I will clean excel and CSV files and remove duplicates
Data Analyst, R, Python, Data Cleaning and Visualization
About this Gig
Send me your Excel or CSV files and I will return a clean dataset with a clear record of what changed.
I can remove duplicates using agreed keys, standardize dates, numbers and labels, fix whitespace and column names, and flag missing values or handle them using your rules. I can combine compatible files into one output when the package allows it and we agree on how to match them.
You get a clean Excel or CSV file and a change log with before-and-after row counts, duplicates removed and missing values flagged. Premium also includes a reusable R or Python script and setup notes.
Basic: 1 file, up to 100 rows and 10 columns. Standard: up to 2 files, 1,000 rows total and 20 columns. Premium: up to 3 files, 3,000 rows total and 30 columns.
For a custom cleanup, message me with an anonymized sample, your rules and your deadline. I work in English and Chinese.
FAQ
What counts as an item in a package?
One data row counts as one item. Row limits apply across all included files. Basic covers 10 columns, Standard 20 and Premium 30. Send a small anonymized sample so I can confirm the package before you order.
How do you handle missing values and uncertain records?
I flag missing or inconsistent values and review the rules with you. Any replacement, recoding or row removal follows the agreed instructions and is recorded in the change summary.

