python-3.x 使用多个条件拆分Pandas Dataframe 的列

ezykj2lf 于 2022-12-15 发布在 Python

关注(0)|答案(2)|浏览(154)

Let's say I have this column in Pandas:
df['GPS'][0]: 0 '39.21,38.6;39.23,38.68;39.26,38.68'
I would like to split the column into:

Xcoord1 Ycoord1 Xcoord2,Ycoord2, Xcoord3, Ycoord3
37.21    38.6    37.23   38.68    37.26    38.68

My approach is to first split the column using:
df['GPS_list']=df['GPS'].apply(lambda x: x.split(';'))
df['GPS_list']:
['39.21,38.6','39.23,38.68','39.26,38.68']
Now I would need to split based on , to separate the x and y value which I am not sure how to do for each row. Can I use apply function work here?
Next, I would need to convert each of those values from string to int.
Is there an elegant way to do this in a step or two?
I am new to Python and Pandas so any nudge in the right direction is helpful.

python-3.x

来源：https://stackoverflow.com/questions/74776778/splitting-a-column-of-a-pandas-dataframe-using-multiple-conditions

2条答案

按热度按时间

dm7nw8vv1#

It If you always have the same number of coordinates, a simple str.split will work:

out = (df['GPS'].str.split('[,;]', expand=True)
       .set_axis(['Xcoord1', 'Ycoord1',  'Xcoord2', 'Ycoord2', 'Xcoord3', 'Ycoord3'], axis=1)
      )

If you have an arbitrary number of pairs, you can use:

out = (df['GPS'].str.split(';', expand=True).stack()
       .str.split(',', expand=True)
       .set_axis(['Xcoord', 'Ycoord'], axis=1).unstack()
       .sort_index(level=1, axis=1)
      )

out.columns = out.columns.map(lambda x: f'{x[0]}{x[1]+1}')

Output:

Xcoord1 Ycoord1 Xcoord2 Ycoord2 Xcoord3 Ycoord3
0   39.21    38.6   39.23   38.68   39.26   38.68

赞(0）回复(0）举报 2022-12-15

nfs0ujit2#

Example

df = pd.DataFrame(['39.21,38.6;39.23,38.68;39.26,38.68'], columns=['GPS'])

df

GPS
0   39.21,38.6;39.23,38.68;39.26,38.68

Code

col1 = ['Xcoord1', 'Ycoord1', 'Xcoord2', 'Ycoord2', 'Xcoord3', 'Ycoord3']
df['GPS'].str.split(r'[,;]', expand=True).set_axis(col1, axis=1)

result :

Xcoord1 Ycoord1 Xcoord2 Ycoord2 Xcoord3 Ycoord3
0   39.21   38.6    39.23   38.68   39.26   38.68

赞(0）回复(0）举报 2022-12-15

我来回答

python-3.x 使用多个条件拆分Pandas Dataframe 的列

2条答案

相关问题

热门标签

最新问答