如何将两个坐标列转换为一列 Shapely 点

2024-02-27

我正在尝试对整个列执行操作,但出现类型错误,我想创建一个包含匀称点 https://shapely.readthedocs.io/en/latest/manual.html#points:

crime_df = crime_df[crime_df['Latitude'].notna()]
crime_df = crime_df[crime_df['Longitude'].notna()]

crime_df['Longitude'] = crime_df['Longitude'].astype(float)
crime_df['Latitude'] = crime_df['Latitude'].astype(float)

print (crime_df['Longitude'])
print (crime_df['Latitude'])

crime_df['point'] = Point(crime_df['Longitude'], crime_df['Latitude'])

Output:

18626    -87.647379
Name: Longitude, Length: 222, dtype: float64

18626    41.781100
Name: Latitude, Length: 222, dtype: float64

TypeError: cannot convert the series to <class 'float'>

我认为你需要分别处理每一点,所以需要DataFrame.apply http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.apply.html使用 lambda 函数:

crime_df['point'] = crime_df.apply(lambda x: Point(x['Longitude'], x['Latitude'], axis=1)

或者谢谢@N。沃达:

crime_df["point"] = crime_df[["Longitude", "Latitude"]].apply(Point, axis=1)

或者列表理解替代方案是:

crime_df['point'] = [Point(lon, lat) 
                                 for lon, lat in crime_df[['Longitude','Latitude']].values]

编辑:我认为矢量化方式是可以使用的geopandas.points_from_xy https://geopandas.readthedocs.io/en/latest/gallery/create_geopandas_from_pandas.html like:

gdf = geopandas.GeoDataFrame(df,geometry=geopandas.points_from_xy(df.Longitude,df.Latitude))
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

如何将两个坐标列转换为一列 Shapely 点 的相关文章

随机推荐