本篇博客将实现国内疫情数据地图
爬取数据
import requests
import json
china_url="https://view.inews.qq.com/g2/getOnsInfo?name=disease_h5"
headers={
"User-Agent":"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36",
"Referer":"https://news.qq.com/"
}
response=requests.get(url=china_url,headers=headers).json()
data=json.loads(response['data'])
print(response)
with open('./国内疫情.json','w') as f:
f.write(json.dumps(data,ensure_ascii=False,indent=2))
将json数据保存到excel中
import pandas as pd
import json
with open("./国内疫情.json",'r',encoding="utf-8") as f:
data=f.read()
data=json.loads(data)
chinaAreaDict=data['areaTree'][0]
provinceList=chinaAreaDict['children']
china_citylist=[]
for x in range(len