acs2019-michigan-data-cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "# Reading in my census data -- race by zip code\n",
    "# Source: https://censusreporter.org/data/table/?table=B02001&geo_ids=04000US26,860|04000US26&primary_geo_id=04000US26#\n",
    "df = pd.read_csv(\"csv/acs2019-race-zip-michigan-raw.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>geoid</th>\n",
       "      <th>name</th>\n",
       "      <th>B02001001</th>\n",
       "      <th>B02001001, Error</th>\n",
       "      <th>B02001002</th>\n",
       "      <th>B02001002, Error</th>\n",
       "      <th>B02001003</th>\n",
       "      <th>B02001003, Error</th>\n",
       "      <th>B02001004</th>\n",
       "      <th>B02001004, Error</th>\n",
       "      <th>...</th>\n",
       "      <th>B02001006</th>\n",
       "      <th>B02001006, Error</th>\n",
       "      <th>B02001007</th>\n",
       "      <th>B02001007, Error</th>\n",
       "      <th>B02001008</th>\n",
       "      <th>B02001008, Error</th>\n",
       "      <th>B02001009</th>\n",
       "      <th>B02001009, Error</th>\n",
       "      <th>B02001010</th>\n",
       "      <th>B02001010, Error</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>04000US26</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>9965265</td>\n",
       "      <td>0</td>\n",
       "      <td>7813755</td>\n",
       "      <td>4058</td>\n",
       "      <td>1374314</td>\n",
       "      <td>4050</td>\n",
       "      <td>53316</td>\n",
       "      <td>1913</td>\n",
       "      <td>...</td>\n",
       "      <td>3099</td>\n",
       "      <td>339</td>\n",
       "      <td>117801</td>\n",
       "      <td>3429</td>\n",
       "      <td>291259</td>\n",
       "      <td>5445</td>\n",
       "      <td>26495</td>\n",
       "      <td>1502</td>\n",
       "      <td>264764</td>\n",
       "      <td>5124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>86000US48001</td>\n",
       "      <td>48001</td>\n",
       "      <td>11903</td>\n",
       "      <td>92</td>\n",
       "      <td>11547</td>\n",
       "      <td>179</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>67</td>\n",
       "      <td>55</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>20</td>\n",
       "      <td>83</td>\n",
       "      <td>79</td>\n",
       "      <td>110</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>110</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>86000US48002</td>\n",
       "      <td>48002</td>\n",
       "      <td>3224</td>\n",
       "      <td>32</td>\n",
       "      <td>3183</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>41</td>\n",
       "      <td>28</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>35</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>86000US48003</td>\n",
       "      <td>48003</td>\n",
       "      <td>6047</td>\n",
       "      <td>179</td>\n",
       "      <td>5967</td>\n",
       "      <td>185</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>86000US48005</td>\n",
       "      <td>48005</td>\n",
       "      <td>5509</td>\n",
       "      <td>20</td>\n",
       "      <td>5341</td>\n",
       "      <td>82</td>\n",
       "      <td>42</td>\n",
       "      <td>49</td>\n",
       "      <td>21</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>95</td>\n",
       "      <td>54</td>\n",
       "      <td>16</td>\n",
       "      <td>25</td>\n",
       "      <td>79</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>86000US49969</td>\n",
       "      <td>49969</td>\n",
       "      <td>1259</td>\n",
       "      <td>138</td>\n",
       "      <td>885</td>\n",
       "      <td>116</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>312</td>\n",
       "      <td>60</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>86000US49970</td>\n",
       "      <td>49970</td>\n",
       "      <td>292</td>\n",
       "      <td>68</td>\n",
       "      <td>289</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>86000US49971</td>\n",
       "      <td>49971</td>\n",
       "      <td>478</td>\n",
       "      <td>87</td>\n",
       "      <td>455</td>\n",
       "      <td>83</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>86000US54540</td>\n",
       "      <td>54540</td>\n",
       "      <td>916</td>\n",
       "      <td>155</td>\n",
       "      <td>907</td>\n",
       "      <td>153</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>86000US54554</td>\n",
       "      <td>54554</td>\n",
       "      <td>1043</td>\n",
       "      <td>132</td>\n",
       "      <td>976</td>\n",
       "      <td>135</td>\n",
       "      <td>10</td>\n",
       "      <td>22</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            geoid      name  B02001001  B02001001, Error  B02001002  \\\n",
       "0       04000US26  Michigan    9965265                 0    7813755   \n",
       "1    86000US48001     48001      11903                92      11547   \n",
       "2    86000US48002     48002       3224                32       3183   \n",
       "3    86000US48003     48003       6047               179       5967   \n",
       "4    86000US48005     48005       5509                20       5341   \n",
       "..            ...       ...        ...               ...        ...   \n",
       "985  86000US49969     49969       1259               138        885   \n",
       "986  86000US49970     49970        292                68        289   \n",
       "987  86000US49971     49971        478                87        455   \n",
       "988  86000US54540     54540        916               155        907   \n",
       "989  86000US54554     54554       1043               132        976   \n",
       "\n",
       "     B02001002, Error  B02001003  B02001003, Error  B02001004  \\\n",
       "0                4058    1374314              4050      53316   \n",
       "1                 179         12                15         67   \n",
       "2                  44          0                10          0   \n",
       "3                 185          1                 4          8   \n",
       "4                  82         42                49         21   \n",
       "..                ...        ...               ...        ...   \n",
       "985               116          8                12        312   \n",
       "986                67          0                10          0   \n",
       "987                83          0                10          8   \n",
       "988               153          0                12          4   \n",
       "989               135         10                22         18   \n",
       "\n",
       "     B02001004, Error  ...  B02001006  B02001006, Error  B02001007  \\\n",
       "0                1913  ...       3099               339     117801   \n",
       "1                  55  ...         13                20         83   \n",
       "2                  10  ...          0                10          0   \n",
       "3                  13  ...          0                15          0   \n",
       "4                  33  ...          0                15          0   \n",
       "..                ...  ...        ...               ...        ...   \n",
       "985                60  ...          2                 3          0   \n",
       "986                10  ...          0                10          0   \n",
       "987                 7  ...          0                10          0   \n",
       "988                 5  ...          0                12          0   \n",
       "989                18  ...          0                12          0   \n",
       "\n",
       "     B02001007, Error  B02001008  B02001008, Error  B02001009  \\\n",
       "0                3429     291259              5445      26495   \n",
       "1                  79        110                85          0   \n",
       "2                  10         41                28          6   \n",
       "3                  15         13                16          0   \n",
       "4                  15         95                54         16   \n",
       "..                ...        ...               ...        ...   \n",
       "985                10         26                30          0   \n",
       "986                10          3                 4          0   \n",
       "987                10          2                 6          0   \n",
       "988                12          5                 7          1   \n",
       "989                12         27                18          0   \n",
       "\n",
       "     B02001009, Error  B02001010  B02001010, Error  \n",
       "0                1502     264764              5124  \n",
       "1                  16        110                85  \n",
       "2                   9         35                28  \n",
       "3                  15         13                16  \n",
       "4                  25         79                48  \n",
       "..                ...        ...               ...  \n",
       "985                10         26                30  \n",
       "986                10          3                 4  \n",
       "987                10          2                 6  \n",
       "988                 2          4                 7  \n",
       "989                12         27                18  \n",
       "\n",
       "[990 rows x 22 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Getting a percentage of the total for each column except population, name and geojson info\n",
    "cols = ['B02001001, Error','B02001002', 'B02001002, Error', 'B02001003', 'B02001003, Error','B02001004','B02001004, Error','B02001005', 'B02001005, Error','B02001006','B02001006, Error','B02001007','B02001007, Error','B02001008','B02001008, Error','B02001009','B02001009, Error','B02001010','B02001010, Error']\n",
    "df[cols] = df[cols].div(df['B02001001'], axis=0).multiply(100).round(1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>geoid</th>\n",
       "      <th>name</th>\n",
       "      <th>B02001001</th>\n",
       "      <th>B02001001, Error</th>\n",
       "      <th>B02001002</th>\n",
       "      <th>B02001002, Error</th>\n",
       "      <th>B02001003</th>\n",
       "      <th>B02001003, Error</th>\n",
       "      <th>B02001004</th>\n",
       "      <th>B02001004, Error</th>\n",
       "      <th>...</th>\n",
       "      <th>B02001006</th>\n",
       "      <th>B02001006, Error</th>\n",
       "      <th>B02001007</th>\n",
       "      <th>B02001007, Error</th>\n",
       "      <th>B02001008</th>\n",
       "      <th>B02001008, Error</th>\n",
       "      <th>B02001009</th>\n",
       "      <th>B02001009, Error</th>\n",
       "      <th>B02001010</th>\n",
       "      <th>B02001010, Error</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>04000US26</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>9965265</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>86000US48001</td>\n",
       "      <td>48001</td>\n",
       "      <td>11903</td>\n",
       "      <td>0.8</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>86000US48002</td>\n",
       "      <td>48002</td>\n",
       "      <td>3224</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>86000US48003</td>\n",
       "      <td>48003</td>\n",
       "      <td>6047</td>\n",
       "      <td>3.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>86000US48005</td>\n",
       "      <td>48005</td>\n",
       "      <td>5509</td>\n",
       "      <td>0.4</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>86000US49969</td>\n",
       "      <td>49969</td>\n",
       "      <td>1259</td>\n",
       "      <td>11.0</td>\n",
       "      <td>70.3</td>\n",
       "      <td>9.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>86000US49970</td>\n",
       "      <td>49970</td>\n",
       "      <td>292</td>\n",
       "      <td>23.3</td>\n",
       "      <td>99.0</td>\n",
       "      <td>22.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>86000US49971</td>\n",
       "      <td>49971</td>\n",
       "      <td>478</td>\n",
       "      <td>18.2</td>\n",
       "      <td>95.2</td>\n",
       "      <td>17.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>86000US54540</td>\n",
       "      <td>54540</td>\n",
       "      <td>916</td>\n",
       "      <td>16.9</td>\n",
       "      <td>99.0</td>\n",
       "      <td>16.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>86000US54554</td>\n",
       "      <td>54554</td>\n",
       "      <td>1043</td>\n",
       "      <td>12.7</td>\n",
       "      <td>93.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            geoid      name  B02001001  B02001001, Error  B02001002  \\\n",
       "0       04000US26  Michigan    9965265               0.0       78.4   \n",
       "1    86000US48001     48001      11903               0.8       97.0   \n",
       "2    86000US48002     48002       3224               1.0       98.7   \n",
       "3    86000US48003     48003       6047               3.0       98.7   \n",
       "4    86000US48005     48005       5509               0.4       97.0   \n",
       "..            ...       ...        ...               ...        ...   \n",
       "985  86000US49969     49969       1259              11.0       70.3   \n",
       "986  86000US49970     49970        292              23.3       99.0   \n",
       "987  86000US49971     49971        478              18.2       95.2   \n",
       "988  86000US54540     54540        916              16.9       99.0   \n",
       "989  86000US54554     54554       1043              12.7       93.6   \n",
       "\n",
       "     B02001002, Error  B02001003  B02001003, Error  B02001004  \\\n",
       "0                 0.0       13.8               0.0        0.5   \n",
       "1                 1.5        0.1               0.1        0.6   \n",
       "2                 1.4        0.0               0.3        0.0   \n",
       "3                 3.1        0.0               0.1        0.1   \n",
       "4                 1.5        0.8               0.9        0.4   \n",
       "..                ...        ...               ...        ...   \n",
       "985               9.2        0.6               1.0       24.8   \n",
       "986              22.9        0.0               3.4        0.0   \n",
       "987              17.4        0.0               2.1        1.7   \n",
       "988              16.7        0.0               1.3        0.4   \n",
       "989              12.9        1.0               2.1        1.7   \n",
       "\n",
       "     B02001004, Error  ...  B02001006  B02001006, Error  B02001007  \\\n",
       "0                 0.0  ...        0.0               0.0        1.2   \n",
       "1                 0.5  ...        0.1               0.2        0.7   \n",
       "2                 0.3  ...        0.0               0.3        0.0   \n",
       "3                 0.2  ...        0.0               0.2        0.0   \n",
       "4                 0.6  ...        0.0               0.3        0.0   \n",
       "..                ...  ...        ...               ...        ...   \n",
       "985               4.8  ...        0.2               0.2        0.0   \n",
       "986               3.4  ...        0.0               3.4        0.0   \n",
       "987               1.5  ...        0.0               2.1        0.0   \n",
       "988               0.5  ...        0.0               1.3        0.0   \n",
       "989               1.7  ...        0.0               1.2        0.0   \n",
       "\n",
       "     B02001007, Error  B02001008  B02001008, Error  B02001009  \\\n",
       "0                 0.0        2.9               0.1        0.3   \n",
       "1                 0.7        0.9               0.7        0.0   \n",
       "2                 0.3        1.3               0.9        0.2   \n",
       "3                 0.2        0.2               0.3        0.0   \n",
       "4                 0.3        1.7               1.0        0.3   \n",
       "..                ...        ...               ...        ...   \n",
       "985               0.8        2.1               2.4        0.0   \n",
       "986               3.4        1.0               1.4        0.0   \n",
       "987               2.1        0.4               1.3        0.0   \n",
       "988               1.3        0.5               0.8        0.1   \n",
       "989               1.2        2.6               1.7        0.0   \n",
       "\n",
       "     B02001009, Error  B02001010  B02001010, Error  \n",
       "0                 0.0        2.7               0.1  \n",
       "1                 0.1        0.9               0.7  \n",
       "2                 0.3        1.1               0.9  \n",
       "3                 0.2        0.2               0.3  \n",
       "4                 0.5        1.4               0.9  \n",
       "..                ...        ...               ...  \n",
       "985               0.8        2.1               2.4  \n",
       "986               3.4        1.0               1.4  \n",
       "987               2.1        0.4               1.3  \n",
       "988               0.2        0.4               0.8  \n",
       "989               1.2        2.6               1.7  \n",
       "\n",
       "[990 rows x 22 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Renaming the columns\n",
    "df = df.rename(columns={ \"B02001001\": \"Total\", \"B02001002\": \"white_pct\", \"B02001003\": \"black_pct\", \"B02001004\": \"am_indian_ak_native_pct\", \"B02001005\": \"asian_pct\", \"B02001006\": \"hi_pc_islander_pct\", \"B02001007\": \"other_alone_pct\", \"B02001008\": \"two_more_pct\", \"B02001009\": \"two_other_pct\", \"B02001010\": \"two_three_pct\"}, errors=\"raise\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>geoid</th>\n",
       "      <th>name</th>\n",
       "      <th>Total</th>\n",
       "      <th>Total, Error</th>\n",
       "      <th>white_pct</th>\n",
       "      <th>white_err</th>\n",
       "      <th>black_pct</th>\n",
       "      <th>black_err</th>\n",
       "      <th>am_indian_ak_native_pct</th>\n",
       "      <th>am_indian_ak_native_err</th>\n",
       "      <th>...</th>\n",
       "      <th>hi_pc_islander_pct</th>\n",
       "      <th>hi_pc_islander_err</th>\n",
       "      <th>other_alone_pct</th>\n",
       "      <th>other_alone_err</th>\n",
       "      <th>two_more_pct</th>\n",
       "      <th>two_more_err</th>\n",
       "      <th>two_other_pct</th>\n",
       "      <th>two_other_err</th>\n",
       "      <th>two_three_pct</th>\n",
       "      <th>two_three_err</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>04000US26</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>9965265</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>86000US48001</td>\n",
       "      <td>48001</td>\n",
       "      <td>11903</td>\n",
       "      <td>0.8</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>86000US48002</td>\n",
       "      <td>48002</td>\n",
       "      <td>3224</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>86000US48003</td>\n",
       "      <td>48003</td>\n",
       "      <td>6047</td>\n",
       "      <td>3.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>86000US48005</td>\n",
       "      <td>48005</td>\n",
       "      <td>5509</td>\n",
       "      <td>0.4</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>86000US49969</td>\n",
       "      <td>49969</td>\n",
       "      <td>1259</td>\n",
       "      <td>11.0</td>\n",
       "      <td>70.3</td>\n",
       "      <td>9.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>86000US49970</td>\n",
       "      <td>49970</td>\n",
       "      <td>292</td>\n",
       "      <td>23.3</td>\n",
       "      <td>99.0</td>\n",
       "      <td>22.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>86000US49971</td>\n",
       "      <td>49971</td>\n",
       "      <td>478</td>\n",
       "      <td>18.2</td>\n",
       "      <td>95.2</td>\n",
       "      <td>17.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>86000US54540</td>\n",
       "      <td>54540</td>\n",
       "      <td>916</td>\n",
       "      <td>16.9</td>\n",
       "      <td>99.0</td>\n",
       "      <td>16.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>86000US54554</td>\n",
       "      <td>54554</td>\n",
       "      <td>1043</td>\n",
       "      <td>12.7</td>\n",
       "      <td>93.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            geoid      name    Total  Total, Error  white_pct  white_err  \\\n",
       "0       04000US26  Michigan  9965265           0.0       78.4        0.0   \n",
       "1    86000US48001     48001    11903           0.8       97.0        1.5   \n",
       "2    86000US48002     48002     3224           1.0       98.7        1.4   \n",
       "3    86000US48003     48003     6047           3.0       98.7        3.1   \n",
       "4    86000US48005     48005     5509           0.4       97.0        1.5   \n",
       "..            ...       ...      ...           ...        ...        ...   \n",
       "985  86000US49969     49969     1259          11.0       70.3        9.2   \n",
       "986  86000US49970     49970      292          23.3       99.0       22.9   \n",
       "987  86000US49971     49971      478          18.2       95.2       17.4   \n",
       "988  86000US54540     54540      916          16.9       99.0       16.7   \n",
       "989  86000US54554     54554     1043          12.7       93.6       12.9   \n",
       "\n",
       "     black_pct  black_err  am_indian_ak_native_pct  am_indian_ak_native_err  \\\n",
       "0         13.8        0.0                      0.5                      0.0   \n",
       "1          0.1        0.1                      0.6                      0.5   \n",
       "2          0.0        0.3                      0.0                      0.3   \n",
       "3          0.0        0.1                      0.1                      0.2   \n",
       "4          0.8        0.9                      0.4                      0.6   \n",
       "..         ...        ...                      ...                      ...   \n",
       "985        0.6        1.0                     24.8                      4.8   \n",
       "986        0.0        3.4                      0.0                      3.4   \n",
       "987        0.0        2.1                      1.7                      1.5   \n",
       "988        0.0        1.3                      0.4                      0.5   \n",
       "989        1.0        2.1                      1.7                      1.7   \n",
       "\n",
       "     ...  hi_pc_islander_pct  hi_pc_islander_err  other_alone_pct  \\\n",
       "0    ...                 0.0                 0.0              1.2   \n",
       "1    ...                 0.1                 0.2              0.7   \n",
       "2    ...                 0.0                 0.3              0.0   \n",
       "3    ...                 0.0                 0.2              0.0   \n",
       "4    ...                 0.0                 0.3              0.0   \n",
       "..   ...                 ...                 ...              ...   \n",
       "985  ...                 0.2                 0.2              0.0   \n",
       "986  ...                 0.0                 3.4              0.0   \n",
       "987  ...                 0.0                 2.1              0.0   \n",
       "988  ...                 0.0                 1.3              0.0   \n",
       "989  ...                 0.0                 1.2              0.0   \n",
       "\n",
       "     other_alone_err  two_more_pct  two_more_err  two_other_pct  \\\n",
       "0                0.0           2.9           0.1            0.3   \n",
       "1                0.7           0.9           0.7            0.0   \n",
       "2                0.3           1.3           0.9            0.2   \n",
       "3                0.2           0.2           0.3            0.0   \n",
       "4                0.3           1.7           1.0            0.3   \n",
       "..               ...           ...           ...            ...   \n",
       "985              0.8           2.1           2.4            0.0   \n",
       "986              3.4           1.0           1.4            0.0   \n",
       "987              2.1           0.4           1.3            0.0   \n",
       "988              1.3           0.5           0.8            0.1   \n",
       "989              1.2           2.6           1.7            0.0   \n",
       "\n",
       "     two_other_err  two_three_pct  two_three_err  \n",
       "0              0.0            2.7            0.1  \n",
       "1              0.1            0.9            0.7  \n",
       "2              0.3            1.1            0.9  \n",
       "3              0.2            0.2            0.3  \n",
       "4              0.5            1.4            0.9  \n",
       "..             ...            ...            ...  \n",
       "985            0.8            2.1            2.4  \n",
       "986            3.4            1.0            1.4  \n",
       "987            2.1            0.4            1.3  \n",
       "988            0.2            0.4            0.8  \n",
       "989            1.2            2.6            1.7  \n",
       "\n",
       "[990 rows x 22 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Renaming the error columns\n",
    "df = df.rename(columns={ \"B02001001, Error\": \"Total, Error\", \"B02001002, Error\": \"white_err\", \"B02001003, Error\": \"black_err\", \"B02001004, Error\": \"am_indian_ak_native_err\", \"B02001005, Error\": \"asian_err\", \"B02001006, Error\": \"hi_pc_islander_err\", \"B02001007, Error\": \"other_alone_err\", \"B02001008, Error\": \"two_more_err\", \"B02001009, Error\": \"two_other_err\", \"B02001010, Error\": \"two_three_err\"}, errors=\"raise\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>geoid</th>\n",
       "      <th>name</th>\n",
       "      <th>Total</th>\n",
       "      <th>Total, Error</th>\n",
       "      <th>white_pct</th>\n",
       "      <th>white_err</th>\n",
       "      <th>black_pct</th>\n",
       "      <th>black_err</th>\n",
       "      <th>am_indian_ak_native_pct</th>\n",
       "      <th>am_indian_ak_native_err</th>\n",
       "      <th>...</th>\n",
       "      <th>other_alone_pct</th>\n",
       "      <th>other_alone_err</th>\n",
       "      <th>two_more_pct</th>\n",
       "      <th>two_more_err</th>\n",
       "      <th>two_other_pct</th>\n",
       "      <th>two_other_err</th>\n",
       "      <th>two_three_pct</th>\n",
       "      <th>two_three_err</th>\n",
       "      <th>other_pct</th>\n",
       "      <th>total_check</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>04000US26</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>9965265</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>4.1</td>\n",
       "      <td>99.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>86000US48001</td>\n",
       "      <td>48001</td>\n",
       "      <td>11903</td>\n",
       "      <td>0.8</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>86000US48002</td>\n",
       "      <td>48002</td>\n",
       "      <td>3224</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>99.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>86000US48003</td>\n",
       "      <td>48003</td>\n",
       "      <td>6047</td>\n",
       "      <td>3.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>86000US48005</td>\n",
       "      <td>48005</td>\n",
       "      <td>5509</td>\n",
       "      <td>0.4</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.7</td>\n",
       "      <td>99.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>86000US49969</td>\n",
       "      <td>49969</td>\n",
       "      <td>1259</td>\n",
       "      <td>11.0</td>\n",
       "      <td>70.3</td>\n",
       "      <td>9.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.1</td>\n",
       "      <td>100.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>86000US49970</td>\n",
       "      <td>49970</td>\n",
       "      <td>292</td>\n",
       "      <td>23.3</td>\n",
       "      <td>99.0</td>\n",
       "      <td>22.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>86000US49971</td>\n",
       "      <td>49971</td>\n",
       "      <td>478</td>\n",
       "      <td>18.2</td>\n",
       "      <td>95.2</td>\n",
       "      <td>17.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>86000US54540</td>\n",
       "      <td>54540</td>\n",
       "      <td>916</td>\n",
       "      <td>16.9</td>\n",
       "      <td>99.0</td>\n",
       "      <td>16.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.5</td>\n",
       "      <td>99.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>86000US54554</td>\n",
       "      <td>54554</td>\n",
       "      <td>1043</td>\n",
       "      <td>12.7</td>\n",
       "      <td>93.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>100.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            geoid      name    Total  Total, Error  white_pct  white_err  \\\n",
       "0       04000US26  Michigan  9965265           0.0       78.4        0.0   \n",
       "1    86000US48001     48001    11903           0.8       97.0        1.5   \n",
       "2    86000US48002     48002     3224           1.0       98.7        1.4   \n",
       "3    86000US48003     48003     6047           3.0       98.7        3.1   \n",
       "4    86000US48005     48005     5509           0.4       97.0        1.5   \n",
       "..            ...       ...      ...           ...        ...        ...   \n",
       "985  86000US49969     49969     1259          11.0       70.3        9.2   \n",
       "986  86000US49970     49970      292          23.3       99.0       22.9   \n",
       "987  86000US49971     49971      478          18.2       95.2       17.4   \n",
       "988  86000US54540     54540      916          16.9       99.0       16.7   \n",
       "989  86000US54554     54554     1043          12.7       93.6       12.9   \n",
       "\n",
       "     black_pct  black_err  am_indian_ak_native_pct  am_indian_ak_native_err  \\\n",
       "0         13.8        0.0                      0.5                      0.0   \n",
       "1          0.1        0.1                      0.6                      0.5   \n",
       "2          0.0        0.3                      0.0                      0.3   \n",
       "3          0.0        0.1                      0.1                      0.2   \n",
       "4          0.8        0.9                      0.4                      0.6   \n",
       "..         ...        ...                      ...                      ...   \n",
       "985        0.6        1.0                     24.8                      4.8   \n",
       "986        0.0        3.4                      0.0                      3.4   \n",
       "987        0.0        2.1                      1.7                      1.5   \n",
       "988        0.0        1.3                      0.4                      0.5   \n",
       "989        1.0        2.1                      1.7                      1.7   \n",
       "\n",
       "     ...  other_alone_pct  other_alone_err  two_more_pct  two_more_err  \\\n",
       "0    ...              1.2              0.0           2.9           0.1   \n",
       "1    ...              0.7              0.7           0.9           0.7   \n",
       "2    ...              0.0              0.3           1.3           0.9   \n",
       "3    ...              0.0              0.2           0.2           0.3   \n",
       "4    ...              0.0              0.3           1.7           1.0   \n",
       "..   ...              ...              ...           ...           ...   \n",
       "985  ...              0.0              0.8           2.1           2.4   \n",
       "986  ...              0.0              3.4           1.0           1.4   \n",
       "987  ...              0.0              2.1           0.4           1.3   \n",
       "988  ...              0.0              1.3           0.5           0.8   \n",
       "989  ...              0.0              1.2           2.6           1.7   \n",
       "\n",
       "     two_other_pct  two_other_err  two_three_pct  two_three_err  other_pct  \\\n",
       "0              0.3            0.0            2.7            0.1        4.1   \n",
       "1              0.0            0.1            0.9            0.7        1.6   \n",
       "2              0.2            0.3            1.1            0.9        1.3   \n",
       "3              0.0            0.2            0.2            0.3        0.2   \n",
       "4              0.3            0.5            1.4            0.9        1.7   \n",
       "..             ...            ...            ...            ...        ...   \n",
       "985            0.0            0.8            2.1            2.4        2.1   \n",
       "986            0.0            3.4            1.0            1.4        1.0   \n",
       "987            0.0            2.1            0.4            1.3        0.4   \n",
       "988            0.1            0.2            0.4            0.8        0.5   \n",
       "989            0.0            1.2            2.6            1.7        2.6   \n",
       "\n",
       "     total_check  \n",
       "0           99.7  \n",
       "1          100.0  \n",
       "2           99.8  \n",
       "3          100.0  \n",
       "4           99.8  \n",
       "..           ...  \n",
       "985        100.1  \n",
       "986        100.0  \n",
       "987        100.0  \n",
       "988         99.8  \n",
       "989        100.1  \n",
       "\n",
       "[990 rows x 24 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Adding up the other columns\n",
    "df['other_pct'] = df['other_alone_pct'] + df['two_more_pct']\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Does everything add up?\n",
    "# Seems like it, I think because of error, it might not add up always perfectly to 100\n",
    "# would check with Census data expert on this before publishing\n",
    "df['total_check'] = df['white_pct'] + df['black_pct'] + df['am_indian_ak_native_pct'] + df['asian_pct'] + df['hi_pc_islander_pct'] + df['other_pct']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>geoid</th>\n",
       "      <th>name</th>\n",
       "      <th>Total</th>\n",
       "      <th>Total, Error</th>\n",
       "      <th>white_pct</th>\n",
       "      <th>white_err</th>\n",
       "      <th>black_pct</th>\n",
       "      <th>black_err</th>\n",
       "      <th>am_indian_ak_native_pct</th>\n",
       "      <th>am_indian_ak_native_err</th>\n",
       "      <th>...</th>\n",
       "      <th>other_alone_pct</th>\n",
       "      <th>other_alone_err</th>\n",
       "      <th>two_more_pct</th>\n",
       "      <th>two_more_err</th>\n",
       "      <th>two_other_pct</th>\n",
       "      <th>two_other_err</th>\n",
       "      <th>two_three_pct</th>\n",
       "      <th>two_three_err</th>\n",
       "      <th>other_pct</th>\n",
       "      <th>total_check</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>04000US26</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>9965265</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.9</td>\n",
       "      <td>99.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>86000US48001</td>\n",
       "      <td>48001</td>\n",
       "      <td>11903</td>\n",
       "      <td>0.8</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.6</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>86000US48002</td>\n",
       "      <td>48002</td>\n",
       "      <td>3224</td>\n",
       "      <td>1.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.1</td>\n",
       "      <td>99.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>86000US48003</td>\n",
       "      <td>48003</td>\n",
       "      <td>6047</td>\n",
       "      <td>3.0</td>\n",
       "      <td>98.7</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.2</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>86000US48005</td>\n",
       "      <td>48005</td>\n",
       "      <td>5509</td>\n",
       "      <td>0.4</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1.4</td>\n",
       "      <td>99.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>86000US49969</td>\n",
       "      <td>49969</td>\n",
       "      <td>1259</td>\n",
       "      <td>11.0</td>\n",
       "      <td>70.3</td>\n",
       "      <td>9.2</td>\n",
       "      <td>0.6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>24.8</td>\n",
       "      <td>4.8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.1</td>\n",
       "      <td>100.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>86000US49970</td>\n",
       "      <td>49970</td>\n",
       "      <td>292</td>\n",
       "      <td>23.3</td>\n",
       "      <td>99.0</td>\n",
       "      <td>22.9</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>86000US49971</td>\n",
       "      <td>49971</td>\n",
       "      <td>478</td>\n",
       "      <td>18.2</td>\n",
       "      <td>95.2</td>\n",
       "      <td>17.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>86000US54540</td>\n",
       "      <td>54540</td>\n",
       "      <td>916</td>\n",
       "      <td>16.9</td>\n",
       "      <td>99.0</td>\n",
       "      <td>16.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.4</td>\n",
       "      <td>99.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>86000US54554</td>\n",
       "      <td>54554</td>\n",
       "      <td>1043</td>\n",
       "      <td>12.7</td>\n",
       "      <td>93.6</td>\n",
       "      <td>12.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.7</td>\n",
       "      <td>1.7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>100.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            geoid      name    Total  Total, Error  white_pct  white_err  \\\n",
       "0       04000US26  Michigan  9965265           0.0       78.4        0.0   \n",
       "1    86000US48001     48001    11903           0.8       97.0        1.5   \n",
       "2    86000US48002     48002     3224           1.0       98.7        1.4   \n",
       "3    86000US48003     48003     6047           3.0       98.7        3.1   \n",
       "4    86000US48005     48005     5509           0.4       97.0        1.5   \n",
       "..            ...       ...      ...           ...        ...        ...   \n",
       "985  86000US49969     49969     1259          11.0       70.3        9.2   \n",
       "986  86000US49970     49970      292          23.3       99.0       22.9   \n",
       "987  86000US49971     49971      478          18.2       95.2       17.4   \n",
       "988  86000US54540     54540      916          16.9       99.0       16.7   \n",
       "989  86000US54554     54554     1043          12.7       93.6       12.9   \n",
       "\n",
       "     black_pct  black_err  am_indian_ak_native_pct  am_indian_ak_native_err  \\\n",
       "0         13.8        0.0                      0.5                      0.0   \n",
       "1          0.1        0.1                      0.6                      0.5   \n",
       "2          0.0        0.3                      0.0                      0.3   \n",
       "3          0.0        0.1                      0.1                      0.2   \n",
       "4          0.8        0.9                      0.4                      0.6   \n",
       "..         ...        ...                      ...                      ...   \n",
       "985        0.6        1.0                     24.8                      4.8   \n",
       "986        0.0        3.4                      0.0                      3.4   \n",
       "987        0.0        2.1                      1.7                      1.5   \n",
       "988        0.0        1.3                      0.4                      0.5   \n",
       "989        1.0        2.1                      1.7                      1.7   \n",
       "\n",
       "     ...  other_alone_pct  other_alone_err  two_more_pct  two_more_err  \\\n",
       "0    ...              1.2              0.0           2.9           0.1   \n",
       "1    ...              0.7              0.7           0.9           0.7   \n",
       "2    ...              0.0              0.3           1.3           0.9   \n",
       "3    ...              0.0              0.2           0.2           0.3   \n",
       "4    ...              0.0              0.3           1.7           1.0   \n",
       "..   ...              ...              ...           ...           ...   \n",
       "985  ...              0.0              0.8           2.1           2.4   \n",
       "986  ...              0.0              3.4           1.0           1.4   \n",
       "987  ...              0.0              2.1           0.4           1.3   \n",
       "988  ...              0.0              1.3           0.5           0.8   \n",
       "989  ...              0.0              1.2           2.6           1.7   \n",
       "\n",
       "     two_other_pct  two_other_err  two_three_pct  two_three_err  other_pct  \\\n",
       "0              0.3            0.0            2.7            0.1        3.9   \n",
       "1              0.0            0.1            0.9            0.7        1.6   \n",
       "2              0.2            0.3            1.1            0.9        1.1   \n",
       "3              0.0            0.2            0.2            0.3        0.2   \n",
       "4              0.3            0.5            1.4            0.9        1.4   \n",
       "..             ...            ...            ...            ...        ...   \n",
       "985            0.0            0.8            2.1            2.4        2.1   \n",
       "986            0.0            3.4            1.0            1.4        1.0   \n",
       "987            0.0            2.1            0.4            1.3        0.4   \n",
       "988            0.1            0.2            0.4            0.8        0.4   \n",
       "989            0.0            1.2            2.6            1.7        2.6   \n",
       "\n",
       "     total_check  \n",
       "0           99.7  \n",
       "1          100.0  \n",
       "2           99.8  \n",
       "3          100.0  \n",
       "4           99.8  \n",
       "..           ...  \n",
       "985        100.1  \n",
       "986        100.0  \n",
       "987        100.0  \n",
       "988         99.8  \n",
       "989        100.1  \n",
       "\n",
       "[990 rows x 24 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Making a copy with the columns that I want and exporting it to a csv\n",
    "df[['name','white_pct', 'black_pct','am_indian_ak_native_pct','asian_pct','hi_pc_islander_pct','other_pct']].copy().to_csv(\"csv/acs2019-race-zip-michigan-clean.csv\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Reading in my census data --- poverty\n",
    "# Source: https://censusreporter.org/data/table/?table=B17001&geo_ids=04000US26,860|04000US26&primary_geo_id=04000US26\n",
    "df2 = pd.read_csv(\"csv/acs2019-poverty-zip-michigan-raw.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>B17001001</th>\n",
       "      <th>B17001001, Error</th>\n",
       "      <th>B17001002</th>\n",
       "      <th>B17001002, Error</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>9741628</td>\n",
       "      <td>1788</td>\n",
       "      <td>1398527</td>\n",
       "      <td>14569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48001</td>\n",
       "      <td>11818</td>\n",
       "      <td>102</td>\n",
       "      <td>1173</td>\n",
       "      <td>239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48002</td>\n",
       "      <td>3212</td>\n",
       "      <td>34</td>\n",
       "      <td>246</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48003</td>\n",
       "      <td>6047</td>\n",
       "      <td>179</td>\n",
       "      <td>567</td>\n",
       "      <td>195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48005</td>\n",
       "      <td>5439</td>\n",
       "      <td>93</td>\n",
       "      <td>265</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>49969</td>\n",
       "      <td>1258</td>\n",
       "      <td>138</td>\n",
       "      <td>185</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>49970</td>\n",
       "      <td>285</td>\n",
       "      <td>66</td>\n",
       "      <td>22</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>49971</td>\n",
       "      <td>478</td>\n",
       "      <td>87</td>\n",
       "      <td>54</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>54540</td>\n",
       "      <td>916</td>\n",
       "      <td>155</td>\n",
       "      <td>97</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>54554</td>\n",
       "      <td>991</td>\n",
       "      <td>129</td>\n",
       "      <td>124</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         name  B17001001  B17001001, Error  B17001002  B17001002, Error\n",
       "0    Michigan    9741628              1788    1398527             14569\n",
       "1       48001      11818               102       1173               239\n",
       "2       48002       3212                34        246               112\n",
       "3       48003       6047               179        567               195\n",
       "4       48005       5439                93        265               107\n",
       "..        ...        ...               ...        ...               ...\n",
       "985     49969       1258               138        185                59\n",
       "986     49970        285                66         22                21\n",
       "987     49971        478                87         54                27\n",
       "988     54540        916               155         97                45\n",
       "989     54554        991               129        124                71\n",
       "\n",
       "[990 rows x 5 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Making a copy with the columns I want\n",
    "df2 = df2[['name', 'B17001001', 'B17001001, Error','B17001002','B17001002, Error']].copy()\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Renaming the columns\n",
    "df2 = df2.rename(columns={\"B17001001\":\"Total\",\"B17001001, Error\": \"Total, Error\", \"B17001002\": \"Income Poverty Level\",\"B17001002, Error\": \"Income Poverty Level, Error\"})"
   ]
  },
  {
   "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>name</th>\n",
       "      <th>Total</th>\n",
       "      <th>Total, Error</th>\n",
       "      <th>Income Poverty Level</th>\n",
       "      <th>Income Poverty Level, Error</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Michigan</td>\n",
       "      <td>9741628</td>\n",
       "      <td>1788</td>\n",
       "      <td>1398527</td>\n",
       "      <td>14569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48001</td>\n",
       "      <td>11818</td>\n",
       "      <td>102</td>\n",
       "      <td>1173</td>\n",
       "      <td>239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>48002</td>\n",
       "      <td>3212</td>\n",
       "      <td>34</td>\n",
       "      <td>246</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>48003</td>\n",
       "      <td>6047</td>\n",
       "      <td>179</td>\n",
       "      <td>567</td>\n",
       "      <td>195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>48005</td>\n",
       "      <td>5439</td>\n",
       "      <td>93</td>\n",
       "      <td>265</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>49969</td>\n",
       "      <td>1258</td>\n",
       "      <td>138</td>\n",
       "      <td>185</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>49970</td>\n",
       "      <td>285</td>\n",
       "      <td>66</td>\n",
       "      <td>22</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>49971</td>\n",
       "      <td>478</td>\n",
       "      <td>87</td>\n",
       "      <td>54</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>54540</td>\n",
       "      <td>916</td>\n",
       "      <td>155</td>\n",
       "      <td>97</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>54554</td>\n",
       "      <td>991</td>\n",
       "      <td>129</td>\n",
       "      <td>124</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         name    Total  Total, Error  Income Poverty Level  \\\n",
       "0    Michigan  9741628          1788               1398527   \n",
       "1       48001    11818           102                  1173   \n",
       "2       48002     3212            34                   246   \n",
       "3       48003     6047           179                   567   \n",
       "4       48005     5439            93                   265   \n",
       "..        ...      ...           ...                   ...   \n",
       "985     49969     1258           138                   185   \n",
       "986     49970      285            66                    22   \n",
       "987     49971      478            87                    54   \n",
       "988     54540      916           155                    97   \n",
       "989     54554      991           129                   124   \n",
       "\n",
       "     Income Poverty Level, Error  \n",
       "0                          14569  \n",
       "1                            239  \n",
       "2                            112  \n",
       "3                            195  \n",
       "4                            107  \n",
       "..                           ...  \n",
       "985                           59  \n",
       "986                           21  \n",
       "987                           27  \n",
       "988                           45  \n",
       "989                           71  \n",
       "\n",
       "[990 rows x 5 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Getting percentage of the total\n",
    "# Exporting to csv\n",
    "cols = ['Total, Error', 'Income Poverty Level', 'Income Poverty Level, Error']\n",
    "df2[cols] = df2[cols].div(df2['Total'], axis=0).multiply(100).round(1)\n",
    "df2.to_csv(\"csv/acs2019-poverty-zip-michigan-clean.csv\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}