Overview

Dataset statistics

Number of variables11
Number of observations10000
Missing cells1440
Missing cells (%)1.3%
Duplicate rows315
Duplicate rows (%)3.1%
Total size in memory937.5 KiB
Average record size in memory96.0 B

Variable types

Categorical3
Boolean7
DateTime1

Dataset

Description한국자산관리공사 행복기금 신청 접수 정보 데이터
Author한국자산관리공사
URLhttps://www.data.go.kr/data/15069812/fileData.do

Alerts

상담존재여부 has constant value ""Constant
약정공인존재여부 has constant value ""Constant
CB정보존재여부 has constant value ""Constant
CB대출정보존재여부 has constant value ""Constant
CB전문존재여부 has constant value ""Constant
신고재산등록여부 has constant value ""Constant
계좌제외등록여부 has constant value ""Constant
Dataset has 315 (3.1%) duplicate rowsDuplicates
접수처 is highly imbalanced (70.6%)Imbalance
채무조정신청일자 has 1440 (14.4%) missing valuesMissing

Reproduction

Analysis started2023-12-12 09:37:50.159588
Analysis finished2023-12-12 09:37:51.075909
Duration0.92 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

신청일자
Categorical

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2013-04-22
2070 
2013-04-29
1567 
2013-04-23
1536 
2013-04-30
1446 
2013-04-24
1244 
Other values (4)
2137 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2013-04-29
2nd row2013-04-24
3rd row2013-04-30
4th row2013-04-22
5th row2013-04-23

Common Values

ValueCountFrequency (%)
2013-04-22 2070
20.7%
2013-04-29 1567
15.7%
2013-04-23 1536
15.4%
2013-04-30 1446
14.5%
2013-04-24 1244
12.4%
2013-04-25 1000
10.0%
2013-04-26 899
9.0%
2013-04-28 147
 
1.5%
2013-04-27 91
 
0.9%

Length

2023-12-12T18:37:51.150370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:37:51.293834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2013-04-22 2070
20.7%
2013-04-29 1567
15.7%
2013-04-23 1536
15.4%
2013-04-30 1446
14.5%
2013-04-24 1244
12.4%
2013-04-25 1000
10.0%
2013-04-26 899
9.0%
2013-04-28 147
 
1.5%
2013-04-27 91
 
0.9%

신청창구
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
인터넷
4448 
공사
1871 
농협은행
1469 
국민은행
1410 
신복위
802 

Length

Max length4
Median length3
Mean length3.1008
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row국민은행
2nd row인터넷
3rd row농협은행
4th row인터넷
5th row농협은행

Common Values

ValueCountFrequency (%)
인터넷 4448
44.5%
공사 1871
18.7%
농협은행 1469
 
14.7%
국민은행 1410
 
14.1%
신복위 802
 
8.0%

Length

2023-12-12T18:37:51.488117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:37:51.627236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인터넷 4448
44.5%
공사 1871
18.7%
농협은행 1469
 
14.7%
국민은행 1410
 
14.1%
신복위 802
 
8.0%

접수처
Categorical

IMBALANCE 

Distinct40
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기타
8101 
서민금융총괄부
 
307
부산지역본부
 
165
대구경북지역본부
 
148
전북지역본부
 
106
Other values (35)
1173 

Length

Max length8
Median length2
Mean length2.8335
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row기타
2nd row기타
3rd row기타
4th row기타
5th row기타

Common Values

ValueCountFrequency (%)
기타 8101
81.0%
서민금융총괄부 307
 
3.1%
부산지역본부 165
 
1.7%
대구경북지역본부 148
 
1.5%
전북지역본부 106
 
1.1%
광주전남지역본부 97
 
1.0%
경기지역본부 93
 
0.9%
대전충남지역본부 93
 
0.9%
인천지역본부 93
 
0.9%
충북지역본부 71
 
0.7%
Other values (30) 726
 
7.3%

Length

2023-12-12T18:37:51.789867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타 8101
81.0%
서민금융총괄부 307
 
3.1%
부산지역본부 165
 
1.7%
대구경북지역본부 148
 
1.5%
전북지역본부 106
 
1.1%
광주전남지역본부 97
 
1.0%
경기지역본부 93
 
0.9%
대전충남지역본부 93
 
0.9%
인천지역본부 93
 
0.9%
경남지역본부 71
 
0.7%
Other values (30) 726
 
7.3%

상담존재여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2023-12-12T18:37:51.915350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

약정공인존재여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2023-12-12T18:37:52.038702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

CB정보존재여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2023-12-12T18:37:52.116802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

CB대출정보존재여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2023-12-12T18:37:52.207732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

CB전문존재여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2023-12-12T18:37:52.320196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

신고재산등록여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2023-12-12T18:37:52.420057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

계좌제외등록여부
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
10000 
ValueCountFrequency (%)
False 10000
100.0%
2023-12-12T18:37:52.521600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

채무조정신청일자
Date

MISSING 

Distinct83
Distinct (%)1.0%
Missing1440
Missing (%)14.4%
Memory size156.2 KiB
Minimum2013-04-22 00:00:00
Maximum2014-05-13 00:00:00
2023-12-12T18:37:52.645082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:37:52.833390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2023-12-12T18:37:52.982470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청일자신청창구접수처채무조정신청일자
신청일자1.0000.3350.1290.993
신청창구0.3351.0000.7990.370
접수처0.1290.7991.0000.139
채무조정신청일자0.9930.3700.1391.000
2023-12-12T18:37:53.105428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청창구신청일자접수처
신청창구1.0000.2010.487
신청일자0.2011.0000.047
접수처0.4870.0471.000
2023-12-12T18:37:53.224098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청일자신청창구접수처
신청일자1.0000.2010.047
신청창구0.2011.0000.487
접수처0.0470.4871.000

Missing values

2023-12-12T18:37:50.804425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:37:50.974478image/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

신청일자신청창구접수처상담존재여부약정공인존재여부CB정보존재여부CB대출정보존재여부CB전문존재여부신고재산등록여부계좌제외등록여부채무조정신청일자
530112013-04-29국민은행기타NNNNNNN2013-04-29
242562013-04-24인터넷기타NNNNNNN2013-04-24
594982013-04-30농협은행기타NNNNNNN2013-04-30
126612013-04-22인터넷기타NNNNNNN2013-04-22
187422013-04-23농협은행기타NNNNNNN2013-04-23
289832013-04-24국민은행기타NNNNNNN2013-04-24
700852013-04-22인터넷기타NNNNNNN2013-04-30
743862013-04-25신복위기타NNNNNNN2013-04-25
599822013-04-30공사인천지역본부NNNNNNN2013-04-30
395202013-04-26농협은행기타NNNNNNN2013-04-26
신청일자신청창구접수처상담존재여부약정공인존재여부CB정보존재여부CB대출정보존재여부CB전문존재여부신고재산등록여부계좌제외등록여부채무조정신청일자
596502013-04-30국민은행기타NNNNNNN2013-04-30
627712013-04-30공사의정부역NNNNNNN2013-04-30
214642013-04-23인터넷기타NNNNNNN<NA>
729802013-04-22인터넷기타NNNNNNN2013-04-22
673972013-04-22인터넷기타NNNNNNN2013-04-22
549902013-04-29농협은행기타NNNNNNN2013-04-29
373692013-04-25농협은행기타NNNNNNN2013-04-25
271402013-04-24농협은행기타NNNNNNN2013-04-24
809172013-04-29국민은행기타NNNNNNN2013-04-29
449722013-04-26공사제주지방사무소NNNNNNN2013-04-26

Duplicate rows

Most frequently occurring

신청일자신청창구접수처상담존재여부약정공인존재여부CB정보존재여부CB대출정보존재여부CB전문존재여부신고재산등록여부계좌제외등록여부채무조정신청일자# duplicates
382013-04-22인터넷기타NNNNNNN2013-04-22777
512013-04-22인터넷기타NNNNNNN<NA>520
932013-04-23인터넷기타NNNNNNN2013-04-23463
2732013-04-29인터넷기타NNNNNNN2013-04-29335
3072013-04-30국민은행기타NNNNNNN2013-04-30332
3092013-04-30농협은행기타NNNNNNN2013-04-30318
2682013-04-29농협은행기타NNNNNNN2013-04-29317
1412013-04-24인터넷기타NNNNNNN2013-04-24291
2662013-04-29국민은행기타NNNNNNN2013-04-29287
3132013-04-30인터넷기타NNNNNNN2013-04-30252