Overview

Dataset statistics

Number of variables9
Number of observations730
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory55.0 KiB
Average record size in memory77.2 B

Variable types

Categorical5
Text1
Numeric3

Dataset

Description대학생 청소년교육지원장학금 멘토링 관련 대학 배정 금액 내역: 상품명, 배정년도, 배정구분, 대학명, 배정금액, 배정일자 등의 정보를 제공하고 있음대학생 청소년교육지원장학금 관련 정보는 "한국장학재단 누리집(http://www.kosaf.go.kr) > 인재육성 > 대학생지식멘토링 > 대학생 청소년교육지원장학금"에서 확인 가능
Author한국장학재단
URLhttps://www.data.go.kr/data/15070057/fileData.do

Alerts

상품명 has constant value ""Constant
배정년도 has constant value ""Constant
배정일자 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 배정구분 and 1 other fieldsHigh correlation
총배정금액 is highly overall correlated with 1학기배정금액 and 1 other fieldsHigh correlation
1학기배정금액 is highly overall correlated with 총배정금액 and 1 other fieldsHigh correlation
2학기배정금액 is highly overall correlated with 총배정금액 and 1 other fieldsHigh correlation
총배정금액 has 488 (66.8%) zerosZeros
1학기배정금액 has 534 (73.2%) zerosZeros
2학기배정금액 has 573 (78.5%) zerosZeros

Reproduction

Analysis started2024-04-06 08:50:59.568339
Analysis finished2024-04-06 08:51:03.246001
Duration3.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상품명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
대학생 청소년교육지원 장학금
730 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대학생 청소년교육지원 장학금
2nd row대학생 청소년교육지원 장학금
3rd row대학생 청소년교육지원 장학금
4th row대학생 청소년교육지원 장학금
5th row대학생 청소년교육지원 장학금

Common Values

ValueCountFrequency (%)
대학생 청소년교육지원 장학금 730
100.0%

Length

2024-04-06T17:51:03.435488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:51:03.699318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대학생 730
33.3%
청소년교육지원 730
33.3%
장학금 730
33.3%

배정년도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
2022
730 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022
2nd row2022
3rd row2022
4th row2022
5th row2022

Common Values

ValueCountFrequency (%)
2022 730
100.0%

Length

2024-04-06T17:51:03.992678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:51:04.275692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 730
100.0%

배정구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
추가배정
547 
정기배정
183 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row추가배정
2nd row추가배정
3rd row추가배정
4th row추가배정
5th row추가배정

Common Values

ValueCountFrequency (%)
추가배정 547
74.9%
정기배정 183
 
25.1%

Length

2024-04-06T17:51:04.565462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:51:04.827668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
추가배정 547
74.9%
정기배정 183
 
25.1%

배정일련번호
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
1
367 
2
184 
3
179 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3
2nd row3
3rd row3
4th row3
5th row3

Common Values

ValueCountFrequency (%)
1 367
50.3%
2 184
25.2%
3 179
24.5%

Length

2024-04-06T17:51:05.539298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:51:05.905320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 367
50.3%
2 184
25.2%
3 179
24.5%

대학명
Text

Distinct201
Distinct (%)27.5%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
2024-04-06T17:51:06.434174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length12.683562
Min length5

Characters and Unicode

Total characters9259
Distinct characters160
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16 ?
Unique (%)2.2%

Sample

1st row청주대학교(본교) 학부
2nd row청운대학교(본교) 학부
3rd row춘천교육대학교(본교) 학부
4th row춘해보건대학교(본교)
5th row충북대학교(본교) 학부
ValueCountFrequency (%)
학부 575
43.5%
중앙대학교 7
 
0.5%
세종캠퍼스 6
 
0.5%
계원예술대학교(본교 4
 
0.3%
경상국립대학교(본교 4
 
0.3%
경인교육대학교(본교 4
 
0.3%
경일대학교(본교 4
 
0.3%
경희대학교(서울캠퍼스 4
 
0.3%
계명대학교(본교 4
 
0.3%
계명문화대학교 4
 
0.3%
Other values (196) 707
53.4%
2024-04-06T17:51:07.468575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 1413
15.3%
학 1349
14.6%
대 769
 
8.3%
) 702
 
7.6%
( 701
 
7.6%
본 641
 
6.9%
부 624
 
6.7%
593
 
6.4%
국 122
 
1.3%
한 87
 
0.9%
Other values (150) 2258
24.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7263
78.4%
Close Punctuation 702
 
7.6%
Open Punctuation 701
 
7.6%
Space Separator 593
 
6.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 1413
19.5%
학 1349
18.6%
대 769
 
10.6%
본 641
 
8.8%
부 624
 
8.6%
국 122
 
1.7%
한 87
 
1.2%
서 67
 
0.9%
립 67
 
0.9%
동 60
 
0.8%
Other values (147) 2064
28.4%
Close Punctuation
ValueCountFrequency (%)
) 702
100.0%
Open Punctuation
ValueCountFrequency (%)
( 701
100.0%
Space Separator
ValueCountFrequency (%)
593
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7263
78.4%
Common 1996
 
21.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 1413
19.5%
학 1349
18.6%
대 769
 
10.6%
본 641
 
8.8%
부 624
 
8.6%
국 122
 
1.7%
한 87
 
1.2%
서 67
 
0.9%
립 67
 
0.9%
동 60
 
0.8%
Other values (147) 2064
28.4%
Common
ValueCountFrequency (%)
) 702
35.2%
( 701
35.1%
593
29.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7263
78.4%
ASCII 1996
 
21.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 1413
19.5%
학 1349
18.6%
대 769
 
10.6%
본 641
 
8.8%
부 624
 
8.6%
국 122
 
1.7%
한 87
 
1.2%
서 67
 
0.9%
립 67
 
0.9%
동 60
 
0.8%
Other values (147) 2064
28.4%
ASCII
ValueCountFrequency (%)
) 702
35.2%
( 701
35.1%
593
29.7%

총배정금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct174
Distinct (%)23.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean76336712
Minimum0
Maximum3.3002969 × 109
Zeros488
Zeros (%)66.8%
Negative0
Negative (%)0.0%
Memory size6.5 KiB
2024-04-06T17:51:07.857051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q337500000
95-th percentile3.9431875 × 108
Maximum3.3002969 × 109
Range3.3002969 × 109
Interquartile range (IQR)37500000

Descriptive statistics

Standard deviation2.5522411 × 108
Coefficient of variation (CV)3.3433994
Kurtosis70.342836
Mean76336712
Median Absolute Deviation (MAD)0
Skewness7.2907874
Sum5.57258 × 1010
Variance6.5139349 × 1016
MonotonicityNot monotonic
2024-04-06T17:51:08.276927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 488
66.8%
75000000 8
 
1.1%
37500000 7
 
1.0%
150000000 6
 
0.8%
15000000 5
 
0.7%
20000000 5
 
0.7%
45000000 5
 
0.7%
26250000 4
 
0.5%
50000000 4
 
0.5%
35000000 4
 
0.5%
Other values (164) 194
 
26.6%
ValueCountFrequency (%)
0 488
66.8%
3250000 1
 
0.1%
5000000 1
 
0.1%
6300000 1
 
0.1%
7000000 1
 
0.1%
8875000 1
 
0.1%
9100000 1
 
0.1%
9375000 1
 
0.1%
9750000 1
 
0.1%
9775000 1
 
0.1%
ValueCountFrequency (%)
3300296875 1
0.1%
3000000000 1
0.1%
2040000000 1
0.1%
1998750000 1
0.1%
1500000000 1
0.1%
1328600000 1
0.1%
1260000000 1
0.1%
1150875000 1
0.1%
1115000000 1
0.1%
1093750000 1
0.1%

1학기배정금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct123
Distinct (%)16.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean58918277
Minimum0
Maximum2.3275 × 109
Zeros534
Zeros (%)73.2%
Negative0
Negative (%)0.0%
Memory size6.5 KiB
2024-04-06T17:51:09.277217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q318025000
95-th percentile3.5 × 108
Maximum2.3275 × 109
Range2.3275 × 109
Interquartile range (IQR)18025000

Descriptive statistics

Standard deviation1.940566 × 108
Coefficient of variation (CV)3.2936571
Kurtosis54.660982
Mean58918277
Median Absolute Deviation (MAD)0
Skewness6.4596059
Sum4.3010342 × 1010
Variance3.7657964 × 1016
MonotonicityNot monotonic
2024-04-06T17:51:09.657941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 534
73.2%
26250000 10
 
1.4%
105000000 10
 
1.4%
52500000 8
 
1.1%
35000000 6
 
0.8%
70000000 5
 
0.7%
43750000 4
 
0.5%
87500000 4
 
0.5%
182000000 3
 
0.4%
273000000 3
 
0.4%
Other values (113) 143
 
19.6%
ValueCountFrequency (%)
0 534
73.2%
6300000 1
 
0.1%
7437500 1
 
0.1%
9100000 1
 
0.1%
9375000 1
 
0.1%
9625000 1
 
0.1%
10000000 1
 
0.1%
10500000 1
 
0.1%
13781250 1
 
0.1%
14000000 1
 
0.1%
ValueCountFrequency (%)
2327500000 1
0.1%
2100000000 1
0.1%
1440000000 1
0.1%
1399125000 1
0.1%
1274000000 1
0.1%
1260000000 1
0.1%
1093750000 1
0.1%
1050000000 1
0.1%
910000000 1
0.1%
805612500 1
0.1%

2학기배정금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct119
Distinct (%)16.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17418435
Minimum0
Maximum9.7279688 × 108
Zeros573
Zeros (%)78.5%
Negative0
Negative (%)0.0%
Memory size6.5 KiB
2024-04-06T17:51:10.177245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile79437500
Maximum9.7279688 × 108
Range9.7279688 × 108
Interquartile range (IQR)0

Descriptive statistics

Standard deviation72653440
Coefficient of variation (CV)4.1710659
Kurtosis85.043109
Mean17418435
Median Absolute Deviation (MAD)0
Skewness8.2034241
Sum1.2715458 × 1010
Variance5.2785223 × 1015
MonotonicityNot monotonic
2024-04-06T17:51:10.695431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 573
78.5%
15000000 8
 
1.1%
11250000 6
 
0.8%
45000000 6
 
0.8%
22500000 5
 
0.7%
20000000 5
 
0.7%
37500000 4
 
0.5%
75000000 3
 
0.4%
180000000 3
 
0.4%
225000000 3
 
0.4%
Other values (109) 114
 
15.6%
ValueCountFrequency (%)
0 573
78.5%
187500 1
 
0.1%
937500 1
 
0.1%
1081250 1
 
0.1%
1218750 1
 
0.1%
1515625 1
 
0.1%
2250000 1
 
0.1%
2875000 1
 
0.1%
3078125 1
 
0.1%
3250000 1
 
0.1%
ValueCountFrequency (%)
972796875 1
0.1%
900000000 1
0.1%
600000000 1
0.1%
599625000 1
0.1%
450000000 1
0.1%
400000000 1
0.1%
345262500 1
0.1%
334500000 1
0.1%
284734375 1
0.1%
250000000 1
0.1%

배정일자
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
2022-07-04
184 
2022-11-10
184 
2022-12-28
179 
2022-01-27
38 
2022-02-09
35 
Other values (13)
110 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique2 ?
Unique (%)0.3%

Sample

1st row2022-12-28
2nd row2022-12-28
3rd row2022-12-28
4th row2022-12-28
5th row2022-12-28

Common Values

ValueCountFrequency (%)
2022-07-04 184
25.2%
2022-11-10 184
25.2%
2022-12-28 179
24.5%
2022-01-27 38
 
5.2%
2022-02-09 35
 
4.8%
2022-02-11 22
 
3.0%
2022-02-07 19
 
2.6%
2022-01-28 14
 
1.9%
2022-02-03 10
 
1.4%
2022-02-04 10
 
1.4%
Other values (8) 35
 
4.8%

Length

2024-04-06T17:51:11.114492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-07-04 184
25.2%
2022-11-10 184
25.2%
2022-12-28 179
24.5%
2022-01-27 38
 
5.2%
2022-02-09 35
 
4.8%
2022-02-11 22
 
3.0%
2022-02-07 19
 
2.6%
2022-01-28 14
 
1.9%
2022-02-08 10
 
1.4%
2022-02-04 10
 
1.4%
Other values (8) 35
 
4.8%

Interactions

2024-04-06T17:51:01.963677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:00.394360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:01.193470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:02.214985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:00.714657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:01.467353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:02.442070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:00.950033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:51:01.732561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:51:11.388431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
배정구분배정일련번호총배정금액1학기배정금액2학기배정금액배정일자
배정구분1.0000.3600.3890.6150.2471.000
배정일련번호0.3601.0000.2240.2550.1031.000
총배정금액0.3890.2241.0000.9460.9800.519
1학기배정금액0.6150.2550.9461.0000.9110.569
2학기배정금액0.2470.1030.9800.9111.0000.390
배정일자1.0001.0000.5190.5690.3901.000
2024-04-06T17:51:11.687731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
배정일자배정구분배정일련번호
배정일자1.0000.9890.990
배정구분0.9891.0000.573
배정일련번호0.9900.5731.000
2024-04-06T17:51:11.938122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
총배정금액1학기배정금액2학기배정금액배정구분배정일련번호배정일자
총배정금액1.0000.9070.7290.4150.1530.260
1학기배정금액0.9071.0000.5220.4640.1660.279
2학기배정금액0.7290.5221.0000.2630.0690.184
배정구분0.4150.4640.2631.0000.5730.989
배정일련번호0.1530.1660.0690.5731.0000.990
배정일자0.2600.2790.1840.9890.9901.000

Missing values

2024-04-06T17:51:02.742064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:51:03.092688image/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

상품명배정년도배정구분배정일련번호대학명총배정금액1학기배정금액2학기배정금액배정일자
0대학생 청소년교육지원 장학금2022추가배정3청주대학교(본교) 학부0002022-12-28
1대학생 청소년교육지원 장학금2022추가배정3청운대학교(본교) 학부0002022-12-28
2대학생 청소년교육지원 장학금2022추가배정3춘천교육대학교(본교) 학부0002022-12-28
3대학생 청소년교육지원 장학금2022추가배정3춘해보건대학교(본교)3250000032500002022-12-28
4대학생 청소년교육지원 장학금2022추가배정3충북대학교(본교) 학부0002022-12-28
5대학생 청소년교육지원 장학금2022추가배정3충북도립대학(본교)0002022-12-28
6대학생 청소년교육지원 장학금2022추가배정3충북보건과학대학교(본교)0002022-12-28
7대학생 청소년교육지원 장학금2022추가배정3충청대학교(본교)0002022-12-28
8대학생 청소년교육지원 장학금2022추가배정3칼빈대학교(본교) 학부0002022-12-28
9대학생 청소년교육지원 장학금2022추가배정3평택대학교(본교) 학부0002022-12-28
상품명배정년도배정구분배정일련번호대학명총배정금액1학기배정금액2학기배정금액배정일자
720대학생 청소년교육지원 장학금2022정기배정1대구대학교(본교) 학부150000000010500000004500000002022-01-27
721대학생 청소년교육지원 장학금2022정기배정1대구가톨릭대학교(본교) 학부11508750008056125003452625002022-01-27
722대학생 청소년교육지원 장학금2022정기배정1단국대학교(천안캠퍼스)200000000140000000600000002022-01-27
723대학생 청소년교육지원 장학금2022정기배정1국립한국교통대학교(본교) 학부183890625159250000246406252022-01-27
724대학생 청소년교육지원 장학금2022정기배정1광운대학교(본교) 학부13650000013650000002022-01-27
725대학생 청소년교육지원 장학금2022정기배정1계원예술대학교(본교)3750000026250000112500002022-01-27
726대학생 청소년교육지원 장학금2022정기배정1경북대학교(본교) 학부300000000021000000009000000002022-01-27
727대학생 청소년교육지원 장학금2022정기배정1경남대학교(본교) 학부4500000003150000001350000002022-01-27
728대학생 청소년교육지원 장학금2022정기배정1강남대학교(본교) 학부126031250105000000210312502022-01-27
729대학생 청소년교육지원 장학금2022정기배정1단국대학교(죽전캠퍼스)143062500130768750122937502022-01-27