import csv
import json
file = open('../test1.csv','r',encoding='utf-8')
file2 = open('test1.csv', 'w', encoding='utf-8')
city = csv.DictReader(file)
for i in city:
d = {}
for k,v in i.items():
d[k]=v
jsongeshi=json.dumps(d,indent=4,ensure_ascii=False)
print(jsongeshi)
file2.write(jsongeshi)
file2.close()
具体读入的csv文件的格式为:
城市,环比,同比,定基 北京,101.5,120.7,121.4 上海,101.2,127.3,127.8 广州,101.3,119.4,120 深圳,102,140.9,145.5 沈阳,100.1,101.4,101.6
转换成为的json文件格式为:
{ "城市": "北京", "环比": "101.5", "同比": "120.7", "定基": "121.4" }{ "城市": "上海", "环比": "101.2", "同比": "127.3", "定基": "127.8" }{ "城市": "广州", "环比": "101.3", "同比": "119.4", "定基": "120" }{ "城市": "深圳", "环比": "102", "同比": "140.9", "定基": "145.5" }{ "城市": "沈阳", "环比": "100.1", "同比": "101.4", "定基": "101.6" }