新冠病毒数据分析(2)----JSON格式数据写入CSV文件

1、原始数据

网上直接获取的JSON格式文件  

2、json文件读取

  def read_data(path):     data=pd.read_json(path)     return data   返回dataframe格式  

3、生成文件

生成country.csv文件，并写入列名   with open('country.csv', 'a+',newline='') as csvfile:         fieldnames = ['country', 'confirmed','deaths','recovered','date']         writer = csv.DictWriter(csvfile, fieldnames=fieldnames)         writer.writeheader()  

4、写入数据

for country in data1.columns:             for i in range(0, len(data1[country].index)):                         writer.writerow({"country": country, "confirmed": int(data1[country][i]['confirmed']),"deaths":int(data1[country][i]['deaths']),\                          "recovered":int(data1[country][i]['recovered']),"date":data1[country][i]['date']})   country代表"国家名"、data1[country][i]['confirmed']代表当天确诊病例、data1[country][i]['deaths']代表当天死亡病例、data1[country][i]['recovered'],代表当天治愈病例、 data1[country][i]['date']代表当天日期。   存储每个国家每日确诊、死亡和治愈病例