import json
import csv #调用数据保存文件
with open(r'data2.txt','r', encoding = 'utf-8') as file_open:
json_data = json.load(file_open)
result = []
for item in json_data['resultset']:
list = []
list.append(item['type'])
list.append(item['code'])
list.append(item['name'])
list.append(item['collegeName'])
list.append(item['assetsSortCode'])
list.append(item['assetsSortGbCode'])
list.append(item['assetsSortGbName'])
list.append(item['averagePrice'])
list.append(item['leijzj'])
list.append(item['priceLeft'])
list.append(item['source'])
list.append(item['stateName'])
list.append(item['useYearFormat'])
list.append(item['depreciationYear'])
list.append(item['purchaseDate'])
list.append(item['stockDates'])
list.append(item['jianzjg'])
list.append(item['jianzmj'])
result.append(list)
with open("data.csv", "a", encoding="gb2312", newline="") as f:
# 2. 基于文件对象构建 csv写入对象
csv_writer = csv.writer(f)
# 3. 构建列表头
name=['类别','编号','名称','所属学院','分类号','财政六大类','财政六大类名称','原值','累计折旧','净值','资产来源',
'现状','已使用年限','最低使用年限','购置日期','入库日期','建筑结构','建筑面积']
csv_writer.writerow(name)
# 4. 写入csv文件内容
for rowItem in result:
csv_writer.writerow(rowItem)
print("写入数据成功")
# 5. 关闭文件
f.close()
元数据格式为json