Dataset statistics
Number of variables | 4 |
---|---|
Number of observations | 311079 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 13.1 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 distance value (cm, centimeter) |
experimentid has constant value "wenetDenmark" | Constant |
userid has 6863 (2.2%) zeros | Zeros |
value has 130796 (42.0%) zeros | Zeros |
Reproduction
Analysis started | 2024-11-23 02:40:08.996965 |
---|---|
Analysis finished | 2024-11-23 02:40:10.137228 |
Duration | 1.14 second |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 5.9 MiB |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Characters and Unicode
Total characters | 3732948 |
---|---|
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 | 311079 |
Most occurring characters
Value | Count | Frequency (%) |
e | 933237 | |
n | 622158 | |
w | 311079 | 8.3% |
t | 311079 | 8.3% |
D | 311079 | 8.3% |
m | 311079 | 8.3% |
a | 311079 | 8.3% |
r | 311079 | 8.3% |
k | 311079 | 8.3% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 3732948 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 933237 | |
n | 622158 | |
w | 311079 | 8.3% |
t | 311079 | 8.3% |
D | 311079 | 8.3% |
m | 311079 | 8.3% |
a | 311079 | 8.3% |
r | 311079 | 8.3% |
k | 311079 | 8.3% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 3732948 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 933237 | |
n | 622158 | |
w | 311079 | 8.3% |
t | 311079 | 8.3% |
D | 311079 | 8.3% |
m | 311079 | 8.3% |
a | 311079 | 8.3% |
r | 311079 | 8.3% |
k | 311079 | 8.3% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 3732948 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 933237 | |
n | 622158 | |
w | 311079 | 8.3% |
t | 311079 | 8.3% |
D | 311079 | 8.3% |
m | 311079 | 8.3% |
a | 311079 | 8.3% |
r | 311079 | 8.3% |
k | 311079 | 8.3% |
Distinct | 17 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 18.2072046 |
Minimum | 0 |
---|---|
Maximum | 27 |
Zeros | 6863 |
Zeros (%) | 2.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.4 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 2 |
Q1 | 17 |
median | 20 |
Q3 | 26 |
95-th percentile | 26 |
Maximum | 27 |
Range | 27 |
Interquartile range (IQR) | 9 |
Descriptive statistics
Standard deviation | 8.30357827 |
---|---|
Coefficient of variation (CV) | 0.4560600296 |
Kurtosis | -0.3057496149 |
Mean | 18.2072046 |
Median Absolute Deviation (MAD) | 5 |
Skewness | -1.031546868 |
Sum | 5663879 |
Variance | 68.94941209 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=17)
Value | Count | Frequency (%) |
20 | 85432 | |
26 | 76074 | |
2 | 25477 | 8.2% |
17 | 22440 | 7.2% |
6 | 16572 | 5.3% |
21 | 16349 | 5.3% |
25 | 16223 | 5.2% |
23 | 14165 | 4.6% |
3 | 13313 | 4.3% |
0 | 6863 | 2.2% |
Other values (7) | 18171 | 5.8% |
Value | Count | Frequency (%) |
0 | 6863 | 2.2% |
2 | 25477 | |
3 | 13313 | |
6 | 16572 | |
8 | 3456 | 1.1% |
Value | Count | Frequency (%) |
27 | 4964 | 1.6% |
26 | 76074 | |
25 | 16223 | 5.2% |
23 | 14165 | 4.6% |
22 | 1548 | 0.5% |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 311047 |
---|---|
Distinct (%) | > 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.4 MiB |
Minimum | 2020-11-16 07:05:55.291000 |
---|---|
Maximum | 2020-12-11 21:59:25.255000 |
Histogram with fixed size bins (bins=50)
Distinct | 6 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 6.650648228 |
Minimum | 0 |
---|---|
Maximum | 100 |
Zeros | 130796 |
Zeros (%) | 42.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.4 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 5 |
Q3 | 5 |
95-th percentile | 8 |
Maximum | 100 |
Range | 100 |
Interquartile range (IQR) | 5 |
Descriptive statistics
Standard deviation | 19.01143098 |
---|---|
Coefficient of variation (CV) | 2.858583153 |
Kurtosis | 19.74210884 |
Mean | 6.650648228 |
Median Absolute Deviation (MAD) | 3 |
Skewness | 4.611562562 |
Sum | 2068877 |
Variance | 361.4345079 |
Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
Value | Count | Frequency (%) |
5 | 140699 | |
0 | 130796 | |
8 | 14107 | 4.5% |
100 | 12167 | 3.9% |
3 | 11258 | 3.6% |
1 | 2052 | 0.7% |
Value | Count | Frequency (%) |
0 | 130796 | |
1 | 2052 | 0.7% |
3 | 11258 | 3.6% |
5 | 140699 | |
8 | 14107 | 4.5% |
Value | Count | Frequency (%) |
100 | 12167 | 3.9% |
8 | 14107 | 4.5% |
5 | 140699 | |
3 | 11258 | 3.6% |
1 | 2052 | 0.7% |
userid | value | |
---|---|---|
userid | 1.000 | -0.110 |
value | -0.110 | 1.000 |