Overview

Dataset statistics

Number of variables6
Number of observations526
Missing cells40
Missing cells (%)1.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.3 KiB
Average record size in memory49.3 B

Variable types

Categorical1
Text3
Numeric1
DateTime1

Dataset

Description제주특별자치도 제주시 관내에 소재하고 있는 유흥주점 관련 현황 데이터를 제공합니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15045368/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 40 (7.6%) missing valuesMissing

Reproduction

Analysis started2023-12-11 22:53:55.905926
Analysis finished2023-12-11 22:53:56.459607
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
유흥주점영업
526 

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 (%)
유흥주점영업 526
100.0%

Length

2023-12-12T07:53:56.515051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:56.596607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 526
100.0%

업소명
Text

Distinct524
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2023-12-12T07:53:56.813511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length3.5684411
Min length1

Characters and Unicode

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

Unique

Unique522 ?
Unique (%)99.2%

Sample

1st row신세계
2nd row더탐클럽
3rd row티오피(TOP)
4th row원 여보여보
5th row하나비
ValueCountFrequency (%)
준코뮤직타운 6
 
1.1%
시청 4
 
0.7%
엔츠노래타운 3
 
0.5%
미소 2
 
0.4%
노래타운 2
 
0.4%
산수화 2
 
0.4%
앤츠 2
 
0.4%
2호점 2
 
0.4%
노래텔 2
 
0.4%
연동 2
 
0.4%
Other values (527) 529
95.1%
2023-12-12T07:53:57.184563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 70
 
3.7%
이 47
 
2.5%
래 39
 
2.1%
노 39
 
2.1%
타 36
 
1.9%
라 35
 
1.9%
점 33
 
1.8%
주 32
 
1.7%
30
 
1.6%
아 29
 
1.5%
Other values (403) 1487
79.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1792
95.5%
Space Separator 30
 
1.6%
Decimal Number 20
 
1.1%
Uppercase Letter 13
 
0.7%
Close Punctuation 11
 
0.6%
Open Punctuation 11
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 70
 
3.9%
이 47
 
2.6%
래 39
 
2.2%
노 39
 
2.2%
타 36
 
2.0%
라 35
 
2.0%
점 33
 
1.8%
주 32
 
1.8%
아 29
 
1.6%
리 28
 
1.6%
Other values (382) 1404
78.3%
Uppercase Letter
ValueCountFrequency (%)
M 2
15.4%
S 2
15.4%
Q 1
7.7%
G 1
7.7%
J 1
7.7%
L 1
7.7%
A 1
7.7%
P 1
7.7%
T 1
7.7%
B 1
7.7%
Decimal Number
ValueCountFrequency (%)
2 5
25.0%
3 5
25.0%
1 3
15.0%
4 3
15.0%
0 2
 
10.0%
7 1
 
5.0%
8 1
 
5.0%
Space Separator
ValueCountFrequency (%)
30
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1792
95.5%
Common 72
 
3.8%
Latin 13
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 70
 
3.9%
이 47
 
2.6%
래 39
 
2.2%
노 39
 
2.2%
타 36
 
2.0%
라 35
 
2.0%
점 33
 
1.8%
주 32
 
1.8%
아 29
 
1.6%
리 28
 
1.6%
Other values (382) 1404
78.3%
Latin
ValueCountFrequency (%)
M 2
15.4%
S 2
15.4%
Q 1
7.7%
G 1
7.7%
J 1
7.7%
L 1
7.7%
A 1
7.7%
P 1
7.7%
T 1
7.7%
B 1
7.7%
Common
ValueCountFrequency (%)
30
41.7%
) 11
 
15.3%
( 11
 
15.3%
2 5
 
6.9%
3 5
 
6.9%
1 3
 
4.2%
4 3
 
4.2%
0 2
 
2.8%
7 1
 
1.4%
8 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1792
95.5%
ASCII 85
 
4.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 70
 
3.9%
이 47
 
2.6%
래 39
 
2.2%
노 39
 
2.2%
타 36
 
2.0%
라 35
 
2.0%
점 33
 
1.8%
주 32
 
1.8%
아 29
 
1.6%
리 28
 
1.6%
Other values (382) 1404
78.3%
ASCII
ValueCountFrequency (%)
30
35.3%
) 11
 
12.9%
( 11
 
12.9%
2 5
 
5.9%
3 5
 
5.9%
1 3
 
3.5%
4 3
 
3.5%
M 2
 
2.4%
0 2
 
2.4%
S 2
 
2.4%
Other values (11) 11
 
12.9%

소재지
Text

Distinct467
Distinct (%)88.8%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2023-12-12T07:53:57.433676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length26
Mean length20.205323
Min length17

Characters and Unicode

Total characters10628
Distinct characters95
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

Unique418 ?
Unique (%)79.5%

Sample

1st row제주특별자치도 제주시 서광로26길 5
2nd row제주특별자치도 제주시 중앙로 지하 151
3rd row제주특별자치도 제주시 삼무로 지하 30
4th row제주특별자치도 제주시 신광로 지하 56
5th row제주특별자치도 제주시 신광로 지하 61
ValueCountFrequency (%)
제주특별자치도 526
23.9%
제주시 526
23.9%
지하 47
 
2.1%
신광로 44
 
2.0%
노연로 32
 
1.5%
서광로 30
 
1.4%
한림읍 29
 
1.3%
삼무로 26
 
1.2%
동광로4길 21
 
1.0%
고마로 21
 
1.0%
Other values (309) 903
41.0%
2023-12-12T07:53:57.781905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1873
17.6%
제 1059
 
10.0%
주 1052
 
9.9%
자 531
 
5.0%
도 529
 
5.0%
특 526
 
4.9%
별 526
 
4.9%
치 526
 
4.9%
시 526
 
4.9%
로 373
 
3.5%
Other values (85) 3107
29.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7262
68.3%
Space Separator 1873
 
17.6%
Decimal Number 1433
 
13.5%
Dash Punctuation 57
 
0.5%
Other Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 1059
14.6%
주 1052
14.5%
자 531
 
7.3%
도 529
 
7.3%
특 526
 
7.2%
별 526
 
7.2%
치 526
 
7.2%
시 526
 
7.2%
로 373
 
5.1%
길 286
 
3.9%
Other values (70) 1328
18.3%
Decimal Number
ValueCountFrequency (%)
1 333
23.2%
2 228
15.9%
4 168
11.7%
3 140
9.8%
6 109
 
7.6%
5 101
 
7.0%
7 100
 
7.0%
8 97
 
6.8%
0 81
 
5.7%
9 76
 
5.3%
Space Separator
ValueCountFrequency (%)
1873
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 57
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7262
68.3%
Common 3366
31.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 1059
14.6%
주 1052
14.5%
자 531
 
7.3%
도 529
 
7.3%
특 526
 
7.2%
별 526
 
7.2%
치 526
 
7.2%
시 526
 
7.2%
로 373
 
5.1%
길 286
 
3.9%
Other values (70) 1328
18.3%
Common
ValueCountFrequency (%)
1873
55.6%
1 333
 
9.9%
2 228
 
6.8%
4 168
 
5.0%
3 140
 
4.2%
6 109
 
3.2%
5 101
 
3.0%
7 100
 
3.0%
8 97
 
2.9%
0 81
 
2.4%
Other values (5) 136
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7262
68.3%
ASCII 3366
31.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1873
55.6%
1 333
 
9.9%
2 228
 
6.8%
4 168
 
5.0%
3 140
 
4.2%
6 109
 
3.2%
5 101
 
3.0%
7 100
 
3.0%
8 97
 
2.9%
0 81
 
2.4%
Other values (5) 136
 
4.0%
Hangul
ValueCountFrequency (%)
제 1059
14.6%
주 1052
14.5%
자 531
 
7.3%
도 529
 
7.3%
특 526
 
7.2%
별 526
 
7.2%
치 526
 
7.2%
시 526
 
7.2%
로 373
 
5.1%
길 286
 
3.9%
Other values (70) 1328
18.3%

영업장면적(미터제곱)
Real number (ℝ)

Distinct472
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean181.05873
Minimum23
Maximum3594.38
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.8 KiB
2023-12-12T07:53:57.899480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum23
5-th percentile33.485
Q197.005
median135.39
Q3208.36
95-th percentile424.64
Maximum3594.38
Range3571.38
Interquartile range (IQR)111.355

Descriptive statistics

Standard deviation204.54373
Coefficient of variation (CV)1.1297093
Kurtosis149.63321
Mean181.05873
Median Absolute Deviation (MAD)54.35
Skewness9.7567341
Sum95236.89
Variance41838.138
MonotonicityNot monotonic
2023-12-12T07:53:58.027856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
23.0 5
 
1.0%
29.0 5
 
1.0%
99.0 5
 
1.0%
26.0 4
 
0.8%
115.0 4
 
0.8%
150.0 3
 
0.6%
159.73 3
 
0.6%
89.0 3
 
0.6%
82.0 3
 
0.6%
128.0 3
 
0.6%
Other values (462) 488
92.8%
ValueCountFrequency (%)
23.0 5
1.0%
24.5 1
 
0.2%
26.0 4
0.8%
27.0 1
 
0.2%
28.0 1
 
0.2%
28.84 1
 
0.2%
29.0 5
1.0%
31.0 1
 
0.2%
31.6 1
 
0.2%
32.0 1
 
0.2%
ValueCountFrequency (%)
3594.38 1
0.2%
1172.15 1
0.2%
1064.64 1
0.2%
970.29 1
0.2%
796.87 1
0.2%
795.64 1
0.2%
793.04 1
0.2%
741.83 1
0.2%
713.22 1
0.2%
698.26 1
0.2%

전화번호
Text

MISSING 

Distinct478
Distinct (%)98.4%
Missing40
Missing (%)7.6%
Memory size4.2 KiB
2023-12-12T07:53:58.275767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique471 ?
Unique (%)96.9%

Sample

1st row064-757-8044
2nd row064-720-6610
3rd row064-757-7711
4th row064-743-1888
5th row064-745-0662
ValueCountFrequency (%)
064-723-3101 3
 
0.6%
064-759-9872 2
 
0.4%
064-711-9911 2
 
0.4%
064-744-4518 2
 
0.4%
064-752-2436 2
 
0.4%
064-747-5589 2
 
0.4%
064-723-3983 2
 
0.4%
064-727-1136 1
 
0.2%
064-711-3241 1
 
0.2%
064-757-8044 1
 
0.2%
Other values (468) 468
96.3%
2023-12-12T07:53:58.633987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 972
16.7%
4 900
15.4%
0 777
13.3%
7 744
12.8%
6 700
12.0%
2 366
 
6.3%
5 362
 
6.2%
3 272
 
4.7%
1 271
 
4.6%
8 249
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4860
83.3%
Dash Punctuation 972
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 900
18.5%
0 777
16.0%
7 744
15.3%
6 700
14.4%
2 366
7.5%
5 362
7.4%
3 272
 
5.6%
1 271
 
5.6%
8 249
 
5.1%
9 219
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 972
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 5832
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 972
16.7%
4 900
15.4%
0 777
13.3%
7 744
12.8%
6 700
12.0%
2 366
 
6.3%
5 362
 
6.2%
3 272
 
4.7%
1 271
 
4.6%
8 249
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5832
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 972
16.7%
4 900
15.4%
0 777
13.3%
7 744
12.8%
6 700
12.0%
2 366
 
6.3%
5 362
 
6.2%
3 272
 
4.7%
1 271
 
4.6%
8 249
 
4.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
Minimum2021-02-15 00:00:00
Maximum2021-02-15 00:00:00
2023-12-12T07:53:58.740710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:53:58.819397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T07:53:56.198151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T07:53:56.307527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:53:56.420842image/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유흥주점영업신세계제주특별자치도 제주시 서광로26길 5110.87064-757-80442021-02-15
1유흥주점영업더탐클럽제주특별자치도 제주시 중앙로 지하 151297.54064-720-66102021-02-15
2유흥주점영업티오피(TOP)제주특별자치도 제주시 삼무로 지하 30425.31064-757-77112021-02-15
3유흥주점영업원 여보여보제주특별자치도 제주시 신광로 지하 56167.0064-743-18882021-02-15
4유흥주점영업하나비제주특별자치도 제주시 신광로 지하 61116.0064-745-06622021-02-15
5유흥주점영업눈사람제주특별자치도 제주시 신광로 지하 82265.36064-749-23332021-02-15
6유흥주점영업두꺼비제주특별자치도 제주시 신광로 지하 65148.0064-711-77552021-02-15
7유흥주점영업여명제주특별자치도 제주시 한림읍 한림해안로 16637.0064-796-81222021-02-15
8유흥주점영업별천지제주특별자치도 제주시 추자면 대서6길 6115.07064-742-35812021-02-15
9유흥주점영업크크제주특별자치도 제주시 신대로16길 4793.04064-745-02532021-02-15
업종명업소명소재지영업장면적(미터제곱)전화번호데이터기준일자
516유흥주점영업소다제주특별자치도 제주시 원노형6길 22274.61064-712-39992021-02-15
517유흥주점영업뮤직박스제원점제주특별자치도 제주시 신대로14길 47275.13064-743-05002021-02-15
518유흥주점영업엔츠노래타운 연동3호점제주특별자치도 제주시 연동7길 22245.92064-747-99892021-02-15
519유흥주점영업수족관제주특별자치도 제주시 고마로 107141.6064-725-79762021-02-15
520유흥주점영업세화7080라이브제주특별자치도 제주시 구좌읍 세화1길 13215.28064-784-69792021-02-15
521유흥주점영업해와달제주특별자치도 제주시 동광로4길 9-1146.87064-702-79002021-02-15
522유흥주점영업엠박스노래주점제주특별자치도 제주시 은남1길 33446.19064-747-26002021-02-15
523유흥주점영업뉴박하제주특별자치도 제주시 연동10길 16527.66064-745-00712021-02-15
524유흥주점영업보이스퀸 노래주점제주특별자치도 제주시 고마로 49214.06<NA>2021-02-15
525유흥주점영업썬크루즈라이브제주특별자치도 제주시 신대로16길 44229.67064-748-74442021-02-15