Overview

Dataset statistics

Number of variables23
Number of observations260
Missing cells381
Missing cells (%)6.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory50.4 KiB
Average record size in memory198.5 B

Variable types

Categorical11
Text3
Numeric5
DateTime3
Boolean1

Dataset

Description대학생 청소년교육지원장학금 멘토링 관련 반환 교부금 내역: 상품명, 배정년도, 배정구분, 배정학기, 대학명, 반환금액, 반환일시, 반환사유 등의 정보를 제공함
URLhttps://www.data.go.kr/data/15070076/fileData.do

Alerts

상품명 has constant value ""Constant
배정년도 has constant value ""Constant
신청일련번호 has constant value ""Constant
반환품의번호 has constant value ""Constant
반환취소일자 has constant value ""Constant
부당수급반환여부 has constant value ""Constant
배정구분 is highly imbalanced (96.4%)Imbalance
배정일련번호 is highly imbalanced (96.4%)Imbalance
배정학기 is highly imbalanced (90.9%)Imbalance
반환취소금액(원) is highly imbalanced (96.4%)Imbalance
반환취소결재상태코드 is highly imbalanced (96.4%)Imbalance
반환취소결재품의번호 is highly imbalanced (96.4%)Imbalance
반환취소일자 has 259 (99.6%) missing valuesMissing
반환승인일시 has 61 (23.5%) missing valuesMissing
장학회계전표번호 has 61 (23.5%) missing valuesMissing
장학반환번호 has unique valuesUnique
반환이자금액(원) has 53 (20.4%) zerosZeros
국고반납금액 has 27 (10.4%) zerosZeros

Reproduction

Analysis started2023-12-12 11:44:55.321676
Analysis finished2023-12-12 11:44:55.934080
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상품명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
교사대생튜터링장학사업
260 

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 (%)
교사대생튜터링장학사업 260
100.0%

Length

2023-12-12T20:44:56.031294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:44:56.193048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교사대생튜터링장학사업 260
100.0%

배정년도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2022
260 

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

Length

2023-12-12T20:44:56.353535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:44:56.511026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 260
100.0%

배정구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
정기배정
259 
추가배정
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)0.4%

Sample

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

Common Values

ValueCountFrequency (%)
정기배정 259
99.6%
추가배정 1
 
0.4%

Length

2023-12-12T20:44:56.681180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:44:56.802729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정기배정 259
99.6%
추가배정 1
 
0.4%

배정일련번호
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
1
259 
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.4%

Sample

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

Common Values

ValueCountFrequency (%)
1 259
99.6%
2 1
 
0.4%

Length

2023-12-12T20:44:56.924622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:44:57.057516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 259
99.6%
2 1
 
0.4%

배정학기
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2
257 
1
 
3

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 257
98.8%
1 3
 
1.2%

Length

2023-12-12T20:44:57.186263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:44:57.321328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 257
98.8%
1 3
 
1.2%

대학명
Text

Distinct181
Distinct (%)69.6%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2023-12-12T20:44:57.514837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length12
Mean length12.45
Min length5

Characters and Unicode

Total characters3237
Distinct characters157
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

Unique127 ?
Unique (%)48.8%

Sample

1st row부산대학교(본교) 학부
2nd row부산대학교(본교) 학부
3rd row부산대학교(본교) 학부
4th row연세대학교 미래캠퍼스(분교) 학부
5th row한남대학교(본교) 학부
ValueCountFrequency (%)
학부 212
44.3%
연세대학교(본교 7
 
1.5%
한밭대학교(본교 4
 
0.8%
을지대학교(성남캠퍼스 4
 
0.8%
중앙대학교 4
 
0.8%
순천향대학교(본교 4
 
0.8%
용인대학교(본교 4
 
0.8%
울산대학교(본교 4
 
0.8%
제주대학교(본교 3
 
0.6%
중원대학교(본교 3
 
0.6%
Other values (175) 230
48.0%
2023-12-12T20:44:57.973415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 495
15.3%
학 485
15.0%
대 272
 
8.4%
( 248
 
7.7%
) 248
 
7.7%
부 228
 
7.0%
본 225
 
7.0%
219
 
6.8%
한 34
 
1.1%
서 25
 
0.8%
Other values (147) 758
23.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2522
77.9%
Open Punctuation 248
 
7.7%
Close Punctuation 248
 
7.7%
Space Separator 219
 
6.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 495
19.6%
학 485
19.2%
대 272
 
10.8%
부 228
 
9.0%
본 225
 
8.9%
한 34
 
1.3%
서 25
 
1.0%
스 24
 
1.0%
퍼 24
 
1.0%
캠 24
 
1.0%
Other values (144) 686
27.2%
Open Punctuation
ValueCountFrequency (%)
( 248
100.0%
Close Punctuation
ValueCountFrequency (%)
) 248
100.0%
Space Separator
ValueCountFrequency (%)
219
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2522
77.9%
Common 715
 
22.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 495
19.6%
학 485
19.2%
대 272
 
10.8%
부 228
 
9.0%
본 225
 
8.9%
한 34
 
1.3%
서 25
 
1.0%
스 24
 
1.0%
퍼 24
 
1.0%
캠 24
 
1.0%
Other values (144) 686
27.2%
Common
ValueCountFrequency (%)
( 248
34.7%
) 248
34.7%
219
30.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2522
77.9%
ASCII 715
 
22.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 495
19.6%
학 485
19.2%
대 272
 
10.8%
부 228
 
9.0%
본 225
 
8.9%
한 34
 
1.3%
서 25
 
1.0%
스 24
 
1.0%
퍼 24
 
1.0%
캠 24
 
1.0%
Other values (144) 686
27.2%
ASCII
ValueCountFrequency (%)
( 248
34.7%
) 248
34.7%
219
30.6%

신청일련번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
1
260 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 260
100.0%

Length

2023-12-12T20:44:58.184386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:44:58.317214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 260
100.0%

반환일련번호
Real number (ℝ)

Distinct257
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.53462
Minimum1
Maximum257
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2023-12-12T20:44:58.560202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.95
Q162.75
median127.5
Q3192.25
95-th percentile244.05
Maximum257
Range256
Interquartile range (IQR)129.5

Descriptive statistics

Standard deviation75.141018
Coefficient of variation (CV)0.58918136
Kurtosis-1.2034065
Mean127.53462
Median Absolute Deviation (MAD)65
Skewness0.00260149
Sum33159
Variance5646.1725
MonotonicityNot monotonic
2023-12-12T20:44:58.823862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 2
 
0.8%
2 2
 
0.8%
3 2
 
0.8%
257 1
 
0.4%
88 1
 
0.4%
83 1
 
0.4%
84 1
 
0.4%
85 1
 
0.4%
86 1
 
0.4%
87 1
 
0.4%
Other values (247) 247
95.0%
ValueCountFrequency (%)
1 2
0.8%
2 2
0.8%
3 2
0.8%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
257 1
0.4%
256 1
0.4%
255 1
0.4%
254 1
0.4%
253 1
0.4%
252 1
0.4%
251 1
0.4%
250 1
0.4%
249 1
0.4%
248 1
0.4%

반환금액(원)
Real number (ℝ)

Distinct219
Distinct (%)84.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean75449085
Minimum1044
Maximum9.919256 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2023-12-12T20:44:59.023301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1044
5-th percentile17745.95
Q15611315.8
median27475996
Q383657463
95-th percentile2.4602196 × 108
Maximum9.919256 × 108
Range9.9192456 × 108
Interquartile range (IQR)78046147

Descriptive statistics

Standard deviation1.4570421 × 108
Coefficient of variation (CV)1.9311594
Kurtosis19.137118
Mean75449085
Median Absolute Deviation (MAD)26105938
Skewness4.0572741
Sum1.9616762 × 1010
Variance2.1229716 × 1016
MonotonicityNot monotonic
2023-12-12T20:44:59.266925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
27207500 3
 
1.2%
129325 3
 
1.2%
33202405 3
 
1.2%
136112500 3
 
1.2%
744412748 2
 
0.8%
52962254 2
 
0.8%
13127413 2
 
0.8%
1994683 2
 
0.8%
32132689 2
 
0.8%
27475996 2
 
0.8%
Other values (209) 236
90.8%
ValueCountFrequency (%)
1044 1
0.4%
1100 1
0.4%
4158 2
0.8%
5456 1
0.4%
6269 1
0.4%
7572 1
0.4%
10000 2
0.8%
10903 1
0.4%
11824 2
0.8%
12102 1
0.4%
ValueCountFrequency (%)
991925603 1
0.4%
991925585 1
0.4%
910070263 1
0.4%
744412748 2
0.8%
573300000 2
0.8%
502031407 1
0.4%
500000000 1
0.4%
440654244 1
0.4%
415452933 1
0.4%
275542201 2
0.8%

반환일시
Date

Distinct32
Distinct (%)12.3%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
Minimum2022-04-22 00:00:00
Maximum2023-04-06 00:00:00
2023-12-12T20:44:59.510584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:44:59.732715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)

반환품의번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
0
260 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 260
100.0%

Length

2023-12-12T20:44:59.947249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:00.098808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 260
100.0%

반환사유
Text

Distinct234
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2023-12-12T20:45:00.341721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length48
Mean length38.384615
Min length9

Characters and Unicode

Total characters9980
Distinct characters115
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique216 ?
Unique (%)83.1%

Sample

1st row이자: 257800, 교사대생 등 대학생 튜터링 보조금 발생 이자 반납
2nd row이자: 0, 교사대생 등 대학생 튜터링 보조금 발생 이자 반납
3rd row이자: 0, 교사대생 등 대학생 튜터링 보조금 집행잔액 반납
4th row이자: 230420, 2022년도 교사대생 등 대학생 튜터링 사업 잔액 및 이자 반납
5th row이자: 117802, 이자반납
ValueCountFrequency (%)
이자 429
17.0%
잔액 195
 
7.7%
사업 179
 
7.1%
반납 175
 
6.9%
튜터링 175
 
6.9%
및 171
 
6.8%
등 162
 
6.4%
대학생 162
 
6.4%
2022년도 158
 
6.3%
교사대생 106
 
4.2%
Other values (276) 613
24.3%
2023-12-12T20:45:00.823532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2266
22.7%
2 739
 
7.4%
자 455
 
4.6%
이 454
 
4.5%
사 388
 
3.9%
0 370
 
3.7%
생 366
 
3.7%
대 359
 
3.6%
: 260
 
2.6%
, 260
 
2.6%
Other values (105) 4063
40.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5199
52.1%
Space Separator 2266
22.7%
Decimal Number 1918
 
19.2%
Other Punctuation 585
 
5.9%
Lowercase Letter 8
 
0.1%
Open Punctuation 2
 
< 0.1%
Close Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
자 455
 
8.8%
이 454
 
8.7%
사 388
 
7.5%
생 366
 
7.0%
대 359
 
6.9%
반 242
 
4.7%
교 225
 
4.3%
액 208
 
4.0%
잔 207
 
4.0%
학 201
 
3.9%
Other values (83) 2094
40.3%
Decimal Number
ValueCountFrequency (%)
2 739
38.5%
0 370
19.3%
1 133
 
6.9%
3 131
 
6.8%
4 105
 
5.5%
5 95
 
5.0%
9 95
 
5.0%
6 94
 
4.9%
7 79
 
4.1%
8 77
 
4.0%
Other Punctuation
ValueCountFrequency (%)
: 260
44.4%
, 260
44.4%
· 43
 
7.4%
. 20
 
3.4%
' 1
 
0.2%
? 1
 
0.2%
Lowercase Letter
ValueCountFrequency (%)
t 4
50.0%
s 2
25.0%
e 2
25.0%
Space Separator
ValueCountFrequency (%)
2266
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5199
52.1%
Common 4773
47.8%
Latin 8
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
자 455
 
8.8%
이 454
 
8.7%
사 388
 
7.5%
생 366
 
7.0%
대 359
 
6.9%
반 242
 
4.7%
교 225
 
4.3%
액 208
 
4.0%
잔 207
 
4.0%
학 201
 
3.9%
Other values (83) 2094
40.3%
Common
ValueCountFrequency (%)
2266
47.5%
2 739
 
15.5%
0 370
 
7.8%
: 260
 
5.4%
, 260
 
5.4%
1 133
 
2.8%
3 131
 
2.7%
4 105
 
2.2%
5 95
 
2.0%
9 95
 
2.0%
Other values (9) 319
 
6.7%
Latin
ValueCountFrequency (%)
t 4
50.0%
s 2
25.0%
e 2
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5196
52.1%
ASCII 4738
47.5%
None 43
 
0.4%
Compat Jamo 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2266
47.8%
2 739
 
15.6%
0 370
 
7.8%
: 260
 
5.5%
, 260
 
5.5%
1 133
 
2.8%
3 131
 
2.8%
4 105
 
2.2%
5 95
 
2.0%
9 95
 
2.0%
Other values (11) 284
 
6.0%
Hangul
ValueCountFrequency (%)
자 455
 
8.8%
이 454
 
8.7%
사 388
 
7.5%
생 366
 
7.0%
대 359
 
6.9%
반 242
 
4.7%
교 225
 
4.3%
액 208
 
4.0%
잔 207
 
4.0%
학 201
 
3.9%
Other values (82) 2091
40.2%
None
ValueCountFrequency (%)
· 43
100.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 3
100.0%

장학반환번호
Text

UNIQUE 

Distinct260
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2023-12-12T20:45:01.107733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length16
Min length16

Characters and Unicode

Total characters4160
Distinct characters11
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique260 ?
Unique (%)100.0%

Sample

1st rowJ030032022202257
2nd rowJ030032022202256
3rd rowJ030032022202255
4th rowJ030032022202254
5th rowJ030032022202253
ValueCountFrequency (%)
j030032022202257 1
 
0.4%
j030032022202095 1
 
0.4%
j030032022202079 1
 
0.4%
j030032022202092 1
 
0.4%
j030032022202091 1
 
0.4%
j030032022202090 1
 
0.4%
j030032022202089 1
 
0.4%
j030032022202088 1
 
0.4%
j030032022202087 1
 
0.4%
j030032022202086 1
 
0.4%
Other values (250) 250
96.2%
2023-12-12T20:45:01.929414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 1459
35.1%
2 1412
33.9%
3 577
 
13.9%
J 260
 
6.2%
1 160
 
3.8%
4 56
 
1.3%
5 54
 
1.3%
7 46
 
1.1%
6 46
 
1.1%
9 45
 
1.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3900
93.8%
Uppercase Letter 260
 
6.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1459
37.4%
2 1412
36.2%
3 577
 
14.8%
1 160
 
4.1%
4 56
 
1.4%
5 54
 
1.4%
7 46
 
1.2%
6 46
 
1.2%
9 45
 
1.2%
8 45
 
1.2%
Uppercase Letter
ValueCountFrequency (%)
J 260
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3900
93.8%
Latin 260
 
6.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 1459
37.4%
2 1412
36.2%
3 577
 
14.8%
1 160
 
4.1%
4 56
 
1.4%
5 54
 
1.4%
7 46
 
1.2%
6 46
 
1.2%
9 45
 
1.2%
8 45
 
1.2%
Latin
ValueCountFrequency (%)
J 260
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4160
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1459
35.1%
2 1412
33.9%
3 577
 
13.9%
J 260
 
6.2%
1 160
 
3.8%
4 56
 
1.3%
5 54
 
1.3%
7 46
 
1.1%
6 46
 
1.1%
9 45
 
1.1%

반환이자금액(원)
Real number (ℝ)

ZEROS 

Distinct175
Distinct (%)67.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean117650.04
Minimum0
Maximum11580987
Zeros53
Zeros (%)20.4%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2023-12-12T20:45:02.146853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q13183.25
median34836
Q385625.5
95-th percentile299429.7
Maximum11580987
Range11580987
Interquartile range (IQR)82442.25

Descriptive statistics

Standard deviation723151.39
Coefficient of variation (CV)6.1466312
Kurtosis246.4826
Mean117650.04
Median Absolute Deviation (MAD)34836
Skewness15.50677
Sum30589010
Variance5.2294794 × 1011
MonotonicityNot monotonic
2023-12-12T20:45:02.353308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 53
 
20.4%
291439 3
 
1.2%
38750 3
 
1.2%
19396 3
 
1.2%
129325 3
 
1.2%
127405 3
 
1.2%
7572 2
 
0.8%
148835 2
 
0.8%
11824 2
 
0.8%
70263 2
 
0.8%
Other values (165) 184
70.8%
ValueCountFrequency (%)
0 53
20.4%
100 1
 
0.4%
397 1
 
0.4%
1044 1
 
0.4%
2100 1
 
0.4%
2277 2
 
0.8%
2280 1
 
0.4%
2308 1
 
0.4%
2331 1
 
0.4%
2413 2
 
0.8%
ValueCountFrequency (%)
11580987 1
0.4%
715952 1
0.4%
706853 1
0.4%
706835 1
0.4%
550248 2
0.8%
465873 1
0.4%
449570 1
0.4%
374900 1
0.4%
368849 1
0.4%
301200 2
0.8%

국고반납금액
Real number (ℝ)

ZEROS 

Distinct198
Distinct (%)76.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean75331435
Minimum0
Maximum9.9121875 × 108
Zeros27
Zeros (%)10.4%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2023-12-12T20:45:02.580411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q15446875
median27437503
Q383523438
95-th percentile2.4602196 × 108
Maximum9.9121875 × 108
Range9.9121875 × 108
Interquartile range (IQR)78076562

Descriptive statistics

Standard deviation1.4562203 × 108
Coefficient of variation (CV)1.9330845
Kurtosis19.153846
Mean75331435
Median Absolute Deviation (MAD)26093753
Skewness4.0599851
Sum1.9586173 × 1010
Variance2.1205775 × 1016
MonotonicityNot monotonic
2023-12-12T20:45:02.796000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 27
 
10.4%
136112500 4
 
1.5%
27168750 3
 
1.2%
33075000 3
 
1.2%
1331250 3
 
1.2%
140441271 2
 
0.8%
3562500 2
 
0.8%
991218750 2
 
0.8%
80736346 2
 
0.8%
153218750 2
 
0.8%
Other values (188) 210
80.8%
ValueCountFrequency (%)
0 27
10.4%
1000 1
 
0.4%
3125 1
 
0.4%
10000 2
 
0.8%
37500 2
 
0.8%
129325 1
 
0.4%
257800 1
 
0.4%
643750 1
 
0.4%
737500 1
 
0.4%
762500 1
 
0.4%
ValueCountFrequency (%)
991218750 2
0.8%
910000000 1
0.4%
744412748 1
0.4%
743862500 1
0.4%
573300000 2
0.8%
501909375 1
0.4%
500000000 1
0.4%
440625000 1
0.4%
415389030 1
0.4%
275542201 2
0.8%

반환취소일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing259
Missing (%)99.6%
Memory size2.2 KiB
Minimum2023-03-15 00:00:00
Maximum2023-03-15 00:00:00
2023-12-12T20:45:02.940835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:45:03.074309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

반환취소금액(원)
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
<NA>
259 
11824
 
1

Length

Max length5
Median length4
Mean length4.0038462
Min length4

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 259
99.6%
11824 1
 
0.4%

Length

2023-12-12T20:45:03.242196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:03.367174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 259
99.6%
11824 1
 
0.4%

반환취소결재상태코드
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
<NA>
259 
5
 
1

Length

Max length4
Median length4
Mean length3.9884615
Min length1

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 259
99.6%
5 1
 
0.4%

Length

2023-12-12T20:45:03.539883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:03.677323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 259
99.6%
5 1
 
0.4%

반환취소결재품의번호
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
<NA>
259 
20239400002
 
1

Length

Max length11
Median length4
Mean length4.0269231
Min length4

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 259
99.6%
20239400002 1
 
0.4%

Length

2023-12-12T20:45:03.834193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:03.985711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 259
99.6%
20239400002 1
 
0.4%

장학반환상태코드
Categorical

Distinct3
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2
198 
<NA>
61 
3
 
1

Length

Max length4
Median length1
Mean length1.7038462
Min length1

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row2
2nd row<NA>
3rd row2
4th row2
5th row2

Common Values

ValueCountFrequency (%)
2 198
76.2%
<NA> 61
 
23.5%
3 1
 
0.4%

Length

2023-12-12T20:45:04.157205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:04.292821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 198
76.2%
na 61
 
23.5%
3 1
 
0.4%

반환승인일시
Date

MISSING 

Distinct7
Distinct (%)3.5%
Missing61
Missing (%)23.5%
Memory size2.2 KiB
Minimum2022-05-11 00:00:00
Maximum2023-04-18 00:00:00
2023-12-12T20:45:04.403033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:45:04.527709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)

장학회계전표번호
Real number (ℝ)

MISSING 

Distinct197
Distinct (%)99.0%
Missing61
Missing (%)23.5%
Infinite0
Infinite (%)0.0%
Mean814.09548
Minimum126
Maximum930
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2023-12-12T20:45:04.713074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126
5-th percentile736.9
Q1774.5
median824
Q3880.5
95-th percentile920.1
Maximum930
Range804
Interquartile range (IQR)106

Descriptive statistics

Standard deviation110.78282
Coefficient of variation (CV)0.13608087
Kurtosis20.177754
Mean814.09548
Median Absolute Deviation (MAD)53
Skewness-3.8346083
Sum162005
Variance12272.834
MonotonicityNot monotonic
2023-12-12T20:45:04.894432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
760 2
 
0.8%
761 2
 
0.8%
866 1
 
0.4%
844 1
 
0.4%
886 1
 
0.4%
867 1
 
0.4%
860 1
 
0.4%
847 1
 
0.4%
888 1
 
0.4%
804 1
 
0.4%
Other values (187) 187
71.9%
(Missing) 61
 
23.5%
ValueCountFrequency (%)
126 1
0.4%
153 1
0.4%
216 1
0.4%
228 1
0.4%
563 1
0.4%
639 1
0.4%
640 1
0.4%
734 1
0.4%
735 1
0.4%
736 1
0.4%
ValueCountFrequency (%)
930 1
0.4%
929 1
0.4%
928 1
0.4%
927 1
0.4%
926 1
0.4%
925 1
0.4%
924 1
0.4%
923 1
0.4%
922 1
0.4%
921 1
0.4%

부당수급반환여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size392.0 B
False
260 
ValueCountFrequency (%)
False 260
100.0%
2023-12-12T20:45:05.072324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Sample

상품명배정년도배정구분배정일련번호배정학기대학명신청일련번호반환일련번호반환금액(원)반환일시반환품의번호반환사유장학반환번호반환이자금액(원)국고반납금액반환취소일자반환취소금액(원)반환취소결재상태코드반환취소결재품의번호장학반환상태코드반환승인일시장학회계전표번호부당수급반환여부
0교사대생튜터링장학사업2022정기배정12부산대학교(본교) 학부12572578002023-04-060이자: 257800, 교사대생 등 대학생 튜터링 보조금 발생 이자 반납J0300320222022572578000<NA><NA><NA><NA>22023-04-18640N
1교사대생튜터링장학사업2022정기배정12부산대학교(본교) 학부12562578002023-04-060이자: 0, 교사대생 등 대학생 튜터링 보조금 발생 이자 반납J0300320222022560257800<NA><NA><NA><NA><NA><NA><NA>N
2교사대생튜터링장학사업2022정기배정12부산대학교(본교) 학부12551657625002023-04-060이자: 0, 교사대생 등 대학생 튜터링 보조금 집행잔액 반납J0300320222022550165762500<NA><NA><NA><NA>22023-04-18639N
3교사대생튜터링장학사업2022정기배정12연세대학교 미래캠퍼스(분교) 학부12541214429202023-04-030이자: 230420, 2022년도 교사대생 등 대학생 튜터링 사업 잔액 및 이자 반납J030032022202254230420121212500<NA><NA><NA><NA>22023-04-05734N
4교사대생튜터링장학사업2022정기배정12한남대학교(본교) 학부12531178022023-03-310이자: 117802, 이자반납J0300320222022531178020<NA><NA><NA><NA>22023-04-05737N
5교사대생튜터링장학사업2022정기배정12한남대학교(본교) 학부1252375002023-03-310이자: 0, 잔여예산반납J030032022202252037500<NA><NA><NA><NA>22023-04-05736N
6교사대생튜터링장학사업2022정기배정12용인대학교(본교) 학부125156539392023-03-310이자: 291439, 2022학년도 교사대생 등 대학생 튜터링 사업 잔액J0300320222022512914395362500<NA><NA><NA><NA>22023-04-07563N
7교사대생튜터링장학사업2022정기배정12용인대학교(본교) 학부125059453782023-03-280이자: 291439, 2022학년도 교사대생등 대학생 튜터링 사업 잔액 및 이자 반납J0300320222022502914395653939<NA><NA><NA><NA><NA><NA><NA>N
8교사대생튜터링장학사업2022정기배정12용인대학교(본교) 학부124911002023-03-280이자: 100, 테스트J0300320222022491001000<NA><NA><NA><NA><NA><NA><NA>N
9교사대생튜터링장학사업2022정기배정12용인대학교(본교) 학부124856539392023-03-280이자: 291439, 2022년도 교·대생 등 대학생 튜터링 사업 잔액 및 이자 반납J0300320222022482914395362500<NA><NA><NA><NA><NA><NA><NA>N
상품명배정년도배정구분배정일련번호배정학기대학명신청일련번호반환일련번호반환금액(원)반환일시반환품의번호반환사유장학반환번호반환이자금액(원)국고반납금액반환취소일자반환취소금액(원)반환취소결재상태코드반환취소결재품의번호장학반환상태코드반환승인일시장학회계전표번호부당수급반환여부
250교사대생튜터링장학사업2022정기배정12선린대학교(본교)1710442023-02-210이자: 1044, 이자반환J03003202220200710440<NA><NA><NA><NA>22023-04-05913N
251교사대생튜터링장학사업2022정기배정12선린대학교(본교)1611125002023-02-210이자: 0, 미집행금액J03003202220200601112500<NA><NA><NA><NA>22023-04-05927N
252교사대생튜터링장학사업2022정기배정12우석대학교(본교) 학부158490302023-02-210이자: 86530, 2022년도 교·사대생 등 대학생 튜터링 사업 잔액 및 이자 반납J03003202220200586530762500<NA><NA><NA><NA>22023-04-05904N
253교사대생튜터링장학사업2022정기배정12단국대학교(천안캠퍼스)14653462023-02-200이자: 65346, 2022년도 교사대생 등 대학생 튜터링 사업 이자 반납J030032022202004653460<NA><NA><NA><NA>22023-04-05910N
254교사대생튜터링장학사업2022정기배정12단국대학교(천안캠퍼스)13366250002023-02-200이자: 0, 2022년도 교사대생 등 대학생 튜터링 사업 잔액 반납J030032022202003036625000<NA><NA><NA><NA>22023-04-05911N
255교사대생튜터링장학사업2022정기배정12한양대학교(에리카캠퍼스) 학부12415389032023-02-160이자: 63903, 2022년 교사대생투터링 사업 종료로 인한 교부금 환반J0300320222020026390341475000<NA><NA><NA><NA>22023-04-05930N
256교사대생튜터링장학사업2022정기배정12한양대학교(에리카캠퍼스) 학부114154529332023-02-160이자: 63903, 2022년도 교사대생튜터링사업 종료로 인한 교부금 잔액 반납J03003202220200163903415389030<NA><NA><NA><NA><NA><NA><NA>N
257교사대생튜터링장학사업2022정기배정11순천향대학교(본교) 학부135733000002022-04-270이자: 0, 교부금 오신청 금액 반환(2)J0300320221020030573300000<NA><NA><NA><NA>22022-05-11760N
258교사대생튜터링장학사업2022정기배정11순천향대학교(본교) 학부125733000002022-04-270이자: 0, 교부금 오신청 금액 반환(1)J0300320221020020573300000<NA><NA><NA><NA>22022-05-11761N
259교사대생튜터링장학사업2022정기배정11순천향대학교(본교) 학부111146600002022-04-220이자: 0, 교부금 오신청으로 인한 차액 반환J0300320221020010114660000<NA><NA><NA><NA><NA><NA><NA>N