Overview

Brought to you by YData

Dataset statistics

Number of variables6
Number of observations161868530
Missing cells0
Missing cells (%)0.0%
Total size in memory10.0 GiB
Average record size in memory66.1 B

Variable types

Text1
Numeric4
DateTime1

Dataset

Description[m/s2] Acceleration force along the x,y,z axis (including gravity). To compare each sensor observation, the frequency was reduced to one minute. The first non-missing name is reported for each of the categorical variables. NOTE: The dataset was sampled to fit into available memory. Results may not reflect the entire dataset.
Creatorname
Authorname
URL
Copyright(c) liveme organization 2024

Variable descriptions

experimentidExperiment Id
useridUser id
timestampshow month(2), day(2), hour(2), minute(2), second(2), decimals(3)
x x axis value at the time of capture
y y axis value at the time of capture
z z axis value at the time of capture

Alerts

experimentid has constant value "wenetItaly" Constant
x is highly skewed (γ1 = -240.0638387) Skewed
y is highly skewed (γ1 = -240.3616945) Skewed
z is highly skewed (γ1 = -206.0930345) Skewed
x has 3485597 (2.2%) zeros Zeros
y has 4187335 (2.6%) zeros Zeros

Reproduction

Analysis started2025-04-10 13:36:35.098204
Analysis finished2025-04-10 14:01:52.879821
Duration25 minutes and 17.78 seconds
Software versionydata-profiling v0.0.dev0
Download configurationconfig.json

Variables

experimentid
Text

Constant 

Experiment Id

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 GiB
2025-04-10T16:01:53.040933image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters1618685300
Distinct characters8
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowwenetItaly
2nd rowwenetItaly
3rd rowwenetItaly
4th rowwenetItaly
5th rowwenetItaly
ValueCountFrequency (%)
wenetitaly 161868530
100.0%
2025-04-10T16:01:53.658412image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 323737060
20.0%
t 323737060
20.0%
w 161868530
10.0%
n 161868530
10.0%
I 161868530
10.0%
a 161868530
10.0%
l 161868530
10.0%
y 161868530
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 1618685300
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 323737060
20.0%
t 323737060
20.0%
w 161868530
10.0%
n 161868530
10.0%
I 161868530
10.0%
a 161868530
10.0%
l 161868530
10.0%
y 161868530
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 1618685300
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 323737060
20.0%
t 323737060
20.0%
w 161868530
10.0%
n 161868530
10.0%
I 161868530
10.0%
a 161868530
10.0%
l 161868530
10.0%
y 161868530
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 1618685300
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 323737060
20.0%
t 323737060
20.0%
w 161868530
10.0%
n 161868530
10.0%
I 161868530
10.0%
a 161868530
10.0%
l 161868530
10.0%
y 161868530
10.0%

userid
Real number (ℝ)

User id

Distinct206
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean141.3967382
Minimum0
Maximum265
Zeros77075
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size2.4 GiB
2025-04-10T16:01:54.020430image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile24
Q179
median144
Q3203
95-th percentile255
Maximum265
Range265
Interquartile range (IQR)124

Descriptive statistics

Standard deviation74.37948011
Coefficient of variation (CV)0.5260339173
Kurtosis-1.170600046
Mean141.3967382
Median Absolute Deviation (MAD)62
Skewness-0.05261048842
Sum2.288768216 × 1010
Variance5532.307061
MonotonicityNot monotonic
2025-04-10T16:01:54.459439image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
163 4590851
 
2.8%
58 4166640
 
2.6%
40 3763656
 
2.3%
175 3521618
 
2.2%
190 3517022
 
2.2%
100 3480147
 
2.1%
255 3182384
 
2.0%
203 3133406
 
1.9%
59 3114300
 
1.9%
161 3078960
 
1.9%
Other values (196) 126319546
78.0%
ValueCountFrequency (%)
0 77075
 
< 0.1%
2 1313417
0.8%
3 148987
 
0.1%
4 1265740
0.8%
6 563751
0.3%
ValueCountFrequency (%)
265 659826
 
0.4%
264 17838
 
< 0.1%
263 2041203
1.3%
262 947982
0.6%
260 376086
 
0.2%

timestamp
Date

show month(2), day(2), hour(2), minute(2), second(2), decimals(3)

Distinct155696666
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size2.4 GiB
Minimum2020-11-16 07:00:00.042000
Maximum2020-12-11 21:59:59.997000
2025-04-10T16:01:54.897428image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
2025-04-10T16:01:55.243445image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

x
Real number (ℝ)

Skewed  Zeros 

x axis value at the time of capture

Distinct9778
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-16.0176409
Minimum-1073655.25
Maximum78.73999786
Zeros3485597
Zeros (%)2.2%
Negative70767846
Negative (%)43.7%
Memory size2.4 GiB
2025-04-10T16:01:55.602345image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum-1073655.25
5-th percentile-4.170000076
Q1-0.3199999928
median0.03999999911
Q30.6000000238
95-th percentile6.980000019
Maximum78.73999786
Range1073733.99
Interquartile range (IQR)0.9200000167

Descriptive statistics

Standard deviation3581.597822
Coefficient of variation (CV)-223.6033286
Kurtosis61106.15474
Mean-16.0176409
Median Absolute Deviation (MAD)0.4500000104
Skewness-240.0638387
Sum-2592751986
Variance12827842.96
MonotonicityNot monotonic
2025-04-10T16:01:55.967701image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 3485597
 
2.2%
0.05000000075 2166059
 
1.3%
-0.05000000075 2042238
 
1.3%
-0.03999999911 2004634
 
1.2%
-0.02999999933 1977671
 
1.2%
0.02999999933 1848693
 
1.1%
0.0700000003 1789994
 
1.1%
0.05999999866 1776895
 
1.1%
0.009999999776 1745720
 
1.1%
0.1099999994 1737018
 
1.1%
Other values (9768) 141294011
87.3%
ValueCountFrequency (%)
-1073655.25 92
< 0.1%
-1039392.938 27
 
< 0.1%
-1038778.625 20
 
< 0.1%
-1037164.812 1
 
< 0.1%
-1036050.75 9
 
< 0.1%
ValueCountFrequency (%)
78.73999786 1
 
< 0.1%
78.47000122 3
 
< 0.1%
78.44000244 6
 
< 0.1%
78.43000031 20
< 0.1%
78.41999817 8
 
< 0.1%

y
Real number (ℝ)

Skewed  Zeros 

y axis value at the time of capture

Distinct9936
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-14.78465011
Minimum-1073660
Maximum78.44999695
Zeros4187335
Zeros (%)2.6%
Negative52473968
Negative (%)32.4%
Memory size2.4 GiB
2025-04-10T16:01:56.326265image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum-1073660
5-th percentile-4.840000153
Q1-0.0700000003
median0.1700000018
Q33.710000038
95-th percentile9.170000076
Maximum78.44999695
Range1073738.45
Interquartile range (IQR)3.780000038

Descriptive statistics

Standard deviation3572.775294
Coefficient of variation (CV)-241.6543691
Kurtosis61297.3076
Mean-14.78465011
Median Absolute Deviation (MAD)0.6300000101
Skewness-240.3616945
Sum-2393169580
Variance12764723.3
MonotonicityNot monotonic
2025-04-10T16:01:56.707547image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4187335
 
2.6%
0.009999999776 2259302
 
1.4%
-0.05000000075 2066206
 
1.3%
-0.02999999933 2056423
 
1.3%
0.02999999933 2006618
 
1.2%
0.01999999955 1903032
 
1.2%
-0.03999999911 1881190
 
1.2%
0.05000000075 1837006
 
1.1%
-0.0700000003 1758464
 
1.1%
-0.009999999776 1686370
 
1.0%
Other values (9926) 140226584
86.6%
ValueCountFrequency (%)
-1073660 93
< 0.1%
-1039393.062 27
 
< 0.1%
-1038778.75 20
 
< 0.1%
-1037164.875 1
 
< 0.1%
-1036050.75 9
 
< 0.1%
ValueCountFrequency (%)
78.44999695 1
< 0.1%
78.26999664 1
< 0.1%
78.25 2
< 0.1%
78.23000336 1
< 0.1%
78.01999664 1
< 0.1%

z
Real number (ℝ)

Skewed 

z axis value at the time of capture

Distinct9116
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-18.56307156
Minimum-1073659.875
Maximum122.9899979
Zeros84910
Zeros (%)0.1%
Negative20789926
Negative (%)12.8%
Memory size2.4 GiB
2025-04-10T16:01:57.066068image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum-1073659.875
5-th percentile-7.760000229
Q14.510000229
median9.420000076
Q39.779999733
95-th percentile9.970000267
Maximum122.9899979
Range1073782.865
Interquartile range (IQR)5.269999504

Descriptive statistics

Standard deviation5146.786814
Coefficient of variation (CV)-277.2594395
Kurtosis42473.11664
Mean-18.56307156
Median Absolute Deviation (MAD)0.5199995041
Skewness-206.0930345
Sum-3004777105
Variance26489414.51
MonotonicityNot monotonic
2025-04-10T16:01:57.443593image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9.840000153 2573892
 
1.6%
9.779999733 2522163
 
1.6%
9.829999924 2463441
 
1.5%
9.819999695 2391220
 
1.5%
9.81000042 2306853
 
1.4%
9.770000458 2268667
 
1.4%
9.760000229 2266249
 
1.4%
9.800000191 2259108
 
1.4%
9.789999962 2142430
 
1.3%
9.729999542 2049488
 
1.3%
Other values (9106) 138625019
85.6%
ValueCountFrequency (%)
-1073659.875 93
 
< 0.1%
-1071693.25 1
 
< 0.1%
-1071112.875 1
 
< 0.1%
-1060522.25 3686
< 0.1%
-1060521.375 1
 
< 0.1%
ValueCountFrequency (%)
122.9899979 1
< 0.1%
82.91000366 1
< 0.1%
81.58999634 1
< 0.1%
78.80000305 1
< 0.1%
78.69000244 2
< 0.1%