Zc' 2021-11-09 01:07 采纳率: 0%
浏览 10

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

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

  • 写回答

2条回答 默认 最新

  • CSDN专家-HGJ 2021-11-09 11:36
    关注

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

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

    评论

报告相同问题?

问题事件

  • 创建了问题 11月9日