Get startedGet started for free

Calculating a normalized metric

Now you are ready to divide the number of building permits issued for projects in each council district by the area of that district to get a normalized value for the permits issued. First you will verify that the districts_and_permits is still a GeoDataFrame.

This exercise is part of the course

Visualizing Geospatial Data in Python

View Course

Exercise instructions

  • Print the type() of districts_and_permits.
  • Add one more column to districts_and_permits. Use a lambda expression and the pandas apply() method to divide the number of building permits issued for projects in each council district by the area of that district to get a normalized value for the permits issued.
  • Print the first five rows of districts_and_permits.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Print the type of districts_and_permits
print(____(____))

# Create permit_density column in districts_and_permits
districts_and_permits['permit_density'] = districts_and_permits.apply(lambda row: row._____ / row._____, axis = 1)

# Print the head of districts_and_permits
print(____.____())
Edit and Run Code