一、excel文件数据形式
二、代码
1.引入库
代码如下(示例):
import pandas as pd
import json,os
def To_Json(file_path,save_path):
data = pd.read_excel(file_path)
lists = []
for i in range(len(data)):
dicts = {}
dicts['时间'] = data['时间'][i]
dicts['地点'] = data['地点'][i]
dicts['目标'] = data['目标'][i]
dicts['行为'] = data['行为'][i]
lists.append(json.dumps(dicts,ensure_ascii=False))
if os.path.exists(save_path):
os.remove("save_path")
with open(save_path, "w") as fp:
fp.write(str(lists))
if __name__ == '__main__':
file_path = r'C:\Users\22846\Desktop\Test.xlsx'
save_path = r'C:\Users\22846\Desktop\Test.txt'
To_Json(file_path,save_path)