Demographics_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pandas import read_excel"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# GUS data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Data 2018 source:** [Central Statistical Office in Poland, *Ludność. Stan i struktura oraz ruch naturalny w przekroju terytorialnym w 2018 r. Stan w dniu 31 XII*](https://stat.gov.pl/obszary-tematyczne/ludnosc/ludnosc/ludnosc-stan-i-struktura-oraz-ruch-naturalny-w-przekroju-terytorialnym-w-2018-r-stan-w-dniu-31-xii,6,25.html)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "gus_2018_all = read_excel(\n",
    "    \"data/03_ludnosć_struktura wg wieku_RD'2019.xls\",\n",
    "    sheet_name=\"Tablica 15 \", index_col=0\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>WIEK                       \\nAGE</th>\n",
       "      <td>Ogółem   Total</td>\n",
       "      <td>Mężczyźni   Males</td>\n",
       "      <td>Kobiety  Females</td>\n",
       "      <td>Miasta   Urban areas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wieś   Rural areas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>razem  total</td>\n",
       "      <td>mężczyźni  males</td>\n",
       "      <td>kobiety females</td>\n",
       "      <td>razem  total</td>\n",
       "      <td>mężczyźni  males</td>\n",
       "      <td>kobiety females</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      Unnamed: 1         Unnamed: 2  \\\n",
       "WIEK                       \\nAGE  Ogółem   Total  Mężczyźni   Males   \n",
       "NaN                                          NaN                NaN   \n",
       "\n",
       "                                        Unnamed: 3            Unnamed: 4  \\\n",
       "WIEK                       \\nAGE  Kobiety  Females  Miasta   Urban areas   \n",
       "NaN                                            NaN          razem  total   \n",
       "\n",
       "                                        Unnamed: 5       Unnamed: 6  \\\n",
       "WIEK                       \\nAGE               NaN              NaN   \n",
       "NaN                               mężczyźni  males  kobiety females   \n",
       "\n",
       "                                          Unnamed: 7        Unnamed: 8  \\\n",
       "WIEK                       \\nAGE  Wieś   Rural areas               NaN   \n",
       "NaN                                     razem  total  mężczyźni  males   \n",
       "\n",
       "                                       Unnamed: 9  \n",
       "WIEK                       \\nAGE              NaN  \n",
       "NaN                               kobiety females  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gus_2018_all.iloc[[5, 6]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "gus_2018 = gus_2018_all.loc[range(16, 22)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>total</th>\n",
       "      <th>males</th>\n",
       "      <th>females</th>\n",
       "      <th>city_total</th>\n",
       "      <th>city_males</th>\n",
       "      <th>city_females</th>\n",
       "      <th>rural_total</th>\n",
       "      <th>rural_male</th>\n",
       "      <th>rural_female</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16</td>\n",
       "      <td>353738</td>\n",
       "      <td>181515</td>\n",
       "      <td>172223</td>\n",
       "      <td>195234</td>\n",
       "      <td>99504</td>\n",
       "      <td>95730</td>\n",
       "      <td>158504</td>\n",
       "      <td>82011</td>\n",
       "      <td>76493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17</td>\n",
       "      <td>366102</td>\n",
       "      <td>187690</td>\n",
       "      <td>178412</td>\n",
       "      <td>201651</td>\n",
       "      <td>102767</td>\n",
       "      <td>98884</td>\n",
       "      <td>164451</td>\n",
       "      <td>84923</td>\n",
       "      <td>79528</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   age   total   males females city_total city_males city_females rural_total  \\\n",
       "0   16  353738  181515  172223     195234      99504        95730      158504   \n",
       "1   17  366102  187690  178412     201651     102767        98884      164451   \n",
       "\n",
       "  rural_male rural_female  \n",
       "0      82011        76493  \n",
       "1      84923        79528  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gus_2018 = gus_2018.reset_index()\n",
    "gus_2018.columns = (\n",
    "    'age total males females city_total city_males '\n",
    "    'city_females rural_total rural_male rural_female'\n",
    ").split()\n",
    "gus_2018.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "gus_2018.to_csv('data/gus_2018_cleaned.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# ZHP"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Data zliczenia</th>\n",
       "      <th>Jednostka</th>\n",
       "      <th>l. ogółem</th>\n",
       "      <th>l. og. K</th>\n",
       "      <th>l. og. M</th>\n",
       "      <th>l. NS K</th>\n",
       "      <th>l. NS M</th>\n",
       "      <th>brak</th>\n",
       "      <th>Obiet. K</th>\n",
       "      <th>Obiet. M</th>\n",
       "      <th>...</th>\n",
       "      <th>HS K</th>\n",
       "      <th>HS M</th>\n",
       "      <th>Wędr K</th>\n",
       "      <th>Wędr M</th>\n",
       "      <th>Wędr/Inst K</th>\n",
       "      <th>Wędr/Inst M</th>\n",
       "      <th>Inst K</th>\n",
       "      <th>Inst M</th>\n",
       "      <th>Sen/Inst K</th>\n",
       "      <th>Sen/Inst M</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kod</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1080000000000</th>\n",
       "      <td>2018-01-01</td>\n",
       "      <td>CHORĄGIEW ZIEMI LUBUSKIEJ</td>\n",
       "      <td>2819</td>\n",
       "      <td>1625</td>\n",
       "      <td>1194</td>\n",
       "      <td>158</td>\n",
       "      <td>149</td>\n",
       "      <td>1973</td>\n",
       "      <td>140</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>245</td>\n",
       "      <td>179</td>\n",
       "      <td>127</td>\n",
       "      <td>82</td>\n",
       "      <td>155</td>\n",
       "      <td>139</td>\n",
       "      <td>274</td>\n",
       "      <td>241</td>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Razem:</th>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102886</td>\n",
       "      <td>61541</td>\n",
       "      <td>41345</td>\n",
       "      <td>1854</td>\n",
       "      <td>2086</td>\n",
       "      <td>73570</td>\n",
       "      <td>5079</td>\n",
       "      <td>3264</td>\n",
       "      <td>...</td>\n",
       "      <td>11679</td>\n",
       "      <td>7132</td>\n",
       "      <td>5626</td>\n",
       "      <td>3611</td>\n",
       "      <td>5798</td>\n",
       "      <td>4263</td>\n",
       "      <td>7309</td>\n",
       "      <td>5890</td>\n",
       "      <td>2425</td>\n",
       "      <td>1923</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Data zliczenia                  Jednostka  l. ogółem  l. og. K  \\\n",
       "Kod                                                                            \n",
       "1080000000000     2018-01-01  CHORĄGIEW ZIEMI LUBUSKIEJ       2819      1625   \n",
       "Razem:                   NaT                        NaN     102886     61541   \n",
       "\n",
       "               l. og. M  l. NS K  l. NS M   brak  Obiet. K  Obiet. M  ...  \\\n",
       "Kod                                                                   ...   \n",
       "1080000000000      1194      158      149   1973       140       100  ...   \n",
       "Razem:            41345     1854     2086  73570      5079      3264  ...   \n",
       "\n",
       "                HS K  HS M  Wędr K  Wędr M  Wędr/Inst K  Wędr/Inst M  Inst K  \\\n",
       "Kod                                                                            \n",
       "1080000000000    245   179     127      82          155          139     274   \n",
       "Razem:         11679  7132    5626    3611         5798         4263    7309   \n",
       "\n",
       "               Inst M  Sen/Inst K  Sen/Inst M  \n",
       "Kod                                            \n",
       "1080000000000     241          90          77  \n",
       "Razem:           5890        2425        1923  \n",
       "\n",
       "[2 rows x 36 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zhp_in_numbers = read_excel(\n",
    "    \"data/ZHP_zestawienie_2018.xlsx\",\n",
    "    sheet_name=\"zestawienie_2018-1\", index_col=2\n",
    ")\n",
    "zhp_in_numbers.tail(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Kod</th>\n",
       "      <th>1000000000000</th>\n",
       "      <th>1200000000000</th>\n",
       "      <th>1020000000000</th>\n",
       "      <th>1220000000000</th>\n",
       "      <th>1260000000000</th>\n",
       "      <th>1120000000000</th>\n",
       "      <th>1040000000000</th>\n",
       "      <th>1060000000000</th>\n",
       "      <th>1100000000000</th>\n",
       "      <th>1140000000000</th>\n",
       "      <th>1160000000000</th>\n",
       "      <th>1180000000000</th>\n",
       "      <th>1340000000000</th>\n",
       "      <th>1240000000000</th>\n",
       "      <th>1280000000000</th>\n",
       "      <th>1300000000000</th>\n",
       "      <th>1320000000000</th>\n",
       "      <th>1080000000000</th>\n",
       "      <th>Razem:</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Data zliczenia</th>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jednostka</th>\n",
       "      <td>GŁÓWNA KWATERA ZHP</td>\n",
       "      <td>CHORĄGIEW BIAŁOSTOCKA</td>\n",
       "      <td>CHORĄGIEW DOLNOŚLĄSKA</td>\n",
       "      <td>CHORĄGIEW GDAŃSKA</td>\n",
       "      <td>CHORĄGIEW KIELECKA</td>\n",
       "      <td>CHORĄGIEW KRAKOWSKA</td>\n",
       "      <td>CHORĄGIEW KUJAWSKO-POMORSKA</td>\n",
       "      <td>CHORĄGIEW LUBELSKA</td>\n",
       "      <td>CHORĄGIEW ŁÓDZKA</td>\n",
       "      <td>CHORĄGIEW MAZOWIECKA</td>\n",
       "      <td>CHORĄGIEW OPOLSKA</td>\n",
       "      <td>CHORĄGIEW PODKARPACKA</td>\n",
       "      <td>CHORĄGIEW STOŁECZNA</td>\n",
       "      <td>CHORĄGIEW ŚLĄSKA</td>\n",
       "      <td>CHORĄGIEW WARMIŃSKO-MAZURSKA</td>\n",
       "      <td>CHORĄGIEW WIELKOPOLSKA</td>\n",
       "      <td>CHORĄGIEW ZACHODNIOPOMORSKA</td>\n",
       "      <td>CHORĄGIEW ZIEMI LUBUSKIEJ</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>l. ogółem</th>\n",
       "      <td>42</td>\n",
       "      <td>4815</td>\n",
       "      <td>5911</td>\n",
       "      <td>6214</td>\n",
       "      <td>3703</td>\n",
       "      <td>7678</td>\n",
       "      <td>6009</td>\n",
       "      <td>1650</td>\n",
       "      <td>8844</td>\n",
       "      <td>5841</td>\n",
       "      <td>1633</td>\n",
       "      <td>4726</td>\n",
       "      <td>11726</td>\n",
       "      <td>12463</td>\n",
       "      <td>3821</td>\n",
       "      <td>11650</td>\n",
       "      <td>3341</td>\n",
       "      <td>2819</td>\n",
       "      <td>102886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>l. og. K</th>\n",
       "      <td>25</td>\n",
       "      <td>3085</td>\n",
       "      <td>3398</td>\n",
       "      <td>3664</td>\n",
       "      <td>2271</td>\n",
       "      <td>4602</td>\n",
       "      <td>3636</td>\n",
       "      <td>1069</td>\n",
       "      <td>5262</td>\n",
       "      <td>3551</td>\n",
       "      <td>964</td>\n",
       "      <td>2931</td>\n",
       "      <td>6716</td>\n",
       "      <td>7323</td>\n",
       "      <td>2420</td>\n",
       "      <td>7023</td>\n",
       "      <td>1976</td>\n",
       "      <td>1625</td>\n",
       "      <td>61541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>l. og. M</th>\n",
       "      <td>17</td>\n",
       "      <td>1730</td>\n",
       "      <td>2513</td>\n",
       "      <td>2550</td>\n",
       "      <td>1432</td>\n",
       "      <td>3076</td>\n",
       "      <td>2373</td>\n",
       "      <td>581</td>\n",
       "      <td>3582</td>\n",
       "      <td>2290</td>\n",
       "      <td>669</td>\n",
       "      <td>1795</td>\n",
       "      <td>5010</td>\n",
       "      <td>5140</td>\n",
       "      <td>1401</td>\n",
       "      <td>4627</td>\n",
       "      <td>1365</td>\n",
       "      <td>1194</td>\n",
       "      <td>41345</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Kod                   1000000000000          1200000000000  \\\n",
       "Data zliczenia  2018-01-01 00:00:00    2018-01-01 00:00:00   \n",
       "Jednostka        GŁÓWNA KWATERA ZHP  CHORĄGIEW BIAŁOSTOCKA   \n",
       "l. ogółem                        42                   4815   \n",
       "l. og. K                         25                   3085   \n",
       "l. og. M                         17                   1730   \n",
       "\n",
       "Kod                     1020000000000        1220000000000  \\\n",
       "Data zliczenia    2018-01-01 00:00:00  2018-01-01 00:00:00   \n",
       "Jednostka       CHORĄGIEW DOLNOŚLĄSKA    CHORĄGIEW GDAŃSKA   \n",
       "l. ogółem                        5911                 6214   \n",
       "l. og. K                         3398                 3664   \n",
       "l. og. M                         2513                 2550   \n",
       "\n",
       "Kod                   1260000000000        1120000000000  \\\n",
       "Data zliczenia  2018-01-01 00:00:00  2018-01-01 00:00:00   \n",
       "Jednostka        CHORĄGIEW KIELECKA  CHORĄGIEW KRAKOWSKA   \n",
       "l. ogółem                      3703                 7678   \n",
       "l. og. K                       2271                 4602   \n",
       "l. og. M                       1432                 3076   \n",
       "\n",
       "Kod                           1040000000000        1060000000000  \\\n",
       "Data zliczenia          2018-01-01 00:00:00  2018-01-01 00:00:00   \n",
       "Jednostka       CHORĄGIEW KUJAWSKO-POMORSKA   CHORĄGIEW LUBELSKA   \n",
       "l. ogółem                              6009                 1650   \n",
       "l. og. K                               3636                 1069   \n",
       "l. og. M                               2373                  581   \n",
       "\n",
       "Kod                   1100000000000         1140000000000  \\\n",
       "Data zliczenia  2018-01-01 00:00:00   2018-01-01 00:00:00   \n",
       "Jednostka          CHORĄGIEW ŁÓDZKA  CHORĄGIEW MAZOWIECKA   \n",
       "l. ogółem                      8844                  5841   \n",
       "l. og. K                       5262                  3551   \n",
       "l. og. M                       3582                  2290   \n",
       "\n",
       "Kod                   1160000000000          1180000000000  \\\n",
       "Data zliczenia  2018-01-01 00:00:00    2018-01-01 00:00:00   \n",
       "Jednostka         CHORĄGIEW OPOLSKA  CHORĄGIEW PODKARPACKA   \n",
       "l. ogółem                      1633                   4726   \n",
       "l. og. K                        964                   2931   \n",
       "l. og. M                        669                   1795   \n",
       "\n",
       "Kod                   1340000000000        1240000000000  \\\n",
       "Data zliczenia  2018-01-01 00:00:00  2018-01-01 00:00:00   \n",
       "Jednostka       CHORĄGIEW STOŁECZNA     CHORĄGIEW ŚLĄSKA   \n",
       "l. ogółem                     11726                12463   \n",
       "l. og. K                       6716                 7323   \n",
       "l. og. M                       5010                 5140   \n",
       "\n",
       "Kod                            1280000000000           1300000000000  \\\n",
       "Data zliczenia           2018-01-01 00:00:00     2018-01-01 00:00:00   \n",
       "Jednostka       CHORĄGIEW WARMIŃSKO-MAZURSKA  CHORĄGIEW WIELKOPOLSKA   \n",
       "l. ogółem                               3821                   11650   \n",
       "l. og. K                                2420                    7023   \n",
       "l. og. M                                1401                    4627   \n",
       "\n",
       "Kod                           1320000000000              1080000000000  Razem:  \n",
       "Data zliczenia          2018-01-01 00:00:00        2018-01-01 00:00:00     NaT  \n",
       "Jednostka       CHORĄGIEW ZACHODNIOPOMORSKA  CHORĄGIEW ZIEMI LUBUSKIEJ     NaN  \n",
       "l. ogółem                              3341                       2819  102886  \n",
       "l. og. K                               1976                       1625   61541  \n",
       "l. og. M                               1365                       1194   41345  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zhp_in_numbers.T.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "zhp_in_numbers.T.to_csv('data/zhp_2018_cleaned.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}