Python如何用lambda apply分割成 Addition of officer + 后面的大写名字，以及Removal of officer + 后面的大写名字

Question

1 Addition of officer C T CORPORATION SYSTEM
2 Addition of officer TIMOTHY COOK
3 Removal of officer DOUGLAS PHILLIPS
4 Removal of officer MIKHAIL V. PARAKHIN
5 Removal of officer ROHAN KUMAR
7 Addition of officer LEGALZOOM.COM, INC
8 Addition of officer ELIZABETH PORTIA MORGAN

看到了您其他的回答，感觉您真的很厉害！如果有空余时间可否指导一下

Answer 1

使用pandas和字符串函数startswith匹配。代码可这样写：

df['val1'] = df['val'].apply(lambda x: x if x.startswith('Add') else None)
df['val2'] = df['val'].apply(lambda x: x if x.startswith('Rem') else None)

如果分割成两个子数据框的话，这样：

df1=df[df['val'].str.startswith('Add')]
df2 = df[df['val'].str.startswith('Rem')]

如对你有帮助，请点采纳按钮。