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!

22 freelancers are bidding on average $178 for this job

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 ReMore

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.

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 [url removed, login to view] science and analytics profeMore

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

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 EMore

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 pMore

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

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 skMore

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 DiploMore

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 eMore