【记录】调取百度地图API获取东京机场群距离

最新推荐文章于 2025-05-23 09:16:47 发布

wangdi_37927

最新推荐文章于 2025-05-23 09:16:47 发布

阅读量381

点赞数

文章标签： python

本文链接：https://blog.youkuaiyun.com/wangdi_37927/article/details/109022025

版权

本文介绍了一种使用Python和百度地图API计算特定区域内机场间非直线路径距离的方法，并通过实例展示了如何构造请求URL、处理响应数据及将结果保存为CSV文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、需求描述

输入信息：机场名字、经纬度

返回：机场间的路径距离矩阵（非直线距离）。

二、代码

import pandas as pd
import requests
import json

df = pd.read_excel(r'东京城市群机场9_ss.xlsx')


import numpy as np


import requests
num = 8;#东京是9个
distance_channel = np.zeros((num,num))
for i in range(num):
    origin = df['lat'][i]  , df['lng'][i]
    n1=df['name'][i]
    for j in range(num):
        if j!=i:
            destination= df['lat'][j],  df['lng'][j]
            n2=df['name'][j]
            url = (f"http://api.map.baidu.com/direction_abroad/v1/driving?origin="
                f"{'%.6f'% origin[0]},{'%.6f'%origin[1]}&destination={'%.6f'%destination[0]},{'%.6f'%destination[1]}&ak=我的AK")#①
            print(url)
            res = requests.get(url)
            jd = res.json()
            print(jd)
            try:
                distance_channel[i][j] = jd['result']['routes'][0]['distance']
            except Exception as e:
                distance_channel[i][j] = -1
            #②
with open('res.csv','w',encoding='utf-8-sig') as f:#③
    print(end=',',file=f)#④
    for i in range(num):
        print(df['name'][i],end=',',file=f)#⑤
    print(file=f)
    for i in range(num):
        print(df['name'][i],end=',',file=f)#⑥
        for j in range(num):
            print(distance_channel[i][j],end=',',file=f)#⑦
        print(file=f)#⑧