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.
Bu egzersiz
Visualizing Geospatial Data in Python
kursunun bir parçasıdırEgzersiz talimatları
- Get just
nameandtitlefromneighborhood_artand then group by each neighborhood's name (name). Save this asneighborhood_art_grouped - Aggregate
neighborhood_art_groupedto 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(), sortingbytitlewithascendingset toFalse. Print it.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# 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))