I will clean, merge, and deduplicate your excel or CSV data
Python automation for Excel and CSV cleanup, reports and backtests
About this Gig
Messy exports can hide duplicate records, inconsistent dates, missing IDs, and mismatched columns. I will clean and combine your Excel or CSV files using business rules we agree on before processing.
I can standardize columns and formats, merge files, remove exact duplicates, and flag uncertain matches for review instead of silently deleting them. You will receive cleaned data plus an exceptions and validation summary showing input/output row counts and issues found. Premium also includes a reusable Python/pandas script with run instructions.
Basic: 1 file, up to 100 rows. Standard: up to 3 files, 5,000 total rows. Premium: up to 5 files, 10,000 total rows. These are package limits; More than 10,000 rows? Message me. Large files are usually no problem, and I'll send you a custom offer.
Please provide the duplicate keys, preferred record when values conflict, and desired output format. I work with tabular files you own or are authorized to use. PDF/OCR conversion, web scraping, manual entry, and third-party enrichment are outside this Gig. Complex fuzzy matching needs a custom scope.
FAQ
Will you delete possible duplicates automatically?
Only when they match the duplicate rule we agree on. Ambiguous matches are listed for your review rather than silently removed.
Is the Python script included?
The reusable Python/pandas script and run instructions are included in Premium. Basic and Standard deliver processed files and quality notes.
