Overview

Dataset statistics

Number of variables5
Number of observations36
Missing cells9
Missing cells (%)5.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory43.7 B

Variable types

DateTime1
Categorical1
Text3

Dataset

Description계룡시 관내 위생등급제 지정현황에 대한 데이터로서 지정일자, 지정등급, 업소명, 주소, 전화번호를 공공데이터로 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=308&beforeMenuCd=DOM_000000201001001000&publicdatapk=15093922

Alerts

전화번호 has 9 (25.0%) missing valuesMissing
업소명 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:23:12.390971
Analysis finished2024-01-09 22:23:12.738873
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지정일자
Date

Distinct24
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Memory size420.0 B
Minimum2021-08-13 00:00:00
Maximum2023-06-25 00:00:00
2024-01-10T07:23:12.782896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:23:12.880160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)

지정등급
Categorical

Distinct3
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size420.0 B
매우우수
27 
우수
6 
등급보류
3 

Length

Max length4
Median length4
Mean length3.6666667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row매우우수
2nd row우수
3rd row매우우수
4th row매우우수
5th row매우우수

Common Values

ValueCountFrequency (%)
매우우수 27
75.0%
우수 6
 
16.7%
등급보류 3
 
8.3%

Length

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

Common Values (Plot)

2024-01-10T07:23:13.093559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
매우우수 27
75.0%
우수 6
 
16.7%
등급보류 3
 
8.3%

업소명
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-01-10T07:23:13.272163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length8.8333333
Min length3

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)100.0%

Sample

1st row푸라닭 계룡점
2nd row피자헛 계룡점
3rd row피자 스쿨 신도안점
4th row노랑카페
5th row노랑통닭 계룡점
ValueCountFrequency (%)
계룡점 8
 
11.9%
계룡엄사점 5
 
7.5%
계룡대점 3
 
4.5%
배스킨라빈스 2
 
3.0%
맘스터치 2
 
3.0%
모멘트 1
 
1.5%
노반뚜노 1
 
1.5%
쟈뎅드모아 1
 
1.5%
첫번째 1
 
1.5%
계룡 1
 
1.5%
Other values (42) 42
62.7%
2024-01-10T07:23:13.566386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
31
 
9.7%
계 25
 
7.9%
룡 24
 
7.5%
점 24
 
7.5%
스 13
 
4.1%
피 8
 
2.5%
대 6
 
1.9%
엄 5
 
1.6%
사 5
 
1.6%
자 5
 
1.6%
Other values (106) 172
54.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 271
85.2%
Space Separator 31
 
9.7%
Uppercase Letter 8
 
2.5%
Close Punctuation 3
 
0.9%
Open Punctuation 3
 
0.9%
Decimal Number 2
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
계 25
 
9.2%
룡 24
 
8.9%
점 24
 
8.9%
스 13
 
4.8%
피 8
 
3.0%
대 6
 
2.2%
엄 5
 
1.8%
사 5
 
1.8%
자 5
 
1.8%
킨 5
 
1.8%
Other values (97) 151
55.7%
Uppercase Letter
ValueCountFrequency (%)
T 3
37.5%
D 3
37.5%
J 1
 
12.5%
B 1
 
12.5%
Decimal Number
ValueCountFrequency (%)
0 1
50.0%
6 1
50.0%
Space Separator
ValueCountFrequency (%)
31
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 271
85.2%
Common 39
 
12.3%
Latin 8
 
2.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
계 25
 
9.2%
룡 24
 
8.9%
점 24
 
8.9%
스 13
 
4.8%
피 8
 
3.0%
대 6
 
2.2%
엄 5
 
1.8%
사 5
 
1.8%
자 5
 
1.8%
킨 5
 
1.8%
Other values (97) 151
55.7%
Common
ValueCountFrequency (%)
31
79.5%
) 3
 
7.7%
( 3
 
7.7%
0 1
 
2.6%
6 1
 
2.6%
Latin
ValueCountFrequency (%)
T 3
37.5%
D 3
37.5%
J 1
 
12.5%
B 1
 
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 271
85.2%
ASCII 47
 
14.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
31
66.0%
T 3
 
6.4%
D 3
 
6.4%
) 3
 
6.4%
( 3
 
6.4%
J 1
 
2.1%
B 1
 
2.1%
0 1
 
2.1%
6 1
 
2.1%
Hangul
ValueCountFrequency (%)
계 25
 
9.2%
룡 24
 
8.9%
점 24
 
8.9%
스 13
 
4.8%
피 8
 
3.0%
대 6
 
2.2%
엄 5
 
1.8%
사 5
 
1.8%
자 5
 
1.8%
킨 5
 
1.8%
Other values (97) 151
55.7%

주소
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-01-10T07:23:13.769477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length33.5
Mean length27.388889
Min length19

Characters and Unicode

Total characters986
Distinct characters84
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

Unique36 ?
Unique (%)100.0%

Sample

1st row충청남도 계룡시 엄사면 엄사중앙로 113 1층 푸라닭 충남계룡점
2nd row충청남도 계룡시 엄사면 평리길 6(엄사면) 1층
3rd row충청남도 계룡시 신도안면 신도안1길 43(신도안면) 1층
4th row충청남도 계룡시 엄사면 전원로 77(엄사면) 1층
5th row충청남도 계룡시 서금암1길 11(금암동) 101호
ValueCountFrequency (%)
충청남도 36
17.4%
계룡시 36
17.4%
엄사면 20
 
9.7%
번영로 7
 
3.4%
1층 7
 
3.4%
계룡대로 5
 
2.4%
금암동 5
 
2.4%
신도안면 5
 
2.4%
엄사중앙로 4
 
1.9%
신도안1길 4
 
1.9%
Other values (69) 78
37.7%
2024-01-10T07:23:14.077847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
171
 
17.3%
1 54
 
5.5%
도 47
 
4.8%
계 45
 
4.6%
룡 45
 
4.6%
충 37
 
3.8%
남 37
 
3.8%
시 37
 
3.8%
청 36
 
3.7%
면 31
 
3.1%
Other values (74) 446
45.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 594
60.2%
Space Separator 171
 
17.3%
Decimal Number 156
 
15.8%
Open Punctuation 28
 
2.8%
Close Punctuation 28
 
2.8%
Other Punctuation 4
 
0.4%
Dash Punctuation 3
 
0.3%
Uppercase Letter 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 47
 
7.9%
계 45
 
7.6%
룡 45
 
7.6%
충 37
 
6.2%
남 37
 
6.2%
시 37
 
6.2%
청 36
 
6.1%
면 31
 
5.2%
사 28
 
4.7%
엄 27
 
4.5%
Other values (56) 224
37.7%
Decimal Number
ValueCountFrequency (%)
1 54
34.6%
4 19
 
12.2%
0 16
 
10.3%
3 14
 
9.0%
2 14
 
9.0%
6 12
 
7.7%
9 11
 
7.1%
5 7
 
4.5%
7 7
 
4.5%
8 2
 
1.3%
Other Punctuation
ValueCountFrequency (%)
, 3
75.0%
. 1
 
25.0%
Uppercase Letter
ValueCountFrequency (%)
T 1
50.0%
D 1
50.0%
Space Separator
ValueCountFrequency (%)
171
100.0%
Open Punctuation
ValueCountFrequency (%)
( 28
100.0%
Close Punctuation
ValueCountFrequency (%)
) 28
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 594
60.2%
Common 390
39.6%
Latin 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 47
 
7.9%
계 45
 
7.6%
룡 45
 
7.6%
충 37
 
6.2%
남 37
 
6.2%
시 37
 
6.2%
청 36
 
6.1%
면 31
 
5.2%
사 28
 
4.7%
엄 27
 
4.5%
Other values (56) 224
37.7%
Common
ValueCountFrequency (%)
171
43.8%
1 54
 
13.8%
( 28
 
7.2%
) 28
 
7.2%
4 19
 
4.9%
0 16
 
4.1%
3 14
 
3.6%
2 14
 
3.6%
6 12
 
3.1%
9 11
 
2.8%
Other values (6) 23
 
5.9%
Latin
ValueCountFrequency (%)
T 1
50.0%
D 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 594
60.2%
ASCII 392
39.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
171
43.6%
1 54
 
13.8%
( 28
 
7.1%
) 28
 
7.1%
4 19
 
4.8%
0 16
 
4.1%
3 14
 
3.6%
2 14
 
3.6%
6 12
 
3.1%
9 11
 
2.8%
Other values (8) 25
 
6.4%
Hangul
ValueCountFrequency (%)
도 47
 
7.9%
계 45
 
7.6%
룡 45
 
7.6%
충 37
 
6.2%
남 37
 
6.2%
시 37
 
6.2%
청 36
 
6.1%
면 31
 
5.2%
사 28
 
4.7%
엄 27
 
4.5%
Other values (56) 224
37.7%

전화번호
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing9
Missing (%)25.0%
Memory size420.0 B
2024-01-10T07:23:14.246100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.037037
Min length12

Characters and Unicode

Total characters325
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

Unique27 ?
Unique (%)100.0%

Sample

1st row042-841-0500
2nd row042-551-5577
3rd row042-532-1845
4th row042-840-8890
5th row042-840-8258
ValueCountFrequency (%)
042-841-0500 1
 
3.7%
042-841-8497 1
 
3.7%
042-365-7911 1
 
3.7%
042-551-6609 1
 
3.7%
042-841-3087 1
 
3.7%
042-710-8272 1
 
3.7%
070-7793-0160 1
 
3.7%
042-551-5292 1
 
3.7%
042-551-1266 1
 
3.7%
042-551-7779 1
 
3.7%
Other values (17) 17
63.0%
2024-01-10T07:23:14.500515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 54
16.6%
4 46
14.2%
0 45
13.8%
2 39
12.0%
8 29
8.9%
5 28
8.6%
1 24
7.4%
9 18
 
5.5%
7 18
 
5.5%
3 14
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 271
83.4%
Dash Punctuation 54
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 46
17.0%
0 45
16.6%
2 39
14.4%
8 29
10.7%
5 28
10.3%
1 24
8.9%
9 18
 
6.6%
7 18
 
6.6%
3 14
 
5.2%
6 10
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 54
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 325
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 54
16.6%
4 46
14.2%
0 45
13.8%
2 39
12.0%
8 29
8.9%
5 28
8.6%
1 24
7.4%
9 18
 
5.5%
7 18
 
5.5%
3 14
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 325
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 54
16.6%
4 46
14.2%
0 45
13.8%
2 39
12.0%
8 29
8.9%
5 28
8.6%
1 24
7.4%
9 18
 
5.5%
7 18
 
5.5%
3 14
 
4.3%

Correlations

2024-01-10T07:23:14.578303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지정일자지정등급업소명주소전화번호
지정일자1.0000.6991.0001.0001.000
지정등급0.6991.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:23:12.637893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:23:12.709102image/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

지정일자지정등급업소명주소전화번호
02021-08-13매우우수푸라닭 계룡점충청남도 계룡시 엄사면 엄사중앙로 113 1층 푸라닭 충남계룡점042-841-0500
12021-09-28우수피자헛 계룡점충청남도 계룡시 엄사면 평리길 6(엄사면) 1층042-551-5577
22021-09-28매우우수피자 스쿨 신도안점충청남도 계룡시 신도안면 신도안1길 43(신도안면) 1층042-532-1845
32021-09-28매우우수노랑카페충청남도 계룡시 엄사면 전원로 77(엄사면) 1층042-840-8890
42021-10-06매우우수노랑통닭 계룡점충청남도 계룡시 서금암1길 11(금암동) 101호042-840-8258
52021-10-06등급보류셀렉토커피 계룡대점충청남도 계룡시 신도안면 신도안1길 43(신도안면) 계룡대 스포츠센터 1층042-551-3696
62021-10-06매우우수응급실 국물 떡볶이 계룡금암점충청남도 계룡시 장안로 49(금암동) 104호042-840-5119
72021-11-02매우우수도깨비주걱충청남도 계룡시 새터산길 22-11(금암동) .042-345-8383
82021-11-02우수맘스터치 계룡엄사점충청남도 계룡시 엄사면 엄사중앙로 106(엄사면) 1층042-841-9288
92021-11-26매우우수스타벅스 계룡대로DT점충청남도 계룡시 엄사면 번영로 6 6(스타벅스 계룡대로DT점)042-551-3420
지정일자지정등급업소명주소전화번호
262022-10-13매우우수맘스터치 계룡 금암점충청남도 계룡시 서금암3길 5(쉐리움 105호 금암동)<NA>
272022-11-02우수메리엘충청남도 계룡시 서금암1길 11(금암동)070-7793-0160
282022-11-24매우우수버거킹 계룡엄사점충청남도 계룡시 엄사면 계룡대로 524(1층)042-710-8272
292023-01-20매우우수카페테리아(이디야 계룡대점)충청남도 계룡시 신도안면 계룡대로 663(교정 및 군사시설)<NA>
302023-02-22매우우수도미노피자 계룡점충청남도 계룡시 엄사면 번영로 12 12042-841-3087
312023-03-20매우우수빽다방 계룡시청점충청남도 계룡시 장안로 59-3(천마빌딩 102호 금암동)<NA>
322023-05-16매우우수배스킨라빈스 계룡대실점충청남도 계룡시 두마면 농소리 981<NA>
332023-05-16매우우수60계 치킨 계룡엄사점충청남도 계룡시 엄사면 번영로 84042-551-6609
342023-05-16매우우수(주)홈플러스초밥충청남도 계룡시 계룡대로 304(금암동)<NA>
352023-06-25우수호식이두마리치킨 계룡점충청남도 계룡시 신도안면 신도안1길 43 1층042-840-9982