uj5u.com熱心網友回復:
這應該作業:
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)]
唯一我不能 100% 確定的是 pd.to_datetime() 但如果它不起作用,你只需要使用它的格式引數。
希望能幫助到你 :)
轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/530346.html
上一篇:熊貓轉換日期
