I will clean and automate excel CSV and json data using python
About this Gig
Have messy Excel, CSV, or JSON data? I clean and organize structured files and create practical Python automations for repeatable tasks.
I can help with:
- Removing duplicate rows and normalizing column names, dates, and values
- Applying agreed rules for missing or inconsistent data
- Merging structured files and converting CSV, Excel, or JSON formats
- Checking data quality and supplying a concise results summary
- Building a reusable Python script with basic tests and instructions (Premium)
Packages:
Basic: one file, up to 1,000 rows.
Standard: up to three files, 5,000 rows in total.
Premium: up to three files, 10,000 rows in total, plus a reusable script.
Please send an anonymized sample, file formats, expected output, and cleanup rules before ordering. Never share passwords, API keys, or sensitive customer information.
My independent Python data-cleanup demo has nine passing automated tests; it is a portfolio example, not a paid client project. We agree on scope first and communicate by Fiverr text messages. Live system access, large migrations, and scraping are excluded unless separately scoped.
Technology:
Excel
•
Python
FAQ
Which file formats can you work with?
CSV, Excel (.xlsx), and structured JSON. Please send a small anonymized sample, field definitions, and your expected output before ordering.
Will I receive a script or only cleaned data?
Basic and Standard deliver cleaned files and a concise summary. Premium also includes a reusable Python script, basic tests, and setup notes for the agreed workflow.
Can you process sensitive data or access live systems?
Please anonymize private records; never share passwords or API keys. Live access, scraping, and regulated sensitive data are excluded unless separately reviewed and agreed.
