9_more_cleaning_answer.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Real Data Cleaning\n",
    "* I need to learn about US presidents! Let's hit wikipedia..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Presidency[a]</th>\n",
       "      <th>Presidency[a].1</th>\n",
       "      <th>President</th>\n",
       "      <th>President.1</th>\n",
       "      <th>Party[b]</th>\n",
       "      <th>Party[b].1</th>\n",
       "      <th>Election</th>\n",
       "      <th>Vice President</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[c]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[c]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>March 4, 1797–March 4, 1801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[d]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron Burr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Presidency[a]               Presidency[a].1 President        President.1  \\\n",
       "0             1  April 30, 1789–March 4, 1797       NaN  George Washington   \n",
       "1             1  April 30, 1789–March 4, 1797       NaN  George Washington   \n",
       "2             2   March 4, 1797–March 4, 1801       NaN         John Adams   \n",
       "3             3   March 4, 1801–March 4, 1809       NaN   Thomas Jefferson   \n",
       "4             3   March 4, 1801–March 4, 1809       NaN   Thomas Jefferson   \n",
       "\n",
       "  Party[b]             Party[b].1 Election       Vice President  \n",
       "0      NaN           Unaffiliated  1788–89        John Adams[c]  \n",
       "1      NaN           Unaffiliated     1792        John Adams[c]  \n",
       "2      NaN             Federalist     1796  Thomas Jefferson[d]  \n",
       "3      NaN  Democratic-Republican     1800           Aaron Burr  \n",
       "4      NaN  Democratic-Republican     1804    George Clinton[e]  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df=pd.read_html(\"https://en.wikipedia.org/wiki/List_of_presidents_of_the_United_States\")[1]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* Let's try and build a dataframe that has the president number, start and end date of term, name and birth/death years. I think there are likely questions like this on the citizenship test."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "Cannot remove 1 levels from an index with 1 levels: at least one level must be left.",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-2-94075d53946b>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdroplevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/opt/conda/lib/python3.7/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mdroplevel\u001b[0;34m(self, level)\u001b[0m\n\u001b[1;32m   1648\u001b[0m                 \u001b[0;34m\"Cannot remove {} levels from an index with {} \"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1649\u001b[0m                 \u001b[0;34m\"levels: at least one level must be \"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1650\u001b[0;31m                 \u001b[0;34m\"left.\"\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnlevels\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1651\u001b[0m             )\n\u001b[1;32m   1652\u001b[0m         \u001b[0;31m# The two checks above guarantee that here self is a MultiIndex\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: Cannot remove 1 levels from an index with 1 levels: at least one level must be left."
     ]
    }
   ],
   "source": [
    "df.columns=df.columns.droplevel(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Presidency[a]', 'Presidency[a].1', 'President', 'President.1',\n",
       "       'Party[b]', 'Party[b].1', 'Election', 'Vice President'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#val=\"April 30, 1789[d]–March 4, 1797\"\n",
    "\n",
    "def get_start(val):\n",
    "    start=val.split(\"–\")[0]\n",
    "    return start\n",
    "\n",
    "#get_start(val)\n",
    "df[\"pres_start\"]=df[\"Presidency[a].1\"].apply(get_start)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         April 30, 1789\n",
       "1         April 30, 1789\n",
       "2          March 4, 1797\n",
       "3          March 4, 1801\n",
       "4          March 4, 1801\n",
       "             ...        \n",
       "77      January 20, 2001\n",
       "78      January 20, 2009\n",
       "79      January 20, 2009\n",
       "80      January 20, 2017\n",
       "81    Sources: [3][4][5]\n",
       "Length: 82, dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_start_by_row0(row):\n",
    "    return row[\"Presidency[a].1\"].split(\"–\")[0]\n",
    "df.apply(get_start_by_row0, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Presidency[a]</th>\n",
       "      <th>Presidency[a].1</th>\n",
       "      <th>President</th>\n",
       "      <th>President.1</th>\n",
       "      <th>Party[b]</th>\n",
       "      <th>Party[b].1</th>\n",
       "      <th>Election</th>\n",
       "      <th>Vice President</th>\n",
       "      <th>pres_start</th>\n",
       "      <th>presy_start</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "      <td>April 30, 1789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "      <td>April 30, 1789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>March 4, 1797–March 4, 1801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[d]</td>\n",
       "      <td>March 4, 1797</td>\n",
       "      <td>March 4, 1797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron Burr</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>March 4, 1801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>March 4, 1801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>March 4, 1809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>Vacant afterApr. 20, 1812</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>March 4, 1809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Elbridge Gerry[e]</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>March 4, 1809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Vacant afterNov. 23, 1814</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>March 4, 1809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5</td>\n",
       "      <td>March 4, 1817–March 4, 1825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1816</td>\n",
       "      <td>Daniel D. Tompkins</td>\n",
       "      <td>March 4, 1817</td>\n",
       "      <td>March 4, 1817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5</td>\n",
       "      <td>March 4, 1817–March 4, 1825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1820</td>\n",
       "      <td>Daniel D. Tompkins</td>\n",
       "      <td>March 4, 1817</td>\n",
       "      <td>March 4, 1817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>6</td>\n",
       "      <td>March 4, 1825–March 4, 1829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican[f]</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>March 4, 1825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6</td>\n",
       "      <td>March 4, 1825–March 4, 1829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Republican</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>March 4, 1825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>March 4, 1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>Vacant afterDec. 28, 1832</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>March 4, 1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1832</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>March 4, 1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8</td>\n",
       "      <td>March 4, 1837–March 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1836</td>\n",
       "      <td>Richard Mentor Johnson</td>\n",
       "      <td>March 4, 1837</td>\n",
       "      <td>March 4, 1837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9</td>\n",
       "      <td>March 4, 1841–April 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Henry Harrison[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1840</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>March 4, 1841</td>\n",
       "      <td>March 4, 1841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig[j]</td>\n",
       "      <td>1840</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1840</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11</td>\n",
       "      <td>March 4, 1845–March 4, 1849</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James K. Polk</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1844</td>\n",
       "      <td>George M. Dallas</td>\n",
       "      <td>March 4, 1845</td>\n",
       "      <td>March 4, 1845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>12</td>\n",
       "      <td>March 4, 1849–July 9, 1850</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zachary Taylor[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>March 4, 1849</td>\n",
       "      <td>March 4, 1849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>13</td>\n",
       "      <td>July 9, 1850[k]–March 4, 1853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>July 9, 1850[k]</td>\n",
       "      <td>July 9, 1850[k]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>William R. King[e]</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>March 4, 1853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>Vacant afterApr. 18, 1853</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>March 4, 1853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>15</td>\n",
       "      <td>March 4, 1857–March 4, 1861</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Buchanan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1856</td>\n",
       "      <td>John C. Breckinridge</td>\n",
       "      <td>March 4, 1857</td>\n",
       "      <td>March 4, 1857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1860</td>\n",
       "      <td>Hannibal Hamlin</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>March 4, 1861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Union[m]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>March 4, 1861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Union[n]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>April 15, 1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1864</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>April 15, 1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>31</td>\n",
       "      <td>March 4, 1929–March 4, 1933</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Herbert Hoover</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1928</td>\n",
       "      <td>Charles Curtis</td>\n",
       "      <td>March 4, 1929</td>\n",
       "      <td>March 4, 1929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1932</td>\n",
       "      <td>John Nance Garner</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>March 4, 1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1936</td>\n",
       "      <td>John Nance Garner</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>March 4, 1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1940</td>\n",
       "      <td>Henry A. Wallace</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>March 4, 1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>March 4, 1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Vacant throughJan. 20, 1949</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>April 12, 1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1948</td>\n",
       "      <td>Alben W. Barkley</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>April 12, 1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1952</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>January 20, 1953</td>\n",
       "      <td>January 20, 1953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1956</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>January 20, 1953</td>\n",
       "      <td>January 20, 1953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>35</td>\n",
       "      <td>January 20, 1961–November 22, 1963</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John F. Kennedy[s]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>January 20, 1961</td>\n",
       "      <td>January 20, 1961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Vacant throughJan. 20, 1965</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>November 22, 1963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1964</td>\n",
       "      <td>Hubert Humphrey</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>November 22, 1963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1968</td>\n",
       "      <td>Spiro Agnew[h]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>January 20, 1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Spiro Agnew[h]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>January 20, 1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Vacant, Oct. 10 – Dec. 6, 1973</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>January 20, 1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Gerald Ford[t]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>January 20, 1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Vacant throughDec. 19, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Nelson Rockefeller[t]</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>39</td>\n",
       "      <td>January 20, 1977–January 20, 1981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jimmy Carter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1976</td>\n",
       "      <td>Walter Mondale</td>\n",
       "      <td>January 20, 1977</td>\n",
       "      <td>January 20, 1977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1980</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>January 20, 1981</td>\n",
       "      <td>January 20, 1981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1984</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>January 20, 1981</td>\n",
       "      <td>January 20, 1981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>41</td>\n",
       "      <td>January 20, 1989–January 20, 1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1988</td>\n",
       "      <td>Dan Quayle</td>\n",
       "      <td>January 20, 1989</td>\n",
       "      <td>January 20, 1989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1992</td>\n",
       "      <td>Al Gore</td>\n",
       "      <td>January 20, 1993</td>\n",
       "      <td>January 20, 1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1996</td>\n",
       "      <td>Al Gore</td>\n",
       "      <td>January 20, 1993</td>\n",
       "      <td>January 20, 1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2000</td>\n",
       "      <td>Dick Cheney</td>\n",
       "      <td>January 20, 2001</td>\n",
       "      <td>January 20, 2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2004</td>\n",
       "      <td>Dick Cheney</td>\n",
       "      <td>January 20, 2001</td>\n",
       "      <td>January 20, 2001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2008</td>\n",
       "      <td>Joe Biden</td>\n",
       "      <td>January 20, 2009</td>\n",
       "      <td>January 20, 2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2012</td>\n",
       "      <td>Joe Biden</td>\n",
       "      <td>January 20, 2009</td>\n",
       "      <td>January 20, 2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>45</td>\n",
       "      <td>January 20, 2017–Incumbent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Donald Trump</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2016</td>\n",
       "      <td>Mike Pence</td>\n",
       "      <td>January 20, 2017</td>\n",
       "      <td>January 20, 2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>82 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Presidency[a]                    Presidency[a].1           President  \\\n",
       "0                    1       April 30, 1789–March 4, 1797                 NaN   \n",
       "1                    1       April 30, 1789–March 4, 1797                 NaN   \n",
       "2                    2        March 4, 1797–March 4, 1801                 NaN   \n",
       "3                    3        March 4, 1801–March 4, 1809                 NaN   \n",
       "4                    3        March 4, 1801–March 4, 1809                 NaN   \n",
       "..                 ...                                ...                 ...   \n",
       "77                  43  January 20, 2001–January 20, 2009                 NaN   \n",
       "78                  44  January 20, 2009–January 20, 2017                 NaN   \n",
       "79                  44  January 20, 2009–January 20, 2017                 NaN   \n",
       "80                  45         January 20, 2017–Incumbent                 NaN   \n",
       "81  Sources: [3][4][5]                 Sources: [3][4][5]  Sources: [3][4][5]   \n",
       "\n",
       "           President.1            Party[b]             Party[b].1  \\\n",
       "0    George Washington                 NaN           Unaffiliated   \n",
       "1    George Washington                 NaN           Unaffiliated   \n",
       "2           John Adams                 NaN             Federalist   \n",
       "3     Thomas Jefferson                 NaN  Democratic-Republican   \n",
       "4     Thomas Jefferson                 NaN  Democratic-Republican   \n",
       "..                 ...                 ...                    ...   \n",
       "77      George W. Bush                 NaN             Republican   \n",
       "78        Barack Obama                 NaN             Democratic   \n",
       "79        Barack Obama                 NaN             Democratic   \n",
       "80        Donald Trump                 NaN             Republican   \n",
       "81  Sources: [3][4][5]  Sources: [3][4][5]     Sources: [3][4][5]   \n",
       "\n",
       "              Election       Vice President          pres_start  \\\n",
       "0              1788–89        John Adams[c]      April 30, 1789   \n",
       "1                 1792        John Adams[c]      April 30, 1789   \n",
       "2                 1796  Thomas Jefferson[d]       March 4, 1797   \n",
       "3                 1800           Aaron Burr       March 4, 1801   \n",
       "4                 1804    George Clinton[e]       March 4, 1801   \n",
       "..                 ...                  ...                 ...   \n",
       "77                2004          Dick Cheney    January 20, 2001   \n",
       "78                2008            Joe Biden    January 20, 2009   \n",
       "79                2012            Joe Biden    January 20, 2009   \n",
       "80                2016           Mike Pence    January 20, 2017   \n",
       "81  Sources: [3][4][5]   Sources: [3][4][5]  Sources: [3][4][5]   \n",
       "\n",
       "           presy_start  \n",
       "0       April 30, 1789  \n",
       "1       April 30, 1789  \n",
       "2        March 4, 1797  \n",
       "3        March 4, 1801  \n",
       "4        March 4, 1801  \n",
       "..                 ...  \n",
       "77    January 20, 2001  \n",
       "78    January 20, 2009  \n",
       "79    January 20, 2009  \n",
       "80    January 20, 2017  \n",
       "81  Sources: [3][4][5]  \n",
       "\n",
       "[82 rows x 10 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_start_by_row(row):\n",
    "    row[\"presy_start\"]=row[\"Presidency[a].1\"].split(\"–\")[0]\n",
    "    return row\n",
    "new_df=df.apply(get_start_by_row, axis=1)\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Presidency[a]</th>\n",
       "      <th>Presidency[a].1</th>\n",
       "      <th>President</th>\n",
       "      <th>President.1</th>\n",
       "      <th>Party[b]</th>\n",
       "      <th>Party[b].1</th>\n",
       "      <th>Election</th>\n",
       "      <th>Vice President</th>\n",
       "      <th>pres_start</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>March 4, 1797–March 4, 1801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[d]</td>\n",
       "      <td>March 4, 1797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron Burr</td>\n",
       "      <td>March 4, 1801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "      <td>March 4, 1801</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Presidency[a]               Presidency[a].1 President        President.1  \\\n",
       "0             1  April 30, 1789–March 4, 1797       NaN  George Washington   \n",
       "1             1  April 30, 1789–March 4, 1797       NaN  George Washington   \n",
       "2             2   March 4, 1797–March 4, 1801       NaN         John Adams   \n",
       "3             3   March 4, 1801–March 4, 1809       NaN   Thomas Jefferson   \n",
       "4             3   March 4, 1801–March 4, 1809       NaN   Thomas Jefferson   \n",
       "\n",
       "  Party[b]             Party[b].1 Election       Vice President  \\\n",
       "0      NaN           Unaffiliated  1788–89        John Adams[c]   \n",
       "1      NaN           Unaffiliated     1792        John Adams[c]   \n",
       "2      NaN             Federalist     1796  Thomas Jefferson[d]   \n",
       "3      NaN  Democratic-Republican     1800           Aaron Burr   \n",
       "4      NaN  Democratic-Republican     1804    George Clinton[e]   \n",
       "\n",
       "       pres_start  \n",
       "0  April 30, 1789  \n",
       "1  April 30, 1789  \n",
       "2   March 4, 1797  \n",
       "3   March 4, 1801  \n",
       "4   March 4, 1801  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['pres_name']=df[\"President.1\"].str.replace(r'\\d+.*','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'George Washington'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"President.1\"].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Presidency[a]</th>\n",
       "      <th>Presidency[a].1</th>\n",
       "      <th>President</th>\n",
       "      <th>President.1</th>\n",
       "      <th>Party[b]</th>\n",
       "      <th>Party[b].1</th>\n",
       "      <th>Election</th>\n",
       "      <th>Vice President</th>\n",
       "      <th>pres_start</th>\n",
       "      <th>pres_name</th>\n",
       "      <th>birth</th>\n",
       "      <th>death</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>March 4, 1797–March 4, 1801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[d]</td>\n",
       "      <td>March 4, 1797</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron Burr</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>Vacant afterApr. 20, 1812</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Elbridge Gerry[e]</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Vacant afterNov. 23, 1814</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5</td>\n",
       "      <td>March 4, 1817–March 4, 1825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1816</td>\n",
       "      <td>Daniel D. Tompkins</td>\n",
       "      <td>March 4, 1817</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5</td>\n",
       "      <td>March 4, 1817–March 4, 1825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1820</td>\n",
       "      <td>Daniel D. Tompkins</td>\n",
       "      <td>March 4, 1817</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>6</td>\n",
       "      <td>March 4, 1825–March 4, 1829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican[f]</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6</td>\n",
       "      <td>March 4, 1825–March 4, 1829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Republican</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>Vacant afterDec. 28, 1832</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1832</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8</td>\n",
       "      <td>March 4, 1837–March 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1836</td>\n",
       "      <td>Richard Mentor Johnson</td>\n",
       "      <td>March 4, 1837</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9</td>\n",
       "      <td>March 4, 1841–April 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Henry Harrison[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1840</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>March 4, 1841</td>\n",
       "      <td>William Henry Harrison[e]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig[j]</td>\n",
       "      <td>1840</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1840</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11</td>\n",
       "      <td>March 4, 1845–March 4, 1849</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James K. Polk</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1844</td>\n",
       "      <td>George M. Dallas</td>\n",
       "      <td>March 4, 1845</td>\n",
       "      <td>James K. Polk</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>12</td>\n",
       "      <td>March 4, 1849–July 9, 1850</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zachary Taylor[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>March 4, 1849</td>\n",
       "      <td>Zachary Taylor[e]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>13</td>\n",
       "      <td>July 9, 1850[k]–March 4, 1853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>July 9, 1850[k]</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>William R. King[e]</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>Vacant afterApr. 18, 1853</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>15</td>\n",
       "      <td>March 4, 1857–March 4, 1861</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Buchanan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1856</td>\n",
       "      <td>John C. Breckinridge</td>\n",
       "      <td>March 4, 1857</td>\n",
       "      <td>James Buchanan</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1860</td>\n",
       "      <td>Hannibal Hamlin</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Union[m]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Union[n]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1864</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>31</td>\n",
       "      <td>March 4, 1929–March 4, 1933</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Herbert Hoover</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1928</td>\n",
       "      <td>Charles Curtis</td>\n",
       "      <td>March 4, 1929</td>\n",
       "      <td>Herbert Hoover</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1932</td>\n",
       "      <td>John Nance Garner</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1936</td>\n",
       "      <td>John Nance Garner</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1940</td>\n",
       "      <td>Henry A. Wallace</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Vacant throughJan. 20, 1949</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1948</td>\n",
       "      <td>Alben W. Barkley</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1952</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>January 20, 1953</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1956</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>January 20, 1953</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>35</td>\n",
       "      <td>January 20, 1961–November 22, 1963</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John F. Kennedy[s]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>January 20, 1961</td>\n",
       "      <td>John F. Kennedy[s]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Vacant throughJan. 20, 1965</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1964</td>\n",
       "      <td>Hubert Humphrey</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1968</td>\n",
       "      <td>Spiro Agnew[h]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Spiro Agnew[h]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Vacant, Oct. 10 – Dec. 6, 1973</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Gerald Ford[t]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Vacant throughDec. 19, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Nelson Rockefeller[t]</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>39</td>\n",
       "      <td>January 20, 1977–January 20, 1981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jimmy Carter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1976</td>\n",
       "      <td>Walter Mondale</td>\n",
       "      <td>January 20, 1977</td>\n",
       "      <td>Jimmy Carter</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1980</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>January 20, 1981</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1984</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>January 20, 1981</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>41</td>\n",
       "      <td>January 20, 1989–January 20, 1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1988</td>\n",
       "      <td>Dan Quayle</td>\n",
       "      <td>January 20, 1989</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1992</td>\n",
       "      <td>Al Gore</td>\n",
       "      <td>January 20, 1993</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1996</td>\n",
       "      <td>Al Gore</td>\n",
       "      <td>January 20, 1993</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2000</td>\n",
       "      <td>Dick Cheney</td>\n",
       "      <td>January 20, 2001</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2004</td>\n",
       "      <td>Dick Cheney</td>\n",
       "      <td>January 20, 2001</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2008</td>\n",
       "      <td>Joe Biden</td>\n",
       "      <td>January 20, 2009</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2012</td>\n",
       "      <td>Joe Biden</td>\n",
       "      <td>January 20, 2009</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>45</td>\n",
       "      <td>January 20, 2017–Incumbent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Donald Trump</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2016</td>\n",
       "      <td>Mike Pence</td>\n",
       "      <td>January 20, 2017</td>\n",
       "      <td>Donald Trump</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>82 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Presidency[a]                    Presidency[a].1           President  \\\n",
       "0                    1       April 30, 1789–March 4, 1797                 NaN   \n",
       "1                    1       April 30, 1789–March 4, 1797                 NaN   \n",
       "2                    2        March 4, 1797–March 4, 1801                 NaN   \n",
       "3                    3        March 4, 1801–March 4, 1809                 NaN   \n",
       "4                    3        March 4, 1801–March 4, 1809                 NaN   \n",
       "..                 ...                                ...                 ...   \n",
       "77                  43  January 20, 2001–January 20, 2009                 NaN   \n",
       "78                  44  January 20, 2009–January 20, 2017                 NaN   \n",
       "79                  44  January 20, 2009–January 20, 2017                 NaN   \n",
       "80                  45         January 20, 2017–Incumbent                 NaN   \n",
       "81  Sources: [3][4][5]                 Sources: [3][4][5]  Sources: [3][4][5]   \n",
       "\n",
       "           President.1            Party[b]             Party[b].1  \\\n",
       "0    George Washington                 NaN           Unaffiliated   \n",
       "1    George Washington                 NaN           Unaffiliated   \n",
       "2           John Adams                 NaN             Federalist   \n",
       "3     Thomas Jefferson                 NaN  Democratic-Republican   \n",
       "4     Thomas Jefferson                 NaN  Democratic-Republican   \n",
       "..                 ...                 ...                    ...   \n",
       "77      George W. Bush                 NaN             Republican   \n",
       "78        Barack Obama                 NaN             Democratic   \n",
       "79        Barack Obama                 NaN             Democratic   \n",
       "80        Donald Trump                 NaN             Republican   \n",
       "81  Sources: [3][4][5]  Sources: [3][4][5]     Sources: [3][4][5]   \n",
       "\n",
       "              Election       Vice President          pres_start  \\\n",
       "0              1788–89        John Adams[c]      April 30, 1789   \n",
       "1                 1792        John Adams[c]      April 30, 1789   \n",
       "2                 1796  Thomas Jefferson[d]       March 4, 1797   \n",
       "3                 1800           Aaron Burr       March 4, 1801   \n",
       "4                 1804    George Clinton[e]       March 4, 1801   \n",
       "..                 ...                  ...                 ...   \n",
       "77                2004          Dick Cheney    January 20, 2001   \n",
       "78                2008            Joe Biden    January 20, 2009   \n",
       "79                2012            Joe Biden    January 20, 2009   \n",
       "80                2016           Mike Pence    January 20, 2017   \n",
       "81  Sources: [3][4][5]   Sources: [3][4][5]  Sources: [3][4][5]   \n",
       "\n",
       "            pres_name birth death  \n",
       "0   George Washington  None  None  \n",
       "1   George Washington  None  None  \n",
       "2          John Adams  None  None  \n",
       "3    Thomas Jefferson  None  None  \n",
       "4    Thomas Jefferson  None  None  \n",
       "..                ...   ...   ...  \n",
       "77     George W. Bush  None  None  \n",
       "78       Barack Obama  None  None  \n",
       "79       Barack Obama  None  None  \n",
       "80       Donald Trump  None  None  \n",
       "81         Sources: [  None  None  \n",
       "\n",
       "[82 rows x 12 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_years(row):\n",
    "    import re\n",
    "    #test='George Washington1732–1799(Lived: 67 years)[3][4][5]'\n",
    "    test=row[\"President.1\"]\n",
    "    pattern=r'(?P<birth>\\d\\d\\d\\d).(?P<death>\\d\\d\\d\\d)'\n",
    "    m=re.search(pattern,test)\n",
    "    if m:\n",
    "        m.groupdict()\n",
    "        row[\"birth\"]=m[\"birth\"]\n",
    "        row[\"death\"]=m[\"death\"]\n",
    "        return row\n",
    "    else:\n",
    "        row[\"birth\"]=None\n",
    "        row[\"death\"]=None\n",
    "        return row\n",
    "df.apply(get_years, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Presidency[a]</th>\n",
       "      <th>Presidency[a].1</th>\n",
       "      <th>President</th>\n",
       "      <th>President.1</th>\n",
       "      <th>Party[b]</th>\n",
       "      <th>Party[b].1</th>\n",
       "      <th>Election</th>\n",
       "      <th>Vice President</th>\n",
       "      <th>pres_start</th>\n",
       "      <th>pres_name</th>\n",
       "      <th>real_birth</th>\n",
       "      <th>real_death</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[c]</td>\n",
       "      <td>April 30, 1789</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>March 4, 1797–March 4, 1801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[d]</td>\n",
       "      <td>March 4, 1797</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron Burr</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>March 4, 1801–March 4, 1809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>George Clinton[e]</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>Vacant afterApr. 20, 1812</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Elbridge Gerry[e]</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4</td>\n",
       "      <td>March 4, 1809–March 4, 1817</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Vacant afterNov. 23, 1814</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5</td>\n",
       "      <td>March 4, 1817–March 4, 1825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1816</td>\n",
       "      <td>Daniel D. Tompkins</td>\n",
       "      <td>March 4, 1817</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5</td>\n",
       "      <td>March 4, 1817–March 4, 1825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1820</td>\n",
       "      <td>Daniel D. Tompkins</td>\n",
       "      <td>March 4, 1817</td>\n",
       "      <td>James Monroe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>6</td>\n",
       "      <td>March 4, 1825–March 4, 1829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican[f]</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6</td>\n",
       "      <td>March 4, 1825–March 4, 1829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Republican</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>John C. Calhoun[g][h]</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>Vacant afterDec. 28, 1832</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1832</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8</td>\n",
       "      <td>March 4, 1837–March 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1836</td>\n",
       "      <td>Richard Mentor Johnson</td>\n",
       "      <td>March 4, 1837</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9</td>\n",
       "      <td>March 4, 1841–April 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Henry Harrison[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1840</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>March 4, 1841</td>\n",
       "      <td>William Henry Harrison[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig[j]</td>\n",
       "      <td>1840</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated</td>\n",
       "      <td>1840</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11</td>\n",
       "      <td>March 4, 1845–March 4, 1849</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James K. Polk</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1844</td>\n",
       "      <td>George M. Dallas</td>\n",
       "      <td>March 4, 1845</td>\n",
       "      <td>James K. Polk</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>12</td>\n",
       "      <td>March 4, 1849–July 9, 1850</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zachary Taylor[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>March 4, 1849</td>\n",
       "      <td>Zachary Taylor[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>13</td>\n",
       "      <td>July 9, 1850[k]–March 4, 1853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>July 9, 1850[k]</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>William R. King[e]</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>Vacant afterApr. 18, 1853</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>15</td>\n",
       "      <td>March 4, 1857–March 4, 1861</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Buchanan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1856</td>\n",
       "      <td>John C. Breckinridge</td>\n",
       "      <td>March 4, 1857</td>\n",
       "      <td>James Buchanan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1860</td>\n",
       "      <td>Hannibal Hamlin</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Union[m]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>Abraham Lincoln[l]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National Union[n]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1864</td>\n",
       "      <td>Vacant throughoutpresidency</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>31</td>\n",
       "      <td>March 4, 1929–March 4, 1933</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Herbert Hoover</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1928</td>\n",
       "      <td>Charles Curtis</td>\n",
       "      <td>March 4, 1929</td>\n",
       "      <td>Herbert Hoover</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1932</td>\n",
       "      <td>John Nance Garner</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1936</td>\n",
       "      <td>John Nance Garner</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1940</td>\n",
       "      <td>Henry A. Wallace</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt[e]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Vacant throughJan. 20, 1949</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1948</td>\n",
       "      <td>Alben W. Barkley</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1952</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>January 20, 1953</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1956</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>January 20, 1953</td>\n",
       "      <td>Dwight D. Eisenhower</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>35</td>\n",
       "      <td>January 20, 1961–November 22, 1963</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John F. Kennedy[s]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>January 20, 1961</td>\n",
       "      <td>John F. Kennedy[s]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Vacant throughJan. 20, 1965</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1964</td>\n",
       "      <td>Hubert Humphrey</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1968</td>\n",
       "      <td>Spiro Agnew[h]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Spiro Agnew[h]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Vacant, Oct. 10 – Dec. 6, 1973</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Gerald Ford[t]</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon[h]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Vacant throughDec. 19, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Nelson Rockefeller[t]</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>39</td>\n",
       "      <td>January 20, 1977–January 20, 1981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jimmy Carter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1976</td>\n",
       "      <td>Walter Mondale</td>\n",
       "      <td>January 20, 1977</td>\n",
       "      <td>Jimmy Carter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1980</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>January 20, 1981</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1984</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>January 20, 1981</td>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>41</td>\n",
       "      <td>January 20, 1989–January 20, 1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1988</td>\n",
       "      <td>Dan Quayle</td>\n",
       "      <td>January 20, 1989</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1992</td>\n",
       "      <td>Al Gore</td>\n",
       "      <td>January 20, 1993</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1996</td>\n",
       "      <td>Al Gore</td>\n",
       "      <td>January 20, 1993</td>\n",
       "      <td>Bill Clinton</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2000</td>\n",
       "      <td>Dick Cheney</td>\n",
       "      <td>January 20, 2001</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2004</td>\n",
       "      <td>Dick Cheney</td>\n",
       "      <td>January 20, 2001</td>\n",
       "      <td>George W. Bush</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2008</td>\n",
       "      <td>Joe Biden</td>\n",
       "      <td>January 20, 2009</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2012</td>\n",
       "      <td>Joe Biden</td>\n",
       "      <td>January 20, 2009</td>\n",
       "      <td>Barack Obama</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>45</td>\n",
       "      <td>January 20, 2017–Incumbent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Donald Trump</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2016</td>\n",
       "      <td>Mike Pence</td>\n",
       "      <td>January 20, 2017</td>\n",
       "      <td>Donald Trump</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [3][4][5]</td>\n",
       "      <td>Sources: [</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>82 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Presidency[a]                    Presidency[a].1           President  \\\n",
       "0                    1       April 30, 1789–March 4, 1797                 NaN   \n",
       "1                    1       April 30, 1789–March 4, 1797                 NaN   \n",
       "2                    2        March 4, 1797–March 4, 1801                 NaN   \n",
       "3                    3        March 4, 1801–March 4, 1809                 NaN   \n",
       "4                    3        March 4, 1801–March 4, 1809                 NaN   \n",
       "..                 ...                                ...                 ...   \n",
       "77                  43  January 20, 2001–January 20, 2009                 NaN   \n",
       "78                  44  January 20, 2009–January 20, 2017                 NaN   \n",
       "79                  44  January 20, 2009–January 20, 2017                 NaN   \n",
       "80                  45         January 20, 2017–Incumbent                 NaN   \n",
       "81  Sources: [3][4][5]                 Sources: [3][4][5]  Sources: [3][4][5]   \n",
       "\n",
       "           President.1            Party[b]             Party[b].1  \\\n",
       "0    George Washington                 NaN           Unaffiliated   \n",
       "1    George Washington                 NaN           Unaffiliated   \n",
       "2           John Adams                 NaN             Federalist   \n",
       "3     Thomas Jefferson                 NaN  Democratic-Republican   \n",
       "4     Thomas Jefferson                 NaN  Democratic-Republican   \n",
       "..                 ...                 ...                    ...   \n",
       "77      George W. Bush                 NaN             Republican   \n",
       "78        Barack Obama                 NaN             Democratic   \n",
       "79        Barack Obama                 NaN             Democratic   \n",
       "80        Donald Trump                 NaN             Republican   \n",
       "81  Sources: [3][4][5]  Sources: [3][4][5]     Sources: [3][4][5]   \n",
       "\n",
       "              Election       Vice President          pres_start  \\\n",
       "0              1788–89        John Adams[c]      April 30, 1789   \n",
       "1                 1792        John Adams[c]      April 30, 1789   \n",
       "2                 1796  Thomas Jefferson[d]       March 4, 1797   \n",
       "3                 1800           Aaron Burr       March 4, 1801   \n",
       "4                 1804    George Clinton[e]       March 4, 1801   \n",
       "..                 ...                  ...                 ...   \n",
       "77                2004          Dick Cheney    January 20, 2001   \n",
       "78                2008            Joe Biden    January 20, 2009   \n",
       "79                2012            Joe Biden    January 20, 2009   \n",
       "80                2016           Mike Pence    January 20, 2017   \n",
       "81  Sources: [3][4][5]   Sources: [3][4][5]  Sources: [3][4][5]   \n",
       "\n",
       "            pres_name real_birth real_death  \n",
       "0   George Washington        NaN        NaN  \n",
       "1   George Washington        NaN        NaN  \n",
       "2          John Adams        NaN        NaN  \n",
       "3    Thomas Jefferson        NaN        NaN  \n",
       "4    Thomas Jefferson        NaN        NaN  \n",
       "..                ...        ...        ...  \n",
       "77     George W. Bush        NaN        NaN  \n",
       "78       Barack Obama        NaN        NaN  \n",
       "79       Barack Obama        NaN        NaN  \n",
       "80       Donald Trump        NaN        NaN  \n",
       "81         Sources: [        NaN        NaN  \n",
       "\n",
       "[82 rows x 12 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[[\"real_birth\",\"real_death\"]]=df[\"President.1\"].str.extract(r'(?P<birth>\\d\\d\\d\\d).(?P<death>\\d\\d\\d\\d)')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.iloc[69]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}