Overview

Dataset statistics

Number of variables6
Number of observations6677
Missing cells0
Missing cells (%)0.0%
Total size in memory1.2 MiB
Average record size in memory181.0 B

Variable types

Text3
Numeric1
DateTime1
Boolean1

Dataset

Description[unitless] Returns information related to the WIFI network to which the phone is connected to, if connected will also report the WIFI network id. 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)
bssid(Basic Service Set Identifier) Special SSID used to define a wireless computer network configured to communicate directly with each other without an access point.
isconnectedReturn if the phone is connected to the WIFI
ssid(Service Set Identifier) ID or unique identifier of a digital network (Wi-Fi or WLAN)

Alerts

experimentid has constant value "wenetDenmark"Constant
isconnected has constant value "True"Constant
timestamp has unique valuesUnique
userid has 172 (2.6%) zerosZeros

Reproduction

Analysis started2024-11-23 02:34:27.634553
Analysis finished2024-11-23 02:34:27.832924
Duration0.2 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 size130.5 KiB
2024-11-23T03:34:27.905772image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters80124
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 6677
100.0%
2024-11-23T03:34:28.156706image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 20031
25.0%
n 13354
16.7%
w 6677
 
8.3%
t 6677
 
8.3%
D 6677
 
8.3%
m 6677
 
8.3%
a 6677
 
8.3%
r 6677
 
8.3%
k 6677
 
8.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 80124
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 20031
25.0%
n 13354
16.7%
w 6677
 
8.3%
t 6677
 
8.3%
D 6677
 
8.3%
m 6677
 
8.3%
a 6677
 
8.3%
r 6677
 
8.3%
k 6677
 
8.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 80124
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 20031
25.0%
n 13354
16.7%
w 6677
 
8.3%
t 6677
 
8.3%
D 6677
 
8.3%
m 6677
 
8.3%
a 6677
 
8.3%
r 6677
 
8.3%
k 6677
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 80124
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 20031
25.0%
n 13354
16.7%
w 6677
 
8.3%
t 6677
 
8.3%
D 6677
 
8.3%
m 6677
 
8.3%
a 6677
 
8.3%
r 6677
 
8.3%
k 6677
 
8.3%

userid
Real number (ℝ)

ZEROS 

User id

Distinct17
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.7441965
Minimum0
Maximum27
Zeros172
Zeros (%)2.6%
Negative0
Negative (%)0.0%
Memory size52.3 KiB
2024-11-23T03:34:28.261359image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q16
median20
Q323
95-th percentile23
Maximum27
Range27
Interquartile range (IQR)17

Descriptive statistics

Standard deviation8.721861265
Coefficient of variation (CV)0.5539730953
Kurtosis-1.245560624
Mean15.7441965
Median Absolute Deviation (MAD)3
Skewness-0.6613013005
Sum105124
Variance76.07086393
MonotonicityIncreasing
2024-11-23T03:34:28.356602image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
23 2626
39.3%
2 1117
16.7%
17 1092
16.4%
6 749
 
11.2%
20 349
 
5.2%
0 172
 
2.6%
25 147
 
2.2%
26 141
 
2.1%
22 140
 
2.1%
12 92
 
1.4%
Other values (7) 52
 
0.8%
ValueCountFrequency (%)
0 172
 
2.6%
2 1117
16.7%
3 5
 
0.1%
6 749
11.2%
8 2
 
< 0.1%
ValueCountFrequency (%)
27 11
 
0.2%
26 141
 
2.1%
25 147
 
2.2%
23 2626
39.3%
22 140
 
2.1%

timestamp
Date

UNIQUE 

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

Distinct6677
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size52.3 KiB
Minimum2020-11-16 07:00:30.090000
Maximum2020-12-11 21:57:56.972000
2024-11-23T03:34:28.468102image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-23T03:34:28.587080image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

bssid
Text

(Basic Service Set Identifier) Special SSID used to define a wireless computer network configured to communicate directly with each other without an access point.

Distinct605
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size469.6 KiB
2024-11-23T03:34:28.730127image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length64
Median length64
Mean length64
Min length64

Characters and Unicode

Total characters427328
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

Unique277 ?
Unique (%)4.1%

Sample

1st rowe0dcd41b0f7f81a756a657fb1fd5e5875e01d5067798c740f3b0434e2aaf5515
2nd row130b01d2486e020dde92925bdd149200a73299c41b2e59a0830a6c89d0247844
3rd row89180f85d707799825e6798048ac6fac4367752a0e94a5487ec1b7e56c547052
4th rowbd2f3967436bf4d90f57c672e95c5c76b76fda476fd624481aa43f2928515ecd
5th rowfd13659f0a2f5ccd5166a32a6ab3030179805e95eaec6b83a237d8c740de0783
ValueCountFrequency (%)
228290f1c9b61c5f3ab21dd6193c8f233c81670b52121013fbe8049c5a6f9650 398
 
6.0%
a7ea6f69257a0e8bedfabd76473b7464ba96a916b21e81cf9637d4ce59c19ac5 388
 
5.8%
3622e99e462f04893d0c6d1b82130374bdbf046274d590b8b2a2eb551929175d 373
 
5.6%
53c89e48c438a1f69c6e923b892c4c33cc7730291f459f8164e9eb6b23372b52 181
 
2.7%
e32fa634f8e0b5f1ad1e45deaaad2723df61aaa14dd6f314c7267cd78a885f14 177
 
2.7%
db805253a3e2487ba5311a9d56661cb8aa7156fb91d59e37e261850b69c6e3b2 170
 
2.5%
22a565d84cba1e5ea5edb2bd065586e47396eedfa0c706054d1eac150a016c75 169
 
2.5%
ca2aa6311d758a272e50e5bdfc0fc09b53dc57a084f2675577b95b0f5307a421 143
 
2.1%
c14d59005dc3dd5eaab4383c7660b10695941e28a6a0de2a446272ac04a9966f 141
 
2.1%
71dee9c3856c6995eac0f78193a536f3f22eb9914c3c652e041c5574bc28e6d1 109
 
1.6%
Other values (595) 4428
66.3%
2024-11-23T03:34:29.020821image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 29812
 
7.0%
5 29200
 
6.8%
2 28794
 
6.7%
9 28161
 
6.6%
1 28117
 
6.6%
a 27608
 
6.5%
b 27359
 
6.4%
3 26383
 
6.2%
4 26350
 
6.2%
7 26169
 
6.1%
Other values (6) 149375
35.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 427328
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
6 29812
 
7.0%
5 29200
 
6.8%
2 28794
 
6.7%
9 28161
 
6.6%
1 28117
 
6.6%
a 27608
 
6.5%
b 27359
 
6.4%
3 26383
 
6.2%
4 26350
 
6.2%
7 26169
 
6.1%
Other values (6) 149375
35.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 427328
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
6 29812
 
7.0%
5 29200
 
6.8%
2 28794
 
6.7%
9 28161
 
6.6%
1 28117
 
6.6%
a 27608
 
6.5%
b 27359
 
6.4%
3 26383
 
6.2%
4 26350
 
6.2%
7 26169
 
6.1%
Other values (6) 149375
35.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 427328
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
6 29812
 
7.0%
5 29200
 
6.8%
2 28794
 
6.7%
9 28161
 
6.6%
1 28117
 
6.6%
a 27608
 
6.5%
b 27359
 
6.4%
3 26383
 
6.2%
4 26350
 
6.2%
7 26169
 
6.1%
Other values (6) 149375
35.0%

isconnected
Boolean

CONSTANT 

Return if the phone is connected to the WIFI

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
True
6677 
ValueCountFrequency (%)
True 6677
100.0%
2024-11-23T03:34:29.141966image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

ssid
Text

(Service Set Identifier) ID or unique identifier of a digital network (Wi-Fi or WLAN)

Distinct48
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size469.6 KiB
2024-11-23T03:34:29.241788image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length64
Median length64
Mean length64
Min length64

Characters and Unicode

Total characters427328
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

Unique9 ?
Unique (%)0.1%

Sample

1st row5d1971cb4ecd5dc06b1288da4080a398c5beb69cf47e12b813322d7c5eb45f4b
2nd rowaa53baf88e39b3590408c4c4214c311048e2abe4fb9cfa08d586c0905a2daa91
3rd rowaa53baf88e39b3590408c4c4214c311048e2abe4fb9cfa08d586c0905a2daa91
4th row54127e54cadc7281335318f09987b2d0f5b047f59f64a7b8f4a2d73f7d7f29a4
5th rowaa53baf88e39b3590408c4c4214c311048e2abe4fb9cfa08d586c0905a2daa91
ValueCountFrequency (%)
822fdae77a423476651f5a80e9ce3667684917851f5411b9d7e9e885de2bdb9a 2398
35.9%
21de6fb48508a9b5569177c36c9910dced4f188b0b3ef8f751d8df9b50093a70 1092
16.4%
46ba6db7106687b3ac271da24b67d9e1d9547e847e454e6da5a8e53b6333ac78 1091
16.3%
6d24edab4a59c1633b54b7a9904546b23b3a242f39d08e3c078947ff6bc28698 747
 
11.2%
8dee96fa17448481595516b17637af367ea4cb027b68e049e006be9efaec4b36 346
 
5.2%
970891946fa62b289f57940e9b2eb9b4a0774f6846cf16e0e80877ab2d2285e2 284
 
4.3%
aa53baf88e39b3590408c4c4214c311048e2abe4fb9cfa08d586c0905a2daa91 102
 
1.5%
f32bd79cf8a571a5097e4f74e97ba510ee6d3a4542b626a5ca6b6e0606368663 78
 
1.2%
0f13c634374ce0c0c1fe5081bffc8419647b5783b60ee4b0e5638726fe4d7d55 70
 
1.0%
16bcf7c3c5f5c053607cade15d8ce2e3c692d6fff5481fbd133788aa146f6702 61
 
0.9%
Other values (38) 408
 
6.1%
2024-11-23T03:34:29.453931image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 34582
 
8.1%
8 34064
 
8.0%
6 33594
 
7.9%
e 31637
 
7.4%
9 31123
 
7.3%
4 30115
 
7.0%
5 28885
 
6.8%
b 28149
 
6.6%
a 26605
 
6.2%
1 26469
 
6.2%
Other values (6) 122105
28.6%

Most occurring categories

ValueCountFrequency (%)
(unknown) 427328
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
7 34582
 
8.1%
8 34064
 
8.0%
6 33594
 
7.9%
e 31637
 
7.4%
9 31123
 
7.3%
4 30115
 
7.0%
5 28885
 
6.8%
b 28149
 
6.6%
a 26605
 
6.2%
1 26469
 
6.2%
Other values (6) 122105
28.6%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 427328
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
7 34582
 
8.1%
8 34064
 
8.0%
6 33594
 
7.9%
e 31637
 
7.4%
9 31123
 
7.3%
4 30115
 
7.0%
5 28885
 
6.8%
b 28149
 
6.6%
a 26605
 
6.2%
1 26469
 
6.2%
Other values (6) 122105
28.6%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 427328
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
7 34582
 
8.1%
8 34064
 
8.0%
6 33594
 
7.9%
e 31637
 
7.4%
9 31123
 
7.3%
4 30115
 
7.0%
5 28885
 
6.8%
b 28149
 
6.6%
a 26605
 
6.2%
1 26469
 
6.2%
Other values (6) 122105
28.6%