pandas_regex_basic.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# pandas: basic regular expression"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "* author:  [Prasert Kanawattanachai](prasert.k@chula.ac.th)\n",
    "* YouTube: https://www.youtube.com/prasertcbs\n",
    "* [Chulalongkorn Business School](https://www.cbs.chula.ac.th/en/)\n",
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"720\"\n",
       "            height=\"405\"\n",
       "            src=\"https://www.youtube.com/embed/KTGvdg9c_qU\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.YouTubeVideo at 0x140d0b38e08>"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from IPython.display import YouTubeVideo\n",
    "YouTubeVideo('KTGvdg9c_qU', width=720, height=405)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# pd.set_option('display.max_rows', 50)\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 64
    },
    "colab_type": "code",
    "id": "fdr0pYIf7P-_",
    "outputId": "c919deae-c99b-44b0-8924-4d2355ca0b63"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "pandas version: 1.1.3\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Timestamp('2020-12-06 10:24:49.507747')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(f'pandas version: {pd.__version__}')\n",
    "\n",
    "pd.Timestamp.now()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Split</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Search Party</td>\n",
       "      <td>Adam Pally, T.J. Miller, Thomas Middleditch,Sh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "0    Guardians of the Galaxy   \n",
       "1                 Prometheus   \n",
       "2                      Split   \n",
       "3                       Sing   \n",
       "4              Suicide Squad   \n",
       "..                       ...   \n",
       "995     Secret in Their Eyes   \n",
       "996          Hostel: Part II   \n",
       "997   Step Up 2: The Streets   \n",
       "998             Search Party   \n",
       "999               Nine Lives   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "1    Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "2    James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3    Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "..                                                 ...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "998  Adam Pally, T.J. Miller, Thomas Middleditch,Sh...  \n",
       "999  Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...  \n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url='https://github.com/prasertcbs/basic-dataset/raw/master/IMDBtop1000.csv'\n",
    "df=pd.read_csv(url, usecols=['Title', 'Actors'])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Kingsman: The Secret Service</td>\n",
       "      <td>Colin Firth, Taron Egerton, Samuel L. Jackson,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Woman in Gold</td>\n",
       "      <td>Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>The Huntsman: Winter's War</td>\n",
       "      <td>Chris Hemsworth, Jessica Chastain, Charlize Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Norman: The Moderate Rise and Tragic Fall of a...</td>\n",
       "      <td>Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Birdman or (The Unexpected Virtue of Ignorance)</td>\n",
       "      <td>Michael Keaton, Zach Galifianakis,Edward Norto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>Nymphomaniac: Vol. I</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Stacy...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>Toni Erdmann</td>\n",
       "      <td>Sandra Hüller, Peter Simonischek, Michael Witt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Nymphomaniac: Vol. II</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Wille...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>En man som heter Ove</td>\n",
       "      <td>Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Superman Returns</td>\n",
       "      <td>Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>The Human Centipede (First Sequence)</td>\n",
       "      <td>Dieter Laser, Ashley C. Williams, Ashlynn Yenn...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "60                  Batman v Superman: Dawn of Justice   \n",
       "65                        Kingsman: The Secret Service   \n",
       "167                                      Woman in Gold   \n",
       "234                         The Huntsman: Winter's War   \n",
       "259  Norman: The Moderate Rise and Tragic Fall of a...   \n",
       "260    Birdman or (The Unexpected Virtue of Ignorance)   \n",
       "263                               Nymphomaniac: Vol. I   \n",
       "391                                         The Gunman   \n",
       "564                        Snow White and the Huntsman   \n",
       "570                                    The Other Woman   \n",
       "611                                       Toni Erdmann   \n",
       "720                              Nymphomaniac: Vol. II   \n",
       "870                               En man som heter Ove   \n",
       "924                                   Superman Returns   \n",
       "936               The Human Centipede (First Sequence)   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "65   Colin Firth, Taron Egerton, Samuel L. Jackson,...  \n",
       "167  Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...  \n",
       "234  Chris Hemsworth, Jessica Chastain, Charlize Th...  \n",
       "259  Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...  \n",
       "260  Michael Keaton, Zach Galifianakis,Edward Norto...  \n",
       "263  Charlotte Gainsbourg, Stellan Skarsgård, Stacy...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "611  Sandra Hüller, Peter Simonischek, Michael Witt...  \n",
       "720  Charlotte Gainsbourg, Stellan Skarsgård, Wille...  \n",
       "870  Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...  \n",
       "924  Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...  \n",
       "936  Dieter Laser, Ashley C. Williams, Ashlynn Yenn...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains('man')] # case sensitive"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manchester by the Sea</td>\n",
       "      <td>Casey Affleck, Michelle Williams, Kyle Chandle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>Johnny Depp, Orlando Bloom, Keira Knightley, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>The Man from U.N.C.L.E.</td>\n",
       "      <td>Henry Cavill, Armie Hammer, Alicia Vikander, E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>The Man Who Knew Infinity</td>\n",
       "      <td>Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Title  \\\n",
       "21                        Manchester by the Sea   \n",
       "78   Pirates of the Caribbean: Dead Man's Chest   \n",
       "104                     The Man from U.N.C.L.E.   \n",
       "179                                     Ant-Man   \n",
       "203                                    Iron Man   \n",
       "253                    The Amazing Spider-Man 2   \n",
       "279                              Iron Man Three   \n",
       "294                                Man of Steel   \n",
       "344                                Spider-Man 3   \n",
       "368                      The Amazing Spider-Man   \n",
       "378                              Swiss Army Man   \n",
       "450                                  Iron Man 2   \n",
       "593                               She's the Man   \n",
       "779                   The Man Who Knew Infinity   \n",
       "794                              Man on a Ledge   \n",
       "815                                  Inside Man   \n",
       "824                                    Man Down   \n",
       "\n",
       "                                                Actors  \n",
       "21   Casey Affleck, Michelle Williams, Kyle Chandle...  \n",
       "78   Johnny Depp, Orlando Bloom, Keira Knightley, J...  \n",
       "104  Henry Cavill, Armie Hammer, Alicia Vikander, E...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "294  Henry Cavill, Amy Adams, Michael Shannon, Dian...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "779  Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...  \n",
       "794  Sam Worthington, Elizabeth Banks, Jamie Bell, ...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  \n",
       "824  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains('Man')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manchester by the Sea</td>\n",
       "      <td>Casey Affleck, Michelle Williams, Kyle Chandle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Kingsman: The Secret Service</td>\n",
       "      <td>Colin Firth, Taron Egerton, Samuel L. Jackson,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>Johnny Depp, Orlando Bloom, Keira Knightley, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>The Man from U.N.C.L.E.</td>\n",
       "      <td>Henry Cavill, Armie Hammer, Alicia Vikander, E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Woman in Gold</td>\n",
       "      <td>Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>The Huntsman: Winter's War</td>\n",
       "      <td>Chris Hemsworth, Jessica Chastain, Charlize Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Norman: The Moderate Rise and Tragic Fall of a...</td>\n",
       "      <td>Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Birdman or (The Unexpected Virtue of Ignorance)</td>\n",
       "      <td>Michael Keaton, Zach Galifianakis,Edward Norto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>Nymphomaniac: Vol. I</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Stacy...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>Toni Erdmann</td>\n",
       "      <td>Sandra Hüller, Peter Simonischek, Michael Witt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Nymphomaniac: Vol. II</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Wille...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>The Man Who Knew Infinity</td>\n",
       "      <td>Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>En man som heter Ove</td>\n",
       "      <td>Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Superman Returns</td>\n",
       "      <td>Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>The Human Centipede (First Sequence)</td>\n",
       "      <td>Dieter Laser, Ashley C. Williams, Ashlynn Yenn...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "21                               Manchester by the Sea   \n",
       "60                  Batman v Superman: Dawn of Justice   \n",
       "65                        Kingsman: The Secret Service   \n",
       "78          Pirates of the Caribbean: Dead Man's Chest   \n",
       "104                            The Man from U.N.C.L.E.   \n",
       "167                                      Woman in Gold   \n",
       "179                                            Ant-Man   \n",
       "203                                           Iron Man   \n",
       "234                         The Huntsman: Winter's War   \n",
       "253                           The Amazing Spider-Man 2   \n",
       "259  Norman: The Moderate Rise and Tragic Fall of a...   \n",
       "260    Birdman or (The Unexpected Virtue of Ignorance)   \n",
       "263                               Nymphomaniac: Vol. I   \n",
       "279                                     Iron Man Three   \n",
       "294                                       Man of Steel   \n",
       "344                                       Spider-Man 3   \n",
       "368                             The Amazing Spider-Man   \n",
       "378                                     Swiss Army Man   \n",
       "391                                         The Gunman   \n",
       "450                                         Iron Man 2   \n",
       "564                        Snow White and the Huntsman   \n",
       "570                                    The Other Woman   \n",
       "593                                      She's the Man   \n",
       "611                                       Toni Erdmann   \n",
       "720                              Nymphomaniac: Vol. II   \n",
       "779                          The Man Who Knew Infinity   \n",
       "794                                     Man on a Ledge   \n",
       "815                                         Inside Man   \n",
       "824                                           Man Down   \n",
       "870                               En man som heter Ove   \n",
       "924                                   Superman Returns   \n",
       "936               The Human Centipede (First Sequence)   \n",
       "\n",
       "                                                Actors  \n",
       "21   Casey Affleck, Michelle Williams, Kyle Chandle...  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "65   Colin Firth, Taron Egerton, Samuel L. Jackson,...  \n",
       "78   Johnny Depp, Orlando Bloom, Keira Knightley, J...  \n",
       "104  Henry Cavill, Armie Hammer, Alicia Vikander, E...  \n",
       "167  Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "234  Chris Hemsworth, Jessica Chastain, Charlize Th...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "259  Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...  \n",
       "260  Michael Keaton, Zach Galifianakis,Edward Norto...  \n",
       "263  Charlotte Gainsbourg, Stellan Skarsgård, Stacy...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "294  Henry Cavill, Amy Adams, Michael Shannon, Dian...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "611  Sandra Hüller, Peter Simonischek, Michael Witt...  \n",
       "720  Charlotte Gainsbourg, Stellan Skarsgård, Wille...  \n",
       "779  Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...  \n",
       "794  Sam Worthington, Elizabeth Banks, Jamie Bell, ...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  \n",
       "824  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...  \n",
       "870  Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...  \n",
       "924  Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...  \n",
       "936  Dieter Laser, Ashley C. Williams, Ashlynn Yenn...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'man', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## starts with"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manchester by the Sea</td>\n",
       "      <td>Casey Affleck, Michelle Williams, Kyle Chandle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Title                                             Actors\n",
       "21   Manchester by the Sea  Casey Affleck, Michelle Williams, Kyle Chandle...\n",
       "294           Man of Steel  Henry Cavill, Amy Adams, Michael Shannon, Dian...\n",
       "794         Man on a Ledge  Sam Worthington, Elizabeth Banks, Jamie Bell, ...\n",
       "824               Man Down  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ..."
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'^man', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## ends with"
   ]
  },
  {
   "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",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Title  \\\n",
       "179                      Ant-Man   \n",
       "203                     Iron Man   \n",
       "368       The Amazing Spider-Man   \n",
       "378               Swiss Army Man   \n",
       "391                   The Gunman   \n",
       "564  Snow White and the Huntsman   \n",
       "570              The Other Woman   \n",
       "593                She's the Man   \n",
       "815                   Inside Man   \n",
       "\n",
       "                                                Actors  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'man$', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## word boundary"
   ]
  },
  {
   "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",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manchester by the Sea</td>\n",
       "      <td>Casey Affleck, Michelle Williams, Kyle Chandle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Kingsman: The Secret Service</td>\n",
       "      <td>Colin Firth, Taron Egerton, Samuel L. Jackson,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>Johnny Depp, Orlando Bloom, Keira Knightley, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>The Man from U.N.C.L.E.</td>\n",
       "      <td>Henry Cavill, Armie Hammer, Alicia Vikander, E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Woman in Gold</td>\n",
       "      <td>Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>The Huntsman: Winter's War</td>\n",
       "      <td>Chris Hemsworth, Jessica Chastain, Charlize Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Norman: The Moderate Rise and Tragic Fall of a...</td>\n",
       "      <td>Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Birdman or (The Unexpected Virtue of Ignorance)</td>\n",
       "      <td>Michael Keaton, Zach Galifianakis,Edward Norto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>Nymphomaniac: Vol. I</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Stacy...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>Toni Erdmann</td>\n",
       "      <td>Sandra Hüller, Peter Simonischek, Michael Witt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Nymphomaniac: Vol. II</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Wille...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>The Man Who Knew Infinity</td>\n",
       "      <td>Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>En man som heter Ove</td>\n",
       "      <td>Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Superman Returns</td>\n",
       "      <td>Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>The Human Centipede (First Sequence)</td>\n",
       "      <td>Dieter Laser, Ashley C. Williams, Ashlynn Yenn...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "21                               Manchester by the Sea   \n",
       "60                  Batman v Superman: Dawn of Justice   \n",
       "65                        Kingsman: The Secret Service   \n",
       "78          Pirates of the Caribbean: Dead Man's Chest   \n",
       "104                            The Man from U.N.C.L.E.   \n",
       "167                                      Woman in Gold   \n",
       "179                                            Ant-Man   \n",
       "203                                           Iron Man   \n",
       "234                         The Huntsman: Winter's War   \n",
       "253                           The Amazing Spider-Man 2   \n",
       "259  Norman: The Moderate Rise and Tragic Fall of a...   \n",
       "260    Birdman or (The Unexpected Virtue of Ignorance)   \n",
       "263                               Nymphomaniac: Vol. I   \n",
       "279                                     Iron Man Three   \n",
       "294                                       Man of Steel   \n",
       "344                                       Spider-Man 3   \n",
       "368                             The Amazing Spider-Man   \n",
       "378                                     Swiss Army Man   \n",
       "391                                         The Gunman   \n",
       "450                                         Iron Man 2   \n",
       "564                        Snow White and the Huntsman   \n",
       "570                                    The Other Woman   \n",
       "593                                      She's the Man   \n",
       "611                                       Toni Erdmann   \n",
       "720                              Nymphomaniac: Vol. II   \n",
       "779                          The Man Who Knew Infinity   \n",
       "794                                     Man on a Ledge   \n",
       "815                                         Inside Man   \n",
       "824                                           Man Down   \n",
       "870                               En man som heter Ove   \n",
       "924                                   Superman Returns   \n",
       "936               The Human Centipede (First Sequence)   \n",
       "\n",
       "                                                Actors  \n",
       "21   Casey Affleck, Michelle Williams, Kyle Chandle...  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "65   Colin Firth, Taron Egerton, Samuel L. Jackson,...  \n",
       "78   Johnny Depp, Orlando Bloom, Keira Knightley, J...  \n",
       "104  Henry Cavill, Armie Hammer, Alicia Vikander, E...  \n",
       "167  Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "234  Chris Hemsworth, Jessica Chastain, Charlize Th...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "259  Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...  \n",
       "260  Michael Keaton, Zach Galifianakis,Edward Norto...  \n",
       "263  Charlotte Gainsbourg, Stellan Skarsgård, Stacy...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "294  Henry Cavill, Amy Adams, Michael Shannon, Dian...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "611  Sandra Hüller, Peter Simonischek, Michael Witt...  \n",
       "720  Charlotte Gainsbourg, Stellan Skarsgård, Wille...  \n",
       "779  Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...  \n",
       "794  Sam Worthington, Elizabeth Banks, Jamie Bell, ...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  \n",
       "824  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...  \n",
       "870  Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...  \n",
       "924  Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...  \n",
       "936  Dieter Laser, Ashley C. Williams, Ashlynn Yenn...  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'man', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## raw string"
   ]
  },
  {
   "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",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Title, Actors]\n",
       "Index: []"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains('man\\b', case=False)] # case insenstive comparison"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Kingsman: The Secret Service</td>\n",
       "      <td>Colin Firth, Taron Egerton, Samuel L. Jackson,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>Johnny Depp, Orlando Bloom, Keira Knightley, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>The Man from U.N.C.L.E.</td>\n",
       "      <td>Henry Cavill, Armie Hammer, Alicia Vikander, E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Woman in Gold</td>\n",
       "      <td>Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>The Huntsman: Winter's War</td>\n",
       "      <td>Chris Hemsworth, Jessica Chastain, Charlize Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Norman: The Moderate Rise and Tragic Fall of a...</td>\n",
       "      <td>Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Birdman or (The Unexpected Virtue of Ignorance)</td>\n",
       "      <td>Michael Keaton, Zach Galifianakis,Edward Norto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>The Man Who Knew Infinity</td>\n",
       "      <td>Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>En man som heter Ove</td>\n",
       "      <td>Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Superman Returns</td>\n",
       "      <td>Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>The Human Centipede (First Sequence)</td>\n",
       "      <td>Dieter Laser, Ashley C. Williams, Ashlynn Yenn...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "60                  Batman v Superman: Dawn of Justice   \n",
       "65                        Kingsman: The Secret Service   \n",
       "78          Pirates of the Caribbean: Dead Man's Chest   \n",
       "104                            The Man from U.N.C.L.E.   \n",
       "167                                      Woman in Gold   \n",
       "179                                            Ant-Man   \n",
       "203                                           Iron Man   \n",
       "234                         The Huntsman: Winter's War   \n",
       "253                           The Amazing Spider-Man 2   \n",
       "259  Norman: The Moderate Rise and Tragic Fall of a...   \n",
       "260    Birdman or (The Unexpected Virtue of Ignorance)   \n",
       "279                                     Iron Man Three   \n",
       "294                                       Man of Steel   \n",
       "344                                       Spider-Man 3   \n",
       "368                             The Amazing Spider-Man   \n",
       "378                                     Swiss Army Man   \n",
       "391                                         The Gunman   \n",
       "450                                         Iron Man 2   \n",
       "564                        Snow White and the Huntsman   \n",
       "570                                    The Other Woman   \n",
       "593                                      She's the Man   \n",
       "779                          The Man Who Knew Infinity   \n",
       "794                                     Man on a Ledge   \n",
       "815                                         Inside Man   \n",
       "824                                           Man Down   \n",
       "870                               En man som heter Ove   \n",
       "924                                   Superman Returns   \n",
       "936               The Human Centipede (First Sequence)   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "65   Colin Firth, Taron Egerton, Samuel L. Jackson,...  \n",
       "78   Johnny Depp, Orlando Bloom, Keira Knightley, J...  \n",
       "104  Henry Cavill, Armie Hammer, Alicia Vikander, E...  \n",
       "167  Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "234  Chris Hemsworth, Jessica Chastain, Charlize Th...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "259  Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...  \n",
       "260  Michael Keaton, Zach Galifianakis,Edward Norto...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "294  Henry Cavill, Amy Adams, Michael Shannon, Dian...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "779  Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...  \n",
       "794  Sam Worthington, Elizabeth Banks, Jamie Bell, ...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  \n",
       "824  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...  \n",
       "870  Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...  \n",
       "924  Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...  \n",
       "936  Dieter Laser, Ashley C. Williams, Ashlynn Yenn...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains('man\\\\b', case=False)] # case insenstive comparison"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Kingsman: The Secret Service</td>\n",
       "      <td>Colin Firth, Taron Egerton, Samuel L. Jackson,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>Johnny Depp, Orlando Bloom, Keira Knightley, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>The Man from U.N.C.L.E.</td>\n",
       "      <td>Henry Cavill, Armie Hammer, Alicia Vikander, E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Woman in Gold</td>\n",
       "      <td>Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>The Huntsman: Winter's War</td>\n",
       "      <td>Chris Hemsworth, Jessica Chastain, Charlize Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Norman: The Moderate Rise and Tragic Fall of a...</td>\n",
       "      <td>Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Birdman or (The Unexpected Virtue of Ignorance)</td>\n",
       "      <td>Michael Keaton, Zach Galifianakis,Edward Norto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>The Man Who Knew Infinity</td>\n",
       "      <td>Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>En man som heter Ove</td>\n",
       "      <td>Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Superman Returns</td>\n",
       "      <td>Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>The Human Centipede (First Sequence)</td>\n",
       "      <td>Dieter Laser, Ashley C. Williams, Ashlynn Yenn...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "60                  Batman v Superman: Dawn of Justice   \n",
       "65                        Kingsman: The Secret Service   \n",
       "78          Pirates of the Caribbean: Dead Man's Chest   \n",
       "104                            The Man from U.N.C.L.E.   \n",
       "167                                      Woman in Gold   \n",
       "179                                            Ant-Man   \n",
       "203                                           Iron Man   \n",
       "234                         The Huntsman: Winter's War   \n",
       "253                           The Amazing Spider-Man 2   \n",
       "259  Norman: The Moderate Rise and Tragic Fall of a...   \n",
       "260    Birdman or (The Unexpected Virtue of Ignorance)   \n",
       "279                                     Iron Man Three   \n",
       "294                                       Man of Steel   \n",
       "344                                       Spider-Man 3   \n",
       "368                             The Amazing Spider-Man   \n",
       "378                                     Swiss Army Man   \n",
       "391                                         The Gunman   \n",
       "450                                         Iron Man 2   \n",
       "564                        Snow White and the Huntsman   \n",
       "570                                    The Other Woman   \n",
       "593                                      She's the Man   \n",
       "779                          The Man Who Knew Infinity   \n",
       "794                                     Man on a Ledge   \n",
       "815                                         Inside Man   \n",
       "824                                           Man Down   \n",
       "870                               En man som heter Ove   \n",
       "924                                   Superman Returns   \n",
       "936               The Human Centipede (First Sequence)   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "65   Colin Firth, Taron Egerton, Samuel L. Jackson,...  \n",
       "78   Johnny Depp, Orlando Bloom, Keira Knightley, J...  \n",
       "104  Henry Cavill, Armie Hammer, Alicia Vikander, E...  \n",
       "167  Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "234  Chris Hemsworth, Jessica Chastain, Charlize Th...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "259  Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...  \n",
       "260  Michael Keaton, Zach Galifianakis,Edward Norto...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "294  Henry Cavill, Amy Adams, Michael Shannon, Dian...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "779  Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...  \n",
       "794  Sam Worthington, Elizabeth Banks, Jamie Bell, ...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  \n",
       "824  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...  \n",
       "870  Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...  \n",
       "924  Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...  \n",
       "936  Dieter Laser, Ashley C. Williams, Ashlynn Yenn...  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'man\\b', case=False)] # case insenstive comparison"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Title                                             Actors\n",
       "179                 Ant-Man  Paul Rudd, Michael Douglas, Corey Stoll, Evang...\n",
       "203                Iron Man  Robert Downey Jr., Gwyneth Paltrow, Terrence H...\n",
       "368  The Amazing Spider-Man  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...\n",
       "378          Swiss Army Man  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...\n",
       "593           She's the Man  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...\n",
       "815              Inside Man  Denzel Washington, Clive Owen, Jodie Foster,Ch..."
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\bman$', case=False)] # r' (raw string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Manchester by the Sea</td>\n",
       "      <td>Casey Affleck, Michelle Williams, Kyle Chandle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Title                                             Actors\n",
       "21   Manchester by the Sea  Casey Affleck, Michelle Williams, Kyle Chandle...\n",
       "294           Man of Steel  Henry Cavill, Amy Adams, Michael Shannon, Dian...\n",
       "794         Man on a Ledge  Sam Worthington, Elizabeth Banks, Jamie Bell, ...\n",
       "824               Man Down  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ..."
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'^man', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Title                                             Actors\n",
       "294    Man of Steel  Henry Cavill, Amy Adams, Michael Shannon, Dian...\n",
       "794  Man on a Ledge  Sam Worthington, Elizabeth Banks, Jamie Bell, ...\n",
       "824        Man Down  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ..."
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'^man\\b', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Kingsman: The Secret Service</td>\n",
       "      <td>Colin Firth, Taron Egerton, Samuel L. Jackson,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>Johnny Depp, Orlando Bloom, Keira Knightley, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>The Man from U.N.C.L.E.</td>\n",
       "      <td>Henry Cavill, Armie Hammer, Alicia Vikander, E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Woman in Gold</td>\n",
       "      <td>Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>The Huntsman: Winter's War</td>\n",
       "      <td>Chris Hemsworth, Jessica Chastain, Charlize Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>Norman: The Moderate Rise and Tragic Fall of a...</td>\n",
       "      <td>Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>Birdman or (The Unexpected Virtue of Ignorance)</td>\n",
       "      <td>Michael Keaton, Zach Galifianakis,Edward Norto...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>The Man Who Knew Infinity</td>\n",
       "      <td>Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>En man som heter Ove</td>\n",
       "      <td>Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>Superman Returns</td>\n",
       "      <td>Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>936</th>\n",
       "      <td>The Human Centipede (First Sequence)</td>\n",
       "      <td>Dieter Laser, Ashley C. Williams, Ashlynn Yenn...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "60                  Batman v Superman: Dawn of Justice   \n",
       "65                        Kingsman: The Secret Service   \n",
       "78          Pirates of the Caribbean: Dead Man's Chest   \n",
       "104                            The Man from U.N.C.L.E.   \n",
       "167                                      Woman in Gold   \n",
       "179                                            Ant-Man   \n",
       "203                                           Iron Man   \n",
       "234                         The Huntsman: Winter's War   \n",
       "253                           The Amazing Spider-Man 2   \n",
       "259  Norman: The Moderate Rise and Tragic Fall of a...   \n",
       "260    Birdman or (The Unexpected Virtue of Ignorance)   \n",
       "279                                     Iron Man Three   \n",
       "294                                       Man of Steel   \n",
       "344                                       Spider-Man 3   \n",
       "368                             The Amazing Spider-Man   \n",
       "378                                     Swiss Army Man   \n",
       "391                                         The Gunman   \n",
       "450                                         Iron Man 2   \n",
       "564                        Snow White and the Huntsman   \n",
       "570                                    The Other Woman   \n",
       "593                                      She's the Man   \n",
       "779                          The Man Who Knew Infinity   \n",
       "794                                     Man on a Ledge   \n",
       "815                                         Inside Man   \n",
       "824                                           Man Down   \n",
       "870                               En man som heter Ove   \n",
       "924                                   Superman Returns   \n",
       "936               The Human Centipede (First Sequence)   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "65   Colin Firth, Taron Egerton, Samuel L. Jackson,...  \n",
       "78   Johnny Depp, Orlando Bloom, Keira Knightley, J...  \n",
       "104  Henry Cavill, Armie Hammer, Alicia Vikander, E...  \n",
       "167  Helen Mirren, Ryan Reynolds, Daniel Brühl, Kat...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "234  Chris Hemsworth, Jessica Chastain, Charlize Th...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "259  Richard Gere, Lior Ashkenazi, Michael Sheen,Ch...  \n",
       "260  Michael Keaton, Zach Galifianakis,Edward Norto...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "294  Henry Cavill, Amy Adams, Michael Shannon, Dian...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "779  Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...  \n",
       "794  Sam Worthington, Elizabeth Banks, Jamie Bell, ...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  \n",
       "824  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...  \n",
       "870  Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...  \n",
       "924  Brandon Routh, Kevin Spacey, Kate Bosworth, Ja...  \n",
       "936  Dieter Laser, Ashley C. Williams, Ashlynn Yenn...  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'man\\b', case=False)] # man + punctuation marks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>The Gunman</td>\n",
       "      <td>Sean Penn, Idris Elba, Jasmine Trinca, Javier ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>Snow White and the Huntsman</td>\n",
       "      <td>Kristen Stewart, Chris Hemsworth, Charlize The...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Title  \\\n",
       "179                      Ant-Man   \n",
       "203                     Iron Man   \n",
       "368       The Amazing Spider-Man   \n",
       "378               Swiss Army Man   \n",
       "391                   The Gunman   \n",
       "564  Snow White and the Huntsman   \n",
       "570              The Other Woman   \n",
       "593                She's the Man   \n",
       "815                   Inside Man   \n",
       "\n",
       "                                                Actors  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "391  Sean Penn, Idris Elba, Jasmine Trinca, Javier ...  \n",
       "564  Kristen Stewart, Chris Hemsworth, Charlize The...  \n",
       "570  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'man\\b$', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Pirates of the Caribbean: Dead Man's Chest</td>\n",
       "      <td>Johnny Depp, Orlando Bloom, Keira Knightley, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>The Man from U.N.C.L.E.</td>\n",
       "      <td>Henry Cavill, Armie Hammer, Alicia Vikander, E...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>Henry Cavill, Amy Adams, Michael Shannon, Dian...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Swiss Army Man</td>\n",
       "      <td>Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>593</th>\n",
       "      <td>She's the Man</td>\n",
       "      <td>Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>The Man Who Knew Infinity</td>\n",
       "      <td>Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Man on a Ledge</td>\n",
       "      <td>Sam Worthington, Elizabeth Banks, Jamie Bell, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>Inside Man</td>\n",
       "      <td>Denzel Washington, Clive Owen, Jodie Foster,Ch...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>Man Down</td>\n",
       "      <td>Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>870</th>\n",
       "      <td>En man som heter Ove</td>\n",
       "      <td>Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Title  \\\n",
       "78   Pirates of the Caribbean: Dead Man's Chest   \n",
       "104                     The Man from U.N.C.L.E.   \n",
       "179                                     Ant-Man   \n",
       "203                                    Iron Man   \n",
       "253                    The Amazing Spider-Man 2   \n",
       "279                              Iron Man Three   \n",
       "294                                Man of Steel   \n",
       "344                                Spider-Man 3   \n",
       "368                      The Amazing Spider-Man   \n",
       "378                              Swiss Army Man   \n",
       "450                                  Iron Man 2   \n",
       "593                               She's the Man   \n",
       "779                   The Man Who Knew Infinity   \n",
       "794                              Man on a Ledge   \n",
       "815                                  Inside Man   \n",
       "824                                    Man Down   \n",
       "870                        En man som heter Ove   \n",
       "\n",
       "                                                Actors  \n",
       "78   Johnny Depp, Orlando Bloom, Keira Knightley, J...  \n",
       "104  Henry Cavill, Armie Hammer, Alicia Vikander, E...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "294  Henry Cavill, Amy Adams, Michael Shannon, Dian...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "378  Paul Dano, Daniel Radcliffe, Mary Elizabeth Wi...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "593  Amanda Bynes, Laura Ramsey, Channing Tatum,Vin...  \n",
       "779  Dev Patel, Jeremy Irons, Malcolm Sinclair, Rag...  \n",
       "794  Sam Worthington, Elizabeth Banks, Jamie Bell, ...  \n",
       "815  Denzel Washington, Clive Owen, Jodie Foster,Ch...  \n",
       "824  Shia LaBeouf, Jai Courtney, Gary Oldman, Kate ...  \n",
       "870  Rolf Lassgård, Bahar Pars, Filip Berg, Ida Eng...  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\bman\\b', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## match one of a set of characters [aeiou]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mindhorn</td>\n",
       "      <td>Essie Davis, Andrea Riseborough, Julian Barrat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>The Lost City of Z</td>\n",
       "      <td>Charlie Hunnam, Robert Pattinson, Sienna Mille...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>Project X</td>\n",
       "      <td>Thomas Mann, Oliver Cooper, Jonathan Daniel Br...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Search Party</td>\n",
       "      <td>Adam Pally, T.J. Miller, Thomas Middleditch,Sh...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>741 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "0    Guardians of the Galaxy   \n",
       "1                 Prometheus   \n",
       "4              Suicide Squad   \n",
       "7                   Mindhorn   \n",
       "8         The Lost City of Z   \n",
       "..                       ...   \n",
       "994                Project X   \n",
       "995     Secret in Their Eyes   \n",
       "996          Hostel: Part II   \n",
       "997   Step Up 2: The Streets   \n",
       "998             Search Party   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "1    Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "7    Essie Davis, Andrea Riseborough, Julian Barrat...  \n",
       "8    Charlie Hunnam, Robert Pattinson, Sienna Mille...  \n",
       "..                                                 ...  \n",
       "994  Thomas Mann, Oliver Cooper, Jonathan Daniel Br...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "998  Adam Pally, T.J. Miller, Thomas Middleditch,Sh...  \n",
       "\n",
       "[741 rows x 2 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df[df['Title'].str.contains(r'[1234you]', case=False)]\n",
    "df[df['Title'].str.contains(r'[1-4you]', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>20th Century Women</td>\n",
       "      <td>Annette Bening, Elle Fanning, Greta Gerwig, Bi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>570</th>\n",
       "      <td>The Other Woman</td>\n",
       "      <td>Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Title                                             Actors\n",
       "247  20th Century Women  Annette Bening, Elle Fanning, Greta Gerwig, Bi...\n",
       "570     The Other Woman  Cameron Diaz, Leslie Mann, Kate Upton, Nikolaj..."
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'wom[ae]n$', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## OR"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fantastic Beasts and Where to Find Them</td>\n",
       "      <td>Eddie Redmayne, Katherine Waterston, Alison Su...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Captain Fantastic</td>\n",
       "      <td>Viggo Mortensen, George MacKay, Samantha Isler...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>The Accountant</td>\n",
       "      <td>Ben Affleck, Anna Kendrick, J.K. Simmons, Jon ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>The Bad Batch</td>\n",
       "      <td>Keanu Reeves, Jason Momoa, Jim Carrey, Diego Luna</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>The Revenant</td>\n",
       "      <td>Leonardo DiCaprio, Tom Hardy, Will Poulter, Do...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>Allegiant</td>\n",
       "      <td>Shailene Woodley, Theo James, Jeff Daniels,Nao...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Battleship</td>\n",
       "      <td>Alexander Skarsgård, Brooklyn Decker, Liam Nee...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>Teenage Mutant Ninja Turtles: Out of the Shadows</td>\n",
       "      <td>Megan Fox, Will Arnett, Tyler Perry, Laura Linney</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>Everybody Wants Some!!</td>\n",
       "      <td>Blake Jenner, Tyler Hoechlin, Ryan Guzman,Zoey...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>The Hobbit: The Battle of the Five Armies</td>\n",
       "      <td>Ian McKellen, Martin Freeman, Richard Armitage...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>Wanted</td>\n",
       "      <td>Angelina Jolie, James McAvoy, Morgan Freeman, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>Marie Antoinette</td>\n",
       "      <td>Kirsten Dunst, Jason Schwartzman, Rip Torn, Ju...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>Anthropoid</td>\n",
       "      <td>Jamie Dornan, Cillian Murphy, Brian Caspe, Kar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>Miles Teller, Kate Mara, Michael B. Jordan, Ja...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>571</th>\n",
       "      <td>Enchanted</td>\n",
       "      <td>Amy Adams, Susan Sarandon, James Marsden, Patr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>622</th>\n",
       "      <td>Antichrist</td>\n",
       "      <td>Willem Dafoe, Charlotte Gainsbourg, Storm Ache...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>643</th>\n",
       "      <td>Frantz</td>\n",
       "      <td>Pierre Niney, Paula Beer, Ernst Stötzner, Mari...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>Teenage Mutant Ninja Turtles</td>\n",
       "      <td>Megan Fox, Will Arnett, William Fichtner, Noel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>Green Lantern</td>\n",
       "      <td>Ryan Reynolds, Blake Lively, Peter Sarsgaard,M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>732</th>\n",
       "      <td>This Beautiful Fantastic</td>\n",
       "      <td>Jessica Brown Findlay, Andrew Scott, Jeremy Ir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>Quantum of Solace</td>\n",
       "      <td>Daniel Craig, Olga Kurylenko, Mathieu Amalric,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>814</th>\n",
       "      <td>Fantastic Mr. Fox</td>\n",
       "      <td>George Clooney, Meryl Streep, Bill Murray, Jas...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>In Dubious Battle</td>\n",
       "      <td>Nat Wolff, James Franco, Vincent D'Onofrio, Se...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>951</th>\n",
       "      <td>The Descendants</td>\n",
       "      <td>George Clooney, Shailene Woodley, Amara Miller...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Title  \\\n",
       "10            Fantastic Beasts and Where to Find Them   \n",
       "60                 Batman v Superman: Dawn of Justice   \n",
       "81                                  Captain Fantastic   \n",
       "89                                     The Accountant   \n",
       "112                                     The Bad Batch   \n",
       "129                                      The Revenant   \n",
       "179                                           Ant-Man   \n",
       "203                                          Iron Man   \n",
       "204                                         Allegiant   \n",
       "253                          The Amazing Spider-Man 2   \n",
       "256                                        Battleship   \n",
       "264  Teenage Mutant Ninja Turtles: Out of the Shadows   \n",
       "278                            Everybody Wants Some!!   \n",
       "279                                    Iron Man Three   \n",
       "313         The Hobbit: The Battle of the Five Armies   \n",
       "344                                      Spider-Man 3   \n",
       "368                            The Amazing Spider-Man   \n",
       "373                                            Wanted   \n",
       "450                                        Iron Man 2   \n",
       "471                                  Marie Antoinette   \n",
       "520                                        Anthropoid   \n",
       "552                                    Fantastic Four   \n",
       "571                                         Enchanted   \n",
       "622                                        Antichrist   \n",
       "643                                            Frantz   \n",
       "657                      Teenage Mutant Ninja Turtles   \n",
       "673                                     Green Lantern   \n",
       "732                          This Beautiful Fantastic   \n",
       "770                                 Quantum of Solace   \n",
       "814                                 Fantastic Mr. Fox   \n",
       "905                                 In Dubious Battle   \n",
       "951                                   The Descendants   \n",
       "\n",
       "                                                Actors  \n",
       "10   Eddie Redmayne, Katherine Waterston, Alison Su...  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "81   Viggo Mortensen, George MacKay, Samantha Isler...  \n",
       "89   Ben Affleck, Anna Kendrick, J.K. Simmons, Jon ...  \n",
       "112  Keanu Reeves, Jason Momoa, Jim Carrey, Diego Luna  \n",
       "129  Leonardo DiCaprio, Tom Hardy, Will Poulter, Do...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "204  Shailene Woodley, Theo James, Jeff Daniels,Nao...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "256  Alexander Skarsgård, Brooklyn Decker, Liam Nee...  \n",
       "264  Megan Fox, Will Arnett, Tyler Perry, Laura Linney  \n",
       "278  Blake Jenner, Tyler Hoechlin, Ryan Guzman,Zoey...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "313  Ian McKellen, Martin Freeman, Richard Armitage...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "373  Angelina Jolie, James McAvoy, Morgan Freeman, ...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "471  Kirsten Dunst, Jason Schwartzman, Rip Torn, Ju...  \n",
       "520  Jamie Dornan, Cillian Murphy, Brian Caspe, Kar...  \n",
       "552  Miles Teller, Kate Mara, Michael B. Jordan, Ja...  \n",
       "571  Amy Adams, Susan Sarandon, James Marsden, Patr...  \n",
       "622  Willem Dafoe, Charlotte Gainsbourg, Storm Ache...  \n",
       "643  Pierre Niney, Paula Beer, Ernst Stötzner, Mari...  \n",
       "657  Megan Fox, Will Arnett, William Fichtner, Noel...  \n",
       "673  Ryan Reynolds, Blake Lively, Peter Sarsgaard,M...  \n",
       "732  Jessica Brown Findlay, Andrew Scott, Jeremy Ir...  \n",
       "770  Daniel Craig, Olga Kurylenko, Mathieu Amalric,...  \n",
       "814  George Clooney, Meryl Streep, Bill Murray, Jas...  \n",
       "905  Nat Wolff, James Franco, Vincent D'Onofrio, Se...  \n",
       "951  George Clooney, Shailene Woodley, Amara Miller...  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'bat|spider|ant|iron', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Title  \\\n",
       "60  Batman v Superman: Dawn of Justice   \n",
       "\n",
       "                                               Actors  \n",
       "60  Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'(bat|spider|ant|iron)man', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Title  \\\n",
       "60   Batman v Superman: Dawn of Justice   \n",
       "203                            Iron Man   \n",
       "279                      Iron Man Three   \n",
       "450                          Iron Man 2   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'(bat|spider|ant|iron)\\s*man', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>The Amazing Spider-Man 2</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>The Amazing Spider-Man</td>\n",
       "      <td>Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Title  \\\n",
       "60   Batman v Superman: Dawn of Justice   \n",
       "179                             Ant-Man   \n",
       "203                            Iron Man   \n",
       "253            The Amazing Spider-Man 2   \n",
       "279                      Iron Man Three   \n",
       "344                        Spider-Man 3   \n",
       "368              The Amazing Spider-Man   \n",
       "450                          Iron Man 2   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "253  Andrew Garfield, Emma Stone, Jamie Foxx, Paul ...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "368  Andrew Garfield, Emma Stone, Rhys Ifans, Irrfa...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'(bat|spider|ant|iron)[\\-\\s]*man', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Battleship</td>\n",
       "      <td>Alexander Skarsgård, Brooklyn Decker, Liam Nee...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>Anthropoid</td>\n",
       "      <td>Jamie Dornan, Cillian Murphy, Brian Caspe, Kar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>622</th>\n",
       "      <td>Antichrist</td>\n",
       "      <td>Willem Dafoe, Charlotte Gainsbourg, Storm Ache...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Title  \\\n",
       "60   Batman v Superman: Dawn of Justice   \n",
       "179                             Ant-Man   \n",
       "203                            Iron Man   \n",
       "256                          Battleship   \n",
       "279                      Iron Man Three   \n",
       "344                        Spider-Man 3   \n",
       "450                          Iron Man 2   \n",
       "520                          Anthropoid   \n",
       "622                          Antichrist   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "256  Alexander Skarsgård, Brooklyn Decker, Liam Nee...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "520  Jamie Dornan, Cillian Murphy, Brian Caspe, Kar...  \n",
       "622  Willem Dafoe, Charlotte Gainsbourg, Storm Ache...  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'^bat|^spider|^iron|^ant', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Ant-Man</td>\n",
       "      <td>Paul Rudd, Michael Douglas, Corey Stoll, Evang...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>Iron Man</td>\n",
       "      <td>Robert Downey Jr., Gwyneth Paltrow, Terrence H...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>Battleship</td>\n",
       "      <td>Alexander Skarsgård, Brooklyn Decker, Liam Nee...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Iron Man 2</td>\n",
       "      <td>Robert Downey Jr., Mickey Rourke, Gwyneth Palt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>Anthropoid</td>\n",
       "      <td>Jamie Dornan, Cillian Murphy, Brian Caspe, Kar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>622</th>\n",
       "      <td>Antichrist</td>\n",
       "      <td>Willem Dafoe, Charlotte Gainsbourg, Storm Ache...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Title  \\\n",
       "60   Batman v Superman: Dawn of Justice   \n",
       "179                             Ant-Man   \n",
       "203                            Iron Man   \n",
       "256                          Battleship   \n",
       "279                      Iron Man Three   \n",
       "344                        Spider-Man 3   \n",
       "450                          Iron Man 2   \n",
       "520                          Anthropoid   \n",
       "622                          Antichrist   \n",
       "\n",
       "                                                Actors  \n",
       "60   Ben Affleck, Henry Cavill, Amy Adams, Jesse Ei...  \n",
       "179  Paul Rudd, Michael Douglas, Corey Stoll, Evang...  \n",
       "203  Robert Downey Jr., Gwyneth Paltrow, Terrence H...  \n",
       "256  Alexander Skarsgård, Brooklyn Decker, Liam Nee...  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "450  Robert Downey Jr., Mickey Rourke, Gwyneth Palt...  \n",
       "520  Jamie Dornan, Cillian Murphy, Brian Caspe, Kar...  \n",
       "622  Willem Dafoe, Charlotte Gainsbourg, Storm Ache...  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'^(bat|spider|iron|ant)', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## \\d for digit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5- 25- 77</td>\n",
       "      <td>John Francis Daley, Austin Pendleton, Colleen ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>12 Years a Slave</td>\n",
       "      <td>Chiwetel Ejiofor, Michael Kenneth Williams, Mi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>300</td>\n",
       "      <td>Gerard Butler, Lena Headey, David Wenham, Domi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 2</td>\n",
       "      <td>Daniel Radcliffe, Emma Watson, Rupert Grint, M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>10 Cloverfield Lane</td>\n",
       "      <td>John Goodman, Mary Elizabeth Winstead, John Ga...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>Texas Chainsaw 3D</td>\n",
       "      <td>Alexandra Daddario, Tania Raymonde, Scott East...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>Scream 4</td>\n",
       "      <td>Neve Campbell, Courteney Cox, David Arquette, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>My Big Fat Greek Wedding 2</td>\n",
       "      <td>Nia Vardalos, John Corbett, Michael Constantin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>Final Destination 5</td>\n",
       "      <td>Nicholas D'Agosto, Emma Bell, Arlen Escarpeta,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Title  \\\n",
       "39                                      5- 25- 77   \n",
       "111                              12 Years a Slave   \n",
       "113                                           300   \n",
       "114  Harry Potter and the Deathly Hallows: Part 2   \n",
       "118                           10 Cloverfield Lane   \n",
       "..                                            ...   \n",
       "970                             Texas Chainsaw 3D   \n",
       "973                                      Scream 4   \n",
       "975                    My Big Fat Greek Wedding 2   \n",
       "986                           Final Destination 5   \n",
       "997                        Step Up 2: The Streets   \n",
       "\n",
       "                                                Actors  \n",
       "39   John Francis Daley, Austin Pendleton, Colleen ...  \n",
       "111  Chiwetel Ejiofor, Michael Kenneth Williams, Mi...  \n",
       "113  Gerard Butler, Lena Headey, David Wenham, Domi...  \n",
       "114  Daniel Radcliffe, Emma Watson, Rupert Grint, M...  \n",
       "118  John Goodman, Mary Elizabeth Winstead, John Ga...  \n",
       "..                                                 ...  \n",
       "970  Alexandra Daddario, Tania Raymonde, Scott East...  \n",
       "973  Neve Campbell, Courteney Cox, David Arquette, ...  \n",
       "975  Nia Vardalos, John Corbett, Michael Constantin...  \n",
       "986  Nicholas D'Agosto, Emma Bell, Arlen Escarpeta,...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "\n",
       "[70 rows x 2 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\d', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5- 25- 77</td>\n",
       "      <td>John Francis Daley, Austin Pendleton, Colleen ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>12 Years a Slave</td>\n",
       "      <td>Chiwetel Ejiofor, Michael Kenneth Williams, Mi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>300</td>\n",
       "      <td>Gerard Butler, Lena Headey, David Wenham, Domi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 2</td>\n",
       "      <td>Daniel Radcliffe, Emma Watson, Rupert Grint, M...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>10 Cloverfield Lane</td>\n",
       "      <td>John Goodman, Mary Elizabeth Winstead, John Ga...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>Texas Chainsaw 3D</td>\n",
       "      <td>Alexandra Daddario, Tania Raymonde, Scott East...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>Scream 4</td>\n",
       "      <td>Neve Campbell, Courteney Cox, David Arquette, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>My Big Fat Greek Wedding 2</td>\n",
       "      <td>Nia Vardalos, John Corbett, Michael Constantin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>Final Destination 5</td>\n",
       "      <td>Nicholas D'Agosto, Emma Bell, Arlen Escarpeta,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Title  \\\n",
       "39                                      5- 25- 77   \n",
       "111                              12 Years a Slave   \n",
       "113                                           300   \n",
       "114  Harry Potter and the Deathly Hallows: Part 2   \n",
       "118                           10 Cloverfield Lane   \n",
       "..                                            ...   \n",
       "970                             Texas Chainsaw 3D   \n",
       "973                                      Scream 4   \n",
       "975                    My Big Fat Greek Wedding 2   \n",
       "986                           Final Destination 5   \n",
       "997                        Step Up 2: The Streets   \n",
       "\n",
       "                                                Actors  \n",
       "39   John Francis Daley, Austin Pendleton, Colleen ...  \n",
       "111  Chiwetel Ejiofor, Michael Kenneth Williams, Mi...  \n",
       "113  Gerard Butler, Lena Headey, David Wenham, Domi...  \n",
       "114  Daniel Radcliffe, Emma Watson, Rupert Grint, M...  \n",
       "118  John Goodman, Mary Elizabeth Winstead, John Ga...  \n",
       "..                                                 ...  \n",
       "970  Alexandra Daddario, Tania Raymonde, Scott East...  \n",
       "973  Neve Campbell, Courteney Cox, David Arquette, ...  \n",
       "975  Nia Vardalos, John Corbett, Michael Constantin...  \n",
       "986  Nicholas D'Agosto, Emma Bell, Arlen Escarpeta,...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "\n",
       "[70 rows x 2 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'[0-9]', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5- 25- 77</td>\n",
       "      <td>John Francis Daley, Austin Pendleton, Colleen ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>12 Years a Slave</td>\n",
       "      <td>Chiwetel Ejiofor, Michael Kenneth Williams, Mi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>300</td>\n",
       "      <td>Gerard Butler, Lena Headey, David Wenham, Domi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>10 Cloverfield Lane</td>\n",
       "      <td>John Goodman, Mary Elizabeth Winstead, John Ga...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>13 Hours</td>\n",
       "      <td>John Krasinski, Pablo Schreiber, James Badge D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>20th Century Women</td>\n",
       "      <td>Annette Bening, Elle Fanning, Greta Gerwig, Bi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>21 Jump Street</td>\n",
       "      <td>Jonah Hill, Channing Tatum, Ice Cube,Brie Larson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>22 Jump Street</td>\n",
       "      <td>Channing Tatum, Jonah Hill, Ice Cube,Nick Offe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>300: Rise of an Empire</td>\n",
       "      <td>Sullivan Stapleton, Eva Green, Lena Headey, Ha...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>2012</td>\n",
       "      <td>John Cusack, Thandie Newton, Chiwetel Ejiofor,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>(500) Days of Summer</td>\n",
       "      <td>Zooey Deschanel, Joseph Gordon-Levitt, Geoffre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>Movie 43</td>\n",
       "      <td>Emma Stone, Stephen Merchant, Richard Gere, Li...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>2307: Winter's Dream</td>\n",
       "      <td>Paul Sidhu, Branden Coles, Arielle Holmes, Kel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>Friday the 13th</td>\n",
       "      <td>Jared Padalecki, Amanda Righetti, Derek Mears,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>Child 44</td>\n",
       "      <td>Tom Hardy, Gary Oldman, Noomi Rapace, Joel Kin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>10 Years</td>\n",
       "      <td>Channing Tatum, Rosario Dawson, Chris Pratt, J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>31</td>\n",
       "      <td>Malcolm McDowell, Richard Brake, Jeff Daniel P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>1408</td>\n",
       "      <td>John Cusack, Samuel L. Jackson, Mary McCormack...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>127 Hours</td>\n",
       "      <td>James Franco, Amber Tamblyn, Kate Mara, Sean Bott</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>42</td>\n",
       "      <td>Chadwick Boseman, T.R. Knight, Harrison Ford,N...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>21</td>\n",
       "      <td>Jim Sturgess, Kate Bosworth, Kevin Spacey, Aar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>28 Weeks Later</td>\n",
       "      <td>Jeremy Renner, Rose Byrne, Robert Carlyle, Har...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>50/50</td>\n",
       "      <td>Joseph Gordon-Levitt, Seth Rogen, Anna Kendric...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>This Is 40</td>\n",
       "      <td>Paul Rudd, Leslie Mann, Maude Apatow, Iris Apatow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>17 Again</td>\n",
       "      <td>Zac Efron, Matthew Perry, Leslie Mann, Thomas ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Title                                             Actors\n",
       "39                5- 25- 77  John Francis Daley, Austin Pendleton, Colleen ...\n",
       "111        12 Years a Slave  Chiwetel Ejiofor, Michael Kenneth Williams, Mi...\n",
       "113                     300  Gerard Butler, Lena Headey, David Wenham, Domi...\n",
       "118     10 Cloverfield Lane  John Goodman, Mary Elizabeth Winstead, John Ga...\n",
       "168                13 Hours  John Krasinski, Pablo Schreiber, James Badge D...\n",
       "247      20th Century Women  Annette Bening, Elle Fanning, Greta Gerwig, Bi...\n",
       "272          21 Jump Street   Jonah Hill, Channing Tatum, Ice Cube,Brie Larson\n",
       "276          22 Jump Street  Channing Tatum, Jonah Hill, Ice Cube,Nick Offe...\n",
       "423  300: Rise of an Empire  Sullivan Stapleton, Eva Green, Lena Headey, Ha...\n",
       "472                    2012  John Cusack, Thandie Newton, Chiwetel Ejiofor,...\n",
       "507    (500) Days of Summer  Zooey Deschanel, Joseph Gordon-Levitt, Geoffre...\n",
       "508                Movie 43  Emma Stone, Stephen Merchant, Richard Gere, Li...\n",
       "616    2307: Winter's Dream  Paul Sidhu, Branden Coles, Arielle Holmes, Kel...\n",
       "623         Friday the 13th  Jared Padalecki, Amanda Righetti, Derek Mears,...\n",
       "671                Child 44  Tom Hardy, Gary Oldman, Noomi Rapace, Joel Kin...\n",
       "696                10 Years  Channing Tatum, Rosario Dawson, Chris Pratt, J...\n",
       "776                      31  Malcolm McDowell, Richard Brake, Jeff Daniel P...\n",
       "804                    1408  John Cusack, Samuel L. Jackson, Mary McCormack...\n",
       "817               127 Hours  James Franco, Amber Tamblyn, Kate Mara, Sean Bott\n",
       "849                      42  Chadwick Boseman, T.R. Knight, Harrison Ford,N...\n",
       "850                      21  Jim Sturgess, Kate Bosworth, Kevin Spacey, Aar...\n",
       "875          28 Weeks Later  Jeremy Renner, Rose Byrne, Robert Carlyle, Har...\n",
       "889                   50/50  Joseph Gordon-Levitt, Seth Rogen, Anna Kendric...\n",
       "891              This Is 40  Paul Rudd, Leslie Mann, Maude Apatow, Iris Apatow\n",
       "922                17 Again  Zac Efron, Matthew Perry, Leslie Mann, Thomas ..."
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\d{2}', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5- 25- 77</td>\n",
       "      <td>John Francis Daley, Austin Pendleton, Colleen ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>300</td>\n",
       "      <td>Gerard Butler, Lena Headey, David Wenham, Domi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>2012</td>\n",
       "      <td>John Cusack, Thandie Newton, Chiwetel Ejiofor,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>Movie 43</td>\n",
       "      <td>Emma Stone, Stephen Merchant, Richard Gere, Li...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>Child 44</td>\n",
       "      <td>Tom Hardy, Gary Oldman, Noomi Rapace, Joel Kin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>31</td>\n",
       "      <td>Malcolm McDowell, Richard Brake, Jeff Daniel P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>1408</td>\n",
       "      <td>John Cusack, Samuel L. Jackson, Mary McCormack...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>42</td>\n",
       "      <td>Chadwick Boseman, T.R. Knight, Harrison Ford,N...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>21</td>\n",
       "      <td>Jim Sturgess, Kate Bosworth, Kevin Spacey, Aar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>50/50</td>\n",
       "      <td>Joseph Gordon-Levitt, Seth Rogen, Anna Kendric...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>This Is 40</td>\n",
       "      <td>Paul Rudd, Leslie Mann, Maude Apatow, Iris Apatow</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Title                                             Actors\n",
       "39    5- 25- 77  John Francis Daley, Austin Pendleton, Colleen ...\n",
       "113         300  Gerard Butler, Lena Headey, David Wenham, Domi...\n",
       "472        2012  John Cusack, Thandie Newton, Chiwetel Ejiofor,...\n",
       "508    Movie 43  Emma Stone, Stephen Merchant, Richard Gere, Li...\n",
       "671    Child 44  Tom Hardy, Gary Oldman, Noomi Rapace, Joel Kin...\n",
       "776          31  Malcolm McDowell, Richard Brake, Jeff Daniel P...\n",
       "804        1408  John Cusack, Samuel L. Jackson, Mary McCormack...\n",
       "849          42  Chadwick Boseman, T.R. Knight, Harrison Ford,N...\n",
       "850          21  Jim Sturgess, Kate Bosworth, Kevin Spacey, Aar...\n",
       "889       50/50  Joseph Gordon-Levitt, Seth Rogen, Anna Kendric...\n",
       "891  This Is 40  Paul Rudd, Leslie Mann, Maude Apatow, Iris Apatow"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\d{2}$', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>The Expendables 3</td>\n",
       "      <td>Sylvester Stallone, Jason Statham, Jet Li, Ant...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>Men in Black 3</td>\n",
       "      <td>Will Smith, Tommy Lee Jones, Josh Brolin,Jemai...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>Movie 43</td>\n",
       "      <td>Emma Stone, Stephen Merchant, Richard Gere, Li...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>Kung Fu Panda 3</td>\n",
       "      <td>Jack Black, Bryan Cranston, Dustin Hoffman, An...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>Taken 3</td>\n",
       "      <td>Liam Neeson, Forest Whitaker, Maggie Grace,Fam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>Toy Story 3</td>\n",
       "      <td>Tom Hanks, Tim Allen, Joan Cusack, Ned Beatty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>869</th>\n",
       "      <td>Mission: Impossible III</td>\n",
       "      <td>Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "279           Iron Man Three   \n",
       "344             Spider-Man 3   \n",
       "379        The Expendables 3   \n",
       "496           Men in Black 3   \n",
       "508                 Movie 43   \n",
       "603          Kung Fu Panda 3   \n",
       "624                  Taken 3   \n",
       "688              Toy Story 3   \n",
       "869  Mission: Impossible III   \n",
       "\n",
       "                                                Actors  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "379  Sylvester Stallone, Jason Statham, Jet Li, Ant...  \n",
       "496  Will Smith, Tommy Lee Jones, Josh Brolin,Jemai...  \n",
       "508  Emma Stone, Stephen Merchant, Richard Gere, Li...  \n",
       "603  Jack Black, Bryan Cranston, Dustin Hoffman, An...  \n",
       "624  Liam Neeson, Forest Whitaker, Maggie Grace,Fam...  \n",
       "688      Tom Hanks, Tim Allen, Joan Cusack, Ned Beatty  \n",
       "869  Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'(3|iii|three)$', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>Iron Man Three</td>\n",
       "      <td>Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>Spider-Man 3</td>\n",
       "      <td>Tobey Maguire, Kirsten Dunst, Topher Grace, Th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>The Expendables 3</td>\n",
       "      <td>Sylvester Stallone, Jason Statham, Jet Li, Ant...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>Men in Black 3</td>\n",
       "      <td>Will Smith, Tommy Lee Jones, Josh Brolin,Jemai...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603</th>\n",
       "      <td>Kung Fu Panda 3</td>\n",
       "      <td>Jack Black, Bryan Cranston, Dustin Hoffman, An...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>Taken 3</td>\n",
       "      <td>Liam Neeson, Forest Whitaker, Maggie Grace,Fam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>Toy Story 3</td>\n",
       "      <td>Tom Hanks, Tim Allen, Joan Cusack, Ned Beatty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>869</th>\n",
       "      <td>Mission: Impossible III</td>\n",
       "      <td>Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "279           Iron Man Three   \n",
       "344             Spider-Man 3   \n",
       "379        The Expendables 3   \n",
       "496           Men in Black 3   \n",
       "603          Kung Fu Panda 3   \n",
       "624                  Taken 3   \n",
       "688              Toy Story 3   \n",
       "869  Mission: Impossible III   \n",
       "\n",
       "                                                Actors  \n",
       "279  Robert Downey Jr., Guy Pearce, Gwyneth Paltrow...  \n",
       "344  Tobey Maguire, Kirsten Dunst, Topher Grace, Th...  \n",
       "379  Sylvester Stallone, Jason Statham, Jet Li, Ant...  \n",
       "496  Will Smith, Tommy Lee Jones, Josh Brolin,Jemai...  \n",
       "603  Jack Black, Bryan Cranston, Dustin Hoffman, An...  \n",
       "624  Liam Neeson, Forest Whitaker, Maggie Grace,Fam...  \n",
       "688      Tom Hanks, Tim Allen, Joan Cusack, Ned Beatty  \n",
       "869  Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\b(3|iii|three)$', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>The Avengers</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Scarlett Johan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Avengers: Age of Ultron</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Mark Ruffalo, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Captain America: The First Avenger</td>\n",
       "      <td>Chris Evans, Hugo Weaving, Samuel L. Jackson,H...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Title  \\\n",
       "76                         The Avengers   \n",
       "94              Avengers: Age of Ultron   \n",
       "195  Captain America: The First Avenger   \n",
       "\n",
       "                                                Actors  \n",
       "76   Robert Downey Jr., Chris Evans, Scarlett Johan...  \n",
       "94   Robert Downey Jr., Chris Evans, Mark Ruffalo, ...  \n",
       "195  Chris Evans, Hugo Weaving, Samuel L. Jackson,H...  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df['Title'].str.contains('iron|avenger', case=False)) & (df['Actors'].str.contains('chris', case=False))]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## AND with lookahead ?="
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>The Avengers</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Scarlett Johan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Avengers: Age of Ultron</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Mark Ruffalo, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Title                                             Actors\n",
       "76             The Avengers  Robert Downey Jr., Chris Evans, Scarlett Johan...\n",
       "94  Avengers: Age of Ultron  Robert Downey Jr., Chris Evans, Mark Ruffalo, ..."
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Actors'].str.contains('.*Downey.*Evans', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Captain America: Civil War</td>\n",
       "      <td>Chris Evans, Robert Downey Jr.,Scarlett Johans...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  \\\n",
       "35  Captain America: Civil War   \n",
       "\n",
       "                                               Actors  \n",
       "35  Chris Evans, Robert Downey Jr.,Scarlett Johans...  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Actors'].str.contains('.*Evans.*Downey', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Captain America: Civil War</td>\n",
       "      <td>Chris Evans, Robert Downey Jr.,Scarlett Johans...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>The Avengers</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Scarlett Johan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Avengers: Age of Ultron</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Mark Ruffalo, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  \\\n",
       "35  Captain America: Civil War   \n",
       "76                The Avengers   \n",
       "94     Avengers: Age of Ultron   \n",
       "\n",
       "                                               Actors  \n",
       "35  Chris Evans, Robert Downey Jr.,Scarlett Johans...  \n",
       "76  Robert Downey Jr., Chris Evans, Scarlett Johan...  \n",
       "94  Robert Downey Jr., Chris Evans, Mark Ruffalo, ...  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Actors'].str.contains('(.*Evans.*Downey)|(.*Downey.*Evans)', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Captain America: Civil War</td>\n",
       "      <td>Chris Evans, Robert Downey Jr.,Scarlett Johans...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>The Avengers</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Scarlett Johan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Avengers: Age of Ultron</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Mark Ruffalo, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  \\\n",
       "35  Captain America: Civil War   \n",
       "76                The Avengers   \n",
       "94     Avengers: Age of Ultron   \n",
       "\n",
       "                                               Actors  \n",
       "35  Chris Evans, Robert Downey Jr.,Scarlett Johans...  \n",
       "76  Robert Downey Jr., Chris Evans, Scarlett Johan...  \n",
       "94  Robert Downey Jr., Chris Evans, Mark Ruffalo, ...  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Actors'].str.contains('(?=.*Downey)(?=.*Evans)', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Captain America: Civil War</td>\n",
       "      <td>Chris Evans, Robert Downey Jr.,Scarlett Johans...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>The Avengers</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Scarlett Johan...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Avengers: Age of Ultron</td>\n",
       "      <td>Robert Downey Jr., Chris Evans, Mark Ruffalo, ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  \\\n",
       "35  Captain America: Civil War   \n",
       "76                The Avengers   \n",
       "94     Avengers: Age of Ultron   \n",
       "\n",
       "                                               Actors  \n",
       "35  Chris Evans, Robert Downey Jr.,Scarlett Johans...  \n",
       "76  Robert Downey Jr., Chris Evans, Scarlett Johan...  \n",
       "94  Robert Downey Jr., Chris Evans, Mark Ruffalo, ...  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Actors'].str.contains('(?=.*Evans)(?=.*Downey)', case=False)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## quantifiers\n",
    "```\n",
    "- *, ?, +\n",
    "- a* -> a{0,}\n",
    "- a+ -> a{1,}\n",
    "- a? -> a{0,1}\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Split</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Search Party</td>\n",
       "      <td>Adam Pally, T.J. Miller, Thomas Middleditch,Sh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "0    Guardians of the Galaxy   \n",
       "1                 Prometheus   \n",
       "2                      Split   \n",
       "3                       Sing   \n",
       "4              Suicide Squad   \n",
       "..                       ...   \n",
       "995     Secret in Their Eyes   \n",
       "996          Hostel: Part II   \n",
       "997   Step Up 2: The Streets   \n",
       "998             Search Party   \n",
       "999               Nine Lives   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "1    Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "2    James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3    Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "..                                                 ...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "998  Adam Pally, T.J. Miller, Thomas Middleditch,Sh...  \n",
       "999  Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...  \n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'i*', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Split</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Search Party</td>\n",
       "      <td>Adam Pally, T.J. Miller, Thomas Middleditch,Sh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "0    Guardians of the Galaxy   \n",
       "1                 Prometheus   \n",
       "2                      Split   \n",
       "3                       Sing   \n",
       "4              Suicide Squad   \n",
       "..                       ...   \n",
       "995     Secret in Their Eyes   \n",
       "996          Hostel: Part II   \n",
       "997   Step Up 2: The Streets   \n",
       "998             Search Party   \n",
       "999               Nine Lives   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "1    Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "2    James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3    Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "..                                                 ...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "998  Adam Pally, T.J. Miller, Thomas Middleditch,Sh...  \n",
       "999  Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...  \n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'i{0,}', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Split</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Search Party</td>\n",
       "      <td>Adam Pally, T.J. Miller, Thomas Middleditch,Sh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "0    Guardians of the Galaxy   \n",
       "1                 Prometheus   \n",
       "2                      Split   \n",
       "3                       Sing   \n",
       "4              Suicide Squad   \n",
       "..                       ...   \n",
       "995     Secret in Their Eyes   \n",
       "996          Hostel: Part II   \n",
       "997   Step Up 2: The Streets   \n",
       "998             Search Party   \n",
       "999               Nine Lives   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "1    Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "2    James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3    Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "..                                                 ...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "998  Adam Pally, T.J. Miller, Thomas Middleditch,Sh...  \n",
       "999  Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...  \n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'i?', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prometheus</td>\n",
       "      <td>Noomi Rapace, Logan Marshall-Green, Michael Fa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Split</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Step Up 2: The Streets</td>\n",
       "      <td>Robert Hoffman, Briana Evigan, Cassie Ventura,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Search Party</td>\n",
       "      <td>Adam Pally, T.J. Miller, Thomas Middleditch,Sh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Title  \\\n",
       "0    Guardians of the Galaxy   \n",
       "1                 Prometheus   \n",
       "2                      Split   \n",
       "3                       Sing   \n",
       "4              Suicide Squad   \n",
       "..                       ...   \n",
       "995     Secret in Their Eyes   \n",
       "996          Hostel: Part II   \n",
       "997   Step Up 2: The Streets   \n",
       "998             Search Party   \n",
       "999               Nine Lives   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "1    Noomi Rapace, Logan Marshall-Green, Michael Fa...  \n",
       "2    James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3    Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "..                                                 ...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "997  Robert Hoffman, Briana Evigan, Cassie Ventura,...  \n",
       "998  Adam Pally, T.J. Miller, Thomas Middleditch,Sh...  \n",
       "999  Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...  \n",
       "\n",
       "[1000 rows x 2 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'i{0,1}', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Split</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mindhorn</td>\n",
       "      <td>Essie Davis, Andrea Riseborough, Julian Barrat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>Take Me Home Tonight</td>\n",
       "      <td>Topher Grace, Anna Faris, Dan Fogler, Teresa P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>Resident Evil: Afterlife</td>\n",
       "      <td>Milla Jovovich, Ali Larter, Wentworth Miller,K...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>573 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Title  \\\n",
       "0     Guardians of the Galaxy   \n",
       "2                       Split   \n",
       "3                        Sing   \n",
       "4               Suicide Squad   \n",
       "7                    Mindhorn   \n",
       "..                        ...   \n",
       "992      Take Me Home Tonight   \n",
       "993  Resident Evil: Afterlife   \n",
       "995      Secret in Their Eyes   \n",
       "996           Hostel: Part II   \n",
       "999                Nine Lives   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "2    James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3    Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "7    Essie Davis, Andrea Riseborough, Julian Barrat...  \n",
       "..                                                 ...  \n",
       "992  Topher Grace, Anna Faris, Dan Fogler, Teresa P...  \n",
       "993  Milla Jovovich, Ali Larter, Wentworth Miller,K...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "999  Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...  \n",
       "\n",
       "[573 rows x 2 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'i+', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Split</td>\n",
       "      <td>James McAvoy, Anya Taylor-Joy, Haley Lu Richar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sing</td>\n",
       "      <td>Matthew McConaughey,Reese Witherspoon, Seth Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>Will Smith, Jared Leto, Margot Robbie, Viola D...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mindhorn</td>\n",
       "      <td>Essie Davis, Andrea Riseborough, Julian Barrat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>Take Me Home Tonight</td>\n",
       "      <td>Topher Grace, Anna Faris, Dan Fogler, Teresa P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>Resident Evil: Afterlife</td>\n",
       "      <td>Milla Jovovich, Ali Larter, Wentworth Miller,K...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>573 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Title  \\\n",
       "0     Guardians of the Galaxy   \n",
       "2                       Split   \n",
       "3                        Sing   \n",
       "4               Suicide Squad   \n",
       "7                    Mindhorn   \n",
       "..                        ...   \n",
       "992      Take Me Home Tonight   \n",
       "993  Resident Evil: Afterlife   \n",
       "995      Secret in Their Eyes   \n",
       "996           Hostel: Part II   \n",
       "999                Nine Lives   \n",
       "\n",
       "                                                Actors  \n",
       "0    Chris Pratt, Vin Diesel, Bradley Cooper, Zoe S...  \n",
       "2    James McAvoy, Anya Taylor-Joy, Haley Lu Richar...  \n",
       "3    Matthew McConaughey,Reese Witherspoon, Seth Ma...  \n",
       "4    Will Smith, Jared Leto, Margot Robbie, Viola D...  \n",
       "7    Essie Davis, Andrea Riseborough, Julian Barrat...  \n",
       "..                                                 ...  \n",
       "992  Topher Grace, Anna Faris, Dan Fogler, Teresa P...  \n",
       "993  Milla Jovovich, Ali Larter, Wentworth Miller,K...  \n",
       "995  Chiwetel Ejiofor, Nicole Kidman, Julia Roberts...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  \n",
       "999  Kevin Spacey, Jennifer Garner, Robbie Amell,Ch...  \n",
       "\n",
       "[573 rows x 2 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'i{1,}', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Star Wars: Episode VII - The Force Awakens</td>\n",
       "      <td>Daisy Ridley, John Boyega, Oscar Isaac, Domhna...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Raw (II)</td>\n",
       "      <td>Garance Marillier, Ella Rumpf, Rabah Nait Oufe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>Hellboy II: The Golden Army</td>\n",
       "      <td>Ron Perlman, Selma Blair, Doug Jones, John Ale...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>Pompeii</td>\n",
       "      <td>Kit Harington, Emily Browning, Kiefer Sutherla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Nymphomaniac: Vol. II</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Wille...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>869</th>\n",
       "      <td>Mission: Impossible III</td>\n",
       "      <td>Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Title  \\\n",
       "50   Star Wars: Episode VII - The Force Awakens   \n",
       "206                                    Raw (II)   \n",
       "609                 Hellboy II: The Golden Army   \n",
       "693                                     Pompeii   \n",
       "720                       Nymphomaniac: Vol. II   \n",
       "869                     Mission: Impossible III   \n",
       "996                             Hostel: Part II   \n",
       "\n",
       "                                                Actors  \n",
       "50   Daisy Ridley, John Boyega, Oscar Isaac, Domhna...  \n",
       "206  Garance Marillier, Ella Rumpf, Rabah Nait Oufe...  \n",
       "609  Ron Perlman, Selma Blair, Doug Jones, John Ale...  \n",
       "693  Kit Harington, Emily Browning, Kiefer Sutherla...  \n",
       "720  Charlotte Gainsbourg, Stellan Skarsgård, Wille...  \n",
       "869  Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'i{2,}', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Raw (II)</td>\n",
       "      <td>Garance Marillier, Ella Rumpf, Rabah Nait Oufe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>Hellboy II: The Golden Army</td>\n",
       "      <td>Ron Perlman, Selma Blair, Doug Jones, John Ale...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Nymphomaniac: Vol. II</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Wille...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>869</th>\n",
       "      <td>Mission: Impossible III</td>\n",
       "      <td>Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Title  \\\n",
       "206                     Raw (II)   \n",
       "609  Hellboy II: The Golden Army   \n",
       "720        Nymphomaniac: Vol. II   \n",
       "869      Mission: Impossible III   \n",
       "996              Hostel: Part II   \n",
       "\n",
       "                                                Actors  \n",
       "206  Garance Marillier, Ella Rumpf, Rabah Nait Oufe...  \n",
       "609  Ron Perlman, Selma Blair, Doug Jones, John Ale...  \n",
       "720  Charlotte Gainsbourg, Stellan Skarsgård, Wille...  \n",
       "869  Tom Cruise, Michelle Monaghan, Ving Rhames, Ph...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\bi{2,}', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Actors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>Raw (II)</td>\n",
       "      <td>Garance Marillier, Ella Rumpf, Rabah Nait Oufe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>609</th>\n",
       "      <td>Hellboy II: The Golden Army</td>\n",
       "      <td>Ron Perlman, Selma Blair, Doug Jones, John Ale...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Nymphomaniac: Vol. II</td>\n",
       "      <td>Charlotte Gainsbourg, Stellan Skarsgård, Wille...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Hostel: Part II</td>\n",
       "      <td>Lauren German, Heather Matarazzo, Bijou Philli...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Title  \\\n",
       "206                     Raw (II)   \n",
       "609  Hellboy II: The Golden Army   \n",
       "720        Nymphomaniac: Vol. II   \n",
       "996              Hostel: Part II   \n",
       "\n",
       "                                                Actors  \n",
       "206  Garance Marillier, Ella Rumpf, Rabah Nait Oufe...  \n",
       "609  Ron Perlman, Selma Blair, Doug Jones, John Ale...  \n",
       "720  Charlotte Gainsbourg, Stellan Skarsgård, Wille...  \n",
       "996  Lauren German, Heather Matarazzo, Bijou Philli...  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Title'].str.contains(r'\\bi{2}\\b', case=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  },
  "toc-autonumbering": true,
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}