Aggregating points within polygons
Now that you have spatially joined art
and neighborhoods
, you can group, aggregate, and sort the data to find which neighborhood has the most public art. You can count artwork titles to see how many artworks are in each neighborhood.
This exercise is part of the course
Visualizing Geospatial Data in Python
Exercise instructions
- Get just
name
andtitle
fromneighborhood_art
and then group by each neighborhood's name (name
). Save this asneighborhood_art_grouped
- Aggregate
neighborhood_art_grouped
to see how many artworks are within each polygon. Use the.agg('count')
function to get a count of art in each neighborhood and sort the results with.sort_values()
, sortingby
title
withascending
set toFalse
. Print it.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Get name and title from neighborhood_art and group by name
neighborhood_art_grouped = neighborhood_art[['name', 'title']].groupby(____)
# Aggregate the grouped data and count the artworks within each polygon
print(____.agg('count').sort_values(by = ____, ascending = False))