pandas中如何让两个dataframe互相填充缺失值

Question

有两套数据，做成了两个行列标签相同的dataframe，想知道如何让两个dataframe相互填补缺失值。

Answer 1

import pandas as pd

data1 = [{'a': '1', 'b': ''}, {'a': '', 'b': '2'}]
data2 = [{'a': '', 'b': '3'}, {'a': '4', 'b': ''}]

df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)

for i, row in df1.iterrows():
    for key in row.keys():
        if not row[key]:
            row[key] = df2.loc[i][key]

print df1