Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells4698
Missing cells (%)11.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory410.2 KiB
Average record size in memory42.0 B

Variable types

Categorical1
DateTime1
Numeric2

Dataset

Description한국무역보험공사의 1995년부터 2023년까지 기준일자별 전세계 통화별 매매기준율 및 미화환산율을 나타낸 데이터입니다.
URLhttps://www.data.go.kr/data/15117590/fileData.do

Alerts

매매기준율 is highly overall correlated with 미화환산율High correlation
미화환산율 is highly overall correlated with 매매기준율High correlation
매매기준율 has 2352 (23.5%) missing valuesMissing
미화환산율 has 2346 (23.5%) missing valuesMissing
미화환산율 is highly skewed (γ1 = 61.39253646)Skewed

Reproduction

Analysis started2023-12-11 23:29:51.430340
Analysis finished2023-12-11 23:29:52.255709
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

통화코드
Categorical

Distinct43
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
SGD
 
594
JPY
 
582
BHD
 
581
KWD
 
580
AED
 
576
Other values (38)
7087 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique5 ?
Unique (%)< 0.1%

Sample

1st rowNZD
2nd rowMYR
3rd rowEUR
4th rowINR
5th rowBHD

Common Values

ValueCountFrequency (%)
SGD 594
 
5.9%
JPY 582
 
5.8%
BHD 581
 
5.8%
KWD 580
 
5.8%
AED 576
 
5.8%
SAR 574
 
5.7%
ESP 571
 
5.7%
NZD 570
 
5.7%
MYR 567
 
5.7%
FIM 555
 
5.5%
Other values (33) 4250
42.5%

Length

2023-12-12T08:29:52.600646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
sgd 594
 
5.9%
jpy 582
 
5.8%
bhd 581
 
5.8%
kwd 580
 
5.8%
aed 576
 
5.8%
sar 574
 
5.7%
esp 571
 
5.7%
nzd 570
 
5.7%
myr 567
 
5.7%
fim 555
 
5.5%
Other values (33) 4250
42.5%

기준일자
Date

Distinct4661
Distinct (%)46.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum1980-01-31 00:00:00
Maximum2001-10-08 00:00:00
2023-12-12T08:29:52.708871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:29:52.837998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

매매기준율
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct6749
Distinct (%)88.2%
Missing2352
Missing (%)23.5%
Infinite0
Infinite (%)0.0%
Mean688.34606
Minimum0
Maximum6400.79
Zeros40
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T08:29:52.973528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile14.6875
Q1148.0675
median334.215
Q3692.6175
95-th percentile2757.4395
Maximum6400.79
Range6400.79
Interquartile range (IQR)544.55

Descriptive statistics

Standard deviation912.00355
Coefficient of variation (CV)1.3249201
Kurtosis3.6223061
Mean688.34606
Median Absolute Deviation (MAD)249.44
Skewness2.0342531
Sum5264470.7
Variance831750.47
MonotonicityNot monotonic
2023-12-12T08:29:53.098375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.0 191
 
1.9%
0.0 40
 
0.4%
0.13 23
 
0.2%
0.17 12
 
0.1%
35.96 5
 
0.1%
0.18 5
 
0.1%
24.39 5
 
0.1%
28.52 5
 
0.1%
30.69 4
 
< 0.1%
26.1 4
 
< 0.1%
Other values (6739) 7354
73.5%
(Missing) 2352
 
23.5%
ValueCountFrequency (%)
0.0 40
 
0.4%
0.12 1
 
< 0.1%
0.13 23
 
0.2%
0.17 12
 
0.1%
0.18 5
 
0.1%
0.19 3
 
< 0.1%
1.0 191
1.9%
2.81 1
 
< 0.1%
2.82 1
 
< 0.1%
2.85 1
 
< 0.1%
ValueCountFrequency (%)
6400.79 1
< 0.1%
5578.34 1
< 0.1%
5386.03 1
< 0.1%
5319.32 1
< 0.1%
5302.78 1
< 0.1%
5049.18 1
< 0.1%
4876.74 1
< 0.1%
4715.13 1
< 0.1%
4626.08 1
< 0.1%
4563.62 1
< 0.1%

미화환산율
Real number (ℝ)

HIGH CORRELATION  MISSING  SKEWED 

Distinct3444
Distinct (%)45.0%
Missing2346
Missing (%)23.5%
Infinite0
Infinite (%)0.0%
Mean1.3458633
Minimum0
Maximum2108
Zeros86
Zeros (%)0.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T08:29:53.234139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.013865
Q10.1569
median0.39135
Q30.76
95-th percentile3.302305
Maximum2108
Range2108
Interquartile range (IQR)0.6031

Descriptive statistics

Standard deviation33.755127
Coefficient of variation (CV)25.080651
Kurtosis3786.6364
Mean1.3458633
Median Absolute Deviation (MAD)0.27415
Skewness61.392536
Sum10301.238
Variance1139.4086
MonotonicityNot monotonic
2023-12-12T08:29:53.359036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.2723 510
 
5.1%
0.2666 324
 
3.2%
2.6529 201
 
2.0%
2.6522 154
 
1.5%
0.2667 107
 
1.1%
2.6525 100
 
1.0%
0.0014 89
 
0.9%
0.0 86
 
0.9%
1.0 76
 
0.8%
0.1208 66
 
0.7%
Other values (3434) 5941
59.4%
(Missing) 2346
 
23.5%
ValueCountFrequency (%)
0.0 86
0.9%
0.0001 36
0.4%
0.0002 8
 
0.1%
0.0012 18
 
0.2%
0.0013 10
 
0.1%
0.0014 89
0.9%
0.0025 8
 
0.1%
0.0026 10
 
0.1%
0.0027 4
 
< 0.1%
0.0028 2
 
< 0.1%
ValueCountFrequency (%)
2108.0 1
< 0.1%
2059.0 1
< 0.1%
128.4 1
< 0.1%
111.0 1
< 0.1%
100.0 1
< 0.1%
11.0 1
< 0.1%
3.6969 1
< 0.1%
3.688 1
< 0.1%
3.6799 1
< 0.1%
3.6778 1
< 0.1%

Interactions

2023-12-12T08:29:51.862447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:29:51.677041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:29:51.951906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:29:51.778141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:29:53.445379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통화코드매매기준율미화환산율
통화코드1.0000.8410.051
매매기준율0.8411.0000.074
미화환산율0.0510.0741.000
2023-12-12T08:29:53.531652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
매매기준율미화환산율통화코드
매매기준율1.0000.9270.480
미화환산율0.9271.0000.043
통화코드0.4800.0431.000

Missing values

2023-12-12T08:29:52.047211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:29:52.128031image/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.
2023-12-12T08:29:52.212607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

통화코드기준일자매매기준율미화환산율
25766NZD1984-02-08<NA><NA>
61610MYR1988-03-22291.240.3879
22267EUR1997-06-261008.871.1365
10459INR1999-12-0726.510.023
64782BHD1992-02-292037.672.6525
9534INR1998-05-1635.410.0247
41941MYR1985-02-24327.590.3891
32262IDR1995-01-2635.480.0451
69808SAR1987-09-09214.960.2666
1976CNY2001-06-27156.930.1208
통화코드기준일자매매기준율미화환산율
64411AED1990-01-08185.410.2723
11926CNY1999-07-15129.790.1099
33818NZD1989-12-06<NA><NA>
93471JPY1999-10-071124.30.9318
39942ESP1990-06-08<NA><NA>
4990CNY1991-01-14<NA><NA>
26239NZD1997-11-04608.710.6294
38384ESP1980-05-31<NA><NA>
11111CNY1995-04-1891.270.1187
84513NLG2001-06-26507.960.3899