Overview

Dataset statistics

Number of variables6
Number of observations509
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.5 KiB
Average record size in memory51.3 B

Variable types

Categorical3
Text1
DateTime1
Numeric1

Dataset

Description대학생 청소년교육지원장학금 멘토링 관련 국고 이자수익 관리 정보: 상품명, 연도, 학기, 대학명, 이자발생일자, 이자수익금액 등
URLhttps://www.data.go.kr/data/15070465/fileData.do

Alerts

상품명 has constant value ""Constant
연도 has constant value ""Constant

Reproduction

Analysis started2023-12-12 06:35:30.437832
Analysis finished2023-12-12 06:35:30.936840
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상품명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.1 KiB
교사대생튜터링장학사업
509 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row교사대생튜터링장학사업
2nd row교사대생튜터링장학사업
3rd row교사대생튜터링장학사업
4th row교사대생튜터링장학사업
5th row교사대생튜터링장학사업

Common Values

ValueCountFrequency (%)
교사대생튜터링장학사업 509
100.0%

Length

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

Common Values (Plot)

2023-12-12T15:35:31.139544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교사대생튜터링장학사업 509
100.0%

연도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.1 KiB
2022
509 

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 509
100.0%

Length

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

Common Values (Plot)

2023-12-12T15:35:31.352396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 509
100.0%

학기
Categorical

Distinct2
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size4.1 KiB
2
262 
1
247 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 262
51.5%
1 247
48.5%

Length

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

Common Values (Plot)

2023-12-12T15:35:31.560716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 262
51.5%
1 247
48.5%

대학명
Text

Distinct183
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Memory size4.1 KiB
2023-12-12T15:35:31.724862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length17
Mean length12.614931
Min length5

Characters and Unicode

Total characters6421
Distinct characters159
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

Unique8 ?
Unique (%)1.6%

Sample

1st row한남대학교(본교) 학부
2nd row한남대학교(본교) 학부
3rd row연세대학교(본교) 학부
4th row연세대학교 미래캠퍼스(분교) 학부
5th row연세대학교 미래캠퍼스(분교) 학부
ValueCountFrequency (%)
학부 402
43.5%
중앙대학교 8
 
0.9%
상명대학교(본교 6
 
0.6%
차의과학대학교(본교 6
 
0.6%
동아방송예술대학교(본교 5
 
0.5%
삼육보건대학교 4
 
0.4%
서울시립대학교(본교 4
 
0.4%
가천대학교(글로벌캠퍼스 4
 
0.4%
경희대학교(서울캠퍼스 4
 
0.4%
한국체육대학교(본교 4
 
0.4%
Other values (177) 478
51.7%
2023-12-12T15:35:32.102336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 969
15.1%
학 940
14.6%
대 539
 
8.4%
( 488
 
7.6%
) 488
 
7.6%
부 436
 
6.8%
본 432
 
6.7%
416
 
6.5%
한 65
 
1.0%
국 56
 
0.9%
Other values (149) 1592
24.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5029
78.3%
Open Punctuation 488
 
7.6%
Close Punctuation 488
 
7.6%
Space Separator 416
 
6.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 969
19.3%
학 940
18.7%
대 539
 
10.7%
부 436
 
8.7%
본 432
 
8.6%
한 65
 
1.3%
국 56
 
1.1%
서 55
 
1.1%
스 50
 
1.0%
퍼 50
 
1.0%
Other values (146) 1437
28.6%
Open Punctuation
ValueCountFrequency (%)
( 488
100.0%
Close Punctuation
ValueCountFrequency (%)
) 488
100.0%
Space Separator
ValueCountFrequency (%)
416
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5029
78.3%
Common 1392
 
21.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 969
19.3%
학 940
18.7%
대 539
 
10.7%
부 436
 
8.7%
본 432
 
8.6%
한 65
 
1.3%
국 56
 
1.1%
서 55
 
1.1%
스 50
 
1.0%
퍼 50
 
1.0%
Other values (146) 1437
28.6%
Common
ValueCountFrequency (%)
( 488
35.1%
) 488
35.1%
416
29.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5029
78.3%
ASCII 1392
 
21.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 969
19.3%
학 940
18.7%
대 539
 
10.7%
부 436
 
8.7%
본 432
 
8.6%
한 65
 
1.3%
국 56
 
1.1%
서 55
 
1.1%
스 50
 
1.0%
퍼 50
 
1.0%
Other values (146) 1437
28.6%
ASCII
ValueCountFrequency (%)
( 488
35.1%
) 488
35.1%
416
29.9%

이자발생일자
Date

Distinct50
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size4.1 KiB
Minimum2022-03-12 00:00:00
Maximum2023-02-28 00:00:00
2023-12-12T15:35:32.304590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:35:32.456939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

이자수익금액(원)
Real number (ℝ)

Distinct504
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean53557.183
Minimum160
Maximum3780752
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.6 KiB
2023-12-12T15:35:32.604583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum160
5-th percentile1070.8
Q16010
median14308
Q336304
95-th percentile138397.8
Maximum3780752
Range3780592
Interquartile range (IQR)30294

Descriptive statistics

Standard deviation265447.68
Coefficient of variation (CV)4.9563414
Kurtosis141.63406
Mean53557.183
Median Absolute Deviation (MAD)10866
Skewness11.57899
Sum27260606
Variance7.0462472 × 1010
MonotonicityNot monotonic
2023-12-12T15:35:32.745132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5864 2
 
0.4%
21479 2
 
0.4%
8041 2
 
0.4%
10720 2
 
0.4%
14420 2
 
0.4%
59864 1
 
0.2%
2001 1
 
0.2%
48106 1
 
0.2%
32898 1
 
0.2%
73570 1
 
0.2%
Other values (494) 494
97.1%
ValueCountFrequency (%)
160 1
0.2%
240 1
0.2%
250 1
0.2%
251 1
0.2%
276 1
0.2%
303 1
0.2%
353 1
0.2%
379 1
0.2%
380 1
0.2%
397 1
0.2%
ValueCountFrequency (%)
3780752 1
0.2%
3287404 1
0.2%
2690799 1
0.2%
1822032 1
0.2%
504708 1
0.2%
247433 1
0.2%
247262 1
0.2%
208106 1
0.2%
202308 1
0.2%
202127 1
0.2%

Interactions

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

Correlations

2023-12-12T15:35:32.855440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
학기이자발생일자이자수익금액(원)
학기1.0001.0000.000
이자발생일자1.0001.0000.000
이자수익금액(원)0.0000.0001.000
2023-12-12T15:35:32.927307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이자수익금액(원)학기
이자수익금액(원)1.0000.000
학기0.0001.000

Missing values

2023-12-12T15:35:30.783262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:35:30.893365image/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교사대생튜터링장학사업20222한남대학교(본교) 학부2022-12-1059864
1교사대생튜터링장학사업20221한남대학교(본교) 학부2022-06-1157938
2교사대생튜터링장학사업20222연세대학교(본교) 학부2022-12-1769442
3교사대생튜터링장학사업20222연세대학교 미래캠퍼스(분교) 학부2022-12-1752759
4교사대생튜터링장학사업20222연세대학교 미래캠퍼스(분교) 학부2022-09-1763852
5교사대생튜터링장학사업20221연세대학교 미래캠퍼스(분교) 학부2022-06-1858144
6교사대생튜터링장학사업20221연세대학교 미래캠퍼스(분교) 학부2022-03-1955665
7교사대생튜터링장학사업20222연세대학교(본교) 학부2022-09-1734708
8교사대생튜터링장학사업20221연세대학교(본교) 학부2022-06-1825175
9교사대생튜터링장학사업20222서울교육대학교(본교) 학부2022-12-311087
상품명연도학기대학명이자발생일자이자수익금액(원)
499교사대생튜터링장학사업20221대진대학교(본교) 학부2022-06-1111327
500교사대생튜터링장학사업20221동의대학교(본교) 학부2022-06-1160856
501교사대생튜터링장학사업20221울산대학교(본교) 학부2022-05-238504
502교사대생튜터링장학사업20221강서대학교(본교) 학부2022-03-193173
503교사대생튜터링장학사업20221선린대학교(본교)2022-03-27250
504교사대생튜터링장학사업20221중앙대학교 안성캠퍼스 학부2022-03-196103
505교사대생튜터링장학사업20221한양대학교(에리카캠퍼스) 학부2022-03-199535
506교사대생튜터링장학사업20221한라대학교(본교) 학부2022-03-195864
507교사대생튜터링장학사업20221대진대학교(본교) 학부2022-03-127234
508교사대생튜터링장학사업20221충청대학교(본교)2022-06-27433