# Overview

Brought to you by YData

Dataset statistics

Number of variables | 6
Number of observations | 10938
Missing cells | 2
Missing cells (%) | < 0.1%
Duplicate rows | 0
Duplicate rows (%) | 0.0%
Total size in memory | 512.8 KiB
Average record size in memory | 48.0 B

Variable types

Text | 2
Categorical | 2
Numeric | 2

Alerts

`no_of_hours_bulbs_was_on_during_daytime_last_week` has 3422 (31.3%) zeros | Zeros
`no_of_hours_bulbs_was_on_during_night_last_week` has 6756 (61.8%) zeros | Zeros

Reproduction

Analysis started | 2025-02-27 04:41:29.769585
Analysis finished | 2025-02-27 04:41:30.682763
Duration | 0.91 seconds
Software version | ydata-profiling vv4.11.0
Download configuration | config.json

# Variables

household_ID
Text

Distinct | 3295
Distinct (%) | 30.1%
Missing | 2
Missing (%) | < 0.1%
Memory size | 85.6 KiB

Length

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

Characters and Unicode

Total characters | 65616
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 | 542 ?
Unique (%) | 5.0%

Sample

1st row | ID2464
2nd row | ID2464
3rd row | ID2464
4th row | ID0430
5th row | ID0430

Value | Count | Frequency (%)
id0278 | 64 | 0.6%
id2033 | 45 | 0.4%
id1841 | 33 | 0.3%
id2969 | 30 | 0.3%
id0622 | 26 | 0.2%
id0282 | 26 | 0.2%
id0069 | 24 | 0.2%
id3899 | 22 | 0.2%
id2950 | 21 | 0.2%
id2985 | 20 | 0.2%
Other values (3285) | 10625 | 97.2%

#### Most occurring characters

Value | Count | Frequency (%)
I | 10936 | 16.7%
D | 10936 | 16.7%
0 | 6305 | 9.6%
2 | 6058 | 9.2%
3 | 6030 | 9.2%
1 | 5781 | 8.8%
6 | 3308 | 5.0%
7 | 3296 | 5.0%
4 | 3283 | 5.0%
9 | 3279 | 5.0%
Other values (2) | 6404 | 9.8%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 10936 | 16.7%
D | 10936 | 16.7%
0 | 6305 | 9.6%
2 | 6058 | 9.2%
3 | 6030 | 9.2%
1 | 5781 | 8.8%
6 | 3308 | 5.0%
7 | 3296 | 5.0%
4 | 3283 | 5.0%
9 | 3279 | 5.0%
Other values (2) | 6404 | 9.8%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 10936 | 16.7%
D | 10936 | 16.7%
0 | 6305 | 9.6%
2 | 6058 | 9.2%
3 | 6030 | 9.2%
1 | 5781 | 8.8%
6 | 3308 | 5.0%
7 | 3296 | 5.0%
4 | 3283 | 5.0%
9 | 3279 | 5.0%
Other values (2) | 6404 | 9.8%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 10936 | 16.7%
D | 10936 | 16.7%
0 | 6305 | 9.6%
2 | 6058 | 9.2%
3 | 6030 | 9.2%
1 | 5781 | 8.8%
6 | 3308 | 5.0%
7 | 3296 | 5.0%
4 | 3283 | 5.0%
9 | 3279 | 5.0%
Other values (2) | 6404 | 9.8%

ROOM_ID
Categorical

Distinct | 26
Distinct (%) | 0.2%
Missing | 0
Missing (%) | 0.0%
Memory size | 85.6 KiB

I1 | 2972
I2 | 2717
I3 | 2123
I4 | 1242
I5 | 647
Other values (21) | 1237

Length

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

Characters and Unicode

Total characters | 22211
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 | 5 ?
Unique (%) | < 0.1%

Sample

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

#### Common Values

Value | Count | Frequency (%)
I1 | 2972 | 27.2%
I2 | 2717 | 24.8%
I3 | 2123 | 19.4%
I4 | 1242 | 11.4%
I5 | 647 | 5.9%
I6 | 400 | 3.7%
I7 | 255 | 2.3%
I8 | 175 | 1.6%
I9 | 118 | 1.1%
I10 | 88 | 0.8%
Other values (16) | 201 | 1.8%

#### Length

Histogram of lengths of the category

Value | Count | Frequency (%)
i1 | 2972 | 27.2%
i2 | 2717 | 24.8%
i3 | 2123 | 19.4%
i4 | 1242 | 11.4%
i5 | 647 | 5.9%
i6 | 400 | 3.7%
i7 | 255 | 2.3%
i8 | 175 | 1.6%
i9 | 118 | 1.1%
i10 | 88 | 0.8%
Other values (16) | 201 | 1.8%

#### Most occurring characters

Value | Count | Frequency (%)
I | 10938 | 49.2%
1 | 3311 | 14.9%
2 | 2751 | 12.4%
3 | 2158 | 9.7%
4 | 1264 | 5.7%
5 | 665 | 3.0%
6 | 408 | 1.8%
7 | 260 | 1.2%
8 | 178 | 0.8%
9 | 120 | 0.5%
Other values (4) | 158 | 0.7%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 10938 | 49.2%
1 | 3311 | 14.9%
2 | 2751 | 12.4%
3 | 2158 | 9.7%
4 | 1264 | 5.7%
5 | 665 | 3.0%
6 | 408 | 1.8%
7 | 260 | 1.2%
8 | 178 | 0.8%
9 | 120 | 0.5%
Other values (4) | 158 | 0.7%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 10938 | 49.2%
1 | 3311 | 14.9%
2 | 2751 | 12.4%
3 | 2158 | 9.7%
4 | 1264 | 5.7%
5 | 665 | 3.0%
6 | 408 | 1.8%
7 | 260 | 1.2%
8 | 178 | 0.8%
9 | 120 | 0.5%
Other values (4) | 158 | 0.7%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 10938 | 49.2%
1 | 3311 | 14.9%
2 | 2751 | 12.4%
3 | 2158 | 9.7%
4 | 1264 | 5.7%
5 | 665 | 3.0%
6 | 408 | 1.8%
7 | 260 | 1.2%
8 | 178 | 0.8%
9 | 120 | 0.5%
Other values (4) | 158 | 0.7%

FAN_ID
Text

Distinct | 97
Distinct (%) | 0.9%
Missing | 0
Missing (%) | 0.0%
Memory size | 85.6 KiB

Length

Max length | 8
Median length | 5
Mean length | 5.03081
Min length | 5

Characters and Unicode

Total characters | 55027
Distinct characters | 16
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 | 41 ?
Unique (%) | 0.4%

Sample

1st row | I1_F1
2nd row | I2_F1
3rd row | I3_F1
4th row | I1_F1
5th row | I2_F1

Value | Count | Frequency (%)
i2_f1 | 2567 | 23.5%
i1_f1 | 2456 | 22.5%
i3_f1 | 2023 | 18.5%
i4_f1 | 1171 | 10.7%
i5_f1 | 594 | 5.4%
i1_f2 | 432 | 3.9%
i6_f1 | 351 | 3.2%
i7_f1 | 223 | 2.0%
i8_f1 | 147 | 1.3%
i2_f2 | 135 | 1.2%
Other values (87) | 839 | 7.7%

#### Most occurring characters

Value | Count | Frequency (%)
1 | 13180 | 24.0%
I | 10938 | 19.9%
F | 10938 | 19.9%
_ | 10938 | 19.9%
2 | 3611 | 6.6%
3 | 2311 | 4.2%
4 | 1289 | 2.3%
5 | 679 | 1.2%
6 | 421 | 0.8%
7 | 262 | 0.5%
Other values (6) | 460 | 0.8%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
1 | 13180 | 24.0%
I | 10938 | 19.9%
F | 10938 | 19.9%
_ | 10938 | 19.9%
2 | 3611 | 6.6%
3 | 2311 | 4.2%
4 | 1289 | 2.3%
5 | 679 | 1.2%
6 | 421 | 0.8%
7 | 262 | 0.5%
Other values (6) | 460 | 0.8%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
1 | 13180 | 24.0%
I | 10938 | 19.9%
F | 10938 | 19.9%
_ | 10938 | 19.9%
2 | 3611 | 6.6%
3 | 2311 | 4.2%
4 | 1289 | 2.3%
5 | 679 | 1.2%
6 | 421 | 0.8%
7 | 262 | 0.5%
Other values (6) | 460 | 0.8%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
1 | 13180 | 24.0%
I | 10938 | 19.9%
F | 10938 | 19.9%
_ | 10938 | 19.9%
2 | 3611 | 6.6%
3 | 2311 | 4.2%
4 | 1289 | 2.3%
5 | 679 | 1.2%
6 | 421 | 0.8%
7 | 262 | 0.5%
Other values (6) | 460 | 0.8%

type_of_the_fan
Categorical

Distinct | 7
Distinct (%) | 0.1%
Missing | 0
Missing (%) | 0.0%
Memory size | 85.6 KiB

Ceiling fan | 5820
Pedestal fan/ Stand fan | 4044
Wall fan | 447
Table fan | 384
Other | 217
Other values (2) | 26

Length

Max length | 24
Median length | 11
Mean length | 15.494332
Min length | 5

Characters and Unicode

Total characters | 169477
Distinct characters | 26
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 | 1 ?
Unique (%) | < 0.1%

Sample

1st row | Ceiling fan
2nd row | Table fan
3rd row | Pedestal fan/ Stand fan
4th row | Wall fan
5th row | Ceiling fan

#### Common Values

Value | Count | Frequency (%)
Ceiling fan | 5820 | 53.2%
Pedestal fan/ Stand fan | 4044 | 37.0%
Wall fan | 447 | 4.1%
Table fan | 384 | 3.5%
Other | 217 | 2.0%
Exhaust fan | 25 | 0.2%
Tower fan | 1 | < 0.1%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
fan | 14765 | 49.6%
ceiling | 5820 | 19.6%
pedestal | 4044 | 13.6%
stand | 4044 | 13.6%
wall | 447 | 1.5%
table | 384 | 1.3%
other | 217 | 0.7%
exhaust | 25 | 0.1%
tower | 1 | < 0.1%

#### Most occurring characters

Value | Count | Frequency (%)
n | 24629 | 14.5%
a | 23709 | 14.0%
| 22853 | 13.5%
f | 14765 | 8.7%
e | 14510 | 8.6%
i | 11640 | 6.9%
l | 11142 | 6.6%
t | 8330 | 4.9%
d | 8088 | 4.8%
C | 5820 | 3.4%
Other values (16) | 23991 | 14.2%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
n | 24629 | 14.5%
a | 23709 | 14.0%
| 22853 | 13.5%
f | 14765 | 8.7%
e | 14510 | 8.6%
i | 11640 | 6.9%
l | 11142 | 6.6%
t | 8330 | 4.9%
d | 8088 | 4.8%
C | 5820 | 3.4%
Other values (16) | 23991 | 14.2%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
n | 24629 | 14.5%
a | 23709 | 14.0%
| 22853 | 13.5%
f | 14765 | 8.7%
e | 14510 | 8.6%
i | 11640 | 6.9%
l | 11142 | 6.6%
t | 8330 | 4.9%
d | 8088 | 4.8%
C | 5820 | 3.4%
Other values (16) | 23991 | 14.2%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
n | 24629 | 14.5%
a | 23709 | 14.0%
| 22853 | 13.5%
f | 14765 | 8.7%
e | 14510 | 8.6%
i | 11640 | 6.9%
l | 11142 | 6.6%
t | 8330 | 4.9%
d | 8088 | 4.8%
C | 5820 | 3.4%
Other values (16) | 23991 | 14.2%

no_of_hours_bulbs_was_on_during_daytime_last_week
Real number (ℝ)

Zeros

Distinct | 137
Distinct (%) | 1.3%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 29.927639

Minimum | 0
Maximum | 98
Zeros | 3422
Zeros (%) | 31.3%
Negative | 0
Negative (%) | 0.0%
Memory size | 85.6 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 29.130752
Coefficient of variation (CV) | 0.97337289
Kurtosis | -1.0001231
Mean | 29.927639
Median Absolute Deviation (MAD) | 21
Skewness | 0.49790825
Sum | 327348.51
Variance | 848.6007
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=50)

Value | Count | Frequency (%)
0 | 3422 | 31.3%
56 | 1409 | 12.9%
70 | 631 | 5.8%
14 | 548 | 5.0%
28 | 518 | 4.7%
21 | 458 | 4.2%
35 | 423 | 3.9%
7 | 337 | 3.1%
49 | 317 | 2.9%
63 | 301 | 2.8%
Other values (127) | 2574 | 23.5%

Value | Count | Frequency (%)
0 | 3422 | 31.3%
0.05 | 2 | < 0.1%
0.1 | 1 | < 0.1%
0.2 | 2 | < 0.1%
0.25 | 12 | 0.1%
0.33 | 3 | < 0.1%
0.35 | 2 | < 0.1%
0.5 | 26 | 0.2%
0.66 | 4 | < 0.1%
0.75 | 1 | < 0.1%

Value | Count | Frequency (%)
98 | 287 | 2.6%
96 | 4 | < 0.1%
95 | 3 | < 0.1%
91 | 18 | 0.2%
90 | 33 | 0.3%
88 | 2 | < 0.1%
87.5 | 3 | < 0.1%
85 | 3 | < 0.1%
84 | 168 | 1.5%
83 | 2 | < 0.1%

no_of_hours_bulbs_was_on_during_night_last_week
Real number (ℝ)

Zeros

Distinct | 96
Distinct (%) | 0.9%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 7.4534636

Minimum | 0
Maximum | 70
Zeros | 6756
Zeros (%) | 61.8%
Negative | 0
Negative (%) | 0.0%
Memory size | 85.6 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 14.233828
Coefficient of variation (CV) | 1.909693
Kurtosis | 7.1695732
Mean | 7.4534636
Median Absolute Deviation (MAD) | 0
Skewness | 2.5996112
Sum | 81525.985
Variance | 202.60185
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=50)

Value | Count | Frequency (%)
0 | 6756 | 61.8%
14 | 1060 | 9.7%
7 | 553 | 5.1%
21 | 443 | 4.1%
28 | 350 | 3.2%
70 | 207 | 1.9%
35 | 187 | 1.7%
1 | 141 | 1.3%
2 | 139 | 1.3%
3 | 89 | 0.8%
Other values (86) | 1013 | 9.3%

Value | Count | Frequency (%)
0 | 6756 | 61.8%
0.16 | 1 | < 0.1%
0.2 | 3 | < 0.1%
0.25 | 9 | 0.1%
0.33 | 1 | < 0.1%
0.35 | 1 | < 0.1%
0.5 | 22 | 0.2%
0.63 | 1 | < 0.1%
0.75 | 1 | < 0.1%
0.99 | 2 | < 0.1%

Value | Count | Frequency (%)
70 | 207 | 1.9%
69 | 1 | < 0.1%
68 | 4 | < 0.1%
66 | 1 | < 0.1%
65 | 2 | < 0.1%
64 | 1 | < 0.1%
63 | 15 | 0.1%
60 | 23 | 0.2%
58 | 2 | < 0.1%
57 | 2 | < 0.1%

# Interactions

# Correlations

| ROOM_ID | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week | type_of_the_fan
--- | --- | --- | --- | ---
ROOM_ID | 1.000 | 0.142 | 0.048 | 0.107
no_of_hours_bulbs_was_on_during_daytime_last_week | 0.142 | 1.000 | 0.231 | 0.138
no_of_hours_bulbs_was_on_during_night_last_week | 0.048 | 0.231 | 1.000 | 0.041
type_of_the_fan | 0.107 | 0.138 | 0.041 | 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 | FAN_ID | type_of_the_fan | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week
--- | --- | --- | --- | --- | --- | ---
0 | ID2464 | I1 | I1_F1 | Ceiling fan | 0.0 | 0.0
1 | ID2464 | I2 | I2_F1 | Table fan | 56.0 | 0.0
2 | ID2464 | I3 | I3_F1 | Pedestal fan/ Stand fan | 63.0 | 0.0
3 | ID0430 | I1 | I1_F1 | Wall fan | 0.0 | 0.0
4 | ID0430 | I2 | I2_F1 | Ceiling fan | 56.0 | 0.0
5 | ID0424 | I1 | I1_F1 | Pedestal fan/ Stand fan | 14.0 | 0.0
6 | ID0424 | I3 | I3_F1 | Pedestal fan/ Stand fan | 59.5 | 0.0
7 | ID0528 | I1 | I1_F1 | Ceiling fan | 10.5 | 0.0
8 | ID0528 | I1 | I1_F2 | Ceiling fan | 0.0 | 0.0
9 | ID0528 | I2 | I2_F1 | Ceiling fan | 18.0 | 10.5

| household_ID | ROOM_ID | FAN_ID | type_of_the_fan | no_of_hours_bulbs_was_on_during_daytime_last_week | no_of_hours_bulbs_was_on_during_night_last_week
--- | --- | --- | --- | --- | --- | ---
10928 | ID1667 | I2 | I2_F1 | Pedestal fan/ Stand fan | 0.0 | 0.0
10929 | ID1667 | I3 | I3_F1 | Pedestal fan/ Stand fan | 16.0 | 0.0
10930 | ID1667 | I4 | I4_F1 | Pedestal fan/ Stand fan | 0.0 | 0.0
10931 | ID1667 | I5 | I5_F1 | Pedestal fan/ Stand fan | 0.0 | 0.0
10932 | ID1667 | I6 | I6_F1 | Pedestal fan/ Stand fan | 0.0 | 0.0
10933 | ID1667 | I8 | I8_F1 | Ceiling fan | 0.0 | 0.0
10934 | ID0589 | I1 | I1_F1 | Ceiling fan | 0.0 | 0.0
10935 | ID0589 | I1 | I1_F2 | Table fan | 70.0 | 21.0
10936 | ID0426 | I1 | I1_F1 | Pedestal fan/ Stand fan | 56.0 | 1.0
10937 | ID0426 | I2 | I2_F1 | Pedestal fan/ Stand fan | 42.0 | 0.0