# Overview

Brought to you by YData

Dataset statistics

Number of variables | 9
Number of observations | 854
Missing cells | 195
Missing cells (%) | 2.5%
Duplicate rows | 0
Duplicate rows (%) | 0.0%
Total size in memory | 60.2 KiB
Average record size in memory | 72.1 B

Variable types

Text | 1
Categorical | 4
Boolean | 1
Numeric | 3

Alerts

`AC_ID` is highly overall correlated with `ROOM_ID` | High correlation
`ROOM_ID` is highly overall correlated with `AC_ID` | High correlation
`is_room_fully_sealed` is highly imbalanced (66.1%) | Imbalance
`is_the_AC_inverter_or_not` has 195 (22.8%) missing values | Missing
`BTU_of_the_AC` has 23 (2.7%) zeros | Zeros
`no_of_hours_bulbs_was_on_during_daytime_last_week` has 692 (81.0%) zeros | Zeros
`no_of_hours_bulbs_was_on_during_night_last_week` has 362 (42.4%) zeros | Zeros

Reproduction

Analysis started | 2025-02-27 04:40:36.945400
Analysis finished | 2025-02-27 04:40:38.200935
Duration | 1.26 second
Software version | ydata-profiling vv4.11.0
Download configuration | config.json

# Variables

household_ID
Text

Distinct | 418
Distinct (%) | 48.9%
Missing | 0
Missing (%) | 0.0%
Memory size | 6.8 KiB

Length

Max length | 6
Median length | 6
Mean length | 6
Min length | 6

Characters and Unicode

Total characters | 5124
Distinct characters | 12
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 234 ?
Unique (%) | 27.4%

Sample

1st row | ID0528
2nd row | ID0041
3rd row | ID0039
4th row | ID0072
5th row | ID1251

Value | Count | Frequency (%)
id0282 | 26 | 3.0%
id1816 | 24 | 2.8%
id2985 | 18 | 2.1%
id0278 | 11 | 1.3%
id2969 | 10 | 1.2%
id1165 | 8 | 0.9%
id0069 | 8 | 0.9%
id0417 | 8 | 0.9%
id0841 | 8 | 0.9%
id2660 | 8 | 0.9%
Other values (408) | 725 | 84.9%

#### Most occurring characters

Value | Count | Frequency (%)
I | 854 | 16.7%
D | 854 | 16.7%
2 | 524 | 10.2%
0 | 474 | 9.3%
1 | 444 | 8.7%
3 | 436 | 8.5%
8 | 295 | 5.8%
6 | 286 | 5.6%
7 | 273 | 5.3%
4 | 243 | 4.7%
Other values (2) | 441 | 8.6%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 5124 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 854 | 16.7%
D | 854 | 16.7%
2 | 524 | 10.2%
0 | 474 | 9.3%
1 | 444 | 8.7%
3 | 436 | 8.5%
8 | 295 | 5.8%
6 | 286 | 5.6%
7 | 273 | 5.3%
4 | 243 | 4.7%
Other values (2) | 441 | 8.6%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 5124 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 854 | 16.7%
D | 854 | 16.7%
2 | 524 | 10.2%
0 | 474 | 9.3%
1 | 444 | 8.7%
3 | 436 | 8.5%
8 | 295 | 5.8%
6 | 286 | 5.6%
7 | 273 | 5.3%
4 | 243 | 4.7%
Other values (2) | 441 | 8.6%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 5124 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 854 | 16.7%
D | 854 | 16.7%
2 | 524 | 10.2%
0 | 474 | 9.3%
1 | 444 | 8.7%
3 | 436 | 8.5%
8 | 295 | 5.8%
6 | 286 | 5.6%
7 | 273 | 5.3%
4 | 243 | 4.7%
Other values (2) | 441 | 8.6%

ROOM_ID
Categorical

High correlation

Distinct | 18
Distinct (%) | 2.1%
Missing | 0
Missing (%) | 0.0%
Memory size | 6.8 KiB

I3 | 212
I2 | 195
I4 | 138
I5 | 102
I6 | 61
Other values (13) | 146

Length

Max length | 3
Median length | 2
Mean length | 2.0620609
Min length | 2

Characters and Unicode

Total characters | 1761
Distinct characters | 11
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 2 ?
Unique (%) | 0.2%

Sample

1st row | I2
2nd row | I13
3rd row | I11
4th row | I3
5th row | I4

#### Common Values

Value | Count | Frequency (%)
I3 | 212 | 24.8%
I2 | 195 | 22.8%
I4 | 138 | 16.2%
I5 | 102 | 11.9%
I6 | 61 | 7.1%
I1 | 37 | 4.3%
I7 | 25 | 2.9%
I8 | 18 | 2.1%
I10 | 15 | 1.8%
I9 | 13 | 1.5%
Other values (8) | 38 | 4.4%

#### Length

Histogram of lengths of the category

Value | Count | Frequency (%)
i3 | 212 | 24.8%
i2 | 195 | 22.8%
i4 | 138 | 16.2%
i5 | 102 | 11.9%
i6 | 61 | 7.1%
i1 | 37 | 4.3%
i7 | 25 | 2.9%
i8 | 18 | 2.1%
i10 | 15 | 1.8%
i9 | 13 | 1.5%
Other values (8) | 38 | 4.4%

#### Most occurring characters

Value | Count | Frequency (%)
I | 854 | 48.5%
3 | 221 | 12.5%
2 | 203 | 11.5%
4 | 141 | 8.0%
5 | 104 | 5.9%
1 | 101 | 5.7%
6 | 64 | 3.6%
7 | 25 | 1.4%
8 | 19 | 1.1%
0 | 16 | 0.9%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 1761 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 854 | 48.5%
3 | 221 | 12.5%
2 | 203 | 11.5%
4 | 141 | 8.0%
5 | 104 | 5.9%
1 | 101 | 5.7%
6 | 64 | 3.6%
7 | 25 | 1.4%
8 | 19 | 1.1%
0 | 16 | 0.9%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 1761 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 854 | 48.5%
3 | 221 | 12.5%
2 | 203 | 11.5%
4 | 141 | 8.0%
5 | 104 | 5.9%
1 | 101 | 5.7%
6 | 64 | 3.6%
7 | 25 | 1.4%
8 | 19 | 1.1%
0 | 16 | 0.9%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 1761 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 854 | 48.5%
3 | 221 | 12.5%
2 | 203 | 11.5%
4 | 141 | 8.0%
5 | 104 | 5.9%
1 | 101 | 5.7%
6 | 64 | 3.6%
7 | 25 | 1.4%
8 | 19 | 1.1%
0 | 16 | 0.9%

AC_ID
Categorical

High correlation

Distinct | 39
Distinct (%) | 4.6%
Missing | 0
Missing (%) | 0.0%
Memory size | 6.8 KiB

I3_AC1 | 207
I2_AC1 | 191
I4_AC1 | 134
I5_AC1 | 98
I6_AC1 | 57
Other values (34) | 167

Length

Max length | 7
Median length | 6
Mean length | 6.0620609
Min length | 6

Characters and Unicode

Total characters | 5177
Distinct characters | 14
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 13 ?
Unique (%) | 1.5%

Sample

1st row | I2_AC1
2nd row | I13_AC1
3rd row | I11_AC1
4th row | I3_AC1
5th row | I4_AC1

#### Common Values

Value | Count | Frequency (%)
I3_AC1 | 207 | 24.2%
I2_AC1 | 191 | 22.4%
I4_AC1 | 134 | 15.7%
I5_AC1 | 98 | 11.5%
I6_AC1 | 57 | 6.7%
I1_AC1 | 29 | 3.4%
I7_AC1 | 21 | 2.5%
I10_AC1 | 14 | 1.6%
I8_AC1 | 14 | 1.6%
I9_AC1 | 11 | 1.3%
Other values (29) | 78 | 9.1%

#### Length

Histogram of lengths of the category

Value | Count | Frequency (%)
i3_ac1 | 207 | 24.2%
i2_ac1 | 191 | 22.4%
i4_ac1 | 134 | 15.7%
i5_ac1 | 98 | 11.5%
i6_ac1 | 57 | 6.7%
i1_ac1 | 29 | 3.4%
i7_ac1 | 21 | 2.5%
i10_ac1 | 14 | 1.6%
i8_ac1 | 14 | 1.6%
i9_ac1 | 11 | 1.3%
Other values (29) | 78 | 9.1%

#### Most occurring characters

Value | Count | Frequency (%)
1 | 912 | 17.6%
I | 854 | 16.5%
A | 854 | 16.5%
_ | 854 | 16.5%
C | 854 | 16.5%
2 | 237 | 4.6%
3 | 230 | 4.4%
4 | 141 | 2.7%
5 | 104 | 2.0%
6 | 64 | 1.2%
Other values (4) | 73 | 1.4%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 5177 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
1 | 912 | 17.6%
I | 854 | 16.5%
A | 854 | 16.5%
_ | 854 | 16.5%
C | 854 | 16.5%
2 | 237 | 4.6%
3 | 230 | 4.4%
4 | 141 | 2.7%
5 | 104 | 2.0%
6 | 64 | 1.2%
Other values (4) | 73 | 1.4%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 5177 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
1 | 912 | 17.6%
I | 854 | 16.5%
A | 854 | 16.5%
_ | 854 | 16.5%
C | 854 | 16.5%
2 | 237 | 4.6%
3 | 230 | 4.4%
4 | 141 | 2.7%
5 | 104 | 2.0%
6 | 64 | 1.2%
Other values (4) | 73 | 1.4%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 5177 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
1 | 912 | 17.6%
I | 854 | 16.5%
A | 854 | 16.5%
_ | 854 | 16.5%
C | 854 | 16.5%
2 | 237 | 4.6%
3 | 230 | 4.4%
4 | 141 | 2.7%
5 | 104 | 2.0%
6 | 64 | 1.2%
Other values (4) | 73 | 1.4%

type_of_the_AC
Categorical

Distinct | 6
Distinct (%) | 0.7%
Missing | 0
Missing (%) | 0.0%
Memory size | 6.8 KiB

Individual AC with two components | 490
Central AC (Only to your Household) | 176
Individual AC with one component | 169
Air Cooler | 8
Central AC (For the whole building | 7

Length

Max length | 35
Median length | 33
Mean length | 32.875878
Min length | 5

Characters and Unicode

Total characters | 28076
Distinct characters | 29
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 0 ?
Unique (%) | 0.0%

Sample

1st row | Individual AC with two components
2nd row | Individual AC with two components
3rd row | Individual AC with two components
4th row | Central AC (Only to your Household)
5th row | Central AC (For the whole building

#### Common Values

Value | Count | Frequency (%)
Individual AC with two components | 490 | 57.4%
Central AC (Only to your Household) | 176 | 20.6%
Individual AC with one component | 169 | 19.8%
Air Cooler | 8 | 0.9%
Central AC (For the whole building | 7 | 0.8%
Other | 4 | 0.5%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
ac | 842 | 19.1%
individual | 659 | 14.9%
with | 659 | 14.9%
two | 490 | 11.1%
components | 490 | 11.1%
central | 183 | 4.1%
only | 176 | 4.0%
to | 176 | 4.0%
your | 176 | 4.0%
household | 176 | 4.0%
Other values (9) | 386 | 8.7%

#### Most occurring characters

Value | Count | Frequency (%)
| 3559 | 12.7%
o | 2711 | 9.7%
n | 2512 | 8.9%
t | 2178 | 7.8%
i | 1999 | 7.1%
d | 1501 | 5.3%
l | 1216 | 4.3%
e | 1213 | 4.3%
w | 1156 | 4.1%
C | 1033 | 3.7%
Other values (19) | 8998 | 32.0%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 28076 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 3559 | 12.7%
o | 2711 | 9.7%
n | 2512 | 8.9%
t | 2178 | 7.8%
i | 1999 | 7.1%
d | 1501 | 5.3%
l | 1216 | 4.3%
e | 1213 | 4.3%
w | 1156 | 4.1%
C | 1033 | 3.7%
Other values (19) | 8998 | 32.0%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 28076 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 3559 | 12.7%
o | 2711 | 9.7%
n | 2512 | 8.9%
t | 2178 | 7.8%
i | 1999 | 7.1%
d | 1501 | 5.3%
l | 1216 | 4.3%
e | 1213 | 4.3%
w | 1156 | 4.1%
C | 1033 | 3.7%
Other values (19) | 8998 | 32.0%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 28076 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 3559 | 12.7%
o | 2711 | 9.7%
n | 2512 | 8.9%
t | 2178 | 7.8%
i | 1999 | 7.1%
d | 1501 | 5.3%
l | 1216 | 4.3%
e | 1213 | 4.3%
w | 1156 | 4.1%
C | 1033 | 3.7%
Other values (19) | 8998 | 32.0%

is_the_AC_inverter_or_not
Boolean

Missing

Distinct | 2
Distinct (%) | 0.3%
Missing | 195
Missing (%) | 22.8%
Memory size | 1.8 KiB

True | 513
False | 146
(Missing) | 195

Value | Count | Frequency (%)
True | 513 | 60.1%
False | 146 | 17.1%
(Missing) | 195 | 22.8%

is_room_fully_sealed
Categorical

Imbalance

Distinct | 3
Distinct (%) | 0.4%
Missing | 0
Missing (%) | 0.0%
Memory size | 6.8 KiB

The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 767
The room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through | 74
The room is not fully closed. There are spaces where the cool air can leak out | 13

Length

Max length | 118
Median length | 117
Mean length | 116.49297
Min length | 78

Characters and Unicode

Total characters | 99485
Distinct characters | 30
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 0 ?
Unique (%) | 0.0%

Sample

1st row | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe
2nd row | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe
3rd row | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe
4th row | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe
5th row | The room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through

#### Common Values

Value | Count | Frequency (%)
The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 767 | 89.8%
The room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through | 74 | 8.7%
The room is not fully closed. There are spaces where the cool air can leak out | 13 | 1.5%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
the | 2549 | 12.5%
and | 1534 | 7.5%
is | 1002 | 4.9%
fully | 928 | 4.6%
closed | 854 | 4.2%
cool | 854 | 4.2%
room | 854 | 4.2%
air | 854 | 4.2%
when | 841 | 4.1%
ac | 841 | 4.1%
Other values (21) | 9207 | 45.3%

#### Most occurring characters

Value | Count | Frequency (%)
| 19464 | 19.6%
e | 12597 | 12.7%
o | 8501 | 8.5%
n | 7151 | 7.2%
d | 5530 | 5.6%
a | 4963 | 5.0%
l | 4492 | 4.5%
h | 4405 | 4.4%
r | 4344 | 4.4%
s | 4257 | 4.3%
Other values (20) | 23781 | 23.9%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 99485 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 19464 | 19.6%
e | 12597 | 12.7%
o | 8501 | 8.5%
n | 7151 | 7.2%
d | 5530 | 5.6%
a | 4963 | 5.0%
l | 4492 | 4.5%
h | 4405 | 4.4%
r | 4344 | 4.4%
s | 4257 | 4.3%
Other values (20) | 23781 | 23.9%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 99485 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 19464 | 19.6%
e | 12597 | 12.7%
o | 8501 | 8.5%
n | 7151 | 7.2%
d | 5530 | 5.6%
a | 4963 | 5.0%
l | 4492 | 4.5%
h | 4405 | 4.4%
r | 4344 | 4.4%
s | 4257 | 4.3%
Other values (20) | 23781 | 23.9%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 99485 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 19464 | 19.6%
e | 12597 | 12.7%
o | 8501 | 8.5%
n | 7151 | 7.2%
d | 5530 | 5.6%
a | 4963 | 5.0%
l | 4492 | 4.5%
h | 4405 | 4.4%
r | 4344 | 4.4%
s | 4257 | 4.3%
Other values (20) | 23781 | 23.9%

BTU_of_the_AC
Real number (ℝ)

Zeros

Distinct | 22
Distinct (%) | 2.6%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 6326.815

Minimum | 0
Maximum | 60000
Zeros | 23
Zeros (%) | 2.7%
Negative | 0
Negative (%) | 0.0%
Memory size | 6.8 KiB

Quantile statistics

Minimum | 0
5-th percentile | 1000
Q1 | 1000
median | 1000
Q3 | 12000
95-th percentile | 18000
Maximum | 60000
Range | 60000
Interquartile range (IQR) | 11000

Descriptive statistics

Standard deviation | 6381.3525
Coefficient of variation (CV) | 1.0086201
Kurtosis | 4.7879532
Mean | 6326.815
Median Absolute Deviation (MAD) | 0
Skewness | 1.2173376
Sum | 5403100
Variance | 40721660
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=22)

Value | Count | Frequency (%)
1000 | 431 | 50.5%
12000 | 211 | 24.7%
9000 | 76 | 8.9%
18000 | 49 | 5.7%
10000 | 25 | 2.9%
0 | 23 | 2.7%
16000 | 7 | 0.8%
8000 | 7 | 0.8%
24000 | 5 | 0.6%
14000 | 4 | 0.5%
Other values (12) | 16 | 1.9%

Value | Count | Frequency (%)
0 | 23 | 2.7%
1000 | 431 | 50.5%
1800 | 1 | 0.1%
3600 | 1 | 0.1%
6000 | 1 | 0.1%
8000 | 7 | 0.8%
9000 | 76 | 8.9%
9500 | 1 | 0.1%
10000 | 25 | 2.9%
12000 | 211 | 24.7%

Value | Count | Frequency (%)
60000 | 1 | 0.1%
30000 | 1 | 0.1%
25000 | 1 | 0.1%
24000 | 5 | 0.6%
20000 | 3 | 0.4%
18000 | 49 | 5.7%
17700 | 1 | 0.1%
16000 | 7 | 0.8%
15000 | 1 | 0.1%
14000 | 4 | 0.5%

no_of_hours_bulbs_was_on_during_daytime_last_week
Real number (ℝ)

Zeros

Distinct | 28
Distinct (%) | 3.3%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 3.3960773

Minimum | 0
Maximum | 70
Zeros | 692
Zeros (%) | 81.0%
Negative | 0
Negative (%) | 0.0%
Memory size | 6.8 KiB

Quantile statistics

Minimum | 0
5-th percentile | 0
Q1 | 0
median | 0
Q3 | 0
95-th percentile | 21
Maximum | 70
Range | 70
Interquartile range (IQR) | 0

Descriptive statistics

Standard deviation | 10.079234
Coefficient of variation (CV) | 2.9679048
Kurtosis | 22.104656
Mean | 3.3960773
Median Absolute Deviation (MAD) | 0
Skewness | 4.3482575
Sum | 2900.25
Variance | 101.59096
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=28)

Value | Count | Frequency (%)
0 | 692 | 81.0%
14 | 53 | 6.2%
7 | 24 | 2.8%
28 | 15 | 1.8%
21 | 11 | 1.3%
70 | 9 | 1.1%
2 | 6 | 0.7%
1 | 6 | 0.7%
4 | 6 | 0.7%
24 | 4 | 0.5%
Other values (18) | 28 | 3.3%

Value | Count | Frequency (%)
0 | 692 | 81.0%
0.25 | 1 | 0.1%
0.5 | 1 | 0.1%
1 | 6 | 0.7%
2 | 6 | 0.7%
3 | 3 | 0.4%
3.5 | 1 | 0.1%
4 | 6 | 0.7%
5 | 4 | 0.5%
6 | 1 | 0.1%

Value | Count | Frequency (%)
70 | 9 | 1.1%
56 | 1 | 0.1%
54 | 1 | 0.1%
49 | 2 | 0.2%
48 | 1 | 0.1%
42 | 1 | 0.1%
41 | 1 | 0.1%
36 | 1 | 0.1%
35 | 2 | 0.2%
28 | 15 | 1.8%

no_of_hours_bulbs_was_on_during_night_last_week
Real number (ℝ)

Zeros

Distinct | 56
Distinct (%) | 6.6%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 17.11363

Minimum | 0
Maximum | 98
Zeros | 362
Zeros (%) | 42.4%
Negative | 0
Negative (%) | 0.0%
Memory size | 6.8 KiB

Quantile statistics

Minimum | 0
5-th percentile | 0
Q1 | 0
median | 6
Q3 | 28
95-th percentile | 60
Maximum | 98
Range | 98
Interquartile range (IQR) | 28

Descriptive statistics

Standard deviation | 22.246367
Coefficient of variation (CV) | 1.299921
Kurtosis | 0.40486331
Mean | 17.11363
Median Absolute Deviation (MAD) | 6
Skewness | 1.1989702
Sum | 14615.04
Variance | 494.90086
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=50)

Value | Count | Frequency (%)
0 | 362 | 42.4%
56 | 61 | 7.1%
28 | 53 | 6.2%
35 | 45 | 5.3%
14 | 43 | 5.0%
21 | 39 | 4.6%
7 | 35 | 4.1%
11 | 26 | 3.0%
42 | 24 | 2.8%
70 | 22 | 2.6%
Other values (46) | 144 | 16.9%

Value | Count | Frequency (%)
0 | 362 | 42.4%
0.5 | 3 | 0.4%
1 | 15 | 1.8%
1.16 | 1 | 0.1%
1.33 | 1 | 0.1%
1.75 | 1 | 0.1%
2 | 19 | 2.2%
2.5 | 2 | 0.2%
3 | 10 | 1.2%
3.5 | 6 | 0.7%

Value | Count | Frequency (%)
98 | 2 | 0.2%
90 | 1 | 0.1%
84 | 6 | 0.7%
77 | 1 | 0.1%
75 | 1 | 0.1%
73.5 | 1 | 0.1%
73.3 | 1 | 0.1%
70 | 22 | 2.6%
65 | 1 | 0.1%
64 | 1 | 0.1%

# Interactions

# Correlations

| AC_ID | BTU_of_the_AC | ROOM_ID | is_room_fully_sealed | is_the_AC_inverter_or_not | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week | type_of_the_AC
--- | --- | --- | --- | --- | --- | --- | --- | ---
AC_ID | 1.000 | 0.123 | 0.987 | 0.000 | 0.000 | 0.000 | 0.000 | 0.122
BTU_of_the_AC | 0.123 | 1.000 | 0.067 | 0.062 | 0.038 | 0.074 | 0.005 | 0.183
ROOM_ID | 0.987 | 0.067 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.144
is_room_fully_sealed | 0.000 | 0.062 | 0.000 | 1.000 | 0.015 | 0.168 | 0.073 | 0.087
is_the_AC_inverter_or_not | 0.000 | 0.038 | 0.000 | 0.015 | 1.000 | 0.129 | 0.195 | 0.054
no_of_hours_bulbs_was_on_during_daytime_last_week | 0.000 | 0.074 | 0.000 | 0.168 | 0.129 | 1.000 | 0.297 | 0.060
no_of_hours_bulbs_was_on_during_night_last_week | 0.000 | 0.005 | 0.000 | 0.073 | 0.195 | 0.297 | 1.000 | 0.097
type_of_the_AC | 0.122 | 0.183 | 0.144 | 0.087 | 0.054 | 0.060 | 0.097 | 1.000

# Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

# Sample

| household_ID | ROOM_ID | AC_ID | type_of_the_AC | is_the_AC_inverter_or_not | is_room_fully_sealed | BTU_of_the_AC | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
0 | ID0528 | I2 | I2_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 0.0
1 | ID0041 | I13 | I13_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 3.0
2 | ID0039 | I11 | I11_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 8000.0 | 12.0 | 12.0
3 | ID0072 | I3 | I3_AC1 | Central AC (Only to your Household) | NaN | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 28.0
4 | ID1251 | I4 | I4_AC1 | Central AC (For the whole building | NaN | The room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through | 1000.0 | 0.0 | 56.0
5 | ID2388 | I3 | I3_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 0.0
6 | ID2388 | I4 | I4_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 14.0
7 | ID1142 | I4 | I4_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 14.0
8 | ID1142 | I5 | I5_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 14.0
9 | ID1142 | I6 | I6_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 1.0

| household_ID | ROOM_ID | AC_ID | type_of_the_AC | is_the_AC_inverter_or_not | is_room_fully_sealed | BTU_of_the_AC | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
844 | ID3774 | I1 | I1_AC2 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 14000.0 | 0.0 | 0.0
845 | ID3774 | I1 | I1_AC3 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 14000.0 | 0.0 | 1.0
846 | ID3774 | I2 | I2_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 14000.0 | 7.0 | 14.0
847 | ID3774 | I3 | I3_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 12000.0 | 0.0 | 0.0
848 | ID3774 | I4 | I4_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 12000.0 | 0.0 | 0.0
849 | ID3652 | I5 | I5_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 7.0
850 | ID0202 | I5 | I5_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 7.0 | 0.0
851 | ID3668 | I2 | I2_AC1 | Individual AC with one component | No | The room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through | 8000.0 | 0.0 | 52.0
852 | ID1084 | I2 | I2_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 0.0
853 | ID1084 | I3 | I3_AC1 | Individual AC with two components | Yes | The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air doe | 1000.0 | 0.0 | 0.0