在pandas中，从另一列填充一个列的缺失值

Question

我有一个pandas数据框，其中包含两列。 我想用Loan_Status列的值（dtype：int64）填充Credit_History列（dtype：int64）中的缺失值。

- Rohit Patwa

Answer 1

你可以尝试使用 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

- jezrael

---

@jazreal：在Credit_History执行combine_first操作后，新的数据框中是否存在Loan_Status列？ - maninekkalapudi