1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Police Activity with pandas

Exercise

Comparing arrest rates by weather rating

Do police officers arrest drivers more often when the weather is bad? Let's find out!

  • First, you'll calculate the overall arrest rate.
  • Then, you'll calculate the arrest rate for each of the weather ratings you previously assigned.
  • Finally, you'll add violation type as a second factor in the analysis, to see if that accounts for any differences in the arrest rate.

Since you previously defined a logical order for the weather categories, good < bad < worse, they will be sorted that way in the results.

Instructions 1/3

undefined XP
  • 1

    Calculate the overall arrest rate by taking the mean of the is_arrested Series.

  • 2

    Calculate the arrest rate for each weather rating using a .groupby().

  • 3

    Calculate the arrest rate for each combination of violation and rating. How do the arrest rates differ by group?