import pandas as pd
gz_data=pd.DataFrame(data)
# 保存为csv文件,指定换行符为|
# gz_data.to_csv('guangzhou.csv', sep='|', index=False, line_terminator='|\\r\\n')
# 将DataFrame转换为JSON字符串
json_str = gz_data.to_json(orient='records')
# 将JSON字符串写入到本地文件中
with open('wulumuqi.json', 'w',encoding='utf-8') as f:
f.write(json_str)
import json
import pandas as pd
with open('guangzhou.json') as f:
data = json.load(f)
df = pd.DataFrame(data)
df.head(1)
问chatgpt的答案,记录一下。