Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells30
Missing cells (%)0.1%
Duplicate rows1190
Duplicate rows (%)11.9%
Total size in memory400.4 KiB
Average record size in memory41.0 B

Variable types

DateTime2
Categorical1
Numeric1

Dataset

Description한국자산관리공사 희망모아의 채무조정 명세 데이터로 "약정일자","완제해지일자","채무조정구분","관련계좌수" 항목을 제공합니다.
Author한국자산관리공사
URLhttps://www.data.go.kr/data/15095234/fileData.do

Alerts

Dataset has 1190 (11.9%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 19:44:39.382034
Analysis finished2023-12-12 19:44:39.878874
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약정일자
Date

Distinct443
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2018-01-31 00:00:00
Maximum2020-04-03 00:00:00
2023-12-13T04:44:39.975226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:44:40.150522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

완제해지일자
Date

Distinct389
Distinct (%)3.9%
Missing30
Missing (%)0.3%
Memory size156.2 KiB
Minimum2018-01-31 00:00:00
Maximum2020-07-06 00:00:00
2023-12-13T04:44:40.322118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:44:40.530176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

채무조정구분
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
신복위
5065 
희망모아
4416 
개인회생
519 

Length

Max length4
Median length3
Mean length3.4935
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row희망모아
2nd row신복위
3rd row신복위
4th row희망모아
5th row희망모아

Common Values

ValueCountFrequency (%)
신복위 5065
50.6%
희망모아 4416
44.2%
개인회생 519
 
5.2%

Length

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

Common Values (Plot)

2023-12-13T04:44:40.892969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
신복위 5065
50.6%
희망모아 4416
44.2%
개인회생 519
 
5.2%

관련계좌수
Real number (ℝ)

Distinct18
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.42
Minimum1
Maximum24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T04:44:41.010698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q33
95-th percentile7
Maximum24
Range23
Interquartile range (IQR)2

Descriptive statistics

Standard deviation2.2751083
Coefficient of variation (CV)0.94012738
Kurtosis4.3039586
Mean2.42
Median Absolute Deviation (MAD)0
Skewness1.9496687
Sum24200
Variance5.1761176
MonotonicityNot monotonic
2023-12-13T04:44:41.188281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
1 5874
58.7%
2 939
 
9.4%
3 860
 
8.6%
4 683
 
6.8%
5 553
 
5.5%
6 386
 
3.9%
7 246
 
2.5%
8 169
 
1.7%
9 110
 
1.1%
10 88
 
0.9%
Other values (8) 92
 
0.9%
ValueCountFrequency (%)
1 5874
58.7%
2 939
 
9.4%
3 860
 
8.6%
4 683
 
6.8%
5 553
 
5.5%
6 386
 
3.9%
7 246
 
2.5%
8 169
 
1.7%
9 110
 
1.1%
10 88
 
0.9%
ValueCountFrequency (%)
24 1
 
< 0.1%
17 2
 
< 0.1%
16 1
 
< 0.1%
15 3
 
< 0.1%
14 2
 
< 0.1%
13 14
 
0.1%
12 23
 
0.2%
11 46
0.5%
10 88
0.9%
9 110
1.1%

Interactions

2023-12-13T04:44:39.572846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:44:41.298347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
채무조정구분관련계좌수
채무조정구분1.0000.529
관련계좌수0.5291.000
2023-12-13T04:44:41.425605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관련계좌수채무조정구분
관련계좌수1.0000.395
채무조정구분0.3951.000

Missing values

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

약정일자완제해지일자채무조정구분관련계좌수
131492018-11-012019-03-15희망모아1
90112018-07-032019-03-15신복위1
27242018-03-022019-03-15신복위1
101092018-08-032018-08-03희망모아4
77962018-06-012019-03-15희망모아8
54502018-04-102019-10-29신복위1
120652018-09-282019-03-15신복위1
24562018-02-282018-02-28희망모아1
132492018-11-052018-11-12희망모아3
4172018-02-062019-03-15신복위1
약정일자완제해지일자채무조정구분관련계좌수
104212018-08-102019-03-15신복위1
140772018-12-042019-03-15신복위1
56032018-04-132019-03-15신복위1
170792019-06-212019-10-29희망모아3
128632018-10-252019-02-08희망모아1
158722019-02-112019-03-14신복위1
170042019-05-03<NA>신복위1
47862018-03-302018-04-06신복위1
78862018-06-052019-03-15신복위1
30202018-03-092018-04-06신복위1

Duplicate rows

Most frequently occurring

약정일자완제해지일자채무조정구분관련계좌수# duplicates
3392018-04-242019-03-15신복위184
1332018-02-272019-03-15신복위175
4112018-05-182019-03-15신복위167
4812018-06-152019-03-15신복위163
572018-02-132018-04-05신복위161
1612018-03-022019-03-15신복위161
1772018-03-092019-03-15신복위161
2812018-03-302019-03-15신복위159
2252018-03-232019-03-15신복위158
2432018-03-272019-03-15신복위158