I will clean and validate CSV data with a reusable python script

China

I speak Chinese, English

Python Scripting and CSV Data Cleaning

I offer small Python scripts, CSV data cleaning, and CSV-to-JSON conversion. I can check required fields, remove duplicates using agreed keys, and provide a reusable script with a clear report and run...
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.