txt 转 json 使用python语言
需求:
把如下的txt文档转成json输出
代码
import json
def txt_to_json(input_file, output_file):
data_list = []
with open(input_file, 'r', encoding='utf-8') as f:
for line in f:
# 分割数据并去除换行符
parts = line.strip().split(',')
print(f"{parts}")
print(type(parts))
# 构造数据字典
record = {
"name": parts[0],
"date": parts[1],
"money": parts[2],
"memo": parts[3]
}
data_list.append(record)
# 写入JSON文件
with open(output_file, 'w', encoding='utf-8') as f:
json.dump(data_list, f, ensure_ascii=False, indent=2)
# 使用示例
txt_to_json('C:/Users/kwok/Desktop/novel/bill.txt', 'C:/Users/kwok/Desktop/novel/output.json')
输出文件如下