Overview

Dataset statistics

Number of variables6
Number of observations77007489
Missing cells0
Missing cells (%)0.0%
Total size in memory4.9 GiB
Average record size in memory68.0 B

Variable types

Text1
Numeric4
DateTime1

Dataset

Description[μT] Geomagnetic field strength along the x,y,z axis. 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.
CreatorAndrea Bontempelli, Matteo Busso, Roy Alia Asiku
AuthorAndrea Bontempelli, Matteo Busso, Fausto Giunchiglia
URL
Copyright(c) University of Trento - Knowledge Diversity 2023

Variable descriptions

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

Alerts

experimentid has constant value "wenetDenmark"Constant
userid has 9821286 (12.8%) zerosZeros

Reproduction

Analysis started2024-11-23 02:41:39.099635
Analysis finished2024-11-23 02:48:12.868517
Duration6 minutes and 33.77 seconds
Software versionydata-profiling v4.8.3
Download configurationconfig.json

Variables

experimentid
Text

CONSTANT 

Experiment Id

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.0 GiB
2024-11-23T03:48:12.925719image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters924089868
Distinct characters9
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 rowwenetDenmark
2nd rowwenetDenmark
3rd rowwenetDenmark
4th rowwenetDenmark
5th rowwenetDenmark
ValueCountFrequency (%)
wenetdenmark 77007489
100.0%
2024-11-23T03:48:13.100996image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 231022467
25.0%
n 154014978
16.7%
w 77007489
 
8.3%
t 77007489
 
8.3%
D 77007489
 
8.3%
m 77007489
 
8.3%
a 77007489
 
8.3%
r 77007489
 
8.3%
k 77007489
 
8.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 924089868
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 231022467
25.0%
n 154014978
16.7%
w 77007489
 
8.3%
t 77007489
 
8.3%
D 77007489
 
8.3%
m 77007489
 
8.3%
a 77007489
 
8.3%
r 77007489
 
8.3%
k 77007489
 
8.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 924089868
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 231022467
25.0%
n 154014978
16.7%
w 77007489
 
8.3%
t 77007489
 
8.3%
D 77007489
 
8.3%
m 77007489
 
8.3%
a 77007489
 
8.3%
r 77007489
 
8.3%
k 77007489
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 924089868
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 231022467
25.0%
n 154014978
16.7%
w 77007489
 
8.3%
t 77007489
 
8.3%
D 77007489
 
8.3%
m 77007489
 
8.3%
a 77007489
 
8.3%
r 77007489
 
8.3%
k 77007489
 
8.3%

userid
Real number (ℝ)

ZEROS 

User id

Distinct13
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.99481057
Minimum0
Maximum25
Zeros9821286
Zeros (%)12.8%
Negative0
Negative (%)0.0%
Memory size1.1 GiB
2024-11-23T03:48:13.202020image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median17
Q321
95-th percentile23
Maximum25
Range25
Interquartile range (IQR)15

Descriptive statistics

Standard deviation8.595672251
Coefficient of variation (CV)0.6142042587
Kurtosis-1.366593587
Mean13.99481057
Median Absolute Deviation (MAD)6
Skewness-0.4731691914
Sum1077705221
Variance73.88558145
MonotonicityIncreasing
2024-11-23T03:48:13.292946image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
17 18673284
24.2%
23 14241174
18.5%
0 9821286
12.8%
6 9668416
12.6%
21 7713867
10.0%
3 7214806
 
9.4%
20 4318394
 
5.6%
25 2946484
 
3.8%
8 1131750
 
1.5%
16 870510
 
1.1%
Other values (3) 407518
 
0.5%
ValueCountFrequency (%)
0 9821286
12.8%
3 7214806
9.4%
6 9668416
12.6%
8 1131750
 
1.5%
12 42604
 
0.1%
ValueCountFrequency (%)
25 2946484
 
3.8%
23 14241174
18.5%
22 203172
 
0.3%
21 7713867
10.0%
20 4318394
 
5.6%

timestamp
Date

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

Distinct75855809
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size1.1 GiB
Minimum2020-11-16 07:00:00.025000
Maximum2020-12-11 21:59:59.996000
2024-11-23T03:48:13.405249image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-23T03:48:13.523553image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

x
Real number (ℝ)

x axis at the time of capture

Distinct136525
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-3.94360182
Minimum-3884.620117
Maximum32767
Zeros74694
Zeros (%)0.1%
Negative37099088
Negative (%)48.2%
Memory size1.1 GiB
2024-11-23T03:48:13.637124image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-3884.620117
5-th percentile-60.59999847
Q1-15.60000038
median1.039999962
Q313.39999962
95-th percentile41.40000153
Maximum32767
Range36651.62012
Interquartile range (IQR)29

Descriptive statistics

Standard deviation84.51660693
Coefficient of variation (CV)-21.43132364
Kurtosis673.9527207
Mean-3.94360182
Median Absolute Deviation (MAD)14.14999962
Skewness-9.99468838
Sum-303686873.8
Variance7143.056848
MonotonicityNot monotonic
2024-11-23T03:48:13.756926image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8.699999809 94101
 
0.1%
13.5 91389
 
0.1%
9 90882
 
0.1%
8.5 90156
 
0.1%
7.5 84985
 
0.1%
6 80104
 
0.1%
8.399999619 76672
 
0.1%
7.800000191 75607
 
0.1%
0 74694
 
0.1%
12 74205
 
0.1%
Other values (136515) 76174694
98.9%
ValueCountFrequency (%)
-3884.620117 1
< 0.1%
-3631.02002 1
< 0.1%
-3628.52002 1
< 0.1%
-3513.459961 1
< 0.1%
-3501.629883 1
< 0.1%
ValueCountFrequency (%)
32767 1
< 0.1%
4879.5 2
< 0.1%
4879.049805 1
< 0.1%
4878.299805 1
< 0.1%
4878 2
< 0.1%

y
Real number (ℝ)

y axis at the time of capture

Distinct127200
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-2.957543066
Minimum-4276.759766
Maximum32767
Zeros64629
Zeros (%)0.1%
Negative45931471
Negative (%)59.6%
Memory size1.1 GiB
2024-11-23T03:48:13.875524image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-4276.759766
5-th percentile-50.29999924
Q1-24.92000008
median-7.309999943
Q312.42000008
95-th percentile44.58000183
Maximum32767
Range37043.75977
Interquartile range (IQR)37.34000015

Descriptive statistics

Standard deviation90.66489655
Coefficient of variation (CV)-30.65547805
Kurtosis823.0839234
Mean-2.957543066
Median Absolute Deviation (MAD)18.80999994
Skewness16.14609178
Sum-227752965.1
Variance8220.123467
MonotonicityNot monotonic
2024-11-23T03:48:13.994420image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-9 94687
 
0.1%
-8.699999809 93442
 
0.1%
-9.300000191 89634
 
0.1%
-9.5 87184
 
0.1%
-9.600000381 86130
 
0.1%
9 82140
 
0.1%
-9.699999809 82006
 
0.1%
-12 74969
 
0.1%
-7.5 74723
 
0.1%
-9.800000191 74467
 
0.1%
Other values (127190) 76168107
98.9%
ValueCountFrequency (%)
-4276.759766 1
< 0.1%
-4048.98999 1
< 0.1%
-4048.73999 1
< 0.1%
-4048.550049 1
< 0.1%
-4048.469971 1
< 0.1%
ValueCountFrequency (%)
32767 1
< 0.1%
4880.25 1
< 0.1%
4879.5 1
< 0.1%
4878 2
< 0.1%
4877.549805 1
< 0.1%

z
Real number (ℝ)

z axis at the time of capture

Distinct139508
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-24.62601203
Minimum-3717.790039
Maximum32767
Zeros29773
Zeros (%)< 0.1%
Negative58242235
Negative (%)75.6%
Memory size1.1 GiB
2024-11-23T03:48:14.113753image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-3717.790039
5-th percentile-92.68000031
Q1-45.36999893
median-29.34000015
Q3-1.019999981
95-th percentile60.11999893
Maximum32767
Range36484.79004
Interquartile range (IQR)44.34999895

Descriptive statistics

Standard deviation99.93882696
Coefficient of variation (CV)-4.058262735
Kurtosis385.6311646
Mean-24.62601203
Median Absolute Deviation (MAD)20.95999908
Skewness1.515141152
Sum-1896387351
Variance9987.769134
MonotonicityNot monotonic
2024-11-23T03:48:14.236842image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-39 75681
 
0.1%
-39.29999924 63679
 
0.1%
-38.70000076 61696
 
0.1%
-51 60665
 
0.1%
-39.18000031 60220
 
0.1%
-38.86999893 59276
 
0.1%
-50.70000076 59059
 
0.1%
-39.11999893 58462
 
0.1%
-38.93000031 58032
 
0.1%
-38.75 57115
 
0.1%
Other values (139498) 76393604
99.2%
ValueCountFrequency (%)
-3717.790039 1
< 0.1%
-3523.75 1
< 0.1%
-3523.139893 1
< 0.1%
-3521.590088 1
< 0.1%
-3515.649902 1
< 0.1%
ValueCountFrequency (%)
32767 1
 
< 0.1%
5709.009766 1
 
< 0.1%
4880.549805 26
< 0.1%
4880.25 36
< 0.1%
4879.799805 21
< 0.1%

Correlations

2024-11-23T03:48:14.313515image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
useridxyz
userid1.000-0.0100.0620.046
x-0.0101.000-0.004-0.084
y0.062-0.0041.0000.058
z0.046-0.0840.0581.000