sofia.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import csv\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import category_encoders as ce\n",
    "import collections\n",
    "from sklearn import preprocessing\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "from sklearn.cluster import KMeans\n",
    "from sklearn.decomposition import PCA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 111733 entries, 0 to 111732\n",
      "Data columns (total 29 columns):\n",
      "ID                      111733 non-null int64\n",
      "Nationality             111733 non-null object\n",
      "Age                     107561 non-null float64\n",
      "DaysSinceCreation       111733 non-null int64\n",
      "NameHash                111733 non-null object\n",
      "DocIDHash               110732 non-null object\n",
      "AverageLeadTime         111733 non-null int64\n",
      "LodgingRevenue          111733 non-null float64\n",
      "OtherRevenue            111733 non-null float64\n",
      "BookingsCanceled        111733 non-null int64\n",
      "BookingsNoShowed        111733 non-null int64\n",
      "BookingsCheckedIn       111733 non-null int64\n",
      "PersonsNights           111733 non-null int64\n",
      "RoomNights              111733 non-null int64\n",
      "DistributionChannel     111733 non-null object\n",
      "MarketSegment           111733 non-null object\n",
      "SRHighFloor             111733 non-null int64\n",
      "SRLowFloor              111733 non-null int64\n",
      "SRAccessibleRoom        111733 non-null int64\n",
      "SRMediumFloor           111733 non-null int64\n",
      "SRBathtub               111733 non-null int64\n",
      "SRShower                111733 non-null int64\n",
      "SRCrib                  111733 non-null int64\n",
      "SRKingSizeBed           111733 non-null int64\n",
      "SRTwinBed               111733 non-null int64\n",
      "SRNearElevator          111733 non-null int64\n",
      "SRAwayFromElevator      111733 non-null int64\n",
      "SRNoAlcoholInMiniBar    111733 non-null int64\n",
      "SRQuietRoom             111733 non-null int64\n",
      "dtypes: float64(3), int64(21), object(5)\n",
      "memory usage: 24.7+ MB\n"
     ]
    }
   ],
   "source": [
    "ds = pd.read_csv(r'C:\\Users\\Sofia\\OneDrive - NOVAIMS\\Nova IMS\\Mestrado\\2º semestre\\Business Cases\\BC2\\dataset.csv', sep=\";\")\n",
    "ds.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>ID</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>55867.000000</td>\n",
       "      <td>32254.683151</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27934.0</td>\n",
       "      <td>55867.0</td>\n",
       "      <td>83800.0</td>\n",
       "      <td>111733.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Age</td>\n",
       "      <td>107561.0</td>\n",
       "      <td>45.639191</td>\n",
       "      <td>17.244952</td>\n",
       "      <td>-10.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>123.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>DaysSinceCreation</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>595.026599</td>\n",
       "      <td>374.657382</td>\n",
       "      <td>36.0</td>\n",
       "      <td>288.0</td>\n",
       "      <td>522.0</td>\n",
       "      <td>889.0</td>\n",
       "      <td>1385.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>AverageLeadTime</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>60.833147</td>\n",
       "      <td>85.115320</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>588.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>LodgingRevenue</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>283.851283</td>\n",
       "      <td>379.131556</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>393.3</td>\n",
       "      <td>21781.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>OtherRevenue</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>64.682802</td>\n",
       "      <td>123.580715</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>8859.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsCanceled</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.002282</td>\n",
       "      <td>0.080631</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsNoShowed</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.000600</td>\n",
       "      <td>0.028217</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsCheckedIn</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.737607</td>\n",
       "      <td>0.730889</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>76.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PersonsNights</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>4.328318</td>\n",
       "      <td>4.630739</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>116.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>RoomNights</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>2.203825</td>\n",
       "      <td>2.301637</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>185.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRHighFloor</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.042512</td>\n",
       "      <td>0.201755</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRLowFloor</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.001307</td>\n",
       "      <td>0.036125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRAccessibleRoom</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.000224</td>\n",
       "      <td>0.014957</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRMediumFloor</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.000770</td>\n",
       "      <td>0.027733</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRBathtub</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.003132</td>\n",
       "      <td>0.055881</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRShower</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.001629</td>\n",
       "      <td>0.040327</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRCrib</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.016181</td>\n",
       "      <td>0.126173</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRKingSizeBed</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.363268</td>\n",
       "      <td>0.480943</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRTwinBed</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.156811</td>\n",
       "      <td>0.363624</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRNearElevator</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.000331</td>\n",
       "      <td>0.018195</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRAwayFromElevator</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.003598</td>\n",
       "      <td>0.059874</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRNoAlcoholInMiniBar</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.000197</td>\n",
       "      <td>0.014031</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRQuietRoom</td>\n",
       "      <td>111733.0</td>\n",
       "      <td>0.087718</td>\n",
       "      <td>0.282886</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         count          mean           std   min      25%  \\\n",
       "ID                    111733.0  55867.000000  32254.683151   1.0  27934.0   \n",
       "Age                   107561.0     45.639191     17.244952 -10.0     33.0   \n",
       "DaysSinceCreation     111733.0    595.026599    374.657382  36.0    288.0   \n",
       "AverageLeadTime       111733.0     60.833147     85.115320  -1.0      0.0   \n",
       "LodgingRevenue        111733.0    283.851283    379.131556   0.0      0.0   \n",
       "OtherRevenue          111733.0     64.682802    123.580715   0.0      0.0   \n",
       "BookingsCanceled      111733.0      0.002282      0.080631   0.0      0.0   \n",
       "BookingsNoShowed      111733.0      0.000600      0.028217   0.0      0.0   \n",
       "BookingsCheckedIn     111733.0      0.737607      0.730889   0.0      0.0   \n",
       "PersonsNights         111733.0      4.328318      4.630739   0.0      0.0   \n",
       "RoomNights            111733.0      2.203825      2.301637   0.0      0.0   \n",
       "SRHighFloor           111733.0      0.042512      0.201755   0.0      0.0   \n",
       "SRLowFloor            111733.0      0.001307      0.036125   0.0      0.0   \n",
       "SRAccessibleRoom      111733.0      0.000224      0.014957   0.0      0.0   \n",
       "SRMediumFloor         111733.0      0.000770      0.027733   0.0      0.0   \n",
       "SRBathtub             111733.0      0.003132      0.055881   0.0      0.0   \n",
       "SRShower              111733.0      0.001629      0.040327   0.0      0.0   \n",
       "SRCrib                111733.0      0.016181      0.126173   0.0      0.0   \n",
       "SRKingSizeBed         111733.0      0.363268      0.480943   0.0      0.0   \n",
       "SRTwinBed             111733.0      0.156811      0.363624   0.0      0.0   \n",
       "SRNearElevator        111733.0      0.000331      0.018195   0.0      0.0   \n",
       "SRAwayFromElevator    111733.0      0.003598      0.059874   0.0      0.0   \n",
       "SRNoAlcoholInMiniBar  111733.0      0.000197      0.014031   0.0      0.0   \n",
       "SRQuietRoom           111733.0      0.087718      0.282886   0.0      0.0   \n",
       "\n",
       "                          50%      75%        max  \n",
       "ID                    55867.0  83800.0  111733.00  \n",
       "Age                      47.0     58.0     123.00  \n",
       "DaysSinceCreation       522.0    889.0    1385.00  \n",
       "AverageLeadTime          21.0     95.0     588.00  \n",
       "LodgingRevenue          208.0    393.3   21781.00  \n",
       "OtherRevenue             31.0     84.0    8859.25  \n",
       "BookingsCanceled          0.0      0.0      15.00  \n",
       "BookingsNoShowed          0.0      0.0       3.00  \n",
       "BookingsCheckedIn         1.0      1.0      76.00  \n",
       "PersonsNights             4.0      6.0     116.00  \n",
       "RoomNights                2.0      3.0     185.00  \n",
       "SRHighFloor               0.0      0.0       1.00  \n",
       "SRLowFloor                0.0      0.0       1.00  \n",
       "SRAccessibleRoom          0.0      0.0       1.00  \n",
       "SRMediumFloor             0.0      0.0       1.00  \n",
       "SRBathtub                 0.0      0.0       1.00  \n",
       "SRShower                  0.0      0.0       1.00  \n",
       "SRCrib                    0.0      0.0       1.00  \n",
       "SRKingSizeBed             0.0      1.0       1.00  \n",
       "SRTwinBed                 0.0      0.0       1.00  \n",
       "SRNearElevator            0.0      0.0       1.00  \n",
       "SRAwayFromElevator        0.0      0.0       1.00  \n",
       "SRNoAlcoholInMiniBar      0.0      0.0       1.00  \n",
       "SRQuietRoom               0.0      0.0       1.00  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Summary statistics for all variables\n",
    "summary=ds.describe(exclude=[np.object])   # exclude only objects, that decrease readability and do not bring information\n",
    "summary=summary.transpose()  # transpose the summary for easier reading\n",
    "summary.head(len(summary))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Questões gerais:\n",
    "- Faz sentido analisarmos pessoas que não têm qualquer booking feito? Acho que não... têm valor de 0 em quase todas as variáveis.\n",
    "- Quando é que foram recolhidos os dados? Data\n",
    "- O que são os GDS Systems? É um distribution channel que junta os voos aos hotéis?\n",
    "- A informação que temos na altura do booking varia consoante o tipo de channel?\n",
    "\n",
    "Hash questions:\n",
    "- É normal algumas pessoas com bookings feitos não terem documento identificação associado? Ser null...\n",
    "- Pode acontecer que uma empresa faça bookings para os seus colaboradores e o DocIDHash seja igual para todos eles? Há tuplos com o mesmo Doc ID, mas com idades muito diferentes.\n",
    "- Há um DocIDHash com 3000 observações com idades diferentes e muitos nulls na age, e tem todo o tipo de distribution channel. O que pode querer dizer?\n",
    "No caso acima não faz sentido fazer merge porque claramente os bookings não dizem respeito todos à mesma pessoa... mas como controlamos isto? -> quando podemos ou não fazer merge.\n",
    "\n",
    "Variáveis questões:\n",
    "- O que fazemos com pessoas menores de idade? Que razões existem para eles estarem na nossa base de dados?\n",
    "- As variáveis binárias são uma média das estadias ou têm a ver com a última estadia? O que fazemos quando fazemos merge de linhas?\n",
    "- Avg lead time of -1? Means something or is an error? O empregado alterou os dados após a reserva, para corrigir algo?\n",
    "\n",
    "1as conclusões das estatísticas descritivas:\n",
    "- Age tem valor mínimo de -10 e máximo de 123 - coherence check\n",
    "- Avg lead time of -1. Há alguma diferença entre o quartil dos 75% e o valor máximo e a média - possíveis outliers\n",
    "- Lodging revenue - claros outliers\n",
    "- Other revenue - claros outliers\n",
    "- bookings cancelled - check for outliers\n",
    "- boockings checked in - check for outliers\n",
    "- persons nights - outliers\n",
    "- room nights - outliers\n",
    "\n",
    "Possíveis sugestões de implementação:\n",
    "- Criar ficha cliente -> para beneficiar os clientes recorrentes.\n",
    "- Guardar o nome da empresa quando é corporate."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B934CA495991B7852B855    3031\n",
       "0xA486FBACF4B4E5537B026743E3FDFE571D716839E758236F42950A61FE6B922B      30\n",
       "0x2B17E9D2CCEF2EA0FE752EE345BEDFB06741FFC8ECECF45D6BBDBAF9A274FF52      23\n",
       "0x469CF1F9CF8C790FFA5AD3F484F2938CBEFF6435BCFD734F687EC6D1E968F076      14\n",
       "0x2A14D03A4827C67E0D39408F103DB417AD496DCE6158F8309E6281185C042003      13\n",
       "                                                                      ... \n",
       "0xD359E23B8879D21FFA271EADDF098C4C7E7A07C7B6666AE1FEB9F23A984C1A2B       1\n",
       "0x86A7B697DF700697B9A56E7010022A88075619FC7BDCC1F3F2B0B1DE64761853       1\n",
       "0x79FA2DB0DE3010AD0A47FEFEEFE8FD367A0388D364F25338AACF8B25FCA4B186       1\n",
       "0x5EBCE941491F2771DB2E98B0A5A570165C03B8A2E4521C727B71D8977AB1FA1A       1\n",
       "0x6621771A6B2B429EBA37BA589CB2CE35E2B84C96FCACB20E97C2E4EF42AC1DDC       1\n",
       "Name: DocIDHash, Length: 3085, dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds[(ds.duplicated(subset=['DocIDHash']))].DocIDHash.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "a=ds[(ds.duplicated(subset=['DocIDHash','NameHash'], keep=False))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "a=a[~a.DocIDHash.isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "b=a[a.duplicated(subset=['DocIDHash','NameHash','Nationality'], keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>ID</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Age</th>\n",
       "      <th>DaysSinceCreation</th>\n",
       "      <th>NameHash</th>\n",
       "      <th>DocIDHash</th>\n",
       "      <th>AverageLeadTime</th>\n",
       "      <th>LodgingRevenue</th>\n",
       "      <th>OtherRevenue</th>\n",
       "      <th>BookingsCanceled</th>\n",
       "      <th>...</th>\n",
       "      <th>SRMediumFloor</th>\n",
       "      <th>SRBathtub</th>\n",
       "      <th>SRShower</th>\n",
       "      <th>SRCrib</th>\n",
       "      <th>SRKingSizeBed</th>\n",
       "      <th>SRTwinBed</th>\n",
       "      <th>SRNearElevator</th>\n",
       "      <th>SRAwayFromElevator</th>\n",
       "      <th>SRNoAlcoholInMiniBar</th>\n",
       "      <th>SRQuietRoom</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>61171</td>\n",
       "      <td>61172</td>\n",
       "      <td>FRA</td>\n",
       "      <td>60.0</td>\n",
       "      <td>480</td>\n",
       "      <td>0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...</td>\n",
       "      <td>0x00006E606D590F336C289D2CC995A0C726878BCAC001...</td>\n",
       "      <td>127</td>\n",
       "      <td>318.0</td>\n",
       "      <td>148.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61250</td>\n",
       "      <td>61251</td>\n",
       "      <td>FRA</td>\n",
       "      <td>60.0</td>\n",
       "      <td>479</td>\n",
       "      <td>0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...</td>\n",
       "      <td>0x00006E606D590F336C289D2CC995A0C726878BCAC001...</td>\n",
       "      <td>1</td>\n",
       "      <td>177.0</td>\n",
       "      <td>14.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44434</td>\n",
       "      <td>44435</td>\n",
       "      <td>IND</td>\n",
       "      <td>38.0</td>\n",
       "      <td>629</td>\n",
       "      <td>0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...</td>\n",
       "      <td>0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...</td>\n",
       "      <td>0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>38.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44336</td>\n",
       "      <td>44337</td>\n",
       "      <td>IND</td>\n",
       "      <td>38.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...</td>\n",
       "      <td>0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...</td>\n",
       "      <td>80</td>\n",
       "      <td>498.0</td>\n",
       "      <td>157.47</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63775</td>\n",
       "      <td>63776</td>\n",
       "      <td>GBR</td>\n",
       "      <td>49.0</td>\n",
       "      <td>460</td>\n",
       "      <td>0x591E70AF9A305B5592F30EC4645878DE67AB1C6755B9...</td>\n",
       "      <td>0x001478086F84325B65735E7A4980BCD9CC8A2C609EE9...</td>\n",
       "      <td>305</td>\n",
       "      <td>216.0</td>\n",
       "      <td>320.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2114</td>\n",
       "      <td>2115</td>\n",
       "      <td>ESP</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1323</td>\n",
       "      <td>0x9A6D4033D479DB80B1EE58A38193FC1481E0943A249B...</td>\n",
       "      <td>0xFFC8E8CE49A4A882225B210B488EB8959153A1CDD538...</td>\n",
       "      <td>0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>38.00</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",
       "      <td>42422</td>\n",
       "      <td>42423</td>\n",
       "      <td>NLD</td>\n",
       "      <td>43.0</td>\n",
       "      <td>673</td>\n",
       "      <td>0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...</td>\n",
       "      <td>0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...</td>\n",
       "      <td>1</td>\n",
       "      <td>118.0</td>\n",
       "      <td>14.00</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",
       "      <td>44332</td>\n",
       "      <td>44333</td>\n",
       "      <td>NLD</td>\n",
       "      <td>43.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...</td>\n",
       "      <td>0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...</td>\n",
       "      <td>75</td>\n",
       "      <td>519.0</td>\n",
       "      <td>245.00</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",
       "      <td>27179</td>\n",
       "      <td>27180</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.0</td>\n",
       "      <td>900</td>\n",
       "      <td>0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...</td>\n",
       "      <td>0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...</td>\n",
       "      <td>21</td>\n",
       "      <td>115.0</td>\n",
       "      <td>15.50</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28075</td>\n",
       "      <td>28076</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.0</td>\n",
       "      <td>887</td>\n",
       "      <td>0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...</td>\n",
       "      <td>0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...</td>\n",
       "      <td>34</td>\n",
       "      <td>180.0</td>\n",
       "      <td>54.20</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>1</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>5498 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID Nationality   Age  DaysSinceCreation  \\\n",
       "61171  61172         FRA  60.0                480   \n",
       "61250  61251         FRA  60.0                479   \n",
       "44434  44435         IND  38.0                629   \n",
       "44336  44337         IND  38.0                630   \n",
       "63775  63776         GBR  49.0                460   \n",
       "...      ...         ...   ...                ...   \n",
       "2114    2115         ESP  46.0               1323   \n",
       "42422  42423         NLD  43.0                673   \n",
       "44332  44333         NLD  43.0                630   \n",
       "27179  27180         USA  39.0                900   \n",
       "28075  28076         USA  39.0                887   \n",
       "\n",
       "                                                NameHash  \\\n",
       "61171  0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...   \n",
       "61250  0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...   \n",
       "44434  0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...   \n",
       "44336  0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...   \n",
       "63775  0x591E70AF9A305B5592F30EC4645878DE67AB1C6755B9...   \n",
       "...                                                  ...   \n",
       "2114   0x9A6D4033D479DB80B1EE58A38193FC1481E0943A249B...   \n",
       "42422  0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...   \n",
       "44332  0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...   \n",
       "27179  0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...   \n",
       "28075  0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...   \n",
       "\n",
       "                                               DocIDHash  AverageLeadTime  \\\n",
       "61171  0x00006E606D590F336C289D2CC995A0C726878BCAC001...              127   \n",
       "61250  0x00006E606D590F336C289D2CC995A0C726878BCAC001...                1   \n",
       "44434  0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...                0   \n",
       "44336  0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...               80   \n",
       "63775  0x001478086F84325B65735E7A4980BCD9CC8A2C609EE9...              305   \n",
       "...                                                  ...              ...   \n",
       "2114   0xFFC8E8CE49A4A882225B210B488EB8959153A1CDD538...                0   \n",
       "42422  0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...                1   \n",
       "44332  0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...               75   \n",
       "27179  0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...               21   \n",
       "28075  0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...               34   \n",
       "\n",
       "       LodgingRevenue  OtherRevenue  BookingsCanceled  ...  SRMediumFloor  \\\n",
       "61171           318.0        148.00                 0  ...              0   \n",
       "61250           177.0         14.00                 0  ...              0   \n",
       "44434           249.0         38.00                 0  ...              0   \n",
       "44336           498.0        157.47                 0  ...              0   \n",
       "63775           216.0        320.00                 0  ...              0   \n",
       "...               ...           ...               ...  ...            ...   \n",
       "2114            261.0         38.00                 0  ...              0   \n",
       "42422           118.0         14.00                 0  ...              0   \n",
       "44332           519.0        245.00                 0  ...              0   \n",
       "27179           115.0         15.50                 0  ...              0   \n",
       "28075           180.0         54.20                 0  ...              0   \n",
       "\n",
       "       SRBathtub  SRShower  SRCrib SRKingSizeBed SRTwinBed  SRNearElevator  \\\n",
       "61171          0         0       0             1         0               0   \n",
       "61250          0         0       0             1         0               0   \n",
       "44434          0         0       0             0         1               0   \n",
       "44336          0         0       0             0         1               0   \n",
       "63775          0         0       0             0         1               0   \n",
       "...          ...       ...     ...           ...       ...             ...   \n",
       "2114           0         0       0             0         0               0   \n",
       "42422          0         0       0             0         0               0   \n",
       "44332          0         0       0             0         0               0   \n",
       "27179          0         0       0             1         1               0   \n",
       "28075          0         0       0             0         1               0   \n",
       "\n",
       "       SRAwayFromElevator  SRNoAlcoholInMiniBar  SRQuietRoom  \n",
       "61171                   0                     0            1  \n",
       "61250                   0                     0            1  \n",
       "44434                   0                     0            0  \n",
       "44336                   0                     0            0  \n",
       "63775                   0                     0            1  \n",
       "...                   ...                   ...          ...  \n",
       "2114                    0                     0            0  \n",
       "42422                   0                     0            0  \n",
       "44332                   0                     0            0  \n",
       "27179                   0                     0            0  \n",
       "28075                   0                     0            0  \n",
       "\n",
       "[5498 rows x 29 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b.sort_values(by='DocIDHash')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "c=a[a.duplicated(subset=['DocIDHash','NameHash','Nationality','Age'], keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>ID</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Age</th>\n",
       "      <th>DaysSinceCreation</th>\n",
       "      <th>NameHash</th>\n",
       "      <th>DocIDHash</th>\n",
       "      <th>AverageLeadTime</th>\n",
       "      <th>LodgingRevenue</th>\n",
       "      <th>OtherRevenue</th>\n",
       "      <th>BookingsCanceled</th>\n",
       "      <th>...</th>\n",
       "      <th>SRMediumFloor</th>\n",
       "      <th>SRBathtub</th>\n",
       "      <th>SRShower</th>\n",
       "      <th>SRCrib</th>\n",
       "      <th>SRKingSizeBed</th>\n",
       "      <th>SRTwinBed</th>\n",
       "      <th>SRNearElevator</th>\n",
       "      <th>SRAwayFromElevator</th>\n",
       "      <th>SRNoAlcoholInMiniBar</th>\n",
       "      <th>SRQuietRoom</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>61250</td>\n",
       "      <td>61251</td>\n",
       "      <td>FRA</td>\n",
       "      <td>60.0</td>\n",
       "      <td>479</td>\n",
       "      <td>0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...</td>\n",
       "      <td>0x00006E606D590F336C289D2CC995A0C726878BCAC001...</td>\n",
       "      <td>1</td>\n",
       "      <td>177.0</td>\n",
       "      <td>14.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61171</td>\n",
       "      <td>61172</td>\n",
       "      <td>FRA</td>\n",
       "      <td>60.0</td>\n",
       "      <td>480</td>\n",
       "      <td>0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...</td>\n",
       "      <td>0x00006E606D590F336C289D2CC995A0C726878BCAC001...</td>\n",
       "      <td>127</td>\n",
       "      <td>318.0</td>\n",
       "      <td>148.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44336</td>\n",
       "      <td>44337</td>\n",
       "      <td>IND</td>\n",
       "      <td>38.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...</td>\n",
       "      <td>0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...</td>\n",
       "      <td>80</td>\n",
       "      <td>498.0</td>\n",
       "      <td>157.47</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44434</td>\n",
       "      <td>44435</td>\n",
       "      <td>IND</td>\n",
       "      <td>38.0</td>\n",
       "      <td>629</td>\n",
       "      <td>0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...</td>\n",
       "      <td>0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...</td>\n",
       "      <td>0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>38.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63775</td>\n",
       "      <td>63776</td>\n",
       "      <td>GBR</td>\n",
       "      <td>49.0</td>\n",
       "      <td>460</td>\n",
       "      <td>0x591E70AF9A305B5592F30EC4645878DE67AB1C6755B9...</td>\n",
       "      <td>0x001478086F84325B65735E7A4980BCD9CC8A2C609EE9...</td>\n",
       "      <td>305</td>\n",
       "      <td>216.0</td>\n",
       "      <td>320.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2036</td>\n",
       "      <td>2037</td>\n",
       "      <td>ESP</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1324</td>\n",
       "      <td>0x9A6D4033D479DB80B1EE58A38193FC1481E0943A249B...</td>\n",
       "      <td>0xFFC8E8CE49A4A882225B210B488EB8959153A1CDD538...</td>\n",
       "      <td>116</td>\n",
       "      <td>162.0</td>\n",
       "      <td>21.00</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",
       "      <td>42422</td>\n",
       "      <td>42423</td>\n",
       "      <td>NLD</td>\n",
       "      <td>43.0</td>\n",
       "      <td>673</td>\n",
       "      <td>0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...</td>\n",
       "      <td>0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...</td>\n",
       "      <td>1</td>\n",
       "      <td>118.0</td>\n",
       "      <td>14.00</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",
       "      <td>44332</td>\n",
       "      <td>44333</td>\n",
       "      <td>NLD</td>\n",
       "      <td>43.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...</td>\n",
       "      <td>0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...</td>\n",
       "      <td>75</td>\n",
       "      <td>519.0</td>\n",
       "      <td>245.00</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",
       "      <td>28075</td>\n",
       "      <td>28076</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.0</td>\n",
       "      <td>887</td>\n",
       "      <td>0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...</td>\n",
       "      <td>0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...</td>\n",
       "      <td>34</td>\n",
       "      <td>180.0</td>\n",
       "      <td>54.20</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27179</td>\n",
       "      <td>27180</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.0</td>\n",
       "      <td>900</td>\n",
       "      <td>0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...</td>\n",
       "      <td>0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...</td>\n",
       "      <td>21</td>\n",
       "      <td>115.0</td>\n",
       "      <td>15.50</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>1</td>\n",
       "      <td>1</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>5442 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID Nationality   Age  DaysSinceCreation  \\\n",
       "61250  61251         FRA  60.0                479   \n",
       "61171  61172         FRA  60.0                480   \n",
       "44336  44337         IND  38.0                630   \n",
       "44434  44435         IND  38.0                629   \n",
       "63775  63776         GBR  49.0                460   \n",
       "...      ...         ...   ...                ...   \n",
       "2036    2037         ESP  46.0               1324   \n",
       "42422  42423         NLD  43.0                673   \n",
       "44332  44333         NLD  43.0                630   \n",
       "28075  28076         USA  39.0                887   \n",
       "27179  27180         USA  39.0                900   \n",
       "\n",
       "                                                NameHash  \\\n",
       "61250  0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...   \n",
       "61171  0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...   \n",
       "44336  0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...   \n",
       "44434  0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...   \n",
       "63775  0x591E70AF9A305B5592F30EC4645878DE67AB1C6755B9...   \n",
       "...                                                  ...   \n",
       "2036   0x9A6D4033D479DB80B1EE58A38193FC1481E0943A249B...   \n",
       "42422  0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...   \n",
       "44332  0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...   \n",
       "28075  0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...   \n",
       "27179  0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...   \n",
       "\n",
       "                                               DocIDHash  AverageLeadTime  \\\n",
       "61250  0x00006E606D590F336C289D2CC995A0C726878BCAC001...                1   \n",
       "61171  0x00006E606D590F336C289D2CC995A0C726878BCAC001...              127   \n",
       "44336  0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...               80   \n",
       "44434  0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...                0   \n",
       "63775  0x001478086F84325B65735E7A4980BCD9CC8A2C609EE9...              305   \n",
       "...                                                  ...              ...   \n",
       "2036   0xFFC8E8CE49A4A882225B210B488EB8959153A1CDD538...              116   \n",
       "42422  0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...                1   \n",
       "44332  0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...               75   \n",
       "28075  0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...               34   \n",
       "27179  0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...               21   \n",
       "\n",
       "       LodgingRevenue  OtherRevenue  BookingsCanceled  ...  SRMediumFloor  \\\n",
       "61250           177.0         14.00                 0  ...              0   \n",
       "61171           318.0        148.00                 0  ...              0   \n",
       "44336           498.0        157.47                 0  ...              0   \n",
       "44434           249.0         38.00                 0  ...              0   \n",
       "63775           216.0        320.00                 0  ...              0   \n",
       "...               ...           ...               ...  ...            ...   \n",
       "2036            162.0         21.00                 0  ...              0   \n",
       "42422           118.0         14.00                 0  ...              0   \n",
       "44332           519.0        245.00                 0  ...              0   \n",
       "28075           180.0         54.20                 0  ...              0   \n",
       "27179           115.0         15.50                 0  ...              0   \n",
       "\n",
       "       SRBathtub  SRShower  SRCrib SRKingSizeBed SRTwinBed  SRNearElevator  \\\n",
       "61250          0         0       0             1         0               0   \n",
       "61171          0         0       0             1         0               0   \n",
       "44336          0         0       0             0         1               0   \n",
       "44434          0         0       0             0         1               0   \n",
       "63775          0         0       0             0         1               0   \n",
       "...          ...       ...     ...           ...       ...             ...   \n",
       "2036           0         0       0             0         0               0   \n",
       "42422          0         0       0             0         0               0   \n",
       "44332          0         0       0             0         0               0   \n",
       "28075          0         0       0             0         1               0   \n",
       "27179          0         0       0             1         1               0   \n",
       "\n",
       "       SRAwayFromElevator  SRNoAlcoholInMiniBar  SRQuietRoom  \n",
       "61250                   0                     0            1  \n",
       "61171                   0                     0            1  \n",
       "44336                   0                     0            0  \n",
       "44434                   0                     0            0  \n",
       "63775                   0                     0            1  \n",
       "...                   ...                   ...          ...  \n",
       "2036                    0                     0            0  \n",
       "42422                   0                     0            0  \n",
       "44332                   0                     0            0  \n",
       "28075                   0                     0            0  \n",
       "27179                   0                     0            0  \n",
       "\n",
       "[5442 rows x 29 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c.sort_values(by='DocIDHash')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Nationality</th>\n",
       "      <th>Age</th>\n",
       "      <th>NameHash</th>\n",
       "      <th>DocIDHash</th>\n",
       "      <th>BookingsCanceled</th>\n",
       "      <th>BookingsCheckedIn</th>\n",
       "      <th>BookingsNoShowed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>747</td>\n",
       "      <td>PRT</td>\n",
       "      <td>45.0</td>\n",
       "      <td>0xA9CDF5003C8585074B501911E57B58E505F6E6B1105D...</td>\n",
       "      <td>0x06614628F5F03C639AC1AD6A2C1BFAC7D25396129B72...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4854</td>\n",
       "      <td>PRT</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0xA9CDF5003C8585074B501911E57B58E505F6E6B1105D...</td>\n",
       "      <td>0x06614628F5F03C639AC1AD6A2C1BFAC7D25396129B72...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1916</td>\n",
       "      <td>DEU</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0xAE4050661026434CEE84C1CB88DD264BD390908013FC...</td>\n",
       "      <td>0x17ED10361077B7502854C0FCCC4A64D68825D61E599C...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1918</td>\n",
       "      <td>DEU</td>\n",
       "      <td>91.0</td>\n",
       "      <td>0xAE4050661026434CEE84C1CB88DD264BD390908013FC...</td>\n",
       "      <td>0x17ED10361077B7502854C0FCCC4A64D68825D61E599C...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1349</td>\n",
       "      <td>DEU</td>\n",
       "      <td>114.0</td>\n",
       "      <td>0x36BF5A087E8029783FC52501A957412690AA36E271CE...</td>\n",
       "      <td>0x1BF60C4718497A0AB8B46FF00708D3250A484DDA0FDC...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1763</td>\n",
       "      <td>CAN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0x023FF882E657C717F6C086EB2BF8C903E44E6F186435...</td>\n",
       "      <td>0x2256EF2188FA4B095ED0738DA590A1D3D5F6EAD6E6B1...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1762</td>\n",
       "      <td>CAN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0x023FF882E657C717F6C086EB2BF8C903E44E6F186435...</td>\n",
       "      <td>0x2256EF2188FA4B095ED0738DA590A1D3D5F6EAD6E6B1...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2722</td>\n",
       "      <td>PRT</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0x104C7AE177206893174F68B1C64E3AF565EC28F7FBC4...</td>\n",
       "      <td>0x2CC93458BF3F3693C32068563589C512D575FBA2037C...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3878</td>\n",
       "      <td>PRT</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0x747ECC15A6C17573AD883207113AAB4ED88D36EDF566...</td>\n",
       "      <td>0x482E2C9F26F48C0A884F2C941F7EC41A5FB00D015E7B...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3924</td>\n",
       "      <td>PRT</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0x747ECC15A6C17573AD883207113AAB4ED88D36EDF566...</td>\n",
       "      <td>0x482E2C9F26F48C0A884F2C941F7EC41A5FB00D015E7B...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>187</td>\n",
       "      <td>PRT</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0xF1F6E2FD8BD900B6FF3EB5628C204842D5735712953B...</td>\n",
       "      <td>0x501BC21EBDA95369BF94D114B6B7B3213C1BEFF301C6...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>PRT</td>\n",
       "      <td>42.0</td>\n",
       "      <td>0xF1F6E2FD8BD900B6FF3EB5628C204842D5735712953B...</td>\n",
       "      <td>0x501BC21EBDA95369BF94D114B6B7B3213C1BEFF301C6...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>962</td>\n",
       "      <td>PRT</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0xB66228CD437A348A7144934AE651F5BC397E6D950309...</td>\n",
       "      <td>0x76C69E88A3861386DA791B8C4880DE9BF962817CE1D1...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1380</td>\n",
       "      <td>PRT</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0xB66228CD437A348A7144934AE651F5BC397E6D950309...</td>\n",
       "      <td>0x76C69E88A3861386DA791B8C4880DE9BF962817CE1D1...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>47</td>\n",
       "      <td>PRT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xCB64B47C7143595CF003621616B7AAC462EED9838F42...</td>\n",
       "      <td>0x7FDA6549E599F8A011531AF6B300D5597BE02CCBD425...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>45</td>\n",
       "      <td>PRT</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0xCB64B47C7143595CF003621616B7AAC462EED9838F42...</td>\n",
       "      <td>0x7FDA6549E599F8A011531AF6B300D5597BE02CCBD425...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>172</td>\n",
       "      <td>PRT</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0xD0CC236A3272CBD64A46D3D958E15CE6F0B4C4E86A27...</td>\n",
       "      <td>0x8AB172723DECBB420902D992B6CAEB5692E50BDDF291...</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3825</td>\n",
       "      <td>PRT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0x436DE6FEF23007A1CAF896C266B314D99714CF834639...</td>\n",
       "      <td>0x8EA3F30C67906A43FA46D02C75537DAABFD8CBA5D7DE...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5393</td>\n",
       "      <td>PRT</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0x436DE6FEF23007A1CAF896C266B314D99714CF834639...</td>\n",
       "      <td>0x8EA3F30C67906A43FA46D02C75537DAABFD8CBA5D7DE...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53</td>\n",
       "      <td>PRT</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0xC86B4CD596BE0A3770A7FAA95786E79796FDEB7BCCBB...</td>\n",
       "      <td>0x918C42080E2E417137B6274BD863F427658DA27FE11E...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2440</td>\n",
       "      <td>PRT</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0xC86B4CD596BE0A3770A7FAA95786E79796FDEB7BCCBB...</td>\n",
       "      <td>0x918C42080E2E417137B6274BD863F427658DA27FE11E...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>74</td>\n",
       "      <td>NLD</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0xE1CA54C8F2E99F77D631ECC41C13ED31E0700A0D57A5...</td>\n",
       "      <td>0x93FE4148F7C0E16E2431F50FDE5974F12E9522BABF27...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1451</td>\n",
       "      <td>PRT</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0x02F841927DB8CE008D30BF6A3360AB615D1188900F98...</td>\n",
       "      <td>0xA1D130C1CB32FBB33D74E8B715F7AA5D18D6C0821043...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2852</td>\n",
       "      <td>PRT</td>\n",
       "      <td>84.0</td>\n",
       "      <td>0x02F841927DB8CE008D30BF6A3360AB615D1188900F98...</td>\n",
       "      <td>0xA1D130C1CB32FBB33D74E8B715F7AA5D18D6C0821043...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2457</td>\n",
       "      <td>PRT</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0xFD382E05D35F45D6DCCD125D67A1DCB8324A47E5B592...</td>\n",
       "      <td>0xA48228BEB6FDA0E41844789716EC6C3F5B5328B9FA6E...</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1154</td>\n",
       "      <td>ITA</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0x264D8DC78C198A35ED647032AC1EBEBC70D4BB9F64F2...</td>\n",
       "      <td>0xA57E144C03F1CA85BCC73BD65F40F09F411C83E9BDAB...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1309</td>\n",
       "      <td>ITA</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0x264D8DC78C198A35ED647032AC1EBEBC70D4BB9F64F2...</td>\n",
       "      <td>0xA57E144C03F1CA85BCC73BD65F40F09F411C83E9BDAB...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44</td>\n",
       "      <td>PRT</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0xCB64B47C7143595CF003621616B7AAC462EED9838F42...</td>\n",
       "      <td>0xA6CA677528649922BBBF6A3B54F8354B6B9EC86071AC...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>46</td>\n",
       "      <td>PRT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0xCB64B47C7143595CF003621616B7AAC462EED9838F42...</td>\n",
       "      <td>0xA6CA677528649922BBBF6A3B54F8354B6B9EC86071AC...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3812</td>\n",
       "      <td>NLD</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0x9839BD0113CE1DF86BD5AE3CE1E51137F2A2F4E894FE...</td>\n",
       "      <td>0xA6FD1A8C89943888CBB59E7C9222D309AA28F086CF29...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3614</td>\n",
       "      <td>PRT</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0xDDD77009B74FB1B5534EC8EE734278918BF6238537E5...</td>\n",
       "      <td>0xAA5427E2522A1692C148AA152EA41B65E4472BE1BF94...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2023</td>\n",
       "      <td>PRT</td>\n",
       "      <td>44.0</td>\n",
       "      <td>0xDDD77009B74FB1B5534EC8EE734278918BF6238537E5...</td>\n",
       "      <td>0xAA5427E2522A1692C148AA152EA41B65E4472BE1BF94...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5051</td>\n",
       "      <td>SWE</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0x7E4939576537094DB85A6FB382BC50FB07C4A8145D47...</td>\n",
       "      <td>0xAE8A77CF2348EA4D37B125A28C301C322343AD71B150...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4199</td>\n",
       "      <td>SWE</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0x7E4939576537094DB85A6FB382BC50FB07C4A8145D47...</td>\n",
       "      <td>0xAE8A77CF2348EA4D37B125A28C301C322343AD71B150...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4833</td>\n",
       "      <td>PRT</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0x3FC67BFC73F36397ADD88D110C0197E9EA75BEA301AC...</td>\n",
       "      <td>0xB062A50ABADD02498519305DD170F0893EEB2847C35F...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1545</td>\n",
       "      <td>PRT</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0x3FC67BFC73F36397ADD88D110C0197E9EA75BEA301AC...</td>\n",
       "      <td>0xB062A50ABADD02498519305DD170F0893EEB2847C35F...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1797</td>\n",
       "      <td>DEU</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0x7668B813CD3091F800948A9E58536688CBB73517CDA5...</td>\n",
       "      <td>0xB932947C78BB735241312C568CFEE6D25F39A5545A64...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1795</td>\n",
       "      <td>DEU</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0x7668B813CD3091F800948A9E58536688CBB73517CDA5...</td>\n",
       "      <td>0xB932947C78BB735241312C568CFEE6D25F39A5545A64...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2776</td>\n",
       "      <td>BEL</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0x53D9B56425DF5C91A7A9D934958424362A07EA0FF2B0...</td>\n",
       "      <td>0xBD00CA9B8ABF50A4AAE19C34AEC15E3A23881093EBA0...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2804</td>\n",
       "      <td>BEL</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0x53D9B56425DF5C91A7A9D934958424362A07EA0FF2B0...</td>\n",
       "      <td>0xBD00CA9B8ABF50A4AAE19C34AEC15E3A23881093EBA0...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>98</td>\n",
       "      <td>FRA</td>\n",
       "      <td>56.0</td>\n",
       "      <td>0x8C764F5DFAEB3D2674DEA46F67668A732B7E6987185D...</td>\n",
       "      <td>0xC0E3BA5D7C426629C6FAA850A587444F203E68B4A475...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>85</td>\n",
       "      <td>FRA</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0x8C764F5DFAEB3D2674DEA46F67668A732B7E6987185D...</td>\n",
       "      <td>0xC0E3BA5D7C426629C6FAA850A587444F203E68B4A475...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>234</td>\n",
       "      <td>ESP</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0xC8A958314414FE006BC0E4155FF6BE009412D3C85196...</td>\n",
       "      <td>0xC71E814A5AEF5747F586AED5BC42DE36D3BFBDC20AD8...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>241</td>\n",
       "      <td>ESP</td>\n",
       "      <td>46.0</td>\n",
       "      <td>0xC8A958314414FE006BC0E4155FF6BE009412D3C85196...</td>\n",
       "      <td>0xC71E814A5AEF5747F586AED5BC42DE36D3BFBDC20AD8...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>175</td>\n",
       "      <td>PRT</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0xE77495BF5BE2A2B92A906EBB319A6427C58713759321...</td>\n",
       "      <td>0xC94C18A8B5218190219290FC45E670B1CF33C354FBF1...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>196</td>\n",
       "      <td>PRT</td>\n",
       "      <td>62.0</td>\n",
       "      <td>0xE77495BF5BE2A2B92A906EBB319A6427C58713759321...</td>\n",
       "      <td>0xC94C18A8B5218190219290FC45E670B1CF33C354FBF1...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4529</td>\n",
       "      <td>PRT</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0x5521E5D7A00EC0B688EBD3AF7BAFB30DF10772521BC1...</td>\n",
       "      <td>0xCE65F42508BCE58619AFADD44648EC244314AADECF98...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2610</td>\n",
       "      <td>USA</td>\n",
       "      <td>69.0</td>\n",
       "      <td>0xB7388E5E11B4EC5EFB78687EDEB4D5E3FFAF544B0175...</td>\n",
       "      <td>0xD698B076C52D5B39838CB6B94B29B04B4B02A3548A3E...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2697</td>\n",
       "      <td>USA</td>\n",
       "      <td>58.0</td>\n",
       "      <td>0xB7388E5E11B4EC5EFB78687EDEB4D5E3FFAF544B0175...</td>\n",
       "      <td>0xD698B076C52D5B39838CB6B94B29B04B4B02A3548A3E...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>222</td>\n",
       "      <td>GNB</td>\n",
       "      <td>48.0</td>\n",
       "      <td>0xCC54FE2D5801503D504EBB93E898B94FB4B72A654FC8...</td>\n",
       "      <td>0xDA9B51A07ADBC5709C46041E9BF73552C8F8C8B56F32...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>94</td>\n",
       "      <td>FRA</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0x4FF6DC51519BE7EAB2808D3F2699F90C92F7CD29FF74...</td>\n",
       "      <td>0xE25EC8D82356CE3C907ECAC901BD93988231EEB01BC8...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>95</td>\n",
       "      <td>FRA</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0x4FF6DC51519BE7EAB2808D3F2699F90C92F7CD29FF74...</td>\n",
       "      <td>0xE25EC8D82356CE3C907ECAC901BD93988231EEB01BC8...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3452</td>\n",
       "      <td>GBR</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0x3D50B023B36F947689A4771D449CF58EDED4E634F135...</td>\n",
       "      <td>0xE484F7FAF916CD4FEA6835F908F36D9DB1D5DE7FC501...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3497</td>\n",
       "      <td>GBR</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0x3D50B023B36F947689A4771D449CF58EDED4E634F135...</td>\n",
       "      <td>0xE484F7FAF916CD4FEA6835F908F36D9DB1D5DE7FC501...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>674</td>\n",
       "      <td>ESP</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0xEE094555EFED691DC14AF996DB7530E6E9638C6B6B21...</td>\n",
       "      <td>0xFCD55A075ACAE4A309DDAECA8D3BD274FD380D6EBE6E...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1703</td>\n",
       "      <td>ESP</td>\n",
       "      <td>53.0</td>\n",
       "      <td>0xEE094555EFED691DC14AF996DB7530E6E9638C6B6B21...</td>\n",
       "      <td>0xFCD55A075ACAE4A309DDAECA8D3BD274FD380D6EBE6E...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Nationality    Age                                           NameHash  \\\n",
       "747          PRT   45.0  0xA9CDF5003C8585074B501911E57B58E505F6E6B1105D...   \n",
       "4854         PRT   65.0  0xA9CDF5003C8585074B501911E57B58E505F6E6B1105D...   \n",
       "1916         DEU   30.0  0xAE4050661026434CEE84C1CB88DD264BD390908013FC...   \n",
       "1918         DEU   91.0  0xAE4050661026434CEE84C1CB88DD264BD390908013FC...   \n",
       "1349         DEU  114.0  0x36BF5A087E8029783FC52501A957412690AA36E271CE...   \n",
       "1763         CAN   21.0  0x023FF882E657C717F6C086EB2BF8C903E44E6F186435...   \n",
       "1762         CAN   31.0  0x023FF882E657C717F6C086EB2BF8C903E44E6F186435...   \n",
       "2722         PRT   34.0  0x104C7AE177206893174F68B1C64E3AF565EC28F7FBC4...   \n",
       "3878         PRT   52.0  0x747ECC15A6C17573AD883207113AAB4ED88D36EDF566...   \n",
       "3924         PRT   12.0  0x747ECC15A6C17573AD883207113AAB4ED88D36EDF566...   \n",
       "187          PRT   40.0  0xF1F6E2FD8BD900B6FF3EB5628C204842D5735712953B...   \n",
       "12           PRT   42.0  0xF1F6E2FD8BD900B6FF3EB5628C204842D5735712953B...   \n",
       "962          PRT   41.0  0xB66228CD437A348A7144934AE651F5BC397E6D950309...   \n",
       "1380         PRT   43.0  0xB66228CD437A348A7144934AE651F5BC397E6D950309...   \n",
       "47           PRT    NaN  0xCB64B47C7143595CF003621616B7AAC462EED9838F42...   \n",
       "45           PRT   41.0  0xCB64B47C7143595CF003621616B7AAC462EED9838F42...   \n",
       "172          PRT   54.0  0xD0CC236A3272CBD64A46D3D958E15CE6F0B4C4E86A27...   \n",
       "3825         PRT    NaN  0x436DE6FEF23007A1CAF896C266B314D99714CF834639...   \n",
       "5393         PRT   39.0  0x436DE6FEF23007A1CAF896C266B314D99714CF834639...   \n",
       "53           PRT   31.0  0xC86B4CD596BE0A3770A7FAA95786E79796FDEB7BCCBB...   \n",
       "2440         PRT   39.0  0xC86B4CD596BE0A3770A7FAA95786E79796FDEB7BCCBB...   \n",
       "74           NLD   44.0  0xE1CA54C8F2E99F77D631ECC41C13ED31E0700A0D57A5...   \n",
       "1451         PRT   34.0  0x02F841927DB8CE008D30BF6A3360AB615D1188900F98...   \n",
       "2852         PRT   84.0  0x02F841927DB8CE008D30BF6A3360AB615D1188900F98...   \n",
       "2457         PRT   63.0  0xFD382E05D35F45D6DCCD125D67A1DCB8324A47E5B592...   \n",
       "1154         ITA   52.0  0x264D8DC78C198A35ED647032AC1EBEBC70D4BB9F64F2...   \n",
       "1309         ITA   43.0  0x264D8DC78C198A35ED647032AC1EBEBC70D4BB9F64F2...   \n",
       "44           PRT   43.0  0xCB64B47C7143595CF003621616B7AAC462EED9838F42...   \n",
       "46           PRT    NaN  0xCB64B47C7143595CF003621616B7AAC462EED9838F42...   \n",
       "3812         NLD   32.0  0x9839BD0113CE1DF86BD5AE3CE1E51137F2A2F4E894FE...   \n",
       "3614         PRT   41.0  0xDDD77009B74FB1B5534EC8EE734278918BF6238537E5...   \n",
       "2023         PRT   44.0  0xDDD77009B74FB1B5534EC8EE734278918BF6238537E5...   \n",
       "5051         SWE   37.0  0x7E4939576537094DB85A6FB382BC50FB07C4A8145D47...   \n",
       "4199         SWE   39.0  0x7E4939576537094DB85A6FB382BC50FB07C4A8145D47...   \n",
       "4833         PRT   31.0  0x3FC67BFC73F36397ADD88D110C0197E9EA75BEA301AC...   \n",
       "1545         PRT   51.0  0x3FC67BFC73F36397ADD88D110C0197E9EA75BEA301AC...   \n",
       "1797         DEU   40.0  0x7668B813CD3091F800948A9E58536688CBB73517CDA5...   \n",
       "1795         DEU   10.0  0x7668B813CD3091F800948A9E58536688CBB73517CDA5...   \n",
       "2776         BEL   11.0  0x53D9B56425DF5C91A7A9D934958424362A07EA0FF2B0...   \n",
       "2804         BEL   71.0  0x53D9B56425DF5C91A7A9D934958424362A07EA0FF2B0...   \n",
       "98           FRA   56.0  0x8C764F5DFAEB3D2674DEA46F67668A732B7E6987185D...   \n",
       "85           FRA   51.0  0x8C764F5DFAEB3D2674DEA46F67668A732B7E6987185D...   \n",
       "234          ESP   50.0  0xC8A958314414FE006BC0E4155FF6BE009412D3C85196...   \n",
       "241          ESP   46.0  0xC8A958314414FE006BC0E4155FF6BE009412D3C85196...   \n",
       "175          PRT   33.0  0xE77495BF5BE2A2B92A906EBB319A6427C58713759321...   \n",
       "196          PRT   62.0  0xE77495BF5BE2A2B92A906EBB319A6427C58713759321...   \n",
       "4529         PRT   22.0  0x5521E5D7A00EC0B688EBD3AF7BAFB30DF10772521BC1...   \n",
       "2610         USA   69.0  0xB7388E5E11B4EC5EFB78687EDEB4D5E3FFAF544B0175...   \n",
       "2697         USA   58.0  0xB7388E5E11B4EC5EFB78687EDEB4D5E3FFAF544B0175...   \n",
       "222          GNB   48.0  0xCC54FE2D5801503D504EBB93E898B94FB4B72A654FC8...   \n",
       "94           FRA   32.0  0x4FF6DC51519BE7EAB2808D3F2699F90C92F7CD29FF74...   \n",
       "95           FRA   37.0  0x4FF6DC51519BE7EAB2808D3F2699F90C92F7CD29FF74...   \n",
       "3452         GBR   51.0  0x3D50B023B36F947689A4771D449CF58EDED4E634F135...   \n",
       "3497         GBR   11.0  0x3D50B023B36F947689A4771D449CF58EDED4E634F135...   \n",
       "674          ESP   33.0  0xEE094555EFED691DC14AF996DB7530E6E9638C6B6B21...   \n",
       "1703         ESP   53.0  0xEE094555EFED691DC14AF996DB7530E6E9638C6B6B21...   \n",
       "\n",
       "                                              DocIDHash  BookingsCanceled  \\\n",
       "747   0x06614628F5F03C639AC1AD6A2C1BFAC7D25396129B72...                 1   \n",
       "4854  0x06614628F5F03C639AC1AD6A2C1BFAC7D25396129B72...                 1   \n",
       "1916  0x17ED10361077B7502854C0FCCC4A64D68825D61E599C...                 0   \n",
       "1918  0x17ED10361077B7502854C0FCCC4A64D68825D61E599C...                 0   \n",
       "1349  0x1BF60C4718497A0AB8B46FF00708D3250A484DDA0FDC...                 0   \n",
       "1763  0x2256EF2188FA4B095ED0738DA590A1D3D5F6EAD6E6B1...                 0   \n",
       "1762  0x2256EF2188FA4B095ED0738DA590A1D3D5F6EAD6E6B1...                 0   \n",
       "2722  0x2CC93458BF3F3693C32068563589C512D575FBA2037C...                 0   \n",
       "3878  0x482E2C9F26F48C0A884F2C941F7EC41A5FB00D015E7B...                 0   \n",
       "3924  0x482E2C9F26F48C0A884F2C941F7EC41A5FB00D015E7B...                 0   \n",
       "187   0x501BC21EBDA95369BF94D114B6B7B3213C1BEFF301C6...                 0   \n",
       "12    0x501BC21EBDA95369BF94D114B6B7B3213C1BEFF301C6...                 0   \n",
       "962   0x76C69E88A3861386DA791B8C4880DE9BF962817CE1D1...                 0   \n",
       "1380  0x76C69E88A3861386DA791B8C4880DE9BF962817CE1D1...                 0   \n",
       "47    0x7FDA6549E599F8A011531AF6B300D5597BE02CCBD425...                 0   \n",
       "45    0x7FDA6549E599F8A011531AF6B300D5597BE02CCBD425...                 0   \n",
       "172   0x8AB172723DECBB420902D992B6CAEB5692E50BDDF291...                 0   \n",
       "3825  0x8EA3F30C67906A43FA46D02C75537DAABFD8CBA5D7DE...                 0   \n",
       "5393  0x8EA3F30C67906A43FA46D02C75537DAABFD8CBA5D7DE...                 0   \n",
       "53    0x918C42080E2E417137B6274BD863F427658DA27FE11E...                 0   \n",
       "2440  0x918C42080E2E417137B6274BD863F427658DA27FE11E...                 0   \n",
       "74    0x93FE4148F7C0E16E2431F50FDE5974F12E9522BABF27...                 0   \n",
       "1451  0xA1D130C1CB32FBB33D74E8B715F7AA5D18D6C0821043...                 0   \n",
       "2852  0xA1D130C1CB32FBB33D74E8B715F7AA5D18D6C0821043...                 0   \n",
       "2457  0xA48228BEB6FDA0E41844789716EC6C3F5B5328B9FA6E...                 0   \n",
       "1154  0xA57E144C03F1CA85BCC73BD65F40F09F411C83E9BDAB...                 0   \n",
       "1309  0xA57E144C03F1CA85BCC73BD65F40F09F411C83E9BDAB...                 0   \n",
       "44    0xA6CA677528649922BBBF6A3B54F8354B6B9EC86071AC...                 0   \n",
       "46    0xA6CA677528649922BBBF6A3B54F8354B6B9EC86071AC...                 0   \n",
       "3812  0xA6FD1A8C89943888CBB59E7C9222D309AA28F086CF29...                 1   \n",
       "3614  0xAA5427E2522A1692C148AA152EA41B65E4472BE1BF94...                 0   \n",
       "2023  0xAA5427E2522A1692C148AA152EA41B65E4472BE1BF94...                 0   \n",
       "5051  0xAE8A77CF2348EA4D37B125A28C301C322343AD71B150...                 0   \n",
       "4199  0xAE8A77CF2348EA4D37B125A28C301C322343AD71B150...                 0   \n",
       "4833  0xB062A50ABADD02498519305DD170F0893EEB2847C35F...                 0   \n",
       "1545  0xB062A50ABADD02498519305DD170F0893EEB2847C35F...                 0   \n",
       "1797  0xB932947C78BB735241312C568CFEE6D25F39A5545A64...                 0   \n",
       "1795  0xB932947C78BB735241312C568CFEE6D25F39A5545A64...                 0   \n",
       "2776  0xBD00CA9B8ABF50A4AAE19C34AEC15E3A23881093EBA0...                 0   \n",
       "2804  0xBD00CA9B8ABF50A4AAE19C34AEC15E3A23881093EBA0...                 0   \n",
       "98    0xC0E3BA5D7C426629C6FAA850A587444F203E68B4A475...                 0   \n",
       "85    0xC0E3BA5D7C426629C6FAA850A587444F203E68B4A475...                 0   \n",
       "234   0xC71E814A5AEF5747F586AED5BC42DE36D3BFBDC20AD8...                 0   \n",
       "241   0xC71E814A5AEF5747F586AED5BC42DE36D3BFBDC20AD8...                 0   \n",
       "175   0xC94C18A8B5218190219290FC45E670B1CF33C354FBF1...                 0   \n",
       "196   0xC94C18A8B5218190219290FC45E670B1CF33C354FBF1...                 0   \n",
       "4529  0xCE65F42508BCE58619AFADD44648EC244314AADECF98...                 0   \n",
       "2610  0xD698B076C52D5B39838CB6B94B29B04B4B02A3548A3E...                 0   \n",
       "2697  0xD698B076C52D5B39838CB6B94B29B04B4B02A3548A3E...                 0   \n",
       "222   0xDA9B51A07ADBC5709C46041E9BF73552C8F8C8B56F32...                 0   \n",
       "94    0xE25EC8D82356CE3C907ECAC901BD93988231EEB01BC8...                 0   \n",
       "95    0xE25EC8D82356CE3C907ECAC901BD93988231EEB01BC8...                 0   \n",
       "3452  0xE484F7FAF916CD4FEA6835F908F36D9DB1D5DE7FC501...                 0   \n",
       "3497  0xE484F7FAF916CD4FEA6835F908F36D9DB1D5DE7FC501...                 0   \n",
       "674   0xFCD55A075ACAE4A309DDAECA8D3BD274FD380D6EBE6E...                 0   \n",
       "1703  0xFCD55A075ACAE4A309DDAECA8D3BD274FD380D6EBE6E...                 0   \n",
       "\n",
       "      BookingsCheckedIn  BookingsNoShowed  \n",
       "747                  10                 0  \n",
       "4854                  1                 0  \n",
       "1916                  1                 0  \n",
       "1918                  1                 0  \n",
       "1349                  1                 0  \n",
       "1763                  1                 0  \n",
       "1762                  1                 0  \n",
       "2722                  1                 0  \n",
       "3878                  0                 0  \n",
       "3924                  0                 0  \n",
       "187                   1                 0  \n",
       "12                    1                 0  \n",
       "962                   2                 0  \n",
       "1380                  1                 0  \n",
       "47                    1                 0  \n",
       "45                    1                 0  \n",
       "172                   5                 0  \n",
       "3825                  0                 0  \n",
       "5393                  0                 0  \n",
       "53                    1                 0  \n",
       "2440                  1                 0  \n",
       "74                    1                 0  \n",
       "1451                  1                 0  \n",
       "2852                  0                 0  \n",
       "2457                  4                 0  \n",
       "1154                  2                 0  \n",
       "1309                  2                 0  \n",
       "44                    1                 0  \n",
       "46                    1                 0  \n",
       "3812                  3                 1  \n",
       "3614                  1                 0  \n",
       "2023                  1                 0  \n",
       "5051                  1                 0  \n",
       "4199                  1                 0  \n",
       "4833                  1                 0  \n",
       "1545                  1                 0  \n",
       "1797                  1                 0  \n",
       "1795                  1                 0  \n",
       "2776                  1                 0  \n",
       "2804                  1                 0  \n",
       "98                    1                 0  \n",
       "85                    0                 0  \n",
       "234                   1                 0  \n",
       "241                   1                 0  \n",
       "175                   1                 0  \n",
       "196                   1                 0  \n",
       "4529                  0                 0  \n",
       "2610                  1                 0  \n",
       "2697                  1                 0  \n",
       "222                   1                 0  \n",
       "94                    1                 0  \n",
       "95                    0                 0  \n",
       "3452                  1                 0  \n",
       "3497                  1                 0  \n",
       "674                   1                 0  \n",
       "1703                  1                 0  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "T = b.merge(c, how = 'outer' ,indicator=True).loc[lambda x : x['_merge']=='left_only']\n",
    "\n",
    "T.sort_values(by='DocIDHash').loc[:,['Nationality','Age','NameHash','DocIDHash','BookingsCanceled','BookingsCheckedIn','BookingsNoShowed']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>ID</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Age</th>\n",
       "      <th>DaysSinceCreation</th>\n",
       "      <th>NameHash</th>\n",
       "      <th>DocIDHash</th>\n",
       "      <th>AverageLeadTime</th>\n",
       "      <th>LodgingRevenue</th>\n",
       "      <th>OtherRevenue</th>\n",
       "      <th>BookingsCanceled</th>\n",
       "      <th>...</th>\n",
       "      <th>SRMediumFloor</th>\n",
       "      <th>SRBathtub</th>\n",
       "      <th>SRShower</th>\n",
       "      <th>SRCrib</th>\n",
       "      <th>SRKingSizeBed</th>\n",
       "      <th>SRTwinBed</th>\n",
       "      <th>SRNearElevator</th>\n",
       "      <th>SRAwayFromElevator</th>\n",
       "      <th>SRNoAlcoholInMiniBar</th>\n",
       "      <th>SRQuietRoom</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>61250</td>\n",
       "      <td>61251</td>\n",
       "      <td>FRA</td>\n",
       "      <td>60.0</td>\n",
       "      <td>479</td>\n",
       "      <td>0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...</td>\n",
       "      <td>0x00006E606D590F336C289D2CC995A0C726878BCAC001...</td>\n",
       "      <td>1</td>\n",
       "      <td>177.0</td>\n",
       "      <td>14.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61171</td>\n",
       "      <td>61172</td>\n",
       "      <td>FRA</td>\n",
       "      <td>60.0</td>\n",
       "      <td>480</td>\n",
       "      <td>0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...</td>\n",
       "      <td>0x00006E606D590F336C289D2CC995A0C726878BCAC001...</td>\n",
       "      <td>127</td>\n",
       "      <td>318.0</td>\n",
       "      <td>148.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44434</td>\n",
       "      <td>44435</td>\n",
       "      <td>IND</td>\n",
       "      <td>38.0</td>\n",
       "      <td>629</td>\n",
       "      <td>0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...</td>\n",
       "      <td>0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...</td>\n",
       "      <td>0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>38.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44336</td>\n",
       "      <td>44337</td>\n",
       "      <td>IND</td>\n",
       "      <td>38.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...</td>\n",
       "      <td>0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...</td>\n",
       "      <td>80</td>\n",
       "      <td>498.0</td>\n",
       "      <td>157.47</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63775</td>\n",
       "      <td>63776</td>\n",
       "      <td>GBR</td>\n",
       "      <td>49.0</td>\n",
       "      <td>460</td>\n",
       "      <td>0x591E70AF9A305B5592F30EC4645878DE67AB1C6755B9...</td>\n",
       "      <td>0x001478086F84325B65735E7A4980BCD9CC8A2C609EE9...</td>\n",
       "      <td>305</td>\n",
       "      <td>216.0</td>\n",
       "      <td>320.00</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2036</td>\n",
       "      <td>2037</td>\n",
       "      <td>ESP</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1324</td>\n",
       "      <td>0x9A6D4033D479DB80B1EE58A38193FC1481E0943A249B...</td>\n",
       "      <td>0xFFC8E8CE49A4A882225B210B488EB8959153A1CDD538...</td>\n",
       "      <td>116</td>\n",
       "      <td>162.0</td>\n",
       "      <td>21.00</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",
       "      <td>44332</td>\n",
       "      <td>44333</td>\n",
       "      <td>NLD</td>\n",
       "      <td>43.0</td>\n",
       "      <td>630</td>\n",
       "      <td>0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...</td>\n",
       "      <td>0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...</td>\n",
       "      <td>75</td>\n",
       "      <td>519.0</td>\n",
       "      <td>245.00</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",
       "      <td>42422</td>\n",
       "      <td>42423</td>\n",
       "      <td>NLD</td>\n",
       "      <td>43.0</td>\n",
       "      <td>673</td>\n",
       "      <td>0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...</td>\n",
       "      <td>0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...</td>\n",
       "      <td>1</td>\n",
       "      <td>118.0</td>\n",
       "      <td>14.00</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",
       "      <td>28075</td>\n",
       "      <td>28076</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.0</td>\n",
       "      <td>887</td>\n",
       "      <td>0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...</td>\n",
       "      <td>0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...</td>\n",
       "      <td>34</td>\n",
       "      <td>180.0</td>\n",
       "      <td>54.20</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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27179</td>\n",
       "      <td>27180</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.0</td>\n",
       "      <td>900</td>\n",
       "      <td>0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...</td>\n",
       "      <td>0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...</td>\n",
       "      <td>21</td>\n",
       "      <td>115.0</td>\n",
       "      <td>15.50</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>1</td>\n",
       "      <td>1</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>5609 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID Nationality   Age  DaysSinceCreation  \\\n",
       "61250  61251         FRA  60.0                479   \n",
       "61171  61172         FRA  60.0                480   \n",
       "44434  44435         IND  38.0                629   \n",
       "44336  44337         IND  38.0                630   \n",
       "63775  63776         GBR  49.0                460   \n",
       "...      ...         ...   ...                ...   \n",
       "2036    2037         ESP  46.0               1324   \n",
       "44332  44333         NLD  43.0                630   \n",
       "42422  42423         NLD  43.0                673   \n",
       "28075  28076         USA  39.0                887   \n",
       "27179  27180         USA  39.0                900   \n",
       "\n",
       "                                                NameHash  \\\n",
       "61250  0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...   \n",
       "61171  0x0D54EA6B14A0574CAA2D3802565441048C5C831EB035...   \n",
       "44434  0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...   \n",
       "44336  0x9C078C3BE9FDC59F25E736E57DAFBCCDE64197FC560D...   \n",
       "63775  0x591E70AF9A305B5592F30EC4645878DE67AB1C6755B9...   \n",
       "...                                                  ...   \n",
       "2036   0x9A6D4033D479DB80B1EE58A38193FC1481E0943A249B...   \n",
       "44332  0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...   \n",
       "42422  0xC031D142FB99F0722FE4DFD4298AA57CC67C89C68E62...   \n",
       "28075  0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...   \n",
       "27179  0x57FA8ECFDD8904600648B133E19EBA7C82549714E294...   \n",
       "\n",
       "                                               DocIDHash  AverageLeadTime  \\\n",
       "61250  0x00006E606D590F336C289D2CC995A0C726878BCAC001...                1   \n",
       "61171  0x00006E606D590F336C289D2CC995A0C726878BCAC001...              127   \n",
       "44434  0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...                0   \n",
       "44336  0x000443891856CB5D74287EDBFBE82A4F6D2841F2D1DB...               80   \n",
       "63775  0x001478086F84325B65735E7A4980BCD9CC8A2C609EE9...              305   \n",
       "...                                                  ...              ...   \n",
       "2036   0xFFC8E8CE49A4A882225B210B488EB8959153A1CDD538...              116   \n",
       "44332  0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...               75   \n",
       "42422  0xFFD0ED500662142AB2E236798F4E5772353C5CA89DF3...                1   \n",
       "28075  0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...               34   \n",
       "27179  0xFFF7DCF7FE679FB88D0A3D8AB4204A933D00C4A35660...               21   \n",
       "\n",
       "       LodgingRevenue  OtherRevenue  BookingsCanceled  ...  SRMediumFloor  \\\n",
       "61250           177.0         14.00                 0  ...              0   \n",
       "61171           318.0        148.00                 0  ...              0   \n",
       "44434           249.0         38.00                 0  ...              0   \n",
       "44336           498.0        157.47                 0  ...              0   \n",
       "63775           216.0        320.00                 0  ...              0   \n",
       "...               ...           ...               ...  ...            ...   \n",
       "2036            162.0         21.00                 0  ...              0   \n",
       "44332           519.0        245.00                 0  ...              0   \n",
       "42422           118.0         14.00                 0  ...              0   \n",
       "28075           180.0         54.20                 0  ...              0   \n",
       "27179           115.0         15.50                 0  ...              0   \n",
       "\n",
       "       SRBathtub  SRShower  SRCrib SRKingSizeBed SRTwinBed  SRNearElevator  \\\n",
       "61250          0         0       0             1         0               0   \n",
       "61171          0         0       0             1         0               0   \n",
       "44434          0         0       0             0         1               0   \n",
       "44336          0         0       0             0         1               0   \n",
       "63775          0         0       0             0         1               0   \n",
       "...          ...       ...     ...           ...       ...             ...   \n",
       "2036           0         0       0             0         0               0   \n",
       "44332          0         0       0             0         0               0   \n",
       "42422          0         0       0             0         0               0   \n",
       "28075          0         0       0             0         1               0   \n",
       "27179          0         0       0             1         1               0   \n",
       "\n",
       "       SRAwayFromElevator  SRNoAlcoholInMiniBar  SRQuietRoom  \n",
       "61250                   0                     0            1  \n",
       "61171                   0                     0            1  \n",
       "44434                   0                     0            0  \n",
       "44336                   0                     0            0  \n",
       "63775                   0                     0            1  \n",
       "...                   ...                   ...          ...  \n",
       "2036                    0                     0            0  \n",
       "44332                   0                     0            0  \n",
       "42422                   0                     0            0  \n",
       "28075                   0                     0            0  \n",
       "27179                   0                     0            0  \n",
       "\n",
       "[5609 rows x 29 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a.sort_values(by='DocIDHash')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Age</th>\n",
       "      <th>DaysSinceCreation</th>\n",
       "      <th>NameHash</th>\n",
       "      <th>DocIDHash</th>\n",
       "      <th>AverageLeadTime</th>\n",
       "      <th>LodgingRevenue</th>\n",
       "      <th>OtherRevenue</th>\n",
       "      <th>BookingsCanceled</th>\n",
       "      <th>...</th>\n",
       "      <th>SRMediumFloor</th>\n",
       "      <th>SRBathtub</th>\n",
       "      <th>SRShower</th>\n",
       "      <th>SRCrib</th>\n",
       "      <th>SRKingSizeBed</th>\n",
       "      <th>SRTwinBed</th>\n",
       "      <th>SRNearElevator</th>\n",
       "      <th>SRAwayFromElevator</th>\n",
       "      <th>SRNoAlcoholInMiniBar</th>\n",
       "      <th>SRQuietRoom</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>744</td>\n",
       "      <td>745</td>\n",
       "      <td>PRT</td>\n",
       "      <td>40.0</td>\n",
       "      <td>1359</td>\n",
       "      <td>0xDE75217D31BF3A07C97BC70DF817FCBA6CC5AA29C153...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>103</td>\n",
       "      <td>388.0</td>\n",
       "      <td>120.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",
       "      <td>842</td>\n",
       "      <td>843</td>\n",
       "      <td>PRT</td>\n",
       "      <td>48.0</td>\n",
       "      <td>1355</td>\n",
       "      <td>0x927BA21A63552D1FC65670C559845E2B3C19BCC55B18...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>17</td>\n",
       "      <td>177.0</td>\n",
       "      <td>77.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",
       "      <td>907</td>\n",
       "      <td>908</td>\n",
       "      <td>PRT</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1352</td>\n",
       "      <td>0x3CA9DDAB19D8F50A425B14FAB6BA283701AB9B5A651C...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>3</td>\n",
       "      <td>73.0</td>\n",
       "      <td>7.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",
       "      <td>1002</td>\n",
       "      <td>1003</td>\n",
       "      <td>PRT</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1348</td>\n",
       "      <td>0x13B95955F49C8E660F3B7639FDAB4BB75A495493A5A2...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>22</td>\n",
       "      <td>172.8</td>\n",
       "      <td>42.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>1</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",
       "      <td>1003</td>\n",
       "      <td>1004</td>\n",
       "      <td>PRT</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1348</td>\n",
       "      <td>0x155357372FF051877CBE53E7A357935957CB3F22F8D7...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>1</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>103345</td>\n",
       "      <td>103346</td>\n",
       "      <td>PRT</td>\n",
       "      <td>23.0</td>\n",
       "      <td>103</td>\n",
       "      <td>0x3B383C03E88F6AFE5508D1E75BBDCB6FE13548B1BDA9...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>1</td>\n",
       "      <td>116.0</td>\n",
       "      <td>16.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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>106428</td>\n",
       "      <td>106429</td>\n",
       "      <td>PRT</td>\n",
       "      <td>10.0</td>\n",
       "      <td>78</td>\n",
       "      <td>0x8C93F42F7CE50F07E1B226CDD2111A5413903FA1EC73...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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",
       "      <td>107858</td>\n",
       "      <td>107859</td>\n",
       "      <td>PRT</td>\n",
       "      <td>6.0</td>\n",
       "      <td>67</td>\n",
       "      <td>0x151FA6F1DCAD61BDCEF01D315AE43293597CE08B0F10...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>108450</td>\n",
       "      <td>108451</td>\n",
       "      <td>PRT</td>\n",
       "      <td>56.0</td>\n",
       "      <td>62</td>\n",
       "      <td>0xD8F7D032DC3955A24CC5394935C8EDC4D06B77812C8A...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>170</td>\n",
       "      <td>314.0</td>\n",
       "      <td>32.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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>108968</td>\n",
       "      <td>108969</td>\n",
       "      <td>PRT</td>\n",
       "      <td>54.0</td>\n",
       "      <td>58</td>\n",
       "      <td>0x7C17DE4E2E27279DA7CD50C2A52030A413E057D34F1D...</td>\n",
       "      <td>0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...</td>\n",
       "      <td>166</td>\n",
       "      <td>938.7</td>\n",
       "      <td>28.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>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>171 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID Nationality   Age  DaysSinceCreation  \\\n",
       "744        745         PRT  40.0               1359   \n",
       "842        843         PRT  48.0               1355   \n",
       "907        908         PRT  33.0               1352   \n",
       "1002      1003         PRT  31.0               1348   \n",
       "1003      1004         PRT  30.0               1348   \n",
       "...        ...         ...   ...                ...   \n",
       "103345  103346         PRT  23.0                103   \n",
       "106428  106429         PRT  10.0                 78   \n",
       "107858  107859         PRT   6.0                 67   \n",
       "108450  108451         PRT  56.0                 62   \n",
       "108968  108969         PRT  54.0                 58   \n",
       "\n",
       "                                                 NameHash  \\\n",
       "744     0xDE75217D31BF3A07C97BC70DF817FCBA6CC5AA29C153...   \n",
       "842     0x927BA21A63552D1FC65670C559845E2B3C19BCC55B18...   \n",
       "907     0x3CA9DDAB19D8F50A425B14FAB6BA283701AB9B5A651C...   \n",
       "1002    0x13B95955F49C8E660F3B7639FDAB4BB75A495493A5A2...   \n",
       "1003    0x155357372FF051877CBE53E7A357935957CB3F22F8D7...   \n",
       "...                                                   ...   \n",
       "103345  0x3B383C03E88F6AFE5508D1E75BBDCB6FE13548B1BDA9...   \n",
       "106428  0x8C93F42F7CE50F07E1B226CDD2111A5413903FA1EC73...   \n",
       "107858  0x151FA6F1DCAD61BDCEF01D315AE43293597CE08B0F10...   \n",
       "108450  0xD8F7D032DC3955A24CC5394935C8EDC4D06B77812C8A...   \n",
       "108968  0x7C17DE4E2E27279DA7CD50C2A52030A413E057D34F1D...   \n",
       "\n",
       "                                                DocIDHash  AverageLeadTime  \\\n",
       "744     0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...              103   \n",
       "842     0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...               17   \n",
       "907     0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...                3   \n",
       "1002    0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...               22   \n",
       "1003    0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...                0   \n",
       "...                                                   ...              ...   \n",
       "103345  0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...                1   \n",
       "106428  0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...                0   \n",
       "107858  0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...                0   \n",
       "108450  0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...              170   \n",
       "108968  0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B...              166   \n",
       "\n",
       "        LodgingRevenue  OtherRevenue  BookingsCanceled  ...  SRMediumFloor  \\\n",
       "744              388.0         120.0                 0  ...              0   \n",
       "842              177.0          77.0                 0  ...              0   \n",
       "907               73.0           7.0                 0  ...              0   \n",
       "1002             172.8          42.0                 0  ...              0   \n",
       "1003               0.0           0.0                 0  ...              0   \n",
       "...                ...           ...               ...  ...            ...   \n",
       "103345           116.0          16.0                 0  ...              0   \n",
       "106428             0.0           0.0                 0  ...              0   \n",
       "107858             0.0           0.0                 0  ...              0   \n",
       "108450           314.0          32.0                 0  ...              0   \n",
       "108968           938.7          28.0                 0  ...              0   \n",
       "\n",
       "        SRBathtub  SRShower  SRCrib SRKingSizeBed SRTwinBed  SRNearElevator  \\\n",
       "744             0         0       0             0         0               0   \n",
       "842             0         0       0             0         0               0   \n",
       "907             0         0       0             0         0               0   \n",
       "1002            0         0       0             1         0               0   \n",
       "1003            0         0       0             1         0               0   \n",
       "...           ...       ...     ...           ...       ...             ...   \n",
       "103345          0         0       0             0         1               0   \n",
       "106428          0         0       0             0         0               0   \n",
       "107858          0         0       0             0         0               0   \n",
       "108450          0         0       0             0         1               0   \n",
       "108968          0         0       0             0         1               0   \n",
       "\n",
       "        SRAwayFromElevator  SRNoAlcoholInMiniBar  SRQuietRoom  \n",
       "744                      0                     0            0  \n",
       "842                      0                     0            0  \n",
       "907                      0                     0            0  \n",
       "1002                     0                     0            0  \n",
       "1003                     0                     0            0  \n",
       "...                    ...                   ...          ...  \n",
       "103345                   0                     0            0  \n",
       "106428                   0                     0            0  \n",
       "107858                   0                     0            1  \n",
       "108450                   0                     0            0  \n",
       "108968                   0                     0            1  \n",
       "\n",
       "[171 rows x 29 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a[(a.DocIDHash=='0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B934CA495991B7852B855') & (~a.Age.isnull())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B934CA495991B7852B855    3031\n",
       "0xA486FBACF4B4E5537B026743E3FDFE571D716839E758236F42950A61FE6B922B      30\n",
       "0x2B17E9D2CCEF2EA0FE752EE345BEDFB06741FFC8ECECF45D6BBDBAF9A274FF52      23\n",
       "0x469CF1F9CF8C790FFA5AD3F484F2938CBEFF6435BCFD734F687EC6D1E968F076      14\n",
       "0x2A14D03A4827C67E0D39408F103DB417AD496DCE6158F8309E6281185C042003      13\n",
       "                                                                      ... \n",
       "0xC2E9F5B7264AF770DB7E78D42C4A566BDAEDA6790C4A2CADD6CDBA30A22B41B1       1\n",
       "0x50A6908B71943FBF414E6760C7696D61A58CFB29BB55C8392B32CD8E816E2BC6       1\n",
       "0x6E08496D8485B95A699EDF39A4E5D3D7E6ACA349A23DC2FBB1ACB55DBF8075D3       1\n",
       "0x6AF1D1958AF5DAEFE05DC55C0224231A5D9DE50F90A8B67B953BCEAA2C0755D0       1\n",
       "0xCFE5F233866148F95D09F74B1449008412516CAA14380D00D917218B501BE75C       1\n",
       "Name: DocIDHash, Length: 3085, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds[(ds.duplicated(subset=['DocIDHash']))].DocIDHash.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Corporate', 'Travel Agent/Operator', 'Direct', 'GDS Systems'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds.DistributionChannel.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         False\n",
       "374       False\n",
       "378       False\n",
       "402       False\n",
       "405       False\n",
       "          ...  \n",
       "111143    False\n",
       "111225     True\n",
       "111226     True\n",
       "111515    False\n",
       "111601    False\n",
       "Length: 3135, dtype: bool"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds[ds.DistributionChannel== 'Corporate'].duplicated(subset=['DocIDHash'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0xE3B0C44298FC1C149AFBF4C8996FB92427AE41E4649B934CA495991B7852B855    275\n",
       "0xA486FBACF4B4E5537B026743E3FDFE571D716839E758236F42950A61FE6B922B     30\n",
       "0x2B17E9D2CCEF2EA0FE752EE345BEDFB06741FFC8ECECF45D6BBDBAF9A274FF52     22\n",
       "0x3856085146F7BC27BD07BFC4CA1991ED4E65E179D7BDB7DBBA7E32620809C799     11\n",
       "0x9220D336F2DDD7B68F5066878889C7637EE28924B249F968F5EC82D895B108A7     11\n",
       "                                                                     ... \n",
       "0xDE497DBCD45593B89D76F9B97CB1B9F3CF9DD677A16998FD35FFB2951A3E8CFD      1\n",
       "0xD03C2CC7EB9FE7EB4FD0129C5AAAC23DE56B5124E2D937FF79FF4DDB949C521C      1\n",
       "0x33B0972B52184C63AF39720B9DD68309776CF43398A8ED97657EFEDC095377C3      1\n",
       "0xD30CB68082161621A24A5D86CADD8A6BD26814C7F65E49913D1B2D8C1D40B687      1\n",
       "0x1AFF5611ED6521CEA7D3CA7A2A626B4F2C6AC53799534C00B7A2FD480A439E56      1\n",
       "Name: DocIDHash, Length: 358, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds[(ds.duplicated(subset=['DocIDHash']))&(ds.DistributionChannel== 'Corporate')].DocIDHash.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "ds['Total_Bookings']=ds.BookingsCanceled + ds.BookingsNoShowed + ds.BookingsCheckedIn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "ds['Total_Revenue']=ds.LodgingRevenue + ds.OtherRevenue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         3\n",
       "1         1\n",
       "2         0\n",
       "3         1\n",
       "4         0\n",
       "         ..\n",
       "111728    0\n",
       "111729    1\n",
       "111730    0\n",
       "111731    1\n",
       "111732    0\n",
       "Name: Total_Bookings, Length: 111733, dtype: int64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds.Total_Bookings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>ID</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Age</th>\n",
       "      <th>DaysSinceCreation</th>\n",
       "      <th>NameHash</th>\n",
       "      <th>DocIDHash</th>\n",
       "      <th>AverageLeadTime</th>\n",
       "      <th>LodgingRevenue</th>\n",
       "      <th>OtherRevenue</th>\n",
       "      <th>BookingsCanceled</th>\n",
       "      <th>...</th>\n",
       "      <th>SRShower</th>\n",
       "      <th>SRCrib</th>\n",
       "      <th>SRKingSizeBed</th>\n",
       "      <th>SRTwinBed</th>\n",
       "      <th>SRNearElevator</th>\n",
       "      <th>SRAwayFromElevator</th>\n",
       "      <th>SRNoAlcoholInMiniBar</th>\n",
       "      <th>SRQuietRoom</th>\n",
       "      <th>Total_Bookings</th>\n",
       "      <th>Total_Revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>DEU</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0xDA46E62F66936284DF2844EC4FC542D0DAD780C0EE0C...</td>\n",
       "      <td>0x27F5DF762CCDA622C752CCDA45794923BED9F1B66300...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>FRA</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0xD2E3D5BFCA141865669F98D64CDA85AD04DEFF47F8A0...</td>\n",
       "      <td>0x42BDEE0E05A9441C94147076EDDCC47E604DA5447DD4...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>JPN</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0x94DB830C90A6DA2331968CFC9448AB9A3CE07D7CFEDD...</td>\n",
       "      <td>0x47E5E4B21585F1FD956C768E730604241B380EDFEA68...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>FRA</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0x44BB41EF2D87698E75B6FBB77A8815BF48DAA912C140...</td>\n",
       "      <td>0x6C456E45A78A20BC794137AE326A81D587B6528B3944...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>IRL</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0x606584F7B9D6A1905BF9B7ED7B7EBE5DF17DF22FECDF...</td>\n",
       "      <td>0xCA46CD508DB3DB2085374141177E07ECEC4B724AE41C...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111723</td>\n",
       "      <td>111724</td>\n",
       "      <td>ITA</td>\n",
       "      <td>56.0</td>\n",
       "      <td>37</td>\n",
       "      <td>0x82277FA4AD074DA9786E64E977C94FEF1C2E47CD6212...</td>\n",
       "      <td>0x5ED6055421E857EA3496D4C75FA2237ACD353DB1B64B...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111725</td>\n",
       "      <td>111726</td>\n",
       "      <td>PAN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>37</td>\n",
       "      <td>0xAA3529E305173010BADE927C7015FA091C3883D257E9...</td>\n",
       "      <td>0xDC47997245A7B9ACF9D4974149D2100CEB00981A2F03...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111728</td>\n",
       "      <td>111729</td>\n",
       "      <td>DEU</td>\n",
       "      <td>31.0</td>\n",
       "      <td>36</td>\n",
       "      <td>0x2F59F0E86596B861C3303585FDB7F090B1B2D70442C5...</td>\n",
       "      <td>0x86AC02B9393E7F58354BA4193D792C07DB91D4BE27C7...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111730</td>\n",
       "      <td>111731</td>\n",
       "      <td>BRA</td>\n",
       "      <td>37.0</td>\n",
       "      <td>36</td>\n",
       "      <td>0xEF5F6AAA6120F2AC49179E16FD12477C243A8F4FC504...</td>\n",
       "      <td>0x74B9B5A554F5F660371E56D4CE4C1D4C3DC80AE71D68...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111732</td>\n",
       "      <td>111733</td>\n",
       "      <td>DEU</td>\n",
       "      <td>48.0</td>\n",
       "      <td>36</td>\n",
       "      <td>0xE52EE501843E3108F20BB8F2EC180D8654DF1424EFA2...</td>\n",
       "      <td>0xD539E89183AB389864B7A24B3C1FBC1FE20A40ED02E7...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33197 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID Nationality   Age  DaysSinceCreation  \\\n",
       "2            3         DEU  32.0               1385   \n",
       "4            5         FRA  52.0               1385   \n",
       "6            7         JPN  50.0               1385   \n",
       "8            9         FRA  43.0               1385   \n",
       "10          11         IRL  28.0               1385   \n",
       "...        ...         ...   ...                ...   \n",
       "111723  111724         ITA  56.0                 37   \n",
       "111725  111726         PAN  60.0                 37   \n",
       "111728  111729         DEU  31.0                 36   \n",
       "111730  111731         BRA  37.0                 36   \n",
       "111732  111733         DEU  48.0                 36   \n",
       "\n",
       "                                                 NameHash  \\\n",
       "2       0xDA46E62F66936284DF2844EC4FC542D0DAD780C0EE0C...   \n",
       "4       0xD2E3D5BFCA141865669F98D64CDA85AD04DEFF47F8A0...   \n",
       "6       0x94DB830C90A6DA2331968CFC9448AB9A3CE07D7CFEDD...   \n",
       "8       0x44BB41EF2D87698E75B6FBB77A8815BF48DAA912C140...   \n",
       "10      0x606584F7B9D6A1905BF9B7ED7B7EBE5DF17DF22FECDF...   \n",
       "...                                                   ...   \n",
       "111723  0x82277FA4AD074DA9786E64E977C94FEF1C2E47CD6212...   \n",
       "111725  0xAA3529E305173010BADE927C7015FA091C3883D257E9...   \n",
       "111728  0x2F59F0E86596B861C3303585FDB7F090B1B2D70442C5...   \n",
       "111730  0xEF5F6AAA6120F2AC49179E16FD12477C243A8F4FC504...   \n",
       "111732  0xE52EE501843E3108F20BB8F2EC180D8654DF1424EFA2...   \n",
       "\n",
       "                                                DocIDHash  AverageLeadTime  \\\n",
       "2       0x27F5DF762CCDA622C752CCDA45794923BED9F1B66300...                0   \n",
       "4       0x42BDEE0E05A9441C94147076EDDCC47E604DA5447DD4...                0   \n",
       "6       0x47E5E4B21585F1FD956C768E730604241B380EDFEA68...                0   \n",
       "8       0x6C456E45A78A20BC794137AE326A81D587B6528B3944...                0   \n",
       "10      0xCA46CD508DB3DB2085374141177E07ECEC4B724AE41C...                0   \n",
       "...                                                   ...              ...   \n",
       "111723  0x5ED6055421E857EA3496D4C75FA2237ACD353DB1B64B...                0   \n",
       "111725  0xDC47997245A7B9ACF9D4974149D2100CEB00981A2F03...                0   \n",
       "111728  0x86AC02B9393E7F58354BA4193D792C07DB91D4BE27C7...                0   \n",
       "111730  0x74B9B5A554F5F660371E56D4CE4C1D4C3DC80AE71D68...                0   \n",
       "111732  0xD539E89183AB389864B7A24B3C1FBC1FE20A40ED02E7...                0   \n",
       "\n",
       "        LodgingRevenue  OtherRevenue  BookingsCanceled  ...  SRShower  SRCrib  \\\n",
       "2                  0.0           0.0                 0  ...         0       0   \n",
       "4                  0.0           0.0                 0  ...         0       0   \n",
       "6                  0.0           0.0                 0  ...         0       0   \n",
       "8                  0.0           0.0                 0  ...         0       0   \n",
       "10                 0.0           0.0                 0  ...         0       0   \n",
       "...                ...           ...               ...  ...       ...     ...   \n",
       "111723             0.0           0.0                 0  ...         0       0   \n",
       "111725             0.0           0.0                 0  ...         0       0   \n",
       "111728             0.0           0.0                 0  ...         0       0   \n",
       "111730             0.0           0.0                 0  ...         0       0   \n",
       "111732             0.0           0.0                 0  ...         0       0   \n",
       "\n",
       "        SRKingSizeBed  SRTwinBed SRNearElevator SRAwayFromElevator  \\\n",
       "2                   0          0              0                  0   \n",
       "4                   0          0              0                  0   \n",
       "6                   0          0              0                  0   \n",
       "8                   1          0              0                  0   \n",
       "10                  0          0              0                  0   \n",
       "...               ...        ...            ...                ...   \n",
       "111723              1          0              0                  0   \n",
       "111725              0          1              1                  0   \n",
       "111728              1          0              0                  0   \n",
       "111730              1          0              0                  0   \n",
       "111732              0          0              0                  0   \n",
       "\n",
       "        SRNoAlcoholInMiniBar  SRQuietRoom  Total_Bookings  Total_Revenue  \n",
       "2                          0            0               0            0.0  \n",
       "4                          0            0               0            0.0  \n",
       "6                          0            0               0            0.0  \n",
       "8                          0            0               0            0.0  \n",
       "10                         0            0               0            0.0  \n",
       "...                      ...          ...             ...            ...  \n",
       "111723                     0            0               0            0.0  \n",
       "111725                     0            0               0            0.0  \n",
       "111728                     0            0               0            0.0  \n",
       "111730                     0            0               0            0.0  \n",
       "111732                     0            0               0            0.0  \n",
       "\n",
       "[33197 rows x 31 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total = ds[(ds.Total_Bookings==0)]\n",
    "total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>ID</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>75481.810796</td>\n",
       "      <td>23666.188706</td>\n",
       "      <td>3.0</td>\n",
       "      <td>59462.0</td>\n",
       "      <td>76182.0</td>\n",
       "      <td>94670.0</td>\n",
       "      <td>111733.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Age</td>\n",
       "      <td>32072.0</td>\n",
       "      <td>39.966139</td>\n",
       "      <td>20.205140</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>DaysSinceCreation</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>365.488779</td>\n",
       "      <td>247.751981</td>\n",
       "      <td>36.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>369.0</td>\n",
       "      <td>493.0</td>\n",
       "      <td>1385.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>AverageLeadTime</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.013947</td>\n",
       "      <td>2.015055</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>349.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>LodgingRevenue</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.007510</td>\n",
       "      <td>1.368273</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>249.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>OtherRevenue</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000542</td>\n",
       "      <td>0.098792</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsCanceled</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsNoShowed</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsCheckedIn</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PersonsNights</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>RoomNights</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRHighFloor</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.045667</td>\n",
       "      <td>0.208765</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRLowFloor</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.001476</td>\n",
       "      <td>0.038391</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRAccessibleRoom</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000120</td>\n",
       "      <td>0.010976</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRMediumFloor</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000693</td>\n",
       "      <td>0.026313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRBathtub</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.003796</td>\n",
       "      <td>0.061492</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRShower</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.001566</td>\n",
       "      <td>0.039547</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRCrib</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.029551</td>\n",
       "      <td>0.169347</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRKingSizeBed</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.383438</td>\n",
       "      <td>0.486231</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRTwinBed</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.181673</td>\n",
       "      <td>0.385581</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRNearElevator</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000271</td>\n",
       "      <td>0.016463</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRAwayFromElevator</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.003283</td>\n",
       "      <td>0.057208</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRNoAlcoholInMiniBar</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000361</td>\n",
       "      <td>0.019009</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRQuietRoom</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.092026</td>\n",
       "      <td>0.289068</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Total_Bookings</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Total_Revenue</td>\n",
       "      <td>33197.0</td>\n",
       "      <td>0.008052</td>\n",
       "      <td>1.467066</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>267.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        count          mean           std   min      25%  \\\n",
       "ID                    33197.0  75481.810796  23666.188706   3.0  59462.0   \n",
       "Age                   32072.0     39.966139     20.205140  -6.0     24.0   \n",
       "DaysSinceCreation     33197.0    365.488779    247.751981  36.0    176.0   \n",
       "AverageLeadTime       33197.0      0.013947      2.015055   0.0      0.0   \n",
       "LodgingRevenue        33197.0      0.007510      1.368273   0.0      0.0   \n",
       "OtherRevenue          33197.0      0.000542      0.098792   0.0      0.0   \n",
       "BookingsCanceled      33197.0      0.000000      0.000000   0.0      0.0   \n",
       "BookingsNoShowed      33197.0      0.000000      0.000000   0.0      0.0   \n",
       "BookingsCheckedIn     33197.0      0.000000      0.000000   0.0      0.0   \n",
       "PersonsNights         33197.0      0.000000      0.000000   0.0      0.0   \n",
       "RoomNights            33197.0      0.000000      0.000000   0.0      0.0   \n",
       "SRHighFloor           33197.0      0.045667      0.208765   0.0      0.0   \n",
       "SRLowFloor            33197.0      0.001476      0.038391   0.0      0.0   \n",
       "SRAccessibleRoom      33197.0      0.000120      0.010976   0.0      0.0   \n",
       "SRMediumFloor         33197.0      0.000693      0.026313   0.0      0.0   \n",
       "SRBathtub             33197.0      0.003796      0.061492   0.0      0.0   \n",
       "SRShower              33197.0      0.001566      0.039547   0.0      0.0   \n",
       "SRCrib                33197.0      0.029551      0.169347   0.0      0.0   \n",
       "SRKingSizeBed         33197.0      0.383438      0.486231   0.0      0.0   \n",
       "SRTwinBed             33197.0      0.181673      0.385581   0.0      0.0   \n",
       "SRNearElevator        33197.0      0.000271      0.016463   0.0      0.0   \n",
       "SRAwayFromElevator    33197.0      0.003283      0.057208   0.0      0.0   \n",
       "SRNoAlcoholInMiniBar  33197.0      0.000361      0.019009   0.0      0.0   \n",
       "SRQuietRoom           33197.0      0.092026      0.289068   0.0      0.0   \n",
       "Total_Bookings        33197.0      0.000000      0.000000   0.0      0.0   \n",
       "Total_Revenue         33197.0      0.008052      1.467066   0.0      0.0   \n",
       "\n",
       "                          50%      75%       max  \n",
       "ID                    76182.0  94670.0  111733.0  \n",
       "Age                      41.0     56.0     123.0  \n",
       "DaysSinceCreation       369.0    493.0    1385.0  \n",
       "AverageLeadTime           0.0      0.0     349.0  \n",
       "LodgingRevenue            0.0      0.0     249.3  \n",
       "OtherRevenue              0.0      0.0      18.0  \n",
       "BookingsCanceled          0.0      0.0       0.0  \n",
       "BookingsNoShowed          0.0      0.0       0.0  \n",
       "BookingsCheckedIn         0.0      0.0       0.0  \n",
       "PersonsNights             0.0      0.0       0.0  \n",
       "RoomNights                0.0      0.0       0.0  \n",
       "SRHighFloor               0.0      0.0       1.0  \n",
       "SRLowFloor                0.0      0.0       1.0  \n",
       "SRAccessibleRoom          0.0      0.0       1.0  \n",
       "SRMediumFloor             0.0      0.0       1.0  \n",
       "SRBathtub                 0.0      0.0       1.0  \n",
       "SRShower                  0.0      0.0       1.0  \n",
       "SRCrib                    0.0      0.0       1.0  \n",
       "SRKingSizeBed             0.0      1.0       1.0  \n",
       "SRTwinBed                 0.0      0.0       1.0  \n",
       "SRNearElevator            0.0      0.0       1.0  \n",
       "SRAwayFromElevator        0.0      0.0       1.0  \n",
       "SRNoAlcoholInMiniBar      0.0      0.0       1.0  \n",
       "SRQuietRoom               0.0      0.0       1.0  \n",
       "Total_Bookings            0.0      0.0       0.0  \n",
       "Total_Revenue             0.0      0.0     267.3  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "summary_total=total.describe(exclude=[np.object])   # exclude only objects, that decrease readability and do not bring information\n",
    "summary_total=summary_total.transpose()  # transpose the summary for easier reading\n",
    "summary_total.head(len(summary_total))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>ID</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Age</th>\n",
       "      <th>DaysSinceCreation</th>\n",
       "      <th>NameHash</th>\n",
       "      <th>DocIDHash</th>\n",
       "      <th>AverageLeadTime</th>\n",
       "      <th>LodgingRevenue</th>\n",
       "      <th>OtherRevenue</th>\n",
       "      <th>BookingsCanceled</th>\n",
       "      <th>...</th>\n",
       "      <th>SRShower</th>\n",
       "      <th>SRCrib</th>\n",
       "      <th>SRKingSizeBed</th>\n",
       "      <th>SRTwinBed</th>\n",
       "      <th>SRNearElevator</th>\n",
       "      <th>SRAwayFromElevator</th>\n",
       "      <th>SRNoAlcoholInMiniBar</th>\n",
       "      <th>SRQuietRoom</th>\n",
       "      <th>Total_Bookings</th>\n",
       "      <th>Total_Revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>DEU</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0xDA46E62F66936284DF2844EC4FC542D0DAD780C0EE0C...</td>\n",
       "      <td>0x27F5DF762CCDA622C752CCDA45794923BED9F1B66300...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>FRA</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0xD2E3D5BFCA141865669F98D64CDA85AD04DEFF47F8A0...</td>\n",
       "      <td>0x42BDEE0E05A9441C94147076EDDCC47E604DA5447DD4...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>JPN</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0x94DB830C90A6DA2331968CFC9448AB9A3CE07D7CFEDD...</td>\n",
       "      <td>0x47E5E4B21585F1FD956C768E730604241B380EDFEA68...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>FRA</td>\n",
       "      <td>43.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0x44BB41EF2D87698E75B6FBB77A8815BF48DAA912C140...</td>\n",
       "      <td>0x6C456E45A78A20BC794137AE326A81D587B6528B3944...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>IRL</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1385</td>\n",
       "      <td>0x606584F7B9D6A1905BF9B7ED7B7EBE5DF17DF22FECDF...</td>\n",
       "      <td>0xCA46CD508DB3DB2085374141177E07ECEC4B724AE41C...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111723</td>\n",
       "      <td>111724</td>\n",
       "      <td>ITA</td>\n",
       "      <td>56.0</td>\n",
       "      <td>37</td>\n",
       "      <td>0x82277FA4AD074DA9786E64E977C94FEF1C2E47CD6212...</td>\n",
       "      <td>0x5ED6055421E857EA3496D4C75FA2237ACD353DB1B64B...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111725</td>\n",
       "      <td>111726</td>\n",
       "      <td>PAN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>37</td>\n",
       "      <td>0xAA3529E305173010BADE927C7015FA091C3883D257E9...</td>\n",
       "      <td>0xDC47997245A7B9ACF9D4974149D2100CEB00981A2F03...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111728</td>\n",
       "      <td>111729</td>\n",
       "      <td>DEU</td>\n",
       "      <td>31.0</td>\n",
       "      <td>36</td>\n",
       "      <td>0x2F59F0E86596B861C3303585FDB7F090B1B2D70442C5...</td>\n",
       "      <td>0x86AC02B9393E7F58354BA4193D792C07DB91D4BE27C7...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111730</td>\n",
       "      <td>111731</td>\n",
       "      <td>BRA</td>\n",
       "      <td>37.0</td>\n",
       "      <td>36</td>\n",
       "      <td>0xEF5F6AAA6120F2AC49179E16FD12477C243A8F4FC504...</td>\n",
       "      <td>0x74B9B5A554F5F660371E56D4CE4C1D4C3DC80AE71D68...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\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>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111732</td>\n",
       "      <td>111733</td>\n",
       "      <td>DEU</td>\n",
       "      <td>48.0</td>\n",
       "      <td>36</td>\n",
       "      <td>0xE52EE501843E3108F20BB8F2EC180D8654DF1424EFA2...</td>\n",
       "      <td>0xD539E89183AB389864B7A24B3C1FBC1FE20A40ED02E7...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33196 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            ID Nationality   Age  DaysSinceCreation  \\\n",
       "2            3         DEU  32.0               1385   \n",
       "4            5         FRA  52.0               1385   \n",
       "6            7         JPN  50.0               1385   \n",
       "8            9         FRA  43.0               1385   \n",
       "10          11         IRL  28.0               1385   \n",
       "...        ...         ...   ...                ...   \n",
       "111723  111724         ITA  56.0                 37   \n",
       "111725  111726         PAN  60.0                 37   \n",
       "111728  111729         DEU  31.0                 36   \n",
       "111730  111731         BRA  37.0                 36   \n",
       "111732  111733         DEU  48.0                 36   \n",
       "\n",
       "                                                 NameHash  \\\n",
       "2       0xDA46E62F66936284DF2844EC4FC542D0DAD780C0EE0C...   \n",
       "4       0xD2E3D5BFCA141865669F98D64CDA85AD04DEFF47F8A0...   \n",
       "6       0x94DB830C90A6DA2331968CFC9448AB9A3CE07D7CFEDD...   \n",
       "8       0x44BB41EF2D87698E75B6FBB77A8815BF48DAA912C140...   \n",
       "10      0x606584F7B9D6A1905BF9B7ED7B7EBE5DF17DF22FECDF...   \n",
       "...                                                   ...   \n",
       "111723  0x82277FA4AD074DA9786E64E977C94FEF1C2E47CD6212...   \n",
       "111725  0xAA3529E305173010BADE927C7015FA091C3883D257E9...   \n",
       "111728  0x2F59F0E86596B861C3303585FDB7F090B1B2D70442C5...   \n",
       "111730  0xEF5F6AAA6120F2AC49179E16FD12477C243A8F4FC504...   \n",
       "111732  0xE52EE501843E3108F20BB8F2EC180D8654DF1424EFA2...   \n",
       "\n",
       "                                                DocIDHash  AverageLeadTime  \\\n",
       "2       0x27F5DF762CCDA622C752CCDA45794923BED9F1B66300...                0   \n",
       "4       0x42BDEE0E05A9441C94147076EDDCC47E604DA5447DD4...                0   \n",
       "6       0x47E5E4B21585F1FD956C768E730604241B380EDFEA68...                0   \n",
       "8       0x6C456E45A78A20BC794137AE326A81D587B6528B3944...                0   \n",
       "10      0xCA46CD508DB3DB2085374141177E07ECEC4B724AE41C...                0   \n",
       "...                                                   ...              ...   \n",
       "111723  0x5ED6055421E857EA3496D4C75FA2237ACD353DB1B64B...                0   \n",
       "111725  0xDC47997245A7B9ACF9D4974149D2100CEB00981A2F03...                0   \n",
       "111728  0x86AC02B9393E7F58354BA4193D792C07DB91D4BE27C7...                0   \n",
       "111730  0x74B9B5A554F5F660371E56D4CE4C1D4C3DC80AE71D68...                0   \n",
       "111732  0xD539E89183AB389864B7A24B3C1FBC1FE20A40ED02E7...                0   \n",
       "\n",
       "        LodgingRevenue  OtherRevenue  BookingsCanceled  ...  SRShower  SRCrib  \\\n",
       "2                  0.0           0.0                 0  ...         0       0   \n",
       "4                  0.0           0.0                 0  ...         0       0   \n",
       "6                  0.0           0.0                 0  ...         0       0   \n",
       "8                  0.0           0.0                 0  ...         0       0   \n",
       "10                 0.0           0.0                 0  ...         0       0   \n",
       "...                ...           ...               ...  ...       ...     ...   \n",
       "111723             0.0           0.0                 0  ...         0       0   \n",
       "111725             0.0           0.0                 0  ...         0       0   \n",
       "111728             0.0           0.0                 0  ...         0       0   \n",
       "111730             0.0           0.0                 0  ...         0       0   \n",
       "111732             0.0           0.0                 0  ...         0       0   \n",
       "\n",
       "        SRKingSizeBed  SRTwinBed SRNearElevator SRAwayFromElevator  \\\n",
       "2                   0          0              0                  0   \n",
       "4                   0          0              0                  0   \n",
       "6                   0          0              0                  0   \n",
       "8                   1          0              0                  0   \n",
       "10                  0          0              0                  0   \n",
       "...               ...        ...            ...                ...   \n",
       "111723              1          0              0                  0   \n",
       "111725              0          1              1                  0   \n",
       "111728              1          0              0                  0   \n",
       "111730              1          0              0                  0   \n",
       "111732              0          0              0                  0   \n",
       "\n",
       "        SRNoAlcoholInMiniBar  SRQuietRoom  Total_Bookings  Total_Revenue  \n",
       "2                          0            0               0            0.0  \n",
       "4                          0            0               0            0.0  \n",
       "6                          0            0               0            0.0  \n",
       "8                          0            0               0            0.0  \n",
       "10                         0            0               0            0.0  \n",
       "...                      ...          ...             ...            ...  \n",
       "111723                     0            0               0            0.0  \n",
       "111725                     0            0               0            0.0  \n",
       "111728                     0            0               0            0.0  \n",
       "111730                     0            0               0            0.0  \n",
       "111732                     0            0               0            0.0  \n",
       "\n",
       "[33196 rows x 31 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total = ds[(ds.Total_Bookings==0)&(ds.Total_Revenue==0)]\n",
    "total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>ID</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>75481.958459</td>\n",
       "      <td>23666.529882</td>\n",
       "      <td>3.0</td>\n",
       "      <td>59461.5</td>\n",
       "      <td>76183.0</td>\n",
       "      <td>94670.5</td>\n",
       "      <td>111733.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Age</td>\n",
       "      <td>32072.0</td>\n",
       "      <td>39.966139</td>\n",
       "      <td>20.205140</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>123.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>DaysSinceCreation</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>365.487438</td>\n",
       "      <td>247.755592</td>\n",
       "      <td>36.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>369.0</td>\n",
       "      <td>493.0</td>\n",
       "      <td>1385.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>AverageLeadTime</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.010513</td>\n",
       "      <td>1.915502</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>349.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>LodgingRevenue</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>OtherRevenue</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsCanceled</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsNoShowed</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>BookingsCheckedIn</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PersonsNights</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>RoomNights</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRHighFloor</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.045668</td>\n",
       "      <td>0.208768</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRLowFloor</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.001476</td>\n",
       "      <td>0.038392</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRAccessibleRoom</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000120</td>\n",
       "      <td>0.010977</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRMediumFloor</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000693</td>\n",
       "      <td>0.026313</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRBathtub</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.003796</td>\n",
       "      <td>0.061493</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRShower</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.001566</td>\n",
       "      <td>0.039548</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRCrib</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.029552</td>\n",
       "      <td>0.169350</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRKingSizeBed</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.383450</td>\n",
       "      <td>0.486234</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRTwinBed</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.181679</td>\n",
       "      <td>0.385585</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRNearElevator</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000271</td>\n",
       "      <td>0.016464</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRAwayFromElevator</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.003284</td>\n",
       "      <td>0.057209</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRNoAlcoholInMiniBar</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000361</td>\n",
       "      <td>0.019010</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SRQuietRoom</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.092029</td>\n",
       "      <td>0.289071</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Total_Bookings</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Total_Revenue</td>\n",
       "      <td>33196.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        count          mean           std   min      25%  \\\n",
       "ID                    33196.0  75481.958459  23666.529882   3.0  59461.5   \n",
       "Age                   32072.0     39.966139     20.205140  -6.0     24.0   \n",
       "DaysSinceCreation     33196.0    365.487438    247.755592  36.0    176.0   \n",
       "AverageLeadTime       33196.0      0.010513      1.915502   0.0      0.0   \n",
       "LodgingRevenue        33196.0      0.000000      0.000000   0.0      0.0   \n",
       "OtherRevenue          33196.0      0.000000      0.000000   0.0      0.0   \n",
       "BookingsCanceled      33196.0      0.000000      0.000000   0.0      0.0   \n",
       "BookingsNoShowed      33196.0      0.000000      0.000000   0.0      0.0   \n",
       "BookingsCheckedIn     33196.0      0.000000      0.000000   0.0      0.0   \n",
       "PersonsNights         33196.0      0.000000      0.000000   0.0      0.0   \n",
       "RoomNights            33196.0      0.000000      0.000000   0.0      0.0   \n",
       "SRHighFloor           33196.0      0.045668      0.208768   0.0      0.0   \n",
       "SRLowFloor            33196.0      0.001476      0.038392   0.0      0.0   \n",
       "SRAccessibleRoom      33196.0      0.000120      0.010977   0.0      0.0   \n",
       "SRMediumFloor         33196.0      0.000693      0.026313   0.0      0.0   \n",
       "SRBathtub             33196.0      0.003796      0.061493   0.0      0.0   \n",
       "SRShower              33196.0      0.001566      0.039548   0.0      0.0   \n",
       "SRCrib                33196.0      0.029552      0.169350   0.0      0.0   \n",
       "SRKingSizeBed         33196.0      0.383450      0.486234   0.0      0.0   \n",
       "SRTwinBed             33196.0      0.181679      0.385585   0.0      0.0   \n",
       "SRNearElevator        33196.0      0.000271      0.016464   0.0      0.0   \n",
       "SRAwayFromElevator    33196.0      0.003284      0.057209   0.0      0.0   \n",
       "SRNoAlcoholInMiniBar  33196.0      0.000361      0.019010   0.0      0.0   \n",
       "SRQuietRoom           33196.0      0.092029      0.289071   0.0      0.0   \n",
       "Total_Bookings        33196.0      0.000000      0.000000   0.0      0.0   \n",
       "Total_Revenue         33196.0      0.000000      0.000000   0.0      0.0   \n",
       "\n",
       "                          50%      75%       max  \n",
       "ID                    76183.0  94670.5  111733.0  \n",
       "Age                      41.0     56.0     123.0  \n",
       "DaysSinceCreation       369.0    493.0    1385.0  \n",
       "AverageLeadTime           0.0      0.0     349.0  \n",
       "LodgingRevenue            0.0      0.0       0.0  \n",
       "OtherRevenue              0.0      0.0       0.0  \n",
       "BookingsCanceled          0.0      0.0       0.0  \n",
       "BookingsNoShowed          0.0      0.0       0.0  \n",
       "BookingsCheckedIn         0.0      0.0       0.0  \n",
       "PersonsNights             0.0      0.0       0.0  \n",
       "RoomNights                0.0      0.0       0.0  \n",
       "SRHighFloor               0.0      0.0       1.0  \n",
       "SRLowFloor                0.0      0.0       1.0  \n",
       "SRAccessibleRoom          0.0      0.0       1.0  \n",
       "SRMediumFloor             0.0      0.0       1.0  \n",
       "SRBathtub                 0.0      0.0       1.0  \n",
       "SRShower                  0.0      0.0       1.0  \n",
       "SRCrib                    0.0      0.0       1.0  \n",
       "SRKingSizeBed             0.0      1.0       1.0  \n",
       "SRTwinBed                 0.0      0.0       1.0  \n",
       "SRNearElevator            0.0      0.0       1.0  \n",
       "SRAwayFromElevator        0.0      0.0       1.0  \n",
       "SRNoAlcoholInMiniBar      0.0      0.0       1.0  \n",
       "SRQuietRoom               0.0      0.0       1.0  \n",
       "Total_Bookings            0.0      0.0       0.0  \n",
       "Total_Revenue             0.0      0.0       0.0  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "summary_total=total.describe(exclude=[np.object])   # exclude only objects, that decrease readability and do not bring information\n",
    "summary_total=summary_total.transpose()  # transpose the summary for easier reading\n",
    "summary_total.head(len(summary_total))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}