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

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

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

使用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')]

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

1.固定以officer 分割： lambda x: x.split('officer')
注意这种情况需要在分割后的字符串后面手动添加officer

2.查找大写字母的位置，取第二个
lambda x: [index for (index, letter) in enumerate(x) if letter.isupper()][1]

3.使用正则
lambda x: re.match('([A-Z][^A-Z]) (.)', x).groups()