如何解决错误：谷歌地图API结果的"Length of values does not match length of index"

Question

我正在使用谷歌地图API收集距离数据，很可能不是所有位置都能检索到距离信息，所以我得到了一个错误"；ValueError：值的长度与索引的长度不匹配；。有什么技巧可以更新代码来修复它吗？

lat_origin = df["lat1"].tolist()
long_origin = df["lon1"].tolist()
lat_destination = df["lat2"].tolist()
long_destination = df["lon2"].tolist()
distance = []
for i in range(len(long_destination)):
url = f"https://maps.googleapis.com/maps/api/distancematrix/json?units=metric&origins={lat_origin[i]},{long_origin[i]}&destinations={lat_destination[i]}%2C{long_destination[i]}&key={google_key}&channel={channel_id}"
r=requests.get(url)
data = r.json()
try:
distance.append(data['rows'][0]['elements'][0]['distance']['value'])
except:
pass
distance
distance2 = []
for i in range(len(distance)):
distance2.append(distance[i])
df["Distance_in_Meters"] = distance2

Answer 1

您可以这样做，将NA值附加到您的列表中

import numpy as np
import pandas as pd
l = [1,2,3]
# Need to convert all the elements in list to float as NAN does not have 
# equivalent Int value in Pandas. 
l = list(map(lambda x: float(x), l))
right_padding = len(df) - len(l)
left_padding = 0
arr = np.pad(l, pad_width=(left_padding, right_padding), mode='constant', 
constant_values=(np.nan,))
print(arr)
df['B'] = arr