I will clean and validate your excel or CSV data with python
About this Gig
I will clean and validate your Excel or CSV data using Python.
I can remove exact duplicates, standardize dates and text, check missing or invalid values, and correct errors using agreed rules or reference data. Conflicting records and unresolved values are flagged for review.
You receive cleaned files and an issue summary explaining what changed. Premium also includes a reusable Python script and running instructions.
Basic: 1 file/sheet, up to 100 rows and 3 rules.
Standard: up to 2 files/sheets, 200 rows total and 5 rules.
Premium: up to 3 files/sheets, 300 rows total and 8 rules.
Each file/sheet may contain up to 15 columns. One Excel worksheet counts as one file.
One revision is included within the original scope. New files, additional rules, integrations and deployment require a separate quote.
Please message me before ordering with an anonymized sample, file and sheet counts, row and column counts, cleaning rules, desired output and deadline. I will review the sample and confirm the scope before we start.

