1. # -*- coding:utf-8 -*-
    2. import pandas as pd
    3. import collections, json
    5. area_data = pd.read_csv('all.csv', encoding='utf8', sep=',')  # gb18030
    6. print(area_data.head())
    7. indicator = area_data.columns[1:5].tolist()
    8. print(indicator)
    9. f = open("all.json", "w+", encoding='utf-8')
    10. for i in range(len(area_data)):
    11.     area_dict = collections.OrderedDict()  # 利用OrderedDict()建立有序词典
    12.     area_dict['question'] = str(area_data.loc[i, 'question'])
    13.     area_dict['answer'] = str(area_data.loc[i, 'answer'])
    14.     # area_dict['lat'] = str(area_data.loc[i, '经度'])
    15.     area_dict['options'] = indicator
    16.     value_list = area_data.iloc[i, 1:5].tolist()
    17.     value_list_new = [str(x) for x in value_list]
    18.     # value_list.append(area_data.iloc[i, 1:4].tolist().astype(str))
    19.     value_list.append(area_data.iloc[i, 1:5].tolist())
    20.     area_dict['values'] = value_list_new
    21.     # f.writelines(json.dumps(area_dict, ensure_ascii=False) + '\n')
    22.     f.write(json.dumps(area_dict, ensure_ascii=False) + '\n')
    23.     # f.writelines(json.dumps(area_dict, ensure_ascii=False, indent=4) + ',\n')
    24. f.close()  # 将文件关闭
    25. # 使用json模块将构造好的字典保存到文件中
    26. # area_dict.encode("utf-8")