我有一个数据框架,它在单个列(coordinates
)中包含纬度、经度和海拔,我想将coordinates
列拆分为三列(纬度、经度和海拔)
df:
ID Coordinates Region
1 latitude_degrees: 52.00755721100514\nlongitude_degrees: 12.565129548994266\naltitude_meters: 185.23616827199143\n Europe
2 latitude_degrees: 52.00755721100514\nlongitude_degrees: 12.565129548994266\naltitude_meters: 185.23616827199143\n Europe
3 latitude_degrees: 52.00755721100514\nlongitude_degrees: 12.565129548994266\naltitude_meters: 185.23616827199143\n Europe
4 latitude_degrees: 52.00755721100514\nlongitude_degrees: 12.565129548994266\naltitude_meters: 185.23616827199143\n Europe
5 latitude_degrees: 52.00755721100514\nlongitude_degrees: 12.565129548994266\naltitude_meters: 185.23616827199143\n Europe
预期产出:
ID lat lon alt Region
1 52.00755721100514 12.565129548994266 185.23616827199143 Europe
2 52.00755721100514 12.565129548994266 185.23616827199143 Europe
3 52.00755721100514 12.565129548994266 185.23616827199143 Europe
4 52.00755721100514 12.565129548994266 185.23616827199143 Europe
5 52.00755721100514 12.565129548994266 185.23616827199143 Europe
我尝试的是:
我试图首先在:
的基础上拆分列,但它不起作用:
df.loc[df['Coordinates'].isin(["latitude_degrees", "longitude_degrees"])]= ""
我还试图替换文本,但它不起作用:
df.Coordinates.replace(to_replace=['latitude_degrees','longitude_degrees'],value='')
让我们使用^{} 从
Coordinates
列中提取lat
、long
和alt
,然后unstack
对其进行重塑,最后join
使用ID
和Region
列对其进行重构:相关问题 更多 >
编程相关推荐