imports json
df = pd.read_json("C:/xampp/htdocs/PHP code/APItest.json", orient='records')
print(df)
我想額外創建三列：['name','logo','ico_score']而不是'main'列
我試過了：
df2 = df.join(pd.DataFrame(list(json.loads(d).values())[0] for d in df.pop('main')) )
但得到這個型別錯誤：
the JSON object must be str, bytes or bytearray, not dict
我希望有人可以幫助我找到一種方法，這樣我就可以得到一個用于統計的資料表。最好的問候學生。
這就是我的 json 資料的樣子：
[
{
"id": "126",
"main": {"name": "SONM", "logo": "link", "ico_score": "6.7"},
"links": {"url": "link"},
"finance": {"raised": "42000000"},
},
{
"id": "132",
"main": {"name": "openANX", "logo": "link", "ico_score": "5.7"},
"links": {"url": "link"},
"finance": {"raised": "18756937"},
},
{
"id": "166",
"main": {"name": "Boul\\u00e9", "logo": "link", "ico_score": "5.6"},
"links": {"url": "link"},
"finance": {"raised": ""},
},
]
uj5u.com熱心網友回復：
IIUC 你可以這樣做：
with open('your_json_file.json') as f:
data = json.load(f)
df = pd.json_normalize(data)
df.columns = ['id', 'name', 'logo', 'ico_score', 'url', 'raised']
print(df)
id name logo ico_score url raised
0 126 SONM link 6.7 link 42000000
1 132 openANX link 5.7 link 18756937
2 166 Boul\u00e9 link 5.6 link
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/474515.html
下一篇：總結r中的兩個資料幀