I will automate excel and CSV data processing with python
About this Gig
Need to clean an Excel or CSV file without repeating the same steps manually?
I will build a Python script to apply agreed cleaning rules and produce a usable output file.
This service includes:
- One Excel worksheet or CSV table, up to 5,000 rows and 20 columns
- - Up to three simple rules, such as removing duplicates, standardizing dates or trimming spaces
- - A reusable Python script and the processed output file
- - Setup and run instructions
- - One revision to align the delivery with the agreed rules
My background includes corporate data science, technical leadership and university teaching. I welcome small, clearly defined tasks.
Please share an anonymized sample, your cleaning rules and an example of the expected output before ordering if you are unsure about scope.
APIs, scraping, OCR, dashboards, deployment and changes to the original requirements need a separate scope.
Technology:
Excel
•
Python
Expertise:
Data manipulation
•
Data validation
•
Transformation
FAQ
What do you need to start?
An Excel or CSV file you are authorized to share, the cleaning rules and an example of the expected output. Use anonymized data where possible.
Can I run the script again?
Yes. Source code and instructions are included. Reuse assumes the same input structure and agreed rules.
What does a revision cover?
One adjustment to match the original requirements. New files, integrations or new rules require a separate scope.
Does this include Excel macros or APIs?
No. This Gig uses Python to process files. Macros, APIs and other integrations need a separate scope.
