Value extraction from a python dataframe [ problem statement specific ]
The problem with your code is that it considers the numerics as column names ie., 0,1,2,3, etc., upto 31 rows and 24 hours column  but u must loop through each of the column name value which is stored as dictionary so u need two looping:


This loops and creates a new list which stores each and every attribute of the json 
This adds the attributes to the DataFrame
now perform your operation at this dataframe you might get an answer


Google drive shared location of edited ipython notebook