Transform a large data set in Python

Encerrado

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!

Habilidades: Python

Ver mais: 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

ID do Projeto: #13801153

23 freelancers estão ofertando em média $179 para este trabalho

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 Mais

$200 USD in 2 dias
(21 Comentários)
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 dias
(14 Comentários)
4.5
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 Mais

$170 USD in 3 dias
(11 Comentários)
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 Mais

$277 USD in 3 dias
(6 Comentários)
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 dias
(9 Comentários)
3.8
$250 USD in 3 dias
(3 Comentários)
4.0
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 Mais

$155 USD in 3 dias
(5 Comentários)
4.0
$200 USD in 3 dias
(12 Comentários)
4.1
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 Mais

$160 USD in 7 dias
(1 Comentário)
2.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 Mais

$150 USD in 4 dias
(3 Comentários)
2.0
$100 USD in 3 dias
(1 Comentário)
1.4
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 Mais

$250 USD in 5 dias
(2 Comentários)
1.0
$255 USD in 5 dias
(0 Comentários)
0.0
$155 USD in 3 dias
(0 Comentários)
0.0
$155 USD in 3 dias
(0 Comentários)
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 Mais

$250 USD in 3 dias
(0 Comentários)
0.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 Mais

$150 USD in 7 dias
(8 Comentários)
0.0
$208 USD in 7 dias
(0 Comentários)
0.0
Robertxs

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 dias
(0 Comentários)
0.0
mlucasdtn

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 Mais

$222 USD in 3 dias
(0 Comentários)
0.0