在此处上传CSV文件API使用Python进行批量地理编码

import csv
from geopy.geocoders import Nominatim

# 读取CSV文件
with open('data.csv', 'r') as file:
    reader = csv.reader(file)
    addresses = [row[0] for row in reader]

# 初始化地理编码器
geolocator = Nominatim(user_agent='my_app')

# 批量地理编码
results = []
for address in addresses:
    location = geolocator.geocode(address)
    if location:
        results.append({
            'address': address,
            'latitude': location.latitude,
            'longitude': location.longitude
        })

# 将结果写入CSV文件
with open('results.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(['Address', 'Latitude', 'Longitude'])
    for result in results:
        writer.writerow([result['address'], result['latitude'], result['longitude']])