Overview

Dataset statistics

Number of variables6
Number of observations36
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory52.7 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description대구광역시_동구_동구5미전문음식점현황_20200515
Author대구광역시 동구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15052652&dataSetDetailId=150526522e0e1f6ddb337&provdMethod=FILE

Alerts

구분 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
주메뉴 is highly overall correlated with 구분High correlation
연번 is highly overall correlated with 구분High correlation
연번 has unique valuesUnique
업소명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 20:07:30.361798
Analysis finished2023-12-10 20:07:33.254834
Duration2.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.5
Minimum1
Maximum36
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-11T05:07:33.440791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.75
Q19.75
median18.5
Q327.25
95-th percentile34.25
Maximum36
Range35
Interquartile range (IQR)17.5

Descriptive statistics

Standard deviation10.535654
Coefficient of variation (CV)0.5694948
Kurtosis-1.2
Mean18.5
Median Absolute Deviation (MAD)9
Skewness0
Sum666
Variance111
MonotonicityStrictly increasing
2023-12-11T05:07:33.692618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
1 1
 
2.8%
20 1
 
2.8%
22 1
 
2.8%
23 1
 
2.8%
24 1
 
2.8%
25 1
 
2.8%
26 1
 
2.8%
27 1
 
2.8%
28 1
 
2.8%
29 1
 
2.8%
Other values (26) 26
72.2%
ValueCountFrequency (%)
1 1
2.8%
2 1
2.8%
3 1
2.8%
4 1
2.8%
5 1
2.8%
6 1
2.8%
7 1
2.8%
8 1
2.8%
9 1
2.8%
10 1
2.8%
ValueCountFrequency (%)
36 1
2.8%
35 1
2.8%
34 1
2.8%
33 1
2.8%
32 1
2.8%
31 1
2.8%
30 1
2.8%
29 1
2.8%
28 1
2.8%
27 1
2.8%

구분
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size420.0 B
닭요리
26 
연근요리
4 
오리요리
4 
산채요리
 
2

Length

Max length4
Median length3
Mean length3.2777778
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row연근요리
2nd row연근요리
3rd row연근요리
4th row연근요리
5th row오리요리

Common Values

ValueCountFrequency (%)
닭요리 26
72.2%
연근요리 4
 
11.1%
오리요리 4
 
11.1%
산채요리 2
 
5.6%

Length

2023-12-11T05:07:33.903051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:07:34.101338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
닭요리 26
72.2%
연근요리 4
 
11.1%
오리요리 4
 
11.1%
산채요리 2
 
5.6%

업소명
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-11T05:07:34.458309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9.5
Mean length5.7222222
Min length3

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)100.0%

Sample

1st row연뜨락
2nd row반야월연근사랑 협동조합
3rd row다중헌
4th row진선재토속음식전문
5th row쌍쌍오리한마당
ValueCountFrequency (%)
연뜨락 1
 
2.6%
오동나무식당 1
 
2.6%
똥집을잘아는남자 1
 
2.6%
만남의 1
 
2.6%
광장 1
 
2.6%
무릉도원식당 1
 
2.6%
부산식당 1
 
2.6%
삼아통닭식당 1
 
2.6%
아가씨와건달들 1
 
2.6%
평화통닭식당 1
 
2.6%
Other values (29) 29
74.4%
2023-12-11T05:07:35.028275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
당 14
 
6.8%
식 14
 
6.8%
통 8
 
3.9%
닭 7
 
3.4%
아 5
 
2.4%
집 5
 
2.4%
똥 4
 
1.9%
와 3
 
1.5%
나 3
 
1.5%
산 3
 
1.5%
Other values (105) 140
68.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 203
98.5%
Space Separator 3
 
1.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
당 14
 
6.9%
식 14
 
6.9%
통 8
 
3.9%
닭 7
 
3.4%
아 5
 
2.5%
집 5
 
2.5%
똥 4
 
2.0%
와 3
 
1.5%
나 3
 
1.5%
산 3
 
1.5%
Other values (104) 137
67.5%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 203
98.5%
Common 3
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
당 14
 
6.9%
식 14
 
6.9%
통 8
 
3.9%
닭 7
 
3.4%
아 5
 
2.5%
집 5
 
2.5%
똥 4
 
2.0%
와 3
 
1.5%
나 3
 
1.5%
산 3
 
1.5%
Other values (104) 137
67.5%
Common
ValueCountFrequency (%)
3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 203
98.5%
ASCII 3
 
1.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
당 14
 
6.9%
식 14
 
6.9%
통 8
 
3.9%
닭 7
 
3.4%
아 5
 
2.5%
집 5
 
2.5%
똥 4
 
2.0%
와 3
 
1.5%
나 3
 
1.5%
산 3
 
1.5%
Other values (104) 137
67.5%
ASCII
ValueCountFrequency (%)
3
100.0%

주소
Text

Distinct30
Distinct (%)83.3%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-11T05:07:35.375489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length32
Mean length23.138889
Min length20

Characters and Unicode

Total characters833
Distinct characters61
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

Unique26 ?
Unique (%)72.2%

Sample

1st row대구광역시 동구 갓바위로 57(진인동)
2nd row대구광역시 동구 동호로2길 13-5(동호동)
3rd row대구광역시 동구 과학로2길 14-1(각산동)
4th row대구광역시 동구 갓바위로 255-10(진인동)
5th row대구광역시 동구 화랑로88길 76(방촌동)
ValueCountFrequency (%)
대구광역시 36
24.2%
동구 36
24.2%
아양로9길 16
 
10.7%
아양로 5
 
3.4%
6-6(신암동 3
 
2.0%
10(신암동 3
 
2.0%
아양로7길 2
 
1.3%
3(신암동 2
 
1.3%
6-4(신암동 2
 
1.3%
신암뜨란채 2
 
1.3%
Other values (39) 42
28.2%
2023-12-11T05:07:35.999666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
113
 
13.6%
동 76
 
9.1%
구 72
 
8.6%
대 38
 
4.6%
시 36
 
4.3%
역 36
 
4.3%
광 36
 
4.3%
로 36
 
4.3%
( 36
 
4.3%
) 36
 
4.3%
Other values (51) 318
38.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 516
61.9%
Decimal Number 115
 
13.8%
Space Separator 113
 
13.6%
Open Punctuation 36
 
4.3%
Close Punctuation 36
 
4.3%
Dash Punctuation 14
 
1.7%
Other Punctuation 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 76
14.7%
구 72
14.0%
대 38
 
7.4%
시 36
 
7.0%
역 36
 
7.0%
광 36
 
7.0%
로 36
 
7.0%
신 27
 
5.2%
암 26
 
5.0%
아 24
 
4.7%
Other values (36) 109
21.1%
Decimal Number
ValueCountFrequency (%)
9 20
17.4%
1 19
16.5%
5 15
13.0%
6 15
13.0%
3 11
9.6%
2 10
8.7%
7 8
 
7.0%
4 7
 
6.1%
8 5
 
4.3%
0 5
 
4.3%
Space Separator
ValueCountFrequency (%)
113
100.0%
Open Punctuation
ValueCountFrequency (%)
( 36
100.0%
Close Punctuation
ValueCountFrequency (%)
) 36
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 516
61.9%
Common 317
38.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 76
14.7%
구 72
14.0%
대 38
 
7.4%
시 36
 
7.0%
역 36
 
7.0%
광 36
 
7.0%
로 36
 
7.0%
신 27
 
5.2%
암 26
 
5.0%
아 24
 
4.7%
Other values (36) 109
21.1%
Common
ValueCountFrequency (%)
113
35.6%
( 36
 
11.4%
) 36
 
11.4%
9 20
 
6.3%
1 19
 
6.0%
5 15
 
4.7%
6 15
 
4.7%
- 14
 
4.4%
3 11
 
3.5%
2 10
 
3.2%
Other values (5) 28
 
8.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 516
61.9%
ASCII 317
38.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
113
35.6%
( 36
 
11.4%
) 36
 
11.4%
9 20
 
6.3%
1 19
 
6.0%
5 15
 
4.7%
6 15
 
4.7%
- 14
 
4.4%
3 11
 
3.5%
2 10
 
3.2%
Other values (5) 28
 
8.8%
Hangul
ValueCountFrequency (%)
동 76
14.7%
구 72
14.0%
대 38
 
7.4%
시 36
 
7.0%
역 36
 
7.0%
광 36
 
7.0%
로 36
 
7.0%
신 27
 
5.2%
암 26
 
5.0%
아 24
 
4.7%
Other values (36) 109
21.1%

전화번호
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-11T05:07:36.361681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique36 ?
Unique (%)100.0%

Sample

1st row053-981-8200
2nd row053-964-0912
3rd row053-766-7022
4th row053-983-9066
5th row053-983-6689
ValueCountFrequency (%)
053-981-8200 1
 
2.8%
053-964-0912 1
 
2.8%
053-957-8227 1
 
2.8%
053-941-3392 1
 
2.8%
053-951-3450 1
 
2.8%
053-944-1884 1
 
2.8%
053-952-1346 1
 
2.8%
053-952-3650 1
 
2.8%
053-955-5044 1
 
2.8%
053-954-6800 1
 
2.8%
Other values (26) 26
72.2%
2023-12-11T05:07:36.903047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 72
16.7%
5 67
15.5%
0 61
14.1%
9 51
11.8%
3 49
11.3%
8 27
 
6.2%
6 27
 
6.2%
4 25
 
5.8%
1 20
 
4.6%
2 20
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 360
83.3%
Dash Punctuation 72
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 67
18.6%
0 61
16.9%
9 51
14.2%
3 49
13.6%
8 27
7.5%
6 27
7.5%
4 25
 
6.9%
1 20
 
5.6%
2 20
 
5.6%
7 13
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 432
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 72
16.7%
5 67
15.5%
0 61
14.1%
9 51
11.8%
3 49
11.3%
8 27
 
6.2%
6 27
 
6.2%
4 25
 
5.8%
1 20
 
4.6%
2 20
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 432
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 72
16.7%
5 67
15.5%
0 61
14.1%
9 51
11.8%
3 49
11.3%
8 27
 
6.2%
6 27
 
6.2%
4 25
 
5.8%
1 20
 
4.6%
2 20
 
4.6%

주메뉴
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)27.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
모듬똥집
24 
연근정식
4 
한방오리불고기
 
1
생오리구이
 
1
한방해신탕
 
1
Other values (5)
5 

Length

Max length7
Median length4
Mean length4.1388889
Min length2

Unique

Unique8 ?
Unique (%)22.2%

Sample

1st row연근정식
2nd row연근정식
3rd row연근정식
4th row연근정식
5th row한방오리불고기

Common Values

ValueCountFrequency (%)
모듬똥집 24
66.7%
연근정식 4
 
11.1%
한방오리불고기 1
 
2.8%
생오리구이 1
 
2.8%
한방해신탕 1
 
2.8%
백숙, 냉면 1
 
2.8%
차밭골정식 1
 
2.8%
곤드레밥 1
 
2.8%
삼계탕 1
 
2.8%
옻닭 1
 
2.8%

Length

2023-12-11T05:07:37.147899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:07:37.344369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
모듬똥집 24
64.9%
연근정식 4
 
10.8%
한방오리불고기 1
 
2.7%
생오리구이 1
 
2.7%
한방해신탕 1
 
2.7%
백숙 1
 
2.7%
냉면 1
 
2.7%
차밭골정식 1
 
2.7%
곤드레밥 1
 
2.7%
삼계탕 1
 
2.7%

Interactions

2023-12-11T05:07:32.725518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T05:07:37.498999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분업소명주소전화번호주메뉴
연번1.0000.9241.0000.8361.0000.829
구분0.9241.0001.0001.0001.0001.000
업소명1.0001.0001.0001.0001.0001.000
주소0.8361.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
주메뉴0.8291.0001.0001.0001.0001.000
2023-12-11T05:07:37.664752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분주메뉴
구분1.0000.901
주메뉴0.9011.000
2023-12-11T05:07:37.804619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분주메뉴
연번1.0000.8260.368
구분0.8261.0000.901
주메뉴0.3680.9011.000

Missing values

2023-12-11T05:07:32.986446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T05:07:33.192956image/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연근요리연뜨락대구광역시 동구 갓바위로 57(진인동)053-981-8200연근정식
12연근요리반야월연근사랑 협동조합대구광역시 동구 동호로2길 13-5(동호동)053-964-0912연근정식
23연근요리다중헌대구광역시 동구 과학로2길 14-1(각산동)053-766-7022연근정식
34연근요리진선재토속음식전문대구광역시 동구 갓바위로 255-10(진인동)053-983-9066연근정식
45오리요리쌍쌍오리한마당대구광역시 동구 화랑로88길 76(방촌동)053-983-6689한방오리불고기
56오리요리하늘천따지식당대구광역시 동구 서촌로 129(송정동)053-982-6190생오리구이
67오리요리큰기와집대구광역시 동구 서촌로 106(송정동)053-956-0667한방해신탕
78오리요리해아래숲대구광역시 동구 파계로138길 26(중대동)053-985-8052백숙, 냉면
89산채요리고향차밭골식당대구광역시 동구 팔공산로 339, 1층(중대동)053-981-5883차밭골정식
910산채요리산중식당대구광역시 동구 팔공산로185길 55(용수동)053-982-0077곤드레밥
연번구분업소명주소전화번호주메뉴
2627닭요리아로마대구광역시 동구 아양로 47(신암동)053-957-8227모듬똥집
2728닭요리오동나무식당대구광역시 동구 아양로 53-2(신암동)053-954-6800모듬똥집
2829닭요리운수좋은날대구광역시 동구 아양로9길 6-3(신암동)053-959-2759모듬똥집
2930닭요리은행나무식당대구광역시 동구 아양로9길 10(신암동)053-942-6660모듬똥집
3031닭요리제일통닭대구광역시 동구 아양로9길 6-6(신암동)053-954-1911모듬똥집
3132닭요리진미통닭식당대구광역시 동구 아양로9길 10(신암동)053-954-6580모듬똥집
3233닭요리타이타닉식당대구광역시 동구 아양로9길 3(신암동)053-954-2802모듬똥집
3334닭요리평강공주와 온달장군식당대구광역시 동구 아양로9길 6-1(신암동)053-959-7986모듬똥집
3435닭요리평화통닭식당대구광역시 동구 아양로9길 6-6(신암동)053-958-0816모듬똥집
3536닭요리합천통닭대구광역시 동구 아양로 53-4(신암동)053-951-3190모듬똥집