我是 Python 的新手，但試圖調用 Google 距離矩陣 API這就是我的數據框的樣子將數據加載到數據框中data = pd.read_csv(input_filename, encoding ='utf8')我只需要一些幫助來循環列表。問題：它不斷打印整個列表#Column name in your input datastart_latitude_name = "Start Latitude"start_longitude_name = "Start Longitude"end_latitude_name = "End Latitude"end_longitude_name = "End Longitude"start_latitude_names = data[start_latitude_name].tolist()end_latitude_names = data[end_latitude_name].tolist()start_longitude_names = data[start_longitude_name].tolist()end_longitude_names = data[end_longitude_name].tolist()for start_latitude_name in start_latitude_names: origins = start_latitude_name, start_longitude_name destinations = end_latitude_name, end_longitude_name mode = "walking" # Set up your distance matrix url distancematrix_url = "*Omitted unnecessary parts*origins={0}&destinations={1}&mode={2}&language=en-EN&key={3}".format(origins, destinations, mode, API_KEY) print(distancematrix_url)電流輸出（來自每個回路）# Omitted unnecessary infoorigins=40.7614645,123.0,-73.9825913,456.0&destinations=40.65815,789.0,-73.98283,0.0預期輸出（來自每個循環）origins=40.7614645,-73.9825913&destinations=40.65815,-73.98283我確定我沒有正確循環它，但是我已經在幾個帖子中嘗試了答案，但它對我不起作用。我愿意接受更好的循環數據替代方案。隨時糾正我。
2 回答
長風秋雁
TA貢獻1757條經驗 獲得超7個贊
如果我理解正確，您可以矢量化此操作并使用坐標的字符串表示形式：
import pandas as pd
# Make pandas print entire strings without truncating them
pd.set_option("display.max_colwidth", -1)
# Create dummy-df from your example
df = pd.DataFrame({"start_latitude": [40.76, 123.00], "start_longitude": [-73.98, 456.00], "end_latitude": [40.65, 789.00], "end_longitude": [-73.98, 0.00]})
print df
# Set globals
mode = "walking"
API_KEY = "my_key"
# Create the url strings for each row
df["distance_matrix_url"] = "origins=" + df["start_latitude"].map(str) + "," + df["start_longitude"].map(str) + "&destinations=" + df["end_latitude"].map(str) + "," + df["end_longitude"].map(str) + "&mode=" + mode + "&languge=en-EN&key=" + API_KEY
# Print results
print df
輸出：
end_latitude end_longitude start_latitude start_longitude distance_matrix_url
0 40.65 -73.98 40.76 -73.98 origins=40.76,-73.98&destinations=40.65,-73.98&mode=walking&languge=en-EN&key=my_key
1 789.00 0.00 123.00 456.00 origins=123.0,456.0&destinations=789.0,0.0&mode=walking&languge=en-EN&key=my_key
這是你要找的嗎？
添加回答
舉報
0/150
提交
取消