I will clean excel and CSV files and remove duplicates

China

I speak Chinese, English

Data Analyst, R, Python, Data Cleaning and Visualization

Turn your raw data into clean datasets, clear insights and polished charts. I provide R and Python data cleaning, statistical analysis, survival analysis, longitudinal analysis and ggplot2 visualizati...
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.