190930_more_cleaning.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": 1,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"9\" halign=\"left\">Unaffiliated (2) Federalist (1) Democratic-Republican (4) Democratic (15) Whig (4) Republican (19) National Union (2)</th>\n",
       "    </tr>\n",
       "    <tr>\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>Prior office[b]</th>\n",
       "      <th>Party[c]</th>\n",
       "      <th>Party[c].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[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[e][f]</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 Adams1735–1826(Lived: 90 years)[6][7][8]</td>\n",
       "      <td>1stvice president of the United States(1789–1797)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[g]</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron BurrMarch 4, 1801 – March 4, 1805</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George ClintonMarch 4, 1805 – March 4, 1809</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>George ClintonMarch 4, 1809 – April 20, 1812(D...</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>Office vacant(Balance of Clinton's term)</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Elbridge GerryMarch 4, 1813 – November 23, 181...</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Office vacant(Balance of Gerry's term)</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 Monroe1758–1831(Lived: 73 years)[15][16]...</td>\n",
       "      <td>7thUnited States secretary of state(1811–1817)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1816</td>\n",
       "      <td>Daniel D. Tompkins</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 Monroe1758–1831(Lived: 73 years)[15][16]...</td>\n",
       "      <td>7thUnited States secretary of state(1811–1817)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1820</td>\n",
       "      <td>Daniel D. Tompkins</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 Adams1767–1848(Lived: 80 years)[18...</td>\n",
       "      <td>8thUnited States secretary of state(1817–1825)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>John C. Calhoun[h]March 4, 1829 – December 28,...</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 Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>Office vacant(Balance of Calhoun's term)</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 Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1832</td>\n",
       "      <td>Martin Van BurenMarch 4, 1833 – March 4, 1837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8</td>\n",
       "      <td>March 4, 1837–March 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martin Van Buren1782–1862(Lived: 79 years)[24]...</td>\n",
       "      <td>8th vice president of the United States(1833–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1836</td>\n",
       "      <td>Richard M. Johnson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>9</td>\n",
       "      <td>March 4, 1841–April 4, 1841(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Henry Harrison1773–1841(Lived: 68 year...</td>\n",
       "      <td>United States minister to Colombia(1828–1829)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1840</td>\n",
       "      <td>John Tyler(Succeeded to presidency)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler1790–1862(Lived: 71 years)[30][31][32]</td>\n",
       "      <td>10thvice president of the United States(1841)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WhigApril 4, 1841 – September 13, 1841</td>\n",
       "      <td>1840</td>\n",
       "      <td>Office vacant</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 Tyler1790–1862(Lived: 71 years)[30][31][32]</td>\n",
       "      <td>10thvice president of the United States(1841)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UnaffiliatedSeptember 13, 1841 – March 4, 1845[j]</td>\n",
       "      <td>1840</td>\n",
       "      <td>Office vacant</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>11</td>\n",
       "      <td>March 4, 1845–March 4, 1849</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James K. Polk1795–1849(Lived: 53 years)[33][34...</td>\n",
       "      <td>9thgovernor of Tennessee(1839–1841)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1844</td>\n",
       "      <td>George M. Dallas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>12</td>\n",
       "      <td>March 4, 1849–July 9, 1850(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zachary Taylor1784–1850(Lived: 65 years)[36][3...</td>\n",
       "      <td>Major general of the 1st Infantry RegimentUnit...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Millard Fillmore(Succeeded to presidency)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>13</td>\n",
       "      <td>July 9, 1850[k]–March 4, 1853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Millard Fillmore1800–1874(Lived: 74 years)[39]...</td>\n",
       "      <td>12thvice president of the United States(1849–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Office vacant</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce1804–1869(Lived: 64 years)[42][...</td>\n",
       "      <td>Brigadier general of the 9th InfantryUnited St...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>William R. KingMarch 4 – April 18, 1853(Died i...</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 Pierce1804–1869(Lived: 64 years)[42][...</td>\n",
       "      <td>Brigadier general of the 9th InfantryUnited St...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>Office vacant(Balance of King's term)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>15</td>\n",
       "      <td>March 4, 1857–March 4, 1861</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Buchanan1791–1868(Lived: 77 years)[45][4...</td>\n",
       "      <td>United States minister to theCourt of St James...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1856</td>\n",
       "      <td>John C. Breckinridge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln1809–1865(Lived: 56 years)[48][...</td>\n",
       "      <td>U.S. representative for Illinois's 7th Distric...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican(National Union)[l]</td>\n",
       "      <td>1860</td>\n",
       "      <td>Hannibal HamlinMarch 4, 1861 – March 4, 1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln1809–1865(Lived: 56 years)[48][...</td>\n",
       "      <td>U.S. representative for Illinois's 7th Distric...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican(National Union)[l]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Andrew JohnsonMarch 4 – April 15, 1865(Succeed...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson1808–1875(Lived: 66 years)[51][5...</td>\n",
       "      <td>16thvice president of the United States(1865)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National UnionApril 15, 1865 – c. 1868</td>\n",
       "      <td>1864</td>\n",
       "      <td>Office vacant</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 Johnson1808–1875(Lived: 66 years)[51][5...</td>\n",
       "      <td>16thvice president of the United States(1865)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democraticc. 1868 – March 4, 1869[m]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Office vacant</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>18</td>\n",
       "      <td>March 4, 1869–March 4, 1877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ulysses S. Grant1822–1885(Lived: 63 years)[54]...</td>\n",
       "      <td>Commanding general of the U.S. Army(1864–1869)...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1868</td>\n",
       "      <td>Schuyler ColfaxMarch 4, 1869 – March 4, 1873</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>30</td>\n",
       "      <td>August 2, 1923[o]–March 4, 1929</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Calvin Coolidge1872–1933(Lived: 60 years)[87][...</td>\n",
       "      <td>29thvice president of the United States(1921–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1924</td>\n",
       "      <td>Charles G. DawesMarch 4, 1925 – March 4, 1929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>31</td>\n",
       "      <td>March 4, 1929–March 4, 1933</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Herbert Hoover1874–1964(Lived: 90 years)[90][9...</td>\n",
       "      <td>3rdUnited States secretary of commerce(1921–19...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1928</td>\n",
       "      <td>Charles Curtis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1932</td>\n",
       "      <td>John N. GarnerMarch 4, 1933 – January 20, 1941[p]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1936</td>\n",
       "      <td>John N. GarnerMarch 4, 1933 – January 20, 1941[p]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1940</td>\n",
       "      <td>Henry A. WallaceJanuary 20, 1941 – January 20,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Harry S. TrumanJanuary 20 – April 12, 1945(Suc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman1884–1972(Lived: 88 years)[96][...</td>\n",
       "      <td>34thvice president of the United States(1945)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Office vacantApril 12, 1945 – January 20, 1949</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. Truman1884–1972(Lived: 88 years)[96][...</td>\n",
       "      <td>34thvice president of the United States(1945)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1948</td>\n",
       "      <td>Alben W. BarkleyJanuary 20, 1949 – January 20,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower1890–1969(Lived: 78 years)...</td>\n",
       "      <td>Supreme Allied Commander Europe(1949–1952)(No ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1952</td>\n",
       "      <td>Richard Nixon</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. Eisenhower1890–1969(Lived: 78 years)...</td>\n",
       "      <td>Supreme Allied Commander Europe(1949–1952)(No ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1956</td>\n",
       "      <td>Richard Nixon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>35</td>\n",
       "      <td>January 20, 1961–November 22, 1963(Died in off...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John F. Kennedy1917–1963(Lived: 46 years)[102]...</td>\n",
       "      <td>U.S. senator from Massachusetts(1953–1960)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Lyndon B. Johnson(Succeeded to presidency)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson1908–1973(Lived: 64 years)[10...</td>\n",
       "      <td>37thvice president of the United States(1961–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Office vacantNovember 22, 1963 – January 20, 1965</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. Johnson1908–1973(Lived: 64 years)[10...</td>\n",
       "      <td>37thvice president of the United States(1961–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1964</td>\n",
       "      <td>Hubert HumphreyJanuary 20, 1965 – January 20, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1968</td>\n",
       "      <td>Spiro AgnewJanuary 20, 1969 – October 10, 1973...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Spiro AgnewJanuary 20, 1969 – October 10, 1973...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Office vacantOctober 10 – December 6, 1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Gerald FordDecember 6, 1973 – August 9, 1974(S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford1913–2006(Lived: 93 years)[111][112...</td>\n",
       "      <td>40thvice president of the United States(1973–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Office vacantAugust 9 – December 19, 1974</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 Ford1913–2006(Lived: 93 years)[111][112...</td>\n",
       "      <td>40thvice president of the United States(1973–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Nelson RockefellerDecember 19, 1974 – January ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>39</td>\n",
       "      <td>January 20, 1977–January 20, 1981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jimmy CarterBorn 1924(94 years old)[114][115][...</td>\n",
       "      <td>76thgovernor of Georgia(1971–1975)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1976</td>\n",
       "      <td>Walter Mondale</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan1911–2004(Lived: 93 years)[117][1...</td>\n",
       "      <td>33rdgovernor of California(1967–1975)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1980</td>\n",
       "      <td>George H. W. Bush</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 Reagan1911–2004(Lived: 93 years)[117][1...</td>\n",
       "      <td>33rdgovernor of California(1967–1975)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1984</td>\n",
       "      <td>George H. W. Bush</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>41</td>\n",
       "      <td>January 20, 1989–January 20, 1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George H. W. Bush1924–2018(Lived: 94 years)[12...</td>\n",
       "      <td>43rdvice president of the United States(1981–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1988</td>\n",
       "      <td>Dan Quayle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill ClintonBorn 1946(73 years old)[123][124][...</td>\n",
       "      <td>40th &amp; 42ndgovernor of Arkansas(1979–1981 &amp; 19...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1992</td>\n",
       "      <td>Al Gore</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 ClintonBorn 1946(73 years old)[123][124][...</td>\n",
       "      <td>40th &amp; 42ndgovernor of Arkansas(1979–1981 &amp; 19...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1996</td>\n",
       "      <td>Al Gore</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. BushBorn 1946(73 years old)[126][127]</td>\n",
       "      <td>46thgovernor of Texas(1995–2000)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2000</td>\n",
       "      <td>Dick Cheney</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. BushBorn 1946(73 years old)[126][127]</td>\n",
       "      <td>46thgovernor of Texas(1995–2000)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2004</td>\n",
       "      <td>Dick Cheney</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack ObamaBorn 1961(58 years old)[128][129]</td>\n",
       "      <td>U.S. senator from Illinois(2005–2008)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2008</td>\n",
       "      <td>Joe Biden</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 ObamaBorn 1961(58 years old)[128][129]</td>\n",
       "      <td>U.S. senator from Illinois(2005–2008)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>2012</td>\n",
       "      <td>Joe Biden</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>45</td>\n",
       "      <td>January 20, 2017–Incumbent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Donald TrumpBorn 1946(73 years old)[130][131]</td>\n",
       "      <td>Chairman ofthe Trump Organization(1971–2017)(N...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>2016</td>\n",
       "      <td>Mike Pence</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>80 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unaffiliated (2) Federalist (1) Democratic-Republican (4) Democratic (15) Whig (4) Republican (19) National Union (2)  \\\n",
       "                                                                                                           Presidency[a]   \n",
       "0                                                   1                                                                      \n",
       "1                                                   1                                                                      \n",
       "2                                                   2                                                                      \n",
       "3                                                   3                                                                      \n",
       "4                                                   3                                                                      \n",
       "..                                                ...                                                                      \n",
       "75                                                 43                                                                      \n",
       "76                                                 43                                                                      \n",
       "77                                                 44                                                                      \n",
       "78                                                 44                                                                      \n",
       "79                                                 45                                                                      \n",
       "\n",
       "                                                 \\\n",
       "                      Presidency[a].1 President   \n",
       "0     April 30, 1789[d]–March 4, 1797       NaN   \n",
       "1     April 30, 1789[d]–March 4, 1797       NaN   \n",
       "2         March 4, 1797–March 4, 1801       NaN   \n",
       "3         March 4, 1801–March 4, 1809       NaN   \n",
       "4         March 4, 1801–March 4, 1809       NaN   \n",
       "..                                ...       ...   \n",
       "75  January 20, 2001–January 20, 2009       NaN   \n",
       "76  January 20, 2001–January 20, 2009       NaN   \n",
       "77  January 20, 2009–January 20, 2017       NaN   \n",
       "78  January 20, 2009–January 20, 2017       NaN   \n",
       "79         January 20, 2017–Incumbent       NaN   \n",
       "\n",
       "                                                       \\\n",
       "                                          President.1   \n",
       "0   George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "1   George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "2       John Adams1735–1826(Lived: 90 years)[6][7][8]   \n",
       "3   Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "4   Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "..                                                ...   \n",
       "75    George W. BushBorn 1946(73 years old)[126][127]   \n",
       "76    George W. BushBorn 1946(73 years old)[126][127]   \n",
       "77      Barack ObamaBorn 1961(58 years old)[128][129]   \n",
       "78      Barack ObamaBorn 1961(58 years old)[128][129]   \n",
       "79      Donald TrumpBorn 1946(73 years old)[130][131]   \n",
       "\n",
       "                                                                \\\n",
       "                                      Prior office[b] Party[c]   \n",
       "0   Commander-in-Chiefof theContinental Army(1775–...      NaN   \n",
       "1   Commander-in-Chiefof theContinental Army(1775–...      NaN   \n",
       "2   1stvice president of the United States(1789–1797)      NaN   \n",
       "3   2ndvice president of the United States(1797–1801)      NaN   \n",
       "4   2ndvice president of the United States(1797–1801)      NaN   \n",
       "..                                                ...      ...   \n",
       "75                   46thgovernor of Texas(1995–2000)      NaN   \n",
       "76                   46thgovernor of Texas(1995–2000)      NaN   \n",
       "77              U.S. senator from Illinois(2005–2008)      NaN   \n",
       "78              U.S. senator from Illinois(2005–2008)      NaN   \n",
       "79  Chairman ofthe Trump Organization(1971–2017)(N...      NaN   \n",
       "\n",
       "                                    \\\n",
       "               Party[c].1 Election   \n",
       "0         Unaffiliated[2]  1788–89   \n",
       "1         Unaffiliated[2]     1792   \n",
       "2              Federalist     1796   \n",
       "3   Democratic-Republican     1800   \n",
       "4   Democratic-Republican     1804   \n",
       "..                    ...      ...   \n",
       "75             Republican     2000   \n",
       "76             Republican     2004   \n",
       "77             Democratic     2008   \n",
       "78             Democratic     2012   \n",
       "79             Republican     2016   \n",
       "\n",
       "                                                 \n",
       "                                 Vice President  \n",
       "0                              John Adams[e][f]  \n",
       "1                              John Adams[e][f]  \n",
       "2                           Thomas Jefferson[g]  \n",
       "3       Aaron BurrMarch 4, 1801 – March 4, 1805  \n",
       "4   George ClintonMarch 4, 1805 – March 4, 1809  \n",
       "..                                          ...  \n",
       "75                                  Dick Cheney  \n",
       "76                                  Dick Cheney  \n",
       "77                                    Joe Biden  \n",
       "78                                    Joe Biden  \n",
       "79                                   Mike Pence  \n",
       "\n",
       "[80 rows x 9 columns]"
      ]
     },
     "execution_count": 1,
     "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"
   ]
  },
  {
   "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": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns=df.columns.droplevel(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Prior office[b]</th>\n",
       "      <th>Party[c]</th>\n",
       "      <th>Party[c].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[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[e][f]</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 Adams1735–1826(Lived: 90 years)[6][7][8]</td>\n",
       "      <td>1stvice president of the United States(1789–1797)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[g]</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron BurrMarch 4, 1801 – March 4, 1805</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George ClintonMarch 4, 1805 – March 4, 1809</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Presidency[a]                  Presidency[a].1  President  \\\n",
       "0              1  April 30, 1789[d]–March 4, 1797        NaN   \n",
       "1              1  April 30, 1789[d]–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",
       "                                         President.1  \\\n",
       "0  George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "1  George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "2      John Adams1735–1826(Lived: 90 years)[6][7][8]   \n",
       "3  Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "4  Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "\n",
       "                                     Prior office[b]  Party[c]  \\\n",
       "0  Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "1  Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "2  1stvice president of the United States(1789–1797)       NaN   \n",
       "3  2ndvice president of the United States(1797–1801)       NaN   \n",
       "4  2ndvice president of the United States(1797–1801)       NaN   \n",
       "\n",
       "              Party[c].1 Election                               Vice President  \n",
       "0        Unaffiliated[2]  1788–89                             John Adams[e][f]  \n",
       "1        Unaffiliated[2]     1792                             John Adams[e][f]  \n",
       "2             Federalist     1796                          Thomas Jefferson[g]  \n",
       "3  Democratic-Republican     1800      Aaron BurrMarch 4, 1801 – March 4, 1805  \n",
       "4  Democratic-Republican     1804  George ClintonMarch 4, 1805 – March 4, 1809  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     April 30, 1789[d]\n",
       "1     April 30, 1789[d]\n",
       "2         March 4, 1797\n",
       "3         March 4, 1801\n",
       "4         March 4, 1801\n",
       "            ...        \n",
       "75     January 20, 2001\n",
       "76     January 20, 2001\n",
       "77     January 20, 2009\n",
       "78     January 20, 2009\n",
       "79     January 20, 2017\n",
       "Length: 80, dtype: object"
      ]
     },
     "execution_count": 23,
     "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": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Presidency[a]</th>\n",
       "      <th>Presidency[a].1</th>\n",
       "      <th>President</th>\n",
       "      <th>President.1</th>\n",
       "      <th>Prior office[b]</th>\n",
       "      <th>Party[c]</th>\n",
       "      <th>Party[c].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[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "      <td>April 30, 1789[d]</td>\n",
       "      <td>April 30, 1789[d]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "      <td>April 30, 1789[d]</td>\n",
       "      <td>April 30, 1789[d]</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 Adams1735–1826(Lived: 90 years)[6][7][8]</td>\n",
       "      <td>1stvice president of the United States(1789–1797)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[g]</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron BurrMarch 4, 1801 – March 4, 1805</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George ClintonMarch 4, 1805 – March 4, 1809</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>George ClintonMarch 4, 1809 – April 20, 1812(D...</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>Office vacant(Balance of Clinton's term)</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Elbridge GerryMarch 4, 1813 – November 23, 181...</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Office vacant(Balance of Gerry's term)</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 Monroe1758–1831(Lived: 73 years)[15][16]...</td>\n",
       "      <td>7thUnited States secretary of state(1811–1817)</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 Monroe1758–1831(Lived: 73 years)[15][16]...</td>\n",
       "      <td>7thUnited States secretary of state(1811–1817)</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 Adams1767–1848(Lived: 80 years)[18...</td>\n",
       "      <td>8thUnited States secretary of state(1817–1825)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>March 4, 1825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>John C. Calhoun[h]March 4, 1829 – December 28,...</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>March 4, 1829</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 Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>Office vacant(Balance of Calhoun's term)</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 Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1832</td>\n",
       "      <td>Martin Van BurenMarch 4, 1833 – March 4, 1837</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>March 4, 1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8</td>\n",
       "      <td>March 4, 1837–March 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martin Van Buren1782–1862(Lived: 79 years)[24]...</td>\n",
       "      <td>8th vice president of the United States(1833–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1836</td>\n",
       "      <td>Richard M. Johnson</td>\n",
       "      <td>March 4, 1837</td>\n",
       "      <td>March 4, 1837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>9</td>\n",
       "      <td>March 4, 1841–April 4, 1841(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Henry Harrison1773–1841(Lived: 68 year...</td>\n",
       "      <td>United States minister to Colombia(1828–1829)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1840</td>\n",
       "      <td>John Tyler(Succeeded to presidency)</td>\n",
       "      <td>March 4, 1841</td>\n",
       "      <td>March 4, 1841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler1790–1862(Lived: 71 years)[30][31][32]</td>\n",
       "      <td>10thvice president of the United States(1841)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WhigApril 4, 1841 – September 13, 1841</td>\n",
       "      <td>1840</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>April 4, 1841[i]</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 Tyler1790–1862(Lived: 71 years)[30][31][32]</td>\n",
       "      <td>10thvice president of the United States(1841)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UnaffiliatedSeptember 13, 1841 – March 4, 1845[j]</td>\n",
       "      <td>1840</td>\n",
       "      <td>Office vacant</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>11</td>\n",
       "      <td>March 4, 1845–March 4, 1849</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James K. Polk1795–1849(Lived: 53 years)[33][34...</td>\n",
       "      <td>9thgovernor of Tennessee(1839–1841)</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>20</th>\n",
       "      <td>12</td>\n",
       "      <td>March 4, 1849–July 9, 1850(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zachary Taylor1784–1850(Lived: 65 years)[36][3...</td>\n",
       "      <td>Major general of the 1st Infantry RegimentUnit...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Millard Fillmore(Succeeded to presidency)</td>\n",
       "      <td>March 4, 1849</td>\n",
       "      <td>March 4, 1849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>13</td>\n",
       "      <td>July 9, 1850[k]–March 4, 1853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Millard Fillmore1800–1874(Lived: 74 years)[39]...</td>\n",
       "      <td>12thvice president of the United States(1849–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>July 9, 1850[k]</td>\n",
       "      <td>July 9, 1850[k]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce1804–1869(Lived: 64 years)[42][...</td>\n",
       "      <td>Brigadier general of the 9th InfantryUnited St...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>William R. KingMarch 4 – April 18, 1853(Died i...</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>March 4, 1853</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 Pierce1804–1869(Lived: 64 years)[42][...</td>\n",
       "      <td>Brigadier general of the 9th InfantryUnited St...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>Office vacant(Balance of King's term)</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>March 4, 1853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>15</td>\n",
       "      <td>March 4, 1857–March 4, 1861</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Buchanan1791–1868(Lived: 77 years)[45][4...</td>\n",
       "      <td>United States minister to theCourt of St James...</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>25</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln1809–1865(Lived: 56 years)[48][...</td>\n",
       "      <td>U.S. representative for Illinois's 7th Distric...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican(National Union)[l]</td>\n",
       "      <td>1860</td>\n",
       "      <td>Hannibal HamlinMarch 4, 1861 – March 4, 1865</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>March 4, 1861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln1809–1865(Lived: 56 years)[48][...</td>\n",
       "      <td>U.S. representative for Illinois's 7th Distric...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican(National Union)[l]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Andrew JohnsonMarch 4 – April 15, 1865(Succeed...</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>March 4, 1861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson1808–1875(Lived: 66 years)[51][5...</td>\n",
       "      <td>16thvice president of the United States(1865)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National UnionApril 15, 1865 – c. 1868</td>\n",
       "      <td>1864</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>April 15, 1865</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 Johnson1808–1875(Lived: 66 years)[51][5...</td>\n",
       "      <td>16thvice president of the United States(1865)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democraticc. 1868 – March 4, 1869[m]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>April 15, 1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>18</td>\n",
       "      <td>March 4, 1869–March 4, 1877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ulysses S. Grant1822–1885(Lived: 63 years)[54]...</td>\n",
       "      <td>Commanding general of the U.S. Army(1864–1869)...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1868</td>\n",
       "      <td>Schuyler ColfaxMarch 4, 1869 – March 4, 1873</td>\n",
       "      <td>March 4, 1869</td>\n",
       "      <td>March 4, 1869</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>30</td>\n",
       "      <td>August 2, 1923[o]–March 4, 1929</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Calvin Coolidge1872–1933(Lived: 60 years)[87][...</td>\n",
       "      <td>29thvice president of the United States(1921–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1924</td>\n",
       "      <td>Charles G. DawesMarch 4, 1925 – March 4, 1929</td>\n",
       "      <td>August 2, 1923[o]</td>\n",
       "      <td>August 2, 1923[o]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>31</td>\n",
       "      <td>March 4, 1929–March 4, 1933</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Herbert Hoover1874–1964(Lived: 90 years)[90][9...</td>\n",
       "      <td>3rdUnited States secretary of commerce(1921–19...</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>52</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1932</td>\n",
       "      <td>John N. GarnerMarch 4, 1933 – January 20, 1941[p]</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>March 4, 1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1936</td>\n",
       "      <td>John N. GarnerMarch 4, 1933 – January 20, 1941[p]</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(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1940</td>\n",
       "      <td>Henry A. WallaceJanuary 20, 1941 – January 20,...</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(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Harry S. TrumanJanuary 20 – April 12, 1945(Suc...</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>March 4, 1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman1884–1972(Lived: 88 years)[96][...</td>\n",
       "      <td>34thvice president of the United States(1945)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Office vacantApril 12, 1945 – January 20, 1949</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>April 12, 1945</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. Truman1884–1972(Lived: 88 years)[96][...</td>\n",
       "      <td>34thvice president of the United States(1945)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1948</td>\n",
       "      <td>Alben W. BarkleyJanuary 20, 1949 – January 20,...</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>April 12, 1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower1890–1969(Lived: 78 years)...</td>\n",
       "      <td>Supreme Allied Commander Europe(1949–1952)(No ...</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>59</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower1890–1969(Lived: 78 years)...</td>\n",
       "      <td>Supreme Allied Commander Europe(1949–1952)(No ...</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>60</th>\n",
       "      <td>35</td>\n",
       "      <td>January 20, 1961–November 22, 1963(Died in off...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John F. Kennedy1917–1963(Lived: 46 years)[102]...</td>\n",
       "      <td>U.S. senator from Massachusetts(1953–1960)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Lyndon B. Johnson(Succeeded to presidency)</td>\n",
       "      <td>January 20, 1961</td>\n",
       "      <td>January 20, 1961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson1908–1973(Lived: 64 years)[10...</td>\n",
       "      <td>37thvice president of the United States(1961–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Office vacantNovember 22, 1963 – January 20, 1965</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>November 22, 1963</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. Johnson1908–1973(Lived: 64 years)[10...</td>\n",
       "      <td>37thvice president of the United States(1961–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1964</td>\n",
       "      <td>Hubert HumphreyJanuary 20, 1965 – January 20, ...</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>November 22, 1963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1968</td>\n",
       "      <td>Spiro AgnewJanuary 20, 1969 – October 10, 1973...</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>January 20, 1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Spiro AgnewJanuary 20, 1969 – October 10, 1973...</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(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Office vacantOctober 10 – December 6, 1973</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(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Gerald FordDecember 6, 1973 – August 9, 1974(S...</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>January 20, 1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford1913–2006(Lived: 93 years)[111][112...</td>\n",
       "      <td>40thvice president of the United States(1973–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Office vacantAugust 9 – December 19, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>August 9, 1974</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 Ford1913–2006(Lived: 93 years)[111][112...</td>\n",
       "      <td>40thvice president of the United States(1973–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Nelson RockefellerDecember 19, 1974 – January ...</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>39</td>\n",
       "      <td>January 20, 1977–January 20, 1981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jimmy CarterBorn 1924(94 years old)[114][115][...</td>\n",
       "      <td>76thgovernor of Georgia(1971–1975)</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>70</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan1911–2004(Lived: 93 years)[117][1...</td>\n",
       "      <td>33rdgovernor of California(1967–1975)</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>71</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan1911–2004(Lived: 93 years)[117][1...</td>\n",
       "      <td>33rdgovernor of California(1967–1975)</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>72</th>\n",
       "      <td>41</td>\n",
       "      <td>January 20, 1989–January 20, 1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George H. W. Bush1924–2018(Lived: 94 years)[12...</td>\n",
       "      <td>43rdvice president of the United States(1981–1...</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>73</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill ClintonBorn 1946(73 years old)[123][124][...</td>\n",
       "      <td>40th &amp; 42ndgovernor of Arkansas(1979–1981 &amp; 19...</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>74</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill ClintonBorn 1946(73 years old)[123][124][...</td>\n",
       "      <td>40th &amp; 42ndgovernor of Arkansas(1979–1981 &amp; 19...</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>75</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. BushBorn 1946(73 years old)[126][127]</td>\n",
       "      <td>46thgovernor of Texas(1995–2000)</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>76</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. BushBorn 1946(73 years old)[126][127]</td>\n",
       "      <td>46thgovernor of Texas(1995–2000)</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>77</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack ObamaBorn 1961(58 years old)[128][129]</td>\n",
       "      <td>U.S. senator from Illinois(2005–2008)</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>78</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack ObamaBorn 1961(58 years old)[128][129]</td>\n",
       "      <td>U.S. senator from Illinois(2005–2008)</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>79</th>\n",
       "      <td>45</td>\n",
       "      <td>January 20, 2017–Incumbent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Donald TrumpBorn 1946(73 years old)[130][131]</td>\n",
       "      <td>Chairman ofthe Trump Organization(1971–2017)(N...</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>80 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Presidency[a]                    Presidency[a].1  President  \\\n",
       "0               1    April 30, 1789[d]–March 4, 1797        NaN   \n",
       "1               1    April 30, 1789[d]–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",
       "75             43  January 20, 2001–January 20, 2009        NaN   \n",
       "76             43  January 20, 2001–January 20, 2009        NaN   \n",
       "77             44  January 20, 2009–January 20, 2017        NaN   \n",
       "78             44  January 20, 2009–January 20, 2017        NaN   \n",
       "79             45         January 20, 2017–Incumbent        NaN   \n",
       "\n",
       "                                          President.1  \\\n",
       "0   George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "1   George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "2       John Adams1735–1826(Lived: 90 years)[6][7][8]   \n",
       "3   Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "4   Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "..                                                ...   \n",
       "75    George W. BushBorn 1946(73 years old)[126][127]   \n",
       "76    George W. BushBorn 1946(73 years old)[126][127]   \n",
       "77      Barack ObamaBorn 1961(58 years old)[128][129]   \n",
       "78      Barack ObamaBorn 1961(58 years old)[128][129]   \n",
       "79      Donald TrumpBorn 1946(73 years old)[130][131]   \n",
       "\n",
       "                                      Prior office[b]  Party[c]  \\\n",
       "0   Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "1   Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "2   1stvice president of the United States(1789–1797)       NaN   \n",
       "3   2ndvice president of the United States(1797–1801)       NaN   \n",
       "4   2ndvice president of the United States(1797–1801)       NaN   \n",
       "..                                                ...       ...   \n",
       "75                   46thgovernor of Texas(1995–2000)       NaN   \n",
       "76                   46thgovernor of Texas(1995–2000)       NaN   \n",
       "77              U.S. senator from Illinois(2005–2008)       NaN   \n",
       "78              U.S. senator from Illinois(2005–2008)       NaN   \n",
       "79  Chairman ofthe Trump Organization(1971–2017)(N...       NaN   \n",
       "\n",
       "               Party[c].1 Election  \\\n",
       "0         Unaffiliated[2]  1788–89   \n",
       "1         Unaffiliated[2]     1792   \n",
       "2              Federalist     1796   \n",
       "3   Democratic-Republican     1800   \n",
       "4   Democratic-Republican     1804   \n",
       "..                    ...      ...   \n",
       "75             Republican     2000   \n",
       "76             Republican     2004   \n",
       "77             Democratic     2008   \n",
       "78             Democratic     2012   \n",
       "79             Republican     2016   \n",
       "\n",
       "                                 Vice President         pres_start  \\\n",
       "0                              John Adams[e][f]  April 30, 1789[d]   \n",
       "1                              John Adams[e][f]  April 30, 1789[d]   \n",
       "2                           Thomas Jefferson[g]      March 4, 1797   \n",
       "3       Aaron BurrMarch 4, 1801 – March 4, 1805      March 4, 1801   \n",
       "4   George ClintonMarch 4, 1805 – March 4, 1809      March 4, 1801   \n",
       "..                                          ...                ...   \n",
       "75                                  Dick Cheney   January 20, 2001   \n",
       "76                                  Dick Cheney   January 20, 2001   \n",
       "77                                    Joe Biden   January 20, 2009   \n",
       "78                                    Joe Biden   January 20, 2009   \n",
       "79                                   Mike Pence   January 20, 2017   \n",
       "\n",
       "          presy_start  \n",
       "0   April 30, 1789[d]  \n",
       "1   April 30, 1789[d]  \n",
       "2       March 4, 1797  \n",
       "3       March 4, 1801  \n",
       "4       March 4, 1801  \n",
       "..                ...  \n",
       "75   January 20, 2001  \n",
       "76   January 20, 2001  \n",
       "77   January 20, 2009  \n",
       "78   January 20, 2009  \n",
       "79   January 20, 2017  \n",
       "\n",
       "[80 rows x 11 columns]"
      ]
     },
     "execution_count": 24,
     "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": 25,
   "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>Prior office[b]</th>\n",
       "      <th>Party[c]</th>\n",
       "      <th>Party[c].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[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "      <td>April 30, 1789[d]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "      <td>April 30, 1789[d]</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 Adams1735–1826(Lived: 90 years)[6][7][8]</td>\n",
       "      <td>1stvice president of the United States(1789–1797)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[g]</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron BurrMarch 4, 1801 – March 4, 1805</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George ClintonMarch 4, 1805 – March 4, 1809</td>\n",
       "      <td>March 4, 1801</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Presidency[a]                  Presidency[a].1  President  \\\n",
       "0              1  April 30, 1789[d]–March 4, 1797        NaN   \n",
       "1              1  April 30, 1789[d]–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",
       "                                         President.1  \\\n",
       "0  George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "1  George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "2      John Adams1735–1826(Lived: 90 years)[6][7][8]   \n",
       "3  Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "4  Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "\n",
       "                                     Prior office[b]  Party[c]  \\\n",
       "0  Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "1  Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "2  1stvice president of the United States(1789–1797)       NaN   \n",
       "3  2ndvice president of the United States(1797–1801)       NaN   \n",
       "4  2ndvice president of the United States(1797–1801)       NaN   \n",
       "\n",
       "              Party[c].1 Election  \\\n",
       "0        Unaffiliated[2]  1788–89   \n",
       "1        Unaffiliated[2]     1792   \n",
       "2             Federalist     1796   \n",
       "3  Democratic-Republican     1800   \n",
       "4  Democratic-Republican     1804   \n",
       "\n",
       "                                Vice President         pres_start  \n",
       "0                             John Adams[e][f]  April 30, 1789[d]  \n",
       "1                             John Adams[e][f]  April 30, 1789[d]  \n",
       "2                          Thomas Jefferson[g]      March 4, 1797  \n",
       "3      Aaron BurrMarch 4, 1801 – March 4, 1805      March 4, 1801  \n",
       "4  George ClintonMarch 4, 1805 – March 4, 1809      March 4, 1801  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['pres_name']=df[\"President.1\"].str.replace(r'\\d+.*','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'George Washington1732–1799(Lived: 67 years)[3][4][5]'"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"President.1\"].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "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": 50,
   "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>Prior office[b]</th>\n",
       "      <th>Party[c]</th>\n",
       "      <th>Party[c].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[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1788–89</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "      <td>April 30, 1789[d]</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>1732</td>\n",
       "      <td>1799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>April 30, 1789[d]–March 4, 1797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Washington1732–1799(Lived: 67 years)[3]...</td>\n",
       "      <td>Commander-in-Chiefof theContinental Army(1775–...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unaffiliated[2]</td>\n",
       "      <td>1792</td>\n",
       "      <td>John Adams[e][f]</td>\n",
       "      <td>April 30, 1789[d]</td>\n",
       "      <td>George Washington</td>\n",
       "      <td>1732</td>\n",
       "      <td>1799</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 Adams1735–1826(Lived: 90 years)[6][7][8]</td>\n",
       "      <td>1stvice president of the United States(1789–1797)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Federalist</td>\n",
       "      <td>1796</td>\n",
       "      <td>Thomas Jefferson[g]</td>\n",
       "      <td>March 4, 1797</td>\n",
       "      <td>John Adams</td>\n",
       "      <td>1735</td>\n",
       "      <td>1826</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1800</td>\n",
       "      <td>Aaron BurrMarch 4, 1801 – March 4, 1805</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>1743</td>\n",
       "      <td>1826</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 Jefferson1743–1826(Lived: 83 years)[9][...</td>\n",
       "      <td>2ndvice president of the United States(1797–1801)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1804</td>\n",
       "      <td>George ClintonMarch 4, 1805 – March 4, 1809</td>\n",
       "      <td>March 4, 1801</td>\n",
       "      <td>Thomas Jefferson</td>\n",
       "      <td>1743</td>\n",
       "      <td>1826</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>George ClintonMarch 4, 1809 – April 20, 1812(D...</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>1751</td>\n",
       "      <td>1836</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1808</td>\n",
       "      <td>Office vacant(Balance of Clinton's term)</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>1751</td>\n",
       "      <td>1836</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Elbridge GerryMarch 4, 1813 – November 23, 181...</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>1751</td>\n",
       "      <td>1836</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 Madison1751–1836(Lived: 85 years)[12][13...</td>\n",
       "      <td>5thUnited States secretary of state(1801–1809)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1812</td>\n",
       "      <td>Office vacant(Balance of Gerry's term)</td>\n",
       "      <td>March 4, 1809</td>\n",
       "      <td>James Madison</td>\n",
       "      <td>1751</td>\n",
       "      <td>1836</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 Monroe1758–1831(Lived: 73 years)[15][16]...</td>\n",
       "      <td>7thUnited States secretary of state(1811–1817)</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>1758</td>\n",
       "      <td>1831</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 Monroe1758–1831(Lived: 73 years)[15][16]...</td>\n",
       "      <td>7thUnited States secretary of state(1811–1817)</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>1758</td>\n",
       "      <td>1831</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 Adams1767–1848(Lived: 80 years)[18...</td>\n",
       "      <td>8thUnited States secretary of state(1817–1825)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic-Republican</td>\n",
       "      <td>1824</td>\n",
       "      <td>John C. Calhoun</td>\n",
       "      <td>March 4, 1825</td>\n",
       "      <td>John Quincy Adams</td>\n",
       "      <td>1767</td>\n",
       "      <td>1848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7</td>\n",
       "      <td>March 4, 1829–March 4, 1837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>John C. Calhoun[h]March 4, 1829 – December 28,...</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>1767</td>\n",
       "      <td>1845</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 Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1828</td>\n",
       "      <td>Office vacant(Balance of Calhoun's term)</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>1767</td>\n",
       "      <td>1845</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 Jackson1767–1845(Lived: 78 years)[21][2...</td>\n",
       "      <td>U.S. senator from Tennessee(1797–1798 &amp; 1823–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1832</td>\n",
       "      <td>Martin Van BurenMarch 4, 1833 – March 4, 1837</td>\n",
       "      <td>March 4, 1829</td>\n",
       "      <td>Andrew Jackson</td>\n",
       "      <td>1767</td>\n",
       "      <td>1845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8</td>\n",
       "      <td>March 4, 1837–March 4, 1841</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martin Van Buren1782–1862(Lived: 79 years)[24]...</td>\n",
       "      <td>8th vice president of the United States(1833–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1836</td>\n",
       "      <td>Richard M. Johnson</td>\n",
       "      <td>March 4, 1837</td>\n",
       "      <td>Martin Van Buren</td>\n",
       "      <td>1782</td>\n",
       "      <td>1862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>9</td>\n",
       "      <td>March 4, 1841–April 4, 1841(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Henry Harrison1773–1841(Lived: 68 year...</td>\n",
       "      <td>United States minister to Colombia(1828–1829)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1840</td>\n",
       "      <td>John Tyler(Succeeded to presidency)</td>\n",
       "      <td>March 4, 1841</td>\n",
       "      <td>William Henry Harrison</td>\n",
       "      <td>1773</td>\n",
       "      <td>1841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10</td>\n",
       "      <td>April 4, 1841[i]–March 4, 1845</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Tyler1790–1862(Lived: 71 years)[30][31][32]</td>\n",
       "      <td>10thvice president of the United States(1841)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WhigApril 4, 1841 – September 13, 1841</td>\n",
       "      <td>1840</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>1790</td>\n",
       "      <td>1862</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 Tyler1790–1862(Lived: 71 years)[30][31][32]</td>\n",
       "      <td>10thvice president of the United States(1841)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UnaffiliatedSeptember 13, 1841 – March 4, 1845[j]</td>\n",
       "      <td>1840</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>April 4, 1841[i]</td>\n",
       "      <td>John Tyler</td>\n",
       "      <td>1790</td>\n",
       "      <td>1862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>11</td>\n",
       "      <td>March 4, 1845–March 4, 1849</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James K. Polk1795–1849(Lived: 53 years)[33][34...</td>\n",
       "      <td>9thgovernor of Tennessee(1839–1841)</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>1795</td>\n",
       "      <td>1849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>12</td>\n",
       "      <td>March 4, 1849–July 9, 1850(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zachary Taylor1784–1850(Lived: 65 years)[36][3...</td>\n",
       "      <td>Major general of the 1st Infantry RegimentUnit...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Millard Fillmore(Succeeded to presidency)</td>\n",
       "      <td>March 4, 1849</td>\n",
       "      <td>Zachary Taylor</td>\n",
       "      <td>1784</td>\n",
       "      <td>1850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>13</td>\n",
       "      <td>July 9, 1850[k]–March 4, 1853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Millard Fillmore1800–1874(Lived: 74 years)[39]...</td>\n",
       "      <td>12thvice president of the United States(1849–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whig</td>\n",
       "      <td>1848</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>July 9, 1850[k]</td>\n",
       "      <td>Millard Fillmore</td>\n",
       "      <td>1800</td>\n",
       "      <td>1874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>14</td>\n",
       "      <td>March 4, 1853–March 4, 1857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin Pierce1804–1869(Lived: 64 years)[42][...</td>\n",
       "      <td>Brigadier general of the 9th InfantryUnited St...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>William R. KingMarch 4 – April 18, 1853(Died i...</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>1804</td>\n",
       "      <td>1869</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 Pierce1804–1869(Lived: 64 years)[42][...</td>\n",
       "      <td>Brigadier general of the 9th InfantryUnited St...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1852</td>\n",
       "      <td>Office vacant(Balance of King's term)</td>\n",
       "      <td>March 4, 1853</td>\n",
       "      <td>Franklin Pierce</td>\n",
       "      <td>1804</td>\n",
       "      <td>1869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>15</td>\n",
       "      <td>March 4, 1857–March 4, 1861</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Buchanan1791–1868(Lived: 77 years)[45][4...</td>\n",
       "      <td>United States minister to theCourt of St James...</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>1791</td>\n",
       "      <td>1868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln1809–1865(Lived: 56 years)[48][...</td>\n",
       "      <td>U.S. representative for Illinois's 7th Distric...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican(National Union)[l]</td>\n",
       "      <td>1860</td>\n",
       "      <td>Hannibal HamlinMarch 4, 1861 – March 4, 1865</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>Abraham Lincoln</td>\n",
       "      <td>1809</td>\n",
       "      <td>1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>16</td>\n",
       "      <td>March 4, 1861–April 15, 1865(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Abraham Lincoln1809–1865(Lived: 56 years)[48][...</td>\n",
       "      <td>U.S. representative for Illinois's 7th Distric...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican(National Union)[l]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Andrew JohnsonMarch 4 – April 15, 1865(Succeed...</td>\n",
       "      <td>March 4, 1861</td>\n",
       "      <td>Abraham Lincoln</td>\n",
       "      <td>1809</td>\n",
       "      <td>1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>17</td>\n",
       "      <td>April 15, 1865–March 4, 1869</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Andrew Johnson1808–1875(Lived: 66 years)[51][5...</td>\n",
       "      <td>16thvice president of the United States(1865)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>National UnionApril 15, 1865 – c. 1868</td>\n",
       "      <td>1864</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>1808</td>\n",
       "      <td>1875</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 Johnson1808–1875(Lived: 66 years)[51][5...</td>\n",
       "      <td>16thvice president of the United States(1865)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democraticc. 1868 – March 4, 1869[m]</td>\n",
       "      <td>1864</td>\n",
       "      <td>Office vacant</td>\n",
       "      <td>April 15, 1865</td>\n",
       "      <td>Andrew Johnson</td>\n",
       "      <td>1808</td>\n",
       "      <td>1875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>18</td>\n",
       "      <td>March 4, 1869–March 4, 1877</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ulysses S. Grant1822–1885(Lived: 63 years)[54]...</td>\n",
       "      <td>Commanding general of the U.S. Army(1864–1869)...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1868</td>\n",
       "      <td>Schuyler ColfaxMarch 4, 1869 – March 4, 1873</td>\n",
       "      <td>March 4, 1869</td>\n",
       "      <td>Ulysses S. Grant</td>\n",
       "      <td>1822</td>\n",
       "      <td>1885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>30</td>\n",
       "      <td>August 2, 1923[o]–March 4, 1929</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Calvin Coolidge1872–1933(Lived: 60 years)[87][...</td>\n",
       "      <td>29thvice president of the United States(1921–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1924</td>\n",
       "      <td>Charles G. DawesMarch 4, 1925 – March 4, 1929</td>\n",
       "      <td>August 2, 1923[o]</td>\n",
       "      <td>Calvin Coolidge</td>\n",
       "      <td>1872</td>\n",
       "      <td>1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>31</td>\n",
       "      <td>March 4, 1929–March 4, 1933</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Herbert Hoover1874–1964(Lived: 90 years)[90][9...</td>\n",
       "      <td>3rdUnited States secretary of commerce(1921–19...</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>1874</td>\n",
       "      <td>1964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1932</td>\n",
       "      <td>John N. GarnerMarch 4, 1933 – January 20, 1941[p]</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt</td>\n",
       "      <td>1882</td>\n",
       "      <td>1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1936</td>\n",
       "      <td>John N. GarnerMarch 4, 1933 – January 20, 1941[p]</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt</td>\n",
       "      <td>1882</td>\n",
       "      <td>1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1940</td>\n",
       "      <td>Henry A. WallaceJanuary 20, 1941 – January 20,...</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt</td>\n",
       "      <td>1882</td>\n",
       "      <td>1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>32</td>\n",
       "      <td>March 4, 1933–April 12, 1945(Died in office)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Franklin D. Roosevelt1882–1945(Lived: 63 years...</td>\n",
       "      <td>44thgovernor of New York(1929–1932)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Harry S. TrumanJanuary 20 – April 12, 1945(Suc...</td>\n",
       "      <td>March 4, 1933</td>\n",
       "      <td>Franklin D. Roosevelt</td>\n",
       "      <td>1882</td>\n",
       "      <td>1945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>33</td>\n",
       "      <td>April 12, 1945–January 20, 1953</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harry S. Truman1884–1972(Lived: 88 years)[96][...</td>\n",
       "      <td>34thvice president of the United States(1945)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1944</td>\n",
       "      <td>Office vacantApril 12, 1945 – January 20, 1949</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>1884</td>\n",
       "      <td>1972</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. Truman1884–1972(Lived: 88 years)[96][...</td>\n",
       "      <td>34thvice president of the United States(1945)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1948</td>\n",
       "      <td>Alben W. BarkleyJanuary 20, 1949 – January 20,...</td>\n",
       "      <td>April 12, 1945</td>\n",
       "      <td>Harry S. Truman</td>\n",
       "      <td>1884</td>\n",
       "      <td>1972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>34</td>\n",
       "      <td>January 20, 1953–January 20, 1961</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight D. Eisenhower1890–1969(Lived: 78 years)...</td>\n",
       "      <td>Supreme Allied Commander Europe(1949–1952)(No ...</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>1890</td>\n",
       "      <td>1969</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. Eisenhower1890–1969(Lived: 78 years)...</td>\n",
       "      <td>Supreme Allied Commander Europe(1949–1952)(No ...</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>1890</td>\n",
       "      <td>1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>35</td>\n",
       "      <td>January 20, 1961–November 22, 1963(Died in off...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John F. Kennedy1917–1963(Lived: 46 years)[102]...</td>\n",
       "      <td>U.S. senator from Massachusetts(1953–1960)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Lyndon B. Johnson(Succeeded to presidency)</td>\n",
       "      <td>January 20, 1961</td>\n",
       "      <td>John F. Kennedy</td>\n",
       "      <td>1917</td>\n",
       "      <td>1963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>36</td>\n",
       "      <td>November 22, 1963–January 20, 1969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lyndon B. Johnson1908–1973(Lived: 64 years)[10...</td>\n",
       "      <td>37thvice president of the United States(1961–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1960</td>\n",
       "      <td>Office vacantNovember 22, 1963 – January 20, 1965</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>1908</td>\n",
       "      <td>1973</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. Johnson1908–1973(Lived: 64 years)[10...</td>\n",
       "      <td>37thvice president of the United States(1961–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Democratic</td>\n",
       "      <td>1964</td>\n",
       "      <td>Hubert HumphreyJanuary 20, 1965 – January 20, ...</td>\n",
       "      <td>November 22, 1963</td>\n",
       "      <td>Lyndon B. Johnson</td>\n",
       "      <td>1908</td>\n",
       "      <td>1973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1968</td>\n",
       "      <td>Spiro AgnewJanuary 20, 1969 – October 10, 1973...</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>1913</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Spiro AgnewJanuary 20, 1969 – October 10, 1973...</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>1913</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Office vacantOctober 10 – December 6, 1973</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>1913</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>37</td>\n",
       "      <td>January 20, 1969–August 9, 1974(Resigned from ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Richard Nixon1913–1994(Lived: 81 years)[108][1...</td>\n",
       "      <td>36thvice president of the United States(1953–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Gerald FordDecember 6, 1973 – August 9, 1974(S...</td>\n",
       "      <td>January 20, 1969</td>\n",
       "      <td>Richard Nixon</td>\n",
       "      <td>1913</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>38</td>\n",
       "      <td>August 9, 1974–January 20, 1977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gerald Ford1913–2006(Lived: 93 years)[111][112...</td>\n",
       "      <td>40thvice president of the United States(1973–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Office vacantAugust 9 – December 19, 1974</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>1913</td>\n",
       "      <td>2006</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 Ford1913–2006(Lived: 93 years)[111][112...</td>\n",
       "      <td>40thvice president of the United States(1973–1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Republican</td>\n",
       "      <td>1972</td>\n",
       "      <td>Nelson RockefellerDecember 19, 1974 – January ...</td>\n",
       "      <td>August 9, 1974</td>\n",
       "      <td>Gerald Ford</td>\n",
       "      <td>1913</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>39</td>\n",
       "      <td>January 20, 1977–January 20, 1981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jimmy CarterBorn 1924(94 years old)[114][115][...</td>\n",
       "      <td>76thgovernor of Georgia(1971–1975)</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 CarterBorn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>40</td>\n",
       "      <td>January 20, 1981–January 20, 1989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ronald Reagan1911–2004(Lived: 93 years)[117][1...</td>\n",
       "      <td>33rdgovernor of California(1967–1975)</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>1911</td>\n",
       "      <td>2004</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 Reagan1911–2004(Lived: 93 years)[117][1...</td>\n",
       "      <td>33rdgovernor of California(1967–1975)</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>1911</td>\n",
       "      <td>2004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>41</td>\n",
       "      <td>January 20, 1989–January 20, 1993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George H. W. Bush1924–2018(Lived: 94 years)[12...</td>\n",
       "      <td>43rdvice president of the United States(1981–1...</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>1924</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>42</td>\n",
       "      <td>January 20, 1993–January 20, 2001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bill ClintonBorn 1946(73 years old)[123][124][...</td>\n",
       "      <td>40th &amp; 42ndgovernor of Arkansas(1979–1981 &amp; 19...</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 ClintonBorn</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 ClintonBorn 1946(73 years old)[123][124][...</td>\n",
       "      <td>40th &amp; 42ndgovernor of Arkansas(1979–1981 &amp; 19...</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 ClintonBorn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>43</td>\n",
       "      <td>January 20, 2001–January 20, 2009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George W. BushBorn 1946(73 years old)[126][127]</td>\n",
       "      <td>46thgovernor of Texas(1995–2000)</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. BushBorn</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. BushBorn 1946(73 years old)[126][127]</td>\n",
       "      <td>46thgovernor of Texas(1995–2000)</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. BushBorn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>44</td>\n",
       "      <td>January 20, 2009–January 20, 2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack ObamaBorn 1961(58 years old)[128][129]</td>\n",
       "      <td>U.S. senator from Illinois(2005–2008)</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 ObamaBorn</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 ObamaBorn 1961(58 years old)[128][129]</td>\n",
       "      <td>U.S. senator from Illinois(2005–2008)</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 ObamaBorn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>45</td>\n",
       "      <td>January 20, 2017–Incumbent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Donald TrumpBorn 1946(73 years old)[130][131]</td>\n",
       "      <td>Chairman ofthe Trump Organization(1971–2017)(N...</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 TrumpBorn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>80 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Presidency[a]                    Presidency[a].1  President  \\\n",
       "0               1    April 30, 1789[d]–March 4, 1797        NaN   \n",
       "1               1    April 30, 1789[d]–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",
       "75             43  January 20, 2001–January 20, 2009        NaN   \n",
       "76             43  January 20, 2001–January 20, 2009        NaN   \n",
       "77             44  January 20, 2009–January 20, 2017        NaN   \n",
       "78             44  January 20, 2009–January 20, 2017        NaN   \n",
       "79             45         January 20, 2017–Incumbent        NaN   \n",
       "\n",
       "                                          President.1  \\\n",
       "0   George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "1   George Washington1732–1799(Lived: 67 years)[3]...   \n",
       "2       John Adams1735–1826(Lived: 90 years)[6][7][8]   \n",
       "3   Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "4   Thomas Jefferson1743–1826(Lived: 83 years)[9][...   \n",
       "..                                                ...   \n",
       "75    George W. BushBorn 1946(73 years old)[126][127]   \n",
       "76    George W. BushBorn 1946(73 years old)[126][127]   \n",
       "77      Barack ObamaBorn 1961(58 years old)[128][129]   \n",
       "78      Barack ObamaBorn 1961(58 years old)[128][129]   \n",
       "79      Donald TrumpBorn 1946(73 years old)[130][131]   \n",
       "\n",
       "                                      Prior office[b]  Party[c]  \\\n",
       "0   Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "1   Commander-in-Chiefof theContinental Army(1775–...       NaN   \n",
       "2   1stvice president of the United States(1789–1797)       NaN   \n",
       "3   2ndvice president of the United States(1797–1801)       NaN   \n",
       "4   2ndvice president of the United States(1797–1801)       NaN   \n",
       "..                                                ...       ...   \n",
       "75                   46thgovernor of Texas(1995–2000)       NaN   \n",
       "76                   46thgovernor of Texas(1995–2000)       NaN   \n",
       "77              U.S. senator from Illinois(2005–2008)       NaN   \n",
       "78              U.S. senator from Illinois(2005–2008)       NaN   \n",
       "79  Chairman ofthe Trump Organization(1971–2017)(N...       NaN   \n",
       "\n",
       "               Party[c].1 Election  \\\n",
       "0         Unaffiliated[2]  1788–89   \n",
       "1         Unaffiliated[2]     1792   \n",
       "2              Federalist     1796   \n",
       "3   Democratic-Republican     1800   \n",
       "4   Democratic-Republican     1804   \n",
       "..                    ...      ...   \n",
       "75             Republican     2000   \n",
       "76             Republican     2004   \n",
       "77             Democratic     2008   \n",
       "78             Democratic     2012   \n",
       "79             Republican     2016   \n",
       "\n",
       "                                 Vice President         pres_start  \\\n",
       "0                              John Adams[e][f]  April 30, 1789[d]   \n",
       "1                              John Adams[e][f]  April 30, 1789[d]   \n",
       "2                           Thomas Jefferson[g]      March 4, 1797   \n",
       "3       Aaron BurrMarch 4, 1801 – March 4, 1805      March 4, 1801   \n",
       "4   George ClintonMarch 4, 1805 – March 4, 1809      March 4, 1801   \n",
       "..                                          ...                ...   \n",
       "75                                  Dick Cheney   January 20, 2001   \n",
       "76                                  Dick Cheney   January 20, 2001   \n",
       "77                                    Joe Biden   January 20, 2009   \n",
       "78                                    Joe Biden   January 20, 2009   \n",
       "79                                   Mike Pence   January 20, 2017   \n",
       "\n",
       "              pres_name real_birth real_death  \n",
       "0     George Washington       1732       1799  \n",
       "1     George Washington       1732       1799  \n",
       "2            John Adams       1735       1826  \n",
       "3      Thomas Jefferson       1743       1826  \n",
       "4      Thomas Jefferson       1743       1826  \n",
       "..                  ...        ...        ...  \n",
       "75  George W. BushBorn         NaN        NaN  \n",
       "76  George W. BushBorn         NaN        NaN  \n",
       "77    Barack ObamaBorn         NaN        NaN  \n",
       "78    Barack ObamaBorn         NaN        NaN  \n",
       "79    Donald TrumpBorn         NaN        NaN  \n",
       "\n",
       "[80 rows x 13 columns]"
      ]
     },
     "execution_count": 50,
     "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": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Presidency[a]                                                     39\n",
       "Presidency[a].1                    January 20, 1977–January 20, 1981\n",
       "President                                                        NaN\n",
       "President.1        Jimmy CarterBorn 1924(94 years old)[114][115][...\n",
       "Prior office[b]                   76thgovernor of Georgia(1971–1975)\n",
       "Party[c]                                                         NaN\n",
       "Party[c].1                                                Democratic\n",
       "Election                                                        1976\n",
       "Vice President                                        Walter Mondale\n",
       "pres_start                                          January 20, 1977\n",
       "pres_name                                          Jimmy CarterBorn \n",
       "real_birth                                                       NaN\n",
       "real_death                                                       NaN\n",
       "Name: 69, dtype: object"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "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": 2
}