movies_squared.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "DB_ULR = \"neo4j://localhost:7687\"\n",
    "DB_USER = \"neo4j\"\n",
    "DB_PASS = \"test1234\"\n",
    "DB_NAME = \"movies2\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Create driver\n",
    "Also set the DB_NAME\n",
    "\n",
    "Hint: Use conda if you get  No module named 'pyarrow._flight' on Apple Silicon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import plotly.graph_objects as go\n",
    "from neo4j import GraphDatabase # Python database driver\n",
    "import pyarrow\n",
    "import pyarrow.flight\n",
    "from graphdatascience import GraphDataScience # Python GDS client\n",
    "\n",
    "# And some cermony to create the driver and gds objects\n",
    "driver = GraphDatabase.driver(DB_ULR, auth=(DB_USER, DB_PASS))\n",
    "gds = GraphDataScience(DB_ULR, auth=(DB_USER, DB_PASS))\n",
    "gds.set_database(DB_NAME)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Prepare databases needed\n",
    "# Our target database sould be removed\n",
    "gds.set_database(\"system\")\n",
    "gds.run_cypher(\"CREATE OR REPLACE DATABASE {dbname}\".format(dbname = DB_NAME))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#  Load data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gds.set_database(DB_NAME)\n",
    "gds.run_cypher(\n",
    "    \"\"\"\n",
    "    CREATE (TheMatrix:Movie:Train {title:'The Matrix', released:1999, tagline:'Welcome to the Real World'})\n",
    "    CREATE (Keanu:Person:Train {name:'Keanu Reeves', born:1964})\n",
    "    CREATE (Carrie:Person:Train {name:'Carrie-Anne Moss', born:1967})\n",
    "    CREATE (Laurence:Person:Train {name:'Laurence Fishburne', born:1961})\n",
    "    CREATE (Hugo:Person:Train {name:'Hugo Weaving', born:1960})\n",
    "    CREATE (LillyW:Person:Train {name:'Lilly Wachowski', born:1967})\n",
    "    CREATE (LanaW:Person:Train {name:'Lana Wachowski', born:1965})\n",
    "    CREATE (JoelS:Person:Train {name:'Joel Silver', born:1952})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrix),\n",
    "    (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrix),\n",
    "    (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrix),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrix),\n",
    "    (LillyW)-[:DIRECTED]->(TheMatrix),\n",
    "    (LanaW)-[:DIRECTED]->(TheMatrix),\n",
    "    (JoelS)-[:PRODUCED]->(TheMatrix)\n",
    "\n",
    "    CREATE (Emil:Person:Train {name:\"Emil Eifrem\", born:1978})\n",
    "    CREATE (Emil)-[:ACTED_IN {roles:[\"Emil\"]}]->(TheMatrix)\n",
    "\n",
    "    CREATE (TheMatrixReloaded:Movie:Train {title:'The Matrix Reloaded', released:2003, tagline:'Free your mind'})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrixReloaded),\n",
    "    (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrixReloaded),\n",
    "    (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrixReloaded),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrixReloaded),\n",
    "    (LillyW)-[:DIRECTED]->(TheMatrixReloaded),\n",
    "    (LanaW)-[:DIRECTED]->(TheMatrixReloaded),\n",
    "    (JoelS)-[:PRODUCED]->(TheMatrixReloaded)\n",
    "\n",
    "    CREATE (TheMatrixRevolutions:Movie:Train {title:'The Matrix Revolutions', released:2003, tagline:'Everything that has a beginning has an end'})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrixRevolutions),\n",
    "    (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrixRevolutions),\n",
    "    (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrixRevolutions),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrixRevolutions),\n",
    "    (LillyW)-[:DIRECTED]->(TheMatrixRevolutions),\n",
    "    (LanaW)-[:DIRECTED]->(TheMatrixRevolutions),\n",
    "    (JoelS)-[:PRODUCED]->(TheMatrixRevolutions)\n",
    "\n",
    "    CREATE (TheDevilsAdvocate:Movie:Train {title:\"The Devil's Advocate\", released:1997, tagline:'Evil has its winning ways'})\n",
    "    CREATE (Charlize:Person:Train {name:'Charlize Theron', born:1975})\n",
    "    CREATE (Al:Person:Train {name:'Al Pacino', born:1940})\n",
    "    CREATE (Taylor:Person:Train {name:'Taylor Hackford', born:1944})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Kevin Lomax']}]->(TheDevilsAdvocate),\n",
    "    (Charlize)-[:ACTED_IN {roles:['Mary Ann Lomax']}]->(TheDevilsAdvocate),\n",
    "    (Al)-[:ACTED_IN {roles:['John Milton']}]->(TheDevilsAdvocate),\n",
    "    (Taylor)-[:DIRECTED]->(TheDevilsAdvocate)\n",
    "\n",
    "    CREATE (AFewGoodMen:Movie:Train {title:\"A Few Good Men\", released:1992, tagline:\"In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth.\"})\n",
    "    CREATE (TomC:Person:Train {name:'Tom Cruise', born:1962})\n",
    "    CREATE (JackN:Person:Train {name:'Jack Nicholson', born:1937})\n",
    "    CREATE (DemiM:Person:Train {name:'Demi Moore', born:1962})\n",
    "    CREATE (KevinB:Person:Train {name:'Kevin Bacon', born:1958})\n",
    "    CREATE (KieferS:Person:Train {name:'Kiefer Sutherland', born:1966})\n",
    "    CREATE (NoahW:Person:Train {name:'Noah Wyle', born:1971})\n",
    "    CREATE (CubaG:Person:Train {name:'Cuba Gooding Jr.', born:1968})\n",
    "    CREATE (KevinP:Person:Train {name:'Kevin Pollak', born:1957})\n",
    "    CREATE (JTW:Person:Train {name:'J.T. Walsh', born:1943})\n",
    "    CREATE (JamesM:Person:Train {name:'James Marshall', born:1967})\n",
    "    CREATE (ChristopherG:Person:Train {name:'Christopher Guest', born:1948})\n",
    "    CREATE (RobR:Person:Train {name:'Rob Reiner', born:1947})\n",
    "    CREATE (AaronS:Person:Train {name:'Aaron Sorkin', born:1961})\n",
    "    CREATE\n",
    "    (TomC)-[:ACTED_IN {roles:['Lt. Daniel Kaffee']}]->(AFewGoodMen),\n",
    "    (JackN)-[:ACTED_IN {roles:['Col. Nathan R. Jessup']}]->(AFewGoodMen),\n",
    "    (DemiM)-[:ACTED_IN {roles:['Lt. Cdr. JoAnne Galloway']}]->(AFewGoodMen),\n",
    "    (KevinB)-[:ACTED_IN {roles:['Capt. Jack Ross']}]->(AFewGoodMen),\n",
    "    (KieferS)-[:ACTED_IN {roles:['Lt. Jonathan Kendrick']}]->(AFewGoodMen),\n",
    "    (NoahW)-[:ACTED_IN {roles:['Cpl. Jeffrey Barnes']}]->(AFewGoodMen),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Cpl. Carl Hammaker']}]->(AFewGoodMen),\n",
    "    (KevinP)-[:ACTED_IN {roles:['Lt. Sam Weinberg']}]->(AFewGoodMen),\n",
    "    (JTW)-[:ACTED_IN {roles:['Lt. Col. Matthew Andrew Markinson']}]->(AFewGoodMen),\n",
    "    (JamesM)-[:ACTED_IN {roles:['Pfc. Louden Downey']}]->(AFewGoodMen),\n",
    "    (ChristopherG)-[:ACTED_IN {roles:['Dr. Stone']}]->(AFewGoodMen),\n",
    "    (AaronS)-[:ACTED_IN {roles:['Man in Bar']}]->(AFewGoodMen),\n",
    "    (RobR)-[:DIRECTED]->(AFewGoodMen),\n",
    "    (AaronS)-[:WROTE]->(AFewGoodMen)\n",
    "\n",
    "    CREATE (TopGun:Movie:Train {title:\"Top Gun\", released:1986, tagline:'I feel the need, the need for speed.'})\n",
    "    CREATE (KellyM:Person:Train {name:'Kelly McGillis', born:1957})\n",
    "    CREATE (ValK:Person:Train {name:'Val Kilmer', born:1959})\n",
    "    CREATE (AnthonyE:Person:Train {name:'Anthony Edwards', born:1962})\n",
    "    CREATE (TomS:Person:Train {name:'Tom Skerritt', born:1933})\n",
    "    CREATE (MegR:Person:Train {name:'Meg Ryan', born:1961})\n",
    "    CREATE (TonyS:Person:Train {name:'Tony Scott', born:1944})\n",
    "    CREATE (JimC:Person:Train {name:'Jim Cash', born:1941})\n",
    "    CREATE\n",
    "    (TomC)-[:ACTED_IN {roles:['Maverick']}]->(TopGun),\n",
    "    (KellyM)-[:ACTED_IN {roles:['Charlie']}]->(TopGun),\n",
    "    (ValK)-[:ACTED_IN {roles:['Iceman']}]->(TopGun),\n",
    "    (AnthonyE)-[:ACTED_IN {roles:['Goose']}]->(TopGun),\n",
    "    (TomS)-[:ACTED_IN {roles:['Viper']}]->(TopGun),\n",
    "    (MegR)-[:ACTED_IN {roles:['Carole']}]->(TopGun),\n",
    "    (TonyS)-[:DIRECTED]->(TopGun),\n",
    "    (JimC)-[:WROTE]->(TopGun)\n",
    "\n",
    "    CREATE (JerryMaguire:Movie:Train {title:'Jerry Maguire', released:2000, tagline:'The rest of his life begins now.'})\n",
    "    CREATE (ReneeZ:Person:Train {name:'Renee Zellweger', born:1969})\n",
    "    CREATE (KellyP:Person:Train {name:'Kelly Preston', born:1962})\n",
    "    CREATE (JerryO:Person:Train {name:\"Jerry O'Connell\", born:1974})\n",
    "    CREATE (JayM:Person:Train {name:'Jay Mohr', born:1970})\n",
    "    CREATE (BonnieH:Person:Train {name:'Bonnie Hunt', born:1961})\n",
    "    CREATE (ReginaK:Person:Train {name:'Regina King', born:1971})\n",
    "    CREATE (JonathanL:Person:Train {name:'Jonathan Lipnicki', born:1996})\n",
    "    CREATE (CameronC:Person:Train {name:'Cameron Crowe', born:1957})\n",
    "    CREATE\n",
    "    (TomC)-[:ACTED_IN {roles:['Jerry Maguire']}]->(JerryMaguire),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Rod Tidwell']}]->(JerryMaguire),\n",
    "    (ReneeZ)-[:ACTED_IN {roles:['Dorothy Boyd']}]->(JerryMaguire),\n",
    "    (KellyP)-[:ACTED_IN {roles:['Avery Bishop']}]->(JerryMaguire),\n",
    "    (JerryO)-[:ACTED_IN {roles:['Frank Cushman']}]->(JerryMaguire),\n",
    "    (JayM)-[:ACTED_IN {roles:['Bob Sugar']}]->(JerryMaguire),\n",
    "    (BonnieH)-[:ACTED_IN {roles:['Laurel Boyd']}]->(JerryMaguire),\n",
    "    (ReginaK)-[:ACTED_IN {roles:['Marcee Tidwell']}]->(JerryMaguire),\n",
    "    (JonathanL)-[:ACTED_IN {roles:['Ray Boyd']}]->(JerryMaguire),\n",
    "    (CameronC)-[:DIRECTED]->(JerryMaguire),\n",
    "    (CameronC)-[:PRODUCED]->(JerryMaguire),\n",
    "    (CameronC)-[:WROTE]->(JerryMaguire)\n",
    "\n",
    "    CREATE (StandByMe:Movie:Train {title:\"Stand By Me\", released:1986, tagline:\"For some, it's the last real taste of innocence, and the first real taste of life. But for everyone, it's the time that memories are made of.\"})\n",
    "    CREATE (RiverP:Person:Train {name:'River Phoenix', born:1970})\n",
    "    CREATE (CoreyF:Person:Train {name:'Corey Feldman', born:1971})\n",
    "    CREATE (WilW:Person:Train {name:'Wil Wheaton', born:1972})\n",
    "    CREATE (JohnC:Person:Train {name:'John Cusack', born:1966})\n",
    "    CREATE (MarshallB:Person:Train {name:'Marshall Bell', born:1942})\n",
    "    CREATE\n",
    "    (WilW)-[:ACTED_IN {roles:['Gordie Lachance']}]->(StandByMe),\n",
    "    (RiverP)-[:ACTED_IN {roles:['Chris Chambers']}]->(StandByMe),\n",
    "    (JerryO)-[:ACTED_IN {roles:['Vern Tessio']}]->(StandByMe),\n",
    "    (CoreyF)-[:ACTED_IN {roles:['Teddy Duchamp']}]->(StandByMe),\n",
    "    (JohnC)-[:ACTED_IN {roles:['Denny Lachance']}]->(StandByMe),\n",
    "    (KieferS)-[:ACTED_IN {roles:['Ace Merrill']}]->(StandByMe),\n",
    "    (MarshallB)-[:ACTED_IN {roles:['Mr. Lachance']}]->(StandByMe),\n",
    "    (RobR)-[:DIRECTED]->(StandByMe)\n",
    "\n",
    "    CREATE (AsGoodAsItGets:Movie:Train {title:'As Good as It Gets', released:1997, tagline:'A comedy from the heart that goes for the throat.'})\n",
    "    CREATE (HelenH:Person:Train {name:'Helen Hunt', born:1963})\n",
    "    CREATE (GregK:Person:Train {name:'Greg Kinnear', born:1963})\n",
    "    CREATE (JamesB:Person:Train {name:'James L. Brooks', born:1940})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Melvin Udall']}]->(AsGoodAsItGets),\n",
    "    (HelenH)-[:ACTED_IN {roles:['Carol Connelly']}]->(AsGoodAsItGets),\n",
    "    (GregK)-[:ACTED_IN {roles:['Simon Bishop']}]->(AsGoodAsItGets),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Frank Sachs']}]->(AsGoodAsItGets),\n",
    "    (JamesB)-[:DIRECTED]->(AsGoodAsItGets)\n",
    "\n",
    "    CREATE (WhatDreamsMayCome:Movie:Train {title:'What Dreams May Come', released:1998, tagline:'After life there is more. The end is just the beginning.'})\n",
    "    CREATE (AnnabellaS:Person:Train {name:'Annabella Sciorra', born:1960})\n",
    "    CREATE (MaxS:Person:Train {name:'Max von Sydow', born:1929})\n",
    "    CREATE (WernerH:Person:Train {name:'Werner Herzog', born:1942})\n",
    "    CREATE (Robin:Person:Train {name:'Robin Williams', born:1951})\n",
    "    CREATE (VincentW:Person:Train {name:'Vincent Ward', born:1956})\n",
    "    CREATE\n",
    "    (Robin)-[:ACTED_IN {roles:['Chris Nielsen']}]->(WhatDreamsMayCome),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Albert Lewis']}]->(WhatDreamsMayCome),\n",
    "    (AnnabellaS)-[:ACTED_IN {roles:['Annie Collins-Nielsen']}]->(WhatDreamsMayCome),\n",
    "    (MaxS)-[:ACTED_IN {roles:['The Tracker']}]->(WhatDreamsMayCome),\n",
    "    (WernerH)-[:ACTED_IN {roles:['The Face']}]->(WhatDreamsMayCome),\n",
    "    (VincentW)-[:DIRECTED]->(WhatDreamsMayCome)\n",
    "\n",
    "    CREATE (SnowFallingonCedars:Movie:Train {title:'Snow Falling on Cedars', released:1999, tagline:'First loves last. Forever.'})\n",
    "    CREATE (EthanH:Person:Train {name:'Ethan Hawke', born:1970})\n",
    "    CREATE (RickY:Person:Train {name:'Rick Yune', born:1971})\n",
    "    CREATE (JamesC:Person:Train {name:'James Cromwell', born:1940})\n",
    "    CREATE (ScottH:Person:Train {name:'Scott Hicks', born:1953})\n",
    "    CREATE\n",
    "    (EthanH)-[:ACTED_IN {roles:['Ishmael Chambers']}]->(SnowFallingonCedars),\n",
    "    (RickY)-[:ACTED_IN {roles:['Kazuo Miyamoto']}]->(SnowFallingonCedars),\n",
    "    (MaxS)-[:ACTED_IN {roles:['Nels Gudmundsson']}]->(SnowFallingonCedars),\n",
    "    (JamesC)-[:ACTED_IN {roles:['Judge Fielding']}]->(SnowFallingonCedars),\n",
    "    (ScottH)-[:DIRECTED]->(SnowFallingonCedars)\n",
    "\n",
    "    CREATE (YouveGotMail:Movie:Train {title:\"You've Got Mail\", released:1998, tagline:'At odds in life... in love on-line.'})\n",
    "    CREATE (ParkerP:Person:Train {name:'Parker Posey', born:1968})\n",
    "    CREATE (DaveC:Person:Train {name:'Dave Chappelle', born:1973})\n",
    "    CREATE (SteveZ:Person:Train {name:'Steve Zahn', born:1967})\n",
    "    CREATE (TomH:Person:Train {name:'Tom Hanks', born:1956})\n",
    "    CREATE (NoraE:Person:Train {name:'Nora Ephron', born:1941})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Joe Fox']}]->(YouveGotMail),\n",
    "    (MegR)-[:ACTED_IN {roles:['Kathleen Kelly']}]->(YouveGotMail),\n",
    "    (GregK)-[:ACTED_IN {roles:['Frank Navasky']}]->(YouveGotMail),\n",
    "    (ParkerP)-[:ACTED_IN {roles:['Patricia Eden']}]->(YouveGotMail),\n",
    "    (DaveC)-[:ACTED_IN {roles:['Kevin Jackson']}]->(YouveGotMail),\n",
    "    (SteveZ)-[:ACTED_IN {roles:['George Pappas']}]->(YouveGotMail),\n",
    "    (NoraE)-[:DIRECTED]->(YouveGotMail)\n",
    "\n",
    "    CREATE (SleeplessInSeattle:Movie:Train {title:'Sleepless in Seattle', released:1993, tagline:'What if someone you never met, someone you never saw, someone you never knew was the only someone for you?'})\n",
    "    CREATE (RitaW:Person:Train {name:'Rita Wilson', born:1956})\n",
    "    CREATE (BillPull:Person:Train {name:'Bill Pullman', born:1953})\n",
    "    CREATE (VictorG:Person:Train {name:'Victor Garber', born:1949})\n",
    "    CREATE (RosieO:Person:Train {name:\"Rosie O'Donnell\", born:1962})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Sam Baldwin']}]->(SleeplessInSeattle),\n",
    "    (MegR)-[:ACTED_IN {roles:['Annie Reed']}]->(SleeplessInSeattle),\n",
    "    (RitaW)-[:ACTED_IN {roles:['Suzy']}]->(SleeplessInSeattle),\n",
    "    (BillPull)-[:ACTED_IN {roles:['Walter']}]->(SleeplessInSeattle),\n",
    "    (VictorG)-[:ACTED_IN {roles:['Greg']}]->(SleeplessInSeattle),\n",
    "    (RosieO)-[:ACTED_IN {roles:['Becky']}]->(SleeplessInSeattle),\n",
    "    (NoraE)-[:DIRECTED]->(SleeplessInSeattle)\n",
    "\n",
    "    CREATE (JoeVersustheVolcano:Movie:Train {title:'Joe Versus the Volcano', released:1990, tagline:'A story of love, lava and burning desire.'})\n",
    "    CREATE (JohnS:Person:Train {name:'John Patrick Stanley', born:1950})\n",
    "    CREATE (Nathan:Person:Train {name:'Nathan Lane', born:1956})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Joe Banks']}]->(JoeVersustheVolcano),\n",
    "    (MegR)-[:ACTED_IN {roles:['DeDe', 'Angelica Graynamore', 'Patricia Graynamore']}]->(JoeVersustheVolcano),\n",
    "    (Nathan)-[:ACTED_IN {roles:['Baw']}]->(JoeVersustheVolcano),\n",
    "    (JohnS)-[:DIRECTED]->(JoeVersustheVolcano)\n",
    "\n",
    "    CREATE (WhenHarryMetSally:Movie:Train {title:'When Harry Met Sally', released:1998, tagline:'Can two friends sleep together and still love each other in the morning?'})\n",
    "    CREATE (BillyC:Person:Train {name:'Billy Crystal', born:1948})\n",
    "    CREATE (CarrieF:Person:Train {name:'Carrie Fisher', born:1956})\n",
    "    CREATE (BrunoK:Person:Train {name:'Bruno Kirby', born:1949})\n",
    "    CREATE\n",
    "    (BillyC)-[:ACTED_IN {roles:['Harry Burns']}]->(WhenHarryMetSally),\n",
    "    (MegR)-[:ACTED_IN {roles:['Sally Albright']}]->(WhenHarryMetSally),\n",
    "    (CarrieF)-[:ACTED_IN {roles:['Marie']}]->(WhenHarryMetSally),\n",
    "    (BrunoK)-[:ACTED_IN {roles:['Jess']}]->(WhenHarryMetSally),\n",
    "    (RobR)-[:DIRECTED]->(WhenHarryMetSally),\n",
    "    (RobR)-[:PRODUCED]->(WhenHarryMetSally),\n",
    "    (NoraE)-[:PRODUCED]->(WhenHarryMetSally),\n",
    "    (NoraE)-[:WROTE]->(WhenHarryMetSally)\n",
    "\n",
    "    CREATE (ThatThingYouDo:Movie:Train {title:'That Thing You Do', released:1996, tagline:'In every life there comes a time when that thing you dream becomes that thing you do'})\n",
    "    CREATE (LivT:Person:Train {name:'Liv Tyler', born:1977})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Mr. White']}]->(ThatThingYouDo),\n",
    "    (LivT)-[:ACTED_IN {roles:['Faye Dolan']}]->(ThatThingYouDo),\n",
    "    (Charlize)-[:ACTED_IN {roles:['Tina']}]->(ThatThingYouDo),\n",
    "    (TomH)-[:DIRECTED]->(ThatThingYouDo)\n",
    "\n",
    "    CREATE (TheReplacements:Movie:Train {title:'The Replacements', released:2000, tagline:'Pain heals, Chicks dig scars... Glory lasts forever'})\n",
    "    CREATE (Brooke:Person:Train {name:'Brooke Langton', born:1970})\n",
    "    CREATE (Gene:Person:Train {name:'Gene Hackman', born:1930})\n",
    "    CREATE (Orlando:Person:Train {name:'Orlando Jones', born:1968})\n",
    "    CREATE (Howard:Person:Train {name:'Howard Deutch', born:1950})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Shane Falco']}]->(TheReplacements),\n",
    "    (Brooke)-[:ACTED_IN {roles:['Annabelle Farrell']}]->(TheReplacements),\n",
    "    (Gene)-[:ACTED_IN {roles:['Jimmy McGinty']}]->(TheReplacements),\n",
    "    (Orlando)-[:ACTED_IN {roles:['Clifford Franklin']}]->(TheReplacements),\n",
    "    (Howard)-[:DIRECTED]->(TheReplacements)\n",
    "\n",
    "    CREATE (RescueDawn:Movie:Train {title:'RescueDawn', released:2006, tagline:\"Based on the extraordinary true story of one man's fight for freedom\"})\n",
    "    CREATE (ChristianB:Person:Train {name:'Christian Bale', born:1974})\n",
    "    CREATE (ZachG:Person:Train {name:'Zach Grenier', born:1954})\n",
    "    CREATE\n",
    "    (MarshallB)-[:ACTED_IN {roles:['Admiral']}]->(RescueDawn),\n",
    "    (ChristianB)-[:ACTED_IN {roles:['Dieter Dengler']}]->(RescueDawn),\n",
    "    (ZachG)-[:ACTED_IN {roles:['Squad Leader']}]->(RescueDawn),\n",
    "    (SteveZ)-[:ACTED_IN {roles:['Duane']}]->(RescueDawn),\n",
    "    (WernerH)-[:DIRECTED]->(RescueDawn)\n",
    "\n",
    "    CREATE (TheBirdcage:Movie:Train {title:'The Birdcage', released:1996, tagline:'Come as you are'})\n",
    "    CREATE (MikeN:Person:Train {name:'Mike Nichols', born:1931})\n",
    "    CREATE\n",
    "    (Robin)-[:ACTED_IN {roles:['Armand Goldman']}]->(TheBirdcage),\n",
    "    (Nathan)-[:ACTED_IN {roles:['Albert Goldman']}]->(TheBirdcage),\n",
    "    (Gene)-[:ACTED_IN {roles:['Sen. Kevin Keeley']}]->(TheBirdcage),\n",
    "    (MikeN)-[:DIRECTED]->(TheBirdcage)\n",
    "\n",
    "    CREATE (Unforgiven:Movie:Train {title:'Unforgiven', released:1992, tagline:\"It's a hell of a thing, killing a man\"})\n",
    "    CREATE (RichardH:Person:Train {name:'Richard Harris', born:1930})\n",
    "    CREATE (ClintE:Person:Train {name:'Clint Eastwood', born:1930})\n",
    "    CREATE\n",
    "    (RichardH)-[:ACTED_IN {roles:['English Bob']}]->(Unforgiven),\n",
    "    (ClintE)-[:ACTED_IN {roles:['Bill Munny']}]->(Unforgiven),\n",
    "    (Gene)-[:ACTED_IN {roles:['Little Bill Daggett']}]->(Unforgiven),\n",
    "    (ClintE)-[:DIRECTED]->(Unforgiven)\n",
    "\n",
    "    CREATE (JohnnyMnemonic:Movie:Train {title:'Johnny Mnemonic', released:1995, tagline:'The hottest data on earth. In the coolest head in town'})\n",
    "    CREATE (Takeshi:Person:Train {name:'Takeshi Kitano', born:1947})\n",
    "    CREATE (Dina:Person:Train {name:'Dina Meyer', born:1968})\n",
    "    CREATE (IceT:Person:Train {name:'Ice-T', born:1958})\n",
    "    CREATE (RobertL:Person:Train {name:'Robert Longo', born:1953})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Johnny Mnemonic']}]->(JohnnyMnemonic),\n",
    "    (Takeshi)-[:ACTED_IN {roles:['Takahashi']}]->(JohnnyMnemonic),\n",
    "    (Dina)-[:ACTED_IN {roles:['Jane']}]->(JohnnyMnemonic),\n",
    "    (IceT)-[:ACTED_IN {roles:['J-Bone']}]->(JohnnyMnemonic),\n",
    "    (RobertL)-[:DIRECTED]->(JohnnyMnemonic)\n",
    "\n",
    "    CREATE (CloudAtlas:Movie:Train {title:'Cloud Atlas', released:2012, tagline:'Everything is connected'})\n",
    "    CREATE (HalleB:Person:Train {name:'Halle Berry', born:1966})\n",
    "    CREATE (JimB:Person:Train {name:'Jim Broadbent', born:1949})\n",
    "    CREATE (TomT:Person:Train {name:'Tom Tykwer', born:1965})\n",
    "    CREATE (DavidMitchell:Person:Train {name:'David Mitchell', born:1969})\n",
    "    CREATE (StefanArndt:Person:Train {name:'Stefan Arndt', born:1961})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Zachry', 'Dr. Henry Goose', 'Isaac Sachs', 'Dermot Hoggins']}]->(CloudAtlas),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Bill Smoke', 'Haskell Moore', 'Tadeusz Kesselring', 'Nurse Noakes', 'Boardman Mephi', 'Old Georgie']}]->(CloudAtlas),\n",
    "    (HalleB)-[:ACTED_IN {roles:['Luisa Rey', 'Jocasta Ayrs', 'Ovid', 'Meronym']}]->(CloudAtlas),\n",
    "    (JimB)-[:ACTED_IN {roles:['Vyvyan Ayrs', 'Captain Molyneux', 'Timothy Cavendish']}]->(CloudAtlas),\n",
    "    (TomT)-[:DIRECTED]->(CloudAtlas),\n",
    "    (LillyW)-[:DIRECTED]->(CloudAtlas),\n",
    "    (LanaW)-[:DIRECTED]->(CloudAtlas),\n",
    "    (DavidMitchell)-[:WROTE]->(CloudAtlas),\n",
    "    (StefanArndt)-[:PRODUCED]->(CloudAtlas)\n",
    "\n",
    "    CREATE (TheDaVinciCode:Movie:Train {title:'The Da Vinci Code', released:2006, tagline:'Break The Codes'})\n",
    "    CREATE (IanM:Person:Train {name:'Ian McKellen', born:1939})\n",
    "    CREATE (AudreyT:Person:Train {name:'Audrey Tautou', born:1976})\n",
    "    CREATE (PaulB:Person:Train {name:'Paul Bettany', born:1971})\n",
    "    CREATE (RonH:Person:Train {name:'Ron Howard', born:1954})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Dr. Robert Langdon']}]->(TheDaVinciCode),\n",
    "    (IanM)-[:ACTED_IN {roles:['Sir Leight Teabing']}]->(TheDaVinciCode),\n",
    "    (AudreyT)-[:ACTED_IN {roles:['Sophie Neveu']}]->(TheDaVinciCode),\n",
    "    (PaulB)-[:ACTED_IN {roles:['Silas']}]->(TheDaVinciCode),\n",
    "    (RonH)-[:DIRECTED]->(TheDaVinciCode)\n",
    "\n",
    "    CREATE (VforVendetta:Movie:Train {title:'V for Vendetta', released:2006, tagline:'Freedom! Forever!'})\n",
    "    CREATE (NatalieP:Person:Train {name:'Natalie Portman', born:1981})\n",
    "    CREATE (StephenR:Person:Train {name:'Stephen Rea', born:1946})\n",
    "    CREATE (JohnH:Person:Train {name:'John Hurt', born:1940})\n",
    "    CREATE (BenM:Person:Train {name: 'Ben Miles', born:1967})\n",
    "    CREATE\n",
    "    (Hugo)-[:ACTED_IN {roles:['V']}]->(VforVendetta),\n",
    "    (NatalieP)-[:ACTED_IN {roles:['Evey Hammond']}]->(VforVendetta),\n",
    "    (StephenR)-[:ACTED_IN {roles:['Eric Finch']}]->(VforVendetta),\n",
    "    (JohnH)-[:ACTED_IN {roles:['High Chancellor Adam Sutler']}]->(VforVendetta),\n",
    "    (BenM)-[:ACTED_IN {roles:['Dascomb']}]->(VforVendetta),\n",
    "    (JamesM)-[:DIRECTED]->(VforVendetta),\n",
    "    (LillyW)-[:PRODUCED]->(VforVendetta),\n",
    "    (LanaW)-[:PRODUCED]->(VforVendetta),\n",
    "    (JoelS)-[:PRODUCED]->(VforVendetta),\n",
    "    (LillyW)-[:WROTE]->(VforVendetta),\n",
    "    (LanaW)-[:WROTE]->(VforVendetta)\n",
    "\n",
    "    CREATE (SpeedRacer:Movie:Train {title:'Speed Racer', released:2008, tagline:'Speed has no limits'})\n",
    "    CREATE (EmileH:Person:Train {name:'Emile Hirsch', born:1985})\n",
    "    CREATE (JohnG:Person:Train {name:'John Goodman', born:1960})\n",
    "    CREATE (SusanS:Person:Train {name:'Susan Sarandon', born:1946})\n",
    "    CREATE (MatthewF:Person:Train {name:'Matthew Fox', born:1966})\n",
    "    CREATE (ChristinaR:Person:Train {name:'Christina Ricci', born:1980})\n",
    "    CREATE (Rain:Person:Train {name:'Rain', born:1982})\n",
    "    CREATE\n",
    "    (EmileH)-[:ACTED_IN {roles:['Speed Racer']}]->(SpeedRacer),\n",
    "    (JohnG)-[:ACTED_IN {roles:['Pops']}]->(SpeedRacer),\n",
    "    (SusanS)-[:ACTED_IN {roles:['Mom']}]->(SpeedRacer),\n",
    "    (MatthewF)-[:ACTED_IN {roles:['Racer X']}]->(SpeedRacer),\n",
    "    (ChristinaR)-[:ACTED_IN {roles:['Trixie']}]->(SpeedRacer),\n",
    "    (Rain)-[:ACTED_IN {roles:['Taejo Togokahn']}]->(SpeedRacer),\n",
    "    (BenM)-[:ACTED_IN {roles:['Cass Jones']}]->(SpeedRacer),\n",
    "    (LillyW)-[:DIRECTED]->(SpeedRacer),\n",
    "    (LanaW)-[:DIRECTED]->(SpeedRacer),\n",
    "    (LillyW)-[:WROTE]->(SpeedRacer),\n",
    "    (LanaW)-[:WROTE]->(SpeedRacer),\n",
    "    (JoelS)-[:PRODUCED]->(SpeedRacer)\n",
    "\n",
    "    CREATE (NinjaAssassin:Movie:Train {title:'Ninja Assassin', released:2009, tagline:'Prepare to enter a secret world of assassins'})\n",
    "    CREATE (NaomieH:Person:Train {name:'Naomie Harris'})\n",
    "    CREATE\n",
    "    (Rain)-[:ACTED_IN {roles:['Raizo']}]->(NinjaAssassin),\n",
    "    (NaomieH)-[:ACTED_IN {roles:['Mika Coretti']}]->(NinjaAssassin),\n",
    "    (RickY)-[:ACTED_IN {roles:['Takeshi']}]->(NinjaAssassin),\n",
    "    (BenM)-[:ACTED_IN {roles:['Ryan Maslow']}]->(NinjaAssassin),\n",
    "    (JamesM)-[:DIRECTED]->(NinjaAssassin),\n",
    "    (LillyW)-[:PRODUCED]->(NinjaAssassin),\n",
    "    (LanaW)-[:PRODUCED]->(NinjaAssassin),\n",
    "    (JoelS)-[:PRODUCED]->(NinjaAssassin)\n",
    "\n",
    "    CREATE (TheGreenMile:Movie:Train {title:'The Green Mile', released:1999, tagline:\"Walk a mile you'll never forget.\"})\n",
    "    CREATE (MichaelD:Person:Train {name:'Michael Clarke Duncan', born:1957})\n",
    "    CREATE (DavidM:Person:Train {name:'David Morse', born:1953})\n",
    "    CREATE (SamR:Person {name:'Sam Rockwell', born:1968})\n",
    "    CREATE (GaryS:Person {name:'Gary Sinise', born:1955})\n",
    "    CREATE (PatriciaC:Person {name:'Patricia Clarkson', born:1959})\n",
    "    CREATE (FrankD:Person {name:'Frank Darabont', born:1959})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Paul Edgecomb']}]->(TheGreenMile),\n",
    "    (MichaelD)-[:ACTED_IN {roles:['John Coffey']}]->(TheGreenMile),\n",
    "    (DavidM)-[:ACTED_IN {roles:['Brutus \"Brutal\" Howell']}]->(TheGreenMile),\n",
    "    (BonnieH)-[:ACTED_IN {roles:['Jan Edgecomb']}]->(TheGreenMile),\n",
    "    (JamesC)-[:ACTED_IN {roles:['Warden Hal Moores']}]->(TheGreenMile),\n",
    "    (SamR)-[:ACTED_IN {roles:['\"Wild Bill\" Wharton']}]->(TheGreenMile),\n",
    "    (GaryS)-[:ACTED_IN {roles:['Burt Hammersmith']}]->(TheGreenMile),\n",
    "    (PatriciaC)-[:ACTED_IN {roles:['Melinda Moores']}]->(TheGreenMile),\n",
    "    (FrankD)-[:DIRECTED]->(TheGreenMile)\n",
    "\n",
    "    CREATE (FrostNixon:Movie:Train {title:'Frost/Nixon', released:2008, tagline:'400 million people were waiting for the truth.'})\n",
    "    CREATE (FrankL:Person {name:'Frank Langella', born:1938})\n",
    "    CREATE (MichaelS:Person {name:'Michael Sheen', born:1969})\n",
    "    CREATE (OliverP:Person {name:'Oliver Platt', born:1960})\n",
    "    CREATE\n",
    "    (FrankL)-[:ACTED_IN {roles:['Richard Nixon']}]->(FrostNixon),\n",
    "    (MichaelS)-[:ACTED_IN {roles:['David Frost']}]->(FrostNixon),\n",
    "    (KevinB)-[:ACTED_IN {roles:['Jack Brennan']}]->(FrostNixon),\n",
    "    (OliverP)-[:ACTED_IN {roles:['Bob Zelnick']}]->(FrostNixon),\n",
    "    (SamR)-[:ACTED_IN {roles:['James Reston, Jr.']}]->(FrostNixon),\n",
    "    (RonH)-[:DIRECTED]->(FrostNixon)\n",
    "\n",
    "    CREATE (Hoffa:Movie:Train {title:'Hoffa', released:1992, tagline:\"He didn't want law. He wanted justice.\"})\n",
    "    CREATE (DannyD:Person {name:'Danny DeVito', born:1944})\n",
    "    CREATE (JohnR:Person {name:'John C. Reilly', born:1965})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Hoffa']}]->(Hoffa),\n",
    "    (DannyD)-[:ACTED_IN {roles:['Robert \"Bobby\" Ciaro']}]->(Hoffa),\n",
    "    (JTW)-[:ACTED_IN {roles:['Frank Fitzsimmons']}]->(Hoffa),\n",
    "    (JohnR)-[:ACTED_IN {roles:['Peter \"Pete\" Connelly']}]->(Hoffa),\n",
    "    (DannyD)-[:DIRECTED]->(Hoffa)\n",
    "\n",
    "    CREATE (Apollo13:Movie:Train {title:'Apollo 13', released:1995, tagline:'Houston, we have a problem.'})\n",
    "    CREATE (EdH:Person {name:'Ed Harris', born:1950})\n",
    "    CREATE (BillPax:Person {name:'Bill Paxton', born:1955})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Jim Lovell']}]->(Apollo13),\n",
    "    (KevinB)-[:ACTED_IN {roles:['Jack Swigert']}]->(Apollo13),\n",
    "    (EdH)-[:ACTED_IN {roles:['Gene Kranz']}]->(Apollo13),\n",
    "    (BillPax)-[:ACTED_IN {roles:['Fred Haise']}]->(Apollo13),\n",
    "    (GaryS)-[:ACTED_IN {roles:['Ken Mattingly']}]->(Apollo13),\n",
    "    (RonH)-[:DIRECTED]->(Apollo13)\n",
    "\n",
    "    CREATE (Twister:Movie:Train {title:'Twister', released:1996, tagline:\"Don't Breathe. Don't Look Back.\"})\n",
    "    CREATE (PhilipH:Person {name:'Philip Seymour Hoffman', born:1967})\n",
    "    CREATE (JanB:Person {name:'Jan de Bont', born:1943})\n",
    "    CREATE\n",
    "    (BillPax)-[:ACTED_IN {roles:['Bill Harding']}]->(Twister),\n",
    "    (HelenH)-[:ACTED_IN {roles:['Dr. Jo Harding']}]->(Twister),\n",
    "    (ZachG)-[:ACTED_IN {roles:['Eddie']}]->(Twister),\n",
    "    (PhilipH)-[:ACTED_IN {roles:['Dustin \"Dusty\" Davis']}]->(Twister),\n",
    "    (JanB)-[:DIRECTED]->(Twister)\n",
    "\n",
    "    CREATE (CastAway:Movie:Train {title:'Cast Away', released:2000, tagline:'At the edge of the world, his journey begins.'})\n",
    "    CREATE (RobertZ:Person {name:'Robert Zemeckis', born:1951})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Chuck Noland']}]->(CastAway),\n",
    "    (HelenH)-[:ACTED_IN {roles:['Kelly Frears']}]->(CastAway),\n",
    "    (RobertZ)-[:DIRECTED]->(CastAway)\n",
    "\n",
    "    CREATE (OneFlewOvertheCuckoosNest:Movie:Train {title:\"One Flew Over the Cuckoo's Nest\", released:1975, tagline:\"If he's crazy, what does that make you?\"})\n",
    "    CREATE (MilosF:Person {name:'Milos Forman', born:1932})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Randle McMurphy']}]->(OneFlewOvertheCuckoosNest),\n",
    "    (DannyD)-[:ACTED_IN {roles:['Martini']}]->(OneFlewOvertheCuckoosNest),\n",
    "    (MilosF)-[:DIRECTED]->(OneFlewOvertheCuckoosNest)\n",
    "\n",
    "    CREATE (SomethingsGottaGive:Movie:Train {title:\"Something's Gotta Give\", released:2003})\n",
    "    CREATE (DianeK:Person {name:'Diane Keaton', born:1946})\n",
    "    CREATE (NancyM:Person {name:'Nancy Meyers', born:1949})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Harry Sanborn']}]->(SomethingsGottaGive),\n",
    "    (DianeK)-[:ACTED_IN {roles:['Erica Barry']}]->(SomethingsGottaGive),\n",
    "    (Keanu)-[:ACTED_IN {roles:['Julian Mercer']}]->(SomethingsGottaGive),\n",
    "    (NancyM)-[:DIRECTED]->(SomethingsGottaGive),\n",
    "    (NancyM)-[:PRODUCED]->(SomethingsGottaGive),\n",
    "    (NancyM)-[:WROTE]->(SomethingsGottaGive)\n",
    "\n",
    "    CREATE (BicentennialMan:Movie:Train {title:'Bicentennial Man', released:1999, tagline:\"One robot's 200 year journey to become an ordinary man.\"})\n",
    "    CREATE (ChrisC:Person {name:'Chris Columbus', born:1958})\n",
    "    CREATE\n",
    "    (Robin)-[:ACTED_IN {roles:['Andrew Marin']}]->(BicentennialMan),\n",
    "    (OliverP)-[:ACTED_IN {roles:['Rupert Burns']}]->(BicentennialMan),\n",
    "    (ChrisC)-[:DIRECTED]->(BicentennialMan)\n",
    "\n",
    "    CREATE (CharlieWilsonsWar:Movie:Train {title:\"Charlie Wilson's War\", released:2007, tagline:\"A stiff drink. A little mascara. A lot of nerve. Who said they couldn't bring down the Soviet empire.\"})\n",
    "    CREATE (JuliaR:Person {name:'Julia Roberts', born:1967})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Rep. Charlie Wilson']}]->(CharlieWilsonsWar),\n",
    "    (JuliaR)-[:ACTED_IN {roles:['Joanne Herring']}]->(CharlieWilsonsWar),\n",
    "    (PhilipH)-[:ACTED_IN {roles:['Gust Avrakotos']}]->(CharlieWilsonsWar),\n",
    "    (MikeN)-[:DIRECTED]->(CharlieWilsonsWar)\n",
    "\n",
    "    CREATE (ThePolarExpress:Movie:Train {title:'The Polar Express', released:2004, tagline:'This Holiday Season... Believe'})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Hero Boy', 'Father', 'Conductor', 'Hobo', 'Scrooge', 'Santa Claus']}]->(ThePolarExpress),\n",
    "    (RobertZ)-[:DIRECTED]->(ThePolarExpress)\n",
    "\n",
    "    CREATE (ALeagueofTheirOwn:Movie:Train {title:'A League of Their Own', released:1992, tagline:'Once in a lifetime you get a chance to do something different.'})\n",
    "    CREATE (Madonna:Person {name:'Madonna', born:1954})\n",
    "    CREATE (GeenaD:Person {name:'Geena Davis', born:1956})\n",
    "    CREATE (LoriP:Person {name:'Lori Petty', born:1963})\n",
    "    CREATE (PennyM:Person {name:'Penny Marshall', born:1943})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Jimmy Dugan']}]->(ALeagueofTheirOwn),\n",
    "    (GeenaD)-[:ACTED_IN {roles:['Dottie Hinson']}]->(ALeagueofTheirOwn),\n",
    "    (LoriP)-[:ACTED_IN {roles:['Kit Keller']}]->(ALeagueofTheirOwn),\n",
    "    (RosieO)-[:ACTED_IN {roles:['Doris Murphy']}]->(ALeagueofTheirOwn),\n",
    "    (Madonna)-[:ACTED_IN {roles:['\"All the Way\" Mae Mordabito']}]->(ALeagueofTheirOwn),\n",
    "    (BillPax)-[:ACTED_IN {roles:['Bob Hinson']}]->(ALeagueofTheirOwn),\n",
    "    (PennyM)-[:DIRECTED]->(ALeagueofTheirOwn)\n",
    "\n",
    "    CREATE (PaulBlythe:Person {name:'Paul Blythe'})\n",
    "    CREATE (AngelaScope:Person {name:'Angela Scope'})\n",
    "    CREATE (JessicaThompson:Person {name:'Jessica Thompson'})\n",
    "    CREATE (JamesThompson:Person {name:'James Thompson'})\n",
    "\n",
    "    CREATE\n",
    "    (JamesThompson)-[:FOLLOWS]->(JessicaThompson),\n",
    "    (AngelaScope)-[:FOLLOWS]->(JessicaThompson),\n",
    "    (PaulBlythe)-[:FOLLOWS]->(AngelaScope)\n",
    "\n",
    "    CREATE\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'An amazing journey', rating:95}]->(CloudAtlas),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'Silly, but fun', rating:65}]->(TheReplacements),\n",
    "    (JamesThompson)-[:REVIEWED {summary:'The coolest football movie ever', rating:100}]->(TheReplacements),\n",
    "    (AngelaScope)-[:REVIEWED {summary:'Pretty funny at times', rating:62}]->(TheReplacements),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'Dark, but compelling', rating:85}]->(Unforgiven),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:\"Slapstick redeemed only by the Robin Williams and Gene Hackman's stellar performances\", rating:45}]->(TheBirdcage),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'A solid romp', rating:68}]->(TheDaVinciCode),\n",
    "    (JamesThompson)-[:REVIEWED {summary:'Fun, but a little far fetched', rating:65}]->(TheDaVinciCode),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'You had me at Jerry', rating:92}]->(JerryMaguire)\n",
    "    \"\"\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gds.set_database(DB_NAME)\n",
    "gds.run_cypher(\n",
    "    \"\"\"\n",
    "    CREATE (TheMatrix:Movie:Test {title:'The Matrix', released:1999, tagline:'Welcome to the Real World'})\n",
    "    CREATE (Keanu:Person:Test {name:'Keanu Reeves', born:1964})\n",
    "    CREATE (Carrie:Person:Test {name:'Carrie-Anne Moss', born:1967})\n",
    "    CREATE (Laurence:Person:Test {name:'Laurence Fishburne', born:1961})\n",
    "    CREATE (Hugo:Person:Test {name:'Hugo Weaving', born:1960})\n",
    "    CREATE (LillyW:Person:Test {name:'Lilly Wachowski', born:1967})\n",
    "    CREATE (LanaW:Person:Test {name:'Lana Wachowski', born:1965})\n",
    "    CREATE (JoelS:Person:Test {name:'Joel Silver', born:1952})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrix),\n",
    "    (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrix),\n",
    "    (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrix),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrix),\n",
    "    (LillyW)-[:DIRECTED]->(TheMatrix),\n",
    "    (LanaW)-[:DIRECTED]->(TheMatrix),\n",
    "    (JoelS)-[:PRODUCED]->(TheMatrix)\n",
    "\n",
    "    CREATE (Emil:Person:Test {name:\"Emil Eifrem\", born:1978})\n",
    "    CREATE (Emil)-[:ACTED_IN {roles:[\"Emil\"]}]->(TheMatrix)\n",
    "\n",
    "    CREATE (TheMatrixReloaded:Movie:Test {title:'The Matrix Reloaded', released:2003, tagline:'Free your mind'})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrixReloaded),\n",
    "    (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrixReloaded),\n",
    "    (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrixReloaded),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrixReloaded),\n",
    "    (LillyW)-[:DIRECTED]->(TheMatrixReloaded),\n",
    "    (LanaW)-[:DIRECTED]->(TheMatrixReloaded),\n",
    "    (JoelS)-[:PRODUCED]->(TheMatrixReloaded)\n",
    "\n",
    "    CREATE (TheMatrixRevolutions:Movie:Test {title:'The Matrix Revolutions', released:2003, tagline:'Everything that has a beginning has an end'})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrixRevolutions),\n",
    "    (Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrixRevolutions),\n",
    "    (Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrixRevolutions),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrixRevolutions),\n",
    "    (LillyW)-[:DIRECTED]->(TheMatrixRevolutions),\n",
    "    (LanaW)-[:DIRECTED]->(TheMatrixRevolutions),\n",
    "    (JoelS)-[:PRODUCED]->(TheMatrixRevolutions)\n",
    "\n",
    "    CREATE (TheDevilsAdvocate:Movie:Test {title:\"The Devil's Advocate\", released:1997, tagline:'Evil has its winning ways'})\n",
    "    CREATE (Charlize:Person:Test {name:'Charlize Theron', born:1975})\n",
    "    CREATE (Al:Person:Test {name:'Al Pacino', born:1940})\n",
    "    CREATE (Taylor:Person:Test {name:'Taylor Hackford', born:1944})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Kevin Lomax']}]->(TheDevilsAdvocate),\n",
    "    (Charlize)-[:ACTED_IN {roles:['Mary Ann Lomax']}]->(TheDevilsAdvocate),\n",
    "    (Al)-[:ACTED_IN {roles:['John Milton']}]->(TheDevilsAdvocate),\n",
    "    (Taylor)-[:DIRECTED]->(TheDevilsAdvocate)\n",
    "\n",
    "    CREATE (AFewGoodMen:Movie:Test {title:\"A Few Good Men\", released:1992, tagline:\"In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth.\"})\n",
    "    CREATE (TomC:Person:Test {name:'Tom Cruise', born:1962})\n",
    "    CREATE (JackN:Person:Test {name:'Jack Nicholson', born:1937})\n",
    "    CREATE (DemiM:Person:Test {name:'Demi Moore', born:1962})\n",
    "    CREATE (KevinB:Person:Test {name:'Kevin Bacon', born:1958})\n",
    "    CREATE (KieferS:Person:Test {name:'Kiefer Sutherland', born:1966})\n",
    "    CREATE (NoahW:Person:Test {name:'Noah Wyle', born:1971})\n",
    "    CREATE (CubaG:Person:Test {name:'Cuba Gooding Jr.', born:1968})\n",
    "    CREATE (KevinP:Person:Test {name:'Kevin Pollak', born:1957})\n",
    "    CREATE (JTW:Person:Test {name:'J.T. Walsh', born:1943})\n",
    "    CREATE (JamesM:Person:Test {name:'James Marshall', born:1967})\n",
    "    CREATE (ChristopherG:Person:Test {name:'Christopher Guest', born:1948})\n",
    "    CREATE (RobR:Person:Test {name:'Rob Reiner', born:1947})\n",
    "    CREATE (AaronS:Person:Test {name:'Aaron Sorkin', born:1961})\n",
    "    CREATE\n",
    "    (TomC)-[:ACTED_IN {roles:['Lt. Daniel Kaffee']}]->(AFewGoodMen),\n",
    "    (JackN)-[:ACTED_IN {roles:['Col. Nathan R. Jessup']}]->(AFewGoodMen),\n",
    "    (DemiM)-[:ACTED_IN {roles:['Lt. Cdr. JoAnne Galloway']}]->(AFewGoodMen),\n",
    "    (KevinB)-[:ACTED_IN {roles:['Capt. Jack Ross']}]->(AFewGoodMen),\n",
    "    (KieferS)-[:ACTED_IN {roles:['Lt. Jonathan Kendrick']}]->(AFewGoodMen),\n",
    "    (NoahW)-[:ACTED_IN {roles:['Cpl. Jeffrey Barnes']}]->(AFewGoodMen),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Cpl. Carl Hammaker']}]->(AFewGoodMen),\n",
    "    (KevinP)-[:ACTED_IN {roles:['Lt. Sam Weinberg']}]->(AFewGoodMen),\n",
    "    (JTW)-[:ACTED_IN {roles:['Lt. Col. Matthew Andrew Markinson']}]->(AFewGoodMen),\n",
    "    (JamesM)-[:ACTED_IN {roles:['Pfc. Louden Downey']}]->(AFewGoodMen),\n",
    "    (ChristopherG)-[:ACTED_IN {roles:['Dr. Stone']}]->(AFewGoodMen),\n",
    "    (AaronS)-[:ACTED_IN {roles:['Man in Bar']}]->(AFewGoodMen),\n",
    "    (RobR)-[:DIRECTED]->(AFewGoodMen),\n",
    "    (AaronS)-[:WROTE]->(AFewGoodMen)\n",
    "\n",
    "    CREATE (TopGun:Movie:Test {title:\"Top Gun\", released:1986, tagline:'I feel the need, the need for speed.'})\n",
    "    CREATE (KellyM:Person:Test {name:'Kelly McGillis', born:1957})\n",
    "    CREATE (ValK:Person:Test {name:'Val Kilmer', born:1959})\n",
    "    CREATE (AnthonyE:Person:Test {name:'Anthony Edwards', born:1962})\n",
    "    CREATE (TomS:Person:Test {name:'Tom Skerritt', born:1933})\n",
    "    CREATE (MegR:Person:Test {name:'Meg Ryan', born:1961})\n",
    "    CREATE (TonyS:Person:Test {name:'Tony Scott', born:1944})\n",
    "    CREATE (JimC:Person:Test {name:'Jim Cash', born:1941})\n",
    "    CREATE\n",
    "    (TomC)-[:ACTED_IN {roles:['Maverick']}]->(TopGun),\n",
    "    (KellyM)-[:ACTED_IN {roles:['Charlie']}]->(TopGun),\n",
    "    (ValK)-[:ACTED_IN {roles:['Iceman']}]->(TopGun),\n",
    "    (AnthonyE)-[:ACTED_IN {roles:['Goose']}]->(TopGun),\n",
    "    (TomS)-[:ACTED_IN {roles:['Viper']}]->(TopGun),\n",
    "    (MegR)-[:ACTED_IN {roles:['Carole']}]->(TopGun),\n",
    "    (TonyS)-[:DIRECTED]->(TopGun),\n",
    "    (JimC)-[:WROTE]->(TopGun)\n",
    "\n",
    "    CREATE (JerryMaguire:Movie:Test {title:'Jerry Maguire', released:2000, tagline:'The rest of his life begins now.'})\n",
    "    CREATE (ReneeZ:Person:Test {name:'Renee Zellweger', born:1969})\n",
    "    CREATE (KellyP:Person:Test {name:'Kelly Preston', born:1962})\n",
    "    CREATE (JerryO:Person:Test {name:\"Jerry O'Connell\", born:1974})\n",
    "    CREATE (JayM:Person:Test {name:'Jay Mohr', born:1970})\n",
    "    CREATE (BonnieH:Person:Test {name:'Bonnie Hunt', born:1961})\n",
    "    CREATE (ReginaK:Person:Test {name:'Regina King', born:1971})\n",
    "    CREATE (JonathanL:Person:Test {name:'Jonathan Lipnicki', born:1996})\n",
    "    CREATE (CameronC:Person:Test {name:'Cameron Crowe', born:1957})\n",
    "    CREATE\n",
    "    (TomC)-[:ACTED_IN {roles:['Jerry Maguire']}]->(JerryMaguire),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Rod Tidwell']}]->(JerryMaguire),\n",
    "    (ReneeZ)-[:ACTED_IN {roles:['Dorothy Boyd']}]->(JerryMaguire),\n",
    "    (KellyP)-[:ACTED_IN {roles:['Avery Bishop']}]->(JerryMaguire),\n",
    "    (JerryO)-[:ACTED_IN {roles:['Frank Cushman']}]->(JerryMaguire),\n",
    "    (JayM)-[:ACTED_IN {roles:['Bob Sugar']}]->(JerryMaguire),\n",
    "    (BonnieH)-[:ACTED_IN {roles:['Laurel Boyd']}]->(JerryMaguire),\n",
    "    (ReginaK)-[:ACTED_IN {roles:['Marcee Tidwell']}]->(JerryMaguire),\n",
    "    (JonathanL)-[:ACTED_IN {roles:['Ray Boyd']}]->(JerryMaguire),\n",
    "    (CameronC)-[:DIRECTED]->(JerryMaguire),\n",
    "    (CameronC)-[:PRODUCED]->(JerryMaguire),\n",
    "    (CameronC)-[:WROTE]->(JerryMaguire)\n",
    "\n",
    "    CREATE (StandByMe:Movie:Test {title:\"Stand By Me\", released:1986, tagline:\"For some, it's the last real taste of innocence, and the first real taste of life. But for everyone, it's the time that memories are made of.\"})\n",
    "    CREATE (RiverP:Person:Test {name:'River Phoenix', born:1970})\n",
    "    CREATE (CoreyF:Person:Test {name:'Corey Feldman', born:1971})\n",
    "    CREATE (WilW:Person:Test {name:'Wil Wheaton', born:1972})\n",
    "    CREATE (JohnC:Person:Test {name:'John Cusack', born:1966})\n",
    "    CREATE (MarshallB:Person:Test {name:'Marshall Bell', born:1942})\n",
    "    CREATE\n",
    "    (WilW)-[:ACTED_IN {roles:['Gordie Lachance']}]->(StandByMe),\n",
    "    (RiverP)-[:ACTED_IN {roles:['Chris Chambers']}]->(StandByMe),\n",
    "    (JerryO)-[:ACTED_IN {roles:['Vern Tessio']}]->(StandByMe),\n",
    "    (CoreyF)-[:ACTED_IN {roles:['Teddy Duchamp']}]->(StandByMe),\n",
    "    (JohnC)-[:ACTED_IN {roles:['Denny Lachance']}]->(StandByMe),\n",
    "    (KieferS)-[:ACTED_IN {roles:['Ace Merrill']}]->(StandByMe),\n",
    "    (MarshallB)-[:ACTED_IN {roles:['Mr. Lachance']}]->(StandByMe),\n",
    "    (RobR)-[:DIRECTED]->(StandByMe)\n",
    "\n",
    "    CREATE (AsGoodAsItGets:Movie:Test {title:'As Good as It Gets', released:1997, tagline:'A comedy from the heart that goes for the throat.'})\n",
    "    CREATE (HelenH:Person:Test {name:'Helen Hunt', born:1963})\n",
    "    CREATE (GregK:Person:Test {name:'Greg Kinnear', born:1963})\n",
    "    CREATE (JamesB:Person:Test {name:'James L. Brooks', born:1940})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Melvin Udall']}]->(AsGoodAsItGets),\n",
    "    (HelenH)-[:ACTED_IN {roles:['Carol Connelly']}]->(AsGoodAsItGets),\n",
    "    (GregK)-[:ACTED_IN {roles:['Simon Bishop']}]->(AsGoodAsItGets),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Frank Sachs']}]->(AsGoodAsItGets),\n",
    "    (JamesB)-[:DIRECTED]->(AsGoodAsItGets)\n",
    "\n",
    "    CREATE (WhatDreamsMayCome:Movie:Test {title:'What Dreams May Come', released:1998, tagline:'After life there is more. The end is just the beginning.'})\n",
    "    CREATE (AnnabellaS:Person:Test {name:'Annabella Sciorra', born:1960})\n",
    "    CREATE (MaxS:Person:Test {name:'Max von Sydow', born:1929})\n",
    "    CREATE (WernerH:Person:Test {name:'Werner Herzog', born:1942})\n",
    "    CREATE (Robin:Person:Test {name:'Robin Williams', born:1951})\n",
    "    CREATE (VincentW:Person:Test {name:'Vincent Ward', born:1956})\n",
    "    CREATE\n",
    "    (Robin)-[:ACTED_IN {roles:['Chris Nielsen']}]->(WhatDreamsMayCome),\n",
    "    (CubaG)-[:ACTED_IN {roles:['Albert Lewis']}]->(WhatDreamsMayCome),\n",
    "    (AnnabellaS)-[:ACTED_IN {roles:['Annie Collins-Nielsen']}]->(WhatDreamsMayCome),\n",
    "    (MaxS)-[:ACTED_IN {roles:['The Tracker']}]->(WhatDreamsMayCome),\n",
    "    (WernerH)-[:ACTED_IN {roles:['The Face']}]->(WhatDreamsMayCome),\n",
    "    (VincentW)-[:DIRECTED]->(WhatDreamsMayCome)\n",
    "\n",
    "    CREATE (SnowFallingonCedars:Movie:Test {title:'Snow Falling on Cedars', released:1999, tagline:'First loves last. Forever.'})\n",
    "    CREATE (EthanH:Person:Test {name:'Ethan Hawke', born:1970})\n",
    "    CREATE (RickY:Person:Test {name:'Rick Yune', born:1971})\n",
    "    CREATE (JamesC:Person:Test {name:'James Cromwell', born:1940})\n",
    "    CREATE (ScottH:Person:Test {name:'Scott Hicks', born:1953})\n",
    "    CREATE\n",
    "    (EthanH)-[:ACTED_IN {roles:['Ishmael Chambers']}]->(SnowFallingonCedars),\n",
    "    (RickY)-[:ACTED_IN {roles:['Kazuo Miyamoto']}]->(SnowFallingonCedars),\n",
    "    (MaxS)-[:ACTED_IN {roles:['Nels Gudmundsson']}]->(SnowFallingonCedars),\n",
    "    (JamesC)-[:ACTED_IN {roles:['Judge Fielding']}]->(SnowFallingonCedars),\n",
    "    (ScottH)-[:DIRECTED]->(SnowFallingonCedars)\n",
    "\n",
    "    CREATE (YouveGotMail:Movie:Test {title:\"You've Got Mail\", released:1998, tagline:'At odds in life... in love on-line.'})\n",
    "    CREATE (ParkerP:Person:Test {name:'Parker Posey', born:1968})\n",
    "    CREATE (DaveC:Person:Test {name:'Dave Chappelle', born:1973})\n",
    "    CREATE (SteveZ:Person:Test {name:'Steve Zahn', born:1967})\n",
    "    CREATE (TomH:Person:Test {name:'Tom Hanks', born:1956})\n",
    "    CREATE (NoraE:Person:Test {name:'Nora Ephron', born:1941})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Joe Fox']}]->(YouveGotMail),\n",
    "    (MegR)-[:ACTED_IN {roles:['Kathleen Kelly']}]->(YouveGotMail),\n",
    "    (GregK)-[:ACTED_IN {roles:['Frank Navasky']}]->(YouveGotMail),\n",
    "    (ParkerP)-[:ACTED_IN {roles:['Patricia Eden']}]->(YouveGotMail),\n",
    "    (DaveC)-[:ACTED_IN {roles:['Kevin Jackson']}]->(YouveGotMail),\n",
    "    (SteveZ)-[:ACTED_IN {roles:['George Pappas']}]->(YouveGotMail),\n",
    "    (NoraE)-[:DIRECTED]->(YouveGotMail)\n",
    "\n",
    "    CREATE (SleeplessInSeattle:Movie:Test {title:'Sleepless in Seattle', released:1993, tagline:'What if someone you never met, someone you never saw, someone you never knew was the only someone for you?'})\n",
    "    CREATE (RitaW:Person:Test {name:'Rita Wilson', born:1956})\n",
    "    CREATE (BillPull:Person:Test {name:'Bill Pullman', born:1953})\n",
    "    CREATE (VictorG:Person:Test {name:'Victor Garber', born:1949})\n",
    "    CREATE (RosieO:Person:Test {name:\"Rosie O'Donnell\", born:1962})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Sam Baldwin']}]->(SleeplessInSeattle),\n",
    "    (MegR)-[:ACTED_IN {roles:['Annie Reed']}]->(SleeplessInSeattle),\n",
    "    (RitaW)-[:ACTED_IN {roles:['Suzy']}]->(SleeplessInSeattle),\n",
    "    (BillPull)-[:ACTED_IN {roles:['Walter']}]->(SleeplessInSeattle),\n",
    "    (VictorG)-[:ACTED_IN {roles:['Greg']}]->(SleeplessInSeattle),\n",
    "    (RosieO)-[:ACTED_IN {roles:['Becky']}]->(SleeplessInSeattle),\n",
    "    (NoraE)-[:DIRECTED]->(SleeplessInSeattle)\n",
    "\n",
    "    CREATE (JoeVersustheVolcano:Movie:Test {title:'Joe Versus the Volcano', released:1990, tagline:'A story of love, lava and burning desire.'})\n",
    "    CREATE (JohnS:Person:Test {name:'John Patrick Stanley', born:1950})\n",
    "    CREATE (Nathan:Person:Test {name:'Nathan Lane', born:1956})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Joe Banks']}]->(JoeVersustheVolcano),\n",
    "    (MegR)-[:ACTED_IN {roles:['DeDe', 'Angelica Graynamore', 'Patricia Graynamore']}]->(JoeVersustheVolcano),\n",
    "    (Nathan)-[:ACTED_IN {roles:['Baw']}]->(JoeVersustheVolcano),\n",
    "    (JohnS)-[:DIRECTED]->(JoeVersustheVolcano)\n",
    "\n",
    "    CREATE (WhenHarryMetSally:Movie:Test {title:'When Harry Met Sally', released:1998, tagline:'Can two friends sleep together and still love each other in the morning?'})\n",
    "    CREATE (BillyC:Person:Test {name:'Billy Crystal', born:1948})\n",
    "    CREATE (CarrieF:Person:Test {name:'Carrie Fisher', born:1956})\n",
    "    CREATE (BrunoK:Person:Test {name:'Bruno Kirby', born:1949})\n",
    "    CREATE\n",
    "    (BillyC)-[:ACTED_IN {roles:['Harry Burns']}]->(WhenHarryMetSally),\n",
    "    (MegR)-[:ACTED_IN {roles:['Sally Albright']}]->(WhenHarryMetSally),\n",
    "    (CarrieF)-[:ACTED_IN {roles:['Marie']}]->(WhenHarryMetSally),\n",
    "    (BrunoK)-[:ACTED_IN {roles:['Jess']}]->(WhenHarryMetSally),\n",
    "    (RobR)-[:DIRECTED]->(WhenHarryMetSally),\n",
    "    (RobR)-[:PRODUCED]->(WhenHarryMetSally),\n",
    "    (NoraE)-[:PRODUCED]->(WhenHarryMetSally),\n",
    "    (NoraE)-[:WROTE]->(WhenHarryMetSally)\n",
    "\n",
    "    CREATE (ThatThingYouDo:Movie:Test {title:'That Thing You Do', released:1996, tagline:'In every life there comes a time when that thing you dream becomes that thing you do'})\n",
    "    CREATE (LivT:Person:Test {name:'Liv Tyler', born:1977})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Mr. White']}]->(ThatThingYouDo),\n",
    "    (LivT)-[:ACTED_IN {roles:['Faye Dolan']}]->(ThatThingYouDo),\n",
    "    (Charlize)-[:ACTED_IN {roles:['Tina']}]->(ThatThingYouDo),\n",
    "    (TomH)-[:DIRECTED]->(ThatThingYouDo)\n",
    "\n",
    "    CREATE (TheReplacements:Movie:Test {title:'The Replacements', released:2000, tagline:'Pain heals, Chicks dig scars... Glory lasts forever'})\n",
    "    CREATE (Brooke:Person:Test {name:'Brooke Langton', born:1970})\n",
    "    CREATE (Gene:Person:Test {name:'Gene Hackman', born:1930})\n",
    "    CREATE (Orlando:Person:Test {name:'Orlando Jones', born:1968})\n",
    "    CREATE (Howard:Person:Test {name:'Howard Deutch', born:1950})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Shane Falco']}]->(TheReplacements),\n",
    "    (Brooke)-[:ACTED_IN {roles:['Annabelle Farrell']}]->(TheReplacements),\n",
    "    (Gene)-[:ACTED_IN {roles:['Jimmy McGinty']}]->(TheReplacements),\n",
    "    (Orlando)-[:ACTED_IN {roles:['Clifford Franklin']}]->(TheReplacements),\n",
    "    (Howard)-[:DIRECTED]->(TheReplacements)\n",
    "\n",
    "    CREATE (RescueDawn:Movie:Test {title:'RescueDawn', released:2006, tagline:\"Based on the extraordinary true story of one man's fight for freedom\"})\n",
    "    CREATE (ChristianB:Person:Test {name:'Christian Bale', born:1974})\n",
    "    CREATE (ZachG:Person:Test {name:'Zach Grenier', born:1954})\n",
    "    CREATE\n",
    "    (MarshallB)-[:ACTED_IN {roles:['Admiral']}]->(RescueDawn),\n",
    "    (ChristianB)-[:ACTED_IN {roles:['Dieter Dengler']}]->(RescueDawn),\n",
    "    (ZachG)-[:ACTED_IN {roles:['Squad Leader']}]->(RescueDawn),\n",
    "    (SteveZ)-[:ACTED_IN {roles:['Duane']}]->(RescueDawn),\n",
    "    (WernerH)-[:DIRECTED]->(RescueDawn)\n",
    "\n",
    "    CREATE (TheBirdcage:Movie:Test {title:'The Birdcage', released:1996, tagline:'Come as you are'})\n",
    "    CREATE (MikeN:Person:Test {name:'Mike Nichols', born:1931})\n",
    "    CREATE\n",
    "    (Robin)-[:ACTED_IN {roles:['Armand Goldman']}]->(TheBirdcage),\n",
    "    (Nathan)-[:ACTED_IN {roles:['Albert Goldman']}]->(TheBirdcage),\n",
    "    (Gene)-[:ACTED_IN {roles:['Sen. Kevin Keeley']}]->(TheBirdcage),\n",
    "    (MikeN)-[:DIRECTED]->(TheBirdcage)\n",
    "\n",
    "    CREATE (Unforgiven:Movie:Test {title:'Unforgiven', released:1992, tagline:\"It's a hell of a thing, killing a man\"})\n",
    "    CREATE (RichardH:Person:Test {name:'Richard Harris', born:1930})\n",
    "    CREATE (ClintE:Person:Test {name:'Clint Eastwood', born:1930})\n",
    "    CREATE\n",
    "    (RichardH)-[:ACTED_IN {roles:['English Bob']}]->(Unforgiven),\n",
    "    (ClintE)-[:ACTED_IN {roles:['Bill Munny']}]->(Unforgiven),\n",
    "    (Gene)-[:ACTED_IN {roles:['Little Bill Daggett']}]->(Unforgiven),\n",
    "    (ClintE)-[:DIRECTED]->(Unforgiven)\n",
    "\n",
    "    CREATE (JohnnyMnemonic:Movie:Test {title:'Johnny Mnemonic', released:1995, tagline:'The hottest data on earth. In the coolest head in town'})\n",
    "    CREATE (Takeshi:Person:Test {name:'Takeshi Kitano', born:1947})\n",
    "    CREATE (Dina:Person:Test {name:'Dina Meyer', born:1968})\n",
    "    CREATE (IceT:Person:Test {name:'Ice-T', born:1958})\n",
    "    CREATE (RobertL:Person:Test {name:'Robert Longo', born:1953})\n",
    "    CREATE\n",
    "    (Keanu)-[:ACTED_IN {roles:['Johnny Mnemonic']}]->(JohnnyMnemonic),\n",
    "    (Takeshi)-[:ACTED_IN {roles:['Takahashi']}]->(JohnnyMnemonic),\n",
    "    (Dina)-[:ACTED_IN {roles:['Jane']}]->(JohnnyMnemonic),\n",
    "    (IceT)-[:ACTED_IN {roles:['J-Bone']}]->(JohnnyMnemonic),\n",
    "    (RobertL)-[:DIRECTED]->(JohnnyMnemonic)\n",
    "\n",
    "    CREATE (CloudAtlas:Movie:Test {title:'Cloud Atlas', released:2012, tagline:'Everything is connected'})\n",
    "    CREATE (HalleB:Person:Test {name:'Halle Berry', born:1966})\n",
    "    CREATE (JimB:Person:Test {name:'Jim Broadbent', born:1949})\n",
    "    CREATE (TomT:Person:Test {name:'Tom Tykwer', born:1965})\n",
    "    CREATE (DavidMitchell:Person:Test {name:'David Mitchell', born:1969})\n",
    "    CREATE (StefanArndt:Person:Test {name:'Stefan Arndt', born:1961})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Zachry', 'Dr. Henry Goose', 'Isaac Sachs', 'Dermot Hoggins']}]->(CloudAtlas),\n",
    "    (Hugo)-[:ACTED_IN {roles:['Bill Smoke', 'Haskell Moore', 'Tadeusz Kesselring', 'Nurse Noakes', 'Boardman Mephi', 'Old Georgie']}]->(CloudAtlas),\n",
    "    (HalleB)-[:ACTED_IN {roles:['Luisa Rey', 'Jocasta Ayrs', 'Ovid', 'Meronym']}]->(CloudAtlas),\n",
    "    (JimB)-[:ACTED_IN {roles:['Vyvyan Ayrs', 'Captain Molyneux', 'Timothy Cavendish']}]->(CloudAtlas),\n",
    "    (TomT)-[:DIRECTED]->(CloudAtlas),\n",
    "    (LillyW)-[:DIRECTED]->(CloudAtlas),\n",
    "    (LanaW)-[:DIRECTED]->(CloudAtlas),\n",
    "    (DavidMitchell)-[:WROTE]->(CloudAtlas),\n",
    "    (StefanArndt)-[:PRODUCED]->(CloudAtlas)\n",
    "\n",
    "    CREATE (TheDaVinciCode:Movie:Test {title:'The Da Vinci Code', released:2006, tagline:'Break The Codes'})\n",
    "    CREATE (IanM:Person:Test {name:'Ian McKellen', born:1939})\n",
    "    CREATE (AudreyT:Person:Test {name:'Audrey Tautou', born:1976})\n",
    "    CREATE (PaulB:Person:Test {name:'Paul Bettany', born:1971})\n",
    "    CREATE (RonH:Person:Test {name:'Ron Howard', born:1954})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Dr. Robert Langdon']}]->(TheDaVinciCode),\n",
    "    (IanM)-[:ACTED_IN {roles:['Sir Leight Teabing']}]->(TheDaVinciCode),\n",
    "    (AudreyT)-[:ACTED_IN {roles:['Sophie Neveu']}]->(TheDaVinciCode),\n",
    "    (PaulB)-[:ACTED_IN {roles:['Silas']}]->(TheDaVinciCode),\n",
    "    (RonH)-[:DIRECTED]->(TheDaVinciCode)\n",
    "\n",
    "    CREATE (VforVendetta:Movie:Test {title:'V for Vendetta', released:2006, tagline:'Freedom! Forever!'})\n",
    "    CREATE (NatalieP:Person:Test {name:'Natalie Portman', born:1981})\n",
    "    CREATE (StephenR:Person:Test {name:'Stephen Rea', born:1946})\n",
    "    CREATE (JohnH:Person:Test {name:'John Hurt', born:1940})\n",
    "    CREATE (BenM:Person:Test {name: 'Ben Miles', born:1967})\n",
    "    CREATE\n",
    "    (Hugo)-[:ACTED_IN {roles:['V']}]->(VforVendetta),\n",
    "    (NatalieP)-[:ACTED_IN {roles:['Evey Hammond']}]->(VforVendetta),\n",
    "    (StephenR)-[:ACTED_IN {roles:['Eric Finch']}]->(VforVendetta),\n",
    "    (JohnH)-[:ACTED_IN {roles:['High Chancellor Adam Sutler']}]->(VforVendetta),\n",
    "    (BenM)-[:ACTED_IN {roles:['Dascomb']}]->(VforVendetta),\n",
    "    (JamesM)-[:DIRECTED]->(VforVendetta),\n",
    "    (LillyW)-[:PRODUCED]->(VforVendetta),\n",
    "    (LanaW)-[:PRODUCED]->(VforVendetta),\n",
    "    (JoelS)-[:PRODUCED]->(VforVendetta),\n",
    "    (LillyW)-[:WROTE]->(VforVendetta),\n",
    "    (LanaW)-[:WROTE]->(VforVendetta)\n",
    "\n",
    "    CREATE (SpeedRacer:Movie:Test {title:'Speed Racer', released:2008, tagline:'Speed has no limits'})\n",
    "    CREATE (EmileH:Person:Test {name:'Emile Hirsch', born:1985})\n",
    "    CREATE (JohnG:Person:Test {name:'John Goodman', born:1960})\n",
    "    CREATE (SusanS:Person:Test {name:'Susan Sarandon', born:1946})\n",
    "    CREATE (MatthewF:Person:Test {name:'Matthew Fox', born:1966})\n",
    "    CREATE (ChristinaR:Person:Test {name:'Christina Ricci', born:1980})\n",
    "    CREATE (Rain:Person:Test {name:'Rain', born:1982})\n",
    "    CREATE\n",
    "    (EmileH)-[:ACTED_IN {roles:['Speed Racer']}]->(SpeedRacer),\n",
    "    (JohnG)-[:ACTED_IN {roles:['Pops']}]->(SpeedRacer),\n",
    "    (SusanS)-[:ACTED_IN {roles:['Mom']}]->(SpeedRacer),\n",
    "    (MatthewF)-[:ACTED_IN {roles:['Racer X']}]->(SpeedRacer),\n",
    "    (ChristinaR)-[:ACTED_IN {roles:['Trixie']}]->(SpeedRacer),\n",
    "    (Rain)-[:ACTED_IN {roles:['Taejo Togokahn']}]->(SpeedRacer),\n",
    "    (BenM)-[:ACTED_IN {roles:['Cass Jones']}]->(SpeedRacer),\n",
    "    (LillyW)-[:DIRECTED]->(SpeedRacer),\n",
    "    (LanaW)-[:DIRECTED]->(SpeedRacer),\n",
    "    (LillyW)-[:WROTE]->(SpeedRacer),\n",
    "    (LanaW)-[:WROTE]->(SpeedRacer),\n",
    "    (JoelS)-[:PRODUCED]->(SpeedRacer)\n",
    "\n",
    "    CREATE (NinjaAssassin:Movie:Test {title:'Ninja Assassin', released:2009, tagline:'Prepare to enter a secret world of assassins'})\n",
    "    CREATE (NaomieH:Person:Test {name:'Naomie Harris'})\n",
    "    CREATE\n",
    "    (Rain)-[:ACTED_IN {roles:['Raizo']}]->(NinjaAssassin),\n",
    "    (NaomieH)-[:ACTED_IN {roles:['Mika Coretti']}]->(NinjaAssassin),\n",
    "    (RickY)-[:ACTED_IN {roles:['Takeshi']}]->(NinjaAssassin),\n",
    "    (BenM)-[:ACTED_IN {roles:['Ryan Maslow']}]->(NinjaAssassin),\n",
    "    (JamesM)-[:DIRECTED]->(NinjaAssassin),\n",
    "    (LillyW)-[:PRODUCED]->(NinjaAssassin),\n",
    "    (LanaW)-[:PRODUCED]->(NinjaAssassin),\n",
    "    (JoelS)-[:PRODUCED]->(NinjaAssassin)\n",
    "\n",
    "    CREATE (TheGreenMile:Movie:Test {title:'The Green Mile', released:1999, tagline:\"Walk a mile you'll never forget.\"})\n",
    "    CREATE (MichaelD:Person:Test {name:'Michael Clarke Duncan', born:1957})\n",
    "    CREATE (DavidM:Person:Test {name:'David Morse', born:1953})\n",
    "    CREATE (SamR:Person {name:'Sam Rockwell', born:1968})\n",
    "    CREATE (GaryS:Person {name:'Gary Sinise', born:1955})\n",
    "    CREATE (PatriciaC:Person {name:'Patricia Clarkson', born:1959})\n",
    "    CREATE (FrankD:Person {name:'Frank Darabont', born:1959})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Paul Edgecomb']}]->(TheGreenMile),\n",
    "    (MichaelD)-[:ACTED_IN {roles:['John Coffey']}]->(TheGreenMile),\n",
    "    (DavidM)-[:ACTED_IN {roles:['Brutus \"Brutal\" Howell']}]->(TheGreenMile),\n",
    "    (BonnieH)-[:ACTED_IN {roles:['Jan Edgecomb']}]->(TheGreenMile),\n",
    "    (JamesC)-[:ACTED_IN {roles:['Warden Hal Moores']}]->(TheGreenMile),\n",
    "    (SamR)-[:ACTED_IN {roles:['\"Wild Bill\" Wharton']}]->(TheGreenMile),\n",
    "    (GaryS)-[:ACTED_IN {roles:['Burt Hammersmith']}]->(TheGreenMile),\n",
    "    (PatriciaC)-[:ACTED_IN {roles:['Melinda Moores']}]->(TheGreenMile),\n",
    "    (FrankD)-[:DIRECTED]->(TheGreenMile)\n",
    "\n",
    "    CREATE (FrostNixon:Movie:Test {title:'Frost/Nixon', released:2008, tagline:'400 million people were waiting for the truth.'})\n",
    "    CREATE (FrankL:Person {name:'Frank Langella', born:1938})\n",
    "    CREATE (MichaelS:Person {name:'Michael Sheen', born:1969})\n",
    "    CREATE (OliverP:Person {name:'Oliver Platt', born:1960})\n",
    "    CREATE\n",
    "    (FrankL)-[:ACTED_IN {roles:['Richard Nixon']}]->(FrostNixon),\n",
    "    (MichaelS)-[:ACTED_IN {roles:['David Frost']}]->(FrostNixon),\n",
    "    (KevinB)-[:ACTED_IN {roles:['Jack Brennan']}]->(FrostNixon),\n",
    "    (OliverP)-[:ACTED_IN {roles:['Bob Zelnick']}]->(FrostNixon),\n",
    "    (SamR)-[:ACTED_IN {roles:['James Reston, Jr.']}]->(FrostNixon),\n",
    "    (RonH)-[:DIRECTED]->(FrostNixon)\n",
    "\n",
    "    CREATE (Hoffa:Movie:Test {title:'Hoffa', released:1992, tagline:\"He didn't want law. He wanted justice.\"})\n",
    "    CREATE (DannyD:Person {name:'Danny DeVito', born:1944})\n",
    "    CREATE (JohnR:Person {name:'John C. Reilly', born:1965})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Hoffa']}]->(Hoffa),\n",
    "    (DannyD)-[:ACTED_IN {roles:['Robert \"Bobby\" Ciaro']}]->(Hoffa),\n",
    "    (JTW)-[:ACTED_IN {roles:['Frank Fitzsimmons']}]->(Hoffa),\n",
    "    (JohnR)-[:ACTED_IN {roles:['Peter \"Pete\" Connelly']}]->(Hoffa),\n",
    "    (DannyD)-[:DIRECTED]->(Hoffa)\n",
    "\n",
    "    CREATE (Apollo13:Movie:Test {title:'Apollo 13', released:1995, tagline:'Houston, we have a problem.'})\n",
    "    CREATE (EdH:Person {name:'Ed Harris', born:1950})\n",
    "    CREATE (BillPax:Person {name:'Bill Paxton', born:1955})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Jim Lovell']}]->(Apollo13),\n",
    "    (KevinB)-[:ACTED_IN {roles:['Jack Swigert']}]->(Apollo13),\n",
    "    (EdH)-[:ACTED_IN {roles:['Gene Kranz']}]->(Apollo13),\n",
    "    (BillPax)-[:ACTED_IN {roles:['Fred Haise']}]->(Apollo13),\n",
    "    (GaryS)-[:ACTED_IN {roles:['Ken Mattingly']}]->(Apollo13),\n",
    "    (RonH)-[:DIRECTED]->(Apollo13)\n",
    "\n",
    "    CREATE (Twister:Movie:Test {title:'Twister', released:1996, tagline:\"Don't Breathe. Don't Look Back.\"})\n",
    "    CREATE (PhilipH:Person {name:'Philip Seymour Hoffman', born:1967})\n",
    "    CREATE (JanB:Person {name:'Jan de Bont', born:1943})\n",
    "    CREATE\n",
    "    (BillPax)-[:ACTED_IN {roles:['Bill Harding']}]->(Twister),\n",
    "    (HelenH)-[:ACTED_IN {roles:['Dr. Jo Harding']}]->(Twister),\n",
    "    (ZachG)-[:ACTED_IN {roles:['Eddie']}]->(Twister),\n",
    "    (PhilipH)-[:ACTED_IN {roles:['Dustin \"Dusty\" Davis']}]->(Twister),\n",
    "    (JanB)-[:DIRECTED]->(Twister)\n",
    "\n",
    "    CREATE (CastAway:Movie:Test {title:'Cast Away', released:2000, tagline:'At the edge of the world, his journey begins.'})\n",
    "    CREATE (RobertZ:Person {name:'Robert Zemeckis', born:1951})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Chuck Noland']}]->(CastAway),\n",
    "    (HelenH)-[:ACTED_IN {roles:['Kelly Frears']}]->(CastAway),\n",
    "    (RobertZ)-[:DIRECTED]->(CastAway)\n",
    "\n",
    "    CREATE (OneFlewOvertheCuckoosNest:Movie:Test {title:\"One Flew Over the Cuckoo's Nest\", released:1975, tagline:\"If he's crazy, what does that make you?\"})\n",
    "    CREATE (MilosF:Person {name:'Milos Forman', born:1932})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Randle McMurphy']}]->(OneFlewOvertheCuckoosNest),\n",
    "    (DannyD)-[:ACTED_IN {roles:['Martini']}]->(OneFlewOvertheCuckoosNest),\n",
    "    (MilosF)-[:DIRECTED]->(OneFlewOvertheCuckoosNest)\n",
    "\n",
    "    CREATE (SomethingsGottaGive:Movie:Test {title:\"Something's Gotta Give\", released:2003})\n",
    "    CREATE (DianeK:Person {name:'Diane Keaton', born:1946})\n",
    "    CREATE (NancyM:Person {name:'Nancy Meyers', born:1949})\n",
    "    CREATE\n",
    "    (JackN)-[:ACTED_IN {roles:['Harry Sanborn']}]->(SomethingsGottaGive),\n",
    "    (DianeK)-[:ACTED_IN {roles:['Erica Barry']}]->(SomethingsGottaGive),\n",
    "    (Keanu)-[:ACTED_IN {roles:['Julian Mercer']}]->(SomethingsGottaGive),\n",
    "    (NancyM)-[:DIRECTED]->(SomethingsGottaGive),\n",
    "    (NancyM)-[:PRODUCED]->(SomethingsGottaGive),\n",
    "    (NancyM)-[:WROTE]->(SomethingsGottaGive)\n",
    "\n",
    "    CREATE (BicentennialMan:Movie:Test {title:'Bicentennial Man', released:1999, tagline:\"One robot's 200 year journey to become an ordinary man.\"})\n",
    "    CREATE (ChrisC:Person {name:'Chris Columbus', born:1958})\n",
    "    CREATE\n",
    "    (Robin)-[:ACTED_IN {roles:['Andrew Marin']}]->(BicentennialMan),\n",
    "    (OliverP)-[:ACTED_IN {roles:['Rupert Burns']}]->(BicentennialMan),\n",
    "    (ChrisC)-[:DIRECTED]->(BicentennialMan)\n",
    "\n",
    "    CREATE (CharlieWilsonsWar:Movie:Test {title:\"Charlie Wilson's War\", released:2007, tagline:\"A stiff drink. A little mascara. A lot of nerve. Who said they couldn't bring down the Soviet empire.\"})\n",
    "    CREATE (JuliaR:Person {name:'Julia Roberts', born:1967})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Rep. Charlie Wilson']}]->(CharlieWilsonsWar),\n",
    "    (JuliaR)-[:ACTED_IN {roles:['Joanne Herring']}]->(CharlieWilsonsWar),\n",
    "    (PhilipH)-[:ACTED_IN {roles:['Gust Avrakotos']}]->(CharlieWilsonsWar),\n",
    "    (MikeN)-[:DIRECTED]->(CharlieWilsonsWar)\n",
    "\n",
    "    CREATE (ThePolarExpress:Movie:Test {title:'The Polar Express', released:2004, tagline:'This Holiday Season... Believe'})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Hero Boy', 'Father', 'Conductor', 'Hobo', 'Scrooge', 'Santa Claus']}]->(ThePolarExpress),\n",
    "    (RobertZ)-[:DIRECTED]->(ThePolarExpress)\n",
    "\n",
    "    CREATE (ALeagueofTheirOwn:Movie:Test {title:'A League of Their Own', released:1992, tagline:'Once in a lifetime you get a chance to do something different.'})\n",
    "    CREATE (Madonna:Person {name:'Madonna', born:1954})\n",
    "    CREATE (GeenaD:Person {name:'Geena Davis', born:1956})\n",
    "    CREATE (LoriP:Person {name:'Lori Petty', born:1963})\n",
    "    CREATE (PennyM:Person {name:'Penny Marshall', born:1943})\n",
    "    CREATE\n",
    "    (TomH)-[:ACTED_IN {roles:['Jimmy Dugan']}]->(ALeagueofTheirOwn),\n",
    "    (GeenaD)-[:ACTED_IN {roles:['Dottie Hinson']}]->(ALeagueofTheirOwn),\n",
    "    (LoriP)-[:ACTED_IN {roles:['Kit Keller']}]->(ALeagueofTheirOwn),\n",
    "    (RosieO)-[:ACTED_IN {roles:['Doris Murphy']}]->(ALeagueofTheirOwn),\n",
    "    (Madonna)-[:ACTED_IN {roles:['\"All the Way\" Mae Mordabito']}]->(ALeagueofTheirOwn),\n",
    "    (BillPax)-[:ACTED_IN {roles:['Bob Hinson']}]->(ALeagueofTheirOwn),\n",
    "    (PennyM)-[:DIRECTED]->(ALeagueofTheirOwn)\n",
    "\n",
    "    CREATE (PaulBlythe:Person {name:'Paul Blythe'})\n",
    "    CREATE (AngelaScope:Person {name:'Angela Scope'})\n",
    "    CREATE (JessicaThompson:Person {name:'Jessica Thompson'})\n",
    "    CREATE (JamesThompson:Person {name:'James Thompson'})\n",
    "\n",
    "    CREATE\n",
    "    (JamesThompson)-[:FOLLOWS]->(JessicaThompson),\n",
    "    (AngelaScope)-[:FOLLOWS]->(JessicaThompson),\n",
    "    (PaulBlythe)-[:FOLLOWS]->(AngelaScope)\n",
    "\n",
    "    CREATE\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'An amazing journey', rating:95}]->(CloudAtlas),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'Silly, but fun', rating:65}]->(TheReplacements),\n",
    "    (JamesThompson)-[:REVIEWED {summary:'The coolest football movie ever', rating:100}]->(TheReplacements),\n",
    "    (AngelaScope)-[:REVIEWED {summary:'Pretty funny at times', rating:62}]->(TheReplacements),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'Dark, but compelling', rating:85}]->(Unforgiven),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:\"Slapstick redeemed only by the Robin Williams and Gene Hackman's stellar performances\", rating:45}]->(TheBirdcage),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'A solid romp', rating:68}]->(TheDaVinciCode),\n",
    "    (JamesThompson)-[:REVIEWED {summary:'Fun, but a little far fetched', rating:65}]->(TheDaVinciCode),\n",
    "    (JessicaThompson)-[:REVIEWED {summary:'You had me at Jerry', rating:92}]->(JerryMaguire)\n",
    "    \"\"\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "nodeQuery                    MATCH (p:Person:Train) return id(p) as id\n",
       "relationshipQuery    MATCH (p1:Person:Train)-->()<--(p2:Person:Trai...\n",
       "graphName                                                        train\n",
       "nodeCount                                                          106\n",
       "relationshipCount                                                 1326\n",
       "projectMillis                                                       14\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "G_train, project_stats = gds.graph.project.cypher(\n",
    "    'train',\n",
    "    \"\"\"\n",
    "        MATCH (p:Person:Train) return id(p) as id\n",
    "    \"\"\",\n",
    "    \"\"\"\n",
    "        MATCH (p1:Person:Train)-->()<--(p2:Person:Train)\n",
    "        RETURN id(p1) as target, id(p2) as source\n",
    "     \"\"\",\n",
    "    readConcurrency=4\n",
    ")\n",
    "project_stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "graphName                                                        train\n",
       "database                                                       movies2\n",
       "memoryUsage                                                           \n",
       "sizeInBytes                                                         -1\n",
       "nodeCount                                                          106\n",
       "relationshipCount                                                 1326\n",
       "configuration        {'relationshipQuery': 'MATCH (p1:Person:Train)...\n",
       "density                                                       0.119137\n",
       "creationTime                       2022-08-18T17:42:24.473934000+02:00\n",
       "modificationTime                   2022-08-18T17:42:24.515614000+02:00\n",
       "schema               {'graphProperties': {}, 'relationships': {'__A...\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "G_train.drop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.13 ('notebooks')",
   "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.9.16"
  },
  "vscode": {
   "interpreter": {
    "hash": "c68434ca16130d73e64183f54aeda16ecffce872c062f16976fd0d983519d848"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}