import jsonimport pprint # 格式化输出模块from msilib.schema import tablesfrom typing import Dictimport pandas as pd # 数据分析模块import requests # 发送第三方请求模块import xlwturl = 'https://view.inews.qq.com/g2/getOnsInfo?name=disease_h5&_=1640585046650%27# 发送请求response = requests.get(url=url)# 获取数据 获取json数据data_json = response.json()# 解析数据 筛选数据data = data_json['data']# 字符变字典data = json.loads(data)china_data = data['areaTree'][0]['children']# 构建一个列表存储数据data_set = []for i in china_data: data_dict = {} data_dict['province'] = i['name'] # 省份 data_dict['nowConfirm'] = i['total']['nowConfirm'] # 新增病例 data_dict['confirm'] = i['total']['confirm'] # 累计确诊 data_dict['dead'] = i['total']['dead'] # 死亡人数 data_dict['heal'] = i['total']['heal'] # 治愈人数 data_dict['healRate'] = i['total']['healRate'] # 治愈率 data_dict['deadRate'] = i['total']['deadRate'] # 死亡率 data_set.append(data_dict) print(data_set) # 保存数据def export_excel(data_set): pf = pd.DataFrame(list(data_set)) order = ['province', 'nowConfirm', 'confirm', 'dead', 'heal', 'healRate', 'deadRate'] pf = pf[order] columns_map: dict[str, str] = { 'province': '省份', 'nowConfirm': '新增病例', 'confirm': '累计确诊', 'dead': '死亡人数', 'heal': '治愈人数', 'healRate': '治愈率', 'deadRate': '死亡率' } pf.rename(columns=columns_map, inplace=True) file_path = pd.ExcelWriter('name.xlsx') # 替换空单元格 pf.fillna(' ', inplace=True) # 输出 pf.to_excel(file_path, encoding='utf-8', index=False) # 保存表格 file_path.save()
写成dataframe形式，直接用to_csv或者to_excel即可，代码运行中有什么具体问题呢？
您这个问题堆了一堆怎么解答