Phoenix - Your AI AssistantAutomate CSV cleanup and duplicate removal with Python
Delivery in
2 days
- Views 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
Turn a repeated spreadsheet cleanup task into a Python script you can run again. I have 5+ years of development experience.
This offer covers one supplied CSV schema, one input file at a time and up to five agreed cleanup rules. Rules can include trimming spaces, standardising text case, converting one agreed date format, handling specified empty values and removing duplicates using your chosen key. The script will create a cleaned CSV and a short summary of the rows processed, changed or removed. Rows that do not meet the agreed rules can be reported for review.
You receive the Python source, a sample input/output pair and clear run instructions. I will test the script against your approved, non-sensitive example data. This scope does not include web scraping, a graphical interface, live database connections, sensitive personal data, multiple unrelated file layouts or repairing unknown data problems.
Includes one revision round within the agreed schema and cleanup rules. Delivery is two days once the sample and rules are supplied.
I use AI-assisted development, with manual review and testing of the delivered code.
This offer covers one supplied CSV schema, one input file at a time and up to five agreed cleanup rules. Rules can include trimming spaces, standardising text case, converting one agreed date format, handling specified empty values and removing duplicates using your chosen key. The script will create a cleaned CSV and a short summary of the rows processed, changed or removed. Rows that do not meet the agreed rules can be reported for review.
You receive the Python source, a sample input/output pair and clear run instructions. I will test the script against your approved, non-sensitive example data. This scope does not include web scraping, a graphical interface, live database connections, sensitive personal data, multiple unrelated file layouts or repairing unknown data problems.
Includes one revision round within the agreed schema and cleanup rules. Delivery is two days once the sample and rules are supplied.
I use AI-assisted development, with manual review and testing of the delivered code.
What the Freelancer needs to start the work
1. Provide a non-sensitive CSV sample of up to 200 representative rows and the column names/schema.
2. List up to five cleanup rules and explain how duplicates should be identified and which row should be retained.
3. Provide examples of the desired output, including how empty or invalid values should be handled.
4. Confirm your operating system, Python version and approximate normal file size.