Intro To DS Asssignmt  2 Answer.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "os.chdir(\"C:/Users/LILENDAR/Desktop/Python Directory\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th># Summer</th>\n",
       "      <th>Gold</th>\n",
       "      <th>Silver</th>\n",
       "      <th>Bronze</th>\n",
       "      <th>Total</th>\n",
       "      <th># Winter</th>\n",
       "      <th>Gold.1</th>\n",
       "      <th>Silver.1</th>\n",
       "      <th>Bronze.1</th>\n",
       "      <th>Total.1</th>\n",
       "      <th># Games</th>\n",
       "      <th>Gold.2</th>\n",
       "      <th>Silver.2</th>\n",
       "      <th>Bronze.2</th>\n",
       "      <th>Combined total</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>AFG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>ALG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Argentina</th>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>18</td>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Armenia</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>ARM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australasia</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>ANZ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             # Summer  Gold  Silver  Bronze  Total  # Winter  Gold.1  \\\n",
       "Afghanistan        13     0       0       2      2         0       0   \n",
       "Algeria            12     5       2       8     15         3       0   \n",
       "Argentina          23    18      24      28     70        18       0   \n",
       "Armenia             5     1       2       9     12         6       0   \n",
       "Australasia         2     3       4       5     12         0       0   \n",
       "\n",
       "             Silver.1  Bronze.1  Total.1  # Games  Gold.2  Silver.2  Bronze.2  \\\n",
       "Afghanistan         0         0        0       13       0         0         2   \n",
       "Algeria             0         0        0       15       5         2         8   \n",
       "Argentina           0         0        0       41      18        24        28   \n",
       "Armenia             0         0        0       11       1         2         9   \n",
       "Australasia         0         0        0        2       3         4         5   \n",
       "\n",
       "             Combined total   ID  \n",
       "Afghanistan               2  AFG  \n",
       "Algeria                  15  ALG  \n",
       "Argentina                70  ARG  \n",
       "Armenia                  12  ARM  \n",
       "Australasia              12  ANZ  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('olympics.csv', index_col=0, skiprows=1)\n",
    "\n",
    "for col in df.columns:\n",
    "    if col[:2]=='01':\n",
    "        df.rename(columns={col:'Gold'+col[4:]}, inplace=True)\n",
    "    if col[:2]=='02':\n",
    "        df.rename(columns={col:'Silver'+col[4:]}, inplace=True)\n",
    "    if col[:2]=='03':\n",
    "        df.rename(columns={col:'Bronze'+col[4:]}, inplace=True)\n",
    "    if col[:1]=='№':\n",
    "        df.rename(columns={col:'#'+col[1:]}, inplace=True)\n",
    "\n",
    "names_ids = df.index.str.split('\\s\\(') # split the index by '('\n",
    "\n",
    "df.index = names_ids.str[0] # the [0] element is the country name (new index) \n",
    "df['ID'] = names_ids.str[1].str[:3] # the [1] element is the abbreviation or ID (take first 3 characters from that)\n",
    "\n",
    "df = df.drop('Totals')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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># Summer</th>\n",
       "      <th>Gold</th>\n",
       "      <th>Silver</th>\n",
       "      <th>Bronze</th>\n",
       "      <th>Total</th>\n",
       "      <th># Winter</th>\n",
       "      <th>Gold.1</th>\n",
       "      <th>Silver.1</th>\n",
       "      <th>Bronze.1</th>\n",
       "      <th>Total.1</th>\n",
       "      <th># Games</th>\n",
       "      <th>Gold.2</th>\n",
       "      <th>Silver.2</th>\n",
       "      <th>Bronze.2</th>\n",
       "      <th>Combined total</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>AFG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>ALG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Argentina</th>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>18</td>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "      <td>ARG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Armenia</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>ARM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australasia</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>ANZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>25</td>\n",
       "      <td>139</td>\n",
       "      <td>152</td>\n",
       "      <td>177</td>\n",
       "      <td>468</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>43</td>\n",
       "      <td>144</td>\n",
       "      <td>155</td>\n",
       "      <td>181</td>\n",
       "      <td>480</td>\n",
       "      <td>AUS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Austria</th>\n",
       "      <td>26</td>\n",
       "      <td>18</td>\n",
       "      <td>33</td>\n",
       "      <td>35</td>\n",
       "      <td>86</td>\n",
       "      <td>22</td>\n",
       "      <td>59</td>\n",
       "      <td>78</td>\n",
       "      <td>81</td>\n",
       "      <td>218</td>\n",
       "      <td>48</td>\n",
       "      <td>77</td>\n",
       "      <td>111</td>\n",
       "      <td>116</td>\n",
       "      <td>304</td>\n",
       "      <td>AUT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Azerbaijan</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>26</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>26</td>\n",
       "      <td>AZE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bahamas</th>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>BAH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bahrain</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BRN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Barbados</th>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belarus</th>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>39</td>\n",
       "      <td>75</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>28</td>\n",
       "      <td>44</td>\n",
       "      <td>90</td>\n",
       "      <td>BLR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belgium</th>\n",
       "      <td>25</td>\n",
       "      <td>37</td>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>142</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>45</td>\n",
       "      <td>38</td>\n",
       "      <td>53</td>\n",
       "      <td>56</td>\n",
       "      <td>147</td>\n",
       "      <td>BEL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bermuda</th>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>BER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bohemia</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>BOH</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             # Summer  Gold  Silver  Bronze  Total  # Winter  Gold.1  \\\n",
       "Afghanistan        13     0       0       2      2         0       0   \n",
       "Algeria            12     5       2       8     15         3       0   \n",
       "Argentina          23    18      24      28     70        18       0   \n",
       "Armenia             5     1       2       9     12         6       0   \n",
       "Australasia         2     3       4       5     12         0       0   \n",
       "Australia          25   139     152     177    468        18       5   \n",
       "Austria            26    18      33      35     86        22      59   \n",
       "Azerbaijan          5     6       5      15     26         5       0   \n",
       "Bahamas            15     5       2       5     12         0       0   \n",
       "Bahrain             8     0       0       1      1         0       0   \n",
       "Barbados           11     0       0       1      1         0       0   \n",
       "Belarus             5    12      24      39     75         6       6   \n",
       "Belgium            25    37      52      53    142        20       1   \n",
       "Bermuda            17     0       0       1      1         7       0   \n",
       "Bohemia             3     0       1       3      4         0       0   \n",
       "\n",
       "             Silver.1  Bronze.1  Total.1  # Games  Gold.2  Silver.2  Bronze.2  \\\n",
       "Afghanistan         0         0        0       13       0         0         2   \n",
       "Algeria             0         0        0       15       5         2         8   \n",
       "Argentina           0         0        0       41      18        24        28   \n",
       "Armenia             0         0        0       11       1         2         9   \n",
       "Australasia         0         0        0        2       3         4         5   \n",
       "Australia           3         4       12       43     144       155       181   \n",
       "Austria            78        81      218       48      77       111       116   \n",
       "Azerbaijan          0         0        0       10       6         5        15   \n",
       "Bahamas             0         0        0       15       5         2         5   \n",
       "Bahrain             0         0        0        8       0         0         1   \n",
       "Barbados            0         0        0       11       0         0         1   \n",
       "Belarus             4         5       15       11      18        28        44   \n",
       "Belgium             1         3        5       45      38        53        56   \n",
       "Bermuda             0         0        0       24       0         0         1   \n",
       "Bohemia             0         0        0        3       0         1         3   \n",
       "\n",
       "             Combined total   ID  \n",
       "Afghanistan               2  AFG  \n",
       "Algeria                  15  ALG  \n",
       "Argentina                70  ARG  \n",
       "Armenia                  12  ARM  \n",
       "Australasia              12  ANZ  \n",
       "Australia               480  AUS  \n",
       "Austria                 304  AUT  \n",
       "Azerbaijan               26  AZE  \n",
       "Bahamas                  12  BAH  \n",
       "Bahrain                   1  BRN  \n",
       "Barbados                  1  BAR  \n",
       "Belarus                  90  BLR  \n",
       "Belgium                 147  BEL  \n",
       "Bermuda                   1  BER  \n",
       "Bohemia                   4  BOH  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\LILENDAR\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\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",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'Bulgaria'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_one():\n",
    "    only_gold=df[(df['Gold']>0)&(df['Gold.1']>0)]\n",
    "    only_gold['Difference']=(abs(only_gold['Gold']-only_gold['Gold.1']))/only_gold['Gold.2']\n",
    "    return only_gold['Difference'].idxmax()\n",
    "answer_one()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Afghanistan                           2\n",
       "Algeria                              27\n",
       "Argentina                           130\n",
       "Armenia                              16\n",
       "Australasia                          22\n",
       "                                   ... \n",
       "Yugoslavia                          171\n",
       "Independent Olympic Participants      4\n",
       "Zambia                                3\n",
       "Zimbabwe                             18\n",
       "Mixed team                           38\n",
       "Name: Points, Length: 146, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer():\n",
    "    df['Points']=df['Gold.2']*3+df['Silver.2']*2+df['Bronze.2']*1\n",
    "    return df['Points']\n",
    "answer()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def answer_three():\n",
    "    k=[]\n",
    "    data1=df[(df['Gold']>1)&(df['Gold.1']>1)]\n",
    "\n",
    "    for i in range(len(data1[\"Gold\"])):\n",
    "\n",
    "    \n",
    "        diff=data1[\"Gold\"][i]-data1[\"Gold.1\"][i]\n",
    "        summ=data1[\"Gold\"][i]+data1[\"Gold.1\"][i]\n",
    "        p=abs(diff/summ)\n",
    "        k.append(p)\n",
    "        \n",
    "    country=data1.index[k.index(max(k))]\n",
    "    return country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Australia'"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "answer_three()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>STATE</th>\n",
       "      <th>COUNTY</th>\n",
       "      <th>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "      <th>CENSUS2010POP</th>\n",
       "      <th>ESTIMATESBASE2010</th>\n",
       "      <th>POPESTIMATE2010</th>\n",
       "      <th>...</th>\n",
       "      <th>RDOMESTICMIG2011</th>\n",
       "      <th>RDOMESTICMIG2012</th>\n",
       "      <th>RDOMESTICMIG2013</th>\n",
       "      <th>RDOMESTICMIG2014</th>\n",
       "      <th>RDOMESTICMIG2015</th>\n",
       "      <th>RNETMIG2011</th>\n",
       "      <th>RNETMIG2012</th>\n",
       "      <th>RNETMIG2013</th>\n",
       "      <th>RNETMIG2014</th>\n",
       "      <th>RNETMIG2015</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>4779736</td>\n",
       "      <td>4780127</td>\n",
       "      <td>4785161</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002295</td>\n",
       "      <td>-0.193196</td>\n",
       "      <td>0.381066</td>\n",
       "      <td>0.582002</td>\n",
       "      <td>-0.467369</td>\n",
       "      <td>1.030015</td>\n",
       "      <td>0.826644</td>\n",
       "      <td>1.383282</td>\n",
       "      <td>1.724718</td>\n",
       "      <td>0.712594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Autauga County</td>\n",
       "      <td>54571</td>\n",
       "      <td>54571</td>\n",
       "      <td>54660</td>\n",
       "      <td>...</td>\n",
       "      <td>7.242091</td>\n",
       "      <td>-2.915927</td>\n",
       "      <td>-3.012349</td>\n",
       "      <td>2.265971</td>\n",
       "      <td>-2.530799</td>\n",
       "      <td>7.606016</td>\n",
       "      <td>-2.626146</td>\n",
       "      <td>-2.722002</td>\n",
       "      <td>2.592270</td>\n",
       "      <td>-2.187333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Baldwin County</td>\n",
       "      <td>182265</td>\n",
       "      <td>182265</td>\n",
       "      <td>183193</td>\n",
       "      <td>...</td>\n",
       "      <td>14.832960</td>\n",
       "      <td>17.647293</td>\n",
       "      <td>21.845705</td>\n",
       "      <td>19.243287</td>\n",
       "      <td>17.197872</td>\n",
       "      <td>15.844176</td>\n",
       "      <td>18.559627</td>\n",
       "      <td>22.727626</td>\n",
       "      <td>20.317142</td>\n",
       "      <td>18.293499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Barbour County</td>\n",
       "      <td>27457</td>\n",
       "      <td>27457</td>\n",
       "      <td>27341</td>\n",
       "      <td>...</td>\n",
       "      <td>-4.728132</td>\n",
       "      <td>-2.500690</td>\n",
       "      <td>-7.056824</td>\n",
       "      <td>-3.904217</td>\n",
       "      <td>-10.543299</td>\n",
       "      <td>-4.874741</td>\n",
       "      <td>-2.758113</td>\n",
       "      <td>-7.167664</td>\n",
       "      <td>-3.978583</td>\n",
       "      <td>-10.543299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bibb County</td>\n",
       "      <td>22915</td>\n",
       "      <td>22919</td>\n",
       "      <td>22861</td>\n",
       "      <td>...</td>\n",
       "      <td>-5.527043</td>\n",
       "      <td>-5.068871</td>\n",
       "      <td>-6.201001</td>\n",
       "      <td>-0.177537</td>\n",
       "      <td>0.177258</td>\n",
       "      <td>-5.088389</td>\n",
       "      <td>-4.363636</td>\n",
       "      <td>-5.403729</td>\n",
       "      <td>0.754533</td>\n",
       "      <td>1.107861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Blount County</td>\n",
       "      <td>57322</td>\n",
       "      <td>57322</td>\n",
       "      <td>57373</td>\n",
       "      <td>...</td>\n",
       "      <td>1.807375</td>\n",
       "      <td>-1.177622</td>\n",
       "      <td>-1.748766</td>\n",
       "      <td>-2.062535</td>\n",
       "      <td>-1.369970</td>\n",
       "      <td>1.859511</td>\n",
       "      <td>-0.848580</td>\n",
       "      <td>-1.402476</td>\n",
       "      <td>-1.577232</td>\n",
       "      <td>-0.884411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Bullock County</td>\n",
       "      <td>10914</td>\n",
       "      <td>10915</td>\n",
       "      <td>10887</td>\n",
       "      <td>...</td>\n",
       "      <td>-30.953709</td>\n",
       "      <td>-5.180127</td>\n",
       "      <td>-1.130263</td>\n",
       "      <td>14.354290</td>\n",
       "      <td>-16.167247</td>\n",
       "      <td>-29.001673</td>\n",
       "      <td>-2.825524</td>\n",
       "      <td>1.507017</td>\n",
       "      <td>17.243790</td>\n",
       "      <td>-13.193961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Butler County</td>\n",
       "      <td>20947</td>\n",
       "      <td>20946</td>\n",
       "      <td>20944</td>\n",
       "      <td>...</td>\n",
       "      <td>-14.032727</td>\n",
       "      <td>-11.684234</td>\n",
       "      <td>-5.655413</td>\n",
       "      <td>1.085428</td>\n",
       "      <td>-6.529805</td>\n",
       "      <td>-13.936612</td>\n",
       "      <td>-11.586865</td>\n",
       "      <td>-5.557058</td>\n",
       "      <td>1.184103</td>\n",
       "      <td>-6.430868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Calhoun County</td>\n",
       "      <td>118572</td>\n",
       "      <td>118586</td>\n",
       "      <td>118437</td>\n",
       "      <td>...</td>\n",
       "      <td>-6.155670</td>\n",
       "      <td>-4.611706</td>\n",
       "      <td>-5.524649</td>\n",
       "      <td>-4.463211</td>\n",
       "      <td>-3.376322</td>\n",
       "      <td>-5.791579</td>\n",
       "      <td>-4.092677</td>\n",
       "      <td>-5.062836</td>\n",
       "      <td>-3.912834</td>\n",
       "      <td>-2.806406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chambers County</td>\n",
       "      <td>34215</td>\n",
       "      <td>34170</td>\n",
       "      <td>34098</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.731639</td>\n",
       "      <td>3.849092</td>\n",
       "      <td>2.872721</td>\n",
       "      <td>-2.287222</td>\n",
       "      <td>1.349468</td>\n",
       "      <td>-1.821092</td>\n",
       "      <td>4.701181</td>\n",
       "      <td>3.781439</td>\n",
       "      <td>-1.290228</td>\n",
       "      <td>2.346901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cherokee County</td>\n",
       "      <td>25989</td>\n",
       "      <td>25986</td>\n",
       "      <td>25976</td>\n",
       "      <td>...</td>\n",
       "      <td>6.339327</td>\n",
       "      <td>1.113180</td>\n",
       "      <td>5.488706</td>\n",
       "      <td>-0.076806</td>\n",
       "      <td>-3.239866</td>\n",
       "      <td>6.416167</td>\n",
       "      <td>1.420264</td>\n",
       "      <td>5.757384</td>\n",
       "      <td>0.230419</td>\n",
       "      <td>-2.931307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Chilton County</td>\n",
       "      <td>43643</td>\n",
       "      <td>43631</td>\n",
       "      <td>43665</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.372935</td>\n",
       "      <td>-2.653369</td>\n",
       "      <td>0.480044</td>\n",
       "      <td>0.456017</td>\n",
       "      <td>-2.253483</td>\n",
       "      <td>-0.823761</td>\n",
       "      <td>-2.447504</td>\n",
       "      <td>0.868651</td>\n",
       "      <td>0.957636</td>\n",
       "      <td>-1.752709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Choctaw County</td>\n",
       "      <td>13859</td>\n",
       "      <td>13858</td>\n",
       "      <td>13841</td>\n",
       "      <td>...</td>\n",
       "      <td>-15.455274</td>\n",
       "      <td>-0.737028</td>\n",
       "      <td>-8.766391</td>\n",
       "      <td>-1.274984</td>\n",
       "      <td>-5.291205</td>\n",
       "      <td>-15.528177</td>\n",
       "      <td>-0.737028</td>\n",
       "      <td>-8.766391</td>\n",
       "      <td>-1.274984</td>\n",
       "      <td>-5.291205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clarke County</td>\n",
       "      <td>25833</td>\n",
       "      <td>25840</td>\n",
       "      <td>25767</td>\n",
       "      <td>...</td>\n",
       "      <td>-6.194363</td>\n",
       "      <td>-17.667705</td>\n",
       "      <td>-0.318345</td>\n",
       "      <td>-8.686428</td>\n",
       "      <td>-5.613667</td>\n",
       "      <td>-6.077488</td>\n",
       "      <td>-17.509958</td>\n",
       "      <td>-0.159172</td>\n",
       "      <td>-8.486280</td>\n",
       "      <td>-5.411736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Clay County</td>\n",
       "      <td>13932</td>\n",
       "      <td>13932</td>\n",
       "      <td>13880</td>\n",
       "      <td>...</td>\n",
       "      <td>-10.744102</td>\n",
       "      <td>-13.345130</td>\n",
       "      <td>4.902871</td>\n",
       "      <td>5.702648</td>\n",
       "      <td>3.912450</td>\n",
       "      <td>-10.816697</td>\n",
       "      <td>-13.345130</td>\n",
       "      <td>4.977157</td>\n",
       "      <td>5.776708</td>\n",
       "      <td>3.986270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cleburne County</td>\n",
       "      <td>14972</td>\n",
       "      <td>14972</td>\n",
       "      <td>14973</td>\n",
       "      <td>...</td>\n",
       "      <td>-3.673524</td>\n",
       "      <td>-5.151880</td>\n",
       "      <td>7.345821</td>\n",
       "      <td>3.654485</td>\n",
       "      <td>-3.123961</td>\n",
       "      <td>-3.673524</td>\n",
       "      <td>-5.151880</td>\n",
       "      <td>7.345821</td>\n",
       "      <td>3.654485</td>\n",
       "      <td>-3.123961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>31</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coffee County</td>\n",
       "      <td>49948</td>\n",
       "      <td>49948</td>\n",
       "      <td>50177</td>\n",
       "      <td>...</td>\n",
       "      <td>0.377640</td>\n",
       "      <td>7.675579</td>\n",
       "      <td>-13.146535</td>\n",
       "      <td>-3.602859</td>\n",
       "      <td>2.214774</td>\n",
       "      <td>2.166460</td>\n",
       "      <td>11.513368</td>\n",
       "      <td>-10.438741</td>\n",
       "      <td>-0.767822</td>\n",
       "      <td>5.350738</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Colbert County</td>\n",
       "      <td>54428</td>\n",
       "      <td>54428</td>\n",
       "      <td>54514</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.073423</td>\n",
       "      <td>1.065051</td>\n",
       "      <td>1.762390</td>\n",
       "      <td>1.835688</td>\n",
       "      <td>-0.110260</td>\n",
       "      <td>0.513964</td>\n",
       "      <td>1.469035</td>\n",
       "      <td>2.276420</td>\n",
       "      <td>2.533249</td>\n",
       "      <td>0.588052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Conecuh County</td>\n",
       "      <td>13228</td>\n",
       "      <td>13228</td>\n",
       "      <td>13208</td>\n",
       "      <td>...</td>\n",
       "      <td>-4.861559</td>\n",
       "      <td>-7.504690</td>\n",
       "      <td>-6.107224</td>\n",
       "      <td>-14.645416</td>\n",
       "      <td>2.684140</td>\n",
       "      <td>-4.861559</td>\n",
       "      <td>-7.504690</td>\n",
       "      <td>-6.107224</td>\n",
       "      <td>-14.645416</td>\n",
       "      <td>2.684140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Coosa County</td>\n",
       "      <td>11539</td>\n",
       "      <td>11758</td>\n",
       "      <td>11758</td>\n",
       "      <td>...</td>\n",
       "      <td>-33.930581</td>\n",
       "      <td>-10.291443</td>\n",
       "      <td>-4.313831</td>\n",
       "      <td>-22.958017</td>\n",
       "      <td>-5.387581</td>\n",
       "      <td>-34.017138</td>\n",
       "      <td>-10.380162</td>\n",
       "      <td>-4.403703</td>\n",
       "      <td>-23.049483</td>\n",
       "      <td>-5.387581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Covington County</td>\n",
       "      <td>37765</td>\n",
       "      <td>37765</td>\n",
       "      <td>37796</td>\n",
       "      <td>...</td>\n",
       "      <td>6.696899</td>\n",
       "      <td>-4.612668</td>\n",
       "      <td>0.740271</td>\n",
       "      <td>3.697932</td>\n",
       "      <td>-0.316945</td>\n",
       "      <td>6.881460</td>\n",
       "      <td>-4.559952</td>\n",
       "      <td>0.793147</td>\n",
       "      <td>3.750759</td>\n",
       "      <td>-0.264121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Crenshaw County</td>\n",
       "      <td>13906</td>\n",
       "      <td>13906</td>\n",
       "      <td>13853</td>\n",
       "      <td>...</td>\n",
       "      <td>1.729792</td>\n",
       "      <td>3.950156</td>\n",
       "      <td>-1.864936</td>\n",
       "      <td>3.084648</td>\n",
       "      <td>3.439504</td>\n",
       "      <td>2.666763</td>\n",
       "      <td>5.099293</td>\n",
       "      <td>-0.502098</td>\n",
       "      <td>4.734577</td>\n",
       "      <td>5.087600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Cullman County</td>\n",
       "      <td>80406</td>\n",
       "      <td>80410</td>\n",
       "      <td>80473</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.404233</td>\n",
       "      <td>-1.019628</td>\n",
       "      <td>4.071247</td>\n",
       "      <td>5.087142</td>\n",
       "      <td>7.915406</td>\n",
       "      <td>-1.031427</td>\n",
       "      <td>-0.634159</td>\n",
       "      <td>4.542916</td>\n",
       "      <td>5.593387</td>\n",
       "      <td>8.417777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dale County</td>\n",
       "      <td>50251</td>\n",
       "      <td>50251</td>\n",
       "      <td>50358</td>\n",
       "      <td>...</td>\n",
       "      <td>-10.749798</td>\n",
       "      <td>-5.277150</td>\n",
       "      <td>-15.236079</td>\n",
       "      <td>-11.979785</td>\n",
       "      <td>-5.107706</td>\n",
       "      <td>-9.575283</td>\n",
       "      <td>-0.776637</td>\n",
       "      <td>-12.640155</td>\n",
       "      <td>-9.503292</td>\n",
       "      <td>-1.998668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>47</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Dallas County</td>\n",
       "      <td>43820</td>\n",
       "      <td>43820</td>\n",
       "      <td>43803</td>\n",
       "      <td>...</td>\n",
       "      <td>-15.635599</td>\n",
       "      <td>-11.308243</td>\n",
       "      <td>-16.745678</td>\n",
       "      <td>-9.344789</td>\n",
       "      <td>-14.687232</td>\n",
       "      <td>-15.727573</td>\n",
       "      <td>-11.378047</td>\n",
       "      <td>-16.792849</td>\n",
       "      <td>-9.368689</td>\n",
       "      <td>-14.711389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>DeKalb County</td>\n",
       "      <td>71109</td>\n",
       "      <td>71115</td>\n",
       "      <td>71142</td>\n",
       "      <td>...</td>\n",
       "      <td>0.294677</td>\n",
       "      <td>-9.302391</td>\n",
       "      <td>-1.748807</td>\n",
       "      <td>0.267830</td>\n",
       "      <td>0.028141</td>\n",
       "      <td>1.375159</td>\n",
       "      <td>-8.656001</td>\n",
       "      <td>-1.029539</td>\n",
       "      <td>1.198187</td>\n",
       "      <td>0.956790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>51</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Elmore County</td>\n",
       "      <td>79303</td>\n",
       "      <td>79296</td>\n",
       "      <td>79465</td>\n",
       "      <td>...</td>\n",
       "      <td>3.235576</td>\n",
       "      <td>0.822717</td>\n",
       "      <td>1.760531</td>\n",
       "      <td>-1.507057</td>\n",
       "      <td>2.067820</td>\n",
       "      <td>3.674511</td>\n",
       "      <td>1.558176</td>\n",
       "      <td>2.306047</td>\n",
       "      <td>-0.951175</td>\n",
       "      <td>2.757093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Escambia County</td>\n",
       "      <td>38319</td>\n",
       "      <td>38319</td>\n",
       "      <td>38309</td>\n",
       "      <td>...</td>\n",
       "      <td>-3.449988</td>\n",
       "      <td>-3.855889</td>\n",
       "      <td>-4.822706</td>\n",
       "      <td>-1.189831</td>\n",
       "      <td>1.190902</td>\n",
       "      <td>-3.397716</td>\n",
       "      <td>-3.803428</td>\n",
       "      <td>-4.769999</td>\n",
       "      <td>-1.136950</td>\n",
       "      <td>1.243830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Etowah County</td>\n",
       "      <td>104430</td>\n",
       "      <td>104427</td>\n",
       "      <td>104442</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.015919</td>\n",
       "      <td>2.062637</td>\n",
       "      <td>-1.931884</td>\n",
       "      <td>-1.726932</td>\n",
       "      <td>-2.082234</td>\n",
       "      <td>-0.632554</td>\n",
       "      <td>2.446383</td>\n",
       "      <td>-1.518596</td>\n",
       "      <td>-1.234901</td>\n",
       "      <td>-1.588308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>50</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>57</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>Fayette County</td>\n",
       "      <td>17241</td>\n",
       "      <td>17241</td>\n",
       "      <td>17231</td>\n",
       "      <td>...</td>\n",
       "      <td>-5.015601</td>\n",
       "      <td>-0.646640</td>\n",
       "      <td>-3.725937</td>\n",
       "      <td>0.296745</td>\n",
       "      <td>-2.797536</td>\n",
       "      <td>-5.132243</td>\n",
       "      <td>-0.705426</td>\n",
       "      <td>-3.785079</td>\n",
       "      <td>0.237396</td>\n",
       "      <td>-2.857058</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30 rows × 100 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    SUMLEV  REGION  DIVISION  STATE  COUNTY   STNAME           CTYNAME  \\\n",
       "0       40       3         6      1       0  Alabama           Alabama   \n",
       "1       50       3         6      1       1  Alabama    Autauga County   \n",
       "2       50       3         6      1       3  Alabama    Baldwin County   \n",
       "3       50       3         6      1       5  Alabama    Barbour County   \n",
       "4       50       3         6      1       7  Alabama       Bibb County   \n",
       "5       50       3         6      1       9  Alabama     Blount County   \n",
       "6       50       3         6      1      11  Alabama    Bullock County   \n",
       "7       50       3         6      1      13  Alabama     Butler County   \n",
       "8       50       3         6      1      15  Alabama    Calhoun County   \n",
       "9       50       3         6      1      17  Alabama   Chambers County   \n",
       "10      50       3         6      1      19  Alabama   Cherokee County   \n",
       "11      50       3         6      1      21  Alabama    Chilton County   \n",
       "12      50       3         6      1      23  Alabama    Choctaw County   \n",
       "13      50       3         6      1      25  Alabama     Clarke County   \n",
       "14      50       3         6      1      27  Alabama       Clay County   \n",
       "15      50       3         6      1      29  Alabama   Cleburne County   \n",
       "16      50       3         6      1      31  Alabama     Coffee County   \n",
       "17      50       3         6      1      33  Alabama    Colbert County   \n",
       "18      50       3         6      1      35  Alabama    Conecuh County   \n",
       "19      50       3         6      1      37  Alabama      Coosa County   \n",
       "20      50       3         6      1      39  Alabama  Covington County   \n",
       "21      50       3         6      1      41  Alabama   Crenshaw County   \n",
       "22      50       3         6      1      43  Alabama    Cullman County   \n",
       "23      50       3         6      1      45  Alabama       Dale County   \n",
       "24      50       3         6      1      47  Alabama     Dallas County   \n",
       "25      50       3         6      1      49  Alabama     DeKalb County   \n",
       "26      50       3         6      1      51  Alabama     Elmore County   \n",
       "27      50       3         6      1      53  Alabama   Escambia County   \n",
       "28      50       3         6      1      55  Alabama     Etowah County   \n",
       "29      50       3         6      1      57  Alabama    Fayette County   \n",
       "\n",
       "    CENSUS2010POP  ESTIMATESBASE2010  POPESTIMATE2010  ...  RDOMESTICMIG2011  \\\n",
       "0         4779736            4780127          4785161  ...          0.002295   \n",
       "1           54571              54571            54660  ...          7.242091   \n",
       "2          182265             182265           183193  ...         14.832960   \n",
       "3           27457              27457            27341  ...         -4.728132   \n",
       "4           22915              22919            22861  ...         -5.527043   \n",
       "5           57322              57322            57373  ...          1.807375   \n",
       "6           10914              10915            10887  ...        -30.953709   \n",
       "7           20947              20946            20944  ...        -14.032727   \n",
       "8          118572             118586           118437  ...         -6.155670   \n",
       "9           34215              34170            34098  ...         -2.731639   \n",
       "10          25989              25986            25976  ...          6.339327   \n",
       "11          43643              43631            43665  ...         -1.372935   \n",
       "12          13859              13858            13841  ...        -15.455274   \n",
       "13          25833              25840            25767  ...         -6.194363   \n",
       "14          13932              13932            13880  ...        -10.744102   \n",
       "15          14972              14972            14973  ...         -3.673524   \n",
       "16          49948              49948            50177  ...          0.377640   \n",
       "17          54428              54428            54514  ...         -0.073423   \n",
       "18          13228              13228            13208  ...         -4.861559   \n",
       "19          11539              11758            11758  ...        -33.930581   \n",
       "20          37765              37765            37796  ...          6.696899   \n",
       "21          13906              13906            13853  ...          1.729792   \n",
       "22          80406              80410            80473  ...         -1.404233   \n",
       "23          50251              50251            50358  ...        -10.749798   \n",
       "24          43820              43820            43803  ...        -15.635599   \n",
       "25          71109              71115            71142  ...          0.294677   \n",
       "26          79303              79296            79465  ...          3.235576   \n",
       "27          38319              38319            38309  ...         -3.449988   \n",
       "28         104430             104427           104442  ...         -1.015919   \n",
       "29          17241              17241            17231  ...         -5.015601   \n",
       "\n",
       "    RDOMESTICMIG2012  RDOMESTICMIG2013  RDOMESTICMIG2014  RDOMESTICMIG2015  \\\n",
       "0          -0.193196          0.381066          0.582002         -0.467369   \n",
       "1          -2.915927         -3.012349          2.265971         -2.530799   \n",
       "2          17.647293         21.845705         19.243287         17.197872   \n",
       "3          -2.500690         -7.056824         -3.904217        -10.543299   \n",
       "4          -5.068871         -6.201001         -0.177537          0.177258   \n",
       "5          -1.177622         -1.748766         -2.062535         -1.369970   \n",
       "6          -5.180127         -1.130263         14.354290        -16.167247   \n",
       "7         -11.684234         -5.655413          1.085428         -6.529805   \n",
       "8          -4.611706         -5.524649         -4.463211         -3.376322   \n",
       "9           3.849092          2.872721         -2.287222          1.349468   \n",
       "10          1.113180          5.488706         -0.076806         -3.239866   \n",
       "11         -2.653369          0.480044          0.456017         -2.253483   \n",
       "12         -0.737028         -8.766391         -1.274984         -5.291205   \n",
       "13        -17.667705         -0.318345         -8.686428         -5.613667   \n",
       "14        -13.345130          4.902871          5.702648          3.912450   \n",
       "15         -5.151880          7.345821          3.654485         -3.123961   \n",
       "16          7.675579        -13.146535         -3.602859          2.214774   \n",
       "17          1.065051          1.762390          1.835688         -0.110260   \n",
       "18         -7.504690         -6.107224        -14.645416          2.684140   \n",
       "19        -10.291443         -4.313831        -22.958017         -5.387581   \n",
       "20         -4.612668          0.740271          3.697932         -0.316945   \n",
       "21          3.950156         -1.864936          3.084648          3.439504   \n",
       "22         -1.019628          4.071247          5.087142          7.915406   \n",
       "23         -5.277150        -15.236079        -11.979785         -5.107706   \n",
       "24        -11.308243        -16.745678         -9.344789        -14.687232   \n",
       "25         -9.302391         -1.748807          0.267830          0.028141   \n",
       "26          0.822717          1.760531         -1.507057          2.067820   \n",
       "27         -3.855889         -4.822706         -1.189831          1.190902   \n",
       "28          2.062637         -1.931884         -1.726932         -2.082234   \n",
       "29         -0.646640         -3.725937          0.296745         -2.797536   \n",
       "\n",
       "    RNETMIG2011  RNETMIG2012  RNETMIG2013  RNETMIG2014  RNETMIG2015  \n",
       "0      1.030015     0.826644     1.383282     1.724718     0.712594  \n",
       "1      7.606016    -2.626146    -2.722002     2.592270    -2.187333  \n",
       "2     15.844176    18.559627    22.727626    20.317142    18.293499  \n",
       "3     -4.874741    -2.758113    -7.167664    -3.978583   -10.543299  \n",
       "4     -5.088389    -4.363636    -5.403729     0.754533     1.107861  \n",
       "5      1.859511    -0.848580    -1.402476    -1.577232    -0.884411  \n",
       "6    -29.001673    -2.825524     1.507017    17.243790   -13.193961  \n",
       "7    -13.936612   -11.586865    -5.557058     1.184103    -6.430868  \n",
       "8     -5.791579    -4.092677    -5.062836    -3.912834    -2.806406  \n",
       "9     -1.821092     4.701181     3.781439    -1.290228     2.346901  \n",
       "10     6.416167     1.420264     5.757384     0.230419    -2.931307  \n",
       "11    -0.823761    -2.447504     0.868651     0.957636    -1.752709  \n",
       "12   -15.528177    -0.737028    -8.766391    -1.274984    -5.291205  \n",
       "13    -6.077488   -17.509958    -0.159172    -8.486280    -5.411736  \n",
       "14   -10.816697   -13.345130     4.977157     5.776708     3.986270  \n",
       "15    -3.673524    -5.151880     7.345821     3.654485    -3.123961  \n",
       "16     2.166460    11.513368   -10.438741    -0.767822     5.350738  \n",
       "17     0.513964     1.469035     2.276420     2.533249     0.588052  \n",
       "18    -4.861559    -7.504690    -6.107224   -14.645416     2.684140  \n",
       "19   -34.017138   -10.380162    -4.403703   -23.049483    -5.387581  \n",
       "20     6.881460    -4.559952     0.793147     3.750759    -0.264121  \n",
       "21     2.666763     5.099293    -0.502098     4.734577     5.087600  \n",
       "22    -1.031427    -0.634159     4.542916     5.593387     8.417777  \n",
       "23    -9.575283    -0.776637   -12.640155    -9.503292    -1.998668  \n",
       "24   -15.727573   -11.378047   -16.792849    -9.368689   -14.711389  \n",
       "25     1.375159    -8.656001    -1.029539     1.198187     0.956790  \n",
       "26     3.674511     1.558176     2.306047    -0.951175     2.757093  \n",
       "27    -3.397716    -3.803428    -4.769999    -1.136950     1.243830  \n",
       "28    -0.632554     2.446383    -1.518596    -1.234901    -1.588308  \n",
       "29    -5.132243    -0.705426    -3.785079     0.237396    -2.857058  \n",
       "\n",
       "[30 rows x 100 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df = pd.read_csv('census.csv')\n",
    "census_df.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['California', 'Texas', 'Florida']"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_six(): \n",
    "    df1=census_df.sort_values(['STNAME','POPESTIMATE2015'], ascending=False).groupby('STNAME').head(3).copy()\n",
    "    df2=df1.reset_index().groupby('STNAME').sum().sort_values(['POPESTIMATE2015'], ascending=False).head(3).copy()\n",
    "    return list(df2.index)\n",
    "answer_six()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\LILENDAR\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\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",
      "  after removing the cwd from sys.path.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'Harris County'"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_seven():\n",
    "    df=census_df[census_df['SUMLEV']==50]\n",
    "    df['STDEV']=df[['POPESTIMATE2010','POPESTIMATE2011','POPESTIMATE2012','POPESTIMATE2013',\n",
    "                'POPESTIMATE2014','POPESTIMATE2015']].std(axis=1)\n",
    "    return df.loc[df['STDEV'].idxmax()]['CTYNAME']\n",
    "answer_seven()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>STNAME</th>\n",
       "      <th>CTYNAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>Iowa</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1419</th>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345</th>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2355</th>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3163</th>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>Washington County</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            STNAME            CTYNAME\n",
       "896           Iowa  Washington County\n",
       "1419     Minnesota  Washington County\n",
       "2345  Pennsylvania  Washington County\n",
       "2355  Rhode Island  Washington County\n",
       "3163     Wisconsin  Washington County"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_eight():\n",
    "    df=census_df[census_df['SUMLEV']==50]\n",
    "    region1=df['REGION']==1\n",
    "    region2=df['REGION']==2\n",
    "    country_name=df['CTYNAME'].str.startswith('Washington')\n",
    "    population=df['POPESTIMATE2015']>df['POPESTIMATE2014']\n",
    "    df=df[(region1|region2)&country_name&population]\n",
    "    return df[['STNAME','CTYNAME']]\n",
    "answer_eight()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Virginia'"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max_county=census_df.loc[census_df[\"COUNTY\"].idxmax()][\"STNAME\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "a=[x for x in census_df[\"STNAME\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['South Carolina',\n",
       " 'Nevada',\n",
       " 'New York',\n",
       " 'New Hampshire',\n",
       " 'Vermont',\n",
       " 'Maryland',\n",
       " 'Colorado',\n",
       " 'Pennsylvania',\n",
       " 'Illinois',\n",
       " 'Rhode Island',\n",
       " 'New Mexico',\n",
       " 'North Carolina',\n",
       " 'Texas',\n",
       " 'Delaware',\n",
       " 'California',\n",
       " 'North Dakota',\n",
       " 'Oregon',\n",
       " 'Hawaii',\n",
       " 'District of Columbia',\n",
       " 'Alabama',\n",
       " 'Virginia',\n",
       " 'Alaska',\n",
       " 'New Jersey',\n",
       " 'Maine',\n",
       " 'Kansas',\n",
       " 'Utah',\n",
       " 'Kentucky',\n",
       " 'Washington',\n",
       " 'Georgia',\n",
       " 'Mississippi',\n",
       " 'Oklahoma',\n",
       " 'Missouri',\n",
       " 'Minnesota',\n",
       " 'West Virginia',\n",
       " 'Montana',\n",
       " 'Tennessee',\n",
       " 'Connecticut',\n",
       " 'Arkansas',\n",
       " 'Wisconsin',\n",
       " 'Wyoming',\n",
       " 'Indiana',\n",
       " 'Ohio',\n",
       " 'Louisiana',\n",
       " 'Arizona',\n",
       " 'Iowa',\n",
       " 'Massachusetts',\n",
       " 'Idaho',\n",
       " 'Nebraska',\n",
       " 'South Dakota',\n",
       " 'Michigan',\n",
       " 'Florida']"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a=[x for x in census_df[\"STNAME\"]]\n",
    "b=set(a)\n",
    "c=list(b)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "South Carolina has occurred 47 times\n",
      "Nevada has occurred 18 times\n",
      "New York has occurred 63 times\n",
      "New Hampshire has occurred 11 times\n",
      "Vermont has occurred 15 times\n",
      "Maryland has occurred 25 times\n",
      "Colorado has occurred 65 times\n",
      "Pennsylvania has occurred 68 times\n",
      "Illinois has occurred 103 times\n",
      "Rhode Island has occurred 6 times\n",
      "New Mexico has occurred 34 times\n",
      "North Carolina has occurred 101 times\n",
      "Texas has occurred 255 times\n",
      "Delaware has occurred 4 times\n",
      "California has occurred 59 times\n",
      "North Dakota has occurred 54 times\n",
      "Oregon has occurred 37 times\n",
      "Hawaii has occurred 6 times\n",
      "District of Columbia has occurred 2 times\n",
      "Alabama has occurred 68 times\n",
      "Virginia has occurred 134 times\n",
      "Alaska has occurred 30 times\n",
      "New Jersey has occurred 22 times\n",
      "Maine has occurred 17 times\n",
      "Kansas has occurred 106 times\n",
      "Utah has occurred 30 times\n",
      "Kentucky has occurred 121 times\n",
      "Washington has occurred 40 times\n",
      "Georgia has occurred 160 times\n",
      "Mississippi has occurred 83 times\n",
      "Oklahoma has occurred 78 times\n",
      "Missouri has occurred 116 times\n",
      "Minnesota has occurred 88 times\n",
      "West Virginia has occurred 56 times\n",
      "Montana has occurred 57 times\n",
      "Tennessee has occurred 96 times\n",
      "Connecticut has occurred 9 times\n",
      "Arkansas has occurred 76 times\n",
      "Wisconsin has occurred 73 times\n",
      "Wyoming has occurred 24 times\n",
      "Indiana has occurred 93 times\n",
      "Ohio has occurred 89 times\n",
      "Louisiana has occurred 65 times\n",
      "Arizona has occurred 16 times\n",
      "Iowa has occurred 100 times\n",
      "Massachusetts has occurred 15 times\n",
      "Idaho has occurred 45 times\n",
      "Nebraska has occurred 94 times\n",
      "South Dakota has occurred 67 times\n",
      "Michigan has occurred 84 times\n",
      "Florida has occurred 68 times\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "255"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from collections import Counter \n",
    "  \n",
    "# driver program\n",
    "m=[]\n",
    "for x in c:\n",
    "    d = Counter(census_df[\"STNAME\"]) \n",
    "    print('{} has occurred {} times'.format(x, d[x]))\n",
    "    m.append(d[x])\n",
    "max(m)    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max(census_df[\"SUMLEV\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2990    750\n",
       "2991    760\n",
       "2992    770\n",
       "2993    775\n",
       "2994    790\n",
       "2995    800\n",
       "2996    810\n",
       "2997    820\n",
       "2998    830\n",
       "2999    840\n",
       "3000      0\n",
       "3001      1\n",
       "3002      3\n",
       "3003      5\n",
       "3004      7\n",
       "3005      9\n",
       "3006     11\n",
       "3007     13\n",
       "3008     15\n",
       "3009     17\n",
       "Name: COUNTY, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "census_df[\"COUNTY\"][2990:3010]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    SUMLEV                STNAME  count\n",
      "0       50               Alabama     67\n",
      "1       50                Alaska     29\n",
      "2       50               Arizona     15\n",
      "3       50              Arkansas     75\n",
      "4       50            California     58\n",
      "5       50              Colorado     64\n",
      "6       50           Connecticut      8\n",
      "7       50              Delaware      3\n",
      "8       50  District of Columbia      1\n",
      "9       50               Florida     67\n",
      "10      50               Georgia    159\n",
      "11      50                Hawaii      5\n",
      "12      50                 Idaho     44\n",
      "13      50              Illinois    102\n",
      "14      50               Indiana     92\n",
      "15      50                  Iowa     99\n",
      "16      50                Kansas    105\n",
      "17      50              Kentucky    120\n",
      "18      50             Louisiana     64\n",
      "19      50                 Maine     16\n",
      "20      50              Maryland     24\n",
      "21      50         Massachusetts     14\n",
      "22      50              Michigan     83\n",
      "23      50             Minnesota     87\n",
      "24      50           Mississippi     82\n",
      "25      50              Missouri    115\n",
      "26      50               Montana     56\n",
      "27      50              Nebraska     93\n",
      "28      50                Nevada     17\n",
      "29      50         New Hampshire     10\n",
      "30      50            New Jersey     21\n",
      "31      50            New Mexico     33\n",
      "32      50              New York     62\n",
      "33      50        North Carolina    100\n",
      "34      50          North Dakota     53\n",
      "35      50                  Ohio     88\n",
      "36      50              Oklahoma     77\n",
      "37      50                Oregon     36\n",
      "38      50          Pennsylvania     67\n",
      "39      50          Rhode Island      5\n",
      "40      50        South Carolina     46\n",
      "41      50          South Dakota     66\n",
      "42      50             Tennessee     95\n",
      "43      50                 Texas    254\n",
      "44      50                  Utah     29\n",
      "45      50               Vermont     14\n",
      "46      50              Virginia    133\n",
      "47      50            Washington     39\n",
      "48      50         West Virginia     55\n",
      "49      50             Wisconsin     72\n",
      "50      50               Wyoming     23\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'Texas'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def answer_five():\n",
    "    df=census_df[census_df['SUMLEV']==50]\n",
    "    df=df.groupby(['SUMLEV','STNAME']).size().to_frame(name='count').reset_index()\n",
    "    print(df)\n",
    "    return df.loc[df['count'].idxmax()]['STNAME']\n",
    "answer_five()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# class and inheritance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "class weight:\n",
    "    \n",
    "    def __init__(self,x,y):\n",
    "        \n",
    "        self.father=x\n",
    "        self.mother=y\n",
    "        \n",
    "        year2010=weight(60,50)\n",
    "        year2015=weight(61,51)\n",
    "        year2020=weight(63,52)\n",
    "        \n",
    "        def family_wt(self):\n",
    "            return self.father+self.mother\n",
    "        print(year2015.family_wt())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}