python - 复制 Pandas 数据框中的行

Question

我试图找到一种简单的方法来分解以下数据框:

COL_A COL_B COL_C COL_D
VAL1  VAL2  VAL3  OFFER1|OFFER2|OFFER3

到

 COL_A COL_B COL_C COL_D COL_Y
 VAL1  VAL2  VAL3  ...   OFFER1
 VAL1  VAL2  VAL3  ...   OFFER2
 VAL1  VAL2  VAL3  ...   OFFER3

Answer 1

让我们使用 pd.concat、str.split 和 fillna:

pd.concat([df,df.COL_D.str.split('|',expand=True).T],axis=1).rename(columns={0:'COL_Y'}).fillna(method='ffill')

输出:

  COL_A COL_B COL_C                 COL_D   COL_Y
0  VAL1  VAL2  VAL3  OFFER1|OFFER2|OFFER3  OFFER1
1  VAL1  VAL2  VAL3  OFFER1|OFFER2|OFFER3  OFFER2
2  VAL1  VAL2  VAL3  OFFER1|OFFER2|OFFER3  OFFER3