Dataset statistics
Number of variables | 4 |
---|---|
Number of observations | 474108 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 19.9 MiB |
Average record size in memory | 44.0 B |
Variable types
Text | 1 |
---|---|
Numeric | 2 |
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) |
value | The number of steps |
experimentid has constant value "wenetDenmark" | Constant |
userid has 39497 (8.3%) zeros | Zeros |
Reproduction
Analysis started | 2024-11-23 02:05:03.872931 |
---|---|
Analysis finished | 2024-11-23 02:05:05.740583 |
Duration | 1.87 second |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 9.0 MiB |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Characters and Unicode
Total characters | 5689296 |
---|---|
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 | 474108 |
Most occurring characters
Value | Count | Frequency (%) |
e | 1422324 | |
n | 948216 | |
w | 474108 | 8.3% |
t | 474108 | 8.3% |
D | 474108 | 8.3% |
m | 474108 | 8.3% |
a | 474108 | 8.3% |
r | 474108 | 8.3% |
k | 474108 | 8.3% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 5689296 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 1422324 | |
n | 948216 | |
w | 474108 | 8.3% |
t | 474108 | 8.3% |
D | 474108 | 8.3% |
m | 474108 | 8.3% |
a | 474108 | 8.3% |
r | 474108 | 8.3% |
k | 474108 | 8.3% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 5689296 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 1422324 | |
n | 948216 | |
w | 474108 | 8.3% |
t | 474108 | 8.3% |
D | 474108 | 8.3% |
m | 474108 | 8.3% |
a | 474108 | 8.3% |
r | 474108 | 8.3% |
k | 474108 | 8.3% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 5689296 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 1422324 | |
n | 948216 | |
w | 474108 | 8.3% |
t | 474108 | 8.3% |
D | 474108 | 8.3% |
m | 474108 | 8.3% |
a | 474108 | 8.3% |
r | 474108 | 8.3% |
k | 474108 | 8.3% |
Distinct | 14 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 14.90895113 |
Minimum | 0 |
---|---|
Maximum | 27 |
Zeros | 39497 |
Zeros (%) | 8.3% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.6 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 6 |
median | 17 |
Q3 | 21 |
95-th percentile | 27 |
Maximum | 27 |
Range | 27 |
Interquartile range (IQR) | 15 |
Descriptive statistics
Standard deviation | 8.498390127 |
---|---|
Coefficient of variation (CV) | 0.5700193163 |
Kurtosis | -0.9855742791 |
Mean | 14.90895113 |
Median Absolute Deviation (MAD) | 4 |
Skewness | -0.4342805832 |
Sum | 7068453 |
Variance | 72.22263475 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=14)
Value | Count | Frequency (%) |
17 | 190453 | |
6 | 53296 | 11.2% |
26 | 50620 | 10.7% |
0 | 39497 | 8.3% |
21 | 35691 | 7.5% |
2 | 33625 | 7.1% |
27 | 27763 | 5.9% |
20 | 18486 | 3.9% |
3 | 12741 | 2.7% |
25 | 6773 | 1.4% |
Other values (4) | 5163 | 1.1% |
Value | Count | Frequency (%) |
0 | 39497 | |
2 | 33625 | |
3 | 12741 | 2.7% |
6 | 53296 | |
8 | 4091 | 0.9% |
Value | Count | Frequency (%) |
27 | 27763 | |
26 | 50620 | |
25 | 6773 | 1.4% |
22 | 123 | < 0.1% |
21 | 35691 |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 474042 |
---|---|
Distinct (%) | > 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 3.6 MiB |
Minimum | 2020-11-16 07:00:00.452000 |
---|---|
Maximum | 2020-12-11 21:59:59.724000 |
Histogram with fixed size bins (bins=50)
value
Real number (ℝ)
The number of steps
Distinct | 134250 |
---|---|
Distinct (%) | 28.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 43518.8592 |
Minimum | 0 |
---|---|
Maximum | 364089 |
Zeros | 647 |
Zeros (%) | 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.6 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 1154 |
Q1 | 7615 |
median | 27001 |
Q3 | 66893.25 |
95-th percentile | 126246 |
Maximum | 364089 |
Range | 364089 |
Interquartile range (IQR) | 59278.25 |
Descriptive statistics
Standard deviation | 45772.02215 |
---|---|
Coefficient of variation (CV) | 1.051774403 |
Kurtosis | 2.698394126 |
Mean | 43518.8592 |
Median Absolute Deviation (MAD) | 23140 |
Skewness | 1.525696018 |
Sum | 2.06326393 × 1010 |
Variance | 2095078012 |
Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
Value | Count | Frequency (%) |
3281 | 869 | 0.2% |
0 | 647 | 0.1% |
96078 | 629 | 0.1% |
8454 | 609 | 0.1% |
51359 | 535 | 0.1% |
81643 | 517 | 0.1% |
59380 | 515 | 0.1% |
44431 | 509 | 0.1% |
3269 | 481 | 0.1% |
34643 | 467 | 0.1% |
Other values (134240) | 468330 |
Value | Count | Frequency (%) |
0 | 647 | |
2 | 1 | < 0.1% |
3 | 1 | < 0.1% |
4 | 1 | < 0.1% |
5 | 1 | < 0.1% |
Value | Count | Frequency (%) |
364089 | 1 | |
364011 | 1 | |
363918 | 1 | |
363807 | 1 | |
363793 | 1 |
userid | value | |
---|---|---|
userid | 1.000 | -0.066 |
value | -0.066 | 1.000 |