I will clean and organise your excel and CSV data

Portugal

I speak English, Portuguese

Freelance Data Analyst

I am an Electrical Engineering graduate and Freelance Data Analyst with hands-on experience cleaning, validating, and analysing tabular data using Python, pandas, Excel, and SQL. I help turn messy spr...
About this Gig

I clean and organise Excel (.xlsx) and CSV files using Python and pandas, so your data is ready for reporting or analysis.


I can remove duplicate rows based on the columns you specify, tidy column headings and text, and standardise date and number formats. The Standard package also flags missing values. Premium includes validation against your agreed rules and a short summary of the changes.


Basic 1 file, up to 1,000 rows.

Standard up to 3 files and 5,000 rows in total.

Premium up to 5 files and 15,000 rows in total.


Row limits apply across all files and worksheets, excluding headers. I deliver the cleaned data in Excel or CSV format. Revisions cover the original files and the agreed cleaning rules.


Before ordering, please tell me which files and worksheets to include, what needs cleaning and which output format you prefer.

Platform:

Excel

•

LibreOffice

•

Jupyter Notebook

Development technology:

Python

•

Excel

Expertise:

Formatting

•

Fixing

•

Formulas

•

Cleaning

•

Data validation