Overview

Dataset statistics

Number of variables39
Number of observations100
Missing cells1504
Missing cells (%)38.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory33.1 KiB
Average record size in memory339.3 B

Variable types

Text1
Numeric5
DateTime6
Categorical13
Unsupported10
Boolean4

Dataset

Description한국주택금융공사 주택연금부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터)
Author한국주택금융공사
URLhttps://www.data.go.kr/data/15073107/fileData.do

Alerts

처리순번2 has constant value ""Constant
처리순번3 has constant value ""Constant
처리순번4 has constant value ""Constant
처리순번5 has constant value ""Constant
처리순번6 has constant value ""Constant
처리순번7 has constant value ""Constant
적격여부1(업무처리규정59조1항충족) has constant value ""Constant
적격여부2(물적담보의충분성) has constant value ""Constant
적격여부3(특별한사정존재) has constant value ""Constant
적격여부4(요청서수취) has constant value ""Constant
유보기한 has constant value ""Constant
지급정지구분코드(T75002) is highly imbalanced (65.4%)Imbalance
지급정지승인코드 is highly imbalanced (86.0%)Imbalance
처리순번1 is highly imbalanced (61.6%)Imbalance
이행청구체크 is highly imbalanced (91.9%)Imbalance
유보기간 is highly imbalanced (91.9%)Imbalance
지급정지(유보)/해소일자 has 3 (3.0%) missing valuesMissing
승인사원번호 has 3 (3.0%) missing valuesMissing
지급정지승인일자 has 3 (3.0%) missing valuesMissing
지급정지예정일자 has 100 (100.0%) missing valuesMissing
이행청구예정일자 has 100 (100.0%) missing valuesMissing
이행청구일자 has 100 (100.0%) missing valuesMissing
지급정지사유2코드 has 100 (100.0%) missing valuesMissing
지급정지사유3코드 has 100 (100.0%) missing valuesMissing
지급정지사유4코드 has 100 (100.0%) missing valuesMissing
지급정지사유5코드 has 100 (100.0%) missing valuesMissing
지급정지사유6코드 has 100 (100.0%) missing valuesMissing
지급정지사유7코드 has 100 (100.0%) missing valuesMissing
팀코드 has 100 (100.0%) missing valuesMissing
적격여부1(업무처리규정59조1항충족) has 99 (99.0%) missing valuesMissing
적격여부2(물적담보의충분성) has 99 (99.0%) missing valuesMissing
적격여부3(특별한사정존재) has 99 (99.0%) missing valuesMissing
적격여부4(요청서수취) has 99 (99.0%) missing valuesMissing
유보기한 has 99 (99.0%) missing valuesMissing
접수품의번호 has unique valuesUnique
지급정지예정일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
이행청구예정일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
이행청구일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
지급정지사유2코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
지급정지사유3코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
지급정지사유4코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
지급정지사유5코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
지급정지사유6코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
지급정지사유7코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
팀코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 22:53:53.969283
Analysis finished2023-12-12 22:53:54.255244
Duration0.29 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct93
Distinct (%)93.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-13T07:53:54.401832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length14
Min length14

Characters and Unicode

Total characters1400
Distinct characters22
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique86 ?
Unique (%)86.0%

Sample

1st rowRTAA2015000168
2nd rowRTAB2019000619
3rd rowRTAB2014000537
4th rowRTAC2016000577
5th rowRTHB2018000477
ValueCountFrequency (%)
rtho2017000285 2
 
2.0%
rtaa2018000598 2
 
2.0%
rtaa2011000033 2
 
2.0%
rtja2010000036 2
 
2.0%
rtac2013000308 2
 
2.0%
rtab2014000537 2
 
2.0%
rtba2015000254 2
 
2.0%
rtho2016000642 1
 
1.0%
rtha2010000371 1
 
1.0%
rtaa2019000625 1
 
1.0%
Other values (83) 83
83.0%
2023-12-13T07:53:54.722110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 444
31.7%
2 136
 
9.7%
1 130
 
9.3%
R 100
 
7.1%
A 94
 
6.7%
T 90
 
6.4%
3 53
 
3.8%
8 43
 
3.1%
6 43
 
3.1%
5 42
 
3.0%
Other values (12) 225
16.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1000
71.4%
Uppercase Letter 400
 
28.6%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
R 100
25.0%
A 94
23.5%
T 90
22.5%
H 29
 
7.2%
B 27
 
6.8%
Q 13
 
3.2%
D 13
 
3.2%
O 13
 
3.2%
P 9
 
2.2%
C 9
 
2.2%
Other values (2) 3
 
0.8%
Decimal Number
ValueCountFrequency (%)
0 444
44.4%
2 136
 
13.6%
1 130
 
13.0%
3 53
 
5.3%
8 43
 
4.3%
6 43
 
4.3%
5 42
 
4.2%
7 40
 
4.0%
9 36
 
3.6%
4 33
 
3.3%

Most occurring scripts

ValueCountFrequency (%)
Common 1000
71.4%
Latin 400
 
28.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
R 100
25.0%
A 94
23.5%
T 90
22.5%
H 29
 
7.2%
B 27
 
6.8%
Q 13
 
3.2%
D 13
 
3.2%
O 13
 
3.2%
P 9
 
2.2%
C 9
 
2.2%
Other values (2) 3
 
0.8%
Common
ValueCountFrequency (%)
0 444
44.4%
2 136
 
13.6%
1 130
 
13.0%
3 53
 
5.3%
8 43
 
4.3%
6 43
 
4.3%
5 42
 
4.2%
7 40
 
4.0%
9 36
 
3.6%
4 33
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1400
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 444
31.7%
2 136
 
9.7%
1 130
 
9.3%
R 100
 
7.1%
A 94
 
6.7%
T 90
 
6.4%
3 53
 
3.8%
8 43
 
3.1%
6 43
 
3.1%
5 42
 
3.0%
Other values (12) 225
16.1%

접수품의번호
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0193302 × 1010
Minimum2.0191402 × 1010
Maximum2.02014 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T07:53:54.890546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0191402 × 1010
5-th percentile2.0191402 × 1010
Q12.0191402 × 1010
median2.0191402 × 1010
Q32.0191402 × 1010
95-th percentile2.02014 × 1010
Maximum2.02014 × 1010
Range9998120
Interquartile range (IQR)53.5

Descriptive statistics

Standard deviation3942010.1
Coefficient of variation (CV)0.00019521375
Kurtosis0.58602569
Mean2.0193302 × 1010
Median Absolute Deviation (MAD)27
Skewness1.6045893
Sum2.0193302 × 1012
Variance1.5539444 × 1013
MonotonicityNot monotonic
2023-12-13T07:53:55.034282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20201400011 1
 
1.0%
20191401940 1
 
1.0%
20191401932 1
 
1.0%
20191401929 1
 
1.0%
20191401930 1
 
1.0%
20191401928 1
 
1.0%
20191401927 1
 
1.0%
20191401933 1
 
1.0%
20191401938 1
 
1.0%
20191401941 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
20191401900 1
1.0%
20191401901 1
1.0%
20191401902 1
1.0%
20191401903 1
1.0%
20191401906 1
1.0%
20191401907 1
1.0%
20191401908 1
1.0%
20191401909 1
1.0%
20191401910 1
1.0%
20191401911 1
1.0%
ValueCountFrequency (%)
20201400020 1
1.0%
20201400019 1
1.0%
20201400018 1
1.0%
20201400017 1
1.0%
20201400016 1
1.0%
20201400015 1
1.0%
20201400014 1
1.0%
20201400013 1
1.0%
20201400012 1
1.0%
20201400011 1
1.0%
Distinct13
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2019-12-17 00:00:00
Maximum2020-01-03 00:00:00
2023-12-13T07:53:55.161119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:55.298862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)

지급정지구분코드(T75002)
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
89 
2
10 
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 89
89.0%
2 10
 
10.0%
3 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:55.566907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 89
89.0%
2 10
 
10.0%
3 1
 
1.0%
Distinct16
Distinct (%)16.5%
Missing3
Missing (%)3.0%
Memory size932.0 B
Minimum2019-12-17 00:00:00
Maximum2020-01-04 00:00:00
2023-12-13T07:53:55.680557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:55.844714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)

승인사원번호
Real number (ℝ)

MISSING 

Distinct22
Distinct (%)22.7%
Missing3
Missing (%)3.0%
Infinite0
Infinite (%)0.0%
Mean1210.6907
Minimum1021
Maximum1421
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T07:53:55.974067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1021
5-th percentile1075.4
Q11140
median1211
Q31258
95-th percentile1354
Maximum1421
Range400
Interquartile range (IQR)118

Descriptive statistics

Standard deviation88.448356
Coefficient of variation (CV)0.073056111
Kurtosis-0.088125016
Mean1210.6907
Median Absolute Deviation (MAD)47
Skewness0.0056096613
Sum117437
Variance7823.1117
MonotonicityNot monotonic
2023-12-13T07:53:56.111773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
1127 10
 
10.0%
1258 9
 
9.0%
1241 9
 
9.0%
1211 9
 
9.0%
1200 7
 
7.0%
1173 6
 
6.0%
1354 6
 
6.0%
1316 5
 
5.0%
1021 5
 
5.0%
1276 5
 
5.0%
Other values (12) 26
26.0%
ValueCountFrequency (%)
1021 5
5.0%
1089 4
 
4.0%
1121 2
 
2.0%
1122 2
 
2.0%
1126 1
 
1.0%
1127 10
10.0%
1140 3
 
3.0%
1172 2
 
2.0%
1173 6
6.0%
1186 2
 
2.0%
ValueCountFrequency (%)
1421 2
 
2.0%
1365 2
 
2.0%
1354 6
6.0%
1316 5
5.0%
1278 1
 
1.0%
1276 5
5.0%
1258 9
9.0%
1247 4
4.0%
1241 9
9.0%
1211 9
9.0%

지급정지승인코드
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
97 
2
 
2
0
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 97
97.0%
2 2
 
2.0%
0 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:56.380745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 97
97.0%
2 2
 
2.0%
0 1
 
1.0%
Distinct12
Distinct (%)12.4%
Missing3
Missing (%)3.0%
Memory size932.0 B
Minimum2019-12-17 00:00:00
Maximum2020-01-03 00:00:00
2023-12-13T07:53:56.462895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:56.587526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

주채무자고객번호
Real number (ℝ)

Distinct93
Distinct (%)93.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0339745 × 108
Minimum8833855
Maximum1.3215961 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T07:53:56.737018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8833855
5-th percentile73240738
Q192930449
median1.1078478 × 108
Q31.1964873 × 108
95-th percentile1.2846704 × 108
Maximum1.3215961 × 108
Range1.2332576 × 108
Interquartile range (IQR)26718277

Descriptive statistics

Standard deviation25519226
Coefficient of variation (CV)0.2468071
Kurtosis5.1291737
Mean1.0339745 × 108
Median Absolute Deviation (MAD)13046783
Skewness-2.0111665
Sum1.0339745 × 1010
Variance6.512309 × 1014
MonotonicityNot monotonic
2023-12-13T07:53:56.905339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
115848703 2
 
2.0%
93801228 2
 
2.0%
99872594 2
 
2.0%
102245623 2
 
2.0%
124295114 2
 
2.0%
81266231 2
 
2.0%
79783014 2
 
2.0%
74558189 1
 
1.0%
130970805 1
 
1.0%
130348327 1
 
1.0%
Other values (83) 83
83.0%
ValueCountFrequency (%)
8833855 1
1.0%
9706910 1
1.0%
9985582 1
1.0%
10994012 1
1.0%
55398041 1
1.0%
74179827 1
1.0%
74544449 1
1.0%
74558189 1
1.0%
78254094 1
1.0%
78360739 1
1.0%
ValueCountFrequency (%)
132159611 1
1.0%
130970805 1
1.0%
130348327 1
1.0%
129753651 1
1.0%
129557158 1
1.0%
128409663 1
1.0%
128382696 1
1.0%
128328883 1
1.0%
127778447 1
1.0%
127615539 1
1.0%
Distinct92
Distinct (%)92.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2008-04-29 00:00:00
Maximum2019-11-26 00:00:00
2023-12-13T07:53:57.073416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:57.243089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

지급정지예정일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

이행청구예정일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

이행청구일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

채무이행기관코드
Real number (ℝ)

Distinct92
Distinct (%)92.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean217044.5
Minimum30423
Maximum883214
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T07:53:57.440483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum30423
5-th percentile41976.3
Q166489.75
median165533.5
Q3264521
95-th percentile811593.4
Maximum883214
Range852791
Interquartile range (IQR)198031.25

Descriptive statistics

Standard deviation220019.13
Coefficient of variation (CV)1.0137051
Kurtosis3.1728828
Mean217044.5
Median Absolute Deviation (MAD)99077
Skewness1.9937652
Sum21704450
Variance4.8408416 × 1010
MonotonicityNot monotonic
2023-12-13T07:53:57.602974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
102283 2
 
2.0%
48305 2
 
2.0%
266763 2
 
2.0%
321064 2
 
2.0%
802884 2
 
2.0%
811095 2
 
2.0%
42275 2
 
2.0%
66811 2
 
2.0%
811516 1
 
1.0%
192701 1
 
1.0%
Other values (82) 82
82.0%
ValueCountFrequency (%)
30423 1
1.0%
31079 1
1.0%
40400 1
1.0%
40471 1
1.0%
40785 1
1.0%
42039 1
1.0%
42275 2
2.0%
42505 1
1.0%
42615 1
1.0%
42822 1
1.0%
ValueCountFrequency (%)
883214 1
1.0%
843322 1
1.0%
814911 1
1.0%
814704 1
1.0%
813064 1
1.0%
811516 1
1.0%
811095 2
2.0%
802884 2
2.0%
341031 1
1.0%
323800 1
1.0%
Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
A2
37 
A1
36 
Z5
11 
B1
ZZ
Other values (4)

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique2 ?
Unique (%)2.0%

Sample

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

Common Values

ValueCountFrequency (%)
A2 37
37.0%
A1 36
36.0%
Z5 11
 
11.0%
B1 6
 
6.0%
ZZ 4
 
4.0%
D2 2
 
2.0%
C1 2
 
2.0%
Z1 1
 
1.0%
Z3 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:57.871850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
a2 37
37.0%
a1 36
36.0%
z5 11
 
11.0%
b1 6
 
6.0%
zz 4
 
4.0%
d2 2
 
2.0%
c1 2
 
2.0%
z1 1
 
1.0%
z3 1
 
1.0%

처리순번1
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
87 
2
12 
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 87
87.0%
2 12
 
12.0%
3 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:58.097151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 87
87.0%
2 12
 
12.0%
3 1
 
1.0%

지급정지사유2코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

처리순번2
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

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 100
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:58.270093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

지급정지사유3코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

처리순번3
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

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 100
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:58.459396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

지급정지사유4코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

처리순번4
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

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 100
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:58.631542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

지급정지사유5코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

처리순번5
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

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 100
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:58.816836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

지급정지사유6코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

처리순번6
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

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 100
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:59.023984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

지급정지사유7코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

처리순번7
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

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 100
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:59.228280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

이행청구체크
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
3
99 
<NA>
 
1

Length

Max length4
Median length1
Mean length1.03
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 99
99.0%
<NA> 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-13T07:53:59.447204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 99
99.0%
na 1
 
1.0%

영업점코드
Categorical

Distinct17
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
TAA
13 
TAC
11 
THA
10 
THO
10 
TAB
Other values (12)
47 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st rowTAA
2nd rowTAB
3rd rowTAB
4th rowTAC
5th rowTHB

Common Values

ValueCountFrequency (%)
TAA 13
13.0%
TAC 11
11.0%
THA 10
10.0%
THO 10
10.0%
TAB 9
9.0%
QAD 9
9.0%
TPA 7
7.0%
THB 7
7.0%
TBA 6
6.0%
TAD 5
 
5.0%
Other values (7) 13
13.0%

Length

2023-12-13T07:53:59.536001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
taa 13
13.0%
tac 11
11.0%
tha 10
10.0%
tho 10
10.0%
tab 9
9.0%
qad 9
9.0%
tpa 7
7.0%
thb 7
7.0%
tba 6
6.0%
tad 5
 
5.0%
Other values (7) 13
13.0%

팀코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB
Distinct13
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2019-12-17 00:00:00
Maximum2020-01-03 00:00:00
2023-12-13T07:53:59.635000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:53:59.749269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)

취급사원번호
Real number (ℝ)

Distinct36
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1699.23
Minimum1174
Maximum1932
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T07:53:59.875918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1174
5-th percentile1406
Q11569
median1714
Q31860.75
95-th percentile1932
Maximum1932
Range758
Interquartile range (IQR)291.75

Descriptive statistics

Standard deviation190.21932
Coefficient of variation (CV)0.11194442
Kurtosis-0.01260085
Mean1699.23
Median Absolute Deviation (MAD)145
Skewness-0.68206145
Sum169923
Variance36183.391
MonotonicityNot monotonic
2023-12-13T07:54:00.017129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
1917 8
 
8.0%
1932 7
 
7.0%
1410 6
 
6.0%
1721 5
 
5.0%
1532 5
 
5.0%
1773 4
 
4.0%
1569 4
 
4.0%
1686 4
 
4.0%
1777 3
 
3.0%
1547 3
 
3.0%
Other values (26) 51
51.0%
ValueCountFrequency (%)
1174 3
3.0%
1406 3
3.0%
1410 6
6.0%
1426 2
 
2.0%
1513 1
 
1.0%
1532 5
5.0%
1535 1
 
1.0%
1547 3
3.0%
1569 4
4.0%
1603 2
 
2.0%
ValueCountFrequency (%)
1932 7
7.0%
1929 2
 
2.0%
1919 2
 
2.0%
1917 8
8.0%
1914 3
 
3.0%
1912 1
 
1.0%
1866 2
 
2.0%
1859 3
 
3.0%
1846 1
 
1.0%
1844 3
 
3.0%
Distinct1
Distinct (%)100.0%
Missing99
Missing (%)99.0%
Memory size332.0 B
True
 
1
(Missing)
99 
ValueCountFrequency (%)
True 1
 
1.0%
(Missing) 99
99.0%
2023-12-13T07:54:00.460524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

적격여부2(물적담보의충분성)
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing99
Missing (%)99.0%
Memory size332.0 B
True
 
1
(Missing)
99 
ValueCountFrequency (%)
True 1
 
1.0%
(Missing) 99
99.0%
2023-12-13T07:54:00.536237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

적격여부3(특별한사정존재)
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing99
Missing (%)99.0%
Memory size332.0 B
True
 
1
(Missing)
99 
ValueCountFrequency (%)
True 1
 
1.0%
(Missing) 99
99.0%
2023-12-13T07:54:00.618178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

적격여부4(요청서수취)
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing99
Missing (%)99.0%
Memory size332.0 B
True
 
1
(Missing)
99 
ValueCountFrequency (%)
True 1
 
1.0%
(Missing) 99
99.0%
2023-12-13T07:54:00.697020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

유보기한
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing99
Missing (%)99.0%
Memory size932.0 B
Minimum2020-08-17 00:00:00
Maximum2020-08-17 00:00:00
2023-12-13T07:54:00.794178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:54:00.892094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

유보기간
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
99 
8
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 99
99.0%
8 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-13T07:54:01.124549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 99
99.0%
8 1
 
1.0%

Sample

보증번호접수품의번호접수품의일자지급정지구분코드(T75002)지급정지(유보)/해소일자승인사원번호지급정지승인코드지급정지승인일자주채무자고객번호보증일자지급정지예정일자이행청구예정일자이행청구일자채무이행기관코드지급정지사유1코드처리순번1지급정지사유2코드처리순번2지급정지사유3코드처리순번3지급정지사유4코드처리순번4지급정지사유5코드처리순번5지급정지사유6코드처리순번6지급정지사유7코드처리순번7이행청구체크영업점코드팀코드처리일자취급사원번호적격여부1(업무처리규정59조1항충족)적격여부2(물적담보의충분성)적격여부3(특별한사정존재)적격여부4(요청서수취)유보기한유보기간
0RTAA2015000168202014000112020-01-0312020-01-04131612020-01-03553980412015-03-30<NA><NA><NA>111724A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAA<NA>2020-01-031410<NA><NA><NA><NA><NA>0
1RTAB2019000619202014000122020-01-0312020-01-04121112020-01-031295571582019-07-17<NA><NA><NA>219642A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAB<NA>2020-01-031914<NA><NA><NA><NA><NA>0
2RTAB2014000537202014000142020-01-0322020-01-03121112020-01-03998725942014-12-09<NA><NA><NA>266763Z52<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAB<NA>2020-01-031532<NA><NA><NA><NA><NA>0
3RTAC2016000577202014000132020-01-031<NA><NA>0<NA>1107468132016-07-05<NA><NA><NA>205863A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAC<NA>2020-01-031707<NA><NA><NA><NA><NA>0
4RTHB2018000477202014000172020-01-0312020-01-04120012020-01-031239841382018-09-19<NA><NA><NA>214977A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03THB<NA>2020-01-031773<NA><NA><NA><NA><NA>0
5RTHB2012000405202014000192020-01-0312020-01-04120012020-01-0399855822012-11-05<NA><NA><NA>111122A11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03THB<NA>2020-01-031773<NA><NA><NA><NA><NA>0
6RQAD2013000237202014000202020-01-0312020-01-04102112020-01-03919726702013-03-11<NA><NA><NA>64509A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAD<NA>2020-01-031656<NA><NA><NA><NA><NA>0
7RTHO2019000415202014000182020-01-0312020-01-04112712020-01-031297536512019-07-10<NA><NA><NA>102830A11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03THO<NA>2020-01-031917<NA><NA><NA><NA><NA>0
8RTAB2014000537202014000162020-01-0312020-01-04121112020-01-03998725942014-12-09<NA><NA><NA>266763Z53<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAB<NA>2020-01-031532<NA><NA><NA><NA><NA>0
9RTHA2013000283202014000152020-01-0312020-01-04117312020-01-03940475152013-07-30<NA><NA><NA>42039A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03THA<NA>2020-01-031844<NA><NA><NA><NA><NA>0
보증번호접수품의번호접수품의일자지급정지구분코드(T75002)지급정지(유보)/해소일자승인사원번호지급정지승인코드지급정지승인일자주채무자고객번호보증일자지급정지예정일자이행청구예정일자이행청구일자채무이행기관코드지급정지사유1코드처리순번1지급정지사유2코드처리순번2지급정지사유3코드처리순번3지급정지사유4코드처리순번4지급정지사유5코드처리순번5지급정지사유6코드처리순번6지급정지사유7코드처리순번7이행청구체크영업점코드팀코드처리일자취급사원번호적격여부1(업무처리규정59조1항충족)적격여부2(물적담보의충분성)적격여부3(특별한사정존재)적격여부4(요청서수취)유보기한유보기간
90RTHO2017000694201914019012019-12-1712019-12-18112712019-12-171193621752018-01-03<NA><NA><NA>111355A11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03THO<NA>2019-12-171641<NA><NA><NA><NA><NA>0
91RTAA2016000501201914019022019-12-1732019-12-17127612019-12-171108227402016-07-01<NA><NA><NA>40785C11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>0<NA>TAA<NA>2019-12-171410YYYY2020-08-178
92RTLA2014000011201914019032019-12-1712019-12-18127812019-12-17962597962014-02-17<NA><NA><NA>113340A11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TLA<NA>2019-12-171638<NA><NA><NA><NA><NA>0
93RTAA2016000661201914019072019-12-1712019-12-18131612019-12-171120192502016-08-29<NA><NA><NA>206710A12<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAA<NA>2019-12-171866<NA><NA><NA><NA><NA>0
94RQAD2014000019201914019092019-12-1712019-12-18124112019-12-17960597762014-01-21<NA><NA><NA>883214A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03QAD<NA>2019-12-171406<NA><NA><NA><NA><NA>0
95RTAA2009000075201914019112019-12-1712019-12-18125812019-12-17741798272009-04-16<NA><NA><NA>31079A11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAC<NA>2019-12-171932<NA><NA><NA><NA><NA>0
96RTAC2015000744201914019122019-12-1712019-12-18125812019-12-171088008842015-12-29<NA><NA><NA>40471A12<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TAC<NA>2019-12-171932<NA><NA><NA><NA><NA>0
97RTOA2019000130201914019102019-12-1712019-12-18112212019-12-171283288832019-05-14<NA><NA><NA>67797A21<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03TOA<NA>2019-12-171676<NA><NA><NA><NA><NA>0
98RTHA2017000838201914019082019-12-1722019-12-17117312019-12-171193022612017-12-29<NA><NA><NA>203904B11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03THA<NA>2019-12-171174<NA><NA><NA><NA><NA>0
99RTHA2012000096201914019062019-12-1712019-12-19108912019-12-18858940652012-02-28<NA><NA><NA>42275A11<NA>0<NA>0<NA>0<NA>0<NA>0<NA>03THA<NA>2019-12-171569<NA><NA><NA><NA><NA>0