Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Load and explore data. Conduct simple data analysis.
Check data quality – NAs and imputation
9. To NA or not to NA
Define customer activity levels
Congratulations

Instruction

Awesome! Now that we're familiar with our dataset, we'll begin defining customer activity levels. First, we'll need to ensure our data is of good quality.

Our company sells three categories of products: food, clothing, and accessories. The categories_3m and categories_6m columns denote how many categories of items a particular customer purchased from within the last 3 or 6 months, respectively.

For example, if a customer purchased only food (but not clothing or accessories) from our stores within the last 3 months, then categories_3m would equal 1 for that particular customer. The maximum value for both these columns is 3, since our company only sells 3 categories of products.

Exercise

Let's check the quality of the data in these two columns. Display the number of values that are missing from the categories_3m column.