Overview

Dataset statistics

Number of variables6
Number of observations1824
Missing cells16
Missing cells (%)0.1%
Duplicate rows2
Duplicate rows (%)0.1%
Total size in memory85.6 KiB
Average record size in memory48.1 B

Variable types

Categorical1
Text3
DateTime2

Dataset

Description충청북도 충주시 소재 담배소매업 지정현황(민원구분, 업소명, 업소지번주소, 업소도로명주소, 지정일자 등)을 제공
Author충청북도 충주시
URLhttps://www.data.go.kr/data/15035638/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 2 (0.1%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 11:22:29.267209
Analysis finished2023-12-12 11:22:30.431294
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

민원구분
Categorical

Distinct6
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
일반소매인
1001 
제7조의3제2항에따른경우
632 
구내소매인
143 
제7조의3제3항에따른경우
 
36
임시소매인
 
10

Length

Max length13
Median length5
Mean length7.9298246
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제7조의3제3항에따른경우
2nd row제7조의3제2항에따른경우
3rd row제7조의3제2항에따른경우
4th row제7조의3제2항에따른경우
5th row제7조의3제2항에따른경우

Common Values

ValueCountFrequency (%)
일반소매인 1001
54.9%
제7조의3제2항에따른경우 632
34.6%
구내소매인 143
 
7.8%
제7조의3제3항에따른경우 36
 
2.0%
임시소매인 10
 
0.5%
자동판매기 2
 
0.1%

Length

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

Common Values (Plot)

2023-12-12T20:22:30.721752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반소매인 1001
54.9%
제7조의3제2항에따른경우 632
34.6%
구내소매인 143
 
7.8%
제7조의3제3항에따른경우 36
 
2.0%
임시소매인 10
 
0.5%
자동판매기 2
 
0.1%
Distinct1556
Distinct (%)85.3%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
2023-12-12T20:22:31.212692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length20
Mean length6.3070175
Min length2

Characters and Unicode

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

Unique

Unique1459 ?
Unique (%)80.0%

Sample

1st row해동상회
2nd row푸디스트 주식회사
3rd row지에스25 충주중앙대로점
4th row봉방아이스크림
5th row안녕식품
ValueCountFrequency (%)
잡화 96
 
4.4%
세븐일레븐 53
 
2.4%
씨유 43
 
2.0%
이마트24 23
 
1.1%
식품 20
 
0.9%
식품점 17
 
0.8%
지에스25 14
 
0.6%
지에스(gs)25 14
 
0.6%
마을구판장 13
 
0.6%
구판장 13
 
0.6%
Other values (1646) 1866
85.9%
2023-12-12T20:22:31.887495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
521
 
4.5%
453
 
3.9%
372
 
3.2%
349
 
3.0%
314
 
2.7%
301
 
2.6%
257
 
2.2%
203
 
1.8%
161
 
1.4%
153
 
1.3%
Other values (567) 8420
73.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10285
89.4%
Space Separator 349
 
3.0%
Decimal Number 347
 
3.0%
Uppercase Letter 263
 
2.3%
Close Punctuation 111
 
1.0%
Open Punctuation 109
 
0.9%
Lowercase Letter 15
 
0.1%
Other Punctuation 13
 
0.1%
Dash Punctuation 9
 
0.1%
Other Symbol 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
521
 
5.1%
453
 
4.4%
372
 
3.6%
314
 
3.1%
301
 
2.9%
257
 
2.5%
203
 
2.0%
161
 
1.6%
153
 
1.5%
147
 
1.4%
Other values (513) 7403
72.0%
Uppercase Letter
ValueCountFrequency (%)
G 73
27.8%
S 64
24.3%
C 23
 
8.7%
L 21
 
8.0%
U 11
 
4.2%
O 9
 
3.4%
A 8
 
3.0%
K 6
 
2.3%
J 6
 
2.3%
R 6
 
2.3%
Other values (14) 36
13.7%
Lowercase Letter
ValueCountFrequency (%)
c 2
13.3%
a 2
13.3%
t 2
13.3%
d 2
13.3%
n 1
6.7%
r 1
6.7%
k 1
6.7%
f 1
6.7%
l 1
6.7%
s 1
6.7%
Decimal Number
ValueCountFrequency (%)
2 151
43.5%
5 95
27.4%
4 49
 
14.1%
1 19
 
5.5%
0 8
 
2.3%
7 7
 
2.0%
8 6
 
1.7%
3 6
 
1.7%
9 4
 
1.2%
6 2
 
0.6%
Other Punctuation
ValueCountFrequency (%)
. 8
61.5%
& 3
 
23.1%
/ 1
 
7.7%
· 1
 
7.7%
Space Separator
ValueCountFrequency (%)
349
100.0%
Close Punctuation
ValueCountFrequency (%)
) 111
100.0%
Open Punctuation
ValueCountFrequency (%)
( 109
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Symbol
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10288
89.4%
Common 938
 
8.2%
Latin 278
 
2.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
521
 
5.1%
453
 
4.4%
372
 
3.6%
314
 
3.1%
301
 
2.9%
257
 
2.5%
203
 
2.0%
161
 
1.6%
153
 
1.5%
147
 
1.4%
Other values (514) 7406
72.0%
Latin
ValueCountFrequency (%)
G 73
26.3%
S 64
23.0%
C 23
 
8.3%
L 21
 
7.6%
U 11
 
4.0%
O 9
 
3.2%
A 8
 
2.9%
K 6
 
2.2%
J 6
 
2.2%
R 6
 
2.2%
Other values (25) 51
18.3%
Common
ValueCountFrequency (%)
349
37.2%
2 151
16.1%
) 111
 
11.8%
( 109
 
11.6%
5 95
 
10.1%
4 49
 
5.2%
1 19
 
2.0%
- 9
 
1.0%
. 8
 
0.9%
0 8
 
0.9%
Other values (8) 30
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10285
89.4%
ASCII 1215
 
10.6%
None 4
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
521
 
5.1%
453
 
4.4%
372
 
3.6%
314
 
3.1%
301
 
2.9%
257
 
2.5%
203
 
2.0%
161
 
1.6%
153
 
1.5%
147
 
1.4%
Other values (513) 7403
72.0%
ASCII
ValueCountFrequency (%)
349
28.7%
2 151
12.4%
) 111
 
9.1%
( 109
 
9.0%
5 95
 
7.8%
G 73
 
6.0%
S 64
 
5.3%
4 49
 
4.0%
C 23
 
1.9%
L 21
 
1.7%
Other values (42) 170
14.0%
None
ValueCountFrequency (%)
3
75.0%
· 1
 
25.0%
Distinct1574
Distinct (%)86.3%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
2023-12-12T20:22:32.421158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length39
Mean length21.454496
Min length1

Characters and Unicode

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

Unique

Unique1523 ?
Unique (%)83.5%

Sample

1st row충청북도 충주시 목행동 611-3
2nd row충청북도 충주시 수안보면 온천리 755-12 한화손해보험 수안보 연수원
3rd row충청북도 충주시 중앙탑면 루암리 210-25
4th row충청북도 충주시 문화동 397
5th row충청북도 충주시 봉방동 65-3
ValueCountFrequency (%)
충청북도 1576
 
19.9%
충주시 1576
 
19.9%
연수동 146
 
1.8%
교현동 127
 
1.6%
문화동 117
 
1.5%
1호 108
 
1.4%
85
 
1.1%
봉방동 83
 
1.0%
대소원면 81
 
1.0%
용산동 77
 
1.0%
Other values (1828) 3962
49.9%
2023-12-12T20:22:33.243091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9787
25.0%
3229
 
8.3%
1690
 
4.3%
1597
 
4.1%
1593
 
4.1%
1592
 
4.1%
1576
 
4.0%
1 1403
 
3.6%
1358
 
3.5%
1219
 
3.1%
Other values (281) 14089
36.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 22722
58.1%
Space Separator 9787
25.0%
Decimal Number 6300
 
16.1%
Dash Punctuation 210
 
0.5%
Uppercase Letter 60
 
0.2%
Other Punctuation 31
 
0.1%
Close Punctuation 8
 
< 0.1%
Open Punctuation 7
 
< 0.1%
Lowercase Letter 7
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
3229
14.2%
1690
 
7.4%
1597
 
7.0%
1593
 
7.0%
1592
 
7.0%
1576
 
6.9%
1358
 
6.0%
1219
 
5.4%
828
 
3.6%
799
 
3.5%
Other values (249) 7241
31.9%
Decimal Number
ValueCountFrequency (%)
1 1403
22.3%
2 819
13.0%
4 618
9.8%
3 592
9.4%
5 565
9.0%
6 528
 
8.4%
0 481
 
7.6%
7 468
 
7.4%
9 447
 
7.1%
8 379
 
6.0%
Uppercase Letter
ValueCountFrequency (%)
A 42
70.0%
S 4
 
6.7%
B 3
 
5.0%
K 2
 
3.3%
G 2
 
3.3%
H 2
 
3.3%
L 2
 
3.3%
T 1
 
1.7%
P 1
 
1.7%
J 1
 
1.7%
Lowercase Letter
ValueCountFrequency (%)
k 2
28.6%
e 2
28.6%
r 2
28.6%
a 1
14.3%
Other Punctuation
ValueCountFrequency (%)
. 26
83.9%
@ 5
 
16.1%
Close Punctuation
ValueCountFrequency (%)
) 7
87.5%
] 1
 
12.5%
Space Separator
ValueCountFrequency (%)
9787
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 210
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 22722
58.1%
Common 16344
41.8%
Latin 67
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
3229
14.2%
1690
 
7.4%
1597
 
7.0%
1593
 
7.0%
1592
 
7.0%
1576
 
6.9%
1358
 
6.0%
1219
 
5.4%
828
 
3.6%
799
 
3.5%
Other values (249) 7241
31.9%
Common
ValueCountFrequency (%)
9787
59.9%
1 1403
 
8.6%
2 819
 
5.0%
4 618
 
3.8%
3 592
 
3.6%
5 565
 
3.5%
6 528
 
3.2%
0 481
 
2.9%
7 468
 
2.9%
9 447
 
2.7%
Other values (8) 636
 
3.9%
Latin
ValueCountFrequency (%)
A 42
62.7%
S 4
 
6.0%
B 3
 
4.5%
K 2
 
3.0%
k 2
 
3.0%
e 2
 
3.0%
r 2
 
3.0%
G 2
 
3.0%
H 2
 
3.0%
L 2
 
3.0%
Other values (4) 4
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 22722
58.1%
ASCII 16411
41.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9787
59.6%
1 1403
 
8.5%
2 819
 
5.0%
4 618
 
3.8%
3 592
 
3.6%
5 565
 
3.4%
6 528
 
3.2%
0 481
 
2.9%
7 468
 
2.9%
9 447
 
2.7%
Other values (22) 703
 
4.3%
Hangul
ValueCountFrequency (%)
3229
14.2%
1690
 
7.4%
1597
 
7.0%
1593
 
7.0%
1592
 
7.0%
1576
 
6.9%
1358
 
6.0%
1219
 
5.4%
828
 
3.6%
799
 
3.5%
Other values (249) 7241
31.9%
Distinct1052
Distinct (%)57.7%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
2023-12-12T20:22:33.801049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length54
Mean length15.425987
Min length1

Characters and Unicode

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

Unique

Unique1005 ?
Unique (%)55.1%

Sample

1st row충청북도 충주시 행정9길 17. 목행동 611-4 (목행동)
2nd row충청북도 충주시 수안보면 온천천변길 61-6. 한화손해보험 수안보 연수원
3rd row충청북도 충주시 중앙탑면 탄금대로 664
4th row충청북도 충주시 중원대로 3460. 1층 (문화동)
5th row충청북도 충주시 탄금대로 77 (봉방동)
ValueCountFrequency (%)
충청북도 1101
 
18.6%
충주시 1101
 
18.6%
연수동 126
 
2.1%
문화동 104
 
1.8%
교현동 92
 
1.6%
1층 91
 
1.5%
봉방동 79
 
1.3%
용산동 67
 
1.1%
대소원면 57
 
1.0%
칠금동 56
 
0.9%
Other values (1109) 3061
51.6%
2023-12-12T20:22:34.583754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5939
21.1%
2298
 
8.2%
1181
 
4.2%
1133
 
4.0%
1130
 
4.0%
1122
 
4.0%
1 1112
 
4.0%
1107
 
3.9%
948
 
3.4%
) 838
 
3.0%
Other values (296) 11329
40.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16270
57.8%
Space Separator 5939
 
21.1%
Decimal Number 3792
 
13.5%
Close Punctuation 838
 
3.0%
Open Punctuation 838
 
3.0%
Other Punctuation 294
 
1.0%
Dash Punctuation 148
 
0.5%
Uppercase Letter 12
 
< 0.1%
Math Symbol 3
 
< 0.1%
Lowercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2298
 
14.1%
1181
 
7.3%
1133
 
7.0%
1130
 
6.9%
1122
 
6.9%
1107
 
6.8%
948
 
5.8%
570
 
3.5%
543
 
3.3%
271
 
1.7%
Other values (272) 5967
36.7%
Decimal Number
ValueCountFrequency (%)
1 1112
29.3%
2 560
14.8%
3 398
 
10.5%
4 325
 
8.6%
0 321
 
8.5%
5 267
 
7.0%
7 226
 
6.0%
6 225
 
5.9%
9 179
 
4.7%
8 179
 
4.7%
Uppercase Letter
ValueCountFrequency (%)
A 3
25.0%
S 3
25.0%
H 3
25.0%
L 2
16.7%
G 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
. 293
99.7%
@ 1
 
0.3%
Lowercase Letter
ValueCountFrequency (%)
e 2
66.7%
a 1
33.3%
Space Separator
ValueCountFrequency (%)
5939
100.0%
Close Punctuation
ValueCountFrequency (%)
) 838
100.0%
Open Punctuation
ValueCountFrequency (%)
( 838
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 148
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16270
57.8%
Common 11852
42.1%
Latin 15
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2298
 
14.1%
1181
 
7.3%
1133
 
7.0%
1130
 
6.9%
1122
 
6.9%
1107
 
6.8%
948
 
5.8%
570
 
3.5%
543
 
3.3%
271
 
1.7%
Other values (272) 5967
36.7%
Common
ValueCountFrequency (%)
5939
50.1%
1 1112
 
9.4%
) 838
 
7.1%
( 838
 
7.1%
2 560
 
4.7%
3 398
 
3.4%
4 325
 
2.7%
0 321
 
2.7%
. 293
 
2.5%
5 267
 
2.3%
Other values (7) 961
 
8.1%
Latin
ValueCountFrequency (%)
A 3
20.0%
S 3
20.0%
H 3
20.0%
e 2
13.3%
L 2
13.3%
G 1
 
6.7%
a 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16270
57.8%
ASCII 11867
42.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5939
50.0%
1 1112
 
9.4%
) 838
 
7.1%
( 838
 
7.1%
2 560
 
4.7%
3 398
 
3.4%
4 325
 
2.7%
0 321
 
2.7%
. 293
 
2.5%
5 267
 
2.2%
Other values (14) 976
 
8.2%
Hangul
ValueCountFrequency (%)
2298
 
14.1%
1181
 
7.3%
1133
 
7.0%
1130
 
6.9%
1122
 
6.9%
1107
 
6.8%
948
 
5.8%
570
 
3.5%
543
 
3.3%
271
 
1.7%
Other values (272) 5967
36.7%
Distinct1377
Distinct (%)76.2%
Missing16
Missing (%)0.9%
Memory size14.4 KiB
Minimum1975-01-25 00:00:00
Maximum2023-09-01 00:00:00
2023-12-12T20:22:35.333990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:22:35.626332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
Minimum2023-08-31 00:00:00
Maximum2023-08-31 00:00:00
2023-12-12T20:22:35.884159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:22:36.078982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T20:22:30.207900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:22:30.364826image/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제7조의3제3항에따른경우해동상회충청북도 충주시 목행동 611-3충청북도 충주시 행정9길 17. 목행동 611-4 (목행동)2023-09-012023-08-31
1제7조의3제2항에따른경우푸디스트 주식회사충청북도 충주시 수안보면 온천리 755-12 한화손해보험 수안보 연수원충청북도 충주시 수안보면 온천천변길 61-6. 한화손해보험 수안보 연수원2023-08-252023-08-31
2제7조의3제2항에따른경우지에스25 충주중앙대로점충청북도 충주시 중앙탑면 루암리 210-25충청북도 충주시 중앙탑면 탄금대로 6642023-08-252023-08-31
3제7조의3제2항에따른경우봉방아이스크림충청북도 충주시 문화동 397충청북도 충주시 중원대로 3460. 1층 (문화동)2023-08-212023-08-31
4제7조의3제2항에따른경우안녕식품충청북도 충주시 봉방동 65-3충청북도 충주시 탄금대로 77 (봉방동)2023-07-272023-08-31
5제7조의3제2항에따른경우씨유충주중원대로점충청북도 충주시 용두동 405-4충청북도 충주시 중원대로 3863 (용두동)2023-07-272023-08-31
6제7조의3제2항에따른경우굿푸드마켓충청북도 충주시 대소원면 본리 1133충청북도 충주시 대소원면 첨단쉼터1길 32023-07-262023-08-31
7제7조의3제2항에따른경우지에스25충주연수계룡점충청북도 충주시 연수동 710-3충청북도 충주시 연수서편2길 31. 1층 104호 (연수동)2023-07-142023-08-31
8제7조의3제2항에따른경우씨유 충주봉방사랑점충청북도 충주시 봉방동 137-23충청북도 충주시 봉방4길 47. 1층 (봉방동)2023-07-062023-08-31
9제7조의3제2항에따른경우주식회사 고캠프충청북도 충주시 중앙탑면 루암리 164-5충청북도 충주시 중앙탑면 청금로 282. 제나동2023-06-262023-08-31
민원구분업소명업소지번주소업소도로명주소지정일자데이터기준일자
1814일반소매인묵국수 and 만두촌충청북도 충주시 연수동 935호충청북도 충주시 국원대로 152-1 (연수동)1999-10-112023-08-31
1815일반소매인현대월드충청북도 충주시 앙성면 능암리 619번지 3호충청북도 충주시 앙성면 능동1길 351999-10-112023-08-31
1816일반소매인꽃사랑화원충청북도 충주시 연수동 1277호충청북도 충주시 연수서3길 12 (연수동)1999-10-112023-08-31
1817일반소매인창동구판장충청북도 충주시 주덕읍 덕련리 239호1999-10-112023-08-31
1818일반소매인충주담배충청북도 충주시 가금면 가흥리 호1999-08-122023-08-31
1819일반소매인지현현대슈퍼충청북도 충주시 지현동 1088번지 현대아파트상가 203호<NA>2023-08-31
1820일반소매인대풍상회충청북도 충주시 가금면 탑평리 183번지 2호충청북도 충주시 가금면 인담길 61<NA>2023-08-31
1821일반소매인문화원식당충청북도 충주시 성내동 205번지충청북도 충주시 중앙로 121 (성내동)<NA>2023-08-31
1822일반소매인식품점포충청북도 충주시 가금면 하구암리 61번지 1 호충청북도 충주시 가금면 묘곡2길 11<NA>2023-08-31
1823구내소매인서충주농업협동조합충청북도 충주시 대소원면 대소리 163-10<NA>2023-08-31

Duplicate rows

Most frequently occurring

민원구분업소명업소지번주소업소도로명주소지정일자데이터기준일자# duplicates
0일반소매인동량휴게식당충청북도 충주시 동량면 대전리 대전리1662번지 7호1989-09-182023-08-312
1일반소매인식품점충청북도 충주시 엄정면 목계리 목계리234번지 1호1985-02-232023-08-312