在分隔符上拆分数据帧列并保留所有其他列

Question

下面是“原始输入”数据帧。如果你看“摘要”栏。有一个 分隔符“：”我希望在其上创建两个附加列，并将其附加到现有数据帧

我想把“总结”一栏分成两栏（“工作 包和任务）

我可以使用下面的命令拆分分隔符。但我不知道如何将其附加/合并回现有的数据帧

split_data = pd.DataFrame(raw_input['Summary'].str.split(':',1).tolist(),columns=['Work Package','Task'])

print(raw_input)

         Key                                     Summary       Status                                        Description     Updated
0  XTBOW-310  Data Mgmt: Product Assesment and Selection  In Analysis  - To establish a provider for the solution of ...  2017-05-26
1  XTBOW-420       Data Mgmt: Vendor > CIBC Implemention          NaN  - Integrate with Vendor to fetch Corporate Act...  2017-05-19
2  XTBOW-421             Trade Migration: PVs and Greeks          NaN  - PVs and Greeks regression gap analysis betwe...  2017-05-19
3  XTBOW-422       Trade Migration: Reports (XTC vs XT2)          NaN                                                NaN  2017-05-19



print(split_data)

      Work Package                              Task
0        Data Mgmt   Product Assesment and Selection
1        Data Mgmt        Vendor > CIBC Implemention
2  Trade Migration                    PVs and Greeks
3  Trade Migration              Reports (XTC vs XT2)

Answer 1

有一种更简单的方法：

In [11]: df[['Work Package','Task']] = df['Summary'].str.split(':',1, expand=True)

In [12]: df
Out[12]:
         Key                                     Summary                                             Status Description  Updated  \
0  XTBOW-310  Data Mgmt: Product Assesment and Selection  In Analysis  - To establish a provider for the...  2017-05-26      NaN
1  XTBOW-420       Data Mgmt: Vendor > CIBC Implemention  NaN  - Integrate with Vendor to fetch Corporat...  2017-05-19      NaN
2  XTBOW-421             Trade Migration: PVs and Greeks  NaN  - PVs and Greeks regression gap analysis ...  2017-05-19      NaN
3  XTBOW-422       Trade Migration: Reports (XTC vs XT2)  NaN                                           ...  2017-05-19      NaN

      Work Package                              Task
0        Data Mgmt   Product Assesment and Selection
1        Data Mgmt        Vendor > CIBC Implemention
2  Trade Migration                    PVs and Greeks
3  Trade Migration              Reports (XTC vs XT2)