scraping website beautifulsoup v12.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Version 12\n",
    "Dated 15 Nov.\n",
    "\n",
<<<<<<< HEAD
    "In this version we have changed the code to look for the most frequent words in the first fifty results of patents from a list of 132 results. The results are directly from the USTrademark office website. We will be moving into a more elaborate use of Natural Language Processing Tool Kit in python to better assess the frequency of words used in the first fifty results we are scraping from the UStrademark Office's website. This code will be modified further.\n"
=======
    "In this version we have changed the code to look for the most frequent words in the first fifty results of patents from a list of 132 results. The results are directly from the USTrademark office website. We will be moving into a more elaborate use of Natural Language Processing Tool Kit in python to better assess the frequency of words used in the first fifty results we are scraping from the UStrademark Office's website. This code will be modified further.\n",
    "\n",
    "Authors:Diane, Joshi\n"
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# import libraries\n",
    "#import urllib2\n",
    "import pandas as pd\n",
    "from urllib.request import urlopen\n",
    "from bs4 import BeautifulSoup\n",
    "from time import sleep\n",
    "from random import randint"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def getsoupfromlink(quote_page):\n",
    "    # specify the url\n",
    "    quote_page = 'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=2&f=S&l=50&Query=ACLM%2Fpython+&d=PTXT'\n",
    "    # query the website and return the html to the variable ‘page’\n",
    "    page = urlopen(quote_page)\n",
    "    # parse the html using beautiful soap and store in variable `soup`\n",
    "    soup = BeautifulSoup(page, 'html.parser')\n",
    "    return soup\n",
    "\n",
    "#soup = getsoupfromlink(quote_page)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "soup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#s = soup.text\n",
    "\n",
    "def find_between( s, first, last ):\n",
    "    try:\n",
    "        start = s.index( first ) + len( first )\n",
    "        end = s.index( last, start )\n",
    "        return s[start:end]\n",
    "    except ValueError:\n",
    "        return \"\"\n",
    "\n",
    "def find_between_r( s, first, last ):\n",
    "    try:\n",
    "        start = s.rindex( first ) + len( first )\n",
    "        end = s.rindex( last, start )\n",
    "        return s[start:end]\n",
    "    except ValueError:\n",
    "        return \"\"\n",
    "\n",
    "\n",
    "#print (find_between( s, \"What is claimed is:\", \"* * * * *\" ))\n",
    "#print (find_between_r (s, '123', 'abc' ))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true,
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "def extractlink (soup):\n",
    "    alllinks = []\n",
    "    count = 0 \n",
    "    for link in soup.find_all('a', href=True):\n",
    "        x =  link['href']\n",
    "        if x[:19]=='/netacgi/nph-Parser' and x.find('Next') == -1:\n",
    "\n",
    "            count = count+1\n",
    "            alllinks.append ('http://patft.uspto.gov'+x)\n",
    "    return alllinks\n",
    "\n",
    "#alllinks = extractlink(soup)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def remove_duplicates(l):\n",
    "    return list(set(l))\n",
    "\n",
    "#alllinks = remove_duplicates(alllinks)\n",
    "\n",
    "#print (len(alllinks))"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 10,
=======
   "execution_count": 22,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {
    "collapsed": true,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def getdatafromlink(link, lstofp):\n",
    "    from urllib.request import urlopen\n",
    "    from bs4 import BeautifulSoup\n",
    "    #quote_page2 = 'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=1&p=1&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python/'\n",
    "    quote_page2 = link\n",
    "    \n",
    "    page2 = urlopen(quote_page2)\n",
    "\n",
<<<<<<< HEAD
    "    sleep(randint(8,15)/30)\n",
=======
    "    sleep(randint(8,15)/10)\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
    "    soupinfun = BeautifulSoup(page2, 'html.parser')\n",
    "    \n",
    "    try:\n",
    "        heading= (soupinfun.find('font', {'size':'+1'}).text).replace(\"\\n\", \"\")\n",
    "        heading = ' '.join(heading.split())\n",
    "        abstract= (soupinfun.p.text).replace(\"\\n\", \"\")\n",
    "        abstract = ' '.join(abstract.split())\n",
    "        claims = (find_between (soupinfun.text, 'What is claimed is:', '* * * * *' )).replace(\"\\n\", \"\")\n",
    "        claims = ' '.join(claims.split())\n",
    "        #print soup\n",
    "        lstofp.append([link,heading, abstract, claims])\n",
    "        page2.close()\n",
    "        #time.sleep(.1)\n",
    "\n",
    "    except Exception:\n",
    "        pass\n",
    "    return lstofp;\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": null,
=======
   "execution_count": 7,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def createdf(alllinks):\n",
    "    listofp =[]\n",
    "    for item in alllinks:\n",
    "        listofp = getdatafromlink(item,listofp)\n",
    "\n",
    "    cols = ['Link', 'Heading', 'Abstract', 'Claims']\n",
    "\n",
    "    df1 = pd.DataFrame(listofp, columns=cols)\n",
    "\n",
    "    df1.to_csv('output.txt', sep='|')\n",
    "    return df1\n",
    "\n",
    "#df1 = createdf(alllinks)"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": null,
=======
   "execution_count": 9,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "quote_page = 'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=2&f=S&l=50&Query=ACLM%2Fpython+&d=PTXT'\n",
    "\n",
    "listofresultpages=[]\n",
    "\n",
    "for num in range(1,9):\n",
    "    leftlink= 'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p='\n",
    "    midnumber = num\n",
    "    rightlink = '&f=S&l=50&Query=ACLM%2Fpython+&d=PTXT'\n",
    "    quotepagejoined = leftlink+str(midnumber)+rightlink\n",
    "    listofresultpages.append([quotepagejoined])\n",
    "\n",
    "#print (quotepagejoined == quote_page)\n",
    "\n",
    "#listofresultpages"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 11,
=======
   "execution_count": 10,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                 Link  \\\n",
      "0   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "1   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "2   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "3   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "4   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "5   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "6   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "7   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "8   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "9   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "10  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "11  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "12  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "13  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "14  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "15  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "16  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "17  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "18  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "19  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "20  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "21  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "22  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "23  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "24  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "25  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "26  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "27  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "28  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "29  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
<<<<<<< HEAD
      "30  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "31  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "32  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "33  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "34  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "35  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "36  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "37  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "38  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "39  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "40  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "41  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "42  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "43  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "44  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "45  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "46  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "47  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "48  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "49  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "\n",
      "                                              Heading  \\\n",
      "0   Replacement of build to order parts with post ...   \n",
      "1                Pattern modeling methods and systems   \n",
      "2   System for translating diverse programming lan...   \n",
      "3   Client program executable on multiple heteroge...   \n",
      "4   Systems, methods and apparatus for modeling, s...   \n",
      "5   System and a method for web-based editing of d...   \n",
      "6          Garbage collection implemented in hardware   \n",
      "7   Method and system for data centric heap profiling   \n",
      "8   Optimizing program by reusing execution result...   \n",
      "9   Dynamic centralized unit determination in a cr...   \n",
      "10              Method for invoking UOML instructions   \n",
      "11  Robot task commander with extensible programmi...   \n",
      "12                      Beverage dispensing apparatus   \n",
      "13                      Cross language object sharing   \n",
      "14                     Automated lamp stack migration   \n",
      "15  Method and system for dynamic digital rights b...   \n",
      "16           Embedded distributed computing solutions   \n",
      "17  Method and an apparatus to conduct software re...   \n",
      "18                                   Scripting bridge   \n",
      "19  User co-routine interface for customizing SIP ...   \n",
      "20  Static extensibility models with dynamic langu...   \n",
      "21     Client-side and server-side unified validation   \n",
      "22  System and method for developing, deploying, m...   \n",
      "23  Method for testing connectivity of software ap...   \n",
      "24  System and method for automatic hardware and s...   \n",
      "25  Methods and systems to avoid unproductive disp...   \n",
      "26  Composition studio to develop and maintain sur...   \n",
      "27  Integrating map-reduce into a distributed rela...   \n",
      "28  Method and system for remote device access in ...   \n",
      "29             Facilitating client server interaction   \n",
      "30  Control surfaces for a technical computing env...   \n",
      "31  Systems and methods for producing a cooling be...   \n",
      "32  Method and system for remote device access in ...   \n",
      "33  Semantic neural network for aggregating query ...   \n",
      "34  Program system, and method and system arrangem...   \n",
      "35  Method and system for simplifying distributed ...   \n",
      "36  System for translating diverse programming lan...   \n",
      "37  Methods and systems for dynamically generating...   \n",
      "38                        Record based code structure   \n",
      "39  Procedurally expressing graphic objects for we...   \n",
      "40  Hierarchically scoped resettable variables in ...   \n",
      "41  Documentation generation from a computer reada...   \n",
      "42  Intelligent offline caching of non-navigated c...   \n",
      "43  Automated customer incident report management ...   \n",
      "44               Pattern modeling methods and systems   \n",
      "45  Method and device for processing data for gene...   \n",
      "46     User-configurable network performance monitors   \n",
      "47  Associating hosts with subscriber and service ...   \n",
      "48  Flow-optimization system and method for cloud ...   \n",
      "49  Systems and methods for managing a collaborati...   \n",
      "\n",
      "                                             Abstract  \\\n",
      "0   An embedded imaging system for addressing burn...   \n",
      "1   In a computer-implemented method, models are d...   \n",
      "2   A computer language translator that translates...   \n",
      "3   A device receives a program that includes one ...   \n",
      "4   Systems, methods and apparatus are provided th...   \n",
      "5   A method and a system for editing documents on...   \n",
      "6   A computing device is provided and includes a ...   \n",
      "7   A method and system for data centric heap prof...   \n",
      "8   A technique for optimizing a program by reusin...   \n",
      "9   A charging system includes a rating engine, a ...   \n",
      "10  Embodiments of the present invention disclose ...   \n",
      "11  A system for developing distributed robot appl...   \n",
      "12  A beverage dispensing apparatus may be adapted...   \n",
      "13  Methods, system, and computer storage media ar...   \n",
      "14  Embodiments of the present invention provide a...   \n",
      "15  Methods and systems for dynamically bundling p...   \n",
      "16  Methods and Systems are provided for participa...   \n",
      "17  Some embodiments of a method and an apparatus ...   \n",
      "18  A scripting bridge allows a developer to autom...   \n",
      "19  A method of using co-routines to implement a f...   \n",
      "20  Various technologies and techniques are disclo...   \n",
      "21  A system and method for validating code on a c...   \n",
      "22  A system and method for developing, deploying,...   \n",
      "23  A method for verifying the connectivity of sof...   \n",
      "24  The present invention relates to a system and ...   \n",
      "25  Methods and systems are disclosed to dispatch ...   \n",
      "26  A system for generating a plurality of surveil...   \n",
      "27  A computer readable storage medium includes ex...   \n",
      "28  A method, system and computer program product ...   \n",
      "29  The apparatus includes a base client module an...   \n",
      "30  A technical computing environment may include ...   \n",
      "31  A system for cooling a beverage and dispensing...   \n",
      "32  A method, system and computer program product ...   \n",
      "33  A system, method and computer program product ...   \n",
      "34  A method and system arrangement are disclosed ...   \n",
      "35  A method and system for managing a large numbe...   \n",
      "36  A computer language translator that translates...   \n",
      "37  The present invention provides methods and sys...   \n",
      "38  The compiled code of a computer program is sto...   \n",
      "39  A graphics object can be expressed using proce...   \n",
      "40  The illustrative embodiments of this invention...   \n",
      "41  Generation of documentation from a computer re...   \n",
      "42  A request for a navigated content associated w...   \n",
      "43  A social networking system is configured to ge...   \n",
      "44  A list of constructs is displayed on a user in...   \n",
      "45  A data processing device comprises processing ...   \n",
      "46  A network analysis system provides for a user-...   \n",
      "47  Associating hosts with subscriber and service ...   \n",
      "48  A cloud computing interface includes a high-le...   \n",
      "49  Embodiments relate to systems and methods for ...   \n",
      "\n",
      "                                               Claims  \n",
      "0   1. A method for installing a software onto an ...  \n",
      "1   1. A computer-implemented method comprising: d...  \n",
      "2   1. A computer language translator for translat...  \n",
      "3   1. A computing device-implemented method compr...  \n",
      "4                                                      \n",
      "5   1. A system for editing both a webpage documen...  \n",
      "6   1. A computing device, comprising: a memory mo...  \n",
      "7   1. A method, implemented in a computing device...  \n",
      "8   1. A method for optimizing a program, comprisi...  \n",
      "9   1. A credit control server, comprising: a rati...  \n",
      "10                                                     \n",
      "11                                                     \n",
      "12                                                     \n",
      "13  1. One or more tangible computer storage devic...  \n",
      "14                                                     \n",
      "15                                                     \n",
      "16  1. A method of distributed computing, comprisi...  \n",
      "17  1. A computer-implemented method comprising: r...  \n",
      "18  1. At a computer system, the computer system i...  \n",
      "19                                                     \n",
      "20  1. A computer storage memory having computer-e...  \n",
      "21                                                     \n",
      "22                                                     \n",
      "23                                                     \n",
      "24  1. A computer implemented method for defining ...  \n",
      "25  1. A method to dispatch service resources comp...  \n",
      "26                                                     \n",
      "27                                                     \n",
      "28  1. A method for remote device access, the meth...  \n",
      "29                                                     \n",
      "30  1. An apparatus comprising: a memory to store ...  \n",
      "31                                                     \n",
      "32  1. A method for remote device access, the meth...  \n",
      "33  1. A system for processing user search request...  \n",
      "34  1. A method for generating a software applicat...  \n",
      "35  1. A method for receiving and executing, on on...  \n",
      "36  1. A computer language translator for translat...  \n",
      "37  1. A method comprising: receiving, by a server...  \n",
      "38  1. A system comprising: a computing device; op...  \n",
      "39                                                     \n",
      "40                                                     \n",
      "41  1. A method executed by a processor for docume...  \n",
      "42  1. A system for usage-based offline caching co...  \n",
      "43  1. A method comprising: receiving, from an adm...  \n",
      "44  1. A computer-implemented method for inserting...  \n",
      "45  1. A data processing device comprising: a disp...  \n",
      "46                                                     \n",
      "47  1. A method of associating a host with a requi...  \n",
      "48                                                     \n",
      "49  1. A method comprising: hosting, by a collabor...  \n"
     ]
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-11-5be7413d323d>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      6\u001b[0m     \u001b[0malllinks\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mremove_duplicates\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0malllinks\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m     \u001b[0;31m#print (alllinks)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 8\u001b[0;31m     \u001b[0mdf1\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcreatedf\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0malllinks\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      9\u001b[0m     \u001b[0mprint\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mdf1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     10\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-7-f590e20c1f04>\u001b[0m in \u001b[0;36mcreatedf\u001b[0;34m(alllinks)\u001b[0m\n\u001b[1;32m      2\u001b[0m     \u001b[0mlistofp\u001b[0m \u001b[0;34m=\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m     \u001b[0;32mfor\u001b[0m \u001b[0mitem\u001b[0m \u001b[0;32min\u001b[0m \u001b[0malllinks\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m         \u001b[0mlistofp\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgetdatafromlink\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mlistofp\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      5\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m     \u001b[0mcols\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;34m'Link'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'Heading'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'Abstract'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'Claims'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-10-5f3d3f3e3404>\u001b[0m in \u001b[0;36mgetdatafromlink\u001b[0;34m(link, lstofp)\u001b[0m\n\u001b[1;32m      5\u001b[0m     \u001b[0mquote_page2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mlink\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      6\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 7\u001b[0;31m     \u001b[0mpage2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0murlopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mquote_page2\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      8\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      9\u001b[0m     \u001b[0msleep\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrandint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m8\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m15\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m/\u001b[0m\u001b[0;36m30\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/urllib/request.py\u001b[0m in \u001b[0;36murlopen\u001b[0;34m(url, data, timeout, cafile, capath, cadefault, context)\u001b[0m\n\u001b[1;32m    221\u001b[0m     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    222\u001b[0m         \u001b[0mopener\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_opener\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 223\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0mopener\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    224\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    225\u001b[0m \u001b[0;32mdef\u001b[0m \u001b[0minstall_opener\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mopener\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/urllib/request.py\u001b[0m in \u001b[0;36mopen\u001b[0;34m(self, fullurl, data, timeout)\u001b[0m\n\u001b[1;32m    524\u001b[0m             \u001b[0mreq\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mmeth\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mreq\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    525\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 526\u001b[0;31m         \u001b[0mresponse\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_open\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mreq\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    527\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    528\u001b[0m         \u001b[0;31m# post-process response\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/urllib/request.py\u001b[0m in \u001b[0;36m_open\u001b[0;34m(self, req, data)\u001b[0m\n\u001b[1;32m    542\u001b[0m         \u001b[0mprotocol\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mreq\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtype\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    543\u001b[0m         result = self._call_chain(self.handle_open, protocol, protocol +\n\u001b[0;32m--> 544\u001b[0;31m                                   '_open', req)\n\u001b[0m\u001b[1;32m    545\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    546\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/urllib/request.py\u001b[0m in \u001b[0;36m_call_chain\u001b[0;34m(self, chain, kind, meth_name, *args)\u001b[0m\n\u001b[1;32m    502\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mhandler\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mhandlers\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    503\u001b[0m             \u001b[0mfunc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhandler\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmeth_name\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 504\u001b[0;31m             \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    505\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    506\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/urllib/request.py\u001b[0m in \u001b[0;36mhttp_open\u001b[0;34m(self, req)\u001b[0m\n\u001b[1;32m   1344\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1345\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mhttp_open\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreq\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1346\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdo_open\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhttp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclient\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mHTTPConnection\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreq\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1347\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1348\u001b[0m     \u001b[0mhttp_request\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mAbstractHTTPHandler\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdo_request_\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/urllib/request.py\u001b[0m in \u001b[0;36mdo_open\u001b[0;34m(self, http_class, req, **http_conn_args)\u001b[0m\n\u001b[1;32m   1319\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mOSError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0;31m# timeout error\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1320\u001b[0m                 \u001b[0;32mraise\u001b[0m \u001b[0mURLError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0merr\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1321\u001b[0;31m             \u001b[0mr\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mh\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgetresponse\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1322\u001b[0m         \u001b[0;32mexcept\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1323\u001b[0m             \u001b[0mh\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/http/client.py\u001b[0m in \u001b[0;36mgetresponse\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1329\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1330\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1331\u001b[0;31m                 \u001b[0mresponse\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mbegin\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1332\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mConnectionError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1333\u001b[0m                 \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/http/client.py\u001b[0m in \u001b[0;36mbegin\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    295\u001b[0m         \u001b[0;31m# read until we get a non-100 response\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    296\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 297\u001b[0;31m             \u001b[0mversion\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstatus\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreason\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_read_status\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    298\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mstatus\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0mCONTINUE\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    299\u001b[0m                 \u001b[0;32mbreak\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/http/client.py\u001b[0m in \u001b[0;36m_read_status\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    256\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    257\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_read_status\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 258\u001b[0;31m         \u001b[0mline\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreadline\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0m_MAXLINE\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m\"iso-8859-1\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    259\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mline\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0m_MAXLINE\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    260\u001b[0m             \u001b[0;32mraise\u001b[0m \u001b[0mLineTooLong\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"status line\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/socket.py\u001b[0m in \u001b[0;36mreadinto\u001b[0;34m(self, b)\u001b[0m\n\u001b[1;32m    584\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    585\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 586\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sock\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrecv_into\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mb\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    587\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    588\u001b[0m                 \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_timeout_occurred\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
=======
      "\n",
      "                                              Heading  \\\n",
      "0                Pattern modeling methods and systems   \n",
      "1   System for translating diverse programming lan...   \n",
      "2   Method and system for data centric heap profiling   \n",
      "3   Intelligent offline caching of non-navigated c...   \n",
      "4                         Record based code structure   \n",
      "5   Procedurally expressing graphic objects for we...   \n",
      "6   Integrating map-reduce into a distributed rela...   \n",
      "7          Garbage collection implemented in hardware   \n",
      "8   System and method for automatic hardware and s...   \n",
      "9   Program system, and method and system arrangem...   \n",
      "10     User-configurable network performance monitors   \n",
      "11                      Beverage dispensing apparatus   \n",
      "12  Method and system for dynamic digital rights b...   \n",
      "13  Documentation generation from a computer reada...   \n",
      "14  Method and system for simplifying distributed ...   \n",
      "15  Client program executable on multiple heteroge...   \n",
      "16  Methods and systems to avoid unproductive disp...   \n",
      "17  Systems and methods for managing a collaborati...   \n",
      "18  Systems, methods and apparatus for modeling, s...   \n",
      "19           Embedded distributed computing solutions   \n",
      "20             Facilitating client server interaction   \n",
      "21  Method for testing connectivity of software ap...   \n",
      "22  Automated customer incident report management ...   \n",
      "23  Method and system for remote device access in ...   \n",
      "24                                   Scripting bridge   \n",
      "25  Static extensibility models with dynamic langu...   \n",
      "26                     Automated lamp stack migration   \n",
      "27  Semantic neural network for aggregating query ...   \n",
      "28  Method and device for processing data for gene...   \n",
      "29  Hierarchically scoped resettable variables in ...   \n",
      "\n",
      "                                             Abstract  \\\n",
      "0   A list of constructs is displayed on a user in...   \n",
      "1   A computer language translator that translates...   \n",
      "2   A method and system for data centric heap prof...   \n",
      "3   A request for a navigated content associated w...   \n",
      "4   The compiled code of a computer program is sto...   \n",
      "5   A graphics object can be expressed using proce...   \n",
      "6   A computer readable storage medium includes ex...   \n",
      "7   A computing device is provided and includes a ...   \n",
      "8   The present invention relates to a system and ...   \n",
      "9   A method and system arrangement are disclosed ...   \n",
      "10  A network analysis system provides for a user-...   \n",
      "11  A beverage dispensing apparatus may be adapted...   \n",
      "12  Methods and systems for dynamically bundling p...   \n",
      "13  Generation of documentation from a computer re...   \n",
      "14  A method and system for managing a large numbe...   \n",
      "15  A device receives a program that includes one ...   \n",
      "16  Methods and systems are disclosed to dispatch ...   \n",
      "17  Embodiments relate to systems and methods for ...   \n",
      "18  Systems, methods and apparatus are provided th...   \n",
      "19  Methods and Systems are provided for participa...   \n",
      "20  The apparatus includes a base client module an...   \n",
      "21  A method for verifying the connectivity of sof...   \n",
      "22  A social networking system is configured to ge...   \n",
      "23  A method, system and computer program product ...   \n",
      "24  A scripting bridge allows a developer to autom...   \n",
      "25  Various technologies and techniques are disclo...   \n",
      "26  Embodiments of the present invention provide a...   \n",
      "27  A system, method and computer program product ...   \n",
      "28  A data processing device comprises processing ...   \n",
      "29  The illustrative embodiments of this invention...   \n",
      "\n",
      "                                               Claims  \n",
      "0   1. A computer-implemented method for inserting...  \n",
      "1   1. A computer language translator for translat...  \n",
      "2   1. A method, implemented in a computing device...  \n",
      "3   1. A system for usage-based offline caching co...  \n",
      "4   1. A system comprising: a computing device; op...  \n",
      "5                                                      \n",
      "6                                                      \n",
      "7   1. A computing device, comprising: a memory mo...  \n",
      "8   1. A computer implemented method for defining ...  \n",
      "9   1. A method for generating a software applicat...  \n",
      "10                                                     \n",
      "11                                                     \n",
      "12                                                     \n",
      "13  1. A method executed by a processor for docume...  \n",
      "14  1. A method for receiving and executing, on on...  \n",
      "15  1. A computing device-implemented method compr...  \n",
      "16  1. A method to dispatch service resources comp...  \n",
      "17  1. A method comprising: hosting, by a collabor...  \n",
      "18                                                     \n",
      "19  1. A method of distributed computing, comprisi...  \n",
      "20                                                     \n",
      "21                                                     \n",
      "22  1. A method comprising: receiving, from an adm...  \n",
      "23  1. A method for remote device access, the meth...  \n",
      "24  1. At a computer system, the computer system i...  \n",
      "25  1. A computer storage memory having computer-e...  \n",
      "26                                                     \n",
      "27  1. A system for processing user search request...  \n",
      "28  1. A data processing device comprising: a disp...  \n",
      "29                                                     \n",
      "Empty DataFrame\n",
      "Columns: [Link, Heading, Abstract, Claims]\n",
      "Index: []\n",
      "Empty DataFrame\n",
      "Columns: [Link, Heading, Abstract, Claims]\n",
      "Index: []\n",
      "Empty DataFrame\n",
      "Columns: [Link, Heading, Abstract, Claims]\n",
      "Index: []\n",
      "Empty DataFrame\n",
      "Columns: [Link, Heading, Abstract, Claims]\n",
      "Index: []\n",
      "Empty DataFrame\n",
      "Columns: [Link, Heading, Abstract, Claims]\n",
      "Index: []\n",
      "Empty DataFrame\n",
      "Columns: [Link, Heading, Abstract, Claims]\n",
      "Index: []\n",
      "Empty DataFrame\n",
      "Columns: [Link, Heading, Abstract, Claims]\n",
      "Index: []\n"
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
     ]
    }
   ],
   "source": [
    "quote_page = 'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=2&f=S&l=50&Query=ACLM%2Fpython+&d=PTXT'\n",
    "\n",
    "for page in listofresultpages:\n",
    "    soup = getsoupfromlink(page)\n",
    "    alllinks = extractlink(soup)\n",
    "    alllinks = remove_duplicates(alllinks)\n",
    "    #print (alllinks)\n",
    "    df1 = createdf(alllinks)\n",
    "    print (df1)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
<<<<<<< HEAD
   "metadata": {},
=======
   "metadata": {
    "collapsed": true
   },
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "outputs": [],
   "source": [
    "randint(8,15)/100"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 26,
=======
   "execution_count": 28,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
<<<<<<< HEAD
      "                                                  Link  \\\n",
      "0    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "1    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "2    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "3    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "4    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "5    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "6    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "7    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "8    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "9    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "10   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "11   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "12   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "13   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "14   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "15   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "16   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "17   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "18   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "19   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "20   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "21   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "22   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "23   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "24   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "25   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "26   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "27   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "28   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "29   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "..                                                 ...   \n",
      "120  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "121  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "122  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "123  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "124  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "125  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "126  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "127  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "128  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "129  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "130  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "131  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "132  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "133  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "134  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "135  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "136  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "137  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "138  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "139  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "140  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "141  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "142  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "143  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "144  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "145  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "146  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "147  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "148  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "149  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "\n",
      "                                               Heading  \\\n",
      "0    Replacement of build to order parts with post ...   \n",
      "1                 Pattern modeling methods and systems   \n",
      "2    System for translating diverse programming lan...   \n",
      "3    Client program executable on multiple heteroge...   \n",
      "4    Systems, methods and apparatus for modeling, s...   \n",
      "5    System and a method for web-based editing of d...   \n",
      "6           Garbage collection implemented in hardware   \n",
      "7    Method and system for data centric heap profiling   \n",
      "8    Optimizing program by reusing execution result...   \n",
      "9    Dynamic centralized unit determination in a cr...   \n",
      "10               Method for invoking UOML instructions   \n",
      "11   Robot task commander with extensible programmi...   \n",
      "12                       Beverage dispensing apparatus   \n",
      "13                       Cross language object sharing   \n",
      "14                      Automated lamp stack migration   \n",
      "15   Method and system for dynamic digital rights b...   \n",
      "16            Embedded distributed computing solutions   \n",
      "17   Method and an apparatus to conduct software re...   \n",
      "18                                    Scripting bridge   \n",
      "19   User co-routine interface for customizing SIP ...   \n",
      "20   Static extensibility models with dynamic langu...   \n",
      "21      Client-side and server-side unified validation   \n",
      "22   System and method for developing, deploying, m...   \n",
      "23   Method for testing connectivity of software ap...   \n",
      "24   System and method for automatic hardware and s...   \n",
      "25   Methods and systems to avoid unproductive disp...   \n",
      "26   Composition studio to develop and maintain sur...   \n",
      "27   Integrating map-reduce into a distributed rela...   \n",
      "28   Method and system for remote device access in ...   \n",
      "29              Facilitating client server interaction   \n",
      "..                                                 ...   \n",
      "120  Static extensibility models with dynamic langu...   \n",
      "121     Client-side and server-side unified validation   \n",
      "122  System and method for developing, deploying, m...   \n",
      "123  Method for testing connectivity of software ap...   \n",
      "124  System and method for automatic hardware and s...   \n",
      "125  Methods and systems to avoid unproductive disp...   \n",
      "126  Composition studio to develop and maintain sur...   \n",
      "127  Integrating map-reduce into a distributed rela...   \n",
      "128  Method and system for remote device access in ...   \n",
      "129             Facilitating client server interaction   \n",
      "130  Control surfaces for a technical computing env...   \n",
      "131  Systems and methods for producing a cooling be...   \n",
      "132  Method and system for remote device access in ...   \n",
      "133  Semantic neural network for aggregating query ...   \n",
      "134  Program system, and method and system arrangem...   \n",
      "135  Method and system for simplifying distributed ...   \n",
      "136  System for translating diverse programming lan...   \n",
      "137  Methods and systems for dynamically generating...   \n",
      "138                        Record based code structure   \n",
      "139  Procedurally expressing graphic objects for we...   \n",
      "140  Hierarchically scoped resettable variables in ...   \n",
      "141  Documentation generation from a computer reada...   \n",
      "142  Intelligent offline caching of non-navigated c...   \n",
      "143  Automated customer incident report management ...   \n",
      "144               Pattern modeling methods and systems   \n",
      "145  Method and device for processing data for gene...   \n",
      "146     User-configurable network performance monitors   \n",
      "147  Associating hosts with subscriber and service ...   \n",
      "148  Flow-optimization system and method for cloud ...   \n",
      "149  Systems and methods for managing a collaborati...   \n",
      "\n",
      "                                              Abstract  \\\n",
      "0    An embedded imaging system for addressing burn...   \n",
      "1    In a computer-implemented method, models are d...   \n",
      "2    A computer language translator that translates...   \n",
      "3    A device receives a program that includes one ...   \n",
      "4    Systems, methods and apparatus are provided th...   \n",
      "5    A method and a system for editing documents on...   \n",
      "6    A computing device is provided and includes a ...   \n",
      "7    A method and system for data centric heap prof...   \n",
      "8    A technique for optimizing a program by reusin...   \n",
      "9    A charging system includes a rating engine, a ...   \n",
      "10   Embodiments of the present invention disclose ...   \n",
      "11   A system for developing distributed robot appl...   \n",
      "12   A beverage dispensing apparatus may be adapted...   \n",
      "13   Methods, system, and computer storage media ar...   \n",
      "14   Embodiments of the present invention provide a...   \n",
      "15   Methods and systems for dynamically bundling p...   \n",
      "16   Methods and Systems are provided for participa...   \n",
      "17   Some embodiments of a method and an apparatus ...   \n",
      "18   A scripting bridge allows a developer to autom...   \n",
      "19   A method of using co-routines to implement a f...   \n",
      "20   Various technologies and techniques are disclo...   \n",
      "21   A system and method for validating code on a c...   \n",
      "22   A system and method for developing, deploying,...   \n",
      "23   A method for verifying the connectivity of sof...   \n",
      "24   The present invention relates to a system and ...   \n",
      "25   Methods and systems are disclosed to dispatch ...   \n",
      "26   A system for generating a plurality of surveil...   \n",
      "27   A computer readable storage medium includes ex...   \n",
      "28   A method, system and computer program product ...   \n",
      "29   The apparatus includes a base client module an...   \n",
      "..                                                 ...   \n",
      "120  Various technologies and techniques are disclo...   \n",
      "121  A system and method for validating code on a c...   \n",
      "122  A system and method for developing, deploying,...   \n",
      "123  A method for verifying the connectivity of sof...   \n",
      "124  The present invention relates to a system and ...   \n",
      "125  Methods and systems are disclosed to dispatch ...   \n",
      "126  A system for generating a plurality of surveil...   \n",
      "127  A computer readable storage medium includes ex...   \n",
      "128  A method, system and computer program product ...   \n",
      "129  The apparatus includes a base client module an...   \n",
      "130  A technical computing environment may include ...   \n",
      "131  A system for cooling a beverage and dispensing...   \n",
      "132  A method, system and computer program product ...   \n",
      "133  A system, method and computer program product ...   \n",
      "134  A method and system arrangement are disclosed ...   \n",
      "135  A method and system for managing a large numbe...   \n",
      "136  A computer language translator that translates...   \n",
      "137  The present invention provides methods and sys...   \n",
      "138  The compiled code of a computer program is sto...   \n",
      "139  A graphics object can be expressed using proce...   \n",
      "140  The illustrative embodiments of this invention...   \n",
      "141  Generation of documentation from a computer re...   \n",
      "142  A request for a navigated content associated w...   \n",
      "143  A social networking system is configured to ge...   \n",
      "144  A list of constructs is displayed on a user in...   \n",
      "145  A data processing device comprises processing ...   \n",
      "146  A network analysis system provides for a user-...   \n",
      "147  Associating hosts with subscriber and service ...   \n",
      "148  A cloud computing interface includes a high-le...   \n",
      "149  Embodiments relate to systems and methods for ...   \n",
      "\n",
      "                                                Claims  \n",
      "0    1. A method for installing a software onto an ...  \n",
      "1    1. A computer-implemented method comprising: d...  \n",
      "2    1. A computer language translator for translat...  \n",
      "3    1. A computing device-implemented method compr...  \n",
      "4                                                       \n",
      "5    1. A system for editing both a webpage documen...  \n",
      "6    1. A computing device, comprising: a memory mo...  \n",
      "7    1. A method, implemented in a computing device...  \n",
      "8    1. A method for optimizing a program, comprisi...  \n",
      "9    1. A credit control server, comprising: a rati...  \n",
      "10                                                      \n",
      "11                                                      \n",
      "12                                                      \n",
      "13   1. One or more tangible computer storage devic...  \n",
      "14                                                      \n",
      "15                                                      \n",
      "16   1. A method of distributed computing, comprisi...  \n",
      "17   1. A computer-implemented method comprising: r...  \n",
      "18   1. At a computer system, the computer system i...  \n",
      "19                                                      \n",
      "20   1. A computer storage memory having computer-e...  \n",
      "21                                                      \n",
      "22                                                      \n",
      "23                                                      \n",
      "24   1. A computer implemented method for defining ...  \n",
      "25   1. A method to dispatch service resources comp...  \n",
      "26                                                      \n",
      "27                                                      \n",
      "28   1. A method for remote device access, the meth...  \n",
      "29                                                      \n",
      "..                                                 ...  \n",
      "120  1. A computer storage memory having computer-e...  \n",
      "121                                                     \n",
      "122                                                     \n",
      "123                                                     \n",
      "124  1. A computer implemented method for defining ...  \n",
      "125  1. A method to dispatch service resources comp...  \n",
      "126                                                     \n",
      "127                                                     \n",
      "128  1. A method for remote device access, the meth...  \n",
      "129                                                     \n",
      "130  1. An apparatus comprising: a memory to store ...  \n",
      "131                                                     \n",
      "132  1. A method for remote device access, the meth...  \n",
      "133  1. A system for processing user search request...  \n",
      "134  1. A method for generating a software applicat...  \n",
      "135  1. A method for receiving and executing, on on...  \n",
      "136  1. A computer language translator for translat...  \n",
      "137  1. A method comprising: receiving, by a server...  \n",
      "138  1. A system comprising: a computing device; op...  \n",
      "139                                                     \n",
      "140                                                     \n",
      "141  1. A method executed by a processor for docume...  \n",
      "142  1. A system for usage-based offline caching co...  \n",
      "143  1. A method comprising: receiving, from an adm...  \n",
      "144  1. A computer-implemented method for inserting...  \n",
      "145  1. A data processing device comprising: a disp...  \n",
      "146                                                     \n",
      "147  1. A method of associating a host with a requi...  \n",
      "148                                                     \n",
      "149  1. A method comprising: hosting, by a collabor...  \n",
      "\n",
      "[150 rows x 4 columns]\n"
=======
      "                                                 Link  \\\n",
      "0   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "1   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "2   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "3   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "4   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "5   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "6   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "7   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "8   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "9   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "10  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "11  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "12  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "13  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "14  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "15  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "16  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "17  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "18  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "19  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "20  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "21  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "22  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "23  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "24  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "25  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "26  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "27  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "28  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "29  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "30  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "31  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "32  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "33  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "34  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "35  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "36  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "37  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "38  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "39  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "40  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "41  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "42  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "43  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "44  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "45  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "46  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "47  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "48  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "49  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "\n",
      "                                              Heading  \\\n",
      "0   Pattern modeling methods and systemsPattern mo...   \n",
      "1   System for translating diverse programming lan...   \n",
      "2   Method and system for data centric heap profil...   \n",
      "3   Intelligent offline caching of non-navigated c...   \n",
      "4   Record based code structureRecord based code s...   \n",
      "5   Procedurally expressing graphic objects for we...   \n",
      "6   Integrating map-reduce into a distributed rela...   \n",
      "7   Garbage collection implemented in hardwareGarb...   \n",
      "8   System and method for automatic hardware and s...   \n",
      "9   Program system, and method and system arrangem...   \n",
      "10  User-configurable network performance monitors...   \n",
      "11  Beverage dispensing apparatusBeverage dispensi...   \n",
      "12  Method and system for dynamic digital rights b...   \n",
      "13  Documentation generation from a computer reada...   \n",
      "14  Method and system for simplifying distributed ...   \n",
      "15  Client program executable on multiple heteroge...   \n",
      "16  Methods and systems to avoid unproductive disp...   \n",
      "17  Systems and methods for managing a collaborati...   \n",
      "18  Systems, methods and apparatus for modeling, s...   \n",
      "19  Embedded distributed computing solutionsEmbedd...   \n",
      "20  Facilitating client server interactionFacilita...   \n",
      "21  Method for testing connectivity of software ap...   \n",
      "22  Automated customer incident report management ...   \n",
      "23  Method and system for remote device access in ...   \n",
      "24  Scripting bridgeScripting bridgeScripting brid...   \n",
      "25  Static extensibility models with dynamic langu...   \n",
      "26  Automated lamp stack migrationAutomated lamp s...   \n",
      "27  Semantic neural network for aggregating query ...   \n",
      "28  Method and device for processing data for gene...   \n",
      "29  Hierarchically scoped resettable variables in ...   \n",
      "30  Control surfaces for a technical computing env...   \n",
      "31  Cross language object sharingCross language ob...   \n",
      "32  System and a method for web-based editing of d...   \n",
      "33  Method and system for remote device access in ...   \n",
      "34  Associating hosts with subscriber and service ...   \n",
      "35  Pattern modeling methods and systemsPattern mo...   \n",
      "36  User co-routine interface for customizing SIP ...   \n",
      "37  Systems and methods for producing a cooling be...   \n",
      "38  Robot task commander with extensible programmi...   \n",
      "39  Method for invoking UOML instructionsMethod fo...   \n",
      "40  System and method for developing, deploying, m...   \n",
      "41  Method and an apparatus to conduct software re...   \n",
      "42  System for translating diverse programming lan...   \n",
      "43  Dynamic centralized unit determination in a cr...   \n",
      "44  Methods and systems for dynamically generating...   \n",
      "45  Composition studio to develop and maintain sur...   \n",
      "46  Replacement of build to order parts with post ...   \n",
      "47  Client-side and server-side unified validation...   \n",
      "48  Optimizing program by reusing execution result...   \n",
      "49  Flow-optimization system and method for cloud ...   \n",
      "\n",
      "                                             Abstract  \\\n",
      "0   A list of constructs is displayed on a user in...   \n",
      "1   A computer language translator that translates...   \n",
      "2   A method and system for data centric heap prof...   \n",
      "3   A request for a navigated content associated w...   \n",
      "4   The compiled code of a computer program is sto...   \n",
      "5   A graphics object can be expressed using proce...   \n",
      "6   A computer readable storage medium includes ex...   \n",
      "7   A computing device is provided and includes a ...   \n",
      "8   The present invention relates to a system and ...   \n",
      "9   A method and system arrangement are disclosed ...   \n",
      "10  A network analysis system provides for a user-...   \n",
      "11  A beverage dispensing apparatus may be adapted...   \n",
      "12  Methods and systems for dynamically bundling p...   \n",
      "13  Generation of documentation from a computer re...   \n",
      "14  A method and system for managing a large numbe...   \n",
      "15  A device receives a program that includes one ...   \n",
      "16  Methods and systems are disclosed to dispatch ...   \n",
      "17  Embodiments relate to systems and methods for ...   \n",
      "18  Systems, methods and apparatus are provided th...   \n",
      "19  Methods and Systems are provided for participa...   \n",
      "20  The apparatus includes a base client module an...   \n",
      "21  A method for verifying the connectivity of sof...   \n",
      "22  A social networking system is configured to ge...   \n",
      "23  A method, system and computer program product ...   \n",
      "24  A scripting bridge allows a developer to autom...   \n",
      "25  Various technologies and techniques are disclo...   \n",
      "26  Embodiments of the present invention provide a...   \n",
      "27  A system, method and computer program product ...   \n",
      "28  A data processing device comprises processing ...   \n",
      "29  The illustrative embodiments of this invention...   \n",
      "30  A technical computing environment may include ...   \n",
      "31  Methods, system, and computer storage media ar...   \n",
      "32  A method and a system for editing documents on...   \n",
      "33  A method, system and computer program product ...   \n",
      "34  Associating hosts with subscriber and service ...   \n",
      "35  In a computer-implemented method, models are d...   \n",
      "36  A method of using co-routines to implement a f...   \n",
      "37  A system for cooling a beverage and dispensing...   \n",
      "38  A system for developing distributed robot appl...   \n",
      "39  Embodiments of the present invention disclose ...   \n",
      "40  A system and method for developing, deploying,...   \n",
      "41  Some embodiments of a method and an apparatus ...   \n",
      "42  A computer language translator that translates...   \n",
      "43  A charging system includes a rating engine, a ...   \n",
      "44  The present invention provides methods and sys...   \n",
      "45  A system for generating a plurality of surveil...   \n",
      "46  An embedded imaging system for addressing burn...   \n",
      "47  A system and method for validating code on a c...   \n",
      "48  A technique for optimizing a program by reusin...   \n",
      "49  A cloud computing interface includes a high-le...   \n",
      "\n",
      "                                               Claims  \n",
      "0   1. A computer-implemented method for inserting...  \n",
      "1   1. A computer language translator for translat...  \n",
      "2   1. A method, implemented in a computing device...  \n",
      "3   1. A system for usage-based offline caching co...  \n",
      "4   1. A system comprising: a computing device; op...  \n",
      "5                                                      \n",
      "6                                                      \n",
      "7   1. A computing device, comprising: a memory mo...  \n",
      "8   1. A computer implemented method for defining ...  \n",
      "9   1. A method for generating a software applicat...  \n",
      "10                                                     \n",
      "11                                                     \n",
      "12                                                     \n",
      "13  1. A method executed by a processor for docume...  \n",
      "14  1. A method for receiving and executing, on on...  \n",
      "15  1. A computing device-implemented method compr...  \n",
      "16  1. A method to dispatch service resources comp...  \n",
      "17  1. A method comprising: hosting, by a collabor...  \n",
      "18                                                     \n",
      "19  1. A method of distributed computing, comprisi...  \n",
      "20                                                     \n",
      "21                                                     \n",
      "22  1. A method comprising: receiving, from an adm...  \n",
      "23  1. A method for remote device access, the meth...  \n",
      "24  1. At a computer system, the computer system i...  \n",
      "25  1. A computer storage memory having computer-e...  \n",
      "26                                                     \n",
      "27  1. A system for processing user search request...  \n",
      "28  1. A data processing device comprising: a disp...  \n",
      "29                                                     \n",
      "30  1. An apparatus comprising: a memory to store ...  \n",
      "31  1. One or more tangible computer storage devic...  \n",
      "32  1. A system for editing both a webpage documen...  \n",
      "33  1. A method for remote device access, the meth...  \n",
      "34  1. A method of associating a host with a requi...  \n",
      "35  1. A computer-implemented method comprising: d...  \n",
      "36                                                     \n",
      "37                                                     \n",
      "38                                                     \n",
      "39                                                     \n",
      "40                                                     \n",
      "41  1. A computer-implemented method comprising: r...  \n",
      "42  1. A computer language translator for translat...  \n",
      "43  1. A credit control server, comprising: a rati...  \n",
      "44  1. A method comprising: receiving, by a server...  \n",
      "45                                                     \n",
      "46  1. A method for installing a software onto an ...  \n",
      "47                                                     \n",
      "48  1. A method for optimizing a program, comprisi...  \n",
      "49                                                     \n"
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
     ]
    }
   ],
   "source": [
    "quote_page =['http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=1&f=S&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&Page=Prev&OS=ACLM/python&RS=ACLM/python', 'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=2&f=S&l=50&Query=ACLM%2Fpython+&d=PTXT'\n",
    ",'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=3&f=S&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&Page=Next&OS=ACLM/python&RS=ACLM/python']\n",
    "\n",
<<<<<<< HEAD
    "dfmerged = pd.DataFrame()\n",
    "\n",
=======
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
    "\n",
    "for quote in quote_page:\n",
    "    soup = getsoupfromlink(quote)\n",
    "    alllinks = extractlink(soup)\n",
    "    alllinks = remove_duplicates(alllinks)\n",
    "    #print (alllinks)\n",
    "    x = createdf(alllinks)\n",
    "    #print (df1)\n",
<<<<<<< HEAD
    "    x = x.reset_index(drop=True)\n",
    "    #dfmerged = dfmerged.add(x)\n",
    "    dfmerged = pd.concat([dfmerged, x], ignore_index = True)\n",
=======
    "    dfmerged = dfmerged.add(x)\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
    "\n",
    "print (dfmerged)"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 25,
=======
   "execution_count": 17,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=1&f=S&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&Page=Prev&OS=ACLM/python&RS=ACLM/python\n",
      "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=2&f=S&l=50&Query=ACLM%2Fpython+&d=PTXT\n",
      "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=3&f=S&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&Page=Next&OS=ACLM/python&RS=ACLM/python\n"
     ]
    }
   ],
   "source": [
    "for quote in quote_page:\n",
    "    print(quote)"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": null,
   "metadata": {},
   "outputs": [],
=======
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=0&p=2&f=S&l=50&Query=ACLM%2Fpython+&d=PTXT'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "source": [
    "quote_page[1]"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": null,
   "metadata": {},
   "outputs": [],
=======
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                 Link  \\\n",
      "0   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "1   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "2   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "3   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "4   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "5   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "6   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "7   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "8   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "9   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "10  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "11  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "12  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "13  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "14  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "15  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "16  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "17  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "18  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "19  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "20  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "21  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "22  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "23  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "24  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "25  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "26  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "27  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "28  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "29  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "30  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "31  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "32  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "33  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "34  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "35  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "36  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "37  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "38  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "39  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "40  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "41  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "42  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "43  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "44  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "45  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "46  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "47  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "48  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "49  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
      "\n",
      "                                              Heading  \\\n",
      "0                Pattern modeling methods and systems   \n",
      "1   System for translating diverse programming lan...   \n",
      "2   Method and system for data centric heap profiling   \n",
      "3   Intelligent offline caching of non-navigated c...   \n",
      "4                         Record based code structure   \n",
      "5   Procedurally expressing graphic objects for we...   \n",
      "6   Integrating map-reduce into a distributed rela...   \n",
      "7          Garbage collection implemented in hardware   \n",
      "8   System and method for automatic hardware and s...   \n",
      "9   Program system, and method and system arrangem...   \n",
      "10     User-configurable network performance monitors   \n",
      "11                      Beverage dispensing apparatus   \n",
      "12  Method and system for dynamic digital rights b...   \n",
      "13  Documentation generation from a computer reada...   \n",
      "14  Method and system for simplifying distributed ...   \n",
      "15  Client program executable on multiple heteroge...   \n",
      "16  Methods and systems to avoid unproductive disp...   \n",
      "17  Systems and methods for managing a collaborati...   \n",
      "18  Systems, methods and apparatus for modeling, s...   \n",
      "19           Embedded distributed computing solutions   \n",
      "20             Facilitating client server interaction   \n",
      "21  Method for testing connectivity of software ap...   \n",
      "22  Automated customer incident report management ...   \n",
      "23  Method and system for remote device access in ...   \n",
      "24                                   Scripting bridge   \n",
      "25  Static extensibility models with dynamic langu...   \n",
      "26                     Automated lamp stack migration   \n",
      "27  Semantic neural network for aggregating query ...   \n",
      "28  Method and device for processing data for gene...   \n",
      "29  Hierarchically scoped resettable variables in ...   \n",
      "30  Control surfaces for a technical computing env...   \n",
      "31                      Cross language object sharing   \n",
      "32  System and a method for web-based editing of d...   \n",
      "33  Method and system for remote device access in ...   \n",
      "34  Associating hosts with subscriber and service ...   \n",
      "35               Pattern modeling methods and systems   \n",
      "36  User co-routine interface for customizing SIP ...   \n",
      "37  Systems and methods for producing a cooling be...   \n",
      "38  Robot task commander with extensible programmi...   \n",
      "39              Method for invoking UOML instructions   \n",
      "40  System and method for developing, deploying, m...   \n",
      "41  Method and an apparatus to conduct software re...   \n",
      "42  System for translating diverse programming lan...   \n",
      "43  Dynamic centralized unit determination in a cr...   \n",
      "44  Methods and systems for dynamically generating...   \n",
      "45  Composition studio to develop and maintain sur...   \n",
      "46  Replacement of build to order parts with post ...   \n",
      "47     Client-side and server-side unified validation   \n",
      "48  Optimizing program by reusing execution result...   \n",
      "49  Flow-optimization system and method for cloud ...   \n",
      "\n",
      "                                             Abstract  \\\n",
      "0   A list of constructs is displayed on a user in...   \n",
      "1   A computer language translator that translates...   \n",
      "2   A method and system for data centric heap prof...   \n",
      "3   A request for a navigated content associated w...   \n",
      "4   The compiled code of a computer program is sto...   \n",
      "5   A graphics object can be expressed using proce...   \n",
      "6   A computer readable storage medium includes ex...   \n",
      "7   A computing device is provided and includes a ...   \n",
      "8   The present invention relates to a system and ...   \n",
      "9   A method and system arrangement are disclosed ...   \n",
      "10  A network analysis system provides for a user-...   \n",
      "11  A beverage dispensing apparatus may be adapted...   \n",
      "12  Methods and systems for dynamically bundling p...   \n",
      "13  Generation of documentation from a computer re...   \n",
      "14  A method and system for managing a large numbe...   \n",
      "15  A device receives a program that includes one ...   \n",
      "16  Methods and systems are disclosed to dispatch ...   \n",
      "17  Embodiments relate to systems and methods for ...   \n",
      "18  Systems, methods and apparatus are provided th...   \n",
      "19  Methods and Systems are provided for participa...   \n",
      "20  The apparatus includes a base client module an...   \n",
      "21  A method for verifying the connectivity of sof...   \n",
      "22  A social networking system is configured to ge...   \n",
      "23  A method, system and computer program product ...   \n",
      "24  A scripting bridge allows a developer to autom...   \n",
      "25  Various technologies and techniques are disclo...   \n",
      "26  Embodiments of the present invention provide a...   \n",
      "27  A system, method and computer program product ...   \n",
      "28  A data processing device comprises processing ...   \n",
      "29  The illustrative embodiments of this invention...   \n",
      "30  A technical computing environment may include ...   \n",
      "31  Methods, system, and computer storage media ar...   \n",
      "32  A method and a system for editing documents on...   \n",
      "33  A method, system and computer program product ...   \n",
      "34  Associating hosts with subscriber and service ...   \n",
      "35  In a computer-implemented method, models are d...   \n",
      "36  A method of using co-routines to implement a f...   \n",
      "37  A system for cooling a beverage and dispensing...   \n",
      "38  A system for developing distributed robot appl...   \n",
      "39  Embodiments of the present invention disclose ...   \n",
      "40  A system and method for developing, deploying,...   \n",
      "41  Some embodiments of a method and an apparatus ...   \n",
      "42  A computer language translator that translates...   \n",
      "43  A charging system includes a rating engine, a ...   \n",
      "44  The present invention provides methods and sys...   \n",
      "45  A system for generating a plurality of surveil...   \n",
      "46  An embedded imaging system for addressing burn...   \n",
      "47  A system and method for validating code on a c...   \n",
      "48  A technique for optimizing a program by reusin...   \n",
      "49  A cloud computing interface includes a high-le...   \n",
      "\n",
      "                                               Claims  \n",
      "0   1. A computer-implemented method for inserting...  \n",
      "1   1. A computer language translator for translat...  \n",
      "2   1. A method, implemented in a computing device...  \n",
      "3   1. A system for usage-based offline caching co...  \n",
      "4   1. A system comprising: a computing device; op...  \n",
      "5                                                      \n",
      "6                                                      \n",
      "7   1. A computing device, comprising: a memory mo...  \n",
      "8   1. A computer implemented method for defining ...  \n",
      "9   1. A method for generating a software applicat...  \n",
      "10                                                     \n",
      "11                                                     \n",
      "12                                                     \n",
      "13  1. A method executed by a processor for docume...  \n",
      "14  1. A method for receiving and executing, on on...  \n",
      "15  1. A computing device-implemented method compr...  \n",
      "16  1. A method to dispatch service resources comp...  \n",
      "17  1. A method comprising: hosting, by a collabor...  \n",
      "18                                                     \n",
      "19  1. A method of distributed computing, comprisi...  \n",
      "20                                                     \n",
      "21                                                     \n",
      "22  1. A method comprising: receiving, from an adm...  \n",
      "23  1. A method for remote device access, the meth...  \n",
      "24  1. At a computer system, the computer system i...  \n",
      "25  1. A computer storage memory having computer-e...  \n",
      "26                                                     \n",
      "27  1. A system for processing user search request...  \n",
      "28  1. A data processing device comprising: a disp...  \n",
      "29                                                     \n",
      "30  1. An apparatus comprising: a memory to store ...  \n",
      "31  1. One or more tangible computer storage devic...  \n",
      "32  1. A system for editing both a webpage documen...  \n",
      "33  1. A method for remote device access, the meth...  \n",
      "34  1. A method of associating a host with a requi...  \n",
      "35  1. A computer-implemented method comprising: d...  \n",
      "36                                                     \n",
      "37                                                     \n",
      "38                                                     \n",
      "39                                                     \n",
      "40                                                     \n",
      "41  1. A computer-implemented method comprising: r...  \n",
      "42  1. A computer language translator for translat...  \n",
      "43  1. A credit control server, comprising: a rati...  \n",
      "44  1. A method comprising: receiving, by a server...  \n",
      "45                                                     \n",
      "46  1. A method for installing a software onto an ...  \n",
      "47                                                     \n",
      "48  1. A method for optimizing a program, comprisi...  \n",
      "49                                                     \n"
     ]
    }
   ],
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "source": [
    "\n",
    "soup = getsoupfromlink(quote_page[1])\n",
    "alllinks = extractlink(soup)\n",
    "alllinks = remove_duplicates(alllinks)\n",
    "#print (alllinks)\n",
    "df1 = createdf(alllinks)\n",
    "print (df1)\n"
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfmerged.to_csv(\"test.txt\", sep = \"|\", encoding='utf-8')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from collections import Counter\n",
    "\n",
    "def splitplay (test):\n",
    "    x = Counter(test.split()).most_common(1)\n",
    "    return x[0][0]\n",
    "\n",
    "dfmerged['freqofwords'] = dfmerged['Abstract'].apply(splitplay)\n",
    "\n",
    "dfmerged['freqofwords'] \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
=======
   "execution_count": 27,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Link</th>\n",
       "      <th>Heading</th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Claims</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Replacement of build to order parts with post ...</td>\n",
       "      <td>An embedded imaging system for addressing burn...</td>\n",
       "      <td>1. A method for installing a software onto an ...</td>\n",
=======
       "      <td>Pattern modeling methods and systemsPattern mo...</td>\n",
       "      <td>A list of constructs is displayed on a user in...</td>\n",
       "      <td>1. A computer-implemented method for inserting...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Pattern modeling methods and systems</td>\n",
       "      <td>In a computer-implemented method, models are d...</td>\n",
       "      <td>1. A computer-implemented method comprising: d...</td>\n",
=======
       "      <td>System for translating diverse programming lan...</td>\n",
       "      <td>A computer language translator that translates...</td>\n",
       "      <td>1. A computer language translator for translat...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>System for translating diverse programming lan...</td>\n",
       "      <td>A computer language translator that translates...</td>\n",
       "      <td>1. A computer language translator for translat...</td>\n",
=======
       "      <td>Method and system for data centric heap profil...</td>\n",
       "      <td>A method and system for data centric heap prof...</td>\n",
       "      <td>1. A method, implemented in a computing device...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Client program executable on multiple heteroge...</td>\n",
       "      <td>A device receives a program that includes one ...</td>\n",
       "      <td>1. A computing device-implemented method compr...</td>\n",
=======
       "      <td>Intelligent offline caching of non-navigated c...</td>\n",
       "      <td>A request for a navigated content associated w...</td>\n",
       "      <td>1. A system for usage-based offline caching co...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Systems, methods and apparatus for modeling, s...</td>\n",
       "      <td>Systems, methods and apparatus are provided th...</td>\n",
       "      <td></td>\n",
=======
       "      <td>Record based code structureRecord based code s...</td>\n",
       "      <td>The compiled code of a computer program is sto...</td>\n",
       "      <td>1. A system comprising: a computing device; op...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>System and a method for web-based editing of d...</td>\n",
       "      <td>A method and a system for editing documents on...</td>\n",
       "      <td>1. A system for editing both a webpage documen...</td>\n",
=======
       "      <td>Procedurally expressing graphic objects for we...</td>\n",
       "      <td>A graphics object can be expressed using proce...</td>\n",
       "      <td></td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Garbage collection implemented in hardware</td>\n",
       "      <td>A computing device is provided and includes a ...</td>\n",
       "      <td>1. A computing device, comprising: a memory mo...</td>\n",
=======
       "      <td>Integrating map-reduce into a distributed rela...</td>\n",
       "      <td>A computer readable storage medium includes ex...</td>\n",
       "      <td></td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Method and system for data centric heap profiling</td>\n",
       "      <td>A method and system for data centric heap prof...</td>\n",
       "      <td>1. A method, implemented in a computing device...</td>\n",
=======
       "      <td>Garbage collection implemented in hardwareGarb...</td>\n",
       "      <td>A computing device is provided and includes a ...</td>\n",
       "      <td>1. A computing device, comprising: a memory mo...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Optimizing program by reusing execution result...</td>\n",
       "      <td>A technique for optimizing a program by reusin...</td>\n",
       "      <td>1. A method for optimizing a program, comprisi...</td>\n",
=======
       "      <td>System and method for automatic hardware and s...</td>\n",
       "      <td>The present invention relates to a system and ...</td>\n",
       "      <td>1. A computer implemented method for defining ...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Dynamic centralized unit determination in a cr...</td>\n",
       "      <td>A charging system includes a rating engine, a ...</td>\n",
       "      <td>1. A credit control server, comprising: a rati...</td>\n",
=======
       "      <td>Program system, and method and system arrangem...</td>\n",
       "      <td>A method and system arrangement are disclosed ...</td>\n",
       "      <td>1. A method for generating a software applicat...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Method for invoking UOML instructions</td>\n",
       "      <td>Embodiments of the present invention disclose ...</td>\n",
=======
       "      <td>User-configurable network performance monitors...</td>\n",
       "      <td>A network analysis system provides for a user-...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Robot task commander with extensible programmi...</td>\n",
       "      <td>A system for developing distributed robot appl...</td>\n",
=======
       "      <td>Beverage dispensing apparatusBeverage dispensi...</td>\n",
       "      <td>A beverage dispensing apparatus may be adapted...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Beverage dispensing apparatus</td>\n",
       "      <td>A beverage dispensing apparatus may be adapted...</td>\n",
=======
       "      <td>Method and system for dynamic digital rights b...</td>\n",
       "      <td>Methods and systems for dynamically bundling p...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Cross language object sharing</td>\n",
       "      <td>Methods, system, and computer storage media ar...</td>\n",
       "      <td>1. One or more tangible computer storage devic...</td>\n",
=======
       "      <td>Documentation generation from a computer reada...</td>\n",
       "      <td>Generation of documentation from a computer re...</td>\n",
       "      <td>1. A method executed by a processor for docume...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Automated lamp stack migration</td>\n",
       "      <td>Embodiments of the present invention provide a...</td>\n",
       "      <td></td>\n",
=======
       "      <td>Method and system for simplifying distributed ...</td>\n",
       "      <td>A method and system for managing a large numbe...</td>\n",
       "      <td>1. A method for receiving and executing, on on...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Method and system for dynamic digital rights b...</td>\n",
       "      <td>Methods and systems for dynamically bundling p...</td>\n",
       "      <td></td>\n",
=======
       "      <td>Client program executable on multiple heteroge...</td>\n",
       "      <td>A device receives a program that includes one ...</td>\n",
       "      <td>1. A computing device-implemented method compr...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Embedded distributed computing solutions</td>\n",
       "      <td>Methods and Systems are provided for participa...</td>\n",
       "      <td>1. A method of distributed computing, comprisi...</td>\n",
=======
       "      <td>Methods and systems to avoid unproductive disp...</td>\n",
       "      <td>Methods and systems are disclosed to dispatch ...</td>\n",
       "      <td>1. A method to dispatch service resources comp...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Method and an apparatus to conduct software re...</td>\n",
       "      <td>Some embodiments of a method and an apparatus ...</td>\n",
       "      <td>1. A computer-implemented method comprising: r...</td>\n",
=======
       "      <td>Systems and methods for managing a collaborati...</td>\n",
       "      <td>Embodiments relate to systems and methods for ...</td>\n",
       "      <td>1. A method comprising: hosting, by a collabor...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Scripting bridge</td>\n",
       "      <td>A scripting bridge allows a developer to autom...</td>\n",
       "      <td>1. At a computer system, the computer system i...</td>\n",
=======
       "      <td>Systems, methods and apparatus for modeling, s...</td>\n",
       "      <td>Systems, methods and apparatus are provided th...</td>\n",
       "      <td></td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>User co-routine interface for customizing SIP ...</td>\n",
       "      <td>A method of using co-routines to implement a f...</td>\n",
       "      <td></td>\n",
=======
       "      <td>Embedded distributed computing solutionsEmbedd...</td>\n",
       "      <td>Methods and Systems are provided for participa...</td>\n",
       "      <td>1. A method of distributed computing, comprisi...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Static extensibility models with dynamic langu...</td>\n",
       "      <td>Various technologies and techniques are disclo...</td>\n",
       "      <td>1. A computer storage memory having computer-e...</td>\n",
=======
       "      <td>Facilitating client server interactionFacilita...</td>\n",
       "      <td>The apparatus includes a base client module an...</td>\n",
       "      <td></td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Client-side and server-side unified validation</td>\n",
       "      <td>A system and method for validating code on a c...</td>\n",
=======
       "      <td>Method for testing connectivity of software ap...</td>\n",
       "      <td>A method for verifying the connectivity of sof...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>System and method for developing, deploying, m...</td>\n",
       "      <td>A system and method for developing, deploying,...</td>\n",
       "      <td></td>\n",
=======
       "      <td>Automated customer incident report management ...</td>\n",
       "      <td>A social networking system is configured to ge...</td>\n",
       "      <td>1. A method comprising: receiving, from an adm...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Method for testing connectivity of software ap...</td>\n",
       "      <td>A method for verifying the connectivity of sof...</td>\n",
       "      <td></td>\n",
=======
       "      <td>Method and system for remote device access in ...</td>\n",
       "      <td>A method, system and computer program product ...</td>\n",
       "      <td>1. A method for remote device access, the meth...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>System and method for automatic hardware and s...</td>\n",
       "      <td>The present invention relates to a system and ...</td>\n",
       "      <td>1. A computer implemented method for defining ...</td>\n",
=======
       "      <td>Scripting bridgeScripting bridgeScripting brid...</td>\n",
       "      <td>A scripting bridge allows a developer to autom...</td>\n",
       "      <td>1. At a computer system, the computer system i...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Methods and systems to avoid unproductive disp...</td>\n",
       "      <td>Methods and systems are disclosed to dispatch ...</td>\n",
       "      <td>1. A method to dispatch service resources comp...</td>\n",
=======
       "      <td>Static extensibility models with dynamic langu...</td>\n",
       "      <td>Various technologies and techniques are disclo...</td>\n",
       "      <td>1. A computer storage memory having computer-e...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Composition studio to develop and maintain sur...</td>\n",
       "      <td>A system for generating a plurality of surveil...</td>\n",
=======
       "      <td>Automated lamp stack migrationAutomated lamp s...</td>\n",
       "      <td>Embodiments of the present invention provide a...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Integrating map-reduce into a distributed rela...</td>\n",
       "      <td>A computer readable storage medium includes ex...</td>\n",
       "      <td></td>\n",
=======
       "      <td>Semantic neural network for aggregating query ...</td>\n",
       "      <td>A system, method and computer program product ...</td>\n",
       "      <td>1. A system for processing user search request...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Method and system for remote device access in ...</td>\n",
       "      <td>A method, system and computer program product ...</td>\n",
       "      <td>1. A method for remote device access, the meth...</td>\n",
=======
       "      <td>Method and device for processing data for gene...</td>\n",
       "      <td>A data processing device comprises processing ...</td>\n",
       "      <td>1. A data processing device comprising: a disp...</td>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
<<<<<<< HEAD
       "      <td>Facilitating client server interaction</td>\n",
       "      <td>The apparatus includes a base client module an...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Static extensibility models with dynamic langu...</td>\n",
       "      <td>Various technologies and techniques are disclo...</td>\n",
       "      <td>1. A computer storage memory having computer-e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Client-side and server-side unified validation</td>\n",
       "      <td>A system and method for validating code on a c...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>System and method for developing, deploying, m...</td>\n",
       "      <td>A system and method for developing, deploying,...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method for testing connectivity of software ap...</td>\n",
       "      <td>A method for verifying the connectivity of sof...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>System and method for automatic hardware and s...</td>\n",
       "      <td>The present invention relates to a system and ...</td>\n",
       "      <td>1. A computer implemented method for defining ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Methods and systems to avoid unproductive disp...</td>\n",
       "      <td>Methods and systems are disclosed to dispatch ...</td>\n",
       "      <td>1. A method to dispatch service resources comp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Composition studio to develop and maintain sur...</td>\n",
       "      <td>A system for generating a plurality of surveil...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Integrating map-reduce into a distributed rela...</td>\n",
       "      <td>A computer readable storage medium includes ex...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method and system for remote device access in ...</td>\n",
       "      <td>A method, system and computer program product ...</td>\n",
       "      <td>1. A method for remote device access, the meth...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Facilitating client server interaction</td>\n",
       "      <td>The apparatus includes a base client module an...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Control surfaces for a technical computing env...</td>\n",
       "      <td>A technical computing environment may include ...</td>\n",
       "      <td>1. An apparatus comprising: a memory to store ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
=======
       "      <td>Hierarchically scoped resettable variables in ...</td>\n",
       "      <td>The illustrative embodiments of this invention...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Control surfaces for a technical computing env...</td>\n",
       "      <td>A technical computing environment may include ...</td>\n",
       "      <td>1. An apparatus comprising: a memory to store ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Cross language object sharingCross language ob...</td>\n",
       "      <td>Methods, system, and computer storage media ar...</td>\n",
       "      <td>1. One or more tangible computer storage devic...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>System and a method for web-based editing of d...</td>\n",
       "      <td>A method and a system for editing documents on...</td>\n",
       "      <td>1. A system for editing both a webpage documen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method and system for remote device access in ...</td>\n",
       "      <td>A method, system and computer program product ...</td>\n",
       "      <td>1. A method for remote device access, the meth...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Associating hosts with subscriber and service ...</td>\n",
       "      <td>Associating hosts with subscriber and service ...</td>\n",
       "      <td>1. A method of associating a host with a requi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Pattern modeling methods and systemsPattern mo...</td>\n",
       "      <td>In a computer-implemented method, models are d...</td>\n",
       "      <td>1. A computer-implemented method comprising: d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>User co-routine interface for customizing SIP ...</td>\n",
       "      <td>A method of using co-routines to implement a f...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Systems and methods for producing a cooling be...</td>\n",
       "      <td>A system for cooling a beverage and dispensing...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
<<<<<<< HEAD
       "      <th>132</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method and system for remote device access in ...</td>\n",
       "      <td>A method, system and computer program product ...</td>\n",
       "      <td>1. A method for remote device access, the meth...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Semantic neural network for aggregating query ...</td>\n",
       "      <td>A system, method and computer program product ...</td>\n",
       "      <td>1. A system for processing user search request...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Program system, and method and system arrangem...</td>\n",
       "      <td>A method and system arrangement are disclosed ...</td>\n",
       "      <td>1. A method for generating a software applicat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method and system for simplifying distributed ...</td>\n",
       "      <td>A method and system for managing a large numbe...</td>\n",
       "      <td>1. A method for receiving and executing, on on...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
=======
       "      <th>38</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Robot task commander with extensible programmi...</td>\n",
       "      <td>A system for developing distributed robot appl...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method for invoking UOML instructionsMethod fo...</td>\n",
       "      <td>Embodiments of the present invention disclose ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>System and method for developing, deploying, m...</td>\n",
       "      <td>A system and method for developing, deploying,...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method and an apparatus to conduct software re...</td>\n",
       "      <td>Some embodiments of a method and an apparatus ...</td>\n",
       "      <td>1. A computer-implemented method comprising: r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>System for translating diverse programming lan...</td>\n",
       "      <td>A computer language translator that translates...</td>\n",
       "      <td>1. A computer language translator for translat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
<<<<<<< HEAD
       "      <th>137</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Methods and systems for dynamically generating...</td>\n",
       "      <td>The present invention provides methods and sys...</td>\n",
       "      <td>1. A method comprising: receiving, by a server...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Record based code structure</td>\n",
       "      <td>The compiled code of a computer program is sto...</td>\n",
       "      <td>1. A system comprising: a computing device; op...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Procedurally expressing graphic objects for we...</td>\n",
       "      <td>A graphics object can be expressed using proce...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Hierarchically scoped resettable variables in ...</td>\n",
       "      <td>The illustrative embodiments of this invention...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Documentation generation from a computer reada...</td>\n",
       "      <td>Generation of documentation from a computer re...</td>\n",
       "      <td>1. A method executed by a processor for docume...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Intelligent offline caching of non-navigated c...</td>\n",
       "      <td>A request for a navigated content associated w...</td>\n",
       "      <td>1. A system for usage-based offline caching co...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Automated customer incident report management ...</td>\n",
       "      <td>A social networking system is configured to ge...</td>\n",
       "      <td>1. A method comprising: receiving, from an adm...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Pattern modeling methods and systems</td>\n",
       "      <td>A list of constructs is displayed on a user in...</td>\n",
       "      <td>1. A computer-implemented method for inserting...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Method and device for processing data for gene...</td>\n",
       "      <td>A data processing device comprises processing ...</td>\n",
       "      <td>1. A data processing device comprising: a disp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>User-configurable network performance monitors</td>\n",
       "      <td>A network analysis system provides for a user-...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Associating hosts with subscriber and service ...</td>\n",
       "      <td>Associating hosts with subscriber and service ...</td>\n",
       "      <td>1. A method of associating a host with a requi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
=======
       "      <th>43</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Dynamic centralized unit determination in a cr...</td>\n",
       "      <td>A charging system includes a rating engine, a ...</td>\n",
       "      <td>1. A credit control server, comprising: a rati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Methods and systems for dynamically generating...</td>\n",
       "      <td>The present invention provides methods and sys...</td>\n",
       "      <td>1. A method comprising: receiving, by a server...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Composition studio to develop and maintain sur...</td>\n",
       "      <td>A system for generating a plurality of surveil...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Replacement of build to order parts with post ...</td>\n",
       "      <td>An embedded imaging system for addressing burn...</td>\n",
       "      <td>1. A method for installing a software onto an ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Client-side and server-side unified validation...</td>\n",
       "      <td>A system and method for validating code on a c...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Optimizing program by reusing execution result...</td>\n",
       "      <td>A technique for optimizing a program by reusin...</td>\n",
       "      <td>1. A method for optimizing a program, comprisi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Flow-optimization system and method for cloud ...</td>\n",
       "      <td>A cloud computing interface includes a high-le...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
<<<<<<< HEAD
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>http://patft.uspto.gov/netacgi/nph-Parser?Sect...</td>\n",
       "      <td>Systems and methods for managing a collaborati...</td>\n",
       "      <td>Embodiments relate to systems and methods for ...</td>\n",
       "      <td>1. A method comprising: hosting, by a collabor...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>150 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  Link  \\\n",
       "0    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "1    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "2    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "3    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "4    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "5    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "6    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "7    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "8    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "9    http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "10   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "11   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "12   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "13   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "14   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "15   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "16   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "17   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "18   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "19   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "20   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "21   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "22   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "23   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "24   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "25   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "26   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "27   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "28   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "29   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "..                                                 ...   \n",
       "120  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "121  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "122  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "123  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "124  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "125  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "126  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "127  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "128  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "129  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "130  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "131  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "132  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "133  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "134  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "135  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "136  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "137  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "138  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "139  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "140  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "141  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "142  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "143  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "144  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "145  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "146  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "147  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "148  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "149  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "\n",
       "                                               Heading  \\\n",
       "0    Replacement of build to order parts with post ...   \n",
       "1                 Pattern modeling methods and systems   \n",
       "2    System for translating diverse programming lan...   \n",
       "3    Client program executable on multiple heteroge...   \n",
       "4    Systems, methods and apparatus for modeling, s...   \n",
       "5    System and a method for web-based editing of d...   \n",
       "6           Garbage collection implemented in hardware   \n",
       "7    Method and system for data centric heap profiling   \n",
       "8    Optimizing program by reusing execution result...   \n",
       "9    Dynamic centralized unit determination in a cr...   \n",
       "10               Method for invoking UOML instructions   \n",
       "11   Robot task commander with extensible programmi...   \n",
       "12                       Beverage dispensing apparatus   \n",
       "13                       Cross language object sharing   \n",
       "14                      Automated lamp stack migration   \n",
       "15   Method and system for dynamic digital rights b...   \n",
       "16            Embedded distributed computing solutions   \n",
       "17   Method and an apparatus to conduct software re...   \n",
       "18                                    Scripting bridge   \n",
       "19   User co-routine interface for customizing SIP ...   \n",
       "20   Static extensibility models with dynamic langu...   \n",
       "21      Client-side and server-side unified validation   \n",
       "22   System and method for developing, deploying, m...   \n",
       "23   Method for testing connectivity of software ap...   \n",
       "24   System and method for automatic hardware and s...   \n",
       "25   Methods and systems to avoid unproductive disp...   \n",
       "26   Composition studio to develop and maintain sur...   \n",
       "27   Integrating map-reduce into a distributed rela...   \n",
       "28   Method and system for remote device access in ...   \n",
       "29              Facilitating client server interaction   \n",
       "..                                                 ...   \n",
       "120  Static extensibility models with dynamic langu...   \n",
       "121     Client-side and server-side unified validation   \n",
       "122  System and method for developing, deploying, m...   \n",
       "123  Method for testing connectivity of software ap...   \n",
       "124  System and method for automatic hardware and s...   \n",
       "125  Methods and systems to avoid unproductive disp...   \n",
       "126  Composition studio to develop and maintain sur...   \n",
       "127  Integrating map-reduce into a distributed rela...   \n",
       "128  Method and system for remote device access in ...   \n",
       "129             Facilitating client server interaction   \n",
       "130  Control surfaces for a technical computing env...   \n",
       "131  Systems and methods for producing a cooling be...   \n",
       "132  Method and system for remote device access in ...   \n",
       "133  Semantic neural network for aggregating query ...   \n",
       "134  Program system, and method and system arrangem...   \n",
       "135  Method and system for simplifying distributed ...   \n",
       "136  System for translating diverse programming lan...   \n",
       "137  Methods and systems for dynamically generating...   \n",
       "138                        Record based code structure   \n",
       "139  Procedurally expressing graphic objects for we...   \n",
       "140  Hierarchically scoped resettable variables in ...   \n",
       "141  Documentation generation from a computer reada...   \n",
       "142  Intelligent offline caching of non-navigated c...   \n",
       "143  Automated customer incident report management ...   \n",
       "144               Pattern modeling methods and systems   \n",
       "145  Method and device for processing data for gene...   \n",
       "146     User-configurable network performance monitors   \n",
       "147  Associating hosts with subscriber and service ...   \n",
       "148  Flow-optimization system and method for cloud ...   \n",
       "149  Systems and methods for managing a collaborati...   \n",
       "\n",
       "                                              Abstract  \\\n",
       "0    An embedded imaging system for addressing burn...   \n",
       "1    In a computer-implemented method, models are d...   \n",
       "2    A computer language translator that translates...   \n",
       "3    A device receives a program that includes one ...   \n",
       "4    Systems, methods and apparatus are provided th...   \n",
       "5    A method and a system for editing documents on...   \n",
       "6    A computing device is provided and includes a ...   \n",
       "7    A method and system for data centric heap prof...   \n",
       "8    A technique for optimizing a program by reusin...   \n",
       "9    A charging system includes a rating engine, a ...   \n",
       "10   Embodiments of the present invention disclose ...   \n",
       "11   A system for developing distributed robot appl...   \n",
       "12   A beverage dispensing apparatus may be adapted...   \n",
       "13   Methods, system, and computer storage media ar...   \n",
       "14   Embodiments of the present invention provide a...   \n",
       "15   Methods and systems for dynamically bundling p...   \n",
       "16   Methods and Systems are provided for participa...   \n",
       "17   Some embodiments of a method and an apparatus ...   \n",
       "18   A scripting bridge allows a developer to autom...   \n",
       "19   A method of using co-routines to implement a f...   \n",
       "20   Various technologies and techniques are disclo...   \n",
       "21   A system and method for validating code on a c...   \n",
       "22   A system and method for developing, deploying,...   \n",
       "23   A method for verifying the connectivity of sof...   \n",
       "24   The present invention relates to a system and ...   \n",
       "25   Methods and systems are disclosed to dispatch ...   \n",
       "26   A system for generating a plurality of surveil...   \n",
       "27   A computer readable storage medium includes ex...   \n",
       "28   A method, system and computer program product ...   \n",
       "29   The apparatus includes a base client module an...   \n",
       "..                                                 ...   \n",
       "120  Various technologies and techniques are disclo...   \n",
       "121  A system and method for validating code on a c...   \n",
       "122  A system and method for developing, deploying,...   \n",
       "123  A method for verifying the connectivity of sof...   \n",
       "124  The present invention relates to a system and ...   \n",
       "125  Methods and systems are disclosed to dispatch ...   \n",
       "126  A system for generating a plurality of surveil...   \n",
       "127  A computer readable storage medium includes ex...   \n",
       "128  A method, system and computer program product ...   \n",
       "129  The apparatus includes a base client module an...   \n",
       "130  A technical computing environment may include ...   \n",
       "131  A system for cooling a beverage and dispensing...   \n",
       "132  A method, system and computer program product ...   \n",
       "133  A system, method and computer program product ...   \n",
       "134  A method and system arrangement are disclosed ...   \n",
       "135  A method and system for managing a large numbe...   \n",
       "136  A computer language translator that translates...   \n",
       "137  The present invention provides methods and sys...   \n",
       "138  The compiled code of a computer program is sto...   \n",
       "139  A graphics object can be expressed using proce...   \n",
       "140  The illustrative embodiments of this invention...   \n",
       "141  Generation of documentation from a computer re...   \n",
       "142  A request for a navigated content associated w...   \n",
       "143  A social networking system is configured to ge...   \n",
       "144  A list of constructs is displayed on a user in...   \n",
       "145  A data processing device comprises processing ...   \n",
       "146  A network analysis system provides for a user-...   \n",
       "147  Associating hosts with subscriber and service ...   \n",
       "148  A cloud computing interface includes a high-le...   \n",
       "149  Embodiments relate to systems and methods for ...   \n",
       "\n",
       "                                                Claims  \n",
       "0    1. A method for installing a software onto an ...  \n",
       "1    1. A computer-implemented method comprising: d...  \n",
       "2    1. A computer language translator for translat...  \n",
       "3    1. A computing device-implemented method compr...  \n",
       "4                                                       \n",
       "5    1. A system for editing both a webpage documen...  \n",
       "6    1. A computing device, comprising: a memory mo...  \n",
       "7    1. A method, implemented in a computing device...  \n",
       "8    1. A method for optimizing a program, comprisi...  \n",
       "9    1. A credit control server, comprising: a rati...  \n",
       "10                                                      \n",
       "11                                                      \n",
       "12                                                      \n",
       "13   1. One or more tangible computer storage devic...  \n",
       "14                                                      \n",
       "15                                                      \n",
       "16   1. A method of distributed computing, comprisi...  \n",
       "17   1. A computer-implemented method comprising: r...  \n",
       "18   1. At a computer system, the computer system i...  \n",
       "19                                                      \n",
       "20   1. A computer storage memory having computer-e...  \n",
       "21                                                      \n",
       "22                                                      \n",
       "23                                                      \n",
       "24   1. A computer implemented method for defining ...  \n",
       "25   1. A method to dispatch service resources comp...  \n",
       "26                                                      \n",
       "27                                                      \n",
       "28   1. A method for remote device access, the meth...  \n",
       "29                                                      \n",
       "..                                                 ...  \n",
       "120  1. A computer storage memory having computer-e...  \n",
       "121                                                     \n",
       "122                                                     \n",
       "123                                                     \n",
       "124  1. A computer implemented method for defining ...  \n",
       "125  1. A method to dispatch service resources comp...  \n",
       "126                                                     \n",
       "127                                                     \n",
       "128  1. A method for remote device access, the meth...  \n",
       "129                                                     \n",
       "130  1. An apparatus comprising: a memory to store ...  \n",
       "131                                                     \n",
       "132  1. A method for remote device access, the meth...  \n",
       "133  1. A system for processing user search request...  \n",
       "134  1. A method for generating a software applicat...  \n",
       "135  1. A method for receiving and executing, on on...  \n",
       "136  1. A computer language translator for translat...  \n",
       "137  1. A method comprising: receiving, by a server...  \n",
       "138  1. A system comprising: a computing device; op...  \n",
       "139                                                     \n",
       "140                                                     \n",
       "141  1. A method executed by a processor for docume...  \n",
       "142  1. A system for usage-based offline caching co...  \n",
       "143  1. A method comprising: receiving, from an adm...  \n",
       "144  1. A computer-implemented method for inserting...  \n",
       "145  1. A data processing device comprising: a disp...  \n",
       "146                                                     \n",
       "147  1. A method of associating a host with a requi...  \n",
       "148                                                     \n",
       "149  1. A method comprising: hosting, by a collabor...  \n",
       "\n",
       "[150 rows x 4 columns]"
      ]
     },
     "execution_count": 28,
=======
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Link  \\\n",
       "0   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "1   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "2   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "3   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "4   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "5   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "6   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "7   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "8   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "9   http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "10  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "11  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "12  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "13  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "14  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "15  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "16  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "17  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "18  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "19  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "20  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "21  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "22  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "23  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "24  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "25  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "26  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "27  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "28  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "29  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "30  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "31  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "32  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "33  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "34  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "35  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "36  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "37  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "38  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "39  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "40  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "41  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "42  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "43  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "44  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "45  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "46  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "47  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "48  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "49  http://patft.uspto.gov/netacgi/nph-Parser?Sect...   \n",
       "\n",
       "                                              Heading  \\\n",
       "0   Pattern modeling methods and systemsPattern mo...   \n",
       "1   System for translating diverse programming lan...   \n",
       "2   Method and system for data centric heap profil...   \n",
       "3   Intelligent offline caching of non-navigated c...   \n",
       "4   Record based code structureRecord based code s...   \n",
       "5   Procedurally expressing graphic objects for we...   \n",
       "6   Integrating map-reduce into a distributed rela...   \n",
       "7   Garbage collection implemented in hardwareGarb...   \n",
       "8   System and method for automatic hardware and s...   \n",
       "9   Program system, and method and system arrangem...   \n",
       "10  User-configurable network performance monitors...   \n",
       "11  Beverage dispensing apparatusBeverage dispensi...   \n",
       "12  Method and system for dynamic digital rights b...   \n",
       "13  Documentation generation from a computer reada...   \n",
       "14  Method and system for simplifying distributed ...   \n",
       "15  Client program executable on multiple heteroge...   \n",
       "16  Methods and systems to avoid unproductive disp...   \n",
       "17  Systems and methods for managing a collaborati...   \n",
       "18  Systems, methods and apparatus for modeling, s...   \n",
       "19  Embedded distributed computing solutionsEmbedd...   \n",
       "20  Facilitating client server interactionFacilita...   \n",
       "21  Method for testing connectivity of software ap...   \n",
       "22  Automated customer incident report management ...   \n",
       "23  Method and system for remote device access in ...   \n",
       "24  Scripting bridgeScripting bridgeScripting brid...   \n",
       "25  Static extensibility models with dynamic langu...   \n",
       "26  Automated lamp stack migrationAutomated lamp s...   \n",
       "27  Semantic neural network for aggregating query ...   \n",
       "28  Method and device for processing data for gene...   \n",
       "29  Hierarchically scoped resettable variables in ...   \n",
       "30  Control surfaces for a technical computing env...   \n",
       "31  Cross language object sharingCross language ob...   \n",
       "32  System and a method for web-based editing of d...   \n",
       "33  Method and system for remote device access in ...   \n",
       "34  Associating hosts with subscriber and service ...   \n",
       "35  Pattern modeling methods and systemsPattern mo...   \n",
       "36  User co-routine interface for customizing SIP ...   \n",
       "37  Systems and methods for producing a cooling be...   \n",
       "38  Robot task commander with extensible programmi...   \n",
       "39  Method for invoking UOML instructionsMethod fo...   \n",
       "40  System and method for developing, deploying, m...   \n",
       "41  Method and an apparatus to conduct software re...   \n",
       "42  System for translating diverse programming lan...   \n",
       "43  Dynamic centralized unit determination in a cr...   \n",
       "44  Methods and systems for dynamically generating...   \n",
       "45  Composition studio to develop and maintain sur...   \n",
       "46  Replacement of build to order parts with post ...   \n",
       "47  Client-side and server-side unified validation...   \n",
       "48  Optimizing program by reusing execution result...   \n",
       "49  Flow-optimization system and method for cloud ...   \n",
       "\n",
       "                                             Abstract  \\\n",
       "0   A list of constructs is displayed on a user in...   \n",
       "1   A computer language translator that translates...   \n",
       "2   A method and system for data centric heap prof...   \n",
       "3   A request for a navigated content associated w...   \n",
       "4   The compiled code of a computer program is sto...   \n",
       "5   A graphics object can be expressed using proce...   \n",
       "6   A computer readable storage medium includes ex...   \n",
       "7   A computing device is provided and includes a ...   \n",
       "8   The present invention relates to a system and ...   \n",
       "9   A method and system arrangement are disclosed ...   \n",
       "10  A network analysis system provides for a user-...   \n",
       "11  A beverage dispensing apparatus may be adapted...   \n",
       "12  Methods and systems for dynamically bundling p...   \n",
       "13  Generation of documentation from a computer re...   \n",
       "14  A method and system for managing a large numbe...   \n",
       "15  A device receives a program that includes one ...   \n",
       "16  Methods and systems are disclosed to dispatch ...   \n",
       "17  Embodiments relate to systems and methods for ...   \n",
       "18  Systems, methods and apparatus are provided th...   \n",
       "19  Methods and Systems are provided for participa...   \n",
       "20  The apparatus includes a base client module an...   \n",
       "21  A method for verifying the connectivity of sof...   \n",
       "22  A social networking system is configured to ge...   \n",
       "23  A method, system and computer program product ...   \n",
       "24  A scripting bridge allows a developer to autom...   \n",
       "25  Various technologies and techniques are disclo...   \n",
       "26  Embodiments of the present invention provide a...   \n",
       "27  A system, method and computer program product ...   \n",
       "28  A data processing device comprises processing ...   \n",
       "29  The illustrative embodiments of this invention...   \n",
       "30  A technical computing environment may include ...   \n",
       "31  Methods, system, and computer storage media ar...   \n",
       "32  A method and a system for editing documents on...   \n",
       "33  A method, system and computer program product ...   \n",
       "34  Associating hosts with subscriber and service ...   \n",
       "35  In a computer-implemented method, models are d...   \n",
       "36  A method of using co-routines to implement a f...   \n",
       "37  A system for cooling a beverage and dispensing...   \n",
       "38  A system for developing distributed robot appl...   \n",
       "39  Embodiments of the present invention disclose ...   \n",
       "40  A system and method for developing, deploying,...   \n",
       "41  Some embodiments of a method and an apparatus ...   \n",
       "42  A computer language translator that translates...   \n",
       "43  A charging system includes a rating engine, a ...   \n",
       "44  The present invention provides methods and sys...   \n",
       "45  A system for generating a plurality of surveil...   \n",
       "46  An embedded imaging system for addressing burn...   \n",
       "47  A system and method for validating code on a c...   \n",
       "48  A technique for optimizing a program by reusin...   \n",
       "49  A cloud computing interface includes a high-le...   \n",
       "\n",
       "                                               Claims  \n",
       "0   1. A computer-implemented method for inserting...  \n",
       "1   1. A computer language translator for translat...  \n",
       "2   1. A method, implemented in a computing device...  \n",
       "3   1. A system for usage-based offline caching co...  \n",
       "4   1. A system comprising: a computing device; op...  \n",
       "5                                                      \n",
       "6                                                      \n",
       "7   1. A computing device, comprising: a memory mo...  \n",
       "8   1. A computer implemented method for defining ...  \n",
       "9   1. A method for generating a software applicat...  \n",
       "10                                                     \n",
       "11                                                     \n",
       "12                                                     \n",
       "13  1. A method executed by a processor for docume...  \n",
       "14  1. A method for receiving and executing, on on...  \n",
       "15  1. A computing device-implemented method compr...  \n",
       "16  1. A method to dispatch service resources comp...  \n",
       "17  1. A method comprising: hosting, by a collabor...  \n",
       "18                                                     \n",
       "19  1. A method of distributed computing, comprisi...  \n",
       "20                                                     \n",
       "21                                                     \n",
       "22  1. A method comprising: receiving, from an adm...  \n",
       "23  1. A method for remote device access, the meth...  \n",
       "24  1. At a computer system, the computer system i...  \n",
       "25  1. A computer storage memory having computer-e...  \n",
       "26                                                     \n",
       "27  1. A system for processing user search request...  \n",
       "28  1. A data processing device comprising: a disp...  \n",
       "29                                                     \n",
       "30  1. An apparatus comprising: a memory to store ...  \n",
       "31  1. One or more tangible computer storage devic...  \n",
       "32  1. A system for editing both a webpage documen...  \n",
       "33  1. A method for remote device access, the meth...  \n",
       "34  1. A method of associating a host with a requi...  \n",
       "35  1. A computer-implemented method comprising: d...  \n",
       "36                                                     \n",
       "37                                                     \n",
       "38                                                     \n",
       "39                                                     \n",
       "40                                                     \n",
       "41  1. A computer-implemented method comprising: r...  \n",
       "42  1. A computer language translator for translat...  \n",
       "43  1. A credit control server, comprising: a rati...  \n",
       "44  1. A method comprising: receiving, by a server...  \n",
       "45                                                     \n",
       "46  1. A method for installing a software onto an ...  \n",
       "47                                                     \n",
       "48  1. A method for optimizing a program, comprisi...  \n",
       "49                                                     "
      ]
     },
     "execution_count": 27,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
<<<<<<< HEAD
    "dfmerged #= dfmerged.add(x)\n"
=======
    "dfmerged"
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   ]
  },
  {
   "cell_type": "code",
<<<<<<< HEAD
   "execution_count": 29,
=======
   "execution_count": 30,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
<<<<<<< HEAD
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=58&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=71&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=72&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=73&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=70&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=89&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=64&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=63&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=84&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=96&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=97&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=67&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=57&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=90&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=55&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=66&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=78&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=80&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=53&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=65&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=95&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=99&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=93&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=87&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=69&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=52&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=56&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=59&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=61&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=83&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=75&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=68&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=60&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=76&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=91&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=88&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=62&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=77&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=92&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=81&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=86&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=82&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=98&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=94&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=100&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python    3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=74&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=54&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=51&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=79&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.htm&r=85&p=2&f=G&l=50&d=PTXT&S1=(python.CLTX.+or+python.DCTX.)&OS=ACLM/python&RS=ACLM/python     3\n",
       "Name: Link, dtype: int64"
      ]
     },
     "execution_count": 29,
=======
       "0               the\n",
       "1          computer\n",
       "2                 a\n",
       "3               can\n",
       "4                of\n",
       "5                 a\n",
       "6        map-reduce\n",
       "7                 a\n",
       "8                 a\n",
       "9           program\n",
       "10              the\n",
       "11              the\n",
       "12                a\n",
       "13               of\n",
       "14                a\n",
       "15                a\n",
       "16                a\n",
       "17    collaboration\n",
       "18              and\n",
       "19              the\n",
       "20                a\n",
       "21         function\n",
       "22             node\n",
       "23                a\n",
       "24               to\n",
       "25               to\n",
       "26              the\n",
       "27              the\n",
       "28               in\n",
       "29                a\n",
       "30               to\n",
       "31              the\n",
       "32         document\n",
       "33                a\n",
       "34       subscriber\n",
       "35         selected\n",
       "36              the\n",
       "37                a\n",
       "38                a\n",
       "39              the\n",
       "40              and\n",
       "41                a\n",
       "42         computer\n",
       "43              the\n",
       "44              the\n",
       "45                a\n",
       "46         embedded\n",
       "47                a\n",
       "48                a\n",
       "49               to\n",
       "Name: freqofwords, dtype: object"
      ]
     },
     "execution_count": 30,
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
<<<<<<< HEAD
    "dfmerged.Link.value_counts()\n"
=======
    "from collections import Counter\n",
    "\n",
    "def splitplay (test):\n",
    "    x = Counter(test.split()).most_common(1)\n",
    "    return x[0][0]\n",
    "\n",
    "dfmerged['freqofwords'] = dfmerged['Abstract'].apply(splitplay)\n",
    "\n",
    "dfmerged['freqofwords'] \n"
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
<<<<<<< HEAD
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
=======
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
  }
 ],
 "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",
<<<<<<< HEAD
   "version": "3.6.2"
=======
   "version": "3.6.1"
>>>>>>> e3cc7dfb9339c287f75e8ddc97eb1b488e60845d
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}