ACS_Cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T19:22:09.922856Z",
     "start_time": "2018-04-28T19:22:08.319188Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:17:09.082430Z",
     "start_time": "2018-04-28T21:17:08.723177Z"
    }
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv('Data/features/ACS_Subset.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:17:09.393909Z",
     "start_time": "2018-04-28T21:17:09.345734Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>FIPS</th>\n",
       "      <th>Name of Area</th>\n",
       "      <th>Qualifying Name</th>\n",
       "      <th>State/U.S.-Abbreviation (USPS)</th>\n",
       "      <th>Summary Level</th>\n",
       "      <th>Geographic Component</th>\n",
       "      <th>File Identification</th>\n",
       "      <th>Logical Record Number</th>\n",
       "      <th>US</th>\n",
       "      <th>Region</th>\n",
       "      <th>...</th>\n",
       "      <th>Occupied Housing Units: Complete Kitchen Facilities</th>\n",
       "      <th>Occupied Housing Units.2</th>\n",
       "      <th>Occupied Housing Units: with Telephone Service Available</th>\n",
       "      <th>Occupied Housing Units: with Telephone Service Available: Householder 15 to 34 Years</th>\n",
       "      <th>Occupied Housing Units: with Telephone Service Available: Householder 35 to 64 Years</th>\n",
       "      <th>Occupied Housing Units: with Telephone Service Available: Householder 65 Years and Over</th>\n",
       "      <th>Occupied Housing Units: No Telephone Service Available</th>\n",
       "      <th>Occupied Housing Units: No Telephone Service Available: Householder 15 to 34 Years</th>\n",
       "      <th>Occupied Housing Units: No Telephone Service Available: Householder 35 to 64 Years</th>\n",
       "      <th>Occupied Housing Units: No Telephone Service Available: Householder 65 Years and Over</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Geo_FIPS</td>\n",
       "      <td>Geo_NAME</td>\n",
       "      <td>Geo_QName</td>\n",
       "      <td>Geo_STUSAB</td>\n",
       "      <td>Geo_SUMLEV</td>\n",
       "      <td>Geo_GEOCOMP</td>\n",
       "      <td>Geo_FILEID</td>\n",
       "      <td>Geo_LOGRECNO</td>\n",
       "      <td>Geo_US</td>\n",
       "      <td>Geo_REGION</td>\n",
       "      <td>...</td>\n",
       "      <td>SE_T181_003</td>\n",
       "      <td>SE_T184_001</td>\n",
       "      <td>SE_T184_002</td>\n",
       "      <td>SE_T184_003</td>\n",
       "      <td>SE_T184_004</td>\n",
       "      <td>SE_T184_005</td>\n",
       "      <td>SE_T184_006</td>\n",
       "      <td>SE_T184_007</td>\n",
       "      <td>SE_T184_008</td>\n",
       "      <td>SE_T184_009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36005000100</td>\n",
       "      <td>Census Tract 1, Bronx County, New York</td>\n",
       "      <td>Census Tract 1, Bronx County, New York</td>\n",
       "      <td>ny</td>\n",
       "      <td>140</td>\n",
       "      <td>00</td>\n",
       "      <td>ACSSF</td>\n",
       "      <td>0003481</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36005000200</td>\n",
       "      <td>Census Tract 2, Bronx County, New York</td>\n",
       "      <td>Census Tract 2, Bronx County, New York</td>\n",
       "      <td>ny</td>\n",
       "      <td>140</td>\n",
       "      <td>00</td>\n",
       "      <td>ACSSF</td>\n",
       "      <td>0003482</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1331</td>\n",
       "      <td>1331</td>\n",
       "      <td>1310</td>\n",
       "      <td>137</td>\n",
       "      <td>858</td>\n",
       "      <td>315</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>36005000400</td>\n",
       "      <td>Census Tract 4, Bronx County, New York</td>\n",
       "      <td>Census Tract 4, Bronx County, New York</td>\n",
       "      <td>ny</td>\n",
       "      <td>140</td>\n",
       "      <td>00</td>\n",
       "      <td>ACSSF</td>\n",
       "      <td>0003483</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1915</td>\n",
       "      <td>1926</td>\n",
       "      <td>1885</td>\n",
       "      <td>160</td>\n",
       "      <td>1407</td>\n",
       "      <td>318</td>\n",
       "      <td>41</td>\n",
       "      <td>11</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36005001600</td>\n",
       "      <td>Census Tract 16, Bronx County, New York</td>\n",
       "      <td>Census Tract 16, Bronx County, New York</td>\n",
       "      <td>ny</td>\n",
       "      <td>140</td>\n",
       "      <td>00</td>\n",
       "      <td>ACSSF</td>\n",
       "      <td>0003484</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1957</td>\n",
       "      <td>1970</td>\n",
       "      <td>1913</td>\n",
       "      <td>225</td>\n",
       "      <td>1166</td>\n",
       "      <td>522</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 756 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          FIPS                             Name of Area  \\\n",
       "0     Geo_FIPS                                 Geo_NAME   \n",
       "1  36005000100   Census Tract 1, Bronx County, New York   \n",
       "2  36005000200   Census Tract 2, Bronx County, New York   \n",
       "3  36005000400   Census Tract 4, Bronx County, New York   \n",
       "4  36005001600  Census Tract 16, Bronx County, New York   \n",
       "\n",
       "                           Qualifying Name State/U.S.-Abbreviation (USPS)  \\\n",
       "0                                Geo_QName                     Geo_STUSAB   \n",
       "1   Census Tract 1, Bronx County, New York                             ny   \n",
       "2   Census Tract 2, Bronx County, New York                             ny   \n",
       "3   Census Tract 4, Bronx County, New York                             ny   \n",
       "4  Census Tract 16, Bronx County, New York                             ny   \n",
       "\n",
       "  Summary Level Geographic Component File Identification  \\\n",
       "0    Geo_SUMLEV          Geo_GEOCOMP          Geo_FILEID   \n",
       "1           140                   00               ACSSF   \n",
       "2           140                   00               ACSSF   \n",
       "3           140                   00               ACSSF   \n",
       "4           140                   00               ACSSF   \n",
       "\n",
       "  Logical Record Number      US      Region  \\\n",
       "0          Geo_LOGRECNO  Geo_US  Geo_REGION   \n",
       "1               0003481     NaN         NaN   \n",
       "2               0003482     NaN         NaN   \n",
       "3               0003483     NaN         NaN   \n",
       "4               0003484     NaN         NaN   \n",
       "\n",
       "                                           ...                                           \\\n",
       "0                                          ...                                            \n",
       "1                                          ...                                            \n",
       "2                                          ...                                            \n",
       "3                                          ...                                            \n",
       "4                                          ...                                            \n",
       "\n",
       "  Occupied Housing Units: Complete Kitchen Facilities  \\\n",
       "0                                        SE_T181_003    \n",
       "1                                                  0    \n",
       "2                                               1331    \n",
       "3                                               1915    \n",
       "4                                               1957    \n",
       "\n",
       "  Occupied Housing Units.2  \\\n",
       "0              SE_T184_001   \n",
       "1                        0   \n",
       "2                     1331   \n",
       "3                     1926   \n",
       "4                     1970   \n",
       "\n",
       "  Occupied Housing Units: with Telephone Service Available  \\\n",
       "0                                        SE_T184_002         \n",
       "1                                                  0         \n",
       "2                                               1310         \n",
       "3                                               1885         \n",
       "4                                               1913         \n",
       "\n",
       "  Occupied Housing Units: with Telephone Service Available: Householder 15 to 34 Years  \\\n",
       "0                                        SE_T184_003                                     \n",
       "1                                                  0                                     \n",
       "2                                                137                                     \n",
       "3                                                160                                     \n",
       "4                                                225                                     \n",
       "\n",
       "  Occupied Housing Units: with Telephone Service Available: Householder 35 to 64 Years  \\\n",
       "0                                        SE_T184_004                                     \n",
       "1                                                  0                                     \n",
       "2                                                858                                     \n",
       "3                                               1407                                     \n",
       "4                                               1166                                     \n",
       "\n",
       "  Occupied Housing Units: with Telephone Service Available: Householder 65 Years and Over  \\\n",
       "0                                        SE_T184_005                                        \n",
       "1                                                  0                                        \n",
       "2                                                315                                        \n",
       "3                                                318                                        \n",
       "4                                                522                                        \n",
       "\n",
       "  Occupied Housing Units: No Telephone Service Available  \\\n",
       "0                                        SE_T184_006       \n",
       "1                                                  0       \n",
       "2                                                 21       \n",
       "3                                                 41       \n",
       "4                                                 57       \n",
       "\n",
       "  Occupied Housing Units: No Telephone Service Available: Householder 15 to 34 Years  \\\n",
       "0                                        SE_T184_007                                   \n",
       "1                                                  0                                   \n",
       "2                                                  0                                   \n",
       "3                                                 11                                   \n",
       "4                                                  0                                   \n",
       "\n",
       "  Occupied Housing Units: No Telephone Service Available: Householder 35 to 64 Years  \\\n",
       "0                                        SE_T184_008                                   \n",
       "1                                                  0                                   \n",
       "2                                                 21                                   \n",
       "3                                                 20                                   \n",
       "4                                                 36                                   \n",
       "\n",
       "  Occupied Housing Units: No Telephone Service Available: Householder 65 Years and Over  \n",
       "0                                        SE_T184_009                                     \n",
       "1                                                  0                                     \n",
       "2                                                  0                                     \n",
       "3                                                 10                                     \n",
       "4                                                 21                                     \n",
       "\n",
       "[5 rows x 756 columns]"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:17:10.304767Z",
     "start_time": "2018-04-28T21:17:10.280391Z"
    }
   },
   "outputs": [],
   "source": [
    "df.drop(0,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:17:11.732322Z",
     "start_time": "2018-04-28T21:17:11.724873Z"
    }
   },
   "outputs": [],
   "source": [
    "key = set(['Chinese','Japanese','Korean','Vietnamese','Malaysian','Filipino',\n",
    "       'Taiwanese','Indian','Cambodian','Laotian','Pakistani','Thai','Himalayan',\n",
    "       'Nepalese','Shanghainese','Singaporean','Cuban','Puerto Rican',\n",
    "       'Dominican','Mexican','Colombian','Salvadoran','Peruvian','Venezuelan',\n",
    "       'Haitian','Italian','Irish','German','Russian','Polish','French','Jewish',\n",
    "       'Greek','Turkish','Lebanese','Armenian','Moroccan'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:17:39.044055Z",
     "start_time": "2018-04-28T21:17:38.654798Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(0, 'FIPS', '36005000100')\n",
      "(1, 'Name of Area', 'Census Tract 1, Bronx County, New York')\n",
      "(2, 'Qualifying Name', 'Census Tract 1, Bronx County, New York')\n",
      "(3, 'State/U.S.-Abbreviation (USPS)', 'ny')\n",
      "(4, 'Summary Level', '140')\n",
      "(5, 'Geographic Component', '00')\n",
      "(6, 'File Identification', 'ACSSF')\n",
      "(7, 'Logical Record Number', '0003481')\n",
      "(8, 'US', nan)\n",
      "(9, 'Region', nan)\n",
      "(10, 'Division', nan)\n",
      "(11, 'State (Census Code)', nan)\n",
      "(12, 'State (FIPS)', '36')\n",
      "(13, 'County', '005')\n",
      "(14, 'County Subdivision (FIPS)', nan)\n",
      "(15, 'Place (FIPS Code)', nan)\n",
      "(16, 'Place (State FIPS + Place FIPS)', nan)\n",
      "(17, 'Census Tract', '000100')\n",
      "(18, 'Block Group', nan)\n",
      "(19, 'Consolidated City', nan)\n",
      "(20, 'American Indian Area/Alaska Native Area/Hawaiian Home Land (Census)', nan)\n",
      "(21, 'American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS)', nan)\n",
      "(22, 'American Indian Trust Land/Hawaiian Home Land Indicator', nan)\n",
      "(23, 'American Indian Tribal Subdivision (Census)', nan)\n",
      "(24, 'American Indian Tribal Subdivision (FIPS)', nan)\n",
      "(25, 'Alaska Native Regional Corporation (FIPS)', nan)\n",
      "(26, 'Metropolitan and Micropolitan Statistical Area', nan)\n",
      "(27, 'Combined Statistical Area', nan)\n",
      "(28, 'Metropolitan Division', nan)\n",
      "(29, 'Metropolitan Area Central City', nan)\n",
      "(30, 'Metropolitan/Micropolitan Indicator Flag', nan)\n",
      "(31, 'New England City and Town Combined Statistical Area', nan)\n",
      "(32, 'New England City and Town Area', nan)\n",
      "(33, 'New England City and Town Area Division', nan)\n",
      "(34, 'Urban Area', nan)\n",
      "(35, 'Urban Area Central Place', nan)\n",
      "(36, 'Current Congressional District ***', nan)\n",
      "(37, 'State Legislative District Upper', nan)\n",
      "(38, 'State Legislative District Lower', nan)\n",
      "(39, 'Voting District', nan)\n",
      "(40, 'ZIP Code Tabulation Area (3-digit)', nan)\n",
      "(41, 'ZIP Code Tabulation Area (5-digit)', nan)\n",
      "(42, 'Subbarrio (FIPS)', nan)\n",
      "(43, 'School District (Elementary)', nan)\n",
      "(44, 'School District (Secondary)', nan)\n",
      "(45, 'School District (Unified)', nan)\n",
      "(46, 'Urban/Rural', nan)\n",
      "(47, 'Principal City Indicator', nan)\n",
      "(48, 'Traffic Analysis Zone', nan)\n",
      "(49, 'Urban Growth Area', nan)\n",
      "(50, 'Public Use Microdata Area - 5% File', nan)\n",
      "(51, 'Public Use Microdata Area - 1% File', nan)\n",
      "(52, 'Geographic Identifier', '14000US36005000100')\n",
      "(53, 'Tribal Tract', nan)\n",
      "(54, 'Tribal Block Group', nan)\n",
      "(55, 'Area (Land)', '1677210')\n",
      "(56, 'Area (Water)', '1035011')\n",
      "(57, 'Total Population', '7503')\n",
      "(58, 'Total Population.1', '7503')\n",
      "(59, 'Population Density (Per Sq. Mile)', '11586.31')\n",
      "(60, 'Area (Land).1', '0.647574428916273')\n",
      "(61, 'Area Total:', '1.047194')\n",
      "(62, 'Area Total: Area (Land)', '0.6475744')\n",
      "(63, 'Area Total: Area (Water)', '0.39962')\n",
      "(64, 'Total Population:', '7503')\n",
      "(65, 'Total Population: Under 5 Years', '0')\n",
      "(66, 'Total Population: 5 to 9 Years', '0')\n",
      "(67, 'Total Population: 10 to 14 Years', '0')\n",
      "(68, 'Total Population: 15 to 17 Years', '267')\n",
      "(69, 'Total Population: 18 to 24 Years', '1914')\n",
      "(70, 'Total Population: 25 to 34 Years', '2105')\n",
      "(71, 'Total Population: 35 to 44 Years', '1450')\n",
      "(72, 'Total Population: 45 to 54 Years', '1298')\n",
      "(73, 'Total Population: 55 to 64 Years', '436')\n",
      "(74, 'Total Population: 65 to 74 Years', '24')\n",
      "(75, 'Total Population: 75 to 84 Years', '9')\n",
      "(76, 'Total Population: 85 Years and Over', '0')\n",
      "(77, 'Median Age:', '32.1')\n",
      "(78, 'Median Age: Male Population', '32')\n",
      "(79, 'Median Age: Female Population', '33.6')\n",
      "(80, 'Total Population:.1', '7503')\n",
      "(81, 'Total Population: White Alone', '933')\n",
      "(82, 'Total Population: Black or African American Alone', '4697')\n",
      "(83, 'Total Population: American Indian and Alaska Native Alone', '14')\n",
      "(84, 'Total Population: Asian Alone', '135')\n",
      "(85, 'Total Population: Native Hawaiian and Other Pacific Islander Alone', '0')\n",
      "(86, 'Total Population: Some Other Race Alone', '1612')\n",
      "(87, 'Total Population: Two or More Races', '112')\n",
      "(88, 'Total Population.2', '7503')\n",
      "(89, 'Total Population: Not Hispanic or Latino', '5263')\n",
      "(90, 'Total Population: Hispanic or Latino', '2240')\n",
      "(91, 'Total Population: Hispanic or Latino: Mexican', '140')\n",
      "(92, 'Total Population: Hispanic or Latino: Puerto Rican', '1093')\n",
      "(93, 'Total Population: Hispanic or Latino: Cuban', '21')\n",
      "(94, 'Total Population: Hispanic or Latino: Dominican Republic', '381')\n",
      "(95, 'Total Population: Hispanic or Latino: Central American', '134')\n",
      "(96, 'Total Population: Hispanic or Latino: Central American: Costa Rican', '0')\n",
      "(97, 'Total Population: Hispanic or Latino: Central American: Guatemalan', '29')\n",
      "(98, 'Total Population: Hispanic or Latino: Central American: Honduran', '63')\n",
      "(99, 'Total Population: Hispanic or Latino: Central American: Nicaraguan', '0')\n",
      "(100, 'Total Population: Hispanic or Latino: Central American: Panamanian', '6')\n",
      "(101, 'Total Population: Hispanic or Latino: Central American: Salvadoran', '36')\n",
      "(102, 'Total Population: Hispanic or Latino: Central American: Other Central American', '0')\n",
      "(103, 'Total Population: Hispanic or Latino: South American', '83')\n",
      "(104, 'Total Population: Hispanic or Latino: South American: Argentinean', '0')\n",
      "(105, 'Total Population: Hispanic or Latino: South American: Bolivian', '0')\n",
      "(106, 'Total Population: Hispanic or Latino: South American: Chilean', '0')\n",
      "(107, 'Total Population: Hispanic or Latino: South American: Colombian', '8')\n",
      "(108, 'Total Population: Hispanic or Latino: South American: Ecuadorian', '75')\n",
      "(109, 'Total Population: Hispanic or Latino: South American: Paraguayan', '0')\n",
      "(110, 'Total Population: Hispanic or Latino: South American: Peruvian', '0')\n",
      "(111, 'Total Population: Hispanic or Latino: South American: Uruguayan', '0')\n",
      "(112, 'Total Population: Hispanic or Latino: South American: Venezuelan', '0')\n",
      "(113, 'Total Population: Hispanic or Latino: South American: Other South American', '0')\n",
      "(114, 'Total Population: Hispanic or Latino: Other Hispanic or Latino', '388')\n",
      "(115, 'Total Population: Hispanic or Latino: Other Hispanic or Latino: Spaniard', '0')\n",
      "(116, 'Total Population: Hispanic or Latino: Other Hispanic or Latino: Spanish', '0')\n",
      "(117, 'Total Population: Hispanic or Latino: Other Hispanic or Latino: Spanish American', '0')\n",
      "(118, 'Total Population: Hispanic or Latino: Other Hispanic or Latino: All Other Hispanic or Latino', '388')\n",
      "(119, 'Total:', '135')\n",
      "(120, 'Total: Asian Indian', '55')\n",
      "(121, 'Total: Bangladeshi', '19')\n",
      "(122, 'Total: Bhutanese', '0')\n",
      "(123, 'Total: Burmese', '0')\n",
      "(124, 'Total: Cambodian', '0')\n",
      "(125, 'Total: Chinese, Except Taiwanese', '39')\n",
      "(126, 'Total: Filipino', '0')\n",
      "(127, 'Total: Hmong', '0')\n",
      "(128, 'Total: Indonesian', '0')\n",
      "(129, 'Total: Japanese', '0')\n",
      "(130, 'Total: Korean', '10')\n",
      "(131, 'Total: Laotian', '0')\n",
      "(132, 'Total: Malaysian', '0')\n",
      "(133, 'Total: Mongolian', '0')\n",
      "(134, 'Total: Nepalese', '5')\n",
      "(135, 'Total: Okinawan', '0')\n",
      "(136, 'Total: Pakistani', '0')\n",
      "(137, 'Total: Sri Lankan', '0')\n",
      "(138, 'Total: Taiwanese', '0')\n",
      "(139, 'Total: Thai', '0')\n",
      "(140, 'Total: Vietnamese', '0')\n",
      "(141, 'Total: Other Asian, Specified', '0')\n",
      "(142, 'Total: Other Asian, Not Specified', '7')\n",
      "(143, 'Total: Two or More Asian', '0')\n",
      "(144, 'Average Household Size', nan)\n",
      "(145, 'Average Household Size for Renter-Occupied Housing Units', nan)\n",
      "(146, 'Population 25 Years and Over:', '5322')\n",
      "(147, 'Population 25 Years and Over: Less than High School', '3141')\n",
      "(148, 'Population 25 Years and Over: High School Graduate (Includes Equivalency)', '1382')\n",
      "(149, 'Population 25 Years and Over: Some College', '723')\n",
      "(150, \"Population 25 Years and Over: Bachelor's Degree\", '35')\n",
      "(151, \"Population 25 Years and Over: Master's Degree\", '41')\n",
      "(152, 'Population 25 Years and Over: Professional School Degree', '0')\n",
      "(153, 'Population 25 Years and Over: Doctorate Degree', '0')\n",
      "(154, 'Population 16 Years and Over:', '7503')\n",
      "(155, 'Population 16 Years and Over: in Labor Force', '0')\n",
      "(156, 'Population 16 Years and Over: in Labor Force: in Armed Forces', '0')\n",
      "(157, 'Population 16 Years and Over: in Labor Force: Civilian', '0')\n",
      "(158, 'Population 16 Years and Over: in Labor Force: Civilian: Employed', '0')\n",
      "(159, 'Population 16 Years and Over: in Labor Force: Civilian: Unemployed', '0')\n",
      "(160, 'Population 16 Years and Over: Not in Labor Force', '7503')\n",
      "(161, 'Civilian Population in Labor Force 16 Years and Over:', '0')\n",
      "(162, 'Civilian Population in Labor Force 16 Years and Over: Employed', '0')\n",
      "(163, 'Civilian Population in Labor Force 16 Years and Over: Unemployed', '0')\n",
      "(164, 'Employed Civilian Population 16 Years and Over:', '0')\n",
      "(165, 'Employed Civilian Population 16 Years and Over: Private Sector', '0')\n",
      "(166, 'Employed Civilian Population 16 Years and Over: Public Sector', '0')\n",
      "(167, 'Employed Civilian Population 16 Years and Over: Self-Employed (Incorporated and Not Incorporated)', '0')\n",
      "(168, 'Employed Civilian Population 16 Years and Over: Private Non-Profit', '0')\n",
      "(169, 'Employed Civilian Population 16 Years and Over: Unpaid Family Workers', '0')\n",
      "(170, 'Occupied Housing Units', '0')\n",
      "(171, 'Occupied Housing Units: Less than $20,000', '0')\n",
      "(172, 'Occupied Housing Units: Less than $20,000: Less than 20 Percent', '0')\n",
      "(173, 'Occupied Housing Units: Less than $20,000: 20 to 29 Percent', '0')\n",
      "(174, 'Occupied Housing Units: Less than $20,000: 30 Percent or More', '0')\n",
      "(175, 'Occupied Housing Units: $20,000 to $34,999', '0')\n",
      "(176, 'Occupied Housing Units: $20,000 to $34,999: Less than 20 Percent', '0')\n",
      "(177, 'Occupied Housing Units: $20,000 to $34,999: 20 to 29 Percent', '0')\n",
      "(178, 'Occupied Housing Units: $20,000 to $34,999: 30 Percent or More', '0')\n",
      "(179, 'Occupied Housing Units: $35,000 to $49,999', '0')\n",
      "(180, 'Occupied Housing Units: $35,000 to $49,999: Less than 20 Percent', '0')\n",
      "(181, 'Occupied Housing Units: $35,000 to $49,999: 20 to 29 Percent', '0')\n",
      "(182, 'Occupied Housing Units: $35,000 to $49,999: 30 Percent or More', '0')\n",
      "(183, 'Occupied Housing Units: $50,000 to $74,999', '0')\n",
      "(184, 'Occupied Housing Units: $50,000 to $74,999: Less than 20 Percent', '0')\n",
      "(185, 'Occupied Housing Units: $50,000 to $74,999: 20 to 29 Percent', '0')\n",
      "(186, 'Occupied Housing Units: $50,000 to $74,999: 30 Percent or More', '0')\n",
      "(187, 'Occupied Housing Units: $75,000 or More', '0')\n",
      "(188, 'Occupied Housing Units: $75,000 or More: Less than 20 Percent', '0')\n",
      "(189, 'Occupied Housing Units: $75,000 or More: 20 to 29 Percent', '0')\n",
      "(190, 'Occupied Housing Units: $75,000 or More: 30 Percent or More', '0')\n",
      "(191, 'Occupied Housing Units: Zero or Negative Income', '0')\n",
      "(192, 'Occupied Housing Units: No Cash Rent', '0')\n",
      "(193, 'Median Household Income (In 2016 Inflation Adjusted Dollars)', nan)\n",
      "(194, 'Per Capita Income (In 2016 Inflation Adjusted Dollars)', '2332')\n",
      "(195, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).1', '2635')\n",
      "(196, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).2', '2189')\n",
      "(197, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).3', nan)\n",
      "(198, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).4', nan)\n",
      "(199, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).5', nan)\n",
      "(200, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).6', '2696')\n",
      "(201, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).7', '3677')\n",
      "(202, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).8', '2517')\n",
      "(203, 'Per Capita Income (In 2016 Inflation Adjusted Dollars).9', '4369')\n",
      "(204, 'Gini Index', nan)\n",
      "(205, 'Housing Units', '0')\n",
      "(206, 'Housing Units:', '0')\n",
      "(207, 'Housing Units: Occupied', '0')\n",
      "(208, 'Housing Units: Vacant', '0')\n",
      "(209, 'Vacant Housing Units:', '0')\n",
      "(210, 'Vacant Housing Units: for Rent', '0')\n",
      "(211, 'Vacant Housing Units: for Sale Only', '0')\n",
      "(212, 'Vacant Housing Units: Other Vacant', '0')\n",
      "(213, 'Renter-Occupied Housing Units', '0')\n",
      "(214, 'Renter-Occupied Housing Units: Built 2014 or Later', '0')\n",
      "(215, 'Renter-Occupied Housing Units: Built 2010 to 2013', '0')\n",
      "(216, 'Renter-Occupied Housing Units: Built 2000 to 2009', '0')\n",
      "(217, 'Renter-Occupied Housing Units: Built 1990 to 1999', '0')\n",
      "(218, 'Renter-Occupied Housing Units: Built 1980 to 1989', '0')\n",
      "(219, 'Renter-Occupied Housing Units: Built 1970 to 1979', '0')\n",
      "(220, 'Renter-Occupied Housing Units: Built 1960 to 1969', '0')\n",
      "(221, 'Renter-Occupied Housing Units: Built 1950 to 1959', '0')\n",
      "(222, 'Renter-Occupied Housing Units: Built 1940 to 1949', '0')\n",
      "(223, 'Renter-Occupied Housing Units: Built 1939 or Earlier', '0')\n",
      "(224, 'Renter-Occupied Housing Units.1', '0')\n",
      "(225, 'Renter-Occupied Housing Units: 0.50 or Less Occupants Per Room', '0')\n",
      "(226, 'Renter-Occupied Housing Units: 0.51 to 1.00 Occupants Per Room', '0')\n",
      "(227, 'Renter-Occupied Housing Units: 1.01 to 1.50 Occupants Per Room', '0')\n",
      "(228, 'Renter-Occupied Housing Units: 1.51 to 2.00 Occupants Per Room', '0')\n",
      "(229, 'Renter-Occupied Housing Units: 2.01 or More Occupants Per Room', '0')\n",
      "(230, 'Renter-Occupied Housing Units.2', '0')\n",
      "(231, 'Renter-Occupied Housing Units: 1 Room', '0')\n",
      "(232, 'Renter-Occupied Housing Units: 2 Rooms', '0')\n",
      "(233, 'Renter-Occupied Housing Units: 3 Rooms', '0')\n",
      "(234, 'Renter-Occupied Housing Units: 4 Rooms', '0')\n",
      "(235, 'Renter-Occupied Housing Units: 5 Rooms', '0')\n",
      "(236, 'Renter-Occupied Housing Units: 6 Rooms', '0')\n",
      "(237, 'Renter-Occupied Housing Units: 7 Rooms', '0')\n",
      "(238, 'Renter-Occupied Housing Units: 8 Rooms', '0')\n",
      "(239, 'Renter-Occupied Housing Units: 9 or More Rooms', '0')\n",
      "(240, 'Median Year Structure Built', nan)\n",
      "(241, 'Occupied Housing Units:', '0')\n",
      "(242, 'Occupied Housing Units: Gas (Utility, Bottled, Tank, or Lp Gas)', '0')\n",
      "(243, 'Occupied Housing Units: Electricity', '0')\n",
      "(244, 'Occupied Housing Units: Fuel Oil, Kerosene, Etc.', '0')\n",
      "(245, 'Occupied Housing Units: Coal, Coke or Wood', '0')\n",
      "(246, 'Occupied Housing Units: Solar Energy', '0')\n",
      "(247, 'Occupied Housing Units: Other Fuel', '0')\n",
      "(248, 'Occupied Housing Units: No Fuel Used', '0')\n",
      "(249, 'Median Value', nan)\n",
      "(250, 'Median Gross Rent', nan)\n",
      "(251, 'Population for Whom Poverty Status Is Determined:', '0')\n",
      "(252, 'Population for Whom Poverty Status Is Determined: Under 1.00 (Doing Poorly)', '0')\n",
      "(253, 'Population for Whom Poverty Status Is Determined: 1.00 to 1.99 (Struggling)', '0')\n",
      "(254, 'Population for Whom Poverty Status Is Determined: Under 2.00 (Poor or Struggling)', '0')\n",
      "(255, 'Population for Whom Poverty Status Is Determined: 2.00 and Over (Doing Ok)', '0')\n",
      "(256, 'Workers 16 Years and Over:', '0')\n",
      "(257, 'Workers 16 Years and Over: Car, Truck, or Van', '0')\n",
      "(258, 'Workers 16 Years and Over: Drove Alone', '0')\n",
      "(259, 'Workers 16 Years and Over: Carpooled', '0')\n",
      "(260, 'Workers 16 Years and Over: Public Transportation (Includes Taxicab)', '0')\n",
      "(261, 'Workers 16 Years and Over: Motorcycle', '0')\n",
      "(262, 'Workers 16 Years and Over: Bicycle', '0')\n",
      "(263, 'Workers 16 Years and Over: Walked', '0')\n",
      "(264, 'Workers 16 Years and Over: Other Means', '0')\n",
      "(265, 'Workers 16 Years and Over: Worked At Home', '0')\n",
      "(266, 'Average Commute to Work (in Min)', nan)\n",
      "(267, 'Renter-Occupied Housing Units.3', '0')\n",
      "(268, 'Renter-Occupied Housing Units: No Vehicle Available', '0')\n",
      "(269, 'Renter-Occupied Housing Units: 1 Vehicle Available', '0')\n",
      "(270, 'Renter-Occupied Housing Units: 2 Vehicles Available', '0')\n",
      "(271, 'Renter-Occupied Housing Units: 3 Vehicles Available', '0')\n",
      "(272, 'Renter-Occupied Housing Units: 4 Vehicles Available', '0')\n",
      "(273, 'Renter-Occupied Housing Units: 5 or More Vehicles Available', '0')\n",
      "(274, 'Total Population:.2', '7503')\n",
      "(275, 'Total Population: Native Born', '6287')\n",
      "(276, 'Total Population: Foreign Born', '1216')\n",
      "(277, 'Total Population: Foreign Born: Naturalized Citizen', '346')\n",
      "(278, 'Total Population: Foreign Born: Not a Citizen', '870')\n",
      "(279, 'Foreign-Born Population:', '1216')\n",
      "(280, 'Foreign-Born Population: 2010 or Later', '122')\n",
      "(281, 'Foreign-Born Population: 2000 to 2009', '357')\n",
      "(282, 'Foreign-Born Population: 1990 to 1999', '409')\n",
      "(283, 'Foreign-Born Population: Before 1990', '328')\n",
      "(284, 'Total:.1', '7503')\n",
      "(285, 'Total: Ancestry Specified', '7465')\n",
      "(286, 'Total: Ancestry Specified: Single Ancestry', '7048')\n",
      "(287, 'Total: Ancestry Specified: Multiple Ancestry', '417')\n",
      "(288, 'Total: Ancestry Not Specified', '38')\n",
      "(289, 'Total: Ancestry Not Specified: Ancestry Unclassified', '0')\n",
      "(290, 'Total: Ancestry Not Specified: Ancestry Not Reported', '38')\n",
      "(291, 'Total Population.3', '7503')\n",
      "(292, 'Total Population: Afghan', '0')\n",
      "(293, 'Total Population: Albanian', '11')\n",
      "(294, 'Total Population: Alsatian', '0')\n",
      "(295, 'Total Population: American', '226')\n",
      "(296, 'Total Population: Arab', '19')\n",
      "(297, 'Total Population: Arab: Egyptian', '8')\n",
      "(298, 'Total Population: Arab: Iraqi', '0')\n",
      "(299, 'Total Population: Arab: Jordanian', '0')\n",
      "(300, 'Total Population: Arab: Lebanese', '6')\n",
      "(301, 'Total Population: Arab: Moroccan', '5')\n",
      "(302, 'Total Population: Arab: Palestinian', '0')\n",
      "(303, 'Total Population: Arab: Syrian', '0')\n",
      "(304, 'Total Population: Arab: Arab', '0')\n",
      "(305, 'Total Population: Arab: Other Arab', '0')\n",
      "(306, 'Total Population: Armenian', '0')\n",
      "(307, 'Total Population: Assyrian/Chaldean/Syriac', '0')\n",
      "(308, 'Total Population: Australian', '0')\n",
      "(309, 'Total Population: Austrian', '0')\n",
      "(310, 'Total Population: Basque', '0')\n",
      "(311, 'Total Population: Belgian', '0')\n",
      "(312, 'Total Population: Brazilian', '0')\n",
      "(313, 'Total Population: British', '16')\n",
      "(314, 'Total Population: Bulgarian', '0')\n",
      "(315, 'Total Population: Cajun', '0')\n",
      "(316, 'Total Population: Canadian', '0')\n",
      "(317, 'Total Population: Carpatho Rusyn', '0')\n",
      "(318, 'Total Population: Celtic', '0')\n",
      "(319, 'Total Population: Croatian', '0')\n",
      "(320, 'Total Population: Cypriot', '0')\n",
      "(321, 'Total Population: Czech', '0')\n",
      "(322, 'Total Population: Czechoslovakian', '0')\n",
      "(323, 'Total Population: Danish', '0')\n",
      "(324, 'Total Population: Dutch', '0')\n",
      "(325, 'Total Population: Eastern European', '0')\n",
      "(326, 'Total Population: English', '0')\n",
      "(327, 'Total Population: Estonian', '0')\n",
      "(328, 'Total Population: European', '0')\n",
      "(329, 'Total Population: Finnish', '0')\n",
      "(330, 'Total Population: French (Except Basque)', '0')\n",
      "(331, 'Total Population: French Canadian', '0')\n",
      "(332, 'Total Population: German', '30')\n",
      "(333, 'Total Population: German Russian', '0')\n",
      "(334, 'Total Population: Greek', '0')\n",
      "(335, 'Total Population: Guyanese', '49')\n",
      "(336, 'Total Population: Hungarian', '0')\n",
      "(337, 'Total Population: Icelander', '0')\n",
      "(338, 'Total Population: Iranian', '8')\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(339, 'Total Population: Irish', '49')\n",
      "(340, 'Total Population: Israeli', '0')\n",
      "(341, 'Total Population: Italian', '31')\n",
      "(342, 'Total Population: Latvian', '0')\n",
      "(343, 'Total Population: Lithuanian', '0')\n",
      "(344, 'Total Population: Luxemburger', '0')\n",
      "(345, 'Total Population: Macedonian', '0')\n",
      "(346, 'Total Population: Maltese', '0')\n",
      "(347, 'Total Population: New Zealander', '0')\n",
      "(348, 'Total Population: Northern European', '0')\n",
      "(349, 'Total Population: Norwegian', '0')\n",
      "(350, 'Total Population: Pennsylvania German', '0')\n",
      "(351, 'Total Population: Polish', '34')\n",
      "(352, 'Total Population: Portuguese', '9')\n",
      "(353, 'Total Population: Romanian', '34')\n",
      "(354, 'Total Population: Russian', '33')\n",
      "(355, 'Total Population: Scandinavian', '0')\n",
      "(356, 'Total Population: Scotch-Irish', '0')\n",
      "(357, 'Total Population: Scottish', '0')\n",
      "(358, 'Total Population: Serbian', '0')\n",
      "(359, 'Total Population: Slavic', '0')\n",
      "(360, 'Total Population: Slovak', '0')\n",
      "(361, 'Total Population: Slovene', '0')\n",
      "(362, 'Total Population: Soviet Union', '0')\n",
      "(363, 'Total Population: Sub-Saharan African', '63')\n",
      "(364, 'Total Population: Sub-Saharan African: Cape Verdean', '0')\n",
      "(365, 'Total Population: Sub-Saharan African: Ethiopian', '0')\n",
      "(366, 'Total Population: Sub-Saharan African: Ghanaian', '0')\n",
      "(367, 'Total Population: Sub-Saharan African: Kenyan', '0')\n",
      "(368, 'Total Population: Sub-Saharan African: Liberian', '0')\n",
      "(369, 'Total Population: Sub-Saharan African: Nigerian', '12')\n",
      "(370, 'Total Population: Sub-Saharan African: Senegalese', '0')\n",
      "(371, 'Total Population: Sub-Saharan African: Sierra Leonean', '0')\n",
      "(372, 'Total Population: Sub-Saharan African: Somali', '0')\n",
      "(373, 'Total Population: Sub-Saharan African: South African', '0')\n",
      "(374, 'Total Population: Sub-Saharan African: Sudanese', '0')\n",
      "(375, 'Total Population: Sub-Saharan African: Ugandan', '0')\n",
      "(376, 'Total Population: Sub-Saharan African: Zimbabwean', '0')\n",
      "(377, 'Total Population: Sub-Saharan African: African', '51')\n",
      "(378, 'Total Population: Sub-Saharan African: Other Sub-Saharan African', '0')\n",
      "(379, 'Total Population: Swedish', '0')\n",
      "(380, 'Total Population: Swiss', '0')\n",
      "(381, 'Total Population: Turkish', '0')\n",
      "(382, 'Total Population: Ukrainian', '5')\n",
      "(383, 'Total Population: Welsh', '0')\n",
      "(384, 'Total Population: West Indian (Except Hispanic Groups)', '283')\n",
      "(385, 'Total Population: West Indian (Except Hispanic Groups): Bahamian', '0')\n",
      "(386, 'Total Population: West Indian (Except Hispanic Groups): Barbadian', '7')\n",
      "(387, 'Total Population: West Indian (Except Hispanic Groups): Belizean', '0')\n",
      "(388, 'Total Population: West Indian (Except Hispanic Groups): Bermudan', '0')\n",
      "(389, 'Total Population: West Indian (Except Hispanic Groups): British West Indian', '10')\n",
      "(390, 'Total Population: West Indian (Except Hispanic Groups): Dutch West Indian', '0')\n",
      "(391, 'Total Population: West Indian (Except Hispanic Groups): Haitian', '46')\n",
      "(392, 'Total Population: West Indian (Except Hispanic Groups): Jamaican', '124')\n",
      "(393, 'Total Population: West Indian (Except Hispanic Groups): Trinidadian and Tobagonian', '77')\n",
      "(394, 'Total Population: West Indian (Except Hispanic Groups): U.s. Virgin Islander', '12')\n",
      "(395, 'Total Population: West Indian (Except Hispanic Groups): West Indian', '7')\n",
      "(396, 'Total Population: West Indian (Except Hispanic Groups): Other West Indian', '0')\n",
      "(397, 'Total Population: Yugoslavian', '0')\n",
      "(398, 'Total Population: Other Groups', '6694')\n",
      "(399, 'Total Population: Unclassified or Not Reported', '38')\n",
      "(400, 'People Reporting Single Ancestry', '7048')\n",
      "(401, 'People Reporting Single Ancestry: Afghan', '0')\n",
      "(402, 'People Reporting Single Ancestry: Albanian', '11')\n",
      "(403, 'People Reporting Single Ancestry: Alsatian', '0')\n",
      "(404, 'People Reporting Single Ancestry: American', '197')\n",
      "(405, 'People Reporting Single Ancestry: Arab', '13')\n",
      "(406, 'People Reporting Single Ancestry: Arab: Egyptian', '8')\n",
      "(407, 'People Reporting Single Ancestry: Arab: Iraqi', '0')\n",
      "(408, 'People Reporting Single Ancestry: Arab: Jordanian', '0')\n",
      "(409, 'People Reporting Single Ancestry: Arab: Lebanese', '0')\n",
      "(410, 'People Reporting Single Ancestry: Arab: Moroccan', '5')\n",
      "(411, 'People Reporting Single Ancestry: Arab: Palestinian', '0')\n",
      "(412, 'People Reporting Single Ancestry: Arab: Syrian', '0')\n",
      "(413, 'People Reporting Single Ancestry: Arab: Arab', '0')\n",
      "(414, 'People Reporting Single Ancestry: Arab: Other Arab', '0')\n",
      "(415, 'People Reporting Single Ancestry: Armenian', '0')\n",
      "(416, 'People Reporting Single Ancestry: Assyrian/Chaldean/Syriac', '0')\n",
      "(417, 'People Reporting Single Ancestry: Australian', '0')\n",
      "(418, 'People Reporting Single Ancestry: Austrian', '0')\n",
      "(419, 'People Reporting Single Ancestry: Basque', '0')\n",
      "(420, 'People Reporting Single Ancestry: Belgian', '0')\n",
      "(421, 'People Reporting Single Ancestry: Brazilian', '0')\n",
      "(422, 'People Reporting Single Ancestry: British', '0')\n",
      "(423, 'People Reporting Single Ancestry: Bulgarian', '0')\n",
      "(424, 'People Reporting Single Ancestry: Cajun', '0')\n",
      "(425, 'People Reporting Single Ancestry: Canadian', '0')\n",
      "(426, 'People Reporting Single Ancestry: Carpatho Rusyn', '0')\n",
      "(427, 'People Reporting Single Ancestry: Celtic', '0')\n",
      "(428, 'People Reporting Single Ancestry: Croatian', '0')\n",
      "(429, 'People Reporting Single Ancestry: Cypriot', '0')\n",
      "(430, 'People Reporting Single Ancestry: Czech', '0')\n",
      "(431, 'People Reporting Single Ancestry: Czechoslovakian', '0')\n",
      "(432, 'People Reporting Single Ancestry: Danish', '0')\n",
      "(433, 'People Reporting Single Ancestry: Dutch', '0')\n",
      "(434, 'People Reporting Single Ancestry: Eastern European', '0')\n",
      "(435, 'People Reporting Single Ancestry: English', '0')\n",
      "(436, 'People Reporting Single Ancestry: Estonian', '0')\n",
      "(437, 'People Reporting Single Ancestry: European', '0')\n",
      "(438, 'People Reporting Single Ancestry: Finnish', '0')\n",
      "(439, 'People Reporting Single Ancestry: French (Except Basque)', '0')\n",
      "(440, 'People Reporting Single Ancestry: French Canadian', '0')\n",
      "(441, 'People Reporting Single Ancestry: German', '12')\n",
      "(442, 'People Reporting Single Ancestry: German Russian', '0')\n",
      "(443, 'People Reporting Single Ancestry: Greek', '0')\n",
      "(444, 'People Reporting Single Ancestry: Guyanese', '49')\n",
      "(445, 'People Reporting Single Ancestry: Hungarian', '0')\n",
      "(446, 'People Reporting Single Ancestry: Icelander', '0')\n",
      "(447, 'People Reporting Single Ancestry: Iranian', '0')\n",
      "(448, 'People Reporting Single Ancestry: Irish', '37')\n",
      "(449, 'People Reporting Single Ancestry: Israeli', '0')\n",
      "(450, 'People Reporting Single Ancestry: Italian', '24')\n",
      "(451, 'People Reporting Single Ancestry: Latvian', '0')\n",
      "(452, 'People Reporting Single Ancestry: Lithuanian', '0')\n",
      "(453, 'People Reporting Single Ancestry: Luxemburger', '0')\n",
      "(454, 'People Reporting Single Ancestry: Macedonian', '0')\n",
      "(455, 'People Reporting Single Ancestry: Maltese', '0')\n",
      "(456, 'People Reporting Single Ancestry: New Zealander', '0')\n",
      "(457, 'People Reporting Single Ancestry: Northern European', '0')\n",
      "(458, 'People Reporting Single Ancestry: Norwegian', '0')\n",
      "(459, 'People Reporting Single Ancestry: Pennsylvania German', '0')\n",
      "(460, 'People Reporting Single Ancestry: Polish', '22')\n",
      "(461, 'People Reporting Single Ancestry: Portuguese', '0')\n",
      "(462, 'People Reporting Single Ancestry: Romanian', '34')\n",
      "(463, 'People Reporting Single Ancestry: Russian', '33')\n",
      "(464, 'People Reporting Single Ancestry: Scandinavian', '0')\n",
      "(465, 'People Reporting Single Ancestry: Scotch-Irish', '0')\n",
      "(466, 'People Reporting Single Ancestry: Scottish', '0')\n",
      "(467, 'People Reporting Single Ancestry: Serbian', '0')\n",
      "(468, 'People Reporting Single Ancestry: Slavic', '0')\n",
      "(469, 'People Reporting Single Ancestry: Slovak', '0')\n",
      "(470, 'People Reporting Single Ancestry: Slovene', '0')\n",
      "(471, 'People Reporting Single Ancestry: Soviet Union', '0')\n",
      "(472, 'People Reporting Single Ancestry: Sub-Saharan African', '63')\n",
      "(473, 'People Reporting Single Ancestry: Sub-Saharan African: Cape Verdean', '0')\n",
      "(474, 'People Reporting Single Ancestry: Sub-Saharan African: Ethiopian', '0')\n",
      "(475, 'People Reporting Single Ancestry: Sub-Saharan African: Ghanaian', '0')\n",
      "(476, 'People Reporting Single Ancestry: Sub-Saharan African: Kenyan', '0')\n",
      "(477, 'People Reporting Single Ancestry: Sub-Saharan African: Liberian', '0')\n",
      "(478, 'People Reporting Single Ancestry: Sub-Saharan African: Nigerian', '12')\n",
      "(479, 'People Reporting Single Ancestry: Sub-Saharan African: Senegalese', '0')\n",
      "(480, 'People Reporting Single Ancestry: Sub-Saharan African: Sierra Leonean', '0')\n",
      "(481, 'People Reporting Single Ancestry: Sub-Saharan African: Somali', '0')\n",
      "(482, 'People Reporting Single Ancestry: Sub-Saharan African: South African', '0')\n",
      "(483, 'People Reporting Single Ancestry: Sub-Saharan African: Sudanese', '0')\n",
      "(484, 'People Reporting Single Ancestry: Sub-Saharan African: Ugandan', '0')\n",
      "(485, 'People Reporting Single Ancestry: Sub-Saharan African: Zimbabwean', '0')\n",
      "(486, 'People Reporting Single Ancestry: Sub-Saharan African: African', '51')\n",
      "(487, 'People Reporting Single Ancestry: Sub-Saharan African: Other Sub-Saharan African', '0')\n",
      "(488, 'People Reporting Single Ancestry: Swedish', '0')\n",
      "(489, 'People Reporting Single Ancestry: Swiss', '0')\n",
      "(490, 'People Reporting Single Ancestry: Turkish', '0')\n",
      "(491, 'People Reporting Single Ancestry: Ukrainian', '5')\n",
      "(492, 'People Reporting Single Ancestry: Welsh', '0')\n",
      "(493, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups)', '259')\n",
      "(494, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Bahamian', '0')\n",
      "(495, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Barbadian', '7')\n",
      "(496, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Belizean', '0')\n",
      "(497, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Bermudan', '0')\n",
      "(498, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): British West Indian', '10')\n",
      "(499, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Dutch West Indian', '0')\n",
      "(500, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Haitian', '29')\n",
      "(501, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Jamaican', '124')\n",
      "(502, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Trinidadian and Tobagonian', '77')\n",
      "(503, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): U.s. Virgin Islander', '12')\n",
      "(504, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): West Indian', '0')\n",
      "(505, 'People Reporting Single Ancestry: West Indian (Except Hispanic Groups): Other West Indian', '0')\n",
      "(506, 'People Reporting Single Ancestry: Yugoslavian', '0')\n",
      "(507, 'People Reporting Single Ancestry: Other Groups', '6289')\n",
      "(508, 'People Reporting Multiple Ancestries', '417')\n",
      "(509, 'People Reporting Multiple Ancestries: Afghan', '0')\n",
      "(510, 'People Reporting Multiple Ancestries: Albanian', '0')\n",
      "(511, 'People Reporting Multiple Ancestries: Alsatian', '0')\n",
      "(512, 'People Reporting Multiple Ancestries: American', '29')\n",
      "(513, 'People Reporting Multiple Ancestries: Arab', '6')\n",
      "(514, 'People Reporting Multiple Ancestries: Arab: Egyptian', '0')\n",
      "(515, 'People Reporting Multiple Ancestries: Arab: Iraqi', '0')\n",
      "(516, 'People Reporting Multiple Ancestries: Arab: Jordanian', '0')\n",
      "(517, 'People Reporting Multiple Ancestries: Arab: Lebanese', '6')\n",
      "(518, 'People Reporting Multiple Ancestries: Arab: Moroccan', '0')\n",
      "(519, 'People Reporting Multiple Ancestries: Arab: Palestinian', '0')\n",
      "(520, 'People Reporting Multiple Ancestries: Arab: Syrian', '0')\n",
      "(521, 'People Reporting Multiple Ancestries: Arab: Arab', '0')\n",
      "(522, 'People Reporting Multiple Ancestries: Arab: Other Arab', '0')\n",
      "(523, 'People Reporting Multiple Ancestries: Armenian', '0')\n",
      "(524, 'People Reporting Multiple Ancestries: Assyrian/Chaldean/Syriac', '0')\n",
      "(525, 'People Reporting Multiple Ancestries: Australian', '0')\n",
      "(526, 'People Reporting Multiple Ancestries: Austrian', '0')\n",
      "(527, 'People Reporting Multiple Ancestries: Basque', '0')\n",
      "(528, 'People Reporting Multiple Ancestries: Belgian', '0')\n",
      "(529, 'People Reporting Multiple Ancestries: Brazilian', '0')\n",
      "(530, 'People Reporting Multiple Ancestries: British', '16')\n",
      "(531, 'People Reporting Multiple Ancestries: Bulgarian', '0')\n",
      "(532, 'People Reporting Multiple Ancestries: Cajun', '0')\n",
      "(533, 'People Reporting Multiple Ancestries: Canadian', '0')\n",
      "(534, 'People Reporting Multiple Ancestries: Carpatho Rusyn', '0')\n",
      "(535, 'People Reporting Multiple Ancestries: Celtic', '0')\n",
      "(536, 'People Reporting Multiple Ancestries: Croatian', '0')\n",
      "(537, 'People Reporting Multiple Ancestries: Cypriot', '0')\n",
      "(538, 'People Reporting Multiple Ancestries: Czech', '0')\n",
      "(539, 'People Reporting Multiple Ancestries: Czechoslovakian', '0')\n",
      "(540, 'People Reporting Multiple Ancestries: Danish', '0')\n",
      "(541, 'People Reporting Multiple Ancestries: Dutch', '0')\n",
      "(542, 'People Reporting Multiple Ancestries: Eastern European', '0')\n",
      "(543, 'People Reporting Multiple Ancestries: English', '0')\n",
      "(544, 'People Reporting Multiple Ancestries: Estonian', '0')\n",
      "(545, 'People Reporting Multiple Ancestries: European', '0')\n",
      "(546, 'People Reporting Multiple Ancestries: Finnish', '0')\n",
      "(547, 'People Reporting Multiple Ancestries: French (Except Basque)', '0')\n",
      "(548, 'People Reporting Multiple Ancestries: French Canadian', '0')\n",
      "(549, 'People Reporting Multiple Ancestries: German', '18')\n",
      "(550, 'People Reporting Multiple Ancestries: German Russian', '0')\n",
      "(551, 'People Reporting Multiple Ancestries: Greek', '0')\n",
      "(552, 'People Reporting Multiple Ancestries: Guyanese', '0')\n",
      "(553, 'People Reporting Multiple Ancestries: Hungarian', '0')\n",
      "(554, 'People Reporting Multiple Ancestries: Icelander', '0')\n",
      "(555, 'People Reporting Multiple Ancestries: Iranian', '8')\n",
      "(556, 'People Reporting Multiple Ancestries: Irish', '12')\n",
      "(557, 'People Reporting Multiple Ancestries: Israeli', '0')\n",
      "(558, 'People Reporting Multiple Ancestries: Italian', '7')\n",
      "(559, 'People Reporting Multiple Ancestries: Latvian', '0')\n",
      "(560, 'People Reporting Multiple Ancestries: Lithuanian', '0')\n",
      "(561, 'People Reporting Multiple Ancestries: Luxemburger', '0')\n",
      "(562, 'People Reporting Multiple Ancestries: Macedonian', '0')\n",
      "(563, 'People Reporting Multiple Ancestries: Maltese', '0')\n",
      "(564, 'People Reporting Multiple Ancestries: New Zealander', '0')\n",
      "(565, 'People Reporting Multiple Ancestries: Northern European', '0')\n",
      "(566, 'People Reporting Multiple Ancestries: Norwegian', '0')\n",
      "(567, 'People Reporting Multiple Ancestries: Pennsylvania German', '0')\n",
      "(568, 'People Reporting Multiple Ancestries: Polish', '12')\n",
      "(569, 'People Reporting Multiple Ancestries: Portuguese', '9')\n",
      "(570, 'People Reporting Multiple Ancestries: Romanian', '0')\n",
      "(571, 'People Reporting Multiple Ancestries: Russian', '0')\n",
      "(572, 'People Reporting Multiple Ancestries: Scandinavian', '0')\n",
      "(573, 'People Reporting Multiple Ancestries: Scotch-Irish', '0')\n",
      "(574, 'People Reporting Multiple Ancestries: Scottish', '0')\n",
      "(575, 'People Reporting Multiple Ancestries: Serbian', '0')\n",
      "(576, 'People Reporting Multiple Ancestries: Slavic', '0')\n",
      "(577, 'People Reporting Multiple Ancestries: Slovak', '0')\n",
      "(578, 'People Reporting Multiple Ancestries: Slovene', '0')\n",
      "(579, 'People Reporting Multiple Ancestries: Soviet Union', '0')\n",
      "(580, 'People Reporting Multiple Ancestries: Sub-Saharan African', '0')\n",
      "(581, 'People Reporting Multiple Ancestries: Sub-Saharan African: Cape Verdean', '0')\n",
      "(582, 'People Reporting Multiple Ancestries: Sub-Saharan African: Ethiopian', '0')\n",
      "(583, 'People Reporting Multiple Ancestries: Sub-Saharan African: Ghanaian', '0')\n",
      "(584, 'People Reporting Multiple Ancestries: Sub-Saharan African: Kenyan', '0')\n",
      "(585, 'People Reporting Multiple Ancestries: Sub-Saharan African: Liberian', '0')\n",
      "(586, 'People Reporting Multiple Ancestries: Sub-Saharan African: Nigerian', '0')\n",
      "(587, 'People Reporting Multiple Ancestries: Sub-Saharan African: Senegalese', '0')\n",
      "(588, 'People Reporting Multiple Ancestries: Sub-Saharan African: Sierra Leonean', '0')\n",
      "(589, 'People Reporting Multiple Ancestries: Sub-Saharan African: Somali', '0')\n",
      "(590, 'People Reporting Multiple Ancestries: Sub-Saharan African: South African', '0')\n",
      "(591, 'People Reporting Multiple Ancestries: Sub-Saharan African: Sudanese', '0')\n",
      "(592, 'People Reporting Multiple Ancestries: Sub-Saharan African: Ugandan', '0')\n",
      "(593, 'People Reporting Multiple Ancestries: Sub-Saharan African: Zimbabwean', '0')\n",
      "(594, 'People Reporting Multiple Ancestries: Sub-Saharan African: African', '0')\n",
      "(595, 'People Reporting Multiple Ancestries: Sub-Saharan African: Other Sub-Saharan African', '0')\n",
      "(596, 'People Reporting Multiple Ancestries: Swedish', '0')\n",
      "(597, 'People Reporting Multiple Ancestries: Swiss', '0')\n",
      "(598, 'People Reporting Multiple Ancestries: Turkish', '0')\n",
      "(599, 'People Reporting Multiple Ancestries: Ukrainian', '0')\n",
      "(600, 'People Reporting Multiple Ancestries: Welsh', '0')\n",
      "(601, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups)', '24')\n",
      "(602, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Bahamian', '0')\n",
      "(603, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Barbadian', '0')\n",
      "(604, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Belizean', '0')\n",
      "(605, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Bermudan', '0')\n",
      "(606, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): British West Indian', '0')\n",
      "(607, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Dutch West Indian', '0')\n",
      "(608, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Haitian', '17')\n",
      "(609, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Jamaican', '0')\n",
      "(610, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Trinidadian and Tobagonian', '0')\n",
      "(611, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): U.s. Virgin Islander', '0')\n",
      "(612, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): West Indian', '7')\n",
      "(613, 'People Reporting Multiple Ancestries: West Indian (Except Hispanic Groups): Other West Indian', '0')\n",
      "(614, 'People Reporting Multiple Ancestries: Yugoslavian', '0')\n",
      "(615, 'People Reporting Multiple Ancestries: Other Groups', '405')\n",
      "(616, 'Foreign-Born Population:.1', '1216')\n",
      "(617, 'Foreign-Born Population: Europe', '121')\n",
      "(618, 'Foreign-Born Population: Europe: Northern Europe', '15')\n",
      "(619, 'Foreign-Born Population: Europe: Northern Europe: United Kingdom', '15')\n",
      "(620, 'Foreign-Born Population: Europe: Northern Europe: United Kingdom: United Kingdom, Excluding England and Scotland', '0')\n",
      "(621, 'Foreign-Born Population: Europe: Northern Europe: United Kingdom: England', '15')\n",
      "(622, 'Foreign-Born Population: Europe: Northern Europe: United Kingdom: Scotland', '0')\n",
      "(623, 'Foreign-Born Population: Europe: Northern Europe: Ireland', '0')\n",
      "(624, 'Foreign-Born Population: Europe: Northern Europe: Other Northern Europe', '0')\n",
      "(625, 'Foreign-Born Population: Europe: Western Europe', '12')\n",
      "(626, 'Foreign-Born Population: Europe: Western Europe: Austria', '0')\n",
      "(627, 'Foreign-Born Population: Europe: Western Europe: France', '0')\n",
      "(628, 'Foreign-Born Population: Europe: Western Europe: Germany', '12')\n",
      "(629, 'Foreign-Born Population: Europe: Western Europe: Netherlands', '0')\n",
      "(630, 'Foreign-Born Population: Europe: Western Europe: Other Western Europe', '0')\n",
      "(631, 'Foreign-Born Population: Europe: Southern Europe', '9')\n",
      "(632, 'Foreign-Born Population: Europe: Southern Europe: Greece', '0')\n",
      "(633, 'Foreign-Born Population: Europe: Southern Europe: Italy', '0')\n",
      "(634, 'Foreign-Born Population: Europe: Southern Europe: Portugal', '9')\n",
      "(635, 'Foreign-Born Population: Europe: Southern Europe: Spain', '0')\n",
      "(636, 'Foreign-Born Population: Europe: Southern Europe: Other Southern Europe', '0')\n",
      "(637, 'Foreign-Born Population: Europe: Eastern Europe', '85')\n",
      "(638, 'Foreign-Born Population: Europe: Eastern Europe: Croatia', '0')\n",
      "(639, 'Foreign-Born Population: Europe: Eastern Europe: Czechoslovakia (Includes Czech Republic and Slovakia)', '0')\n",
      "(640, 'Foreign-Born Population: Europe: Eastern Europe: Hungary', '0')\n",
      "(641, 'Foreign-Born Population: Europe: Eastern Europe: Poland', '31')\n",
      "(642, 'Foreign-Born Population: Europe: Eastern Europe: Romania', '21')\n",
      "(643, 'Foreign-Born Population: Europe: Eastern Europe: Russia', '28')\n",
      "(644, 'Foreign-Born Population: Europe: Eastern Europe: Ukraine', '5')\n",
      "(645, 'Foreign-Born Population: Europe: Eastern Europe: Bosnia and Herzegovina', '0')\n",
      "(646, 'Foreign-Born Population: Europe: Eastern Europe: Serbia', '0')\n",
      "(647, 'Foreign-Born Population: Europe: Eastern Europe: Other Eastern Europe', '0')\n",
      "(648, 'Foreign-Born Population: Europe: Europe, N.e.c.', '0')\n",
      "(649, 'Foreign-Born Population: Asia', '87')\n",
      "(650, 'Foreign-Born Population: Asia: Eastern Asia', '39')\n",
      "(651, 'Foreign-Born Population: Asia: Eastern Asia: China', '39')\n",
      "(652, 'Foreign-Born Population: Asia: Eastern Asia: China: China, Excluding Hong Kong and Taiwan', '39')\n",
      "(653, 'Foreign-Born Population: Asia: Eastern Asia: China: Hong Kong', '0')\n",
      "(654, 'Foreign-Born Population: Asia: Eastern Asia: China: Taiwan', '0')\n",
      "(655, 'Foreign-Born Population: Asia: Eastern Asia: Japan', '0')\n",
      "(656, 'Foreign-Born Population: Asia: Eastern Asia: Korea', '0')\n",
      "(657, 'Foreign-Born Population: Asia: Eastern Asia: Other Eastern Asia', '0')\n",
      "(658, 'Foreign-Born Population: Asia: South Central Asia', '48')\n",
      "(659, 'Foreign-Born Population: Asia: South Central Asia: Afghanistan', '0')\n",
      "(660, 'Foreign-Born Population: Asia: South Central Asia: Bangladesh', '19')\n",
      "(661, 'Foreign-Born Population: Asia: South Central Asia: India', '9')\n",
      "(662, 'Foreign-Born Population: Asia: South Central Asia: Iran', '0')\n",
      "(663, 'Foreign-Born Population: Asia: South Central Asia: Pakistan', '0')\n",
      "(664, 'Foreign-Born Population: Asia: South Central Asia: Other South Central Asia', '20')\n",
      "(665, 'Foreign-Born Population: Asia: South Eastern Asia', '0')\n",
      "(666, 'Foreign-Born Population: Asia: South Eastern Asia: Cambodia', '0')\n",
      "(667, 'Foreign-Born Population: Asia: South Eastern Asia: Indonesia', '0')\n",
      "(668, 'Foreign-Born Population: Asia: South Eastern Asia: Laos', '0')\n",
      "(669, 'Foreign-Born Population: Asia: South Eastern Asia: Philippines', '0')\n",
      "(670, 'Foreign-Born Population: Asia: South Eastern Asia: Thailand', '0')\n",
      "(671, 'Foreign-Born Population: Asia: South Eastern Asia: Vietnam', '0')\n",
      "(672, 'Foreign-Born Population: Asia: South Eastern Asia: Other South Eastern Asia', '0')\n",
      "(673, 'Foreign-Born Population: Asia: Western Asia', '0')\n",
      "(674, 'Foreign-Born Population: Asia: Western Asia: Iraq', '0')\n",
      "(675, 'Foreign-Born Population: Asia: Western Asia: Israel', '0')\n",
      "(676, 'Foreign-Born Population: Asia: Western Asia: Lebanon', '0')\n",
      "(677, 'Foreign-Born Population: Asia: Western Asia: Syria', '0')\n",
      "(678, 'Foreign-Born Population: Asia: Western Asia: Turkey', '0')\n",
      "(679, 'Foreign-Born Population: Asia: Western Asia: Armenia', '0')\n",
      "(680, 'Foreign-Born Population: Asia: Western Asia: Other Western Asia', '0')\n",
      "(681, 'Foreign-Born Population: Asia: Asia, N.e.c.', '0')\n",
      "(682, 'Foreign-Born Population: Africa', '56')\n",
      "(683, 'Foreign-Born Population: Africa: Eastern Africa', '0')\n",
      "(684, 'Foreign-Born Population: Africa: Eastern Africa: Ethiopia', '0')\n",
      "(685, 'Foreign-Born Population: Africa: Eastern Africa: Kenya', '0')\n",
      "(686, 'Foreign-Born Population: Africa: Eastern Africa: Other Eastern Africa', '0')\n",
      "(687, 'Foreign-Born Population: Africa: Middle Africa', '0')\n",
      "(688, 'Foreign-Born Population: Africa: Northern Africa', '13')\n",
      "(689, 'Foreign-Born Population: Africa: Northern Africa: Egypt', '8')\n",
      "(690, 'Foreign-Born Population: Africa: Northern Africa: Other Northern Africa', '5')\n",
      "(691, 'Foreign-Born Population: Africa: Southern Africa', '0')\n",
      "(692, 'Foreign-Born Population: Africa: Southern Africa: South Africa', '0')\n",
      "(693, 'Foreign-Born Population: Africa: Southern Africa: Other Southern Africa', '0')\n",
      "(694, 'Foreign-Born Population: Africa: Western Africa', '12')\n",
      "(695, 'Foreign-Born Population: Africa: Western Africa: Ghana', '0')\n",
      "(696, 'Foreign-Born Population: Africa: Western Africa: Liberia', '0')\n",
      "(697, 'Foreign-Born Population: Africa: Western Africa: Nigeria', '12')\n",
      "(698, 'Foreign-Born Population: Africa: Western Africa: Other Western Africa', '0')\n",
      "(699, 'Foreign-Born Population: Africa: Africa, N.e.c.', '31')\n",
      "(700, 'Foreign-Born Population: Oceania', '8')\n",
      "(701, 'Foreign-Born Population: Oceania: Australia and New Zealand Subregion', '0')\n",
      "(702, 'Foreign-Born Population: Oceania: Australia and New Zealand Subregion: Australia', '0')\n",
      "(703, 'Foreign-Born Population: Oceania: Australia and New Zealand Subregion: Other Australian and New Zealand Subregion', '0')\n",
      "(704, 'Foreign-Born Population: Oceania: Oceania, N.e.c.', '8')\n",
      "(705, 'Foreign-Born Population: Americas', '944')\n",
      "(706, 'Foreign-Born Population: Americas: Latin America', '944')\n",
      "(707, 'Foreign-Born Population: Americas: Latin America: Caribbean', '586')\n",
      "(708, 'Foreign-Born Population: Americas: Latin America: Caribbean: Barbados', '7')\n",
      "(709, 'Foreign-Born Population: Americas: Latin America: Caribbean: Cuba', '0')\n",
      "(710, 'Foreign-Born Population: Americas: Latin America: Caribbean: Dominican Republic', '327')\n",
      "(711, 'Foreign-Born Population: Americas: Latin America: Caribbean: Haiti', '41')\n",
      "(712, 'Foreign-Born Population: Americas: Latin America: Caribbean: Jamaica', '124')\n",
      "(713, 'Foreign-Born Population: Americas: Latin America: Caribbean: Trinidad and Tobago', '77')\n",
      "(714, 'Foreign-Born Population: Americas: Latin America: Caribbean: Other Caribbean', '10')\n",
      "(715, 'Foreign-Born Population: Americas: Latin America: Central America', '211')\n",
      "(716, 'Foreign-Born Population: Americas: Latin America: Central America: Mexico', '118')\n",
      "(717, 'Foreign-Born Population: Americas: Latin America: Central America: Costa Rica', '0')\n",
      "(718, 'Foreign-Born Population: Americas: Latin America: Central America: El Salvador', '37')\n",
      "(719, 'Foreign-Born Population: Americas: Latin America: Central America: Guatemala', '23')\n",
      "(720, 'Foreign-Born Population: Americas: Latin America: Central America: Honduras', '33')\n",
      "(721, 'Foreign-Born Population: Americas: Latin America: Central America: Nicaragua', '0')\n",
      "(722, 'Foreign-Born Population: Americas: Latin America: Central America: Panama', '0')\n",
      "(723, 'Foreign-Born Population: Americas: Latin America: Central America: Other Central America', '0')\n",
      "(724, 'Foreign-Born Population: Americas: Latin America: South America', '147')\n",
      "(725, 'Foreign-Born Population: Americas: Latin America: South America: Argentina', '0')\n",
      "(726, 'Foreign-Born Population: Americas: Latin America: South America: Bolivia', '0')\n",
      "(727, 'Foreign-Born Population: Americas: Latin America: South America: Brazil', '0')\n",
      "(728, 'Foreign-Born Population: Americas: Latin America: South America: Chile', '0')\n",
      "(729, 'Foreign-Born Population: Americas: Latin America: South America: Colombia', '17')\n",
      "(730, 'Foreign-Born Population: Americas: Latin America: South America: Ecuador', '64')\n",
      "(731, 'Foreign-Born Population: Americas: Latin America: South America: Guyana', '58')\n",
      "(732, 'Foreign-Born Population: Americas: Latin America: South America: Peru', '8')\n",
      "(733, 'Foreign-Born Population: Americas: Latin America: South America: Uruguay', '0')\n",
      "(734, 'Foreign-Born Population: Americas: Latin America: South America: Venezuela', '0')\n",
      "(735, 'Foreign-Born Population: Americas: Latin America: South America: Other South America', '0')\n",
      "(736, 'Foreign-Born Population: Americas: Northern America', '0')\n",
      "(737, 'Foreign-Born Population: Americas: Northern America: Canada', '0')\n",
      "(738, 'Foreign-Born Population: Americas: Northern America: Other Northern America', '0')\n",
      "(739, 'Total:.2', '0')\n",
      "(740, 'Total: No Health Insurance Coverage', '0')\n",
      "(741, 'Total: with Health Insurance Coverage', '0')\n",
      "(742, 'Total: with Health Insurance Coverage: Public Health Coverage', '0')\n",
      "(743, 'Total: with Health Insurance Coverage: Private Health Insurance', '0')\n",
      "(744, 'Occupied Housing Units.1', '0')\n",
      "(745, 'Occupied Housing Units: Complete Plumbing Facilities', '0')\n",
      "(746, 'Occupied Housing Units: Complete Kitchen Facilities', '0')\n",
      "(747, 'Occupied Housing Units.2', '0')\n",
      "(748, 'Occupied Housing Units: with Telephone Service Available', '0')\n",
      "(749, 'Occupied Housing Units: with Telephone Service Available: Householder 15 to 34 Years', '0')\n",
      "(750, 'Occupied Housing Units: with Telephone Service Available: Householder 35 to 64 Years', '0')\n",
      "(751, 'Occupied Housing Units: with Telephone Service Available: Householder 65 Years and Over', '0')\n",
      "(752, 'Occupied Housing Units: No Telephone Service Available', '0')\n",
      "(753, 'Occupied Housing Units: No Telephone Service Available: Householder 15 to 34 Years', '0')\n",
      "(754, 'Occupied Housing Units: No Telephone Service Available: Householder 35 to 64 Years', '0')\n",
      "(755, 'Occupied Housing Units: No Telephone Service Available: Householder 65 Years and Over', '0')\n"
     ]
    }
   ],
   "source": [
    "# newcolumn = []\n",
    "for i in range(len(df.columns)): \n",
    "#     if len(key.intersection(set(df.columns[i].split(\" \")))) == 0 or \"Reporting\" in df.columns[i]:\n",
    "#         continue\n",
    "#     if \"Foreign-Born\" in df.columns[i]:\n",
    "    print(i,df.columns[i],df.loc[1,df.columns[i]])\n",
    "#     newcolumn.append(df.columns[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:23:35.709885Z",
     "start_time": "2018-04-28T21:23:35.701885Z"
    }
   },
   "outputs": [],
   "source": [
    "newcolumn = [0,17,59,193,77,144,64,91,93,94,101,107,110,112,120,124,125,126,129,130,131,132,134,136,138,139,140,\n",
    " 300,301,306,330,332,334,339,341,351,354,381,391,81,82,83,84,90]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:23:39.441393Z",
     "start_time": "2018-04-28T21:23:39.431041Z"
    }
   },
   "outputs": [],
   "source": [
    "ndf = df.iloc[:,newcolumn]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:23:46.565139Z",
     "start_time": "2018-04-28T21:23:46.488408Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>FIPS</th>\n",
       "      <th>Census Tract</th>\n",
       "      <th>Population Density (Per Sq. Mile)</th>\n",
       "      <th>Median Household Income (In 2016 Inflation Adjusted Dollars)</th>\n",
       "      <th>Median Age:</th>\n",
       "      <th>Average Household Size</th>\n",
       "      <th>Total Population:</th>\n",
       "      <th>Total Population: Hispanic or Latino: Mexican</th>\n",
       "      <th>Total Population: Hispanic or Latino: Cuban</th>\n",
       "      <th>Total Population: Hispanic or Latino: Dominican Republic</th>\n",
       "      <th>...</th>\n",
       "      <th>Total Population: Italian</th>\n",
       "      <th>Total Population: Polish</th>\n",
       "      <th>Total Population: Russian</th>\n",
       "      <th>Total Population: Turkish</th>\n",
       "      <th>Total Population: West Indian (Except Hispanic Groups): Haitian</th>\n",
       "      <th>Total Population: White Alone</th>\n",
       "      <th>Total Population: Black or African American Alone</th>\n",
       "      <th>Total Population: American Indian and Alaska Native Alone</th>\n",
       "      <th>Total Population: Asian Alone</th>\n",
       "      <th>Total Population: Hispanic or Latino</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36005000100</td>\n",
       "      <td>000100</td>\n",
       "      <td>11586.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7503</td>\n",
       "      <td>140</td>\n",
       "      <td>21</td>\n",
       "      <td>381</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>34</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>933</td>\n",
       "      <td>4697</td>\n",
       "      <td>14</td>\n",
       "      <td>135</td>\n",
       "      <td>2240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36005000200</td>\n",
       "      <td>000200</td>\n",
       "      <td>28365.12</td>\n",
       "      <td>70893</td>\n",
       "      <td>38.6</td>\n",
       "      <td>3.94</td>\n",
       "      <td>5251</td>\n",
       "      <td>203</td>\n",
       "      <td>10</td>\n",
       "      <td>673</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2282</td>\n",
       "      <td>1302</td>\n",
       "      <td>0</td>\n",
       "      <td>147</td>\n",
       "      <td>3936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>36005000400</td>\n",
       "      <td>000400</td>\n",
       "      <td>20096.47</td>\n",
       "      <td>76667</td>\n",
       "      <td>39.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>5980</td>\n",
       "      <td>100</td>\n",
       "      <td>91</td>\n",
       "      <td>792</td>\n",
       "      <td>...</td>\n",
       "      <td>152</td>\n",
       "      <td>21</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2593</td>\n",
       "      <td>2019</td>\n",
       "      <td>19</td>\n",
       "      <td>57</td>\n",
       "      <td>3868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36005001600</td>\n",
       "      <td>001600</td>\n",
       "      <td>32334.87</td>\n",
       "      <td>31540</td>\n",
       "      <td>36.9</td>\n",
       "      <td>2.94</td>\n",
       "      <td>6056</td>\n",
       "      <td>35</td>\n",
       "      <td>89</td>\n",
       "      <td>1812</td>\n",
       "      <td>...</td>\n",
       "      <td>45</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>2623</td>\n",
       "      <td>2185</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>36005001900</td>\n",
       "      <td>001900</td>\n",
       "      <td>4164.445</td>\n",
       "      <td>39130</td>\n",
       "      <td>32.5</td>\n",
       "      <td>2.27</td>\n",
       "      <td>2682</td>\n",
       "      <td>129</td>\n",
       "      <td>0</td>\n",
       "      <td>456</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>22</td>\n",
       "      <td>452</td>\n",
       "      <td>994</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>1449</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          FIPS Census Tract Population Density (Per Sq. Mile)  \\\n",
       "1  36005000100       000100                          11586.31   \n",
       "2  36005000200       000200                          28365.12   \n",
       "3  36005000400       000400                          20096.47   \n",
       "4  36005001600       001600                          32334.87   \n",
       "5  36005001900       001900                          4164.445   \n",
       "\n",
       "  Median Household Income (In 2016 Inflation Adjusted Dollars) Median Age:  \\\n",
       "1                                                NaN                  32.1   \n",
       "2                                              70893                  38.6   \n",
       "3                                              76667                  39.4   \n",
       "4                                              31540                  36.9   \n",
       "5                                              39130                  32.5   \n",
       "\n",
       "  Average Household Size Total Population:  \\\n",
       "1                    NaN              7503   \n",
       "2                   3.94              5251   \n",
       "3                    3.1              5980   \n",
       "4                   2.94              6056   \n",
       "5                   2.27              2682   \n",
       "\n",
       "  Total Population: Hispanic or Latino: Mexican  \\\n",
       "1                                           140   \n",
       "2                                           203   \n",
       "3                                           100   \n",
       "4                                            35   \n",
       "5                                           129   \n",
       "\n",
       "  Total Population: Hispanic or Latino: Cuban  \\\n",
       "1                                          21   \n",
       "2                                          10   \n",
       "3                                          91   \n",
       "4                                          89   \n",
       "5                                           0   \n",
       "\n",
       "  Total Population: Hispanic or Latino: Dominican Republic  \\\n",
       "1                                                381         \n",
       "2                                                673         \n",
       "3                                                792         \n",
       "4                                               1812         \n",
       "5                                                456         \n",
       "\n",
       "                  ...                  Total Population: Italian  \\\n",
       "1                 ...                                         31   \n",
       "2                 ...                                          0   \n",
       "3                 ...                                        152   \n",
       "4                 ...                                         45   \n",
       "5                 ...                                         61   \n",
       "\n",
       "  Total Population: Polish Total Population: Russian  \\\n",
       "1                       34                        33   \n",
       "2                       36                         0   \n",
       "3                       21                         9   \n",
       "4                        8                         7   \n",
       "5                        8                         7   \n",
       "\n",
       "  Total Population: Turkish  \\\n",
       "1                         0   \n",
       "2                         0   \n",
       "3                         0   \n",
       "4                         0   \n",
       "5                         3   \n",
       "\n",
       "  Total Population: West Indian (Except Hispanic Groups): Haitian  \\\n",
       "1                                                 46                \n",
       "2                                                  0                \n",
       "3                                                  0                \n",
       "4                                                 32                \n",
       "5                                                 22                \n",
       "\n",
       "  Total Population: White Alone  \\\n",
       "1                           933   \n",
       "2                          2282   \n",
       "3                          2593   \n",
       "4                          2623   \n",
       "5                           452   \n",
       "\n",
       "  Total Population: Black or African American Alone  \\\n",
       "1                                              4697   \n",
       "2                                              1302   \n",
       "3                                              2019   \n",
       "4                                              2185   \n",
       "5                                               994   \n",
       "\n",
       "  Total Population: American Indian and Alaska Native Alone  \\\n",
       "1                                                 14          \n",
       "2                                                  0          \n",
       "3                                                 19          \n",
       "4                                                  0          \n",
       "5                                                  0          \n",
       "\n",
       "  Total Population: Asian Alone Total Population: Hispanic or Latino  \n",
       "1                           135                                 2240  \n",
       "2                           147                                 3936  \n",
       "3                            57                                 3868  \n",
       "4                             0                                 4041  \n",
       "5                            50                                 1449  \n",
       "\n",
       "[5 rows x 44 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ndf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:29:14.891646Z",
     "start_time": "2018-04-28T21:29:14.883261Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "44"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(ndf.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:30:18.435686Z",
     "start_time": "2018-04-28T21:30:18.427649Z"
    }
   },
   "outputs": [],
   "source": [
    "ndf.columns = ['FIPS','Census Tract','Pop Density','Income','Age','Household Size',\n",
    "               'Total Pop','Mexican','Cuban','Dominican','Salvadoran','Colombian','Peruvian',\n",
    "               'Venezuelan','Indian','Cambodian','Chinese','Filipino','Japanese','Korean',\n",
    "               'Laotian','Malaysian','Nepalese','Pakistani','Taiwanese','Thai','Vietnamese',\n",
    "               'Lebanese','Moroccan','Armenian','French','German','Greek','Irish','Italian',\n",
    "               'Polish','Russian','Turkish','Haitian',\n",
    "               'White','Black or African American',\n",
    "               'American Indian and Alaska Native','Asian','Hispanic or Latino'] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:30:22.340902Z",
     "start_time": "2018-04-28T21:30:22.301573Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>FIPS</th>\n",
       "      <th>Census Tract</th>\n",
       "      <th>Pop Density</th>\n",
       "      <th>Income</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Size</th>\n",
       "      <th>Total Pop</th>\n",
       "      <th>Mexican</th>\n",
       "      <th>Cuban</th>\n",
       "      <th>Dominican</th>\n",
       "      <th>...</th>\n",
       "      <th>Italian</th>\n",
       "      <th>Polish</th>\n",
       "      <th>Russian</th>\n",
       "      <th>Turkish</th>\n",
       "      <th>Haitian</th>\n",
       "      <th>White</th>\n",
       "      <th>Black or African American</th>\n",
       "      <th>American Indian and Alaska Native</th>\n",
       "      <th>Asian</th>\n",
       "      <th>Hispanic or Latino</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36005000100</td>\n",
       "      <td>000100</td>\n",
       "      <td>11586.31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7503</td>\n",
       "      <td>140</td>\n",
       "      <td>21</td>\n",
       "      <td>381</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>34</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>933</td>\n",
       "      <td>4697</td>\n",
       "      <td>14</td>\n",
       "      <td>135</td>\n",
       "      <td>2240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36005000200</td>\n",
       "      <td>000200</td>\n",
       "      <td>28365.12</td>\n",
       "      <td>70893</td>\n",
       "      <td>38.6</td>\n",
       "      <td>3.94</td>\n",
       "      <td>5251</td>\n",
       "      <td>203</td>\n",
       "      <td>10</td>\n",
       "      <td>673</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2282</td>\n",
       "      <td>1302</td>\n",
       "      <td>0</td>\n",
       "      <td>147</td>\n",
       "      <td>3936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>36005000400</td>\n",
       "      <td>000400</td>\n",
       "      <td>20096.47</td>\n",
       "      <td>76667</td>\n",
       "      <td>39.4</td>\n",
       "      <td>3.1</td>\n",
       "      <td>5980</td>\n",
       "      <td>100</td>\n",
       "      <td>91</td>\n",
       "      <td>792</td>\n",
       "      <td>...</td>\n",
       "      <td>152</td>\n",
       "      <td>21</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2593</td>\n",
       "      <td>2019</td>\n",
       "      <td>19</td>\n",
       "      <td>57</td>\n",
       "      <td>3868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36005001600</td>\n",
       "      <td>001600</td>\n",
       "      <td>32334.87</td>\n",
       "      <td>31540</td>\n",
       "      <td>36.9</td>\n",
       "      <td>2.94</td>\n",
       "      <td>6056</td>\n",
       "      <td>35</td>\n",
       "      <td>89</td>\n",
       "      <td>1812</td>\n",
       "      <td>...</td>\n",
       "      <td>45</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>2623</td>\n",
       "      <td>2185</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>36005001900</td>\n",
       "      <td>001900</td>\n",
       "      <td>4164.445</td>\n",
       "      <td>39130</td>\n",
       "      <td>32.5</td>\n",
       "      <td>2.27</td>\n",
       "      <td>2682</td>\n",
       "      <td>129</td>\n",
       "      <td>0</td>\n",
       "      <td>456</td>\n",
       "      <td>...</td>\n",
       "      <td>61</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>22</td>\n",
       "      <td>452</td>\n",
       "      <td>994</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>1449</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          FIPS Census Tract Pop Density Income   Age Household Size Total Pop  \\\n",
       "1  36005000100       000100    11586.31    NaN  32.1            NaN      7503   \n",
       "2  36005000200       000200    28365.12  70893  38.6           3.94      5251   \n",
       "3  36005000400       000400    20096.47  76667  39.4            3.1      5980   \n",
       "4  36005001600       001600    32334.87  31540  36.9           2.94      6056   \n",
       "5  36005001900       001900    4164.445  39130  32.5           2.27      2682   \n",
       "\n",
       "  Mexican Cuban Dominican        ...         Italian Polish Russian Turkish  \\\n",
       "1     140    21       381        ...              31     34      33       0   \n",
       "2     203    10       673        ...               0     36       0       0   \n",
       "3     100    91       792        ...             152     21       9       0   \n",
       "4      35    89      1812        ...              45      8       7       0   \n",
       "5     129     0       456        ...              61      8       7       3   \n",
       "\n",
       "  Haitian White Black or African American American Indian and Alaska Native  \\\n",
       "1      46   933                      4697                                14   \n",
       "2       0  2282                      1302                                 0   \n",
       "3       0  2593                      2019                                19   \n",
       "4      32  2623                      2185                                 0   \n",
       "5      22   452                       994                                 0   \n",
       "\n",
       "  Asian Hispanic or Latino  \n",
       "1   135               2240  \n",
       "2   147               3936  \n",
       "3    57               3868  \n",
       "4     0               4041  \n",
       "5    50               1449  \n",
       "\n",
       "[5 rows x 44 columns]"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ndf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:30:38.570637Z",
     "start_time": "2018-04-28T21:30:38.565147Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2167"
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(ndf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:31:23.285874Z",
     "start_time": "2018-04-28T21:31:21.259102Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python2.7/site-packages/pandas/core/indexing.py:561: 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: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  self.obj[item_labels[indexer[info_axis]]] = value\n"
     ]
    }
   ],
   "source": [
    "for i in ndf.columns[2:]:\n",
    "    ndf.loc[:,i] = pd.to_numeric(ndf.loc[:,i],errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:31:31.690722Z",
     "start_time": "2018-04-28T21:31:31.655158Z"
    }
   },
   "outputs": [],
   "source": [
    "ndf.to_csv('selectedcol.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:32:44.399848Z",
     "start_time": "2018-04-28T21:32:43.013910Z"
    }
   },
   "outputs": [],
   "source": [
    "for i in ndf.columns[7:]:\n",
    "    ndf.loc[:,i] = ndf.loc[:,i] / ndf.loc[:,'Total Pop'] * 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:32:47.650989Z",
     "start_time": "2018-04-28T21:32:47.603730Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>FIPS</th>\n",
       "      <th>Census Tract</th>\n",
       "      <th>Pop Density</th>\n",
       "      <th>Income</th>\n",
       "      <th>Age</th>\n",
       "      <th>Household Size</th>\n",
       "      <th>Total Pop</th>\n",
       "      <th>Mexican</th>\n",
       "      <th>Cuban</th>\n",
       "      <th>Dominican</th>\n",
       "      <th>...</th>\n",
       "      <th>Italian</th>\n",
       "      <th>Polish</th>\n",
       "      <th>Russian</th>\n",
       "      <th>Turkish</th>\n",
       "      <th>Haitian</th>\n",
       "      <th>White</th>\n",
       "      <th>Black or African American</th>\n",
       "      <th>American Indian and Alaska Native</th>\n",
       "      <th>Asian</th>\n",
       "      <th>Hispanic or Latino</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36005000100</td>\n",
       "      <td>000100</td>\n",
       "      <td>11586.310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7503</td>\n",
       "      <td>1.865920</td>\n",
       "      <td>0.279888</td>\n",
       "      <td>5.077969</td>\n",
       "      <td>...</td>\n",
       "      <td>0.413168</td>\n",
       "      <td>0.453152</td>\n",
       "      <td>0.439824</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.613088</td>\n",
       "      <td>12.435026</td>\n",
       "      <td>62.601626</td>\n",
       "      <td>0.186592</td>\n",
       "      <td>1.799280</td>\n",
       "      <td>29.854725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>36005000200</td>\n",
       "      <td>000200</td>\n",
       "      <td>28365.120</td>\n",
       "      <td>70893.0</td>\n",
       "      <td>38.6</td>\n",
       "      <td>3.94</td>\n",
       "      <td>5251</td>\n",
       "      <td>3.865930</td>\n",
       "      <td>0.190440</td>\n",
       "      <td>12.816606</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.685584</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>43.458389</td>\n",
       "      <td>24.795277</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.799467</td>\n",
       "      <td>74.957151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>36005000400</td>\n",
       "      <td>000400</td>\n",
       "      <td>20096.470</td>\n",
       "      <td>76667.0</td>\n",
       "      <td>39.4</td>\n",
       "      <td>3.10</td>\n",
       "      <td>5980</td>\n",
       "      <td>1.672241</td>\n",
       "      <td>1.521739</td>\n",
       "      <td>13.244147</td>\n",
       "      <td>...</td>\n",
       "      <td>2.541806</td>\n",
       "      <td>0.351171</td>\n",
       "      <td>0.150502</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>43.361204</td>\n",
       "      <td>33.762542</td>\n",
       "      <td>0.317726</td>\n",
       "      <td>0.953177</td>\n",
       "      <td>64.682274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36005001600</td>\n",
       "      <td>001600</td>\n",
       "      <td>32334.870</td>\n",
       "      <td>31540.0</td>\n",
       "      <td>36.9</td>\n",
       "      <td>2.94</td>\n",
       "      <td>6056</td>\n",
       "      <td>0.577939</td>\n",
       "      <td>1.469617</td>\n",
       "      <td>29.920740</td>\n",
       "      <td>...</td>\n",
       "      <td>0.743065</td>\n",
       "      <td>0.132100</td>\n",
       "      <td>0.115588</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.528402</td>\n",
       "      <td>43.312417</td>\n",
       "      <td>36.079921</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>66.727213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>36005001900</td>\n",
       "      <td>001900</td>\n",
       "      <td>4164.445</td>\n",
       "      <td>39130.0</td>\n",
       "      <td>32.5</td>\n",
       "      <td>2.27</td>\n",
       "      <td>2682</td>\n",
       "      <td>4.809843</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>17.002237</td>\n",
       "      <td>...</td>\n",
       "      <td>2.274422</td>\n",
       "      <td>0.298285</td>\n",
       "      <td>0.260999</td>\n",
       "      <td>0.111857</td>\n",
       "      <td>0.820283</td>\n",
       "      <td>16.853095</td>\n",
       "      <td>37.061894</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.864280</td>\n",
       "      <td>54.026846</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          FIPS Census Tract  Pop Density   Income   Age  Household Size  \\\n",
       "1  36005000100       000100    11586.310      NaN  32.1             NaN   \n",
       "2  36005000200       000200    28365.120  70893.0  38.6            3.94   \n",
       "3  36005000400       000400    20096.470  76667.0  39.4            3.10   \n",
       "4  36005001600       001600    32334.870  31540.0  36.9            2.94   \n",
       "5  36005001900       001900     4164.445  39130.0  32.5            2.27   \n",
       "\n",
       "   Total Pop   Mexican     Cuban  Dominican         ...           Italian  \\\n",
       "1       7503  1.865920  0.279888   5.077969         ...          0.413168   \n",
       "2       5251  3.865930  0.190440  12.816606         ...          0.000000   \n",
       "3       5980  1.672241  1.521739  13.244147         ...          2.541806   \n",
       "4       6056  0.577939  1.469617  29.920740         ...          0.743065   \n",
       "5       2682  4.809843  0.000000  17.002237         ...          2.274422   \n",
       "\n",
       "     Polish   Russian   Turkish   Haitian      White  \\\n",
       "1  0.453152  0.439824  0.000000  0.613088  12.435026   \n",
       "2  0.685584  0.000000  0.000000  0.000000  43.458389   \n",
       "3  0.351171  0.150502  0.000000  0.000000  43.361204   \n",
       "4  0.132100  0.115588  0.000000  0.528402  43.312417   \n",
       "5  0.298285  0.260999  0.111857  0.820283  16.853095   \n",
       "\n",
       "   Black or African American  American Indian and Alaska Native     Asian  \\\n",
       "1                  62.601626                           0.186592  1.799280   \n",
       "2                  24.795277                           0.000000  2.799467   \n",
       "3                  33.762542                           0.317726  0.953177   \n",
       "4                  36.079921                           0.000000  0.000000   \n",
       "5                  37.061894                           0.000000  1.864280   \n",
       "\n",
       "   Hispanic or Latino  \n",
       "1           29.854725  \n",
       "2           74.957151  \n",
       "3           64.682274  \n",
       "4           66.727213  \n",
       "5           54.026846  \n",
       "\n",
       "[5 rows x 44 columns]"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ndf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-04-28T21:35:25.314152Z",
     "start_time": "2018-04-28T21:35:25.251256Z"
    }
   },
   "outputs": [],
   "source": [
    "ndf.to_csv('ACSselectedData.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}