Python 无嵌套json文件转csv文件

import csv
import json
import jsonpath
import pandas as pd

#正常的文件

json_file = open(r'C:\Users\ellzhang\Desktop\test1.json', 'r', encoding='utf_8')
csv_file = open(r'C:\Users\ellzhang\Desktop\my1.csv', 'w', newline='',encoding='utf_8_sig')
keys = []
writer = csv.writer(csv_file)

json_data = json_file.read() #str
dic_data = json.loads(json_data, encoding='utf_8_sig') # list

for dic in dic_data:
    #print(type(dic)) dict
    keys = dic.keys()

    # 写入列名
    writer.writerow(keys)
    break

for dic in dic_data:
    for key in keys:
        if key not in dic:
            dic[key] = ''
        #替换掉字段中的换行符
        if dic[key] != None :
            dic[key]=str(dic[key]).replace("\n","")
        
    writer.writerow((dic.values()))