Overview

Dataset statistics

Number of variables9
Number of observations677
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory49.7 KiB
Average record size in memory75.2 B

Variable types

Categorical3
Text1
DateTime4
Numeric1

Dataset

Description대학생 청소년교육지원장학금 국고 이자수익 관리 정보: 상품명, 연도, 학기 , 대학명, 이자발생일자, 이자수익금액, 등록일시 등에 대한 데이터
Author한국장학재단
URLhttps://www.data.go.kr/data/15070467/fileData.do

Alerts

상품코드 has constant value ""Constant
년도 has constant value ""Constant
변경상세일시 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:43:24.987506
Analysis finished2023-12-12 19:43:25.759300
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상품코드
Categorical

CONSTANT 

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

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

2023-12-13T04:43:25.862379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:43:26.015976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대학생 677
50.0%
청소년교육지원장학금 677
50.0%

년도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
2019
677 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2019 677
100.0%

Length

2023-12-13T04:43:26.175746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:43:26.321118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019 677
100.0%

학기
Categorical

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
1
343 
2
334 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2
2nd row1
3rd row2
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 343
50.7%
2 334
49.3%

Length

2023-12-13T04:43:26.817761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:43:26.989260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 343
50.7%
2 334
49.3%

대학코드
Text

Distinct164
Distinct (%)24.2%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
2023-12-13T04:43:27.261911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length17
Mean length12.546529
Min length5

Characters and Unicode

Total characters8494
Distinct characters156
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

Unique3 ?
Unique (%)0.4%

Sample

1st row목포가톨릭대학교(본교) 학부
2nd row나사렛대학교(본교) 학부
3rd row신한대학교(본교)
4th row경희대학교(서울캠퍼스) 학부
5th row춘해보건대학교(본교)
ValueCountFrequency (%)
학부 523
42.6%
동명대학교(본교 24
 
2.0%
배화여자대학교(본교 20
 
1.6%
경운대학교(본교 18
 
1.5%
부경대학교(본교 15
 
1.2%
한국항공대학교(본교 14
 
1.1%
연세대학교 13
 
1.1%
미래캠퍼스(분교 13
 
1.1%
선문대학교(본교 11
 
0.9%
칼빈대학교(본교 11
 
0.9%
Other values (158) 567
46.1%
2023-12-13T04:43:27.779854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 1277
15.0%
학 1247
14.7%
대 710
 
8.4%
( 649
 
7.6%
) 649
 
7.6%
본 578
 
6.8%
부 576
 
6.8%
552
 
6.5%
한 85
 
1.0%
경 77
 
0.9%
Other values (146) 2094
24.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6644
78.2%
Open Punctuation 649
 
7.6%
Close Punctuation 649
 
7.6%
Space Separator 552
 
6.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 1277
19.2%
학 1247
18.8%
대 710
 
10.7%
본 578
 
8.7%
부 576
 
8.7%
한 85
 
1.3%
경 77
 
1.2%
국 70
 
1.1%
동 70
 
1.1%
서 64
 
1.0%
Other values (143) 1890
28.4%
Open Punctuation
ValueCountFrequency (%)
( 649
100.0%
Close Punctuation
ValueCountFrequency (%)
) 649
100.0%
Space Separator
ValueCountFrequency (%)
552
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6644
78.2%
Common 1850
 
21.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 1277
19.2%
학 1247
18.8%
대 710
 
10.7%
본 578
 
8.7%
부 576
 
8.7%
한 85
 
1.3%
경 77
 
1.2%
국 70
 
1.1%
동 70
 
1.1%
서 64
 
1.0%
Other values (143) 1890
28.4%
Common
ValueCountFrequency (%)
( 649
35.1%
) 649
35.1%
552
29.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6644
78.2%
ASCII 1850
 
21.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 1277
19.2%
학 1247
18.8%
대 710
 
10.7%
본 578
 
8.7%
부 576
 
8.7%
한 85
 
1.3%
경 77
 
1.2%
국 70
 
1.1%
동 70
 
1.1%
서 64
 
1.0%
Other values (143) 1890
28.4%
ASCII
ValueCountFrequency (%)
( 649
35.1%
) 649
35.1%
552
29.8%

이자발생일자
Date

Distinct51
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
Minimum2019-03-01 00:00:00
Maximum2020-02-03 00:00:00
2023-12-13T04:43:27.947880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:43:28.125694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

변경상세일시
Date

UNIQUE 

Distinct677
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
Minimum2019-02-11 13:53:56
Maximum2020-03-25 09:14:50
2023-12-13T04:43:28.290567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:43:28.467600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

이자수익금액
Real number (ℝ)

Distinct480
Distinct (%)70.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28369.913
Minimum1
Maximum2678454
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.1 KiB
2023-12-13T04:43:28.638680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile351.8
Q12240
median6196
Q318817
95-th percentile89532
Maximum2678454
Range2678453
Interquartile range (IQR)16577

Descriptive statistics

Standard deviation159717.6
Coefficient of variation (CV)5.6298233
Kurtosis223.52681
Mean28369.913
Median Absolute Deviation (MAD)4868
Skewness14.52325
Sum19206431
Variance2.550971 × 1010
MonotonicityNot monotonic
2023-12-13T04:43:28.867543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1335 13
 
1.9%
2147 11
 
1.6%
97349 10
 
1.5%
5471 6
 
0.9%
403 6
 
0.9%
5066 5
 
0.7%
5339 5
 
0.7%
349 5
 
0.7%
25715 5
 
0.7%
606 5
 
0.7%
Other values (470) 606
89.5%
ValueCountFrequency (%)
1 3
0.4%
2 1
 
0.1%
4 1
 
0.1%
54 1
 
0.1%
62 3
0.4%
64 1
 
0.1%
68 1
 
0.1%
76 1
 
0.1%
81 1
 
0.1%
105 1
 
0.1%
ValueCountFrequency (%)
2678454 1
 
0.1%
2567546 1
 
0.1%
1696049 1
 
0.1%
645238 1
 
0.1%
219739 2
0.3%
179575 1
 
0.1%
155557 1
 
0.1%
122390 3
0.4%
118841 1
 
0.1%
118453 1
 
0.1%

최초등록일시
Date

Distinct550
Distinct (%)81.2%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
Minimum2019-02-11 13:53:56
Maximum2020-03-24 19:36:11
2023-12-13T04:43:29.033456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:43:29.197321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

최종변경일시
Date

Distinct583
Distinct (%)86.1%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
Minimum2019-02-11 13:53:56
Maximum2020-03-25 09:14:50
2023-12-13T04:43:29.382753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:43:29.546751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-13T04:43:25.292777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:43:29.677698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
학기이자발생일자이자수익금액
학기1.0001.0000.000
이자발생일자1.0001.0000.000
이자수익금액0.0000.0001.000
2023-12-13T04:43:29.780817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이자수익금액학기
이자수익금액1.0000.000
학기0.0001.000

Missing values

2023-12-13T04:43:25.481512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:43:25.687856image/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

상품코드년도학기대학코드이자발생일자변경상세일시이자수익금액최초등록일시최종변경일시
0대학생 청소년교육지원장학금20192목포가톨릭대학교(본교) 학부2019-12-152019-02-11 13:53:5688302019-02-11 13:53:562019-02-11 13:53:56
1대학생 청소년교육지원장학금20191나사렛대학교(본교) 학부2019-06-172019-02-13 13:35:5660552019-02-13 13:35:562019-02-13 13:35:56
2대학생 청소년교육지원장학금20192신한대학교(본교)2019-09-152019-03-06 15:25:1626892019-03-06 15:25:162019-03-06 15:25:16
3대학생 청소년교육지원장학금20191경희대학교(서울캠퍼스) 학부2019-06-142019-07-24 13:40:1947342019-07-24 13:40:192019-07-24 13:40:19
4대학생 청소년교육지원장학금20191춘해보건대학교(본교)2019-06-232020-01-14 14:04:5233892020-01-14 14:04:522020-01-14 14:04:52
5대학생 청소년교육지원장학금20191광주여자대학교(본교) 학부2019-06-232020-02-04 18:24:26256592020-02-04 18:24:262020-02-04 18:24:26
6대학생 청소년교육지원장학금20192고려대학교 세종캠퍼스2019-12-212020-02-07 13:55:35375212020-02-07 13:55:352020-02-07 13:55:35
7대학생 청소년교육지원장학금20191계명대학교(본교) 학부2019-06-232020-02-14 15:29:12128092020-02-14 15:29:112020-02-14 15:29:11
8대학생 청소년교육지원장학금20192목원대학교(본교) 학부2019-12-212020-02-20 19:26:3070552020-02-20 19:26:302020-02-20 19:26:30
9대학생 청소년교육지원장학금20192선문대학교(본교) 학부2019-12-142020-02-24 11:26:3568882020-02-24 11:25:292020-02-24 11:25:29
상품코드년도학기대학코드이자발생일자변경상세일시이자수익금액최초등록일시최종변경일시
667대학생 청소년교육지원장학금20192성결대학교(본교) 학부2019-12-222020-03-10 13:33:10134842020-03-10 13:33:102020-03-10 13:33:10
668대학생 청소년교육지원장학금20192안동대학교(본교) 학부2019-12-212020-03-11 13:21:1193752020-03-11 13:21:102020-03-11 13:21:10
669대학생 청소년교육지원장학금20191홍익대학교 세종캠퍼스 학부2019-06-222020-03-11 14:08:57268542020-03-11 14:08:572020-03-11 14:08:57
670대학생 청소년교육지원장학금20192호서대학교(본교) 학부2019-12-152020-03-11 14:10:0693822020-03-11 10:08:502020-03-11 10:08:50
671대학생 청소년교육지원장학금20191동신대학교(본교) 학부2019-06-232020-03-11 16:42:06365712020-03-11 16:42:062020-03-11 16:42:06
672대학생 청소년교육지원장학금20192한세대학교(본교) 학부2019-10-172020-03-12 15:16:471382020-03-12 15:16:472020-03-12 15:16:47
673대학생 청소년교육지원장학금20191동명대학교(본교) 학부2019-05-192020-03-12 16:06:5513352020-03-12 16:05:532020-03-12 16:05:53
674대학생 청소년교육지원장학금20191동명대학교(본교) 학부2019-05-192020-03-12 17:52:3513352020-03-12 17:47:132020-03-12 17:47:13
675대학생 청소년교육지원장학금20192부산경상대학교(본교)2019-11-172020-03-13 10:36:1368292020-03-13 10:16:592020-03-13 10:36:13
676대학생 청소년교육지원장학금20192을지대학교(성남캠퍼스)2019-09-212020-03-16 14:36:44188172020-03-16 14:36:442020-03-16 14:36:44