Overview

Dataset statistics

Number of variables5
Number of observations2663
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory112.0 KiB
Average record size in memory43.0 B

Variable types

DateTime1
Categorical2
Numeric2

Dataset

Description한국무역보험공사의 2022년 리보 금리 이력을 기준 일자, 통화코드, 리보 기준 기간코드, 금리, 증감금리로 제시한 파일 데이터 자료입니다.
URLhttps://www.data.go.kr/data/15064301/fileData.do

Alerts

금리 is highly overall correlated with 통화코드High correlation
통화코드 is highly overall correlated with 금리High correlation
증감금리 has 493 (18.5%) zerosZeros

Reproduction

Analysis started2023-12-12 13:13:15.863330
Analysis finished2023-12-12 13:13:16.684791
Duration0.82 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준일자
Date

Distinct247
Distinct (%)9.3%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
Minimum2022-01-04 00:00:00
Maximum2022-12-30 00:00:00
2023-12-12T22:13:16.764709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:13:16.930731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

통화코드
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
USD
1203 
GBP
741 
JPY
719 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowGBP
2nd rowGBP
3rd rowGBP
4th rowUSD
5th rowGBP

Common Values

ValueCountFrequency (%)
USD 1203
45.2%
GBP 741
27.8%
JPY 719
27.0%

Length

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

Common Values (Plot)

2023-12-12T22:13:17.182410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
usd 1203
45.2%
gbp 741
27.8%
jpy 719
27.0%

리보기준기간코드
Categorical

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
206
737 
201
730 
203
721 
212
246 
1
229 

Length

Max length3
Median length3
Mean length2.8280135
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row201
2nd row203
3rd row206
4th row212
5th row203

Common Values

ValueCountFrequency (%)
206 737
27.7%
201 730
27.4%
203 721
27.1%
212 246
 
9.2%
1 229
 
8.6%

Length

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

Common Values (Plot)

2023-12-12T22:13:17.481377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
206 737
27.7%
201 730
27.4%
203 721
27.1%
212 246
 
9.2%
1 229
 
8.6%

금리
Real number (ℝ)

HIGH CORRELATION 

Distinct2040
Distinct (%)76.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.7027186
Minimum-0.0637
Maximum5.66643
Zeros0
Zeros (%)0.0%
Negative468
Negative (%)17.6%
Memory size23.5 KiB
2023-12-12T22:13:17.659482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-0.0637
5-th percentile-0.0561
Q10.0433
median1.2942
Q33.058785
95-th percentile4.735112
Maximum5.66643
Range5.73013
Interquartile range (IQR)3.015485

Descriptive statistics

Standard deviation1.6497418
Coefficient of variation (CV)0.96888697
Kurtosis-0.86895359
Mean1.7027186
Median Absolute Deviation (MAD)1.262
Skewness0.60443723
Sum4534.3396
Variance2.7216481
MonotonicityNot monotonic
2023-12-12T22:13:17.817833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-0.0637 65
 
2.4%
-0.06 59
 
2.2%
-0.0463 44
 
1.7%
0.04083 28
 
1.1%
-0.0206 25
 
0.9%
-0.0555 25
 
0.9%
0.0433 24
 
0.9%
-0.0175 24
 
0.9%
-0.0541 15
 
0.6%
-0.0561 13
 
0.5%
Other values (2030) 2341
87.9%
ValueCountFrequency (%)
-0.0637 65
2.4%
-0.06 59
2.2%
-0.0571 1
 
< 0.1%
-0.0563 1
 
< 0.1%
-0.0561 13
 
0.5%
-0.056 1
 
< 0.1%
-0.0555 25
 
0.9%
-0.0551 1
 
< 0.1%
-0.0545 1
 
< 0.1%
-0.0541 15
 
0.6%
ValueCountFrequency (%)
5.66643 1
< 0.1%
5.65357 1
< 0.1%
5.64029 1
< 0.1%
5.63886 1
< 0.1%
5.63286 1
< 0.1%
5.63129 1
< 0.1%
5.61214 1
< 0.1%
5.598 1
< 0.1%
5.57886 1
< 0.1%
5.57214 1
< 0.1%

증감금리
Real number (ℝ)

ZEROS 

Distinct1166
Distinct (%)43.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.012134514
Minimum-0.4779
Maximum1.0452
Zeros493
Zeros (%)18.5%
Negative693
Negative (%)26.0%
Memory size23.5 KiB
2023-12-12T22:13:18.015916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-0.4779
5-th percentile-0.02694
Q1-0.0002
median0.00123
Q30.0202
95-th percentile0.0623
Maximum1.0452
Range1.5231
Interquartile range (IQR)0.0204

Descriptive statistics

Standard deviation0.055209623
Coefficient of variation (CV)4.549801
Kurtosis128.27272
Mean0.012134514
Median Absolute Deviation (MAD)0.00717
Skewness8.1068681
Sum32.31421
Variance0.0030481024
MonotonicityNot monotonic
2023-12-12T22:13:18.194009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 493
 
18.5%
-0.0012 18
 
0.7%
-0.0001 18
 
0.7%
-0.0006 17
 
0.6%
-0.0002 14
 
0.5%
-0.0005 12
 
0.5%
-0.0018 12
 
0.5%
-0.0007 12
 
0.5%
-0.0014 11
 
0.4%
0.001 11
 
0.4%
Other values (1156) 2045
76.8%
ValueCountFrequency (%)
-0.4779 1
< 0.1%
-0.3396 1
< 0.1%
-0.2722 1
< 0.1%
-0.2605 1
< 0.1%
-0.2301 1
< 0.1%
-0.2046 1
< 0.1%
-0.18 1
< 0.1%
-0.16 1
< 0.1%
-0.1571 1
< 0.1%
-0.1542 1
< 0.1%
ValueCountFrequency (%)
1.0452 1
< 0.1%
0.9501 1
< 0.1%
0.752 1
< 0.1%
0.75015 1
< 0.1%
0.74 1
< 0.1%
0.6555 1
< 0.1%
0.50243 1
< 0.1%
0.48485 1
< 0.1%
0.36443 1
< 0.1%
0.32407 1
< 0.1%

Interactions

2023-12-12T22:13:16.283148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:13:16.076798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:13:16.404059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:13:16.185359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:13:18.312523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통화코드리보기준기간코드금리증감금리
통화코드1.0000.4300.7470.203
리보기준기간코드0.4301.0000.5290.329
금리0.7470.5291.0000.270
증감금리0.2030.3290.2701.000
2023-12-12T22:13:18.424822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
리보기준기간코드통화코드
리보기준기간코드1.0000.361
통화코드0.3611.000
2023-12-12T22:13:18.536701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
금리증감금리통화코드리보기준기간코드
금리1.0000.2610.6160.247
증감금리0.2611.0000.1230.142
통화코드0.6160.1231.0000.361
리보기준기간코드0.2470.1420.3611.000

Missing values

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

기준일자통화코드리보기준기간코드금리증감금리
02022-01-04GBP2010.2350.04825
12022-01-04GBP2030.47820.21595
22022-01-04GBP2060.79770.32407
32022-01-04USD2120.6030.01987
42022-01-05GBP2030.4767-0.0015
52022-01-05JPY201-0.06370.0
62022-01-05USD2030.225570.00957
72022-01-07USD10.07271-0.0014
82022-01-07USD2060.376430.00986
92022-01-10USD2010.104-0.0012
기준일자통화코드리보기준기간코드금리증감금리
26532022-12-16USD2125.478860.01157
26542022-11-21JPY203-0.048-0.0009
26552022-11-30USD13.823140.00571
26562022-12-07JPY201-0.060.0
26572022-12-06GBP2033.72390.0144
26582022-12-12GBP2033.79610.0406
26592022-12-13JPY203-0.04960.0
26602022-12-13USD2014.317860.02572
26612022-12-16JPY203-0.04520.00061
26622022-12-16USD2065.186860.03457