Lab3/Lab_3_Task.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "k6wE5HbzsyOo"
      },
      "outputs": [],
      "source": [
        "import numpy as np\n",
        "import pandas as pd "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "3Uvfy6Roc3LN"
      },
      "source": [
        "## Cars Dataset\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 202
        },
        "id": "_5ORhanWtahJ",
        "outputId": "1d579084-8c8c-457b-a221-686b2d7c9d75"
      },
      "outputs": [
        {
          "data": {
            "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>Car</th>\n",
              "      <th>MPG</th>\n",
              "      <th>Cylinders</th>\n",
              "      <th>Displacement</th>\n",
              "      <th>Horsepower</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>Model</th>\n",
              "      <th>Origin</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>STRING</td>\n",
              "      <td>DOUBLE</td>\n",
              "      <td>INT</td>\n",
              "      <td>DOUBLE</td>\n",
              "      <td>DOUBLE</td>\n",
              "      <td>DOUBLE</td>\n",
              "      <td>DOUBLE</td>\n",
              "      <td>INT</td>\n",
              "      <td>CAT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Chevrolet Chevelle Malibu</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>307.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>3504.</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Buick Skylark 320</td>\n",
              "      <td>15.0</td>\n",
              "      <td>8</td>\n",
              "      <td>350.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3693.</td>\n",
              "      <td>11.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Plymouth Satellite</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>318.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>3436.</td>\n",
              "      <td>11.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AMC Rebel SST</td>\n",
              "      <td>16.0</td>\n",
              "      <td>8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>150.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                         Car     MPG Cylinders  ... Acceleration Model Origin\n",
              "0                     STRING  DOUBLE       INT  ...       DOUBLE   INT    CAT\n",
              "1  Chevrolet Chevelle Malibu     NaN         8  ...         12.0    70     US\n",
              "2          Buick Skylark 320    15.0         8  ...         11.5    70     US\n",
              "3         Plymouth Satellite     NaN         8  ...         11.0    70     US\n",
              "4              AMC Rebel SST    16.0         8  ...         12.0    70     US\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "execution_count": 2,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_cars= pd.read_csv('https://raw.githubusercontent.com/harshitroy2605/missing-value-in-dataset/master/cars.csv', sep=\";\")\n",
        "df_cars.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 202
        },
        "id": "HQZGgLJa5QUX",
        "outputId": "8beaeeec-2d3b-416b-d0e1-0031668c64b7"
      },
      "outputs": [
        {
          "data": {
            "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>Car</th>\n",
              "      <th>MPG</th>\n",
              "      <th>Cylinders</th>\n",
              "      <th>Displacement</th>\n",
              "      <th>Horsepower</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>Model</th>\n",
              "      <th>Origin</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Chevrolet Chevelle Malibu</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>307.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>3504.</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Buick Skylark 320</td>\n",
              "      <td>15.0</td>\n",
              "      <td>8</td>\n",
              "      <td>350.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3693.</td>\n",
              "      <td>11.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Plymouth Satellite</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>318.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>3436.</td>\n",
              "      <td>11.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AMC Rebel SST</td>\n",
              "      <td>16.0</td>\n",
              "      <td>8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>150.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Ford Torino</td>\n",
              "      <td>17.0</td>\n",
              "      <td>8</td>\n",
              "      <td>302.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>3449.</td>\n",
              "      <td>10.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                         Car   MPG Cylinders  ... Acceleration Model Origin\n",
              "1  Chevrolet Chevelle Malibu   NaN         8  ...         12.0    70     US\n",
              "2          Buick Skylark 320  15.0         8  ...         11.5    70     US\n",
              "3         Plymouth Satellite   NaN         8  ...         11.0    70     US\n",
              "4              AMC Rebel SST  16.0         8  ...         12.0    70     US\n",
              "5                Ford Torino  17.0         8  ...         10.5    70     US\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "execution_count": 4,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_cars = df_cars.iloc[1:]\n",
        "df_cars.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "5-jLL7ixtWBl",
        "outputId": "d106de9a-312b-488a-e020-477b48bbc428"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Car             0\n",
            "MPG             3\n",
            "Cylinders       0\n",
            "Displacement    1\n",
            "Horsepower      2\n",
            "Weight          1\n",
            "Acceleration    0\n",
            "Model           0\n",
            "Origin          0\n",
            "dtype: int64\n",
            "0.19157088122605362\n"
          ]
        }
      ],
      "source": [
        "# get the number of missing data points per column\n",
        "missing_values_count_cars = df_cars.isnull().sum()\n",
        "#look at the missing value\n",
        "print(missing_values_count_cars)\n",
        "# How many total missing values do we have?\n",
        "\n",
        "# shape returns the dimentionality of a dataframe (rows and columns), can you guess what product will do?\n",
        "total_cells_cars = np.product(df_cars.shape) \n",
        "total_missing_cars = missing_values_count_cars.sum()\n",
        "\n",
        "# percent of data that is missing\n",
        "percentage_missign_values_cars = (total_missing_cars/total_cells_cars) * 100\n",
        "print(percentage_missign_values_cars)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yNuqQzi1c6QG"
      },
      "source": [
        "For the `MPG` column we can fill in the missing values with 0s through the following line of code:\n",
        "\n",
        "`df_cars.fillna(0) `. "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "metadata": {
        "id": "mHpFT7ORc60G"
      },
      "outputs": [],
      "source": [
        "df_cars_temp = df_cars.fillna(0)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 202
        },
        "id": "xcFGCaexc-AP",
        "outputId": "01c50192-ad1d-4687-dff6-668a1d1c866b"
      },
      "outputs": [
        {
          "data": {
            "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>Car</th>\n",
              "      <th>MPG</th>\n",
              "      <th>Cylinders</th>\n",
              "      <th>Displacement</th>\n",
              "      <th>Horsepower</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>Model</th>\n",
              "      <th>Origin</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Chevrolet Chevelle Malibu</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>307.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>3504.</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Buick Skylark 320</td>\n",
              "      <td>15.0</td>\n",
              "      <td>8</td>\n",
              "      <td>350.0</td>\n",
              "      <td>0</td>\n",
              "      <td>3693.</td>\n",
              "      <td>11.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Plymouth Satellite</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>318.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>3436.</td>\n",
              "      <td>11.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AMC Rebel SST</td>\n",
              "      <td>16.0</td>\n",
              "      <td>8</td>\n",
              "      <td>0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Ford Torino</td>\n",
              "      <td>17.0</td>\n",
              "      <td>8</td>\n",
              "      <td>302.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>3449.</td>\n",
              "      <td>10.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                         Car   MPG Cylinders  ... Acceleration Model Origin\n",
              "1  Chevrolet Chevelle Malibu     0         8  ...         12.0    70     US\n",
              "2          Buick Skylark 320  15.0         8  ...         11.5    70     US\n",
              "3         Plymouth Satellite     0         8  ...         11.0    70     US\n",
              "4              AMC Rebel SST  16.0         8  ...         12.0    70     US\n",
              "5                Ford Torino  17.0         8  ...         10.5    70     US\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "execution_count": 7,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_cars_temp.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zTj3MB2NdALv"
      },
      "source": [
        "However, this does not make much sense as there isn't MPG equal to 0. How about we plot the MPG column and if it follows a random distribution we can use the mean of the column to compute the missing values. Otherwise, we can use the median (if there is a skewed distribution). "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 414
        },
        "id": "pEu34clQdCLV",
        "outputId": "3d4da35a-3e31-43e4-e13c-1dbcd9f0fe61"
      },
      "outputs": [
        {
          "data": {
            "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>Car</th>\n",
              "      <th>MPG</th>\n",
              "      <th>Cylinders</th>\n",
              "      <th>Displacement</th>\n",
              "      <th>Horsepower</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>Model</th>\n",
              "      <th>Origin</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Buick Skylark 320</td>\n",
              "      <td>15.0</td>\n",
              "      <td>8</td>\n",
              "      <td>350.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3693.</td>\n",
              "      <td>11.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Plymouth Satellite</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>318.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>3436.</td>\n",
              "      <td>11.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AMC Rebel SST</td>\n",
              "      <td>16.0</td>\n",
              "      <td>8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>150.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Ford Torino</td>\n",
              "      <td>17.0</td>\n",
              "      <td>8</td>\n",
              "      <td>302.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>3449.</td>\n",
              "      <td>10.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Ford Galaxie 500</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8</td>\n",
              "      <td>429.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4341.</td>\n",
              "      <td>10.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>402</th>\n",
              "      <td>Ford Mustang GL</td>\n",
              "      <td>27.0</td>\n",
              "      <td>4</td>\n",
              "      <td>140.0</td>\n",
              "      <td>86.00</td>\n",
              "      <td>2790.</td>\n",
              "      <td>15.6</td>\n",
              "      <td>82</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>403</th>\n",
              "      <td>Volkswagen Pickup</td>\n",
              "      <td>44.0</td>\n",
              "      <td>4</td>\n",
              "      <td>97.00</td>\n",
              "      <td>52.00</td>\n",
              "      <td>2130.</td>\n",
              "      <td>24.6</td>\n",
              "      <td>82</td>\n",
              "      <td>Europe</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>404</th>\n",
              "      <td>Dodge Rampage</td>\n",
              "      <td>32.0</td>\n",
              "      <td>4</td>\n",
              "      <td>135.0</td>\n",
              "      <td>84.00</td>\n",
              "      <td>2295.</td>\n",
              "      <td>11.6</td>\n",
              "      <td>82</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>405</th>\n",
              "      <td>Ford Ranger</td>\n",
              "      <td>28.0</td>\n",
              "      <td>4</td>\n",
              "      <td>120.0</td>\n",
              "      <td>79.00</td>\n",
              "      <td>2625.</td>\n",
              "      <td>18.6</td>\n",
              "      <td>82</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>406</th>\n",
              "      <td>Chevy S-10</td>\n",
              "      <td>31.0</td>\n",
              "      <td>4</td>\n",
              "      <td>119.0</td>\n",
              "      <td>82.00</td>\n",
              "      <td>2720.</td>\n",
              "      <td>19.4</td>\n",
              "      <td>82</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>405 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                    Car   MPG Cylinders  ... Acceleration Model  Origin\n",
              "2     Buick Skylark 320  15.0         8  ...         11.5    70      US\n",
              "3    Plymouth Satellite   NaN         8  ...         11.0    70      US\n",
              "4         AMC Rebel SST  16.0         8  ...         12.0    70      US\n",
              "5           Ford Torino  17.0         8  ...         10.5    70      US\n",
              "6      Ford Galaxie 500   NaN         8  ...         10.0    70      US\n",
              "..                  ...   ...       ...  ...          ...   ...     ...\n",
              "402     Ford Mustang GL  27.0         4  ...         15.6    82      US\n",
              "403   Volkswagen Pickup  44.0         4  ...         24.6    82  Europe\n",
              "404       Dodge Rampage  32.0         4  ...         11.6    82      US\n",
              "405         Ford Ranger  28.0         4  ...         18.6    82      US\n",
              "406          Chevy S-10  31.0         4  ...         19.4    82      US\n",
              "\n",
              "[405 rows x 9 columns]"
            ]
          },
          "execution_count": 8,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "import seaborn as sns \n",
        "import matplotlib.pyplot as plt\n",
        "df_cars = df_cars.iloc[1:] \n",
        "df_cars"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 9,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 355
        },
        "id": "jUmQPnm7dUHv",
        "outputId": "fdcc10f5-3efd-4ea6-8068-01a929c49371"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/seaborn/distributions.py:2619: FutureWarning: `distplot` is a deprecated function and will be removed in a future version. Please adapt your code to use either `displot` (a figure-level function with similar flexibility) or `histplot` (an axes-level function for histograms).\n",
            "  warnings.warn(msg, FutureWarning)\n"
          ]
        },
        {
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7fe2fcd69e50>"
            ]
          },
          "execution_count": 9,
          "metadata": {},
          "output_type": "execute_result"
        },
        {
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEJCAYAAACOr7BbAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3dd3xc9Znv8c8zGvXeJatYknvDBss2psSUkBhIcAidJJCEDeEG9iabu4VsNizLJhvY3BtSIIUEskAgeMMCccCEpZhqMLZxL7IlV8nqXZbVn/vHjLOKGGzZ0tGZ8rxfr3lp5pwzM8+xR/rOOb9yRFUxxhhjRvK4XYAxxpjgZAFhjDEmIAsIY4wxAVlAGGOMCcgCwhhjTEAWEMYYYwJyNCBEZLmIVIhIpYjcGWB9rIis9K9fJyIl/uUlInJMRDb7b79wsk5jjDEf5nXqhUUkCngQuASoBtaLyCpV3Tlss1uAVlWdKiLXA/cB1/nXVanqAqfqM8YYc2KOBQSwGKhU1X0AIvIUsAIYHhArgLv9958GHhAROZ03y8rK0pKSktMu1hhjItHGjRubVDU70DonA6IAODzscTWw5KO2UdUBEWkHMv3rSkVkE9AB/JOqvnWiNyspKWHDhg3jUrgxxkQKETn4UeucDIixqAWKVbVZRBYCz4nIHFXtGL6RiNwK3ApQXFzsQpnGGBO+nGykrgGKhj0u9C8LuI2IeIFUoFlVe1W1GUBVNwJVwPSRb6CqD6lquaqWZ2cHPEIyxhhzmpwMiPXANBEpFZEY4Hpg1YhtVgE3++9fDbymqioi2f5GbkSkDJgG7HOwVmOMMSM4dorJ36ZwB/ASEAU8oqo7ROQeYIOqrgIeBh4XkUqgBV+IAHwMuEdE+oEh4DZVbXGqVmOMMR8m4TLdd3l5uVojtTHGnBoR2aiq5YHW2UhqY4wxAVlAGGOMCcgCwhhjTEAWEMYYYwIK1oFyJkI9ue7QaT/3xiU2WNKY8WRHEMYYYwKygDDGGBOQBYQxxpiALCCMMcYEZAFhjDEmIAsIY4wxAVlAGGOMCcgCwhhjTEAWEMYYYwKygDDGGBOQBYQxxpiALCCMMcYEZJP1mYhT236MHTUddPUOkBLvZX5hGplJsW6XZUzQsYAwEePVXfX84o0q1h9o/dC6hZPT+cr5ZXxyTi4i4kJ1xgQfCwgT9jp7+vnOc9t5bvMRijLi+YflM1lcmkF6QjTNR/tYt6+ZlRsOc9tvN7KkNIPvf3YeZdlJbpdtjOssIExYaz3ax02PvM/O2g6+8fFp3H7hVKKj/qfprSwbFpVkcNuyKfx+YzXfX72LT/30bX5w9XwuPyPfxcqNcZ8FhAkbIy821Ns/yC/f3EdTVy+fW1JMTnIcv99Q/ZHPv3FJMRfOyOFrT2zk9ic/4FDLTP7XBVOcLtuYoGW9mExYGlLl9xurqe/o4fNnT2ZmXsqonpeXGsdTty7livmTuO9Pu/nRK3tQVYerNSY42RGECUtrK5vYWdvBZfPymZ6bfErPjfF6uP+6BcR4Pfzolb30DQzxd5+cYY3XJuJYQJiw09zVy8u76pmZl8y5UzJP6zWiPMK/X3UG0VEefvZ6FSLwd5+cOc6VGhPcLCBMWFFVnt1Ug0eEFQsKxvSt3+MR/u3KuQA8uKaK5LhobltmbRImclhAmLCyu66TfU1HuWL+JFLjo8f8eiLCdz8zl67eAe59cTcpcdHcuKR4HCo1JvhZQJiwMaTKSzvqyEyMYVFJxri9bpRH+OG18+nq6efbz20jOc7Lp+dPGrfXNyZYWUCYsLH5cBsNnb3csLiYKM+pn1oa2U12pGXTc9jf1M3Xn9rEhgMtzBjWM8qOKkw4sm6uJiyoKm/uaSQvJY65k0bXpfVUxXg93LR0Mvmp8Tyx7hD7m4468j7GBAsLCBMW9jZ00dDZy3lTsxztjhoXHcUXzykhPTGGx949QE3rMcfeyxi3WUCYsPD23iaS47ycUZTq+Hslxnr58rmlJMRE8Zu1+6nv6HH8PY1xgwWECXmNnb1UNnaxtCwTr2diPtKp8dF8+dxSokT4zTv72VPfOSHva8xEsoAwIW/jwRY84puyeyJlJsXypfNKUYWrf76WdfuaJ/T9jXGaowEhIstFpEJEKkXkzgDrY0VkpX/9OhEpGbG+WES6RORvnazThK7BIeWDQ23MyE0mOW7s4x5OVV5KHLctm0JWciyf+/U6/uOd/TZ3kwkbjnVzFZEo4EHgEqAaWC8iq1R157DNbgFaVXWqiFwP3AdcN2z9D4EXnarRhL499Z109Q5QPo7jHk5VemIMz91+Lt9cuZm7/7iTt/Y28f3PziMnJW5Uzz9Z99qTsS62xilOHkEsBipVdZ+q9gFPAStGbLMCeNR//2ngYvF3QRGRzwD7gR0O1mhC3KbDbSTGek95Qr7xlhIXzUNfKOeuT83m7comLvp/b/CLN6ro7htwtS5jxsLJgCgADg97XO1fFnAbVR0A2oFMEUkC/gH4FwfrMyGub2CIiroO5k5KOa2BcePN4xG+fF4pf/rGx1hSmsG9L+7mnHtf4//9dwWNnb1ul2fMKQvWkdR3A/erateJ+rSLyK3ArQDFxXaYHWl213XQP6jMK3S+a+upKM1K5OEvLmLjwRZ++cY+HlhTyS/f2Mel8/K4YXExS0ozbOpwExKcDIgaoGjY40L/skDbVIuIF0gFmoElwNUi8u9AGjAkIj2q+sDwJ6vqQ8BDAOXl5dYyGGG217STHOulJDPR7VICWjg5g4duyqCqsYtH1x7g2Q9q+MPmI5RlJ3LDomKuWlhIRmKM22Ua85GcDIj1wDQRKcUXBNcDN47YZhVwM/AucDXwmvq6gJx/fAMRuRvoGhkOJrL1DQxRUd/JwsnpeIL82/iU7CTuWTGXb106ixe21fK79w/xvdW7+MFLFXxybh4lmQnkp8a7XaYxH+JYQKjqgIjcAbwERAGPqOoOEbkH2KCqq4CHgcdFpBJowRcixpxUVWMX/YPK7PzgOr10IvExUVy9sJCrFxZSUdfJ794/xH99UE1XzwBnFqdz2dw8EmKD9ayviUSOfhpVdTWwesSyu4bd7wGuOclr3O1IcSak7a7rJNbroSQrwe1STsuMvGTuvmIOf/Px6dzxuw94p7KJivpOrllY6HqPLGOOs5HUJuSoKhV1HUzNSZqwqTWckpoQzaVz87n9wqkkx3p5dO0B1lQ02GA7ExRC+7fLRKTa9h46egaYmRc+37TzU+O5bdkUzihM5eWd9fxx6xGGLCSMy+yEpwk5u+t8E+OF26mYGK+Ha8uLSImL5q3KJgaH4DMLJlmXWOMaCwgTciobOpmUFufK3EtOExGWz83D4xHe2NNIYkwUn5iT53ZZJkLZKSYTUnoHBjnccoyp2eF19DCciPCJ2bksKknn9T2NfHCo1e2STISygDAh5UBTN4OqTMkJzsFx40VEuGJ+AWVZiTy3qYbq1m63SzIRyALChJSqxi68Hgna0dPjKcoj3LC4mKRYL0+tP0zvwKDbJZkIYwFhQkpVYxfFGQlER0XGRzcx1ss15UW0Hu3jha21bpdjIkxk/JaZsNDVO0Btew9Tc5LcLmVClWYlcv60bDYcbGVXbYfb5ZgIYgFhQsaBpqOA7w9mpPn47BzyU+N45oNqOnv63S7HRAgLCBMyDjYfxesRCtIjb2I7r8c3RqJ3YIhVW464XY6JEBYQJmQcaO6mKCMh5KfXOF25KXFcNDOHHUc6qKizU03GeTZQzoSE3v5BjrQd44IZ2W6XEtBYrys9WudNy2LToTZWbTnC17OSiPFGZliaiWGfLhMSDrV0oxAR3VtPxOvxcMWCSbR29/P6nga3yzFhzgLChIQDzUcRoDgjNKf3Hk9TspNYUJTGW3uaaOjocbscE8YsIExIONjSTX5qHLHRUW6XEhQunZtHtFdYtfWITQ1uHGNtECboDalS3XqMs4rT3C4laCTHRXPJrFz+uLWWbz+7nbkFp3dlvRuXFI9zZSac2BGECXoNHb30DQxRlG6nl4ZbXJpJXkocq7fV0jcw5HY5JgxZQJigd7jFN1FdkbU//IUoj/CpM/JpO9bPW3sb3S7HhCELCBP0DrV2Ex8dRWZijNulBJ2y7CTmFaTyxp5GWrv73C7HhBkLCBP0Drd0U5yRYFdW+wiXzs1DBF7cZpP5mfFlAWGCWk//II2dvRRlRN70GqOVlhDDsuk5bD/SQWVDl9vlmDBiAWGCWk3bMRQotAbqEzp/WhbpCdE8v/UIg0PW7dWMDwsIE9RqWo8BUJBmRxAnEh3l4fJ5+TR09rJuf7Pb5ZgwYQFhgtqR9mOkxUeTGGtDdk5mVn4KU3OSeGVXPV29A26XY8KABYQJajWtx5hkRw+jIiJ8al4+fQND/PeOOrfLMWHAAsIErZ7+QZqP9llAnIKclDjOmZLFxoOtVLd2u12OCXEWECZo1bb7JqIrSItzuZLQctHMHBJjvTy/tZYhm6fJjIEFhAlaNW2+Bmo7gjg1cdFRfHJOHodautlyuM3tckwIs4AwQetI2zFS4rwkx0W7XUrIObM4jcL0eP60vY6e/kG3yzEhygLCBK0jbdZAfbo8Inz6jEl09g6wpsIuLGROjwWECUp9A0M0dvZaQIxBUUYCC4vTWVvZTGNnr9vlmBBkAWGCUm27bwS1DZAbm0/MycUbJbywzS4sZE6dBYQJStZAPT6S46K5eFYue+q72F3X6XY5JsRYQJigdKSth8RYLylxNoJ6rJaWZZKdHMsL22rpH7QLC5nRczQgRGS5iFSISKWI3BlgfayIrPSvXyciJf7li0Vks/+2RUSudLJOE3yOtB2jIC3OpvgeB8cvLNRytI93KpvcLseEEMcCQkSigAeBS4HZwA0iMnvEZrcArao6FbgfuM+/fDtQrqoLgOXAL0XEvkpGiP7BIRo6e+z00jialpPM7PwU1lQ00H6s3+1yTIhw8ghiMVCpqvtUtQ94ClgxYpsVwKP++08DF4uIqGq3qh6fbSwOsNa1CFLX3sOQwqRUC4jxdNm8fFThT9vtwkJmdJwMiALg8LDH1f5lAbfxB0I7kAkgIktEZAewDbhtWGD8mYjcKiIbRGRDY6Ndkzdc1HX4ptjIT7UpNsZTRmIM50/LZkt1O/ubjrpdjgkBQdtIrarrVHUOsAj4loh86K+Fqj6kquWqWp6dnT3xRRpH1HX0EBPlId2uQT3ulk3PJi0+mj9usQsLmZNzMiBqgKJhjwv9ywJu429jSAX+4monqroL6ALmOlapCSr17T3kpMTisQbqcRfj9XD5GfnUdfTw3j67sJA5MScDYj0wTURKRSQGuB5YNWKbVcDN/vtXA6+pqvqf4wUQkcnATOCAg7WaIKGq1HX0kJdip5ecMjs/hWn+Cws1dPa4XY4JYo4FhL/N4A7gJWAX8J+qukNE7hGRK/ybPQxkikgl8E3geFfY84AtIrIZeBb4mqpa/7wI0NU7QHffILkWEI4RET49fxIDQ8q9q3e7XY4JYqPqOioiz+D7Y/6iqo56pI2qrgZWj1h217D7PcA1AZ73OPD4aN/HhI/jDdR51kDtqKykWM6flsUzm2q4blERS8oy3S7JBKHRHkH8DLgR2Csi94rIDAdrMhGs3n+RIDuCcN4F03MoSIvnn1ftYMBGWJsARhUQqvqKqn4OOAtfW8ArIrJWRL4kIjZZvxk3dR29JMV6SYq1cZFOi/F6+M6nZrO7rpPH3j3odjkmCI26DUJEMoEvAn8FbAJ+jC8wXnakMhOR6q2BekJ9ck4uy6Znc//Le2josAZr85dGFRAi8izwFpAAfFpVr1DVlar610CSkwWayDE4pNR39JCbEut2KRFDRLj7ijn0Dgzx/Retwdr8pdEeQfxKVWer6vdVtRZ8E+0BqGq5Y9WZiHKw+SgDQ2oN1BOsNCuRry4r49lNNayzsRFmmNEGxHcDLHt3PAsxpsJ/vQJroJ54X7tgKgVp8dzz/E6GbIS18TthQIhInogsBOJF5EwROct/uwDf6SZjxs3uuk4EyEm2gJho8TFR/P3yGew40sEzm0ZOeGAi1cm6inwSX8N0IfDDYcs7gX90qCYToSrqOslIjCHGG7RThIW1T58xiUfeOcAPXtrNZfPySIixnmSR7oS/iar6qKpeCHxRVS8cdrtCVZ+ZoBpNhKio77T2Bxd5PMJ3Lp9FfUcvv3pzv9vlmCBwwq8IIvJ5Vf0tUCIi3xy5XlV/GOBpxpyyY32DHGg+yoUzctwuJaKVl2Rw6dw8fvFGFdcvLrL2oAh3smP5RP/PJCA5wM2YcbG3oRNVa6AOBndeOpOBoSHuf3mP26UYl53wCEJVf+n/+S8TU46JVMd7MNkgOfdNzkzkc0sm8/h7B7n1Y2WUZdtQp0g12oFy/y4iKSISLSKvikijiHze6eJM5Kio6yTW6yEzyS4SFAxuv3AqsV4P97+y1+1SjItG203hE6r69yJyJb65mD4LvAn81qnCTGSpqO9kWm6SXSRogj257tBHrltcmsEftxxhckYCk9I+fH3wG5cUO1maCQKj7U94PEguB36vqu0O1WMi1O66Tmbkprhdhhnm/KnZxEV7eHlnvdulGJeMNiCeF5HdwELgVRHJBmxmLzMuWo720djZy8w86/cQTOJjolg2LZuK+k4ONh91uxzjgtFO930ncA5Qrqr9wFFghZOFmcixu64DgBkWEEFn6ZQskmO9dhQRoU5lqORMfOMhhj/nsXGux0Sg4z2YZuYlU916zOVqzHAxXg8fm57NC9tqOdB0lJKsxJM/yYSN0fZiehz4v/iuFb3If7NZXM24qKjrJD0hmuxkm+Y7GC0qySAx1strFQ1ul2Im2GiPIMqB2apq0zyacbe7rpMZecmI9WAKSjFeDx+blsWL2+s41HyU4kw7iogUo22k3g7kOVmIiUxDQ8qe+k5m5lkPpmC2uDSDhJgoO4qIMKM9gsgCdorI+0Dv8YWqeoUjVZmIUd16jO6+QWugDnKx3ijOn5rFSzvrqW7tpjDdZvuPBKMNiLudLMJELuvBFDrOLsvkzb1NrNndwBeWlrhdjpkAo+3m+ga+EdTR/vvrgQ8crMtEiOM9mKbnWkAEu9joKJZOyWRXXScNHTYMKhKMthfTV4CngV/6FxUAzzlVlIkcu+s7KcqIJynWLk4TCs4uy8TrEd6ubHK7FDMBRttIfTtwLtABoKp7AZu434xZhU2xEVKSYr0snJzOpsNt1NtRRNgbbUD0qmrf8Qf+wXLW5dWMSe/AIPubjtoUGyHmvKlZDA0pv3nngNulGIeNNiDeEJF/BOJF5BLg98AfnSvLRILKhi4Gh9QaqENMZlIscwtSeeK9g3T29LtdjnHQaAPiTqAR2AZ8FVgN/JNTRZnIsKf+f6bYMKHl/GlZdPYO8NT7h90uxThoVC2DqjokIs8Bz6lqo8M1mQixu66TmCiPze8TggrTE1halsnDb+/n5nNKiPGO9rumCSUn/F8Vn7tFpAmoACr8V5O7a2LKM+Gsoq6TKTlJREfZH5dQ9NVlZdR19LBqyxG3SzEOOdlv5t/g6720SFUzVDUDWAKcKyJ/43h1JqxV1HXa6aUQtmx6NjPzknnozSpsmrbwdLKA+AJwg6ruP75AVfcBnwducrIwE97au/upbe+xAXIhTET46rIy9tR38XqFnXkORycLiGhV/dCIGH87RLQzJZlIUGEN1GHhU2dMIjcllkfe2X/yjU3IOVlA9J3mOgBEZLmIVIhIpYjcGWB9rIis9K9fJyIl/uWXiMhGEdnm/3nRyd7LhJYKm4MpLERHefjC2ZN5a28TlQ2dbpdjxtnJAmK+iHQEuHUC8070RBGJAh4ELgVmAzeIyOwRm90CtKrqVOB+4D7/8ibg06o6D7gZePzUdssEu911nSTHeclPjXO7FDNGNywuJsbrsYFzYeiEAaGqUaqaEuCWrKonO8W0GKhU1X3+UdhP8eHrWK8AHvXffxq4WEREVTep6vGuETvwDdCzy42FkeMN1HaRoNCXmRTLZxZM4pkPamjvtoFz4cTJ/oUFwPBRNNX+ZQG3UdUBoB3IHLHNVcAHqto7YjkicquIbBCRDY2N1kgWKlSVivpOO70URr50binH+gd5av0ht0sx4yioO6CLyBx8p52+Gmi9qj6kquWqWp6dnT2xxZnTVtN2jM6eAWbl2yR94WJWfgpnl2Xw6NoDDAwOuV2OGSdOBkQNUDTscaF/WcBt/BMApgLN/seFwLPATapa5WCdZoLtrj3eg8kCIpx86dxSjrT38N87690uxYwTJwNiPTBNREpFJAa4Hlg1YptV+BqhAa4GXlNVFZE04AXgTlV9x8EajQt21VoPpnD08Vm5FGXE8xvr8ho2HAsIf5vCHcBLwC7gP1V1h4jcIyLHr2X9MJApIpXAN/FNCoj/eVOBu0Rks/9m158IE7vrOinOSLCLBIWZKI9w89IS1h9oZXtNu9vlmHHgaBuEqq5W1emqOkVVv+dfdpeqrvLf71HVa1R1qqou9o/SRlW/q6qJqrpg2K3ByVrNxNlV12ED5MLUtYuKSIyJsoFzYSKoG6lN+DnWN8iBpqPWQB2mUuKiuXphIc9vqaWp60MdD02IsWN8M6H2NnQypDAr344gQt2T6wJ3aU1PiKFvcIhvP7ONZTM++szwjUuKnSrNjBM7gjAT6ngDtfVgCl85KXGUZSWy7kALQzbLa0izgDATaldtJ/HRURRnJLhdinHQ2WWZtHX3U1Fn8zOFMgsIM6F213UwIy8Zj8em2Ahns/JTSInz8t6+ZrdLMWNgAWEmjKqyu67T2h8iQJRHWFSawd6GLmusDmEWEGbC1Hf00tbdbz2YIsSikgw8Au/vb3G7FHOaLCDMhLEG6siSEhfNnEmpbDjYQt+Azc8UiiwgzITZZRcJijhnl2XS0z/E1uo2t0sxp8ECwkyY3bWdFKTFkxpvV6uNFCWZCeSmxPLevmbUuryGHAsIM2F22xQbEUdEWFKayZH2Hg63HnO7HHOKLCDMhOjpH6Sq8SgzrQdTxDmzKI1Yr8e6vIYgCwgzIXbVdjA4pMwrSHW7FDPBYqOjOLM4nW017XT1DrhdjjkFFhBmQmw/4mugnmsBEZGWlGYwOKRsPGBdXkOJBYSZENur20lLiKYgLd7tUowLcm1+ppBkAWEmxLaaduYVpCJiU2xEqiU2P1PIsYAwjusdGGRPfaedXopws21+ppBjAWEcV1HXyYA1UEe84fMzNdv8TCHBAsI4bpv/+sRzJ1lARLrj8zPZUURosIAwjtte005qfDRFGdZAHemOz8+08VArx/oG3S7HnIQFhHHc9poO5hakWAO1Af5nfqY/bK5xuxRzEhYQxlF9A0NU1FkDtfkfJZkJ5KXE8ei7B21+piBnAWEctae+k77BIWt/MH8mIiwty2RXbQcbDra6XY45AQsI46jt/gZq68FkhptflEZKnJfH3j3odinmBCwgjKO21bSTHOdlcmaC26WYIBLj9XBNeREvbquloaPH7XLMR7CAMI7aXtPO3Ek2gtp82BfOnszAkPLk+4fcLsV8BAsI45j+wSF21XUyt8AuMWo+rCQrkQtmZPPkukP0D9olSYORBYRxzK7aDvoGhphflOZ2KSZI3bR0Mg2dvby0o87tUkwAFhDGMZsO+a5DfGZxusuVmGC1bHoOxRkJ1lgdpCwgjGM2HWolNyWWSalxbpdiglSUR/jC2ZN5f38LO460u12OGcECwjhm0+E2zixKtwZqc0LXLioiISaKR94+4HYpZgQLCOOIpq5eDjZ3c2axtT+YE0uNj+ba8iJWbamxLq9BxgLCOGKztT+YU/Clc0sYGFJriwgyFhDGER8caiXKIzaC2ozK5MxELpmVyxPrDtosr0HE0YAQkeUiUiEilSJyZ4D1sSKy0r9+nYiU+JdnisgaEekSkQecrNE4Y8OBVuZOSiE+JsrtUkyI+Kvzy2jt7ueZTdVul2L8HAsIEYkCHgQuBWYDN4jI7BGb3QK0qupU4H7gPv/yHuA7wN86VZ9xTu/AIJur21hUkuF2KSaELCpJ54zCVB55ez9DQzbLazBw8ghiMVCpqvtUtQ94ClgxYpsVwKP++08DF4uIqOpRVX0bX1CYELO1up2+gSEWlVpAmNETEW45r5SqxqO8urvB7XIMzgZEAXB42ONq/7KA26jqANAOZDpYk5kA7+9vAbAjCHPKLp+XT3FGAg+sqbRrRQSBkG6kFpFbRWSDiGxobGx0uxzjt/5AC9NykshIjHG7FBNivFEebls2hS2H23i7ssntciKe18HXrgGKhj0u9C8LtE21iHiBVGDUVzNX1YeAhwDKy8vt60YQGBxS3q1qZn5hGk+us1k6zam7amEBP3l1Lw+8Vsn507LdLieiOXkEsR6YJiKlIhIDXA+sGrHNKuBm//2rgdfUjitD2s4jHfQODFGSleh2KSZExXqj+MrHyli3v4UNB1rcLieiORYQ/jaFO4CXgF3Af6rqDhG5R0Su8G/2MJApIpXAN4E/d4UVkQPAD4Evikh1gB5QJggdPy0wJdsCwpy+GxYXkZEYwwNrKt0uJaI5eYoJVV0NrB6x7K5h93uAaz7iuSVO1macsbaqiZzkWJLjot0uxYSwhBgvt5xXyg9eqmDL4TabMt4lId1IbYJLT/8g6w+0MDUnye1STBi4aelkMhJjuPfF3dajySUWEGbcfHColZ7+IaZkW0CYsUuOi+Z/XzSVd/c18/oe66XoBgsIM27WVjYT5RFKrYHajJMbl0xmcmYC9724m0EbXT3hHG2DMJHl9T0NnFmURly0zb9kTm603aCXlmXy1PrD/MPTWzlrsm924BuXFDtZmvGzIwgzLho6ethe08GFM3PcLsWEmbkFqRSkxfPyrnr6B4fcLieiWECYcbGmwjd3zoUzLCDM+PKIsHxuHu3H+nlzr7VFTCQLCDMu1uxuJD81jln5yW6XYsLQlOwk5hWk8kZFI81dvW6XEzEsIMyY9Q0M8XZlExfMyLHrTxvHXDYvH49HWLXliHV7nSAWEGbM3t3XTFfvABdb+4NxUGp8NJ+Yncvehi5+v9EuKjQRLCDMmK3eWktSrJfzpmW5XYoJc2eXZVKSmedGCgoAAA+tSURBVMi//nEnR9qOuV1O2LNurkFsLLOhTlQ3wP7BIV7aWcfFs3Kse6txnEeEq84q4OdvVPGNpzbz5FeW4I2y77lOsX9ZMybr9rXQ1t3PZfPy3S7FRIjMpFi+d+Vc3j/Qwo9f3et2OWHNAsKMyQvbakmMiWLZdJu330ycK88s5JqFhfz0tUr+tL3O7XLClgWEOW09/YM8v/UIl8zOtdNLZsL962fmMr8ojb9ZuZntNe1ulxOWLCDMaXt5Zz2dPQNcU1508o2NGWdx0VH86gsLSU+I5ou/eZ/9TUfdLinsWECY0/b0xmompcaxtCzT7VJMhMpJieOxW5YwpPD5X6/jgIXEuLKAMKelrr2Ht/Y2ctXCQjweGxxn3DM1J4nHvryY7r4Brv3lu+yq7XC7pLBhAWFOy2/fO4gC1yy000vGfXMLUln51aWIwFU/X8sLW2vdLiksWECYU9bTP8iT7x/i4pm5FGcmuF2OMQBMz01m1R3nMTMvmduf/IB77RoSY2YBYU7Zqi1HaDnax5fPLXG7FGP+Qm5KHE/dupTPLSnmF29Uce0v32VvfafbZYUsCwhzSgaHlF+9uY8ZucksnWKN0yb4xHg9fO/KefzougVUNXZx2U/e4v6X99A7MOh2aSHHptowp+SFbbXsbejipzecaTO3GteMdhqar10wlee3HuHHr+7l8fcOcsmsXL7/2XnWsWKU7AjCjNrgkPLjV/YwPTeJy21qDRMCkmK9XL+omC+eU0JMlIeVGw7z6Qfe5s09jTZl+CjYEUQQGRxSdtd1sK/xKE1dvWw82EpirJespFjyUuKIcvlbz9MbD1PVeJQHbzzLvoGZkDI9N5mpOUlsOdzG2qpmbnrkfc6dmsk3L5nBQv91rs2HWUC4TFV5t6qZpzdW88quejp6BgJuF+v1MCMvmYXF6UzNSZrw0ztt3X3c96cKyienc9m8vAl9b2PGg0eEM4vTmVeQyrr9Lbxe0cBVP1/LtJwkPj4rl6KMk/fIm6hZkoOFBYRLVJW3K5v44ct72HSojeQ4L8vn5HHu1Cxm5ieTkxzHf22sprN3gPqOHqoauthxpIOt1e1MSovj4pm5zMxLnrCg+MFLFbR193HPiiXW9mBCmjfKw7lTsygvSWfdvhbe3NvIz9+oYkZuMhfPyqEw3bpuH2cB4YJdtR388x928P6BFialxvG9K+dy1VmFH5rwLjHWS2Ksl7yUOOYXpnHF/CG2VLexpqKRx987yKS0OC6bm09ZdpKj9a6paOCJdYf48rmlzJ6U4uh7GTNRYr1RfGx6NktKM3h3XzNv7W3iZ69XMTMvmYtn5lKQHu92ia6zgJhAPf2D/OTVvTz05j5S46P51xVzuHZREbHe0c2E6o3ysHByBguK0tl8uI1Xd9Xz67f3M3dSCpfOyyc9IWbca27o7OHvfr+FGbnJ/P3yGeP++sa4LTY6igtm5HB2WSbv7mvm7b1NPPh6JbPykrl4Vi6T0iI3KCwgJsjaqib+8ZltHGju5uqFhXz7slmkJ57eH/Qoj7BwcjpnFKby1t5G3tjTyO66Ts6fls2y6dnEeMenc9rR3gFu+Y8NHO0d5Im/OtOm9DZhLS46igtn5LC0LJO1VU28XdnEA2sqmZ2fwsWzcshPjbygsIBwWHt3P/+2ehcrNxymOCOB396yZNyu3Rwd5eGimbmcVZzOn3bUsaaigQ8OtbJ8bh43LC4aU1tBd98At/12IzuOtPOrm8qZkZc8LjUbE+zioqO4aGYuS8uyeKeqiXcqm9hZ28GcSSmcNTmNmXmRc5rVAsIhqsofNh/huy/sorW7j68uK+MbF08nPmb8v4WnJcRw/aJizi49yvNbj7By/WH2NXbxz5+ew9yC1FN+vaauXr7y2Aa2HG7j3qvO4OJZueNeszHBLj4mio/PyuXcKVm8XdnE2qomlv/oLS6fl8/XPz6N6bnh/6VJwmWwSHl5uW7YsMHtMgDYW9/Jd/6wnff2tXBGYSr/duW80/pDPdrRosMNqbLxYCtv7mmkpbuP68qLuP3CqaPqwqeq/Gl7Hf/03HY6ewf4yfVnsnzuqXdpPZ26jQl23X0DtHX385t39tPdP+gLiounMS3Eg0JENqpqeaB1dgQxjmrbj/HAa5WsXH+YxFgv3/3MXG5YXDyhA9w8IiwqyeDuK+bw01f38h9rD7Byw2GWTc/msnn5nDMlk4K0+L84/dRytI9XdtbzxLqDbKluZ3Z+Ck9et8BOKxkzTEKMl786v4wvn1fKr97ax6NrD/D81lrOn5bFzUtLuHBmjuuDWcebHUGMg8Mt3Tzyzn6eWHcIVeXa8iK+ecl0MpNix/S6Y/kmfnxAz5G2Yzy57hDPbqqhpu0YAGkJ0eQmxyECrd191Hf0AjA5M4GvXTCFz55VSHTU6Td02xGECVfDB8o1d/Xy5LpDPLHuEHUdPRSkxbNiwSRWLCgIqS9XJzqCcDQgRGQ58GMgCvi1qt47Yn0s8BiwEGgGrlPVA/513wJuAQaB/62qL53ovSY6IHoHBlmzu5HfvX+IN/c24hHhqrMK+OuLpo3qdM5ojEdAHKeq7KztYMOBVvbUd9LQ6QuFlLhopuUmcc6UTOYVpP75yML+yBvzYYFGUvcPDvHKznqeWn+YtyubGBxSZuQmc9GsHC6Yns1Zk9PH9IXLaa6cYhKRKOBB4BKgGlgvIqtUdeewzW4BWlV1qohcD9wHXCcis4HrgTnAJOAVEZmuqq7N19s/OMTe+i42Hmzh9YpG1lY1c6x/kLyUOP76omlcW14Y1CMwRYQ5k1KZM+nU20KMMR8tOsrDpfPyuXRePk1dvbywtZbV22r51Zv7+PnrVSTFeplflMqCojTmF6YxPTeZooyEkDgd5WQbxGKgUlX3AYjIU8AKYHhArADu9t9/GnhAfF9hVwBPqWovsF9EKv2v9+54FzkwOETz0T46jvXT0TNAZ08/nT0DNHf1UtveQ03bMfY3HWVvfRd9g0MAFGckcE15IRfNzOG8qVl4g/jbgTFm4mQlxXLzOSXcfE4JHT39rK1s5p3KJjYdbuUXb+z78xXuYrweSjITyEuNJyc5ltyUWHKS48hIjCExNor4aC+JsVEkxHhJiIkiPjoKj0fweoSo4zcRxyfNdDIgCoDDwx5XA0s+ahtVHRCRdiDTv/y9Ec8tcKLIrTXtfPZnawOui/F6mJQaR1FGAl86r4Q5k1I5oyCVyZkJNh+RMeaEUuKiWT437889AY/1DbKztoOqhi6qGruoajxKQ2cPe+o6aezqPa3Lo4pAlAifOiOfH11/5njvQmj3YhKRW4Fb/Q+7RKRi2OosoGms77F3rC8wNqe9D58b50LGYFz+H1wWDvsA4bEfru7DOP1ejfs+/Bj48Q2n/fTJH7XCyYCoAYqGPS70Lwu0TbWIeIFUfI3Vo3kuqvoQ8FCgNxeRDR/V8BIqbB+CQzjsA4THftg+TCwnT56vB6aJSKmIxOBrdF41YptVwM3++1cDr6mvW9Uq4HoRiRWRUmAa8L6DtRpjjBnBsSMIf5vCHcBL+Lq5PqKqO0TkHmCDqq4CHgYe9zdCt+ALEfzb/Se+Bu0B4HY3ezAZY0wkcrQNQlVXA6tHLLtr2P0e4JqPeO73gO+N4e0DnnoKMbYPwSEc9gHCYz9sHyZQ2IykNsYYM76sA78xxpiAwiogROQaEdkhIkMiUj5i3bdEpFJEKkTkk27VOBoistxfZ6WI3Ol2PaMlIo+ISIOIbB+2LENEXhaRvf6f6W7WeDIiUiQia0Rkp/+z9HX/8pDZDxGJE5H3RWSLfx/+xb+8VETW+T9XK/2dR4KaiESJyCYRed7/OBT34YCIbBORzSKywb8sJD5PYRUQwHbgs8CbwxeOmLpjOfAz/1QgQWfYFCWXArOBG/z1h4L/wPfvO9ydwKuqOg141f84mA0A/0dVZwNnA7f7//1DaT96gYtUdT6wAFguImfjm8rmflWdCrTim+om2H0d2DXscSjuA8CFqrpgWPfWkPg8hVVAqOouVa0IsOrPU3eo6n7g+NQdwejPU5Soah9wfIqSoKeqb+LrjTbcCuBR//1Hgc9MaFGnSFVrVfUD//1OfH+cCgih/VCfLv/DaP9NgYvwTWkDQb4PACJSCFwO/Nr/WAixfTiBkPg8hVVAnECgaT8cmbpjHIRSraORq6q1/vt1QMhcnk5ESoAzgXWE2H74T81sBhqAl4EqoE1VB/ybhMLn6kfA3wND/seZhN4+gC+c/1tENvpnf4AQ+TyF3FQbIvIKEOgyZ99W1T9MdD1m9FRVRSQkus2JSBLwX8A3VLVj+NxbobAf/nFDC0QkDXgWmOlySadERD4FNKjqRhG5wO16xug8Va0RkRzgZRHZPXxlMH+eQi4gVPXjp/G0UU3dESRCqdbRqBeRfFWtFZF8fN9og5qIROMLhydU9Rn/4pDbDwBVbRORNcBSIE1EvP5v4MH+uToXuEJELgPigBR8Uw6F0j4AoKo1/p8NIvIsvtPIIfF5ipRTTKE0dcdopigJJcOnU7kZCOqjPP957oeBXar6w2GrQmY/RCTbf+SAiMTjuybLLmANviltIMj3QVW/paqFqlqC73fgNVX9HCG0DwAikigiycfvA5/A15kmND5Pqho2N+BKfOcle4F64KVh676N7zxsBXCp27WeZD8uA/b46/222/WcQt2/A2qBfv//wy34zhu/im9i3FeADLfrPMk+nIfvnPFWYLP/dlko7QdwBrDJvw/bgbv8y8vwfTGqBH4PxLpd6yj35wLg+VDcB3+9W/y3Hcd/n0Pl82QjqY0xxgQUKaeYjDHGnCILCGOMMQFZQBhjjAnIAsIYY0xAFhDGGGMCsoAwZgxEREXkt8Mee0Wkcdjso1/0P97snyH2K8O2Xe6fdXW3f/1KESl2Yz+MCSTkRlIbE2SOAnNFJF5Vj+EblDZydO9KVb3DP9XCDhFZBWQDPwWuUNVdACJyBVACHJqw6o05ATuCMGbsVuObdRTgBnwDBj9EVRvwDX6cDPwD8G/Hw8G/fpX6ZsQ1JihYQBgzdk/hm8olDt8o5nWBNhKRMnwjayvxXZvkgwmr0JjTYAFhzBip6lZ8p4ZuwHc0MdJ1/qm3fwd8VVX/4poZIpLpb4PYIyJ/63jBxoyStUEYMz5WAf8X37xBmSPWrVTVO0Ys2wGcBWxR1WZ8U3P/LZDkdKHGjJYFhDHj4xF8F7PZNsrrF/w78KyIvDesHSLBseqMOQ0WEMaMA1WtBn5yCttvE5GvA4+JSArQhK/30j87VKIxp8xmczXGGBOQNVIbY4wJyALCGGNMQBYQxhhjArKAMMYYE5AFhDHGmIAsIIwxxgRkAWGMMSYgCwhjjDEB/X+ITs9JSVzpogAAAABJRU5ErkJggg==",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "needs_background": "light"
          },
          "output_type": "display_data"
        }
      ],
      "source": [
        "sns.distplot(df_cars[\"MPG\"])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "KoX1dc8pdc54"
      },
      "source": [
        "If we observe the graph above, we can consider it in a way or another normally distributed. Therefore, we can impute the missing values using the mean."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0MHFU3zXdqog"
      },
      "source": [
        "To compute the mean we need numeric values. However the values in the dataframe are objects. Therefore, we need to change them to numerics so that we can compute them."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 10,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CmDqc9I4dtMX",
        "outputId": "00d25d0a-fe0f-47ed-812f-8c6f61428844"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "Car             object\n",
              "MPG             object\n",
              "Cylinders       object\n",
              "Displacement    object\n",
              "Horsepower      object\n",
              "Weight          object\n",
              "Acceleration    object\n",
              "Model           object\n",
              "Origin          object\n",
              "dtype: object"
            ]
          },
          "execution_count": 10,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "#convert the following column to float\n",
        "df_cars.dtypes"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "metadata": {
        "id": "Ouxf_lzDujWC"
      },
      "outputs": [],
      "source": [
        "df_cars[\"MPG\"] = df_cars[\"MPG\"].astype(float)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_2b5o9zddz9w"
      },
      "source": [
        "Now let's see what is the mean of the MPG column"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hx3_6jCxd2H5",
        "outputId": "11ae0c41-10ab-4f3d-933f-3b3c058107c3"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "23.09627791563276"
            ]
          },
          "execution_count": 12,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "np.mean(df_cars['MPG'])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FP_Xc_Dcd5VZ"
      },
      "source": [
        "We can use this mean to compute the missing values since the graph demonstarted a normal distribution"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "metadata": {
        "id": "5vmaMricd3xw"
      },
      "outputs": [],
      "source": [
        "df_cars['MPG'].fillna((df_cars['MPG'].mean()), inplace=True) #inplace doesnt require me to aassign result to a new df"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 15,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 202
        },
        "id": "EdSfknd_d42J",
        "outputId": "9d7accd3-5851-4080-fa37-fd3c28198b40"
      },
      "outputs": [
        {
          "data": {
            "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>Car</th>\n",
              "      <th>MPG</th>\n",
              "      <th>Cylinders</th>\n",
              "      <th>Displacement</th>\n",
              "      <th>Horsepower</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>Model</th>\n",
              "      <th>Origin</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Buick Skylark 320</td>\n",
              "      <td>15.000000</td>\n",
              "      <td>8</td>\n",
              "      <td>350.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3693.</td>\n",
              "      <td>11.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Plymouth Satellite</td>\n",
              "      <td>23.096278</td>\n",
              "      <td>8</td>\n",
              "      <td>318.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>3436.</td>\n",
              "      <td>11.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>AMC Rebel SST</td>\n",
              "      <td>16.000000</td>\n",
              "      <td>8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>150.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Ford Torino</td>\n",
              "      <td>17.000000</td>\n",
              "      <td>8</td>\n",
              "      <td>302.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>3449.</td>\n",
              "      <td>10.5</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Ford Galaxie 500</td>\n",
              "      <td>23.096278</td>\n",
              "      <td>8</td>\n",
              "      <td>429.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4341.</td>\n",
              "      <td>10.0</td>\n",
              "      <td>70</td>\n",
              "      <td>US</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                  Car        MPG Cylinders  ... Acceleration Model Origin\n",
              "2   Buick Skylark 320  15.000000         8  ...         11.5    70     US\n",
              "3  Plymouth Satellite  23.096278         8  ...         11.0    70     US\n",
              "4       AMC Rebel SST  16.000000         8  ...         12.0    70     US\n",
              "5         Ford Torino  17.000000         8  ...         10.5    70     US\n",
              "6    Ford Galaxie 500  23.096278         8  ...         10.0    70     US\n",
              "\n",
              "[5 rows x 9 columns]"
            ]
          },
          "execution_count": 15,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_cars.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-K7RczSiR58O"
      },
      "source": [
        "# Data Cleaning Building Permits"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 17,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 457
        },
        "id": "rsZkTMxNXChm",
        "outputId": "5208cf3b-87e8-42ec-ffa0-3f71ebf14db6"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (22,32) have mixed types.Specify dtype option on import or set low_memory=False.\n",
            "  interactivity=interactivity, compiler=compiler, result=result)\n"
          ]
        },
        {
          "data": {
            "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>Permit Number</th>\n",
              "      <th>Permit Type</th>\n",
              "      <th>Permit Type Definition</th>\n",
              "      <th>Permit Creation Date</th>\n",
              "      <th>Block</th>\n",
              "      <th>Lot</th>\n",
              "      <th>Street Number</th>\n",
              "      <th>Street Number Suffix</th>\n",
              "      <th>Street Name</th>\n",
              "      <th>Street Suffix</th>\n",
              "      <th>Unit</th>\n",
              "      <th>Unit Suffix</th>\n",
              "      <th>Description</th>\n",
              "      <th>Current Status</th>\n",
              "      <th>Current Status Date</th>\n",
              "      <th>Filed Date</th>\n",
              "      <th>Issued Date</th>\n",
              "      <th>Completed Date</th>\n",
              "      <th>First Construction Document Date</th>\n",
              "      <th>Structural Notification</th>\n",
              "      <th>Number of Existing Stories</th>\n",
              "      <th>Number of Proposed Stories</th>\n",
              "      <th>Voluntary Soft-Story Retrofit</th>\n",
              "      <th>Fire Only Permit</th>\n",
              "      <th>Permit Expiration Date</th>\n",
              "      <th>Estimated Cost</th>\n",
              "      <th>Revised Cost</th>\n",
              "      <th>Existing Use</th>\n",
              "      <th>Existing Units</th>\n",
              "      <th>Proposed Use</th>\n",
              "      <th>Proposed Units</th>\n",
              "      <th>Plansets</th>\n",
              "      <th>TIDF Compliance</th>\n",
              "      <th>Existing Construction Type</th>\n",
              "      <th>Existing Construction Type Description</th>\n",
              "      <th>Proposed Construction Type</th>\n",
              "      <th>Proposed Construction Type Description</th>\n",
              "      <th>Site Permit</th>\n",
              "      <th>Supervisor District</th>\n",
              "      <th>Neighborhoods - Analysis Boundaries</th>\n",
              "      <th>Zipcode</th>\n",
              "      <th>Location</th>\n",
              "      <th>Record ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>201505065519</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>0326</td>\n",
              "      <td>023</td>\n",
              "      <td>140</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Ellis</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ground fl facade: to erect illuminated, electr...</td>\n",
              "      <td>expired</td>\n",
              "      <td>12/21/2017</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>11/09/2015</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11/09/2015</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11/03/2016</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>tourist hotel/motel</td>\n",
              "      <td>143.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.785719256680785, -122.40852313194863)</td>\n",
              "      <td>1380611233945</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>201604195146</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>0306</td>\n",
              "      <td>007</td>\n",
              "      <td>440</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Geary</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>remove (e) awning and associated signs.</td>\n",
              "      <td>issued</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/03/2017</td>\n",
              "      <td>1.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>tourist hotel/motel</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.78733980600732, -122.41063199757738)</td>\n",
              "      <td>1420164406718</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>201605278609</td>\n",
              "      <td>3</td>\n",
              "      <td>additions alterations or repairs</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>0595</td>\n",
              "      <td>203</td>\n",
              "      <td>1647</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>installation of separating wall</td>\n",
              "      <td>withdrawn</td>\n",
              "      <td>09/26/2017</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Russian Hill</td>\n",
              "      <td>94109.0</td>\n",
              "      <td>(37.7946573324287, -122.42232562979227)</td>\n",
              "      <td>1424856504716</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>201611072166</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>0156</td>\n",
              "      <td>011</td>\n",
              "      <td>1230</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>repair dryrot &amp; stucco at front of bldg.</td>\n",
              "      <td>complete</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>07/13/2018</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>1 family dwelling</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1 family dwelling</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Nob Hill</td>\n",
              "      <td>94109.0</td>\n",
              "      <td>(37.79595867909168, -122.41557405519474)</td>\n",
              "      <td>1443574295566</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>201611283529</td>\n",
              "      <td>6</td>\n",
              "      <td>demolitions</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>0342</td>\n",
              "      <td>001</td>\n",
              "      <td>950</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Market</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>demolish retail/office/commercial 3-story buil...</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/01/2017</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>12/01/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11/20/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/01/2018</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.78315261897309, -122.40950883997789)</td>\n",
              "      <td>144548169992</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Permit Number  ...      Record ID\n",
              "0  201505065519  ...  1380611233945\n",
              "1  201604195146  ...  1420164406718\n",
              "2  201605278609  ...  1424856504716\n",
              "3  201611072166  ...  1443574295566\n",
              "4  201611283529  ...   144548169992\n",
              "\n",
              "[5 rows x 43 columns]"
            ]
          },
          "execution_count": 17,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "#1\n",
        "building_permits_df = pd.read_csv(\"Building_Permits.csv\")\n",
        "\n",
        "building_permits_df.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 18,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sPVm-WJrBb0z",
        "outputId": "1d160482-0fb7-422d-9242-1a94040a5831"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "26.26002315058403\n"
          ]
        }
      ],
      "source": [
        "#2\n",
        "building_permit_cells = np.product(building_permits_df.shape) #get the number of cells of the dataframe\n",
        "building_permit_nulls = (building_permits_df.isnull().sum()).sum() # get the number of missing cells\n",
        "\n",
        "#calculate the percentage \n",
        "\n",
        "result = (building_permit_nulls / building_permit_cells)*100\n",
        "print(result)\n",
        "#26.2% of the dataframe's data is missing! "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 19,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 801
        },
        "id": "KhlwuHNnCkgM",
        "outputId": "bcbd26e2-f69b-44ce-933a-f59080abb9a9"
      },
      "outputs": [
        {
          "data": {
            "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>Permit Number</th>\n",
              "      <th>Permit Type</th>\n",
              "      <th>Permit Type Definition</th>\n",
              "      <th>Permit Creation Date</th>\n",
              "      <th>Block</th>\n",
              "      <th>Lot</th>\n",
              "      <th>Street Number</th>\n",
              "      <th>Street Number Suffix</th>\n",
              "      <th>Street Name</th>\n",
              "      <th>Street Suffix</th>\n",
              "      <th>Unit</th>\n",
              "      <th>Unit Suffix</th>\n",
              "      <th>Description</th>\n",
              "      <th>Current Status</th>\n",
              "      <th>Current Status Date</th>\n",
              "      <th>Filed Date</th>\n",
              "      <th>Issued Date</th>\n",
              "      <th>Completed Date</th>\n",
              "      <th>First Construction Document Date</th>\n",
              "      <th>Structural Notification</th>\n",
              "      <th>Number of Existing Stories</th>\n",
              "      <th>Number of Proposed Stories</th>\n",
              "      <th>Voluntary Soft-Story Retrofit</th>\n",
              "      <th>Fire Only Permit</th>\n",
              "      <th>Permit Expiration Date</th>\n",
              "      <th>Estimated Cost</th>\n",
              "      <th>Revised Cost</th>\n",
              "      <th>Existing Use</th>\n",
              "      <th>Existing Units</th>\n",
              "      <th>Proposed Use</th>\n",
              "      <th>Proposed Units</th>\n",
              "      <th>Plansets</th>\n",
              "      <th>TIDF Compliance</th>\n",
              "      <th>Existing Construction Type</th>\n",
              "      <th>Existing Construction Type Description</th>\n",
              "      <th>Proposed Construction Type</th>\n",
              "      <th>Proposed Construction Type Description</th>\n",
              "      <th>Site Permit</th>\n",
              "      <th>Supervisor District</th>\n",
              "      <th>Neighborhoods - Analysis Boundaries</th>\n",
              "      <th>Zipcode</th>\n",
              "      <th>Location</th>\n",
              "      <th>Record ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>201505065519</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>0326</td>\n",
              "      <td>023</td>\n",
              "      <td>140</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Ellis</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ground fl facade: to erect illuminated, electr...</td>\n",
              "      <td>expired</td>\n",
              "      <td>12/21/2017</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>11/09/2015</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11/09/2015</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11/03/2016</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>tourist hotel/motel</td>\n",
              "      <td>143.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.785719256680785, -122.40852313194863)</td>\n",
              "      <td>1380611233945</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>201604195146</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>0306</td>\n",
              "      <td>007</td>\n",
              "      <td>440</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Geary</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>remove (e) awning and associated signs.</td>\n",
              "      <td>issued</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/03/2017</td>\n",
              "      <td>1.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>tourist hotel/motel</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.78733980600732, -122.41063199757738)</td>\n",
              "      <td>1420164406718</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>201605278609</td>\n",
              "      <td>3</td>\n",
              "      <td>additions alterations or repairs</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>0595</td>\n",
              "      <td>203</td>\n",
              "      <td>1647</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>installation of separating wall</td>\n",
              "      <td>withdrawn</td>\n",
              "      <td>09/26/2017</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Russian Hill</td>\n",
              "      <td>94109.0</td>\n",
              "      <td>(37.7946573324287, -122.42232562979227)</td>\n",
              "      <td>1424856504716</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>201611072166</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>0156</td>\n",
              "      <td>011</td>\n",
              "      <td>1230</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>repair dryrot &amp; stucco at front of bldg.</td>\n",
              "      <td>complete</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>07/13/2018</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>1 family dwelling</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1 family dwelling</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Nob Hill</td>\n",
              "      <td>94109.0</td>\n",
              "      <td>(37.79595867909168, -122.41557405519474)</td>\n",
              "      <td>1443574295566</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>201611283529</td>\n",
              "      <td>6</td>\n",
              "      <td>demolitions</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>0342</td>\n",
              "      <td>001</td>\n",
              "      <td>950</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Market</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>demolish retail/office/commercial 3-story buil...</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/01/2017</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>12/01/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11/20/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/01/2018</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.78315261897309, -122.40950883997789)</td>\n",
              "      <td>144548169992</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",
              "      <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",
              "      <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",
              "      <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>198895</th>\n",
              "      <td>M862628</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0113</td>\n",
              "      <td>017A</td>\n",
              "      <td>1228</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Montgomery</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>street space</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1489337276729</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198896</th>\n",
              "      <td>201712055595</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0271</td>\n",
              "      <td>014</td>\n",
              "      <td>580</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Bush</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>fire alarm upgrade ref 201704123852</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Y</td>\n",
              "      <td>04/06/2018</td>\n",
              "      <td>5000.0</td>\n",
              "      <td>5000.0</td>\n",
              "      <td>apartments</td>\n",
              "      <td>4.0</td>\n",
              "      <td>apartments</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1489462354993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198897</th>\n",
              "      <td>M863507</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>4318</td>\n",
              "      <td>019</td>\n",
              "      <td>1568</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Indiana</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>street space</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1489539379952</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198898</th>\n",
              "      <td>M863747</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0298</td>\n",
              "      <td>029</td>\n",
              "      <td>795</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Sutter</td>\n",
              "      <td>St</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>street space permit</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1489608233656</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198899</th>\n",
              "      <td>M864287</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>0160</td>\n",
              "      <td>006</td>\n",
              "      <td>838</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>street space permit</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1489796283803</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>198900 rows × 43 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       Permit Number  ...      Record ID\n",
              "0       201505065519  ...  1380611233945\n",
              "1       201604195146  ...  1420164406718\n",
              "2       201605278609  ...  1424856504716\n",
              "3       201611072166  ...  1443574295566\n",
              "4       201611283529  ...   144548169992\n",
              "...              ...  ...            ...\n",
              "198895       M862628  ...  1489337276729\n",
              "198896  201712055595  ...  1489462354993\n",
              "198897       M863507  ...  1489539379952\n",
              "198898       M863747  ...  1489608233656\n",
              "198899       M864287  ...  1489796283803\n",
              "\n",
              "[198900 rows x 43 columns]"
            ]
          },
          "execution_count": 19,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        " #3\n",
        "building_permits_df['Street Number Suffix'].unique()\n",
        "building_permits_df['Zipcode'].unique()\n",
        "\n",
        "building_permits_df\n",
        "\n",
        "#Answer: The street suffix can be non-existant. However, a Zipcode should exist with every city. Therefore, it could be non-existant because it was not recorded."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 20,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "2OnofY2SbN6D",
        "outputId": "889dad89-1928-4927-87d5-ca7ea86f2aeb"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "array([nan, 'A', 'C', 'V', 'B', 'F', 'R', 'D', '0', 'E', 'P', 'G', 'J',\n",
              "       'K', 'H', 'L', 'I', '½', 'N'], dtype=object)"
            ]
          },
          "execution_count": 20,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "building_permits_df['Street Number Suffix'].unique()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 21,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xjeJcpQRX77O",
        "outputId": "7f968f39-7c71-415c-e620-e2ad59b2cb8e"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "array([94102., 94109., 94107., 94122., 94124., 94117., 94114., 94131.,\n",
              "       94115., 94108., 94104., 94123., 94110., 94133., 94121., 94105.,\n",
              "       94103., 94118., 94132., 94112., 94134., 94116., 94127., 94158.,\n",
              "       94130., 94111.,    nan, 94129.])"
            ]
          },
          "execution_count": 21,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "building_permits_df['Zipcode'].unique()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 22,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 118
        },
        "id": "CS-C2X8hFYEX",
        "outputId": "ce0eee40-055e-488a-fa9a-110d950ae04a"
      },
      "outputs": [
        {
          "data": {
            "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>Permit Number</th>\n",
              "      <th>Permit Type</th>\n",
              "      <th>Permit Type Definition</th>\n",
              "      <th>Permit Creation Date</th>\n",
              "      <th>Block</th>\n",
              "      <th>Lot</th>\n",
              "      <th>Street Number</th>\n",
              "      <th>Street Number Suffix</th>\n",
              "      <th>Street Name</th>\n",
              "      <th>Street Suffix</th>\n",
              "      <th>Unit</th>\n",
              "      <th>Unit Suffix</th>\n",
              "      <th>Description</th>\n",
              "      <th>Current Status</th>\n",
              "      <th>Current Status Date</th>\n",
              "      <th>Filed Date</th>\n",
              "      <th>Issued Date</th>\n",
              "      <th>Completed Date</th>\n",
              "      <th>First Construction Document Date</th>\n",
              "      <th>Structural Notification</th>\n",
              "      <th>Number of Existing Stories</th>\n",
              "      <th>Number of Proposed Stories</th>\n",
              "      <th>Voluntary Soft-Story Retrofit</th>\n",
              "      <th>Fire Only Permit</th>\n",
              "      <th>Permit Expiration Date</th>\n",
              "      <th>Estimated Cost</th>\n",
              "      <th>Revised Cost</th>\n",
              "      <th>Existing Use</th>\n",
              "      <th>Existing Units</th>\n",
              "      <th>Proposed Use</th>\n",
              "      <th>Proposed Units</th>\n",
              "      <th>Plansets</th>\n",
              "      <th>TIDF Compliance</th>\n",
              "      <th>Existing Construction Type</th>\n",
              "      <th>Existing Construction Type Description</th>\n",
              "      <th>Proposed Construction Type</th>\n",
              "      <th>Proposed Construction Type Description</th>\n",
              "      <th>Site Permit</th>\n",
              "      <th>Supervisor District</th>\n",
              "      <th>Neighborhoods - Analysis Boundaries</th>\n",
              "      <th>Zipcode</th>\n",
              "      <th>Location</th>\n",
              "      <th>Record ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "Empty DataFrame\n",
              "Columns: [Permit Number, Permit Type, Permit Type Definition, Permit Creation Date, Block, Lot, Street Number, Street Number Suffix, Street Name, Street Suffix, Unit, Unit Suffix, Description, Current Status, Current Status Date, Filed Date, Issued Date, Completed Date, First Construction Document Date, Structural Notification, Number of Existing Stories, Number of Proposed Stories, Voluntary Soft-Story Retrofit, Fire Only Permit, Permit Expiration Date, Estimated Cost, Revised Cost, Existing Use, Existing Units, Proposed Use, Proposed Units, Plansets, TIDF Compliance, Existing Construction Type, Existing Construction Type Description, Proposed Construction Type, Proposed Construction Type Description, Site Permit, Supervisor District, Neighborhoods - Analysis Boundaries, Zipcode, Location, Record ID]\n",
              "Index: []"
            ]
          },
          "execution_count": 22,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "#4 \n",
        "\n",
        "#drop nan rows\n",
        "building_permits_df_rows_dropped = building_permits_df.dropna()\n",
        "building_permits_df_rows_dropped\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 23,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 701
        },
        "id": "ca80PWEKFFBL",
        "outputId": "766668c8-7042-4f87-b252-89eaf7ad1219"
      },
      "outputs": [
        {
          "data": {
            "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>Permit Number</th>\n",
              "      <th>Permit Type</th>\n",
              "      <th>Permit Type Definition</th>\n",
              "      <th>Permit Creation Date</th>\n",
              "      <th>Block</th>\n",
              "      <th>Lot</th>\n",
              "      <th>Street Number</th>\n",
              "      <th>Street Name</th>\n",
              "      <th>Current Status</th>\n",
              "      <th>Current Status Date</th>\n",
              "      <th>Filed Date</th>\n",
              "      <th>Record ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>201505065519</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>0326</td>\n",
              "      <td>023</td>\n",
              "      <td>140</td>\n",
              "      <td>Ellis</td>\n",
              "      <td>expired</td>\n",
              "      <td>12/21/2017</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>1380611233945</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>201604195146</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>0306</td>\n",
              "      <td>007</td>\n",
              "      <td>440</td>\n",
              "      <td>Geary</td>\n",
              "      <td>issued</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>1420164406718</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>201605278609</td>\n",
              "      <td>3</td>\n",
              "      <td>additions alterations or repairs</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>0595</td>\n",
              "      <td>203</td>\n",
              "      <td>1647</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>withdrawn</td>\n",
              "      <td>09/26/2017</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>1424856504716</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>201611072166</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>0156</td>\n",
              "      <td>011</td>\n",
              "      <td>1230</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>complete</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>1443574295566</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>201611283529</td>\n",
              "      <td>6</td>\n",
              "      <td>demolitions</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>0342</td>\n",
              "      <td>001</td>\n",
              "      <td>950</td>\n",
              "      <td>Market</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/01/2017</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>144548169992</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>198895</th>\n",
              "      <td>M862628</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0113</td>\n",
              "      <td>017A</td>\n",
              "      <td>1228</td>\n",
              "      <td>Montgomery</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>1489337276729</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198896</th>\n",
              "      <td>201712055595</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0271</td>\n",
              "      <td>014</td>\n",
              "      <td>580</td>\n",
              "      <td>Bush</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>1489462354993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198897</th>\n",
              "      <td>M863507</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>4318</td>\n",
              "      <td>019</td>\n",
              "      <td>1568</td>\n",
              "      <td>Indiana</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>1489539379952</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198898</th>\n",
              "      <td>M863747</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0298</td>\n",
              "      <td>029</td>\n",
              "      <td>795</td>\n",
              "      <td>Sutter</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>1489608233656</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198899</th>\n",
              "      <td>M864287</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>0160</td>\n",
              "      <td>006</td>\n",
              "      <td>838</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>1489796283803</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>198900 rows × 12 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       Permit Number  Permit Type  ...  Filed Date      Record ID\n",
              "0       201505065519            4  ...  05/06/2015  1380611233945\n",
              "1       201604195146            4  ...  04/19/2016  1420164406718\n",
              "2       201605278609            3  ...  05/27/2016  1424856504716\n",
              "3       201611072166            8  ...  11/07/2016  1443574295566\n",
              "4       201611283529            6  ...  11/28/2016   144548169992\n",
              "...              ...          ...  ...         ...            ...\n",
              "198895       M862628            8  ...  12/05/2017  1489337276729\n",
              "198896  201712055595            8  ...  12/05/2017  1489462354993\n",
              "198897       M863507            8  ...  12/06/2017  1489539379952\n",
              "198898       M863747            8  ...  12/06/2017  1489608233656\n",
              "198899       M864287            8  ...  12/07/2017  1489796283803\n",
              "\n",
              "[198900 rows x 12 columns]"
            ]
          },
          "execution_count": 23,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "\n",
        "#drop nan cols\n",
        "\n",
        "building_permits_df_cols_dropped = building_permits_df.dropna(axis = 1)\n",
        "building_permits_df_cols_dropped"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 24,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 801
        },
        "id": "e4ftNEdaF2oD",
        "outputId": "136302a6-4211-4d55-8018-59310619c77c"
      },
      "outputs": [
        {
          "data": {
            "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>Permit Number</th>\n",
              "      <th>Permit Type</th>\n",
              "      <th>Permit Type Definition</th>\n",
              "      <th>Permit Creation Date</th>\n",
              "      <th>Block</th>\n",
              "      <th>Lot</th>\n",
              "      <th>Street Number</th>\n",
              "      <th>Street Number Suffix</th>\n",
              "      <th>Street Name</th>\n",
              "      <th>Street Suffix</th>\n",
              "      <th>Unit</th>\n",
              "      <th>Unit Suffix</th>\n",
              "      <th>Description</th>\n",
              "      <th>Current Status</th>\n",
              "      <th>Current Status Date</th>\n",
              "      <th>Filed Date</th>\n",
              "      <th>Issued Date</th>\n",
              "      <th>Completed Date</th>\n",
              "      <th>First Construction Document Date</th>\n",
              "      <th>Structural Notification</th>\n",
              "      <th>Number of Existing Stories</th>\n",
              "      <th>Number of Proposed Stories</th>\n",
              "      <th>Voluntary Soft-Story Retrofit</th>\n",
              "      <th>Fire Only Permit</th>\n",
              "      <th>Permit Expiration Date</th>\n",
              "      <th>Estimated Cost</th>\n",
              "      <th>Revised Cost</th>\n",
              "      <th>Existing Use</th>\n",
              "      <th>Existing Units</th>\n",
              "      <th>Proposed Use</th>\n",
              "      <th>Proposed Units</th>\n",
              "      <th>Plansets</th>\n",
              "      <th>TIDF Compliance</th>\n",
              "      <th>Existing Construction Type</th>\n",
              "      <th>Existing Construction Type Description</th>\n",
              "      <th>Proposed Construction Type</th>\n",
              "      <th>Proposed Construction Type Description</th>\n",
              "      <th>Site Permit</th>\n",
              "      <th>Supervisor District</th>\n",
              "      <th>Neighborhoods - Analysis Boundaries</th>\n",
              "      <th>Zipcode</th>\n",
              "      <th>Location</th>\n",
              "      <th>Record ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>201505065519</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>0326</td>\n",
              "      <td>023</td>\n",
              "      <td>140</td>\n",
              "      <td>A</td>\n",
              "      <td>Ellis</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>A</td>\n",
              "      <td>ground fl facade: to erect illuminated, electr...</td>\n",
              "      <td>expired</td>\n",
              "      <td>12/21/2017</td>\n",
              "      <td>05/06/2015</td>\n",
              "      <td>11/09/2015</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>11/09/2015</td>\n",
              "      <td>Y</td>\n",
              "      <td>6.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>Y</td>\n",
              "      <td>11/03/2016</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>4000.0</td>\n",
              "      <td>tourist hotel/motel</td>\n",
              "      <td>143.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.785719256680785, -122.40852313194863)</td>\n",
              "      <td>1380611233945</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>201604195146</td>\n",
              "      <td>4</td>\n",
              "      <td>sign - erect</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>0306</td>\n",
              "      <td>007</td>\n",
              "      <td>440</td>\n",
              "      <td>A</td>\n",
              "      <td>Geary</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>A</td>\n",
              "      <td>remove (e) awning and associated signs.</td>\n",
              "      <td>issued</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>04/19/2016</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>08/03/2017</td>\n",
              "      <td>Y</td>\n",
              "      <td>7.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>Y</td>\n",
              "      <td>12/03/2017</td>\n",
              "      <td>1.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>tourist hotel/motel</td>\n",
              "      <td>39.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.78733980600732, -122.41063199757738)</td>\n",
              "      <td>1420164406718</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>201605278609</td>\n",
              "      <td>3</td>\n",
              "      <td>additions alterations or repairs</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>0595</td>\n",
              "      <td>203</td>\n",
              "      <td>1647</td>\n",
              "      <td>A</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>0.0</td>\n",
              "      <td>A</td>\n",
              "      <td>installation of separating wall</td>\n",
              "      <td>withdrawn</td>\n",
              "      <td>09/26/2017</td>\n",
              "      <td>05/27/2016</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>Y</td>\n",
              "      <td>6.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>Y</td>\n",
              "      <td>07/13/2018</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>39.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Russian Hill</td>\n",
              "      <td>94109.0</td>\n",
              "      <td>(37.7946573324287, -122.42232562979227)</td>\n",
              "      <td>1424856504716</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>201611072166</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>0156</td>\n",
              "      <td>011</td>\n",
              "      <td>1230</td>\n",
              "      <td>A</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>0.0</td>\n",
              "      <td>A</td>\n",
              "      <td>repair dryrot &amp; stucco at front of bldg.</td>\n",
              "      <td>complete</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>11/07/2016</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>07/24/2017</td>\n",
              "      <td>07/18/2017</td>\n",
              "      <td>Y</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>Y</td>\n",
              "      <td>07/13/2018</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>1 family dwelling</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1 family dwelling</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Nob Hill</td>\n",
              "      <td>94109.0</td>\n",
              "      <td>(37.79595867909168, -122.41557405519474)</td>\n",
              "      <td>1443574295566</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>201611283529</td>\n",
              "      <td>6</td>\n",
              "      <td>demolitions</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>0342</td>\n",
              "      <td>001</td>\n",
              "      <td>950</td>\n",
              "      <td>A</td>\n",
              "      <td>Market</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>A</td>\n",
              "      <td>demolish retail/office/commercial 3-story buil...</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/01/2017</td>\n",
              "      <td>11/28/2016</td>\n",
              "      <td>12/01/2017</td>\n",
              "      <td>07/12/2017</td>\n",
              "      <td>11/20/2017</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>Y</td>\n",
              "      <td>12/01/2018</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>retail sales</td>\n",
              "      <td>326.0</td>\n",
              "      <td>apartments</td>\n",
              "      <td>326.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>Y</td>\n",
              "      <td>3.0</td>\n",
              "      <td>constr type 3</td>\n",
              "      <td>1.0</td>\n",
              "      <td>constr type 1</td>\n",
              "      <td>Y</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Tenderloin</td>\n",
              "      <td>94102.0</td>\n",
              "      <td>(37.78315261897309, -122.40950883997789)</td>\n",
              "      <td>144548169992</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",
              "      <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",
              "      <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",
              "      <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>198895</th>\n",
              "      <td>M862628</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0113</td>\n",
              "      <td>017A</td>\n",
              "      <td>1228</td>\n",
              "      <td>0</td>\n",
              "      <td>Montgomery</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>street space</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0</td>\n",
              "      <td>Y</td>\n",
              "      <td>04/06/2018</td>\n",
              "      <td>5000.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>apartments</td>\n",
              "      <td>4.0</td>\n",
              "      <td>apartments</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1489337276729</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198896</th>\n",
              "      <td>201712055595</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>0271</td>\n",
              "      <td>014</td>\n",
              "      <td>580</td>\n",
              "      <td>0</td>\n",
              "      <td>Bush</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>fire alarm upgrade ref 201704123852</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/05/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0</td>\n",
              "      <td>Y</td>\n",
              "      <td>04/06/2018</td>\n",
              "      <td>5000.0</td>\n",
              "      <td>5000.0</td>\n",
              "      <td>apartments</td>\n",
              "      <td>4.0</td>\n",
              "      <td>apartments</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>5.0</td>\n",
              "      <td>wood frame (5)</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1489462354993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198897</th>\n",
              "      <td>M863507</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>4318</td>\n",
              "      <td>019</td>\n",
              "      <td>1568</td>\n",
              "      <td>0</td>\n",
              "      <td>Indiana</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>street space</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1489539379952</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198898</th>\n",
              "      <td>M863747</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0298</td>\n",
              "      <td>029</td>\n",
              "      <td>795</td>\n",
              "      <td>0</td>\n",
              "      <td>Sutter</td>\n",
              "      <td>St</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>street space permit</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>12/06/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1489608233656</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>198899</th>\n",
              "      <td>M864287</td>\n",
              "      <td>8</td>\n",
              "      <td>otc alterations permit</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>0160</td>\n",
              "      <td>006</td>\n",
              "      <td>838</td>\n",
              "      <td>0</td>\n",
              "      <td>Pacific</td>\n",
              "      <td>Av</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>street space permit</td>\n",
              "      <td>issued</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>12/07/2017</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1489796283803</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>198900 rows × 43 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       Permit Number  ...      Record ID\n",
              "0       201505065519  ...  1380611233945\n",
              "1       201604195146  ...  1420164406718\n",
              "2       201605278609  ...  1424856504716\n",
              "3       201611072166  ...  1443574295566\n",
              "4       201611283529  ...   144548169992\n",
              "...              ...  ...            ...\n",
              "198895       M862628  ...  1489337276729\n",
              "198896  201712055595  ...  1489462354993\n",
              "198897       M863507  ...  1489539379952\n",
              "198898       M863747  ...  1489608233656\n",
              "198899       M864287  ...  1489796283803\n",
              "\n",
              "[198900 rows x 43 columns]"
            ]
          },
          "execution_count": 24,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# 5\n",
        "\n",
        "building_permits_df.fillna(method = 'bfill', axis=0).fillna(0) #axis =0 col - axis = 1 rows\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 25,
      "metadata": {
        "id": "pGOkmTfHHZPN"
      },
      "outputs": [],
      "source": [
        "#6\n",
        "imputed_permits = building_permits_df.fillna(method = 'bfill', axis=0).fillna(0)\n",
        "imputed_permits.to_csv('imputed_permits.csv')"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "collapsed_sections": [],
      "name": "Lab 3 - Task.ipynb",
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3.6.15 64-bit",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "name": "python",
      "version": "3.6.15"
    },
    "vscode": {
      "interpreter": {
        "hash": "767d51c1340bd893661ea55ea3124f6de3c7a262a8b4abca0554b478b1e2ff90"
      }
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}