Overview

Dataset statistics

Number of variables11
Number of observations500
Missing cells0
Missing cells (%)0.0%
Duplicate rows10
Duplicate rows (%)2.0%
Total size in memory46.0 KiB
Average record size in memory94.3 B

Variable types

Categorical10
Boolean1

Dataset

Description해당 파일 데이터는 신용보증기금의 재정상태표정보에 대해 확인하실 수 있는 자료이니 데이터 활용에 참고하여 주시기 바랍니다.
Author신용보증기금
URLhttps://www.data.go.kr/data/15092810/fileData.do

Alerts

국가계정코드값 has constant value ""Constant
국가결산단계구분코드 has constant value ""Constant
삭제여부 has constant value ""Constant
최종수정수 has constant value ""Constant
처리직원번호 has constant value ""Constant
최초처리직원번호 has constant value ""Constant
Dataset has 10 (2.0%) duplicate rowsDuplicates
회계년월 is highly overall correlated with 처리시각 and 1 other fieldsHigh correlation
최초처리시각 is highly overall correlated with 회계년월 and 3 other fieldsHigh correlation
처리시각 is highly overall correlated with 회계년월 and 3 other fieldsHigh correlation
소관코드 is highly overall correlated with 국가결산회계구분코드 and 2 other fieldsHigh correlation
국가결산회계구분코드 is highly overall correlated with 소관코드 and 2 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 07:10:55.228158
Analysis finished2023-12-12 07:10:55.744744
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계년월
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
202109
211 
202108
151 
202107
138 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row202109
2nd row202109
3rd row202109
4th row202109
5th row202109

Common Values

ValueCountFrequency (%)
202109 211
42.2%
202108 151
30.2%
202107 138
27.6%

Length

2023-12-12T16:10:55.803999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:55.889104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
202109 211
42.2%
202108 151
30.2%
202107 138
27.6%

소관코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
79
439 
69
61 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row79
2nd row79
3rd row79
4th row79
5th row79

Common Values

ValueCountFrequency (%)
79 439
87.8%
69 61
 
12.2%

Length

2023-12-12T16:10:55.983478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:56.093393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
79 439
87.8%
69 61
 
12.2%

국가결산회계구분코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
574
439 
578
61 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row574
2nd row574
3rd row574
4th row574
5th row574

Common Values

ValueCountFrequency (%)
574 439
87.8%
578 61
 
12.2%

Length

2023-12-12T16:10:56.191084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:56.282861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
574 439
87.8%
578 61
 
12.2%

국가계정코드값
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
0
500 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 500
100.0%

Length

2023-12-12T16:10:56.400580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:56.508093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 500
100.0%

국가결산단계구분코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
21
500 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row21
2nd row21
3rd row21
4th row21
5th row21

Common Values

ValueCountFrequency (%)
21 500
100.0%

Length

2023-12-12T16:10:56.606669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:56.716381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
21 500
100.0%

삭제여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size632.0 B
False
500 
ValueCountFrequency (%)
False 500
100.0%
2023-12-12T16:10:56.812077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

최종수정수
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
1
500 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 500
100.0%

Length

2023-12-12T16:10:56.939094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:57.053083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 500
100.0%

처리시각
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
05:56.4
135 
35:05.9
124 
06:54.3
109 
16:27.2
61 
06:54.2
38 
Other values (5)
33 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row06:54.5
2nd row06:54.5
3rd row06:54.5
4th row06:54.3
5th row06:54.3

Common Values

ValueCountFrequency (%)
05:56.4 135
27.0%
35:05.9 124
24.8%
06:54.3 109
21.8%
16:27.2 61
12.2%
06:54.2 38
 
7.6%
05:56.3 13
 
2.6%
35:06.0 11
 
2.2%
06:54.5 3
 
0.6%
05:56.6 3
 
0.6%
35:06.3 3
 
0.6%

Length

2023-12-12T16:10:57.150405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:57.326387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
05:56.4 135
27.0%
35:05.9 124
24.8%
06:54.3 109
21.8%
16:27.2 61
12.2%
06:54.2 38
 
7.6%
05:56.3 13
 
2.6%
35:06.0 11
 
2.2%
06:54.5 3
 
0.6%
05:56.6 3
 
0.6%
35:06.3 3
 
0.6%

처리직원번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
AND14
500 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowAND14
2nd rowAND14
3rd rowAND14
4th rowAND14
5th rowAND14

Common Values

ValueCountFrequency (%)
AND14 500
100.0%

Length

2023-12-12T16:10:57.559963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:57.690868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
and14 500
100.0%

최초처리시각
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
05:56.4
135 
35:05.9
124 
06:54.3
109 
16:27.2
61 
06:54.2
38 
Other values (5)
33 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row06:54.5
2nd row06:54.5
3rd row06:54.5
4th row06:54.3
5th row06:54.3

Common Values

ValueCountFrequency (%)
05:56.4 135
27.0%
35:05.9 124
24.8%
06:54.3 109
21.8%
16:27.2 61
12.2%
06:54.2 38
 
7.6%
05:56.3 13
 
2.6%
35:06.0 11
 
2.2%
06:54.5 3
 
0.6%
05:56.6 3
 
0.6%
35:06.3 3
 
0.6%

Length

2023-12-12T16:10:58.140183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:58.270633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
05:56.4 135
27.0%
35:05.9 124
24.8%
06:54.3 109
21.8%
16:27.2 61
12.2%
06:54.2 38
 
7.6%
05:56.3 13
 
2.6%
35:06.0 11
 
2.2%
06:54.5 3
 
0.6%
05:56.6 3
 
0.6%
35:06.3 3
 
0.6%

최초처리직원번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
AND14
500 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowAND14
2nd rowAND14
3rd rowAND14
4th rowAND14
5th rowAND14

Common Values

ValueCountFrequency (%)
AND14 500
100.0%

Length

2023-12-12T16:10:58.421727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:10:58.536704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
and14 500
100.0%

Correlations

2023-12-12T16:10:58.615533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계년월소관코드국가결산회계구분코드처리시각최초처리시각
회계년월1.0000.2660.2661.0001.000
소관코드0.2661.0001.0001.0001.000
국가결산회계구분코드0.2661.0001.0001.0001.000
처리시각1.0001.0001.0001.0001.000
최초처리시각1.0001.0001.0001.0001.000
2023-12-12T16:10:58.773566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계년월최초처리시각처리시각소관코드국가결산회계구분코드
회계년월1.0000.9930.9930.4320.432
최초처리시각0.9931.0001.0000.9920.992
처리시각0.9931.0001.0000.9920.992
소관코드0.4320.9920.9921.0000.991
국가결산회계구분코드0.4320.9920.9920.9911.000
2023-12-12T16:10:58.875416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계년월소관코드국가결산회계구분코드처리시각최초처리시각
회계년월1.0000.4320.4320.9930.993
소관코드0.4321.0000.9910.9920.992
국가결산회계구분코드0.4320.9911.0000.9920.992
처리시각0.9930.9920.9921.0001.000
최초처리시각0.9930.9920.9921.0001.000

Missing values

2023-12-12T16:10:55.538767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:10:55.690778image/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

회계년월소관코드국가결산회계구분코드국가계정코드값국가결산단계구분코드삭제여부최종수정수처리시각처리직원번호최초처리시각최초처리직원번호
020210979574021N106:54.5AND1406:54.5AND14
120210979574021N106:54.5AND1406:54.5AND14
220210979574021N106:54.5AND1406:54.5AND14
320210979574021N106:54.3AND1406:54.3AND14
420210979574021N106:54.3AND1406:54.3AND14
520210979574021N106:54.3AND1406:54.3AND14
620210979574021N106:54.3AND1406:54.3AND14
720210979574021N106:54.3AND1406:54.3AND14
820210979574021N106:54.3AND1406:54.3AND14
920210979574021N106:54.3AND1406:54.3AND14
회계년월소관코드국가결산회계구분코드국가계정코드값국가결산단계구분코드삭제여부최종수정수처리시각처리직원번호최초처리시각최초처리직원번호
49020210779574021N135:05.9AND1435:05.9AND14
49120210779574021N135:05.9AND1435:05.9AND14
49220210779574021N135:05.9AND1435:05.9AND14
49320210779574021N135:05.9AND1435:05.9AND14
49420210779574021N135:05.9AND1435:05.9AND14
49520210779574021N135:05.9AND1435:05.9AND14
49620210779574021N135:05.9AND1435:05.9AND14
49720210779574021N135:05.9AND1435:05.9AND14
49820210779574021N135:05.9AND1435:05.9AND14
49920210779574021N135:05.9AND1435:05.9AND14

Duplicate rows

Most frequently occurring

회계년월소관코드국가결산회계구분코드국가계정코드값국가결산단계구분코드삭제여부최종수정수처리시각처리직원번호최초처리시각최초처리직원번호# duplicates
420210879574021N105:56.4AND1405:56.4AND14135
020210779574021N135:05.9AND1435:05.9AND14124
820210979574021N106:54.3AND1406:54.3AND14109
620210969578021N116:27.2AND1416:27.2AND1461
720210979574021N106:54.2AND1406:54.2AND1438
320210879574021N105:56.3AND1405:56.3AND1413
120210779574021N135:06.0AND1435:06.0AND1411
220210779574021N135:06.3AND1435:06.3AND143
520210879574021N105:56.6AND1405:56.6AND143
920210979574021N106:54.5AND1406:54.5AND143