- Pull the repository to your local machine.
- Install Python 3.8 or higher.
- Install the required packages by running
pip install csv
in the command line. - Place all the CSV files you want to combine in the
inputs
directory. - Run the
combine.py
script. - The combined CSV file will be saved in the
outputs
directory. - The combined CSV file will be named
combined_csvs.csv
by default. You can change this by editing line 7 of thecombine.py
script. - The combined CSV file will contain a header row and a data row for each CSV file. If you want to remove the header row from each CSV file, set
skip_header
toTrue
on line 8 of thecombine.py
script. - If you want to combine CSV files from a different directory, change the value of
directory
on line 4 of thecombine.py
script. - If you want to combine CSV files with a different file extension, change the value of
".csv"
on line 5 of thecombine.py
script. - If you want to combine CSV files with a different delimiter, change the value of
","
on line 6 of thecombine.py
script. - If you want to combine CSV files with a different encoding, change the value of
"utf-8"
on line 7 of thecombine.py
script.
Flexsidee/combine_csv_files
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
A script that can be used to merge multiple excel sheets with same heading into one sheet
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published