1 回答

TA贡献2041条经验 获得超4个赞
让我们使用从列中extractall
提取lat
,long
和,然后对其进行重塑,最后使用列和:alt
Coordinates
unstack
join
ID
Region
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
添加回答
举报