Post Reccomendation System.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Recommendation System"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In this recommendation system I have used Kaggle dataset named Post Recommendation System Here is the link of that : https://www.kaggle.com/vatsalparsaniya/post-pecommendation\n",
    "\n",
    "It will consume a user_id and check the history or like or vote he has given to post and check other users simliarities and then recommend posts.\n",
    "\n",
    "Here we go::::::::::::"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#importing relevant libraries\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Datasets Importing \n",
    "#post_data consists of post details like post_id, title, category\n",
    "#user_data consists of user's information\n",
    "#view_data consists of which user view which post\n",
    "\n",
    "post_data = pd.read_csv(r'post_data.csv')\n",
    "user_data = pd.read_csv(r'user_data.csv')\n",
    "view_data = pd.read_csv(r'view_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>category</th>\n",
       "      <th>post_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Find A Quick Way To GRAPHIC</td>\n",
       "      <td>graphic</td>\n",
       "      <td>10260109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>How To Sell CRAFT</td>\n",
       "      <td>Craft</td>\n",
       "      <td>39550285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>POLITICS An Incredibly Easy Method That Works ...</td>\n",
       "      <td>politics</td>\n",
       "      <td>935118791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5 Brilliant Ways To Use POLITICAL</td>\n",
       "      <td>political</td>\n",
       "      <td>151805043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>How To Make Your MATHEMATICS Look Amazing In ...</td>\n",
       "      <td>Mathematics</td>\n",
       "      <td>995833095</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title     category    post_id\n",
       "0                        Find A Quick Way To GRAPHIC      graphic   10260109\n",
       "1                                  How To Sell CRAFT        Craft   39550285\n",
       "2  POLITICS An Incredibly Easy Method That Works ...     politics  935118791\n",
       "3                  5 Brilliant Ways To Use POLITICAL    political  151805043\n",
       "4   How To Make Your MATHEMATICS Look Amazing In ...  Mathematics  995833095"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "post_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>gender</th>\n",
       "      <th>avatar</th>\n",
       "      <th>city</th>\n",
       "      <th>academics</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>5eece14efc13ae6609000000</td>\n",
       "      <td>Milena</td>\n",
       "      <td>Lacelett</td>\n",
       "      <td>Female</td>\n",
       "      <td>https://robohash.org/quisidomnis.png?size=50x5...</td>\n",
       "      <td>Blagoveshchensk</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>5eece14efc13ae6609000001</td>\n",
       "      <td>Nolan</td>\n",
       "      <td>Satcher</td>\n",
       "      <td>Male</td>\n",
       "      <td>https://robohash.org/dignissimosrepudiandaedol...</td>\n",
       "      <td>Wufeng</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>5eece14efc13ae6609000002</td>\n",
       "      <td>Eveleen</td>\n",
       "      <td>Cotterell</td>\n",
       "      <td>Female</td>\n",
       "      <td>https://robohash.org/remomnissuscipit.png?size...</td>\n",
       "      <td>Barra Bonita</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5eece14efc13ae6609000003</td>\n",
       "      <td>Petrina</td>\n",
       "      <td>Berr</td>\n",
       "      <td>Female</td>\n",
       "      <td>https://robohash.org/estquasconsectetur.png?si...</td>\n",
       "      <td>San Angelo</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5eece14efc13ae6609000004</td>\n",
       "      <td>Saunderson</td>\n",
       "      <td>Duquesnay</td>\n",
       "      <td>Male</td>\n",
       "      <td>https://robohash.org/nullaaest.png?size=50x50&amp;...</td>\n",
       "      <td>Olszówka</td>\n",
       "      <td>graduate</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    user_id  first_name  last_name  gender  \\\n",
       "0  5eece14efc13ae6609000000      Milena   Lacelett  Female   \n",
       "1  5eece14efc13ae6609000001       Nolan    Satcher    Male   \n",
       "2  5eece14efc13ae6609000002     Eveleen  Cotterell  Female   \n",
       "3  5eece14efc13ae6609000003     Petrina       Berr  Female   \n",
       "4  5eece14efc13ae6609000004  Saunderson  Duquesnay    Male   \n",
       "\n",
       "                                              avatar             city  \\\n",
       "0  https://robohash.org/quisidomnis.png?size=50x5...  Blagoveshchensk   \n",
       "1  https://robohash.org/dignissimosrepudiandaedol...           Wufeng   \n",
       "2  https://robohash.org/remomnissuscipit.png?size...     Barra Bonita   \n",
       "3  https://robohash.org/estquasconsectetur.png?si...       San Angelo   \n",
       "4  https://robohash.org/nullaaest.png?size=50x50&...         Olszówka   \n",
       "\n",
       "       academics  \n",
       "0  undergraduate  \n",
       "1  undergraduate  \n",
       "2  undergraduate  \n",
       "3  undergraduate  \n",
       "4       graduate  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>post_id</th>\n",
       "      <th>time_stamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>5eece14ffc13ae660900008b</td>\n",
       "      <td>136781766</td>\n",
       "      <td>01/01/2019 01:30 PM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>5eece14efc13ae660900003c</td>\n",
       "      <td>43094523</td>\n",
       "      <td>01/01/2019 01:33 PM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>5eece14efc13ae6609000025</td>\n",
       "      <td>42428071</td>\n",
       "      <td>01/01/2019 01:43 PM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5eece14ffc13ae66090001d4</td>\n",
       "      <td>76472880</td>\n",
       "      <td>01/01/2019 01:54 PM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5eece14ffc13ae66090000ac</td>\n",
       "      <td>202721843</td>\n",
       "      <td>01/01/2019 02:00 PM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    user_id    post_id           time_stamp\n",
       "0  5eece14ffc13ae660900008b  136781766  01/01/2019 01:30 PM\n",
       "1  5eece14efc13ae660900003c   43094523  01/01/2019 01:33 PM\n",
       "2  5eece14efc13ae6609000025   42428071  01/01/2019 01:43 PM\n",
       "3  5eece14ffc13ae66090001d4   76472880  01/01/2019 01:54 PM\n",
       "4  5eece14ffc13ae66090000ac  202721843  01/01/2019 02:00 PM"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Making Recommendation system is not a supervised learning right that consist of label but it is \n",
    "# unsupervised learning so we have to add likes or make it valuable that means the user rate it valuable\n",
    "# in terms of rating like out of 5 okay\n",
    "# I add up it.\n",
    "\n",
    "dataframe = pd.DataFrame(view_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataframe[\"Valuable\"] = np.random.randint(1, 6, len(dataframe))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>post_id</th>\n",
       "      <th>time_stamp</th>\n",
       "      <th>Valuable</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>5eece14ffc13ae660900008b</td>\n",
       "      <td>136781766</td>\n",
       "      <td>01/01/2019 01:30 PM</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>5eece14efc13ae660900003c</td>\n",
       "      <td>43094523</td>\n",
       "      <td>01/01/2019 01:33 PM</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>5eece14efc13ae6609000025</td>\n",
       "      <td>42428071</td>\n",
       "      <td>01/01/2019 01:43 PM</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5eece14ffc13ae66090001d4</td>\n",
       "      <td>76472880</td>\n",
       "      <td>01/01/2019 01:54 PM</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5eece14ffc13ae66090000ac</td>\n",
       "      <td>202721843</td>\n",
       "      <td>01/01/2019 02:00 PM</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71795</td>\n",
       "      <td>5eece14ffc13ae660900018c</td>\n",
       "      <td>615389604</td>\n",
       "      <td>12/31/2019 12:37 AM</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71796</td>\n",
       "      <td>5eece14ffc13ae660900010c</td>\n",
       "      <td>348689108</td>\n",
       "      <td>12/31/2019 12:50 PM</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71797</td>\n",
       "      <td>5eece14ffc13ae6609000190</td>\n",
       "      <td>619052165</td>\n",
       "      <td>12/31/2019 12:51 AM</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71798</td>\n",
       "      <td>5eece14efc13ae6609000067</td>\n",
       "      <td>426384418</td>\n",
       "      <td>12/31/2019 12:51 PM</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71799</td>\n",
       "      <td>5eece14ffc13ae6609000110</td>\n",
       "      <td>165390871</td>\n",
       "      <td>12/31/2019 12:54 AM</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>71800 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        user_id    post_id           time_stamp  Valuable\n",
       "0      5eece14ffc13ae660900008b  136781766  01/01/2019 01:30 PM         3\n",
       "1      5eece14efc13ae660900003c   43094523  01/01/2019 01:33 PM         3\n",
       "2      5eece14efc13ae6609000025   42428071  01/01/2019 01:43 PM         3\n",
       "3      5eece14ffc13ae66090001d4   76472880  01/01/2019 01:54 PM         3\n",
       "4      5eece14ffc13ae66090000ac  202721843  01/01/2019 02:00 PM         2\n",
       "...                         ...        ...                  ...       ...\n",
       "71795  5eece14ffc13ae660900018c  615389604  12/31/2019 12:37 AM         5\n",
       "71796  5eece14ffc13ae660900010c  348689108  12/31/2019 12:50 PM         2\n",
       "71797  5eece14ffc13ae6609000190  619052165  12/31/2019 12:51 AM         5\n",
       "71798  5eece14efc13ae6609000067  426384418  12/31/2019 12:51 PM         1\n",
       "71799  5eece14ffc13ae6609000110  165390871  12/31/2019 12:54 AM         5\n",
       "\n",
       "[71800 rows x 4 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#this is our data right now.\n",
    "dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>post_id</th>\n",
       "      <th>time_stamp</th>\n",
       "      <th>Valuable</th>\n",
       "      <th>title</th>\n",
       "      <th>category</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>71795</td>\n",
       "      <td>5eece14ffc13ae66090000c3</td>\n",
       "      <td>810223923</td>\n",
       "      <td>08/28/2019 06:32 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>graphic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71796</td>\n",
       "      <td>5eece14efc13ae6609000073</td>\n",
       "      <td>810223923</td>\n",
       "      <td>09/15/2019 06:58 PM</td>\n",
       "      <td>5</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>graphic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71797</td>\n",
       "      <td>5eece14ffc13ae660900017d</td>\n",
       "      <td>810223923</td>\n",
       "      <td>10/31/2019 09:50 PM</td>\n",
       "      <td>2</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>graphic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71798</td>\n",
       "      <td>5eece14ffc13ae66090000e3</td>\n",
       "      <td>810223923</td>\n",
       "      <td>12/04/2019 03:56 PM</td>\n",
       "      <td>1</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>graphic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71799</td>\n",
       "      <td>5eece14ffc13ae6609000135</td>\n",
       "      <td>810223923</td>\n",
       "      <td>12/20/2019 09:54 AM</td>\n",
       "      <td>5</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>graphic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        user_id    post_id           time_stamp  Valuable  \\\n",
       "71795  5eece14ffc13ae66090000c3  810223923  08/28/2019 06:32 PM         1   \n",
       "71796  5eece14efc13ae6609000073  810223923  09/15/2019 06:58 PM         5   \n",
       "71797  5eece14ffc13ae660900017d  810223923  10/31/2019 09:50 PM         2   \n",
       "71798  5eece14ffc13ae66090000e3  810223923  12/04/2019 03:56 PM         1   \n",
       "71799  5eece14ffc13ae6609000135  810223923  12/20/2019 09:54 AM         5   \n",
       "\n",
       "                                                   title category  \n",
       "71795   7 and a Half Very Simple Things You Can Do To...  graphic  \n",
       "71796   7 and a Half Very Simple Things You Can Do To...  graphic  \n",
       "71797   7 and a Half Very Simple Things You Can Do To...  graphic  \n",
       "71798   7 and a Half Very Simple Things You Can Do To...  graphic  \n",
       "71799   7 and a Half Very Simple Things You Can Do To...  graphic  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# in this cell we are merging view data and the dataframe I have made of post data. in this post id is common.\n",
    "\n",
    "df = pd.merge(dataframe, post_data ,on='post_id')\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "#drop the irrevelent features i.e category is important but not for this. and also time_stamp is not \n",
    "#important right now.\n",
    "data = df.drop(['time_stamp', 'category'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>post_id</th>\n",
       "      <th>Valuable</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>71795</td>\n",
       "      <td>5eece14ffc13ae66090000c3</td>\n",
       "      <td>810223923</td>\n",
       "      <td>1</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71796</td>\n",
       "      <td>5eece14efc13ae6609000073</td>\n",
       "      <td>810223923</td>\n",
       "      <td>5</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71797</td>\n",
       "      <td>5eece14ffc13ae660900017d</td>\n",
       "      <td>810223923</td>\n",
       "      <td>2</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71798</td>\n",
       "      <td>5eece14ffc13ae66090000e3</td>\n",
       "      <td>810223923</td>\n",
       "      <td>1</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71799</td>\n",
       "      <td>5eece14ffc13ae6609000135</td>\n",
       "      <td>810223923</td>\n",
       "      <td>5</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        user_id    post_id  Valuable  \\\n",
       "71795  5eece14ffc13ae66090000c3  810223923         1   \n",
       "71796  5eece14efc13ae6609000073  810223923         5   \n",
       "71797  5eece14ffc13ae660900017d  810223923         2   \n",
       "71798  5eece14ffc13ae66090000e3  810223923         1   \n",
       "71799  5eece14ffc13ae6609000135  810223923         5   \n",
       "\n",
       "                                                   title  \n",
       "71795   7 and a Half Very Simple Things You Can Do To...  \n",
       "71796   7 and a Half Very Simple Things You Can Do To...  \n",
       "71797   7 and a Half Very Simple Things You Can Do To...  \n",
       "71798   7 and a Half Very Simple Things You Can Do To...  \n",
       "71799   7 and a Half Very Simple Things You Can Do To...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>totalValuableCount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>10 Funny ART Quotes</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>10 Funny BANKING Quotes</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>10 Funny BUSINESS Quotes</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>10 Funny CRAFT Quotes</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>10 Funny DANCE Quotes</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       title  totalValuableCount\n",
       "0        10 Funny ART Quotes                  15\n",
       "1    10 Funny BANKING Quotes                  10\n",
       "2   10 Funny BUSINESS Quotes                  13\n",
       "3      10 Funny CRAFT Quotes                   9\n",
       "4      10 Funny DANCE Quotes                  19"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# In this first we have to make a column here that consists of total ratings a title or a post have. \n",
    "#like 10 Funny ART Quotes has 15 votes given by users.\n",
    "\n",
    "combine_post_rating = data.dropna(axis = 0, subset = ['title'])\n",
    "\n",
    "post_ratingCount = (combine_post_rating.\n",
    "     groupby(by = ['title'])['Valuable'].\n",
    "     count().\n",
    "     reset_index().\n",
    "     rename(columns = {'Valuable': 'totalValuableCount'})\n",
    "     [['title', 'totalValuableCount']]\n",
    "    )\n",
    "post_ratingCount.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>post_id</th>\n",
       "      <th>Valuable</th>\n",
       "      <th>title</th>\n",
       "      <th>totalValuableCount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>71795</td>\n",
       "      <td>5eece14ffc13ae66090000c3</td>\n",
       "      <td>810223923</td>\n",
       "      <td>1</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71796</td>\n",
       "      <td>5eece14efc13ae6609000073</td>\n",
       "      <td>810223923</td>\n",
       "      <td>5</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71797</td>\n",
       "      <td>5eece14ffc13ae660900017d</td>\n",
       "      <td>810223923</td>\n",
       "      <td>2</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71798</td>\n",
       "      <td>5eece14ffc13ae66090000e3</td>\n",
       "      <td>810223923</td>\n",
       "      <td>1</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71799</td>\n",
       "      <td>5eece14ffc13ae6609000135</td>\n",
       "      <td>810223923</td>\n",
       "      <td>5</td>\n",
       "      <td>7 and a Half Very Simple Things You Can Do To...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        user_id    post_id  Valuable  \\\n",
       "71795  5eece14ffc13ae66090000c3  810223923         1   \n",
       "71796  5eece14efc13ae6609000073  810223923         5   \n",
       "71797  5eece14ffc13ae660900017d  810223923         2   \n",
       "71798  5eece14ffc13ae66090000e3  810223923         1   \n",
       "71799  5eece14ffc13ae6609000135  810223923         5   \n",
       "\n",
       "                                                   title  totalValuableCount  \n",
       "71795   7 and a Half Very Simple Things You Can Do To...                   5  \n",
       "71796   7 and a Half Very Simple Things You Can Do To...                   5  \n",
       "71797   7 and a Half Very Simple Things You Can Do To...                   5  \n",
       "71798   7 and a Half Very Simple Things You Can Do To...                   5  \n",
       "71799   7 and a Half Very Simple Things You Can Do To...                   5  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "#Merge it into our main dataset \n",
    "rating_with_totalValuableCount = combine_post_rating.merge(post_ratingCount, left_on = 'title', right_on = 'title', how = 'left')\n",
    "rating_with_totalValuableCount.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "count   6000.000\n",
      "mean      11.967\n",
      "std        3.449\n",
      "min        2.000\n",
      "25%       10.000\n",
      "50%       12.000\n",
      "75%       14.000\n",
      "max       24.000\n",
      "Name: totalValuableCount, dtype: float64\n"
     ]
    }
   ],
   "source": [
    "#It is just how to see data desciption and stuff.\n",
    "pd.set_option('display.float_format', lambda x: '%.3f' % x)\n",
    "print(post_ratingCount['totalValuableCount'].describe())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.900   17.000\n",
      "0.910   17.000\n",
      "0.920   17.000\n",
      "0.930   17.000\n",
      "0.940   18.000\n",
      "0.950   18.000\n",
      "0.960   18.000\n",
      "0.970   19.000\n",
      "0.980   19.020\n",
      "0.990   21.000\n",
      "Name: totalValuableCount, dtype: float64\n"
     ]
    }
   ],
   "source": [
    "print(post_ratingCount['totalValuableCount'].quantile(np.arange(.9, 1, .01)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>post_id</th>\n",
       "      <th>Valuable</th>\n",
       "      <th>title</th>\n",
       "      <th>totalValuableCount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>71697</td>\n",
       "      <td>5eece14ffc13ae66090001bb</td>\n",
       "      <td>36975738</td>\n",
       "      <td>4</td>\n",
       "      <td>I Don't Want To Spend This Much Time On MUSIC...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71698</td>\n",
       "      <td>5eece14ffc13ae660900012d</td>\n",
       "      <td>36975738</td>\n",
       "      <td>3</td>\n",
       "      <td>I Don't Want To Spend This Much Time On MUSIC...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71699</td>\n",
       "      <td>5eece14efc13ae660900006c</td>\n",
       "      <td>36975738</td>\n",
       "      <td>5</td>\n",
       "      <td>I Don't Want To Spend This Much Time On MUSIC...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71700</td>\n",
       "      <td>5eece14ffc13ae660900007e</td>\n",
       "      <td>36975738</td>\n",
       "      <td>5</td>\n",
       "      <td>I Don't Want To Spend This Much Time On MUSIC...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71701</td>\n",
       "      <td>5eece14efc13ae6609000048</td>\n",
       "      <td>36975738</td>\n",
       "      <td>2</td>\n",
       "      <td>I Don't Want To Spend This Much Time On MUSIC...</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        user_id   post_id  Valuable  \\\n",
       "71697  5eece14ffc13ae66090001bb  36975738         4   \n",
       "71698  5eece14ffc13ae660900012d  36975738         3   \n",
       "71699  5eece14efc13ae660900006c  36975738         5   \n",
       "71700  5eece14ffc13ae660900007e  36975738         5   \n",
       "71701  5eece14efc13ae6609000048  36975738         2   \n",
       "\n",
       "                                                   title  totalValuableCount  \n",
       "71697   I Don't Want To Spend This Much Time On MUSIC...                  13  \n",
       "71698   I Don't Want To Spend This Much Time On MUSIC...                  13  \n",
       "71699   I Don't Want To Spend This Much Time On MUSIC...                  13  \n",
       "71700   I Don't Want To Spend This Much Time On MUSIC...                  13  \n",
       "71701   I Don't Want To Spend This Much Time On MUSIC...                  13  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#we have to fix a threshold here that machine will recommend post to user that have votes greater than\n",
    "# the threshold values\n",
    "popularity_threshold = 13\n",
    "rating_popular_post = rating_with_totalValuableCount.query('totalValuableCount >= @popularity_threshold')\n",
    "rating_popular_post.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(38292, 5)"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rating_popular_post.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>first_name</th>\n",
       "      <th>last_name</th>\n",
       "      <th>gender</th>\n",
       "      <th>avatar</th>\n",
       "      <th>city</th>\n",
       "      <th>academics</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>5eece14efc13ae6609000000</td>\n",
       "      <td>Milena</td>\n",
       "      <td>Lacelett</td>\n",
       "      <td>Female</td>\n",
       "      <td>https://robohash.org/quisidomnis.png?size=50x5...</td>\n",
       "      <td>Blagoveshchensk</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>5eece14efc13ae6609000001</td>\n",
       "      <td>Nolan</td>\n",
       "      <td>Satcher</td>\n",
       "      <td>Male</td>\n",
       "      <td>https://robohash.org/dignissimosrepudiandaedol...</td>\n",
       "      <td>Wufeng</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>5eece14efc13ae6609000002</td>\n",
       "      <td>Eveleen</td>\n",
       "      <td>Cotterell</td>\n",
       "      <td>Female</td>\n",
       "      <td>https://robohash.org/remomnissuscipit.png?size...</td>\n",
       "      <td>Barra Bonita</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5eece14efc13ae6609000003</td>\n",
       "      <td>Petrina</td>\n",
       "      <td>Berr</td>\n",
       "      <td>Female</td>\n",
       "      <td>https://robohash.org/estquasconsectetur.png?si...</td>\n",
       "      <td>San Angelo</td>\n",
       "      <td>undergraduate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5eece14efc13ae6609000004</td>\n",
       "      <td>Saunderson</td>\n",
       "      <td>Duquesnay</td>\n",
       "      <td>Male</td>\n",
       "      <td>https://robohash.org/nullaaest.png?size=50x50&amp;...</td>\n",
       "      <td>Olszówka</td>\n",
       "      <td>graduate</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    user_id  first_name  last_name  gender  \\\n",
       "0  5eece14efc13ae6609000000      Milena   Lacelett  Female   \n",
       "1  5eece14efc13ae6609000001       Nolan    Satcher    Male   \n",
       "2  5eece14efc13ae6609000002     Eveleen  Cotterell  Female   \n",
       "3  5eece14efc13ae6609000003     Petrina       Berr  Female   \n",
       "4  5eece14efc13ae6609000004  Saunderson  Duquesnay    Male   \n",
       "\n",
       "                                              avatar             city  \\\n",
       "0  https://robohash.org/quisidomnis.png?size=50x5...  Blagoveshchensk   \n",
       "1  https://robohash.org/dignissimosrepudiandaedol...           Wufeng   \n",
       "2  https://robohash.org/remomnissuscipit.png?size...     Barra Bonita   \n",
       "3  https://robohash.org/estquasconsectetur.png?si...       San Angelo   \n",
       "4  https://robohash.org/nullaaest.png?size=50x50&...         Olszówka   \n",
       "\n",
       "       academics  \n",
       "0  undergraduate  \n",
       "1  undergraduate  \n",
       "2  undergraduate  \n",
       "3  undergraduate  \n",
       "4       graduate  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "491"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(user_data.city.unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Making model from here.\n",
    "we have to make a data matrix like indexes are titles and columns are user id and target is how valuable or how much likes it have."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Use here cosine similiarity to find the simliarity between user and other users."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NearestNeighbors(algorithm='brute', leaf_size=30, metric='cosine',\n",
       "                 metric_params=None, n_jobs=None, n_neighbors=5, p=2,\n",
       "                 radius=1.0)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from scipy.sparse import csr_matrix\n",
    "rating_popular_post = rating_popular_post.drop_duplicates(['user_id', 'title'])\n",
    "rating_popular_post_pivot = rating_popular_post.pivot(index = 'title', columns = 'user_id', values = 'Valuable').fillna(0)\n",
    "rating_popular_post_matrix = csr_matrix(rating_popular_post_pivot.values)\n",
    "\n",
    "from sklearn.neighbors import NearestNeighbors\n",
    "\n",
    "\n",
    "model_knn = NearestNeighbors(metric = 'cosine', algorithm = 'brute')\n",
    "model_knn.fit(rating_popular_post_matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2513"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rating_popular_post_pivot.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>user_id</th>\n",
       "      <th>5eece14efc13ae6609000000</th>\n",
       "      <th>5eece14efc13ae6609000001</th>\n",
       "      <th>5eece14efc13ae6609000002</th>\n",
       "      <th>5eece14efc13ae6609000003</th>\n",
       "      <th>5eece14efc13ae6609000004</th>\n",
       "      <th>5eece14efc13ae6609000005</th>\n",
       "      <th>5eece14efc13ae6609000006</th>\n",
       "      <th>5eece14efc13ae6609000007</th>\n",
       "      <th>5eece14efc13ae6609000008</th>\n",
       "      <th>5eece14efc13ae6609000009</th>\n",
       "      <th>...</th>\n",
       "      <th>5eece14ffc13ae66090001ea</th>\n",
       "      <th>5eece14ffc13ae66090001eb</th>\n",
       "      <th>5eece14ffc13ae66090001ec</th>\n",
       "      <th>5eece14ffc13ae66090001ed</th>\n",
       "      <th>5eece14ffc13ae66090001ee</th>\n",
       "      <th>5eece14ffc13ae66090001ef</th>\n",
       "      <th>5eece14ffc13ae66090001f0</th>\n",
       "      <th>5eece14ffc13ae66090001f1</th>\n",
       "      <th>5eece14ffc13ae66090001f2</th>\n",
       "      <th>5eece14ffc13ae66090001f3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>10 Funny ART Quotes</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10 Funny BUSINESS Quotes</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10 Funny DANCE Quotes</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10 Funny DRAWING Quotes</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10 Funny GRAPHIC Quotes</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>ZOOLOGY Your Way To Success</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>ZOOLOGY: An Incredibly Easy Method That Works For All</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>ZOOLOGY: Do You Really Need It? This Will Help You Decide!</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>ZOOLOGY: The Samurai Way</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>ZOOLOGY? It's Easy If You Do It Smart</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2513 rows × 495 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "user_id                                             5eece14efc13ae6609000000  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000001  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000002  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000003  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000004  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   3.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000005  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000006  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000007  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000008  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14efc13ae6609000009  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  1.000   \n",
       "\n",
       "user_id                                             ...  \\\n",
       "title                                               ...   \n",
       " 10 Funny ART Quotes                                ...   \n",
       " 10 Funny BUSINESS Quotes                           ...   \n",
       " 10 Funny DANCE Quotes                              ...   \n",
       " 10 Funny DRAWING Quotes                            ...   \n",
       " 10 Funny GRAPHIC Quotes                            ...   \n",
       "...                                                 ...   \n",
       "ZOOLOGY Your Way To Success                         ...   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...  ...   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...  ...   \n",
       "ZOOLOGY: The Samurai Way                            ...   \n",
       "ZOOLOGY? It's Easy If You Do It Smart               ...   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001ea  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     5.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001eb  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001ec  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001ed  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001ee  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  2.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001ef  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001f0  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   5.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001f1  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001f2  \\\n",
       "title                                                                          \n",
       " 10 Funny ART Quotes                                                   0.000   \n",
       " 10 Funny BUSINESS Quotes                                              0.000   \n",
       " 10 Funny DANCE Quotes                                                 0.000   \n",
       " 10 Funny DRAWING Quotes                                               0.000   \n",
       " 10 Funny GRAPHIC Quotes                                               0.000   \n",
       "...                                                                      ...   \n",
       "ZOOLOGY Your Way To Success                                            0.000   \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000   \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000   \n",
       "ZOOLOGY: The Samurai Way                                               0.000   \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000   \n",
       "\n",
       "user_id                                             5eece14ffc13ae66090001f3  \n",
       "title                                                                         \n",
       " 10 Funny ART Quotes                                                   0.000  \n",
       " 10 Funny BUSINESS Quotes                                              0.000  \n",
       " 10 Funny DANCE Quotes                                                 0.000  \n",
       " 10 Funny DRAWING Quotes                                               0.000  \n",
       " 10 Funny GRAPHIC Quotes                                               0.000  \n",
       "...                                                                      ...  \n",
       "ZOOLOGY Your Way To Success                                            0.000  \n",
       "ZOOLOGY: An Incredibly Easy Method That Works F...                     0.000  \n",
       "ZOOLOGY: Do You Really Need It? This Will Help ...                     0.000  \n",
       "ZOOLOGY: The Samurai Way                                               0.000  \n",
       "ZOOLOGY? It's Easy If You Do It Smart                                  0.000  \n",
       "\n",
       "[2513 rows x 495 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rating_popular_post_pivot"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Choose a random users and recommend it a title of post by looking their cosine simliarity scores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "186\n"
     ]
    }
   ],
   "source": [
    "query_index = np.random.choice(rating_popular_post_pivot.shape[0])\n",
    "print(query_index)\n",
    "distances, indices = model_knn.kneighbors(rating_popular_post_pivot.iloc[query_index,:].values.reshape(1, -1), n_neighbors = 6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "' 3 Mistakes In DANCE That Make You Look Dumb'"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# this is our name of user 3 and title he has seen or vote it and our task is to recommend it similiar\n",
    "#post\n",
    "rating_popular_post_pivot.index[query_index]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Recommendations for  3 Mistakes In DANCE That Make You Look Dumb:\n",
      "\n",
      "1:  Never Changing GRAPHIC Will Eventually Destroy You, with distance of 0.7032371623363501:\n",
      "2:  10 Tips That Will Make You Influential In CRAFT, with distance of 0.7267841024811379:\n",
      "3:  Fall In Love With OPERATING SYSTEM, with distance of 0.7402270129541558:\n",
      "4:  How To Save Money with SCIENCE?, with distance of 0.7407620763173937:\n",
      "5:  Sick And Tired Of Doing BUSINESS The Old Way? Read This, with distance of 0.7452830038796782:\n"
     ]
    }
   ],
   "source": [
    "#Here we go\n",
    "for i in range(0, len(distances.flatten())):\n",
    "    if i == 0:\n",
    "        print('Recommendations for {0}:\\n'.format(rating_popular_post_pivot.index[query_index]))\n",
    "    else:\n",
    "        print('{0}: {1}, with distance of {2}:'.format(i, rating_popular_post_pivot.index[indices.flatten()[i]], distances.flatten()[i]))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}