Overview

Dataset statistics

Number of variables5
Number of observations486
Missing cells27
Missing cells (%)1.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.6 KiB
Average record size in memory41.3 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description전라북도 군산시 정상영업중인 담배소매인 지정현황입니다. (상호명칭, 업소 지번주소, 업소 도로명주소, 지정일자)
Author전라북도 군산시
URLhttps://www.data.go.kr/data/15021211/fileData.do

Alerts

업소지번주소 has 26 (5.3%) missing valuesMissing
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:18:38.560315
Analysis finished2023-12-12 10:18:39.508592
Duration0.95 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct486
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean243.5
Minimum1
Maximum486
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.4 KiB
2023-12-12T19:18:39.586143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile25.25
Q1122.25
median243.5
Q3364.75
95-th percentile461.75
Maximum486
Range485
Interquartile range (IQR)242.5

Descriptive statistics

Standard deviation140.44038
Coefficient of variation (CV)0.5767572
Kurtosis-1.2
Mean243.5
Median Absolute Deviation (MAD)121.5
Skewness0
Sum118341
Variance19723.5
MonotonicityStrictly increasing
2023-12-12T19:18:39.784456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
306 1
 
0.2%
334 1
 
0.2%
333 1
 
0.2%
332 1
 
0.2%
331 1
 
0.2%
330 1
 
0.2%
329 1
 
0.2%
328 1
 
0.2%
327 1
 
0.2%
Other values (476) 476
97.9%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
486 1
0.2%
485 1
0.2%
484 1
0.2%
483 1
0.2%
482 1
0.2%
481 1
0.2%
480 1
0.2%
479 1
0.2%
478 1
0.2%
477 1
0.2%

상호
Text

Distinct483
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size3.9 KiB
2023-12-12T19:18:40.077809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length15
Mean length9.244856
Min length1

Characters and Unicode

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

Unique

Unique480 ?
Unique (%)98.8%

Sample

1st row신우마트
2nd row세븐일레븐 군산우체통거리점
3rd row유한회사 케이앤에이치(K&H)
4th row동군산농협 하나로마트 로컬푸드직판장
5th row씨유 군산구암점
ValueCountFrequency (%)
세븐일레븐 42
 
5.7%
씨유 37
 
5.0%
이마트24 22
 
3.0%
지에스(gs)25 19
 
2.6%
gs25 16
 
2.2%
미니스톱 15
 
2.0%
지에스25 13
 
1.8%
유한회사 9
 
1.2%
주)코리아세븐 8
 
1.1%
지에스25(gs25 5
 
0.7%
Other values (512) 550
74.7%
2023-12-12T19:18:40.581799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
276
 
6.1%
250
 
5.6%
237
 
5.3%
215
 
4.8%
148
 
3.3%
144
 
3.2%
2 122
 
2.7%
109
 
2.4%
107
 
2.4%
5 88
 
2.0%
Other values (356) 2797
62.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3669
81.7%
Space Separator 250
 
5.6%
Decimal Number 247
 
5.5%
Uppercase Letter 148
 
3.3%
Close Punctuation 85
 
1.9%
Open Punctuation 84
 
1.9%
Lowercase Letter 6
 
0.1%
Other Punctuation 3
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
276
 
7.5%
237
 
6.5%
215
 
5.9%
148
 
4.0%
144
 
3.9%
109
 
3.0%
107
 
2.9%
87
 
2.4%
78
 
2.1%
65
 
1.8%
Other values (322) 2203
60.0%
Uppercase Letter
ValueCountFrequency (%)
S 59
39.9%
G 58
39.2%
K 6
 
4.1%
C 5
 
3.4%
U 4
 
2.7%
R 3
 
2.0%
N 2
 
1.4%
E 2
 
1.4%
L 2
 
1.4%
F 1
 
0.7%
Other values (6) 6
 
4.1%
Decimal Number
ValueCountFrequency (%)
2 122
49.4%
5 88
35.6%
4 31
 
12.6%
1 3
 
1.2%
9 1
 
0.4%
6 1
 
0.4%
3 1
 
0.4%
Lowercase Letter
ValueCountFrequency (%)
e 2
33.3%
i 1
16.7%
h 1
16.7%
f 1
16.7%
l 1
16.7%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
. 1
33.3%
Space Separator
ValueCountFrequency (%)
250
100.0%
Close Punctuation
ValueCountFrequency (%)
) 85
100.0%
Open Punctuation
ValueCountFrequency (%)
( 84
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3669
81.7%
Common 670
 
14.9%
Latin 154
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
276
 
7.5%
237
 
6.5%
215
 
5.9%
148
 
4.0%
144
 
3.9%
109
 
3.0%
107
 
2.9%
87
 
2.4%
78
 
2.1%
65
 
1.8%
Other values (322) 2203
60.0%
Latin
ValueCountFrequency (%)
S 59
38.3%
G 58
37.7%
K 6
 
3.9%
C 5
 
3.2%
U 4
 
2.6%
R 3
 
1.9%
N 2
 
1.3%
E 2
 
1.3%
e 2
 
1.3%
L 2
 
1.3%
Other values (11) 11
 
7.1%
Common
ValueCountFrequency (%)
250
37.3%
2 122
18.2%
5 88
 
13.1%
) 85
 
12.7%
( 84
 
12.5%
4 31
 
4.6%
1 3
 
0.4%
& 2
 
0.3%
. 1
 
0.1%
9 1
 
0.1%
Other values (3) 3
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3669
81.7%
ASCII 824
 
18.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
276
 
7.5%
237
 
6.5%
215
 
5.9%
148
 
4.0%
144
 
3.9%
109
 
3.0%
107
 
2.9%
87
 
2.4%
78
 
2.1%
65
 
1.8%
Other values (322) 2203
60.0%
ASCII
ValueCountFrequency (%)
250
30.3%
2 122
14.8%
5 88
 
10.7%
) 85
 
10.3%
( 84
 
10.2%
S 59
 
7.2%
G 58
 
7.0%
4 31
 
3.8%
K 6
 
0.7%
C 5
 
0.6%
Other values (24) 36
 
4.4%

업소지번주소
Text

MISSING 

Distinct455
Distinct (%)98.9%
Missing26
Missing (%)5.3%
Memory size3.9 KiB
2023-12-12T19:18:40.921681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length40
Mean length22.793478
Min length15

Characters and Unicode

Total characters10485
Distinct characters294
Distinct categories10 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique451 ?
Unique (%)98.0%

Sample

1st row전라북도 군산시 산북동 3616 부향하나로1차아파트
2nd row전라북도 군산시 신창동 18-1
3rd row전라북도 군산시 중앙로2가 12-4
4th row전라북도 군산시 구암동 130-1
5th row전라북도 군산시 구암동 333-1 세풍아파트
ValueCountFrequency (%)
전라북도 460
19.8%
군산시 460
19.8%
나운동 63
 
2.7%
수송동 41
 
1.8%
오식도동 40
 
1.7%
1호 35
 
1.5%
소룡동 32
 
1.4%
조촌동 29
 
1.2%
산북동 23
 
1.0%
2호 22
 
0.9%
Other values (684) 1124
48.3%
2023-12-12T19:18:41.383410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1869
17.8%
549
 
5.2%
523
 
5.0%
488
 
4.7%
476
 
4.5%
474
 
4.5%
464
 
4.4%
461
 
4.4%
418
 
4.0%
1 410
 
3.9%
Other values (284) 4353
41.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6408
61.1%
Decimal Number 1985
 
18.9%
Space Separator 1869
 
17.8%
Dash Punctuation 152
 
1.4%
Uppercase Letter 29
 
0.3%
Other Punctuation 17
 
0.2%
Lowercase Letter 16
 
0.2%
Open Punctuation 4
 
< 0.1%
Close Punctuation 4
 
< 0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
549
 
8.6%
523
 
8.2%
488
 
7.6%
476
 
7.4%
474
 
7.4%
464
 
7.2%
461
 
7.2%
418
 
6.5%
303
 
4.7%
275
 
4.3%
Other values (242) 1977
30.9%
Uppercase Letter
ValueCountFrequency (%)
S 4
13.8%
C 3
10.3%
K 3
10.3%
H 2
 
6.9%
O 2
 
6.9%
W 2
 
6.9%
B 2
 
6.9%
U 2
 
6.9%
G 2
 
6.9%
E 1
 
3.4%
Other values (6) 6
20.7%
Decimal Number
ValueCountFrequency (%)
1 410
20.7%
5 224
11.3%
3 216
10.9%
2 192
9.7%
6 174
8.8%
8 173
8.7%
4 160
 
8.1%
0 153
 
7.7%
7 144
 
7.3%
9 139
 
7.0%
Lowercase Letter
ValueCountFrequency (%)
a 3
18.8%
y 3
18.8%
e 2
12.5%
l 2
12.5%
h 1
 
6.2%
u 1
 
6.2%
t 1
 
6.2%
r 1
 
6.2%
i 1
 
6.2%
m 1
 
6.2%
Space Separator
ValueCountFrequency (%)
1869
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 152
100.0%
Other Punctuation
ValueCountFrequency (%)
, 17
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Other Symbol
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6407
61.1%
Common 4031
38.4%
Latin 45
 
0.4%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
549
 
8.6%
523
 
8.2%
488
 
7.6%
476
 
7.4%
474
 
7.4%
464
 
7.2%
461
 
7.2%
418
 
6.5%
303
 
4.7%
275
 
4.3%
Other values (241) 1976
30.8%
Latin
ValueCountFrequency (%)
S 4
 
8.9%
C 3
 
6.7%
K 3
 
6.7%
a 3
 
6.7%
y 3
 
6.7%
H 2
 
4.4%
O 2
 
4.4%
W 2
 
4.4%
e 2
 
4.4%
B 2
 
4.4%
Other values (16) 19
42.2%
Common
ValueCountFrequency (%)
1869
46.4%
1 410
 
10.2%
5 224
 
5.6%
3 216
 
5.4%
2 192
 
4.8%
6 174
 
4.3%
8 173
 
4.3%
4 160
 
4.0%
0 153
 
3.8%
- 152
 
3.8%
Other values (5) 308
 
7.6%
Han
ValueCountFrequency (%)
1
50.0%
1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6406
61.1%
ASCII 4076
38.9%
CJK 2
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1869
45.9%
1 410
 
10.1%
5 224
 
5.5%
3 216
 
5.3%
2 192
 
4.7%
6 174
 
4.3%
8 173
 
4.2%
4 160
 
3.9%
0 153
 
3.8%
- 152
 
3.7%
Other values (31) 353
 
8.7%
Hangul
ValueCountFrequency (%)
549
 
8.6%
523
 
8.2%
488
 
7.6%
476
 
7.4%
474
 
7.4%
464
 
7.2%
461
 
7.2%
418
 
6.5%
303
 
4.7%
275
 
4.3%
Other values (240) 1975
30.8%
None
ValueCountFrequency (%)
1
100.0%
CJK
ValueCountFrequency (%)
1
50.0%
1
50.0%
Distinct485
Distinct (%)100.0%
Missing1
Missing (%)0.2%
Memory size3.9 KiB
2023-12-12T19:18:41.831689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length61
Median length52
Mean length27.552577
Min length18

Characters and Unicode

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

Unique

Unique485 ?
Unique (%)100.0%

Sample

1st row전라북도 군산시 동아로 12, 상가동 (산북동, 부향하나로1차아파트)
2nd row전라북도 군산시 우체통거리2길 35(신창동)
3rd row전라북도 군산시 싸전길 2, 1층 (중앙로2가)
4th row전라북도 군산시 구암로 110(구암동)
5th row전라북도 군산시 구암3.1로 219, 101,102-2,103-2호 (구암동)
ValueCountFrequency (%)
전라북도 485
 
16.9%
군산시 485
 
16.9%
1층 121
 
4.2%
나운동 68
 
2.4%
101호 45
 
1.6%
오식도동 35
 
1.2%
수송동 34
 
1.2%
소룡동 31
 
1.1%
조촌동 28
 
1.0%
상가동 24
 
0.8%
Other values (729) 1510
52.7%
2023-12-12T19:18:42.490715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2381
 
17.8%
1 699
 
5.2%
574
 
4.3%
560
 
4.2%
531
 
4.0%
528
 
4.0%
505
 
3.8%
500
 
3.7%
490
 
3.7%
488
 
3.7%
Other values (255) 6107
45.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7583
56.7%
Space Separator 2381
 
17.8%
Decimal Number 2114
 
15.8%
Close Punctuation 430
 
3.2%
Open Punctuation 430
 
3.2%
Other Punctuation 368
 
2.8%
Dash Punctuation 50
 
0.4%
Uppercase Letter 4
 
< 0.1%
Lowercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
574
 
7.6%
560
 
7.4%
531
 
7.0%
528
 
7.0%
505
 
6.7%
500
 
6.6%
490
 
6.5%
488
 
6.4%
297
 
3.9%
199
 
2.6%
Other values (233) 2911
38.4%
Decimal Number
ValueCountFrequency (%)
1 699
33.1%
2 310
14.7%
0 264
 
12.5%
3 208
 
9.8%
4 142
 
6.7%
5 126
 
6.0%
6 100
 
4.7%
9 100
 
4.7%
8 89
 
4.2%
7 76
 
3.6%
Uppercase Letter
ValueCountFrequency (%)
B 1
25.0%
E 1
25.0%
A 1
25.0%
G 1
25.0%
Other Punctuation
ValueCountFrequency (%)
, 362
98.4%
. 6
 
1.6%
Lowercase Letter
ValueCountFrequency (%)
p 2
66.7%
e 1
33.3%
Space Separator
ValueCountFrequency (%)
2381
100.0%
Close Punctuation
ValueCountFrequency (%)
) 430
100.0%
Open Punctuation
ValueCountFrequency (%)
( 430
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7583
56.7%
Common 5773
43.2%
Latin 7
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
574
 
7.6%
560
 
7.4%
531
 
7.0%
528
 
7.0%
505
 
6.7%
500
 
6.6%
490
 
6.5%
488
 
6.4%
297
 
3.9%
199
 
2.6%
Other values (233) 2911
38.4%
Common
ValueCountFrequency (%)
2381
41.2%
1 699
 
12.1%
) 430
 
7.4%
( 430
 
7.4%
, 362
 
6.3%
2 310
 
5.4%
0 264
 
4.6%
3 208
 
3.6%
4 142
 
2.5%
5 126
 
2.2%
Other values (6) 421
 
7.3%
Latin
ValueCountFrequency (%)
p 2
28.6%
B 1
14.3%
E 1
14.3%
A 1
14.3%
G 1
14.3%
e 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7583
56.7%
ASCII 5780
43.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2381
41.2%
1 699
 
12.1%
) 430
 
7.4%
( 430
 
7.4%
, 362
 
6.3%
2 310
 
5.4%
0 264
 
4.6%
3 208
 
3.6%
4 142
 
2.5%
5 126
 
2.2%
Other values (12) 428
 
7.4%
Hangul
ValueCountFrequency (%)
574
 
7.6%
560
 
7.4%
531
 
7.0%
528
 
7.0%
505
 
6.7%
500
 
6.6%
490
 
6.5%
488
 
6.4%
297
 
3.9%
199
 
2.6%
Other values (233) 2911
38.4%
Distinct380
Distinct (%)78.2%
Missing0
Missing (%)0.0%
Memory size3.9 KiB
Minimum2015-01-02 00:00:00
Maximum2022-09-08 00:00:00
2023-12-12T19:18:42.734791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:18:43.232308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T19:18:39.132680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T19:18:39.263883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:18:39.366892image/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.
2023-12-12T19:18:39.459415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

번호상호업소지번주소업소도로명주소지정일자
01신우마트전라북도 군산시 산북동 3616 부향하나로1차아파트전라북도 군산시 동아로 12, 상가동 (산북동, 부향하나로1차아파트)2022-09-08
12세븐일레븐 군산우체통거리점전라북도 군산시 신창동 18-1전라북도 군산시 우체통거리2길 35(신창동)2022-09-07
23유한회사 케이앤에이치(K&H)전라북도 군산시 중앙로2가 12-4전라북도 군산시 싸전길 2, 1층 (중앙로2가)2022-09-07
34동군산농협 하나로마트 로컬푸드직판장전라북도 군산시 구암동 130-1전라북도 군산시 구암로 110(구암동)2022-08-31
45씨유 군산구암점전라북도 군산시 구암동 333-1 세풍아파트전라북도 군산시 구암3.1로 219, 101,102-2,103-2호 (구암동)2022-08-26
56씨유 군산프리미엄점전라북도 군산시 나운동 100-7전라북도 군산시 나운안1길 1, 1층 101호 (나운동)2022-08-17
67세븐일레븐 군산나운한밭점전라북도 군산시 나운동 1187-20전라북도 군산시 대학로 367, 1층 101호 (나운동)2022-08-17
78이마트24군산시립도서관점전라북도 군산시 나운동 1536-7전라북도 군산시 서수송안1길 12, 1층 (나운동)2022-08-16
89찬스복권방(동행복권)전라북도 군산시 장재동 212 현대세솔아파트전라북도 군산시 동팔마길 53, 현대세솔아파트 101동 제에스-119호 (장재동)2022-08-08
910세븐일레븐 군산해양수산청점전라북도 군산시 소룡동 1530-1전라북도 군산시 설림5길 52(소룡동)2022-08-03
번호상호업소지번주소업소도로명주소지정일자
476477코사마트전라북도 군산시 금동 35번지 7호전라북도 군산시 중앙로 219 (금동)2015-02-11
477478순금나라 군산점<NA>전라북도 군산시 문화로 17 (문화동)2015-01-28
478479케이원낚시전라북도 군산시 오식도동 1003번지전라북도 군산시 새만금북로 281, 1층 (오식도동)2015-01-27
479480레드정보통신전라북도 군산시 명산동 2번지 14호전라북도 군산시 대학로 49 (명산동)2015-01-26
480481럭셔리전자담배<NA>전라북도 군산시 월명로 353 (서흥남동)2015-01-15
481482전자담배<NA>전라북도 군산시 공단대로 429 (나운동)2015-01-13
482483천냥시대<NA>전라북도 군산시 대학로 65 (명산동)2015-01-08
483484라미야<NA>전라북도 군산시 중앙로 43 (대명동)2015-01-05
484485씨가앤슈가<NA>전라북도 군산시 축동2길 40-6 (수송동)2015-01-05
485486전자담배멀티샵<NA>전라북도 군산시 백릉로 53 (경암동)2015-01-02