I will clean and convert csv or json data with a reusable python script
About this Gig
Turn a small CSV or JSON file into clean, usable data, with a Python script you can run again.
The basic package covers ONE file of up to 1,000 records and 1 MB. Choose the steps you need:
- Convert CSV to JSON or a flat JSON array of records to CSV
- Trim extra whitespace from text fields
- Remove exact duplicate records while keeping the first occurrence
You receive the processed file, a readable Python script, and simple run instructions. I verify the result against the agreed rules and preserve your original file.
Please message me before ordering with a sanitized sample, the desired output format, and your rules for blank values and duplicates. Nested JSON, Excel workbooks, database connections, and complex data pipelines need a separate scope.
I use AI-assisted development and check the code and output with focused tests. The gallery example uses synthetic data and is a self-directed demonstration, not a client project. Please remove passwords, API keys, and private customer information from samples.
Technology:
Python
Expertise:
Data manipulation
•
Transformation
FAQ
Which formats are included?
Comma-separated UTF-8 CSV files and JSON arrays containing flat records with consistent fields. CSV values stay as text unless we agree otherwise. Nested JSON and XLSX files need a different scope.
Will I get a reusable script?
Yes. Delivery includes the processed file, readable Python code and run instructions. Tell me your Python version and operating system before ordering so we can confirm compatibility.
How are duplicates and missing values handled?
The default removes exact duplicate records after any agreed trimming, keeping the first record. Blank CSV fields remain empty strings. For JSON-to-CSV, we agree how to represent null values before work starts.
Do you use AI?
Yes, I use AI-assisted development and verify the resulting code and data. If your project prohibits AI assistance, please do not order this service.

