notebooks/2_laczenie.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyMy1vhHD6I5EDqE+oKOgR2u",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/DepartmentOfStatisticsPUE/air-2024/blob/main/notebooks/2_laczenie.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "id": "PUPCY_Xxq5b6"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "wyn = pd.read_excel(\"/content/wynag-powiaty.xlsx\",\n",
        "                    sheet_name = 1)\n",
        "nie = pd.read_excel(\"/content/nieruch-powiaty.xlsx\",\n",
        "                    sheet_name = \"DANE\")\n",
        "nie.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 258
        },
        "id": "WSU6Fp5nrTZt",
        "outputId": "1a23559f-ac30-4422-a850-0ad9981f0ac3"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Kod                   Nazwa Transakcje rynkowe  \\\n",
              "0  261000  Powiat m. Jelenia Góra       rynek wtórny   \n",
              "1  261000  Powiat m. Jelenia Góra       rynek wtórny   \n",
              "2  262000       Powiat m. Legnica       rynek wtórny   \n",
              "3  262000       Powiat m. Legnica       rynek wtórny   \n",
              "4  264000       Powiat m. Wrocław       rynek wtórny   \n",
              "\n",
              "  Powierzchnia użytkowa lokali mieszkalnych   Rok  Wartosc Jednostka miary  \\\n",
              "0                                    ogółem  2021   235712              zł   \n",
              "1                                    ogółem  2022   266242              zł   \n",
              "2                                    ogółem  2021   250244              zł   \n",
              "3                                    ogółem  2022   268053              zł   \n",
              "4                                    ogółem  2021   445419              zł   \n",
              "\n",
              "  Atrybut  \n",
              "0          \n",
              "1          \n",
              "2          \n",
              "3          \n",
              "4          "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a606c51f-0097-480e-b880-12f9171fde2e\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Kod</th>\n",
              "      <th>Nazwa</th>\n",
              "      <th>Transakcje rynkowe</th>\n",
              "      <th>Powierzchnia użytkowa lokali mieszkalnych</th>\n",
              "      <th>Rok</th>\n",
              "      <th>Wartosc</th>\n",
              "      <th>Jednostka miary</th>\n",
              "      <th>Atrybut</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>261000</td>\n",
              "      <td>Powiat m. Jelenia Góra</td>\n",
              "      <td>rynek wtórny</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2021</td>\n",
              "      <td>235712</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>261000</td>\n",
              "      <td>Powiat m. Jelenia Góra</td>\n",
              "      <td>rynek wtórny</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2022</td>\n",
              "      <td>266242</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>262000</td>\n",
              "      <td>Powiat m. Legnica</td>\n",
              "      <td>rynek wtórny</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2021</td>\n",
              "      <td>250244</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>262000</td>\n",
              "      <td>Powiat m. Legnica</td>\n",
              "      <td>rynek wtórny</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2022</td>\n",
              "      <td>268053</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>264000</td>\n",
              "      <td>Powiat m. Wrocław</td>\n",
              "      <td>rynek wtórny</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2021</td>\n",
              "      <td>445419</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a606c51f-0097-480e-b880-12f9171fde2e')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-a606c51f-0097-480e-b880-12f9171fde2e button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-a606c51f-0097-480e-b880-12f9171fde2e');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7d82a846-3c93-44aa-bebe-e052535a2458\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7d82a846-3c93-44aa-bebe-e052535a2458')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7d82a846-3c93-44aa-bebe-e052535a2458 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Łączymy dane wykorzystując dwa identyfikatory: Kod i Rok."
      ],
      "metadata": {
        "id": "iJfaPTuGtb1C"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Wykorzystujemy łączenie typu inner join"
      ],
      "metadata": {
        "id": "niNAD7SytrX2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "zb1 = pd.merge(\n",
        "    left = wyn[[\"Kod\", \"Rok\", \"Wartosc\"]],\n",
        "    right = nie[[\"Kod\", \"Rok\", \"Wartosc\"]],\n",
        "    on = [\"Kod\", \"Rok\"],\n",
        "    how = \"inner\",\n",
        ")"
      ],
      "metadata": {
        "id": "jVVbwfvitnYU"
      },
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "zb2 = pd.merge(\n",
        "    left = wyn[[\"Kod\", \"Rok\", \"Wartosc\"]],\n",
        "    right = nie[[\"Kod\", \"Rok\", \"Wartosc\"]],\n",
        "    on = [\"Kod\", \"Rok\"],\n",
        "    how = \"left\",\n",
        ")\n",
        "zb2.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "M5YCN_QTvOqe",
        "outputId": "d9272a18-9ad0-48db-9c8d-e3aa0634cbd6"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Kod   Rok  Wartosc_x  Wartosc_y\n",
              "0  201000  2021    5461.94        NaN\n",
              "1  201000  2022    6181.60        NaN\n",
              "2  202000  2021    5127.97        NaN\n",
              "3  202000  2022    5723.65        NaN\n",
              "4  203000  2021    5171.28        NaN"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-44596a4f-819d-492f-bfff-376431b7b5ed\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Kod</th>\n",
              "      <th>Rok</th>\n",
              "      <th>Wartosc_x</th>\n",
              "      <th>Wartosc_y</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>201000</td>\n",
              "      <td>2021</td>\n",
              "      <td>5461.94</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>201000</td>\n",
              "      <td>2022</td>\n",
              "      <td>6181.60</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>202000</td>\n",
              "      <td>2021</td>\n",
              "      <td>5127.97</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>202000</td>\n",
              "      <td>2022</td>\n",
              "      <td>5723.65</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>203000</td>\n",
              "      <td>2021</td>\n",
              "      <td>5171.28</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-44596a4f-819d-492f-bfff-376431b7b5ed')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-44596a4f-819d-492f-bfff-376431b7b5ed button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-44596a4f-819d-492f-bfff-376431b7b5ed');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-490f79ed-aaa5-4442-9f80-7759dac634b1\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-490f79ed-aaa5-4442-9f80-7759dac634b1')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-490f79ed-aaa5-4442-9f80-7759dac634b1 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Sprawdzamy jak wygląda zależność między wynagrodzeniem, a ceną nieruchomości na wtórnym rynku"
      ],
      "metadata": {
        "id": "DGDlm5PnwUUX"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "zb1[zb1[\"Rok\"] == 2022].plot.scatter(x = \"Wartosc_x\", y = \"Wartosc_y\")"
      ],
      "metadata": {
        "id": "Z7Yj872Owaip",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 467
        },
        "outputId": "6c3ebbe0-a6cf-4483-9409-89dda2ca0b51"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<Axes: xlabel='Wartosc_x', ylabel='Wartosc_y'>"
            ]
          },
          "metadata": {},
          "execution_count": 6
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 640x480 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAlUAAAGwCAYAAACAZ5AeAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAABCuklEQVR4nO3deXxV1b3//3cGEgiQBMgEEkiQSQQlEEgjCkRSo6WtXK3FlCIitg4IAq1TrdO1CkV7awUV7W1BbwWEfussagoJCMQQggHCELGMBQOBkBzmQM76/eEvuzmQ4ZxkJycneT0fjzxus/c6+6yT3dvzZq21P8vPGGMEAACABvH3dgcAAABaAkIVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYI9HYHWhOn06lDhw6pY8eO8vPz83Z3AACAG4wxOnHihLp16yZ//5rHowhVTejQoUOKjY31djcAAEA9HDhwQN27d6/xPKGqCXXs2FHSdzclNDTUy70BAADucDgcio2Ntb7Ha0KoakKVU36hoaGEKgAAfExdS3dYqA4AAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA3YpgYAAFxid/FJ7Ss5rbgu7RUf0d7b3fEJhCoAAGApPV2u6UvytWZXsXVsZJ9IzUtPUFhIGy/2rPlj+g8AAFimL8nXum+Ouhxb981RTVvylZd65DsIVQAAQNJ3U35rdhWrwhiX4xXGaM2uYu05espLPfMNhCoAACBJ2ldyutbze48RqmpDqAIAAJKknp1Daj0f14UF67UhVAEAAElSr8gOGtknUgF+fi7HA/z8NLJPJE8B1oFQBQAALPPSEzSid4TLsRG9IzQvPcFLPfIdlFQAAACWsJA2emvKcO05ekp7j52iTpUHCFUAAOAS8RGEKU8x/QcAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANvBqqKqoqNATTzyh+Ph4tWvXTpdffrmeffZZGWOsNsYYPfnkk+ratavatWun1NRU7dq1y+U6JSUlmjBhgkJDQxUeHq4pU6bo5MmTLm22bNmi6667Tm3btlVsbKzmzp17SX+WL1+u/v37q23btho0aJA++eQTl/Pu9AUAALROXg1Vv//97/Xaa69p/vz52rFjh37/+99r7ty5mjdvntVm7ty5evnll7VgwQLl5OSoffv2SktL09mzZ602EyZM0LZt25SRkaGPPvpIa9as0S9/+UvrvMPh0A033KCePXsqLy9PL7zwgp5++mm98cYbVpv169crPT1dU6ZM0VdffaVx48Zp3LhxKigo8KgvAACglTJeNHbsWHPXXXe5HLvlllvMhAkTjDHGOJ1OExMTY1544QXrfGlpqQkODjZLliwxxhizfft2I8nk5uZabVasWGH8/PzMwYMHjTHGvPrqq6ZTp07m3LlzVptHHnnE9OvXz/r9pz/9qRk7dqxLX5KSksw999zjdl/qUlZWZiSZsrIyt9oDAADvc/f726sjVddcc41Wrlypr7/+WpK0efNmrV27VjfddJMkac+ePSoqKlJqaqr1mrCwMCUlJSk7O1uSlJ2drfDwcCUmJlptUlNT5e/vr5ycHKvNyJEjFRQUZLVJS0tTYWGhjh8/brWp+j6VbSrfx52+XOzcuXNyOBwuPwAAoGUK9OabP/roo3I4HOrfv78CAgJUUVGh5557ThMmTJAkFRUVSZKio6NdXhcdHW2dKyoqUlRUlMv5wMBAde7c2aVNfHz8JdeoPNepUycVFRXV+T519eVis2fP1jPPPOPGXwIAAPg6r45ULVu2TG+//bYWL16sTZs26c0339SLL76oN99805vdss1jjz2msrIy6+fAgQPe7hIAAGgkXh2peuihh/Too4/q9ttvlyQNGjRI+/bt0+zZszVp0iTFxMRIkg4fPqyuXbtarzt8+LAGDx4sSYqJidGRI0dcrnvhwgWVlJRYr4+JidHhw4dd2lT+Xlebqufr6svFgoODFRwc7N4fAwAA+DSvjlSdPn1a/v6uXQgICJDT6ZQkxcfHKyYmRitXrrTOOxwO5eTkKDk5WZKUnJys0tJS5eXlWW1WrVolp9OppKQkq82aNWt0/vx5q01GRob69eunTp06WW2qvk9lm8r3cacvAACgFWuihfPVmjRpkrnsssvMRx99ZPbs2WP+8Y9/mIiICPPwww9bbebMmWPCw8PN+++/b7Zs2WJuvvlmEx8fb86cOWO1ufHGG01CQoLJyckxa9euNX369DHp6enW+dLSUhMdHW0mTpxoCgoKzNKlS01ISIh5/fXXrTbr1q0zgYGB5sUXXzQ7duwwTz31lGnTpo3ZunWrR32pDU//AQDge9z9/vZqqHI4HObBBx80PXr0MG3btjW9evUyjz/+uEvpA6fTaZ544gkTHR1tgoODzZgxY0xhYaHLdY4dO2bS09NNhw4dTGhoqJk8ebI5ceKES5vNmzeba6+91gQHB5vLLrvMzJkz55L+LFu2zPTt29cEBQWZK6+80nz88ccu593pS20IVQAA+B53v7/9jKlSvhyNyuFwKCwsTGVlZQoNDfV2dwAAgBvc/f5m7z8AAAAbEKoAAABsQKgCAACwAaEKAADABoQqAAAAGxCqAAAAbECoAgAAsAGhCgAAwAaEKgAAABsQqgAAAGxAqAIAALABoQoAAMAGhCoAAAAbEKoAAABsQKgCAACwAaEKAADABoQqAAAAGxCqAAAAbECoAgAAsAGhCgAAwAaEKgAAABsEersDAAAADbW7+KT2lZxWXJf2io9o75U+EKoAAIDPKj1drulL8rVmV7F1bGSfSM1LT1BYSJsm7QvTfwAAwGdNX5Kvdd8cdTm27pujmrbkqybvC6EKAAD4pN3FJ7VmV7EqjHE5XmGM1uwq1p6jp5q0P4QqAADgk/aVnK71/N5jhCoAAIA69ewcUuv5uC5Nu2CdUAUAAHxSr8gOGtknUgF+fi7HA/z8NLJPZJM/BUioAgAAPmteeoJG9I5wOTaid4TmpSc0eV8oqQAAAHxWWEgbvTVluPYcPaW9x05RpwoAAKAh4iO8F6YqMf0HAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYAOvh6qDBw/q5z//ubp06aJ27dpp0KBB2rhxo3XeGKMnn3xSXbt2Vbt27ZSamqpdu3a5XKOkpEQTJkxQaGiowsPDNWXKFJ08edKlzZYtW3Tdddepbdu2io2N1dy5cy/py/Lly9W/f3+1bdtWgwYN0ieffOJy3p2+AACA1smroer48eMaMWKE2rRpoxUrVmj79u36wx/+oE6dOllt5s6dq5dfflkLFixQTk6O2rdvr7S0NJ09e9ZqM2HCBG3btk0ZGRn66KOPtGbNGv3yl7+0zjscDt1www3q2bOn8vLy9MILL+jpp5/WG2+8YbVZv3690tPTNWXKFH311VcaN26cxo0bp4KCAo/6AgAAWinjRY888oi59tprazzvdDpNTEyMeeGFF6xjpaWlJjg42CxZssQYY8z27duNJJObm2u1WbFihfHz8zMHDx40xhjz6quvmk6dOplz5865vHe/fv2s33/605+asWPHurx/UlKSueeee9zuy8XOnj1rysrKrJ8DBw4YSaasrKzOvw0AAGgeysrK3Pr+9upI1QcffKDExETddtttioqKUkJCgv785z9b5/fs2aOioiKlpqZax8LCwpSUlKTs7GxJUnZ2tsLDw5WYmGi1SU1Nlb+/v3Jycqw2I0eOVFBQkNUmLS1NhYWFOn78uNWm6vtUtql8H3f6crHZs2crLCzM+omNja3X3wkAADR/Xg1Vu3fv1muvvaY+ffros88+03333afp06frzTfflCQVFRVJkqKjo11eFx0dbZ0rKipSVFSUy/nAwEB17tzZpU1116j6HjW1qXq+rr5c7LHHHlNZWZn1c+DAgbr+JAAAwEcFevPNnU6nEhMT9fzzz0uSEhISVFBQoAULFmjSpEne7JotgoODFRwc7O1uAACAJuDVkaquXbtqwIABLseuuOIK7d+/X5IUExMjSTp8+LBLm8OHD1vnYmJidOTIEZfzFy5cUElJiUub6q5R9T1qalP1fF19AQAArZdXQ9WIESNUWFjocuzrr79Wz549JUnx8fGKiYnRypUrrfMOh0M5OTlKTk6WJCUnJ6u0tFR5eXlWm1WrVsnpdCopKclqs2bNGp0/f95qk5GRoX79+llPGiYnJ7u8T2Wbyvdxpy8AAKAVa6KF89XasGGDCQwMNM8995zZtWuXefvtt01ISIj529/+ZrWZM2eOCQ8PN++//77ZsmWLufnmm018fLw5c+aM1ebGG280CQkJJicnx6xdu9b06dPHpKenW+dLS0tNdHS0mThxoikoKDBLly41ISEh5vXXX7farFu3zgQGBpoXX3zR7Nixwzz11FOmTZs2ZuvWrR71pTbuPj0AAACaD3e/v70aqowx5sMPPzQDBw40wcHBpn///uaNN95wOe90Os0TTzxhoqOjTXBwsBkzZowpLCx0aXPs2DGTnp5uOnToYEJDQ83kyZPNiRMnXNps3rzZXHvttSY4ONhcdtllZs6cOZf0ZdmyZaZv374mKCjIXHnllebjjz/2uC+1IVQBAOB73P3+9jPGGO+OlbUeDodDYWFhKisrU2hoqLe7AwAA3ODu97dXn/4DAAC+a3fxSe0rOa24Lu0VH9He293xOkIVAADwSOnpck1fkq81u4qtYyP7RGpeeoLCQtp4sWfe5fUNlQEAgG+ZviRf67456nJs3TdHNW3JV17qUfNAqAIAAG7bXXxSa3YVq+KiJdkVxmjNrmLtOXrKSz3zPo9D1aRJk7RmzZrG6AsAAGjm9pWcrvX83mOEKreVlZUpNTVVffr00fPPP6+DBw82Rr8AAEAz1LNzSK3n47q03gXrHoeq9957TwcPHtR9992nd955R3Fxcbrpppv097//3aViOQAAaHl6RXbQyD6RCvDzczke4OenkX0iW/VTgPVaUxUZGalZs2Zp8+bNysnJUe/evTVx4kR169ZNM2fO1K5du+zuJwAAaCbmpSdoRO8Il2MjekdoXnqCl3rUPDSopMK3336rjIwMZWRkKCAgQD/4wQ+0detWDRgwQHPnztXMmTPt6icAAGgmwkLa6K0pw7Xn6CntPXaqXnWqWmKNK48rqp8/f14ffPCBFi5cqM8//1xXXXWV7r77bv3sZz+zqoy+++67uuuuu3T8+PFG6bSvoqI6AKC188UaV41WUb1r165yOp1KT0/Xhg0bNHjw4EvapKSkKDw83NNLAwCAFq62GldvTRnupV7Zw+NQ9cc//lG33Xab2rZtW2Ob8PBwffHFF3I6nfL3pxQWAKBxtIQppJbwGdxVWePqYlVrXPny38DjUDVx4kS32g0YMED5+fnq1auXx50CAKA2vjiFdLGW8Bk85U6NK18OVY02jOThUi0AANzWErZJaQmfwVMtvcYVc3MAAJ/SErZJaQmfoT5aeo0rQhUAwKe0hG1SWsJnqK+WXOOqQXWqAABoai1hCqklfIb6sqPGVXPVaCNVfhcN7QEAYIeWMIXUEj5DQ8VHtFdKv6gW9VlZqA4A8DktYQqpJXwGuPK4onpZWZkqKirUuXNnl+MlJSUKDAy0Ko0eOHBA3bp1U0BAgH299XFUVAcAe7WEKaSW8BlaOne/vz0eqbr99tu1dOnSS44vW7ZMt99+u/V7bGwsgQoA0KhawhRSS/gM+I7HoSonJ0cpKSmXHB89erRycnJs6RQAAICv8ThUnTt3ThcuXLjk+Pnz53XmzBlbOgUAAOBrPA5Vw4cP1xtvvHHJ8QULFmjo0KG2dAoAADTM7uKTyiw80mILiTZHHtep+t3vfqfU1FRt3rxZY8aMkSStXLlSubm5+vzzz23vIAAAcF9r3FOwufB4pGrEiBHKzs5WbGysli1bpg8//FC9e/fWli1bdN111zVGHwEAgJta456CzUW9KqoPHjxYb7/9tt19AQAADVC5p+DFqu4pyFOGjcfjkapNmzZp69at1u/vv/++xo0bp9/85jcqLy+3tXMAAMB9rXlPwebA41B1zz336Ouvv5Yk7d69W+PHj1dISIiWL1+uhx9+2PYOAgAA97TmPQWbA49D1ddff63BgwdLkpYvX65Ro0Zp8eLFWrRokf7f//t/dvcPAAC4iT0FvcvjUGWMkdPplCT985//1A9+8ANJ31VQP3r0aG0vBQAAjYw9Bb3H44XqiYmJVlmF1atX67XXXpMk7dmzR9HR0bZ3EAAAuC8spI3emjKcPQW9wONQ9dJLL2nChAl677339Pjjj6t3796SpL///e+65pprbO8gAADwXHwEYaqp+RljjB0XOnv2rAICAtSmDYXFauLuLtcAAKD5cPf7u151qiQpLy9PO3bskCQNGDBAQ4YMqe+lAAAAfJ7HoerIkSMaP368Vq9erfDwcElSaWmpUlJStHTpUkVGRtrdRwAAgGbP46f/pk2bppMnT2rbtm0qKSlRSUmJCgoK5HA4NH369MboIwAAQLPn8ZqqsLAw/fOf/9SwYcNcjm/YsEE33HCDSktL7exfi8KaKgAAfI+7398ej1Q5nc5qF6O3adPGql8FAADQ2ngcqq6//no9+OCDOnTokHXs4MGDmjlzpsaMGWNr5wAAAHyFx6Fq/vz5cjgciouL0+WXX67LL79c8fHxcjgcmjdvXmP0EQAAoNnz+Om/2NhYbdq0Sf/85z+1c+dOSdIVV1yh1NRU2zsHAADgKzxeqP7WW29p/PjxCg4OdjleXl6upUuX6o477rC1gy0JC9UBAI1td/FJ7Ss5zfY0NnL3+9vjUBUQEKBvv/1WUVFRLsePHTumqKgoVVRU1K/HrQChCgDQWEpPl2v6knyt2VVsHRvZJ1Lz0hMUFsJuJw3RaE//GWPk5+d3yfF///vfCgsL8/RyAADABtOX5GvdN0ddjq375qimLfnKSz1qfdxeU5WQkCA/Pz/5+flpzJgxCgz8z0srKiq0Z88e3XjjjY3SSQAAULPdxSddRqgqVRijNbuKtefoKaYCm4DboWrcuHGSpPz8fKWlpalDhw7WuaCgIMXFxenWW2+1vYMAAKB2+0pO13p+7zFCVVNwO1Q99dRTqqioUFxcnG644QZ17dq1MfsFAADc1LNzSK3n47oQqJqCR2uqAgICdM899+js2bON1R8AAOChXpEdNLJPpAIuWvMc4OenkX0iGaVqIh4vVB84cKB2797dGH0BAAD1NC89QSN6R7gcG9E7QvPSE7zUo9bH45IKn376qR577DE9++yzGjp0qNq3d02/lAqoGSUVAACNbc/RU9p77BR1qmzUaHWq/P3/M7hVtbRCZakF6lTVjFAFAIDvcff72+NtajIzMxvUMQAAgJbI41A1atSoxugHAACAT/M4VFU6ffq09u/fr/LycpfjV111VYM7BQAA4Gs8DlXFxcWaPHmyVqxYUe151lQBAIDWyOOSCjNmzFBpaalycnLUrl07ffrpp3rzzTfVp08fffDBB43RRwAAgGbP45GqVatW6f3331diYqL8/f3Vs2dPff/731doaKhmz56tsWPHNkY/AQBoNLuLT2pfyWnKEKBBPA5Vp06dUlRUlCSpU6dOKi4uVt++fTVo0CBt2rTJ9g4CANBYSk+Xa/qSfJfNiEf2idS89ASFhbTxYs/gizye/uvXr58KCwslSVdffbVef/11HTx4UAsWLGA/QACAT5m+JF/rvjnqcmzdN0c1bclXXuoRfJnboWrPnj2SpAcffFDffvutpO82WV6xYoV69Oihl19+Wc8//3y9OzJnzhz5+flpxowZ1rGzZ89q6tSp6tKlizp06KBbb71Vhw8fdnnd/v37NXbsWIWEhCgqKkoPPfSQLly44NImKytLQ4YMUXBwsHr37q1FixZd8v6vvPKK4uLi1LZtWyUlJWnDhg0u593pCwDAd+wuPqk1u4pVcVEN7ApjtGZXsfYcPeWlnsFXuR2qLr/8csXHx2vVqlUKCAjQv//9bw0dOlT79u1Tbm6uDhw4oPHjx9erE7m5uXr99dcvKccwc+ZMffjhh1q+fLlWr16tQ4cO6ZZbbrHOV1RUaOzYsSovL9f69ev15ptvatGiRXryySetNnv27NHYsWOVkpKi/Px8zZgxQ3fffbc+++wzq80777yjWbNm6amnntKmTZt09dVXKy0tTUeOHHG7LwAA37Kv5HSt5/ceI1TBM25vU5OVlWX95OTkqLy8XL169dL111+vlJQUpaSkKDo62uMOnDx5UkOGDNGrr76q3/3udxo8eLBeeukllZWVKTIyUosXL9ZPfvITSdLOnTt1xRVXKDs7W9/73ve0YsUK/fCHP9ShQ4es916wYIEeeeQRFRcXKygoSI888og+/vhjFRQUWO95++23q7S0VJ9++qkkKSkpScOGDdP8+fMlSU6nU7GxsZo2bZoeffRRt/pSnXPnzuncuXPW7w6HQ7GxsWxTAwDNwO7ik7r+D6trPJ/569EsWock97epcXukavTo0Xr66aeVlZWl48ePKyMjQ+np6dqxY4fuvPNOdevWTVdeeaXHHZ06darGjh2r1NRUl+N5eXk6f/68y/H+/furR48eys7OliRlZ2dr0KBBLmEuLS1NDodD27Zts9pcfO20tDTrGuXl5crLy3Np4+/vr9TUVKuNO32pzuzZsxUWFmb9xMbGevS3AQA0nl6RHTSyT6QCquxjK0kBfn4a2SeSQAWPebxQXZLatm2r66+/Xr/97W/1zDPPaPr06erQoYN27tzp0XWWLl2qTZs2afbs2ZecKyoqUlBQkMLDw12OR0dHq6ioyGpz8ehY5e91tXE4HDpz5oyOHj2qioqKattUvUZdfanOY489prKyMuvnwIEDNbYFADS9eekJGtE7wuXYiN4Rmpee0Ojvvbv4pDILj7B2qwXxqKRCeXm5vvzyS2VmZlrTgLGxsRo5cqTmz5/v0b6ABw4c0IMPPqiMjAy1bdvW4477guDgYAUHB3u7GwCAGoSFtNFbU4Zrz9FT2nvsVJPUqaKMQ8vldqi6/vrrlZOTo/j4eI0aNUr33HOPFi9eXO8yCnl5eTpy5IiGDBliHauoqNCaNWs0f/58ffbZZyovL1dpaanLCNHhw4cVExMjSYqJibnkKb3KJ/Kqtrn4Kb3Dhw8rNDRU7dq1U0BAgAICAqptU/UadfUFAOC74iOaruhnbWUc3poyvEn6gMbh9vTfF198oS5duuj666/XmDFj9P3vf79BdanGjBmjrVu3Kj8/3/pJTEzUhAkTrP/cpk0brVy50npNYWGh9u/fr+TkZElScnKytm7d6vKUXkZGhkJDQzVgwACrTdVrVLapvEZQUJCGDh3q0sbpdGrlypVWm6FDh9bZFwAA6kIZh5bN7ZGq0tJSffHFF8rKytLvf/97paenq2/fvho1apRGjx6tUaNGKTIy0u037tixowYOHOhyrH379urSpYt1fMqUKZo1a5Y6d+6s0NBQTZs2TcnJydbTdjfccIMGDBigiRMnau7cuSoqKtJvf/tbTZ061Zp2u/feezV//nw9/PDDuuuuu7Rq1SotW7ZMH3/8sfW+s2bN0qRJk5SYmKjhw4frpZde0qlTpzR58mRJUlhYWJ19AQCgLu6UcWCBvO9yO1S1b99eN954o2688UZJ0okTJ7R27VplZmZq7ty5mjBhgvr06eNSuqCh/vjHP8rf31+33nqrzp07p7S0NL366qvW+YCAAH300Ue67777lJycrPbt22vSpEn67//+b6tNfHy8Pv74Y82cOVN/+tOf1L17d/3v//6v0tLSrDbjx49XcXGxnnzySRUVFWnw4MH69NNPXRav19UXAEDLY/eegD07h9R6Pq4LgcqXuV2n6mJOp1O5ubnKzMxUZmam1q5dq7Nnz6qiosLuPrYY7ta5AAA0XEMCUWMuJr/jLxu07pujLlOAAX5+GtE7gjVVzZS7399uhyqn06mNGzcqKytLmZmZWrdunU6dOqXLLrvMKv6ZkpKinj172vYhWhpCFQA0voYGot3FJzV96VfafsghZ5VvSLuCT9np85q25Cue/vMhtoeq0NBQnTp1SjExMVaAGj16tC6//HLbOt3SEaoAoPHVdySoujBWHbsqrTdlGQc0jLvf326vqXrhhReUkpKivn372tJBAADsVvl03cWqPl1XU4CprtRBdexaTN6UZRzQNNwOVffcc09j9gMAgAar79N1NYWx6rCYHDXxqKI6AADNWX2frqsrjEn/mUJkdAk1qdfefwAANEf13SS5U7u6F4g31Z6A8F2EKgBAi1KfTZL/J2NXjecGdgtV5q9H660pw3k6D7Vi+g8A0KJ4uklyXeupnv+vQUz5wS2EKgBAi+Tu03V1rac6drrcri6hhSNUAQBaJHcrqrN1DOxCqAIAtCieVlSvXNxeXcHQhB7h2nvslCQxBYg61XvvP3iOiuoA0PjqU1G9uq1jOoW00fHT563fh8V10qRr4nRltzACVitje0V1AACau/pWVL94cfurmd9o075Slza5e48rd+9xSezV566GbGrtiwhVAIAWo74V1SvFR7SXMcYKTzVZ981RTVvyVYM3V26pGrqpta+iThUAoMWwY9G5O9XVq4584VLV7aNYGURbMkIVAKDZ2F18UpmFR+odVupbUb2quoJZVZWL2PEflVOwFRct2W4NQZTpPwCAreqzjsbO6aJ56QmXLDr3ZIuZmp4GrA7lFi7V0ClYX0aoAgDYoiHBqLbpIk/XLXlaUb061QWzqthcuWatue4X038AAFvUdx1NY00XxUe0V0q/qHoFn2OnzmnytXH6vynD9Up6gob17ORyns2Va2bHFKyvYqQKANBg9S1lIDWv6aKaRtv+d9IwlZwur/fIV2vT0ClYX0WoAgA0WEOCUXOaLqprGpIw5R47pmB9EdN/AIAGa0gwaorpIneeKmzNT601loZMwfoiRqoAAA1W2/557izobqzpIncXz3/Xrva1Xy35qTXYg73/mhB7/wFoyarbP8/Tsgh2Txe5uw/gHX/ZoLW7iuWs5VqZvx5NqGql2PsPANCk7FhHEx/xn9c0dN84dxfP19Sukr+fdG1v12nI1ranHdxDqAIA2KpqMKoPuwqBurt4vq52A7qFWtOQrXVPO7iHheoAgGbFrn3j3F08X1e7eelDrMDUWve0g3sIVQCAZsPOJ/DcfarQ3XY8HYi6EKoAAM2GO1N2nvjduIEKbee60iW0XaCeGzfQ5di89ASN6B3hcuzipw/t7htaHtZUAQCaDbsLgf72vQI5zlxwOeY4c0GPv1fg8vSfO4vsm1ORUjRPjFQBAJqFyifqhvXsZEsh0PpM19VWrLI172kH9zBSBQBosPqWGNhdfFLbDzn05vq9yt133DreKaSNjp8+b/0+pEe4x4VAG2NPQV/e044yEI2PUAUAqLf6lhio7nVVlZ0+r9C2gXKc/W7qLnffcU1b8pVHpQsaY7rOF/e0owxE02H6DwBQb/UtMVDd66pySlagqrRmV7Hu/VueR/0beFmo/F1n62yZrvOlPe0oA9F0GKkCANSLuxXL3X2dO7J3H6vxupXqGgWze7quOU+r1fceoX4IVQCAeqnvmqW6XleXL3cfq3XLmOpGZvz1/1dG/9kQ20KEL0yrNca6MtSMUAUAqJf6rlmq63V1qZzNqy7UJPbspI1VFrxXckoqOOTQgRL71kLVNq1WtVyDN1EGomkRqgAA9VJZYmDtN8VyVqlaEODnpxG9I2oNLQMvC9X2Qw6X17krqVcXSdWHmk3VBKqq7vhrrvWfGzKq5CvTapX3aN03R11KS7hzj9zVnKc/mxoL1QEA9VJ6ulznK5yXBKOkXp2rXbNUerpcd/xlg67/w2oVHKxfoLqia0fFR7TX6sIj1dagcnpwrYYs1q5rWm3a4k0qq1ISwpvcqRZfH1Xv5+SFuUp5MUt3/GVDs/nc3sBIFQCgXu5+c+MlI0P+kgL9/asd/anriT93/PYHA3THXzbUudDd3091hraGjCrVNa22/ZCj2UwDNlYZCF+Y/mxqjFQBADxSerpcty1Yr437jl8yMuSUqq1WXlN1c3f567vputfX7HYrmA3t2cnta9dnz77KabWLyzVUqunv4E12loFgc+nqEaoAAB6ZviRfeXWsXbo4qDT0ib9r+0TqVzf0rTOYVdagWn7vNcr89WgtnDxMb901rNZr13ex9rz0BA3oFlprm5a6yTKbS1ePUAUAcFvlCEVdU2sXB5WGPPH3f1OG660pw1VyurzOtlXXClWOzIzsG9Uoe/aFhbTRy7fXvi6ppT5dx1OF1SNUAQDcVtcIReU03cVBpabNiGtTGXqu6xMpqe4v8srwVd16rsZarN1aN1lurZ+7LoQqAIDb6go2Q3t2qjGoVBdsknt10TWXd6m2/cWhp64v8srwVZ3KxdqVU4KZvx5dYwDzVGMFtuautX7u2vgZU89Vg/CYw+FQWFiYysrKFBpa+zw8ADRXd/xlwyV1j/z9vgtUy++9ps7XV30KzRijfSWnFejvpwtOY/3fyifULq6BVHb6vKYt+apZVjH3pU2W7dQaPre739+EqiZEqALQEtgRbOra4qWu863hi9wdDS28SeFO9xCqmiFCFYCWpCHBprrRrsoq329NGV7n+dauofsO+sK+hc2Ju9/frKkCANSLu3WPdhefVGbhEat2UV01jtZ8XX219MrzX9RR+LM1qK3wZlO8HtWjojoAoFHUNBoyPrF7ra/76kBprecn/mVDqx5Vaei+g76yb6EvYqQKANBgF49GSTWPhixcv7fWayXEhtf5fjWNqlTXj5amoYU3KdzZeBipAgDUW02jUb+6oU+NoyEb9x3XsLhO2rSvtNo1UyP7RimxZydtrKVq+8WjKq1pjVBDC29SuLPxMFIFAKi3mkajHn+voNbXTbomrtYaR5OviXPr/StHVVrTGqGGFt6kcGfjYaQKAFAvta3NKTjoqPW1V3YL01tTutX4BOEVdeypVymuS/tWuUZoXnrCJWUtPCm82dDXo3qEKgBAvdS1Nmdgt1Dt+PZEtVN8lSEnPqL6cgyVoykXl1Wo7jqZhUdq7cfeYy0vVFVWiK9vWYuGvh7VY/oPAFAvda3Nef6/BjVoG5PqtkGp7jqteY2Qu2UtGuv1cMVIFQCgXmoaTaocRboqNtyW0ZTNB47r8XcLVHCo+inFXpEd1CmkjY6fPn/JuU4hbQgMaDKMVAEA6s2dTXUbOhryh893ace3J1yOVV2Evrv4ZLWBSpKOnz7fossroHlhpAoAUG/HTp3T5Gvj9IuR8S4bIVenPvvMubMI3Z26S4xWoSl4daRq9uzZGjZsmDp27KioqCiNGzdOhYWFLm3Onj2rqVOnqkuXLurQoYNuvfVWHT582KXN/v37NXbsWIWEhCgqKkoPPfSQLly44NImKytLQ4YMUXBwsHr37q1FixZd0p9XXnlFcXFxatu2rZKSkrRhwwaP+wIArUHp6XLd8ZcNuv4PqzV5Ya4m/mWDFq7dq84hQXW2TXkxS3f8ZYPKahhdqsqdwNSYa6paQzFR2MeroWr16tWaOnWqvvzyS2VkZOj8+fO64YYbdOrUf/7LO3PmTH344Ydavny5Vq9erUOHDumWW26xzldUVGjs2LEqLy/X+vXr9eabb2rRokV68sknrTZ79uzR2LFjlZKSovz8fM2YMUN33323PvvsM6vNO++8o1mzZumpp57Spk2bdPXVVystLU1Hjhxxuy8A0NLUFCo8qQvVkBpS7gSmxqi71JAgiNbLz5hqnlX1kuLiYkVFRWn16tUaOXKkysrKFBkZqcWLF+snP/mJJGnnzp264oorlJ2dre9973tasWKFfvjDH+rQoUOKjo6WJC1YsECPPPKIiouLFRQUpEceeUQff/yxCgr+U4zu9ttvV2lpqT799FNJUlJSkoYNG6b58+dLkpxOp2JjYzVt2jQ9+uijbvWlLu7ucg0A3lZbhfJjp87p+j+srvG1mb8ebQWZ3cUn3W5bkzv+sqHGxfBvTRkuSSo7ff6SuksNqajuznui9XD3+7tZLVQvKyuTJHXu3FmSlJeXp/Pnzys1NdVq079/f/Xo0UPZ2dmSpOzsbA0aNMgKVJKUlpYmh8Ohbdu2WW2qXqOyTeU1ysvLlZeX59LG399fqampVht3+nKxc+fOyeFwuPwAgC+obXTJk73j7NhnrrrF8EN6huunw7pbI2iVTwpm/nq0Fk4epsxfj9ZbU4bXK1BVruO6uD5W1XVcQHWazUJ1p9OpGTNmaMSIERo4cKAkqaioSEFBQQoPD3dpGx0draKiIqtN1UBVeb7yXG1tHA6Hzpw5o+PHj6uioqLaNjt37nS7LxebPXu2nnnmGTf/AgDQPNS1OPzu6+JrfX3VNUx2rHeqWqhy28Eyvbl+r3L3Hlfu3u/2Bqw6IlVTMVFPsPAd9dVsRqqmTp2qgoICLV261Ntdsc1jjz2msrIy6+fAgQPe7hIA1KmuUFFhjNtrmOxc7xQf0V7LNv5bm/aXuhy3e4+/1lxMFA3TLELVAw88oI8++kiZmZnq3r27dTwmJkbl5eUqLS11aX/48GHFxMRYbS5+Aq/y97rahIaGql27doqIiFBAQEC1bapeo66+XCw4OFihoaEuPwDQ3LkTKtypT1XJk7a1aappuZqCoL+fNCyuE6NUqJFXQ5UxRg888IDeffddrVq1SvHxrkPKQ4cOVZs2bbRy5UrrWGFhofbv36/k5GRJUnJysrZu3erylF5GRoZCQ0M1YMAAq03Va1S2qbxGUFCQhg4d6tLG6XRq5cqVVht3+uItPPILwE7ujC55sobJrvVOdqzPcld1QdBppNy9x3kKEDXy6tN/999/vxYvXqz3339f/fr1s46HhYWpXbt2kqT77rtPn3zyiRYtWqTQ0FBNmzZNkrR+/XpJ35VUGDx4sLp166a5c+eqqKhIEydO1N13363nn39e0nclFQYOHKipU6fqrrvu0qpVqzR9+nR9/PHHSktLk/RdSYVJkybp9ddf1/Dhw/XSSy9p2bJl2rlzp7XWqq6+1MXup/9qezqnPoszAaCS3U/T2cGOJwkrr+NuEdLbXluvvH3H5axyjKcAWx93v7+9Gqr8LvpXUKWFCxfqzjvvlPRdwc1f/epXWrJkic6dO6e0tDS9+uqrLlNu+/bt03333aesrCy1b99ekyZN0pw5cxQY+J91+FlZWZo5c6a2b9+u7t2764knnrDeo9L8+fP1wgsvqKioSIMHD9bLL7+spKQk67w7famN3aGKR34BNLb67tvXWBryv3ue/kPUrhAH3+cToaq1sTNU8f/sAFqjhoygeRrIMguPaPLC3Bqvt3DyMKX0i3I5Vp+teND8ufv93WxKKsAzPPILoDWqWl7BkxE0d/YQvPg6njwFyHIMSM3k6T94jkd+AbRm8RHtldIvyu1/PNZnkbsn5SAashUPWg5ClY9qjL2uAKClqu8/RN0pB0EFdlRi+s+HzUtPuGRtQX1qvwBAS1f5D9Ga1lTV9A9Rd6YbWY6BSoQqH1bftQUA0Bo15B+itW1/w3IMVCJUtQB27HUFAC1dY/1DtL6jYGh5WFMFAGhVPF3k7g67tuKBb2OkCgCABmI5BiRCFQAAtmE5RuvG9B8AAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA0IVAACADQhVAAAANiBUAQAA2IBQBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFDloVdeeUVxcXFq27atkpKStGHDBm93CQBard3FJ5VZeER7jp7ydlcABXq7A77knXfe0axZs7RgwQIlJSXppZdeUlpamgoLCxUVFeXt7gFAq1F6ulzTl+Rrza5i69jIPpGal56gsJA2XuwZWjNGqjzwP//zP/rFL36hyZMna8CAAVqwYIFCQkL017/+1dtdA4BWZfqSfK375qjLsXXfHNW0JV95qUcAocpt5eXlysvLU2pqqnXM399fqampys7OrvY1586dk8PhcPkBADTM7uKTWrOrWBXGuByvMEZrdhUzFQivIVS56ejRo6qoqFB0dLTL8ejoaBUVFVX7mtmzZyssLMz6iY2NbYquAkCLtq/kdK3n9x4jVME7CFWN6LHHHlNZWZn1c+DAAW93CQB8Xs/OIbWej+vSvol6ArhiobqbIiIiFBAQoMOHD7scP3z4sGJiYqp9TXBwsIKDg5uiewDQavSK7KCRfSK17pujLlOAAX5+GtE7QvERhCp4ByNVbgoKCtLQoUO1cuVK65jT6dTKlSuVnJzsxZ4BQOszLz1BI3pHuBwb0TtC89ITvNQjgJEqj8yaNUuTJk1SYmKihg8frpdeekmnTp3S5MmTvd01AGhVwkLa6K0pw7Xn6CntPXZKcV3aM0IFryNUeWD8+PEqLi7Wk08+qaKiIg0ePFiffvrpJYvXAQBNIz6CMIXmw8+Yi55JRaNxOBwKCwtTWVmZQkNDvd0dAADgBne/v1lTBQAAYANCFQAAgA0IVQAAADYgVAEAANiAUAUAAGADQhUAAIANCFUAAAA2IFQBAADYgFAFAABgA7apaUKVxesdDoeXewIAANxV+b1d1yY0hKomdOLECUlSbGysl3sCAAA8deLECYWFhdV4nr3/mpDT6dShQ4fUsWNH+fn52XZdh8Oh2NhYHThwgD0FmzHuk2/gPjV/3CPf0JLukzFGJ06cULdu3eTvX/PKKUaqmpC/v7+6d+/eaNcPDQ31+f/itgbcJ9/AfWr+uEe+oaXcp9pGqCqxUB0AAMAGhCoAAAAbEKpagODgYD311FMKDg72dldQC+6Tb+A+NX/cI9/QGu8TC9UBAABswEgVAACADQhVAAAANiBUAQAA2IBQBQAAYANCVQvwyiuvKC4uTm3btlVSUpI2bNjg7S61WLNnz9awYcPUsWNHRUVFady4cSosLHRpc/bsWU2dOlVdunRRhw4ddOutt+rw4cMubfbv36+xY8cqJCREUVFReuihh3ThwgWXNllZWRoyZIiCg4PVu3dvLVq0qLE/Xos0Z84c+fn5acaMGdYx7lHzcPDgQf385z9Xly5d1K5dOw0aNEgbN260zhtj9OSTT6pr165q166dUlNTtWvXLpdrlJSUaMKECQoNDVV4eLimTJmikydPurTZsmWLrrvuOrVt21axsbGaO3duk3w+X1dRUaEnnnhC8fHxateunS6//HI9++yzLvvfcY8uYuDTli5daoKCgsxf//pXs23bNvOLX/zChIeHm8OHD3u7ay1SWlqaWbhwoSkoKDD5+fnmBz/4genRo4c5efKk1ebee+81sbGxZuXKlWbjxo3me9/7nrnmmmus8xcuXDADBw40qamp5quvvjKffPKJiYiIMI899pjVZvfu3SYkJMTMmjXLbN++3cybN88EBASYTz/9tEk/r6/bsGGDiYuLM1dddZV58MEHrePcI+8rKSkxPXv2NHfeeafJyckxu3fvNp999pn55ptvrDZz5swxYWFh5r333jObN282P/7xj018fLw5c+aM1ebGG280V199tfnyyy/NF198YXr37m3S09Ot82VlZSY6OtpMmDDBFBQUmCVLlph27dqZ119/vUk/ry967rnnTJcuXcxHH31k9uzZY5YvX246dOhg/vSnP1ltuEeuCFU+bvjw4Wbq1KnW7xUVFaZbt25m9uzZXuxV63HkyBEjyaxevdoYY0xpaalp06aNWb58udVmx44dRpLJzs42xhjzySefGH9/f1NUVGS1ee2110xoaKg5d+6cMcaYhx9+2Fx55ZUu7zV+/HiTlpbW2B+pxThx4oTp06ePycjIMKNGjbJCFfeoeXjkkUfMtddeW+N5p9NpYmJizAsvvGAdKy0tNcHBwWbJkiXGGGO2b99uJJnc3FyrzYoVK4yfn585ePCgMcaYV1991XTq1Mm6b5Xv3a9fP7s/UoszduxYc9ddd7kcu+WWW8yECROMMdyj6jD958PKy8uVl5en1NRU65i/v79SU1OVnZ3txZ61HmVlZZKkzp07S5Ly8vJ0/vx5l3vSv39/9ejRw7on2dnZGjRokKKjo602aWlpcjgc2rZtm9Wm6jUq23Bf3Td16lSNHTv2kr8j96h5+OCDD5SYmKjbbrtNUVFRSkhI0J///Gfr/J49e1RUVOTyNw4LC1NSUpLLfQoPD1diYqLVJjU1Vf7+/srJybHajBw5UkFBQVabtLQ0FRYW6vjx4439MX3aNddco5UrV+rrr7+WJG3evFlr167VTTfdJIl7VB02VPZhR48eVUVFhcv/8EtSdHS0du7c6aVetR5Op1MzZszQiBEjNHDgQElSUVGRgoKCFB4e7tI2OjpaRUVFVpvq7lnludraOBwOnTlzRu3atWuMj9RiLF26VJs2bVJubu4l57hHzcPu3bv12muvadasWfrNb36j3NxcTZ8+XUFBQZo0aZL1d67ub1z1HkRFRbmcDwwMVOfOnV3axMfHX3KNynOdOnVqlM/XEjz66KNyOBzq37+/AgICVFFRoeeee04TJkyQJO5RNQhVQD1NnTpVBQUFWrt2rbe7gioOHDigBx98UBkZGWrbtq23u4MaOJ1OJSYm6vnnn5ckJSQkqKCgQAsWLNCkSZO83DtI0rJly/T2229r8eLFuvLKK5Wfn68ZM2aoW7du3KMaMP3nwyIiIhQQEHDJU0uHDx9WTEyMl3rVOjzwwAP66KOPlJmZqe7du1vHY2JiVF5ertLSUpf2Ve9JTExMtfes8lxtbUJDQxkBqUNeXp6OHDmiIUOGKDAwUIGBgVq9erVefvllBQYGKjo6mnvUDHTt2lUDBgxwOXbFFVdo//79kv7zd67tf99iYmJ05MgRl/MXLlxQSUmJR/cS1XvooYf06KOP6vbbb9egQYM0ceJEzZw5U7Nnz5bEPaoOocqHBQUFaejQoVq5cqV1zOl0auXKlUpOTvZiz1ouY4weeOABvfvuu1q1atUlQ9ZDhw5VmzZtXO5JYWGh9u/fb92T5ORkbd261eV/aDIyMhQaGmp9ySQnJ7tco7IN97VuY8aM0datW5Wfn2/9JCYmasKECdZ/5h5534gRIy4pR/L111+rZ8+ekqT4+HjFxMS4/I0dDodycnJc7lNpaany8vKsNqtWrZLT6VRSUpLVZs2aNTp//rzVJiMjQ/369fOpaSVvOH36tPz9XWNCQECAnE6nJO5Rtby9Uh4Ns3TpUhMcHGwWLVpktm/fbn75y1+a8PBwl6eWYJ/77rvPhIWFmaysLPPtt99aP6dPn7ba3HvvvaZHjx5m1apVZuPGjSY5OdkkJydb5ysf17/hhhtMfn6++fTTT01kZGS1j+s/9NBDZseOHeaVV17hcf0GqPr0nzHco+Zgw4YNJjAw0Dz33HNm165d5u233zYhISHmb3/7m9Vmzpw5Jjw83Lz//vtmy5Yt5uabb672cf2EhASTk5Nj1q5da/r06ePyuH5paamJjo42EydONAUFBWbp0qUmJCTEJx/Xb2qTJk0yl112mVVS4R//+IeJiIgwDz/8sNWGe+SKUNUCzJs3z/To0cMEBQWZ4cOHmy+//NLbXWqxJFX7s3DhQqvNmTNnzP333286depkQkJCzH/913+Zb7/91uU6e/fuNTfddJNp166diYiIML/61a/M+fPnXdpkZmaawYMHm6CgINOrVy+X94BnLg5V3KPm4cMPPzQDBw40wcHBpn///uaNN95wOe90Os0TTzxhoqOjTXBwsBkzZowpLCx0aXPs2DGTnp5uOnToYEJDQ83kyZPNiRMnXNps3rzZXHvttSY4ONhcdtllZs6cOY3+2VoCh8NhHnzwQdOjRw/Ttm1b06tXL/P444+7lD7gHrnyM6ZKaVQAAADUC2uqAAAAbECoAgAAsAGhCgAAwAaEKgAAABsQqgAAAGxAqAIAALABoQoAAMAGhCoAAAAbEKoAAABsQKgC4NMWLFigjh076sKFC9axkydPqk2bNho9erRL26ysLPn5+elf//pXvd7r6aef1uDBgxvQWwAtGaEKgE9LSUnRyZMntXHjRuvYF198oZiYGOXk5Ojs2bPW8czMTPXo0UOXX365R+9hjHEJbQBQHUIVAJ/Wr18/de3aVVlZWdaxrKws3XzzzYqPj9eXX37pcjwlJUX/93//p8TERHXs2FExMTH62c9+piNHjri08/Pz04oVKzR06FAFBwfrb3/7m5555hlt3rxZfn5+8vPz06JFiyRJ+/fv180336wOHTooNDRUP/3pT3X48GHreps3b1ZKSoo6duyo0NBQDR061CUErlu3TqNHj1ZISIg6deqktLQ0HT9+vNbPXVxcrJiYGD3//PPWsfXr1ysoKEgrV66s758TQAMQqgD4vJSUFGVmZlq/Z2ZmavTo0Ro1apR1/MyZM8rJyVFKSorOnz+vZ599Vps3b9Z7772nvXv36s4777zkuo8++qjmzJmjHTt26Pvf/75+9atf6corr9S3336rb7/9VuPHj5fT6dTNN9+skpISrV69WhkZGdq9e7fGjx9vXWfChAnq3r27cnNzlZeXp0cffVRt2rSRJOXn52vMmDEaMGCAsrOztXbtWv3oRz9SRUVFrZ85MjJSf/3rX/X0009r48aNOnHihCZOnKgHHnhAY8aMseGvCsBjBgB83J///GfTvn17c/78eeNwOExgYKA5cuSIWbx4sRk5cqQxxpiVK1caSWbfvn2XvD43N9dIMidOnDDGGJOZmWkkmffee8+l3VNPPWWuvvpql2Off/65CQgIMPv377eObdu2zUgyGzZsMMYY07FjR7No0aJq+56enm5GjBhR789+//33m759+5qf/exnZtCgQebs2bP1vhaAhmGkCoDPGz16tE6dOqXc3Fx98cUX6tu3ryIjIzVq1ChrXVVWVpZ69eqlHj16KC8vTz/60Y/Uo0cPdezYUaNGjZL03TReVYmJiXW+944dOxQbG6vY2Fjr2IABAxQeHq4dO3ZIkmbNmqW7775bqampmjNnjstC+cqRqvp68cUXdeHCBS1fvlxvv/22goOD630tAA1DqALg83r37q3u3bsrMzNTmZmZVkjq1q2bYmNjtX79emVmZur666/XqVOnlJaWptDQUL399tvKzc3Vu+++K0kqLy93uW779u1t6d/TTz+tbdu2aezYsVq1apUGDBhgvWe7du0adO1//etfOnTokJxOp/bu3WtDbwHUF6EKQIuQkpKirKwsZWVluZRSGDlypFasWKENGzYoJSVFO3fu1LFjxzRnzhxdd9116t+/v8si9doEBQVdstbpiiuu0IEDB3TgwAHr2Pbt21VaWqoBAwZYx/r27auZM2fq888/1y233KKFCxdKkq666qp6LywvLy/Xz3/+c40fP17PPvus7r77brc/CwD7EaoAtAgpKSlau3at8vPzrZEqSRo1apRef/11lZeXKyUlRT169FBQUJDmzZun3bt364MPPtCzzz7r1nvExcVpz549ys/P19GjR3Xu3DmlpqZq0KBBmjBhgjZt2qQNGzbojjvu0KhRo5SYmKgzZ87ogQceUFZWlvbt26d169YpNzdXV1xxhSTpscceU25uru6//35t2bJFO3fu1GuvvaajR4/W2Z/HH39cZWVlevnll/XII4+ob9++uuuuu+r3BwTQcN5e1AUAdtizZ4+RZPr37+9yfO/evUaS6devn3Vs8eLFJi4uzgQHB5vk5GTzwQcfGEnmq6++Msb8Z6H68ePHXa519uxZc+utt5rw8HAjySxcuNAYY8y+ffvMj3/8Y9O+fXvTsWNHc9ttt5mioiJjjDHnzp0zt99+u4mNjTVBQUGmW7du5oEHHjBnzpyxrpuVlWWuueYaExwcbMLDw01aWtol732xzMxMExgYaL744guXv0FoaKh59dVXPfzrAbCDnzHGeDXVAQAAtABM/wEAANiAUAUAzdD+/fvVoUOHGn8uLv8AwPuY/gOAZujChQu1lkiIi4tTYGBg03UIQJ0IVQAAADZg+g8AAMAGhCoAAAAbEKoAAABsQKgCAACwAaEKAADABoQqAAAAGxCqAAAAbPD/AaDvWhfWA0DKAAAAAElFTkSuQmCC\n"
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "zb1[zb1[\"Rok\"] == 2022][(zb1[\"Wartosc_y\"] == 0) | (zb1[\"Wartosc_x\"] == 0)]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 148
        },
        "id": "6dFEU8AXxcgk",
        "outputId": "7077ebd0-e6f1-46d6-de5c-4876eb2ede89"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-7-e269651adc58>:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
            "  zb1[zb1[\"Rok\"] == 2022][(zb1[\"Wartosc_y\"] == 0) | (zb1[\"Wartosc_x\"] == 0)]\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         Kod   Rok  Wartosc_x  Wartosc_y\n",
              "87   2467000  2022       0.00     180006\n",
              "127  3261000  2022    6054.77          0"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-532a281c-6c10-49dd-b479-d58af9b829ee\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Kod</th>\n",
              "      <th>Rok</th>\n",
              "      <th>Wartosc_x</th>\n",
              "      <th>Wartosc_y</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>87</th>\n",
              "      <td>2467000</td>\n",
              "      <td>2022</td>\n",
              "      <td>0.00</td>\n",
              "      <td>180006</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>3261000</td>\n",
              "      <td>2022</td>\n",
              "      <td>6054.77</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-532a281c-6c10-49dd-b479-d58af9b829ee')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-532a281c-6c10-49dd-b479-d58af9b829ee button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-532a281c-6c10-49dd-b479-d58af9b829ee');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-05500a9e-9694-4221-bd8d-a2562ceba68b\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-05500a9e-9694-4221-bd8d-a2562ceba68b')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-05500a9e-9694-4221-bd8d-a2562ceba68b button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "wyn[wyn[\"Kod\"].isin([2467000, 3261000])]"
      ],
      "metadata": {
        "id": "G8N-mklBxplc",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 175
        },
        "outputId": "8e7528e2-5c9c-43e6-9fa7-1272d6b5546b"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         Kod                       Nazwa Wyszczególnienie   Rok  Wartosc  \\\n",
              "552  2467000  Powiat m. Jastrzębie-Zdrój           ogółem  2021  8987.51   \n",
              "553  2467000  Powiat m. Jastrzębie-Zdrój           ogółem  2022     0.00   \n",
              "754  3261000          Powiat m. Koszalin           ogółem  2021  5496.02   \n",
              "755  3261000          Powiat m. Koszalin           ogółem  2022  6054.77   \n",
              "\n",
              "    Jednostka miary Atrybut  \n",
              "552              zł          \n",
              "553              zł       x  \n",
              "754              zł          \n",
              "755              zł          "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-d35a62c9-a78c-4593-af0a-132ef5a533cd\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Kod</th>\n",
              "      <th>Nazwa</th>\n",
              "      <th>Wyszczególnienie</th>\n",
              "      <th>Rok</th>\n",
              "      <th>Wartosc</th>\n",
              "      <th>Jednostka miary</th>\n",
              "      <th>Atrybut</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>552</th>\n",
              "      <td>2467000</td>\n",
              "      <td>Powiat m. Jastrzębie-Zdrój</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2021</td>\n",
              "      <td>8987.51</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>553</th>\n",
              "      <td>2467000</td>\n",
              "      <td>Powiat m. Jastrzębie-Zdrój</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2022</td>\n",
              "      <td>0.00</td>\n",
              "      <td>zł</td>\n",
              "      <td>x</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>754</th>\n",
              "      <td>3261000</td>\n",
              "      <td>Powiat m. Koszalin</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2021</td>\n",
              "      <td>5496.02</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>755</th>\n",
              "      <td>3261000</td>\n",
              "      <td>Powiat m. Koszalin</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2022</td>\n",
              "      <td>6054.77</td>\n",
              "      <td>zł</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d35a62c9-a78c-4593-af0a-132ef5a533cd')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-d35a62c9-a78c-4593-af0a-132ef5a533cd button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-d35a62c9-a78c-4593-af0a-132ef5a533cd');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-e00400e7-4e32-4f7d-8035-c7f04945cbaa\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e00400e7-4e32-4f7d-8035-c7f04945cbaa')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-e00400e7-4e32-4f7d-8035-c7f04945cbaa button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Zapoznajemy się z opcjami read_excel"
      ],
      "metadata": {
        "id": "kSoyExU70E_9"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "wyn2 = pd.read_excel(\"/content/wynag-powiaty.xlsx\",\n",
        "                     sheet_name = 1,\n",
        "                     names = [\"kod\", \"pow\", \"typ\", \"rok\", \"wyn\", \"jedn\", \"atr\"],\n",
        "                     dtype = {\"kod\": str, \"wyn\": np.float64},\n",
        "                     usecols = \"A:E\",\n",
        "                     na_values= \"0\")\n",
        "wyn2[wyn2[\"kod\"] == \"2467000\"]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 112
        },
        "id": "OuFjX2H50J_U",
        "outputId": "025d9b66-b8b6-440b-f57e-5445cd4c36b1"
      },
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         kod                         pow     typ   rok      wyn\n",
              "552  2467000  Powiat m. Jastrzębie-Zdrój  ogółem  2021  8987.51\n",
              "553  2467000  Powiat m. Jastrzębie-Zdrój  ogółem  2022      NaN"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a5a2c1cd-7401-4579-a52d-2afb66befd20\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>kod</th>\n",
              "      <th>pow</th>\n",
              "      <th>typ</th>\n",
              "      <th>rok</th>\n",
              "      <th>wyn</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>552</th>\n",
              "      <td>2467000</td>\n",
              "      <td>Powiat m. Jastrzębie-Zdrój</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2021</td>\n",
              "      <td>8987.51</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>553</th>\n",
              "      <td>2467000</td>\n",
              "      <td>Powiat m. Jastrzębie-Zdrój</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2022</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a5a2c1cd-7401-4579-a52d-2afb66befd20')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-a5a2c1cd-7401-4579-a52d-2afb66befd20 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-a5a2c1cd-7401-4579-a52d-2afb66befd20');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-061c1b30-85cf-40b2-b6eb-300c7f9ce55c\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-061c1b30-85cf-40b2-b6eb-300c7f9ce55c')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-061c1b30-85cf-40b2-b6eb-300c7f9ce55c button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "nie2 = pd.read_excel(\"/content/nieruch-powiaty.xlsx\",\n",
        "                     sheet_name = 1,\n",
        "                     names = [\"kod\", \"pow\", \"typ\", \"ogolem\", \"rok\", \"wyn\", \"jedn\", \"atr\"],\n",
        "                     dtype = {\"kod\": str, \"wyn\": np.float64},\n",
        "                     usecols = \"A:F\",\n",
        "                     na_values= [0, 0.0])\n",
        "\n",
        "nie2[nie2[\"wyn\"] == 0] ## nie dziala"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 112
        },
        "id": "48XL0kfmr1QC",
        "outputId": "9710aab2-057b-44dc-8905-ae7e6880e1b7"
      },
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         kod                 pow           typ  ogolem   rok  wyn\n",
              "126  3261000  Powiat m. Koszalin  rynek wtórny  ogółem  2021  0.0\n",
              "127  3261000  Powiat m. Koszalin  rynek wtórny  ogółem  2022  0.0"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f7b018ed-7a4f-4276-a517-a2c337ab89b9\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>kod</th>\n",
              "      <th>pow</th>\n",
              "      <th>typ</th>\n",
              "      <th>ogolem</th>\n",
              "      <th>rok</th>\n",
              "      <th>wyn</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>3261000</td>\n",
              "      <td>Powiat m. Koszalin</td>\n",
              "      <td>rynek wtórny</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2021</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>3261000</td>\n",
              "      <td>Powiat m. Koszalin</td>\n",
              "      <td>rynek wtórny</td>\n",
              "      <td>ogółem</td>\n",
              "      <td>2022</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f7b018ed-7a4f-4276-a517-a2c337ab89b9')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-f7b018ed-7a4f-4276-a517-a2c337ab89b9 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-f7b018ed-7a4f-4276-a517-a2c337ab89b9');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-488e568a-1078-470f-a285-a93b692c7fd7\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-488e568a-1078-470f-a285-a93b692c7fd7')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-488e568a-1078-470f-a285-a93b692c7fd7 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 40
        }
      ]
    }
  ]
}