cleanmachine.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyOb3OVSqft3hXojFFOdoOGt",
      "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/sehbaw/allthingspractice/blob/main/cleanmachine.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": {
        "id": "xzjaN1HpeQga"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import seaborn as sns\n",
        "import numpy as np"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv(\"/bmore.csv\")"
      ],
      "metadata": {
        "id": "1C0S9aXK1DZl"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()\n",
        "\n",
        "df.dropna()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 597
        },
        "id": "0nc2fGg91W2J",
        "outputId": "f1f41121-2a0b-413e-d5c0-862d6ce9ecfe"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                         organization  \\\n",
              "0          Modell Performing Arts Center at the Lyric   \n",
              "1   National James Baldwin Literary Society, Inc./BMI   \n",
              "2                              Vagabond Players, Inc.   \n",
              "3                             Baltimore Jazz Alliance   \n",
              "4                                     CityLit Project   \n",
              "..                                                ...   \n",
              "75                                  Creative Alliance   \n",
              "76                                          ARTblocks   \n",
              "77                                         Hippodrome   \n",
              "78         Station North Art & Entertainment District   \n",
              "79                             MD Humanities Council    \n",
              "\n",
              "                               adress      cityState  zipCode  \\\n",
              "0                140 West Mount Royal  Baltimore, MD    21201   \n",
              "1              3618 Greenmount Avenue  Baltimore, MD    21218   \n",
              "2                     806 S. Broadway  Baltimore, MD    21231   \n",
              "3                847 N. Howard Street  Baltimore, MD    21201   \n",
              "4                120 S. Curley Street  Baltimore, MD    21224   \n",
              "..                                ...            ...      ...   \n",
              "75                   3134 Eastern Ave  Baltimore, MD    21224   \n",
              "76                 834 W. 36th Street  Baltimore, MD    21211   \n",
              "77              12 Nprth Eutaw Street  Baltimore, MD    21201   \n",
              "78  1800 N. Charles Street, Suite 810  Baltimore, MD    21201   \n",
              "79                    108 West Centre  Baltimore, MD    21201   \n",
              "\n",
              "                                           URL  \\\n",
              "0              http://www.lyricoperahouse.com/   \n",
              "1       http://jamesbaldwin.org/Home_Page.html   \n",
              "2              http://www.vagabondplayers.org/   \n",
              "3                http://www.baltimorejazz.com/   \n",
              "4               http://www.citylitproject.org/   \n",
              "..                                         ...   \n",
              "75            http://www.creativealliance.org/   \n",
              "76          http://www.artblocks.org/home.html   \n",
              "77  http://www.france-merrickpac.com/home.html   \n",
              "78                http://www.stationnorth.org/   \n",
              "79                        http://www.mdhc.org/   \n",
              "\n",
              "                                           Location 1  \n",
              "0   140 West Mount Royal\\n21201\\n(39.3058073139683...  \n",
              "1   3618 Greenmount Avenue\\n21218\\n(39.33299362145...  \n",
              "2   806 S. Broadway\\n21231\\n(39.28234380476192, -7...  \n",
              "3   847 N. Howard Street\\n21201\\n(39.2996737402664...  \n",
              "4   120 S. Curley Street\\n21224\\n(39.2906265606517...  \n",
              "..                                                ...  \n",
              "75  3134 Eastern Ave\\n21224\\n(39.28643571999521, -...  \n",
              "76  834 W. 36th Street\\n21211\\n(39.33117699095288,...  \n",
              "77  12 Nprth Eutaw Street\\n21201\\n(39.294880000000...  \n",
              "78  1800 N. Charles Street, Suite 810\\n21201\\n(39....  \n",
              "79  108 West Centre\\n21201\\n(39.294880000000035, -...  \n",
              "\n",
              "[74 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bd4eca35-0f40-4a0d-8374-9f238e5a7834\" 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>organization</th>\n",
              "      <th>adress</th>\n",
              "      <th>cityState</th>\n",
              "      <th>zipCode</th>\n",
              "      <th>URL</th>\n",
              "      <th>Location 1</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Modell Performing Arts Center at the Lyric</td>\n",
              "      <td>140 West Mount Royal</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.lyricoperahouse.com/</td>\n",
              "      <td>140 West Mount Royal\\n21201\\n(39.3058073139683...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>National James Baldwin Literary Society, Inc./BMI</td>\n",
              "      <td>3618 Greenmount Avenue</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21218</td>\n",
              "      <td>http://jamesbaldwin.org/Home_Page.html</td>\n",
              "      <td>3618 Greenmount Avenue\\n21218\\n(39.33299362145...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Vagabond Players, Inc.</td>\n",
              "      <td>806 S. Broadway</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21231</td>\n",
              "      <td>http://www.vagabondplayers.org/</td>\n",
              "      <td>806 S. Broadway\\n21231\\n(39.28234380476192, -7...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Baltimore Jazz Alliance</td>\n",
              "      <td>847 N. Howard Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.baltimorejazz.com/</td>\n",
              "      <td>847 N. Howard Street\\n21201\\n(39.2996737402664...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>CityLit Project</td>\n",
              "      <td>120 S. Curley Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21224</td>\n",
              "      <td>http://www.citylitproject.org/</td>\n",
              "      <td>120 S. Curley Street\\n21224\\n(39.2906265606517...</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>Creative Alliance</td>\n",
              "      <td>3134 Eastern Ave</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21224</td>\n",
              "      <td>http://www.creativealliance.org/</td>\n",
              "      <td>3134 Eastern Ave\\n21224\\n(39.28643571999521, -...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>ARTblocks</td>\n",
              "      <td>834 W. 36th Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21211</td>\n",
              "      <td>http://www.artblocks.org/home.html</td>\n",
              "      <td>834 W. 36th Street\\n21211\\n(39.33117699095288,...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>Hippodrome</td>\n",
              "      <td>12 Nprth Eutaw Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.france-merrickpac.com/home.html</td>\n",
              "      <td>12 Nprth Eutaw Street\\n21201\\n(39.294880000000...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78</th>\n",
              "      <td>Station North Art &amp; Entertainment District</td>\n",
              "      <td>1800 N. Charles Street, Suite 810</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.stationnorth.org/</td>\n",
              "      <td>1800 N. Charles Street, Suite 810\\n21201\\n(39....</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>79</th>\n",
              "      <td>MD Humanities Council</td>\n",
              "      <td>108 West Centre</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.mdhc.org/</td>\n",
              "      <td>108 West Centre\\n21201\\n(39.294880000000035, -...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>74 rows × 6 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-bd4eca35-0f40-4a0d-8374-9f238e5a7834')\"\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-bd4eca35-0f40-4a0d-8374-9f238e5a7834 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-bd4eca35-0f40-4a0d-8374-9f238e5a7834');\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-16d47589-7303-4d95-a48b-7a30ffe86d88\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-16d47589-7303-4d95-a48b-7a30ffe86d88')\"\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-16d47589-7303-4d95-a48b-7a30ffe86d88 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\": \"df\",\n  \"rows\": 74,\n  \"fields\": [\n    {\n      \"column\": \"organization\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 74,\n        \"samples\": [\n          \"CityLit Project\",\n          \"Black Cherry Puppet Theater\",\n          \"Baltimore Symphony Orchestra\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"adress\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 71,\n        \"samples\": [\n          \"35 Market Place\",\n          \"140 West Mount Royal\",\n          \"306 Suffolk Road\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"cityState\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"Baltimore, MD\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"zipCode\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 11,\n        \"min\": 21201,\n        \"max\": 21251,\n        \"num_unique_values\": 20,\n        \"samples\": [\n          21201\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"URL\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 74,\n        \"samples\": [\n          \"http://www.citylitproject.org/\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Location 1\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 71,\n        \"samples\": [\n          \"35 Market Place\\n21202\\n(39.288206791276075, -76.60666138878938)\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "I want to split the last column"
      ],
      "metadata": {
        "id": "48zkR-UU1mio"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df[['lat', 'lon']] = df['Location 1'].str.split(' ', expand=True)\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 321
        },
        "id": "yHhoCIGs1oLN",
        "outputId": "453c688f-9655-44ad-e4e7-cf636f3b5745"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "error",
          "ename": "ValueError",
          "evalue": "Columns must be same length as key",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-4-54a509aecf30>\u001b[0m in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'lat'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'lon'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Location 1'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m' '\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mexpand\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m__setitem__\u001b[0;34m(self, key, value)\u001b[0m\n\u001b[1;32m   3936\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_setitem_frame\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3937\u001b[0m         \u001b[0;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mSeries\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mndarray\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mIndex\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3938\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_setitem_array\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3939\u001b[0m         \u001b[0;32melif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mvalue\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mDataFrame\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3940\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_set_item_frame_value\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m_setitem_array\u001b[0;34m(self, key, value)\u001b[0m\n\u001b[1;32m   3978\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3979\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mvalue\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mDataFrame\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3980\u001b[0;31m                 \u001b[0mcheck_key_length\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3981\u001b[0m                 \u001b[0;32mfor\u001b[0m \u001b[0mk1\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mk2\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mzip\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3982\u001b[0m                     \u001b[0mself\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mk1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mk2\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/core/indexers/utils.py\u001b[0m in \u001b[0;36mcheck_key_length\u001b[0;34m(columns, key, value)\u001b[0m\n\u001b[1;32m    390\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_unique\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    391\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mvalue\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 392\u001b[0;31m             \u001b[0;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"Columns must be same length as key\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    393\u001b[0m     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    394\u001b[0m         \u001b[0;31m# Missing keys in columns are represented as -1\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mValueError\u001b[0m: Columns must be same length as key"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df[['address', 'zip', 'lat', 'lon']] = df['Location 1'].str.extract(r'(.+?)\\s(\\d{5})\\s\\(([^,]+),\\s([^)]+)\\)', expand=True)\n",
        "df\n",
        "\n",
        "df[[\"city\", \"state\"]] = df[\"cityState\"].str.split(' ', expand=True)\n",
        "df\n",
        "\n",
        "df[\"city\"].replace(\",\", \" \")\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 843
        },
        "id": "PV3MG5Gqx_X0",
        "outputId": "f749bb97-9434-470a-df3b-d0daca2c3e34"
      },
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                         organization  \\\n",
              "0          Modell Performing Arts Center at the Lyric   \n",
              "1   National James Baldwin Literary Society, Inc./BMI   \n",
              "2                              Vagabond Players, Inc.   \n",
              "3                             Baltimore Jazz Alliance   \n",
              "4                                     CityLit Project   \n",
              "..                                                ...   \n",
              "75                                  Creative Alliance   \n",
              "76                                          ARTblocks   \n",
              "77                                         Hippodrome   \n",
              "78         Station North Art & Entertainment District   \n",
              "79                             MD Humanities Council    \n",
              "\n",
              "                               adress      cityState  zipCode  \\\n",
              "0                140 West Mount Royal  Baltimore, MD    21201   \n",
              "1              3618 Greenmount Avenue  Baltimore, MD    21218   \n",
              "2                     806 S. Broadway  Baltimore, MD    21231   \n",
              "3                847 N. Howard Street  Baltimore, MD    21201   \n",
              "4                120 S. Curley Street  Baltimore, MD    21224   \n",
              "..                                ...            ...      ...   \n",
              "75                   3134 Eastern Ave  Baltimore, MD    21224   \n",
              "76                 834 W. 36th Street  Baltimore, MD    21211   \n",
              "77              12 Nprth Eutaw Street  Baltimore, MD    21201   \n",
              "78  1800 N. Charles Street, Suite 810  Baltimore, MD    21201   \n",
              "79                    108 West Centre  Baltimore, MD    21201   \n",
              "\n",
              "                                           URL  \\\n",
              "0              http://www.lyricoperahouse.com/   \n",
              "1       http://jamesbaldwin.org/Home_Page.html   \n",
              "2              http://www.vagabondplayers.org/   \n",
              "3                http://www.baltimorejazz.com/   \n",
              "4               http://www.citylitproject.org/   \n",
              "..                                         ...   \n",
              "75            http://www.creativealliance.org/   \n",
              "76          http://www.artblocks.org/home.html   \n",
              "77  http://www.france-merrickpac.com/home.html   \n",
              "78                http://www.stationnorth.org/   \n",
              "79                        http://www.mdhc.org/   \n",
              "\n",
              "                                           Location 1  \\\n",
              "0   140 West Mount Royal\\n21201\\n(39.3058073139683...   \n",
              "1   3618 Greenmount Avenue\\n21218\\n(39.33299362145...   \n",
              "2   806 S. Broadway\\n21231\\n(39.28234380476192, -7...   \n",
              "3   847 N. Howard Street\\n21201\\n(39.2996737402664...   \n",
              "4   120 S. Curley Street\\n21224\\n(39.2906265606517...   \n",
              "..                                                ...   \n",
              "75  3134 Eastern Ave\\n21224\\n(39.28643571999521, -...   \n",
              "76  834 W. 36th Street\\n21211\\n(39.33117699095288,...   \n",
              "77  12 Nprth Eutaw Street\\n21201\\n(39.294880000000...   \n",
              "78  1800 N. Charles Street, Suite 810\\n21201\\n(39....   \n",
              "79  108 West Centre\\n21201\\n(39.294880000000035, -...   \n",
              "\n",
              "                              address    zip                 lat  \\\n",
              "0                140 West Mount Royal  21201   39.30580731396832   \n",
              "1              3618 Greenmount Avenue  21218   39.33299362145209   \n",
              "2                     806 S. Broadway  21231   39.28234380476192   \n",
              "3                847 N. Howard Street  21201  39.299673740266485   \n",
              "4                120 S. Curley Street  21224   39.29062656065173   \n",
              "..                                ...    ...                 ...   \n",
              "75                   3134 Eastern Ave  21224   39.28643571999521   \n",
              "76                 834 W. 36th Street  21211   39.33117699095288   \n",
              "77              12 Nprth Eutaw Street  21201  39.294880000000035   \n",
              "78  1800 N. Charles Street, Suite 810  21201    39.3099889639426   \n",
              "79                    108 West Centre  21201  39.294880000000035   \n",
              "\n",
              "                   lon        city state  \n",
              "0   -76.61863173205661  Baltimore,    MD  \n",
              "1   -76.60948197894515  Baltimore,    MD  \n",
              "2     -76.593456060383  Baltimore,    MD  \n",
              "3   -76.62009397889085  Baltimore,    MD  \n",
              "4   -76.57537069437376  Baltimore,    MD  \n",
              "..                 ...         ...   ...  \n",
              "75   -76.5717644130363  Baltimore,    MD  \n",
              "76  -76.63059806019311  Baltimore,    MD  \n",
              "77  -76.62253999999996  Baltimore,    MD  \n",
              "78   -76.6164876975534  Baltimore,    MD  \n",
              "79  -76.62253999999996  Baltimore,    MD  \n",
              "\n",
              "[80 rows x 12 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0e5c50d6-82c4-4879-a717-e8f4cd755c43\" 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>organization</th>\n",
              "      <th>adress</th>\n",
              "      <th>cityState</th>\n",
              "      <th>zipCode</th>\n",
              "      <th>URL</th>\n",
              "      <th>Location 1</th>\n",
              "      <th>address</th>\n",
              "      <th>zip</th>\n",
              "      <th>lat</th>\n",
              "      <th>lon</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Modell Performing Arts Center at the Lyric</td>\n",
              "      <td>140 West Mount Royal</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.lyricoperahouse.com/</td>\n",
              "      <td>140 West Mount Royal\\n21201\\n(39.3058073139683...</td>\n",
              "      <td>140 West Mount Royal</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.30580731396832</td>\n",
              "      <td>-76.61863173205661</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>National James Baldwin Literary Society, Inc./BMI</td>\n",
              "      <td>3618 Greenmount Avenue</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21218</td>\n",
              "      <td>http://jamesbaldwin.org/Home_Page.html</td>\n",
              "      <td>3618 Greenmount Avenue\\n21218\\n(39.33299362145...</td>\n",
              "      <td>3618 Greenmount Avenue</td>\n",
              "      <td>21218</td>\n",
              "      <td>39.33299362145209</td>\n",
              "      <td>-76.60948197894515</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Vagabond Players, Inc.</td>\n",
              "      <td>806 S. Broadway</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21231</td>\n",
              "      <td>http://www.vagabondplayers.org/</td>\n",
              "      <td>806 S. Broadway\\n21231\\n(39.28234380476192, -7...</td>\n",
              "      <td>806 S. Broadway</td>\n",
              "      <td>21231</td>\n",
              "      <td>39.28234380476192</td>\n",
              "      <td>-76.593456060383</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Baltimore Jazz Alliance</td>\n",
              "      <td>847 N. Howard Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.baltimorejazz.com/</td>\n",
              "      <td>847 N. Howard Street\\n21201\\n(39.2996737402664...</td>\n",
              "      <td>847 N. Howard Street</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.299673740266485</td>\n",
              "      <td>-76.62009397889085</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>CityLit Project</td>\n",
              "      <td>120 S. Curley Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21224</td>\n",
              "      <td>http://www.citylitproject.org/</td>\n",
              "      <td>120 S. Curley Street\\n21224\\n(39.2906265606517...</td>\n",
              "      <td>120 S. Curley Street</td>\n",
              "      <td>21224</td>\n",
              "      <td>39.29062656065173</td>\n",
              "      <td>-76.57537069437376</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>Creative Alliance</td>\n",
              "      <td>3134 Eastern Ave</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21224</td>\n",
              "      <td>http://www.creativealliance.org/</td>\n",
              "      <td>3134 Eastern Ave\\n21224\\n(39.28643571999521, -...</td>\n",
              "      <td>3134 Eastern Ave</td>\n",
              "      <td>21224</td>\n",
              "      <td>39.28643571999521</td>\n",
              "      <td>-76.5717644130363</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>ARTblocks</td>\n",
              "      <td>834 W. 36th Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21211</td>\n",
              "      <td>http://www.artblocks.org/home.html</td>\n",
              "      <td>834 W. 36th Street\\n21211\\n(39.33117699095288,...</td>\n",
              "      <td>834 W. 36th Street</td>\n",
              "      <td>21211</td>\n",
              "      <td>39.33117699095288</td>\n",
              "      <td>-76.63059806019311</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>Hippodrome</td>\n",
              "      <td>12 Nprth Eutaw Street</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.france-merrickpac.com/home.html</td>\n",
              "      <td>12 Nprth Eutaw Street\\n21201\\n(39.294880000000...</td>\n",
              "      <td>12 Nprth Eutaw Street</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.294880000000035</td>\n",
              "      <td>-76.62253999999996</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78</th>\n",
              "      <td>Station North Art &amp; Entertainment District</td>\n",
              "      <td>1800 N. Charles Street, Suite 810</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.stationnorth.org/</td>\n",
              "      <td>1800 N. Charles Street, Suite 810\\n21201\\n(39....</td>\n",
              "      <td>1800 N. Charles Street, Suite 810</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.3099889639426</td>\n",
              "      <td>-76.6164876975534</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>79</th>\n",
              "      <td>MD Humanities Council</td>\n",
              "      <td>108 West Centre</td>\n",
              "      <td>Baltimore, MD</td>\n",
              "      <td>21201</td>\n",
              "      <td>http://www.mdhc.org/</td>\n",
              "      <td>108 West Centre\\n21201\\n(39.294880000000035, -...</td>\n",
              "      <td>108 West Centre</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.294880000000035</td>\n",
              "      <td>-76.62253999999996</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>80 rows × 12 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-0e5c50d6-82c4-4879-a717-e8f4cd755c43')\"\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-0e5c50d6-82c4-4879-a717-e8f4cd755c43 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-0e5c50d6-82c4-4879-a717-e8f4cd755c43');\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-d0bb1b39-80a3-4957-bd1c-49c15222281a\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d0bb1b39-80a3-4957-bd1c-49c15222281a')\"\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-d0bb1b39-80a3-4957-bd1c-49c15222281a button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_2306bf92-df8b-4b60-8e65-f3902475acb3\">\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('df')\"\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_2306bf92-df8b-4b60-8e65-f3902475acb3 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('df');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df",
              "summary": "{\n  \"name\": \"df\",\n  \"rows\": 80,\n  \"fields\": [\n    {\n      \"column\": \"organization\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 80,\n        \"samples\": [\n          \"Walters - Literary Arts Week \",\n          \"Modell Performing Arts Center at the Lyric\",\n          \"Unchained Talent\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"adress\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 76,\n        \"samples\": [\n          \"120 S. Curley Street\",\n          \"1823 N. Charles Street\",\n          \"1727 N. Charles Street\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"cityState\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"Baltimore, MD\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"zipCode\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 11,\n        \"min\": 21201,\n        \"max\": 21251,\n        \"num_unique_values\": 21,\n        \"samples\": [\n          21201\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"URL\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 74,\n        \"samples\": [\n          \"http://www.citylitproject.org/\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Location 1\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 76,\n        \"samples\": [\n          \"120 S. Curley Street\\n21224\\n(39.29062656065173, -76.57537069437376)\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"address\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 76,\n        \"samples\": [\n          \"120 S. Curley Street\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"zip\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 21,\n        \"samples\": [\n          \"21201\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"lat\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 71,\n        \"samples\": [\n          \"39.331788529932794\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"lon\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 71,\n        \"samples\": [\n          \"-76.6448613075778\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"city\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"Baltimore,\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"state\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"MD\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.drop(columns=[\"Location 1\", \"adress\", \"cityState\", \"zipCode\"])"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "NUflB5CS_wBS",
        "outputId": "68ee1064-a5ab-4757-c172-927ce4bfbe19"
      },
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                         organization  \\\n",
              "0          Modell Performing Arts Center at the Lyric   \n",
              "1   National James Baldwin Literary Society, Inc./BMI   \n",
              "2                              Vagabond Players, Inc.   \n",
              "3                             Baltimore Jazz Alliance   \n",
              "4                                     CityLit Project   \n",
              "..                                                ...   \n",
              "75                                  Creative Alliance   \n",
              "76                                          ARTblocks   \n",
              "77                                         Hippodrome   \n",
              "78         Station North Art & Entertainment District   \n",
              "79                             MD Humanities Council    \n",
              "\n",
              "                                           URL  \\\n",
              "0              http://www.lyricoperahouse.com/   \n",
              "1       http://jamesbaldwin.org/Home_Page.html   \n",
              "2              http://www.vagabondplayers.org/   \n",
              "3                http://www.baltimorejazz.com/   \n",
              "4               http://www.citylitproject.org/   \n",
              "..                                         ...   \n",
              "75            http://www.creativealliance.org/   \n",
              "76          http://www.artblocks.org/home.html   \n",
              "77  http://www.france-merrickpac.com/home.html   \n",
              "78                http://www.stationnorth.org/   \n",
              "79                        http://www.mdhc.org/   \n",
              "\n",
              "                              address    zip                 lat  \\\n",
              "0                140 West Mount Royal  21201   39.30580731396832   \n",
              "1              3618 Greenmount Avenue  21218   39.33299362145209   \n",
              "2                     806 S. Broadway  21231   39.28234380476192   \n",
              "3                847 N. Howard Street  21201  39.299673740266485   \n",
              "4                120 S. Curley Street  21224   39.29062656065173   \n",
              "..                                ...    ...                 ...   \n",
              "75                   3134 Eastern Ave  21224   39.28643571999521   \n",
              "76                 834 W. 36th Street  21211   39.33117699095288   \n",
              "77              12 Nprth Eutaw Street  21201  39.294880000000035   \n",
              "78  1800 N. Charles Street, Suite 810  21201    39.3099889639426   \n",
              "79                    108 West Centre  21201  39.294880000000035   \n",
              "\n",
              "                   lon        city state  \n",
              "0   -76.61863173205661  Baltimore,    MD  \n",
              "1   -76.60948197894515  Baltimore,    MD  \n",
              "2     -76.593456060383  Baltimore,    MD  \n",
              "3   -76.62009397889085  Baltimore,    MD  \n",
              "4   -76.57537069437376  Baltimore,    MD  \n",
              "..                 ...         ...   ...  \n",
              "75   -76.5717644130363  Baltimore,    MD  \n",
              "76  -76.63059806019311  Baltimore,    MD  \n",
              "77  -76.62253999999996  Baltimore,    MD  \n",
              "78   -76.6164876975534  Baltimore,    MD  \n",
              "79  -76.62253999999996  Baltimore,    MD  \n",
              "\n",
              "[80 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bf38739e-82cf-4974-a31b-37aa2e5230f4\" 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>organization</th>\n",
              "      <th>URL</th>\n",
              "      <th>address</th>\n",
              "      <th>zip</th>\n",
              "      <th>lat</th>\n",
              "      <th>lon</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Modell Performing Arts Center at the Lyric</td>\n",
              "      <td>http://www.lyricoperahouse.com/</td>\n",
              "      <td>140 West Mount Royal</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.30580731396832</td>\n",
              "      <td>-76.61863173205661</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>National James Baldwin Literary Society, Inc./BMI</td>\n",
              "      <td>http://jamesbaldwin.org/Home_Page.html</td>\n",
              "      <td>3618 Greenmount Avenue</td>\n",
              "      <td>21218</td>\n",
              "      <td>39.33299362145209</td>\n",
              "      <td>-76.60948197894515</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Vagabond Players, Inc.</td>\n",
              "      <td>http://www.vagabondplayers.org/</td>\n",
              "      <td>806 S. Broadway</td>\n",
              "      <td>21231</td>\n",
              "      <td>39.28234380476192</td>\n",
              "      <td>-76.593456060383</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Baltimore Jazz Alliance</td>\n",
              "      <td>http://www.baltimorejazz.com/</td>\n",
              "      <td>847 N. Howard Street</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.299673740266485</td>\n",
              "      <td>-76.62009397889085</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>CityLit Project</td>\n",
              "      <td>http://www.citylitproject.org/</td>\n",
              "      <td>120 S. Curley Street</td>\n",
              "      <td>21224</td>\n",
              "      <td>39.29062656065173</td>\n",
              "      <td>-76.57537069437376</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</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>75</th>\n",
              "      <td>Creative Alliance</td>\n",
              "      <td>http://www.creativealliance.org/</td>\n",
              "      <td>3134 Eastern Ave</td>\n",
              "      <td>21224</td>\n",
              "      <td>39.28643571999521</td>\n",
              "      <td>-76.5717644130363</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>ARTblocks</td>\n",
              "      <td>http://www.artblocks.org/home.html</td>\n",
              "      <td>834 W. 36th Street</td>\n",
              "      <td>21211</td>\n",
              "      <td>39.33117699095288</td>\n",
              "      <td>-76.63059806019311</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>Hippodrome</td>\n",
              "      <td>http://www.france-merrickpac.com/home.html</td>\n",
              "      <td>12 Nprth Eutaw Street</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.294880000000035</td>\n",
              "      <td>-76.62253999999996</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>78</th>\n",
              "      <td>Station North Art &amp; Entertainment District</td>\n",
              "      <td>http://www.stationnorth.org/</td>\n",
              "      <td>1800 N. Charles Street, Suite 810</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.3099889639426</td>\n",
              "      <td>-76.6164876975534</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>79</th>\n",
              "      <td>MD Humanities Council</td>\n",
              "      <td>http://www.mdhc.org/</td>\n",
              "      <td>108 West Centre</td>\n",
              "      <td>21201</td>\n",
              "      <td>39.294880000000035</td>\n",
              "      <td>-76.62253999999996</td>\n",
              "      <td>Baltimore,</td>\n",
              "      <td>MD</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>80 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-bf38739e-82cf-4974-a31b-37aa2e5230f4')\"\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-bf38739e-82cf-4974-a31b-37aa2e5230f4 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-bf38739e-82cf-4974-a31b-37aa2e5230f4');\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-fa37dd9d-8903-4c1a-a54d-50d71d51abce\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-fa37dd9d-8903-4c1a-a54d-50d71d51abce')\"\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-fa37dd9d-8903-4c1a-a54d-50d71d51abce 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\": \"df\",\n  \"rows\": 80,\n  \"fields\": [\n    {\n      \"column\": \"organization\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 80,\n        \"samples\": [\n          \"Walters - Literary Arts Week \",\n          \"Modell Performing Arts Center at the Lyric\",\n          \"Unchained Talent\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"URL\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 74,\n        \"samples\": [\n          \"http://www.citylitproject.org/\",\n          \"http://www.blackcherry.org/\",\n          \"http://www.bsomusic.org/\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"address\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 76,\n        \"samples\": [\n          \"120 S. Curley Street\",\n          \"1823 N. Charles Street\",\n          \"1727 N. Charles Street\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"zip\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 21,\n        \"samples\": [\n          \"21201\",\n          \"21223\",\n          \"21209\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"lat\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 71,\n        \"samples\": [\n          \"39.331788529932794\",\n          \"39.30580731396832\",\n          \"39.329890960450996\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"lon\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 71,\n        \"samples\": [\n          \"-76.6448613075778\",\n          \"-76.61863173205661\",\n          \"-76.6082678942056\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"city\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"Baltimore,\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"state\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"MD\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "dFtMjT_7LWRJ"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}