python爬取某城市气温数据，显示这线图并导出Excel

bixuehua

于 2024-09-04 15:19:21 发布

阅读量552

点赞数 3

文章标签： python excel 开发语言 pandas plotly

本文链接：https://blog.csdn.net/bixuehua/article/details/141894736

版权

import json
import requests
import pandas as pd
import re
import numpy as np
from matplotlib import pyplot as plt
from datetime  import  datetime

months = [1,2,3,4,5,6,7,8,9,10,11,12]
years = [2023,2024]
# citys = [60813]
citys = [57328]
citysName =["四川达州"]
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36',
}
index_ = ['MaxTemp','MinTemp', 'WindDir', 'Wind', 'Weather','Aqi','AqiInfo','AqiLevel']  # 选取的气象要素
data = pd.DataFrame(columns=index_)  # 建立一个空dataframe
maxTemps,minTemps ,Dates  = [],[],[]
for c in citys:
    for y in years:
        for m in months:
            # 找到json格式数据的url
            if (y<2017) or (y==2017)&(m<=12):
                url = "http://tianqi.2345.com/t/wea_history/js/"+str(c)+"_"+str(y)