{ "cells": [ { "cell_type": "code", "execution_count": 28, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [], "source": [ "import magellan as mg\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 29, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "WARNING:magellan.utils.helperfunctions:JVM is already running\n" ] }, { "data": { "text/plain": [ "True" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "mg.init_jvm()" ] }, { "cell_type": "code", "execution_count": 55, "metadata": { "collapsed": false }, "outputs": [], "source": [ "path_A = '/Users/guangshanchen/Documents/CS784/Project/imdbClean.csv'\n", "path_B = '/Users/guangshanchen/Documents/CS784/Project/tmdClean.csv'" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 56, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# read table A; table A has 'ID as the key attribute\n", "A = mg.read_csv(path_A, key='ID')\n", "B = mg.read_csv(path_B, key='ID')" ] }, { "cell_type": "code", "execution_count": 57, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | ID | \n", "name | \n", "year | \n", "director | \n", "writers | \n", "actors | \n", "
---|---|---|---|---|---|---|
0 | \n", "1 | \n", "The Martian | \n", "2015 | \n", "Ridley Scott | \n", "Drew Goddard; Andy Weir | \n", "Matt Damon; Jessica Chastain; Kristen Wiig | \n", "
1 | \n", "2 | \n", "The Green Inferno | \n", "2013 | \n", "Eli Roth | \n", "Guillermo Amoedo; Eli Roth | \n", "Lorenza Izzo; Ariel Levy; Aaron Burns | \n", "
2 | \n", "3 | \n", "Everest | \n", "2015 | \n", "Baltasar Kormákur | \n", "William Nicholson; Simon Beaufoy | \n", "Jason Clarke; Ang Phula Sherpa; Thomas M. Wright | \n", "
3 | \n", "4 | \n", "Sicario | \n", "2015 | \n", "Denis Villeneuve | \n", "Taylor Sheridan | \n", "Emily Blunt; Josh Brolin; Benicio Del Toro | \n", "
4 | \n", "5 | \n", "The Intern(I) | \n", "2015 | \n", "Nancy Meyers | \n", "Nancy Meyers | \n", "Robert De Niro; Anne Hathaway; Rene Russo | \n", "
5 | \n", "6 | \n", "Black Mass(I) | \n", "2015 | \n", "Scott Cooper | \n", "Mark Mallouk; Jez Butterworth | \n", "Johnny Depp; Benedict Cumberbatch; Dakota Joh... | \n", "
6 | \n", "7 | \n", "Hotel Transylvania 2 | \n", "2015 | \n", "Genndy Tartakovsky | \n", "Robert Smigel; Adam Sandler | \n", "Adam Sandler; Andy Samberg; Selena Gomez | \n", "
7 | \n", "8 | \n", "Maze Runner: The Scorch Trials | \n", "2015 | \n", "Wes Ball | \n", "T.S. Nowlin; James Dashner | \n", "Dylan O'Brien; Kaya Scodelario; Thomas Brodie... | \n", "
8 | \n", "9 | \n", "The Visit(I) | \n", "2015 | \n", "M. Night Shyamalan | \n", "M. Night Shyamalan | \n", "Olivia DeJonge; Ed Oxenbould; Deanna Dunagan | \n", "
9 | \n", "10 | \n", "Spectre | \n", "2015 | \n", "Sam Mendes | \n", "John Logan; Neal Purvis | \n", "Daniel Craig; Christoph Waltz; Ralph Fiennes | \n", "
10 | \n", "11 | \n", "Mad Max: Fury Road | \n", "2015 | \n", "George Miller | \n", "George Miller; Brendan McCarthy | \n", "Tom Hardy; Charlize Theron; Nicholas Hoult | \n", "
11 | \n", "12 | \n", "The Walk(II) | \n", "2015 | \n", "Robert Zemeckis | \n", "Robert Zemeckis; Christopher Browne | \n", "Joseph Gordon-Levitt; Charlotte Le Bon; Guill... | \n", "
12 | \n", "13 | \n", "The Revenant | \n", "2015 | \n", "Alejandro González Iñárritu | \n", "Alejandro González Iñárritu; Michael Punke | \n", "Tom Hardy; Leonardo DiCaprio; Will Poulter | \n", "
13 | \n", "14 | \n", "Tomorrowland | \n", "2015 | \n", "Brad Bird | \n", "Damon Lindelof; Brad Bird | \n", "George Clooney; Britt Robertson; Hugh Laurie | \n", "
14 | \n", "15 | \n", "Star Wars: Episode VII - The Force Awakens | \n", "2015 | \n", "J.J. Abrams | \n", "J.J. Abrams; Lawrence Kasdan | \n", "Harrison Ford; Mark Hamill; Carrie Fisher | \n", "
15 | \n", "16 | \n", "Terminator Genisys | \n", "2015 | \n", "Alan Taylor | \n", "Laeta Kalogridis; Patrick Lussier | \n", "Arnold Schwarzenegger; Jason Clarke; Emilia C... | \n", "
16 | \n", "17 | \n", "Avengers: Age of Ultron | \n", "2015 | \n", "Joss Whedon | \n", "Joss Whedon; Stan Lee | \n", "Robert Downey Jr.; Chris Evans; Mark Ruffalo | \n", "
17 | \n", "18 | \n", "San Andreas | \n", "2015 | \n", "Brad Peyton | \n", "Carlton Cuse; Andre Fabrizio | \n", "Dwayne Johnson; Carla Gugino; Alexandra Daddario | \n", "
18 | \n", "19 | \n", "Pan | \n", "2015 | \n", "Joe Wright | \n", "Jason Fuchs; J.M. Barrie | \n", "Levi Miller; Hugh Jackman; Garrett Hedlund | \n", "
19 | \n", "20 | \n", "Jurassic World | \n", "2015 | \n", "Colin Trevorrow | \n", "Rick Jaffa; Amanda Silver | \n", "Chris Pratt; Bryce Dallas Howard; Ty Simpkins | \n", "
20 | \n", "21 | \n", "Crimson Peak | \n", "2015 | \n", "Guillermo del Toro | \n", "Guillermo del Toro; Matthew Robbins | \n", "Mia Wasikowska; Jessica Chastain; Tom Hiddleston | \n", "
21 | \n", "22 | \n", "The Big Short | \n", "2015 | \n", "Adam McKay | \n", "Michael Lewis; Adam McKay | \n", "Brad Pitt; Christian Bale; Karen Gillan | \n", "
22 | \n", "23 | \n", "Mission: Impossible - Rogue Nation | \n", "2015 | \n", "Christopher McQuarrie | \n", "Christopher McQuarrie; Christopher McQuarrie | \n", "Tom Cruise; Rebecca Ferguson; Jeremy Renner | \n", "
23 | \n", "24 | \n", "Inside Out(I) | \n", "2015 | \n", "Pete Docter; Ronnie Del Carmen | \n", "Pete Docter; Ronnie Del Carmen | \n", "Amy Poehler; Bill Hader; Lewis Black | \n", "
24 | \n", "25 | \n", "Shingeki no kyojin | \n", "2015 | \n", "Shinji Higuchi | \n", "Hajime Isayama; Yûsuke Watanabe | \n", "Haruma Miura; Kiko Mizuhara; Kanata Hongô | \n", "
25 | \n", "26 | \n", "Pitch Perfect 2 | \n", "2015 | \n", "Elizabeth Banks | \n", "Kay Cannon; Mickey Rapkin | \n", "Anna Kendrick; Rebel Wilson; Hailee Steinfeld | \n", "
26 | \n", "27 | \n", "Macbeth(I) | \n", "2015 | \n", "Justin Kurzel | \n", "Jacob Koskoff; Michael Lesslie | \n", "Marion Cotillard; Michael Fassbender; Elizabe... | \n", "
27 | \n", "28 | \n", "Batman v Superman: Dawn of Justice | \n", "2016 | \n", "Zack Snyder | \n", "Chris Terrio; David S. Goyer | \n", "Ben Affleck; Henry Cavill; Amy Adams | \n", "
28 | \n", "29 | \n", "Interstellar | \n", "2014 | \n", "Christopher Nolan | \n", "Jonathan Nolan; Christopher Nolan | \n", "Matthew McConaughey; Anne Hathaway; Jessica C... | \n", "
29 | \n", "30 | \n", "Spy | \n", "2015 | \n", "Paul Feig | \n", "Paul Feig | \n", "Melissa McCarthy; Rose Byrne; Jude Law | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2970 | \n", "3003 | \n", "The Holy Mountain | \n", "1973 | \n", "Alejandro Jodorowsky | \n", "Alejandro Jodorowsky | \n", "Alejandro Jodorowsky; Horacio Salinas; Zamira... | \n", "
2971 | \n", "3004 | \n", "The Fisher King | \n", "1991 | \n", "Terry Gilliam | \n", "Richard LaGravenese | \n", "Jeff Bridges; Robin Williams; Adam Bryant | \n", "
2972 | \n", "3005 | \n", "The Diary of Anne Frank | \n", "1959 | \n", "George Stevens | \n", "Frances Goodrich; Albert Hackett | \n", "Millie Perkins; Shelley Winters; Joseph Schil... | \n", "
2973 | \n", "3006 | \n", "The Witches | \n", "1990 | \n", "Nicolas Roeg | \n", "Roald Dahl; Allan Scott | \n", "Anjelica Huston; Mai Zetterling; Jasen Fisher | \n", "
2974 | \n", "3007 | \n", "The Taking of Pelham 1 2 3 | \n", "2009 | \n", "Tony Scott | \n", "Brian Helgeland; John Godey | \n", "Denzel Washington; John Travolta; Luis Guzmán | \n", "
2975 | \n", "3008 | \n", "Mechanic: Resurrection | \n", "2016 | \n", "Dennis Gansel | \n", "Philip Shelby; Tony Mosher | \n", "Jason Statham; Jessica Alba; Tommy Lee Jones | \n", "
2976 | \n", "3009 | \n", "Beginners | \n", "2010 | \n", "Mike Mills | \n", "Mike Mills | \n", "Ewan McGregor; Christopher Plummer; Mélanie L... | \n", "
2977 | \n", "3010 | \n", "The Core | \n", "2003 | \n", "Jon Amiel | \n", "Cooper Layne; John Rogers | \n", "Aaron Eckhart; Hilary Swank; Delroy Lindo | \n", "
2978 | \n", "3011 | \n", "Bill(I) | \n", "2015 | \n", "Richard Bracewell | \n", "Laurence Rickard; Ben Willbond | \n", "Mathew Baynton; Simon Farnaby; Martha Howe-Do... | \n", "
2979 | \n", "3012 | \n", "Because I Said So | \n", "2007 | \n", "Michael Lehmann | \n", "Karen Leigh Hopkins; Jessie Nelson | \n", "Diane Keaton; Mandy Moore; Gabriel Macht | \n", "
2980 | \n", "3013 | \n", "Elizabeth: The Golden Age | \n", "2007 | \n", "Shekhar Kapur | \n", "William Nicholson; Michael Hirst | \n", "Cate Blanchett; Clive Owen; Geoffrey Rush | \n", "
2981 | \n", "3014 | \n", "My All American | \n", "2015 | \n", "Angelo Pizzo | \n", "Angelo Pizzo | \n", "Finn Wittrock; Robin Tunney; Sarah Bolger | \n", "
2982 | \n", "3015 | \n", "The Three Stooges | \n", "2012 | \n", "Bobby Farrelly; Peter Farrelly | \n", "Mike Cerrone; Bobby Farrelly | \n", "Sean Hayes; Chris Diamantopoulos; Will Sasso | \n", "
2983 | \n", "3016 | \n", "Death at a Funeral | \n", "2007 | \n", "Frank Oz | \n", "Dean Craig | \n", "Matthew Macfadyen; Peter Dinklage; Ewen Bremner | \n", "
2984 | \n", "3017 | \n", "For Your Eyes Only | \n", "1981 | \n", "John Glen | \n", "Richard Maibaum; Michael G. Wilson | \n", "Roger Moore; Carole Bouquet; Topol | \n", "
2985 | \n", "3018 | \n", "Dawn of the Dead | \n", "1978 | \n", "George A. Romero | \n", "George A. Romero | \n", "David Emge; Ken Foree; Scott H. Reiniger | \n", "
2986 | \n", "3019 | \n", "The Lords of Salem | \n", "2012 | \n", "Rob Zombie | \n", "Rob Zombie | \n", "Sheri Moon Zombie; Meg Foster; Bruce Davison | \n", "
2987 | \n", "3020 | \n", "8½ | \n", "1963 | \n", "Federico Fellini | \n", "Federico Fellini; Ennio Flaiano | \n", "Marcello Mastroianni; Anouk Aimée; Claudia Ca... | \n", "
2988 | \n", "3021 | \n", "Gummo | \n", "1997 | \n", "Harmony Korine | \n", "Harmony Korine | \n", "Nick Sutton; Jacob Sewell; Lara Tosh | \n", "
2989 | \n", "3023 | \n", "La Dolce Vita | \n", "1960 | \n", "Federico Fellini | \n", "Federico Fellini; Ennio Flaiano | \n", "Marcello Mastroianni; Anita Ekberg; Anouk Aimée | \n", "
2990 | \n", "3024 | \n", "Invasion of the Body Snatchers | \n", "1978 | \n", "Philip Kaufman | \n", "Jack Finney; W.D. Richter | \n", "Donald Sutherland; Brooke Adams; Jeff Goldblum | \n", "
2991 | \n", "3025 | \n", "Live by Night | \n", "2017 | \n", "Ben Affleck | \n", "Ben Affleck; Dennis Lehane | \n", "Zoe Saldana; Ben Affleck; Sienna Miller | \n", "
2992 | \n", "3026 | \n", "Disaster Movie | \n", "2008 | \n", "Jason Friedberg; Aaron Seltzer | \n", "Jason Friedberg; Aaron Seltzer | \n", "Carmen Electra; Vanessa Lachey; Nicole Parker | \n", "
2993 | \n", "3027 | \n", "Flightplan | \n", "2005 | \n", "Robert Schwentke | \n", "Peter A. Dowling; Billy Ray | \n", "Jodie Foster; Peter Sarsgaard; Sean Bean | \n", "
2994 | \n", "3028 | \n", "The Natural | \n", "1984 | \n", "Barry Levinson | \n", "Bernard Malamud; Roger Towne | \n", "Robert Redford; Robert Duvall; Glenn Close | \n", "
2995 | \n", "3029 | \n", "Brother Bear | \n", "2003 | \n", "Aaron Blaise; Robert Walker | \n", "Tab Murphy; Lorne Cameron | \n", "Joaquin Phoenix; Jeremy Suarez; Rick Moranis | \n", "
2996 | \n", "3030 | \n", "Oliver! | \n", "1968 | \n", "Carol Reed | \n", "Lionel Bart; Vernon Harris | \n", "Mark Lester; Ron Moody; Shani Wallis | \n", "
2997 | \n", "3031 | \n", "Splinter Cell | \n", "2017 | \n", "\n", " | \n", " | \n", " |
2998 | \n", "3032 | \n", "Dennis the Menace | \n", "1993 | \n", "Nick Castle | \n", "Hank Ketcham; John Hughes | \n", "Walter Matthau; Mason Gamble; Joan Plowright | \n", "
2999 | \n", "3033 | \n", "Aquaman | \n", "2018 | \n", "James Wan | \n", "Kurt Johnstad; Paul Norris | \n", "Jason Momoa | \n", "
3000 rows × 6 columns
\n", "\n", " | ID | \n", "title | \n", "year | \n", "director(s) | \n", "writer(s) | \n", "actor(s) | \n", "
---|---|---|---|---|---|---|
0 | \n", "0 | \n", "Jurassic World | \n", "2015 | \n", "Colin Trevorrow | \n", "Rick Jaffa;Amanda Silver;Derek Connolly;Colin ... | \n", "Chris Pratt;Bryce Dallas Howard;Jake Johnson;J... | \n", "
1 | \n", "1 | \n", "The Martian | \n", "2015 | \n", "Ridley Scott | \n", "Drew Goddard;Andy Weir | \n", "Matt Damon;Jessica Chastain;Kate Mara;Jeff Dan... | \n", "
2 | \n", "2 | \n", "Terminator Genisys | \n", "2015 | \n", "Alan Taylor | \n", "Laeta Kalogridis;Patrick Lussier | \n", "Arnold Schwarzenegger;Jason Clarke;Emilia Clar... | \n", "
3 | \n", "3 | \n", "Mad Max: Fury Road | \n", "2015 | \n", "George Miller | \n", "George Miller;Nick Lathouris;Brendan McCarthy | \n", "Tom Hardy;Charlize Theron;Hugh Keays-Byrne;Nic... | \n", "
4 | \n", "4 | \n", "San Andreas | \n", "2015 | \n", "Brad Peyton | \n", "Carlton Cuse;Andre Fabrizio;Jeremy Passmore | \n", "Alexandra Daddario;Dwayne Johnson;Carla Gugino... | \n", "
5 | \n", "5 | \n", "Southpaw | \n", "2015 | \n", "Antoine Fuqua | \n", "Kurt Sutter;Richard Wenk | \n", "Jake Gyllenhaal;Rachel McAdams;Forest Whitaker... | \n", "
6 | \n", "6 | \n", "Tomorrowland | \n", "2015 | \n", "Brad Bird | \n", "Brad Bird;Damon Lindelof;Jeff Jensen | \n", "Britt Robertson;George Clooney;Raffey Cassidy;... | \n", "
7 | \n", "7 | \n", "Avengers: Age of Ultron | \n", "2015 | \n", "Joss Whedon | \n", "Joss Whedon | \n", "Robert Downey Jr.;Chris Evans;Chris Hemsworth;... | \n", "
8 | \n", "8 | \n", "Pixels | \n", "2015 | \n", "Chris Columbus | \n", "Tim Herlihy;Adam Sandler;Timothy Dowling;Patri... | \n", "Adam Sandler;Michelle Monaghan;Peter Dinklage;... | \n", "
9 | \n", "9 | \n", "Minions | \n", "2015 | \n", "Kyle Balda;Pierre Coffin | \n", "Brian Lynch | \n", "Pierre Coffin;Sandra Bullock;Jon Hamm;Katy Mixon | \n", "
10 | \n", "10 | \n", "Inside Out | \n", "2015 | \n", "Pete Docter;Ronaldo Del Carmen | \n", "Pete Docter;Meg LeFauve;Ronaldo Del Carmen;Jos... | \n", "Amy Poehler;Mindy Kaling;Bill Hader;Phyllis Smith | \n", "
11 | \n", "11 | \n", "Interstellar | \n", "2014 | \n", "Christopher Nolan | \n", "Christopher Nolan;Jonathan Nolan | \n", "Matthew McConaughey;Anne Hathaway;Jessica Chas... | \n", "
12 | \n", "12 | \n", "Maze Runner: The Scorch Trials | \n", "2015 | \n", "Wes Ball | \n", "James Dashner;T.S. Nowlin | \n", "Dylan O'Brien;Kaya Scodelario;Thomas Brodie-Sa... | \n", "
13 | \n", "13 | \n", "Ant-Man | \n", "2015 | \n", "Peyton Reed | \n", "Adam McKay;Edgar Wright;Joe Cornish;Paul Rudd | \n", "Paul Rudd;Michael Douglas;Evangeline Lilly;Cor... | \n", "
14 | \n", "14 | \n", "Eddie Izzard: Glorious | \n", "1997 | \n", "Peter Richardson | \n", "Eddie Izzard | \n", "Eddie Izzard | \n", "
15 | \n", "15 | \n", "Insurgent | \n", "2015 | \n", "Robert Schwentke | \n", "Brian Duffield;Akiva Goldsman;Veronica Roth;Ma... | \n", "Shailene Woodley;Theo James;Kate Winslet;Ansel... | \n", "
16 | \n", "16 | \n", "Hotel Transylvania 2 | \n", "2015 | \n", "Genndy Tartakovsky | \n", "Dan Hageman;Kevin Hageman | \n", "Adam Sandler;Kevin James;Steve Buscemi;Selena ... | \n", "
17 | \n", "17 | \n", "The Hunger Games: Mockingjay - Part 1 | \n", "2014 | \n", "Francis Lawrence | \n", "Suzanne Collins;Danny Strong;Peter Craig | \n", "Jennifer Lawrence;Josh Hutcherson;Liam Hemswor... | \n", "
18 | \n", "18 | \n", "Big Hero 6 | \n", "2014 | \n", "Don Hall;Chris Williams | \n", "Joseph Mateo;Dan Gerson;Robert L. Baird;Jordan... | \n", "Scott Adsit;Ryan Potter;Daniel Henney;T.J. Miller | \n", "
19 | \n", "19 | \n", "The Hobbit: The Battle of the Five Armies | \n", "2014 | \n", "Peter Jackson | \n", "J.R.R. Tolkien;Peter Jackson;Fran Walsh;Philip... | \n", "Martin Freeman;Ian McKellen;Richard Armitage;K... | \n", "
20 | \n", "20 | \n", "Spy | \n", "2015 | \n", "Paul Feig | \n", "Paul Feig | \n", "Melissa McCarthy;Jude Law;Jason Statham;Rose B... | \n", "
21 | \n", "21 | \n", "Kingsman: The Secret Service | \n", "2015 | \n", "Matthew Vaughn | \n", "Jane Goldman;Matthew Vaughn | \n", "Taron Egerton;Colin Firth;Samuel L. Jackson;Mi... | \n", "
22 | \n", "22 | \n", "Paper Towns | \n", "2015 | \n", "Jake Schreier | \n", "Scott Neustadter;Michael H. Weber;John Green | \n", "Nat Wolff;Cara Delevingne;Halston Sage;Caitlin... | \n", "
23 | \n", "23 | \n", "Mission: Impossible – Rogue Nation | \n", "2015 | \n", "Christopher McQuarrie | \n", "Drew Pearce;Will Staples | \n", "Tom Cruise;Jeremy Renner;Simon Pegg;Rebecca Fe... | \n", "
24 | \n", "24 | \n", "Guardians of the Galaxy | \n", "2014 | \n", "James Gunn | \n", "Nicole Perlman;James Gunn | \n", "Chris Pratt;Zoe Saldana;Dave Bautista;Vin Diesel | \n", "
25 | \n", "25 | \n", "Jupiter Ascending | \n", "2015 | \n", "Lana Wachowski;Andy Wachowski | \n", "Andy Wachowski;Lana Wachowski | \n", "Mila Kunis;Channing Tatum;Sean Bean;Eddie Redm... | \n", "
26 | \n", "26 | \n", "The Maze Runner | \n", "2014 | \n", "Wes Ball | \n", "James Dashner;Grant Pierce Myers;Noah Oppenhei... | \n", "Dylan O'Brien;Aml Ameen;Ki Hong Lee;Blake Cooper | \n", "
27 | \n", "27 | \n", "John Wick | \n", "2014 | \n", "Chad Stahelski;David Leitch | \n", "Derek Kolstad | \n", "Keanu Reeves;Michael Nyqvist;Alfie Allen;Wille... | \n", "
28 | \n", "28 | \n", "Furious 7 | \n", "2015 | \n", "James Wan | \n", "Chris Morgan | \n", "Vin Diesel;Paul Walker;Jason Statham;Michelle ... | \n", "
29 | \n", "29 | \n", "Ted 2 | \n", "2015 | \n", "Seth MacFarlane | \n", "Seth MacFarlane;Alec Sulkin;Wellesley Wild | \n", "Mark Wahlberg;Seth MacFarlane;Amanda Seyfried;... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2970 | \n", "3046 | \n", "The Hustler | \n", "1961 | \n", "Robert Rossen | \n", "Sidney Carroll;Robert Rossen;Walter Tevis | \n", "Paul Newman;Jackie Gleason;Piper Laurie;George... | \n", "
2971 | \n", "3047 | \n", "Reclaim | \n", "2014 | \n", "Alan White | \n", "Luke Davies;Carmine Gaeta | \n", "John Cusack;Ryan Phillippe;Rachelle Lefevre;Ja... | \n", "
2972 | \n", "3048 | \n", "The Woman in Black 2: Angel of Death | \n", "2014 | \n", "Tom Harper | \n", "Jon Croker;Susan Hill | \n", "Helen McCrory;Jeremy Irvine;Phoebe Fox;Ned Den... | \n", "
2973 | \n", "3050 | \n", "Conquest of the Planet of the Apes | \n", "1972 | \n", "J. Lee Thompson | \n", "Paul Dehn;Pierre Boulle | \n", "Roddy McDowall;Don Murray;Joyce Haber;Ricardo ... | \n", "
2974 | \n", "3051 | \n", "Grosse Pointe Blank | \n", "1997 | \n", "George Armitage | \n", "Tom Jankiewicz;D.V. DeVincentis;John Cusack;St... | \n", "John Cusack;Minnie Driver;Dan Aykroyd;Joan Cusack | \n", "
2975 | \n", "3052 | \n", "Fruitvale Station | \n", "2013 | \n", "Ryan Coogler | \n", "Ryan Coogler | \n", "Michael B. Jordan;Octavia Spencer;Melonie Diaz... | \n", "
2976 | \n", "3053 | \n", "A Cinderella Story | \n", "2004 | \n", "Mark Rosman | \n", "Leigh Dunlap | \n", "Hilary Duff;Jennifer Coolidge;Chad Michael Mur... | \n", "
2977 | \n", "3054 | \n", "K-19: The Widowmaker | \n", "2002 | \n", "Kathryn Bigelow | \n", "Christopher Kyle | \n", "Harrison Ford;Liam Neeson;Peter Sarsgaard;Joss... | \n", "
2978 | \n", "3055 | \n", "A Prophet | \n", "2009 | \n", "Jacques Audiard | \n", "Thomas Bidegain;Jacques Audiard | \n", "Tahar Rahim;Niels Arestrup;Adel Bencherif;Hich... | \n", "
2979 | \n", "3056 | \n", "The Disappearance of Alice Creed | \n", "2009 | \n", "J Blakeson | \n", "J Blakeson | \n", "Gemma Arterton;Martin Compston;Eddie Marsan | \n", "
2980 | \n", "3057 | \n", "Tequila Sunrise | \n", "1988 | \n", "Robert Towne | \n", "Robert Towne | \n", "Mel Gibson;Kurt Russell;J. T. Walsh;Michelle P... | \n", "
2981 | \n", "3058 | \n", "The Spiderwick Chronicles | \n", "2008 | \n", "Mark Waters | \n", "Karey Kirkpatrick;David Berenbaum;Holly Black;... | \n", "Freddie Highmore;Sarah Bolger;Nick Nolte;Mary-... | \n", "
2982 | \n", "3059 | \n", "Splice | \n", "2009 | \n", "Vincenzo Natali | \n", "Doug Taylor;Vincenzo Natali;Antoinette Terry B... | \n", "Adrien Brody;Sarah Polley;Delphine Chanéac;Dav... | \n", "
2983 | \n", "3060 | \n", "Cat on a Hot Tin Roof | \n", "1958 | \n", "Richard Brooks | \n", "Richard Brooks;James Poe | \n", "Elizabeth Taylor;Paul Newman;Burl Ives;Judith ... | \n", "
2984 | \n", "3061 | \n", "The Good Lie | \n", "2014 | \n", "Philippe Falardeau | \n", "Margaret Nagle | \n", "Reese Witherspoon;Corey Stoll;Thad Luckinbill;... | \n", "
2985 | \n", "3062 | \n", "Trading Places | \n", "1983 | \n", "John Landis | \n", "Timothy Harris;Herschel Weingrod | \n", "Eddie Murphy;Dan Aykroyd;Jamie Lee Curtis;Denh... | \n", "
2986 | \n", "3063 | \n", "The Best Offer | \n", "2013 | \n", "Giuseppe Tornatore | \n", "Giuseppe Tornatore | \n", "Geoffrey Rush;Jim Sturgess;Sylvia Hoeks;Donald... | \n", "
2987 | \n", "3064 | \n", "When the Game Stands Tall | \n", "2014 | \n", "Thomas Carter | \n", "Neil Hayes;Scott Marshall Smith;David Zelon | \n", "Jim Caviezel;Michael Chiklis;Laura Dern;Clancy... | \n", "
2988 | \n", "3065 | \n", "Ten Thousand Saints | \n", "2015 | \n", "Robert Pulcini;Shari Springer Berman | \n", "Eleanor Henderson;Shari Springer Berman;Robert... | \n", "Ethan Hawke;Asa Butterfield;Hailee Steinfeld;E... | \n", "
2989 | \n", "3066 | \n", "The Concert | \n", "2009 | \n", "Radu Mihaileanu | \n", "Alan-Michel Blanc;Radu Mihaileanu | \n", "Lionel Abelanski;Mélanie Laurent;Dmitri Nazaro... | \n", "
2990 | \n", "3067 | \n", "Bill & Ted's Excellent Adventure | \n", "1989 | \n", "Stephen Herek | \n", "Chris Matheson;Ed Solomon | \n", "Keanu Reeves;Alex Winter;George Carlin;Dan Shor | \n", "
2991 | \n", "3068 | \n", "Pangea: The Neverending World | \n", "2009 | \n", "Daniel Magyar;Adam Magyar;Zsolt Macsinka;Gabor... | \n", "NaN | \n", "NaN | \n", "
2992 | \n", "3069 | \n", "Viking: The Berserkers | \n", "2014 | \n", "Antony Smith | \n", "Antony Smith | \n", "Sol Heras;Anthony Baines;Kezia Burrows;Nick Co... | \n", "
2993 | \n", "3070 | \n", "Young Adult | \n", "2011 | \n", "Jason Reitman | \n", "Diablo Cody | \n", "Charlize Theron;Patton Oswalt;Patrick Wilson;E... | \n", "
2994 | \n", "3071 | \n", "Side by Side | \n", "2012 | \n", "Christopher Kenneally | \n", "Christopher Kenneally | \n", "Keanu Reeves;Martin Scorsese;James Cameron;Dav... | \n", "
2995 | \n", "3072 | \n", "Frank Herbert's Children of Dune | \n", "2003 | \n", "Greg Yaitanes | \n", "John Harrison;Frank Herbert | \n", "Alec Newman;Susan Sarandon;James McAvoy;Julie Cox | \n", "
2996 | \n", "3073 | \n", "Forbidden Games | \n", "1952 | \n", "René Clément | \n", "François Boyer;René Clément | \n", "Brigitte Fossey;Georges Poujouly;Amédée;Lauren... | \n", "
2997 | \n", "3074 | \n", "Armour of God II: Operation Condor | \n", "1991 | \n", "Jackie Chan | \n", "Jackie Chan;Edward Tang | \n", "Jackie Chan;Carol Cheng Yu-Ling;Eva Cobo;Shôko... | \n", "
2998 | \n", "3075 | \n", "Time Lapse | \n", "2014 | \n", "Bradley King | \n", "Bradley King;B.P. Cooper | \n", "Danielle Panabaker;Matt O'Leary;George Finn;Jo... | \n", "
2999 | \n", "3076 | \n", "Stonewall | \n", "2015 | \n", "Roland Emmerich | \n", "Jon Robin Baitz | \n", "Jeremy Irvine;Jonathan Rhys Meyers;Ron Perlman... | \n", "
3000 rows × 6 columns
\n", "\n", " | _id | \n", "ltable.ID | \n", "rtable.ID | \n", "ltable. name | \n", "ltable. year | \n", "rtable.title | \n", "rtable.year | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "1 | \n", "0 | \n", "The Martian | \n", "2015 | \n", "Jurassic World | \n", "2015 | \n", "
1 | \n", "1 | \n", "1 | \n", "1 | \n", "The Martian | \n", "2015 | \n", "The Martian | \n", "2015 | \n", "
2 | \n", "2 | \n", "1 | \n", "2 | \n", "The Martian | \n", "2015 | \n", "Terminator Genisys | \n", "2015 | \n", "
3 | \n", "3 | \n", "1 | \n", "3 | \n", "The Martian | \n", "2015 | \n", "Mad Max: Fury Road | \n", "2015 | \n", "
4 | \n", "4 | \n", "1 | \n", "4 | \n", "The Martian | \n", "2015 | \n", "San Andreas | \n", "2015 | \n", "
5 | \n", "5 | \n", "1 | \n", "5 | \n", "The Martian | \n", "2015 | \n", "Southpaw | \n", "2015 | \n", "
6 | \n", "6 | \n", "1 | \n", "6 | \n", "The Martian | \n", "2015 | \n", "Tomorrowland | \n", "2015 | \n", "
7 | \n", "7 | \n", "1 | \n", "7 | \n", "The Martian | \n", "2015 | \n", "Avengers: Age of Ultron | \n", "2015 | \n", "
8 | \n", "8 | \n", "1 | \n", "8 | \n", "The Martian | \n", "2015 | \n", "Pixels | \n", "2015 | \n", "
9 | \n", "9 | \n", "1 | \n", "9 | \n", "The Martian | \n", "2015 | \n", "Minions | \n", "2015 | \n", "
10 | \n", "10 | \n", "1 | \n", "10 | \n", "The Martian | \n", "2015 | \n", "Inside Out | \n", "2015 | \n", "
11 | \n", "11 | \n", "1 | \n", "11 | \n", "The Martian | \n", "2015 | \n", "Interstellar | \n", "2014 | \n", "
12 | \n", "12 | \n", "1 | \n", "12 | \n", "The Martian | \n", "2015 | \n", "Maze Runner: The Scorch Trials | \n", "2015 | \n", "
13 | \n", "13 | \n", "1 | \n", "13 | \n", "The Martian | \n", "2015 | \n", "Ant-Man | \n", "2015 | \n", "
14 | \n", "14 | \n", "1 | \n", "15 | \n", "The Martian | \n", "2015 | \n", "Insurgent | \n", "2015 | \n", "
15 | \n", "15 | \n", "1 | \n", "16 | \n", "The Martian | \n", "2015 | \n", "Hotel Transylvania 2 | \n", "2015 | \n", "
16 | \n", "16 | \n", "1 | \n", "17 | \n", "The Martian | \n", "2015 | \n", "The Hunger Games: Mockingjay - Part 1 | \n", "2014 | \n", "
17 | \n", "17 | \n", "1 | \n", "18 | \n", "The Martian | \n", "2015 | \n", "Big Hero 6 | \n", "2014 | \n", "
18 | \n", "18 | \n", "1 | \n", "19 | \n", "The Martian | \n", "2015 | \n", "The Hobbit: The Battle of the Five Armies | \n", "2014 | \n", "
19 | \n", "19 | \n", "1 | \n", "20 | \n", "The Martian | \n", "2015 | \n", "Spy | \n", "2015 | \n", "
20 | \n", "20 | \n", "1 | \n", "21 | \n", "The Martian | \n", "2015 | \n", "Kingsman: The Secret Service | \n", "2015 | \n", "
21 | \n", "21 | \n", "1 | \n", "22 | \n", "The Martian | \n", "2015 | \n", "Paper Towns | \n", "2015 | \n", "
22 | \n", "22 | \n", "1 | \n", "23 | \n", "The Martian | \n", "2015 | \n", "Mission: Impossible – Rogue Nation | \n", "2015 | \n", "
23 | \n", "23 | \n", "1 | \n", "24 | \n", "The Martian | \n", "2015 | \n", "Guardians of the Galaxy | \n", "2014 | \n", "
24 | \n", "24 | \n", "1 | \n", "25 | \n", "The Martian | \n", "2015 | \n", "Jupiter Ascending | \n", "2015 | \n", "
25 | \n", "25 | \n", "1 | \n", "26 | \n", "The Martian | \n", "2015 | \n", "The Maze Runner | \n", "2014 | \n", "
26 | \n", "26 | \n", "1 | \n", "27 | \n", "The Martian | \n", "2015 | \n", "John Wick | \n", "2014 | \n", "
27 | \n", "27 | \n", "1 | \n", "28 | \n", "The Martian | \n", "2015 | \n", "Furious 7 | \n", "2015 | \n", "
28 | \n", "28 | \n", "1 | \n", "29 | \n", "The Martian | \n", "2015 | \n", "Ted 2 | \n", "2015 | \n", "
29 | \n", "29 | \n", "1 | \n", "30 | \n", "The Martian | \n", "2015 | \n", "Cinderella | \n", "2015 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1148787 | \n", "1148787 | \n", "3032 | \n", "2518 | \n", "Dennis the Menace | \n", "1993 | \n", "Pom Poko | \n", "1994 | \n", "
1148788 | \n", "1148788 | \n", "3032 | \n", "2554 | \n", "Dennis the Menace | \n", "1993 | \n", "The Wrong Trousers | \n", "1993 | \n", "
1148789 | \n", "1148789 | \n", "3032 | \n", "2586 | \n", "Dennis the Menace | \n", "1993 | \n", "Clerks. | \n", "1994 | \n", "
1148790 | \n", "1148790 | \n", "3032 | \n", "2590 | \n", "Dennis the Menace | \n", "1993 | \n", "Ed Wood | \n", "1994 | \n", "
1148791 | \n", "1148791 | \n", "3032 | \n", "2592 | \n", "Dennis the Menace | \n", "1993 | \n", "Jason Goes to Hell: The Final Friday | \n", "1993 | \n", "
1148792 | \n", "1148792 | \n", "3032 | \n", "2655 | \n", "Dennis the Menace | \n", "1993 | \n", "The Naked Gun 33⅓: The Final Insult | \n", "1994 | \n", "
1148793 | \n", "1148793 | \n", "3032 | \n", "2673 | \n", "Dennis the Menace | \n", "1993 | \n", "Death Becomes Her | \n", "1992 | \n", "
1148794 | \n", "1148794 | \n", "3032 | \n", "2684 | \n", "Dennis the Menace | \n", "1993 | \n", "The Firm | \n", "1993 | \n", "
1148795 | \n", "1148795 | \n", "3032 | \n", "2702 | \n", "Dennis the Menace | \n", "1993 | \n", "Hot Shots! Part Deux | \n", "1993 | \n", "
1148796 | \n", "1148796 | \n", "3032 | \n", "2741 | \n", "Dennis the Menace | \n", "1993 | \n", "Four Weddings and a Funeral | \n", "1994 | \n", "
1148797 | \n", "1148797 | \n", "3032 | \n", "2744 | \n", "Dennis the Menace | \n", "1993 | \n", "Drop Zone | \n", "1994 | \n", "
1148798 | \n", "1148798 | \n", "3032 | \n", "2791 | \n", "Dennis the Menace | \n", "1993 | \n", "The River Wild | \n", "1994 | \n", "
1148799 | \n", "1148799 | \n", "3032 | \n", "2796 | \n", "Dennis the Menace | \n", "1993 | \n", "Cool Runnings | \n", "1993 | \n", "
1148800 | \n", "1148800 | \n", "3032 | \n", "2834 | \n", "Dennis the Menace | \n", "1993 | \n", "My Cousin Vinny | \n", "1992 | \n", "
1148801 | \n", "1148801 | \n", "3032 | \n", "2839 | \n", "Dennis the Menace | \n", "1993 | \n", "Richie Rich | \n", "1994 | \n", "
1148802 | \n", "1148802 | \n", "3032 | \n", "2918 | \n", "Dennis the Menace | \n", "1993 | \n", "Poison Ivy | \n", "1992 | \n", "
1148803 | \n", "1148803 | \n", "3032 | \n", "2939 | \n", "Dennis the Menace | \n", "1993 | \n", "The Snooks | \n", "1992 | \n", "
1148804 | \n", "1148804 | \n", "3032 | \n", "2949 | \n", "Dennis the Menace | \n", "1993 | \n", "Greedy | \n", "1994 | \n", "
1148805 | \n", "1148805 | \n", "3032 | \n", "2962 | \n", "Dennis the Menace | \n", "1993 | \n", "Carlito's Way | \n", "1993 | \n", "
1148806 | \n", "1148806 | \n", "3032 | \n", "2996 | \n", "Dennis the Menace | \n", "1993 | \n", "A Few Good Men | \n", "1992 | \n", "
1148807 | \n", "1148807 | \n", "3032 | \n", "3016 | \n", "Dennis the Menace | \n", "1993 | \n", "Fatal Instinct | \n", "1993 | \n", "
1148808 | \n", "1148808 | \n", "3032 | \n", "3037 | \n", "Dennis the Menace | \n", "1993 | \n", "Forever Young | \n", "1992 | \n", "
1148809 | \n", "1148809 | \n", "3032 | \n", "3042 | \n", "Dennis the Menace | \n", "1993 | \n", "The Bodyguard | \n", "1992 | \n", "
1148810 | \n", "1148810 | \n", "3033 | \n", "222 | \n", "Aquaman | \n", "2018 | \n", "Furious 8 | \n", "2017 | \n", "
1148811 | \n", "1148811 | \n", "3033 | \n", "296 | \n", "Aquaman | \n", "2018 | \n", "Thor: Ragnarok | \n", "2017 | \n", "
1148812 | \n", "1148812 | \n", "3033 | \n", "1334 | \n", "Aquaman | \n", "2018 | \n", "Untitled Spider-Man Reboot | \n", "2017 | \n", "
1148813 | \n", "1148813 | \n", "3033 | \n", "1413 | \n", "Aquaman | \n", "2018 | \n", "Avengers: Infinity War - Part I | \n", "2018 | \n", "
1148814 | \n", "1148814 | \n", "3033 | \n", "1971 | \n", "Aquaman | \n", "2018 | \n", "Justice League | \n", "2017 | \n", "
1148815 | \n", "1148815 | \n", "3033 | \n", "2011 | \n", "Aquaman | \n", "2018 | \n", "Guardians of the Galaxy Vol. 2 | \n", "2017 | \n", "
1148816 | \n", "1148816 | \n", "3033 | \n", "2167 | \n", "Aquaman | \n", "2018 | \n", "Avatar 2 | \n", "2017 | \n", "
1148817 rows × 7 columns
\n", "