Python: API request nested dictionaries to dataframe with datetime indexed values-CodePudding

The

CodePudding user response：

this should work:

df = pd.DataFrame() cols = ['Datetime', 'eur/mwh'] # concat days together to one df for day in results['Elements']: # chunk represents a day worth of data to concat chunk = [] date = pd.to_datetime(day['Date']) for pair in day['TimeSpans']: # hour offset is just the first 2 characters of TimeSpan offset = pd.DateOffset(hours=int(pair['TimeSpan'][:1]) value = pair['Value'] chunk.append([(date offset), value]) # concat day-chunk to df df = pd.concat([df, pd.DataFrame(chunk, columns=cols)]

only thing i'm not 100% sure of is the pd.to_datetime() but if it does't work you just need to use a format argument with it.

hope it helps :)