vote_average.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import star_trek_tos_data as TOS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>guest_ids</th>\n",
       "      <th>guest_names</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>original_title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>The Godfather: Part II</th>\n",
       "      <td>2</td>\n",
       "      <td>[8490, 15659]</td>\n",
       "      <td>[John Megna, Marianna Hill]</td>\n",
       "      <td>8.3</td>\n",
       "      <td>3638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Witness for the Prosecution</th>\n",
       "      <td>2</td>\n",
       "      <td>[10925, 2782]</td>\n",
       "      <td>[Torin Thatcher, Ian Wolfe]</td>\n",
       "      <td>8.2</td>\n",
       "      <td>299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>To Kill a Mockingbird</th>\n",
       "      <td>5</td>\n",
       "      <td>[8496, 8490, 6838, 8499, 16055]</td>\n",
       "      <td>[Paul Fix, John Megna, Frank Overton, William ...</td>\n",
       "      <td>8</td>\n",
       "      <td>729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chinatown</th>\n",
       "      <td>2</td>\n",
       "      <td>[12295, 12298]</td>\n",
       "      <td>[Perry Lopez, Roy Jenson]</td>\n",
       "      <td>7.9</td>\n",
       "      <td>1001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Big Heat</th>\n",
       "      <td>3</td>\n",
       "      <td>[83913, 15693, 15942]</td>\n",
       "      <td>[Joseph Mell, John Crawford, Celia Lovsky]</td>\n",
       "      <td>7.9</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Sting</th>\n",
       "      <td>2</td>\n",
       "      <td>[151482, 15988]</td>\n",
       "      <td>[Byron Morrow, Charles Dierkop]</td>\n",
       "      <td>7.9</td>\n",
       "      <td>679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Papillon</th>\n",
       "      <td>3</td>\n",
       "      <td>[14069, 16030, 161405]</td>\n",
       "      <td>[Vic Tayback, William Smithers, Ron Soble]</td>\n",
       "      <td>7.8</td>\n",
       "      <td>483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Annie Hall</th>\n",
       "      <td>2</td>\n",
       "      <td>[1820, 151695]</td>\n",
       "      <td>[Mark Lenard, Johnny Haymer]</td>\n",
       "      <td>7.8</td>\n",
       "      <td>1136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Maltese Falcon</th>\n",
       "      <td>2</td>\n",
       "      <td>[3339, 15978]</td>\n",
       "      <td>[Elisha Cook Jr., Charles Drake]</td>\n",
       "      <td>7.8</td>\n",
       "      <td>470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>North by Northwest</th>\n",
       "      <td>2</td>\n",
       "      <td>[2652, 1947]</td>\n",
       "      <td>[Ken Lynch, Stanley Adams]</td>\n",
       "      <td>7.8</td>\n",
       "      <td>1133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Judgment at Nuremberg</th>\n",
       "      <td>2</td>\n",
       "      <td>[126903, 1214926]</td>\n",
       "      <td>[Joseph Bernard, Rudy Solari]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Manchurian Candidate</th>\n",
       "      <td>3</td>\n",
       "      <td>[14732, 14733, 15972]</td>\n",
       "      <td>[James Gregory, Leslie Parrish, Reggie Nalder]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cool Hand Luke</th>\n",
       "      <td>2</td>\n",
       "      <td>[13869, 13871]</td>\n",
       "      <td>[Morgan Woodward, Lou Antonio]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gone with the Wind</th>\n",
       "      <td>2</td>\n",
       "      <td>[1468833, 1468833]</td>\n",
       "      <td>[Phyllis Douglas, Phyllis Douglas]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>1045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>In the Heat of the Night</th>\n",
       "      <td>2</td>\n",
       "      <td>[168061, 15992]</td>\n",
       "      <td>[Clegg Hoyt, William Schallert]</td>\n",
       "      <td>7.5</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Planet of the Apes</th>\n",
       "      <td>2</td>\n",
       "      <td>[102426, 13259]</td>\n",
       "      <td>[Billy Curtis, James Daly]</td>\n",
       "      <td>7.5</td>\n",
       "      <td>1017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Days of Wine and Roses</th>\n",
       "      <td>2</td>\n",
       "      <td>[2652, 14256]</td>\n",
       "      <td>[Ken Lynch, Dick Crockett]</td>\n",
       "      <td>7.5</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ben-Hur</th>\n",
       "      <td>2</td>\n",
       "      <td>[82510, 16055]</td>\n",
       "      <td>[Michael Dugan, Richard Hale]</td>\n",
       "      <td>7.5</td>\n",
       "      <td>698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>High Plains Drifter</th>\n",
       "      <td>2</td>\n",
       "      <td>[15659, 102426]</td>\n",
       "      <td>[Marianna Hill, Billy Curtis]</td>\n",
       "      <td>7.4</td>\n",
       "      <td>299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Message</th>\n",
       "      <td>2</td>\n",
       "      <td>[1007561, 16074]</td>\n",
       "      <td>[Michael Forest, Michael Ansara]</td>\n",
       "      <td>7.4</td>\n",
       "      <td>84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Butch Cassidy and the Sundance Kid</th>\n",
       "      <td>3</td>\n",
       "      <td>[9600, 15988, 9596]</td>\n",
       "      <td>[Ted Cassidy, Charles Dierkop, Jeff Corey]</td>\n",
       "      <td>7.4</td>\n",
       "      <td>697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Magnificent Seven</th>\n",
       "      <td>2</td>\n",
       "      <td>[13786, 15998]</td>\n",
       "      <td>[Whit Bissell, Joseph Ruskin]</td>\n",
       "      <td>7.4</td>\n",
       "      <td>495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>True Grit</th>\n",
       "      <td>5</td>\n",
       "      <td>[15620, 15655, 5247, 161405, 9596]</td>\n",
       "      <td>[Alfred Ryder, Kim Darby, John Fiedler, Ron So...</td>\n",
       "      <td>7.3</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shane</th>\n",
       "      <td>2</td>\n",
       "      <td>[3339, 15983]</td>\n",
       "      <td>[Elisha Cook Jr., Beverly Washburn]</td>\n",
       "      <td>7.3</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Caine Mutiny</th>\n",
       "      <td>2</td>\n",
       "      <td>[13786, 12298]</td>\n",
       "      <td>[Whit Bissell, Roy Jenson]</td>\n",
       "      <td>7.3</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mister Roberts</th>\n",
       "      <td>2</td>\n",
       "      <td>[12295, 118508]</td>\n",
       "      <td>[Perry Lopez, Tige Andrews]</td>\n",
       "      <td>7.3</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Breezy</th>\n",
       "      <td>2</td>\n",
       "      <td>[122004, 16047]</td>\n",
       "      <td>[Roger C. Carmel, Marj Dusay]</td>\n",
       "      <td>7.3</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Spartacus</th>\n",
       "      <td>6</td>\n",
       "      <td>[14508, 15949, 7074, 12431, 14256, 1214919]</td>\n",
       "      <td>[John Hoyt, Vic Perrin, Peter Brocco, Carey Lo...</td>\n",
       "      <td>7.3</td>\n",
       "      <td>519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Duel</th>\n",
       "      <td>2</td>\n",
       "      <td>[12424, 12431]</td>\n",
       "      <td>[Gene Dynarski, Carey Loftin]</td>\n",
       "      <td>7.3</td>\n",
       "      <td>405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>El Dorado</th>\n",
       "      <td>3</td>\n",
       "      <td>[39770, 8496, 50974]</td>\n",
       "      <td>[Adam Roarke, Paul Fix, John Gabriel]</td>\n",
       "      <td>7.3</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mackenna's Gold</th>\n",
       "      <td>2</td>\n",
       "      <td>[9600, 15973]</td>\n",
       "      <td>[Ted Cassidy, Julie Newmar]</td>\n",
       "      <td>6.4</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Julius Caesar</th>\n",
       "      <td>5</td>\n",
       "      <td>[14508, 4076, 2782, 16055, 16074]</td>\n",
       "      <td>[John Hoyt, Morgan Farley, Ian Wolfe, Richard ...</td>\n",
       "      <td>6.4</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Supervixens</th>\n",
       "      <td>2</td>\n",
       "      <td>[45100, 16119]</td>\n",
       "      <td>[Garth Pillsbury, Charles Napier]</td>\n",
       "      <td>6.4</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>THX 1138</th>\n",
       "      <td>2</td>\n",
       "      <td>[5695, 2782]</td>\n",
       "      <td>[Sid Haig, Ian Wolfe]</td>\n",
       "      <td>6.4</td>\n",
       "      <td>278</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Battlestar Galactica</th>\n",
       "      <td>2</td>\n",
       "      <td>[15765, 106664]</td>\n",
       "      <td>[John Colicos, Geoffrey Binney]</td>\n",
       "      <td>6.4</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Salem's Lot</th>\n",
       "      <td>3</td>\n",
       "      <td>[3339, 15956, 121041]</td>\n",
       "      <td>[Elisha Cook Jr., David Soul, Julie Cobb]</td>\n",
       "      <td>6.3</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Paint Your Wagon</th>\n",
       "      <td>2</td>\n",
       "      <td>[15969, 12298]</td>\n",
       "      <td>[William O'Connell, Roy Jenson]</td>\n",
       "      <td>6.3</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Escape from the Planet of the Apes</th>\n",
       "      <td>3</td>\n",
       "      <td>[1793, 8499, 16089]</td>\n",
       "      <td>[Ricardo Montalban, William Windom, Jason Evers]</td>\n",
       "      <td>6.3</td>\n",
       "      <td>286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Star Trek: The Motion Picture</th>\n",
       "      <td>2</td>\n",
       "      <td>[1759, 1820]</td>\n",
       "      <td>[Grace Lee Whitney, Mark Lenard]</td>\n",
       "      <td>6.2</td>\n",
       "      <td>569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beneath the Planet of the Apes</th>\n",
       "      <td>2</td>\n",
       "      <td>[14732, 9596]</td>\n",
       "      <td>[James Gregory, Jeff Corey]</td>\n",
       "      <td>6.2</td>\n",
       "      <td>394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sands of Iwo Jima</th>\n",
       "      <td>2</td>\n",
       "      <td>[10161, 15781]</td>\n",
       "      <td>[Richard Webb, Hal Baylor]</td>\n",
       "      <td>6.2</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Hindenburg</th>\n",
       "      <td>2</td>\n",
       "      <td>[15719, 16066]</td>\n",
       "      <td>[Charles Macaulay, Rex Holman]</td>\n",
       "      <td>6.2</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>When Worlds Collide</th>\n",
       "      <td>2</td>\n",
       "      <td>[14508, 15772]</td>\n",
       "      <td>[John Hoyt, Richard Derr]</td>\n",
       "      <td>6.2</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Last Tycoon</th>\n",
       "      <td>3</td>\n",
       "      <td>[4076, 118508, 9596]</td>\n",
       "      <td>[Morgan Farley, Tige Andrews, Jeff Corey]</td>\n",
       "      <td>6.2</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Conquest of the Planet of the Apes</th>\n",
       "      <td>2</td>\n",
       "      <td>[153675, 1793]</td>\n",
       "      <td>[Paul Comi, Ricardo Montalban]</td>\n",
       "      <td>6.1</td>\n",
       "      <td>258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Batman</th>\n",
       "      <td>5</td>\n",
       "      <td>[100799, 14256, 1214919, 291, 16108]</td>\n",
       "      <td>[George Sawaya, Dick Crockett, Gil Perkins, Fr...</td>\n",
       "      <td>6.1</td>\n",
       "      <td>229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Haunted World of El Superbeasto</th>\n",
       "      <td>2</td>\n",
       "      <td>[15661, 5695]</td>\n",
       "      <td>[Clint Howard, Sid Haig]</td>\n",
       "      <td>6.1</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tango &amp; Cash</th>\n",
       "      <td>2</td>\n",
       "      <td>[6451, 15661]</td>\n",
       "      <td>[Michael J. Pollard, Clint Howard]</td>\n",
       "      <td>6.1</td>\n",
       "      <td>500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>House of 1000 Corpses</th>\n",
       "      <td>2</td>\n",
       "      <td>[6451, 5695]</td>\n",
       "      <td>[Michael J. Pollard, Sid Haig]</td>\n",
       "      <td>6</td>\n",
       "      <td>334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Halloween</th>\n",
       "      <td>2</td>\n",
       "      <td>[15661, 5695]</td>\n",
       "      <td>[Clint Howard, Sid Haig]</td>\n",
       "      <td>6</td>\n",
       "      <td>549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Night Shift</th>\n",
       "      <td>2</td>\n",
       "      <td>[15661, 15993]</td>\n",
       "      <td>[Clint Howard, Michael Pataki]</td>\n",
       "      <td>6</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ride Lonesome</th>\n",
       "      <td>2</td>\n",
       "      <td>[15644, 12298]</td>\n",
       "      <td>[Karen Steele, Roy Jenson]</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Battle Beyond the Stars</th>\n",
       "      <td>2</td>\n",
       "      <td>[13869, 9596]</td>\n",
       "      <td>[Morgan Woodward, Jeff Corey]</td>\n",
       "      <td>5.9</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Blacula</th>\n",
       "      <td>3</td>\n",
       "      <td>[3339, 15719, 16028]</td>\n",
       "      <td>[Elisha Cook Jr., Charles Macaulay, William Ma...</td>\n",
       "      <td>5.7</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Firefox</th>\n",
       "      <td>2</td>\n",
       "      <td>[1472601, 15772]</td>\n",
       "      <td>[Lev Mailer, Richard Derr]</td>\n",
       "      <td>5.6</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Starsky &amp; Hutch</th>\n",
       "      <td>2</td>\n",
       "      <td>[15956, 9811]</td>\n",
       "      <td>[David Soul, Fred Williamson]</td>\n",
       "      <td>5.6</td>\n",
       "      <td>692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Undefeated</th>\n",
       "      <td>3</td>\n",
       "      <td>[8496, 16071, 16108]</td>\n",
       "      <td>[Paul Fix, Gregg Palmer, Lee Meriwether]</td>\n",
       "      <td>5.6</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Sword and the Sorcerer</th>\n",
       "      <td>3</td>\n",
       "      <td>[15998, 16097, 9596]</td>\n",
       "      <td>[Joseph Ruskin, Jay Robinson, Jeff Corey]</td>\n",
       "      <td>5.5</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Lords of Salem</th>\n",
       "      <td>2</td>\n",
       "      <td>[15661, 5695]</td>\n",
       "      <td>[Clint Howard, Sid Haig]</td>\n",
       "      <td>5.1</td>\n",
       "      <td>267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Star Wars Holiday Special</th>\n",
       "      <td>2</td>\n",
       "      <td>[1472601, 16000]</td>\n",
       "      <td>[Lev Mailer, Mickey Morton]</td>\n",
       "      <td>3.3</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>119 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    count  \\\n",
       "original_title                              \n",
       "The Godfather: Part II                  2   \n",
       "Witness for the Prosecution             2   \n",
       "To Kill a Mockingbird                   5   \n",
       "Chinatown                               2   \n",
       "The Big Heat                            3   \n",
       "The Sting                               2   \n",
       "Papillon                                3   \n",
       "Annie Hall                              2   \n",
       "The Maltese Falcon                      2   \n",
       "North by Northwest                      2   \n",
       "Judgment at Nuremberg                   2   \n",
       "The Manchurian Candidate                3   \n",
       "Cool Hand Luke                          2   \n",
       "Gone with the Wind                      2   \n",
       "In the Heat of the Night                2   \n",
       "Planet of the Apes                      2   \n",
       "Days of Wine and Roses                  2   \n",
       "Ben-Hur                                 2   \n",
       "High Plains Drifter                     2   \n",
       "The Message                             2   \n",
       "Butch Cassidy and the Sundance Kid      3   \n",
       "The Magnificent Seven                   2   \n",
       "True Grit                               5   \n",
       "Shane                                   2   \n",
       "The Caine Mutiny                        2   \n",
       "Mister Roberts                          2   \n",
       "Breezy                                  2   \n",
       "Spartacus                               6   \n",
       "Duel                                    2   \n",
       "El Dorado                               3   \n",
       "...                                   ...   \n",
       "Mackenna's Gold                         2   \n",
       "Julius Caesar                           5   \n",
       "Supervixens                             2   \n",
       "THX 1138                                2   \n",
       "Battlestar Galactica                    2   \n",
       "Salem's Lot                             3   \n",
       "Paint Your Wagon                        2   \n",
       "Escape from the Planet of the Apes      3   \n",
       "Star Trek: The Motion Picture           2   \n",
       "Beneath the Planet of the Apes          2   \n",
       "Sands of Iwo Jima                       2   \n",
       "The Hindenburg                          2   \n",
       "When Worlds Collide                     2   \n",
       "The Last Tycoon                         3   \n",
       "Conquest of the Planet of the Apes      2   \n",
       "Batman                                  5   \n",
       "The Haunted World of El Superbeasto     2   \n",
       "Tango & Cash                            2   \n",
       "House of 1000 Corpses                   2   \n",
       "Halloween                               2   \n",
       "Night Shift                             2   \n",
       "Ride Lonesome                           2   \n",
       "Battle Beyond the Stars                 2   \n",
       "Blacula                                 3   \n",
       "Firefox                                 2   \n",
       "Starsky & Hutch                         2   \n",
       "The Undefeated                          3   \n",
       "The Sword and the Sorcerer              3   \n",
       "The Lords of Salem                      2   \n",
       "The Star Wars Holiday Special           2   \n",
       "\n",
       "                                                                       guest_ids  \\\n",
       "original_title                                                                     \n",
       "The Godfather: Part II                                             [8490, 15659]   \n",
       "Witness for the Prosecution                                        [10925, 2782]   \n",
       "To Kill a Mockingbird                            [8496, 8490, 6838, 8499, 16055]   \n",
       "Chinatown                                                         [12295, 12298]   \n",
       "The Big Heat                                               [83913, 15693, 15942]   \n",
       "The Sting                                                        [151482, 15988]   \n",
       "Papillon                                                  [14069, 16030, 161405]   \n",
       "Annie Hall                                                        [1820, 151695]   \n",
       "The Maltese Falcon                                                 [3339, 15978]   \n",
       "North by Northwest                                                  [2652, 1947]   \n",
       "Judgment at Nuremberg                                          [126903, 1214926]   \n",
       "The Manchurian Candidate                                   [14732, 14733, 15972]   \n",
       "Cool Hand Luke                                                    [13869, 13871]   \n",
       "Gone with the Wind                                            [1468833, 1468833]   \n",
       "In the Heat of the Night                                         [168061, 15992]   \n",
       "Planet of the Apes                                               [102426, 13259]   \n",
       "Days of Wine and Roses                                             [2652, 14256]   \n",
       "Ben-Hur                                                           [82510, 16055]   \n",
       "High Plains Drifter                                              [15659, 102426]   \n",
       "The Message                                                     [1007561, 16074]   \n",
       "Butch Cassidy and the Sundance Kid                           [9600, 15988, 9596]   \n",
       "The Magnificent Seven                                             [13786, 15998]   \n",
       "True Grit                                     [15620, 15655, 5247, 161405, 9596]   \n",
       "Shane                                                              [3339, 15983]   \n",
       "The Caine Mutiny                                                  [13786, 12298]   \n",
       "Mister Roberts                                                   [12295, 118508]   \n",
       "Breezy                                                           [122004, 16047]   \n",
       "Spartacus                            [14508, 15949, 7074, 12431, 14256, 1214919]   \n",
       "Duel                                                              [12424, 12431]   \n",
       "El Dorado                                                   [39770, 8496, 50974]   \n",
       "...                                                                          ...   \n",
       "Mackenna's Gold                                                    [9600, 15973]   \n",
       "Julius Caesar                                  [14508, 4076, 2782, 16055, 16074]   \n",
       "Supervixens                                                       [45100, 16119]   \n",
       "THX 1138                                                            [5695, 2782]   \n",
       "Battlestar Galactica                                             [15765, 106664]   \n",
       "Salem's Lot                                                [3339, 15956, 121041]   \n",
       "Paint Your Wagon                                                  [15969, 12298]   \n",
       "Escape from the Planet of the Apes                           [1793, 8499, 16089]   \n",
       "Star Trek: The Motion Picture                                       [1759, 1820]   \n",
       "Beneath the Planet of the Apes                                     [14732, 9596]   \n",
       "Sands of Iwo Jima                                                 [10161, 15781]   \n",
       "The Hindenburg                                                    [15719, 16066]   \n",
       "When Worlds Collide                                               [14508, 15772]   \n",
       "The Last Tycoon                                             [4076, 118508, 9596]   \n",
       "Conquest of the Planet of the Apes                                [153675, 1793]   \n",
       "Batman                                      [100799, 14256, 1214919, 291, 16108]   \n",
       "The Haunted World of El Superbeasto                                [15661, 5695]   \n",
       "Tango & Cash                                                       [6451, 15661]   \n",
       "House of 1000 Corpses                                               [6451, 5695]   \n",
       "Halloween                                                          [15661, 5695]   \n",
       "Night Shift                                                       [15661, 15993]   \n",
       "Ride Lonesome                                                     [15644, 12298]   \n",
       "Battle Beyond the Stars                                            [13869, 9596]   \n",
       "Blacula                                                     [3339, 15719, 16028]   \n",
       "Firefox                                                         [1472601, 15772]   \n",
       "Starsky & Hutch                                                    [15956, 9811]   \n",
       "The Undefeated                                              [8496, 16071, 16108]   \n",
       "The Sword and the Sorcerer                                  [15998, 16097, 9596]   \n",
       "The Lords of Salem                                                 [15661, 5695]   \n",
       "The Star Wars Holiday Special                                   [1472601, 16000]   \n",
       "\n",
       "                                                                           guest_names  \\\n",
       "original_title                                                                           \n",
       "The Godfather: Part II                                     [John Megna, Marianna Hill]   \n",
       "Witness for the Prosecution                                [Torin Thatcher, Ian Wolfe]   \n",
       "To Kill a Mockingbird                [Paul Fix, John Megna, Frank Overton, William ...   \n",
       "Chinatown                                                    [Perry Lopez, Roy Jenson]   \n",
       "The Big Heat                                [Joseph Mell, John Crawford, Celia Lovsky]   \n",
       "The Sting                                              [Byron Morrow, Charles Dierkop]   \n",
       "Papillon                                    [Vic Tayback, William Smithers, Ron Soble]   \n",
       "Annie Hall                                                [Mark Lenard, Johnny Haymer]   \n",
       "The Maltese Falcon                                    [Elisha Cook Jr., Charles Drake]   \n",
       "North by Northwest                                          [Ken Lynch, Stanley Adams]   \n",
       "Judgment at Nuremberg                                    [Joseph Bernard, Rudy Solari]   \n",
       "The Manchurian Candidate                [James Gregory, Leslie Parrish, Reggie Nalder]   \n",
       "Cool Hand Luke                                          [Morgan Woodward, Lou Antonio]   \n",
       "Gone with the Wind                                  [Phyllis Douglas, Phyllis Douglas]   \n",
       "In the Heat of the Night                               [Clegg Hoyt, William Schallert]   \n",
       "Planet of the Apes                                          [Billy Curtis, James Daly]   \n",
       "Days of Wine and Roses                                      [Ken Lynch, Dick Crockett]   \n",
       "Ben-Hur                                                  [Michael Dugan, Richard Hale]   \n",
       "High Plains Drifter                                      [Marianna Hill, Billy Curtis]   \n",
       "The Message                                           [Michael Forest, Michael Ansara]   \n",
       "Butch Cassidy and the Sundance Kid          [Ted Cassidy, Charles Dierkop, Jeff Corey]   \n",
       "The Magnificent Seven                                    [Whit Bissell, Joseph Ruskin]   \n",
       "True Grit                            [Alfred Ryder, Kim Darby, John Fiedler, Ron So...   \n",
       "Shane                                              [Elisha Cook Jr., Beverly Washburn]   \n",
       "The Caine Mutiny                                            [Whit Bissell, Roy Jenson]   \n",
       "Mister Roberts                                             [Perry Lopez, Tige Andrews]   \n",
       "Breezy                                                   [Roger C. Carmel, Marj Dusay]   \n",
       "Spartacus                            [John Hoyt, Vic Perrin, Peter Brocco, Carey Lo...   \n",
       "Duel                                                     [Gene Dynarski, Carey Loftin]   \n",
       "El Dorado                                        [Adam Roarke, Paul Fix, John Gabriel]   \n",
       "...                                                                                ...   \n",
       "Mackenna's Gold                                            [Ted Cassidy, Julie Newmar]   \n",
       "Julius Caesar                        [John Hoyt, Morgan Farley, Ian Wolfe, Richard ...   \n",
       "Supervixens                                          [Garth Pillsbury, Charles Napier]   \n",
       "THX 1138                                                         [Sid Haig, Ian Wolfe]   \n",
       "Battlestar Galactica                                   [John Colicos, Geoffrey Binney]   \n",
       "Salem's Lot                                  [Elisha Cook Jr., David Soul, Julie Cobb]   \n",
       "Paint Your Wagon                                       [William O'Connell, Roy Jenson]   \n",
       "Escape from the Planet of the Apes    [Ricardo Montalban, William Windom, Jason Evers]   \n",
       "Star Trek: The Motion Picture                         [Grace Lee Whitney, Mark Lenard]   \n",
       "Beneath the Planet of the Apes                             [James Gregory, Jeff Corey]   \n",
       "Sands of Iwo Jima                                           [Richard Webb, Hal Baylor]   \n",
       "The Hindenburg                                          [Charles Macaulay, Rex Holman]   \n",
       "When Worlds Collide                                          [John Hoyt, Richard Derr]   \n",
       "The Last Tycoon                              [Morgan Farley, Tige Andrews, Jeff Corey]   \n",
       "Conquest of the Planet of the Apes                      [Paul Comi, Ricardo Montalban]   \n",
       "Batman                               [George Sawaya, Dick Crockett, Gil Perkins, Fr...   \n",
       "The Haunted World of El Superbeasto                           [Clint Howard, Sid Haig]   \n",
       "Tango & Cash                                        [Michael J. Pollard, Clint Howard]   \n",
       "House of 1000 Corpses                                   [Michael J. Pollard, Sid Haig]   \n",
       "Halloween                                                     [Clint Howard, Sid Haig]   \n",
       "Night Shift                                             [Clint Howard, Michael Pataki]   \n",
       "Ride Lonesome                                               [Karen Steele, Roy Jenson]   \n",
       "Battle Beyond the Stars                                  [Morgan Woodward, Jeff Corey]   \n",
       "Blacula                              [Elisha Cook Jr., Charles Macaulay, William Ma...   \n",
       "Firefox                                                     [Lev Mailer, Richard Derr]   \n",
       "Starsky & Hutch                                          [David Soul, Fred Williamson]   \n",
       "The Undefeated                                [Paul Fix, Gregg Palmer, Lee Meriwether]   \n",
       "The Sword and the Sorcerer                   [Joseph Ruskin, Jay Robinson, Jeff Corey]   \n",
       "The Lords of Salem                                            [Clint Howard, Sid Haig]   \n",
       "The Star Wars Holiday Special                              [Lev Mailer, Mickey Morton]   \n",
       "\n",
       "                                    vote_average vote_count  \n",
       "original_title                                               \n",
       "The Godfather: Part II                       8.3       3638  \n",
       "Witness for the Prosecution                  8.2        299  \n",
       "To Kill a Mockingbird                          8        729  \n",
       "Chinatown                                    7.9       1001  \n",
       "The Big Heat                                 7.9        119  \n",
       "The Sting                                    7.9        679  \n",
       "Papillon                                     7.8        483  \n",
       "Annie Hall                                   7.8       1136  \n",
       "The Maltese Falcon                           7.8        470  \n",
       "North by Northwest                           7.8       1133  \n",
       "Judgment at Nuremberg                        7.7        174  \n",
       "The Manchurian Candidate                     7.7        199  \n",
       "Cool Hand Luke                               7.7        410  \n",
       "Gone with the Wind                           7.7       1045  \n",
       "In the Heat of the Night                     7.5        226  \n",
       "Planet of the Apes                           7.5       1017  \n",
       "Days of Wine and Roses                       7.5         41  \n",
       "Ben-Hur                                      7.5        698  \n",
       "High Plains Drifter                          7.4        299  \n",
       "The Message                                  7.4         84  \n",
       "Butch Cassidy and the Sundance Kid           7.4        697  \n",
       "The Magnificent Seven                        7.4        495  \n",
       "True Grit                                    7.3        215  \n",
       "Shane                                        7.3        155  \n",
       "The Caine Mutiny                             7.3         82  \n",
       "Mister Roberts                               7.3         46  \n",
       "Breezy                                       7.3         35  \n",
       "Spartacus                                    7.3        519  \n",
       "Duel                                         7.3        405  \n",
       "El Dorado                                    7.3        104  \n",
       "...                                          ...        ...  \n",
       "Mackenna's Gold                              6.4         46  \n",
       "Julius Caesar                                6.4         40  \n",
       "Supervixens                                  6.4         38  \n",
       "THX 1138                                     6.4        278  \n",
       "Battlestar Galactica                         6.4         43  \n",
       "Salem's Lot                                  6.3        130  \n",
       "Paint Your Wagon                             6.3         71  \n",
       "Escape from the Planet of the Apes           6.3        286  \n",
       "Star Trek: The Motion Picture                6.2        569  \n",
       "Beneath the Planet of the Apes               6.2        394  \n",
       "Sands of Iwo Jima                            6.2         34  \n",
       "The Hindenburg                               6.2         31  \n",
       "When Worlds Collide                          6.2         37  \n",
       "The Last Tycoon                              6.2         27  \n",
       "Conquest of the Planet of the Apes           6.1        258  \n",
       "Batman                                       6.1        229  \n",
       "The Haunted World of El Superbeasto          6.1         45  \n",
       "Tango & Cash                                 6.1        500  \n",
       "House of 1000 Corpses                          6        334  \n",
       "Halloween                                      6        549  \n",
       "Night Shift                                    6         49  \n",
       "Ride Lonesome                                  6         30  \n",
       "Battle Beyond the Stars                      5.9         43  \n",
       "Blacula                                      5.7         43  \n",
       "Firefox                                      5.6        153  \n",
       "Starsky & Hutch                              5.6        692  \n",
       "The Undefeated                               5.6         30  \n",
       "The Sword and the Sorcerer                   5.5         32  \n",
       "The Lords of Salem                           5.1        267  \n",
       "The Star Wars Holiday Special                3.3         89  \n",
       "\n",
       "[119 rows x 5 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(TOS.guest_movies).T.set_index('original_title')[['count', 'guest_ids', 'guest_names', 'vote_average', 'vote_count']]\n",
    "df = df[df['vote_count']>25]\n",
    "df = df[df['count']>1]\n",
    "df.sort_values('vote_average', ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW4AAAEGCAYAAABFBX+4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAE3tJREFUeJzt3Xl0lfWdx/HPB4gCyqKYEYYIwS5U\nkbUBj6VHBRdAe7AqjuCUcWlhzlErtB0KtsfWtoPjVKyttDpEh1atWBXHpYx1GXcrVYPiVqoWGzEi\nEsCFpSLgd/7IZTUhD3Bvbn7h/TqHw12e+9wvj/D2yZPnyXVECACQjlbFHgAAsGsINwAkhnADQGII\nNwAkhnADQGIINwAkhnADQGIINwAkhnADQGLaFGKlBx10UJSXlxdi1QDQIi1YsGBFRJRmWbYg4S4v\nL1dVVVUhVg0ALZLtN7Muy6ESAEgM4QaAxBBuAEhMQY5xAyi+DRs2qKamRh999FGxR8E22rZtq7Ky\nMpWUlOz2OhoNt+3ekm7d5qFDJf0gIn6+2+8KoOBqamrUoUMHlZeXy3axx4GkiNDKlStVU1OjXr16\n7fZ6Gg13RLwqaYAk2W4t6W1Jd+72OwJoEh999BHRbmZsq0uXLqqtrd2j9ezqMe7jJC2OiMynrQAo\nHqLd/OTjv8muhnuspFsaGGai7SrbVXv6fxMAQMMyf3PS9j6SRku6uL7nI6JSUqUkVVRU8EGWQDNT\nPu1/87q+6stPzt+6qqv11FNP6ayzztrl175Y837e5tgT/co6N9l77cpZJaMkPRcR7xZqGADZZInw\ndaO7aUMBo/Zizft5i1V1dbXmzJmzW+EuhIhQRKhVq+Z5xvSuTDVODRwmAYAdTZ06Vddcc82W+5de\neqmuvPJKTZkyRUcccYT69u2rW2+tO2Ft2rRpeuKJJzRgwABdddVV2rRpk6ZMmaLBgwerX79+mjVr\nVoPvs27tGk0Ye4rOHHWMTj/+S3rk/nslSVdd9kPdesP1W5a79meX64ZZv5Qk/ea/rtZZJw/XmBOG\n6por/0OS9PZbS/TVYUdq+ve+ozNHHaNlS2v07xd/W+NOGqZTjztqy3KS9MTDD+iUY4fo7NNG6vIf\nTNWF55wpSVq7dq3OO+88DR48WAMHDtTdd9+dp625vUx73LbbSzpB0r8WZIod5PtLut2Vzy8Fgb3N\n2LFjNXnyZJ1//vmSpNtuu01Tp07VfffdpxdeeEErVqzQ4MGDdfTRR+vyyy/XjBkzNG/ePElSZWWl\nOnXqpGeffVbr16/X0KFDdeKJJ9Z7Ct0++7bVVdfdpP07dNR7q1Zq/OgTdOyJozRy9Om64tKLdebZ\n35AkPTDvLl1z0+166rGHteRvb+jmeQ8pInTReeO04E9/VNfuh6h68ev68ZW/1Pcvu1KS9M3vXqJO\nBxygTZs2aeLYU/TaopfVs9dn9ZNp39LsufeqrEdPTb3g61tmmT59uoYPH67Zs2fr/fff15AhQ3T8\n8cdrv/32y+u2zRTuiFgnqUte3xlAizZw4EAtX75cS5cuVW1trQ444AAtXLhQ48aNU+vWrXXwwQfr\nmGOO0bPPPquOHTtu99oHHnhAL774oubOnStJ+uCDD/T666/XG+6I0NX/+RM99/RTatWqlZYve0cr\na5frsCP6adXKFVq+7B29t2qFOnbqpG7dD9Gc2ZWa//jDOnPk0ZKkdWvX6s3qN9S1+yHqVnaI+g0a\nvGXd98+7U3fMuUGbNm7UiuXvavFrr+qTT0JlPcpV1qOnJGnUKadr7pwbtsx9zz33aMaMGZLqTslc\nsmSJDjvssLxuW66cRDL4Siw9Y8aM0dy5c7Vs2TKNHTtWixcvzvS6iNDMmTM1YsSIRpe9987b9d7K\nlbrl3kdVUlKiUUf10/r16yVJx580Wg/ee49WLn9XI0afvmXd513wLZ3xtXO3W8/bby1Ru3btt9yv\nWfKmbpz1S82Z97A6du6sS751vj5ev14RDZ97ERG644471Lt370x/zt1FuJs5YoWUjR07VhMmTNCK\nFSv02GOPaf78+Zo1a5bOPvtsrVq1So8//riuuOIKvf3221q9evWW140YMULXXnuthg8frpKSEr32\n2mvq3r17vYcc1qz+UAcedJBKSkr0zFNPaGnNW1ueGzn6NP146iS9t2qVZt9edxjmS8cM169mXKaT\nTz1D7ffbX+++s1Rt6rn8fO2aD9WufXvt37GjVtYu15OP/p8qjvqyen3mc6pZUq2331qi7of00P2/\n33o94ogRIzRz5kzNnDlTtvX8889r4MCB+dykkgg3sNe458KhTf6effr00erVq9W9e3d169ZNp556\nqubPn6/+/fvLtn7605+qa9eu6tKli9q0aaP+/fvrnHPO0aRJk1RdXa1BgwYpIlRaWqq77rqr3vc4\n6dQzdNG54zTupGHq3aeven3281ue+2zvw7R2zRr9Q9duKj24q6S6cP/tr69p/CknSpLa77e/LvvF\nLLVq3Xq79fY+vK++0KefTjvuKJX16KkBFUdKktq2a6fvTZ+h88ePUecDD9QR/b+45TWXXHKJJk+e\nrH79+ikiVF5evuW4fT55Z7v9u6uioiL25IMU2Mvcim2xFdtiq6ynAx7c49CCztGU5y43pBjnca9b\nu0bt99tfEaHLvv9v6tHrM7riR9/L/PpFixZ96ri37QURUZHl9exxA8AuumPOjfr93Fu0YcMGfaFP\nX4352jlN+v6EG0ASXnrpJY0fP367x/bdd19dd8f9TT7L+Anna/yE85v8fTcj3ACS0LdvXy1cuPBT\njzeXS96bUvO8nhPAHgvFTk9dQ3Hk478J4QZaqDff36CN6z4k3s3I5g9SaNu27R6th0MlQAs18+n3\n9E1JPTuvkFWYn8u9aHW7gqx3V7z73t+LPYKk7Nti80eX7QnCDbRQH67/RNMfX1nQ92gOp0aO2gtP\nE+VQCQAkhnADQGIINwAkhnADQGIINwAkhnADQGIINwAkhnADQGIINwAkJlO4bXe2Pdf2X2wvsn1U\noQcDANQv6yXvv5B0X0SMsb2PpPaNvQAAUBiNhtt2R0lHSzpHkiLiY0kfF3YsAEBDshwqOVRSraRf\n237e9vW2P/1RywCAJpEl3G0kDZJ0bUQMlLRW0rQdF7I90XaV7ara2to8jwkA2CxLuGsk1UTE07n7\nc1UX8u1ERGVEVERERWlpaT5nBABso9FwR8QySW/Z7p176DhJfy7oVACABmU9q+Sbkm7OnVHyhqRz\nCzcSAGBnMoU7IhZKqijwLACADLhyEgASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGE\nGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwAS\nk+lT3m1XS1otaZOkjRHBJ74DQJFkCnfOsIhYUbBJAACZcKgEABKTNdwh6QHbC2xPrG8B2xNtV9mu\nqq2tzd+EAIDtZA330IgYJGmUpAtsH73jAhFRGREVEVFRWlqa1yEBAFtlCndELM39vlzSnZKGFHIo\nAEDDGg237f1sd9h8W9KJkl4u9GAAgPplOavkYEl32t68/JyIuK+gUwEAGtRouCPiDUn9m2AWAEAG\nnA4IAIkh3ACQGMINAIkh3ACQGMINAIkh3ACQGMINAIkh3ACQGMINAIkh3ACQGMINAIkh3ACQGMIN\nAIkh3ACQGMINAIkh3ACQGMINAIkh3ACQGMINAIkh3ACQGMINAInJHG7brW0/b3teIQcCAOzcruxx\nT5K0qFCDAACyyRRu22WSTpZ0fWHHAQA0Juse988lfVfSJw0tYHui7SrbVbW1tXkZDgDwaY2G2/ZX\nJC2PiAU7Wy4iKiOiIiIqSktL8zYgAGB7Wfa4h0oabbta0u8kDbf924JOBQBoUKPhjoiLI6IsIsol\njZX0cER8reCTAQDqxXncAJCYNruycEQ8KunRgkwCAMiEPW4ASAzhBoDEEG4ASAzhBoDEEG4ASAzh\nBoDEEG4ASAzhBoDEEG4ASAzhBoDEEG4ASAzhBoDEEG4ASAzhBoDEEG4ASAzhBoDEEG4ASAzhBoDE\nEG4ASAzhBoDEEG4ASEyj4bbd1vYztl+w/YrtHzXFYACA+rXJsMx6ScMjYo3tEklP2v5DRPypwLMB\nAOrRaLgjIiStyd0tyf2KQg4FAGhYpmPctlvbXihpuaQHI+LpepaZaLvKdlVtbW2+5wQA5GQKd0Rs\niogBksokDbF9RD3LVEZERURUlJaW5ntOAEDOLp1VEhHvS3pU0siCTAMAaFSWs0pKbXfO3W4n6XhJ\nfyn0YACA+mU5q6SbpBtst1Zd6G+LiHmFHQsA0JAsZ5W8KGlgE8wCAMiAKycBIDGEGwASQ7gBIDGE\nGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGEGwAS\nQ7gBIDGEGwASQ7gBIDGEGwASQ7gBIDGNhtv2IbYfsb3I9iu2JzXFYACA+rXJsMxGSd+JiOdsd5C0\nwPaDEfHnAs8GAKhHo3vcEfFORDyXu71a0iJJ3Qs9GACgfrt0jNt2uaSBkp6u57mJtqtsV9XW1uZn\nOgDAp2QOt+39Jd0haXJEfLjj8xFRGREVEVFRWlqazxkBANvIFG7bJaqL9s0R8T+FHQkAsDNZziqx\npP+WtCgiflb4kQAAO5Nlj3uopPGShttemPt1UoHnAgA0oNHTASPiSUluglkAABlw5SQAJIZwA0Bi\nCDcAJIZwA0BiCDcAJIZwA0BiCDcAJIZwA0BiCDcAJIZwA0BiCDcAJIZwA0BiCDcAJIZwA0BiCDcA\nJIZwA0BiCDcAJIZwA0BiCDcAJIZwA0BiGg237dm2l9t+uSkGAgDsXJY97t9IGlngOQAAGTUa7oh4\nXNKqJpgFAJABx7gBIDF5C7ftibarbFfV1tbma7UAgB3kLdwRURkRFRFRUVpamq/VAgB2wKESAEhM\nltMBb5E0X1Jv2zW2v174sQAADWnT2AIRMa4pBgEAZMOhEgBIDOEGgMQQbgBIDOEGgMQQbgBIDOEG\ngMQQbgBIDOEGgMQQbgBIDOEGgMQQbgBIDOEGgMQQbgBIDOEGgMQQbgBIDOEGgMQQbgBIDOEGgMQQ\nbgBIDOEGgMQQbgBITKZw2x5p+1Xbf7U9rdBDAQAa1mi4bbeW9CtJoyQdLmmc7cMLPRgAoH5Z9riH\nSPprRLwRER9L+p2kUwo7FgCgIY6InS9gj5E0MiK+kbs/XtKREXHhDstNlDQxd7e3pFfzP+4uOUjS\niiLP0FywLbZiW2zFttiqOWyLnhFRmmXBNhmWcT2Pfar2EVEpqTLLmzYF21URUVHsOZoDtsVWbIut\n2BZbpbYtshwqqZF0yDb3yyQtLcw4AIDGZAn3s5I+Z7uX7X0kjZV0T2HHAgA0pNFDJRGx0faFku6X\n1FrS7Ih4peCT7blmc9imGWBbbMW22IptsVVS26LRb04CAJoXrpwEgMQQbgBIDOEGgMQQ7hbI9hDb\ng3O3D7f9bdsnFXuuYrN9Y7FnAPIhywU4SbD9BUndJT0dEWu2eXxkRNxXvMmalu0fqu7nyrSx/aCk\nIyU9Kmma7YERMb2Y8zUV2zuesmpJw2x3lqSIGN30UzUftr+suh9n8XJEPFDseZqS7SMlLYqID223\nkzRN0iBJf5Z0WUR8UNQBM2gRZ5XYvkjSBZIWSRogaVJE3J177rmIGFTM+ZqS7ZdUtw32lbRMUtk2\nf0Gfjoh+RR2widh+TnX/EK9X3ZW+lnSL6q5DUEQ8Vrzpmp7tZyJiSO72BNX9e7lT0omSfh8Rlxdz\nvqZk+xVJ/XOnOldKWidprqTjco+fVtQBM2gpe9wTJH0xItbYLpc013Z5RPxC9V+y35JtjIhNktbZ\nXhwRH0pSRPzd9idFnq0pVUiaJOn7kqZExELbf9/bgr2Nkm1uT5R0QkTU2p4h6U+S9ppwS2oVERtz\ntyu22bF70vbCYg21K1pKuFtvPjwSEdW2j1VdvHtq7wv3x7bbR8Q6SV/c/KDtTpL2mnBHxCeSrrJ9\ne+73d9Vy/r7vjla2D1Dd97UcEbWSFBFrbW/c+UtbnJdtnxsRv5b0gu2KiKiy/XlJG4o9XBYt5ZuT\ny2wP2HwnF/GvqO4nfvUt2lTFcXQu2pvjtVmJpLOLM1LxRERNRJwh6Q+SflvseYqok6QFkqokHWi7\nqyTZ3l97387NNyQdY3ux6j5jYL7tNyRdl3uu2Wspx7jLVHeIYFk9zw2NiD8WYSyg2bPdXtLBEfG3\nYs/S1Gx3kHSo6r4Sq4mId4s8UmYtItwAsDdpKYdKAGCvQbgBIDGEG6iH7cm5479As8MxbqAetqtV\nd45vsT+HEPgU9riRLNv/YvtF2y/Yvsl2T9sP5R57yHaP3HK/yX3o9ebXrcn9fqztR23Ptf0X2ze7\nzkWS/lHSI7YfKc6fDmjY3nxBAhJmu4/qroocGhErbB8o6QZJN0bEDbbPk3S1pK82sqqBkvqo7nNU\n/5hb39W2vy1pGHvcaI7Y40aqhkuauzmsEbFK0lGS5uSev0nSlzOs55ncRTqfSFooqbwAswJ5RbiR\nKqvuh0ftzObnNyr3d922Je2zzTLrt7m9SXwVigQQbqTqIUn/ZLuLJOUOlTyl3E//k/TPkp7M3a7W\n1p/bcoq2/4FLDVktqUO+hgXyib0LJCkiXrE9XdJjtjdJel7SRZJm254iqVbSubnFr5N0t+1nVBf8\ntRneolLSH2y/ExHD8v8nAHYfpwMCQGI4VAIAiSHcAJAYwg0AiSHcAJAYwg0AiSHcAJAYwg0Aifl/\n3Blr4gDqSywAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1123831d0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df['vote_average'] = df['vote_average'].astype(float)\n",
    "df.groupby('count').mean().plot( kind = 'bar')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}