Overview

Dataset statistics

Number of variables6
Number of observations40
Missing cells21
Missing cells (%)8.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory51.3 B

Variable types

DateTime3
Categorical3

Dataset

Description스탠더드앤드푸어스(S&P) · 무디스(Moody"s) · 피치(Fitch) 세계 3대 신용평가사가 제공하는 우리나라 국가 신용등급에 대한 자료입니다
URLhttps://www.data.go.kr/data/15117342/fileData.do

Alerts

신용등급(standardandpoors) is highly overall correlated with 신용등급(fitch)High correlation
신용등급(fitch) is highly overall correlated with 신용등급(standardandpoors)High correlation
국가신용등급(standardandpoors) has 12 (30.0%) missing valuesMissing
국가신용등급(fitch) has 9 (22.5%) missing valuesMissing
국가신용등급(moodys) has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:31:23.097448
Analysis finished2023-12-12 10:31:23.634192
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

국가신용등급(standardandpoors)
Date

MISSING 

Distinct28
Distinct (%)100.0%
Missing12
Missing (%)30.0%
Memory size452.0 B
Minimum1988-10-01 00:00:00
Maximum2022-04-26 00:00:00
2023-12-12T19:31:23.701406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:31:23.864849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)

신용등급(standardandpoors)
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)27.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
<NA>
12 
A+
7 
AA
7 
AA-
3 
A-
2 
Other values (6)
9 

Length

Max length4
Median length3
Mean length2.85
Min length1

Unique

Unique3 ?
Unique (%)7.5%

Sample

1st rowA+
2nd rowA+
3rd rowA+
4th rowA+
5th rowAA-

Common Values

ValueCountFrequency (%)
<NA> 12
30.0%
A+ 7
17.5%
AA 7
17.5%
AA- 3
 
7.5%
A- 2
 
5.0%
BBB- 2
 
5.0%
BB+ 2
 
5.0%
A 2
 
5.0%
B+ 1
 
2.5%
BBB 1
 
2.5%

Length

2023-12-12T19:31:24.002227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 12
30.0%
a 11
27.5%
aa 10
25.0%
bbb 4
 
10.0%
bb 2
 
5.0%
b 1
 
2.5%

국가신용등급(moodys)
Date

UNIQUE 

Distinct40
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
Minimum1986-11-18 00:00:00
Maximum2023-05-19 00:00:00
2023-12-12T19:31:24.434103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:31:24.560180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)

신용등급(moodys)
Categorical

Distinct8
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
Aa2
11 
A3
9 
A1
6 
Baa2
5 
A2
4 
Other values (3)
5 

Length

Max length4
Median length3
Mean length2.675
Min length2

Unique

Unique2 ?
Unique (%)5.0%

Sample

1st rowA2
2nd rowA1
3rd rowA2
4th rowA1
5th rowA1

Common Values

ValueCountFrequency (%)
Aa2 11
27.5%
A3 9
22.5%
A1 6
15.0%
Baa2 5
12.5%
A2 4
 
10.0%
Aa3 3
 
7.5%
Ba1 1
 
2.5%
Baa3 1
 
2.5%

Length

2023-12-12T19:31:24.708566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:24.856174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
aa2 11
27.5%
a3 9
22.5%
a1 6
15.0%
baa2 5
12.5%
a2 4
 
10.0%
aa3 3
 
7.5%
ba1 1
 
2.5%
baa3 1
 
2.5%

국가신용등급(fitch)
Date

MISSING 

Distinct31
Distinct (%)100.0%
Missing9
Missing (%)22.5%
Memory size452.0 B
Minimum1996-06-27 00:00:00
Maximum2023-03-13 00:00:00
2023-12-12T19:31:25.075488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:31:25.281522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)

신용등급(fitch)
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)22.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
AA-
13 
<NA>
9 
A+
5 
A
3 
BBB-
3 
Other values (4)
7 

Length

Max length4
Median length3
Mean length3.025
Min length1

Unique

Unique1 ?
Unique (%)2.5%

Sample

1st rowAA-
2nd rowA+
3rd rowA
4th rowBBB-
5th rowB-

Common Values

ValueCountFrequency (%)
AA- 13
32.5%
<NA> 9
22.5%
A+ 5
 
12.5%
A 3
 
7.5%
BBB- 3
 
7.5%
B- 2
 
5.0%
BB+ 2
 
5.0%
BBB+ 2
 
5.0%
BBB 1
 
2.5%

Length

2023-12-12T19:31:25.442211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:25.609266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
aa 13
32.5%
na 9
22.5%
a 8
20.0%
bbb 6
15.0%
b 2
 
5.0%
bb 2
 
5.0%

Correlations

2023-12-12T19:31:25.734238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
국가신용등급(standardandpoors)신용등급(standardandpoors)국가신용등급(moodys)신용등급(moodys)국가신용등급(fitch)신용등급(fitch)
국가신용등급(standardandpoors)1.0001.0001.0001.0001.0001.000
신용등급(standardandpoors)1.0001.0001.0000.6621.0000.796
국가신용등급(moodys)1.0001.0001.0001.0001.0001.000
신용등급(moodys)1.0000.6621.0001.0001.0000.883
국가신용등급(fitch)1.0001.0001.0001.0001.0001.000
신용등급(fitch)1.0000.7961.0000.8831.0001.000
2023-12-12T19:31:25.851825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신용등급(moodys)신용등급(standardandpoors)신용등급(fitch)
신용등급(moodys)1.0000.3660.486
신용등급(standardandpoors)0.3661.0000.505
신용등급(fitch)0.4860.5051.000
2023-12-12T19:31:25.966329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신용등급(standardandpoors)신용등급(moodys)신용등급(fitch)
신용등급(standardandpoors)1.0000.3660.505
신용등급(moodys)0.3661.0000.486
신용등급(fitch)0.5050.4861.000

Missing values

2023-12-12T19:31:23.344346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:31:23.455728image/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-12T19:31:23.566291image/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

국가신용등급(standardandpoors)신용등급(standardandpoors)국가신용등급(moodys)신용등급(moodys)국가신용등급(fitch)신용등급(fitch)
01988-10-01A+1986-11-18A21996-06-27AA-
11989-06-26A+1990-04-04A11997-11-18A+
21994-06-09A+1995-10-02A21997-11-26A
31994-11-09A+1997-03-07A11997-12-11BBB-
41995-05-03AA-1997-08-05A11997-12-23B-
51997-08-05AA-1997-10-27A11998-01-21B-
61997-10-24A+1997-11-27A31998-02-02BB+
71997-11-25A-1997-11-28A31998-12-22BB+
81997-12-11BBB-1997-12-10Baa21999-01-19BBB-
91997-12-23B+1997-12-11Baa21999-04-26BBB-
국가신용등급(standardandpoors)신용등급(standardandpoors)국가신용등급(moodys)신용등급(moodys)국가신용등급(fitch)신용등급(fitch)
30<NA><NA>2015-12-19Aa22023-03-13AA-
31<NA><NA>2016-11-01Aa2<NA><NA>
32<NA><NA>2017-02-21Aa2<NA><NA>
33<NA><NA>2017-10-18Aa2<NA><NA>
34<NA><NA>2018-06-18Aa2<NA><NA>
35<NA><NA>2019-07-08Aa2<NA><NA>
36<NA><NA>2020-05-12Aa2<NA><NA>
37<NA><NA>2021-05-12Aa2<NA><NA>
38<NA><NA>2022-04-21Aa2<NA><NA>
39<NA><NA>2023-05-19Aa2<NA><NA>