单元格中的Pandas带状文本

Question

我正在尝试从我的数据帧中剥离文本。目前我有以下内容：

ID                 name
T1548              Abuse Elevation Control Mechanism
T1548.002          Abuse Elevation Control Mechanism: Bypass User Account Control
T1548.004          Abuse Elevation Control Mechanism: Elevated Execution with Prompt
T1548.001          Abuse Elevation Control Mechanism: Setuid and Setgid
T1548.003          Abuse Elevation Control Mechanism: Sudo and Sudo Caching
T1134              Access Token Manipulation
T1134.002          Access Token Manipulation: Create Process with Token

如果它包含'：‘，我想删除它和它之前的所有文本，并得到以下输出：

ID                 name
T1548              Abuse Elevation Control Mechanism
T1548.002          Bypass User Account Control
T1548.004          Elevated Execution with Prompt
T1548.001          Setuid and Setgid
T1548.003          Sudo and Sudo Caching
T1134              Access Token Manipulation
T1134.002          Create Process with Token

有没有像这样剥离文本的方法？

Answer 1

您可以在:上拆分并取最后一个值。使用索引将应用于整个列，其中-1 .str返回最后一个值，即使只有一个值也是如此。

df.name.str.split(':').str[-1]