product recommendation for pmp.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "ename": "ModuleNotFoundError",
     "evalue": "No module named 'turicreate'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mModuleNotFoundError\u001b[0m                       Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-26-c0031596582c>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[1;32mimport\u001b[0m \u001b[0mturicreate\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0mtc\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m \u001b[1;32mfrom\u001b[0m \u001b[0msklearn\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mmodel_selection\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mtrain_test_split\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mpandas\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mnumpy\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0mnp\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mModuleNotFoundError\u001b[0m: No module named 'turicreate'"
     ]
    }
   ],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"C:/Users/prime/Downloads/report_8f25df58-dbda-43b3-aae6-06062ecb9408 - report_8f25df58-dbda-43b3-aae6-06062ecb9408.csv\")"
   ]
  },
  {
   "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>order_id</th>\n",
       "      <th>product_id</th>\n",
       "      <th>product_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>00dff8e7-8325-4883-8e15-f1ba68d8cb0e</td>\n",
       "      <td>fe849f4f-904a-4e77-a0f8-05a7dadde04e</td>\n",
       "      <td>iPhone 11 Pro Defender Case Pink</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>00dff8e7-8325-4883-8e15-f1ba68d8cb0e</td>\n",
       "      <td>5df057fc-9f95-4e93-8e84-d8d8b6313786</td>\n",
       "      <td>iPhone 11 Pro Silicon Case Black</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>00dff8e7-8325-4883-8e15-f1ba68d8cb0e</td>\n",
       "      <td>beba627b-fad2-4d4f-aa8c-be0938bfa8a5</td>\n",
       "      <td>iPhone 11 Pro Sparkle Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>00dff8e7-8325-4883-8e15-f1ba68d8cb0e</td>\n",
       "      <td>3a2ed5a6-a99f-4556-9a3d-f3b2573c246f</td>\n",
       "      <td>iPhone 11 Pro OT SM with Grip Red</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>00dff8e7-8325-4883-8e15-f1ba68d8cb0e</td>\n",
       "      <td>e9135d4c-e363-48c3-ba7b-7a18b3145f0a</td>\n",
       "      <td>iPhone 11 Pro Defender Case Clear</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   user_id                              order_id  \\\n",
       "0   1100.0  00dff8e7-8325-4883-8e15-f1ba68d8cb0e   \n",
       "1   1100.0  00dff8e7-8325-4883-8e15-f1ba68d8cb0e   \n",
       "2   1100.0  00dff8e7-8325-4883-8e15-f1ba68d8cb0e   \n",
       "3   1100.0  00dff8e7-8325-4883-8e15-f1ba68d8cb0e   \n",
       "4   1100.0  00dff8e7-8325-4883-8e15-f1ba68d8cb0e   \n",
       "\n",
       "                             product_id                       product_name  \n",
       "0  fe849f4f-904a-4e77-a0f8-05a7dadde04e   iPhone 11 Pro Defender Case Pink  \n",
       "1  5df057fc-9f95-4e93-8e84-d8d8b6313786   iPhone 11 Pro Silicon Case Black  \n",
       "2  beba627b-fad2-4d4f-aa8c-be0938bfa8a5          iPhone 11 Pro Sparkle Red  \n",
       "3  3a2ed5a6-a99f-4556-9a3d-f3b2573c246f  iPhone 11 Pro OT SM with Grip Red  \n",
       "4  e9135d4c-e363-48c3-ba7b-7a18b3145f0a  iPhone 11 Pro Defender Case Clear  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.melt(df.set_index('user_id')['product_id'].apply(pd.Series).reset_index(), \n",
    "             id_vars=['user_id'],\n",
    "             value_name='product_id') \\\n",
    "    .dropna().drop(['variable'], axis=1) \\\n",
    "    .groupby(['user_id', 'product_id']) \\\n",
    "    .agg({'product_id': 'count'}) \\\n",
    "    .rename(columns={'product_id': 'purchase_count'}) \\\n",
    "    .reset_index() \\\n",
    "    .rename(columns={'product_id': 'productId'})"
   ]
  },
  {
   "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>productId</th>\n",
       "      <th>purchase_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10686</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1560</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2092</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2226</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   user_id productId  purchase_count\n",
       "0      1.0     10686               1\n",
       "1      1.0        13               1\n",
       "2      1.0      1560               1\n",
       "3      1.0      2092               1\n",
       "4      1.0      2226               1"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "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>user_id</th>\n",
       "      <th>productId</th>\n",
       "      <th>purchase_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>737.0</td>\n",
       "      <td>249</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>23eb0740-b1da-455b-8105-ef628fd8adb9</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>737.0</td>\n",
       "      <td>200</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>e804aaae-6268-4117-8fcb-2302825be98a</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>737.0</td>\n",
       "      <td>86</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     user_id                             productId  purchase_count\n",
       "159    737.0                                   249               7\n",
       "935   1100.0  23eb0740-b1da-455b-8105-ef628fd8adb9               6\n",
       "152    737.0                                   200               6\n",
       "996   1100.0  e804aaae-6268-4117-8fcb-2302825be98a               5\n",
       "314    737.0                                    86               5"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values(by=['purchase_count'], ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_raw = pd.DataFrame(data)\n",
    "df_matrix = pd.pivot_table(data, values='purchase_count', index='user_id', columns='productId')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>productId</th>\n",
       "      <th>000051b3-1cbd-47d3-8e00-e2e40475734c</th>\n",
       "      <th>00db3026-4d10-433d-b99c-43d373cd8690</th>\n",
       "      <th>03190770-b63a-4b2d-896f-365731d134c0</th>\n",
       "      <th>03dc66b3-e7e7-40cc-ae36-80bf989e0d30</th>\n",
       "      <th>05678e16-dbb8-4236-9ae9-431600c46b19</th>\n",
       "      <th>073423e6-b298-40eb-92bd-666601ab6755</th>\n",
       "      <th>07ce3275-6366-422b-bf89-a2935a633b75</th>\n",
       "      <th>07e19476-ebc2-415c-bbef-883797f6c2bc</th>\n",
       "      <th>08e44c36-28e9-4cce-8587-94af55561732</th>\n",
       "      <th>0a899187-4249-4dd0-97be-aeb5273aae03</th>\n",
       "      <th>...</th>\n",
       "      <th>f292bfa2-f11b-43c3-9053-1fe5f9e30a08</th>\n",
       "      <th>f3ee6a3b-0983-4b0b-a56d-cb6a0f51d7e7</th>\n",
       "      <th>f59a2078-7b73-4bf5-af9a-4aad56b33184</th>\n",
       "      <th>f68dea18-76dc-463e-a3a2-2793b694f811</th>\n",
       "      <th>f72efb77-cb51-471f-9c20-340169b34eb8</th>\n",
       "      <th>f76c81c0-691b-48b2-b60d-3a73f8391151</th>\n",
       "      <th>f848b34f-f277-4db0-b98f-53b6e4f2b0cd</th>\n",
       "      <th>fe53696f-5592-433d-a8e2-488e5917e3a3</th>\n",
       "      <th>fe702c47-582b-4b27-98cd-42cd91d89f5c</th>\n",
       "      <th>fe849f4f-904a-4e77-a0f8-05a7dadde04e</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</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",
       "      <th>1.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1087.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1093.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1094.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1096.0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1098.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1100.0</th>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1101.0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1102.0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1103.0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1104.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1105.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1107.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1109.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1110.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1111.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1112.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1114.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 1004 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "productId  000051b3-1cbd-47d3-8e00-e2e40475734c  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         1.0   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      3.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      1.0   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  00db3026-4d10-433d-b99c-43d373cd8690  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      1.0   \n",
       "1100.0                                      3.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  03190770-b63a-4b2d-896f-365731d134c0  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      2.0   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  03dc66b3-e7e7-40cc-ae36-80bf989e0d30  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  05678e16-dbb8-4236-9ae9-431600c46b19  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      2.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  073423e6-b298-40eb-92bd-666601ab6755  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  07ce3275-6366-422b-bf89-a2935a633b75  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      1.0   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  07e19476-ebc2-415c-bbef-883797f6c2bc  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      1.0   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  08e44c36-28e9-4cce-8587-94af55561732  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      1.0   \n",
       "1100.0                                      4.0   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  0a899187-4249-4dd0-97be-aeb5273aae03  ...  \\\n",
       "user_id                                          ...   \n",
       "1.0                                         NaN  ...   \n",
       "6.0                                         NaN  ...   \n",
       "8.0                                         NaN  ...   \n",
       "10.0                                        NaN  ...   \n",
       "12.0                                        NaN  ...   \n",
       "685.0                                       NaN  ...   \n",
       "737.0                                       NaN  ...   \n",
       "1020.0                                      NaN  ...   \n",
       "1087.0                                      NaN  ...   \n",
       "1093.0                                      NaN  ...   \n",
       "1094.0                                      NaN  ...   \n",
       "1096.0                                      NaN  ...   \n",
       "1098.0                                      NaN  ...   \n",
       "1100.0                                      NaN  ...   \n",
       "1101.0                                      1.0  ...   \n",
       "1102.0                                      NaN  ...   \n",
       "1103.0                                      1.0  ...   \n",
       "1104.0                                      NaN  ...   \n",
       "1105.0                                      NaN  ...   \n",
       "1107.0                                      1.0  ...   \n",
       "1109.0                                      NaN  ...   \n",
       "1110.0                                      NaN  ...   \n",
       "1111.0                                      NaN  ...   \n",
       "1112.0                                      NaN  ...   \n",
       "1114.0                                      NaN  ...   \n",
       "\n",
       "productId  f292bfa2-f11b-43c3-9053-1fe5f9e30a08  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      3.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      1.0   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f3ee6a3b-0983-4b0b-a56d-cb6a0f51d7e7  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f59a2078-7b73-4bf5-af9a-4aad56b33184  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      1.0   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      1.0   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f68dea18-76dc-463e-a3a2-2793b694f811  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         1.0   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      2.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      1.0   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f72efb77-cb51-471f-9c20-340169b34eb8  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f76c81c0-691b-48b2-b60d-3a73f8391151  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      1.0   \n",
       "1100.0                                      3.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      1.0   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f848b34f-f277-4db0-b98f-53b6e4f2b0cd  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      2.0   \n",
       "1100.0                                      2.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  fe53696f-5592-433d-a8e2-488e5917e3a3  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      1.0   \n",
       "1100.0                                      3.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      1.0   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      1.0   \n",
       "\n",
       "productId  fe702c47-582b-4b27-98cd-42cd91d89f5c  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      1.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      2.0   \n",
       "1101.0                                      1.0   \n",
       "1102.0                                      1.0   \n",
       "1103.0                                      1.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  fe849f4f-904a-4e77-a0f8-05a7dadde04e  \n",
       "user_id                                          \n",
       "1.0                                         NaN  \n",
       "6.0                                         NaN  \n",
       "8.0                                         1.0  \n",
       "10.0                                        NaN  \n",
       "12.0                                        NaN  \n",
       "685.0                                       NaN  \n",
       "737.0                                       NaN  \n",
       "1020.0                                      NaN  \n",
       "1087.0                                      NaN  \n",
       "1093.0                                      NaN  \n",
       "1094.0                                      NaN  \n",
       "1096.0                                      NaN  \n",
       "1098.0                                      NaN  \n",
       "1100.0                                      3.0  \n",
       "1101.0                                      1.0  \n",
       "1102.0                                      1.0  \n",
       "1103.0                                      1.0  \n",
       "1104.0                                      NaN  \n",
       "1105.0                                      NaN  \n",
       "1107.0                                      NaN  \n",
       "1109.0                                      NaN  \n",
       "1110.0                                      1.0  \n",
       "1111.0                                      NaN  \n",
       "1112.0                                      NaN  \n",
       "1114.0                                      NaN  \n",
       "\n",
       "[25 rows x 1004 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matrix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_matrix_norm = (df_matrix-df_matrix.min())/(df_matrix.max()-df_matrix.min())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>productId</th>\n",
       "      <th>000051b3-1cbd-47d3-8e00-e2e40475734c</th>\n",
       "      <th>00db3026-4d10-433d-b99c-43d373cd8690</th>\n",
       "      <th>03190770-b63a-4b2d-896f-365731d134c0</th>\n",
       "      <th>03dc66b3-e7e7-40cc-ae36-80bf989e0d30</th>\n",
       "      <th>05678e16-dbb8-4236-9ae9-431600c46b19</th>\n",
       "      <th>073423e6-b298-40eb-92bd-666601ab6755</th>\n",
       "      <th>07ce3275-6366-422b-bf89-a2935a633b75</th>\n",
       "      <th>07e19476-ebc2-415c-bbef-883797f6c2bc</th>\n",
       "      <th>08e44c36-28e9-4cce-8587-94af55561732</th>\n",
       "      <th>0a899187-4249-4dd0-97be-aeb5273aae03</th>\n",
       "      <th>...</th>\n",
       "      <th>f292bfa2-f11b-43c3-9053-1fe5f9e30a08</th>\n",
       "      <th>f3ee6a3b-0983-4b0b-a56d-cb6a0f51d7e7</th>\n",
       "      <th>f59a2078-7b73-4bf5-af9a-4aad56b33184</th>\n",
       "      <th>f68dea18-76dc-463e-a3a2-2793b694f811</th>\n",
       "      <th>f72efb77-cb51-471f-9c20-340169b34eb8</th>\n",
       "      <th>f76c81c0-691b-48b2-b60d-3a73f8391151</th>\n",
       "      <th>f848b34f-f277-4db0-b98f-53b6e4f2b0cd</th>\n",
       "      <th>fe53696f-5592-433d-a8e2-488e5917e3a3</th>\n",
       "      <th>fe702c47-582b-4b27-98cd-42cd91d89f5c</th>\n",
       "      <th>fe849f4f-904a-4e77-a0f8-05a7dadde04e</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</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",
       "      <th>1.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1087.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1093.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1094.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1096.0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1098.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1100.0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1101.0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</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>1102.0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1103.0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</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>1104.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1105.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1107.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1109.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1110.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1111.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1112.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1114.0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 1004 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "productId  000051b3-1cbd-47d3-8e00-e2e40475734c  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         0.0   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      0.0   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  00db3026-4d10-433d-b99c-43d373cd8690  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      0.0   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  03190770-b63a-4b2d-896f-365731d134c0  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  03dc66b3-e7e7-40cc-ae36-80bf989e0d30  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  05678e16-dbb8-4236-9ae9-431600c46b19  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  073423e6-b298-40eb-92bd-666601ab6755  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  07ce3275-6366-422b-bf89-a2935a633b75  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  07e19476-ebc2-415c-bbef-883797f6c2bc  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  08e44c36-28e9-4cce-8587-94af55561732  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      0.0   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  0a899187-4249-4dd0-97be-aeb5273aae03  ...  \\\n",
       "user_id                                          ...   \n",
       "1.0                                         NaN  ...   \n",
       "6.0                                         NaN  ...   \n",
       "8.0                                         NaN  ...   \n",
       "10.0                                        NaN  ...   \n",
       "12.0                                        NaN  ...   \n",
       "685.0                                       NaN  ...   \n",
       "737.0                                       NaN  ...   \n",
       "1020.0                                      NaN  ...   \n",
       "1087.0                                      NaN  ...   \n",
       "1093.0                                      NaN  ...   \n",
       "1094.0                                      NaN  ...   \n",
       "1096.0                                      NaN  ...   \n",
       "1098.0                                      NaN  ...   \n",
       "1100.0                                      NaN  ...   \n",
       "1101.0                                      NaN  ...   \n",
       "1102.0                                      NaN  ...   \n",
       "1103.0                                      NaN  ...   \n",
       "1104.0                                      NaN  ...   \n",
       "1105.0                                      NaN  ...   \n",
       "1107.0                                      NaN  ...   \n",
       "1109.0                                      NaN  ...   \n",
       "1110.0                                      NaN  ...   \n",
       "1111.0                                      NaN  ...   \n",
       "1112.0                                      NaN  ...   \n",
       "1114.0                                      NaN  ...   \n",
       "\n",
       "productId  f292bfa2-f11b-43c3-9053-1fe5f9e30a08  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      0.0   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f3ee6a3b-0983-4b0b-a56d-cb6a0f51d7e7  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f59a2078-7b73-4bf5-af9a-4aad56b33184  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f68dea18-76dc-463e-a3a2-2793b694f811  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         0.0   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      0.0   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f72efb77-cb51-471f-9c20-340169b34eb8  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      NaN   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      NaN   \n",
       "1101.0                                      NaN   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      NaN   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f76c81c0-691b-48b2-b60d-3a73f8391151  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      0.0   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      0.0   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  f848b34f-f277-4db0-b98f-53b6e4f2b0cd  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      1.0   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      NaN   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  fe53696f-5592-433d-a8e2-488e5917e3a3  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      0.0   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      0.0   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      0.0   \n",
       "\n",
       "productId  fe702c47-582b-4b27-98cd-42cd91d89f5c  \\\n",
       "user_id                                           \n",
       "1.0                                         NaN   \n",
       "6.0                                         NaN   \n",
       "8.0                                         NaN   \n",
       "10.0                                        NaN   \n",
       "12.0                                        NaN   \n",
       "685.0                                       NaN   \n",
       "737.0                                       NaN   \n",
       "1020.0                                      NaN   \n",
       "1087.0                                      NaN   \n",
       "1093.0                                      NaN   \n",
       "1094.0                                      NaN   \n",
       "1096.0                                      0.0   \n",
       "1098.0                                      NaN   \n",
       "1100.0                                      1.0   \n",
       "1101.0                                      0.0   \n",
       "1102.0                                      0.0   \n",
       "1103.0                                      0.0   \n",
       "1104.0                                      NaN   \n",
       "1105.0                                      NaN   \n",
       "1107.0                                      NaN   \n",
       "1109.0                                      NaN   \n",
       "1110.0                                      NaN   \n",
       "1111.0                                      NaN   \n",
       "1112.0                                      NaN   \n",
       "1114.0                                      NaN   \n",
       "\n",
       "productId  fe849f4f-904a-4e77-a0f8-05a7dadde04e  \n",
       "user_id                                          \n",
       "1.0                                         NaN  \n",
       "6.0                                         NaN  \n",
       "8.0                                         0.0  \n",
       "10.0                                        NaN  \n",
       "12.0                                        NaN  \n",
       "685.0                                       NaN  \n",
       "737.0                                       NaN  \n",
       "1020.0                                      NaN  \n",
       "1087.0                                      NaN  \n",
       "1093.0                                      NaN  \n",
       "1094.0                                      NaN  \n",
       "1096.0                                      NaN  \n",
       "1098.0                                      NaN  \n",
       "1100.0                                      1.0  \n",
       "1101.0                                      0.0  \n",
       "1102.0                                      0.0  \n",
       "1103.0                                      0.0  \n",
       "1104.0                                      NaN  \n",
       "1105.0                                      NaN  \n",
       "1107.0                                      NaN  \n",
       "1109.0                                      NaN  \n",
       "1110.0                                      0.0  \n",
       "1111.0                                      NaN  \n",
       "1112.0                                      NaN  \n",
       "1114.0                                      NaN  \n",
       "\n",
       "[25 rows x 1004 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_matrix_norm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(529, 3)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>productId</th>\n",
       "      <th>scaled_purchase_freq</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8.0</td>\n",
       "      <td>000051b3-1cbd-47d3-8e00-e2e40475734c</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1096.0</td>\n",
       "      <td>000051b3-1cbd-47d3-8e00-e2e40475734c</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>000051b3-1cbd-47d3-8e00-e2e40475734c</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1101.0</td>\n",
       "      <td>000051b3-1cbd-47d3-8e00-e2e40475734c</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1102.0</td>\n",
       "      <td>000051b3-1cbd-47d3-8e00-e2e40475734c</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    user_id                             productId  scaled_purchase_freq\n",
       "2       8.0  000051b3-1cbd-47d3-8e00-e2e40475734c                   0.0\n",
       "11   1096.0  000051b3-1cbd-47d3-8e00-e2e40475734c                   0.0\n",
       "13   1100.0  000051b3-1cbd-47d3-8e00-e2e40475734c                   1.0\n",
       "14   1101.0  000051b3-1cbd-47d3-8e00-e2e40475734c                   0.0\n",
       "15   1102.0  000051b3-1cbd-47d3-8e00-e2e40475734c                   0.0"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create a table for input to the modeling  \n",
    "d = df_matrix_norm.reset_index() \n",
    "d.index.names = ['scaled_purchase_freq'] \n",
    "data_norm = pd.melt(d, id_vars=['user_id'], value_name='scaled_purchase_freq').dropna()\n",
    "print(data_norm.shape)\n",
    "data_norm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>productId</th>\n",
       "      <th>scaled_purchase_freq</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13288</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>5e9ef4a5-3c8a-4280-93c1-bc7ce02527ed</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7812</th>\n",
       "      <td>1098.0</td>\n",
       "      <td>3f30ca95-6e6e-4a43-aa76-8f4f8e5859e1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24163</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>cb51e076-5e0b-4684-9e2e-57c6215c73fd</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7332</th>\n",
       "      <td>1020.0</td>\n",
       "      <td>3842</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7663</th>\n",
       "      <td>1100.0</td>\n",
       "      <td>3921b850-e11d-47c5-b0f7-5c162ac33f69</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       user_id                             productId  scaled_purchase_freq\n",
       "13288   1100.0  5e9ef4a5-3c8a-4280-93c1-bc7ce02527ed                   1.0\n",
       "7812    1098.0  3f30ca95-6e6e-4a43-aa76-8f4f8e5859e1                   1.0\n",
       "24163   1100.0  cb51e076-5e0b-4684-9e2e-57c6215c73fd                   1.0\n",
       "7332    1020.0                                  3842                   1.0\n",
       "7663    1100.0  3921b850-e11d-47c5-b0f7-5c162ac33f69                   1.0"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_norm.sort_values(by=['scaled_purchase_freq'], ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "def normalize_data(data):\n",
    "    df_matrix = pd.pivot_table(data, values='purchase_count', index='user_id', columns='productId')\n",
    "    df_matrix_norm = (df_matrix-df_matrix.min())/(df_matrix.max()-df_matrix.min())\n",
    "    d = df_matrix_norm.reset_index()\n",
    "    d.index.names = ['scaled_purchase_freq']\n",
    "    return pd.melt(d, id_vars=['user_id'], value_name='scaled_purchase_freq').dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "def split_data(data):\n",
    "    '''\n",
    "    Splits dataset into training and test set.\n",
    "    \n",
    "    Args:\n",
    "        data (pandas.DataFrame)\n",
    "        \n",
    "    Returns\n",
    "        train_data (tc.SFrame)\n",
    "        test_data (tc.SFrame)\n",
    "    '''\n",
    "    train, test = train_test_split(data, test_size = .2)\n",
    "    train_data = tc.SFrame(train)\n",
    "    test_data = tc.SFrame(test)\n",
    "    return train_data, test_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'tc' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-23-357c0616a57b>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mpitrain_data\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtest_data\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0msplit_data\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m \u001b[0mtrain_data_dummy\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtest_data_dummy\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0msplit_data\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_dummy\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[0mtrain_data_norm\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtest_data_norm\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0msplit_data\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_norm\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m<ipython-input-22-1cdb6b1d5325>\u001b[0m in \u001b[0;36msplit_data\u001b[1;34m(data)\u001b[0m\n\u001b[0;32m     11\u001b[0m     '''\n\u001b[0;32m     12\u001b[0m     \u001b[0mtrain\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtest\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mtrain_test_split\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtest_size\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;36m.2\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 13\u001b[1;33m     \u001b[0mtrain_data\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mtc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mSFrame\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mtrain\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     14\u001b[0m     \u001b[0mtest_data\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mtc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mSFrame\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mtest\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     15\u001b[0m     \u001b[1;32mreturn\u001b[0m \u001b[0mtrain_data\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtest_data\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'tc' is not defined"
     ]
    }
   ],
   "source": [
    "pitrain_data, test_data = split_data(data)\n",
    "train_data_dummy, test_data_dummy = split_data(data_dummy)\n",
    "train_data_norm, test_data_norm = split_data(data_norm)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting pip\n",
      "  Downloading https://files.pythonhosted.org/packages/54/0c/d01aa759fdc501a58f431eb594a17495f15b88da142ce14b5845662c13f3/pip-20.0.2-py2.py3-none-any.whl (1.4MB)\n",
      "Collecting setuptools\n",
      "  Downloading https://files.pythonhosted.org/packages/3d/72/1c1498c1e908e0562b1e1cd30012580baa7d33b5b0ffdbeb5fde2462cc71/setuptools-45.2.0-py3-none-any.whl (584kB)\n",
      "Collecting wheel\n",
      "  Downloading https://files.pythonhosted.org/packages/8c/23/848298cccf8e40f5bbb59009b32848a4c38f4e7f3364297ab3c3e2e2cd14/wheel-0.34.2-py2.py3-none-any.whl\n",
      "Installing collected packages: pip, setuptools, wheel\n",
      "  Found existing installation: pip 19.3.1\n",
      "    Uninstalling pip-19.3.1:\n",
      "      Successfully uninstalled pip-19.3.1\n",
      "  Found existing installation: setuptools 41.6.0\n",
      "    Uninstalling setuptools-41.6.0:\n",
      "      Successfully uninstalled setuptools-41.6.0\n",
      "  Found existing installation: wheel 0.33.6\n",
      "    Uninstalling wheel-0.33.6:\n",
      "      Successfully uninstalled wheel-0.33.6\n",
      "Successfully installed pip-20.0.2 setuptools-45.2.0 wheel-0.34.2\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install --upgrade pip setuptools wheel"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting python-language-server\n",
      "  Downloading https://files.pythonhosted.org/packages/ba/91/6e821d478141c05a063170eff73dd7fbb258e2cdb09b4a33e5ce48e0fed7/python-language-server-0.30.0.tar.gz (63kB)\n",
      "Collecting jedi<0.16,>=0.14.1\n",
      "  Downloading https://files.pythonhosted.org/packages/55/54/da994f359e4e7da4776a200e76dbc85ba5fc319eefc22e33d55296d95a1d/jedi-0.15.1-py2.py3-none-any.whl (1.0MB)\n",
      "Collecting python-jsonrpc-server>=0.1.0\n",
      "  Downloading https://files.pythonhosted.org/packages/57/09/aa412ed43a2d2bc4e97df51673c763f51a2a1135bb454b3bcb2433f688c5/python-jsonrpc-server-0.3.0.tar.gz\n",
      "Requirement already satisfied: pluggy in c:\\users\\prime\\anaconda3\\lib\\site-packages (from python-language-server) (0.12.0)\n",
      "Requirement already satisfied: parso>=0.5.0 in c:\\users\\prime\\anaconda3\\lib\\site-packages (from jedi<0.16,>=0.14.1->python-language-server) (0.5.0)\n",
      "Requirement already satisfied: future>=0.14.0 in c:\\users\\prime\\anaconda3\\lib\\site-packages (from python-jsonrpc-server>=0.1.0->python-language-server) (0.17.1)\n",
      "Collecting ujson<=1.35\n",
      "  Downloading https://files.pythonhosted.org/packages/16/c4/79f3409bc710559015464e5f49b9879430d8f87498ecdc335899732e5377/ujson-1.35.tar.gz (192kB)\n",
      "Requirement already satisfied: importlib-metadata>=0.12 in c:\\users\\prime\\anaconda3\\lib\\site-packages (from pluggy->python-language-server) (0.17)\n",
      "Requirement already satisfied: zipp>=0.5 in c:\\users\\prime\\anaconda3\\lib\\site-packages (from importlib-metadata>=0.12->pluggy->python-language-server) (0.5.1)\n",
      "Building wheels for collected packages: python-language-server, python-jsonrpc-server, ujson\n",
      "  Building wheel for python-language-server (setup.py): started\n",
      "  Building wheel for python-language-server (setup.py): finished with status 'done'\n",
      "  Created wheel for python-language-server: filename=python_language_server-0.30.0-cp37-none-any.whl size=45032 sha256=00be62538efc693ab6936c2fb181f1410ba2b4356e0986a8ce11f9bbe9a3bfd3\n",
      "  Stored in directory: C:\\Users\\prime\\AppData\\Local\\pip\\Cache\\wheels\\68\\04\\5a\\2e2d5beb6c98790bf3695ea4eae738bab36fd47b5684a0f546\n",
      "  Building wheel for python-jsonrpc-server (setup.py): started\n",
      "  Building wheel for python-jsonrpc-server (setup.py): finished with status 'done'\n",
      "  Created wheel for python-jsonrpc-server: filename=python_jsonrpc_server-0.3.0-cp37-none-any.whl size=8914 sha256=5e8e6a7a5d3820980298612c83edbc094979dc6e7f3989e2f88408c457b8248c\n",
      "  Stored in directory: C:\\Users\\prime\\AppData\\Local\\pip\\Cache\\wheels\\e9\\43\\92\\5249797fa2dc7e45c8b9c1ec087a9ca54e0f68032d0b0a2c89\n",
      "  Building wheel for ujson (setup.py): started\n",
      "  Building wheel for ujson (setup.py): finished with status 'error'\n",
      "  Running setup.py clean for ujson\n",
      "Successfully built python-language-server python-jsonrpc-server\n",
      "Failed to build ujson\n",
      "Installing collected packages: jedi, ujson, python-jsonrpc-server, python-language-server\n",
      "  Found existing installation: jedi 0.13.3\n",
      "    Uninstalling jedi-0.13.3:\n",
      "      Successfully uninstalled jedi-0.13.3\n",
      "    Running setup.py install for ujson: started\n",
      "    Running setup.py install for ujson: finished with status 'error'\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "  ERROR: Command errored out with exit status 1:\n",
      "   command: 'C:\\Users\\prime\\Anaconda3\\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-5gnqwlt6\\\\ujson\\\\setup.py'\"'\"'; __file__='\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-5gnqwlt6\\\\ujson\\\\setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' bdist_wheel -d 'C:\\Users\\prime\\AppData\\Local\\Temp\\pip-wheel-d7csa3tl' --python-tag cp37\n",
      "       cwd: C:\\Users\\prime\\AppData\\Local\\Temp\\pip-install-5gnqwlt6\\ujson\\\n",
      "  Complete output (6 lines):\n",
      "  Warning: 'classifiers' should be a list, got type 'filter'\n",
      "  running bdist_wheel\n",
      "  running build\n",
      "  running build_ext\n",
      "  building 'ujson' extension\n",
      "  error: Microsoft Visual C++ 14.0 is required. Get it with \"Build Tools for Visual Studio\": https://visualstudio.microsoft.com/downloads/\n",
      "  ----------------------------------------\n",
      "  ERROR: Failed building wheel for ujson\n",
      "ERROR: spyder 3.3.6 requires pyqt5<5.13; python_version >= \"3\", which is not installed.\n",
      "ERROR: spyder 3.3.6 requires pyqtwebengine<5.13; python_version >= \"3\", which is not installed.\n",
      "    ERROR: Command errored out with exit status 1:\n",
      "     command: 'C:\\Users\\prime\\Anaconda3\\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-5gnqwlt6\\\\ujson\\\\setup.py'\"'\"'; __file__='\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-5gnqwlt6\\\\ujson\\\\setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' install --record 'C:\\Users\\prime\\AppData\\Local\\Temp\\pip-record-mf9ew5e_\\install-record.txt' --single-version-externally-managed --compile\n",
      "         cwd: C:\\Users\\prime\\AppData\\Local\\Temp\\pip-install-5gnqwlt6\\ujson\\\n",
      "    Complete output (6 lines):\n",
      "    Warning: 'classifiers' should be a list, got type 'filter'\n",
      "    running install\n",
      "    running build\n",
      "    running build_ext\n",
      "    building 'ujson' extension\n",
      "    error: Microsoft Visual C++ 14.0 is required. Get it with \"Build Tools for Visual Studio\": https://visualstudio.microsoft.com/downloads/\n",
      "    ----------------------------------------\n",
      "ERROR: Command errored out with exit status 1: 'C:\\Users\\prime\\Anaconda3\\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-5gnqwlt6\\\\ujson\\\\setup.py'\"'\"'; __file__='\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-5gnqwlt6\\\\ujson\\\\setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' install --record 'C:\\Users\\prime\\AppData\\Local\\Temp\\pip-record-mf9ew5e_\\install-record.txt' --single-version-externally-managed --compile Check the logs for full command output.\n"
     ]
    }
   ],
   "source": [
    "pip install python-language-server"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting Turicreate\n",
      "  Downloading turicreate-6.0.tar.gz (1.9 kB)\n",
      "Building wheels for collected packages: Turicreate\n",
      "  Building wheel for Turicreate (setup.py): started\n",
      "  Building wheel for Turicreate (setup.py): finished with status 'error'\n",
      "  Running setup.py clean for Turicreate\n",
      "Failed to build Turicreate\n",
      "Installing collected packages: Turicreate\n",
      "    Running setup.py install for Turicreate: started\n",
      "    Running setup.py install for Turicreate: finished with status 'error'\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "  ERROR: Command errored out with exit status 1:\n",
      "   command: 'C:\\Users\\prime\\Anaconda3\\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-hgxpgyrv\\\\Turicreate\\\\setup.py'\"'\"'; __file__='\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-hgxpgyrv\\\\Turicreate\\\\setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' bdist_wheel -d 'C:\\Users\\prime\\AppData\\Local\\Temp\\pip-wheel-2g5x7rpo'\n",
      "       cwd: C:\\Users\\prime\\AppData\\Local\\Temp\\pip-install-hgxpgyrv\\Turicreate\\\n",
      "  Complete output (31 lines):\n",
      "  running bdist_wheel\n",
      "  running build\n",
      "  installing to build\\bdist.win-amd64\\wheel\n",
      "  running install\n",
      "  \n",
      "  \n",
      "  \n",
      "          ==================================================================================\n",
      "          TURICREATE ERROR\n",
      "  \n",
      "          If you see this message, pip install did not find an available binary package\n",
      "          for your system.\n",
      "  \n",
      "          Supported Platforms:\n",
      "              * macOS 10.12+ x86_64.\n",
      "              * Linux x86_64 (including WSL on Windows 10).\n",
      "  \n",
      "          Support Python Versions:\n",
      "              * 2.7\n",
      "              * 3.5\n",
      "              * 3.6\n",
      "              * 3.7\n",
      "  \n",
      "  \n",
      "          Another possible cause of this error is an outdated pip version. Try:\n",
      "              `pip install -U pip`\n",
      "  \n",
      "          ==================================================================================\n",
      "  \n",
      "  \n",
      "  \n",
      "  ----------------------------------------\n",
      "  ERROR: Failed building wheel for Turicreate\n",
      "    ERROR: Command errored out with exit status 1:\n",
      "     command: 'C:\\Users\\prime\\Anaconda3\\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-hgxpgyrv\\\\Turicreate\\\\setup.py'\"'\"'; __file__='\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-hgxpgyrv\\\\Turicreate\\\\setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' install --record 'C:\\Users\\prime\\AppData\\Local\\Temp\\pip-record-eu8ifvfj\\install-record.txt' --single-version-externally-managed --compile --install-headers 'C:\\Users\\prime\\Anaconda3\\Include\\Turicreate'\n",
      "         cwd: C:\\Users\\prime\\AppData\\Local\\Temp\\pip-install-hgxpgyrv\\Turicreate\\\n",
      "    Complete output (28 lines):\n",
      "    running install\n",
      "    \n",
      "    \n",
      "    \n",
      "            ==================================================================================\n",
      "            TURICREATE ERROR\n",
      "    \n",
      "            If you see this message, pip install did not find an available binary package\n",
      "            for your system.\n",
      "    \n",
      "            Supported Platforms:\n",
      "                * macOS 10.12+ x86_64.\n",
      "                * Linux x86_64 (including WSL on Windows 10).\n",
      "    \n",
      "            Support Python Versions:\n",
      "                * 2.7\n",
      "                * 3.5\n",
      "                * 3.6\n",
      "                * 3.7\n",
      "    \n",
      "    \n",
      "            Another possible cause of this error is an outdated pip version. Try:\n",
      "                `pip install -U pip`\n",
      "    \n",
      "            ==================================================================================\n",
      "    \n",
      "    \n",
      "    \n",
      "    ----------------------------------------\n",
      "ERROR: Command errored out with exit status 1: 'C:\\Users\\prime\\Anaconda3\\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-hgxpgyrv\\\\Turicreate\\\\setup.py'\"'\"'; __file__='\"'\"'C:\\\\Users\\\\prime\\\\AppData\\\\Local\\\\Temp\\\\pip-install-hgxpgyrv\\\\Turicreate\\\\setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' install --record 'C:\\Users\\prime\\AppData\\Local\\Temp\\pip-record-eu8ifvfj\\install-record.txt' --single-version-externally-managed --compile --install-headers 'C:\\Users\\prime\\Anaconda3\\Include\\Turicreate' Check the logs for full command output.\n"
     ]
    }
   ],
   "source": [
    "pip install Turicreate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}