How to merge two CSV file by a specific column using python?

python
merge
#1

Hey all #python members, I am working in a project and I found that I am generating 2 CSV files from my server and both 2 files contain one column name same. So, is there anyone who can give me code for merge both 2 files in one file.

Best,
Narendra

#2

import pandas as pd

df1 = pd.read_csv(‘first.csv’)
df2 = pd.read_csv(‘second.csv’)

df = df1.merge(df2, on=‘column_name’)