Find Jobs
Hire Freelancers

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!
Project ID: 28188282

About the project

7 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
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
$30 AUD in 1 day
5.0 (61 reviews)
5.3
5.3
User Avatar
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.
$30 AUD in 1 day
5.0 (1 review)
2.4
2.4
User Avatar
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.
$30 AUD in 2 days
5.0 (3 reviews)
1.8
1.8

About the client

Flag of AUSTRALIA
Bogangar, Australia
5.0
1
Payment method verified
Member since Oct 24, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.