Skip to main content
 首页 » 编程设计

python之如何拆分数据列中的值并将其添加到具有 pandas 条件的新列

2025年01月19日15linjiqin

我有一个df,

name                        Value 
Sri is a cricketer          Sri,is 
Ram player                  Ram 
Ravi is a singer            is 
cricket and foot is ball    and,is,foot 

和一个列表,

my_list=["is", "foot"]

我正在尝试将 df["value"] 拆分为 (,) 并将该值添加到新列(如果该值存在于 my_list 中)。 我的预期输出是

name                      Value        my_list 
Sri is a cricketer        Sri           is       
Ram player                Ram  
Ravi is a singer                        is      
cricket and foot is ball  and          is,foot 

请帮助实现这一目标,提前致谢

请您参考如下方法:

使用str.findall与 str.join :

my_list=["is", "foot"] 
df['my_list'] = df['Value'].str.findall('(' + '|'.join(my_list) + ')').str.join(',') 
print (df) 
                       name        Value  my_list 
0        Sri is a cricketer       Sri,is       is 
1                Ram player          Ram          
2          Ravi is a singer           is       is 
3  cricket and foot is ball  and,is,foot  is,foot 

另一种解决方案 split并获取 set 的 intersection:

my_list=["is", "foot"] 
df['my_list']=df['Value'].str.split(',').apply(lambda x: set(x) & set(my_list)).str.join(',') 
print (df) 
                       name        Value  my_list 
0        Sri is a cricketer       Sri,is       is 
1                Ram player          Ram          
2          Ravi is a singer           is       is 
3  cricket and foot is ball  and,is,foot  is,foot 

最后:

df['Value'] = (df['Value'].str.replace('(' + '|,'.join(my_list) + ')', '') 
                          .str.replace('[,]{2,}',',') 
                          .str.strip(',')) 
print (df) 
                       name Value  my_list 
0        Sri is a cricketer   Sri       is 
1                Ram player   Ram          
2          Ravi is a singer             is 
3  cricket and foot is ball   and  is,foot 

或者:

my_list=["is", "foot"] 
 
s1 = df['Value'].str.split(',') 
 
df['my_list'] = s1.apply(lambda x: set(x) & set(my_list)).str.join(',') 
df['Value'] = s1.apply(lambda x: set(x) - set(my_list)).str.join(',') 
print (df) 
 
                       name Value  my_list 
0        Sri is a cricketer   Sri       is 
1                Ram player   Ram          
2          Ravi is a singer             is 
3  cricket and foot is ball   and  is,foot