In this tutorial, we will learn how to merge two CSV files using Python with some cool and easy examples. In many situations, you might have to come up with this type of requirements.
I know you are here just because you are in need of this awesome trick to merge two CSV files using Python.
If you don’t know how to merge two CSV files using python then you are at the right place. Because in this tutorial we gonna find out how to merge two CSV files using python.
import pandas as pd
data1 = pd.read_csv('datasets/loan.csv')
data2 = pd.read_csv('datasets/borrower.csv')
output1 = pd.merge(data1, data2, on='LOAN_NO',how='inner')
print(output1)
Output:
