# Overview

Brought to you by YData

Dataset statistics

Number of variables | 22
Number of observations | 3398
Missing cells | 36939
Missing cells (%) | 49.4%
Duplicate rows | 0
Duplicate rows (%) | 0.0%
Total size in memory | 584.2 KiB
Average record size in memory | 176.0 B

Variable types

Text | 3
Boolean | 4
Categorical | 13
Numeric | 2

Alerts

`awareness_of_electricity_consumption_of_renters` is highly overall correlated with `own_the_house_or_living_on_rent` | High correlation
`changes_to_the_structure_of_household_after_w1` is highly overall correlated with `charged_method_for_rent_for_electricity` and 3 other fields | High correlation
`charged_method_for_rent_for_electricity` is highly overall correlated with `changes_to_the_structure_of_household_after_w1` and 1 other fields | High correlation
`charging_method_of_renters_for_electricity` is highly overall correlated with `own_the_house_or_living_on_rent` | High correlation
`is_there_any_construction_or_renovation_ongoing` is highly overall correlated with `new_no_of_storeys` and 1 other fields | High correlation
`is_there_business_carried_out_in_the_household` is highly overall correlated with `new_floor_area` and 4 other fields | High correlation
`new_electricity_meters` is highly overall correlated with `charged_method_for_rent_for_electricity` and 6 other fields | High correlation
`new_floor_area` is highly overall correlated with `is_there_business_carried_out_in_the_household` and 2 other fields | High correlation
`new_household_members` is highly overall correlated with `new_no_of_storeys` and 1 other fields | High correlation
`new_no_of_storeys` is highly overall correlated with `changes_to_the_structure_of_household_after_w1` and 9 other fields | High correlation
`new_type_of_house` is highly overall correlated with `is_there_business_carried_out_in_the_household` and 3 other fields | High correlation
`no_of_electricity_meters` is highly overall correlated with `changes_to_the_structure_of_household_after_w1` and 5 other fields | High correlation
`occupy_renters_boarders` is highly overall correlated with `new_no_of_storeys` and 1 other fields | High correlation
`own_the_house_or_living_on_rent` is highly overall correlated with `awareness_of_electricity_consumption_of_renters` and 8 other fields | High correlation
`renovations_done_after_w1` is highly overall correlated with `new_no_of_storeys` | High correlation
`renters_were_there_during_w1_or_not` is highly overall correlated with `own_the_house_or_living_on_rent` | High correlation
`since_when_renters_are_living_in_household` is highly overall correlated with `new_electricity_meters` and 2 other fields | High correlation
`smart_metered_or_non_smart_metered` is highly overall correlated with `new_no_of_storeys` and 1 other fields | High correlation
`type_of_business` is highly overall correlated with `changes_to_the_structure_of_household_after_w1` and 2 other fields | High correlation
`new_electricity_meters` is highly imbalanced (98.1%) | Imbalance
`own_the_house_or_living_on_rent` is highly imbalanced (73.3%) | Imbalance
`occupy_renters_boarders` is highly imbalanced (89.9%) | Imbalance
`changes_to_the_structure_of_household_after_w1` is highly imbalanced (96.6%) | Imbalance
`renovations_done_after_w1` is highly imbalanced (78.5%) | Imbalance
`charged_method_for_rent_for_electricity` is highly imbalanced (82.0%) | Imbalance
`is_there_business_carried_out_in_the_household` is highly imbalanced (79.2%) | Imbalance
`is_there_any_construction_or_renovation_ongoing` is highly imbalanced (85.0%) | Imbalance
`no_of_electricity_meters` has 3392 (99.8%) missing values | Missing
`occupy_renters_boarders` has 360 (10.6%) missing values | Missing
`renters_were_there_during_w1_or_not` has 3336 (98.2%) missing values | Missing
`since_when_renters_are_living_in_household` has 3377 (99.4%) missing values | Missing
`awareness_of_electricity_consumption_of_renters` has 3336 (98.2%) missing values | Missing
`new_type_of_house` has 3374 (99.3%) missing values | Missing
`new_no_of_storeys` has 3396 (99.9%) missing values | Missing
`new_floor_area` has 3374 (99.3%) missing values | Missing
`charging_method_of_renters_for_electricity` has 3336 (98.2%) missing values | Missing
`charged_method_for_rent_for_electricity` has 3037 (89.4%) missing values | Missing
`type_of_business` has 3287 (96.7%) missing values | Missing
`other_business_activity` has 3333 (98.1%) missing values | Missing
`new_no_of_storeys` is uniformly distributed | Uniform
`new_household_members` has 3140 (92.4%) zeros | Zeros

Reproduction

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

# Variables

household_ID
Text

Distinct | 3397
Distinct (%) | 100.0%
Missing | 1
Missing (%) | < 0.1%
Memory size | 26.7 KiB

Length

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

Characters and Unicode

Total characters | 20382
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 | 3397 ?
Unique (%) | 100.0%

Sample

1st row | ID0726
2nd row | ID0734
3rd row | ID2795
4th row | ID2829
5th row | ID2843

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

#### Most occurring characters

Value | Count | Frequency (%)
I | 3397 | 16.7%
D | 3397 | 16.7%
0 | 1913 | 9.4%
3 | 1871 | 9.2%
2 | 1858 | 9.1%
1 | 1837 | 9.0%
4 | 1066 | 5.2%
5 | 1033 | 5.1%
6 | 1028 | 5.0%
9 | 1018 | 5.0%
Other values (2) | 1964 | 9.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 3397 | 16.7%
D | 3397 | 16.7%
0 | 1913 | 9.4%
3 | 1871 | 9.2%
2 | 1858 | 9.1%
1 | 1837 | 9.0%
4 | 1066 | 5.2%
5 | 1033 | 5.1%
6 | 1028 | 5.0%
9 | 1018 | 5.0%
Other values (2) | 1964 | 9.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 3397 | 16.7%
D | 3397 | 16.7%
0 | 1913 | 9.4%
3 | 1871 | 9.2%
2 | 1858 | 9.1%
1 | 1837 | 9.0%
4 | 1066 | 5.2%
5 | 1033 | 5.1%
6 | 1028 | 5.0%
9 | 1018 | 5.0%
Other values (2) | 1964 | 9.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 3397 | 16.7%
D | 3397 | 16.7%
0 | 1913 | 9.4%
3 | 1871 | 9.2%
2 | 1858 | 9.1%
1 | 1837 | 9.0%
4 | 1066 | 5.2%
5 | 1033 | 5.1%
6 | 1028 | 5.0%
9 | 1018 | 5.0%
Other values (2) | 1964 | 9.6%

new_electricity_meters
Boolean

High correlation Imbalance

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

False | 3392
True | 6

Value | Count | Frequency (%)
False | 3392 | 99.8%
True | 6 | 0.2%

no_of_electricity_meters
Categorical

High correlation Missing

Distinct | 2
Distinct (%) | 33.3%
Missing | 3392
Missing (%) | 99.8%
Memory size | 26.7 KiB

2.0 | 5
4.0 | 1

Length

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

Characters and Unicode

Total characters | 18
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 | 1 ?
Unique (%) | 16.7%

Sample

1st row | 4.0
2nd row | 2.0
3rd row | 2.0
4th row | 2.0
5th row | 2.0

#### Common Values

Value | Count | Frequency (%)
2.0 | 5 | 0.1%
4.0 | 1 | < 0.1%
(Missing) | 3392 | 99.8%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
2.0 | 5 | 83.3%
4.0 | 1 | 16.7%

#### Most occurring characters

Value | Count | Frequency (%)
. | 6 | 33.3%
0 | 6 | 33.3%
2 | 5 | 27.8%
4 | 1 | 5.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
. | 6 | 33.3%
0 | 6 | 33.3%
2 | 5 | 27.8%
4 | 1 | 5.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
. | 6 | 33.3%
0 | 6 | 33.3%
2 | 5 | 27.8%
4 | 1 | 5.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
. | 6 | 33.3%
0 | 6 | 33.3%
2 | 5 | 27.8%
4 | 1 | 5.6%

own_the_house_or_living_on_rent
Categorical

High correlation Imbalance

Distinct | 4
Distinct (%) | 0.1%
Missing | 0
Missing (%) | 0.0%
Memory size | 26.7 KiB

Yes, I or a household member owns it. | 3038
No, I am living on rent and the rent is paid by me or a household member. | 333
No, I or any household member does not own or rent this household. We occupy this household without any payment of rent | 20
No, I am living on rent and the rent is paid by the employer. | 7

Length

Max length | 119
Median length | 37
Mean length | 41.060035
Min length | 37

Characters and Unicode

Total characters | 139522
Distinct characters | 28
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 | Yes, I or a household member owns it.
2nd row | Yes, I or a household member owns it.
3rd row | Yes, I or a household member owns it.
4th row | Yes, I or a household member owns it.
5th row | Yes, I or a household member owns it.

#### Common Values

Value | Count | Frequency (%)
Yes, I or a household member owns it. | 3038 | 89.4%
No, I am living on rent and the rent is paid by me or a household member. | 333 | 9.8%
No, I or any household member does not own or rent this household. We occupy this household without any payment of rent | 20 | 0.6%
No, I am living on rent and the rent is paid by the employer. | 7 | 0.2%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
household | 3431 | 11.2%
or | 3411 | 11.2%
i | 3398 | 11.1%
member | 3391 | 11.1%
a | 3371 | 11.1%
yes | 3038 | 10.0%
owns | 3038 | 10.0%
it | 3038 | 10.0%
rent | 720 | 2.4%
no | 360 | 1.2%
Other values (20) | 3307 | 10.8%

#### Most occurring characters

Value | Count | Frequency (%)
| 27105 | 19.4%
e | 14725 | 10.6%
o | 14138 | 10.1%
s | 9907 | 7.1%
r | 7529 | 5.4%
m | 7482 | 5.4%
h | 7269 | 5.2%
n | 4878 | 3.5%
i | 4458 | 3.2%
a | 4451 | 3.2%
Other values (18) | 37580 | 26.9%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 27105 | 19.4%
e | 14725 | 10.6%
o | 14138 | 10.1%
s | 9907 | 7.1%
r | 7529 | 5.4%
m | 7482 | 5.4%
h | 7269 | 5.2%
n | 4878 | 3.5%
i | 4458 | 3.2%
a | 4451 | 3.2%
Other values (18) | 37580 | 26.9%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 27105 | 19.4%
e | 14725 | 10.6%
o | 14138 | 10.1%
s | 9907 | 7.1%
r | 7529 | 5.4%
m | 7482 | 5.4%
h | 7269 | 5.2%
n | 4878 | 3.5%
i | 4458 | 3.2%
a | 4451 | 3.2%
Other values (18) | 37580 | 26.9%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 27105 | 19.4%
e | 14725 | 10.6%
o | 14138 | 10.1%
s | 9907 | 7.1%
r | 7529 | 5.4%
m | 7482 | 5.4%
h | 7269 | 5.2%
n | 4878 | 3.5%
i | 4458 | 3.2%
a | 4451 | 3.2%
Other values (18) | 37580 | 26.9%

occupy_renters_boarders
Categorical

High correlation Imbalance Missing

Distinct | 3
Distinct (%) | 0.1%
Missing | 360
Missing (%) | 10.6%
Memory size | 26.7 KiB

I don’t occupy any of the above | 2976
Renters / boarders who are living in your annexe or any other attached place, maintaining separate living conditions but | 48
Boarders who live in your house using a room/s that is attached to your living conditions. | 14

Length

Max length | 120
Median length | 31
Mean length | 32.678078
Min length | 31

Characters and Unicode

Total characters | 99276
Distinct characters | 30
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 | I don’t occupy any of the above
2nd row | I don’t occupy any of the above
3rd row | I don’t occupy any of the above
4th row | I don’t occupy any of the above
5th row | I don’t occupy any of the above

#### Common Values

Value | Count | Frequency (%)
I don’t occupy any of the above | 2976 | 87.6%
Renters / boarders who are living in your annexe or any other attached place, maintaining separate living conditions but | 48 | 1.4%
Boarders who live in your house using a room/s that is attached to your living conditions. | 14 | 0.4%
(Missing) | 360 | 10.6%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
any | 3024 | 13.8%
i | 2976 | 13.5%
don’t | 2976 | 13.5%
occupy | 2976 | 13.5%
of | 2976 | 13.5%
the | 2976 | 13.5%
above | 2976 | 13.5%
living | 110 | 0.5%
your | 76 | 0.3%
in | 62 | 0.3%
Other values (22) | 840 | 3.8%

#### Most occurring characters

Value | Count | Frequency (%)
| 18930 | 19.1%
o | 12380 | 12.5%
n | 6598 | 6.6%
a | 6550 | 6.6%
e | 6536 | 6.6%
t | 6420 | 6.5%
c | 6124 | 6.2%
y | 6076 | 6.1%
h | 3176 | 3.2%
d | 3162 | 3.2%
Other values (20) | 23324 | 23.5%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 18930 | 19.1%
o | 12380 | 12.5%
n | 6598 | 6.6%
a | 6550 | 6.6%
e | 6536 | 6.6%
t | 6420 | 6.5%
c | 6124 | 6.2%
y | 6076 | 6.1%
h | 3176 | 3.2%
d | 3162 | 3.2%
Other values (20) | 23324 | 23.5%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 18930 | 19.1%
o | 12380 | 12.5%
n | 6598 | 6.6%
a | 6550 | 6.6%
e | 6536 | 6.6%
t | 6420 | 6.5%
c | 6124 | 6.2%
y | 6076 | 6.1%
h | 3176 | 3.2%
d | 3162 | 3.2%
Other values (20) | 23324 | 23.5%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 18930 | 19.1%
o | 12380 | 12.5%
n | 6598 | 6.6%
a | 6550 | 6.6%
e | 6536 | 6.6%
t | 6420 | 6.5%
c | 6124 | 6.2%
y | 6076 | 6.1%
h | 3176 | 3.2%
d | 3162 | 3.2%
Other values (20) | 23324 | 23.5%

renters_were_there_during_w1_or_not
Categorical

High correlation Missing

Distinct | 3
Distinct (%) | 4.8%
Missing | 3336
Missing (%) | 98.2%
Memory size | 26.7 KiB

They were living in this household when the 2nd interview was done | 41
They started living in this household after the 2nd interview was done | 16
Some were there when the second interview was done, but there are some who are new | 5

Length

Max length | 82
Median length | 66
Mean length | 68.322581
Min length | 66

Characters and Unicode

Total characters | 4236
Distinct characters | 25
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 | They were living in this household when the 2nd interview was done
2nd row | Some were there when the second interview was done, but there are some who are new
3rd row | They were living in this household when the 2nd interview was done
4th row | They started living in this household after the 2nd interview was done
5th row | They started living in this household after the 2nd interview was done

#### Common Values

Value | Count | Frequency (%)
They were living in this household when the 2nd interview was done | 41 | 1.2%
They started living in this household after the 2nd interview was done | 16 | 0.5%
Some were there when the second interview was done, but there are some who are new | 5 | 0.1%
(Missing) | 3336 | 98.2%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
the | 62 | 8.1%
interview | 62 | 8.1%
was | 62 | 8.1%
done | 62 | 8.1%
they | 57 | 7.5%
household | 57 | 7.5%
this | 57 | 7.5%
in | 57 | 7.5%
living | 57 | 7.5%
2nd | 57 | 7.5%
Other values (11) | 174 | 22.8%

#### Most occurring characters

Value | Count | Frequency (%)
| 702 | 16.6%
e | 582 | 13.7%
i | 352 | 8.3%
h | 351 | 8.3%
n | 351 | 8.3%
t | 244 | 5.8%
w | 226 | 5.3%
s | 202 | 4.8%
d | 197 | 4.7%
o | 196 | 4.6%
Other values (15) | 833 | 19.7%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 702 | 16.6%
e | 582 | 13.7%
i | 352 | 8.3%
h | 351 | 8.3%
n | 351 | 8.3%
t | 244 | 5.8%
w | 226 | 5.3%
s | 202 | 4.8%
d | 197 | 4.7%
o | 196 | 4.6%
Other values (15) | 833 | 19.7%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 702 | 16.6%
e | 582 | 13.7%
i | 352 | 8.3%
h | 351 | 8.3%
n | 351 | 8.3%
t | 244 | 5.8%
w | 226 | 5.3%
s | 202 | 4.8%
d | 197 | 4.7%
o | 196 | 4.6%
Other values (15) | 833 | 19.7%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 702 | 16.6%
e | 582 | 13.7%
i | 352 | 8.3%
h | 351 | 8.3%
n | 351 | 8.3%
t | 244 | 5.8%
w | 226 | 5.3%
s | 202 | 4.8%
d | 197 | 4.7%
o | 196 | 4.6%
Other values (15) | 833 | 19.7%

since_when_renters_are_living_in_household
Categorical

High correlation Missing

Distinct | 5
Distinct (%) | 23.8%
Missing | 3377
Missing (%) | 99.4%
Memory size | 26.7 KiB

November 2024 | 7
October 2024 | 6
December 2024 | 4
Other | 2
September 2024 | 2

Length

Max length | 14
Median length | 13
Mean length | 12.047619
Min length | 5

Characters and Unicode

Total characters | 253
Distinct characters | 18
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 | October 2024
2nd row | November 2024
3rd row | November 2024
4th row | November 2024
5th row | December 2024

#### Common Values

Value | Count | Frequency (%)
November 2024 | 7 | 0.2%
October 2024 | 6 | 0.2%
December 2024 | 4 | 0.1%
Other | 2 | 0.1%
September 2024 | 2 | 0.1%
(Missing) | 3377 | 99.4%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
2024 | 19 | 47.5%
november | 7 | 17.5%
october | 6 | 15.0%
december | 4 | 10.0%
other | 2 | 5.0%
september | 2 | 5.0%

#### Most occurring characters

Value | Count | Frequency (%)
e | 40 | 15.8%
2 | 38 | 15.0%
r | 21 | 8.3%
0 | 19 | 7.5%
| 19 | 7.5%
b | 19 | 7.5%
4 | 19 | 7.5%
o | 13 | 5.1%
m | 13 | 5.1%
t | 10 | 4.0%
Other values (8) | 42 | 16.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
e | 40 | 15.8%
2 | 38 | 15.0%
r | 21 | 8.3%
0 | 19 | 7.5%
| 19 | 7.5%
b | 19 | 7.5%
4 | 19 | 7.5%
o | 13 | 5.1%
m | 13 | 5.1%
t | 10 | 4.0%
Other values (8) | 42 | 16.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
e | 40 | 15.8%
2 | 38 | 15.0%
r | 21 | 8.3%
0 | 19 | 7.5%
| 19 | 7.5%
b | 19 | 7.5%
4 | 19 | 7.5%
o | 13 | 5.1%
m | 13 | 5.1%
t | 10 | 4.0%
Other values (8) | 42 | 16.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
e | 40 | 15.8%
2 | 38 | 15.0%
r | 21 | 8.3%
0 | 19 | 7.5%
| 19 | 7.5%
b | 19 | 7.5%
4 | 19 | 7.5%
o | 13 | 5.1%
m | 13 | 5.1%
t | 10 | 4.0%
Other values (8) | 42 | 16.6%

awareness_of_electricity_consumption_of_renters
Categorical

High correlation Missing

Distinct | 3
Distinct (%) | 4.8%
Missing | 3336
Missing (%) | 98.2%
Memory size | 26.7 KiB

I know all the details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the | 45
i know some details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the nu | 13
I do not know any details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and | 4

Length

Max length | 120
Median length | 120
Mean length | 119.93548
Min length | 119

Characters and Unicode

Total characters | 7436
Distinct characters | 25
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 | I know all the details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the
2nd row | i know some details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the nu
3rd row | I know all the details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the
4th row | I know all the details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the
5th row | i know some details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the nu

#### Common Values

Value | Count | Frequency (%)
I know all the details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the | 45 | 1.3%
i know some details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the nu | 13 | 0.4%
I do not know any details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and | 4 | 0.1%
(Missing) | 3336 | 98.2%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
the | 289 | 23.3%
i | 62 | 5.0%
know | 62 | 5.0%
details | 62 | 5.0%
about | 62 | 5.0%
they | 62 | 5.0%
electricity | 62 | 5.0%
consumption | 62 | 5.0%
of | 62 | 5.0%
renters | 62 | 5.0%
Other values (11) | 393 | 31.7%

#### Most occurring characters

Value | Count | Frequency (%)
| 1178 | 15.8%
e | 922 | 12.4%
t | 727 | 9.8%
a | 421 | 5.7%
o | 393 | 5.3%
n | 393 | 5.3%
i | 385 | 5.2%
s | 385 | 5.2%
h | 351 | 4.7%
r | 310 | 4.2%
Other values (15) | 1971 | 26.5%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 1178 | 15.8%
e | 922 | 12.4%
t | 727 | 9.8%
a | 421 | 5.7%
o | 393 | 5.3%
n | 393 | 5.3%
i | 385 | 5.2%
s | 385 | 5.2%
h | 351 | 4.7%
r | 310 | 4.2%
Other values (15) | 1971 | 26.5%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 1178 | 15.8%
e | 922 | 12.4%
t | 727 | 9.8%
a | 421 | 5.7%
o | 393 | 5.3%
n | 393 | 5.3%
i | 385 | 5.2%
s | 385 | 5.2%
h | 351 | 4.7%
r | 310 | 4.2%
Other values (15) | 1971 | 26.5%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 1178 | 15.8%
e | 922 | 12.4%
t | 727 | 9.8%
a | 421 | 5.7%
o | 393 | 5.3%
n | 393 | 5.3%
i | 385 | 5.2%
s | 385 | 5.2%
h | 351 | 4.7%
r | 310 | 4.2%
Other values (15) | 1971 | 26.5%

changes_to_the_structure_of_household_after_w1
Categorical

High correlation Imbalance

Distinct | 4
Distinct (%) | 0.1%
Missing | 0
Missing (%) | 0.0%
Memory size | 26.7 KiB

No structural changes were done to the household | 3375
Yes, new parts were added only | 15
Yes, some new parts were added to the household and some parts were dismantled | 5
Yes, some parts were dismantled only | 3

Length

Max length | 78
Median length | 48
Mean length | 47.954091
Min length | 30

Characters and Unicode

Total characters | 162948
Distinct characters | 22
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 | No structural changes were done to the household
2nd row | No structural changes were done to the household
3rd row | No structural changes were done to the household
4th row | No structural changes were done to the household
5th row | No structural changes were done to the household

#### Common Values

Value | Count | Frequency (%)
No structural changes were done to the household | 3375 | 99.3%
Yes, new parts were added only | 15 | 0.4%
Yes, some new parts were added to the household and some parts were dismantled | 5 | 0.1%
Yes, some parts were dismantled only | 3 | 0.1%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
were | 3403 | 12.5%
household | 3380 | 12.4%
the | 3380 | 12.4%
to | 3380 | 12.4%
changes | 3375 | 12.4%
structural | 3375 | 12.4%
no | 3375 | 12.4%
done | 3375 | 12.4%
parts | 28 | 0.1%
yes | 23 | 0.1%
Other values (6) | 84 | 0.3%

#### Most occurring characters

Value | Count | Frequency (%)
| 23780 | 14.6%
e | 20400 | 12.5%
o | 16921 | 10.4%
t | 13546 | 8.3%
h | 13515 | 8.3%
s | 10202 | 6.3%
r | 10181 | 6.2%
u | 10130 | 6.2%
d | 6836 | 4.2%
a | 6811 | 4.2%
Other values (12) | 30626 | 18.8%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 23780 | 14.6%
e | 20400 | 12.5%
o | 16921 | 10.4%
t | 13546 | 8.3%
h | 13515 | 8.3%
s | 10202 | 6.3%
r | 10181 | 6.2%
u | 10130 | 6.2%
d | 6836 | 4.2%
a | 6811 | 4.2%
Other values (12) | 30626 | 18.8%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 23780 | 14.6%
e | 20400 | 12.5%
o | 16921 | 10.4%
t | 13546 | 8.3%
h | 13515 | 8.3%
s | 10202 | 6.3%
r | 10181 | 6.2%
u | 10130 | 6.2%
d | 6836 | 4.2%
a | 6811 | 4.2%
Other values (12) | 30626 | 18.8%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 23780 | 14.6%
e | 20400 | 12.5%
o | 16921 | 10.4%
t | 13546 | 8.3%
h | 13515 | 8.3%
s | 10202 | 6.3%
r | 10181 | 6.2%
u | 10130 | 6.2%
d | 6836 | 4.2%
a | 6811 | 4.2%
Other values (12) | 30626 | 18.8%

renovations_done_after_w1
Boolean

High correlation Imbalance

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

False | 3282
True | 116

Value | Count | Frequency (%)
False | 3282 | 96.6%
True | 116 | 3.4%

new_type_of_house
Categorical

High correlation Missing

Distinct | 3
Distinct (%) | 12.5%
Missing | 3374
Missing (%) | 99.3%
Memory size | 26.7 KiB

Single House - Single Floor | 16
Single House -Double Floor | 7
Single House – More than 2 floors | 1

Length

Max length | 33
Median length | 27
Mean length | 26.958333
Min length | 26

Characters and Unicode

Total characters | 647
Distinct characters | 23
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 (%) | 4.2%

Sample

1st row | Single House - Single Floor
2nd row | Single House -Double Floor
3rd row | Single House - Single Floor
4th row | Single House -Double Floor
5th row | Single House - Single Floor

#### Common Values

Value | Count | Frequency (%)
Single House - Single Floor | 16 | 0.5%
Single House -Double Floor | 7 | 0.2%
Single House – More than 2 floors | 1 | < 0.1%
(Missing) | 3374 | 99.3%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
single | 40 | 34.8%
house | 24 | 20.9%
floor | 23 | 20.0%
| 16 | 13.9%
double | 7 | 6.1%
– | 1 | 0.9%
more | 1 | 0.9%
than | 1 | 0.9%
2 | 1 | 0.9%
floors | 1 | 0.9%

#### Most occurring characters

Value | Count | Frequency (%)
| 91 | 14.1%
o | 80 | 12.4%
e | 72 | 11.1%
l | 71 | 11.0%
n | 41 | 6.3%
i | 40 | 6.2%
S | 40 | 6.2%
g | 40 | 6.2%
u | 31 | 4.8%
s | 25 | 3.9%
Other values (13) | 116 | 17.9%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 91 | 14.1%
o | 80 | 12.4%
e | 72 | 11.1%
l | 71 | 11.0%
n | 41 | 6.3%
i | 40 | 6.2%
S | 40 | 6.2%
g | 40 | 6.2%
u | 31 | 4.8%
s | 25 | 3.9%
Other values (13) | 116 | 17.9%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 91 | 14.1%
o | 80 | 12.4%
e | 72 | 11.1%
l | 71 | 11.0%
n | 41 | 6.3%
i | 40 | 6.2%
S | 40 | 6.2%
g | 40 | 6.2%
u | 31 | 4.8%
s | 25 | 3.9%
Other values (13) | 116 | 17.9%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 91 | 14.1%
o | 80 | 12.4%
e | 72 | 11.1%
l | 71 | 11.0%
n | 41 | 6.3%
i | 40 | 6.2%
S | 40 | 6.2%
g | 40 | 6.2%
u | 31 | 4.8%
s | 25 | 3.9%
Other values (13) | 116 | 17.9%

new_no_of_storeys
Categorical

High correlation Missing Uniform

Distinct | 2
Distinct (%) | 100.0%
Missing | 3396
Missing (%) | 99.9%
Memory size | 26.7 KiB

0.0 | 1
3.0 | 1

Length

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

Characters and Unicode

Total characters | 6
Distinct characters | 3
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 (%) | 100.0%

Sample

1st row | 0.0
2nd row | 3.0

#### Common Values

Value | Count | Frequency (%)
0.0 | 1 | < 0.1%
3.0 | 1 | < 0.1%
(Missing) | 3396 | 99.9%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
0.0 | 1 | 50.0%
3.0 | 1 | 50.0%

#### Most occurring characters

Value | Count | Frequency (%)
0 | 3 | 50.0%
. | 2 | 33.3%
3 | 1 | 16.7%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
0 | 3 | 50.0%
. | 2 | 33.3%
3 | 1 | 16.7%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
0 | 3 | 50.0%
. | 2 | 33.3%
3 | 1 | 16.7%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
0 | 3 | 50.0%
. | 2 | 33.3%
3 | 1 | 16.7%

new_floor_area
Real number (ℝ)

High correlation Missing

Distinct | 10
Distinct (%) | 41.7%
Missing | 3374
Missing (%) | 99.3%
Infinite | 0
Infinite (%) | 0.0%
Mean | 4.1666667 × 1011

Minimum | 650
Maximum | 1 × 1012
Zeros | 0
Zeros (%) | 0.0%
Negative | 0
Negative (%) | 0.0%
Memory size | 26.7 KiB

Quantile statistics

Minimum | 650
5-th percentile | 691.2
Q1 | 1000
median | 1700
Q3 | 1 × 1012
95-th percentile | 1 × 1012
Maximum | 1 × 1012
Range | 1 × 1012
Interquartile range (IQR) | 1 × 1012

Descriptive statistics

Standard deviation | 5.0361015 × 1011
Coefficient of variation (CV) | 1.2086644
Kurtosis | -2.0482375
Mean | 4.1666667 × 1011
Median Absolute Deviation (MAD) | 964
Skewness | 0.36102962
Sum | 1 × 1013
Variance | 2.5362319 × 1023
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=10)

Value | Count | Frequency (%)
1 × 1012 | 10 | 0.3%
1000 | 4 | 0.1%
1500 | 2 | 0.1%
800 | 2 | 0.1%
1600 | 1 | < 0.1%
650 | 1 | < 0.1%
672 | 1 | < 0.1%
1800 | 1 | < 0.1%
2000 | 1 | < 0.1%
1050 | 1 | < 0.1%
(Missing) | 3374 | 99.3%

Value | Count | Frequency (%)
650 | 1 | < 0.1%
672 | 1 | < 0.1%
800 | 2 | 0.1%
1000 | 4 | 0.1%
1050 | 1 | < 0.1%
1500 | 2 | 0.1%
1600 | 1 | < 0.1%
1800 | 1 | < 0.1%
2000 | 1 | < 0.1%
1 × 1012 | 10 | 0.3%

Value | Count | Frequency (%)
1 × 1012 | 10 | 0.3%
2000 | 1 | < 0.1%
1800 | 1 | < 0.1%
1600 | 1 | < 0.1%
1500 | 2 | 0.1%
1050 | 1 | < 0.1%
1000 | 4 | 0.1%
800 | 2 | 0.1%
672 | 1 | < 0.1%
650 | 1 | < 0.1%

new_household_members
Real number (ℝ)

High correlation Zeros

Distinct | 9
Distinct (%) | 0.3%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 0.13213655

Minimum | 0
Maximum | 8
Zeros | 3140
Zeros (%) | 92.4%
Negative | 0
Negative (%) | 0.0%
Memory size | 26.7 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 0.57667106
Coefficient of variation (CV) | 4.3642055
Kurtosis | 52.083906
Mean | 0.13213655
Median Absolute Deviation (MAD) | 0
Skewness | 6.4038895
Sum | 449
Variance | 0.33254951
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=9)

Value | Count | Frequency (%)
0 | 3140 | 92.4%
1 | 158 | 4.6%
2 | 59 | 1.7%
4 | 14 | 0.4%
3 | 14 | 0.4%
5 | 7 | 0.2%
6 | 3 | 0.1%
7 | 2 | 0.1%
8 | 1 | < 0.1%

Value | Count | Frequency (%)
0 | 3140 | 92.4%
1 | 158 | 4.6%
2 | 59 | 1.7%
3 | 14 | 0.4%
4 | 14 | 0.4%
5 | 7 | 0.2%
6 | 3 | 0.1%
7 | 2 | 0.1%
8 | 1 | < 0.1%

Value | Count | Frequency (%)
8 | 1 | < 0.1%
7 | 2 | 0.1%
6 | 3 | 0.1%
5 | 7 | 0.2%
4 | 14 | 0.4%
3 | 14 | 0.4%
2 | 59 | 1.7%
1 | 158 | 4.6%
0 | 3140 | 92.4%

charging_method_of_renters_for_electricity
Categorical

High correlation Missing

Distinct | 5
Distinct (%) | 8.1%
Missing | 3336
Missing (%) | 98.2%
Memory size | 26.7 KiB

You charge a fixed amount every month for electricity. | 29
You charge an amount for electricity depending on the variance of the bill. | 12
You don’t charge them for electricity consumption | 10
You don't charge a specific amount for electricity but charge a fixed amount for all the utilities such as electricity, | 10
You don't charge a specific amount for electricity but charge a varied amount for all the utilities such as electricity, | 1

Length

Max length | 120
Median length | 119
Mean length | 68.806452
Min length | 49

Characters and Unicode

Total characters | 4266
Distinct characters | 27
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 (%) | 1.6%

Sample

1st row | You don't charge a specific amount for electricity but charge a varied amount for all the utilities such as electricity,
2nd row | You charge a fixed amount every month for electricity.
3rd row | You charge a fixed amount every month for electricity.
4th row | You charge a fixed amount every month for electricity.
5th row | You don’t charge them for electricity consumption

#### Common Values

Value | Count | Frequency (%)
You charge a fixed amount every month for electricity. | 29 | 0.9%
You charge an amount for electricity depending on the variance of the bill. | 12 | 0.4%
You don’t charge them for electricity consumption | 10 | 0.3%
You don't charge a specific amount for electricity but charge a fixed amount for all the utilities such as electricity, | 10 | 0.3%
You don't charge a specific amount for electricity but charge a varied amount for all the utilities such as electricity, | 1 | < 0.1%
(Missing) | 3336 | 98.2%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
charge | 73 | 10.3%
for | 73 | 10.3%
electricity | 73 | 10.3%
amount | 63 | 8.9%
you | 62 | 8.8%
a | 51 | 7.2%
fixed | 39 | 5.5%
the | 35 | 5.0%
month | 29 | 4.1%
every | 29 | 4.1%
Other values (17) | 180 | 25.5%

#### Most occurring characters

Value | Count | Frequency (%)
| 645 | 15.1%
e | 420 | 9.8%
t | 347 | 8.1%
o | 292 | 6.8%
i | 287 | 6.7%
c | 274 | 6.4%
r | 261 | 6.1%
a | 246 | 5.8%
n | 193 | 4.5%
u | 168 | 3.9%
Other values (17) | 1133 | 26.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 645 | 15.1%
e | 420 | 9.8%
t | 347 | 8.1%
o | 292 | 6.8%
i | 287 | 6.7%
c | 274 | 6.4%
r | 261 | 6.1%
a | 246 | 5.8%
n | 193 | 4.5%
u | 168 | 3.9%
Other values (17) | 1133 | 26.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 645 | 15.1%
e | 420 | 9.8%
t | 347 | 8.1%
o | 292 | 6.8%
i | 287 | 6.7%
c | 274 | 6.4%
r | 261 | 6.1%
a | 246 | 5.8%
n | 193 | 4.5%
u | 168 | 3.9%
Other values (17) | 1133 | 26.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 645 | 15.1%
e | 420 | 9.8%
t | 347 | 8.1%
o | 292 | 6.8%
i | 287 | 6.7%
c | 274 | 6.4%
r | 261 | 6.1%
a | 246 | 5.8%
n | 193 | 4.5%
u | 168 | 3.9%
Other values (17) | 1133 | 26.6%

charged_method_for_rent_for_electricity
Categorical

High correlation Imbalance Missing

Distinct | 4
Distinct (%) | 1.1%
Missing | 3037
Missing (%) | 89.4%
Memory size | 26.7 KiB

You pay the full amount of the electricity bill. | 343
You pay a fixed amount to the owner every month for electricity. | 8
You don’t pay the owner for electricity consumption | 7
You pay a varied amount to the owner every month for electricity. The amount paid varies depending on the variance of th | 3

Length

Max length | 120
Median length | 48
Mean length | 49.01108
Min length | 48

Characters and Unicode

Total characters | 17693
Distinct characters | 27
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 | You pay the full amount of the electricity bill.
2nd row | You pay the full amount of the electricity bill.
3rd row | You pay the full amount of the electricity bill.
4th row | You pay the full amount of the electricity bill.
5th row | You pay a varied amount to the owner every month for electricity. The amount paid varies depending on the variance of th

#### Common Values

Value | Count | Frequency (%)
You pay the full amount of the electricity bill. | 343 | 10.1%
You pay a fixed amount to the owner every month for electricity. | 8 | 0.2%
You don’t pay the owner for electricity consumption | 7 | 0.2%
You pay a varied amount to the owner every month for electricity. The amount paid varies depending on the variance of th | 3 | 0.1%
(Missing) | 3037 | 89.4%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
the | 710 | 21.5%
you | 361 | 10.9%
pay | 361 | 10.9%
electricity | 361 | 10.9%
amount | 357 | 10.8%
of | 346 | 10.5%
full | 343 | 10.4%
bill | 343 | 10.4%
owner | 18 | 0.5%
for | 18 | 0.5%
Other values (14) | 87 | 2.6%

#### Most occurring characters

Value | Count | Frequency (%)
| 2944 | 16.6%
t | 1825 | 10.3%
l | 1733 | 9.8%
e | 1495 | 8.4%
o | 1146 | 6.5%
i | 1095 | 6.2%
u | 1068 | 6.0%
a | 744 | 4.2%
y | 733 | 4.1%
c | 732 | 4.1%
Other values (17) | 4178 | 23.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 2944 | 16.6%
t | 1825 | 10.3%
l | 1733 | 9.8%
e | 1495 | 8.4%
o | 1146 | 6.5%
i | 1095 | 6.2%
u | 1068 | 6.0%
a | 744 | 4.2%
y | 733 | 4.1%
c | 732 | 4.1%
Other values (17) | 4178 | 23.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 2944 | 16.6%
t | 1825 | 10.3%
l | 1733 | 9.8%
e | 1495 | 8.4%
o | 1146 | 6.5%
i | 1095 | 6.2%
u | 1068 | 6.0%
a | 744 | 4.2%
y | 733 | 4.1%
c | 732 | 4.1%
Other values (17) | 4178 | 23.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 2944 | 16.6%
t | 1825 | 10.3%
l | 1733 | 9.8%
e | 1495 | 8.4%
o | 1146 | 6.5%
i | 1095 | 6.2%
u | 1068 | 6.0%
a | 744 | 4.2%
y | 733 | 4.1%
c | 732 | 4.1%
Other values (17) | 4178 | 23.6%

is_there_business_carried_out_in_the_household
Boolean

High correlation Imbalance

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

False | 3287
True | 111

Value | Count | Frequency (%)
False | 3287 | 96.7%
True | 111 | 3.3%

type_of_business
Categorical

High correlation Missing

Distinct | 3
Distinct (%) | 2.7%
Missing | 3287
Missing (%) | 96.7%
Memory size | 26.7 KiB

Other | 65
A shop | 45
A communication | 1

Length

Max length | 15
Median length | 5
Mean length | 5.4954955
Min length | 5

Characters and Unicode

Total characters | 610
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 | 1 ?
Unique (%) | 0.9%

Sample

1st row | A shop
2nd row | A shop
3rd row | A shop
4th row | Other
5th row | Other

#### Common Values

Value | Count | Frequency (%)
Other | 65 | 1.9%
A shop | 45 | 1.3%
A communication | 1 | < 0.1%
(Missing) | 3287 | 96.7%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
other | 65 | 41.4%
a | 46 | 29.3%
shop | 45 | 28.7%
communication | 1 | 0.6%

#### Most occurring characters

Value | Count | Frequency (%)
h | 110 | 18.0%
t | 66 | 10.8%
O | 65 | 10.7%
e | 65 | 10.7%
r | 65 | 10.7%
o | 47 | 7.7%
| 46 | 7.5%
A | 46 | 7.5%
s | 45 | 7.4%
p | 45 | 7.4%
Other values (6) | 10 | 1.6%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
h | 110 | 18.0%
t | 66 | 10.8%
O | 65 | 10.7%
e | 65 | 10.7%
r | 65 | 10.7%
o | 47 | 7.7%
| 46 | 7.5%
A | 46 | 7.5%
s | 45 | 7.4%
p | 45 | 7.4%
Other values (6) | 10 | 1.6%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
h | 110 | 18.0%
t | 66 | 10.8%
O | 65 | 10.7%
e | 65 | 10.7%
r | 65 | 10.7%
o | 47 | 7.7%
| 46 | 7.5%
A | 46 | 7.5%
s | 45 | 7.4%
p | 45 | 7.4%
Other values (6) | 10 | 1.6%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
h | 110 | 18.0%
t | 66 | 10.8%
O | 65 | 10.7%
e | 65 | 10.7%
r | 65 | 10.7%
o | 47 | 7.7%
| 46 | 7.5%
A | 46 | 7.5%
s | 45 | 7.4%
p | 45 | 7.4%
Other values (6) | 10 | 1.6%

other_business_activity
Text

Missing

Distinct | 53
Distinct (%) | 81.5%
Missing | 3333
Missing (%) | 98.1%
Memory size | 26.7 KiB

Length

Max length | 42
Median length | 22
Mean length | 12.4
Min length | 5

Characters and Unicode

Total characters | 806
Distinct characters | 70
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 | 46 ?
Unique (%) | 70.8%

Sample

1st row | Lee maduwa
2nd row | mahanawa radi
3rd row | leemdy
4th row | namapuwaru sadiema
5th row | dewalayak

Value | Count | Frequency (%)
lee | 6 | 4.8%
maduwa | 5 | 4.0%
mahanawa | 5 | 4.0%
මැසීම | 4 | 3.2%
wadumaduwa | 4 | 3.2%
ekak | 4 | 3.2%
ඇදුම් | 3 | 2.4%
office | 3 | 2.4%
garment | 3 | 2.4%
kema | 2 | 1.6%
Other values (82) | 87 | 69.0%

#### Most occurring characters

Value | Count | Frequency (%)
a | 127 | 15.8%
| 65 | 8.1%
e | 49 | 6.1%
k | 34 | 4.2%
s | 32 | 4.0%
m | 30 | 3.7%
u | 29 | 3.6%
d | 28 | 3.5%
r | 27 | 3.3%
w | 27 | 3.3%
Other values (60) | 358 | 44.4%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
a | 127 | 15.8%
| 65 | 8.1%
e | 49 | 6.1%
k | 34 | 4.2%
s | 32 | 4.0%
m | 30 | 3.7%
u | 29 | 3.6%
d | 28 | 3.5%
r | 27 | 3.3%
w | 27 | 3.3%
Other values (60) | 358 | 44.4%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
a | 127 | 15.8%
| 65 | 8.1%
e | 49 | 6.1%
k | 34 | 4.2%
s | 32 | 4.0%
m | 30 | 3.7%
u | 29 | 3.6%
d | 28 | 3.5%
r | 27 | 3.3%
w | 27 | 3.3%
Other values (60) | 358 | 44.4%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
a | 127 | 15.8%
| 65 | 8.1%
e | 49 | 6.1%
k | 34 | 4.2%
s | 32 | 4.0%
m | 30 | 3.7%
u | 29 | 3.6%
d | 28 | 3.5%
r | 27 | 3.3%
w | 27 | 3.3%
Other values (60) | 358 | 44.4%

is_there_any_construction_or_renovation_ongoing
Boolean

High correlation Imbalance

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

False | 3325
True | 73

Value | Count | Frequency (%)
False | 3325 | 97.9%
True | 73 | 2.1%

last_month_expenditure
Text

Distinct | 76
Distinct (%) | 2.2%
Missing | 0
Missing (%) | 0.0%
Memory size | 26.7 KiB

Length

Max length | 9
Median length | 7
Mean length | 7.3322543
Min length | 7

Characters and Unicode

Total characters | 24915
Distinct characters | 19
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 | 29 ?
Unique (%) | 0.9%

Sample

1st row | 100000.0
2nd row | 100000.0
3rd row | 100000.0
4th row | 20000.0
5th row | 50000.0

Value | Count | Frequency (%)
100000.0 | 441 | 12.7%
50000.0 | 402 | 11.6%
60000.0 | 382 | 11.0%
40000.0 | 245 | 7.0%
150000.0 | 222 | 6.4%
80000.0 | 215 | 6.2%
70000.0 | 178 | 5.1%
30000.0 | 159 | 4.6%
75000.0 | 154 | 4.4%
35000.0 | 102 | 2.9%
Other values (67) | 979 | 28.1%

#### Most occurring characters

Value | Count | Frequency (%)
0 | 16427 | 65.9%
. | 3317 | 13.3%
5 | 1302 | 5.2%
1 | 907 | 3.6%
2 | 458 | 1.8%
6 | 443 | 1.8%
7 | 351 | 1.4%
4 | 344 | 1.4%
3 | 316 | 1.3%
8 | 256 | 1.0%
Other values (9) | 794 | 3.2%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
0 | 16427 | 65.9%
. | 3317 | 13.3%
5 | 1302 | 5.2%
1 | 907 | 3.6%
2 | 458 | 1.8%
6 | 443 | 1.8%
7 | 351 | 1.4%
4 | 344 | 1.4%
3 | 316 | 1.3%
8 | 256 | 1.0%
Other values (9) | 794 | 3.2%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
0 | 16427 | 65.9%
. | 3317 | 13.3%
5 | 1302 | 5.2%
1 | 907 | 3.6%
2 | 458 | 1.8%
6 | 443 | 1.8%
7 | 351 | 1.4%
4 | 344 | 1.4%
3 | 316 | 1.3%
8 | 256 | 1.0%
Other values (9) | 794 | 3.2%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
0 | 16427 | 65.9%
. | 3317 | 13.3%
5 | 1302 | 5.2%
1 | 907 | 3.6%
2 | 458 | 1.8%
6 | 443 | 1.8%
7 | 351 | 1.4%
4 | 344 | 1.4%
3 | 316 | 1.3%
8 | 256 | 1.0%
Other values (9) | 794 | 3.2%

smart_metered_or_non_smart_metered
Categorical

High correlation

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

Smart meter | 1910
Non smart meter | 1488

Length

Max length | 15
Median length | 11
Mean length | 12.751619
Min length | 11

Characters and Unicode

Total characters | 43330
Distinct characters | 11
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 | Smart meter
2nd row | Smart meter
3rd row | Smart meter
4th row | Smart meter
5th row | Smart meter

#### Common Values

Value | Count | Frequency (%)
Smart meter | 1910 | 56.2%
Non smart meter | 1488 | 43.8%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
smart | 3398 | 41.0%
meter | 3398 | 41.0%
non | 1488 | 18.0%

#### Most occurring characters

Value | Count | Frequency (%)
m | 6796 | 15.7%
t | 6796 | 15.7%
r | 6796 | 15.7%
e | 6796 | 15.7%
| 4886 | 11.3%
a | 3398 | 7.8%
S | 1910 | 4.4%
N | 1488 | 3.4%
o | 1488 | 3.4%
n | 1488 | 3.4%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
m | 6796 | 15.7%
t | 6796 | 15.7%
r | 6796 | 15.7%
e | 6796 | 15.7%
| 4886 | 11.3%
a | 3398 | 7.8%
S | 1910 | 4.4%
N | 1488 | 3.4%
o | 1488 | 3.4%
n | 1488 | 3.4%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
m | 6796 | 15.7%
t | 6796 | 15.7%
r | 6796 | 15.7%
e | 6796 | 15.7%
| 4886 | 11.3%
a | 3398 | 7.8%
S | 1910 | 4.4%
N | 1488 | 3.4%
o | 1488 | 3.4%
n | 1488 | 3.4%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
m | 6796 | 15.7%
t | 6796 | 15.7%
r | 6796 | 15.7%
e | 6796 | 15.7%
| 4886 | 11.3%
a | 3398 | 7.8%
S | 1910 | 4.4%
N | 1488 | 3.4%
o | 1488 | 3.4%
n | 1488 | 3.4%

# Interactions

# Correlations

| awareness_of_electricity_consumption_of_renters | changes_to_the_structure_of_household_after_w1 | charged_method_for_rent_for_electricity | charging_method_of_renters_for_electricity | is_there_any_construction_or_renovation_ongoing | is_there_business_carried_out_in_the_household | new_electricity_meters | new_floor_area | new_household_members | new_no_of_storeys | new_type_of_house | no_of_electricity_meters | occupy_renters_boarders | own_the_house_or_living_on_rent | renovations_done_after_w1 | renters_were_there_during_w1_or_not | since_when_renters_are_living_in_household | smart_metered_or_non_smart_metered | type_of_business
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
awareness_of_electricity_consumption_of_renters | 1.000 | 0.172 | 0.000 | 0.000 | 0.000 | 0.456 | 0.000 | NaN | 0.152 | 0.000 | NaN | NaN | 0.172 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | NaN
changes_to_the_structure_of_household_after_w1 | 0.172 | 1.000 | 1.000 | 0.000 | 0.309 | 0.000 | 0.000 | 0.000 | 0.076 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.160 | 0.121 | 0.115 | 0.000 | 1.000
charged_method_for_rent_for_electricity | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.060 | 1.000 | 0.000 | 0.000 | NaN | NaN | 0.000 | NaN | 0.232 | 0.074 | 0.000 | 0.000 | 0.053 | 0.000
charging_method_of_renters_for_electricity | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.141 | 0.000 | NaN | 0.000 | 0.000 | NaN | NaN | 0.160 | 1.000 | 0.000 | 0.098 | 0.000 | 0.051 | NaN
is_there_any_construction_or_renovation_ongoing | 0.000 | 0.309 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.032 | 1.000 | 0.000 | 1.000 | 0.000 | 0.044 | 0.369 | 0.000 | 0.115 | 0.000 | 0.000
is_there_business_carried_out_in_the_household | 0.456 | 0.000 | 0.060 | 0.141 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.019 | 0.000 | 0.121 | 0.000 | 0.021 | 1.000
new_electricity_meters | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.047 | 0.000 | 0.047 | 0.000 | 1.000 | 0.000 | 1.000
new_floor_area | NaN | 0.000 | 0.000 | NaN | 0.000 | 1.000 | 1.000 | 1.000 | -0.343 | NaN | 0.319 | 0.000 | 0.000 | 1.000 | 0.228 | NaN | NaN | 0.000 | 0.000
new_household_members | 0.152 | 0.076 | 0.000 | 0.000 | 0.032 | 0.000 | 0.000 | -0.343 | 1.000 | 1.000 | 0.000 | 1.000 | 0.140 | 0.015 | 0.010 | 0.387 | 0.387 | 0.000 | 0.000
new_no_of_storeys | 0.000 | 1.000 | NaN | 0.000 | 1.000 | 1.000 | 1.000 | NaN | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000
new_type_of_house | NaN | 0.000 | NaN | NaN | 0.000 | 1.000 | 1.000 | 0.319 | 0.000 | 1.000 | 1.000 | 0.000 | 0.140 | 1.000 | 0.000 | NaN | NaN | 0.000 | 0.000
no_of_electricity_meters | NaN | 1.000 | 0.000 | NaN | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | NaN | 0.000 | 0.000 | 0.000
occupy_renters_boarders | 0.172 | 0.000 | NaN | 0.160 | 0.000 | 0.000 | 0.047 | 0.000 | 0.140 | 1.000 | 0.140 | 0.000 | 1.000 | 1.000 | 0.000 | 0.166 | 0.000 | 0.000 | 0.000
own_the_house_or_living_on_rent | 1.000 | 0.000 | 0.232 | 1.000 | 0.044 | 0.019 | 0.000 | 1.000 | 0.015 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000
renovations_done_after_w1 | 0.000 | 0.160 | 0.074 | 0.000 | 0.369 | 0.000 | 0.047 | 0.228 | 0.010 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.115 | 0.000 | 0.000
renters_were_there_during_w1_or_not | 0.000 | 0.121 | 0.000 | 0.098 | 0.000 | 0.121 | 0.000 | NaN | 0.387 | 0.000 | NaN | NaN | 0.166 | 1.000 | 0.000 | 1.000 | 0.410 | 0.228 | NaN
since_when_renters_are_living_in_household | 0.000 | 0.115 | 0.000 | 0.000 | 0.115 | 0.000 | 1.000 | NaN | 0.387 | 0.000 | NaN | 0.000 | 0.000 | 1.000 | 0.115 | 0.410 | 1.000 | 0.522 | NaN
smart_metered_or_non_smart_metered | 0.000 | 0.000 | 0.053 | 0.051 | 0.000 | 0.021 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.228 | 0.522 | 1.000 | 0.000
type_of_business | NaN | 1.000 | 0.000 | NaN | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | NaN | NaN | 0.000 | 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 | new_electricity_meters | no_of_electricity_meters | own_the_house_or_living_on_rent | occupy_renters_boarders | renters_were_there_during_w1_or_not | since_when_renters_are_living_in_household | awareness_of_electricity_consumption_of_renters | changes_to_the_structure_of_household_after_w1 | renovations_done_after_w1 | new_type_of_house | new_no_of_storeys | new_floor_area | new_household_members | charging_method_of_renters_for_electricity | charged_method_for_rent_for_electricity | is_there_business_carried_out_in_the_household | type_of_business | other_business_activity | is_there_any_construction_or_renovation_ongoing | last_month_expenditure | smart_metered_or_non_smart_metered
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
0 | ID0726 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 100000.0 | Smart meter
1 | ID0734 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 100000.0 | Smart meter
2 | ID2795 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 100000.0 | Smart meter
3 | ID2829 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 20000.0 | Smart meter
4 | ID2843 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 50000.0 | Smart meter
5 | ID2906 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 55000.0 | Smart meter
6 | ID2908 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 180000.0 | Smart meter
7 | ID2917 | No | NaN | No, I am living on rent and the rent is paid by me or a household member. | NaN | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | You pay the full amount of the electricity bill. | No | NaN | NaN | No | 70000.0 | Non smart meter
8 | ID2836 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | Can't Say | Smart meter
9 | ID2915 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 35000.0 | Non smart meter

| household_ID | new_electricity_meters | no_of_electricity_meters | own_the_house_or_living_on_rent | occupy_renters_boarders | renters_were_there_during_w1_or_not | since_when_renters_are_living_in_household | awareness_of_electricity_consumption_of_renters | changes_to_the_structure_of_household_after_w1 | renovations_done_after_w1 | new_type_of_house | new_no_of_storeys | new_floor_area | new_household_members | charging_method_of_renters_for_electricity | charged_method_for_rent_for_electricity | is_there_business_carried_out_in_the_household | type_of_business | other_business_activity | is_there_any_construction_or_renovation_ongoing | last_month_expenditure | smart_metered_or_non_smart_metered
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
3388 | ID3458 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 60000.0 | Smart meter
3389 | ID3064 | No | NaN | Yes, I or a household member owns it. | Boarders who live in your house using a room/s that is attached to your living conditions. | They were living in this household when the 2nd interview was done | NaN | I know all the details about the electricity consumption of the renters/ boarders; i.e.; the appliances they use and the | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | You don't charge a specific amount for electricity but charge a fixed amount for all the utilities such as electricity, | NaN | No | NaN | NaN | No | 100000.0 | Smart meter
3390 | ID0586 | No | NaN | No, I am living on rent and the rent is paid by me or a household member. | NaN | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | You pay the full amount of the electricity bill. | No | NaN | NaN | No | 750000.0 | Non smart meter
3391 | ID0403 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 70000.0 | Non smart meter
3392 | ID2268 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | NaN | No | NaN | NaN | No | 60000.0 | Non smart meter
3393 | ID1147 | No | NaN | No, I am living on rent and the rent is paid by me or a household member. | NaN | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | You pay the full amount of the electricity bill. | No | NaN | NaN | No | 80000.0 | Non smart meter
3394 | ID0963 | No | NaN | Yes, I or a household member owns it. | I don’t occupy any of the above | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 5.0 | NaN | NaN | No | NaN | NaN | No | 30000.0 | Non smart meter
3395 | ID1024 | No | NaN | No, I am living on rent and the rent is paid by me or a household member. | NaN | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | You pay the full amount of the electricity bill. | No | NaN | NaN | No | 150000.0 | Smart meter
3396 | ID2440 | No | NaN | No, I am living on rent and the rent is paid by me or a household member. | NaN | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | You pay the full amount of the electricity bill. | No | NaN | NaN | No | 150000.0 | Smart meter
3397 | ID1050 | No | NaN | No, I am living on rent and the rent is paid by me or a household member. | NaN | NaN | NaN | NaN | No structural changes were done to the household | No | NaN | NaN | NaN | 0.0 | NaN | You pay the full amount of the electricity bill. | No | NaN | NaN | No | 100000.0 | Non smart meter