Overview

Dataset statistics

Number of variables5
Number of observations638
Missing cells36
Missing cells (%)1.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.1 KiB
Average record size in memory40.2 B

Variable types

Categorical1
Text4

Dataset

Description충청남도 시군에 등록된 모범 음식점 현황에 대한 데이터이며 지역, 업소명, 주소, 연락처 주 메뉴 등 항목을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=406&beforeMenuCd=DOM_000000201001001000&publicdatapk=3082706

Alerts

전화번호 has 36 (5.6%) missing valuesMissing

Reproduction

Analysis started2024-01-09 20:57:23.840361
Analysis finished2024-01-09 20:57:24.712765
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지역
Categorical

Distinct14
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
아산시
84 
공주시
72 
논산시
69 
서산시
58 
천안시
50 
Other values (9)
305 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row천안시
2nd row천안시
3rd row천안시
4th row천안시
5th row천안시

Common Values

ValueCountFrequency (%)
아산시 84
13.2%
공주시 72
11.3%
논산시 69
10.8%
서산시 58
9.1%
천안시 50
7.8%
당진시 50
7.8%
부여군 44
6.9%
홍성군 40
6.3%
예산군 37
 
5.8%
태안군 35
 
5.5%
Other values (4) 99
15.5%

Length

2024-01-10T05:57:24.768320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
아산시 84
13.2%
공주시 72
11.3%
논산시 69
10.8%
서산시 58
9.1%
천안시 50
7.8%
당진시 50
7.8%
부여군 44
6.9%
홍성군 40
6.3%
예산군 37
 
5.8%
태안군 35
 
5.5%
Other values (4) 99
15.5%

업소명
Text

Distinct625
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2024-01-10T05:57:24.949284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length15
Mean length5.460815
Min length1

Characters and Unicode

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

Unique

Unique613 ?
Unique (%)96.1%

Sample

1st row(주)방아다리
2nd row개성집
3rd row개성집천안법원점
4th row경복궁
5th row경복궁신부점주식회사덕용푸드시스템
ValueCountFrequency (%)
투가리감자탕 3
 
0.4%
망향비빔국수 2
 
0.3%
용화점 2
 
0.3%
화평동왕냉면 2
 
0.3%
토담 2
 
0.3%
청지기꽃게장 2
 
0.3%
소나무 2
 
0.3%
주)케이알산업홍성 2
 
0.3%
육하원칙 2
 
0.3%
향적산 2
 
0.3%
Other values (656) 666
96.9%
2024-01-10T05:57:25.275448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
가 97
 
2.8%
산 71
 
2.0%
수 65
 
1.9%
당 63
 
1.8%
집 60
 
1.7%
식 55
 
1.6%
53
 
1.5%
장 52
 
1.5%
대 52
 
1.5%
비 51
 
1.5%
Other values (425) 2865
82.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3360
96.4%
Space Separator 53
 
1.5%
Close Punctuation 22
 
0.6%
Open Punctuation 22
 
0.6%
Other Punctuation 10
 
0.3%
Decimal Number 8
 
0.2%
Other Symbol 4
 
0.1%
Lowercase Letter 4
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
가 97
 
2.9%
산 71
 
2.1%
수 65
 
1.9%
당 63
 
1.9%
집 60
 
1.8%
식 55
 
1.6%
장 52
 
1.5%
대 52
 
1.5%
비 51
 
1.5%
이 48
 
1.4%
Other values (407) 2746
81.7%
Decimal Number
ValueCountFrequency (%)
1 4
50.0%
5 1
 
12.5%
3 1
 
12.5%
0 1
 
12.5%
2 1
 
12.5%
Other Punctuation
ValueCountFrequency (%)
. 4
40.0%
& 4
40.0%
· 1
 
10.0%
, 1
 
10.0%
Lowercase Letter
ValueCountFrequency (%)
o 1
25.0%
u 1
25.0%
t 1
25.0%
e 1
25.0%
Space Separator
ValueCountFrequency (%)
53
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%
Open Punctuation
ValueCountFrequency (%)
( 22
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%
Uppercase Letter
ValueCountFrequency (%)
R 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3363
96.5%
Common 115
 
3.3%
Latin 5
 
0.1%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
가 97
 
2.9%
산 71
 
2.1%
수 65
 
1.9%
당 63
 
1.9%
집 60
 
1.8%
식 55
 
1.6%
장 52
 
1.5%
대 52
 
1.5%
비 51
 
1.5%
이 48
 
1.4%
Other values (407) 2749
81.7%
Common
ValueCountFrequency (%)
53
46.1%
) 22
19.1%
( 22
19.1%
1 4
 
3.5%
. 4
 
3.5%
& 4
 
3.5%
5 1
 
0.9%
3 1
 
0.9%
· 1
 
0.9%
, 1
 
0.9%
Other values (2) 2
 
1.7%
Latin
ValueCountFrequency (%)
R 1
20.0%
o 1
20.0%
u 1
20.0%
t 1
20.0%
e 1
20.0%
Han
ValueCountFrequency (%)
本 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3359
96.4%
ASCII 119
 
3.4%
None 5
 
0.1%
CJK 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
가 97
 
2.9%
산 71
 
2.1%
수 65
 
1.9%
당 63
 
1.9%
집 60
 
1.8%
식 55
 
1.6%
장 52
 
1.5%
대 52
 
1.5%
비 51
 
1.5%
이 48
 
1.4%
Other values (406) 2745
81.7%
ASCII
ValueCountFrequency (%)
53
44.5%
) 22
18.5%
( 22
18.5%
1 4
 
3.4%
. 4
 
3.4%
& 4
 
3.4%
5 1
 
0.8%
3 1
 
0.8%
, 1
 
0.8%
R 1
 
0.8%
Other values (6) 6
 
5.0%
None
ValueCountFrequency (%)
㈜ 4
80.0%
· 1
 
20.0%
CJK
ValueCountFrequency (%)
本 1
100.0%

주소
Text

Distinct634
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2024-01-10T05:57:25.572032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length39
Mean length19.768025
Min length10

Characters and Unicode

Total characters12612
Distinct characters292
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

Unique630 ?
Unique (%)98.7%

Sample

1st row 천안시 서북구 쌍용19로 38-5, 1층 (쌍용동)
2nd row 천안시 서북구 한들2로 62 (백석동)
3rd row 천안시 동남구 청수5로 3, 2층 203,204,205호 (청당동)
4th row 천안시 서북구 성정중7길 9 (성정동)
5th row 천안시 동남구 천안천7길 38, 2층 (신부동)
ValueCountFrequency (%)
아산시 84
 
3.1%
1층 84
 
3.1%
공주시 72
 
2.7%
논산시 69
 
2.5%
서산시 58
 
2.1%
당진시 50
 
1.8%
천안시 50
 
1.8%
부여군 44
 
1.6%
홍성군 40
 
1.5%
부여읍 38
 
1.4%
Other values (1113) 2121
78.3%
2024-01-10T05:57:26.029385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2582
 
20.5%
1 641
 
5.1%
시 462
 
3.7%
로 458
 
3.6%
산 383
 
3.0%
2 370
 
2.9%
동 349
 
2.8%
) 307
 
2.4%
( 306
 
2.4%
길 258
 
2.0%
Other values (282) 6496
51.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6624
52.5%
Space Separator 2582
 
20.5%
Decimal Number 2422
 
19.2%
Close Punctuation 307
 
2.4%
Open Punctuation 306
 
2.4%
Dash Punctuation 204
 
1.6%
Other Punctuation 147
 
1.2%
Lowercase Letter 9
 
0.1%
Uppercase Letter 8
 
0.1%
Math Symbol 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 462
 
7.0%
로 458
 
6.9%
산 383
 
5.8%
동 349
 
5.3%
길 258
 
3.9%
군 213
 
3.2%
읍 208
 
3.1%
면 197
 
3.0%
서 164
 
2.5%
천 148
 
2.2%
Other values (252) 3784
57.1%
Decimal Number
ValueCountFrequency (%)
1 641
26.5%
2 370
15.3%
3 249
 
10.3%
4 201
 
8.3%
5 190
 
7.8%
6 175
 
7.2%
7 158
 
6.5%
0 153
 
6.3%
8 151
 
6.2%
9 134
 
5.5%
Lowercase Letter
ValueCountFrequency (%)
e 2
22.2%
a 1
11.1%
u 1
11.1%
n 1
11.1%
v 1
11.1%
h 1
11.1%
c 1
11.1%
r 1
11.1%
Uppercase Letter
ValueCountFrequency (%)
A 3
37.5%
C 2
25.0%
M 1
 
12.5%
I 1
 
12.5%
D 1
 
12.5%
Other Punctuation
ValueCountFrequency (%)
, 146
99.3%
. 1
 
0.7%
Space Separator
ValueCountFrequency (%)
2582
100.0%
Close Punctuation
ValueCountFrequency (%)
) 307
100.0%
Open Punctuation
ValueCountFrequency (%)
( 306
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 204
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6624
52.5%
Common 5971
47.3%
Latin 17
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 462
 
7.0%
로 458
 
6.9%
산 383
 
5.8%
동 349
 
5.3%
길 258
 
3.9%
군 213
 
3.2%
읍 208
 
3.1%
면 197
 
3.0%
서 164
 
2.5%
천 148
 
2.2%
Other values (252) 3784
57.1%
Common
ValueCountFrequency (%)
2582
43.2%
1 641
 
10.7%
2 370
 
6.2%
) 307
 
5.1%
( 306
 
5.1%
3 249
 
4.2%
- 204
 
3.4%
4 201
 
3.4%
5 190
 
3.2%
6 175
 
2.9%
Other values (7) 746
 
12.5%
Latin
ValueCountFrequency (%)
A 3
17.6%
e 2
11.8%
C 2
11.8%
a 1
 
5.9%
M 1
 
5.9%
I 1
 
5.9%
u 1
 
5.9%
n 1
 
5.9%
v 1
 
5.9%
h 1
 
5.9%
Other values (3) 3
17.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6624
52.5%
ASCII 5988
47.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2582
43.1%
1 641
 
10.7%
2 370
 
6.2%
) 307
 
5.1%
( 306
 
5.1%
3 249
 
4.2%
- 204
 
3.4%
4 201
 
3.4%
5 190
 
3.2%
6 175
 
2.9%
Other values (20) 763
 
12.7%
Hangul
ValueCountFrequency (%)
시 462
 
7.0%
로 458
 
6.9%
산 383
 
5.8%
동 349
 
5.3%
길 258
 
3.9%
군 213
 
3.2%
읍 208
 
3.1%
면 197
 
3.0%
서 164
 
2.5%
천 148
 
2.2%
Other values (252) 3784
57.1%

전화번호
Text

MISSING 

Distinct601
Distinct (%)99.8%
Missing36
Missing (%)5.6%
Memory size5.1 KiB
2024-01-10T05:57:26.239892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length11.988372
Min length9

Characters and Unicode

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

Unique600 ?
Unique (%)99.7%

Sample

1st row041-579-9222
2nd row041-572-3600
3rd row041-556-7260
4th row041-565-7776
5th row041-565-6633
ValueCountFrequency (%)
041-587-0303 2
 
0.3%
041-753-2900 1
 
0.2%
041-752-4110 1
 
0.2%
041-579-9222 1
 
0.2%
041-754-1133 1
 
0.2%
041-753-4132 1
 
0.2%
041-751-1320 1
 
0.2%
041-753-8033 1
 
0.2%
041-751-0323 1
 
0.2%
041-754-3121 1
 
0.2%
Other values (591) 591
98.2%
2024-01-10T05:57:26.556455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 1200
16.6%
0 966
13.4%
4 920
12.7%
1 888
12.3%
5 613
8.5%
3 608
8.4%
6 469
 
6.5%
2 406
 
5.6%
7 403
 
5.6%
8 402
 
5.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 6017
83.4%
Dash Punctuation 1200
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 966
16.1%
4 920
15.3%
1 888
14.8%
5 613
10.2%
3 608
10.1%
6 469
7.8%
2 406
6.7%
7 403
6.7%
8 402
6.7%
9 342
 
5.7%
Dash Punctuation
ValueCountFrequency (%)
- 1200
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 7217
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 1200
16.6%
0 966
13.4%
4 920
12.7%
1 888
12.3%
5 613
8.5%
3 608
8.4%
6 469
 
6.5%
2 406
 
5.6%
7 403
 
5.6%
8 402
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7217
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 1200
16.6%
0 966
13.4%
4 920
12.7%
1 888
12.3%
5 613
8.5%
3 608
8.4%
6 469
 
6.5%
2 406
 
5.6%
7 403
 
5.6%
8 402
 
5.6%

주메뉴
Text

Distinct424
Distinct (%)66.5%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2024-01-10T05:57:26.829432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length12
Mean length5.69279
Min length1

Characters and Unicode

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

Unique

Unique343 ?
Unique (%)53.8%

Sample

1st row한방오리백숙
2nd row감자탕
3rd row장어구이
4th row돼지갈비
5th row짜장, 짬뽕
ValueCountFrequency (%)
돼지갈비 28
 
3.4%
삼겹살 24
 
2.9%
생선회 17
 
2.1%
한정식 17
 
2.1%
칼국수 16
 
1.9%
삼계탕 14
 
1.7%
갈비 13
 
1.6%
아구찜 12
 
1.4%
짬뽕 12
 
1.4%
장어구이 12
 
1.4%
Other values (391) 663
80.1%
2024-01-10T05:57:27.286025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
, 244
 
6.7%
195
 
5.4%
탕 118
 
3.2%
비 110
 
3.0%
식 101
 
2.8%
갈 96
 
2.6%
장 85
 
2.3%
국 82
 
2.3%
정 76
 
2.1%
한 76
 
2.1%
Other values (252) 2449
67.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3148
86.7%
Other Punctuation 252
 
6.9%
Space Separator 195
 
5.4%
Close Punctuation 17
 
0.5%
Open Punctuation 17
 
0.5%
Decimal Number 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
탕 118
 
3.7%
비 110
 
3.5%
식 101
 
3.2%
갈 96
 
3.0%
장 85
 
2.7%
국 82
 
2.6%
정 76
 
2.4%
한 76
 
2.4%
지 63
 
2.0%
구 60
 
1.9%
Other values (244) 2281
72.5%
Decimal Number
ValueCountFrequency (%)
4 1
33.3%
3 1
33.3%
2 1
33.3%
Other Punctuation
ValueCountFrequency (%)
, 244
96.8%
. 8
 
3.2%
Space Separator
ValueCountFrequency (%)
195
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3148
86.7%
Common 484
 
13.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
탕 118
 
3.7%
비 110
 
3.5%
식 101
 
3.2%
갈 96
 
3.0%
장 85
 
2.7%
국 82
 
2.6%
정 76
 
2.4%
한 76
 
2.4%
지 63
 
2.0%
구 60
 
1.9%
Other values (244) 2281
72.5%
Common
ValueCountFrequency (%)
, 244
50.4%
195
40.3%
) 17
 
3.5%
( 17
 
3.5%
. 8
 
1.7%
4 1
 
0.2%
3 1
 
0.2%
2 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3148
86.7%
ASCII 484
 
13.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
, 244
50.4%
195
40.3%
) 17
 
3.5%
( 17
 
3.5%
. 8
 
1.7%
4 1
 
0.2%
3 1
 
0.2%
2 1
 
0.2%
Hangul
ValueCountFrequency (%)
탕 118
 
3.7%
비 110
 
3.5%
식 101
 
3.2%
갈 96
 
3.0%
장 85
 
2.7%
국 82
 
2.6%
정 76
 
2.4%
한 76
 
2.4%
지 63
 
2.0%
구 60
 
1.9%
Other values (244) 2281
72.5%

Missing values

2024-01-10T05:57:24.535293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:57:24.681222image/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천안시(주)방아다리천안시 서북구 쌍용19로 38-5, 1층 (쌍용동)041-579-9222한방오리백숙
1천안시개성집천안시 서북구 한들2로 62 (백석동)041-572-3600감자탕
2천안시개성집천안법원점천안시 동남구 청수5로 3, 2층 203,204,205호 (청당동)041-556-7260장어구이
3천안시경복궁천안시 서북구 성정중7길 9 (성정동)041-565-7776돼지갈비
4천안시경복궁신부점주식회사덕용푸드시스템천안시 동남구 천안천7길 38, 2층 (신부동)041-565-6633짜장, 짬뽕
5천안시금수저천안시 서북구 불당25로 192, 2층 208~210호 (불당동, 골든프라자2)041-567-5957코다리조림
6천안시기가찬참숯민물장어천안시 서북구 천안대로 1048-6, 1동 1층 (두정동)041-523-6008굴비
7천안시노걸대감자탕앤가마삼겹본점천안시 서북구 오성로 134, 1층 (성정동)041-553-7006두부, 보쌈
8천안시녹원천안시 동남구 유량로 140, 1층 (유량동)041-555-3531곤드레밥
9천안시느티나무레스토랑천안시 서북구 성환읍 무내2길 70, 1층041-580-1131순두부
지역업소명주소전화번호주메뉴
628태안군대우식당태안군 태안읍 군청8길 42-4041-674-2934돌솥밥, 백반
629태안군수미정알찬꽃게태안군 안면읍 그네들길 147, 1층041-673-0001간장게장. 게국지
630태안군와우재태안군 이원면 원이로 1849041-672-6699갈비, 칼국수
631태안군양반왕족발보쌈태안군 태안읍 동문1길 59041-675-7020보쌈, 족발
632태안군항구회관태안군 근흥면 신진부두길 134041-675-3330회, 매운탕
633태안군방포수산회타운태안군 안면읍 방포항길 64041-673-4575생선회, 매운탕
634태안군미도락태안군 태안읍 후곡로 110041-675-9208숯불구이, 삼겹살
635태안군딴뚝통나무집식당태안군 안면읍 조운막터길 23-22041-673-3340게국지, 간장게장, 갈치조림
636태안군국일대반점태안군 태안읍 서문5길 19041-674-0313중화요리
637태안군항아리보쌈태안점태안군 태안읍 군청8길 19041-675-0023보쌈, 쟁반구수, 육개장