I will clean and deduplicate your CSV export with a change report
CSV cleanup and Python automation with AI assistance
About this Gig
Messy CSV exports can slow down imports and reporting. I will clean one CSV using agreed rules and provide a clear record of the changes. The starter package covers up to 100 rows and 15 columns: trim unwanted spaces in selected columns, standardize agreed text fields, remove exact duplicate rows, and flag missing values or conflicting records. You receive the cleaned CSV, review list, change log, summary, and a reusable Python script with your agreed rules. Running the script requires Python 3.10 or newer. Your source file stays unchanged. IDs stay as text in the CSV, including leading zeros. Conflicting records are retained for review. The script was developed with AI assistance. Basic email syntax checks are included when relevant; deliverability, web research, fuzzy matching, Excel workbooks, and database access are outside this package. Message before ordering to confirm scope and delivery. Larger files need a custom quote. Portfolio examples use synthetic data.
FAQ
Will you merge people who look similar?
Exact duplicate rows can be removed under the agreed rules. Similar or conflicting records are flagged and retained for review, with no guessed merges or invented missing data.
Do you use AI, and do I need Python?
The scripting workflow is AI-assisted. CSV processing runs in a local rules-based script. Running the reusable script yourself requires Python 3.10 or newer; receiving the cleaned CSV does not. This service cannot promise a non-AI workflow.
Can you verify that email addresses work?
Basic format checks can flag obvious syntax problems. They do not verify mailbox existence, identity, or deliverability. Web research and external email-verification services are outside this package.
What does the included revision cover?
One correction to the agreed cleanup rules on the original CSV is included. New data, extra columns, larger files, research, or new requirements need a new scope and quote. Please confirm your rules and deadline before ordering.
