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.4 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description대구광역시_동구_동구5미전문음식점현황_20230406
Author대구광역시 동구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15052652&dataSetDetailId=1505265218f29c44c8c12&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:59:22.541595
Analysis finished2023-12-10 18:59:24.857231
Duration2.32 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 size483.0 B
2023-12-11T03:59:25.257391image/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
2023-12-11T03:59:25.415017image/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 

Distinct5
Distinct (%)12.8%
Missing0
Missing (%)0.0%
Memory size444.0 B
닭요리
26 
오리요리
7 
연근요리
3 
산채요리
 
2
미나리삼겹살
 
1

Length

Max length6
Median length3
Mean length3.3846154
Min length3

Unique

Unique1 ?
Unique (%)2.6%

Sample

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

Common Values

ValueCountFrequency (%)
닭요리 26
66.7%
오리요리 7
 
17.9%
연근요리 3
 
7.7%
산채요리 2
 
5.1%
미나리삼겹살 1
 
2.6%

Length

2023-12-11T03:59:25.616870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T03:59:25.739052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
닭요리 26
66.7%
오리요리 7
 
17.9%
연근요리 3
 
7.7%
산채요리 2
 
5.1%
미나리삼겹살 1
 
2.6%

업소명
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-11T03:59:25.981225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length5.7179487
Min length3

Characters and Unicode

Total characters223
Distinct characters119
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.3%
똥집대통령 1
 
2.3%
만남의 1
 
2.3%
광장 1
 
2.3%
무릉도원식당 1
 
2.3%
부산식당 1
 
2.3%
삼아통닭식당 1
 
2.3%
아가씨와건달들 1
 
2.3%
아로마 1
 
2.3%
오동나무식당 1
 
2.3%
Other values (33) 33
76.7%
2023-12-11T03:59:26.381286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
식 15
 
6.7%
당 14
 
6.3%
통 7
 
3.1%
닭 6
 
2.7%
아 5
 
2.2%
집 5
 
2.2%
대 4
 
1.8%
오 4
 
1.8%
산 4
 
1.8%
와 4
 
1.8%
Other values (109) 155
69.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 219
98.2%
Space Separator 4
 
1.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
식 15
 
6.8%
당 14
 
6.4%
통 7
 
3.2%
닭 6
 
2.7%
아 5
 
2.3%
집 5
 
2.3%
대 4
 
1.8%
오 4
 
1.8%
산 4
 
1.8%
와 4
 
1.8%
Other values (108) 151
68.9%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 219
98.2%
Common 4
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
식 15
 
6.8%
당 14
 
6.4%
통 7
 
3.2%
닭 6
 
2.7%
아 5
 
2.3%
집 5
 
2.3%
대 4
 
1.8%
오 4
 
1.8%
산 4
 
1.8%
와 4
 
1.8%
Other values (108) 151
68.9%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 219
98.2%
ASCII 4
 
1.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
식 15
 
6.8%
당 14
 
6.4%
통 7
 
3.2%
닭 6
 
2.7%
아 5
 
2.3%
집 5
 
2.3%
대 4
 
1.8%
오 4
 
1.8%
산 4
 
1.8%
와 4
 
1.8%
Other values (108) 151
68.9%
ASCII
ValueCountFrequency (%)
4
100.0%

주소
Text

Distinct35
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-11T03:59:26.627060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length38
Mean length23.666667
Min length20

Characters and Unicode

Total characters923
Distinct characters75
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

Unique31 ?
Unique (%)79.5%

Sample

1st row대구광역시 동구 동호로2길 13-5(동호동)
2nd row대구광역시 동구 과학로2길 14-1(각산동)
3rd row대구광역시 동구 갓바위로 255-10(진인동)
4th row대구광역시 동구 화랑로88길 76(방촌동)
5th row대구광역시 동구 서촌로 129(송정동)
ValueCountFrequency (%)
대구광역시 39
23.4%
동구 39
23.4%
아양로9길 14
 
8.4%
아양로 5
 
3.0%
신암뜨란채 3
 
1.8%
12 3
 
1.8%
아양로7길 3
 
1.8%
3(신암동 2
 
1.2%
6-6(신암동 2
 
1.2%
10(신암동 2
 
1.2%
Other values (52) 55
32.9%
2023-12-11T03:59:27.023245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
128
 
13.9%
동 84
 
9.1%
구 79
 
8.6%
대 42
 
4.6%
시 39
 
4.2%
역 39
 
4.2%
광 39
 
4.2%
( 39
 
4.2%
) 39
 
4.2%
로 38
 
4.1%
Other values (65) 357
38.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 571
61.9%
Space Separator 128
 
13.9%
Decimal Number 126
 
13.7%
Open Punctuation 39
 
4.2%
Close Punctuation 39
 
4.2%
Dash Punctuation 14
 
1.5%
Other Punctuation 6
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 84
14.7%
구 79
13.8%
대 42
 
7.4%
시 39
 
6.8%
역 39
 
6.8%
광 39
 
6.8%
로 38
 
6.7%
신 27
 
4.7%
암 27
 
4.7%
길 25
 
4.4%
Other values (49) 132
23.1%
Decimal Number
ValueCountFrequency (%)
1 21
16.7%
9 18
14.3%
5 17
13.5%
6 16
12.7%
2 13
10.3%
3 11
8.7%
8 9
7.1%
7 9
7.1%
4 7
 
5.6%
0 5
 
4.0%
Other Punctuation
ValueCountFrequency (%)
, 5
83.3%
. 1
 
16.7%
Space Separator
ValueCountFrequency (%)
128
100.0%
Open Punctuation
ValueCountFrequency (%)
( 39
100.0%
Close Punctuation
ValueCountFrequency (%)
) 39
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 571
61.9%
Common 352
38.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 84
14.7%
구 79
13.8%
대 42
 
7.4%
시 39
 
6.8%
역 39
 
6.8%
광 39
 
6.8%
로 38
 
6.7%
신 27
 
4.7%
암 27
 
4.7%
길 25
 
4.4%
Other values (49) 132
23.1%
Common
ValueCountFrequency (%)
128
36.4%
( 39
 
11.1%
) 39
 
11.1%
1 21
 
6.0%
9 18
 
5.1%
5 17
 
4.8%
6 16
 
4.5%
- 14
 
4.0%
2 13
 
3.7%
3 11
 
3.1%
Other values (6) 36
 
10.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 571
61.9%
ASCII 352
38.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
128
36.4%
( 39
 
11.1%
) 39
 
11.1%
1 21
 
6.0%
9 18
 
5.1%
5 17
 
4.8%
6 16
 
4.5%
- 14
 
4.0%
2 13
 
3.7%
3 11
 
3.1%
Other values (6) 36
 
10.2%
Hangul
ValueCountFrequency (%)
동 84
14.7%
구 79
13.8%
대 42
 
7.4%
시 39
 
6.8%
역 39
 
6.8%
광 39
 
6.8%
로 38
 
6.7%
신 27
 
4.7%
암 27
 
4.7%
길 25
 
4.4%
Other values (49) 132
23.1%

전화번호
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-11T03:59:27.285270image/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-964-0912
2nd row053-766-7022
3rd row053-983-9066
4th row053-983-6689
5th row053-982-6190
ValueCountFrequency (%)
053-964-0912 1
 
2.6%
053-941-5580 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-954-6800 1
 
2.6%
053-941-3392 1
 
2.6%
Other values (29) 29
74.4%
2023-12-11T03:59:27.652308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 78
16.7%
5 75
16.0%
0 64
13.7%
9 59
12.6%
3 53
11.3%
8 31
 
6.6%
6 29
 
6.2%
4 27
 
5.8%
2 20
 
4.3%
1 17
 
3.6%

Most occurring categories

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

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 75
19.2%
0 64
16.4%
9 59
15.1%
3 53
13.6%
8 31
7.9%
6 29
 
7.4%
4 27
 
6.9%
2 20
 
5.1%
1 17
 
4.4%
7 15
 
3.8%
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 75
16.0%
0 64
13.7%
9 59
12.6%
3 53
11.3%
8 31
 
6.6%
6 29
 
6.2%
4 27
 
5.8%
2 20
 
4.3%
1 17
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 468
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 78
16.7%
5 75
16.0%
0 64
13.7%
9 59
12.6%
3 53
11.3%
8 31
 
6.6%
6 29
 
6.2%
4 27
 
5.8%
2 20
 
4.3%
1 17
 
3.6%

주메뉴
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)41.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
모듬똥집
22 
연근정식
 
2
생오리구이
 
2
연요리정찬
 
1
한방해신탕
 
1
Other values (11)
11 

Length

Max length17
Median length4
Mean length5.4358974
Min length3

Unique

Unique13 ?
Unique (%)33.3%

Sample

1st row연근정식
2nd row연근정식
3rd row연요리정찬
4th row생오리구이
5th row생오리구이

Common Values

ValueCountFrequency (%)
모듬똥집 22
56.4%
연근정식 2
 
5.1%
생오리구이 2
 
5.1%
연요리정찬 1
 
2.6%
한방해신탕 1
 
2.6%
백숙+냉면 1
 
2.6%
능이한방오리백숙+산더미오리불고기 1
 
2.6%
오리산더미+오리능이백숙 1
 
2.6%
차밭골 정식 1
 
2.6%
곤드레밥보쌈세트 1
 
2.6%
Other values (6) 6
 
15.4%

Length

2023-12-11T03:59:27.812921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
모듬똥집 22
52.4%
생오리구이 2
 
4.8%
연근정식 2
 
4.8%
삼계탕 1
 
2.4%
능이닭백숙+오리불고기 1
 
2.4%
닭목살 1
 
2.4%
닭목살+갈비맛 1
 
2.4%
양념 1
 
2.4%
삼계탕+찜닭 1
 
2.4%
옻닭+옻오리 1
 
2.4%
Other values (9) 9
21.4%

Interactions

2023-12-11T03:59:24.450717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T03:59:27.922901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분업소명주소전화번호주메뉴
연번1.0000.9181.0000.6871.0000.624
구분0.9181.0001.0001.0001.0001.000
업소명1.0001.0001.0001.0001.0001.000
주소0.6871.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
주메뉴0.6241.0001.0001.0001.0001.000
2023-12-11T03:59:28.038106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분주메뉴
구분1.0000.822
주메뉴0.8221.000
2023-12-11T03:59:28.119726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분주메뉴
연번1.0000.5700.245
구분0.5701.0000.822
주메뉴0.2450.8221.000

Missing values

2023-12-11T03:59:24.664901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T03:59:24.806064image/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연근요리반야월 연근사랑 협동조합대구광역시 동구 동호로2길 13-5(동호동)053-964-0912연근정식
12연근요리다중헌대구광역시 동구 과학로2길 14-1(각산동)053-766-7022연근정식
23연근요리진선재토속음식전문대구광역시 동구 갓바위로 255-10(진인동)053-983-9066연요리정찬
34오리요리쌍쌍오리한마당대구광역시 동구 화랑로88길 76(방촌동)053-983-6689생오리구이
45오리요리하늘천따지식당대구광역시 동구 서촌로 129(송정동)053-982-6190생오리구이
56오리요리큰기와집대구광역시 동구 서촌로 106(송정동)053-956-0667한방해신탕
67오리요리해아래숲대구광역시 동구 파계로138길 26(중대동)053-985-8052백숙+냉면
78오리요리송해와오리백숙대구광역시 동구 율하서로 76(율하동)053-964-5999능이한방오리백숙+산더미오리불고기
89오리요리오리짱대구광역시 동구 효동로6길 86. 2층(효목동)053-959-9252오리산더미+오리능이백숙
910산채요리고향차밭골식당대구광역시 동구 팔공산로 339(송정동)053-981-5883차밭골 정식
연번구분업소명주소전화번호주메뉴
2930닭요리운수좋은날대구광역시 동구 아양로9길 6-3(신암동)053-959-2759모듬똥집
3031닭요리진미통닭식당대구광역시 동구 아양로9길 10(신암동)053-954-6580모듬똥집
3132닭요리타이타닉식당대구광역시 동구 아양로9길 3(신암동)053-954-2802모듬똥집
3233닭요리평강공주와 온달장군식당대구광역시 동구 아양로9길 6-1(신암동)053-959-7986모듬똥집
3334닭요리평화통닭식당대구광역시 동구 아양로9길 6-6(신암동)053-958-0816모듬똥집
3435닭요리합천통닭대구광역시 동구 아양로 53-4(신암동)053-951-3190모듬똥집
3536닭요리장수삼계탕대구광역시 동구 메디밸리로 5-25(대림동)053-965-0078삼계탕+찜닭
3637닭요리신산홍대구광역시 동구 아양로7길 12, 가상가동 지하1층 108호 (신암동, 신암뜨란채)053-944-5650양념 닭목살+갈비맛 닭목살
3738오리요리팔공은가비대구광역시 동구 용천로 58(미곡동)053-983-8886능이닭백숙+오리불고기
3839미나리삼겹살대성식육식당대구광역시 동구 구암길 8, 1층(미대동)053-981-7649미나리삼겹살