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 |