Sometimes, we want to merge multiple data frames with Python Pandas.
In this article, we’ll look at how to merge multiple data frames with Python Pandas.
How to merge multiple data frames with Python Pandas?
To merge multiple data frames with Python Pandas, we can use the concat method.
For instance, we write:
import pandas as pd
data1 = {'a': [1, 2, 3]}
data2 = {'a': [4, 5, 6]}
df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)
merged_df = pd.concat([df1, df2])
print(merged_df)
We create 2 data frames with pd.DataFrame and 2 dictionaries.
Then we call pd.concat with the data frames in the list and assign the returned data frame to merged_df.
Therefore, merged_df is:
a
0 1
1 2
2 3
0 4
1 5
2 6
Conclusion
To merge multiple data frames with Python Pandas, we can use the concat method.
