I will excel data cleaning and formatting using python
Python Data Cleaning and Automation
About this Gig
Messy Excel file slowing you down?
I clean and format Excel files using Python (pandas) fixing duplicates, inconsistent formatting, blank fields, and mismatched dates faster and more reliably than manual spreadsheet work. CSV files welcome too.
What I fix:
- Duplicate entries and rows
- Inconsistent formatting (dates, currency, capitalization)
- Missing or blank values
- Multiple files merged into one clean sheet
Packages at a glance:
- Quick Clean one file, up to 1,200 - 1,300 rows, duplicates/formatting/blanks fixed
- Full Clean & Merge up to 3 files merged, up to 5,000 rows, plus basic summary stats
- Clean + Script + Report up to 20,000 rows, the Python script used, and a full written explanation
Want the reusable Python script on Quick Clean or Full Clean & Merge? Add it as an extra.
I'm building my Python data track alongside my science degree, and I test every script against your actual file before delivery anything unclear gets flagged for your input rather than guessed at, never silently assumed.
Not sure which package fits your file? Message me your row count and what's wrong with the data, and I'll point you to the right one before you order.
My Portfolio
FAQ
Do you work with CSV files too, or only Excel?
Yes. CSV, XLSX, and XLS are all fine. Just let me know the format when you order.
What if my file has more rows than the package I ordered?
Message me before ordering with your row count I'll tell you honestly which package fits, or if you need a custom quote.
Will I get the actual Python script used to clean my file?
It's included in Clean + Script + Report, and available as a paid add-on on the other two packages.
What if some data is missing and can't be cleaned automatically?
I flag it clearly in the delivery rather than guessing or deleting it, you decide how to handle it.
