script to combine thousand plus csv files
Budget: $30 – $250 USD
looking for a script that would combine over a thousand csv files that have special characters in them with the option to disable importing the first row of every file.
would prefer the use of python or shell scripting and would like comments added to the script so I can troubleshoot if the script stops working.
All files would be located in one directory
First column of output.csv would have the filename.csv at the beginning of each row that was imported from that filename.
Example:
filename1.csv,mxrecord,domainame.com,,mx01.domainname.com,,10,,,STATIC,,False,False,,External,CHG123456
filename1.csv,txtrecord,domainame.com,,""etc...
filename2.csv,cnamrecord,xpress-tst.domainname.com,
etc..
would prefer the use of python or shell scripting and would like comments added to the script so I can troubleshoot if the script stops working.
All files would be located in one directory
First column of output.csv would have the filename.csv at the beginning of each row that was imported from that filename.
Example:
filename1.csv,mxrecord,domainame.com,,mx01.domainname.com,,10,,,STATIC,,False,False,,External,CHG123456
filename1.csv,txtrecord,domainame.com,,""etc...
filename2.csv,cnamrecord,xpress-tst.domainname.com,
etc..