8강_추천시스템.ipynb

{
    "cells": [
        {
            "cell_type": "markdown",
            "source": [
                "## 8강_ 영화 추천 시스템\r\n",
                "\r\n",
                "이번 강의에서는, Kaggle의 'Movielens'dataset을 이용하여,\r\n",
                "\r\n",
                "영화 추천 시스템을 만들어보도록 하겠습니다!!\r\n",
                "\r\n",
                "우선 두 파일을 다운받으세요 - 아래 링크에 접속하여서, \r\n",
                "\r\n",
                "https://www.kaggle.com/sengzhaotoo/movielens-small\r\n",
                "\r\n",
                "좌측의 movie.csv, ratings.csv 파일을 다운받으신 후, \r\n",
                "\r\n",
                "이 .ipynb파일과 같은 경로에 저장하세요!!\r\n",
                "\r\n"
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "pip 명령어로 numpy, pandas, sklearn을 설치해 줍니다!!\r\n",
                "예시) !pip install numpy pandas sklearn"
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "ratings.csv 파일은 각 사용자가 영화에 몇 점을 주었는지(총평점 5점 중 몇 점을 받았는가)를 나타내주는 파일입니다.\r\n",
                "\r\n",
                "해당 파일을 파이썬 콘솔로 불러와 살펴보도록 할까요?"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 19,
            "source": [
                "import numpy as np # linear algebra\r\n",
                "import pandas as pd\r\n",
                "from sklearn.metrics.pairwise import cosine_similarity\r\n",
                "ratings=pd.read_csv('ratings.csv')\r\n",
                "# ratings.head(15)\r\n",
                "ratings.tail(15)"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "        userId  movieId  rating   timestamp\n",
                            "99989      671     5445     4.5  1064891627\n",
                            "99990      671     5464     3.0  1064891549\n",
                            "99991      671     5669     4.0  1063502711\n",
                            "99992      671     5816     4.0  1065111963\n",
                            "99993      671     5902     3.5  1064245507\n",
                            "99994      671     5952     5.0  1063502716\n",
                            "99995      671     5989     4.0  1064890625\n",
                            "99996      671     5991     4.5  1064245387\n",
                            "99997      671     5995     4.0  1066793014\n",
                            "99998      671     6212     2.5  1065149436\n",
                            "99999      671     6268     2.5  1065579370\n",
                            "100000     671     6269     4.0  1065149201\n",
                            "100001     671     6365     4.0  1070940363\n",
                            "100002     671     6385     2.5  1070979663\n",
                            "100003     671     6565     3.5  1074784724"
                        ],
                        "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>userId</th>\n",
                            "      <th>movieId</th>\n",
                            "      <th>rating</th>\n",
                            "      <th>timestamp</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>99989</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5445</td>\n",
                            "      <td>4.5</td>\n",
                            "      <td>1064891627</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99990</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5464</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>1064891549</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99991</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5669</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1063502711</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99992</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5816</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1065111963</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99993</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5902</td>\n",
                            "      <td>3.5</td>\n",
                            "      <td>1064245507</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99994</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5952</td>\n",
                            "      <td>5.0</td>\n",
                            "      <td>1063502716</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99995</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5989</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1064890625</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99996</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5991</td>\n",
                            "      <td>4.5</td>\n",
                            "      <td>1064245387</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99997</th>\n",
                            "      <td>671</td>\n",
                            "      <td>5995</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1066793014</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99998</th>\n",
                            "      <td>671</td>\n",
                            "      <td>6212</td>\n",
                            "      <td>2.5</td>\n",
                            "      <td>1065149436</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99999</th>\n",
                            "      <td>671</td>\n",
                            "      <td>6268</td>\n",
                            "      <td>2.5</td>\n",
                            "      <td>1065579370</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100000</th>\n",
                            "      <td>671</td>\n",
                            "      <td>6269</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1065149201</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100001</th>\n",
                            "      <td>671</td>\n",
                            "      <td>6365</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1070940363</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100002</th>\n",
                            "      <td>671</td>\n",
                            "      <td>6385</td>\n",
                            "      <td>2.5</td>\n",
                            "      <td>1070979663</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100003</th>\n",
                            "      <td>671</td>\n",
                            "      <td>6565</td>\n",
                            "      <td>3.5</td>\n",
                            "      <td>1074784724</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 19
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "movies.csv 파일은 영화의 목록 파일입니다.\r\n",
                "\r\n",
                "장르도 같이 포함하고 있어요!!(복수 장르)\r\n",
                "\r\n",
                "불러와서 내용을 살펴보도록 하겠습니다!!"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 25,
            "source": [
                "movies=pd.read_csv('movies.csv')\r\n",
                "movies.head(15)"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "    movieId                               title  \\\n",
                            "0         1                    Toy Story (1995)   \n",
                            "1         2                      Jumanji (1995)   \n",
                            "2         3             Grumpier Old Men (1995)   \n",
                            "3         4            Waiting to Exhale (1995)   \n",
                            "4         5  Father of the Bride Part II (1995)   \n",
                            "5         6                         Heat (1995)   \n",
                            "6         7                      Sabrina (1995)   \n",
                            "7         8                 Tom and Huck (1995)   \n",
                            "8         9                 Sudden Death (1995)   \n",
                            "9        10                    GoldenEye (1995)   \n",
                            "10       11      American President, The (1995)   \n",
                            "11       12  Dracula: Dead and Loving It (1995)   \n",
                            "12       13                        Balto (1995)   \n",
                            "13       14                        Nixon (1995)   \n",
                            "14       15             Cutthroat Island (1995)   \n",
                            "\n",
                            "                                         genres  \n",
                            "0   Adventure|Animation|Children|Comedy|Fantasy  \n",
                            "1                    Adventure|Children|Fantasy  \n",
                            "2                                Comedy|Romance  \n",
                            "3                          Comedy|Drama|Romance  \n",
                            "4                                        Comedy  \n",
                            "5                         Action|Crime|Thriller  \n",
                            "6                                Comedy|Romance  \n",
                            "7                            Adventure|Children  \n",
                            "8                                        Action  \n",
                            "9                     Action|Adventure|Thriller  \n",
                            "10                         Comedy|Drama|Romance  \n",
                            "11                                Comedy|Horror  \n",
                            "12                 Adventure|Animation|Children  \n",
                            "13                                        Drama  \n",
                            "14                     Action|Adventure|Romance  "
                        ],
                        "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>movieId</th>\n",
                            "      <th>title</th>\n",
                            "      <th>genres</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>1</td>\n",
                            "      <td>Toy Story (1995)</td>\n",
                            "      <td>Adventure|Animation|Children|Comedy|Fantasy</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>2</td>\n",
                            "      <td>Jumanji (1995)</td>\n",
                            "      <td>Adventure|Children|Fantasy</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>3</td>\n",
                            "      <td>Grumpier Old Men (1995)</td>\n",
                            "      <td>Comedy|Romance</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>4</td>\n",
                            "      <td>Waiting to Exhale (1995)</td>\n",
                            "      <td>Comedy|Drama|Romance</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>5</td>\n",
                            "      <td>Father of the Bride Part II (1995)</td>\n",
                            "      <td>Comedy</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>5</th>\n",
                            "      <td>6</td>\n",
                            "      <td>Heat (1995)</td>\n",
                            "      <td>Action|Crime|Thriller</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>6</th>\n",
                            "      <td>7</td>\n",
                            "      <td>Sabrina (1995)</td>\n",
                            "      <td>Comedy|Romance</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>7</th>\n",
                            "      <td>8</td>\n",
                            "      <td>Tom and Huck (1995)</td>\n",
                            "      <td>Adventure|Children</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>8</th>\n",
                            "      <td>9</td>\n",
                            "      <td>Sudden Death (1995)</td>\n",
                            "      <td>Action</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>9</th>\n",
                            "      <td>10</td>\n",
                            "      <td>GoldenEye (1995)</td>\n",
                            "      <td>Action|Adventure|Thriller</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>10</th>\n",
                            "      <td>11</td>\n",
                            "      <td>American President, The (1995)</td>\n",
                            "      <td>Comedy|Drama|Romance</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>11</th>\n",
                            "      <td>12</td>\n",
                            "      <td>Dracula: Dead and Loving It (1995)</td>\n",
                            "      <td>Comedy|Horror</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>12</th>\n",
                            "      <td>13</td>\n",
                            "      <td>Balto (1995)</td>\n",
                            "      <td>Adventure|Animation|Children</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>13</th>\n",
                            "      <td>14</td>\n",
                            "      <td>Nixon (1995)</td>\n",
                            "      <td>Drama</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>14</th>\n",
                            "      <td>15</td>\n",
                            "      <td>Cutthroat Island (1995)</td>\n",
                            "      <td>Action|Adventure|Romance</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 25
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "이제 두 Dataframe을 합쳐서(merge, 병합해서) 나타내보도록 하겠습니다!!"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 23,
            "source": [
                "movie_ratings = pd.merge(movies, ratings)\r\n",
                "movie_ratings.head(15)"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "        movieId                                              title  \\\n",
                            "99989    160565                    The Purge: Election Year (2016)   \n",
                            "99990    160567              Mike & Dave Need Wedding Dates (2016)   \n",
                            "99991    160590                         Survive and Advance (2013)   \n",
                            "99992    160656                                    Tallulah (2016)   \n",
                            "99993    160718                                       Piper (2016)   \n",
                            "99994    161084                       My Friend Rockefeller (2015)   \n",
                            "99995    161155                                   Sunspring (2016)   \n",
                            "99996    161594               Kingsglaive: Final Fantasy XV (2016)   \n",
                            "99997    161830                                        Body (2015)   \n",
                            "99998    161918                Sharknado 4: The 4th Awakens (2016)   \n",
                            "99999    161944              The Last Brickmaker in America (2001)   \n",
                            "100000   162376                                    Stranger Things   \n",
                            "100001   162542                                      Rustom (2016)   \n",
                            "100002   162672                                Mohenjo Daro (2016)   \n",
                            "100003   163949  The Beatles: Eight Days a Week - The Touring Y...   \n",
                            "\n",
                            "                                                 genres  userId  rating  \\\n",
                            "99989                              Action|Horror|Sci-Fi      15     2.0   \n",
                            "99990                                            Comedy      15     4.0   \n",
                            "99991                                (no genres listed)      56     5.0   \n",
                            "99992                                             Drama     547     3.5   \n",
                            "99993                                         Animation     547     4.0   \n",
                            "99994                                       Documentary     547     2.5   \n",
                            "99995                                            Sci-Fi      15     0.5   \n",
                            "99996   Action|Adventure|Animation|Drama|Fantasy|Sci-Fi      73     3.0   \n",
                            "99997                             Drama|Horror|Thriller     624     1.0   \n",
                            "99998                    Action|Adventure|Horror|Sci-Fi     624     1.5   \n",
                            "99999                                             Drama     287     5.0   \n",
                            "100000                                            Drama      73     4.5   \n",
                            "100001                                 Romance|Thriller     611     5.0   \n",
                            "100002                          Adventure|Drama|Romance     611     3.0   \n",
                            "100003                                      Documentary     547     5.0   \n",
                            "\n",
                            "         timestamp  \n",
                            "99989   1469330266  \n",
                            "99990   1469330242  \n",
                            "99991   1467095789  \n",
                            "99992   1471168466  \n",
                            "99993   1469713151  \n",
                            "99994   1468248331  \n",
                            "99995   1469330307  \n",
                            "99996   1474255459  \n",
                            "99997   1472493010  \n",
                            "99998   1472929873  \n",
                            "99999   1470167824  \n",
                            "100000  1474255532  \n",
                            "100001  1471520667  \n",
                            "100002  1471523986  \n",
                            "100003  1476419239  "
                        ],
                        "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>movieId</th>\n",
                            "      <th>title</th>\n",
                            "      <th>genres</th>\n",
                            "      <th>userId</th>\n",
                            "      <th>rating</th>\n",
                            "      <th>timestamp</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>99989</th>\n",
                            "      <td>160565</td>\n",
                            "      <td>The Purge: Election Year (2016)</td>\n",
                            "      <td>Action|Horror|Sci-Fi</td>\n",
                            "      <td>15</td>\n",
                            "      <td>2.0</td>\n",
                            "      <td>1469330266</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99990</th>\n",
                            "      <td>160567</td>\n",
                            "      <td>Mike &amp; Dave Need Wedding Dates (2016)</td>\n",
                            "      <td>Comedy</td>\n",
                            "      <td>15</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1469330242</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99991</th>\n",
                            "      <td>160590</td>\n",
                            "      <td>Survive and Advance (2013)</td>\n",
                            "      <td>(no genres listed)</td>\n",
                            "      <td>56</td>\n",
                            "      <td>5.0</td>\n",
                            "      <td>1467095789</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99992</th>\n",
                            "      <td>160656</td>\n",
                            "      <td>Tallulah (2016)</td>\n",
                            "      <td>Drama</td>\n",
                            "      <td>547</td>\n",
                            "      <td>3.5</td>\n",
                            "      <td>1471168466</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99993</th>\n",
                            "      <td>160718</td>\n",
                            "      <td>Piper (2016)</td>\n",
                            "      <td>Animation</td>\n",
                            "      <td>547</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>1469713151</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99994</th>\n",
                            "      <td>161084</td>\n",
                            "      <td>My Friend Rockefeller (2015)</td>\n",
                            "      <td>Documentary</td>\n",
                            "      <td>547</td>\n",
                            "      <td>2.5</td>\n",
                            "      <td>1468248331</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99995</th>\n",
                            "      <td>161155</td>\n",
                            "      <td>Sunspring (2016)</td>\n",
                            "      <td>Sci-Fi</td>\n",
                            "      <td>15</td>\n",
                            "      <td>0.5</td>\n",
                            "      <td>1469330307</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99996</th>\n",
                            "      <td>161594</td>\n",
                            "      <td>Kingsglaive: Final Fantasy XV (2016)</td>\n",
                            "      <td>Action|Adventure|Animation|Drama|Fantasy|Sci-Fi</td>\n",
                            "      <td>73</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>1474255459</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99997</th>\n",
                            "      <td>161830</td>\n",
                            "      <td>Body (2015)</td>\n",
                            "      <td>Drama|Horror|Thriller</td>\n",
                            "      <td>624</td>\n",
                            "      <td>1.0</td>\n",
                            "      <td>1472493010</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99998</th>\n",
                            "      <td>161918</td>\n",
                            "      <td>Sharknado 4: The 4th Awakens (2016)</td>\n",
                            "      <td>Action|Adventure|Horror|Sci-Fi</td>\n",
                            "      <td>624</td>\n",
                            "      <td>1.5</td>\n",
                            "      <td>1472929873</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>99999</th>\n",
                            "      <td>161944</td>\n",
                            "      <td>The Last Brickmaker in America (2001)</td>\n",
                            "      <td>Drama</td>\n",
                            "      <td>287</td>\n",
                            "      <td>5.0</td>\n",
                            "      <td>1470167824</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100000</th>\n",
                            "      <td>162376</td>\n",
                            "      <td>Stranger Things</td>\n",
                            "      <td>Drama</td>\n",
                            "      <td>73</td>\n",
                            "      <td>4.5</td>\n",
                            "      <td>1474255532</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100001</th>\n",
                            "      <td>162542</td>\n",
                            "      <td>Rustom (2016)</td>\n",
                            "      <td>Romance|Thriller</td>\n",
                            "      <td>611</td>\n",
                            "      <td>5.0</td>\n",
                            "      <td>1471520667</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100002</th>\n",
                            "      <td>162672</td>\n",
                            "      <td>Mohenjo Daro (2016)</td>\n",
                            "      <td>Adventure|Drama|Romance</td>\n",
                            "      <td>611</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>1471523986</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>100003</th>\n",
                            "      <td>163949</td>\n",
                            "      <td>The Beatles: Eight Days a Week - The Touring Y...</td>\n",
                            "      <td>Documentary</td>\n",
                            "      <td>547</td>\n",
                            "      <td>5.0</td>\n",
                            "      <td>1476419239</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 23
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "## 추천 시스템 구성\r\n",
                "\r\n",
                "아래는 추천 시스템을 구성하기 위해, userid 와 영화 별 평점을 도표로 나타낸 것입니다!!\r\n",
                "\r\n",
                "가로축은 영화의 id,\r\n",
                "\r\n",
                "세로축은 평점을 준 user id를 나타내고 있어요!!\r\n"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 20,
            "source": [
                "# 테이블을 pivot하여 가로축에는 영화 id (671번까지)\r\n",
                "# 세로축에는 user id (100003번까지)를 위치시켜,\r\n",
                "# matrix를 만들어 줍니다!! (가로세로 그물망)\r\n",
                "ratings_matrix = ratings.pivot_table(index=['movieId'],columns=['userId'],values='rating').reset_index(drop=True)\r\n",
                "# 빈 칸에 0을 삽입함으로서 에러가 나지 않도록 합니다!!\r\n",
                "ratings_matrix.fillna( 0, inplace = True ) \r\n",
                "#상위 15개 행만 출력합니다!!\r\n",
                "ratings_matrix.head(15)"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "userId  1    2    3    4    5    6    7    8    9    10   ...  662  663  664  \\\n",
                            "0       0.0  0.0  0.0  0.0  0.0  0.0  3.0  0.0  4.0  0.0  ...  0.0  4.0  3.5   \n",
                            "1       0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  5.0  0.0  0.0   \n",
                            "2       0.0  0.0  0.0  0.0  4.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "3       0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "4       0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "5       0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  4.0   \n",
                            "6       0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "7       0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "8       0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "9       0.0  4.0  0.0  4.0  0.0  0.0  3.0  0.0  0.0  0.0  ...  3.0  0.0  0.0   \n",
                            "10      0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "11      0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "12      0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "13      0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "14      0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0  ...  0.0  0.0  0.0   \n",
                            "\n",
                            "userId  665  666  667  668  669  670  671  \n",
                            "0       0.0  0.0  0.0  0.0  0.0  4.0  5.0  \n",
                            "1       3.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "2       3.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "3       0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "4       3.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "5       0.0  5.0  4.0  0.0  0.0  0.0  0.0  \n",
                            "6       0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "7       0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "8       0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "9       0.0  3.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "10      0.0  0.0  3.0  0.0  0.0  0.0  0.0  \n",
                            "11      0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "12      0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "13      0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "14      0.0  0.0  0.0  0.0  0.0  0.0  0.0  \n",
                            "\n",
                            "[15 rows x 671 columns]"
                        ],
                        "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>userId</th>\n",
                            "      <th>1</th>\n",
                            "      <th>2</th>\n",
                            "      <th>3</th>\n",
                            "      <th>4</th>\n",
                            "      <th>5</th>\n",
                            "      <th>6</th>\n",
                            "      <th>7</th>\n",
                            "      <th>8</th>\n",
                            "      <th>9</th>\n",
                            "      <th>10</th>\n",
                            "      <th>...</th>\n",
                            "      <th>662</th>\n",
                            "      <th>663</th>\n",
                            "      <th>664</th>\n",
                            "      <th>665</th>\n",
                            "      <th>666</th>\n",
                            "      <th>667</th>\n",
                            "      <th>668</th>\n",
                            "      <th>669</th>\n",
                            "      <th>670</th>\n",
                            "      <th>671</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>3.5</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>5.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>5.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>5</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>5.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>6</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>7</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>8</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>9</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>4.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>10</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>3.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>11</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>12</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>13</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>14</th>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "<p>15 rows × 671 columns</p>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 20
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [],
            "metadata": {}
        },
        {
            "cell_type": "markdown",
            "source": [
                "아래는 추천 시스템을 구성하기 위해, cosine_similarty를 사용한 것입니다!!\r\n",
                "\r\n",
                "즉 같은 사용자가 비슷한 추천 점수를 준 영화(아이템)이라면, 유사도가 높다고 평가하는 것입니다!!\r\n",
                "\r\n",
                "Reference: https://lsjsj92.tistory.com/563"
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 11,
            "source": [
                "movie_similarity=cosine_similarity(ratings_matrix)\r\n",
                "np.fill_diagonal( movie_similarity, 0 ) \r\n",
                "movie_similarity"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "array([[0.        , 0.39451145, 0.30651588, ..., 0.        , 0.        ,\n",
                            "        0.05582876],\n",
                            "       [0.39451145, 0.        , 0.21749153, ..., 0.        , 0.        ,\n",
                            "        0.        ],\n",
                            "       [0.30651588, 0.21749153, 0.        , ..., 0.        , 0.        ,\n",
                            "        0.        ],\n",
                            "       ...,\n",
                            "       [0.        , 0.        , 0.        , ..., 0.        , 1.        ,\n",
                            "        0.        ],\n",
                            "       [0.        , 0.        , 0.        , ..., 1.        , 0.        ,\n",
                            "        0.        ],\n",
                            "       [0.05582876, 0.        , 0.        , ..., 0.        , 0.        ,\n",
                            "        0.        ]])"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 11
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 22,
            "source": [
                "ratings_matrix = pd.DataFrame( movie_similarity )\r\n",
                "ratings_matrix.head(15)\r\n",
                "# 9124 x 9124 의 matrix를 만들어, 각 영화들끼리의 유사도를 나타내 줍니다!!"
            ],
            "outputs": [
                {
                    "output_type": "execute_result",
                    "data": {
                        "text/plain": [
                            "        0         1         2         3         4         5         6     \\\n",
                            "0   0.000000  0.394511  0.306516  0.133614  0.245102  0.377086  0.278629   \n",
                            "1   0.394511  0.000000  0.217492  0.164651  0.278476  0.222003  0.207299   \n",
                            "2   0.306516  0.217492  0.000000  0.177012  0.370732  0.247499  0.435648   \n",
                            "3   0.133614  0.164651  0.177012  0.000000  0.179556  0.072518  0.184626   \n",
                            "4   0.245102  0.278476  0.370732  0.179556  0.000000  0.272645  0.388476   \n",
                            "5   0.377086  0.222003  0.247499  0.072518  0.272645  0.000000  0.278855   \n",
                            "6   0.278629  0.207299  0.435648  0.184626  0.388476  0.278855  0.000000   \n",
                            "7   0.063031  0.223524  0.127574  0.501513  0.194113  0.097561  0.196091   \n",
                            "8   0.117499  0.113669  0.306717  0.254630  0.367941  0.248155  0.349827   \n",
                            "9   0.310689  0.418124  0.191255  0.111447  0.246846  0.307948  0.177425   \n",
                            "10  0.328194  0.293312  0.220983  0.152753  0.293352  0.289200  0.372882   \n",
                            "11  0.189994  0.079558  0.182194  0.000000  0.187843  0.151322  0.302999   \n",
                            "12  0.146473  0.219004  0.111808  0.133192  0.164968  0.034547  0.204840   \n",
                            "13  0.190222  0.055918  0.244043  0.082895  0.172188  0.263074  0.244025   \n",
                            "14  0.170197  0.165269  0.155901  0.026531  0.081467  0.106127  0.116185   \n",
                            "\n",
                            "        7         8         9     ...      9056      9057      9058      9059  \\\n",
                            "0   0.063031  0.117499  0.310689  ...  0.055829  0.031902  0.079755  0.079755   \n",
                            "1   0.223524  0.113669  0.418124  ...  0.000000  0.055038  0.068797  0.082557   \n",
                            "2   0.127574  0.306717  0.191255  ...  0.000000  0.000000  0.000000  0.116226   \n",
                            "3   0.501513  0.254630  0.111447  ...  0.000000  0.000000  0.000000  0.000000   \n",
                            "4   0.194113  0.367941  0.246846  ...  0.000000  0.176845  0.000000  0.117897   \n",
                            "5   0.097561  0.248155  0.307948  ...  0.061724  0.098758  0.111103  0.000000   \n",
                            "6   0.196091  0.349827  0.177425  ...  0.079399  0.000000  0.000000  0.000000   \n",
                            "7   0.000000  0.264477  0.042169  ...  0.000000  0.000000  0.000000  0.000000   \n",
                            "8   0.264477  0.000000  0.130475  ...  0.000000  0.000000  0.000000  0.000000   \n",
                            "9   0.042169  0.130475  0.000000  ...  0.000000  0.076835  0.076835  0.102446   \n",
                            "10  0.130968  0.216373  0.282299  ...  0.087306  0.072755  0.000000  0.000000   \n",
                            "11  0.000000  0.238833  0.154012  ...  0.000000  0.000000  0.000000  0.154189   \n",
                            "12  0.143990  0.228782  0.053756  ...  0.000000  0.000000  0.000000  0.000000   \n",
                            "13  0.089216  0.293766  0.070908  ...  0.177800  0.127000  0.000000  0.000000   \n",
                            "14  0.000000  0.075554  0.167087  ...  0.000000  0.000000  0.304855  0.000000   \n",
                            "\n",
                            "        9060      9061      9062  9063  9064      9065  \n",
                            "0   0.079755  0.079755  0.079755   0.0   0.0  0.055829  \n",
                            "1   0.082557  0.137594  0.068797   0.0   0.0  0.000000  \n",
                            "2   0.116226  0.000000  0.000000   0.0   0.0  0.000000  \n",
                            "3   0.000000  0.000000  0.000000   0.0   0.0  0.000000  \n",
                            "4   0.117897  0.000000  0.000000   0.0   0.0  0.000000  \n",
                            "5   0.000000  0.000000  0.111103   0.0   0.0  0.061724  \n",
                            "6   0.000000  0.000000  0.000000   0.0   0.0  0.079399  \n",
                            "7   0.000000  0.000000  0.000000   0.0   0.0  0.000000  \n",
                            "8   0.000000  0.000000  0.000000   0.0   0.0  0.000000  \n",
                            "9   0.102446  0.000000  0.076835   0.0   0.0  0.000000  \n",
                            "10  0.000000  0.000000  0.000000   0.0   0.0  0.087306  \n",
                            "11  0.154189  0.000000  0.000000   0.0   0.0  0.000000  \n",
                            "12  0.000000  0.393543  0.000000   0.0   0.0  0.000000  \n",
                            "13  0.000000  0.000000  0.000000   0.0   0.0  0.177800  \n",
                            "14  0.000000  0.000000  0.304855   0.0   0.0  0.000000  \n",
                            "\n",
                            "[15 rows x 9066 columns]"
                        ],
                        "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>0</th>\n",
                            "      <th>1</th>\n",
                            "      <th>2</th>\n",
                            "      <th>3</th>\n",
                            "      <th>4</th>\n",
                            "      <th>5</th>\n",
                            "      <th>6</th>\n",
                            "      <th>7</th>\n",
                            "      <th>8</th>\n",
                            "      <th>9</th>\n",
                            "      <th>...</th>\n",
                            "      <th>9056</th>\n",
                            "      <th>9057</th>\n",
                            "      <th>9058</th>\n",
                            "      <th>9059</th>\n",
                            "      <th>9060</th>\n",
                            "      <th>9061</th>\n",
                            "      <th>9062</th>\n",
                            "      <th>9063</th>\n",
                            "      <th>9064</th>\n",
                            "      <th>9065</th>\n",
                            "    </tr>\n",
                            "  </thead>\n",
                            "  <tbody>\n",
                            "    <tr>\n",
                            "      <th>0</th>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.394511</td>\n",
                            "      <td>0.306516</td>\n",
                            "      <td>0.133614</td>\n",
                            "      <td>0.245102</td>\n",
                            "      <td>0.377086</td>\n",
                            "      <td>0.278629</td>\n",
                            "      <td>0.063031</td>\n",
                            "      <td>0.117499</td>\n",
                            "      <td>0.310689</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.055829</td>\n",
                            "      <td>0.031902</td>\n",
                            "      <td>0.079755</td>\n",
                            "      <td>0.079755</td>\n",
                            "      <td>0.079755</td>\n",
                            "      <td>0.079755</td>\n",
                            "      <td>0.079755</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.055829</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>1</th>\n",
                            "      <td>0.394511</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.217492</td>\n",
                            "      <td>0.164651</td>\n",
                            "      <td>0.278476</td>\n",
                            "      <td>0.222003</td>\n",
                            "      <td>0.207299</td>\n",
                            "      <td>0.223524</td>\n",
                            "      <td>0.113669</td>\n",
                            "      <td>0.418124</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.055038</td>\n",
                            "      <td>0.068797</td>\n",
                            "      <td>0.082557</td>\n",
                            "      <td>0.082557</td>\n",
                            "      <td>0.137594</td>\n",
                            "      <td>0.068797</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>2</th>\n",
                            "      <td>0.306516</td>\n",
                            "      <td>0.217492</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.177012</td>\n",
                            "      <td>0.370732</td>\n",
                            "      <td>0.247499</td>\n",
                            "      <td>0.435648</td>\n",
                            "      <td>0.127574</td>\n",
                            "      <td>0.306717</td>\n",
                            "      <td>0.191255</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.116226</td>\n",
                            "      <td>0.116226</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>3</th>\n",
                            "      <td>0.133614</td>\n",
                            "      <td>0.164651</td>\n",
                            "      <td>0.177012</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.179556</td>\n",
                            "      <td>0.072518</td>\n",
                            "      <td>0.184626</td>\n",
                            "      <td>0.501513</td>\n",
                            "      <td>0.254630</td>\n",
                            "      <td>0.111447</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>4</th>\n",
                            "      <td>0.245102</td>\n",
                            "      <td>0.278476</td>\n",
                            "      <td>0.370732</td>\n",
                            "      <td>0.179556</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.272645</td>\n",
                            "      <td>0.388476</td>\n",
                            "      <td>0.194113</td>\n",
                            "      <td>0.367941</td>\n",
                            "      <td>0.246846</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.176845</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.117897</td>\n",
                            "      <td>0.117897</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>5</th>\n",
                            "      <td>0.377086</td>\n",
                            "      <td>0.222003</td>\n",
                            "      <td>0.247499</td>\n",
                            "      <td>0.072518</td>\n",
                            "      <td>0.272645</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.278855</td>\n",
                            "      <td>0.097561</td>\n",
                            "      <td>0.248155</td>\n",
                            "      <td>0.307948</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.061724</td>\n",
                            "      <td>0.098758</td>\n",
                            "      <td>0.111103</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.111103</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.061724</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>6</th>\n",
                            "      <td>0.278629</td>\n",
                            "      <td>0.207299</td>\n",
                            "      <td>0.435648</td>\n",
                            "      <td>0.184626</td>\n",
                            "      <td>0.388476</td>\n",
                            "      <td>0.278855</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.196091</td>\n",
                            "      <td>0.349827</td>\n",
                            "      <td>0.177425</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.079399</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.079399</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>7</th>\n",
                            "      <td>0.063031</td>\n",
                            "      <td>0.223524</td>\n",
                            "      <td>0.127574</td>\n",
                            "      <td>0.501513</td>\n",
                            "      <td>0.194113</td>\n",
                            "      <td>0.097561</td>\n",
                            "      <td>0.196091</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.264477</td>\n",
                            "      <td>0.042169</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>8</th>\n",
                            "      <td>0.117499</td>\n",
                            "      <td>0.113669</td>\n",
                            "      <td>0.306717</td>\n",
                            "      <td>0.254630</td>\n",
                            "      <td>0.367941</td>\n",
                            "      <td>0.248155</td>\n",
                            "      <td>0.349827</td>\n",
                            "      <td>0.264477</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.130475</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>9</th>\n",
                            "      <td>0.310689</td>\n",
                            "      <td>0.418124</td>\n",
                            "      <td>0.191255</td>\n",
                            "      <td>0.111447</td>\n",
                            "      <td>0.246846</td>\n",
                            "      <td>0.307948</td>\n",
                            "      <td>0.177425</td>\n",
                            "      <td>0.042169</td>\n",
                            "      <td>0.130475</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.076835</td>\n",
                            "      <td>0.076835</td>\n",
                            "      <td>0.102446</td>\n",
                            "      <td>0.102446</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.076835</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>10</th>\n",
                            "      <td>0.328194</td>\n",
                            "      <td>0.293312</td>\n",
                            "      <td>0.220983</td>\n",
                            "      <td>0.152753</td>\n",
                            "      <td>0.293352</td>\n",
                            "      <td>0.289200</td>\n",
                            "      <td>0.372882</td>\n",
                            "      <td>0.130968</td>\n",
                            "      <td>0.216373</td>\n",
                            "      <td>0.282299</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.087306</td>\n",
                            "      <td>0.072755</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.087306</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>11</th>\n",
                            "      <td>0.189994</td>\n",
                            "      <td>0.079558</td>\n",
                            "      <td>0.182194</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.187843</td>\n",
                            "      <td>0.151322</td>\n",
                            "      <td>0.302999</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.238833</td>\n",
                            "      <td>0.154012</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.154189</td>\n",
                            "      <td>0.154189</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>12</th>\n",
                            "      <td>0.146473</td>\n",
                            "      <td>0.219004</td>\n",
                            "      <td>0.111808</td>\n",
                            "      <td>0.133192</td>\n",
                            "      <td>0.164968</td>\n",
                            "      <td>0.034547</td>\n",
                            "      <td>0.204840</td>\n",
                            "      <td>0.143990</td>\n",
                            "      <td>0.228782</td>\n",
                            "      <td>0.053756</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.393543</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>13</th>\n",
                            "      <td>0.190222</td>\n",
                            "      <td>0.055918</td>\n",
                            "      <td>0.244043</td>\n",
                            "      <td>0.082895</td>\n",
                            "      <td>0.172188</td>\n",
                            "      <td>0.263074</td>\n",
                            "      <td>0.244025</td>\n",
                            "      <td>0.089216</td>\n",
                            "      <td>0.293766</td>\n",
                            "      <td>0.070908</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.177800</td>\n",
                            "      <td>0.127000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.177800</td>\n",
                            "    </tr>\n",
                            "    <tr>\n",
                            "      <th>14</th>\n",
                            "      <td>0.170197</td>\n",
                            "      <td>0.165269</td>\n",
                            "      <td>0.155901</td>\n",
                            "      <td>0.026531</td>\n",
                            "      <td>0.081467</td>\n",
                            "      <td>0.106127</td>\n",
                            "      <td>0.116185</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.075554</td>\n",
                            "      <td>0.167087</td>\n",
                            "      <td>...</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.304855</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.000000</td>\n",
                            "      <td>0.304855</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.0</td>\n",
                            "      <td>0.000000</td>\n",
                            "    </tr>\n",
                            "  </tbody>\n",
                            "</table>\n",
                            "<p>15 rows × 9066 columns</p>\n",
                            "</div>"
                        ]
                    },
                    "metadata": {},
                    "execution_count": 22
                }
            ],
            "metadata": {}
        },
        {
            "cell_type": "code",
            "execution_count": 13,
            "source": [
                "try:\r\n",
                "    #user_inp=input('Enter the reference movie title based on which recommendations are to be made: ')\r\n",
                "    user_inp=\"Jumanji (1995)\"\r\n",
                "    inp=movies[movies['title']==user_inp].index.tolist()\r\n",
                "    inp=inp[0]\r\n",
                "    \r\n",
                "    movies['similarity'] = ratings_matrix.iloc[inp]\r\n",
                "    movies.head(5)\r\n",
                "    \r\n",
                "except:\r\n",
                "    print(\"Sorry, the movie is not in the database!\")\r\n",
                "    \r\n",
                "print(\"Recommended movies based on your choice of \",user_inp ,\": \\n\", movies.sort_values( [\"similarity\"], ascending = False )[1:10])"
            ],
            "outputs": [
                {
                    "output_type": "stream",
                    "name": "stdout",
                    "text": [
                        "Recommended movies based on your choice of  Jumanji (1995) : \n",
                        "      movieId                              title  \\\n",
                        "328      364              Lion King, The (1994)   \n",
                        "283      317           Santa Clause, The (1994)   \n",
                        "331      367                   Mask, The (1994)   \n",
                        "527      595        Beauty and the Beast (1991)   \n",
                        "521      588                     Aladdin (1992)   \n",
                        "309      344  Ace Ventura: Pet Detective (1994)   \n",
                        "520      587                       Ghost (1990)   \n",
                        "427      480               Jurassic Park (1993)   \n",
                        "341      377                       Speed (1994)   \n",
                        "\n",
                        "                                              genres  similarity  \n",
                        "328  Adventure|Animation|Children|Drama|Musical|IMAX    0.530357  \n",
                        "283                             Comedy|Drama|Fantasy    0.505831  \n",
                        "331                      Action|Comedy|Crime|Fantasy    0.494605  \n",
                        "527  Animation|Children|Fantasy|Musical|Romance|IMAX    0.494124  \n",
                        "521      Adventure|Animation|Children|Comedy|Musical    0.493995  \n",
                        "309                                           Comedy    0.475673  \n",
                        "520            Comedy|Drama|Fantasy|Romance|Thriller    0.474787  \n",
                        "427                 Action|Adventure|Sci-Fi|Thriller    0.471624  \n",
                        "341                          Action|Romance|Thriller    0.470265  \n"
                    ]
                }
            ],
            "metadata": {}
        }
    ],
    "metadata": {
        "orig_nbformat": 4,
        "language_info": {
            "name": "python",
            "version": "3.9.6",
            "mimetype": "text/x-python",
            "codemirror_mode": {
                "name": "ipython",
                "version": 3
            },
            "pygments_lexer": "ipython3",
            "nbconvert_exporter": "python",
            "file_extension": ".py"
        },
        "kernelspec": {
            "name": "python3",
            "display_name": "Python 3.9.6 64-bit"
        },
        "interpreter": {
            "hash": "63fd5069d213b44bf678585dea6b12cceca9941eaf7f819626cde1f2670de90d"
        }
    },
    "nbformat": 4,
    "nbformat_minor": 2
}