Overview

Dataset statistics

Number of variables5
Number of observations871
Missing cells3
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory35.0 KiB
Average record size in memory41.2 B

Variable types

Numeric1
Categorical1
Text2
DateTime1

Dataset

Description증평군에 위치한 모범음식점 업소명, 주소, 연락처, 업종 정보 링크주소: https://www.jp.go.kr/kor/cop/bbs/BBSMSTR_000000000526/selectBoardArticle.do?nttId=B00000013975hp4kZ8vj&kind=&mno=sitemap_12&pageIndex=1&searchCnd=&searchWrd= ## LINK 미리보기 [![미리보기](http://curate.gimi9.com/linkview/www-data-go-kr-data-filedata-3041649?url=https%3A//www.jp.go.kr/kor/cop/bbs/BBSMSTR_000000000526/selectBoardList.do&version=d7)](https://www.data.go.kr/data/3041649/fileData.do)
URLhttps://www.data.go.kr/data/3041649/fileData.do

Alerts

연번 is highly overall correlated with 업종명High correlation
업종명 is highly overall correlated with 연번High correlation
업종명 is highly imbalanced (54.2%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:37:54.807115
Analysis finished2023-12-12 14:37:55.775819
Duration0.97 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct871
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean436
Minimum1
Maximum871
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.8 KiB
2023-12-12T23:37:55.869762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile44.5
Q1218.5
median436
Q3653.5
95-th percentile827.5
Maximum871
Range870
Interquartile range (IQR)435

Descriptive statistics

Standard deviation251.58034
Coefficient of variation (CV)0.57701912
Kurtosis-1.2
Mean436
Median Absolute Deviation (MAD)218
Skewness0
Sum379756
Variance63292.667
MonotonicityStrictly increasing
2023-12-12T23:37:56.026206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
586 1
 
0.1%
575 1
 
0.1%
576 1
 
0.1%
577 1
 
0.1%
578 1
 
0.1%
579 1
 
0.1%
580 1
 
0.1%
581 1
 
0.1%
582 1
 
0.1%
Other values (861) 861
98.9%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
871 1
0.1%
870 1
0.1%
869 1
0.1%
868 1
0.1%
867 1
0.1%
866 1
0.1%
865 1
0.1%
864 1
0.1%
863 1
0.1%
862 1
0.1%

업종명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct6
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
일반음식점
654 
휴게음식점
147 
유흥주점영업
 
33
위탁급식영업
 
14
제과점영업
 
13

Length

Max length6
Median length5
Mean length5.0424799
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반음식점
2nd row일반음식점
3rd row일반음식점
4th row일반음식점
5th row일반음식점

Common Values

ValueCountFrequency (%)
일반음식점 654
75.1%
휴게음식점 147
 
16.9%
유흥주점영업 33
 
3.8%
위탁급식영업 14
 
1.6%
제과점영업 13
 
1.5%
단란주점 10
 
1.1%

Length

2023-12-12T23:37:56.163632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:56.313376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 654
75.1%
휴게음식점 147
 
16.9%
유흥주점영업 33
 
3.8%
위탁급식영업 14
 
1.6%
제과점영업 13
 
1.5%
단란주점 10
 
1.1%
Distinct870
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
2023-12-12T23:37:56.600861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length24
Mean length6.8105626
Min length2

Characters and Unicode

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

Unique

Unique869 ?
Unique (%)99.8%

Sample

1st row복성원
2nd row차부식당
3rd row아지트
4th row장인자연산 버섯찌게
5th row증평감자탕
ValueCountFrequency (%)
증평점 62
 
5.0%
충북증평점 18
 
1.4%
세븐일레븐 13
 
1.0%
카페 9
 
0.7%
증평 6
 
0.5%
노래타운 5
 
0.4%
5
 
0.4%
씨유 4
 
0.3%
이마트24 4
 
0.3%
cafe 3
 
0.2%
Other values (1070) 1120
89.7%
2023-12-12T23:37:57.330932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
379
 
6.4%
179
 
3.0%
176
 
3.0%
175
 
3.0%
97
 
1.6%
79
 
1.3%
75
 
1.3%
65
 
1.1%
61
 
1.0%
59
 
1.0%
Other values (620) 4587
77.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4980
84.0%
Space Separator 379
 
6.4%
Uppercase Letter 211
 
3.6%
Lowercase Letter 147
 
2.5%
Decimal Number 102
 
1.7%
Close Punctuation 43
 
0.7%
Open Punctuation 42
 
0.7%
Other Punctuation 27
 
0.5%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
179
 
3.6%
176
 
3.5%
175
 
3.5%
97
 
1.9%
79
 
1.6%
75
 
1.5%
65
 
1.3%
61
 
1.2%
59
 
1.2%
52
 
1.0%
Other values (556) 3962
79.6%
Uppercase Letter
ValueCountFrequency (%)
C 28
13.3%
A 18
 
8.5%
S 18
 
8.5%
G 15
 
7.1%
O 13
 
6.2%
B 11
 
5.2%
E 11
 
5.2%
T 11
 
5.2%
H 11
 
5.2%
R 10
 
4.7%
Other values (12) 65
30.8%
Lowercase Letter
ValueCountFrequency (%)
e 20
13.6%
a 14
 
9.5%
o 13
 
8.8%
l 13
 
8.8%
r 11
 
7.5%
n 9
 
6.1%
s 9
 
6.1%
i 8
 
5.4%
u 8
 
5.4%
t 7
 
4.8%
Other values (12) 35
23.8%
Decimal Number
ValueCountFrequency (%)
2 24
23.5%
5 16
15.7%
3 13
12.7%
9 9
 
8.8%
4 9
 
8.8%
0 8
 
7.8%
1 8
 
7.8%
8 6
 
5.9%
6 5
 
4.9%
7 4
 
3.9%
Other Punctuation
ValueCountFrequency (%)
& 15
55.6%
, 8
29.6%
: 1
 
3.7%
# 1
 
3.7%
1
 
3.7%
. 1
 
3.7%
Space Separator
ValueCountFrequency (%)
379
100.0%
Close Punctuation
ValueCountFrequency (%)
) 43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 42
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4975
83.9%
Common 594
 
10.0%
Latin 358
 
6.0%
Han 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
179
 
3.6%
176
 
3.5%
175
 
3.5%
97
 
1.9%
79
 
1.6%
75
 
1.5%
65
 
1.3%
61
 
1.2%
59
 
1.2%
52
 
1.0%
Other values (552) 3957
79.5%
Latin
ValueCountFrequency (%)
C 28
 
7.8%
e 20
 
5.6%
A 18
 
5.0%
S 18
 
5.0%
G 15
 
4.2%
a 14
 
3.9%
o 13
 
3.6%
l 13
 
3.6%
O 13
 
3.6%
B 11
 
3.1%
Other values (34) 195
54.5%
Common
ValueCountFrequency (%)
379
63.8%
) 43
 
7.2%
( 42
 
7.1%
2 24
 
4.0%
5 16
 
2.7%
& 15
 
2.5%
3 13
 
2.2%
9 9
 
1.5%
4 9
 
1.5%
0 8
 
1.3%
Other values (10) 36
 
6.1%
Han
ValueCountFrequency (%)
2
40.0%
1
20.0%
1
20.0%
1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4973
83.8%
ASCII 951
 
16.0%
CJK 5
 
0.1%
Compat Jamo 2
 
< 0.1%
Punctuation 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
379
39.9%
) 43
 
4.5%
( 42
 
4.4%
C 28
 
2.9%
2 24
 
2.5%
e 20
 
2.1%
A 18
 
1.9%
S 18
 
1.9%
5 16
 
1.7%
& 15
 
1.6%
Other values (53) 348
36.6%
Hangul
ValueCountFrequency (%)
179
 
3.6%
176
 
3.5%
175
 
3.5%
97
 
2.0%
79
 
1.6%
75
 
1.5%
65
 
1.3%
61
 
1.2%
59
 
1.2%
52
 
1.0%
Other values (551) 3955
79.5%
Compat Jamo
ValueCountFrequency (%)
2
100.0%
CJK
ValueCountFrequency (%)
2
40.0%
1
20.0%
1
20.0%
1
20.0%
Punctuation
ValueCountFrequency (%)
1
100.0%
Distinct787
Distinct (%)90.7%
Missing3
Missing (%)0.3%
Memory size6.9 KiB
2023-12-12T23:37:57.691783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length43
Mean length23.491935
Min length18

Characters and Unicode

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

Unique

Unique717 ?
Unique (%)82.6%

Sample

1st row충청북도 증평군 증평읍 광장로 97
2nd row충청북도 증평군 증평읍 광장로 91
3rd row충청북도 증평군 증평읍 윗장뜰길 43
4th row충청북도 증평군 증평읍 중앙로 238
5th row충청북도 증평군 증평읍 광장로 91
ValueCountFrequency (%)
충청북도 868
17.7%
증평군 868
17.7%
증평읍 833
17.0%
1층 283
 
5.8%
윗장뜰길 72
 
1.5%
중앙로 71
 
1.4%
광장로 66
 
1.3%
초중로 62
 
1.3%
장뜰로 52
 
1.1%
2층 41
 
0.8%
Other values (531) 1688
34.4%
2023-12-12T23:37:58.279216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4037
19.8%
1735
 
8.5%
1732
 
8.5%
1 1025
 
5.0%
904
 
4.4%
877
 
4.3%
877
 
4.3%
876
 
4.3%
868
 
4.3%
833
 
4.1%
Other values (219) 6627
32.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12559
61.6%
Space Separator 4037
 
19.8%
Decimal Number 3103
 
15.2%
Other Punctuation 422
 
2.1%
Dash Punctuation 181
 
0.9%
Close Punctuation 28
 
0.1%
Open Punctuation 28
 
0.1%
Uppercase Letter 25
 
0.1%
Lowercase Letter 8
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1735
13.8%
1732
13.8%
904
 
7.2%
877
 
7.0%
877
 
7.0%
876
 
7.0%
868
 
6.9%
833
 
6.6%
595
 
4.7%
409
 
3.3%
Other values (183) 2853
22.7%
Uppercase Letter
ValueCountFrequency (%)
S 4
16.0%
K 4
16.0%
B 4
16.0%
A 2
8.0%
C 2
8.0%
L 2
8.0%
H 2
8.0%
N 1
 
4.0%
G 1
 
4.0%
T 1
 
4.0%
Other values (2) 2
8.0%
Decimal Number
ValueCountFrequency (%)
1 1025
33.0%
2 408
 
13.1%
0 271
 
8.7%
3 269
 
8.7%
4 217
 
7.0%
6 216
 
7.0%
5 215
 
6.9%
7 197
 
6.3%
8 147
 
4.7%
9 138
 
4.4%
Lowercase Letter
ValueCountFrequency (%)
s 3
37.5%
i 1
 
12.5%
g 1
 
12.5%
o 1
 
12.5%
u 1
 
12.5%
e 1
 
12.5%
Other Punctuation
ValueCountFrequency (%)
, 418
99.1%
# 2
 
0.5%
. 1
 
0.2%
/ 1
 
0.2%
Space Separator
ValueCountFrequency (%)
4037
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 181
100.0%
Close Punctuation
ValueCountFrequency (%)
) 28
100.0%
Open Punctuation
ValueCountFrequency (%)
( 28
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12559
61.6%
Common 7799
38.2%
Latin 33
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1735
13.8%
1732
13.8%
904
 
7.2%
877
 
7.0%
877
 
7.0%
876
 
7.0%
868
 
6.9%
833
 
6.6%
595
 
4.7%
409
 
3.3%
Other values (183) 2853
22.7%
Common
ValueCountFrequency (%)
4037
51.8%
1 1025
 
13.1%
, 418
 
5.4%
2 408
 
5.2%
0 271
 
3.5%
3 269
 
3.4%
4 217
 
2.8%
6 216
 
2.8%
5 215
 
2.8%
7 197
 
2.5%
Other values (8) 526
 
6.7%
Latin
ValueCountFrequency (%)
S 4
12.1%
K 4
12.1%
B 4
12.1%
s 3
 
9.1%
A 2
 
6.1%
C 2
 
6.1%
L 2
 
6.1%
H 2
 
6.1%
i 1
 
3.0%
g 1
 
3.0%
Other values (8) 8
24.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12559
61.6%
ASCII 7832
38.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4037
51.5%
1 1025
 
13.1%
, 418
 
5.3%
2 408
 
5.2%
0 271
 
3.5%
3 269
 
3.4%
4 217
 
2.8%
6 216
 
2.8%
5 215
 
2.7%
7 197
 
2.5%
Other values (26) 559
 
7.1%
Hangul
ValueCountFrequency (%)
1735
13.8%
1732
13.8%
904
 
7.2%
877
 
7.0%
877
 
7.0%
876
 
7.0%
868
 
6.9%
833
 
6.6%
595
 
4.7%
409
 
3.3%
Other values (183) 2853
22.7%
Distinct5
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
Minimum2023-08-03 00:00:00
Maximum2023-08-07 00:00:00
2023-12-12T23:37:58.429539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:58.548211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

Interactions

2023-12-12T23:37:55.510082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:37:58.669461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명데이터기준일
연번1.0000.7860.019
업종명0.7861.0000.376
데이터기준일0.0190.3761.000
2023-12-12T23:37:58.777622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명
연번1.0000.566
업종명0.5661.000

Missing values

2023-12-12T23:37:55.625354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:37:55.732398image/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일반음식점복성원충청북도 증평군 증평읍 광장로 972023-08-03
12일반음식점차부식당충청북도 증평군 증평읍 광장로 912023-08-03
23일반음식점아지트충청북도 증평군 증평읍 윗장뜰길 432023-08-03
34일반음식점장인자연산 버섯찌게충청북도 증평군 증평읍 중앙로 2382023-08-03
45일반음식점증평감자탕충청북도 증평군 증평읍 광장로 912023-08-03
56일반음식점대성불고기충청북도 증평군 증평읍 윗장뜰길 622023-08-03
67일반음식점오행사주카페충청북도 증평군 증평읍 대동길 12023-08-03
78일반음식점태화장충청북도 증평군 증평읍 광장로 952023-08-03
89일반음식점이철희삼계탕충청북도 증평군 증평읍 삼보로 1172023-08-03
910일반음식점핫포차충청북도 증평군 증평읍 윗장뜰길 732023-08-03
연번업종명업소명소재지 도로명주소데이터기준일
861862제과점영업증평군장애인복지관(더드림)충청북도 증평군 증평읍 보건복지로 56-12023-08-03
862863제과점영업뚜레쥬르 증평하나로마트점충청북도 증평군 증평읍 광장로 272023-08-03
863864제과점영업케익 하우스충청북도 증평군 증평읍 창신로 54 (gs 마트내)2023-08-03
864865제과점영업디저트 크림충청북도 증평군 증평읍 초중8길 602023-08-03
865866제과점영업이층빵집충청북도 증평군 증평읍 장뜰로 22-1, 2층2023-08-03
866867제과점영업제빵공작소충청북도 증평군 증평읍 증평로 92023-08-03
867868제과점영업증평송산 파리바게뜨충청북도 증평군 증평읍 송산로2길 36-1, 1층 102호2023-08-04
868869제과점영업도레아 도너츠충청북도 증평군 증평읍 증평로 52, 1층2023-08-05
869870제과점영업으네로아충청북도 증평군 증평읍 충청대로 1756, 상가동 109호 (예다인)2023-08-06
870871제과점영업구르메 도씨 제과점충청북도 증평군 증평읍 송산로 105, 상가동 102호 (송산 대광로제비앙)2023-08-07