我的熊猫数据框中有两列。
我想用Credit_History
列(dtype:int64)的值填充列(dtype:int64)的缺失值Loan_Status
。
您可以尝试fillna
或combine_first
:
df.Credit_History = df.Credit_History.fillna(df.Loan_Status)
要么:
df.Credit_History = df.Credit_History.combine_first(df.Loan_Status)
样品:
import pandas as pd
import numpy as np
df = pd.DataFrame({'Credit_History':[1,2,np.nan, np.nan],
'Loan_Status':[4,5,6,8]})
print (df)
Credit_History Loan_Status
0 1.0 4
1 2.0 5
2 NaN 6
3 NaN 8
df.Credit_History = df.Credit_History.combine_first(df.Loan_Status)
print (df)
Credit_History Loan_Status
0 1.0 4
1 2.0 5
2 6.0 6
3 8.0 8
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句