Overview

Dataset statistics

Number of variables5
Number of observations932
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory37.4 KiB
Average record size in memory41.1 B

Variable types

Numeric1
Categorical2
Text2

Dataset

Descriptionㅇ 주로 주류를 조리ㆍ판매하는 영업으로서 손님이 노래를 부르는 행위가 허용되는 단란주점 업소정보
Author경상남도
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15069259

Alerts

업종 has constant value ""Constant
연번 is highly overall correlated with 인허가관할기관High correlation
인허가관할기관 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:34:05.388786
Analysis finished2023-12-10 23:34:06.081471
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct932
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean466.5
Minimum1
Maximum932
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.3 KiB
2023-12-11T08:34:06.148469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile47.55
Q1233.75
median466.5
Q3699.25
95-th percentile885.45
Maximum932
Range931
Interquartile range (IQR)465.5

Descriptive statistics

Standard deviation269.18952
Coefficient of variation (CV)0.57704078
Kurtosis-1.2
Mean466.5
Median Absolute Deviation (MAD)233
Skewness0
Sum434778
Variance72463
MonotonicityStrictly increasing
2023-12-11T08:34:06.271526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
628 1
 
0.1%
616 1
 
0.1%
617 1
 
0.1%
618 1
 
0.1%
619 1
 
0.1%
620 1
 
0.1%
621 1
 
0.1%
622 1
 
0.1%
623 1
 
0.1%
Other values (922) 922
98.9%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
932 1
0.1%
931 1
0.1%
930 1
0.1%
929 1
0.1%
928 1
0.1%
927 1
0.1%
926 1
0.1%
925 1
0.1%
924 1
0.1%
923 1
0.1%

인허가관할기관
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size7.4 KiB
진주시
114 
창원시 마산합포구
113 
김해시
97 
양산시
87 
창원시 마산회원구
74 
Other values (17)
447 

Length

Max length9
Median length3
Mean length4.7103004
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row거제시
2nd row거제시
3rd row거제시
4th row거제시
5th row거제시

Common Values

ValueCountFrequency (%)
진주시 114
12.2%
창원시 마산합포구 113
12.1%
김해시 97
10.4%
양산시 87
9.3%
창원시 마산회원구 74
 
7.9%
거제시 64
 
6.9%
통영시 50
 
5.4%
사천시 45
 
4.8%
창원시 의창구 43
 
4.6%
창원시 성산구 42
 
4.5%
Other values (12) 203
21.8%

Length

2023-12-11T08:34:06.393156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
창원시 305
24.7%
진주시 114
 
9.2%
마산합포구 113
 
9.1%
김해시 97
 
7.8%
양산시 87
 
7.0%
마산회원구 74
 
6.0%
거제시 64
 
5.2%
통영시 50
 
4.0%
사천시 45
 
3.6%
의창구 43
 
3.5%
Other values (13) 245
19.8%

업소명
Text

Distinct889
Distinct (%)95.4%
Missing0
Missing (%)0.0%
Memory size7.4 KiB
2023-12-11T08:34:06.645665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length16
Mean length5.8540773
Min length1

Characters and Unicode

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

Unique

Unique851 ?
Unique (%)91.3%

Sample

1st row질러가라오케
2nd row가라오케 로제
3rd row7080비틀즈
4th row아네모네단란주점
5th row708090라이브
ValueCountFrequency (%)
단란주점 37
 
3.6%
가라오케 11
 
1.1%
라이브 7
 
0.7%
7080 6
 
0.6%
노래주점 5
 
0.5%
현대단란주점 4
 
0.4%
노래방 4
 
0.4%
귀빈단란주점 4
 
0.4%
칼라 3
 
0.3%
오렌지 3
 
0.3%
Other values (903) 949
91.9%
2023-12-11T08:34:07.057712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 388
 
7.1%
점 380
 
7.0%
란 334
 
6.1%
단 333
 
6.1%
라 208
 
3.8%
이 141
 
2.6%
오 135
 
2.5%
가 128
 
2.3%
노 121
 
2.2%
래 114
 
2.1%
Other values (539) 3174
58.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4958
90.9%
Decimal Number 218
 
4.0%
Space Separator 103
 
1.9%
Uppercase Letter 97
 
1.8%
Close Punctuation 25
 
0.5%
Open Punctuation 25
 
0.5%
Lowercase Letter 23
 
0.4%
Other Punctuation 6
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 388
 
7.8%
점 380
 
7.7%
란 334
 
6.7%
단 333
 
6.7%
라 208
 
4.2%
이 141
 
2.8%
오 135
 
2.7%
가 128
 
2.6%
노 121
 
2.4%
래 114
 
2.3%
Other values (488) 2676
54.0%
Uppercase Letter
ValueCountFrequency (%)
A 13
13.4%
B 10
 
10.3%
M 8
 
8.2%
I 8
 
8.2%
O 6
 
6.2%
N 6
 
6.2%
D 6
 
6.2%
E 6
 
6.2%
J 5
 
5.2%
H 3
 
3.1%
Other values (13) 26
26.8%
Decimal Number
ValueCountFrequency (%)
0 92
42.2%
8 49
22.5%
7 41
18.8%
1 10
 
4.6%
2 9
 
4.1%
9 6
 
2.8%
5 4
 
1.8%
6 3
 
1.4%
4 3
 
1.4%
3 1
 
0.5%
Lowercase Letter
ValueCountFrequency (%)
a 5
21.7%
l 5
21.7%
u 3
13.0%
p 2
 
8.7%
o 2
 
8.7%
r 2
 
8.7%
n 1
 
4.3%
m 1
 
4.3%
h 1
 
4.3%
i 1
 
4.3%
Other Punctuation
ValueCountFrequency (%)
! 2
33.3%
& 2
33.3%
. 1
16.7%
, 1
16.7%
Space Separator
ValueCountFrequency (%)
103
100.0%
Close Punctuation
ValueCountFrequency (%)
) 25
100.0%
Open Punctuation
ValueCountFrequency (%)
( 25
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4956
90.8%
Common 378
 
6.9%
Latin 120
 
2.2%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 388
 
7.8%
점 380
 
7.7%
란 334
 
6.7%
단 333
 
6.7%
라 208
 
4.2%
이 141
 
2.8%
오 135
 
2.7%
가 128
 
2.6%
노 121
 
2.4%
래 114
 
2.3%
Other values (486) 2674
54.0%
Latin
ValueCountFrequency (%)
A 13
 
10.8%
B 10
 
8.3%
M 8
 
6.7%
I 8
 
6.7%
O 6
 
5.0%
N 6
 
5.0%
D 6
 
5.0%
E 6
 
5.0%
J 5
 
4.2%
a 5
 
4.2%
Other values (23) 47
39.2%
Common
ValueCountFrequency (%)
103
27.2%
0 92
24.3%
8 49
13.0%
7 41
 
10.8%
) 25
 
6.6%
( 25
 
6.6%
1 10
 
2.6%
2 9
 
2.4%
9 6
 
1.6%
5 4
 
1.1%
Other values (8) 14
 
3.7%
Han
ValueCountFrequency (%)
白 1
50.0%
潮 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4956
90.8%
ASCII 498
 
9.1%
CJK 2
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 388
 
7.8%
점 380
 
7.7%
란 334
 
6.7%
단 333
 
6.7%
라 208
 
4.2%
이 141
 
2.8%
오 135
 
2.7%
가 128
 
2.6%
노 121
 
2.4%
래 114
 
2.3%
Other values (486) 2674
54.0%
ASCII
ValueCountFrequency (%)
103
20.7%
0 92
18.5%
8 49
9.8%
7 41
 
8.2%
) 25
 
5.0%
( 25
 
5.0%
A 13
 
2.6%
B 10
 
2.0%
1 10
 
2.0%
2 9
 
1.8%
Other values (41) 121
24.3%
CJK
ValueCountFrequency (%)
白 1
50.0%
潮 1
50.0%

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.4 KiB
단란주점
932 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단란주점
2nd row단란주점
3rd row단란주점
4th row단란주점
5th row단란주점

Common Values

ValueCountFrequency (%)
단란주점 932
100.0%

Length

2023-12-11T08:34:07.178550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:34:07.271023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단란주점 932
100.0%

업소주소
Text

Distinct924
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size7.4 KiB
2023-12-11T08:34:07.543885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length43
Mean length28.025751
Min length18

Characters and Unicode

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

Unique

Unique916 ?
Unique (%)98.3%

Sample

1st row경상남도 거제시 아주1로2길 23(1층 아주동)
2nd row경상남도 거제시 거제중앙로26길 17-1(1층 고현동)
3rd row경상남도 거제시 고현로9길 14(3층 고현동)
4th row경상남도 거제시 고현로 95(고현동,지하)
5th row경상남도 거제시 아주1로2길 46(2층 아주동)
ValueCountFrequency (%)
경상남도 932
 
19.2%
창원시 305
 
6.3%
진주시 114
 
2.4%
마산합포구 113
 
2.3%
김해시 97
 
2.0%
양산시 87
 
1.8%
마산회원구 74
 
1.5%
거제시 64
 
1.3%
의창구 53
 
1.1%
통영시 50
 
1.0%
Other values (1616) 2956
61.0%
2023-12-11T08:34:08.109688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3920
 
15.0%
상 1081
 
4.1%
남 1081
 
4.1%
1 1015
 
3.9%
도 946
 
3.6%
경 940
 
3.6%
동 850
 
3.3%
시 825
 
3.2%
) 790
 
3.0%
( 790
 
3.0%
Other values (278) 13882
53.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16066
61.5%
Decimal Number 4029
 
15.4%
Space Separator 3920
 
15.0%
Close Punctuation 790
 
3.0%
Open Punctuation 790
 
3.0%
Other Punctuation 280
 
1.1%
Dash Punctuation 230
 
0.9%
Uppercase Letter 15
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
상 1081
 
6.7%
남 1081
 
6.7%
도 946
 
5.9%
경 940
 
5.9%
동 850
 
5.3%
시 825
 
5.1%
로 645
 
4.0%
길 502
 
3.1%
층 497
 
3.1%
원 467
 
2.9%
Other values (253) 8232
51.2%
Decimal Number
ValueCountFrequency (%)
1 1015
25.2%
2 734
18.2%
3 456
11.3%
5 316
 
7.8%
0 311
 
7.7%
4 296
 
7.3%
6 256
 
6.4%
7 241
 
6.0%
9 203
 
5.0%
8 201
 
5.0%
Uppercase Letter
ValueCountFrequency (%)
B 6
40.0%
C 3
20.0%
J 1
 
6.7%
S 1
 
6.7%
Y 1
 
6.7%
N 1
 
6.7%
A 1
 
6.7%
P 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
, 268
95.7%
· 11
 
3.9%
. 1
 
0.4%
Space Separator
ValueCountFrequency (%)
3920
100.0%
Close Punctuation
ValueCountFrequency (%)
) 790
100.0%
Open Punctuation
ValueCountFrequency (%)
( 790
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 230
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16066
61.5%
Common 10039
38.4%
Latin 15
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
상 1081
 
6.7%
남 1081
 
6.7%
도 946
 
5.9%
경 940
 
5.9%
동 850
 
5.3%
시 825
 
5.1%
로 645
 
4.0%
길 502
 
3.1%
층 497
 
3.1%
원 467
 
2.9%
Other values (253) 8232
51.2%
Common
ValueCountFrequency (%)
3920
39.0%
1 1015
 
10.1%
) 790
 
7.9%
( 790
 
7.9%
2 734
 
7.3%
3 456
 
4.5%
5 316
 
3.1%
0 311
 
3.1%
4 296
 
2.9%
, 268
 
2.7%
Other values (7) 1143
 
11.4%
Latin
ValueCountFrequency (%)
B 6
40.0%
C 3
20.0%
J 1
 
6.7%
S 1
 
6.7%
Y 1
 
6.7%
N 1
 
6.7%
A 1
 
6.7%
P 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16066
61.5%
ASCII 10043
38.4%
None 11
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3920
39.0%
1 1015
 
10.1%
) 790
 
7.9%
( 790
 
7.9%
2 734
 
7.3%
3 456
 
4.5%
5 316
 
3.1%
0 311
 
3.1%
4 296
 
2.9%
, 268
 
2.7%
Other values (14) 1147
 
11.4%
Hangul
ValueCountFrequency (%)
상 1081
 
6.7%
남 1081
 
6.7%
도 946
 
5.9%
경 940
 
5.9%
동 850
 
5.3%
시 825
 
5.1%
로 645
 
4.0%
길 502
 
3.1%
층 497
 
3.1%
원 467
 
2.9%
Other values (253) 8232
51.2%
None
ValueCountFrequency (%)
· 11
100.0%

Interactions

2023-12-11T08:34:05.785814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:34:08.219010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번인허가관할기관
연번1.0000.982
인허가관할기관0.9821.000
2023-12-11T08:34:08.310516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번인허가관할기관
연번1.0000.891
인허가관할기관0.8911.000

Missing values

2023-12-11T08:34:05.963140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:34:06.048001image/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거제시질러가라오케단란주점경상남도 거제시 아주1로2길 23(1층 아주동)
12거제시가라오케 로제단란주점경상남도 거제시 거제중앙로26길 17-1(1층 고현동)
23거제시7080비틀즈단란주점경상남도 거제시 고현로9길 14(3층 고현동)
34거제시아네모네단란주점단란주점경상남도 거제시 고현로 95(고현동,지하)
45거제시708090라이브단란주점경상남도 거제시 아주1로2길 46(2층 아주동)
56거제시꽃잎가라오케단란주점경상남도 거제시 장평로10길 5(신성프라임빌딩 3층 장평동)
67거제시아메리카단란주점경상남도 거제시 고현로9길 5-1(고현동,2층)
78거제시불꽃가라오케단란주점경상남도 거제시 고현로9길 14(2층 고현동)
89거제시지중해단란주점단란주점경상남도 거제시 일운면 지세포해안로 90-13
910거제시보스단란주점경상남도 거제시 옥포성안로 32(옥포동,지하)
연번인허가관할기관업소명업종업소주소
922923합천군예향단란주점단란주점경상남도 합천군 가야면 가야시장로 58-1
923924합천군황강단란주점단란주점경상남도 합천군 대병면 서부로 1978(지하 1층)
924925합천군귀빈단란주점단란주점경상남도 합천군 초계면 초계중앙로 11
925926합천군라스베가스단란주점경상남도 합천군 가야면 가야시장로 69(3층)
926927합천군모모단란주점단란주점경상남도 합천군 초계면 내동1길 3-2
927928합천군양지단란주점단란주점경상남도 합천군 합천읍 대야로 807
928929합천군금호단란주점단란주점경상남도 합천군 초계면 초계1길 9-38(1층)
929930합천군향명단란주점단란주점경상남도 합천군 합천읍 충효로 71-1
930931합천군물결소리노래주점단란주점경상남도 합천군 가야면 가야시장로 106
931932합천군박카스단란주점경상남도 합천군 초계면 내동아막길 7-6