HW5.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "'''\n",
    "The libraries we used:\n",
    "'''\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import math\n",
    "import networkx as nx\n",
    "import csv\n",
    "from statistics import median, mean\n",
    "import queue as Q\n",
    "import threading\n",
    "from numba import autojit\n",
    "import functs as fnc\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Research question 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Opening the file that countains the information about the edges of our graph."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "nodesfile = np.loadtxt('wiki-topcats-reduced.txt', delimiter=\"\\t\", dtype =int)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To see what kind of graph is contained in the file we've got we first check for self loops."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "777"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "self_count = 0\n",
    "for row in nodesfile:\n",
    "    if row[0] == row[1]:\n",
    "        self_count += 1\n",
    "self_count"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we're checking if our graph is directed by seeing if the first node occurs the same number of times in both columns. If the number of occurences is the same, we have a undirected graph. If not, its directed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "directed graph\n"
     ]
    }
   ],
   "source": [
    "dir_count1 = 0\n",
    "dir_count2 = 0\n",
    "for node1 in nodesfile:\n",
    "    if nodesfile[0][0] == node1[0]:\n",
    "        dir_count1 +=1\n",
    "    if nodesfile[0][0] == node1[1]:\n",
    "        dir_count2 +=1\n",
    "if dir_count1 != dir_count2:\n",
    "    print(\"directed graph\")\n",
    "else:\n",
    "    print(\"no directed graph\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we're creating the graph using the networkx library (as the TA's said on slack that we can use networkx for this purpose). We choose set the graph type to MultiDiGraph as we already prooved that there are self loops and that we have a directed graph. By creating the edges from our file, the nodes will automatically be created by networkx."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "graph = nx.MultiDiGraph()\n",
    "for nodes in nodesfile:\n",
    "    graph.add_edge(nodes[0], nodes[1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Name: \\nType: MultiDiGraph\\nNumber of nodes: 461193\\nNumber of edges: 2645247\\nAverage in degree:   5.7357\\nAverage out degree:   5.7357'"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nx.info(graph)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Getting the number of nodes by getting a list of unique values and the get the length of this list."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "461193"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "no_nodes = len(np.unique(nodesfile))\n",
    "no_nodes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The number of all edges we can also retrieve by seeing how many rows our array has, as every row represents one edge.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2645247"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "no_edges = len(nodesfile)\n",
    "no_edges"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We first tried to evaluate the number of edges and nodes directly from the given file. As the outputs above show, there are no differences in the number of edges we assumed and the number of edges counted by networkx. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Calculating the average degree by dividing the total number of edges (number of rows in our array) by the number of nodes (unique values in our array). As you can see here, the result of our calculation for the average doesn't differ lot from the output nx.info() gave us."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5.735661642739591"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avg_degree = no_edges/no_nodes\n",
    "avg_degree"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Calculating the density of our graph"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.2436602635647606e-05"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dens = (no_edges)/(no_nodes*(no_nodes-1))\n",
    "dens"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Calculating the density using the number of edges we read from the file earlier. As a value of 1 indicates a very dense graph and our result for the density is very low value, we conclude that it is a very sparse graph. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Research question 2\n",
    "\n",
    "First we have to do some preperation for our calculations of the block-ranking and the score of every article in every category.\n",
    "\n",
    "Creating a list of unique nodes to be used later. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "nodes = np.unique(nodesfile)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Creating a dictionary out of the given list by removing \"Category:\" and \"\\n\" and the splitting the lines. The first value of each line is the name of the category (we used it as key for our dictionary). The following values are the nodes contained in this category."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "categories = open('wiki-topcats-categories.txt', 'r', encoding = \"utf8\").readlines()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "cats = {}\n",
    "for line in categories:\n",
    "    temp = line.strip(\"Category:\").strip(\"\\n\").split()\n",
    "    temp[0] = temp[0].strip(\";\")\n",
    "    cats[temp[0]] = temp[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(cats)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Before we clean up our dictionary we already remove all categories that contain less than 3500 entries. This will spare us some time later on as there will be less values/categories we have to check."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "cats2 = {}\n",
    "for key in cats.keys():\n",
    "    if len(cats[key]) > 3500:\n",
    "        cats2[key] = cats[key]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(cats2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In the following step we created a second dictionary by checking if the values for every key are contained in our list of unique nodes we created earlier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for key in cats2.keys():\n",
    "    temp = []\n",
    "    for node in cats2[key]:\n",
    "        if int(node) in nodes:\n",
    "            temp.append(node)\n",
    "    cats2[key] = temp\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As you can see after cleaning up, six of our categories contain less then 3500 entry's again."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "i = 0\n",
    "for keys in cats2.keys():\n",
    "    if len(cats2[keys]) < 3500:\n",
    "        i+=1\n",
    "print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "fnc.save_dict(cats2,fileName=\"wiki-topcats-categories_modified.txt\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "cats2 = fnc.open_dict(\"wiki-topcats-categories_modified.txt\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In the cells below you can see the code we used to remove the pagenames of nodes that are not in our graph. To access the pagenames we created a dictionary where the key is the number of the node and the item is the name of the page."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pagenames = open('wiki-topcats-page-names.txt', 'r', encoding = \"utf8\").readlines()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pagenames[0].strip(\"\\n\").split()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pages_split = {}\n",
    "for page in pagenames:\n",
    "    pages_split[page.strip(\"\\n\").split()[0]] = \" \".join(page.strip(\"\\n\").split()[1:])\n",
    "pages = {}\n",
    "for node in nodes:\n",
    "    pages[node] = pages_split[str(node)]\n",
    "del pages_split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "fnc.save_dict(pages,fileName='wiki-topcats-page-names_modified.txt')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "For the usage in the further steps (search the distance between categories) we append the categories as attributes to the nodes. If the node belongs to a category, the value will be set to \"True\". Otherwise is will be \"False\". "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for key in cats2.keys():\n",
    "    for node in graph.nodes:\n",
    "        graph.node[node][key] = False\n",
    "    temp = cats2[key]\n",
    "    for node in temp:\n",
    "        graph.node[int(node)][key] = True"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Block-ranking. Calculating the shortest distance between the categories\n",
    "To speed up our calculations we tried to use _\"@autojit\"_ wich is part of the _\"numba\"_ library. This will convert our the code placed after _\"@autojit\"_ to a code that can be executed below the python executer and this way might speed up the process a lot as it can be executed directly on the CPU. Some functions of course can't be converted, what will lead to checking with the python instance and the libraries loaded. This again might lead to a slower process, as happened in our case. With usigh _\"@autojit\"_ our _BFS_ ran 814.86 seconds, without 710.23 seconds using \"Year_of_birth_unknown\" as starting category and 'English_television_actors' as target category. Using _threating_ we could drop the runtime for these both categories to 642.2 secornds. We have to state that this is not a 100% reliable result as we only once for every approach. Due to the time it takes for running, we could'nt test in more detail.\n",
    "\n",
    "As our C0 we used __\"Year_of_birth_unknown\"__. It is the smallest of our categories."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "smallest = fnc.run_bfs('Year_of_birth_unknown', graph, cats2.keys())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Save the result to file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "fnc.save_dict(smallest, 'results.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Opening the file that contains our results."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "smallest = fnc.open_dict('results.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "for key in smallest.keys():\n",
    "    if type(smallest[key]) != list:\n",
    "        smallest[key] = smallest[key].split()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Printing the results of our shortest paths from C0 to the other categories."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'English_footballers': ['4.0', '3.9053475935828876', '634'],\n",
       " 'The_Football_League_players': ['4.0', '3.9925412892914225', '637'],\n",
       " 'Association_football_forwards': ['4.0', '3.6680896478121663', '634'],\n",
       " 'Association_football_goalkeepers': ['4', '4.0021310602024505', '644'],\n",
       " 'Association_football_midfielders': ['4', '3.5982951518380393', '636'],\n",
       " 'Association_football_defenders': ['5.0', '4.298499464094319', '636'],\n",
       " 'Living_people': ['2.0', '2.0278494069107786', '587'],\n",
       " 'Harvard_University_alumni': ['3.0', '2.781068217874141', '637'],\n",
       " 'Major_League_Baseball_pitchers': ['5', '4.375734901122394', '644'],\n",
       " 'Members_of_the_United_Kingdom_Parliament_for_English_constituencies': ['3',\n",
       "  '3.1770334928229667',\n",
       "  '634'],\n",
       " 'Indian_films': ['5.0', '4.313947226709747', '637'],\n",
       " 'Year_of_death_missing': ['4.0', '3.3721294363256784', '606'],\n",
       " 'English_cricketers': ['4.0', '3.742138364779874', '620'],\n",
       " 'Year_of_birth_missing_(living_people)': ['3.0', '2.971518987341772', '636'],\n",
       " 'Rivers_of_Romania': ['4.0', '3.799357945425361', '635'],\n",
       " 'Main_Belt_asteroids': ['4.0', '4.100373731980779', '643'],\n",
       " 'Asteroids_named_for_people': ['4.0', '4.108427267847557', '637'],\n",
       " 'English-language_albums': ['4', '3.993096123207647', '640'],\n",
       " 'English_television_actors': ['4', '3.4275898520084565', '643'],\n",
       " 'British_films': ['4', '3.22710428798306', '642'],\n",
       " 'English-language_films': ['3', '2.9888594164456235', '636'],\n",
       " 'American_films': ['3.0', '3.1020084566596196', '644'],\n",
       " 'Fellows_of_the_Royal_Society': ['3', '2.8631801373481247', '642'],\n",
       " 'People_from_New_York_City': ['3', '2.9465608465608466', '635'],\n",
       " 'American_Jews': ['3', '3.09447983014862', '633'],\n",
       " 'American_television_actors': ['4.0', '3.3046958377801494', '636'],\n",
       " 'American_film_actors': ['3', '3.0563230605738574', '635'],\n",
       " 'Debut_albums': ['4', '4.009120171673819', '633'],\n",
       " 'Black-and-white_films': ['4', '3.1592967501331914', '634'],\n",
       " 'Year_of_birth_missing': ['3.0', '2.804591836734694', '558'],\n",
       " 'Place_of_birth_missing_(living_people)': ['4.0',\n",
       "  '3.4622741764080764',\n",
       "  '636'],\n",
       " 'Article_Feedback_Pilot': ['2.0', '1.5792811839323466', '632'],\n",
       " 'American_military_personnel_of_World_War_II': ['3',\n",
       "  '3.2150079829696647',\n",
       "  '634'],\n",
       " 'Windows_games': ['4.0', '3.821181479510378', '635']}"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "smallest"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Because the median doesn't seem a aqequate measure for the distance between the catogries (it can be accidentely a far distance between the two categories), wie decided to rank by the mean distance. The mean was in most cases also close to the median so it seemed to be the better measure. As the number of inifinitives doesn't vary much we didn't take them into account for our block ranking. In the next step we sort the dictionary by the mean distance."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "smallest = sorted(smallest.items(), key=lambda x: x[1][1])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here you can see the our block-ranking/distances (median and mean) for every category to our C0. The third number represents the number of infinitives."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('Article_Feedback_Pilot', ['2.0', '1.5792811839323466', '632']),\n",
       " ('Living_people', ['2.0', '2.0278494069107786', '587']),\n",
       " ('Harvard_University_alumni', ['3.0', '2.781068217874141', '637']),\n",
       " ('Year_of_birth_missing', ['3.0', '2.804591836734694', '558']),\n",
       " ('Fellows_of_the_Royal_Society', ['3', '2.8631801373481247', '642']),\n",
       " ('People_from_New_York_City', ['3', '2.9465608465608466', '635']),\n",
       " ('Year_of_birth_missing_(living_people)',\n",
       "  ['3.0', '2.971518987341772', '636']),\n",
       " ('English-language_films', ['3', '2.9888594164456235', '636']),\n",
       " ('American_film_actors', ['3', '3.0563230605738574', '635']),\n",
       " ('American_Jews', ['3', '3.09447983014862', '633']),\n",
       " ('American_films', ['3.0', '3.1020084566596196', '644']),\n",
       " ('Black-and-white_films', ['4', '3.1592967501331914', '634']),\n",
       " ('Members_of_the_United_Kingdom_Parliament_for_English_constituencies',\n",
       "  ['3', '3.1770334928229667', '634']),\n",
       " ('American_military_personnel_of_World_War_II',\n",
       "  ['3', '3.2150079829696647', '634']),\n",
       " ('British_films', ['4', '3.22710428798306', '642']),\n",
       " ('American_television_actors', ['4.0', '3.3046958377801494', '636']),\n",
       " ('Year_of_death_missing', ['4.0', '3.3721294363256784', '606']),\n",
       " ('English_television_actors', ['4', '3.4275898520084565', '643']),\n",
       " ('Place_of_birth_missing_(living_people)',\n",
       "  ['4.0', '3.4622741764080764', '636']),\n",
       " ('Association_football_midfielders', ['4', '3.5982951518380393', '636']),\n",
       " ('Association_football_forwards', ['4.0', '3.6680896478121663', '634']),\n",
       " ('English_cricketers', ['4.0', '3.742138364779874', '620']),\n",
       " ('Rivers_of_Romania', ['4.0', '3.799357945425361', '635']),\n",
       " ('Windows_games', ['4.0', '3.821181479510378', '635']),\n",
       " ('English_footballers', ['4.0', '3.9053475935828876', '634']),\n",
       " ('The_Football_League_players', ['4.0', '3.9925412892914225', '637']),\n",
       " ('English-language_albums', ['4', '3.993096123207647', '640']),\n",
       " ('Association_football_goalkeepers', ['4', '4.0021310602024505', '644']),\n",
       " ('Debut_albums', ['4', '4.009120171673819', '633']),\n",
       " ('Main_Belt_asteroids', ['4.0', '4.100373731980779', '643']),\n",
       " ('Asteroids_named_for_people', ['4.0', '4.108427267847557', '637']),\n",
       " ('Association_football_defenders', ['5.0', '4.298499464094319', '636']),\n",
       " ('Indian_films', ['5.0', '4.313947226709747', '637']),\n",
       " ('Major_League_Baseball_pitchers', ['5', '4.375734901122394', '644'])]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "smallest"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Preparation for the calculatioin of the article score.\n",
    "In the following step we assigned every node either to C0 (if it was included) or to the category that is the closest to C0."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "cat_mod = fnc.key_substraction(cats2, 'Year_of_birth_unknown', smallest)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "fnc.save_dict(cat_mod, 'cats_modified.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "cats3 = fnc.open_dict('cats_modified.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Using the new dictionary that contains the information which code belongs to which category to update the attributes we assigned to our graph. Now every node in our graph belongs to only one category."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "for key in cats3.keys():\n",
    "    for node in graph.nodes:\n",
    "        graph.node[node][key] = False\n",
    "        graph.node[node]['score'] = 0\n",
    "    temp = cats3[key]\n",
    "    for node in temp:\n",
    "        graph.node[int(node)][key] = True"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Creating a list of categories to be used for scoring the articles. Element 0 is our starting category. The other will be appended according to their distance to C0."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "cat_list = ['Year_of_birth_unknown']\n",
    "keys = [keys[0] for keys in smallest]\n",
    "for key in keys:\n",
    "    cat_list.append(key)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Getting the subgraph out of our scoring function. See the functs.py to see how we calculated our score."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "sub_graph_scored = fnc.article_score(graph, cat_list)\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "944"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sub_graph_scored.node[279122]['score']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Appending the names of the pages to our nodes for the display of the ranking of the articles in each category.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "for node in sub_graph_scored.nodes():\n",
    "    sub_graph_scored.node[node]['pagename'] = pages[node]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Setting up a dataframe to save the information about the 100 sites for every category, sorted by the score."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Year_of_birth_unknown 2536\n",
      "Article_Feedback_Pilot 3484\n",
      "Harvard_University_alumni 2507\n",
      "Year_of_birth_missing 4339\n",
      "Fellows_of_the_Royal_Society 3439\n",
      "People_from_New_York_City 4614\n",
      "Year_of_birth_missing_(living_people) 28309\n",
      "English-language_films 22463\n",
      "American_film_actors 13865\n",
      "American_Jews 2907\n",
      "American_films 15159\n",
      "Black-and-white_films 4929\n",
      "Members_of_the_United_Kingdom_Parliament_for_English_constituencies 6491\n",
      "American_military_personnel_of_World_War_II 3720\n",
      "British_films 4422\n",
      "American_television_actors 11531\n",
      "Year_of_death_missing 4120\n",
      "English_television_actors 3361\n",
      "Place_of_birth_missing_(living_people) 5491\n",
      "Association_football_midfielders 5801\n",
      "Association_football_forwards 4927\n",
      "English_cricketers 3253\n",
      "Rivers_of_Romania 7729\n",
      "Windows_games 4025\n",
      "English_footballers 7538\n",
      "The_Football_League_players 2794\n",
      "English-language_albums 4760\n",
      "Association_football_goalkeepers 3737\n",
      "Debut_albums 7561\n",
      "Main_Belt_asteroids 11660\n",
      "Asteroids_named_for_people 360\n",
      "Association_football_defenders 4588\n",
      "Indian_films 5568\n",
      "Major_League_Baseball_pitchers 5192\n"
     ]
    }
   ],
   "source": [
    "#creating a dataframe to display the scoring of the articles for every category\n",
    "outframe = pd.DataFrame(columns = cat_list)\n",
    "for cat in cat_list:\n",
    "    if cat != 'Living_people':\n",
    "        print(cat, len(cats3[cat]))\n",
    "        tempframe = pd.DataFrame(columns= ['Pagename (Score)', 'Score'])\n",
    "        for i in range(len(cats3[cat])):\n",
    "            tempframe.loc[i] = [str(sub_graph_scored.node[int(cats3[cat][i])]['pagename']+ ' ('+ str(sub_graph_scored.node[int(cats3[cat][i])]['score'])+')'), sub_graph_scored.node[int(cats3[cat][i])]['score']] \n",
    "        tempframe = tempframe.sort_values('Score', ascending=False)\n",
    "        tempframe = tempframe.reset_index(drop=True)\n",
    "        outframe[cat] = tempframe['Pagename (Score)'].loc[:100]\n",
    "        del tempframe"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Due to the running time and the deadline closing in we had to exclude the biggest category ('Living_people') from the ranking. In the output below you can see the ranking of the articles in the other categories."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year_of_birth_unknown</th>\n",
       "      <th>Article_Feedback_Pilot</th>\n",
       "      <th>Living_people</th>\n",
       "      <th>Harvard_University_alumni</th>\n",
       "      <th>Year_of_birth_missing</th>\n",
       "      <th>Fellows_of_the_Royal_Society</th>\n",
       "      <th>People_from_New_York_City</th>\n",
       "      <th>Year_of_birth_missing_(living_people)</th>\n",
       "      <th>English-language_films</th>\n",
       "      <th>American_film_actors</th>\n",
       "      <th>...</th>\n",
       "      <th>English_footballers</th>\n",
       "      <th>The_Football_League_players</th>\n",
       "      <th>English-language_albums</th>\n",
       "      <th>Association_football_goalkeepers</th>\n",
       "      <th>Debut_albums</th>\n",
       "      <th>Main_Belt_asteroids</th>\n",
       "      <th>Asteroids_named_for_people</th>\n",
       "      <th>Association_football_defenders</th>\n",
       "      <th>Indian_films</th>\n",
       "      <th>Major_League_Baseball_pitchers</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Diogenes Lartius (21)</td>\n",
       "      <td>To Kill a Mockingbird (film) (11742)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John F. Kennedy (62240)</td>\n",
       "      <td>Edward V. Hartford (1022)</td>\n",
       "      <td>Winston Churchill (37547)</td>\n",
       "      <td>Sydney Pollack (30121)</td>\n",
       "      <td>Aljean Harmetz (34717)</td>\n",
       "      <td>Rebecca (1940 film) (178798)</td>\n",
       "      <td>R. Lee Ermey (59381)</td>\n",
       "      <td>...</td>\n",
       "      <td>Wayne Rooney (1458)</td>\n",
       "      <td>Kevin Keegan (10757)</td>\n",
       "      <td>Definitely Maybe (1881)</td>\n",
       "      <td>Goalkeeper (association football) (3125)</td>\n",
       "      <td>Definitely Maybe (1881)</td>\n",
       "      <td>Asteroid belt (10555)</td>\n",
       "      <td>5535 Annefrank (10555)</td>\n",
       "      <td>Alan Hansen (1882)</td>\n",
       "      <td>Neeraj Vora (31)</td>\n",
       "      <td>Roger Clemens (310)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Stephen Dingate (17)</td>\n",
       "      <td>Allen Ginsberg (4907)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Rehnquist (8694)</td>\n",
       "      <td>Joe Gould (manager) (663)</td>\n",
       "      <td>Royal Society (1557)</td>\n",
       "      <td>Leelee Sobieski (29668)</td>\n",
       "      <td>Kevyn Major Howard (29623)</td>\n",
       "      <td>The Great Ziegfeld (141533)</td>\n",
       "      <td>James Woods (54368)</td>\n",
       "      <td>...</td>\n",
       "      <td>Alan Shearer (1293)</td>\n",
       "      <td>Kenny Dalglish (6371)</td>\n",
       "      <td>A Grand Don't Come for Free (1873)</td>\n",
       "      <td>Shay Given (1757)</td>\n",
       "      <td>Illmatic (15)</td>\n",
       "      <td>Cybele asteroid (7)</td>\n",
       "      <td>2685 Masursky (10555)</td>\n",
       "      <td>Geremi Njitap (1457)</td>\n",
       "      <td>Bend It Like Beckham (23)</td>\n",
       "      <td>Nolan Ryan (245)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Andrew Gibson (footballer) (16)</td>\n",
       "      <td>Laserblast (2282)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Quincy Adams (6944)</td>\n",
       "      <td>John Johnstone (mayor) (458)</td>\n",
       "      <td>Margaret Thatcher (1013)</td>\n",
       "      <td>Stanley Kubrick (29579)</td>\n",
       "      <td>John McMartin (9332)</td>\n",
       "      <td>The Power and the Glory (film) (140577)</td>\n",
       "      <td>James Marsden (54080)</td>\n",
       "      <td>...</td>\n",
       "      <td>Michael Owen (1233)</td>\n",
       "      <td>Eric Cantona (6024)</td>\n",
       "      <td>Let It Be (416)</td>\n",
       "      <td>Antti Niemi (footballer) (1278)</td>\n",
       "      <td>I Dreamed a Dream (album) (13)</td>\n",
       "      <td>3355 Onizuka (6)</td>\n",
       "      <td>4055 Magellan (2)</td>\n",
       "      <td>Gareth Bale (741)</td>\n",
       "      <td>Amar Akbar Anthony (18)</td>\n",
       "      <td>Sandy Koufax (214)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tom Faulkner (13)</td>\n",
       "      <td>Isaac Asimov (2072)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Leonard Bernstein (6203)</td>\n",
       "      <td>Martin Snyder (326)</td>\n",
       "      <td>Charles, Prince of Wales (326)</td>\n",
       "      <td>Stephen Sondheim (26473)</td>\n",
       "      <td>Jim Powell (historian) (5487)</td>\n",
       "      <td>The Battle Over Citizen Kane (140575)</td>\n",
       "      <td>Kate Bosworth (54045)</td>\n",
       "      <td>...</td>\n",
       "      <td>Peter Crouch (1181)</td>\n",
       "      <td>Graeme Souness (5016)</td>\n",
       "      <td>Sgt. Pepper's Lonely Hearts Club Band (35)</td>\n",
       "      <td>Mark Schwarzer (1213)</td>\n",
       "      <td>Please Please Me (13)</td>\n",
       "      <td>3352 McAuliffe (6)</td>\n",
       "      <td>1580 Betulia (1)</td>\n",
       "      <td>Colin Calderwood (735)</td>\n",
       "      <td>Hisss (17)</td>\n",
       "      <td>Randy Johnson (211)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>L Bu (12)</td>\n",
       "      <td>Scream 4 (2009)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norman Mailer (5969)</td>\n",
       "      <td>Barry Garner (281)</td>\n",
       "      <td>William Ewart Gladstone (261)</td>\n",
       "      <td>Emmy Rossum (11286)</td>\n",
       "      <td>Michael Horowitz (2541)</td>\n",
       "      <td>Citizen Kane (140574)</td>\n",
       "      <td>Beau Bridges (54041)</td>\n",
       "      <td>...</td>\n",
       "      <td>Teddy Sheringham (1048)</td>\n",
       "      <td>Mark Hughes (4966)</td>\n",
       "      <td>The Joshua Tree (32)</td>\n",
       "      <td>Bruce Grobbelaar (824)</td>\n",
       "      <td>Appetite for Destruction (11)</td>\n",
       "      <td>3353 Jarvis (6)</td>\n",
       "      <td>1685 Toro (1)</td>\n",
       "      <td>Colin Hendry (622)</td>\n",
       "      <td>Sholay (17)</td>\n",
       "      <td>Tom Seaver (191)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pausanias (geographer) (12)</td>\n",
       "      <td>Charlize Theron (1585)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T. S. Eliot (5846)</td>\n",
       "      <td>Ben Pon (senior) (244)</td>\n",
       "      <td>Richard Dawkins (194)</td>\n",
       "      <td>Joseph Papp (9020)</td>\n",
       "      <td>Nathan George (2347)</td>\n",
       "      <td>Sunset Boulevard (film) (80770)</td>\n",
       "      <td>Stacy Keach (54019)</td>\n",
       "      <td>...</td>\n",
       "      <td>Theo Walcott (994)</td>\n",
       "      <td>Ryan Giggs (4561)</td>\n",
       "      <td>The Beatles (album) (18)</td>\n",
       "      <td>Neville Southall (704)</td>\n",
       "      <td>Enter the Wu-Tang (36 Chambers) (11)</td>\n",
       "      <td>3356 Resnik (6)</td>\n",
       "      <td>878 Mildred (1)</td>\n",
       "      <td>Jim Gannon (458)</td>\n",
       "      <td>Chhalia (16)</td>\n",
       "      <td>Mariano Rivera (179)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Dong Zhuo (10)</td>\n",
       "      <td>Whitney Houston (1497)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Barack Obama, Sr. (5415)</td>\n",
       "      <td>Jean Tatlock (60)</td>\n",
       "      <td>Arthur Wellesley, 1st Duke of Wellington (167)</td>\n",
       "      <td>Jerome Robbins (8699)</td>\n",
       "      <td>Martin Gottfried (1322)</td>\n",
       "      <td>Lolita (1962 film) (72614)</td>\n",
       "      <td>Walton Goggins (53915)</td>\n",
       "      <td>...</td>\n",
       "      <td>Jermain Defoe (511)</td>\n",
       "      <td>Ian Rush (4438)</td>\n",
       "      <td>Pet Sounds (17)</td>\n",
       "      <td>Neil Sullivan (677)</td>\n",
       "      <td>The Piper at the Gates of Dawn (10)</td>\n",
       "      <td>3350 Scobee (6)</td>\n",
       "      <td>254 Augusta (1)</td>\n",
       "      <td>Anthony Gerrard (454)</td>\n",
       "      <td>Vaali (16)</td>\n",
       "      <td>Bob Gibson (161)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Theocritus (10)</td>\n",
       "      <td>Dreamgirls (film) (1368)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Theodore Roosevelt (5353)</td>\n",
       "      <td>Glen Frey (44)</td>\n",
       "      <td>Benjamin Disraeli (161)</td>\n",
       "      <td>Herman J. Mankiewicz (8532)</td>\n",
       "      <td>Kate Baldwin (1312)</td>\n",
       "      <td>Fear and Desire (59169)</td>\n",
       "      <td>Laz Alonso (53895)</td>\n",
       "      <td>...</td>\n",
       "      <td>Robbie Fowler (463)</td>\n",
       "      <td>Roy Keane (3758)</td>\n",
       "      <td>John Wesley Harding (album) (17)</td>\n",
       "      <td>Bryan Gunn (511)</td>\n",
       "      <td>Some Gave All (10)</td>\n",
       "      <td>3354 McNair (6)</td>\n",
       "      <td>25098 Gridnev (0)</td>\n",
       "      <td>Steve Staunton (415)</td>\n",
       "      <td>Mard (15)</td>\n",
       "      <td>Roy Halladay (158)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Yuan Shu (9)</td>\n",
       "      <td>Wanted (2008 film) (986)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Adams (5282)</td>\n",
       "      <td>Stanley Kerr (44)</td>\n",
       "      <td>Harold Wilson (149)</td>\n",
       "      <td>Theodore Roosevelt (5353)</td>\n",
       "      <td>John Doyle (director) (1312)</td>\n",
       "      <td>Dirty Harry (56869)</td>\n",
       "      <td>Rhys Coiro (53894)</td>\n",
       "      <td>...</td>\n",
       "      <td>David Beckham (438)</td>\n",
       "      <td>Iain Dowie (2897)</td>\n",
       "      <td>Thriller (album) (16)</td>\n",
       "      <td>Brad Friedel (485)</td>\n",
       "      <td>The Chronic (10)</td>\n",
       "      <td>3351 Smith (6)</td>\n",
       "      <td>25113 Benwasserman (0)</td>\n",
       "      <td>Frank Sinclair (410)</td>\n",
       "      <td>Chandramukhi (15)</td>\n",
       "      <td>Curt Schilling (153)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Tim Stevenson (9)</td>\n",
       "      <td>Matt Damon (948)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cole Porter (5194)</td>\n",
       "      <td>Lee Roberts (39)</td>\n",
       "      <td>Charles Darwin (140)</td>\n",
       "      <td>Allen Ginsberg (4907)</td>\n",
       "      <td>Maria Riccetto (1307)</td>\n",
       "      <td>Straw Dogs (53853)</td>\n",
       "      <td>Willa Holland (53868)</td>\n",
       "      <td>...</td>\n",
       "      <td>John Aldridge (414)</td>\n",
       "      <td>Joe Kinnear (2559)</td>\n",
       "      <td>Revolver (album) (16)</td>\n",
       "      <td>Pat Jennings (468)</td>\n",
       "      <td>Ten (Pearl Jam album) (9)</td>\n",
       "      <td>253 Mathilde (5)</td>\n",
       "      <td>25103 Kimdongyoung (0)</td>\n",
       "      <td>Kyle Walker (380)</td>\n",
       "      <td>Suhaag (1979 film) (15)</td>\n",
       "      <td>Pedro Martnez (144)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Joe Harris (cricketer) (8)</td>\n",
       "      <td>United States (944)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William S. Burroughs (4634)</td>\n",
       "      <td>John Hickson (cinematographer) (24)</td>\n",
       "      <td>Ramsay MacDonald (139)</td>\n",
       "      <td>Dorothy Fields (4111)</td>\n",
       "      <td>Ben Wright (American actor) (1307)</td>\n",
       "      <td>A Clockwork Orange (film) (50371)</td>\n",
       "      <td>Mel Gibson (35644)</td>\n",
       "      <td>...</td>\n",
       "      <td>Gary Lineker (376)</td>\n",
       "      <td>Robbie Keane (2554)</td>\n",
       "      <td>Illmatic (15)</td>\n",
       "      <td>Ricardo Pereira (405)</td>\n",
       "      <td>Spirit (Leona Lewis album) (9)</td>\n",
       "      <td>9619 Terrygilliam (5)</td>\n",
       "      <td>25111 Klokun (0)</td>\n",
       "      <td>Abdoulaye Diagne-Faye (377)</td>\n",
       "      <td>Aa Gale Lag Jaa (15)</td>\n",
       "      <td>Greg Maddux (134)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Symeon of Durham (7)</td>\n",
       "      <td>Al Capp (918)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pierre Trudeau (4630)</td>\n",
       "      <td>George Hull (Massachusetts) (23)</td>\n",
       "      <td>Clement Attlee (132)</td>\n",
       "      <td>Diane Arbus (3949)</td>\n",
       "      <td>Aaron Lazar (1307)</td>\n",
       "      <td>Dr. Strangelove (43014)</td>\n",
       "      <td>Jean Simmons (34713)</td>\n",
       "      <td>...</td>\n",
       "      <td>Darren Bent (361)</td>\n",
       "      <td>Gordon Strachan (2367)</td>\n",
       "      <td>Abbey Road (15)</td>\n",
       "      <td>Oliver Kahn (376)</td>\n",
       "      <td>The Rolling Stones (album) (9)</td>\n",
       "      <td>9618 Johncleese (5)</td>\n",
       "      <td>25119 Kakani (0)</td>\n",
       "      <td>Jonny Evans (333)</td>\n",
       "      <td>Bhai Ho To Aisa (14)</td>\n",
       "      <td>Dennis Eckersley (133)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Kim Jong-un (7)</td>\n",
       "      <td>Iron Man (film) (881)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Robert F. Kennedy (3918)</td>\n",
       "      <td>Roger M. Kyes (16)</td>\n",
       "      <td>Robert Gascoyne-Cecil, 3rd Marquess of Salisbu...</td>\n",
       "      <td>Doug Liman (3471)</td>\n",
       "      <td>Nat Benchley (1238)</td>\n",
       "      <td>Brief Encounter (41521)</td>\n",
       "      <td>Richard Chamberlain (34682)</td>\n",
       "      <td>...</td>\n",
       "      <td>Jimmy Greaves (350)</td>\n",
       "      <td>David Moyes (2353)</td>\n",
       "      <td>The Dark Side of the Moon (15)</td>\n",
       "      <td>Nick Colgan (365)</td>\n",
       "      <td>Reasonable Doubt (9)</td>\n",
       "      <td>9617 Grahamchapman (5)</td>\n",
       "      <td>25047 Tsuitehsin (0)</td>\n",
       "      <td>Franck Queudrue (325)</td>\n",
       "      <td>Raampur Ka Lakshman (14)</td>\n",
       "      <td>Steve Carlton (132)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Penda of Mercia (7)</td>\n",
       "      <td>Kevin Costner (519)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jack Lemmon (3341)</td>\n",
       "      <td>Jennifer Gan (14)</td>\n",
       "      <td>Neville Chamberlain (111)</td>\n",
       "      <td>Milton Friedman (3170)</td>\n",
       "      <td>Ralph Raico (807)</td>\n",
       "      <td>Ed Wood (film) (38771)</td>\n",
       "      <td>Alan Cumming (32091)</td>\n",
       "      <td>...</td>\n",
       "      <td>Harry Redknapp (339)</td>\n",
       "      <td>Alan Hansen (1882)</td>\n",
       "      <td>Please Please Me (13)</td>\n",
       "      <td>Thomas Srensen (321)</td>\n",
       "      <td>Spice (album) (8)</td>\n",
       "      <td>9620 Ericidle (5)</td>\n",
       "      <td>25099 Mashinskiy (0)</td>\n",
       "      <td>Ritchie Sutton (301)</td>\n",
       "      <td>Sachaa Jhutha (14)</td>\n",
       "      <td>Derek Lowe (128)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Stobaeus (7)</td>\n",
       "      <td>Jermain Defoe (511)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Robert Frost (2290)</td>\n",
       "      <td>L Bu (12)</td>\n",
       "      <td>George Canning (111)</td>\n",
       "      <td>Daniel Melnick (2983)</td>\n",
       "      <td>Juliet Landau (732)</td>\n",
       "      <td>Invasion of the Body Snatchers (36620)</td>\n",
       "      <td>Nicole Kidman (31979)</td>\n",
       "      <td>...</td>\n",
       "      <td>Neil Woods (303)</td>\n",
       "      <td>George Best (1871)</td>\n",
       "      <td>I Dreamed a Dream (album) (13)</td>\n",
       "      <td>Magnus Hedman (297)</td>\n",
       "      <td>The Fame (8)</td>\n",
       "      <td>9621 Michaelpalin (5)</td>\n",
       "      <td>25050 Michmadsen (0)</td>\n",
       "      <td>Paul McGrath (footballer) (299)</td>\n",
       "      <td>Chacha Bhatija (14)</td>\n",
       "      <td>Gaylord Perry (113)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Edwin, Earl of Mercia (6)</td>\n",
       "      <td>Scarlett Johansson (480)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Edward Said (2193)</td>\n",
       "      <td>Robert Lyden (11)</td>\n",
       "      <td>Harold Macmillan (105)</td>\n",
       "      <td>Ralph Lauren (2938)</td>\n",
       "      <td>Chuck E. Weiss (595)</td>\n",
       "      <td>Plan 9 from Outer Space (36616)</td>\n",
       "      <td>Bruce Willis (30751)</td>\n",
       "      <td>...</td>\n",
       "      <td>Geoff Hurst (300)</td>\n",
       "      <td>Dwight Yorke (1817)</td>\n",
       "      <td>Sweetheart of the Rodeo (13)</td>\n",
       "      <td>John Filan (260)</td>\n",
       "      <td>Kill 'Em All (8)</td>\n",
       "      <td>9622 Terryjones (5)</td>\n",
       "      <td>24986 Yalefan (0)</td>\n",
       "      <td>Ricky Sbragia (270)</td>\n",
       "      <td>Dharam Veer (1977 film) (14)</td>\n",
       "      <td>David Wells (113)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Joseph Rudd (6)</td>\n",
       "      <td>Phil Ochs (472)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Dos Passos (2118)</td>\n",
       "      <td>Junior Sanchez (11)</td>\n",
       "      <td>Arthur Balfour (104)</td>\n",
       "      <td>Laura Linney (2779)</td>\n",
       "      <td>Carlos Jacott (559)</td>\n",
       "      <td>The Day the Earth Stood Still (36556)</td>\n",
       "      <td>Vincent D'Onofrio (30204)</td>\n",
       "      <td>...</td>\n",
       "      <td>Henry Cursham (273)</td>\n",
       "      <td>Martin O'Neill (1787)</td>\n",
       "      <td>A Hard Day's Night (album) (12)</td>\n",
       "      <td>Wayne Hennessey (249)</td>\n",
       "      <td>The Documentary (8)</td>\n",
       "      <td>20296 Shayestorm (4)</td>\n",
       "      <td>25106 Ryoojungmin (0)</td>\n",
       "      <td>Richard Dunne (270)</td>\n",
       "      <td>Budtameez (14)</td>\n",
       "      <td>Whitey Ford (112)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Pye (Sussex cricketer) (6)</td>\n",
       "      <td>Robbie Fowler (463)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>William Gaddis (2117)</td>\n",
       "      <td>Murray Ashby (11)</td>\n",
       "      <td>Isaac Newton (103)</td>\n",
       "      <td>Bernadette Peters (2518)</td>\n",
       "      <td>Billy Steinberg (546)</td>\n",
       "      <td>Apocalypse Now (36112)</td>\n",
       "      <td>Sydney Pollack (30121)</td>\n",
       "      <td>...</td>\n",
       "      <td>Alan Smith (footballer born 1962) (255)</td>\n",
       "      <td>Martin Jol (1783)</td>\n",
       "      <td>Rubber Soul (12)</td>\n",
       "      <td>Hans Segers (241)</td>\n",
       "      <td>Doggystyle (7)</td>\n",
       "      <td>20341 Alanstack (4)</td>\n",
       "      <td>22558 Mladen (0)</td>\n",
       "      <td>Phil Babb (260)</td>\n",
       "      <td>Coolie (1983 film) (14)</td>\n",
       "      <td>Dwight Gooden (111)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Mary Jo Pehl (6)</td>\n",
       "      <td>Elia Kazan (428)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Walter Lippmann (1976)</td>\n",
       "      <td>Edwin Smith (rower) (11)</td>\n",
       "      <td>Robert Peel (100)</td>\n",
       "      <td>Joe Spinell (2452)</td>\n",
       "      <td>Philip Berg (446)</td>\n",
       "      <td>Hamlet (1948 film) (34564)</td>\n",
       "      <td>Matthew Modine (29879)</td>\n",
       "      <td>...</td>\n",
       "      <td>Nigel Clough (253)</td>\n",
       "      <td>Shay Given (1757)</td>\n",
       "      <td>Nashville Skyline (12)</td>\n",
       "      <td>Steve Ogrizovic (221)</td>\n",
       "      <td>Tubular Bells (7)</td>\n",
       "      <td>1589 Fanatica (4)</td>\n",
       "      <td>22512 Cannat (0)</td>\n",
       "      <td>Steve Nicol (254)</td>\n",
       "      <td>Desh Premee (14)</td>\n",
       "      <td>Josh Beckett (110)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Michael Knighton (6)</td>\n",
       "      <td>When Harry Met Sally... (398)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Updike (1915)</td>\n",
       "      <td>Donald Adam (11)</td>\n",
       "      <td>William Lamb, 2nd Viscount Melbourne (98)</td>\n",
       "      <td>Judy Holliday (2421)</td>\n",
       "      <td>Yehuda Berg (424)</td>\n",
       "      <td>The Shining (film) (33663)</td>\n",
       "      <td>Anthony Michael Hall (29770)</td>\n",
       "      <td>...</td>\n",
       "      <td>Micky Adams (248)</td>\n",
       "      <td>Nat Lofthouse (1713)</td>\n",
       "      <td>Appetite for Destruction (11)</td>\n",
       "      <td>Mike Walker (Welsh footballer) (220)</td>\n",
       "      <td>How Could Hell Be Any Worse? (7)</td>\n",
       "      <td>45 Eugenia (4)</td>\n",
       "      <td>22519 Gerardklein (0)</td>\n",
       "      <td>Micky Adams (248)</td>\n",
       "      <td>Om Shanti Om (13)</td>\n",
       "      <td>Andy Pettitte (108)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>A. M. Rathnam (6)</td>\n",
       "      <td>John Huston (347)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Benazir Bhutto (1602)</td>\n",
       "      <td>Graham Jarratt (11)</td>\n",
       "      <td>Stephen Hawking (95)</td>\n",
       "      <td>Paula Kelly (actress/dancer) (2346)</td>\n",
       "      <td>Joyce Piven (329)</td>\n",
       "      <td>Reds (film) (33174)</td>\n",
       "      <td>Adam Baldwin (29727)</td>\n",
       "      <td>...</td>\n",
       "      <td>Kevin Phillips (footballer) (239)</td>\n",
       "      <td>George Graham (footballer) (1710)</td>\n",
       "      <td>Enter the Wu-Tang (36 Chambers) (11)</td>\n",
       "      <td>Marcus Hahnemann (215)</td>\n",
       "      <td>Led Zeppelin (album) (7)</td>\n",
       "      <td>17233 Stanshapiro (4)</td>\n",
       "      <td>22168 Weissflog (0)</td>\n",
       "      <td>Michael Johnson (footballer born 1973) (247)</td>\n",
       "      <td>Enthiran (11)</td>\n",
       "      <td>David Cone (106)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Zhang Fei (6)</td>\n",
       "      <td>Barbra Streisand (336)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Willard Van Orman Quine (1575)</td>\n",
       "      <td>Bruce Culpan (11)</td>\n",
       "      <td>Charles II of England (86)</td>\n",
       "      <td>John Karlen (2343)</td>\n",
       "      <td>Lyle Kessler (322)</td>\n",
       "      <td>There Will Be Blood (33131)</td>\n",
       "      <td>Arliss Howard (29699)</td>\n",
       "      <td>...</td>\n",
       "      <td>Andy Carroll (237)</td>\n",
       "      <td>Neil Lennon (1624)</td>\n",
       "      <td>Harvest (Neil Young album) (11)</td>\n",
       "      <td>Maik Taylor (203)</td>\n",
       "      <td>The College Dropout (7)</td>\n",
       "      <td>20586 Elizkolod (4)</td>\n",
       "      <td>24968 Chernyakhovsky (0)</td>\n",
       "      <td>Jos Enrique Snchez (241)</td>\n",
       "      <td>Gandhi (film) (11)</td>\n",
       "      <td>John Smoltz (104)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Frankie Ingrassia (6)</td>\n",
       "      <td>Germany (312)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jacques Derrida (1444)</td>\n",
       "      <td>Thomas Engel (11)</td>\n",
       "      <td>Tim Berners-Lee (84)</td>\n",
       "      <td>Leonard Maltin (2279)</td>\n",
       "      <td>Andrew Heyward (263)</td>\n",
       "      <td>One, Two, Three (32416)</td>\n",
       "      <td>Ed O'Ross (29688)</td>\n",
       "      <td>...</td>\n",
       "      <td>Glenn Hoddle (234)</td>\n",
       "      <td>Nicklas Bendtner (1605)</td>\n",
       "      <td>All Things Must Pass (11)</td>\n",
       "      <td>Roy Carroll (198)</td>\n",
       "      <td>Come Away with Me (6)</td>\n",
       "      <td>21355 Pikovskaya (4)</td>\n",
       "      <td>24977 Tongzhan (0)</td>\n",
       "      <td>Efe Sodje (231)</td>\n",
       "      <td>Chennai 600028 (11)</td>\n",
       "      <td>Vida Blue (103)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Pope Nicholas III (5)</td>\n",
       "      <td>Japan (283)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George Abbott (1432)</td>\n",
       "      <td>Tony Stetson (10)</td>\n",
       "      <td>Joseph Chamberlain (70)</td>\n",
       "      <td>Natalie Portman (2116)</td>\n",
       "      <td>Mary Mapes (261)</td>\n",
       "      <td>Suddenly, Last Summer (film) (32400)</td>\n",
       "      <td>Leelee Sobieski (29668)</td>\n",
       "      <td>...</td>\n",
       "      <td>Sam Allardyce (231)</td>\n",
       "      <td>Gary McAllister (1551)</td>\n",
       "      <td>Blood on the Tracks (11)</td>\n",
       "      <td>David James (footballer) (174)</td>\n",
       "      <td>In the Court of the Crimson King (6)</td>\n",
       "      <td>7 Iris (4)</td>\n",
       "      <td>24985 Benuri (0)</td>\n",
       "      <td>Fabricio Coloccini (225)</td>\n",
       "      <td>Rab Ne Bana Di Jodi (10)</td>\n",
       "      <td>Jim Bunning (103)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Pope Nicholas II (5)</td>\n",
       "      <td>Rome (249)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>H. Bradford Westerfield (1419)</td>\n",
       "      <td>Thomas Twisden Hodges (9)</td>\n",
       "      <td>Henry John Temple, 3rd Viscount Palmerston (62)</td>\n",
       "      <td>Abbie Hoffman (2040)</td>\n",
       "      <td>David Andelman (259)</td>\n",
       "      <td>Lawrence of Arabia (film) (32396)</td>\n",
       "      <td>John Terry (actor) (29649)</td>\n",
       "      <td>...</td>\n",
       "      <td>Brian Little (footballer) (231)</td>\n",
       "      <td>Damien Duff (1495)</td>\n",
       "      <td>Smash (album) (11)</td>\n",
       "      <td>David Seaman (173)</td>\n",
       "      <td>Ready to Die (6)</td>\n",
       "      <td>15 Eunomia (4)</td>\n",
       "      <td>25049 Christofnorn (0)</td>\n",
       "      <td>Paul McShane (Irish footballer) (221)</td>\n",
       "      <td>Ajay (10)</td>\n",
       "      <td>Phil Niekro (100)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Sextus Empiricus (5)</td>\n",
       "      <td>Egypt (216)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nelson Goodman (1389)</td>\n",
       "      <td>Eileen Wilks (9)</td>\n",
       "      <td>Robert Jenkinson, 2nd Earl of Liverpool (60)</td>\n",
       "      <td>Boaz Yakin (2030)</td>\n",
       "      <td>Duncan Campbell (The Guardian) (247)</td>\n",
       "      <td>Hamburger Hill (30931)</td>\n",
       "      <td>Thomas Gibson (29649)</td>\n",
       "      <td>...</td>\n",
       "      <td>Steve Ogrizovic (221)</td>\n",
       "      <td>Geremi Njitap (1457)</td>\n",
       "      <td>The Piper at the Gates of Dawn (10)</td>\n",
       "      <td>Peter Shilton (169)</td>\n",
       "      <td>Dangerously in Love (6)</td>\n",
       "      <td>6 Hebe (3)</td>\n",
       "      <td>25104 Chohyunghoon (0)</td>\n",
       "      <td>Eric Young (footballer) (214)</td>\n",
       "      <td>Mother India (10)</td>\n",
       "      <td>Ferguson Jenkins (99)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Ivan Alexander of Bulgaria (5)</td>\n",
       "      <td>Ed Wood (215)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Carol Chomsky (1295)</td>\n",
       "      <td>Amanda Lepore (9)</td>\n",
       "      <td>Roger Penrose (57)</td>\n",
       "      <td>Joseph L. Mankiewicz (2003)</td>\n",
       "      <td>Robert K. Weiss (217)</td>\n",
       "      <td>Fast and Furious (30814)</td>\n",
       "      <td>Vinessa Shaw (29646)</td>\n",
       "      <td>...</td>\n",
       "      <td>Dion Dublin (213)</td>\n",
       "      <td>Dean Saunders (1443)</td>\n",
       "      <td>Fearless (Taylor Swift album) (10)</td>\n",
       "      <td>Harry Gregg (161)</td>\n",
       "      <td>Animal (Kesha album) (6)</td>\n",
       "      <td>Nysa family (3)</td>\n",
       "      <td>25115 Drago (0)</td>\n",
       "      <td>Dion Dublin (213)</td>\n",
       "      <td>Lagaan (9)</td>\n",
       "      <td>Luis Tiant (98)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Tancred of Hauteville (5)</td>\n",
       "      <td>Russia (211)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Thomas Wolfe (1139)</td>\n",
       "      <td>Ian Rickson (9)</td>\n",
       "      <td>Henry Brougham, 1st Baron Brougham and Vaux (53)</td>\n",
       "      <td>Scooter Braun (1883)</td>\n",
       "      <td>Lewis Beale (212)</td>\n",
       "      <td>Alice in Wonderland (2010 film) (30812)</td>\n",
       "      <td>Kevyn Major Howard (29623)</td>\n",
       "      <td>...</td>\n",
       "      <td>Clive Allen (213)</td>\n",
       "      <td>Roger Hunt (1422)</td>\n",
       "      <td>The Wall (10)</td>\n",
       "      <td>Vito Mannone (161)</td>\n",
       "      <td>Simply Deep (6)</td>\n",
       "      <td>9965 GNU (3)</td>\n",
       "      <td>21775 Tsiganis (0)</td>\n",
       "      <td>Glenn Loovens (206)</td>\n",
       "      <td>Bommarillu (9)</td>\n",
       "      <td>Tom Glavine (95)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Sweyn II of Denmark (5)</td>\n",
       "      <td>Henrik Larsson (204)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nicholas Longworth (1135)</td>\n",
       "      <td>John Masterman (MP) (9)</td>\n",
       "      <td>Cotton Mather (50)</td>\n",
       "      <td>Kyra Sedgwick (1577)</td>\n",
       "      <td>Sarah Lane (dancer) (210)</td>\n",
       "      <td>An American in Paris (film) (30401)</td>\n",
       "      <td>Tim Colceri (29617)</td>\n",
       "      <td>...</td>\n",
       "      <td>Alan Pardew (211)</td>\n",
       "      <td>Antti Niemi (footballer) (1278)</td>\n",
       "      <td>Some Gave All (10)</td>\n",
       "      <td>Paul Jones (footballer) (157)</td>\n",
       "      <td>Black Sabbath (album) (6)</td>\n",
       "      <td>9793 Torvalds (3)</td>\n",
       "      <td>20465 Vervack (0)</td>\n",
       "      <td>Pat Scully (200)</td>\n",
       "      <td>Madhumati (9)</td>\n",
       "      <td>Johan Santana (94)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Stigand (5)</td>\n",
       "      <td>United States Senate (202)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Hawkes (novelist) (1099)</td>\n",
       "      <td>Peter Reilly (9)</td>\n",
       "      <td>James Lovelock (49)</td>\n",
       "      <td>Holly Marie Combs (1392)</td>\n",
       "      <td>Lou Hirsch (206)</td>\n",
       "      <td>Fantasia (film) (29780)</td>\n",
       "      <td>Alfred Molina (26391)</td>\n",
       "      <td>...</td>\n",
       "      <td>Steve McClaren (211)</td>\n",
       "      <td>Richie Partridge (1258)</td>\n",
       "      <td>The Freewheelin' Bob Dylan (10)</td>\n",
       "      <td>Don Mackay (155)</td>\n",
       "      <td>Freak Out! (6)</td>\n",
       "      <td>9885 Linux (3)</td>\n",
       "      <td>23890 Quindou (0)</td>\n",
       "      <td>Glenn Roeder (200)</td>\n",
       "      <td>Pokiri (2006 film) (9)</td>\n",
       "      <td>Ron Guidry (93)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Pope Benedict VI (3)</td>\n",
       "      <td>Sudan (55)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hyman Minsky (259)</td>\n",
       "      <td>Charley Aull (4)</td>\n",
       "      <td>Alfred Russel Wallace (25)</td>\n",
       "      <td>Oliver Stone (382)</td>\n",
       "      <td>Tom Whedon (137)</td>\n",
       "      <td>Intermezzo (1939 film) (20625)</td>\n",
       "      <td>Jodie Foster (3368)</td>\n",
       "      <td>...</td>\n",
       "      <td>Brian Laws (140)</td>\n",
       "      <td>Ched Evans (611)</td>\n",
       "      <td>The Basement Tapes (7)</td>\n",
       "      <td>Brad Jones (footballer) (74)</td>\n",
       "      <td>The Monkees (album) (3)</td>\n",
       "      <td>162 Laurentia (1)</td>\n",
       "      <td>24353 Patrickhsu (0)</td>\n",
       "      <td>Laurent Koscielny (79)</td>\n",
       "      <td>Baazigar (6)</td>\n",
       "      <td>Justin Verlander (57)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Estrid Svendsdatter (3)</td>\n",
       "      <td>Vanilla Ice (54)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W. E. B. Du Bois (258)</td>\n",
       "      <td>Fred Taylor (Edwardian footballer) (4)</td>\n",
       "      <td>Joseph Dalton Hooker (25)</td>\n",
       "      <td>Don Roos (381)</td>\n",
       "      <td>James A. Contner (137)</td>\n",
       "      <td>Analyze That (19986)</td>\n",
       "      <td>Jack Lemmon (3341)</td>\n",
       "      <td>...</td>\n",
       "      <td>Ronnie Moore (140)</td>\n",
       "      <td>Brian Carey (564)</td>\n",
       "      <td>Let It Bleed (7)</td>\n",
       "      <td>Petr ech (72)</td>\n",
       "      <td>Hand Sown ... Home Grown (3)</td>\n",
       "      <td>51 Nemausa (1)</td>\n",
       "      <td>24354 Caz (0)</td>\n",
       "      <td>Mal Donaghy (79)</td>\n",
       "      <td>My Name Is Khan (6)</td>\n",
       "      <td>Bruce Sutter (56)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>William Smith (congressman) (3)</td>\n",
       "      <td>Michael Jackson (53)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bobbi Sykes (247)</td>\n",
       "      <td>Kaohelelani (4)</td>\n",
       "      <td>J. J. Thomson (24)</td>\n",
       "      <td>Buck Henry (368)</td>\n",
       "      <td>John Earl Haynes (137)</td>\n",
       "      <td>Good Morning, Vietnam (19984)</td>\n",
       "      <td>Tom Cruise (3341)</td>\n",
       "      <td>...</td>\n",
       "      <td>Gabriel Agbonlahor (139)</td>\n",
       "      <td>Dave Mackay (footballer born 1934) (544)</td>\n",
       "      <td>Cosmo's Factory (7)</td>\n",
       "      <td>Gordon Banks (72)</td>\n",
       "      <td>The Barbra Streisand Album (3)</td>\n",
       "      <td>248 Lameia (1)</td>\n",
       "      <td>24369 Evanichols (0)</td>\n",
       "      <td>Steven Watt (footballer) (78)</td>\n",
       "      <td>Golmaal Returns (6)</td>\n",
       "      <td>Ted Lilly (55)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>John Underwood (actor) (3)</td>\n",
       "      <td>San Diego (52)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Charles Olson (245)</td>\n",
       "      <td>Hector Maclean, 4th Laird of Coll (4)</td>\n",
       "      <td>Victor Cavendish, 9th Duke of Devonshire (24)</td>\n",
       "      <td>Peggy McCay (339)</td>\n",
       "      <td>Stacey Scowley (136)</td>\n",
       "      <td>Toys (film) (19981)</td>\n",
       "      <td>Nicolas Cage (3327)</td>\n",
       "      <td>...</td>\n",
       "      <td>Stan Ternent (138)</td>\n",
       "      <td>Jan Mlby (544)</td>\n",
       "      <td>How Could Hell Be Any Worse? (7)</td>\n",
       "      <td>Greg Fleming (69)</td>\n",
       "      <td>Funkadelic (album) (3)</td>\n",
       "      <td>4797 Ako (1)</td>\n",
       "      <td>24432 Elizamcnitt (0)</td>\n",
       "      <td>Bacary Sagna (78)</td>\n",
       "      <td>Force (film) (6)</td>\n",
       "      <td>Bret Saberhagen (54)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Morcar (3)</td>\n",
       "      <td>United States Secretary of State (52)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Buckminster Fuller (244)</td>\n",
       "      <td>Clifford Evans (rugby league) (4)</td>\n",
       "      <td>John Evelyn (24)</td>\n",
       "      <td>Barry Primus (339)</td>\n",
       "      <td>Marita Grabiak (135)</td>\n",
       "      <td>The Perfect Storm (film) (19979)</td>\n",
       "      <td>Martin Landau (3310)</td>\n",
       "      <td>...</td>\n",
       "      <td>Graham Taylor (footballer) (138)</td>\n",
       "      <td>Denis Law (536)</td>\n",
       "      <td>Younger Than Yesterday (7)</td>\n",
       "      <td>Walter Zenga (68)</td>\n",
       "      <td>The Unraveling (3)</td>\n",
       "      <td>687 Tinette (1)</td>\n",
       "      <td>24422 Helentressa (0)</td>\n",
       "      <td>Roy McFarland (77)</td>\n",
       "      <td>Manmadhan (6)</td>\n",
       "      <td>Kevin Millwood (54)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Nicol I Sommaripa, Lord of Paros, Tercier of N...</td>\n",
       "      <td>Rocky (52)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Marcelo Fernan (243)</td>\n",
       "      <td>Alf Middleton (4)</td>\n",
       "      <td>Christopher Wren (24)</td>\n",
       "      <td>Aram Saroyan (334)</td>\n",
       "      <td>Vern Gillum (135)</td>\n",
       "      <td>Cover Girl (film) (18596)</td>\n",
       "      <td>Robert Montgomery (actor) (3182)</td>\n",
       "      <td>...</td>\n",
       "      <td>John Terry (136)</td>\n",
       "      <td>Chris Iwelumo (535)</td>\n",
       "      <td>Beggars Banquet (7)</td>\n",
       "      <td>Lewis Price (67)</td>\n",
       "      <td>Taylor Swift (album) (3)</td>\n",
       "      <td>4303 Savitskij (1)</td>\n",
       "      <td>24493 McCommon (0)</td>\n",
       "      <td>Richard Gough (77)</td>\n",
       "      <td>Dasavathaaram (6)</td>\n",
       "      <td>Mike Timlin (54)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>George Adams (football player and coach) (3)</td>\n",
       "      <td>Brussels (52)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pedro Albizu Campos (242)</td>\n",
       "      <td>Dutch Voight (4)</td>\n",
       "      <td>Andrew Wiles (24)</td>\n",
       "      <td>Wendy Benson (330)</td>\n",
       "      <td>Elizabeth Craft and Sarah Fain (135)</td>\n",
       "      <td>Ben-Hur (1959 film) (18339)</td>\n",
       "      <td>Steve Martin (3037)</td>\n",
       "      <td>...</td>\n",
       "      <td>Dave Jones (football manager) (136)</td>\n",
       "      <td>Liam Brady (532)</td>\n",
       "      <td>Bringing It All Back Home (7)</td>\n",
       "      <td>Boaz Myhill (67)</td>\n",
       "      <td>St. Elsewhere (album) (3)</td>\n",
       "      <td>3952 Russellmark (1)</td>\n",
       "      <td>24492 Nathanmonroe (0)</td>\n",
       "      <td>Jeff Hopkins (76)</td>\n",
       "      <td>Kadhal Kottai (6)</td>\n",
       "      <td>John Farrell (pitcher) (53)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Andronikos Doukas (general under Romanos IV) (3)</td>\n",
       "      <td>Encyclopdia Britannica (52)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Theodore H. White (233)</td>\n",
       "      <td>Billy Watkins (rugby) (4)</td>\n",
       "      <td>John Copley, 1st Baron Lyndhurst (24)</td>\n",
       "      <td>Lauren Bacall (327)</td>\n",
       "      <td>Marion Sandler (134)</td>\n",
       "      <td>The Human Comedy (film) (18336)</td>\n",
       "      <td>Leonardo DiCaprio (2962)</td>\n",
       "      <td>...</td>\n",
       "      <td>Bill Dearden (136)</td>\n",
       "      <td>Bryan Gunn (511)</td>\n",
       "      <td>The Blueprint 3 (7)</td>\n",
       "      <td>Robert Olejnik (67)</td>\n",
       "      <td>Pacific Ocean Blue (3)</td>\n",
       "      <td>106 Dione (1)</td>\n",
       "      <td>24494 Megmoulding (0)</td>\n",
       "      <td>Paul Parker (footballer) (75)</td>\n",
       "      <td>K. T. Kunjumon (6)</td>\n",
       "      <td>Adam Wainwright (53)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Thomas Cotes (3)</td>\n",
       "      <td>Buenos Aires (51)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>David P. McAllester (219)</td>\n",
       "      <td>John Feetham (4)</td>\n",
       "      <td>James Cook (24)</td>\n",
       "      <td>Stockard Channing (322)</td>\n",
       "      <td>Kevin Chapman (132)</td>\n",
       "      <td>Manpower (1941 film) (18329)</td>\n",
       "      <td>Roddy McDowall (2926)</td>\n",
       "      <td>...</td>\n",
       "      <td>Jermaine Beckford (134)</td>\n",
       "      <td>Mo Johnston (495)</td>\n",
       "      <td>Who's Next (7)</td>\n",
       "      <td>Ray Clemence (66)</td>\n",
       "      <td>Hello, I'm Dolly (3)</td>\n",
       "      <td>19 Fortuna (1)</td>\n",
       "      <td>24474 Ananthram (0)</td>\n",
       "      <td>Alex Song (74)</td>\n",
       "      <td>Swades (6)</td>\n",
       "      <td>Billy Wagner (53)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>George Oldner (3)</td>\n",
       "      <td>United States Environmental Protection Agency ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Samuel Adams (210)</td>\n",
       "      <td>Ollie Quinn (4)</td>\n",
       "      <td>John Lubbock, 1st Baron Avebury (23)</td>\n",
       "      <td>James Cagney (318)</td>\n",
       "      <td>Anthony Thomopoulos (131)</td>\n",
       "      <td>The Maltese Falcon (1941 film) (18326)</td>\n",
       "      <td>Christopher Walken (2917)</td>\n",
       "      <td>...</td>\n",
       "      <td>Jay Simpson (133)</td>\n",
       "      <td>Joe Jordan (footballer) (488)</td>\n",
       "      <td>Use Your Illusion I (7)</td>\n",
       "      <td>Mart Poom (66)</td>\n",
       "      <td>OP8 (3)</td>\n",
       "      <td>1462 Zamenhof (1)</td>\n",
       "      <td>24464 Williamkalb (0)</td>\n",
       "      <td>Richard Money (74)</td>\n",
       "      <td>Penn (film) (6)</td>\n",
       "      <td>Warren Spahn (51)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Ballard Smith (3)</td>\n",
       "      <td>Scooter Libby (51)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Frank O'Hara (205)</td>\n",
       "      <td>Johnny Jack Nounes (4)</td>\n",
       "      <td>John Horton Conway (23)</td>\n",
       "      <td>Jack Hirschman (316)</td>\n",
       "      <td>John Burgee (129)</td>\n",
       "      <td>Since You Went Away (18324)</td>\n",
       "      <td>Timothy Hutton (2905)</td>\n",
       "      <td>...</td>\n",
       "      <td>Ronnie Jepson (132)</td>\n",
       "      <td>Brad Friedel (485)</td>\n",
       "      <td>From Elvis in Memphis (7)</td>\n",
       "      <td>David Stockdale (66)</td>\n",
       "      <td>Song Cycle (album) (3)</td>\n",
       "      <td>26734 Terryfarrell (1)</td>\n",
       "      <td>24410 Juliewalker (0)</td>\n",
       "      <td>Knut Anders Fostervold (73)</td>\n",
       "      <td>Thulladha Manamum Thullum (5)</td>\n",
       "      <td>Francisco Liriano (51)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Raphael Holinshed (3)</td>\n",
       "      <td>First Amendment to the United States Constitut...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>James Rossant (200)</td>\n",
       "      <td>Gabriel Eder (4)</td>\n",
       "      <td>John Herschel (23)</td>\n",
       "      <td>Alan Alda (315)</td>\n",
       "      <td>John Regan (bassist) (128)</td>\n",
       "      <td>Double Indemnity (film) (18323)</td>\n",
       "      <td>Clint Eastwood (2808)</td>\n",
       "      <td>...</td>\n",
       "      <td>Lee Chapman (131)</td>\n",
       "      <td>Ally McCoist (479)</td>\n",
       "      <td>Led Zeppelin (album) (7)</td>\n",
       "      <td>Stewart Kerr (64)</td>\n",
       "      <td>Don't Do It (3)</td>\n",
       "      <td>26733 Nanavisitor (1)</td>\n",
       "      <td>24316 Anncooper (0)</td>\n",
       "      <td>Kieran Gibbs (72)</td>\n",
       "      <td>Parineeta (2005 film) (5)</td>\n",
       "      <td>Lee Smith (baseball) (50)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Wakeland (London cricketer) (3)</td>\n",
       "      <td>Philosophy (50)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Vincent Hanna (200)</td>\n",
       "      <td>Guan Yu (4)</td>\n",
       "      <td>Julian Huxley (23)</td>\n",
       "      <td>Patricia Broderick (314)</td>\n",
       "      <td>Martin J. Sherwin (126)</td>\n",
       "      <td>Going My Way (18308)</td>\n",
       "      <td>Laura Linney (2779)</td>\n",
       "      <td>...</td>\n",
       "      <td>Steve Coppell (129)</td>\n",
       "      <td>Tore Andr Flo (470)</td>\n",
       "      <td>Metallica (album) (7)</td>\n",
       "      <td>Bartosz Biakowski (62)</td>\n",
       "      <td>The Thoughts of Emerlist Davjack (3)</td>\n",
       "      <td>8380 Tooting (1)</td>\n",
       "      <td>24397 Parkerowan (0)</td>\n",
       "      <td>Chris Hutchings (72)</td>\n",
       "      <td>Madrasapattinam (5)</td>\n",
       "      <td>Francisco Rodrguez (baseball, born 1982) (50)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Diogenianus (3)</td>\n",
       "      <td>Guam (49)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Emile de Antonio (197)</td>\n",
       "      <td>Henri Callot (4)</td>\n",
       "      <td>Freeman Dyson (23)</td>\n",
       "      <td>Flex Alexander (313)</td>\n",
       "      <td>Dale Oliver (122)</td>\n",
       "      <td>Stalag 17 (18301)</td>\n",
       "      <td>Lynn Redgrave (2753)</td>\n",
       "      <td>...</td>\n",
       "      <td>John Barnes (footballer) (129)</td>\n",
       "      <td>Pat Jennings (468)</td>\n",
       "      <td>Headquarters (album) (7)</td>\n",
       "      <td>Scott Carson (61)</td>\n",
       "      <td>Do You Believe in Magic (album) (3)</td>\n",
       "      <td>7507 Israel (1)</td>\n",
       "      <td>24387 Trettel (0)</td>\n",
       "      <td>Sbastien Squillaci (72)</td>\n",
       "      <td>Satya (film) (5)</td>\n",
       "      <td>Bob Feller (49)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Indravarman I (3)</td>\n",
       "      <td>American Revolutionary War (49)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Marilyn French (195)</td>\n",
       "      <td>William A. Nimick (4)</td>\n",
       "      <td>Edward Cardwell, 1st Viscount Cardwell (23)</td>\n",
       "      <td>Burt Lancaster (310)</td>\n",
       "      <td>Miles Ross (producer) (120)</td>\n",
       "      <td>Five Graves to Cairo (18301)</td>\n",
       "      <td>Shirley MacLaine (2705)</td>\n",
       "      <td>...</td>\n",
       "      <td>Ray Lewington (128)</td>\n",
       "      <td>Kenwyne Jones (467)</td>\n",
       "      <td>Late Registration (7)</td>\n",
       "      <td>Scott Howie (61)</td>\n",
       "      <td>Who Needs Actions When You Got Words (3)</td>\n",
       "      <td>25 Phocaea (1)</td>\n",
       "      <td>24386 McLindon (0)</td>\n",
       "      <td>Chris Baird (70)</td>\n",
       "      <td>Kadhal Desam (5)</td>\n",
       "      <td>Keith Foulke (49)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Edward Aburrow senior (3)</td>\n",
       "      <td>Jamaica (49)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arthur M. Schlesinger, Jr. (193)</td>\n",
       "      <td>Jeremiah Robinson (4)</td>\n",
       "      <td>Humphry Davy (22)</td>\n",
       "      <td>Hillard Elkins (299)</td>\n",
       "      <td>Alfredo Alonso (118)</td>\n",
       "      <td>Witness for the Prosecution (1957 film) (18299)</td>\n",
       "      <td>Barbara Bouchet (2682)</td>\n",
       "      <td>...</td>\n",
       "      <td>Akpo Sodje (128)</td>\n",
       "      <td>Ian St. John (467)</td>\n",
       "      <td>The Marshall Mathers LP (7)</td>\n",
       "      <td>Brad Guzan (61)</td>\n",
       "      <td>America (America album) (3)</td>\n",
       "      <td>4923 Clarke (1)</td>\n",
       "      <td>24385 Katcagen (0)</td>\n",
       "      <td>Johan Djourou (70)</td>\n",
       "      <td>7G Rainbow Colony (5)</td>\n",
       "      <td>Octavio Dotel (48)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Pope John XIII (3)</td>\n",
       "      <td>Terrorism (49)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Reed (journalist) (191)</td>\n",
       "      <td>Jimmy Kelly (hurler) (4)</td>\n",
       "      <td>William Lowther, 2nd Earl of Lonsdale (22)</td>\n",
       "      <td>Adam Goldstein (294)</td>\n",
       "      <td>Alan Blumenfeld (115)</td>\n",
       "      <td>Ball of Fire (18298)</td>\n",
       "      <td>Carroll O'Connor (2674)</td>\n",
       "      <td>...</td>\n",
       "      <td>Lawrie Sanchez (127)</td>\n",
       "      <td>Charlie Miller (462)</td>\n",
       "      <td>Dusty in Memphis (7)</td>\n",
       "      <td>Jens Lehmann (61)</td>\n",
       "      <td>The Mechanix (3)</td>\n",
       "      <td>5020 Asimov (1)</td>\n",
       "      <td>24378 Katelyngibbs (0)</td>\n",
       "      <td>Paul Hurst (70)</td>\n",
       "      <td>Vinnaithaandi Varuvaayaa (5)</td>\n",
       "      <td>Steve Stone (baseball) (48)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Chief Gomo (3)</td>\n",
       "      <td>Stone Cold Steve Austin (48)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Julian Simon (186)</td>\n",
       "      <td>Jos Vaquero (4)</td>\n",
       "      <td>Thomas Babington Macaulay, 1st Baron Macaulay ...</td>\n",
       "      <td>Tina Fey (293)</td>\n",
       "      <td>Peter Biskind (112)</td>\n",
       "      <td>The Fortune Cookie (18298)</td>\n",
       "      <td>John Hoyt (2637)</td>\n",
       "      <td>...</td>\n",
       "      <td>Ashley Young (127)</td>\n",
       "      <td>Jim Gannon (458)</td>\n",
       "      <td>Off the Wall (album) (7)</td>\n",
       "      <td>Joe Corrigan (61)</td>\n",
       "      <td>Fresh Cream (3)</td>\n",
       "      <td>Frank Pieter Israel (1)</td>\n",
       "      <td>24376 Ramesh (0)</td>\n",
       "      <td>Julian Dicks (68)</td>\n",
       "      <td>Dhoom 2 (5)</td>\n",
       "      <td>Javier Vzquez (47)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Sabinianus (consul 505) (3)</td>\n",
       "      <td>Torture (48)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Max Soliven (183)</td>\n",
       "      <td>John Fleming (Devonport MP) (4)</td>\n",
       "      <td>George Grote (21)</td>\n",
       "      <td>Howard Stern (291)</td>\n",
       "      <td>David Rubenstein (111)</td>\n",
       "      <td>Hold Back the Dawn (18296)</td>\n",
       "      <td>Fred Astaire (2631)</td>\n",
       "      <td>...</td>\n",
       "      <td>Peter Reid (127)</td>\n",
       "      <td>Robbie Savage (457)</td>\n",
       "      <td>The College Dropout (7)</td>\n",
       "      <td>Nico Vaesen (60)</td>\n",
       "      <td>No Depression (album) (3)</td>\n",
       "      <td>18244 Anneila (1)</td>\n",
       "      <td>24372 Timobauman (0)</td>\n",
       "      <td>Alvin Martin (66)</td>\n",
       "      <td>Bachna Ae Haseeno (5)</td>\n",
       "      <td>Brad Penny (47)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Paul McGeough (3)</td>\n",
       "      <td>Alexander the Great (48)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Erich Kunzel (173)</td>\n",
       "      <td>Harry Spencer Waddington (4)</td>\n",
       "      <td>William Pitt, 1st Earl of Chatham (21)</td>\n",
       "      <td>Jack Schwartzman (284)</td>\n",
       "      <td>Ben Sliney (110)</td>\n",
       "      <td>The Wild Bunch (17918)</td>\n",
       "      <td>David Clennon (2623)</td>\n",
       "      <td>...</td>\n",
       "      <td>Daryl Clare (124)</td>\n",
       "      <td>John Charles (455)</td>\n",
       "      <td>No Control (Bad Religion album) (7)</td>\n",
       "      <td>Saul Deeney (59)</td>\n",
       "      <td>One Nation Underground (Pearls Before Swine al...</td>\n",
       "      <td>1838 Ursa (1)</td>\n",
       "      <td>24351 Fionawood (0)</td>\n",
       "      <td>Andy Morrison (66)</td>\n",
       "      <td>Eeram (5)</td>\n",
       "      <td>Jim Kaat (47)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Xiahou Yuan (3)</td>\n",
       "      <td>Samuel Pepys (47)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Charles Eliot Norton (172)</td>\n",
       "      <td>Burpee L. Steeves (4)</td>\n",
       "      <td>David Lindsay, 27th Earl of Crawford (21)</td>\n",
       "      <td>Wallace Shawn (266)</td>\n",
       "      <td>Len Munsil (109)</td>\n",
       "      <td>Horse Feathers (17803)</td>\n",
       "      <td>Oliver Platt (2608)</td>\n",
       "      <td>...</td>\n",
       "      <td>Gary Alexander (footballer) (122)</td>\n",
       "      <td>Anthony Gerrard (454)</td>\n",
       "      <td>Recovery (Eminem album) (7)</td>\n",
       "      <td>Tim Howard (59)</td>\n",
       "      <td>Lumpy Gravy (3)</td>\n",
       "      <td>11 Parthenope (1)</td>\n",
       "      <td>24347 Arthurkuan (0)</td>\n",
       "      <td>Ricardo Carvalho (65)</td>\n",
       "      <td>Naan Kadavul (5)</td>\n",
       "      <td>Orlando Hernndez (46)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Pope Leo VIII (3)</td>\n",
       "      <td>Poverty (47)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Leonard (critic) (172)</td>\n",
       "      <td>James M. Stevens (4)</td>\n",
       "      <td>Charles Lennox, 2nd Duke of Richmond (21)</td>\n",
       "      <td>Amanda Peet (264)</td>\n",
       "      <td>Barry Hess (107)</td>\n",
       "      <td>Show Boat (1936 film) (17800)</td>\n",
       "      <td>Chris O'Donnell (2604)</td>\n",
       "      <td>...</td>\n",
       "      <td>Paul Jewell (122)</td>\n",
       "      <td>Kenny Miller (453)</td>\n",
       "      <td>After the Gold Rush (7)</td>\n",
       "      <td>Espen Baardsen (58)</td>\n",
       "      <td>Niandra Lades and Usually Just a T-Shirt (3)</td>\n",
       "      <td>5815 Shinsengumi (1)</td>\n",
       "      <td>24370 Marywang (0)</td>\n",
       "      <td>Neill Collins (65)</td>\n",
       "      <td>Paiyaa (5)</td>\n",
       "      <td>Byung-Hyun Kim (46)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Idwal Foel (3)</td>\n",
       "      <td>New Deal (47)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Peter Ivers (171)</td>\n",
       "      <td>Thomas F. Terrell (4)</td>\n",
       "      <td>George Byng, 2nd Earl of Strafford (21)</td>\n",
       "      <td>Natasha Lyonne (261)</td>\n",
       "      <td>Ken Mandelbaum (107)</td>\n",
       "      <td>One Night in the Tropics (17800)</td>\n",
       "      <td>Winona Ryder (2580)</td>\n",
       "      <td>...</td>\n",
       "      <td>Mick McCarthy (121)</td>\n",
       "      <td>Sammy McIlroy (450)</td>\n",
       "      <td>Out of Time (album) (7)</td>\n",
       "      <td>Fabien Barthez (55)</td>\n",
       "      <td>Latino Velvet Project (3)</td>\n",
       "      <td>192 Nausikaa (1)</td>\n",
       "      <td>20657 Alvarez-Candal (0)</td>\n",
       "      <td>Ian Atkins (64)</td>\n",
       "      <td>Yaaradi Nee Mohini (5)</td>\n",
       "      <td>LaTroy Hawkins (46)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Uilliam Duinnn (3)</td>\n",
       "      <td>Rio de Janeiro (46)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Francisco Varela (171)</td>\n",
       "      <td>George F. Moore (lieutenant governor) (4)</td>\n",
       "      <td>John Wilkins (21)</td>\n",
       "      <td>Don Kirshner (260)</td>\n",
       "      <td>Eddie Jemison (106)</td>\n",
       "      <td>Swing Time (17796)</td>\n",
       "      <td>Daryl Hannah (2567)</td>\n",
       "      <td>...</td>\n",
       "      <td>Bobby Zamora (121)</td>\n",
       "      <td>Ben Thatcher (449)</td>\n",
       "      <td>Generator (Bad Religion album) (7)</td>\n",
       "      <td>Santiago Caizares (55)</td>\n",
       "      <td>Innocent Eyes (Delta Goodrem album) (3)</td>\n",
       "      <td>52 Europa (1)</td>\n",
       "      <td>21459 Chrisrussell (0)</td>\n",
       "      <td>Graham Rodger (64)</td>\n",
       "      <td>Jodhaa Akbar (5)</td>\n",
       "      <td>Calvin Schiraldi (46)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Vishnuvardhana (3)</td>\n",
       "      <td>Tuberculosis (46)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ogden Nash (168)</td>\n",
       "      <td>J. H. Hutchinson (4)</td>\n",
       "      <td>William Edward Forster (21)</td>\n",
       "      <td>Dan Rather (258)</td>\n",
       "      <td>Cameron Goodman (106)</td>\n",
       "      <td>You Were Never Lovelier (17794)</td>\n",
       "      <td>Dina Meyer (2542)</td>\n",
       "      <td>...</td>\n",
       "      <td>Connor Wickham (120)</td>\n",
       "      <td>Tomasz Cywka (444)</td>\n",
       "      <td>As I Am (6)</td>\n",
       "      <td>Phil Barnes (55)</td>\n",
       "      <td>The Animals (American album) (3)</td>\n",
       "      <td>2488 Bryan (1)</td>\n",
       "      <td>20608 Fredmerlin (0)</td>\n",
       "      <td>Carl Jenkinson (63)</td>\n",
       "      <td>Gentleman (film) (5)</td>\n",
       "      <td>Andrew Miller (baseball) (46)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Ramesses XI (3)</td>\n",
       "      <td>Fulham F.C. (45)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Learned Hand (167)</td>\n",
       "      <td>F. J. Mills (4)</td>\n",
       "      <td>Paul Dirac (20)</td>\n",
       "      <td>Aaron Sorkin (256)</td>\n",
       "      <td>Peter Travers (105)</td>\n",
       "      <td>Sally (1929 film) (17793)</td>\n",
       "      <td>Madonna (entertainer) (2541)</td>\n",
       "      <td>...</td>\n",
       "      <td>Michael Boulding (118)</td>\n",
       "      <td>Robert Snodgrass (442)</td>\n",
       "      <td>Seasons in the Abyss (6)</td>\n",
       "      <td>Gary Sprake (52)</td>\n",
       "      <td>We Don't Need to Whisper (3)</td>\n",
       "      <td>70 Panopaea (1)</td>\n",
       "      <td>24509 Joycechai (0)</td>\n",
       "      <td>Kyle Bartley (63)</td>\n",
       "      <td>Dheena (5)</td>\n",
       "      <td>Mickey Lolich (45)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Veera Ballala II (3)</td>\n",
       "      <td>Christmas (45)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Roberts Blossom (166)</td>\n",
       "      <td>O. E. Hailey (4)</td>\n",
       "      <td>Adam Sedgwick (20)</td>\n",
       "      <td>Elena Kagan (232)</td>\n",
       "      <td>Bob Beckel (103)</td>\n",
       "      <td>High, Wide, and Handsome (17791)</td>\n",
       "      <td>Murray Hamilton (2541)</td>\n",
       "      <td>...</td>\n",
       "      <td>Alan Curbishley (117)</td>\n",
       "      <td>Adel Taarabt (432)</td>\n",
       "      <td>In Rainbows (6)</td>\n",
       "      <td>Mervyn Day (52)</td>\n",
       "      <td>A.M. (album) (3)</td>\n",
       "      <td>1925 Franklin-Adams (1)</td>\n",
       "      <td>54522 Menaechmus (0)</td>\n",
       "      <td>Ignasi Miquel (62)</td>\n",
       "      <td>Lage Raho Munna Bhai (5)</td>\n",
       "      <td>Bartolo Coln (45)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Charles F. Hackmeyer (3)</td>\n",
       "      <td>Malta (45)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>George P. Putnam (166)</td>\n",
       "      <td>George Molyneux (4)</td>\n",
       "      <td>Charles Tennyson d'Eyncourt (20)</td>\n",
       "      <td>Groucho Marx (232)</td>\n",
       "      <td>Harvey S. Rosen (102)</td>\n",
       "      <td>Centennial Summer (17791)</td>\n",
       "      <td>Joseph Cotten (2536)</td>\n",
       "      <td>...</td>\n",
       "      <td>Peter Osgood (117)</td>\n",
       "      <td>Amdy Faye (429)</td>\n",
       "      <td>Simply Deep (6)</td>\n",
       "      <td>Martyn Margetson (51)</td>\n",
       "      <td>Horses (album) (3)</td>\n",
       "      <td>236 Honoria (1)</td>\n",
       "      <td>47002 Harlingten (0)</td>\n",
       "      <td>Chris Casper (62)</td>\n",
       "      <td>Laaga Chunari Mein Daag (5)</td>\n",
       "      <td>Todd Worrell (45)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Aistulf (3)</td>\n",
       "      <td>Social Security (United States) (45)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gareth Evans (philosopher) (165)</td>\n",
       "      <td>Walter C. Booth (4)</td>\n",
       "      <td>William Thomson, 1st Baron Kelvin (20)</td>\n",
       "      <td>Jerry O'Connell (231)</td>\n",
       "      <td>Robert Sedgwick (actor) (100)</td>\n",
       "      <td>Men of the Sky (17791)</td>\n",
       "      <td>Dom DeLuise (2535)</td>\n",
       "      <td>...</td>\n",
       "      <td>Leslie Compton (115)</td>\n",
       "      <td>Osvaldo Ardiles (424)</td>\n",
       "      <td>Freak Out! (6)</td>\n",
       "      <td>Steve Croudson (51)</td>\n",
       "      <td>Trace (album) (3)</td>\n",
       "      <td>84 Klio (1)</td>\n",
       "      <td>66843 Pulido (0)</td>\n",
       "      <td>Paolo Maldini (61)</td>\n",
       "      <td>Roja (5)</td>\n",
       "      <td>Brandon Webb (45)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Ratchis (3)</td>\n",
       "      <td>Saddam Hussein (45)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wassily Leontief (164)</td>\n",
       "      <td>Hector Roy Maclean, 5th Laird of Coll (4)</td>\n",
       "      <td>George Hamilton-Gordon, 4th Earl of Aberdeen (20)</td>\n",
       "      <td>Max Fleischer (227)</td>\n",
       "      <td>Kimberly Brooks (100)</td>\n",
       "      <td>Can't Help Singing (17791)</td>\n",
       "      <td>Bernadette Peters (2518)</td>\n",
       "      <td>...</td>\n",
       "      <td>Giuliano Grazioli (115)</td>\n",
       "      <td>Billy Hamilton (footballer) (419)</td>\n",
       "      <td>Some Girls (6)</td>\n",
       "      <td>Stephen Bywater (50)</td>\n",
       "      <td>Roger and Out (3)</td>\n",
       "      <td>Maria family (1)</td>\n",
       "      <td>64288 Lamchiuying (0)</td>\n",
       "      <td>Sergio Ramos (60)</td>\n",
       "      <td>Jab We Met (5)</td>\n",
       "      <td>Ken Holtzman (45)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>101 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Year_of_birth_unknown  \\\n",
       "0                                Diogenes Lartius (21)   \n",
       "1                                 Stephen Dingate (17)   \n",
       "2                      Andrew Gibson (footballer) (16)   \n",
       "3                                    Tom Faulkner (13)   \n",
       "4                                            L Bu (12)   \n",
       "5                          Pausanias (geographer) (12)   \n",
       "6                                       Dong Zhuo (10)   \n",
       "7                                      Theocritus (10)   \n",
       "8                                         Yuan Shu (9)   \n",
       "9                                    Tim Stevenson (9)   \n",
       "10                          Joe Harris (cricketer) (8)   \n",
       "11                                Symeon of Durham (7)   \n",
       "12                                     Kim Jong-un (7)   \n",
       "13                                 Penda of Mercia (7)   \n",
       "14                                        Stobaeus (7)   \n",
       "15                           Edwin, Earl of Mercia (6)   \n",
       "16                                     Joseph Rudd (6)   \n",
       "17                          Pye (Sussex cricketer) (6)   \n",
       "18                                    Mary Jo Pehl (6)   \n",
       "19                                Michael Knighton (6)   \n",
       "20                                   A. M. Rathnam (6)   \n",
       "21                                       Zhang Fei (6)   \n",
       "22                               Frankie Ingrassia (6)   \n",
       "23                               Pope Nicholas III (5)   \n",
       "24                                Pope Nicholas II (5)   \n",
       "25                                Sextus Empiricus (5)   \n",
       "26                      Ivan Alexander of Bulgaria (5)   \n",
       "27                           Tancred of Hauteville (5)   \n",
       "28                             Sweyn II of Denmark (5)   \n",
       "29                                         Stigand (5)   \n",
       "..                                                 ...   \n",
       "71                                Pope Benedict VI (3)   \n",
       "72                             Estrid Svendsdatter (3)   \n",
       "73                     William Smith (congressman) (3)   \n",
       "74                          John Underwood (actor) (3)   \n",
       "75                                          Morcar (3)   \n",
       "76   Nicol I Sommaripa, Lord of Paros, Tercier of N...   \n",
       "77        George Adams (football player and coach) (3)   \n",
       "78    Andronikos Doukas (general under Romanos IV) (3)   \n",
       "79                                    Thomas Cotes (3)   \n",
       "80                                   George Oldner (3)   \n",
       "81                                   Ballard Smith (3)   \n",
       "82                               Raphael Holinshed (3)   \n",
       "83                     Wakeland (London cricketer) (3)   \n",
       "84                                     Diogenianus (3)   \n",
       "85                                   Indravarman I (3)   \n",
       "86                           Edward Aburrow senior (3)   \n",
       "87                                  Pope John XIII (3)   \n",
       "88                                      Chief Gomo (3)   \n",
       "89                         Sabinianus (consul 505) (3)   \n",
       "90                                   Paul McGeough (3)   \n",
       "91                                     Xiahou Yuan (3)   \n",
       "92                                   Pope Leo VIII (3)   \n",
       "93                                      Idwal Foel (3)   \n",
       "94                                  Uilliam Duinnn (3)   \n",
       "95                                  Vishnuvardhana (3)   \n",
       "96                                     Ramesses XI (3)   \n",
       "97                                Veera Ballala II (3)   \n",
       "98                            Charles F. Hackmeyer (3)   \n",
       "99                                         Aistulf (3)   \n",
       "100                                        Ratchis (3)   \n",
       "\n",
       "                                Article_Feedback_Pilot Living_people  \\\n",
       "0                 To Kill a Mockingbird (film) (11742)           NaN   \n",
       "1                                Allen Ginsberg (4907)           NaN   \n",
       "2                                    Laserblast (2282)           NaN   \n",
       "3                                  Isaac Asimov (2072)           NaN   \n",
       "4                                      Scream 4 (2009)           NaN   \n",
       "5                               Charlize Theron (1585)           NaN   \n",
       "6                               Whitney Houston (1497)           NaN   \n",
       "7                             Dreamgirls (film) (1368)           NaN   \n",
       "8                             Wanted (2008 film) (986)           NaN   \n",
       "9                                     Matt Damon (948)           NaN   \n",
       "10                                 United States (944)           NaN   \n",
       "11                                       Al Capp (918)           NaN   \n",
       "12                               Iron Man (film) (881)           NaN   \n",
       "13                                 Kevin Costner (519)           NaN   \n",
       "14                                 Jermain Defoe (511)           NaN   \n",
       "15                            Scarlett Johansson (480)           NaN   \n",
       "16                                     Phil Ochs (472)           NaN   \n",
       "17                                 Robbie Fowler (463)           NaN   \n",
       "18                                    Elia Kazan (428)           NaN   \n",
       "19                       When Harry Met Sally... (398)           NaN   \n",
       "20                                   John Huston (347)           NaN   \n",
       "21                              Barbra Streisand (336)           NaN   \n",
       "22                                       Germany (312)           NaN   \n",
       "23                                         Japan (283)           NaN   \n",
       "24                                          Rome (249)           NaN   \n",
       "25                                         Egypt (216)           NaN   \n",
       "26                                       Ed Wood (215)           NaN   \n",
       "27                                        Russia (211)           NaN   \n",
       "28                                Henrik Larsson (204)           NaN   \n",
       "29                          United States Senate (202)           NaN   \n",
       "..                                                 ...           ...   \n",
       "71                                          Sudan (55)           NaN   \n",
       "72                                    Vanilla Ice (54)           NaN   \n",
       "73                                Michael Jackson (53)           NaN   \n",
       "74                                      San Diego (52)           NaN   \n",
       "75               United States Secretary of State (52)           NaN   \n",
       "76                                          Rocky (52)           NaN   \n",
       "77                                       Brussels (52)           NaN   \n",
       "78                         Encyclopdia Britannica (52)           NaN   \n",
       "79                                   Buenos Aires (51)           NaN   \n",
       "80   United States Environmental Protection Agency ...           NaN   \n",
       "81                                  Scooter Libby (51)           NaN   \n",
       "82   First Amendment to the United States Constitut...           NaN   \n",
       "83                                     Philosophy (50)           NaN   \n",
       "84                                           Guam (49)           NaN   \n",
       "85                     American Revolutionary War (49)           NaN   \n",
       "86                                        Jamaica (49)           NaN   \n",
       "87                                      Terrorism (49)           NaN   \n",
       "88                        Stone Cold Steve Austin (48)           NaN   \n",
       "89                                        Torture (48)           NaN   \n",
       "90                            Alexander the Great (48)           NaN   \n",
       "91                                   Samuel Pepys (47)           NaN   \n",
       "92                                        Poverty (47)           NaN   \n",
       "93                                       New Deal (47)           NaN   \n",
       "94                                 Rio de Janeiro (46)           NaN   \n",
       "95                                   Tuberculosis (46)           NaN   \n",
       "96                                    Fulham F.C. (45)           NaN   \n",
       "97                                      Christmas (45)           NaN   \n",
       "98                                          Malta (45)           NaN   \n",
       "99                Social Security (United States) (45)           NaN   \n",
       "100                                Saddam Hussein (45)           NaN   \n",
       "\n",
       "            Harvard_University_alumni  \\\n",
       "0             John F. Kennedy (62240)   \n",
       "1            William Rehnquist (8694)   \n",
       "2            John Quincy Adams (6944)   \n",
       "3            Leonard Bernstein (6203)   \n",
       "4                Norman Mailer (5969)   \n",
       "5                  T. S. Eliot (5846)   \n",
       "6            Barack Obama, Sr. (5415)   \n",
       "7           Theodore Roosevelt (5353)   \n",
       "8                   John Adams (5282)   \n",
       "9                  Cole Porter (5194)   \n",
       "10        William S. Burroughs (4634)   \n",
       "11              Pierre Trudeau (4630)   \n",
       "12           Robert F. Kennedy (3918)   \n",
       "13                 Jack Lemmon (3341)   \n",
       "14                Robert Frost (2290)   \n",
       "15                 Edward Said (2193)   \n",
       "16             John Dos Passos (2118)   \n",
       "17              William Gaddis (2117)   \n",
       "18             Walter Lippmann (1976)   \n",
       "19                 John Updike (1915)   \n",
       "20              Benazir Bhutto (1602)   \n",
       "21     Willard Van Orman Quine (1575)   \n",
       "22             Jacques Derrida (1444)   \n",
       "23               George Abbott (1432)   \n",
       "24     H. Bradford Westerfield (1419)   \n",
       "25              Nelson Goodman (1389)   \n",
       "26               Carol Chomsky (1295)   \n",
       "27                Thomas Wolfe (1139)   \n",
       "28          Nicholas Longworth (1135)   \n",
       "29      John Hawkes (novelist) (1099)   \n",
       "..                                ...   \n",
       "71                 Hyman Minsky (259)   \n",
       "72             W. E. B. Du Bois (258)   \n",
       "73                  Bobbi Sykes (247)   \n",
       "74                Charles Olson (245)   \n",
       "75           Buckminster Fuller (244)   \n",
       "76               Marcelo Fernan (243)   \n",
       "77          Pedro Albizu Campos (242)   \n",
       "78            Theodore H. White (233)   \n",
       "79          David P. McAllester (219)   \n",
       "80                 Samuel Adams (210)   \n",
       "81                 Frank O'Hara (205)   \n",
       "82                James Rossant (200)   \n",
       "83                Vincent Hanna (200)   \n",
       "84             Emile de Antonio (197)   \n",
       "85               Marilyn French (195)   \n",
       "86   Arthur M. Schlesinger, Jr. (193)   \n",
       "87       John Reed (journalist) (191)   \n",
       "88                 Julian Simon (186)   \n",
       "89                  Max Soliven (183)   \n",
       "90                 Erich Kunzel (173)   \n",
       "91         Charles Eliot Norton (172)   \n",
       "92        John Leonard (critic) (172)   \n",
       "93                  Peter Ivers (171)   \n",
       "94             Francisco Varela (171)   \n",
       "95                   Ogden Nash (168)   \n",
       "96                 Learned Hand (167)   \n",
       "97              Roberts Blossom (166)   \n",
       "98             George P. Putnam (166)   \n",
       "99   Gareth Evans (philosopher) (165)   \n",
       "100            Wassily Leontief (164)   \n",
       "\n",
       "                         Year_of_birth_missing  \\\n",
       "0                    Edward V. Hartford (1022)   \n",
       "1                    Joe Gould (manager) (663)   \n",
       "2                 John Johnstone (mayor) (458)   \n",
       "3                          Martin Snyder (326)   \n",
       "4                           Barry Garner (281)   \n",
       "5                       Ben Pon (senior) (244)   \n",
       "6                            Jean Tatlock (60)   \n",
       "7                               Glen Frey (44)   \n",
       "8                            Stanley Kerr (44)   \n",
       "9                             Lee Roberts (39)   \n",
       "10         John Hickson (cinematographer) (24)   \n",
       "11            George Hull (Massachusetts) (23)   \n",
       "12                          Roger M. Kyes (16)   \n",
       "13                           Jennifer Gan (14)   \n",
       "14                                   L Bu (12)   \n",
       "15                           Robert Lyden (11)   \n",
       "16                         Junior Sanchez (11)   \n",
       "17                           Murray Ashby (11)   \n",
       "18                    Edwin Smith (rower) (11)   \n",
       "19                            Donald Adam (11)   \n",
       "20                         Graham Jarratt (11)   \n",
       "21                           Bruce Culpan (11)   \n",
       "22                           Thomas Engel (11)   \n",
       "23                           Tony Stetson (10)   \n",
       "24                   Thomas Twisden Hodges (9)   \n",
       "25                            Eileen Wilks (9)   \n",
       "26                           Amanda Lepore (9)   \n",
       "27                             Ian Rickson (9)   \n",
       "28                     John Masterman (MP) (9)   \n",
       "29                            Peter Reilly (9)   \n",
       "..                                         ...   \n",
       "71                            Charley Aull (4)   \n",
       "72      Fred Taylor (Edwardian footballer) (4)   \n",
       "73                             Kaohelelani (4)   \n",
       "74       Hector Maclean, 4th Laird of Coll (4)   \n",
       "75           Clifford Evans (rugby league) (4)   \n",
       "76                           Alf Middleton (4)   \n",
       "77                            Dutch Voight (4)   \n",
       "78                   Billy Watkins (rugby) (4)   \n",
       "79                            John Feetham (4)   \n",
       "80                             Ollie Quinn (4)   \n",
       "81                      Johnny Jack Nounes (4)   \n",
       "82                            Gabriel Eder (4)   \n",
       "83                                 Guan Yu (4)   \n",
       "84                            Henri Callot (4)   \n",
       "85                       William A. Nimick (4)   \n",
       "86                       Jeremiah Robinson (4)   \n",
       "87                    Jimmy Kelly (hurler) (4)   \n",
       "88                             Jos Vaquero (4)   \n",
       "89             John Fleming (Devonport MP) (4)   \n",
       "90                Harry Spencer Waddington (4)   \n",
       "91                       Burpee L. Steeves (4)   \n",
       "92                        James M. Stevens (4)   \n",
       "93                       Thomas F. Terrell (4)   \n",
       "94   George F. Moore (lieutenant governor) (4)   \n",
       "95                        J. H. Hutchinson (4)   \n",
       "96                             F. J. Mills (4)   \n",
       "97                            O. E. Hailey (4)   \n",
       "98                         George Molyneux (4)   \n",
       "99                         Walter C. Booth (4)   \n",
       "100  Hector Roy Maclean, 5th Laird of Coll (4)   \n",
       "\n",
       "                          Fellows_of_the_Royal_Society  \\\n",
       "0                            Winston Churchill (37547)   \n",
       "1                                 Royal Society (1557)   \n",
       "2                             Margaret Thatcher (1013)   \n",
       "3                       Charles, Prince of Wales (326)   \n",
       "4                        William Ewart Gladstone (261)   \n",
       "5                                Richard Dawkins (194)   \n",
       "6       Arthur Wellesley, 1st Duke of Wellington (167)   \n",
       "7                              Benjamin Disraeli (161)   \n",
       "8                                  Harold Wilson (149)   \n",
       "9                                 Charles Darwin (140)   \n",
       "10                              Ramsay MacDonald (139)   \n",
       "11                                Clement Attlee (132)   \n",
       "12   Robert Gascoyne-Cecil, 3rd Marquess of Salisbu...   \n",
       "13                           Neville Chamberlain (111)   \n",
       "14                                George Canning (111)   \n",
       "15                              Harold Macmillan (105)   \n",
       "16                                Arthur Balfour (104)   \n",
       "17                                  Isaac Newton (103)   \n",
       "18                                   Robert Peel (100)   \n",
       "19           William Lamb, 2nd Viscount Melbourne (98)   \n",
       "20                                Stephen Hawking (95)   \n",
       "21                          Charles II of England (86)   \n",
       "22                                Tim Berners-Lee (84)   \n",
       "23                             Joseph Chamberlain (70)   \n",
       "24     Henry John Temple, 3rd Viscount Palmerston (62)   \n",
       "25        Robert Jenkinson, 2nd Earl of Liverpool (60)   \n",
       "26                                  Roger Penrose (57)   \n",
       "27    Henry Brougham, 1st Baron Brougham and Vaux (53)   \n",
       "28                                  Cotton Mather (50)   \n",
       "29                                 James Lovelock (49)   \n",
       "..                                                 ...   \n",
       "71                          Alfred Russel Wallace (25)   \n",
       "72                           Joseph Dalton Hooker (25)   \n",
       "73                                  J. J. Thomson (24)   \n",
       "74       Victor Cavendish, 9th Duke of Devonshire (24)   \n",
       "75                                    John Evelyn (24)   \n",
       "76                               Christopher Wren (24)   \n",
       "77                                   Andrew Wiles (24)   \n",
       "78               John Copley, 1st Baron Lyndhurst (24)   \n",
       "79                                     James Cook (24)   \n",
       "80                John Lubbock, 1st Baron Avebury (23)   \n",
       "81                             John Horton Conway (23)   \n",
       "82                                  John Herschel (23)   \n",
       "83                                  Julian Huxley (23)   \n",
       "84                                  Freeman Dyson (23)   \n",
       "85         Edward Cardwell, 1st Viscount Cardwell (23)   \n",
       "86                                   Humphry Davy (22)   \n",
       "87          William Lowther, 2nd Earl of Lonsdale (22)   \n",
       "88   Thomas Babington Macaulay, 1st Baron Macaulay ...   \n",
       "89                                   George Grote (21)   \n",
       "90              William Pitt, 1st Earl of Chatham (21)   \n",
       "91           David Lindsay, 27th Earl of Crawford (21)   \n",
       "92           Charles Lennox, 2nd Duke of Richmond (21)   \n",
       "93             George Byng, 2nd Earl of Strafford (21)   \n",
       "94                                   John Wilkins (21)   \n",
       "95                         William Edward Forster (21)   \n",
       "96                                     Paul Dirac (20)   \n",
       "97                                  Adam Sedgwick (20)   \n",
       "98                    Charles Tennyson d'Eyncourt (20)   \n",
       "99              William Thomson, 1st Baron Kelvin (20)   \n",
       "100  George Hamilton-Gordon, 4th Earl of Aberdeen (20)   \n",
       "\n",
       "               People_from_New_York_City  \\\n",
       "0                 Sydney Pollack (30121)   \n",
       "1                Leelee Sobieski (29668)   \n",
       "2                Stanley Kubrick (29579)   \n",
       "3               Stephen Sondheim (26473)   \n",
       "4                    Emmy Rossum (11286)   \n",
       "5                     Joseph Papp (9020)   \n",
       "6                  Jerome Robbins (8699)   \n",
       "7            Herman J. Mankiewicz (8532)   \n",
       "8              Theodore Roosevelt (5353)   \n",
       "9                  Allen Ginsberg (4907)   \n",
       "10                 Dorothy Fields (4111)   \n",
       "11                    Diane Arbus (3949)   \n",
       "12                     Doug Liman (3471)   \n",
       "13                Milton Friedman (3170)   \n",
       "14                 Daniel Melnick (2983)   \n",
       "15                   Ralph Lauren (2938)   \n",
       "16                   Laura Linney (2779)   \n",
       "17              Bernadette Peters (2518)   \n",
       "18                    Joe Spinell (2452)   \n",
       "19                  Judy Holliday (2421)   \n",
       "20   Paula Kelly (actress/dancer) (2346)   \n",
       "21                    John Karlen (2343)   \n",
       "22                 Leonard Maltin (2279)   \n",
       "23                Natalie Portman (2116)   \n",
       "24                  Abbie Hoffman (2040)   \n",
       "25                     Boaz Yakin (2030)   \n",
       "26           Joseph L. Mankiewicz (2003)   \n",
       "27                  Scooter Braun (1883)   \n",
       "28                  Kyra Sedgwick (1577)   \n",
       "29              Holly Marie Combs (1392)   \n",
       "..                                   ...   \n",
       "71                    Oliver Stone (382)   \n",
       "72                        Don Roos (381)   \n",
       "73                      Buck Henry (368)   \n",
       "74                     Peggy McCay (339)   \n",
       "75                    Barry Primus (339)   \n",
       "76                    Aram Saroyan (334)   \n",
       "77                    Wendy Benson (330)   \n",
       "78                   Lauren Bacall (327)   \n",
       "79               Stockard Channing (322)   \n",
       "80                    James Cagney (318)   \n",
       "81                  Jack Hirschman (316)   \n",
       "82                       Alan Alda (315)   \n",
       "83              Patricia Broderick (314)   \n",
       "84                  Flex Alexander (313)   \n",
       "85                  Burt Lancaster (310)   \n",
       "86                  Hillard Elkins (299)   \n",
       "87                  Adam Goldstein (294)   \n",
       "88                        Tina Fey (293)   \n",
       "89                    Howard Stern (291)   \n",
       "90                Jack Schwartzman (284)   \n",
       "91                   Wallace Shawn (266)   \n",
       "92                     Amanda Peet (264)   \n",
       "93                  Natasha Lyonne (261)   \n",
       "94                    Don Kirshner (260)   \n",
       "95                      Dan Rather (258)   \n",
       "96                    Aaron Sorkin (256)   \n",
       "97                     Elena Kagan (232)   \n",
       "98                    Groucho Marx (232)   \n",
       "99                 Jerry O'Connell (231)   \n",
       "100                  Max Fleischer (227)   \n",
       "\n",
       "    Year_of_birth_missing_(living_people)  \\\n",
       "0                  Aljean Harmetz (34717)   \n",
       "1              Kevyn Major Howard (29623)   \n",
       "2                    John McMartin (9332)   \n",
       "3           Jim Powell (historian) (5487)   \n",
       "4                 Michael Horowitz (2541)   \n",
       "5                    Nathan George (2347)   \n",
       "6                 Martin Gottfried (1322)   \n",
       "7                     Kate Baldwin (1312)   \n",
       "8            John Doyle (director) (1312)   \n",
       "9                   Maria Riccetto (1307)   \n",
       "10     Ben Wright (American actor) (1307)   \n",
       "11                     Aaron Lazar (1307)   \n",
       "12                    Nat Benchley (1238)   \n",
       "13                      Ralph Raico (807)   \n",
       "14                    Juliet Landau (732)   \n",
       "15                   Chuck E. Weiss (595)   \n",
       "16                    Carlos Jacott (559)   \n",
       "17                  Billy Steinberg (546)   \n",
       "18                      Philip Berg (446)   \n",
       "19                      Yehuda Berg (424)   \n",
       "20                      Joyce Piven (329)   \n",
       "21                     Lyle Kessler (322)   \n",
       "22                   Andrew Heyward (263)   \n",
       "23                       Mary Mapes (261)   \n",
       "24                   David Andelman (259)   \n",
       "25   Duncan Campbell (The Guardian) (247)   \n",
       "26                  Robert K. Weiss (217)   \n",
       "27                      Lewis Beale (212)   \n",
       "28              Sarah Lane (dancer) (210)   \n",
       "29                       Lou Hirsch (206)   \n",
       "..                                    ...   \n",
       "71                       Tom Whedon (137)   \n",
       "72                 James A. Contner (137)   \n",
       "73                 John Earl Haynes (137)   \n",
       "74                   Stacey Scowley (136)   \n",
       "75                   Marita Grabiak (135)   \n",
       "76                      Vern Gillum (135)   \n",
       "77   Elizabeth Craft and Sarah Fain (135)   \n",
       "78                   Marion Sandler (134)   \n",
       "79                    Kevin Chapman (132)   \n",
       "80              Anthony Thomopoulos (131)   \n",
       "81                      John Burgee (129)   \n",
       "82             John Regan (bassist) (128)   \n",
       "83                Martin J. Sherwin (126)   \n",
       "84                      Dale Oliver (122)   \n",
       "85            Miles Ross (producer) (120)   \n",
       "86                   Alfredo Alonso (118)   \n",
       "87                  Alan Blumenfeld (115)   \n",
       "88                    Peter Biskind (112)   \n",
       "89                 David Rubenstein (111)   \n",
       "90                       Ben Sliney (110)   \n",
       "91                       Len Munsil (109)   \n",
       "92                       Barry Hess (107)   \n",
       "93                   Ken Mandelbaum (107)   \n",
       "94                    Eddie Jemison (106)   \n",
       "95                  Cameron Goodman (106)   \n",
       "96                    Peter Travers (105)   \n",
       "97                       Bob Beckel (103)   \n",
       "98                  Harvey S. Rosen (102)   \n",
       "99          Robert Sedgwick (actor) (100)   \n",
       "100                 Kimberly Brooks (100)   \n",
       "\n",
       "                              English-language_films  \\\n",
       "0                       Rebecca (1940 film) (178798)   \n",
       "1                        The Great Ziegfeld (141533)   \n",
       "2            The Power and the Glory (film) (140577)   \n",
       "3              The Battle Over Citizen Kane (140575)   \n",
       "4                              Citizen Kane (140574)   \n",
       "5                    Sunset Boulevard (film) (80770)   \n",
       "6                         Lolita (1962 film) (72614)   \n",
       "7                            Fear and Desire (59169)   \n",
       "8                                Dirty Harry (56869)   \n",
       "9                                 Straw Dogs (53853)   \n",
       "10                 A Clockwork Orange (film) (50371)   \n",
       "11                           Dr. Strangelove (43014)   \n",
       "12                           Brief Encounter (41521)   \n",
       "13                            Ed Wood (film) (38771)   \n",
       "14            Invasion of the Body Snatchers (36620)   \n",
       "15                   Plan 9 from Outer Space (36616)   \n",
       "16             The Day the Earth Stood Still (36556)   \n",
       "17                            Apocalypse Now (36112)   \n",
       "18                        Hamlet (1948 film) (34564)   \n",
       "19                        The Shining (film) (33663)   \n",
       "20                               Reds (film) (33174)   \n",
       "21                       There Will Be Blood (33131)   \n",
       "22                           One, Two, Three (32416)   \n",
       "23              Suddenly, Last Summer (film) (32400)   \n",
       "24                 Lawrence of Arabia (film) (32396)   \n",
       "25                            Hamburger Hill (30931)   \n",
       "26                          Fast and Furious (30814)   \n",
       "27           Alice in Wonderland (2010 film) (30812)   \n",
       "28               An American in Paris (film) (30401)   \n",
       "29                           Fantasia (film) (29780)   \n",
       "..                                               ...   \n",
       "71                    Intermezzo (1939 film) (20625)   \n",
       "72                              Analyze That (19986)   \n",
       "73                     Good Morning, Vietnam (19984)   \n",
       "74                               Toys (film) (19981)   \n",
       "75                  The Perfect Storm (film) (19979)   \n",
       "76                         Cover Girl (film) (18596)   \n",
       "77                       Ben-Hur (1959 film) (18339)   \n",
       "78                   The Human Comedy (film) (18336)   \n",
       "79                      Manpower (1941 film) (18329)   \n",
       "80            The Maltese Falcon (1941 film) (18326)   \n",
       "81                       Since You Went Away (18324)   \n",
       "82                   Double Indemnity (film) (18323)   \n",
       "83                              Going My Way (18308)   \n",
       "84                                 Stalag 17 (18301)   \n",
       "85                      Five Graves to Cairo (18301)   \n",
       "86   Witness for the Prosecution (1957 film) (18299)   \n",
       "87                              Ball of Fire (18298)   \n",
       "88                        The Fortune Cookie (18298)   \n",
       "89                        Hold Back the Dawn (18296)   \n",
       "90                            The Wild Bunch (17918)   \n",
       "91                            Horse Feathers (17803)   \n",
       "92                     Show Boat (1936 film) (17800)   \n",
       "93                  One Night in the Tropics (17800)   \n",
       "94                                Swing Time (17796)   \n",
       "95                   You Were Never Lovelier (17794)   \n",
       "96                         Sally (1929 film) (17793)   \n",
       "97                  High, Wide, and Handsome (17791)   \n",
       "98                         Centennial Summer (17791)   \n",
       "99                            Men of the Sky (17791)   \n",
       "100                       Can't Help Singing (17791)   \n",
       "\n",
       "                 American_film_actors  \\\n",
       "0                R. Lee Ermey (59381)   \n",
       "1                 James Woods (54368)   \n",
       "2               James Marsden (54080)   \n",
       "3               Kate Bosworth (54045)   \n",
       "4                Beau Bridges (54041)   \n",
       "5                 Stacy Keach (54019)   \n",
       "6              Walton Goggins (53915)   \n",
       "7                  Laz Alonso (53895)   \n",
       "8                  Rhys Coiro (53894)   \n",
       "9               Willa Holland (53868)   \n",
       "10                 Mel Gibson (35644)   \n",
       "11               Jean Simmons (34713)   \n",
       "12        Richard Chamberlain (34682)   \n",
       "13               Alan Cumming (32091)   \n",
       "14              Nicole Kidman (31979)   \n",
       "15               Bruce Willis (30751)   \n",
       "16          Vincent D'Onofrio (30204)   \n",
       "17             Sydney Pollack (30121)   \n",
       "18             Matthew Modine (29879)   \n",
       "19       Anthony Michael Hall (29770)   \n",
       "20               Adam Baldwin (29727)   \n",
       "21              Arliss Howard (29699)   \n",
       "22                  Ed O'Ross (29688)   \n",
       "23            Leelee Sobieski (29668)   \n",
       "24         John Terry (actor) (29649)   \n",
       "25              Thomas Gibson (29649)   \n",
       "26               Vinessa Shaw (29646)   \n",
       "27         Kevyn Major Howard (29623)   \n",
       "28                Tim Colceri (29617)   \n",
       "29              Alfred Molina (26391)   \n",
       "..                                ...   \n",
       "71                Jodie Foster (3368)   \n",
       "72                 Jack Lemmon (3341)   \n",
       "73                  Tom Cruise (3341)   \n",
       "74                Nicolas Cage (3327)   \n",
       "75               Martin Landau (3310)   \n",
       "76   Robert Montgomery (actor) (3182)   \n",
       "77                Steve Martin (3037)   \n",
       "78           Leonardo DiCaprio (2962)   \n",
       "79              Roddy McDowall (2926)   \n",
       "80          Christopher Walken (2917)   \n",
       "81              Timothy Hutton (2905)   \n",
       "82              Clint Eastwood (2808)   \n",
       "83                Laura Linney (2779)   \n",
       "84               Lynn Redgrave (2753)   \n",
       "85            Shirley MacLaine (2705)   \n",
       "86             Barbara Bouchet (2682)   \n",
       "87            Carroll O'Connor (2674)   \n",
       "88                   John Hoyt (2637)   \n",
       "89                Fred Astaire (2631)   \n",
       "90               David Clennon (2623)   \n",
       "91                Oliver Platt (2608)   \n",
       "92             Chris O'Donnell (2604)   \n",
       "93                Winona Ryder (2580)   \n",
       "94                Daryl Hannah (2567)   \n",
       "95                  Dina Meyer (2542)   \n",
       "96       Madonna (entertainer) (2541)   \n",
       "97             Murray Hamilton (2541)   \n",
       "98               Joseph Cotten (2536)   \n",
       "99                 Dom DeLuise (2535)   \n",
       "100          Bernadette Peters (2518)   \n",
       "\n",
       "                         ...                        \\\n",
       "0                        ...                         \n",
       "1                        ...                         \n",
       "2                        ...                         \n",
       "3                        ...                         \n",
       "4                        ...                         \n",
       "5                        ...                         \n",
       "6                        ...                         \n",
       "7                        ...                         \n",
       "8                        ...                         \n",
       "9                        ...                         \n",
       "10                       ...                         \n",
       "11                       ...                         \n",
       "12                       ...                         \n",
       "13                       ...                         \n",
       "14                       ...                         \n",
       "15                       ...                         \n",
       "16                       ...                         \n",
       "17                       ...                         \n",
       "18                       ...                         \n",
       "19                       ...                         \n",
       "20                       ...                         \n",
       "21                       ...                         \n",
       "22                       ...                         \n",
       "23                       ...                         \n",
       "24                       ...                         \n",
       "25                       ...                         \n",
       "26                       ...                         \n",
       "27                       ...                         \n",
       "28                       ...                         \n",
       "29                       ...                         \n",
       "..                       ...                         \n",
       "71                       ...                         \n",
       "72                       ...                         \n",
       "73                       ...                         \n",
       "74                       ...                         \n",
       "75                       ...                         \n",
       "76                       ...                         \n",
       "77                       ...                         \n",
       "78                       ...                         \n",
       "79                       ...                         \n",
       "80                       ...                         \n",
       "81                       ...                         \n",
       "82                       ...                         \n",
       "83                       ...                         \n",
       "84                       ...                         \n",
       "85                       ...                         \n",
       "86                       ...                         \n",
       "87                       ...                         \n",
       "88                       ...                         \n",
       "89                       ...                         \n",
       "90                       ...                         \n",
       "91                       ...                         \n",
       "92                       ...                         \n",
       "93                       ...                         \n",
       "94                       ...                         \n",
       "95                       ...                         \n",
       "96                       ...                         \n",
       "97                       ...                         \n",
       "98                       ...                         \n",
       "99                       ...                         \n",
       "100                      ...                         \n",
       "\n",
       "                         English_footballers  \\\n",
       "0                        Wayne Rooney (1458)   \n",
       "1                        Alan Shearer (1293)   \n",
       "2                        Michael Owen (1233)   \n",
       "3                        Peter Crouch (1181)   \n",
       "4                    Teddy Sheringham (1048)   \n",
       "5                         Theo Walcott (994)   \n",
       "6                        Jermain Defoe (511)   \n",
       "7                        Robbie Fowler (463)   \n",
       "8                        David Beckham (438)   \n",
       "9                        John Aldridge (414)   \n",
       "10                        Gary Lineker (376)   \n",
       "11                         Darren Bent (361)   \n",
       "12                       Jimmy Greaves (350)   \n",
       "13                      Harry Redknapp (339)   \n",
       "14                          Neil Woods (303)   \n",
       "15                         Geoff Hurst (300)   \n",
       "16                       Henry Cursham (273)   \n",
       "17   Alan Smith (footballer born 1962) (255)   \n",
       "18                        Nigel Clough (253)   \n",
       "19                         Micky Adams (248)   \n",
       "20         Kevin Phillips (footballer) (239)   \n",
       "21                        Andy Carroll (237)   \n",
       "22                        Glenn Hoddle (234)   \n",
       "23                       Sam Allardyce (231)   \n",
       "24           Brian Little (footballer) (231)   \n",
       "25                     Steve Ogrizovic (221)   \n",
       "26                         Dion Dublin (213)   \n",
       "27                         Clive Allen (213)   \n",
       "28                         Alan Pardew (211)   \n",
       "29                      Steve McClaren (211)   \n",
       "..                                       ...   \n",
       "71                          Brian Laws (140)   \n",
       "72                        Ronnie Moore (140)   \n",
       "73                  Gabriel Agbonlahor (139)   \n",
       "74                        Stan Ternent (138)   \n",
       "75          Graham Taylor (footballer) (138)   \n",
       "76                          John Terry (136)   \n",
       "77       Dave Jones (football manager) (136)   \n",
       "78                        Bill Dearden (136)   \n",
       "79                   Jermaine Beckford (134)   \n",
       "80                         Jay Simpson (133)   \n",
       "81                       Ronnie Jepson (132)   \n",
       "82                         Lee Chapman (131)   \n",
       "83                       Steve Coppell (129)   \n",
       "84            John Barnes (footballer) (129)   \n",
       "85                       Ray Lewington (128)   \n",
       "86                          Akpo Sodje (128)   \n",
       "87                      Lawrie Sanchez (127)   \n",
       "88                        Ashley Young (127)   \n",
       "89                          Peter Reid (127)   \n",
       "90                         Daryl Clare (124)   \n",
       "91         Gary Alexander (footballer) (122)   \n",
       "92                         Paul Jewell (122)   \n",
       "93                       Mick McCarthy (121)   \n",
       "94                        Bobby Zamora (121)   \n",
       "95                      Connor Wickham (120)   \n",
       "96                    Michael Boulding (118)   \n",
       "97                     Alan Curbishley (117)   \n",
       "98                        Peter Osgood (117)   \n",
       "99                      Leslie Compton (115)   \n",
       "100                  Giuliano Grazioli (115)   \n",
       "\n",
       "                  The_Football_League_players  \\\n",
       "0                        Kevin Keegan (10757)   \n",
       "1                       Kenny Dalglish (6371)   \n",
       "2                         Eric Cantona (6024)   \n",
       "3                       Graeme Souness (5016)   \n",
       "4                          Mark Hughes (4966)   \n",
       "5                           Ryan Giggs (4561)   \n",
       "6                             Ian Rush (4438)   \n",
       "7                            Roy Keane (3758)   \n",
       "8                           Iain Dowie (2897)   \n",
       "9                          Joe Kinnear (2559)   \n",
       "10                        Robbie Keane (2554)   \n",
       "11                     Gordon Strachan (2367)   \n",
       "12                         David Moyes (2353)   \n",
       "13                         Alan Hansen (1882)   \n",
       "14                         George Best (1871)   \n",
       "15                        Dwight Yorke (1817)   \n",
       "16                      Martin O'Neill (1787)   \n",
       "17                          Martin Jol (1783)   \n",
       "18                          Shay Given (1757)   \n",
       "19                       Nat Lofthouse (1713)   \n",
       "20          George Graham (footballer) (1710)   \n",
       "21                         Neil Lennon (1624)   \n",
       "22                    Nicklas Bendtner (1605)   \n",
       "23                     Gary McAllister (1551)   \n",
       "24                         Damien Duff (1495)   \n",
       "25                       Geremi Njitap (1457)   \n",
       "26                       Dean Saunders (1443)   \n",
       "27                          Roger Hunt (1422)   \n",
       "28            Antti Niemi (footballer) (1278)   \n",
       "29                    Richie Partridge (1258)   \n",
       "..                                        ...   \n",
       "71                           Ched Evans (611)   \n",
       "72                          Brian Carey (564)   \n",
       "73   Dave Mackay (footballer born 1934) (544)   \n",
       "74                             Jan Mlby (544)   \n",
       "75                            Denis Law (536)   \n",
       "76                        Chris Iwelumo (535)   \n",
       "77                           Liam Brady (532)   \n",
       "78                           Bryan Gunn (511)   \n",
       "79                          Mo Johnston (495)   \n",
       "80              Joe Jordan (footballer) (488)   \n",
       "81                         Brad Friedel (485)   \n",
       "82                         Ally McCoist (479)   \n",
       "83                        Tore Andr Flo (470)   \n",
       "84                         Pat Jennings (468)   \n",
       "85                        Kenwyne Jones (467)   \n",
       "86                         Ian St. John (467)   \n",
       "87                       Charlie Miller (462)   \n",
       "88                           Jim Gannon (458)   \n",
       "89                        Robbie Savage (457)   \n",
       "90                         John Charles (455)   \n",
       "91                      Anthony Gerrard (454)   \n",
       "92                         Kenny Miller (453)   \n",
       "93                        Sammy McIlroy (450)   \n",
       "94                         Ben Thatcher (449)   \n",
       "95                         Tomasz Cywka (444)   \n",
       "96                     Robert Snodgrass (442)   \n",
       "97                         Adel Taarabt (432)   \n",
       "98                            Amdy Faye (429)   \n",
       "99                      Osvaldo Ardiles (424)   \n",
       "100         Billy Hamilton (footballer) (419)   \n",
       "\n",
       "                        English-language_albums  \\\n",
       "0                       Definitely Maybe (1881)   \n",
       "1            A Grand Don't Come for Free (1873)   \n",
       "2                               Let It Be (416)   \n",
       "3    Sgt. Pepper's Lonely Hearts Club Band (35)   \n",
       "4                          The Joshua Tree (32)   \n",
       "5                      The Beatles (album) (18)   \n",
       "6                               Pet Sounds (17)   \n",
       "7              John Wesley Harding (album) (17)   \n",
       "8                         Thriller (album) (16)   \n",
       "9                         Revolver (album) (16)   \n",
       "10                                Illmatic (15)   \n",
       "11                              Abbey Road (15)   \n",
       "12               The Dark Side of the Moon (15)   \n",
       "13                        Please Please Me (13)   \n",
       "14               I Dreamed a Dream (album) (13)   \n",
       "15                 Sweetheart of the Rodeo (13)   \n",
       "16              A Hard Day's Night (album) (12)   \n",
       "17                             Rubber Soul (12)   \n",
       "18                       Nashville Skyline (12)   \n",
       "19                Appetite for Destruction (11)   \n",
       "20         Enter the Wu-Tang (36 Chambers) (11)   \n",
       "21              Harvest (Neil Young album) (11)   \n",
       "22                    All Things Must Pass (11)   \n",
       "23                     Blood on the Tracks (11)   \n",
       "24                           Smash (album) (11)   \n",
       "25          The Piper at the Gates of Dawn (10)   \n",
       "26           Fearless (Taylor Swift album) (10)   \n",
       "27                                The Wall (10)   \n",
       "28                           Some Gave All (10)   \n",
       "29              The Freewheelin' Bob Dylan (10)   \n",
       "..                                          ...   \n",
       "71                       The Basement Tapes (7)   \n",
       "72                             Let It Bleed (7)   \n",
       "73                          Cosmo's Factory (7)   \n",
       "74             How Could Hell Be Any Worse? (7)   \n",
       "75                   Younger Than Yesterday (7)   \n",
       "76                          Beggars Banquet (7)   \n",
       "77                Bringing It All Back Home (7)   \n",
       "78                          The Blueprint 3 (7)   \n",
       "79                               Who's Next (7)   \n",
       "80                      Use Your Illusion I (7)   \n",
       "81                    From Elvis in Memphis (7)   \n",
       "82                     Led Zeppelin (album) (7)   \n",
       "83                        Metallica (album) (7)   \n",
       "84                     Headquarters (album) (7)   \n",
       "85                        Late Registration (7)   \n",
       "86                  The Marshall Mathers LP (7)   \n",
       "87                         Dusty in Memphis (7)   \n",
       "88                     Off the Wall (album) (7)   \n",
       "89                      The College Dropout (7)   \n",
       "90          No Control (Bad Religion album) (7)   \n",
       "91                  Recovery (Eminem album) (7)   \n",
       "92                      After the Gold Rush (7)   \n",
       "93                      Out of Time (album) (7)   \n",
       "94           Generator (Bad Religion album) (7)   \n",
       "95                                  As I Am (6)   \n",
       "96                     Seasons in the Abyss (6)   \n",
       "97                              In Rainbows (6)   \n",
       "98                              Simply Deep (6)   \n",
       "99                               Freak Out! (6)   \n",
       "100                              Some Girls (6)   \n",
       "\n",
       "             Association_football_goalkeepers  \\\n",
       "0    Goalkeeper (association football) (3125)   \n",
       "1                           Shay Given (1757)   \n",
       "2             Antti Niemi (footballer) (1278)   \n",
       "3                       Mark Schwarzer (1213)   \n",
       "4                      Bruce Grobbelaar (824)   \n",
       "5                      Neville Southall (704)   \n",
       "6                         Neil Sullivan (677)   \n",
       "7                            Bryan Gunn (511)   \n",
       "8                          Brad Friedel (485)   \n",
       "9                          Pat Jennings (468)   \n",
       "10                      Ricardo Pereira (405)   \n",
       "11                          Oliver Kahn (376)   \n",
       "12                          Nick Colgan (365)   \n",
       "13                       Thomas Srensen (321)   \n",
       "14                        Magnus Hedman (297)   \n",
       "15                           John Filan (260)   \n",
       "16                      Wayne Hennessey (249)   \n",
       "17                          Hans Segers (241)   \n",
       "18                      Steve Ogrizovic (221)   \n",
       "19       Mike Walker (Welsh footballer) (220)   \n",
       "20                     Marcus Hahnemann (215)   \n",
       "21                          Maik Taylor (203)   \n",
       "22                          Roy Carroll (198)   \n",
       "23             David James (footballer) (174)   \n",
       "24                         David Seaman (173)   \n",
       "25                        Peter Shilton (169)   \n",
       "26                          Harry Gregg (161)   \n",
       "27                         Vito Mannone (161)   \n",
       "28              Paul Jones (footballer) (157)   \n",
       "29                           Don Mackay (155)   \n",
       "..                                        ...   \n",
       "71               Brad Jones (footballer) (74)   \n",
       "72                              Petr ech (72)   \n",
       "73                          Gordon Banks (72)   \n",
       "74                          Greg Fleming (69)   \n",
       "75                          Walter Zenga (68)   \n",
       "76                           Lewis Price (67)   \n",
       "77                           Boaz Myhill (67)   \n",
       "78                        Robert Olejnik (67)   \n",
       "79                          Ray Clemence (66)   \n",
       "80                             Mart Poom (66)   \n",
       "81                       David Stockdale (66)   \n",
       "82                          Stewart Kerr (64)   \n",
       "83                     Bartosz Biakowski (62)   \n",
       "84                          Scott Carson (61)   \n",
       "85                           Scott Howie (61)   \n",
       "86                            Brad Guzan (61)   \n",
       "87                          Jens Lehmann (61)   \n",
       "88                          Joe Corrigan (61)   \n",
       "89                           Nico Vaesen (60)   \n",
       "90                           Saul Deeney (59)   \n",
       "91                            Tim Howard (59)   \n",
       "92                        Espen Baardsen (58)   \n",
       "93                        Fabien Barthez (55)   \n",
       "94                     Santiago Caizares (55)   \n",
       "95                           Phil Barnes (55)   \n",
       "96                           Gary Sprake (52)   \n",
       "97                            Mervyn Day (52)   \n",
       "98                      Martyn Margetson (51)   \n",
       "99                        Steve Croudson (51)   \n",
       "100                      Stephen Bywater (50)   \n",
       "\n",
       "                                          Debut_albums  \\\n",
       "0                              Definitely Maybe (1881)   \n",
       "1                                        Illmatic (15)   \n",
       "2                       I Dreamed a Dream (album) (13)   \n",
       "3                                Please Please Me (13)   \n",
       "4                        Appetite for Destruction (11)   \n",
       "5                 Enter the Wu-Tang (36 Chambers) (11)   \n",
       "6                  The Piper at the Gates of Dawn (10)   \n",
       "7                                   Some Gave All (10)   \n",
       "8                                     The Chronic (10)   \n",
       "9                            Ten (Pearl Jam album) (9)   \n",
       "10                      Spirit (Leona Lewis album) (9)   \n",
       "11                      The Rolling Stones (album) (9)   \n",
       "12                                Reasonable Doubt (9)   \n",
       "13                                   Spice (album) (8)   \n",
       "14                                        The Fame (8)   \n",
       "15                                    Kill 'Em All (8)   \n",
       "16                                 The Documentary (8)   \n",
       "17                                      Doggystyle (7)   \n",
       "18                                   Tubular Bells (7)   \n",
       "19                    How Could Hell Be Any Worse? (7)   \n",
       "20                            Led Zeppelin (album) (7)   \n",
       "21                             The College Dropout (7)   \n",
       "22                               Come Away with Me (6)   \n",
       "23                In the Court of the Crimson King (6)   \n",
       "24                                    Ready to Die (6)   \n",
       "25                             Dangerously in Love (6)   \n",
       "26                            Animal (Kesha album) (6)   \n",
       "27                                     Simply Deep (6)   \n",
       "28                           Black Sabbath (album) (6)   \n",
       "29                                      Freak Out! (6)   \n",
       "..                                                 ...   \n",
       "71                             The Monkees (album) (3)   \n",
       "72                        Hand Sown ... Home Grown (3)   \n",
       "73                      The Barbra Streisand Album (3)   \n",
       "74                              Funkadelic (album) (3)   \n",
       "75                                  The Unraveling (3)   \n",
       "76                            Taylor Swift (album) (3)   \n",
       "77                           St. Elsewhere (album) (3)   \n",
       "78                              Pacific Ocean Blue (3)   \n",
       "79                                Hello, I'm Dolly (3)   \n",
       "80                                             OP8 (3)   \n",
       "81                              Song Cycle (album) (3)   \n",
       "82                                     Don't Do It (3)   \n",
       "83                The Thoughts of Emerlist Davjack (3)   \n",
       "84                 Do You Believe in Magic (album) (3)   \n",
       "85            Who Needs Actions When You Got Words (3)   \n",
       "86                         America (America album) (3)   \n",
       "87                                    The Mechanix (3)   \n",
       "88                                     Fresh Cream (3)   \n",
       "89                           No Depression (album) (3)   \n",
       "90   One Nation Underground (Pearls Before Swine al...   \n",
       "91                                     Lumpy Gravy (3)   \n",
       "92        Niandra Lades and Usually Just a T-Shirt (3)   \n",
       "93                           Latino Velvet Project (3)   \n",
       "94             Innocent Eyes (Delta Goodrem album) (3)   \n",
       "95                    The Animals (American album) (3)   \n",
       "96                        We Don't Need to Whisper (3)   \n",
       "97                                    A.M. (album) (3)   \n",
       "98                                  Horses (album) (3)   \n",
       "99                                   Trace (album) (3)   \n",
       "100                                  Roger and Out (3)   \n",
       "\n",
       "         Main_Belt_asteroids Asteroids_named_for_people  \\\n",
       "0      Asteroid belt (10555)     5535 Annefrank (10555)   \n",
       "1        Cybele asteroid (7)      2685 Masursky (10555)   \n",
       "2           3355 Onizuka (6)          4055 Magellan (2)   \n",
       "3         3352 McAuliffe (6)           1580 Betulia (1)   \n",
       "4            3353 Jarvis (6)              1685 Toro (1)   \n",
       "5            3356 Resnik (6)            878 Mildred (1)   \n",
       "6            3350 Scobee (6)            254 Augusta (1)   \n",
       "7            3354 McNair (6)          25098 Gridnev (0)   \n",
       "8             3351 Smith (6)     25113 Benwasserman (0)   \n",
       "9           253 Mathilde (5)     25103 Kimdongyoung (0)   \n",
       "10     9619 Terrygilliam (5)           25111 Klokun (0)   \n",
       "11       9618 Johncleese (5)           25119 Kakani (0)   \n",
       "12    9617 Grahamchapman (5)       25047 Tsuitehsin (0)   \n",
       "13         9620 Ericidle (5)       25099 Mashinskiy (0)   \n",
       "14     9621 Michaelpalin (5)       25050 Michmadsen (0)   \n",
       "15       9622 Terryjones (5)          24986 Yalefan (0)   \n",
       "16      20296 Shayestorm (4)      25106 Ryoojungmin (0)   \n",
       "17       20341 Alanstack (4)           22558 Mladen (0)   \n",
       "18         1589 Fanatica (4)           22512 Cannat (0)   \n",
       "19            45 Eugenia (4)      22519 Gerardklein (0)   \n",
       "20     17233 Stanshapiro (4)        22168 Weissflog (0)   \n",
       "21       20586 Elizkolod (4)   24968 Chernyakhovsky (0)   \n",
       "22      21355 Pikovskaya (4)         24977 Tongzhan (0)   \n",
       "23                7 Iris (4)           24985 Benuri (0)   \n",
       "24            15 Eunomia (4)     25049 Christofnorn (0)   \n",
       "25                6 Hebe (3)     25104 Chohyunghoon (0)   \n",
       "26           Nysa family (3)            25115 Drago (0)   \n",
       "27              9965 GNU (3)         21775 Tsiganis (0)   \n",
       "28         9793 Torvalds (3)          20465 Vervack (0)   \n",
       "29            9885 Linux (3)          23890 Quindou (0)   \n",
       "..                       ...                        ...   \n",
       "71         162 Laurentia (1)       24353 Patrickhsu (0)   \n",
       "72            51 Nemausa (1)              24354 Caz (0)   \n",
       "73            248 Lameia (1)       24369 Evanichols (0)   \n",
       "74              4797 Ako (1)      24432 Elizamcnitt (0)   \n",
       "75           687 Tinette (1)      24422 Helentressa (0)   \n",
       "76        4303 Savitskij (1)         24493 McCommon (0)   \n",
       "77      3952 Russellmark (1)     24492 Nathanmonroe (0)   \n",
       "78             106 Dione (1)      24494 Megmoulding (0)   \n",
       "79            19 Fortuna (1)        24474 Ananthram (0)   \n",
       "80         1462 Zamenhof (1)      24464 Williamkalb (0)   \n",
       "81    26734 Terryfarrell (1)      24410 Juliewalker (0)   \n",
       "82     26733 Nanavisitor (1)        24316 Anncooper (0)   \n",
       "83          8380 Tooting (1)       24397 Parkerowan (0)   \n",
       "84           7507 Israel (1)          24387 Trettel (0)   \n",
       "85            25 Phocaea (1)         24386 McLindon (0)   \n",
       "86           4923 Clarke (1)         24385 Katcagen (0)   \n",
       "87           5020 Asimov (1)     24378 Katelyngibbs (0)   \n",
       "88   Frank Pieter Israel (1)           24376 Ramesh (0)   \n",
       "89         18244 Anneila (1)       24372 Timobauman (0)   \n",
       "90             1838 Ursa (1)        24351 Fionawood (0)   \n",
       "91         11 Parthenope (1)       24347 Arthurkuan (0)   \n",
       "92      5815 Shinsengumi (1)         24370 Marywang (0)   \n",
       "93          192 Nausikaa (1)   20657 Alvarez-Candal (0)   \n",
       "94             52 Europa (1)     21459 Chrisrussell (0)   \n",
       "95            2488 Bryan (1)       20608 Fredmerlin (0)   \n",
       "96           70 Panopaea (1)        24509 Joycechai (0)   \n",
       "97   1925 Franklin-Adams (1)       54522 Menaechmus (0)   \n",
       "98           236 Honoria (1)       47002 Harlingten (0)   \n",
       "99               84 Klio (1)           66843 Pulido (0)   \n",
       "100         Maria family (1)      64288 Lamchiuying (0)   \n",
       "\n",
       "                   Association_football_defenders  \\\n",
       "0                              Alan Hansen (1882)   \n",
       "1                            Geremi Njitap (1457)   \n",
       "2                               Gareth Bale (741)   \n",
       "3                          Colin Calderwood (735)   \n",
       "4                              Colin Hendry (622)   \n",
       "5                                Jim Gannon (458)   \n",
       "6                           Anthony Gerrard (454)   \n",
       "7                            Steve Staunton (415)   \n",
       "8                            Frank Sinclair (410)   \n",
       "9                               Kyle Walker (380)   \n",
       "10                    Abdoulaye Diagne-Faye (377)   \n",
       "11                              Jonny Evans (333)   \n",
       "12                          Franck Queudrue (325)   \n",
       "13                           Ritchie Sutton (301)   \n",
       "14                Paul McGrath (footballer) (299)   \n",
       "15                            Ricky Sbragia (270)   \n",
       "16                            Richard Dunne (270)   \n",
       "17                                Phil Babb (260)   \n",
       "18                              Steve Nicol (254)   \n",
       "19                              Micky Adams (248)   \n",
       "20   Michael Johnson (footballer born 1973) (247)   \n",
       "21                       Jos Enrique Snchez (241)   \n",
       "22                                Efe Sodje (231)   \n",
       "23                       Fabricio Coloccini (225)   \n",
       "24          Paul McShane (Irish footballer) (221)   \n",
       "25                  Eric Young (footballer) (214)   \n",
       "26                              Dion Dublin (213)   \n",
       "27                            Glenn Loovens (206)   \n",
       "28                               Pat Scully (200)   \n",
       "29                             Glenn Roeder (200)   \n",
       "..                                            ...   \n",
       "71                         Laurent Koscielny (79)   \n",
       "72                               Mal Donaghy (79)   \n",
       "73                  Steven Watt (footballer) (78)   \n",
       "74                              Bacary Sagna (78)   \n",
       "75                             Roy McFarland (77)   \n",
       "76                             Richard Gough (77)   \n",
       "77                              Jeff Hopkins (76)   \n",
       "78                  Paul Parker (footballer) (75)   \n",
       "79                                 Alex Song (74)   \n",
       "80                             Richard Money (74)   \n",
       "81                    Knut Anders Fostervold (73)   \n",
       "82                              Kieran Gibbs (72)   \n",
       "83                           Chris Hutchings (72)   \n",
       "84                        Sbastien Squillaci (72)   \n",
       "85                               Chris Baird (70)   \n",
       "86                             Johan Djourou (70)   \n",
       "87                                Paul Hurst (70)   \n",
       "88                              Julian Dicks (68)   \n",
       "89                              Alvin Martin (66)   \n",
       "90                             Andy Morrison (66)   \n",
       "91                          Ricardo Carvalho (65)   \n",
       "92                             Neill Collins (65)   \n",
       "93                                Ian Atkins (64)   \n",
       "94                             Graham Rodger (64)   \n",
       "95                            Carl Jenkinson (63)   \n",
       "96                              Kyle Bartley (63)   \n",
       "97                             Ignasi Miquel (62)   \n",
       "98                              Chris Casper (62)   \n",
       "99                             Paolo Maldini (61)   \n",
       "100                             Sergio Ramos (60)   \n",
       "\n",
       "                      Indian_films  \\\n",
       "0                 Neeraj Vora (31)   \n",
       "1        Bend It Like Beckham (23)   \n",
       "2          Amar Akbar Anthony (18)   \n",
       "3                       Hisss (17)   \n",
       "4                      Sholay (17)   \n",
       "5                     Chhalia (16)   \n",
       "6                       Vaali (16)   \n",
       "7                        Mard (15)   \n",
       "8                Chandramukhi (15)   \n",
       "9          Suhaag (1979 film) (15)   \n",
       "10            Aa Gale Lag Jaa (15)   \n",
       "11            Bhai Ho To Aisa (14)   \n",
       "12        Raampur Ka Lakshman (14)   \n",
       "13              Sachaa Jhutha (14)   \n",
       "14             Chacha Bhatija (14)   \n",
       "15    Dharam Veer (1977 film) (14)   \n",
       "16                  Budtameez (14)   \n",
       "17         Coolie (1983 film) (14)   \n",
       "18                Desh Premee (14)   \n",
       "19               Om Shanti Om (13)   \n",
       "20                   Enthiran (11)   \n",
       "21              Gandhi (film) (11)   \n",
       "22             Chennai 600028 (11)   \n",
       "23        Rab Ne Bana Di Jodi (10)   \n",
       "24                       Ajay (10)   \n",
       "25               Mother India (10)   \n",
       "26                      Lagaan (9)   \n",
       "27                  Bommarillu (9)   \n",
       "28                   Madhumati (9)   \n",
       "29          Pokiri (2006 film) (9)   \n",
       "..                             ...   \n",
       "71                    Baazigar (6)   \n",
       "72             My Name Is Khan (6)   \n",
       "73             Golmaal Returns (6)   \n",
       "74                Force (film) (6)   \n",
       "75                   Manmadhan (6)   \n",
       "76               Dasavathaaram (6)   \n",
       "77               Kadhal Kottai (6)   \n",
       "78              K. T. Kunjumon (6)   \n",
       "79                      Swades (6)   \n",
       "80                 Penn (film) (6)   \n",
       "81   Thulladha Manamum Thullum (5)   \n",
       "82       Parineeta (2005 film) (5)   \n",
       "83             Madrasapattinam (5)   \n",
       "84                Satya (film) (5)   \n",
       "85                Kadhal Desam (5)   \n",
       "86           7G Rainbow Colony (5)   \n",
       "87    Vinnaithaandi Varuvaayaa (5)   \n",
       "88                     Dhoom 2 (5)   \n",
       "89           Bachna Ae Haseeno (5)   \n",
       "90                       Eeram (5)   \n",
       "91                Naan Kadavul (5)   \n",
       "92                      Paiyaa (5)   \n",
       "93          Yaaradi Nee Mohini (5)   \n",
       "94                Jodhaa Akbar (5)   \n",
       "95            Gentleman (film) (5)   \n",
       "96                      Dheena (5)   \n",
       "97        Lage Raho Munna Bhai (5)   \n",
       "98     Laaga Chunari Mein Daag (5)   \n",
       "99                        Roja (5)   \n",
       "100                 Jab We Met (5)   \n",
       "\n",
       "                    Major_League_Baseball_pitchers  \n",
       "0                              Roger Clemens (310)  \n",
       "1                                 Nolan Ryan (245)  \n",
       "2                               Sandy Koufax (214)  \n",
       "3                              Randy Johnson (211)  \n",
       "4                                 Tom Seaver (191)  \n",
       "5                             Mariano Rivera (179)  \n",
       "6                                 Bob Gibson (161)  \n",
       "7                               Roy Halladay (158)  \n",
       "8                             Curt Schilling (153)  \n",
       "9                              Pedro Martnez (144)  \n",
       "10                               Greg Maddux (134)  \n",
       "11                          Dennis Eckersley (133)  \n",
       "12                             Steve Carlton (132)  \n",
       "13                                Derek Lowe (128)  \n",
       "14                             Gaylord Perry (113)  \n",
       "15                               David Wells (113)  \n",
       "16                               Whitey Ford (112)  \n",
       "17                             Dwight Gooden (111)  \n",
       "18                              Josh Beckett (110)  \n",
       "19                             Andy Pettitte (108)  \n",
       "20                                David Cone (106)  \n",
       "21                               John Smoltz (104)  \n",
       "22                                 Vida Blue (103)  \n",
       "23                               Jim Bunning (103)  \n",
       "24                               Phil Niekro (100)  \n",
       "25                           Ferguson Jenkins (99)  \n",
       "26                                 Luis Tiant (98)  \n",
       "27                                Tom Glavine (95)  \n",
       "28                              Johan Santana (94)  \n",
       "29                                 Ron Guidry (93)  \n",
       "..                                             ...  \n",
       "71                           Justin Verlander (57)  \n",
       "72                               Bruce Sutter (56)  \n",
       "73                                  Ted Lilly (55)  \n",
       "74                            Bret Saberhagen (54)  \n",
       "75                             Kevin Millwood (54)  \n",
       "76                                Mike Timlin (54)  \n",
       "77                     John Farrell (pitcher) (53)  \n",
       "78                            Adam Wainwright (53)  \n",
       "79                               Billy Wagner (53)  \n",
       "80                               Warren Spahn (51)  \n",
       "81                          Francisco Liriano (51)  \n",
       "82                       Lee Smith (baseball) (50)  \n",
       "83   Francisco Rodrguez (baseball, born 1982) (50)  \n",
       "84                                 Bob Feller (49)  \n",
       "85                               Keith Foulke (49)  \n",
       "86                              Octavio Dotel (48)  \n",
       "87                     Steve Stone (baseball) (48)  \n",
       "88                              Javier Vzquez (47)  \n",
       "89                                 Brad Penny (47)  \n",
       "90                                   Jim Kaat (47)  \n",
       "91                           Orlando Hernndez (46)  \n",
       "92                             Byung-Hyun Kim (46)  \n",
       "93                             LaTroy Hawkins (46)  \n",
       "94                           Calvin Schiraldi (46)  \n",
       "95                   Andrew Miller (baseball) (46)  \n",
       "96                              Mickey Lolich (45)  \n",
       "97                               Bartolo Coln (45)  \n",
       "98                               Todd Worrell (45)  \n",
       "99                               Brandon Webb (45)  \n",
       "100                              Ken Holtzman (45)  \n",
       "\n",
       "[101 rows x 35 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "outframe.to_csv('outframe.csv', sep='\\t')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}