Activity 8: Handling Outliers and Missing Data

In this activity, we will identify and get rid of outliers. Here, we have a CSV file. The goal here is to clean the data by using the knowledge that we have learned about so far and come up with a nicely formatted DataFrame. Identify the type of outliers and their effect on the data and clean the messy data.

The steps that will help you solve this activity are as follows:

1. Read the visit_data.csv file.

2. Check for duplicates.

3. Check if any essential column contains NaN.

4. Get rid of the outliers.

5. Report the size difference.

6. Create a box plot to check for outliers.

7. Get rid of any outliers.

Note

The solution for this activity can be found on page 312.