Python通过高德地图API批量获取目的地天气情况

也是之前的公司需求，放上来记录一下。

import pandas as pd
import requests
import json

AK = "*******"   #你自己注册获取的key

def getWeather(place):
    url = f"https://restapi.amap.com/v3/weather/weatherInfo?city={place}&extensions=base&key={AK}"  # 高德地图extension=all可以查询预报天气
    res = requests.get(url)
    json_data = json.loads(res.text)

    if json_data["status"] == "1":       #这里有个坑，注意1是string
        return int(json_data["lives"][0]["temperature"]), int(json_data["lives"][0]["humidity"]), json_data["lives"][0]["reporttime"]     #实况天气每小时更新多次,预报天气每天更新3次，分别在8、11、18点左右更新。还有风速等数据，根据自己需要提取
    else:
        return "no data", json_data["info"], json_data["infocode"]


if __name__ == "__main__":
    data = pd.read_excel("place.xlsx")
    result = []
    for i in range(0,len(data)):
        place = data.iloc[i,0]
        temperature, humidity, time = getWeather(place)
        result.append([place, temperature, humidity, time])
    pd.DataFrame(result).to_excel(
        "result.xlsx",
        header=["地点", "温度", "湿度", "更新时间"],
        encoding="utf-8"
    )