I will clean, format and organize your messy excel or CSV data

United States

I speak English, Chinese

SelfDirected Futures Trader Quant Developer

I am a mathematics graduate and self-directed quantitative trader specializing in building Python tools for data cleaning, analysis, and strategy backtesting. I deliver automation scripts, Excel data ...
About this Gig

Messy spreadsheet? Duplicates, extra spaces, mixed date formats, broken phone numbers, codes nobody understands? I will turn it into a clean, consistent file you can sort, filter and pivot right away.


What I fix:

- Duplicates, blank rows, extra spaces

- Dates, numbers, phone numbers and text stored in the wrong format

- Inconsistent names and categories ("NY", "N.Y.", "new york")

- Split or merge columns, merge several files into one

- Missing values: flagged, never silently guessed


What you get:

- Cleaned Excel (.xlsx) or CSV, with filters and frozen headers

- A change log: every rule applied and how many rows it touched

- Premium: a Python script you can re-run on next month's file


I'm a math graduate (BS Mathematics, University at Buffalo) and I check every number before delivery. See the before/after sample in the gallery, built on 20,000 rows of public NYC data.


Please message me before ordering if your file is over 100,000 rows or needs custom rules.