Provide python code to transpose data in multiple spreadsheets (batch-process) and re-save each spreadsheet as new .txt file
$10-30 AUD
Completed
Posted over 3 years ago
$10-30 AUD
Paid on delivery
I have a large number of spreadsheets of numerical data in tab delimited format (.txt.). I need each file transposed, and each re-saved as a new file, also in .txt format.
See example files that I have uploaded. I need the code to perform this same function on many more similar files. Note that many (though not all) of the files have more than 16384 rows, so the "paste -> transpose" function in Excel exceeds the 16384 column limit.
Also, I want to avoid the potential for error with doing each one manually - i.e. I would like python code that will batch-process all files in one operation (e.g. by copy-pasting all filenames into the code), rather than manually doing each of the files separately.
Preferably the code should be in python (but could be in matlab).
I also need STEP-BY-STEP instructions on how to execute the code in Juypter, as I do not have much experience using Python.
NOTE: I do NOT want the data processing actually done, I just want the code to perform it myself.
The above task should be relatively simple for someone with experience in basic data manipulation and batch-processing in python, given I only want the code and some basic instructions (i.e. not the actual data processing). It is probably something which can be found through a google search, though I do not have the time to do so myself. So I am only able to pay max. AU$15 for this job.
If you would like to be awarded this job, please reply indicating that you have READ and UNDERSTAND all requirements (WITHOUT needing any further guidance) and are able to complete the task within the budget.
Thanks!
Hi employer.
As a expert in Python development,
I will send you the result +python scripts on 30 minutes because this task is easy for me.
Could you approve me. I will receive money before you check my scripts.
Please contact me at chat for more detail.
$15 AUD in 1 day
5.0 (1 review)
0.0
0.0
7 freelancers are bidding on average $38 AUD for this job
Hi there,
Yes sure. I've great exp with such data manipulation tasks. Will be delivering standalone GUI tool for to batch transpose tab delimited files and re-save. I'm willing to do it at $30 AUD. I could be the best candidate!
I'll respond within max one hour, if you find me offline (daytime).
Best regards,
Ishaq
Dear client.
As a python developer, I am so interested in your small job.
I checked the source file and destination file, then I 100% understand what you want.
Please ping me to discuss more, I am sure I will provide the perfect result.
Regards.
Greetings,
I think here you are looking for someone to provide python code to transpose data in multiple spreadsheets (batch-process) and re-save each spreadsheet as new .txt file.
I have seen the attached file and understood your project description.
I am an expert in Python, Data Processing, Excel, and am interested in your project.
I am confident that I can do this with 100% accuracy and ready to start now!
But I want to know more about your project. So, can we discuss more?
Regards.