Overview

Dataset statistics

Number of variables2
Number of observations100
Missing cells9
Missing cells (%)4.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory17.3 B

Variable types

Text2

Alerts

장소 아이디 has 9 (9.0%) missing valuesMissing
장치 아이디 has unique valuesUnique

Reproduction

Analysis started2023-12-10 12:00:38.730021
Analysis finished2023-12-10 12:00:39.203590
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

장치 아이디
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T21:00:39.421697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

Total characters2400
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row5f28d181a42fcd6d828e013d
2nd row5f28db78ee39d47796f08a04
3rd row5f28dc8aee39d47796f08a08
4th row5f28f1724de0bb7ebabe6dbb
5th row5f28f1d84de0bb7ebabe6dbf
ValueCountFrequency (%)
5f28d181a42fcd6d828e013d 1
 
1.0%
5f962e189dc73747d6e71cb2 1
 
1.0%
5f962e189dc73747d6e71cd8 1
 
1.0%
5f962e189dc73747d6e71cd1 1
 
1.0%
5f962e189dc73747d6e71cce 1
 
1.0%
5f962e189dc73747d6e71ccb 1
 
1.0%
5f962e189dc73747d6e71cc8 1
 
1.0%
5f962e189dc73747d6e71cc5 1
 
1.0%
5f962e189dc73747d6e71cc2 1
 
1.0%
5f962e189dc73747d6e71cbf 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T21:00:39.988555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 277
11.5%
d 190
 
7.9%
5 189
 
7.9%
f 188
 
7.8%
1 179
 
7.5%
9 174
 
7.2%
e 164
 
6.8%
c 157
 
6.5%
6 155
 
6.5%
2 151
 
6.3%
Other values (6) 576
24.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1553
64.7%
Lowercase Letter 847
35.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 277
17.8%
5 189
12.2%
1 179
11.5%
9 174
11.2%
6 155
10.0%
2 151
9.7%
3 132
8.5%
4 116
7.5%
8 109
 
7.0%
0 71
 
4.6%
Lowercase Letter
ValueCountFrequency (%)
d 190
22.4%
f 188
22.2%
e 164
19.4%
c 157
18.5%
b 82
9.7%
a 66
 
7.8%

Most occurring scripts

ValueCountFrequency (%)
Common 1553
64.7%
Latin 847
35.3%

Most frequent character per script

Common
ValueCountFrequency (%)
7 277
17.8%
5 189
12.2%
1 179
11.5%
9 174
11.2%
6 155
10.0%
2 151
9.7%
3 132
8.5%
4 116
7.5%
8 109
 
7.0%
0 71
 
4.6%
Latin
ValueCountFrequency (%)
d 190
22.4%
f 188
22.2%
e 164
19.4%
c 157
18.5%
b 82
9.7%
a 66
 
7.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2400
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7 277
11.5%
d 190
 
7.9%
5 189
 
7.9%
f 188
 
7.8%
1 179
 
7.5%
9 174
 
7.2%
e 164
 
6.8%
c 157
 
6.5%
6 155
 
6.5%
2 151
 
6.3%
Other values (6) 576
24.0%

장소 아이디
Text

MISSING 

Distinct85
Distinct (%)93.4%
Missing9
Missing (%)9.0%
Memory size932.0 B
2023-12-10T21:00:40.373705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

Total characters2184
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique81 ?
Unique (%)89.0%

Sample

1st row5f28d167a42fcd6d828e013b
2nd row5f28db25ee39d47796f08a01
3rd row5f28dc6eee39d47796f08a05
4th row5f28f15b4de0bb7ebabe6db8
5th row5f28f1bb4de0bb7ebabe6dbc
ValueCountFrequency (%)
5f3cbebcb7894827fa3c6c8f 3
 
3.3%
5f3355eebf556f3fc5479f50 3
 
3.3%
5f2902e5d75afc21134d7534 2
 
2.2%
5f71607e39518d7393361fa4 2
 
2.2%
5f962e189dc73747d6e71cba 1
 
1.1%
5f962e189dc73747d6e71cc3 1
 
1.1%
5f962e189dc73747d6e71ccf 1
 
1.1%
5f962e189dc73747d6e71ccc 1
 
1.1%
5f962e189dc73747d6e71cc9 1
 
1.1%
5f962e189dc73747d6e71cc6 1
 
1.1%
Other values (75) 75
82.4%
2023-12-10T21:00:40.965572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 268
12.3%
f 176
 
8.1%
d 176
 
8.1%
5 168
 
7.7%
e 164
 
7.5%
1 153
 
7.0%
9 150
 
6.9%
c 147
 
6.7%
6 140
 
6.4%
3 122
 
5.6%
Other values (6) 520
23.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1380
63.2%
Lowercase Letter 804
36.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 268
19.4%
5 168
12.2%
1 153
11.1%
9 150
10.9%
6 140
10.1%
3 122
8.8%
2 113
8.2%
8 103
 
7.5%
4 101
 
7.3%
0 62
 
4.5%
Lowercase Letter
ValueCountFrequency (%)
f 176
21.9%
d 176
21.9%
e 164
20.4%
c 147
18.3%
b 88
10.9%
a 53
 
6.6%

Most occurring scripts

ValueCountFrequency (%)
Common 1380
63.2%
Latin 804
36.8%

Most frequent character per script

Common
ValueCountFrequency (%)
7 268
19.4%
5 168
12.2%
1 153
11.1%
9 150
10.9%
6 140
10.1%
3 122
8.8%
2 113
8.2%
8 103
 
7.5%
4 101
 
7.3%
0 62
 
4.5%
Latin
ValueCountFrequency (%)
f 176
21.9%
d 176
21.9%
e 164
20.4%
c 147
18.3%
b 88
10.9%
a 53
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2184
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7 268
12.3%
f 176
 
8.1%
d 176
 
8.1%
5 168
 
7.7%
e 164
 
7.5%
1 153
 
7.0%
9 150
 
6.9%
c 147
 
6.7%
6 140
 
6.4%
3 122
 
5.6%
Other values (6) 520
23.8%

Correlations

2023-12-10T21:00:41.113812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
장치 아이디장소 아이디
장치 아이디1.0001.000
장소 아이디1.0001.000

Missing values

2023-12-10T21:00:39.044358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T21:00:39.159093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

장치 아이디장소 아이디
05f28d181a42fcd6d828e013d5f28d167a42fcd6d828e013b
15f28db78ee39d47796f08a045f28db25ee39d47796f08a01
25f28dc8aee39d47796f08a085f28dc6eee39d47796f08a05
35f28f1724de0bb7ebabe6dbb5f28f15b4de0bb7ebabe6db8
45f28f1d84de0bb7ebabe6dbf5f28f1bb4de0bb7ebabe6dbc
55f28f2224de0bb7ebabe6dc25f28f21a4de0bb7ebabe6dc0
65f28f3394de0bb7ebabe6dc85f28f3324de0bb7ebabe6dc6
75f28f3874de0bb7ebabe6dcb5f28f3804de0bb7ebabe6dca
85f28f41d4de0bb7ebabe6dce5f28f3f44de0bb7ebabe6dcd
95f28f4624de0bb7ebabe6dd15f28f45b4de0bb7ebabe6dd0
장치 아이디장소 아이디
905f97f7d4a79bc35a8f7d7d245f97f7d4a79bc35a8f7d7d22
915f980dc3d645151fccc131a75f3355eebf556f3fc5479f50
925f996484e0f2eb506114fe265f996484e0f2eb506114fe24
935f9a82a631af700a30977dc9<NA>
945f9ac182e0f2eb506114fe2a5f9ac182e0f2eb506114fe28
955f9b59d9e0f2eb506114fe2e5f9b59d9e0f2eb506114fe2c
965f9b7866ad60bb243eaf4534<NA>
975f9ba8ee417dd148d18f5fc3<NA>
985f9bc170e0f2eb506114fe325f9bc170e0f2eb506114fe30
995f9c99c9e0f2eb506114fe365f9c99c9e0f2eb506114fe34