且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

用列/系列中的值替换pandas子字符串

更新时间:2022-11-11 12:00:55

您需要python re.sub和listcomp

You need python re.sub and listcomp

import re

df['new_name'] = [re.sub(r'\(\w+\)', r, s) for r, s in zip(df.name2, df.name)]

Out[280]:
   id       name  name2     new_name
0   1  name1 (C)   Jane   name1 Jane
1   2  name2 (B)  Abbie  name2 Abbie
2   3      name3   Luke        name3
3   4      name4  Peter        name4