Skip to main content
 首页 » 编程设计

python之链接多个 combine_first()

2025年01月19日8duanxz

什么是链接多个 combine_first() 语句的更好方法。 即

我已经解析了一些数据,并且有 3 个不同的 cc-email 列。这行得通,但是有没有更简洁的方法呢?

df['cc-email2'] = df['cc-email'].combine_first( 
df['cc-email_cc-email'].combine_first( 
df['cc-emails_cc-email'])) 

例如

df = pd.DataFrame([]) 
df['cc-email'] = ('bob@hotmail.com', np.nan, np.nan, np.nan) 
df['cc-email_cc-email'] = (np.nan, 'michael@outlook.com', np.nan, np.nan) 
df['cc-emails_cc-email'] = ('bob@yahoo.com', np.nan, np.nan, 'trey@gmail.com') 

结果 df:

     cc-email           cc-email_cc-email   cc-emails_cc-email    cc-email2 
0    bob@hotmail.com    NaN                 bob@yahoo.com         bob@hotmail.com 
1    NaN                michael@outlook.com NaN                   michael@outlook.com 
2    NaN                NaN                 NaN                   NaN 
3    NaN                NaN                 trey@gmail.com        trey@gmail.com 

请您参考如下方法:

我认为你可以使用reduce:

from functools import reduce 
 
dfs = [df['cc-email'], df['cc-email_cc-email'], df['cc-emails_cc-email']] 
df['cc-email2'] = reduce(lambda l,r: l.combine_first(r), dfs) 

但似乎 ffill 选择最后一列也应该有效:

df['cc-email2'] = df.ffill(axis=1).iloc[:, -1] 
print (df) 
          cc-email    cc-email_cc-email cc-emails_cc-email  \ 
0  bob@hotmail.com                  NaN      bob@yahoo.com    
1              NaN  michael@outlook.com                NaN    
2              NaN                  NaN                NaN    
3              NaN                  NaN     trey@gmail.com    
 
             cc-email2   
0        bob@yahoo.com   
1  michael@outlook.com   
2                  NaN   
3       trey@gmail.com