Overview

Dataset statistics

Number of variables8
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory703.1 KiB
Average record size in memory72.0 B

Variable types

Text1
DateTime2
Categorical5

Dataset

Description내일채움공제 가입대상자 중 만기가 도래하여 신청 및 승인된 가입자 데이터로 청약번호, 만기접수일, 만기승인일, 만기금 지급상태, 은행코드, 상세상품을 제공합니다
Author중소벤처기업진흥공단
URLhttps://www.data.go.kr/data/15112944/fileData.do

Alerts

만기상태코드 is highly overall correlated with 만기수령방법코드High correlation
만기수령방법코드 is highly overall correlated with 만기상태코드High correlation
만기상태코드 is highly imbalanced (97.0%)Imbalance
만기수령방법코드 is highly imbalanced (99.0%)Imbalance
연계이전 청약번호 is highly imbalanced (98.9%)Imbalance
상세상품 is highly imbalanced (59.1%)Imbalance
청약번호 has unique valuesUnique

Reproduction

Analysis started2024-04-17 14:45:33.969587
Analysis finished2024-04-17 14:45:34.773215
Duration0.8 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

청약번호
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-17T23:45:34.939768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique

Unique10000 ?
Unique (%)100.0%

Sample

1st row2018-10-4727
2nd row2019-02-1604
3rd row2019-02-2730
4th row2018-10-3441
5th row2018-01-0037
ValueCountFrequency (%)
2018-10-4727 1
 
< 0.1%
2018-06-4901 1
 
< 0.1%
2018-08-3313 1
 
< 0.1%
2018-07-6405 1
 
< 0.1%
2018-12-0640 1
 
< 0.1%
2018-10-4148 1
 
< 0.1%
2019-01-0499 1
 
< 0.1%
2019-01-5605 1
 
< 0.1%
2019-01-7143 1
 
< 0.1%
2015-11-0088 1
 
< 0.1%
Other values (9990) 9990
99.9%
2024-04-17T23:45:35.250815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 26186
21.8%
- 20000
16.7%
1 19686
16.4%
2 15508
12.9%
8 9475
 
7.9%
7 5098
 
4.2%
5 5076
 
4.2%
6 4988
 
4.2%
3 4740
 
4.0%
9 4527
 
3.8%
Other values (3) 4716
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 99808
83.2%
Dash Punctuation 20000
 
16.7%
Uppercase Letter 192
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 26186
26.2%
1 19686
19.7%
2 15508
15.5%
8 9475
 
9.5%
7 5098
 
5.1%
5 5076
 
5.1%
6 4988
 
5.0%
3 4740
 
4.7%
9 4527
 
4.5%
4 4524
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
G 96
50.0%
W 96
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 20000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 119808
99.8%
Latin 192
 
0.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 26186
21.9%
- 20000
16.7%
1 19686
16.4%
2 15508
12.9%
8 9475
 
7.9%
7 5098
 
4.3%
5 5076
 
4.2%
6 4988
 
4.2%
3 4740
 
4.0%
9 4527
 
3.8%
Latin
ValueCountFrequency (%)
G 96
50.0%
W 96
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 120000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 26186
21.8%
- 20000
16.7%
1 19686
16.4%
2 15508
12.9%
8 9475
 
7.9%
7 5098
 
4.2%
5 5076
 
4.2%
6 4988
 
4.2%
3 4740
 
4.0%
9 4527
 
3.8%
Other values (3) 4716
 
3.9%

만기접수일자
Date

Distinct1116
Distinct (%)11.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2019-09-05 00:00:00
Maximum2024-03-05 00:00:00
2024-04-17T23:45:35.366557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T23:45:35.488756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

만기접수 승인일시
Date

Distinct905
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2019-09-06 00:00:00
Maximum2024-03-11 00:00:00
2024-04-17T23:45:35.591407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T23:45:35.693054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

만기상태코드
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
지급완료
9969 
승인
 
31

Length

Max length4
Median length4
Mean length3.9938
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row지급완료
2nd row지급완료
3rd row지급완료
4th row지급완료
5th row지급완료

Common Values

ValueCountFrequency (%)
지급완료 9969
99.7%
승인 31
 
0.3%

Length

2024-04-17T23:45:35.802411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T23:45:35.882636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
지급완료 9969
99.7%
승인 31
 
0.3%

핵심인력거래은행코드
Categorical

Distinct19
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기업은행
3193 
국민은행
1807 
신한은행
1247 
우리은행
1172 
농협은행
1131 
Other values (14)
1450 

Length

Max length8
Median length4
Mean length4.2841
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기업은행
2nd row기업은행
3rd row국민은행
4th row국민은행
5th row국민은행

Common Values

ValueCountFrequency (%)
기업은행 3193
31.9%
국민은행 1807
18.1%
신한은행 1247
 
12.5%
우리은행 1172
 
11.7%
농협은행 1131
 
11.3%
KEB 하나은행 683
 
6.8%
대구은행 168
 
1.7%
경남은행 145
 
1.5%
부산은행 131
 
1.3%
SC제일은행 71
 
0.7%
Other values (9) 252
 
2.5%

Length

2024-04-17T23:45:35.964811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기업은행 3193
29.9%
국민은행 1807
16.9%
신한은행 1247
 
11.7%
우리은행 1172
 
11.0%
농협은행 1131
 
10.6%
keb 683
 
6.4%
하나은행 683
 
6.4%
대구은행 168
 
1.6%
경남은행 145
 
1.4%
부산은행 131
 
1.2%
Other values (10) 323
 
3.0%

만기수령방법코드
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일시수령
9991 
분할수령
 
9

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일시수령
2nd row일시수령
3rd row일시수령
4th row일시수령
5th row일시수령

Common Values

ValueCountFrequency (%)
일시수령 9991
99.9%
분할수령 9
 
0.1%

Length

2024-04-17T23:45:36.052691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T23:45:36.120887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일시수령 9991
99.9%
분할수령 9
 
0.1%

연계이전 청약번호
Categorical

IMBALANCE 

Distinct43
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
해당사항 없음
9958 
2015-05-0384
 
1
EL18-16-1328
 
1
EL18-01-3841
 
1
EL17-07-0130
 
1
Other values (38)
 
38

Length

Max length12
Median length7
Mean length7.021
Min length7

Unique

Unique42 ?
Unique (%)0.4%

Sample

1st row해당사항 없음
2nd row해당사항 없음
3rd row해당사항 없음
4th row해당사항 없음
5th row해당사항 없음

Common Values

ValueCountFrequency (%)
해당사항 없음 9958
99.6%
2015-05-0384 1
 
< 0.1%
EL18-16-1328 1
 
< 0.1%
EL18-01-3841 1
 
< 0.1%
EL17-07-0130 1
 
< 0.1%
2015-10-0538 1
 
< 0.1%
2016-01-0116 1
 
< 0.1%
2015-03-0149 1
 
< 0.1%
2015-01-0070 1
 
< 0.1%
EL19-01-1434 1
 
< 0.1%
Other values (33) 33
 
0.3%

Length

2024-04-17T23:45:36.198420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
해당사항 9958
49.9%
없음 9958
49.9%
2015-05-0048 1
 
< 0.1%
el18-04-7881 1
 
< 0.1%
el18-07-4993 1
 
< 0.1%
el18-11-9199 1
 
< 0.1%
el18-07-8707 1
 
< 0.1%
2015-02-0314 1
 
< 0.1%
2015-01-0075 1
 
< 0.1%
el18-04-4698 1
 
< 0.1%
Other values (34) 34
 
0.2%

상세상품
Categorical

IMBALANCE 

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
청년재직자 내일채움공제
6140 
내일채움공제
3305 
금융내일채움
 
337
안심
 
49
강원내일채움공제
 
47
Other values (4)
 
122

Length

Max length12
Median length12
Mean length9.7201
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row청년재직자 내일채움공제
2nd row청년재직자 내일채움공제
3rd row청년재직자 내일채움공제
4th row청년재직자 내일채움공제
5th row내일채움공제

Common Values

ValueCountFrequency (%)
청년재직자 내일채움공제 6140
61.4%
내일채움공제 3305
33.1%
금융내일채움 337
 
3.4%
안심 49
 
0.5%
강원내일채움공제 47
 
0.5%
제주도 내일채움공제 44
 
0.4%
내일채움(연계/재가입) 42
 
0.4%
대전시내일채움 35
 
0.4%
CJ제일제당 1
 
< 0.1%

Length

2024-04-17T23:45:36.290685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T23:45:36.385226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
내일채움공제 9489
58.6%
청년재직자 6140
37.9%
금융내일채움 337
 
2.1%
안심 49
 
0.3%
강원내일채움공제 47
 
0.3%
제주도 44
 
0.3%
내일채움(연계/재가입 42
 
0.3%
대전시내일채움 35
 
0.2%
cj제일제당 1
 
< 0.1%

Correlations

2024-04-17T23:45:36.465658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
만기상태코드핵심인력거래은행코드만기수령방법코드연계이전 청약번호상세상품
만기상태코드1.0000.0000.7160.2010.000
핵심인력거래은행코드0.0001.0000.0230.0000.387
만기수령방법코드0.7160.0231.0000.0000.022
연계이전 청약번호0.2010.0000.0001.0000.711
상세상품0.0000.3870.0220.7111.000
2024-04-17T23:45:36.545735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
만기수령방법코드연계이전 청약번호핵심인력거래은행코드상세상품만기상태코드
만기수령방법코드1.0000.0000.0200.0220.508
연계이전 청약번호0.0001.0000.0000.3480.167
핵심인력거래은행코드0.0200.0001.0000.1620.000
상세상품0.0220.3480.1621.0000.000
만기상태코드0.5080.1670.0000.0001.000
2024-04-17T23:45:36.625323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
만기상태코드핵심인력거래은행코드만기수령방법코드연계이전 청약번호상세상품
만기상태코드1.0000.0000.5080.1670.000
핵심인력거래은행코드0.0001.0000.0200.0000.162
만기수령방법코드0.5080.0201.0000.0000.022
연계이전 청약번호0.1670.0000.0001.0000.348
상세상품0.0000.1620.0220.3481.000

Missing values

2024-04-17T23:45:34.625911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T23:45:34.725166image/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

청약번호만기접수일자만기접수 승인일시만기상태코드핵심인력거래은행코드만기수령방법코드연계이전 청약번호상세상품
257562018-10-47272023-10-262023-11-01지급완료기업은행일시수령해당사항 없음청년재직자 내일채움공제
345962019-02-16042024-02-252024-02-27지급완료기업은행일시수령해당사항 없음청년재직자 내일채움공제
347982019-02-27302024-02-192024-02-23지급완료국민은행일시수령해당사항 없음청년재직자 내일채움공제
252052018-10-34412023-10-252023-10-27지급완료국민은행일시수령해당사항 없음청년재직자 내일채움공제
109372018-01-00372023-01-172023-01-17지급완료국민은행일시수령해당사항 없음내일채움공제
334132019-01-52282024-02-072024-02-15지급완료국민은행일시수령해당사항 없음내일채움공제
7932014-11-00632019-12-052019-12-17지급완료농협은행일시수령해당사항 없음내일채움공제
176862018-07-31472023-08-212023-08-24지급완료국민은행일시수령해당사항 없음청년재직자 내일채움공제
127882018-05-06902023-06-062023-06-08지급완료국민은행일시수령해당사항 없음내일채움공제
63092016-08-01982021-09-062021-09-08지급완료경남은행일시수령해당사항 없음내일채움공제
청약번호만기접수일자만기접수 승인일시만기상태코드핵심인력거래은행코드만기수령방법코드연계이전 청약번호상세상품
307562018-12-40662024-01-152024-01-22지급완료국민은행일시수령해당사항 없음청년재직자 내일채움공제
350862020-12-10872024-02-232024-02-26지급완료기업은행일시수령2015-11-0244내일채움(연계/재가입)
227782018-09-17832023-10-182023-10-23지급완료국민은행일시수령해당사항 없음청년재직자 내일채움공제
105342017-11-05522022-11-282022-11-28지급완료농협은행일시수령해당사항 없음내일채움공제
238442018-10-03252023-11-022023-11-07지급완료신한은행일시수령해당사항 없음청년재직자 내일채움공제
237132018-10-00582023-11-062023-11-09지급완료기업은행일시수령해당사항 없음내일채움공제
299092018-12-24622023-12-272024-01-09지급완료우리은행일시수령해당사항 없음청년재직자 내일채움공제
231522018-09-26832023-10-262023-11-02지급완료국민은행일시수령해당사항 없음내일채움공제
81622017-03-12112022-05-022022-05-03지급완료기업은행일시수령해당사항 없음내일채움공제
123532018-04-05882023-05-082023-05-08지급완료신한은행일시수령해당사항 없음내일채움공제