参考博客

import json
import csv

def csv_json():

    json_fp = open("02-news.json", "r")
    csv_fp = open("03csv.csv", "w")


    data_list = json.load(json_fp)

    sheet_title = data_list[0].keys()
    # sheet_title = {"姓名","年龄"}  # 将表头改为中文
    sheet_data = []
    for data in data_list:
        sheet_data.append(data.values())

    writer = csv.writer(csv_fp)

    writer.writerow(sheet_title
    writer.writerows(sheet_data)

    json_fp.close()
    csv_fp.close()
    
if __name__ == "__main__":
    csv_json()