Building a polished Geopandas choropleth

After merging the counts_df with permits_by_district, you will create a column with normalized permit_density by dividing the count of permits in each council district by the area of that council district. Then you will plot your final geopandas choropleth of the building projects in each council district.

Diese Übung ist Teil des Kurses

Visualizing Geospatial Data in Python

Kurs anzeigen

Anleitung zur Übung

Merge permits_by_district and counts_df on district to create districts_and_permits.
Using apply() and a lambda expression, calculate a new column in districts_and_permits called permit_density. Divide counts by areas.
Plot a choropleth of the districts_and_permits, using permit_density with the OrRd colormap, and black outlines.
Add axis labels (longitude and latitude) and the title provided. Show your plot.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

# Merge permits_by_district and counts_df
districts_and_permits = pd.merge(____, ____, on = ____)

# Create permit_density column
districts_and_permits['permit_density'] = districts_and_permits.apply(lambda row: row.____ / row.____, axis = 1)
print(districts_and_permits.head(2))

# Create choropleth plot
districts_and_permits.plot(column = ____, ____ = 'OrRd', ____ = 'black', legend = True)

# Add axis labels and title
plt.xlabel(____)
plt.ylabel(____)
plt.title('2017 Building Project Density by Council District')
plt.show()

Code bearbeiten und ausführen