Dataset statistics
Number of variables | 3 |
---|---|
Number of observations | 410508 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 14.1 MiB |
Average record size in memory | 36.0 B |
Variable types
Text | 1 |
---|---|
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) |
experimentid has constant value "wenetDenmark" | Constant |
userid has 36640 (8.9%) zeros | Zeros |
Reproduction
Analysis started | 2024-11-23 01:51:53.115910 |
---|---|
Analysis finished | 2024-11-23 01:51:54.491538 |
Duration | 1.38 second |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.8 MiB |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Characters and Unicode
Total characters | 4926096 |
---|---|
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 | 410508 |
Most occurring characters
Value | Count | Frequency (%) |
e | 1231524 | |
n | 821016 | |
w | 410508 | 8.3% |
t | 410508 | 8.3% |
D | 410508 | 8.3% |
m | 410508 | 8.3% |
a | 410508 | 8.3% |
r | 410508 | 8.3% |
k | 410508 | 8.3% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 4926096 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 1231524 | |
n | 821016 | |
w | 410508 | 8.3% |
t | 410508 | 8.3% |
D | 410508 | 8.3% |
m | 410508 | 8.3% |
a | 410508 | 8.3% |
r | 410508 | 8.3% |
k | 410508 | 8.3% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 4926096 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 1231524 | |
n | 821016 | |
w | 410508 | 8.3% |
t | 410508 | 8.3% |
D | 410508 | 8.3% |
m | 410508 | 8.3% |
a | 410508 | 8.3% |
r | 410508 | 8.3% |
k | 410508 | 8.3% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 4926096 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 1231524 | |
n | 821016 | |
w | 410508 | 8.3% |
t | 410508 | 8.3% |
D | 410508 | 8.3% |
m | 410508 | 8.3% |
a | 410508 | 8.3% |
r | 410508 | 8.3% |
k | 410508 | 8.3% |
Distinct | 9 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 13.01571224 |
Minimum | 0 |
---|---|
Maximum | 27 |
Zeros | 36640 |
Zeros (%) | 8.9% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 3.1 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 6 |
median | 17 |
Q3 | 17 |
95-th percentile | 27 |
Maximum | 27 |
Range | 27 |
Interquartile range (IQR) | 11 |
Descriptive statistics
Standard deviation | 8.050025539 |
---|---|
Coefficient of variation (CV) | 0.6184852116 |
Kurtosis | -1.116572444 |
Mean | 13.01571224 |
Median Absolute Deviation (MAD) | 4 |
Skewness | -0.3071962849 |
Sum | 5343054 |
Variance | 64.80291117 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=9)
Value | Count | Frequency (%) |
17 | 197845 | |
6 | 52359 | 12.8% |
2 | 47569 | 11.6% |
0 | 36640 | 8.9% |
21 | 33116 | 8.1% |
27 | 27343 | 6.7% |
3 | 10738 | 2.6% |
22 | 4571 | 1.1% |
12 | 327 | 0.1% |
Value | Count | Frequency (%) |
0 | 36640 | |
2 | 47569 | |
3 | 10738 | 2.6% |
6 | 52359 | |
12 | 327 | 0.1% |
Value | Count | Frequency (%) |
27 | 27343 | 6.7% |
22 | 4571 | 1.1% |
21 | 33116 | 8.1% |
17 | 197845 | |
12 | 327 | 0.1% |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 410459 |
---|---|
Distinct (%) | > 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 3.1 MiB |
Minimum | 2020-11-16 07:36:51.616000 |
---|---|
Maximum | 2020-12-11 21:59:59.744000 |
Histogram with fixed size bins (bins=50)