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=150526521e0e1f6ddb337&provdMethod=FILE

Alerts

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

Reproduction

Analysis started2023-12-10 18:43:42.498287
Analysis finished2023-12-10 18:43:45.998394
Duration3.5 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-11T03:43:46.129106image/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-11T03:43:46.564679image/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-11T03:43:47.239660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T03:43:47.636285image/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-11T03:43:48.358469image/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-11T03:43:49.113902image/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-11T03:43:49.530935image/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-11T03:43:50.228599image/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-11T03:43:50.593913image/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-11T03:43:51.205194image/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-11T03:43:51.451667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T03:43:51.669371image/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-11T03:43:45.414370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T03:43:51.836910image/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-11T03:43:52.015191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주메뉴구분
주메뉴1.0000.901
구분0.9011.000
2023-12-11T03:43:52.168601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분주메뉴
연번1.0000.8260.368
구분0.8261.0000.901
주메뉴0.3680.9011.000

Missing values

2023-12-11T03:43:45.717432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T03:43:45.917831image/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모듬똥집