我有这个Python3脚本来读取json文件并另存为csv。它工作得很好,除了像\u00e9
这样的特殊字符。所以Montr\u00e9al
应该像Montréal
一样编码,但是它给了我Montréal
。
import json
ifilename = 'business.json'
ofilename = 'business.csv'
json_lines = [json.loads( l.strip() ) for l in open(ifilename).readlines() ]
OUT_FILE = open(ofilename, "w", newline='', encoding='utf-8')
root = csv.writer(OUT_FILE)
root.writerow(["business_id","name","neighborhood","address","city","state"])
json_no = 0
for l in json_lines:
root.writerow([l["business_id"],l["name"],l["neighborhood"],l["address"],l["city"],l["state"]])
json_no += 1
print('Finished {0} lines'.format(json_no))
OUT_FILE.close()
https://stackoverflow.com/questions/51662228
复制相似问题