I will clean, format, and merge your excel or CSV data
AI Automation, Framer Websites and Python Data Tools
About this Gig
Turn messy spreadsheets into clean, consistent data you can use.
I will clean Excel or CSV files using a repeatable Python and Pandas workflow where appropriate.
Cleaning can include:
Removing exact duplicate rows
Standardizing dates, numbers, text case, and whitespace
Correcting agreed formatting inconsistencies
Splitting or combining columns
Merging files using a confirmed matching key
Flagging missing or invalid values
Basic covers 1 file and up to 100 rows. Standard covers up to 3 files and 2,000 total rows. Premium covers up to 5 files and 5,000 total rows.
You receive the cleaned Excel or CSV file plus a brief summary of the work performed. I preserve the original columns unless we agree otherwise and never invent missing values without an approved rule.
Complex formulas, macros, dashboards, manual research, data entry, scraping, and confidential regulated data require a scope review.
Message me before ordering with sample rows, file count, total rows, and your expected output.
My Portfolio
FAQ
What should I send?
Send the files, total rows, known issues, cleaning rules, and your preferred output format.
How do you handle duplicates and missing data?
I remove duplicates using the columns or matching rules we agree on. I flag missing or invalid values and only fill them when you provide an approved rule or trusted reference.
Can you merge multiple Excel or CSV files?
Yes. Standard covers up to 3 files and Premium up to 5. The files need a reliable shared key or a clear matching rule. I will confirm the merge method before starting.

