Overview

Dataset statistics

Number of variables8
Number of observations90302289
Missing cells0
Missing cells (%)0.0%
Total size in memory18.5 GiB
Average record size in memory220.3 B

Variable types

Text5
Numeric2
DateTime1

Dataset

Description[unitless] Returns wheter the device to wirelessly exchange data with other Bluetooth devices. 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)
addressMAC address.
bondstatebond state of the remote device.
namename of the remote device.
rssi(Received Signal Strength Indicator) is an estimated measure of power level received from an access point or router. (dBm)
typethe type of bluetooth device {normal, low-energy}

Alerts

experimentid has constant value "wenetItaly"Constant

Reproduction

Analysis started2024-11-23 11:15:10.478279
Analysis finished2024-11-23 11:27:00.597155
Duration11 minutes and 50.12 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.2 GiB
2024-11-23T12:27:00.654442image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters903022890
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 90302289
100.0%
2024-11-23T12:27:00.838430image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 180604578
20.0%
t 180604578
20.0%
w 90302289
10.0%
n 90302289
10.0%
I 90302289
10.0%
a 90302289
10.0%
l 90302289
10.0%
y 90302289
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 903022890
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 180604578
20.0%
t 180604578
20.0%
w 90302289
10.0%
n 90302289
10.0%
I 90302289
10.0%
a 90302289
10.0%
l 90302289
10.0%
y 90302289
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 903022890
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 180604578
20.0%
t 180604578
20.0%
w 90302289
10.0%
n 90302289
10.0%
I 90302289
10.0%
a 90302289
10.0%
l 90302289
10.0%
y 90302289
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 903022890
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 180604578
20.0%
t 180604578
20.0%
w 90302289
10.0%
n 90302289
10.0%
I 90302289
10.0%
a 90302289
10.0%
l 90302289
10.0%
y 90302289
10.0%

userid
Real number (ℝ)

User id

Distinct157
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean148.6610615
Minimum1
Maximum264
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 GiB
2024-11-23T12:27:00.965891image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5
Q1111
median146
Q3208
95-th percentile255
Maximum264
Range263
Interquartile range (IQR)97

Descriptive statistics

Standard deviation76.15845276
Coefficient of variation (CV)0.512295903
Kurtosis-0.973019169
Mean148.6610615
Median Absolute Deviation (MAD)62
Skewness-0.2981749701
Sum1.342443414 × 1010
Variance5800.109926
MonotonicityIncreasing
2024-11-23T12:27:01.106862image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
208 11405081
 
12.6%
111 10488415
 
11.6%
136 4805582
 
5.3%
177 4412283
 
4.9%
255 3786744
 
4.2%
5 3756182
 
4.2%
250 3752026
 
4.2%
114 3314064
 
3.7%
113 3096620
 
3.4%
190 3094194
 
3.4%
Other values (147) 38391098
42.5%
ValueCountFrequency (%)
1 77458
 
0.1%
2 973123
 
1.1%
3 150330
 
0.2%
4 354838
 
0.4%
5 3756182
4.2%
ValueCountFrequency (%)
264 72796
 
0.1%
263 24618
 
< 0.1%
262 58118
 
0.1%
258 1802190
2.0%
257 313053
 
0.3%

timestamp
Date

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

Distinct87631806
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size1.3 GiB
Minimum2020-11-16 07:00:00.765000
Maximum2020-12-11 21:59:59.998000
2024-11-23T12:27:01.233101image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-23T12:27:01.357510image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

address
Text

MAC address.

Distinct590912
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size6.7 GiB
2024-11-23T12:27:02.218729image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length64
Median length64
Mean length64
Min length64

Characters and Unicode

Total characters5779346496
Distinct characters16
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

Unique60268 ?
Unique (%)0.1%

Sample

1st rowf37af4f924421146130d561ade04650193565baeda100e91f0d0c22ff3418943
2nd rowf37af4f924421146130d561ade04650193565baeda100e91f0d0c22ff3418943
3rd rowae5aaaf8fc212241bc3e8e6d6389f115d4aecace99932a07086e8d00d10d5469
4th rowae5aaaf8fc212241bc3e8e6d6389f115d4aecace99932a07086e8d00d10d5469
5th rowde600da3ef7681aaa9cd38ea68f021f02c4085f3e8b4b0014b4fa75509984b6a
ValueCountFrequency (%)
1161a47918a6f1ed7f36290666c884096e4498957d405ed85c17efde85b663ac 1604907
 
1.8%
c3c066c4d3b610eceaecaca446ee1c0a536bbb63a22a7079aa1ee1d39b640a67 1368646
 
1.5%
11d98c2712d26ba528466d9d51bf103c0b72502213146977d716dd47ced79aeb 1326505
 
1.5%
652a8bc3636654aba8c1710b89d75845ca2a4e25de683bc97c2b1077cad7bc7d 1180808
 
1.3%
d60dc9738b7b664ad382277d7c624d4703e864a9b4f1a38479aa6153dd9b49c3 654368
 
0.7%
148de95df3d3a4f0cf05b54c7071aad75b6b7e5b9559218e9ef5c285120da74b 631593
 
0.7%
dae25e2bd00710f09607ab897fd47d8e5d6ba345d2b1f251d880d6a22286571d 589021
 
0.7%
2700f83880ba6db80fd46460bf2217744e1803f198e948453edb6c45a4fcdfca 509594
 
0.6%
1fb33acfb89fe7b40cc6d260dfc06c0a94c4f798dddc9d2f617524cfc4e7d78d 480161
 
0.5%
89d1de18e4c1bdadbe442f6796cc97ca85fa30e297db79b700be088eb1b7e2c1 470222
 
0.5%
Other values (590902) 81486464
90.2%
2024-11-23T12:27:03.096553image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 374215245
 
6.5%
c 369930489
 
6.4%
7 369785998
 
6.4%
d 369524086
 
6.4%
b 366019307
 
6.3%
1 365151578
 
6.3%
4 364474368
 
6.3%
2 364470889
 
6.3%
8 361481959
 
6.3%
0 359665143
 
6.2%
Other values (6) 2114627434
36.6%

Most occurring categories

ValueCountFrequency (%)
(unknown) 5779346496
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
6 374215245
 
6.5%
c 369930489
 
6.4%
7 369785998
 
6.4%
d 369524086
 
6.4%
b 366019307
 
6.3%
1 365151578
 
6.3%
4 364474368
 
6.3%
2 364470889
 
6.3%
8 361481959
 
6.3%
0 359665143
 
6.2%
Other values (6) 2114627434
36.6%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 5779346496
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
6 374215245
 
6.5%
c 369930489
 
6.4%
7 369785998
 
6.4%
d 369524086
 
6.4%
b 366019307
 
6.3%
1 365151578
 
6.3%
4 364474368
 
6.3%
2 364470889
 
6.3%
8 361481959
 
6.3%
0 359665143
 
6.2%
Other values (6) 2114627434
36.6%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 5779346496
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
6 374215245
 
6.5%
c 369930489
 
6.4%
7 369785998
 
6.4%
d 369524086
 
6.4%
b 366019307
 
6.3%
1 365151578
 
6.3%
4 364474368
 
6.3%
2 364470889
 
6.3%
8 361481959
 
6.3%
0 359665143
 
6.2%
Other values (6) 2114627434
36.6%

bondstate
Text

bond state of the remote device.

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.1 GiB
2024-11-23T12:27:03.195808image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length12
Median length9
Mean length9.037162624
Min length9

Characters and Unicode

Total characters816076471
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 rowBOND_NONE
2nd rowBOND_NONE
3rd rowBOND_NONE
4th rowBOND_NONE
5th rowBOND_NONE
ValueCountFrequency (%)
bond_none 88624365
98.1%
bond_bonded 1677902
 
1.9%
bond_bonding 22
 
< 0.1%
2024-11-23T12:27:03.387460image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
N 269228965
33.0%
O 180604578
22.1%
D 93658115
 
11.5%
B 91980213
 
11.3%
_ 90302289
 
11.1%
E 90302267
 
11.1%
I 22
 
< 0.1%
G 22
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
(unknown) 816076471
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
N 269228965
33.0%
O 180604578
22.1%
D 93658115
 
11.5%
B 91980213
 
11.3%
_ 90302289
 
11.1%
E 90302267
 
11.1%
I 22
 
< 0.1%
G 22
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 816076471
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
N 269228965
33.0%
O 180604578
22.1%
D 93658115
 
11.5%
B 91980213
 
11.3%
_ 90302289
 
11.1%
E 90302267
 
11.1%
I 22
 
< 0.1%
G 22
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 816076471
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
N 269228965
33.0%
O 180604578
22.1%
D 93658115
 
11.5%
B 91980213
 
11.3%
_ 90302289
 
11.1%
E 90302267
 
11.1%
I 22
 
< 0.1%
G 22
 
< 0.1%

name
Text

name of the remote device.

Distinct11025
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.7 GiB
2024-11-23T12:27:03.518546image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length64
Median length64
Mean length64
Min length64

Characters and Unicode

Total characters5779346496
Distinct characters16
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

Unique1310 ?
Unique (%)< 0.1%

Sample

1st rowef0c79ca0128874f83e93e02ae12ed0b77a8b4ec5f68f27a570cf418525a3724
2nd rowef0c79ca0128874f83e93e02ae12ed0b77a8b4ec5f68f27a570cf418525a3724
3rd rowef0c79ca0128874f83e93e02ae12ed0b77a8b4ec5f68f27a570cf418525a3724
4th rowef0c79ca0128874f83e93e02ae12ed0b77a8b4ec5f68f27a570cf418525a3724
5th row574439f2a6e506a9a8fa002f5dc0ad9025b5e301a0f95b422eea8458f91ca4c2
ValueCountFrequency (%)
ef0c79ca0128874f83e93e02ae12ed0b77a8b4ec5f68f27a570cf418525a3724 63920728
70.8%
107fb534d9375b11894c3f40c4171bb75d5f6737e533711378ef796295bb2177 1696198
 
1.9%
0e2a7f3b6dee320ebc6ffb33bf9d2affa963ac7c80f79ccf0ac7d6e41d93486b 1604479
 
1.8%
37336d06d9a7db303e347043fb470fc8eabb477f052386a3be3606821418399e 1368640
 
1.5%
db0ce656fdf40754ac671c9bfd141a57b7a0236bad1e699500d9c421abb0b4a2 1160259
 
1.3%
53fe7a77b9f6750a132fefb64d5f07896e1a2b596bcccc5454616829c8b62322 762135
 
0.8%
79d33529d7795ac5d9a939d3ec7824aad1ae66fd49487a0d79a8e133c08a79b0 756073
 
0.8%
f612cfee934bcaae1c178c43920211ca7894b937cc77c7be973a4b67fd4d4ace 692065
 
0.8%
f2353c96e7949a00b761eee2817d1e009f007fbe3c83298a71dc64196e966dff 630845
 
0.7%
43c4a2b37bb59193dc5ddc6e794d2a060a605a3534802080186d76dd432f18a1 616709
 
0.7%
Other values (11015) 17094158
 
18.9%
2024-11-23T12:27:03.750287image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 576756204
10.0%
e 483332890
 
8.4%
2 480024009
 
8.3%
8 476381360
 
8.2%
f 429445048
 
7.4%
0 428789335
 
7.4%
a 421498868
 
7.3%
c 362569839
 
6.3%
4 361995890
 
6.3%
5 348970836
 
6.0%
Other values (6) 1409582217
24.4%

Most occurring categories

ValueCountFrequency (%)
(unknown) 5779346496
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
7 576756204
10.0%
e 483332890
 
8.4%
2 480024009
 
8.3%
8 476381360
 
8.2%
f 429445048
 
7.4%
0 428789335
 
7.4%
a 421498868
 
7.3%
c 362569839
 
6.3%
4 361995890
 
6.3%
5 348970836
 
6.0%
Other values (6) 1409582217
24.4%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 5779346496
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
7 576756204
10.0%
e 483332890
 
8.4%
2 480024009
 
8.3%
8 476381360
 
8.2%
f 429445048
 
7.4%
0 428789335
 
7.4%
a 421498868
 
7.3%
c 362569839
 
6.3%
4 361995890
 
6.3%
5 348970836
 
6.0%
Other values (6) 1409582217
24.4%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 5779346496
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
7 576756204
10.0%
e 483332890
 
8.4%
2 480024009
 
8.3%
8 476381360
 
8.2%
f 429445048
 
7.4%
0 428789335
 
7.4%
a 421498868
 
7.3%
c 362569839
 
6.3%
4 361995890
 
6.3%
5 348970836
 
6.0%
Other values (6) 1409582217
24.4%

rssi
Real number (ℝ)

(Received Signal Strength Indicator) is an estimated measure of power level received from an access point or router. (dBm)

Distinct145
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-81.20674116
Minimum-126
Maximum127
Zeros869
Zeros (%)< 0.1%
Negative90299821
Negative (%)> 99.9%
Memory size1.3 GiB
2024-11-23T12:27:03.870427image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-126
5-th percentile-98
Q1-92
median-84
Q3-73
95-th percentile-54
Maximum127
Range253
Interquartile range (IQR)19

Descriptive statistics

Standard deviation14.03260068
Coefficient of variation (CV)-0.1728009335
Kurtosis1.006321172
Mean-81.20674116
Median Absolute Deviation (MAD)9
Skewness1.027050325
Sum-7333154609
Variance196.9138819
MonotonicityNot monotonic
2024-11-23T12:27:03.992188image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-94 3953922
 
4.4%
-91 3605630
 
4.0%
-88 3517612
 
3.9%
-92 3229132
 
3.6%
-90 3132453
 
3.5%
-93 2995523
 
3.3%
-96 2900542
 
3.2%
-85 2809769
 
3.1%
-97 2809140
 
3.1%
-82 2771486
 
3.1%
Other values (135) 58577080
64.9%
ValueCountFrequency (%)
-126 1
 
< 0.1%
-124 1
 
< 0.1%
-122 3
 
< 0.1%
-121 4
 
< 0.1%
-120 22
< 0.1%
ValueCountFrequency (%)
127 210
< 0.1%
107 1
 
< 0.1%
104 9
 
< 0.1%
101 3
 
< 0.1%
98 3
 
< 0.1%

type
Text

the type of bluetooth device {normal, low-energy}

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.5 GiB
2024-11-23T12:27:04.059457image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length2
Median length1
Mean length1.292082463
Min length1

Characters and Unicode

Total characters116678004
Distinct characters3
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 rown
2nd rown
3rd rown
4th rown
5th rown
ValueCountFrequency (%)
n 63926574
70.8%
le 26375715
29.2%
2024-11-23T12:27:04.240208image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
n 63926574
54.8%
l 26375715
22.6%
e 26375715
22.6%

Most occurring categories

ValueCountFrequency (%)
(unknown) 116678004
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
n 63926574
54.8%
l 26375715
22.6%
e 26375715
22.6%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 116678004
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
n 63926574
54.8%
l 26375715
22.6%
e 26375715
22.6%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 116678004
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
n 63926574
54.8%
l 26375715
22.6%
e 26375715
22.6%

Correlations

2024-11-23T12:27:04.313841image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
rssiuserid
rssi1.0000.095
userid0.0951.000