I have a small project that I would like to get completed. I have hundreds of CSV files located in a specific Google Drive directory. These spreadsheets are formatted identically, however the data within them is unique. I am looking for a google script that can: 1. Take the CSV filename and append it to a column in the spreadsheet (otherwise I have no way of identifying the data, the filename is the only place where the name exists) 2. Remove multiple columns from the CSV (Currently there are 22 columns, of which I only require 5, I'd like to remove the unnecessary columns) and 3. Export to one large spreadsheet that combines all of the sheets from the directory.
12 freelancer đang chào giá trung bình $150 cho công việc này
I have worked with CSV files because of machine learning. I will do the job in python which is the best language for this needs. If you have any doubt just contact me.