{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# The Battle of Neighborhoods " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", " | Incident Datetime | \n", "Incident Date | \n", "Incident Time | \n", "Incident Year | \n", "Incident Day of Week | \n", "Report Datetime | \n", "Row ID | \n", "Incident ID | \n", "Incident Number | \n", "CAD Number | \n", "Report Type Code | \n", "Report Type Description | \n", "Filed Online | \n", "Incident Code | \n", "Incident Category | \n", "Incident Subcategory | \n", "Incident Description | \n", "Resolution | \n", "Intersection | \n", "CNN | \n", "Police District | \n", "Analysis Neighborhood | \n", "Supervisor District | \n", "Latitude | \n", "Longitude | \n", "point | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2018/01/01 01:30:00 AM | \n", "2018/01/01 | \n", "01:30 | \n", "2018 | \n", "Monday | \n", "2018/01/01 02:13:00 AM | \n", "61870203073 | \n", "618702 | \n", "180000263 | \n", "180010563.0 | \n", "II | \n", "Initial | \n", "NaN | \n", "3073 | \n", "Robbery | \n", "Robbery - Other | \n", "Robbery, W/ Other Weapon | \n", "Open or Active | \n", "JUSTIN DR \\ COLLEGE AVE | \n", "21236000.0 | \n", "Ingleside | \n", "Bernal Heights | \n", "9.0 | \n", "37.732261 | \n", "-122.423486 | \n", "(37.732261252752224, -122.42348641495892) | \n", "
1 | \n", "2018/01/01 01:59:00 AM | \n", "2018/01/01 | \n", "01:59 | \n", "2018 | \n", "Monday | \n", "2018/01/01 01:59:00 AM | \n", "61870768000 | \n", "618707 | \n", "180000326 | \n", "180010504.0 | \n", "II | \n", "Initial | \n", "NaN | \n", "68000 | \n", "Fire Report | \n", "Fire Report | \n", "Fire Report | \n", "Open or Active | \n", "16TH ST \\ MISSION ST | \n", "24170000.0 | \n", "Mission | \n", "Mission | \n", "9.0 | \n", "37.765051 | \n", "-122.419669 | \n", "(37.76505133632968, -122.41966897380142) | \n", "
2 | \n", "2018/01/01 02:28:00 AM | \n", "2018/01/01 | \n", "02:28 | \n", "2018 | \n", "Monday | \n", "2018/01/01 02:31:00 AM | \n", "61870904134 | \n", "618709 | \n", "180000348 | \n", "180010636.0 | \n", "II | \n", "Initial | \n", "NaN | \n", "4134 | \n", "Assault | \n", "Simple Assault | \n", "Battery | \n", "Open or Active | \n", "03RD ST \\ PERRY ST | \n", "20657000.0 | \n", "Southern | \n", "South of Market | \n", "6.0 | \n", "37.782119 | \n", "-122.396841 | \n", "(37.78211912156566, -122.39684142850209) | \n", "
3 | \n", "2018/01/01 02:28:00 AM | \n", "2018/01/01 | \n", "02:28 | \n", "2018 | \n", "Monday | \n", "2018/01/01 02:31:00 AM | \n", "61870928160 | \n", "618709 | \n", "180000348 | \n", "180010636.0 | \n", "II | \n", "Initial | \n", "NaN | \n", "28160 | \n", "Malicious Mischief | \n", "Vandalism | \n", "Malicious Mischief, Vandalism to Vehicle | \n", "Open or Active | \n", "03RD ST \\ PERRY ST | \n", "20657000.0 | \n", "Southern | \n", "South of Market | \n", "6.0 | \n", "37.782119 | \n", "-122.396841 | \n", "(37.78211912156566, -122.39684142850209) | \n", "
4 | \n", "2018/01/01 02:08:00 AM | \n", "2018/01/01 | \n", "02:08 | \n", "2018 | \n", "Monday | \n", "2018/01/01 02:08:00 AM | \n", "61871004014 | \n", "618710 | \n", "180000285 | \n", "180010537.0 | \n", "II | \n", "Initial | \n", "NaN | \n", "4014 | \n", "Assault | \n", "Aggravated Assault | \n", "Assault, Aggravated, W/ Force | \n", "Cite or Arrest Adult | \n", "CESAR CHAVEZ ST \\ CAPP ST \\ MISSION ST | \n", "21304000.0 | \n", "Mission | \n", "Bernal Heights | \n", "9.0 | \n", "37.748166 | \n", "-122.418221 | \n", "(37.74816568813204, -122.41822117169174) | \n", "
\n", " | Incident Date | \n", "Incident Time | \n", "Incident Number | \n", "Incident Category | \n", "Police District | \n", "Latitude | \n", "Longitude | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "2018/01/01 | \n", "01:30 | \n", "180000263 | \n", "Robbery | \n", "Ingleside | \n", "37.732261 | \n", "-122.423486 | \n", "POINT (-122.4234864149589 37.73226125275223) | \n", "
1 | \n", "2018/01/01 | \n", "01:59 | \n", "180000326 | \n", "Fire Report | \n", "Mission | \n", "37.765051 | \n", "-122.419669 | \n", "POINT (-122.4196689738014 37.76505133632968) | \n", "
2 | \n", "2018/01/01 | \n", "02:28 | \n", "180000348 | \n", "Assault | \n", "Southern | \n", "37.782119 | \n", "-122.396841 | \n", "POINT (-122.3968414285021 37.78211912156566) | \n", "
3 | \n", "2018/01/01 | \n", "02:28 | \n", "180000348 | \n", "Malicious Mischief | \n", "Southern | \n", "37.782119 | \n", "-122.396841 | \n", "POINT (-122.3968414285021 37.78211912156566) | \n", "
4 | \n", "2018/01/01 | \n", "02:08 | \n", "180000285 | \n", "Assault | \n", "Mission | \n", "37.748166 | \n", "-122.418221 | \n", "POINT (-122.4182211716917 37.74816568813204) | \n", "
\n", " | nbrhood | \n", "nid | \n", "sfar_distr | \n", "geometry | \n", "
---|---|---|---|---|
0 | \n", "Alamo Square | \n", "6e | \n", "District 6 - Central North | \n", "POLYGON ((-122.4294839489174 37.77509623070431... | \n", "
1 | \n", "Anza Vista | \n", "6a | \n", "District 6 - Central North | \n", "POLYGON ((-122.4474643913587 37.77986335309237... | \n", "
2 | \n", "Balboa Terrace | \n", "4a | \n", "District 4 - Twin Peaks West | \n", "POLYGON ((-122.464508862148 37.73220849554402,... | \n", "
3 | \n", "Bayview | \n", "10a | \n", "District 10 - Southeast | \n", "POLYGON ((-122.38758527039 37.7502633777501, -... | \n", "
4 | \n", "Bernal Heights | \n", "9a | \n", "District 9 - Central East | \n", "POLYGON ((-122.4037549223623 37.74919006373567... | \n", "
\n", " | nbrhood | \n", "incident_counts | \n", "
---|---|---|
0 | \n", "Alamo Square | \n", "687 | \n", "
1 | \n", "Anza Vista | \n", "310 | \n", "
2 | \n", "Balboa Terrace | \n", "49 | \n", "
3 | \n", "Bayview | \n", "3185 | \n", "
4 | \n", "Bayview Heights | \n", "253 | \n", "
\n", " | nbrhood | \n", "nid | \n", "sfar_distr | \n", "geometry | \n", "incident_counts | \n", "
---|---|---|---|---|---|
0 | \n", "Alamo Square | \n", "6e | \n", "District 6 - Central North | \n", "POLYGON ((-122.4294839489174 37.77509623070431... | \n", "687 | \n", "
1 | \n", "Anza Vista | \n", "6a | \n", "District 6 - Central North | \n", "POLYGON ((-122.4474643913587 37.77986335309237... | \n", "310 | \n", "
2 | \n", "Balboa Terrace | \n", "4a | \n", "District 4 - Twin Peaks West | \n", "POLYGON ((-122.464508862148 37.73220849554402,... | \n", "49 | \n", "
3 | \n", "Bayview | \n", "10a | \n", "District 10 - Southeast | \n", "POLYGON ((-122.38758527039 37.7502633777501, -... | \n", "3185 | \n", "
4 | \n", "Bernal Heights | \n", "9a | \n", "District 9 - Central East | \n", "POLYGON ((-122.4037549223623 37.74919006373567... | \n", "1561 | \n", "
\n", " | Block and Lot Number | \n", "Closed Roll Assessed Fixtures Value | \n", "Closed Roll Assessed Improvement Value | \n", "Closed Roll Assessed Land Value | \n", "Closed Roll Assessed Personal Prop Value | \n", "Neighborhoods - Analysis Boundaries | \n", "Location | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "3751435 | \n", "0.0 | \n", "149168.0 | \n", "149168.0 | \n", "0.0 | \n", "South of Market | \n", "(37.7816504619473, -122.399116945614) | \n", "298336.0 | \n", "
2 | \n", "6276009 | \n", "0.0 | \n", "270000.0 | \n", "405000.0 | \n", "0.0 | \n", "Excelsior | \n", "(37.7190514589638, -122.433999199176) | \n", "675000.0 | \n", "
3 | \n", "3751420 | \n", "0.0 | \n", "128078.0 | \n", "128078.0 | \n", "0.0 | \n", "South of Market | \n", "(37.7816504619473, -122.399116945614) | \n", "256156.0 | \n", "
4 | \n", "7517378 | \n", "0.0 | \n", "129545.0 | \n", "141594.0 | \n", "0.0 | \n", "Noe Valley | \n", "(37.7463212609468, -122.441519528492) | \n", "271139.0 | \n", "
5 | \n", "3735098 | \n", "0.0 | \n", "336716.0 | \n", "336716.0 | \n", "0.0 | \n", "Financial District/South Beach | \n", "(37.7857477114134, -122.397398669759) | \n", "673432.0 | \n", "
\n", " | Block and Lot Number | \n", "Neighborhoods - Analysis Boundaries | \n", "total_price | \n", "Latitude | \n", "Longitude | \n", "
---|---|---|---|---|---|
0 | \n", "3751435 | \n", "South of Market | \n", "298336.0 | \n", "37.781650 | \n", "-122.399117 | \n", "
2 | \n", "6276009 | \n", "Excelsior | \n", "675000.0 | \n", "37.719051 | \n", "-122.433999 | \n", "
3 | \n", "3751420 | \n", "South of Market | \n", "256156.0 | \n", "37.781650 | \n", "-122.399117 | \n", "
4 | \n", "7517378 | \n", "Noe Valley | \n", "271139.0 | \n", "37.746321 | \n", "-122.441520 | \n", "
5 | \n", "3735098 | \n", "Financial District/South Beach | \n", "673432.0 | \n", "37.785748 | \n", "-122.397399 | \n", "
\n", " | Block and Lot Number | \n", "Neighborhoods - Analysis Boundaries | \n", "total_price | \n", "Latitude | \n", "Longitude | \n", "geometry | \n", "
---|---|---|---|---|---|---|
0 | \n", "3751435 | \n", "South of Market | \n", "298336.0 | \n", "37.781650 | \n", "-122.399117 | \n", "POINT (-122.399116945614 37.7816504619473) | \n", "
2 | \n", "6276009 | \n", "Excelsior | \n", "675000.0 | \n", "37.719051 | \n", "-122.433999 | \n", "POINT (-122.433999199176 37.7190514589638) | \n", "
3 | \n", "3751420 | \n", "South of Market | \n", "256156.0 | \n", "37.781650 | \n", "-122.399117 | \n", "POINT (-122.399116945614 37.7816504619473) | \n", "
4 | \n", "7517378 | \n", "Noe Valley | \n", "271139.0 | \n", "37.746321 | \n", "-122.441520 | \n", "POINT (-122.441519528492 37.7463212609468) | \n", "
5 | \n", "3735098 | \n", "Financial District/South Beach | \n", "673432.0 | \n", "37.785748 | \n", "-122.397399 | \n", "POINT (-122.397398669759 37.7857477114134) | \n", "
\n", " | nbrhood | \n", "house_avg_price | \n", "
---|---|---|
0 | \n", "Alamo Square | \n", "0.862016 | \n", "
1 | \n", "Anza Vista | \n", "1.121534 | \n", "
2 | \n", "Balboa Terrace | \n", "0.737963 | \n", "
3 | \n", "Bayview | \n", "0.439684 | \n", "
4 | \n", "Bayview Heights | \n", "0.296895 | \n", "
\n", " | nbrhood | \n", "nid | \n", "sfar_distr | \n", "geometry | \n", "incident_counts | \n", "house_avg_price | \n", "
---|---|---|---|---|---|---|
0 | \n", "Alamo Square | \n", "6e | \n", "District 6 - Central North | \n", "POLYGON ((-122.4294839489174 37.77509623070431... | \n", "687 | \n", "0.862016 | \n", "
1 | \n", "Anza Vista | \n", "6a | \n", "District 6 - Central North | \n", "POLYGON ((-122.4474643913587 37.77986335309237... | \n", "310 | \n", "1.121534 | \n", "
2 | \n", "Balboa Terrace | \n", "4a | \n", "District 4 - Twin Peaks West | \n", "POLYGON ((-122.464508862148 37.73220849554402,... | \n", "49 | \n", "0.737963 | \n", "
3 | \n", "Bayview | \n", "10a | \n", "District 10 - Southeast | \n", "POLYGON ((-122.38758527039 37.7502633777501, -... | \n", "3185 | \n", "0.439684 | \n", "
4 | \n", "Bernal Heights | \n", "9a | \n", "District 9 - Central East | \n", "POLYGON ((-122.4037549223623 37.74919006373567... | \n", "1561 | \n", "0.448200 | \n", "
\n", " | nbrhood | \n", "incident_counts | \n", "house_avg_price | \n", "Latitude | \n", "Longitude | \n", "
---|---|---|---|---|---|
0 | \n", "Alamo Square | \n", "687 | \n", "0.862016 | \n", "37.776076 | \n", "-122.433919 | \n", "
1 | \n", "Anza Vista | \n", "310 | \n", "1.121534 | \n", "37.780611 | \n", "-122.443255 | \n", "
2 | \n", "Balboa Terrace | \n", "49 | \n", "0.737963 | \n", "37.730649 | \n", "-122.468267 | \n", "
3 | \n", "Bayview | \n", "3185 | \n", "0.439684 | \n", "37.732391 | \n", "-122.387170 | \n", "
4 | \n", "Bernal Heights | \n", "1561 | \n", "0.448200 | \n", "37.740230 | \n", "-122.415885 | \n", "
\n", " | nbrhood | \n", "nbrhood Latitude | \n", "nbrhood Longitude | \n", "Venue | \n", "Venue Latitude | \n", "Venue Longitude | \n", "Venue Category | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "Alamo Square | \n", "37.776076 | \n", "-122.433919 | \n", "Alamo Square | \n", "37.775906 | \n", "-122.434047 | \n", "Park | \n", "
1 | \n", "Alamo Square | \n", "37.776076 | \n", "-122.433919 | \n", "Painted Ladies | \n", "37.776010 | \n", "-122.433179 | \n", "Historic Site | \n", "
2 | \n", "Alamo Square | \n", "37.776076 | \n", "-122.433919 | \n", "Alamo Square Dog Park | \n", "37.775878 | \n", "-122.435740 | \n", "Dog Run | \n", "
3 | \n", "Alamo Square | \n", "37.776076 | \n", "-122.433919 | \n", "Originals Vinyl | \n", "37.775835 | \n", "-122.431227 | \n", "Record Shop | \n", "
4 | \n", "Alamo Square | \n", "37.776076 | \n", "-122.433919 | \n", "The Center SF | \n", "37.774545 | \n", "-122.430730 | \n", "Spiritual Center | \n", "
\n", " | nbrhood | \n", "ATM | \n", "Acai House | \n", "Accessories Store | \n", "Adult Boutique | \n", "Afghan Restaurant | \n", "African Restaurant | \n", "Alternative Healer | \n", "American Restaurant | \n", "Antique Shop | \n", "Arcade | \n", "Argentinian Restaurant | \n", "Art Gallery | \n", "Art Museum | \n", "Arts & Crafts Store | \n", "Asian Restaurant | \n", "Athletics & Sports | \n", "Automotive Shop | \n", "BBQ Joint | \n", "Baby Store | \n", "Bagel Shop | \n", "Bakery | \n", "Bank | \n", "Bar | \n", "Baseball Field | \n", "Baseball Stadium | \n", "Basketball Court | \n", "Basketball Stadium | \n", "Beach | \n", "Bed & Breakfast | \n", "Beer Bar | \n", "Beer Garden | \n", "Beer Store | \n", "Belgian Restaurant | \n", "Big Box Store | \n", "Bike Rental / Bike Share | \n", "Bike Shop | \n", "Bistro | \n", "Board Shop | \n", "Boat or Ferry | \n", "Bookstore | \n", "Boutique | \n", "Bowling Alley | \n", "Boxing Gym | \n", "Brazilian Restaurant | \n", "Breakfast Spot | \n", "Brewery | \n", "Bubble Tea Shop | \n", "Buffet | \n", "Building | \n", "... | \n", "Stadium | \n", "Stationery Store | \n", "Steakhouse | \n", "Street Food Gathering | \n", "Supermarket | \n", "Supplement Shop | \n", "Surf Spot | \n", "Sushi Restaurant | \n", "Szechuan Restaurant | \n", "Taco Place | \n", "Taiwanese Restaurant | \n", "Tapas Restaurant | \n", "Tattoo Parlor | \n", "Tea Room | \n", "Tech Startup | \n", "Tennis Court | \n", "Thai Restaurant | \n", "Theater | \n", "Thrift / Vintage Store | \n", "Tiki Bar | \n", "Tour Provider | \n", "Tourist Information Center | \n", "Toy / Game Store | \n", "Track | \n", "Track Stadium | \n", "Trade School | \n", "Trail | \n", "Train Station | \n", "Trattoria/Osteria | \n", "Tree | \n", "Tunnel | \n", "Turkish Restaurant | \n", "Tuscan Restaurant | \n", "Udon Restaurant | \n", "Used Bookstore | \n", "Vegetarian / Vegan Restaurant | \n", "Veterinarian | \n", "Video Game Store | \n", "Video Store | \n", "Vietnamese Restaurant | \n", "Vineyard | \n", "Wagashi Place | \n", "Weight Loss Center | \n", "Whisky Bar | \n", "Wine Bar | \n", "Wine Shop | \n", "Winery | \n", "Wings Joint | \n", "Women's Store | \n", "Yoga Studio | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Alamo Square | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.013889 | \n", "0.013889 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.027778 | \n", "0.0 | \n", "0.0 | \n", "0.013889 | \n", "0.013889 | \n", "0.055556 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.027778 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.013889 | \n", "0.013889 | \n", "0.0 | \n", "0.0 | \n", "... | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.027778 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.013889 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.027778 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
1 | \n", "Anza Vista | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.055556 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.055556 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "... | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.055556 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
2 | \n", "Balboa Terrace | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.066667 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.066667 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "... | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.066667 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
3 | \n", "Bayview | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.058824 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.058824 | \n", "0.0 | \n", "0.0 | \n", "0.058824 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "... | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.058824 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.058824 | \n", "0.058824 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
4 | \n", "Bayview Heights | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.25 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "... | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
5 rows Ă— 344 columns
\n", "\n", " | nbrhood | \n", "1st Most Common Venue | \n", "2nd Most Common Venue | \n", "3rd Most Common Venue | \n", "4th Most Common Venue | \n", "5th Most Common Venue | \n", "6th Most Common Venue | \n", "7th Most Common Venue | \n", "8th Most Common Venue | \n", "9th Most Common Venue | \n", "10th Most Common Venue | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Alamo Square | \n", "Bar | \n", "Record Shop | \n", "Boutique | \n", "Italian Restaurant | \n", "Wine Bar | \n", "Sushi Restaurant | \n", "Gift Shop | \n", "Mediterranean Restaurant | \n", "BBQ Joint | \n", "Ethiopian Restaurant | \n", "
1 | \n", "Anza Vista | \n", "Café | \n", "Health & Beauty Service | \n", "Coffee Shop | \n", "Southern / Soul Food Restaurant | \n", "Mexican Restaurant | \n", "Grocery Store | \n", "Sandwich Place | \n", "Tunnel | \n", "Big Box Store | \n", "Arts & Crafts Store | \n", "
2 | \n", "Balboa Terrace | \n", "Light Rail Station | \n", "Pharmacy | \n", "Circus | \n", "Bakery | \n", "Park | \n", "Playground | \n", "Dessert Shop | \n", "Vietnamese Restaurant | \n", "Italian Restaurant | \n", "American Restaurant | \n", "
3 | \n", "Bayview | \n", "Southern / Soul Food Restaurant | \n", "Park | \n", "Light Rail Station | \n", "Chinese Restaurant | \n", "Thrift / Vintage Store | \n", "Theater | \n", "African Restaurant | \n", "Plaza | \n", "Gym | \n", "Bakery | \n", "
4 | \n", "Bayview Heights | \n", "Breakfast Spot | \n", "Park | \n", "Burger Joint | \n", "Latin American Restaurant | \n", "Food | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "Filipino Restaurant | \n", "Flea Market | \n", "
5 | \n", "Bernal Heights | \n", "Coffee Shop | \n", "Park | \n", "Bakery | \n", "Italian Restaurant | \n", "Playground | \n", "Gourmet Shop | \n", "Yoga Studio | \n", "Seafood Restaurant | \n", "Sandwich Place | \n", "Gym | \n", "
6 | \n", "Buena Vista Park/Ashbury Heights | \n", "Boutique | \n", "Park | \n", "Coffee Shop | \n", "Clothing Store | \n", "Convenience Store | \n", "Trail | \n", "Scenic Lookout | \n", "Gift Shop | \n", "Breakfast Spot | \n", "Café | \n", "
7 | \n", "Candlestick Point | \n", "Football Stadium | \n", "Park | \n", "Campground | \n", "Stadium | \n", "American Restaurant | \n", "Food & Drink Shop | \n", "Soccer Field | \n", "Flea Market | \n", "Event Space | \n", "Exhibit | \n", "
8 | \n", "Central Richmond | \n", "Grocery Store | \n", "Chinese Restaurant | \n", "Sushi Restaurant | \n", "Korean Restaurant | \n", "Café | \n", "Deli / Bodega | \n", "Bakery | \n", "Dim Sum Restaurant | \n", "Coffee Shop | \n", "Vietnamese Restaurant | \n", "
9 | \n", "Central Sunset | \n", "Chinese Restaurant | \n", "Gym / Fitness Center | \n", "Pilates Studio | \n", "Spa | \n", "Shoe Store | \n", "Food | \n", "Pet Store | \n", "Playground | \n", "Dessert Shop | \n", "Ethiopian Restaurant | \n", "
10 | \n", "Central Waterfront/Dogpatch | \n", "Bakery | \n", "Art Gallery | \n", "Cocktail Bar | \n", "Brewery | \n", "Wine Bar | \n", "Café | \n", "Gym / Fitness Center | \n", "Coffee Shop | \n", "Gift Shop | \n", "Dessert Shop | \n", "
11 | \n", "Clarendon Heights | \n", "Trail | \n", "Park | \n", "Road | \n", "Bus Stop | \n", "Scenic Lookout | \n", "Art Gallery | \n", "Playground | \n", "Convenience Store | \n", "Wine Bar | \n", "Dance Studio | \n", "
12 | \n", "Cole Valley/Parnassus Heights | \n", "Wine Bar | \n", "Park | \n", "Yoga Studio | \n", "Athletics & Sports | \n", "Burger Joint | \n", "Sports Bar | \n", "Sports Club | \n", "Breakfast Spot | \n", "Street Food Gathering | \n", "Mexican Restaurant | \n", "
13 | \n", "Corona Heights | \n", "Gay Bar | \n", "Park | \n", "Thai Restaurant | \n", "Cosmetics Shop | \n", "Dog Run | \n", "Sushi Restaurant | \n", "Dim Sum Restaurant | \n", "Grocery Store | \n", "Coffee Shop | \n", "Diner | \n", "
14 | \n", "Cow Hollow | \n", "Cosmetics Shop | \n", "Wine Bar | \n", "French Restaurant | \n", "Gym / Fitness Center | \n", "Italian Restaurant | \n", "Sandwich Place | \n", "Salad Place | \n", "Gym | \n", "Bakery | \n", "Salon / Barbershop | \n", "
15 | \n", "Crocker Amazon | \n", "Pharmacy | \n", "Gastropub | \n", "Coffee Shop | \n", "Bar | \n", "Latin American Restaurant | \n", "Scenic Lookout | \n", "Tennis Court | \n", "Basketball Court | \n", "Pizza Place | \n", "American Restaurant | \n", "
16 | \n", "Diamond Heights | \n", "Trail | \n", "Playground | \n", "Grocery Store | \n", "Pharmacy | \n", "Dim Sum Restaurant | \n", "Salon / Barbershop | \n", "Bus Station | \n", "Video Store | \n", "Coffee Shop | \n", "Shopping Mall | \n", "
17 | \n", "Downtown | \n", "Hotel | \n", "Cocktail Bar | \n", "Speakeasy | \n", "Theater | \n", "American Restaurant | \n", "Hostel | \n", "Breakfast Spot | \n", "Thai Restaurant | \n", "Bar | \n", "Coffee Shop | \n", "
18 | \n", "Duboce Triangle | \n", "Gay Bar | \n", "Coffee Shop | \n", "Gym | \n", "Sushi Restaurant | \n", "New American Restaurant | \n", "Mexican Restaurant | \n", "Grocery Store | \n", "Sandwich Place | \n", "Jewelry Store | \n", "Cocktail Bar | \n", "
19 | \n", "Eureka Valley / Dolores Heights | \n", "Gay Bar | \n", "Coffee Shop | \n", "New American Restaurant | \n", "Thai Restaurant | \n", "Pet Store | \n", "Playground | \n", "Park | \n", "Deli / Bodega | \n", "Mexican Restaurant | \n", "Men's Store | \n", "
20 | \n", "Excelsior | \n", "Convenience Store | \n", "Moving Target | \n", "Scenic Lookout | \n", "Lake | \n", "Flower Shop | \n", "Ethiopian Restaurant | \n", "Event Space | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "
21 | \n", "Financial District/Barbary Coast | \n", "Coffee Shop | \n", "Italian Restaurant | \n", "Food Truck | \n", "Men's Store | \n", "New American Restaurant | \n", "Sandwich Place | \n", "Gym | \n", "Seafood Restaurant | \n", "Café | \n", "Japanese Restaurant | \n", "
22 | \n", "Forest Hill | \n", "Japanese Restaurant | \n", "Hotpot Restaurant | \n", "Tennis Court | \n", "Park | \n", "Playground | \n", "French Restaurant | \n", "Cycle Studio | \n", "Coworking Space | \n", "Event Space | \n", "Exhibit | \n", "
23 | \n", "Forest Hills Extension | \n", "Convenience Store | \n", "Burger Joint | \n", "Hotpot Restaurant | \n", "Gym | \n", "French Restaurant | \n", "Park | \n", "Pharmacy | \n", "Dive Bar | \n", "Sandwich Place | \n", "Bus Stop | \n", "
24 | \n", "Forest Knolls | \n", "Trail | \n", "Park | \n", "Mountain | \n", "Garden | \n", "Fountain | \n", "Football Stadium | \n", "Ethiopian Restaurant | \n", "Event Space | \n", "French Restaurant | \n", "Exhibit | \n", "
25 | \n", "Glen Park | \n", "Park | \n", "Café | \n", "Trail | \n", "Coffee Shop | \n", "Grocery Store | \n", "Cosmetics Shop | \n", "Dive Bar | \n", "Spa | \n", "Tennis Court | \n", "Gift Shop | \n", "
26 | \n", "Golden Gate Heights | \n", "Trail | \n", "Park | \n", "Bus Stop | \n", "Playground | \n", "Scenic Lookout | \n", "Home Service | \n", "Tennis Court | \n", "Video Game Store | \n", "Flower Shop | \n", "Farmers Market | \n", "
27 | \n", "Golden Gate Park | \n", "Park | \n", "Track | \n", "Disc Golf | \n", "Bus Stop | \n", "Yoga Studio | \n", "Ethiopian Restaurant | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "Filipino Restaurant | \n", "
28 | \n", "Haight Ashbury | \n", "Café | \n", "Boutique | \n", "Coffee Shop | \n", "Thrift / Vintage Store | \n", "Pizza Place | \n", "Shoe Store | \n", "Clothing Store | \n", "Thai Restaurant | \n", "Gift Shop | \n", "Board Shop | \n", "
29 | \n", "Hayes Valley | \n", "Boutique | \n", "Wine Bar | \n", "Café | \n", "French Restaurant | \n", "Sushi Restaurant | \n", "Clothing Store | \n", "Cocktail Bar | \n", "Coffee Shop | \n", "Bubble Tea Shop | \n", "Mexican Restaurant | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
62 | \n", "Outer Mission | \n", "Latin American Restaurant | \n", "Cosmetics Shop | \n", "Spanish Restaurant | \n", "Chinese Restaurant | \n", "Mexican Restaurant | \n", "Bakery | \n", "Grocery Store | \n", "Food | \n", "Asian Restaurant | \n", "Motel | \n", "
63 | \n", "Outer Parkside | \n", "Coffee Shop | \n", "Chinese Restaurant | \n", "Pizza Place | \n", "Pharmacy | \n", "Beach | \n", "Thai Restaurant | \n", "Grocery Store | \n", "Bar | \n", "Bakery | \n", "Light Rail Station | \n", "
64 | \n", "Outer Richmond | \n", "Chinese Restaurant | \n", "Café | \n", "Japanese Restaurant | \n", "Sporting Goods Shop | \n", "Music Store | \n", "Bakery | \n", "Sandwich Place | \n", "Ramen Restaurant | \n", "Yoga Studio | \n", "Record Shop | \n", "
65 | \n", "Outer Sunset | \n", "Art Gallery | \n", "Mexican Restaurant | \n", "Thai Restaurant | \n", "Light Rail Station | \n", "Coffee Shop | \n", "Yoga Studio | \n", "Arts & Crafts Store | \n", "Brewery | \n", "Breakfast Spot | \n", "Bookstore | \n", "
66 | \n", "Pacific Heights | \n", "Cosmetics Shop | \n", "Coffee Shop | \n", "Park | \n", "Grocery Store | \n", "Juice Bar | \n", "Gym / Fitness Center | \n", "French Restaurant | \n", "Salon / Barbershop | \n", "Bar | \n", "Ice Cream Shop | \n", "
67 | \n", "Parkside | \n", "Chinese Restaurant | \n", "Dumpling Restaurant | \n", "Light Rail Station | \n", "Bubble Tea Shop | \n", "Café | \n", "Japanese Restaurant | \n", "Sandwich Place | \n", "Bar | \n", "Liquor Store | \n", "Burrito Place | \n", "
68 | \n", "Pine Lake Park | \n", "Park | \n", "Gym | \n", "Music Venue | \n", "Sandwich Place | \n", "Food Truck | \n", "Dog Run | \n", "Asian Restaurant | \n", "Hawaiian Restaurant | \n", "Event Space | \n", "Exhibit | \n", "
69 | \n", "Portola | \n", "Recreation Center | \n", "Lake | \n", "Playground | \n", "Shopping Mall | \n", "Bus Station | \n", "Food Truck | \n", "Food Stand | \n", "Electronics Store | \n", "Ethiopian Restaurant | \n", "Event Space | \n", "
70 | \n", "Potrero Hill | \n", "Park | \n", "Café | \n", "Brewery | \n", "Grocery Store | \n", "Playground | \n", "Breakfast Spot | \n", "Burger Joint | \n", "Bus Station | \n", "Pizza Place | \n", "Sandwich Place | \n", "
71 | \n", "Presidio | \n", "Museum | \n", "Brewery | \n", "American Restaurant | \n", "Outdoor Sculpture | \n", "Trail | \n", "Asian Restaurant | \n", "General Entertainment | \n", "Art Gallery | \n", "Park | \n", "Bowling Alley | \n", "
72 | \n", "Presidio Heights | \n", "American Restaurant | \n", "Park | \n", "Cosmetics Shop | \n", "Golf Course | \n", "Baby Store | \n", "New American Restaurant | \n", "Supermarket | \n", "Café | \n", "Bookstore | \n", "Miscellaneous Shop | \n", "
73 | \n", "Russian Hill | \n", "Park | \n", "Chocolate Shop | \n", "Ice Cream Shop | \n", "Coffee Shop | \n", "Hotel | \n", "Bike Rental / Bike Share | \n", "Tour Provider | \n", "Diner | \n", "Art Gallery | \n", "Seafood Restaurant | \n", "
74 | \n", "Saint Francis Wood | \n", "Coffee Shop | \n", "Chinese Restaurant | \n", "Italian Restaurant | \n", "Indian Restaurant | \n", "Pizza Place | \n", "Gym / Fitness Center | \n", "Wine Bar | \n", "Mexican Restaurant | \n", "Pub | \n", "Music Store | \n", "
75 | \n", "Sea Cliff | \n", "Trail | \n", "Tea Room | \n", "Beach | \n", "Scenic Lookout | \n", "Golf Course | \n", "Neighborhood | \n", "Football Stadium | \n", "Food Truck | \n", "Event Space | \n", "Exhibit | \n", "
76 | \n", "Sherwood Forest | \n", "Tree | \n", "Park | \n", "Monument / Landmark | \n", "Trail | \n", "Yoga Studio | \n", "Flea Market | \n", "Ethiopian Restaurant | \n", "Event Space | \n", "Exhibit | \n", "Farmers Market | \n", "
77 | \n", "Silver Terrace | \n", "Park | \n", "Liquor Store | \n", "Soccer Field | \n", "Outdoor Gym | \n", "Yoga Studio | \n", "Electronics Store | \n", "Event Space | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "
78 | \n", "South Beach | \n", "Café | \n", "Gym | \n", "Sandwich Place | \n", "Coffee Shop | \n", "Deli / Bodega | \n", "Park | \n", "Scenic Lookout | \n", "Residential Building (Apartment / Condo) | \n", "Spa | \n", "American Restaurant | \n", "
79 | \n", "South of Market | \n", "Nightclub | \n", "Sandwich Place | \n", "Art Gallery | \n", "Coffee Shop | \n", "Furniture / Home Store | \n", "Food Truck | \n", "Jewelry Store | \n", "Bar | \n", "Café | \n", "Clothing Store | \n", "
80 | \n", "Stonestown | \n", "Café | \n", "Sandwich Place | \n", "Pizza Place | \n", "College Cafeteria | \n", "Tennis Court | \n", "Park | \n", "Coffee Shop | \n", "Gym | \n", "Juice Bar | \n", "Mexican Restaurant | \n", "
81 | \n", "Sunnyside | \n", "Bar | \n", "Vietnamese Restaurant | \n", "Baseball Field | \n", "Trail | \n", "Grocery Store | \n", "Dumpling Restaurant | \n", "Soccer Field | \n", "Cantonese Restaurant | \n", "Spa | \n", "College Gym | \n", "
82 | \n", "Telegraph Hill | \n", "Italian Restaurant | \n", "Pizza Place | \n", "Cocktail Bar | \n", "Coffee Shop | \n", "Park | \n", "Mexican Restaurant | \n", "Bakery | \n", "Trail | \n", "Chinese Restaurant | \n", "Scenic Lookout | \n", "
83 | \n", "Tenderloin | \n", "Coffee Shop | \n", "Vietnamese Restaurant | \n", "Thai Restaurant | \n", "Theater | \n", "Cocktail Bar | \n", "Speakeasy | \n", "Indian Restaurant | \n", "Burger Joint | \n", "Sandwich Place | \n", "Hotel | \n", "
84 | \n", "Twin Peaks | \n", "Trail | \n", "Scenic Lookout | \n", "Reservoir | \n", "Yoga Studio | \n", "Filipino Restaurant | \n", "Egyptian Restaurant | \n", "Electronics Store | \n", "Ethiopian Restaurant | \n", "Event Space | \n", "Exhibit | \n", "
85 | \n", "Van Ness/Civic Center | \n", "Thai Restaurant | \n", "Vietnamese Restaurant | \n", "Sandwich Place | \n", "Sushi Restaurant | \n", "Coffee Shop | \n", "Bar | \n", "Korean Restaurant | \n", "Southern / Soul Food Restaurant | \n", "Vegetarian / Vegan Restaurant | \n", "Theater | \n", "
86 | \n", "Visitacion Valley | \n", "Garden | \n", "Baseball Field | \n", "Park | \n", "Pool | \n", "Trail | \n", "Flower Shop | \n", "Event Space | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "
87 | \n", "West Portal | \n", "Coffee Shop | \n", "Chinese Restaurant | \n", "Music Store | \n", "Pizza Place | \n", "Indian Restaurant | \n", "Wine Bar | \n", "Park | \n", "Mexican Restaurant | \n", "Pub | \n", "Gym / Fitness Center | \n", "
88 | \n", "Western Addition | \n", "Cosmetics Shop | \n", "Shopping Mall | \n", "Jazz Club | \n", "Japanese Restaurant | \n", "New American Restaurant | \n", "Furniture / Home Store | \n", "Sushi Restaurant | \n", "Gift Shop | \n", "Tea Room | \n", "Grocery Store | \n", "
89 | \n", "Westwood Highlands | \n", "Yoga Studio | \n", "Diner | \n", "Sushi Restaurant | \n", "Bus Line | \n", "Food | \n", "Monument / Landmark | \n", "Gun Range | \n", "Cantonese Restaurant | \n", "Breakfast Spot | \n", "Trail | \n", "
90 | \n", "Westwood Park | \n", "Yoga Studio | \n", "Asian Restaurant | \n", "Poke Place | \n", "Pharmacy | \n", "Coffee Shop | \n", "Bubble Tea Shop | \n", "Café | \n", "Gastropub | \n", "Food | \n", "Grocery Store | \n", "
91 | \n", "Yerba Buena | \n", "Coffee Shop | \n", "Hotel | \n", "Sushi Restaurant | \n", "Sandwich Place | \n", "Gym / Fitness Center | \n", "Café | \n", "Museum | \n", "Art Museum | \n", "Bar | \n", "Pizza Place | \n", "
92 rows Ă— 11 columns
\n", "\n", " | nbrhood | \n", "incident_counts | \n", "house_avg_price | \n", "Latitude | \n", "Longitude | \n", "1st Most Common Venue | \n", "2nd Most Common Venue | \n", "3rd Most Common Venue | \n", "4th Most Common Venue | \n", "5th Most Common Venue | \n", "6th Most Common Venue | \n", "7th Most Common Venue | \n", "8th Most Common Venue | \n", "9th Most Common Venue | \n", "10th Most Common Venue | \n", "Cluster Labels | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Alamo Square | \n", "687 | \n", "0.862016 | \n", "37.776076 | \n", "-122.433919 | \n", "Bar | \n", "Record Shop | \n", "Boutique | \n", "Italian Restaurant | \n", "Wine Bar | \n", "Sushi Restaurant | \n", "Gift Shop | \n", "Mediterranean Restaurant | \n", "BBQ Joint | \n", "Ethiopian Restaurant | \n", "1 | \n", "
1 | \n", "Anza Vista | \n", "310 | \n", "1.121534 | \n", "37.780611 | \n", "-122.443255 | \n", "Café | \n", "Health & Beauty Service | \n", "Coffee Shop | \n", "Southern / Soul Food Restaurant | \n", "Mexican Restaurant | \n", "Grocery Store | \n", "Sandwich Place | \n", "Tunnel | \n", "Big Box Store | \n", "Arts & Crafts Store | \n", "1 | \n", "
2 | \n", "Balboa Terrace | \n", "49 | \n", "0.737963 | \n", "37.730649 | \n", "-122.468267 | \n", "Light Rail Station | \n", "Pharmacy | \n", "Circus | \n", "Bakery | \n", "Park | \n", "Playground | \n", "Dessert Shop | \n", "Vietnamese Restaurant | \n", "Italian Restaurant | \n", "American Restaurant | \n", "3 | \n", "
3 | \n", "Bayview | \n", "3185 | \n", "0.439684 | \n", "37.732391 | \n", "-122.387170 | \n", "Southern / Soul Food Restaurant | \n", "Park | \n", "Light Rail Station | \n", "Chinese Restaurant | \n", "Thrift / Vintage Store | \n", "Theater | \n", "African Restaurant | \n", "Plaza | \n", "Gym | \n", "Bakery | \n", "3 | \n", "
4 | \n", "Bernal Heights | \n", "1561 | \n", "0.448200 | \n", "37.740230 | \n", "-122.415885 | \n", "Coffee Shop | \n", "Park | \n", "Bakery | \n", "Italian Restaurant | \n", "Playground | \n", "Gourmet Shop | \n", "Yoga Studio | \n", "Seafood Restaurant | \n", "Sandwich Place | \n", "Gym | \n", "1 | \n", "
\n", " | nbrhood | \n", "incident_counts | \n", "1st Most Common Venue | \n", "2nd Most Common Venue | \n", "3rd Most Common Venue | \n", "4th Most Common Venue | \n", "5th Most Common Venue | \n", "6th Most Common Venue | \n", "7th Most Common Venue | \n", "8th Most Common Venue | \n", "9th Most Common Venue | \n", "10th Most Common Venue | \n", "Cluster Labels | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | \n", "Forest Hill | \n", "89 | \n", "Japanese Restaurant | \n", "Hotpot Restaurant | \n", "Tennis Court | \n", "Park | \n", "Playground | \n", "French Restaurant | \n", "Cycle Studio | \n", "Coworking Space | \n", "Event Space | \n", "Exhibit | \n", "0 | \n", "
24 | \n", "Golden Gate Park | \n", "544 | \n", "Park | \n", "Track | \n", "Disc Golf | \n", "Bus Stop | \n", "Yoga Studio | \n", "Ethiopian Restaurant | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "Filipino Restaurant | \n", "0 | \n", "
43 | \n", "Merced Heights | \n", "33 | \n", "Garden | \n", "Racetrack | \n", "Park | \n", "Liquor Store | \n", "Light Rail Station | \n", "Yoga Studio | \n", "Flea Market | \n", "Event Space | \n", "Exhibit | \n", "Farmers Market | \n", "0 | \n", "
44 | \n", "Merced Manor | \n", "61 | \n", "Gym | \n", "Park | \n", "Art Gallery | \n", "Tennis Court | \n", "Japanese Restaurant | \n", "Bubble Tea Shop | \n", "Music Venue | \n", "Weight Loss Center | \n", "Food Truck | \n", "Pet Store | \n", "0 | \n", "
47 | \n", "Miraloma Park | \n", "191 | \n", "Park | \n", "Playground | \n", "Monument / Landmark | \n", "Tree | \n", "Bus Line | \n", "College Auditorium | \n", "Event Space | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "0 | \n", "
64 | \n", "Pine Lake Park | \n", "36 | \n", "Park | \n", "Gym | \n", "Music Venue | \n", "Sandwich Place | \n", "Food Truck | \n", "Dog Run | \n", "Asian Restaurant | \n", "Hawaiian Restaurant | \n", "Event Space | \n", "Exhibit | \n", "0 | \n", "
72 | \n", "Silver Terrace | \n", "678 | \n", "Park | \n", "Liquor Store | \n", "Soccer Field | \n", "Outdoor Gym | \n", "Yoga Studio | \n", "Electronics Store | \n", "Event Space | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "0 | \n", "
89 | \n", "Bayview Heights | \n", "253 | \n", "Breakfast Spot | \n", "Park | \n", "Burger Joint | \n", "Latin American Restaurant | \n", "Food | \n", "Exhibit | \n", "Farmers Market | \n", "Fast Food Restaurant | \n", "Filipino Restaurant | \n", "Flea Market | \n", "0 | \n", "
\n", " | nbrhood | \n", "1st Most Common Venue | \n", "2nd Most Common Venue | \n", "3rd Most Common Venue | \n", "4th Most Common Venue | \n", "5th Most Common Venue | \n", "6th Most Common Venue | \n", "7th Most Common Venue | \n", "8th Most Common Venue | \n", "9th Most Common Venue | \n", "10th Most Common Venue | \n", "Cluster Labels | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
58 | \n", "North Beach | \n", "Italian Restaurant | \n", "Pizza Place | \n", "Chinese Restaurant | \n", "Bakery | \n", "Cocktail Bar | \n", "Coffee Shop | \n", "Café | \n", "Dive Bar | \n", "Deli / Bodega | \n", "Yoga Studio | \n", "1 | \n", "
\n", " | name | \n", "categories | \n", "lat | \n", "lng | \n", "
---|---|---|---|---|
0 | \n", "Tony’s Pizza Napoletana | \n", "Pizza Place | \n", "37.800328 | \n", "-122.409040 | \n", "
1 | \n", "Park Tavern | \n", "New American Restaurant | \n", "37.801097 | \n", "-122.409301 | \n", "
2 | \n", "Trattoria Contadina | \n", "Trattoria/Osteria | \n", "37.800078 | \n", "-122.412422 | \n", "
3 | \n", "The Italian Homemade Company | \n", "Italian Restaurant | \n", "37.801497 | \n", "-122.411795 | \n", "
4 | \n", "Mario's Bohemian Cigar Store Cafe | \n", "Café | \n", "37.800391 | \n", "-122.409876 | \n", "