Practice-3 ( EDA [Hotel_booking] ).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "c4d08e9f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "from matplotlib import pyplot as plt\n",
    "%matplotlib inline\n",
    "mydata=pd.read_csv(\"https://raw.githubusercontent.com/Premalatha-success/Yhills_July12_Analytics/main/hotel_bookings.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "53b80af4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(119390, 32)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "05dc3284",
   "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>hotel</th>\n",
       "      <th>is_canceled</th>\n",
       "      <th>lead_time</th>\n",
       "      <th>arrival_date_year</th>\n",
       "      <th>arrival_date_month</th>\n",
       "      <th>arrival_date_week_number</th>\n",
       "      <th>arrival_date_day_of_month</th>\n",
       "      <th>stays_in_weekend_nights</th>\n",
       "      <th>stays_in_week_nights</th>\n",
       "      <th>adults</th>\n",
       "      <th>...</th>\n",
       "      <th>deposit_type</th>\n",
       "      <th>agent</th>\n",
       "      <th>company</th>\n",
       "      <th>days_in_waiting_list</th>\n",
       "      <th>customer_type</th>\n",
       "      <th>adr</th>\n",
       "      <th>required_car_parking_spaces</th>\n",
       "      <th>total_of_special_requests</th>\n",
       "      <th>reservation_status</th>\n",
       "      <th>reservation_status_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>107671</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>2017</td>\n",
       "      <td>March</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>143.6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>3/17/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77164</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>2016</td>\n",
       "      <td>December</td>\n",
       "      <td>50</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>12-11-2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64604</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>2017</td>\n",
       "      <td>March</td>\n",
       "      <td>11</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>Non Refund</td>\n",
       "      <td>56.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Canceled</td>\n",
       "      <td>1/20/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9593</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>2016</td>\n",
       "      <td>December</td>\n",
       "      <td>51</td>\n",
       "      <td>17</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>240.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>93.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Canceled</td>\n",
       "      <td>10/29/2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11446</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>2017</td>\n",
       "      <td>May</td>\n",
       "      <td>19</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>240.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>85.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Canceled</td>\n",
       "      <td>05-02-2017</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               hotel  is_canceled  lead_time  arrival_date_year  \\\n",
       "107671    City Hotel            0         38               2017   \n",
       "77164     City Hotel            0          9               2016   \n",
       "64604     City Hotel            1         52               2017   \n",
       "9593    Resort Hotel            1         49               2016   \n",
       "11446   Resort Hotel            1          7               2017   \n",
       "\n",
       "       arrival_date_month  arrival_date_week_number  \\\n",
       "107671              March                        11   \n",
       "77164            December                        50   \n",
       "64604               March                        11   \n",
       "9593             December                        51   \n",
       "11446                 May                        19   \n",
       "\n",
       "        arrival_date_day_of_month  stays_in_weekend_nights  \\\n",
       "107671                         13                        1   \n",
       "77164                          10                        0   \n",
       "64604                          13                        1   \n",
       "9593                           17                        2   \n",
       "11446                           9                        0   \n",
       "\n",
       "        stays_in_week_nights  adults  ...  deposit_type  agent company  \\\n",
       "107671                     3       2  ...    No Deposit    9.0     NaN   \n",
       "77164                      1       2  ...    No Deposit    NaN    45.0   \n",
       "64604                      1       1  ...    Non Refund   56.0     NaN   \n",
       "9593                       3       2  ...    No Deposit  240.0     NaN   \n",
       "11446                      2       1  ...    No Deposit  240.0     NaN   \n",
       "\n",
       "       days_in_waiting_list customer_type    adr  required_car_parking_spaces  \\\n",
       "107671                    0     Transient  143.6                            0   \n",
       "77164                     0     Transient    0.0                            0   \n",
       "64604                     0     Transient   80.0                            0   \n",
       "9593                      0     Transient   93.0                            0   \n",
       "11446                     0     Transient   85.0                            0   \n",
       "\n",
       "        total_of_special_requests  reservation_status reservation_status_date  \n",
       "107671                          1           Check-Out               3/17/2017  \n",
       "77164                           1           Check-Out              12-11-2016  \n",
       "64604                           0            Canceled               1/20/2017  \n",
       "9593                            0            Canceled              10/29/2016  \n",
       "11446                           1            Canceled              05-02-2017  \n",
       "\n",
       "[5 rows x 32 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "1c9a9235",
   "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>is_canceled</th>\n",
       "      <th>lead_time</th>\n",
       "      <th>arrival_date_year</th>\n",
       "      <th>arrival_date_week_number</th>\n",
       "      <th>arrival_date_day_of_month</th>\n",
       "      <th>stays_in_weekend_nights</th>\n",
       "      <th>stays_in_week_nights</th>\n",
       "      <th>adults</th>\n",
       "      <th>children</th>\n",
       "      <th>babies</th>\n",
       "      <th>is_repeated_guest</th>\n",
       "      <th>previous_cancellations</th>\n",
       "      <th>previous_bookings_not_canceled</th>\n",
       "      <th>booking_changes</th>\n",
       "      <th>agent</th>\n",
       "      <th>company</th>\n",
       "      <th>days_in_waiting_list</th>\n",
       "      <th>adr</th>\n",
       "      <th>required_car_parking_spaces</th>\n",
       "      <th>total_of_special_requests</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119386.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>103050.000000</td>\n",
       "      <td>6797.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "      <td>119390.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.370416</td>\n",
       "      <td>104.011416</td>\n",
       "      <td>2016.156554</td>\n",
       "      <td>27.165173</td>\n",
       "      <td>15.798241</td>\n",
       "      <td>0.927599</td>\n",
       "      <td>2.500302</td>\n",
       "      <td>1.856403</td>\n",
       "      <td>0.103890</td>\n",
       "      <td>0.007949</td>\n",
       "      <td>0.031912</td>\n",
       "      <td>0.087118</td>\n",
       "      <td>0.137097</td>\n",
       "      <td>0.221124</td>\n",
       "      <td>86.693382</td>\n",
       "      <td>189.266735</td>\n",
       "      <td>2.321149</td>\n",
       "      <td>101.831122</td>\n",
       "      <td>0.062518</td>\n",
       "      <td>0.571363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.482918</td>\n",
       "      <td>106.863097</td>\n",
       "      <td>0.707476</td>\n",
       "      <td>13.605138</td>\n",
       "      <td>8.780829</td>\n",
       "      <td>0.998613</td>\n",
       "      <td>1.908286</td>\n",
       "      <td>0.579261</td>\n",
       "      <td>0.398561</td>\n",
       "      <td>0.097436</td>\n",
       "      <td>0.175767</td>\n",
       "      <td>0.844336</td>\n",
       "      <td>1.497437</td>\n",
       "      <td>0.652306</td>\n",
       "      <td>110.774548</td>\n",
       "      <td>131.655015</td>\n",
       "      <td>17.594721</td>\n",
       "      <td>50.535790</td>\n",
       "      <td>0.245291</td>\n",
       "      <td>0.792798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2015.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-6.380000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>62.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>69.290000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>2016.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>179.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>94.575000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>160.000000</td>\n",
       "      <td>2017.000000</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>229.000000</td>\n",
       "      <td>270.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>126.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>737.000000</td>\n",
       "      <td>2017.000000</td>\n",
       "      <td>53.000000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>26.000000</td>\n",
       "      <td>72.000000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>535.000000</td>\n",
       "      <td>543.000000</td>\n",
       "      <td>391.000000</td>\n",
       "      <td>5400.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         is_canceled      lead_time  arrival_date_year  \\\n",
       "count  119390.000000  119390.000000      119390.000000   \n",
       "mean        0.370416     104.011416        2016.156554   \n",
       "std         0.482918     106.863097           0.707476   \n",
       "min         0.000000       0.000000        2015.000000   \n",
       "25%         0.000000      18.000000        2016.000000   \n",
       "50%         0.000000      69.000000        2016.000000   \n",
       "75%         1.000000     160.000000        2017.000000   \n",
       "max         1.000000     737.000000        2017.000000   \n",
       "\n",
       "       arrival_date_week_number  arrival_date_day_of_month  \\\n",
       "count             119390.000000              119390.000000   \n",
       "mean                  27.165173                  15.798241   \n",
       "std                   13.605138                   8.780829   \n",
       "min                    1.000000                   1.000000   \n",
       "25%                   16.000000                   8.000000   \n",
       "50%                   28.000000                  16.000000   \n",
       "75%                   38.000000                  23.000000   \n",
       "max                   53.000000                  31.000000   \n",
       "\n",
       "       stays_in_weekend_nights  stays_in_week_nights         adults  \\\n",
       "count            119390.000000         119390.000000  119390.000000   \n",
       "mean                  0.927599              2.500302       1.856403   \n",
       "std                   0.998613              1.908286       0.579261   \n",
       "min                   0.000000              0.000000       0.000000   \n",
       "25%                   0.000000              1.000000       2.000000   \n",
       "50%                   1.000000              2.000000       2.000000   \n",
       "75%                   2.000000              3.000000       2.000000   \n",
       "max                  19.000000             50.000000      55.000000   \n",
       "\n",
       "            children         babies  is_repeated_guest  \\\n",
       "count  119386.000000  119390.000000      119390.000000   \n",
       "mean        0.103890       0.007949           0.031912   \n",
       "std         0.398561       0.097436           0.175767   \n",
       "min         0.000000       0.000000           0.000000   \n",
       "25%         0.000000       0.000000           0.000000   \n",
       "50%         0.000000       0.000000           0.000000   \n",
       "75%         0.000000       0.000000           0.000000   \n",
       "max        10.000000      10.000000           1.000000   \n",
       "\n",
       "       previous_cancellations  previous_bookings_not_canceled  \\\n",
       "count           119390.000000                   119390.000000   \n",
       "mean                 0.087118                        0.137097   \n",
       "std                  0.844336                        1.497437   \n",
       "min                  0.000000                        0.000000   \n",
       "25%                  0.000000                        0.000000   \n",
       "50%                  0.000000                        0.000000   \n",
       "75%                  0.000000                        0.000000   \n",
       "max                 26.000000                       72.000000   \n",
       "\n",
       "       booking_changes          agent      company  days_in_waiting_list  \\\n",
       "count    119390.000000  103050.000000  6797.000000         119390.000000   \n",
       "mean          0.221124      86.693382   189.266735              2.321149   \n",
       "std           0.652306     110.774548   131.655015             17.594721   \n",
       "min           0.000000       1.000000     6.000000              0.000000   \n",
       "25%           0.000000       9.000000    62.000000              0.000000   \n",
       "50%           0.000000      14.000000   179.000000              0.000000   \n",
       "75%           0.000000     229.000000   270.000000              0.000000   \n",
       "max          21.000000     535.000000   543.000000            391.000000   \n",
       "\n",
       "                 adr  required_car_parking_spaces  total_of_special_requests  \n",
       "count  119390.000000                119390.000000              119390.000000  \n",
       "mean      101.831122                     0.062518                   0.571363  \n",
       "std        50.535790                     0.245291                   0.792798  \n",
       "min        -6.380000                     0.000000                   0.000000  \n",
       "25%        69.290000                     0.000000                   0.000000  \n",
       "50%        94.575000                     0.000000                   0.000000  \n",
       "75%       126.000000                     0.000000                   1.000000  \n",
       "max      5400.000000                     8.000000                   5.000000  "
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "b0010d01",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 119390 entries, 0 to 119389\n",
      "Data columns (total 32 columns):\n",
      " #   Column                          Non-Null Count   Dtype  \n",
      "---  ------                          --------------   -----  \n",
      " 0   hotel                           119390 non-null  object \n",
      " 1   is_canceled                     119390 non-null  int64  \n",
      " 2   lead_time                       119390 non-null  int64  \n",
      " 3   arrival_date_year               119390 non-null  int64  \n",
      " 4   arrival_date_month              119390 non-null  object \n",
      " 5   arrival_date_week_number        119390 non-null  int64  \n",
      " 6   arrival_date_day_of_month       119390 non-null  int64  \n",
      " 7   stays_in_weekend_nights         119390 non-null  int64  \n",
      " 8   stays_in_week_nights            119390 non-null  int64  \n",
      " 9   adults                          119390 non-null  int64  \n",
      " 10  children                        119386 non-null  float64\n",
      " 11  babies                          119390 non-null  int64  \n",
      " 12  meal                            119390 non-null  object \n",
      " 13  country                         118902 non-null  object \n",
      " 14  market_segment                  119390 non-null  object \n",
      " 15  distribution_channel            119390 non-null  object \n",
      " 16  is_repeated_guest               119390 non-null  int64  \n",
      " 17  previous_cancellations          119390 non-null  int64  \n",
      " 18  previous_bookings_not_canceled  119390 non-null  int64  \n",
      " 19  reserved_room_type              119390 non-null  object \n",
      " 20  assigned_room_type              119390 non-null  object \n",
      " 21  booking_changes                 119390 non-null  int64  \n",
      " 22  deposit_type                    119390 non-null  object \n",
      " 23  agent                           103050 non-null  float64\n",
      " 24  company                         6797 non-null    float64\n",
      " 25  days_in_waiting_list            119390 non-null  int64  \n",
      " 26  customer_type                   119390 non-null  object \n",
      " 27  adr                             119390 non-null  float64\n",
      " 28  required_car_parking_spaces     119390 non-null  int64  \n",
      " 29  total_of_special_requests       119390 non-null  int64  \n",
      " 30  reservation_status              119390 non-null  object \n",
      " 31  reservation_status_date         119390 non-null  object \n",
      "dtypes: float64(4), int64(16), object(12)\n",
      "memory usage: 29.1+ MB\n"
     ]
    }
   ],
   "source": [
    "mydata.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "b8df02a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "hotel                              object\n",
       "is_canceled                         int64\n",
       "lead_time                           int64\n",
       "arrival_date_year                   int64\n",
       "arrival_date_month                 object\n",
       "arrival_date_week_number            int64\n",
       "arrival_date_day_of_month           int64\n",
       "stays_in_weekend_nights             int64\n",
       "stays_in_week_nights                int64\n",
       "adults                              int64\n",
       "children                          float64\n",
       "babies                              int64\n",
       "meal                               object\n",
       "country                            object\n",
       "market_segment                     object\n",
       "distribution_channel               object\n",
       "is_repeated_guest                   int64\n",
       "previous_cancellations              int64\n",
       "previous_bookings_not_canceled      int64\n",
       "reserved_room_type                 object\n",
       "assigned_room_type                 object\n",
       "booking_changes                     int64\n",
       "deposit_type                       object\n",
       "agent                             float64\n",
       "company                           float64\n",
       "days_in_waiting_list                int64\n",
       "customer_type                      object\n",
       "adr                               float64\n",
       "required_car_parking_spaces         int64\n",
       "total_of_special_requests           int64\n",
       "reservation_status                 object\n",
       "reservation_status_date            object\n",
       "dtype: object"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "dcb6c9fd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "hotel                                  0\n",
       "is_canceled                            0\n",
       "lead_time                              0\n",
       "arrival_date_year                      0\n",
       "arrival_date_month                     0\n",
       "arrival_date_week_number               0\n",
       "arrival_date_day_of_month              0\n",
       "stays_in_weekend_nights                0\n",
       "stays_in_week_nights                   0\n",
       "adults                                 0\n",
       "children                               4\n",
       "babies                                 0\n",
       "meal                                   0\n",
       "country                              488\n",
       "market_segment                         0\n",
       "distribution_channel                   0\n",
       "is_repeated_guest                      0\n",
       "previous_cancellations                 0\n",
       "previous_bookings_not_canceled         0\n",
       "reserved_room_type                     0\n",
       "assigned_room_type                     0\n",
       "booking_changes                        0\n",
       "deposit_type                           0\n",
       "agent                              16340\n",
       "company                           112593\n",
       "days_in_waiting_list                   0\n",
       "customer_type                          0\n",
       "adr                                    0\n",
       "required_car_parking_spaces            0\n",
       "total_of_special_requests              0\n",
       "reservation_status                     0\n",
       "reservation_status_date                0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "41b0c0eb",
   "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>hotel</th>\n",
       "      <th>is_canceled</th>\n",
       "      <th>lead_time</th>\n",
       "      <th>arrival_date_year</th>\n",
       "      <th>arrival_date_month</th>\n",
       "      <th>arrival_date_week_number</th>\n",
       "      <th>arrival_date_day_of_month</th>\n",
       "      <th>stays_in_weekend_nights</th>\n",
       "      <th>stays_in_week_nights</th>\n",
       "      <th>adults</th>\n",
       "      <th>...</th>\n",
       "      <th>booking_changes</th>\n",
       "      <th>deposit_type</th>\n",
       "      <th>agent</th>\n",
       "      <th>days_in_waiting_list</th>\n",
       "      <th>customer_type</th>\n",
       "      <th>adr</th>\n",
       "      <th>required_car_parking_spaces</th>\n",
       "      <th>total_of_special_requests</th>\n",
       "      <th>reservation_status</th>\n",
       "      <th>reservation_status_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>52435</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>2016</td>\n",
       "      <td>June</td>\n",
       "      <td>24</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>191.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient-Party</td>\n",
       "      <td>120.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Canceled</td>\n",
       "      <td>06-02-2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28367</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>258</td>\n",
       "      <td>2016</td>\n",
       "      <td>September</td>\n",
       "      <td>40</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>242.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>100.8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>10-01-2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10038</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>2017</td>\n",
       "      <td>February</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>242.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>45.6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Canceled</td>\n",
       "      <td>1/30/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116677</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>184</td>\n",
       "      <td>2017</td>\n",
       "      <td>July</td>\n",
       "      <td>29</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>85.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>7/24/2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66046</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>1</td>\n",
       "      <td>141</td>\n",
       "      <td>2017</td>\n",
       "      <td>April</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>80.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Canceled</td>\n",
       "      <td>02-07-2017</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               hotel  is_canceled  lead_time  arrival_date_year  \\\n",
       "52435     City Hotel            1         24               2016   \n",
       "28367   Resort Hotel            0        258               2016   \n",
       "10038   Resort Hotel            1         32               2017   \n",
       "116677    City Hotel            0        184               2017   \n",
       "66046     City Hotel            1        141               2017   \n",
       "\n",
       "       arrival_date_month  arrival_date_week_number  \\\n",
       "52435                June                        24   \n",
       "28367           September                        40   \n",
       "10038            February                         6   \n",
       "116677               July                        29   \n",
       "66046               April                        15   \n",
       "\n",
       "        arrival_date_day_of_month  stays_in_weekend_nights  \\\n",
       "52435                           6                        1   \n",
       "28367                          29                        0   \n",
       "10038                           9                        1   \n",
       "116677                         21                        1   \n",
       "66046                          13                        0   \n",
       "\n",
       "        stays_in_week_nights  adults  ...  booking_changes  deposit_type  \\\n",
       "52435                      2       1  ...                0    No Deposit   \n",
       "28367                      2       2  ...                0    No Deposit   \n",
       "10038                      3       2  ...                0    No Deposit   \n",
       "116677                     2       2  ...                0    No Deposit   \n",
       "66046                      3       2  ...                0    No Deposit   \n",
       "\n",
       "        agent days_in_waiting_list    customer_type    adr  \\\n",
       "52435   191.0                    0  Transient-Party  120.0   \n",
       "28367   242.0                    0        Transient  100.8   \n",
       "10038   242.0                    0        Transient   45.6   \n",
       "116677   28.0                    0        Transient   85.0   \n",
       "66046    28.0                    0        Transient   80.1   \n",
       "\n",
       "        required_car_parking_spaces  total_of_special_requests  \\\n",
       "52435                             0                          0   \n",
       "28367                             0                          1   \n",
       "10038                             0                          1   \n",
       "116677                            0                          0   \n",
       "66046                             0                          0   \n",
       "\n",
       "        reservation_status reservation_status_date  \n",
       "52435             Canceled              06-02-2016  \n",
       "28367            Check-Out              10-01-2016  \n",
       "10038             Canceled               1/30/2017  \n",
       "116677           Check-Out               7/24/2017  \n",
       "66046             Canceled              02-07-2017  \n",
       "\n",
       "[5 rows x 31 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata=mydata.drop('company',axis=1)\n",
    "mydata.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "148a3597",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.0"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "median1=mydata['children'].median()\n",
    "median1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "405f78da",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.10388990333874994"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mean1=mydata['children'].mean()\n",
    "mean1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "3b360fed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14.0"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "median2=mydata['agent'].median()\n",
    "median2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "3403b9c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "mydata['children'].replace(np.nan,median1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "3ce48664",
   "metadata": {},
   "outputs": [],
   "source": [
    "mydata['agent'].replace(np.nan,median2,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "b79aa5be",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "hotel                               0\n",
       "is_canceled                         0\n",
       "lead_time                           0\n",
       "arrival_date_year                   0\n",
       "arrival_date_month                  0\n",
       "arrival_date_week_number            0\n",
       "arrival_date_day_of_month           0\n",
       "stays_in_weekend_nights             0\n",
       "stays_in_week_nights                0\n",
       "adults                              0\n",
       "children                            0\n",
       "babies                              0\n",
       "meal                                0\n",
       "country                           488\n",
       "market_segment                      0\n",
       "distribution_channel                0\n",
       "is_repeated_guest                   0\n",
       "previous_cancellations              0\n",
       "previous_bookings_not_canceled      0\n",
       "reserved_room_type                  0\n",
       "assigned_room_type                  0\n",
       "booking_changes                     0\n",
       "deposit_type                        0\n",
       "agent                               0\n",
       "days_in_waiting_list                0\n",
       "customer_type                       0\n",
       "adr                                 0\n",
       "required_car_parking_spaces         0\n",
       "total_of_special_requests           0\n",
       "reservation_status                  0\n",
       "reservation_status_date             0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "860edbcc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'PRT'"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mode=mydata['country'].mode().values[0]\n",
    "mode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "1c946f16",
   "metadata": {},
   "outputs": [],
   "source": [
    "mydata['country'].replace(np.nan,mode,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "8009d0d1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "hotel                             0\n",
       "is_canceled                       0\n",
       "lead_time                         0\n",
       "arrival_date_year                 0\n",
       "arrival_date_month                0\n",
       "arrival_date_week_number          0\n",
       "arrival_date_day_of_month         0\n",
       "stays_in_weekend_nights           0\n",
       "stays_in_week_nights              0\n",
       "adults                            0\n",
       "children                          0\n",
       "babies                            0\n",
       "meal                              0\n",
       "country                           0\n",
       "market_segment                    0\n",
       "distribution_channel              0\n",
       "is_repeated_guest                 0\n",
       "previous_cancellations            0\n",
       "previous_bookings_not_canceled    0\n",
       "reserved_room_type                0\n",
       "assigned_room_type                0\n",
       "booking_changes                   0\n",
       "deposit_type                      0\n",
       "agent                             0\n",
       "days_in_waiting_list              0\n",
       "customer_type                     0\n",
       "adr                               0\n",
       "required_car_parking_spaces       0\n",
       "total_of_special_requests         0\n",
       "reservation_status                0\n",
       "reservation_status_date           0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "9c857ac3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "32020\n"
     ]
    }
   ],
   "source": [
    "duplicates=mydata.duplicated()\n",
    "print(duplicates.sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "66ef6163",
   "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>hotel</th>\n",
       "      <th>is_canceled</th>\n",
       "      <th>lead_time</th>\n",
       "      <th>arrival_date_year</th>\n",
       "      <th>arrival_date_month</th>\n",
       "      <th>arrival_date_week_number</th>\n",
       "      <th>arrival_date_day_of_month</th>\n",
       "      <th>stays_in_weekend_nights</th>\n",
       "      <th>stays_in_week_nights</th>\n",
       "      <th>adults</th>\n",
       "      <th>...</th>\n",
       "      <th>booking_changes</th>\n",
       "      <th>deposit_type</th>\n",
       "      <th>agent</th>\n",
       "      <th>days_in_waiting_list</th>\n",
       "      <th>customer_type</th>\n",
       "      <th>adr</th>\n",
       "      <th>required_car_parking_spaces</th>\n",
       "      <th>total_of_special_requests</th>\n",
       "      <th>reservation_status</th>\n",
       "      <th>reservation_status_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>2015</td>\n",
       "      <td>July</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>98.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-03-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "      <td>2015</td>\n",
       "      <td>July</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>250.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>84.67</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-07-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "      <td>2015</td>\n",
       "      <td>July</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>250.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>137.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-07-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>2015</td>\n",
       "      <td>July</td>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>97.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Canceled</td>\n",
       "      <td>07-01-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2015</td>\n",
       "      <td>July</td>\n",
       "      <td>28</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>109.80</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-08-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119349</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>186</td>\n",
       "      <td>2017</td>\n",
       "      <td>August</td>\n",
       "      <td>35</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>126.00</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>09-03-2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119352</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>2017</td>\n",
       "      <td>August</td>\n",
       "      <td>35</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient-Party</td>\n",
       "      <td>195.33</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>09-03-2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119353</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>2017</td>\n",
       "      <td>August</td>\n",
       "      <td>35</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient-Party</td>\n",
       "      <td>195.33</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>09-03-2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119354</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>2017</td>\n",
       "      <td>August</td>\n",
       "      <td>35</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient-Party</td>\n",
       "      <td>195.33</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>09-03-2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119373</th>\n",
       "      <td>City Hotel</td>\n",
       "      <td>0</td>\n",
       "      <td>175</td>\n",
       "      <td>2017</td>\n",
       "      <td>August</td>\n",
       "      <td>35</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Transient</td>\n",
       "      <td>82.35</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>09-04-2017</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>32020 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               hotel  is_canceled  lead_time  arrival_date_year  \\\n",
       "5       Resort Hotel            0         14               2015   \n",
       "22      Resort Hotel            0         72               2015   \n",
       "43      Resort Hotel            0         70               2015   \n",
       "138     Resort Hotel            1          5               2015   \n",
       "200     Resort Hotel            0          0               2015   \n",
       "...              ...          ...        ...                ...   \n",
       "119349    City Hotel            0        186               2017   \n",
       "119352    City Hotel            0         63               2017   \n",
       "119353    City Hotel            0         63               2017   \n",
       "119354    City Hotel            0         63               2017   \n",
       "119373    City Hotel            0        175               2017   \n",
       "\n",
       "       arrival_date_month  arrival_date_week_number  \\\n",
       "5                    July                        27   \n",
       "22                   July                        27   \n",
       "43                   July                        27   \n",
       "138                  July                        28   \n",
       "200                  July                        28   \n",
       "...                   ...                       ...   \n",
       "119349             August                        35   \n",
       "119352             August                        35   \n",
       "119353             August                        35   \n",
       "119354             August                        35   \n",
       "119373             August                        35   \n",
       "\n",
       "        arrival_date_day_of_month  stays_in_weekend_nights  \\\n",
       "5                               1                        0   \n",
       "22                              1                        2   \n",
       "43                              2                        2   \n",
       "138                             5                        1   \n",
       "200                             7                        0   \n",
       "...                           ...                      ...   \n",
       "119349                         31                        0   \n",
       "119352                         31                        0   \n",
       "119353                         31                        0   \n",
       "119354                         31                        0   \n",
       "119373                         31                        1   \n",
       "\n",
       "        stays_in_week_nights  adults  ...  booking_changes  deposit_type  \\\n",
       "5                          2       2  ...                0    No Deposit   \n",
       "22                         4       2  ...                1    No Deposit   \n",
       "43                         3       2  ...                0    No Deposit   \n",
       "138                        0       2  ...                0    No Deposit   \n",
       "200                        1       1  ...                0    No Deposit   \n",
       "...                      ...     ...  ...              ...           ...   \n",
       "119349                     3       2  ...                0    No Deposit   \n",
       "119352                     3       3  ...                0    No Deposit   \n",
       "119353                     3       3  ...                0    No Deposit   \n",
       "119354                     3       3  ...                0    No Deposit   \n",
       "119373                     3       1  ...                0    No Deposit   \n",
       "\n",
       "        agent days_in_waiting_list    customer_type     adr  \\\n",
       "5       240.0                    0        Transient   98.00   \n",
       "22      250.0                    0        Transient   84.67   \n",
       "43      250.0                    0        Transient  137.00   \n",
       "138     240.0                    0        Transient   97.00   \n",
       "200     240.0                    0        Transient  109.80   \n",
       "...       ...                  ...              ...     ...   \n",
       "119349    9.0                    0        Transient  126.00   \n",
       "119352    9.0                    0  Transient-Party  195.33   \n",
       "119353    9.0                    0  Transient-Party  195.33   \n",
       "119354    9.0                    0  Transient-Party  195.33   \n",
       "119373   42.0                    0        Transient   82.35   \n",
       "\n",
       "        required_car_parking_spaces  total_of_special_requests  \\\n",
       "5                                 0                          1   \n",
       "22                                0                          1   \n",
       "43                                0                          1   \n",
       "138                               0                          0   \n",
       "200                               0                          3   \n",
       "...                             ...                        ...   \n",
       "119349                            0                          2   \n",
       "119352                            0                          2   \n",
       "119353                            0                          2   \n",
       "119354                            0                          2   \n",
       "119373                            0                          1   \n",
       "\n",
       "        reservation_status reservation_status_date  \n",
       "5                Check-Out              07-03-2015  \n",
       "22               Check-Out              07-07-2015  \n",
       "43               Check-Out              07-07-2015  \n",
       "138               Canceled              07-01-2015  \n",
       "200              Check-Out              07-08-2015  \n",
       "...                    ...                     ...  \n",
       "119349           Check-Out              09-03-2017  \n",
       "119352           Check-Out              09-03-2017  \n",
       "119353           Check-Out              09-03-2017  \n",
       "119354           Check-Out              09-03-2017  \n",
       "119373           Check-Out              09-04-2017  \n",
       "\n",
       "[32020 rows x 31 columns]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata[duplicates]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "84bd037e",
   "metadata": {},
   "outputs": [],
   "source": [
    "mydata.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "d014ee63",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dp1=mydata.duplicated()\n",
    "dp1.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "119ecc95",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(87370, 31)"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "14a45f17",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWoAAAD5CAYAAAAOXX+6AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAOfElEQVR4nO3df4zkd13H8eervYOD60kDLSs/qmv4JT+UEtYqFHQLpgIlgCcKKJCq4WKQgoSKNRGtEbQGI2gpgcpPgRQjHGB6/Gpgv61gge4Vrr1SiASKYJGfQdkTwda3f8x3y97e7M1cb+buM+zzkUz2u5/5zOfz3u/NvfYzn5nZSVUhSWrXCce7AEnS4RnUktQ4g1qSGmdQS1LjDGpJatyWaQx6yimn1Pz8/DSGlo7KgQMH2L59+/EuQzrE3r17v1FVpw67bipBPT8/z/Ly8jSGlo5K13UsLi4e7zKkQyT54kbXufUhSY0zqCWpcQa1JDXOoJakxhnUktS4sV71keQm4DvArcAtVbUwzaKkSUtySJt/kEyz4khW1GdV1emGtGbN2pDeuXPn0HapZW59aNOoKs477zxX0po5477hpYAPJingtVV16foOSXYBuwDm5uboum5iRUpHa+fOnXRdx8rKCl3XsXPnTnbv3u39VDMh46wuktyzqm5OcnfgCuC8qrpqo/4LCwvlOxPVitUtjqq67Z2Ja9ukFiTZu9HW8lhbH1V1c//1a8C7gDMmV550bCTh4osvdm9aM2dkUCfZnmTH6jFwNrB/2oVJk7J21bx79+6h7VLLxllRzwEfSbIP+ASwp6reP92ypMmqKqqKpaWl246lWTHyycSq+jzw0GNQiyRpCF+eJ0mNM6glqXEGtSQ1zqCWpMYZ1JLUOINakhpnUEtS4wxqSWqcQS1JjTOoJalxBrUkNc6glqTGGdSS1DiDWpIaZ1BLUuMMaklqnEEtSY0zqCWpcQa1JDXOoJakxhnUktQ4g1qSGmdQS1LjDGpJapxBLUmNM6glqXEGtSQ1zqCWpMYZ1JLUOINakhpnUEtS47aM2zHJicAy8O9V9cTplSRNXpJD2qrqOFQiHbkjWVG/ALhxWoVI0zIspA/XLrVmrKBOcm/gHOB10y1Hmp6qYmlpyZW0Zs64Wx+vBF4M7NioQ5JdwC6Aubk5uq472tqkieq6jpWVlYPum95PNQsyanWR5InAE6rquUkWgfNH7VEvLCzU8vLyxIqUjsbqFkdV0XUdi4uLB7VJLUiyt6oWhl03zor6TOBJSZ4AbAN+JMlbq+qZkyxSmjb3pDWrRu5RV9UfVtW9q2oeeDrwYUNas2SjVbOrac0KX0etTaGqDnoy0ZDWLBn7ddQAVdUB3VQqkSQN5YpakhpnUEtS4wxqSWqcQS1JjTOoJalxBrUkNc6glqTGGdSS1DiDWpIaZ1BLUuMMaklqnEEtSY0zqCWpcQa1JDXOoJakxhnUktQ4g1qSGmdQS1LjDGpJapxBLUmNM6glqXEGtSQ1zqCWpMYZ1JLUOINakhpnUEtS4wxqSWqcQS1JjTOoJalxBrUkNW7LqA5JtgFXAXfs+7+jqv5k2oVJk5TkkLaqOg6VSEduZFAD3wMeU1UrSbYCH0nyvqr62JRrkyZiWEivthvWmgUjtz5qYKX/dmt/8d6tmVNVLC0tGc6aOeOsqElyIrAXuC9wSVV9fEifXcAugLm5Obqum2CZ0tHruo6VlZWD7pveTzULciSriyQnA+8Czquq/Rv1W1hYqOXl5aOvTpqA1a2PqqLrOhYXFw9qk1qQZG9VLQy7bqwV9aqq+naSDngcsGFQSy3aaK9aat3IPeokp/YraZLcCfhF4DNTrkuamI1Wza6mNSvGeR31PYClJNcB1wBXVNXl0y1LmqyqOujJRENas2Tk1kdVXQc87BjUIkkawncmSlLjDGpJapxBLUmNM6glqXEGtSQ1zqCWpMYZ1JLUOINakhpnUEtS4wxqSWqcQS1JjTOoJalxBrUkNc6glqTGGdSS1DiDWpIaZ1BLUuMMaklqnEEtSY0zqCWpcQa1JDXOoJakxhnUktQ4g1qSGmdQS1LjDGpJapxBLUmNM6glqXEGtSQ1zqCWpMYZ1JLUuJFBneS0JEtJbkxyQ5IXHIvCJEkDW8bocwvwoqq6NskOYG+SK6rq01OuTZLEGCvqqvpKVV3bH38HuBG417QLkyQNjLOivk2SeeBhwMeHXLcL2AUwNzdH13UTKE/a2FlnnXXM5lpaWjpmc0nrparG65icBFwJvKyqdh+u78LCQi0vL0+gPGmy5i/Yw00XnXO8y5AOkWRvVS0Mu26sV30k2Qq8E3jbqJCWJE3WOK/6CPB64Maq+uvplyRJWmucFfWZwLOAxyT5VH95wpTrkiT1Rj6ZWFUfAXIMapEkDeE7EyWpcQa1JDXOoJakxhnUktQ4g1qSGmdQS1LjDGpJapxBLUmNM6glqXEGtSQ1zqCWpMYZ1JLUOINakhpnUEtS4wxqSWqcQS1JjTOoJalxBrUkNc6glqTGGdSS1DiDWpIaZ1BLUuMMaklqnEEtSY0zqCWpcQa1JDXOoJakxhnUktQ4g1qSGmdQS1LjRgZ1kjck+VqS/ceiIEnSwcZZUb8JeNyU65AkbWBkUFfVVcC3jkEtkqQhtkxqoCS7gF0Ac3NzdF03qaG1Sfzuhw5w4H+nP8/8BXumOv72rXDJY7dPdQ5tLhML6qq6FLgUYGFhoRYXFyc1tDaJA+/fw00XnTPVObquY9r3zfkL9kx9Dm0uvupDkhpnUEtS48Z5ed5lwNXAA5J8OclvT78sSdKqkXvUVfWMY1GIJGk4tz4kqXEGtSQ1zqCWpMYZ1JLUOINakhpnUEtS4wxqSWqcQS1JjTOoJalxBrUkNc6glqTGGdSS1DiDWpIaZ1BLUuMMaklqnEEtSY0zqCWpcQa1JDXOoJakxhnUktQ4g1qSGmdQS1LjDGpJapxBLUmNM6glqXEGtSQ1zqCWpMYZ1JLUOINakhpnUEtS4wxqSWrcWEGd5HFJPpvkc0kumHZRkqQfGBnUSU4ELgEeDzwIeEaSB027MEnSwDgr6jOAz1XV56vq+8DbgSdPtyxJ0qotY/S5F/ClNd9/GfjZ9Z2S7AJ2AczNzdF13STq0yay44EX8FNvPgY7a2+e7vA7Hghdt326k2hTGSeoM6StDmmouhS4FGBhYaEWFxePrjJtOtdz/dTn6LoO75uaNeNsfXwZOG3N9/cGbp5OOZKk9cYJ6muA+yX5iSR3AJ4O/NN0y5IkrRq59VFVtyR5HvAB4ETgDVV1w9QrkyQB4+1RU1XvBd475VokSUP4zkRJapxBLUmNM6glqXEGtSQ1LlWHvHfl6AdNvg58ceIDS0fvFOAbx7sIaYgfr6pTh10xlaCWWpVkuaoWjncd0pFw60OSGmdQS1LjDGptNpce7wKkI+UetSQ1zhW1JDXOoJakxhnUktQ4g3oTSnJykueO6DOf5NfHGGs+yf7bWcdlSa5L8sLbc/ujkeR3kjx7RJ8Lk5x/rGq6vZI8xQ+c/uFmUG9OJwOHDWpgHhgZ1LdXkh8FHllVP11Vr5jWPBupqtdU1d9ParwkY/3J4Cl5CmBQ/xAzqDeni4D7JPlUkpf3l/1Jrk/ytDV9Ht33eWG/cv7nJNf2l0eOM1GSbUne2I/9ySRn9Vd9ELh7P/6jN7jt85N8ul91v71vuzDJW5J8OMm/JnnOmv6/n+Savv+frml/dt+2L8lb1oxzfn/8nP52+5K8M8mdx/zZuiR/nuRK4AVJHp7kyiR7k3wgyT36fg/vx7569Vz37ecmedWa8S5Pstgfn933vzbJPyY5qW+/aM05+av+3+FJwMv7c3mfYedNM66qvGyyC4PV8v7++FeAKxh8es8c8G/APYBF4PI1t7kzsK0/vh+wvH6sDeZ6EfDG/vgn+/G3jbpd3/9m4I798cn91wuBfcCdGPzdji8B9wTOZvAa6TBYgFwO/DzwYOCzwCn97e+6Zpzz++O7rZnzpcB56/tsUF8HvLo/3gr8C3Bq//3TGHwaEsB1wC/0xy9fc+7PBV61ZrzL+/N+CnAVsL1v/wPgj4G79j9L1p2TNwFPPdx58zLbl+P5cE1teBRwWVXdCny1Xx3+DPBf6/ptBV6V5HTgVuD+RzD+xQBV9ZkkX+xvu378Ya4D3pbk3cC717S/p6q+C3w3yRJwRj/P2cAn+z4nMfiF8lDgHVX1jb6Gbw2Z5yFJXspgS+gkBh87N65/6L8+AHgIcEUSGPzi+0qSuzAIyyv7fm8BHj9izJ9jsJXx0X6sOwBXMzhn/wO8LskeBsE+zEbnTTPKoFbG7PdC4KsMgu8EBoExyfGHOYfBqvhJwEuSPLhvX/8urern+Yuqeu1BkyfPH9J/vTcBT6mqfUnOZbCqHdeB1amAG6rqEevmP/kw89/CwduP29aMdUVVPWP9DZKcATyWwYdMPw94zJBxDzlvVXXLWD+NmuQe9eb0HWBHf3wV8LQkJyY5lcF/8E+s6wNwF+ArVfV/wLMYrBjHcRXwGwBJ7g/8GIOH74eV5ATgtKpaAl7MD1a7AE/u977vxiBUr2GwCv6tNXu590pyd+BDwK/1fUly1yHT7WCw+t26Wuvt8Fng1CSP6OfZ2gfkt4H/TPKovt/a8W8CTk9yQpLTGDwyAPgYcGaS+/Zj3TnJ/fuf7S41+AzT3wNO7/vf9m814rxpRrmi3oSq6ptJPto/qfU+Bg+V9zFY+b24qv4jyTeBW5LsY7DifDXwziS/Cizxg5XkKK8GXpPkegYryHOr6nv9Q/rDORF4a791EOAVVfXt/nafAPYwCP0/q6qbgZuTPBC4uu+zAjyzqm5I8jLgyiS3MtgaOXfdXC8BPs7gb6hfz8G/oMZSVd9P8lTgb/uatwCvBG4AfhN4Q5L/5uBtlY8CX+jn3A9c24/19X5lf1mSO/Z9/4hBIL8nybb+nKy+rPHtwN/1jx6eDrx+/Xk70p9HbfFvfWimJLkQWKmqvzretdweSeYZPEn7kONdi2aHWx+S1DhX1JqIJL8E/OW65i9U1S+PcdtLgDPXNf9NVb1xUvUdjdbr0w8/g1qSGufWhyQ1zqCWpMYZ1JLUOINakhr3/yLx0feSulkkAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "mydata.boxplot(column=['total_of_special_requests'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "9b769782",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD5CAYAAAAp8/5SAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAYm0lEQVR4nO3df5TV9X3n8edrRgNbhtZtiVNRyNAeVqFmdZOpNqLJTA0MEFvTrpuFbTQ/OCGDhq1rsgcI+bGphwOctNnTRJkRgzGxKcmaxlYjkZlNuPEHagIGI4JpKBCgeGLJD+Sii2HmvX/c73Auw525d+6d4d779fU45575fj/fX+/rHV/z4XO/PxQRmJlZejVUuwAzMxtbDnozs5Rz0JuZpZyD3sws5Rz0ZmYpd061Cyhk0qRJ0dLSUu0yzM5w/PhxJkyYUO0yzM6wffv2IxHxxkLLajLoW1pa2LZtW7XLMDtDJpOhra2t2mWYnUHST4da5qEbM7OUc9CbmaWcg97MLOUc9GZmKeegNzNLOQe9WQk2btzIpZdeyrXXXsull17Kxo0bq12SWclq8vRKs1qyceNGVq5cyYYNG+jr66OxsZFFixYBsHDhwipXZ1ace/RmRaxatYoNGzbQ3t7OOeecQ3t7Oxs2bGDVqlXVLs2sJA56syJ2797N1VdffVrb1Vdfze7du6tUkdnIOOjNipgxYwaPP/74aW2PP/44M2bMqFJFZiPjoDcrYuXKlSxatIgtW7Zw8uRJtmzZwqJFi1i5cmW1SzMrib+MNSti4AvXpUuXsnv3bmbMmMGqVav8RazVDdXiM2NbW1vDNzWzWuSbmlmtkrQ9IloLLfPQjZlZyjnozcxSzkFvZpZyDnqzEvgWCFbPfNaNWRG+BYLVO/fozYrwLRCs3jnozYrwLRCs3jnozYrwLRCs3hUNekn3SHpJ0s68tq9L2pG89kvaMcS2+yU9l6znK6CsLvkWCFbvSvky9l7gDuArAw0R8V8HpiX9DXB0mO3bI+JIuQWaVZtvgWD1rmjQR8SjkloKLZMk4D3AH49yXWY1ZeHChSxcuNC3QLC6VOnpldcAP4uInwyxPIAeSQHcFRHrh9qRpMXAYoDm5mYymUyFpZmNvmw2699NqzuVBv1CYLgrR2ZFxGFJ5wO9kl6IiEcLrZj8EVgPuZuauddktcg9eqtHZZ91I+kc4M+Brw+1TkQcTn6+BDwAXFHu8czMrDyVnF75TuCFiDhUaKGkCZImDkwDc4CdhdY1M7OxU8rplRuBJ4GLJR2StChZtIBBwzaSJkvalMw2A49Lehb4PvBwRDwyeqWbmVkpSjnrpuA5ZBHx/gJth4H5yfRe4LIK6zMzswr5ylgzs5Rz0JuZpZyD3sws5Rz0ZmYp56A3M0s5B72ZWco56M3MUs5Bb1aCjo4OGhoaaG9vp6GhgY6OjmqXZFYyB71ZER0dHfT09NDZ2clDDz1EZ2cnPT09DnurG5XevdIs9Xp7e1myZAnr1q0jk8mwbt06ALq7u6tcmVlp3KM3KyIiWL169Wltq1evJiKqVJHZyDjozYqQxIoVK05rW7FiBbkHrJnVPg/dmBUxe/Zsurq6AJg/fz4333wzXV1dzJkzp8qVmZVGtfjPz9bW1ti2bVu1yzA7paOjg97eXiICScyePZvNmzdXuyyzUyRtj4jWQsvcozcrwUCo+1GCVo88Rm9mlnIOejOzlCvlUYL3SHpJ0s68tv8l6V8l7Uhe84fYdq6kH0vaI2n5aBZuZmalKaVHfy8wt0D7/46Iy5PXpsELJTUCdwLzgJnAQkkzKynWzMxGrmjQR8SjwC/K2PcVwJ6I2BsRrwFfA64vYz9mZlaBSs66+Yikm4BtwEcj4peDll8IHMybPwRcOdTOJC0GFgM0NzeTyWQqKM1sbGSzWf9uWt0pN+i7gNuBSH7+DfDBQesUumxwyJP2I2I9sB5y59H7FDarRT690upRWWfdRMTPIqIvIvqBu8kN0wx2CJiSN38RcLic45mZWfnKCnpJF+TN/hmws8BqPwCmS5om6Q3AAuDBco5nZmblKzp0I2kj0AZMknQI+DTQJulyckMx+4EPJ+tOBr4YEfMj4qSkjwCbgUbgnoh4fizehJmZDa1o0EfEwgLNG4ZY9zAwP29+E3DGqZdmZnb2+MpYM7OUc9CblWDp0qWMHz+e9vZ2xo8fz9KlS6tdklnJfPdKsyKWLl1Kd3c3a9euZebMmezatYtly5YB8IUvfKHK1ZkV5x69WRF33303a9eu5bbbbmP8+PHcdtttrF27lrvvvrvapZmVxEFvVsSJEyfo7Ow8ra2zs5MTJ05UqSKzkXHQmxUxbtw4uru7T2vr7u5m3LhxVarIbGQ8Rm9WxIc+9KFTY/IzZ87kc5/7HMuWLTujl29Wqxz0ZkUMfOH68Y9/nBMnTjBu3Dg6Ozv9RazVDT8c3GwEfFMzq1XDPRzcY/RmZinnoDczSzkHvZlZyjnozUrQ0dFBQ0MD7e3tNDQ00NHRUe2SzErmoDcroqOjg56eHjo7O3nooYfo7Oykp6fHYW91w6dXmhXR29vLkiVLWLduHZlMhnXr1gGccRGVWa1yj96siIhg9erVp7WtXr2aWjw12awQB71ZEZJYsWLFaW0rVqxAUpUqMhuZUh4leA9wHfBSRFyatH0W+BPgNeBfgA9ExK8KbLsfOAb0ASeHOpnfrJbNnj2brq4uAObPn8/NN99MV1cXc+bMqXJlZqUpemWspLcDWeAreUE/B/hu8lzYtQARsazAtvuB1og4MpKifGWs1ZqOjg56e3uJCCQxe/ZsNm/eXO2yzE6p6MrYiHgU+MWgtp6IOJnMPgVcVHGVZjVs8+bN9Pf3s2XLFvr7+x3yVldG46ybDwJfH2JZAD2SArgrItYPtRNJi4HFAM3NzWQymVEozWx0ZbNZ/25a3ako6CWtBE4CXx1ilVkRcVjS+UCvpBeSfyGcIfkjsB5yQze+cZTVIt/UzOpR2WfdSHofuS9p/yKGGOiPiMPJz5eAB4Aryj2eWTVNnToVSbS3tyOJqVOnVrsks5KVFfSS5gLLgD+NiFeGWGeCpIkD08AcYGe5hZpVy9SpUzl48CBXXXUV999/P1dddRUHDx502FvdKBr0kjYCTwIXSzokaRFwBzCR3HDMDkndybqTJW1KNm0GHpf0LPB94OGIeGRM3oXZGBoI+SeeeIJJkybxxBNPnAp7s3pQdIw+IhYWaN4wxLqHgfnJ9F7gsoqqM6sR3/jGN86Ynzx5cpWqMRsZXxlrVoIbbrhh2HmzWuagNytiypQpbN26lVmzZnHkyBFmzZrF1q1bmTJlSrVLMyuJ715pVsSBAweYOnUqW7duZevWrUAu/A8cOFDlysxK4x69WQkOHDhARLBlyxYiwiFvdcVBb2aWcg56M7OUc9CbmaWcg97MLOUc9GZmKeegNzNLOQe9mVnKOejNzFLOQW9mlnIOejOzlHPQm5mlnIPezCzlHPRmZilXyqME75H0kqSdeW2/LalX0k+Sn/9+iG3nSvqxpD2Slo9m4WZnU1NT02kPB29qaqp2SWYlK6VHfy8wd1DbcuA7ETEd+E4yfxpJjcCdwDxgJrBQ0syKqjWrgqamJo4fP05LSwv33XcfLS0tHD9+3GFvdaNo0EfEo8AvBjVfD3w5mf4y8O4Cm14B7ImIvRHxGvC1ZDuzujIQ8vv27eOiiy5i3759p8LerB6U+4Sp5oh4ESAiXpR0foF1LgQO5s0fAq4caoeSFgOLAZqbm8lkMmWWZjb6br/9djKZDNlslkwmw+23386NN97o31OrC2P5KEEVaIuhVo6I9cB6gNbW1mhraxujssxG7pOf/CT79u0jk8nQ1tbGtGnTAPDvqdWDcs+6+ZmkCwCSny8VWOcQkP/05IuAw2Uez6xqJkyYwP79+5k2bRqHDh1i2rRp7N+/nwkTJlS7NLOSlBv0DwLvS6bfB/xTgXV+AEyXNE3SG4AFyXZmdSWbzZ4K+xtvvPFUyGez2WqXZlaSUk6v3Ag8CVws6ZCkRcAaYLaknwCzk3kkTZa0CSAiTgIfATYDu4H/ExHPj83bMBtb2Wz2tIeDO+StnhQdo4+IhUMsurbAuoeB+Xnzm4BNZVdnZmYV85WxZmYpN5Zn3ZilRmNjI/39/afmGxoa6Ovrq2JFZqVzj96siIGQb2pqoquri6amJvr7+2lsbKx2aWYlcdCbFTEQ8seOHeOSSy7h2LFjp8LerB446M1K8L3vfW/YebNa5qA3K8E73vGOYefNapmD3qyIhoYGstksEydO5IUXXmDixIlks1kaGvy/j9UHn3VjVkRfXx+NjY1ks1mWLFkC+Kwbqy/ukpiVoK+v77QrYx3yVk8c9GZmKeegNzNLOQe9mVnK+ctYsxJIZz5HJ2LI5+iY1RT36M2KyA/5mTNnFmw3q2UOerMSRQR33nmne/JWdxz0ZiW45pprhp03q2UOerMSPPbYY8POm9WysoNe0sWSduS9XpZ066B12iQdzVvnUxVXbFYlkrjllls8Nm91p+yzbiLix8DlAJIagX8FHiiw6mMRcV25xzGrtog4Fe67du06rd2sHozW0M21wL9ExE9HaX9mNSUiTrsFgkPe6slonUe/ANg4xLK3SXoWOAx8LCKeL7SSpMXAYoDm5mYymcwolWY2erLZrH83re6o0p6JpDeQC/E/iIifDVr2m0B/RGQlzQf+NiKmF9tna2trbNu2raK6zMZCJpOhra2t2mWYnUHS9ohoLbRsNHr084BnBoc8QES8nDe9SdI6SZMi4sgoHNfsrPGVsVbPRmOMfiFDDNtI+l0l/4dIuiI53s9H4ZhmZ81AyEtizZo1p82b1YOKevSSfgOYDXw4r60TICK6gRuAJZJOAq8CC8LdIKtDkujv7yeTydDf309DQ4N79FY3Kgr6iHgF+J1Bbd1503cAd1RyDLNa8O1vf/uM+blz51apGrOR8ZWxZiWYN2/esPNmtcxBb1aCiKChoYGnn37awzZWdxz0ZkUMhHpEsHz58tPmzeqBg96sBL4y1uqZg97MLOUc9GZmKeegNzNLOT8c3KwEvgWC1TP36M2KGOpWB74FgtULB71ZifLPujGrJw56sxI0NjYOO29Wyxz0ZiXo6+sbdt6slvnLWLMSeUze6pV79GZFDDUm77F6qxcOerMS+BYIVs8c9GZmKeegNzNLuYqCXtJ+Sc9J2iFpW4HlkvR5SXsk/UjSWyo5npmZjdxonHXTHhFHhlg2D5ievK4EupKfZmZ2loz10M31wFci5yngPEkXjPExzcwsT6U9+gB6JAVwV0SsH7T8QuBg3vyhpO3FwTuStBhYDNDc3Ewmk6mwNLPhtbe3n7Vjbdmy5awdy2ywSoN+VkQclnQ+0CvphYh4NG95oStMCp6XlvyRWA/Q2toabW1tFZZmNrxyTpFsWf4w+9e8awyqMRs7FQ3dRMTh5OdLwAPAFYNWOQRMyZu/CDhcyTHNzGxkyg56SRMkTRyYBuYAOwet9iBwU3L2zR8BRyPijGEbMzMbO5UM3TQDDyT3/zgH+PuIeERSJ0BEdAObgPnAHuAV4AOVlWtmZiNVdtBHxF7gsgLt3XnTAdxS7jHMzKxyvjLWzCzlHPRmZinnoDczSzkHvZlZyjnozcxSzkFvZpZyDnozs5Rz0JuZpZyD3sws5Rz0ZmYp56A3M0s5B72ZWco56M3MUs5Bb2aWcg56M7OUc9CbmaWcg97MLOUqeWbsFElbJO2W9LykvyywTpuko5J2JK9PVVaumZmNVCXPjD0JfDQinkkeEr5dUm9E7Bq03mMRcV0FxzEzswqU3aOPiBcj4plk+hiwG7hwtAozM7PRUUmP/hRJLcB/Ap4usPhtkp4FDgMfi4jnh9jHYmAxQHNzM5lMZjRKMxt1/t20elNx0EtqAv4BuDUiXh60+BngTRGRlTQf+EdgeqH9RMR6YD1Aa2trtLW1VVqa2eh75GH8u2n1pqKzbiSdSy7kvxoR3xy8PCJejohsMr0JOFfSpEqOaWZmI1PJWTcCNgC7I+JzQ6zzu8l6SLoiOd7Pyz2mmZmNXCVDN7OAG4HnJO1I2j4OTAWIiG7gBmCJpJPAq8CCiIgKjmlmZiOkWszd1tbW2LZtW7XLsDpz2Wd6OPrqr6tdRsV+69+dy7OfnlPtMqzOSNoeEa2Flo3KWTdmteDoq79m/5p3jekxMpnMmH8Z27L84THdv73++BYIZmYp56A3M0s5B72ZWco56M3MUs5Bb2aWcg56M7OUc9CbmaWcg97MLOUc9GZmKecrYy01Js5Yzpu/vHzsD/Tlsd39xBkAY3uFr72+OOgtNY7tXuNbIJgV4KEbM7OUc9CbmaWcg97MLOUc9GZmKeegNzNLuUofDj5X0o8l7ZF0xnltyvl8svxHkt5SyfHMzGzkKnk4eCNwJzAPmAkslDRz0GrzgOnJazHQVe7xzMysPJX06K8A9kTE3oh4DfgacP2gda4HvhI5TwHnSbqggmOamdkIVXLB1IXAwbz5Q8CVJaxzIfDi4J1JWkyu109zczOZTKaC0uz1aiQXG/107XVjWMnp3rTsWyWvO+Fc/Ptvo6qSoFeBtihjnVxjxHpgPUBra2uM9dWHlj7720a4wZqCv4rDOhtXxpqNtkqGbg4BU/LmLwIOl7GOmZmNoUqC/gfAdEnTJL0BWAA8OGidB4GbkrNv/gg4GhFnDNuYmdnYKXvoJiJOSvoIsBloBO6JiOcldSbLu4FNwHxgD/AK8IHKSzYzs5Go6O6VEbGJXJjnt3XnTQdwSyXHMDOzyvjKWDOzlHPQm5mlnIPezCzlHPRmZimn3PeltUXSvwE/rXYdZgVMAo5UuwizAt4UEW8stKAmg96sVknaFhGt1a7DbCQ8dGNmlnIOejOzlHPQm43M+moXYDZSHqM3M0s59+jNzFLOQW9mlnIOejOzlHPQ26iQdKuk3zgLx/krSe8c6+OUUEeLpJ1jsN97Jd1QxnZ/Kml5kXXaJBV8puHZ+vysOhz0NlpuBcY8KCLiUxHxf8f6OPUmIh6MiDUV7OJWzsLnZ9XhoLcRkzRB0sOSnpW0U9KngcnAFklbknW6JG2T9LykzyRt10p6IG8/syV9U1Jj0pPdKek5Sf9jmGOf6vFK2i/pM5KeSba7ZJjtnpN0XvK0s59Luilpv0/SO5MaPivpB5J+JOnDedv+z7z2zxTY9+9J+qGkP5T0+5IekbRd0mMDNSV1f17SVkl7896DJN0haZekh4Hzi/y3L/ieJb1f0h3J9O9Leiqp+a8kZfN20STpG5JekPTV5Pj/Pf/zG8nnYXUiIvzya0Qv4D8Dd+fN/xawH5iU1/bbyc9GIAP8R3IPi38BeGOy7O+BPwHeCvTmbXveMMe+F7ghmd4PLE2mbwa+OMx23cC7gEvJPQbz7qT9J0ATsBj4RNI2DtgGTAPmkDt3XuQ6Rt8C3g60ADuBi4EfApcn234HmJ5MXwl8N6/u+5N9zAT2JO1/DvQm/50mA78aeH9DvI+C7xl4P3BHMv0tYGEy3Qlkk+k24Ci5Zzc3AE8CV+ftd1IyXfLn4Vd9vNyjt3I8B7xT0lpJ10TE0QLrvEfSM+RC8A+AmZFLjfuA90o6D3gb8G1gL/B7kr4gaS7w8ghq+Wbyczu58B3KY+QC+u1AF/BmSRcCv4iILLlAv0nSDuBp4HeA6Un7nOR9PANckrQDvBH4J+C9EbFDUhNwFXB/sp+7gAvyavjHiOiPiF1Ac9L2dmBjRPRFxGHgu6Pwnt9G7o8K5P6Y5vt+RByKiH5gxxDbV/J5WA2q6FGC9voUEf8s6a3knge8WlJP/nJJ04CPAX8YEb+UdC8wPln8JeAh4P8B90fESeCXki4DOsg9evI9wAdLLOdE8rOP4X+fH032PRVYCfwZcAO5PwCQ67EvjYjNg95LB7A6Iu4a1N5Crnd8EJgFPE+ul/yriLi8SK0Dxxsw0qsWS33PxWoouH3ymZX7eVgNco/eRkzSZOCViPg74K+BtwDHgInJKr8JHAeOSmoG5g1sm/RaDwOfIDecgaRJQENE/APwyWR/oyoiDpK7xfD0iNgLPE7uj9FA0G8Glkg6N6npP0iakLR/MOmtI+lCSQPj6K8B7yb3L4H/FhEvA/sk/ZdkXSWBOZxHgQXJuPgFQPsovN2nyA2vASwocZtTn9/Z+Dzs7HKP3srxZuCzkvqBXwNLSIZhJL0YEe2Sfkiul7sXeGLQ9l8lN06/K5m/EPiSpIGOx4oxqvtpcmPhkAv41eQCH+CL5IYxnpEk4N+Ad0dEj6QZwJO5ZrLAe8n1homI45KuA3olHQf+AuiS9AngXOBrwLPD1PQA8MfkhsP+GfjeKLzPW4G/k/RR4GFy//IoZj3J55dsfzY+DztLfK8bO+uSs0N+GBEbql1LGil3PvyrERGSFpD7Yvb6atdl1eMevZ1VkraTG9b5aLVrSbG3Anck/zL5FR5ff91zj95qkqQ7yX3Jme9vI+JLRbb7APCXg5qfiIhbRrO+sabc9QbTBjUvG/xlsVkpHPRmZinns27MzFLOQW9mlnIOejOzlHPQm5ml3P8HOF0/jKm26EYAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "mydata.boxplot(column=['stays_in_weekend_nights'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "90999a13",
   "metadata": {},
   "outputs": [],
   "source": [
    "def remove_outlier(co1):\n",
    "    sorted(co1)\n",
    "    Q1,Q3=co1.quantile([0.25,0.75])\n",
    "    IQR=Q3-Q1\n",
    "    lower_range=Q1-(1.5+IQR)\n",
    "    upper_range=Q3+(1.5+IQR)\n",
    "    return lower_range,upper_range"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "75e43190",
   "metadata": {},
   "outputs": [],
   "source": [
    "lowstays_in_weekend_nights,uppstays_in_weekend_nights=remove_outlier(mydata['stays_in_weekend_nights'])\n",
    "mydata['stays_in_weekend_nights']=np.where(mydata['stays_in_weekend_nights']>uppstays_in_weekend_nights,uppstays_in_weekend_nights,mydata['stays_in_weekend_nights'])\n",
    "mydata['stays_in_weekend_nights']=np.where(mydata['stays_in_weekend_nights']<lowstays_in_weekend_nights,lowstays_in_weekend_nights,mydata['stays_in_weekend_nights'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "3576d777",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWoAAAD5CAYAAAAOXX+6AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAOA0lEQVR4nO3dfZBd9V3H8fcHEq2GKKOhOzzULq3YgmJb2bZTUWahSGnBtip2QLHWOrNaEcFBbTqiDv2HdOo4PsAgKS0whZYRC1pJy4MlV0oF2iRACQ9WBsPA0BmKLU9R2wJf/7hnYUk22Ztmz+4v7Ps1s7N3zz33nO/l3rz3cO7d3VQVkqR27bXYA0iSds5QS1LjDLUkNc5QS1LjDLUkNW5ZHxtdtWpVjY+P97Fpabds3bqVFStWLPYY0nY2btz4WFXtN9t1vYR6fHycDRs29LFpabcMBgMmJycXewxpO0ke3NF1nvqQpMYZaklqnKGWpMYZaklqnKGWpMb18q4PqTVJtlvmLyTTnsIjar3kzRbpnS2XWmOotWRUFevXr/dIWnscQy1JjTPUktQ4X0zUkuE5ae2pPKLWS96Ozkl7rlp7CkOtJaGqXvRiopHWnsRQS1LjDLUkNc5QS1LjDLUkNc5QS1LjDLUkNc5QS1LjDLUkNc5QS1LjDLUkNW6kX8qUZAvwFPAs8ExVTfQ5lCTpBbvy2/OOrqrHeptEkjQrT31IUuNGPaIu4PokBVxYVWu3XSHJFDAFMDY2xmAwmLchpdkcffTRC7av9evXL9i+pG1llF/3mOSAqnokycuBG4DTq+qmHa0/MTFRGzZsmMcxpfkxvnodW9acsNhjSNtJsnFHr/+NdOqjqh7pPj8KXA28af7GkyTtzJyhTrIiycrpy8BxwOa+B5MkDY1yjnoMuLr7e3PLgE9V1bW9TiVJet6coa6qB4DXLcAskqRZ+PY8SWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWrcyKFOsneS25Nc0+dAkqQX25Uj6jOAe/saRJI0u5FCneQg4ATgon7HkSRta9mI6/018CfAyh2tkGQKmAIYGxtjMBjs7mxSL3xuak8zZ6iTnAg8WlUbk0zuaL2qWgusBZiYmKjJyR2uKi2ea9fhc1N7mlFOfRwJvDPJFuAK4Jgkl/U6lSTpeXOGuqo+VFUHVdU4cDJwY1Wd2vtkkiTA91FLUvNGfTERgKoaAINeJpEkzcojaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklqnKGWpMYZaklq3JyhTvKyJF9OcmeSu5OcsxCDSZKGlo2wzreBY6rq6STLgZuTfL6qbu15NkkSI4S6qgp4uvtyefdRfQ4lSXrBKEfUJNkb2Aj8OHB+Vd02yzpTwBTA2NgYg8FgHseU5o/PTe1pMjxgHnHlZF/gauD0qtq8o/UmJiZqw4YNuz+dNM/GV69jy5oTFnsMaTtJNlbVxGzX7dK7PqrqcWAAHL/7Y0mSRjHKuz72646kSfIDwLHAfT3PJUnqjHKOen/g0u489V7AP1TVNf2OJUmaNsq7Pr4KvGEBZpEkzcKfTJSkxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxhlqSWqcoZakxs0Z6iSvSLI+yb1J7k5yxkIMJkkaWjbCOs8AZ1XVpiQrgY1Jbqiqe3qeTZLECEfUVfX1qtrUXX4KuBc4sO/BJElDoxxRPy/JOPAG4LZZrpsCpgDGxsYYDAbzMJ6WktO+sJWt3+1/P+Or1/W6/RXL4fy3ruh1H1paRg51kn2AzwBnVtWT215fVWuBtQATExM1OTk5XzNqidh67Tq2rDmh130MBgP6fm6Or17X+z60tIz0ro8kyxlG+vKquqrfkSRJM43yro8AHwfuraq/6n8kSdJMoxxRHwn8BnBMkju6j3f0PJckqTPnOeqquhnIAswiSZqFP5koSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY0z1JLUOEMtSY2bM9RJPpHk0SSbF2IgSdKLjXJEfQlwfM9zSJJ2YM5QV9VNwDcXYBZJ0iyWzdeGkkwBUwBjY2MMBoP52rSWiJWHrubwS1f3v6NL+938ykNhMFjR7060pMxbqKtqLbAWYGJioiYnJ+dr01oinlq9hi1rTuh1H4PBgL6fm+Or1zH5m/3uQ0uL7/qQpMYZaklq3Chvz/s0cAvwmiQPJ/nt/seSJE2b8xx1VZ2yEINIkmbnqQ9JapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJapyhlqTGGWpJatxIoU5yfJL/SHJ/ktV9DyVJesGcoU6yN3A+8HbgMOCUJIf1PZgkaWiUI+o3AfdX1QNV9R3gCuBd/Y4lSZq2bIR1DgQemvH1w8Cbt10pyRQwBTA2NsZgMJiP+bTEjK9eN/K6D37kxB4nebFXfvCakdddsRyf/5pXo4Q6syyr7RZUrQXWAkxMTNTk5OTuTaYlZ8vkLt5gzXZPwzkNBgN8bmpPM8qpj4eBV8z4+iDgkX7GkSRta5RQfwU4JMnBSb4POBn4bL9jSZKmzXnqo6qeSfL7wHXA3sAnquru3ieTJAGjnaOmqj4HfK7nWSRJs/AnEyWpcYZakhpnqCWpcYZakhqXql3/oYE5N5p8A3hw3jcs7b5VwGOLPYQ0i1dW1X6zXdFLqKVWJdlQVROLPYe0Kzz1IUmNM9SS1DhDraVm7WIPIO0qz1FLUuM8opakxhlqSWqcoZakxhlqAZDkzCQ/uAD7+XCSY/vezwhzjCfZ3MN2L0ly0vdwu3cmWT3HOpNJZv2bYAv1+GlxGGpNOxPo/R96Vf15Vf1r3/vZ01TVZ6tqzW5s4kwW4PHT4jDUS1CSFUnWJbkzyeYkfwEcAKxPsr5b54IkG5LcneScbtlbk1w9Yzu/kOSqJHt3R5Kbk9yV5A93su/njziTbElyTpJN3e1eu5Pb3ZVk3wz9d5L3dss/meTYboaPJvlKkq8m+Z0Zt/3jGcvPmWXbr0pye5I3Jnl1kmuTbEzyxemZurn/Nsm/J3lgxn1IkvOS3JNkHfDyOf7bz3qfk7wvyXnd5VcnubWb+cNJnp6xiX2S/GOS+5Jc3u3/D2Y+frvyeGgPUVV+LLEP4FeAj834+oeBLcCqGct+pPu8NzAAfprhHzq+D9ivu+5TwC8CRwA3zLjtvjvZ9yXASd3lLcDp3eXfAy7aye3+HjgB+CmGfx7uY93y/wT2AaaAs7tl3w9sAA4GjmP43ukwPDC5BjgKGAc2A68Bbgde3932C8Ah3eU3AzfOmPvKbhuHAfd3y38ZuKH773QA8Pj0/dvB/Zj1PgPvA87rLl8DnNJd/l3g6e7yJPAEw79buhdwC/BzM7a7qrs88uPhx57x4RH10nQXcGySjyT5+ap6YpZ13pNkE8OI/SRwWA3/1X8SODXJvsBbgM8DDwCvSvJ3SY4HntyFWa7qPm9kGM8d+SLDwB4FXAAcnuRA4JtV9TTDIL83yR3AbcCPAod0y4/r7scm4LXdcoD9gH8GTq2qO5LsA/wscGW3nQuB/WfM8E9V9VxV3QOMdcuOAj5dVc9W1SPAjfNwn9/C8JsCDL8ZzvTlqnq4qp4D7tjB7Xfn8VCDRvpTXHppqaqvJTkCeAdwbpLrZ16f5GDgj4A3VtW3klwCvKy7+mLgX4D/A66sqmeAbyV5HfA24DTgPcD7Rxzn293nZ9n58/Gmbts/Bvwp8EvASQwDDsMj5tOr6rpt7svbgHOr6sJtlo8zPDp9CDgSuJvhUerjVfX6OWad3t+0Xf2psVHv81wzzHr77jH7Xh8PNcgj6iUoyQHA/1TVZcBfAj8DPAWs7Fb5IWAr8ESSMeDt07ftjhofAc5meDqAJKuAvarqM8CfddubV1X1EMNfUXpIVT0A3Mzwm8l0qK8DPpBkeTfTTyRZ0S1/f3e0TJIDk0yfR/4O8G6GR+K/VlVPAv+V5Fe7ddMFb2duAk7uzgvvDxw9D3f3VoanpwBOHvE2zz9+C/F4aGF5RL00HQ58NMlzwHeBD9Cdxkjy9ao6OsntDI8yHwC+tM3tL2d4nvqe7usDgYuTTH/j/1BPc9/G8FwwDAN9LsNgA1zE8DTApiQBvgG8u6quT3IocMtwMU8DpzI8GqWqtiY5EbghyVbg14ELkpwNLAeuAO7cyUxXA8cwPJ30NeDf5uF+nglcluQsYB3DI/+5rKV7/LrbL8TjoQXi7/rQLuvenXB7VX18sWd5Kcrw/dD/W1WV5GSGLyy+a7Hn0uLxiFq7JMlGhqdFzlrsWV7CjgDO6/7P4HE8v7zkeUStXiQ5n+GLdDP9TVVdPMftfgs4Y5vFX6qq0+Zzvr5l+H7zg7dZ/MFtX+yURmGoJalxvutDkhpnqCWpcYZakhpnqCWpcf8PoXNYkxdviugAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "mydata.boxplot(column=['stays_in_weekend_nights'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "7a4c0dec",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "StandardScaler()"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.preprocessing import StandardScaler\n",
    "std_scale=StandardScaler()\n",
    "std_scale"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "8d05eec1",
   "metadata": {},
   "outputs": [],
   "source": [
    "mydata['is_canceled']=std_scale.fit_transform(mydata[['is_canceled']])\n",
    "mydata['lead_time']=std_scale.fit_transform(mydata[['lead_time']])\n",
    "mydata['arrival_date_year']=std_scale.fit_transform(mydata[['arrival_date_year']])\n",
    "mydata['arrival_date_week_number']=std_scale.fit_transform(mydata[['arrival_date_week_number']])\n",
    "mydata['arrival_date_day_of_month']=std_scale.fit_transform(mydata[['arrival_date_day_of_month']])\n",
    "mydata['stays_in_weekend_nights']=std_scale.fit_transform(mydata[['stays_in_weekend_nights']])\n",
    "mydata['stays_in_week_nights']=std_scale.fit_transform(mydata[['stays_in_week_nights']])\n",
    "mydata['adults']=std_scale.fit_transform(mydata[['adults']])\n",
    "mydata['children']=std_scale.fit_transform(mydata[['children']])\n",
    "mydata['babies']=std_scale.fit_transform(mydata[['babies']])\n",
    "mydata['is_repeated_guest']=std_scale.fit_transform(mydata[['is_repeated_guest']])\n",
    "mydata['previous_cancellations']=std_scale.fit_transform(mydata[['previous_cancellations']])\n",
    "mydata['previous_bookings_not_canceled']=std_scale.fit_transform(mydata[['previous_bookings_not_canceled']])\n",
    "mydata['booking_changes']=std_scale.fit_transform(mydata[['booking_changes']])\n",
    "mydata['agent']=std_scale.fit_transform(mydata[['agent']])\n",
    "mydata['days_in_waiting_list']=std_scale.fit_transform(mydata[['days_in_waiting_list']])\n",
    "mydata['adr']=std_scale.fit_transform(mydata[['adr']])\n",
    "mydata['required_car_parking_spaces']=std_scale.fit_transform(mydata[['required_car_parking_spaces']])\n",
    "mydata['total_of_special_requests']=std_scale.fit_transform(mydata[['total_of_special_requests']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "6464a76a",
   "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>hotel</th>\n",
       "      <th>is_canceled</th>\n",
       "      <th>lead_time</th>\n",
       "      <th>arrival_date_year</th>\n",
       "      <th>arrival_date_month</th>\n",
       "      <th>arrival_date_week_number</th>\n",
       "      <th>arrival_date_day_of_month</th>\n",
       "      <th>stays_in_weekend_nights</th>\n",
       "      <th>stays_in_week_nights</th>\n",
       "      <th>adults</th>\n",
       "      <th>...</th>\n",
       "      <th>booking_changes</th>\n",
       "      <th>deposit_type</th>\n",
       "      <th>agent</th>\n",
       "      <th>days_in_waiting_list</th>\n",
       "      <th>customer_type</th>\n",
       "      <th>adr</th>\n",
       "      <th>required_car_parking_spaces</th>\n",
       "      <th>total_of_special_requests</th>\n",
       "      <th>reservation_status</th>\n",
       "      <th>reservation_status_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>-0.615833</td>\n",
       "      <td>3.045556</td>\n",
       "      <td>-1.763984</td>\n",
       "      <td>July</td>\n",
       "      <td>0.011736</td>\n",
       "      <td>-1.676934</td>\n",
       "      <td>-1.000824</td>\n",
       "      <td>-1.278582</td>\n",
       "      <td>0.198010</td>\n",
       "      <td>...</td>\n",
       "      <td>3.751152</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>-0.635000</td>\n",
       "      <td>-0.07485</td>\n",
       "      <td>Transient</td>\n",
       "      <td>-1.933442</td>\n",
       "      <td>-0.299218</td>\n",
       "      <td>-0.839768</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-01-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>-0.615833</td>\n",
       "      <td>7.635592</td>\n",
       "      <td>-1.763984</td>\n",
       "      <td>July</td>\n",
       "      <td>0.011736</td>\n",
       "      <td>-1.676934</td>\n",
       "      <td>-1.000824</td>\n",
       "      <td>-1.278582</td>\n",
       "      <td>0.198010</td>\n",
       "      <td>...</td>\n",
       "      <td>5.126043</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>-0.635000</td>\n",
       "      <td>-0.07485</td>\n",
       "      <td>Transient</td>\n",
       "      <td>-1.933442</td>\n",
       "      <td>-0.299218</td>\n",
       "      <td>-0.839768</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-01-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>-0.615833</td>\n",
       "      <td>-0.847259</td>\n",
       "      <td>-1.763984</td>\n",
       "      <td>July</td>\n",
       "      <td>0.011736</td>\n",
       "      <td>-1.676934</td>\n",
       "      <td>-1.000824</td>\n",
       "      <td>-0.791651</td>\n",
       "      <td>-1.398237</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.373520</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>-0.635000</td>\n",
       "      <td>-0.07485</td>\n",
       "      <td>Transient</td>\n",
       "      <td>-0.569903</td>\n",
       "      <td>-0.299218</td>\n",
       "      <td>-0.839768</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-02-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>-0.615833</td>\n",
       "      <td>-0.777537</td>\n",
       "      <td>-1.763984</td>\n",
       "      <td>July</td>\n",
       "      <td>0.011736</td>\n",
       "      <td>-1.676934</td>\n",
       "      <td>-1.000824</td>\n",
       "      <td>-0.791651</td>\n",
       "      <td>-1.398237</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.373520</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>2.035301</td>\n",
       "      <td>-0.07485</td>\n",
       "      <td>Transient</td>\n",
       "      <td>-0.569903</td>\n",
       "      <td>-0.299218</td>\n",
       "      <td>-0.839768</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-02-2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Resort Hotel</td>\n",
       "      <td>-0.615833</td>\n",
       "      <td>-0.765916</td>\n",
       "      <td>-1.763984</td>\n",
       "      <td>July</td>\n",
       "      <td>0.011736</td>\n",
       "      <td>-1.676934</td>\n",
       "      <td>-1.000824</td>\n",
       "      <td>-0.304720</td>\n",
       "      <td>0.198010</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.373520</td>\n",
       "      <td>No Deposit</td>\n",
       "      <td>1.445993</td>\n",
       "      <td>-0.07485</td>\n",
       "      <td>Transient</td>\n",
       "      <td>-0.151752</td>\n",
       "      <td>-0.299218</td>\n",
       "      <td>0.362239</td>\n",
       "      <td>Check-Out</td>\n",
       "      <td>07-03-2015</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          hotel  is_canceled  lead_time  arrival_date_year arrival_date_month  \\\n",
       "0  Resort Hotel    -0.615833   3.045556          -1.763984               July   \n",
       "1  Resort Hotel    -0.615833   7.635592          -1.763984               July   \n",
       "2  Resort Hotel    -0.615833  -0.847259          -1.763984               July   \n",
       "3  Resort Hotel    -0.615833  -0.777537          -1.763984               July   \n",
       "4  Resort Hotel    -0.615833  -0.765916          -1.763984               July   \n",
       "\n",
       "   arrival_date_week_number  arrival_date_day_of_month  \\\n",
       "0                  0.011736                  -1.676934   \n",
       "1                  0.011736                  -1.676934   \n",
       "2                  0.011736                  -1.676934   \n",
       "3                  0.011736                  -1.676934   \n",
       "4                  0.011736                  -1.676934   \n",
       "\n",
       "   stays_in_weekend_nights  stays_in_week_nights    adults  ...  \\\n",
       "0                -1.000824             -1.278582  0.198010  ...   \n",
       "1                -1.000824             -1.278582  0.198010  ...   \n",
       "2                -1.000824             -0.791651 -1.398237  ...   \n",
       "3                -1.000824             -0.791651 -1.398237  ...   \n",
       "4                -1.000824             -0.304720  0.198010  ...   \n",
       "\n",
       "   booking_changes  deposit_type     agent days_in_waiting_list customer_type  \\\n",
       "0         3.751152    No Deposit -0.635000             -0.07485     Transient   \n",
       "1         5.126043    No Deposit -0.635000             -0.07485     Transient   \n",
       "2        -0.373520    No Deposit -0.635000             -0.07485     Transient   \n",
       "3        -0.373520    No Deposit  2.035301             -0.07485     Transient   \n",
       "4        -0.373520    No Deposit  1.445993             -0.07485     Transient   \n",
       "\n",
       "        adr  required_car_parking_spaces  total_of_special_requests  \\\n",
       "0 -1.933442                    -0.299218                  -0.839768   \n",
       "1 -1.933442                    -0.299218                  -0.839768   \n",
       "2 -0.569903                    -0.299218                  -0.839768   \n",
       "3 -0.569903                    -0.299218                  -0.839768   \n",
       "4 -0.151752                    -0.299218                   0.362239   \n",
       "\n",
       "   reservation_status reservation_status_date  \n",
       "0           Check-Out              07-01-2015  \n",
       "1           Check-Out              07-01-2015  \n",
       "2           Check-Out              07-02-2015  \n",
       "3           Check-Out              07-02-2015  \n",
       "4           Check-Out              07-03-2015  \n",
       "\n",
       "[5 rows x 31 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "936a6454",
   "metadata": {},
   "outputs": [],
   "source": [
    "dummies=pd.get_dummies(mydata[['hotel','arrival_date_month','meal','country','market_segment','distribution_channel','reserved_room_type','assigned_room_type','deposit_type','customer_type','reservation_status','reservation_status_date']],\n",
    "                       columns=['hotel','arrival_date_month','meal','country','market_segment','distribution_channel','reserved_room_type','assigned_room_type','deposit_type','customer_type','reservation_status','reservation_status_date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "6647662b",
   "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>hotel_City Hotel</th>\n",
       "      <th>hotel_Resort Hotel</th>\n",
       "      <th>arrival_date_month_April</th>\n",
       "      <th>arrival_date_month_August</th>\n",
       "      <th>arrival_date_month_December</th>\n",
       "      <th>arrival_date_month_February</th>\n",
       "      <th>arrival_date_month_January</th>\n",
       "      <th>arrival_date_month_July</th>\n",
       "      <th>arrival_date_month_June</th>\n",
       "      <th>arrival_date_month_March</th>\n",
       "      <th>...</th>\n",
       "      <th>reservation_status_date_9/26/2015</th>\n",
       "      <th>reservation_status_date_9/26/2016</th>\n",
       "      <th>reservation_status_date_9/27/2015</th>\n",
       "      <th>reservation_status_date_9/27/2016</th>\n",
       "      <th>reservation_status_date_9/28/2015</th>\n",
       "      <th>reservation_status_date_9/28/2016</th>\n",
       "      <th>reservation_status_date_9/29/2015</th>\n",
       "      <th>reservation_status_date_9/29/2016</th>\n",
       "      <th>reservation_status_date_9/30/2015</th>\n",
       "      <th>reservation_status_date_9/30/2016</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 1167 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   hotel_City Hotel  hotel_Resort Hotel  arrival_date_month_April  \\\n",
       "0                 0                   1                         0   \n",
       "1                 0                   1                         0   \n",
       "2                 0                   1                         0   \n",
       "3                 0                   1                         0   \n",
       "4                 0                   1                         0   \n",
       "\n",
       "   arrival_date_month_August  arrival_date_month_December  \\\n",
       "0                          0                            0   \n",
       "1                          0                            0   \n",
       "2                          0                            0   \n",
       "3                          0                            0   \n",
       "4                          0                            0   \n",
       "\n",
       "   arrival_date_month_February  arrival_date_month_January  \\\n",
       "0                            0                           0   \n",
       "1                            0                           0   \n",
       "2                            0                           0   \n",
       "3                            0                           0   \n",
       "4                            0                           0   \n",
       "\n",
       "   arrival_date_month_July  arrival_date_month_June  arrival_date_month_March  \\\n",
       "0                        1                        0                         0   \n",
       "1                        1                        0                         0   \n",
       "2                        1                        0                         0   \n",
       "3                        1                        0                         0   \n",
       "4                        1                        0                         0   \n",
       "\n",
       "   ...  reservation_status_date_9/26/2015  reservation_status_date_9/26/2016  \\\n",
       "0  ...                                  0                                  0   \n",
       "1  ...                                  0                                  0   \n",
       "2  ...                                  0                                  0   \n",
       "3  ...                                  0                                  0   \n",
       "4  ...                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/27/2015  reservation_status_date_9/27/2016  \\\n",
       "0                                  0                                  0   \n",
       "1                                  0                                  0   \n",
       "2                                  0                                  0   \n",
       "3                                  0                                  0   \n",
       "4                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/28/2015  reservation_status_date_9/28/2016  \\\n",
       "0                                  0                                  0   \n",
       "1                                  0                                  0   \n",
       "2                                  0                                  0   \n",
       "3                                  0                                  0   \n",
       "4                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/29/2015  reservation_status_date_9/29/2016  \\\n",
       "0                                  0                                  0   \n",
       "1                                  0                                  0   \n",
       "2                                  0                                  0   \n",
       "3                                  0                                  0   \n",
       "4                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/30/2015  reservation_status_date_9/30/2016  \n",
       "0                                  0                                  0  \n",
       "1                                  0                                  0  \n",
       "2                                  0                                  0  \n",
       "3                                  0                                  0  \n",
       "4                                  0                                  0  \n",
       "\n",
       "[5 rows x 1167 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dummies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "b3fb60d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "mydata=pd.concat([mydata,dummies],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "954fbd86",
   "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>hotel_City Hotel</th>\n",
       "      <th>hotel_Resort Hotel</th>\n",
       "      <th>arrival_date_month_April</th>\n",
       "      <th>arrival_date_month_August</th>\n",
       "      <th>arrival_date_month_December</th>\n",
       "      <th>arrival_date_month_February</th>\n",
       "      <th>arrival_date_month_January</th>\n",
       "      <th>arrival_date_month_July</th>\n",
       "      <th>arrival_date_month_June</th>\n",
       "      <th>arrival_date_month_March</th>\n",
       "      <th>...</th>\n",
       "      <th>reservation_status_date_9/26/2015</th>\n",
       "      <th>reservation_status_date_9/26/2016</th>\n",
       "      <th>reservation_status_date_9/27/2015</th>\n",
       "      <th>reservation_status_date_9/27/2016</th>\n",
       "      <th>reservation_status_date_9/28/2015</th>\n",
       "      <th>reservation_status_date_9/28/2016</th>\n",
       "      <th>reservation_status_date_9/29/2015</th>\n",
       "      <th>reservation_status_date_9/29/2016</th>\n",
       "      <th>reservation_status_date_9/30/2015</th>\n",
       "      <th>reservation_status_date_9/30/2016</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 1167 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   hotel_City Hotel  hotel_Resort Hotel  arrival_date_month_April  \\\n",
       "0                 0                   1                         0   \n",
       "1                 0                   1                         0   \n",
       "2                 0                   1                         0   \n",
       "3                 0                   1                         0   \n",
       "4                 0                   1                         0   \n",
       "\n",
       "   arrival_date_month_August  arrival_date_month_December  \\\n",
       "0                          0                            0   \n",
       "1                          0                            0   \n",
       "2                          0                            0   \n",
       "3                          0                            0   \n",
       "4                          0                            0   \n",
       "\n",
       "   arrival_date_month_February  arrival_date_month_January  \\\n",
       "0                            0                           0   \n",
       "1                            0                           0   \n",
       "2                            0                           0   \n",
       "3                            0                           0   \n",
       "4                            0                           0   \n",
       "\n",
       "   arrival_date_month_July  arrival_date_month_June  arrival_date_month_March  \\\n",
       "0                        1                        0                         0   \n",
       "1                        1                        0                         0   \n",
       "2                        1                        0                         0   \n",
       "3                        1                        0                         0   \n",
       "4                        1                        0                         0   \n",
       "\n",
       "   ...  reservation_status_date_9/26/2015  reservation_status_date_9/26/2016  \\\n",
       "0  ...                                  0                                  0   \n",
       "1  ...                                  0                                  0   \n",
       "2  ...                                  0                                  0   \n",
       "3  ...                                  0                                  0   \n",
       "4  ...                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/27/2015  reservation_status_date_9/27/2016  \\\n",
       "0                                  0                                  0   \n",
       "1                                  0                                  0   \n",
       "2                                  0                                  0   \n",
       "3                                  0                                  0   \n",
       "4                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/28/2015  reservation_status_date_9/28/2016  \\\n",
       "0                                  0                                  0   \n",
       "1                                  0                                  0   \n",
       "2                                  0                                  0   \n",
       "3                                  0                                  0   \n",
       "4                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/29/2015  reservation_status_date_9/29/2016  \\\n",
       "0                                  0                                  0   \n",
       "1                                  0                                  0   \n",
       "2                                  0                                  0   \n",
       "3                                  0                                  0   \n",
       "4                                  0                                  0   \n",
       "\n",
       "   reservation_status_date_9/30/2015  reservation_status_date_9/30/2016  \n",
       "0                                  0                                  0  \n",
       "1                                  0                                  0  \n",
       "2                                  0                                  0  \n",
       "3                                  0                                  0  \n",
       "4                                  0                                  0  \n",
       "\n",
       "[5 rows x 1167 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dummies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "8481da46",
   "metadata": {},
   "outputs": [],
   "source": [
    "columns=['hotel','arrival_date_month','meal','country','market_segment','distribution_channel','reserved_room_type','assigned_room_type','deposit_type','customer_type','reservation_status','reservation_status_date']\n",
    "mydata=pd.concat([mydata,dummies],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "34c3a39e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "hotel                                 object\n",
       "is_canceled                          float64\n",
       "lead_time                            float64\n",
       "arrival_date_year                    float64\n",
       "arrival_date_month                    object\n",
       "                                      ...   \n",
       "reservation_status_date_9/28/2016      uint8\n",
       "reservation_status_date_9/29/2015      uint8\n",
       "reservation_status_date_9/29/2016      uint8\n",
       "reservation_status_date_9/30/2015      uint8\n",
       "reservation_status_date_9/30/2016      uint8\n",
       "Length: 2365, dtype: object"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydata.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "31ed4100",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1a510a03",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2792aa65",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}