gpt-3.5-turbo-0301· OpenAI WildChat-4.8M (AI2)
以下是获取上海各地铁站经纬度的代码,需要使用 requests 和 pandas 库:
import requests
import pandas as pd
url = 'https://shanghaicity.openservice.kankanews.com/public/bus/metroStationInfo.json'
response = requests.get(url).json()
stations = response['data']
data = []
for station in stations:
name = station['name']
lon = float(station['longitude'])
lat = float(station['latitude'])
data.append([name, lon, lat])
df = pd.DataFrame(data, columns=['name', 'longitude', 'latitude'])
df.to_csv('shanghai_metro_stations.csv', index=False)
上述代码将对上海所有地铁站的经纬度数据获取后保存为 CSV 文件。
2 turns totalFull conversation →