Timediaries

Dataset statistics

Number of variables	24
Number of observations	168095
Missing cells	2544778
Missing cells (%)	63.1%
Total size in memory	44.2 MiB
Average record size in memory	275.4 B

Variable types

Numeric	11
Text	13

Dataset

Description	[unitless] Question and answers. 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.
Creator	Xiaoyue Li
Author	Xiaoyue Li
URL
Copyright	(c) Knowledge Diversity, Trento University 2024

Alerts

`population` has constant value "0.0"	Constant
`code` is highly overall correlated with `gid`	High correlation
`gid` is highly overall correlated with `code`	High correlation
`questiontimestamp2` has 63681 (37.9%) missing values	Missing
`notificationtimestamp2` has 63681 (37.9%) missing values	Missing
`answertimestamp2` has 63681 (37.9%) missing values	Missing
`answerduration` has 63681 (37.9%) missing values	Missing
`delta` has 63681 (37.9%) missing values	Missing
`what` has 63681 (37.9%) missing values	Missing
`how` has 159448 (94.9%) missing values	Missing
`where` has 88402 (52.6%) missing values	Missing
`withwhom` has 79840 (47.5%) missing values	Missing
`mood` has 79840 (47.5%) missing values	Missing
`latitude` has 141268 (84.0%) missing values	Missing
`longitude` has 141268 (84.0%) missing values	Missing
`altitude` has 141268 (84.0%) missing values	Missing
`gid` has 166140 (98.8%) missing values	Missing
`osm_id` has 166140 (98.8%) missing values	Missing
`code` has 166140 (98.8%) missing values	Missing
`fclass` has 166140 (98.8%) missing values	Missing
`name` has 166140 (98.8%) missing values	Missing
`population` has 168071 (> 99.9%) missing values	Missing
`type` has 166447 (99.0%) missing values	Missing
`coordinates` has 166140 (98.8%) missing values	Missing
`answerduration` has 16159 (9.6%) zeros	Zeros
`delta` has 2758 (1.6%) zeros	Zeros

Reproduction

Analysis started	2024-09-24 08:54:38.733520
Analysis finished	2024-09-24 08:54:41.698315
Duration	2.96 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

userid
Real number (ℝ)

Distinct	158
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.50320949

Minimum	0
Maximum	157
Zeros	1065
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	39
median	79
Q3	118
95-th percentile	150
Maximum	157
Range	157
Interquartile range (IQR)	79

Descriptive statistics

Standard deviation	45.61129998
Coefficient of variation (CV)	0.5810119138
Kurtosis	-1.200181691
Mean	78.50320949
Median Absolute Deviation (MAD)	40
Skewness	-8.872441011 × 10^-5
Sum	13195997
Variance	2080.390686
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
132	1067	0.6%
131	1066	0.6%
58	1066	0.6%
156	1066	0.6%
144	1066	0.6%
140	1065	0.6%
0	1065	0.6%
22	1065	0.6%
90	1064	0.6%
89	1064	0.6%
Other values (148)	157441	93.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1065	0.6%
1	1064	0.6%
2	1064	0.6%
3	1063	0.6%
4	1064	0.6%

Value	Count	Frequency (%)
157	1063	0.6%
156	1066	0.6%
155	1063	0.6%
154	1064	0.6%
153	1064	0.6%

dt
Text

Distinct	1063
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	3193805
Distinct characters	13
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	1900-05-09 03:30:00
2nd row	1900-05-09 04:00:00
3rd row	1900-05-09 04:30:00
4th row	1900-05-09 05:00:00
5th row	1900-05-09 05:30:00

Value	Count	Frequency (%)
1900-05-11	7588	2.3%
1900-05-10	7587	2.3%
1900-05-17	7587	2.3%
1900-05-23	7585	2.3%
1900-05-12	7584	2.3%
1900-05-13	7584	2.3%
1900-05-14	7584	2.3%
1900-05-15	7584	2.3%
1900-05-16	7584	2.3%
1900-05-18	7584	2.3%
Other values (67)	260339	77.4%

Most occurring characters

Value	Count	Frequency (%)
0	1256459	39.3%
1	358161	11.2%
-	336190	10.5%
:	336190	10.5%
9	200015	6.3%
5	175173	5.5%
	168095	5.3%
2	122906	3.8%
3	106342	3.3%
6	51352	1.6%
Other values (3)	82922	2.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3193805	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1256459	39.3%
1	358161	11.2%
-	336190	10.5%
:	336190	10.5%
9	200015	6.3%
5	175173	5.5%
	168095	5.3%
2	122906	3.8%
3	106342	3.3%
6	51352	1.6%
Other values (3)	82922	2.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3193805	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1256459	39.3%
1	358161	11.2%
-	336190	10.5%
:	336190	10.5%
9	200015	6.3%
5	175173	5.5%
	168095	5.3%
2	122906	3.8%
3	106342	3.3%
6	51352	1.6%
Other values (3)	82922	2.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3193805	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1256459	39.3%
1	358161	11.2%
-	336190	10.5%
:	336190	10.5%
9	200015	6.3%
5	175173	5.5%
	168095	5.3%
2	122906	3.8%
3	106342	3.3%
6	51352	1.6%
Other values (3)	82922	2.6%

questiontimestamp2
Text

MISSING

Distinct	905
Distinct (%)	0.9%
Missing	63681
Missing (%)	37.9%
Memory size	3.2 MiB

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	1983866
Distinct characters	13
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	1900-05-09 06:32:00
2nd row	1900-05-09 07:02:00
3rd row	1900-05-09 07:32:00
4th row	1900-05-09 08:02:00
5th row	1900-05-09 08:32:00

Value	Count	Frequency (%)
1900-05-14	5910	2.8%
1900-05-22	5866	2.8%
1900-05-16	5853	2.8%
1900-05-17	5819	2.8%
1900-05-11	5802	2.8%
1900-05-15	5797	2.8%
1900-05-18	5705	2.7%
1900-05-12	5662	2.7%
1900-05-13	5656	2.7%
1900-05-10	5627	2.7%
Other values (81)	151131	72.4%

Most occurring characters

Value	Count	Frequency (%)
0	637475	32.1%
1	256260	12.9%
-	208828	10.5%
:	208828	10.5%
2	163290	8.2%
5	130997	6.6%
9	127178	6.4%
	104414	5.3%
3	72708	3.7%
6	22421	1.1%
Other values (3)	51467	2.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	637475	32.1%
1	256260	12.9%
-	208828	10.5%
:	208828	10.5%
2	163290	8.2%
5	130997	6.6%
9	127178	6.4%
	104414	5.3%
3	72708	3.7%
6	22421	1.1%
Other values (3)	51467	2.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	637475	32.1%
1	256260	12.9%
-	208828	10.5%
:	208828	10.5%
2	163290	8.2%
5	130997	6.6%
9	127178	6.4%
	104414	5.3%
3	72708	3.7%
6	22421	1.1%
Other values (3)	51467	2.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	637475	32.1%
1	256260	12.9%
-	208828	10.5%
:	208828	10.5%
2	163290	8.2%
5	130997	6.6%
9	127178	6.4%
	104414	5.3%
3	72708	3.7%
6	22421	1.1%
Other values (3)	51467	2.6%

notificationtimestamp2
Text

MISSING

Distinct	22346
Distinct (%)	21.4%
Missing	63681
Missing (%)	37.9%
Memory size	3.2 MiB

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	1983866
Distinct characters	13
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	15301 ?
Unique (%)	14.7%

Sample

1st row	1900-05-09 08:49:43
2nd row	1900-05-09 08:49:43
3rd row	1900-05-09 08:49:43
4th row	1900-05-09 08:49:44
5th row	1900-05-09 08:49:44

Value	Count	Frequency (%)
1900-05-14	5915	2.8%
1900-05-22	5866	2.8%
1900-05-16	5849	2.8%
1900-05-17	5820	2.8%
1900-05-11	5802	2.8%
1900-05-15	5797	2.8%
1900-05-18	5700	2.7%
1900-05-13	5666	2.7%
1900-05-12	5653	2.7%
1900-05-10	5622	2.7%
Other values (11300)	151138	72.4%

Most occurring characters

Value	Count	Frequency (%)
0	455124	22.9%
1	309859	15.6%
2	212062	10.7%
-	208828	10.5%
:	208828	10.5%
9	161429	8.1%
5	138335	7.0%
	104414	5.3%
3	82321	4.1%
4	28760	1.4%
Other values (3)	73906	3.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	455124	22.9%
1	309859	15.6%
2	212062	10.7%
-	208828	10.5%
:	208828	10.5%
9	161429	8.1%
5	138335	7.0%
	104414	5.3%
3	82321	4.1%
4	28760	1.4%
Other values (3)	73906	3.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	455124	22.9%
1	309859	15.6%
2	212062	10.7%
-	208828	10.5%
:	208828	10.5%
9	161429	8.1%
5	138335	7.0%
	104414	5.3%
3	82321	4.1%
4	28760	1.4%
Other values (3)	73906	3.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	455124	22.9%
1	309859	15.6%
2	212062	10.7%
-	208828	10.5%
:	208828	10.5%
9	161429	8.1%
5	138335	7.0%
	104414	5.3%
3	82321	4.1%
4	28760	1.4%
Other values (3)	73906	3.7%

answertimestamp2
Text

MISSING

Distinct	89336
Distinct (%)	85.6%
Missing	63681
Missing (%)	37.9%
Memory size	3.2 MiB

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	1983866
Distinct characters	13
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	84161 ?
Unique (%)	80.6%

Sample

1st row	1900-05-09 09:04:09
2nd row	1900-05-09 08:49:43
3rd row	1900-05-09 08:49:43
4th row	1900-05-09 08:49:44
5th row	1900-05-09 08:49:44

Value	Count	Frequency (%)
1900-05-14	5882	2.8%
1900-05-22	5882	2.8%
1900-05-16	5853	2.8%
1900-05-17	5803	2.8%
1900-05-15	5789	2.8%
1900-05-13	5764	2.8%
1900-05-11	5763	2.8%
1900-05-18	5621	2.7%
1900-05-12	5615	2.7%
1900-05-10	5611	2.7%
Other values (49251)	151245	72.4%

Most occurring characters

Value	Count	Frequency (%)
0	448043	22.6%
1	295117	14.9%
-	208828	10.5%
:	208828	10.5%
5	161413	8.1%
9	148906	7.5%
2	142523	7.2%
	104414	5.3%
3	88947	4.5%
4	65815	3.3%
Other values (3)	111032	5.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	448043	22.6%
1	295117	14.9%
-	208828	10.5%
:	208828	10.5%
5	161413	8.1%
9	148906	7.5%
2	142523	7.2%
	104414	5.3%
3	88947	4.5%
4	65815	3.3%
Other values (3)	111032	5.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	448043	22.6%
1	295117	14.9%
-	208828	10.5%
:	208828	10.5%
5	161413	8.1%
9	148906	7.5%
2	142523	7.2%
	104414	5.3%
3	88947	4.5%
4	65815	3.3%
Other values (3)	111032	5.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1983866	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	448043	22.6%
1	295117	14.9%
-	208828	10.5%
:	208828	10.5%
5	161413	8.1%
9	148906	7.5%
2	142523	7.2%
	104414	5.3%
3	88947	4.5%
4	65815	3.3%
Other values (3)	111032	5.6%

answerduration
Real number (ℝ)

MISSING ZEROS

Distinct	22337
Distinct (%)	21.4%
Missing	63681
Missing (%)	37.9%
Infinite	0
Infinite (%)	0.0%
Mean	10113.03299

Minimum	0
Maximum	462960
Zeros	16159
Zeros (%)	9.6%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5760.25
median	8106
Q3	11800.75
95-th percentile	25856.4
Maximum	462960
Range	462960
Interquartile range (IQR)	6040.5

Descriptive statistics

Standard deviation	11450.0818
Coefficient of variation (CV)	1.132210466
Kurtosis	162.6405062
Mean	10113.03299
Median Absolute Deviation (MAD)	2844
Skewness	8.165215475
Sum	1055942227
Variance	131104373.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	16159	9.6%
7670	23	< 0.1%
7330	23	< 0.1%
7905	23	< 0.1%
7480	23	< 0.1%
7569	22	< 0.1%
6333	22	< 0.1%
6903	22	< 0.1%
7167	21	< 0.1%
7303	21	< 0.1%
Other values (22327)	88055	52.4%
(Missing)	63681	37.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	16159	9.6%
1658	1	< 0.1%
1744	1	< 0.1%
1751	1	< 0.1%
1858	1	< 0.1%

Value	Count	Frequency (%)
462960	1	< 0.1%
454911	1	< 0.1%
429378	1	< 0.1%
359610	1	< 0.1%
343956	1	< 0.1%

delta
Real number (ℝ)

MISSING ZEROS

Distinct	87057
Distinct (%)	83.4%
Missing	63681
Missing (%)	37.9%
Infinite	0
Infinite (%)	0.0%
Mean	2904941.433

Minimum	0
Maximum	73881685
Zeros	2758
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	101560.75
median	808813
Q3	3226259
95-th percentile	14123335.2
Maximum	73881685
Range	73881685
Interquartile range (IQR)	3124698.25

Descriptive statistics

Standard deviation	5048764.894
Coefficient of variation (CV)	1.737991973
Kurtosis	13.05614022
Mean	2904941.433
Median Absolute Deviation (MAD)	808806
Skewness	3.100031657
Sum	3.033165548 × 10¹¹
Variance	2.549002695 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2758	1.6%
3	2523	1.5%
4	1957	1.2%
5	1649	1.0%
2	1612	1.0%
6	1094	0.7%
7	822	0.5%
8	637	0.4%
1	579	0.3%
9	489	0.3%
Other values (87047)	90294	53.7%
(Missing)	63681	37.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2758	1.6%
1	579	0.3%
2	1612	1.0%
3	2523	1.5%
4	1957	1.2%

Value	Count	Frequency (%)
73881685	1	< 0.1%
66692075	1	< 0.1%
66224031	1	< 0.1%
65404555	1	< 0.1%
59502403	1	< 0.1%

what
Text

MISSING

Distinct	22
Distinct (%)	< 0.1%
Missing	63681
Missing (%)	37.9%
Memory size	2.5 MiB

Length

Max length	40
Median length	35
Mean length	11.70900454
Min length	4

Characters and Unicode

Total characters	1222584
Distinct characters	46
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	Sleeping
2nd row	I will go to sleep
3rd row	I will go to sleep
4th row	I will go to sleep
5th row	I will go to sleep

Value	Count	Frequency (%)
studying	17459	8.2%
to	14383	6.8%
i	13466	6.3%
will	13466	6.3%
go	13466	6.3%
sleep	13466	6.3%
sleeping	11618	5.5%
eating	9156	4.3%
etc	8976	4.2%
en	8600	4.0%
Other values (35)	88895	41.7%

Most occurring characters

Value	Count	Frequency (%)
e	127125	10.4%
	108537	8.9%
i	88058	7.2%
t	84365	6.9%
o	81407	6.7%
l	74459	6.1%
n	67963	5.6%
g	64975	5.3%
s	47288	3.9%
a	43018	3.5%
Other values (36)	435389	35.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1222584	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	127125	10.4%
	108537	8.9%
i	88058	7.2%
t	84365	6.9%
o	81407	6.7%
l	74459	6.1%
n	67963	5.6%
g	64975	5.3%
s	47288	3.9%
a	43018	3.5%
Other values (36)	435389	35.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1222584	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	127125	10.4%
	108537	8.9%
i	88058	7.2%
t	84365	6.9%
o	81407	6.7%
l	74459	6.1%
n	67963	5.6%
g	64975	5.3%
s	47288	3.9%
a	43018	3.5%
Other values (36)	435389	35.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1222584	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	127125	10.4%
	108537	8.9%
i	88058	7.2%
t	84365	6.9%
o	81407	6.7%
l	74459	6.1%
n	67963	5.6%
g	64975	5.3%
s	47288	3.9%
a	43018	3.5%
Other values (36)	435389	35.6%

how
Text

MISSING

Distinct	6
Distinct (%)	0.1%
Missing	159448
Missing (%)	94.9%
Memory size	1.4 MiB

Length

Max length	12
Median length	8
Mean length	6.702324506
Min length	6

Characters and Unicode

Total characters	57955
Distinct characters	17
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	By bike
2nd row	By car
3rd row	By car
4th row	By car
5th row	By car

Value	Count	Frequency (%)
by	8647	50.0%
foot	3169	18.3%
car	2479	14.3%
bus	1551	9.0%
train	1241	7.2%
bike	164	0.9%
motorbike	43	0.2%

Most occurring characters

Value	Count	Frequency (%)
B	8647	14.9%
y	8647	14.9%
	8647	14.9%
o	6424	11.1%
t	4453	7.7%
r	3763	6.5%
a	3720	6.4%
f	3169	5.5%
c	2479	4.3%
b	1758	3.0%
Other values (7)	6248	10.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	57955	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	8647	14.9%
y	8647	14.9%
	8647	14.9%
o	6424	11.1%
t	4453	7.7%
r	3763	6.5%
a	3720	6.4%
f	3169	5.5%
c	2479	4.3%
b	1758	3.0%
Other values (7)	6248	10.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	57955	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	8647	14.9%
y	8647	14.9%
	8647	14.9%
o	6424	11.1%
t	4453	7.7%
r	3763	6.5%
a	3720	6.4%
f	3169	5.5%
c	2479	4.3%
b	1758	3.0%
Other values (7)	6248	10.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	57955	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	8647	14.9%
y	8647	14.9%
	8647	14.9%
o	6424	11.1%
t	4453	7.7%
r	3763	6.5%
a	3720	6.4%
f	3169	5.5%
c	2479	4.3%
b	1758	3.0%
Other values (7)	6248	10.8%

where
Text

MISSING

Distinct	16
Distinct (%)	< 0.1%
Missing	88402
Missing (%)	52.6%
Memory size	2.1 MiB

Length

Max length	30
Median length	26
Mean length	11.07075904
Min length	3

Characters and Unicode

Total characters	882262
Distinct characters	41
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	Relatives Home
2nd row	Relatives Home
3rd row	Relatives Home
4th row	Relatives Home
5th row	Relatives Home

Value	Count	Frequency (%)
home	49252	34.2%
relatives	14174	9.8%
	10070	7.0%
classroom	9737	6.8%
place	5244	3.6%
laboratory	5185	3.6%
study	4552	3.2%
hall	4552	3.2%
outdoors	4531	3.1%
house	4388	3.0%
Other values (19)	32357	22.5%

Most occurring characters

Value	Count	Frequency (%)
e	109763	12.4%
o	99430	11.3%
	64349	7.3%
m	60602	6.9%
s	55879	6.3%
a	55464	6.3%
r	55189	6.3%
H	53640	6.1%
t	44533	5.0%
l	38259	4.3%
Other values (31)	245154	27.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	882262	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	109763	12.4%
o	99430	11.3%
	64349	7.3%
m	60602	6.9%
s	55879	6.3%
a	55464	6.3%
r	55189	6.3%
H	53640	6.1%
t	44533	5.0%
l	38259	4.3%
Other values (31)	245154	27.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	882262	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	109763	12.4%
o	99430	11.3%
	64349	7.3%
m	60602	6.9%
s	55879	6.3%
a	55464	6.3%
r	55189	6.3%
H	53640	6.1%
t	44533	5.0%
l	38259	4.3%
Other values (31)	245154	27.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	882262	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	109763	12.4%
o	99430	11.3%
	64349	7.3%
m	60602	6.9%
s	55879	6.3%
a	55464	6.3%
r	55189	6.3%
H	53640	6.1%
t	44533	5.0%
l	38259	4.3%
Other values (31)	245154	27.8%

withwhom
Text

MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	79840
Missing (%)	47.5%
Memory size	1.9 MiB

Length

Max length	12
Median length	11
Mean length	7.563197553
Min length	5

Characters and Unicode

Total characters	667490
Distinct characters	23
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	Relative(s)
2nd row	Relative(s)
3rd row	Alone
4th row	Alone
5th row	Alone

Value	Count	Frequency (%)
alone	41269	46.8%
friend(s	14751	16.7%
relative(s	8633	9.8%
classmate(s	7677	8.7%
partner	6897	7.8%
roommate(s	6265	7.1%
colleague(s	1470	1.7%
other	1293	1.5%

Most occurring characters

Value	Count	Frequency (%)
e	98358	14.7%
n	62917	9.4%
l	60519	9.1%
o	55269	8.3%
s	54150	8.1%
A	41269	6.2%
(	38796	5.8%
)	38796	5.8%
a	38619	5.8%
t	30765	4.6%
Other values (13)	148032	22.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	667490	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	98358	14.7%
n	62917	9.4%
l	60519	9.1%
o	55269	8.3%
s	54150	8.1%
A	41269	6.2%
(	38796	5.8%
)	38796	5.8%
a	38619	5.8%
t	30765	4.6%
Other values (13)	148032	22.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	667490	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	98358	14.7%
n	62917	9.4%
l	60519	9.1%
o	55269	8.3%
s	54150	8.1%
A	41269	6.2%
(	38796	5.8%
)	38796	5.8%
a	38619	5.8%
t	30765	4.6%
Other values (13)	148032	22.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	667490	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	98358	14.7%
n	62917	9.4%
l	60519	9.1%
o	55269	8.3%
s	54150	8.1%
A	41269	6.2%
(	38796	5.8%
)	38796	5.8%
a	38619	5.8%
t	30765	4.6%
Other values (13)	148032	22.2%

mood
Real number (ℝ)

MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	79840
Missing (%)	47.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.8026854

Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	3
median	4
Q3	4
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7571803238
Coefficient of variation (CV)	0.1991172669
Kurtosis	2.059408726
Mean	3.8026854
Median Absolute Deviation (MAD)	0
Skewness	-0.9201782253
Sum	335606
Variance	0.5733220427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
4	52527	31.2%
3	20382	12.1%
5	11714	7.0%
2	2150	1.3%
1	1482	0.9%
(Missing)	79840	47.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1482	0.9%
2	2150	1.3%
3	20382	12.1%
4	52527	31.2%
5	11714	7.0%

Value	Count	Frequency (%)
5	11714	7.0%
4	52527	31.2%
3	20382	12.1%
2	2150	1.3%
1	1482	0.9%

week
Text

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	1344760
Distinct characters	10
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	1st week
2nd row	1st week
3rd row	1st week
4th row	1st week
5th row	1st week

Value	Count	Frequency (%)
week	168095	50.0%
1st	118007	35.1%
2nd	50088	14.9%

Most occurring characters

Value	Count	Frequency (%)
e	336190	25.0%
	168095	12.5%
w	168095	12.5%
k	168095	12.5%
1	118007	8.8%
s	118007	8.8%
t	118007	8.8%
2	50088	3.7%
n	50088	3.7%
d	50088	3.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1344760	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	336190	25.0%
	168095	12.5%
w	168095	12.5%
k	168095	12.5%
1	118007	8.8%
s	118007	8.8%
t	118007	8.8%
2	50088	3.7%
n	50088	3.7%
d	50088	3.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1344760	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	336190	25.0%
	168095	12.5%
w	168095	12.5%
k	168095	12.5%
1	118007	8.8%
s	118007	8.8%
t	118007	8.8%
2	50088	3.7%
n	50088	3.7%
d	50088	3.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1344760	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	336190	25.0%
	168095	12.5%
w	168095	12.5%
k	168095	12.5%
1	118007	8.8%
s	118007	8.8%
t	118007	8.8%
2	50088	3.7%
n	50088	3.7%
d	50088	3.7%

latitude
Real number (ℝ)

MISSING

Distinct	10367
Distinct (%)	38.6%
Missing	141268
Missing (%)	84.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.98730973

Minimum	37.3871
Maximum	50.08577333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	37.3871
5-th percentile	45.632227
Q1	46.0469
median	46.06502222
Q3	46.0691
95-th percentile	46.19170939
Maximum	50.08577333
Range	12.69867333
Interquartile range (IQR)	0.0222

Descriptive statistics

Standard deviation	0.4620216799
Coefficient of variation (CV)	0.01004672121
Kurtosis	102.2981417
Mean	45.98730973
Median Absolute Deviation (MAD)	0.00727778
Skewness	-8.188076116
Sum	1233701.558
Variance	0.2134640327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45.8201	378	0.2%
46.0798	305	0.2%
46.067	303	0.2%
46.0992	303	0.2%
46.0694	291	0.2%
46.2109	260	0.2%
45.8641	259	0.2%
46.0667	250	0.1%
46.0611	246	0.1%
46.0663	238	0.1%
Other values (10357)	23994	14.3%
(Missing)	141268	84.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
37.3871	7	< 0.1%
39.21696364	1	< 0.1%
39.21698	1	< 0.1%
39.217	2	< 0.1%
39.217025	1	< 0.1%

Value	Count	Frequency (%)
50.08577333	1	< 0.1%
50.08577	1	< 0.1%
50.08573636	1	< 0.1%
50.08572564	1	< 0.1%
50.08572069	1	< 0.1%

longitude
Real number (ℝ)

MISSING

Distinct	11948
Distinct (%)	44.5%
Missing	141268
Missing (%)	84.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.18180229

Minimum	-5.9888
Maximum	16.41363704
Zeros	0
Zeros (%)	0.0%
Negative	7
Negative (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-5.9888
5-th percentile	10.9442
Q1	11.1169
median	11.12556667
Q3	11.14251334
95-th percentile	11.7208
Maximum	16.41363704
Range	22.40243704
Interquartile range (IQR)	0.025613335

Descriptive statistics

Standard deviation	0.5386111478
Coefficient of variation (CV)	0.04816854508
Kurtosis	301.826472
Mean	11.18180229
Median Absolute Deviation (MAD)	0.00946667
Skewness	-4.802934546
Sum	299974.2101
Variance	0.2901019685
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.1199	330	0.2%
11.1316	330	0.2%
12.2916	292	0.2%
11.134	280	0.2%
11.129	270	0.2%
11.0924	233	0.1%
11.1449	199	0.1%
11.1272	189	0.1%
11.1502	184	0.1%
11.1231	173	0.1%
Other values (11938)	24347	14.5%
(Missing)	141268	84.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-5.9888	7	< 0.1%
7.747	3	< 0.1%
7.747046667	1	< 0.1%
7.747048148	1	< 0.1%
7.7471	1	< 0.1%

Value	Count	Frequency (%)
16.41363704	1	< 0.1%
16.41344545	1	< 0.1%
16.41344231	1	< 0.1%
16.41342258	1	< 0.1%
16.4134125	1	< 0.1%

altitude
Real number (ℝ)

MISSING

Distinct	241
Distinct (%)	0.9%
Missing	141268
Missing (%)	84.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.880002535

Minimum	-18
Maximum	1060.681854
Zeros	12
Zeros (%)	< 0.1%
Negative	26554
Negative (%)	15.8%
Memory size	1.3 MiB

Quantile statistics

Minimum	-18
5-th percentile	-1
Q1	-1
median	-1
Q3	-1
95-th percentile	-1
Maximum	1060.681854
Range	1078.681854
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	32.85091396
Coefficient of variation (CV)	17.47386684
Kurtosis	306.4537198
Mean	1.880002535
Median Absolute Deviation (MAD)	0
Skewness	15.1760688
Sum	50434.82801
Variance	1079.182548
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	26553	15.8%
0	12	< 0.1%
262	4	< 0.1%
65	3	< 0.1%
263	3	< 0.1%
249	3	< 0.1%
252	3	< 0.1%
245	2	< 0.1%
238	2	< 0.1%
259	2	< 0.1%
Other values (231)	240	0.1%
(Missing)	141268	84.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-18	1	< 0.1%
-1	26553	15.8%
0	12	< 0.1%
33.6656	1	< 0.1%
45.33434	1	< 0.1%

Value	Count	Frequency (%)
1060.681854	1	< 0.1%
1059.764319	1	< 0.1%
1056.616359	1	< 0.1%
1054.62897	1	< 0.1%
931	1	< 0.1%

gid
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	147
Distinct (%)	7.5%
Missing	166140
Missing (%)	98.8%
Infinite	0
Infinite (%)	0.0%
Mean	2232692.912

Minimum	567
Maximum	4585114
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	567
5-th percentile	7874
Q1	742315
median	3200456
Q3	3373916
95-th percentile	3523873
Maximum	4585114
Range	4584547
Interquartile range (IQR)	2631601

Descriptive statistics

Standard deviation	1458625.498
Coefficient of variation (CV)	0.6533032333
Kurtosis	-1.535198549
Mean	2232692.912
Median Absolute Deviation (MAD)	256598
Skewness	-0.3842181767
Sum	4364914642
Variance	2.127588344 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3373916	405	0.2%
7874	192	0.1%
3372274	154	0.1%
3389224	154	0.1%
2943858	114	0.1%
742315	92	0.1%
772636	86	0.1%
3200456	75	< 0.1%
743319	72	< 0.1%
741151	67	< 0.1%
Other values (137)	544	0.3%
(Missing)	166140	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
567	2	< 0.1%
977	2	< 0.1%
1777	1	< 0.1%
7874	192	0.1%
7875	2	< 0.1%

Value	Count	Frequency (%)
4585114	1	< 0.1%
4585112	2	< 0.1%
4576144	1	< 0.1%
4553483	1	< 0.1%
4550049	2	< 0.1%

osm_id
Real number (ℝ)

MISSING

Distinct	147
Distinct (%)	7.5%
Missing	166140
Missing (%)	98.8%
Infinite	0
Infinite (%)	0.0%
Mean	467725109.5

Minimum	65608561
Maximum	1.081679294 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	65608561
5-th percentile	106077349
Q1	149753711
median	218008250
Q3	218923891
95-th percentile	882460310
Maximum	1.081679294 × 10¹⁰
Range	1.075118438 × 10¹⁰
Interquartile range (IQR)	69170180

Descriptive statistics

Standard deviation	1188726408
Coefficient of variation (CV)	2.541506504
Kurtosis	32.41409059
Mean	467725109.5
Median Absolute Deviation (MAD)	28762759
Skewness	5.61976248
Sum	9.144025891 × 10¹¹
Variance	1.413070473 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
218008250	405	0.2%
564884221	192	0.1%
217897668	154	0.1%
218923891	154	0.1%
189245491	114	0.1%
106077349	92	0.1%
120210327	86	0.1%
200221570	75	< 0.1%
106406070	72	< 0.1%
105602479	67	< 0.1%
Other values (137)	544	0.3%
(Missing)	166140	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
65608561	4	< 0.1%
70259362	1	< 0.1%
97548080	1	< 0.1%
102779829	3	< 0.1%
104720377	2	< 0.1%

Value	Count	Frequency (%)
1.081679294 × 10¹⁰	2	< 0.1%
9930095450	1	< 0.1%
9363013553	1	< 0.1%
7987971963	24	< 0.1%
7079797034	3	< 0.1%

code
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	27
Distinct (%)	1.4%
Missing	166140
Missing (%)	98.8%
Infinite	0
Infinite (%)	0.0%
Mean	1702.330946

Minimum	1050
Maximum	7204
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1050
5-th percentile	1500
Q1	1500
median	1500
Q3	1500
95-th percentile	2601
Maximum	7204
Range	6154
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	627.7870554
Coefficient of variation (CV)	0.3687808512
Kurtosis	23.61535817
Mean	1702.330946
Median Absolute Deviation (MAD)	0
Skewness	4.350079643
Sum	3328057
Variance	394116.5869
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1500	1648	1.0%
2601	194	0.1%
1050	24	< 0.1%
5204	20	< 0.1%
2602	14	< 0.1%
2301	8	< 0.1%
2401	6	< 0.1%
2516	4	< 0.1%
2515	4	< 0.1%
5260	4	< 0.1%
Other values (17)	29	< 0.1%
(Missing)	166140	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1050	24	< 0.1%
1500	1648	1.0%
2031	1	< 0.1%
2205	1	< 0.1%
2301	8	< 0.1%

Value	Count	Frequency (%)
7204	1	< 0.1%
7203	2	< 0.1%
5601	2	< 0.1%
5332	2	< 0.1%
5303	3	< 0.1%

fclass
Text

MISSING

Distinct	27
Distinct (%)	1.4%
Missing	166140
Missing (%)	98.8%
Memory size	1.3 MiB

Length

Max length	15
Median length	8
Mean length	7.560102302
Min length	3

Characters and Unicode

Total characters	14780
Distinct characters	22
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	8 ?
Unique (%)	0.4%

Sample

1st row	building
2nd row	industrial
3rd row	building
4th row	building
5th row	building

Value	Count	Frequency (%)
building	1648	84.3%
bank	194	9.9%
locality	24	1.2%
crossing	20	1.0%
atm	14	0.7%
restaurant	8	0.4%
hotel	6	0.3%
bookshop	4	0.2%
butcher	4	0.2%
parking	4	0.2%
Other values (17)	29	1.5%

Most occurring characters

Value	Count	Frequency (%)
i	3371	22.8%
n	1890	12.8%
b	1855	12.6%
l	1713	11.6%
g	1678	11.4%
u	1664	11.3%
d	1654	11.2%
a	275	1.9%
k	205	1.4%
t	80	0.5%
Other values (12)	395	2.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	14780	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	3371	22.8%
n	1890	12.8%
b	1855	12.6%
l	1713	11.6%
g	1678	11.4%
u	1664	11.3%
d	1654	11.2%
a	275	1.9%
k	205	1.4%
t	80	0.5%
Other values (12)	395	2.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	14780	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	3371	22.8%
n	1890	12.8%
b	1855	12.6%
l	1713	11.6%
g	1678	11.4%
u	1664	11.3%
d	1654	11.2%
a	275	1.9%
k	205	1.4%
t	80	0.5%
Other values (12)	395	2.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	14780	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	3371	22.8%
n	1890	12.8%
b	1855	12.6%
l	1713	11.6%
g	1678	11.4%
u	1664	11.3%
d	1654	11.2%
a	275	1.9%
k	205	1.4%
t	80	0.5%
Other values (12)	395	2.7%

name
Text

MISSING

Distinct	21
Distinct (%)	1.1%
Missing	166140
Missing (%)	98.8%
Memory size	1.3 MiB

Length

Max length	38
Median length	2
Mean length	4.886956522
Min length	2

Characters and Unicode

Total characters	9554
Distinct characters	41
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	6 ?
Unique (%)	0.3%

Sample

1st row	\N
2nd row	\N
3rd row	\N
4th row	\N
5th row	\N

Value	Count	Frequency (%)
n	1701	65.1%
cassa	194	7.4%
rurale	192	7.3%
alta	192	7.3%
valsugana	192	7.3%
lungolago	24	0.9%
e	8	0.3%
hotel	6	0.2%
antica	6	0.2%
rosa	6	0.2%
Other values (41)	92	3.5%

Most occurring characters

Value	Count	Frequency (%)
N	1702	17.8%
\	1701	17.8%
a	1463	15.3%
	658	6.9%
l	645	6.8%
s	604	6.3%
u	409	4.3%
e	257	2.7%
n	255	2.7%
g	245	2.6%
Other values (31)	1615	16.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9554	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	1702	17.8%
\	1701	17.8%
a	1463	15.3%
	658	6.9%
l	645	6.8%
s	604	6.3%
u	409	4.3%
e	257	2.7%
n	255	2.7%
g	245	2.6%
Other values (31)	1615	16.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9554	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	1702	17.8%
\	1701	17.8%
a	1463	15.3%
	658	6.9%
l	645	6.8%
s	604	6.3%
u	409	4.3%
e	257	2.7%
n	255	2.7%
g	245	2.6%
Other values (31)	1615	16.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9554	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	1702	17.8%
\	1701	17.8%
a	1463	15.3%
	658	6.9%
l	645	6.8%
s	604	6.3%
u	409	4.3%
e	257	2.7%
n	255	2.7%
g	245	2.6%
Other values (31)	1615	16.9%

population
Real number (ℝ)

CONSTANT MISSING

Distinct	1
Distinct (%)	4.2%
Missing	168071
Missing (%)	> 99.9%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	24
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	0
Range	0
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0
Coefficient of variation (CV)	nan
Kurtosis	0
Mean	0
Median Absolute Deviation (MAD)	0
Skewness	0
Sum	0
Variance	0
Monotonicity	Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	24	< 0.1%
(Missing)	168071	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	24	< 0.1%

Value	Count	Frequency (%)
0	24	< 0.1%

type
Text

MISSING

Distinct	10
Distinct (%)	0.6%
Missing	166447
Missing (%)	99.0%
Memory size	1.3 MiB

Length

Max length	14
Median length	2
Mean length	2.737864078
Min length	2

Characters and Unicode

Total characters	4512
Distinct characters	22
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	3 ?
Unique (%)	0.2%

Sample

1st row	\N
2nd row	house
3rd row	\N
4th row	\N
5th row	\N

Value	Count	Frequency (%)
n	1414	85.8%
apartments	92	5.6%
house	87	5.3%
hut	29	1.8%
boathouse	18	1.1%
church	3	0.2%
farm_auxiliary	2	0.1%
industrial	1	0.1%
residential	1	0.1%
train_station	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
\	1414	31.3%
N	1414	31.3%
t	236	5.2%
a	212	4.7%
s	200	4.4%
e	199	4.4%
h	140	3.1%
u	140	3.1%
o	124	2.7%
r	102	2.3%
Other values (12)	331	7.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4512	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
\	1414	31.3%
N	1414	31.3%
t	236	5.2%
a	212	4.7%
s	200	4.4%
e	199	4.4%
h	140	3.1%
u	140	3.1%
o	124	2.7%
r	102	2.3%
Other values (12)	331	7.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4512	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
\	1414	31.3%
N	1414	31.3%
t	236	5.2%
a	212	4.7%
s	200	4.4%
e	199	4.4%
h	140	3.1%
u	140	3.1%
o	124	2.7%
r	102	2.3%
Other values (12)	331	7.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4512	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
\	1414	31.3%
N	1414	31.3%
t	236	5.2%
a	212	4.7%
s	200	4.4%
e	199	4.4%
h	140	3.1%
u	140	3.1%
o	124	2.7%
r	102	2.3%
Other values (12)	331	7.3%

coordinates
Text

MISSING

Distinct	147
Distinct (%)	7.5%
Missing	166140
Missing (%)	98.8%
Memory size	1.7 MiB

Length

Max length	802
Median length	436
Mean length	227.6337596
Min length	25

Characters and Unicode

Total characters	445024
Distinct characters	17
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	62 ?
Unique (%)	3.2%

Sample

1st row	[(11.2227828, 46.1749667), (11.2230031, 46.1750353), (11.2230666, 46.1749375), (11.2228464, 46.1748689), (11.2227828, 46.1749667)]
2nd row	[(11.7937218, 45.7999569), (11.7937336, 45.7999866), (11.7937525, 45.8000341), (11.7938225, 45.8001291), (11.7939063, 45.8001942), (11.7939472, 45.8002363), (11.7939497, 45.8002341), (11.7948695, 45.7991892), (11.7948545, 45.799189), (11.7948532, 45.7992007), (11.794845, 45.7992048), (11.7948376, 45.7992096), (11.7948343, 45.7992123), (11.7944633, 45.7996461), (11.7940698, 45.7994583), (11.7937239, 45.7998697), (11.7937218, 45.7999569)]
3rd row	[(11.22681, 46.0283445), (11.2268181, 46.0284832), (11.2270017, 46.028478), (11.2269935, 46.0283393), (11.22681, 46.0283445)]
4th row	[(11.7158349, 45.8200596), (11.7159617, 45.8201145), (11.716012, 45.8200565), (11.7160253, 45.8200617), (11.71607, 45.8200091), (11.7160825, 45.8200134), (11.7161249, 45.8199606), (11.7161394, 45.8199653), (11.7161879, 45.819907), (11.7160658, 45.8198516), (11.7160184, 45.8199119), (11.7160016, 45.8199035), (11.7159608, 45.8199572), (11.715945, 45.8199523), (11.7158997, 45.8200055), (11.715886, 45.8200016), (11.7158349, 45.8200596)]
5th row	[(11.7158349, 45.8200596), (11.7159617, 45.8201145), (11.716012, 45.8200565), (11.7160253, 45.8200617), (11.71607, 45.8200091), (11.7160825, 45.8200134), (11.7161249, 45.8199606), (11.7161394, 45.8199653), (11.7161879, 45.819907), (11.7160658, 45.8198516), (11.7160184, 45.8199119), (11.7160016, 45.8199035), (11.7159608, 45.8199572), (11.715945, 45.8199523), (11.7158997, 45.8200055), (11.715886, 45.8200016), (11.7158349, 45.8200596)]

Value	Count	Frequency (%)
11.7158349	810	2.3%
45.8200596	810	2.3%
11.7159617	405	1.2%
45.8201145	405	1.2%
11.716012	405	1.2%
45.8200565	405	1.2%
11.7160253	405	1.2%
45.8200617	405	1.2%
11.71607	405	1.2%
45.8200091	405	1.2%
Other values (1604)	29804	86.0%

Most occurring characters

Value	Count	Frequency (%)
1	67387	15.1%
6	35508	8.0%
5	34747	7.8%
.	34664	7.8%
,	32709	7.3%
	32709	7.3%
4	31869	7.2%
0	29076	6.5%
9	28471	6.4%
8	22420	5.0%
Other values (7)	95464	21.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	445024	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	67387	15.1%
6	35508	8.0%
5	34747	7.8%
.	34664	7.8%
,	32709	7.3%
	32709	7.3%
4	31869	7.2%
0	29076	6.5%
9	28471	6.4%
8	22420	5.0%
Other values (7)	95464	21.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	445024	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	67387	15.1%
6	35508	8.0%
5	34747	7.8%
.	34664	7.8%
,	32709	7.3%
	32709	7.3%
4	31869	7.2%
0	29076	6.5%
9	28471	6.4%
8	22420	5.0%
Other values (7)	95464	21.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	445024	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	67387	15.1%
6	35508	8.0%
5	34747	7.8%
.	34664	7.8%
,	32709	7.3%
	32709	7.3%
4	31869	7.2%
0	29076	6.5%
9	28471	6.4%
8	22420	5.0%
Other values (7)	95464	21.5%

Auto

Heatmap
Table

	altitude	answerduration	code	delta	gid	latitude	longitude	mood	osm_id	userid
altitude	1.000	0.038	-0.007	0.007	0.013	-0.016	0.019	0.009	0.053	0.024
answerduration	0.038	1.000	0.013	0.367	-0.107	0.035	-0.006	0.040	-0.042	0.015
code	-0.007	0.013	1.000	-0.052	-0.542	0.047	-0.108	0.071	0.476	-0.109
delta	0.007	0.367	-0.052	1.000	-0.047	0.053	-0.005	0.052	-0.110	-0.020
gid	0.013	-0.107	-0.542	-0.047	1.000	-0.176	0.480	-0.054	0.240	-0.217
latitude	-0.016	0.035	0.047	0.053	-0.176	1.000	-0.119	-0.022	-0.129	-0.173
longitude	0.019	-0.006	-0.108	-0.005	0.480	-0.119	1.000	0.052	0.284	0.012
mood	0.009	0.040	0.071	0.052	-0.054	-0.022	0.052	1.000	0.084	0.008
osm_id	0.053	-0.042	0.476	-0.110	0.240	-0.129	0.284	0.084	1.000	-0.269
userid	0.024	0.015	-0.109	-0.020	-0.217	-0.173	0.012	0.008	-0.269	1.000

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks