Act database.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import regex as re\n",
    "import numpy as np\n",
    "import os\n",
    "from os import listdir\n",
    "from os.path import isfile,join\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [],
   "source": [
    "files = []\n",
    "path = \"/Users/yuhanxie/Desktop/LA/textfiles/\"\n",
    "for i in os.listdir(path):\n",
    "    if i.endswith('.txt'):\n",
    "        text = open(path+i,encoding=\"utf8\").read()\n",
    "        files.append(text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1302"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(files)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "metadata": {},
   "outputs": [],
   "source": [
    "def unique(texts):\n",
    "    list(set(texts))\n",
    "#return a set of nonunique bill mentioned in the speech.\n",
    "def bill(texts):\n",
    "    no_num = re.sub('\\d+','',texts)\n",
    "    no_n = re.sub('\\n','',no_num)\n",
    "    evenly_spaced = re.sub('\\s+',' ',no_n)\n",
    "    r = re.findall(r'(([A-Z][a-z]+\\s)+Act)', evenly_spaced)\n",
    "    b = []\n",
    "    for i in range(len(r)):\n",
    "        b.append(r[i][0])\n",
    "    return b\n",
    "\n",
    "#return a set of unique bill mentioned in the speech.\n",
    "def unibill(texts):\n",
    "    return np.unique(bill(texts))\n",
    "#return the name and times it appears.\n",
    "def count(texts):\n",
    "    bills = bill(texts)\n",
    "    ret = []\n",
    "    for i in range(0,len(bills)):\n",
    "        count = bills.count(bills[i])\n",
    "        ret.append (str(bills[i]) + \" \" + \":\" + ' '+str(count))\n",
    "    return unique(ret)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 274,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaned = []\n",
    "for txt in files:\n",
    "    clean = re.sub('\\xad','',txt)\n",
    "    clean = re.sub('\\n','',clean)\n",
    "    clean = re.sub('\\\\\\\\','',clean)\n",
    "    cleaned += [clean]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 275,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Prison Litigation Reform Act',\n",
       "       'States Administrative Procedure Act'], dtype='<U35')"
      ]
     },
     "execution_count": 275,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unibill(cleaned[10])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 276,
   "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>Unnamed: 0</th>\n",
       "      <th>Title</th>\n",
       "      <th>Case No</th>\n",
       "      <th>Date</th>\n",
       "      <th>Bills Mentioned</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>14 Penn Plaza LLC v. Pyett</td>\n",
       "      <td>No. 07-581</td>\n",
       "      <td>December 1, 2008</td>\n",
       "      <td>['Labor Relations Act : 2', 'Labor Standards A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Abbott v. Perez</td>\n",
       "      <td>No. 17-586</td>\n",
       "      <td>April 24, 2018</td>\n",
       "      <td>['Voting Rights Act : 3']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Abbott v. United States</td>\n",
       "      <td>No. 09-479</td>\n",
       "      <td>October 4, 2010</td>\n",
       "      <td>['Career Criminal Act : 3']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Abdul-Kabir v. Quarterman</td>\n",
       "      <td>No. 05-11284</td>\n",
       "      <td>January 17, 2006</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Abdur_Rahman v. Bell</td>\n",
       "      <td>No. 01-9094</td>\n",
       "      <td>November 6, 2002</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Abramski v. United States</td>\n",
       "      <td>No. 121493</td>\n",
       "      <td>January 22, 2014</td>\n",
       "      <td>['Gun Control Act : 12', 'Owners Protection Ac...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Abuelhawa v. United States</td>\n",
       "      <td>No. 08-192</td>\n",
       "      <td>March 4, 2009</td>\n",
       "      <td>['The Travel Act : 1', 'Controlled Substances ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Adams v. Florida Power Corp.</td>\n",
       "      <td>No. 01-584</td>\n",
       "      <td>March 20, 2002</td>\n",
       "      <td>['Age Discrimination Act : 3', 'Civil Rights A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Adarand Constructors, Inc. v. Mineta</td>\n",
       "      <td>No. 00-730</td>\n",
       "      <td>October 31, 2001</td>\n",
       "      <td>['Small Business Act : 3']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>Adoptive Couple v. Baby Girl</td>\n",
       "      <td>No. 12-399</td>\n",
       "      <td>April 16, 2013</td>\n",
       "      <td>['Child Welfare Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Advocate Health Care Network v. Stapleton</td>\n",
       "      <td>No. 16-74</td>\n",
       "      <td>March 27, 2017</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Aetna Health Inc. v. Davila</td>\n",
       "      <td>No. 02-1845</td>\n",
       "      <td>March 23, 2004</td>\n",
       "      <td>['Management Relations Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Agency for Int_l Development v. Alliance for O...</td>\n",
       "      <td>No. 12-10</td>\n",
       "      <td>April 22, 2013</td>\n",
       "      <td>['Affordable Care Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Air Wisconsin Airlines Corp. v. Hoeper</td>\n",
       "      <td>No. 12315</td>\n",
       "      <td>December 9, 2013</td>\n",
       "      <td>['Transportation Security Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>Air _ Liquid Systems Corp. v. DeVries</td>\n",
       "      <td>No. 17-1104</td>\n",
       "      <td>October 10, 2018</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Alabama Dept. of Revenue v. CSX Transp., Inc.....</td>\n",
       "      <td>No. 13553</td>\n",
       "      <td>December 9, 2014</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Alabama Dept. of Revenue v. CSX Transp., Inc.</td>\n",
       "      <td>No. 13553</td>\n",
       "      <td>December 9, 2014</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Alabama Legislative Black Caucus v. Alabama</td>\n",
       "      <td>No. 13895</td>\n",
       "      <td>November 12, 2014</td>\n",
       "      <td>['Voting Rights Act : 3']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Alabama v. Bozeman</td>\n",
       "      <td>No. 00-492</td>\n",
       "      <td>April 17, 2001</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Alabama v. North Carolina</td>\n",
       "      <td>No. 132</td>\n",
       "      <td>January 11, 2010</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Alabama v. Shelton</td>\n",
       "      <td>No. 00-1214</td>\n",
       "      <td>February 19, 2002</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Alaska Dept. of Environmental Conservation v. EPA</td>\n",
       "      <td>No. 02-658</td>\n",
       "      <td>October 8, 2003</td>\n",
       "      <td>['Clean Air Act : 3']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Alaska v. United States</td>\n",
       "      <td>No. 128</td>\n",
       "      <td>January 10, 2005</td>\n",
       "      <td>['The Antiquities Act : 1', 'Submerged Lands A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Alexander v. Sandoval</td>\n",
       "      <td>No. 99-1908</td>\n",
       "      <td>January 16, 2001</td>\n",
       "      <td>['Voting Rights Act : 2', 'Civil Rights Act : ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Ali v. Federal Bureau of Prisons</td>\n",
       "      <td>No. 06-9130</td>\n",
       "      <td>October 29, 2007</td>\n",
       "      <td>['Tort Claims Act : 1', 'Federal Arbitration A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Alice Corp. v. CLS Bank Int’l</td>\n",
       "      <td>No. 13298</td>\n",
       "      <td>March 31, 2014</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Alleyne v. United States</td>\n",
       "      <td>No. 11-9335</td>\n",
       "      <td>January 14, 2013</td>\n",
       "      <td>['First Crimes Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>Allison Engine Co. v. United States Ex Rel. Sa...</td>\n",
       "      <td>No. 07-214</td>\n",
       "      <td>February 26, 2008</td>\n",
       "      <td>['False Claims Act : 14']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Already, LLC v. Nike, Inc.</td>\n",
       "      <td>No. 11-982</td>\n",
       "      <td>November 7, 2012</td>\n",
       "      <td>['Declaratory Judgment Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Altria Group, Inc. v. Good</td>\n",
       "      <td>No. 07-562</td>\n",
       "      <td>October 6, 2008</td>\n",
       "      <td>['Airline Deregulation Act : 1', 'Trade Commis...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1272</th>\n",
       "      <td>1272</td>\n",
       "      <td>Williams-Yulee v. Florida Bar</td>\n",
       "      <td>No. 131499</td>\n",
       "      <td>January 20, 2015</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1273</th>\n",
       "      <td>1273</td>\n",
       "      <td>Williamson v. Mazda Motor of America, Inc.</td>\n",
       "      <td>No. 08-1314</td>\n",
       "      <td>November 3, 2010</td>\n",
       "      <td>['Vehicle Safety Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1274</th>\n",
       "      <td>1274</td>\n",
       "      <td>Wilson v. Sellers</td>\n",
       "      <td>No. 16-6855</td>\n",
       "      <td>October 30, 2017</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1275</th>\n",
       "      <td>1275</td>\n",
       "      <td>Winkelman v. Parma City School Distr.</td>\n",
       "      <td>No. 05-98311</td>\n",
       "      <td>February 27, 2007</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1276</th>\n",
       "      <td>1276</td>\n",
       "      <td>Winter v. Natural Resources Defense Council, Inc.</td>\n",
       "      <td>No. 07-1239</td>\n",
       "      <td>October 8, 2008</td>\n",
       "      <td>['Mammal Protection Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1277</th>\n",
       "      <td>1277</td>\n",
       "      <td>Wisconsin Central Ltd. v. United States</td>\n",
       "      <td>No. 17-530</td>\n",
       "      <td>April 16, 2018</td>\n",
       "      <td>['Retirement Tax Act : 2']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1278</th>\n",
       "      <td>1278</td>\n",
       "      <td>Wisconsin Dept. of Health and Family Servs. v....</td>\n",
       "      <td>No. 00-952</td>\n",
       "      <td>December 3, 2001</td>\n",
       "      <td>['Federal Medicaid Act : 1', 'Catastrophic Cov...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1279</th>\n",
       "      <td>1279</td>\n",
       "      <td>Wisconsin Right to Life, Inc. v. Federal Elect...</td>\n",
       "      <td>No. 04-1581</td>\n",
       "      <td>January 17, 2006</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1280</th>\n",
       "      <td>1280</td>\n",
       "      <td>Wittman v. Personhuballah</td>\n",
       "      <td>No. 141504</td>\n",
       "      <td>March 21, 2016</td>\n",
       "      <td>['Voting Rights Act : 7']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1281</th>\n",
       "      <td>1281</td>\n",
       "      <td>Wood v. Allen</td>\n",
       "      <td>No. 08-9156</td>\n",
       "      <td>November 4, 2009</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1282</th>\n",
       "      <td>1282</td>\n",
       "      <td>Wood v. Milyard</td>\n",
       "      <td>No. 10-9995</td>\n",
       "      <td>February 27, 2012</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1283</th>\n",
       "      <td>1283</td>\n",
       "      <td>Wood v. Moss</td>\n",
       "      <td>No. 13115</td>\n",
       "      <td>March 26, 2014</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1284</th>\n",
       "      <td>1284</td>\n",
       "      <td>Woodford v. Garceau</td>\n",
       "      <td>No. 01-1862</td>\n",
       "      <td>January 21, 2003</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1285</th>\n",
       "      <td>1285</td>\n",
       "      <td>Woodford v. Ngo</td>\n",
       "      <td>No. 05-416</td>\n",
       "      <td>March 22, 2006</td>\n",
       "      <td>['Age Discrimination Act : 2', 'Litigation Ref...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1286</th>\n",
       "      <td>1286</td>\n",
       "      <td>Wyeth v. Levine</td>\n",
       "      <td>No. 06-1249</td>\n",
       "      <td>November 3, 2008</td>\n",
       "      <td>['Federal Drug Act : 1', 'Medical Device Act :...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1287</th>\n",
       "      <td>1287</td>\n",
       "      <td>Yarborough v. Alvarado</td>\n",
       "      <td>No. 02-1684</td>\n",
       "      <td>March 1, 2004</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1288</th>\n",
       "      <td>1288</td>\n",
       "      <td>Yates v. United States</td>\n",
       "      <td>No. 137451</td>\n",
       "      <td>November 5, 2014</td>\n",
       "      <td>['Oxley Grouper Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1289</th>\n",
       "      <td>1289</td>\n",
       "      <td>Yeager v. United States</td>\n",
       "      <td>No. 08-67</td>\n",
       "      <td>March 23, 2009</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1290</th>\n",
       "      <td>1290</td>\n",
       "      <td>Yellow Transp. Inc. v. Michigan, et al</td>\n",
       "      <td>No. 01-270</td>\n",
       "      <td>October 7, 2002</td>\n",
       "      <td>['Transportation Efficiency Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1291</th>\n",
       "      <td>1291</td>\n",
       "      <td>Young v. United Parcel Service, Inc.</td>\n",
       "      <td>No. 121226</td>\n",
       "      <td>December 3, 2014</td>\n",
       "      <td>['Civil Rights Act : 1', 'Pregnancy Discrimina...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1292</th>\n",
       "      <td>1292</td>\n",
       "      <td>Young v. United States</td>\n",
       "      <td>No. 00-1567</td>\n",
       "      <td>January 9, 2002</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1293</th>\n",
       "      <td>1293</td>\n",
       "      <td>Ysursa v. Pocatello Ed. Assn.</td>\n",
       "      <td>No. 07-869</td>\n",
       "      <td>November 3, 2008</td>\n",
       "      <td>['Federal Power Act : 1', 'Voluntary Contribut...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1294</th>\n",
       "      <td>1294</td>\n",
       "      <td>Zadvydas v. Underdown</td>\n",
       "      <td>No. 99-7791</td>\n",
       "      <td>February 21, 2001</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1295</th>\n",
       "      <td>1295</td>\n",
       "      <td>Zedner v. United States</td>\n",
       "      <td>No. 05-5992</td>\n",
       "      <td>April 18, 2006</td>\n",
       "      <td>['Speedy Trial Act : 14']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1296</th>\n",
       "      <td>1296</td>\n",
       "      <td>Zelman v. Simmons-Harris</td>\n",
       "      <td>No. 00-1751</td>\n",
       "      <td>February 20, 2002</td>\n",
       "      <td>['Community School Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1297</th>\n",
       "      <td>1297</td>\n",
       "      <td>Ziglar v. Abbasi</td>\n",
       "      <td>No. 15-1358</td>\n",
       "      <td>January 18, 2017</td>\n",
       "      <td>['Administrative Procedures Act : 1']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1298</th>\n",
       "      <td>1298</td>\n",
       "      <td>Zivotofsky v. Clinton</td>\n",
       "      <td>No. 10-699</td>\n",
       "      <td>November 7, 2011</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1299</th>\n",
       "      <td>1299</td>\n",
       "      <td>Zivotofsky v. Kerry</td>\n",
       "      <td>No. 13628</td>\n",
       "      <td>November 3, 2014</td>\n",
       "      <td>['Taiwan Relations Act : 2', 'Jerusalem Embass...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1300</th>\n",
       "      <td>1300</td>\n",
       "      <td>Zubik v. Burwell</td>\n",
       "      <td>No. 141418</td>\n",
       "      <td>March 23, 2016</td>\n",
       "      <td>['Affordable Care Act : 1', 'Freedom Restorati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1301</th>\n",
       "      <td>1301</td>\n",
       "      <td>Zuni Public School Dist. v. Department of Educ...</td>\n",
       "      <td>No. 05-1508</td>\n",
       "      <td>January 10, 2007</td>\n",
       "      <td>['Impact Aid Act : 4']</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1302 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                              Title  \\\n",
       "0              0                         14 Penn Plaza LLC v. Pyett   \n",
       "1              1                                    Abbott v. Perez   \n",
       "2              2                            Abbott v. United States   \n",
       "3              3                          Abdul-Kabir v. Quarterman   \n",
       "4              4                               Abdur_Rahman v. Bell   \n",
       "5              5                          Abramski v. United States   \n",
       "6              6                         Abuelhawa v. United States   \n",
       "7              7                       Adams v. Florida Power Corp.   \n",
       "8              8               Adarand Constructors, Inc. v. Mineta   \n",
       "9              9                       Adoptive Couple v. Baby Girl   \n",
       "10            10          Advocate Health Care Network v. Stapleton   \n",
       "11            11                        Aetna Health Inc. v. Davila   \n",
       "12            12  Agency for Int_l Development v. Alliance for O...   \n",
       "13            13             Air Wisconsin Airlines Corp. v. Hoeper   \n",
       "14            14              Air _ Liquid Systems Corp. v. DeVries   \n",
       "15            15  Alabama Dept. of Revenue v. CSX Transp., Inc.....   \n",
       "16            16      Alabama Dept. of Revenue v. CSX Transp., Inc.   \n",
       "17            17        Alabama Legislative Black Caucus v. Alabama   \n",
       "18            18                                 Alabama v. Bozeman   \n",
       "19            19                          Alabama v. North Carolina   \n",
       "20            20                                 Alabama v. Shelton   \n",
       "21            21  Alaska Dept. of Environmental Conservation v. EPA   \n",
       "22            22                            Alaska v. United States   \n",
       "23            23                              Alexander v. Sandoval   \n",
       "24            24                   Ali v. Federal Bureau of Prisons   \n",
       "25            25                      Alice Corp. v. CLS Bank Int’l   \n",
       "26            26                           Alleyne v. United States   \n",
       "27            27  Allison Engine Co. v. United States Ex Rel. Sa...   \n",
       "28            28                         Already, LLC v. Nike, Inc.   \n",
       "29            29                         Altria Group, Inc. v. Good   \n",
       "...          ...                                                ...   \n",
       "1272        1272                      Williams-Yulee v. Florida Bar   \n",
       "1273        1273         Williamson v. Mazda Motor of America, Inc.   \n",
       "1274        1274                                  Wilson v. Sellers   \n",
       "1275        1275              Winkelman v. Parma City School Distr.   \n",
       "1276        1276  Winter v. Natural Resources Defense Council, Inc.   \n",
       "1277        1277            Wisconsin Central Ltd. v. United States   \n",
       "1278        1278  Wisconsin Dept. of Health and Family Servs. v....   \n",
       "1279        1279  Wisconsin Right to Life, Inc. v. Federal Elect...   \n",
       "1280        1280                          Wittman v. Personhuballah   \n",
       "1281        1281                                      Wood v. Allen   \n",
       "1282        1282                                    Wood v. Milyard   \n",
       "1283        1283                                       Wood v. Moss   \n",
       "1284        1284                                Woodford v. Garceau   \n",
       "1285        1285                                    Woodford v. Ngo   \n",
       "1286        1286                                    Wyeth v. Levine   \n",
       "1287        1287                             Yarborough v. Alvarado   \n",
       "1288        1288                             Yates v. United States   \n",
       "1289        1289                            Yeager v. United States   \n",
       "1290        1290             Yellow Transp. Inc. v. Michigan, et al   \n",
       "1291        1291               Young v. United Parcel Service, Inc.   \n",
       "1292        1292                             Young v. United States   \n",
       "1293        1293                      Ysursa v. Pocatello Ed. Assn.   \n",
       "1294        1294                              Zadvydas v. Underdown   \n",
       "1295        1295                            Zedner v. United States   \n",
       "1296        1296                           Zelman v. Simmons-Harris   \n",
       "1297        1297                                   Ziglar v. Abbasi   \n",
       "1298        1298                              Zivotofsky v. Clinton   \n",
       "1299        1299                                Zivotofsky v. Kerry   \n",
       "1300        1300                                   Zubik v. Burwell   \n",
       "1301        1301  Zuni Public School Dist. v. Department of Educ...   \n",
       "\n",
       "           Case No                Date  \\\n",
       "0       No. 07-581    December 1, 2008   \n",
       "1       No. 17-586      April 24, 2018   \n",
       "2       No. 09-479     October 4, 2010   \n",
       "3     No. 05-11284    January 17, 2006   \n",
       "4      No. 01-9094    November 6, 2002   \n",
       "5       No. 121493    January 22, 2014   \n",
       "6       No. 08-192       March 4, 2009   \n",
       "7       No. 01-584      March 20, 2002   \n",
       "8       No. 00-730    October 31, 2001   \n",
       "9       No. 12-399      April 16, 2013   \n",
       "10       No. 16-74      March 27, 2017   \n",
       "11     No. 02-1845      March 23, 2004   \n",
       "12       No. 12-10      April 22, 2013   \n",
       "13       No. 12315    December 9, 2013   \n",
       "14     No. 17-1104    October 10, 2018   \n",
       "15       No. 13553    December 9, 2014   \n",
       "16       No. 13553    December 9, 2014   \n",
       "17       No. 13895   November 12, 2014   \n",
       "18      No. 00-492      April 17, 2001   \n",
       "19         No. 132    January 11, 2010   \n",
       "20     No. 00-1214   February 19, 2002   \n",
       "21      No. 02-658     October 8, 2003   \n",
       "22         No. 128    January 10, 2005   \n",
       "23     No. 99-1908    January 16, 2001   \n",
       "24     No. 06-9130    October 29, 2007   \n",
       "25       No. 13298      March 31, 2014   \n",
       "26     No. 11-9335    January 14, 2013   \n",
       "27      No. 07-214   February 26, 2008   \n",
       "28      No. 11-982    November 7, 2012   \n",
       "29      No. 07-562     October 6, 2008   \n",
       "...            ...                 ...   \n",
       "1272    No. 131499    January 20, 2015   \n",
       "1273   No. 08-1314    November 3, 2010   \n",
       "1274   No. 16-6855    October 30, 2017   \n",
       "1275  No. 05-98311   February 27, 2007   \n",
       "1276   No. 07-1239     October 8, 2008   \n",
       "1277    No. 17-530      April 16, 2018   \n",
       "1278    No. 00-952    December 3, 2001   \n",
       "1279   No. 04-1581    January 17, 2006   \n",
       "1280    No. 141504      March 21, 2016   \n",
       "1281   No. 08-9156    November 4, 2009   \n",
       "1282   No. 10-9995   February 27, 2012   \n",
       "1283     No. 13115      March 26, 2014   \n",
       "1284   No. 01-1862    January 21, 2003   \n",
       "1285    No. 05-416      March 22, 2006   \n",
       "1286   No. 06-1249    November 3, 2008   \n",
       "1287   No. 02-1684       March 1, 2004   \n",
       "1288    No. 137451    November 5, 2014   \n",
       "1289     No. 08-67      March 23, 2009   \n",
       "1290    No. 01-270     October 7, 2002   \n",
       "1291    No. 121226    December 3, 2014   \n",
       "1292   No. 00-1567     January 9, 2002   \n",
       "1293    No. 07-869    November 3, 2008   \n",
       "1294   No. 99-7791   February 21, 2001   \n",
       "1295   No. 05-5992      April 18, 2006   \n",
       "1296   No. 00-1751   February 20, 2002   \n",
       "1297   No. 15-1358    January 18, 2017   \n",
       "1298    No. 10-699    November 7, 2011   \n",
       "1299     No. 13628    November 3, 2014   \n",
       "1300    No. 141418      March 23, 2016   \n",
       "1301   No. 05-1508    January 10, 2007   \n",
       "\n",
       "                                        Bills Mentioned  \n",
       "0     ['Labor Relations Act : 2', 'Labor Standards A...  \n",
       "1                             ['Voting Rights Act : 3']  \n",
       "2                           ['Career Criminal Act : 3']  \n",
       "3                                                    []  \n",
       "4                                                    []  \n",
       "5     ['Gun Control Act : 12', 'Owners Protection Ac...  \n",
       "6     ['The Travel Act : 1', 'Controlled Substances ...  \n",
       "7     ['Age Discrimination Act : 3', 'Civil Rights A...  \n",
       "8                            ['Small Business Act : 3']  \n",
       "9                             ['Child Welfare Act : 1']  \n",
       "10                                                   []  \n",
       "11                     ['Management Relations Act : 1']  \n",
       "12                          ['Affordable Care Act : 1']  \n",
       "13                  ['Transportation Security Act : 1']  \n",
       "14                                                   []  \n",
       "15                                                   []  \n",
       "16                                                   []  \n",
       "17                            ['Voting Rights Act : 3']  \n",
       "18                                                   []  \n",
       "19                                                   []  \n",
       "20                                                   []  \n",
       "21                                ['Clean Air Act : 3']  \n",
       "22    ['The Antiquities Act : 1', 'Submerged Lands A...  \n",
       "23    ['Voting Rights Act : 2', 'Civil Rights Act : ...  \n",
       "24    ['Tort Claims Act : 1', 'Federal Arbitration A...  \n",
       "25                                                   []  \n",
       "26                             ['First Crimes Act : 1']  \n",
       "27                            ['False Claims Act : 14']  \n",
       "28                     ['Declaratory Judgment Act : 1']  \n",
       "29    ['Airline Deregulation Act : 1', 'Trade Commis...  \n",
       "...                                                 ...  \n",
       "1272                                                 []  \n",
       "1273                         ['Vehicle Safety Act : 1']  \n",
       "1274                                                 []  \n",
       "1275                                                 []  \n",
       "1276                      ['Mammal Protection Act : 1']  \n",
       "1277                         ['Retirement Tax Act : 2']  \n",
       "1278  ['Federal Medicaid Act : 1', 'Catastrophic Cov...  \n",
       "1279                                                 []  \n",
       "1280                          ['Voting Rights Act : 7']  \n",
       "1281                                                 []  \n",
       "1282                                                 []  \n",
       "1283                                                 []  \n",
       "1284                                                 []  \n",
       "1285  ['Age Discrimination Act : 2', 'Litigation Ref...  \n",
       "1286  ['Federal Drug Act : 1', 'Medical Device Act :...  \n",
       "1287                                                 []  \n",
       "1288                          ['Oxley Grouper Act : 1']  \n",
       "1289                                                 []  \n",
       "1290              ['Transportation Efficiency Act : 1']  \n",
       "1291  ['Civil Rights Act : 1', 'Pregnancy Discrimina...  \n",
       "1292                                                 []  \n",
       "1293  ['Federal Power Act : 1', 'Voluntary Contribut...  \n",
       "1294                                                 []  \n",
       "1295                          ['Speedy Trial Act : 14']  \n",
       "1296                       ['Community School Act : 1']  \n",
       "1297              ['Administrative Procedures Act : 1']  \n",
       "1298                                                 []  \n",
       "1299  ['Taiwan Relations Act : 2', 'Jerusalem Embass...  \n",
       "1300  ['Affordable Care Act : 1', 'Freedom Restorati...  \n",
       "1301                             ['Impact Aid Act : 4']  \n",
       "\n",
       "[1302 rows x 5 columns]"
      ]
     },
     "execution_count": 276,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path = \"/Users/yuhanxie/Desktop/LA/SC/bills.csv\"\n",
    "data = pd.read_csv(path)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 277,
   "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>Act</th>\n",
       "      <th>Case</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alderson Reporting Company Official Act</td>\n",
       "      <td>14 Penn Plaza LLC v. Pyett</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Help America Vote Act</td>\n",
       "      <td>Abbott v. Perez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Voting Rights Act</td>\n",
       "      <td>Abbott v. Perez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Lanham Act</td>\n",
       "      <td>Abramski v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Birth Abortion Act</td>\n",
       "      <td>Abuelhawa v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Private Securities Litigation Reform Act</td>\n",
       "      <td>Adarand Constructors, Inc. v. Mineta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Uniform Standards Act</td>\n",
       "      <td>Adarand Constructors, Inc. v. Mineta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Prison Litigation Reform Act</td>\n",
       "      <td>Advocate Health Care Network v. Stapleton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>States Administrative Procedure Act</td>\n",
       "      <td>Advocate Health Care Network v. Stapleton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alaska Statehood Act</td>\n",
       "      <td>Aetna Health Inc. v. Davila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Antiquities Act</td>\n",
       "      <td>Aetna Health Inc. v. Davila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Submerged Lands Act</td>\n",
       "      <td>Aetna Health Inc. v. Davila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Antiquities Act</td>\n",
       "      <td>Aetna Health Inc. v. Davila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Texas Civil Procedure Act</td>\n",
       "      <td>Air _ Liquid Systems Corp. v. DeVries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Armed Career Criminal Act</td>\n",
       "      <td>Alabama Dept. of Revenue v. CSX Transp., Inc.....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Administrative Procedures Act</td>\n",
       "      <td>Alabama Dept. of Revenue v. CSX Transp., Inc.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dental Practice Act</td>\n",
       "      <td>Alabama Dept. of Revenue v. CSX Transp., Inc.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sherman Act</td>\n",
       "      <td>Alabama Dept. of Revenue v. CSX Transp., Inc.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fair Labor Act</td>\n",
       "      <td>Alabama v. Bozeman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Portal Act</td>\n",
       "      <td>Alabama v. Bozeman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alderson Reporting Company Official Hobbs Act</td>\n",
       "      <td>Alabama v. North Carolina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Clayton Act</td>\n",
       "      <td>Alabama v. North Carolina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Hobbs Act</td>\n",
       "      <td>Alabama v. North Carolina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Racketeering Act</td>\n",
       "      <td>Alabama v. North Carolina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Hobbs Act</td>\n",
       "      <td>Alabama v. North Carolina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fair Labor Standards Act</td>\n",
       "      <td>Alaska v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>National Labor Relations Act</td>\n",
       "      <td>Alaska v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>All Writs Act</td>\n",
       "      <td>Alexander v. Sandoval</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Military Extraterritorial Jurisdiction Act</td>\n",
       "      <td>Alexander v. Sandoval</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The All Writs Act</td>\n",
       "      <td>Alexander v. Sandoval</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Healthcare Act</td>\n",
       "      <td>Yellow Transp. Inc. v. Michigan, et al</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Religious Liberty Protection Act</td>\n",
       "      <td>Yellow Transp. Inc. v. Michigan, et al</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Lanham Act</td>\n",
       "      <td>Young v. United Parcel Service, Inc.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Energy Policy Act</td>\n",
       "      <td>Young v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Federal Power Act</td>\n",
       "      <td>Young v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>National Policy Act</td>\n",
       "      <td>Young v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Federal Power Act</td>\n",
       "      <td>Young v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>California Public Records Act</td>\n",
       "      <td>Zedner v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Electronic Communications Privacy Act</td>\n",
       "      <td>Zedner v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Final Review Act</td>\n",
       "      <td>Zedner v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Storage Act</td>\n",
       "      <td>Zedner v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Stored Communications Act</td>\n",
       "      <td>Zedner v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Stored Communications Act</td>\n",
       "      <td>Zedner v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cosmetic Act</td>\n",
       "      <td>Ziglar v. Abbasi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Civil Rights Act</td>\n",
       "      <td>Zivotofsky v. Clinton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Open Housing Act</td>\n",
       "      <td>Zivotofsky v. Clinton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Voting Rights Act</td>\n",
       "      <td>Zivotofsky v. Clinton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Communications Act</td>\n",
       "      <td>Zivotofsky v. Kerry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Telecommunications Act</td>\n",
       "      <td>Zivotofsky v. Kerry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Act</td>\n",
       "      <td>Zivotofsky v. Kerry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bankruptcy Act</td>\n",
       "      <td>Zubik v. Burwell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Civil Relief Act</td>\n",
       "      <td>Zubik v. Burwell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Injunction Act</td>\n",
       "      <td>Zubik v. Burwell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Relief Act</td>\n",
       "      <td>Zubik v. Burwell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>South Carolina Tort Claims Act</td>\n",
       "      <td>Zubik v. Burwell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Air Act</td>\n",
       "      <td>Zuni Public School Dist. v. Department of Educ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Clean Air Act</td>\n",
       "      <td>Zuni Public School Dist. v. Department of Educ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Clean Water Act</td>\n",
       "      <td>Zuni Public School Dist. v. Department of Educ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Resource Conservation Act</td>\n",
       "      <td>Zuni Public School Dist. v. Department of Educ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Water Act</td>\n",
       "      <td>Zuni Public School Dist. v. Department of Educ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2420 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Act  \\\n",
       "0         Alderson Reporting Company Official Act   \n",
       "0                           Help America Vote Act   \n",
       "0                               Voting Rights Act   \n",
       "0                                      Lanham Act   \n",
       "0                              Birth Abortion Act   \n",
       "0        Private Securities Litigation Reform Act   \n",
       "0                           Uniform Standards Act   \n",
       "0                    Prison Litigation Reform Act   \n",
       "0             States Administrative Procedure Act   \n",
       "0                            Alaska Statehood Act   \n",
       "0                                 Antiquities Act   \n",
       "0                             Submerged Lands Act   \n",
       "0                             The Antiquities Act   \n",
       "0                       Texas Civil Procedure Act   \n",
       "0                       Armed Career Criminal Act   \n",
       "0                   Administrative Procedures Act   \n",
       "0                             Dental Practice Act   \n",
       "0                                     Sherman Act   \n",
       "0                                  Fair Labor Act   \n",
       "0                                      Portal Act   \n",
       "0   Alderson Reporting Company Official Hobbs Act   \n",
       "0                                     Clayton Act   \n",
       "0                                       Hobbs Act   \n",
       "0                                Racketeering Act   \n",
       "0                                   The Hobbs Act   \n",
       "0                        Fair Labor Standards Act   \n",
       "0                    National Labor Relations Act   \n",
       "0                                   All Writs Act   \n",
       "0      Military Extraterritorial Jurisdiction Act   \n",
       "0                               The All Writs Act   \n",
       "..                                            ...   \n",
       "0                                  Healthcare Act   \n",
       "0                Religious Liberty Protection Act   \n",
       "0                                      Lanham Act   \n",
       "0                               Energy Policy Act   \n",
       "0                               Federal Power Act   \n",
       "0                             National Policy Act   \n",
       "0                           The Federal Power Act   \n",
       "0                   California Public Records Act   \n",
       "0           Electronic Communications Privacy Act   \n",
       "0                                Final Review Act   \n",
       "0                                     Storage Act   \n",
       "0                       Stored Communications Act   \n",
       "0                   The Stored Communications Act   \n",
       "0                                    Cosmetic Act   \n",
       "0                                Civil Rights Act   \n",
       "0                                Open Housing Act   \n",
       "0                               Voting Rights Act   \n",
       "0                              Communications Act   \n",
       "0                          Telecommunications Act   \n",
       "0                                         The Act   \n",
       "0                                  Bankruptcy Act   \n",
       "0                                Civil Relief Act   \n",
       "0                                  Injunction Act   \n",
       "0                                      Relief Act   \n",
       "0                  South Carolina Tort Claims Act   \n",
       "0                                         Air Act   \n",
       "0                                   Clean Air Act   \n",
       "0                                 Clean Water Act   \n",
       "0                       Resource Conservation Act   \n",
       "0                                       Water Act   \n",
       "\n",
       "                                                 Case  \n",
       "0                          14 Penn Plaza LLC v. Pyett  \n",
       "0                                     Abbott v. Perez  \n",
       "0                                     Abbott v. Perez  \n",
       "0                           Abramski v. United States  \n",
       "0                          Abuelhawa v. United States  \n",
       "0                Adarand Constructors, Inc. v. Mineta  \n",
       "0                Adarand Constructors, Inc. v. Mineta  \n",
       "0           Advocate Health Care Network v. Stapleton  \n",
       "0           Advocate Health Care Network v. Stapleton  \n",
       "0                         Aetna Health Inc. v. Davila  \n",
       "0                         Aetna Health Inc. v. Davila  \n",
       "0                         Aetna Health Inc. v. Davila  \n",
       "0                         Aetna Health Inc. v. Davila  \n",
       "0               Air _ Liquid Systems Corp. v. DeVries  \n",
       "0   Alabama Dept. of Revenue v. CSX Transp., Inc.....  \n",
       "0       Alabama Dept. of Revenue v. CSX Transp., Inc.  \n",
       "0       Alabama Dept. of Revenue v. CSX Transp., Inc.  \n",
       "0       Alabama Dept. of Revenue v. CSX Transp., Inc.  \n",
       "0                                  Alabama v. Bozeman  \n",
       "0                                  Alabama v. Bozeman  \n",
       "0                           Alabama v. North Carolina  \n",
       "0                           Alabama v. North Carolina  \n",
       "0                           Alabama v. North Carolina  \n",
       "0                           Alabama v. North Carolina  \n",
       "0                           Alabama v. North Carolina  \n",
       "0                             Alaska v. United States  \n",
       "0                             Alaska v. United States  \n",
       "0                               Alexander v. Sandoval  \n",
       "0                               Alexander v. Sandoval  \n",
       "0                               Alexander v. Sandoval  \n",
       "..                                                ...  \n",
       "0              Yellow Transp. Inc. v. Michigan, et al  \n",
       "0              Yellow Transp. Inc. v. Michigan, et al  \n",
       "0                Young v. United Parcel Service, Inc.  \n",
       "0                              Young v. United States  \n",
       "0                              Young v. United States  \n",
       "0                              Young v. United States  \n",
       "0                              Young v. United States  \n",
       "0                             Zedner v. United States  \n",
       "0                             Zedner v. United States  \n",
       "0                             Zedner v. United States  \n",
       "0                             Zedner v. United States  \n",
       "0                             Zedner v. United States  \n",
       "0                             Zedner v. United States  \n",
       "0                                    Ziglar v. Abbasi  \n",
       "0                               Zivotofsky v. Clinton  \n",
       "0                               Zivotofsky v. Clinton  \n",
       "0                               Zivotofsky v. Clinton  \n",
       "0                                 Zivotofsky v. Kerry  \n",
       "0                                 Zivotofsky v. Kerry  \n",
       "0                                 Zivotofsky v. Kerry  \n",
       "0                                    Zubik v. Burwell  \n",
       "0                                    Zubik v. Burwell  \n",
       "0                                    Zubik v. Burwell  \n",
       "0                                    Zubik v. Burwell  \n",
       "0                                    Zubik v. Burwell  \n",
       "0   Zuni Public School Dist. v. Department of Educ...  \n",
       "0   Zuni Public School Dist. v. Department of Educ...  \n",
       "0   Zuni Public School Dist. v. Department of Educ...  \n",
       "0   Zuni Public School Dist. v. Department of Educ...  \n",
       "0   Zuni Public School Dist. v. Department of Educ...  \n",
       "\n",
       "[2420 rows x 2 columns]"
      ]
     },
     "execution_count": 277,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "act_df = pd.DataFrame({'Act':[],'Case':[]})\n",
    "for i in range(1302):\n",
    "    title = data['Title'].iloc[i]\n",
    "    act = unibill(cleaned[i])\n",
    "    for j in act:\n",
    "        act_df = act_df.append(pd.DataFrame({'Act':[j],'Case':[title]}))\n",
    "act_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 278,
   "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>Act</th>\n",
       "      <th>Case</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Alderson Reporting Company Official Act</td>\n",
       "      <td>14 Penn Plaza LLC v. Pyett</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Help America Vote Act</td>\n",
       "      <td>Abbott v. Perez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Voting Rights Act</td>\n",
       "      <td>Abbott v. Perez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lanham Act</td>\n",
       "      <td>Abramski v. United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Birth Abortion Act</td>\n",
       "      <td>Abuelhawa v. United States</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Act                        Case\n",
       "0  Alderson Reporting Company Official Act  14 Penn Plaza LLC v. Pyett\n",
       "1                    Help America Vote Act             Abbott v. Perez\n",
       "2                        Voting Rights Act             Abbott v. Perez\n",
       "3                               Lanham Act   Abramski v. United States\n",
       "4                       Birth Abortion Act  Abuelhawa v. United States"
      ]
     },
     "execution_count": 278,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "act_df = act_df.reset_index().drop('index',axis=1).head()\n",
    "act_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'America Vote Act'"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}