您可以使用
reduce函数where
dfList是数据帧列表:
import pandas as pdfrom functools import reducereduce(lambda x, y: pd.merge(x, y, on = 'Date'), dfList)
作为演示:
df = pd.Dataframe({'Date': [1,2,3,4], 'Value': [2,3,3,4]})dfList = [df, df, df]dfList# [ Date Value# 0 1 2# 1 2 3# 2 3 3# 3 4 4, Date Value# 0 1 2# 1 2 3# 2 3 3# 3 4 4, Date Value# 0 1 2# 1 2 3# 2 3 3# 3 4 4]reduce(lambda x, y: pd.merge(x, y, on = 'Date'), dfList)# Date Value_x Value_y Value# 0 1 2 2 2# 1 2 3 3 3# 2 3 3 3 3# 3 4 4 4 4


