Ireland-ESS.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e683ab09",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ddc43737",
   "metadata": {},
   "outputs": [],
   "source": [
    "ireland_2018 = pd.read_spss('./ireland-data/ESS9IE.sav')\n",
    "ireland_2016 = pd.read_spss('./ireland-data/ESS8IE.sav')\n",
    "ireland_2014 = pd.read_spss('./ireland-data/ESS7IE.sav')\n",
    "ireland_2012 = pd.read_spss('./ireland-data/ESS6IE.sav')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "9135f30f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(135, 135, 135, 85)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ireland_2016.vteurmmb.isnull().sum(), ireland_2016.vteurmmb.isnull().sum(), \\\n",
    "ireland_2016.vteurmmb.isnull().sum(), ireland_2018.vteurmmb.isnull().sum()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "991012f5",
   "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>name</th>\n",
       "      <th>essround</th>\n",
       "      <th>edition</th>\n",
       "      <th>proddate</th>\n",
       "      <th>idno</th>\n",
       "      <th>cntry</th>\n",
       "      <th>tvtot</th>\n",
       "      <th>tvpol</th>\n",
       "      <th>ppltrst</th>\n",
       "      <th>pplfair</th>\n",
       "      <th>...</th>\n",
       "      <th>inwtm</th>\n",
       "      <th>spltadmf</th>\n",
       "      <th>supqad1</th>\n",
       "      <th>supqad2</th>\n",
       "      <th>supqdd</th>\n",
       "      <th>supqmm</th>\n",
       "      <th>supqyr</th>\n",
       "      <th>dweight</th>\n",
       "      <th>pspwght</th>\n",
       "      <th>pweight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ESS7e02_2</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>01.12.2018</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>More than 2,5 hours, up to 3 hours</td>\n",
       "      <td>Less than 0,5 hour</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>42.0</td>\n",
       "      <td>FF B TESTF10-TESTF18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Face to face interview</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>0.471866</td>\n",
       "      <td>0.498010</td>\n",
       "      <td>0.1503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ESS7e02_2</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>01.12.2018</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>More than 1,5 hours, up to 2 hours</td>\n",
       "      <td>More than 1 hour, up to 1,5 hours</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>44.0</td>\n",
       "      <td>FF A TESTF1-TESTF9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Face to face interview</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>1.415597</td>\n",
       "      <td>1.024681</td>\n",
       "      <td>0.1503</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 601 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        name  essround edition    proddate  idno    cntry  \\\n",
       "0  ESS7e02_2       7.0     2.2  01.12.2018   2.0  Ireland   \n",
       "1  ESS7e02_2       7.0     2.2  01.12.2018   4.0  Ireland   \n",
       "\n",
       "                                tvtot                              tvpol  \\\n",
       "0  More than 2,5 hours, up to 3 hours                 Less than 0,5 hour   \n",
       "1  More than 1,5 hours, up to 2 hours  More than 1 hour, up to 1,5 hours   \n",
       "\n",
       "  ppltrst pplfair  ... inwtm              spltadmf supqad1  \\\n",
       "0       6       6  ...  42.0  FF B TESTF10-TESTF18     NaN   \n",
       "1       8       7  ...  44.0    FF A TESTF1-TESTF9     NaN   \n",
       "\n",
       "                  supqad2 supqdd supqmm  supqyr   dweight   pspwght pweight  \n",
       "0  Face to face interview   16.0    9.0  2014.0  0.471866  0.498010  0.1503  \n",
       "1  Face to face interview   18.0    9.0  2014.0  1.415597  1.024681  0.1503  \n",
       "\n",
       "[2 rows x 601 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ireland_2014.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "c8883686",
   "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>name</th>\n",
       "      <th>essround</th>\n",
       "      <th>edition</th>\n",
       "      <th>proddate</th>\n",
       "      <th>idno</th>\n",
       "      <th>cntry</th>\n",
       "      <th>nwspol</th>\n",
       "      <th>netusoft</th>\n",
       "      <th>netustm</th>\n",
       "      <th>ppltrst</th>\n",
       "      <th>...</th>\n",
       "      <th>inwdde</th>\n",
       "      <th>inwmme</th>\n",
       "      <th>inwyye</th>\n",
       "      <th>inwehh</th>\n",
       "      <th>inwemm</th>\n",
       "      <th>inwtm</th>\n",
       "      <th>dweight</th>\n",
       "      <th>pspwght</th>\n",
       "      <th>pweight</th>\n",
       "      <th>anweight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ESS8e02_2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>10.12.2020</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>60.0</td>\n",
       "      <td>Most days</td>\n",
       "      <td>30.0</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>29.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>2.329728</td>\n",
       "      <td>1.527070</td>\n",
       "      <td>0.133761</td>\n",
       "      <td>0.204262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ESS8e02_2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>10.12.2020</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>30.0</td>\n",
       "      <td>Only occasionally</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0.931891</td>\n",
       "      <td>0.883879</td>\n",
       "      <td>0.133761</td>\n",
       "      <td>0.118228</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 535 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        name  essround edition    proddate  idno    cntry nwspol  \\\n",
       "0  ESS8e02_2       8.0     2.2  10.12.2020   1.0  Ireland   60.0   \n",
       "1  ESS8e02_2       8.0     2.2  10.12.2020   2.0  Ireland   30.0   \n",
       "\n",
       "            netusoft netustm ppltrst  ... inwdde inwmme  inwyye inwehh inwemm  \\\n",
       "0          Most days    30.0       6  ...   29.0   12.0  2016.0   22.0    5.0   \n",
       "1  Only occasionally     NaN       5  ...    6.0    1.0  2017.0   19.0   45.0   \n",
       "\n",
       "  inwtm   dweight   pspwght   pweight  anweight  \n",
       "0  67.0  2.329728  1.527070  0.133761  0.204262  \n",
       "1  51.0  0.931891  0.883879  0.133761  0.118228  \n",
       "\n",
       "[2 rows x 535 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ireland_2016.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6009f8d5",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "386aa2fc",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "910ad0f5",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ce804838",
   "metadata": {},
   "outputs": [],
   "source": [
    "variables = [\"cntry\", \n",
    "               \"eduyrs\", \n",
    "               \"eisced\",\n",
    "               \"uemp3m\", \n",
    "               \"mbtru\", \n",
    "               \"vteurmmb\", \n",
    "               \"yrbrn\", \n",
    "               \"agea\", \n",
    "               \"gndr\", \n",
    "               \"anweight\", \n",
    "               \"psu\", \n",
    "               \"stratum\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d0006f08",
   "metadata": {},
   "outputs": [],
   "source": [
    "variables = [\"cntry\", \n",
    "               \"eduyrs\", \n",
    "               \"eisced\",\n",
    "               \"uemp3m\", \n",
    "               \"mbtru\", \n",
    "               \"vteurmmb\", \n",
    "               \"yrbrn\", \n",
    "               \"agea\", \n",
    "               \"gndr\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "3e9dc0f6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2012_clean = ireland_2016.loc[:,variables]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2f92f1ec",
   "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>cntry</th>\n",
       "      <th>eduyrs</th>\n",
       "      <th>eisced</th>\n",
       "      <th>uemp3m</th>\n",
       "      <th>mbtru</th>\n",
       "      <th>vteurmmb</th>\n",
       "      <th>yrbrn</th>\n",
       "      <th>agea</th>\n",
       "      <th>gndr</th>\n",
       "      <th>anweight</th>\n",
       "      <th>psu</th>\n",
       "      <th>stratum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>19.0</td>\n",
       "      <td>ES-ISCED IV, advanced vocational, sub-degree</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, previously</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>0.260053</td>\n",
       "      <td>14244.0</td>\n",
       "      <td>1885.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>16.0</td>\n",
       "      <td>ES-ISCED IV, advanced vocational, sub-degree</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>0.520106</td>\n",
       "      <td>14177.0</td>\n",
       "      <td>1765.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>15.0</td>\n",
       "      <td>ES-ISCED IV, advanced vocational, sub-degree</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1984.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>0.134029</td>\n",
       "      <td>14522.0</td>\n",
       "      <td>2029.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>7.0</td>\n",
       "      <td>ES-ISCED I , less than lower secondary</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1951.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>0.045637</td>\n",
       "      <td>14539.0</td>\n",
       "      <td>1823.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ireland</td>\n",
       "      <td>20.0</td>\n",
       "      <td>ES-ISCED IV, advanced vocational, sub-degree</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, previously</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1940.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>0.107635</td>\n",
       "      <td>14204.0</td>\n",
       "      <td>2050.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cntry eduyrs                                        eisced uemp3m  \\\n",
       "0  Ireland   19.0  ES-ISCED IV, advanced vocational, sub-degree     No   \n",
       "1  Ireland   16.0  ES-ISCED IV, advanced vocational, sub-degree    Yes   \n",
       "2  Ireland   15.0  ES-ISCED IV, advanced vocational, sub-degree     No   \n",
       "3  Ireland    7.0        ES-ISCED I , less than lower secondary     No   \n",
       "4  Ireland   20.0  ES-ISCED IV, advanced vocational, sub-degree     No   \n",
       "\n",
       "             mbtru                             vteurmmb   yrbrn  agea    gndr  \\\n",
       "0  Yes, previously  Remain member of the European Union  1984.0  34.0    Male   \n",
       "1               No  Remain member of the European Union  1996.0  23.0    Male   \n",
       "2               No  Remain member of the European Union  1984.0  35.0  Female   \n",
       "3               No  Remain member of the European Union  1951.0  68.0    Male   \n",
       "4  Yes, previously  Remain member of the European Union  1940.0  79.0  Female   \n",
       "\n",
       "   anweight      psu  stratum  \n",
       "0  0.260053  14244.0   1885.0  \n",
       "1  0.520106  14177.0   1765.0  \n",
       "2  0.134029  14522.0   2029.0  \n",
       "3  0.045637  14539.0   1823.0  \n",
       "4  0.107635  14204.0   2050.0  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "e9289cd7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "vteurmmb\n",
       "Leave the European Union                125\n",
       "Not eligible to vote                     48\n",
       "Remain member of the European Union    1914\n",
       "Would not vote                           38\n",
       "Would spoil the ballot paper              2\n",
       "Would submit a blank ballot paper         4\n",
       "dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_clean.groupby('vteurmmb').size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f9c325e8",
   "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>cntry</th>\n",
       "      <th>eduyrs</th>\n",
       "      <th>eisced</th>\n",
       "      <th>uemp3m</th>\n",
       "      <th>mbtru</th>\n",
       "      <th>vteurmmb</th>\n",
       "      <th>yrbrn</th>\n",
       "      <th>agea</th>\n",
       "      <th>gndr</th>\n",
       "      <th>anweight</th>\n",
       "      <th>psu</th>\n",
       "      <th>stratum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Italy</td>\n",
       "      <td>13.0</td>\n",
       "      <td>ES-ISCED IIIa, upper tier upper secondary</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>1.765664</td>\n",
       "      <td>15837.0</td>\n",
       "      <td>2403.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Italy</td>\n",
       "      <td>10.0</td>\n",
       "      <td>ES-ISCED II, lower secondary</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Not eligible to vote</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>1.822796</td>\n",
       "      <td>15862.0</td>\n",
       "      <td>2422.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Italy</td>\n",
       "      <td>15.0</td>\n",
       "      <td>ES-ISCED V1, lower tertiary education, BA level</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>1.558781</td>\n",
       "      <td>15384.0</td>\n",
       "      <td>2424.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Italy</td>\n",
       "      <td>20.0</td>\n",
       "      <td>ES-ISCED V1, lower tertiary education, BA level</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Remain member of the European Union</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Female</td>\n",
       "      <td>1.883601</td>\n",
       "      <td>15802.0</td>\n",
       "      <td>2399.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Italy</td>\n",
       "      <td>8.0</td>\n",
       "      <td>ES-ISCED II, lower secondary</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Leave the European Union</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>Male</td>\n",
       "      <td>2.741621</td>\n",
       "      <td>15826.0</td>\n",
       "      <td>2403.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cntry eduyrs                                           eisced uemp3m mbtru  \\\n",
       "0  Italy   13.0        ES-ISCED IIIa, upper tier upper secondary    Yes    No   \n",
       "1  Italy   10.0                     ES-ISCED II, lower secondary    Yes    No   \n",
       "2  Italy   15.0  ES-ISCED V1, lower tertiary education, BA level     No    No   \n",
       "3  Italy   20.0  ES-ISCED V1, lower tertiary education, BA level    Yes    No   \n",
       "4  Italy    8.0                     ES-ISCED II, lower secondary    Yes    No   \n",
       "\n",
       "                              vteurmmb   yrbrn  agea    gndr  anweight  \\\n",
       "0  Remain member of the European Union  1981.0  38.0  Female  1.765664   \n",
       "1                 Not eligible to vote  2002.0  17.0    Male  1.822796   \n",
       "2  Remain member of the European Union  1991.0  28.0    Male  1.558781   \n",
       "3  Remain member of the European Union  1990.0  29.0  Female  1.883601   \n",
       "4             Leave the European Union  1974.0  45.0    Male  2.741621   \n",
       "\n",
       "       psu  stratum  \n",
       "0  15837.0   2403.0  \n",
       "1  15862.0   2422.0  \n",
       "2  15384.0   2424.0  \n",
       "3  15802.0   2399.0  \n",
       "4  15826.0   2403.0  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "italy = pd.read_spss('./ESS9IT.sav')\n",
    "it_clean = italy.loc[:,variables]\n",
    "it_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "fb24622e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "vteurmmb\n",
       "Leave the European Union                438\n",
       "Not eligible to vote                     53\n",
       "Remain member of the European Union    1679\n",
       "Would not vote                          150\n",
       "Would spoil the ballot paper             13\n",
       "Would submit a blank ballot paper        54\n",
       "dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "it_clean.groupby('vteurmmb').size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d98675f5",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}