# Overview

Brought to you by YData

Dataset statistics

Number of variables | 5
Number of observations | 33980
Missing cells | 33236
Missing cells (%) | 19.6%
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 | 1
Numeric | 2
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 (98.5%) | Imbalance
`new_no_of_rooms` has 33226 (97.8%) missing values | Missing
`Room_Type` is uniformly distributed | Uniform
`no_of_rooms_in_w2` has 15632 (46.0%) zeros | Zeros
`new_no_of_rooms` has 707 (2.1%) zeros | Zeros

Reproduction

Analysis started | 2025-02-27 04:59:24.066587
Analysis finished | 2025-02-27 04:59:24.909661
Duration | 0.84 seconds
Software version | ydata-profiling vv4.11.0
Download configuration | config.json

# Variables

household_ID
Text

Distinct | 3397
Distinct (%) | 10.0%
Missing | 10
Missing (%) | < 0.1%
Memory size | 265.6 KiB

Length

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

Characters and Unicode

Total characters | 203820
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 | ID0726
2nd row | ID0726
3rd row | ID0726
4th row | ID0726
5th row | ID0726

Value | Count | Frequency (%)
id0020 | 10 | < 0.1%
id1050 | 10 | < 0.1%
id0726 | 10 | < 0.1%
id0734 | 10 | < 0.1%
id2795 | 10 | < 0.1%
id3026 | 10 | < 0.1%
id2178 | 10 | < 0.1%
id3804 | 10 | < 0.1%
id0976 | 10 | < 0.1%
id1025 | 10 | < 0.1%
Other values (3387) | 33870 | 99.7%

#### Most occurring characters

Value | Count | Frequency (%)
I | 33970 | 16.7%
D | 33970 | 16.7%
0 | 19130 | 9.4%
3 | 18710 | 9.2%
2 | 18580 | 9.1%
1 | 18370 | 9.0%
4 | 10660 | 5.2%
5 | 10330 | 5.1%
6 | 10280 | 5.0%
9 | 10180 | 5.0%
Other values (2) | 19640 | 9.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 33970 | 16.7%
D | 33970 | 16.7%
0 | 19130 | 9.4%
3 | 18710 | 9.2%
2 | 18580 | 9.1%
1 | 18370 | 9.0%
4 | 10660 | 5.2%
5 | 10330 | 5.1%
6 | 10280 | 5.0%
9 | 10180 | 5.0%
Other values (2) | 19640 | 9.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 33970 | 16.7%
D | 33970 | 16.7%
0 | 19130 | 9.4%
3 | 18710 | 9.2%
2 | 18580 | 9.1%
1 | 18370 | 9.0%
4 | 10660 | 5.2%
5 | 10330 | 5.1%
6 | 10280 | 5.0%
9 | 10180 | 5.0%
Other values (2) | 19640 | 9.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 33970 | 16.7%
D | 33970 | 16.7%
0 | 19130 | 9.4%
3 | 18710 | 9.2%
2 | 18580 | 9.1%
1 | 18370 | 9.0%
4 | 10660 | 5.2%
5 | 10330 | 5.1%
6 | 10280 | 5.0%
9 | 10180 | 5.0%
Other values (2) | 19640 | 9.6%

Room_Type
Categorical

Uniform

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

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

Length

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

Characters and Unicode

Total characters | 948042
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 | 3398 | 10.0%
Bedrooms | 3398 | 10.0%
Kitchen and/or pantry / dining room | 3398 | 10.0%
Bathroom and/or toilets | 3398 | 10.0%
Storage room | 3398 | 10.0%
Other rooms / parts in the house including passages, verandas, balconies, staircase, etc. | 3398 | 10.0%
Garage | 3398 | 10.0%
Security Room | 3398 | 10.0%
Garden (including the wall around the garden, if any) | 3398 | 10.0%
Other rooms outside the house | 3398 | 10.0%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
room | 13592 | 9.1%
the | 13592 | 9.1%
| 6796 | 4.5%
other | 6796 | 4.5%
rooms | 6796 | 4.5%
house | 6796 | 4.5%
and/or | 6796 | 4.5%
garden | 6796 | 4.5%
including | 6796 | 4.5%
dining | 3398 | 2.3%
Other values (21) | 71358 | 47.7%

#### Most occurring characters

Value | Count | Frequency (%)
| 115532 | 12.2%
o | 84950 | 9.0%
e | 74756 | 7.9%
r | 71358 | 7.5%
a | 67960 | 7.2%
n | 61164 | 6.5%
t | 57766 | 6.1%
i | 54368 | 5.7%
s | 50970 | 5.4%
d | 37378 | 3.9%
Other values (24) | 271840 | 28.7%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 115532 | 12.2%
o | 84950 | 9.0%
e | 74756 | 7.9%
r | 71358 | 7.5%
a | 67960 | 7.2%
n | 61164 | 6.5%
t | 57766 | 6.1%
i | 54368 | 5.7%
s | 50970 | 5.4%
d | 37378 | 3.9%
Other values (24) | 271840 | 28.7%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 115532 | 12.2%
o | 84950 | 9.0%
e | 74756 | 7.9%
r | 71358 | 7.5%
a | 67960 | 7.2%
n | 61164 | 6.5%
t | 57766 | 6.1%
i | 54368 | 5.7%
s | 50970 | 5.4%
d | 37378 | 3.9%
Other values (24) | 271840 | 28.7%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 115532 | 12.2%
o | 84950 | 9.0%
e | 74756 | 7.9%
r | 71358 | 7.5%
a | 67960 | 7.2%
n | 61164 | 6.5%
t | 57766 | 6.1%
i | 54368 | 5.7%
s | 50970 | 5.4%
d | 37378 | 3.9%
Other values (24) | 271840 | 28.7%

no_of_rooms_in_w2
Real number (ℝ)

Zeros

Distinct | 12
Distinct (%) | < 0.1%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 0.82151265

Minimum | 0
Maximum | 13
Zeros | 15632
Zeros (%) | 46.0%
Negative | 0
Negative (%) | 0.0%
Memory size | 265.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.0025494
Coefficient of variation (CV) | 1.22037
Kurtosis | 4.3499201
Mean | 0.82151265
Median Absolute Deviation (MAD) | 1
Skewness | 1.6669887
Sum | 27915
Variance | 1.0051053
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=12)

Value | Count | Frequency (%)
0 | 15632 | 46.0%
1 | 12200 | 35.9%
2 | 3831 | 11.3%
3 | 1537 | 4.5%
4 | 561 | 1.7%
5 | 150 | 0.4%
6 | 51 | 0.2%
7 | 12 | < 0.1%
8 | 2 | < 0.1%
10 | 2 | < 0.1%
Other values (2) | 2 | < 0.1%

Value | Count | Frequency (%)
0 | 15632 | 46.0%
1 | 12200 | 35.9%
2 | 3831 | 11.3%
3 | 1537 | 4.5%
4 | 561 | 1.7%
5 | 150 | 0.4%
6 | 51 | 0.2%
7 | 12 | < 0.1%
8 | 2 | < 0.1%
9 | 1 | < 0.1%

Value | Count | Frequency (%)
13 | 1 | < 0.1%
10 | 2 | < 0.1%
9 | 1 | < 0.1%
8 | 2 | < 0.1%
7 | 12 | < 0.1%
6 | 51 | 0.2%
5 | 150 | 0.4%
4 | 561 | 1.7%
3 | 1537 | 4.5%
2 | 3831 | 11.3%

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 | 33.3 KiB

False | 33933
True | 47

Value | Count | Frequency (%)
False | 33933 | 99.9%
True | 47 | 0.1%

new_no_of_rooms
Real number (ℝ)

High correlation Missing Zeros

Distinct | 6
Distinct (%) | 0.8%
Missing | 33226
Missing (%) | 97.8%
Infinite | 0
Infinite (%) | 0.0%
Mean | 0.12201592

Minimum | 0
Maximum | 10
Zeros | 707
Zeros (%) | 2.1%
Negative | 0
Negative (%) | 0.0%
Memory size | 265.6 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 0.6727227
Coefficient of variation (CV) | 5.5134012
Kurtosis | 128.59763
Mean | 0.12201592
Median Absolute Deviation (MAD) | 0
Skewness | 9.9803346
Sum | 92
Variance | 0.45255582
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=6)

Value | Count | Frequency (%)
0 | 707 | 2.1%
1 | 28 | 0.1%
2 | 10 | < 0.1%
3 | 4 | < 0.1%
4 | 3 | < 0.1%
10 | 2 | < 0.1%
(Missing) | 33226 | 97.8%

Value | Count | Frequency (%)
0 | 707 | 2.1%
1 | 28 | 0.1%
2 | 10 | < 0.1%
3 | 4 | < 0.1%
4 | 3 | < 0.1%
10 | 2 | < 0.1%

Value | Count | Frequency (%)
10 | 2 | < 0.1%
4 | 3 | < 0.1%
3 | 4 | < 0.1%
2 | 10 | < 0.1%
1 | 28 | 0.1%
0 | 707 | 2.1%

# Interactions

# Correlations

| Room_Type | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms | no_of_rooms_in_w2
--- | --- | --- | --- | ---
Room_Type | 1.000 | 0.041 | 0.225 | 0.247
is_there_change_of_no_of_rooms_of_each_type | 0.041 | 1.000 | 0.620 | 0.156
new_no_of_rooms | 0.225 | 0.620 | 1.000 | 0.437
no_of_rooms_in_w2 | 0.247 | 0.156 | 0.437 | 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_w2 | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms
--- | --- | --- | --- | --- | ---
0 | ID0726 | Living room | 1 | No | NaN
1 | ID0726 | Bedrooms | 2 | No | NaN
2 | ID0726 | Kitchen and/or pantry / dining room | 1 | No | NaN
3 | ID0726 | Bathroom and/or toilets | 1 | No | NaN
4 | ID0726 | Storage room | 0 | No | NaN
5 | ID0726 | Other rooms / parts in the house including passages, verandas, balconies, staircase, etc. | 1 | No | NaN
6 | ID0726 | Garage | 0 | No | NaN
7 | ID0726 | Security Room | 0 | No | NaN
8 | ID0726 | Garden (including the wall around the garden, if any) | 0 | No | NaN
9 | ID0726 | Other rooms outside the house | 0 | No | NaN

| household_ID | Room_Type | no_of_rooms_in_w2 | is_there_change_of_no_of_rooms_of_each_type | new_no_of_rooms
--- | --- | --- | --- | --- | ---
33970 | ID1050 | Living room | 1 | No | NaN
33971 | ID1050 | Bedrooms | 2 | No | NaN
33972 | ID1050 | Kitchen and/or pantry / dining room | 2 | No | NaN
33973 | ID1050 | Bathroom and/or toilets | 2 | No | NaN
33974 | ID1050 | Storage room | 0 | No | NaN
33975 | ID1050 | Other rooms / parts in the house including passages, verandas, balconies, staircase, etc. | 1 | No | NaN
33976 | ID1050 | Garage | 0 | No | NaN
33977 | ID1050 | Security Room | 0 | No | NaN
33978 | ID1050 | Garden (including the wall around the garden, if any) | 0 | No | NaN
33979 | ID1050 | Other rooms outside the house | 1 | No | NaN