Transform a large data set in Python

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!

Umiejętności: Python

Zobacz więcej: python set page title, set data sql 2005 user primavera, python website data, add subtract large numbers arrays programming, perl xls maker set data type, parsing html python extract data, python extract data web page, python extract data html, plot set data excel graph, excel paste data large, skill set data cleansing, set data feed website, set data feed, set data feeds, identify possibilities given set data excel lotto

O pracodawcy:
( 10 ocen ) San Francisco, Germany

Numer ID Projektu: #13801153

22 freelancerów złożyło ofertę na kwotę $178 do tego projektu


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 Re Więcej

$200 USD w ciągu 2 dni
(25 Oceny)

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 w ciągu 5 dni
(29 Oceny)
$250 USD w ciągu 3 dni
(12 Oceny)

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 w ciągu 3 dni
(19 Oceny)

Experienced in using pandas in Python for multiple tasks like data cleaning, manipulation,analysis,machine learning etc My profile is as follows:- 4 years of experience in data [login to view URL] science and analytics profe Więcej

$170 USD w ciągu 3 dni
(16 Oceny)

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 Więcej

$277 USD w ciągu 3 dni
(8 Oceny)

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 R Więcej

$155 USD w ciągu 3 dni
(5 Oceny)
$200 USD w ciągu 3 dni
(22 Oceny)

Bid Summary I have a python script that iterates over data in columnar format and cleans the data based on ideal names and matches to ideals. Should be able to ETL your data easily with slight adjustment. Project Req Więcej

$222 USD w ciągu 3 dni
(3 Oceny)

I have worked with python/pandas, and data cleaning with csv and excel files, as part of my data mining projects

$55 USD w ciągu 3 dni
(6 Oceny)
$155 USD w ciągu 3 dni
(1 Ocena)
$100 USD w ciągu 3 dni
(5 Oceny)

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 E Więcej

$160 USD w ciągu 7 dni
(1 Ocena)

Bid Summary Hi, Can we know more about the project Project Requirements About ME : We have been freelancing for 10 years and has perfect reviews on all my projects. We am are Expert in Delphi and Java, I have a Diplo Więcej

$250 USD w ciągu 3 dni
(1 Ocena)

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 p Więcej

$150 USD w ciągu 4 dni
(6 Oceny)

Bid Summary Hi! I'll adapt your 200,000 data points from Excel to a [login to view URL], taking care of the inconsistencies, like the number of columns, missing headers, etc. Project Requirements For this project it is Więcej

$250 USD w ciągu 5 dni
(2 Oceny)

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 e Więcej

$45 USD w ciągu 3 dni
(1 Ocena)
$155 USD w ciągu 3 dni
(0 Oceny)

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 sk Więcej

$150 USD w ciągu 7 dni
(8 Oceny)
$166 USD w ciągu 7 dni
(0 Oceny)