Overview

Dataset statistics

Number of variables5
Number of observations278
Missing cells64
Missing cells (%)4.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.3 KiB
Average record size in memory41.5 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description대구광역시 동구 관내 휴흥단란주점 현황 데이터입니다. 이 데이트는 업종명, 업소명, 소재지, 전화번호 등의 항목으로 구성되어 있습니다.
Author대구광역시 동구
URLhttps://www.data.go.kr/data/15061564/fileData.do

Alerts

연번 is highly overall correlated with 업종명High correlation
업종명 is highly overall correlated with 연번High correlation
소재지전화 has 64 (23.0%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-04-21 01:28:37.834161
Analysis finished2024-04-21 01:28:39.401720
Duration1.57 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct278
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean139.5
Minimum1
Maximum278
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2024-04-21T10:28:39.477228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.85
Q170.25
median139.5
Q3208.75
95-th percentile264.15
Maximum278
Range277
Interquartile range (IQR)138.5

Descriptive statistics

Standard deviation80.395895
Coefficient of variation (CV)0.57631466
Kurtosis-1.2
Mean139.5
Median Absolute Deviation (MAD)69.5
Skewness0
Sum38781
Variance6463.5
MonotonicityStrictly increasing
2024-04-21T10:28:39.603529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
185 1
 
0.4%
191 1
 
0.4%
190 1
 
0.4%
189 1
 
0.4%
188 1
 
0.4%
187 1
 
0.4%
186 1
 
0.4%
184 1
 
0.4%
176 1
 
0.4%
Other values (268) 268
96.4%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
278 1
0.4%
277 1
0.4%
276 1
0.4%
275 1
0.4%
274 1
0.4%
273 1
0.4%
272 1
0.4%
271 1
0.4%
270 1
0.4%
269 1
0.4%

업종명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
유흥주점영업
200 
단란주점
78 

Length

Max length6
Median length6
Mean length5.4388489
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유흥주점영업
2nd row유흥주점영업
3rd row유흥주점영업
4th row유흥주점영업
5th row유흥주점영업

Common Values

ValueCountFrequency (%)
유흥주점영업 200
71.9%
단란주점 78
 
28.1%

Length

2024-04-21T10:28:39.728216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:28:39.839189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 200
71.9%
단란주점 78
 
28.1%

업소명
Text

Distinct254
Distinct (%)91.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2024-04-21T10:28:40.100715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length4.0467626
Min length1

Characters and Unicode

Total characters1125
Distinct characters285
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique234 ?
Unique (%)84.2%

Sample

1st row큐브
2nd row평화가요주점
3rd row베르사체
4th row희로가요궁
5th row프린스
ValueCountFrequency (%)
퀸 4
 
1.4%
연예인 3
 
1.0%
큐 3
 
1.0%
가요주점 3
 
1.0%
르네상스 2
 
0.7%
세븐 2
 
0.7%
스타 2
 
0.7%
라라 2
 
0.7%
발리단란주점 2
 
0.7%
발리 2
 
0.7%
Other values (250) 262
91.3%
2024-04-21T10:28:40.496600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 69
 
6.1%
점 68
 
6.0%
스 38
 
3.4%
노 27
 
2.4%
래 26
 
2.3%
이 25
 
2.2%
가 25
 
2.2%
라 23
 
2.0%
요 22
 
2.0%
리 20
 
1.8%
Other values (275) 782
69.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1018
90.5%
Uppercase Letter 45
 
4.0%
Decimal Number 16
 
1.4%
Open Punctuation 15
 
1.3%
Close Punctuation 15
 
1.3%
Space Separator 9
 
0.8%
Lowercase Letter 4
 
0.4%
Other Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 69
 
6.8%
점 68
 
6.7%
스 38
 
3.7%
노 27
 
2.7%
래 26
 
2.6%
이 25
 
2.5%
가 25
 
2.5%
라 23
 
2.3%
요 22
 
2.2%
리 20
 
2.0%
Other values (241) 675
66.3%
Uppercase Letter
ValueCountFrequency (%)
B 7
15.6%
A 5
11.1%
O 4
 
8.9%
S 4
 
8.9%
K 3
 
6.7%
M 3
 
6.7%
I 2
 
4.4%
P 2
 
4.4%
U 2
 
4.4%
R 2
 
4.4%
Other values (8) 11
24.4%
Decimal Number
ValueCountFrequency (%)
7 4
25.0%
2 4
25.0%
1 3
18.8%
0 2
12.5%
9 1
 
6.2%
3 1
 
6.2%
8 1
 
6.2%
Lowercase Letter
ValueCountFrequency (%)
a 2
50.0%
h 1
25.0%
r 1
25.0%
Other Punctuation
ValueCountFrequency (%)
, 1
33.3%
& 1
33.3%
. 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1018
90.5%
Common 58
 
5.2%
Latin 49
 
4.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 69
 
6.8%
점 68
 
6.7%
스 38
 
3.7%
노 27
 
2.7%
래 26
 
2.6%
이 25
 
2.5%
가 25
 
2.5%
라 23
 
2.3%
요 22
 
2.2%
리 20
 
2.0%
Other values (241) 675
66.3%
Latin
ValueCountFrequency (%)
B 7
14.3%
A 5
 
10.2%
O 4
 
8.2%
S 4
 
8.2%
K 3
 
6.1%
M 3
 
6.1%
I 2
 
4.1%
P 2
 
4.1%
a 2
 
4.1%
U 2
 
4.1%
Other values (11) 15
30.6%
Common
ValueCountFrequency (%)
( 15
25.9%
) 15
25.9%
9
15.5%
7 4
 
6.9%
2 4
 
6.9%
1 3
 
5.2%
0 2
 
3.4%
9 1
 
1.7%
3 1
 
1.7%
, 1
 
1.7%
Other values (3) 3
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1018
90.5%
ASCII 107
 
9.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 69
 
6.8%
점 68
 
6.7%
스 38
 
3.7%
노 27
 
2.7%
래 26
 
2.6%
이 25
 
2.5%
가 25
 
2.5%
라 23
 
2.3%
요 22
 
2.2%
리 20
 
2.0%
Other values (241) 675
66.3%
ASCII
ValueCountFrequency (%)
( 15
14.0%
) 15
14.0%
9
 
8.4%
B 7
 
6.5%
A 5
 
4.7%
7 4
 
3.7%
O 4
 
3.7%
2 4
 
3.7%
S 4
 
3.7%
K 3
 
2.8%
Other values (24) 37
34.6%

소재지(도로명)
Text

Distinct257
Distinct (%)92.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2024-04-21T10:28:40.730562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length35
Mean length26.705036
Min length21

Characters and Unicode

Total characters7424
Distinct characters88
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique237 ?
Unique (%)85.3%

Sample

1st row대구광역시 동구 동대구로 462-3, 지하1층 (신천동)
2nd row대구광역시 동구 아양로 65 (신암동)
3rd row대구광역시 동구 동부로26길 60 (신천동)
4th row대구광역시 동구 효목로 20 (효목동)
5th row대구광역시 동구 아양로 30 (신암동)
ValueCountFrequency (%)
대구광역시 278
17.9%
동구 278
17.9%
신천동 135
 
8.7%
지하1층 79
 
5.1%
신암동 52
 
3.3%
동부로30길 49
 
3.2%
아양로 32
 
2.1%
동부로22길 31
 
2.0%
효목동 31
 
2.0%
동부로26길 26
 
1.7%
Other values (246) 564
36.3%
2024-04-21T10:28:41.089379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1277
17.2%
동 743
 
10.0%
구 569
 
7.7%
대 292
 
3.9%
로 284
 
3.8%
광 278
 
3.7%
역 278
 
3.7%
시 278
 
3.7%
( 278
 
3.7%
) 278
 
3.7%
Other values (78) 2869
38.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4206
56.7%
Space Separator 1277
 
17.2%
Decimal Number 1174
 
15.8%
Open Punctuation 278
 
3.7%
Close Punctuation 278
 
3.7%
Other Punctuation 162
 
2.2%
Dash Punctuation 46
 
0.6%
Uppercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 743
17.7%
구 569
13.5%
대 292
 
6.9%
로 284
 
6.8%
광 278
 
6.6%
역 278
 
6.6%
시 278
 
6.6%
신 230
 
5.5%
길 172
 
4.1%
층 144
 
3.4%
Other values (60) 938
22.3%
Decimal Number
ValueCountFrequency (%)
2 237
20.2%
1 235
20.0%
3 157
13.4%
0 108
9.2%
6 104
8.9%
4 87
 
7.4%
5 73
 
6.2%
8 69
 
5.9%
7 60
 
5.1%
9 44
 
3.7%
Other Punctuation
ValueCountFrequency (%)
, 159
98.1%
. 3
 
1.9%
Uppercase Letter
ValueCountFrequency (%)
A 2
66.7%
B 1
33.3%
Space Separator
ValueCountFrequency (%)
1277
100.0%
Open Punctuation
ValueCountFrequency (%)
( 278
100.0%
Close Punctuation
ValueCountFrequency (%)
) 278
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4206
56.7%
Common 3215
43.3%
Latin 3
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 743
17.7%
구 569
13.5%
대 292
 
6.9%
로 284
 
6.8%
광 278
 
6.6%
역 278
 
6.6%
시 278
 
6.6%
신 230
 
5.5%
길 172
 
4.1%
층 144
 
3.4%
Other values (60) 938
22.3%
Common
ValueCountFrequency (%)
1277
39.7%
( 278
 
8.6%
) 278
 
8.6%
2 237
 
7.4%
1 235
 
7.3%
, 159
 
4.9%
3 157
 
4.9%
0 108
 
3.4%
6 104
 
3.2%
4 87
 
2.7%
Other values (6) 295
 
9.2%
Latin
ValueCountFrequency (%)
A 2
66.7%
B 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4206
56.7%
ASCII 3218
43.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1277
39.7%
( 278
 
8.6%
) 278
 
8.6%
2 237
 
7.4%
1 235
 
7.3%
, 159
 
4.9%
3 157
 
4.9%
0 108
 
3.4%
6 104
 
3.2%
4 87
 
2.7%
Other values (8) 298
 
9.3%
Hangul
ValueCountFrequency (%)
동 743
17.7%
구 569
13.5%
대 292
 
6.9%
로 284
 
6.8%
광 278
 
6.6%
역 278
 
6.6%
시 278
 
6.6%
신 230
 
5.5%
길 172
 
4.1%
층 144
 
3.4%
Other values (60) 938
22.3%

소재지전화
Text

MISSING 

Distinct212
Distinct (%)99.1%
Missing64
Missing (%)23.0%
Memory size2.3 KiB
2024-04-21T10:28:41.300667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.014019
Min length12

Characters and Unicode

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

Unique210 ?
Unique (%)98.1%

Sample

1st row053-755-4040
2nd row053-956-3222
3rd row053-744-8144
4th row053-743-1834
5th row053-955-5007
ValueCountFrequency (%)
053-985-1204 2
 
0.9%
053-754-6206 2
 
0.9%
053-7452-233 1
 
0.5%
053-741-1441 1
 
0.5%
053-941-0205 1
 
0.5%
053-741-4151 1
 
0.5%
053-755-4040 1
 
0.5%
053-741-7975 1
 
0.5%
053-745-2626 1
 
0.5%
053-955-0110 1
 
0.5%
Other values (202) 202
94.4%
2024-04-21T10:28:41.638517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 428
16.6%
5 427
16.6%
3 337
13.1%
0 333
13.0%
7 205
8.0%
9 189
7.4%
4 181
7.0%
1 136
 
5.3%
2 128
 
5.0%
6 104
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2143
83.4%
Dash Punctuation 428
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 427
19.9%
3 337
15.7%
0 333
15.5%
7 205
9.6%
9 189
8.8%
4 181
8.4%
1 136
 
6.3%
2 128
 
6.0%
6 104
 
4.9%
8 103
 
4.8%
Dash Punctuation
ValueCountFrequency (%)
- 428
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2571
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 428
16.6%
5 427
16.6%
3 337
13.1%
0 333
13.0%
7 205
8.0%
9 189
7.4%
4 181
7.0%
1 136
 
5.3%
2 128
 
5.0%
6 104
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2571
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 428
16.6%
5 427
16.6%
3 337
13.1%
0 333
13.0%
7 205
8.0%
9 189
7.4%
4 181
7.0%
1 136
 
5.3%
2 128
 
5.0%
6 104
 
4.0%

Interactions

2024-04-21T10:28:39.097319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T10:28:41.722700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명
연번1.0000.998
업종명0.9981.000
2024-04-21T10:28:41.799415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명
연번1.0000.942
업종명0.9421.000

Missing values

2024-04-21T10:28:39.262561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T10:28:39.358189image/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유흥주점영업큐브대구광역시 동구 동대구로 462-3, 지하1층 (신천동)053-755-4040
12유흥주점영업평화가요주점대구광역시 동구 아양로 65 (신암동)053-956-3222
23유흥주점영업베르사체대구광역시 동구 동부로26길 60 (신천동)053-744-8144
34유흥주점영업희로가요궁대구광역시 동구 효목로 20 (효목동)053-743-1834
45유흥주점영업프린스대구광역시 동구 아양로 30 (신암동)053-955-5007
56유흥주점영업위너대구광역시 동구 동부로26길 25 (신천동)053-742-1250
67유흥주점영업SBS대구광역시 동구 동부로22길 36 (신천동)053-754-0500
78유흥주점영업귀빈회관대구광역시 동구 화랑로25길 5 (효목동)053-755-5057
89유흥주점영업하야트대구광역시 동구 화랑로25길 5 (효목동)053-756-4939
910유흥주점영업신세계대구광역시 동구 장등로 20 (신천동)053-742-7978
연번업종명업소명소재지(도로명)소재지전화
268269단란주점놀대구광역시 동구 동부로30길 30, 지하1층 (신천동)053-751-6969
269270단란주점써프 (SURF)대구광역시 동구 동부로28길 40, 지하1층 (신천동)<NA>
270271단란주점라라(LALA)대구광역시 동구 동부로28길 39-1, 1층 (신천동)<NA>
271272단란주점동촌라이브대구광역시 동구 효동로2길 57-11, 2층 (효목동)053-985-3001
272273단란주점신천별곡대구광역시 동구 동부로30길 43, 2층 (신천동)<NA>
273274단란주점파라오라이브대구광역시 동구 효동로2길 13-3, 지하1층 (효목동)<NA>
274275단란주점퀸대구광역시 동구 동촌로 224, 지하1층 (방촌동)053-981-7228
275276단란주점필라이브카페대구광역시 동구 효동로6길 88, 3층 (효목동)<NA>
276277단란주점마키하우스대구광역시 동구 효동로2길 57-11, 3층 (효목동)053-959-3001
277278단란주점디엠대구광역시 동구 동부로28길 16, 지하1층 (신천동)<NA>