Dataset statistics
Number of variables | 4 |
---|---|
Number of observations | 7101410 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 291.2 MiB |
Average record size in memory | 43.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 "wenetItaly" | Constant |
Reproduction
Analysis started | 2024-11-23 05:56:42.112610 |
---|---|
Analysis finished | 2024-11-23 05:57:04.368653 |
Duration | 22.26 seconds |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 176.1 MiB |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Characters and Unicode
Total characters | 71014100 |
---|---|
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 | wenetItaly |
---|---|
2nd row | wenetItaly |
3rd row | wenetItaly |
4th row | wenetItaly |
5th row | wenetItaly |
Value | Count | Frequency (%) |
wenetitaly | 7101410 |
Most occurring characters
Value | Count | Frequency (%) |
e | 14202820 | |
t | 14202820 | |
w | 7101410 | |
n | 7101410 | |
I | 7101410 | |
a | 7101410 | |
l | 7101410 | |
y | 7101410 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 71014100 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 14202820 | |
t | 14202820 | |
w | 7101410 | |
n | 7101410 | |
I | 7101410 | |
a | 7101410 | |
l | 7101410 | |
y | 7101410 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 71014100 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 14202820 | |
t | 14202820 | |
w | 7101410 | |
n | 7101410 | |
I | 7101410 | |
a | 7101410 | |
l | 7101410 | |
y | 7101410 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 71014100 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 14202820 | |
t | 14202820 | |
w | 7101410 | |
n | 7101410 | |
I | 7101410 | |
a | 7101410 | |
l | 7101410 | |
y | 7101410 |
userid
Real number (ℝ)
User id
Distinct | 221 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 131.8959249 |
Minimum | 0 |
---|---|
Maximum | 265 |
Zeros | 4726 |
Zeros (%) | 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 108.4 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 15 |
Q1 | 58 |
median | 118 |
Q3 | 204 |
95-th percentile | 255 |
Maximum | 265 |
Range | 265 |
Interquartile range (IQR) | 146 |
Descriptive statistics
Standard deviation | 79.38368609 |
---|---|
Coefficient of variation (CV) | 0.6018661013 |
Kurtosis | -1.243176789 |
Mean | 131.8959249 |
Median Absolute Deviation (MAD) | 72 |
Skewness | 0.0718602361 |
Sum | 936647040 |
Variance | 6301.769617 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
Value | Count | Frequency (%) |
111 | 345648 | 4.9% |
57 | 209006 | 2.9% |
118 | 181494 | 2.6% |
245 | 172048 | 2.4% |
175 | 166063 | 2.3% |
217 | 164905 | 2.3% |
258 | 162598 | 2.3% |
103 | 153235 | 2.2% |
75 | 140003 | 2.0% |
112 | 130958 | 1.8% |
Other values (211) | 5275452 |
Value | Count | Frequency (%) |
0 | 4726 | 0.1% |
1 | 35578 | |
2 | 28775 | |
3 | 28083 | |
4 | 10418 | 0.1% |
Value | Count | Frequency (%) |
265 | 39517 | |
264 | 623 | < 0.1% |
263 | 21113 | |
262 | 15776 | 0.2% |
260 | 623 | < 0.1% |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 7085247 |
---|---|
Distinct (%) | 99.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 108.4 MiB |
Minimum | 2020-11-16 07:00:00.192000 |
---|---|
Maximum | 2020-12-11 21:59:51.161000 |
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 | 61.0 MiB |
False | |
---|---|
True |
Value | Count | Frequency (%) |
False | 6102935 | |
True | 998475 | 14.1% |
status | userid | |
---|---|---|
status | 1.000 | -0.005 |
userid | -0.005 | 1.000 |