# Overview

Brought to you by YData

Dataset statistics

Number of variables | 9
Number of observations | 702
Missing cells | 115
Missing cells (%) | 1.8%
Duplicate rows | 0
Duplicate rows (%) | 0.0%
Total size in memory | 49.5 KiB
Average record size in memory | 72.2 B

Variable types

Text | 1
Categorical | 4
Numeric | 4

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 (68.7%) | Imbalance
`is_the_AC_inverter_or_not` has 115 (16.4%) missing values | Missing
`BTU_of_the_AC` has 10 (1.4%) zeros | Zeros
`no_of_hours_AC_was_on_during_daytime_last_week` has 546 (77.8%) zeros | Zeros
`no_of_hours_AC_was_on_during_night_last_week` has 286 (40.7%) zeros | Zeros

Reproduction

Analysis started | 2025-02-27 04:59:08.742185
Analysis finished | 2025-02-27 04:59:10.569710
Duration | 1.83 second
Software version | ydata-profiling vv4.11.0
Download configuration | config.json

# Variables

household_ID
Text

Distinct | 354
Distinct (%) | 50.4%
Missing | 0
Missing (%) | 0.0%
Memory size | 5.6 KiB

Length

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

Characters and Unicode

Total characters | 4212
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 | 192 ?
Unique (%) | 27.4%

Sample

1st row | ID0757
2nd row | ID0823
3rd row | ID0823
4th row | ID0823
5th row | ID0069

Value | Count | Frequency (%)
id2985 | 18 | 2.6%
id1816 | 12 | 1.7%
id0278 | 11 | 1.6%
id0069 | 10 | 1.4%
id2969 | 10 | 1.4%
id2660 | 9 | 1.3%
id1165 | 8 | 1.1%
id1521 | 8 | 1.1%
id2974 | 7 | 1.0%
id0572 | 6 | 0.9%
Other values (344) | 603 | 85.9%

#### Most occurring characters

Value | Count | Frequency (%)
I | 702 | 16.7%
D | 702 | 16.7%
2 | 420 | 10.0%
0 | 388 | 9.2%
1 | 364 | 8.6%
3 | 357 | 8.5%
8 | 238 | 5.7%
7 | 230 | 5.5%
6 | 230 | 5.5%
5 | 201 | 4.8%
Other values (2) | 380 | 9.0%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 702 | 16.7%
D | 702 | 16.7%
2 | 420 | 10.0%
0 | 388 | 9.2%
1 | 364 | 8.6%
3 | 357 | 8.5%
8 | 238 | 5.7%
7 | 230 | 5.5%
6 | 230 | 5.5%
5 | 201 | 4.8%
Other values (2) | 380 | 9.0%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 702 | 16.7%
D | 702 | 16.7%
2 | 420 | 10.0%
0 | 388 | 9.2%
1 | 364 | 8.6%
3 | 357 | 8.5%
8 | 238 | 5.7%
7 | 230 | 5.5%
6 | 230 | 5.5%
5 | 201 | 4.8%
Other values (2) | 380 | 9.0%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 702 | 16.7%
D | 702 | 16.7%
2 | 420 | 10.0%
0 | 388 | 9.2%
1 | 364 | 8.6%
3 | 357 | 8.5%
8 | 238 | 5.7%
7 | 230 | 5.5%
6 | 230 | 5.5%
5 | 201 | 4.8%
Other values (2) | 380 | 9.0%

ROOM_ID
Categorical

High correlation

Distinct | 16
Distinct (%) | 2.3%
Missing | 0
Missing (%) | 0.0%
Memory size | 5.6 KiB

I3 | 180
I2 | 164
I4 | 130
I5 | 77
I6 | 50
Other values (11) | 101

Length

Max length | 5
Median length | 2
Mean length | 2.0441595
Min length | 2

Characters and Unicode

Total characters | 1435
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 | 2 ?
Unique (%) | 0.3%

Sample

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

#### Common Values

Value | Count | Frequency (%)
I3 | 180 | 25.6%
I2 | 164 | 23.4%
I4 | 130 | 18.5%
I5 | 77 | 11.0%
I6 | 50 | 7.1%
I7 | 23 | 3.3%
I1 | 20 | 2.8%
I8 | 16 | 2.3%
I10 | 14 | 2.0%
I9 | 13 | 1.9%
Other values (6) | 15 | 2.1%

#### Length

Histogram of lengths of the category

Value | Count | Frequency (%)
i3 | 180 | 25.6%
i2 | 164 | 23.4%
i4 | 130 | 18.5%
i5 | 77 | 11.0%
i6 | 50 | 7.1%
i7 | 23 | 3.3%
i1 | 20 | 2.8%
i8 | 16 | 2.3%
i10 | 14 | 2.0%
i9 | 13 | 1.9%
Other values (6) | 15 | 2.1%

#### Most occurring characters

Value | Count | Frequency (%)
I | 702 | 48.9%
3 | 182 | 12.7%
2 | 167 | 11.6%
4 | 132 | 9.2%
5 | 78 | 5.4%
1 | 55 | 3.8%
6 | 50 | 3.5%
7 | 23 | 1.6%
8 | 16 | 1.1%
0 | 14 | 1.0%
Other values (4) | 16 | 1.1%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 702 | 48.9%
3 | 182 | 12.7%
2 | 167 | 11.6%
4 | 132 | 9.2%
5 | 78 | 5.4%
1 | 55 | 3.8%
6 | 50 | 3.5%
7 | 23 | 1.6%
8 | 16 | 1.1%
0 | 14 | 1.0%
Other values (4) | 16 | 1.1%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 702 | 48.9%
3 | 182 | 12.7%
2 | 167 | 11.6%
4 | 132 | 9.2%
5 | 78 | 5.4%
1 | 55 | 3.8%
6 | 50 | 3.5%
7 | 23 | 1.6%
8 | 16 | 1.1%
0 | 14 | 1.0%
Other values (4) | 16 | 1.1%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 702 | 48.9%
3 | 182 | 12.7%
2 | 167 | 11.6%
4 | 132 | 9.2%
5 | 78 | 5.4%
1 | 55 | 3.8%
6 | 50 | 3.5%
7 | 23 | 1.6%
8 | 16 | 1.1%
0 | 14 | 1.0%
Other values (4) | 16 | 1.1%

AC_ID
Categorical

High correlation

Distinct | 27
Distinct (%) | 3.8%
Missing | 0
Missing (%) | 0.0%
Memory size | 5.6 KiB

I3_AC1 | 179
I2_AC1 | 163
I4_AC1 | 129
I5_AC1 | 76
I6_AC1 | 49
Other values (22) | 106

Length

Max length | 9
Median length | 6
Mean length | 6.0441595
Min length | 6

Characters and Unicode

Total characters | 4243
Distinct characters | 17
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 | 12 ?
Unique (%) | 1.7%

Sample

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

#### Common Values

Value | Count | Frequency (%)
I3_AC1 | 179 | 25.5%
I2_AC1 | 163 | 23.2%
I4_AC1 | 129 | 18.4%
I5_AC1 | 76 | 10.8%
I6_AC1 | 49 | 7.0%
I7_AC1 | 22 | 3.1%
I1_AC1 | 17 | 2.4%
I8_AC1 | 15 | 2.1%
I10_AC1 | 13 | 1.9%
I9_AC1 | 12 | 1.7%
Other values (17) | 27 | 3.8%

#### Length

Histogram of lengths of the category

Value | Count | Frequency (%)
i3_ac1 | 179 | 25.5%
i2_ac1 | 163 | 23.2%
i4_ac1 | 129 | 18.4%
i5_ac1 | 76 | 10.8%
i6_ac1 | 49 | 7.0%
i7_ac1 | 22 | 3.1%
i1_ac1 | 17 | 2.4%
i8_ac1 | 15 | 2.1%
i10_ac1 | 13 | 1.9%
i9_ac1 | 12 | 1.7%
Other values (17) | 27 | 3.8%

#### Most occurring characters

Value | Count | Frequency (%)
1 | 745 | 17.6%
I | 702 | 16.5%
_ | 702 | 16.5%
C | 702 | 16.5%
A | 702 | 16.5%
3 | 183 | 4.3%
2 | 178 | 4.2%
4 | 132 | 3.1%
5 | 78 | 1.8%
6 | 50 | 1.2%
Other values (7) | 69 | 1.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
1 | 745 | 17.6%
I | 702 | 16.5%
_ | 702 | 16.5%
C | 702 | 16.5%
A | 702 | 16.5%
3 | 183 | 4.3%
2 | 178 | 4.2%
4 | 132 | 3.1%
5 | 78 | 1.8%
6 | 50 | 1.2%
Other values (7) | 69 | 1.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
1 | 745 | 17.6%
I | 702 | 16.5%
_ | 702 | 16.5%
C | 702 | 16.5%
A | 702 | 16.5%
3 | 183 | 4.3%
2 | 178 | 4.2%
4 | 132 | 3.1%
5 | 78 | 1.8%
6 | 50 | 1.2%
Other values (7) | 69 | 1.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
1 | 745 | 17.6%
I | 702 | 16.5%
_ | 702 | 16.5%
C | 702 | 16.5%
A | 702 | 16.5%
3 | 183 | 4.3%
2 | 178 | 4.2%
4 | 132 | 3.1%
5 | 78 | 1.8%
6 | 50 | 1.2%
Other values (7) | 69 | 1.6%

type_of_the_AC
Real number (ℝ)

Distinct | 6
Distinct (%) | 0.9%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 2.9017094

Minimum | 1
Maximum | 6
Zeros | 0
Zeros (%) | 0.0%
Negative | 0
Negative (%) | 0.0%
Memory size | 5.6 KiB

Quantile statistics

Minimum | 1
5-th percentile | 1
Q1 | 3
median | 3
Q3 | 3
95-th percentile | 4
Maximum | 6
Range | 5
Interquartile range (IQR) | 0

Descriptive statistics

Standard deviation | 0.89873738
Coefficient of variation (CV) | 0.30972687
Kurtosis | 1.0869834
Mean | 2.9017094
Median Absolute Deviation (MAD) | 0
Skewness | -0.78704562
Sum | 2037
Variance | 0.80772889
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=6)

Value | Count | Frequency (%)
3 | 468 | 66.7%
4 | 119 | 17.0%
1 | 100 | 14.2%
2 | 7 | 1.0%
5 | 5 | 0.7%
6 | 3 | 0.4%

Value | Count | Frequency (%)
1 | 100 | 14.2%
2 | 7 | 1.0%
3 | 468 | 66.7%
4 | 119 | 17.0%
5 | 5 | 0.7%
6 | 3 | 0.4%

Value | Count | Frequency (%)
6 | 3 | 0.4%
5 | 5 | 0.7%
4 | 119 | 17.0%
3 | 468 | 66.7%
2 | 7 | 1.0%
1 | 100 | 14.2%

is_the_AC_inverter_or_not
Categorical

Missing

Distinct | 2
Distinct (%) | 0.3%
Missing | 115
Missing (%) | 16.4%
Memory size | 5.6 KiB

1.0 | 479
2.0 | 108

Length

Max length | 3
Median length | 3
Mean length | 3
Min length | 3

Characters and Unicode

Total characters | 1761
Distinct characters | 4
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 | 1.0
2nd row | 1.0
3rd row | 1.0
4th row | 1.0
5th row | 1.0

#### Common Values

Value | Count | Frequency (%)
1.0 | 479 | 68.2%
2.0 | 108 | 15.4%
(Missing) | 115 | 16.4%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
1.0 | 479 | 81.6%
2.0 | 108 | 18.4%

#### Most occurring characters

Value | Count | Frequency (%)
. | 587 | 33.3%
0 | 587 | 33.3%
1 | 479 | 27.2%
2 | 108 | 6.1%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
. | 587 | 33.3%
0 | 587 | 33.3%
1 | 479 | 27.2%
2 | 108 | 6.1%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
. | 587 | 33.3%
0 | 587 | 33.3%
1 | 479 | 27.2%
2 | 108 | 6.1%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
. | 587 | 33.3%
0 | 587 | 33.3%
1 | 479 | 27.2%
2 | 108 | 6.1%

is_room_fully_sealed
Categorical

Imbalance

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

1.0 | 634
2.0 | 63
3.0 | 5

Length

Max length | 3
Median length | 3
Mean length | 3
Min length | 3

Characters and Unicode

Total characters | 2106
Distinct characters | 5
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 | 1.0
2nd row | 1.0
3rd row | 1.0
4th row | 1.0
5th row | 1.0

#### Common Values

Value | Count | Frequency (%)
1.0 | 634 | 90.3%
2.0 | 63 | 9.0%
3.0 | 5 | 0.7%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
1.0 | 634 | 90.3%
2.0 | 63 | 9.0%
3.0 | 5 | 0.7%

#### Most occurring characters

Value | Count | Frequency (%)
. | 702 | 33.3%
0 | 702 | 33.3%
1 | 634 | 30.1%
2 | 63 | 3.0%
3 | 5 | 0.2%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
. | 702 | 33.3%
0 | 702 | 33.3%
1 | 634 | 30.1%
2 | 63 | 3.0%
3 | 5 | 0.2%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
. | 702 | 33.3%
0 | 702 | 33.3%
1 | 634 | 30.1%
2 | 63 | 3.0%
3 | 5 | 0.2%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
. | 702 | 33.3%
0 | 702 | 33.3%
1 | 634 | 30.1%
2 | 63 | 3.0%
3 | 5 | 0.2%

BTU_of_the_AC
Real number (ℝ)

Zeros

Distinct | 20
Distinct (%) | 2.8%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 4.5014246 × 1011

Minimum | 0
Maximum | 1 × 1012
Zeros | 10
Zeros (%) | 1.4%
Negative | 0
Negative (%) | 0.0%
Memory size | 5.6 KiB

Quantile statistics

Minimum | 0
5-th percentile | 1000
Q1 | 12000
median | 18000
Q3 | 1 × 1012
95-th percentile | 1 × 1012
Maximum | 1 × 1012
Range | 1 × 1012
Interquartile range (IQR) | 9.9999999 × 1011

Descriptive statistics

Standard deviation | 4.9786274 × 1011
Coefficient of variation (CV) | 1.1060115
Kurtosis | -1.965263
Mean | 4.5014246 × 1011
Median Absolute Deviation (MAD) | 17000
Skewness | 0.20085857
Sum | 3.16 × 1014
Variance | 2.4786731 × 1023
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=20)

Value | Count | Frequency (%)
1 × 1012 | 316 | 45.0%
12000 | 173 | 24.6%
9000 | 77 | 11.0%
1000 | 47 | 6.7%
18000 | 37 | 5.3%
0 | 10 | 1.4%
24000 | 9 | 1.3%
60000 | 8 | 1.1%
8000 | 5 | 0.7%
10000 | 4 | 0.6%
Other values (10) | 16 | 2.3%

Value | Count | Frequency (%)
0 | 10 | 1.4%
17 | 1 | 0.1%
1000 | 47 | 6.7%
1200 | 1 | 0.1%
2000 | 1 | 0.1%
2400 | 1 | 0.1%
2500 | 3 | 0.4%
5000 | 1 | 0.1%
6000 | 2 | 0.3%
8000 | 5 | 0.7%

Value | Count | Frequency (%)
1 × 1012 | 316 | 45.0%
60000 | 8 | 1.1%
24000 | 9 | 1.3%
18000 | 37 | 5.3%
16000 | 1 | 0.1%
15000 | 2 | 0.3%
13000 | 3 | 0.4%
12000 | 173 | 24.6%
10000 | 4 | 0.6%
9000 | 77 | 11.0%

no_of_hours_AC_was_on_during_daytime_last_week
Real number (ℝ)

Zeros

Distinct | 28
Distinct (%) | 4.0%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 3.2211538

Minimum | 0
Maximum | 70
Zeros | 546
Zeros (%) | 77.8%
Negative | 0
Negative (%) | 0.0%
Memory size | 5.6 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 8.3850351
Coefficient of variation (CV) | 2.6031154
Kurtosis | 24.301124
Mean | 3.2211538
Median Absolute Deviation (MAD) | 0
Skewness | 4.1883808
Sum | 2261.25
Variance | 70.308814
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=28)

Value | Count | Frequency (%)
0 | 546 | 77.8%
14 | 41 | 5.8%
7 | 25 | 3.6%
21 | 19 | 2.7%
17 | 12 | 1.7%
2 | 11 | 1.6%
3 | 5 | 0.7%
28 | 5 | 0.7%
1 | 4 | 0.6%
70 | 4 | 0.6%
Other values (18) | 30 | 4.3%

Value | Count | Frequency (%)
0 | 546 | 77.8%
0.5 | 2 | 0.3%
1 | 4 | 0.6%
1.75 | 1 | 0.1%
2 | 11 | 1.6%
3 | 5 | 0.7%
3.5 | 3 | 0.4%
4 | 3 | 0.4%
5 | 1 | 0.1%
6 | 1 | 0.1%

Value | Count | Frequency (%)
70 | 4 | 0.6%
42 | 1 | 0.1%
40 | 1 | 0.1%
38 | 1 | 0.1%
35 | 3 | 0.4%
30 | 1 | 0.1%
28 | 5 | 0.7%
24 | 1 | 0.1%
21 | 19 | 2.7%
20 | 1 | 0.1%

no_of_hours_AC_was_on_during_night_last_week
Real number (ℝ)

Zeros

Distinct | 55
Distinct (%) | 7.8%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 16.339316

Minimum | 0
Maximum | 98
Zeros | 286
Zeros (%) | 40.7%
Negative | 0
Negative (%) | 0.0%
Memory size | 5.6 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 21.758588
Coefficient of variation (CV) | 1.3316707
Kurtosis | 1.1730938
Mean | 16.339316
Median Absolute Deviation (MAD) | 4
Skewness | 1.3729934
Sum | 11470.2
Variance | 473.43616
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=50)

Value | Count | Frequency (%)
0 | 286 | 40.7%
35 | 54 | 7.7%
14 | 37 | 5.3%
7 | 33 | 4.7%
56 | 31 | 4.4%
28 | 31 | 4.4%
21 | 28 | 4.0%
42 | 25 | 3.6%
2 | 14 | 2.0%
17 | 12 | 1.7%
Other values (45) | 151 | 21.5%

Value | Count | Frequency (%)
0 | 286 | 40.7%
0.25 | 3 | 0.4%
0.33 | 1 | 0.1%
0.45 | 1 | 0.1%
0.5 | 4 | 0.6%
1 | 11 | 1.6%
1.5 | 1 | 0.1%
2 | 14 | 2.0%
2.31 | 2 | 0.3%
2.5 | 1 | 0.1%

Value | Count | Frequency (%)
98 | 1 | 0.1%
96 | 1 | 0.1%
88 | 6 | 0.9%
84 | 4 | 0.6%
77 | 4 | 0.6%
74 | 1 | 0.1%
72 | 1 | 0.1%
70 | 8 | 1.1%
66.5 | 1 | 0.1%
63 | 7 | 1.0%

# Interactions

# Correlations

| AC_ID | BTU_of_the_AC | ROOM_ID | is_room_fully_sealed | is_the_AC_inverter_or_not | no_of_hours_AC_was_on_during_daytime_last_week | no_of_hours_AC_was_on_during_night_last_week | type_of_the_AC
--- | --- | --- | --- | --- | --- | --- | --- | ---
AC_ID | 1.000 | 0.000 | 0.992 | 0.000 | 0.000 | 0.000 | 0.000 | 0.093
BTU_of_the_AC | 0.000 | 1.000 | 0.000 | 0.092 | 0.000 | -0.067 | -0.002 | -0.037
ROOM_ID | 0.992 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.097
is_room_fully_sealed | 0.000 | 0.092 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.091
is_the_AC_inverter_or_not | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000
no_of_hours_AC_was_on_during_daytime_last_week | 0.000 | -0.067 | 0.000 | 0.000 | 0.000 | 1.000 | 0.308 | -0.069
no_of_hours_AC_was_on_during_night_last_week | 0.000 | -0.002 | 0.000 | 0.000 | 0.000 | 0.308 | 1.000 | 0.076
type_of_the_AC | 0.093 | -0.037 | 0.097 | 0.091 | 0.000 | -0.069 | 0.076 | 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_AC_was_on_during_daytime_last_week | no_of_hours_AC_was_on_during_night_last_week
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
0 | ID0757 | I4 | I4_AC1 | 3.0 | 1.0 | 1.0 | 1.000000e+12 | 0.0 | 0.0
1 | ID0823 | I2 | I2_AC1 | 3.0 | 1.0 | 1.0 | 9.000000e+03 | 0.0 | 3.0
2 | ID0823 | I3 | I3_AC1 | 3.0 | 1.0 | 1.0 | 9.000000e+03 | 0.0 | 21.0
3 | ID0823 | I4 | I4_AC1 | 3.0 | 1.0 | 1.0 | 9.000000e+03 | 21.0 | 56.0
4 | ID0069 | I1 | I1_AC1 | 1.0 | NaN | 1.0 | 1.000000e+12 | 0.0 | 0.0
5 | ID0069 | I2 | I2_AC1 | 1.0 | NaN | 1.0 | 1.000000e+12 | 0.0 | 0.0
6 | ID0069 | I3 | I3_AC1 | 1.0 | NaN | 1.0 | 1.000000e+12 | 0.0 | 0.0
7 | ID0069 | I4 | I4_AC1 | 1.0 | NaN | 1.0 | 1.000000e+12 | 0.0 | 0.0
8 | ID0069 | I5 | I5_AC1 | 1.0 | NaN | 1.0 | 1.000000e+12 | 0.0 | 0.0
9 | ID0069 | I6 | I6_AC1 | 1.0 | NaN | 1.0 | 1.000000e+12 | 0.0 | 0.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_AC_was_on_during_daytime_last_week | no_of_hours_AC_was_on_during_night_last_week
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
692 | ID2780 | I3 | I3_AC1 | 3.0 | 1.0 | 1.0 | 9.000000e+03 | 0.0 | 12.0
693 | ID2780 | I4 | I4_AC1 | 3.0 | 1.0 | 1.0 | 9.000000e+03 | 0.0 | 12.0
694 | ID2780 | I5 | I5_AC1 | 3.0 | 1.0 | 1.0 | 9.000000e+03 | 0.0 | 0.0
695 | ID2774 | I2 | I2_AC1 | 4.0 | 1.0 | 1.0 | 1.000000e+04 | 0.0 | 35.0
696 | ID0605 | I3 | I3_AC1 | 3.0 | 1.0 | 1.0 | 1.000000e+12 | 14.0 | 14.0
697 | ID3475 | I2 | I2_AC1 | 3.0 | 1.0 | 1.0 | 1.800000e+04 | 0.0 | 42.0
698 | ID3475 | I3 | I3_AC1 | 3.0 | 1.0 | 1.0 | 1.800000e+04 | 0.0 | 21.0
699 | ID3475 | I4 | I4_AC1 | 3.0 | 1.0 | 1.0 | 1.800000e+04 | 0.0 | 21.0
700 | ID0980 | I5 | I5_AC1 | 3.0 | 1.0 | 1.0 | 1.200000e+04 | 0.0 | 10.0
701 | ID0470 | I3 | I3_AC1 | 4.0 | 1.0 | 1.0 | 1.600000e+04 | 0.0 | 35.0