Merge List of pandas DataFrames in Python (Example) | Join & Combine | reduce() Function & functools
How to join a list of multiple data sets using the pandas library in the Python programming language. More details: https://statisticsglobe.com/merge-lis...
Python code of this video:
import pandas as pd # Load pandas
data1 = pd.DataFrame({"ID":range(1, 6), # Create first pandas DataFrame
"x1":range(101, 106),
"x2":["y", "x", "c", "v", "b"]})
data2 = pd.DataFrame({"ID":range(4, 9), # Create second pandas DataFrame
"y1":["a", "y", "x", "a", "y"],
"y2":range(20, 10, - 2)})
data3 = pd.DataFrame({"ID":range(2, 10), # Create third pandas DataFrame
"z1":range(21, 29),
"z2":range(10, 2, - 1)})
data_list = [data1, data2, data3] # Create list of DataFrames
print(data_list) # Print list of DataFrames
[ ID x1 x2
0 1 101 y
1 2 102 x
2 3 103 c
3 4 104 v
4 5 105 b, ID y1 y2
0 4 a 20
1 5 y 18
2 6 x 16
3 7 a 14
4 8 y 12, ID z1 z2
0 2 21 10
1 3 22 9
2 4 23 8
3 5 24 7
4 6 25 6
5 7 26 5
6 8 27 4
7 9 28 3]
from functools import reduce # Import reduce function
data_merge = reduce(lambda left, right: # Merge DataFrames in list
pd.merge(left , right,
on = ["ID"],
how = "outer"),
data_list)
print(data_merge) # Print merged DataFrame
Follow me on Social Media:
Facebook – Statistics Globe Page: / statisticsglobecom
Facebook – Group for Discussions & Questions: / statisticsglobe
LinkedIn – Statistics Globe Page: / statisticsglobe
LinkedIn – Group for Discussions & Questions: / 12555223
Twitter: / joachimschork
Music by bensound.com
