从多个其他列中填充空白Pandas列(多于2个)

import pandas as pd

# 创建示例DataFrame
data = {'A': [1, 2, None, 4, 5],
        'B': [None, 2, 3, 4, 5],
        'C': [None, None, None, 4, 5],
        'D': [None, 2, None, None, 5]}

df = pd.DataFrame(data)

# 从多个列中填充空白列
df['A'].fillna(df['B'], inplace=True)  # 使用列B填充列A的缺失值
df['A'].fillna(df['C'], inplace=True)  # 使用列C填充列A的缺失值
df['A'].fillna(df['D'], inplace=True)  # 使用列D填充列A的缺失值

print(df)

     A    B    C    D
0  1.0  NaN  NaN  NaN
1  2.0  2.0  NaN  2.0
2  3.0  3.0  NaN  NaN
3  4.0  4.0  4.0  NaN
4  5.0  5.0  5.0  5.0