I will clean and validate CSV data with a reusable python script
About this Gig
I will clean and validate one CSV file using rules we agree before work starts.
This package covers one UTF-8, comma-separated CSV with up to 100 rows and 20 columns:
- Trim surrounding spaces
- Check required fields
- Remove duplicates using your chosen key, keeping the first valid record
- Preserve text values such as leading-zero IDs
You will receive the cleaned CSV, a report of rejected/duplicate records, a reusable Python script, and running instructions. JSON export is included if requested.
Missing or uncertain values are flagged, not invented. I use AI-assisted development and test the outputs before delivery. The portfolio sample is an independent demonstration using synthetic data.
Please provide an anonymized sample and your required columns, duplicate key and processing rules. Do not send passwords, API keys or sensitive personal data.
XLSX, PDF/OCR, scraping, fuzzy matching, complex date inference, API integration and live-system deployment are outside this package.
FAQ
What files and cleaning rules are included?
One UTF-8, comma-separated CSV, up to 100 rows and 20 columns. Please specify required fields and the duplicate key. I trim spaces, flag invalid rows and remove exact-key duplicates. XLSX, PDF/OCR, scraping and fuzzy matching are not included.
What will I receive, and what does a revision cover?
You receive a cleaned CSV, a validation report, Python source code and running instructions. JSON export is available on request. One revision covers corrections against the original agreed rules. New data or new requirements may require a separate order.
