Dataset statistics
Number of variables | 3 |
---|---|
Number of observations | 109321261 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Total size in memory | 4.3 GiB |
Average record size in memory | 42.0 B |
Variable types
Text | 1 |
---|---|
Numeric | 1 |
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) |
experimentid has constant value "wenetItaly" | Constant |
Reproduction
Analysis started | 2024-11-23 05:59:15.769433 |
---|---|
Analysis finished | 2024-11-23 06:05:10.543881 |
Duration | 5 minutes and 54.77 seconds |
Software version | ydata-profiling v4.8.3 |
Download configuration | config.json |
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.6 GiB |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Characters and Unicode
Total characters | 1093212610 |
---|---|
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 | 109321261 |
Most occurring characters
Value | Count | Frequency (%) |
e | 218642522 | |
t | 218642522 | |
w | 109321261 | |
n | 109321261 | |
I | 109321261 | |
a | 109321261 | |
l | 109321261 | |
y | 109321261 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 1093212610 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 218642522 | |
t | 218642522 | |
w | 109321261 | |
n | 109321261 | |
I | 109321261 | |
a | 109321261 | |
l | 109321261 | |
y | 109321261 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 1093212610 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 218642522 | |
t | 218642522 | |
w | 109321261 | |
n | 109321261 | |
I | 109321261 | |
a | 109321261 | |
l | 109321261 | |
y | 109321261 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 1093212610 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 218642522 | |
t | 218642522 | |
w | 109321261 | |
n | 109321261 | |
I | 109321261 | |
a | 109321261 | |
l | 109321261 | |
y | 109321261 |
userid
Real number (ℝ)
User id
Distinct | 182 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 139.5866532 |
Minimum | 1 |
---|---|
Maximum | 264 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.6 GiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 15 |
Q1 | 66 |
median | 148 |
Q3 | 212 |
95-th percentile | 255 |
Maximum | 264 |
Range | 263 |
Interquartile range (IQR) | 146 |
Descriptive statistics
Standard deviation | 80.5261362 |
---|---|
Coefficient of variation (CV) | 0.5768899414 |
Kurtosis | -1.347967992 |
Mean | 139.5866532 |
Median Absolute Deviation (MAD) | 73 |
Skewness | -0.109273064 |
Sum | 1.525978895 × 1010 |
Variance | 6484.458611 |
Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
Value | Count | Frequency (%) |
75 | 5409345 | 4.9% |
66 | 4932780 | 4.5% |
212 | 3447419 | 3.2% |
245 | 3398455 | 3.1% |
58 | 3340294 | 3.1% |
258 | 3149781 | 2.9% |
175 | 2501973 | 2.3% |
161 | 2351035 | 2.2% |
221 | 2324510 | 2.1% |
118 | 2189917 | 2.0% |
Other values (172) | 76275752 |
Value | Count | Frequency (%) |
1 | 773315 | |
2 | 424572 | |
3 | 785524 | |
4 | 166408 | 0.2% |
5 | 924568 |
Value | Count | Frequency (%) |
264 | 117301 | 0.1% |
263 | 904742 | |
262 | 215260 | 0.2% |
260 | 13492 | < 0.1% |
259 | 203399 | 0.2% |
timestamp
Date
show month(2), day(2), hour(2), minute(2), second(2), decimals(3)
Distinct | 105766935 |
---|---|
Distinct (%) | 96.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 GiB |
Minimum | 2020-11-16 07:00:00.718000 |
---|---|
Maximum | 2020-12-11 21:59:59.921000 |
Histogram with fixed size bins (bins=50)