Overview

Dataset statistics

Number of variables6
Number of observations39
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory52.3 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description대구광역시_동구_동구5미전문음식점현황_20210514
Author대구광역시 동구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15052652&dataSetDetailId=150526521e54b10da9f2c&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 started2024-04-21 09:45:35.375652
Analysis finished2024-04-21 09:45:36.233676
Duration0.86 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20
Minimum1
Maximum39
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size479.0 B
2024-04-21T18:45:36.354047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.9
Q110.5
median20
Q329.5
95-th percentile37.1
Maximum39
Range38
Interquartile range (IQR)19

Descriptive statistics

Standard deviation11.401754
Coefficient of variation (CV)0.57008771
Kurtosis-1.2
Mean20
Median Absolute Deviation (MAD)10
Skewness0
Sum780
Variance130
MonotonicityStrictly increasing
2024-04-21T18:45:36.606790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
1 1
 
2.6%
2 1
 
2.6%
23 1
 
2.6%
24 1
 
2.6%
25 1
 
2.6%
26 1
 
2.6%
27 1
 
2.6%
28 1
 
2.6%
29 1
 
2.6%
30 1
 
2.6%
Other values (29) 29
74.4%
ValueCountFrequency (%)
1 1
2.6%
2 1
2.6%
3 1
2.6%
4 1
2.6%
5 1
2.6%
6 1
2.6%
7 1
2.6%
8 1
2.6%
9 1
2.6%
10 1
2.6%
ValueCountFrequency (%)
39 1
2.6%
38 1
2.6%
37 1
2.6%
36 1
2.6%
35 1
2.6%
34 1
2.6%
33 1
2.6%
32 1
2.6%
31 1
2.6%
30 1
2.6%

구분
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Memory size440.0 B
닭요리
27 
오리요리
6 
연근요리
4 
산채요리
 
2

Length

Max length4
Median length3
Mean length3.3076923
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
닭요리 27
69.2%
오리요리 6
 
15.4%
연근요리 4
 
10.3%
산채요리 2
 
5.1%

Length

2024-04-21T18:45:36.850393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T18:45:37.034545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
닭요리 27
69.2%
오리요리 6
 
15.4%
연근요리 4
 
10.3%
산채요리 2
 
5.1%

업소명
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size440.0 B
2024-04-21T18:45:37.757382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length5.6666667
Min length3

Characters and Unicode

Total characters221
Distinct characters118
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

Unique39 ?
Unique (%)100.0%

Sample

1st row연뜨락
2nd row반야월연근사랑 협동조합
3rd row다중헌
4th row진선재토속음식전문
5th row쌍쌍오리한마당
ValueCountFrequency (%)
연뜨락 1
 
2.4%
똥집나이트 1
 
2.4%
똥집을잘아는남자 1
 
2.4%
만남의 1
 
2.4%
광장 1
 
2.4%
무릉도원식당 1
 
2.4%
부산식당 1
 
2.4%
삼아통닭식당 1
 
2.4%
아가씨와건달들 1
 
2.4%
아로마 1
 
2.4%
Other values (32) 32
76.2%
2024-04-21T18:45:38.699560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
식 14
 
6.3%
당 14
 
6.3%
통 8
 
3.6%
닭 7
 
3.2%
집 5
 
2.3%
아 5
 
2.3%
오 4
 
1.8%
와 4
 
1.8%
똥 4
 
1.8%
부 3
 
1.4%
Other values (108) 153
69.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 218
98.6%
Space Separator 3
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
식 14
 
6.4%
당 14
 
6.4%
통 8
 
3.7%
닭 7
 
3.2%
집 5
 
2.3%
아 5
 
2.3%
오 4
 
1.8%
와 4
 
1.8%
똥 4
 
1.8%
부 3
 
1.4%
Other values (107) 150
68.8%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 218
98.6%
Common 3
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
식 14
 
6.4%
당 14
 
6.4%
통 8
 
3.7%
닭 7
 
3.2%
집 5
 
2.3%
아 5
 
2.3%
오 4
 
1.8%
와 4
 
1.8%
똥 4
 
1.8%
부 3
 
1.4%
Other values (107) 150
68.8%
Common
ValueCountFrequency (%)
3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 218
98.6%
ASCII 3
 
1.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
식 14
 
6.4%
당 14
 
6.4%
통 8
 
3.7%
닭 7
 
3.2%
집 5
 
2.3%
아 5
 
2.3%
오 4
 
1.8%
와 4
 
1.8%
똥 4
 
1.8%
부 3
 
1.4%
Other values (107) 150
68.8%
ASCII
ValueCountFrequency (%)
3
100.0%

주소
Text

Distinct33
Distinct (%)84.6%
Missing0
Missing (%)0.0%
Memory size440.0 B
2024-04-21T18:45:39.393053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length26
Mean length23.179487
Min length20

Characters and Unicode

Total characters904
Distinct characters71
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

Unique29 ?
Unique (%)74.4%

Sample

1st row대구광역시 동구 갓바위로 57(진인동)
2nd row대구광역시 동구 동호로2길 13-5(동호동)
3rd row대구광역시 동구 과학로2길 14-1(각산동)
4th row대구광역시 동구 갓바위로 255-10(진인동)
5th row대구광역시 동구 화랑로88길 76(방촌동)
ValueCountFrequency (%)
대구광역시 39
24.1%
동구 39
24.1%
아양로9길 16
 
9.9%
아양로 5
 
3.1%
10(신암동 3
 
1.9%
6-6(신암동 3
 
1.9%
신암뜨란채 2
 
1.2%
갓바위로 2
 
1.2%
서촌로 2
 
1.2%
12 2
 
1.2%
Other values (46) 49
30.2%
2024-04-21T18:45:40.326512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
123
 
13.6%
동 83
 
9.2%
구 78
 
8.6%
대 42
 
4.6%
광 39
 
4.3%
역 39
 
4.3%
시 39
 
4.3%
로 39
 
4.3%
) 39
 
4.3%
( 39
 
4.3%
Other values (61) 344
38.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 560
61.9%
Decimal Number 124
 
13.7%
Space Separator 123
 
13.6%
Close Punctuation 39
 
4.3%
Open Punctuation 39
 
4.3%
Dash Punctuation 15
 
1.7%
Other Punctuation 4
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 83
14.8%
구 78
13.9%
대 42
 
7.5%
광 39
 
7.0%
역 39
 
7.0%
시 39
 
7.0%
로 39
 
7.0%
신 27
 
4.8%
암 26
 
4.6%
길 25
 
4.5%
Other values (45) 123
22.0%
Decimal Number
ValueCountFrequency (%)
9 20
16.1%
1 19
15.3%
6 18
14.5%
5 17
13.7%
2 12
9.7%
3 11
8.9%
7 9
7.3%
4 7
 
5.6%
8 6
 
4.8%
0 5
 
4.0%
Other Punctuation
ValueCountFrequency (%)
, 3
75.0%
. 1
 
25.0%
Space Separator
ValueCountFrequency (%)
123
100.0%
Close Punctuation
ValueCountFrequency (%)
) 39
100.0%
Open Punctuation
ValueCountFrequency (%)
( 39
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 560
61.9%
Common 344
38.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 83
14.8%
구 78
13.9%
대 42
 
7.5%
광 39
 
7.0%
역 39
 
7.0%
시 39
 
7.0%
로 39
 
7.0%
신 27
 
4.8%
암 26
 
4.6%
길 25
 
4.5%
Other values (45) 123
22.0%
Common
ValueCountFrequency (%)
123
35.8%
) 39
 
11.3%
( 39
 
11.3%
9 20
 
5.8%
1 19
 
5.5%
6 18
 
5.2%
5 17
 
4.9%
- 15
 
4.4%
2 12
 
3.5%
3 11
 
3.2%
Other values (6) 31
 
9.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 560
61.9%
ASCII 344
38.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
123
35.8%
) 39
 
11.3%
( 39
 
11.3%
9 20
 
5.8%
1 19
 
5.5%
6 18
 
5.2%
5 17
 
4.9%
- 15
 
4.4%
2 12
 
3.5%
3 11
 
3.2%
Other values (6) 31
 
9.0%
Hangul
ValueCountFrequency (%)
동 83
14.8%
구 78
13.9%
대 42
 
7.5%
광 39
 
7.0%
역 39
 
7.0%
시 39
 
7.0%
로 39
 
7.0%
신 27
 
4.8%
암 26
 
4.6%
길 25
 
4.5%
Other values (45) 123
22.0%

전화번호
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size440.0 B
2024-04-21T18:45:41.050756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique39 ?
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.6%
053-951-9494 1
 
2.6%
053-941-3392 1
 
2.6%
053-951-3450 1
 
2.6%
053-944-1884 1
 
2.6%
053-952-1346 1
 
2.6%
053-952-3650 1
 
2.6%
053-955-5044 1
 
2.6%
053-957-8227 1
 
2.6%
053-941-5580 1
 
2.6%
Other values (29) 29
74.4%
2024-04-21T18:45:41.970820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 78
16.7%
5 74
15.8%
0 66
14.1%
9 59
12.6%
3 52
11.1%
6 29
 
6.2%
8 28
 
6.0%
4 26
 
5.6%
2 22
 
4.7%
1 20
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 390
83.3%
Dash Punctuation 78
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 74
19.0%
0 66
16.9%
9 59
15.1%
3 52
13.3%
6 29
 
7.4%
8 28
 
7.2%
4 26
 
6.7%
2 22
 
5.6%
1 20
 
5.1%
7 14
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 78
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 468
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 78
16.7%
5 74
15.8%
0 66
14.1%
9 59
12.6%
3 52
11.1%
6 29
 
6.2%
8 28
 
6.0%
4 26
 
5.6%
2 22
 
4.7%
1 20
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 468
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 78
16.7%
5 74
15.8%
0 66
14.1%
9 59
12.6%
3 52
11.1%
6 29
 
6.2%
8 28
 
6.0%
4 26
 
5.6%
2 22
 
4.7%
1 20
 
4.3%

주메뉴
Categorical

HIGH CORRELATION 

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

Length

Max length18
Median length4
Mean length4.7948718
Min length2

Unique

Unique11 ?
Unique (%)28.2%

Sample

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

Common Values

ValueCountFrequency (%)
모듬똥집 24
61.5%
연근정식 4
 
10.3%
한방오리불고기 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 (3) 3
 
7.7%

Length

2024-04-21T18:45:42.221668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
모듬똥집 24
55.8%
연근정식 4
 
9.3%
삼계탕 2
 
4.7%
한방오리불고기 1
 
2.3%
생오리구이 1
 
2.3%
한방해신탕 1
 
2.3%
백숙 1
 
2.3%
냉면 1
 
2.3%
능이한방오리백숙 1
 
2.3%
산더미오리불고기 1
 
2.3%
Other values (6) 6
 
14.0%

Interactions

2024-04-21T18:45:35.773398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T18:45:42.380227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분업소명주소전화번호주메뉴
연번1.0000.9331.0000.7461.0000.700
구분0.9331.0001.0001.0001.0001.000
업소명1.0001.0001.0001.0001.0001.000
주소0.7461.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
주메뉴0.7001.0001.0001.0001.0001.000
2024-04-21T18:45:42.550725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주메뉴구분
주메뉴1.0000.862
구분0.8621.000
2024-04-21T18:45:42.687448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분주메뉴
연번1.0000.7660.349
구분0.7661.0000.862
주메뉴0.3490.8621.000

Missing values

2024-04-21T18:45:35.982733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T18:45:36.164624image/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오리요리송해와오리백숙대구광역시 동구 율하서로 76(율하동)053-964-5999능이한방오리백숙, 산더미오리불고기
910오리요리오리짱대구광역시 동구 효동로6길 86. 2층(효목동)053-959-9252오리산더미, 오리능이백숙
연번구분업소명주소전화번호주메뉴
2930닭요리오동나무식당대구광역시 동구 아양로 53-2(신암동)053-954-6800모듬똥집
3031닭요리운수좋은날대구광역시 동구 아양로9길 6-3(신암동)053-959-2759모듬똥집
3132닭요리은행나무식당대구광역시 동구 아양로9길 10(신암동)053-942-6660모듬똥집
3233닭요리제일통닭대구광역시 동구 아양로9길 6-6(신암동)053-954-1911모듬똥집
3334닭요리진미통닭식당대구광역시 동구 아양로9길 10(신암동)053-954-6580모듬똥집
3435닭요리타이타닉식당대구광역시 동구 아양로9길 3(신암동)053-954-2802모듬똥집
3536닭요리평강공주와 온달장군식당대구광역시 동구 아양로9길 6-1(신암동)053-959-7986모듬똥집
3637닭요리평화통닭식당대구광역시 동구 아양로9길 6-6(신암동)053-958-0816모듬똥집
3738닭요리합천통닭대구광역시 동구 아양로 53-4(신암동)053-951-3190모듬똥집
3839닭요리장수삼계탕대구광역시 동구 메디밸리로 5-25(대림동)053-965-0078삼계탕, 찜닭