Light

Dataset statistics

Number of variables	4
Number of observations	28208464
Missing cells	0
Missing cells (%)	0.0%
Total size in memory	1.4 GiB
Average record size in memory	52.0 B

Variable types

Text	1
Numeric	2
DateTime	1

Dataset

Description	[lx] Illuminance. To compare each sensor observation, the frequency was reduced to one minute. The first non-missing name is reported for each of the categorical variables.
Creator	Andrea Bontempelli, Matteo Busso, Roy Alia Asiku
Author	Andrea Bontempelli, Matteo Busso, Fausto Giunchiglia
URL
Copyright	(c) University of Trento - Knowledge Diversity 2023

Variable descriptions

experimentid	Experiment Id
userid	User id
timestamp	show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
value	The ambient light level in SI lux units

Alerts

`experimentid` has constant value "wenetDenmark"	Constant
`value` is highly skewed (γ1 = 64.953274)	Skewed
`userid` has 6637628 (23.5%) zeros	Zeros
`value` has 10575001 (37.5%) zeros	Zeros

Reproduction

Analysis started	2024-11-23 02:35:03.058165
Analysis finished	2024-11-23 02:36:54.275291
Duration	1 minute and 51.22 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

experimentid
Text

CONSTANT

Experiment Id

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	753.2 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	338501568
Distinct characters	9
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	wenetDenmark
2nd row	wenetDenmark
3rd row	wenetDenmark
4th row	wenetDenmark
5th row	wenetDenmark

Value	Count	Frequency (%)
wenetdenmark	28208464	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	84625392	25.0%
n	56416928	16.7%
w	28208464	8.3%
t	28208464	8.3%
D	28208464	8.3%
m	28208464	8.3%
a	28208464	8.3%
r	28208464	8.3%
k	28208464	8.3%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	84625392	25.0%
n	56416928	16.7%
w	28208464	8.3%
t	28208464	8.3%
D	28208464	8.3%
m	28208464	8.3%
a	28208464	8.3%
r	28208464	8.3%
k	28208464	8.3%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	84625392	25.0%
n	56416928	16.7%
w	28208464	8.3%
t	28208464	8.3%
D	28208464	8.3%
m	28208464	8.3%
a	28208464	8.3%
r	28208464	8.3%
k	28208464	8.3%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	84625392	25.0%
n	56416928	16.7%
w	28208464	8.3%
t	28208464	8.3%
D	28208464	8.3%
m	28208464	8.3%
a	28208464	8.3%
r	28208464	8.3%
k	28208464	8.3%

userid
Real number (ℝ)

ZEROS

User id

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.829913674

Minimum	0
Maximum	27
Zeros	6637628
Zeros (%)	23.5%
Negative	0
Negative (%)	0.0%
Memory size	430.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	6
Q3	20
95-th percentile	26
Maximum	27
Range	27
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	9.850967567
Coefficient of variation (CV)	1.002141819
Kurtosis	-1.208658235
Mean	9.829913674
Median Absolute Deviation (MAD)	6
Skewness	0.6702756727
Sum	277286766
Variance	97.041562
Monotonicity	Increasing

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	6637628	23.5%
6	6488825	23.0%
3	4502828	16.0%
26	3700909	13.1%
25	1718927	6.1%
17	1356653	4.8%
8	904023	3.2%
20	858978	3.0%
21	756342	2.7%
23	375348	1.3%
Other values (7)	908003	3.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6637628	23.5%
2	269945	1.0%
3	4502828	16.0%
6	6488825	23.0%
8	904023	3.2%

Value	Count	Frequency (%)
27	235405	0.8%
26	3700909	13.1%
25	1718927	6.1%
23	375348	1.3%
22	14498	0.1%

timestamp
Date

show month(2), day(2), hour(2), minute(2), second(2), decimals(3)

Distinct	28056559
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	430.4 MiB

Minimum	2020-11-16 07:00:00.009000
Maximum	2020-12-11 21:59:59.858000

Histogram

Histogram with fixed size bins (bins=50)

value
Real number (ℝ)

SKEWED ZEROS

The ambient light level in SI lux units

Distinct	138090
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.73917191

Minimum	0
Maximum	416450.1875
Zeros	10575001
Zeros (%)	37.5%
Negative	0
Negative (%)	0.0%
Memory size	430.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4.46999979
Q3	29.23999977
95-th percentile	254
Maximum	416450.1875
Range	416450.1875
Interquartile range (IQR)	29.23999977

Descriptive statistics

Standard deviation	978.5301604
Coefficient of variation (CV)	10.32867546
Kurtosis	10669.17257
Mean	94.73917191
Median Absolute Deviation (MAD)	4.46999979
Skewness	64.953274
Sum	2672446520
Variance	957521.2748
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10575001	37.5%
1	814327	2.9%
2	762362	2.7%
3	447727	1.6%
4	351789	1.2%
8	306321	1.1%
5	279198	1.0%
21	271161	1.0%
10	249717	0.9%
11	245129	0.9%
Other values (138080)	13905732	49.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10575001	37.5%
0.009999999776	1255	< 0.1%
0.01999999955	68	< 0.1%
0.02999999933	95	< 0.1%
0.03999999911	36	< 0.1%

Value	Count	Frequency (%)
416450.1875	1	< 0.1%
272040	1	< 0.1%
266722	1	< 0.1%
258831	1	< 0.1%
251384	1	< 0.1%

Auto

Heatmap
Table

	userid	value
userid	1.000	0.176
value	0.176	1.000

Overview

Variables

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)

Correlations