How to Join Pandas DataFrames using Merge?
Last Updated :
05 May, 2022
Joining and merging DataFrames is that the core process to start out with data analysis and machine learning tasks. It's one of the toolkits which each Data Analyst or Data Scientist should master because in most cases data comes from multiple sources and files. In this tutorial, you'll how to join data frames in pandas using the merge technique. More specifically, we will practice the concatenation of DataFrames along row and column.
Getting Started
The most widely used operation related to DataFrames is the merging operation. Two DataFrames might hold different kinds of information about the same entity and they may have some same columns, so we need to combine the two data frames in pandas for better reliability code. To join these DataFrames, pandas provides various functions like join(), concat(), merge(), etc. In this section, you will practice using the merge() function of pandas. There are basically four methods of merging:
- inner join
- outer join
- right join
- left join
Inner join
From the name itself, it is clear enough that the inner join keeps rows where the merge “on” value exists in both the left and right dataframes.
Now let us create two dataframes and then try merging them using inner.
Python3
import numpy as np
import pandas as pd
left = pd.DataFrame({'Sr.no': ['1', '2', '3', '4', '5'],
'Name': ['Rashmi', 'Arun', 'John',
'Kshitu', 'Bresha'],
'Roll No': ['1', '2', '3', '4', '5']})
right = pd.DataFrame({'Sr.no': ['2', '4', '6', '7', '8'],
'Gender': ['F', 'M', 'M', 'F', 'F'],
'Interest': ['Writing', 'Cricket', 'Dancing',
'Chess', 'Sleeping']})
# Merging the dataframes
pd.merge(left, right, how ='inner', on ='Sr.no')
Output: 
Outer join
An outer join returns all the rows from the left dataframe, all the rows from the right dataframe, and matches up rows where possible, with NaNs elsewhere. But if the dataframe is complete, then we get the same output.
Python3
import numpy as np
import pandas as pd
left = pd.DataFrame({'Sr.no': ['1', '2', '3', '4', '5'],
'Name': ['Rashmi', 'Arun', 'John',
'Kshitu', 'Bresha'],
'Roll No': ['1', '2', '3', '4', '5']})
right = pd.DataFrame({'Sr.no': ['2', '4', '6', '7', '8'],
'Gender': ['F', 'M', 'M', 'F', 'F'],
'Interest': ['Writing', 'Cricket', 'Dancing',
'Chess', 'Sleeping']})
# Merging the dataframes
pd.merge(left, right, how ='outer', on ='Sr.no')
Output: 
Left join
With a left join, all the records from the first dataframe will be displayed, irrespective of whether the keys in the first dataframe can be found in the second dataframe. Whereas, for the second dataframe, only the records with the keys in the second dataframe that can be found in the first dataframe will be displayed.
Python3
import numpy as np
import pandas as pd
left = pd.DataFrame({'Sr.no': ['1', '2', '3', '4', '5'],
'Name': ['Rashmi', 'Arun', 'John',
'Kshitu', 'Bresha'],
'Roll No': ['1', '2', '3', '4', '5']})
right = pd.DataFrame({'Sr.no': ['2', '4', '6', '7', '8'],
'Gender': ['F', 'M', 'M', 'F', 'F'],
'Interest': ['Writing', 'Cricket',
'Dancing', 'Chess',
'Sleeping']})
# Merging the dataframes
pd.merge(left, right, how ='left', on ='Sr.no')
Output:
Note the Output Carefully.
Right join
For a right join, all the records from the second dataframe will be displayed. However, only the records with the keys in the first dataframe that can be found in the second dataframe will be displayed.
Python3
import numpy as np
import pandas as pd
left = pd.DataFrame({'Sr.no': ['1', '2', '3', '4', '5'],
'Name': ['Rashmi', 'Arun', 'John',
'Kshitu', 'Bresha'],
'Roll No': ['1', '2', '3', '4', '5']})
right = pd.DataFrame({'Sr.no': ['2', '4', '6', '7', '8'],
'Gender': ['F', 'M', 'M', 'F', 'F'],
'Interest': ['Writing', 'Cricket', 'Dancing',
'Chess', 'Sleeping']})
# Merging the dataframes
pd.merge(left, right, how ='right', on ='Sr.no')
Output: 
Similar Reads
Python Tutorial - Learn Python Programming Language Python is one of the most popular programming languages. Itâs simple to use, packed with features and supported by a wide range of libraries and frameworks. Its clean syntax makes it beginner-friendly. It'sA high-level language, used in web development, data science, automation, AI and more.Known fo
10 min read
Python Interview Questions and Answers Python is the most used language in top companies such as Intel, IBM, NASA, Pixar, Netflix, Facebook, JP Morgan Chase, Spotify and many more because of its simplicity and powerful libraries. To crack their Online Assessment and Interview Rounds as a Python developer, we need to master important Pyth
15+ min read
Python OOPs Concepts Object Oriented Programming is a fundamental concept in Python, empowering developers to build modular, maintainable, and scalable applications. By understanding the core OOP principles (classes, objects, inheritance, encapsulation, polymorphism, and abstraction), programmers can leverage the full p
11 min read
Python Projects - Beginner to Advanced Python is one of the most popular programming languages due to its simplicity, versatility, and supportive community. Whether youâre a beginner eager to learn the basics or an experienced programmer looking to challenge your skills, there are countless Python projects to help you grow.Hereâs a list
10 min read
Python Exercise with Practice Questions and Solutions Python Exercise for Beginner: Practice makes perfect in everything, and this is especially true when learning Python. If you're a beginner, regularly practicing Python exercises will build your confidence and sharpen your skills. To help you improve, try these Python exercises with solutions to test
9 min read
Python Programs Practice with Python program examples is always a good choice to scale up your logical understanding and programming skills and this article will provide you with the best sets of Python code examples.The below Python section contains a wide collection of Python programming examples. These Python co
11 min read
Python Introduction Python was created by Guido van Rossum in 1991 and further developed by the Python Software Foundation. It was designed with focus on code readability and its syntax allows us to express concepts in fewer lines of code.Key Features of PythonPythonâs simple and readable syntax makes it beginner-frien
3 min read
Python Data Types Python Data types are the classification or categorization of data items. It represents the kind of value that tells what operations can be performed on a particular data. Since everything is an object in Python programming, Python data types are classes and variables are instances (objects) of thes
9 min read
Input and Output in Python Understanding input and output operations is fundamental to Python programming. With the print() function, we can display output in various formats, while the input() function enables interaction with users by gathering input during program execution. Taking input in PythonPython input() function is
8 min read
Enumerate() in Python enumerate() function adds a counter to each item in a list or other iterable. It turns the iterable into something we can loop through, where each item comes with its number (starting from 0 by default). We can also turn it into a list of (number, item) pairs using list().Let's look at a simple exam
3 min read