我的數(shù)據(jù)框在單列（coordinates）中包含緯度、經(jīng)度和海拔高度，我想將coordinates列分成三列（緯度、經(jīng)度和海拔高度）。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預(yù)期輸出：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我嘗試過的：我嘗試首先根據(jù):基礎(chǔ)拆分列，但它不起作用：df.loc[df['Coordinates'].isin(["latitude_degrees", "longitude_degrees"])]= ""我也嘗試替換文本，但它不起作用：df.Coordinates.replace(to_replace=['latitude_degrees','longitude_degrees'],value='')
1 回答
縹緲止盈
TA貢獻(xiàn)2041條經(jīng)驗 獲得超4個贊
讓我們使用從列中extractall提取lat,long和，然后對其進(jìn)行重塑，最后使用列和：altCoordinatesunstackjoinIDRegion
c = df['Coordinates'].str.extractall(r'([\d.]+)')[0].unstack()
d = df[['ID', 'Region']].join(c.set_axis(['lat', 'long', 'alt'], 1))
? ?ID? Region? ? ? ? ? ? ? ? lat? ? ? ? ? ? ? ? long? ? ? ? ? ? ? ? ?alt
0? ?1? Europe? 52.00755721100514? 12.565129548994266? 185.23616827199143
1? ?2? Europe? 52.00755721100514? 12.565129548994266? 185.23616827199143
2? ?3? Europe? 52.00755721100514? 12.565129548994266? 185.23616827199143
3? ?4? Europe? 52.00755721100514? 12.565129548994266? 185.23616827199143
4? ?5? Europe? 52.00755721100514? 12.565129548994266? 185.23616827199143
添加回答
舉報
0/150
提交
取消