Dataset statistics
Number of variables | 4 |
---|---|
Number of observations | 281198 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 9.4 MiB |
Average record size in memory | 35.0 B |
Variable types
Text | 1 |
---|---|
Numeric | 1 |
DateTime | 1 |
Boolean | 1 |
Dataset
Variable descriptions
experimentid | Experiment Id |
---|---|
userid | User id |
timestamp | show month(2), day(2), hour(2), minute(2), second(2), decimals(3) |
status | Return if the user is present or not |
experimentid has constant value "wenetIndia" | Constant |
userid has 100759 (35.8%) zeros | Zeros |
Reproduction
Analysis started | 2024-11-22 12:32:04.489083 |
---|---|
Analysis finished | 2024-11-22 12:32:05.623809 |
Duration | 1.13 second |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 4.8 MiB |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Characters and Unicode
Total characters | 2811980 |
---|---|
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 | 281198 |
Most occurring characters
Value | Count | Frequency (%) |
e | 562396 | |
n | 562396 | |
w | 281198 | |
t | 281198 | |
I | 281198 | |
d | 281198 | |
i | 281198 | |
a | 281198 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 2811980 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 562396 | |
n | 562396 | |
w | 281198 | |
t | 281198 | |
I | 281198 | |
d | 281198 | |
i | 281198 | |
a | 281198 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 2811980 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 562396 | |
n | 562396 | |
w | 281198 | |
t | 281198 | |
I | 281198 | |
d | 281198 | |
i | 281198 | |
a | 281198 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 2811980 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 562396 | |
n | 562396 | |
w | 281198 | |
t | 281198 | |
I | 281198 | |
d | 281198 | |
i | 281198 | |
a | 281198 |
Distinct | 20 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 12.59305187 |
Minimum | 0 |
---|---|
Maximum | 62 |
Zeros | 100759 |
Zeros (%) | 35.8% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.1 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 12 |
Q3 | 26 |
95-th percentile | 35 |
Maximum | 62 |
Range | 62 |
Interquartile range (IQR) | 26 |
Descriptive statistics
Standard deviation | 12.51441168 |
---|---|
Coefficient of variation (CV) | 0.9937552717 |
Kurtosis | 0.7930764788 |
Mean | 12.59305187 |
Median Absolute Deviation (MAD) | 12 |
Skewness | 0.9245361871 |
Sum | 3541141 |
Variance | 156.6104998 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=20)
Value | Count | Frequency (%) |
0 | 100759 | |
26 | 66860 | |
12 | 65076 | |
9 | 21719 | 7.7% |
35 | 5150 | 1.8% |
17 | 4835 | 1.7% |
24 | 3356 | 1.2% |
43 | 3079 | 1.1% |
4 | 2315 | 0.8% |
44 | 2196 | 0.8% |
Other values (10) | 5853 | 2.1% |
Value | Count | Frequency (%) |
0 | 100759 | |
4 | 2315 | 0.8% |
8 | 633 | 0.2% |
9 | 21719 | 7.7% |
12 | 65076 |
Value | Count | Frequency (%) |
62 | 1356 | |
57 | 1539 | |
49 | 591 | 0.2% |
46 | 156 | 0.1% |
44 | 2196 |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 281181 |
---|---|
Distinct (%) | > 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.1 MiB |
Minimum | 2021-07-12 08:05:14.999000 |
---|---|
Maximum | 2021-08-12 14:40:29.583000 |
Histogram with fixed size bins (bins=50)
status
Boolean
Return if the user is present or not
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 274.7 KiB |
False | |
---|---|
True |
Value | Count | Frequency (%) |
False | 243804 | |
True | 37394 | 13.3% |
status | userid | |
---|---|---|
status | 1.000 | 0.014 |
userid | 0.014 | 1.000 |