汇总pandas数据框列表

使用

reduce

add

fill_value=0

np.random.seed(12)a = pd.Dataframe(np.random.randint(3, size=(5,3)), columns=list('abc'))b = pd.Dataframe(np.random.randint(3, size=(5,2)), columns=list('ab'))c = pd.Dataframe(np.random.randint(3, size=(5,2)), columns=list('ac'))print(a)   a  b  c0  2  1  11  2  0  02  2  1  03  1  1  14  2  2  2print(b)   a  b0  0  11  0  02  1  23  1  24  0  1print(c)   a  c0  2  01  2  22  2  03  0  24  1  1

from functools import reducedfs = [a,b, c]d = reduce(lambda x, y: x.add(y, fill_value=0), dfs)print (d)   a    b    c0  4  2.0  1.01  4  0.0  2.02  5  3.0  0.03  2  3.0  3.04  3  3.0  3.0