合并重叠数据&combine_first

import numpy as np
import pandas as pd

参考文档: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.combine_first.html

合并重叠数据练习

df1 = pd.DataFrame(np.random.rand(4,3))
df1

	0	1	2
0	0.325950	0.452043	0.655911
1	0.530379	0.049705	0.207227
2	0.326496	0.582872	0.702065
3	0.256844	0.971958	0.467238

df2 = pd.DataFrame(np.random.rand(3,2))
df2

	0	1
0	0.808633	0.639771
1	0.909655	0.409935
2	0.396323	0.589618

df1的第0行第三列均为nan

df1[2]=np.nan
df1.loc[0]=np.nan

df1

	0	1	2
0	NaN	NaN	NaN
1	0.530379	0.049705	NaN
2	0.326496	0.582872	NaN
3	0.256844	0.971958	NaN

利用combine_first合并df1,df2

df1.combine_first(df2)

	0	1	2
0	0.808633	0.639771	NaN
1	0.530379	0.049705	NaN
2	0.326496	0.582872	NaN
3	0.256844	0.971958	NaN