Python 腾讯接口之全球/全国疫情数据获取
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Python 腾讯接口之全球/全国疫情数据获取,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含1947字,纯文字阅读大概需要3分钟。
内容图文
# 全国数据
import json
import requests
import pandas as pd
url_name = 'https://api.inews.qq.com/newsqa/v1/query/inner/publish/modules/list?modules=chinaDayList,chinaDayAddList,nowConfirmStatis,provinceCompare'
html_name = requests.get(url_name)
data_name=json.loads(html_name.text)['data']['provinceCompare']
city = [k for k,v in data_name.items()]
writer = pd.ExcelWriter('全国疫情历史数据.xlsx')
for j in city:
data1=[]
url='https://api.inews.qq.com/newsqa/v1/query/pubished/daily/list?province='+ j
html = requests.get(url)
html.text
data=json.loads(html.text)['data']
for i in data:
data2={}
data2['日期']=str(i['year'])+'年'+i['date'][0:2]+'月'+i['date'][3:5]+'日'
data2['省份']=i['province']
data2['确诊']=i['confirm']
data2['死亡']=i['dead']
data2['治愈']=i['heal']
data2['现有']=data2['确诊'] - data2['治愈'] - data2['死亡']
data2['新增确诊']=i['newConfirm']
data2['新增治愈']=i['newHeal']
data2['新增死亡']=i['newDead']
data1.append(data2)
df=pd.DataFrame(data1)
df.to_excel(writer, sheet_name=j,index=0)
writer.save()
# 全球数据
import json
import requests
import pandas as pd
url_name = 'https://api.inews.qq.com/newsqa/v1/automation/modules/list?modules=FAutoGlobalStatis,FAutoGlobalDailyList,FAutoCountryConfirmAdd'
html_name = requests.get(url_name)
data_name=json.loads(html_name.text)['data']['FAutoCountryConfirmAdd']
FAutoCountry = [k for k,v in data_name.items()]
writer = pd.ExcelWriter('全球疫情历史数据.xlsx')
for j in FAutoCountry:
data1=[]
url='https://api.inews.qq.com/newsqa/v1/automation/foreign/daily/list?country='+ j
html = requests.get(url)
html.text
data=json.loads(html.text)['data']
for i in data:
data2={}
data2['日期']=str(i['y'])+'年'+i['date'][0:2]+'月'+i['date'][3:5]+'日'
data2['确诊']=i['confirm']
data2['死亡']=i['dead']
data2['治愈']=i['heal']
data2['现有']=data2['确诊'] - data2['治愈'] - data2['死亡']
data2['新增确诊']=i['confirm_add']
data1.append(data2)
df=pd.DataFrame(data1)
df.to_excel(writer, sheet_name=j,index=0)
writer.save()
内容总结
以上是互联网集市为您收集整理的Python 腾讯接口之全球/全国疫情数据获取全部内容,希望文章能够帮你解决Python 腾讯接口之全球/全国疫情数据获取所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。