/Python/Python merge csv files in same folder

Python merge csv files in same folder

import os, glob
import pandas as pd

os.chdir(os.path.dirname(__file__) + r"\CSVs")

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

combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames ])

os.chdir(os.path.dirname(__file__))

combined_csv.to_csv( "combined_csv.csv", index=False, encoding='utf-8-sig')

Source: github.com

Similar codes

0 vote202 views1 answer
Error: Command '['/home/jonas/twitchslam/env/bin/python3.6', '-Im', 'ensurepip', '--upgrade', '--default-pip']' returned non-zero exit status 1.
Python
0 vote147 views1 answer
Python apply function to list
Python
0 vote155 views1 answer
Django check if get parameter exists
Python Django
0 vote185 views1 answer
How to send file in django response
Python Django
0 vote179 views1 answer
Django project files
Python Django
2 votes151 views2 answers
Python asterisk as generator
Python
17 votes230 views6 answers
Installing django
Python Django
0 vote165 views1 answer
Parallel loops in python
Python
1 vote179 views1 answer
Flask blueprints
Python Flask
0 vote168 views1 answer
Removing duplicates using json python
Python