Overview

Dataset statistics

Number of variables7
Number of observations980
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory57.6 KiB
Average record size in memory60.1 B

Variable types

Numeric4
Text1
DateTime1
Boolean1

Dataset

Description농촌진흥청 시군센터의 그룹 교육 과정 정보 관리 테이블입니다
Author농촌진흥청
URLhttps://www.data.go.kr/data/15049967/fileData.do

Alerts

시작시간 is highly overall correlated with 종료시간High correlation
종료시간 is highly overall correlated with 시작시간High correlation
내부식사 is highly imbalanced (95.4%)Imbalance
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 01:12:31.384743
Analysis finished2023-12-12 01:12:34.080089
Duration2.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct980
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean490.5
Minimum1
Maximum980
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB
2023-12-12T10:12:34.201076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile49.95
Q1245.75
median490.5
Q3735.25
95-th percentile931.05
Maximum980
Range979
Interquartile range (IQR)489.5

Descriptive statistics

Standard deviation283.04593
Coefficient of variation (CV)0.57705593
Kurtosis-1.2
Mean490.5
Median Absolute Deviation (MAD)245
Skewness0
Sum480690
Variance80115
MonotonicityStrictly increasing
2023-12-12T10:12:34.729887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
646 1
 
0.1%
648 1
 
0.1%
649 1
 
0.1%
650 1
 
0.1%
651 1
 
0.1%
652 1
 
0.1%
653 1
 
0.1%
654 1
 
0.1%
655 1
 
0.1%
Other values (970) 970
99.0%
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 (%)
980 1
0.1%
979 1
0.1%
978 1
0.1%
977 1
0.1%
976 1
0.1%
975 1
0.1%
974 1
0.1%
973 1
0.1%
972 1
0.1%
971 1
0.1%

강의명
Text

Distinct687
Distinct (%)70.1%
Missing0
Missing (%)0.0%
Memory size7.8 KiB
2023-12-12T10:12:35.113739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length27
Mean length11.488776
Min length2

Characters and Unicode

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

Unique

Unique598 ?
Unique (%)61.0%

Sample

1st row ATIS 과제등록요령
2nd row G20정상회의와 국가브랜드가치 제고
3rd row21세기 한국농업의 비전
4th row21세기 한국농업의 비전
5th rowBSC기반 성과관리
ValueCountFrequency (%)
및 218
 
7.9%
평가 63
 
2.3%
위한 41
 
1.5%
수료식 39
 
1.4%
정보교환 38
 
1.4%
등록 37
 
1.3%
종합토의 33
 
1.2%
방향 29
 
1.1%
녹색성장 27
 
1.0%
· 26
 
0.9%
Other values (1186) 2205
80.0%
2023-12-12T10:12:35.670739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1778
 
15.8%
기 280
 
2.5%
농 246
 
2.2%
및 220
 
2.0%
의 196
 
1.7%
업 174
 
1.5%
방 145
 
1.3%
리 144
 
1.3%
가 141
 
1.3%
정 141
 
1.3%
Other values (442) 7794
69.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9048
80.4%
Space Separator 1778
 
15.8%
Other Punctuation 122
 
1.1%
Uppercase Letter 111
 
1.0%
Decimal Number 86
 
0.8%
Dash Punctuation 37
 
0.3%
Close Punctuation 33
 
0.3%
Open Punctuation 33
 
0.3%
Lowercase Letter 7
 
0.1%
Math Symbol 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 280
 
3.1%
농 246
 
2.7%
및 220
 
2.4%
의 196
 
2.2%
업 174
 
1.9%
방 145
 
1.6%
리 144
 
1.6%
가 141
 
1.6%
정 141
 
1.6%
술 137
 
1.5%
Other values (408) 7224
79.8%
Uppercase Letter
ValueCountFrequency (%)
C 24
21.6%
I 16
14.4%
P 15
13.5%
A 14
12.6%
G 12
10.8%
H 11
9.9%
D 7
 
6.3%
R 5
 
4.5%
S 3
 
2.7%
B 2
 
1.8%
Other values (2) 2
 
1.8%
Other Punctuation
ValueCountFrequency (%)
· 61
50.0%
, 33
27.0%
: 10
 
8.2%
" 8
 
6.6%
& 5
 
4.1%
/ 3
 
2.5%
. 1
 
0.8%
! 1
 
0.8%
Decimal Number
ValueCountFrequency (%)
0 29
33.7%
2 24
27.9%
1 15
17.4%
3 7
 
8.1%
9 4
 
4.7%
7 3
 
3.5%
8 2
 
2.3%
4 2
 
2.3%
Space Separator
ValueCountFrequency (%)
1778
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%
Close Punctuation
ValueCountFrequency (%)
) 33
100.0%
Open Punctuation
ValueCountFrequency (%)
( 33
100.0%
Lowercase Letter
ValueCountFrequency (%)
l 7
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9048
80.4%
Common 2093
 
18.6%
Latin 118
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 280
 
3.1%
농 246
 
2.7%
및 220
 
2.4%
의 196
 
2.2%
업 174
 
1.9%
방 145
 
1.6%
리 144
 
1.6%
가 141
 
1.6%
정 141
 
1.6%
술 137
 
1.5%
Other values (408) 7224
79.8%
Common
ValueCountFrequency (%)
1778
84.9%
· 61
 
2.9%
- 37
 
1.8%
) 33
 
1.6%
, 33
 
1.6%
( 33
 
1.6%
0 29
 
1.4%
2 24
 
1.1%
1 15
 
0.7%
: 10
 
0.5%
Other values (11) 40
 
1.9%
Latin
ValueCountFrequency (%)
C 24
20.3%
I 16
13.6%
P 15
12.7%
A 14
11.9%
G 12
10.2%
H 11
9.3%
D 7
 
5.9%
l 7
 
5.9%
R 5
 
4.2%
S 3
 
2.5%
Other values (3) 4
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9048
80.4%
ASCII 2150
 
19.1%
None 61
 
0.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1778
82.7%
- 37
 
1.7%
) 33
 
1.5%
, 33
 
1.5%
( 33
 
1.5%
0 29
 
1.3%
2 24
 
1.1%
C 24
 
1.1%
I 16
 
0.7%
1 15
 
0.7%
Other values (23) 128
 
6.0%
Hangul
ValueCountFrequency (%)
기 280
 
3.1%
농 246
 
2.7%
및 220
 
2.4%
의 196
 
2.2%
업 174
 
1.9%
방 145
 
1.6%
리 144
 
1.6%
가 141
 
1.6%
정 141
 
1.6%
술 137
 
1.5%
Other values (408) 7224
79.8%
None
ValueCountFrequency (%)
· 61
100.0%

강의일자
Date

Distinct133
Distinct (%)13.6%
Missing0
Missing (%)0.0%
Memory size7.8 KiB
Minimum2009-06-08 00:00:00
Maximum2016-06-20 00:00:00
2023-12-12T10:12:35.871634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:36.062435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

시작시간
Real number (ℝ)

HIGH CORRELATION 

Distinct13
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.354082
Minimum7
Maximum19
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB
2023-12-12T10:12:36.223618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile9
Q19
median13
Q315
95-th percentile17
Maximum19
Range12
Interquartile range (IQR)6

Descriptive statistics

Standard deviation2.7774323
Coefficient of variation (CV)0.22481901
Kurtosis-1.1183019
Mean12.354082
Median Absolute Deviation (MAD)3
Skewness0.22458987
Sum12107
Variance7.7141304
MonotonicityNot monotonic
2023-12-12T10:12:36.386635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
9 254
25.9%
13 211
21.5%
11 91
 
9.3%
15 90
 
9.2%
10 87
 
8.9%
16 85
 
8.7%
14 82
 
8.4%
17 64
 
6.5%
19 11
 
1.1%
7 2
 
0.2%
Other values (3) 3
 
0.3%
ValueCountFrequency (%)
7 2
 
0.2%
8 1
 
0.1%
9 254
25.9%
10 87
 
8.9%
11 91
 
9.3%
12 1
 
0.1%
13 211
21.5%
14 82
 
8.4%
15 90
 
9.2%
16 85
 
8.7%
ValueCountFrequency (%)
19 11
 
1.1%
18 1
 
0.1%
17 64
 
6.5%
16 85
8.7%
15 90
9.2%
14 82
 
8.4%
13 211
21.5%
12 1
 
0.1%
11 91
9.3%
10 87
8.9%

종료시간
Real number (ℝ)

HIGH CORRELATION 

Distinct13
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.345918
Minimum9
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.7 KiB
2023-12-12T10:12:36.521163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile10
Q112
median14
Q317
95-th percentile18
Maximum21
Range12
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.8571244
Coefficient of variation (CV)0.1991594
Kurtosis-1.2605298
Mean14.345918
Median Absolute Deviation (MAD)2
Skewness0.074910677
Sum14059
Variance8.16316
MonotonicityNot monotonic
2023-12-12T10:12:36.674340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
12 220
22.4%
18 212
21.6%
14 109
11.1%
15 96
9.8%
11 88
 
9.0%
16 86
 
8.8%
10 85
 
8.7%
17 66
 
6.7%
21 9
 
0.9%
20 3
 
0.3%
Other values (3) 6
 
0.6%
ValueCountFrequency (%)
9 3
 
0.3%
10 85
 
8.7%
11 88
 
9.0%
12 220
22.4%
13 2
 
0.2%
14 109
11.1%
15 96
9.8%
16 86
 
8.8%
17 66
 
6.7%
18 212
21.6%
ValueCountFrequency (%)
21 9
 
0.9%
20 3
 
0.3%
19 1
 
0.1%
18 212
21.6%
17 66
 
6.7%
16 86
 
8.8%
15 96
9.8%
14 109
11.1%
13 2
 
0.2%
12 220
22.4%

강의시간
Real number (ℝ)

Distinct8
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9857143
Minimum0
Maximum9
Zeros1
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size8.7 KiB
2023-12-12T10:12:36.808964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q11
median2
Q32
95-th percentile5
Maximum9
Range9
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.4010794
Coefficient of variation (CV)0.70557956
Kurtosis9.9941006
Mean1.9857143
Median Absolute Deviation (MAD)1
Skewness2.7361719
Sum1946
Variance1.9630235
MonotonicityNot monotonic
2023-12-12T10:12:36.958591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
1 436
44.5%
2 330
33.7%
3 134
 
13.7%
5 36
 
3.7%
4 23
 
2.3%
9 18
 
1.8%
7 2
 
0.2%
0 1
 
0.1%
ValueCountFrequency (%)
0 1
 
0.1%
1 436
44.5%
2 330
33.7%
3 134
 
13.7%
4 23
 
2.3%
5 36
 
3.7%
7 2
 
0.2%
9 18
 
1.8%
ValueCountFrequency (%)
9 18
 
1.8%
7 2
 
0.2%
5 36
 
3.7%
4 23
 
2.3%
3 134
 
13.7%
2 330
33.7%
1 436
44.5%
0 1
 
0.1%

내부식사
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
False
975 
True
 
5
ValueCountFrequency (%)
False 975
99.5%
True 5
 
0.5%
2023-12-12T10:12:37.077981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Interactions

2023-12-12T10:12:33.317296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:31.845219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.327067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.831816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:33.414820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:31.970622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.451919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.950486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:33.532422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.087542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.593138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:33.079808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:33.679697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.197097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:32.699338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:12:33.193560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T10:12:37.156562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호시작시간종료시간강의시간내부식사
번호1.0000.4690.5010.3010.000
시작시간0.4691.0000.9450.4840.317
종료시간0.5010.9451.0000.5200.000
강의시간0.3010.4840.5201.0000.584
내부식사0.0000.3170.0000.5841.000
2023-12-12T10:12:37.299155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호시작시간종료시간강의시간내부식사
번호1.0000.0990.109-0.0330.000
시작시간0.0991.0000.858-0.1690.243
종료시간0.1090.8581.0000.2610.000
강의시간-0.033-0.1690.2611.0000.440
내부식사0.0000.2430.0000.4401.000

Missing values

2023-12-12T10:12:33.843331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:12:34.015653image/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

번호강의명강의일자시작시간종료시간강의시간내부식사
01ATIS 과제등록요령2010-05-1816182N
12G20정상회의와 국가브랜드가치 제고2010-06-1410122N
2321세기 한국농업의 비전2010-04-1214162N
3421세기 한국농업의 비전2010-05-2810122N
45BSC기반 성과관리2010-02-1815183N
56G-20 서울정상회의 의미와 과제2010-05-1010122N
67G-20 서울정상회의의미와 과제2010-05-1010122N
78G20 정상회의와 국가 브랜드 가치 제고2010-04-1210122N
89G20정상회의와 국가브랜드가치 제고2010-03-0810122N
910G20정상회의와 국가브랜드가치 제고2010-03-0810122N
번호강의명강의일자시작시간종료시간강의시간내부식사
970971현장기술지원 사례2010-06-1410111N
971972현장연구 실행방법2010-05-0610122N
972973현장중심의 농업기술개발 추진방향2010-05-049101N
973974황유섭의 행복텃밭 견학2010-04-0115183N
974975회귀분석2010-09-089123N
975976효과적인 멘토링2010-02-179123N
976977효과적인 시간관리2010-02-1813174N
977978효과적인 영어학습법2010-06-2213152N
978979효율적인 시간관리2010-04-0715183N
979980효율적인 시간관리2010-06-0315183N