Python script to query web API and generate charts in R

In Progress

My goal is to develop and maintain a database of energy data from the U.S. Energy Information Administration (EIA). The EIA has an API ([url removed, login to view]) allowing developers to easily access their data.

Here's a specific example I have in mind. The Python script would query EIA's website and get data for the following series:

*Monthly net generation for Colorado (ELEC.GEN.ALL-CO-99.M)

*Monthly net generation from coal for Colorado (ELEC.GEN.COW-CO-99.M)

*Monthly net generation from natural gas for Colorado (ELEC.GEN.NG-CO-99.M)

*Monthly net generation from hydroelectric for Colorado (ELEC.GEN.HYC-CO-99.M)

*Monthly net generation for all other renewables for Colorado (ELEC.GEN.AOR-CO-99.M)

The script would compare the data from EIA with a local PostgreSQL database and update the local database if necessary. This could be done by directly comparing the data, or by checking the "last updated" time stamp EIA has for each data series. (Using the SQLAlchemy library to interface with Postgres would be preferred.)

After updating the local database, a dialog would pop up allowing the user to select which data series to chart and allowing the user to choose the time window for the data (e.g., Jan 2005 to Mar 2011).

Based on the simple user input, the script would query the data from the PostgreSQL database, interface with R, and produce the charts using ggplot2. (Likely this will involve the use of the "pandas" python library and a library like "PypeR" or "rpy2".) In the example above, I would like to see time series charts for each of the series and then a stacked area chart for coal, natural gas, hydro, and all other renewables.

I would appreciate clearly-organized, well-documented code as I will have to maintain and modify the code to fit specific needs. Thanks!

Skills: PostgreSQL, Python, R Programming Language

See more: python web query, python rpy2 chart example, web query python, chart web api python, rpy2 pyper, python pandas pyper, eia data python, python website query, example use python script eia, postgresql python pandas, rpy2 pandas, python query website, www web developers, website to get web developers, web interface for postgresql, web develop on python, web developer python, web developer local, script developers, postgresql r, local web developers, colorado access, api developers, net gen, postgresql developer

Project ID: #4854002

Awarded to:


I'm able to code this thing for you. The API seems strightforward. I have experience with graphing in R. I'm new here, so I'm offering a discount. I'm looking forward to working with you.

$277 USD in 7 days
(0 Reviews)

12 freelancers are bidding on average $729 for this job


Hi. Interesting and challenging project for me. I would like to be involved.

$631 USD in 3 days
(10 Reviews)

I can do it.

$421 USD in 5 days
(29 Reviews)

Hi, ready to assist u. check pm.

$3157 USD in 30 days
(3 Reviews)

Let's start.

$499 USD in 7 days
(13 Reviews)

I can do that professional

$555 USD in 3 days
(9 Reviews)

You certainly seem to have a clear idea of what you want. Getting the data using the EIA API and keeping the PostgreSQL database in sync should be easy, not sure why you want to use SQLAlchemy rather than using psycopg More

$300 USD in 15 days
(1 Review)

i can make this app , can work with their api.

$444 USD in 8 days
(2 Reviews)

Dear Sir, I am interested in this project and can make an app to create charts by querying their api. Thanks and regards

$555 USD in 3 days
(1 Review)

I'd give it a whirl.

$444 USD in 15 days
(1 Review)

Nice project, requires both Statistics and Computer Science. My two favorite fields! I am going to send you a private message. Romain.

$722 USD in 7 days
(1 Review)

Hi, We have expert in-house team of Python programmers. Please check private message.

$747 USD in 24 days
(0 Reviews)