DataFrame
Compared
2749
ROWS
4318
0
DUPLICATES
0
3.1 MB
RAM
4.6 MB
24
FEATURES
23
18
CATEGORICAL
17
3
NUMERICAL
3
3
TEXT
3
2.0.9
Get updates, docs & report issues here

Created & maintained by Francois Bertrand
Graphic design by Jean-Francois Hains
1
Reservation-id
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
2,749
(100%)
4,318
(100%)
ZEROES:
---
---
MAX
100.0M
100.0M
95%
95.0M
95.0M
Q3
74.7M
75.2M
AVG
49.9M
50.4M
MEDIAN
49.3M
51.1M
Q1
24.8M
25.5M
5%
5.8M
5.1M
MIN
0.0M
0.1M
RANGE
100.0M
99.9M
IQR
49.9M
49.7M
STD
28.9M
28.8M
VAR
834.1T
829.1T
KURT.
-1.21
-1.20
SKEW
0.026
-0.026
SUM
137.2B
217.8B
2
Gender
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
2
(<1%)
2
(<1%)
3
Age
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
53
(2%)
53
(1%)
ZEROES:
---
---
MAX
70.0
70.0
95%
68.0
68.0
Q3
57.0
57.0
AVG
44.2
43.8
MEDIAN
44.0
44.0
Q1
31.0
31.0
5%
21.0
20.0
MIN
18.0
18.0
RANGE
52.0
52.0
IQR
26.0
26.0
STD
15.2
15.3
VAR
231
233
KURT.
-1.20
-1.17
SKEW
0.005
0.016
SUM
121k
189k
4
Ethnicity
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
4
(<1%)
4
(<1%)
5
Educational_Level
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
4
(<1%)
4
(<1%)
6
Income
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
4
(<1%)
4
(<1%)
7
Country_region
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
4
(<1%)
4
(<1%)
8
Hotel_Type
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
3
(<1%)
3
(<1%)
9
Expected_checkin
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
151
(5%)
191
(4%)
86
3%
-
-
10/6/2016
71
3%
-
-
10/20/2016
69
3%
-
-
10/11/2016
65
2%
-
-
10/12/2016
62
2%
-
-
11/12/2016
56
2%
-
-
9/15/2016
56
2%
-
-
10/24/2016
2,284
83%
4,318
100%
(Other)
10
Expected_checkout
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
156
(6%)
194
(4%)
67
2%
-
-
10/13/2016
66
2%
-
-
10/7/2016
55
2%
-
-
10/12/2016
53
2%
-
-
10/31/2016
50
2%
-
-
11/1/2016
50
2%
-
-
10/21/2016
49
2%
-
-
10/24/2016
2,359
86%
4,318
100%
(Other)
11
Booking_date
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
322
(12%)
370
(9%)
23
<1%
7
<1%
6/1/2016
21
<1%
4
<1%
4/14/2016
21
<1%
14
<1%
7/8/2016
20
<1%
16
<1%
7/19/2016
19
<1%
17
<1%
8/17/2016
19
<1%
7
<1%
4/29/2016
19
<1%
1
<1%
4/19/2016
2,607
95%
4,252
98%
(Other)
12
Adults
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
5
(<1%)
5
(<1%)
13
Children
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
3
(<1%)
3
(<1%)
14
Babies
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
3
(<1%)
3
(<1%)
15
Meal_Type
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
3
(<1%)
3
(<1%)
16
Visted_Previously
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
2
(<1%)
2
(<1%)
17
Previous_Cancellations
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
2
(<1%)
2
(<1%)
18
Deposit_type
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
3
(<1%)
3
(<1%)
19
Booking_channel
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
3
(<1%)
3
(<1%)
20
Required_Car_Parking
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
2
(<1%)
2
(<1%)
21
Reservation_Status
VALUES:
2,749
(100%)
MISSING:
---
DISTINCT:
3
(<1%)
22
Use_Promotion
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
2
(<1%)
2
(<1%)
23
Discount_Rate
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
8
(<1%)
8
(<1%)
24
Room_Rate
VALUES:
2,749
(100%)
4,318
(100%)
MISSING:
---
---
DISTINCT:
151
(5%)
151
(3%)
ZEROES:
---
---
MAX
250
250
95%
243
242
Q3
212
212
AVG
174
176
MEDIAN
173
176
Q1
136
139
5%
106
108
MIN
100
100
RANGE
150
150
IQR
76.0
73.0
STD
43.9
42.9
VAR
1,925
1,844
KURT.
-1.22
-1.19
SKEW
0.032
-0.019
SUM
478k
758k
Associations
[Only including dataset "DataFrame"] Squares are categorical associations (uncertainty coefficient & correlation ratio) from 0 to 1. The uncertainty coefficient is assymmetrical, (approximating how much the elements on the left PROVIDE INFORMATION on elements in the row). Circles are the symmetrical numerical correlations (Pearson's) from -1 to 1. The trivial diagonal is intentionally left blank for clarity.
Associations
[Only including dataset "Compared"] Squares are categorical associations (uncertainty coefficient & correlation ratio) from 0 to 1. The uncertainty coefficient is assymmetrical, (approximating how much the elements on the left PROVIDE INFORMATION on elements in the row). Circles are the symmetrical numerical correlations (Pearson's) from -1 to 1. The trivial diagonal is intentionally left blank for clarity.
Reservation-id
MISSING:
---
---
>
NUMERICAL ASSOCIATIONS
(PEARSON, -1 to 1)

Room_Rate
-0.03
Age
0.03

CATEGORICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)

Discount_Rate
0.06
Country_region
0.05
Gender
0.04
Babies
0.04
Income
0.04
Adults
0.03
Meal_Type
0.03
Hotel_Type
0.03
Required_Car_Parking
0.03
Children
0.03
Booking_channel
0.03
Ethnicity
0.03
Deposit_type
0.02
Previous_Cancellations
0.02
MOST FREQUENT VALUES

64894977
1
<0.1%
0
0.0%
8168111
1
<0.1%
0
0.0%
60652309
1
<0.1%
0
0.0%
90768037
1
<0.1%
0
0.0%
56285862
1
<0.1%
0
0.0%
51252574
1
<0.1%
0
0.0%
58221549
1
<0.1%
0
0.0%
57258665
1
<0.1%
0
0.0%
22557355
1
<0.1%
0
0.0%
49959597
1
<0.1%
0
0.0%
33249968
1
<0.1%
0
0.0%
17763008
1
<0.1%
0
0.0%
43250353
1
<0.1%
0
0.0%
80038578
1
<0.1%
0
0.0%
11965107
1
<0.1%
0
0.0%
SMALLEST VALUES

143
1
<0.1%
0
0.0%
44414
1
<0.1%
0
0.0%
57696
1
<0.1%
0
0.0%
111054
1
<0.1%
0
0.0%
235442
1
<0.1%
0
0.0%
291672
1
<0.1%
0
0.0%
311232
1
<0.1%
0
0.0%
378037
1
<0.1%
0
0.0%
421734
1
<0.1%
0
0.0%
464732
1
<0.1%
0
0.0%
508956
1
<0.1%
0
0.0%
510266
1
<0.1%
0
0.0%
564266
1
<0.1%
0
0.0%
617024
1
<0.1%
0
0.0%
627299
1
<0.1%
0
0.0%
LARGEST VALUES

99988487
1
<0.1%
0
0.0%
99925802
1
<0.1%
0
0.0%
99904583
1
<0.1%
0
0.0%
99858430
1
<0.1%
0
0.0%
99838228
1
<0.1%
0
0.0%
99760217
1
<0.1%
0
0.0%
99750182
1
<0.1%
0
0.0%
99674227
1
<0.1%
0
0.0%
99557081
1
<0.1%
0
0.0%
99556820
1
<0.1%
0
0.0%
99548229
1
<0.1%
0
0.0%
99524745
1
<0.1%
0
0.0%
99505932
1
<0.1%
0
0.0%
99496025
1
<0.1%
0
0.0%
99450184
1
<0.1%
0
0.0%
Gender
MISSING:
---
---
TOP CATEGORIES

F
1,396
51%
2,169
50%
M
1,353
49%
2,149
50%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Gender
PROVIDES INFORMATION ON...

Booking_channel
0.00
Discount_Rate
0.00
Use_Promotion
0.00
Income
0.00
Ethnicity
0.00
Reservation_Status
0.00
Educational_Level
0.00
Country_region
0.00
Hotel_Type
0.00
Adults
0.00
Children
0.00
Visted_Previously
0.00
Required_Car_Parking
0.00
Babies
0.00

THESE FEATURES
GIVE INFORMATION
ON Gender:

Discount_Rate
0.00
Booking_channel
0.00
Income
0.00
Ethnicity
0.00
Educational_Level
0.00
Use_Promotion
0.00
Country_region
0.00
Reservation_Status
0.00
Adults
0.00
Hotel_Type
0.00
Children
0.00
Meal_Type
0.00
Visted_Previously
0.00
Babies
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Gender
CORRELATION RATIO WITH...

Reservation-id
0.04
Room_Rate
0.02
Age
0.01
Age
MISSING:
---
---
>
NUMERICAL ASSOCIATIONS
(PEARSON, -1 to 1)

Room_Rate
0.04
Reservation-id
0.03

CATEGORICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)

Income
0.05
Ethnicity
0.04
Discount_Rate
0.04
Children
0.04
Adults
0.03
Hotel_Type
0.03
Booking_channel
0.03
Educational_Level
0.03
Country_region
0.03
Reservation_Status
0.02
Babies
0.02
Meal_Type
0.02
Deposit_type
0.02
Gender
0.01
MOST FREQUENT VALUES

30
63
2.3%
70
1.6%
60
60
2.2%
82
1.9%
27
60
2.2%
87
2.0%
26
60
2.2%
67
1.6%
31
59
2.1%
89
2.1%
48
58
2.1%
97
2.2%
53
57
2.1%
66
1.5%
50
57
2.1%
81
1.9%
43
56
2.0%
77
1.8%
40
56
2.0%
64
1.5%
55
55
2.0%
72
1.7%
68
55
2.0%
79
1.8%
57
55
2.0%
80
1.9%
37
55
2.0%
60
1.4%
46
55
2.0%
84
1.9%
SMALLEST VALUES

18
50
1.8%
83
1.9%
19
47
1.7%
86
2.0%
20
39
1.4%
91
2.1%
21
46
1.7%
88
2.0%
22
55
2.0%
78
1.8%
23
34
1.2%
74
1.7%
24
53
1.9%
91
2.1%
25
55
2.0%
78
1.8%
26
60
2.2%
67
1.6%
27
60
2.2%
87
2.0%
28
52
1.9%
92
2.1%
29
53
1.9%
63
1.5%
30
63
2.3%
70
1.6%
31
59
2.1%
89
2.1%
32
55
2.0%
86
2.0%
LARGEST VALUES

70
54
2.0%
79
1.8%
69
55
2.0%
87
2.0%
68
55
2.0%
79
1.8%
67
49
1.8%
80
1.9%
66
53
1.9%
80
1.9%
65
51
1.9%
90
2.1%
64
53
1.9%
70
1.6%
63
54
2.0%
82
1.9%
62
48
1.7%
67
1.6%
61
45
1.6%
81
1.9%
60
60
2.2%
82
1.9%
59
54
2.0%
72
1.7%
58
55
2.0%
67
1.6%
57
55
2.0%
80
1.9%
56
42
1.5%
82
1.9%
Ethnicity
MISSING:
---
---
TOP CATEGORIES

caucasian
697
25%
1,093
25%
African American
685
25%
1,020
24%
Latino
685
25%
1,091
25%
Asian American
682
25%
1,114
26%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Ethnicity
PROVIDES INFORMATION ON...

Discount_Rate
0.00
Adults
0.00
Babies
0.00
Country_region
0.00
Deposit_type
0.00
Required_Car_Parking
0.00
Children
0.00
Gender
0.00
Meal_Type
0.00
Income
0.00
Use_Promotion
0.00
Hotel_Type
0.00
Educational_Level
0.00
Visted_Previously
0.00

THESE FEATURES
GIVE INFORMATION
ON Ethnicity:

Discount_Rate
0.00
Adults
0.00
Country_region
0.00
Children
0.00
Babies
0.00
Income
0.00
Deposit_type
0.00
Meal_Type
0.00
Hotel_Type
0.00
Educational_Level
0.00
Required_Car_Parking
0.00
Gender
0.00
Use_Promotion
0.00
Reservation_Status
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Ethnicity
CORRELATION RATIO WITH...

Room_Rate
0.05
Age
0.04
Reservation-id
0.03
Educational_Level
MISSING:
---
---
TOP CATEGORIES

College
1,124
41%
1,705
39%
Mid-School
553
20%
905
21%
Grad
540
20%
805
19%
High-School
532
19%
903
21%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Educational_Level
PROVIDES INFORMATION ON...

Previous_Cancellations
0.00
Discount_Rate
0.00
Income
0.00
Use_Promotion
0.00
Reservation_Status
0.00
Deposit_type
0.00
Children
0.00
Visted_Previously
0.00
Gender
0.00
Adults
0.00
Hotel_Type
0.00
Country_region
0.00
Meal_Type
0.00
Babies
0.00

THESE FEATURES
GIVE INFORMATION
ON Educational_Level:

Discount_Rate
0.00
Income
0.00
Reservation_Status
0.00
Children
0.00
Adults
0.00
Use_Promotion
0.00
Previous_Cancellations
0.00
Deposit_type
0.00
Country_region
0.00
Hotel_Type
0.00
Meal_Type
0.00
Ethnicity
0.00
Visted_Previously
0.00
Gender
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Educational_Level
CORRELATION RATIO WITH...

Room_Rate
0.03
Age
0.03
Reservation-id
0.01
Income
MISSING:
---
---
TOP CATEGORIES

50K -- 100K
786
29%
1,214
28%
<25K
785
29%
1,228
28%
25K --50K
778
28%
1,244
29%
>100K
400
15%
632
15%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Income
PROVIDES INFORMATION ON...

Reservation_Status
0.00
Educational_Level
0.00
Country_region
0.00
Required_Car_Parking
0.00
Previous_Cancellations
0.00
Use_Promotion
0.00
Gender
0.00
Discount_Rate
0.00
Adults
0.00
Babies
0.00
Ethnicity
0.00
Hotel_Type
0.00
Meal_Type
0.00
Deposit_type
0.00

THESE FEATURES
GIVE INFORMATION
ON Income:

Reservation_Status
0.00
Educational_Level
0.00
Country_region
0.00
Discount_Rate
0.00
Adults
0.00
Required_Car_Parking
0.00
Ethnicity
0.00
Gender
0.00
Hotel_Type
0.00
Use_Promotion
0.00
Meal_Type
0.00
Babies
0.00
Previous_Cancellations
0.00
Children
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Income
CORRELATION RATIO WITH...

Age
0.05
Reservation-id
0.04
Room_Rate
0.03
Country_region
MISSING:
---
---
TOP CATEGORIES

South
1,093
40%
1,722
40%
East
563
20%
881
20%
North
560
20%
869
20%
West
533
19%
846
20%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Country_region
PROVIDES INFORMATION ON...

Discount_Rate
0.00
Income
0.00
Hotel_Type
0.00
Ethnicity
0.00
Babies
0.00
Adults
0.00
Meal_Type
0.00
Previous_Cancellations
0.00
Reservation_Status
0.00
Educational_Level
0.00
Gender
0.00
Booking_channel
0.00
Children
0.00
Deposit_type
0.00

THESE FEATURES
GIVE INFORMATION
ON Country_region:

Discount_Rate
0.00
Income
0.00
Ethnicity
0.00
Hotel_Type
0.00
Adults
0.00
Meal_Type
0.00
Babies
0.00
Educational_Level
0.00
Reservation_Status
0.00
Booking_channel
0.00
Children
0.00
Gender
0.00
Deposit_type
0.00
Previous_Cancellations
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Country_region
CORRELATION RATIO WITH...

Room_Rate
0.05
Reservation-id
0.05
Age
0.03
Hotel_Type
MISSING:
---
---
TOP CATEGORIES

Airport Hotels
976
36%
1,466
34%
City Hotel
901
33%
1,394
32%
Resort
872
32%
1,458
34%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Hotel_Type
PROVIDES INFORMATION ON...

Previous_Cancellations
0.00
Visted_Previously
0.00
Babies
0.00
Country_region
0.00
Educational_Level
0.00
Income
0.00
Ethnicity
0.00
Use_Promotion
0.00
Discount_Rate
0.00
Required_Car_Parking
0.00
Booking_channel
0.00
Adults
0.00
Children
0.00
Gender
0.00

THESE FEATURES
GIVE INFORMATION
ON Hotel_Type:

Country_region
0.00
Babies
0.00
Visted_Previously
0.00
Discount_Rate
0.00
Previous_Cancellations
0.00
Educational_Level
0.00
Income
0.00
Ethnicity
0.00
Adults
0.00
Booking_channel
0.00
Children
0.00
Required_Car_Parking
0.00
Use_Promotion
0.00
Gender
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Hotel_Type
CORRELATION RATIO WITH...

Age
0.03
Room_Rate
0.03
Reservation-id
0.03
Expected_checkin
MISSING:
---
---
86
3%
-
-
10/6/2016
71
3%
-
-
10/20/2016
69
3%
-
-
10/11/2016
65
2%
-
-
10/12/2016
62
2%
-
-
11/12/2016
56
2%
-
-
9/15/2016
56
2%
-
-
10/24/2016
56
2%
-
-
10/10/2016
56
2%
-
-
10/30/2016
54
2%
-
-
10/27/2016
51
2%
-
-
11/5/2016
51
2%
-
-
10/29/2016
49
2%
-
-
11/6/2016
47
2%
-
-
11/16/2016
46
2%
-
-
10/9/2016
45
2%
-
-
11/4/2016
43
2%
-
-
9/19/2016
43
2%
-
-
10/23/2016
42
2%
-
-
9/5/2016
40
1%
-
-
11/2/2016
38
1%
-
-
10/19/2016
37
1%
-
-
10/28/2016
37
1%
-
-
10/5/2016
37
1%
-
-
9/18/2016
37
1%
-
-
9/21/2016
37
1%
-
-
10/17/2016
37
1%
-
-
9/3/2016
36
1%
-
-
11/13/2016
36
1%
-
-
10/31/2016
36
1%
-
-
9/2/2016
35
1%
-
-
9/14/2016
35
1%
-
-
11/1/2016
35
1%
-
-
11/17/2016
35
1%
-
-
11/9/2016
35
1%
-
-
9/26/2016
34
1%
-
-
11/7/2016
34
1%
-
-
10/3/2016
34
1%
-
-
9/11/2016
32
1%
-
-
11/15/2016
32
1%
-
-
10/26/2016
32
1%
-
-
10/2/2016
31
1%
-
-
9/27/2016
31
1%
-
-
11/8/2016
31
1%
-
-
9/29/2016
31
1%
-
-
9/12/2016
30
1%
-
-
9/10/2016
28
1%
-
-
10/8/2016
27
<1%
-
-
11/3/2016
27
<1%
-
-
9/20/2016
27
<1%
-
-
9/13/2016
27
<1%
-
-
10/25/2016
26
<1%
-
-
10/21/2016
25
<1%
-
-
11/14/2016
25
<1%
-
-
9/30/2016
25
<1%
-
-
11/10/2016
25
<1%
-
-
9/23/2016
24
<1%
-
-
11/11/2016
24
<1%
-
-
9/1/2016
23
<1%
-
-
10/18/2016
23
<1%
-
-
9/25/2016
410
15%
4,318
100%
(Other)
Expected_checkout
MISSING:
---
---
67
2%
-
-
10/13/2016
66
2%
-
-
10/7/2016
55
2%
-
-
10/12/2016
53
2%
-
-
10/31/2016
50
2%
-
-
11/1/2016
50
2%
-
-
10/21/2016
49
2%
-
-
10/24/2016
48
2%
-
-
11/7/2016
47
2%
-
-
11/2/2016
47
2%
-
-
10/11/2016
46
2%
-
-
10/25/2016
46
2%
-
-
10/10/2016
44
2%
-
-
11/6/2016
43
2%
-
-
10/28/2016
42
2%
-
-
11/8/2016
42
2%
-
-
11/14/2016
41
1%
-
-
10/30/2016
40
1%
-
-
10/22/2016
40
1%
-
-
10/29/2016
39
1%
-
-
11/15/2016
39
1%
-
-
11/17/2016
39
1%
-
-
9/16/2016
39
1%
-
-
9/22/2016
38
1%
-
-
11/5/2016
38
1%
-
-
11/9/2016
38
1%
-
-
11/13/2016
38
1%
-
-
9/28/2016
37
1%
-
-
9/17/2016
37
1%
-
-
11/3/2016
36
1%
-
-
9/15/2016
36
1%
-
-
9/6/2016
35
1%
-
-
11/16/2016
35
1%
-
-
10/14/2016
34
1%
-
-
9/30/2016
34
1%
-
-
9/4/2016
34
1%
-
-
11/10/2016
34
1%
-
-
10/18/2016
33
1%
-
-
11/4/2016
33
1%
-
-
10/4/2016
33
1%
-
-
10/8/2016
33
1%
-
-
10/26/2016
33
1%
-
-
9/14/2016
32
1%
-
-
10/9/2016
32
1%
-
-
9/20/2016
32
1%
-
-
9/23/2016
31
1%
-
-
9/13/2016
31
1%
-
-
10/27/2016
31
1%
-
-
9/21/2016
30
1%
-
-
9/19/2016
30
1%
-
-
10/6/2016
29
1%
-
-
10/15/2016
29
1%
-
-
11/18/2016
29
1%
-
-
10/20/2016
28
1%
-
-
9/12/2016
27
<1%
-
-
9/3/2016
27
<1%
11
<1%
11/19/2016
26
<1%
-
-
10/23/2016
26
<1%
-
-
10/1/2016
26
<1%
-
-
11/12/2016
26
<1%
-
-
9/7/2016
486
18%
4,307
>99%
(Other)
Booking_date
MISSING:
---
---
23
<1%
7
<1%
6/1/2016
21
<1%
4
<1%
4/14/2016
21
<1%
14
<1%
7/8/2016
20
<1%
16
<1%
7/19/2016
19
<1%
17
<1%
8/17/2016
19
<1%
7
<1%
4/29/2016
19
<1%
1
<1%
4/19/2016
18
<1%
16
<1%
8/15/2016
18
<1%
20
<1%
9/11/2016
18
<1%
23
<1%
9/3/2016
18
<1%
-
-
4/16/2016
18
<1%
22
<1%
7/28/2016
18
<1%
-
-
4/11/2016
17
<1%
11
<1%
7/9/2016
17
<1%
22
<1%
8/27/2016
17
<1%
18
<1%
8/18/2016
17
<1%
10
<1%
6/11/2016
17
<1%
25
<1%
8/7/2016
17
<1%
5
<1%
5/12/2016
16
<1%
18
<1%
8/8/2016
16
<1%
10
<1%
7/4/2016
16
<1%
3
<1%
5/27/2016
16
<1%
6
<1%
6/12/2016
16
<1%
18
<1%
8/10/2016
16
<1%
25
<1%
9/13/2016
16
<1%
16
<1%
9/20/2016
16
<1%
2
<1%
5/13/2016
16
<1%
10
<1%
7/20/2016
16
<1%
4
<1%
4/30/2016
16
<1%
4
<1%
6/22/2016
16
<1%
18
<1%
9/5/2016
16
<1%
6
<1%
5/8/2016
15
<1%
4
<1%
5/30/2016
15
<1%
9
<1%
6/14/2016
15
<1%
18
<1%
9/9/2016
14
<1%
15
<1%
7/18/2016
14
<1%
9
<1%
6/21/2016
14
<1%
3
<1%
5/21/2016
14
<1%
15
<1%
9/7/2016
14
<1%
-
-
4/5/2016
14
<1%
8
<1%
5/25/2016
14
<1%
5
<1%
5/18/2016
14
<1%
25
<1%
8/30/2016
14
<1%
13
<1%
7/25/2016
14
<1%
1
<1%
4/18/2016
14
<1%
21
<1%
8/25/2016
13
<1%
4
<1%
5/19/2016
13
<1%
4
<1%
5/26/2016
13
<1%
27
<1%
8/6/2016
13
<1%
17
<1%
8/16/2016
13
<1%
4
<1%
5/23/2016
13
<1%
21
<1%
7/13/2016
13
<1%
21
<1%
9/4/2016
13
<1%
-
-
4/1/2016
13
<1%
24
<1%
8/1/2016
13
<1%
12
<1%
6/9/2016
13
<1%
3
<1%
6/4/2016
13
<1%
-
-
4/26/2016
13
<1%
17
<1%
7/21/2016
13
<1%
18
<1%
8/19/2016
1,808
66%
3,622
84%
(Other)
Adults
MISSING:
---
---
TOP CATEGORIES

2
1,124
41%
1,759
41%
1
699
25%
1,050
24%
3
454
17%
742
17%
4
245
9%
396
9%
5
227
8%
371
9%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Adults
PROVIDES INFORMATION ON...

Booking_channel
0.00
Use_Promotion
0.00
Discount_Rate
0.00
Ethnicity
0.00
Meal_Type
0.00
Children
0.00
Required_Car_Parking
0.00
Country_region
0.00
Babies
0.00
Deposit_type
0.00
Visted_Previously
0.00
Income
0.00
Educational_Level
0.00
Reservation_Status
0.00

THESE FEATURES
GIVE INFORMATION
ON Adults:

Discount_Rate
0.00
Booking_channel
0.00
Ethnicity
0.00
Meal_Type
0.00
Use_Promotion
0.00
Children
0.00
Country_region
0.00
Income
0.00
Educational_Level
0.00
Required_Car_Parking
0.00
Deposit_type
0.00
Babies
0.00
Reservation_Status
0.00
Hotel_Type
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Adults
CORRELATION RATIO WITH...

Room_Rate
0.05
Reservation-id
0.03
Age
0.03
Children
MISSING:
---
---
TOP CATEGORIES

1
1,171
43%
1,863
43%
2
1,120
41%
1,757
41%
3
458
17%
698
16%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Children
PROVIDES INFORMATION ON...

Deposit_type
0.00
Required_Car_Parking
0.00
Babies
0.00
Adults
0.00
Discount_Rate
0.00
Educational_Level
0.00
Ethnicity
0.00
Booking_channel
0.00
Use_Promotion
0.00
Meal_Type
0.00
Income
0.00
Country_region
0.00
Hotel_Type
0.00
Reservation_Status
0.00

THESE FEATURES
GIVE INFORMATION
ON Children:

Discount_Rate
0.00
Adults
0.00
Deposit_type
0.00
Babies
0.00
Educational_Level
0.00
Ethnicity
0.00
Required_Car_Parking
0.00
Booking_channel
0.00
Income
0.00
Country_region
0.00
Meal_Type
0.00
Hotel_Type
0.00
Use_Promotion
0.00
Reservation_Status
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Children
CORRELATION RATIO WITH...

Age
0.04
Reservation-id
0.03
Room_Rate
0.01
Babies
MISSING:
---
---
TOP CATEGORIES

0
1,967
72%
3,029
70%
1
646
23%
1,085
25%
2
136
5%
204
5%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Babies
PROVIDES INFORMATION ON...

Discount_Rate
0.00
Deposit_type
0.00
Children
0.00
Reservation_Status
0.00
Hotel_Type
0.00
Ethnicity
0.00
Country_region
0.00
Adults
0.00
Income
0.00
Educational_Level
0.00
Booking_channel
0.00
Meal_Type
0.00
Previous_Cancellations
0.00
Use_Promotion
0.00

THESE FEATURES
GIVE INFORMATION
ON Babies:

Discount_Rate
0.00
Children
0.00
Ethnicity
0.00
Hotel_Type
0.00
Reservation_Status
0.00
Deposit_type
0.00
Country_region
0.00
Adults
0.00
Income
0.00
Educational_Level
0.00
Booking_channel
0.00
Meal_Type
0.00
Use_Promotion
0.00
Visted_Previously
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Babies
CORRELATION RATIO WITH...

Reservation-id
0.04
Age
0.02
Room_Rate
0.01
Meal_Type
MISSING:
---
---
TOP CATEGORIES

FB
937
34%
1,461
34%
BB
922
34%
1,416
33%
HB
890
32%
1,441
33%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Meal_Type
PROVIDES INFORMATION ON...

Adults
0.00
Reservation_Status
0.00
Country_region
0.00
Use_Promotion
0.00
Booking_channel
0.00
Discount_Rate
0.00
Ethnicity
0.00
Educational_Level
0.00
Income
0.00
Previous_Cancellations
0.00
Children
0.00
Required_Car_Parking
0.00
Babies
0.00
Visted_Previously
0.00

THESE FEATURES
GIVE INFORMATION
ON Meal_Type:

Adults
0.00
Discount_Rate
0.00
Country_region
0.00
Reservation_Status
0.00
Ethnicity
0.00
Income
0.00
Educational_Level
0.00
Booking_channel
0.00
Children
0.00
Use_Promotion
0.00
Required_Car_Parking
0.00
Babies
0.00
Visted_Previously
0.00
Previous_Cancellations
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Meal_Type
CORRELATION RATIO WITH...

Reservation-id
0.03
Room_Rate
0.03
Age
0.02
Visted_Previously
MISSING:
---
---
TOP CATEGORIES

No
1,791
65%
2,867
66%
Yes
958
35%
1,451
34%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Visted_Previously
PROVIDES INFORMATION ON...

Previous_Cancellations
0.39
Hotel_Type
0.00
Educational_Level
0.00
Reservation_Status
0.00
Adults
0.00
Booking_channel
0.00
Discount_Rate
0.00
Required_Car_Parking
0.00
Ethnicity
0.00
Meal_Type
0.00
Country_region
0.00
Gender
0.00
Babies
0.00
Income
0.00

THESE FEATURES
GIVE INFORMATION
ON Visted_Previously:

Previous_Cancellations
0.22
Hotel_Type
0.00
Educational_Level
0.00
Discount_Rate
0.00
Adults
0.00
Reservation_Status
0.00
Booking_channel
0.00
Ethnicity
0.00
Meal_Type
0.00
Country_region
0.00
Required_Car_Parking
0.00
Income
0.00
Children
0.00
Gender
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Visted_Previously
CORRELATION RATIO WITH...

Room_Rate
0.03
Reservation-id
0.01
Age
0.00
Previous_Cancellations
MISSING:
---
---
TOP CATEGORIES

No
2,421
88%
3,872
90%
Yes
328
12%
446
10%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Previous_Cancellations
PROVIDES INFORMATION ON...

Visted_Previously
0.22
Reservation_Status
0.00
Educational_Level
0.00
Hotel_Type
0.00
Required_Car_Parking
0.00
Discount_Rate
0.00
Income
0.00
Country_region
0.00
Deposit_type
0.00
Booking_channel
0.00
Meal_Type
0.00
Use_Promotion
0.00
Children
0.00
Adults
0.00

THESE FEATURES
GIVE INFORMATION
ON Previous_Cancellations:

Visted_Previously
0.39
Educational_Level
0.00
Discount_Rate
0.00
Reservation_Status
0.00
Hotel_Type
0.00
Income
0.00
Country_region
0.00
Required_Car_Parking
0.00
Meal_Type
0.00
Booking_channel
0.00
Deposit_type
0.00
Adults
0.00
Children
0.00
Ethnicity
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Previous_Cancellations
CORRELATION RATIO WITH...

Reservation-id
0.02
Room_Rate
0.01
Age
0.00
Deposit_type
MISSING:
---
---
TOP CATEGORIES

No Deposit
1,843
67%
2,872
67%
Refundable
687
25%
1,073
25%
Non-Refundable
219
8%
373
9%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Deposit_type
PROVIDES INFORMATION ON...

Children
0.00
Babies
0.00
Discount_Rate
0.00
Booking_channel
0.00
Educational_Level
0.00
Ethnicity
0.00
Adults
0.00
Use_Promotion
0.00
Reservation_Status
0.00
Previous_Cancellations
0.00
Income
0.00
Country_region
0.00
Hotel_Type
0.00
Meal_Type
0.00

THESE FEATURES
GIVE INFORMATION
ON Deposit_type:

Discount_Rate
0.00
Children
0.00
Educational_Level
0.00
Babies
0.00
Booking_channel
0.00
Ethnicity
0.00
Adults
0.00
Income
0.00
Reservation_Status
0.00
Country_region
0.00
Use_Promotion
0.00
Hotel_Type
0.00
Previous_Cancellations
0.00
Meal_Type
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Deposit_type
CORRELATION RATIO WITH...

Reservation-id
0.02
Room_Rate
0.02
Age
0.02
Booking_channel
MISSING:
---
---
TOP CATEGORIES

Online
1,569
57%
2,481
57%
Direct
784
29%
1,215
28%
Agent
396
14%
622
14%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Booking_channel
PROVIDES INFORMATION ON...

Adults
0.00
Gender
0.00
Deposit_type
0.00
Discount_Rate
0.00
Children
0.00
Required_Car_Parking
0.00
Meal_Type
0.00
Visted_Previously
0.00
Previous_Cancellations
0.00
Country_region
0.00
Hotel_Type
0.00
Babies
0.00
Use_Promotion
0.00
Educational_Level
0.00

THESE FEATURES
GIVE INFORMATION
ON Booking_channel:

Adults
0.00
Discount_Rate
0.00
Deposit_type
0.00
Gender
0.00
Children
0.00
Meal_Type
0.00
Country_region
0.00
Educational_Level
0.00
Hotel_Type
0.00
Required_Car_Parking
0.00
Ethnicity
0.00
Visted_Previously
0.00
Babies
0.00
Use_Promotion
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Booking_channel
CORRELATION RATIO WITH...

Age
0.03
Reservation-id
0.03
Room_Rate
0.02
Required_Car_Parking
MISSING:
---
---
TOP CATEGORIES

Yes
1,959
71%
3,113
72%
No
790
29%
1,205
28%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Required_Car_Parking
PROVIDES INFORMATION ON...

Children
0.00
Previous_Cancellations
0.00
Income
0.00
Discount_Rate
0.00
Adults
0.00
Ethnicity
0.00
Booking_channel
0.00
Reservation_Status
0.00
Hotel_Type
0.00
Meal_Type
0.00
Visted_Previously
0.00
Deposit_type
0.00
Educational_Level
0.00
Gender
0.00

THESE FEATURES
GIVE INFORMATION
ON Required_Car_Parking:

Discount_Rate
0.00
Children
0.00
Income
0.00
Adults
0.00
Ethnicity
0.00
Booking_channel
0.00
Reservation_Status
0.00
Previous_Cancellations
0.00
Hotel_Type
0.00
Meal_Type
0.00
Visted_Previously
0.00
Educational_Level
0.00
Deposit_type
0.00
Gender
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Required_Car_Parking
CORRELATION RATIO WITH...

Reservation-id
0.03
Age
0.00
Room_Rate
0.00
Reservation_Status
MISSING:
---
TOP CATEGORIES

Check-In
1,610
59%
Canceled
741
27%
No-Show
398
14%
ALL
2,749
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Reservation_Status
PROVIDES INFORMATION ON...

Income
0.00
Previous_Cancellations
0.00
Babies
0.00
Educational_Level
0.00
Discount_Rate
0.00
Meal_Type
0.00
Visted_Previously
0.00
Gender
0.00
Country_region
0.00
Required_Car_Parking
0.00
Deposit_type
0.00
Adults
0.00
Use_Promotion
0.00
Children
0.00

THESE FEATURES
GIVE INFORMATION
ON Reservation_Status:

Income
0.00
Discount_Rate
0.00
Educational_Level
0.00
Babies
0.00
Meal_Type
0.00
Country_region
0.00
Previous_Cancellations
0.00
Adults
0.00
Deposit_type
0.00
Gender
0.00
Visted_Previously
0.00
Ethnicity
0.00
Required_Car_Parking
0.00
Children
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Reservation_Status
CORRELATION RATIO WITH...

Room_Rate
0.03
Age
0.02
Reservation-id
0.01
Use_Promotion
MISSING:
---
---
TOP CATEGORIES

Yes
2,085
76%
3,241
75%
No
664
24%
1,077
25%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Use_Promotion
PROVIDES INFORMATION ON...

Discount_Rate
0.29
Adults
0.00
Educational_Level
0.00
Gender
0.00
Income
0.00
Deposit_type
0.00
Meal_Type
0.00
Children
0.00
Ethnicity
0.00
Reservation_Status
0.00
Hotel_Type
0.00
Booking_channel
0.00
Previous_Cancellations
0.00
Country_region
0.00

THESE FEATURES
GIVE INFORMATION
ON Use_Promotion:

Discount_Rate
1.00
Adults
0.00
Educational_Level
0.00
Income
0.00
Gender
0.00
Ethnicity
0.00
Meal_Type
0.00
Children
0.00
Deposit_type
0.00
Hotel_Type
0.00
Reservation_Status
0.00
Country_region
0.00
Booking_channel
0.00
Previous_Cancellations
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Use_Promotion
CORRELATION RATIO WITH...

Room_Rate
0.00
Reservation-id
0.00
Age
0.00
Discount_Rate
MISSING:
---
---
TOP CATEGORIES

0
664
24%
1,077
25%
10
564
21%
884
20%
5
438
16%
669
15%
20
410
15%
650
15%
25
269
10%
398
9%
30
147
5%
217
5%
40
132
5%
225
5%
15
125
5%
198
5%
ALL
2,749
100%
4,318
100%
CATEGORICAL ASSOCIATIONS
(UNCERTAINTY COEFFICIENT, 0 to 1)
Discount_Rate
PROVIDES INFORMATION ON...

Use_Promotion
1.00
Adults
0.00
Educational_Level
0.00
Babies
0.00
Country_region
0.00
Ethnicity
0.00
Deposit_type
0.00
Gender
0.00
Previous_Cancellations
0.00
Required_Car_Parking
0.00
Children
0.00
Reservation_Status
0.00
Booking_channel
0.00
Income
0.00

THESE FEATURES
GIVE INFORMATION
ON Discount_Rate:

Use_Promotion
0.29
Adults
0.00
Educational_Level
0.00
Country_region
0.00
Ethnicity
0.00
Babies
0.00
Children
0.00
Income
0.00
Deposit_type
0.00
Reservation_Status
0.00
Gender
0.00
Booking_channel
0.00
Required_Car_Parking
0.00
Meal_Type
0.00

NUMERICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)
Discount_Rate
CORRELATION RATIO WITH...

Room_Rate
0.08
Reservation-id
0.06
Age
0.04
Room_Rate
MISSING:
---
---
>
NUMERICAL ASSOCIATIONS
(PEARSON, -1 to 1)

Age
0.04
Reservation-id
-0.03

CATEGORICAL ASSOCIATIONS
(CORRELATION RATIO, 0 to 1)

Discount_Rate
0.08
Ethnicity
0.05
Adults
0.05
Country_region
0.05
Visted_Previously
0.03
Reservation_Status
0.03
Educational_Level
0.03
Meal_Type
0.03
Hotel_Type
0.03
Income
0.03
Deposit_type
0.02
Booking_channel
0.02
Gender
0.02
Children
0.01
MOST FREQUENT VALUES

109
31
1.1%
20
0.5%
184
31
1.1%
29
0.7%
162
28
1.0%
34
0.8%
138
27
1.0%
40
0.9%
141
27
1.0%
27
0.6%
127
26
0.9%
32
0.7%
140
26
0.9%
37
0.9%
205
26
0.9%
30
0.7%
224
26
0.9%
22
0.5%
208
25
0.9%
31
0.7%
158
25
0.9%
34
0.8%
128
25
0.9%
25
0.6%
231
25
0.9%
23
0.5%
108
25
0.9%
23
0.5%
104
25
0.9%
31
0.7%
SMALLEST VALUES

100
17
0.6%
31
0.7%
101
19
0.7%
30
0.7%
102
14
0.5%
25
0.6%
103
23
0.8%
19
0.4%
104
25
0.9%
31
0.7%
105
19
0.7%
18
0.4%
106
22
0.8%
24
0.6%
107
22
0.8%
19
0.4%
108
25
0.9%
23
0.5%
109
31
1.1%
20
0.5%
110
11
0.4%
30
0.7%
111
16
0.6%
41
0.9%
112
24
0.9%
29
0.7%
113
18
0.7%
21
0.5%
114
19
0.7%
21
0.5%
LARGEST VALUES

250
23
0.8%
22
0.5%
249
11
0.4%
22
0.5%
248
14
0.5%
29
0.7%
247
17
0.6%
27
0.6%
246
17
0.6%
29
0.7%
245
18
0.7%
26
0.6%
244
18
0.7%
26
0.6%
243
20
0.7%
26
0.6%
242
21
0.8%
27
0.6%
241
17
0.6%
24
0.6%
240
17
0.6%
32
0.7%
239
15
0.5%
30
0.7%
238
17
0.6%
30
0.7%
237
19
0.7%
31
0.7%
236
14
0.5%
33
0.8%