Dataset statistics
| Number of variables | 4 |
|---|---|
| Number of observations | 46915 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Total size in memory | 1.7 MiB |
| Average record size in memory | 37.0 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 1 |
| DateTime | 1 |
| Boolean | 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 | The status of whether the mode is on or off |
experimentid has constant value "wenetDenmark" | Constant |
timestamp has unique values | Unique |
userid has 862 (1.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-23 01:50:58.893817 |
|---|---|
| Analysis finished | 2024-11-23 01:50:59.156831 |
| Duration | 0.26 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 916.4 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 562980 |
|---|---|
| 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 | 46915 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 140745 | |
| n | 93830 | |
| w | 46915 | 8.3% |
| t | 46915 | 8.3% |
| D | 46915 | 8.3% |
| m | 46915 | 8.3% |
| a | 46915 | 8.3% |
| r | 46915 | 8.3% |
| k | 46915 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 562980 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 140745 | |
| n | 93830 | |
| w | 46915 | 8.3% |
| t | 46915 | 8.3% |
| D | 46915 | 8.3% |
| m | 46915 | 8.3% |
| a | 46915 | 8.3% |
| r | 46915 | 8.3% |
| k | 46915 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 562980 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 140745 | |
| n | 93830 | |
| w | 46915 | 8.3% |
| t | 46915 | 8.3% |
| D | 46915 | 8.3% |
| m | 46915 | 8.3% |
| a | 46915 | 8.3% |
| r | 46915 | 8.3% |
| k | 46915 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 562980 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 140745 | |
| n | 93830 | |
| w | 46915 | 8.3% |
| t | 46915 | 8.3% |
| D | 46915 | 8.3% |
| m | 46915 | 8.3% |
| a | 46915 | 8.3% |
| r | 46915 | 8.3% |
| k | 46915 | 8.3% |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.95135884 |
| Minimum | 0 |
|---|---|
| Maximum | 27 |
| Zeros | 862 |
| Zeros (%) | 1.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 6 |
| Q3 | 17 |
| 95-th percentile | 23 |
| Maximum | 27 |
| Range | 27 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 6.736733201 |
|---|---|
| Coefficient of variation (CV) | 0.7525933571 |
| Kurtosis | -0.3337426433 |
| Mean | 8.95135884 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.044069494 |
| Sum | 419953 |
| Variance | 45.38357422 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 6 | 23706 | |
| 3 | 8584 | 18.3% |
| 17 | 5370 | 11.4% |
| 20 | 2976 | 6.3% |
| 23 | 1840 | 3.9% |
| 16 | 879 | 1.9% |
| 0 | 862 | 1.8% |
| 2 | 825 | 1.8% |
| 25 | 580 | 1.2% |
| 19 | 350 | 0.7% |
| Other values (6) | 943 | 2.0% |
| Value | Count | Frequency (%) |
| 0 | 862 | 1.8% |
| 2 | 825 | 1.8% |
| 3 | 8584 | 18.3% |
| 6 | 23706 | |
| 12 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 27 | 336 | 0.7% |
| 26 | 134 | 0.3% |
| 25 | 580 | 1.2% |
| 23 | 1840 | |
| 22 | 16 | < 0.1% |
| Distinct | 46915 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| Minimum | 2020-11-16 07:28:41.046000 |
|---|---|
| Maximum | 2020-12-11 21:40:38.835000 |
Histogram with fixed size bins (bins=50)
status
Boolean
The status of whether the mode is on or off
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 45.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 28764 | |
| True | 18151 |
| status | userid | |
|---|---|---|
| status | 1.000 | 0.094 |
| userid | 0.094 | 1.000 |