Overview

Dataset statistics

Number of variables5
Number of observations216
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.6 KiB
Average record size in memory40.6 B

Variable types

Categorical2
Text3

Dataset

Description광주광역시 북구에 소재한 유흥,단란주점 업소 현황으로 업종명, 업소명, 소재지(도로명), 소재지(지번)의 항목을 공공데이터 포털에 제공하고 있습니다.
Author광주광역시 북구
URLhttps://www.data.go.kr/data/15067807/fileData.do

Alerts

데이터기준일자 has constant value ""Constant

Reproduction

Analysis started2023-12-12 10:28:55.762349
Analysis finished2023-12-12 10:28:56.170894
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
단란주점
117 
유흥주점영업
99 

Length

Max length6
Median length4
Mean length4.9166667
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
단란주점 117
54.2%
유흥주점영업 99
45.8%

Length

2023-12-12T19:28:56.267022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:28:56.413496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단란주점 117
54.2%
유흥주점영업 99
45.8%

업소명
Text

Distinct205
Distinct (%)94.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T19:28:56.645293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length11
Mean length5.5833333
Min length1

Characters and Unicode

Total characters1206
Distinct characters263
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique194 ?
Unique (%)89.8%

Sample

1st row센스노래홀
2nd row본노래홀
3rd row워커힐
4th row케이투
5th row오드리
ValueCountFrequency (%)
술마시는 5
 
2.2%
쿵쿵따 2
 
0.9%
술마시는첫번째노래홀 2
 
0.9%
노래홀 2
 
0.9%
레알 2
 
0.9%
부킹 2
 
0.9%
술마시는탑노래홀 2
 
0.9%
술마시는오렌지노래홀 2
 
0.9%
비비 2
 
0.9%
술마시는볼륨노래홀 2
 
0.9%
Other values (202) 206
90.0%
2023-12-12T19:28:57.095937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
래 88
 
7.3%
노 87
 
7.2%
홀 71
 
5.9%
는 55
 
4.6%
시 54
 
4.5%
술 53
 
4.4%
마 52
 
4.3%
0 42
 
3.5%
8 21
 
1.7%
7 20
 
1.7%
Other values (253) 663
55.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1077
89.3%
Decimal Number 86
 
7.1%
Uppercase Letter 17
 
1.4%
Space Separator 14
 
1.2%
Close Punctuation 5
 
0.4%
Open Punctuation 4
 
0.3%
Lowercase Letter 1
 
0.1%
Letter Number 1
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
래 88
 
8.2%
노 87
 
8.1%
홀 71
 
6.6%
는 55
 
5.1%
시 54
 
5.0%
술 53
 
4.9%
마 52
 
4.8%
이 20
 
1.9%
스 19
 
1.8%
지 13
 
1.2%
Other values (232) 565
52.5%
Uppercase Letter
ValueCountFrequency (%)
V 3
17.6%
P 3
17.6%
S 3
17.6%
I 2
11.8%
O 2
11.8%
T 1
 
5.9%
B 1
 
5.9%
M 1
 
5.9%
G 1
 
5.9%
Decimal Number
ValueCountFrequency (%)
0 42
48.8%
8 21
24.4%
7 20
23.3%
9 1
 
1.2%
2 1
 
1.2%
5 1
 
1.2%
Space Separator
ValueCountFrequency (%)
14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Lowercase Letter
ValueCountFrequency (%)
k 1
100.0%
Letter Number
ValueCountFrequency (%)
Ⅰ 1
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1077
89.3%
Common 110
 
9.1%
Latin 19
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
래 88
 
8.2%
노 87
 
8.1%
홀 71
 
6.6%
는 55
 
5.1%
시 54
 
5.0%
술 53
 
4.9%
마 52
 
4.8%
이 20
 
1.9%
스 19
 
1.8%
지 13
 
1.2%
Other values (232) 565
52.5%
Latin
ValueCountFrequency (%)
V 3
15.8%
P 3
15.8%
S 3
15.8%
I 2
10.5%
O 2
10.5%
k 1
 
5.3%
T 1
 
5.3%
Ⅰ 1
 
5.3%
B 1
 
5.3%
M 1
 
5.3%
Common
ValueCountFrequency (%)
0 42
38.2%
8 21
19.1%
7 20
18.2%
14
 
12.7%
) 5
 
4.5%
( 4
 
3.6%
9 1
 
0.9%
2 1
 
0.9%
5 1
 
0.9%
& 1
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1077
89.3%
ASCII 128
 
10.6%
Number Forms 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
래 88
 
8.2%
노 87
 
8.1%
홀 71
 
6.6%
는 55
 
5.1%
시 54
 
5.0%
술 53
 
4.9%
마 52
 
4.8%
이 20
 
1.9%
스 19
 
1.8%
지 13
 
1.2%
Other values (232) 565
52.5%
ASCII
ValueCountFrequency (%)
0 42
32.8%
8 21
16.4%
7 20
15.6%
14
 
10.9%
) 5
 
3.9%
( 4
 
3.1%
V 3
 
2.3%
P 3
 
2.3%
S 3
 
2.3%
I 2
 
1.6%
Other values (10) 11
 
8.6%
Number Forms
ValueCountFrequency (%)
Ⅰ 1
100.0%

소재지(도로명)
Text

Distinct202
Distinct (%)93.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T19:28:57.424528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length36
Mean length25.337963
Min length9

Characters and Unicode

Total characters5473
Distinct characters110
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

Unique188 ?
Unique (%)87.0%

Sample

1st row광주광역시 북구 서양로 164 (우산동)
2nd row광주광역시 북구 대자로 86 (운암동)
3rd row광주광역시 북구 경열로 지하 220 (유동)
4th row광주광역시 북구 제봉로 지하 255 (북동)
5th row광주광역시 북구 경양로119번길 18 (신안동)
ValueCountFrequency (%)
광주광역시 214
 
18.5%
북구 214
 
18.5%
신안동 38
 
3.3%
유동 29
 
2.5%
운암동 23
 
2.0%
2층 23
 
2.0%
중흥로 20
 
1.7%
용봉동 18
 
1.6%
중가로51번길 18
 
1.6%
저불로 12
 
1.0%
Other values (255) 545
47.2%
2023-12-12T19:28:58.225180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
938
17.1%
광 428
 
7.8%
( 246
 
4.5%
) 246
 
4.5%
동 228
 
4.2%
북 227
 
4.1%
역 214
 
3.9%
로 214
 
3.9%
시 214
 
3.9%
구 214
 
3.9%
Other values (100) 2304
42.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3198
58.4%
Space Separator 938
 
17.1%
Decimal Number 796
 
14.5%
Open Punctuation 246
 
4.5%
Close Punctuation 246
 
4.5%
Dash Punctuation 30
 
0.5%
Uppercase Letter 14
 
0.3%
Math Symbol 5
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 428
 
13.4%
동 228
 
7.1%
북 227
 
7.1%
역 214
 
6.7%
로 214
 
6.7%
시 214
 
6.7%
구 214
 
6.7%
주 214
 
6.7%
층 103
 
3.2%
번 72
 
2.3%
Other values (77) 1070
33.5%
Decimal Number
ValueCountFrequency (%)
1 196
24.6%
2 130
16.3%
5 98
12.3%
3 71
 
8.9%
6 61
 
7.7%
0 58
 
7.3%
7 49
 
6.2%
8 48
 
6.0%
4 47
 
5.9%
9 38
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
E 4
28.6%
P 2
14.3%
R 2
14.3%
C 2
14.3%
A 2
14.3%
L 2
14.3%
Math Symbol
ValueCountFrequency (%)
< 2
40.0%
> 2
40.0%
~ 1
20.0%
Space Separator
ValueCountFrequency (%)
938
100.0%
Open Punctuation
ValueCountFrequency (%)
( 246
100.0%
Close Punctuation
ValueCountFrequency (%)
) 246
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 30
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3198
58.4%
Common 2261
41.3%
Latin 14
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 428
 
13.4%
동 228
 
7.1%
북 227
 
7.1%
역 214
 
6.7%
로 214
 
6.7%
시 214
 
6.7%
구 214
 
6.7%
주 214
 
6.7%
층 103
 
3.2%
번 72
 
2.3%
Other values (77) 1070
33.5%
Common
ValueCountFrequency (%)
938
41.5%
( 246
 
10.9%
) 246
 
10.9%
1 196
 
8.7%
2 130
 
5.7%
5 98
 
4.3%
3 71
 
3.1%
6 61
 
2.7%
0 58
 
2.6%
7 49
 
2.2%
Other values (7) 168
 
7.4%
Latin
ValueCountFrequency (%)
E 4
28.6%
P 2
14.3%
R 2
14.3%
C 2
14.3%
A 2
14.3%
L 2
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3198
58.4%
ASCII 2275
41.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
938
41.2%
( 246
 
10.8%
) 246
 
10.8%
1 196
 
8.6%
2 130
 
5.7%
5 98
 
4.3%
3 71
 
3.1%
6 61
 
2.7%
0 58
 
2.5%
7 49
 
2.2%
Other values (13) 182
 
8.0%
Hangul
ValueCountFrequency (%)
광 428
 
13.4%
동 228
 
7.1%
북 227
 
7.1%
역 214
 
6.7%
로 214
 
6.7%
시 214
 
6.7%
구 214
 
6.7%
주 214
 
6.7%
층 103
 
3.2%
번 72
 
2.3%
Other values (77) 1070
33.5%

소재지(지번)
Text

Distinct201
Distinct (%)93.1%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T19:28:58.569998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length28
Mean length21.583333
Min length16

Characters and Unicode

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

Unique

Unique186 ?
Unique (%)86.1%

Sample

1st row광주광역시 북구 우산동 554-36
2nd row광주광역시 북구 운암동 447-3
3rd row광주광역시 북구 유동 8-2
4th row광주광역시 북구 북동 2-13
5th row광주광역시 북구 신안동 9-2
ValueCountFrequency (%)
광주광역시 216
22.2%
북구 216
22.2%
신안동 50
 
5.1%
유동 34
 
3.5%
용봉동 25
 
2.6%
운암동 24
 
2.5%
2층 19
 
2.0%
지상2층 16
 
1.6%
지하1층 14
 
1.4%
문흥동 12
 
1.2%
Other values (212) 345
35.5%
2023-12-12T19:28:59.187817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
969
20.8%
광 432
 
9.3%
1 288
 
6.2%
북 220
 
4.7%
시 216
 
4.6%
역 216
 
4.6%
구 216
 
4.6%
주 216
 
4.6%
동 216
 
4.6%
- 202
 
4.3%
Other values (44) 1471
31.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2376
51.0%
Decimal Number 1027
22.0%
Space Separator 969
20.8%
Dash Punctuation 202
 
4.3%
Close Punctuation 44
 
0.9%
Open Punctuation 44
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 432
18.2%
북 220
9.3%
시 216
9.1%
역 216
9.1%
구 216
9.1%
주 216
9.1%
동 216
9.1%
층 94
 
4.0%
지 64
 
2.7%
신 57
 
2.4%
Other values (30) 429
18.1%
Decimal Number
ValueCountFrequency (%)
1 288
28.0%
2 120
11.7%
3 101
 
9.8%
6 97
 
9.4%
5 82
 
8.0%
4 79
 
7.7%
0 69
 
6.7%
9 68
 
6.6%
7 65
 
6.3%
8 58
 
5.6%
Space Separator
ValueCountFrequency (%)
969
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 202
100.0%
Close Punctuation
ValueCountFrequency (%)
) 44
100.0%
Open Punctuation
ValueCountFrequency (%)
( 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2376
51.0%
Common 2286
49.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 432
18.2%
북 220
9.3%
시 216
9.1%
역 216
9.1%
구 216
9.1%
주 216
9.1%
동 216
9.1%
층 94
 
4.0%
지 64
 
2.7%
신 57
 
2.4%
Other values (30) 429
18.1%
Common
ValueCountFrequency (%)
969
42.4%
1 288
 
12.6%
- 202
 
8.8%
2 120
 
5.2%
3 101
 
4.4%
6 97
 
4.2%
5 82
 
3.6%
4 79
 
3.5%
0 69
 
3.0%
9 68
 
3.0%
Other values (4) 211
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2376
51.0%
ASCII 2286
49.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
969
42.4%
1 288
 
12.6%
- 202
 
8.8%
2 120
 
5.2%
3 101
 
4.4%
6 97
 
4.2%
5 82
 
3.6%
4 79
 
3.5%
0 69
 
3.0%
9 68
 
3.0%
Other values (4) 211
 
9.2%
Hangul
ValueCountFrequency (%)
광 432
18.2%
북 220
9.3%
시 216
9.1%
역 216
9.1%
구 216
9.1%
주 216
9.1%
동 216
9.1%
층 94
 
4.0%
지 64
 
2.7%
신 57
 
2.4%
Other values (30) 429
18.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-09-22
216 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-22
2nd row2023-09-22
3rd row2023-09-22
4th row2023-09-22
5th row2023-09-22

Common Values

ValueCountFrequency (%)
2023-09-22 216
100.0%

Length

2023-12-12T19:28:59.359009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:28:59.480772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-22 216
100.0%

Missing values

2023-12-12T19:28:56.028088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:28:56.130605image/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

업종명업소명소재지(도로명)소재지(지번)데이터기준일자
0유흥주점영업센스노래홀광주광역시 북구 서양로 164 (우산동)광주광역시 북구 우산동 554-362023-09-22
1유흥주점영업본노래홀광주광역시 북구 대자로 86 (운암동)광주광역시 북구 운암동 447-32023-09-22
2유흥주점영업워커힐광주광역시 북구 경열로 지하 220 (유동)광주광역시 북구 유동 8-22023-09-22
3유흥주점영업케이투광주광역시 북구 제봉로 지하 255 (북동)광주광역시 북구 북동 2-132023-09-22
4유흥주점영업오드리광주광역시 북구 경양로119번길 18 (신안동)광주광역시 북구 신안동 9-22023-09-22
5유흥주점영업미강광주광역시 북구 중흥로 99 (신안동)광주광역시 북구 신안동 16-52023-09-22
6유흥주점영업골프룸소주방광주광역시 북구 경열로 215 (유동)광주광역시 북구 유동 109-152023-09-22
7유흥주점영업하모니광주광역시 북구 서하로 373 (문흥동)광주광역시 북구 문흥동 998-32023-09-22
8유흥주점영업부킹광주광역시 북구 설죽로 514 (일곡동 지하1층)광주광역시 북구 일곡동 830-2 지하1층2023-09-22
9유흥주점영업파라오노래타운광주광역시 북구 문산로 43 (문흥동)광주광역시 북구 문흥동 997-112023-09-22
업종명업소명소재지(도로명)소재지(지번)데이터기준일자
206단란주점술마시는 그래그래 가자 노래홀광주광역시 북구 첨단연신로91번길 20-7 신용동 3층 303호 (신용동)광주광역시 북구 신용동 715 3층 303호2023-09-22
207단란주점레파토리7080광주광역시 북구 중흥로 96 3층 (신안동)광주광역시 북구 신안동 144-1 3층2023-09-22
208단란주점술마시는놀자노래홀광주광역시 북구 북문대로19번길 8 지상2층 (운암동)광주광역시 북구 운암동 96-26 지상2층2023-09-22
209단란주점럭키7080광주광역시 북구 안산로 47-6 지하1층 (오치동)광주광역시 북구 오치동 856-24 지하1층2023-09-22
210단란주점술마시는달콤소주룸광주광역시 북구 중흥로 107 2층 (신안동)광주광역시 북구 신안동 118-4 지상2층2023-09-22
211단란주점별밤7080광주광역시 북구 첨단연신로107번길 45-11 3층 (신용동)광주광역시 북구 신용동 7012023-09-22
212단란주점레알 룸 소주방광주광역시 북구 중흥로 95 2층 (신안동)광주광역시 북구 신안동 120-4 2층2023-09-22
213단란주점미팅7080광주광역시 북구 대자로 80-1 2층 (운암동)광주광역시 북구 운암동 447-17 2층2023-09-22
214단란주점노래하는호프백악관광주광역시 북구 무등로202번길 42 1층 (신안동)광주광역시 북구 신안동 144-2 1층2023-09-22
215단란주점술마시는첫번째노래홀광주광역시 북구 중가로51번길 32 2층 (유동)광주광역시 북구 유동 101-182023-09-22