如何将地理坐标长列表拆分为含纬度、经度列的两个DataFrame？

实现代码 #

import pandas as pd

# 原始地理坐标数据
coordinates = [
    [[31.547836, -103.7842], [31.639685, -104.03722], 
     [32.051894, -104.22097], [32.082813, -104.20363],
     [32.195333, -104.10359], [32.398168, -103.66786],
     [32.224538, -103.48232], [31.977848, -103.28086],
     [31.8019236, -103.30381], [31.688412, -103.482903],
     [31.607474, -103.62303]],
    [[31.582053, -101.93924], [31.585542, -102.16106],
     [31.6131197, -102.24417], [31.661732, -102.2972],
     [32.0562417, -102.28902], [32.4380094, -101.97873],
     [32.438598, -101.94766], [32.435146, -101.83021],
     [32.4000907, -101.78283], [31.905481, -101.73379],
     [31.781019, -101.72468], [31.650047, -101.71616],
     [31.6497171, -101.71621], [31.583703, -101.80637]]
]

# 拆分并转换为DataFrame
df = pd.DataFrame(coordinates[0], columns=['latitude', 'longitude'])
df1 = pd.DataFrame(coordinates[1], columns=['latitude', 'longitude'])

# 查看第一个DataFrame的前几行
print("第一个DataFrame df：")
print(df.head())

# 查看第二个DataFrame的前几行
print("\n第二个DataFrame df1：")
print(df1.head())

输出示例 #

第一个DataFrame df：

latitude  longitude
0  31.547836  -103.78420
1  31.639685  -104.03722
2  32.051894  -104.22097
3  32.082813  -104.20363
4  32.195333  -104.10359

第二个DataFrame df1：

latitude  longitude
0  31.582053  -101.93924
1  31.585542  -102.16106
2  31.613120  -102.24417
3  31.661732  -102.29720
4  32.056242  -102.28902

内容的提问来源于stack exchange，提问作者JEG