Clean & Format Mixed Dataset
Budget: ₹750 – ₹1,250 INR
I have a collection of spreadsheets and CSV files containing both text fields and numeric columns. The raw tables need thorough data cleaning and formatting so I can run reliable analytics on them.
Your task is strictly data cleaning and formatting—no new data has to be gathered or scraped. The dataset is mixed, with product descriptions, dates, IDs, and several numeric measures. Typical issues you will encounter include inconsistent date styles, extra white-spaces, misplaced decimal separators, and occasional duplicate rows.
I will provide the raw files and a short data dictionary. I need you to:
• remove duplicates
• standardise dates, currency, and percentage formats
• trim stray spaces and fix obvious typos without altering meaning
• verify numeric columns remain numeric after re-formatting
• return one polished file per original source, plus a combined master sheet
Deliverables should come back in the same file formats (mainly Excel and CSV), ready for immediate upload to my BI tool. Please let me know how soon you can start and your estimated turnaround time for the first batch.
Your task is strictly data cleaning and formatting—no new data has to be gathered or scraped. The dataset is mixed, with product descriptions, dates, IDs, and several numeric measures. Typical issues you will encounter include inconsistent date styles, extra white-spaces, misplaced decimal separators, and occasional duplicate rows.
I will provide the raw files and a short data dictionary. I need you to:
• remove duplicates
• standardise dates, currency, and percentage formats
• trim stray spaces and fix obvious typos without altering meaning
• verify numeric columns remain numeric after re-formatting
• return one polished file per original source, plus a combined master sheet
Deliverables should come back in the same file formats (mainly Excel and CSV), ready for immediate upload to my BI tool. Please let me know how soon you can start and your estimated turnaround time for the first batch.
Related categories:
Python
Data Processing
Data Entry
Excel
Data Visualization
Data Analysis
Data Integration
Data Management