Overview

Dataset statistics

Number of variables3
Number of observations988
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory24.2 KiB
Average record size in memory25.1 B

Variable types

DateTime1
Categorical1
Numeric1

Dataset

Description한국무역보험공사 2022년도 시장 평균 환율을 계산일자, 통화코드(각 국가별 화폐 단위에 따라 상이함.), 시장 평균 환율로 제시한 파일 데이터 자료입니다.
URLhttps://www.data.go.kr/data/15064316/fileData.do

Alerts

시장평균환율 is highly overall correlated with 통화코드High correlation
통화코드 is highly overall correlated with 시장평균환율High correlation

Reproduction

Analysis started2023-12-12 02:29:00.167583
Analysis finished2023-12-12 02:29:00.467999
Duration0.3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

계산일자
Date

Distinct247
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size7.8 KiB
Minimum2022-01-03 00:00:00
Maximum2022-12-30 00:00:00
2023-12-12T11:29:00.531387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:29:00.675784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

통화코드
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size7.8 KiB
CNY
247 
EUR
247 
JPY
247 
USD
247 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowCNY
2nd rowEUR
3rd rowJPY
4th rowUSD
5th rowCNY

Common Values

ValueCountFrequency (%)
CNY 247
25.0%
EUR 247
25.0%
JPY 247
25.0%
USD 247
25.0%

Length

2023-12-12T11:29:00.847421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:29:01.024605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cny 247
25.0%
eur 247
25.0%
jpy 247
25.0%
usd 247
25.0%

시장평균환율
Real number (ℝ)

HIGH CORRELATION 

Distinct945
Distinct (%)95.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean957.08849
Minimum181.51
Maximum1436.6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.8 KiB
2023-12-12T11:29:01.169345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum181.51
5-th percentile187.9575
Q1937.255
median1127.3
Q31338.8575
95-th percentile1396.3575
Maximum1436.6
Range1255.09
Interquartile range (IQR)401.6025

Descriptive statistics

Standard deviation464.96424
Coefficient of variation (CV)0.48581113
Kurtosis-0.93612447
Mean957.08849
Median Absolute Deviation (MAD)211.305
Skewness-0.84514359
Sum945603.43
Variance216191.74
MonotonicityNot monotonic
2023-12-12T11:29:01.366979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1436.6 3
 
0.3%
1310.0 3
 
0.3%
1329.39 2
 
0.2%
192.01 2
 
0.2%
1197.8 2
 
0.2%
192.66 2
 
0.2%
1326.8 2
 
0.2%
952.42 2
 
0.2%
963.0 2
 
0.2%
1352.3 2
 
0.2%
Other values (935) 966
97.8%
ValueCountFrequency (%)
181.51 1
0.1%
182.04 1
0.1%
182.1 1
0.1%
182.5 1
0.1%
182.93 1
0.1%
183.13 1
0.1%
184.43 1
0.1%
184.49 1
0.1%
184.55 1
0.1%
184.76 1
0.1%
ValueCountFrequency (%)
1436.6 3
0.3%
1436.5 2
0.2%
1434.8 1
 
0.1%
1433.5 1
 
0.1%
1432.1 1
 
0.1%
1431.7 1
 
0.1%
1431.2 1
 
0.1%
1430.4 1
 
0.1%
1429.7 1
 
0.1%
1428.9 1
 
0.1%

Interactions

2023-12-12T11:29:00.254814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:29:01.521988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통화코드시장평균환율
통화코드1.0000.906
시장평균환율0.9061.000
2023-12-12T11:29:01.619399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시장평균환율통화코드
시장평균환율1.0000.910
통화코드0.9101.000

Missing values

2023-12-12T11:29:00.372812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:29:00.440193image/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-03CNY186.11
12022-01-03EUR1344.35
22022-01-03JPY1030.5
32022-01-03USD1185.5
42022-01-04CNY187.28
52022-01-04EUR1351.93
62022-01-04JPY1033.38
72022-01-04USD1190.8
82022-01-05CNY187.38
92022-01-05EUR1349.97
계산일자통화코드시장평균환율
9782022-12-28JPY954.79
9792022-12-28USD1268.3
9802022-12-29CNY182.04
9812022-12-29EUR1349.89
9822022-12-29JPY947.93
9832022-12-29USD1268.4
9842022-12-30CNY181.51
9852022-12-30EUR1346.63
9862022-12-30JPY947.37
9872022-12-30USD1267.3