similar movies and similar actors

In the past I gave some examples of common[movies] and common[actors]. Today, let's try similar[op].
sa: load improved-imdb.sw
-- who has similar movies to Tom Cruise:
sa: table[actor,coeff] select[1,15] 100 self-similar[movies] |actor: Tom Cruise>
+------------------+---------+
| actor            | coeff   |
+------------------+---------+
| Tom Cruise       | 100.000 |
| Nicole Kidman    | 11.940  |
| William Mapother | 8.065   |
| Steven Spielberg | 8.065   |
| Ving Rhames      | 6.579   |
| Brad Pitt        | 6.061   |
| John Travolta    | 5.634   |
| Ron (I) Dean     | 4.839   |
| Dale Dye         | 4.839   |
| Cuba Gooding Jr. | 4.839   |
| Michael G. Kehoe | 4.839   |
| Simon Pegg       | 4.839   |
| Sydney Pollack   | 4.839   |
| Jeremy Renner    | 4.839   |
| George C. Scott  | 4.839   |
+------------------+---------+

-- now dig a little into these results:
-- how many movies has Tom Cruise starred in?
sa: how-many movies |actor: Tom Cruise>
|number: 62>

-- how many movies has Nicole Kidman starred in?
sa: how-many movies |actor: Nicole Kidman>
|number: 67>

-- how many common movies have Tom and Nicole starred in?
sa: how-many common[movies] (|actor: Tom Cruise> + |actor: Nicole Kidman>)
|number: 8>

-- show a table of common movies for Tom Cruise and Nicole Kidman:
sa: table[movies] common[movies] (|actor: Tom Cruise> + |actor: Nicole Kidman>)
+---------------------------------------------------+
| movies                                            |
+---------------------------------------------------+
| August (2008)                                     |
| Boffo! Tinseltown's Bombs and Blockbusters (2006) |
| Days of Thunder (1990)                            |
| Der Geist des Geldes (2007)                       |
| Eyes Wide Shut (1999)                             |
| Far and Away (1992)                               |
| A Life in Pictures (2001)                         |
| The Queen (2006)                                  |
+---------------------------------------------------+

-- now another example:
-- who has similar movies to Matt Damon:
sa: table[actor,coeff] select[1,15] 100 self-similar[movies] |actor: Matt Damon>
+---------------------+---------+
| actor               | coeff   |
+---------------------+---------+
| Matt Damon          | 100.000 |
| Ben Affleck         | 13.333  |
| George Clooney      | 10.667  |
| Casey Affleck       | 9.333   |
| Johnny Cicco        | 9.333   |
| Brad Pitt           | 6.667   |
| Don Cheadle         | 5.333   |
| Eddie Jemison       | 5.333   |
| Jason (I) Lee       | 5.333   |
| Ernest O'Donnell    | 5.333   |
| Carl Reiner         | 5.333   |
| Jerry (I) Weintraub | 5.333   |
| Franka Potente      | 5.333   |
| Julia (I) Roberts   | 5.333   |
| Josh Brolin         | 4.000   |
+---------------------+---------+

-- a table of common movies for Matt Damon and Ben Affleck:
sa: table[movies] common[movies] (|actor: Matt Damon> + |actor: Ben Affleck>)
+---------------------------------------+
| movies                                |
+---------------------------------------+
| Chasing Amy (1997)                    |
| Dogma (1999)                          |
| Field of Dreams (1989)                |
| Glory Daze (1995)                     |
| Good Will Hunting (1997)              |
| Jay and Silent Bob Strike Back (2001) |
| Jersey Girl (2004)                    |
| School Ties (1992)                    |
| The Third Wheel (2002)                |
| Unite for Japan (2011)                |
+---------------------------------------+

-- a table of common movies for Matt Damon and George Clooney:
sa: table[movies] common[movies] (|actor: Matt Damon> + |actor: George Clooney>)
+--------------------------------------------+
| movies                                     |
+--------------------------------------------+
| Confessions of a Dangerous Mind (2002)     |
| George W. Bush Battles Jesus Christ (2008) |
| Ocean's Eleven (2001)                      |
| Ocean's Thirteen (2007)                    |
| Ocean's Twelve (2004)                      |
| Radioman (2012)                            |
| Syriana (2005)                             |
| The Monuments Men (2014)                   |
+--------------------------------------------+

-- who has similar movies to Morgan Freeman:
sa: table[actor,coeff] select[1,15] 100 self-similar[movies] |actor: Morgan (I) Freeman>
+----------------------+---------+
| actor                | coeff   |
+----------------------+---------+
| Morgan (I) Freeman   | 100.000 |
| Clint Eastwood       | 6.542   |
| Aaron Eckhart        | 4.673   |
| Bruce Willis         | 4.673   |
| Ashley Judd          | 4.673   |
| Steve Carell         | 3.738   |
| Kevin Costner        | 3.738   |
| Alfonso Freeman      | 3.738   |
| Gene Hackman         | 3.738   |
| Cillian Murphy       | 3.738   |
| James (III) Rawlings | 3.738   |
| Tim (I) Robbins      | 3.738   |
| Steven Spielberg     | 3.738   |
| Radha Mitchell       | 3.738   |
| Jessica Tandy        | 3.738   |
+----------------------+---------+

-- a table of common movies for Morgan Freeman and Clint Eastwood:
sa: table[movies] common[movies] (|actor: Morgan (I) Freeman> + |actor: Clint Eastwood>)
+---------------------------------------------------+
| movies                                            |
+---------------------------------------------------+
| A Century of Cinema (1994)                        |
| Boffo! Tinseltown's Bombs and Blockbusters (2006) |
| The Story of Richard D. Zanuck (2013)             |
| The Untold Story (2013)                           |
| Million Dollar Baby (2004)                        |
| Tales from the Warner Bros. Lot (2013)            |
| Unforgiven (1992)                                 |
+---------------------------------------------------+

-- which movies have similar actors to Pulp Fiction:
sa: table[movie,coeff] select[1,15] 100 self-similar[actors] |movie: Pulp Fiction (1994)>
+-----------------------------------------+---------+
| movie                                   | coeff   |
+-----------------------------------------+---------+
| Pulp Fiction (1994)                     | 100.000 |
| Reservoir Dogs (1992)                   | 16.981  |
| You're Still Not Fooling Anybody (1997) | 13.208  |
| Jackie Brown (1997)                     | 9.434   |
| Vol. 2 (2004)                           | 7.576   |
| Full Tilt Boogie (1997)                 | 7.547   |
| Somebody to Love (1994)                 | 7.547   |
| From Dusk Till Dawn (1996)              | 7.547   |
| My Best Friend's Birthday (1987)        | 7.547   |
| The Prophecy (1995)                     | 5.660   |
| It's Pat (1994)                         | 5.660   |
| Jumpin' at the Boneyard (1992)          | 5.660   |
| Out of Sight (1998)                     | 5.660   |
| Kiss of Death (1995)                    | 5.660   |
| Inside Hollywood Movies (2013)          | 5.660   |
+-----------------------------------------+---------+

-- a table of common actors for Pulp Fiction and Reservoir Dogs:
sa: table[actor] common[actors] (|movie: Pulp Fiction (1994)> + |movie: Reservoir Dogs (1992)>)
+-------------------+
| actor             |
+-------------------+
| Lawrence Bender   |
| Steve Buscemi     |
| Harvey (I) Keitel |
| Tim (I) Roth      |
| Robert (I) Ruth   |
| Burr Steers       |
| Quentin Tarantino |
| Rich (I) Turner   |
| Linda (I) Kaye    |
+-------------------+

-- which movies have similar actors to Star Trek: The Motion Picture:
-- NB: the extract-value operator is stripping our "Star Trek: " prefix. I don't know how to fix.
sa: table[movie,coeff] select[1,15] 100 self-similar[actors] |movie: Star Trek: The Motion Picture (1979)> 
+---------------------------------+---------+
| movie                           | coeff   |
+---------------------------------+---------+
| The Motion Picture (1979)       | 100.000 |
| The Voyage Home (1986)          | 15.625  |
| The Search for Spock (1984)     | 15.625  |
| The Undiscovered Country (1991) | 15.625  |
| The Final Frontier (1989)       | 10.938  |
| The Wrath of Khan (1982)        | 10.938  |
| Road Trek 2011 (2012)           | 10.938  |
| Star Trek Adventure (1991)      | 10.938  |
| To Be Takei (2014)              | 7.812   |
| Generations (1994)              | 5.797   |
| Trekkies (1997)                 | 5.670   |
| Trek Nation (2010)              | 4.688   |
| The Other Movie (1981)          | 4.688   |
| The Captains (2011)             | 4.688   |
| Backyard Blockbusters (2012)    | 4.545   |
+---------------------------------+---------+

-- a table of common actors for the original series Star Trek movies:
-- NB: we know to select the top 6 movies because of the results in the table just above
sa: table[actor] common[actors] select[1,6] self-similar[actors] |movie: Star Trek: The Motion Picture (1979)>
+-------------------+
| actor             |
+-------------------+
| James Doohan      |
| DeForest Kelley   |
| Walter (I) Koenig |
| Leonard Nimoy     |
| William Shatner   |
| George Takei      |
| Nichelle Nichols  |
+-------------------+
And that's it for this post. I think we are really starting to see some cool results, and starting to show how the Feynman Knowledge Engine works in practice. As usual, heaps more to come!


Home
previous: new function such that
next: how many movies

updated: 19/12/2016
by Garry Morrison
email: garry -at- semantic-db.org