python json转csv示例

来源:互联网 发布:纸黄金行情软件 编辑:程序博客网 时间:2024/05/24 23:15

功能说明:
将以下json文件转为csv文件
json文件:
{“a”:1, “b”:2, “c”:3}
{“a”:11, “b”:22, “c”:33}
{“a”:111, “b”:222, “c”:333}

# -*- coding:utf-8 -*- import pandas as pdimport sysdef json2csv(json_path, json_file, csv_path= None, csv_file=None):    if csv_path is None:        csv_path = json_path    if csv_file is None:        csv_file = json_file.split('.')[0] + '.csv'    file_handler = open(json_path + json_file, "r")    lines = file_handler.readlines()    file_handler.close()    content_list = []    for line in lines:        content_list.append(eval(line))    df = pd.DataFrame(content_list)    df.to_csv(csv_path + csv_file)if __name__ == '__main__':    argv = sys.argv    json2csv(argv[1], argv[2], argv[3], argv[4])

使用示例:
python json2csv.py D:\ a.json D:\ b.csv

0 0
原创粉丝点击