Closed

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!

Skills: Python

See more: python website data, python extract data html, excel paste data large, skill set data cleansing, set data feed website, set data feed, set data feeds

About the Employer:
( 10 reviews ) San Francisco, Germany

Project ID: #13801153

23 freelancers are bidding on average $179 for this job

cugamelover

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 More

$200 USD in 2 days
(21 Reviews)
5.2
guptaabhinav

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
(14 Reviews)
4.5
itgold

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 More

$155 USD in 3 days
(5 Reviews)
4.0
$200 USD in 3 days
(12 Reviews)
4.1
aki003iitr

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 science.Data science and analytics profe More

$170 USD in 3 days
(11 Reviews)
4.5
ykStudios

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 More

$277 USD in 3 days
(6 Reviews)
4.3
deaswang

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
(9 Reviews)
3.8
$250 USD in 3 days
(3 Reviews)
4.0
ksinghrajeev

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 More

$160 USD in 7 days
(1 Review)
2.4
$100 USD in 3 days
(1 Review)
1.4
origami07

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 More

$150 USD in 4 days
(3 Reviews)
2.0
charlysalmu

Bid Summary Hi! I'll adapt your 200,000 data points from Excel to a pandas.DataFrame, taking care of the inconsistencies, like the number of columns, missing headers, etc. Project Requirements For this project it is More

$250 USD in 5 days
(2 Reviews)
1.0
baap7

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 More

$150 USD in 7 days
(8 Reviews)
0.0
DamithaKD

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 More

$250 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
atiffani451

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 More

$45 USD in 3 days
(0 Reviews)
0.0
$208 USD in 7 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$166 USD in 7 days
(0 Reviews)
0.0