Overview

Dataset statistics

Number of variables3
Number of observations372
Missing cells0
Missing cells (%)0.0%
Duplicate rows19
Duplicate rows (%)5.1%
Total size in memory9.2 KiB
Average record size in memory25.4 B

Variable types

DateTime1
Categorical1
Numeric1

Dataset

DescriptionCIRR 금리 이력입니다.
Author한국무역보험공사
URLhttps://www.data.go.kr/data/15064227/fileData.do

Alerts

Dataset has 19 (5.1%) duplicate rowsDuplicates
금리 is highly overall correlated with 통화코드High correlation
통화코드 is highly overall correlated with 금리High correlation

Reproduction

Analysis started2023-12-12 15:18:49.805062
Analysis finished2023-12-12 15:18:50.253944
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준일자
Date

Distinct12
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
Minimum2019-01-15 00:00:00
Maximum2019-12-15 00:00:00
2023-12-13T00:18:50.323599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:18:50.458827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

통화코드
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
USD
36 
CHF
36 
CAD
36 
GBP
36 
DKK
36 
Other values (10)
192 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowUSD
2nd rowCHF
3rd rowCAD
4th rowUSD
5th rowCAD

Common Values

ValueCountFrequency (%)
USD 36
9.7%
CHF 36
9.7%
CAD 36
9.7%
GBP 36
9.7%
DKK 36
9.7%
EUR 36
9.7%
JPY 36
9.7%
SEK 36
9.7%
NOK 12
 
3.2%
PLN 12
 
3.2%
Other values (5) 60
16.1%

Length

2023-12-13T00:18:50.606254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
usd 36
9.7%
chf 36
9.7%
cad 36
9.7%
gbp 36
9.7%
dkk 36
9.7%
eur 36
9.7%
jpy 36
9.7%
sek 36
9.7%
nok 12
 
3.2%
pln 12
 
3.2%
Other values (5) 60
16.1%

금리
Real number (ℝ)

HIGH CORRELATION 

Distinct162
Distinct (%)43.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.4960484
Minimum-0.16
Maximum3.61
Zeros2
Zeros (%)0.5%
Negative5
Negative (%)1.3%
Memory size3.4 KiB
2023-12-13T00:18:50.780042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-0.16
5-th percentile0.2155
Q10.5
median1.395
Q32.475
95-th percentile3.17
Maximum3.61
Range3.77
Interquartile range (IQR)1.975

Descriptive statistics

Standard deviation1.0404458
Coefficient of variation (CV)0.69546267
Kurtosis-1.396506
Mean1.4960484
Median Absolute Deviation (MAD)0.955
Skewness0.23572889
Sum556.53
Variance1.0825275
MonotonicityNot monotonic
2023-12-13T00:18:50.970096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.84 10
 
2.7%
0.79 9
 
2.4%
0.69 8
 
2.2%
0.71 6
 
1.6%
0.76 6
 
1.6%
0.49 6
 
1.6%
0.5 5
 
1.3%
0.85 5
 
1.3%
0.36 5
 
1.3%
2.44 5
 
1.3%
Other values (152) 307
82.5%
ValueCountFrequency (%)
-0.16 1
0.3%
-0.14 1
0.3%
-0.1 1
0.3%
-0.01 2
0.5%
0.0 2
0.5%
0.09 2
0.5%
0.1 1
0.3%
0.12 1
0.3%
0.13 2
0.5%
0.14 1
0.3%
ValueCountFrequency (%)
3.61 2
0.5%
3.54 2
0.5%
3.52 2
0.5%
3.47 1
0.3%
3.43 2
0.5%
3.37 2
0.5%
3.33 2
0.5%
3.31 2
0.5%
3.23 2
0.5%
3.2 1
0.3%

Interactions

2023-12-13T00:18:49.913999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:18:51.099571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자통화코드금리
기준일자1.0000.0000.330
통화코드0.0001.0000.879
금리0.3300.8791.000
2023-12-13T00:18:51.195414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
금리통화코드
금리1.0000.567
통화코드0.5671.000

Missing values

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

기준일자통화코드금리
02019-12-15USD2.61
12019-12-15CHF0.25
22019-12-15CAD2.51
32019-12-15USD2.64
42019-12-15CAD2.51
52019-12-15GBP1.49
62019-12-15USD2.74
72019-12-15GBP1.59
82019-12-15GBP1.46
92019-12-15CAD2.56
기준일자통화코드금리
3622019-11-15HUF1.7
3632019-11-15PLN2.73
3642019-11-15NOK2.25
3652019-11-15KRW2.44
3662019-11-15DKK0.36
3672019-11-15EUR0.28
3682019-11-15DKK0.28
3692019-11-15AUD1.88
3702019-11-15USD2.62
3712019-11-15JPY0.71

Duplicate rows

Most frequently occurring

기준일자통화코드금리# duplicates
22019-03-15JPY0.833
42019-04-15JPY0.843
52019-05-15JPY0.843
182019-12-15JPY0.793
02019-01-15JPY0.842
12019-02-15JPY0.842
32019-03-15USD3.372
62019-06-15CAD2.382
72019-06-15JPY0.762
82019-07-15JPY0.762