Overview

Dataset statistics

Number of variables4
Number of observations500
Missing cells0
Missing cells (%)0.0%
Duplicate rows39
Duplicate rows (%)7.8%
Total size in memory16.2 KiB
Average record size in memory33.3 B

Variable types

Categorical3
Boolean1

Dataset

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

Alerts

삭제여부 has constant value ""Constant
최종수정수 has constant value ""Constant
Dataset has 39 (7.8%) duplicate rowsDuplicates
보증심사검토표검토항목구분 is highly overall correlated with 검토여부값High correlation
검토여부값 is highly overall correlated with 보증심사검토표검토항목구분High correlation

Reproduction

Analysis started2023-12-12 06:13:47.210652
Analysis finished2023-12-12 06:13:47.437418
Duration0.23 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

보증심사검토표검토항목구분
Categorical

HIGH CORRELATION 

Distinct46
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
회사의 *********점)
84 
회사는 *********점)
80 
회사가 *********점)
56 
목표(잠*********점)
28 
총차입금*********여부
 
18
Other values (41)
234 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique19 ?
Unique (%)3.8%

Sample

1st row보증제한*********여부
2nd row총차입금*********여부
3rd row자기자본*********여부
4th row최근 1*********여부
5th row보증제한*********여부

Common Values

ValueCountFrequency (%)
회사의 *********점) 84
16.8%
회사는 *********점) 80
16.0%
회사가 *********점) 56
 
11.2%
목표(잠*********점) 28
 
5.6%
총차입금*********여부 18
 
3.6%
보증제한*********여부 18
 
3.6%
최근 1*********여부 18
 
3.6%
자기자본*********여부 18
 
3.6%
건축허가*********여부 16
 
3.2%
시설활용*********여부 16
 
3.2%
Other values (36) 148
29.6%

Length

2023-12-12T15:13:47.498534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
224
28.6%
회사의 84
 
10.7%
회사는 80
 
10.2%
회사가 56
 
7.2%
목표(잠*********점 28
 
3.6%
최근 20
 
2.6%
총차입금*********여부 18
 
2.3%
보증제한*********여부 18
 
2.3%
1*********여부 18
 
2.3%
자기자본*********여부 18
 
2.3%
Other values (48) 218
27.9%

검토여부값
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
N
269 
Y
201 
28 
<NA>
 
2

Length

Max length4
Median length1
Mean length1.012
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row
2nd row
3rd row
4th row
5th rowN

Common Values

ValueCountFrequency (%)
N 269
53.8%
Y 201
40.2%
28
 
5.6%
<NA> 2
 
0.4%

Length

2023-12-12T15:13:47.617918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:13:47.739055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
n 269
57.0%
y 201
42.6%
na 2
 
0.4%

삭제여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size632.0 B
False
500 
ValueCountFrequency (%)
False 500
100.0%
2023-12-12T15:13:47.826026image/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-12T15:13:47.939820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:13:48.041953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 500
100.0%

Correlations

2023-12-12T15:13:48.101821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
보증심사검토표검토항목구분검토여부값
보증심사검토표검토항목구분1.0000.762
검토여부값0.7621.000
2023-12-12T15:13:48.207213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
보증심사검토표검토항목구분검토여부값
보증심사검토표검토항목구분1.0000.508
검토여부값0.5081.000
2023-12-12T15:13:48.302648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
보증심사검토표검토항목구분검토여부값
보증심사검토표검토항목구분1.0000.508
검토여부값0.5081.000

Missing values

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

보증심사검토표검토항목구분검토여부값삭제여부최종수정수
0보증제한*********여부N1
1총차입금*********여부N1
2자기자본*********여부N1
3최근 1*********여부N1
4보증제한*********여부NN1
5최근 1*********여부NN1
6자기자본*********여부NN1
7총차입금*********여부NN1
8시설자금*********이내NN1
9시설활용*********여부YN1
보증심사검토표검토항목구분검토여부값삭제여부최종수정수
490자기자본*********여부N1
491최근 1*********여부N1
492신청기업*********기업NN1
493「보증심*********기업NN1
494금융업 *********기업NN1
495기업구조*********기업NN1
496회생절차*********기업NN1
497보증심사*********기업NN1
498당기 C*********기업NN1
499보증심사*********기업NN1

Duplicate rows

Most frequently occurring

보증심사검토표검토항목구분검토여부값삭제여부최종수정수# duplicates
35회사는 *********점)YN157
36회사의 *********점)NN142
37회사의 *********점)YN142
33회사가 *********점)YN129
32회사가 *********점)NN127
34회사는 *********점)NN123
7목표(잠*********점)NN120
2건축허가*********여부YN115
9보증심사*********기업NN115
16시설활용*********여부YN115