/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

1 vote292 views3 answers
How to sort values in python
Python
7 votes331 views4 answers
Qr code in python
Python
0 vote318 views1 answer
Nth term of gp in python when 2,3 terms given
Python
0 vote296 views2 answers
How to create fibonacci sequence in python
Python
4 votes305 views1 answer
Histogram | creating a histogram
Python
0 vote314 views4 answers
New line in jupyter notebook markdown
Python
9 votes340 views6 answers
How to get absolute path in python
Python
3 votes335 views1 answer
Python split on first occurrence
Python
0 vote315 views2 answers
How to count how many cameras you have with python
Python
11 votes305 views1 answer
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe2 in position 10: invalid continuation byte
Python