Dataset statistics
Number of variables | 3 |
---|---|
Number of observations | 4949365 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 207.7 MiB |
Average record size in memory | 44.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 308744 (6.2%) zeros | Zeros |
Reproduction
Analysis started | 2024-11-23 01:51:12.462510 |
---|---|
Analysis finished | 2024-11-23 01:51:28.250681 |
Duration | 15.79 seconds |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 132.2 MiB |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Characters and Unicode
Total characters | 59392380 |
---|---|
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 | 4949365 |
Most occurring characters
Value | Count | Frequency (%) |
e | 14848095 | |
n | 9898730 | |
w | 4949365 | 8.3% |
t | 4949365 | 8.3% |
D | 4949365 | 8.3% |
m | 4949365 | 8.3% |
a | 4949365 | 8.3% |
r | 4949365 | 8.3% |
k | 4949365 | 8.3% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 59392380 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 14848095 | |
n | 9898730 | |
w | 4949365 | 8.3% |
t | 4949365 | 8.3% |
D | 4949365 | 8.3% |
m | 4949365 | 8.3% |
a | 4949365 | 8.3% |
r | 4949365 | 8.3% |
k | 4949365 | 8.3% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 59392380 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 14848095 | |
n | 9898730 | |
w | 4949365 | 8.3% |
t | 4949365 | 8.3% |
D | 4949365 | 8.3% |
m | 4949365 | 8.3% |
a | 4949365 | 8.3% |
r | 4949365 | 8.3% |
k | 4949365 | 8.3% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 59392380 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 14848095 | |
n | 9898730 | |
w | 4949365 | 8.3% |
t | 4949365 | 8.3% |
D | 4949365 | 8.3% |
m | 4949365 | 8.3% |
a | 4949365 | 8.3% |
r | 4949365 | 8.3% |
k | 4949365 | 8.3% |
Distinct | 13 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 11.74016869 |
Minimum | 0 |
---|---|
Maximum | 27 |
Zeros | 308744 |
Zeros (%) | 6.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 75.5 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 3 |
median | 17 |
Q3 | 17 |
95-th percentile | 26 |
Maximum | 27 |
Range | 27 |
Interquartile range (IQR) | 14 |
Descriptive statistics
Standard deviation | 8.333247111 |
---|---|
Coefficient of variation (CV) | 0.7098064203 |
Kurtosis | -1.426766479 |
Mean | 11.74016869 |
Median Absolute Deviation (MAD) | 9 |
Skewness | 0.1166561648 |
Sum | 58106380 |
Variance | 69.44300741 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=13)
Value | Count | Frequency (%) |
17 | 1596043 | |
6 | 861699 | |
3 | 858043 | |
21 | 382192 | 7.7% |
2 | 335547 | 6.8% |
0 | 308744 | 6.2% |
26 | 221353 | 4.5% |
27 | 102630 | 2.1% |
22 | 86980 | 1.8% |
25 | 85560 | 1.7% |
Other values (3) | 110574 | 2.2% |
Value | Count | Frequency (%) |
0 | 308744 | 6.2% |
2 | 335547 | 6.8% |
3 | 858043 | |
6 | 861699 | |
12 | 32059 | 0.6% |
Value | Count | Frequency (%) |
27 | 102630 | 2.1% |
26 | 221353 | |
25 | 85560 | 1.7% |
22 | 86980 | 1.8% |
21 | 382192 |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 4944224 |
---|---|
Distinct (%) | 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 75.5 MiB |
Minimum | 2020-11-16 07:00:07.839000 |
---|---|
Maximum | 2020-12-11 21:59:49.265000 |
Histogram with fixed size bins (bins=50)