1. Learn
    2. /
  2. Courses
    3. /
  3. Working with Categorical Data in Python

Exercise

Using pandas functions effectively

You are creating a Python application that will calculate summary statistics based on user-selected variables. The complete dataset is quite large. For now, you are setting up your code using part of the dataset, preloaded as adult. As you create a reusable process, make sure you are thinking through the most efficient way to setup the GroupBy object.

Instructions

100 XP
  • Create a list of the names for two user-selected variables: "Education" and "Above/Below 50k".
  • Create a GroupBy object, gb, using the user_list as the grouping variables.
  • Calculate the mean of "Hours/Week" across each group using the most efficient approach covered in the video.