Overview

Dataset statistics

Number of variables6
Number of observations167
Missing cells2
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.1 KiB
Average record size in memory49.8 B

Variable types

Numeric1
Text4
Categorical1

Dataset

Description충청북도 밥맛좋은 집 지정업소 현황에 대한 csv 데이터입니다.(연번, 업소명, 시군명, 세부주소, 전화번호, 비고 등)
URLhttps://www.data.go.kr/data/15056470/fileData.do

Alerts

번호 is highly overall correlated with 시군명High correlation
시군명 is highly overall correlated with 번호High correlation
전화번호 has 2 (1.2%) missing valuesMissing
번호 has unique valuesUnique
업 소 명 has unique valuesUnique
세부주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:33:08.406260
Analysis finished2023-12-12 06:33:09.156654
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct167
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean84
Minimum1
Maximum167
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-12T15:33:09.227975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.3
Q142.5
median84
Q3125.5
95-th percentile158.7
Maximum167
Range166
Interquartile range (IQR)83

Descriptive statistics

Standard deviation48.35287
Coefficient of variation (CV)0.5756294
Kurtosis-1.2
Mean84
Median Absolute Deviation (MAD)42
Skewness0
Sum14028
Variance2338
MonotonicityStrictly increasing
2023-12-12T15:33:09.415301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
116 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
Other values (157) 157
94.0%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
167 1
0.6%
166 1
0.6%
165 1
0.6%
164 1
0.6%
163 1
0.6%
162 1
0.6%
161 1
0.6%
160 1
0.6%
159 1
0.6%
158 1
0.6%

업 소 명
Text

UNIQUE 

Distinct167
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T15:33:09.815538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length5.2035928
Min length2

Characters and Unicode

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

Unique

Unique167 ?
Unique (%)100.0%

Sample

1st row즐거운나의집돌솥밥
2nd row사또가든
3rd row마중가는길
4th row오소담
5th row김가네더덕밥
ValueCountFrequency (%)
즐거운나의집돌솥밥 1
 
0.6%
한천가든 1
 
0.6%
옥천해뜨는집가든 1
 
0.6%
지선생쌈촌 1
 
0.6%
토박이식당 1
 
0.6%
연이네해장국사골곰탕 1
 
0.6%
진수성찬 1
 
0.6%
보성복전문 1
 
0.6%
오아시스가든 1
 
0.6%
사랑채 1
 
0.6%
Other values (165) 165
94.3%
2023-12-12T15:33:10.668838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
가 38
 
4.4%
식 19
 
2.2%
탕 19
 
2.2%
집 18
 
2.1%
든 17
 
2.0%
리 17
 
2.0%
마 16
 
1.8%
당 14
 
1.6%
밥 14
 
1.6%
이 13
 
1.5%
Other values (233) 684
78.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 849
97.7%
Space Separator 11
 
1.3%
Other Punctuation 3
 
0.3%
Close Punctuation 2
 
0.2%
Open Punctuation 2
 
0.2%
Decimal Number 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
가 38
 
4.5%
식 19
 
2.2%
탕 19
 
2.2%
집 18
 
2.1%
든 17
 
2.0%
리 17
 
2.0%
마 16
 
1.9%
당 14
 
1.6%
밥 14
 
1.6%
이 13
 
1.5%
Other values (227) 664
78.2%
Decimal Number
ValueCountFrequency (%)
5 1
50.0%
2 1
50.0%
Space Separator
ValueCountFrequency (%)
11
100.0%
Other Punctuation
ValueCountFrequency (%)
· 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 849
97.7%
Common 20
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
가 38
 
4.5%
식 19
 
2.2%
탕 19
 
2.2%
집 18
 
2.1%
든 17
 
2.0%
리 17
 
2.0%
마 16
 
1.9%
당 14
 
1.6%
밥 14
 
1.6%
이 13
 
1.5%
Other values (227) 664
78.2%
Common
ValueCountFrequency (%)
11
55.0%
· 3
 
15.0%
) 2
 
10.0%
( 2
 
10.0%
5 1
 
5.0%
2 1
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 849
97.7%
ASCII 17
 
2.0%
None 3
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
가 38
 
4.5%
식 19
 
2.2%
탕 19
 
2.2%
집 18
 
2.1%
든 17
 
2.0%
리 17
 
2.0%
마 16
 
1.9%
당 14
 
1.6%
밥 14
 
1.6%
이 13
 
1.5%
Other values (227) 664
78.2%
ASCII
ValueCountFrequency (%)
11
64.7%
) 2
 
11.8%
( 2
 
11.8%
5 1
 
5.9%
2 1
 
5.9%
None
ValueCountFrequency (%)
· 3
100.0%

시군명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
청주시
52 
충주시
22 
제천시
18 
진천군
14 
증평군
11 
Other values (6)
50 

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 (%)
청주시 52
31.1%
충주시 22
13.2%
제천시 18
 
10.8%
진천군 14
 
8.4%
증평군 11
 
6.6%
보은군 10
 
6.0%
옥천군 10
 
6.0%
영동군 9
 
5.4%
단양군 9
 
5.4%
음성군 8
 
4.8%

Length

2023-12-12T15:33:10.845643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
청주시 52
31.1%
충주시 22
13.2%
제천시 18
 
10.8%
진천군 14
 
8.4%
증평군 11
 
6.6%
보은군 10
 
6.0%
옥천군 10
 
6.0%
영동군 9
 
5.4%
단양군 9
 
5.4%
음성군 8
 
4.8%

세부주소
Text

UNIQUE 

Distinct167
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T15:33:11.192977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length19
Mean length13.047904
Min length6

Characters and Unicode

Total characters2179
Distinct characters184
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

Unique167 ?
Unique (%)100.0%

Sample

1st row상당구 영운천로 153번길 36
2nd row청원구 오창읍 꽃화산길51-1
3rd row상당구 문의면 대청호반로 845-5
4th row상당구 낭성면 지산나박실길 4
5th row서원구 대림로421번길 24
ValueCountFrequency (%)
상당구 13
 
2.6%
청원구 12
 
2.4%
증평읍 11
 
2.2%
청주시 10
 
2.0%
보은읍 8
 
1.6%
단양읍 7
 
1.4%
흥덕구 6
 
1.2%
서원구 6
 
1.2%
진천읍 6
 
1.2%
내수읍 4
 
0.8%
Other values (345) 412
83.2%
2023-12-12T15:33:11.697236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
332
 
15.2%
로 117
 
5.4%
1 114
 
5.2%
길 82
 
3.8%
2 74
 
3.4%
4 59
 
2.7%
읍 56
 
2.6%
6 55
 
2.5%
구 54
 
2.5%
면 53
 
2.4%
Other values (174) 1183
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1236
56.7%
Decimal Number 536
24.6%
Space Separator 332
 
15.2%
Dash Punctuation 37
 
1.7%
Open Punctuation 17
 
0.8%
Close Punctuation 17
 
0.8%
Other Punctuation 4
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 117
 
9.5%
길 82
 
6.6%
읍 56
 
4.5%
구 54
 
4.4%
면 53
 
4.3%
청 38
 
3.1%
원 37
 
3.0%
산 28
 
2.3%
동 27
 
2.2%
천 26
 
2.1%
Other values (159) 718
58.1%
Decimal Number
ValueCountFrequency (%)
1 114
21.3%
2 74
13.8%
4 59
11.0%
6 55
10.3%
5 49
9.1%
3 48
9.0%
8 38
 
7.1%
7 38
 
7.1%
9 33
 
6.2%
0 28
 
5.2%
Space Separator
ValueCountFrequency (%)
332
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1236
56.7%
Common 943
43.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 117
 
9.5%
길 82
 
6.6%
읍 56
 
4.5%
구 54
 
4.4%
면 53
 
4.3%
청 38
 
3.1%
원 37
 
3.0%
산 28
 
2.3%
동 27
 
2.2%
천 26
 
2.1%
Other values (159) 718
58.1%
Common
ValueCountFrequency (%)
332
35.2%
1 114
 
12.1%
2 74
 
7.8%
4 59
 
6.3%
6 55
 
5.8%
5 49
 
5.2%
3 48
 
5.1%
8 38
 
4.0%
7 38
 
4.0%
- 37
 
3.9%
Other values (5) 99
 
10.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1236
56.7%
ASCII 943
43.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
332
35.2%
1 114
 
12.1%
2 74
 
7.8%
4 59
 
6.3%
6 55
 
5.8%
5 49
 
5.2%
3 48
 
5.1%
8 38
 
4.0%
7 38
 
4.0%
- 37
 
3.9%
Other values (5) 99
 
10.5%
Hangul
ValueCountFrequency (%)
로 117
 
9.5%
길 82
 
6.6%
읍 56
 
4.5%
구 54
 
4.4%
면 53
 
4.3%
청 38
 
3.1%
원 37
 
3.0%
산 28
 
2.3%
동 27
 
2.2%
천 26
 
2.1%
Other values (159) 718
58.1%

전화번호
Text

MISSING 

Distinct165
Distinct (%)100.0%
Missing2
Missing (%)1.2%
Memory size1.4 KiB
2023-12-12T15:33:11.995106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.018182
Min length9

Characters and Unicode

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

Unique165 ?
Unique (%)100.0%

Sample

1st row043-298-5285
2nd row043-212-7072
3rd row043-288-1259
4th row043-221-7330
5th row043-236-0789
ValueCountFrequency (%)
043-236-3392 1
 
0.6%
0507-1360-6628 1
 
0.6%
043-733-1780 1
 
0.6%
043-733-3292 1
 
0.6%
043-732-3786 1
 
0.6%
0507-1368 1
 
0.6%
043-732-6627 1
 
0.6%
043-743-4985 1
 
0.6%
043-744-8736 1
 
0.6%
043-745-6004 1
 
0.6%
Other values (155) 155
93.9%
2023-12-12T15:33:12.427173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 329
16.6%
3 307
15.5%
0 277
14.0%
4 265
13.4%
2 169
8.5%
8 144
7.3%
5 131
 
6.6%
7 101
 
5.1%
6 92
 
4.6%
1 89
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1654
83.4%
Dash Punctuation 329
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 307
18.6%
0 277
16.7%
4 265
16.0%
2 169
10.2%
8 144
8.7%
5 131
7.9%
7 101
 
6.1%
6 92
 
5.6%
1 89
 
5.4%
9 79
 
4.8%
Dash Punctuation
ValueCountFrequency (%)
- 329
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1983
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 329
16.6%
3 307
15.5%
0 277
14.0%
4 265
13.4%
2 169
8.5%
8 144
7.3%
5 131
 
6.6%
7 101
 
5.1%
6 92
 
4.6%
1 89
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1983
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 329
16.6%
3 307
15.5%
0 277
14.0%
4 265
13.4%
2 169
8.5%
8 144
7.3%
5 131
 
6.6%
7 101
 
5.1%
6 92
 
4.6%
1 89
 
4.5%

비고
Text

Distinct132
Distinct (%)79.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T15:33:12.720586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length16
Mean length5.8562874
Min length2

Characters and Unicode

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

Unique

Unique119 ?
Unique (%)71.3%

Sample

1st row돌솥정식
2nd row청국장
3rd row가마솥밥한정식
4th row두부정식
5th row더덕한정식
ValueCountFrequency (%)
추어탕 9
 
4.5%
청국장 8
 
4.0%
한정식 6
 
3.0%
곤드레밥 5
 
2.5%
순두부찌개 5
 
2.5%
갈비탕 5
 
2.5%
김치찌개 3
 
1.5%
우렁쌈밥 3
 
1.5%
된장찌개 3
 
1.5%
민물매운탕 3
 
1.5%
Other values (135) 150
75.0%
2023-12-12T15:33:13.159730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
정 44
 
4.5%
식 43
 
4.4%
밥 41
 
4.2%
탕 37
 
3.8%
, 36
 
3.7%
36
 
3.7%
장 26
 
2.7%
솥 19
 
1.9%
개 18
 
1.8%
리 18
 
1.8%
Other values (152) 660
67.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 905
92.5%
Other Punctuation 37
 
3.8%
Space Separator 36
 
3.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 44
 
4.9%
식 43
 
4.8%
밥 41
 
4.5%
탕 37
 
4.1%
장 26
 
2.9%
솥 19
 
2.1%
개 18
 
2.0%
리 18
 
2.0%
찌 18
 
2.0%
두 17
 
1.9%
Other values (149) 624
69.0%
Other Punctuation
ValueCountFrequency (%)
, 36
97.3%
· 1
 
2.7%
Space Separator
ValueCountFrequency (%)
36
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 905
92.5%
Common 73
 
7.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 44
 
4.9%
식 43
 
4.8%
밥 41
 
4.5%
탕 37
 
4.1%
장 26
 
2.9%
솥 19
 
2.1%
개 18
 
2.0%
리 18
 
2.0%
찌 18
 
2.0%
두 17
 
1.9%
Other values (149) 624
69.0%
Common
ValueCountFrequency (%)
, 36
49.3%
36
49.3%
· 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 905
92.5%
ASCII 72
 
7.4%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
정 44
 
4.9%
식 43
 
4.8%
밥 41
 
4.5%
탕 37
 
4.1%
장 26
 
2.9%
솥 19
 
2.1%
개 18
 
2.0%
리 18
 
2.0%
찌 18
 
2.0%
두 17
 
1.9%
Other values (149) 624
69.0%
ASCII
ValueCountFrequency (%)
, 36
50.0%
36
50.0%
None
ValueCountFrequency (%)
· 1
100.0%

Interactions

2023-12-12T15:33:08.841907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:33:13.264500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호시군명
번호1.0000.926
시군명0.9261.000
2023-12-12T15:33:13.363711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호시군명
번호1.0000.737
시군명0.7371.000

Missing values

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

번호업 소 명시군명세부주소전화번호비고
01즐거운나의집돌솥밥청주시상당구 영운천로 153번길 36043-298-5285돌솥정식
12사또가든청주시청원구 오창읍 꽃화산길51-1043-212-7072청국장
23마중가는길청주시상당구 문의면 대청호반로 845-5043-288-1259가마솥밥한정식
34오소담청주시상당구 낭성면 지산나박실길 4043-221-7330두부정식
45김가네더덕밥청주시서원구 대림로421번길 24043-236-0789더덕한정식
56신항도복집청주시청원구 우암로 59043-287-7192복지리
67활력추어탕청주시상당구 월평로184번길 106043-294-1020추어탕
78황소고집청주시청원구 오창읍 용두길 72043-211-5550청국장돌솥밥정식
89돌뫼마을청주시청원구 내수읍 청암로371043-213-4204우리콩손두부전골
910이티성영토청주시상당구 미원면 미원초정로978043-296-0801곤드레밥정식
번호업 소 명시군명세부주소전화번호비고
157158소담밥집음성군음성군 생극면 음성로 1725043-878-0870황태더덕정식
158159성원마늘약선요리단양군단양읍 삼봉로 59043-421-8777마늘약선정식
159160벌집식당단양군단양읍 별곡9길 16043-422-2872곤드레솥밥
160161장다리마늘약선단양군단양읍 삼봉로 370043-423-3960마늘정식
161162고향집두부단양군대강면 단양로 68043-421-0150해물순두부
162163영상강가든단양군영춘면 남천 계곡로 41043-423-0573산채더덕정식
163164단양팔각정단양군단양읍 수변로 95043-422-8165팔각정수라상
164165대교약선요리단양군단양읍 별곡9길 15043-421-3599버섯전골, 마늘정식
165166계절그리기단양군단양읍 다리안로 499043-422-8836곤드레밥
166167가연단양군단양읍 삼봉로 870507-1321-4805마늘떡갈비