python json转csv示例

功能说明:
将以下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 pd
import sys

def 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