House Price Index.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "toc": true
   },
   "source": [
    "<h1>Table of Contents<span class=\"tocSkip\"></span></h1>\n",
    "<div class=\"toc\"><ul class=\"toc-item\"></ul></div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas_datareader as pdr\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": true
   },
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>UNIT</th>\n",
       "      <th colspan=\"10\" halign=\"left\">Quarterly index</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">Quarterly rate of change</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GEO</th>\n",
       "      <th>Austria</th>\n",
       "      <th>Belgium</th>\n",
       "      <th>Bulgaria</th>\n",
       "      <th>Cyprus</th>\n",
       "      <th>Czechia</th>\n",
       "      <th>Germany (until 1990 former territory of the FRG)</th>\n",
       "      <th>Denmark</th>\n",
       "      <th>Estonia</th>\n",
       "      <th>Greece</th>\n",
       "      <th>Spain</th>\n",
       "      <th>...</th>\n",
       "      <th>Latvia</th>\n",
       "      <th>Malta</th>\n",
       "      <th>Netherlands</th>\n",
       "      <th>Poland</th>\n",
       "      <th>Portugal</th>\n",
       "      <th>Romania</th>\n",
       "      <th>Sweden</th>\n",
       "      <th>Slovenia</th>\n",
       "      <th>Slovakia</th>\n",
       "      <th>United Kingdom</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FREQ</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>...</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "      <th>Quarterly</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIME_PERIOD</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",
       "      <td>2005-01-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69.68</td>\n",
       "      <td>76.01</td>\n",
       "      <td>93.41</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.2</td>\n",
       "      <td>75.49</td>\n",
       "      <td>50.59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2005-04-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>71.24</td>\n",
       "      <td>79.26</td>\n",
       "      <td>95.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.7</td>\n",
       "      <td>79.46</td>\n",
       "      <td>57.07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>-0.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2005-07-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>73.78</td>\n",
       "      <td>81.55</td>\n",
       "      <td>98.79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.4</td>\n",
       "      <td>85.56</td>\n",
       "      <td>60.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2005-10-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>75.24</td>\n",
       "      <td>83.52</td>\n",
       "      <td>100.64</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.0</td>\n",
       "      <td>91.19</td>\n",
       "      <td>68.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>123.7</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-2.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>5.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2006-01-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>76.70</td>\n",
       "      <td>87.47</td>\n",
       "      <td>103.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>83.2</td>\n",
       "      <td>97.68</td>\n",
       "      <td>77.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>128.3</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 84 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "UNIT        Quarterly index                                          \\\n",
       "GEO                 Austria   Belgium  Bulgaria    Cyprus   Czechia   \n",
       "FREQ              Quarterly Quarterly Quarterly Quarterly Quarterly   \n",
       "TIME_PERIOD                                                           \n",
       "2005-01-01              NaN     69.68     76.01     93.41       NaN   \n",
       "2005-04-01              NaN     71.24     79.26     95.38       NaN   \n",
       "2005-07-01              NaN     73.78     81.55     98.79       NaN   \n",
       "2005-10-01              NaN     75.24     83.52    100.64       NaN   \n",
       "2006-01-01              NaN     76.70     87.47    103.04       NaN   \n",
       "\n",
       "UNIT                                                                    \\\n",
       "GEO         Germany (until 1990 former territory of the FRG)   Denmark   \n",
       "FREQ                                               Quarterly Quarterly   \n",
       "TIME_PERIOD                                                              \n",
       "2005-01-01                                              84.2     75.49   \n",
       "2005-04-01                                              82.7     79.46   \n",
       "2005-07-01                                              84.4     85.56   \n",
       "2005-10-01                                              82.0     91.19   \n",
       "2006-01-01                                              83.2     97.68   \n",
       "\n",
       "UNIT                                       ... Quarterly rate of change  \\\n",
       "GEO           Estonia    Greece     Spain  ...                   Latvia   \n",
       "FREQ        Quarterly Quarterly Quarterly  ...                Quarterly   \n",
       "TIME_PERIOD                                ...                            \n",
       "2005-01-01      50.59       NaN       NaN  ...                      NaN   \n",
       "2005-04-01      57.07       NaN       NaN  ...                      NaN   \n",
       "2005-07-01      60.25       NaN       NaN  ...                      NaN   \n",
       "2005-10-01      68.14       NaN     123.7  ...                      NaN   \n",
       "2006-01-01      77.03       NaN     128.3  ...                      NaN   \n",
       "\n",
       "UNIT                                                                       \\\n",
       "GEO             Malta Netherlands    Poland  Portugal   Romania    Sweden   \n",
       "FREQ        Quarterly   Quarterly Quarterly Quarterly Quarterly Quarterly   \n",
       "TIME_PERIOD                                                                 \n",
       "2005-01-01        NaN         NaN       NaN       NaN       NaN       NaN   \n",
       "2005-04-01       -0.3         1.1      -0.9       NaN       NaN       3.3   \n",
       "2005-07-01        8.3         1.3       0.0       NaN       NaN       3.9   \n",
       "2005-10-01       -2.8         0.5       5.9       NaN       NaN       2.6   \n",
       "2006-01-01        4.9         1.1       4.3       NaN       NaN       3.5   \n",
       "\n",
       "UNIT                                            \n",
       "GEO          Slovenia  Slovakia United Kingdom  \n",
       "FREQ        Quarterly Quarterly      Quarterly  \n",
       "TIME_PERIOD                                     \n",
       "2005-01-01        NaN       NaN            NaN  \n",
       "2005-04-01        NaN       NaN            2.9  \n",
       "2005-07-01        NaN       NaN            2.4  \n",
       "2005-10-01        NaN       NaN            0.2  \n",
       "2006-01-01        NaN       NaN            0.6  \n",
       "\n",
       "[5 rows x 84 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "start = dt.datetime(2005, 1, 1)\n",
    "end = dt.datetime(2020, 5, 28)\n",
    "df = pdr.data.DataReader('tipsho40', 'eurostat', start, end)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('Quarterly index', 'Austria', 'Quarterly'),\n",
       " ('Quarterly index', 'Belgium', 'Quarterly'),\n",
       " ('Quarterly index', 'Bulgaria', 'Quarterly'),\n",
       " ('Quarterly index', 'Cyprus', 'Quarterly'),\n",
       " ('Quarterly index', 'Czechia', 'Quarterly'),\n",
       " ('Quarterly index',\n",
       "  'Germany (until 1990 former territory of the FRG)',\n",
       "  'Quarterly'),\n",
       " ('Quarterly index', 'Denmark', 'Quarterly'),\n",
       " ('Quarterly index', 'Estonia', 'Quarterly'),\n",
       " ('Quarterly index', 'Greece', 'Quarterly'),\n",
       " ('Quarterly index', 'Spain', 'Quarterly'),\n",
       " ('Quarterly index', 'Finland', 'Quarterly'),\n",
       " ('Quarterly index', 'France', 'Quarterly'),\n",
       " ('Quarterly index', 'Croatia', 'Quarterly'),\n",
       " ('Quarterly index', 'Hungary', 'Quarterly'),\n",
       " ('Quarterly index', 'Ireland', 'Quarterly'),\n",
       " ('Quarterly index', 'Italy', 'Quarterly'),\n",
       " ('Quarterly index', 'Lithuania', 'Quarterly'),\n",
       " ('Quarterly index', 'Luxembourg', 'Quarterly'),\n",
       " ('Quarterly index', 'Latvia', 'Quarterly'),\n",
       " ('Quarterly index', 'Malta', 'Quarterly'),\n",
       " ('Quarterly index', 'Netherlands', 'Quarterly'),\n",
       " ('Quarterly index', 'Poland', 'Quarterly'),\n",
       " ('Quarterly index', 'Portugal', 'Quarterly'),\n",
       " ('Quarterly index', 'Romania', 'Quarterly'),\n",
       " ('Quarterly index', 'Sweden', 'Quarterly'),\n",
       " ('Quarterly index', 'Slovenia', 'Quarterly'),\n",
       " ('Quarterly index', 'Slovakia', 'Quarterly'),\n",
       " ('Quarterly index', 'United Kingdom', 'Quarterly'),\n",
       " ('Annual rate of change', 'Austria', 'Quarterly'),\n",
       " ('Annual rate of change', 'Belgium', 'Quarterly'),\n",
       " ('Annual rate of change', 'Bulgaria', 'Quarterly'),\n",
       " ('Annual rate of change', 'Cyprus', 'Quarterly'),\n",
       " ('Annual rate of change', 'Czechia', 'Quarterly'),\n",
       " ('Annual rate of change',\n",
       "  'Germany (until 1990 former territory of the FRG)',\n",
       "  'Quarterly'),\n",
       " ('Annual rate of change', 'Denmark', 'Quarterly'),\n",
       " ('Annual rate of change', 'Estonia', 'Quarterly'),\n",
       " ('Annual rate of change', 'Greece', 'Quarterly'),\n",
       " ('Annual rate of change', 'Spain', 'Quarterly'),\n",
       " ('Annual rate of change', 'Finland', 'Quarterly'),\n",
       " ('Annual rate of change', 'France', 'Quarterly'),\n",
       " ('Annual rate of change', 'Croatia', 'Quarterly'),\n",
       " ('Annual rate of change', 'Hungary', 'Quarterly'),\n",
       " ('Annual rate of change', 'Ireland', 'Quarterly'),\n",
       " ('Annual rate of change', 'Italy', 'Quarterly'),\n",
       " ('Annual rate of change', 'Lithuania', 'Quarterly'),\n",
       " ('Annual rate of change', 'Luxembourg', 'Quarterly'),\n",
       " ('Annual rate of change', 'Latvia', 'Quarterly'),\n",
       " ('Annual rate of change', 'Malta', 'Quarterly'),\n",
       " ('Annual rate of change', 'Netherlands', 'Quarterly'),\n",
       " ('Annual rate of change', 'Poland', 'Quarterly'),\n",
       " ('Annual rate of change', 'Portugal', 'Quarterly'),\n",
       " ('Annual rate of change', 'Romania', 'Quarterly'),\n",
       " ('Annual rate of change', 'Sweden', 'Quarterly'),\n",
       " ('Annual rate of change', 'Slovenia', 'Quarterly'),\n",
       " ('Annual rate of change', 'Slovakia', 'Quarterly'),\n",
       " ('Annual rate of change', 'United Kingdom', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Austria', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Belgium', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Bulgaria', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Cyprus', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Czechia', 'Quarterly'),\n",
       " ('Quarterly rate of change',\n",
       "  'Germany (until 1990 former territory of the FRG)',\n",
       "  'Quarterly'),\n",
       " ('Quarterly rate of change', 'Denmark', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Estonia', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Greece', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Spain', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Finland', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'France', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Croatia', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Hungary', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Ireland', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Italy', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Lithuania', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Luxembourg', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Latvia', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Malta', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Netherlands', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Poland', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Portugal', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Romania', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Sweden', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Slovenia', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'Slovakia', 'Quarterly'),\n",
       " ('Quarterly rate of change', 'United Kingdom', 'Quarterly')]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MultiIndex([(         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (         'Quarterly index', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            (   'Annual rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...),\n",
       "            ('Quarterly rate of change', ...)],\n",
       "           names=['UNIT', 'GEO', 'FREQ'])"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MultiIndex([(1,  'red'),\n",
       "            (1, 'blue'),\n",
       "            (2,  'red'),\n",
       "            (2, 'blue')],\n",
       "           names=['number', 'color'])"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "arrays = [[1, 1, 2, 2], ['red', 'blue', 'red', 'blue']]\n",
    "pd.MultiIndex.from_arrays(arrays, names=('number', 'color'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.4"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": true,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}