notebooks/split_data_tables.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "import importlib\n",
    "import data_cleaning\n",
    "from data_cleaning import *\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfs = {}\n",
    "for table_name in TABLE_FORMATS.keys():\n",
    "    dfs[table_name] = df_from_movie_csv(table_name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "mdf = dfs['imdb.title.basics'].copy()\n",
    "test = mdf.head()"
   ]
  },
  {
   "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>primary_title</th>\n",
       "      <th>original_title</th>\n",
       "      <th>start_year</th>\n",
       "      <th>runtime_minutes</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tconst</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>tt4975722</th>\n",
       "      <td>Moonlight</td>\n",
       "      <td>Moonlight</td>\n",
       "      <td>2016</td>\n",
       "      <td>111.0</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt5934182</th>\n",
       "      <td>Moonlight</td>\n",
       "      <td>Moonlight</td>\n",
       "      <td>2011</td>\n",
       "      <td>87.0</td>\n",
       "      <td>Horror</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          primary_title original_title  start_year  runtime_minutes  genres\n",
       "tconst                                                                     \n",
       "tt4975722     Moonlight      Moonlight        2016            111.0   Drama\n",
       "tt5934182     Moonlight      Moonlight        2011             87.0  Horror"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mdf[mdf.original_title=='Moonlight']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "scrolled": true
   },
   "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>primary_title</th>\n",
       "      <th>original_title</th>\n",
       "      <th>start_year</th>\n",
       "      <th>runtime_minutes</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tconst</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>tt0063540</th>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>2013</td>\n",
       "      <td>175.0</td>\n",
       "      <td>Action,Crime,Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0066787</th>\n",
       "      <td>One Day Before the Rainy Season</td>\n",
       "      <td>Ashad Ka Ek Din</td>\n",
       "      <td>2019</td>\n",
       "      <td>114.0</td>\n",
       "      <td>Biography,Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0069049</th>\n",
       "      <td>The Other Side of the Wind</td>\n",
       "      <td>The Other Side of the Wind</td>\n",
       "      <td>2018</td>\n",
       "      <td>122.0</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0069204</th>\n",
       "      <td>Sabse Bada Sukh</td>\n",
       "      <td>Sabse Bada Sukh</td>\n",
       "      <td>2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Comedy,Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0100275</th>\n",
       "      <td>The Wandering Soap Opera</td>\n",
       "      <td>La Telenovela Errante</td>\n",
       "      <td>2017</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Comedy,Drama,Fantasy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             primary_title              original_title  \\\n",
       "tconst                                                                   \n",
       "tt0063540                        Sunghursh                   Sunghursh   \n",
       "tt0066787  One Day Before the Rainy Season             Ashad Ka Ek Din   \n",
       "tt0069049       The Other Side of the Wind  The Other Side of the Wind   \n",
       "tt0069204                  Sabse Bada Sukh             Sabse Bada Sukh   \n",
       "tt0100275         The Wandering Soap Opera       La Telenovela Errante   \n",
       "\n",
       "           start_year  runtime_minutes                genres  \n",
       "tconst                                                        \n",
       "tt0063540        2013            175.0    Action,Crime,Drama  \n",
       "tt0066787        2019            114.0       Biography,Drama  \n",
       "tt0069049        2018            122.0                 Drama  \n",
       "tt0069204        2018              NaN          Comedy,Drama  \n",
       "tt0100275        2017             80.0  Comedy,Drama,Fantasy  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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>primary_title</th>\n",
       "      <th>original_title</th>\n",
       "      <th>start_year</th>\n",
       "      <th>runtime_minutes</th>\n",
       "      <th>genre</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tconst</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>tt0063540</th>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>2013</td>\n",
       "      <td>175.0</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0063540</th>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>2013</td>\n",
       "      <td>175.0</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0063540</th>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>2013</td>\n",
       "      <td>175.0</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0066787</th>\n",
       "      <td>One Day Before the Rainy Season</td>\n",
       "      <td>Ashad Ka Ek Din</td>\n",
       "      <td>2019</td>\n",
       "      <td>114.0</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0066787</th>\n",
       "      <td>One Day Before the Rainy Season</td>\n",
       "      <td>Ashad Ka Ek Din</td>\n",
       "      <td>2019</td>\n",
       "      <td>114.0</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0069049</th>\n",
       "      <td>The Other Side of the Wind</td>\n",
       "      <td>The Other Side of the Wind</td>\n",
       "      <td>2018</td>\n",
       "      <td>122.0</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0100275</th>\n",
       "      <td>The Wandering Soap Opera</td>\n",
       "      <td>La Telenovela Errante</td>\n",
       "      <td>2017</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0100275</th>\n",
       "      <td>The Wandering Soap Opera</td>\n",
       "      <td>La Telenovela Errante</td>\n",
       "      <td>2017</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0100275</th>\n",
       "      <td>The Wandering Soap Opera</td>\n",
       "      <td>La Telenovela Errante</td>\n",
       "      <td>2017</td>\n",
       "      <td>80.0</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             primary_title              original_title  \\\n",
       "tconst                                                                   \n",
       "tt0063540                        Sunghursh                   Sunghursh   \n",
       "tt0063540                        Sunghursh                   Sunghursh   \n",
       "tt0063540                        Sunghursh                   Sunghursh   \n",
       "tt0066787  One Day Before the Rainy Season             Ashad Ka Ek Din   \n",
       "tt0066787  One Day Before the Rainy Season             Ashad Ka Ek Din   \n",
       "tt0069049       The Other Side of the Wind  The Other Side of the Wind   \n",
       "tt0100275         The Wandering Soap Opera       La Telenovela Errante   \n",
       "tt0100275         The Wandering Soap Opera       La Telenovela Errante   \n",
       "tt0100275         The Wandering Soap Opera       La Telenovela Errante   \n",
       "\n",
       "           start_year  runtime_minutes      genre  \n",
       "tconst                                             \n",
       "tt0063540        2013            175.0     Action  \n",
       "tt0063540        2013            175.0      Crime  \n",
       "tt0063540        2013            175.0      Drama  \n",
       "tt0066787        2019            114.0  Biography  \n",
       "tt0066787        2019            114.0      Drama  \n",
       "tt0069049        2018            122.0      Drama  \n",
       "tt0100275        2017             80.0     Comedy  \n",
       "tt0100275        2017             80.0      Drama  \n",
       "tt0100275        2017             80.0    Fantasy  "
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.genres.apply(lambda x: [str.strip(\"[']\") for str in x.split(\",\")]) \\\n",
    "           .apply(pd.Series) \\\n",
    "           .merge(test, left_index = True, right_index = True) \\\n",
    "           .reset_index() \\\n",
    "           .drop([\"genres\"], axis = 1) \\\n",
    "           .melt(id_vars = test.reset_index().columns.drop('genres'), value_name = \"genre\") \\\n",
    "           .drop(\"variable\", axis = 1) \\\n",
    "           .dropna() \\\n",
    "           .set_index('tconst') \\\n",
    "           .sort_values(by=['tconst','genre'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "import split_data_fields\n",
    "importlib.reload(split_data_fields)\n",
    "from split_data_fields import expand_df_split_fields"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "imdb_genre_df = expand_df_split_fields(dfs['imdb.title.basics'],'imdb.title.basics')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: \n",
      "Passing list-likes to .loc or [] with any missing label will raise\n",
      "KeyError in the future, you can use .reindex() as an alternative.\n",
      "\n",
      "See the documentation here:\n",
      "https://pandas.pydata.org/pandas-docs/stable/indexing.html#deprecate-loc-reindex-listlike\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>primary_title</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tconst</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>tt0063540</th>\n",
       "      <td>Sunghursh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0315642</th>\n",
       "      <td>Wazir</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0365907</th>\n",
       "      <td>A Walk Among the Tombstones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0372538</th>\n",
       "      <td>Spy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0411951</th>\n",
       "      <td>Tekken</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0423474</th>\n",
       "      <td>Venus &amp; Vegas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0455944</th>\n",
       "      <td>The Equalizer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0464032</th>\n",
       "      <td>Guns, Drugs and Dirty Money</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0464162</th>\n",
       "      <td>Komaram Puli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0469021</th>\n",
       "      <td>Alan Partridge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0471042</th>\n",
       "      <td>Tower Heist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0472399</th>\n",
       "      <td>The Mechanic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0480255</th>\n",
       "      <td>The Losers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0490847</th>\n",
       "      <td>Double Tap</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0493405</th>\n",
       "      <td>CHIPS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0790724</th>\n",
       "      <td>Jack Reacher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0817545</th>\n",
       "      <td>The Power of Few</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0835775</th>\n",
       "      <td>Electric Slide</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0847180</th>\n",
       "      <td>Loot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0857190</th>\n",
       "      <td>The Sweeney</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0873886</th>\n",
       "      <td>Red State</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0896872</th>\n",
       "      <td>The Whistleblower</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0903036</th>\n",
       "      <td>Westbrick Murders</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0934981</th>\n",
       "      <td>The Waiter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0960827</th>\n",
       "      <td>Private Security Officer: Los Angeles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0975738</th>\n",
       "      <td>Sinatra Club</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0985694</th>\n",
       "      <td>Machete</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0990407</th>\n",
       "      <td>The Green Hornet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0995845</th>\n",
       "      <td>The Courier</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt10017680</th>\n",
       "      <td>P Storm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt8820540</th>\n",
       "      <td>Bostrom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt8836988</th>\n",
       "      <td>Avengement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt8858420</th>\n",
       "      <td>Women of Mafia 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt8869530</th>\n",
       "      <td>Keita Never Die</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt8898254</th>\n",
       "      <td>Money Is Our Goal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt8961674</th>\n",
       "      <td>School Chalega..!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt8972280</th>\n",
       "      <td>I'll See What I Can Do</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9009056</th>\n",
       "      <td>Ksatria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9109794</th>\n",
       "      <td>Kolaigaran</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9144712</th>\n",
       "      <td>Jack Boiz The Movie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9146260</th>\n",
       "      <td>Hell Is Empty</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9174410</th>\n",
       "      <td>Koodasha</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9179256</th>\n",
       "      <td>Mix-ups</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9183176</th>\n",
       "      <td>Don of the Damned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9225192</th>\n",
       "      <td>Unstoppable</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9233940</th>\n",
       "      <td>Toxic Man</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9293562</th>\n",
       "      <td>DeSorrow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9347622</th>\n",
       "      <td>Such a Funny Life</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9426186</th>\n",
       "      <td>Revenger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9447662</th>\n",
       "      <td>Suspended Inspector Boro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9481630</th>\n",
       "      <td>The lolipop Gang</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9531344</th>\n",
       "      <td>Appavi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9553374</th>\n",
       "      <td>Set Me Free: Retribution</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9559888</th>\n",
       "      <td>PlayBoy (and the Gang of Cherry)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9584830</th>\n",
       "      <td>Dark Intentions: The Movie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9596638</th>\n",
       "      <td>The Big Shot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9742422</th>\n",
       "      <td>Savage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9816258</th>\n",
       "      <td>Joyland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9817070</th>\n",
       "      <td>6.5 Toman Per Meter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9904066</th>\n",
       "      <td>Fox Hunting</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1479 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    primary_title\n",
       "tconst                                           \n",
       "tt0063540                               Sunghursh\n",
       "tt0315642                                   Wazir\n",
       "tt0365907             A Walk Among the Tombstones\n",
       "tt0372538                                     Spy\n",
       "tt0411951                                  Tekken\n",
       "tt0423474                           Venus & Vegas\n",
       "tt0455944                           The Equalizer\n",
       "tt0464032             Guns, Drugs and Dirty Money\n",
       "tt0464162                            Komaram Puli\n",
       "tt0469021                          Alan Partridge\n",
       "tt0471042                             Tower Heist\n",
       "tt0472399                            The Mechanic\n",
       "tt0480255                              The Losers\n",
       "tt0490847                              Double Tap\n",
       "tt0493405                                   CHIPS\n",
       "tt0790724                            Jack Reacher\n",
       "tt0817545                        The Power of Few\n",
       "tt0835775                          Electric Slide\n",
       "tt0847180                                    Loot\n",
       "tt0857190                             The Sweeney\n",
       "tt0873886                               Red State\n",
       "tt0896872                       The Whistleblower\n",
       "tt0903036                       Westbrick Murders\n",
       "tt0934981                              The Waiter\n",
       "tt0960827   Private Security Officer: Los Angeles\n",
       "tt0975738                            Sinatra Club\n",
       "tt0985694                                 Machete\n",
       "tt0990407                        The Green Hornet\n",
       "tt0995845                             The Courier\n",
       "tt10017680                                P Storm\n",
       "...                                           ...\n",
       "tt8820540                                 Bostrom\n",
       "tt8836988                              Avengement\n",
       "tt8858420                        Women of Mafia 2\n",
       "tt8869530                         Keita Never Die\n",
       "tt8898254                       Money Is Our Goal\n",
       "tt8961674                       School Chalega..!\n",
       "tt8972280                  I'll See What I Can Do\n",
       "tt9009056                                 Ksatria\n",
       "tt9109794                              Kolaigaran\n",
       "tt9144712                     Jack Boiz The Movie\n",
       "tt9146260                           Hell Is Empty\n",
       "tt9174410                                Koodasha\n",
       "tt9179256                                 Mix-ups\n",
       "tt9183176                       Don of the Damned\n",
       "tt9225192                             Unstoppable\n",
       "tt9233940                               Toxic Man\n",
       "tt9293562                                DeSorrow\n",
       "tt9347622                       Such a Funny Life\n",
       "tt9426186                                Revenger\n",
       "tt9447662                Suspended Inspector Boro\n",
       "tt9481630                        The lolipop Gang\n",
       "tt9531344                                  Appavi\n",
       "tt9553374                Set Me Free: Retribution\n",
       "tt9559888        PlayBoy (and the Gang of Cherry)\n",
       "tt9584830              Dark Intentions: The Movie\n",
       "tt9596638                            The Big Shot\n",
       "tt9742422                                  Savage\n",
       "tt9816258                                 Joyland\n",
       "tt9817070                     6.5 Toman Per Meter\n",
       "tt9904066                             Fox Hunting\n",
       "\n",
       "[1479 rows x 1 columns]"
      ]
     },
     "execution_count": 159,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb_genre_df[imdb_genre_df.genre == 'Crime'][['primary_title']].loc[imdb_genre_df[imdb_genre_df.genre == 'Action'].index].dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "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>primary_title</th>\n",
       "      <th>original_title</th>\n",
       "      <th>start_year</th>\n",
       "      <th>runtime_minutes</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tconst</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>tt0063540</th>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>Sunghursh</td>\n",
       "      <td>2013</td>\n",
       "      <td>175.0</td>\n",
       "      <td>[Action, Crime, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0066787</th>\n",
       "      <td>One Day Before the Rainy Season</td>\n",
       "      <td>Ashad Ka Ek Din</td>\n",
       "      <td>2019</td>\n",
       "      <td>114.0</td>\n",
       "      <td>[Biography, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0069049</th>\n",
       "      <td>The Other Side of the Wind</td>\n",
       "      <td>The Other Side of the Wind</td>\n",
       "      <td>2018</td>\n",
       "      <td>122.0</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0069204</th>\n",
       "      <td>Sabse Bada Sukh</td>\n",
       "      <td>Sabse Bada Sukh</td>\n",
       "      <td>2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0100275</th>\n",
       "      <td>The Wandering Soap Opera</td>\n",
       "      <td>La Telenovela Errante</td>\n",
       "      <td>2017</td>\n",
       "      <td>80.0</td>\n",
       "      <td>[Comedy, Drama, Fantasy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0111414</th>\n",
       "      <td>A Thin Life</td>\n",
       "      <td>A Thin Life</td>\n",
       "      <td>2018</td>\n",
       "      <td>75.0</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0112502</th>\n",
       "      <td>Bigfoot</td>\n",
       "      <td>Bigfoot</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Horror, Thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0137204</th>\n",
       "      <td>Joe Finds Grace</td>\n",
       "      <td>Joe Finds Grace</td>\n",
       "      <td>2017</td>\n",
       "      <td>83.0</td>\n",
       "      <td>[Adventure, Animation, Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0139613</th>\n",
       "      <td>O Silêncio</td>\n",
       "      <td>O Silêncio</td>\n",
       "      <td>2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Documentary, History]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0144449</th>\n",
       "      <td>Nema aviona za Zagreb</td>\n",
       "      <td>Nema aviona za Zagreb</td>\n",
       "      <td>2012</td>\n",
       "      <td>82.0</td>\n",
       "      <td>[Biography]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0146592</th>\n",
       "      <td>Pál Adrienn</td>\n",
       "      <td>Pál Adrienn</td>\n",
       "      <td>2010</td>\n",
       "      <td>136.0</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0154039</th>\n",
       "      <td>So Much for Justice!</td>\n",
       "      <td>Oda az igazság</td>\n",
       "      <td>2010</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[History]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0159369</th>\n",
       "      <td>Cooper and Hemingway: The True Gen</td>\n",
       "      <td>Cooper and Hemingway: The True Gen</td>\n",
       "      <td>2013</td>\n",
       "      <td>180.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0162942</th>\n",
       "      <td>Children of the Green Dragon</td>\n",
       "      <td>A zöld sárkány gyermekei</td>\n",
       "      <td>2010</td>\n",
       "      <td>89.0</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0170651</th>\n",
       "      <td>T.G.M. - osvoboditel</td>\n",
       "      <td>T.G.M. - osvoboditel</td>\n",
       "      <td>2018</td>\n",
       "      <td>60.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0176694</th>\n",
       "      <td>The Tragedy of Man</td>\n",
       "      <td>Az ember tragédiája</td>\n",
       "      <td>2011</td>\n",
       "      <td>160.0</td>\n",
       "      <td>[Animation, Drama, History]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0187902</th>\n",
       "      <td>How Huang Fei-hong Rescued the Orphan from the...</td>\n",
       "      <td>How Huang Fei-hong Rescued the Orphan from the...</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0192528</th>\n",
       "      <td>Heaven &amp; Hell</td>\n",
       "      <td>Reverse Heaven</td>\n",
       "      <td>2018</td>\n",
       "      <td>104.0</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0230212</th>\n",
       "      <td>The Final Journey</td>\n",
       "      <td>The Final Journey</td>\n",
       "      <td>2010</td>\n",
       "      <td>120.0</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0247643</th>\n",
       "      <td>Los pájaros se van con la muerte</td>\n",
       "      <td>Los pájaros se van con la muerte</td>\n",
       "      <td>2011</td>\n",
       "      <td>110.0</td>\n",
       "      <td>[Drama, Mystery]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0249516</th>\n",
       "      <td>Foodfight!</td>\n",
       "      <td>Foodfight!</td>\n",
       "      <td>2012</td>\n",
       "      <td>91.0</td>\n",
       "      <td>[Action, Animation, Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0250404</th>\n",
       "      <td>Godfather</td>\n",
       "      <td>Godfather</td>\n",
       "      <td>2012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Crime, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0253093</th>\n",
       "      <td>Gangavataran</td>\n",
       "      <td>Gangavataran</td>\n",
       "      <td>2018</td>\n",
       "      <td>134.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0255820</th>\n",
       "      <td>Return to Babylon</td>\n",
       "      <td>Return to Babylon</td>\n",
       "      <td>2013</td>\n",
       "      <td>75.0</td>\n",
       "      <td>[Biography, Comedy, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0262218</th>\n",
       "      <td>Akakis mogzauroba</td>\n",
       "      <td>Akakis mogzauroba</td>\n",
       "      <td>2012</td>\n",
       "      <td>44.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0262759</th>\n",
       "      <td>Seven Jews from My Class</td>\n",
       "      <td>Siedmiu Zydów z mojej klasy</td>\n",
       "      <td>2018</td>\n",
       "      <td>40.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0263814</th>\n",
       "      <td>On kadin</td>\n",
       "      <td>On kadin</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0276568</th>\n",
       "      <td>To Chase a Million</td>\n",
       "      <td>To Chase a Million</td>\n",
       "      <td>2018</td>\n",
       "      <td>97.0</td>\n",
       "      <td>[Action, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0277964</th>\n",
       "      <td>Prague: The Restless Heart of Europe</td>\n",
       "      <td>Praha - neklidné srdce Evropy</td>\n",
       "      <td>2018</td>\n",
       "      <td>59.0</td>\n",
       "      <td>[Documentary, History]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt0283440</th>\n",
       "      <td>Short Time Heroes</td>\n",
       "      <td>Kurzzeithelden</td>\n",
       "      <td>2015</td>\n",
       "      <td>45.0</td>\n",
       "      <td>[Sci-Fi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9913056</th>\n",
       "      <td>Swarm Season</td>\n",
       "      <td>Swarm Season</td>\n",
       "      <td>2019</td>\n",
       "      <td>86.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9913084</th>\n",
       "      <td>Diabolik sono io</td>\n",
       "      <td>Diabolik sono io</td>\n",
       "      <td>2019</td>\n",
       "      <td>75.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9913248</th>\n",
       "      <td>Nepal - Homebird</td>\n",
       "      <td>Nepal - Homebird</td>\n",
       "      <td>2019</td>\n",
       "      <td>52.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9913418</th>\n",
       "      <td>Fragments</td>\n",
       "      <td>Fragments</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Drama, Mystery, Sci-Fi]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9913572</th>\n",
       "      <td>Marley G Documentary</td>\n",
       "      <td>Marley G Documentary</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9913594</th>\n",
       "      <td>Bacchanalia</td>\n",
       "      <td>Bacchanalia</td>\n",
       "      <td>2017</td>\n",
       "      <td>72.0</td>\n",
       "      <td>[Drama, Mystery, Thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9913936</th>\n",
       "      <td>Paradise</td>\n",
       "      <td>Paradise</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Crime, Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914254</th>\n",
       "      <td>A Cherry Tale</td>\n",
       "      <td>Kirsebæreventyret</td>\n",
       "      <td>2019</td>\n",
       "      <td>85.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914286</th>\n",
       "      <td>Sokagin Çocuklari</td>\n",
       "      <td>Sokagin Çocuklari</td>\n",
       "      <td>2019</td>\n",
       "      <td>98.0</td>\n",
       "      <td>[Drama, Family]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914368</th>\n",
       "      <td>Kuttram Seiyel</td>\n",
       "      <td>Kuttram Seiyel</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Action, Crime]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914522</th>\n",
       "      <td>The Holden Family Plan</td>\n",
       "      <td>The Holden Family Plan</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Drama, Family]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914642</th>\n",
       "      <td>Albatross</td>\n",
       "      <td>Albatross</td>\n",
       "      <td>2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914644</th>\n",
       "      <td>9/11: Escape from the Towers</td>\n",
       "      <td>9/11: Escape from the Towers</td>\n",
       "      <td>2018</td>\n",
       "      <td>120.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914662</th>\n",
       "      <td>Wien is 't Hof van Commerce</td>\n",
       "      <td>Wien is 't Hof van Commerce</td>\n",
       "      <td>2018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914828</th>\n",
       "      <td>The War of Godzilla</td>\n",
       "      <td>The War of Godzilla</td>\n",
       "      <td>2015</td>\n",
       "      <td>102.0</td>\n",
       "      <td>[Action, Comedy, Family]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9914942</th>\n",
       "      <td>La vida sense la Sara Amat</td>\n",
       "      <td>La vida sense la Sara Amat</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9915436</th>\n",
       "      <td>Vida em Movimento</td>\n",
       "      <td>Vida em Movimento</td>\n",
       "      <td>2019</td>\n",
       "      <td>70.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9915790</th>\n",
       "      <td>Bobbyr Bondhura</td>\n",
       "      <td>Bobbyr Bondhura</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Family]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9915872</th>\n",
       "      <td>The Last White Witch</td>\n",
       "      <td>The Last White Witch</td>\n",
       "      <td>2019</td>\n",
       "      <td>97.0</td>\n",
       "      <td>[Comedy, Drama, Fantasy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916132</th>\n",
       "      <td>The Mystery of a Buryat Lama</td>\n",
       "      <td>The Mystery of a Buryat Lama</td>\n",
       "      <td>2018</td>\n",
       "      <td>94.0</td>\n",
       "      <td>[Biography, Documentary, History]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916160</th>\n",
       "      <td>Drømmeland</td>\n",
       "      <td>Drømmeland</td>\n",
       "      <td>2019</td>\n",
       "      <td>72.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916170</th>\n",
       "      <td>The Rehearsal</td>\n",
       "      <td>O Ensaio</td>\n",
       "      <td>2019</td>\n",
       "      <td>51.0</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916186</th>\n",
       "      <td>Illenau - die Geschichte einer ehemaligen Heil...</td>\n",
       "      <td>Illenau - die Geschichte einer ehemaligen Heil...</td>\n",
       "      <td>2017</td>\n",
       "      <td>84.0</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916190</th>\n",
       "      <td>Safeguard</td>\n",
       "      <td>Safeguard</td>\n",
       "      <td>2019</td>\n",
       "      <td>90.0</td>\n",
       "      <td>[Drama, Thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916428</th>\n",
       "      <td>The Secret of China</td>\n",
       "      <td>The Secret of China</td>\n",
       "      <td>2019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Adventure, History, War]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916538</th>\n",
       "      <td>Kuambil Lagi Hatiku</td>\n",
       "      <td>Kuambil Lagi Hatiku</td>\n",
       "      <td>2019</td>\n",
       "      <td>123.0</td>\n",
       "      <td>[Drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916622</th>\n",
       "      <td>Rodolpho Teóphilo - O Legado de um Pioneiro</td>\n",
       "      <td>Rodolpho Teóphilo - O Legado de um Pioneiro</td>\n",
       "      <td>2015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916706</th>\n",
       "      <td>Dankyavar Danka</td>\n",
       "      <td>Dankyavar Danka</td>\n",
       "      <td>2013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916730</th>\n",
       "      <td>6 Gunn</td>\n",
       "      <td>6 Gunn</td>\n",
       "      <td>2017</td>\n",
       "      <td>116.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tt9916754</th>\n",
       "      <td>Chico Albuquerque - Revelações</td>\n",
       "      <td>Chico Albuquerque - Revelações</td>\n",
       "      <td>2013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>146144 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               primary_title  \\\n",
       "tconst                                                         \n",
       "tt0063540                                          Sunghursh   \n",
       "tt0066787                    One Day Before the Rainy Season   \n",
       "tt0069049                         The Other Side of the Wind   \n",
       "tt0069204                                    Sabse Bada Sukh   \n",
       "tt0100275                           The Wandering Soap Opera   \n",
       "tt0111414                                        A Thin Life   \n",
       "tt0112502                                            Bigfoot   \n",
       "tt0137204                                    Joe Finds Grace   \n",
       "tt0139613                                         O Silêncio   \n",
       "tt0144449                              Nema aviona za Zagreb   \n",
       "tt0146592                                        Pál Adrienn   \n",
       "tt0154039                               So Much for Justice!   \n",
       "tt0159369                 Cooper and Hemingway: The True Gen   \n",
       "tt0162942                       Children of the Green Dragon   \n",
       "tt0170651                               T.G.M. - osvoboditel   \n",
       "tt0176694                                 The Tragedy of Man   \n",
       "tt0187902  How Huang Fei-hong Rescued the Orphan from the...   \n",
       "tt0192528                                      Heaven & Hell   \n",
       "tt0230212                                  The Final Journey   \n",
       "tt0247643                   Los pájaros se van con la muerte   \n",
       "tt0249516                                         Foodfight!   \n",
       "tt0250404                                          Godfather   \n",
       "tt0253093                                       Gangavataran   \n",
       "tt0255820                                  Return to Babylon   \n",
       "tt0262218                                  Akakis mogzauroba   \n",
       "tt0262759                           Seven Jews from My Class   \n",
       "tt0263814                                           On kadin   \n",
       "tt0276568                                 To Chase a Million   \n",
       "tt0277964               Prague: The Restless Heart of Europe   \n",
       "tt0283440                                  Short Time Heroes   \n",
       "...                                                      ...   \n",
       "tt9913056                                       Swarm Season   \n",
       "tt9913084                                   Diabolik sono io   \n",
       "tt9913248                                   Nepal - Homebird   \n",
       "tt9913418                                          Fragments   \n",
       "tt9913572                               Marley G Documentary   \n",
       "tt9913594                                        Bacchanalia   \n",
       "tt9913936                                           Paradise   \n",
       "tt9914254                                      A Cherry Tale   \n",
       "tt9914286                                  Sokagin Çocuklari   \n",
       "tt9914368                                     Kuttram Seiyel   \n",
       "tt9914522                             The Holden Family Plan   \n",
       "tt9914642                                          Albatross   \n",
       "tt9914644                       9/11: Escape from the Towers   \n",
       "tt9914662                        Wien is 't Hof van Commerce   \n",
       "tt9914828                                The War of Godzilla   \n",
       "tt9914942                         La vida sense la Sara Amat   \n",
       "tt9915436                                  Vida em Movimento   \n",
       "tt9915790                                    Bobbyr Bondhura   \n",
       "tt9915872                               The Last White Witch   \n",
       "tt9916132                       The Mystery of a Buryat Lama   \n",
       "tt9916160                                         Drømmeland   \n",
       "tt9916170                                      The Rehearsal   \n",
       "tt9916186  Illenau - die Geschichte einer ehemaligen Heil...   \n",
       "tt9916190                                          Safeguard   \n",
       "tt9916428                                The Secret of China   \n",
       "tt9916538                                Kuambil Lagi Hatiku   \n",
       "tt9916622        Rodolpho Teóphilo - O Legado de um Pioneiro   \n",
       "tt9916706                                    Dankyavar Danka   \n",
       "tt9916730                                             6 Gunn   \n",
       "tt9916754                     Chico Albuquerque - Revelações   \n",
       "\n",
       "                                              original_title  start_year  \\\n",
       "tconst                                                                     \n",
       "tt0063540                                          Sunghursh        2013   \n",
       "tt0066787                                    Ashad Ka Ek Din        2019   \n",
       "tt0069049                         The Other Side of the Wind        2018   \n",
       "tt0069204                                    Sabse Bada Sukh        2018   \n",
       "tt0100275                              La Telenovela Errante        2017   \n",
       "tt0111414                                        A Thin Life        2018   \n",
       "tt0112502                                            Bigfoot        2017   \n",
       "tt0137204                                    Joe Finds Grace        2017   \n",
       "tt0139613                                         O Silêncio        2012   \n",
       "tt0144449                              Nema aviona za Zagreb        2012   \n",
       "tt0146592                                        Pál Adrienn        2010   \n",
       "tt0154039                                     Oda az igazság        2010   \n",
       "tt0159369                 Cooper and Hemingway: The True Gen        2013   \n",
       "tt0162942                           A zöld sárkány gyermekei        2010   \n",
       "tt0170651                               T.G.M. - osvoboditel        2018   \n",
       "tt0176694                                Az ember tragédiája        2011   \n",
       "tt0187902  How Huang Fei-hong Rescued the Orphan from the...        2011   \n",
       "tt0192528                                     Reverse Heaven        2018   \n",
       "tt0230212                                  The Final Journey        2010   \n",
       "tt0247643                   Los pájaros se van con la muerte        2011   \n",
       "tt0249516                                         Foodfight!        2012   \n",
       "tt0250404                                          Godfather        2012   \n",
       "tt0253093                                       Gangavataran        2018   \n",
       "tt0255820                                  Return to Babylon        2013   \n",
       "tt0262218                                  Akakis mogzauroba        2012   \n",
       "tt0262759                        Siedmiu Zydów z mojej klasy        2018   \n",
       "tt0263814                                           On kadin        2019   \n",
       "tt0276568                                 To Chase a Million        2018   \n",
       "tt0277964                      Praha - neklidné srdce Evropy        2018   \n",
       "tt0283440                                     Kurzzeithelden        2015   \n",
       "...                                                      ...         ...   \n",
       "tt9913056                                       Swarm Season        2019   \n",
       "tt9913084                                   Diabolik sono io        2019   \n",
       "tt9913248                                   Nepal - Homebird        2019   \n",
       "tt9913418                                          Fragments        2019   \n",
       "tt9913572                               Marley G Documentary        2019   \n",
       "tt9913594                                        Bacchanalia        2017   \n",
       "tt9913936                                           Paradise        2019   \n",
       "tt9914254                                  Kirsebæreventyret        2019   \n",
       "tt9914286                                  Sokagin Çocuklari        2019   \n",
       "tt9914368                                     Kuttram Seiyel        2019   \n",
       "tt9914522                             The Holden Family Plan        2019   \n",
       "tt9914642                                          Albatross        2017   \n",
       "tt9914644                       9/11: Escape from the Towers        2018   \n",
       "tt9914662                        Wien is 't Hof van Commerce        2018   \n",
       "tt9914828                                The War of Godzilla        2015   \n",
       "tt9914942                         La vida sense la Sara Amat        2019   \n",
       "tt9915436                                  Vida em Movimento        2019   \n",
       "tt9915790                                    Bobbyr Bondhura        2019   \n",
       "tt9915872                               The Last White Witch        2019   \n",
       "tt9916132                       The Mystery of a Buryat Lama        2018   \n",
       "tt9916160                                         Drømmeland        2019   \n",
       "tt9916170                                           O Ensaio        2019   \n",
       "tt9916186  Illenau - die Geschichte einer ehemaligen Heil...        2017   \n",
       "tt9916190                                          Safeguard        2019   \n",
       "tt9916428                                The Secret of China        2019   \n",
       "tt9916538                                Kuambil Lagi Hatiku        2019   \n",
       "tt9916622        Rodolpho Teóphilo - O Legado de um Pioneiro        2015   \n",
       "tt9916706                                    Dankyavar Danka        2013   \n",
       "tt9916730                                             6 Gunn        2017   \n",
       "tt9916754                     Chico Albuquerque - Revelações        2013   \n",
       "\n",
       "           runtime_minutes                             genres  \n",
       "tconst                                                         \n",
       "tt0063540            175.0             [Action, Crime, Drama]  \n",
       "tt0066787            114.0                 [Biography, Drama]  \n",
       "tt0069049            122.0                            [Drama]  \n",
       "tt0069204              NaN                    [Comedy, Drama]  \n",
       "tt0100275             80.0           [Comedy, Drama, Fantasy]  \n",
       "tt0111414             75.0                           [Comedy]  \n",
       "tt0112502              NaN                 [Horror, Thriller]  \n",
       "tt0137204             83.0     [Adventure, Animation, Comedy]  \n",
       "tt0139613              NaN             [Documentary, History]  \n",
       "tt0144449             82.0                        [Biography]  \n",
       "tt0146592            136.0                            [Drama]  \n",
       "tt0154039            100.0                          [History]  \n",
       "tt0159369            180.0                      [Documentary]  \n",
       "tt0162942             89.0                            [Drama]  \n",
       "tt0170651             60.0                      [Documentary]  \n",
       "tt0176694            160.0        [Animation, Drama, History]  \n",
       "tt0187902              NaN                               None  \n",
       "tt0192528            104.0                            [Drama]  \n",
       "tt0230212            120.0                            [Drama]  \n",
       "tt0247643            110.0                   [Drama, Mystery]  \n",
       "tt0249516             91.0        [Action, Animation, Comedy]  \n",
       "tt0250404              NaN                     [Crime, Drama]  \n",
       "tt0253093            134.0                               None  \n",
       "tt0255820             75.0         [Biography, Comedy, Drama]  \n",
       "tt0262218             44.0                      [Documentary]  \n",
       "tt0262759             40.0                      [Documentary]  \n",
       "tt0263814              NaN                            [Drama]  \n",
       "tt0276568             97.0                    [Action, Drama]  \n",
       "tt0277964             59.0             [Documentary, History]  \n",
       "tt0283440             45.0                           [Sci-Fi]  \n",
       "...                    ...                                ...  \n",
       "tt9913056             86.0                      [Documentary]  \n",
       "tt9913084             75.0                      [Documentary]  \n",
       "tt9913248             52.0                      [Documentary]  \n",
       "tt9913418              NaN           [Drama, Mystery, Sci-Fi]  \n",
       "tt9913572              NaN                      [Documentary]  \n",
       "tt9913594             72.0         [Drama, Mystery, Thriller]  \n",
       "tt9913936              NaN                     [Crime, Drama]  \n",
       "tt9914254             85.0                      [Documentary]  \n",
       "tt9914286             98.0                    [Drama, Family]  \n",
       "tt9914368              NaN                    [Action, Crime]  \n",
       "tt9914522              NaN                    [Drama, Family]  \n",
       "tt9914642              NaN                      [Documentary]  \n",
       "tt9914644            120.0                      [Documentary]  \n",
       "tt9914662              NaN                           [Comedy]  \n",
       "tt9914828            102.0           [Action, Comedy, Family]  \n",
       "tt9914942              NaN                               None  \n",
       "tt9915436             70.0                      [Documentary]  \n",
       "tt9915790              NaN                           [Family]  \n",
       "tt9915872             97.0           [Comedy, Drama, Fantasy]  \n",
       "tt9916132             94.0  [Biography, Documentary, History]  \n",
       "tt9916160             72.0                      [Documentary]  \n",
       "tt9916170             51.0                            [Drama]  \n",
       "tt9916186             84.0                      [Documentary]  \n",
       "tt9916190             90.0                  [Drama, Thriller]  \n",
       "tt9916428              NaN          [Adventure, History, War]  \n",
       "tt9916538            123.0                            [Drama]  \n",
       "tt9916622              NaN                      [Documentary]  \n",
       "tt9916706              NaN                           [Comedy]  \n",
       "tt9916730            116.0                               None  \n",
       "tt9916754              NaN                      [Documentary]  \n",
       "\n",
       "[146144 rows x 5 columns]"
      ]
     },
     "execution_count": 162,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "importlib.reload(split_data_fields)\n",
    "from split_data_fields import multifield_to_list\n",
    "multifield_to_list(dfs['imdb.title.basics'],'genres')"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}