Overview

Dataset statistics

Number of variables16
Number of observations10000
Missing cells50900
Missing cells (%)31.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 MiB
Average record size in memory144.0 B

Variable types

Text3
Categorical5
Numeric4
Unsupported4

Dataset

Description- 제주특별자치도에 위치한 일반, 휴게 음식점의 사업장명, 인허가일자, 영업상태, 소재지주소 등의 정보를 제공합니다. - 원본 파일의 좌표가 중부원점 TM(EPSH:2097) 좌표계를 따르고 있는데 위경도(WGS84) 좌표계로 변환 시 정확하게 변환이 되지 않아 파일에서 좌표 정보는 제외하였습니다. 데이터 제공 사이트로 가시면 원본 좌표를 확인하실 수 있습니다. - 인포그래픽을 제공함에 따라 인허가일에 따른 영업 및 폐업 음식점 수 파일도 함께 제공합니다. - 데이터 제공처: LOCALDATA
Author제주데이터허브
URLhttps://www.jejudatahub.net/data/view/data/780

Alerts

데이터갱신일자 has constant value ""Constant
업종구분소분류 is highly overall correlated with 업종구분대분류High correlation
상세영업상태명 is highly overall correlated with 폐업일자 and 1 other fieldsHigh correlation
영업상태명 is highly overall correlated with 폐업일자 and 1 other fieldsHigh correlation
업종구분대분류 is highly overall correlated with 업종구분소분류High correlation
인허가일자 is highly overall correlated with 폐업일자High correlation
폐업일자 is highly overall correlated with 인허가일자 and 2 other fieldsHigh correlation
인허가취소일자 has 10000 (100.0%) missing valuesMissing
폐업일자 has 4307 (43.1%) missing valuesMissing
휴업시작일자 has 10000 (100.0%) missing valuesMissing
휴업종료일자 has 10000 (100.0%) missing valuesMissing
재개업일자 has 10000 (100.0%) missing valuesMissing
소재지면적 has 142 (1.4%) missing valuesMissing
도로명전체주소 has 3171 (31.7%) missing valuesMissing
도로명우편번호 has 3239 (32.4%) missing valuesMissing
도로명우편번호 is highly skewed (γ1 = -53.96233555)Skewed
인허가취소일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업시작일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업종료일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
재개업일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 20:00:56.832590
Analysis finished2023-12-11 20:01:01.505714
Duration4.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사업장명
Text

Distinct9633
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T05:01:01.788757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length25
Mean length5.3935
Min length1

Characters and Unicode

Total characters53935
Distinct characters1118
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

Unique9317 ?
Unique (%)93.2%

Sample

1st row미궁
2nd row희동이네본점
3rd row알레그로
4th row삼양
5th row해바라기
ValueCountFrequency (%)
친구 6
 
0.1%
제주바당 5
 
< 0.1%
생수천계절음식점 5
 
< 0.1%
왕돌 5
 
< 0.1%
속골계절음식점 5
 
< 0.1%
바다이야기 4
 
< 0.1%
악근천계절음식점 4
 
< 0.1%
우일 4
 
< 0.1%
은하수 4
 
< 0.1%
씨유 4
 
< 0.1%
Other values (9736) 10091
99.5%
2023-12-12T05:01:02.345309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 1785
 
3.3%
주 1190
 
2.2%
이 1161
 
2.2%
제 1070
 
2.0%
스 892
 
1.7%
리 872
 
1.6%
식 817
 
1.5%
당 590
 
1.1%
도 568
 
1.1%
라 551
 
1.0%
Other values (1108) 44439
82.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 51971
96.4%
Decimal Number 679
 
1.3%
Uppercase Letter 401
 
0.7%
Lowercase Letter 336
 
0.6%
Close Punctuation 193
 
0.4%
Open Punctuation 191
 
0.4%
Space Separator 137
 
0.3%
Other Punctuation 21
 
< 0.1%
Dash Punctuation 6
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 1785
 
3.4%
주 1190
 
2.3%
이 1161
 
2.2%
제 1070
 
2.1%
스 892
 
1.7%
리 872
 
1.7%
식 817
 
1.6%
당 590
 
1.1%
도 568
 
1.1%
라 551
 
1.1%
Other values (1039) 42475
81.7%
Uppercase Letter
ValueCountFrequency (%)
C 38
 
9.5%
E 30
 
7.5%
G 30
 
7.5%
S 29
 
7.2%
O 28
 
7.0%
P 28
 
7.0%
B 25
 
6.2%
A 23
 
5.7%
T 20
 
5.0%
N 17
 
4.2%
Other values (16) 133
33.2%
Lowercase Letter
ValueCountFrequency (%)
a 45
13.4%
e 39
11.6%
r 32
 
9.5%
o 25
 
7.4%
n 21
 
6.2%
i 21
 
6.2%
l 17
 
5.1%
u 16
 
4.8%
t 14
 
4.2%
h 11
 
3.3%
Other values (14) 95
28.3%
Decimal Number
ValueCountFrequency (%)
2 169
24.9%
1 117
17.2%
5 109
16.1%
3 59
 
8.7%
0 56
 
8.2%
4 44
 
6.5%
9 34
 
5.0%
8 34
 
5.0%
7 29
 
4.3%
6 28
 
4.1%
Other Punctuation
ValueCountFrequency (%)
& 10
47.6%
. 6
28.6%
' 2
 
9.5%
, 2
 
9.5%
? 1
 
4.8%
Close Punctuation
ValueCountFrequency (%)
) 193
100.0%
Open Punctuation
ValueCountFrequency (%)
( 191
100.0%
Space Separator
ValueCountFrequency (%)
137
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 51960
96.3%
Common 1227
 
2.3%
Latin 737
 
1.4%
Han 11
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 1785
 
3.4%
주 1190
 
2.3%
이 1161
 
2.2%
제 1070
 
2.1%
스 892
 
1.7%
리 872
 
1.7%
식 817
 
1.6%
당 590
 
1.1%
도 568
 
1.1%
라 551
 
1.1%
Other values (1029) 42464
81.7%
Latin
ValueCountFrequency (%)
a 45
 
6.1%
e 39
 
5.3%
C 38
 
5.2%
r 32
 
4.3%
E 30
 
4.1%
G 30
 
4.1%
S 29
 
3.9%
O 28
 
3.8%
P 28
 
3.8%
o 25
 
3.4%
Other values (40) 413
56.0%
Common
ValueCountFrequency (%)
) 193
15.7%
( 191
15.6%
2 169
13.8%
137
11.2%
1 117
9.5%
5 109
8.9%
3 59
 
4.8%
0 56
 
4.6%
4 44
 
3.6%
9 34
 
2.8%
Other values (9) 118
9.6%
Han
ValueCountFrequency (%)
酒 2
18.2%
客 1
9.1%
四 1
9.1%
丹 1
9.1%
直 1
9.1%
素 1
9.1%
度 1
9.1%
斗 1
9.1%
友 1
9.1%
知 1
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 51960
96.3%
ASCII 1964
 
3.6%
CJK 11
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 1785
 
3.4%
주 1190
 
2.3%
이 1161
 
2.2%
제 1070
 
2.1%
스 892
 
1.7%
리 872
 
1.7%
식 817
 
1.6%
당 590
 
1.1%
도 568
 
1.1%
라 551
 
1.1%
Other values (1029) 42464
81.7%
ASCII
ValueCountFrequency (%)
) 193
 
9.8%
( 191
 
9.7%
2 169
 
8.6%
137
 
7.0%
1 117
 
6.0%
5 109
 
5.5%
3 59
 
3.0%
0 56
 
2.9%
a 45
 
2.3%
4 44
 
2.2%
Other values (59) 844
43.0%
CJK
ValueCountFrequency (%)
酒 2
18.2%
客 1
9.1%
四 1
9.1%
丹 1
9.1%
直 1
9.1%
素 1
9.1%
度 1
9.1%
斗 1
9.1%
友 1
9.1%
知 1
9.1%

업종구분대분류
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반음식점
7525 
휴게음식점
2475 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반음식점
2nd row일반음식점
3rd row일반음식점
4th row일반음식점
5th row휴게음식점

Common Values

ValueCountFrequency (%)
일반음식점 7525
75.2%
휴게음식점 2475
 
24.8%

Length

2023-12-12T05:01:02.516234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:01:02.621054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 7525
75.2%
휴게음식점 2475
 
24.8%

업종구분소분류
Categorical

HIGH CORRELATION 

Distinct38
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
한식
3908 
기타
1066 
커피숍
766 
호프/통닭
594 
기타 휴게음식점
511 
Other values (33)
3155 

Length

Max length15
Median length2
Mean length3.2767
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row한식
2nd row분식
3rd row경양식
4th row한식
5th row과자점

Common Values

ValueCountFrequency (%)
한식 3908
39.1%
기타 1066
 
10.7%
커피숍 766
 
7.7%
호프/통닭 594
 
5.9%
기타 휴게음식점 511
 
5.1%
일반조리판매 446
 
4.5%
경양식 331
 
3.3%
식육(숯불구이) 289
 
2.9%
편의점 242
 
2.4%
까페 230
 
2.3%
Other values (28) 1617
16.2%

Length

2023-12-12T05:01:02.755955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
한식 3908
37.2%
기타 1577
15.0%
커피숍 766
 
7.3%
호프/통닭 594
 
5.7%
휴게음식점 511
 
4.9%
일반조리판매 446
 
4.2%
경양식 331
 
3.1%
식육(숯불구이 289
 
2.7%
편의점 242
 
2.3%
까페 230
 
2.2%
Other values (28) 1617
15.4%

인허가일자
Real number (ℝ)

HIGH CORRELATION 

Distinct5667
Distinct (%)56.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20088767
Minimum19600229
Maximum20230927
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T05:01:02.928031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19600229
5-th percentile19910305
Q120010213
median20110724
Q320180716
95-th percentile20220718
Maximum20230927
Range630698
Interquartile range (IQR)170503

Descriptive statistics

Standard deviation106992.82
Coefficient of variation (CV)0.0053260023
Kurtosis-0.25002979
Mean20088767
Median Absolute Deviation (MAD)80114.5
Skewness-0.65939309
Sum2.0088767 × 1011
Variance1.1447464 × 1010
MonotonicityNot monotonic
2023-12-12T05:01:03.109480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19760228 19
 
0.2%
20180405 8
 
0.1%
19970312 8
 
0.1%
20170403 8
 
0.1%
20181022 8
 
0.1%
20190613 8
 
0.1%
20200428 8
 
0.1%
20160630 8
 
0.1%
20180228 8
 
0.1%
20201029 7
 
0.1%
Other values (5657) 9910
99.1%
ValueCountFrequency (%)
19600229 1
< 0.1%
19640307 1
< 0.1%
19640320 1
< 0.1%
19650914 1
< 0.1%
19680318 1
< 0.1%
19681223 1
< 0.1%
19690711 1
< 0.1%
19700325 1
< 0.1%
19700826 1
< 0.1%
19710326 1
< 0.1%
ValueCountFrequency (%)
20230927 1
 
< 0.1%
20230926 2
 
< 0.1%
20230925 5
0.1%
20230922 2
 
< 0.1%
20230920 1
 
< 0.1%
20230918 2
 
< 0.1%
20230915 4
< 0.1%
20230914 1
 
< 0.1%
20230913 3
< 0.1%
20230911 1
 
< 0.1%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

영업상태명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
폐업
5693 
영업/정상
4307 

Length

Max length5
Median length2
Mean length3.2921
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐업
2nd row영업/정상
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 5693
56.9%
영업/정상 4307
43.1%

Length

2023-12-12T05:01:03.242948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:01:03.324187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 5693
56.9%
영업/정상 4307
43.1%

상세영업상태명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
폐업
5693 
영업
4307 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐업
2nd row영업
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 5693
56.9%
영업 4307
43.1%

Length

2023-12-12T05:01:03.421995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:01:03.507937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 5693
56.9%
영업 4307
43.1%

폐업일자
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct3551
Distinct (%)62.4%
Missing4307
Missing (%)43.1%
Infinite0
Infinite (%)0.0%
Mean20110576
Minimum19930215
Maximum20230927
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T05:01:03.611958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19930215
5-th percentile19980402
Q120040906
median20120126
Q320181226
95-th percentile20221014
Maximum20230927
Range300712
Interquartile range (IQR)140320

Descriptive statistics

Standard deviation80746.733
Coefficient of variation (CV)0.0040151377
Kurtosis-1.1837692
Mean20110576
Median Absolute Deviation (MAD)70184
Skewness-0.19915023
Sum1.1448951 × 1011
Variance6.5200348 × 109
MonotonicityNot monotonic
2023-12-12T05:01:03.765751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20150427 61
 
0.6%
20120307 56
 
0.6%
20130405 34
 
0.3%
20160517 23
 
0.2%
20020311 22
 
0.2%
20050831 17
 
0.2%
20030831 16
 
0.2%
20030314 12
 
0.1%
20080930 12
 
0.1%
20040831 12
 
0.1%
Other values (3541) 5428
54.3%
(Missing) 4307
43.1%
ValueCountFrequency (%)
19930215 1
< 0.1%
19931012 1
< 0.1%
19940128 1
< 0.1%
19940224 1
< 0.1%
19940420 1
< 0.1%
19940510 1
< 0.1%
19940514 1
< 0.1%
19940517 1
< 0.1%
19940620 1
< 0.1%
19940719 1
< 0.1%
ValueCountFrequency (%)
20230927 1
 
< 0.1%
20230926 2
< 0.1%
20230922 1
 
< 0.1%
20230920 1
 
< 0.1%
20230919 1
 
< 0.1%
20230915 1
 
< 0.1%
20230914 1
 
< 0.1%
20230912 3
< 0.1%
20230908 1
 
< 0.1%
20230906 1
 
< 0.1%

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

소재지면적
Real number (ℝ)

MISSING 

Distinct5625
Distinct (%)57.1%
Missing142
Missing (%)1.4%
Infinite0
Infinite (%)0.0%
Mean86.879779
Minimum0
Maximum2475.1
Zeros2
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T05:01:03.904337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile11.2935
Q135.2
median63.995
Q3102.115
95-th percentile225.926
Maximum2475.1
Range2475.1
Interquartile range (IQR)66.915

Descriptive statistics

Standard deviation102.69545
Coefficient of variation (CV)1.1820409
Kurtosis114.93502
Mean86.879779
Median Absolute Deviation (MAD)32.205
Skewness7.6644892
Sum856460.86
Variance10546.356
MonotonicityNot monotonic
2023-12-12T05:01:04.079728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6.6 183
 
1.8%
66.0 85
 
0.9%
3.3 70
 
0.7%
33.0 60
 
0.6%
30.0 50
 
0.5%
60.0 42
 
0.4%
99.0 40
 
0.4%
49.5 36
 
0.4%
80.0 33
 
0.3%
9.9 31
 
0.3%
Other values (5615) 9228
92.3%
(Missing) 142
 
1.4%
ValueCountFrequency (%)
0.0 2
 
< 0.1%
1.0 1
 
< 0.1%
1.5 1
 
< 0.1%
1.66 1
 
< 0.1%
2.0 1
 
< 0.1%
2.4 1
 
< 0.1%
2.7 1
 
< 0.1%
3.0 2
 
< 0.1%
3.3 70
0.7%
3.44 1
 
< 0.1%
ValueCountFrequency (%)
2475.1 1
< 0.1%
2316.56 1
< 0.1%
2074.02 1
< 0.1%
2026.0 1
< 0.1%
1958.5 1
< 0.1%
1597.32 1
< 0.1%
1507.0 1
< 0.1%
1447.6 1
< 0.1%
1236.36 1
< 0.1%
1176.07 1
< 0.1%

소재지전체주소
Text

Distinct8895
Distinct (%)89.3%
Missing41
Missing (%)0.4%
Memory size156.2 KiB
2023-12-12T05:01:04.462322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length50
Mean length26.271614
Min length18

Characters and Unicode

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

Unique

Unique8076 ?
Unique (%)81.1%

Sample

1st row제주특별자치도 제주시 연동 294-45번지
2nd row제주특별자치도 서귀포시 표선면 표선리 864-2번지
3rd row제주특별자치도 서귀포시 상예동 2850
4th row제주특별자치도 제주시 삼양일동 1599-17번지 (서흘로73)
5th row제주특별자치도 제주시 노형동 1048-1번지
ValueCountFrequency (%)
제주특별자치도 9958
21.7%
제주시 7236
 
15.7%
서귀포시 2722
 
5.9%
연동 991
 
2.2%
이도이동 704
 
1.5%
노형동 601
 
1.3%
서귀동 554
 
1.2%
애월읍 496
 
1.1%
1층 452
 
1.0%
한림읍 375
 
0.8%
Other values (9591) 21906
47.6%
2023-12-12T05:01:04.957230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
36039
 
13.8%
제 17364
 
6.6%
주 17324
 
6.6%
도 12698
 
4.9%
1 11615
 
4.4%
시 10036
 
3.8%
자 9993
 
3.8%
별 9970
 
3.8%
치 9969
 
3.8%
특 9959
 
3.8%
Other values (425) 116672
44.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 164886
63.0%
Decimal Number 49430
 
18.9%
Space Separator 36039
 
13.8%
Dash Punctuation 8131
 
3.1%
Open Punctuation 1424
 
0.5%
Close Punctuation 1423
 
0.5%
Other Punctuation 191
 
0.1%
Uppercase Letter 84
 
< 0.1%
Lowercase Letter 22
 
< 0.1%
Math Symbol 8
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 17364
 
10.5%
주 17324
 
10.5%
도 12698
 
7.7%
시 10036
 
6.1%
자 9993
 
6.1%
별 9970
 
6.0%
치 9969
 
6.0%
특 9959
 
6.0%
동 7310
 
4.4%
지 6578
 
4.0%
Other values (384) 53685
32.6%
Uppercase Letter
ValueCountFrequency (%)
B 26
31.0%
L 16
19.0%
A 14
16.7%
C 12
14.3%
J 6
 
7.1%
P 2
 
2.4%
K 2
 
2.4%
F 2
 
2.4%
G 1
 
1.2%
N 1
 
1.2%
Other values (2) 2
 
2.4%
Decimal Number
ValueCountFrequency (%)
1 11615
23.5%
2 7325
14.8%
3 5064
10.2%
4 4082
 
8.3%
5 3910
 
7.9%
7 3684
 
7.5%
0 3646
 
7.4%
6 3560
 
7.2%
9 3356
 
6.8%
8 3188
 
6.4%
Lowercase Letter
ValueCountFrequency (%)
u 4
18.2%
a 4
18.2%
e 4
18.2%
q 2
9.1%
j 2
9.1%
t 2
9.1%
n 2
9.1%
l 2
9.1%
Other Punctuation
ValueCountFrequency (%)
, 157
82.2%
/ 23
 
12.0%
. 9
 
4.7%
& 1
 
0.5%
: 1
 
0.5%
Space Separator
ValueCountFrequency (%)
36039
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8131
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1424
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1423
100.0%
Math Symbol
ValueCountFrequency (%)
~ 8
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 164886
63.0%
Common 96646
36.9%
Latin 107
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 17364
 
10.5%
주 17324
 
10.5%
도 12698
 
7.7%
시 10036
 
6.1%
자 9993
 
6.1%
별 9970
 
6.0%
치 9969
 
6.0%
특 9959
 
6.0%
동 7310
 
4.4%
지 6578
 
4.0%
Other values (384) 53685
32.6%
Latin
ValueCountFrequency (%)
B 26
24.3%
L 16
15.0%
A 14
13.1%
C 12
11.2%
J 6
 
5.6%
u 4
 
3.7%
a 4
 
3.7%
e 4
 
3.7%
q 2
 
1.9%
j 2
 
1.9%
Other values (11) 17
15.9%
Common
ValueCountFrequency (%)
36039
37.3%
1 11615
 
12.0%
- 8131
 
8.4%
2 7325
 
7.6%
3 5064
 
5.2%
4 4082
 
4.2%
5 3910
 
4.0%
7 3684
 
3.8%
0 3646
 
3.8%
6 3560
 
3.7%
Other values (10) 9590
 
9.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 164886
63.0%
ASCII 96752
37.0%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
36039
37.2%
1 11615
 
12.0%
- 8131
 
8.4%
2 7325
 
7.6%
3 5064
 
5.2%
4 4082
 
4.2%
5 3910
 
4.0%
7 3684
 
3.8%
0 3646
 
3.8%
6 3560
 
3.7%
Other values (30) 9696
 
10.0%
Hangul
ValueCountFrequency (%)
제 17364
 
10.5%
주 17324
 
10.5%
도 12698
 
7.7%
시 10036
 
6.1%
자 9993
 
6.1%
별 9970
 
6.0%
치 9969
 
6.0%
특 9959
 
6.0%
동 7310
 
4.4%
지 6578
 
4.0%
Other values (384) 53685
32.6%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

도로명전체주소
Text

MISSING 

Distinct6440
Distinct (%)94.3%
Missing3171
Missing (%)31.7%
Memory size156.2 KiB
2023-12-12T05:01:05.523278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length55
Mean length29.655879
Min length21

Characters and Unicode

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

Unique

Unique6098 ?
Unique (%)89.3%

Sample

1st row제주특별자치도 서귀포시 표선면 표선중앙로 101
2nd row제주특별자치도 서귀포시 소보리당로 220 (상예동)
3rd row제주특별자치도 서귀포시 성산읍 중산간동로 4330, 1층
4th row제주특별자치도 서귀포시 소보리당로164번길 62, 2층 (상예동)
5th row제주특별자치도 서귀포시 이어도로 781, 1층 (강정동)
ValueCountFrequency (%)
제주특별자치도 6828
 
17.3%
제주시 4743
 
12.0%
1층 2913
 
7.4%
서귀포시 2085
 
5.3%
연동 495
 
1.3%
이도이동 427
 
1.1%
노형동 410
 
1.0%
2층 408
 
1.0%
애월읍 391
 
1.0%
서귀동 339
 
0.9%
Other values (4028) 20325
51.6%
2023-12-12T05:01:06.039205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
32535
 
16.1%
주 11948
 
5.9%
제 11870
 
5.9%
도 8673
 
4.3%
1 8614
 
4.3%
시 6894
 
3.4%
자 6894
 
3.4%
치 6843
 
3.4%
별 6838
 
3.4%
특 6829
 
3.4%
Other values (453) 94582
46.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 127613
63.0%
Space Separator 32535
 
16.1%
Decimal Number 27155
 
13.4%
Close Punctuation 4620
 
2.3%
Open Punctuation 4620
 
2.3%
Other Punctuation 4518
 
2.2%
Dash Punctuation 1230
 
0.6%
Uppercase Letter 117
 
0.1%
Math Symbol 84
 
< 0.1%
Lowercase Letter 27
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 11948
 
9.4%
제 11870
 
9.3%
도 8673
 
6.8%
시 6894
 
5.4%
자 6894
 
5.4%
치 6843
 
5.4%
별 6838
 
5.4%
특 6829
 
5.4%
동 5692
 
4.5%
로 5670
 
4.4%
Other values (408) 49462
38.8%
Uppercase Letter
ValueCountFrequency (%)
A 37
31.6%
B 34
29.1%
C 17
14.5%
E 6
 
5.1%
J 6
 
5.1%
D 4
 
3.4%
F 4
 
3.4%
N 2
 
1.7%
P 2
 
1.7%
K 2
 
1.7%
Other values (3) 3
 
2.6%
Decimal Number
ValueCountFrequency (%)
1 8614
31.7%
2 3991
14.7%
3 2507
 
9.2%
4 2289
 
8.4%
5 1921
 
7.1%
6 1790
 
6.6%
0 1767
 
6.5%
7 1565
 
5.8%
8 1440
 
5.3%
9 1271
 
4.7%
Lowercase Letter
ValueCountFrequency (%)
e 6
22.2%
u 4
14.8%
a 4
14.8%
n 3
11.1%
j 2
 
7.4%
t 2
 
7.4%
l 2
 
7.4%
q 2
 
7.4%
z 1
 
3.7%
o 1
 
3.7%
Other Punctuation
ValueCountFrequency (%)
, 4511
99.8%
. 5
 
0.1%
& 1
 
< 0.1%
* 1
 
< 0.1%
Close Punctuation
ValueCountFrequency (%)
) 4619
> 99.9%
] 1
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 4619
> 99.9%
[ 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
32535
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1230
100.0%
Math Symbol
ValueCountFrequency (%)
~ 84
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 127613
63.0%
Common 74762
36.9%
Latin 145
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 11948
 
9.4%
제 11870
 
9.3%
도 8673
 
6.8%
시 6894
 
5.4%
자 6894
 
5.4%
치 6843
 
5.4%
별 6838
 
5.4%
특 6829
 
5.4%
동 5692
 
4.5%
로 5670
 
4.4%
Other values (408) 49462
38.8%
Latin
ValueCountFrequency (%)
A 37
25.5%
B 34
23.4%
C 17
11.7%
E 6
 
4.1%
e 6
 
4.1%
J 6
 
4.1%
u 4
 
2.8%
a 4
 
2.8%
D 4
 
2.8%
F 4
 
2.8%
Other values (14) 23
15.9%
Common
ValueCountFrequency (%)
32535
43.5%
1 8614
 
11.5%
) 4619
 
6.2%
( 4619
 
6.2%
, 4511
 
6.0%
2 3991
 
5.3%
3 2507
 
3.4%
4 2289
 
3.1%
5 1921
 
2.6%
6 1790
 
2.4%
Other values (11) 7366
 
9.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 127613
63.0%
ASCII 74906
37.0%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
32535
43.4%
1 8614
 
11.5%
) 4619
 
6.2%
( 4619
 
6.2%
, 4511
 
6.0%
2 3991
 
5.3%
3 2507
 
3.3%
4 2289
 
3.1%
5 1921
 
2.6%
6 1790
 
2.4%
Other values (34) 7510
 
10.0%
Hangul
ValueCountFrequency (%)
주 11948
 
9.4%
제 11870
 
9.3%
도 8673
 
6.8%
시 6894
 
5.4%
자 6894
 
5.4%
치 6843
 
5.4%
별 6838
 
5.4%
특 6829
 
5.4%
동 5692
 
4.5%
로 5670
 
4.4%
Other values (408) 49462
38.8%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

도로명우편번호
Real number (ℝ)

MISSING  SKEWED 

Distinct485
Distinct (%)7.2%
Missing3239
Missing (%)32.4%
Infinite0
Infinite (%)0.0%
Mean63297.098
Minimum33443
Maximum63644
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T05:01:06.178997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum33443
5-th percentile63029
Q163124
median63248
Q363530
95-th percentile63629
Maximum63644
Range30201
Interquartile range (IQR)406

Descriptive statistics

Standard deviation417.73725
Coefficient of variation (CV)0.0065996272
Kurtosis3859.3637
Mean63297.098
Median Absolute Deviation (MAD)149
Skewness-53.962336
Sum4.2795168 × 108
Variance174504.41
MonotonicityNot monotonic
2023-12-12T05:01:06.309391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
63207 104
 
1.0%
63333 103
 
1.0%
63595 97
 
1.0%
63591 92
 
0.9%
63629 91
 
0.9%
63123 82
 
0.8%
63358 76
 
0.8%
63643 72
 
0.7%
63592 68
 
0.7%
63277 68
 
0.7%
Other values (475) 5908
59.1%
(Missing) 3239
32.4%
ValueCountFrequency (%)
33443 1
 
< 0.1%
63000 16
0.2%
63001 3
 
< 0.1%
63002 18
0.2%
63003 9
 
0.1%
63004 8
 
0.1%
63005 32
0.3%
63006 12
 
0.1%
63007 3
 
< 0.1%
63008 25
0.2%
ValueCountFrequency (%)
63644 21
 
0.2%
63643 72
0.7%
63642 6
 
0.1%
63641 39
0.4%
63640 55
0.5%
63639 22
 
0.2%
63638 5
 
0.1%
63637 4
 
< 0.1%
63636 2
 
< 0.1%
63635 6
 
0.1%

데이터갱신일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-11-07
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-07
2nd row2023-11-07
3rd row2023-11-07
4th row2023-11-07
5th row2023-11-07

Common Values

ValueCountFrequency (%)
2023-11-07 10000
100.0%

Length

2023-12-12T05:01:06.457698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:01:06.554584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-07 10000
100.0%

Interactions

2023-12-12T05:01:00.396374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.071716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.499198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.919373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:01:00.494188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.199076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.601349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:01:00.061163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:01:00.602216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.308106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.721872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:01:00.176412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:01:00.770175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.402421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:00:59.813647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:01:00.288475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T05:01:06.626686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종구분대분류업종구분소분류인허가일자영업상태명상세영업상태명폐업일자소재지면적도로명우편번호
업종구분대분류1.0001.0000.2740.0050.0050.2470.067NaN
업종구분소분류1.0001.0000.5350.3200.3200.5410.201NaN
인허가일자0.2740.5351.0000.5930.5930.7920.000NaN
영업상태명0.0050.3200.5931.0001.000NaN0.058NaN
상세영업상태명0.0050.3200.5931.0001.000NaN0.058NaN
폐업일자0.2470.5410.792NaNNaN1.0000.074NaN
소재지면적0.0670.2010.0000.0580.0580.0741.000NaN
도로명우편번호NaNNaNNaNNaNNaNNaNNaN1.000
2023-12-12T05:01:06.737090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종구분소분류상세영업상태명영업상태명업종구분대분류
업종구분소분류1.0000.2540.2540.991
상세영업상태명0.2541.0001.0000.003
영업상태명0.2541.0001.0000.003
업종구분대분류0.9910.0030.0031.000
2023-12-12T05:01:06.848162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
인허가일자폐업일자소재지면적도로명우편번호업종구분대분류업종구분소분류영업상태명상세영업상태명
인허가일자1.0000.7760.092-0.0070.2100.2150.4590.459
폐업일자0.7761.0000.1450.0800.1900.2221.0001.000
소재지면적0.0920.1451.0000.0170.0510.0710.0450.045
도로명우편번호-0.0070.0800.0171.0000.0000.0000.0000.000
업종구분대분류0.2100.1900.0510.0001.0000.9910.0030.003
업종구분소분류0.2150.2220.0710.0000.9911.0000.2540.254
영업상태명0.4591.0000.0450.0000.0030.2541.0001.000
상세영업상태명0.4591.0000.0450.0000.0030.2541.0001.000

Missing values

2023-12-12T05:01:00.941002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T05:01:01.221718image/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.
2023-12-12T05:01:01.409335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

사업장명업종구분대분류업종구분소분류인허가일자인허가취소일자영업상태명상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지면적소재지전체주소도로명전체주소도로명우편번호데이터갱신일자
19330미궁일반음식점한식19950927<NA>폐업폐업19970908<NA><NA><NA>22.34제주특별자치도 제주시 연동 294-45번지<NA><NA>2023-11-07
26625희동이네본점일반음식점분식19971230<NA>영업/정상영업<NA><NA><NA><NA>54.14제주특별자치도 서귀포시 표선면 표선리 864-2번지제주특별자치도 서귀포시 표선면 표선중앙로 101636292023-11-07
31568알레그로일반음식점경양식20090918<NA>폐업폐업20200706<NA><NA><NA>124.8제주특별자치도 서귀포시 상예동 2850제주특별자치도 서귀포시 소보리당로 220 (상예동)635372023-11-07
23750삼양일반음식점한식20030114<NA>폐업폐업20040220<NA><NA><NA>158.85제주특별자치도 제주시 삼양일동 1599-17번지 (서흘로73)<NA><NA>2023-11-07
42715해바라기휴게음식점과자점19830513<NA>폐업폐업20020622<NA><NA><NA>93.0제주특별자치도 제주시 노형동 1048-1번지<NA><NA>2023-11-07
12113아름드리일반음식점한식19971008<NA>폐업폐업20020507<NA><NA><NA>47.47제주특별자치도 제주시 구좌읍 덕천리 457번지<NA><NA>2023-11-07
33468코지식당일반음식점한식19980520<NA>폐업폐업20041029<NA><NA><NA>41.8제주특별자치도 서귀포시 안덕면 사계리 2840번지<NA><NA>2023-11-07
46367선비치뷔페휴게음식점일반조리판매20100604<NA>폐업폐업20130130<NA><NA><NA>141.24제주특별자치도 서귀포시 대정읍 하모리 645-17번지 (2층)<NA><NA>2023-11-07
29406와갱이일반음식점한식20230428<NA>영업/정상영업<NA><NA><NA><NA>199.8제주특별자치도 서귀포시 성산읍 삼달리 1788-7제주특별자치도 서귀포시 성산읍 중산간동로 4330, 1층636352023-11-07
28753탐라만찬일반음식점뷔페식20170821<NA>영업/정상영업<NA><NA><NA><NA>1236.36제주특별자치도 서귀포시 상예동 2802번지 2층제주특별자치도 서귀포시 소보리당로164번길 62, 2층 (상예동)635372023-11-07
사업장명업종구분대분류업종구분소분류인허가일자인허가취소일자영업상태명상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지면적소재지전체주소도로명전체주소도로명우편번호데이터갱신일자
16396진해원일반음식점한식20110221<NA>폐업폐업20111202<NA><NA><NA>66.0제주특별자치도 제주시 삼도이동 925-1번지 제2호(1층)<NA><NA>2023-11-07
8239별돈별협재해변점일반음식점기타20200623<NA>영업/정상영업<NA><NA><NA><NA>98.09제주특별자치도 제주시 한림읍 협재리 1725-1번지제주특별자치도 제주시 한림읍 협재1길 4, 2층630112023-11-07
31351황금돼지등갈비일반음식점한식19971205<NA>폐업폐업20190607<NA><NA><NA>101.3제주특별자치도 서귀포시 서귀동 420-10번지제주특별자치도 서귀포시 명동로 13-1 (서귀동)635952023-11-07
10100청량일반음식점기타20220718<NA>영업/정상영업<NA><NA><NA><NA>26.5제주특별자치도 제주시 구좌읍 세화리 1521-5제주특별자치도 제주시 구좌읍 구좌로 31, 1층633612023-11-07
27372물동산식당일반음식점한식20021107<NA>영업/정상영업<NA><NA><NA><NA>82.8제주특별자치도 서귀포시 남원읍 신례리 734-4번지제주특별자치도 서귀포시 남원읍 신례천로 2636082023-11-07
1474대흘부엌일반음식점기타20190621<NA>영업/정상영업<NA><NA><NA><NA>62.24제주특별자치도 제주시 조천읍 대흘리 1611-1제주특별자치도 제주시 조천읍 중산간동로 700, 1층633432023-11-07
42255연동빵굽는마을휴게음식점과자점20010913<NA>폐업폐업20011212<NA><NA><NA>40.3제주특별자치도 제주시 연동 290-51번지 연동시장연립11호,112호<NA><NA>2023-11-07
45211씨유제주남원의귀점휴게음식점편의점20200103<NA>영업/정상영업<NA><NA><NA><NA>3.3제주특별자치도 서귀포시 남원읍 의귀리 794번지제주특별자치도 서귀포시 남원읍 한신로 247-3, 1층636182023-11-07
4790카사블랑카일반음식점까페20071217<NA>영업/정상영업<NA><NA><NA><NA>256.58제주특별자치도 제주시 연동 293-87제주특별자치도 제주시 은남길 38 (연동)631232023-11-07
36825꼬마팬시휴게음식점기타 휴게음식점20070402<NA>영업/정상영업<NA><NA><NA><NA>8.0제주특별자치도 제주시 도남동 56번지제주특별자치도 제주시 도남로8길 21 (도남동)632042023-11-07