Python将json文件写入csv文件中

#-*- coding: utf-8
import json
import csv
names = ['joker','joe','nacy','timi']
json_file = open('./get.json','r')
csv_file = open('./aaa.csv','w')
# 3. 取出数据 : 1.表头 2. 内容
json_list = json.load(json_file)
# 3.1获取表头所需要的数据
sheet_title = json_list[0].keys()
# 3.2 取所有内容
json_values = []
for dict in json_list:
        json_values.append(dict.values())
# 4.1根据文件对象  生成读写器
csv_writer = csv.writer(csv_file)
# 4.2 写入表头
csv_writer.writerow(sheet_title)
# 4.3 写入内容
csv_writer.writerows(json_values)
# 5.关闭文件
csv_file.close()
json_file.close()

[
    {
        "firstName": "Bill",
        "lastName": "Gates"
    },
    {
        "firstName": "George",
        "lastName": "Bush"
    },
    {
        "firstName": "Thomas",
        "lastName": "Carter"
    }
]