Merge A List Of Pandas Dataframes Into A Single Dataframe In Python

Merge A List Of Pandas Dataframes Into A Single Dataframe In Python

To merge a list of pandas dataframes into a single dataframe in Python, you’ll need to use the merge() function. This function takes two or more dataframes as input and returns one new data frame of type list. Merging a list of pandas dataframes into a single dataframe in Python is easy. In this tutorial, we will learn how to merge a list of pandas dataframes into a single dataframe in Python.

*Working on Jupyter Notebook Anaconda Environment.

As a result of merging a list of DataFrames with identical column labels into one DataFrame, each DataFrame column is combined into another until there is only one DataFrame left, which has information about all dataframes previously in the list.

If you want to learn more about Python Programming, visit Python Programming Tutorials.

Merge Pandas Dataframes In Python.

First, we’ll need to create our dataset. We’ll combine both dataframes by creating a list of Panda’s dataframes. We’ll need to create an object for the list to hold the merged dataset. 

After that, we call the merge function from pandas to combine a list of pandas dataframes into a single dataframe in Python in aggregation with reduce function. 

The execution process is like this:

  • First, create two or more dataframes in Pandas by importing the panda’s library.
  • Now, in a list, hold both dataframes.
  • Now import reduce function from the functools module.
  • Now using reduce function in aggregation with merge() function to combine a list of pandas dataframes into a single dataframe in Python.
  • Both dataframes are joined by “on,” indicating which field is being joined. 
  • A join can be inner, outer, left, or right depending on the “how.” 
  • Print the merged dataframes using simple print commands. 
import pandas as pd
flower=pd.DataFrame({'flower':['Red Ginger','Tree Poppy','passion flower','water lily'],'test':['similarities','accuracy','correctness','classification']},
                 index=[0,1,2,3])
test=pd.DataFrame({'flower':['Red Ginger','Tree Poppy','rose flower','sun flower'],'cluster':['cluster_1','cluster_2','cluster_3','cluster_4' ]},
                 index=[4,5,6,7])
merge_a_list = [flower, test]
from functools import reduce
merge_df = reduce(lambda flower, test:    
                    pd.merge(flower , test,
                             on = ["flower"],  
                             how = "outer"),
                    merge_a_list)
merge_df      
flowertestcluster
0Red Gingersimilaritiescluster_1
1Tree Poppyaccuracycluster_2
2passion flowercorrectnessNaN
3water lilyclassificationNaN
4rose flowerNaNcluster_3
5sun flowerNaNcluster_4

Using Concat() function

You can merge DataFrames by calling pandas.concat( merge_a_list ) with pandas.DataFrames with the same column labels are merged and give a single dataframe.  DataFrame data that belong to the same column label are combined into a single column by the Concat () function. A column outside of the intersection will be empty. The value ” NaN ” will be returned if no values are present.

import pandas as pd
flower=pd.DataFrame({'flower':['Red Ginger','Tree Poppy','passion flower','water lily'],'test':['similarities','accuracy','correctness','classification']},
                 index=[0,1,2,3])
test=pd.DataFrame({'flower':['Red Ginger','Tree Poppy','rose flower','sun flower'],'cluster':['cluster_1','cluster_2','cluster_3','cluster_4' ]},
                 index=[4,5,6,7])
merge_a_list = [flower, test]
merge = pd. concat(merge_a_list)
print(type(merge))
merge
<class 'pandas.core.frame.DataFrame'>
flowertestcluster
0Red GingersimilaritiesNaN
1Tree PoppyaccuracyNaN
2passion flowercorrectnessNaN
3water lilyclassificationNaN
4Red GingerNaNcluster_1
5Tree PoppyNaNcluster_2
6rose flowerNaNcluster_3
7sun flowerNaNcluster_4

Conclusion

On this Page, two ways are discussed with examples of how to merge a list of pandas dataframes into a single dataframes in Python. These two methods include using a merge() function to join dataframes into a single dataframe and using a concat() function to do so. 

Leave a Comment

Your email address will not be published. Required fields are marked *