2021-06-25 5_그래프 그리기.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "ec73131a",
   "metadata": {},
   "source": [
    "### 환경 설정"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "f808ad02",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import matplotlib as mpl\n",
    "import seaborn as sns\n",
    "import sqlite3\n",
    "import datetime as dt\n",
    "plt.rcParams['font.family'] = 'Malgun Gothic' # 한글 글꼴 설정"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c0362db8",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "43b89b10",
   "metadata": {},
   "source": [
    "### SQLite에서 데이터 받기"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "32e0c720",
   "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>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>album_name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14776</td>\n",
       "      <td>All I Want For Christmas Is You</td>\n",
       "      <td>Mariah Carey</td>\n",
       "      <td>Merry Christmas (Deluxe Anniversary Edition)</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1489805</td>\n",
       "      <td>Must Have Love</td>\n",
       "      <td>SG 워너비, 브라운아이드걸스</td>\n",
       "      <td>SG워너비 &amp; 브라운아이드걸스 싱글</td>\n",
       "      <td>2006-11-16</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1500196</td>\n",
       "      <td>내사람</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Precious History</td>\n",
       "      <td>2006-11-15</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1615770</td>\n",
       "      <td>아리랑</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Sentimental Chord</td>\n",
       "      <td>2007-04-06</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1854856</td>\n",
       "      <td>라라라</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>My Friend</td>\n",
       "      <td>2008-04-24</td>\n",
       "      <td>발라드</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>8130796</td>\n",
       "      <td>상상더하기</td>\n",
       "      <td>라붐 (LABOUM)</td>\n",
       "      <td>Fresh Adventure</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>댄스</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>8235260</td>\n",
       "      <td>비</td>\n",
       "      <td>폴킴</td>\n",
       "      <td>비</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8252573</td>\n",
       "      <td>아주 NICE</td>\n",
       "      <td>세븐틴</td>\n",
       "      <td>Love&amp;Letter Repackage Album</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>댄스</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>8298724</td>\n",
       "      <td>뜨거운 여름밤은 가고 남은 건 볼품없지만</td>\n",
       "      <td>잔나비</td>\n",
       "      <td>MONKEY HOTEL</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>인디음악, 록/메탈</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>9642570</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>닐로(Nilo)</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>발라드</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1045 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      song_id                        song_name       artist_name  \\\n",
       "0       14776  All I Want For Christmas Is You      Mariah Carey   \n",
       "1     1489805                   Must Have Love  SG 워너비, 브라운아이드걸스   \n",
       "2     1500196                              내사람            SG 워너비   \n",
       "3     1615770                              아리랑            SG 워너비   \n",
       "4     1854856                              라라라            SG 워너비   \n",
       "...       ...                              ...               ...   \n",
       "1040  8130796                            상상더하기       라붐 (LABOUM)   \n",
       "1041  8235260                                비                폴킴   \n",
       "1042  8252573                          아주 NICE               세븐틴   \n",
       "1043  8298724           뜨거운 여름밤은 가고 남은 건 볼품없지만               잔나비   \n",
       "1044  9642570                              넋두리          닐로(Nilo)   \n",
       "\n",
       "                                        album_name release_date       genre  \n",
       "0     Merry Christmas (Deluxe Anniversary Edition)   2019-11-01    R&B/Soul  \n",
       "1                              SG워너비 & 브라운아이드걸스 싱글   2006-11-16    R&B/Soul  \n",
       "2                             The Precious History   2006-11-15    R&B/Soul  \n",
       "3                            The Sentimental Chord   2007-04-06    R&B/Soul  \n",
       "4                                        My Friend   2008-04-24         발라드  \n",
       "...                                            ...          ...         ...  \n",
       "1040                               Fresh Adventure   2016-04-06          댄스  \n",
       "1041                                             비   2016-06-21    R&B/Soul  \n",
       "1042                   Love&Letter Repackage Album   2016-07-04          댄스  \n",
       "1043                                  MONKEY HOTEL   2016-08-04  인디음악, 록/메탈  \n",
       "1044                                           넋두리   2016-09-12         발라드  \n",
       "\n",
       "[1045 rows x 6 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con = sqlite3.connect(\"db/new_song.db\")\n",
    "\n",
    "df_song_info = pd.read_sql(\"SELECT * FROM df_song_info_NOST\", con)\n",
    "\n",
    "con.close()\n",
    "\n",
    "df_song_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "af6e88b1",
   "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>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>album_name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "      <th>day_of_week</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14776</td>\n",
       "      <td>All I Want For Christmas Is You</td>\n",
       "      <td>Mariah Carey</td>\n",
       "      <td>Merry Christmas (Deluxe Anniversary Edition)</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1489805</td>\n",
       "      <td>Must Have Love</td>\n",
       "      <td>SG 워너비, 브라운아이드걸스</td>\n",
       "      <td>SG워너비 &amp; 브라운아이드걸스 싱글</td>\n",
       "      <td>2006-11-16</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1500196</td>\n",
       "      <td>내사람</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Precious History</td>\n",
       "      <td>2006-11-15</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1615770</td>\n",
       "      <td>아리랑</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Sentimental Chord</td>\n",
       "      <td>2007-04-06</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1854856</td>\n",
       "      <td>라라라</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>My Friend</td>\n",
       "      <td>2008-04-24</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Thursday</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>8130796</td>\n",
       "      <td>상상더하기</td>\n",
       "      <td>라붐 (LABOUM)</td>\n",
       "      <td>Fresh Adventure</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>8235260</td>\n",
       "      <td>비</td>\n",
       "      <td>폴킴</td>\n",
       "      <td>비</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8252573</td>\n",
       "      <td>아주 NICE</td>\n",
       "      <td>세븐틴</td>\n",
       "      <td>Love&amp;Letter Repackage Album</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>8298724</td>\n",
       "      <td>뜨거운 여름밤은 가고 남은 건 볼품없지만</td>\n",
       "      <td>잔나비</td>\n",
       "      <td>MONKEY HOTEL</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>인디음악, 록/메탈</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>9642570</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>닐로(Nilo)</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1045 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      song_id                        song_name       artist_name  \\\n",
       "0       14776  All I Want For Christmas Is You      Mariah Carey   \n",
       "1     1489805                   Must Have Love  SG 워너비, 브라운아이드걸스   \n",
       "2     1500196                              내사람            SG 워너비   \n",
       "3     1615770                              아리랑            SG 워너비   \n",
       "4     1854856                              라라라            SG 워너비   \n",
       "...       ...                              ...               ...   \n",
       "1040  8130796                            상상더하기       라붐 (LABOUM)   \n",
       "1041  8235260                                비                폴킴   \n",
       "1042  8252573                          아주 NICE               세븐틴   \n",
       "1043  8298724           뜨거운 여름밤은 가고 남은 건 볼품없지만               잔나비   \n",
       "1044  9642570                              넋두리          닐로(Nilo)   \n",
       "\n",
       "                                        album_name release_date       genre  \\\n",
       "0     Merry Christmas (Deluxe Anniversary Edition)   2019-11-01    R&B/Soul   \n",
       "1                              SG워너비 & 브라운아이드걸스 싱글   2006-11-16    R&B/Soul   \n",
       "2                             The Precious History   2006-11-15    R&B/Soul   \n",
       "3                            The Sentimental Chord   2007-04-06    R&B/Soul   \n",
       "4                                        My Friend   2008-04-24         발라드   \n",
       "...                                            ...          ...         ...   \n",
       "1040                               Fresh Adventure   2016-04-06          댄스   \n",
       "1041                                             비   2016-06-21    R&B/Soul   \n",
       "1042                   Love&Letter Repackage Album   2016-07-04          댄스   \n",
       "1043                                  MONKEY HOTEL   2016-08-04  인디음악, 록/메탈   \n",
       "1044                                           넋두리   2016-09-12         발라드   \n",
       "\n",
       "     day_of_week  \n",
       "0         Friday  \n",
       "1       Thursday  \n",
       "2      Wednesday  \n",
       "3         Friday  \n",
       "4       Thursday  \n",
       "...          ...  \n",
       "1040   Wednesday  \n",
       "1041     Tuesday  \n",
       "1042      Monday  \n",
       "1043    Thursday  \n",
       "1044      Monday  \n",
       "\n",
       "[1045 rows x 7 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def insert_day(data):\n",
    "    yoil=pd.Timestamp(data)\n",
    "    return yoil.day_name()\n",
    "\n",
    "day_of_week_list = []\n",
    "for i in range(len(df_song_info.loc[:])):\n",
    "    day_of_week = insert_day(df_song_info.loc[i][4])\n",
    "    day_of_week_list.append(day_of_week)\n",
    "\n",
    "\n",
    "df_song_info['day_of_week'] = day_of_week_list\n",
    "\n",
    "df_song_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bca2e6f6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "eb5531f4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "144e1549",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "a3518962",
   "metadata": {},
   "source": [
    "### 요일별 발매 수 그래프"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "018f0304",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYEAAAETCAYAAADQ97psAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAaGUlEQVR4nO3de5RdZX3G8e8DIYFYNQkkSENiFARKEFEHkEsk3hADtNZGsVYpVE1MvSwWQr3gBUXUJmIRCpRIXRRqE4TIRUGBRAIxCZSJUogBKmKEkFaGECJCiob8+sd+D9k5OTNzZpJ9zsy8z2etWbPv+7fPnNnPvpz9HkUEZmaWp53aXYCZmbWPQ8DMLGMOATOzjDkEzMwy5hAwM8uYQ8CyJulASSP6MH2HpLHbsb5393H6UZIO6O/6zHrjELAhT9KJkpZLujv9nlYaPRfYq276h+r6L5c0NfV+DJjcw7reL+nsHpb3tSZrviyt8xDg083MU5r3f/oyveVtWLsLMOsrSbsAnwDew5YDmc3AVcAFEbGpNO0rgS8Bb42IJyXtDtwqaVVErO7Das+X9BRwAHD5dm/ElvreD8wG1qZB+wEHb8fyjgFeJumwiPjPHVCiDXEOARuMvg7sARwXEesBJI0G/hn4ClsfOb8W+ElEPAkQEesk3Qa8DljdzfL3ltRZ6p8EnAL8FLi4ifpmSDqhm3EvlnQKsKq0k54bEWen7VjYxPIbknQkcCFwAvAvkj4aEcv7uzzLg0PABqOjgL+rBQBARKyX9I/ARXXT/gw4S9KY0pnAmyl2lt1ZExEdtR5Jl1NcBpoOHEZxCaknL+zU0/zly0EB/B/wx16W0RRJLwHemX52BY6PiEcl3QN8S9Jw4MfAf0TEUztinTa0OARsMLoR+JSk00pnAmOATwE3lSeMiF9L+iJwk6SdgU3AWb1cCpqQdqI1E4F3RcTiFAg92Qi8r+5MoKvU/fuImN/LMmre1sQ0zwETgK9GxAtnLxHxGDBd0j7A0cDTTa7TMuMQsMHoK8CVwN2SamcDY4DlFJeKthIRPwB+0M2yLgHWlwdERE+fFrqNLdfvtxERC4AFPcx/QQ/j6r20twki4jng3B7G/wr4VR/WaZlxCNigExEhaQ3wudpRtaT3AodENy0iSrqW4oi53k4UO/YNddNfCry+mxJW9lSfpHHUnZGUbKT5ILgm/T6lh3U1qvPVwH11w+6KiI82uV7LiEPAshARf9loeLoRO7zB9DO7mf4y4MW9rOtxoKPRuPqPnyYnSzo6db+2p2U3U6ek1eV7GmY9cQjYoCGpA7gs9e4FbJRU+yTQKGA3Scel/lMi4p7SvL+gOAqvtwvwhwbruoziM/r1JlBciuqpzpcBdwBPNhjdVdc/H7iubtgzPS3fbEdyCNigkW58HtLP2UdERLcPeTWwLzC9j88S1AwD1kbE1N4mTM80/L5+uKR+rNas7xwClo26T/yUzYmI7zYYfpOkbc4SgO9GxJxeVtfRw/r+Kt2wNWs7+ZvFzAYuScOA4RHxbB/mOTYibqmwLBtCHAJmZhlzA3JmZhkbdPcE9thjj5g0aVK7yzAzG1RWrFjxRERs0wz6oAuBSZMm0dnZ2fuEZmb2Akm/aTTcl4PMzDLmEDAzy5hDwMwsYw4BM7OMOQTMzDLmEDAzy5hDwMwsYw4BM7OMOQTMzDKWVQiMnzARSS37GT9hYrs32cysR4Ou2YjtsXbNo5x06bKWre+qmUe2bF1mZv2R1ZmAmZltzSFgZpYxh4CZWcYcAmZmGaskBCSNkjRf0mJJd0h6haQPSFqVht1SmvYcSbdLWippchX1mJlZY1V9OmgkcHpErJV0PHAG8ADwmYi4vjaRpCnAnhFxjKSDgDnAtIpqMjOzOpWcCUTE2ohYm3rXA88Ao1J32bHAvDTPSmBMo+VJmiGpU1JnV1dXFSWbmWWp0nsCksZTnAWcT3HWMVvSEkkz0iTjgPJefZOkbWqKiLkR0RERHWPHbvMVmWZm1k+VPSwm6QTgRODDEbEO+CLwRUkjgeslLQU2AKNLs22OiM1V1WRmZlur6sbwwcCJETEzBQCSaoGzEXgaCGAJMD2NPxBYU0U9ZmbWWFVnAscBUyQtTv2PAL+VdFha57URsUrSA8A0SUsogmFmRfWYmVkDlYRARMwGZjcx3WZgVhU1mJlZ7/ywmJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWWskhCQNErSfEmLJd0h6RWS9pe0SNJSSXNK054j6fY0fHIV9ZiZWWPDKlruSOD0iFgr6XjgDOCVwAcjYrWkqyUdDgwH9oyIYyQdBMwBplVUk5mZ1akkBCJibal3PfAcsGtErE7DFgBHALsD89I8KyWNqaIeMzNrrNJ7ApLGU5wFnAesK41aB4wGxgFdpeGbJG1Tk6QZkjoldXZ1ddWPNjOzfqosBCSdAHwB+DDwJDCqNHo0xc5/Q+qu2RwRm+uXFRFzI6IjIjrGjh1bVclmg9r4CROR1LKf8RMmtnuTbQeo5HKQpIOBEyNiZmnYCEnjI+Ix4F3Al4B9genAEkkHAmuqqMcsB2vXPMpJly5r2fqumnlky9Zl1anqxvBxwBRJi1P/I8DpwDWSngNuiIj7JT0ITJO0BHgamNlwaWZmVomqbgzPBmY3GHVE3XSbgVlV1GBmZr3zw2JmZhlzCJiZZcwhYGaWMYeAmVnGHAJmZhlzCJiZZcwhYGaWMYeAmVnGHAJmZhlzCJiZZcwhYGaWMYeAmVnGHAJmZhlzCJiZZcwhYGaWMYeAmVnGHAJmZhlzCJiZZcwhYGaWMYeAmVnGHAJmZhlzCJiZZcwhYGaWMYeAmVnGHAJmZhlzCJiZZcwhYGaWMYeAmVnGHAJmZhlzCJiZZcwhYGaWMYeAmVnGKgkBSWMlnSvpnNT/AUmrJC2WdEtpunMk3S5pqaTJVdRiZmbdG1bRcs8DHgJGpv5RwGci4vraBJKmAHtGxDGSDgLmANMqqsfMzBpo6kxA0tS6/qN7mj4iTgbuKA0aBayvm+xYYF6afiUwpplazMxsx+kxBFQYAZwtaRdJwyW9BLiwj+sZBsyWtETSjDRsHNBVmmaTpIb1SJohqVNSZ1dXV6NJzMysH3o7EzgS+DHwGuDm9LMAuLwvK4mIL0bEG4C3A+9O1/83AKNLk22OiM3dzD83IjoiomPs2LF9WbVZn42fMBFJLfsZP2FiuzfZMtbjPYGIWAq8SdJnI+Kr/V2JpGERsQnYCDwNBLAEmA4skXQgsKa/yzfbkdaueZSTLl3WsvVdNfPIlq3LrF6zN4bnSDqe4rq9ACLiij6s52uSDkvruzYiVkl6AJgmaQlFMMzsw/LMzGwHaDYEbgRWAQ9QHMX3KiIWA4tT95kNxm8GZjW5fjMzq0CzIbBrRJxWZSFmZtZ6zT4stljSfpVWYmZmLdfsmcDbgPdJqn0+MyLCd7PMzAa5pkIgIo6ouhAzM2u9pkJA0sn1w/r46SDbDuMnTGTtmkdbtr4/3XsCjz36SMvWZ2bt0+zloN1K3fsC4wGHQIv4c+tmVpVmLwddWu6XdFY15ZiZWSv1uSnp1JbQqyuoxczMWqzZewLLKR4SE7AJ+EaVRZmZWWv400FmZhlr9vsEJkm6On0D2BWSxlVdmJmZVa/ZewKXAv8YEUcB3wIurq4kMzNrlWZDYHhEdAJExAqKbwozM7NBrtkQCEljANLvEdWVZGZmrdLsw2JnATdLegyYAJxWWUVmZtYyvX3H8GWSdomI5RFxKPAh4I3A8S2pzgY1f02j2cDX25nAqyLij7WeiHgCQFJHpVXZkODmLswGvt7uCQzvZnizl5HMzGwA6y0EHpQ0pTxA0mRgQ3UlmZlZq/R2RH8GcJ2khcA9FC2I/jXw3orrMjOzFujxTCDdA5gK3AccAKwFpkbEL6svzczMqtbrtf2I2AQsaEEtZmbWYn1uStrMzIYOh4CZWcYcAmZmGXMImJllzCFgZpYxh4CZWcYcAmZmGXMImJllzCFgZpYxh4CZWcYqCQFJYyWdK+mc1L+/pEWSlkqaU5ruHEm3p+GTq6jFzAY2f/lQe1X1vQDnAQ8BI1P/+cAHI2K1pKslHU7xXQV7RsQxkg4C5gDTKqrHzAYof/lQe1VyJhARJwN3AEgaBuwaEavT6AXAEcCxwLw0/UpgTHfLkzRDUqekzq6uripKNjPLUivuCYwF1pX61wGjgXFAeY++SVLDeiJibkR0RETH2LFjq6vUzCwzrfiayKeAUaX+0RQ7/91Sd83miNjcgnrMzCyp/EwgIjYCIySNT4PeBSwClgDTASQdCKypuhYzM9taq74w/nTgGknPATdExP2SHgSmSVoCPA3MbFEtZmaWVBYCEbEYWJy676a4GVwevxmYVdX6zcysd35YzMwsYw4BM7OMOQTMzDLmEDAzy5hDwMwsYw4BM7OMOQTMzDLmEDAzy5hDwMwsYw4BM7OMOQTMzDLmEDAzy5hDwMwsYw4BM7OMOQTMzDLmEDAzy5hDwMwsYw4BM7N+Gj9hIpJa8jN+wsRKtqFV3zFsZjbkrF3zKCdduqwl67pq5pGVLNdnAmZmGXMImJllzCFgZpYxh4CZWcYcAmZmGXMImJllzCFgZpYxh4CZWcYcAmZmGXMImJllzCFgZpYxh4CZWcZa2oCcpPuAdal3LrACuBjYFVgWEWe2sh4zs9y1uhXR30bEW2s9kn4EfDAiVku6WtLhEXFXi2syM8tWqy8Hba51SBoG7BoRq9OgBcARLa7HzCxrLQsBSS8C9pF0h6TvAXux5dIQqXt0N/POkNQpqbOrq6sF1ZqZ5aFll4Mi4hlgHwBJbwO+CYwqTTIaaLiHj4i5FPcQ6OjoiEoLNTPLSCvPBHYu9XYBAYyQND4NexewqFX1mJlZa28M7yvpO8Af0s8sYHfgGknPATdExP0trMfMLHutvBz0IHBU3eCH8c1gM7O28cNiZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxhwCZmYZcwiYmWXMIWBmljGHgJlZxgZECEg6R9LtkpZKmtzueszMctH2EJA0BdgzIo4BZgJz2lySmVk22h4CwLHAPICIWAmMaW85Zmb5UES0twDpUuDCFABI+inwxojYXJpmBjAj9e4PPNjiMvcAnmjxOncE191arru1XHffvDwixtYPHNaGQuptAEaX+jeXAwAgIuYCc1taVYmkzojoaNf6+8t1t5brbi3XvWMMhMtBS4DpAJIOBNa0txwzs3wMhDOBG4FpkpYAT1PcHDYzsxZoewikSz+z2l1HL9p2KWo7ue7Wct2t5bp3gLbfGDYzs/YZCPcEzMysTRwCZmYZG9IhICkkvaNu2G6Sfitp6g5Y/tmSjtve5TRY7mWSFkt6StIdqXubz/f2c9mXSzqgn/PeJGnfUv/3Jf1Nqf9fJL25ieXc2Z/197LMUyR9pI/zNHqdf7Wjayutr5L3S4P1/C5ty2JJZzYYf7Kkg9tRn6SdJX1D0iJJyyV9uZvpXirpkO1YzyRJ8/tdaM/Lbmob+rC8lrwvutP2G8MV+yXwMeBHpWGnAr9tTznNiYgPAUhaDBwXEf/X3opecAMwDbhA0nDg5cA7gO+m8W8APt6m2vqs0evc34CSpBg4N9hWRcTURiNSnVe0uJ6y44DnI+ItqZ4R3Uz32jTtPc0stMWvf7PbMCgM6TMB4EngsdoRhaSdgb8Cbq5NIOnPJS1JDdhdL2n3NPxOSV9J4xbW/tCSPpbG/Qg4uLScb0m6TdIKSYdJeo+ks0vjb5HUryYxyjsmSR+RdEpd7UslnZqGfVjSsvTzhjTsa2maG4C9S8uan2q+U9IrJf1Dadk7pXnKBwo/pNjpAxwDLAD2S9O+CngYeEeDmsZL+lE6cppdWv/Zkuakcb+QdHQavn96vW6TdHEa9gZJP03L/mgaNl3SXZJuBt5aWu5nJP1E0s8knSjpUEmXl8ZfKenPeni9a3/321WcOW51VJlet0np53pJC4BPpL/HslTnX6ZpW/5+abA99XW+cOTZhvp+DbxG6cw2Ip6TdGp6b6yQNEPSeOB84H2SrujD6z9ZxdnPLcAZpemnpeXfJenL6W96tySl8R9S384iG21Dd/+jA2Y/0q2IGLI/wJ0UzUz8W+o/CfgE8HVgKjAKWA6MTOPfDZyXun8F/FnqvgA4EdiP4rmGnQFR7BSPS9OMTb+PAb5NcZb1U4qgPQiY24/6FwO7AneWhn0EOCXV/hNgl1TLotq0pe3ZiWLn+O3UPxz4OXBAXc1/C5xF8eT2zWnYCcBZDWpaBoyk+Cc9BLgIOBT4KPDJbmr6d+CoNP+hte0Bzga+lrpfByxI3T8GJqTu2cAU4J+At5S2a1SqZbc07CLgI3Xb9XLg1tS9CHgJsDvwg0avc+p+GJhc+rv/BTAJmF+afn4aNonifVKb91pgn1KNLX2/lOr7XdqmxcCfN6jzbIqj2XbV92rgGuAcYERpXS8Cfp66pwJfT93Nvv4LS6//u2vzlJa/M/CLtA1fZ8v76VbgRdu5Ddv8jw6U/UhvP0P9chAR8aCkXSXtDXwIeCfw+TT6VcDdEfFs6l9IsYMFeCIi7k/d91M0bHcIsDAingeQtCL93g34rKTnKN7IL46ITZJuotgJnwj88w7etP1S/bem/j2APYEPA1+V9L8UO+rXATcBRMQfJN2bah4HfEHS74E/BdZGxHpJqyXtn16HRs9v3Aq8GTgkIu6RdCPF2cHrgfOA0xrUtE9ELE3DOuuWd0f6XXuNobgUcGU6UPsTYAXwFeB0ScdS/DONp/jbbSwtd4SknYDTVJzB/BF4cRr/r8B7KYKgp89pPxERvyjVNBro6TLDz2PL5brTgI9J2gh8k/a9X7a6HCRpUl2dNW2pLyLuA6ans5HLgRXp/biJ4qBhm1l6WFx5u14UEbV7Op0UZ/0Ax0t6NfAHigOY4RQHDedKegq4NyKe2c5t6M5A348M+ctBNecDV1CkdfmP/TBwWHrxodi5/Tx1l994QZHYvwGOghcuLU1J46cBj0fEpymOvmrmAh+kOKq9dzvqf75UY+3G7K+Be4E3pX/4wyLiN8BDEXEasJ4iEH4D1C6z7AYcnub/ALA01fxfpXVdCHwB2BARXQ1q+QFFOPwy9d9GcdQyiuJN3qim9dpyI/JNbPva1n4rdd8HvDMt4yiKI65nI+Is4DsUIbAG6NCWy1VT0+/XAntExKcojsxrrqYIq7dQHIV1p9xuVa22J4GXlYbvW+reVOp+PCLOBJZSHGi06/3SyKYGw1pen6SXqbifBEWTMYcAb4uIf6DYwdXe589THGFD86//MEl7pe43lYZ/PCI+CZxbW2ZEPEqx/zuTIhC2Zxsm0fh/FAbWfqShIX8mABARyyVtotjBlYevk3QecJukZ4DHgL/vYTl3SXpE0t3A/1L8MaG4BPNZFZ84uqs0/RPpyHR7b8R9A/g3SfdRXNNfGRFdkq4Dlkv6XVrv54F5kkZR/HPMogiLv5C0PG1f7ahkIfDvKj7d80CanohYqeL6fnfXSFcArwEuS9NvTEe+/9VDTZ8Bvi3pWeAWin/wnnwO+GE6IuqiuJl/hqS3pzrPj4i1kr4P3J3Oemqh9ABwgKTbKC4rker8o6SHgP+JugYKexMRT6u41n8R8DjFEWUj31TxpUjPU1xKa9f7pSltqm8y8I30/nie4vLs30taShGej6fp7gMukvSdiPi7Jl//TwM3SnqSYudcc6ekTor37iOl4fOAmRHx8HZuwxcozli3+h/tbuaB9r7wE8MVkvRSih3R0bVTv4FO0ssp7iEc2+5adiRJu1CctZwQEU+1uZyGBvr7ZaDX11eSLgG+FxG3tbuWnlT9uudyOajl0rXChRRHhIPiHyZ9ouF7wOltLmWHUvHpsGXAxQM4AAb0+2Wg19dXkpYBzw2CAKj8dfeZgJlZxnwmYGaWMYeAmVnGHAJmZhlzCFg2tB2N5/Wy3PeraKLiPTt62aV1tLWRMRu6snhOwKxip1I88LSu3YWY9ZXPBGxIU4PG89T3hvNqyzoyzbdY0q1p3k9TNJlxbWqaoDz9EZIuTN1TVHyPNpIOknSJiiaJL0nLXCTpFWn8Ng0Dlpa5t4pmr1+5418ty5HPBGzIkvRWiiYkjkqP+deewvx4err5b4G/Bi6maJTscopH92+KiEbNLFwAvCPNeygwOyJq7cc0avL7TooG8KBoiG6DpNEUjbddT3EG8WBEzJJ0IPA5SZ+kaIPozRRPRy+UNC8tY1yq8dR+POVq1pBDwIayRo3njaNo5K1PDeepaDZ4ba09pYi4W0WTx92KiJC0KjXDMRa4Eng7cCRFEyb/BBwq6Z1pli66bxgQ4MvA50uNpJltN4eADWW1xvOu1ZbG8/6bouG8eemou/aNbb01nPcEMEHS7qnNqddTNBPcm+uAzwI/o3j0/xLg91G0Qf/fwPKIuBJA0kiK1iPvpWjeIiSNjIhnVbSo+ilgpqTVEbGkwbrM+sz3BGwoWwDslRrPu5Ki8bwfUjTS9UOg1uIkEbGS4gi8YYuSUTxafxpwvaSfUHz/whmNpq2ziKIJ4O9HxAaK7zOofanRXOAEFV9ecxNweAqg6yga4buFovG9mg0UzSN/VdIbm1i3Wa/cbIQZQ7fhPLPe+HKQZS99MmgWRZvttWHz2boN+zkR0dP3ECDpfIr28WuujIh/3WGFmlXAZwJmZhnzPQEzs4w5BMzMMuYQMDPLmEPAzCxjDgEzs4z9PxLTNdIh+Z/YAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_song_info_sort = df_song_info[df_song_info.columns]\n",
    "df_song_info_sort['week_index'] = pd.to_datetime(df_song_info_sort['release_date']).dt.weekday\n",
    "df_song_info_sort['week_index'] = df_song_info_sort['week_index'].astype(str)\n",
    "df_song_info_sort = df_song_info_sort.sort_values(by = 'week_index', axis = 0)\n",
    "\n",
    "plt.title('요일별 발매 수')\n",
    "g1=sns.histplot(df_song_info_sort.day_of_week,shrink=.6)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4871f91b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "15510edd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4e4cbf84",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "5f9e3bb1",
   "metadata": {},
   "source": [
    "### 데이터 처리"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "05cb5053",
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.title('월별 장르 수')\n",
    "g1=sns.histplot(df_song_info_sort.day_of_week,shrink=.6)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "489c47c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_song_info['release_date'] = pd.to_datetime(df_song_info['release_date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ca1f12d2",
   "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>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>album_name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "      <th>day_of_week</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14776</td>\n",
       "      <td>All I Want For Christmas Is You</td>\n",
       "      <td>Mariah Carey</td>\n",
       "      <td>Merry Christmas (Deluxe Anniversary Edition)</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1489805</td>\n",
       "      <td>Must Have Love</td>\n",
       "      <td>SG 워너비, 브라운아이드걸스</td>\n",
       "      <td>SG워너비 &amp; 브라운아이드걸스 싱글</td>\n",
       "      <td>2006-11-16</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1500196</td>\n",
       "      <td>내사람</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Precious History</td>\n",
       "      <td>2006-11-15</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1615770</td>\n",
       "      <td>아리랑</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Sentimental Chord</td>\n",
       "      <td>2007-04-06</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1854856</td>\n",
       "      <td>라라라</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>My Friend</td>\n",
       "      <td>2008-04-24</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Thursday</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>8130796</td>\n",
       "      <td>상상더하기</td>\n",
       "      <td>라붐 (LABOUM)</td>\n",
       "      <td>Fresh Adventure</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>8235260</td>\n",
       "      <td>비</td>\n",
       "      <td>폴킴</td>\n",
       "      <td>비</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8252573</td>\n",
       "      <td>아주 NICE</td>\n",
       "      <td>세븐틴</td>\n",
       "      <td>Love&amp;Letter Repackage Album</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Monday</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>8298724</td>\n",
       "      <td>뜨거운 여름밤은 가고 남은 건 볼품없지만</td>\n",
       "      <td>잔나비</td>\n",
       "      <td>MONKEY HOTEL</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>인디음악, 록/메탈</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>9642570</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>닐로(Nilo)</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Monday</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1045 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      song_id                        song_name       artist_name  \\\n",
       "0       14776  All I Want For Christmas Is You      Mariah Carey   \n",
       "1     1489805                   Must Have Love  SG 워너비, 브라운아이드걸스   \n",
       "2     1500196                              내사람            SG 워너비   \n",
       "3     1615770                              아리랑            SG 워너비   \n",
       "4     1854856                              라라라            SG 워너비   \n",
       "...       ...                              ...               ...   \n",
       "1040  8130796                            상상더하기       라붐 (LABOUM)   \n",
       "1041  8235260                                비                폴킴   \n",
       "1042  8252573                          아주 NICE               세븐틴   \n",
       "1043  8298724           뜨거운 여름밤은 가고 남은 건 볼품없지만               잔나비   \n",
       "1044  9642570                              넋두리          닐로(Nilo)   \n",
       "\n",
       "                                        album_name release_date       genre  \\\n",
       "0     Merry Christmas (Deluxe Anniversary Edition)   2019-11-01    R&B/Soul   \n",
       "1                              SG워너비 & 브라운아이드걸스 싱글   2006-11-16    R&B/Soul   \n",
       "2                             The Precious History   2006-11-15    R&B/Soul   \n",
       "3                            The Sentimental Chord   2007-04-06    R&B/Soul   \n",
       "4                                        My Friend   2008-04-24         발라드   \n",
       "...                                            ...          ...         ...   \n",
       "1040                               Fresh Adventure   2016-04-06          댄스   \n",
       "1041                                             비   2016-06-21    R&B/Soul   \n",
       "1042                   Love&Letter Repackage Album   2016-07-04          댄스   \n",
       "1043                                  MONKEY HOTEL   2016-08-04  인디음악, 록/메탈   \n",
       "1044                                           넋두리   2016-09-12         발라드   \n",
       "\n",
       "     day_of_week  month  \n",
       "0         Friday     11  \n",
       "1       Thursday     11  \n",
       "2      Wednesday     11  \n",
       "3         Friday      4  \n",
       "4       Thursday      4  \n",
       "...          ...    ...  \n",
       "1040   Wednesday      4  \n",
       "1041     Tuesday      6  \n",
       "1042      Monday      7  \n",
       "1043    Thursday      8  \n",
       "1044      Monday      9  \n",
       "\n",
       "[1045 rows x 8 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_song_info['month'] = df_song_info['release_date'].dt.month\n",
    "df_song_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "55328a87",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "4c78a4e2",
   "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>unique_values</th>\n",
       "      <th>counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>발라드</td>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>랩/힙합</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>댄스</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>POP</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>록/메탈</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>발라드, 인디음악</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>인디음악, 포크/블루스</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>인디음악, 록/메탈</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>랩/힙합, 인디음악</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>성인가요</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>포크/블루스</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>R&amp;B/Soul, 인디음악</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>일렉트로니카</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>POP, 애니메이션/웹툰, 키즈, 만화</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>인디음악, 일렉트로니카</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>게임</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>POP, 록/메탈</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>발라드, 애니메이션/웹툰</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>재즈, 애시드/퓨전/팝</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>댄스, 랩/힙합</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>발라드, 애니메이션/웹툰, 키즈, 만화</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>댄스, 인디음악</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            unique_values  counts\n",
       "0                     발라드     284\n",
       "1                    랩/힙합     223\n",
       "2                      댄스     221\n",
       "3                R&B/Soul     122\n",
       "4                     POP      39\n",
       "5                    록/메탈      38\n",
       "6               발라드, 인디음악      27\n",
       "7            인디음악, 포크/블루스      18\n",
       "8              인디음악, 록/메탈      17\n",
       "9              랩/힙합, 인디음악      12\n",
       "10                   성인가요      10\n",
       "11                 포크/블루스       7\n",
       "12         R&B/Soul, 인디음악       6\n",
       "13                 일렉트로니카       4\n",
       "14  POP, 애니메이션/웹툰, 키즈, 만화       4\n",
       "15           인디음악, 일렉트로니카       3\n",
       "16                     게임       3\n",
       "17              POP, 록/메탈       2\n",
       "18          발라드, 애니메이션/웹툰       1\n",
       "19           재즈, 애시드/퓨전/팝       1\n",
       "20               댄스, 랩/힙합       1\n",
       "21  발라드, 애니메이션/웹툰, 키즈, 만화       1\n",
       "22               댄스, 인디음악       1"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_genre_count = df_song_info['genre'].value_counts().rename_axis('unique_values').reset_index(name='counts')\n",
    "df_genre_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "12abfe0f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['발라드', '랩/힙합', '댄스', 'R&B/Soul', 'POP', '록/메탈']\n",
      "6\n"
     ]
    }
   ],
   "source": [
    "df_genre_count_2 = df_genre_count.iloc[[0, 1, 2, 3, 4, 5]]\n",
    "genre_list = list(df_genre_count_2['unique_values'])\n",
    "print(genre_list)\n",
    "print(len(genre_list))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "b26db8b5",
   "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>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>album_name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "      <th>day_of_week</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14776</td>\n",
       "      <td>All I Want For Christmas Is You</td>\n",
       "      <td>Mariah Carey</td>\n",
       "      <td>Merry Christmas (Deluxe Anniversary Edition)</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1489805</td>\n",
       "      <td>Must Have Love</td>\n",
       "      <td>SG 워너비, 브라운아이드걸스</td>\n",
       "      <td>SG워너비 &amp; 브라운아이드걸스 싱글</td>\n",
       "      <td>2006-11-16</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1500196</td>\n",
       "      <td>내사람</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Precious History</td>\n",
       "      <td>2006-11-15</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1615770</td>\n",
       "      <td>아리랑</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Sentimental Chord</td>\n",
       "      <td>2007-04-06</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1854856</td>\n",
       "      <td>라라라</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>My Friend</td>\n",
       "      <td>2008-04-24</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Thursday</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>8130796</td>\n",
       "      <td>상상더하기</td>\n",
       "      <td>라붐 (LABOUM)</td>\n",
       "      <td>Fresh Adventure</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>8235260</td>\n",
       "      <td>비</td>\n",
       "      <td>폴킴</td>\n",
       "      <td>비</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8252573</td>\n",
       "      <td>아주 NICE</td>\n",
       "      <td>세븐틴</td>\n",
       "      <td>Love&amp;Letter Repackage Album</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Monday</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>8298724</td>\n",
       "      <td>뜨거운 여름밤은 가고 남은 건 볼품없지만</td>\n",
       "      <td>잔나비</td>\n",
       "      <td>MONKEY HOTEL</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>인디음악, 록/메탈</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>9642570</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>닐로(Nilo)</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Monday</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1045 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      song_id                        song_name       artist_name  \\\n",
       "0       14776  All I Want For Christmas Is You      Mariah Carey   \n",
       "1     1489805                   Must Have Love  SG 워너비, 브라운아이드걸스   \n",
       "2     1500196                              내사람            SG 워너비   \n",
       "3     1615770                              아리랑            SG 워너비   \n",
       "4     1854856                              라라라            SG 워너비   \n",
       "...       ...                              ...               ...   \n",
       "1040  8130796                            상상더하기       라붐 (LABOUM)   \n",
       "1041  8235260                                비                폴킴   \n",
       "1042  8252573                          아주 NICE               세븐틴   \n",
       "1043  8298724           뜨거운 여름밤은 가고 남은 건 볼품없지만               잔나비   \n",
       "1044  9642570                              넋두리          닐로(Nilo)   \n",
       "\n",
       "                                        album_name release_date       genre  \\\n",
       "0     Merry Christmas (Deluxe Anniversary Edition)   2019-11-01    R&B/Soul   \n",
       "1                              SG워너비 & 브라운아이드걸스 싱글   2006-11-16    R&B/Soul   \n",
       "2                             The Precious History   2006-11-15    R&B/Soul   \n",
       "3                            The Sentimental Chord   2007-04-06    R&B/Soul   \n",
       "4                                        My Friend   2008-04-24         발라드   \n",
       "...                                            ...          ...         ...   \n",
       "1040                               Fresh Adventure   2016-04-06          댄스   \n",
       "1041                                             비   2016-06-21    R&B/Soul   \n",
       "1042                   Love&Letter Repackage Album   2016-07-04          댄스   \n",
       "1043                                  MONKEY HOTEL   2016-08-04  인디음악, 록/메탈   \n",
       "1044                                           넋두리   2016-09-12         발라드   \n",
       "\n",
       "     day_of_week  month  \n",
       "0         Friday     11  \n",
       "1       Thursday     11  \n",
       "2      Wednesday     11  \n",
       "3         Friday      4  \n",
       "4       Thursday      4  \n",
       "...          ...    ...  \n",
       "1040   Wednesday      4  \n",
       "1041     Tuesday      6  \n",
       "1042      Monday      7  \n",
       "1043    Thursday      8  \n",
       "1044      Monday      9  \n",
       "\n",
       "[1045 rows x 8 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_song_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "bd233fc3",
   "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>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>album_name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "      <th>day_of_week</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14776</td>\n",
       "      <td>All I Want For Christmas Is You</td>\n",
       "      <td>Mariah Carey</td>\n",
       "      <td>Merry Christmas (Deluxe Anniversary Edition)</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1489805</td>\n",
       "      <td>Must Have Love</td>\n",
       "      <td>SG 워너비, 브라운아이드걸스</td>\n",
       "      <td>SG워너비 &amp; 브라운아이드걸스 싱글</td>\n",
       "      <td>2006-11-16</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1500196</td>\n",
       "      <td>내사람</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Precious History</td>\n",
       "      <td>2006-11-15</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1615770</td>\n",
       "      <td>아리랑</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Sentimental Chord</td>\n",
       "      <td>2007-04-06</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1854856</td>\n",
       "      <td>라라라</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>My Friend</td>\n",
       "      <td>2008-04-24</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Thursday</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1038</th>\n",
       "      <td>8111603</td>\n",
       "      <td>HandClap</td>\n",
       "      <td>Fitz &amp; The Tantrums</td>\n",
       "      <td>Fitz and The Tantrums (Deluxe Edition)</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>POP</td>\n",
       "      <td>Monday</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>8130796</td>\n",
       "      <td>상상더하기</td>\n",
       "      <td>라붐 (LABOUM)</td>\n",
       "      <td>Fresh Adventure</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>8235260</td>\n",
       "      <td>비</td>\n",
       "      <td>폴킴</td>\n",
       "      <td>비</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8252573</td>\n",
       "      <td>아주 NICE</td>\n",
       "      <td>세븐틴</td>\n",
       "      <td>Love&amp;Letter Repackage Album</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Monday</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>9642570</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>닐로(Nilo)</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Monday</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>927 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      song_id                        song_name          artist_name  \\\n",
       "0       14776  All I Want For Christmas Is You         Mariah Carey   \n",
       "1     1489805                   Must Have Love     SG 워너비, 브라운아이드걸스   \n",
       "2     1500196                              내사람               SG 워너비   \n",
       "3     1615770                              아리랑               SG 워너비   \n",
       "4     1854856                              라라라               SG 워너비   \n",
       "...       ...                              ...                  ...   \n",
       "1038  8111603                         HandClap  Fitz & The Tantrums   \n",
       "1040  8130796                            상상더하기          라붐 (LABOUM)   \n",
       "1041  8235260                                비                   폴킴   \n",
       "1042  8252573                          아주 NICE                  세븐틴   \n",
       "1044  9642570                              넋두리             닐로(Nilo)   \n",
       "\n",
       "                                        album_name release_date     genre  \\\n",
       "0     Merry Christmas (Deluxe Anniversary Edition)   2019-11-01  R&B/Soul   \n",
       "1                              SG워너비 & 브라운아이드걸스 싱글   2006-11-16  R&B/Soul   \n",
       "2                             The Precious History   2006-11-15  R&B/Soul   \n",
       "3                            The Sentimental Chord   2007-04-06  R&B/Soul   \n",
       "4                                        My Friend   2008-04-24       발라드   \n",
       "...                                            ...          ...       ...   \n",
       "1038        Fitz and The Tantrums (Deluxe Edition)   2017-07-24       POP   \n",
       "1040                               Fresh Adventure   2016-04-06        댄스   \n",
       "1041                                             비   2016-06-21  R&B/Soul   \n",
       "1042                   Love&Letter Repackage Album   2016-07-04        댄스   \n",
       "1044                                           넋두리   2016-09-12       발라드   \n",
       "\n",
       "     day_of_week  month  \n",
       "0         Friday     11  \n",
       "1       Thursday     11  \n",
       "2      Wednesday     11  \n",
       "3         Friday      4  \n",
       "4       Thursday      4  \n",
       "...          ...    ...  \n",
       "1038      Monday      7  \n",
       "1040   Wednesday      4  \n",
       "1041     Tuesday      6  \n",
       "1042      Monday      7  \n",
       "1044      Monday      9  \n",
       "\n",
       "[927 rows x 8 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con1 = df_song_info['genre'] == genre_list[0]\n",
    "con2 = df_song_info['genre'] == genre_list[1]\n",
    "con3 = df_song_info['genre'] == genre_list[2]\n",
    "con4 = df_song_info['genre'] == genre_list[3]\n",
    "con5 = df_song_info['genre'] == genre_list[4]\n",
    "con6 = df_song_info['genre'] == genre_list[5]\n",
    "\n",
    "df_song_info_genre = df_song_info.loc[con1 | con2 | con3 | con4 | con5 | con6]\n",
    "df_song_info_genre"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d75949dc",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "3886717d",
   "metadata": {},
   "source": [
    "### 월별 장르 선호도 그래프 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "1c75420b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA3IAAAFxCAYAAAA23JpmAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAApGElEQVR4nO3de7hWZZ0//vcNomhSoJKTKWknlaTRkTLPaB4os8mJTMscGh3tYE2XgjlZxNA4mQ6jefhqzcnxh+l8xUNao1YoppinnEn6eugkQ+QRQp1EFOH+/cF2D8gGNsizn732fr2uq4tnrXWvZ32e+9runve+17rvUmsNAAAAzTGg3QUAAACwbgQ5AACAhhHkAAAAGkaQAwAAaBhBDgAAoGEEOQAAgIbZqN0FrM5WW21Vt99++3aXAQAA0BY//elP59dah3d1rNcGue233z733ntvu8sAAABoi1LKf6/umFsrAQAAGkaQAwAAaBhBDgAAoGF67TNyXVmyZEnmzZuXxYsXt7uUxhk8eHC23XbbDBo0qN2lAAAAr1Kjgty8efMyZMiQbL/99imltLucxqi1ZsGCBZk3b1522GGHdpcDAAC8So26tXLx4sXZcssthbh1VErJlltuaSQTAAD6iEYFuSRC3HrSbwAA0Hc0LsgBAAD0d4JcD6m1trsEAACgj2jUZCftcOqpp+b222/P1ltvneeeey7nnXderrjiitxyyy2pteacc87J7rvvnjFjxuR973tfbrzxxjz//PO5/vrrM3z48LznPe/JAQcckCeeeCLnnXdeTjjhhDz++OPZbLPNcumll2aLLbZo90cEAAAaxojcGvzwhz/MwoULc8cdd+Tf//3f89RTT+VHP/pRnn766dx666259tpr89WvfrWz/a677ppbbrklRx55ZK644ookyfz58/OJT3wi//Iv/5IzzzwzRx55ZG6++eZ85jOfyYUXXtiujwYAADSYEbk1+M///M+8//3vT5JsvPHGGTVqVH7/+99nxowZGTNmTJJk6dKlne3322+/JMnOO++cu+++O0kydOjQjBw5Mkly33335dZbb825556bl156Ke9617t68NMAAAB9hSC3BiNGjMhtt92WI444IosWLcqdd96ZkSNH5sgjj8xXvvKVJMmiRYs62788M2QppfOZuI02+t8ufvvb354Pf/jD2XfffZMkzz//fE99FAAAoA8R5NZg3Lhxue6667LnnntmxIgRefOb35yPfvSj+cY3vpF99tknQ4YMySc/+ckceeSR3Xq/L33pSxk/fnwmTZqUzTffPF//+tezyy67tPhTAAA009wpo7rVbsSk2S2uBHqf0ltnUxw9enS99957V9r34IMPZuedd+6xGpYuXZoBAwaklJJnnnkmBxxwQO65554MHDiwx2rYkHq6/wAAXg1Bjv6ulPLTWuvoro4ZkVuDJ598Msccc0yWLVuWJUuW5Mwzz2xsiAMAAPoOQW4N3vCGN2TGjBntLgMAAGAllh8AAABoGEEOAACgYQQ5AACAhhHkAAAAGqbRk53sPvHSDfp+Pz372LW2ee1rX5s/+ZM/yeLFi/Oe97wn5557bpJk4cKF+chHPpJnn30273jHO/Kv//qvK503fvz4PPDAA9l4440zfPjwfOc738mmm27aefxjH/tYpk6dmptuuin/9m//lpdeeimvfe1r8/3vf3+dP8f48eNz2mmnZaeddlrncwEAgN7PiNw6GjlyZGbOnJk777wzjz32WH72s58lSW688cYceuihufvuuzNv3rwsWLAgc+bMyZNPPtl57qWXXprbb789u+yyS2644YbO/b/97W8zaNCgvOY1r8k//uM/ZsaMGbntttty9dVX9/jnAwAAej9Bbj0tXrw48+fPz+tf//okyd57751777033/3ud7PLLrtkyy23zNVXX52bb755pfOWLl2aOXPmZMcdd+zcd+GFF+Yzn/lMNt100wwYMCA///nPkySbbLJJkuSxxx7Lhz70oRxwwAHZc889c9NNNyVZPvL20EMPJUkeeuihjB8/vtUfGwAA6AUEuXX0wAMPZI899shb3/rWTJ48OW94wxuSJHfccUeGDx+eq666Km9961uTJA8++GDe8Y53dJ577LHHZuTIkXn66aez3XbbJVkeCGfPnp099tgjgwYNyjXXXJNvfetb+eQnP5nf/e53SZKJEyfm5JNPzi233JIbbrghX/ziF1Nr7eFPDgAA9BaC3DoaOXJk7rrrrvz1X/91rrvuuiTJ3Llzc8011+SCCy7IpZdemq222ioTJ07Mo48+mlGjRnWee+mll+bhhx/O5z73uUyYMCFJMm3atHz84x/vbLPVVlvlwgsvzFe+8pUceeSReeGFF/LrX/86++23X5Jk6NChedOb3pT58+enlNKDnxwAAOgtBLn19NnPfjb33XdfZs+enT/84Q95/vnnO4/tv//+ufbaa/PhD3+4y3O32mqrPPfcc0mSq666Kh/5yEeSJM8991wWLFiQJHnzm9+cwYMH59lnn812222XWbNmJUmeeeaZPPnkk9lqq62y5ZZb5tFHH02S/OpXv2rZZwUAAHqXRs9a2W7nnHNO/uqv/io333xzRo8enQMOOCADBw7M5ptvniuuuCLnnHNOrrrqqs4ZLI899thsttlmGTx4cC6++OLMnDkze+21VwYNGpRkeZA7/PDDs9FGG2XQoEH54Ac/mOHDh2fq1Kk58cQTs2jRomy00UY555xzUkrJCSeckAkTJuS2227LokWL2tkVAABADyq99Vmr0aNH13vvvXelfQ8++GB23nnnNlW04X3sYx/Lueee2zlhSqv1tf4DAPq2uVNGrb1RkhGTZre4EmiPUspPa62juzpmRK6NvvOd77S7BAAAoIE8IwcAANAwghwAAEDDCHIAAAANI8gBAAA0jCC3gXz+859fa5vvfve7PVAJAADQ1zV61sruTknbXd2Zunbs2LG58cYbkyQzZ87MnXfemdNOOy2/+MUvOtuceuqpue+++5IkCxcuzBFHHJEvf/nLOf/88/Onf/qnK73fjjvumO22226lfcOHD8/ll1/+aj8OAADQRzU6yLXD73//+3zhC19IksybNy+jRy9f1qHWmttvvz1ve9vbctZZZ3W2nzlzZm6//fbVvt92222XH/3oRy2tGQAA6FsEuXW0xRZb5O///u+TJLfeemvuueeeJMuD3Lx587LNNtvk2WefzYsvvpgkeeaZZ9pWKwAA0DcJcuvowAMPzGmnnda5fdhhhyVJBgwYkKOOOipJctBBB2WnnXbqbHP44YcnSZYtW5YPfehDOfjgg/PZz362B6sGAAD6EkFuHZ166qn5zne+k7lz5yZJ7rrrrtx111056KCDVmp3wQUXrHLugAEDcu211660b9iwYRkzZswqbW+44YZsuummG6xuAACg7xDk1sO73/3ujBw5cqV9J510UiZMmNBl+1prlixZ0uWxK6+8coPXBwAA9G2C3Hq44IIL8l//9V8r7fvVr37V+XrkyJE5+uijM2DAgJRSkiSf/OQnV2r/wx/+MGecccYar3Paaadl7NixG6ZoAACgz2h0kOvOcgGt8NBDD2XmzJmrPX7eeed1uf/rX/965+uDDz44Bx988IYuDQAA6AcaHeTaZcmSJas8E5ck5557bnbZZZc2VAQAAPQngtx6mDFjxnqdZ704AABgQxjQyjcvpdxXShlbStmxlDKjlDKrlHJ2K68JAADQ17UsyJVSxiV5XcfmuUmOq7XunWT7UsoerbouAABAX9eSIFdKGZLkE0kuy/LbNwfXWud0HL4qyZ6tuC4AAEB/0KoRufOS/G2SZUmGJFmwwrEFSYZ1dVIp5YRSyr2llHufeuqpFpUGAADQbBs8yJVSPp5kbq31no5dTycZukKTYUm6TGm11m/XWkfXWkcPHz58Q5fWa11zzTVrbXP00Uf3QCUAAEATtGLWyo8lWVRKuSLJLknGJNmxlPLGWuvvkvxZkr/ZEBfa+/y9N8TbdJr1uVndbnv00UfnlaOG//3f/51f/vKXXbY/8MADM2DA8tz8s5/9LE899VTGjh2bG2+8Md/85jdzxBFHJEnGjh2bxYsXd563++67Z+rUqatcCwAA6L82eJCrtR728utSyuQkd2b57ZTTSykvJLmu1vrghr5uT3v00UczaNCglfZts802K20vWbIkH/jAB3LTTTdlwIABncsPdLUG3Yo+9alPdb4+8MADO1/feeedefOb35zXv/71r7Z8AACgwVq6jlytdfIKm31qgpNNN900N9544xrbXHnllRk3blyXx+bPn58lS5Z0eWzXXXftfL355psnSWqtmTdvXl7/+tcLcgAA0M9ZEHw9DRs2LAcddFAef/zx1Frzhje8IUly2WWXZeutt+58PX369FXOXbZsWSZMmJCHHnpolWMf/OAHc9lll6WUklJKkuT0009PKWW1oRAAAOhfBLl19Mgjj2TWrFk57LDld5DecccdWbp0afbdd98kyQ9/+MPstddeWbBgQUaNGpVNN910lfcYMGBALrnkkowdO3aVY5/5zGdy1VVX5ZFHHuncd9555+X9739/iz4RAADQNILcOnrd616XnXbaqXN7xdcrtpkyZUqmTJnSua/Wmu9973tJkgULFqxyzop22223vOUtb1lp30knnZSTTz751ZQOAAD0EYLcOtpiiy3y4osv5qijjlrl2K9//ev89re/zRNPPJElS5ZkxIgRncdOOumkzJkzJ0nyl3/5l2u8xsUXX5y77757pX0PP/zwqy8eAADoExod5NZluYAN6Y/+6I8yc+bMVfa/PBvlRRddtNLMk0k6lxfojvvvv7/L9wcAAEgaHuR6oyVLluTuu+/O5MmTX9X7jBkzZpV9559/fkaNGvWq3hcAAGg+QW4DenmduP/4j//oVvuXly945ejb2pY1AAAA+rcB7S4AAACAdSPIAQAANIwgBwAA0DCCHAAAQMM0erKTW/fbf4O+3/4/vnWDvh8AAEArGJFbR6997WszZsyYvPvd7843v/nNzv233XZbDj744BxwwAHZb7/9MnXq1CxbtixJMnny5Lzzne/Mfvvtl0MOOSRz585tV/kAAEAfIMito5EjR2bmzJn5yU9+ku9973t55JFH8sADD+S0007LtGnTcsstt2TmzJl54okncv7553eed9ZZZ+XHP/5xvvSlL+WrX/1qGz8BAADQdILceho4cGB22223PPbYY7noooty1llnZeutt06SDBgwIGeccUYuv/zyVc5797vfnd/97nc9XS4AANCHCHLraf78+bn77rszatSo/OY3v8nOO++80vFBgwZlwIBVu/eSSy7Je9/73p4qEwAA6IMEuXX0wAMPZMyYMRk/fnymTp2aIUOGZLvttssvfvGLldq9+OKLGThwYOf2qaeemgMOOCCPPfZYTjnllJ4uGwAA6EMaPWtlO7z8jNyKPvWpT+ULX/hCrr766myxxRZZunRpTj311IwfP76zzVlnnZWxY8f2bLEAAECf1Ogg11uWC9h1111z+umnZ9y4cVm2bFlqrTnqqKNy3HHHtbs0AACgD2p0kGuHO++8s8v9Bx98cA4++OAuj02ePLmFFQEAAP2NZ+QAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkeqH58+e3uwQAAKAXE+Q2kDlz5uRTn/rUGtvcf//9efrppzu3Fy5cmDlz5qzS7phjjllp+5JLLtkAFQIAAH1Fo5cfuOCU6zfo+5009fC1tjnllFPy05/+NMnykbOf//znGTt2bC6++OLVnjN79uwsXbo05513Xg499NDsuOOO2WKLLfKb3/wmt99+e7785S/njjvuyKRJkzrPOeigg5IkU6dOzbRp01ZaXBwAAOjfjMito2OPPTaTJ0/O5MmTM3To0CTLR9ZmzZq1UrslS5bk0EMPTZLccsst+cEPfpChQ4dm9uzZ+dGPfpQHHnhgpfZ77bVXrrjiirzzne/MsGHDsuuuu+bKK6/MH//xHydJ/vCHP2Tp0qWt/4AAAECvJ8ito1NOOaXz9dSpU1fb7sorr8y4ceOSJIceemhuvfXWDB06NIsWLcrs2bNzyCGHrHLO5z73uXziE5/IlVdemY9+9KP5/Oc/nyRZtmxZjj/++Nx///0b+NMAAABN1OhbK9vhda97Xb7//e8nSQYNGpSNNtoow4YNy957753bbruts91ll12W6dOnJ0m+973v5S/+4i/y4Q9/OEly9NFH5/HHH1/lvf/whz/kjW98Y5JkxIgRefbZZ5MkAwYMyBVXXNHSzwUAADSHILeOrrrqqlX2vf3tb8/222/f+ZzcPffck1GjRmXTTTdNkowfPz4TJkzIDTfckJdeeim77bZbttlmm/ziF79Y6X2+8Y1vdE6YMmDAgJx11lkt/jQAAEATCXLrYcaMGXnxxRfzvve9L0ly3nnn5fHHH8+0adMyYcKEXHjhhZkyZUpn+y233DJf+MIX8vzzz+c973lP5/5tt902e+yxR+f2yJEjc+KJJ3Y+W/eyiRMntvgTAQAATSLIrYennnoqX/va11Z6Rm7x4sXZZZdd8sQTT2TJkiUZMWLESuf88pe/zKRJk7LNNtt07lu4cGGOOOKIHHzwwZ37Jk2alLPPPnulc2fPnp0nnniiRZ8GAABomkYHue4sF9AqEydOXGlJgDlz5uTMM8/MRRddtNr15E4++eQcf/zxndszZ87M7bffvlKbYcOG5cYbb1xp39ixYzdc4QAAQOM1Osi109lnn51p06Z1bi9evDg77rhj7r777kyePLlb5zz99NOdM1u+bOHChZ1ryL1s9uzZG65wAACg8QS59XDUUUflqKOOWqdzxo0bt0po68pdd921vmUBAAD9hHXkAAAAGkaQAwAAaBhBDgAAoGEEOQAAgIYR5Dag+fPnr7S2HAAAQCs0etbKM45Z+yyQ6+L0adO71W78+PF5+OGHs8kmm2TgwIGZMWNGxo4dm3/6p3/qcqmAiy66KEny6U9/eoPWCwAA9E+NDnLtdOWVV2bbbbdda7tly5blpptuSiklJ554YgYMMAgKAAC8OlLFBrJw4cL88z//80r7Fi1alJNOOinHHXdcjj/++Hz605/O//zP/7SpQgAAoK8wIreBbLLJJtlxxx3zyCOPJEmmTJmSBx54IF/84hez2267JUlGjBiRE044IW9/+9vzN3/zN+0sFwAAaDBBbj3ssMMOOf7447PRRhtl4MCB+cpXvpLNNtss++yzT2688cYkySmnnJLXvOY1K503atSoXH755Vm0aFE7ygYAAPoIQW49fPWrX11rm1eGuBVtttlmG7IcAACgnxHk1tNPfvKT3HLLLfnSl76UJPnyl7+cbbfdNpdccklmzJiRr3/962s8/9RTT80hhxzSE6UCAAB9TKODXHeXC2iFpUuX5sUXX+zc3meffTpfv/e978173/vedpQFAAD0A40Ocu12ySWXZObMmSvt22KLLXL11Ve3pyAAAKBfEOTW0z777JM5c+a0uwwAADaQC065fq1tTpp6eA9UAmtnHTkAAICGaVyQq7W2u4RG0m8AANB3NCrIDR48OAsWLBBK1lGtNQsWLMjgwYPbXQoAALABNOoZuW233Tbz5s3LU0891e5SGmfw4MHZdttt210GAACwATQqyA0aNCg77LBDu8sAAABoq0bdWgkAAEDDRuQAAIDe54xjxq21zenTpvdAJf2HETkAAICGEeQAAAAaRpADAABomJY8I1dK2TjJVUmGJClJPpZk8yT/J8ngJHfUWie24toAAAB9XasmO3kpyUdrrYtKKcck+fMk+yY5rtY6p5RyZSllj1rrXS26PgAAQJ/Vklsra63Laq2LOjbflmR2ksG11jkd+65Ksmcrrg0AANDXtWz5gVLKxCQnJPlFkm8nWbDC4QVJdu7inBM6zsmIESNe1fXnThnVrXYjJs1+VdcBAICe1J3vub7j9n0tm+yk1np2rfVtSS5I8g9Jhq5weFiSp7o459u11tG11tHDhw9vVWkAAACN1pIgV0oZUkopHZtzkwxMskkp5Y0d+/4syYxWXBsAAKCva9WtlTslObeU8kKS55OclGSrJNM79l1Xa32wRdcGAADo01oS5Gqt9yTZ+xW7H4kJTgAAAF41C4IDAAA0jCAHAADQMIIcAABAwwhyAAAADSPIAQAANIwgBwAA0DCCHAAAQMMIcgAAAA0jyAEAADTMRu0uAABa4YxjxnWr3enTpre4kt6lO/3S3/ok0S9A8xiRAwAAaBhBDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYs1YCAACrdcEp17e7BLpgRA4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhrH8ALBac6eMWmubEZNm90AlAABr1t++txiRAwAAaBhBDgAAoGEEOQAAgIYR5AAAABpGkAMAAGiYbgW5UsqZr9ie0ppyAAAAWJs1Lj9QSnl7kgOSfKiU8puO3YOTjEsyqcW1AQAA0IW1rSP3TJLFSWqSFzr2LUpyeCuLAgAAYPXWGORqrU8k+bdSyuxa6309VBMAAABrsLYRuZcNLqVMTzIsy5+rq7XWA1tXFgAAAKvT3SD3rSTHJnkwy2+zBAAAoE26G+R+W2v9z5ZWAgAAQLd0N8j9vJRyRpIfp2NErtb6g5ZVBQAAwGp1N8g91/Hvezr+rUkEOQCADWDulFHdajdi0uwWVwI0RbeCXK31b1pdCAAAAN3TrSBXSrklr5jkxKyVAAAA7dHdWyvHrvD6bUkOa0EtAAAAdMOA7jSqtb6wwv9+nmTTFtcFAADAanT31spDVth8Y5JdW1INAAAAa9XdWyv37Pi3JlmQ5LjWlAMAAMDadHvWylLKFkl2SPLLWuuzrS0LoGtnHDNurW1Onza9Zdc3RTgA0Bt06xm5UsrHk1yf5BNJri2lvL+lVQEAALBa3b218qQk+9daXyylbJzkxiT/0bqyAAAAWJ1ujcgleb7W+mKSdPzb3fMAAADYwLobyH5XSjmmlDK0lHJ0kidbWRQAAACr191bK/89yV5JjkrycJK/b1lFAAAArFF3g9yptdb9Xt4opfwgySFraA8AAECLdDfIlVdsD9nQhQAAtMIFp1zf7hKAPqg7v1tOmnp4y67f3SA3vZQyLcn0JGOT3NayigAAAFij7i4I/s1Syr5J3p3k+7VWf9oCAABok+6OyKXWeluMxAEAALSd9eAAAAAaRpADAABoGEEOAACgYbr9jBz0ZXOnjFprmxGTZm+w67V7uloAAJrNiBwAAEDDCHIAAAANI8gBAAA0TEuekSulDE1ycZI/yvKw+OdJNk7yf5IMTnJHrXViK64NAADQ17VqspPNkpxca320lHJYkglJ3pzkuFrrnFLKlaWUPWqtd7Xo+gAAAH1WS26trLU+Wmt9tGNzYZIXkgyutc7p2HdVkj1bcW0AAIC+rqXPyJVS3pjlo3FTkyxY4dCCJMO6aH9CKeXeUsq9Tz31VCtLAwAAaKyWBblSygeSTEryl0l+n2ToCoeHJVklqdVav11rHV1rHT18+PBWlQYAANBoLQlypZR3Jjm81npirXVBrfX5JJt0jNAlyZ8lmdGKawMAAPR1rZrsZGySfUspMzu25yY5Ocn0UsoLSa6rtT7YomsDAAD0aS0JcrXWs5Kc1cUhE5wAAAC8ShYEBwAAaBhBDgAAoGFa9YwcvdTcKaO61W7EpNktrgQAAFhfRuQAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkAAAAGkaQAwAAaBjLD9BSF5xy/VrbnDT18B6oBAAA+g4jcgAAAA0jyAEAADSMIAcAANAwghwAAEDDCHIAAAANY9ZKAF61uVNGdavdiEmzW1wJAH3N7hMv7Va7a4a0uJBexogcAABAwwhyAAAADSPIAQAANIwgBwAA0DCCHAAAQMMIcgAAAA1j+QH6vO5MWdvfpqvtrS445fq2Xr83/qx0t09Omnp4iysBIEnOOGZct9qdPm16iyuhvzMiBwAA0DCCHAAAQMMIcgAAAA0jyAEAADSMIAcAANAwghwAAEDDWH4AAFpk7pRRa20zYtLsHqgEep/euOQLNIkROQAAgIYR5AAAABpGkAMAAGgYQQ4AAKBhBDkAAICGEeQAAAAaxvID0Eudccy4tbY5fdr0HqiEJvDzAqyLC065vlvtTpp6eIsrAdaXETkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkAAAAGsbyAwAA0EvsPvHStba5ZkgPFEKvZ0QOAACgYQQ5AACAhhHkAAAAGkaQAwAAaBhBDgAAoGEEOQAAgIax/MAGcsEp13er3TNP/Nta25w+bfqrLQegT+vu71wA6KuMyAEAADSMIAcAANAwghwAAEDDCHIAAAANI8gBAAA0jCAHAADQMJYfgG7a+/y9u9Vu1udmtbgSoDfYfeKla21zzZAeKGQFlmUA6D+MyAEAADSMIAcAANAwghwAAEDDtCTIlVKGl1LOKKV8rWN7x1LKjFLKrFLK2a24JgAAQH/RqhG5qUleSDKoY/vcJMfVWvdOsn0pZY8WXRcAAKDPa0mQq7Uem+THSVJK2SjJ4FrrnI7DVyXZsxXXBQAA6A96YvmB4UkWrLC9IMnOXTUspZyQ5IQkGTFiROsro1c445hx3Wp3+rTpLa4EAACaoScmO3k6ydAVtocleaqrhrXWb9daR9daRw8fPrwHSgMAAGielge5WuvzSTYppbyxY9efJZnR6usCAAD0VT1xa2WSnJxkeinlhSTX1Vof7KHrAgAA9DktC3K11plJZna8vicmOAEAANggLAgOAADQMIIcAABAw/TUM3IANNTuEy9da5trhvRAIQDQMN1ZZmt9l9gyIgcAANAwghwAAEDDCHIAAAANI8gBAAA0jCAHAADQMIIcAABAw1h+AADoUXOnjFprmxGTZvdAJaxNK6dOp3e4db/9197oXRNaXwjrzIgcAABAwwhyAAAADSPIAQAANIwgBwAA0DCCHAAAQMOYtRIAoIV2n3jpWttcM6QHCunn+tvsjHufv3e32v2dONBYRuQAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkAAAAGkaQAwAAaBjzjXZDf5uulr6vO1NhJ6bDBtaN3y0APceIHAAAQMMIcgAAAA0jyAEAADSMIAcAANAwghwAAEDDCHIAAAAN0++XH9j7/L3X2ubvdBPrwHIVJN373TLrc7N6oBKgL/G7BXiZETkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkAAAAGqaR8+rvPvHStba5ZkgPFAIAANAGRuQAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkAAAAGkaQAwAAaJhGLj8AAEDXbt1v/7U3eteE1hfSg/Y+f++1tvk7X3vpY4zIAQAANIwgBwAA0DCCHAAAQMMIcgAAAA0jyAEAADSMIAcAANAw5mHtQ3afeOla21wzpAcKAbrFFOFdm/W5WT1QSfP0x5+XtelWnyT9rl+A/sGIHAAAQMMIcgAAAA0jyAEAADSMIAcAANAwghwAAEDDCHIAAAANY/kB1pupsOkuU4SzLvxuAaCdmvK9xYgcAABAwwhyAAAADSPIAQAANEyPBrlSytdKKbeWUmaVUt7Rk9cGAADoK3osyJVS9k2yda11/yQnJjm7p64NAADQl/TkiNwhSS5Pklrrz5Ns0YPXBgAA6DNKrbVnLlTKt5Kc3xHiUkq5Pcl+tdZlK7Q5IckJHZs7Jnm4R4pbu62SzG93Eb2QfumaflmVPumafumafumaflmVPumafumafumafllVb+qTN9Vah3d1oCfXkXsmybAVtpetGOKSpNb67STf7sGauqWUcm+tdXS76+ht9EvX9Muq9EnX9EvX9EvX9Muq9EnX9EvX9EvX9MuqmtInPXlr5W1JxiVJKWVkknk9eG0AAIA+oydH5L6f5P2llNuS/E+WT3gCAADAOuqxINdxG+Wne+p6G1ivu92zl9AvXdMvq9InXdMvXdMvXdMvq9InXdMvXdMvXdMvq2pEn/TYZCcAAABsGD26IDgAAACvniC3BqWU4aWUM0opX2t3Lb1JKWVoKeWKUsrMUsqPSyk7tLumdiulbFxKub6jT24tpbyx3TX1NqWU+0opY9tdR29RSpnd8fMys5TysXbX01uUUt7d8XtlVinl1HbX026llJNW+DmZWUrpLdNht10p5eSO37ezSim7tbue3qKUclZHv/yklLJru+tpl1d+hyul7FhKmdHx83J2u+trl66+25ZSDiql/FcpZXA7a2unLn5ejur4nXtvKeWv213f6vTkZCdNNDXJr5Js1u5CepnNkpxca320lHJYkglJPtvmmtrtpSQfrbUuKqUck+TPk/xdm2vqNUop45K8rt119DJP1FoPancRvUkpZVCSSUn+tNa6sN319Aa11guSXJAkpZQPJ+n3fzhLlv9BMckHk4xJ8pYk5yQ5vI0l9QodfywbXGvdv5Syc5b/7Ly3zWW1yyu/w52b5Lha65xSypWllD1qrXe1rbr2WalfSikfSvKuJC+2sabe4JU/L7+qtY4ppQxIckcp5Z9qrU+1r7yuGZFbg1rrsUl+3O46epta66O11kc7Nhcmea6d9fQGtdZltdZFHZtvSzK7nfX0JqWUIUk+keSydtfSyyxbe5N+531J/jvJ5R1/Of+TdhfUW3R8mfhsOkIdWZrl32E2zvKFe3vdF6w2GZXkliSptT6YZGhbq2mjFb/DlVI2yvKAO6fj8FVJ9mxTaW31yu+2tdZra62nJ1m0+rP6vi765d6Of5clWZBeGnQFOdZbx+2DE7L8r1z9XillYinll0lGJ7m53fX0Iucl+dsILp1KKa9J8paOWwj/byllu3bX1Eu8LckWST6Q5LgkF7a3nF7lT5P8sNa6uN2F9Aa11v/J8i9dDya5LstH5EjuT/KhstzbkmxfSintLqoXGJ7lX8ZftiDJsDbVQoOUUj6T5LZa6zPtrqUrghzrpZTygSy/BeovVxid69dqrWfXWt+W5X8x9wU0SSnl40nm1lrvaXctvUmt9bla61tqrfsl+ccsv6WD5bco/6DW+lLHX86X+RLa6S+S/HO7i+gtOm7rH5Tlt1XulOS8jltz+7Va601JfplkZpYv+XRnNT15kjydlUcnh8UoLmtQShlSSrk4yZO11jPbXc/qCHKss1LKO5McXms9sda6YK0n9AMd/8G//IVzbpLN21lPL/KxJCNLKVckGZfktFLKjm2uqe1KKQNX2PRl4n/9JMtvr0wpZeskS3wJTUopW2b5bWFPtruWXuRNWf6caU3ybJIhSfrtRA0rqrX+ba11/yQ/SnJnu+vpDWqtzyfZZIWJyP4syYw2lkTvd0GSf6i1Tm93IWtishPWx9gk+5ZSZnZsz+24t7g/2ynJuaWUF5I8n+SkNtfTK9RaD3v5dSllcpb/dfjh9lXUa7y1lPIvWX7P/YtZ/pfzfq/Wencp5eFSyqwsH507ud019RL7ZXnI5X9dkuRfSim3Jtkkybc6brfs1zpC/3eTlCS/iN8tKzo5yfSO/5++ruMZQlidDyR50wo3hUyptfa6x2YsCA4AANAwbq0EAABoGEEOAACgYQQ5AACAhhHkAAAAGkaQAwAAaBhBDgDWUSllk1LKe1bYtl4XAD1KkAOAdfeGJF9odxEA9F+CHAB9Xill+1LKf5RS/rGU8vNSymGllGmllHtKKf9QShlYSrmglDKzlHJnKeXUjvPGdLS7upQyu5TyV6WUgUmuSHJgKeUHK1zjb0spt5VSbi2lbNquzwpA/yDIAdBfvCXJZ5Psl+TyJF+ptb4ryUFJPpPkyVrrmCR7JdmnlPLOjvPelOQjSUYn+VStdWmSo5LcXGs9pKPN65NcXmvdN8nPkry8HwBaQpADoL/4r1rri7XW3yd5qNb6SMf+uUl2TfK9JKm1LktyS5IdO47fUWtdWmt9Icmzq3nv+bXW/9fx+sEkw1rxAQDgZYIcAP1FXeH1slcc+3WSsUlSShmQZN8k93dx3suvlybZZDXvt2J7AGgJQQ4Akv8vyQ6llNuyfDTu+7XWh9fQ/tEkW5VSbuqR6gDgFUqt/nAIAADQJEbkAAAAGkaQAwAAaBhBDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYQQ4AAKBhBDkAAICG+f8BfbYdU0qii5IAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 1080x432 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(15,6)) # 그림 크기\n",
    "\n",
    "sns.countplot(x = 'month', hue = 'genre', data = df_song_info_genre)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cc2f06a4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "50b35a8d",
   "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>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>artist_name</th>\n",
       "      <th>album_name</th>\n",
       "      <th>release_date</th>\n",
       "      <th>genre</th>\n",
       "      <th>day_of_week</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14776</td>\n",
       "      <td>All I Want For Christmas Is You</td>\n",
       "      <td>Mariah Carey</td>\n",
       "      <td>Merry Christmas (Deluxe Anniversary Edition)</td>\n",
       "      <td>2019-11-01</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1489805</td>\n",
       "      <td>Must Have Love</td>\n",
       "      <td>SG 워너비, 브라운아이드걸스</td>\n",
       "      <td>SG워너비 &amp; 브라운아이드걸스 싱글</td>\n",
       "      <td>2006-11-16</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1500196</td>\n",
       "      <td>내사람</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Precious History</td>\n",
       "      <td>2006-11-15</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1615770</td>\n",
       "      <td>아리랑</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>The Sentimental Chord</td>\n",
       "      <td>2007-04-06</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Friday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1854856</td>\n",
       "      <td>라라라</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>My Friend</td>\n",
       "      <td>2008-04-24</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Thursday</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1036</th>\n",
       "      <td>711627</td>\n",
       "      <td>죄와벌</td>\n",
       "      <td>SG 워너비</td>\n",
       "      <td>살다가</td>\n",
       "      <td>2005-03-23</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1040</th>\n",
       "      <td>8130796</td>\n",
       "      <td>상상더하기</td>\n",
       "      <td>라붐 (LABOUM)</td>\n",
       "      <td>Fresh Adventure</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>8235260</td>\n",
       "      <td>비</td>\n",
       "      <td>폴킴</td>\n",
       "      <td>비</td>\n",
       "      <td>2016-06-21</td>\n",
       "      <td>R&amp;B/Soul</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>8252573</td>\n",
       "      <td>아주 NICE</td>\n",
       "      <td>세븐틴</td>\n",
       "      <td>Love&amp;Letter Repackage Album</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>댄스</td>\n",
       "      <td>Monday</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1044</th>\n",
       "      <td>9642570</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>닐로(Nilo)</td>\n",
       "      <td>넋두리</td>\n",
       "      <td>2016-09-12</td>\n",
       "      <td>발라드</td>\n",
       "      <td>Monday</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>850 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      song_id                        song_name       artist_name  \\\n",
       "0       14776  All I Want For Christmas Is You      Mariah Carey   \n",
       "1     1489805                   Must Have Love  SG 워너비, 브라운아이드걸스   \n",
       "2     1500196                              내사람            SG 워너비   \n",
       "3     1615770                              아리랑            SG 워너비   \n",
       "4     1854856                              라라라            SG 워너비   \n",
       "...       ...                              ...               ...   \n",
       "1036   711627                              죄와벌            SG 워너비   \n",
       "1040  8130796                            상상더하기       라붐 (LABOUM)   \n",
       "1041  8235260                                비                폴킴   \n",
       "1042  8252573                          아주 NICE               세븐틴   \n",
       "1044  9642570                              넋두리          닐로(Nilo)   \n",
       "\n",
       "                                        album_name release_date     genre  \\\n",
       "0     Merry Christmas (Deluxe Anniversary Edition)   2019-11-01  R&B/Soul   \n",
       "1                              SG워너비 & 브라운아이드걸스 싱글   2006-11-16  R&B/Soul   \n",
       "2                             The Precious History   2006-11-15  R&B/Soul   \n",
       "3                            The Sentimental Chord   2007-04-06  R&B/Soul   \n",
       "4                                        My Friend   2008-04-24       발라드   \n",
       "...                                            ...          ...       ...   \n",
       "1036                                           살다가   2005-03-23       발라드   \n",
       "1040                               Fresh Adventure   2016-04-06        댄스   \n",
       "1041                                             비   2016-06-21  R&B/Soul   \n",
       "1042                   Love&Letter Repackage Album   2016-07-04        댄스   \n",
       "1044                                           넋두리   2016-09-12       발라드   \n",
       "\n",
       "     day_of_week  month  \n",
       "0         Friday     11  \n",
       "1       Thursday     11  \n",
       "2      Wednesday     11  \n",
       "3         Friday      4  \n",
       "4       Thursday      4  \n",
       "...          ...    ...  \n",
       "1036   Wednesday      3  \n",
       "1040   Wednesday      4  \n",
       "1041     Tuesday      6  \n",
       "1042      Monday      7  \n",
       "1044      Monday      9  \n",
       "\n",
       "[850 rows x 8 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "con1 = df_song_info['genre'] == genre_list[0]\n",
    "con2 = df_song_info['genre'] == genre_list[1]\n",
    "con3 = df_song_info['genre'] == genre_list[2]\n",
    "con4 = df_song_info['genre'] == genre_list[3]\n",
    "\n",
    "\n",
    "df_song_info_genre2 = df_song_info.loc[con1 | con2 | con3 | con4 ]\n",
    "df_song_info_genre2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "01648074",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA3IAAAFxCAYAAAA23JpmAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAkZklEQVR4nO3de5hdVX0//vfKBQIaTYDUnwgBrNwi6aMlChggQbkpUkEQEYGGwheqgPUBgtRCtFgFoZR8uXy9tZbmh5D+uIrlC1QDCSHIJVI0/rio/ZlvSJFbDCCEQCDr98cM0wQmYTLMmTN78no9D8+cvc9eZ3/2eobJeZ+1z1ql1hoAAACaY0i7CwAAAGDdCHIAAAANI8gBAAA0jCAHAADQMIIcAABAwwhyAAAADTOs3QWsyWabbVa33nrrdpcBAADQFj/72c+eqrWO6e65ARvktt5668yfP7/dZQAAALRFKeX/rOk5t1YCAAA0jCAHAADQMIIcAABAwwzY78gBAADNsWLFiixevDjLly9vdymNM2LEiGyxxRYZPnx4j9sIcgAAwJu2ePHijBw5MltvvXVKKe0upzFqrVmyZEkWL16cbbbZpsft3FoJAAC8acuXL8+mm24qxK2jUko23XTTdR7JFOQAAIA+IcT1Tm/6TZADAABoGEEOAABYr9Va213COjPZCQAA0Einn3567rjjjrzjHe/I888/n4suuigzZ87MbbfdllprLrzwwuy8886ZPHlyPvrRj+bmm2/OCy+8kB/96EcZM2ZMdt111+y11155/PHHc9FFF+X444/PY489lo033jgzZszIJpts0u5LXCMjcgAAQOP8+Mc/ztKlS3PnnXfmX//1X/Pkk0/mJz/5SZ5++unMmTMn119/fb7yla90Hf++970vt912Ww477LDMnDkzSfLUU0/lqKOOyve///2ce+65Oeyww3Lrrbfm85//fC699NJ2XVqPGJEDAAAa5z/+4z/ysY99LEmywQYbZPz48fn973+fWbNmZfLkyUmSV155pev4PffcM0my44475p577kmSjBo1KuPGjUuS3HfffZkzZ06mT5+el19+OR/4wAf68WrWnSAHAAA0ztixYzN37twcfPDBWbZsWe66666MGzcuhx12WM4666wkybJly7qOf3VmyFJK13fihg377zi03Xbb5ZBDDskee+yRJHnhhRf661J6RZADAKAxFp09vlftxk5b0MeV0G6HHnpobrjhhuy2224ZO3Zs3v3ud+fTn/50vvnNb2b33XfPyJEjc8wxx+Swww7r0et9+ctfzpQpUzJt2rS89a1vzTnnnJOddtqpxVfRe2WgztAyYcKEOn/+/HaXAQDAACLIDVwPPvhgdtxxx3473yuvvJIhQ4aklJJnnnkme+21V+69994MHTq032roS931XynlZ7XWCd0db0QOAABonCeeeCJHHnlkVq5cmRUrVuTcc89tbIjrDUEOAABonHe+852ZNWtWu8toG8sPAAAANIwgBwAA0DCCHAAAQMMIcgAAAA1jshMAAKDP7Tx1Rp++3s/OP/oNj3nb296WP/3TP83y5cuz6667Zvr06UmSpUuX5lOf+lSeffbZvPe9780///M/r9ZuypQpeeCBB7LBBhtkzJgxueKKK7LRRht1PX/EEUfkggsuyC233JJ/+Zd/ycsvv5y3ve1tufHGG9f5OqZMmZIzzjgjO+ywwzq3XZUROQAAYFAYN25cZs+enbvuuiu/+93v8vOf/zxJcvPNN2e//fbLPffck8WLF2fJkiVZuHBhnnjiia62M2bMyB133JGddtopN910U9f+Rx55JMOHD89b3vKWfO9738usWbMyd+7cXHvttf1+fasS5AAAgEFl+fLleeqpp/JHf/RHSZKJEydm/vz5+eEPf5iddtopm266aa699trceuutq7V75ZVXsnDhwmy//fZd+y699NJ8/vOfz0YbbZQhQ4bkl7/8ZZJkww03TJL87ne/y0EHHZS99toru+22W2655ZYkHSNvDz30UJLkoYceypQpU/r0GgU5AABgUHjggQeyyy675D3veU+++tWv5p3vfGeS5M4778yYMWNyzTXX5D3veU+S5MEHH8x73/verrZHH310xo0bl6effjpbbrllko5AuGDBguyyyy4ZPnx4rrvuunznO9/JMccck//6r/9KkkydOjWnnHJKbrvtttx000350pe+lFpry69VkAMAAAaFcePG5e67785f//Vf54YbbkiSLFq0KNddd10uueSSzJgxI5tttlmmTp2aRx99NOPHj+9qO2PGjDz88MM5+eSTc9pppyVJLr/88nz2s5/tOmazzTbLpZdemrPOOiuHHXZYXnzxxfznf/5n9txzzyTJqFGjstVWW+Wpp55KKaWl1yrIAQAAg8qJJ56Y++67LwsWLMhzzz2XF154oeu5SZMm5frrr88hhxzSbdvNNtsszz//fJLkmmuuyac+9akkyfPPP58lS5YkSd797ndnxIgRefbZZ7Pllltm3rx5SZJnnnkmTzzxRDbbbLNsuummefTRR5Mkv/nNb/r8Gs1aCQAADDoXXnhh/uqv/iq33nprJkyYkL322itDhw7NW9/61sycOTMXXnhhrrnmmq4ZLI8++uhsvPHGGTFiRL797W9n9uzZ+dCHPpThw4cn6QhyBx54YIYNG5bhw4fnz/7szzJmzJhccMEFOeGEE7Js2bIMGzYsF154YUopOf7443Paaadl7ty5WbZsWZ9fX+mP+zd7Y8KECXX+/PntLgMAgAFk0dnj3/igboydtqCPK+G1Hnzwwey4447tLqPPHHHEEZk+fXrXhCmt1l3/lVJ+Vmud0N3xRuQAAABe44orrmh3CWvlO3IAAAANI8gBAAA0jCAHAADQMIIcAABAwwhyAADAoPaFL3zhDY/54Q9/2A+V9B2zVgIAAH2ut0tFrElPlpDYf//9c/PNNydJZs+enbvuuitnnHFGfvWrX3Udc/rpp+e+++5LkixdujQHH3xwzjzzzFx88cX5xCc+sdrrbb/99tlyyy1X2zdmzJhceeWVb/Zy3jRBDgAAGBR+//vf54tf/GKSZPHixZkwoWMJtlpr7rjjjmy77bY577zzuo6fPXt27rjjjjW+3pZbbpmf/OQnLa25twQ5AABgUNhkk03y93//90mSOXPm5N57703SEeQWL16czTffPM8++2xeeumlJMkzzzzTtlrfLEEOAAAYFD784Q/njDPO6No+4IADkiRDhgzJ4YcfniTZe++9s8MOO3Qdc+CBByZJVq5cmYMOOij77LNPTjzxxH6suncEOQAAYFA4/fTTc8UVV2TRokVJkrvvvjt333139t5779WOu+SSS17XdsiQIbn++utX2zd69OhMnjz5dcfedNNN2Wijjfqs7t4Q5AAAgEHjgx/8YMaNG7favpNOOimnnXZat8fXWrNixYpun7vqqqv6vL6+IsgBAACDxiWXXJL7779/tX2/+c1vuh6PGzcun/nMZzJkyJCUUpIkxxxzzGrH//jHP87Xv/71tZ7njDPOyP777983RfeCIAcAAPS5niwX0AoPPfRQZs+evcbnL7room73n3POOV2P99lnn+yzzz59XVqfEuQAAIBBY8WKFa/7TlySTJ8+PTvttFMbKmoNQQ4AABg0Zs2a1at2A3W9uDUZ0soXL6XcV0rZv5SyfSllVillXinl/FaeEwAAYLBrWZArpRya5O2dm9OTHFtrnZhk61LKLq06LwAAwGDXkiBXShmZ5KgkP0jH7Zsjaq0LO5++JslurTgvAADA+qBVI3IXJfm7JCuTjEyyZJXnliQZ3V2jUsrxpZT5pZT5Tz75ZItKAwAA6J2nnnqq3SUkaUGQK6V8NsmiWuu9nbueTjJqlUNGJ+k2pdVav1trnVBrnTBmzJi+Lg0AAFgPLVy4MH/5l3+51mN+8Ytf5Omnn+7aXrp0aRYuXPi644488sjVti+77LI+qHDdtWJE7ogk40opM5McmuRLSd5bSnlX5/OfTNK7qWQAAADW4NRTT83kyZMzefLkrqUG3mjR7gULFuT+++/P9OnTc8stt+T+++/PokWL8vOf/zyXX355kuTOO+/M3nvvnb333jsvv/xy1+NVj+lvfb78QK31gFcfl1K+muSudNxOeXUp5cUkN9RaH+zr8wIAAAPHxIsn9unrzTt53hsec/TRR+fAAw9Mkpx55plJOkbW5s1bve2KFSvy8Y9/PLfccktuu+22LF++PKNGjcqCBQvyyCOPZKeddsqIESO6jv/Qhz6UmTNn5hvf+EYeeeSRbLXVVvmbv/mbjB7d8Y2x5557LhtttFGGDh3aV5f7hlq6/ECt9au11ptrrffWWnertU6utf5DK88JAACsn0499dSuxxdccMEaj7vqqqty6KGHJkn222+/zJkzJ6NGjcqyZcuyYMGC7Lvvvq9rc/LJJ+eoo47KVVddlU9/+tP5whe+kCRZuXJljjvuuPziF7/o46tZOwuCAwAAg8Lb3/723HjjjUmS4cOHZ9iwYRk9enQmTpyYuXPndh33gx/8IFdffXWS5N/+7d/yF3/xFznkkEOSJJ/5zGfy2GOPve61n3vuubzrXR3fFhs7dmyeffbZJMmQIUMyc+bMll5XdwQ5AABgULjmmmtet2+77bbL1ltvnW9/+9tJknvvvTfjx4/PRhttlCSZMmVKTjvttNx00015+eWX8/73vz+bb755fvWrX632Ot/85je7JkwZMmRIzjvvvBZfzdoJcgAAwKAxa9asvPTSS/noRz+aJLnooovy2GOP5fLLL89pp52WSy+9NGeffXbX8Ztuumm++MUv5oUXXsiuu+7atX+LLbbILrvs0rU9bty4nHDCCdlvv/1WO9/UqVNbfEXdE+QAAIBB48knn8zXvva11b4jt3z58uy00055/PHHs2LFiowdO3a1Nr/+9a8zbdq0bL755l37li5dmoMPPjj77LNP175p06bl/PPPX63tggUL8vjjj7foatZMkAMAAAaVqVOnZsqUKV3bCxcuzLnnnptvfetba1xP7pRTTslxxx3XtT179uzccccdqx0zevTo3Hzzzavte6PlDVpFkAMAAPpcT5YLaJXzzz9/tfXdli9fnu233z733HNPvvrVr/aozdNPP901s+Wrli5dmr333nu1fQsWLOi7wteBIAcAAAwahx9+eA4//PB1anPooYe+LrR15+677+5tWX2upevIAQAA0PcEOQAAgIYR5AAAABpGkAMAAGgYQQ4AABj0nnrqqdXWlms6s1YCAAB9bs6ek/r09SbdPqdHx02ZMiUPP/xwNtxwwwwdOjSzZs3K/vvvn3/8x3/sdqmAb33rW0mSz33uc31ab6sJcgAAwKBy1VVXZYsttnjD41auXJlbbrklpZSccMIJGTKkOTcsNqdSAACAXli6dGn+6Z/+abV9y5Yty0knnZRjjz02xx13XD73uc/lD3/4Q5sqXHdG5AAAgEFtww03zPbbb5/f/va3SZKzzz47DzzwQL70pS/l/e9/f5Jk7NixOf7447Pddtvlb//2b9tZbo8IcgAAwKCxzTbb5LjjjsuwYcMydOjQnHXWWdl4442z++675+abb06SnHrqqXnLW96yWrvx48fnyiuvzLJly9pR9joT5AAAgEHjK1/5yhse89oQt6qNN964L8tpGUEOAAAYVH7605/mtttuy5e//OUkyZlnnpktttgil112WWbNmpVzzjlnre1PP/307Lvvvv1Raq8JcgAAQJ/r6XIBrfDKK6/kpZde6trefffdux5/5CMfyUc+8pF2lNWnBDkAAGDQueyyyzJ79uzV9m2yySa59tpr21NQHxPkAACAQWX33XfPwoUL211GS1lHDgAAoGEEOQAAoE/UWttdQiP1pt8EOQAA4E0bMWJElixZIsyto1prlixZkhEjRqxTO9+RAwAA3rQtttgiixcvzpNPPtnuUhpnxIgR2WKLLdapjSAHAAC8acOHD88222zT7jLWG26tBAAAaBhBDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYQQ4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkAAAAGkaQAwAAaBhBDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYQQ4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhhnW7gIAAKDVJl48sVft5p08r48rgb5hRA4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhrH8AAAAsE7m7DlpndtMun1OCypZfxmRAwAAaBhBDgAAoGEEOQAAgIZpyXfkSikbJLkmycgkJckRSd6a5H8lGZHkzlrr1FacGwAAYLBr1WQnLyf5dK11WSnlyCR/nmSPJMfWWheWUq4qpexSa727RecHAAAYtFpya2WtdWWtdVnn5rZJFiQZUWtd2LnvmiS7teLcAAAAg13Llh8opUxNcnySXyX5bpIlqzy9JMmO3bQ5vrNNxo4d2+c1LTp7fK/ajZ22oI8rAQCAvuN97vqnZZOd1FrPr7Vum+SSJP+QZNQqT49O8mQ3bb5ba51Qa50wZsyYVpUGAADQaC0JcqWUkaWU0rm5KMnQJBuWUt7Vue+TSWa14twAAACDXaturdwhyfRSyotJXkhyUpLNklzdue+GWuuDLTo3AADAoNaSIFdrvTfJxNfs/m1McAIAAPCmWRAcAACgYQQ5AACAhhHkAAAAGkaQAwAAaBhBDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYQQ4AAKBhhrW7AADoC3P2nNSrdpNun9PHlQwsvekXfdK9wd4vQLMYkQMAAGgYQQ4AAKBhBDkAAICGEeQAAAAaRpADAABoGLNWAgDAemrixRN71e4bYkTbGZEDAABoGEEOAACgYQQ5AACAhhHkAAAAGkaQAwAAaBhBDgAAoGHMGwr02KKzx/eq3dhpC/q4EgCAtRvs71uMyAEAADSMIAcAANAwghwAAEDDCHIAAAANI8gBAAA0TI+CXCnl3Ndsn92acgAAAHgja11+oJSyXZK9khxUSvn/OnePSHJokmktrg0AAIBuvNE6cs8kWZ6kJnmxc9+yJAe2sigAAADWbK1Brtb6eJJ/KaUsqLXe1081AQAAsBZvNCL3qhGllKuTjE7H9+pqrfXDrSsLAACANelpkPtOkqOTPJiO2ywBAABok54GuUdqrf/R0koAAADokZ4GuV+WUr6e5PZ0jsjVWv+9ZVUBAACwRj0Ncs93/ty182dNIsgBALTIorPH96rd2GkL+rgSYCDqUZCrtf5tqwsBAACgZ3oU5Eopt+U1k5yYtRIAAKA9enpr5f6rPN42yQEtqAUAAIAeGNKTg2qtL67y3y+TbNTiugAAAFiDnt5aue8qm+9K8r6WVAMAAMAb6umtlbt1/qxJliQ5tjXlAAAA8EZ6PGtlKWWTJNsk+XWt9dnWlgWQzNlzUq/aTbp9Th9XsnamCAcA+luPviNXSvlskh8lOSrJ9aWUj7W0KgAAANaop7dWnpRkUq31pVLKBkluTvK/W1cWAAAAa9KjEbkkL9RaX0qSzp89bQcAAEAf62kg+69SypGllFGllM8keaKVRQEAALBmPb218l+TfCjJ4UkeTvL3LasIAACAteppkDu91rrnqxullH9Psu9ajgcAAKBFehrkymu2R/Z1IQAA62LixRN71e4bPX77A6yPevu3Zd7J8/q4krXr6V+yq0splye5Osn+Sea2riQAAADWpqcLgv/PUsoeST6Y5MZa649aWxYAAABr0uN7C2qtc2MkDgAAoO2sBwcAANAwghwAAEDDCHIAAAANY/5dWINFZ4/vVbvPjH5br9r195S1AAA0lxE5AACAhhHkAAAAGkaQAwAAaJiWfEeulDIqybeT/F/pCIt/nmSDJP8ryYgkd9Zap7bi3AAAAINdqyY72TjJKbXWR0spByQ5Lcm7kxxba11YSrmqlLJLrfXuFp0fAABg0GrJrZW11kdrrY92bi5N8mKSEbXWhZ37rkmyWyvODQAAMNi19DtypZR3pWM07oIkS1Z5akmS0d0cf3wpZX4pZf6TTz7ZytIAAAAaq2VBrpTy8STTkvyPJL9PMmqVp0cneV1Sq7V+t9Y6odY6YcyYMa0qDQAAoNFaEuRKKX+S5MBa6wm11iW11heSbNg5Qpckn0wyqxXnBgAAGOxaNdnJ/kn2KKXM7txelOSUJFeXUl5MckOt9cEWnRsAAGBQa0mQq7Wel+S8bp4ywQkAAMCbZEFwAACAhhHkAAAAGqZV35GjQRadPb5X7cZOW9DHlQAAAD1hRA4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhrH8AL028eKJvWo37+R5fVwJAACsX4zIAQAANIwgBwAA0DCCHAAAQMMIcgAAAA0jyAEAADSMWSsBaIlFZ4/vVbux0xb0cSUANNnOU2f0qt11I/u4kAHGiBwAAEDDCHIAAAANI8gBAAA0jCAHAADQMIIcAABAwwhyAAAADWP5AQY9U9a238SLJ/aq3Tf6+U9Uf/+u9LZf5p08r3cnBGCdzdlzUq/aTbp9Th9XAqszIgcAANAwghwAAEDDCHIAAAANI8gBAAA0jCAHAADQMIIcAABAw1h+AAD60aKzx/eq3dhpC/q4EmgvywPBm2NEDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYQQ4AAKBhBDkAAICGsfwADBBz9py0zm0m3T6nBZUw0PXmdyXx+wLri4kXT+xVu3knz+vjSoBWMiIHAADQMIIcAABAwwhyAAAADSPIAQAANIwgBwAA0DCCHAAAQMNYfgAAAAaInafO6FW760b2cSEMeEbkAAAAGkaQAwAAaBhBDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYyw/0wMSLJ/aq3Teu6l33Trp9Tq/aAQwGvf6b6580ANYjRuQAAAAaRpADAABoGEEOAACgYQQ5AACAhhHkAAAAGkaQAwAAaBhzNQNAL+w8dUav2l03snfnsywDAKsyIgcAANAwghwAAEDDCHIAAAAN05IgV0oZU0r5einla53b25dSZpVS5pVSzm/FOQEAANYXrRqRuyDJi0mGd25PT3JsrXVikq1LKbu06LwAAACDXkuCXK316CS3J0kpZViSEbXWhZ1PX5Nkt1acFwAAYH3QH3MSj0myZJXtJUl27O7AUsrxSY5PkrFjx7a+Mtpizp6TetVu0u1z+rgSAABopv6Y7OTpJKNW2R6d5MnuDqy1frfWOqHWOmHMmDH9UBoAAEDztDzI1VpfSLJhKeVdnbs+mWRWq88LAAAwWPXHrZVJckqSq0spLya5odb6YD+dFwAAYNBpWZCrtc5OMrvz8b0xwQkAAECfsCA4AABAwwhyAAAADdNf35EDoKF2njqjV+2uG9nHhQDAANbfS2wZkQMAAGgYQQ4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYSw/AAC01aKzx/eu4ei39W0h67n+njodeHOMyAEAADSMIAcAANAwghwAAEDDCHIAAAANI8gBAAA0jFkrAQBaaOepM3rV7rqRfVwIMKgYkQMAAGgYQQ4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYSw/AOshU2EDreBvC0D/MSIHAADQMIIcAABAwwhyAAAADSPIAQAANIwgBwAA0DCCHAAAQMMIcgAAAA0jyAEAADSMIAcAANAwghwAAEDDCHIAAAANI8gBAAA0jCAHAADQMMPaXUBv7Dx1Rq/aXTeyjwsBAABoAyNyAAAADSPIAQAANIwgBwAA0DCCHAAAQMMIcgAAAA0jyAEAADSMIAcAANAwghwAAEDDCHIAAAANI8gBAAA0jCAHAADQMIIcAABAwwhyAAAADTOs3QXQd3aeOqNX7a4b2ceFAAAALWVEDgAAoGEEOQAAgIYR5AAAABpGkAMAAGgYQQ4AAKBhBDkAAICGEeQAAAAaRpADAABoGEEOAACgYQQ5AACAhunXIFdK+VopZU4pZV4p5b39eW4AAIDBot+CXClljyTvqLVOSnJCkvP769wAAACDSX+OyO2b5MokqbX+Mskm/XhuAACAQaPUWvvnRKV8J8nFnSEupZQ7kuxZa125yjHHJzm+c3P7JA/3S3FvbLMkT7W7iAFIv3RPv7yePumefumefumefnk9fdI9/dI9/dI9/fJ6A6lPtqq1junuiWH9WMQzSUavsr1y1RCXJLXW7yb5bj/W1COllPm11gntrmOg0S/d0y+vp0+6p1+6p1+6p19eT590T790T790T7+8XlP6pD9vrZyb5NAkKaWMS7K4H88NAAAwaPTniNyNST5WSpmb5A/pmPAEAACAddRvQa7zNsrP9df5+tiAu91zgNAv3dMvr6dPuqdfuqdfuqdfXk+fdE+/dE+/dE+/vF4j+qTfJjsBAACgb/TrguAAAAC8eYLcWpRSxpRSvl5K+Vq7axlISimjSikzSymzSym3l1K2aXdN7VZK2aCU8qPOPplTSnlXu2saaEop95VS9m93HQNFKWVB5+/L7FLKEe2uZ6AopXyw8+/KvFLK6e2up91KKSet8nsyu5QyUKbDbrtSyimdf2/nlVLe3+56BopSynmd/fLTUsr72l1Pu7z2PVwpZftSyqzO35fz211fu3T33raUsncp5f5Syoh21tZO3fy+HN75N3d+KeWv213fmvTnZCdNdEGS3yTZuN2FDDAbJzml1vpoKeWAJKclObHNNbXby0k+XWtdVko5MsmfJ/lGm2saMEophyZ5e7vrGGAer7Xu3e4iBpJSyvAk05J8ota6tN31DAS11kuSXJIkpZRDkqz3H5wlHR8oJvmzJJOT/HGSC5Mc2MaSBoTOD8tG1FonlVJ2TMfvzkfaXFa7vPY93PQkx9ZaF5ZSriql7FJrvbtt1bXPav1SSjkoyQeSvNTGmgaC1/6+/KbWOrmUMiTJnaWUf6y1Ptm+8rpnRG4taq1HJ7m93XUMNLXWR2utj3ZuLk3yfDvrGQhqrStrrcs6N7dNsqCd9QwkpZSRSY5K8oN21zLArHzjQ9Y7H03yf5Jc2fnJ+Z+2u6CBovPNxInpDHXklXS8h9kgHQv3Drg3WG0yPsltSVJrfTDJqLZW00arvocrpQxLR8Bd2Pn0NUl2a1NpbfXa97a11utrrX+TZNmaWw1+3fTL/M6fK5MsyQANuoIcvdZ5++Bp6fiUa71XSplaSvl1kglJbm13PQPIRUn+LoJLl1LKW5L8cecthP9PKWXLdtc0QGybZJMkH09ybJJL21vOgPKJJD+utS5vdyEDQa31D+l40/VgkhvSMSJH8oskB5UO2ybZupRS2l3UADAmHW/GX7Ukyeg21UKDlFI+n2RurfWZdtfSHUGOXimlfDwdt0D9j1VG59Zrtdbza63bpuMTc29Ak5RSPptkUa313nbXMpDUWp+vtf5xrXXPJN9Lxy0ddNyi/O+11pc7Pzlf6U1ol79I8k/tLmKg6Lytf3g6bqvcIclFnbfmrtdqrbck+XWS2elY8umuanryJHk6q49Ojo5RXNailDKylPLtJE/UWs9tdz1rIsixzkopf5LkwFrrCbXWJW/YYD3Q+T/8q284FyV5azvrGUCOSDKulDIzyaFJziilbN/mmtqulDJ0lU1vJv7bT9Nxe2VKKe9IssKb0KSUsmk6bgt7ot21DCBbpeN7pjXJs0lGJllvJ2pYVa3172qtk5L8JMld7a5nIKi1vpBkw1UmIvtkklltLImB75Ik/1BrvbrdhayNyU7ojf2T7FFKmd25vajz3uL12Q5JppdSXkzyQpKT2lzPgFBrPeDVx6WUr6bj0+GH21fRgPGeUsr303HP/Uvp+OR8vVdrvaeU8nApZV46RudOaXdNA8Se6Qi5/LfLkny/lDInyYZJvtN5u+V6rTP0/zBJSfKr+NuyqlOSXN357/QNnd8hhDX5eJKtVrkp5Oxa64D72owFwQEAABrGrZUAAAANI8gBAAA0jCAHAADQMIIcAABAwwhyAAAADSPIAcA6KqVsWErZdZVt63UB0K8EOQBYd+9M8sV2FwHA+kuQA2DQK6VsXUr536WU75VSfllKOaCUcnkp5d5Syj+UUoaWUi4ppcwupdxVSjm9s93kzuOuLaUsKKX8VSllaJKZST5cSvn3Vc7xd6WUuaWUOaWUjdp1rQCsHwQ5ANYXf5zkxCR7JrkyyVm11g8k2TvJ55M8UWudnORDSXYvpfxJZ7utknwqyYQkf1lrfSXJ4UlurbXu23nMHyW5sta6R5KfJ3l1PwC0hCAHwPri/lrrS7XW3yd5qNb62879i5K8L8m/JUmtdWWS25Js3/n8nbXWV2qtLyZ5dg2v/VSt9f/tfPxgktGtuAAAeJUgB8D6oq7yeOVrnvvPJPsnSSllSJI9kvyim3avPn4lyYZreL1VjweAlhDkACD5v5NsU0qZm47RuBtrrQ+v5fhHk2xWSrmlX6oDgNcotfrgEAAAoEmMyAEAADSMIAcAANAwghwAAEDDCHIAAAANI8gBAAA0jCAHAADQMIIcAABAwwhyAAAADfP/A3F0r8T7qMEiAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1080x432 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(15,6)) # 그림 크기\n",
    "\n",
    "sns.countplot(x = 'month', hue = 'genre', data = df_song_info_genre2)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "631715c1",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "be3448ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "balad = df_song_info['genre'] == genre_list[0]\n",
    "hiphop = df_song_info['genre'] == genre_list[1]\n",
    "dance = df_song_info['genre'] == genre_list[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "2cb8ab5f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXwAAAETCAYAAAA1Rb1FAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAARGUlEQVR4nO3df4ylVX3H8fdHV1itG3ctoxgirkVErTW2WUVUEH8EUaAipdHyQ2mJgErUUjE2pgYFWyPVIlILiFajBqxLtSgqtCiCIJbV2kJL/VFdsZLKsiJagaXAt3/cZ/Eyzi53d+bcZee8XwmZeX7c8z03y/3MmfM8z5lUFZKkxe8B27oDkqTpMPAlqRMGviR1wsCXpE4Y+NKYJI9K8uwJz905ycrGXZIWjIGv7iQ5J8m+Y9v7Jjln2NwDOGrCpvbfgnOlbW7Jtu6AdH+W5DjguLFdDwc+VFUnbeY1bwZeDayb4/D7quojC9pJaUIGvnp1VpKfD98vAy4fO7Z7kqOAL1bVmcCZGw8M+1dO0P5fDK+V7jec0lGvjq2qVVW1Cjh21rG7gNuHr9Ki4QhfPboFeF+SDcP2jsDFY8e/V1XnwT0j+qPGju0MnDe2/fgkBwL/UVXfa9ZjaQEY+OpOVf3JZg6vBS4Y214JfLiqPryJ8x8BPBm4EdgY+P8L/PEw/z/bhVX1li3pr7RQDHx1KcmLgJPnOLQD8AXuHfqb85Wqeuf4jqo6Azhjfj2UFp6Bry5V1eeBz8/eP9yuecSs3Y9K8iRGn5elwHJGo3hpu2Lgq0tJDgZO4VeDeylwydj2GuAA4DXAHcBtwM+G/bPbXAWcM3v/JhxVVd/cok5L8xSXR1aPkhwBPG5z99NP0MZRwMr5tCFNkyN89ey4YaQ/281V9dxpd0ZqzRG+tJWS7AA8oKpu39Z9kSZh4EtSJ3zSVpI6YeBLUifutxdtd9ppp1q5cuW27oYkbVe+/vWv31RVM3Mdu98G/sqVK1mz5ldudZYkbUaSH2zqmFM6ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUifvtk7aS+vP5T9zUpN0XvWynJu1ubxzhS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ1oGvhJvpFk/yR7JLkkyRVJTm1ZU5I0t2aBn+RQ4GHD5mnA0VX1LGBlkj1b1ZUkza1J4CdZBhwJfBxYAiytqrXD4fOBvVrUlSRtWqsR/unAKcDdwDJg/dix9cCKuV6U5Jgka5KsWbduXaOuSVKfFjzwkxwOXF9VVw+7fgosHztlBTBnmlfV2VW1qqpWzczMLHTXJKlrSxq0eRhwa5LzgCcD+wJ7JNmlqn4EHAK8rUFdSdJmLHjgV9UBG79PchJwFaNpnNVJNgAXVNV1C11XkrR5LUb496iqk8Y2vVArSduQD15JUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4sadFokh2A84FlQIDDgIcC7weWAldW1YktakuS5tYk8IE7gZdV1a1JjgBeCewNHF1Va5N8MsmeVfW1RvUlSbM0mdKpqrur6tZhc3fgGmBpVa0d9p0P7NWitiRpbq1G+CQ5ETgG+DZwNrB+7PB64IlzvOaY4TXsuuuu9+xf9zcfa9LHmVcf0aRdSduHtaf9T5N2V75h5ybtzlezi7ZVdWpV7Q6cAbwHWD52eAWwbo7XnF1Vq6pq1czMTKuuSVKXmgR+kmVJMmxeDzwQ2DHJLsO+Q4BLWtSWJM2t1ZTOE4DTkmwAbgOOB3YCVg/7Lqiq6xrVliTNoUngV9XVwLNm7f4+XqiVpG3GB68kqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I60ewvXun+66yPvrBJu8ceeVGTdqXF4sfv/WqTdh/5+skWIp5ohJ/knbO2374VfZIkbUObHeEneTzwXODgJN8bdi8FDgXe2rhvkqQFdF9TOrcAtwMFbBj23Qoc1LJTkqSFt9nAr6ofAx9Jck1VfWNKfZIkNTDpRdulSVYDKxjN+1dVPa9dtyRJC23SwD8LeAVwHaPpHUnSdmbSwP9hVf1L055IkpqaNPCvTfIO4DKGEX5VXdysV5KkBTdp4P9i+PqM4WsBBr60yL3uUz9s1vbpL310s7Y1t4kCv6re1rojkqS2Jgr8JF9i1sVa79KRpO3LpFM6+499vztwQIO+SJIammgtnaraMPbftcCDG/dLkrTAJp3S2W9scxfgqU16o0XpDz+1/32ftBX+9qVfaNKutFhNOqWzce3NAtYDR7fpjiSplYnv0knycOCxwHeq6mdtuyVJWmiTrod/OPAZ4Ejg00le3LRXkqQFN+mUzvHAc6rqjiQ7AF8APteuW5KkhTbp37S9raruABi++rdwJWk7M2lw/yjJEUmWJ/kD4MaWnZIkLbxJp3Q+ATwTeDnwLeAvm/VIktTEpIH/pqraZ+NGkouB/TZzviTpfmbSwM+s7WUL3ZGeXfTBNjc9vfBor6tL+qVJA391ko8Bqxmtq3N5uy5JklqY9MGr9ybZG3g6cGFVfWZz5ydZDpwJ7MzowvArgR2A9wNLgSur6sR59FuStIUmHeFTVZcz+cj+IcAJVXVDkgOANwK/ARxdVWuTfDLJnlX1tS3vsiRpazS5n76qbqiqG4bNm4ENwNKqWjvsO59frs8jSZqCpg9QJdmF0ej+3YwWXdtoPbBijvOPSbImyZp169a17JokdadZ4Cc5EHgr8CrgJ8DyscMrgF9J9Ko6u6pWVdWqmZmZVl2TpC41CfwkTwEOqqpjq2p9Vd0G7DiM+AEOAS5pUVuSNLeJL9puof2BvZNcOmxfD5zA6PbODcAFVXVdo9qSpDk0CfyqehfwrjkObRcXaq8//dAm7e76utVN2pWkSbjqpSR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdaLV0grSNnHAp05t1vaFL/Vv9mj75ghfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkfvJLm4cDVH2/W9mcPPbxZ2+qTI3xJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpE00CP8lMknckOXnY3iPJJUmuSHJqi5qSpM1rNcJ/N7ABeNCwfRpwdFU9C1iZZM9GdSVJm9Ak8KvqFcBlAEmWAEurau1w+HxgrxZ1JUmbNo05/Blg/dj2emDFXCcmOSbJmiRr1q1bN4WuSVI/phH4PwWWj22vAOZM86o6u6pWVdWqmZmZKXRNkvrRPPCr6jZgxyS7DLsOAS5pXVeSdG9LplTnBGB1kg3ABVV13ZTqSpIGzQK/qi4FLh2+vxov1ErSNuWDV5LUCQNfkjph4EtSJwx8SerEtO7SkbQADl7d7o7mTx/6/GZt6/7BEb4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHViqoGf5OQkX05yRZLfnGZtSerd1AI/yd7AI6vqOcCxwKnTqi1Jmu4Ifz/gXICquhZ4+BRrS1L3UlXTKZScBbxvCHuSfAXYp6ruHjvnGOCYYXMP4FtbUWon4KZ5dtd61lsM9Rbze7Pepj2mqmbmOrBkfv3ZIrcAK8a27x4Pe4CqOhs4ez5FkqypqlXzacN61lsM9Rbze7Pe1pnmlM7lwKEASZ4E/PcUa0tS96Y5wr8QeHGSy4GfM7pwK0makqkF/jB98+oplJrXlJD1rLeI6i3m92a9rTC1i7aSpG3LJ20lqRMGviR1YtEEfpKZJO9IcvKU6i1Pcl6SS5NcluSxjevtkOQzQ70vJ9mlZb2xut9Isv+Ual0zvL9LkxzWuNbTh3+3K5K8qXGt48fe16VJmt/LneSEsWVMfnsK9d411Ptqkqc2qnGvz3iSPZJcMrzHBX9yf65MSfKCJN9MsrR1vSQvH/5/WZPkTxeixjTv0mnt3cB3gYdMqd5DgBOq6oYkBwBvBF7bsN6dwMuq6tYkRwCvBP68YT2SHAo8rGWNWX5cVS9oXSTJg4C3Ai+pqptb16uqM4Azhtq/B7QeHCwHfhfYF9gN+CvgoIb19geWVtVzkjyR0Xt9foNSsz/jpwFHV9XaJJ9MsmdVfa1VvSQHA08D7ljAGpusB3y3qvZN8gDgyiTnVNW6+RRYNCP8qnoFcNkU691QVTcMmzcDv2hc7+6qunXY3B24pmW9JMuAI4GPt6wzy933fcqCeBHwA+DcYYT4O9MoOnxwX8sQ/g3dxeizvQOjpzXnFRIT+C3gSwBVdR2wvEWR8c94kiWMfsisHQ6fD+zVqt6w/emqegtw66ZftaD11gxf7wbWswA/aBZN4G8rw9TKGxmNNlrXOjHJd4BVwBcblzsdOIUphXCSXwN2G6ZZ/i7JoxuW253RWk4HAkcDf92w1riXAP9YVbe3LFJVP2cUHNcBFzAa4bf0b8DBGdkdWJkkjWvOMArBjdZz7yf5F40krwEur6pb5tuWgT8PSQ5kNDXwqrHRfjNVdWpV7c5ohNgspJIcDlxfVVe3qjFbVf2iqnarqn2ADzD69baVO4GLq+rOYYR49xQCCuCPgA+2LjJMMT6I0XTOE4DTh2msJqrqIuA7wKWMnrW5qtrf7/1T7v2bxAra/yYzVUmWJTkTuLGq3rkQbRr4WynJU4CDqurYqlp/ny+Yf71lY6F0PfDQhuUOA56U5DxGy2G8OckeDeuR5IFjm60/uF9lNK1DkkcC/9c6oJL8OqMpiBtb1hk8htH1kAJ+BiwDFvwi47iqOmVY+vyfgKta1hrq3QbsOHbzwiHAJa3rTtkZwHuqavVCNbiYLtpO2/7A3kkuHbavH+bgWnkCcFqSDcBtwPGtClXVARu/T3ISoxHb1qxcuiUel+RDjOYp76DhU9lV9c9JvpXkCkaj/RNa1RqzD6MfNNPwYeBDSb4M7AicNUzzNDH8MPsHIMC3mc4T9TD6d1s9fCYuGK4fLCYHAo8Z++Xz7VU1r6lcn7SVpE44pSNJnTDwJakTBr4kdcLAl6ROGPiS1AkDX1ogSXZM8oyx7eb3o0tbwsCXFs6jgDds605Im2Lgq1tJVib5XJIPJLk2yQFJPpbk6iTvSfLAJGcMS9RetXEZ5ST7Duf9/bCk8+uHJ4XPA56X5OKxGqckuXxYOvjB2+q9SmDgS7sxWsFyH+Bc4M+q6mnAC4DXMFrHZF/gmcCzhyU1YLR8we8zWsjuuKq6C3g58MWq2m845xHAuVW1N/CvwMb90jZh4Kt336yqO6rqJ8B/VtX3h/3XA08FPgv3LFH7JWDjmkJXVtVdVbWB0Xo1c7mpqv59+P46Fulqjtp+GPjq3fjaIrOXgv4vRmsmbVzLfm9GSwHPft3G7+9itHbNXO25hom2OQNf2rSPAo9Ncjmj0f2F97GI3A3ATkkumkrvpC3k4mmS1AlH+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdeL/AfPocR/olRZYAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_song_info_balad = df_song_info.loc[balad]\n",
    "\n",
    "plt.title(\"발라드\")\n",
    "sns.countplot(x = 'month', data = df_song_info_balad)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "f70f7c4a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXwAAAETCAYAAAA1Rb1FAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAASNUlEQVR4nO3de5SdVX3G8e8jESJKm9hMtWVZYxHx0lrsingNUrWAAhUtVusFW6mhKlUXS1x1tdVWpLqg2KhoIVa09YKXUBAvFS0aidc64gUrWrVGbLOKQ7wuiCDw6x/nTT2ME5hMZp+Q7O9nraw5+z3v7N8+C84ze/Z73j2pKiRJe77b7eoBSJImw8CXpE4Y+JLUCQNfkjph4EtzSPLYJJl17OAkS2cdm0qyarKjkxbGwJfm9ipgr1nH1gJ3nXXsfsBJ4weSHJbkzc1GJi3Qkl09AOm2IslrgQcMzWuBDcMk/9qqOnzsvJXAhbO+9wvDw3OBLzUeqrQgBr40qKo/S3IfYA1wN+Bq4K1V9fFZ520CDk7yW8BxwH7AZcB5VfXTJIdNctzSfLmkIw2SLAcuAN4BHM9oCeeMJA+Y49xDgbOBS4F/Bu4FvGXslKOTTCf5jdbjlubLGb70M78AbAUuq6qfAl9Nsgn4VeDzs849AlhbVR8e2pcN527zvqr6o7bDlXaMgS8NqurbSV4HfDjJVmApoxn8B+Y4/UJgXZIlwPeAY4GLJzRUaUHiXjrSzSW5F/DNqrpx1vGDga9W1U+G9krgGOBOwOer6oPD8YOAh1bVmyY5bunWuIYv/by3M7oQO9tabv6xzEOAFVX1im1hP1gBPLzd8KSFcUlHmtvGJDfOOnbPWe3bAc9KctSs43cCPt1sZNICGfjS3FZX1Q/GDyTZMMd551bVX8467+HAn7QbmrQwBr40t/nM8AGemeTIWcec4es2yYu2ktQJL9pKUicMfEnqhIEvSZ24zV60XbFiRa1cuXJXD0OSdiuf+9znrq6qqbmeu80G/sqVK5ment7Vw5Ck3UqSb2/vOZd0JKkTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpE7fZO20l9edf33l1k34f86QVTfrd3TjDl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekTjS50zbJ3sD5wH5AgKcAdwJeDywFPllVp7SoLUmaW6utFW4AnlRV1yZ5GvAMYDVwQlVtSvLuJA+qqs80qi9JmqXJkk5V3VRV1w7NA4HLgaVVtWk4dj7wkBa1JUlza7aGn+SUJF8HVgGXAVvGnt4CLJ/je9YkmU4yPTMz02poktSlZoFfVWdU1YHAWcCrgGVjTy8Hfi7Rq2pdVa2qqlVTU1OthiZJXWoS+En2S5KheSWwF7BPkv2HY08ALmlRW5I0t1YXbe8NrE1yHbAVOAlYAawfjl1UVVc0qi1JmkOTwK+qzwIPm3X4W3ihVpJ2GW+8kqROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdaLUfviTd5m1a+79N+l35grs26XdnOcOXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6RONLnTNsky4Gzgrox+qDwDeDjwYuC7wPVVdXiL2pKkubXaWmFf4OSq2pzkKOCFwFeBF1fVexrVlCTdgiZLOlW1uao2D83vA9cAy4bHkqRdoOkafpL9Gc3u1zL6beL0JBuTrNnO+WuSTCeZnpmZaTk0SepOs8BPcjTwEuBZw4z/pVX1YOAI4IlJ7jf7e6pqXVWtqqpVU1NTrYYmSV1qddH2/sAxVXXi2LElVXUDsBX4MVAtakuS5tbqou2RwOokG4b2lcBVSQ4Zal5QVV9pVFuSNIcmgV9VpwOnt+hbkrQw3nglSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjrRaj98SQ0cu/6SZn1feNyjmvWtkate/akm/d7l+Q+Z13nO8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1In/FjmbcDFb3xsk36POOEDTfqVtHtyhi9JnTDwJakTBr4kdaLJGn6SZcDZwF0Z/VB5BrA38HpgKfDJqjqlRW1J0txaXbTdFzi5qjYnOQp4IfDrwAlVtSnJu5M8qKo+06i+JGmWJks6VbW5qjYPze8D1wFLq2rTcOx84Od2+0myJsl0kumZmZkWQ5OkbjVdw0+yP6PZ/ZnAlrGntgDLZ59fVeuqalVVrZqammo5NEnqTrPP4Sc5GjgGeBZwLbBs7OnlgFN4SZqgJjP8JPcHjqmqE6tqS1VtBfYZZvwATwDabewtSfo5rWb4RwKrk2wY2lcCJwPrk1wHXFRVVzSqLUmaQ5PAr6rTgdPneGp+f5ZFkrTovPFKkjph4EtSJwx8SeqEgS9JnTDwJakT8wr8JK+c1X5Zm+FIklq5xY9lJrkX8DvAsUn+azi8FDgOeEnjsUmSFtGtfQ7/h8BPgGK0ARqMtkk4puWgdrUrX3Nck35/7Xnrm/QrSfNxi4FfVVcB/5Tk8qq6bEJjkiQ1MN87bZcmWc9o07PbAVVVj2w3LEnSYptv4J8DHA9cwWh5R5K0m5lv4H+nqj7fdCSSpKbmG/hfTnIacCnDDL+qPtRsVJKkRTffwL9m+Prg4WsBBr4k7UbmFfhV9TetByJJamtegZ/ko8y6WOundCRp9zLfJZ0jxx4fCBzVYCySpIbmtZdOVV039u/LwB0aj0uStMjmu6Rz+Fhzf+DgJqORJDUz3yWdbX+LtoAtwAlthiNJamXen9JJcmfgHsDXq+pHbYells55yxFN+j3x6RfPefyPLzhyzuM7602P/2CTfqU91Xz3w38q8F7g6cCFSR7bdFSSpEU33yWdk4BHVNX1SfYGPgh8oN2wJEmLbb5/4nBrVV0PMHz1TyNK0m5mvsH9P0melmRZkj8EvntLJyeZSnJaklOH9tOTfCXJhiRuySBJu8B8l3TeCTwUeDLwNeDvbuX8M4FvAPsO7WXAi6vqPQsYoyRpEcw38F9UVYduawyz9MO3d3JVHZ/kMH52h+4y4IsLG6IkaTHMd0kns9r77WCdJcDpSTYmWbPdIsmaJNNJpmdmZnawhCTplsw38NcneWuSY5OcDWzckSJV9dKqejBwBPDEJPfbznnrqmpVVa2amprakRKSpFsx3xuvXp1kNXAI8P6qeu+OFEmypKpuALYCP8Y/kyhJEzffNXyqaiM7OLMf84okhwz1LqiqryywH0nSAs078HdUVW0ANgyPT2lVR5I0P95AJUmdaDbDl7T7e94F32nW92sef7dmfWtuzvAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1IndYvO0mX94a5N+p579tCb9atc56oIzmvX9/se7y7d2b87wJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUid2i49lSrdVR69/W7O+33fcU5v1rT45w5ekThj4ktSJJoGfZCrJaUlOHdoHJbkkySeStLsVUpK0Xa1m+GcC1wG3H9prgROq6mHAyiQPalRXkrQdTQK/qo4HLgVIsgRYWlWbhqfPBx7Soq4kafsmsYY/BWwZa28Bls91YpI1SaaTTM/MzExgaJLUj0kE/g+AZWPt5cCcaV5V66pqVVWtmpqamsDQJKkfzQO/qrYC+yTZfzj0BOCS1nUlSTc3qRuvTgbWJ7kOuKiqrphQXUnSoFngV9UGYMPw+LN4oVaSdilvvJKkThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekTiyZZLEklwNbhua6qnr7JOtLUs8mGvjAVVX16AnXlCQx+SWdm27pySRrkkwnmZ6ZmZnUmCSpCxML/CR3BA5IcmmSdyW52+xzqmpdVa2qqlVTU1OTGpokdWFiSzpVdQ1wAECS3wXOBP5gUvUlqXeTnOHvNdZ0vUaSJmySF23vmeRc4Prh37MnWFuSujfJJZ2vAQ+bVD1J0s1545UkdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTEw38JKcm+ViSTyS53yRrS1LvJhb4SVYDd6mqRwAnAmdMqrYkabIz/MOB8wCq6svAnSdYW5K6l6qaTKHkHOC1Q9iT5OPAoVV109g5a4A1Q/Mg4GsLKLUCuHonh2s96+0J9fbk12a97bt7VU3N9cSSnRvPDvkhsHysfdN42ANU1Tpg3c4USTJdVat2pg/rWW9PqLcnvzbrLcwkl3Q2AscBJLkv8N8TrC1J3ZvkDP/9wGOTbAR+zOjCrSRpQiYW+MPyzbMnUGqnloSsZ709qN6e/NqstwATu2grSdq1vNNWkjph4EtSJ/aYwE8yleS0JKdOqN6yJO9IsiHJpUnu0bje3kneO9T7WJL9W9Ybq3tZkiMnVOvy4fVtSPKUxrUOGf67fSLJixrXOmnsdW1I0vyz3ElOHtvG5AETqHf6UO9TSQ5uVONm7/EkByW5ZHiNi37n/lyZkuTRSb6QZGnrekmePPz/Mp3kxYtRY5Kf0mntTOAbwL4TqrcvcHJVbU5yFPBC4LkN690APKmqrk3yNOAZwN82rEeS44BfbFljlquq6tGtiyS5PfAS4HFV9f3W9arqLOCsofbvA60nB8uA3wMOAw4A/h44pmG9I4GlVfWIJPdh9Fof1aDU7Pf4WuCEqtqU5N1JHlRVn2lVL8mxwAOB6xexxnbrAd+oqsOS3A74ZJJ/rKqZnSmwx8zwq+p44NIJ1ttcVZuH5veBaxrXu6mqrh2aBwKXt6yXZD/g6cDbWtaZ5aZbP2VRPAb4NnDeMEP87UkUHd64z2UI/4ZuZPTe3pvR3Zo7FRLz8JvARwGq6gpgWYsi4+/xJEsY/ZDZNDx9PvCQVvWG9oVV9RfAtdv/rkWtNz18vQnYwiL8oNljAn9XGZZWXshottG61ilJvg6sAj7SuNxrgJczoRBOckfggGGZ5V1J7taw3IGM9nI6GjgBeF3DWuMeB3y4qn7SskhV/ZhRcFwBXMRoht/Sl4BjM3IgsDJJGtecYhSC22zh5nfy7zGSPAfYWFU/3Nm+DPydkORoRksDzxqb7TdTVWdU1YGMZojNQirJU4Erq+qzrWrMVlXXVNUBVXUo8AZGv962cgPwoaq6YZgh3jSBgAJ4JvDG1kWGJcbbM1rOuTfwmmEZq4mquhj4OrCB0b02n672n/f+ATf/TWI57X+Tmagk+yU5G/huVb1yMfo08Bcoyf2BY6rqxKracqvfsPP19hsLpSuBOzUs9xTgvknewWg7jD9PclDDeiTZa6zZ+o37KUbLOiS5C/DT1gGV5JcYLUF8t2Wdwd0ZXQ8p4EfAfsCiX2QcV1UvH7Y+/zfg0y1rDfW2AvuMfXjhCcAlretO2FnAq6pq/WJ1uCddtJ20I4HVSTYM7SuHNbhW7g2sTXIdsBU4qVWhqjpq2+Mkf81oxraQnUt3xD2TnMtonfJ6Gt6VXVX/nuRrST7BaLZ/cqtaYw5l9INmEt4MnJvkY8A+wDnDMk8Tww+z9wAB/pPJ3FEPo/9u64f3xEXD9YM9ydHA3cd++XxZVe3UUq532kpSJ1zSkaROGPiS1AkDX5I6YeBLUicMfEnqhIEvLZIk+yR58Fi7+efRpR1h4EuL51eAF+zqQUjbY+CrW0lWJvlAkjck+XKSo5K8Nclnk7wqyV5Jzhq2qP30tm2Ukxw2nPcvw5bOzx/uFH4H8MgkHxqr8fIkG4etg++wq16rBAa+dACjHSwPBc4D/qqqHgg8GngOo31MDgMeCjx82FIDRtsXPJHRRnZ/WlU3Ak8GPlJVhw/n/DJwXlWtBr4IbDsu7RIGvnr3haq6vqq+B3y1qr41HL8SOBh4H/z/FrUfBbbtKfTJqrqxqq5jtF/NXK6uqv8YHl/BHrqbo3YfBr56N763yOytoL/JaM+kbXvZr2a0FfDs79v2+EZGe9fM1Z97mGiXM/Cl7XsLcI8kGxnN7t9/K5vIbQZWJLl4IqOTdpCbp0lSJ5zhS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUif8DPuHmr+I7H+QAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_song_info_hiphop = df_song_info.loc[hiphop]\n",
    "\n",
    "plt.title(\"힙합\")\n",
    "sns.countplot(x = 'month', data = df_song_info_hiphop)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "b5436421",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXwAAAETCAYAAAA1Rb1FAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAARyklEQVR4nO3dfZBkVX3G8e8jCCtKZVEmmqLENUhErVgkNaJEQWMIooBvwWhUfAnlEl9KLSKWVhJNRIwFYtAQo+tbUmp8W4KCGjWiKxt8iaNiIKLRxBWTLXFcUSlYWYFf/ui7yTDO7vbuzOlh53w/VVvT5/bt+ztd0M+cObfvuakqJEkr3x2WuwOSpMkw8CWpEwa+JHXCwJekThj40piSrEqy33L3Q9pTBr60C0k+lWQN8DLgqcvcHWmPGfjSIMmzknw/yRXDv0/txmv/NMkft+yftFgGvnRbb66qI4d/x+3G6x4KPLxVp6SlYOBL45kGDp2/MckdkrwWWA98JMlrkuwz8d5JYzDwpfEcDxyxvZFkvySPBj4CXFlVb6+qdcAVwCVJHptk1fJ0VVrYvsvdAel25jFJDgbuCNwJeN2w/TXAs+bsdyqjEf+zq+ra7Rur6gNJLgWeB9wNeOckOi2Nw8CX/t/FwFeBW4BtwFbg+wvtWFVv39FBqmoLcFaLDkqL4ZSONKiqH1XV14AHAN+vqu9V1c+BS4Drl7d30uLF1TKl20qyAXhWVW3awfPTwNvGPNyzquqKpemZtDhO6Ui7qapmgCOXux/S7jLwpYV9LMm2BbZfXlXPn3hvpCXglI4kdcKTtpLUCQNfkjph4EtSJ263J20PPvjgWrNmzXJ3Q5L2Kl/+8pd/WFVTCz13uw38NWvWMDMzs9zdkKS9SpLv7ug5p3QkqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTt9srbSWptU3nL3jL4kVb8+J7NDnuYjnCl6ROGPiS1AkDX5I60WQOP8l+wIXAgUCApwJ3Ad4ErAI+V1VntqgtSVpYq5O2NwNPrqobkzwdeCZwDHBaVW1K8sEkD66qLzaqL0map8mUTlXdWlU3Ds3DgSuBVVW1adh2IXD0/NclWZtkJsnM7Oxsi65JUreazeEnOTPJt4Bp4CvAljlPbwEOmv+aqlpXVdNVNT01teANWyRJe6hZ4FfVuVV1OHAB8Hpg9ZynDwIcwkvSBDUJ/CQHJsnQvAbYB9g/ySHDticCl7aoLUlaWKuTtkcA5ye5CdgKvAA4GFg/bLu4qq5uVFuStIAmgV9VXwIeOm/zd1jgRK0kaTK88EqSOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCe9pqxXlxIvObXbsjz7hF2/hcNL69zSr95FTnvYL2x6/vt2KJB865XeaHVu3D47wJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdaHIDlCSrgTcD92D0S+WZwMOAlwM/ALZV1fEtakuSFtbqjlcHAGdU1eYkJwIvAb4BvLyqPtyopiRpJ5pM6VTV5qraPDSvA24AVg+PJUnLoOkcfpJDGI3uz2f018Q5STYmWbuD/dcmmUkyMzs727JrktSdZoGf5CTgFcBzhhH/K6vqIcCjgCclecD811TVuqqarqrpqampVl2TpC61Omn7QODkqjp9zrZ9q+pmYCtwPVAtakuSFtbqpO0JwDFJNgzta4Brkxw11Lyoqr7eqLYkaQFNAr+qzgHOaXFsSdKe8cIrSeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUidaXWmr27G3vOtRTY57+qmfaHJcSUvDEb4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1oskdr5KsBt4M3IPRL5VnAvsBbwJWAZ+rqjNb1JYkLazVLQ4PAM6oqs1JTgReAvwqcFpVbUrywSQPrqovNqovSZqnyZROVW2uqs1D8zrgJmBVVW0atl0IHD3/dUnWJplJMjM7O9uia5LUraZz+EkOYTS6Pw/YMuepLcBB8/evqnVVNV1V01NTUy27JkndaTWlQ5KTgJOB5wA3AqvnPH0Q4BBekiaoyQg/yQOBk6vq9KraUlVbgf2HET/AE4FLW9SWJC2s1Qj/BOCYJBuG9jXAGcD6JDcBF1fV1Y1qS5IW0CTwq+oc4JwFnvqFE7WSpMnwwitJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SerEWIGf5LXz2q9q0x1JUis7XVohya8Bvw08Psl/DZtXAacAr2jcN0nSEtrVWjo/AX4GFKObmMBoqeOTW3ZKkrT0dhr4VXUt8PdJrqyqr0yoT5KkBsZdLXNVkvWMblxyB6Cq6pHtuiVJWmrjBv5bgGcAVzOa3pEk7WXGDfzvVdVXm/ZEktTUuIF/VZKzgcsYRvhV9clmvZIkLblxA/+G4edDhp8FGPiStBcZK/Cr6i9ad0SS1NZYgZ/kM8w7Weu3dCRp7zLulM4Jcx4fDpzYoC+SpIbGndK5aU7zqiSnNOqPpI790/t/2OS4j37ywU2Ou7cZd0rn+DnNQ4Ajm/RGktTMuFM6Rw8/C9gCnNamO5KkVsb+lk6SuwL3Br5VVT9t2y1J0lIbdz38pwGXAKcCH0rymF3sP5Xk7CRnDe1Tk3w9yYYkfn9fkpbBuFM6LwAeXlXbkuwHfBz42E72Pw/4NnDA0F4NvLyqPrynHZUkLc64tzjcWlXbAIafO31dVT2D0TIM260GrtuTDkqSlsa4gf8/SZ6eZHWSPwB+sJt19gXOSbIxydod7ZRkbZKZJDOzs7O7WUKStDPjBv77gfsD7wamgdftTpGqemVVPQR4FPCkJA/YwX7rqmq6qqanpqZ2p4QkaRfGncN/aVUdu70xnHg9fif730aSfavqZmArcD2uqS9JEzdu4Gde+8DdrPOXSY4a6l1UVV/fzddLkhZp3MBfn+TdwHpG6+ps3NULqmoDsGF4fOYe9k+StETGvfDqDUmOAY4CPlpVl7TtliRpqY07wqeqNjLGyF677xNv3+l1bHvsUaft7FKJyXn2RSfseqc98M4nfLzJcaWVatxv6UiS9nIGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6MfZqmctp9m/f3eS4U899epPjStLtkSN8SeqEgS9JnTDwJakTBr4kdcLAl6ROGPiS1AkDX5I6YeBLUicMfEnqRJPATzKV5OwkZw3t+ya5NMnlSc5tUVOStHOtRvjnATcBdxza5wOnVdVDgTVJHtyoriRpB5oEflU9A7gMIMm+wKqq2jQ8fSFwdIu6kqQdm8TiaVPAljntLcD9FtoxyVpgLcChhx7avmc7cM0bT2ly3ENfuL7JcSVpHJM4aftjYPWc9kHA7EI7VtW6qpququmpqakJdE2S+tE88KtqK7B/kkOGTU8ELm1dV5J0W5NaD/8MYH2Sm4CLq+rqCdWVJA2aBX5VbQA2DI+/hCdqJWlZeeGVJHXCwJekTuwV97SVpJXg2jd8vslx7/6i8WbMHeFLUicMfEnqhIEvSZ0w8CWpEwa+JHXCb+lI2qEXXvS9Zsd+4xPu2ezYWpgjfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SerERO94leRKYMvQXFdV/zDJ+pLUs0nf4vDaqjpuwjUlSUx+SufWnT2ZZG2SmSQzs7Ozk+qTJHVhYoGf5M7AYUkuS/KBJL9wB+OqWldV01U1PTU1NamuSVIXJjalU1U3AIcBJPld4Dzg9ydVX5J6N8kR/j5zms7XSNKETfKk7X2SvAPYNvx77gRrS1L3Jjml803goZOqJ0m6LS+8kqROGPiS1AkDX5I6YeBLUicMfEnqhIEvSZ0w8CWpEwa+JHXCwJekThj4ktQJA1+SOmHgS1InDHxJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjph4EtSJwx8SeqEgS9JnTDwJakTBr4kdcLAl6ROTDTwk5yV5LNJLk/ygEnWlqTeTSzwkxwD3L2qHg6cDpw7qdqSpMmO8I8H3gtQVVcBd51gbUnqXqpqMoWStwB/PYQ9Sf4FOLaqbp2zz1pg7dC8L/DNPSh1MPDDRXbXetZbCfVW8nuz3o7dq6qmFnpi38X1Z7f8BDhoTvvWuWEPUFXrgHWLKZJkpqqmF3MM61lvJdRbye/NentmklM6G4FTAJLcH/jvCdaWpO5NcoT/UeAxSTYC1zM6cStJmpCJBf4wffPcCZRa1JSQ9ay3guqt5PdmvT0wsZO2kqTl5ZW2ktQJA1+SOrFiAj/JVJKzk5w1oXqrk7wvyYYklyW5d+N6+yW5ZKj32SSHtKw3p+5XkpwwoVpXDu9vQ5KnNq511PDf7fIkL21c6wVz3teGJM2/y53kjDnLmPzGBOqdM9T7fJIjG9W4zWc8yX2TXDq8xyW/cn+hTElyXJIrkqxqXS/JU4b/X2aSvHwpakzyWzqtnQd8GzhgQvUOAM6oqs1JTgReAjy/Yb2bgSdX1Y1Jng48E3hNw3okOQX4pZY15rm2qo5rXSTJHYFXAI+rquta16uqC4ALhtq/B7QeHKwGHgs8AjgM+Cvg5Ib1TgBWVdXDk9yP0Xv9nQal5n/GzwdOq6pNST6Y5MFV9cVW9ZI8HngQsG0Ja+ywHvDtqnpEkjsAn0vytqqaXUyBFTPCr6pnAJdNsN7mqto8NK8Dbmhc79aqunFoHg5c2bJekgOBU4H3tKwzz6273mVJPBr4LvDeYYT4m5MoOnxwn88Q/g3dwuizvR+jqzUXFRJj+HXgMwBVdTWwukWRuZ/xJPsy+iWzaXj6QuDoVvWG9oeq6k+AG3f8qiWtNzP8vBXYwhL8olkxgb9chqmVlzAabbSudWaSbwHTwKcbl3sj8GomFMJJ7gwcNkyzfCDJPRuWO5zRWk4nAacBf9Ow1lyPA/65qn7WskhVXc8oOK4GLmY0wm/p34DHZ+RwYE2SNK45xSgEt9vCba/kXzGSPA/YWFU/WeyxDPxFSHISo6mB58wZ7TdTVedW1eGMRojNQirJ04BrqupLrWrMV1U3VNVhVXUs8FZGf962cjPwyaq6eRgh3jqBgAL4Q+DtrYsMU4x3ZDSdcwTwxmEaq4mq+gTwLWADo2ttvlDtv+/9Y277l8RBtP9LZqKSHJjkzcAPquq1S3FMA38PJXkgcHJVnV5VW3b5gsXXO3BOKF0D3KVhuacC90/yPkbLYbwsyX0b1iPJPnOarT+4n2c0rUOSuwM/bx1QSe7GaAriBy3rDO7F6HxIAT8FDgSW/CTjXFX16mHp808BX2hZa6i3Fdh/zpcXnghc2rruhF0AvL6q1i/VAVfSSdtJOwE4JsmGoX3NMAfXyhHA+UluArYCL2hVqKpO3P44yZ8zGrHtycqlu+M+Sd7BaJ5yGw2vyq6qf03yzSSXMxrtn9Gq1hzHMvpFMwl/B7wjyWeB/YG3DNM8TQy/zD4MBPgPJnNFPYz+u60fPhMXD+cPVpKTgHvN+ePzVVW1qKlcr7SVpE44pSNJnTDwJakTBr4kdcLAl6ROGPiS1AkDX1oiSfZP8pA57ebfR5d2h4EvLZ1fAV683J2QdsTAV7eSrEnysSRvTXJVkhOTvDvJl5K8Psk+SS4Ylqj9wvZllJM8YtjvH4clnV80XCn8PuCRST45p8ark2wclg6+03K9VwkMfOkwRitYHgu8F/izqnoQcBzwPEbrmDwC+C3gYcOSGjBavuBJjBay+6OqugV4CvDpqjp+2OeXgfdW1THA14Dt26VlYeCrd1dU1baq+hHwjar6zrD9GuBI4CPwf0vUfgbYvqbQ56rqlqq6idF6NQv5YVX9+/D4alboao7aexj46t3ctUXmLwX9n4zWTNq+lv0xjJYCnv+67Y9vYbR2zULHcw0TLTsDX9qxdwH3TrKR0ej+o7tYRG4zcHCST0ykd9JucvE0SeqEI3xJ6oSBL0mdMPAlqRMGviR1wsCXpE4Y+JLUCQNfkjrxv5qKxIWypUV4AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_song_info_dance = df_song_info.loc[dance]\n",
    "\n",
    "plt.title(\"댄스\")\n",
    "sns.countplot(x = 'month', data = df_song_info_dance)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2c45ad23",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "59f70227",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYEAAAETCAYAAADQ97psAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAATKklEQVR4nO3dfbBcd13H8fcH+hDQjEntpWoHGyy1WHxAJ7ZWTVuRKaVpaalhQB6KGkkFGcUMZUQHBig4DLVQa1UaBXUoU5BUMFAeKpG0MTxesEo1VlBDwY5wm0KptKS2+frHnqvbeG+zSe45N8nv/ZrJ3D1nz/6+351297PnnD2/TVUhSWrTIxa7AUnS4jEEJKlhhoAkNcwQkKSGGQLSAUry6H3YdkWS7+6zH2lfGALSXiR5c5JbktyW5Ovd7VuSfE+3yT/N8ZiPJHn82PJvJXkW8AvA6mE6l/buiMVuQDrYVdVvACT5SeCVVfW0+bZNshZYCjwW+IUkdwJ/BRwFHDlAu9I+MQSkyf0g8CNJHgk8GbigW3/M2DYzwDeB+4C7gP8Edg3ZpLQvDAFpcr8MfAp4AfBR4P3d+mfOblBVmwCSvBC4sapu7ZaH7VSakCEgTSDJy4CtwGuBm4DPVNWHuvvum+Mh3wc8vjuEtA74HuDlA7UrTcwTw9LDyMiljE7m/lZV3Q2sAa5Ncuo8j/kxRucALq6qDVW1EtgwWNPSPjAEpIdRo8m17gLOr6pd3bovAD8NTM/zsNcwOnS0LMlTB2lU2k+GgLQXVfXWqvqvJNeNrbu7qnbvuW2SVwD/VVUfZHTu4MokZw7YrrRPDAFpcqvmWllVKwCSLGH0TaEXduu/BDwd+JeB+pP2mSeGpQVSVd8CLt1j3efBbwfp4GUISJM7Ksl85wFeWlV/O2g30gKIPyojDac7ZLS7qu5f7F4kMAQkqWmeGJakhhkCktSwQ+7E8LHHHlsrVqxY7DYk6ZDymc985s6qmtpz/SEXAitWrGB6er4vaEiS5pLki3Ot93CQJDXMEJCkhhkCktQwQ0CSGmYISFLDDAFJapghIEkNMwQkqWGGgCQ17JC7YliS+rTjyv/sbewVL/2u3sbeX+4JSFLDDAFJapghIEkNMwQkqWGGgCQ1zG8HSTroffBdd/Yy7tOedWwv4x5K3BOQpIYZApLUMENAkhpmCEhSwwwBSWpYLyGQZCrJ65Nc1i0/O8mWJNNJXjG23WVJbkqyLckT++hFkjS/vvYErgB2AUd2y1+oqrOAU4ELupBYBRxXVWcClwCX99SLJGkevYRAVV0M3Dy2PN393Q3sBO4Hzgau69bfChwz33hJ1nV7EdMzMzN9tCxJTRr0nECSFwNbq+pu4DHA+Dv6A0nm7KeqNlTVyqpaOTU1NUSrktSEQUIgydIkbwG+WlVv6FbfDSwf22x3t6cgSRrIUHsCVwNvqqqNY+u2AmsAkpwCfHmgXiRJnaHmDjoPOCHJ7PJrgRuAc5NsBe5hdHJYkjSg3kKgqrYAW7rb3znPZi/qq74kae+8WEySGmYISFLDDAFJapghIEkNMwQkqWGGgCQ1zBCQpIYZApLUMENAkhpmCEhSwwwBSWqYISBJDTMEJKlhhoAkNcwQkKSGGQKS1DBDQJIaZghIUsMMAUlqmCEgSQ3r7YfmdWA+/NZzexv7qWs/0NvYkg4t7glIUsMMAUlqmCEgSQ3rJQSSTCV5fZLLuuWTk2xOsi3J5WPbXZbkpm79E/voRZI0v772BK4AdgFHdstXAmur6qeAFUlOS7IKOK6qzgQuAS6fcyRJUm96CYGquhi4GSDJEcCSqtrR3X09cDpwNnBdt/2twDHzjZdkXZLpJNMzMzN9tCxJTRrinMAUsHNseSewHHgMMP6O/kCSOfupqg1VtbKqVk5NTfXXqSQ1ZojrBL4OLBtbXs7ozf9R3e1Zu6tq9wD9SJI6ve8JVNV9wNFJju9WXQRsBrYCawCSnAJ8ue9eJEkPNdQVw+uBjUl2AZuqanuS24Bzk2wF7mF0cliSNKDeQqCqtgBbutufZnQyePz+3cCL+qovSdo7LxaTpIYZApLUMENAkhpmCEhSwwwBSWqYISBJDTMEJKlhhoAkNcwQkKSGGQKS1LCh5g6SHuIX33NOL+P+6TM+1Mu40uHKPQFJapghIEkNMwQkqWGGgCQ1zBCQpIYZApLUMENAkhpmCEhSwwwBSWqYISBJDTMEJKlhzh0kAK55+1N7G/uS53+4t7ElHRhDQE1Y/Z7Lexn3hmdc2su40lAGPRyUZH2Sm5JsS/KjSU5Osrlb7udVKkma12B7AkmWAU8HzgJOBN7c1V9bVTuSvDvJaVX1yaF6kqTWDbkn8GBX7yjgWGAGWFJVO7r7rwdOn+uBSdYlmU4yPTMzM0SvktSEwUKgqu4Bbga2A5uAPwV2jm2yE1g+z2M3VNXKqlo5NTXVe6+S1IohDwetBo5kdChoOaNP/rvHNlnOaO9gIjN/dO2C9jdu6kXP621sSTqYDHk46ATgK1VVwDeApcAxSY7v7r8I2DxgP5LUvCG/IvpnwNuS3AQcDVwD3AJsTLIL2FRV2wfsR5IW3Vd+7+O9jX3cr895mvUhBguBqroXePYcd+29S0kHlV97z5d6GfeqZzy2l3E1P6eNkKSGGQKS1DBDQJIaZghIUsMmOjGc5A1V9Ztjy6+tqlf115Z0aDtv4zt6Gff9a57by7hq18OGQJLvB34GuDDJv3WrlwBrAENAkg5xe9sTuBv4FlDArm7dvcD5fTYlad9cuLGf6yzfu+ZnexlXB4+HDYGq+grw50k+V1WfHagnSdJAJr1YbEmSjYzm93kEUFX15P7akiQNYdIQuAa4mNEMoNVfO5KkIU0aAl+qqr/rtRNJ0uAmDYFbk7ye0e8BFEBV3dhbV5KkQUwaAt/s/v5E97cAQ0CSDnEThUBVvabvRiRJw5v0iuGPsscJYb8dJEmHvkkPB50zdvskYHUPvUiSBjbRBHJVtWvs363Ao3ruS5I0gEkPB509tng88KReupEkDWrSw0GzPwFZwE5gbT/tSJKGNPG3g5IcAzwO+HxVfaPftiRJQ5jonECS5wLvA54PvDfJub12JUkaxKSHg14CnFlV9yc5CvgQ8IH+2pIkDWHSn5e8r6ruB+j++rOUknQYmPTN/D+SPC/JsiQ/D3y1z6YkScOYNATeBZwCXAusBH53f4olOTXJzUm2JXl5kpOTbO6WL9+fMSVJ+2/ScwIvr6ozZheS3Aic/TDb/z9JjmT0u8QXVNXXunUfBNZW1Y4k705yWlV9cl/GlSTtv0n3BLLH8tL9qPU04IvAdd2n/1OBJVW1o7v/ev7veoSHFk/WJZlOMj0zM7MfpSVJc5k0BDYmuTbJhUneAmzdj1onAccA5zG62OxdjC48m7WT0c9X/j9VtaGqVlbVyqmpqf0oLUmay6QXi/1eklXAqcANVfW+/aj1AHBjVT0A7EhyFw99018O+DFfkgY08Vc9q2prVV2xnwEA8HFGh4RIchxwD3BUkuO7+y8CNu/n2JKk/TDpieEDVlWfSnJbkm2M9grWMwqhjUl2AZuqavtQ/UiSBgwBgKp6JfDKPVbPeTJYktQ/r/yVpIYZApLUMENAkhpmCEhSwwwBSWqYISBJDTMEJKlhhoAkNcwQkKSGDXrF8KHs9qvW9Db29/7axt7GlqSH456AJDXMEJCkhhkCktQwQ0CSGmYISFLDDAFJapghIEkNMwQkqWGGgCQ1zBCQpIYZApLUMENAkhpmCEhSwwwBSWrYooRAks8mOSfJyUk2J9mW5PLF6EWSWjZ4CCRZA3xHt3glsLaqfgpYkeS0ofuRpJYNGgJJlgLPB97B6AdtllTVju7u64HTh+xHklo39J7AVcDrgN3AUmDn2H07geVzPSjJuiTTSaZnZmb671KSGjFYCCR5LnB7VX26W/V1YNnYJsuBOd/hq2pDVa2sqpVTU1O99ilJLRnyN4afA9yb5J3ADwJnAScnOb6q/gO4CHjNgP1IUvMGC4GqWj17O8mrgU8wOgS0MckuYFNVbR+qH0nSsHsC/6uqXj226MlgSVokXiwmSQ0zBCSpYYaAJDXMEJCkhhkCktQwQ0CSGmYISFLDDAFJapghIEkNMwQkqWGGgCQ1zBCQpIYZApLUMENAkhpmCEhSwwwBSWqYISBJDTMEJKlhhoAkNcwQkKSGGQKS1DBDQJIaZghIUsMMAUlq2BFDFUqyDHgL8F2MwucFwFHAHwJLgI9V1aVD9SNJGjAEgEcD66vqjiSrgZcB3wesraodSd6d5LSq+uSAPUlS0wY7HFRVd1TVHd3i14BdwJKq2tGtux44fah+JEmLcE4gyfGM9gKuAHaO3bUTWD7PY9YlmU4yPTMzM0CXktSGQUMgyXnAq4AXAncBy8buXg7M+Q5fVRuqamVVrZyamuq9T0lqxWAhkOSHgfOr6pKq2llV9wFHd3sGABcBm4fqR5I07Inhc4BVSbZ0y7cD64GNSXYBm6pq+4D9SFLzBguBqnoj8MY57vJksCQtEi8Wk6SGGQKS1DBDQJIaZghIUsMMAUlqmCEgSQ0zBCSpYYaAJDXMEJCkhhkCktQwQ0CSGmYISFLDDAFJapghIEkNMwQkqWGGgCQ1zBCQpIYZApLUMENAkhpmCEhSwwwBSWqYISBJDTMEJKlhhoAkNeygCIEklyW5Kcm2JE9c7H4kqRWLHgJJVgHHVdWZwCXA5YvckiQ1Y9FDADgbuA6gqm4FjlncdiSpHamqxW0guQb4/S4ASPK3wBlVtXtsm3XAum7xZOC2/Sh1LHDnAbZ7sNY7nJ+b9axnvYWpd0JVTe258ogD7+eA3Q0sH1vePR4AAFW1AdhwIEWSTFfVygMZ42Ctdzg/N+tZz3r91jsYDgdtBdYAJDkF+PLitiNJ7TgY9gRuAM5NshW4h9HJYUnSABY9BLpDPy8aoNQBHU46yOsdzs/NetazXo/1Fv3EsCRp8RwM5wQkSYvEEJCkhh32IZBkKsnrk1w2QK1lSd6ZZEuSm5M8rud6RyV5X1fvpiTH91lvj9qfTXLOAHU+1z2/LUmeM0C9U7v/dtuSvLznWi8Ze25bkvT+XfMk68emaPnRAeq9sav38SRP6mH8h7y+k5ycZHP3/BZ89oG53k+SPCXJLUmW9F0vybO7/1emk7xiIWos+onhAVwBfAF49AC1Hg2sr6o7kqwGXgb8ao/1HgCeVVX3Jnke8ALgd3qsB0CSNcB39F2n85WqesoQhZIcCbwKuKCqvtZ3vaq6Gri6q/1zQN8fGpYBTwfOAk4E3gyc32O9c4AlVXVmkh9g9Fx/doHL7Pn6vhJYW1U7krw7yWlV9cm+6iW5EPhx4P4FrDFvPeALVXVWkkcAH0vyJ1U1cyAFDvs9gaq6GLh5oFp3VNUd3eLXgG/2XG93Vd3bLZ4EfK7PegBJlgLPB97Rd63O7r1vsmCeBnwRuK77NPljQxTtXtC/ShcIPXqQ0Wv+KEZXnR7Qm8cEfgj4KEBVbQeWLXSB8dd3kiMYhc6O7u7rgdP7qtctv7eqfhu4d/5HLWi96e7vbmAnCxA+h30ILIbusMzLGH0q6bvWpUk+D6wE/qbvesBVwOsY4M05ybcBJ3aHZ/4iyWN7LnkSo7mrzgPWAn/Qc71ZFwB/XVXf6rNIVd3D6A1lO7CJ0Z5An/4BuDAjJwErkqTHelOM3hhn7eShsxEcNpK8GNhaVXcf6FiGwAJLch6jQwovHNsr6E1VXV5VJzH6FNnrm1aS5wK3V9Wn+6wzq6q+WVUnVtUZwB8z2jXu0wPAjVX1QPdpcnfPb1qzfgl4a99FukOURzI6FPQE4KruEFgvqurDwOeBLYyuBfpE9fud9K/z0L2N5fS/tzOoJEuTvAX4alW9YSHGNAQWUJIfBs6vqkuqaudeH3Dg9ZaOvUndDnx7zyWfA5yS5J2Mpvr4zSQn91UsySPHFod4MX+c0SEhkhwH/HfPb1ok+U5GhzC+2medzgmMzrEU8A1gKbDgJzPHVdXrumniPwJ8ouda9wFHj31B4iJgc581F8HVwJuqauNCDdjCieEhnQOsSrKlW769O6bXlycAVybZBdwHvKTHWlTV6tnbSV7N6JPd/szoOqnHJ3kbo+Oe99PzleVV9akktyXZxmivYH2f9TpnMAqfIfwZ8LYkNwFHA9d0h4h60QXcXwEB/oVhZgZYD2zsXhObunMRh5PzgBPGdlBfW1UHdBjYK4YlqWEeDpKkhhkCktQwQ0CSGmYISFLDDAFJapghIPUsydFJfmJsudfvy0v7whCQ+vfdwEsXuwlpLoaAtIckK5J8IMkfJ7k1yeok1yb5dJI3JXlkkqu7KX0/MTvldJKzuu3+spsC+9e7q57fCTw5yY1jNV6XZGs3zfKjFuu5SoaANLcTGc3seQZwHfDKqvpx4CnAixnN3XIW8JPAT3dThsBoaoZnMprQ71eq6kHg2cDfVNXZ3TaPAa6rqlXA3wOz66XBGQLS3G6pqvur6i7gn6vq37v1twNPAt4P/zul70eB2TmUPlZVD1bVLkbz88zlzqr6x+72dg7TmS51aDAEpLmNz6ey57TZ/8ponqjZ3wJYxWja5D0fN3v7QUZz9cw1nvO2aFEZAtK+ezvwuCRbGe0F3LCXifTuAI5N8uFBupP2gRPISVLD3BOQpIYZApLUMENAkhpmCEhSwwwBSWqYISBJDTMEJKlh/wOGMj0pal95zAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.title(\"전체\")\n",
    "sns.countplot(x = 'month', data = df_song_info)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "de2ea342",
   "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}