Overview

Dataset statistics

Number of variables7
Number of observations133
Missing cells142
Missing cells (%)15.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.7 KiB
Average record size in memory59.0 B

Variable types

Numeric1
Text4
Categorical1
Unsupported1

Dataset

Description춘천시 대표음식, 먹거리촌, 모범음식점, 맛집, 가격안내 등 상세정보를 조회하는 서비스
Author강원도 춘천시
URLhttps://www.data.go.kr/data/15050521/fileData.do

Alerts

연번 is highly overall correlated with 업태명High correlation
업태명 is highly overall correlated with 연번High correlation
전 화 has 9 (6.8%) missing valuesMissing
비고 has 133 (100.0%) missing valuesMissing
연번 has unique valuesUnique
소 재 지(지번) has unique valuesUnique
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 07:27:08.649060
Analysis finished2023-12-12 07:27:09.248040
Duration0.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct133
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67
Minimum1
Maximum133
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T16:27:09.319186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.6
Q134
median67
Q3100
95-th percentile126.4
Maximum133
Range132
Interquartile range (IQR)66

Descriptive statistics

Standard deviation38.53786
Coefficient of variation (CV)0.57519194
Kurtosis-1.2
Mean67
Median Absolute Deviation (MAD)33
Skewness0
Sum8911
Variance1485.1667
MonotonicityStrictly increasing
2023-12-12T16:27:09.484745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
85 1
 
0.8%
99 1
 
0.8%
98 1
 
0.8%
97 1
 
0.8%
96 1
 
0.8%
95 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
Other values (123) 123
92.5%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
133 1
0.8%
132 1
0.8%
131 1
0.8%
130 1
0.8%
129 1
0.8%
128 1
0.8%
127 1
0.8%
126 1
0.8%
125 1
0.8%
124 1
0.8%

업 소 명
Text

Distinct132
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T16:27:09.706194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length5.8646617
Min length2

Characters and Unicode

Total characters780
Distinct characters220
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

Unique131 ?
Unique (%)98.5%

Sample

1st row함지
2nd row돈카돈까(후평점)
3rd row돈까스와 뼈다귀
4th row델모니코스
5th row돈가스클럽
ValueCountFrequency (%)
우성닭갈비 2
 
1.4%
하주골 1
 
0.7%
일산감자탕 1
 
0.7%
춘천이동갈비 1
 
0.7%
우물정 1
 
0.7%
육쌈냉면 1
 
0.7%
이가등심 1
 
0.7%
짚터퇴계점 1
 
0.7%
오케이농장춘천본점 1
 
0.7%
라이라이 1
 
0.7%
Other values (129) 129
92.1%
2023-12-12T16:27:10.080481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
갈 31
 
4.0%
비 31
 
4.0%
닭 25
 
3.2%
수 22
 
2.8%
국 21
 
2.7%
막 19
 
2.4%
가 18
 
2.3%
이 16
 
2.1%
우 15
 
1.9%
점 14
 
1.8%
Other values (210) 568
72.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 747
95.8%
Close Punctuation 10
 
1.3%
Open Punctuation 10
 
1.3%
Space Separator 7
 
0.9%
Other Punctuation 3
 
0.4%
Decimal Number 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
갈 31
 
4.1%
비 31
 
4.1%
닭 25
 
3.3%
수 22
 
2.9%
국 21
 
2.8%
막 19
 
2.5%
가 18
 
2.4%
이 16
 
2.1%
우 15
 
2.0%
점 14
 
1.9%
Other values (202) 535
71.6%
Decimal Number
ValueCountFrequency (%)
0 1
33.3%
5 1
33.3%
1 1
33.3%
Other Punctuation
ValueCountFrequency (%)
, 2
66.7%
. 1
33.3%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 747
95.8%
Common 33
 
4.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
갈 31
 
4.1%
비 31
 
4.1%
닭 25
 
3.3%
수 22
 
2.9%
국 21
 
2.8%
막 19
 
2.5%
가 18
 
2.4%
이 16
 
2.1%
우 15
 
2.0%
점 14
 
1.9%
Other values (202) 535
71.6%
Common
ValueCountFrequency (%)
) 10
30.3%
( 10
30.3%
7
21.2%
, 2
 
6.1%
0 1
 
3.0%
5 1
 
3.0%
1 1
 
3.0%
. 1
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 747
95.8%
ASCII 33
 
4.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
갈 31
 
4.1%
비 31
 
4.1%
닭 25
 
3.3%
수 22
 
2.9%
국 21
 
2.8%
막 19
 
2.5%
가 18
 
2.4%
이 16
 
2.1%
우 15
 
2.0%
점 14
 
1.9%
Other values (202) 535
71.6%
ASCII
ValueCountFrequency (%)
) 10
30.3%
( 10
30.3%
7
21.2%
, 2
 
6.1%
0 1
 
3.0%
5 1
 
3.0%
1 1
 
3.0%
. 1
 
3.0%

영업자
Text

Distinct132
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T16:27:10.358246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length3
Mean length3
Min length2

Characters and Unicode

Total characters399
Distinct characters107
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique131 ?
Unique (%)98.5%

Sample

1st row이광석
2nd row송희관
3rd row김현자
4th row박현국
5th row이치숙
ValueCountFrequency (%)
박주현 2
 
1.5%
박은자 1
 
0.8%
박형복 1
 
0.8%
김연숙 1
 
0.8%
김명숙 1
 
0.8%
민금자 1
 
0.8%
김현종 1
 
0.8%
송영자 1
 
0.8%
박제춘 1
 
0.8%
이강욱 1
 
0.8%
Other values (122) 122
91.7%
2023-12-12T16:27:10.859334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 28
 
7.0%
이 22
 
5.5%
박 18
 
4.5%
순 14
 
3.5%
숙 12
 
3.0%
영 11
 
2.8%
정 10
 
2.5%
현 10
 
2.5%
자 10
 
2.5%
경 9
 
2.3%
Other values (97) 255
63.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 399
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 28
 
7.0%
이 22
 
5.5%
박 18
 
4.5%
순 14
 
3.5%
숙 12
 
3.0%
영 11
 
2.8%
정 10
 
2.5%
현 10
 
2.5%
자 10
 
2.5%
경 9
 
2.3%
Other values (97) 255
63.9%

Most occurring scripts

ValueCountFrequency (%)
Hangul 399
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 28
 
7.0%
이 22
 
5.5%
박 18
 
4.5%
순 14
 
3.5%
숙 12
 
3.0%
영 11
 
2.8%
정 10
 
2.5%
현 10
 
2.5%
자 10
 
2.5%
경 9
 
2.3%
Other values (97) 255
63.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 399
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 28
 
7.0%
이 22
 
5.5%
박 18
 
4.5%
순 14
 
3.5%
숙 12
 
3.0%
영 11
 
2.8%
정 10
 
2.5%
현 10
 
2.5%
자 10
 
2.5%
경 9
 
2.3%
Other values (97) 255
63.9%

소 재 지(지번)
Text

UNIQUE 

Distinct133
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T16:27:11.263277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length21
Mean length13.541353
Min length7

Characters and Unicode

Total characters1801
Distinct characters105
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

Unique133 ?
Unique (%)100.0%

Sample

1st row중앙로3가 60
2nd row후평동 801번지 2호
3rd row우두동 37번지 1호
4th row동면 장학리 139번지 55호 (1,2층)
5th row후평동 179 - 2
ValueCountFrequency (%)
83
 
15.2%
퇴계동 22
 
4.0%
1 19
 
3.5%
동면 16
 
2.9%
2 14
 
2.6%
후평동 12
 
2.2%
만천리 11
 
2.0%
신북읍 9
 
1.7%
동내면 9
 
1.7%
3 9
 
1.7%
Other values (214) 341
62.6%
2023-12-12T16:27:11.832105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
412
22.9%
1 128
 
7.1%
동 116
 
6.4%
- 95
 
5.3%
2 71
 
3.9%
3 66
 
3.7%
0 49
 
2.7%
6 47
 
2.6%
7 45
 
2.5%
리 45
 
2.5%
Other values (95) 727
40.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 680
37.8%
Decimal Number 573
31.8%
Space Separator 412
22.9%
Dash Punctuation 95
 
5.3%
Open Punctuation 13
 
0.7%
Close Punctuation 13
 
0.7%
Other Punctuation 7
 
0.4%
Uppercase Letter 7
 
0.4%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 116
 
17.1%
리 45
 
6.6%
지 37
 
5.4%
면 34
 
5.0%
천 29
 
4.3%
번 22
 
3.2%
계 22
 
3.2%
퇴 22
 
3.2%
호 18
 
2.6%
층 14
 
2.1%
Other values (76) 321
47.2%
Decimal Number
ValueCountFrequency (%)
1 128
22.3%
2 71
12.4%
3 66
11.5%
0 49
 
8.6%
6 47
 
8.2%
7 45
 
7.9%
4 44
 
7.7%
5 43
 
7.5%
8 42
 
7.3%
9 38
 
6.6%
Uppercase Letter
ValueCountFrequency (%)
L 3
42.9%
B 3
42.9%
A 1
 
14.3%
Space Separator
ValueCountFrequency (%)
412
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 95
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1114
61.9%
Hangul 680
37.8%
Latin 7
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 116
 
17.1%
리 45
 
6.6%
지 37
 
5.4%
면 34
 
5.0%
천 29
 
4.3%
번 22
 
3.2%
계 22
 
3.2%
퇴 22
 
3.2%
호 18
 
2.6%
층 14
 
2.1%
Other values (76) 321
47.2%
Common
ValueCountFrequency (%)
412
37.0%
1 128
 
11.5%
- 95
 
8.5%
2 71
 
6.4%
3 66
 
5.9%
0 49
 
4.4%
6 47
 
4.2%
7 45
 
4.0%
4 44
 
3.9%
5 43
 
3.9%
Other values (6) 114
 
10.2%
Latin
ValueCountFrequency (%)
L 3
42.9%
B 3
42.9%
A 1
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1121
62.2%
Hangul 680
37.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
412
36.8%
1 128
 
11.4%
- 95
 
8.5%
2 71
 
6.3%
3 66
 
5.9%
0 49
 
4.4%
6 47
 
4.2%
7 45
 
4.0%
4 44
 
3.9%
5 43
 
3.8%
Other values (9) 121
 
10.8%
Hangul
ValueCountFrequency (%)
동 116
 
17.1%
리 45
 
6.6%
지 37
 
5.4%
면 34
 
5.0%
천 29
 
4.3%
번 22
 
3.2%
계 22
 
3.2%
퇴 22
 
3.2%
호 18
 
2.6%
층 14
 
2.1%
Other values (76) 321
47.2%

전 화
Text

MISSING 

Distinct124
Distinct (%)100.0%
Missing9
Missing (%)6.8%
Memory size1.2 KiB
2023-12-12T16:27:12.112316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.064516
Min length12

Characters and Unicode

Total characters1496
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique124 ?
Unique (%)100.0%

Sample

1st row033-254-5221
2nd row033-251-5709
3rd row033-252-0999
4th row033-256-5836
5th row033-243-1997
ValueCountFrequency (%)
033 7
 
5.3%
033-241-7376 1
 
0.8%
033-244-1100 1
 
0.8%
033-256-5678 1
 
0.8%
033-243-0100 1
 
0.8%
033-242-6498 1
 
0.8%
033-254-4198 1
 
0.8%
033-264-3792 1
 
0.8%
033-263-2555 1
 
0.8%
256-7963 1
 
0.8%
Other values (116) 116
87.9%
2023-12-12T16:27:12.536712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 310
20.7%
- 248
16.6%
2 217
14.5%
0 183
12.2%
5 129
8.6%
4 97
 
6.5%
6 84
 
5.6%
9 72
 
4.8%
1 64
 
4.3%
8 45
 
3.0%
Other values (2) 47
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1240
82.9%
Dash Punctuation 248
 
16.6%
Space Separator 8
 
0.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 310
25.0%
2 217
17.5%
0 183
14.8%
5 129
10.4%
4 97
 
7.8%
6 84
 
6.8%
9 72
 
5.8%
1 64
 
5.2%
8 45
 
3.6%
7 39
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 248
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1496
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 310
20.7%
- 248
16.6%
2 217
14.5%
0 183
12.2%
5 129
8.6%
4 97
 
6.5%
6 84
 
5.6%
9 72
 
4.8%
1 64
 
4.3%
8 45
 
3.0%
Other values (2) 47
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1496
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 310
20.7%
- 248
16.6%
2 217
14.5%
0 183
12.2%
5 129
8.6%
4 97
 
6.5%
6 84
 
5.6%
9 72
 
4.8%
1 64
 
4.3%
8 45
 
3.0%
Other values (2) 47
 
3.1%

업태명
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)5.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
한식
64 
닭갈비
27 
막국수
14 
뷔페식
9 
일식
9 
Other values (2)
10 

Length

Max length3
Median length2
Mean length2.4511278
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경양식
2nd row경양식
3rd row경양식
4th row경양식
5th row경양식

Common Values

ValueCountFrequency (%)
한식 64
48.1%
닭갈비 27
20.3%
막국수 14
 
10.5%
뷔페식 9
 
6.8%
일식 9
 
6.8%
경양식 7
 
5.3%
중국식 3
 
2.3%

Length

2023-12-12T16:27:12.719222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:27:12.841912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한식 64
48.1%
닭갈비 27
20.3%
막국수 14
 
10.5%
뷔페식 9
 
6.8%
일식 9
 
6.8%
경양식 7
 
5.3%
중국식 3
 
2.3%

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing133
Missing (%)100.0%
Memory size1.3 KiB

Interactions

2023-12-12T16:27:08.939477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:27:12.936984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업태명
연번1.0000.866
업태명0.8661.000
2023-12-12T16:27:13.030432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업태명
연번1.0000.657
업태명0.6571.000

Missing values

2023-12-12T16:27:09.065305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:27:09.204764image/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함지이광석중앙로3가 60033-254-5221경양식<NA>
12돈카돈까(후평점)송희관후평동 801번지 2호<NA>경양식<NA>
23돈까스와 뼈다귀김현자우두동 37번지 1호033-251-5709경양식<NA>
34델모니코스박현국동면 장학리 139번지 55호 (1,2층)033-252-0999경양식<NA>
45돈가스클럽이치숙후평동 179 - 2033-256-5836경양식<NA>
56씨제이푸드빌(주)빕스춘천점허민회퇴계동 771 - 11(2층)033-243-1997경양식<NA>
67뉴욕바닷가재정일용동내면 사암리 1245 - 1033-263-5255경양식<NA>
78부안막국수홍인숙후평동 419 - 1033-254-0654닭갈비<NA>
89금복할머니막국수닭갈비박금복신북읍 천전리 89번지 4호033-242-0342닭갈비<NA>
910남춘천명물닭갈비박춘옥퇴계동 875번지 2호033-254-9922닭갈비<NA>
연번업 소 명영업자소 재 지(지번)전 화업태명비고
123124효자황태구이이금순효자동 705 - 18 (1~2층)033-253-9988한식<NA>
124125만천돼지갈비허미옥동면 만천리 796 - 4033-242-6969한식<NA>
125126원조고기촌강미경후평동 24 - 2 외2필지(나동)033-244-9933한식<NA>
126127평창정육점식당이광준근화동 544 - 6033-241-8882한식<NA>
127128하이록한우전문점주영노퇴계동 164 - 3 외 15필지 (2층)033-261-9253한식<NA>
128129퇴골집오리숯불구이둘째아들점김현옥후평동 157 - 17033-255-7829한식<NA>
129130갈비명가담소최영선동면 만천리 896 - 2033-251-3989한식<NA>
130131황가네황윤경퇴계동 875 - 6 (1층)033-254-6692한식<NA>
131132정자나루최규손남산면 창촌리 135 - 1033-264-7002한식<NA>
132133천년동안안인숙동면 만천리 430033-255-7222한식<NA>