Dataset statistics
Number of variables | 4 |
---|---|
Number of observations | 11783870 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 668.8 MiB |
Average record size in memory | 59.5 B |
Variable types
Text | 2 |
---|---|
Numeric | 1 |
DateTime | 1 |
Dataset
Variable descriptions
experimentid | Experiment Id |
---|---|
userid | User id |
timestamp | show month(2), day(2), hour(2), minute(2), second(2), decimals(3) |
status | Return if the screen is ON |
experimentid has constant value "wenetItaly" | Constant |
Reproduction
Analysis started | 2024-11-23 06:05:46.113672 |
---|---|
Analysis finished | 2024-11-23 06:06:30.942561 |
Duration | 44.83 seconds |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 292.2 MiB |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Characters and Unicode
Total characters | 117838700 |
---|---|
Distinct characters | 8 |
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 | wenetItaly |
---|---|
2nd row | wenetItaly |
3rd row | wenetItaly |
4th row | wenetItaly |
5th row | wenetItaly |
Value | Count | Frequency (%) |
wenetitaly | 11783870 |
Most occurring characters
Value | Count | Frequency (%) |
e | 23567740 | |
t | 23567740 | |
w | 11783870 | |
n | 11783870 | |
I | 11783870 | |
a | 11783870 | |
l | 11783870 | |
y | 11783870 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 117838700 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 23567740 | |
t | 23567740 | |
w | 11783870 | |
n | 11783870 | |
I | 11783870 | |
a | 11783870 | |
l | 11783870 | |
y | 11783870 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 117838700 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 23567740 | |
t | 23567740 | |
w | 11783870 | |
n | 11783870 | |
I | 11783870 | |
a | 11783870 | |
l | 11783870 | |
y | 11783870 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 117838700 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 23567740 | |
t | 23567740 | |
w | 11783870 | |
n | 11783870 | |
I | 11783870 | |
a | 11783870 | |
l | 11783870 | |
y | 11783870 |
userid
Real number (ℝ)
User id
Distinct | 221 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 132.0191999 |
Minimum | 0 |
---|---|
Maximum | 265 |
Zeros | 5954 |
Zeros (%) | 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 179.8 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 18 |
Q1 | 58 |
median | 118 |
Q3 | 204 |
95-th percentile | 255 |
Maximum | 265 |
Range | 265 |
Interquartile range (IQR) | 146 |
Descriptive statistics
Standard deviation | 79.41900029 |
---|---|
Coefficient of variation (CV) | 0.6015715923 |
Kurtosis | -1.245445939 |
Mean | 132.0191999 |
Median Absolute Deviation (MAD) | 72 |
Skewness | 0.07454661916 |
Sum | 1555697089 |
Variance | 6307.377607 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
Value | Count | Frequency (%) |
111 | 543543 | 4.6% |
57 | 376437 | 3.2% |
118 | 322618 | 2.7% |
217 | 293832 | 2.5% |
175 | 284141 | 2.4% |
258 | 282134 | 2.4% |
245 | 270271 | 2.3% |
103 | 255287 | 2.2% |
18 | 229836 | 2.0% |
112 | 228135 | 1.9% |
Other values (211) | 8697636 |
Value | Count | Frequency (%) |
0 | 5954 | 0.1% |
1 | 55829 | |
2 | 49090 | |
3 | 43157 | |
4 | 13506 | 0.1% |
Value | Count | Frequency (%) |
265 | 69054 | |
264 | 818 | < 0.1% |
263 | 36198 | |
262 | 23941 | 0.2% |
260 | 352 | < 0.1% |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 11740109 |
---|---|
Distinct (%) | 99.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 179.8 MiB |
Minimum | 2020-11-16 07:00:00.202000 |
---|---|
Maximum | 2020-12-11 21:59:58.764000 |
Histogram with fixed size bins (bins=50)
status
Text
Return if the screen is ON
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 286.7 MiB |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 9.512468824 |
Min length | 9 |
Characters and Unicode
Total characters | 112093696 |
---|---|
Distinct characters | 8 |
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 | SCREEN_OFF |
---|---|
2nd row | SCREEN_ON |
3rd row | SCREEN_OFF |
4th row | SCREEN_ON |
5th row | SCREEN_OFF |
Value | Count | Frequency (%) |
screen_off | 6038866 | |
screen_on | 5745004 |
Most occurring characters
Value | Count | Frequency (%) |
E | 23567740 | |
N | 17528874 | |
F | 12077732 | |
S | 11783870 | |
C | 11783870 | |
R | 11783870 | |
_ | 11783870 | |
O | 11783870 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 112093696 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
E | 23567740 | |
N | 17528874 | |
F | 12077732 | |
S | 11783870 | |
C | 11783870 | |
R | 11783870 | |
_ | 11783870 | |
O | 11783870 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 112093696 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
E | 23567740 | |
N | 17528874 | |
F | 12077732 | |
S | 11783870 | |
C | 11783870 | |
R | 11783870 | |
_ | 11783870 | |
O | 11783870 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 112093696 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
E | 23567740 | |
N | 17528874 | |
F | 12077732 | |
S | 11783870 | |
C | 11783870 | |
R | 11783870 | |
_ | 11783870 | |
O | 11783870 |