I will clean and organise your excel and CSV data
About this Gig
I clean and organise Excel (.xlsx) and CSV files using Python and pandas, so your data is ready for reporting or analysis.
I can remove duplicate rows based on the columns you specify, tidy column headings and text, and standardise date and number formats. The Standard package also flags missing values. Premium includes validation against your agreed rules and a short summary of the changes.
Basic 1 file, up to 1,000 rows.
Standard up to 3 files and 5,000 rows in total.
Premium up to 5 files and 15,000 rows in total.
Row limits apply across all files and worksheets, excluding headers. I deliver the cleaned data in Excel or CSV format. Revisions cover the original files and the agreed cleaning rules.
Before ordering, please tell me which files and worksheets to include, what needs cleaning and which output format you prefer.
Platform:
Excel
•
LibreOffice
•
Jupyter Notebook
Development technology:
Python
•
Excel
Expertise:
Formatting
•
Fixing
•
Formulas
•
Cleaning
•
Data validation

