# Overview

Brought to you by YData

Dataset statistics

Number of variables | 10
Number of observations | 3398
Missing cells | 7525
Missing cells (%) | 22.1%
Duplicate rows | 0
Duplicate rows (%) | 0.0%
Total size in memory | 265.6 KiB
Average record size in memory | 80.0 B

Variable types

Text | 1
Boolean | 3
Categorical | 3
Numeric | 3

Alerts

`target_bill_value` is highly overall correlated with `target_number_of_units` and 1 other fields | High correlation
`target_number_of_units` is highly overall correlated with `target_bill_value` and 1 other fields | High correlation
`target_type` is highly overall correlated with `target_units_of_consumption` | High correlation
`target_units_of_consumption` is highly overall correlated with `target_bill_value` and 2 other fields | High correlation
`target_type` has 2180 (64.2%) missing values | Missing
`target_number_of_units` has 2672 (78.6%) missing values | Missing
`target_bill_value` has 2672 (78.6%) missing values | Missing
`no_of_red_notices` has 2451 (72.1%) zeros | Zeros

Reproduction

Analysis started | 2025-02-27 04:58:59.202634
Analysis finished | 2025-02-27 04:59:00.701864
Duration | 1.5 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%

target_units_of_consumption
Boolean

High correlation

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

False | 2180
True | 1218

Value | Count | Frequency (%)
False | 2180 | 64.2%
True | 1218 | 35.8%

target_type
Categorical

High correlation Missing

Distinct | 3
Distinct (%) | 0.2%
Missing | 2180
Missing (%) | 64.2%
Memory size | 26.7 KiB

Number of units | 492
Bill value | 492
Both | 234

Length

Max length | 15
Median length | 10
Mean length | 10.866995
Min length | 4

Characters and Unicode

Total characters | 13236
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 | Both
2nd row | Number of units
3rd row | Both
4th row | Number of units
5th row | Both

#### Common Values

Value | Count | Frequency (%)
Number of units | 492 | 14.5%
Bill value | 492 | 14.5%
Both | 234 | 6.9%
(Missing) | 2180 | 64.2%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
number | 492 | 18.3%
of | 492 | 18.3%
units | 492 | 18.3%
bill | 492 | 18.3%
value | 492 | 18.3%
both | 234 | 8.7%

#### Most occurring characters

Value | Count | Frequency (%)
u | 1476 | 11.2%
| 1476 | 11.2%
l | 1476 | 11.2%
i | 984 | 7.4%
e | 984 | 7.4%
t | 726 | 5.5%
o | 726 | 5.5%
B | 726 | 5.5%
N | 492 | 3.7%
m | 492 | 3.7%
Other values (8) | 3678 | 27.8%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
u | 1476 | 11.2%
| 1476 | 11.2%
l | 1476 | 11.2%
i | 984 | 7.4%
e | 984 | 7.4%
t | 726 | 5.5%
o | 726 | 5.5%
B | 726 | 5.5%
N | 492 | 3.7%
m | 492 | 3.7%
Other values (8) | 3678 | 27.8%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
u | 1476 | 11.2%
| 1476 | 11.2%
l | 1476 | 11.2%
i | 984 | 7.4%
e | 984 | 7.4%
t | 726 | 5.5%
o | 726 | 5.5%
B | 726 | 5.5%
N | 492 | 3.7%
m | 492 | 3.7%
Other values (8) | 3678 | 27.8%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
u | 1476 | 11.2%
| 1476 | 11.2%
l | 1476 | 11.2%
i | 984 | 7.4%
e | 984 | 7.4%
t | 726 | 5.5%
o | 726 | 5.5%
B | 726 | 5.5%
N | 492 | 3.7%
m | 492 | 3.7%
Other values (8) | 3678 | 27.8%

target_number_of_units
Real number (ℝ)

High correlation Missing

Distinct | 133
Distinct (%) | 18.3%
Missing | 2672
Missing (%) | 78.6%
Infinite | 0
Infinite (%) | 0.0%
Mean | 92.570248

Minimum | 1
Maximum | 500
Zeros | 0
Zeros (%) | 0.0%
Negative | 0
Negative (%) | 0.0%
Memory size | 26.7 KiB

Quantile statistics

Minimum | 1
5-th percentile | 22.75
Q1 | 60
median | 90
Q3 | 108
95-th percentile | 180
Maximum | 500
Range | 499
Interquartile range (IQR) | 48

Descriptive statistics

Standard deviation | 53.760207
Coefficient of variation (CV) | 0.58075039
Kurtosis | 12.887304
Mean | 92.570248
Median Absolute Deviation (MAD) | 29.5
Skewness | 2.5072623
Sum | 67206
Variance | 2890.1599
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=50)

Value | Count | Frequency (%)
90 | 127 | 3.7%
60 | 90 | 2.6%
100 | 42 | 1.2%
80 | 28 | 0.8%
120 | 26 | 0.8%
50 | 26 | 0.8%
30 | 16 | 0.5%
110 | 15 | 0.4%
89 | 13 | 0.4%
20 | 12 | 0.4%
Other values (123) | 331 | 9.7%
(Missing) | 2672 | 78.6%

Value | Count | Frequency (%)
1 | 6 | 0.2%
2 | 1 | < 0.1%
5 | 3 | 0.1%
8 | 1 | < 0.1%
10 | 4 | 0.1%
12 | 3 | 0.1%
14 | 1 | < 0.1%
15 | 2 | 0.1%
18 | 1 | < 0.1%
19 | 1 | < 0.1%

Value | Count | Frequency (%)
500 | 2 | 0.1%
400 | 1 | < 0.1%
380 | 1 | < 0.1%
375 | 1 | < 0.1%
312 | 1 | < 0.1%
300 | 2 | 0.1%
295 | 1 | < 0.1%
280 | 1 | < 0.1%
260 | 1 | < 0.1%
250 | 2 | 0.1%

target_bill_value
Real number (ℝ)

High correlation Missing

Distinct | 191
Distinct (%) | 26.3%
Missing | 2672
Missing (%) | 78.6%
Infinite | 0
Infinite (%) | 0.0%
Mean | 3465.3251

Minimum | 0
Maximum | 36800
Zeros | 19
Zeros (%) | 0.6%
Negative | 0
Negative (%) | 0.0%
Memory size | 26.7 KiB

Quantile statistics

Minimum | 0
5-th percentile | 200
Q1 | 1418.5
median | 2500
Q3 | 4500
95-th percentile | 10000
Maximum | 36800
Range | 36800
Interquartile range (IQR) | 3081.5

Descriptive statistics

Standard deviation | 3633.3484
Coefficient of variation (CV) | 1.048487
Kurtosis | 17.808753
Mean | 3465.3251
Median Absolute Deviation (MAD) | 1500
Skewness | 3.3019613
Sum | 2515826
Variance | 13201220
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=50)

Value | Count | Frequency (%)
2000 | 69 | 2.0%
3000 | 54 | 1.6%
5000 | 36 | 1.1%
1000 | 35 | 1.0%
2500 | 32 | 0.9%
1500 | 32 | 0.9%
6000 | 28 | 0.8%
4000 | 24 | 0.7%
3500 | 20 | 0.6%
500 | 19 | 0.6%
Other values (181) | 377 | 11.1%
(Missing) | 2672 | 78.6%

Value | Count | Frequency (%)
0 | 19 | 0.6%
28 | 1 | < 0.1%
32 | 1 | < 0.1%
40 | 1 | < 0.1%
61 | 1 | < 0.1%
65 | 2 | 0.1%
80 | 2 | 0.1%
90 | 1 | < 0.1%
100 | 2 | 0.1%
102 | 1 | < 0.1%

Value | Count | Frequency (%)
36800 | 1 | < 0.1%
28000 | 1 | < 0.1%
25000 | 2 | 0.1%
21000 | 1 | < 0.1%
20000 | 2 | 0.1%
16831 | 1 | < 0.1%
16000 | 1 | < 0.1%
15702 | 1 | < 0.1%
15602 | 1 | < 0.1%
15000 | 6 | 0.2%

reading_smart_meter_data
Boolean

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

False | 2950
True | 448

Value | Count | Frequency (%)
False | 2950 | 86.8%
True | 448 | 13.2%

Knowledge_on_bill_calculation
Categorical

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

Neither me, nor my household members are aware of how the bill is calculated | 2202
I am aware of how the bill is calculated. | 655
I’m not aware of how the bill is calculated, but a household member is aware | 541

Length

Max length | 76
Median length | 76
Mean length | 69.253384
Min length | 41

Characters and Unicode

Total characters | 235323
Distinct characters | 24
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 | Neither me, nor my household members are aware of how the bill is calculated
2nd row | Neither me, nor my household members are aware of how the bill is calculated
3rd row | I am aware of how the bill is calculated.
4th row | Neither me, nor my household members are aware of how the bill is calculated
5th row | Neither me, nor my household members are aware of how the bill is calculated

#### Common Values

Value | Count | Frequency (%)
Neither me, nor my household members are aware of how the bill is calculated | 2202 | 64.8%
I am aware of how the bill is calculated. | 655 | 19.3%
I’m not aware of how the bill is calculated, but a household member is aware | 541 | 15.9%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
aware | 3939 | 8.8%
is | 3939 | 8.8%
how | 3398 | 7.6%
of | 3398 | 7.6%
the | 3398 | 7.6%
calculated | 3398 | 7.6%
bill | 3398 | 7.6%
household | 2743 | 6.1%
neither | 2202 | 4.9%
my | 2202 | 4.9%
Other values (11) | 12823 | 28.6%

#### Most occurring characters

Value | Count | Frequency (%)
| 41440 | 17.6%
e | 27772 | 11.8%
a | 18072 | 7.7%
l | 16335 | 6.9%
o | 15025 | 6.4%
h | 14484 | 6.2%
r | 13288 | 5.6%
m | 11086 | 4.7%
t | 10080 | 4.3%
i | 9539 | 4.1%
Other values (14) | 58202 | 24.7%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 41440 | 17.6%
e | 27772 | 11.8%
a | 18072 | 7.7%
l | 16335 | 6.9%
o | 15025 | 6.4%
h | 14484 | 6.2%
r | 13288 | 5.6%
m | 11086 | 4.7%
t | 10080 | 4.3%
i | 9539 | 4.1%
Other values (14) | 58202 | 24.7%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 41440 | 17.6%
e | 27772 | 11.8%
a | 18072 | 7.7%
l | 16335 | 6.9%
o | 15025 | 6.4%
h | 14484 | 6.2%
r | 13288 | 5.6%
m | 11086 | 4.7%
t | 10080 | 4.3%
i | 9539 | 4.1%
Other values (14) | 58202 | 24.7%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 41440 | 17.6%
e | 27772 | 11.8%
a | 18072 | 7.7%
l | 16335 | 6.9%
o | 15025 | 6.4%
h | 14484 | 6.2%
r | 13288 | 5.6%
m | 11086 | 4.7%
t | 10080 | 4.3%
i | 9539 | 4.1%
Other values (14) | 58202 | 24.7%

payment_practice
Categorical

Distinct | 6
Distinct (%) | 0.2%
Missing | 0
Missing (%) | 0.0%
Memory size | 26.7 KiB

We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600) | 1427
We try to pay the exact amount in the bill (ex: 4566) | 933
We try to pay a portion of the bill amount that is possible for us (ex: 3500) | 435
We don’t pay the bill regularly/ every month. | 301
We try to pay a rounded off amount which is mostly lower than the bill (ex: 4500) | 294

Length

Max length | 84
Median length | 81
Mean length | 70.800177
Min length | 45

Characters and Unicode

Total characters | 240579
Distinct characters | 39
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 | We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600)
2nd row | We try to pay the exact amount in the bill (ex: 4566)
3rd row | We try to pay the exact amount in the bill (ex: 4566)
4th row | We try to pay the exact amount in the bill (ex: 4566)
5th row | We try to pay the exact amount in the bill (ex: 4566)

#### Common Values

Value | Count | Frequency (%)
We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600) | 1427 | 42.0%
We try to pay the exact amount in the bill (ex: 4566) | 933 | 27.5%
We try to pay a portion of the bill amount that is possible for us (ex: 3500) | 435 | 12.8%
We don’t pay the bill regularly/ every month. | 301 | 8.9%
We try to pay a rounded off amount which is mostly lower than the bill (ex: 4500) | 294 | 8.7%
We live on rent and we do not pay directly to LECO. | 8 | 0.2%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
amount | 4516 | 9.0%
the | 4323 | 8.6%
we | 3406 | 6.8%
pay | 3398 | 6.7%
bill | 3390 | 6.7%
to | 3097 | 6.2%
try | 3089 | 6.1%
ex | 3089 | 6.1%
a | 2156 | 4.3%
off | 1721 | 3.4%
Other values (33) | 18167 | 36.1%

#### Most occurring characters

Value | Count | Frequency (%)
| 46954 | 19.5%
t | 18477 | 7.7%
e | 17982 | 7.5%
o | 17298 | 7.2%
l | 12702 | 5.3%
a | 12041 | 5.0%
h | 10222 | 4.2%
i | 9086 | 3.8%
n | 8533 | 3.5%
r | 8320 | 3.5%
Other values (29) | 78964 | 32.8%

#### Most occurring categories

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

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 46954 | 19.5%
t | 18477 | 7.7%
e | 17982 | 7.5%
o | 17298 | 7.2%
l | 12702 | 5.3%
a | 12041 | 5.0%
h | 10222 | 4.2%
i | 9086 | 3.8%
n | 8533 | 3.5%
r | 8320 | 3.5%
Other values (29) | 78964 | 32.8%

#### Most occurring scripts

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

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 46954 | 19.5%
t | 18477 | 7.7%
e | 17982 | 7.5%
o | 17298 | 7.2%
l | 12702 | 5.3%
a | 12041 | 5.0%
h | 10222 | 4.2%
i | 9086 | 3.8%
n | 8533 | 3.5%
r | 8320 | 3.5%
Other values (29) | 78964 | 32.8%

#### Most occurring blocks

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

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 46954 | 19.5%
t | 18477 | 7.7%
e | 17982 | 7.5%
o | 17298 | 7.2%
l | 12702 | 5.3%
a | 12041 | 5.0%
h | 10222 | 4.2%
i | 9086 | 3.8%
n | 8533 | 3.5%
r | 8320 | 3.5%
Other values (29) | 78964 | 32.8%

disconnection_due_to_late_payment
Boolean

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

False | 2928
True | 470

Value | Count | Frequency (%)
False | 2928 | 86.2%
True | 470 | 13.8%

no_of_red_notices
Real number (ℝ)

Zeros

Distinct | 12
Distinct (%) | 0.4%
Missing | 0
Missing (%) | 0.0%
Infinite | 0
Infinite (%) | 0.0%
Mean | 0.68098882

Minimum | 0
Maximum | 15
Zeros | 2451
Zeros (%) | 72.1%
Negative | 0
Negative (%) | 0.0%
Memory size | 26.7 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation | 1.4309946
Coefficient of variation (CV) | 2.1013482
Kurtosis | 16.750067
Mean | 0.68098882
Median Absolute Deviation (MAD) | 0
Skewness | 3.3305434
Sum | 2314
Variance | 2.0477456
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=12)

Value | Count | Frequency (%)
0 | 2451 | 72.1%
1 | 302 | 8.9%
2 | 297 | 8.7%
3 | 196 | 5.8%
4 | 68 | 2.0%
5 | 39 | 1.1%
6 | 22 | 0.6%
12 | 8 | 0.2%
8 | 7 | 0.2%
10 | 5 | 0.1%
Other values (2) | 3 | 0.1%

Value | Count | Frequency (%)
0 | 2451 | 72.1%
1 | 302 | 8.9%
2 | 297 | 8.7%
3 | 196 | 5.8%
4 | 68 | 2.0%
5 | 39 | 1.1%
6 | 22 | 0.6%
7 | 2 | 0.1%
8 | 7 | 0.2%
10 | 5 | 0.1%

Value | Count | Frequency (%)
15 | 1 | < 0.1%
12 | 8 | 0.2%
10 | 5 | 0.1%
8 | 7 | 0.2%
7 | 2 | 0.1%
6 | 22 | 0.6%
5 | 39 | 1.1%
4 | 68 | 2.0%
3 | 196 | 5.8%
2 | 297 | 8.7%

# Interactions

# Correlations

| Knowledge_on_bill_calculation | disconnection_due_to_late_payment | no_of_red_notices | payment_practice | reading_smart_meter_data | target_bill_value | target_number_of_units | target_type | target_units_of_consumption
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
Knowledge_on_bill_calculation | 1.000 | 0.088 | 0.030 | 0.068 | 0.316 | 0.092 | 0.107 | 0.116 | 0.129
disconnection_due_to_late_payment | 0.088 | 1.000 | 0.418 | 0.263 | 0.000 | 0.000 | 0.000 | 0.068 | 0.009
no_of_red_notices | 0.030 | 0.418 | 1.000 | 0.119 | 0.035 | 0.065 | 0.008 | 0.031 | 0.000
payment_practice | 0.068 | 0.263 | 0.119 | 1.000 | 0.045 | 0.000 | 0.015 | 0.052 | 0.070
reading_smart_meter_data | 0.316 | 0.000 | 0.035 | 0.045 | 1.000 | 0.090 | 0.043 | 0.151 | 0.195
target_bill_value | 0.092 | 0.000 | 0.065 | 0.000 | 0.090 | 1.000 | 0.623 | 0.001 | 1.000
target_number_of_units | 0.107 | 0.000 | 0.008 | 0.015 | 0.043 | 0.623 | 1.000 | 0.136 | 1.000
target_type | 0.116 | 0.068 | 0.031 | 0.052 | 0.151 | 0.001 | 0.136 | 1.000 | 1.000
target_units_of_consumption | 0.129 | 0.009 | 0.000 | 0.070 | 0.195 | 1.000 | 1.000 | 1.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 | target_units_of_consumption | target_type | target_number_of_units | target_bill_value | reading_smart_meter_data | Knowledge_on_bill_calculation | payment_practice | disconnection_due_to_late_payment | no_of_red_notices
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
0 | ID0726 | Yes | Both | 15.0 | 2400.0 | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600) | Yes | 1.0
1 | ID0734 | Yes | Number of units | 80.0 | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | No | 0.0
2 | ID2795 | Yes | Both | 20.0 | 2773.0 | Yes | I am aware of how the bill is calculated. | We try to pay the exact amount in the bill (ex: 4566) | No | 0.0
3 | ID2829 | Yes | Number of units | 10.0 | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | No | 0.0
4 | ID2843 | Yes | Both | 20.0 | 0.0 | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | No | 0.0
5 | ID2906 | No | NaN | NaN | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | Yes | 1.0
6 | ID2908 | Yes | Both | 150.0 | 6000.0 | Yes | I am aware of how the bill is calculated. | We try to pay a portion of the bill amount that is possible for us (ex: 3500) | No | 0.0
7 | ID2917 | Yes | Bill value | NaN | 20000.0 | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | Yes | 1.0
8 | ID2836 | No | NaN | NaN | NaN | Yes | I am aware of how the bill is calculated. | We try to pay the exact amount in the bill (ex: 4566) | No | 0.0
9 | ID2915 | Yes | Both | 20.0 | 2800.0 | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | No | 0.0

| household_ID | target_units_of_consumption | target_type | target_number_of_units | target_bill_value | reading_smart_meter_data | Knowledge_on_bill_calculation | payment_practice | disconnection_due_to_late_payment | no_of_red_notices
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
3388 | ID3458 | No | NaN | NaN | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | Yes | 2.0
3389 | ID3064 | No | NaN | NaN | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay the exact amount in the bill (ex: 4566) | No | 0.0
3390 | ID0586 | No | NaN | NaN | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600) | No | 0.0
3391 | ID0403 | No | NaN | NaN | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We don’t pay the bill regularly/ every month. | No | 0.0
3392 | ID2268 | Yes | Number of units | 62.0 | NaN | No | I am aware of how the bill is calculated. | We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600) | No | 0.0
3393 | ID1147 | No | NaN | NaN | NaN | No | I am aware of how the bill is calculated. | We don’t pay the bill regularly/ every month. | Yes | 3.0
3394 | ID0963 | Yes | Bill value | NaN | 3000.0 | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay a portion of the bill amount that is possible for us (ex: 3500) | No | 1.0
3395 | ID1024 | Yes | Bill value | NaN | 120.0 | No | Neither me, nor my household members are aware of how the bill is calculated | We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600) | No | 3.0
3396 | ID2440 | No | NaN | NaN | NaN | Yes | Neither me, nor my household members are aware of how the bill is calculated | We try to pay a rounded off amount which will cover the whole bill amount (ex: 4600) | No | 0.0
3397 | ID1050 | No | NaN | NaN | NaN | No | Neither me, nor my household members are aware of how the bill is calculated | We don’t pay the bill regularly/ every month. | No | 1.0