openingPNADdata.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Opening PNAD Data "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "[PNAD](https://www.ibge.gov.br/estatisticas/sociais/populacao/9171-pesquisa-nacional-por-amostra-de-domicilios-continua-mensal.html) stands for Pesquisa Nacional por Amostra de Domicílio (The National Household Sample Survey), a survey carried out by the Brazilian Institute of Geography and Statistics (IBGE) on a sample of Brazilian households that, for having multiple purposes, investigates various socioeconomic characteristics of society, such as population, education, work , income, housing, social security, migration, fertility, marriage, health, nutrition, and many others."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "ename": "UnsupportedOperation",
     "evalue": "not readable",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mUnsupportedOperation\u001b[0m                      Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-2-a644385d2dd1>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[0mf\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.txt'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'w'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mUnsupportedOperation\u001b[0m: not readable"
     ]
    }
   ],
   "source": [
    "f = open('C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.txt', 'w')\n",
    "print(f.read())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "ename": "UnsupportedOperation",
     "evalue": "not readable",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mUnsupportedOperation\u001b[0m                      Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-4-73bed67cf2d5>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;32mwith\u001b[0m \u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.txt'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'w'\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0mf\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m     \u001b[0mcontents\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      3\u001b[0m     \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcontents\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mUnsupportedOperation\u001b[0m: not readable"
     ]
    }
   ],
   "source": [
    "with open('C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.txt', 'w') as f:\n",
    "    contents = f.read()\n",
    "    print(contents)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#when trying to open the text file, as if it were a normal txt file, in either way it won't open "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Another way could be to open the text file on [sublime text](https://www.sublimetext.com) and save it on csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-6-dad99cde1f7a>:1: ParserWarning: Falling back to the 'python' engine because the 'c' engine does not support regex separators (separators > 1 char and different from '\\s+' are interpreted as regex); you can avoid this warning by specifying engine='python'.\n",
      "  pnad4thtrimester2020csv = pd.read_csv('C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.csv', sep='delimiter', header=None)\n"
     ]
    }
   ],
   "source": [
    "pnad4thtrimester2020csv = pd.read_csv('C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.csv', sep='delimiter', header=None)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The data can be downloaded [here](https://www.ibge.gov.br/estatisticas/downloads-estatisticas.html?caminho=Trabalho_e_Rendimento/Pesquisa_Nacional_por_Amostra_de_Domicilios_continua/Trimestral/Microdados/2020).\n",
    "The 1st file corresponds to the 1st trimester of 2020, the 2nd file, 2nd trimester, and the same logic for the 3rd and 4th files. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(335566, 1)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020csv.shape"
   ]
  },
  {
   "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></th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202041111  11000001611100110108311000083.40224...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>202041111  11000001611100110108311000083.40224...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>202041111  11000001611100110108311000083.40224...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   0\n",
       "0  202041111  11000001611100110108311000083.40224...\n",
       "1  202041111  11000001611100110108311000083.40224...\n",
       "2  202041111  11000001611100110108311000083.40224..."
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020csv.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#If the file is opened on csv or txt, it will not work because it will have only one column and it won't be readable. \n",
    "#It needs to be opened with fwf from the text file format, fwf stands for 'fixed width files'."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here's the documentation on [fwf](https://pandas.pydata.org/pandas-docs/version/0.22/generated/pandas.read_fwf.html)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "pnad4thtrimester2020 = pd.read_fwf('C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.txt',header=None, dtype=str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(335566, 31)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "      <th>30</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202041111</td>\n",
       "      <td>11000001611100110108311000083.40224763000126.9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>072</td>\n",
       "      <td>105</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>191123 69000</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01063205311</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110107091331000010450000104510000104500001045</td>\n",
       "      <td>040</td>\n",
       "      <td>04033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>202041111</td>\n",
       "      <td>11000001611100110108311000083.40224763000126.9...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>101</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>152233 48071</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03063410411</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110104051331000010450000104510000104500001045</td>\n",
       "      <td>040</td>\n",
       "      <td>04033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>202041111</td>\n",
       "      <td>11000001611100110108311000083.40224763000126.9...</td>\n",
       "      <td>06</td>\n",
       "      <td>01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22222</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>220306330942 2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          0                                                  1    2   3    4   \\\n",
       "0  202041111  11000001611100110108311000083.40224763000126.9...  NaN   1  072   \n",
       "1  202041111  11000001611100110108311000083.40224763000126.9...  NaN   1   10   \n",
       "2  202041111  11000001611100110108311000083.40224763000126.9...   06  01  NaN   \n",
       "\n",
       "    5      6    7    8             9   ...   21   22   23   24   25  \\\n",
       "0  105     21  NaN  NaN  191123 69000  ...    2  NaN  NaN  NaN  NaN   \n",
       "1  101     21  NaN  NaN  152233 48071  ...    2  NaN  NaN  NaN  NaN   \n",
       "2  NaN  22222  NaN  NaN           NaN  ...  NaN    2    2  NaN  NaN   \n",
       "\n",
       "               26   27                                             28   29  \\\n",
       "0     01063205311  NaN  110107091331000010450000104510000104500001045  040   \n",
       "1     03063410411  NaN  110104051331000010450000104510000104500001045  040   \n",
       "2  220306330942 2  NaN                                            NaN    2   \n",
       "\n",
       "      30  \n",
       "0  04033  \n",
       "1  04033  \n",
       "2    NaN  \n",
       "\n",
       "[3 rows x 31 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Python does not know the width of the columns\n",
    "#It's also important to type 'dtype = str', so python does not try to find any other kinds of data type objects besides strings."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#There's the need to pass a list 'width', because python does not know how large each column in the data is;\n",
    "#these numbers below came from the data dictionary, from the column 'tamanho', which means size."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "PNAD's data dictionary can be downloaded in this [page](https://ftp.ibge.gov.br/Trabalho_e_Rendimento/Pesquisa_Nacional_por_Amostra_de_Domicilios_continua/Trimestral/Microdados/Documentacao/) or directly [here](https://ftp.ibge.gov.br/Trabalho_e_Rendimento/Pesquisa_Nacional_por_Amostra_de_Domicilios_continua/Trimestral/Microdados/Documentacao/Dicionario_e_input_20210617.zip), both pages are on IBGE's website."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "width = [4,1,2,2,2,9,7,2,2,1,1,1,15,15,9,3,2,2,2,1,2,2,4,3,1,1,1,1,2,2,1,1,1,2,1,1,1,2,2,1,1,1,1,2,1,1,1,1,1,1,1,1,1,1,1,1,\n",
    "2,2,2,1,4,1,1,5,1,1,1,1,1,1,2,1,1,2,2,1,1,1,1,1,2,2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8,1,1,8,1,1,1,1,1,8,1,1,8,3,3,1,2,\n",
    "2,2,4,1,1,5,1,1,1,1,1,1,1,1,8,1,1,8,1,1,1,1,1,8,1,1,8,3,3,1,1,1,1,8,1,1,8,1,1,1,1,1,1,8,1,1,8,3,3,1,1,1,1,1,2,1,1,\n",
    "1,2,1,2,1,2,2,2,1,1,1,1,2,2,1,1,2,1,1,1,1,1,1,1,1,1,2,2,2,1,1,1,1,8,8,1,8,8,1,1,3,3,3,3,3,1,1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "pnad4thtrimester2020 = pd.read_fwf('C:/Users/andre/Documents/Thesis/Thesis Project/Novas planilhas até 22-12-2020/pnad/PNADC_042020/PNADC_042020.txt', widths=width, header=None, dtype=str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "      <th>30</th>\n",
       "      <th>31</th>\n",
       "      <th>32</th>\n",
       "      <th>33</th>\n",
       "      <th>34</th>\n",
       "      <th>35</th>\n",
       "      <th>36</th>\n",
       "      <th>37</th>\n",
       "      <th>38</th>\n",
       "      <th>39</th>\n",
       "      <th>40</th>\n",
       "      <th>41</th>\n",
       "      <th>42</th>\n",
       "      <th>43</th>\n",
       "      <th>44</th>\n",
       "      <th>45</th>\n",
       "      <th>46</th>\n",
       "      <th>47</th>\n",
       "      <th>48</th>\n",
       "      <th>49</th>\n",
       "      <th>50</th>\n",
       "      <th>51</th>\n",
       "      <th>52</th>\n",
       "      <th>53</th>\n",
       "      <th>54</th>\n",
       "      <th>55</th>\n",
       "      <th>56</th>\n",
       "      <th>57</th>\n",
       "      <th>58</th>\n",
       "      <th>59</th>\n",
       "      <th>60</th>\n",
       "      <th>61</th>\n",
       "      <th>62</th>\n",
       "      <th>63</th>\n",
       "      <th>64</th>\n",
       "      <th>65</th>\n",
       "      <th>66</th>\n",
       "      <th>67</th>\n",
       "      <th>68</th>\n",
       "      <th>69</th>\n",
       "      <th>70</th>\n",
       "      <th>71</th>\n",
       "      <th>72</th>\n",
       "      <th>73</th>\n",
       "      <th>74</th>\n",
       "      <th>75</th>\n",
       "      <th>76</th>\n",
       "      <th>77</th>\n",
       "      <th>78</th>\n",
       "      <th>79</th>\n",
       "      <th>80</th>\n",
       "      <th>81</th>\n",
       "      <th>82</th>\n",
       "      <th>83</th>\n",
       "      <th>84</th>\n",
       "      <th>85</th>\n",
       "      <th>86</th>\n",
       "      <th>87</th>\n",
       "      <th>88</th>\n",
       "      <th>89</th>\n",
       "      <th>90</th>\n",
       "      <th>91</th>\n",
       "      <th>92</th>\n",
       "      <th>93</th>\n",
       "      <th>94</th>\n",
       "      <th>95</th>\n",
       "      <th>96</th>\n",
       "      <th>97</th>\n",
       "      <th>98</th>\n",
       "      <th>99</th>\n",
       "      <th>100</th>\n",
       "      <th>101</th>\n",
       "      <th>102</th>\n",
       "      <th>103</th>\n",
       "      <th>104</th>\n",
       "      <th>105</th>\n",
       "      <th>106</th>\n",
       "      <th>107</th>\n",
       "      <th>108</th>\n",
       "      <th>109</th>\n",
       "      <th>110</th>\n",
       "      <th>111</th>\n",
       "      <th>112</th>\n",
       "      <th>113</th>\n",
       "      <th>114</th>\n",
       "      <th>115</th>\n",
       "      <th>116</th>\n",
       "      <th>117</th>\n",
       "      <th>118</th>\n",
       "      <th>119</th>\n",
       "      <th>120</th>\n",
       "      <th>121</th>\n",
       "      <th>122</th>\n",
       "      <th>123</th>\n",
       "      <th>124</th>\n",
       "      <th>125</th>\n",
       "      <th>126</th>\n",
       "      <th>127</th>\n",
       "      <th>128</th>\n",
       "      <th>129</th>\n",
       "      <th>130</th>\n",
       "      <th>131</th>\n",
       "      <th>132</th>\n",
       "      <th>133</th>\n",
       "      <th>134</th>\n",
       "      <th>135</th>\n",
       "      <th>136</th>\n",
       "      <th>137</th>\n",
       "      <th>138</th>\n",
       "      <th>139</th>\n",
       "      <th>140</th>\n",
       "      <th>141</th>\n",
       "      <th>142</th>\n",
       "      <th>143</th>\n",
       "      <th>144</th>\n",
       "      <th>145</th>\n",
       "      <th>146</th>\n",
       "      <th>147</th>\n",
       "      <th>148</th>\n",
       "      <th>149</th>\n",
       "      <th>150</th>\n",
       "      <th>151</th>\n",
       "      <th>152</th>\n",
       "      <th>153</th>\n",
       "      <th>154</th>\n",
       "      <th>155</th>\n",
       "      <th>156</th>\n",
       "      <th>157</th>\n",
       "      <th>158</th>\n",
       "      <th>159</th>\n",
       "      <th>160</th>\n",
       "      <th>161</th>\n",
       "      <th>162</th>\n",
       "      <th>163</th>\n",
       "      <th>164</th>\n",
       "      <th>165</th>\n",
       "      <th>166</th>\n",
       "      <th>167</th>\n",
       "      <th>168</th>\n",
       "      <th>169</th>\n",
       "      <th>170</th>\n",
       "      <th>171</th>\n",
       "      <th>172</th>\n",
       "      <th>173</th>\n",
       "      <th>174</th>\n",
       "      <th>175</th>\n",
       "      <th>176</th>\n",
       "      <th>177</th>\n",
       "      <th>178</th>\n",
       "      <th>179</th>\n",
       "      <th>180</th>\n",
       "      <th>181</th>\n",
       "      <th>182</th>\n",
       "      <th>183</th>\n",
       "      <th>184</th>\n",
       "      <th>185</th>\n",
       "      <th>186</th>\n",
       "      <th>187</th>\n",
       "      <th>188</th>\n",
       "      <th>189</th>\n",
       "      <th>190</th>\n",
       "      <th>191</th>\n",
       "      <th>192</th>\n",
       "      <th>193</th>\n",
       "      <th>194</th>\n",
       "      <th>195</th>\n",
       "      <th>196</th>\n",
       "      <th>197</th>\n",
       "      <th>198</th>\n",
       "      <th>199</th>\n",
       "      <th>200</th>\n",
       "      <th>201</th>\n",
       "      <th>202</th>\n",
       "      <th>203</th>\n",
       "      <th>204</th>\n",
       "      <th>205</th>\n",
       "      <th>206</th>\n",
       "      <th>207</th>\n",
       "      <th>208</th>\n",
       "      <th>209</th>\n",
       "      <th>210</th>\n",
       "      <th>211</th>\n",
       "      <th>212</th>\n",
       "      <th>213</th>\n",
       "      <th>214</th>\n",
       "      <th>215</th>\n",
       "      <th>216</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110000016</td>\n",
       "      <td>1110011</td>\n",
       "      <td>01</td>\n",
       "      <td>08</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>000083.40224763</td>\n",
       "      <td>000126.91052794</td>\n",
       "      <td>000542168</td>\n",
       "      <td>111</td>\n",
       "      <td>06</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>05</td>\n",
       "      <td>1981</td>\n",
       "      <td>039</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</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>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>07</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9112</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>040</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>06</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>05</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>07</td>\n",
       "      <td>09</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110000016</td>\n",
       "      <td>1110011</td>\n",
       "      <td>01</td>\n",
       "      <td>08</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>000083.40224763</td>\n",
       "      <td>000126.91052794</td>\n",
       "      <td>000542168</td>\n",
       "      <td>111</td>\n",
       "      <td>06</td>\n",
       "      <td>02</td>\n",
       "      <td>05</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>06</td>\n",
       "      <td>2000</td>\n",
       "      <td>020</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</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>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>5223</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>040</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03</td>\n",
       "      <td>06</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>04</td>\n",
       "      <td>05</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110000016</td>\n",
       "      <td>1110011</td>\n",
       "      <td>01</td>\n",
       "      <td>08</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>000083.40224763</td>\n",
       "      <td>000126.91052794</td>\n",
       "      <td>000542168</td>\n",
       "      <td>111</td>\n",
       "      <td>06</td>\n",
       "      <td>03</td>\n",
       "      <td>05</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>05</td>\n",
       "      <td>2004</td>\n",
       "      <td>016</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>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>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>03</td>\n",
       "      <td>06</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>09</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    0   1   2   3    4          5        6   7   8   9   10  11   \\\n",
       "0  2020   4  11  11  NaN  110000016  1110011  01  08   3   1   1   \n",
       "1  2020   4  11  11  NaN  110000016  1110011  01  08   3   1   1   \n",
       "2  2020   4  11  11  NaN  110000016  1110011  01  08   3   1   1   \n",
       "\n",
       "               12               13         14   15  16  17  18  19  20  21   \\\n",
       "0  000083.40224763  000126.91052794  000542168  111  06  01  01   2  16  05   \n",
       "1  000083.40224763  000126.91052794  000542168  111  06  02  05   2  12  06   \n",
       "2  000083.40224763  000126.91052794  000542168  111  06  03  05   2  15  05   \n",
       "\n",
       "    22   23  24  25  26   27   28   29   30   31   32   33   34   35   36   \\\n",
       "0  1981  039   4   1   2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    1   \n",
       "1  2000  020   4   1   2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    1   \n",
       "2  2004  016   4   1   1    2  NaN   06  NaN  NaN  NaN   01  NaN  NaN  NaN   \n",
       "\n",
       "   37   38   39   40   41   42   43   44   45   46  47   48   49   50   51   \\\n",
       "0  NaN   07    2  NaN  NaN    1   05  NaN  NaN    2   1  NaN  NaN  NaN  NaN   \n",
       "1  NaN   10  NaN  NaN  NaN    1   01  NaN  NaN    2   1  NaN  NaN  NaN  NaN   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   2    2    2    2    2   \n",
       "\n",
       "   52   53   54   55   56   57   58   59    60   61   62     63   64   65   \\\n",
       "0  NaN  NaN  NaN  NaN  NaN  NaN  NaN    1  9112    3  NaN  69000  NaN    2   \n",
       "1  NaN  NaN  NaN  NaN  NaN  NaN  NaN    1  5223    3  NaN  48071  NaN    2   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   NaN  NaN  NaN    NaN  NaN  NaN   \n",
       "\n",
       "   66   67   68   69   70   71   72   73   74   75   76   77   78   79   80   \\\n",
       "0  NaN    2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    3  NaN  NaN   \n",
       "1  NaN    2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    1    4  NaN   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "\n",
       "   81   82   83   84   85   86   87   88   89   90   91   92   93   94   95   \\\n",
       "0   15  NaN    1    1  NaN  NaN    2  NaN  NaN  NaN    1  NaN    1    1    2   \n",
       "1  NaN  NaN    1    1  NaN  NaN    2  NaN  NaN  NaN    1  NaN    1    1    2   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "\n",
       "        96   97   98   99   100  101  102  103  104       105  106  107  108  \\\n",
       "0  00001045  NaN  NaN  NaN  NaN  NaN    1    1    2  00001045  NaN  NaN  NaN   \n",
       "1  00001045  NaN  NaN  NaN  NaN  NaN    1    1    2  00001045  NaN  NaN  NaN   \n",
       "2       NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN       NaN  NaN  NaN  NaN   \n",
       "\n",
       "   109  110  111  112  113  114  115  116  117  118  119  120  121  122  123  \\\n",
       "0  040  040    4  NaN  NaN   03  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "1  040  040    4  NaN  NaN   02  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "\n",
       "   124  125  126  127  128  129  130  131  132  133  134  135  136  137  138  \\\n",
       "0  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "1  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "\n",
       "   139  140  141  142  143  144  145  146  147  148  149  150  151  152  153  \\\n",
       "0  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "1  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "\n",
       "   154  155  156  157  158  159  160  161  162  163  164  165  166  167  168  \\\n",
       "0  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    2  NaN  NaN  NaN  NaN  NaN   \n",
       "1  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    2  NaN  NaN  NaN  NaN  NaN   \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    2  NaN  NaN   \n",
       "\n",
       "   169  170  171  172  173  174  175  176  177  178  179  180  181 182 183  \\\n",
       "0  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  01  06   \n",
       "1  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  03  06   \n",
       "2    2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN    2    2  03  06   \n",
       "\n",
       "  184 185 186 187 188  189  190  191  192  193  194  195  196  197  198  199  \\\n",
       "0   3   2  05   3   1    1  NaN  NaN  NaN  NaN    1    1   01   07   09    1   \n",
       "1   3   4  10   4   1    1  NaN  NaN  NaN  NaN    1    1   01   04   05    1   \n",
       "2   3   3  09   4   2  NaN    2  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
       "\n",
       "   200  201  202       203       204  205       206       207  208  209  210  \\\n",
       "0    3    3    1  00001045  00001045    1  00001045  00001045  NaN  NaN  040   \n",
       "1    3    3    1  00001045  00001045    1  00001045  00001045  NaN  NaN  040   \n",
       "2  NaN  NaN  NaN       NaN       NaN  NaN       NaN       NaN  NaN    2  NaN   \n",
       "\n",
       "   211  212  213  214  215  216  \n",
       "0  NaN  NaN  NaN  040    3    3  \n",
       "1  NaN  NaN  NaN  040    3    3  \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "#By looking at the data dictionary, on the columns variables, each variable needs to be passed into a list with .columns,\n",
    "#which names the columns."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "pnad4thtrimester2020.columns = ['Ano','Trimestre', 'UF', 'CAPITAL','RM_RIDE','UPA', 'Estrato', 'V1008', 'V1014','V1016', \n",
    "                                'V1022','V1023', 'V1027', 'V1028','V1029', 'posest', 'V2001','V2003','V2005','V2007','V2008',\n",
    "                                'V20081', 'V20082','V2009','V2010','V3001','V3002','V3002A','V3003','V3003A','V3004','V3005',\n",
    "                                'V3005A','V3006','V3006A','V3007','V3008','V3009','V3009A','V3010','V3011','V3011A','V3012',\n",
    "                                'V3013','V3013A','V3013B','V3014','V4001','V4002','V4003','V4004','V4005','V4006','V4006A',\n",
    "                                'V4007','V4008','V40081','V40082','V40083','V4009','V4010','V4012','V4012','V40121','V4013',\n",
    "                                'V40132','V40132A','V4014','V4015','V40151','V401511','V401512','V4016','V40161','V40162',\n",
    "                                'V40163','V4017','V40171','V401711','V4018','V40181','V40182','V40183','V4019','V4020',\n",
    "                                'V4021','V4022','V4024','V4025','V4026','V4027','V4028','V4029','V4032','V4033','V40331'\n",
    "                                'V403311','V403312','V40332','V403321','V403322','V40333','V403331','V4034','V40341',\n",
    "                                'V403411','V403412','V40342','V403421','V403422','V4039','V4039C','V4040','V40401','V40402',\n",
    "                                'V40403','V4041','V4043','V40431','V4044','V4045','V4046','V4047','V4048','V4049','V4050',\n",
    "                                'V40501','V405011','V405012','V40502','V405021','V405022','V40503','V405031','V4051','V40511',\n",
    "                                'V405111','V405112','V40512','V405121','V405122','V4056','V4056C','V4057','V4058','V40581',\n",
    "                                'V405811','V405812','V40582','V405821','V405822','V40583','V405831','V40584','V4059','V40591',\n",
    "                                'V405911','V405912','V40592','V405921','V405922','V4062','V4062C','V4063','V4063A',\n",
    "                                'V4064','V4064A','V4071','V4072','V4072A','V4073','V4074','V4074A','V4075A','V4075A1',\n",
    "                                'V4076','V40761','V40762','V40763','V4077','V4078','V4078A','V4082','VD2002','VD2003','VD2004',\n",
    "                                'VD3004','VD3005','VD3006','VD4001','VD4002','VD4003','VD4004','VD4004A','VD4005','VD4007',\n",
    "                                'VD4008','VD4009','VD4010','VD4011','VD4012','VD4013','VD4014','VD4015','VD4016','VD4017',\n",
    "                                'VD4018','VD4019','VD4020','VD4023','VD4030','VD4031','VD4032','VD4033','VD4034','VD4035',\n",
    "                                'VD4036','VD4037']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>Ano</th>\n",
       "      <th>Trimestre</th>\n",
       "      <th>UF</th>\n",
       "      <th>CAPITAL</th>\n",
       "      <th>RM_RIDE</th>\n",
       "      <th>UPA</th>\n",
       "      <th>Estrato</th>\n",
       "      <th>V1008</th>\n",
       "      <th>V1014</th>\n",
       "      <th>V1016</th>\n",
       "      <th>V1022</th>\n",
       "      <th>V1023</th>\n",
       "      <th>V1027</th>\n",
       "      <th>V1028</th>\n",
       "      <th>V1029</th>\n",
       "      <th>posest</th>\n",
       "      <th>V2001</th>\n",
       "      <th>V2003</th>\n",
       "      <th>V2005</th>\n",
       "      <th>V2007</th>\n",
       "      <th>V2008</th>\n",
       "      <th>V20081</th>\n",
       "      <th>V20082</th>\n",
       "      <th>V2009</th>\n",
       "      <th>V2010</th>\n",
       "      <th>V3001</th>\n",
       "      <th>V3002</th>\n",
       "      <th>V3002A</th>\n",
       "      <th>V3003</th>\n",
       "      <th>V3003A</th>\n",
       "      <th>V3004</th>\n",
       "      <th>V3005</th>\n",
       "      <th>V3005A</th>\n",
       "      <th>V3006</th>\n",
       "      <th>V3006A</th>\n",
       "      <th>V3007</th>\n",
       "      <th>V3008</th>\n",
       "      <th>V3009</th>\n",
       "      <th>V3009A</th>\n",
       "      <th>V3010</th>\n",
       "      <th>V3011</th>\n",
       "      <th>V3011A</th>\n",
       "      <th>V3012</th>\n",
       "      <th>V3013</th>\n",
       "      <th>V3013A</th>\n",
       "      <th>V3013B</th>\n",
       "      <th>V3014</th>\n",
       "      <th>V4001</th>\n",
       "      <th>V4002</th>\n",
       "      <th>V4003</th>\n",
       "      <th>V4004</th>\n",
       "      <th>V4005</th>\n",
       "      <th>V4006</th>\n",
       "      <th>V4006A</th>\n",
       "      <th>V4007</th>\n",
       "      <th>V4008</th>\n",
       "      <th>V40081</th>\n",
       "      <th>V40082</th>\n",
       "      <th>V40083</th>\n",
       "      <th>V4009</th>\n",
       "      <th>V4010</th>\n",
       "      <th>V4012</th>\n",
       "      <th>V4012</th>\n",
       "      <th>V40121</th>\n",
       "      <th>V4013</th>\n",
       "      <th>V40132</th>\n",
       "      <th>V40132A</th>\n",
       "      <th>V4014</th>\n",
       "      <th>V4015</th>\n",
       "      <th>V40151</th>\n",
       "      <th>V401511</th>\n",
       "      <th>V401512</th>\n",
       "      <th>V4016</th>\n",
       "      <th>V40161</th>\n",
       "      <th>V40162</th>\n",
       "      <th>V40163</th>\n",
       "      <th>V4017</th>\n",
       "      <th>V40171</th>\n",
       "      <th>V401711</th>\n",
       "      <th>V4018</th>\n",
       "      <th>V40181</th>\n",
       "      <th>V40182</th>\n",
       "      <th>V40183</th>\n",
       "      <th>V4019</th>\n",
       "      <th>V4020</th>\n",
       "      <th>V4021</th>\n",
       "      <th>V4022</th>\n",
       "      <th>V4024</th>\n",
       "      <th>V4025</th>\n",
       "      <th>V4026</th>\n",
       "      <th>V4027</th>\n",
       "      <th>V4028</th>\n",
       "      <th>V4029</th>\n",
       "      <th>V4032</th>\n",
       "      <th>V4033</th>\n",
       "      <th>V40331V403311</th>\n",
       "      <th>V403312</th>\n",
       "      <th>V40332</th>\n",
       "      <th>V403321</th>\n",
       "      <th>V403322</th>\n",
       "      <th>V40333</th>\n",
       "      <th>V403331</th>\n",
       "      <th>V4034</th>\n",
       "      <th>V40341</th>\n",
       "      <th>V403411</th>\n",
       "      <th>V403412</th>\n",
       "      <th>V40342</th>\n",
       "      <th>V403421</th>\n",
       "      <th>V403422</th>\n",
       "      <th>V4039</th>\n",
       "      <th>V4039C</th>\n",
       "      <th>V4040</th>\n",
       "      <th>V40401</th>\n",
       "      <th>V40402</th>\n",
       "      <th>V40403</th>\n",
       "      <th>V4041</th>\n",
       "      <th>V4043</th>\n",
       "      <th>V40431</th>\n",
       "      <th>V4044</th>\n",
       "      <th>V4045</th>\n",
       "      <th>V4046</th>\n",
       "      <th>V4047</th>\n",
       "      <th>V4048</th>\n",
       "      <th>V4049</th>\n",
       "      <th>V4050</th>\n",
       "      <th>V40501</th>\n",
       "      <th>V405011</th>\n",
       "      <th>V405012</th>\n",
       "      <th>V40502</th>\n",
       "      <th>V405021</th>\n",
       "      <th>V405022</th>\n",
       "      <th>V40503</th>\n",
       "      <th>V405031</th>\n",
       "      <th>V4051</th>\n",
       "      <th>V40511</th>\n",
       "      <th>V405111</th>\n",
       "      <th>V405112</th>\n",
       "      <th>V40512</th>\n",
       "      <th>V405121</th>\n",
       "      <th>V405122</th>\n",
       "      <th>V4056</th>\n",
       "      <th>V4056C</th>\n",
       "      <th>V4057</th>\n",
       "      <th>V4058</th>\n",
       "      <th>V40581</th>\n",
       "      <th>V405811</th>\n",
       "      <th>V405812</th>\n",
       "      <th>V40582</th>\n",
       "      <th>V405821</th>\n",
       "      <th>V405822</th>\n",
       "      <th>V40583</th>\n",
       "      <th>V405831</th>\n",
       "      <th>V40584</th>\n",
       "      <th>V4059</th>\n",
       "      <th>V40591</th>\n",
       "      <th>V405911</th>\n",
       "      <th>V405912</th>\n",
       "      <th>V40592</th>\n",
       "      <th>V405921</th>\n",
       "      <th>V405922</th>\n",
       "      <th>V4062</th>\n",
       "      <th>V4062C</th>\n",
       "      <th>V4063</th>\n",
       "      <th>V4063A</th>\n",
       "      <th>V4064</th>\n",
       "      <th>V4064A</th>\n",
       "      <th>V4071</th>\n",
       "      <th>V4072</th>\n",
       "      <th>V4072A</th>\n",
       "      <th>V4073</th>\n",
       "      <th>V4074</th>\n",
       "      <th>V4074A</th>\n",
       "      <th>V4075A</th>\n",
       "      <th>V4075A1</th>\n",
       "      <th>V4076</th>\n",
       "      <th>V40761</th>\n",
       "      <th>V40762</th>\n",
       "      <th>V40763</th>\n",
       "      <th>V4077</th>\n",
       "      <th>V4078</th>\n",
       "      <th>V4078A</th>\n",
       "      <th>V4082</th>\n",
       "      <th>VD2002</th>\n",
       "      <th>VD2003</th>\n",
       "      <th>VD2004</th>\n",
       "      <th>VD3004</th>\n",
       "      <th>VD3005</th>\n",
       "      <th>VD3006</th>\n",
       "      <th>VD4001</th>\n",
       "      <th>VD4002</th>\n",
       "      <th>VD4003</th>\n",
       "      <th>VD4004</th>\n",
       "      <th>VD4004A</th>\n",
       "      <th>VD4005</th>\n",
       "      <th>VD4007</th>\n",
       "      <th>VD4008</th>\n",
       "      <th>VD4009</th>\n",
       "      <th>VD4010</th>\n",
       "      <th>VD4011</th>\n",
       "      <th>VD4012</th>\n",
       "      <th>VD4013</th>\n",
       "      <th>VD4014</th>\n",
       "      <th>VD4015</th>\n",
       "      <th>VD4016</th>\n",
       "      <th>VD4017</th>\n",
       "      <th>VD4018</th>\n",
       "      <th>VD4019</th>\n",
       "      <th>VD4020</th>\n",
       "      <th>VD4023</th>\n",
       "      <th>VD4030</th>\n",
       "      <th>VD4031</th>\n",
       "      <th>VD4032</th>\n",
       "      <th>VD4033</th>\n",
       "      <th>VD4034</th>\n",
       "      <th>VD4035</th>\n",
       "      <th>VD4036</th>\n",
       "      <th>VD4037</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110000016</td>\n",
       "      <td>1110011</td>\n",
       "      <td>01</td>\n",
       "      <td>08</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>000083.40224763</td>\n",
       "      <td>000126.91052794</td>\n",
       "      <td>000542168</td>\n",
       "      <td>111</td>\n",
       "      <td>06</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>05</td>\n",
       "      <td>1981</td>\n",
       "      <td>039</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</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>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>07</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9112</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>040</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>06</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>05</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>07</td>\n",
       "      <td>09</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110000016</td>\n",
       "      <td>1110011</td>\n",
       "      <td>01</td>\n",
       "      <td>08</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>000083.40224763</td>\n",
       "      <td>000126.91052794</td>\n",
       "      <td>000542168</td>\n",
       "      <td>111</td>\n",
       "      <td>06</td>\n",
       "      <td>02</td>\n",
       "      <td>05</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>06</td>\n",
       "      <td>2000</td>\n",
       "      <td>020</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</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>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>5223</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>040</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03</td>\n",
       "      <td>06</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>04</td>\n",
       "      <td>05</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>1</td>\n",
       "      <td>00001045</td>\n",
       "      <td>00001045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>040</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110000016</td>\n",
       "      <td>1110011</td>\n",
       "      <td>01</td>\n",
       "      <td>08</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>000083.40224763</td>\n",
       "      <td>000126.91052794</td>\n",
       "      <td>000542168</td>\n",
       "      <td>111</td>\n",
       "      <td>06</td>\n",
       "      <td>03</td>\n",
       "      <td>05</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>05</td>\n",
       "      <td>2004</td>\n",
       "      <td>016</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>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>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>03</td>\n",
       "      <td>06</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>09</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Ano Trimestre  UF CAPITAL RM_RIDE        UPA  Estrato V1008 V1014 V1016  \\\n",
       "0  2020         4  11      11     NaN  110000016  1110011    01    08     3   \n",
       "1  2020         4  11      11     NaN  110000016  1110011    01    08     3   \n",
       "2  2020         4  11      11     NaN  110000016  1110011    01    08     3   \n",
       "\n",
       "  V1022 V1023            V1027            V1028      V1029 posest V2001 V2003  \\\n",
       "0     1     1  000083.40224763  000126.91052794  000542168    111    06    01   \n",
       "1     1     1  000083.40224763  000126.91052794  000542168    111    06    02   \n",
       "2     1     1  000083.40224763  000126.91052794  000542168    111    06    03   \n",
       "\n",
       "  V2005 V2007 V2008 V20081 V20082 V2009 V2010 V3001 V3002 V3002A V3003 V3003A  \\\n",
       "0    01     2    16     05   1981   039     4     1     2    NaN   NaN    NaN   \n",
       "1    05     2    12     06   2000   020     4     1     2    NaN   NaN    NaN   \n",
       "2    05     2    15     05   2004   016     4     1     1      2   NaN     06   \n",
       "\n",
       "  V3004 V3005 V3005A V3006 V3006A V3007 V3008 V3009 V3009A V3010 V3011 V3011A  \\\n",
       "0   NaN   NaN    NaN   NaN    NaN   NaN     1   NaN     07     2   NaN    NaN   \n",
       "1   NaN   NaN    NaN   NaN    NaN   NaN     1   NaN     10   NaN   NaN    NaN   \n",
       "2   NaN   NaN    NaN    01    NaN   NaN   NaN   NaN    NaN   NaN   NaN    NaN   \n",
       "\n",
       "  V3012 V3013 V3013A V3013B V3014 V4001 V4002 V4003 V4004 V4005 V4006 V4006A  \\\n",
       "0     1    05    NaN    NaN     2     1   NaN   NaN   NaN   NaN   NaN    NaN   \n",
       "1     1    01    NaN    NaN     2     1   NaN   NaN   NaN   NaN   NaN    NaN   \n",
       "2   NaN   NaN    NaN    NaN   NaN     2     2     2     2     2   NaN    NaN   \n",
       "\n",
       "  V4007 V4008 V40081 V40082 V40083 V4009 V4010 V4012 V4012 V40121 V4013  \\\n",
       "0   NaN   NaN    NaN    NaN    NaN     1  9112     3   NaN  69000   NaN   \n",
       "1   NaN   NaN    NaN    NaN    NaN     1  5223     3   NaN  48071   NaN   \n",
       "2   NaN   NaN    NaN    NaN    NaN   NaN   NaN   NaN   NaN    NaN   NaN   \n",
       "\n",
       "  V40132 V40132A V4014 V4015 V40151 V401511 V401512 V4016 V40161 V40162  \\\n",
       "0      2     NaN     2   NaN    NaN     NaN     NaN   NaN    NaN    NaN   \n",
       "1      2     NaN     2   NaN    NaN     NaN     NaN   NaN    NaN    NaN   \n",
       "2    NaN     NaN   NaN   NaN    NaN     NaN     NaN   NaN    NaN    NaN   \n",
       "\n",
       "  V40163 V4017 V40171 V401711 V4018 V40181 V40182 V40183 V4019 V4020 V4021  \\\n",
       "0    NaN   NaN    NaN       3   NaN    NaN     15    NaN     1     1   NaN   \n",
       "1    NaN   NaN    NaN       1     4    NaN    NaN    NaN     1     1   NaN   \n",
       "2    NaN   NaN    NaN     NaN   NaN    NaN    NaN    NaN   NaN   NaN   NaN   \n",
       "\n",
       "  V4022 V4024 V4025 V4026 V4027 V4028 V4029 V4032 V4033 V40331V403311  \\\n",
       "0   NaN     2   NaN   NaN   NaN     1   NaN     1     1             2   \n",
       "1   NaN     2   NaN   NaN   NaN     1   NaN     1     1             2   \n",
       "2   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN           NaN   \n",
       "\n",
       "    V403312 V40332 V403321 V403322 V40333 V403331 V4034 V40341 V403411  \\\n",
       "0  00001045    NaN     NaN     NaN    NaN     NaN     1      1       2   \n",
       "1  00001045    NaN     NaN     NaN    NaN     NaN     1      1       2   \n",
       "2       NaN    NaN     NaN     NaN    NaN     NaN   NaN    NaN     NaN   \n",
       "\n",
       "    V403412 V40342 V403421 V403422 V4039 V4039C V4040 V40401 V40402 V40403  \\\n",
       "0  00001045    NaN     NaN     NaN   040    040     4    NaN    NaN     03   \n",
       "1  00001045    NaN     NaN     NaN   040    040     4    NaN    NaN     02   \n",
       "2       NaN    NaN     NaN     NaN   NaN    NaN   NaN    NaN    NaN    NaN   \n",
       "\n",
       "  V4041 V4043 V40431 V4044 V4045 V4046 V4047 V4048 V4049 V4050 V40501 V405011  \\\n",
       "0   NaN   NaN    NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN    NaN     NaN   \n",
       "1   NaN   NaN    NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN    NaN     NaN   \n",
       "2   NaN   NaN    NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN    NaN     NaN   \n",
       "\n",
       "  V405012 V40502 V405021 V405022 V40503 V405031 V4051 V40511 V405111 V405112  \\\n",
       "0     NaN    NaN     NaN     NaN    NaN     NaN   NaN    NaN     NaN     NaN   \n",
       "1     NaN    NaN     NaN     NaN    NaN     NaN   NaN    NaN     NaN     NaN   \n",
       "2     NaN    NaN     NaN     NaN    NaN     NaN   NaN    NaN     NaN     NaN   \n",
       "\n",
       "  V40512 V405121 V405122 V4056 V4056C V4057 V4058 V40581 V405811 V405812  \\\n",
       "0    NaN     NaN     NaN   NaN    NaN   NaN   NaN    NaN     NaN     NaN   \n",
       "1    NaN     NaN     NaN   NaN    NaN   NaN   NaN    NaN     NaN     NaN   \n",
       "2    NaN     NaN     NaN   NaN    NaN   NaN   NaN    NaN     NaN     NaN   \n",
       "\n",
       "  V40582 V405821 V405822 V40583 V405831 V40584 V4059 V40591 V405911 V405912  \\\n",
       "0    NaN     NaN     NaN    NaN     NaN    NaN   NaN    NaN     NaN     NaN   \n",
       "1    NaN     NaN     NaN    NaN     NaN    NaN   NaN    NaN     NaN     NaN   \n",
       "2    NaN     NaN     NaN    NaN     NaN    NaN   NaN    NaN     NaN     NaN   \n",
       "\n",
       "  V40592 V405921 V405922 V4062 V4062C V4063 V4063A V4064 V4064A V4071 V4072  \\\n",
       "0    NaN     NaN     NaN   NaN    NaN   NaN      2   NaN    NaN   NaN   NaN   \n",
       "1    NaN     NaN     NaN   NaN    NaN   NaN      2   NaN    NaN   NaN   NaN   \n",
       "2    NaN     NaN     NaN   NaN    NaN   NaN    NaN   NaN    NaN     2   NaN   \n",
       "\n",
       "  V4072A V4073 V4074 V4074A V4075A V4075A1 V4076 V40761 V40762 V40763 V4077  \\\n",
       "0    NaN   NaN   NaN    NaN    NaN     NaN   NaN    NaN    NaN    NaN   NaN   \n",
       "1    NaN   NaN   NaN    NaN    NaN     NaN   NaN    NaN    NaN    NaN   NaN   \n",
       "2    NaN     2   NaN    NaN    NaN     NaN   NaN    NaN    NaN    NaN   NaN   \n",
       "\n",
       "  V4078 V4078A V4082 VD2002 VD2003 VD2004 VD3004 VD3005 VD3006 VD4001 VD4002  \\\n",
       "0   NaN    NaN   NaN     01     06      3      2     05      3      1      1   \n",
       "1   NaN    NaN   NaN     03     06      3      4     10      4      1      1   \n",
       "2   NaN      2     2     03     06      3      3     09      4      2    NaN   \n",
       "\n",
       "  VD4003 VD4004 VD4004A VD4005 VD4007 VD4008 VD4009 VD4010 VD4011 VD4012  \\\n",
       "0    NaN    NaN     NaN    NaN      1      1     01     07     09      1   \n",
       "1    NaN    NaN     NaN    NaN      1      1     01     04     05      1   \n",
       "2      2    NaN     NaN    NaN    NaN    NaN    NaN    NaN    NaN    NaN   \n",
       "\n",
       "  VD4013 VD4014 VD4015    VD4016    VD4017 VD4018    VD4019    VD4020 VD4023  \\\n",
       "0      3      3      1  00001045  00001045      1  00001045  00001045    NaN   \n",
       "1      3      3      1  00001045  00001045      1  00001045  00001045    NaN   \n",
       "2    NaN    NaN    NaN       NaN       NaN    NaN       NaN       NaN    NaN   \n",
       "\n",
       "  VD4030 VD4031 VD4032 VD4033 VD4034 VD4035 VD4036 VD4037  \n",
       "0    NaN    040    NaN    NaN    NaN    040      3      3  \n",
       "1    NaN    040    NaN    NaN    NaN    040      3      3  \n",
       "2      2    NaN    NaN    NaN    NaN    NaN    NaN    NaN  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Just checking the variable's unique values to see if it makes sense with the data dictionary, and it does."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1', '2'], dtype=object)"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020['V1022'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1', '4', '2', '3'], dtype=object)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020['V1023'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['11', '12', '13', '14', '15', '16', '17', '21', '22', '23', '24',\n",
       "       '25', '26', '27', '28', '29', '31', '32', '33', '35', '41', '42',\n",
       "       '43', '50', '51', '52', '53'], dtype=object)"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020['UF'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['11', nan, '12', '13', '14', '15', '16', '17', '21', '22', '23',\n",
       "       '24', '25', '26', '27', '28', '29', '31', '32', '33', '35', '41',\n",
       "       '42', '43', '50', '51', '52', '53'], dtype=object)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020['CAPITAL'].unique() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, '13', '15', '16', '21', '22', '23', '24', '25', '26', '27',\n",
       "       '28', '29', '31', '32', '33', '35', '41', '42', '43', '51', '52'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020['RM_RIDE'].unique() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "#There are many variables to rename, what I would do, is to select some variables looking at the dictionary and then renaming it,\n",
    "#intead of renaming all variables."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "#The example below selects four variables just as an example. Usually to analyze the data someone would probably select 20-50 \n",
    "#variables, but it's much better renaming 20-50 variables than about 400 variables. And there's the need to rename \n",
    "#them only once. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "pnad4thtrimester2020selectedcolumns = pnad4thtrimester2020[['V2001','V2003','V2005','V2007']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\andre\\Anaconda3\\lib\\site-packages\\pandas\\core\\frame.py:4441: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  return super().rename(\n"
     ]
    }
   ],
   "source": [
    "pnad4thtrimester2020selectedcolumns.rename({'V2001':'numberofhouseholds', 'V2003': 'ordernumber','V2005': 'relationtohousehold', 'V2007':'sex'}, axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>numberofhouseholds</th>\n",
       "      <th>ordernumber</th>\n",
       "      <th>relationtohousehold</th>\n",
       "      <th>sex</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>06</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06</td>\n",
       "      <td>02</td>\n",
       "      <td>05</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>06</td>\n",
       "      <td>03</td>\n",
       "      <td>05</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>08</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>06</td>\n",
       "      <td>05</td>\n",
       "      <td>08</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335561</th>\n",
       "      <td>02</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335562</th>\n",
       "      <td>02</td>\n",
       "      <td>02</td>\n",
       "      <td>02</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335563</th>\n",
       "      <td>03</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335564</th>\n",
       "      <td>03</td>\n",
       "      <td>02</td>\n",
       "      <td>02</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335565</th>\n",
       "      <td>03</td>\n",
       "      <td>03</td>\n",
       "      <td>04</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>335566 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       numberofhouseholds ordernumber relationtohousehold sex\n",
       "0                      06          01                  01   2\n",
       "1                      06          02                  05   2\n",
       "2                      06          03                  05   2\n",
       "3                      06          04                  08   1\n",
       "4                      06          05                  08   2\n",
       "...                   ...         ...                 ...  ..\n",
       "335561                 02          01                  01   1\n",
       "335562                 02          02                  02   2\n",
       "335563                 03          01                  01   1\n",
       "335564                 03          02                  02   2\n",
       "335565                 03          03                  04   2\n",
       "\n",
       "[335566 rows x 4 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pnad4thtrimester2020selectedcolumns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "#There's also the need to look at the dictionary in order to interpret, for example, sex has number 1 or 2, according to the \n",
    "#dictionary 1 is masculine and 2 is feminine. These four selected variables is just for an example, any variable can be chosen."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Part of this code I found [here](https://medium.com/data-hackers/microdados-em-python-um-pacote-para-ler-dados-da-pnad-e-pof-e254cf18477d). The library mentioned on the link does not work for the year 2020, the year that I needed. I also found another [page](https://gist.github.com/jpmvbastos/d20e91d3a49c655af815c8188059f4ff) with python code to open pnad, but it did not work for me. "
   ]
  },
  {
   "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.8.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}