Python script for combining multiple csv files into one.

combine_csv.py

import pandas as pd
import sys


'''
usage:
python combine_csv.py <1.csv> <2.csv> ... <n.csv>

will write the final output to standard output
can be written to a new file with:
	python combine_csv.py <1.csv> <2.csv> ... <n.csv> > output.csv

'''


# Empty DataFrame for the CSV files to be added to
finalFrame = pd.DataFrame()

# iterates through all given files and reads them as a csv
# if the file doesnt exist or has different column names, it will throw an error
for file in sys.argv[1:]:
	temp = pd.read_csv(file)
	finalFrame = finalFrame.append(temp, ignore_index=True)

# outputs the resulting csv
print(finalFrame.to_csv(index=False))