我正在使用Pandas处理数据帧,如果另一列的值不是空值,我需要替换一个列。我的数据帧看起来像这样:
v_4 v5 s_5 vt_5 ex_5 pfv pfv_cat
0-50 StoreSale Clothes 8-Apr above 100 FatimaStore Shoes
0-50 StoreSale Clothes 8-Apr 0-50 DiscountWorld Clothes
51-100 CleanShop Clothes 4-Dec 51-100 BetterUncle Shoes
那么,我想在pfv
不为null的情况下用pfv
替换v_5
,我该怎么做?
DF[numpy.isnan(DF["pfv"])]["v_5 "] =DF["pfv"]
- Gwendal YviquelNaN
或None
吗? - jezraeldf.loc[df['pfv'].ne('null'), 'v5'] = df["pfv"]
对你有用吗? - jezrael