03-cleaning_data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 03 - Cleaning the data\n",
    "\n",
    "This notebook continues the data cleaning from notebook `02-scapring_html`. It uses regular expressions to parce through the html bits and extract the wanted information."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import re\n",
    "\n",
    "df = pd.read_csv(\"data/nominations.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Strip the concress_no column of any text and years. \n",
    "df['congress_no'] =  df['congress_no'].apply(lambda x: re.sub(r'th Congress .\\d{4}-\\d{4}.','', str(x)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['circuit'] = df['post'].str.extract('(the \\w.+ Circuit)', expand=False).str.strip()\n",
    "\n",
    "# And strip the column of any additional text so only the circuit names remain.\n",
    "df['circuit'] = df['circuit'].str.replace('the District of Columbia, to be United States Circuit Judge for ','')\n",
    "df['circuit'] = df['circuit'].str.replace('the ','')\n",
    "df['circuit'] = df['circuit'].str.replace(' Circuit','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>nomination_no</th>\n",
       "      <th>congress_no</th>\n",
       "      <th>post</th>\n",
       "      <th>vote</th>\n",
       "      <th>circuit</th>\n",
       "      <th>confirmation_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Roopali H. Desai</td>\n",
       "      <td>PN2262</td>\n",
       "      <td>117</td>\n",
       "      <td>Roopali H. Desai, of Arizona, to be United Sta...</td>\n",
       "      <td>Latest Action: 08/04/2022 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>08/04/2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Florence Y. Pan</td>\n",
       "      <td>PN2193</td>\n",
       "      <td>117</td>\n",
       "      <td>Florence Y. Pan, of the District of Columbia, ...</td>\n",
       "      <td>Latest Action: 09/20/2022 - Confirmed by the S...</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>09/20/2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sarah A. L. Merriam</td>\n",
       "      <td>PN2141</td>\n",
       "      <td>117</td>\n",
       "      <td>Sarah A. L. Merriam, of Connecticut, to be Uni...</td>\n",
       "      <td>Latest Action: 09/15/2022 - Confirmed by the S...</td>\n",
       "      <td>Second</td>\n",
       "      <td>09/15/2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lara E. Montecalvo</td>\n",
       "      <td>PN2140</td>\n",
       "      <td>117</td>\n",
       "      <td>Lara E. Montecalvo, of Rhode Island, to be Uni...</td>\n",
       "      <td>Latest Action: 09/14/2022 - Confirmed by the S...</td>\n",
       "      <td>First</td>\n",
       "      <td>09/14/2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Salvador Mendoza Jr</td>\n",
       "      <td>PN1966</td>\n",
       "      <td>117</td>\n",
       "      <td>Salvador Mendoza, Jr., of Washington, to be Un...</td>\n",
       "      <td>Latest Action: 09/12/2022 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>09/12/2022</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  name nomination_no congress_no  \\\n",
       "0     Roopali H. Desai        PN2262         117   \n",
       "1      Florence Y. Pan        PN2193         117   \n",
       "2  Sarah A. L. Merriam        PN2141         117   \n",
       "3   Lara E. Montecalvo        PN2140         117   \n",
       "4  Salvador Mendoza Jr        PN1966         117   \n",
       "\n",
       "                                                post  \\\n",
       "0  Roopali H. Desai, of Arizona, to be United Sta...   \n",
       "1  Florence Y. Pan, of the District of Columbia, ...   \n",
       "2  Sarah A. L. Merriam, of Connecticut, to be Uni...   \n",
       "3  Lara E. Montecalvo, of Rhode Island, to be Uni...   \n",
       "4  Salvador Mendoza, Jr., of Washington, to be Un...   \n",
       "\n",
       "                                                vote               circuit  \\\n",
       "0  Latest Action: 08/04/2022 - Confirmed by the S...                 Ninth   \n",
       "1  Latest Action: 09/20/2022 - Confirmed by the S...  District of Columbia   \n",
       "2  Latest Action: 09/15/2022 - Confirmed by the S...                Second   \n",
       "3  Latest Action: 09/14/2022 - Confirmed by the S...                 First   \n",
       "4  Latest Action: 09/12/2022 - Confirmed by the S...                 Ninth   \n",
       "\n",
       "  confirmation_date  \n",
       "0        08/04/2022  \n",
       "1        09/20/2022  \n",
       "2        09/15/2022  \n",
       "3        09/14/2022  \n",
       "4        09/12/2022  "
      ]
     },
     "execution_count": 161,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['confirmation_date'] = df['vote'].str.extract('(\\d\\d\\W\\d\\d\\W\\d{4})', expand=False).str.strip()\n",
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [],
   "source": [
    "# I make a list out of the column vote so I can use regex on the information in the column. \n",
    "list_vote = df.vote.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "metadata": {},
   "outputs": [],
   "source": [
    "for list in list_vote:\n",
    "    try:\n",
    "        sub_regex = r\"Latest Action: \\d\\d\\W\\d\\d\\W\\d{4}.*(\\d\\d+) - (\\d*).*: (\\d+)[.].*\"\n",
    "        df.vote.str.split(sub_regex,expand=True)\n",
    "    except:\n",
    "        pass\n",
    "\n",
    "votes = df.vote.str.split(sub_regex,expand=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "name                  object\n",
       "nomination_no         object\n",
       "congress_no           object\n",
       "post                  object\n",
       "vote                  object\n",
       "circuit               object\n",
       "confirmation_date     object\n",
       "yea_votes             object\n",
       "nay_votes             object\n",
       "record_vote_number    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 164,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"yea_votes\"]= votes[1]\n",
    "df[\"nay_votes\"]= votes[2]\n",
    "df[\"record_vote_number\"]= votes[3]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I realized that the regex, in the rare cases where a judges was confirmed with 100 yea votes, has cut the number to two digits. Thus, I have to replace the 00 with 100 in the yea column. No judge will ever be confirmed with 00 votes, so it won't mess up the rest of the data. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>nomination_no</th>\n",
       "      <th>congress_no</th>\n",
       "      <th>post</th>\n",
       "      <th>vote</th>\n",
       "      <th>circuit</th>\n",
       "      <th>confirmation_date</th>\n",
       "      <th>yea_votes</th>\n",
       "      <th>nay_votes</th>\n",
       "      <th>record_vote_number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Kimberly Ann Moore</td>\n",
       "      <td>PN1594</td>\n",
       "      <td>109</td>\n",
       "      <td>Kimberly Ann Moore, of Virginia, to be United ...</td>\n",
       "      <td>Latest Action: 09/05/2006 - Confirmed by the S...</td>\n",
       "      <td>Federal</td>\n",
       "      <td>09/05/2006</td>\n",
       "      <td>92</td>\n",
       "      <td>0</td>\n",
       "      <td>231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>Bobby E. Shepherd</td>\n",
       "      <td>PN1593</td>\n",
       "      <td>109</td>\n",
       "      <td>Bobby E. Shepherd, of Arkansas, to be United S...</td>\n",
       "      <td>Latest Action: 07/20/2006 - Confirmed by the S...</td>\n",
       "      <td>Eighth</td>\n",
       "      <td>07/20/2006</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Neil M. Gorsuch</td>\n",
       "      <td>PN1565</td>\n",
       "      <td>109</td>\n",
       "      <td>Neil M. Gorsuch, of Colorado, to be United Sta...</td>\n",
       "      <td>Latest Action: 07/20/2006 - Confirmed by the S...</td>\n",
       "      <td>Tenth</td>\n",
       "      <td>07/20/2006</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>Jerome A. Holmes</td>\n",
       "      <td>PN1536</td>\n",
       "      <td>109</td>\n",
       "      <td>Jerome A. Holmes, of Oklahoma, to be United St...</td>\n",
       "      <td>Latest Action: 07/25/2006 - Confirmed by the S...</td>\n",
       "      <td>Tenth</td>\n",
       "      <td>07/25/2006</td>\n",
       "      <td>67</td>\n",
       "      <td>30</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Milan D. Smith Jr.</td>\n",
       "      <td>PN1327</td>\n",
       "      <td>109</td>\n",
       "      <td>Milan D. Smith, Jr., of California, to be Unit...</td>\n",
       "      <td>Latest Action: 05/16/2006 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>05/16/2006</td>\n",
       "      <td>93</td>\n",
       "      <td>0</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>Sandra Segal Ikuta</td>\n",
       "      <td>PN1296</td>\n",
       "      <td>109</td>\n",
       "      <td>Sandra Segal Ikuta, of California, to be Unite...</td>\n",
       "      <td>Latest Action: 06/19/2006 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>06/19/2006</td>\n",
       "      <td>81</td>\n",
       "      <td>0</td>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>Michael A. Chagares</td>\n",
       "      <td>PN1180</td>\n",
       "      <td>109</td>\n",
       "      <td>Michael A. Chagares, of New Jersey, to be Unit...</td>\n",
       "      <td>Latest Action: 04/04/2006 - Confirmed by the S...</td>\n",
       "      <td>Third</td>\n",
       "      <td>04/04/2006</td>\n",
       "      <td>98</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>Brett M. Kavanaugh</td>\n",
       "      <td>PN1179</td>\n",
       "      <td>109</td>\n",
       "      <td>Brett M. Kavanaugh, of Maryland, to be United ...</td>\n",
       "      <td>Latest Action: 05/26/2006 - Confirmed by the S...</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>05/26/2006</td>\n",
       "      <td>57</td>\n",
       "      <td>36</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>Thomas B. Griffith</td>\n",
       "      <td>PN202</td>\n",
       "      <td>109</td>\n",
       "      <td>Thomas B. Griffith, of Utah, to be United Stat...</td>\n",
       "      <td>Latest Action: 06/14/2005 - Confirmed by the S...</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>06/14/2005</td>\n",
       "      <td>73</td>\n",
       "      <td>24</td>\n",
       "      <td>136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>Janice R. Brown</td>\n",
       "      <td>PN201</td>\n",
       "      <td>109</td>\n",
       "      <td>Janice R. Brown, of California, to be United S...</td>\n",
       "      <td>Latest Action: 06/08/2005 - Confirmed by the S...</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>06/08/2005</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>William H. Pryor Jr.</td>\n",
       "      <td>PN200</td>\n",
       "      <td>109</td>\n",
       "      <td>William H. Pryor, Jr., of Alabama, to be Unite...</td>\n",
       "      <td>Latest Action: 06/09/2005 - Confirmed by the S...</td>\n",
       "      <td>Eleventh</td>\n",
       "      <td>06/09/2005</td>\n",
       "      <td>53</td>\n",
       "      <td>45</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>Susan Bieke Neilson</td>\n",
       "      <td>PN197</td>\n",
       "      <td>109</td>\n",
       "      <td>Susan Bieke Neilson, of Michigan, to be United...</td>\n",
       "      <td>Latest Action: 10/27/2005 - Confirmed by the S...</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>10/27/2005</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>David W. McKeague</td>\n",
       "      <td>PN196</td>\n",
       "      <td>109</td>\n",
       "      <td>David W. McKeague, of Michigan, to be United S...</td>\n",
       "      <td>Latest Action: 06/09/2005 - Confirmed by the S...</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>06/09/2005</td>\n",
       "      <td>96</td>\n",
       "      <td>0</td>\n",
       "      <td>135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Richard A. Griffin</td>\n",
       "      <td>PN195</td>\n",
       "      <td>109</td>\n",
       "      <td>Richard A. Griffin, of Michigan, to be United ...</td>\n",
       "      <td>Latest Action: 06/09/2005 - Confirmed by the S...</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>06/09/2005</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>Priscilla Richman Owen</td>\n",
       "      <td>PN194</td>\n",
       "      <td>109</td>\n",
       "      <td>Priscilla Richman Owen, of Texas, to be United...</td>\n",
       "      <td>Latest Action: 05/25/2005 - Confirmed by the S...</td>\n",
       "      <td>Fifth</td>\n",
       "      <td>05/25/2005</td>\n",
       "      <td>55</td>\n",
       "      <td>43</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>William Duane Benton</td>\n",
       "      <td>PN1369</td>\n",
       "      <td>108</td>\n",
       "      <td>William Duane Benton, of Missouri, to be Unite...</td>\n",
       "      <td>Latest Action: 06/24/2004 - Confirmed by the S...</td>\n",
       "      <td>Eighth</td>\n",
       "      <td>06/24/2004</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Peter W. Hall</td>\n",
       "      <td>PN1195</td>\n",
       "      <td>108</td>\n",
       "      <td>Peter W. Hall, of Vermont, to be United States...</td>\n",
       "      <td>Latest Action: 06/24/2004 - Confirmed by the S...</td>\n",
       "      <td>Second</td>\n",
       "      <td>06/24/2004</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>Franklin S. Van Antwerpen</td>\n",
       "      <td>PN1164</td>\n",
       "      <td>108</td>\n",
       "      <td>Franklin S. Van Antwerpen, of Pennsylvania, to...</td>\n",
       "      <td>Latest Action: 05/20/2004 - Confirmed by the S...</td>\n",
       "      <td>Third</td>\n",
       "      <td>05/20/2004</td>\n",
       "      <td>96</td>\n",
       "      <td>0</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>Diane S. Sykes</td>\n",
       "      <td>PN1109</td>\n",
       "      <td>108</td>\n",
       "      <td>Diane S. Sykes, of Wisconsin, to be United Sta...</td>\n",
       "      <td>Latest Action: 06/24/2004 - Confirmed by the S...</td>\n",
       "      <td>Seventh</td>\n",
       "      <td>06/24/2004</td>\n",
       "      <td>70</td>\n",
       "      <td>27</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Raymond W. Gruender</td>\n",
       "      <td>PN975</td>\n",
       "      <td>108</td>\n",
       "      <td>Raymond W. Gruender, of Missouri, to be United...</td>\n",
       "      <td>Latest Action: 05/20/2004 - Confirmed by the S...</td>\n",
       "      <td>Eighth</td>\n",
       "      <td>05/20/2004</td>\n",
       "      <td>97</td>\n",
       "      <td>1</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>D. Michael Fisher</td>\n",
       "      <td>PN570</td>\n",
       "      <td>108</td>\n",
       "      <td>D. Michael Fisher, of Pennsylvania, to be Unit...</td>\n",
       "      <td>Latest Action: 12/09/2003 - Confirmed by the S...</td>\n",
       "      <td>Third</td>\n",
       "      <td>12/09/2003</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>Allyson K. Duncan</td>\n",
       "      <td>PN533</td>\n",
       "      <td>108</td>\n",
       "      <td>Allyson K. Duncan, of North Carolina, to be Un...</td>\n",
       "      <td>Latest Action: 07/17/2003 - Confirmed by the S...</td>\n",
       "      <td>Fourth</td>\n",
       "      <td>07/17/2003</td>\n",
       "      <td>93</td>\n",
       "      <td>0</td>\n",
       "      <td>289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>Carlos T. Bea</td>\n",
       "      <td>PN523</td>\n",
       "      <td>108</td>\n",
       "      <td>Carlos T. Bea, of California, to be United Sta...</td>\n",
       "      <td>Latest Action: 09/29/2003 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>09/29/2003</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Richard C. Wesley</td>\n",
       "      <td>PN395</td>\n",
       "      <td>108</td>\n",
       "      <td>Richard C. Wesley, of New York, to be United S...</td>\n",
       "      <td>Latest Action: 06/11/2003 - Confirmed by the S...</td>\n",
       "      <td>Second</td>\n",
       "      <td>06/11/2003</td>\n",
       "      <td>96</td>\n",
       "      <td>0</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Michael Chertoff</td>\n",
       "      <td>PN394</td>\n",
       "      <td>108</td>\n",
       "      <td>Michael Chertoff, of New Jersey, to be United ...</td>\n",
       "      <td>Latest Action: 06/09/2003 - Confirmed by the S...</td>\n",
       "      <td>Third</td>\n",
       "      <td>06/09/2003</td>\n",
       "      <td>88</td>\n",
       "      <td>1</td>\n",
       "      <td>211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Steven M. Colloton</td>\n",
       "      <td>PN343</td>\n",
       "      <td>108</td>\n",
       "      <td>Steven M. Colloton, of Iowa, to be United Stat...</td>\n",
       "      <td>Latest Action: 09/04/2003 - Confirmed by the S...</td>\n",
       "      <td>Eighth</td>\n",
       "      <td>09/04/2003</td>\n",
       "      <td>94</td>\n",
       "      <td>1</td>\n",
       "      <td>327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Consuelo Maria Callahan</td>\n",
       "      <td>PN342</td>\n",
       "      <td>108</td>\n",
       "      <td>Consuelo Maria Callahan, of California, to be ...</td>\n",
       "      <td>Latest Action: 05/22/2003 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>05/22/2003</td>\n",
       "      <td>99</td>\n",
       "      <td>0</td>\n",
       "      <td>195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Edward C. Prado</td>\n",
       "      <td>PN295</td>\n",
       "      <td>108</td>\n",
       "      <td>Edward C. Prado, of Texas, to be United States...</td>\n",
       "      <td>Latest Action: 05/01/2003 - Confirmed by the S...</td>\n",
       "      <td>Fifth</td>\n",
       "      <td>05/01/2003</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>Timothy M. Tymkovich</td>\n",
       "      <td>PN16</td>\n",
       "      <td>108</td>\n",
       "      <td>Timothy M. Tymkovich, of Colorado, to be Unite...</td>\n",
       "      <td>Latest Action: 04/01/2003 - Confirmed by the S...</td>\n",
       "      <td>Tenth</td>\n",
       "      <td>04/01/2003</td>\n",
       "      <td>58</td>\n",
       "      <td>41</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>Jeffrey S. Sutton</td>\n",
       "      <td>PN15</td>\n",
       "      <td>108</td>\n",
       "      <td>Jeffrey S. Sutton, of Ohio, to be United State...</td>\n",
       "      <td>Latest Action: 04/29/2003 - Confirmed by the S...</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>04/29/2003</td>\n",
       "      <td>52</td>\n",
       "      <td>41</td>\n",
       "      <td>135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>John G. Roberts Jr.</td>\n",
       "      <td>PN13</td>\n",
       "      <td>108</td>\n",
       "      <td>John G. Roberts, Jr., of Maryland, to be Unite...</td>\n",
       "      <td>Latest Action: 05/08/2003 - Confirmed by the S...</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>05/08/2003</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>Deborah L. Cook</td>\n",
       "      <td>PN5</td>\n",
       "      <td>108</td>\n",
       "      <td>Deborah L. Cook, of Ohio, to be United States ...</td>\n",
       "      <td>Latest Action: 05/05/2003 - Confirmed by the S...</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>05/05/2003</td>\n",
       "      <td>66</td>\n",
       "      <td>25</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Jay S. Bybee</td>\n",
       "      <td>PN4</td>\n",
       "      <td>108</td>\n",
       "      <td>Jay S. Bybee, of Nevada, to be United States C...</td>\n",
       "      <td>Latest Action: 03/13/2003 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>03/13/2003</td>\n",
       "      <td>74</td>\n",
       "      <td>19</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Reena Raggi</td>\n",
       "      <td>PN1713</td>\n",
       "      <td>107</td>\n",
       "      <td>Reena Raggi, of New York, to be United States ...</td>\n",
       "      <td>Latest Action: 09/20/2002 - Confirmed by the S...</td>\n",
       "      <td>Second</td>\n",
       "      <td>09/20/2002</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>John M. Rogers</td>\n",
       "      <td>PN1300</td>\n",
       "      <td>107</td>\n",
       "      <td>John M. Rogers, of Kentucky, to be United Stat...</td>\n",
       "      <td>Latest Action: 11/14/2002 - Confirmed by the S...</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>11/14/2002</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Julia Smith Gibbons</td>\n",
       "      <td>PN1115</td>\n",
       "      <td>107</td>\n",
       "      <td>Julia Smith Gibbons, of Tennessee, to be Unite...</td>\n",
       "      <td>Latest Action: 07/29/2002 - Confirmed by the S...</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>07/29/2002</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>D. Brooks Smith</td>\n",
       "      <td>PN1005</td>\n",
       "      <td>107</td>\n",
       "      <td>D. Brooks Smith, of Pennsylvania, to be United...</td>\n",
       "      <td>Latest Action: 07/31/2002 - Confirmed by the S...</td>\n",
       "      <td>Third</td>\n",
       "      <td>07/31/2002</td>\n",
       "      <td>64</td>\n",
       "      <td>35</td>\n",
       "      <td>202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Jeffrey R. Howard</td>\n",
       "      <td>PN898</td>\n",
       "      <td>107</td>\n",
       "      <td>Jeffrey R. Howard, of New Hampshire, to be Uni...</td>\n",
       "      <td>Latest Action: 04/23/2002 - Confirmed by the S...</td>\n",
       "      <td>First</td>\n",
       "      <td>04/23/2002</td>\n",
       "      <td>99</td>\n",
       "      <td>0</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>Harris L. Hartz</td>\n",
       "      <td>PN897</td>\n",
       "      <td>107</td>\n",
       "      <td>Harris L. Hartz, of New Mexico, to be United S...</td>\n",
       "      <td>Latest Action: 12/06/2001 - Confirmed by the S...</td>\n",
       "      <td>Tenth</td>\n",
       "      <td>12/06/2001</td>\n",
       "      <td>99</td>\n",
       "      <td>0</td>\n",
       "      <td>353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Richard R. Clifton</td>\n",
       "      <td>PN894</td>\n",
       "      <td>107</td>\n",
       "      <td>Richard R. Clifton, of Hawaii, to be United St...</td>\n",
       "      <td>Latest Action: 07/18/2002 - Confirmed by the S...</td>\n",
       "      <td>Ninth</td>\n",
       "      <td>07/18/2002</td>\n",
       "      <td>98</td>\n",
       "      <td>0</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Edith Brown Clement</td>\n",
       "      <td>PN893</td>\n",
       "      <td>107</td>\n",
       "      <td>Edith Brown Clement, of Louisiana, to be Unite...</td>\n",
       "      <td>Latest Action: 11/13/2001 - Confirmed by the S...</td>\n",
       "      <td>Fifth</td>\n",
       "      <td>11/13/2001</td>\n",
       "      <td>99</td>\n",
       "      <td>0</td>\n",
       "      <td>335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Lavenski R. Smith</td>\n",
       "      <td>PN889</td>\n",
       "      <td>107</td>\n",
       "      <td>Lavenski R. Smith, of Arkansas, to be United S...</td>\n",
       "      <td>Latest Action: 07/15/2002 - Confirmed by the S...</td>\n",
       "      <td>Eighth</td>\n",
       "      <td>07/15/2002</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Dennis W. Shedd</td>\n",
       "      <td>PN888</td>\n",
       "      <td>107</td>\n",
       "      <td>Dennis W. Shedd, of South Carolina, to be Unit...</td>\n",
       "      <td>Latest Action: 11/19/2002 - Confirmed by the S...</td>\n",
       "      <td>Fourth</td>\n",
       "      <td>11/19/2002</td>\n",
       "      <td>55</td>\n",
       "      <td>44</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>Sharon Prost</td>\n",
       "      <td>PN886</td>\n",
       "      <td>107</td>\n",
       "      <td>Sharon Prost, of the District of Columbia, to ...</td>\n",
       "      <td>Latest Action: 09/21/2001 - Confirmed by the S...</td>\n",
       "      <td>Federal</td>\n",
       "      <td>09/21/2001</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Barrington D. Parker</td>\n",
       "      <td>PN884</td>\n",
       "      <td>107</td>\n",
       "      <td>Barrington D. Parker, of Connecticut, to be Un...</td>\n",
       "      <td>Latest Action: 10/11/2001 - Confirmed by the S...</td>\n",
       "      <td>Second</td>\n",
       "      <td>10/11/2001</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Terrence L. O'Brien</td>\n",
       "      <td>PN882</td>\n",
       "      <td>107</td>\n",
       "      <td>Terrence L. O'Brien, of Wyoming, to be United ...</td>\n",
       "      <td>Latest Action: 04/15/2002 - Confirmed by the S...</td>\n",
       "      <td>Tenth</td>\n",
       "      <td>04/15/2002</td>\n",
       "      <td>98</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>Michael J. Melloy</td>\n",
       "      <td>PN881</td>\n",
       "      <td>107</td>\n",
       "      <td>Michael J. Melloy, of Iowa, to be United State...</td>\n",
       "      <td>Latest Action: 02/11/2002 - Confirmed by the S...</td>\n",
       "      <td>Eighth</td>\n",
       "      <td>02/11/2002</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Michael W. McConnell</td>\n",
       "      <td>PN880</td>\n",
       "      <td>107</td>\n",
       "      <td>Michael W. McConnell, of Utah, to be United St...</td>\n",
       "      <td>Latest Action: 11/15/2002 - Confirmed by the S...</td>\n",
       "      <td>Tenth</td>\n",
       "      <td>11/15/2002</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>William J. Riley</td>\n",
       "      <td>PN458</td>\n",
       "      <td>107</td>\n",
       "      <td>William J. Riley, of Nebraska, to be United St...</td>\n",
       "      <td>Latest Action: 08/02/2001 - Confirmed by the S...</td>\n",
       "      <td>Eighth</td>\n",
       "      <td>08/02/2001</td>\n",
       "      <td>97</td>\n",
       "      <td>0</td>\n",
       "      <td>270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>Roger L. Gregory</td>\n",
       "      <td>PN402</td>\n",
       "      <td>107</td>\n",
       "      <td>Roger L. Gregory, of Virginia, to be United St...</td>\n",
       "      <td>Latest Action: 07/20/2001 - Confirmed by the S...</td>\n",
       "      <td>Fourth</td>\n",
       "      <td>07/20/2001</td>\n",
       "      <td>93</td>\n",
       "      <td>1</td>\n",
       "      <td>244</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          name nomination_no congress_no  \\\n",
       "144         Kimberly Ann Moore        PN1594         109   \n",
       "145          Bobby E. Shepherd        PN1593         109   \n",
       "146            Neil M. Gorsuch        PN1565         109   \n",
       "147           Jerome A. Holmes        PN1536         109   \n",
       "148         Milan D. Smith Jr.        PN1327         109   \n",
       "149         Sandra Segal Ikuta        PN1296         109   \n",
       "150        Michael A. Chagares        PN1180         109   \n",
       "151         Brett M. Kavanaugh        PN1179         109   \n",
       "152         Thomas B. Griffith         PN202         109   \n",
       "153            Janice R. Brown         PN201         109   \n",
       "154       William H. Pryor Jr.         PN200         109   \n",
       "155        Susan Bieke Neilson         PN197         109   \n",
       "156          David W. McKeague         PN196         109   \n",
       "157         Richard A. Griffin         PN195         109   \n",
       "158     Priscilla Richman Owen         PN194         109   \n",
       "159       William Duane Benton        PN1369         108   \n",
       "160              Peter W. Hall        PN1195         108   \n",
       "161  Franklin S. Van Antwerpen        PN1164         108   \n",
       "162             Diane S. Sykes        PN1109         108   \n",
       "163        Raymond W. Gruender         PN975         108   \n",
       "164          D. Michael Fisher         PN570         108   \n",
       "165          Allyson K. Duncan         PN533         108   \n",
       "166              Carlos T. Bea         PN523         108   \n",
       "167          Richard C. Wesley         PN395         108   \n",
       "168           Michael Chertoff         PN394         108   \n",
       "169         Steven M. Colloton         PN343         108   \n",
       "170    Consuelo Maria Callahan         PN342         108   \n",
       "171            Edward C. Prado         PN295         108   \n",
       "172       Timothy M. Tymkovich          PN16         108   \n",
       "173          Jeffrey S. Sutton          PN15         108   \n",
       "174        John G. Roberts Jr.          PN13         108   \n",
       "175            Deborah L. Cook           PN5         108   \n",
       "176               Jay S. Bybee           PN4         108   \n",
       "177                Reena Raggi        PN1713         107   \n",
       "178             John M. Rogers        PN1300         107   \n",
       "179        Julia Smith Gibbons        PN1115         107   \n",
       "180            D. Brooks Smith        PN1005         107   \n",
       "181          Jeffrey R. Howard         PN898         107   \n",
       "182            Harris L. Hartz         PN897         107   \n",
       "183         Richard R. Clifton         PN894         107   \n",
       "184        Edith Brown Clement         PN893         107   \n",
       "185          Lavenski R. Smith         PN889         107   \n",
       "186            Dennis W. Shedd         PN888         107   \n",
       "187               Sharon Prost         PN886         107   \n",
       "188       Barrington D. Parker         PN884         107   \n",
       "189        Terrence L. O'Brien         PN882         107   \n",
       "190          Michael J. Melloy         PN881         107   \n",
       "191       Michael W. McConnell         PN880         107   \n",
       "192           William J. Riley         PN458         107   \n",
       "193           Roger L. Gregory         PN402         107   \n",
       "\n",
       "                                                  post  \\\n",
       "144  Kimberly Ann Moore, of Virginia, to be United ...   \n",
       "145  Bobby E. Shepherd, of Arkansas, to be United S...   \n",
       "146  Neil M. Gorsuch, of Colorado, to be United Sta...   \n",
       "147  Jerome A. Holmes, of Oklahoma, to be United St...   \n",
       "148  Milan D. Smith, Jr., of California, to be Unit...   \n",
       "149  Sandra Segal Ikuta, of California, to be Unite...   \n",
       "150  Michael A. Chagares, of New Jersey, to be Unit...   \n",
       "151  Brett M. Kavanaugh, of Maryland, to be United ...   \n",
       "152  Thomas B. Griffith, of Utah, to be United Stat...   \n",
       "153  Janice R. Brown, of California, to be United S...   \n",
       "154  William H. Pryor, Jr., of Alabama, to be Unite...   \n",
       "155  Susan Bieke Neilson, of Michigan, to be United...   \n",
       "156  David W. McKeague, of Michigan, to be United S...   \n",
       "157  Richard A. Griffin, of Michigan, to be United ...   \n",
       "158  Priscilla Richman Owen, of Texas, to be United...   \n",
       "159  William Duane Benton, of Missouri, to be Unite...   \n",
       "160  Peter W. Hall, of Vermont, to be United States...   \n",
       "161  Franklin S. Van Antwerpen, of Pennsylvania, to...   \n",
       "162  Diane S. Sykes, of Wisconsin, to be United Sta...   \n",
       "163  Raymond W. Gruender, of Missouri, to be United...   \n",
       "164  D. Michael Fisher, of Pennsylvania, to be Unit...   \n",
       "165  Allyson K. Duncan, of North Carolina, to be Un...   \n",
       "166  Carlos T. Bea, of California, to be United Sta...   \n",
       "167  Richard C. Wesley, of New York, to be United S...   \n",
       "168  Michael Chertoff, of New Jersey, to be United ...   \n",
       "169  Steven M. Colloton, of Iowa, to be United Stat...   \n",
       "170  Consuelo Maria Callahan, of California, to be ...   \n",
       "171  Edward C. Prado, of Texas, to be United States...   \n",
       "172  Timothy M. Tymkovich, of Colorado, to be Unite...   \n",
       "173  Jeffrey S. Sutton, of Ohio, to be United State...   \n",
       "174  John G. Roberts, Jr., of Maryland, to be Unite...   \n",
       "175  Deborah L. Cook, of Ohio, to be United States ...   \n",
       "176  Jay S. Bybee, of Nevada, to be United States C...   \n",
       "177  Reena Raggi, of New York, to be United States ...   \n",
       "178  John M. Rogers, of Kentucky, to be United Stat...   \n",
       "179  Julia Smith Gibbons, of Tennessee, to be Unite...   \n",
       "180  D. Brooks Smith, of Pennsylvania, to be United...   \n",
       "181  Jeffrey R. Howard, of New Hampshire, to be Uni...   \n",
       "182  Harris L. Hartz, of New Mexico, to be United S...   \n",
       "183  Richard R. Clifton, of Hawaii, to be United St...   \n",
       "184  Edith Brown Clement, of Louisiana, to be Unite...   \n",
       "185  Lavenski R. Smith, of Arkansas, to be United S...   \n",
       "186  Dennis W. Shedd, of South Carolina, to be Unit...   \n",
       "187  Sharon Prost, of the District of Columbia, to ...   \n",
       "188  Barrington D. Parker, of Connecticut, to be Un...   \n",
       "189  Terrence L. O'Brien, of Wyoming, to be United ...   \n",
       "190  Michael J. Melloy, of Iowa, to be United State...   \n",
       "191  Michael W. McConnell, of Utah, to be United St...   \n",
       "192  William J. Riley, of Nebraska, to be United St...   \n",
       "193  Roger L. Gregory, of Virginia, to be United St...   \n",
       "\n",
       "                                                  vote               circuit  \\\n",
       "144  Latest Action: 09/05/2006 - Confirmed by the S...               Federal   \n",
       "145  Latest Action: 07/20/2006 - Confirmed by the S...                Eighth   \n",
       "146  Latest Action: 07/20/2006 - Confirmed by the S...                 Tenth   \n",
       "147  Latest Action: 07/25/2006 - Confirmed by the S...                 Tenth   \n",
       "148  Latest Action: 05/16/2006 - Confirmed by the S...                 Ninth   \n",
       "149  Latest Action: 06/19/2006 - Confirmed by the S...                 Ninth   \n",
       "150  Latest Action: 04/04/2006 - Confirmed by the S...                 Third   \n",
       "151  Latest Action: 05/26/2006 - Confirmed by the S...  District of Columbia   \n",
       "152  Latest Action: 06/14/2005 - Confirmed by the S...  District of Columbia   \n",
       "153  Latest Action: 06/08/2005 - Confirmed by the S...  District of Columbia   \n",
       "154  Latest Action: 06/09/2005 - Confirmed by the S...              Eleventh   \n",
       "155  Latest Action: 10/27/2005 - Confirmed by the S...                 Sixth   \n",
       "156  Latest Action: 06/09/2005 - Confirmed by the S...                 Sixth   \n",
       "157  Latest Action: 06/09/2005 - Confirmed by the S...                 Sixth   \n",
       "158  Latest Action: 05/25/2005 - Confirmed by the S...                 Fifth   \n",
       "159  Latest Action: 06/24/2004 - Confirmed by the S...                Eighth   \n",
       "160  Latest Action: 06/24/2004 - Confirmed by the S...                Second   \n",
       "161  Latest Action: 05/20/2004 - Confirmed by the S...                 Third   \n",
       "162  Latest Action: 06/24/2004 - Confirmed by the S...               Seventh   \n",
       "163  Latest Action: 05/20/2004 - Confirmed by the S...                Eighth   \n",
       "164  Latest Action: 12/09/2003 - Confirmed by the S...                 Third   \n",
       "165  Latest Action: 07/17/2003 - Confirmed by the S...                Fourth   \n",
       "166  Latest Action: 09/29/2003 - Confirmed by the S...                 Ninth   \n",
       "167  Latest Action: 06/11/2003 - Confirmed by the S...                Second   \n",
       "168  Latest Action: 06/09/2003 - Confirmed by the S...                 Third   \n",
       "169  Latest Action: 09/04/2003 - Confirmed by the S...                Eighth   \n",
       "170  Latest Action: 05/22/2003 - Confirmed by the S...                 Ninth   \n",
       "171  Latest Action: 05/01/2003 - Confirmed by the S...                 Fifth   \n",
       "172  Latest Action: 04/01/2003 - Confirmed by the S...                 Tenth   \n",
       "173  Latest Action: 04/29/2003 - Confirmed by the S...                 Sixth   \n",
       "174  Latest Action: 05/08/2003 - Confirmed by the S...  District of Columbia   \n",
       "175  Latest Action: 05/05/2003 - Confirmed by the S...                 Sixth   \n",
       "176  Latest Action: 03/13/2003 - Confirmed by the S...                 Ninth   \n",
       "177  Latest Action: 09/20/2002 - Confirmed by the S...                Second   \n",
       "178  Latest Action: 11/14/2002 - Confirmed by the S...                 Sixth   \n",
       "179  Latest Action: 07/29/2002 - Confirmed by the S...                 Sixth   \n",
       "180  Latest Action: 07/31/2002 - Confirmed by the S...                 Third   \n",
       "181  Latest Action: 04/23/2002 - Confirmed by the S...                 First   \n",
       "182  Latest Action: 12/06/2001 - Confirmed by the S...                 Tenth   \n",
       "183  Latest Action: 07/18/2002 - Confirmed by the S...                 Ninth   \n",
       "184  Latest Action: 11/13/2001 - Confirmed by the S...                 Fifth   \n",
       "185  Latest Action: 07/15/2002 - Confirmed by the S...                Eighth   \n",
       "186  Latest Action: 11/19/2002 - Confirmed by the S...                Fourth   \n",
       "187  Latest Action: 09/21/2001 - Confirmed by the S...               Federal   \n",
       "188  Latest Action: 10/11/2001 - Confirmed by the S...                Second   \n",
       "189  Latest Action: 04/15/2002 - Confirmed by the S...                 Tenth   \n",
       "190  Latest Action: 02/11/2002 - Confirmed by the S...                Eighth   \n",
       "191  Latest Action: 11/15/2002 - Confirmed by the S...                 Tenth   \n",
       "192  Latest Action: 08/02/2001 - Confirmed by the S...                Eighth   \n",
       "193  Latest Action: 07/20/2001 - Confirmed by the S...                Fourth   \n",
       "\n",
       "    confirmation_date yea_votes nay_votes record_vote_number  \n",
       "144        09/05/2006        92         0                231  \n",
       "145        07/20/2006      None      None               None  \n",
       "146        07/20/2006      None      None               None  \n",
       "147        07/25/2006        67        30                213  \n",
       "148        05/16/2006        93         0                120  \n",
       "149        06/19/2006        81         0                175  \n",
       "150        04/04/2006        98         0                 86  \n",
       "151        05/26/2006        57        36                159  \n",
       "152        06/14/2005        73        24                136  \n",
       "153        06/08/2005      None      None               None  \n",
       "154        06/09/2005        53        45                133  \n",
       "155        10/27/2005        97         0                277  \n",
       "156        06/09/2005        96         0                135  \n",
       "157        06/09/2005        95         0                134  \n",
       "158        05/25/2005        55        43                128  \n",
       "159        06/24/2004      None      None               None  \n",
       "160        06/24/2004      None      None               None  \n",
       "161        05/20/2004        96         0                103  \n",
       "162        06/24/2004        70        27                152  \n",
       "163        05/20/2004        97         1                102  \n",
       "164        12/09/2003      None      None               None  \n",
       "165        07/17/2003        93         0                289  \n",
       "166        09/29/2003        86         0                368  \n",
       "167        06/11/2003        96         0                215  \n",
       "168        06/09/2003        88         1                211  \n",
       "169        09/04/2003        94         1                327  \n",
       "170        05/22/2003        99         0                195  \n",
       "171        05/01/2003        97         0                138  \n",
       "172        04/01/2003        58        41                113  \n",
       "173        04/29/2003        52        41                135  \n",
       "174        05/08/2003      None      None               None  \n",
       "175        05/05/2003        66        25                139  \n",
       "176        03/13/2003        74        19                 54  \n",
       "177        09/20/2002        85         0                219  \n",
       "178        11/14/2002      None      None               None  \n",
       "179        07/29/2002        95         0                194  \n",
       "180        07/31/2002        64        35                202  \n",
       "181        04/23/2002        99         0                 79  \n",
       "182        12/06/2001        99         0                353  \n",
       "183        07/18/2002        98         0                184  \n",
       "184        11/13/2001        99         0                335  \n",
       "185        07/15/2002      None      None               None  \n",
       "186        11/19/2002        55        44                250  \n",
       "187        09/21/2001        97         0                282  \n",
       "188        10/11/2001       100         0                297  \n",
       "189        04/15/2002        98         0                 68  \n",
       "190        02/11/2002        91         0                 21  \n",
       "191        11/15/2002      None      None               None  \n",
       "192        08/02/2001        97         0                270  \n",
       "193        07/20/2001        93         1                244  "
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[ df['yea_votes'] == \"00\", 'yea_votes'] = \"100\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = df.drop(['post', 'vote'], axis=1)\n",
    "\n",
    "data.to_csv(\"data/votes.csv\", index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.11.0rc2 64-bit ('3.11.0rc2')",
   "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.11.0"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "fa07e5dff76123542c28abca75c0e47ea742948dbeeb360ccfbd2a5c7c277f8b"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}