I will clean messy csv and excel data

China

I speak Chinese

Data Cleaning Specialist

I clean messy data and automate repetitive file work. What I do: - Remove duplicates, fix broken dates/numbers, unify units - Normalize text, strip emojis, merge or split columns - Turn messy CSV/Exc...
About this Gig

You send a messy CSV or Excel file. You get back a clean table, a conflicts sheet, and a validation report you can check.


What I clean:

- Duplicates: the same order/ID appearing more than once

- Dates written in several different formats

- Numbers with mixed units (yuan vs thousand yuan, commas, spaces)

- Text with emojis, full-width spaces, inconsistent case

- Columns that need merging or splitting


How I work:

1. You send a sample (20-50 rows).

2. I write the rules down and send them to you for confirmation.

3. I run the cleaning script and send back three files: the clean data, a conflicts sheet (anything I refused to guess), and a validation report (rows before/after, what changed, checks passed).


What I do not do:

- I do not guess values. If a rule is ambiguous, it goes into the conflicts sheet.

- I do not modify your original file; you get a new one.


Deliverable: .xlsx or .csv + a short report (PDF or Markdown).


My Portfolio