Overview

Dataset statistics

Number of variables8
Number of observations70
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory65.9 B

Variable types

Text4
Categorical4

Dataset

Description2022년도 충청남도 서산시 모범음식점 및 위생등급제 지정현황
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=450&beforeMenuCd=DOM_000000201001001000&publicdatapk=3068030

Alerts

지정일 has constant value ""Constant
종료일 has constant value ""Constant
데이터기준일 has constant value ""Constant
업태 is highly imbalanced (61.2%)Imbalance
상호 has unique valuesUnique
도로명주소 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:35:03.594308
Analysis finished2024-01-09 22:35:04.057321
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

UNIQUE 

Distinct70
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size692.0 B
2024-01-10T07:35:04.245834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length5.1428571
Min length2

Characters and Unicode

Total characters360
Distinct characters162
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

Unique70 ?
Unique (%)100.0%

Sample

1st row가보
2nd row가야관
3rd row갈비본가 두툼한숯불갈비
4th row갈산농장가든
5th row강미루
ValueCountFrequency (%)
가보 1
 
1.3%
예당숯불갈비 1
 
1.3%
읍성숯불구이 1
 
1.3%
유대감생고기 1
 
1.3%
웰빙갈비랑메밀막국수 1
 
1.3%
원할머니보쌈.족발(서산점 1
 
1.3%
운산가든 1
 
1.3%
잠실감자탕&찜이야기 1
 
1.3%
오뚜기횟집 1
 
1.3%
영동보쌈꽃게장 1
 
1.3%
Other values (66) 66
86.8%
2024-01-10T07:35:04.595258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
산 12
 
3.3%
가 11
 
3.1%
서 11
 
3.1%
갈 10
 
2.8%
비 10
 
2.8%
부 7
 
1.9%
한 6
 
1.7%
우 6
 
1.7%
집 6
 
1.7%
구 6
 
1.7%
Other values (152) 275
76.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 350
97.2%
Space Separator 6
 
1.7%
Other Punctuation 2
 
0.6%
Close Punctuation 1
 
0.3%
Open Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 12
 
3.4%
가 11
 
3.1%
서 11
 
3.1%
갈 10
 
2.9%
비 10
 
2.9%
부 7
 
2.0%
한 6
 
1.7%
우 6
 
1.7%
집 6
 
1.7%
구 6
 
1.7%
Other values (147) 265
75.7%
Other Punctuation
ValueCountFrequency (%)
& 1
50.0%
. 1
50.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 350
97.2%
Common 10
 
2.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 12
 
3.4%
가 11
 
3.1%
서 11
 
3.1%
갈 10
 
2.9%
비 10
 
2.9%
부 7
 
2.0%
한 6
 
1.7%
우 6
 
1.7%
집 6
 
1.7%
구 6
 
1.7%
Other values (147) 265
75.7%
Common
ValueCountFrequency (%)
6
60.0%
) 1
 
10.0%
( 1
 
10.0%
& 1
 
10.0%
. 1
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 350
97.2%
ASCII 10
 
2.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
산 12
 
3.4%
가 11
 
3.1%
서 11
 
3.1%
갈 10
 
2.9%
비 10
 
2.9%
부 7
 
2.0%
한 6
 
1.7%
우 6
 
1.7%
집 6
 
1.7%
구 6
 
1.7%
Other values (147) 265
75.7%
ASCII
ValueCountFrequency (%)
6
60.0%
) 1
 
10.0%
( 1
 
10.0%
& 1
 
10.0%
. 1
 
10.0%

도로명주소
Text

UNIQUE 

Distinct70
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size692.0 B
2024-01-10T07:35:04.889512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length28
Mean length23.528571
Min length19

Characters and Unicode

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

Unique

Unique70 ?
Unique (%)100.0%

Sample

1st row충청남도 서산시 호수공원9로 47, 1층(예천동)
2nd row충청남도 서산시 명륜3길 24-23, 1층(읍내동)
3rd row충청남도 서산시 율지19길 74(동문동)
4th row충청남도 서산시 갈산1길 119(갈산동)
5th row충청남도 서산시 양유정1로 3(읍내동,, 124-38, 124-39(1,2층))
ValueCountFrequency (%)
충청남도 70
21.0%
서산시 70
21.0%
1층 7
 
2.1%
부석면 6
 
1.8%
1층(동문동 6
 
1.8%
해미면 5
 
1.5%
무학로 5
 
1.5%
율지6로 4
 
1.2%
인지면 4
 
1.2%
팔봉면 3
 
0.9%
Other values (130) 153
45.9%
2024-01-10T07:35:05.289340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
263
 
16.0%
1 98
 
6.0%
동 79
 
4.8%
산 78
 
4.7%
남 76
 
4.6%
충 72
 
4.4%
도 72
 
4.4%
서 72
 
4.4%
시 72
 
4.4%
청 70
 
4.3%
Other values (79) 695
42.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 964
58.5%
Decimal Number 268
 
16.3%
Space Separator 263
 
16.0%
Open Punctuation 55
 
3.3%
Close Punctuation 55
 
3.3%
Other Punctuation 32
 
1.9%
Dash Punctuation 9
 
0.5%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 79
 
8.2%
산 78
 
8.1%
남 76
 
7.9%
충 72
 
7.5%
도 72
 
7.5%
서 72
 
7.5%
시 72
 
7.5%
청 70
 
7.3%
로 57
 
5.9%
문 33
 
3.4%
Other values (63) 283
29.4%
Decimal Number
ValueCountFrequency (%)
1 98
36.6%
4 28
 
10.4%
6 22
 
8.2%
2 22
 
8.2%
7 21
 
7.8%
3 21
 
7.8%
8 17
 
6.3%
5 16
 
6.0%
9 15
 
5.6%
0 8
 
3.0%
Space Separator
ValueCountFrequency (%)
263
100.0%
Open Punctuation
ValueCountFrequency (%)
( 55
100.0%
Close Punctuation
ValueCountFrequency (%)
) 55
100.0%
Other Punctuation
ValueCountFrequency (%)
, 32
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Uppercase Letter
ValueCountFrequency (%)
D 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 964
58.5%
Common 682
41.4%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 79
 
8.2%
산 78
 
8.1%
남 76
 
7.9%
충 72
 
7.5%
도 72
 
7.5%
서 72
 
7.5%
시 72
 
7.5%
청 70
 
7.3%
로 57
 
5.9%
문 33
 
3.4%
Other values (63) 283
29.4%
Common
ValueCountFrequency (%)
263
38.6%
1 98
 
14.4%
( 55
 
8.1%
) 55
 
8.1%
, 32
 
4.7%
4 28
 
4.1%
6 22
 
3.2%
2 22
 
3.2%
7 21
 
3.1%
3 21
 
3.1%
Other values (5) 65
 
9.5%
Latin
ValueCountFrequency (%)
D 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 964
58.5%
ASCII 683
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
263
38.5%
1 98
 
14.3%
( 55
 
8.1%
) 55
 
8.1%
, 32
 
4.7%
4 28
 
4.1%
6 22
 
3.2%
2 22
 
3.2%
7 21
 
3.1%
3 21
 
3.1%
Other values (6) 66
 
9.7%
Hangul
ValueCountFrequency (%)
동 79
 
8.2%
산 78
 
8.1%
남 76
 
7.9%
충 72
 
7.5%
도 72
 
7.5%
서 72
 
7.5%
시 72
 
7.5%
청 70
 
7.3%
로 57
 
5.9%
문 33
 
3.4%
Other values (63) 283
29.4%

전화번호
Text

UNIQUE 

Distinct70
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size692.0 B
2024-01-10T07:35:05.511689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique

Unique70 ?
Unique (%)100.0%

Sample

1st row041-666-7700
2nd row041-667-6681
3rd row041-668-4420
4th row041-681-4200
5th row041-669-4938
ValueCountFrequency (%)
041-666-7700 1
 
1.4%
041-662-2708 1
 
1.4%
041-688-9265 1
 
1.4%
041-665-7706 1
 
1.4%
041-665-8787 1
 
1.4%
041-666-2251 1
 
1.4%
041-669-6060 1
 
1.4%
041-666-0007 1
 
1.4%
041-665-3392 1
 
1.4%
041-664-8626 1
 
1.4%
Other values (60) 60
85.7%
2024-01-10T07:35:05.833133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 170
20.2%
- 140
16.7%
0 113
13.5%
4 99
11.8%
1 95
11.3%
8 58
 
6.9%
2 44
 
5.2%
5 37
 
4.4%
7 30
 
3.6%
9 29
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 700
83.3%
Dash Punctuation 140
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 170
24.3%
0 113
16.1%
4 99
14.1%
1 95
13.6%
8 58
 
8.3%
2 44
 
6.3%
5 37
 
5.3%
7 30
 
4.3%
9 29
 
4.1%
3 25
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 140
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 840
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 170
20.2%
- 140
16.7%
0 113
13.5%
4 99
11.8%
1 95
11.3%
8 58
 
6.9%
2 44
 
5.2%
5 37
 
4.4%
7 30
 
3.6%
9 29
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 840
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 170
20.2%
- 140
16.7%
0 113
13.5%
4 99
11.8%
1 95
11.3%
8 58
 
6.9%
2 44
 
5.2%
5 37
 
4.4%
7 30
 
3.6%
9 29
 
3.5%

메뉴
Text

Distinct68
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size692.0 B
2024-01-10T07:35:06.085628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length8.6571429
Min length2

Characters and Unicode

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

Unique

Unique66 ?
Unique (%)94.3%

Sample

1st row자장면, 짬뽕
2nd row한정식, 생고기
3rd row돼지양념갈비, 삼겹살
4th row오리주물럭, 백숙
5th row탕수육, 궁보계정
ValueCountFrequency (%)
돼지갈비 6
 
4.5%
탕수육 5
 
3.8%
삼겹살 4
 
3.0%
냉면 3
 
2.3%
한정식 3
 
2.3%
자장면 3
 
2.3%
생고기 3
 
2.3%
불고기 2
 
1.5%
매운탕 2
 
1.5%
꽃게탕 2
 
1.5%
Other values (88) 99
75.0%
2024-01-10T07:35:06.454265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
, 62
 
10.2%
62
 
10.2%
탕 21
 
3.5%
갈 18
 
3.0%
비 18
 
3.0%
장 13
 
2.1%
구 13
 
2.1%
정 12
 
2.0%
찜 12
 
2.0%
지 12
 
2.0%
Other values (124) 363
59.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 482
79.5%
Other Punctuation 62
 
10.2%
Space Separator 62
 
10.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
탕 21
 
4.4%
갈 18
 
3.7%
비 18
 
3.7%
장 13
 
2.7%
구 13
 
2.7%
정 12
 
2.5%
찜 12
 
2.5%
지 12
 
2.5%
식 11
 
2.3%
우 10
 
2.1%
Other values (122) 342
71.0%
Other Punctuation
ValueCountFrequency (%)
, 62
100.0%
Space Separator
ValueCountFrequency (%)
62
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 482
79.5%
Common 124
 
20.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
탕 21
 
4.4%
갈 18
 
3.7%
비 18
 
3.7%
장 13
 
2.7%
구 13
 
2.7%
정 12
 
2.5%
찜 12
 
2.5%
지 12
 
2.5%
식 11
 
2.3%
우 10
 
2.1%
Other values (122) 342
71.0%
Common
ValueCountFrequency (%)
, 62
50.0%
62
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 482
79.5%
ASCII 124
 
20.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
, 62
50.0%
62
50.0%
Hangul
ValueCountFrequency (%)
탕 21
 
4.4%
갈 18
 
3.7%
비 18
 
3.7%
장 13
 
2.7%
구 13
 
2.7%
정 12
 
2.5%
찜 12
 
2.5%
지 12
 
2.5%
식 11
 
2.3%
우 10
 
2.1%
Other values (122) 342
71.0%

업태
Categorical

IMBALANCE 

Distinct4
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size692.0 B
한식
60 
중식
 
6
일식
 
3
양식
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)1.4%

Sample

1st row중식
2nd row한식
3rd row한식
4th row한식
5th row중식

Common Values

ValueCountFrequency (%)
한식 60
85.7%
중식 6
 
8.6%
일식 3
 
4.3%
양식 1
 
1.4%

Length

2024-01-10T07:35:06.577027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:35:06.693913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한식 60
85.7%
중식 6
 
8.6%
일식 3
 
4.3%
양식 1
 
1.4%

지정일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size692.0 B
2015-12-29
70 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2015-12-29
2nd row2015-12-29
3rd row2015-12-29
4th row2015-12-29
5th row2015-12-29

Common Values

ValueCountFrequency (%)
2015-12-29 70
100.0%

Length

2024-01-10T07:35:06.805024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:35:06.902727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2015-12-29 70
100.0%

종료일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size692.0 B
2016-12-28
70 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2016-12-28
2nd row2016-12-28
3rd row2016-12-28
4th row2016-12-28
5th row2016-12-28

Common Values

ValueCountFrequency (%)
2016-12-28 70
100.0%

Length

2024-01-10T07:35:07.021995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:35:07.117993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016-12-28 70
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size692.0 B
2016-05-16
70 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2016-05-16
2nd row2016-05-16
3rd row2016-05-16
4th row2016-05-16
5th row2016-05-16

Common Values

ValueCountFrequency (%)
2016-05-16 70
100.0%

Length

2024-01-10T07:35:07.206821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:35:07.289534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016-05-16 70
100.0%

Correlations

2024-01-10T07:35:07.346681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호도로명주소전화번호메뉴업태
상호1.0001.0001.0001.0001.000
도로명주소1.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000
메뉴1.0001.0001.0001.0001.000
업태1.0001.0001.0001.0001.000

Missing values

2024-01-10T07:35:03.915934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:35:04.017125image/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가보충청남도 서산시 호수공원9로 47, 1층(예천동)041-666-7700자장면, 짬뽕중식2015-12-292016-12-282016-05-16
1가야관충청남도 서산시 명륜3길 24-23, 1층(읍내동)041-667-6681한정식, 생고기한식2015-12-292016-12-282016-05-16
2갈비본가 두툼한숯불갈비충청남도 서산시 율지19길 74(동문동)041-668-4420돼지양념갈비, 삼겹살한식2015-12-292016-12-282016-05-16
3갈산농장가든충청남도 서산시 갈산1길 119(갈산동)041-681-4200오리주물럭, 백숙한식2015-12-292016-12-282016-05-16
4강미루충청남도 서산시 양유정1로 3(읍내동,, 124-38, 124-39(1,2층))041-669-4938탕수육, 궁보계정중식2015-12-292016-12-282016-05-16
5거북이 횟집충청남도 서산시 율지6로 45(동문동, 1층)041-668-6116광어회, 우럭회한식2015-12-292016-12-282016-05-16
6고삐충청남도 서산시 쌍연남2로14(동문동)041-664-9253한우생고기구이한식2015-12-292016-12-282016-05-16
7광명먹거리마당충청남도 서산시 부춘4로 18, 1층(읍내동)041-665-2368삽겹살, 두부전골한식2015-12-292016-12-282016-05-16
8구도해물맛집충청남도 서산시 팔봉면 범머리길 17, 1층041-669-1943해물찜, 해물탕한식2015-12-292016-12-282016-05-16
9구도횟집충청남도 서산시 팔봉면 팔봉1로 748041-662-6117박속밀국낙지탕, 활어회일식2015-12-292016-12-282016-05-16
상호도로명주소전화번호메뉴업태지정일종료일데이터기준일
60천수만회타운충청남도 서산시 부석면 천수만로 602041-669-8134생선회한식2015-12-292016-12-282016-05-16
61청도충청남도 서산시 율지11로 8(동문동)041-663-6652탕수육, 짬뽕중식2015-12-292016-12-282016-05-16
62청원꽃게장충청남도 서산시 율지8로 80(동문동,(1층))041-667-2012꽃게장정식, 우럭젓국한식2015-12-292016-12-282016-05-16
63태능갈비충청남도 서산시 대산읍 가로림로 56-1041-681-5252모듬생고기, 돼지갈비한식2015-12-292016-12-282016-05-16
64팔봉순두부충청남도 서산시 인지면 차동길 146, 1층041-429-2211순두부전골, 두부김치한식2015-12-292016-12-282016-05-16
65한우명가 백제충청남도 서산시 해미면 남문1로 14(1층)041-688-3005한우떡갈비정식, 한우불고기한식2015-12-292016-12-282016-05-16
66해성숯불갈비충청남도 서산시 해미면 남문5로 12-1041-688-2048돼지갈비, 깻묵된장한식2015-12-292016-12-282016-05-16
67현대한우촌충청남도 서산시 율지 17로 21(동문동)041-665-3271생등심, 특수구이한식2015-12-292016-12-282016-05-16
68황우숯불갈비충청남도 서산시 해미면 남문5로 16041-688-0599생갈비, 돼지갈비한식2015-12-292016-12-282016-05-16
69효정가든충청남도 서산시 운산면 장벌4로 8041-663-3554생삼겹살, 돼지갈비한식2015-12-292016-12-282016-05-16