# Overview

Brought to you by YData

Dataset statistics

Number of variables | 5
Number of observations | 35010
Missing cells | 34771
Missing cells (%) | 19.9%
Duplicate rows | 0
Duplicate rows (%) | 0.0%
Total size in memory | 1.3 MiB
Average record size in memory | 40.0 B

Variable types

Text | 1
Categorical | 2
Numeric | 1
Boolean | 1

Alerts

`is_there_change_of_no_of_rooms_of_each_type` is highly overall correlated with `new_no_of_rooms` | High correlation
`new_no_of_rooms` is highly overall correlated with `is_there_change_of_no_of_rooms_of_each_type` | High correlation
`is_there_change_of_no_of_rooms_of_each_type` is highly imbalanced (93.9%) | Imbalance
`new_no_of_rooms` has 34761 (99.3%) missing values | Missing
`Room_Type` is uniformly distributed | Uniform
`no_of_rooms_in_w1` has 15214 (43.5%) zeros | Zeros

Reproduction

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

# Variables

household_ID
Text

Distinct | 3500
Distinct (%) | 10.0%
Missing | 10
Missing (%) | < 0.1%
Memory size | 273.6 KiB

Length

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

Characters and Unicode

Total characters | 210000
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 | 0 ?
Unique (%) | 0.0%

Sample

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

Value | Count | Frequency (%)
id0759 | 10 | < 0.1%
id0426 | 10 | < 0.1%
id2464 | 10 | < 0.1%
id0430 | 10 | < 0.1%
id0424 | 10 | < 0.1%
id0528 | 10 | < 0.1%
id0427 | 10 | < 0.1%
id0886 | 10 | < 0.1%
id0041 | 10 | < 0.1%
id0039 | 10 | < 0.1%
Other values (3490) | 34900 | 99.7%

#### Most occurring characters

Value | Count | Frequency (%)
I | 35000 | 16.7%
D | 35000 | 16.7%
0 | 19750 | 9.4%
3 | 19230 | 9.2%
2 | 19100 | 9.1%
1 | 18960 | 9.0%
4 | 10940 | 5.2%
9 | 10590 | 5.0%
5 | 10560 | 5.0%
6 | 10510 | 5.0%
Other values (2) | 20360 | 9.7%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 35000 | 16.7%
D | 35000 | 16.7%
0 | 19750 | 9.4%
3 | 19230 | 9.2%
2 | 19100 | 9.1%
1 | 18960 | 9.0%
4 | 10940 | 5.2%
9 | 10590 | 5.0%
5 | 10560 | 5.0%
6 | 10510 | 5.0%
Other values (2) | 20360 | 9.7%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 35000 | 16.7%
D | 35000 | 16.7%
0 | 19750 | 9.4%
3 | 19230 | 9.2%
2 | 19100 | 9.1%
1 | 18960 | 9.0%
4 | 10940 | 5.2%
9 | 10590 | 5.0%
5 | 10560 | 5.0%
6 | 10510 | 5.0%
Other values (2) | 20360 | 9.7%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 35000 | 16.7%
D | 35000 | 16.7%
0 | 19750 | 9.4%
3 | 19230 | 9.2%
2 | 19100 | 9.1%
1 | 18960 | 9.0%
4 | 10940 | 5.2%
9 | 10590 | 5.0%
5 | 10560 | 5.0%
6 | 10510 | 5.0%
Other values (2) | 20360 | 9.7%

Room_Type
Categorical

Uniform

Distinct | 10
Distinct (%) | < 0.1%
Missing | 0
Missing (%) | 0.0%
Memory size | 273.6 KiB

Living room | 3501
Bedrooms | 3501
Kitchen and/or pantry / dining room | 3501
Bathroom and/or toilets | 3501
Storage room | 3501
Other values (5) | 17505

Length

Max length | 89
Median length | 18
Mean length | 27.9
Min length | 6

Characters and Unicode

Total characters | 976779
Distinct characters | 34
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 | Living room
2nd row | Bedrooms
3rd row | Kitchen and/or pantry / dining room
4th row | Bathroom and/or toilets
5th row | Storage room

#### Common Values

Value | Count | Frequency (%)
Living room | 3501 | 10.0%
Bedrooms | 3501 | 10.0%
Kitchen and/or pantry / dining room | 3501 | 10.0%
Bathroom and/or toilets | 3501 | 10.0%
Storage room | 3501 | 10.0%
Other rooms / parts in the house including passages, verandas, balconies, staircase, etc. | 3501 | 10.0%
Garage | 3501 | 10.0%
Security Room | 3501 | 10.0%
Garden (including the wall around the garden, if any) | 3501 | 10.0%
Other rooms outside the house | 3501 | 10.0%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
room | 14004 | 9.1%
the | 14004 | 9.1%
| 7002 | 4.5%
other | 7002 | 4.5%
rooms | 7002 | 4.5%
house | 7002 | 4.5%
and/or | 7002 | 4.5%
garden | 7002 | 4.5%
including | 7002 | 4.5%
dining | 3501 | 2.3%
Other values (21) | 73521 | 47.7%

#### Most occurring characters

Value | Count | Frequency (%)
| 119034 | 12.2%
o | 87525 | 9.0%
e | 77022 | 7.9%
r | 73521 | 7.5%
a | 70020 | 7.2%
n | 63018 | 6.5%
t | 59517 | 6.1%
i | 56016 | 5.7%
s | 52515 | 5.4%
d | 38511 | 3.9%
Other values (24) | 280080 | 28.7%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 119034 | 12.2%
o | 87525 | 9.0%
e | 77022 | 7.9%
r | 73521 | 7.5%
a | 70020 | 7.2%
n | 63018 | 6.5%
t | 59517 | 6.1%
i | 56016 | 5.7%
s | 52515 | 5.4%
d | 38511 | 3.9%
Other values (24) | 280080 | 28.7%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 119034 | 12.2%
o | 87525 | 9.0%
e | 77022 | 7.9%
r | 73521 | 7.5%
a | 70020 | 7.2%
n | 63018 | 6.5%
t | 59517 | 6.1%
i | 56016 | 5.7%
s | 52515 | 5.4%
d | 38511 | 3.9%
Other values (24) | 280080 | 28.7%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 119034 | 12.2%
o | 87525 | 9.0%
e | 77022 | 7.9%
r | 73521 | 7.5%
a | 70020 | 7.2%
n | 63018 | 6.5%
t | 59517 | 6.1%
i | 56016 | 5.7%
s | 52515 | 5.4%
d | 38511 | 3.9%
Other values (24) | 280080 | 28.7%

no_of_rooms_in_w1
Real number (ℝ)

Zeros

Distinct | 14
Distinct (%) | < 0.1%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 0.89697229

Minimum | 0
Maximum | 13
Zeros | 15214
Zeros (%) | 43.5%
Negative | 0
Negative (%) | 0.0%
Memory size | 273.6 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 1.09088
Coefficient of variation (CV) | 1.2161802
Kurtosis | 6.3665014
Mean | 0.89697229
Median Absolute Deviation (MAD) | 1
Skewness | 1.9104891
Sum | 31403
Variance | 1.1900191
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=14)

Value | Count | Frequency (%)
0 | 15214 | 43.5%
1 | 12830 | 36.6%
2 | 4061 | 11.6%
3 | 1822 | 5.2%
4 | 717 | 2.0%
5 | 225 | 0.6%
6 | 72 | 0.2%
7 | 29 | 0.1%
8 | 21 | 0.1%
9 | 8 | < 0.1%
Other values (4) | 11 | < 0.1%

Value | Count | Frequency (%)
0 | 15214 | 43.5%
1 | 12830 | 36.6%
2 | 4061 | 11.6%
3 | 1822 | 5.2%
4 | 717 | 2.0%
5 | 225 | 0.6%
6 | 72 | 0.2%
7 | 29 | 0.1%
8 | 21 | 0.1%
9 | 8 | < 0.1%

Value | Count | Frequency (%)
13 | 1 | < 0.1%
12 | 1 | < 0.1%
11 | 2 | < 0.1%
10 | 7 | < 0.1%
9 | 8 | < 0.1%
8 | 21 | 0.1%
7 | 29 | 0.1%
6 | 72 | 0.2%
5 | 225 | 0.6%
4 | 717 | 2.0%

is_there_change_of_no_of_rooms_of_each_type
Boolean

High correlation Imbalance

Distinct | 2
Distinct (%) | < 0.1%
Missing | 0
Missing (%) | 0.0%
Memory size | 34.3 KiB

False | 34761
True | 249

Value | Count | Frequency (%)
False | 34761 | 99.3%
True | 249 | 0.7%

new_no_of_rooms
Categorical

High correlation Missing

Distinct | 4
Distinct (%) | 1.6%
Missing | 34761
Missing (%) | 99.3%
Memory size | 273.6 KiB

1.0 | 182
2.0 | 41
3.0 | 22
4.0 | 4

Length

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

Characters and Unicode

Total characters | 747
Distinct characters | 6
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 | 3.0
5th row | 1.0

#### Common Values

Value | Count | Frequency (%)
1.0 | 182 | 0.5%
2.0 | 41 | 0.1%
3.0 | 22 | 0.1%
4.0 | 4 | < 0.1%
(Missing) | 34761 | 99.3%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
1.0 | 182 | 73.1%
2.0 | 41 | 16.5%
3.0 | 22 | 8.8%
4.0 | 4 | 1.6%

#### Most occurring characters

Value | Count | Frequency (%)
. | 249 | 33.3%
0 | 249 | 33.3%
1 | 182 | 24.4%
2 | 41 | 5.5%
3 | 22 | 2.9%
4 | 4 | 0.5%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
. | 249 | 33.3%
0 | 249 | 33.3%
1 | 182 | 24.4%
2 | 41 | 5.5%
3 | 22 | 2.9%
4 | 4 | 0.5%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
. | 249 | 33.3%
0 | 249 | 33.3%
1 | 182 | 24.4%
2 | 41 | 5.5%
3 | 22 | 2.9%
4 | 4 | 0.5%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
. | 249 | 33.3%
0 | 249 | 33.3%
1 | 182 | 24.4%
2 | 41 | 5.5%
3 | 22 | 2.9%
4 | 4 | 0.5%

# Interactions

# Correlations

| Room_Type | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms | no_of_rooms_in_w1
--- | --- | --- | --- | ---
Room_Type | 1.000 | 0.094 | 0.259 | 0.225
is_there_change_of_no_of_rooms_of_each_type | 0.094 | 1.000 | 1.000 | 0.422
new_no_of_rooms | 0.259 | 1.000 | 1.000 | 0.389
no_of_rooms_in_w1 | 0.225 | 0.422 | 0.389 | 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.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

# Sample

| household_ID | Room_Type | no_of_rooms_in_w1 | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms
--- | --- | --- | --- | --- | ---
0 | ID2464 | Living room | 1 | No | NaN
1 | ID2464 | Bedrooms | 3 | No | NaN
2 | ID2464 | Kitchen and/or pantry / dining room | 1 | No | NaN
3 | ID2464 | Bathroom and/or toilets | 1 | No | NaN
4 | ID2464 | Storage room | 0 | No | NaN
5 | ID2464 | Other rooms / parts in the house including passages, verandas, balconies, staircase, etc. | 2 | No | NaN
6 | ID2464 | Garage | 0 | No | NaN
7 | ID2464 | Security Room | 0 | No | NaN
8 | ID2464 | Garden (including the wall around the garden, if any) | 0 | No | NaN
9 | ID2464 | Other rooms outside the house | 2 | No | NaN

| household_ID | Room_Type | no_of_rooms_in_w1 | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms
--- | --- | --- | --- | --- | ---
35000 | ID0426 | Living room | 1 | No | NaN
35001 | ID0426 | Bedrooms | 1 | No | NaN
35002 | ID0426 | Kitchen and/or pantry / dining room | 1 | No | NaN
35003 | ID0426 | Bathroom and/or toilets | 1 | No | NaN
35004 | ID0426 | Storage room | 0 | No | NaN
35005 | ID0426 | Other rooms / parts in the house including passages, verandas, balconies, staircase, etc. | 0 | No | NaN
35006 | ID0426 | Garage | 0 | No | NaN
35007 | ID0426 | Security Room | 0 | No | NaN
35008 | ID0426 | Garden (including the wall around the garden, if any) | 0 | No | NaN
35009 | ID0426 | Other rooms outside the house | 0 | No | NaN