Data Cleaning Before & After.
Before Cleaning
ID
Full Name
1 john Banda
2 mary lungu
peter mwale
4 IREEN ZULU
5 blessings CHIRWA
7 kabwe phiri
9 ESNART CHINTU
6 SALLY phiri
10 fridah kapasa
11 josehp kafula
13 david Chifu
Email
Phone--
peter@@example.com---
@example.com-
@example.com-
@example.com-
@example.com---
ord-1030
ord-1027
ord-1028
Order No.
ord-1023
ORD1024
ord-1026
ord-1027
Status
completed
pending
In progress
Completed
pending
compleeted
In progress
ord-1030
ord-1027
ord-1028
compleeted
After Cleaning
ID-
Full Name
John Banda
Mary Lungu
Peter Mwale
Ireen Zulu
Blessings Chirwa
kabwe phiri
Esnart Chintu
Sally Phiri
Fridah kapasa
Josehp Kafula
David Chifu
Email-----------
Contant No-
Order No.
ORD-1023
ORD-1024
ORD-1025
ORD-1026
ORD-1027
ORD-1028
ORD-1029
ORD-1030
ORD-1031
ORD-1032
ORD-1033
Status
Completed
Pending
In Progress
Completed
Pending
Completed
Completed
Pending
Completed
Pending
In Progress
Notes
Trimmed spaces, fixed casing
Standardized format
Fixed email, added missing ID
Added missing order number
Standardized spacing & casing
Added missing oder number
Standardized format
Standardized format
Added missing order number & Status
Fixed email
Status