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
Exercise instructions
- Print the
type()
ofdistricts_and_permits
. - Add one more column to
districts_and_permits
. Use a lambda expression and thepandas
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(____.____())