I will clean, merge, and deduplicate your excel or CSV data

China

I speak English, Chinese

Python automation for Excel and CSV cleanup, reports and backtests

I clean, merge and automate data with Python. Typical jobs: messy Excel/CSV exports from shops, CRMs or accounting tools that need deduplicating, standardizing and combining, and monthly reports that ...
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.