Overview

Dataset statistics

Number of variables15
Number of observations93
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.0 KiB
Average record size in memory121.4 B

Variable types

Text8
Categorical6
DateTime1

Dataset

Description창원시 주남저수지스마트스토리텔림제공시스템의 비콘에 관한 정보(장비이름, 맥어드레드, 비콘주소, 유유아이디, 매이저, 마이너, 위도, 경도, 팝업, 타입, 서브타입, 사진, 스탬프, 생성일, 수정일
Author경상남도 창원시
URLhttps://www.data.go.kr/data/15089009/fileData.do

Alerts

유유아이디 has constant value ""Constant
팝업 is highly overall correlated with 타입High correlation
타입 is highly overall correlated with 팝업High correlation
매이저 is highly imbalanced (89.2%)Imbalance
팝업 is highly imbalanced (79.4%)Imbalance
타입 is highly imbalanced (52.9%)Imbalance
사진 is highly imbalanced (83.5%)Imbalance
스탬프 is highly imbalanced (70.5%)Imbalance
맥어드레스 has unique valuesUnique
장비이름 has unique valuesUnique
마이너 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:47:35.885738
Analysis finished2023-12-12 10:47:38.364259
Duration2.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

맥어드레스
Text

UNIQUE 

Distinct93
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:38.696513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length10
Mean length10.064516
Min length10

Characters and Unicode

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

Unique

Unique93 ?
Unique (%)100.0%

Sample

1st row('next198'
2nd row('next451'
3rd row('next477'
4th row('next604'
5th row('next772'
ValueCountFrequency (%)
next198 1
 
1.1%
next919 1
 
1.1%
next941 1
 
1.1%
next940 1
 
1.1%
next939 1
 
1.1%
next938 1
 
1.1%
next937 1
 
1.1%
next935 1
 
1.1%
next934 1
 
1.1%
next933 1
 
1.1%
Other values (83) 83
89.2%
2023-12-12T19:47:39.286498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
' 186
19.9%
( 93
9.9%
n 93
9.9%
e 93
9.9%
x 93
9.9%
t 93
9.9%
9 74
 
7.9%
8 44
 
4.7%
1 25
 
2.7%
7 24
 
2.6%
Other values (6) 118
12.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 372
39.7%
Decimal Number 285
30.4%
Other Punctuation 186
19.9%
Open Punctuation 93
 
9.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
9 74
26.0%
8 44
15.4%
1 25
 
8.8%
7 24
 
8.4%
4 22
 
7.7%
0 22
 
7.7%
2 22
 
7.7%
5 20
 
7.0%
3 18
 
6.3%
6 14
 
4.9%
Lowercase Letter
ValueCountFrequency (%)
n 93
25.0%
e 93
25.0%
x 93
25.0%
t 93
25.0%
Other Punctuation
ValueCountFrequency (%)
' 186
100.0%
Open Punctuation
ValueCountFrequency (%)
( 93
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 564
60.3%
Latin 372
39.7%

Most frequent character per script

Common
ValueCountFrequency (%)
' 186
33.0%
( 93
16.5%
9 74
 
13.1%
8 44
 
7.8%
1 25
 
4.4%
7 24
 
4.3%
4 22
 
3.9%
0 22
 
3.9%
2 22
 
3.9%
5 20
 
3.5%
Other values (2) 32
 
5.7%
Latin
ValueCountFrequency (%)
n 93
25.0%
e 93
25.0%
x 93
25.0%
t 93
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 936
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
' 186
19.9%
( 93
9.9%
n 93
9.9%
e 93
9.9%
x 93
9.9%
t 93
9.9%
9 74
 
7.9%
8 44
 
4.7%
1 25
 
2.7%
7 24
 
2.6%
Other values (6) 118
12.6%

비콘주소
Text

Distinct88
Distinct (%)94.6%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:39.685642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length36
Mean length33.311828
Min length27

Characters and Unicode

Total characters3098
Distinct characters188
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique83 ?
Unique (%)89.2%

Sample

1st row '경상남도 창원시 의창구 동읍 월잠리 303-2 습지문화실'
2nd row '경상남도 창원시 의창구 동읍 죽동리 508-8 환경스쿨사랑방'
3rd row '경상남도 창원시 의창구 대산면 가술리 550-81 쇠기러기'
4th row '경상남도 창원시 의창구 동읍 월잠리 309-10 철새관찰대'
5th row '경상남도 창원시 의창구 동읍 월잠리 306-12'
ValueCountFrequency (%)
의창구 93
15.4%
창원시 93
15.4%
경상남도 92
15.3%
동읍 68
11.3%
월잠리 49
 
8.1%
대산면 25
 
4.2%
가술리 25
 
4.2%
죽동리 15
 
2.5%
303-6 4
 
0.7%
석산리 3
 
0.5%
Other values (123) 135
22.4%
2023-12-12T19:47:40.258034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
602
19.4%
창 187
 
6.0%
' 186
 
6.0%
리 125
 
4.0%
구 98
 
3.2%
남 95
 
3.1%
경 94
 
3.0%
원 94
 
3.0%
의 93
 
3.0%
시 93
 
3.0%
Other values (178) 1431
46.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1818
58.7%
Space Separator 602
 
19.4%
Decimal Number 406
 
13.1%
Other Punctuation 186
 
6.0%
Dash Punctuation 86
 
2.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
창 187
 
10.3%
리 125
 
6.9%
구 98
 
5.4%
남 95
 
5.2%
경 94
 
5.2%
원 94
 
5.2%
의 93
 
5.1%
시 93
 
5.1%
도 93
 
5.1%
상 92
 
5.1%
Other values (165) 754
41.5%
Decimal Number
ValueCountFrequency (%)
0 59
14.5%
3 59
14.5%
5 55
13.5%
1 53
13.1%
4 40
9.9%
6 37
9.1%
8 29
7.1%
2 28
6.9%
9 28
6.9%
7 18
 
4.4%
Space Separator
ValueCountFrequency (%)
602
100.0%
Other Punctuation
ValueCountFrequency (%)
' 186
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 86
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1818
58.7%
Common 1280
41.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
창 187
 
10.3%
리 125
 
6.9%
구 98
 
5.4%
남 95
 
5.2%
경 94
 
5.2%
원 94
 
5.2%
의 93
 
5.1%
시 93
 
5.1%
도 93
 
5.1%
상 92
 
5.1%
Other values (165) 754
41.5%
Common
ValueCountFrequency (%)
602
47.0%
' 186
 
14.5%
- 86
 
6.7%
0 59
 
4.6%
3 59
 
4.6%
5 55
 
4.3%
1 53
 
4.1%
4 40
 
3.1%
6 37
 
2.9%
8 29
 
2.3%
Other values (3) 74
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1818
58.7%
ASCII 1280
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
602
47.0%
' 186
 
14.5%
- 86
 
6.7%
0 59
 
4.6%
3 59
 
4.6%
5 55
 
4.3%
1 53
 
4.1%
4 40
 
3.1%
6 37
 
2.9%
8 29
 
2.3%
Other values (3) 74
 
5.8%
Hangul
ValueCountFrequency (%)
창 187
 
10.3%
리 125
 
6.9%
구 98
 
5.4%
남 95
 
5.2%
경 94
 
5.2%
원 94
 
5.2%
의 93
 
5.1%
시 93
 
5.1%
도 93
 
5.1%
상 92
 
5.1%
Other values (165) 754
41.5%

장비이름
Text

UNIQUE 

Distinct93
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:40.670027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length8.0215054
Min length8

Characters and Unicode

Total characters746
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique93 ?
Unique (%)100.0%

Sample

1st row '60198'
2nd row '60451'
3rd row '61598'
4th row '60604'
5th row '61503'
ValueCountFrequency (%)
60198 1
 
1.1%
61321 1
 
1.1%
61843 1
 
1.1%
62006 1
 
1.1%
62020 1
 
1.1%
62031 1
 
1.1%
62016 1
 
1.1%
61394 1
 
1.1%
62024 1
 
1.1%
62002 1
 
1.1%
Other values (83) 83
89.2%
2023-12-12T19:47:41.281387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
' 186
24.9%
6 110
14.7%
93
12.5%
0 80
10.7%
1 63
 
8.4%
2 58
 
7.8%
8 39
 
5.2%
9 28
 
3.8%
4 27
 
3.6%
3 22
 
2.9%
Other values (2) 40
 
5.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 467
62.6%
Other Punctuation 186
 
24.9%
Space Separator 93
 
12.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 110
23.6%
0 80
17.1%
1 63
13.5%
2 58
12.4%
8 39
 
8.4%
9 28
 
6.0%
4 27
 
5.8%
3 22
 
4.7%
7 22
 
4.7%
5 18
 
3.9%
Other Punctuation
ValueCountFrequency (%)
' 186
100.0%
Space Separator
ValueCountFrequency (%)
93
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 746
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
' 186
24.9%
6 110
14.7%
93
12.5%
0 80
10.7%
1 63
 
8.4%
2 58
 
7.8%
8 39
 
5.2%
9 28
 
3.8%
4 27
 
3.6%
3 22
 
2.9%
Other values (2) 40
 
5.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 746
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
' 186
24.9%
6 110
14.7%
93
12.5%
0 80
10.7%
1 63
 
8.4%
2 58
 
7.8%
8 39
 
5.2%
9 28
 
3.8%
4 27
 
3.6%
3 22
 
2.9%
Other values (2) 40
 
5.4%

유유아이디
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size876.0 B
'E2C56DB5-DFFB-48D2-B060-D0F5A71096E0'
93 

Length

Max length39
Median length39
Mean length39
Min length39

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row 'E2C56DB5-DFFB-48D2-B060-D0F5A71096E0'
2nd row 'E2C56DB5-DFFB-48D2-B060-D0F5A71096E0'
3rd row 'E2C56DB5-DFFB-48D2-B060-D0F5A71096E0'
4th row 'E2C56DB5-DFFB-48D2-B060-D0F5A71096E0'
5th row 'E2C56DB5-DFFB-48D2-B060-D0F5A71096E0'

Common Values

ValueCountFrequency (%)
'E2C56DB5-DFFB-48D2-B060-D0F5A71096E0' 93
100.0%

Length

2023-12-12T19:47:41.461741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:47:41.582290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
e2c56db5-dffb-48d2-b060-d0f5a71096e0 93
100.0%

매이저
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size876.0 B
'60000'
91 
'1001'
 
1
'10'
 
1

Length

Max length8
Median length8
Mean length7.9569892
Min length5

Unique

Unique2 ?
Unique (%)2.2%

Sample

1st row '60000'
2nd row '60000'
3rd row '60000'
4th row '60000'
5th row '60000'

Common Values

ValueCountFrequency (%)
'60000' 91
97.8%
'1001' 1
 
1.1%
'10' 1
 
1.1%

Length

2023-12-12T19:47:41.719196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:47:41.836411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
60000 91
97.8%
1001 1
 
1.1%
10 1
 
1.1%

마이너
Text

UNIQUE 

Distinct93
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:42.191902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length6.7096774
Min length6

Characters and Unicode

Total characters624
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique93 ?
Unique (%)100.0%

Sample

1st row '198'
2nd row '451'
3rd row '1598'
4th row '604'
5th row '1503'
ValueCountFrequency (%)
198 1
 
1.1%
1321 1
 
1.1%
1843 1
 
1.1%
2006 1
 
1.1%
2020 1
 
1.1%
2031 1
 
1.1%
2016 1
 
1.1%
1394 1
 
1.1%
2024 1
 
1.1%
2002 1
 
1.1%
Other values (83) 83
89.2%
2023-12-12T19:47:42.799147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
' 186
29.8%
93
14.9%
1 60
 
9.6%
2 58
 
9.3%
0 52
 
8.3%
8 38
 
6.1%
9 27
 
4.3%
4 27
 
4.3%
3 23
 
3.7%
7 21
 
3.4%
Other values (2) 39
 
6.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 345
55.3%
Other Punctuation 186
29.8%
Space Separator 93
 
14.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 60
17.4%
2 58
16.8%
0 52
15.1%
8 38
11.0%
9 27
7.8%
4 27
7.8%
3 23
 
6.7%
7 21
 
6.1%
6 20
 
5.8%
5 19
 
5.5%
Other Punctuation
ValueCountFrequency (%)
' 186
100.0%
Space Separator
ValueCountFrequency (%)
93
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 624
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
' 186
29.8%
93
14.9%
1 60
 
9.6%
2 58
 
9.3%
0 52
 
8.3%
8 38
 
6.1%
9 27
 
4.3%
4 27
 
4.3%
3 23
 
3.7%
7 21
 
3.4%
Other values (2) 39
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 624
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
' 186
29.8%
93
14.9%
1 60
 
9.6%
2 58
 
9.3%
0 52
 
8.3%
8 38
 
6.1%
9 27
 
4.3%
4 27
 
4.3%
3 23
 
3.7%
7 21
 
3.4%
Other values (2) 39
 
6.2%

위도
Text

Distinct86
Distinct (%)92.5%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:43.174853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

Total characters1023
Distinct characters13
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique79 ?
Unique (%)84.9%

Sample

1st row '35.30723'
2nd row '35.33089'
3rd row '35.31506'
4th row '35.31088'
5th row '35.30838'
ValueCountFrequency (%)
35.32168 2
 
2.2%
35.30695 2
 
2.2%
35.30676 2
 
2.2%
35.30772 2
 
2.2%
35.31054 2
 
2.2%
35.32000 2
 
2.2%
35.31596 2
 
2.2%
35.32473 1
 
1.1%
35.32034 1
 
1.1%
35.30992 1
 
1.1%
Other values (76) 76
81.7%
2023-12-12T19:47:43.712027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 207
20.2%
' 186
18.2%
5 120
11.7%
93
9.1%
. 93
9.1%
1 69
 
6.7%
0 59
 
5.8%
2 51
 
5.0%
6 35
 
3.4%
7 34
 
3.3%
Other values (3) 76
 
7.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 651
63.6%
Other Punctuation 279
27.3%
Space Separator 93
 
9.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 207
31.8%
5 120
18.4%
1 69
 
10.6%
0 59
 
9.1%
2 51
 
7.8%
6 35
 
5.4%
7 34
 
5.2%
8 31
 
4.8%
9 23
 
3.5%
4 22
 
3.4%
Other Punctuation
ValueCountFrequency (%)
' 186
66.7%
. 93
33.3%
Space Separator
ValueCountFrequency (%)
93
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1023
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 207
20.2%
' 186
18.2%
5 120
11.7%
93
9.1%
. 93
9.1%
1 69
 
6.7%
0 59
 
5.8%
2 51
 
5.0%
6 35
 
3.4%
7 34
 
3.3%
Other values (3) 76
 
7.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1023
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 207
20.2%
' 186
18.2%
5 120
11.7%
93
9.1%
. 93
9.1%
1 69
 
6.7%
0 59
 
5.8%
2 51
 
5.0%
6 35
 
3.4%
7 34
 
3.3%
Other values (3) 76
 
7.4%

경도
Text

Distinct86
Distinct (%)92.5%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:44.091027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.010753
Min length12

Characters and Unicode

Total characters1117
Distinct characters13
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique79 ?
Unique (%)84.9%

Sample

1st row '128.67802'
2nd row '128.67717'
3rd row '128.68517'
4th row '128.68005'
5th row '128.67785'
ValueCountFrequency (%)
128.67982 2
 
2.1%
128.67791 2
 
2.1%
128.67807 2
 
2.1%
128.67720 2
 
2.1%
128.67905 2
 
2.1%
128.68404 2
 
2.1%
128.67785 2
 
2.1%
128.68484 2
 
2.1%
128.67790 1
 
1.1%
1
 
1.1%
Other values (76) 76
80.9%
2023-12-12T19:47:44.665951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
' 186
16.7%
8 164
14.7%
1 119
10.7%
2 118
10.6%
6 108
9.7%
7 100
9.0%
94
8.4%
. 93
8.3%
9 35
 
3.1%
0 32
 
2.9%
Other values (3) 68
 
6.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 744
66.6%
Other Punctuation 279
 
25.0%
Space Separator 94
 
8.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 164
22.0%
1 119
16.0%
2 118
15.9%
6 108
14.5%
7 100
13.4%
9 35
 
4.7%
0 32
 
4.3%
4 29
 
3.9%
5 25
 
3.4%
3 14
 
1.9%
Other Punctuation
ValueCountFrequency (%)
' 186
66.7%
. 93
33.3%
Space Separator
ValueCountFrequency (%)
94
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1117
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
' 186
16.7%
8 164
14.7%
1 119
10.7%
2 118
10.6%
6 108
9.7%
7 100
9.0%
94
8.4%
. 93
8.3%
9 35
 
3.1%
0 32
 
2.9%
Other values (3) 68
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1117
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
' 186
16.7%
8 164
14.7%
1 119
10.7%
2 118
10.6%
6 108
9.7%
7 100
9.0%
94
8.4%
. 93
8.3%
9 35
 
3.1%
0 32
 
2.9%
Other values (3) 68
 
6.1%

팝업
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size876.0 B
'1'
90 
''
 
3

Length

Max length4
Median length4
Mean length3.9677419
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row '1'
2nd row '1'
3rd row '1'
4th row '1'
5th row '1'

Common Values

ValueCountFrequency (%)
'1' 90
96.8%
'' 3
 
3.2%

Length

2023-12-12T19:47:44.843740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:47:44.971514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 90
96.8%
3
 
3.2%

타입
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size876.0 B
'info_no'
70 
'view_no'
17 
''
 
4
'time_no'
 
1
'monument_no'
 
1

Length

Max length14
Median length10
Mean length9.7419355
Min length3

Unique

Unique2 ?
Unique (%)2.2%

Sample

1st row 'view_no'
2nd row 'view_no'
3rd row 'info_no'
4th row 'view_no'
5th row 'info_no'

Common Values

ValueCountFrequency (%)
'info_no' 70
75.3%
'view_no' 17
 
18.3%
'' 4
 
4.3%
'time_no' 1
 
1.1%
'monument_no' 1
 
1.1%

Length

2023-12-12T19:47:45.122519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:47:45.271101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
info_no 70
75.3%
view_no 17
 
18.3%
4
 
4.3%
time_no 1
 
1.1%
monument_no 1
 
1.1%

서브타입
Text

Distinct55
Distinct (%)59.1%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:45.513233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length4.6344086
Min length3

Characters and Unicode

Total characters431
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)35.5%

Sample

1st row '8'
2nd row '12'
3rd row '9'
4th row '4'
5th row '4'
ValueCountFrequency (%)
4 6
 
6.5%
8 5
 
5.4%
3 5
 
5.4%
4
 
4.3%
5 3
 
3.2%
77 3
 
3.2%
82 3
 
3.2%
80 3
 
3.2%
74 2
 
2.2%
10 2
 
2.2%
Other values (45) 57
61.3%
2023-12-12T19:47:46.002873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
' 186
43.2%
93
21.6%
8 22
 
5.1%
1 21
 
4.9%
7 20
 
4.6%
4 19
 
4.4%
3 15
 
3.5%
2 15
 
3.5%
5 10
 
2.3%
0 10
 
2.3%
Other values (2) 20
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Other Punctuation 186
43.2%
Decimal Number 152
35.3%
Space Separator 93
21.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 22
14.5%
1 21
13.8%
7 20
13.2%
4 19
12.5%
3 15
9.9%
2 15
9.9%
5 10
6.6%
0 10
6.6%
6 10
6.6%
9 10
6.6%
Other Punctuation
ValueCountFrequency (%)
' 186
100.0%
Space Separator
ValueCountFrequency (%)
93
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 431
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
' 186
43.2%
93
21.6%
8 22
 
5.1%
1 21
 
4.9%
7 20
 
4.6%
4 19
 
4.4%
3 15
 
3.5%
2 15
 
3.5%
5 10
 
2.3%
0 10
 
2.3%
Other values (2) 20
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 431
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
' 186
43.2%
93
21.6%
8 22
 
5.1%
1 21
 
4.9%
7 20
 
4.6%
4 19
 
4.4%
3 15
 
3.5%
2 15
 
3.5%
5 10
 
2.3%
0 10
 
2.3%
Other values (2) 20
 
4.6%

사진
Categorical

IMBALANCE 

Distinct6
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Memory size876.0 B
''
88 
'4'
 
1
'5'
 
1
'3'
 
1
'2'
 
1

Length

Max length4
Median length3
Mean length3.0537634
Min length3

Unique

Unique5 ?
Unique (%)5.4%

Sample

1st row ''
2nd row ''
3rd row ''
4th row ''
5th row ''

Common Values

ValueCountFrequency (%)
'' 88
94.6%
'4' 1
 
1.1%
'5' 1
 
1.1%
'3' 1
 
1.1%
'2' 1
 
1.1%
'1' 1
 
1.1%

Length

2023-12-12T19:47:46.180338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:47:46.315437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
88
94.6%
4 1
 
1.1%
5 1
 
1.1%
3 1
 
1.1%
2 1
 
1.1%
1 1
 
1.1%

스탬프
Categorical

IMBALANCE 

Distinct12
Distinct (%)12.9%
Missing0
Missing (%)0.0%
Memory size876.0 B
''
80 
'7'
 
2
'3'
 
2
'8'
 
1
'4'
 
1
Other values (7)
 
7

Length

Max length5
Median length3
Mean length3.1612903
Min length3

Unique

Unique9 ?
Unique (%)9.7%

Sample

1st row ''
2nd row ''
3rd row ''
4th row ''
5th row ''

Common Values

ValueCountFrequency (%)
'' 80
86.0%
'7' 2
 
2.2%
'3' 2
 
2.2%
'8' 1
 
1.1%
'4' 1
 
1.1%
'6' 1
 
1.1%
'9' 1
 
1.1%
'5' 1
 
1.1%
'10' 1
 
1.1%
'1' 1
 
1.1%
Other values (2) 2
 
2.2%

Length

2023-12-12T19:47:46.502297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
80
86.0%
7 2
 
2.2%
3 2
 
2.2%
8 1
 
1.1%
4 1
 
1.1%
6 1
 
1.1%
9 1
 
1.1%
5 1
 
1.1%
10 1
 
1.1%
1 1
 
1.1%
Other values (2) 2
 
2.2%

생성일
Date

Distinct6
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Memory size876.0 B
Minimum2016-10-02 12:00:00
Maximum2016-12-05 10:10:00
2023-12-12T19:47:46.658736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:47:46.780928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)

수정일
Text

Distinct91
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size876.0 B
2023-12-12T19:47:47.070251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length23.010753
Min length23

Characters and Unicode

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

Unique

Unique90 ?
Unique (%)96.8%

Sample

1st row '2016-12-04 11:52:12')
2nd row '2016-12-04 11:55:46')
3rd row '2016-12-28 11:23:29')
4th row '2016-12-04 11:55:11')
5th row '2016-12-28 11:12:01')
ValueCountFrequency (%)
2016-12-28 64
34.4%
2016-12-04 14
 
7.5%
2016-11-04 7
 
3.8%
0000-00-00 3
 
1.6%
00:00:00 3
 
1.6%
2017-01-03 2
 
1.1%
2016-11-10 2
 
1.1%
11:34:47 1
 
0.5%
11:39:41 1
 
0.5%
11:23:03 1
 
0.5%
Other values (88) 88
47.3%
2023-12-12T19:47:47.608373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 413
19.3%
2 290
13.6%
0 212
9.9%
186
8.7%
' 186
8.7%
- 186
8.7%
: 186
8.7%
6 107
 
5.0%
) 93
 
4.3%
8 76
 
3.6%
Other values (6) 205
9.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1302
60.8%
Other Punctuation 373
 
17.4%
Space Separator 186
 
8.7%
Dash Punctuation 186
 
8.7%
Close Punctuation 93
 
4.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 413
31.7%
2 290
22.3%
0 212
16.3%
6 107
 
8.2%
8 76
 
5.8%
4 65
 
5.0%
3 57
 
4.4%
5 49
 
3.8%
9 17
 
1.3%
7 16
 
1.2%
Other Punctuation
ValueCountFrequency (%)
' 186
49.9%
: 186
49.9%
; 1
 
0.3%
Space Separator
ValueCountFrequency (%)
186
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 186
100.0%
Close Punctuation
ValueCountFrequency (%)
) 93
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2140
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 413
19.3%
2 290
13.6%
0 212
9.9%
186
8.7%
' 186
8.7%
- 186
8.7%
: 186
8.7%
6 107
 
5.0%
) 93
 
4.3%
8 76
 
3.6%
Other values (6) 205
9.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2140
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 413
19.3%
2 290
13.6%
0 212
9.9%
186
8.7%
' 186
8.7%
- 186
8.7%
: 186
8.7%
6 107
 
5.0%
) 93
 
4.3%
8 76
 
3.6%
Other values (6) 205
9.6%

Correlations

2023-12-12T19:47:47.750930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
맥어드레스비콘주소장비이름매이저마이너위도경도팝업타입서브타입사진스탬프생성일수정일
맥어드레스1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
비콘주소1.0001.0001.0000.0001.0000.9980.9981.0001.0000.9931.0001.0000.0000.998
장비이름1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
매이저1.0000.0001.0001.0001.0000.0000.0000.0000.1070.0000.0000.0001.0000.000
마이너1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
위도1.0000.9981.0000.0001.0001.0001.0001.0000.9950.9641.0000.9520.0000.997
경도1.0000.9981.0000.0001.0001.0001.0001.0000.9850.9491.0000.9520.0000.997
팝업1.0001.0001.0000.0001.0001.0001.0001.0000.4390.0000.0000.0000.0001.000
타입1.0001.0001.0000.1071.0000.9950.9850.4391.0000.0000.0000.0000.0000.957
서브타입1.0000.9931.0000.0001.0000.9640.9490.0000.0001.0000.8800.0000.0000.992
사진1.0001.0001.0000.0001.0001.0001.0000.0000.0000.8801.0000.0000.0001.000
스탬프1.0001.0001.0000.0001.0000.9520.9520.0000.0000.0000.0001.0000.6360.540
생성일1.0000.0001.0001.0001.0000.0000.0000.0000.0000.0000.0000.6361.0000.000
수정일1.0000.9981.0000.0001.0000.9970.9971.0000.9570.9921.0000.5400.0001.000
2023-12-12T19:47:48.013130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
스탬프매이저타입사진팝업
스탬프1.0000.0000.0000.0000.000
매이저0.0001.0000.0760.0000.000
타입0.0000.0761.0000.0000.525
사진0.0000.0000.0001.0000.000
팝업0.0000.0000.5250.0001.000
2023-12-12T19:47:48.138741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
매이저팝업타입사진스탬프
매이저1.0000.0000.0760.0000.000
팝업0.0001.0000.5250.0000.000
타입0.0760.5251.0000.0000.000
사진0.0000.0000.0001.0000.000
스탬프0.0000.0000.0000.0001.000

Missing values

2023-12-12T19:47:37.652886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:47:38.259366image/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

맥어드레스비콘주소장비이름유유아이디매이저마이너위도경도팝업타입서브타입사진스탬프생성일수정일
0('next198''경상남도 창원시 의창구 동읍 월잠리 303-2 습지문화실''60198''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''198''35.30723''128.67802''1''view_no''8''''''2016-10-02 12:00:00''2016-12-04 11:52:12')
1('next451''경상남도 창원시 의창구 동읍 죽동리 508-8 환경스쿨사랑방''60451''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''451''35.33089''128.67717''1''view_no''12''''''2016-10-06 11:00:00''2016-12-04 11:55:46')
2('next477''경상남도 창원시 의창구 대산면 가술리 550-81 쇠기러기''61598''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''1598''35.31506''128.68517''1''info_no''9''''''2016-10-06 11:00:00''2016-12-28 11:23:29')
3('next604''경상남도 창원시 의창구 동읍 월잠리 309-10 철새관찰대''60604''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''604''35.31088''128.68005''1''view_no''4''''''2016-10-06 11:00:00''2016-12-04 11:55:11')
4('next772''경상남도 창원시 의창구 동읍 월잠리 306-12''61503''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''1503''35.30838''128.67785''1''info_no''4''''''2016-10-06 11:00:00''2016-12-28 11:12:01')
5('next786''경상남도 창원시 의창구 동읍 월잠리 304-31사마귀풀''61795''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''1651''35.30578''128.67789''1''info_no''68''''''2016-10-06 11:00:00''2017-01-03 22:59:44')
6('next820''창원시 의창구 동읍 월잠리 306-12 쇠물닭''61317''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''1317''35.30812''128.67747''1''info_no''76''4''''2016-10-06 11:00:00''2016-12-28 11:10:41')
7('next822''경상남도 창원시 의창구 동읍 월잠리 304-3쥐방울덩굴''60822''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''822''35.30717''128.67765''1''time_no''4''''''2016-10-06 11:00:00''2016-12-04 11:49:02')
8('next829''경상남도 창원시 의창구 대산면 가술리 588참개구리''60829''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''829''35.31895''128.67970''1''info_no''69''''''2016-10-06 11:00:00''2016-11-10 14:35:11')
9('next841''경상남도 창원시 의창구 동읍 월잠리 304-30사위질빵''61581''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''1553''35.30626''128.67778''1''info_no''70''''''2016-10-06 11:00:00''2017-01-03 23:00:04')
맥어드레스비콘주소장비이름유유아이디매이저마이너위도경도팝업타입서브타입사진스탬프생성일수정일
83('next958''경상남도 창원시 의창구 동읍 죽동리 535-21통발''62007''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''2007''35.32527''128.67506''1''info_no''82''''1''2016-10-06 11:00:00''2016-12-28 11:40:56')
84('next959''경상남도 창원시 의창구 동읍 죽동리 498-11생이가래''62014''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''2014''35.32389''128.67589''1''info_no''77''''2''2016-10-06 11:00:00''2016-12-28 11:38:49')
85('next960''경상남도 창원시 의창구 동읍 죽동리 535-21어리연''62027''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''2027''35.32507''128.67519''''info_no''71''''''2016-10-06 11:00:00''2016-12-28 11:40:32')
86('next997''경상남도 창원시 의창구 동읍 주남로 101번길 26''60997''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''997''35.30731''128.67794''''''''''''2016-10-06 11:00:00''2016-11-04 01:00:00')
87('next998''경상남도 창원시 의창구 동읍 석산리 17-7''60998''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''998''35.31983''128.67108''''''''''''2016-10-06 11:00:00''2016-11-04 01:01:00')
88('next861''경상남도 창원시 의창구 동읍 월잠리 302-11 람사르문화관2층''61424''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''1424''35.30676''128.67807''1''info_no''55'''NULL'2016-10-06 11:00:00''2016-12-28 11:16:04')
89('next1001968''경상남도 창원시 의창구 동읍 월잠리 303-6 람사르문화관정문''1001968''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''1001''968''35.30695''128.67791''1''view_no''2''''''2016-12-04 00:00:00''0000-00-00 00:00:00')
90('next10274''경상남도 창원시 의창구 동읍 월잠리 309-10 철새관찰대''10274''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''10''274''35.31083''128.68032''1''view_no''4''''''2016-12-04 10:00:00''0000-00-00 00:00:00')
91('next688''경상남도 창원시 의창구 동읍 죽동리 497-24꼬리명주나비''60688''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''688''35.32168''128.67720''1''info_no''80''''3''2016-12-05 10:00:00''0000-00-00 00:00:00')
92('next859''경상남도 창원시 의창구 대산면 가술리 569-10논병아리''60859''E2C56DB5-DFFB-48D2-B060-D0F5A71096E0''60000''859''35.31596''128.68404''1''info_no''8''''7''2016-12-05 10:10:00''2016-12-28 10:55:30');