DataCleaning_for_movies_dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f1475d34-06f9-42b4-baa5-218f16269935",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "        <script type=\"text/javascript\">\n",
       "        window.PlotlyConfig = {MathJaxConfig: 'local'};\n",
       "        if (window.MathJax && window.MathJax.Hub && window.MathJax.Hub.Config) {window.MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}\n",
       "        if (typeof require !== 'undefined') {\n",
       "        require.undef(\"plotly\");\n",
       "        requirejs.config({\n",
       "            paths: {\n",
       "                'plotly': ['https://cdn.plot.ly/plotly-2.12.1.min']\n",
       "            }\n",
       "        });\n",
       "        require(['plotly'], function(Plotly) {\n",
       "            window._Plotly = Plotly;\n",
       "        });\n",
       "        }\n",
       "        </script>\n",
       "        "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import plotly.express as px\n",
    "from plotly.offline import init_notebook_mode, iplot\n",
    "import plotly.graph_objects as go\n",
    "init_notebook_mode(connected=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e1c2bdfd-9dc0-425f-ba61-10631fc97273",
   "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>MOVIES</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>RATING</th>\n",
       "      <th>ONE-LINE</th>\n",
       "      <th>STARS</th>\n",
       "      <th>VOTES</th>\n",
       "      <th>RunTime</th>\n",
       "      <th>Gross</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Blood Red Sky</td>\n",
       "      <td>(2021)</td>\n",
       "      <td>\\nAction, Horror, Thriller</td>\n",
       "      <td>6.1</td>\n",
       "      <td>\\nA woman with a mysterious illness is forced ...</td>\n",
       "      <td>\\n    Director:\\nPeter Thorwarth\\n| \\n    Star...</td>\n",
       "      <td>21,062</td>\n",
       "      <td>121.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Masters of the Universe: Revelation</td>\n",
       "      <td>(2021– )</td>\n",
       "      <td>\\nAnimation, Action, Adventure</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nThe war for Eternia begins again in what may...</td>\n",
       "      <td>\\n            \\n    Stars:\\nChris Wood, \\nSara...</td>\n",
       "      <td>17,870</td>\n",
       "      <td>25.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Walking Dead</td>\n",
       "      <td>(2010–2022)</td>\n",
       "      <td>\\nDrama, Horror, Thriller</td>\n",
       "      <td>8.2</td>\n",
       "      <td>\\nSheriff Deputy Rick Grimes wakes up from a c...</td>\n",
       "      <td>\\n            \\n    Stars:\\nAndrew Lincoln, \\n...</td>\n",
       "      <td>885,805</td>\n",
       "      <td>44.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Rick and Morty</td>\n",
       "      <td>(2013– )</td>\n",
       "      <td>\\nAnimation, Adventure, Comedy</td>\n",
       "      <td>9.2</td>\n",
       "      <td>\\nAn animated series that follows the exploits...</td>\n",
       "      <td>\\n            \\n    Stars:\\nJustin Roiland, \\n...</td>\n",
       "      <td>414,849</td>\n",
       "      <td>23.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Army of Thieves</td>\n",
       "      <td>(2021)</td>\n",
       "      <td>\\nAction, Crime, Horror</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\nA prequel, set before the events of Army of ...</td>\n",
       "      <td>\\n    Director:\\nMatthias Schweighöfer\\n| \\n  ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9994</th>\n",
       "      <td>The Imperfects</td>\n",
       "      <td>(2021– )</td>\n",
       "      <td>\\nAdventure, Drama, Fantasy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\nAdd a Plot\\n</td>\n",
       "      <td>\\n            \\n    Stars:\\nMorgan Taylor Camp...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>Arcane</td>\n",
       "      <td>(2021– )</td>\n",
       "      <td>\\nAnimation, Action, Adventure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\nAdd a Plot\\n</td>\n",
       "      <td>\\n</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>Heart of Invictus</td>\n",
       "      <td>(2022– )</td>\n",
       "      <td>\\nDocumentary, Sport</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\nAdd a Plot\\n</td>\n",
       "      <td>\\n    Director:\\nOrlando von Einsiedel\\n| \\n  ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>The Imperfects</td>\n",
       "      <td>(2021– )</td>\n",
       "      <td>\\nAdventure, Drama, Fantasy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\nAdd a Plot\\n</td>\n",
       "      <td>\\n    Director:\\nJovanka Vuckovic\\n| \\n    Sta...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>The Imperfects</td>\n",
       "      <td>(2021– )</td>\n",
       "      <td>\\nAdventure, Drama, Fantasy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\nAdd a Plot\\n</td>\n",
       "      <td>\\n    Director:\\nJovanka Vuckovic\\n| \\n    Sta...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9999 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   MOVIES         YEAR  \\\n",
       "0                           Blood Red Sky       (2021)   \n",
       "1     Masters of the Universe: Revelation     (2021– )   \n",
       "2                        The Walking Dead  (2010–2022)   \n",
       "3                          Rick and Morty     (2013– )   \n",
       "4                         Army of Thieves       (2021)   \n",
       "...                                   ...          ...   \n",
       "9994                       The Imperfects     (2021– )   \n",
       "9995                               Arcane     (2021– )   \n",
       "9996                    Heart of Invictus     (2022– )   \n",
       "9997                       The Imperfects     (2021– )   \n",
       "9998                       The Imperfects     (2021– )   \n",
       "\n",
       "                                           GENRE  RATING  \\\n",
       "0         \\nAction, Horror, Thriller                 6.1   \n",
       "1     \\nAnimation, Action, Adventure                 5.0   \n",
       "2          \\nDrama, Horror, Thriller                 8.2   \n",
       "3     \\nAnimation, Adventure, Comedy                 9.2   \n",
       "4            \\nAction, Crime, Horror                 NaN   \n",
       "...                                          ...     ...   \n",
       "9994     \\nAdventure, Drama, Fantasy                 NaN   \n",
       "9995  \\nAnimation, Action, Adventure                 NaN   \n",
       "9996            \\nDocumentary, Sport                 NaN   \n",
       "9997     \\nAdventure, Drama, Fantasy                 NaN   \n",
       "9998     \\nAdventure, Drama, Fantasy                 NaN   \n",
       "\n",
       "                                               ONE-LINE  \\\n",
       "0     \\nA woman with a mysterious illness is forced ...   \n",
       "1     \\nThe war for Eternia begins again in what may...   \n",
       "2     \\nSheriff Deputy Rick Grimes wakes up from a c...   \n",
       "3     \\nAn animated series that follows the exploits...   \n",
       "4     \\nA prequel, set before the events of Army of ...   \n",
       "...                                                 ...   \n",
       "9994                                     \\nAdd a Plot\\n   \n",
       "9995                                     \\nAdd a Plot\\n   \n",
       "9996                                     \\nAdd a Plot\\n   \n",
       "9997                                     \\nAdd a Plot\\n   \n",
       "9998                                     \\nAdd a Plot\\n   \n",
       "\n",
       "                                                  STARS    VOTES  RunTime  \\\n",
       "0     \\n    Director:\\nPeter Thorwarth\\n| \\n    Star...   21,062    121.0   \n",
       "1     \\n            \\n    Stars:\\nChris Wood, \\nSara...   17,870     25.0   \n",
       "2     \\n            \\n    Stars:\\nAndrew Lincoln, \\n...  885,805     44.0   \n",
       "3     \\n            \\n    Stars:\\nJustin Roiland, \\n...  414,849     23.0   \n",
       "4     \\n    Director:\\nMatthias Schweighöfer\\n| \\n  ...      NaN      NaN   \n",
       "...                                                 ...      ...      ...   \n",
       "9994  \\n            \\n    Stars:\\nMorgan Taylor Camp...      NaN      NaN   \n",
       "9995                                                 \\n      NaN      NaN   \n",
       "9996  \\n    Director:\\nOrlando von Einsiedel\\n| \\n  ...      NaN      NaN   \n",
       "9997  \\n    Director:\\nJovanka Vuckovic\\n| \\n    Sta...      NaN      NaN   \n",
       "9998  \\n    Director:\\nJovanka Vuckovic\\n| \\n    Sta...      NaN      NaN   \n",
       "\n",
       "     Gross  \n",
       "0      NaN  \n",
       "1      NaN  \n",
       "2      NaN  \n",
       "3      NaN  \n",
       "4      NaN  \n",
       "...    ...  \n",
       "9994   NaN  \n",
       "9995   NaN  \n",
       "9996   NaN  \n",
       "9997   NaN  \n",
       "9998   NaN  \n",
       "\n",
       "[9999 rows x 9 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(r'C:\\Users\\xinya\\PhD\\UIUC Courses\\IS 537\\Project\\archive\\movies.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "46bd8e51-5583-4bbc-8b15-a18fcbdabbbb",
   "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>MOVIES</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>RATING</th>\n",
       "      <th>ONE-LINE</th>\n",
       "      <th>STARS</th>\n",
       "      <th>VOTES</th>\n",
       "      <th>RunTime</th>\n",
       "      <th>Gross</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>\\nAction, Comedy, Crime</td>\n",
       "      <td>6.9</td>\n",
       "      <td>\\nThe world's top bodyguard gets a new client,...</td>\n",
       "      <td>\\n    Director:\\nPatrick Hughes\\n| \\n    Stars...</td>\n",
       "      <td>205,979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>\\nAction, Adventure, Sci-Fi</td>\n",
       "      <td>8.1</td>\n",
       "      <td>\\nA pragmatic paleontologist visiting an almos...</td>\n",
       "      <td>\\n    Director:\\nSteven Spielberg\\n| \\n    Sta...</td>\n",
       "      <td>897,444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>$402.45M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Don't Breathe</td>\n",
       "      <td>(2016)</td>\n",
       "      <td>\\nCrime, Horror, Thriller</td>\n",
       "      <td>7.1</td>\n",
       "      <td>\\nHoping to walk away with a massive fortune, ...</td>\n",
       "      <td>\\n    Director:\\nFede Alvarez\\n| \\n    Stars:\\...</td>\n",
       "      <td>237,601</td>\n",
       "      <td>88.0</td>\n",
       "      <td>$89.22M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the Ring</td>\n",
       "      <td>(2001)</td>\n",
       "      <td>\\nAction, Adventure, Drama</td>\n",
       "      <td>8.8</td>\n",
       "      <td>\\nA meek Hobbit from the Shire and eight compa...</td>\n",
       "      <td>\\n    Director:\\nPeter Jackson\\n| \\n    Stars:...</td>\n",
       "      <td>1,713,028</td>\n",
       "      <td>178.0</td>\n",
       "      <td>$315.54M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Escape Room</td>\n",
       "      <td>(I) (2019)</td>\n",
       "      <td>\\nAction, Adventure, Horror</td>\n",
       "      <td>6.4</td>\n",
       "      <td>\\nSix strangers find themselves in a maze of d...</td>\n",
       "      <td>\\n    Director:\\nAdam Robitel\\n| \\n    Stars:\\...</td>\n",
       "      <td>99,351</td>\n",
       "      <td>99.0</td>\n",
       "      <td>$57.01M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                MOVIES        YEAR  \\\n",
       "77                              The Hitman's Bodyguard      (2017)   \n",
       "85                                       Jurassic Park      (1993)   \n",
       "95                                       Don't Breathe      (2016)   \n",
       "111  The Lord of the Rings: The Fellowship of the Ring      (2001)   \n",
       "125                                        Escape Room  (I) (2019)   \n",
       "\n",
       "                                       GENRE  RATING  \\\n",
       "77       \\nAction, Comedy, Crime                 6.9   \n",
       "85   \\nAction, Adventure, Sci-Fi                 8.1   \n",
       "95     \\nCrime, Horror, Thriller                 7.1   \n",
       "111   \\nAction, Adventure, Drama                 8.8   \n",
       "125  \\nAction, Adventure, Horror                 6.4   \n",
       "\n",
       "                                              ONE-LINE  \\\n",
       "77   \\nThe world's top bodyguard gets a new client,...   \n",
       "85   \\nA pragmatic paleontologist visiting an almos...   \n",
       "95   \\nHoping to walk away with a massive fortune, ...   \n",
       "111  \\nA meek Hobbit from the Shire and eight compa...   \n",
       "125  \\nSix strangers find themselves in a maze of d...   \n",
       "\n",
       "                                                 STARS      VOTES  RunTime  \\\n",
       "77   \\n    Director:\\nPatrick Hughes\\n| \\n    Stars...    205,979    118.0   \n",
       "85   \\n    Director:\\nSteven Spielberg\\n| \\n    Sta...    897,444    127.0   \n",
       "95   \\n    Director:\\nFede Alvarez\\n| \\n    Stars:\\...    237,601     88.0   \n",
       "111  \\n    Director:\\nPeter Jackson\\n| \\n    Stars:...  1,713,028    178.0   \n",
       "125  \\n    Director:\\nAdam Robitel\\n| \\n    Stars:\\...     99,351     99.0   \n",
       "\n",
       "        Gross  \n",
       "77    $75.47M  \n",
       "85   $402.45M  \n",
       "95    $89.22M  \n",
       "111  $315.54M  \n",
       "125   $57.01M  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Drop nan values\n",
    "df.dropna(inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "8827f88c-f20e-408d-8e5a-31840f9b2405",
   "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>MOVIES</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>RATING</th>\n",
       "      <th>ONE-LINE</th>\n",
       "      <th>STARS</th>\n",
       "      <th>VOTES</th>\n",
       "      <th>RunTime</th>\n",
       "      <th>Gross</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action, Comedy, Crime</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205,979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>Action, Adventure, Sci-Fi</td>\n",
       "      <td>8.1</td>\n",
       "      <td>A pragmatic paleontologist visiting an almost ...</td>\n",
       "      <td>Director:Steven Spielberg|     Stars:Sam N...</td>\n",
       "      <td>897,444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>$402.45M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Don't Breathe</td>\n",
       "      <td>(2016)</td>\n",
       "      <td>Crime, Horror, Thriller</td>\n",
       "      <td>7.1</td>\n",
       "      <td>Hoping to walk away with a massive fortune, a ...</td>\n",
       "      <td>Director:Fede Alvarez|     Stars:Stephen L...</td>\n",
       "      <td>237,601</td>\n",
       "      <td>88.0</td>\n",
       "      <td>$89.22M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the Ring</td>\n",
       "      <td>(2001)</td>\n",
       "      <td>Action, Adventure, Drama</td>\n",
       "      <td>8.8</td>\n",
       "      <td>A meek Hobbit from the Shire and eight compani...</td>\n",
       "      <td>Director:Peter Jackson|     Stars:Elijah W...</td>\n",
       "      <td>1,713,028</td>\n",
       "      <td>178.0</td>\n",
       "      <td>$315.54M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Escape Room</td>\n",
       "      <td>(I) (2019)</td>\n",
       "      <td>Action, Adventure, Horror</td>\n",
       "      <td>6.4</td>\n",
       "      <td>Six strangers find themselves in a maze of dea...</td>\n",
       "      <td>Director:Adam Robitel|     Stars:Taylor Ru...</td>\n",
       "      <td>99,351</td>\n",
       "      <td>99.0</td>\n",
       "      <td>$57.01M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                MOVIES        YEAR  \\\n",
       "77                              The Hitman's Bodyguard      (2017)   \n",
       "85                                       Jurassic Park      (1993)   \n",
       "95                                       Don't Breathe      (2016)   \n",
       "111  The Lord of the Rings: The Fellowship of the Ring      (2001)   \n",
       "125                                        Escape Room  (I) (2019)   \n",
       "\n",
       "                                     GENRE  RATING  \\\n",
       "77       Action, Comedy, Crime                 6.9   \n",
       "85   Action, Adventure, Sci-Fi                 8.1   \n",
       "95     Crime, Horror, Thriller                 7.1   \n",
       "111   Action, Adventure, Drama                 8.8   \n",
       "125  Action, Adventure, Horror                 6.4   \n",
       "\n",
       "                                              ONE-LINE  \\\n",
       "77   The world's top bodyguard gets a new client, a...   \n",
       "85   A pragmatic paleontologist visiting an almost ...   \n",
       "95   Hoping to walk away with a massive fortune, a ...   \n",
       "111  A meek Hobbit from the Shire and eight compani...   \n",
       "125  Six strangers find themselves in a maze of dea...   \n",
       "\n",
       "                                                 STARS      VOTES  RunTime  \\\n",
       "77       Director:Patrick Hughes|     Stars:Ryan Re...    205,979    118.0   \n",
       "85       Director:Steven Spielberg|     Stars:Sam N...    897,444    127.0   \n",
       "95       Director:Fede Alvarez|     Stars:Stephen L...    237,601     88.0   \n",
       "111      Director:Peter Jackson|     Stars:Elijah W...  1,713,028    178.0   \n",
       "125      Director:Adam Robitel|     Stars:Taylor Ru...     99,351     99.0   \n",
       "\n",
       "        Gross  \n",
       "77    $75.47M  \n",
       "85   $402.45M  \n",
       "95    $89.22M  \n",
       "111  $315.54M  \n",
       "125   $57.01M  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get rid of \\n\n",
    "df['GENRE'] = df['GENRE'].str.replace('\\n', '')\n",
    "df['ONE-LINE'] = df['ONE-LINE'].str.replace('\\n', '')\n",
    "df['STARS'] = df['STARS'].str.replace('\\n', '')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5a705ae8-6afc-408b-b8f6-21cb02aa4c08",
   "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>MOVIES</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>RATING</th>\n",
       "      <th>ONE-LINE</th>\n",
       "      <th>STARS</th>\n",
       "      <th>VOTES</th>\n",
       "      <th>RunTime</th>\n",
       "      <th>Gross</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205,979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205,979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Crime</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205,979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>Action</td>\n",
       "      <td>8.1</td>\n",
       "      <td>A pragmatic paleontologist visiting an almost ...</td>\n",
       "      <td>Director:Steven Spielberg|     Stars:Sam N...</td>\n",
       "      <td>897,444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>$402.45M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>8.1</td>\n",
       "      <td>A pragmatic paleontologist visiting an almost ...</td>\n",
       "      <td>Director:Steven Spielberg|     Stars:Sam N...</td>\n",
       "      <td>897,444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>$402.45M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    MOVIES    YEAR      GENRE  RATING  \\\n",
       "77  The Hitman's Bodyguard  (2017)     Action     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)     Comedy     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)      Crime     6.9   \n",
       "85           Jurassic Park  (1993)     Action     8.1   \n",
       "85           Jurassic Park  (1993)  Adventure     8.1   \n",
       "\n",
       "                                             ONE-LINE  \\\n",
       "77  The world's top bodyguard gets a new client, a...   \n",
       "77  The world's top bodyguard gets a new client, a...   \n",
       "77  The world's top bodyguard gets a new client, a...   \n",
       "85  A pragmatic paleontologist visiting an almost ...   \n",
       "85  A pragmatic paleontologist visiting an almost ...   \n",
       "\n",
       "                                                STARS    VOTES  RunTime  \\\n",
       "77      Director:Patrick Hughes|     Stars:Ryan Re...  205,979    118.0   \n",
       "77      Director:Patrick Hughes|     Stars:Ryan Re...  205,979    118.0   \n",
       "77      Director:Patrick Hughes|     Stars:Ryan Re...  205,979    118.0   \n",
       "85      Director:Steven Spielberg|     Stars:Sam N...  897,444    127.0   \n",
       "85      Director:Steven Spielberg|     Stars:Sam N...  897,444    127.0   \n",
       "\n",
       "       Gross  \n",
       "77   $75.47M  \n",
       "77   $75.47M  \n",
       "77   $75.47M  \n",
       "85  $402.45M  \n",
       "85  $402.45M  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Separate multiple values in a cell\n",
    "df['GENRE'] = df['GENRE'].str.split(', ')\n",
    "df = df.explode('GENRE')\n",
    "# get rid of blank space in GENRE column\n",
    "df['GENRE'] = df['GENRE'].str.strip()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0eecd4ed-4094-481b-8b0d-129979721d1f",
   "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>MOVIES</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>RATING</th>\n",
       "      <th>ONE-LINE</th>\n",
       "      <th>STARS</th>\n",
       "      <th>VOTES</th>\n",
       "      <th>RunTime</th>\n",
       "      <th>Gross</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Crime</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>$75.47M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>Action</td>\n",
       "      <td>8.1</td>\n",
       "      <td>A pragmatic paleontologist visiting an almost ...</td>\n",
       "      <td>Director:Steven Spielberg|     Stars:Sam N...</td>\n",
       "      <td>897444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>$402.45M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>8.1</td>\n",
       "      <td>A pragmatic paleontologist visiting an almost ...</td>\n",
       "      <td>Director:Steven Spielberg|     Stars:Sam N...</td>\n",
       "      <td>897444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>$402.45M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    MOVIES    YEAR      GENRE  RATING  \\\n",
       "77  The Hitman's Bodyguard  (2017)     Action     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)     Comedy     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)      Crime     6.9   \n",
       "85           Jurassic Park  (1993)     Action     8.1   \n",
       "85           Jurassic Park  (1993)  Adventure     8.1   \n",
       "\n",
       "                                             ONE-LINE  \\\n",
       "77  The world's top bodyguard gets a new client, a...   \n",
       "77  The world's top bodyguard gets a new client, a...   \n",
       "77  The world's top bodyguard gets a new client, a...   \n",
       "85  A pragmatic paleontologist visiting an almost ...   \n",
       "85  A pragmatic paleontologist visiting an almost ...   \n",
       "\n",
       "                                                STARS   VOTES  RunTime  \\\n",
       "77      Director:Patrick Hughes|     Stars:Ryan Re...  205979    118.0   \n",
       "77      Director:Patrick Hughes|     Stars:Ryan Re...  205979    118.0   \n",
       "77      Director:Patrick Hughes|     Stars:Ryan Re...  205979    118.0   \n",
       "85      Director:Steven Spielberg|     Stars:Sam N...  897444    127.0   \n",
       "85      Director:Steven Spielberg|     Stars:Sam N...  897444    127.0   \n",
       "\n",
       "       Gross  \n",
       "77   $75.47M  \n",
       "77   $75.47M  \n",
       "77   $75.47M  \n",
       "85  $402.45M  \n",
       "85  $402.45M  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Turn str into int\n",
    "df['VOTES'] = df['VOTES'].str.replace(',', '').astype(int)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "730a9287-f5f0-449a-b8a5-b765fd30554a",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\xinya\\AppData\\Local\\Temp\\ipykernel_30812\\2633289510.py:2: FutureWarning:\n",
      "\n",
      "The default value of regex will change from True to False in a future version. In addition, single character regular expressions will *not* be treated as literal strings when regex=True.\n",
      "\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>MOVIES</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>RATING</th>\n",
       "      <th>ONE-LINE</th>\n",
       "      <th>STARS</th>\n",
       "      <th>VOTES</th>\n",
       "      <th>RunTime</th>\n",
       "      <th>Gross</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Crime</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>Director:Patrick Hughes|     Stars:Ryan Re...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>Action</td>\n",
       "      <td>8.1</td>\n",
       "      <td>A pragmatic paleontologist visiting an almost ...</td>\n",
       "      <td>Director:Steven Spielberg|     Stars:Sam N...</td>\n",
       "      <td>897444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>402.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jurassic Park</td>\n",
       "      <td>(1993)</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>8.1</td>\n",
       "      <td>A pragmatic paleontologist visiting an almost ...</td>\n",
       "      <td>Director:Steven Spielberg|     Stars:Sam N...</td>\n",
       "      <td>897444</td>\n",
       "      <td>127.0</td>\n",
       "      <td>402.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5835</th>\n",
       "      <td>Decoding Deepak</td>\n",
       "      <td>(2012)</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>5.5</td>\n",
       "      <td>Deepak Chopra's son, Gotham, spends a year tra...</td>\n",
       "      <td>Director:Gotham Chopra|     Stars:Deepak C...</td>\n",
       "      <td>124</td>\n",
       "      <td>83.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6056</th>\n",
       "      <td>Theo Who Lived</td>\n",
       "      <td>(2016)</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>6.8</td>\n",
       "      <td>A documentary on American journalist Theo Padn...</td>\n",
       "      <td>Director:David Schisgall|     Star:Theo Pa...</td>\n",
       "      <td>111</td>\n",
       "      <td>86.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6292</th>\n",
       "      <td>Southern Justice</td>\n",
       "      <td>(2006)</td>\n",
       "      <td>Action</td>\n",
       "      <td>3.1</td>\n",
       "      <td>M.D. Selig's feature thriller, SOUTHERN JUSTIC...</td>\n",
       "      <td>Director:M.D. Selig|     Stars:M.D. Selig,...</td>\n",
       "      <td>126</td>\n",
       "      <td>96.0</td>\n",
       "      <td>0.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6292</th>\n",
       "      <td>Southern Justice</td>\n",
       "      <td>(2006)</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>3.1</td>\n",
       "      <td>M.D. Selig's feature thriller, SOUTHERN JUSTIC...</td>\n",
       "      <td>Director:M.D. Selig|     Stars:M.D. Selig,...</td>\n",
       "      <td>126</td>\n",
       "      <td>96.0</td>\n",
       "      <td>0.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6292</th>\n",
       "      <td>Southern Justice</td>\n",
       "      <td>(2006)</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>3.1</td>\n",
       "      <td>M.D. Selig's feature thriller, SOUTHERN JUSTIC...</td>\n",
       "      <td>Director:M.D. Selig|     Stars:M.D. Selig,...</td>\n",
       "      <td>126</td>\n",
       "      <td>96.0</td>\n",
       "      <td>0.14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1171 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      MOVIES    YEAR        GENRE  RATING  \\\n",
       "77    The Hitman's Bodyguard  (2017)       Action     6.9   \n",
       "77    The Hitman's Bodyguard  (2017)       Comedy     6.9   \n",
       "77    The Hitman's Bodyguard  (2017)        Crime     6.9   \n",
       "85             Jurassic Park  (1993)       Action     8.1   \n",
       "85             Jurassic Park  (1993)    Adventure     8.1   \n",
       "...                      ...     ...          ...     ...   \n",
       "5835         Decoding Deepak  (2012)  Documentary     5.5   \n",
       "6056          Theo Who Lived  (2016)  Documentary     6.8   \n",
       "6292        Southern Justice  (2006)       Action     3.1   \n",
       "6292        Southern Justice  (2006)    Adventure     3.1   \n",
       "6292        Southern Justice  (2006)     Thriller     3.1   \n",
       "\n",
       "                                               ONE-LINE  \\\n",
       "77    The world's top bodyguard gets a new client, a...   \n",
       "77    The world's top bodyguard gets a new client, a...   \n",
       "77    The world's top bodyguard gets a new client, a...   \n",
       "85    A pragmatic paleontologist visiting an almost ...   \n",
       "85    A pragmatic paleontologist visiting an almost ...   \n",
       "...                                                 ...   \n",
       "5835  Deepak Chopra's son, Gotham, spends a year tra...   \n",
       "6056  A documentary on American journalist Theo Padn...   \n",
       "6292  M.D. Selig's feature thriller, SOUTHERN JUSTIC...   \n",
       "6292  M.D. Selig's feature thriller, SOUTHERN JUSTIC...   \n",
       "6292  M.D. Selig's feature thriller, SOUTHERN JUSTIC...   \n",
       "\n",
       "                                                  STARS   VOTES  RunTime  \\\n",
       "77        Director:Patrick Hughes|     Stars:Ryan Re...  205979    118.0   \n",
       "77        Director:Patrick Hughes|     Stars:Ryan Re...  205979    118.0   \n",
       "77        Director:Patrick Hughes|     Stars:Ryan Re...  205979    118.0   \n",
       "85        Director:Steven Spielberg|     Stars:Sam N...  897444    127.0   \n",
       "85        Director:Steven Spielberg|     Stars:Sam N...  897444    127.0   \n",
       "...                                                 ...     ...      ...   \n",
       "5835      Director:Gotham Chopra|     Stars:Deepak C...     124     83.0   \n",
       "6056      Director:David Schisgall|     Star:Theo Pa...     111     86.0   \n",
       "6292      Director:M.D. Selig|     Stars:M.D. Selig,...     126     96.0   \n",
       "6292      Director:M.D. Selig|     Stars:M.D. Selig,...     126     96.0   \n",
       "6292      Director:M.D. Selig|     Stars:M.D. Selig,...     126     96.0   \n",
       "\n",
       "       Gross  \n",
       "77     75.47  \n",
       "77     75.47  \n",
       "77     75.47  \n",
       "85    402.45  \n",
       "85    402.45  \n",
       "...      ...  \n",
       "5835    0.01  \n",
       "6056    0.01  \n",
       "6292    0.14  \n",
       "6292    0.14  \n",
       "6292    0.14  \n",
       "\n",
       "[1171 rows x 9 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Turn Gross column into float\n",
    "df['Gross'] = df['Gross'].str.replace('$', '').str.replace('M', '',regex=False).astype(float)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "e261a6b6-0589-486b-86fb-88543776a4a3",
   "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>MOVIES</th>\n",
       "      <th>YEAR</th>\n",
       "      <th>GENRE</th>\n",
       "      <th>RATING</th>\n",
       "      <th>ONE-LINE</th>\n",
       "      <th>VOTES</th>\n",
       "      <th>RunTime</th>\n",
       "      <th>Gross</th>\n",
       "      <th>Director</th>\n",
       "      <th>Stars</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "      <td>Patrick Hughes</td>\n",
       "      <td>Ryan Reynolds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "      <td>Patrick Hughes</td>\n",
       "      <td>Samuel L. Jackson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "      <td>Patrick Hughes</td>\n",
       "      <td>Gary Oldman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Action</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "      <td>Patrick Hughes</td>\n",
       "      <td>Elodie Yung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>The Hitman's Bodyguard</td>\n",
       "      <td>(2017)</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>6.9</td>\n",
       "      <td>The world's top bodyguard gets a new client, a...</td>\n",
       "      <td>205979</td>\n",
       "      <td>118.0</td>\n",
       "      <td>75.47</td>\n",
       "      <td>Patrick Hughes</td>\n",
       "      <td>Ryan Reynolds</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    MOVIES    YEAR   GENRE  RATING  \\\n",
       "77  The Hitman's Bodyguard  (2017)  Action     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)  Action     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)  Action     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)  Action     6.9   \n",
       "77  The Hitman's Bodyguard  (2017)  Comedy     6.9   \n",
       "\n",
       "                                             ONE-LINE   VOTES  RunTime  Gross  \\\n",
       "77  The world's top bodyguard gets a new client, a...  205979    118.0  75.47   \n",
       "77  The world's top bodyguard gets a new client, a...  205979    118.0  75.47   \n",
       "77  The world's top bodyguard gets a new client, a...  205979    118.0  75.47   \n",
       "77  The world's top bodyguard gets a new client, a...  205979    118.0  75.47   \n",
       "77  The world's top bodyguard gets a new client, a...  205979    118.0  75.47   \n",
       "\n",
       "          Director              Stars  \n",
       "77  Patrick Hughes      Ryan Reynolds  \n",
       "77  Patrick Hughes  Samuel L. Jackson  \n",
       "77  Patrick Hughes        Gary Oldman  \n",
       "77  Patrick Hughes        Elodie Yung  \n",
       "77  Patrick Hughes      Ryan Reynolds  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Separate director and stars\n",
    "df[['Director', 'Stars']] = df['STARS'].str.split('|', expand=True)\n",
    "df['Director'] = df['Director'].str.split(':', expand=True)[1]\n",
    "df['Stars'] = df['Stars'].str.split(':', expand=True)[1]\n",
    "df['Stars'] = df['Stars'].str.split(', ')\n",
    "df = df.explode('Stars')\n",
    "df.drop('STARS', axis=1, inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "86319022-7829-4379-9898-5f4b9e818983",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}