python脚本未编码为utf-8

Question

我有这个Python 3脚本来读取json文件并另存为csv。除了特殊字符以外，它都可以正常工作\u00e9。因此Montr\u00e9al应编码为Montréal，但它却给了我Montréal。import jsonifilename = '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 = 0for l in json_lines:    root.writerow([l["business_id"],l["name"],l["neighborhood"],l["address"],l["city"],l["state"]])    json_no += 1print('Finished {0} lines'.format(json_no))OUT_FILE.close()

Answer 1

事实证明，使用Notepad ++（而不是Excel）打开csv文件时，其显示正确。因此，我不得不使用Excel导入csv文件并指定65001：Unicode（UTF-8）。谢谢您的帮助。