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 |