Transform a large data set in Python

Closed

Mô tả

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!

Kỹ năng: Python

Xem thêm: 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

Mã Dự Án: #13801153

23 freelancer đang chào giá trung bình $179 cho công việc này

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 Thêm

$200 USD trong 2 ngày
(21 Đánh Giá)
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 trong 5 ngày
(14 Đánh Giá)
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 Thêm

$170 USD trong 3 ngày
(11 Đánh Giá)
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 Thêm

$277 USD trong 3 ngày
(6 Đánh Giá)
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 trong 3 ngày
(9 Đánh Giá)
3.8
$250 USD trong 3 ngày
(3 Đánh Giá)
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 Thêm

$155 USD trong 3 ngày
(5 Đánh Giá)
4.0
$200 USD trong 3 ngày
(12 Đánh Giá)
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 Thêm

$160 USD trong 7 ngày
(1 Đánh Giá)
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 Thêm

$150 USD trong 4 ngày
(3 Đánh Giá)
2.0
$100 USD trong 3 ngày
(1 Đánh Giá)
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 Thêm

$250 USD trong 5 ngày
(2 Đánh Giá)
1.0
$255 USD trong 5 ngày
(0 Đánh Giá)
0.0
$155 USD trong 3 ngày
(0 Đánh Giá)
0.0
$155 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$250 USD trong 3 ngày
(0 Đánh Giá)
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 Thêm

$150 USD trong 7 ngày
(8 Đánh Giá)
0.0
$208 USD trong 7 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
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 Thêm

$222 USD trong 3 ngày
(0 Đánh Giá)
0.0