Pandas把JSON读入Ex

Question

我试图从一个URL解析JSON数据。我已经获取数据并将其解析为数据帧。从外表看，我少了一步。在

数据在excel中以JSON格式返回，但我的数据框返回两列：entry number和JSON Text

import urllib.request
import json
import pandas
with urllib.request.urlopen("https://raw.githubusercontent.com/gavinr/usa-
mcdonalds-locations/master/mcdonalds.geojson") as url:
data = json.loads(url.read().decode())
print(data)
json_parsed = json.dumps(data)
print(json_parsed)

df=pandas.read_json(json_parsed)
writer = pandas.ExcelWriter('Mcdonaldsstorelist.xlsx')
df.to_excel(writer,'Sheet1')
writer.save()

Answer 1

我相信您可以使用json_normalize：

df = pd.io.json.json_normalize(data['features'])

---

^{pr2}$