I will clean and deduplicate your messy excel or csv data
Web Scraping and Python Specialist
Sobre este Serviço
Send me the messy file. I send back one you can actually use.
Free 100-row sample first.
I clean and standardise data with Python and pandas, then hand you a
file that imports without errors.
What I fix:
- Duplicate rows, matched on the fields that actually identify a
record, not just exact matches
- Dates, currencies, and units standardised to one format
- Broken encoding and stray characters repaired
- Columns split, merged, or renamed to your schema
- Multiple files merged into one consistent sheet
Validation, not just tidying: on a recent job I ran EAN-13 check-digit
validation and deduplicated on unique IDs, then split the output into
verified rows and rows needing a human look. You know exactly what you
can trust.
Formats: CSV, Excel, JSON, TSV in and out. Premium includes a reusable
Python script so you can re-run the same cleaning yourself next month.
Send the file and tell me what "clean" means for your use case. I'll
clean 100 rows free so you can see the before and after.
Meu portfólio
Perguntas frequentes
What is the row limit?
See the packages. Larger sets fit Premium; message me for anything unusually large.
What formats do you accept?
CSV, Excel, JSON, or TSV.
Can you validate against my rules?
Yes. I have built check-digit and format validation before, and can apply your specific rules on Premium.
How fast?
Basic in 1 day, most jobs within 2 to 3.
Can I re-run the cleaning myself later?
On Premium I deliver a reusable script.

