Dataset statistics
| Number of variables | 4 |
|---|---|
| Number of observations | 635166 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Total size in memory | 25.4 MiB |
| Average record size in memory | 42.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 "wenetIndia" | Constant |
userid has 25323 (4.0%) zeros | Zeros |
value has 150178 (23.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-22 13:04:45.865708 |
|---|---|
| Analysis finished | 2024-11-22 13:04:47.939121 |
| Duration | 2.07 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.9 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 6351660 |
|---|---|
| Distinct characters | 8 |
| 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 | wenetIndia |
|---|---|
| 2nd row | wenetIndia |
| 3rd row | wenetIndia |
| 4th row | wenetIndia |
| 5th row | wenetIndia |
| Value | Count | Frequency (%) |
| wenetindia | 635166 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1270332 | |
| n | 1270332 | |
| w | 635166 | |
| t | 635166 | |
| I | 635166 | |
| d | 635166 | |
| i | 635166 | |
| a | 635166 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6351660 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1270332 | |
| n | 1270332 | |
| w | 635166 | |
| t | 635166 | |
| I | 635166 | |
| d | 635166 | |
| i | 635166 | |
| a | 635166 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6351660 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1270332 | |
| n | 1270332 | |
| w | 635166 | |
| t | 635166 | |
| I | 635166 | |
| d | 635166 | |
| i | 635166 | |
| a | 635166 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6351660 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1270332 | |
| n | 1270332 | |
| w | 635166 | |
| t | 635166 | |
| I | 635166 | |
| d | 635166 | |
| i | 635166 | |
| a | 635166 |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.70121354 |
| Minimum | 0 |
|---|---|
| Maximum | 62 |
| Zeros | 25323 |
| Zeros (%) | 4.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 40 |
| median | 40 |
| Q3 | 40 |
| 95-th percentile | 46 |
| Maximum | 62 |
| Range | 62 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 11.32361136 |
|---|---|
| Coefficient of variation (CV) | 0.3085350664 |
| Kurtosis | 4.10905626 |
| Mean | 36.70121354 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.275047896 |
| Sum | 23311363 |
| Variance | 128.2241742 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 40 | 472227 | |
| 46 | 65669 | 10.3% |
| 0 | 25323 | 4.0% |
| 8 | 23623 | 3.7% |
| 35 | 10858 | 1.7% |
| 17 | 7356 | 1.2% |
| 9 | 6297 | 1.0% |
| 4 | 4502 | 0.7% |
| 26 | 4427 | 0.7% |
| 24 | 2702 | 0.4% |
| Other values (10) | 12182 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 25323 | |
| 4 | 4502 | 0.7% |
| 8 | 23623 | |
| 9 | 6297 | 1.0% |
| 12 | 1324 | 0.2% |
| Value | Count | Frequency (%) |
| 62 | 1156 | 0.2% |
| 57 | 1957 | 0.3% |
| 49 | 1031 | 0.2% |
| 46 | 65669 | |
| 44 | 93 | < 0.1% |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
| Distinct | 635154 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| Minimum | 2021-07-12 08:02:18.159000 |
|---|---|
| Maximum | 2021-08-12 14:41:25.366000 |
Histogram with fixed size bins (bins=50)
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.824908764 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 150178 |
| Zeros (%) | 23.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.133413502 |
|---|---|
| Coefficient of variation (CV) | 0.5577684682 |
| Kurtosis | -0.4523065597 |
| Mean | 3.824908764 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.217624067 |
| Sum | 2429452 |
| Variance | 4.551453171 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=3)
| Value | Count | Frequency (%) |
| 5 | 483484 | |
| 0 | 150178 | 23.6% |
| 8 | 1504 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 150178 | 23.6% |
| 5 | 483484 | |
| 8 | 1504 | 0.2% |
| Value | Count | Frequency (%) |
| 8 | 1504 | 0.2% |
| 5 | 483484 | |
| 0 | 150178 | 23.6% |
| userid | value | |
|---|---|---|
| userid | 1.000 | 0.119 |
| value | 0.119 | 1.000 |