Find Jobs
Hire Freelancers

Transform a large data set in Python

$30-250 USD

Closed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
I have an Excel sheet containing approximately 200,000 data points on multiple sheets. They need to be entirely reorganized into a single large Pandas DataFrame. There are some pitfalls: on some sheets the number of columns are inconsistent, column headers missing, etc. In short, this does require some nifty Python programming and some data cleaning. I will provide the files and script I have written so far. Please outline your previous Python experience - thanks!
Project ID: 13801153

About the project

19 proposals
Remote project
Active 7 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
19 freelancers are bidding on average $173 USD for this job
User Avatar
Bid Summary I am a computer science professional with a PhD degree and excellent skills in Python and a number of other languages. I've dome many data science projects in Python including Pandas and Excel.. Project Requirements I've done many similar projects. Please see reviews on my profile. It would be my pleasure to complete your project. Due to the pitfalls you mentioned, I assume I'll need to spend a lot of time manually exploring and cleaning the data in Excel before it could be imported into Python. My bid reflects those expectations. Relevant Skills and Experience I've done a lot of reading of large data sets from Excel to Python, so once the data has been cleaned, the rest must be easy. Proposed Milestones $200 USD - default milestone
$200 USD in 2 days
5.0 (24 reviews)
5.6
5.6
User Avatar
Expert python developer with experience of over 100 projects and masters in Data science. If you'll read my reviews you'll notice how much my clients love my work and me to discuss this further contact me.
$250 USD in 5 days
4.9 (32 reviews)
5.4
5.4
User Avatar
Bid Summary hello Sir, I'm the author of "Building Machine Learning Projects with Tensorflow", and am writing a second book about Machine Learning. Please feel free to discuss details via chat. Best Regards. Project Requirements Data input via pandas Data cleanup and preprocessing Data processing Relevant Skills and Experience Very experienced software engineer (10 years plus experience). Python based book author. Proposed Milestones $155 USD - Full project
$155 USD in 3 days
5.0 (5 reviews)
4.7
4.7
User Avatar
hello I have read your requirement. I can help you to finish this work. Can you provide more information about this project? Thank you
$150 USD in 3 days
5.0 (19 reviews)
4.9
4.9
User Avatar
Bid Summary I will need to review the data set and files to estimate what kind of preprocessing will be required for pandas. I don't expect there to be too many issues. Project Requirements You require an excel sheet to be processed into a pandas dataframe. The excel sheet will require preprocessing of some kind. Relevant Skills and Experience I am highly experienced in python (2 and 3) and have worked with most python frameworks including pandas. Proposed Milestones $277 USD - convert excel data to data frame Please provide me with your existing script and data to assess the feasibility of the task.
$277 USD in 3 days
4.9 (8 reviews)
4.7
4.7
User Avatar
I have worked with python/pandas, and data cleaning with csv and excel files, as part of my data mining projects
$55 USD in 3 days
5.0 (7 reviews)
3.4
3.4
User Avatar
Bid Summary Hello, I have been developing scripts within the python environment for over 5 years. I have experience in all the sub tasks that you require. Regards, Steven Project Requirements convert excel data to pandas data frame, handle missing data. Relevant Skills and Experience python, pandas, excel, 5+ years experience Proposed Milestones $150 USD - completion
$150 USD in 4 days
4.3 (12 reviews)
3.9
3.9
User Avatar
Bid Summary Multiple sheet data has to be merged and created as Pandas DataFrame using python. Current Data is in Excel. Project Requirements Merge all sheets data into a single Pandas DataFrame Relevant Skills and Experience Python, Excel and VBA Proposed Milestones $160 USD - Final Datafile Additional Services Offered $1 USD - Nothing
$160 USD in 7 days
5.0 (1 review)
2.7
2.7
User Avatar
Bid Summary I am master in computer science and i know about the requirements of your project Project Requirements it is very easy to complete within due date range Relevant Skills and Experience pythen, java, HTML etc Proposed Milestones $45 USD - after completion further discussion on chat
$45 USD in 3 days
5.0 (1 review)
0.3
0.3
User Avatar
Having practical experience of development in this area through some starling concepts. May be next one is yours . You may also wish to review my portfolio in order to check my previous work and learn more about my skill. Thank you
$150 USD in 7 days
5.0 (8 reviews)
0.0
0.0

About the client

Flag of GERMANY
San Francisco, Germany
5.0
10
Payment method verified
Member since Dec 9, 2015

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.