사무기기 item based.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.metrics.pairwise import cosine_similarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "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>상품명</th>\n",
       "      <th>가격</th>\n",
       "      <th>스펙 목록</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>...</th>\n",
       "      <th>Unnamed: 20</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>Unnamed: 23</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "      <th>Unnamed: 27</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Unnamed: 29</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ApeosPort 2560</td>\n",
       "      <td>2125000</td>\n",
       "      <td>흑백 디지털 복합기</td>\n",
       "      <td>잉크젯</td>\n",
       "      <td>포토프린터</td>\n",
       "      <td>컬러 출력</td>\n",
       "      <td>복사</td>\n",
       "      <td>스캔</td>\n",
       "      <td>팩스</td>\n",
       "      <td>인쇄 해상도: 4,800dpi</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>1</th>\n",
       "      <td>ApeosPort 3060</td>\n",
       "      <td>2200000</td>\n",
       "      <td>흑백 디지털 복합기</td>\n",
       "      <td>잉크젯</td>\n",
       "      <td>포토프린터</td>\n",
       "      <td>컬러 출력</td>\n",
       "      <td>복사</td>\n",
       "      <td>스캔</td>\n",
       "      <td>팩스</td>\n",
       "      <td>인쇄 해상도: 4,800dpi</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>2</th>\n",
       "      <td>ApeosPort 3560</td>\n",
       "      <td>2528000</td>\n",
       "      <td>흑백 디지털 복합기</td>\n",
       "      <td>잉크젯</td>\n",
       "      <td>컬러 출력</td>\n",
       "      <td>복사</td>\n",
       "      <td>스캔</td>\n",
       "      <td>인쇄 해상도: 4,800dpi</td>\n",
       "      <td>무한 패키지</td>\n",
       "      <td>연결방식: USB</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>3</th>\n",
       "      <td>ApeosPort C2060</td>\n",
       "      <td>2600000</td>\n",
       "      <td>컬러 디지털 복합기</td>\n",
       "      <td>인쇄</td>\n",
       "      <td>복사</td>\n",
       "      <td>스캔</td>\n",
       "      <td>컬러 속도: 23ppm</td>\n",
       "      <td>흑백 속도: 28ppm</td>\n",
       "      <td>인쇄 해상도: 600 x 600dpi</td>\n",
       "      <td>자동양면인쇄</td>\n",
       "      <td>...</td>\n",
       "      <td>가로: 699mm</td>\n",
       "      <td>세로: 742mm</td>\n",
       "      <td>높이: 759mm</td>\n",
       "      <td>무게: 121kg</td>\n",
       "      <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>4</th>\n",
       "      <td>ApeosPort C2560</td>\n",
       "      <td>2778170</td>\n",
       "      <td>컬러 디지털 복합기</td>\n",
       "      <td>인쇄</td>\n",
       "      <td>복사</td>\n",
       "      <td>스캔</td>\n",
       "      <td>팩스</td>\n",
       "      <td>컬러 속도: 23ppm</td>\n",
       "      <td>흑백 속도: 25ppm</td>\n",
       "      <td>인쇄 해상도: 1200 x 1200dpi</td>\n",
       "      <td>...</td>\n",
       "      <td>무게: 125kg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <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",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               상품명       가격        스펙 목록 Unnamed: 3 Unnamed: 4 Unnamed: 5  \\\n",
       "0   ApeosPort 2560  2125000  흑백 디지털 복합기        잉크젯      포토프린터      컬러 출력    \n",
       "1   ApeosPort 3060  2200000  흑백 디지털 복합기        잉크젯      포토프린터      컬러 출력    \n",
       "2   ApeosPort 3560  2528000  흑백 디지털 복합기        잉크젯      컬러 출력         복사    \n",
       "3  ApeosPort C2060  2600000  컬러 디지털 복합기         인쇄         복사         스캔    \n",
       "4  ApeosPort C2560  2778170  컬러 디지털 복합기         인쇄         복사         스캔    \n",
       "\n",
       "       Unnamed: 6          Unnamed: 7              Unnamed: 8  \\\n",
       "0             복사                  스캔                      팩스    \n",
       "1             복사                  스캔                      팩스    \n",
       "2             스캔    인쇄 해상도: 4,800dpi                  무한 패키지    \n",
       "3   컬러 속도: 23ppm        흑백 속도: 28ppm    인쇄 해상도: 600 x 600dpi    \n",
       "4             팩스        컬러 속도: 23ppm            흑백 속도: 25ppm    \n",
       "\n",
       "                 Unnamed: 9  ...  Unnamed: 20  Unnamed: 21  Unnamed: 22  \\\n",
       "0         인쇄 해상도: 4,800dpi   ...          NaN          NaN          NaN   \n",
       "1         인쇄 해상도: 4,800dpi   ...          NaN          NaN          NaN   \n",
       "2                연결방식: USB   ...          NaN          NaN          NaN   \n",
       "3                   자동양면인쇄   ...   가로: 699mm    세로: 742mm    높이: 759mm    \n",
       "4   인쇄 해상도: 1200 x 1200dpi   ...    무게: 125kg          NaN          NaN   \n",
       "\n",
       "  Unnamed: 23 Unnamed: 24 Unnamed: 25 Unnamed: 26 Unnamed: 27 Unnamed: 28  \\\n",
       "0         NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "1         NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "2         NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "3   무게: 121kg         NaN         NaN         NaN         NaN         NaN   \n",
       "4         NaN         NaN         NaN         NaN         NaN         NaN   \n",
       "\n",
       "  Unnamed: 29  \n",
       "0         NaN  \n",
       "1         NaN  \n",
       "2         NaN  \n",
       "3         NaN  \n",
       "4         NaN  \n",
       "\n",
       "[5 rows x 30 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_excel('./datasets/복합기 크롤링 중복제거.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>지은</th>\n",
       "      <th>시은</th>\n",
       "      <th>준영</th>\n",
       "      <th>도현</th>\n",
       "      <th>비둘기</th>\n",
       "    </tr>\n",
       "    <tr>\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>ApeosPort 2560</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort 3060</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort 3560</th>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort C2060</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort C2560</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 bizhub C451</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 C022DN</th>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 C028DN</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 C036DN</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 MagiColor 4690MF</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5901 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         지은  시은  준영  도현  비둘기\n",
       "상품명                                         \n",
       "ApeosPort 2560            1   3   3   3    1\n",
       "ApeosPort 3060            2   1   2   1    1\n",
       "ApeosPort 3560            4   2   2   3    2\n",
       "ApeosPort C2060           3   2   5   5    2\n",
       "ApeosPort C2560           3   1   1   5    4\n",
       "...                      ..  ..  ..  ..  ...\n",
       "코니카미놀타 bizhub C451        1   3   4   1    4\n",
       "코니카미놀타 C022DN             5   4   4   5    2\n",
       "코니카미놀타 C028DN             5   1   1   3    1\n",
       "코니카미놀타 C036DN             2   3   3   2    4\n",
       "코니카미놀타 MagiColor 4690MF   1   2   1   4    1\n",
       "\n",
       "[5901 rows x 5 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#user 평점 테이블 생성\n",
    "item_user_table = pd.DataFrame(data=np.random.randint(1,6,size=(5901,15)), index=data['상품명'], columns=['대표님','팀장님','지은','시은','준영','도현','비둘기','세무사님','이룬아이티','아리오','후반기인턴1','후반기인턴2','후반기인턴3','정직원1'])\n",
    "item_user_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": false
   },
   "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>ApeosPort 2560</th>\n",
       "      <th>ApeosPort 3060</th>\n",
       "      <th>ApeosPort 3560</th>\n",
       "      <th>ApeosPort C2060</th>\n",
       "      <th>ApeosPort C2560</th>\n",
       "      <th>ApeosPort C3060</th>\n",
       "      <th>Apeosport-II 5010</th>\n",
       "      <th>Apeosport-II 6000</th>\n",
       "      <th>Apeosport-II 7000</th>\n",
       "      <th>Apeosport-II C2200 CP</th>\n",
       "      <th>...</th>\n",
       "      <th>코니카미놀타 Bizhub C025DNi</th>\n",
       "      <th>코니카미놀타 bizhub C200</th>\n",
       "      <th>코니카미놀타 bizhub C220</th>\n",
       "      <th>코니카미놀타 Bizhub C225DN</th>\n",
       "      <th>코니카미놀타 bizhub C360</th>\n",
       "      <th>코니카미놀타 bizhub C451</th>\n",
       "      <th>코니카미놀타 C022DN</th>\n",
       "      <th>코니카미놀타 C028DN</th>\n",
       "      <th>코니카미놀타 C036DN</th>\n",
       "      <th>코니카미놀타 MagiColor 4690MF</th>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ApeosPort 2560</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.839839</td>\n",
       "      <td>0.824259</td>\n",
       "      <td>0.930138</td>\n",
       "      <td>0.721037</td>\n",
       "      <td>0.705887</td>\n",
       "      <td>0.799014</td>\n",
       "      <td>0.727860</td>\n",
       "      <td>0.871978</td>\n",
       "      <td>0.735316</td>\n",
       "      <td>...</td>\n",
       "      <td>0.859481</td>\n",
       "      <td>0.760078</td>\n",
       "      <td>0.871978</td>\n",
       "      <td>0.852209</td>\n",
       "      <td>0.789205</td>\n",
       "      <td>0.821230</td>\n",
       "      <td>0.921106</td>\n",
       "      <td>0.641091</td>\n",
       "      <td>0.859602</td>\n",
       "      <td>0.890564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort 3060</th>\n",
       "      <td>0.839839</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.941795</td>\n",
       "      <td>0.920887</td>\n",
       "      <td>0.752618</td>\n",
       "      <td>0.842750</td>\n",
       "      <td>0.936975</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>0.809040</td>\n",
       "      <td>0.767523</td>\n",
       "      <td>...</td>\n",
       "      <td>0.966136</td>\n",
       "      <td>0.897549</td>\n",
       "      <td>0.943880</td>\n",
       "      <td>0.972345</td>\n",
       "      <td>0.979912</td>\n",
       "      <td>0.827641</td>\n",
       "      <td>0.942871</td>\n",
       "      <td>0.842659</td>\n",
       "      <td>0.883960</td>\n",
       "      <td>0.691564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort 3560</th>\n",
       "      <td>0.824259</td>\n",
       "      <td>0.941795</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.903804</td>\n",
       "      <td>0.889123</td>\n",
       "      <td>0.863877</td>\n",
       "      <td>0.903874</td>\n",
       "      <td>0.941795</td>\n",
       "      <td>0.790356</td>\n",
       "      <td>0.767234</td>\n",
       "      <td>...</td>\n",
       "      <td>0.936507</td>\n",
       "      <td>0.978777</td>\n",
       "      <td>0.937399</td>\n",
       "      <td>0.937994</td>\n",
       "      <td>0.883645</td>\n",
       "      <td>0.727048</td>\n",
       "      <td>0.975018</td>\n",
       "      <td>0.945946</td>\n",
       "      <td>0.862489</td>\n",
       "      <td>0.822709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort C2060</th>\n",
       "      <td>0.930138</td>\n",
       "      <td>0.920887</td>\n",
       "      <td>0.903804</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.830151</td>\n",
       "      <td>0.682948</td>\n",
       "      <td>0.846918</td>\n",
       "      <td>0.810380</td>\n",
       "      <td>0.915150</td>\n",
       "      <td>0.673817</td>\n",
       "      <td>...</td>\n",
       "      <td>0.956924</td>\n",
       "      <td>0.863736</td>\n",
       "      <td>0.969786</td>\n",
       "      <td>0.863736</td>\n",
       "      <td>0.839915</td>\n",
       "      <td>0.782488</td>\n",
       "      <td>0.948519</td>\n",
       "      <td>0.783297</td>\n",
       "      <td>0.848302</td>\n",
       "      <td>0.866119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ApeosPort C2560</th>\n",
       "      <td>0.721037</td>\n",
       "      <td>0.752618</td>\n",
       "      <td>0.889123</td>\n",
       "      <td>0.830151</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.728704</td>\n",
       "      <td>0.812167</td>\n",
       "      <td>0.878054</td>\n",
       "      <td>0.852739</td>\n",
       "      <td>0.725630</td>\n",
       "      <td>...</td>\n",
       "      <td>0.757054</td>\n",
       "      <td>0.946029</td>\n",
       "      <td>0.790721</td>\n",
       "      <td>0.705221</td>\n",
       "      <td>0.624038</td>\n",
       "      <td>0.655580</td>\n",
       "      <td>0.837408</td>\n",
       "      <td>0.820729</td>\n",
       "      <td>0.813125</td>\n",
       "      <td>0.867472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 bizhub C451</th>\n",
       "      <td>0.821230</td>\n",
       "      <td>0.827641</td>\n",
       "      <td>0.727048</td>\n",
       "      <td>0.782488</td>\n",
       "      <td>0.655580</td>\n",
       "      <td>0.835443</td>\n",
       "      <td>0.929580</td>\n",
       "      <td>0.827641</td>\n",
       "      <td>0.886593</td>\n",
       "      <td>0.927362</td>\n",
       "      <td>...</td>\n",
       "      <td>0.705832</td>\n",
       "      <td>0.737690</td>\n",
       "      <td>0.681994</td>\n",
       "      <td>0.813350</td>\n",
       "      <td>0.819680</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.756440</td>\n",
       "      <td>0.476342</td>\n",
       "      <td>0.964773</td>\n",
       "      <td>0.604165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 C022DN</th>\n",
       "      <td>0.921106</td>\n",
       "      <td>0.942871</td>\n",
       "      <td>0.975018</td>\n",
       "      <td>0.948519</td>\n",
       "      <td>0.837408</td>\n",
       "      <td>0.819813</td>\n",
       "      <td>0.876417</td>\n",
       "      <td>0.877846</td>\n",
       "      <td>0.819813</td>\n",
       "      <td>0.747243</td>\n",
       "      <td>...</td>\n",
       "      <td>0.959805</td>\n",
       "      <td>0.922876</td>\n",
       "      <td>0.964486</td>\n",
       "      <td>0.949626</td>\n",
       "      <td>0.889620</td>\n",
       "      <td>0.756440</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.886380</td>\n",
       "      <td>0.865226</td>\n",
       "      <td>0.876903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 C028DN</th>\n",
       "      <td>0.641091</td>\n",
       "      <td>0.842659</td>\n",
       "      <td>0.945946</td>\n",
       "      <td>0.783297</td>\n",
       "      <td>0.820729</td>\n",
       "      <td>0.735215</td>\n",
       "      <td>0.746679</td>\n",
       "      <td>0.842659</td>\n",
       "      <td>0.588172</td>\n",
       "      <td>0.557989</td>\n",
       "      <td>...</td>\n",
       "      <td>0.877976</td>\n",
       "      <td>0.917603</td>\n",
       "      <td>0.882258</td>\n",
       "      <td>0.836039</td>\n",
       "      <td>0.780895</td>\n",
       "      <td>0.476342</td>\n",
       "      <td>0.886380</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.659550</td>\n",
       "      <td>0.719871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 C036DN</th>\n",
       "      <td>0.859602</td>\n",
       "      <td>0.883960</td>\n",
       "      <td>0.862489</td>\n",
       "      <td>0.848302</td>\n",
       "      <td>0.813125</td>\n",
       "      <td>0.914337</td>\n",
       "      <td>0.977467</td>\n",
       "      <td>0.930484</td>\n",
       "      <td>0.914337</td>\n",
       "      <td>0.960159</td>\n",
       "      <td>...</td>\n",
       "      <td>0.787435</td>\n",
       "      <td>0.880393</td>\n",
       "      <td>0.776324</td>\n",
       "      <td>0.880393</td>\n",
       "      <td>0.848668</td>\n",
       "      <td>0.964773</td>\n",
       "      <td>0.865226</td>\n",
       "      <td>0.659550</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.740013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>코니카미놀타 MagiColor 4690MF</th>\n",
       "      <td>0.890564</td>\n",
       "      <td>0.691564</td>\n",
       "      <td>0.822709</td>\n",
       "      <td>0.866119</td>\n",
       "      <td>0.867472</td>\n",
       "      <td>0.606128</td>\n",
       "      <td>0.672900</td>\n",
       "      <td>0.691564</td>\n",
       "      <td>0.815942</td>\n",
       "      <td>0.619256</td>\n",
       "      <td>...</td>\n",
       "      <td>0.767129</td>\n",
       "      <td>0.801754</td>\n",
       "      <td>0.815942</td>\n",
       "      <td>0.698302</td>\n",
       "      <td>0.573415</td>\n",
       "      <td>0.604165</td>\n",
       "      <td>0.876903</td>\n",
       "      <td>0.719871</td>\n",
       "      <td>0.740013</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5901 rows × 5901 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "상품명                      ApeosPort 2560  ApeosPort 3060  ApeosPort 3560  \\\n",
       "상품명                                                                       \n",
       "ApeosPort 2560                 1.000000        0.839839        0.824259   \n",
       "ApeosPort 3060                 0.839839        1.000000        0.941795   \n",
       "ApeosPort 3560                 0.824259        0.941795        1.000000   \n",
       "ApeosPort C2060                0.930138        0.920887        0.903804   \n",
       "ApeosPort C2560                0.721037        0.752618        0.889123   \n",
       "...                                 ...             ...             ...   \n",
       "코니카미놀타 bizhub C451             0.821230        0.827641        0.727048   \n",
       "코니카미놀타 C022DN                  0.921106        0.942871        0.975018   \n",
       "코니카미놀타 C028DN                  0.641091        0.842659        0.945946   \n",
       "코니카미놀타 C036DN                  0.859602        0.883960        0.862489   \n",
       "코니카미놀타 MagiColor 4690MF        0.890564        0.691564        0.822709   \n",
       "\n",
       "상품명                      ApeosPort C2060  ApeosPort C2560  ApeosPort C3060  \\\n",
       "상품명                                                                          \n",
       "ApeosPort 2560                  0.930138         0.721037         0.705887   \n",
       "ApeosPort 3060                  0.920887         0.752618         0.842750   \n",
       "ApeosPort 3560                  0.903804         0.889123         0.863877   \n",
       "ApeosPort C2060                 1.000000         0.830151         0.682948   \n",
       "ApeosPort C2560                 0.830151         1.000000         0.728704   \n",
       "...                                  ...              ...              ...   \n",
       "코니카미놀타 bizhub C451              0.782488         0.655580         0.835443   \n",
       "코니카미놀타 C022DN                   0.948519         0.837408         0.819813   \n",
       "코니카미놀타 C028DN                   0.783297         0.820729         0.735215   \n",
       "코니카미놀타 C036DN                   0.848302         0.813125         0.914337   \n",
       "코니카미놀타 MagiColor 4690MF         0.866119         0.867472         0.606128   \n",
       "\n",
       "상품명                      Apeosport-II 5010  Apeosport-II 6000  \\\n",
       "상품명                                                             \n",
       "ApeosPort 2560                    0.799014           0.727860   \n",
       "ApeosPort 3060                    0.936975           0.909091   \n",
       "ApeosPort 3560                    0.903874           0.941795   \n",
       "ApeosPort C2060                   0.846918           0.810380   \n",
       "ApeosPort C2560                   0.812167           0.878054   \n",
       "...                                    ...                ...   \n",
       "코니카미놀타 bizhub C451                0.929580           0.827641   \n",
       "코니카미놀타 C022DN                     0.876417           0.877846   \n",
       "코니카미놀타 C028DN                     0.746679           0.842659   \n",
       "코니카미놀타 C036DN                     0.977467           0.930484   \n",
       "코니카미놀타 MagiColor 4690MF           0.672900           0.691564   \n",
       "\n",
       "상품명                      Apeosport-II 7000  Apeosport-II C2200 CP  ...  \\\n",
       "상품명                                                                ...   \n",
       "ApeosPort 2560                    0.871978               0.735316  ...   \n",
       "ApeosPort 3060                    0.809040               0.767523  ...   \n",
       "ApeosPort 3560                    0.790356               0.767234  ...   \n",
       "ApeosPort C2060                   0.915150               0.673817  ...   \n",
       "ApeosPort C2560                   0.852739               0.725630  ...   \n",
       "...                                    ...                    ...  ...   \n",
       "코니카미놀타 bizhub C451                0.886593               0.927362  ...   \n",
       "코니카미놀타 C022DN                     0.819813               0.747243  ...   \n",
       "코니카미놀타 C028DN                     0.588172               0.557989  ...   \n",
       "코니카미놀타 C036DN                     0.914337               0.960159  ...   \n",
       "코니카미놀타 MagiColor 4690MF           0.815942               0.619256  ...   \n",
       "\n",
       "상품명                      코니카미놀타 Bizhub C025DNi  코니카미놀타 bizhub C200  \\\n",
       "상품명                                                                  \n",
       "ApeosPort 2560                        0.859481            0.760078   \n",
       "ApeosPort 3060                        0.966136            0.897549   \n",
       "ApeosPort 3560                        0.936507            0.978777   \n",
       "ApeosPort C2060                       0.956924            0.863736   \n",
       "ApeosPort C2560                       0.757054            0.946029   \n",
       "...                                        ...                 ...   \n",
       "코니카미놀타 bizhub C451                    0.705832            0.737690   \n",
       "코니카미놀타 C022DN                         0.959805            0.922876   \n",
       "코니카미놀타 C028DN                         0.877976            0.917603   \n",
       "코니카미놀타 C036DN                         0.787435            0.880393   \n",
       "코니카미놀타 MagiColor 4690MF               0.767129            0.801754   \n",
       "\n",
       "상품명                      코니카미놀타 bizhub C220  코니카미놀타 Bizhub C225DN  \\\n",
       "상품명                                                                 \n",
       "ApeosPort 2560                     0.871978              0.852209   \n",
       "ApeosPort 3060                     0.943880              0.972345   \n",
       "ApeosPort 3560                     0.937399              0.937994   \n",
       "ApeosPort C2060                    0.969786              0.863736   \n",
       "ApeosPort C2560                    0.790721              0.705221   \n",
       "...                                     ...                   ...   \n",
       "코니카미놀타 bizhub C451                 0.681994              0.813350   \n",
       "코니카미놀타 C022DN                      0.964486              0.949626   \n",
       "코니카미놀타 C028DN                      0.882258              0.836039   \n",
       "코니카미놀타 C036DN                      0.776324              0.880393   \n",
       "코니카미놀타 MagiColor 4690MF            0.815942              0.698302   \n",
       "\n",
       "상품명                      코니카미놀타 bizhub C360  코니카미놀타 bizhub C451  \\\n",
       "상품명                                                               \n",
       "ApeosPort 2560                     0.789205            0.821230   \n",
       "ApeosPort 3060                     0.979912            0.827641   \n",
       "ApeosPort 3560                     0.883645            0.727048   \n",
       "ApeosPort C2060                    0.839915            0.782488   \n",
       "ApeosPort C2560                    0.624038            0.655580   \n",
       "...                                     ...                 ...   \n",
       "코니카미놀타 bizhub C451                 0.819680            1.000000   \n",
       "코니카미놀타 C022DN                      0.889620            0.756440   \n",
       "코니카미놀타 C028DN                      0.780895            0.476342   \n",
       "코니카미놀타 C036DN                      0.848668            0.964773   \n",
       "코니카미놀타 MagiColor 4690MF            0.573415            0.604165   \n",
       "\n",
       "상품명                      코니카미놀타 C022DN  코니카미놀타 C028DN  코니카미놀타 C036DN  \\\n",
       "상품명                                                                    \n",
       "ApeosPort 2560                0.921106       0.641091       0.859602   \n",
       "ApeosPort 3060                0.942871       0.842659       0.883960   \n",
       "ApeosPort 3560                0.975018       0.945946       0.862489   \n",
       "ApeosPort C2060               0.948519       0.783297       0.848302   \n",
       "ApeosPort C2560               0.837408       0.820729       0.813125   \n",
       "...                                ...            ...            ...   \n",
       "코니카미놀타 bizhub C451            0.756440       0.476342       0.964773   \n",
       "코니카미놀타 C022DN                 1.000000       0.886380       0.865226   \n",
       "코니카미놀타 C028DN                 0.886380       1.000000       0.659550   \n",
       "코니카미놀타 C036DN                 0.865226       0.659550       1.000000   \n",
       "코니카미놀타 MagiColor 4690MF       0.876903       0.719871       0.740013   \n",
       "\n",
       "상품명                      코니카미놀타 MagiColor 4690MF  \n",
       "상품명                                               \n",
       "ApeosPort 2560                          0.890564  \n",
       "ApeosPort 3060                          0.691564  \n",
       "ApeosPort 3560                          0.822709  \n",
       "ApeosPort C2060                         0.866119  \n",
       "ApeosPort C2560                         0.867472  \n",
       "...                                          ...  \n",
       "코니카미놀타 bizhub C451                      0.604165  \n",
       "코니카미놀타 C022DN                           0.876903  \n",
       "코니카미놀타 C028DN                           0.719871  \n",
       "코니카미놀타 C036DN                           0.740013  \n",
       "코니카미놀타 MagiColor 4690MF                 1.000000  \n",
       "\n",
       "[5901 rows x 5901 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#코사인 유사도로 유사도측정\n",
    "printer_sim = cosine_similarity(item_user_table,item_user_table)\n",
    "printer_sim_df = pd.DataFrame(data=printer_sim,index=item_user_table.index,columns=item_user_table.index)\n",
    "printer_sim_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#사용자가 좋다고 평점매긴 것을 기준으로 상품추천.\n",
    "def recommend_product(printer_sim_df, user_id, ori_ratings_df, num_recommendations=5):\n",
    "    \n",
    "    #item_user_table 평점 순서로 정렬\n",
    "    sorted_ori_df = ori_ratings_df.sort_values(by=[user_id], ascending=False)\n",
    "    product = sorted_ori_df.index[0]\n",
    "    \n",
    "    #가장높은 평점을 기준으로 10개 추천\n",
    "    recommend = printer_sim_df[product].sort_values(ascending=False)[:10]\n",
    "    \n",
    "    return product, recommend"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "product, recommend = recommend_product(printer_sim_df, '비둘기', item_user_table, 10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "상품명\n",
       "Lexmark X363dn               1.000000\n",
       "신도리코 N500                    1.000000\n",
       "삼성전자 SCX-8123NA              1.000000\n",
       "Lexmark X203n                0.999481\n",
       "Canon PIXMA MX727            0.996082\n",
       "Canon PIXMA MX357            0.996082\n",
       "Canon PIXMA MX357            0.996082\n",
       "Epson 완성형 가정용 정품 무한 L3156    0.996082\n",
       "Canon PIXMA iP2702 병행수입      0.996082\n",
       "Canon MF643Cdw               0.995910\n",
       "Name: 삼성전자 SCX-8123NA, dtype: float64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#추천된 상품\n",
    "recommend"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'삼성전자 SCX-8123NA'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#user가 가장 높은 평점을 매긴 상품\n",
    "product"
   ]
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}