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": ""},
},
]