Overview

Dataset statistics

Number of variables5
Number of observations1119
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory43.8 KiB
Average record size in memory40.1 B

Variable types

Text2
DateTime2
Categorical1

Dataset

Description제주특별자치도 제주시 관내 담배 소매인 지정 관련 현황 데이터를 제공합니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15021306/fileData.do

Alerts

상태 has constant value ""Constant
데이터기준일자 has constant value ""Constant

Reproduction

Analysis started2023-12-12 11:23:06.844992
Analysis finished2023-12-12 11:23:07.789731
Duration0.94 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

Distinct1115
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
2023-12-12T20:23:08.165810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18
Mean length9.0563003
Min length2

Characters and Unicode

Total characters10134
Distinct characters506
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1111 ?
Unique (%)99.3%

Sample

1st row세븐일레븐 제주곽지점
2nd row세븐일레븐 제주노형대박점
3rd row씨유제주용인아파트점
4th row은지로또방
5th row제주로컬푸드 연동점
ValueCountFrequency (%)
씨유 139
 
8.3%
세븐일레븐 128
 
7.6%
gs25 58
 
3.5%
지에스25 40
 
2.4%
주)코리아세븐 30
 
1.8%
주식회사 15
 
0.9%
레몬비 15
 
0.9%
제주 11
 
0.7%
편의점 7
 
0.4%
코리아세븐 5
 
0.3%
Other values (1163) 1232
73.3%
2023-12-12T20:23:08.945941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 769
 
7.6%
주 681
 
6.7%
제 609
 
6.0%
561
 
5.5%
븐 363
 
3.6%
유 288
 
2.8%
씨 269
 
2.7%
세 217
 
2.1%
2 208
 
2.1%
5 202
 
2.0%
Other values (496) 5967
58.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8625
85.1%
Space Separator 561
 
5.5%
Decimal Number 423
 
4.2%
Uppercase Letter 323
 
3.2%
Open Punctuation 87
 
0.9%
Close Punctuation 87
 
0.9%
Lowercase Letter 18
 
0.2%
Other Punctuation 7
 
0.1%
Dash Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 769
 
8.9%
주 681
 
7.9%
제 609
 
7.1%
븐 363
 
4.2%
유 288
 
3.3%
씨 269
 
3.1%
세 217
 
2.5%
일 198
 
2.3%
레 194
 
2.2%
마 152
 
1.8%
Other values (448) 4885
56.6%
Uppercase Letter
ValueCountFrequency (%)
S 136
42.1%
G 130
40.2%
C 10
 
3.1%
U 7
 
2.2%
L 4
 
1.2%
E 4
 
1.2%
R 4
 
1.2%
T 4
 
1.2%
N 4
 
1.2%
O 3
 
0.9%
Other values (11) 17
 
5.3%
Lowercase Letter
ValueCountFrequency (%)
e 7
38.9%
t 2
 
11.1%
u 1
 
5.6%
c 1
 
5.6%
o 1
 
5.6%
g 1
 
5.6%
n 1
 
5.6%
w 1
 
5.6%
i 1
 
5.6%
m 1
 
5.6%
Decimal Number
ValueCountFrequency (%)
2 208
49.2%
5 202
47.8%
1 3
 
0.7%
4 2
 
0.5%
8 2
 
0.5%
6 2
 
0.5%
3 2
 
0.5%
7 2
 
0.5%
Other Punctuation
ValueCountFrequency (%)
. 4
57.1%
& 1
 
14.3%
, 1
 
14.3%
· 1
 
14.3%
Space Separator
ValueCountFrequency (%)
561
100.0%
Open Punctuation
ValueCountFrequency (%)
( 87
100.0%
Close Punctuation
ValueCountFrequency (%)
) 87
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8625
85.1%
Common 1168
 
11.5%
Latin 341
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 769
 
8.9%
주 681
 
7.9%
제 609
 
7.1%
븐 363
 
4.2%
유 288
 
3.3%
씨 269
 
3.1%
세 217
 
2.5%
일 198
 
2.3%
레 194
 
2.2%
마 152
 
1.8%
Other values (448) 4885
56.6%
Latin
ValueCountFrequency (%)
S 136
39.9%
G 130
38.1%
C 10
 
2.9%
e 7
 
2.1%
U 7
 
2.1%
L 4
 
1.2%
E 4
 
1.2%
R 4
 
1.2%
T 4
 
1.2%
N 4
 
1.2%
Other values (22) 31
 
9.1%
Common
ValueCountFrequency (%)
561
48.0%
2 208
 
17.8%
5 202
 
17.3%
( 87
 
7.4%
) 87
 
7.4%
. 4
 
0.3%
- 3
 
0.3%
1 3
 
0.3%
4 2
 
0.2%
8 2
 
0.2%
Other values (6) 9
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8625
85.1%
ASCII 1508
 
14.9%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 769
 
8.9%
주 681
 
7.9%
제 609
 
7.1%
븐 363
 
4.2%
유 288
 
3.3%
씨 269
 
3.1%
세 217
 
2.5%
일 198
 
2.3%
레 194
 
2.2%
마 152
 
1.8%
Other values (448) 4885
56.6%
ASCII
ValueCountFrequency (%)
561
37.2%
2 208
 
13.8%
5 202
 
13.4%
S 136
 
9.0%
G 130
 
8.6%
( 87
 
5.8%
) 87
 
5.8%
C 10
 
0.7%
e 7
 
0.5%
U 7
 
0.5%
Other values (37) 73
 
4.8%
None
ValueCountFrequency (%)
· 1
100.0%

주소
Text

Distinct1110
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
2023-12-12T20:23:09.561624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length28
Mean length21.152815
Min length15

Characters and Unicode

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

Unique

Unique1103 ?
Unique (%)98.6%

Sample

1st row제주특별자치도 제주시 애월읍 일주서로 5989
2nd row제주특별자치도 제주시 다랑곶길 36
3rd row제주특별자치도 제주시 고마로14길 16
4th row제주특별자치도 제주시 화남로 53
5th row제주특별자치도 제주시 일주서로 7815
ValueCountFrequency (%)
제주특별자치도 1119
23.3%
제주시 1118
23.3%
애월읍 111
 
2.3%
한림읍 66
 
1.4%
조천읍 63
 
1.3%
구좌읍 43
 
0.9%
일주서로 36
 
0.8%
중앙로 32
 
0.7%
2 26
 
0.5%
일주동로 24
 
0.5%
Other values (976) 2159
45.0%
2023-12-12T20:23:10.508717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4170
17.6%
주 2307
 
9.7%
제 2246
 
9.5%
도 1176
 
5.0%
자 1133
 
4.8%
특 1119
 
4.7%
별 1119
 
4.7%
치 1119
 
4.7%
시 1118
 
4.7%
로 852
 
3.6%
Other values (169) 7311
30.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16131
68.1%
Space Separator 4170
 
17.6%
Decimal Number 3262
 
13.8%
Dash Punctuation 107
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 2307
14.3%
제 2246
13.9%
도 1176
 
7.3%
자 1133
 
7.0%
특 1119
 
6.9%
별 1119
 
6.9%
치 1119
 
6.9%
시 1118
 
6.9%
로 852
 
5.3%
길 429
 
2.7%
Other values (157) 3513
21.8%
Decimal Number
ValueCountFrequency (%)
1 675
20.7%
2 473
14.5%
3 335
10.3%
4 329
10.1%
5 286
8.8%
6 276
8.5%
7 270
 
8.3%
8 221
 
6.8%
0 215
 
6.6%
9 182
 
5.6%
Space Separator
ValueCountFrequency (%)
4170
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 107
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16131
68.1%
Common 7539
31.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 2307
14.3%
제 2246
13.9%
도 1176
 
7.3%
자 1133
 
7.0%
특 1119
 
6.9%
별 1119
 
6.9%
치 1119
 
6.9%
시 1118
 
6.9%
로 852
 
5.3%
길 429
 
2.7%
Other values (157) 3513
21.8%
Common
ValueCountFrequency (%)
4170
55.3%
1 675
 
9.0%
2 473
 
6.3%
3 335
 
4.4%
4 329
 
4.4%
5 286
 
3.8%
6 276
 
3.7%
7 270
 
3.6%
8 221
 
2.9%
0 215
 
2.9%
Other values (2) 289
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16131
68.1%
ASCII 7539
31.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4170
55.3%
1 675
 
9.0%
2 473
 
6.3%
3 335
 
4.4%
4 329
 
4.4%
5 286
 
3.8%
6 276
 
3.7%
7 270
 
3.6%
8 221
 
2.9%
0 215
 
2.9%
Other values (2) 289
 
3.8%
Hangul
ValueCountFrequency (%)
주 2307
14.3%
제 2246
13.9%
도 1176
 
7.3%
자 1133
 
7.0%
특 1119
 
6.9%
별 1119
 
6.9%
치 1119
 
6.9%
시 1118
 
6.9%
로 852
 
5.3%
길 429
 
2.7%
Other values (157) 3513
21.8%

허가일
Date

Distinct861
Distinct (%)76.9%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
Minimum2010-01-07 00:00:00
Maximum2020-06-29 00:00:00
2023-12-12T20:23:10.796591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:11.626487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
영업/정상
1119 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업/정상
2nd row영업/정상
3rd row영업/정상
4th row영업/정상
5th row영업/정상

Common Values

ValueCountFrequency (%)
영업/정상 1119
100.0%

Length

2023-12-12T20:23:11.863899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:23:11.995965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 1119
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
Minimum2020-07-01 00:00:00
Maximum2020-07-01 00:00:00
2023-12-12T20:23:12.103335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:12.248123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T20:23:07.544524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:23:07.717550image/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세븐일레븐 제주곽지점제주특별자치도 제주시 애월읍 일주서로 59892020-06-29영업/정상2020-07-01
1세븐일레븐 제주노형대박점제주특별자치도 제주시 다랑곶길 362020-06-26영업/정상2020-07-01
2씨유제주용인아파트점제주특별자치도 제주시 고마로14길 162020-06-25영업/정상2020-07-01
3은지로또방제주특별자치도 제주시 화남로 532020-06-25영업/정상2020-07-01
4제주로컬푸드 연동점제주특별자치도 제주시 일주서로 78152020-06-19영업/정상2020-07-01
5세븐일레븐이도동광양점제주특별자치도 제주시 동광로 512020-06-11영업/정상2020-07-01
6씨유 제주서해안로점제주특별자치도 제주시 서해안로 456-22020-06-11영업/정상2020-07-01
7세븐일레븐 제주라온프라이빗타운제주특별자치도 제주시 한림읍 금능남로 1272020-06-10영업/정상2020-07-01
8레몬비 곽지해변점제주특별자치도 제주시 애월읍 곽지9길 232020-06-08영업/정상2020-07-01
9제주도푸른밤제주특별자치도 제주시 애월읍 중산간서로 55852020-06-08영업/정상2020-07-01
업소명주소허가일상태데이터기준일자
1109(주)신세계푸드제주특별자치도 제주시 한라대학로 382010-03-04영업/정상2020-07-01
1110용호미니슈퍼제주특별자치도 제주시 구좌읍 김녕로1길 82010-03-03영업/정상2020-07-01
1111원낚시프라자제주특별자치도 제주시 구좌읍 김녕로6길 22010-03-03영업/정상2020-07-01
1112씨유제주서광점제주특별자치도 제주시 서광로 2382010-02-25영업/정상2020-07-01
1113GS25제주도청점제주특별자치도 제주시 신대로 632010-02-04영업/정상2020-07-01
1114유드림마트제주특별자치도 제주시 광평동로 632010-02-02영업/정상2020-07-01
1115열린마트제주특별자치도 제주시 신대로10길 442010-01-22영업/정상2020-07-01
1116삼이농약사제주특별자치도 제주시 일주동로 360-12010-01-21영업/정상2020-07-01
1117투다모아 물류센터제주특별자치도 제주시 구좌읍 세화8길 22010-01-12영업/정상2020-07-01
1118해태철물제주특별자치도 제주시 구좌읍 구좌로 722010-01-07영업/정상2020-07-01