merge all csv files in a folder python code example

Example 1: how to join csv files in python

import os
import glob
import pandas as pd
os.chdir("/mydir")

extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]

#combine all files in the list
combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames ])
#export to csv
combined_csv.to_csv( "combined_csv.csv", index=False, encoding='utf-8-sig')

Example 2: merge all csv files in a folder python

merge all csv files in a folder python

Example 3: merge all csv files in a folder python

merge all csv files in a folder python