Overview

Dataset statistics

Number of variables7
Number of observations21
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory63.3 B

Variable types

Numeric1
Text2
DateTime1
Categorical3

Dataset

Description전라남도 함평군에서 출원하여 보호하고 있는 국화품종에 대한 데이터로 품종명, 출원번호, 보호만료일 등의 정보를 제공합니다.
Author전라남도 함평군
URLhttps://www.data.go.kr/data/15037387/fileData.do

Alerts

등록일 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
보호만료 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
연번 is highly overall correlated with 등록일 and 2 other fieldsHigh correlation
구분 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
연번 has unique valuesUnique
품종명 has unique valuesUnique
출원번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:48:18.659046
Analysis finished2023-12-12 06:48:19.270199
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-12T15:48:19.350741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q16
median11
Q316
95-th percentile20
Maximum21
Range20
Interquartile range (IQR)10

Descriptive statistics

Standard deviation6.2048368
Coefficient of variation (CV)0.56407607
Kurtosis-1.2
Mean11
Median Absolute Deviation (MAD)5
Skewness0
Sum231
Variance38.5
MonotonicityStrictly increasing
2023-12-12T15:48:19.474133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1 1
 
4.8%
2 1
 
4.8%
21 1
 
4.8%
20 1
 
4.8%
19 1
 
4.8%
18 1
 
4.8%
17 1
 
4.8%
16 1
 
4.8%
15 1
 
4.8%
14 1
 
4.8%
Other values (11) 11
52.4%
ValueCountFrequency (%)
1 1
4.8%
2 1
4.8%
3 1
4.8%
4 1
4.8%
5 1
4.8%
6 1
4.8%
7 1
4.8%
8 1
4.8%
9 1
4.8%
10 1
4.8%
ValueCountFrequency (%)
21 1
4.8%
20 1
4.8%
19 1
4.8%
18 1
4.8%
17 1
4.8%
16 1
4.8%
15 1
4.8%
14 1
4.8%
13 1
4.8%
12 1
4.8%

품종명
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-12T15:48:19.704286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length4
Mean length4.1904762
Min length4

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)100.0%

Sample

1st row국향백미
2nd row국향만홍
3rd row국향천황
4th row나비번영
5th row나비사랑
ValueCountFrequency (%)
국향백미 1
 
4.8%
나비금향 1
 
4.8%
천지금촌 1
 
4.8%
천지자홍 1
 
4.8%
천지백황 1
 
4.8%
천지석양 1
 
4.8%
국향풍월조 1
 
4.8%
국향미소조 1
 
4.8%
국향요염조 1
 
4.8%
나비연옥 1
 
4.8%
Other values (11) 11
52.4%
2023-12-12T15:48:20.105964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
비 11
 
12.5%
나 11
 
12.5%
향 7
 
8.0%
국 6
 
6.8%
천 5
 
5.7%
지 4
 
4.5%
금 3
 
3.4%
연 3
 
3.4%
조 3
 
3.4%
옥 3
 
3.4%
Other values (24) 32
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 88
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
비 11
 
12.5%
나 11
 
12.5%
향 7
 
8.0%
국 6
 
6.8%
천 5
 
5.7%
지 4
 
4.5%
금 3
 
3.4%
연 3
 
3.4%
조 3
 
3.4%
옥 3
 
3.4%
Other values (24) 32
36.4%

Most occurring scripts

ValueCountFrequency (%)
Hangul 88
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
비 11
 
12.5%
나 11
 
12.5%
향 7
 
8.0%
국 6
 
6.8%
천 5
 
5.7%
지 4
 
4.5%
금 3
 
3.4%
연 3
 
3.4%
조 3
 
3.4%
옥 3
 
3.4%
Other values (24) 32
36.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 88
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
비 11
 
12.5%
나 11
 
12.5%
향 7
 
8.0%
국 6
 
6.8%
천 5
 
5.7%
지 4
 
4.5%
금 3
 
3.4%
연 3
 
3.4%
조 3
 
3.4%
옥 3
 
3.4%
Other values (24) 32
36.4%

출원번호
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-12T15:48:20.319153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length8
Mean length7.7142857
Min length7

Characters and Unicode

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

Unique21 ?
Unique (%)100.0%

Sample

1st row2009-195
2nd row2009-196
3rd row2009-197
4th row2012-203
5th row2012-123
ValueCountFrequency (%)
2009-195 1
 
4.8%
2015-96 1
 
4.8%
2017-133 1
 
4.8%
2017-122 1
 
4.8%
2017-132 1
 
4.8%
2017-143 1
 
4.8%
2017-121 1
 
4.8%
2017-120 1
 
4.8%
2017-119 1
 
4.8%
2015-94 1
 
4.8%
Other values (11) 11
52.4%
2023-12-12T15:48:20.655076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 35
21.6%
1 34
21.0%
0 27
16.7%
- 21
13.0%
7 12
 
7.4%
9 10
 
6.2%
5 8
 
4.9%
3 6
 
3.7%
6 3
 
1.9%
8 3
 
1.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 141
87.0%
Dash Punctuation 21
 
13.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 35
24.8%
1 34
24.1%
0 27
19.1%
7 12
 
8.5%
9 10
 
7.1%
5 8
 
5.7%
3 6
 
4.3%
6 3
 
2.1%
8 3
 
2.1%
4 3
 
2.1%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 162
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 35
21.6%
1 34
21.0%
0 27
16.7%
- 21
13.0%
7 12
 
7.4%
9 10
 
6.2%
5 8
 
4.9%
3 6
 
3.7%
6 3
 
1.9%
8 3
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 162
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 35
21.6%
1 34
21.0%
0 27
16.7%
- 21
13.0%
7 12
 
7.4%
9 10
 
6.2%
5 8
 
4.9%
3 6
 
3.7%
6 3
 
1.9%
8 3
 
1.9%

출원일
Date

Distinct12
Distinct (%)57.1%
Missing0
Missing (%)0.0%
Memory size300.0 B
Minimum2009-02-27 00:00:00
Maximum2018-02-20 00:00:00
2023-12-12T15:48:20.808427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:48:20.924979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

등록일
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)42.9%
Missing0
Missing (%)0.0%
Memory size300.0 B
2018-04-18
4 
2013-05-23
3 
2016-05-27
3 
2016-05-31
3 
2018-05-04
3 
Other values (4)
5 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique3 ?
Unique (%)14.3%

Sample

1st row2010-08-03
2nd row2010-08-03
3rd row2011-08-02
4th row2013-05-21
5th row2013-05-23

Common Values

ValueCountFrequency (%)
2018-04-18 4
19.0%
2013-05-23 3
14.3%
2016-05-27 3
14.3%
2016-05-31 3
14.3%
2018-05-04 3
14.3%
2010-08-03 2
9.5%
2011-08-02 1
 
4.8%
2013-05-21 1
 
4.8%
2020-07-08 1
 
4.8%

Length

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

Common Values (Plot)

2023-12-12T15:48:21.244493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2018-04-18 4
19.0%
2013-05-23 3
14.3%
2016-05-27 3
14.3%
2016-05-31 3
14.3%
2018-05-04 3
14.3%
2010-08-03 2
9.5%
2011-08-02 1
 
4.8%
2013-05-21 1
 
4.8%
2020-07-08 1
 
4.8%

보호만료
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)42.9%
Missing0
Missing (%)0.0%
Memory size300.0 B
2038-04-17
4 
2033-05-22
3 
2036-05-26
3 
2036-05-30
3 
2038-05-03
3 
Other values (4)
5 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique3 ?
Unique (%)14.3%

Sample

1st row2030-08-02
2nd row2030-08-02
3rd row2031-08-01
4th row2033-05-20
5th row2033-05-22

Common Values

ValueCountFrequency (%)
2038-04-17 4
19.0%
2033-05-22 3
14.3%
2036-05-26 3
14.3%
2036-05-30 3
14.3%
2038-05-03 3
14.3%
2030-08-02 2
9.5%
2031-08-01 1
 
4.8%
2033-05-20 1
 
4.8%
2040-07-07 1
 
4.8%

Length

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

Common Values (Plot)

2023-12-12T15:48:21.551786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2038-04-17 4
19.0%
2033-05-22 3
14.3%
2036-05-26 3
14.3%
2036-05-30 3
14.3%
2038-05-03 3
14.3%
2030-08-02 2
9.5%
2031-08-01 1
 
4.8%
2033-05-20 1
 
4.8%
2040-07-07 1
 
4.8%

구분
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
분재국
11 
화단국
4 
현애국
3 
현수국
3 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row현애국
2nd row현애국
3rd row현애국
4th row분재국
5th row분재국

Common Values

ValueCountFrequency (%)
분재국 11
52.4%
화단국 4
 
19.0%
현애국 3
 
14.3%
현수국 3
 
14.3%

Length

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

Common Values (Plot)

2023-12-12T15:48:21.879772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
분재국 11
52.4%
화단국 4
 
19.0%
현애국 3
 
14.3%
현수국 3
 
14.3%

Interactions

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

Correlations

2023-12-12T15:48:21.962093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번품종명출원번호출원일등록일보호만료구분
연번1.0001.0001.0000.7610.8870.8870.903
품종명1.0001.0001.0001.0001.0001.0001.000
출원번호1.0001.0001.0001.0001.0001.0001.000
출원일0.7611.0001.0001.0000.9680.9681.000
등록일0.8871.0001.0000.9681.0001.0001.000
보호만료0.8871.0001.0000.9681.0001.0001.000
구분0.9031.0001.0001.0001.0001.0001.000
2023-12-12T15:48:22.079052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분등록일보호만료
구분1.0000.8400.840
등록일0.8401.0001.000
보호만료0.8401.0001.000
2023-12-12T15:48:22.176374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번등록일보호만료구분
연번1.0000.5560.5560.683
등록일0.5561.0001.0000.840
보호만료0.5561.0001.0000.840
구분0.6830.8400.8401.000

Missing values

2023-12-12T15:48:19.073396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:48:19.223466image/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국향백미2009-1952009-02-272010-08-032030-08-02현애국
12국향만홍2009-1962009-02-272010-08-032030-08-02현애국
23국향천황2009-1972009-02-272011-08-022031-08-01현애국
34나비번영2012-2032012-03-052013-05-212033-05-20분재국
45나비사랑2012-1232012-02-142013-05-232033-05-22분재국
56나비당산2012-1272012-02-152013-05-232033-05-22분재국
67나비백설2012-1282012-02-152013-05-232033-05-22분재국
78나비선유2015-782015-01-132016-05-272036-05-26분재국
89나비설화2015-772015-01-132016-05-272036-05-26분재국
910나비연홍2015-842015-01-142016-05-272036-05-26분재국
연번품종명출원번호출원일등록일보호만료구분
1112나비금향2015-962015-01-152016-05-312036-05-30분재국
1213나비연옥2015-942015-01-152016-05-312036-05-30분재국
1314국향요염조2017-1192017-02-282018-05-042038-05-03현수국
1415국향미소조2017-1202017-02-282018-05-042038-05-03현수국
1516국향풍월조2017-1212017-02-282018-05-042038-05-03현수국
1617천지석양2017-1432017-03-082018-04-182038-04-17화단국
1718천지백황2017-1322017-03-062018-04-182038-04-17화단국
1819천지자홍2017-1222017-03-012018-04-182038-04-17화단국
1920천지금촌2017-1332017-03-062018-04-182038-04-17화단국
2021나비연옥황2020-1162018-02-202020-07-082040-07-07분재국