Overview

Brought to you by YData

Dataset statistics

Number of variables10
Number of observations1,171
Missing cells909
Missing cells (%)7.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory91.6 KiB
Average record size in memory80.1 B

Variable types

Text2
Categorical3
Boolean1
Numeric4

Alerts

is_room_fully_sealed is highly imbalanced (64.1%) Imbalance
wattage_of_the_ac has 356 (30.4%) missing values Missing
btu_of_the_ac has 553 (47.2%) missing values Missing
wattage_of_the_ac has 610 (52.1%) zeros Zeros
btu_of_the_ac has 67 (5.7%) zeros Zeros
no_of_hours_ac_was_on_during_daytime_last_week has 993 (84.8%) zeros Zeros
no_of_hours_ac_was_on_during_night_last_week has 499 (42.6%) zeros Zeros

Reproduction

Analysis started2024-12-06 05:54:54.739615
Analysis finished2024-12-06 05:54:56.671088
Duration1.93 second
Software versionydata-profiling vv4.11.0
Download configurationconfig.json

Variables

household_ID
Text

Distinct562
Distinct (%)48.0%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2024-12-06T11:24:56.844205image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

Total characters7,026
Distinct characters12
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique312 ?
Unique (%)26.6%

Sample

1st rowID0012
2nd rowID0014
3rd rowID0018
4th rowID0025
5th rowID0039
ValueCountFrequency (%)
id1214 28
 
2.4%
id2985 26
 
2.2%
id0282 26
 
2.2%
id1816 24
 
2.0%
id2072 24
 
2.0%
id0278 11
 
0.9%
id1227 9
 
0.8%
id0083 9
 
0.8%
id2660 8
 
0.7%
id0348 7
 
0.6%
Other values (552) 999
85.3%
2024-12-06T11:24:57.155876image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
I 1171
16.7%
D 1171
16.7%
2 758
10.8%
0 662
9.4%
1 634
9.0%
3 590
8.4%
7 407
 
5.8%
8 371
 
5.3%
4 365
 
5.2%
6 342
 
4.9%
Other values (2) 555
7.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4684
66.7%
Uppercase Letter 2342
33.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 758
16.2%
0 662
14.1%
1 634
13.5%
3 590
12.6%
7 407
8.7%
8 371
7.9%
4 365
7.8%
6 342
7.3%
5 281
 
6.0%
9 274
 
5.8%
Uppercase Letter
ValueCountFrequency (%)
I 1171
50.0%
D 1171
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4684
66.7%
Latin 2342
33.3%

Most frequent character per script

Common
ValueCountFrequency (%)
2 758
16.2%
0 662
14.1%
1 634
13.5%
3 590
12.6%
7 407
8.7%
8 371
7.9%
4 365
7.8%
6 342
7.3%
5 281
 
6.0%
9 274
 
5.8%
Latin
ValueCountFrequency (%)
I 1171
50.0%
D 1171
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7026
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
I 1171
16.7%
D 1171
16.7%
2 758
10.8%
0 662
9.4%
1 634
9.0%
3 590
8.4%
7 407
 
5.8%
8 371
 
5.3%
4 365
 
5.2%
6 342
 
4.9%
Other values (2) 555
7.9%

room_ID
Categorical

Distinct23
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
I2
282 
I3
255 
I4
176 
I5
115 
I6
76 
Other values (18)
267 

Length

Max length5
Median length2
Mean length2.1229718
Min length2

Characters and Unicode

Total characters2,486
Distinct characters14
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st rowI3
2nd rowI3
3rd rowI5
4th rowI2
5th rowI8

Common Values

ValueCountFrequency (%)
I2 282
24.1%
I3 255
21.8%
I4 176
15.0%
I5 115
9.8%
I6 76
 
6.5%
I1 58
 
5.0%
I7 38
 
3.2%
I8 30
 
2.6%
I11 25
 
2.1%
I10 22
 
1.9%
Other values (13) 94
 
8.0%

Length

2024-12-06T11:24:57.266819image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
i2 282
24.1%
i3 255
21.8%
i4 176
15.0%
i5 115
9.8%
i6 76
 
6.5%
i1 58
 
5.0%
i7 38
 
3.2%
i8 30
 
2.6%
i11 25
 
2.1%
i10 22
 
1.9%
Other values (13) 94
 
8.0%

Most occurring characters

ValueCountFrequency (%)
I 1171
47.1%
2 299
 
12.0%
3 277
 
11.1%
1 198
 
8.0%
4 186
 
7.5%
5 124
 
5.0%
6 80
 
3.2%
7 40
 
1.6%
8 34
 
1.4%
0 23
 
0.9%
Other values (4) 54
 
2.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1282
51.6%
Uppercase Letter 1182
47.5%
Lowercase Letter 22
 
0.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 299
23.3%
3 277
21.6%
1 198
15.4%
4 186
14.5%
5 124
9.7%
6 80
 
6.2%
7 40
 
3.1%
8 34
 
2.7%
0 23
 
1.8%
9 21
 
1.6%
Uppercase Letter
ValueCountFrequency (%)
I 1171
99.1%
O 11
 
0.9%
Lowercase Letter
ValueCountFrequency (%)
t 11
50.0%
h 11
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1282
51.6%
Latin 1204
48.4%

Most frequent character per script

Common
ValueCountFrequency (%)
2 299
23.3%
3 277
21.6%
1 198
15.4%
4 186
14.5%
5 124
9.7%
6 80
 
6.2%
7 40
 
3.1%
8 34
 
2.7%
0 23
 
1.8%
9 21
 
1.6%
Latin
ValueCountFrequency (%)
I 1171
97.3%
O 11
 
0.9%
t 11
 
0.9%
h 11
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2486
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
I 1171
47.1%
2 299
 
12.0%
3 277
 
11.1%
1 198
 
8.0%
4 186
 
7.5%
5 124
 
5.0%
6 80
 
3.2%
7 40
 
1.6%
8 34
 
1.4%
0 23
 
0.9%
Other values (4) 54
 
2.2%

ac_ID
Text

Distinct51
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2024-12-06T11:24:57.386404image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Length

Max length9
Median length6
Mean length6.1229718
Min length6

Characters and Unicode

Total characters7,170
Distinct characters17
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique10 ?
Unique (%)0.9%

Sample

1st rowI3_AC1
2nd rowI3_AC1
3rd rowI5_AC1
4th rowI2_AC1
5th rowI8_AC1
ValueCountFrequency (%)
i2_ac1 273
23.3%
i3_ac1 245
20.9%
i4_ac1 168
14.3%
i5_ac1 107
 
9.1%
i6_ac1 68
 
5.8%
i1_ac1 47
 
4.0%
i7_ac1 32
 
2.7%
i11_ac1 22
 
1.9%
i8_ac1 22
 
1.9%
i10_ac1 18
 
1.5%
Other values (41) 169
14.4%
2024-12-06T11:24:57.610018image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1284
17.9%
I 1171
16.3%
_ 1171
16.3%
C 1171
16.3%
A 1171
16.3%
2 356
 
5.0%
3 304
 
4.2%
4 187
 
2.6%
5 124
 
1.7%
6 80
 
1.1%
Other values (7) 151
 
2.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 3524
49.1%
Decimal Number 2453
34.2%
Connector Punctuation 1171
 
16.3%
Lowercase Letter 22
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1284
52.3%
2 356
 
14.5%
3 304
 
12.4%
4 187
 
7.6%
5 124
 
5.1%
6 80
 
3.3%
7 40
 
1.6%
8 34
 
1.4%
0 23
 
0.9%
9 21
 
0.9%
Uppercase Letter
ValueCountFrequency (%)
I 1171
33.2%
C 1171
33.2%
A 1171
33.2%
O 11
 
0.3%
Lowercase Letter
ValueCountFrequency (%)
t 11
50.0%
h 11
50.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1171
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3624
50.5%
Latin 3546
49.5%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1284
35.4%
_ 1171
32.3%
2 356
 
9.8%
3 304
 
8.4%
4 187
 
5.2%
5 124
 
3.4%
6 80
 
2.2%
7 40
 
1.1%
8 34
 
0.9%
0 23
 
0.6%
Latin
ValueCountFrequency (%)
I 1171
33.0%
C 1171
33.0%
A 1171
33.0%
O 11
 
0.3%
t 11
 
0.3%
h 11
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7170
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1284
17.9%
I 1171
16.3%
_ 1171
16.3%
C 1171
16.3%
A 1171
16.3%
2 356
 
5.0%
3 304
 
4.2%
4 187
 
2.6%
5 124
 
1.7%
6 80
 
1.1%
Other values (7) 151
 
2.1%

type_of_the_ac
Categorical

Distinct6
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Individual AC with two components
596 
Central AC (Only to your Household)
332 
Individual AC with one component
207 
Central AC (For the whole building)
 
14
Other
 
12

Length

Max length35
Median length33
Mean length32.930828
Min length5

Characters and Unicode

Total characters38,562
Distinct characters29
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowIndividual AC with one component
2nd rowOther
3rd rowIndividual AC with two components
4th rowCentral AC (Only to your Household)
5th rowIndividual AC with two components

Common Values

ValueCountFrequency (%)
Individual AC with two components 596
50.9%
Central AC (Only to your Household) 332
28.4%
Individual AC with one component 207
 
17.7%
Central AC (For the whole building) 14
 
1.2%
Other 12
 
1.0%
Air Cooler 10
 
0.9%

Length

2024-12-06T11:24:57.716869image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-12-06T11:24:57.808836image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
ValueCountFrequency (%)
ac 1149
18.8%
individual 803
13.1%
with 803
13.1%
two 596
9.7%
components 596
9.7%
central 346
 
5.7%
only 332
 
5.4%
to 332
 
5.4%
your 332
 
5.4%
household 332
 
5.4%
Other values (9) 502
8.2%

Most occurring characters

ValueCountFrequency (%)
4952
 
12.8%
o 3785
 
9.8%
n 3308
 
8.6%
t 2906
 
7.5%
i 2447
 
6.3%
d 1952
 
5.1%
l 1851
 
4.8%
e 1738
 
4.5%
C 1505
 
3.9%
u 1481
 
3.8%
Other values (19) 12637
32.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 28761
74.6%
Space Separator 4952
 
12.8%
Uppercase Letter 4157
 
10.8%
Open Punctuation 346
 
0.9%
Close Punctuation 346
 
0.9%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 3785
13.2%
n 3308
11.5%
t 2906
10.1%
i 2447
 
8.5%
d 1952
 
6.8%
l 1851
 
6.4%
e 1738
 
6.0%
u 1481
 
5.1%
w 1413
 
4.9%
h 1175
 
4.1%
Other values (10) 6705
23.3%
Uppercase Letter
ValueCountFrequency (%)
C 1505
36.2%
A 1159
27.9%
I 803
19.3%
O 344
 
8.3%
H 332
 
8.0%
F 14
 
0.3%
Space Separator
ValueCountFrequency (%)
4952
100.0%
Open Punctuation
ValueCountFrequency (%)
( 346
100.0%
Close Punctuation
ValueCountFrequency (%)
) 346
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 32918
85.4%
Common 5644
 
14.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
o 3785
 
11.5%
n 3308
 
10.0%
t 2906
 
8.8%
i 2447
 
7.4%
d 1952
 
5.9%
l 1851
 
5.6%
e 1738
 
5.3%
C 1505
 
4.6%
u 1481
 
4.5%
w 1413
 
4.3%
Other values (16) 10532
32.0%
Common
ValueCountFrequency (%)
4952
87.7%
( 346
 
6.1%
) 346
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 38562
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4952
 
12.8%
o 3785
 
9.8%
n 3308
 
8.6%
t 2906
 
7.5%
i 2447
 
6.3%
d 1952
 
5.1%
l 1851
 
4.8%
e 1738
 
4.5%
C 1505
 
3.9%
u 1481
 
3.8%
Other values (19) 12637
32.8%

is_the_ac_inverter_or_not
Boolean

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
True
748 
False
423 
ValueCountFrequency (%)
True 748
63.9%
False 423
36.1%
2024-12-06T11:24:57.900360image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

is_room_fully_sealed
Categorical

Imbalance 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.
1047 
The room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through the spaces that are not sealed such as the space in-between the door and the door frame.
 
96
The room is not fully closed. There are spaces where the cool air can leak out.
 
28

Length

Max length207
Median length142
Mean length145.82237
Min length79

Characters and Unicode

Total characters170,758
Distinct characters31
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.
2nd rowThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.
3rd rowThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.
4th rowThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.
5th rowThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.

Common Values

ValueCountFrequency (%)
The room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room. 1047
89.4%
The room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through the spaces that are not sealed such as the space in-between the door and the door frame. 96
 
8.2%
The room is not fully closed. There are spaces where the cool air can leak out. 28
 
2.4%

Length

2024-12-06T11:24:57.986242image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-12-06T11:24:58.073936image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
ValueCountFrequency (%)
the 4916
 
13.8%
room 2218
 
6.2%
and 2190
 
6.1%
is 1363
 
3.8%
not 1267
 
3.5%
fully 1267
 
3.5%
sealed 1239
 
3.5%
closed 1171
 
3.3%
cool 1171
 
3.3%
are 1171
 
3.3%
Other values (30) 17725
49.7%

Most occurring characters

ValueCountFrequency (%)
34527
20.2%
e 19528
11.4%
o 18388
10.8%
n 11198
 
6.6%
t 9708
 
5.7%
d 7933
 
4.6%
h 7642
 
4.5%
a 7574
 
4.4%
s 7450
 
4.4%
r 7382
 
4.3%
Other values (21) 39428
23.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 127638
74.7%
Space Separator 34527
 
20.2%
Uppercase Letter 4724
 
2.8%
Other Punctuation 3773
 
2.2%
Dash Punctuation 96
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 19528
15.3%
o 18388
14.4%
n 11198
8.8%
t 9708
 
7.6%
d 7933
 
6.2%
h 7642
 
6.0%
a 7574
 
5.9%
s 7450
 
5.8%
r 7382
 
5.8%
l 6239
 
4.9%
Other values (12) 24596
19.3%
Uppercase Letter
ValueCountFrequency (%)
T 1295
27.4%
C 1143
24.2%
A 1143
24.2%
W 1047
22.2%
H 96
 
2.0%
Other Punctuation
ValueCountFrequency (%)
. 2438
64.6%
, 1335
35.4%
Space Separator
ValueCountFrequency (%)
34527
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 96
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 132362
77.5%
Common 38396
 
22.5%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 19528
14.8%
o 18388
13.9%
n 11198
 
8.5%
t 9708
 
7.3%
d 7933
 
6.0%
h 7642
 
5.8%
a 7574
 
5.7%
s 7450
 
5.6%
r 7382
 
5.6%
l 6239
 
4.7%
Other values (17) 29320
22.2%
Common
ValueCountFrequency (%)
34527
89.9%
. 2438
 
6.3%
, 1335
 
3.5%
- 96
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 170758
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
34527
20.2%
e 19528
11.4%
o 18388
10.8%
n 11198
 
6.6%
t 9708
 
5.7%
d 7933
 
4.6%
h 7642
 
4.5%
a 7574
 
4.4%
s 7450
 
4.4%
r 7382
 
4.3%
Other values (21) 39428
23.1%

wattage_of_the_ac
Real number (ℝ)

Missing  Zeros 

Distinct45
Distinct (%)5.5%
Missing356
Missing (%)30.4%
Infinite0
Infinite (%)0.0%
Mean571.87117
Minimum0
Maximum18000
Zeros610
Zeros (%)52.1%
Negative0
Negative (%)0.0%
Memory size9.3 KiB
2024-12-06T11:24:58.185518image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile2000
Maximum18000
Range18000
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2337.6704
Coefficient of variation (CV)4.0877571
Kurtosis23.630431
Mean571.87117
Median Absolute Deviation (MAD)0
Skewness4.8141448
Sum466075
Variance5464703
MonotonicityNot monotonic
2024-12-06T11:24:58.300075image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
0 610
52.1%
12 31
 
2.6%
55 23
 
2.0%
12000 18
 
1.5%
18 16
 
1.4%
9000 10
 
0.9%
1000 8
 
0.7%
25 7
 
0.6%
24 7
 
0.6%
1100 7
 
0.6%
Other values (35) 78
 
6.7%
(Missing) 356
30.4%
ValueCountFrequency (%)
0 610
52.1%
1 2
 
0.2%
2 1
 
0.1%
5 2
 
0.2%
9 5
 
0.4%
10 2
 
0.2%
12 31
 
2.6%
13 3
 
0.3%
15 5
 
0.4%
18 16
 
1.4%
ValueCountFrequency (%)
18000 3
 
0.3%
12000 18
1.5%
9000 10
0.9%
8000 2
 
0.2%
6000 1
 
0.1%
5800 1
 
0.1%
5000 2
 
0.2%
2500 1
 
0.1%
2000 4
 
0.3%
1890 2
 
0.2%

btu_of_the_ac
Real number (ℝ)

Missing  Zeros 

Distinct29
Distinct (%)4.7%
Missing553
Missing (%)47.2%
Infinite0
Infinite (%)0.0%
Mean9564.0761
Minimum0
Maximum100000
Zeros67
Zeros (%)5.7%
Negative0
Negative (%)0.0%
Memory size9.3 KiB
2024-12-06T11:24:58.407518image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11000
median11000
Q312000
95-th percentile18000
Maximum100000
Range100000
Interquartile range (IQR)11000

Descriptive statistics

Standard deviation10532.706
Coefficient of variation (CV)1.1012779
Kurtosis32.504953
Mean9564.0761
Median Absolute Deviation (MAD)2000
Skewness4.6239866
Sum5910599
Variance1.109379 × 108
MonotonicityNot monotonic
2024-12-06T11:24:58.506693image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
12000 233
19.9%
1000 109
 
9.3%
9000 71
 
6.1%
0 67
 
5.7%
18000 39
 
3.3%
8000 18
 
1.5%
10000 16
 
1.4%
24000 12
 
1.0%
2000 9
 
0.8%
5000 5
 
0.4%
Other values (19) 39
 
3.3%
(Missing) 553
47.2%
ValueCountFrequency (%)
0 67
5.7%
1000 109
9.3%
1200 3
 
0.3%
1600 2
 
0.2%
1800 2
 
0.2%
2000 9
 
0.8%
2200 2
 
0.2%
2400 2
 
0.2%
3000 1
 
0.1%
5000 5
 
0.4%
ValueCountFrequency (%)
100000 2
 
0.2%
90000 1
 
0.1%
80000 3
 
0.3%
60000 2
 
0.2%
41000 1
 
0.1%
40000 2
 
0.2%
24000 12
 
1.0%
20000 3
 
0.3%
18000 39
3.3%
16000 3
 
0.3%

no_of_hours_ac_was_on_during_daytime_last_week
Real number (ℝ)

Zeros 

Distinct27
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.2492143
Minimum0
Maximum70
Zeros993
Zeros (%)84.8%
Negative0
Negative (%)0.0%
Memory size9.3 KiB
2024-12-06T11:24:58.600474image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile14
Maximum70
Range70
Interquartile range (IQR)0

Descriptive statistics

Standard deviation7.63311
Coefficient of variation (CV)3.3936783
Kurtosis29.528784
Mean2.2492143
Median Absolute Deviation (MAD)0
Skewness4.9085963
Sum2633.83
Variance58.264368
MonotonicityNot monotonic
2024-12-06T11:24:58.699641image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0 993
84.8%
7 37
 
3.2%
14 31
 
2.6%
28 16
 
1.4%
21 12
 
1.0%
2 10
 
0.9%
1 8
 
0.7%
4 7
 
0.6%
35 7
 
0.6%
42 7
 
0.6%
Other values (17) 43
 
3.7%
ValueCountFrequency (%)
0 993
84.8%
0.33 1
 
0.1%
0.5 2
 
0.2%
1 8
 
0.7%
2 10
 
0.9%
3 5
 
0.4%
3.5 6
 
0.5%
4 7
 
0.6%
5 2
 
0.2%
6 5
 
0.4%
ValueCountFrequency (%)
70 4
 
0.3%
49 1
 
0.1%
48 1
 
0.1%
42 7
0.6%
35 7
0.6%
28 16
1.4%
24 1
 
0.1%
21 12
1.0%
20 1
 
0.1%
18 1
 
0.1%

no_of_hours_ac_was_on_during_night_last_week
Real number (ℝ)

Zeros 

Distinct65
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.361085
Minimum0
Maximum98
Zeros499
Zeros (%)42.6%
Negative0
Negative (%)0.0%
Memory size9.3 KiB
2024-12-06T11:24:58.811773image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median4
Q330
95-th percentile70
Maximum98
Range98
Interquartile range (IQR)30

Descriptive statistics

Standard deviation23.892416
Coefficient of variation (CV)1.3762053
Kurtosis1.0044618
Mean17.361085
Median Absolute Deviation (MAD)4
Skewness1.3788235
Sum20329.83
Variance570.84753
MonotonicityNot monotonic
2024-12-06T11:24:58.928657image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 499
42.6%
14 87
 
7.4%
42 63
 
5.4%
7 61
 
5.2%
56 60
 
5.1%
21 40
 
3.4%
28 39
 
3.3%
35 27
 
2.3%
70 24
 
2.0%
30 23
 
2.0%
Other values (55) 248
21.2%
ValueCountFrequency (%)
0 499
42.6%
0.25 3
 
0.3%
0.5 4
 
0.3%
0.75 1
 
0.1%
0.99 1
 
0.1%
1 19
 
1.6%
1.5 3
 
0.3%
1.66 1
 
0.1%
1.75 1
 
0.1%
2 18
 
1.5%
ValueCountFrequency (%)
98 14
1.2%
90 1
 
0.1%
86 1
 
0.1%
85 1
 
0.1%
84 10
0.9%
81 1
 
0.1%
80 3
 
0.3%
77 2
 
0.2%
72 2
 
0.2%
70.5 1
 
0.1%

Interactions

2024-12-06T11:24:56.067674image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.048939image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.409002image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.728231image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:56.154055image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.149204image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.493912image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.816802image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:56.231720image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.236213image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.568597image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.897693image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:56.317199image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.324692image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.650481image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
2024-12-06T11:24:55.984420image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/

Correlations

2024-12-06T11:24:59.233782image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
btu_of_the_acis_room_fully_sealedis_the_ac_inverter_or_notno_of_hours_ac_was_on_during_daytime_last_weekno_of_hours_ac_was_on_during_night_last_weekroom_IDtype_of_the_acwattage_of_the_ac
btu_of_the_ac1.0000.0900.0420.0560.1890.1520.230-0.171
is_room_fully_sealed0.0901.0000.0000.0000.0850.0850.2210.169
is_the_ac_inverter_or_not0.0420.0001.0000.0000.1010.1220.2590.000
no_of_hours_ac_was_on_during_daytime_last_week0.0560.0000.0001.0000.2330.0840.0400.039
no_of_hours_ac_was_on_during_night_last_week0.1890.0850.1010.2331.0000.0000.0710.200
room_ID0.1520.0850.1220.0840.0001.0000.1010.059
type_of_the_ac0.2300.2210.2590.0400.0710.1011.0000.114
wattage_of_the_ac-0.1710.1690.0000.0390.2000.0590.1141.000

Missing values

2024-12-06T11:24:56.426888image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-12-06T11:24:56.563214image/svg+xmlMatplotlib v3.9.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

household_IDroom_IDac_IDtype_of_the_acis_the_ac_inverter_or_notis_room_fully_sealedwattage_of_the_acbtu_of_the_acno_of_hours_ac_was_on_during_daytime_last_weekno_of_hours_ac_was_on_during_night_last_week
0ID0012I3I3_AC1Individual AC with one componentYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.1500.0NaN0.045.0
1ID0014I3I3_AC1OtherNoThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.0NaN0.00.0
2ID0018I5I5_AC1Individual AC with two componentsYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.2000.0NaN0.056.0
3ID0025I2I2_AC1Central AC (Only to your Household)YesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.0NaN0.00.0
4ID0039I8I8_AC1Individual AC with two componentsYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.0NaN12.012.0
5ID0039I9I9_AC1Individual AC with two componentsYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.09000.012.012.0
6ID0041I8I8_AC1Air CoolerYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.0NaN0.021.0
7ID0043I3I3_AC1Individual AC with two componentsNoThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.0NaN0.00.0
8ID0043I18I18_AC1Individual AC with two componentsNoThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.0NaN42.021.0
9ID0043I19I19_AC1Individual AC with two componentsNoThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.0.0NaN42.042.0
household_IDroom_IDac_IDtype_of_the_acis_the_ac_inverter_or_notis_room_fully_sealedwattage_of_the_acbtu_of_the_acno_of_hours_ac_was_on_during_daytime_last_weekno_of_hours_ac_was_on_during_night_last_week
1161ID3910I3I3_AC1Individual AC with two componentsYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaN12000.00.056.0
1162ID3910I13I13_AC1Individual AC with two componentsNoThe room is not fully closed. There are spaces where the cool air can leak out.NaN12000.00.04.0
1163ID3910I14I14_AC1Individual AC with two componentsYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaN12000.00.021.0
1164ID3910I15I15_AC1Individual AC with two componentsYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaN12000.00.00.0
1165ID3943I2I2_AC1Central AC (Only to your Household)NoThe room is fully closed. However, it is not fully sealed. Therefore, when the AC is on, the cool air may leak through the spaces that are not sealed such as the space in-between the door and the door frame.NaNNaN0.00.0
1166ID3950I1I1_AC1Individual AC with one componentNoThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaN1000.00.02.0
1167ID4015I2I2_AC1Individual AC with one componentYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaNNaN0.00.0
1168ID4026I2I2_AC1Individual AC with one componentYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaNNaN0.02.0
1169ID4053I2I2_AC1Individual AC with one componentNoThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaN1000.07.07.0
1170ID4055I4I4_AC1Individual AC with one componentYesThe room can be fully closed and sealed and there are no outside openings. When the AC is turned on, the cool air does not go out of the room.NaN1000.00.00.0