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