E5_1_Visualization.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "fe1c6d20",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "150f45d7",
   "metadata": {},
   "outputs": [],
   "source": [
    "DEMO = pd.read_csv('LPOINT_BIG_COMP_01_DEMO.csv',encoding='cp949')\n",
    "COP_U = pd.read_csv('LPOINT_BIG_COMP_03_COP_U.csv',encoding='cp949')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dcd9c27e",
   "metadata": {},
   "source": [
    "# 전체 고객"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "11e73afa",
   "metadata": {},
   "source": [
    "## 주말 이용 비율"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "4b65d1f0",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21102612B015763935</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211026</td>\n",
       "      <td>20211026</td>\n",
       "      <td>12</td>\n",
       "      <td>60000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21110610B014219744</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211106</td>\n",
       "      <td>20211106</td>\n",
       "      <td>10</td>\n",
       "      <td>17100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21021112B013419710</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210211</td>\n",
       "      <td>20210211</td>\n",
       "      <td>12</td>\n",
       "      <td>136500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21092010B012637545</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210920</td>\n",
       "      <td>20210920</td>\n",
       "      <td>10</td>\n",
       "      <td>34200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21101009D015920171</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010614</td>\n",
       "      <td>1</td>\n",
       "      <td>20211010</td>\n",
       "      <td>20211010</td>\n",
       "      <td>9</td>\n",
       "      <td>2500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         cust              rct_no cop_c     br_c  chnl_dv     de_dt    vst_dt  \\\n",
       "0  M839993508  21102612B015763935   B01  B010012        1  20211026  20211026   \n",
       "1  M839993508  21110610B014219744   B01  B010012        1  20211106  20211106   \n",
       "2  M839993508  21021112B013419710   B01  B010012        1  20210211  20210211   \n",
       "3  M839993508  21092010B012637545   B01  B010012        1  20210920  20210920   \n",
       "4  M839993508  21101009D015920171   D01  D010614        1  20211010  20211010   \n",
       "\n",
       "   de_hr  buy_am  \n",
       "0     12   60000  \n",
       "1     10   17100  \n",
       "2     12  136500  \n",
       "3     10   34200  \n",
       "4      9    2500  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "COP_U.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "9e095ab0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#문자열을 datetime 자료형으로 바꿔주기\n",
    "COP_U['data_time']=COP_U['de_dt'].astype('str')\n",
    "COP_U['data_time'] = pd.to_datetime(COP_U['data_time'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "1a9fe368",
   "metadata": {},
   "outputs": [],
   "source": [
    "#날짜로부터 요일 구하기\n",
    "COP_U['weekday']=COP_U['data_time'].dt.weekday #월:0 ~ 일:6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "1a5d69e7",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21102612B015763935</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211026</td>\n",
       "      <td>20211026</td>\n",
       "      <td>12</td>\n",
       "      <td>60000</td>\n",
       "      <td>2021-10-26</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21110610B014219744</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211106</td>\n",
       "      <td>20211106</td>\n",
       "      <td>10</td>\n",
       "      <td>17100</td>\n",
       "      <td>2021-11-06</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21021112B013419710</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210211</td>\n",
       "      <td>20210211</td>\n",
       "      <td>12</td>\n",
       "      <td>136500</td>\n",
       "      <td>2021-02-11</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21092010B012637545</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210920</td>\n",
       "      <td>20210920</td>\n",
       "      <td>10</td>\n",
       "      <td>34200</td>\n",
       "      <td>2021-09-20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21101009D015920171</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010614</td>\n",
       "      <td>1</td>\n",
       "      <td>20211010</td>\n",
       "      <td>20211010</td>\n",
       "      <td>9</td>\n",
       "      <td>2500</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         cust              rct_no cop_c     br_c  chnl_dv     de_dt    vst_dt  \\\n",
       "0  M839993508  21102612B015763935   B01  B010012        1  20211026  20211026   \n",
       "1  M839993508  21110610B014219744   B01  B010012        1  20211106  20211106   \n",
       "2  M839993508  21021112B013419710   B01  B010012        1  20210211  20210211   \n",
       "3  M839993508  21092010B012637545   B01  B010012        1  20210920  20210920   \n",
       "4  M839993508  21101009D015920171   D01  D010614        1  20211010  20211010   \n",
       "\n",
       "   de_hr  buy_am  data_time  weekday  \n",
       "0     12   60000 2021-10-26        1  \n",
       "1     10   17100 2021-11-06        5  \n",
       "2     12  136500 2021-02-11        3  \n",
       "3     10   34200 2021-09-20        0  \n",
       "4      9    2500 2021-10-10        6  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "COP_U.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ae77ed22",
   "metadata": {},
   "outputs": [],
   "source": [
    "def func(x) :\n",
    "    if x > 4 :\n",
    "        return 'weekend'\n",
    "    else :\n",
    "        return 'weekday'\n",
    "COP_U['weekend'] = COP_U['weekday'].apply(lambda x : func(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "e6418a14",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "      <th>weekend</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21102612B015763935</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211026</td>\n",
       "      <td>20211026</td>\n",
       "      <td>12</td>\n",
       "      <td>60000</td>\n",
       "      <td>2021-10-26</td>\n",
       "      <td>1</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21110610B014219744</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211106</td>\n",
       "      <td>20211106</td>\n",
       "      <td>10</td>\n",
       "      <td>17100</td>\n",
       "      <td>2021-11-06</td>\n",
       "      <td>5</td>\n",
       "      <td>weekend</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21021112B013419710</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210211</td>\n",
       "      <td>20210211</td>\n",
       "      <td>12</td>\n",
       "      <td>136500</td>\n",
       "      <td>2021-02-11</td>\n",
       "      <td>3</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21092010B012637545</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210920</td>\n",
       "      <td>20210920</td>\n",
       "      <td>10</td>\n",
       "      <td>34200</td>\n",
       "      <td>2021-09-20</td>\n",
       "      <td>0</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21101009D015920171</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010614</td>\n",
       "      <td>1</td>\n",
       "      <td>20211010</td>\n",
       "      <td>20211010</td>\n",
       "      <td>9</td>\n",
       "      <td>2500</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>6</td>\n",
       "      <td>weekend</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         cust              rct_no cop_c     br_c  chnl_dv     de_dt    vst_dt  \\\n",
       "0  M839993508  21102612B015763935   B01  B010012        1  20211026  20211026   \n",
       "1  M839993508  21110610B014219744   B01  B010012        1  20211106  20211106   \n",
       "2  M839993508  21021112B013419710   B01  B010012        1  20210211  20210211   \n",
       "3  M839993508  21092010B012637545   B01  B010012        1  20210920  20210920   \n",
       "4  M839993508  21101009D015920171   D01  D010614        1  20211010  20211010   \n",
       "\n",
       "   de_hr  buy_am  data_time  weekday  weekend  \n",
       "0     12   60000 2021-10-26        1  weekday  \n",
       "1     10   17100 2021-11-06        5  weekend  \n",
       "2     12  136500 2021-02-11        3  weekday  \n",
       "3     10   34200 2021-09-20        0  weekday  \n",
       "4      9    2500 2021-10-10        6  weekend  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "COP_U.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "de0f1fdb",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAOcAAADnCAYAAADl9EEgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAYwUlEQVR4nO3deZhUxbnH8W/NAgoii2JARVRwjdpGRECvCthRUeMSEYKQ2GKL4hJNwI1oFJUrMYr7QjzGo6LELYl4jQooKLJoEBjjBsoOojAiiw7DMFD3jzroQFhmhul+63S/n+fpBxmmu94e+zdVp845VcZai1LKPwXSBSiltkzDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeUrDqZSnNJxKeapIuoDaMMaMBwZaa6du43tSwNHW2iuyVVdGhEF9oDWw72aPfYBGuP+HxdGfRYAB1gHlwNoqj+XAHOALYHb0mE8qXZmld6JqKJbhzElhsD9wAnAgm4awBS5wmVBJGMznx7DOxoX3E1LpzzPUpqqmrITTGHMtUG6tvd8Ycw+QsNZ2NcacBFwIPAUMBurjPiAXWmu/M8a0A4YBuwClQMpau6TK6xYATwALrbU3GmMuBG4AlgCzcD0GxphfADcC9YBvgN7AMmAmcKy1dln0WrOAjtba0gz/SCAMWgBdgZOiP/fNeJv/rQhoEz02FQYLgDHAaGAsqfTy7JamTDa2ADTGdAQGWGvPM8ZMwIXwOGAQbvh1OtDNWvu9Mea66N/vAN4GzorC0xM4xVrbNxrWXg9cBXxkrR1ijGkJvAe0A1YC44Dp1torjDFNgRXWWmuMSQOHWGsHGGNuBlZaa+81xpwMXGKtPTcjP4QwaAJ05sdAHpqRdjJjA/ABLqijgcmk0utkS8p92RrWfgC0M8Y0wvVm04CjgeOBUbgP6kRjDLjebTJwEHAYMCb6eiGuR9xoOPC8tXZI9PcOwHhr7TIAY8xzuCEiwN7Ac1GA6wFzo6//FXgZuBfoi+uF604YtI5etxtwVPQe4qgAaB89/gCsJgzG44I6ilR6gWBtOSsr4bTWrjPGzMMNYScBHwJdcMOpucAYa22vqs8xxhwOfGyt7bSVl50EdDHG3G2tLd/Y1Fa+9wFgmLV2lDGmM3BLVNdCY8zXxpiuuHD3rt07rCIMCnEjgUuBU8jNGfFGwC+ix32EwavAQ8BoUmndjbmOZPOD8w4wMPpzAu7DOwOYAhxnjGkLYIxpYIw5EHc82NwY0yn6erEx5qdVXu9x4F/AC8aYItyQtrMxZjdjTDFwXpXvbQwsjv77gs3qCoARuF54fa3fXRjsRRjcDMzD9cbdyM1gbq4AF9LXgZmEwdWEQWPhmnJCVo45AaLJn9eBJtGx5SzgUWvtsKjn+hPuWBPgxqiXOxK4HxeuIuBea+1jVU+lGGMG44avvXHB2zghNAMojI45zwLuwQV0CtDeWts5qqsYN0l0jLX2sxq9qTAoAE7G/aI5g/gOW+va98AzwEOk0h9KFxNXWQunr4wxRwP3WGuPr/aT3OTOpUA/YL/MVJYzJuCGvH/XSaSayetwGmOuB/oDva217273Ce6CgCtxvXOzzFaXc77EnS57nFS69ocPeSSvw1ltbvh6Ae7D1Uq4mrj7BLiWVPpV6UJ8p+HcnjBI4o5XD5MuJce8BQwklZ4uXYivNJxbEwb74K5OysxFCQrcxQ3DgUGk0iuEa/GOhnNz7rjyGtxxZQPhavLF17hedIR0IT7RcFYVBu1xpwAOkC4lT40DLiOVrtkprRyVDyfJqycMrgLeRYMpqQswjTDY/EKRvKQ9p7ua5a/AL6VLUZt4DLiSVHqtdCFS8jucYdAOeB7YX7oUtUVTge6k0vOlC5GQv8PaMLgcmIgG02dH44a5p0oXIiH/es4w2BU3ZOohXYqqtg3A7cBgUukN0sVkS36FMwyOBF4A2gpXomrnDaA3qfQ30oVkQ/6EMwxOA14CdpIuRe2QBcC5pNJbXdwtV+RHOMPgF8CLuFUQVPx9B3Qjld7+zQoxlvsTQmFwDq7H1GDmjl2A1wiD46QLyaTcDmcYnIc7VVIsXYqqcxsDeqx0IZmSu+EMg17ASHRt3lzWCHidMNjaOlOxlpvhDINfA0+jy4bkg40B7ShdSF3LvXCGwYVAiAYzn+wKvEEYdJAupC7lVjjD4GLcqny59b5UdWwM6DHShdSV3DmVEgZnAv8kc/uKqHhYCSRz4TxoboQzDA4A/o1bQlOpJcDPSKW/li5kR8R/+BcGDYG/o8FUP2oJjIxW34+t+IfTrdiui2+pzXUBbpUuYkfEe1gbBlfjVsZTaksscAap9L+kC6mN+IYzDI7HLa+oFxmobVmOO/6M3U5o8QxnGLTEbSPYQroUFQvvA8eTSldIF1IT8TvmDINi3D2ZGkxVXccAd0sXUVPxC6f7Ief03QgqI64gDGK1+kW8hrVh8HPcbspeWVFWRvqJJ/lo0ZcYA3/tm6JT2zY8MPZNHnxzHEUFBZyeOII7e3Rn4udf0P+pEdQvKmLkpf1o+5M9WFFWRs+Hh/P6gKuJdvFWmbEaaE8qPVO6kOqIz2RKGOwEPCJdxpZc9czfOPWww3jx8v5UVFZSVlHBuE8/4+XpJXx4683ULy5m6apVANz9+mheurw/8775hkfGjefuX/XgtlH/x6AzTtNgZl4j3Km36m/3KChOw9o/4Lap98qqNWt4Z9YsLjrhfwCoV1REkwYNeGTceK4/7VTqF7tbSffYdVcAigsLWbNuHWVrKyguLGT20qUs/nYFJx58kNh7yDP/Qxj8RrqI6ojHsDYMDgZK8HA1gxkLFtAvfJpD92xJycJFtGvdmvt6/4rjhgzlrJ8dyesffcxOxcXc1aM77fffjxkLFnDpkyPYuV49nr64LwOfe5HbzjmLA1r8RPqt5JOlwIGk0iulC9mWuPScj+JhMAEq129g2vwF9O/SmemD/0jD+vUZ+uprVG7YwLdlZUy58Qb+3KM7PR4ZjrWWI/fZhyk3DWLcdQOZs6yUPZs0xmLp+fBw+gwP+HrlKum3lA/2wC216TX/w+lm2E6ULmNr9m7WlL2bNqVDG7c2dff2RzFt/gL2btqUX7Y7CmMMx+y/HwWmgNLV3/3wPGstt7/yKjedeQaDX36FweecSZ9jO3L/2Del3kq+6R8tleotv8PptuMbKl3GtrRo3JhWzZoyc8lXALz5yWccumdLzj7qSN761G2WNeurr6iorGT3Rrv88LwnJ07i9CMOp2nDhpRVVFBgDAXGUFYRq/PkcVaI5+c+/T7mDINrgT9Jl7E9MxYsIP3EU1RUVrJ/8+Y8cVGKhvXr0/fxkBkLF1KvsIi7enan66GHAFC2di2n3/sAowdcTXFRERNmzeKyp56lXlEhIy+9mANb6PUVWXQaqfRr0kVsib/hDIPmwOforWAqs/4DHOnjNg8+D2tvRoOpMu9wwMv9QP3sOcNgd2AhunWCyo7FQFtS6XLpQqrytefshwZTZc9eQE/pIjbnXzjDoAjoL12Gyjvefeb8CyecDewtXYTKOx0Ig6Oki6jKx3BeKV2Aylte9Z5+TQiFwRG4a2iVklAG7OnLNbe+9ZzaaypJDfDotIo/4QyDZkBv6TJU3rtUuoCN/AknpIGdpYtQee8QwqCLdBHgSzjdytyXSZehVMSLiSE/wulW524tXYRSkbOj5VdF+RLObtIFKFVFMdBLughfwnmqdAFKbebn0gXIn+cMg1ZA7JbKVzmvDGgquUq8Dz3nKdIFKLUFDYBjJQvwIZw6pFW+Sko2LhtOdweK6A9AqW0QPe6U7jk7oqsdKH+1IwyaSDUuHU4d0iqfFQJdpRqXDqdOBinfiR12yYXTra7XTqx9paonD8MJHQDdVkv57gDCQOTSUslwHiDYtlI10VGiUQ2nUtu3v0SjGk6ltm8/iUY1nEptXx71nG73sFYibStVc3nVc7YRbFupmtonWq0jq6QCokNaFSdFCIz0NJxKVU/Wjzs1nEpVT9aPO6XC2VaoXaVqK296zn2E2lWqtvImnA2F2lWqtrK+851UOHVjXBU3Wf/MSoVTt11QcVOc7QazH84wMGjPqeKnXrYblOg5NZgqjvKg53TrsigVN1nvOYuy3SCwQaDNvFDa8JApi5sce6B0HbnJrk5kuUWJcK4XaDPnrTdF3y9u0qk1xjSTriU3mdXZblFiWKs9ZwbMb9b135gC8W3rcljWOxWJcGrPWcfWFDebs3qnVsdJ15HjyrLdYPbDmUpvAIS3Nsstc3bvtgJjsj6bmGe+zXaDUhchfC3Ubs5Z1vDQKZWFOx8lXUceyJtwzhdqN6esN0Xff9mko8iaqnkob8Kpm+XWgfnNuk7VSaCsyZtwas+5g9YUNZ27eqdWopu75pm8Caf2nDtoTvNuy3USKKuy/pnVcMaQmwRqoJtAZdecbDeow9qY0UkgMXkTTu05a0kngUSsBRZnu1GZcKbSy4HvRNqOMZ0EEjMvkcz+hTOSq65r71lDOgkkZpZEo5Lh1OPOGihteOhknQQSM02iUclwThdsO1bc7WA6CSToA4lGJcM5TrDtWIluB9tTuo48NlWiUclwTgQqBNuPBZ0EErckkWSJRMNy4Uyl1wDvibUfE9EkUNbXr1E/EBnSgvwemTq03YZSvRLIBxOkGtZweiqaBNI9ZeSNkWpYOpyTgXLhGrykk0BeWAbMkGpcNpyp9FpcQFUVOgnkjTclrgzaSLrnBB3a/hedBPKG2JAWNJze0Ukgb1hgtGQBPoTzPQSWHfSRTgJ5ZXIiySLJAuTDmUqvA/4pXYYPotvBdBLID89JFyAfTucv0gVIiyaBOknXoQC3K8Hz0kX4Ec5U+m1gpnQZknQSyCtvJ5J8JV2EH+F0HpMuQEppw0N0Esgv4kNa8CucT5KHF8JvMEVli5t00kkgf3wP/E26CPApnKl0KfAP6TKybZ5eCeSbZxJJVkoXAT6F08mriSGdBPLSQ9IFbORbOMcBX0gXkS06CeSdiYkkH0oXsZFf4UylLRBIl5ENOgnkJW96TfAtnM4TwDrpIjJJJ4G8tBB4SbqIqvwLZyq9FHhRuoxMmt+sy/s6CeSdOxJJv84W+BdO5xagUrqITFhT1HTuqp320dvB/LIIeFy6iM35Gc5UehZueJtzdBLIS971muBrOJ3BwBrpIuqSTgJ5ycteE3wOZyq9GHhQuoy6EodJoLUV5fS+4hh6XJLgl+mf8vCTN2/y70++cBdH/tzw7cpSAKZ/NJHz+h3B+Ze3Z8FidwZs1Xcr6H/9KVgrtoBATQ1JJFkrXcSW+BtOZygCOwpnwvxmXby/EqhecX0e+/NbPD+8hOcencGkqa/z4SdTAPhq6UKmfDCGlnv8+Pvl6Rfv5q4/vsSVff+XF155BIDHRtzGRb0GYYwReQ819DEeX9PtdzjdbmR/lC5jR0WTQN5fCWSMocHOuwBQWbmOysp1P4Tsrkd/x9UX3wlVQldUVMzaijWUry2jqKiYhV/OZuk3izk6caJI/bUwIJFkvXQRW1MkXUA1PAL0Aw6XLqS2okmg/aTrqI7169fT67J2LPzyC3qeeTmHH9KB8ZNG0Xy3vTioTWKT7+37qxu47Z5+1K+/M0Oue5phfxnIZRfcJlR5jY1KJHlDuoht8bvnBEil1wO/lS6jtuI2CVRYWMjzw2fwxshFfDTzfWbN+ZBg5BAuS936X997cNsjefqBKQR3jWPRkjk0321PwHLt7T0ZNLQP33z7dfbfQPWsAa6SLmJ7/A8nQCo9Hg/uTK+pOEwCbc2uuzTh6ERnxk96mcVfzaXHJQm69dmXpcsW0av/UZQu//FeZGstjz1zO/1638SjTw+m/28Gc/pJfXj2H/cLvoNtuj2RZJ50EdsTj3A6A4jZ5FAcJoGqWr5iGau+WwFA+do1vDdtLAe3/RnjXljKayPm8dqIeezRfG9GPjKN3Zu1+OF5o0Y/yfEdTmfXRk0pX1tGQUEBxhRQvtbLddv+DfxJuojqiMMxp5NKLyIM+hKTez7jMglUVenyJdx05wVs2LCeDXYDJ5/QgxM6nrHN56wpL+OVMU/yyFC3iuSvz/09AwafS3FxPYYOGpmNsmuiHLjA50mgqkyMzkc5YXAfMTgG/bjl+VMrCxscLV2H2sQ1iSR3SRdRXXEa1m50DYLbslVHNAmkwfTLRGCYdBE1Eb9wptIVQE9glXQpWxJNArWSrkNtYgXwm0SSDdKF1ET8wgmQSs8G0tJlbEl0O9he0nWoH1igTyLJHOlCaiqe4QRIpV8AhkuXUVV5UZN5ejuYd4YkkrwqXURtxDecztVAiXQRG81uflqp3g7mldHAzdv9Lk/FO5ypdDnu+PM76VJ0Esg784Hz43acWVW8wwmQSs8ELgK5/wk6CeSdb4FuiSTfSBeyI+IfToBU+nngEpDZhVgngbxSDpyZSPKpdCE7KjfCCZBKB8AV2W5WJ4G8sgE3M/uudCF1IXfCCZBKPwz8PptN6iSQV36XSPq1vOWOyK1wAqTS9wCDstFUacOD39NJIG/ckEji7W0wtZF74QRIpe8AMnrXr5sEOnbvTLahqu3aRJKh0kXUtdwMJ0Aq/Ufgzky9fHQ7mE4CyRuQSPJn6SIyIXfDCZBKXwd1P9SJJoFidTtYjvpdIhmvi9lrIrfDCZBKXwU8UJcvqZNA4ipw92XeK11IJuV+OAFS6d8CF8OOr0+qk0DiVgCnJJI8JV1IpuVHOGHjedATcSt814pOAombC3RKJBkvXUg25E84AVLp94B2wDu1ebpOAomaAnRMJPlMupBsya9wwsYtBk+ihhNFOgkk6j7gxESSpdKFZFP81hCqS2HQB/gLsPP2vlXXBBKxEuibSPJ36UIk5F/PWVUqPQI4Dra9hmlpw4P1drDsmw60y9dgQr6HEyCVng4cDfxrS/+sk0BZtx538UinRJLZ0sVIyu9h7ebCoBdwL7DHxi/N3S05ftXO+3aWKinPfARcmEgyVboQH2jPWVUqPRI4GAgA6yaBWuskUOatA27FDWM1mBHtObcmDI7/9Cfn/b6iuPHZ0qXkuAnAFYkkH0oX4hsN5zaUjKUIdwP3LUBj2WpyzgLc3STPSRfiKw1nNZSMZXfgeuAyqnHaRW3TSuAO4L5EknLpYnym4ayBkrG0xN3I3Q/QC99rZiXwIHBP3BfeyhYNZy2UjKUVcCNwAVBfuBzfleJmwB9MJFkpXEusaDh3QMlY9sCt+tcfaClcjm/m4W7VG55I8r1EAcaY8cBAa22dzQAbYzpHr7ntvRHrgJ5K2QGJJEsTSW4DWgO9gfeES5K2Hvgn0A1ok0gyTCqYuSA+m+d6LJFkHfAs8GzJWI7ABfV8IF+uLJoHPAEEiSRf1vZFjDHXAuXW2vuNMfcACWttV2PMScCFwFPAYNyhxGzgQmvtd8aYdrjt/XbBDaNT1tolVV63IKpvIW57hqFA5+h1HrLWDo96xFui5x+G22ayj7XWGmNOxQ3NS4FptX1/NaXD2gwpGUsBcAIuqN2BJqIF1b3ZwIvAi3V14YAxpiMwwFp7njFmAi48x+Em4cqB04Fu1trvjTHXRf9+B/A2cJa1dpkxpidwirW2bzSsvR64CvjIWjvEGNMP2MNae7sxpj5u387zcKOfl4GfAl9GX78GmAp8DnQFvgCeAxpkY1irPWeGRHt0jAfGl4ylP3AscCpuyJcAjFx1tbIe15uMBl5KJJmRgTY+ANoZYxrhVq2Yhrvu+XhgFHAoMNEYA262fDJwEK6nGxN9vRBYUuU1hwPPW2uHRH8/GTjCGNM9+ntj4ADc0ifvW2sXARhjZgD74vbhmWut/Tz6+gjcbH3GaTizIJGkEneD9zvAoJKxtMAF9QSgA3AI/oXVAv8B3ooebyeSmd2w2Fq7zhgzDzeEnQR8CHQB2uBWQRhjre1V9TnGmMOBj621W7vMchLQxRhzt7W2HPdzvtJa+8Zmr9OZTZexWc+P+RAZXmo4BSSSfAWE0YOSsewKtMcFtT3u+t79yd651ArgY2BGlUeJ0KmPd4CBQF/cL4dhuB51CvCQMaattfYLY0wD3DH9TKC5MaaTtXayMaYYONBa+3H0eo/jfgm+YIw5B3gD6G+MeSv6ZXAgsHgb9XwG7GeMaWOtnQ302sb31ikNpweiHunN6AFAyVgKgX1wQ64DcEOs5tFj9yqPRmy91y0DVkWP1bjdtxbitser+lgQ9e4+mAD8AZgcHVuWAxOi48kUMDI6VgS40Vo7Kxqi3m+MaYz7TN+L+2UDgLV2WPRvT+PmAPYFphk3Dl4GnL21Yqy15dFx6qvGmFLgXdwwOuN0QigHRNcA18Mdb21UlkiyXqgkVQc0nEp5Si9CUMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpTGk6lPKXhVMpT/w+jIzULJmAGaQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "colors = sns.color_palette('pastel')[3:5]\n",
    "\n",
    "labels = COP_U['weekend'].value_counts().index.tolist()\n",
    "ratio = COP_U['weekend'].value_counts().values.tolist()\n",
    "\n",
    "plt.pie(ratio, labels = labels, colors = colors, autopct='%.0f%%')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "678639f3",
   "metadata": {},
   "source": [
    "## 카페 이용률"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "8cc2d423",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "      <th>weekend</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21101009D015920171</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010614</td>\n",
       "      <td>1</td>\n",
       "      <td>20211010</td>\n",
       "      <td>20211010</td>\n",
       "      <td>9</td>\n",
       "      <td>2500</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>6</td>\n",
       "      <td>weekend</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M348796971</td>\n",
       "      <td>21103114D013043421</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010398</td>\n",
       "      <td>1</td>\n",
       "      <td>20211031</td>\n",
       "      <td>20211031</td>\n",
       "      <td>14</td>\n",
       "      <td>4600</td>\n",
       "      <td>2021-10-31</td>\n",
       "      <td>6</td>\n",
       "      <td>weekend</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>M348796971</td>\n",
       "      <td>21080712D012470819</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010398</td>\n",
       "      <td>1</td>\n",
       "      <td>20210807</td>\n",
       "      <td>20210807</td>\n",
       "      <td>12</td>\n",
       "      <td>7800</td>\n",
       "      <td>2021-08-07</td>\n",
       "      <td>5</td>\n",
       "      <td>weekend</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>M348796971</td>\n",
       "      <td>21081014D011253058</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010398</td>\n",
       "      <td>1</td>\n",
       "      <td>20210810</td>\n",
       "      <td>20210810</td>\n",
       "      <td>14</td>\n",
       "      <td>5900</td>\n",
       "      <td>2021-08-10</td>\n",
       "      <td>1</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>M348796971</td>\n",
       "      <td>21081210D014440902</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010398</td>\n",
       "      <td>1</td>\n",
       "      <td>20210812</td>\n",
       "      <td>20210812</td>\n",
       "      <td>10</td>\n",
       "      <td>4900</td>\n",
       "      <td>2021-08-12</td>\n",
       "      <td>3</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          cust              rct_no cop_c     br_c  chnl_dv     de_dt  \\\n",
       "4   M839993508  21101009D015920171   D01  D010614        1  20211010   \n",
       "6   M348796971  21103114D013043421   D01  D010398        1  20211031   \n",
       "17  M348796971  21080712D012470819   D01  D010398        1  20210807   \n",
       "18  M348796971  21081014D011253058   D01  D010398        1  20210810   \n",
       "19  M348796971  21081210D014440902   D01  D010398        1  20210812   \n",
       "\n",
       "      vst_dt  de_hr  buy_am  data_time  weekday  weekend  \n",
       "4   20211010      9    2500 2021-10-10        6  weekend  \n",
       "6   20211031     14    4600 2021-10-31        6  weekend  \n",
       "17  20210807     12    7800 2021-08-07        5  weekend  \n",
       "18  20210810     14    5900 2021-08-10        1  weekday  \n",
       "19  20210812     10    4900 2021-08-12        3  weekday  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fnb = COP_U.loc[COP_U['cop_c'].isin(['D01','D02'])]\n",
    "fnb.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "7a7c1cf4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAOcAAADnCAYAAADl9EEgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAXT0lEQVR4nO3de5wWZd3H8c+1e8/uqqiYrgdGUUhM0XyNgoc0yx7hUXmsMQkPmJqgJKjogzyl1stDqaiYkRmJLzMTDyFpjaIlqZga5gkoRUVAERhUEBJhj7O78/wx99KCIHu67981c//er9e+Fvd0fTf4ds3MPXNdJo5jlFL2KZMOoJTaPC2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplKS2nUpbSciplqZx0ALVlURDmgH3yb72BvYCdgR2Bnvn3rW/lQDPQkn/f+rYOWLWZt2XAAsd3PyjSr6M6yOhGRnaIgnAP4DBgIHAo8CWSUhb6/0A/Bd4B3gYWAP8CXnR8d1WBx1VboeUUEAWhISnhIOCI/J9d0VCftQiY3ebtDcd39R9LEWk5iyQKwt2A44ETgMHALrKJOmwl8DjwGDDT8d0a4TyZp+UsoPyh6nDgdGAAYGQTdZt6YBbwKPCI47srhfNkkpazm0VBuD0wFPgu8A2yf0W8iWRGvRt4wvHdJuE8maHl7CZREA4ALiUp5jayacR8BEwF7nZ89y3pMGmn5eyCKAjLgJNJSnmMaBj7PAXc4vjuk9JB0krL2QlREG4HnA+MBfoIx7Hd68CNwDTHd5ulw6SJlrMDoiCsAEYBPwZ2E46TNouAG4DfOb7bIh0mDay6WGGMaTbGzDPGzDfG/NMYM84YU9bm81cYYxYZYxYYY45v8/HrjTHLjDHrC5ErCsKyKAjPInmh/pdoMTtjX5KLRvOiIPxv6TBpYNXMaYxZH8dxj/yfdwUeAP4ex/HVxpj+wIPA4UAvknOa/eI4bjbGHAm8Dyxs/f7uEgXhEOAm4KDu/LmKmcB4x3dflw5iK2vLmf/vvsArJC/YXw4Qx/GE/OeeBK6J4/jFLX1/V0RB6AK3Aad0x89Tm9UC/Bb4oeO7q6XD2Maqw9pNxXH8LknGXUlub1vW5tPLKcAtb1EQlkdBeAnwFlrMQisDRgJvRkF4qnQY21hdzjyzyfu2unXaj4LwUOAlYBKwfXf+bPW5dgWmRUH4x/xdVQrLy5k/rG0mua9zOckjU632BFZ0xzj5Cz5XkhRzQHf8TNUpJ5PMoudKB7GBteecxphq4H7gxfwFoQNJLhC1XhB6GugXx3Hz5r6/vaIg7AXcR3KrnbLHw8AIx3c/lQ4ixbaZc5vWl1JIrsbOBK4FiON4PvAQ8CbwF+DC1mIaY242xiwHtjXGLDfGXNOewaIg/BbJ84taTPsMBV6LgtCTDiLFqpmzWKIgdICfARdLZ1FbVQ9c4vjundJBiq3kyhkF4S7AdOBY4SiqY+4DRjm+WycdpFhKqpxREPYHZqD3w6bVi8C3HN/9WDpIMdh2zlkwURAOIlluQ4uZXl8BXoyCcF/pIMVQEuWMgvAc4M8kq9SpdNsXmB0F4ZHSQQot8+WMgvACklvEdBnQ7KgGnomC0JcOUkiZLmcUhJcCvyY7a/eo/9gG+EMUhJm9xTKz5YyC8IfAz6VzqILKAb+PgvBk6SCFkMlyRkF4FcnT9yr7HOCh/A0lmZK5l1KiIBwL/EI6hyq6RmCo47szpIN0l0yVMwrCYcDvyegRgdqqBmCQ47svSAfpDpkpZxSEx5Lcc1spHEXJWg0c6fjuIukgXZWJckZB+GXgefR1TJVYSFLQNdJBuiL1h39REO6O3mCgNtYP+FN+tcTUSnU58/tXPoR9O3QpeccAv5EO0RWpLifJyyW60rraku9GQXihdIjOSu05ZxSEQ4E/SOdQ1msgOf+cJx2ko1JZzigIv0SyZKYuwqXaYyFwqOO7BVl0vFBSd1ibP8l/CC2mar9+wBTpEB2VunICVwEHS4dQqTM8CsIR0iE6IlWHtfk9MP+BPv6lOmcdcJDju0ulg7RHambO/OHsPWgxVedtT4oOb1NTTpLDWd1MSHXVCfkd46yXisPaKAgPBl5DZ03VPVYB+9t+e19aZs5JaDFV96km2dbRatbPnPmn3P8oNf6CcDFnThy94b/f+2gpV58xnhVrPmDGK09RkXPou/ve3HXxrfTssSOz33qFi+64gkqnkqmX3c6+e/Thk/VrOfOWMcy4+j6M0RVTLBEDAxzfnSsdZEusLmf+ItB8khXXxDU3N7PPyIG8cPNjvBMu5hsHH02uPMcVv7segAnn/IhhN57HDWdfyfsrlzNzzrPcPOIqfnD3Tzjp8MF87aCvCP8GahN/dXzX2l22bT+sHYslxQR45l8v0Hf3vdl71z0ZfMjXyZUnR9pHfOlQwtUfAOCUO9Q11lPbUEcul2PxB0sI13yoxbTT4CgIB0uH2BJry5nfNuHH0jnaeuiFRzntmM+uxnjPU9M4/tBkL6QfDL2IMZN/yC8fu4sxQ77HVfffzDXDxxc7qmq/G6MgtPJcw9pyAv+LRc9oNkaNzHh5JkOPPmmjj0+Yfhu58nKGfz1ZodHreyAv3PwYf71uOu99tJReX9iNOIbhE0dzzs8v5qNPVknEV1t2KHCGdIjNsbKcURDuCFj1qM9f5szikL5fZree1Rs+du8z03ni1ae4d9ztn7nQE8cxEx66jStPvYTrpt3KVWdcxvCvn8LtM+4udnS1dT+NgrBcOsSmrCwnSTGtmTUBpj0fcNrX/nNI++ScWdzyyGQeufK3bFu5zWe+fuoz0zlx4H+xU4+e1DbUUWbKKDNl1DWUzCZZadIX+I50iE1Zd7U2CsJtgfeBXaSztKptqKPveYex4I7Z7LjdDgAccMHRNESNfGH7nYDkotCvRt+44ev9n57NE9c8gJNzeGH+S1w85UoqchVMvexX7Of2Fftd1Ba96vjuYdIh2rKxnJeiK7UrGcc6vvs36RCtrDqszR/3j5POoUrWZdIB2rKqnMAJwF7SIVTJOim/yoYVbCvn+dIBVEkzwOitflWRWHPOGQXhHsBS9AZ3JWsV0Mvx3SbpIDbNnOeixVTyqoETpUOAJeXM3z41UjqHUnnnSAcAS8oJHEXyQrBSNjgpCsKdpEPYUs5h0gGUaqMSOF06hHg584e0Q6VzKLWJb0sHEC8nMBDYUzqEUpv4WhSE20kGsKGc35QOoNRmVAKDJANoOZXasv+RHFy0nPnVDjzJDEp9jiGSg0vPnF8VHl+pz+Pm10wWIV1O3fhW2U7s36h0OXXmVLY7QmpgsXLmL1MfKjW+Uu1UeuUEjkRvdFf26xcF4RckBpYs5wDBsZVqLwMcLjGwZDn7C46tVEeIHNpqOZXaugMkBhUpZ/5md5FfWKlO6CcxqNTM2RvoITS2Uh0lspmWVDn1kFalyQ5REO5a7EGlytlHaFylOqvos6dUOXcXGlepzir6eadUOXcTGlepzir6hKIzp1LtU/S7hHTmVKp9di72gDpzKtU+JTNz9hQaV6nOKplyVgqNq1RnlcxhrSM0rlKdtW2xByx6OaMgLAPKiz2uUl1U9K5IzJw6a6o0KvqEIrESQYXAmCWh3mlasniPf+8gnSOj1nq4RR1QopxGYMySUFMVfYBhH+kcGbW22ANKHNbWCIxZEmorGxukM2RYVOwBi15Ox3ebgdpij1sK6iqaqqQzZFj2y5m3XmjcTGvKtewhnSHDSqac64TGzawWE9fGsJd0jgxbXewBtZwZUVcRLcGIr+CfZcuLPaDUX2bRr3xlXU1VtEY6Q8aVTDmXCY2bWbWVUbN0howrmXK+LzRuZtVXNG0vnSHjtJyqc5rLYr0YVFglU84lQuNmUlNZy8cYqqVzZFzJlFNnzm5UWxnpOXxh1Xue93GxB5Uq51KgRWjszKmpatSXpgorlBhUpJyO79YD70iMnUW1lU36MEFhLZQYVPJF67mCY2dKo9MssrlrCXlJYlAtZ8rFxHGLifeWzpFxL0oMKlnOOYJjZ0ZjrnkZRndsK6AYnTlVZ9RWRR9IZ8i4tz3P+0RiYLFyOr67Bn29s8tqqqI66QwZJ3JIC7IzJ8BzwuOnXl1Fk64BXFglW85ZwuOnXpRrLvqmriWmZMv5tPD4qdZC3BCDXqktnLXAm1KDi5bT8d1lwNuSGdKsvqLpfYzICoqlYrbnebHU4NIzJ8BfpAOkVU1VtEo6Q8Y9LDm4DeV8QjpAWtVWRUVfdKqERMAjkgFsKOcsoOh3/GdBvdOkNx8Uzl89z/u3ZADxcjq+2wT8QTpHGjWVtxR3f4DS8pB0APFy5j0oHSBtmsta1mLQdWoLowH4k3QIW8r5PAJPmqdZbWW0RDpDhj3peZ74CpFWlNPx3RgLDiPSpKYyEv/Hk2HTpAOAJeXMu086QJrUVumF2gKpBx6VDgEWldPx3bkI3iqVNg255p2kM2TUo57nWbGXjzXlzLtNOkBatJTFvaUzZNQvpAO0sq2cDwMrpEPYrrG8eQWGHaVzZNBLnufNlg7RyqpyOr4bAXdI57BdbVUkshpcCfi5dIC2rCpn3hSgUTqEzWqqGkV2B//www85//zzOeWUUxg6dCgPPPAAAAsWLODss8/mtNNOY/jw4bzxxhsAzJs3j1NPPZUzzzyTpUuXArBu3TrGjBlDHIvdT74lS7HsZhjryun47krgHukcNquraHIkxi0vL2fcuHE88sgj3HvvvUybNo3FixczadIkRo0axbRp0xg9ejSTJk0CYOrUqUycOJGLL76Y6dOnA3DnnXcyYsQIjLFuNc+bPc+zajMo68qZdx3JXRpqMxpzzSJbL1RXV3PAAQcAsN1229GnTx9WrVqFMYaammQyX79+PdXVSbxcLkdDQwN1dXXkcjmWLVvGypUrGThwoET8z/MB8BvpEJsyFh5eABAF4S+Bi6Rz2CYmbnqz98ctGCokc6xYsYKRI0cyffp0Vq5cyYUXXkgcx7S0tHDPPffQq1cvFixYwPXXX09lZSXXXXcdt956K2PGjGHvva17Pnyc53lWnW+C3eXcHXgX2EY6i03qKqJF7+7xyb6SGWpraznvvPMYOXIkxx13HDfddBMDBgxg0KBBzJw5k4cffpgpU6Zs9D2vvfYas2bNYtiwYUyePJlcLse4cePYeeedhX6LDVYB+3ieVysdZFO2Htbi+O6HwK+kc9implL2Aesoihg/fjwnnngixx13HAAzZszY8OfBgwczf/78jb4njmPuuusuRo0axZQpU7jgggsYMmQIDz5oxfMO19pYTLC4nHk3AZ9Kh7BJbVUkdi4exzHXXnstffr04ayzztrw8erqal577TUAXn75ZXr33vj+iMcee4xjjjmGHXbYgfr6esrKyigrK6O+vr6o+TdjDvBr6RBbYu1hbasoCMdi0V0b0t5xV78c5VoOlxh77ty5jBgxgn79+m242nrRRRfRo0cPJk6cSFNTE5WVlVxxxRX0798fgLq6OsaOHcvkyZNxHIc5c+YwYcIEHMdhwoQJkuefLcBXPM97WSrA1qShnOXAq4AnHMUK83uvWoZBd7Huujs9z/u+dIjPY/thLY7vNgOjSfasKGnNpmU9sKd0jgz4GLhCOsTWWF9OAMd3/4GFr0MVW11l0xIM1r16n0KXe563RjrE1qSinHmXU+ILgdVURaILTmXEbOBu6RDtkZpyOr67GrhAOoek2sqoRTpDyjUDYyQXiu6I1JQTwPHdh4HfSueQ0uA06WNiXTPB87x/Sodor1SVM28ssEg6hITmsliv0nbe08DV0iE6InXldHx3PXAm0CSdpZii8uaVGMTvdUupFcBwz/NSdVqQunICOL77MnCtdI5iqq2MlklnSKkm4DTP81ZKB+moVJYz7wZghnSIYqmpiqxYdCqFLvc87wXpEJ2R2nI6vtsCDEdw/8RiqquMyqUzpNAfPc/7mXSIzkptOQEc310HfAuw/gXlrmrMtej5ZscsAs6VDtEVqS4ngOO7i4FhZPgCUUzc0mLifaRzpEgN8B0btlToitSXE8Dx3WeAS6RzFEqD0/w+Rh86b6d6wE/T65lbkolyAji+Oxm4RjpHIdRWRh9JZ0iJiGTGfFo6SHfITDkBHN+9FkjtBYAtqalqFH8qOQWagTM9z3tcOkh3yVQ5ARzfHU+y9m1m1FU0VUlnsFwMjPA8b7p0kO6UuXLmjQHulw7RXZpyLbtJZ7DchZ7n3Ssdortlspz510C/RwYK2mLiuhisW0vSIuM9z7N2HaCuyGQ5ARzfbQLOwuIFnNqjrqJpCSa7f09d9KM032SwNZn+S3d8N3Z8dwzwU+ksnVVT1bhaOoOFIpJzzBukgxRSpsvZyvHdq0ge1LZqL4z2qK2MUpe5wD4Fhniel/nnekuinACO704BTiZl6+DWVzT1kM5gkaXAVz3Pe0o6SDGUTDkBHN+dARxGim6W1wesN3gOGOh53uvSQYqlpMoJ4PjuO8ARWLYX4+Y0lbWsxrCrdA4LTAYGeZ4nuhVFsZVcOSFZTcHx3WEkK/pZe06nD1hTB5zved6FnudFn/eFxphmY8w8Y8x8Y8w/jTHjjDFlbT5/hTFmkTFmgTHm+PzHtjXGPG6MeTv/fTcW+PfpkJIsZyvHd28CjgOWCEfZrJqqKNVPVXTRbMDzPO+udn59XRzHXhzHBwKDgSHk1wwyxvQHTgcOBE4AJhtjWp+PvSWO4/2BQ4CjjTEnducv0RUlXU4Ax3f/BhwMtPcfQdHUVkal+PdTB1wGHON53jud+QFxHK8ERgEXmWRTFx/4fRzHDXEcv0fyrOfhcRzXxnE8K/89jSQbG1mzon4p/uV/huO76xzfPR84iWSXYys0Os07SWcoshdJZstbu7oYVxzH75L8+94VcIG2pwjL8x/bwBjTE/gmySp9VtBytuH47uPAQVhw219MHJfQA9b1wP+RvEzSqdlyC8wm79vasLC0MSYHPAjcli+1FXLSAWzj+O4a4LtREE4BbkNod7PGXPPyEtlN7B/AuZ7nvd2dP9QY05fkYt9Kkpmy7f+We5Isl9nqTmBhHMeTujNDV+nMuQWO7z4PDAC+j8AeLbVVkTWH1wWyEDgDOKoAxawG7gBuj5M9Lh8FTjfGVBpj+gD9gJfzX3sdsCNwaXdm6A7W789pgygIe5Ksk3sBUFGMMZfv/Omza3s0HFuMsYpsKfAT4Hee53Xbuk/GmGbgdcAhWU9qKnBrHMct+c//CBiR/9ylcRz/2RizJ8m56NtA647ht8dxbMXFQS1nB0RBuCfJa6PnAZWFHGthrzWzG53mowo5RpF9RLLW8BTP8xq29sVKy9kpURD2An5Acrm+IAtvvbnXqsVxGV8sxM8usn8DE4HbPM+rkQ6TJlrOLoiCcDeSVf9GQvfdZtdC3PhW74/LMKm+YLeQZMPjKZ7nfSKcJZW0nN0gCsIK4BSSc9Kvd/Xn1VZE77y3xyf7dTlY8dWR3LN8l+d5z0mHSTstZzeLgnB/kpIOB6o78zM+3qH27x/tVHN0twYrrLkkd1jdn/aFnG2i5SyQKAjLSWbRocC3gT3a+73vV699dv22jccWKFp3Wcl/Zsm50mGySMtZBFEQlgFHAd8Bjgf2/7yvX+CufqUp13JYMbJ1QAvwKvBE/u3VtGzfnlZaTgH5C0nHtnnbqKzze69agaFX0YNtLAbeAJ7Nvz3neV7Rb8YoZVpOC+TLehjgtZi4/1u9Pz4E2Jfi3V75IckL8W8DC/LvX/E8TxcXE6TltNS8efMc4Isks+p+wC7ATkDPzbzvyca3YjaR7LTV+ra+zZ/XkjwytaGInuelal2lUqHlzIB58+YZYHuSmbZG78DJBi2nUpbSp1KUspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVspSWUylLaTmVstT/Aw5WwAoPtpjIAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "colors = sns.color_palette('pastel')[6:8]\n",
    "\n",
    "labels = fnb['cop_c'].value_counts().index.tolist()\n",
    "ratio = fnb['cop_c'].value_counts().values.tolist()\n",
    "\n",
    "plt.pie(ratio, labels = labels, colors = colors, autopct='%.0f%%')\n",
    "plt.show() #D01: 롯데리아, D02: 엔젤리너스"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "13e8eabd",
   "metadata": {},
   "source": [
    "## 카페 방문시간"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "c835a0c0",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "      <th>weekend</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>M355649173</td>\n",
       "      <td>21102914D021083700</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020485</td>\n",
       "      <td>1</td>\n",
       "      <td>20211029</td>\n",
       "      <td>20211029</td>\n",
       "      <td>14</td>\n",
       "      <td>80200</td>\n",
       "      <td>2021-10-29</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>M267409798</td>\n",
       "      <td>21102815D022091253</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020374</td>\n",
       "      <td>1</td>\n",
       "      <td>20211028</td>\n",
       "      <td>20211028</td>\n",
       "      <td>15</td>\n",
       "      <td>9100</td>\n",
       "      <td>2021-10-28</td>\n",
       "      <td>3</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>M725568174</td>\n",
       "      <td>21081615D025551251</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020158</td>\n",
       "      <td>1</td>\n",
       "      <td>20210816</td>\n",
       "      <td>20210816</td>\n",
       "      <td>15</td>\n",
       "      <td>5700</td>\n",
       "      <td>2021-08-16</td>\n",
       "      <td>0</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>M502325468</td>\n",
       "      <td>21110914D021813670</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020158</td>\n",
       "      <td>1</td>\n",
       "      <td>20211109</td>\n",
       "      <td>20211109</td>\n",
       "      <td>14</td>\n",
       "      <td>11300</td>\n",
       "      <td>2021-11-09</td>\n",
       "      <td>1</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>M502325468</td>\n",
       "      <td>21072213D020814740</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020158</td>\n",
       "      <td>1</td>\n",
       "      <td>20210722</td>\n",
       "      <td>20210722</td>\n",
       "      <td>13</td>\n",
       "      <td>11000</td>\n",
       "      <td>2021-07-22</td>\n",
       "      <td>3</td>\n",
       "      <td>weekday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          cust              rct_no cop_c     br_c  chnl_dv     de_dt  \\\n",
       "42  M355649173  21102914D021083700   D02  D020485        1  20211029   \n",
       "67  M267409798  21102815D022091253   D02  D020374        1  20211028   \n",
       "83  M725568174  21081615D025551251   D02  D020158        1  20210816   \n",
       "88  M502325468  21110914D021813670   D02  D020158        1  20211109   \n",
       "89  M502325468  21072213D020814740   D02  D020158        1  20210722   \n",
       "\n",
       "      vst_dt  de_hr  buy_am  data_time  weekday  weekend  \n",
       "42  20211029     14   80200 2021-10-29        4  weekday  \n",
       "67  20211028     15    9100 2021-10-28        3  weekday  \n",
       "83  20210816     15    5700 2021-08-16        0  weekday  \n",
       "88  20211109     14   11300 2021-11-09        1  weekday  \n",
       "89  20210722     13   11000 2021-07-22        3  weekday  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cafe = COP_U.loc[COP_U['cop_c']=='D02']\n",
    "cafe.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "456e84ef",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='de_hr', ylabel='count'>"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAEHCAYAAABfkmooAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAYF0lEQVR4nO3de7BlZX3m8e8DKOKFCKEhbTczTazWiBhReggToxhwtL0E0BGLTICekdAzFF5wxokwUBmtQBUmmjFYSgq8cPGC7QVpdVCQBMxUUDwgyF1aQWhp6VbHkWgVBvzNH+vtZKfZ56x1mt6nT3O+n6pde633vL+93nPO2vvZ67LXTlUhSdJMdtreA5AkzX+GhSSpl2EhSeplWEiSehkWkqReu2zvAUzKXnvtVcuWLdvew5CkHcr111//o6patGX74zYsli1bxtTU1PYehiTtUJJ8f1y7u6EkSb0MC0lSL8NCktTLsJAk9TIsJEm9DAtJUi/DQpLUy7CQJPUyLCRJvR63n+CW5rO7PnDGrPovP/nMCY1EGsYtC0lSL8NCktTLsJAk9TIsJEm9DAtJUq+JhkWSe5LcnOTGJFOtbc8kVya5q93vMdL/tCTrktyZ5BUj7Qe1x1mX5JwkmeS4JUn/0lycOvv7VfWjkflTgauq6uwkp7b5dyTZHzgGeC7wDOCrSZ5VVY8A5wKrga8D/xtYCVw+B2OX5pWb3/GWWfV/3rvPmdBItNBsj91QRwIXtukLgaNG2i+pqoeq6m5gHXBwksXA7lV1bVUVcNFIjSRpDkw6LAq4Isn1SVa3tn2qagNAu9+7tS8B7hupXd/alrTpLdsfJcnqJFNJpjZt2rQNfw1JWtgmvRvqRVV1f5K9gSuT3DFD33HHIWqG9kc3Vp0HnAewYsWKsX0kSbM30S2Lqrq/3W8ELgUOBh5ou5Zo9xtb9/XAviPlS4H7W/vSMe2SpDkysbBI8pQkT9s8DbwcuAVYC6xq3VYBl7XptcAxSXZNsh+wHLiu7ap6MMkh7Syo40dqJElzYJK7ofYBLm1nue4CfKKqvpzkm8CaJCcA9wJHA1TVrUnWALcBDwMntzOhAE4CLgB2ozsLyjOhJGkOTSwsqup7wPPHtP8YOHyamrOAs8a0TwEHbOsxSpKG8RPckqRehoUkqZdhIUnqZVhIknoZFpKkXoaFJKnXXFx1VtJ2ds2xb55V/0M/9v4JjUQ7KrcsJEm9DAtJUi/DQpLUy2MWkqZ18atPmVX/4770vomMQ9ufWxaSpF6GhSSpl2EhSeplWEiSehkWkqRehoUkqZdhIUnqZVhIknoZFpKkXoaFJKmXYSFJ6mVYSJJ6GRaSpF6GhSSpl2EhSeplWEiSehkWkqRehoUkqZdhIUnqNfGwSLJzkm8l+WKb3zPJlUnuavd7jPQ9Lcm6JHcmecVI+0FJbm4/OydJJj1uSdI/m4sti7cCt4/MnwpcVVXLgavaPEn2B44BngusBD6YZOdWcy6wGljebivnYNySpGaiYZFkKfBq4EMjzUcCF7bpC4GjRtovqaqHqupuYB1wcJLFwO5VdW1VFXDRSI0kaQ5MesvifcCfAL8aadunqjYAtPu9W/sS4L6Rfutb25I2vWX7oyRZnWQqydSmTZu2yS8gSZpgWCR5DbCxqq4fWjKmrWZof3Rj1XlVtaKqVixatGjgYiVJfXaZ4GO/CDgiyauAJwG7J/kY8ECSxVW1oe1i2tj6rwf2HalfCtzf2peOaZc0T5156FsG9z3jmnMmOBJtKxPbsqiq06pqaVUtoztw/TdVdSywFljVuq0CLmvTa4FjkuyaZD+6A9nXtV1VDyY5pJ0FdfxIjSRpDkxyy2I6ZwNrkpwA3AscDVBVtyZZA9wGPAycXFWPtJqTgAuA3YDL202SNEfmJCyq6mrg6jb9Y+DwafqdBZw1pn0KOGByI5QkzcRPcEuSehkWkqRehoUkqZdhIUnqZVhIknoZFpKkXoaFJKmXYSFJ6mVYSJJ6GRaSpF6GhSSpl2EhSeplWEiSehkWkqRehoUkqZdhIUnqZVhIknoZFpKkXoaFJKmXYSFJ6mVYSJJ67bK9ByBJm5244sTBfc+fOn+CI9GW3LKQJPUyLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9ZpYWCR5UpLrktyU5NYk72rteya5Msld7X6PkZrTkqxLcmeSV4y0H5Tk5vazc5JkUuOWJD3aJLcsHgIOq6rnAwcCK5McApwKXFVVy4Gr2jxJ9geOAZ4LrAQ+mGTn9ljnAquB5e22coLjliRtYVBYJLlqSNuo6vxDm31CuxVwJHBha78QOKpNHwlcUlUPVdXdwDrg4CSLgd2r6tqqKuCikRpJ0hyYMSzarqQ9gb2S7NF2Ie2ZZBnwjL4HT7JzkhuBjcCVVfUNYJ+q2gDQ7vdu3ZcA942Ur29tS9r0lu3jlrc6yVSSqU2bNvUNT5I0UN9VZ/8zcApdMFwPbD5W8DPgA30PXlWPAAcmeTpwaZIDZug+7jhEzdA+bnnnAecBrFixYmwfSdLszRgWVfVXwF8leXNVvX9rF1JVP01yNd2xhgeSLK6qDW0X08bWbT2w70jZUuD+1r50TLskaY4MOmZRVe9P8rtJ/kOS4zffZqpJsqhtUZBkN+BlwB3AWmBV67YKuKxNrwWOSbJrkv3oDmRf13ZVPZjkkHYW1PEjNZKkOTDoy4+SXAw8E7gReKQ1bz7YPJ3FwIXtjKadgDVV9cUk1wJrkpwA3AscDVBVtyZZA9wGPAyc3HZjAZwEXADsBlzebpIEwF0fOGNw3+UnnznBkTx+Df2mvBXA/u1spEGq6tvAC8a0/xg4fJqas4CzxrRPATMd75AkTdDQz1ncAvzGJAciSZq/hm5Z7AXcluQ6ug/bAVBVR0xkVJKkeWVoWLxzkoOQJM1vg8Kiqq6Z9EAkSfPX0LOhHuSfPwj3RLpLd/y8qnaf1MAkSfPH0C2Lp43OJzkKOHgSA5J2NCeuOHFw3/Onzp/gSKTJ2aqrzlbV54HDtu1QJEnz1dDdUK8bmd2J7nMXXntJkhaIoWdD/cHI9MPAPXSXFJckLQBDj1n8p0kPRJI0fw398qOlSS5NsjHJA0k+m2Rpf6Uk6fFg6AHuj9JdFfYZdF889IXWJklaAIaGxaKq+mhVPdxuFwCLJjguSdI8MjQsfpTk2PY1qTsnORb48SQHJkmaP4aGxRuBNwA/BDYArwc86C1JC8TQU2f/DFhVVf8XIMmewHvoQkSS9Dg3dMvitzcHBUBV/YQxX2wkSXp8GhoWOyXZY/NM27IYulUiSdrBDX3Bfy/w90k+Q3eZjzcw5utPJUmPT0M/wX1Rkim6iwcGeF1V3TbRkUmS5o3Bu5JaOBgQkrQAbdUlyiVJC4thIUnqZVhIknoZFpKkXn5WQtKCdfM73jK47/Pefc4ERzL/uWUhSeplWEiSehkWkqReHrPQ487Frz5lcN/jvvS+f5o+89Dh+6/PuGZh77/WwjOxLYsk+yb52yS3J7k1yVtb+55JrkxyV7sfvUDhaUnWJbkzyStG2g9KcnP72TlJMqlxS5IebZK7oR4G/ltVPQc4BDg5yf7AqcBVVbUcuKrN0352DPBcYCXwwSQ7t8c6F1gNLG+3lRMctyRpCxMLi6raUFU3tOkHgduBJcCRwIWt24XAUW36SOCSqnqoqu4G1gEHJ1kM7F5V11ZVAReN1EiS5sCcHOBOsozuy5K+AexTVRugCxRg79ZtCXDfSNn61rakTW/ZLkmaIxMPiyRPBT4LnFJVP5up65i2mqF93LJWJ5lKMrVp06bZD1aSNNZEwyLJE+iC4uNV9bnW/EDbtUS739ja1wP7jpQvBe5v7UvHtD9KVZ1XVSuqasWiRYu23S8iSQvcJM+GCvBh4Paq+suRH60FVrXpVcBlI+3HJNk1yX50B7Kva7uqHkxySHvM40dqJElzYJKfs3gRcBxwc5IbW9v/AM4G1iQ5AbgXOBqgqm5NsobuC5YeBk6uqkda3UnABcBuwOXtJkmaIxMLi6r6P4w/3gBw+DQ1ZzHmu72rago4YNuNTpI0G17uQ5LUy7CQJPUyLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9TIsJEm9DAtJUi/DQpLUy7CQJPUyLCRJvQwLSVIvw0KS1GuSX6sqPSbXHPvmwX0P/dj7JzgSSW5ZSJJ6uWUhSbO0ELd63bKQJPUyLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9TIsJEm9DAtJUq+JhUWSjyTZmOSWkbY9k1yZ5K52v8fIz05Lsi7JnUleMdJ+UJKb28/OSZJJjVmSNN4ktywuAFZu0XYqcFVVLQeuavMk2R84Bnhuq/lgkp1bzbnAamB5u235mJKkCZtYWFTV14CfbNF8JHBhm74QOGqk/ZKqeqiq7gbWAQcnWQzsXlXXVlUBF43USJLmyFwfs9inqjYAtPu9W/sS4L6Rfutb25I2vWX7WElWJ5lKMrVp06ZtOnBJWsjmywHuccchaob2sarqvKpaUVUrFi1atM0GJ0kL3VyHxQNt1xLtfmNrXw/sO9JvKXB/a186pl2SNIfmOizWAqva9CrgspH2Y5LsmmQ/ugPZ17VdVQ8mOaSdBXX8SI0kaY5M7GtVk3wSeCmwV5L1wP8EzgbWJDkBuBc4GqCqbk2yBrgNeBg4uaoeaQ91Et2ZVbsBl7ebJGkOTSwsquoPp/nR4dP0Pws4a0z7FHDANhyaJGmW5ssBbknSPGZYSJJ6GRaSpF6GhSSpl2EhSeplWEiSehkWkqRehoUkqZdhIUnqZVhIknpN7HIfkqR/6eJXnzK473Ffet/ExrE13LKQJPUyLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9fIT3Jq4m9/xlsF9n/fucyY4Eklbyy0LSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9fJzFpI0z5156PDPKp1xzWQ+q2RYaLC7PnDG4L7LTz5zgiORNNfcDSVJ6rXDhEWSlUnuTLIuyanbezyStJDsELuhkuwMfAD4d8B64JtJ1lbVbdt3ZJI0f5244sTBfc+fOn/Gn+8QYQEcDKyrqu8BJLkEOBKYMSy2dh/74/3Cd9tyBZK0MKSqtvcYeiV5PbCyqv64zR8H/E5VvWmLfquB1W322cCd0zzkXsCPtmIoO0LdjjBG66yzbv7W/euqWvSo1qqa9zfgaOBDI/PHAe9/DI839Xit2xHGaJ111u14dTvKAe71wL4j80uB+7fTWCRpwdlRwuKbwPIk+yV5InAMsHY7j0mSFowd4gB3VT2c5E3AV4CdgY9U1a2P4SHPexzX7QhjtM4663awuh3iALckafvaUXZDSZK2I8NCktRrQYXF1l4yJMlHkmxMcsssavZN8rdJbk9ya5K3Dqx7UpLrktzU6t41dJmtfuck30ryxVnU3JPk5iQ3JpmaRd3Tk3wmyR3t9/y3A2qe3Zaz+fazJKcMXN7b2t/kliSfTPKkgXVvbTW3zrSscf/nJHsmuTLJXe1+j4F1R7fl/SrJilks7y/a3/PbSS5N8vSBdX/Wam5MckWSZwypG/nZ25NUkr0GLu+dSX4w8n981dDlJXlzex7emuTPBy7vUyPLuifJjQPrDkzy9c3rdpKDB9Q8P8m17TnxhSS7j1nW2Od33/oyQ92M68sMdTOuLzPU9a4vj7I15+juiDe6A+PfBX4TeCJwE7D/wNqXAC8EbpnF8hYDL2zTTwO+M2R5QICntuknAN8ADpnFcv8r8Angi7OouQfYayv+phcCf9ymnwg8fSv+Jz+k+xBQX98lwN3Abm1+DfAfB9QdANwCPJnuhI6vAsuH/p+BPwdObdOnAu8eWPccug+GXg2smMXyXg7s0qbfPYvl7T4y/Rbgr4eux3SnpX8F+P649WCa5b0TeHvP335c3e+3/8GubX7voeMc+fl7gT8duLwrgFe26VcBVw+o+SZwaJt+I/BnY5Y19vndt77MUDfj+jJD3Yzrywx1vevLlreFtGXxT5cMqapfApsvGdKrqr4G/GQ2C6uqDVV1Q5t+ELid7gWvr66q6h/a7BPabdBZCEmWAq8GPjSbsW6N9m7rJcCHAarql1X101k+zOHAd6vq+wP77wLslmQXuhf/IZ+1eQ7w9ar6RVU9DFwDvHZcx2n+z0fShSLt/qghdVV1e1VNdwWBmequaOME+DrdZ4qG1P1sZPYpjFlnZliP/xfwJ+NqeupmNE3dScDZVfVQ67NxNstLEuANwCcH1hWwecvg19hinZmm5tnA19r0lcC/H7Os6Z7fM64v09X1rS8z1M24vsxQ17u+bGkhhcUS4L6R+fUMePHeFpIsA15At5UwpP/ObTN7I3BlVQ2qA95H96T/1SyHWMAVSa5Pd8mUIX4T2AR8NN1urw8lecosl3sMY570YwdY9QPgPcC9wAbg/1XVFQNKbwFekuTXkzyZ7t3lvj01o/apqg1tDBuAvWdR+1i9Ebh8aOckZyW5D/gj4E8H1hwB/KCqbtqK8b2p7cr4yLjdc9N4FvDiJN9Ick2SfzPLZb4YeKCq7hrY/xTgL9rf5T3AaQNqbgGOaNNH07O+bPH8Hry+zPZ1YUDdjOvLlnWzXV8WUlhkTNvEzxtO8lTgs8ApW6T5tKrqkao6kO5dwsFJDhiwnNcAG6vq+q0Y5ouq6oXAK4GTk7xkQM0udJvv51bVC4Cf0212D5Luw5VHAJ8e2H8Pundt+wHPAJ6S5Ni+uqq6nW7z/Ergy3S7Hx+esWgeSHI63Tg/PrSmqk6vqn1bzZv6+rfwPJ2BwbKFc4FnAgfShfd7B9btAuwBHAL8d2BN21oY6g8Z+AajOQl4W/u7vI22JdzjjXTPg+vpdt38crqOW/P8nkRd3/oyrm6268tCCos5v2RIkifQ/YM+XlWfm219261zNbByQPcXAUckuYduF9thST42cDn3t/uNwKV0u+z6rAfWj2z1fIYuPIZ6JXBDVT0wsP/LgLuralNV/SPwOeB3hxRW1Yer6oVV9RK6XQ5D35UCPJBkMUC7f9Ruk20tySrgNcAfVdupPEufYMyukzGeSRe+N7X1ZilwQ5Lf6Cusqgfam5pfAeczbJ2Bbr35XNvdeh3dVvCjDqqP03Y/vg741MBlAayiW1ege2PSO86quqOqXl5VB9EF03enGc+453fv+rK1rwvT1fWtLwOWN2h9WUhhMaeXDGnvlj4M3F5VfzmLukWbz2hIshvdi+QdfXVVdVpVLa2qZXS/299UVe877yRPSfK0zdN0B8x6z/qqqh8C9yV5dms6nJ5Lxm9htu8Q7wUOSfLk9rc9nG7/a68ke7f7f0X3YjOb5a6le8Gh3V82i9pZS7ISeAdwRFX9YhZ1y0dmj2DYOnNzVe1dVcvaerOe7mDoDwcsb/HI7GsZsM40nwcOa4/xLLoTI4ZeNfVlwB1VtX5gf+jeEB7apg9jwBuFkfVlJ+AM4K/H9Jnu+T3j+vIYXhfG1vWtLzPUzXp9mfHo9+PtRre/+jt07xROn0XdJ+k2tf+R7gl1woCa36PbzfVt4MZ2e9WAut8GvtXqbmHMWR8DHuOlDDwbiu7Yw03tduss/y4HAlNtrJ8H9hhY92Tgx8CvzfL3eldbqW8BLqadUTOg7u/oguwm4PDZ/J+BXweuonuRuQrYc2Dda9v0Q8ADwFcG1q2jO7a2eZ0Zd1bTuLrPtr/Lt4Ev0B3EnNV6zDRnxU2zvIuBm9vy1gKLB9Y9EfhYG+sNwGFDxwlcAPyXWf7/fg+4vv3vvwEcNKDmrXSvE98BzqZd6WLI87tvfZmhbsb1ZYa6GdeXGep615ctb17uQ5LUayHthpIkbSXDQpLUy7CQJPUyLCRJvQwLSVIvw0KS1MuwkLahdJfufvssay5I8vpJjUnaFgwLaQeQZOftPQYtbIaF9BglOT3dl/l8le7y1iR5ZpIvtyv5/l2S3+p5mJck+fsk39u8lZHkpe2Laz5B92lpabvZZXsPQNqRJTmI7lpcL6B7Pt1Ad3mJ8+guTXFXkt8BPki7JtI0FtNdmuG36C6f8ZnWfjBwQFXdPZnfQBrGsJAemxcDl1a7iFuStcCT6K6I++mRq2/v2vM4n6/uCq63JdlnpP06g0LzgWEhPXZbXmBtJ+Cn1X0nyVAPjUyPfr/Dz7d2UNK25DEL6bH5GvDaJLu1S73/AfAL4O4kR0N3megkz9+eg5QeK8NCegyq+37jT9Fd+vmzdJdDh+6rKk9IsvnS74O+712ar7xEuSSpl1sWkqReHuCW5kiS04Gjt2j+dFWdtT3GI82Gu6EkSb3cDSVJ6mVYSJJ6GRaSpF6GhSSp1/8H5FGM/h2OiQwAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "p1=sns.color_palette(\"flare\")\n",
    "sns.countplot(x=cafe['de_hr'],palette=p1) #점심 식사 후, 카페를 많이 방문하는 것 같습니다.."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f588d99e",
   "metadata": {},
   "source": [
    "## 카페 평균 이용 금액"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "3cbaffd4",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10130.199842351742"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cafe['buy_am'].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "94df86ca",
   "metadata": {},
   "source": [
    "# 20대 카페 이용 비율 및 이용 시간대"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "1cf7c601",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "      <th>weekend</th>\n",
       "      <th>ma_fem_dv</th>\n",
       "      <th>ages</th>\n",
       "      <th>zon_hlv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21102612B015763935</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211026</td>\n",
       "      <td>20211026</td>\n",
       "      <td>12</td>\n",
       "      <td>60000</td>\n",
       "      <td>2021-10-26</td>\n",
       "      <td>1</td>\n",
       "      <td>weekday</td>\n",
       "      <td>남성</td>\n",
       "      <td>70대</td>\n",
       "      <td>Z17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21110610B014219744</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20211106</td>\n",
       "      <td>20211106</td>\n",
       "      <td>10</td>\n",
       "      <td>17100</td>\n",
       "      <td>2021-11-06</td>\n",
       "      <td>5</td>\n",
       "      <td>weekend</td>\n",
       "      <td>남성</td>\n",
       "      <td>70대</td>\n",
       "      <td>Z17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21021112B013419710</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210211</td>\n",
       "      <td>20210211</td>\n",
       "      <td>12</td>\n",
       "      <td>136500</td>\n",
       "      <td>2021-02-11</td>\n",
       "      <td>3</td>\n",
       "      <td>weekday</td>\n",
       "      <td>남성</td>\n",
       "      <td>70대</td>\n",
       "      <td>Z17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21092010B012637545</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010012</td>\n",
       "      <td>1</td>\n",
       "      <td>20210920</td>\n",
       "      <td>20210920</td>\n",
       "      <td>10</td>\n",
       "      <td>34200</td>\n",
       "      <td>2021-09-20</td>\n",
       "      <td>0</td>\n",
       "      <td>weekday</td>\n",
       "      <td>남성</td>\n",
       "      <td>70대</td>\n",
       "      <td>Z17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M839993508</td>\n",
       "      <td>21101009D015920171</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010614</td>\n",
       "      <td>1</td>\n",
       "      <td>20211010</td>\n",
       "      <td>20211010</td>\n",
       "      <td>9</td>\n",
       "      <td>2500</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>6</td>\n",
       "      <td>weekend</td>\n",
       "      <td>남성</td>\n",
       "      <td>70대</td>\n",
       "      <td>Z17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         cust              rct_no cop_c     br_c  chnl_dv     de_dt    vst_dt  \\\n",
       "0  M839993508  21102612B015763935   B01  B010012        1  20211026  20211026   \n",
       "1  M839993508  21110610B014219744   B01  B010012        1  20211106  20211106   \n",
       "2  M839993508  21021112B013419710   B01  B010012        1  20210211  20210211   \n",
       "3  M839993508  21092010B012637545   B01  B010012        1  20210920  20210920   \n",
       "4  M839993508  21101009D015920171   D01  D010614        1  20211010  20211010   \n",
       "\n",
       "   de_hr  buy_am  data_time  weekday  weekend ma_fem_dv ages zon_hlv  \n",
       "0     12   60000 2021-10-26        1  weekday        남성  70대     Z17  \n",
       "1     10   17100 2021-11-06        5  weekend        남성  70대     Z17  \n",
       "2     12  136500 2021-02-11        3  weekday        남성  70대     Z17  \n",
       "3     10   34200 2021-09-20        0  weekday        남성  70대     Z17  \n",
       "4      9    2500 2021-10-10        6  weekend        남성  70대     Z17  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "customer = pd.merge(COP_U,DEMO, how='inner', on='cust')\n",
    "customer.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "557c480d",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "      <th>weekend</th>\n",
       "      <th>ma_fem_dv</th>\n",
       "      <th>ages</th>\n",
       "      <th>zon_hlv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>101764</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21091719D015810462</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010681</td>\n",
       "      <td>1</td>\n",
       "      <td>20210917</td>\n",
       "      <td>20210917</td>\n",
       "      <td>19</td>\n",
       "      <td>12800</td>\n",
       "      <td>2021-09-17</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101765</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21052123C011047432</td>\n",
       "      <td>C01</td>\n",
       "      <td>C010096</td>\n",
       "      <td>2</td>\n",
       "      <td>20210521</td>\n",
       "      <td>20210522</td>\n",
       "      <td>23</td>\n",
       "      <td>4900</td>\n",
       "      <td>2021-05-21</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101766</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21070721D013427640</td>\n",
       "      <td>D01</td>\n",
       "      <td>D011208</td>\n",
       "      <td>1</td>\n",
       "      <td>20210707</td>\n",
       "      <td>20210707</td>\n",
       "      <td>21</td>\n",
       "      <td>2500</td>\n",
       "      <td>2021-07-07</td>\n",
       "      <td>2</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101767</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21072513C013346139</td>\n",
       "      <td>C01</td>\n",
       "      <td>C010015</td>\n",
       "      <td>2</td>\n",
       "      <td>20210725</td>\n",
       "      <td>20210725</td>\n",
       "      <td>13</td>\n",
       "      <td>4900</td>\n",
       "      <td>2021-07-25</td>\n",
       "      <td>6</td>\n",
       "      <td>weekend</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101768</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21120411B014929990</td>\n",
       "      <td>B01</td>\n",
       "      <td>B010016</td>\n",
       "      <td>1</td>\n",
       "      <td>20211204</td>\n",
       "      <td>20211204</td>\n",
       "      <td>11</td>\n",
       "      <td>21000</td>\n",
       "      <td>2021-12-04</td>\n",
       "      <td>5</td>\n",
       "      <td>weekend</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              cust              rct_no cop_c     br_c  chnl_dv     de_dt  \\\n",
       "101764  M529174515  21091719D015810462   D01  D010681        1  20210917   \n",
       "101765  M529174515  21052123C011047432   C01  C010096        2  20210521   \n",
       "101766  M529174515  21070721D013427640   D01  D011208        1  20210707   \n",
       "101767  M529174515  21072513C013346139   C01  C010015        2  20210725   \n",
       "101768  M529174515  21120411B014929990   B01  B010016        1  20211204   \n",
       "\n",
       "          vst_dt  de_hr  buy_am  data_time  weekday  weekend ma_fem_dv ages  \\\n",
       "101764  20210917     19   12800 2021-09-17        4  weekday        여성  20대   \n",
       "101765  20210522     23    4900 2021-05-21        4  weekday        여성  20대   \n",
       "101766  20210707     21    2500 2021-07-07        2  weekday        여성  20대   \n",
       "101767  20210725     13    4900 2021-07-25        6  weekend        여성  20대   \n",
       "101768  20211204     11   21000 2021-12-04        5  weekend        여성  20대   \n",
       "\n",
       "       zon_hlv  \n",
       "101764     Z16  \n",
       "101765     Z16  \n",
       "101766     Z16  \n",
       "101767     Z16  \n",
       "101768     Z16  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#20대 추출\n",
    "twenties = customer.loc[customer['ages']=='20대']\n",
    "twenties.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c3aeab95",
   "metadata": {},
   "source": [
    "#  F&B 카테고리 내 카페 이용 비율"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "2e5fefd2",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "      <th>weekend</th>\n",
       "      <th>ma_fem_dv</th>\n",
       "      <th>ages</th>\n",
       "      <th>zon_hlv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>101764</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21091719D015810462</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010681</td>\n",
       "      <td>1</td>\n",
       "      <td>20210917</td>\n",
       "      <td>20210917</td>\n",
       "      <td>19</td>\n",
       "      <td>12800</td>\n",
       "      <td>2021-09-17</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101766</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21070721D013427640</td>\n",
       "      <td>D01</td>\n",
       "      <td>D011208</td>\n",
       "      <td>1</td>\n",
       "      <td>20210707</td>\n",
       "      <td>20210707</td>\n",
       "      <td>21</td>\n",
       "      <td>2500</td>\n",
       "      <td>2021-07-07</td>\n",
       "      <td>2</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101769</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21090315D014712585</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010681</td>\n",
       "      <td>1</td>\n",
       "      <td>20210903</td>\n",
       "      <td>20210903</td>\n",
       "      <td>15</td>\n",
       "      <td>12800</td>\n",
       "      <td>2021-09-03</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101770</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21090316D022558382</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020024</td>\n",
       "      <td>1</td>\n",
       "      <td>20210903</td>\n",
       "      <td>20210903</td>\n",
       "      <td>16</td>\n",
       "      <td>5500</td>\n",
       "      <td>2021-09-03</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101771</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21040920D010410272</td>\n",
       "      <td>D01</td>\n",
       "      <td>D010681</td>\n",
       "      <td>1</td>\n",
       "      <td>20210409</td>\n",
       "      <td>20210409</td>\n",
       "      <td>20</td>\n",
       "      <td>10400</td>\n",
       "      <td>2021-04-09</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              cust              rct_no cop_c     br_c  chnl_dv     de_dt  \\\n",
       "101764  M529174515  21091719D015810462   D01  D010681        1  20210917   \n",
       "101766  M529174515  21070721D013427640   D01  D011208        1  20210707   \n",
       "101769  M529174515  21090315D014712585   D01  D010681        1  20210903   \n",
       "101770  M529174515  21090316D022558382   D02  D020024        1  20210903   \n",
       "101771  M529174515  21040920D010410272   D01  D010681        1  20210409   \n",
       "\n",
       "          vst_dt  de_hr  buy_am  data_time  weekday  weekend ma_fem_dv ages  \\\n",
       "101764  20210917     19   12800 2021-09-17        4  weekday        여성  20대   \n",
       "101766  20210707     21    2500 2021-07-07        2  weekday        여성  20대   \n",
       "101769  20210903     15   12800 2021-09-03        4  weekday        여성  20대   \n",
       "101770  20210903     16    5500 2021-09-03        4  weekday        여성  20대   \n",
       "101771  20210409     20   10400 2021-04-09        4  weekday        여성  20대   \n",
       "\n",
       "       zon_hlv  \n",
       "101764     Z16  \n",
       "101766     Z16  \n",
       "101769     Z16  \n",
       "101770     Z16  \n",
       "101771     Z16  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "FnB_twenties = twenties[twenties['cop_c'].isin(['D01','D02'])]\n",
    "FnB_twenties.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "10195e5d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAOcAAADnCAYAAADl9EEgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAWxklEQVR4nO3deXwU9f3H8deEAB6oiBweo8WrXrXtaL2qVi1WW/en1lql49laqfWqgvVA6lG1bg/rrVWrLVh1PFuronhgEVSsVodLQBRcYUgwSCQQIOfO748ZMKJAErLz+c7O5/l47CPIbvi+10femdk5vl8rDEOUUuapkA6glPpyWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQWk6lDKXlVMpQldIB1Jp5flABbAMMBLaPv24J9AE2BzYDNo4flUArUIy/rnwsAT5Z7VEDzAHedx27Oqn3ozrG0oWMzOD5wdbA3sBe8WN3YDugR4mHXgq8Hz9mAG8Bb7iOXVvicdU6aDkFeH5gAd8AvgccQlTKLUVDfdEHwBvxY4Lr2FOE82SOljMhnh/YwJHA4cAgoJ9sog6bDzwHPAu86Dp2vXCespeaclqW1QpMBboDLcAo4OYwDIvx88OBnxN9zvpVGIbPx3//O+A0YPMwDHslmdnzgy2BE4HBwAGAleT4JdQETAAeAx51HftT4TxlKU3lrF9ZLsuy+gMPAa+FYXiVZVm7Ax6wL7A18BLw1TAMWy3L2h/4CHg/iXJ6ftCbqIw/Ab5D+R8RbwRGA/8AnnUdu0k4T9lIZTnj/96B6OBFX+AygDAM8/FzzwNXh2E4cU3f39U8P/gGcC5wMrBRqcYx3CKiX5q3uY79vnSYtEvtqZQwDOdYllUB9Cc63fBGm6eD+O9KyvOD7sCPiUp5YKnHS4EtgPOBcz0/eAa4yXXscbKR0iu15YxZq31tq2S7BJ4f9ASGEG2xS/5LIIUqgGOAYzw/8IGbAM917BbZWOmS2s9D8W5tK9EJ9QDYts3TNlDV1WN6ftDT84NziU4z3IYWsz0c4H5gpucHp8YXVqh2SOVnTsuy+gEPAhPjA0J7EH3WWXlAaCywcxiGrV/2/R3l+UElcCYwgqj4qvOmA5e7jv1v6SCmS1M5Vz+V8g/gxjanUkYAZ8TPXRiG4XPx3/8ROImotFXAvWEYXt3ecT0/OJRoK/m1rnovCoBXgQtdx35bOoipUlPOpHl+sC1wA9F5SlUaReBOYITr2Eukw5hGy7ma+AjsxUS7sFk9JZK0amCo69iPSAcxiZazjfhc5Sii615V8p4Hfuk6dkE6iAm0nIDnB92A4cCVRJ9plZw64BzXsR+SDiIt8+X0/GBHooNLB0hnUZ/zAHBulj+LZrqcnh/8kOgc3CbCUdSX+xA42XXsiet8ZRnKZDnjE+HXEV3hUy53ipSrFmCY69i3SQdJWubK6flBH6I7WI6QzqI65K9Eu7nN0kGSkqlyen7wdeBJovl4VPqMB453HfsT6SBJyEw54yt9/g1sKhxFrZ8CcIzr2FOlg5RaJi5C9vzgeGAMWsxyMBAY7/lB2R9dL/tyen5wFvAo0FM6i+oyvYEXPT8YJB2klMq6nJ4fXAHcRZm/z4zaGBjt+cGx0kFKpWx/aD0/GAFcI51DlVRP4HHPD06WDlIKZXlAyPODYcCfpXOoxLQCg13HfkI6SFcqu3J6fnA20W1IKluagJzr2C9JB+kqZVVOzw9OB/6OXvWTVfXAINex35QO0hXKppyeHxxBNBt5N+ksSlQtcLDr2NOlg6yvsiin5we7AROJVt1SKgC+5Tr2x9JB1kfqj9Z6frAF8DRaTPUZG3gintUitVJdTs8PegD/BHaUzqKMcyDRxGyplepyEv3P/450CGWss+IrxFIptZ85PT8YDDwsnUMZrxk4zHXs16SDdFQqy+n5wfbAJPRCdtU+c4Gvu45dJx2kI1K3WxvPvu6hxVTttx1wu3SIjkpdOYmmF9lPOoRKnVM8P0jVBOGp2q31/OAgorvh9Qog1RmfAnu6jj1fOkh7pGbLGZ82uQctpuq8zYGR0iHaKzXlJJopbzfpEADLltZx88VncdGPDuXXPzqMWZPf5qNZ07ny9GO59MTD+dMFP2N5/VIA3pv0Fpee+D1+c0qOBXM/XPX9+XNOJk17LWXkcM8PTpMO0R6p2K31/GAXYDKGzGbwlyuHsquzL4cd59LS3ERjwwryZ5/EyUN/w257H8C4Jx+mpmoeJ55zMTddNISfXHA5n1TNY/Lr4zhl2JU8cOM17H3I99ht77KfacNUC4FdXceulQ6yNsZvOT0/sIC7MaSYy+uXMvOd/3LoD38CQGX3Hmy8yWZUfzSHXffaH4A99/8Ob419DoBulZU0NzTQ2LCCbpXd+XhegdqaBVpMWf2A66VDrIvx5QRc4BDpECvVzJ/LJpv34e6rhzHc/T73XHMxDSuWY++4C2+/8gIAb7z0DIs+jhbWPuaM87j3uksZ89B9HDH4pzxyxx854ZyLJd+Cigzx/MCRDrE2RpczPgj0O+kcbRVbWyjMnMbhPz6NvDeGnhtuxFN/v4NfXHUDLz46istPOoqGZcuo7B5dcz1wlz245v6n+M09j1ITfMTm/QZAGHLrpWdzx4hfUbdoofA7yqwKDL/21uhyAucQTYVojD79t6JP/63Yac/ol+5+g46iMHMa22y/E8PvfIjrH3qWb3//WPrbX/nc94VhyJP33cpxQy7giXtu4vhfXsRBRx3HGO9vEm9DRQ70/OBo6RBrYmw5PT/YlGgBW6P07tufLQZsRVVhNgDT3nyNbbbfmbraaBLyYrHIv+69lcOPP+Vz3zf+6cf45kGD6LVpb5oaVlBRUYFVUUFTw4rE34P6nGvi4xrGqZQOsBaXAH2lQ3yZ0y+9ljtGnE9LczP97e046+o/M+GZJ3jx0VEA7PPdH3DIsYNXvb5xxQomPPM4l93xIABHnTyEmy/+Bd0qe3B+PnVXlZWbbwLHA48L5/gCI0+leH7Qj2jafV32XSVhOtGVQ0XpIG2Zult7AVpMlZzdic4KGMW4cnp+sAlwrnQOlTmXSQdYnXHlBM4kWgtDqSR9zfOD70qHaMuocnp+0A34lXQOlVlG/ewZVU7gWAw7r6ky5eh4lg0jmFbOIdIBVKZVAOdJh1jJmFMpnh9sQzTXi2m/MFS2LAa2ch27QTqISUU4FbPyqGzqDeSkQ4BZZThdOoBSsZOkA4Ahu7WeH+xPtNaJUiZoBAZIT6VpypazLFcmVqnVk+h6W1GmlNPY23ZUZonv2orv1np+sCcwRTSEUl/UCvR1HXuxVAATtpy61VQm6gYMkgyg5VRqzY6UHFy0nJ4f9Af2lcyg1Fpkt5zAYQZkUGpNtvP8QGwic+lifFt4fKXW5QipgbWcSq3d/lIDi5XT84ONiCZXUspk35IaWHLLuQ9mz/6nFMBOnh9sLjGwZDl1sRCVFiJbT8ly7ik4tlIdsY/EoJLl3FVwbKU6Yi+JQUXKGU9/v4vE2Ep1wk4Sg0ptOW1gY6GxleqoHSUGlSqn7tKqNOkVX2qaKKly7iw0rlKdlfjWU6qcWwuNq1RnZaacie8iKLWetkt6QKlyDhAaV6nO6pP0gFpOpdon8Uv4dLdWqfbJzJZzC6FxleqszGw5ewqNq1RnZWbL2V1oXKU6K/Er2hIvZ7xArvQMDEp1VLekB5QoiW41VRolXk6JmQi0nCXyXvWSKSMnfGhL5yhHFRaLXSfZ/7U6TUgZGTOlegkCBy6yoBiyOOkxJXZrlwuMWfYamluXLKhrELkpOCOakx4w8XK6jt0KrEh63HI3bkbNJGAj6RxlrPzLGasXGrdsvfHBJ32lM5S5pqQH1HKWgaB2+fuNLcXdpXOUucQ/jmk5y8Bzk6uqpDNkwLykB5QqZ63QuGWnpbXYOGfhMp1mtPQ+SnpAqXLOFxq37Lwxe9Hb6OmTJBSSHlDLmXKvzKjRmwiSkZkt51yhccvKovrGoL6xRc9tJiMz5SwIjVtWxkyp/gCwpHNkhJZTtU8xDIvT59fpFKPJWFjI5zJzKuUDoFVo7LIwdd5ivxiyjXSOjEh8qwlC5XQduwF4T2LscvHitAWJX7GSYdkpZ2yS4NiptqyxpXZRfdPe0jkypCAxqGQ5JwuOnWpj310wFeghnSND/icxqG45U+h/H9bqchbJekViUC1nysyuqZ/e3BrqUdrkzCrkc9USA4uV03XsGmC21PhpNWZK1SLpDBkjstUE+VnwXhYeP1WaWorLg9oV35DOkTFaTrVur85a+A6wqXSOjBknNbCWM0VenbVwE+kMGTO7kM+J3aQhWs74c+e7khnSYkHdig9XNLXqLm2yxHZpQX7LCfCSdIA0GDOlWuQqlYwbJzm4CeX8l3QA07UWw5ZZ1Ut1jqDkZX7LOQH4WDqEyd4p1L4T6pqmSZtUyOdE7zsWL6fr2EXgn9I5TPbydP3dJeDv0gHEyxl7TDqAqeqWN328eHmzznaQrCbgQekQppRzPFAjHcJEL0xbMANd0yZpTxXyOfErsYwoZ7xEw8PSOUw0ee7igdIZMkh8lxYMKWfsbukApplRtWRyazEcKJ0jY6qA56VDgEHldB17OtHurYq9MLV6qXSGDLq/kM8ZMYWOMeWM3SUdwBS6pJ8YI3ZpwbxyPoEeGAJ0ST8hrxXyuVnSIVYyqpyuYzcB90nnMIEu6SfCmK0mGFbO2C1kfHFdXdJPRDUGnNtsy7hyuo79MXCPdA5JuqSfiD8U8rkG6RBtGVfO2B+BRukQEnRJPxFVGHgqz8hyuo5dBfxNOocEk5b0C1uaqB41lKr7zqPq3nNYPCHa61s281Wq7j2Hj35/NI3V7696fUMwnar7zqN65FCaP402/sWGej5+5ArCMBR5D+1k3FYTzL4s7PfAmUB36SBJMmpJv27dGeBeT0WPDQlbW1jwwCVsuMPe9Oj7FfoddzmLxtz+uZcvefNf9DtuOC11NSx951n6DDqTxa89zGYHnIhlGbve0nwM/Rhl5JYTwHXsucDt63xhGTFtST/LsqjosSEAYbEFiq1gWXTvuy3dt7C/+PqKSsKWJsLmRqxulTR/Wk1r/SI22M7ovfQrTNxqgtlbToBrgFOAftJBkhAv6ffFn3pBYbGV6pEX0vJpNZvslaPn1rus8bWbHXACi8bcjlXZg77/dxGf/uc+eh98SoJpO2wKMEo6xJoYu+UEcB17MXCFdI4kmLqkn1XRja3PuA373JE0Vs+iaWFhja/tMWAHtjrtz2x5Up6WxQvo1iv66LzwyT/wydM30Lrs04RSt9uvC/lcUTrEmhhdzti9RL/hyprpS/pVbNCLDbbbkxVz3lnna8MwpO71R9jsQJfFrz5E74NPYuM9DmPJ/55OIGm7PV/I516UDrE2xpczvp3sQukcpWbikn6ty+soNtQDUGxupKEw6Us/a65u2dSxbLjjt+i2QS/C5kawKsCyoj+boQEYKh1iXSzDD3Gv4vnBKOA06RylsKyxpfa6f7/bC8NWDmuq+ZBPnrkJwiKERTba9WB6H+Sy/L3XqX3pblqX11HRsxc9BmzPgMHXAlBsbqDmsd8yYPC1WN0qaZg3jdoX/oJVUUnfYy+hex8jdg6GFvK5m6VDrEuaytmbaI7bslth66l3glcmfrDoEOkcGfEycHghnzP+B9/43dqV4oNDQ6RzlIIu6ZeYOuCnaSgmpKicAK5jPwuMlM7RlXRJv0SdV8jn5kmHaK9UlTN2IRBIh+gquqRfYh4t5HMPSIfoiNSV03XsOuBkwIipJNaHLumXmCrgbOkQHZW6cgK4jj0euFI6x/rSJf0Sc0Yhn6uVDtFRqSxnLA+Mlg6xPnRJv0TcWcjnjJhNr6NSW07XsUOi624/kM7SGbqkXyLGAcOkQ3RWassJq06vHAfUC0fpMF3Sr+SmAT8s5HPGXJbUUakuJ4Dr2NOAHwPN0lnaS5f0K7l5wPcL+VyddJD1kfpyAriO/TzRjdmpoEv6ldRi4AeSy8V3lbIoJ4Dr2PcDI6RztIcu6VcyjcCxhXzuXekgXaFsygngOvb1wF+kc6yNLulXMkXg1EI+VzZLepRVOWPnAfdLh1gTXdKvZIYV8rmyWue17MoZr5T9MwydvU+X9CuJPxXyuVukQ3S1sisnrCromRg2F6ku6VcSIwr53CXSIUqhLMsJqy5SOBu4QzrLSrqkX5dqJvqMeb10kFIp23JCVFDXsc8DrpPOokv6daklRKdLUnWXSUeVdTlXch37CqLPoWIXKuiSfl1mPnBwIZ8bKx2k1DJRTgDXsUcCRwIi8zPqkn5dYiqwfyGfK/vZGCFD5QRwHfs/wAHAnCTH1SX9usTLRFvMsrnRfl0yVU4A17HfA/YBEptEVZf0W2/3UwbXynZUambfKwXPD4YRLZhUssWSWlqLTVc8MbUeQ1YOS5l64PxCPjdSOoiEzG0523Id+0bgIKBQqjFMWtIvZd4CnKwWEzJeTgDXsd8EHODhUvz7r8yoMWqi6BQoEs1ycWAhn0vljfRdJdO7tavz/OAY4E7omjVLFtU3Bjc8O3MbwNjFKQ0znWi+n/9KBzFB5recbbmO/RSwB9Fiquv9Wyte0k+LuW4twPXAXlrMz+iWcw08PzgUuAtY84KUa1EMw+IVj0+pNnnlMEO8DQwp5HO+dBDT6JZzDVzHHgd8jegWtIUd/X7Tl/QzwAzgBGCf9hbTsqxWy7ImWZb1rmVZky3LGmZZVkWb54dblvWBZVnvWZZ1ZPx3G1mWNdqyrJnx9/2+NG+n6+mWsx08P9gUuIxotvkN2/M9Nzw7Y+Ki+qYDSpkrpeYAvwUe6OjCtZZl1Ydh2Cv+c3/gIeC1MAyvsixrd8AD9iVa7Ool4KtAT2C/MAz/Y1lWD2AscH0Yhs912TsqES1nB3h+sC1wNXAqazk3auqSfsLmE92AcF8hn+vUNc5tyxn/9w5Ep1z6Ev3yJAzDfPzc88DVYRhOXO3fuAWYFobhXzv1LhKku7Ud4Dr2PNexfw7sCNwMLPuy1419d8FUtJgrLQQuAnYq5HN3dbaYXyYMwzlEP8P9iY6wt12kKGC1o+6WZfUGjibaehpPp8voBNex5wFDPT+4Fjg/fmyx8nld0g+AuURHvW8p5HOlnFfYWu1rW6t2Cy3LqiTa7b01LrXxtJzrwXXsWuC3nh/8CRgMnDW7pr5Xc2u4h3A0KcuBfxIt0/hyqdfBjHdrW4Eaoi3ltm2etokWMFrpHuD9MAxvLmWmrqSfObvYoJte2WN2Tf1PgZMow1W41+BVokI+WsjnSjbbw2oHhPoBDwIT4wNCexAdIFp5QGgssHMYhq2WZV0H7AacEIZhhw5CSdJylsjA4aMrgEFEB49+BGwsm6jLzSW6W2RUUpfZWZbVSnRPZ3eiCxf+Ady4snCWZY0AzoifuzAMw+csy7KJPovOJJrXFuD2MAzvTSLz+tByJmDg8NEbAPsDh8WP/UjfAaMG4L/AeKKt0vi0LN+eVlpOAQOHj94Q+DaflXUfSnjbWictBV4nKuN44M1CPtckGylbtJwGGDh89MbAgcChRJ+NtgcGApslFKGZ6La5acAEojJOKuRzqV89PM20nAYbOHz05nxW1O1X+3N/otMHFfHXtn9u+xVgEbAgflTHXz8CZsePeR29WkeVnpZTKUPpFUJKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZShtJxKGUrLqZSh/h8jL4BvYsfG6gAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "colors2 = sns.color_palette(\"Paired\")[0:2]\n",
    "\n",
    "labels = FnB_twenties['cop_c'].value_counts().index.tolist()\n",
    "ratio = FnB_twenties['cop_c'].value_counts().values.tolist()\n",
    "\n",
    "plt.pie(ratio, labels = labels, colors = colors2, autopct='%.0f%%')\n",
    "plt.show() #D01: 롯데리아, D02: 엔젤리너스"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d543d69f",
   "metadata": {},
   "source": [
    "## 주말 카페 이용 시간 비율"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "8f28f49e",
   "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>cust</th>\n",
       "      <th>rct_no</th>\n",
       "      <th>cop_c</th>\n",
       "      <th>br_c</th>\n",
       "      <th>chnl_dv</th>\n",
       "      <th>de_dt</th>\n",
       "      <th>vst_dt</th>\n",
       "      <th>de_hr</th>\n",
       "      <th>buy_am</th>\n",
       "      <th>data_time</th>\n",
       "      <th>weekday</th>\n",
       "      <th>weekend</th>\n",
       "      <th>ma_fem_dv</th>\n",
       "      <th>ages</th>\n",
       "      <th>zon_hlv</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>101770</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21090316D022558382</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020024</td>\n",
       "      <td>1</td>\n",
       "      <td>20210903</td>\n",
       "      <td>20210903</td>\n",
       "      <td>16</td>\n",
       "      <td>5500</td>\n",
       "      <td>2021-09-03</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101773</th>\n",
       "      <td>M529174515</td>\n",
       "      <td>21101115D022248354</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020491</td>\n",
       "      <td>1</td>\n",
       "      <td>20211011</td>\n",
       "      <td>20211011</td>\n",
       "      <td>15</td>\n",
       "      <td>4500</td>\n",
       "      <td>2021-10-11</td>\n",
       "      <td>0</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102269</th>\n",
       "      <td>M469589241</td>\n",
       "      <td>21041118D020812568</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020464</td>\n",
       "      <td>1</td>\n",
       "      <td>20210411</td>\n",
       "      <td>20210411</td>\n",
       "      <td>18</td>\n",
       "      <td>13100</td>\n",
       "      <td>2021-04-11</td>\n",
       "      <td>6</td>\n",
       "      <td>weekend</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102898</th>\n",
       "      <td>M752566035</td>\n",
       "      <td>21062211D020239196</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020397</td>\n",
       "      <td>1</td>\n",
       "      <td>20210622</td>\n",
       "      <td>20210622</td>\n",
       "      <td>11</td>\n",
       "      <td>3900</td>\n",
       "      <td>2021-06-22</td>\n",
       "      <td>1</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102899</th>\n",
       "      <td>M752566035</td>\n",
       "      <td>21111209D021217995</td>\n",
       "      <td>D02</td>\n",
       "      <td>D020152</td>\n",
       "      <td>1</td>\n",
       "      <td>20211112</td>\n",
       "      <td>20211112</td>\n",
       "      <td>9</td>\n",
       "      <td>10800</td>\n",
       "      <td>2021-11-12</td>\n",
       "      <td>4</td>\n",
       "      <td>weekday</td>\n",
       "      <td>여성</td>\n",
       "      <td>20대</td>\n",
       "      <td>Z16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              cust              rct_no cop_c     br_c  chnl_dv     de_dt  \\\n",
       "101770  M529174515  21090316D022558382   D02  D020024        1  20210903   \n",
       "101773  M529174515  21101115D022248354   D02  D020491        1  20211011   \n",
       "102269  M469589241  21041118D020812568   D02  D020464        1  20210411   \n",
       "102898  M752566035  21062211D020239196   D02  D020397        1  20210622   \n",
       "102899  M752566035  21111209D021217995   D02  D020152        1  20211112   \n",
       "\n",
       "          vst_dt  de_hr  buy_am  data_time  weekday  weekend ma_fem_dv ages  \\\n",
       "101770  20210903     16    5500 2021-09-03        4  weekday        여성  20대   \n",
       "101773  20211011     15    4500 2021-10-11        0  weekday        여성  20대   \n",
       "102269  20210411     18   13100 2021-04-11        6  weekend        여성  20대   \n",
       "102898  20210622     11    3900 2021-06-22        1  weekday        여성  20대   \n",
       "102899  20211112      9   10800 2021-11-12        4  weekday        여성  20대   \n",
       "\n",
       "       zon_hlv  \n",
       "101770     Z16  \n",
       "101773     Z16  \n",
       "102269     Z16  \n",
       "102898     Z16  \n",
       "102899     Z16  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cafe_twenty = twenties[twenties['cop_c']=='D02']\n",
    "cafe_twenty.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "2b8b3324",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAOcAAADnCAYAAADl9EEgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAZ6ElEQVR4nO3deZgU1b3G8e9vFpbpmUE22URBkJ10EIhaqHFBTUyMmmjS2kHNNcaFaKJtMFFyr141URO3mEWjxutVYqlxiYlGrztgo1GIpYJKVFAQRBAEnGH2c/+oGjMSlln7nOr+fZ6nH4aZnj7vwLxd1VWn64gxBqWUe4psB1BKbZuWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVcpSWUylHaTmVclSJ7QBq+zw/KAb2jG5DgMHAAKA/0A+oALpFt9IWfzYCVcBm4JPothlYB6wA3mtxW51NJXXBHAeJLmTkBs8PRgCTgXHA2OjPvYDuXTx0HfAW8HKL2z+yqeS6Lh5X7YSW04Joi/h5YP/oNg0YZDPTNrwPZIEngSezqeRblvMUHC1njnh+0Bf4KnA0MJ1wlzRO3gOeAp4AHsmmkhss58l7Ws4u5PnBnsAxhIWcBhRbDdR56oHHgXuAB7Op5EbLefKSlrOTeX5QBhwPnAocYDlOLtQB/wf8Ebg/m0rWWs6TN5wpp4g8A5xvjHlpB/c5BZhijPl+rnK1lucH+xAWMkX8dlk7y1rgD8CN2VRyueUssaenUjrA84Mi4DhgFuGR1kLXH7gA+JHnB48AvwUe1VM17dPuSQgiMktEzok+vlZEnoo+PlRE7hSRw0VkgYgsEpF7RaQ8+vpkEXlWRBaKyGMiMmirxy0SkdtF5LLo798RkaUi8izh67bm+x0lIi+IyD9E5AkRGRB97z9FpH+Lx3pLRPq19+fcFs8Punt+cDrwJnA3WsytFREe/HoEeNXzg3R0hFq1QUdmCM3lX6+ppgDlIlJKeGrgVWA2MN0YszfwEnBe9PUbgOOMMZMJd4Eub/GYJcAcYKkxZnZU3EsIS3kY4bm/ZvOBfY0xkwAfmGWMaQLuBNLRfaYDgTGmU87ZeX7Q0/ODHwHLgRuBkZ3xuHluPOH/yeueH8yI9jZUK3Rkt3YhMFlEKoBaYBFhSQ8AHiIs0nMiAuHMlQXAaGAC8Hj0+WJgdYvHvAm4xxjTXNh9gGeMMWsBRORuYFT0td2Au6MCdwOWRZ//A/Bn4DrgP4DbOvAzAuD5gQAzgMuAoR19vAK1F/C/wE88P5idTSXvtx3Ide1+FjPG1BNuQb5DeLJ6HnAwMIKwKI8bYz4f3cYZY04FBFjc4vMTjTGHt3jYLHCwiPRoOdR2ItwA/NoYMxE4HegR5VoBrBGRQwjL/bf2/owAnh8cQvhEdDtazM4wFrjP84MnPT8YbzuMyzq6izEXOD/6cx5wBuH0r+eBaSIyEkBEykRkFOFrtP4isl/0+VIRafkfdCvh65R7RaQEeAE4SET6RrvEx7e4by/CWSwAJ2+V6xbCXal7jDGN7fnBPD8Y7vnBXwlnyExqz2OoHToEeNnzg+s8P+hlO4yLOlrOeYTTzhYYY9YANcC8aDf0FOAuEXmFsKxjjDF1hEc3rxSRgLDIXssHNMZcQ7iLfAewBriYcJf4iejzzS4mLPE8wgndLT0ElNOOXVrPD4o8PzgXeA34Slu/X7VJCfADYKnnB6dYzuIcZ85zdiYRmQJca4xp0ySAaDfrVsLdYZV7jwDfzaaSq3d6zwKQd+UUkR8DZwJpY8z81nyP5wclwIXARYQHl5Q964Ezs6nkPbaD2JZ35Wwrzw+GAXcB+1qOoj7rLmBmIU+wL+hyen7wDcLdWD0g4aaVwDeyqeTfbQexoSDLGe3GXgWcazuL2qlawi3orbaD5FrBldPzg/7A/YQzmVR83ASck00l62wHyZWCKqfnB6MIjwiOsJ1FtcvzhLu5q2wHyYWCKafnBwcADwJ9LEdRHfMecHg2lXzTdpCuVhCTkD0/OIHwnftazPjbHZjv+cFU20G6Wt6X0/OD8wjf6dLVV7FTudMPeMrzg8NsB+lKeV3O6O1dVxNOuFf5pRx42PODlO0gXSVvX3NGxbzKdg7V5ZqAE7Op5N22g3S2vCyn5wezgCtt51A5U094FPcvtoN0prwrp+cHGeCXtnOonKsFvpJNJZ+0HaSz5FU5PT9IE77VTF9jFqYq4IhsKvmc7SCdIW/K6fnBQcBj6LtKCt1GwMumkktsB+movCin5wfjgOeAXSxHUW54B/hCNpX8yHaQjoj9qRTPDwYSTsnbxXIU5Y49Ca9TVGo7SEfEupzRP/4DwB62syjnfBH4je0QHRHrcgK/QN8krbbvNM8PzrEdor1i+5rT84OvA/fZzqGc1wBMi+MbtmNZzmgV6IXoFQxU67wNTMqmkpttB2mL2O3Wen7QHbgXLaZqvRHE8PVn7MoJ/Dd6kWfVdjM8PzjRdoi2iNVurecHUwjfDa8rVqn22AQk47J2aGy2nJ4fdCO8grsWU7VXJfB72yFaKzblJLzg8wTbIVTsHeb5wQzbIVojFru1nh98jnCNT2szPrasWs7SX8369O+1H77P0OPOpFufXVnxpxvZsmoZEy+9k/IR4bpMm978B8tu/RlSWspeZ19Bz4G701C1iaW/uoCxP/4t0RKIyo51wOhsKrnedpAdicuy87/BYjEBeg4eRvKKcIUA09TIwrMOp8/UQ2isq2H0edfwzi2Xfub+qx++g1Hn/pLatatY8/i9DJuRYeX9NzPk6FO1mPb1A35GuCqes5zfrY2uyu7UNWY3vvYCPQbsRvf+gykbsic9Bw/7t/tIcQlNdbU01dUgJSXUrFlB3YYP6TVuSu4Dq205LTrA6Cynt5zRQSDnrmiwLvsYfb0v7/A+Q47+D9655VKKunVn5FmX8+6caxh6/Fk5SqhaoYjw+lJftB1ke1zfcs7EsQtANzXUs2Hhs/TdZ8cXfksMG8PES+9g/E9vofbDlXTr3R+ApdfP4p+/vpC6j2P9bqZ8caDnB1+yHWJ7nC2n5wd9gJ/azrG1j1+eT2L4GLrt0rdV9zfGsPKBm9nt2O+x8r4bGXrcmfTb/yt88NgfuzipaqXLPT9w8iCAs+UELgB62w6xtXXZR+nntf7Jdu3ch+g96QBKyitprK2BoiKkSGiqrenClKoN9iZcbd05Tp5K8fxgF8LL7ldYjvIZjbVbWPT9LzHp+r9SUhZG++jFp1j+P1dQv2kDJWUVlA0bzbif/O7T+79x1dmM/cnvKCopZdMbi3jnDz+jqCQ6vTJI34bqiDeB8dlUstF2kJZcLedFwGW2c6iCMiObSt5pO0RLzu3Wen7QE/iB7Ryq4JxnO8DWnCsn8F2gv+0QquBM8vzAqdMqTpUzWnH6fNs5VMFyaqVzp8oJfJVwiTelbDgqusqGE1wrp9NzHVXeKwKcuSCYM0drPT8YRngxYCdPCKuCsR4YlE0l62wHcWnLeTJaTGVfH+BI2yHAkXJG06dOtp1Dqci3bQcAR8oJTAOG2w6hVOSr0Sw1q1wp57G2AyjVQnfgeNshXCnn0bYDKLWVE2wHsH601vODicArVkMo9e/qgb42rxLvwpZTt5rKRaXAdJsBXCjnMbYDKLUdVq+SYLWcnh/0I3yzq1Iu2vGForqY7S3n/ujEA+WuoZ4fjLc1uO1yHmB5fKV25hBbA2s5ldqxfWwNbK2cnh8k0KX8lPu+YGtgm1vOfXH8otZKASM9P7ByFUib5ZxscWylWkuAqTYGtlnOcRbHVqotrLzutFlOa4eolWqjz9kY1Eo5o/dvjrExtlLtYOW6Qra2nLsD5ZbGVqqtCqqc+npTxUml5we75npQW+XURUJU3IzM9YC2yjnI0rhKtVfOd21tlXOgpXGVaq/dcj2gbjmVap2czxLSLadSrdMn1wPaKucAS+Mq1V4FU85KS+Mq1V4FU85ulsZVqr0KppzdLY2rVHuV5XrAnJfT84NioDjX4yrVQTn/nbWx5dRdWhVHOS+njSsRaDm7yMDaHq9/fd0QPRLeBQxszPWYNsrZYGHMgjCxqtcaQcbazpGPBD7O9Zg2dmurATeW084ze9SU9bOdIY/V53rAnJczm0oawoKqTtSjsWh9N1Okb8XrOvlfzkiVpXHz1tjqyjcEsX0d4nym5VTtM6ZaJ111sU25HtBWOT+xNG5+MjT1bijVazJ1rRW5HtBWOT+0NG5e2q225xJBcj69rMC8l+sBbZUz589C+WxCVa+PbGcoAFpO1XZDa8t04kHXK5hyrrQ0bt4payxeW2pktO0cBaBgyqlbzk4yrqpyqSC6AHHXK5hy5vwHzVejqyv03GbX25jOJDbnelBb/7FvA02Wxs4bYmjo1Viqs4K6npWNiZVyZlPJGsKCqg7YvaZsiSC9bOcoAIVTzsirFsfOCxOqem2wnaFALLExqM1yvmxx7LwwpK7nYNsZCsR8G4PaLOcii2PHXkVDyepSU7SX7RwFwADP2RjYZjkXWhw79sZVVb5lO0OBeCOdSViZgWWtnNlU8gNAf8HaadSWCr3cS25Y2aUFu1tOgKcsjx9LRYa6isYSPYWSG/NsDWy7nE9bHj+WhtUkFgtSYTtHgdAtp2q9CVW9cv7G3wL1fjqTWGZrcKvlzKaSHwKLbWaIo0G1PYbazlAgrBylbWZ7ywnwpO0AcdKroXRFCUV72s5RIKy93gQ3yvmA7QBxMqGq0tpuVoExwEM2A7hQzrnAGtsh4mJkdUVP2xkKxNx0JmH13VPWy5lNJZuA+23niINiIzWJpuLxtnMUiDtsB7Bezsi9tgPEwZ5bEosFyflSdAWoBviT7RCulFN3bVthfFUvvd5vbvwlnUnkfOGirTlRzmwq2QjcYzuH6wbW9djDdoYCcaftAOBIOSM32g7gsj713ZYXI1rOrrcO+JvtEOBQObOp5BLC3Vu1DROqKvW6S7lxdzqTyPm6KNviTDkjv7MdwFUjtpSX285QIJzYpQX3ynkfemDo35Q0SVVPPYWSC0vSmcTztkM0c6qc2VSyHrjFdg7XjNxSvkSQ7rZzFIArbQdoyalyRn4NbLEdwiXjq3rV2M5QAJYDf7QdoiXnyhldIeFm2zlcsmt99+G2MxSAX6QziQbbIVoqsR1gO64ETgcKfleuX133t4uQETYzfPTxSm686zQ2bl6DSBEH7/sdvnTATN5d9Sq33fcDamo/oX/vPTgzfStlPSpZumwBt93/Q0qKuzPz27cxsN8IqrZ8zK/vOJlZpz2IuLd6xBrgD7ZDbM25LSdANpVchb72BGBiVaX1RZ+Kiko48aifc9WsRVx89tM88dzNvP/B69xyz0y+deQlXHH+35ky8SgefuY6AB559lf84KQ5fPPIi3kyG/43Pvj4lXzt0PNdLCbAFelMwrmXDk6WM3IFUGc7hG3Da8qtX9G9d+VAhu/2eQB69qhg8IDRrN+0mtVr/8mYPfcHYMKoQ3jxlT8DUFxcSl19DXV11RQXl7Jm3Tts2LSKsSMOsPUj7MgKHD2F52w5s6nkSgp81lC3pqJNPZqKnDqFsnb9u7z7fsCI3acwdOA4Fi1+GIAXggdYv/F9AL52yPnc+qezeXTebzhs2unc++glHHfET23G3pH/TmcStbZDbIuz5YxcTDidqiDtVV2+RJBS2zma1dR+wvW3p/n20VdS1qOS0771Wx7P/p7Z1+5PTe1mSorDq3XuMeRzXHLO01x05t9Y+9EydqkchMFwwx0n8ds/nsrGzc6cyl4K3GY7xPY4Xc5sKrkBcPYpt6uNq6505uhhQ2M919+extv7W0ydeDQAg3cdzY+/9xCXnTuf/SYdz659P3tQ2RjDg09exbHTL+CB//s53zjiIqbtneKx+c7sRf44nUk02g6xPU6XM/J7CnRdlX713UfazgBhyW655ywGDxjNkV88+9PPb9z8IQBNTU38+YmrOHS/Uz/zffNemsPnxx5Boqw3tfXViBRRJEXU1TlxGvu+dCbh9CVyXD2V8qlsKtnk+cE5FNik+AF13ZcWIaNs5wBYunwB8xfexdBB47nwmv0A+OaXL+aDdW/xxHPhKekpE7/GgVNnfPo9tXXVzHtpDhd8L7wMz5cPPJvrb09TUtyNmd+2vie5HphpO8TOiDHGdoZW8fzgTiBtO0euHLp+12fHbKn8ou0ceerkdCbxv7ZD7EwcdmubnQOsth0iV4bVJPrYzpCn/haHYkKMyplNJdcDp9nOkQvdm4o+7m6KdC2UzreZcOZZLMSmnADZVPJhHJxm1dnGVFe8Lkix7Rx5aFY6k1hhO0RrxaqckR8C79oO0ZXGVlU22c6Qh54BbrIdoi1iV85sKrkZOAVw9vxUhxhMn4ZuThylzSPVwHfTmUQ8jn5GYldOgGwq+Qxwoe0cXWFwXY/XBelvO0ceMcBJ6UzibdtB2iqW5QTIppJXEV7WJK9MqOq11naGPPNf6Uwilr8nsS1n5DvAG7ZDdKY9ahL9bGfII346k7jUdoj2inU5o9efxxIeIo+9no3F60qNjLWdI0+8SPjkHVuxLidANpV8AziRPDhANLa68k1BYv9/4oD3gaNdfAN1W+TFL0I2lfwrMZgruTNjqiucvExAzFQTFjP2s8nyopwA2VTyJiC2ry/E0LhLQ6nu0naMAU5JZxILbQfpDHlTToBsKvmfxPTqCbvV9lwiSG/bOWLuonQmkTfLSeZVOSMzgbtsh2irCVW91tvOEHM/SmcSP7cdojPlXTmjlbJnALF450GzobVlA2xniCkDnJXOJH5pO0hny7tywqfrfZ5CTOZSJhqL15QYGW07Rww1Er7GdOa6J50pNm+2bi/PD64lnCzvrKmb+sz/wuY++9vOETN1wIlxnf3TGnm55Wwpm0qeC1xuO8eOjK6ucP5yMY7ZAhyTz8WEAignQDaVnE34JlsnFkVtSQwNlY0l+sbq1vsEODKdSTix+nRXKohyAmRTyd8DRxBe3MkZe9QkFgtSaTtHTHwATE9nEs/YDpILBVNOgGwq+TSwD/Cm7SzNJlRVbrCdISaeA/ZOZxIv2A6SKwVVToBsKvkWsC/wmO0sAENqew6xnSEGbgAOzocpeW2R90drt8fzAwF+BFwGWFnyoKKhZNVJa4YNtjF2THwCnJ7OJJxa1DZXCraczTw/mEo4oyjna2Duu7HvvMmf9HZy6S0HvASckM4k3rIdxJaC263dWjaVfBGYBNyZ67FHbSkv+MWBt8EAVwFeIRcTdMv5GZ4ffBO4HhjY1WMVGerOWDWiXpBEV48VI+8Q7sY+keuBReQZ4HxjzEud+JgHRY/51fZ8f8FvOVvKppL3AGMJp/116bPW8C3lr2kxP1UFzAbG2Simq7ScW8mmkh9nU8kzgGnAa101zoSqyry4tEonuAsYk84kLm/LIrYiMktEzok+vlZEnoo+PlRE7hSRw0VkgYgsEpF7RaQ8+vpkEXlWRBaKyGMiMmirxy0SkdtF5DIRKRaRX4jIiyLyioicHt3nIBF5RkT+JCJviMgcEZHoa1+KPjcf+HpH/mG0nNuRTSUXEL4WPR/o9HORg+p67t7ZjxkzLwMHpjOJE9OZxMp2fP9coPlg2hSgXERKgf2BVwm3xNONMXsTHlw6L/r6DcBxxpjJhKsHtJzaWQLMAZYaY2YDpwIbjTFTganAaSLSvAjpJMI52+OAPYFpItIDuBk4KsrWoZdHWs4dyKaSDdlU8mrCf/yfE14Co8N2qS99rxgZvvN75qV1wBnA5HQmMa8Dj7MQmCwiFUAtsICwpAcQzr0dBzwnIi8DJwN7AKOBCcDj0ednA7u1eMybgNeMMc2FPRw4KbrvC0BfYK/oa383xqw0xjQRPtEMA8YAy4wx/zThwZwOHWTUCdetkE0lPwYu9PzgBuA/ge/SgX+78VW9lgOFtuWsAm4BLklnEh3eEzHG1IvIcsIr7GWBV4CDCU+JLQMeN8ac0PJ7RGQisNgYs992HjYLHCwiVxtjagABzjbGfGbCSnSgp+UueCP/+n3otGMVuuVsg2wquTqbSp5J+Az5O9q5JR25pbysU4O5bQVwATA0nUn8sDOK2cJcwpcdc4F5hFvkl4HnCXczRwKISJmIjCKcttlfRPaLPl8qIuNbPN6twCPAvSJSQjiL7MxodxgRGSWyw4N4bwDDRaT5nPkJO7jvTumWsx2yqeTbwFmeH/yU8BdiJjBox98VKjayJdFUPH7n94y954HrCJd3b+iiMeYBFwELjDFVIlIDzDPGrBWRU4C7RKT5XPJsY8xSETkO+JWI9CL8/b8OWNz8gMaYa6Kv3UG4WPMwYFF0wGctcMz2whhjakTke8DDIrIOmE+4G90uep6zE3h+0I3wWfL7hK97tmtUdcVLh20YsMP7xFgD4RIZ16Uziedth4k7LWcn8/xgLHAS4bPu0K2/fuzaIXMH1/U8MOfButa7gA/8Jk7rX7pOy9lFPD8oAg4ivNjYMcAuAGe8P2JFMfJvpY2hhcCfgYfSmURgO0w+0nLmgOcHJcD+lQ0l02esGXYs4WH+uKkDniYs5F/aeW5StYGW04I5V1cNBqa3uLXqYFKONREe3XyB8Ajmo+lMQmc15ZCW0wFzrq7aFRhPuEUd3+LjXC0HuIWwiIuBfxCu0LUonUl8kqPx1TZoOR0Wlba5sGOAPkBFdCvf6uNyPnveup5w2uH2buuBt4AlwLJ0JtHU9T+RagstZ56Yc3WVAGXRrSqdSXTKVENlj5ZTKUfp9D2lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHKXlVMpRWk6lHPX/La72+5nnsHgAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "colors3 = sns.color_palette(\"husl\", 8)[5:7]\n",
    "\n",
    "labels = cafe_twenty['weekend'].value_counts().index.tolist()\n",
    "ratio = cafe_twenty['weekend'].value_counts().values.tolist()\n",
    "\n",
    "plt.pie(ratio, labels = labels, colors = colors3, autopct='%.0f%%')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "26d7d452",
   "metadata": {},
   "source": [
    "## 카페 이용 시간대"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "f5234ce0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='de_hr', ylabel='count'>"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEHCAYAAABBW1qbAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAYNElEQVR4nO3df/BddX3n8eeLoKioFUpCI2E3yKQqMAKapW6p1IJV/FGCFhw6VbMVh90OKri6XVhXamUyg624ddxiJ4s/4g/EiCKpzio0LdraCgYETEAkCEIkkqh1sTqLgu/945ycvSTfH+d+4Xy/3yTPx8x37rnnft73vL/f77n3dc85956bqkKSJIB95roBSdL8YShIkjqGgiSpYyhIkjqGgiSps+9cN/BoHHTQQbV06dK5bkOSdis33HDDD6pq4US3DRoKSZ4GXAocBRTweuB24FPAUuBu4NVV9S/t+POBM4GHgTdX1Zemuv+lS5eyYcOGgbqXpD1Tku9OdtvQu4/eB3yxqp4FHA3cBpwHrK+qZcD69jpJjgDOAI4ETgYuSbJg4P4kSSMGC4UkTwVOAD4IUFU/r6ofAyuANe2wNcCp7fQK4PKqerCq7gI2A8cN1Z8kaVdDbik8A9gOfDjJN5JcmmR/4OCq2grQXi5qxx8C3DtSv6Wd9whJzkqyIcmG7du3D9i+JO19hgyFfYHnAh+oqmOBn9LuKppEJpi3yzk4qmp1VS2vquULF054nESSNENDhsIWYEtVXddev4ImJO5Pshigvdw2Mv7QkfolwH0D9idJ2slgoVBV3wfuTfLMdtZJwK3AOmBlO28lcFU7vQ44I8l+SQ4DlgHXD9WfJGlXQ39O4U3AJ5I8HvgO8Ec0QbQ2yZnAPcDpAFW1KclamuB4CDi7qh4euD9J0ohBQ6GqbgKWT3DTSZOMXwWsGrInSdLkPM2FJKmzW5/mQprvtm26uffYRUcePWAnUj9uKUiSOm4pSOLile/qPfatay4YsBPNNbcUJEkdtxSkeWjjFet6jz3qtFMG7ER7G7cUJEkdQ0GS1DEUJEkdjylIe5AvXLi699iXv+OsATvR7sotBUlSx1CQJHUMBUlSx1CQJHUMBUlSx1CQJHUMBUlSx1CQJHUMBUlSx1CQJHUMBUlSx1CQJHUMBUlSx1CQJHUMBUlSx1CQJHUMBUlSZ9BQSHJ3km8muSnJhnbegUmuSXJHe3nAyPjzk2xOcnuSlwzZmyRpV7OxpfA7VXVMVS1vr58HrK+qZcD69jpJjgDOAI4ETgYuSbJgFvqTJLXmYvfRCmBNO70GOHVk/uVV9WBV3QVsBo6b/fYkae81dCgUcHWSG5Ls+Jbwg6tqK0B7uaidfwhw70jtlnbeIyQ5K8mGJBu2b98+YOuStPfZd+D7P76q7kuyCLgmybemGJsJ5tUuM6pWA6sBli9fvsvtkqSZG3RLoaruay+3AVfS7A66P8ligPZyWzt8C3DoSPkS4L4h+5MkPdJgoZBk/yRP2TENvBjYCKwDVrbDVgJXtdPrgDOS7JfkMGAZcP1Q/UmSdjXk7qODgSuT7FjOZVX1xSRfB9YmORO4BzgdoKo2JVkL3Ao8BJxdVQ8P2J8kaSeDhUJVfQc4eoL5PwROmqRmFbBqqJ4kSVPzE82SpI6hIEnqGAqSpI6hIEnqGAqSpI6hIEnqGAqSpI6hIEnqGAqSpM7QZ0mVtAd73Qvf0HvsR6+9dMBO9FhxS0GS1HFLQdKse87hx/cee8udXx2wE+3MLQVJUsdQkCR1DAVJUsdjCpJ2G9s23dx77KIjd/k6F/XgloIkqWMoSJI6hoIkqWMoSJI6hoIkqWMoSJI6hoIkqWMoSJI6hoIkqWMoSJI6g4dCkgVJvpHk8+31A5Nck+SO9vKAkbHnJ9mc5PYkLxm6N0nSI83GlsI5wG0j188D1lfVMmB9e50kRwBnAEcCJwOXJFkwC/1JklqDhkKSJcDLgdHv4VsBrGmn1wCnjsy/vKoerKq7gM3AcUP2J0l6pKG3FP4S+BPglyPzDq6qrQDt5aJ2/iHAvSPjtrTzJEmzZLBQSPIKYFtV3dC3ZIJ5NcH9npVkQ5IN27dvf1Q9SpIeacgtheOBU5LcDVwOnJjk48D9SRYDtJfb2vFbgENH6pcA9+18p1W1uqqWV9XyhQsXDti+JO19BguFqjq/qpZU1VKaA8h/V1WvAdYBK9thK4Gr2ul1wBlJ9ktyGLAMuH6o/iRJu5qLb167CFib5EzgHuB0gKralGQtcCvwEHB2VT08B/1J0l5rVkKhqq4Frm2nfwicNMm4VcCq2ehJ0t5j4xXreo896rRTBuxk/vMTzZKkjqEgSeoYCpKkjqEgSeoYCpKkjqEgSeoYCpKkjqEgSeoYCpKkjqEgSeoYCpKkjqEgSeoYCpKkjqEgSeoYCpKkjqEgSeoYCpKkTq9QSLK+zzxJ0u5tyq/jTPIE4EnAQUkOANLe9FTg6QP3JkmaZdN9R/N/BM6lCYAb+P+h8ADwV8O1JUmaC1OGQlW9D3hfkjdV1ftnqSdJ0hyZbksBgKp6f5LfBJaO1lTVRwfqS5I0B3qFQpKPAYcDNwEPt7MLMBQkaQ/SKxSA5cARVVVDNiNJmlt9P6ewEfi1IRuRJM29vlsKBwG3JrkeeHDHzKo6ZZCuJElzom8ovHPIJiRJ80Pfdx99edw7bj/49hVgv3Y5V1TVnyY5EPgUzTuZ7gZeXVX/0tacD5xJczD7zVX1pXGXK0maub6nufhJkgfan/+b5OEkD0xT9iBwYlUdDRwDnJzk+cB5wPqqWgasb6+T5AjgDOBI4GTgkiQLZvRbSZJmpFcoVNVTquqp7c8TgN8H/uc0NVVV/9pefVz7U8AKYE07fw1waju9Ari8qh6sqruAzcBx4/wykqRHZ0ZnSa2qzwEnTjcuyYIkNwHbgGuq6jrg4Kra2t7PVmBRO/wQ4N6R8i3tvJ3v86wkG5Js2L59+0zalyRNou+H1141cnUfms8tTPuZhap6GDgmydOAK5McNdViJrqLCe5zNbAaYPny5X5uQrPiOYcf33vsLXd+dcBOpGH1fffR741MP0RzgHhF34VU1Y+TXEtzrOD+JIuramuSxTRbEdBsGRw6UrYEuK/vMiRJj17fdx/90bh3nGQh8Is2EJ4IvAh4N7AOWAlc1F5e1ZasAy5L8l6as7IuA64fd7mSpJnru/toCfB+4HiaXTr/CJxTVVumKFsMrGnfQbQPsLaqPp/kn4G1Sc4E7gFOB6iqTUnWArfSbI2c3e5+kiTNkr67jz4MXEb7BA68pp33u5MVVNUtwLETzP8hcNIkNauAVT17kiQ9xvqGwsKq+vDI9Y8kOXeAfiRp3vjChat7j335O84asJPZ0/ctqT9I8pr2LaYLkrwG+OGQjUmSZl/fUHg98Grg+8BW4DRg7IPPkqT5re/uowuBlSPnKDoQeA9NWEiS9hB9txSesyMQAKrqR0xwEFmStHvrGwr7JDlgx5V2S6HvVoYkaTfR94n9YuCfklxB8zmFV+NbRyVpj9P3E80fTbKB5iR4AV5VVbcO2pkkadb13gXUhoBBIEl7sBmdOluStGcyFCRJHUNBktQxFCRJHUNBktTxA2jaLV288l29x751zQUDdiLtWQwFzam98dTE0nzm7iNJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUmewUEhyaJK/T3Jbkk1JzmnnH5jkmiR3tJcHjNScn2RzktuTvGSo3iRJExtyS+Eh4K1V9Wzg+cDZSY4AzgPWV9UyYH17nfa2M4AjgZOBS5IsGLA/SdJOBguFqtpaVTe20z8BbgMOAVYAa9pha4BT2+kVwOVV9WBV3QVsBo4bqj9J0q5m5ZhCkqXAscB1wMFVtRWa4AAWtcMOAe4dKdvSztv5vs5KsiHJhu3btw/atyTtbQYPhSRPBj4DnFtVD0w1dIJ5tcuMqtVVtbyqli9cuPCxalOSxMChkORxNIHwiar6bDv7/iSL29sXA9va+VuAQ0fKlwD3DdmfJOmRBvvmtSQBPgjcVlXvHblpHbASuKi9vGpk/mVJ3gs8HVgGXD9Uf9o7ve6Fb+g99qPXXjpgJ9L8NOTXcR4PvBb4ZpKb2nn/jSYM1iY5E7gHOB2gqjYlWQvcSvPOpbOr6uEB+5Mk7WSwUKiqf2Ti4wQAJ01SswpYNVRPkqSp+YlmSVLHUJAkdQwFSVLHUJAkdQwFSVLHUJAkdQwFSVLHUJAkdQwFSVLHUJAkdQwFSVLHUJAkdQwFSVLHUJAkdYb8PgVJ2itdvPJdvce+dc0FA3YyPrcUJEkdQ0GS1DEUJEkdQ0GS1DEUJEkdQ0GS1DEUJEkdQ0GS1DEUJEkdQ0GS1DEUJEmdwUIhyYeSbEuycWTegUmuSXJHe3nAyG3nJ9mc5PYkLxmqL0nS5IbcUvgIcPJO884D1lfVMmB9e50kRwBnAEe2NZckWTBgb5KkCQwWClX1FeBHO81eAaxpp9cAp47Mv7yqHqyqu4DNwHFD9SZJmthsH1M4uKq2ArSXi9r5hwD3jozb0s7bRZKzkmxIsmH79u2DNitJe5v5cqA5E8yriQZW1eqqWl5VyxcuXDhwW5K0d5ntULg/yWKA9nJbO38LcOjIuCXAfbPcmyTt9WY7FNYBK9vplcBVI/PPSLJfksOAZcD1s9ybJO31Bvs6ziSfBF4IHJRkC/CnwEXA2iRnAvcApwNU1aYka4FbgYeAs6vq4aF6kyRNbLBQqKo/mOSmkyYZvwpYNVQ/kqTpzZcDzZKkecBQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUsdQkCR1DAVJUmew72iWJI3ndS98Q++xH7320kF6cEtBktRxS0GPiY1XrBtr/FGnnTJQJ5IeDbcUJEkdtxQkaTf3nMOP7z32lju/OuXtbilIkjp79ZbCOPvB95Z94Ns23TzW+EVHHj1QJ5Lmwh4RCuM8kfkkJkmTm3ehkORk4H3AAuDSqrpojlvaLY2zjxGm388oae8wr0IhyQLgr4DfBbYAX0+yrqpundvOHukLF67uPfbl7zhrwE4k6bE1r0IBOA7YXFXfAUhyObACmFehMFMXr3xX77FvXXNBNz0fPuUoae+QqprrHjpJTgNOrqo3tNdfC/xGVb1xZMxZwI6X388Ebp/k7g4CfjCDNqyzzrq5qdsdetxT6v5tVS2c8Jaqmjc/wOk0xxF2XH8t8P4Z3tcG66yzbvep2x163Bvq5tvnFLYAh45cXwLcN0e9SNJeZ76FwteBZUkOS/J44AxgvJPqSJJmbF4daK6qh5K8EfgSzVtSP1RVm2Z4d/3fImSdddbNh7rdocc9vm5eHWiWJM2t+bb7SJI0hwwFSVJnjwyFJCcnuT3J5iTn9az5UJJtSTaOuaxDk/x9ktuSbEpyTs+6JyS5PsnNbd2fjbHMBUm+keTzY/Z6d5JvJrkpyYYx6p6W5Iok32p/z3/fo+aZ7XJ2/DyQ5NwedW9p/x4bk3wyyRN69nhOW7NpuuVM9L9OcmCSa5Lc0V4e0KPm9HZ5v0yyfIxl/UX7t7wlyZVJntaz7sK25qYkVyd5ep+6kdvelqSSHNRzee9M8r2R/+HL+i4vyZvax+CmJH/ec3mfGlnW3Ulu6ll3TJKv7VivkxzXs+7oJP/cPib+JslTJ6ib8PHdY32ZrG7KdWaKuinXmSnqpl1ndjGT97HO5x+aA9R3As8AHg/cDBzRo+4E4LnAxjGXtxh4bjv9FODbPZcX4Mnt9OOA64Dn91zmfwYuAz4/Zq93AwfN4G+6BnhDO/144Gkz+J98n+YDM1ONOwS4C3hie30t8B963P9RwEbgSTRvnvhbYNk4/2vgz4Hz2unzgHf3qHk2zQcorwWWj7GsFwP7ttPv3nlZU9Q9dWT6zcBf912Pad7q/SXguxOtA5Ms753A26b5209U9zvt/2C/9vqivn2O3H4xcEHP5V0NvLSdfhlwbc+6rwO/3U6/HrhwgroJH9891pfJ6qZcZ6aom3KdmaJu2nVm5589cUuhO1VGVf0c2HGqjClV1VeAH427sKraWlU3ttM/AW6jeXKbrq6q6l/bq49rf6Y96p9kCfByYFbOZ9G+ejoB+CBAVf28qn485t2cBNxZVd/tMXZf4IlJ9qV5ku/zOZVnA1+rqp9V1UPAl4FXTjZ4kv/1Cprwo708dbqaqrqtqib7RP1UdVe3fQJ8jebzOH3qHhi5uj8TrC9TrMf/A/iTiWqmqZvSJHV/DFxUVQ+2Y7aNs7wkAV4NfLJnXQE7XuX/ChOsM5PUPRP4Sjt9DfD7E9RN9viebn2ZsG66dWaKuinXmSnqpl1ndrYnhsIhwL0j17fQ40n6sZBkKXAszav+PuMXtJvI24BrqqpP3V/SPLh/OYMWC7g6yQ1pThfSxzOA7cCH0+yyujTJ/mMu9wwmeIDv0lzV94D3APcAW4H/U1VX97j/jcAJSX41yZNoXi0eOk3Nzg6uqq1tH1uBRWPWz9Trgf/dd3CSVUnuBf4QuGC68W3NKcD3qmq8L8tovLHd/fChnXeRTOHXgRckuS7Jl5P8uzGX+QLg/qq6o+f4c4G/aP8u7wHO71m3EdjxRSmnM806s9Pju/f6Mu7zQo+6KdeZnevGXWf2xFDIBPMGf99tkicDnwHO3SmdJ1VVD1fVMTSpf1ySo6ZZxiuAbVV1wwzbPL6qngu8FDg7yQk9aval2ez+QFUdC/yUZnO5lzQfQjwF+HSPsQfQvAI7DHg6sH+S10xXV1W30WxSXwN8kWaX4UNTFs0DSd5O0+cn+tZU1dur6tC25o3TjW9D8u30DJCdfAA4HDiGJqQv7lm3L3AA8HzgvwBr21f/ff0BPV5EjPhj4C3t3+UttFu1Pbye5nFwA80ul59PNnAmj+8h6qZbZyaqG3ed2RNDYdZPlZHkcTT/iE9U1WfHrW93x1wLnDzN0OOBU5LcTbNb7MQkHx9jOfe1l9uAK2l2tU1nC7BlZCvmCpqQ6OulwI1VdX+PsS8C7qqq7VX1C+CzwG/2WUhVfbCqnltVJ9DsJuj7KnOH+5MsBmgvd9nl8VhKshJ4BfCH1e7wHdNlTLC7YwKH04Tsze16swS4McmvTVdYVfe3L1x+Cfwv+q0v0Kwzn213kV5Ps1W7y8HtibS7DV8FfKrnsgBW0qwr0Lz46NVnVX2rql5cVc+jCaE7J+lposf3tOvLTJ8XJqubbp3psbxe68yeGAqzeqqM9hXQB4Hbquq9Y9Qt3PEOgiRPpHlC/NZUNVV1flUtqaqlNL/X31XVtK+k22Xsn+QpO6ZpDlxN+06rqvo+cG+SZ7azTmK8U5mP86rvHuD5SZ7U/l1Potk3Oq0ki9rLf0PzpDLOK01o1pGV7fRK4Kox63tL80VS/xU4pap+NkbdspGrpzDN+gJQVd+sqkVVtbRdb7bQHJD8fo/lLR65+kp6rC+tzwEntvfx6zRvTuh7ls8XAd+qqi09x0Pzou+32+kT6fmCYGSd2Qf478BfTzBmssf3lOvLo3hemLBuunVmirqx15kpj0Lvrj80+5S/TZP8b+9Z80maTeRf0DxwzuxZ91s0u6duAW5qf17Wo+45wDfauo1M8E6LaepfyBjvPqI5NnBz+7Op79+lrT0G2ND2+jnggJ51TwJ+CPzKGMv6s3bF3Qh8jPYdLD3q/oEmrG4GThr3fw38KrCe5gllPXBgj5pXttMPAvcDX+q5rM00x712rC8TvYtoorrPtH+XW4C/oTmQONZ6zCTvQJtkeR8Dvtkubx2wuGfd44GPt73eCJzYt0/gI8B/GvN/91vADe3//jrgeT3rzqF5nvg2cBHtGR76PL57rC+T1U25zkxRN+U6M0XdtOvMzj+e5kKS1NkTdx9JkmbIUJAkdQwFSVLHUJAkdQwFSVLHUJAkdQwFaUxpTin9tjFrPpLktKF6kh4rhoI0TyRZMNc9SIaC1EOSt6f50pi/pTnlMkkOT/LF9qyz/5DkWdPczQlJ/inJd3ZsNSR5YfvlKJfRfHpYmlP7znUD0nyX5Hk055o6luYxcyPNaRVW05yS4Y4kvwFcQnvOn0kspjkdwbNoThtxRTv/OOCoqrprmN9A6s9QkKb3AuDKak9ElmQd8ASaM7h+euSs0PtNcz+fq+aMo7cmOXhk/vUGguYLQ0HqZ+eThO0D/Lia78Po68GR6dHvF/jpTJuSHmseU5Cm9xXglUme2J5+/PeAnwF3JTkdmlMXJzl6LpuUHguGgjSNar779lM0pyP+DM1puqH5esMzk+w4Hfm03wUuzXeeOluS1HFLQZLU8UCz9Bhqv1j99J1mf7qqVs1FP9K43H0kSeq4+0iS1DEUJEkdQ0GS1DEUJEmd/wd23lbqYJI6lQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#전체 기준\n",
    "p2 = sns.cubehelix_palette()\n",
    "sns.countplot(x=cafe_twenty['de_hr'],palette=p2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "4b067b72",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='de_hr', ylabel='count'>"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEHCAYAAABBW1qbAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAVsklEQVR4nO3dfbBddX3v8feXhEcfKjQHGkm8xzrRNjIVNE1zC1Jv8LZgKUFrGDrVSa/pYDtQwJbbQrm2dpjMYEVvq9ZWrlFTFSHiA5EZCxiLlGkDJgiaB5VYIhyJSXyqVmeiid/7x1r5dXOyz95rH7POPjnn/Zo5s9de5/fd63vOWft89nrYa0dmIkkSwDHDbkCSNH0YCpKkwlCQJBWGgiSpMBQkScXcYTfw05g3b16Ojo4Ouw1JOqps2bLlm5k50u17R3UojI6Osnnz5mG3IUlHlYj42kTfc/eRJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTiq39EsTXebdu1qPHaZl2zRNOCWgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVrYdCRMyJiM9HxJ31/VMi4p6IeLS+Pblj7HURsTMivhwRv9F2b5Kkp5qKLYWrgB0d968FNmbmImBjfZ+IWAxcCrwQOB94V0TMmYL+JEm1VkMhIhYAvwm8p2P2CmBdPb0OuLhj/q2ZuT8zHwN2Akvb7E+S9FRtbyn8DfCnwE865p2WmbsB6ttT6/mnA090jBur50mSpkhroRARFwJ7M3NL05Iu87LL414WEZsjYvO+fft+qh4lSU/V5pbC2cBFEbELuBVYHhEfBPZExHyA+nZvPX4MWNhRvwB4cvyDZubNmbkkM5eMjIy02L4kzT5z23rgzLwOuA4gIl4GXJOZr4mItwCrgBvr2zvqkg3ALRHxNuDZwCLgwbb6k6aztZ/Z1Hjs6uXLWuxEs01rodDDjcD6iFgNPA6sBMjMbRGxHtgOHAAuz8yDQ+hPkmatKQmFzLwXuLee/hZw3gTj1gBrpqInSdLhfEezJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEnFMK59JGmaWX3NOxuPXXvTFS12omFzS0GSVLilIM0gb3z3Hf0H1W54/YoWO9HRyi0FSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVIxt60HjogTgPuA4+vl3J6ZfxkRpwC3AaPALuCSzPxOXXMdsBo4CFyZmXe11Z+k4Vm86JzGY7c/en+LnWi8NrcU9gPLM/NFwJnA+RGxDLgW2JiZi4CN9X0iYjFwKfBC4HzgXRExp8X+JEnjtBYKWfnP+u6x9VcCK4B19fx1wMX19Arg1szcn5mPATuBpW31J0k6XKvHFCJiTkQ8DOwF7snMB4DTMnM3QH17aj38dOCJjvKxet74x7wsIjZHxOZ9+/a12b4kzTqthkJmHszMM4EFwNKIOKPH8Oj2EF0e8+bMXJKZS0ZGRo5Qp5IkmKKzjzLzu8C9VMcK9kTEfID6dm89bAxY2FG2AHhyKvqTJFXaPPtoBPhxZn43Ik4EXg68GdgArAJurG/vqEs2ALdExNuAZwOLgAfb6k/S0WfTrl2Nxy4bHW2tj5mstVAA5gPr6jOIjgHWZ+adEfFvwPqIWA08DqwEyMxtEbEe2A4cAC7PzIMt9idJGqe1UMjMLwBndZn/LeC8CWrWAGva6kmS1JvvaJYkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpKLNdzRLmuEuuPDKxmM/defbW+xER4qhIGnGW/uZTY3Hrl6+rMVOpj93H0mSCkNBklQYCpKkwlCQJBWNQiEiNjaZJ0k6uvU8+ygiTgBOAuZFxMn81+coP5Pq09EkSTNIv1NSXw9cTRUAW/ivUPge8HfttSVJGoaeoZCZfwv8bUT8UWa+Y4p6kiQNSaM3r2XmOyLiV4HRzprM/MeW+pIkDUGjUIiIDwDPAx4GDtazEzAUJGkGaXqZiyXA4szMNpuRJA1X0/cpbAV+rs1GJEnD13RLYR6wPSIeBPYfmpmZF7XSlSRpKJqGwpvabEKSND00Pfvos203IkkavqZnH32f6mwjgOOAY4EfZOYz22pMkjT1mm4pPKPzfkRcDCxtoyFJ0vBM6iqpmfkJYPmRbUWSNGxNdx+9quPuMVTvW/A9C5I0wzQ9++i3OqYPALuAFUe8G0nSUDU9pvC/2m5Es9Mb331H47E3vN7XIVLbmu4+WgC8AzibarfR/cBVmTnWYm/StLF40TmNx25/9P4WO5Ha1fRA8/uADVSfq3A68Ml6niRpBmkaCiOZ+b7MPFB/vR8YabEvSdIQNA2Fb0bEayJiTv31GuBbbTYmSZp6TUPhdcAlwDeA3cCrAQ8+S9IM0/SU1BuAVZn5HYCIOAW4iSospCm3+pp3Nh679qYrWuxEmlmabin80qFAAMjMbwNntdOSJGlYmobCMRFx8qE79ZZCz62MiFgYEf8cETsiYltEXHWoNiLuiYhH69vOx70uInZGxJcj4jcm8wNJkiav6e6jtwL/GhG3U71P4RJgTZ+aA8CfZOZDEfEMYEtE3AP8HrAxM2+MiGuBa4E/i4jFwKXAC6lOff10RDw/Mw9O8PiSpCOs0ZZCZv4j8NvAHmAf8KrM/ECfmt2Z+VA9/X1gB9V7HFYA6+ph64CL6+kVwK2ZuT8zHwN24pVYJWlKNd1SIDO3A9sns5CIGKU6BvEAcFpm7q4fc3dEnFoPOx3Y1FE2Vs8b/1iXAZcBPOc5z5lMO5KkCUzq0tmDiIinAx8Frs7M7/Ua2mXeYVdizcybM3NJZi4ZGfH9c5J0JLUaChFxLFUgfCgzP1bP3hMR8+vvzwf21vPHgIUd5QuAJ9vsT5L0VK2FQkQEsBbYkZlv6/jWBmBVPb0KuKNj/qURcXxEPBdYBDzYVn+SpMM1PqYwCWcDrwW+GBEP1/P+HLgRWB8Rq4HHgZUAmbktItZTHbc4AFzumUeShmk2Xtq9tVDIzPvpfpwA4LwJatbQ/1RXSVJLWj/QLEk6ehgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklS0+XGc0rRzwYVXNh77qTvf3mIn0vTkloIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSpa+4zmiHgvcCGwNzPPqOedAtwGjAK7gEsy8zv1964DVgMHgSsz8662epOkNq2+5p2Nx6696YoWOxlcm1sK7wfOHzfvWmBjZi4CNtb3iYjFwKXAC+uad0XEnBZ7kyR10VooZOZ9wLfHzV4BrKun1wEXd8y/NTP3Z+ZjwE5gaVu9SZK6m+pjCqdl5m6A+vbUev7pwBMd48bqeYeJiMsiYnNEbN63b1+rzUrSbDNdDjRHl3nZbWBm3pyZSzJzycjISMttSdLsMtWhsCci5gPUt3vr+WPAwo5xC4Anp7g3SZr1pjoUNgCr6ulVwB0d8y+NiOMj4rnAIuDBKe5Nkma9Nk9J/TDwMmBeRIwBfwncCKyPiNXA48BKgMzcFhHrge3AAeDyzDzYVm+SpO5aC4XM/J0JvnXeBOPXAGva6keS1N90OdAsSZoGDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFXOH3YAkqXLBhVc2HvupO9/eSg+Ggo6ItZ/ZNND41cuXtdSJpJ+Gu48kSYWhIEkqZvXuo0F2ebi7Q9J0tXjROY3Hbn/0/p7fd0tBklQYCpKkYkbsPtq0a1fjsctGR1vrYzoZZHMS+m9SSpodpt2WQkScHxFfjoidEXHtsPuRpNlkWm0pRMQc4O+A/wmMAZ+LiA2ZuX24nT3VG999R+OxN7x+RZlefc07G9etvemKgXo6UgbZ6oLZs+UlzRbTKhSApcDOzPx3gIi4FVgBTKtQmGrT4V2OkmaHyMxh91BExKuB8zPz9+v7rwV+JTOv6BhzGXBZffcFwJcneLh5wDcn0YZ11lk3nLqjoceZUvffMnOk63cyc9p8ASuB93Tcfy3wjkk+1mbrrLPu6Kk7GnqcDXXT7UDzGLCw4/4C4Mkh9SJJs850C4XPAYsi4rkRcRxwKbBhyD1J0qwxrQ40Z+aBiLgCuAuYA7w3M7dN8uFuts46646quqOhxxlfN60ONEuShmu67T6SJA2RoSBJKmZkKEzmUhkR8d6I2BsRWwdc1sKI+OeI2BER2yLiqoZ1J0TEgxHxSF33VwMsc05EfD4i7hyw110R8cWIeDgiNg9Q96yIuD0ivlT/nP+9Qc0L6uUc+vpeRFzdoO4N9e9ja0R8OCJOaNjjVXXNtn7L6fa3johTIuKeiHi0vj25Qc3Kenk/iYglAyzrLfXv8gsR8fGIeFbDuhvqmocj4u6IeHaTuo7vXRMRGRHzGi7vTRHx9Y6/4SuaLi8i/qh+Dm6LiL9uuLzbOpa1KyIeblh3ZkRsOrReR8TShnUvioh/q58Tn4yIZ3ap6/r8brC+TFTXc53pUddznelR13edOcxkzmOdzl9UB6i/Cvw8cBzwCLC4Qd25wIuBrQMubz7w4nr6GcBXGi4vgKfX08cCDwDLGi7zj4FbgDsH7HUXMG8Sv9N1wO/X08cBz5rE3+QbVG+Y6TXudOAx4MT6/nrg9xo8/hnAVuAkqpMnPg0sGuRvDfw1cG09fS3w5gY1v0j1Bsp7gSUDLOvXgbn19JvHL6tH3TM7pq8E/qHpekx1qvddwNe6rQMTLO9NwDV9fvfd6v5H/Tc4vr5/atM+O77/VuAvGi7vbuCCevoVwL0N6z4H/Fo9/Trghi51XZ/fDdaXiep6rjM96nquMz3q+q4z479m4pZCuVRGZv4IOHSpjJ4y8z7g24MuLDN3Z+ZD9fT3gR1U/9z61WVm/md999j6q+9R/4hYAPwm8J5Be52M+tXTucBagMz8UWZ+d8CHOQ/4amZ+rcHYucCJETGX6p98k/ep/CKwKTN/mJkHgM8Cr5xo8AR/6xVU4Ud9e3G/mszckZkTvaO+V93ddZ8Am6jej9Ok7nsdd59Gl/Wlx3r8f4E/7VbTp66nCer+ELgxM/fXY/YOsryICOAS4MMN6xI49Cr/Z+iyzkxQ9wLgvnr6HuC3u9RN9Pzut750reu3zvSo67nO9Kjru86MNxND4XTgiY77YzT4J30kRMQocBbVq/4m4+fUm8h7gXsys0nd31A9uX8yiRYTuDsitkR1uZAmfh7YB7wvql1W74mIpw243Evp8gQ/rLnMrwM3AY8Du4H/yMy7Gzz+VuDciPjZiDiJ6tXiwj41452WmbvrPnYDpw5YP1mvAz7VdHBErImIJ4DfBf6iYc1FwNcz85FJ9HdFvfvhveN3kfTwfOClEfFARHw2In55wGW+FNiTmY82HH818Jb693ITcF3Duq3ARfX0SvqsM+Oe343Xl0H/LzSo67nOjK8bdJ2ZiaEQXea1ft5tRDwd+Chw9bh0nlBmHszMM6lSf2lEnNFnGRcCezNzyyTbPDszXwxcAFweEec2qJlLtdn995l5FvADqs3lRqJ6E+JFwEcajD2Z6hXYc4FnA0+LiNf0q8vMHVSb1PcA/0S1y/BAz6JpICKup+rzQ01rMvP6zFxY1/S9lG4dktfTMEDG+XvgecCZVCH91oZ1c4GTgWXA/wbW16/+m/odGryI6PCHwBvq38sbqLdqG3gd1fNgC9Uulx9NNHAyz+826vqtM93qBl1nZmIoTPmlMiLiWKo/xIcy82OD1te7Y+4Fzu8z9GzgoojYRbVbbHlEfHCA5TxZ3+4FPk61q62fMWCsYyvmdqqQaOoC4KHM3NNg7MuBxzJzX2b+GPgY8KtNFpKZazPzxZl5LtVugqavMg/ZExHzAerbw3Z5HEkRsQq4EPjdrHf4DugWuuzu6OJ5VCH7SL3eLAAeioif61eYmXvqFy4/Af4fzdYXqNaZj9W7SB+k2qo97OB2N/Vuw1cBtzVcFsAqqnUFqhcfjfrMzC9l5q9n5kuoQuirE/TU7fndd32Z7P+Fier6rTMNltdonZmJoTCll8qoXwGtBXZk5tsGqBs5dAZBRJxI9Q/xS71qMvO6zFyQmaNUP9dnMrPvK+l6GU+LiGccmqY6cNX3TKvM/AbwRES8oJ51HoNdynyQV32PA8si4qT693oe1b7RviLi1Pr2OVT/VAZ5pQnVOrKqnl4FNP/QjAFFxPnAnwEXZeYPB6hb1HH3IvqsLwCZ+cXMPDUzR+v1ZozqgOQ3GixvfsfdV9Jgfal9AlheP8bzqU5OaHqVz5cDX8rMsYbjoXrR92v19HIaviDoWGeOAf4P8A9dxkz0/O65vvwU/xe61vVbZ3rUDbzO9DwKfbR+Ue1T/gpV8l/fsObDVJvIP6Z64qxuWHcO1e6pLwAP11+vaFD3S8Dn67qtdDnTok/9yxjg7COqYwOP1F/bmv5e6tozgc11r58ATm5YdxLwLeBnBljWX9Ur7lbgA9RnsDSo+xeqsHoEOG/QvzXws8BGqn8oG4FTGtS8sp7eD+wB7mq4rJ1Ux70OrS/dziLqVvfR+vfyBeCTVAcSB1qPmeAMtAmW9wHgi/XyNgDzG9YdB3yw7vUhYHnTPoH3A38w4N/uHGBL/bd/AHhJw7qrqP5PfAW4kfoKD02e3w3Wl4nqeq4zPep6rjM96vquM+O/vMyFJKmYibuPJEmTZChIkgpDQZJUGAqSpMJQkCQVhoIkqTAUpAFFdUnpawaseX9EvLqtnqQjxVCQpomImDPsHiRDQWogIq6P6kNjPk11yWUi4nkR8U/1VWf/JSJ+oc/DnBsR/xoR/35oqyEiXlZ/OMotVO8eloZq7rAbkKa7iHgJ1bWmzqJ6zjxEdVmFm6kuyfBoRPwK8C7qa/5MYD7V5Qh+geqyEbfX85cCZ2TmY+38BFJzhoLU30uBj2d9IbKI2ACcQHUF1490XBX6+D6P84msrji6PSJO65j/oIGg6cJQkJoZf5GwY4DvZvV5GE3t75ju/HyBH0y2KelI85iC1N99wCsj4sT68uO/BfwQeCwiVkJ16eKIeNEwm5SOBENB6iOrz769jepyxB+lukw3VB9vuDoiDl2OvO9ngUvTnZfOliQVbilIkgoPNEtHUP3B6ivHzf5IZq4ZRj/SoNx9JEkq3H0kSSoMBUlSYShIkgpDQZJU/H/EL258QvTfBwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#주중 기준\n",
    "p3 = sns.color_palette(\"ch:start=.2,rot=-.3\")\n",
    "cafe_weekdays = cafe_twenty[cafe_twenty['weekend']=='weekday']\n",
    "sns.countplot(x=cafe_weekdays['de_hr'],palette = p3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "06c4d9e4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='de_hr', ylabel='count'>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEHCAYAAABBW1qbAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAX+ElEQVR4nO3de7BlZXnn8e9PEBQvEeSALZc0UC0RrdhohzgxECOOImO4KQ6MOh0habUkESdmRJlSZyym8ILGiRGnDQgaRZAGRMcIhDJiKlFsELC5CQhKQ9vdQhIsTWEanvljrV5u23PZ69D77NN9vp+qXXutd61nr6dPv+c8e93elapCkiSAx407AUnS/GFRkCR1LAqSpI5FQZLUsShIkjo7jjuBx2L33XevxYsXjzsNSdqmXHfddT+uqonJlm3TRWHx4sWsXr163GlI0jYlyQ+mWubhI0lSx6IgSepYFCRJHYuCJKljUZAkdSwKkqSORUGS1LEoSJI6FgVJUmebvqNZWuiOvviK3jFffPXLR5CJthfuKUiSOhYFSVLHoiBJ6lgUJEmdkRWFJPsk+VqSW5PcnOStbftuSa5Kckf7vutAzDuT3Jnk9iSeDZOkOTbKPYVNwJ9V1bOBFwJvSXIQcBpwdVUtAa5u52mXnQA8BzgC+HiSHUaYnyRpCyMrClW1rqqub6d/AtwK7AUcDZzfrnY+cEw7fTTw+ap6uKruBu4EDhlVfpKkXzUn5xSSLAYOBr4F7FlV66ApHMAe7Wp7AfcOhK1t27b8rBVJVidZvXHjxpHmLUkLzciLQpInA6uAU6vqoelWnaStfqWhamVVLauqZRMTkz5iVJI0SyMtCkkeT1MQPltVl7TN65MsapcvAja07WuBfQbC9wbuH2V+kqRfNsqrjwKcA9xaVR8eWHQ5sLydXg58caD9hCQ7J9kPWAJcO6r8JEm/apRjH70IeD3w3SQ3tG3vAs4ELkpyMvBD4HiAqro5yUXALTRXLr2lqh4ZYX7S2L3y4i/0jvnyq48fQSZSY2RFoar+gcnPEwAcPkXMGcAZo8pJkjQ972iWJHUsCpKkjkVBktSxKEiSOhYFSVLHoiBJ6lgUJEmdUd68Jmmee9Wqb/eOWfWq3xpBJpov3FOQJHUsCpKkjkVBktSxKEiSOhYFSVLHoiBJ6lgUJEmdUT557dwkG5KsGWi7MMkN7euezQ/fSbI4yb8NLPvEqPKSJE1tlDevnQd8DPj05oaq+s+bp5OcBfzrwPp3VdXSEeYjSZrBKJ+8dk2SxZMta5/f/BrgJaPaviSpv3GdUzgUWF9Vdwy07ZfkO0m+nuTQMeUlSQvauMY+OhG4YGB+HbBvVT2Q5AXAZUmeU1UPbRmYZAWwAmDfffedk2QlaaGY8z2FJDsCxwEXbm6rqoer6oF2+jrgLuBZk8VX1cqqWlZVyyYmJuYiZUlaMMaxp/BS4LaqWru5IckE8GBVPZJkf2AJ8P0x5Cb18spVn+od8+VXvWEEmUhbxygvSb0A+CfgwCRrk5zcLjqBXz50BHAYcFOSG4GLgTdV1YOjyk2SNLlRXn104hTtfzhJ2ypg1ahykSQNxzuaJUkdi4IkqWNRkCR1LAqSpI5FQZLUsShIkjoWBUlSx6IgSepYFCRJHYuCJKljUZAkdSwKkqSORUGS1LEoSJI6FgVJUseiIEnqjPLJa+cm2ZBkzUDbe5Pcl+SG9nXkwLJ3Jrkzye1JXj6qvCRJUxvlnsJ5wBGTtH+kqpa2r68AJDmI5jGdz2ljPp5khxHmJkmaxMiKQlVdAwz7nOWjgc9X1cNVdTdwJ3DIqHKTJE1uHOcUTklyU3t4ade2bS/g3oF11rZtkqQ5NNdF4WzgAGApsA44q23PJOvWZB+QZEWS1UlWb9y4cSRJStJCNadFoarWV9UjVfUo8El+cYhoLbDPwKp7A/dP8Rkrq2pZVS2bmJgYbcKStMDMaVFIsmhg9lhg85VJlwMnJNk5yX7AEuDaucxNkgQ7juqDk1wAvBjYPcla4D3Ai5MspTk0dA/wRoCqujnJRcAtwCbgLVX1yKhykzQ/nH9J/0PAy4/zCMEojawoVNWJkzSfM836ZwBnjCofSdLMRlYUJG3//vTSe2deaQv/59h9Zl5JY+MwF5KkjkVBktSxKEiSOhYFSVLHoiBJ6lgUJEkdL0nVgvafLvmL3jH/77hTt3oe0nzhnoIkqWNRkCR1LAqSpI5FQZLUsShIkjoWBUlSx6IgSepYFCRJnZEVhSTnJtmQZM1A2weT3JbkpiSXJnla2744yb8luaF9fWJUeUmSpjbKPYXzgCO2aLsKeG5V/SbwPeCdA8vuqqql7etNI8xLkjSFkRWFqroGeHCLtiuralM7+01g71FtX5LU3zjPKZwE/O3A/H5JvpPk60kOnSooyYokq5Os3rix/0O/JUlTG0tRSHI6sAn4bNu0Dti3qg4G/hvwuSRPnSy2qlZW1bKqWjYxMTE3CUvSAjHnRSHJcuCVwGurqgCq6uGqeqCdvg64C3jWXOcmSQvdnBaFJEcA7wCOqqqfDbRPJNmhnd4fWAJ8fy5zkySN8HkKSS4AXgzsnmQt8B6aq412Bq5KAvDN9kqjw4D/lWQT8Ajwpqp6cNIPliSNzFBFIcnVVXX4TG2DqurESZrPmWLdVcCqYXKRJI3OtEUhyROAXWi+7e8KpF30VOCZI85NkjTHZtpTeCNwKk0BuI5fFIWHgL8aXVqSNLOrP9f/svTD/4tXLU5n2qJQVR8FPprkT6rqL+coJ0nSmAx1TqGq/jLJ7wCLB2Oq6tMjykuSNAbDnmj+DHAAcAPN1UEABVgUJGk7MuwlqcuAgzbfbCZJ2j4Ne/PaGuAZo0xEkjR+w+4p7A7ckuRa4OHNjVV11EiykiSNxbBF4b2jTEKSND8Me/XR10ediCRp/Ia9+ugnNFcbAewEPB74aVVNOry1JGnbNOyewlMG55McAxwyioQkSeMzq6Gzq+oy4CVbNxVJ0rgNe/jouIHZx9Hct+A9C5K0nRn26qM/GJjeBNwDHL3Vs5EkjdWw5xTeMOpEJEnjN9Q5hSR7J7k0yYYk65OsSrL3DDHntuuvGWjbLclVSe5o33cdWPbOJHcmuT3Jy2f/T5IkzdawJ5o/BVxO81yFvYAvtW3TOQ84You204Crq2oJcHU7T5KDgBOA57QxH9/8zGZJ0twZtihMVNWnqmpT+zoPmPZJFVV1DbDlc5aPBs5vp88Hjhlo/3xVPVxVdwN34iWvkjTnhi0KP07yuiQ7tK/XAQ/MYnt7VtU6gPZ9j7Z9L+DegfXWtm2/IsmKJKuTrN64sf9TlyRJUxu2KJwEvAb4EbAOeDWwNU8+Z5K2SS95raqVVbWsqpZNTPhYPUnamoYtCu8DllfVRFXtQVMk3juL7a1Psgigfd/Qtq8F9hlYb2/g/ll8viTpMRi2KPxmVf3z5pmqehA4eBbbuxxY3k4vB7440H5Ckp2T7AcsAa6dxedLkh6DYW9ee1ySXTcXhiS7zRSb5ALgxcDuSdYC7wHOBC5KcjLwQ+B4gKq6OclFwC00N8e9paoemfSDJUkjM2xROAv4xyQX0xzrfw1wxnQBVXXiFIsOn2L9M2b6TEnSaA17R/Onk6ymGQQvwHFVdctIM5Mkzblh9xRoi4CFQJK2Y7MaOluStH0aek9BkrY3a/7v+t4xz33jniPIZP5wT0GS1LEoSJI6FgVJUseiIEnqWBQkSR2LgiSpY1GQJHUsCpKkjkVBktSxKEiSOhYFSVLHoiBJ6sz5gHhJDgQuHGjaH3g38DTgj4GNbfu7quorc5udJC1sc14Uqup2YClAkh2A+4BLgTcAH6mqD811TpKkxriHzj4cuKuqfpBkzKloW3TkZaf1jvnKMWeOIBNp+zDucwonABcMzJ+S5KYk5ybZdbKAJCuSrE6yeuPGjZOtIkmapbEVhSQ7AUcBX2ibzgYOoDm0tA44a7K4qlpZVcuqatnExMRcpCpJC8Y49xReAVxfVesBqmp9VT1SVY8CnwQOGWNukrQgjbMonMjAoaMkiwaWHQusmfOMJGmBG8uJ5iS7AP8ReONA8weSLAUKuGeLZZKkOTCWolBVPwOevkXb68eRiyTpF8Z99ZEkaR6xKEiSOhYFSVLHoiBJ6lgUJEkdi4IkqWNRkCR1LAqSpI5FQZLUsShIkjoWBUlSx6IgSepYFCRJHYuCJKljUZAkdSwKkqTOuJ68dg/wE+ARYFNVLUuyG3AhsJjmyWuvqap/Hkd+krRQjXNP4feramlVLWvnTwOurqolwNXtvCRpDs2nw0dHA+e30+cDx4wvFUlamMZVFAq4Msl1SVa0bXtW1TqA9n2PyQKTrEiyOsnqjRs3zlG6krQwjOWcAvCiqro/yR7AVUluGzawqlYCKwGWLVtWo0pQkhaisewpVNX97fsG4FLgEGB9kkUA7fuGceQmSQvZnBeFJE9K8pTN08DLgDXA5cDydrXlwBfnOjdJWujGcfhoT+DSJJu3/7mq+mqSbwMXJTkZ+CFw/Bhyk6QFbc6LQlV9H3jeJO0PAIfPdT6SpF+YT5ekSpLGzKIgSepYFCRJnXHdpyB13nDpEb3W/9SxXx1RJpLcU5AkdSwKkqSORUGS1LEoSJI6nmiWpFn60Qd/0DvmGX/+6yPIZOtxT0GS1LEoSJI6Hj7SY/b+z7+81/rvOOGKEWUi6bFyT0GS1LEoSJI6FgVJUseiIEnqjONxnPsk+VqSW5PcnOStbft7k9yX5Ib2deRc5yZJC904rj7aBPxZVV3fPqv5uiRXtcs+UlUfGkNOkiTG8zjOdcC6dvonSW4F9prrPCRJv2qs5xSSLAYOBr7VNp2S5KYk5ybZdYqYFUlWJ1m9cePGuUpVkhaEsRWFJE8GVgGnVtVDwNnAAcBSmj2JsyaLq6qVVbWsqpZNTEzMVbqStCCMpSgkeTxNQfhsVV0CUFXrq+qRqnoU+CRwyDhyk6SFbBxXHwU4B7i1qj480L5oYLVjgTVznZskLXTjuProRcDrge8muaFtexdwYpKlQAH3AG8cQ26StKCN4+qjfwAyyaKvzHUukqRf5h3NkqSORUGS1PF5CuKcT7+s1/on/9crR5SJpHFzT0GS1LEoSJI6FgVJUseiIEnqWBQkSR2LgiSpY1GQJHW8T2Ee+MYnX9k75tA//vIIMpE0l9b/xbd7x+x56m+NIJNfcE9BktSxKEiSOh4+kqRt1IaPXdE7Zo9TXj7tcvcUJEmd7WJPYePZf9M7ZuLNrxtBJpK0bZt3RSHJEcBHgR2Av66qM8ec0rx32bmv6LX+MSf97YgykbStm1eHj5LsAPwV8ArgIJpHdB403qwkaeGYb3sKhwB3VtX3AZJ8HjgauGWUG11/9v/uHbPnm9/VTd/xsaN7xy855Yu9YyRp1FJV486hk+TVwBFV9Uft/OuB366qUwbWWQGsaGcPBG6f5iN3B378GFIy3njjt71tGz9z/K9X1cRkC+bbnkImafulqlVVK4GVQ31Ysrqqls06GeONN35W8dty7gs9fl6dUwDWAvsMzO8N3D+mXCRpwZlvReHbwJIk+yXZCTgBuHzMOUnSgjGvDh9V1aYkpwBX0FySem5V3fwYPnKow0zGG2/8Vo/flnNf0PHz6kSzJGm85tvhI0nSGFkUJEmd7bYoJDkiye1J7kxyWs/Yc5NsSLLmMWz/niTfTXJDktWziH9akouT3Jbk1iT/oUfsge12N78eSnJqj/i3Jbk5yZokFyR5Qs/c39rG3jzsdif7mSfZLclVSe5o33ftGX98m8OjSaa9PG+K+A+2P/+bklya5Gk9Yt/Xxt2Q5Mokz+yz7YFlb09SSXbvmft7k9w30AeO7Lv9JH/S/g7dnOQDPbd/4cC270lyQ8/4pUm+ufn3J8khPeOfl+Sf2t/BLyV56jTx+yT5Wvt7dnOSt7btQ/W/aeKH6n/TxA/b/6aKH7oP/pKq2u5eNCep7wL2B3YCbgQO6hF/GPB8YM1jyOEeYPfHEH8+8Eft9E7A0x7Dz+JHNDerDLP+XsDdwBPb+YuAP+yxvecCa4BdaC5k+DtgyWx+5sAHgNPa6dOA9/eMfzbNDY5/DyybxfZfBuzYTr9/qu1PEfvUgek/BT7Rt7/RXJ59BfCD6frSFNt/L/D22fZ34Pfb/7ud2/k9+uY/sPws4N09t38l8Ip2+kjg73vGfxv4vXb6JOB908QvAp7fTj8F+B7NMDtD9b9p4ofqf9PED9v/poofug8OvrbXPYVuuIyq+jmwebiMoVTVNcCDo0puJu23msOAc9p8fl5V/zLLjzscuKuqftAjZkfgiUl2pPnj3udekWcD36yqn1XVJuDrwLEzBU3xMz+apjjSvh/TJ76qbq2q6e54nyn+yvbfAPBNmvtmho19aGD2SWxxE+ZM8a2PAP99utgZ4ocyRfybgTOr6uF2nQ2z2X6SAK8BLugZX8Dmb/e/xjR9cIr4A4Fr2umrgFdNE7+uqq5vp38C3Erz5Wio/jdV/LD9b5r4YfvfVPFD98FB22tR2Au4d2B+bds2lwq4Msl1aYbm6GN/YCPwqSTfSfLXSZ40yzxOYJpfyC1V1X3Ah4AfAuuAf62qK3tsbw1wWJKnJ9mF5lvePjPETGXPqlrX5rUO2GOWn7M1nAT0Gl42yRlJ7gVeC7y7Z+xRwH1VdWOfuC2c0h4+OHe6Q29TeBZwaJJvJfl6ktk+GPhQYH1V3dEz7lTgg+3P70PAO3vGrwGOaqePZ8g+mGQxcDDwLWbR/7aI722a+KH635bxs+mD22tRmHG4jDnwoqp6Ps2Ir29JcliP2B1pdofPrqqDgZ/S7L72kuYGwKOAL/SI2ZXmG9J+wDOBJyUZ+uETVXUrza7uVcBXaQ7dbZo2aJ5LcjrNv+GzfeKq6vSq2qeNO2Wm9Qe2twtwOj0LyRbOBg4AltIU97N6xu8I7Aq8EPhz4KL2W39fJ9LjS8mANwNva39+b6Pda+7hJJrfu+toDqn8fKaAJE8GVgGnbvEteyijih+2/00WP5s+uL0WhbEPl1FV97fvG4BLaQ5pDWstsLaqNn9buJimSPT1CuD6qlrfI+alwN1VtbGq/h24BPidPhutqnOq6vlVdRjNbn3fb4mbrU+yCKB9n/IQxqgkWQ68EnhttQdnZ+FzTHP4YhIH0BTlG5PcQ9N/r0/yjGE/oKrWV9UjVfUo8En69T9o+uAl1bgWeJRmkLWhtYcfjwMu7LltgOU0fQ+aLzW98q+q26rqZVX1ApqidNcMuT6e5g/qZ6tq83aH7n9TxA9tqvhh+98Q2x+6D26vRWGsw2UkeVKSp2yepjlhNPSVTFX1I+DeJAe2TYczu+HDZ/Mt7YfAC5Ps0n4zPJzmGOXQkuzRvu9L80dhNt8Uofk/W95OLwfmdLzxNA98egdwVFX9rGfskoHZo4Dbho2tqu9W1R5VtbiqFtP8gX5+2y+G3f6igdlj6dH/WpcBL2k/61k0Fzv0HbXzpcBtVbW2Zxw0X+J+r51+CT2/WAz0wccB/wP4xDTrhmZP5Naq+vDAoqH63zTxw+Y6afyw/W+a+Nn1wWHORm+LL5pj2d+j+YZwes/YC2h2uf+d5hfy5J7x+9McNrkRuLnv9tvPWAqsBm6i+QXdtWf8LsADwK/NYtv/s+1Aa4DP0F6B0iP+GzRF7Ebg8Nn+zIGnA1fT/EG4GtitZ/yx7fTDwHrgip7xd9Kcm7qhfU169cYUsavan99NwJdoTvzNqr8xw5VsU2z/M8B32+1fDizqGb8T8Dftv+F64CV98wfOA940y//73wWua/vQt4AX9Ix/K83v//eAM2lHb5gi/ndpDi/fNPB/feSw/W+a+KH63zTxw/a/qeKH7oODL4e5kCR1ttfDR5KkWbAoSJI6FgVJUseiIEnqWBQkSR2LgiSpY1GQekozLPXbe8acl+TVo8pJ2losCtI8kWSHcecgWRSkISQ5Pc0DZ/6OZlhmkhyQ5KvtSLjfSPIbM3zMYUn+Mcn3N+81JHlx+4CUz9HcgSyN1Y7jTkCa75K8gGb8rINpfmeupxmCYSXNMA53JPlt4OO04wVNYRHNkAS/QTP0xMVt+yHAc6vq7tH8C6ThWRSkmR0KXFrtoGRJLgeeQDN67BcGRpTeeYbPuayaUUtvSbLnQPu1FgTNFxYFaThbDhL2OOBfqmppj894eGB68NkEP51tUtLW5jkFaWbXAMcmeWI7JPofAD8D7k5yPDTDFyd53jiTlLYGi4I0g2qef3shzZDEq2iGBofmEYcnJ9k8RPrQzwGX5iuHzpYkddxTkCR1PNEsbUXtQ9aP36L5C1V1xjjykfry8JEkqePhI0lSx6IgSepYFCRJHYuCJKnz/wGsv4OsVoPsdAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#주말 기준\n",
    "cafe_weekend = cafe_twenty[cafe_twenty['weekend']=='weekend']\n",
    "sns.countplot(x=cafe_weekend['de_hr'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1a1193c3",
   "metadata": {},
   "source": [
    "## 20대 성별에 따른 카페 이용 비율"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "229be2e5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAOcAAADnCAYAAADl9EEgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAV70lEQVR4nO3de7xUZb3H8c+zb4AgiKBc1cVJ0KN2ERXxlmSlpa0otIuajuYtTnYxW2nmScvOMVt2ytJTaUrisSRFy4WikLnRvDaaOnKRRBYgd8S4bTYb9jznjzUgbrnsy8z8njXze79e83rhZtjPF+TLs9aaZz3LWGtRSrmnRjqAUmrHtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSjtJxKOUrLqZSj6qQDqJ2L4rAGGAwcsN1rP6Av0GsHr1pgU+HVst2Pm4BlwFJgSZvXAt8L8mX7Tal2M/ogIzdEcTgMOAL4YOF1KEkR60s89EZgNpArvF4Fcr4XLCnxuGo3tJwCojg0wOHAycCHgaOA/qKh3utNYAbwONDoe8E84TxVR8tZJlEcDiQp4ynAx4F9ZBN12CKgEXgUiHwvWCsbp/JpOUuoUMgvAmcDRwrHKaZNwHTgXuDPvhesEc5TkbScRRbF4Z7AOJJCnkRykaaStQB/Af4A3Od7QbNwnoqh5SySKA6PAL4JnA70kE0jZjUwEfi17wWvSYdJOy1nFxQ+6hgLXAacIBzHJRaYBvwCmOp7gf4l6wQtZydEcdgTuBD4OvBvwnFcNwv4AXCvlrRjtJwdEMVhA3AJcDWwr3CctMmRlPR+LWn7aDnboXD4ejbJX65hwnHS7mXgB74XPCAdxHVazt2I4vA04Hrg/dJZKsyTwFd9L8hJB3GVlnMnojgcCtxMcsFHlcYWkj/ja3RRw3tpOdsoHMJeCvwI2FM4TrVYCgS+F9wtHcQlzpXTGDMcqLXWztnFe/oDe1tr5xZz7CgOPwDcBowq5vdV7fYYcJ7vBW9KB3GB2P2cxph6Y8ytxphGY8xjxpjBhZ86Ahjd5r1T2vzyw4DPFytLFIc1URz+J/ACWkxJHwVeieKwaP9v00xs5jTGXAzsYa39uTHmaOA3wEskV0MnWGt/V3hfLbCY5PapccB4YC/gPmvtj7qaI4rDwcDdwJiufi9VVBOBS30vWCcdRIrkTggnAbcDWGufA5YDXwF+2+Z944G7gGustZOstWNIlsl1WRSHp5L8gzCmGN9PFdW5wMtRHB4rHUSKZDn3sNZu/69i3lrbDGwGMMbUGGO+Cgyx1gbAPGPM7caYLq9bjeKwPorDG4EppO/WrWoyDJgRxeF/SAeRIFnON40xB0JSRGCIMeZC4COFn28AVlhrvwtgrZ1AMntuJNl2Y1VnBo3icG+SuyguB0zXfguqDOqAW6I4/FUUh6XeFcIpkuecI4HvAVeSHMJ0J7mRdwzw+nbnnDXAVSQ3KreS3IL1D+DKQlHbLYrDA4GHgBFF+U2ocmsEPud7Qaf+YU4b0Y9SjDGjgM8Ac6y1Ewtf+yLQfbtynkeyn84V1tp84WsXA8O2zqrtEcXh8cCfgH7F+x0oAfOBsdWwskh0a0xr7fPW2qu2FnMXmrYWs6BDV/CiODyL5FBWi5l+w4Anozg8TjpIqaVh39o7gbwx5q/GmGnGmMdI7p28rj2/OIrDb5F8VNKthBlVefUBHo3i8KPSQUrJuRVCxRTF4VXAf0nnUCWzCTjD94K2i1QqQhpmzk6J4vAatJiVrhtwf6WuKKrIckZxeDVwrXQOVRb1wO+jODxTOkixVdxhbRSH3wFukM6hym4zcJrvBdOlgxRLRZUzisNzSNZkquq0HviI7wVZ6SDFUDHljOLwRJId3xqksyhRK4HjfC/4p3SQrqqIckZxeDDwNMnTt5SaDxzre8Ey6SBdkfoLQlEc7gs8jBZTvWMY8GAUh6n+bDvV5Sz84T+I7oin3usokk2tUyvV5QRuBI6WDqGcdXEUh+dLh+is1J5zRnE4DpgsnUM5r5nk/PMf0kE6KpXlLDwF+kWS7UqU2p35wJG+F6yWDtIRqTusLdxwew9aTNV+w4A7pEN0VOrKSbL7uu6QpzpqbBSHGekQHZGqw9ooDkcDT5HOf1SUvLXA+30vWCgdpD1S85e8cDh7GynKrJzTm2QL1lRI01/0K0g2k1aqKz4RxeG50iHaIxWHtVEcHkTy6LhUr/hQzlgNHOT6RmHOz5xRHBrgVrSYqnj2JnnWqtOcLydwJvBh6RCq4lwSxeEh0iF2xelyFh7z3uXnoSi1A7Ukyz+d5XQ5SZ6doovaVal8MorDU6RD7IyzF4SiONwTmIfQs0ym3PkUT099Z9/iBXOXceHVPvf96nH69OtFXX0tP7zrIpbMX8ktV01m08bNnH35KRx+wghefe4N5r60kHGXjJGIrjpmJvBB3wtapYO0VScdYBcCBB8y9KnMcXwqk+xb/PTUHMsXrWbD2mbOCT7J6JMP3fa+qXc/y2X/80V6792TX15xH4ccNYxHfp98TaXCocDZOLi9jZOHtYUbqL8lnQMgn8/z0F1Pc1rmWNav3UivPu9+yFm37vU0N7XQ3NRC7757cM9N0zlj/EeorXXyj1bt2BWFTwWc4urMeSnQUzoEwHPTZ/Gh44fT0K2efGue3/34Yerqahjz2ZF84qzRfPqCE/i/nz4KwOEnjGDh3OW88sw8/jblZQ45ahgjTzxI+Heg2uEQYCzJs3Sc4dw5ZxSHPYCFQH/pLADXXTCBr93wOfbq32vb1zZtbOFHF93JRd/32X/EQAA2b9rCzy6/h1POPJq3lq3lpNOP4GeXT+Kyn35BKrrqmOd9L3Dqxn0Xj73OxZFirn17Ay2btmwrZuuW5JpBQ/d6evTqBuadI6FJNz/GuEvGsGFd87YvNzdtKntm1Wmjojg8STrE9pw6rC0c918mnWOrmc/P5+CR+2/774k/mcrclxfR2prnmJMPY//hAwB4PfcmAAe+fyhD37cv14+fyKN/eI4xnx0pklt12neBv0qH2Mqpw9ooDj8FRNI5VFU7yPeCudIhwL3D2m9IB1BV78vSAbZyZuaM4nA/YAHg3CVtVVWWAvu5sCjBpZnzbLSYSt4g4FTpEOBWOb8kHUCpAicObZ04rI3i8HCSrS6VcsEWYIjvBSskQ7gyc54jHUCp7dQBn5EOIV7OwmebukpcuebT0gHEywmMJDkJV8olH43icA/JAC6U09mbXVVV6w58XDKAC+X8hHQApXZC9NBW9GptFIe9gbdwbI2vUgUrgEG+F+QlBpeeOT+GFlO5a1+Sez1FSJfzZOHxldqdY6UGli7n8cLjK7U7x0gNLFbOwu56/y41vlLtVH3lBI4SHl+p9hgRxWE/iYEly3GE4NhKtZcBRksMLFnOwwXHVqojRCYSyXJ+SHBspTpihMSgIuWM4rAWGC4xtlKdUD3lBIaiiw9UelRVOT2hcZXqjD5RHA4o96BS5dTH+qm0KfvsqTOnUu3zvnIPqOVUqn3K/jhKyQtCSqVJ2VcJSZWzj9C4SnXW3uUeUKqcvYXGVaqzqmbm3FNoXKU6S8uplKMqv5xRHNbgyCPlleqAHuUeUGLm7Ik+sEilT225B9SbnZVqn7KXU2Lx+WaBMavChpbm1Tc+80fpGBXJYNb6XlDWMSXK2SIwZlWw2FYEVrJUA4tdU+4xy35YW9igV2ST3krnwuMcK9iWcg8odc6ps2cJWLSdJVQ15dTzzhKwVo9ISqi53ANKlXOt0LiVTmfO0llW7gGlyrlcaNyKZrWbpbSk3ANKlXOp0LgVzVqrh7WlU/a/s1LlLPshQjWwelhbSlVTTp05S0A/Simpqjms1ZmzBCx6WFtCVTNzLhYat9Lp1Fk6VVPO2ULjVjQ9rC0ZSxWV83Vgk9DYFUsvCJXMvGwmV/aFMyLl9L2gFZgjMXYlszp1lsoLEoNK3s/5quDYlUrLWRpVV86ZgmNXpLwufC+VqiunzpzFpoe1pfKixKCS5XwGPQwrKr0gVBLzspncvyQGFiun7wWr0I9UikonzpIQOaQF+Q2+ZgiPX1F0hVBJaDlV1+m8WRJPSw2s5awg+jln0b1Fcm1EhGg5fS9YBsyVzFBJdA+hons4m8m1Sg0uPXMCPCwdoGLoVgjF9qDk4C6Uc7J0gEqh3SyqTcAjkgFcKOdT6M3XRaHnnEXVmM3k1ksGEC+n7wUWeEA6RyXQRQhFJXpICw6Us+A+6QCVQGfOooqkA7hSzieAVdIh0k7POYsmm83kFkmHcKKchfs775HOkXZW21kst0sHAEfKWXCbdIC00885i2ID8HvpEOBQOX0veAV4XjpHmukpZ1FMymZyTjwuROL5nLvyK2CUdIi0kpg5t2xoZeGdS9i8ZjNY8C4ayvq5G1j20Crq9qzF1BlGBMNoXraJBb9bQr4lz5BxA+h9WC/WvbaBDfOaGHiqU48U/Y10gK1cK+c9QAj0lw6SUmUvZ74lz9AzB9LQt541L61j+dRVdB/UjSFnDGCvkb23vW/l46sZdvFQ6nrVsmDCYnqN2GPb1xzyXDaTc+bozZnDWgDfC5qB30rnSKu8wGFtQ996GvrWA1Dbs5aabjW0NrVS27P2Xe+raagh35wn35KnrlcdS/60gkGn7YOpMWXPvAs/lw6wPafKWfALBJ6FWAkkLwi1vL2Z5Y+sYt+T+2HzlsWTlvHaf7/BysbVAAw4pR/Lp7/F4skr6HVwT2q717B29noWT17Omtw6qdjbW4xjn7c7V07fC5YCt0rnSCWhj1L+9dJalv55BQecP5iGvvUM/uwADv7++xh+ucfbf1/DxsXN1PWq44DMYPY7ayBvP/cveh64B3U9axly+gBWP7tGInZbN2UzubI/vXpXnCtnwQ3o7NlheYFuNi1qZs1L6zjgvCHU9UouYdjWJIdpMNR2f/fh7dIHVzLg1H1obXrnTqx8s/gGDouBm6VDtOXaBSEAfC9YEsXhbcDXpLOkisBnKWtz61g/t4nXrn8DgIZ+DdT3rmPD/CZsK+x1RG96DOkOwIZ4IwA9vR50H9SNN365kFUz3mbvY/Yqd+y2rs1mchulQ7TlZDkLfgxcBHSXDpIWEse0A0/dp90fhfT0etDT6wFAbbcahn/bK2GydpsDTJAOsSOuHtbie8ES9NyzQ3The6dcJbnbwa44W86CHwKrpUOkhS6t7bBns5mcs7crOl1O3wveAr4nnSMtdOF7h10hHWBXnC5nwa0IbYefNtrNDnk4m8k9IR1iV5wvp+8FeeBS9C7/3dJTznZrAr4uHWJ3nC8ngO8FzwATpXO4Tnd8b7crs5ncPOkQu5OKchZ8B1gpHcJlOm+2SyMOLjjYkdSU0/eCFcCF0jlcpoe1u7UB+HI2k0vFH1Rqygnge8GD6F0rO6U7IezWd7KZ3HzpEO2VqnIWXAY4f74gQau5S4+R3MyfGqkrp+8F64EvAU6u6pCkH6Xs1DrggrQczm6VunIC+F7wLMnqIbUdXb63Q5akmAukg3RUKstZcB3wZ+kQLtEd33foumwmd690iM5IbTkLj3E4B5gpncUZOnG2dT9wrXSIzkptOQF8L1gHjEUXxwMyN1s77GXg3LSdZ24v1eUE8L1gHvAF9AKRftD5jpXA2Gwmt0E6SFekvpwAvhf8BfiGdA5p2kwAWoBxabwA1FZFlBPA94JbgO9L55CkEycA47OZ3N+kQxRDxZQTwPeC64AbpXNI0RVCXJbN5O6QDlEsFVVOAN8LAqp0e5Mqr+aV2Uzu59IhiqniylkwHviDdIhyq+IVQtdkM7kbpEMUW0WWs3CD9rlU2T2gVXrOeVU2k+vUajFjzCfb8Z7+xpgRnfn+XVWR5QTwvWALcB7wU+EoZVOFK4S+mc3krt/dm4wxvzbGeDv4qct38N4pbb50GPD5zsXrmootJySriHwv+DaOb+RULNZap54KVEKtwCXZTO6mrn4jY8yRxph9Cj+uBY40xtQbY75gjGlE8OFGFV3OrXwv+AnwZSp8oUKVXK19Gzg1m8l16aKfMaY7YIAjga27Yo8H7gKusdZOstaOAb7ZlXG6oirKCeB7wQTgM4ATTy0uhSq4IDQLGJXN5KZ18NctAyYaY/5ijJlujJlGctuhtdb+GphjjPkqMMRaGwDzjDG3G2N6FDd+x7j8OIai871gShSHRwEPAIdI5ym2Cp83pwBnZTMdf16gtfZadrAA3hizX+GHDcAKa+0thfdPMMZMt9ZuNMY0Aas6nboLTDVe4YvisBdwB/A56SzFNPX152c8v3jOidI5SuB64OpsJtfp3QWNMXcA+7f5cm9r7ajt3lMDXAWcTHIKVAv8A7jSWlv2Bx1V1cy5VWE3hc9HcRiQ/I+v3c0vSYUK/Ie2iWRDrklF+F6DrbUf2/4LxphH2rznXKAPMMbaZJtRY8zFJMtCv1uEDB1SNeecO+J7QQh8DFgknUW9xwvA0UUqZkc0bS1mgdhjt6u6nAC+FzQCHwDuFo7SZfnKmDk3kRxajs5mcq8W8fvWFy4IbXsBh7d5z51A3hjzV2PMNGPMY8AJJLtulF1VnnPuTBSHpwP/C+wrnaUzornPzHhx6T/TfM75d+D8bCanu1ugM+e7+F4wmeQqbjpn0fT+O7sJuBI4Rov5jqq8ILQrhccOfimKw9uBnwEfFI7Ubin9nPNZkos+s6WDuEZnzp3wveBxYCRwMbBCOE67pGxrzLkk28scq8XcMZ05d6Fwd8ttURxOAq4m2QqlQTbVzqWkmYuBHwATspncFukwLtMLQh0QxaFHsoj+fKCbbJr3emD232a8suINVy8IrSb5TPnmbCbXLB0mDbScnRDF4SCS242+AvQUjrPN/bOfbMytmD9GOkcb64GbgDCbya2RDpMmWs4uiOKwH8kTkr8G9BWOw+TZTza+6k453yB5DuYdWsrO0XIWQRSH3YEzgAuAE0luRSq7+2Y9MWPmyljysDYPTCP5rPihrqyFVVrOoovi8ECSkp4HDCzn2PfOmtE4a+WCMeUcs2ABMIFkltSlkEWi5SyRKA7rgI+TPC7i08CgUo9578wZjbNWLRhT6nEKZpPcxhUBT+ksWXxazjKI4tAAo0hKOhY4tBTj/HFmY+PsVQvHlOJ7A5uBJ0jKOCWbyekDjEtMyykgisMDgOOB4wqvwyjCgpBJMx+fMWfVomKdc7aQPMHtBeBRYFo2k6vYXSRcpIsQBPhesIDkPO1ugCgOewOjgWNIZtWDgOFAh7bJsJ1fv9cEvAK8uN1rZjaTa+nk91NFoOV0gO8Fa0mucm7bGyeKwxqSO/cPKryGkmxE1b/w2vrjPlt/zU66uYZkD52dvRYAc7OZXEVvfpZGelibcoXz2Tqg7tF5WfPsm7Mg2WIjD7TqhZr00nIq5Si9K0UpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR2k5lXKUllMpR/0/Xs7EJgKM/q0AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "colors4 = sns.color_palette(\"Paired\")[2:4]\n",
    "\n",
    "labels = cafe_twenty['ma_fem_dv'].value_counts().index.tolist()\n",
    "ratio = cafe_twenty['ma_fem_dv'].value_counts().values.tolist()\n",
    "\n",
    "plt.rcParams['font.family'] = 'Malgun Gothic'\n",
    "\n",
    "plt.pie(ratio, labels = labels, colors = colors4, autopct='%.0f%%')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5b4e5b74",
   "metadata": {},
   "source": [
    "## 카페 평균 이용 금액"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "e0fb5771",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9049.31270241094"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cafe_twenty['buy_am'].mean()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}