Overview

Brought to you by YData

Dataset statistics

Number of variables	4
Number of observations	53,599
Missing cells	21,780
Missing cells (%)	10.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	32.0 B

Variable types

Text	3
Numeric	1

Alerts

`no_of_hours_used_during_last_week` has 21780 (40.6%) missing values	Missing
`no_of_hours_used_during_last_week` has 7837 (14.6%) zeros	Zeros

Reproduction

Analysis started	2024-12-06 05:54:32.951821
Analysis finished	2024-12-06 05:54:33.577925
Duration	0.63 seconds
Software version	ydata-profiling vv4.11.0
Download configuration	config.json

household_ID
Text

Distinct	4055
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Memory size	418.9 KiB

Length

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

Characters and Unicode

Total characters	321,594
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	53 ?
Unique (%)	0.1%

Sample

1st row	ID0001
2nd row	ID0001
3rd row	ID0001
4th row	ID0001
5th row	ID0001

Value	Count	Frequency (%)
id0255	66	0.1%
id0772	59	0.1%
id3663	55	0.1%
id2774	54	0.1%
id2262	53	0.1%
id3068	52	0.1%
id0841	52	0.1%
id3787	52	0.1%
id3910	51	0.1%
id2420	51	0.1%
Other values (4045)	53054	99.0%

Most occurring characters

Value	Count	Frequency (%)
I	53599	16.7%
D	53599	16.7%
3	30301	9.4%
0	29498	9.2%
2	29272	9.1%
1	29216	9.1%
7	16459	5.1%
4	16396	5.1%
6	16312	5.1%
8	15797	4.9%
Other values (2)	31145	9.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	214396	66.7%
Uppercase Letter	107198	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	30301	14.1%
0	29498	13.8%
2	29272	13.7%
1	29216	13.6%
7	16459	7.7%
4	16396	7.6%
6	16312	7.6%
8	15797	7.4%
9	15598	7.3%
5	15547	7.3%

Uppercase Letter

Value	Count	Frequency (%)
I	53599	50.0%
D	53599	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	214396	66.7%
Latin	107198	33.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	30301	14.1%
0	29498	13.8%
2	29272	13.7%
1	29216	13.6%
7	16459	7.7%
4	16396	7.6%
6	16312	7.6%
8	15797	7.4%
9	15598	7.3%
5	15547	7.3%

Latin

Value	Count	Frequency (%)
I	53599	50.0%
D	53599	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	321594	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	53599	16.7%
D	53599	16.7%
3	30301	9.4%
0	29498	9.2%
2	29272	9.1%
1	29216	9.1%
7	16459	5.1%
4	16396	5.1%
6	16312	5.1%
8	15797	4.9%
Other values (2)	31145	9.7%

appliance_ID
Text

Distinct	210
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	418.9 KiB