In today's world, data is collected and stored at increasingly fast rates. One popular format for storing text data is the **CSV** or **comma-separated values** file. In this shot, we will learn how to merge multiple CSV files into one using the [pandas library](https://www.educative.io/answers/what-is-pandas-in-python) in Python.

Let's suppose we have three CSV files ("A.csv", "B.csv", and "C.csv") that store the information of students who go to the same school in the same directory. The contents of these three files are shown below:

Our goal is to compile all this data into a single CSV file. To do so, we will use the `concat` method in pandas and then store the result in a final CSV called "ABC.csv". This can be done by running the following Python program in the directory where the three CSV files are located:

Name,Roll Number,Grade
Usama,24524,6
Alizeh,13452,4
Ibrar,54633,8

Name,Roll Number,Grade
Sherzad,42168,5
Sana,35246,8
Nabeela,78356,3

Name,Roll Number,Grade
Farheen,33462,4
Bilal,46724,7
Zaroon,56880,5

import pandas as pd

files = ["A.csv", "B.csv", "C.csv"]

# Combine all three CSV files using the concat method
a_b_c = pd.concat([pd.read_csv(f) for f in files])
# Export to csv
a_b_c.to_csv( "ABC.csv", index=False, encoding='utf-8-sig')
data = pd.read_csv("ABC.csv") 
print(data)

After executing the following code, "ABC.csv" will be produced in the same directory as our A, B, and C files. The contents of this merged CSV will be as follows:

How to combine multiple CSV files in Python

Merge multiple CSV files into one using Python’s pandas library and the concat method.