- In this project, a customer data set is cleaned using MS Excel.
- Some important steps included in the data cleaning process are: spelling checking, removal of empty rows and duplicate rows, using find and replace to mention appropriate values, applying string functions, trimming white spaces
- The workbook contains two worksheets, one with the original data and other post cleaning process, so that the changes can be seen and compared.
-
Notifications
You must be signed in to change notification settings - Fork 0
prabhuti-b/Data-Cleaning-in-MS-Excel
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Data Cleaning in MS Excel - Customer Data
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published