I will clean and standardize your messy spreadsheet or CSV

China

I speak Chinese, English

Python developer: data cleaning, LLM tools, technical documentation

I build small things that work, not large things that nearly work. Recent: a GPU compiler backend (kernel IR to PTX, 15/15 official problems passing on two GPUs), a federated learning pipeline liftin...
About this Gig

Most spreadsheet problems are not formatting problems. They are "nobody wrote down what this column means" problems.


WHAT I DO

I take one messy file and give you back a clean one, plus a short note saying exactly what changed. Dates in one format, numbers stored as numbers, whitespace gone, duplicates collapsed, spelling variants of the same value merged into one.


WHAT YOU GET

- the cleaned file, original untouched

- a change log: column by column, what changed and what I deliberately left alone

- the Python script, if the cleanup has to run again next month


WHAT I DO NOT DO

- invent missing values. If it cannot be derived from the file, I flag it instead of guessing

- turn formulas into pasted values

- touch your source file


WHAT I NEED FROM YOU

One file, plus one sentence: what you are going to do with the cleaned data. That sentence decides how I normalise things.


Files over 1,000 rows: message me before ordering so I can price it properly.


Python, pandas, Excel. Repeatable output, not a one-off fix.