Overview

Dataset statistics

Number of variables7
Number of observations135
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.8 KiB
Average record size in memory59.0 B

Variable types

Numeric2
Text2
Categorical2
DateTime1

Dataset

Description제주특별자치도 제주시 관내 육상 양식장 현황 데이터입니다.항목 : 해당연도, 허가번호, 상호, 주소, 대표 품종, 주 생산품종
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/3083549/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
대표품종 is highly overall correlated with 주생산품종High correlation
주생산품종 is highly overall correlated with 대표품종High correlation
대표품종 is highly imbalanced (70.8%)Imbalance
주생산품종 is highly imbalanced (67.6%)Imbalance
상호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:42:31.104688
Analysis finished2023-12-12 20:42:32.115214
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

해당연도
Real number (ℝ)

Distinct6
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2020.5185
Minimum2018
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-13T05:42:32.178286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2018
5-th percentile2018
Q12020
median2020
Q32021.5
95-th percentile2023
Maximum2023
Range5
Interquartile range (IQR)1.5

Descriptive statistics

Standard deviation1.4291833
Coefficient of variation (CV)0.00070733493
Kurtosis-0.72951258
Mean2020.5185
Median Absolute Deviation (MAD)1
Skewness0.19569995
Sum272770
Variance2.042565
MonotonicityNot monotonic
2023-12-13T05:42:32.326320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2020 42
31.1%
2021 27
20.0%
2019 22
16.3%
2022 17
12.6%
2023 17
12.6%
2018 10
 
7.4%
ValueCountFrequency (%)
2018 10
 
7.4%
2019 22
16.3%
2020 42
31.1%
2021 27
20.0%
2022 17
12.6%
2023 17
12.6%
ValueCountFrequency (%)
2023 17
12.6%
2022 17
12.6%
2021 27
20.0%
2020 42
31.1%
2019 22
16.3%
2018 10
 
7.4%

허가번호
Real number (ℝ)

Distinct42
Distinct (%)31.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.637037
Minimum1
Maximum42
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-13T05:42:32.485436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q17.5
median14
Q322.5
95-th percentile35.3
Maximum42
Range41
Interquartile range (IQR)15

Descriptive statistics

Standard deviation10.197752
Coefficient of variation (CV)0.65215371
Kurtosis-0.34244185
Mean15.637037
Median Absolute Deviation (MAD)8
Skewness0.59411311
Sum2111
Variance103.99414
MonotonicityNot monotonic
2023-12-13T05:42:32.636957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
13 5
 
3.7%
10 5
 
3.7%
8 5
 
3.7%
6 5
 
3.7%
5 5
 
3.7%
4 5
 
3.7%
2 5
 
3.7%
1 5
 
3.7%
3 5
 
3.7%
11 5
 
3.7%
Other values (32) 85
63.0%
ValueCountFrequency (%)
1 5
3.7%
2 5
3.7%
3 5
3.7%
4 5
3.7%
5 5
3.7%
6 5
3.7%
7 4
3.0%
8 5
3.7%
9 5
3.7%
10 5
3.7%
ValueCountFrequency (%)
42 1
0.7%
41 1
0.7%
40 1
0.7%
39 1
0.7%
38 1
0.7%
37 1
0.7%
36 1
0.7%
35 1
0.7%
34 1
0.7%
33 1
0.7%

상호
Text

UNIQUE 

Distinct135
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-13T05:42:32.861535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length5.9777778
Min length2

Characters and Unicode

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

Unique

Unique135 ?
Unique (%)100.0%

Sample

1st row산호초수산
2nd row(영)수월수산
3rd row㈜신흥바다낚시공원
4th row대덕수산
5th row용수산
ValueCountFrequency (%)
어업회사법인 2
 
1.4%
산호초수산 1
 
0.7%
영)온누리수산 1
 
0.7%
흥림수산 1
 
0.7%
바다수산 1
 
0.7%
어업회사법인무진㈜ 1
 
0.7%
금영수산 1
 
0.7%
대옥수산 1
 
0.7%
용천수산(영 1
 
0.7%
재영수산 1
 
0.7%
Other values (127) 127
92.0%
2023-12-13T05:42:33.250746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
산 100
 
12.4%
수 100
 
12.4%
영 47
 
5.8%
( 38
 
4.7%
) 38
 
4.7%
어 21
 
2.6%
인 18
 
2.2%
법 17
 
2.1%
해 14
 
1.7%
업 14
 
1.7%
Other values (137) 400
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 717
88.8%
Open Punctuation 38
 
4.7%
Close Punctuation 38
 
4.7%
Other Symbol 9
 
1.1%
Space Separator 3
 
0.4%
Decimal Number 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 100
 
13.9%
수 100
 
13.9%
영 47
 
6.6%
어 21
 
2.9%
인 18
 
2.5%
법 17
 
2.4%
해 14
 
2.0%
업 14
 
2.0%
양 13
 
1.8%
회 13
 
1.8%
Other values (131) 360
50.2%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
1 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 9
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 726
90.0%
Common 81
 
10.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 100
 
13.8%
수 100
 
13.8%
영 47
 
6.5%
어 21
 
2.9%
인 18
 
2.5%
법 17
 
2.3%
해 14
 
1.9%
업 14
 
1.9%
양 13
 
1.8%
회 13
 
1.8%
Other values (132) 369
50.8%
Common
ValueCountFrequency (%)
( 38
46.9%
) 38
46.9%
3
 
3.7%
2 1
 
1.2%
1 1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 717
88.8%
ASCII 81
 
10.0%
None 9
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
산 100
 
13.9%
수 100
 
13.9%
영 47
 
6.6%
어 21
 
2.9%
인 18
 
2.5%
법 17
 
2.4%
해 14
 
2.0%
업 14
 
2.0%
양 13
 
1.8%
회 13
 
1.8%
Other values (131) 360
50.2%
ASCII
ValueCountFrequency (%)
( 38
46.9%
) 38
46.9%
3
 
3.7%
2 1
 
1.2%
1 1
 
1.2%
None
ValueCountFrequency (%)
㈜ 9
100.0%

주소
Text

Distinct118
Distinct (%)87.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-13T05:42:33.599750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length27
Mean length26.02963
Min length23

Characters and Unicode

Total characters3514
Distinct characters74
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

Unique106 ?
Unique (%)78.5%

Sample

1st row제주특별자치도 제주시 구좌읍 해맞이해안로 916
2nd row제주특별자치도 제주시 한경면 고산리 3932
3rd row제주특별자치도 제주시 조천읍 조함해안로 277-33
4th row제주특별자치도 제주시 한림읍 귀덕11길 22-1
5th row제주특별자치도 제주시 구좌읍 동복로 105
ValueCountFrequency (%)
제주특별자치도 135
20.1%
제주시 135
20.1%
구좌읍 67
 
10.0%
해맞이해안로 52
 
7.7%
한경면 28
 
4.2%
한림읍 18
 
2.7%
조천읍 14
 
2.1%
금등3길 9
 
1.3%
한림해안로 8
 
1.2%
노을해안로 8
 
1.2%
Other values (151) 199
29.6%
2023-12-13T05:42:34.137949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
538
 
15.3%
주 277
 
7.9%
제 270
 
7.7%
도 140
 
4.0%
자 137
 
3.9%
해 136
 
3.9%
특 135
 
3.8%
별 135
 
3.8%
치 135
 
3.8%
시 135
 
3.8%
Other values (64) 1476
42.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2401
68.3%
Space Separator 538
 
15.3%
Decimal Number 516
 
14.7%
Dash Punctuation 51
 
1.5%
Open Punctuation 4
 
0.1%
Close Punctuation 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 277
 
11.5%
제 270
 
11.2%
도 140
 
5.8%
자 137
 
5.7%
해 136
 
5.7%
특 135
 
5.6%
별 135
 
5.6%
치 135
 
5.6%
시 135
 
5.6%
읍 101
 
4.2%
Other values (50) 800
33.3%
Decimal Number
ValueCountFrequency (%)
1 86
16.7%
3 83
16.1%
8 72
14.0%
0 57
11.0%
6 54
10.5%
2 51
9.9%
4 31
 
6.0%
5 29
 
5.6%
9 29
 
5.6%
7 24
 
4.7%
Space Separator
ValueCountFrequency (%)
538
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 51
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2401
68.3%
Common 1113
31.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 277
 
11.5%
제 270
 
11.2%
도 140
 
5.8%
자 137
 
5.7%
해 136
 
5.7%
특 135
 
5.6%
별 135
 
5.6%
치 135
 
5.6%
시 135
 
5.6%
읍 101
 
4.2%
Other values (50) 800
33.3%
Common
ValueCountFrequency (%)
538
48.3%
1 86
 
7.7%
3 83
 
7.5%
8 72
 
6.5%
0 57
 
5.1%
6 54
 
4.9%
2 51
 
4.6%
- 51
 
4.6%
4 31
 
2.8%
5 29
 
2.6%
Other values (4) 61
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2401
68.3%
ASCII 1113
31.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
538
48.3%
1 86
 
7.7%
3 83
 
7.5%
8 72
 
6.5%
0 57
 
5.1%
6 54
 
4.9%
2 51
 
4.6%
- 51
 
4.6%
4 31
 
2.8%
5 29
 
2.6%
Other values (4) 61
 
5.5%
Hangul
ValueCountFrequency (%)
주 277
 
11.5%
제 270
 
11.2%
도 140
 
5.8%
자 137
 
5.7%
해 136
 
5.7%
특 135
 
5.6%
별 135
 
5.6%
치 135
 
5.6%
시 135
 
5.6%
읍 101
 
4.2%
Other values (50) 800
33.3%

대표품종
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct8
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
어류
117 
패류
 
7
해삼
 
5
패류+해삼류
 
2
패류+해삼
 
1
Other values (3)
 
3

Length

Max length9
Median length2
Mean length2.1555556
Min length2

Unique

Unique4 ?
Unique (%)3.0%

Sample

1st row어류
2nd row어류
3rd row어류
4th row어류
5th row어류

Common Values

ValueCountFrequency (%)
어류 117
86.7%
패류 7
 
5.2%
해삼 5
 
3.7%
패류+해삼류 2
 
1.5%
패류+해삼 1
 
0.7%
넙치 1
 
0.7%
어류+패류+해삼류 1
 
0.7%
어류+해삼 1
 
0.7%

Length

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

Common Values (Plot)

2023-12-13T05:42:34.457278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
어류 117
86.7%
패류 7
 
5.2%
해삼 5
 
3.7%
패류+해삼류 2
 
1.5%
패류+해삼 1
 
0.7%
넙치 1
 
0.7%
어류+패류+해삼류 1
 
0.7%
어류+해삼 1
 
0.7%

주생산품종
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct11
Distinct (%)8.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
넙치
113 
해삼
 
6
전복
 
4
패류
 
4
<NA>
 
2
Other values (6)
 
6

Length

Max length5
Median length2
Mean length2.0518519
Min length2

Unique

Unique6 ?
Unique (%)4.4%

Sample

1st row넙치
2nd row넙치
3rd row참돔
4th row넙치
5th row넙치

Common Values

ValueCountFrequency (%)
넙치 113
83.7%
해삼 6
 
4.4%
전복 4
 
3.0%
패류 4
 
3.0%
<NA> 2
 
1.5%
참돔 1
 
0.7%
돌돔 1
 
0.7%
어류 1
 
0.7%
터봇 1
 
0.7%
해수관상어 1
 
0.7%

Length

2023-12-13T05:42:34.583538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
넙치 113
83.7%
해삼 6
 
4.4%
전복 4
 
3.0%
패류 4
 
3.0%
na 2
 
1.5%
참돔 1
 
0.7%
돌돔 1
 
0.7%
어류 1
 
0.7%
터봇 1
 
0.7%
해수관상어 1
 
0.7%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2023-09-20 00:00:00
Maximum2023-09-20 00:00:00
2023-12-13T05:42:34.700347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:42:34.815920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T05:42:31.682980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:42:31.466290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:42:31.786409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:42:31.579853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:42:34.897887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
해당연도허가번호대표품종주생산품종
해당연도1.0000.4070.1860.246
허가번호0.4071.0000.3840.509
대표품종0.1860.3841.0000.846
주생산품종0.2460.5090.8461.000
2023-12-13T05:42:35.041303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대표품종주생산품종
대표품종1.0000.647
주생산품종0.6471.000
2023-12-13T05:42:35.215496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
해당연도허가번호대표품종주생산품종
해당연도1.000-0.3640.0720.145
허가번호-0.3641.0000.1910.176
대표품종0.0720.1911.0000.647
주생산품종0.1450.1760.6471.000

Missing values

2023-12-13T05:42:31.936802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:42:32.068258image/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

해당연도허가번호상호주소대표품종주생산품종데이터기준일자
0201823산호초수산제주특별자치도 제주시 구좌읍 해맞이해안로 916어류넙치2023-09-20
1201821(영)수월수산제주특별자치도 제주시 한경면 고산리 3932어류넙치2023-09-20
2201824㈜신흥바다낚시공원제주특별자치도 제주시 조천읍 조함해안로 277-33어류참돔2023-09-20
3201825대덕수산제주특별자치도 제주시 한림읍 귀덕11길 22-1어류넙치2023-09-20
4201826용수산제주특별자치도 제주시 구좌읍 동복로 105어류넙치2023-09-20
5201827양지수산제주특별자치도 제주시 구좌읍 해맞이해안로 872어류넙치2023-09-20
6201822자매수산제주특별자치도 제주시 한림읍 귀덕11길 68어류넙치2023-09-20
7201828두문포수산제주특별자치도 제주시 해맞이해안로 2246어류넙치2023-09-20
8201830진보수산제주특별자치도 제주시 구좌읍 해맞이해안로 342어류넙치2023-09-20
9201829해동수산제주특별자치도 제주시 조천읍 북촌서길 38어류넙치2023-09-20
해당연도허가번호상호주소대표품종주생산품종데이터기준일자
12520238미래수산제주특별자치도 제주시 한림읍 한림해안로 436해삼해삼2023-09-20
12620239동덕(영)제주특별자치도 제주시 한경면 금등3길 103어류넙치2023-09-20
127202310한물제주특별자치도 제주시 한경면 노을해안로 834어류넙치2023-09-20
128202311어진수산제주특별자치도 제주시 한림읍 귀덕7길 28-6어류넙치2023-09-20
129202312어업회사법인㈜뉴태양수산제주특별자치도 제주시 한림읍 귀덕리 3945어류넙치2023-09-20
130202313고원수산(영)제주특별자치도 제주시 구좌읍 해맞이해안로 384어류넙치2023-09-20
131202314대풍수산(영)제주특별자치도 제주시 구좌읍 해맞이해안로 384어류넙치2023-09-20
132202315선우수산제주특별자치도 제주시 구좌읍 해맞이해안로 680-32어류넙치2023-09-20
133202316다다(영)제주특별자치도 제주시 한경면 고산리 3859어류넙치2023-09-20
134202317대한수산(영)제주특별자치도 제주시 조천읍 북촌리 383어류넙치2023-09-20