new_dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "from computer_vision.main import poster_analysis\n",
    "from audio.main import audiofy\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "bechdel_df = pd.read_json(\"audio/bechdel_data.json\")\n",
    "imdb_df = pd.read_json(\"audio/tmdb_data.json\")\n",
    "imdb_df[\"imdb_id\"] = imdb_df[\"imdb_id\"].apply(lambda x: x[2:])\n",
    "merged_df = pd.merge(\n",
    "    bechdel_df, imdb_df, left_on=\"imdbid\", right_on=\"imdb_id\"\n",
    ").sample(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 20/20 [02:06<00:00,  6.34s/it]\n"
     ]
    }
   ],
   "source": [
    "df = poster_analysis(merged_df)"
   ]
  },
  {
   "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>year</th>\n",
       "      <th>title_x</th>\n",
       "      <th>imdbid</th>\n",
       "      <th>id_x</th>\n",
       "      <th>rating</th>\n",
       "      <th>adult</th>\n",
       "      <th>backdrop_path</th>\n",
       "      <th>belongs_to_collection</th>\n",
       "      <th>budget</th>\n",
       "      <th>genres</th>\n",
       "      <th>...</th>\n",
       "      <th>tagline</th>\n",
       "      <th>title_y</th>\n",
       "      <th>video</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>nb_women</th>\n",
       "      <th>nb_men</th>\n",
       "      <th>area_women</th>\n",
       "      <th>area_men</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4116</th>\n",
       "      <td>1995</td>\n",
       "      <td>Dolores Claiborne</td>\n",
       "      <td>0109642</td>\n",
       "      <td>2394</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/9vJ57nbL4hWJrmsyjKTxiGXqrBU.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 80, 'name': 'Crime'}, {'id': 18, 'name...</td>\n",
       "      <td>...</td>\n",
       "      <td>Sometimes, an accident can be an unhappy woman...</td>\n",
       "      <td>Dolores Claiborne</td>\n",
       "      <td>False</td>\n",
       "      <td>7.2</td>\n",
       "      <td>553</td>\n",
       "      <td>0109642</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.152320</td>\n",
       "      <td>0.136901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7807</th>\n",
       "      <td>1966</td>\n",
       "      <td>A Big Hand for the Little Lady</td>\n",
       "      <td>0060165</td>\n",
       "      <td>2696</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/4kMhrn6zR4FNrLJ67eY4b93cRdC.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 37, 'name': 'Western'}]</td>\n",
       "      <td>...</td>\n",
       "      <td>All the action you can take...all the adventur...</td>\n",
       "      <td>A Big Hand for the Little Lady</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>50</td>\n",
       "      <td>0060165</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.006192</td>\n",
       "      <td>0.012344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5585</th>\n",
       "      <td>2011</td>\n",
       "      <td>Apart</td>\n",
       "      <td>1525552</td>\n",
       "      <td>4242</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 53, 'name...</td>\n",
       "      <td>...</td>\n",
       "      <td>Damned Together. Condemned By Fate.</td>\n",
       "      <td>Apart</td>\n",
       "      <td>False</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1525552</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.014264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3366</th>\n",
       "      <td>2015</td>\n",
       "      <td>Sunset Song</td>\n",
       "      <td>2262161</td>\n",
       "      <td>6928</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/oMvovUVMe7HIvPsZxq23cBdLwZB.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}]</td>\n",
       "      <td>...</td>\n",
       "      <td>An epic story of love, loss and the land that ...</td>\n",
       "      <td>Sunset Song</td>\n",
       "      <td>False</td>\n",
       "      <td>6.3</td>\n",
       "      <td>80</td>\n",
       "      <td>2262161</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.008101</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3247</th>\n",
       "      <td>1985</td>\n",
       "      <td>Agnes of God</td>\n",
       "      <td>0088683</td>\n",
       "      <td>602</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/OAxqslLEzlBF8eT8KcfO4EqQko.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 9648, 'na...</td>\n",
       "      <td>...</td>\n",
       "      <td>That night, murder wasn't the only sin.</td>\n",
       "      <td>Agnes of God</td>\n",
       "      <td>False</td>\n",
       "      <td>6.3</td>\n",
       "      <td>92</td>\n",
       "      <td>0088683</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.141664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>1989</td>\n",
       "      <td>Leningrad Cowboys Go America</td>\n",
       "      <td>0097728</td>\n",
       "      <td>4646</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>/kevyDBlyEJvQOPGd0b3BbtPKqrK.jpg</td>\n",
       "      <td>{'id': 187736, 'name': 'Leningrad Cowboys Coll...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 10402, '...</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>Leningrad Cowboys Go America</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>108</td>\n",
       "      <td>0097728</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.148176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045</th>\n",
       "      <td>2005</td>\n",
       "      <td>Elizabethtown</td>\n",
       "      <td>0368709</td>\n",
       "      <td>8908</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/cx2nwab4wKPpmQ9uacgBU7jJfEp.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>57000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>It's a heck of a place to find yourself</td>\n",
       "      <td>Elizabethtown</td>\n",
       "      <td>False</td>\n",
       "      <td>6.2</td>\n",
       "      <td>907</td>\n",
       "      <td>0368709</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.009045</td>\n",
       "      <td>0.010155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2465</th>\n",
       "      <td>2013</td>\n",
       "      <td>White Lies</td>\n",
       "      <td>2386257</td>\n",
       "      <td>8629</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 36, 'name...</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>White Lies</td>\n",
       "      <td>False</td>\n",
       "      <td>5.8</td>\n",
       "      <td>4</td>\n",
       "      <td>2386257</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5297</th>\n",
       "      <td>2001</td>\n",
       "      <td>Elvira&amp;#39;s Haunted Hills</td>\n",
       "      <td>0265171</td>\n",
       "      <td>4403</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/yVGbzNoKaeicVkl2ilqmEzr7MYh.jpg</td>\n",
       "      <td>{'id': 182617, 'name': 'Elvira Collection', 'p...</td>\n",
       "      <td>1500000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 27, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>Elvira's Haunted Hills</td>\n",
       "      <td>False</td>\n",
       "      <td>5.4</td>\n",
       "      <td>76</td>\n",
       "      <td>0265171</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.018549</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>2001</td>\n",
       "      <td>Sweet November</td>\n",
       "      <td>0230838</td>\n",
       "      <td>8533</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/lDtmwXg6nknzViEQ5SDkk4D1WEZ.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>40000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td>She Just Needed A Month To Change His Life For...</td>\n",
       "      <td>Sweet November</td>\n",
       "      <td>False</td>\n",
       "      <td>6.9</td>\n",
       "      <td>1052</td>\n",
       "      <td>0230838</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.164736</td>\n",
       "      <td>0.288083</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5393</th>\n",
       "      <td>2010</td>\n",
       "      <td>Wolfman, The</td>\n",
       "      <td>0780653</td>\n",
       "      <td>717</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/juIHQJjA9ByHQcG63Hy5eJbVMbc.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>150000000</td>\n",
       "      <td>[{'id': 27, 'name': 'Horror'}, {'id': 36, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>When the moon is full the legend comes to life</td>\n",
       "      <td>The Wolfman</td>\n",
       "      <td>False</td>\n",
       "      <td>5.8</td>\n",
       "      <td>1586</td>\n",
       "      <td>0780653</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1994</th>\n",
       "      <td>2013</td>\n",
       "      <td>Riley Rewind</td>\n",
       "      <td>2944454</td>\n",
       "      <td>4953</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 14, 'name': 'Fantasy'}]</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>Riley Rewind</td>\n",
       "      <td>False</td>\n",
       "      <td>6.8</td>\n",
       "      <td>13</td>\n",
       "      <td>2944454</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4479</th>\n",
       "      <td>2021</td>\n",
       "      <td>French Dispatch, The</td>\n",
       "      <td>8847712</td>\n",
       "      <td>10115</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/u4Vm8n0suBYimsUoarqMw5vxNU8.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>25000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>The French Dispatch</td>\n",
       "      <td>False</td>\n",
       "      <td>7.2</td>\n",
       "      <td>1343</td>\n",
       "      <td>8847712</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2922</th>\n",
       "      <td>2013</td>\n",
       "      <td>Kill Your Darlings</td>\n",
       "      <td>1311071</td>\n",
       "      <td>5362</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/lkQ5ZZsCrQ1S7TOzujXM2Ct7NvZ.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>1030064</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td>A true story of obsession and murder.</td>\n",
       "      <td>Kill Your Darlings</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>1165</td>\n",
       "      <td>1311071</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.360363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2774</th>\n",
       "      <td>1969</td>\n",
       "      <td>Support Your Local Sheriff!</td>\n",
       "      <td>0065051</td>\n",
       "      <td>1100</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/nWe91B0iGdOc12cGB7Pks4HiKId.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 37, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>Bad men... Bad ladies... Bad horses...</td>\n",
       "      <td>Support Your Local Sheriff!</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>126</td>\n",
       "      <td>0065051</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.069021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7821</th>\n",
       "      <td>2002</td>\n",
       "      <td>Tuck Everlasting</td>\n",
       "      <td>0283084</td>\n",
       "      <td>1529</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/5u3UyWBGbTBV6yzt13Ahj9AbS45.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>15000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10751, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td>If you could choose to live forever, would you?</td>\n",
       "      <td>Tuck Everlasting</td>\n",
       "      <td>False</td>\n",
       "      <td>6.6</td>\n",
       "      <td>382</td>\n",
       "      <td>0283084</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0.077083</td>\n",
       "      <td>0.107925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4172</th>\n",
       "      <td>1966</td>\n",
       "      <td>Cathy Come Home</td>\n",
       "      <td>0059020</td>\n",
       "      <td>2855</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10770, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>Cathy Come Home</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>20</td>\n",
       "      <td>0059020</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.002613</td>\n",
       "      <td>0.007096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6783</th>\n",
       "      <td>2021</td>\n",
       "      <td>Kissing Booth 3, The</td>\n",
       "      <td>12783454</td>\n",
       "      <td>10050</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/oOZM1C3wZtsZtdidVgEazeas7U4.jpg</td>\n",
       "      <td>{'id': 726619, 'name': 'The Kissing Booth Coll...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 10749, 'name': 'Romance'}, {'id': 35, ...</td>\n",
       "      <td>...</td>\n",
       "      <td>The end of an era. The beginning of everything...</td>\n",
       "      <td>The Kissing Booth 3</td>\n",
       "      <td>False</td>\n",
       "      <td>7.2</td>\n",
       "      <td>1369</td>\n",
       "      <td>12783454</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.016704</td>\n",
       "      <td>0.036608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>1985</td>\n",
       "      <td>Weird Science</td>\n",
       "      <td>0090305</td>\n",
       "      <td>520</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/7386slmhA9YqwU2Fbi9X1sIQsPx.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>7500000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 10749, '...</td>\n",
       "      <td>...</td>\n",
       "      <td>If you can't get a date, make one!</td>\n",
       "      <td>Weird Science</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>1065</td>\n",
       "      <td>0090305</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.025136</td>\n",
       "      <td>0.009901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5665</th>\n",
       "      <td>2010</td>\n",
       "      <td>Steam of Life</td>\n",
       "      <td>1583323</td>\n",
       "      <td>2337</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>580000</td>\n",
       "      <td>[{'id': 99, 'name': 'Documentary'}]</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td>Steam of Life</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>28</td>\n",
       "      <td>1583323</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.017755</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      year                         title_x    imdbid   id_x  rating  adult  \\\n",
       "4116  1995               Dolores Claiborne   0109642   2394       3  False   \n",
       "7807  1966  A Big Hand for the Little Lady   0060165   2696       1  False   \n",
       "5585  2011                           Apart   1525552   4242       3  False   \n",
       "3366  2015                     Sunset Song   2262161   6928       3  False   \n",
       "3247  1985                    Agnes of God   0088683    602       3  False   \n",
       "1654  1989    Leningrad Cowboys Go America   0097728   4646       0  False   \n",
       "2045  2005                   Elizabethtown   0368709   8908       3  False   \n",
       "2465  2013                      White Lies   2386257   8629       3  False   \n",
       "5297  2001      Elvira&#39;s Haunted Hills   0265171   4403       3  False   \n",
       "806   2001                  Sweet November   0230838   8533       1  False   \n",
       "5393  2010                    Wolfman, The   0780653    717       1  False   \n",
       "1994  2013                    Riley Rewind   2944454   4953       3  False   \n",
       "4479  2021            French Dispatch, The   8847712  10115       3  False   \n",
       "2922  2013              Kill Your Darlings   1311071   5362       1  False   \n",
       "2774  1969     Support Your Local Sheriff!   0065051   1100       1  False   \n",
       "7821  2002                Tuck Everlasting   0283084   1529       3  False   \n",
       "4172  1966                 Cathy Come Home   0059020   2855       3  False   \n",
       "6783  2021            Kissing Booth 3, The  12783454  10050       3  False   \n",
       "160   1985                   Weird Science   0090305    520       3  False   \n",
       "5665  2010                   Steam of Life   1583323   2337       0  False   \n",
       "\n",
       "                         backdrop_path  \\\n",
       "4116  /9vJ57nbL4hWJrmsyjKTxiGXqrBU.jpg   \n",
       "7807  /4kMhrn6zR4FNrLJ67eY4b93cRdC.jpg   \n",
       "5585                              None   \n",
       "3366  /oMvovUVMe7HIvPsZxq23cBdLwZB.jpg   \n",
       "3247   /OAxqslLEzlBF8eT8KcfO4EqQko.jpg   \n",
       "1654  /kevyDBlyEJvQOPGd0b3BbtPKqrK.jpg   \n",
       "2045  /cx2nwab4wKPpmQ9uacgBU7jJfEp.jpg   \n",
       "2465                              None   \n",
       "5297  /yVGbzNoKaeicVkl2ilqmEzr7MYh.jpg   \n",
       "806   /lDtmwXg6nknzViEQ5SDkk4D1WEZ.jpg   \n",
       "5393  /juIHQJjA9ByHQcG63Hy5eJbVMbc.jpg   \n",
       "1994                              None   \n",
       "4479  /u4Vm8n0suBYimsUoarqMw5vxNU8.jpg   \n",
       "2922  /lkQ5ZZsCrQ1S7TOzujXM2Ct7NvZ.jpg   \n",
       "2774  /nWe91B0iGdOc12cGB7Pks4HiKId.jpg   \n",
       "7821  /5u3UyWBGbTBV6yzt13Ahj9AbS45.jpg   \n",
       "4172                              None   \n",
       "6783  /oOZM1C3wZtsZtdidVgEazeas7U4.jpg   \n",
       "160   /7386slmhA9YqwU2Fbi9X1sIQsPx.jpg   \n",
       "5665                              None   \n",
       "\n",
       "                                  belongs_to_collection     budget  \\\n",
       "4116                                               None          0   \n",
       "7807                                               None          0   \n",
       "5585                                               None          0   \n",
       "3366                                               None          0   \n",
       "3247                                               None          0   \n",
       "1654  {'id': 187736, 'name': 'Leningrad Cowboys Coll...          0   \n",
       "2045                                               None   57000000   \n",
       "2465                                               None          0   \n",
       "5297  {'id': 182617, 'name': 'Elvira Collection', 'p...    1500000   \n",
       "806                                                None   40000000   \n",
       "5393                                               None  150000000   \n",
       "1994                                               None          0   \n",
       "4479                                               None   25000000   \n",
       "2922                                               None    1030064   \n",
       "2774                                               None          0   \n",
       "7821                                               None   15000000   \n",
       "4172                                               None          0   \n",
       "6783  {'id': 726619, 'name': 'The Kissing Booth Coll...          0   \n",
       "160                                                None    7500000   \n",
       "5665                                               None     580000   \n",
       "\n",
       "                                                 genres  ...  \\\n",
       "4116  [{'id': 80, 'name': 'Crime'}, {'id': 18, 'name...  ...   \n",
       "7807                    [{'id': 37, 'name': 'Western'}]  ...   \n",
       "5585  [{'id': 18, 'name': 'Drama'}, {'id': 53, 'name...  ...   \n",
       "3366                      [{'id': 18, 'name': 'Drama'}]  ...   \n",
       "3247  [{'id': 18, 'name': 'Drama'}, {'id': 9648, 'na...  ...   \n",
       "1654  [{'id': 35, 'name': 'Comedy'}, {'id': 10402, '...  ...   \n",
       "2045  [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...  ...   \n",
       "2465  [{'id': 18, 'name': 'Drama'}, {'id': 36, 'name...  ...   \n",
       "5297  [{'id': 35, 'name': 'Comedy'}, {'id': 27, 'nam...  ...   \n",
       "806   [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...  ...   \n",
       "5393  [{'id': 27, 'name': 'Horror'}, {'id': 36, 'nam...  ...   \n",
       "1994                    [{'id': 14, 'name': 'Fantasy'}]  ...   \n",
       "4479  [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...  ...   \n",
       "2922  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...  ...   \n",
       "2774  [{'id': 35, 'name': 'Comedy'}, {'id': 37, 'nam...  ...   \n",
       "7821  [{'id': 18, 'name': 'Drama'}, {'id': 10751, 'n...  ...   \n",
       "4172  [{'id': 18, 'name': 'Drama'}, {'id': 10770, 'n...  ...   \n",
       "6783  [{'id': 10749, 'name': 'Romance'}, {'id': 35, ...  ...   \n",
       "160   [{'id': 35, 'name': 'Comedy'}, {'id': 10749, '...  ...   \n",
       "5665                [{'id': 99, 'name': 'Documentary'}]  ...   \n",
       "\n",
       "                                                tagline  \\\n",
       "4116  Sometimes, an accident can be an unhappy woman...   \n",
       "7807  All the action you can take...all the adventur...   \n",
       "5585                Damned Together. Condemned By Fate.   \n",
       "3366  An epic story of love, loss and the land that ...   \n",
       "3247            That night, murder wasn't the only sin.   \n",
       "1654                                                      \n",
       "2045            It's a heck of a place to find yourself   \n",
       "2465                                                      \n",
       "5297                                                      \n",
       "806   She Just Needed A Month To Change His Life For...   \n",
       "5393     When the moon is full the legend comes to life   \n",
       "1994                                                      \n",
       "4479                                                      \n",
       "2922              A true story of obsession and murder.   \n",
       "2774             Bad men... Bad ladies... Bad horses...   \n",
       "7821    If you could choose to live forever, would you?   \n",
       "4172                                                      \n",
       "6783  The end of an era. The beginning of everything...   \n",
       "160                  If you can't get a date, make one!   \n",
       "5665                                                      \n",
       "\n",
       "                             title_y  video vote_average vote_count   imdb_id  \\\n",
       "4116               Dolores Claiborne  False          7.2        553   0109642   \n",
       "7807  A Big Hand for the Little Lady  False          7.0         50   0060165   \n",
       "5585                           Apart  False          4.0         11   1525552   \n",
       "3366                     Sunset Song  False          6.3         80   2262161   \n",
       "3247                    Agnes of God  False          6.3         92   0088683   \n",
       "1654    Leningrad Cowboys Go America  False          7.0        108   0097728   \n",
       "2045                   Elizabethtown  False          6.2        907   0368709   \n",
       "2465                      White Lies  False          5.8          4   2386257   \n",
       "5297          Elvira's Haunted Hills  False          5.4         76   0265171   \n",
       "806                   Sweet November  False          6.9       1052   0230838   \n",
       "5393                     The Wolfman  False          5.8       1586   0780653   \n",
       "1994                    Riley Rewind  False          6.8         13   2944454   \n",
       "4479             The French Dispatch  False          7.2       1343   8847712   \n",
       "2922              Kill Your Darlings  False          7.1       1165   1311071   \n",
       "2774     Support Your Local Sheriff!  False          7.0        126   0065051   \n",
       "7821                Tuck Everlasting  False          6.6        382   0283084   \n",
       "4172                 Cathy Come Home  False          7.1         20   0059020   \n",
       "6783             The Kissing Booth 3  False          7.2       1369  12783454   \n",
       "160                    Weird Science  False          6.5       1065   0090305   \n",
       "5665                   Steam of Life  False          7.1         28   1583323   \n",
       "\n",
       "      nb_women nb_men area_women  area_men  \n",
       "4116         1      1   0.152320  0.136901  \n",
       "7807         1      2   0.006192  0.012344  \n",
       "5585         0      2   0.000000  0.014264  \n",
       "3366         1      0   0.008101  0.000000  \n",
       "3247         0      1   0.000000  0.141664  \n",
       "1654         0      5   0.000000  0.148176  \n",
       "2045         1      1   0.009045  0.010155  \n",
       "2465         0      0   0.000000  0.000000  \n",
       "5297         1      0   0.018549  0.000000  \n",
       "806          1      2   0.164736  0.288083  \n",
       "5393         0      0   0.000000  0.000000  \n",
       "1994         0      0   0.000000  0.000000  \n",
       "4479         0      4   0.000000  0.001888  \n",
       "2922         0      2   0.000000  0.360363  \n",
       "2774         0      1   0.000000  0.069021  \n",
       "7821         1      3   0.077083  0.107925  \n",
       "4172         1      2   0.002613  0.007096  \n",
       "6783         1      2   0.016704  0.036608  \n",
       "160          2      1   0.025136  0.009901  \n",
       "5665         0      3   0.000000  0.017755  \n",
       "\n",
       "[20 rows x 35 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = audiofy(df)"
   ]
  },
  {
   "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>year</th>\n",
       "      <th>title_x</th>\n",
       "      <th>imdbid</th>\n",
       "      <th>id_x</th>\n",
       "      <th>rating</th>\n",
       "      <th>adult</th>\n",
       "      <th>backdrop_path</th>\n",
       "      <th>belongs_to_collection</th>\n",
       "      <th>budget</th>\n",
       "      <th>genres</th>\n",
       "      <th>...</th>\n",
       "      <th>video</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>nb_women</th>\n",
       "      <th>nb_men</th>\n",
       "      <th>area_women</th>\n",
       "      <th>area_men</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4116</th>\n",
       "      <td>1995</td>\n",
       "      <td>Dolores Claiborne</td>\n",
       "      <td>0109642</td>\n",
       "      <td>2394</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/9vJ57nbL4hWJrmsyjKTxiGXqrBU.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 80, 'name': 'Crime'}, {'id': 18, 'name...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.2</td>\n",
       "      <td>553</td>\n",
       "      <td>0109642</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.152320</td>\n",
       "      <td>0.136901</td>\n",
       "      <td>imdb_id    0109642\n",
       "imdb_id    0109642\n",
       "Name: 41...</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7807</th>\n",
       "      <td>1966</td>\n",
       "      <td>A Big Hand for the Little Lady</td>\n",
       "      <td>0060165</td>\n",
       "      <td>2696</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/4kMhrn6zR4FNrLJ67eY4b93cRdC.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 37, 'name': 'Western'}]</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>50</td>\n",
       "      <td>0060165</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.006192</td>\n",
       "      <td>0.012344</td>\n",
       "      <td>imdb_id    0060165\n",
       "imdb_id    0060165\n",
       "Name: 78...</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5585</th>\n",
       "      <td>2011</td>\n",
       "      <td>Apart</td>\n",
       "      <td>1525552</td>\n",
       "      <td>4242</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 53, 'name...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>4.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1525552</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.014264</td>\n",
       "      <td>imdb_id    1525552\n",
       "imdb_id    1525552\n",
       "Name: 55...</td>\n",
       "      <td>1.591871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3366</th>\n",
       "      <td>2015</td>\n",
       "      <td>Sunset Song</td>\n",
       "      <td>2262161</td>\n",
       "      <td>6928</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/oMvovUVMe7HIvPsZxq23cBdLwZB.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}]</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>6.3</td>\n",
       "      <td>80</td>\n",
       "      <td>2262161</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.008101</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>imdb_id    2262161\n",
       "imdb_id    2262161\n",
       "Name: 33...</td>\n",
       "      <td>0.627178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3247</th>\n",
       "      <td>1985</td>\n",
       "      <td>Agnes of God</td>\n",
       "      <td>0088683</td>\n",
       "      <td>602</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/OAxqslLEzlBF8eT8KcfO4EqQko.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 9648, 'na...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>6.3</td>\n",
       "      <td>92</td>\n",
       "      <td>0088683</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.141664</td>\n",
       "      <td>imdb_id    0088683\n",
       "imdb_id    0088683\n",
       "Name: 32...</td>\n",
       "      <td>0.289136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>1989</td>\n",
       "      <td>Leningrad Cowboys Go America</td>\n",
       "      <td>0097728</td>\n",
       "      <td>4646</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>/kevyDBlyEJvQOPGd0b3BbtPKqrK.jpg</td>\n",
       "      <td>{'id': 187736, 'name': 'Leningrad Cowboys Coll...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 10402, '...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>108</td>\n",
       "      <td>0097728</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.148176</td>\n",
       "      <td>imdb_id    0097728\n",
       "imdb_id    0097728\n",
       "Name: 16...</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045</th>\n",
       "      <td>2005</td>\n",
       "      <td>Elizabethtown</td>\n",
       "      <td>0368709</td>\n",
       "      <td>8908</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/cx2nwab4wKPpmQ9uacgBU7jJfEp.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>57000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>6.2</td>\n",
       "      <td>907</td>\n",
       "      <td>0368709</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.009045</td>\n",
       "      <td>0.010155</td>\n",
       "      <td>imdb_id    0368709\n",
       "imdb_id    0368709\n",
       "Name: 20...</td>\n",
       "      <td>1.117808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2465</th>\n",
       "      <td>2013</td>\n",
       "      <td>White Lies</td>\n",
       "      <td>2386257</td>\n",
       "      <td>8629</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 36, 'name...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>5.8</td>\n",
       "      <td>4</td>\n",
       "      <td>2386257</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>imdb_id    2386257\n",
       "imdb_id    2386257\n",
       "Name: 24...</td>\n",
       "      <td>7.651613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5297</th>\n",
       "      <td>2001</td>\n",
       "      <td>Elvira&amp;#39;s Haunted Hills</td>\n",
       "      <td>0265171</td>\n",
       "      <td>4403</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/yVGbzNoKaeicVkl2ilqmEzr7MYh.jpg</td>\n",
       "      <td>{'id': 182617, 'name': 'Elvira Collection', 'p...</td>\n",
       "      <td>1500000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 27, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>5.4</td>\n",
       "      <td>76</td>\n",
       "      <td>0265171</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.018549</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>imdb_id    0265171\n",
       "imdb_id    0265171\n",
       "Name: 52...</td>\n",
       "      <td>0.789016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>2001</td>\n",
       "      <td>Sweet November</td>\n",
       "      <td>0230838</td>\n",
       "      <td>8533</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/lDtmwXg6nknzViEQ5SDkk4D1WEZ.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>40000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>6.9</td>\n",
       "      <td>1052</td>\n",
       "      <td>0230838</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.164736</td>\n",
       "      <td>0.288083</td>\n",
       "      <td>imdb_id    0230838\n",
       "imdb_id    0230838\n",
       "Name: 80...</td>\n",
       "      <td>0.842197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5393</th>\n",
       "      <td>2010</td>\n",
       "      <td>Wolfman, The</td>\n",
       "      <td>0780653</td>\n",
       "      <td>717</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/juIHQJjA9ByHQcG63Hy5eJbVMbc.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>150000000</td>\n",
       "      <td>[{'id': 27, 'name': 'Horror'}, {'id': 36, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>5.8</td>\n",
       "      <td>1586</td>\n",
       "      <td>0780653</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>imdb_id    0780653\n",
       "imdb_id    0780653\n",
       "Name: 53...</td>\n",
       "      <td>0.149215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1994</th>\n",
       "      <td>2013</td>\n",
       "      <td>Riley Rewind</td>\n",
       "      <td>2944454</td>\n",
       "      <td>4953</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 14, 'name': 'Fantasy'}]</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>6.8</td>\n",
       "      <td>13</td>\n",
       "      <td>2944454</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>imdb_id    2944454\n",
       "imdb_id    2944454\n",
       "Name: 19...</td>\n",
       "      <td>0.341530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4479</th>\n",
       "      <td>2021</td>\n",
       "      <td>French Dispatch, The</td>\n",
       "      <td>8847712</td>\n",
       "      <td>10115</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/u4Vm8n0suBYimsUoarqMw5vxNU8.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>25000000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.2</td>\n",
       "      <td>1343</td>\n",
       "      <td>8847712</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.001888</td>\n",
       "      <td>imdb_id    8847712\n",
       "imdb_id    8847712\n",
       "Name: 44...</td>\n",
       "      <td>0.608291</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2922</th>\n",
       "      <td>2013</td>\n",
       "      <td>Kill Your Darlings</td>\n",
       "      <td>1311071</td>\n",
       "      <td>5362</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/lkQ5ZZsCrQ1S7TOzujXM2Ct7NvZ.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>1030064</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>1165</td>\n",
       "      <td>1311071</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.360363</td>\n",
       "      <td>imdb_id    1311071\n",
       "imdb_id    1311071\n",
       "Name: 29...</td>\n",
       "      <td>0.314246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2774</th>\n",
       "      <td>1969</td>\n",
       "      <td>Support Your Local Sheriff!</td>\n",
       "      <td>0065051</td>\n",
       "      <td>1100</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>/nWe91B0iGdOc12cGB7Pks4HiKId.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 37, 'nam...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>126</td>\n",
       "      <td>0065051</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.069021</td>\n",
       "      <td>imdb_id    0065051\n",
       "imdb_id    0065051\n",
       "Name: 27...</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7821</th>\n",
       "      <td>2002</td>\n",
       "      <td>Tuck Everlasting</td>\n",
       "      <td>0283084</td>\n",
       "      <td>1529</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/5u3UyWBGbTBV6yzt13Ahj9AbS45.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>15000000</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10751, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>6.6</td>\n",
       "      <td>382</td>\n",
       "      <td>0283084</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0.077083</td>\n",
       "      <td>0.107925</td>\n",
       "      <td>imdb_id    0283084\n",
       "imdb_id    0283084\n",
       "Name: 78...</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4172</th>\n",
       "      <td>1966</td>\n",
       "      <td>Cathy Come Home</td>\n",
       "      <td>0059020</td>\n",
       "      <td>2855</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 18, 'name': 'Drama'}, {'id': 10770, 'n...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>20</td>\n",
       "      <td>0059020</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.002613</td>\n",
       "      <td>0.007096</td>\n",
       "      <td>imdb_id    0059020\n",
       "imdb_id    0059020\n",
       "Name: 41...</td>\n",
       "      <td>0.188907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6783</th>\n",
       "      <td>2021</td>\n",
       "      <td>Kissing Booth 3, The</td>\n",
       "      <td>12783454</td>\n",
       "      <td>10050</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/oOZM1C3wZtsZtdidVgEazeas7U4.jpg</td>\n",
       "      <td>{'id': 726619, 'name': 'The Kissing Booth Coll...</td>\n",
       "      <td>0</td>\n",
       "      <td>[{'id': 10749, 'name': 'Romance'}, {'id': 35, ...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.2</td>\n",
       "      <td>1369</td>\n",
       "      <td>12783454</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.016704</td>\n",
       "      <td>0.036608</td>\n",
       "      <td>imdb_id    12783454\n",
       "imdb_id    12783454\n",
       "Name: ...</td>\n",
       "      <td>2.447939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>1985</td>\n",
       "      <td>Weird Science</td>\n",
       "      <td>0090305</td>\n",
       "      <td>520</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>/7386slmhA9YqwU2Fbi9X1sIQsPx.jpg</td>\n",
       "      <td>None</td>\n",
       "      <td>7500000</td>\n",
       "      <td>[{'id': 35, 'name': 'Comedy'}, {'id': 10749, '...</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>6.5</td>\n",
       "      <td>1065</td>\n",
       "      <td>0090305</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0.025136</td>\n",
       "      <td>0.009901</td>\n",
       "      <td>imdb_id    0090305\n",
       "imdb_id    0090305\n",
       "Name: 16...</td>\n",
       "      <td>0.350692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5665</th>\n",
       "      <td>2010</td>\n",
       "      <td>Steam of Life</td>\n",
       "      <td>1583323</td>\n",
       "      <td>2337</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>580000</td>\n",
       "      <td>[{'id': 99, 'name': 'Documentary'}]</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>7.1</td>\n",
       "      <td>28</td>\n",
       "      <td>1583323</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.017755</td>\n",
       "      <td>imdb_id    1583323\n",
       "imdb_id    1583323\n",
       "Name: 56...</td>\n",
       "      <td>0.551865</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      year                         title_x    imdbid   id_x  rating  adult  \\\n",
       "4116  1995               Dolores Claiborne   0109642   2394       3  False   \n",
       "7807  1966  A Big Hand for the Little Lady   0060165   2696       1  False   \n",
       "5585  2011                           Apart   1525552   4242       3  False   \n",
       "3366  2015                     Sunset Song   2262161   6928       3  False   \n",
       "3247  1985                    Agnes of God   0088683    602       3  False   \n",
       "1654  1989    Leningrad Cowboys Go America   0097728   4646       0  False   \n",
       "2045  2005                   Elizabethtown   0368709   8908       3  False   \n",
       "2465  2013                      White Lies   2386257   8629       3  False   \n",
       "5297  2001      Elvira&#39;s Haunted Hills   0265171   4403       3  False   \n",
       "806   2001                  Sweet November   0230838   8533       1  False   \n",
       "5393  2010                    Wolfman, The   0780653    717       1  False   \n",
       "1994  2013                    Riley Rewind   2944454   4953       3  False   \n",
       "4479  2021            French Dispatch, The   8847712  10115       3  False   \n",
       "2922  2013              Kill Your Darlings   1311071   5362       1  False   \n",
       "2774  1969     Support Your Local Sheriff!   0065051   1100       1  False   \n",
       "7821  2002                Tuck Everlasting   0283084   1529       3  False   \n",
       "4172  1966                 Cathy Come Home   0059020   2855       3  False   \n",
       "6783  2021            Kissing Booth 3, The  12783454  10050       3  False   \n",
       "160   1985                   Weird Science   0090305    520       3  False   \n",
       "5665  2010                   Steam of Life   1583323   2337       0  False   \n",
       "\n",
       "                         backdrop_path  \\\n",
       "4116  /9vJ57nbL4hWJrmsyjKTxiGXqrBU.jpg   \n",
       "7807  /4kMhrn6zR4FNrLJ67eY4b93cRdC.jpg   \n",
       "5585                              None   \n",
       "3366  /oMvovUVMe7HIvPsZxq23cBdLwZB.jpg   \n",
       "3247   /OAxqslLEzlBF8eT8KcfO4EqQko.jpg   \n",
       "1654  /kevyDBlyEJvQOPGd0b3BbtPKqrK.jpg   \n",
       "2045  /cx2nwab4wKPpmQ9uacgBU7jJfEp.jpg   \n",
       "2465                              None   \n",
       "5297  /yVGbzNoKaeicVkl2ilqmEzr7MYh.jpg   \n",
       "806   /lDtmwXg6nknzViEQ5SDkk4D1WEZ.jpg   \n",
       "5393  /juIHQJjA9ByHQcG63Hy5eJbVMbc.jpg   \n",
       "1994                              None   \n",
       "4479  /u4Vm8n0suBYimsUoarqMw5vxNU8.jpg   \n",
       "2922  /lkQ5ZZsCrQ1S7TOzujXM2Ct7NvZ.jpg   \n",
       "2774  /nWe91B0iGdOc12cGB7Pks4HiKId.jpg   \n",
       "7821  /5u3UyWBGbTBV6yzt13Ahj9AbS45.jpg   \n",
       "4172                              None   \n",
       "6783  /oOZM1C3wZtsZtdidVgEazeas7U4.jpg   \n",
       "160   /7386slmhA9YqwU2Fbi9X1sIQsPx.jpg   \n",
       "5665                              None   \n",
       "\n",
       "                                  belongs_to_collection     budget  \\\n",
       "4116                                               None          0   \n",
       "7807                                               None          0   \n",
       "5585                                               None          0   \n",
       "3366                                               None          0   \n",
       "3247                                               None          0   \n",
       "1654  {'id': 187736, 'name': 'Leningrad Cowboys Coll...          0   \n",
       "2045                                               None   57000000   \n",
       "2465                                               None          0   \n",
       "5297  {'id': 182617, 'name': 'Elvira Collection', 'p...    1500000   \n",
       "806                                                None   40000000   \n",
       "5393                                               None  150000000   \n",
       "1994                                               None          0   \n",
       "4479                                               None   25000000   \n",
       "2922                                               None    1030064   \n",
       "2774                                               None          0   \n",
       "7821                                               None   15000000   \n",
       "4172                                               None          0   \n",
       "6783  {'id': 726619, 'name': 'The Kissing Booth Coll...          0   \n",
       "160                                                None    7500000   \n",
       "5665                                               None     580000   \n",
       "\n",
       "                                                 genres  ...  video  \\\n",
       "4116  [{'id': 80, 'name': 'Crime'}, {'id': 18, 'name...  ...  False   \n",
       "7807                    [{'id': 37, 'name': 'Western'}]  ...  False   \n",
       "5585  [{'id': 18, 'name': 'Drama'}, {'id': 53, 'name...  ...  False   \n",
       "3366                      [{'id': 18, 'name': 'Drama'}]  ...  False   \n",
       "3247  [{'id': 18, 'name': 'Drama'}, {'id': 9648, 'na...  ...  False   \n",
       "1654  [{'id': 35, 'name': 'Comedy'}, {'id': 10402, '...  ...  False   \n",
       "2045  [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...  ...  False   \n",
       "2465  [{'id': 18, 'name': 'Drama'}, {'id': 36, 'name...  ...  False   \n",
       "5297  [{'id': 35, 'name': 'Comedy'}, {'id': 27, 'nam...  ...  False   \n",
       "806   [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...  ...  False   \n",
       "5393  [{'id': 27, 'name': 'Horror'}, {'id': 36, 'nam...  ...  False   \n",
       "1994                    [{'id': 14, 'name': 'Fantasy'}]  ...  False   \n",
       "4479  [{'id': 35, 'name': 'Comedy'}, {'id': 18, 'nam...  ...  False   \n",
       "2922  [{'id': 18, 'name': 'Drama'}, {'id': 10749, 'n...  ...  False   \n",
       "2774  [{'id': 35, 'name': 'Comedy'}, {'id': 37, 'nam...  ...  False   \n",
       "7821  [{'id': 18, 'name': 'Drama'}, {'id': 10751, 'n...  ...  False   \n",
       "4172  [{'id': 18, 'name': 'Drama'}, {'id': 10770, 'n...  ...  False   \n",
       "6783  [{'id': 10749, 'name': 'Romance'}, {'id': 35, ...  ...  False   \n",
       "160   [{'id': 35, 'name': 'Comedy'}, {'id': 10749, '...  ...  False   \n",
       "5665                [{'id': 99, 'name': 'Documentary'}]  ...  False   \n",
       "\n",
       "      vote_average vote_count   imdb_id nb_women nb_men  area_women  area_men  \\\n",
       "4116           7.2        553   0109642        1      1    0.152320  0.136901   \n",
       "7807           7.0         50   0060165        1      2    0.006192  0.012344   \n",
       "5585           4.0         11   1525552        0      2    0.000000  0.014264   \n",
       "3366           6.3         80   2262161        1      0    0.008101  0.000000   \n",
       "3247           6.3         92   0088683        0      1    0.000000  0.141664   \n",
       "1654           7.0        108   0097728        0      5    0.000000  0.148176   \n",
       "2045           6.2        907   0368709        1      1    0.009045  0.010155   \n",
       "2465           5.8          4   2386257        0      0    0.000000  0.000000   \n",
       "5297           5.4         76   0265171        1      0    0.018549  0.000000   \n",
       "806            6.9       1052   0230838        1      2    0.164736  0.288083   \n",
       "5393           5.8       1586   0780653        0      0    0.000000  0.000000   \n",
       "1994           6.8         13   2944454        0      0    0.000000  0.000000   \n",
       "4479           7.2       1343   8847712        0      4    0.000000  0.001888   \n",
       "2922           7.1       1165   1311071        0      2    0.000000  0.360363   \n",
       "2774           7.0        126   0065051        0      1    0.000000  0.069021   \n",
       "7821           6.6        382   0283084        1      3    0.077083  0.107925   \n",
       "4172           7.1         20   0059020        1      2    0.002613  0.007096   \n",
       "6783           7.2       1369  12783454        1      2    0.016704  0.036608   \n",
       "160            6.5       1065   0090305        2      1    0.025136  0.009901   \n",
       "5665           7.1         28   1583323        0      3    0.000000  0.017755   \n",
       "\n",
       "                                                imdb_id     ratio  \n",
       "4116  imdb_id    0109642\n",
       "imdb_id    0109642\n",
       "Name: 41...  0.000000  \n",
       "7807  imdb_id    0060165\n",
       "imdb_id    0060165\n",
       "Name: 78...  0.000000  \n",
       "5585  imdb_id    1525552\n",
       "imdb_id    1525552\n",
       "Name: 55...  1.591871  \n",
       "3366  imdb_id    2262161\n",
       "imdb_id    2262161\n",
       "Name: 33...  0.627178  \n",
       "3247  imdb_id    0088683\n",
       "imdb_id    0088683\n",
       "Name: 32...  0.289136  \n",
       "1654  imdb_id    0097728\n",
       "imdb_id    0097728\n",
       "Name: 16...  0.000000  \n",
       "2045  imdb_id    0368709\n",
       "imdb_id    0368709\n",
       "Name: 20...  1.117808  \n",
       "2465  imdb_id    2386257\n",
       "imdb_id    2386257\n",
       "Name: 24...  7.651613  \n",
       "5297  imdb_id    0265171\n",
       "imdb_id    0265171\n",
       "Name: 52...  0.789016  \n",
       "806   imdb_id    0230838\n",
       "imdb_id    0230838\n",
       "Name: 80...  0.842197  \n",
       "5393  imdb_id    0780653\n",
       "imdb_id    0780653\n",
       "Name: 53...  0.149215  \n",
       "1994  imdb_id    2944454\n",
       "imdb_id    2944454\n",
       "Name: 19...  0.341530  \n",
       "4479  imdb_id    8847712\n",
       "imdb_id    8847712\n",
       "Name: 44...  0.608291  \n",
       "2922  imdb_id    1311071\n",
       "imdb_id    1311071\n",
       "Name: 29...  0.314246  \n",
       "2774  imdb_id    0065051\n",
       "imdb_id    0065051\n",
       "Name: 27...  0.000000  \n",
       "7821  imdb_id    0283084\n",
       "imdb_id    0283084\n",
       "Name: 78...  0.000000  \n",
       "4172  imdb_id    0059020\n",
       "imdb_id    0059020\n",
       "Name: 41...  0.188907  \n",
       "6783  imdb_id    12783454\n",
       "imdb_id    12783454\n",
       "Name: ...  2.447939  \n",
       "160   imdb_id    0090305\n",
       "imdb_id    0090305\n",
       "Name: 16...  0.350692  \n",
       "5665  imdb_id    1583323\n",
       "imdb_id    1583323\n",
       "Name: 56...  0.551865  \n",
       "\n",
       "[20 rows x 37 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.to_csv('dataset_turfu.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "8a06b16eeb1aafe456feb02fe6e0b1401b216a035170a1a7613df3d99ddf6e3e"
  },
  "kernelspec": {
   "display_name": "Python 3.7.12 ('hackathon')",
   "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.12"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}