Household Consumption Profile Report

Dataset statistics

Number of variables	21
Number of observations	728
Missing cells	1933
Missing cells (%)	12.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	111.0 KiB
Average record size in memory	156.2 B

Variable types

Numeric	16
DateTime	1
Categorical	2
Unsupported	2

Alerts

`snow` has constant value "10.0"	Constant
`Global_active_power` is highly overall correlated with `Global_intensity`	High correlation
`Global_intensity` is highly overall correlated with `Global_active_power`	High correlation
`tavg` is highly overall correlated with `tmax` and 1 other fields	High correlation
`tmax` is highly overall correlated with `tavg` and 1 other fields	High correlation
`tmin` is highly overall correlated with `tavg` and 1 other fields	High correlation
`snow` has 477 (65.5%) missing values	Missing
`wpgt` has 728 (100.0%) missing values	Missing
`tsun` has 728 (100.0%) missing values	Missing
`Datetime` has unique values	Unique
`wpgt` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tsun` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Global_reactive_power` has 181 (24.9%) zeros	Zeros
`Sub_metering_1` has 691 (94.9%) zeros	Zeros
`Sub_metering_2` has 522 (71.7%) zeros	Zeros
`Sub_metering_3` has 468 (64.3%) zeros	Zeros
`prcp` has 411 (56.5%) zeros	Zeros

Reproduction

Analysis started	2024-10-19 04:23:45.138971
Analysis finished	2024-10-19 04:24:35.429113
Duration	50.29 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Global_active_power
Real number (ℝ)

HIGH CORRELATION

Distinct	406
Distinct (%)	55.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.80824725

Minimum	0.08
Maximum	5.544
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0.08
5-th percentile	0.1587
Q1	0.264
median	0.394
Q3	1.241
95-th percentile	2.7808
Maximum	5.544
Range	5.464
Interquartile range (IQR)	0.977

Descriptive statistics

Standard deviation	0.90083816
Coefficient of variation (CV)	1.1145576
Kurtosis	4.9245651
Mean	0.80824725
Median Absolute Deviation (MAD)	0.169
Skewness	2.154245
Sum	588.404
Variance	0.81150939
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.326	8	1.1%
0.25	7	1.0%
0.324	7	1.0%
0.29	6	0.8%
0.292	6	0.8%
0.354	6	0.8%
0.258	6	0.8%
0.314	6	0.8%
0.218	6	0.8%
0.404	5	0.7%
Other values (396)	665	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.08	3	0.4%
0.082	3	0.4%
0.084	1	0.1%
0.086	1	0.1%
0.102	3	0.4%
0.104	1	0.1%
0.108	1	0.1%
0.114	3	0.4%
0.116	2	0.3%
0.118	1	0.1%

Value	Count	Frequency (%)
5.544	1	0.1%
5.376	1	0.1%
4.786	1	0.1%
4.718	1	0.1%
4.646	1	0.1%
4.36	1	0.1%
4.286	1	0.1%
4.094	1	0.1%
3.966	1	0.1%
3.902	1	0.1%

Global_reactive_power
Real number (ℝ)

ZEROS

Distinct	148
Distinct (%)	20.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11026374

Minimum	0
Maximum	0.588
Zeros	181
Zeros (%)	24.9%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.046
median	0.094
Q3	0.154
95-th percentile	0.2986
Maximum	0.588
Range	0.588
Interquartile range (IQR)	0.108

Descriptive statistics

Standard deviation	0.097748107
Coefficient of variation (CV)	0.88649369
Kurtosis	1.3053862
Mean	0.11026374
Median Absolute Deviation (MAD)	0.06
Skewness	1.032959
Sum	80.272
Variance	0.0095546924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	181	24.9%
0.09	12	1.6%
0.058	12	1.6%
0.082	11	1.5%
0.102	11	1.5%
0.104	11	1.5%
0.088	11	1.5%
0.086	10	1.4%
0.094	10	1.4%
0.12	10	1.4%
Other values (138)	449	61.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	181	24.9%
0.046	7	1.0%
0.048	5	0.7%
0.05	8	1.1%
0.052	6	0.8%
0.054	4	0.5%
0.056	6	0.8%
0.058	12	1.6%
0.06	6	0.8%
0.062	8	1.1%

Value	Count	Frequency (%)
0.588	1	0.1%
0.564	1	0.1%
0.44	1	0.1%
0.404	1	0.1%
0.396	1	0.1%
0.392	1	0.1%
0.382	3	0.4%
0.38	1	0.1%
0.378	1	0.1%
0.368	1	0.1%

Voltage
Real number (ℝ)

Distinct	505
Distinct (%)	69.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	241.88342

Minimum	229.4
Maximum	248.61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	229.4
5-th percentile	236.5415
Q1	240.455
median	242.33
Q3	243.7125
95-th percentile	245.853
Maximum	248.61
Range	19.21
Interquartile range (IQR)	3.2575

Descriptive statistics

Standard deviation	2.8415497
Coefficient of variation (CV)	0.0117476
Kurtosis	1.2009578
Mean	241.88342
Median Absolute Deviation (MAD)	1.59
Skewness	-0.83414206
Sum	176091.13
Variance	8.0744049
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
243.03	6	0.8%
241.45	5	0.7%
243.38	5	0.7%
242.56	5	0.7%
241.25	5	0.7%
241.55	4	0.5%
241.95	4	0.5%
242.8	4	0.5%
241.94	4	0.5%
243.92	4	0.5%
Other values (495)	682	93.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
229.4	1	0.1%
231.82	1	0.1%
232.21	1	0.1%
232.73	1	0.1%
232.83	1	0.1%
232.88	1	0.1%
233.05	4	0.5%
233.18	1	0.1%
233.77	1	0.1%
233.8	1	0.1%

Value	Count	Frequency (%)
248.61	1	0.1%
248.58	1	0.1%
248.44	1	0.1%
247.29	1	0.1%
247.27	1	0.1%
247.23	1	0.1%
247.16	1	0.1%
247.1	1	0.1%
247.07	1	0.1%
246.97	1	0.1%

Global_intensity
Real number (ℝ)

HIGH CORRELATION

Distinct	81
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4211538

Minimum	0.2
Maximum	23.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0.2
5-th percentile	0.67
Q1	1.2
median	1.8
Q3	5.2
95-th percentile	11.73
Maximum	23.2
Range	23
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.7321523
Coefficient of variation (CV)	1.0909045
Kurtosis	5.1451087
Mean	3.4211538
Median Absolute Deviation (MAD)	0.8
Skewness	2.1853675
Sum	2490.6
Variance	13.92896
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.4	81	11.1%
1	79	10.9%
1.2	69	9.5%
1.6	45	6.2%
1.8	45	6.2%
0.8	42	5.8%
2	27	3.7%
2.2	26	3.6%
0.6	24	3.3%
2.4	22	3.0%
Other values (71)	268	36.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	8	1.1%
0.4	5	0.7%
0.6	24	3.3%
0.8	42	5.8%
1	79	10.9%
1.2	69	9.5%
1.4	81	11.1%
1.6	45	6.2%
1.8	45	6.2%
2	27	3.7%

Value	Count	Frequency (%)
23.2	1	0.1%
22.6	1	0.1%
20	1	0.1%
19.8	2	0.3%
18	1	0.1%
17.8	1	0.1%
17	2	0.3%
16.4	1	0.1%
16	1	0.1%
15.8	1	0.1%

Sub_metering_1
Real number (ℝ)

ZEROS

Distinct	8
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.62774725

Minimum	0
Maximum	40
Zeros	691
Zeros (%)	94.9%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.65
Maximum	40
Range	40
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4.6807457
Coefficient of variation (CV)	7.4564177
Kurtosis	61.206129
Mean	0.62774725
Median Absolute Deviation (MAD)	0
Skewness	7.918295
Sum	457
Variance	21.90938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	691	94.9%
1	21	2.9%
38	5	0.7%
2	4	0.5%
39	4	0.5%
35	1	0.1%
40	1	0.1%
7	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	691	94.9%
1	21	2.9%
2	4	0.5%
7	1	0.1%
35	1	0.1%
38	5	0.7%
39	4	0.5%
40	1	0.1%

Value	Count	Frequency (%)
40	1	0.1%
39	4	0.5%
38	5	0.7%
35	1	0.1%
7	1	0.1%
2	4	0.5%
1	21	2.9%
0	691	94.9%

Sub_metering_2
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.76510989

Minimum	0
Maximum	38
Zeros	522
Zeros (%)	71.7%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	3.5237129
Coefficient of variation (CV)	4.6054991
Kurtosis	82.406366
Mean	0.76510989
Median Absolute Deviation (MAD)	0
Skewness	8.8701191
Sum	557
Variance	12.416553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	522	71.7%
1	126	17.3%
2	65	8.9%
4	6	0.8%
36	2	0.3%
21	1	0.1%
37	1	0.1%
30	1	0.1%
18	1	0.1%
26	1	0.1%
Other values (2)	2	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	522	71.7%
1	126	17.3%
2	65	8.9%
4	6	0.8%
18	1	0.1%
21	1	0.1%
26	1	0.1%
30	1	0.1%
35	1	0.1%
36	2	0.3%

Value	Count	Frequency (%)
38	1	0.1%
37	1	0.1%
36	2	0.3%
35	1	0.1%
30	1	0.1%
26	1	0.1%
21	1	0.1%
18	1	0.1%
4	6	0.8%
2	65	8.9%

Sub_metering_3
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4574176

Minimum	0
Maximum	19
Zeros	468
Zeros (%)	64.3%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	6.8399546
Coefficient of variation (CV)	1.9783421
Kurtosis	0.71756129
Mean	3.4574176
Median Absolute Deviation (MAD)	0
Skewness	1.6350579
Sum	2517
Variance	46.784979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	468	64.3%
1	123	16.9%
18	89	12.2%
17	24	3.3%
19	17	2.3%
2	1	0.1%
16	1	0.1%
10	1	0.1%
7	1	0.1%
12	1	0.1%
Other values (2)	2	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	468	64.3%
1	123	16.9%
2	1	0.1%
3	1	0.1%
7	1	0.1%
10	1	0.1%
11	1	0.1%
12	1	0.1%
16	1	0.1%
17	24	3.3%

Value	Count	Frequency (%)
19	17	2.3%
18	89	12.2%
17	24	3.3%
16	1	0.1%
12	1	0.1%
11	1	0.1%
10	1	0.1%
7	1	0.1%
3	1	0.1%
2	1	0.1%

Datetime
Date

UNIQUE

Distinct	728
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

Minimum	2006-12-17 00:00:00
Maximum	2008-12-13 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

tavg
Real number (ℝ)

HIGH CORRELATION

Distinct	216
Distinct (%)	29.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.488049

Minimum	-1.6
Maximum	26.2
Zeros	0
Zeros (%)	0.0%
Negative	8
Negative (%)	1.1%
Memory size	5.8 KiB

Quantile statistics

Minimum	-1.6
5-th percentile	2.77
Q1	8.3
median	12.5
Q3	17.7
95-th percentile	20.965
Maximum	26.2
Range	27.8
Interquartile range (IQR)	9.4

Descriptive statistics

Standard deviation	5.8174435
Coefficient of variation (CV)	0.46584085
Kurtosis	-0.79642261
Mean	12.488049
Median Absolute Deviation (MAD)	4.6
Skewness	-0.1317714
Sum	9091.3
Variance	33.842649
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.2	11	1.5%
10.2	11	1.5%
10.3	11	1.5%
9.5	10	1.4%
10.7	10	1.4%
9.1	9	1.2%
18.7	9	1.2%
17.9	9	1.2%
17.8	8	1.1%
8.7	8	1.1%
Other values (206)	632	86.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1.6	1	0.1%
-1.1	1	0.1%
-0.9	2	0.3%
-0.8	1	0.1%
-0.6	1	0.1%
-0.2	2	0.3%
0.3	2	0.3%
0.5	2	0.3%
0.7	1	0.1%
1.1	2	0.3%

Value	Count	Frequency (%)
26.2	1	0.1%
25.6	1	0.1%
25.5	1	0.1%
25.3	1	0.1%
25.1	1	0.1%
24.6	1	0.1%
24.4	1	0.1%
24.2	1	0.1%
23.8	1	0.1%
23.4	1	0.1%

tmin
Real number (ℝ)

HIGH CORRELATION

Distinct	204
Distinct (%)	28.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.1200549

Minimum	-3.6
Maximum	20.4
Zeros	3
Zeros (%)	0.4%
Negative	29
Negative (%)	4.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	-3.6
5-th percentile	0.2
Q1	5.4
median	9.1
Q3	13.625
95-th percentile	16.765
Maximum	20.4
Range	24
Interquartile range (IQR)	8.225

Descriptive statistics

Standard deviation	5.2176701
Coefficient of variation (CV)	0.5721095
Kurtosis	-0.87096483
Mean	9.1200549
Median Absolute Deviation (MAD)	4.2
Skewness	-0.20312558
Sum	6639.4
Variance	27.224081
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.4	9	1.2%
15.8	9	1.2%
15.1	8	1.1%
12	8	1.1%
11.8	8	1.1%
5.4	8	1.1%
10.2	8	1.1%
12.8	8	1.1%
6.3	8	1.1%
6.9	8	1.1%
Other values (194)	646	88.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3.6	1	0.1%
-3.1	1	0.1%
-2.8	2	0.3%
-2.4	1	0.1%
-2.3	2	0.3%
-2.2	2	0.3%
-2.1	1	0.1%
-1.7	2	0.3%
-1.6	1	0.1%
-1.4	1	0.1%

Value	Count	Frequency (%)
20.4	1	0.1%
19.7	1	0.1%
19.4	1	0.1%
19.3	1	0.1%
18.7	1	0.1%
18.6	1	0.1%
18.5	1	0.1%
18.4	1	0.1%
18.1	1	0.1%
18	3	0.4%

tmax
Real number (ℝ)

HIGH CORRELATION

Distinct	248
Distinct (%)	34.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.555357

Minimum	0.7
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0.7
5-th percentile	5.805
Q1	11.275
median	16.55
Q3	22.1
95-th percentile	27.3
Maximum	34
Range	33.3
Interquartile range (IQR)	10.825

Descriptive statistics

Standard deviation	6.9032794
Coefficient of variation (CV)	0.41698161
Kurtosis	-0.74517443
Mean	16.555357
Median Absolute Deviation (MAD)	5.45
Skewness	0.02555871
Sum	12052.3
Variance	47.655267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.8	11	1.5%
11.7	10	1.4%
12.9	9	1.2%
21.4	8	1.1%
8.5	8	1.1%
22.8	7	1.0%
20.7	7	1.0%
10.6	7	1.0%
22.6	7	1.0%
13.2	7	1.0%
Other values (238)	647	88.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.7	1	0.1%
0.8	1	0.1%
0.9	2	0.3%
1	1	0.1%
1.1	1	0.1%
1.8	1	0.1%
2.4	1	0.1%
2.6	1	0.1%
2.7	2	0.3%
2.8	2	0.3%

Value	Count	Frequency (%)
34	1	0.1%
33.3	2	0.3%
32.4	1	0.1%
31.8	2	0.3%
31.7	1	0.1%
31.6	1	0.1%
31.5	1	0.1%
31.3	2	0.3%
30.8	1	0.1%
30.5	1	0.1%

prcp
Real number (ℝ)

ZEROS

Distinct	62
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7192308

Minimum	0
Maximum	44.7
Zeros	411
Zeros (%)	56.5%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.5
95-th percentile	8.225
Maximum	44.7
Range	44.7
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	4.1770498
Coefficient of variation (CV)	2.4296039
Kurtosis	30.735513
Mean	1.7192308
Median Absolute Deviation (MAD)	0
Skewness	4.7737746
Sum	1251.6
Variance	17.447745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	411	56.5%
0.5	43	5.9%
0.3	34	4.7%
0.8	23	3.2%
1.5	16	2.2%
2.3	15	2.1%
1.3	14	1.9%
1	14	1.9%
3.3	10	1.4%
2	9	1.2%
Other values (52)	139	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	411	56.5%
0.2	2	0.3%
0.3	34	4.7%
0.5	43	5.9%
0.8	23	3.2%
1	14	1.9%
1.3	14	1.9%
1.5	16	2.2%
1.8	6	0.8%
2	9	1.2%

Value	Count	Frequency (%)
44.7	1	0.1%
31.5	1	0.1%
30.5	2	0.3%
27.4	1	0.1%
24.9	1	0.1%
24.4	1	0.1%
21.1	2	0.3%
19.6	1	0.1%
18.5	1	0.1%
17.5	1	0.1%

snow
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	0.4%
Missing	477
Missing (%)	65.5%
Memory size	44.9 KiB

10.0	251

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

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

Sample

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

Common Values

Value	Count	Frequency (%)
10.0	251	34.5%
(Missing)	477	65.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
10.0	251	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	502	50.0%
1	251	25.0%
.	251	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1004	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	502	50.0%
1	251	25.0%
.	251	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1004	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	502	50.0%
1	251	25.0%
.	251	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1004	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	502	50.0%
1	251	25.0%
.	251	25.0%

wdir
Real number (ℝ)

Distinct	290
Distinct (%)	39.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	187.57143

Minimum	0
Maximum	359
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	13
Q1	112.5
median	208
Q3	260
95-th percentile	340.3
Maximum	359
Range	359
Interquartile range (IQR)	147.5

Descriptive statistics

Standard deviation	100.08765
Coefficient of variation (CV)	0.53359754
Kurtosis	-0.8845513
Mean	187.57143
Median Absolute Deviation (MAD)	67
Skewness	-0.35689492
Sum	136552
Variance	10017.538
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
214	10	1.4%
216	9	1.2%
210	7	1.0%
8	7	1.0%
219	7	1.0%
261	6	0.8%
201	6	0.8%
20	6	0.8%
306	6	0.8%
213	6	0.8%
Other values (280)	658	90.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
2	3	0.4%
3	1	0.1%
4	2	0.3%
5	3	0.4%
6	1	0.1%
7	5	0.7%
8	7	1.0%
9	2	0.3%
10	2	0.3%

Value	Count	Frequency (%)
359	1	0.1%
358	2	0.3%
356	3	0.4%
355	2	0.3%
354	4	0.5%
353	3	0.4%
352	2	0.3%
350	2	0.3%
349	4	0.5%
348	1	0.1%

wspd
Real number (ℝ)

Distinct	167
Distinct (%)	22.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.53489

Minimum	3.1
Maximum	36.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	3.1
5-th percentile	6
Q1	8.5
median	10.9
Q3	13.9
95-th percentile	18.8
Maximum	36.4
Range	33.3
Interquartile range (IQR)	5.4

Descriptive statistics

Standard deviation	4.1463618
Coefficient of variation (CV)	0.35946262
Kurtosis	2.3670798
Mean	11.53489
Median Absolute Deviation (MAD)	2.6
Skewness	1.0418591
Sum	8397.4
Variance	17.192316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.8	16	2.2%
13	15	2.1%
9.7	14	1.9%
10	13	1.8%
9.5	12	1.6%
8.8	12	1.6%
9.8	12	1.6%
7.5	11	1.5%
8.6	11	1.5%
8.5	10	1.4%
Other values (157)	602	82.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.1	1	0.1%
4.2	1	0.1%
4.3	2	0.3%
4.4	1	0.1%
4.5	1	0.1%
4.6	3	0.4%
4.8	4	0.5%
4.9	2	0.3%
5	1	0.1%
5.1	2	0.3%

Value	Count	Frequency (%)
36.4	1	0.1%
29.1	1	0.1%
27.8	1	0.1%
26.2	1	0.1%
25.6	1	0.1%
25	1	0.1%
24.8	1	0.1%
23.5	2	0.3%
23.2	2	0.3%
22.5	1	0.1%

wpgt
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	728
Missing (%)	100.0%
Memory size	5.8 KiB

pres
Real number (ℝ)

Distinct	316
Distinct (%)	43.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1017.3728

Minimum	989
Maximum	1041.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	989
5-th percentile	1001.07
Q1	1011.6
median	1017
Q3	1023
95-th percentile	1032.9
Maximum	1041.4
Range	52.4
Interquartile range (IQR)	11.4

Descriptive statistics

Standard deviation	9.2739657
Coefficient of variation (CV)	0.0091156021
Kurtosis	0.043953189
Mean	1017.3728
Median Absolute Deviation (MAD)	5.7
Skewness	-0.10968287
Sum	740647.4
Variance	86.006439
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1021.5	9	1.2%
1022.7	9	1.2%
1016.8	8	1.1%
1015.3	8	1.1%
1028.3	8	1.1%
1016.4	8	1.1%
1011	8	1.1%
1013.8	8	1.1%
1021.4	7	1.0%
1020.5	7	1.0%
Other values (306)	648	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
989	1	0.1%
989.9	1	0.1%
991.4	1	0.1%
992.3	1	0.1%
992.9	2	0.3%
993.8	1	0.1%
993.9	1	0.1%
994.8	1	0.1%
995	1	0.1%
995.8	2	0.3%

Value	Count	Frequency (%)
1041.4	1	0.1%
1039.7	1	0.1%
1039.5	1	0.1%
1039.4	1	0.1%
1039.2	1	0.1%
1038.7	2	0.3%
1038.4	1	0.1%
1038.2	1	0.1%
1037.5	2	0.3%
1036.9	1	0.1%

tsun
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	728
Missing (%)	100.0%
Memory size	5.8 KiB

Year
Categorical

Distinct	3
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	43.5 KiB

2007	365
2008	348
2006	15

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2912
Distinct characters	5
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	2006
2nd row	2006
3rd row	2006
4th row	2006
5th row	2006

Common Values

Value	Count	Frequency (%)
2007	365	50.1%
2008	348	47.8%
2006	15	2.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2007	365	50.1%
2008	348	47.8%
2006	15	2.1%

Most occurring characters

Value	Count	Frequency (%)
0	1456	50.0%
2	728	25.0%
7	365	12.5%
8	348	12.0%
6	15	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2912	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1456	50.0%
2	728	25.0%
7	365	12.5%
8	348	12.0%
6	15	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2912	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1456	50.0%
2	728	25.0%
7	365	12.5%
8	348	12.0%
6	15	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2912	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1456	50.0%
2	728	25.0%
7	365	12.5%
8	348	12.0%
6	15	0.5%

Month
Real number (ℝ)

Distinct	12
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.4972527

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.440993
Coefficient of variation (CV)	0.52960737
Kurtosis	-1.2057319
Mean	6.4972527
Median Absolute Deviation (MAD)	3
Skewness	-0.0052322921
Sum	4730
Variance	11.840433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	62	8.5%
3	62	8.5%
5	62	8.5%
7	62	8.5%
8	62	8.5%
10	62	8.5%
4	60	8.2%
6	60	8.2%
9	60	8.2%
11	60	8.2%
Other values (2)	116	15.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	62	8.5%
2	57	7.8%
3	62	8.5%
4	60	8.2%
5	62	8.5%
6	60	8.2%
7	62	8.5%
8	62	8.5%
9	60	8.2%
10	62	8.5%

Value	Count	Frequency (%)
12	59	8.1%
11	60	8.2%
10	62	8.5%
9	60	8.2%
8	62	8.5%
7	62	8.5%
6	60	8.2%
5	62	8.5%
4	60	8.2%
3	62	8.5%

Day
Real number (ℝ)

Distinct	31
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.741758

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8278235
Coefficient of variation (CV)	0.56079019
Kurtosis	-1.2020996
Mean	15.741758
Median Absolute Deviation (MAD)	8
Skewness	0.0049701175
Sum	11460
Variance	77.930468
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	24	3.3%
18	24	3.3%
13	24	3.3%
12	24	3.3%
11	24	3.3%
10	24	3.3%
9	24	3.3%
8	24	3.3%
7	24	3.3%
6	24	3.3%
Other values (21)	488	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	24	3.3%
2	24	3.3%
3	24	3.3%
4	24	3.3%
5	24	3.3%
6	24	3.3%
7	24	3.3%
8	24	3.3%
9	24	3.3%
10	24	3.3%

Value	Count	Frequency (%)
31	14	1.9%
30	22	3.0%
29	23	3.2%
28	24	3.3%
27	24	3.3%
26	24	3.3%
25	24	3.3%
24	24	3.3%
23	24	3.3%
22	24	3.3%

Auto

Heatmap
Table

	Day	Global_active_power	Global_intensity	Global_reactive_power	Month	Sub_metering_1	Sub_metering_2	Sub_metering_3	Voltage	Year	prcp	pres	tavg	tmax	tmin	wdir	wspd
Day	1.000	-0.110	-0.103	-0.058	0.010	-0.057	0.000	-0.059	0.062	0.000	-0.060	0.084	-0.067	-0.062	-0.069	-0.044	-0.163
Global_active_power	-0.110	1.000	0.991	0.278	-0.087	0.247	0.203	0.421	-0.142	0.157	-0.013	0.065	-0.247	-0.236	-0.251	-0.025	0.006
Global_intensity	-0.103	0.991	1.000	0.322	-0.089	0.245	0.222	0.428	-0.172	0.175	-0.008	0.054	-0.211	-0.202	-0.215	-0.022	0.005
Global_reactive_power	-0.058	0.278	0.322	1.000	-0.001	0.060	0.477	0.041	-0.053	0.000	0.044	-0.097	0.140	0.137	0.127	0.035	0.010
Month	0.010	-0.087	-0.089	-0.001	1.000	-0.001	-0.055	0.002	-0.004	0.208	-0.068	0.141	0.040	0.015	0.070	-0.035	-0.121
Sub_metering_1	-0.057	0.247	0.245	0.060	-0.001	1.000	0.031	0.131	-0.131	0.000	0.067	-0.020	0.019	0.032	0.014	0.089	0.027
Sub_metering_2	0.000	0.203	0.222	0.477	-0.055	0.031	1.000	-0.020	-0.061	0.000	0.005	-0.009	0.049	0.048	0.035	0.003	-0.008
Sub_metering_3	-0.059	0.421	0.428	0.041	0.002	0.131	-0.020	1.000	-0.178	0.093	-0.051	-0.013	0.114	0.119	0.098	-0.033	-0.038
Voltage	0.062	-0.142	-0.172	-0.053	-0.004	-0.131	-0.061	-0.178	1.000	0.219	-0.040	0.110	-0.438	-0.436	-0.433	-0.096	0.026
Year	0.000	0.157	0.175	0.000	0.208	0.000	0.000	0.093	0.219	1.000	0.000	0.252	0.210	0.235	0.186	0.154	0.053
prcp	-0.060	-0.013	-0.008	0.044	-0.068	0.067	0.005	-0.051	-0.040	0.000	1.000	-0.397	-0.060	-0.092	0.018	0.330	0.338
pres	0.084	0.065	0.054	-0.097	0.141	-0.020	-0.009	-0.013	0.110	0.252	-0.397	1.000	-0.180	-0.174	-0.217	-0.101	-0.351
tavg	-0.067	-0.247	-0.211	0.140	0.040	0.019	0.049	0.114	-0.438	0.210	-0.060	-0.180	1.000	0.980	0.960	0.029	-0.123
tmax	-0.062	-0.236	-0.202	0.137	0.015	0.032	0.048	0.119	-0.436	0.235	-0.092	-0.174	0.980	1.000	0.909	-0.009	-0.152
tmin	-0.069	-0.251	-0.215	0.127	0.070	0.014	0.035	0.098	-0.433	0.186	0.018	-0.217	0.960	0.909	1.000	0.093	-0.060
wdir	-0.044	-0.025	-0.022	0.035	-0.035	0.089	0.003	-0.033	-0.096	0.154	0.330	-0.101	0.029	-0.009	0.093	1.000	0.128
wspd	-0.163	0.006	0.005	0.010	-0.121	0.027	-0.008	-0.038	0.026	0.053	0.338	-0.351	-0.123	-0.152	-0.060	0.128	1.000

Count
Matrix

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.

First rows
Last rows

	Global_active_power	Global_reactive_power	Voltage	Global_intensity	Sub_metering_2	Sub_metering_3	Datetime	tavg	tmin	tmax	prcp	snow	wdir	wspd	wpgt	pres	tsun	Year	Month	Day
0	1.044	0.152	242.73	4.4	2.0	0.0	2006-12-17	4.4	1.1	7.9	3.3	NaN	217.0	4.6	NaN	1029.5	NaN	2006	12	17
1	0.278	0.126	246.17	1.2	2.0	0.0	2006-12-18	4.6	3.4	6.0	0.0	NaN	125.0	6.5	NaN	1029.0	NaN	2006	12	18
2	0.414	0.242	241.19	2.0	1.0	0.0	2006-12-19	2.6	0.5	5.2	0.0	NaN	22.0	14.8	NaN	1034.1	NaN	2006	12	19
3	0.824	0.058	245.57	3.4	0.0	0.0	2006-12-20	2.9	0.5	5.7	0.0	NaN	21.0	13.5	NaN	1037.5	NaN	2006	12	20
4	1.814	0.148	243.51	7.6	0.0	18.0	2006-12-21	5.2	1.7	8.5	0.0	NaN	23.0	14.5	NaN	1039.4	NaN	2006	12	21
5	0.206	0.000	245.70	0.8	0.0	0.0	2006-12-22	5.1	3.8	6.8	0.0	NaN	30.0	15.0	NaN	1039.5	NaN	2006	12	22
6	2.328	0.000	241.25	9.6	0.0	0.0	2006-12-23	2.7	1.8	5.6	0.0	NaN	34.0	10.4	NaN	1038.2	NaN	2006	12	23
7	5.376	0.046	237.57	22.6	0.0	18.0	2006-12-24	2.4	1.6	2.8	0.0	NaN	65.0	7.4	NaN	1036.4	NaN	2006	12	24
8	0.586	0.260	243.65	2.6	1.0	0.0	2006-12-25	1.4	0.2	2.8	0.0	NaN	27.0	7.2	NaN	1035.5	NaN	2006	12	25
9	2.490	0.102	245.44	10.0	1.0	0.0	2006-12-26	0.3	-0.5	1.0	0.0	NaN	115.0	6.6	NaN	1034.2	NaN	2006	12	26

	Global_active_power	Global_reactive_power	Voltage	Global_intensity	Sub_metering_2	Sub_metering_3	Datetime	tavg	tmin	tmax	prcp	snow	wdir	wspd	wpgt	pres	tsun	Year	Month	Day
718	0.346	0.062	245.43	1.4	1.0	0.0	2008-12-04	4.8	0.2	10.3	0.0	10.0	198.0	10.6	NaN	994.8	NaN	2008	12	4
719	1.024	0.180	245.44	4.4	0.0	0.0	2008-12-05	6.9	5.9	8.3	5.6	10.0	225.0	15.1	NaN	991.4	NaN	2008	12	5
720	1.560	0.074	244.07	6.4	0.0	18.0	2008-12-06	7.0	5.8	8.9	2.3	10.0	283.0	11.7	NaN	1010.8	NaN	2008	12	6
721	1.452	0.142	246.23	5.8	0.0	0.0	2008-12-07	4.0	2.9	7.8	0.0	10.0	28.0	6.5	NaN	1027.2	NaN	2008	12	7
722	1.600	0.148	242.05	6.6	1.0	18.0	2008-12-08	2.0	1.1	3.5	0.0	10.0	135.0	6.9	NaN	1025.6	NaN	2008	12	8
723	0.218	0.048	246.58	0.8	0.0	0.0	2008-12-09	2.2	0.6	3.9	0.0	10.0	277.0	8.9	NaN	1018.1	NaN	2008	12	9
724	0.212	0.052	244.62	0.8	0.0	0.0	2008-12-10	3.4	2.3	4.8	3.3	10.0	322.0	11.0	NaN	1017.2	NaN	2008	12	10
725	0.336	0.086	244.49	1.4	0.0	0.0	2008-12-11	1.5	-0.5	4.7	0.0	10.0	216.0	6.2	NaN	1013.7	NaN	2008	12	11
726	0.372	0.062	242.86	1.6	0.0	0.0	2008-12-12	-0.9	-1.6	2.7	0.0	10.0	177.0	9.6	NaN	1018.5	NaN	2008	12	12
727	0.212	0.048	244.87	0.8	0.0	0.0	2008-12-13	0.3	-2.1	3.5	0.0	10.0	150.0	15.9	NaN	1001.4	NaN	2008	12	13

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample