python 读取txt文件通过 高德API获取批量定位坐标，写入到Excel

import requests
import pandas as pd
 
# 定义函数，将单个地址转换为经纬度
def geocode(address):
    url = f"https://restapi.amap.com/v3/geocode/geo?key=key&address={address}"
    
    response = requests.get(url)
    data = response.json()
    
    if data['status'] == '1' and int(data['count']) >= 1:
        location = data['geocodes'][0]['location'].split(',')
        longitude = float(location[0])
        latitude = float(location[1])
        
        return (longitude, latitude)
    else:
        print("无法获得有效的位置信息")
        return None
 
# 从txt文件中逐行读取地址列表
with open('dinhai.txt', 'r') as file:
    addresses = [line.strip() for line in file]
 
# 初始化空白DataFrame
df = pd.DataFrame(columns=["Address", "Longitude", "Latitude"])
 
for address in addresses:
    result = geocode(address)
    if result is not None:
        df = df._append({"Address": address, "Longitude": result[0], "Latitude": result[1]}, ignore_index=True)
 
# 将结果保存到Excel表格
df.to_excel('定海区.xlsx', index=False)
print("处理完成！已生成输出文件 output.xlsx")