Overview

Dataset statistics

Number of variables4
Number of observations1961
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory61.4 KiB
Average record size in memory32.1 B

Variable types

Categorical1
Text3

Dataset

Description충청남도 공주시 일반 음식점 현황에 대한 데이터로 (업종명, 업소명, 영업자, 소재지(도로명) ) 등의 항목을 제공합니다.
Author충청남도 공주시
URLhttps://www.data.go.kr/data/15051147/fileData.do

Alerts

업종명 has constant value ""Constant

Reproduction

Analysis started2023-12-12 22:01:35.667691
Analysis finished2023-12-12 22:01:36.440586
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size15.4 KiB
일반음식점
1961 

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 (%)
일반음식점 1961
100.0%

Length

2023-12-13T07:01:36.509546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:01:36.621709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 1961
100.0%

업소명
Text

Distinct1905
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size15.4 KiB
2023-12-13T07:01:36.873939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length18
Mean length5.2116267
Min length1

Characters and Unicode

Total characters10220
Distinct characters712
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

Unique1853 ?
Unique (%)94.5%

Sample

1st row황해집
2nd row부산식당
3rd row기산식당
4th row중동오뎅집
5th row진미우동
ValueCountFrequency (%)
공주식당 4
 
0.2%
서울식당 3
 
0.2%
전주식당 3
 
0.2%
어린왕자 2
 
0.1%
고갯마루 2
 
0.1%
감나무집 2
 
0.1%
만나 2
 
0.1%
공주율찬 2
 
0.1%
우금치가든 2
 
0.1%
용궁칼국수 2
 
0.1%
Other values (1909) 1954
98.8%
2023-12-13T07:01:37.330104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
식 345
 
3.4%
당 288
 
2.8%
가 229
 
2.2%
주 191
 
1.9%
점 141
 
1.4%
공 140
 
1.4%
장 139
 
1.4%
이 138
 
1.4%
집 129
 
1.3%
수 127
 
1.2%
Other values (702) 8353
81.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9780
95.7%
Uppercase Letter 99
 
1.0%
Lowercase Letter 89
 
0.9%
Decimal Number 89
 
0.9%
Open Punctuation 66
 
0.6%
Close Punctuation 66
 
0.6%
Space Separator 17
 
0.2%
Other Punctuation 13
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
식 345
 
3.5%
당 288
 
2.9%
가 229
 
2.3%
주 191
 
2.0%
점 141
 
1.4%
공 140
 
1.4%
장 139
 
1.4%
이 138
 
1.4%
집 129
 
1.3%
수 127
 
1.3%
Other values (643) 7913
80.9%
Uppercase Letter
ValueCountFrequency (%)
C 12
12.1%
B 10
 
10.1%
O 8
 
8.1%
F 7
 
7.1%
H 7
 
7.1%
N 6
 
6.1%
M 6
 
6.1%
A 5
 
5.1%
I 5
 
5.1%
E 5
 
5.1%
Other values (14) 28
28.3%
Lowercase Letter
ValueCountFrequency (%)
e 17
19.1%
o 14
15.7%
c 8
9.0%
f 8
9.0%
d 6
 
6.7%
a 6
 
6.7%
r 5
 
5.6%
s 5
 
5.6%
i 4
 
4.5%
n 3
 
3.4%
Other values (7) 13
14.6%
Decimal Number
ValueCountFrequency (%)
1 16
18.0%
0 15
16.9%
8 12
13.5%
2 11
12.4%
7 10
11.2%
9 8
9.0%
5 7
7.9%
3 4
 
4.5%
6 3
 
3.4%
4 3
 
3.4%
Other Punctuation
ValueCountFrequency (%)
& 7
53.8%
. 4
30.8%
, 1
 
7.7%
· 1
 
7.7%
Open Punctuation
ValueCountFrequency (%)
( 66
100.0%
Close Punctuation
ValueCountFrequency (%)
) 66
100.0%
Space Separator
ValueCountFrequency (%)
17
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9780
95.7%
Common 252
 
2.5%
Latin 188
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
식 345
 
3.5%
당 288
 
2.9%
가 229
 
2.3%
주 191
 
2.0%
점 141
 
1.4%
공 140
 
1.4%
장 139
 
1.4%
이 138
 
1.4%
집 129
 
1.3%
수 127
 
1.3%
Other values (643) 7913
80.9%
Latin
ValueCountFrequency (%)
e 17
 
9.0%
o 14
 
7.4%
C 12
 
6.4%
B 10
 
5.3%
c 8
 
4.3%
f 8
 
4.3%
O 8
 
4.3%
F 7
 
3.7%
H 7
 
3.7%
d 6
 
3.2%
Other values (31) 91
48.4%
Common
ValueCountFrequency (%)
( 66
26.2%
) 66
26.2%
17
 
6.7%
1 16
 
6.3%
0 15
 
6.0%
8 12
 
4.8%
2 11
 
4.4%
7 10
 
4.0%
9 8
 
3.2%
5 7
 
2.8%
Other values (8) 24
 
9.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9780
95.7%
ASCII 439
 
4.3%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
식 345
 
3.5%
당 288
 
2.9%
가 229
 
2.3%
주 191
 
2.0%
점 141
 
1.4%
공 140
 
1.4%
장 139
 
1.4%
이 138
 
1.4%
집 129
 
1.3%
수 127
 
1.3%
Other values (643) 7913
80.9%
ASCII
ValueCountFrequency (%)
( 66
 
15.0%
) 66
 
15.0%
e 17
 
3.9%
17
 
3.9%
1 16
 
3.6%
0 15
 
3.4%
o 14
 
3.2%
8 12
 
2.7%
C 12
 
2.7%
2 11
 
2.5%
Other values (48) 193
44.0%
None
ValueCountFrequency (%)
· 1
100.0%

영업자
Text

Distinct1746
Distinct (%)89.0%
Missing0
Missing (%)0.0%
Memory size15.4 KiB
2023-12-13T07:01:37.757610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length3
Mean length3.0571137
Min length2

Characters and Unicode

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

Unique

Unique1599 ?
Unique (%)81.5%

Sample

1st row김득순
2nd row김정희
3rd row이기순
4th row최화순
5th row오용운
ValueCountFrequency (%)
외 20
 
1.0%
1명 19
 
0.9%
이명수 9
 
0.4%
김미숙 6
 
0.3%
김명자 5
 
0.2%
김영숙 5
 
0.2%
김영희 5
 
0.2%
이옥례 4
 
0.2%
박병철 4
 
0.2%
김순자 4
 
0.2%
Other values (1738) 1921
96.0%
2023-12-13T07:01:38.292538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 407
 
6.8%
이 341
 
5.7%
순 224
 
3.7%
정 213
 
3.6%
영 195
 
3.3%
숙 158
 
2.6%
박 154
 
2.6%
희 133
 
2.2%
자 132
 
2.2%
미 120
 
2.0%
Other values (232) 3918
65.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5907
98.5%
Space Separator 41
 
0.7%
Uppercase Letter 27
 
0.5%
Decimal Number 20
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 407
 
6.9%
이 341
 
5.8%
순 224
 
3.8%
정 213
 
3.6%
영 195
 
3.3%
숙 158
 
2.7%
박 154
 
2.6%
희 133
 
2.3%
자 132
 
2.2%
미 120
 
2.0%
Other values (213) 3830
64.8%
Uppercase Letter
ValueCountFrequency (%)
A 4
14.8%
N 4
14.8%
I 3
11.1%
G 2
 
7.4%
E 2
 
7.4%
U 2
 
7.4%
J 1
 
3.7%
H 1
 
3.7%
T 1
 
3.7%
R 1
 
3.7%
Other values (6) 6
22.2%
Decimal Number
ValueCountFrequency (%)
1 19
95.0%
2 1
 
5.0%
Space Separator
ValueCountFrequency (%)
41
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5907
98.5%
Common 61
 
1.0%
Latin 27
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 407
 
6.9%
이 341
 
5.8%
순 224
 
3.8%
정 213
 
3.6%
영 195
 
3.3%
숙 158
 
2.7%
박 154
 
2.6%
희 133
 
2.3%
자 132
 
2.2%
미 120
 
2.0%
Other values (213) 3830
64.8%
Latin
ValueCountFrequency (%)
A 4
14.8%
N 4
14.8%
I 3
11.1%
G 2
 
7.4%
E 2
 
7.4%
U 2
 
7.4%
J 1
 
3.7%
H 1
 
3.7%
T 1
 
3.7%
R 1
 
3.7%
Other values (6) 6
22.2%
Common
ValueCountFrequency (%)
41
67.2%
1 19
31.1%
2 1
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5907
98.5%
ASCII 88
 
1.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 407
 
6.9%
이 341
 
5.8%
순 224
 
3.8%
정 213
 
3.6%
영 195
 
3.3%
숙 158
 
2.7%
박 154
 
2.6%
희 133
 
2.3%
자 132
 
2.2%
미 120
 
2.0%
Other values (213) 3830
64.8%
ASCII
ValueCountFrequency (%)
41
46.6%
1 19
21.6%
A 4
 
4.5%
N 4
 
4.5%
I 3
 
3.4%
G 2
 
2.3%
E 2
 
2.3%
U 2
 
2.3%
J 1
 
1.1%
2 1
 
1.1%
Other values (9) 9
 
10.2%

소재지(도로명)
Text

Distinct1795
Distinct (%)91.5%
Missing0
Missing (%)0.0%
Memory size15.4 KiB
2023-12-13T07:01:38.678090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length44
Mean length24.63794
Min length9

Characters and Unicode

Total characters48315
Distinct characters284
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

Unique1662 ?
Unique (%)84.8%

Sample

1st row충청남도 공주시 산성시장5길 33-18, 1층 (산성동)
2nd row충청남도 공주시 산성시장2길 76 (산성동)
3rd row충청남도 공주시 산성시장2길 74 (산성동)
4th row충청남도 공주시 제민천3길 42 (중동)
5th row충청남도 공주시 중동3길 14-20, 1층 (산성동)
ValueCountFrequency (%)
충청남도 1950
 
18.4%
공주시 1950
 
18.4%
신관동 500
 
4.7%
1층 487
 
4.6%
반포면 244
 
2.3%
유구읍 132
 
1.2%
번영2로 110
 
1.0%
중동 99
 
0.9%
산성동 98
 
0.9%
계룡면 93
 
0.9%
Other values (1484) 4908
46.4%
2023-12-13T07:01:39.128678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8611
 
17.8%
1 2226
 
4.6%
시 2060
 
4.3%
공 2047
 
4.2%
주 2021
 
4.2%
도 1965
 
4.1%
남 1958
 
4.1%
충 1953
 
4.0%
청 1953
 
4.0%
동 1341
 
2.8%
Other values (274) 22180
45.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 27991
57.9%
Space Separator 8611
 
17.8%
Decimal Number 7530
 
15.6%
Open Punctuation 1237
 
2.6%
Close Punctuation 1237
 
2.6%
Other Punctuation 802
 
1.7%
Dash Punctuation 797
 
1.6%
Uppercase Letter 89
 
0.2%
Math Symbol 20
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 2060
 
7.4%
공 2047
 
7.3%
주 2021
 
7.2%
도 1965
 
7.0%
남 1958
 
7.0%
충 1953
 
7.0%
청 1953
 
7.0%
동 1341
 
4.8%
길 985
 
3.5%
로 967
 
3.5%
Other values (242) 10741
38.4%
Decimal Number
ValueCountFrequency (%)
1 2226
29.6%
2 1153
15.3%
3 761
 
10.1%
4 602
 
8.0%
5 554
 
7.4%
7 492
 
6.5%
6 466
 
6.2%
0 465
 
6.2%
8 456
 
6.1%
9 355
 
4.7%
Uppercase Letter
ValueCountFrequency (%)
E 21
23.6%
A 17
19.1%
C 12
13.5%
L 11
12.4%
R 10
11.2%
P 10
11.2%
B 6
 
6.7%
H 1
 
1.1%
U 1
 
1.1%
Other Punctuation
ValueCountFrequency (%)
, 797
99.4%
. 3
 
0.4%
& 1
 
0.1%
* 1
 
0.1%
Open Punctuation
ValueCountFrequency (%)
( 1236
99.9%
[ 1
 
0.1%
Close Punctuation
ValueCountFrequency (%)
) 1236
99.9%
] 1
 
0.1%
Math Symbol
ValueCountFrequency (%)
< 10
50.0%
> 10
50.0%
Space Separator
ValueCountFrequency (%)
8611
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 797
100.0%
Lowercase Letter
ValueCountFrequency (%)
a 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 27991
57.9%
Common 20234
41.9%
Latin 90
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 2060
 
7.4%
공 2047
 
7.3%
주 2021
 
7.2%
도 1965
 
7.0%
남 1958
 
7.0%
충 1953
 
7.0%
청 1953
 
7.0%
동 1341
 
4.8%
길 985
 
3.5%
로 967
 
3.5%
Other values (242) 10741
38.4%
Common
ValueCountFrequency (%)
8611
42.6%
1 2226
 
11.0%
( 1236
 
6.1%
) 1236
 
6.1%
2 1153
 
5.7%
, 797
 
3.9%
- 797
 
3.9%
3 761
 
3.8%
4 602
 
3.0%
5 554
 
2.7%
Other values (12) 2261
 
11.2%
Latin
ValueCountFrequency (%)
E 21
23.3%
A 17
18.9%
C 12
13.3%
L 11
12.2%
R 10
11.1%
P 10
11.1%
B 6
 
6.7%
H 1
 
1.1%
U 1
 
1.1%
a 1
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 27991
57.9%
ASCII 20324
42.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8611
42.4%
1 2226
 
11.0%
( 1236
 
6.1%
) 1236
 
6.1%
2 1153
 
5.7%
, 797
 
3.9%
- 797
 
3.9%
3 761
 
3.7%
4 602
 
3.0%
5 554
 
2.7%
Other values (22) 2351
 
11.6%
Hangul
ValueCountFrequency (%)
시 2060
 
7.4%
공 2047
 
7.3%
주 2021
 
7.2%
도 1965
 
7.0%
남 1958
 
7.0%
충 1953
 
7.0%
청 1953
 
7.0%
동 1341
 
4.8%
길 985
 
3.5%
로 967
 
3.5%
Other values (242) 10741
38.4%

Missing values

2023-12-13T07:01:36.319481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:01:36.405723image/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일반음식점황해집김득순충청남도 공주시 산성시장5길 33-18, 1층 (산성동)
1일반음식점부산식당김정희충청남도 공주시 산성시장2길 76 (산성동)
2일반음식점기산식당이기순충청남도 공주시 산성시장2길 74 (산성동)
3일반음식점중동오뎅집최화순충청남도 공주시 제민천3길 42 (중동)
4일반음식점진미우동오용운충청남도 공주시 중동3길 14-20, 1층 (산성동)
5일반음식점고향순대정옥순충청남도 공주시 산성시장2길 70-17 (산성동)
6일반음식점백제삼계탕유범석충청남도 공주시 봉산길 20-1 (중동)
7일반음식점삼미집조귀예충청남도 공주시 먹자1길 2 (중동)
8일반음식점중동분식박효순충청남도 공주시 먹자1길 3 (중동)
9일반음식점오거리반점김달수충청남도 공주시 제민천1길 9-1 (봉황동)
업종명업소명영업자소재지(도로명)
1951일반음식점명품키친김용수충청남도 공주시 한적2길 37-19, 1층 (금흥동)
1952일반음식점공주노랑통닭신관점이은석충청남도 공주시 번영1로 54-7, 1층 (신관동)
1953일반음식점통닭옛날삼학장석구충청남도 공주시 산성시장2길 56-8, 1층 (산성동)
1954일반음식점영상대감황창순충청남도 공주시 우성면 산막골길 70, 1층
1955일반음식점향마루뜸북장뷔페김미숙충청남도 공주시 반포면 금벽로 1714-3, 1층
1956일반음식점엄마의식당박병철충청남도 공주시 번영3로 30-1 (신관동)
1957일반음식점몽이의주방박병철충청남도 공주시 번영3로 30-1 (신관동)
1958일반음식점팜스키친박병철충청남도 공주시 번영3로 30-1 (신관동)
1959일반음식점빅도어하우스박병철충청남도 공주시 번영3로 30-1 (신관동)
1960일반음식점또봉이통닭(공주금흥점)김미선충청남도 공주시 무령로 599-25, 1층 105호 (금흥동)