Henry's_21st_GEOIDs.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyNVpbwPokfch+v2DYg22qOa",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/alisongx/interactive-birthday-atlas/blob/main/Henry's_21st_GEOIDs.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jOlruOeRp20m",
        "outputId": "d8f63d9c-3aa9-4526-a438-bc869920d855"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ],
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')\n",
        "\n",
        "import pandas as pd\n",
        "import numpy as np"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "hdi = pd.read_csv('/content/drive/MyDrive/hd birthday atlas/[CLEAN] Henrys21stBirthday_12-09_guests.csv')\n",
        "hdi = hdi.drop(columns=['region'])\n",
        "hdi['person_name'] = hdi['person_name'].ffill(axis=0)\n",
        "hdi.loc[140, 'genr_address'] = 'Tunnel Beach, Oregon 97141'\n",
        "hdi.loc[72, 'genr_address'] = '510 Concord Dr, Menlo Park, CA 94025'\n",
        "\n",
        "isna = [0, 14, 36, 44, 80]\n",
        "hd_isna = hdi.loc[isna].copy()\n",
        "hdi = hdi.drop(isna).reset_index(drop=True)\n",
        "hdi.iloc[0]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 272
        },
        "id": "DrIMJ24QqIIl",
        "outputId": "f2a6598b-cd5b-462d-ba1b-cff9cabdeda5"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "person_name                               Amber (one of alison 5)\n",
              "place                                                 los angeles\n",
              "address                                                       NaN\n",
              "place_name                                                Fred 62\n",
              "genr_address    Fred 62, 1850 N Vermont Ave, Los Angeles, CA 9...\n",
              "text                                                fred 62 in la\n",
              "Name: 0, dtype: object"
            ],
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>0</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>person_name</th>\n",
              "      <td>Amber (one of alison 5)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>place</th>\n",
              "      <td>los angeles</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>address</th>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>place_name</th>\n",
              "      <td>Fred 62</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>genr_address</th>\n",
              "      <td>Fred 62, 1850 N Vermont Ave, Los Angeles, CA 9...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>text</th>\n",
              "      <td>fred 62 in la</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div><br><label><b>dtype:</b> object</label>"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from geopy.geocoders import Nominatim\n",
        "from geopy.exc import GeocoderTimedOut\n",
        "\n",
        "hd = hdi.copy()\n",
        "\n",
        "def is_in_ca(lat, lon):\n",
        "    CA_NORTH = 42.0\n",
        "    CA_SOUTH = 32.5\n",
        "    CA_WEST = -124.4\n",
        "    CA_EAST = -114.1\n",
        "    return CA_SOUTH <= lat <= CA_NORTH and CA_WEST <= lon <= CA_EAST\n",
        "\n",
        "geolocator = Nominatim(user_agent=\"my_agent\")\n",
        "\n",
        "def geocode_with_retry(address, max_attempts=3):\n",
        "    address_components = address.split(', ')\n",
        "    address_combinations = [\n",
        "        # ', '.join(address_components),\n",
        "        ', '.join(address_components[:1]),\n",
        "        ', '.join(address_components[1:]),\n",
        "    ]\n",
        "\n",
        "    for addr in address_combinations:\n",
        "        for attempt in range(max_attempts):\n",
        "            try:\n",
        "                location = geolocator.geocode(addr)\n",
        "                if location:\n",
        "                    lat, lon = location.latitude, location.longitude\n",
        "                    if is_in_ca(lat, lon):\n",
        "                        return lat, lon\n",
        "                    else:\n",
        "                        break\n",
        "                break\n",
        "            except GeocoderTimedOut:\n",
        "                if attempt == max_attempts - 1:\n",
        "                    break\n",
        "    return np.nan, np.nan\n",
        "\n",
        "# fill in missing addresses\n",
        "for i in range(hd.shape[0]):\n",
        "    if pd.isna(hd['address'].iloc[i]):\n",
        "        place_name = hd['place_name'].iloc[i] if not pd.isna(hd['place_name'].iloc[i]) else ''\n",
        "        place = hd['place'].iloc[i] if not pd.isna(hd['place'].iloc[i]) else ''\n",
        "        hd.loc[i, 'address'] = f\"{place_name}, {place}, California\".strip(', ')\n",
        "\n",
        "hd['address'] = hd['address'].str.replace(', ,', ',', regex=False)\n",
        "hd[['latitude', 'longitude']] = hd['genr_address'].apply(geocode_with_retry).apply(pd.Series)\n",
        "\n",
        "hd"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "8jUAsVTfSX0P",
        "outputId": "23a2720d-3fc2-49f7-98b6-ba260e2c6868"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Rialto+Cinemas+Elmwood&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Henry+Cowell+Redwoods+State+Park%2C+2100-4166+State+Rte+9%2C+Felton%2C+CA+95018&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=University+of+California+Botanical+Garden&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=2811+Martin+Luther+King+Jr+Way&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=198+Sir+Francis+Drake+Blvd%2C+San+Anselmo%2C+CA+94960&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=3300+Page+Mill+Rd%2C+Los+Altos+Hills%2C+CA+94022&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=3300+Page+Mill+Rd%2C+Los+Altos+Hills%2C+CA+94022&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Sunday+Marin+Farmers%27+Market&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=510+Concord+Dr&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Yosemite+National+Park%2C+CA+95389&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Yosemite+National+Park%2C+CA+95389&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Yosemite+National+Park%2C+CA+95389&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Yosemite+National+Park%2C+CA+95389&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Martin%27s+Beach+Rd%2C+Half+Moon+Bay%2C+CA+94019&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Elizabeth+F.+Gamble+Garden&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=6th+Avenue+Skate+Park&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=1630+Caroline+St%2C+Redlands%2C+CA+92373&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Oregon+97141&format=json&limit=1\n",
            "WARNING:urllib3.connectionpool:Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError(\"HTTPSConnectionPool(host='nominatim.openstreetmap.org', port=443): Read timed out. (read timeout=1)\")': /search?q=Steiner+St+%26+Hayes+St%2C+San+Francisco%2C+CA+94117&format=json&limit=1\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 person_name          place  \\\n",
              "0    Amber (one of alison 5)    los angeles   \n",
              "1             Amelia Monsour    los angeles   \n",
              "2             Amelia Monsour    Pismo Beach   \n",
              "3             Amelia Monsour  Sierra Madre    \n",
              "4                       anna         moraga   \n",
              "..                       ...            ...   \n",
              "158           Vika Stukalova       berkeley   \n",
              "159             wavey cramer        big sur   \n",
              "160             wavey cramer    guerneville   \n",
              "161             wavey cramer         jenner   \n",
              "162     William Allan Bulris   marin county   \n",
              "\n",
              "                                               address  \\\n",
              "0                     Fred 62, los angeles, California   \n",
              "1          Blue Ribbon Garden, los angeles, California   \n",
              "2     Old West Cinnamon Rolls, Pismo Beach, California   \n",
              "3        Little Santa Anita, Sierra Madre , California   \n",
              "4                   Pinehurst Road, moraga, California   \n",
              "..                                                 ...   \n",
              "158                        Big C, berkeley, California   \n",
              "159                Pfeiffer Beach, big sur, California   \n",
              "160             Russian River, guerneville, California   \n",
              "161                  Cafe Aquatica, jenner, California   \n",
              "162  Muir Woods National Monument, marin county, Ca...   \n",
              "\n",
              "                       place_name  \\\n",
              "0                         Fred 62   \n",
              "1              Blue Ribbon Garden   \n",
              "2         Old West Cinnamon Rolls   \n",
              "3              Little Santa Anita   \n",
              "4                  Pinehurst Road   \n",
              "..                            ...   \n",
              "158                         Big C   \n",
              "159                Pfeiffer Beach   \n",
              "160                 Russian River   \n",
              "161                 Cafe Aquatica   \n",
              "162  Muir Woods National Monument   \n",
              "\n",
              "                                          genr_address  \\\n",
              "0    Fred 62, 1850 N Vermont Ave, Los Angeles, CA 9...   \n",
              "1    Blue Ribbon Garden, 111 S Grand Ave, Los Angel...   \n",
              "2    Old West Cinnamon Rolls, 861 Dolliver St, Pism...   \n",
              "3           Little Santa Anita, Sierra Madre, CA 91024   \n",
              "4                     Pinehurst Road, Moraga, CA 94556   \n",
              "..                                                 ...   \n",
              "158    Big C, Berkeley Fire Trails, Berkeley, CA 94720   \n",
              "159  Pfeiffer Beach, Sycamore Canyon Rd, Big Sur, C...   \n",
              "160               Russian River, Guerneville, CA 95446   \n",
              "161        Cafe Aquatica, 10439 CA-1, Jenner, CA 95450   \n",
              "162  Muir Woods National Monument, 1 Muir Woods Rd,...   \n",
              "\n",
              "                                                  text   latitude   longitude  \n",
              "0                                        fred 62 in la  34.104625 -118.291645  \n",
              "1                     Disney Hall rooftop garden in LA  34.055574 -118.250270  \n",
              "2               Old West Cinnamon Rolls in Pismo Beach  35.141585 -120.642431  \n",
              "3    Little Santa Anita in Sierra Madre (doesn’t lo...  34.155897 -118.029447  \n",
              "4                     (1) pinehurst road in moraga, ca  34.106034 -118.340468  \n",
              "..                                                 ...        ...         ...  \n",
              "158                              the one swing in berk        NaN         NaN  \n",
              "159                  big sur pink sand key hole beach,  36.239365 -121.817605  \n",
              "160                      russian river (guerneville),   38.793469 -123.004315  \n",
              "161                                     cafe aquatica   38.449039 -123.114884  \n",
              "162  One place around Berkeley that I very much enj...  37.896391 -122.580218  \n",
              "\n",
              "[163 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f033fdc5-ec98-4657-8cb5-0c954eed655a\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>person_name</th>\n",
              "      <th>place</th>\n",
              "      <th>address</th>\n",
              "      <th>place_name</th>\n",
              "      <th>genr_address</th>\n",
              "      <th>text</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Amber (one of alison 5)</td>\n",
              "      <td>los angeles</td>\n",
              "      <td>Fred 62, los angeles, California</td>\n",
              "      <td>Fred 62</td>\n",
              "      <td>Fred 62, 1850 N Vermont Ave, Los Angeles, CA 9...</td>\n",
              "      <td>fred 62 in la</td>\n",
              "      <td>34.104625</td>\n",
              "      <td>-118.291645</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Amelia Monsour</td>\n",
              "      <td>los angeles</td>\n",
              "      <td>Blue Ribbon Garden, los angeles, California</td>\n",
              "      <td>Blue Ribbon Garden</td>\n",
              "      <td>Blue Ribbon Garden, 111 S Grand Ave, Los Angel...</td>\n",
              "      <td>Disney Hall rooftop garden in LA</td>\n",
              "      <td>34.055574</td>\n",
              "      <td>-118.250270</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Amelia Monsour</td>\n",
              "      <td>Pismo Beach</td>\n",
              "      <td>Old West Cinnamon Rolls, Pismo Beach, California</td>\n",
              "      <td>Old West Cinnamon Rolls</td>\n",
              "      <td>Old West Cinnamon Rolls, 861 Dolliver St, Pism...</td>\n",
              "      <td>Old West Cinnamon Rolls in Pismo Beach</td>\n",
              "      <td>35.141585</td>\n",
              "      <td>-120.642431</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Amelia Monsour</td>\n",
              "      <td>Sierra Madre</td>\n",
              "      <td>Little Santa Anita, Sierra Madre , California</td>\n",
              "      <td>Little Santa Anita</td>\n",
              "      <td>Little Santa Anita, Sierra Madre, CA 91024</td>\n",
              "      <td>Little Santa Anita in Sierra Madre (doesn’t lo...</td>\n",
              "      <td>34.155897</td>\n",
              "      <td>-118.029447</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>anna</td>\n",
              "      <td>moraga</td>\n",
              "      <td>Pinehurst Road, moraga, California</td>\n",
              "      <td>Pinehurst Road</td>\n",
              "      <td>Pinehurst Road, Moraga, CA 94556</td>\n",
              "      <td>(1) pinehurst road in moraga, ca</td>\n",
              "      <td>34.106034</td>\n",
              "      <td>-118.340468</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>158</th>\n",
              "      <td>Vika Stukalova</td>\n",
              "      <td>berkeley</td>\n",
              "      <td>Big C, berkeley, California</td>\n",
              "      <td>Big C</td>\n",
              "      <td>Big C, Berkeley Fire Trails, Berkeley, CA 94720</td>\n",
              "      <td>the one swing in berk</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>159</th>\n",
              "      <td>wavey cramer</td>\n",
              "      <td>big sur</td>\n",
              "      <td>Pfeiffer Beach, big sur, California</td>\n",
              "      <td>Pfeiffer Beach</td>\n",
              "      <td>Pfeiffer Beach, Sycamore Canyon Rd, Big Sur, C...</td>\n",
              "      <td>big sur pink sand key hole beach,</td>\n",
              "      <td>36.239365</td>\n",
              "      <td>-121.817605</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160</th>\n",
              "      <td>wavey cramer</td>\n",
              "      <td>guerneville</td>\n",
              "      <td>Russian River, guerneville, California</td>\n",
              "      <td>Russian River</td>\n",
              "      <td>Russian River, Guerneville, CA 95446</td>\n",
              "      <td>russian river (guerneville),</td>\n",
              "      <td>38.793469</td>\n",
              "      <td>-123.004315</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>161</th>\n",
              "      <td>wavey cramer</td>\n",
              "      <td>jenner</td>\n",
              "      <td>Cafe Aquatica, jenner, California</td>\n",
              "      <td>Cafe Aquatica</td>\n",
              "      <td>Cafe Aquatica, 10439 CA-1, Jenner, CA 95450</td>\n",
              "      <td>cafe aquatica</td>\n",
              "      <td>38.449039</td>\n",
              "      <td>-123.114884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>162</th>\n",
              "      <td>William Allan Bulris</td>\n",
              "      <td>marin county</td>\n",
              "      <td>Muir Woods National Monument, marin county, Ca...</td>\n",
              "      <td>Muir Woods National Monument</td>\n",
              "      <td>Muir Woods National Monument, 1 Muir Woods Rd,...</td>\n",
              "      <td>One place around Berkeley that I very much enj...</td>\n",
              "      <td>37.896391</td>\n",
              "      <td>-122.580218</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>163 rows × 8 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f033fdc5-ec98-4657-8cb5-0c954eed655a')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-f033fdc5-ec98-4657-8cb5-0c954eed655a button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-f033fdc5-ec98-4657-8cb5-0c954eed655a');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-9b6318c2-79ee-4efa-932c-ad657879e03f\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9b6318c2-79ee-4efa-932c-ad657879e03f')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-9b6318c2-79ee-4efa-932c-ad657879e03f button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_70b29058-09b5-4381-b0c3-78254d79c73b\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('hd')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_70b29058-09b5-4381-b0c3-78254d79c73b button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('hd');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "hd",
              "summary": "{\n  \"name\": \"hd\",\n  \"rows\": 163,\n  \"fields\": [\n    {\n      \"column\": \"person_name\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 65,\n        \"samples\": [\n          \"Sofia Wallace\",\n          \"Tasha Tanabe\",\n          \"Amber (one of alison 5)\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"place\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 77,\n        \"samples\": [\n          \"solvang\",\n          \"San Anselmo\",\n          \"Solvang\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"address\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 152,\n        \"samples\": [\n          \"Estero Bluffs Trail, cayucos, California\",\n          \"Point Reyes Station, marin county, California\",\n          \"Bodega Head, sonoma county, California\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"place_name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 146,\n        \"samples\": [\n          \"Hillsborough\",\n          \"Pacific Southwest Railway Museum\",\n          \"Mount Tamalpais State Park\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"genr_address\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 150,\n        \"samples\": [\n          \"Kirby Cove, Conzelman Rd, Sausalito, CA 94965\",\n          \"Harley Farms Goat Dairy, 205 North St, Pescadero, CA 94060\",\n          \"Caroline Park, 1630 Caroline St, Redlands, CA 92373\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"text\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 162,\n        \"samples\": [\n          \"big sur pink sand key hole beach,\",\n          \"bear flag (restaurant in socal if you\\u2019re a fan of fish \\u2014 get the burrito )\",\n          \"Taking a day to do the golden gate park loop\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"latitude\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.8102440726457347,\n        \"min\": 32.6168967,\n        \"max\": 41.4091977,\n        \"num_unique_values\": 136,\n        \"samples\": [\n          37.8661174,\n          37.7306704,\n          37.784464\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"longitude\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.8717428592503267,\n        \"min\": -124.1673746,\n        \"max\": -116.469373,\n        \"num_unique_values\": 136,\n        \"samples\": [\n          -122.58985865076625,\n          -119.5736664,\n          -122.4037068\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "loc = geolocator.geocode('4125 Piedmont Ave, Oakland, CA 94611')\n",
        "print(loc.latitude, loc.longitude)\n",
        "\n",
        "add = 'Fred 62, 1850 N Vermont Ave, Los Angeles, CA 90027,'\n",
        "address_components = add.split(', ')\n",
        "addcombinations = [\n",
        "        ', '.join(address_components),\n",
        "        ', '.join(address_components[1:2]),\n",
        "        ', '.join(address_components[:1]),\n",
        "        ', '.join(address_components[:2]),\n",
        "        ', '.join(address_components[1:]),\n",
        "        ', '.join([address_components[0], address_components[-1]]) if len(address_components) > 1 else address\n",
        "    ]\n",
        "\n",
        "addcombinations\n",
        "\n",
        "hd.loc[37, 'place_name'] = \"Emma's House\"\n",
        "hd.loc[68, 'place_name'] = \"Henry's Mom's House\"\n",
        "hd.loc[86, 'place_name'] = 'Fort Bragg'\n",
        "hd.loc[[10, 44], 'place_name'] = 'Carmel-by-the-Sea'\n",
        "\n",
        "# hd[hd['person_name'] == 'Kyla']"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "UypP-7KQnd43",
        "outputId": "b9f4f879-4dec-4352-d588-7ce18c6b5876"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "37.82682954545455 -122.25168313636364\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           person_name             place  \\\n",
              "7              antonia        santa cruz   \n",
              "42               grace     san francisco   \n",
              "57                 Jay      redwood city   \n",
              "59               JFink        santa cruz   \n",
              "71          Kai Matson           cayucos   \n",
              "84                Kyla  san mateo county   \n",
              "125     Rebekah Murphy     san francisco   \n",
              "127     Rebekah Murphy          redlands   \n",
              "135     Shubhangi Bose     tillamook, OR   \n",
              "141  Sophia Roy-Burman    trinity county   \n",
              "158     Vika Stukalova          berkeley   \n",
              "\n",
              "                                               address  \\\n",
              "7    Garden of Eden - Henry Cowell Redwood State Pa...   \n",
              "42   The Interval at Long Now, san francisco, Calif...   \n",
              "57             Skyline Trail, redwood city, California   \n",
              "59               Waddell Beach, santa cruz, California   \n",
              "71            Estero Bluffs Trail, cayucos, California   \n",
              "84        Martin's Beach, san mateo county, California   \n",
              "125   6th Avenue Skate Park, san francisco, California   \n",
              "127                Caroline Park, redlands, California   \n",
              "135            Tunnel Beach, tillamook, OR, California   \n",
              "141           Trinity Alps, trinity county, California   \n",
              "158                        Big C, berkeley, California   \n",
              "\n",
              "                                           place_name  \\\n",
              "7    Garden of Eden - Henry Cowell Redwood State Park   \n",
              "42                           The Interval at Long Now   \n",
              "57                                      Skyline Trail   \n",
              "59                                      Waddell Beach   \n",
              "71                                Estero Bluffs Trail   \n",
              "84                                     Martin's Beach   \n",
              "125                             6th Avenue Skate Park   \n",
              "127                                     Caroline Park   \n",
              "135                                      Tunnel Beach   \n",
              "141                                      Trinity Alps   \n",
              "158                                             Big C   \n",
              "\n",
              "                                          genr_address  \\\n",
              "7    Garden of Eden, Henry Cowell Redwoods State Pa...   \n",
              "42   The Interval at Long Now, Fort Mason Center, L...   \n",
              "57   Skyline Trail, Skyline Blvd, Redwood City, CA ...   \n",
              "59   Waddell Creek Beach, 3600 Highway 1, Davenport...   \n",
              "71   Estero Bluffs Trail, 1 Mile North of Cayucos o...   \n",
              "84   Martin's Beach, Martin's Beach Rd, Half Moon B...   \n",
              "125  6th Avenue Skate Park, 6th Ave & Kirkham St, S...   \n",
              "127  Caroline Park, 1630 Caroline St, Redlands, CA ...   \n",
              "135                         Tunnel Beach, Oregon 97141   \n",
              "141  Trinity Alps, Trinity Alps Wilderness, Weaverv...   \n",
              "158    Big C, Berkeley Fire Trails, Berkeley, CA 94720   \n",
              "\n",
              "                                                  text  latitude  longitude  \n",
              "7                             Garden of Eden (classic)       NaN        NaN  \n",
              "42                    the interval, awesome bar in sf.       NaN        NaN  \n",
              "57                           37.40876° N, 122.29965° W       NaN        NaN  \n",
              "59          Waddell Creek Beach (watch kite surfers!).       NaN        NaN  \n",
              "71                 and Estero bluffs trails in Cayucos       NaN        NaN  \n",
              "84   martin's beach (this one is top secret, so con...       NaN        NaN  \n",
              "125  I really love Golden Gate Park on Sunday and w...       NaN        NaN  \n",
              "127   I have to plug Redlands... sorry. but if you ...       NaN        NaN  \n",
              "135                                 Tunnel Beach (OR),       NaN        NaN  \n",
              "141                                      trinity alps!       NaN        NaN  \n",
              "158                              the one swing in berk       NaN        NaN  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-6c3b286b-04c7-41c8-b432-57e96e9ad78a\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>person_name</th>\n",
              "      <th>place</th>\n",
              "      <th>address</th>\n",
              "      <th>place_name</th>\n",
              "      <th>genr_address</th>\n",
              "      <th>text</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>antonia</td>\n",
              "      <td>santa cruz</td>\n",
              "      <td>Garden of Eden - Henry Cowell Redwood State Pa...</td>\n",
              "      <td>Garden of Eden - Henry Cowell Redwood State Park</td>\n",
              "      <td>Garden of Eden, Henry Cowell Redwoods State Pa...</td>\n",
              "      <td>Garden of Eden (classic)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>grace</td>\n",
              "      <td>san francisco</td>\n",
              "      <td>The Interval at Long Now, san francisco, Calif...</td>\n",
              "      <td>The Interval at Long Now</td>\n",
              "      <td>The Interval at Long Now, Fort Mason Center, L...</td>\n",
              "      <td>the interval, awesome bar in sf.</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>Jay</td>\n",
              "      <td>redwood city</td>\n",
              "      <td>Skyline Trail, redwood city, California</td>\n",
              "      <td>Skyline Trail</td>\n",
              "      <td>Skyline Trail, Skyline Blvd, Redwood City, CA ...</td>\n",
              "      <td>37.40876° N, 122.29965° W</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>JFink</td>\n",
              "      <td>santa cruz</td>\n",
              "      <td>Waddell Beach, santa cruz, California</td>\n",
              "      <td>Waddell Beach</td>\n",
              "      <td>Waddell Creek Beach, 3600 Highway 1, Davenport...</td>\n",
              "      <td>Waddell Creek Beach (watch kite surfers!).</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71</th>\n",
              "      <td>Kai Matson</td>\n",
              "      <td>cayucos</td>\n",
              "      <td>Estero Bluffs Trail, cayucos, California</td>\n",
              "      <td>Estero Bluffs Trail</td>\n",
              "      <td>Estero Bluffs Trail, 1 Mile North of Cayucos o...</td>\n",
              "      <td>and Estero bluffs trails in Cayucos</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>84</th>\n",
              "      <td>Kyla</td>\n",
              "      <td>san mateo county</td>\n",
              "      <td>Martin's Beach, san mateo county, California</td>\n",
              "      <td>Martin's Beach</td>\n",
              "      <td>Martin's Beach, Martin's Beach Rd, Half Moon B...</td>\n",
              "      <td>martin's beach (this one is top secret, so con...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>Rebekah Murphy</td>\n",
              "      <td>san francisco</td>\n",
              "      <td>6th Avenue Skate Park, san francisco, California</td>\n",
              "      <td>6th Avenue Skate Park</td>\n",
              "      <td>6th Avenue Skate Park, 6th Ave &amp; Kirkham St, S...</td>\n",
              "      <td>I really love Golden Gate Park on Sunday and w...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>Rebekah Murphy</td>\n",
              "      <td>redlands</td>\n",
              "      <td>Caroline Park, redlands, California</td>\n",
              "      <td>Caroline Park</td>\n",
              "      <td>Caroline Park, 1630 Caroline St, Redlands, CA ...</td>\n",
              "      <td>I have to plug Redlands... sorry. but if you ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Shubhangi Bose</td>\n",
              "      <td>tillamook, OR</td>\n",
              "      <td>Tunnel Beach, tillamook, OR, California</td>\n",
              "      <td>Tunnel Beach</td>\n",
              "      <td>Tunnel Beach, Oregon 97141</td>\n",
              "      <td>Tunnel Beach (OR),</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>141</th>\n",
              "      <td>Sophia Roy-Burman</td>\n",
              "      <td>trinity county</td>\n",
              "      <td>Trinity Alps, trinity county, California</td>\n",
              "      <td>Trinity Alps</td>\n",
              "      <td>Trinity Alps, Trinity Alps Wilderness, Weaverv...</td>\n",
              "      <td>trinity alps!</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>158</th>\n",
              "      <td>Vika Stukalova</td>\n",
              "      <td>berkeley</td>\n",
              "      <td>Big C, berkeley, California</td>\n",
              "      <td>Big C</td>\n",
              "      <td>Big C, Berkeley Fire Trails, Berkeley, CA 94720</td>\n",
              "      <td>the one swing in berk</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-6c3b286b-04c7-41c8-b432-57e96e9ad78a')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-6c3b286b-04c7-41c8-b432-57e96e9ad78a button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-6c3b286b-04c7-41c8-b432-57e96e9ad78a');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-5a9a36ef-908a-4ade-b471-1b4538dc79fb\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-5a9a36ef-908a-4ade-b471-1b4538dc79fb')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-5a9a36ef-908a-4ade-b471-1b4538dc79fb button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"# hd\",\n  \"rows\": 11,\n  \"fields\": [\n    {\n      \"column\": \"person_name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 10,\n        \"samples\": [\n          \"Sophia Roy-Burman\",\n          \"grace\",\n          \"Kyla\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"place\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 9,\n        \"samples\": [\n          \"trinity county\",\n          \"san francisco\",\n          \"redlands\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"address\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"Martin's Beach, san mateo county, California\",\n          \"Garden of Eden - Henry Cowell Redwood State Park, santa cruz, California\",\n          \"Trinity Alps, trinity county, California\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"place_name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"Martin's Beach\",\n          \"Garden of Eden - Henry Cowell Redwood State Park\",\n          \"Trinity Alps\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"genr_address\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"Martin's Beach, Martin's Beach Rd, Half Moon Bay, CA 94019\",\n          \"Garden of Eden, Henry Cowell Redwoods State Park, 2100-4166 State Rte 9, Felton, CA 95018\",\n          \"Trinity Alps, Trinity Alps Wilderness, Weaverville, CA 96093\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"text\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"martin's beach (this one is top secret, so consider it an excellent price).\",\n          \"Garden of Eden (classic)\",\n          \"trinity alps!\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"latitude\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": null,\n        \"min\": null,\n        \"max\": null,\n        \"num_unique_values\": 0,\n        \"samples\": [],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"longitude\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": null,\n        \"min\": null,\n        \"max\": null,\n        \"num_unique_values\": 0,\n        \"samples\": [],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#shameful manual edits...\n",
        "\n",
        "hdf = hd.copy()\n",
        "\n",
        "hdf.loc[7, ['longitude', 'latitude']] = [-122.064625, 37.035238]\n",
        "hdf.loc[13, ['longitude', 'latitude']] = [-122.008907, 41.240927] #mccloud\n",
        "hdf.loc[36, ['longitude', 'latitude']] = [-119.628304, 37.730343] #horsetail\n",
        "hdf.loc[42, ['longitude', 'latitude']] = [-122.427564, 37.804721]\n",
        "hdf.loc[45, ['longitude', 'latitude']] = [-122.227929, 37.760009] #xmas lane\n",
        "hdf.loc[57, ['longitude', 'latitude']] = [-122.320605, 37.435343]\n",
        "hdf.loc[59, ['longitude', 'latitude']] = [-122.274604, 37.096702] #waddell\n",
        "hdf.loc[68, ['longitude', 'latitude']] = [-122.159183, 37.458628] #ur mom\n",
        "hdf.loc[71, ['longitude', 'latitude']] = [-120.986634, 35.473485]\n",
        "hdf.loc[73, ['longitude', 'latitude']] = [-122.209578, 37.827280] #montclair neighborhood\n",
        "hdf.loc[84, ['longitude', 'latitude']] = [-122.406816, 37.375462] #martin's\n",
        "hdf.loc[125, ['longitude', 'latitude']] = [-122.464048, 37.772724]\n",
        "hdf.loc[127, ['longitude', 'latitude']] = [-117.158167, 34.023272] #caro park\n",
        "hdf.loc[131, ['longitude', 'latitude']] = [-121.498534, 38.583445] #tower theatre\n",
        "hdf.loc[135, ['longitude', 'latitude']] = [-123.973731, 45.463856] #oregon\n",
        "hdf.loc[141, ['longitude', 'latitude']] = [-123.048539, 41.005859]\n",
        "hdf.loc[153, ['longitude', 'latitude']] = [-122.257766, 37.873664] #evans\n",
        "hdf.loc[158, ['longitude', 'latitude']] = [-122.249686, 37.875483]\n"
      ],
      "metadata": {
        "id": "ThL04s4sbp7G"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import geopandas as gpd\n",
        "from shapely.geometry import Point\n",
        "\n",
        "geometry = [Point(xy) for xy in zip(hdf['longitude'], hdf['latitude'])]\n",
        "gdf = gpd.GeoDataFrame(hdf, geometry=geometry, crs=\"EPSG:4326\")"
      ],
      "metadata": {
        "id": "oV9Rs6PW8waT"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import folium\n",
        "\n",
        "map = folium.Map(location=[36.7783, -119.4179], zoom_start=6)  # center on California\n",
        "\n",
        "grouped = gdf.groupby(['latitude', 'longitude'])\n",
        "\n",
        "location_data = {}\n",
        "for (lat, lon), group in grouped:\n",
        "    place_name = group['place_name'].iloc[0]  # use the first place_name as the main header\n",
        "    entries = group.apply(lambda row: f\"{row['person_name']}: {row['text']}\", axis=1).tolist()\n",
        "    location_data[(lat, lon)] = {'place_name': place_name, 'entries': entries}\n",
        "\n",
        "for (lat, lon), data in location_data.items():\n",
        "    html = f\"\"\"\n",
        "    <div style=\"width:300px\">\n",
        "        <h4>{data['place_name']}</h4>\n",
        "        {'<br>'.join(data['entries'])}\n",
        "    </div>\n",
        "    \"\"\"\n",
        "    popup = folium.Popup(folium.Html(html, script=True))\n",
        "    folium.Marker(\n",
        "        location=[lat, lon],\n",
        "        popup=popup,\n",
        "        tooltip=data['place_name']\n",
        "    ).add_to(map)\n",
        "\n",
        "map.save(\"henrys21stgeoids.html\")"
      ],
      "metadata": {
        "id": "NH8EmdM5FgNS"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}