Overview

Dataset statistics

Number of variables9
Number of observations183
Missing cells99
Missing cells (%)6.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.2 KiB
Average record size in memory73.7 B

Variable types

Numeric1
Categorical2
Text3
Boolean1
DateTime2

Dataset

Description광주광역시 광산구 관내에 위치한 유흥주점 현황 정보(구분, 사업장명, 위생업태명, 주소, 전화번호, 다중이용업소여부, 허가일 등)를 제공합니다.
Author광주광역시 광산구
URLhttps://www.data.go.kr/data/15108741/fileData.do

Alerts

구분 has constant value ""Constant
다중이용업소여부 has constant value ""Constant
데이터기준일자 has constant value ""Constant
위생업태명 is highly imbalanced (63.6%)Imbalance
전화번호 has 99 (54.1%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:22:31.591512
Analysis finished2023-12-12 06:22:32.552667
Duration0.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct183
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean92
Minimum1
Maximum183
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2023-12-12T15:22:32.629361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.1
Q146.5
median92
Q3137.5
95-th percentile173.9
Maximum183
Range182
Interquartile range (IQR)91

Descriptive statistics

Standard deviation52.971691
Coefficient of variation (CV)0.57577925
Kurtosis-1.2
Mean92
Median Absolute Deviation (MAD)46
Skewness0
Sum16836
Variance2806
MonotonicityStrictly increasing
2023-12-12T15:22:32.818575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
127 1
 
0.5%
118 1
 
0.5%
119 1
 
0.5%
120 1
 
0.5%
121 1
 
0.5%
122 1
 
0.5%
123 1
 
0.5%
124 1
 
0.5%
125 1
 
0.5%
Other values (173) 173
94.5%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
183 1
0.5%
182 1
0.5%
181 1
0.5%
180 1
0.5%
179 1
0.5%
178 1
0.5%
177 1
0.5%
176 1
0.5%
175 1
0.5%
174 1
0.5%

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
유흥주점영업
183 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
유흥주점영업 183
100.0%

Length

2023-12-12T15:22:32.968269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:22:33.098835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 183
100.0%

사업장명
Text

Distinct179
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T15:22:33.365385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length5.3934426
Min length1

Characters and Unicode

Total characters987
Distinct characters250
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

Unique176 ?
Unique (%)96.2%

Sample

1st rowMGM나이트클럽
2nd row발렌타인
3rd row뉴스타(New Star)음악홀
4th row바나나노래홀
5th row베트남노래홀
ValueCountFrequency (%)
럭셔리수룸소주방 3
 
1.6%
황금음악홀 2
 
1.1%
필음악홀 2
 
1.1%
삼다수 2
 
1.1%
음악홀 2
 
1.1%
룰루음악홀 1
 
0.5%
top(티오피)음악홀 1
 
0.5%
빠담빠담 1
 
0.5%
밀크2 1
 
0.5%
스토리유흥홀 1
 
0.5%
Other values (171) 171
91.4%
2023-12-12T15:22:33.866452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
홀 89
 
9.0%
악 62
 
6.3%
음 61
 
6.2%
주 32
 
3.2%
래 28
 
2.8%
노 27
 
2.7%
스 26
 
2.6%
소 25
 
2.5%
방 25
 
2.5%
이 25
 
2.5%
Other values (240) 587
59.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 894
90.6%
Uppercase Letter 30
 
3.0%
Decimal Number 15
 
1.5%
Lowercase Letter 15
 
1.5%
Close Punctuation 13
 
1.3%
Open Punctuation 13
 
1.3%
Space Separator 4
 
0.4%
Dash Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홀 89
 
10.0%
악 62
 
6.9%
음 61
 
6.8%
주 32
 
3.6%
래 28
 
3.1%
노 27
 
3.0%
스 26
 
2.9%
소 25
 
2.8%
방 25
 
2.8%
이 25
 
2.8%
Other values (203) 494
55.3%
Uppercase Letter
ValueCountFrequency (%)
M 4
13.3%
B 3
10.0%
S 3
10.0%
J 2
 
6.7%
W 2
 
6.7%
N 2
 
6.7%
P 2
 
6.7%
I 2
 
6.7%
E 2
 
6.7%
T 2
 
6.7%
Other values (6) 6
20.0%
Lowercase Letter
ValueCountFrequency (%)
u 3
20.0%
g 2
13.3%
s 2
13.3%
p 1
 
6.7%
b 1
 
6.7%
k 1
 
6.7%
r 1
 
6.7%
a 1
 
6.7%
t 1
 
6.7%
w 1
 
6.7%
Decimal Number
ValueCountFrequency (%)
0 4
26.7%
2 4
26.7%
7 3
20.0%
8 2
13.3%
1 1
 
6.7%
9 1
 
6.7%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Space Separator
ValueCountFrequency (%)
4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 894
90.6%
Common 48
 
4.9%
Latin 45
 
4.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홀 89
 
10.0%
악 62
 
6.9%
음 61
 
6.8%
주 32
 
3.6%
래 28
 
3.1%
노 27
 
3.0%
스 26
 
2.9%
소 25
 
2.8%
방 25
 
2.8%
이 25
 
2.8%
Other values (203) 494
55.3%
Latin
ValueCountFrequency (%)
M 4
 
8.9%
B 3
 
6.7%
u 3
 
6.7%
S 3
 
6.7%
g 2
 
4.4%
s 2
 
4.4%
J 2
 
4.4%
W 2
 
4.4%
N 2
 
4.4%
P 2
 
4.4%
Other values (17) 20
44.4%
Common
ValueCountFrequency (%)
) 13
27.1%
( 13
27.1%
0 4
 
8.3%
2 4
 
8.3%
4
 
8.3%
7 3
 
6.2%
- 3
 
6.2%
8 2
 
4.2%
1 1
 
2.1%
9 1
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 894
90.6%
ASCII 93
 
9.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
홀 89
 
10.0%
악 62
 
6.9%
음 61
 
6.8%
주 32
 
3.6%
래 28
 
3.1%
노 27
 
3.0%
스 26
 
2.9%
소 25
 
2.8%
방 25
 
2.8%
이 25
 
2.8%
Other values (203) 494
55.3%
ASCII
ValueCountFrequency (%)
) 13
 
14.0%
( 13
 
14.0%
M 4
 
4.3%
0 4
 
4.3%
2 4
 
4.3%
4
 
4.3%
7 3
 
3.2%
B 3
 
3.2%
u 3
 
3.2%
S 3
 
3.2%
Other values (27) 39
41.9%

위생업태명
Categorical

IMBALANCE 

Distinct6
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
룸살롱
155 
기타
 
12
비어(바)살롱
 
5
간이주점
 
4
노래클럽
 
4

Length

Max length9
Median length3
Mean length3.1857923
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고고(디스코)클럽
2nd row룸살롱
3rd row룸살롱
4th row룸살롱
5th row간이주점

Common Values

ValueCountFrequency (%)
룸살롱 155
84.7%
기타 12
 
6.6%
비어(바)살롱 5
 
2.7%
간이주점 4
 
2.2%
노래클럽 4
 
2.2%
고고(디스코)클럽 3
 
1.6%

Length

2023-12-12T15:22:34.071543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:22:34.194568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
룸살롱 155
84.7%
기타 12
 
6.6%
비어(바)살롱 5
 
2.7%
간이주점 4
 
2.2%
노래클럽 4
 
2.2%
고고(디스코)클럽 3
 
1.6%

주소
Text

Distinct166
Distinct (%)90.7%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T15:22:34.454758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length42
Mean length33.540984
Min length23

Characters and Unicode

Total characters6138
Distinct characters80
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

Unique149 ?
Unique (%)81.4%

Sample

1st row광주광역시 광산구 무진대로212번길 13-33 (우산동)
2nd row광주광역시 광산구 무진대로231번길 23 (우산동)
3rd row광주광역시 광산구 무진대로211번길 21-23 (우산동)
4th row광주광역시 광산구 무진대로212번길 21 (우산동)
5th row광주광역시 광산구 무진대로211번길 29-17 (우산동)
ValueCountFrequency (%)
광주광역시 183
17.9%
광산구 183
17.9%
쌍암동 52
 
5.1%
2층 48
 
4.7%
첨단중앙로152번길 42
 
4.1%
우산동 29
 
2.8%
월계동 27
 
2.6%
임방울대로800번길 26
 
2.5%
3층 19
 
1.9%
쌍암동,(2층 19
 
1.9%
Other values (178) 392
38.4%
2023-12-12T15:22:34.910499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
837
 
13.6%
광 551
 
9.0%
2 303
 
4.9%
1 266
 
4.3%
) 241
 
3.9%
( 241
 
3.9%
산 218
 
3.6%
동 186
 
3.0%
역 183
 
3.0%
시 183
 
3.0%
Other values (70) 2929
47.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3438
56.0%
Decimal Number 1167
 
19.0%
Space Separator 837
 
13.6%
Close Punctuation 241
 
3.9%
Open Punctuation 241
 
3.9%
Other Punctuation 141
 
2.3%
Dash Punctuation 72
 
1.2%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 551
16.0%
산 218
 
6.3%
동 186
 
5.4%
역 183
 
5.3%
시 183
 
5.3%
구 183
 
5.3%
로 183
 
5.3%
주 183
 
5.3%
길 173
 
5.0%
번 173
 
5.0%
Other values (54) 1222
35.5%
Decimal Number
ValueCountFrequency (%)
2 303
26.0%
1 266
22.8%
3 119
 
10.2%
0 113
 
9.7%
5 103
 
8.8%
8 83
 
7.1%
6 76
 
6.5%
7 40
 
3.4%
4 40
 
3.4%
9 24
 
2.1%
Space Separator
ValueCountFrequency (%)
837
100.0%
Close Punctuation
ValueCountFrequency (%)
) 241
100.0%
Open Punctuation
ValueCountFrequency (%)
( 241
100.0%
Other Punctuation
ValueCountFrequency (%)
, 141
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3438
56.0%
Common 2699
44.0%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 551
16.0%
산 218
 
6.3%
동 186
 
5.4%
역 183
 
5.3%
시 183
 
5.3%
구 183
 
5.3%
로 183
 
5.3%
주 183
 
5.3%
길 173
 
5.0%
번 173
 
5.0%
Other values (54) 1222
35.5%
Common
ValueCountFrequency (%)
837
31.0%
2 303
 
11.2%
1 266
 
9.9%
) 241
 
8.9%
( 241
 
8.9%
, 141
 
5.2%
3 119
 
4.4%
0 113
 
4.2%
5 103
 
3.8%
8 83
 
3.1%
Other values (5) 252
 
9.3%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3438
56.0%
ASCII 2700
44.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
837
31.0%
2 303
 
11.2%
1 266
 
9.9%
) 241
 
8.9%
( 241
 
8.9%
, 141
 
5.2%
3 119
 
4.4%
0 113
 
4.2%
5 103
 
3.8%
8 83
 
3.1%
Other values (6) 253
 
9.4%
Hangul
ValueCountFrequency (%)
광 551
16.0%
산 218
 
6.3%
동 186
 
5.4%
역 183
 
5.3%
시 183
 
5.3%
구 183
 
5.3%
로 183
 
5.3%
주 183
 
5.3%
길 173
 
5.0%
번 173
 
5.0%
Other values (54) 1222
35.5%

전화번호
Text

MISSING 

Distinct83
Distinct (%)98.8%
Missing99
Missing (%)54.1%
Memory size1.6 KiB
2023-12-12T15:22:35.215598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.952381
Min length12

Characters and Unicode

Total characters1172
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique82 ?
Unique (%)97.6%

Sample

1st row 062- 945-0902
2nd row 062- 954-0715
3rd row 062- 955-5659
4th row062 -944 -2220
5th row 062- 956-0077
ValueCountFrequency (%)
062 78
40.0%
971 6
 
3.1%
973 6
 
3.1%
953 3
 
1.5%
954 2
 
1.0%
972 2
 
1.0%
945-6969 2
 
1.0%
8801 1
 
0.5%
940 1
 
0.5%
973-7546 1
 
0.5%
Other values (93) 93
47.7%
2023-12-12T15:22:35.629022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 168
14.3%
163
13.9%
2 131
11.2%
0 130
11.1%
6 117
10.0%
9 109
9.3%
7 91
7.8%
5 73
6.2%
3 67
 
5.7%
1 54
 
4.6%
Other values (2) 69
5.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 841
71.8%
Dash Punctuation 168
 
14.3%
Space Separator 163
 
13.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 131
15.6%
0 130
15.5%
6 117
13.9%
9 109
13.0%
7 91
10.8%
5 73
8.7%
3 67
8.0%
1 54
6.4%
4 36
 
4.3%
8 33
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 168
100.0%
Space Separator
ValueCountFrequency (%)
163
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1172
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 168
14.3%
163
13.9%
2 131
11.2%
0 130
11.1%
6 117
10.0%
9 109
9.3%
7 91
7.8%
5 73
6.2%
3 67
 
5.7%
1 54
 
4.6%
Other values (2) 69
5.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1172
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 168
14.3%
163
13.9%
2 131
11.2%
0 130
11.1%
6 117
10.0%
9 109
9.3%
7 91
7.8%
5 73
6.2%
3 67
 
5.7%
1 54
 
4.6%
Other values (2) 69
5.9%

다중이용업소여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size315.0 B
True
183 
ValueCountFrequency (%)
True 183
100.0%
2023-12-12T15:22:35.774897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

허가(신고)일
Date

Distinct168
Distinct (%)91.8%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum1978-04-24 00:00:00
Maximum2023-10-12 00:00:00
2023-12-12T15:22:35.880561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:22:36.042287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2023-10-30 00:00:00
Maximum2023-10-30 00:00:00
2023-12-12T15:22:36.193381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:22:36.284804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T15:22:31.977603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:22:36.375661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위생업태명전화번호
연번1.0000.3620.981
위생업태명0.3621.0001.000
전화번호0.9811.0001.000
2023-12-12T15:22:36.463620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위생업태명
연번1.0000.197
위생업태명0.1971.000

Missing values

2023-12-12T15:22:32.132929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:22:32.476570image/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유흥주점영업MGM나이트클럽고고(디스코)클럽광주광역시 광산구 무진대로212번길 13-33 (우산동)062- 945-0902Y1997-11-112023-10-30
12유흥주점영업발렌타인룸살롱광주광역시 광산구 무진대로231번길 23 (우산동)062- 954-0715Y1978-04-242023-10-30
23유흥주점영업뉴스타(New Star)음악홀룸살롱광주광역시 광산구 무진대로211번길 21-23 (우산동)062- 955-5659Y1996-04-122023-10-30
34유흥주점영업바나나노래홀룸살롱광주광역시 광산구 무진대로212번길 21 (우산동)062 -944 -2220Y1996-06-102023-10-30
45유흥주점영업베트남노래홀간이주점광주광역시 광산구 무진대로211번길 29-17 (우산동)062- 956-0077Y1996-06-212023-10-30
56유흥주점영업앗싸좋아좋아노래홀룸살롱광주광역시 광산구 무진대로212번길 21 (우산동)062 -943 -0790Y1996-06-262023-10-30
67유흥주점영업오페라룸살롱광주광역시 광산구 무진대로231번길 13-8 (우산동)<NA>Y1996-11-112023-10-30
78유흥주점영업고래고래룸살롱광주광역시 광산구 무진대로211번길 29-5 (우산동, 지하1층)062- 955-6799Y1996-12-302023-10-30
89유흥주점영업어머나노래타운룸살롱광주광역시 광산구 무진대로231번길 13-8 (우산동)062- 955-4870Y1997-03-102023-10-30
910유흥주점영업광주노래클럽(DIEMHEN)룸살롱광주광역시 광산구 사암로216번길 10-11 (우산동)062- 953-5225Y2001-10-092023-10-30
연번구분사업장명위생업태명주소전화번호다중이용업소여부허가(신고)일데이터기준일자
173174유흥주점영업벅스(Bugs)룸소주방룸살롱광주광역시 광산구 임방울대로800번길 11-2, 2층 (월계동)<NA>Y2020-04-222023-10-30
174175유흥주점영업벅스(Bugs)음악홀룸살롱광주광역시 광산구 임방울대로800번길 11-2, 2층 (월계동)<NA>Y2020-04-222023-10-30
175176유흥주점영업쓰리포노래클럽광주광역시 광산구 임방울대로801번길 32, 2층 (쌍암동)<NA>Y2022-10-282023-10-30
176177유흥주점영업지세븐룸소주방룸살롱광주광역시 광산구 임방울대로826번길 60-2, 2층 (월계동)<NA>Y2023-04-062023-10-30
177178유흥주점영업망고음악홀룸살롱광주광역시 광산구 첨단중앙로182번길 24-6, 2층 (쌍암동)<NA>Y2023-04-142023-10-30
178179유흥주점영업망고룸소주방노래클럽광주광역시 광산구 첨단중앙로182번길 24-6, 2층 (쌍암동)<NA>Y2023-04-242023-10-30
179180유흥주점영업제이제이룸소주방(JJ룸소주방)기타광주광역시 광산구 임방울대로800번길 52, 3층 301호 (월계동)<NA>Y2023-09-212023-10-30
180181유흥주점영업아델룸소주방기타광주광역시 광산구 임방울대로826번길 25, 2층 203호 (쌍암동)<NA>Y2023-09-272023-10-30
181182유흥주점영업첨단물나이트클럽기타광주광역시 광산구 임방울대로800번길 52, 2층 201호 (월계동)<NA>Y2023-09-272023-10-30
182183유흥주점영업슈가맨기타광주광역시 광산구 임방울대로800번길 42, 2층 (월계동)<NA>Y2023-10-122023-10-30