Overview

Dataset statistics

Number of variables7
Number of observations77
Missing cells24
Missing cells (%)4.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory59.7 B

Variable types

Categorical5
Numeric2

Dataset

Description한국사학진흥재단 대학재정정보시스템 환율관리목록(고시기준일, 국가 , 학교/교육원 구분, 미화환산율, 매매기준율, 입력일시, 최종변경일시) 정보
URLhttps://www.data.go.kr/data/15120211/fileData.do

Alerts

입력일시 is highly overall correlated with 고시기준일High 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 미화환산율High correlation
국가 is highly overall correlated with 미화환산율High correlation
학교/교육원 구분 is highly overall correlated with 최종변경일시High correlation
최종변경일시 is highly overall correlated with 고시기준일 and 1 other fieldsHigh correlation
최종변경일시 is highly imbalanced (55.0%)Imbalance
매매기준율 has 24 (31.2%) missing valuesMissing

Reproduction

Analysis started2023-12-12 06:47:13.168023
Analysis finished2023-12-12 06:47:14.230196
Duration1.06 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고시기준일
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size748.0 B
2022-12-30
28 
2021-12-31
25 
2022-02-28
13 
2023-02-28
11 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-02-28
2nd row2023-02-28
3rd row2023-02-28
4th row2023-02-28
5th row2023-02-28

Common Values

ValueCountFrequency (%)
2022-12-30 28
36.4%
2021-12-31 25
32.5%
2022-02-28 13
16.9%
2023-02-28 11
 
14.3%

Length

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

Common Values (Plot)

2023-12-12T15:47:14.451541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-12-30 28
36.4%
2021-12-31 25
32.5%
2022-02-28 13
16.9%
2023-02-28 11
 
14.3%

국가
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)33.8%
Missing0
Missing (%)0.0%
Memory size748.0 B
태국
6 
베트남
6 
말레이시아
6 
일본
6 
영국
 
4
Other values (21)
49 

Length

Max length7
Median length6
Mean length3.3246753
Min length2

Unique

Unique6 ?
Unique (%)7.8%

Sample

1st row태국
2nd row대만
3rd row중국
4th row베트남
5th row사우디아라비아

Common Values

ValueCountFrequency (%)
태국 6
 
7.8%
베트남 6
 
7.8%
말레이시아 6
 
7.8%
일본 6
 
7.8%
영국 4
 
5.2%
대만 4
 
5.2%
러시아 4
 
5.2%
미국 4
 
5.2%
인도네시아 4
 
5.2%
싱가포르 4
 
5.2%
Other values (16) 29
37.7%

Length

2023-12-12T15:47:14.579995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
태국 6
 
7.8%
말레이시아 6
 
7.8%
일본 6
 
7.8%
베트남 6
 
7.8%
영국 4
 
5.2%
대만 4
 
5.2%
러시아 4
 
5.2%
미국 4
 
5.2%
인도네시아 4
 
5.2%
싱가포르 4
 
5.2%
Other values (16) 29
37.7%

학교/교육원 구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size748.0 B
학교
49 
교육원
28 

Length

Max length3
Median length2
Mean length2.3636364
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row학교
2nd row학교
3rd row학교
4th row학교
5th row학교

Common Values

ValueCountFrequency (%)
학교 49
63.6%
교육원 28
36.4%

Length

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

Common Values (Plot)

2023-12-12T15:47:14.864104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
학교 49
63.6%
교육원 28
36.4%

미화환산율
Real number (ℝ)

HIGH CORRELATION 

Distinct60
Distinct (%)77.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.29881927
Minimum4.2 × 10-5
Maximum1.3498
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size825.0 B
2023-12-12T15:47:14.981816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4.2 × 10-5
5-th percentile4.4 × 10-5
Q10.008685
median0.0637
Q30.6814
95-th percentile1.0704
Maximum1.3498
Range1.349758
Interquartile range (IQR)0.672715

Descriptive statistics

Standard deviation0.39335362
Coefficient of variation (CV)1.3163596
Kurtosis-0.13916012
Mean0.29881927
Median Absolute Deviation (MAD)0.063658
Skewness1.1476066
Sum23.009084
Variance0.15472707
MonotonicityNot monotonic
2023-12-12T15:47:15.153857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.0 5
 
6.5%
4.2e-05 3
 
3.9%
0.0136 2
 
2.6%
0.00907 2
 
2.6%
0.227 2
 
2.6%
0.0289 2
 
2.6%
0.0133 2
 
2.6%
1.0704 2
 
2.6%
4.4e-05 2
 
2.6%
0.007626 2
 
2.6%
Other values (50) 53
68.8%
ValueCountFrequency (%)
4.2e-05 3
3.9%
4.4e-05 2
2.6%
6.6e-05 1
 
1.3%
7e-05 1
 
1.3%
0.0001 1
 
1.3%
0.0002 1
 
1.3%
0.000361 1
 
1.3%
0.0022 1
 
1.3%
0.0023 1
 
1.3%
0.0044 1
 
1.3%
ValueCountFrequency (%)
1.3498 1
 
1.3%
1.2097 1
 
1.3%
1.1325 1
 
1.3%
1.0704 2
 
2.6%
1.0 5
6.5%
0.8685 1
 
1.3%
0.7859 1
 
1.3%
0.7462 1
 
1.3%
0.7447 1
 
1.3%
0.7411 1
 
1.3%

매매기준율
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct45
Distinct (%)84.9%
Missing24
Missing (%)31.2%
Infinite0
Infinite (%)0.0%
Mean563.28642
Minimum0.11
Maximum8882.24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size825.0 B
2023-12-12T15:47:15.345468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.11
5-th percentile2.038
Q117.13
median166.89
Q3942.5
95-th percentile1351.92
Maximum8882.24
Range8882.13
Interquartile range (IQR)925.37

Descriptive statistics

Standard deviation1261.2956
Coefficient of variation (CV)2.2391728
Kurtosis37.704574
Mean563.28642
Median Absolute Deviation (MAD)161.36
Skewness5.7257579
Sum29854.18
Variance1590866.6
MonotonicityNot monotonic
2023-12-12T15:47:15.527458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
963.2 2
 
2.6%
1190.5 2
 
2.6%
286.72 2
 
2.6%
5.35 2
 
2.6%
1351.92 2
 
2.6%
17.13 2
 
2.6%
36.48 2
 
2.6%
166.89 2
 
2.6%
317.09 1
 
1.3%
5.21 1
 
1.3%
Other values (35) 35
45.5%
(Missing) 24
31.2%
ValueCountFrequency (%)
0.11 1
1.3%
0.31 1
1.3%
1.0 1
1.3%
2.73 1
1.3%
5.21 1
1.3%
5.35 2
2.6%
5.53 1
1.3%
8.13 1
1.3%
8.37 1
1.3%
8.62 1
1.3%
ValueCountFrequency (%)
8882.24 1
1.3%
1527.91 1
1.3%
1351.92 2
2.6%
1263.0 1
1.3%
1204.5 1
1.3%
1190.5 2
2.6%
1034.0 1
1.3%
975.54 1
1.3%
963.2 2
2.6%
961.79 1
1.3%

입력일시
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)11.7%
Missing0
Missing (%)0.0%
Memory size748.0 B
2023-02-04
28 
2022-01-11
25 
2023-07-07
9 
2022-05-23
8 
2022-05-12
3 
Other values (4)
4 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique4 ?
Unique (%)5.2%

Sample

1st row2023-07-13
2nd row2023-07-07
3rd row2023-07-07
4th row2023-07-07
5th row2023-07-07

Common Values

ValueCountFrequency (%)
2023-02-04 28
36.4%
2022-01-11 25
32.5%
2023-07-07 9
 
11.7%
2022-05-23 8
 
10.4%
2022-05-12 3
 
3.9%
2023-07-13 1
 
1.3%
2022-08-10 1
 
1.3%
2022-07-25 1
 
1.3%
2023-07-17 1
 
1.3%

Length

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

Common Values (Plot)

2023-12-12T15:47:15.821838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-02-04 28
36.4%
2022-01-11 25
32.5%
2023-07-07 9
 
11.7%
2022-05-23 8
 
10.4%
2022-05-12 3
 
3.9%
2023-07-13 1
 
1.3%
2022-08-10 1
 
1.3%
2022-07-25 1
 
1.3%
2023-07-17 1
 
1.3%

최종변경일시
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct9
Distinct (%)11.7%
Missing0
Missing (%)0.0%
Memory size748.0 B
<NA>
59 
2023-06-27
 
4
2022-03-23
 
4
2023-07-17
 
3
2023-07-07
 
3
Other values (4)
 
4

Length

Max length10
Median length4
Mean length5.4025974
Min length4

Unique

Unique4 ?
Unique (%)5.2%

Sample

1st row2023-07-17
2nd row<NA>
3rd row2023-07-07
4th row<NA>
5th row2023-07-17

Common Values

ValueCountFrequency (%)
<NA> 59
76.6%
2023-06-27 4
 
5.2%
2022-03-23 4
 
5.2%
2023-07-17 3
 
3.9%
2023-07-07 3
 
3.9%
2022-01-11 1
 
1.3%
2022-08-10 1
 
1.3%
2022-05-22 1
 
1.3%
2022-01-17 1
 
1.3%

Length

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

Common Values (Plot)

2023-12-12T15:47:16.227108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 59
76.6%
2023-06-27 4
 
5.2%
2022-03-23 4
 
5.2%
2023-07-17 3
 
3.9%
2023-07-07 3
 
3.9%
2022-01-11 1
 
1.3%
2022-08-10 1
 
1.3%
2022-05-22 1
 
1.3%
2022-01-17 1
 
1.3%

Interactions

2023-12-12T15:47:13.792618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:47:13.560552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:47:13.897754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:47:13.689065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:47:16.352587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고시기준일국가학교/교육원 구분미화환산율매매기준율입력일시최종변경일시
고시기준일1.0000.0000.6790.0000.0671.0000.997
국가0.0001.0000.6860.8900.8230.7990.751
학교/교육원 구분0.6790.6861.0000.3740.1140.4160.971
미화환산율0.0000.8900.3741.0000.6420.0000.000
매매기준율0.0670.8230.1140.6421.0000.0000.000
입력일시1.0000.7990.4160.0000.0001.0000.760
최종변경일시0.9970.7510.9710.0000.0000.7601.000
2023-12-12T15:47:16.516893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
학교/교육원 구분최종변경일시입력일시국가고시기준일
학교/교육원 구분1.0000.6680.3950.4540.472
최종변경일시0.6681.0000.4850.1860.776
입력일시0.3950.4851.0000.3880.965
국가0.4540.1860.3881.0000.000
고시기준일0.4720.7760.9650.0001.000
2023-12-12T15:47:16.667108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
미화환산율매매기준율고시기준일국가학교/교육원 구분입력일시최종변경일시
미화환산율1.0000.7840.0000.5350.2680.0000.000
매매기준율0.7841.0000.0530.4280.1840.0000.000
고시기준일0.0000.0531.0000.0000.4720.9650.776
국가0.5350.4280.0001.0000.4540.3880.186
학교/교육원 구분0.2680.1840.4720.4541.0000.3950.668
입력일시0.0000.0000.9650.3880.3951.0000.485
최종변경일시0.0000.0000.7760.1860.6680.4851.000

Missing values

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

고시기준일국가학교/교육원 구분미화환산율매매기준율입력일시최종변경일시
02023-02-28태국학교0.028837.712023-07-132023-07-17
12023-02-28대만학교0.032742.872023-07-07<NA>
22023-02-28중국학교0.1453166.892023-07-072023-07-07
32023-02-28베트남학교0.0000425.532023-07-07<NA>
42023-02-28사우디아라비아학교0.2665349.12023-07-072023-07-17
52023-02-28싱가포르학교0.7447975.542023-07-07<NA>
62023-02-28말레이시아학교0.2236292.92023-07-07<NA>
72023-02-28인도네시아학교0.0000668.622023-07-07<NA>
82021-12-31사우디아라비아학교0.2664317.092022-01-11<NA>
92022-02-28사우디아라비아학교0.2665<NA>2022-05-23<NA>
고시기준일국가학교/교육원 구분미화환산율매매기준율입력일시최종변경일시
672021-12-31일본교육원0.008685<NA>2022-01-11<NA>
682021-12-31카자흐스탄교육원0.0023<NA>2022-01-11<NA>
692021-12-31캐나다교육원0.7859<NA>2022-01-112022-01-17
702021-12-31태국교육원0.0301<NA>2022-01-11<NA>
712021-12-31호주교육원0.7264<NA>2022-01-112022-03-23
722021-12-31독일교육원1.1325<NA>2022-01-112022-03-23
732021-12-31일본학교0.86851034.02022-01-11<NA>
742023-02-28영국학교0.1274166.892023-07-07<NA>
752023-02-28중국(홍콩)학교1.01.02023-07-172023-07-17
762023-02-28일본학교0.007342961.792023-07-07<NA>