Recommended Workflow
Original Data
↓
Check Duplicates
↓
Highlight Problems
↓
Remove Duplicates
↓
Clean Spaces
↓
Standardize Text
↓
Check Missing Data
↓
Verify Data Types
↓
Final Clean Dataset
Example
Before cleaning:
|
Customer |
City |
Product |
Sales |
|
Amit |
sirsa |
Keyboard |
4000 |
|
Neha |
Hisar |
Mouse |
5000 |
|
Amit |
SIRSA |
Keyboard |
4000 |
|
Rahul |
Sirsa |
Monitor |
25500 |
After cleaning:
|
Customer |
City |
Product |
Sales |
|
Amit |
Sirsa |
Keyboard |
4000 |
|
Neha |
Hisar |
Mouse |
5000 |
|
Rahul |
Sirsa |
Monitor |
25500 |
Practice
Create a complete clean-data workflow using the practice dataset.