我有以下JSON文件:
{"data":
{"success":true,
"timeseries":true,
"start_date":"2022-10-01",
"end_date":"2022-10-04",
"base":"EUR",
"rates":
{"2022-10-01":{"NG":0.1448939471560284},
"2022-10-02":{"NG":0.14487923291390148},
"2022-10-03":{"NG":0.1454857922753868},
"2022-10-04":{"NG":0.1507352356663182}},
"unit":"per MMBtu"}}
我正试图将这个JSON正常化成一个Pandas 数据帧.这就是我try 过的:
import pandas as pd
import json
with open(r'C:\Users\Gio\Desktop\tools\python\acrodata.json','r') as f:
data = json.loads(f.read())
df_flatten = pd.json_normalize(data, record_path =['data']['rates'], meta=['success', 'timeseries', 'start_date','end_date','base'])
print(df_flatten)
我收到以下错误:
TypeError: list indices must be integers or slices, not str