Task 2: Cleaning Data

This second task of this assignment is to clean your data! You should feel comfortable beginning this task after you have completed Chapter 20: Cleaning Data with Pandas.

When cleaning the datasets, you may find that there isn’t dirty data to clean. That is okay! Below are some questions you need to answer about the data sets.

Question

Is there any missing data and if yes explain what you would do with the missing data and why?

Question

In the North data set, there are two separate “YES” values for a sale. Why and how did you rectify the issue?

Question

Are there duplicates in the two data sets? If there are, how did you handle them?

Question

Is any of the data in the two data sets unnecessary? If yes, how did you handle it?