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 |