Overview

Dataset statistics

Number of variables5
Number of observations235
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.5 KiB
Average record size in memory41.6 B

Variable types

Numeric1
Text2
Categorical2

Dataset

Description농림안전축산식품부에서 주관하는 각 지역별 안심식당 지정제도에 대해공고 및 현장 방문을 통해 지정된 충남형 The 안심식당에 대한 업소 목록
Author충청남도 예산군
URLhttps://www.data.go.kr/data/15125348/fileData.do

Alerts

연번 is highly overall correlated with 비고High correlation
비고 is highly overall correlated with 연번High correlation
업종 상세 is highly imbalanced (73.8%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:52:28.473399
Analysis finished2023-12-16 15:52:30.723337
Duration2.25 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct235
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean118
Minimum1
Maximum235
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2023-12-16T15:52:31.037882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile12.7
Q159.5
median118
Q3176.5
95-th percentile223.3
Maximum235
Range234
Interquartile range (IQR)117

Descriptive statistics

Standard deviation67.982841
Coefficient of variation (CV)0.57612577
Kurtosis-1.2
Mean118
Median Absolute Deviation (MAD)59
Skewness0
Sum27730
Variance4621.6667
MonotonicityStrictly increasing
2023-12-16T15:52:31.979579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
163 1
 
0.4%
151 1
 
0.4%
152 1
 
0.4%
153 1
 
0.4%
154 1
 
0.4%
155 1
 
0.4%
156 1
 
0.4%
157 1
 
0.4%
158 1
 
0.4%
Other values (225) 225
95.7%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
235 1
0.4%
234 1
0.4%
233 1
0.4%
232 1
0.4%
231 1
0.4%
230 1
0.4%
229 1
0.4%
228 1
0.4%
227 1
0.4%
226 1
0.4%

업소명
Text

Distinct231
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-16T15:52:33.344424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length15
Mean length5.5489362
Min length2

Characters and Unicode

Total characters1304
Distinct characters300
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

Unique227 ?
Unique (%)96.6%

Sample

1st row153포인츠부대찌개예산점
2nd row거북이식당
3rd row고덕갈비
4th row금강장어구이
5th row내가조선의한우다
ValueCountFrequency (%)
송담추어탕 2
 
0.8%
아리산 2
 
0.8%
대흥식당 2
 
0.8%
토속식당 2
 
0.8%
천사김밥 1
 
0.4%
미가복집 1
 
0.4%
153포인츠부대찌개예산점 1
 
0.4%
영남식당 1
 
0.4%
양지한우타운식당 1
 
0.4%
명품한우식당 1
 
0.4%
Other values (222) 222
94.1%
2023-12-16T15:52:34.998556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
당 56
 
4.3%
식 49
 
3.8%
가 40
 
3.1%
산 31
 
2.4%
예 27
 
2.1%
장 23
 
1.8%
수 23
 
1.8%
어 22
 
1.7%
대 20
 
1.5%
한 20
 
1.5%
Other values (290) 993
76.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1272
97.5%
Open Punctuation 10
 
0.8%
Close Punctuation 10
 
0.8%
Decimal Number 7
 
0.5%
Other Punctuation 3
 
0.2%
Space Separator 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
당 56
 
4.4%
식 49
 
3.9%
가 40
 
3.1%
산 31
 
2.4%
예 27
 
2.1%
장 23
 
1.8%
수 23
 
1.8%
어 22
 
1.7%
대 20
 
1.6%
한 20
 
1.6%
Other values (280) 961
75.6%
Decimal Number
ValueCountFrequency (%)
0 2
28.6%
9 2
28.6%
3 1
14.3%
1 1
14.3%
5 1
14.3%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
. 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1272
97.5%
Common 32
 
2.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
당 56
 
4.4%
식 49
 
3.9%
가 40
 
3.1%
산 31
 
2.4%
예 27
 
2.1%
장 23
 
1.8%
수 23
 
1.8%
어 22
 
1.7%
대 20
 
1.6%
한 20
 
1.6%
Other values (280) 961
75.6%
Common
ValueCountFrequency (%)
( 10
31.2%
) 10
31.2%
2
 
6.2%
0 2
 
6.2%
& 2
 
6.2%
9 2
 
6.2%
. 1
 
3.1%
3 1
 
3.1%
1 1
 
3.1%
5 1
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1272
97.5%
ASCII 32
 
2.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
당 56
 
4.4%
식 49
 
3.9%
가 40
 
3.1%
산 31
 
2.4%
예 27
 
2.1%
장 23
 
1.8%
수 23
 
1.8%
어 22
 
1.7%
대 20
 
1.6%
한 20
 
1.6%
Other values (280) 961
75.6%
ASCII
ValueCountFrequency (%)
( 10
31.2%
) 10
31.2%
2
 
6.2%
0 2
 
6.2%
& 2
 
6.2%
9 2
 
6.2%
. 1
 
3.1%
3 1
 
3.1%
1 1
 
3.1%
5 1
 
3.1%

주소
Text

Distinct226
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-16T15:52:36.636281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length19
Mean length13.651064
Min length9

Characters and Unicode

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

Unique

Unique217 ?
Unique (%)92.3%

Sample

1st row예산읍 금오대로 144
2nd row덕산면 수덕사안길 37-1
3rd row덕산면 덕산온천로 371-8
4th row오가면 오가중앙로 125
5th row광시면 예당로 127-1
ValueCountFrequency (%)
예산읍 103
 
13.2%
예산군 60
 
7.7%
덕산면 40
 
5.1%
삽교읍 30
 
3.8%
벚꽃로 17
 
2.2%
예당로 16
 
2.0%
수덕사안길 15
 
1.9%
덕산온천로 12
 
1.5%
금오대로 11
 
1.4%
광시면 10
 
1.3%
Other values (271) 467
59.8%
2023-12-16T15:52:39.006070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
548
17.1%
산 252
 
7.9%
예 196
 
6.1%
로 184
 
5.7%
1 181
 
5.6%
읍 134
 
4.2%
면 104
 
3.2%
2 99
 
3.1%
3 91
 
2.8%
덕 85
 
2.6%
Other values (108) 1334
41.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1839
57.3%
Decimal Number 760
23.7%
Space Separator 548
 
17.1%
Dash Punctuation 55
 
1.7%
Other Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%
Close Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 252
 
13.7%
예 196
 
10.7%
로 184
 
10.0%
읍 134
 
7.3%
면 104
 
5.7%
덕 85
 
4.6%
길 81
 
4.4%
군 61
 
3.3%
교 36
 
2.0%
사 36
 
2.0%
Other values (93) 670
36.4%
Decimal Number
ValueCountFrequency (%)
1 181
23.8%
2 99
13.0%
3 91
12.0%
4 67
 
8.8%
5 66
 
8.7%
9 58
 
7.6%
0 54
 
7.1%
6 54
 
7.1%
7 53
 
7.0%
8 37
 
4.9%
Space Separator
ValueCountFrequency (%)
548
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 55
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1839
57.3%
Common 1369
42.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 252
 
13.7%
예 196
 
10.7%
로 184
 
10.0%
읍 134
 
7.3%
면 104
 
5.7%
덕 85
 
4.6%
길 81
 
4.4%
군 61
 
3.3%
교 36
 
2.0%
사 36
 
2.0%
Other values (93) 670
36.4%
Common
ValueCountFrequency (%)
548
40.0%
1 181
 
13.2%
2 99
 
7.2%
3 91
 
6.6%
4 67
 
4.9%
5 66
 
4.8%
9 58
 
4.2%
- 55
 
4.0%
0 54
 
3.9%
6 54
 
3.9%
Other values (5) 96
 
7.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1839
57.3%
ASCII 1369
42.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
548
40.0%
1 181
 
13.2%
2 99
 
7.2%
3 91
 
6.6%
4 67
 
4.9%
5 66
 
4.8%
9 58
 
4.2%
- 55
 
4.0%
0 54
 
3.9%
6 54
 
3.9%
Other values (5) 96
 
7.0%
Hangul
ValueCountFrequency (%)
산 252
 
13.7%
예 196
 
10.7%
로 184
 
10.0%
읍 134
 
7.3%
면 104
 
5.7%
덕 85
 
4.6%
길 81
 
4.4%
군 61
 
3.3%
교 36
 
2.0%
사 36
 
2.0%
Other values (93) 670
36.4%

업종 상세
Categorical

IMBALANCE 

Distinct6
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
한식
210 
중식
 
13
서양식
 
7
일식
 
2
분식
 
2

Length

Max length3
Median length2
Mean length2.0340426
Min length2

Unique

Unique1 ?
Unique (%)0.4%

Sample

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

Common Values

ValueCountFrequency (%)
한식 210
89.4%
중식 13
 
5.5%
서양식 7
 
3.0%
일식 2
 
0.9%
분식 2
 
0.9%
뷔페식 1
 
0.4%

Length

2023-12-16T15:52:39.904484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:52:40.507826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한식 210
89.4%
중식 13
 
5.5%
서양식 7
 
3.0%
일식 2
 
0.9%
분식 2
 
0.9%
뷔페식 1
 
0.4%

비고
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2022년 재지정업소
85 
2021년 지정업소
60 
2022년 지정업소
60 
2023년 지정업소
30 

Length

Max length11
Median length10
Mean length10.361702
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022년 재지정업소
2nd row2022년 재지정업소
3rd row2022년 재지정업소
4th row2022년 재지정업소
5th row2022년 재지정업소

Common Values

ValueCountFrequency (%)
2022년 재지정업소 85
36.2%
2021년 지정업소 60
25.5%
2022년 지정업소 60
25.5%
2023년 지정업소 30
 
12.8%

Length

2023-12-16T15:52:41.262234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:52:41.662181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
지정업소 150
31.9%
2022년 145
30.9%
재지정업소 85
18.1%
2021년 60
 
12.8%
2023년 30
 
6.4%

Interactions

2023-12-16T15:52:29.498816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T15:52:42.182182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종 상세비고
연번1.0000.2500.970
업종 상세0.2501.0000.121
비고0.9700.1211.000
2023-12-16T15:52:42.643932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비고업종 상세
비고1.0000.078
업종 상세0.0781.000
2023-12-16T15:52:43.033899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종 상세비고
연번1.0000.1330.900
업종 상세0.1331.0000.078
비고0.9000.0781.000

Missing values

2023-12-16T15:52:29.962305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:52:30.403022image/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

연번업소명주소업종 상세비고
01153포인츠부대찌개예산점예산읍 금오대로 144한식2022년 재지정업소
12거북이식당덕산면 수덕사안길 37-1한식2022년 재지정업소
23고덕갈비덕산면 덕산온천로 371-8한식2022년 재지정업소
34금강장어구이오가면 오가중앙로 125한식2022년 재지정업소
45내가조선의한우다광시면 예당로 127-1한식2022년 재지정업소
56대보건설(주)예산(당진방향)휴게소(한식)신양면 당진영덕고속도로 33한식2022년 재지정업소
67동흥루예산읍 예산로 220-1중식2022년 재지정업소
78두멍덕산면 광천홍암길 83-5한식2022년 재지정업소
89뜨끈이식당덕산면 덕산온천로 331-6한식2022년 재지정업소
910매일한우타운식당광시면 예당로 155한식2022년 재지정업소
연번업소명주소업종 상세비고
225226예산순대국밥대술면 차동로 967한식2023년 지정업소
226227중국성대술면 대술로 124중식2023년 지정업소
227228친구네가든대술면 산정동길 15한식2023년 지정업소
228229좋은친구네집예산읍 예산로 233한식2023년 지정업소
229230김재춘인생김밥예산읍 예산로 194번길 10한식2023년 지정업소
230231봉산식당봉산면 봉산로 364한식2023년 지정업소
231232봉림느티나무가든봉산면 봉운로 515-21한식2023년 지정업소
232233김가네김밥예산점예산읍 벚꽃로 155번길 20한식2023년 지정업소
233234예산갈비예산읍 교남길 55-1한식2023년 지정업소
234235상숙이네쭈꾸미신암면 용산로 1한식2023년 지정업소