{ "cells": [ { "cell_type": "code", "execution_count": 296, "id": "c95c69b7", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "\n", "from tensorflow.keras.preprocessing.text import Tokenizer" ] }, { "cell_type": "code", "execution_count": 297, "id": "c9fc586e", "metadata": {}, "outputs": [], "source": [ "df_netflix = pd.read_excel(\"C:/Users/LeeSeungYong/Downloads/netflix_titles.xlsx\")\n", "df_netflix_categ = pd.read_excel(\"C:/Users/LeeSeungYong/Downloads/netflix_titles.xlsx\", sheet_name=\"netflix_titles_category\")" ] }, { "cell_type": "code", "execution_count": 298, "id": "55411913", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | duration_minutes | \n", "duration_seasons | \n", "type | \n", "title | \n", "date_added | \n", "release_year | \n", "rating | \n", "description | \n", "show_id | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "90 | \n", "NaN | \n", "Movie | \n", "Norm of the North: King Sized Adventure | \n", "2019-09-09 00:00:00 | \n", "2019.0 | \n", "TV-PG | \n", "Before planning an awesome wedding for his gra... | \n", "81145628.0 | \n", "
1 | \n", "94 | \n", "NaN | \n", "Movie | \n", "Jandino: Whatever it Takes | \n", "2016-09-09 00:00:00 | \n", "2016.0 | \n", "TV-MA | \n", "Jandino Asporaat riffs on the challenges of ra... | \n", "80117401.0 | \n", "
2 | \n", "NaN | \n", "1 | \n", "TV Show | \n", "Transformers Prime | \n", "2018-09-08 00:00:00 | \n", "2013.0 | \n", "TV-Y7-FV | \n", "With the help of three human allies, the Autob... | \n", "70234439.0 | \n", "
\n", " | listed_in | \n", "show_id | \n", "
---|---|---|
0 | \n", "Children & Family Movies | \n", "81145628 | \n", "
1 | \n", "Stand-Up Comedy | \n", "80117401 | \n", "
2 | \n", "Kids' TV | \n", "70234439 | \n", "
\n", " | listed_in | \n", "description | \n", "
---|---|---|
0 | \n", "Children & Family Movies | \n", "Before planning an awesome wedding for his gra... | \n", "
1 | \n", "Stand-Up Comedy | \n", "Jandino Asporaat riffs on the challenges of ra... | \n", "
2 | \n", "Kids' TV | \n", "With the help of three human allies, the Autob... | \n", "
3 | \n", "Kids' TV | \n", "When a prison ship crash unleashes hundreds of... | \n", "
4 | \n", "Comedies | \n", "When nerdy high schooler Dani finally attracts... | \n", "
... | \n", "... | \n", "... | \n", "
6231 | \n", "Movies | \n", "This parody of first-person shooter games, mil... | \n", "
6232 | \n", "British TV Shows | \n", "Marc Maron stars as Marc Maron, who interviews... | \n", "
6233 | \n", "Classic & Cult TV | \n", "Nursery rhymes and original music for children... | \n", "
6234 | \n", "Comedies | \n", "Set during the Russian Revolution, this comic ... | \n", "
6235 | \n", "International TV Shows | \n", "This hit sitcom follows the merry misadventure... | \n", "
6236 rows × 2 columns
\n", "\n", " | listed_in | \n", "description | \n", "
---|---|---|
0 | \n", "Children & Family Movies | \n", "[before, planning, an, awesome, wedding, for, ... | \n", "
1 | \n", "Stand-Up Comedy | \n", "[jandino, asporaat, riffs, on, the, challenges... | \n", "
2 | \n", "Kids' TV | \n", "[with, the, help, of, three, human, allies, th... | \n", "
3 | \n", "Kids' TV | \n", "[when, a, prison, ship, crash, unleashes, hund... | \n", "
4 | \n", "Comedies | \n", "[when, nerdy, high, schooler, dani, finally, a... | \n", "
... | \n", "... | \n", "... | \n", "
6228 | \n", "Movies | \n", "[this, parody, of, first, person, shooter, gam... | \n", "
6229 | \n", "British TV Shows | \n", "[marc, maron, stars, as, marc, maron, who, int... | \n", "
6230 | \n", "Classic & Cult TV | \n", "[nursery, rhymes, and, original, music, for, c... | \n", "
6231 | \n", "Comedies | \n", "[set, during, the, russian, revolution, this, ... | \n", "
6232 | \n", "International TV Shows | \n", "[this, hit, sitcom, follows, the, merry, misad... | \n", "
6233 rows × 2 columns
\n", "\n", " | listed_in | \n", "description | \n", "
---|---|---|
0 | \n", "Children & Family Movies | \n", "[planning, awesome, wedding, grandfather, pola... | \n", "
1 | \n", "Stand-Up Comedy | \n", "[jandino, asporaat, riff, challenge, raising, ... | \n", "
2 | \n", "Kids' TV | \n", "[help, three, human, ally, autobots, protect, ... | \n", "
3 | \n", "Kids' TV | \n", "[prison, ship, crash, unleashes, hundred, dece... | \n", "
4 | \n", "Comedies | \n", "[nerdy, high, schooler, dani, finally, attract... | \n", "
... | \n", "... | \n", "... | \n", "
6228 | \n", "Movies | \n", "[parody, first, person, shooter, game, militar... | \n", "
6229 | \n", "British TV Shows | \n", "[marc, maron, star, marc, maron, interview, fe... | \n", "
6230 | \n", "Classic & Cult TV | \n", "[nursery, rhyme, original, music, child, accom... | \n", "
6231 | \n", "Comedies | \n", "[set, russian, revolution, comic, miniseries, ... | \n", "
6232 | \n", "International TV Shows | \n", "[hit, sitcom, follows, merry, misadventure, si... | \n", "
6233 rows × 2 columns
\n", "\n", " | category | \n", "index | \n", "0 | \n", "
---|---|---|---|
0 | \n", "Action & Adventure | \n", "life | \n", "75 | \n", "
1 | \n", "Action & Adventure | \n", "find | \n", "61 | \n", "
2 | \n", "Action & Adventure | \n", "take | \n", "55 | \n", "
3 | \n", "Action & Adventure | \n", "young | \n", "55 | \n", "
4 | \n", "Action & Adventure | \n", "man | \n", "45 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
3169 | \n", "Thrillers | \n", "spy | \n", "1 | \n", "
3170 | \n", "Thrillers | \n", "million | \n", "1 | \n", "
3171 | \n", "Thrillers | \n", "haul | \n", "1 | \n", "
3172 | \n", "Thrillers | \n", "selling | \n", "1 | \n", "
3173 | \n", "Thrillers | \n", "held | \n", "1 | \n", "
3174 rows × 3 columns
\n", "