我有一個如下所示的資料集
Datetime Message
0 2021-12-20 09:50:08.819 Current sidewing pressure: 3362
1 2021-12-20 09:50:08.820 Current sidewing pressure: 3303
2 2021-12-20 09:50:08.839 Current sidewing pressure: 3398
3 2021-12-20 09:50:08.839 Current sidewing pressure: 3279
4 2021-12-20 09:50:08.860 Current sidewing pressure: 3398
5 2021-12-20 09:50:08.860 Current sidewing pressure: 3303
6 2021-12-20 09:50:08.879 Current sidewing pressure: 3303
我正在嘗試將這些值交替分配給名為 Left 和 Right 的兩個新列。
如下
Datetime Message Left Right
0 2021-12-20 09:50:08.819 Current sidewing pressure: 3362 3362
1 2021-12-20 09:50:08.820 Current sidewing pressure: 3303 3303
2 2021-12-20 09:50:08.839 Current sidewing pressure: 3398 3398
3 2021-12-20 09:50:08.839 Current sidewing pressure: 3279 3279
4 2021-12-20 09:50:08.860 Current sidewing pressure: 3398 3398
5 2021-12-20 09:50:08.860 Current sidewing pressure: 3303 3303
6 2021-12-20 09:50:08.879 Current sidewing pressure: 3303 3303
有沒有辦法做到這一點？
uj5u.com熱心網友回復：
您可以使用iloc[::2]提取所有其他值（::2對于偶數索引值和1::2奇數索引值）并分配給一列：
vals = df.Message.str.extract('(\d )$')
df['Right'] = vals.iloc[::2]
df['Left'] = vals.iloc[1::2]
df
Datetime Message Right Left
0 2021-12-20 09:50:08.819 Current sidewing pressure: 3362 3362 NaN
1 2021-12-20 09:50:08.820 Current sidewing pressure: 3303 NaN 3303
2 2021-12-20 09:50:08.839 Current sidewing pressure: 3398 3398 NaN
3 2021-12-20 09:50:08.839 Current sidewing pressure: 3279 NaN 3279
4 2021-12-20 09:50:08.860 Current sidewing pressure: 3398 3398 NaN
5 2021-12-20 09:50:08.860 Current sidewing pressure: 3303 NaN 3303
6 2021-12-20 09:50:08.879 Current sidewing pressure: 3303 3303 NaN
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/399110.html