Data cleaning is one of the least enjoyable tasks for data professionals. Unfortunately, most data scientists I have spoken to state that data cleaning makes of 60% to 70% of their work load.
While there is no magic data cleaning machine I am aware of, there are some tips and tricks that you can learn to save you a lot of time and head aches. I have put together a 2 part video series using Excel that shows some of the most common data cleaning tasks:
- Handling Duplicates
- Spelling Errors
- Missing Data
- Converting Data
- Merging Data Sets
I even have the Excel worksheet available for download so you can work along with the videos.
Download the file here: Data Cleaning
Videos
Below, you will find the links to my videos (video opens in new tab)
Excel: Data Cleaning with Excel Part 1
Excel: Data Cleaning with Excel Part 2
If you enjoyed this lesson, click LIKE below, or better yet, leave me a COMMENT.
Follow this link for more Excel content: Excel