gimi9 Pandas Profiling

Dataset statistics

Number of variables	20
Number of observations	500
Missing cells	58
Missing cells (%)	0.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	81.7 KiB
Average record size in memory	167.3 B

Variable types

Categorical	10
Text	2
Numeric	7
Boolean	1

Dataset

Description	해당 파일 데이터는 신용보증기금의 보증고객창업기업정보에 대해 확인하실 수 있는 자료이니 데이터 활용에 참고하여 주시기 바랍니다.
Author	신용보증기금
URL	https://www.data.go.kr/data/15092890/fileData.do

Alerts

`업무구분코드` has constant value ""	Constant
`성과공유금액유예기한` has constant value ""	Constant
`삭제여부` has constant value ""	Constant
`성과공유금액최초납부기한` is highly overall correlated with `한도설정금액` and 5 other fields	High correlation
`최초처리시각` is highly overall correlated with `최초처리직원번호`	High correlation
`성과공유금액분납신청여부` is highly overall correlated with `한도설정금액` and 5 other fields	High correlation
`최초처리직원번호` is highly overall correlated with `최초처리시각`	High correlation
`4기평가년도` is highly overall correlated with `5기평가년도`	High correlation
`5기평가년도` is highly overall correlated with `4기평가년도`	High correlation
`한도설정금액` is highly overall correlated with `건별발급금액` and 4 other fields	High correlation
`건별발급금액` is highly overall correlated with `한도설정금액` and 2 other fields	High correlation
`성과공유금액납부예정금액` is highly overall correlated with `한도설정금액` and 4 other fields	High correlation
`성과공유금액약정체결여부` is highly overall correlated with `중단일자` and 2 other fields	High correlation
`성과공유금액약정체결사유코드` is highly overall correlated with `중단일자`	High correlation
`중단일자` is highly overall correlated with `한도설정금액` and 4 other fields	High correlation
`성과공유금액분납예정일자` is highly overall correlated with `성과공유금액납부예정금액` and 1 other fields	High correlation
`성과공유금액약정체결여부` is highly imbalanced (51.4%)	Imbalance
`성과공유금액약정체결사유코드` is highly imbalanced (54.6%)	Imbalance
`성과공유금액분납예정일자` is highly imbalanced (68.9%)	Imbalance
`최초처리시각` is highly imbalanced (84.0%)	Imbalance
`최초처리직원번호` is highly imbalanced (83.8%)	Imbalance
`4기평가년도` has 29 (5.8%) missing values	Missing
`5기평가년도` has 29 (5.8%) missing values	Missing
`원장번호` has unique values	Unique
`한도설정금액` has 159 (31.8%) zeros	Zeros
`건별발급금액` has 159 (31.8%) zeros	Zeros
`성과공유금액납부예정금액` has 159 (31.8%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 00:29:28.054165
Analysis finished	2023-12-12 00:29:34.440876
Duration	6.39 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

업무구분코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

G	500

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
G	500	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
g	500	100.0%

원장번호
Text

UNIQUE

Distinct	500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	6000
Distinct characters	35
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	500 ?
Unique (%)	100.0%

Sample

1st row	TIF200700832
2nd row	IIA200801114
3rd row	THZ200801078
4th row	TIE200800236
5th row	TAQ201200149

Value	Count	Frequency (%)
tif200700832	1	0.2%
tat200701415	1	0.2%
tbk201000252	1	0.2%
tqa201100021	1	0.2%
thi200701012	1	0.2%
thu200800654	1	0.2%
tal201001990	1	0.2%
thn201100351	1	0.2%
ipa200800210	1	0.2%
iaa200800315	1	0.2%
Other values (490)	490	98.0%

Most occurring characters

Value	Count	Frequency (%)
0	2084	34.7%
2	668	11.1%
8	399	6.7%
T	324	5.4%
A	295	4.9%
7	292	4.9%
1	288	4.8%
I	269	4.5%
9	161	2.7%
4	159	2.6%
Other values (25)	1061	17.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4500	75.0%
Uppercase Letter	1500	25.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	324	21.6%
A	295	19.7%
I	269	17.9%
H	115	7.7%
P	69	4.6%
B	63	4.2%
C	50	3.3%
Q	42	2.8%
D	33	2.2%
N	32	2.1%
Other values (15)	208	13.9%

Decimal Number

Value	Count	Frequency (%)
0	2084	46.3%
2	668	14.8%
8	399	8.9%
7	292	6.5%
1	288	6.4%
9	161	3.6%
4	159	3.5%
3	157	3.5%
6	147	3.3%
5	145	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	4500	75.0%
Latin	1500	25.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	324	21.6%
A	295	19.7%
I	269	17.9%
H	115	7.7%
P	69	4.6%
B	63	4.2%
C	50	3.3%
Q	42	2.8%
D	33	2.2%
N	32	2.1%
Other values (15)	208	13.9%

Common

Value	Count	Frequency (%)
0	2084	46.3%
2	668	14.8%
8	399	8.9%
7	292	6.5%
1	288	6.4%
9	161	3.6%
4	159	3.5%
3	157	3.5%
6	147	3.3%
5	145	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2084	34.7%
2	668	11.1%
8	399	6.7%
T	324	5.4%
A	295	4.9%
7	292	4.9%
1	288	4.8%
I	269	4.5%
9	161	2.7%
4	159	2.6%
Other values (25)	1061	17.7%

성과공유금액약정체결여부
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Y	402
N	93
	5

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Y
2nd row	Y
3rd row	Y
4th row	N
5th row

Common Values

Value	Count	Frequency (%)
Y	402	80.4%
N	93	18.6%
	5	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
y	402	81.2%
n	93	18.8%

성과공유금액약정체결사유코드
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

1	418
	74
2	8

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	418	83.6%
	74	14.8%
2	8	1.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	418	98.1%
2	8	1.9%

4기평가년도
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	8
Distinct (%)	1.7%
Missing	29
Missing (%)	5.8%
Infinite	0
Infinite (%)	0.0%
Mean	2010.845

Minimum	2009
Maximum	2016
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	2009
5-th percentile	2010
Q1	2010
median	2011
Q3	2011
95-th percentile	2012
Maximum	2016
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.86256147
Coefficient of variation (CV)	0.00042895473
Kurtosis	8.8657235
Mean	2010.845
Median Absolute Deviation (MAD)	0
Skewness	2.1620037
Sum	947108
Variance	0.74401229
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2011	283	56.6%
2010	143	28.6%
2012	21	4.2%
2013	9	1.8%
2014	7	1.4%
2009	4	0.8%
2015	2	0.4%
2016	2	0.4%
(Missing)	29	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	4	0.8%
2010	143	28.6%
2011	283	56.6%
2012	21	4.2%
2013	9	1.8%
2014	7	1.4%
2015	2	0.4%
2016	2	0.4%

Value	Count	Frequency (%)
2016	2	0.4%
2015	2	0.4%
2014	7	1.4%
2013	9	1.8%
2012	21	4.2%
2011	283	56.6%
2010	143	28.6%
2009	4	0.8%

5기평가년도
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	8
Distinct (%)	1.7%
Missing	29
Missing (%)	5.8%
Infinite	0
Infinite (%)	0.0%
Mean	2011.845

Minimum	2010
Maximum	2017
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	2010
5-th percentile	2011
Q1	2011
median	2012
Q3	2012
95-th percentile	2013
Maximum	2017
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.86256147
Coefficient of variation (CV)	0.00042874151
Kurtosis	8.8657235
Mean	2011.845
Median Absolute Deviation (MAD)	0
Skewness	2.1620037
Sum	947579
Variance	0.74401229
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2012	283	56.6%
2011	143	28.6%
2013	21	4.2%
2014	9	1.8%
2015	7	1.4%
2010	4	0.8%
2016	2	0.4%
2017	2	0.4%
(Missing)	29	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	4	0.8%
2011	143	28.6%
2012	283	56.6%
2013	21	4.2%
2014	9	1.8%
2015	7	1.4%
2016	2	0.4%
2017	2	0.4%

Value	Count	Frequency (%)
2017	2	0.4%
2016	2	0.4%
2015	7	1.4%
2014	9	1.8%
2013	21	4.2%
2012	283	56.6%
2011	143	28.6%
2010	4	0.8%

중단일자
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

0001-01-01 00:00:00.000000	437
00:00.0	63

Length

Max length	26
Median length	26
Mean length	23.606
Min length	7

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0001-01-01 00:00:00.000000
2nd row	0001-01-01 00:00:00.000000
3rd row	0001-01-01 00:00:00.000000
4th row	00:00.0
5th row	0001-01-01 00:00:00.000000

Common Values

Value	Count	Frequency (%)
0001-01-01 00:00:00.000000	437	87.4%
00:00.0	63	12.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0001-01-01	437	46.6%
00:00:00.000000	437	46.6%
00:00.0	63	6.7%

한도설정금액
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	27
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.06588 × 10⁸

Minimum	0
Maximum	5 × 10⁸
Zeros	159
Zeros (%)	31.8%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2.07 × 10⁸
Q3	3 × 10⁸
95-th percentile	5 × 10⁸
Maximum	5 × 10⁸
Range	5 × 10⁸
Interquartile range (IQR)	3 × 10⁸

Descriptive statistics

Standard deviation	1.7311214 × 10⁸
Coefficient of variation (CV)	0.83795836
Kurtosis	-1.1219059
Mean	2.06588 × 10⁸
Median Absolute Deviation (MAD)	1.07 × 10⁸
Skewness	0.2036442
Sum	1.03294 × 10¹¹
Variance	2.9967814 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	159	31.8%
300000000	153	30.6%
500000000	68	13.6%
200000000	39	7.8%
150000000	25	5.0%
100000000	17	3.4%
250000000	9	1.8%
450000000	4	0.8%
400000000	3	0.6%
60000000	2	0.4%
Other values (17)	21	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	159	31.8%
50000000	2	0.4%
60000000	2	0.4%
80000000	1	0.2%
100000000	17	3.4%
130000000	2	0.4%
135000000	1	0.2%
150000000	25	5.0%
170000000	1	0.2%
175000000	1	0.2%

Value	Count	Frequency (%)
500000000	68	13.6%
470000000	1	0.2%
461000000	1	0.2%
450000000	4	0.8%
405000000	1	0.2%
400000000	3	0.6%
360000000	1	0.2%
300000000	153	30.6%
282000000	1	0.2%
257000000	1	0.2%

건별발급금액
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	178
Distinct (%)	35.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3491965 × 10⁸

Minimum	0
Maximum	1.375825 × 10⁹
Zeros	159
Zeros (%)	31.8%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	90000000
Q3	2 × 10⁸
95-th percentile	4.808625 × 10⁸
Maximum	1.375825 × 10⁹
Range	1.375825 × 10⁹
Interquartile range (IQR)	2 × 10⁸

Descriptive statistics

Standard deviation	1.6295354 × 10⁸
Coefficient of variation (CV)	1.2077821
Kurtosis	8.3195017
Mean	1.3491965 × 10⁸
Median Absolute Deviation (MAD)	90000000
Skewness	2.1401311
Sum	6.7459825 × 10¹⁰
Variance	2.6553855 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	159	31.8%
100000000	23	4.6%
300000000	21	4.2%
90000000	17	3.4%
50000000	15	3.0%
45000000	10	2.0%
200000000	10	2.0%
180000000	7	1.4%
190000000	7	1.4%
150000000	6	1.2%
Other values (168)	225	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	159	31.8%
9000000	1	0.2%
13500000	1	0.2%
17000000	1	0.2%
18000000	1	0.2%
19550000	1	0.2%
23000000	1	0.2%
27000000	3	0.6%
30000000	4	0.8%
31500000	1	0.2%

Value	Count	Frequency (%)
1375825000	1	0.2%
900000000	1	0.2%
864000000	1	0.2%
732500000	1	0.2%
699500000	1	0.2%
600000000	2	0.4%
597500000	1	0.2%
578000000	1	0.2%
558000000	1	0.2%
540500000	1	0.2%

성과공유금액납부예정금액
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	147
Distinct (%)	29.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2508654

Minimum	0
Maximum	10000000
Zeros	159
Zeros (%)	31.8%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1800000
Q3	4000000
95-th percentile	8293750
Maximum	10000000
Range	10000000
Interquartile range (IQR)	4000000

Descriptive statistics

Standard deviation	2717275
Coefficient of variation (CV)	1.0831605
Kurtosis	0.46711973
Mean	2508654
Median Absolute Deviation (MAD)	1800000
Skewness	1.0954535
Sum	1.254327 × 10⁹
Variance	7.3835835 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	159	31.8%
6000000	36	7.2%
2000000	24	4.8%
1800000	17	3.4%
1000000	16	3.2%
4000000	13	2.6%
10000000	12	2.4%
900000	10	2.0%
3000000	9	1.8%
3600000	7	1.4%
Other values (137)	197	39.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	159	31.8%
180000	1	0.2%
270000	1	0.2%
340000	1	0.2%
360000	1	0.2%
391000	1	0.2%
460000	1	0.2%
540000	3	0.6%
600000	4	0.8%
630000	1	0.2%

Value	Count	Frequency (%)
10000000	12	2.4%
9960000	1	0.2%
9940000	2	0.4%
9910000	1	0.2%
9900000	1	0.2%
9880000	1	0.2%
9850000	1	0.2%
9605000	1	0.2%
9560000	1	0.2%
9300000	1	0.2%

성과공유금액최초납부기한
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

00:00.0	341
0001-01-01 00:00:00.000000	159

Length

Max length	26
Median length	7
Mean length	13.042
Min length	7

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	00:00.0
2nd row	00:00.0
3rd row	0001-01-01 00:00:00.000000
4th row	0001-01-01 00:00:00.000000
5th row	0001-01-01 00:00:00.000000

Common Values

Value	Count	Frequency (%)
00:00.0	341	68.2%
0001-01-01 00:00:00.000000	159	31.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
00:00.0	341	51.7%
0001-01-01	159	24.1%
00:00:00.000000	159	24.1%

성과공유금액분납신청여부
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

N	304
	159
Y	37

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
N	304	60.8%
	159	31.8%
Y	37	7.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	304	89.1%
y	37	10.9%

성과공유금액분납예정일자
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

0001-01-01 00:00:00.000000	472
00:00.0	28

Length

Max length	26
Median length	26
Mean length	24.936
Min length	7

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0001-01-01 00:00:00.000000
2nd row	0001-01-01 00:00:00.000000
3rd row	0001-01-01 00:00:00.000000
4th row	0001-01-01 00:00:00.000000
5th row	0001-01-01 00:00:00.000000

Common Values

Value	Count	Frequency (%)
0001-01-01 00:00:00.000000	472	94.4%
00:00.0	28	5.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0001-01-01	472	48.6%
00:00:00.000000	472	48.6%
00:00.0	28	2.9%

성과공유금액유예기한
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

0001-01-01 00:00:00.000000	500

Length

Max length	26
Median length	26
Mean length	26
Min length	26

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0001-01-01 00:00:00.000000
2nd row	0001-01-01 00:00:00.000000
3rd row	0001-01-01 00:00:00.000000
4th row	0001-01-01 00:00:00.000000
5th row	0001-01-01 00:00:00.000000

Common Values

Value	Count	Frequency (%)
0001-01-01 00:00:00.000000	500	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0001-01-01	500	50.0%
00:00:00.000000	500	50.0%

삭제여부
Boolean

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	632.0 B

False	500

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	500	100.0%

최종수정수
Real number (ℝ)

Distinct	20
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.002

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	11
Maximum	31
Range	30
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.4072297
Coefficient of variation (CV)	0.85138174
Kurtosis	12.271193
Mean	4.002
Median Absolute Deviation (MAD)	1
Skewness	2.843069
Sum	2001
Variance	11.609214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
2	179	35.8%
3	89	17.8%
4	51	10.2%
1	42	8.4%
5	39	7.8%
6	27	5.4%
7	20	4.0%
9	13	2.6%
11	7	1.4%
10	6	1.2%
Other values (10)	27	5.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	42	8.4%
2	179	35.8%
3	89	17.8%
4	51	10.2%
5	39	7.8%
6	27	5.4%
7	20	4.0%
8	6	1.2%
9	13	2.6%
10	6	1.2%

Value	Count	Frequency (%)
31	1	0.2%
24	1	0.2%
18	2	0.4%
17	2	0.4%
16	2	0.4%
15	2	0.4%
14	3	0.6%
13	6	1.2%
12	2	0.4%
11	7	1.4%

처리시각
Text

Distinct	498
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	3500
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	496 ?
Unique (%)	99.2%

Sample

1st row	05:08.4
2nd row	05:37.4
3rd row	08:47.6
4th row	40:54.7
5th row	36:10.7

Value	Count	Frequency (%)
47:13.8	2	0.4%
22:14.3	2	0.4%
58:27.1	1	0.2%
06:53.5	1	0.2%
53:45.8	1	0.2%
12:54.2	1	0.2%
29:03.2	1	0.2%
50:56.1	1	0.2%
37:40.1	1	0.2%
46:39.1	1	0.2%
Other values (488)	488	97.6%

Most occurring characters

Value	Count	Frequency (%)
:	500	14.3%
.	500	14.3%
1	333	9.5%
2	332	9.5%
5	322	9.2%
0	319	9.1%
4	304	8.7%
3	294	8.4%
7	171	4.9%
6	152	4.3%
Other values (2)	273	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2500	71.4%
Other Punctuation	1000	28.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	333	13.3%
2	332	13.3%
5	322	12.9%
0	319	12.8%
4	304	12.2%
3	294	11.8%
7	171	6.8%
6	152	6.1%
8	137	5.5%
9	136	5.4%

Other Punctuation

Value	Count	Frequency (%)
:	500	50.0%
.	500	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3500	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	500	14.3%
.	500	14.3%
1	333	9.5%
2	332	9.5%
5	322	9.2%
0	319	9.1%
4	304	8.7%
3	294	8.4%
7	171	4.9%
6	152	4.3%
Other values (2)	273	7.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	500	14.3%
.	500	14.3%
1	333	9.5%
2	332	9.5%
5	322	9.2%
0	319	9.1%
4	304	8.7%
3	294	8.4%
7	171	4.9%
6	152	4.3%
Other values (2)	273	7.8%

처리직원번호
Real number (ℝ)

Distinct	297
Distinct (%)	59.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4068.116

Minimum	1019
Maximum	5218
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1019
5-th percentile	2958.65
Q1	3520
median	4141
Q3	4640.25
95-th percentile	5047.15
Maximum	5218
Range	4199
Interquartile range (IQR)	1120.25

Descriptive statistics

Standard deviation	720.40015
Coefficient of variation (CV)	0.17708447
Kurtosis	1.15649
Mean	4068.116
Median Absolute Deviation (MAD)	538
Skewness	-0.79730112
Sum	2034058
Variance	518976.38
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3965	6	1.2%
4505	6	1.2%
4636	6	1.2%
3290	5	1.0%
4679	5	1.0%
3200	5	1.0%
4256	5	1.0%
3687	5	1.0%
3082	5	1.0%
3415	4	0.8%
Other values (287)	448	89.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1019	3	0.6%
1886	2	0.4%
1928	1	0.2%
1940	1	0.2%
2394	2	0.4%
2398	2	0.4%
2443	1	0.2%
2451	1	0.2%
2458	1	0.2%
2564	4	0.8%

Value	Count	Frequency (%)
5218	1	0.2%
5124	1	0.2%
5118	2	0.4%
5112	1	0.2%
5109	1	0.2%
5106	3	0.6%
5103	1	0.2%
5098	1	0.2%
5097	1	0.2%
5094	1	0.2%

최초처리시각
Categorical

HIGH CORRELATION IMBALANCE

Distinct	43
Distinct (%)	8.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

0001-01-01 00:00:00.000000	458
47:28.9	1
22:30.0	1
04:06.7	1
48:27.4	1
Other values (38)	38

Length

Max length	26
Median length	26
Mean length	24.404
Min length	7

Unique

Unique	42 ?
Unique (%)	8.4%

Sample

1st row	0001-01-01 00:00:00.000000
2nd row	0001-01-01 00:00:00.000000
3rd row	0001-01-01 00:00:00.000000
4th row	0001-01-01 00:00:00.000000
5th row	0001-01-01 00:00:00.000000

Common Values

Value	Count	Frequency (%)
0001-01-01 00:00:00.000000	458	91.6%
47:28.9	1	0.2%
22:30.0	1	0.2%
04:06.7	1	0.2%
48:27.4	1	0.2%
51:23.0	1	0.2%
42:04.7	1	0.2%
49:54.2	1	0.2%
28:00.9	1	0.2%
23:28.4	1	0.2%
Other values (33)	33	6.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0001-01-01	458	47.8%
00:00:00.000000	458	47.8%
44:02.7	1	0.1%
55:14.6	1	0.1%
56:00.1	1	0.1%
35:11.5	1	0.1%
03:28.6	1	0.1%
54:47.1	1	0.1%
51:41.3	1	0.1%
12:54.2	1	0.1%
Other values (34)	34	3.5%

최초처리직원번호
Categorical

HIGH CORRELATION IMBALANCE

Distinct	35
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

BATCH	458
4191	4
4256	4
3687	2
3415	2
Other values (30)	30

Length

Max length	5
Median length	5
Mean length	4.916
Min length	4

Unique

Unique	30 ?
Unique (%)	6.0%

Sample

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

Common Values

Value	Count	Frequency (%)
BATCH	458	91.6%
4191	4	0.8%
4256	4	0.8%
3687	2	0.4%
3415	2	0.4%
3670	1	0.2%
4876	1	0.2%
3599	1	0.2%
5046	1	0.2%
5076	1	0.2%
Other values (25)	25	5.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
batch	458	91.6%
4256	4	0.8%
4191	4	0.8%
3687	2	0.4%
3415	2	0.4%
4188	1	0.2%
4013	1	0.2%
4984	1	0.2%
4589	1	0.2%
4024	1	0.2%
Other values (25)	25	5.0%

Heatmap
Table

	성과공유금액약정체결여부	성과공유금액약정체결사유코드	4기평가년도	5기평가년도	중단일자	한도설정금액	건별발급금액	성과공유금액납부예정금액	성과공유금액최초납부기한	성과공유금액분납신청여부	성과공유금액분납예정일자	최종수정수	처리직원번호	최초처리시각	최초처리직원번호
성과공유금액약정체결여부	1.000	0.788	0.389	0.389	0.494	0.789	0.363	0.546	0.469	0.833	0.062	0.065	0.086	0.712	0.709
성과공유금액약정체결사유코드	0.788	1.000	0.598	0.598	0.323	0.596	0.271	0.472	0.297	0.681	0.000	0.368	0.000	0.745	0.693
4기평가년도	0.389	0.598	1.000	1.000	0.424	0.282	0.000	0.113	0.385	0.387	0.000	0.000	0.000	0.807	0.845
5기평가년도	0.389	0.598	1.000	1.000	0.424	0.282	0.000	0.113	0.385	0.387	0.000	0.000	0.000	0.807	0.845
중단일자	0.494	0.323	0.424	0.424	1.000	0.538	0.366	0.554	0.759	0.346	0.103	0.000	0.099	0.408	0.429
한도설정금액	0.789	0.596	0.282	0.282	0.538	1.000	0.527	0.721	0.956	0.948	0.315	0.158	0.189	0.000	0.000
건별발급금액	0.363	0.271	0.000	0.000	0.366	0.527	1.000	0.824	0.689	0.624	0.624	0.262	0.301	0.000	0.000
성과공유금액납부예정금액	0.546	0.472	0.113	0.113	0.554	0.721	0.824	1.000	0.941	0.790	0.706	0.541	0.222	0.000	0.000
성과공유금액최초납부기한	0.469	0.297	0.385	0.385	0.759	0.956	0.689	0.941	1.000	1.000	0.234	0.326	0.153	0.419	0.439
성과공유금액분납신청여부	0.833	0.681	0.387	0.387	0.346	0.948	0.624	0.790	1.000	1.000	0.559	0.373	0.171	0.248	0.340
성과공유금액분납예정일자	0.062	0.000	0.000	0.000	0.103	0.315	0.624	0.706	0.234	0.559	1.000	0.456	0.166	0.000	0.000
최종수정수	0.065	0.368	0.000	0.000	0.000	0.158	0.262	0.541	0.326	0.373	0.456	1.000	0.320	0.000	0.000
처리직원번호	0.086	0.000	0.000	0.000	0.099	0.189	0.301	0.222	0.153	0.171	0.166	0.320	1.000	0.000	0.000
최초처리시각	0.712	0.745	0.807	0.807	0.408	0.000	0.000	0.000	0.419	0.248	0.000	0.000	0.000	1.000	1.000
최초처리직원번호	0.709	0.693	0.845	0.845	0.429	0.000	0.000	0.000	0.439	0.340	0.000	0.000	0.000	1.000	1.000

Heatmap
Table

	성과공유금액최초납부기한	중단일자	최초처리시각	성과공유금액약정체결여부	성과공유금액분납신청여부	성과공유금액분납예정일자	최초처리직원번호	성과공유금액약정체결사유코드
성과공유금액최초납부기한	1.000	0.548	0.336	0.721	0.999	0.151	0.359	0.480
중단일자	0.548	1.000	0.327	0.752	0.553	0.066	0.351	0.518
최초처리시각	0.336	0.327	1.000	0.458	0.119	0.000	0.991	0.493
성과공유금액약정체결여부	0.721	0.752	0.458	1.000	0.508	0.102	0.465	0.450
성과공유금액분납신청여부	0.999	0.553	0.119	0.508	1.000	0.827	0.174	0.339
성과공유금액분납예정일자	0.151	0.066	0.000	0.102	0.827	1.000	0.000	0.000
최초처리직원번호	0.359	0.351	0.991	0.465	0.174	0.000	1.000	0.448
성과공유금액약정체결사유코드	0.480	0.518	0.493	0.450	0.339	0.000	0.448	1.000

Heatmap
Table

	4기평가년도	5기평가년도	한도설정금액	건별발급금액	성과공유금액납부예정금액	최종수정수	처리직원번호	성과공유금액약정체결여부	성과공유금액약정체결사유코드	중단일자	성과공유금액최초납부기한	성과공유금액분납신청여부	성과공유금액분납예정일자	최초처리시각	최초처리직원번호
4기평가년도	1.000	1.000	-0.294	-0.194	-0.198	-0.117	-0.068	0.413	0.482	0.450	0.408	0.278	0.000	0.477	0.485
5기평가년도	1.000	1.000	-0.294	-0.194	-0.198	-0.117	-0.068	0.413	0.482	0.450	0.408	0.278	0.000	0.477	0.485
한도설정금액	-0.294	-0.294	1.000	0.872	0.880	0.329	-0.027	0.492	0.320	0.537	0.984	0.727	0.312	0.000	0.000
건별발급금액	-0.194	-0.194	0.872	1.000	0.998	0.309	-0.037	0.247	0.177	0.273	0.522	0.492	0.470	0.000	0.000
성과공유금액납부예정금액	-0.198	-0.198	0.880	0.998	1.000	0.314	-0.036	0.387	0.320	0.424	0.789	0.672	0.547	0.000	0.000
최종수정수	-0.117	-0.117	0.329	0.309	0.314	1.000	-0.015	0.000	0.236	0.000	0.208	0.239	0.330	0.000	0.000
처리직원번호	-0.068	-0.068	-0.027	-0.037	-0.036	-0.015	1.000	0.041	0.000	0.066	0.105	0.100	0.117	0.000	0.000
성과공유금액약정체결여부	0.413	0.413	0.492	0.247	0.387	0.000	0.041	1.000	0.450	0.752	0.721	0.508	0.102	0.458	0.465
성과공유금액약정체결사유코드	0.482	0.482	0.320	0.177	0.320	0.236	0.000	0.450	1.000	0.518	0.480	0.339	0.000	0.493	0.448
중단일자	0.450	0.450	0.537	0.273	0.424	0.000	0.066	0.752	0.518	1.000	0.548	0.553	0.066	0.327	0.351
성과공유금액최초납부기한	0.408	0.408	0.984	0.522	0.789	0.208	0.105	0.721	0.480	0.548	1.000	0.999	0.151	0.336	0.359
성과공유금액분납신청여부	0.278	0.278	0.727	0.492	0.672	0.239	0.100	0.508	0.339	0.553	0.999	1.000	0.827	0.119	0.174
성과공유금액분납예정일자	0.000	0.000	0.312	0.470	0.547	0.330	0.117	0.102	0.000	0.066	0.151	0.827	1.000	0.000	0.000
최초처리시각	0.477	0.477	0.000	0.000	0.000	0.000	0.000	0.458	0.493	0.327	0.336	0.119	0.000	1.000	0.991
최초처리직원번호	0.485	0.485	0.000	0.000	0.000	0.000	0.000	0.465	0.448	0.351	0.359	0.174	0.000	0.991	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	업무구분코드	원장번호	성과공유금액약정체결여부	성과공유금액약정체결사유코드	4기평가년도	5기평가년도	중단일자	한도설정금액	건별발급금액	성과공유금액납부예정금액	성과공유금액최초납부기한	성과공유금액분납신청여부	성과공유금액분납예정일자	성과공유금액유예기한	삭제여부	최종수정수	처리시각	처리직원번호	최초처리시각	최초처리직원번호
0	G	TIF200700832	Y	1	2010	2011	0001-01-01 00:00:00.000000	300000000	83500000	1670000	00:00.0	N	0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	10	05:08.4	3947	0001-01-01 00:00:00.000000	BATCH
1	G	IIA200801114	Y	1	2011	2012	0001-01-01 00:00:00.000000	200000000	220000000	4000000	00:00.0	N	0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	9	05:37.4	3419	0001-01-01 00:00:00.000000	BATCH
2	G	THZ200801078	Y	1	2011	2012	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	2	08:47.6	4435	0001-01-01 00:00:00.000000	BATCH
3	G	TIE200800236	N	1	2011	2012	00:00.0	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	3	40:54.7	4813	0001-01-01 00:00:00.000000	BATCH
4	G	TAQ201200149			<NA>	<NA>	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	2	36:10.7	3670	0001-01-01 00:00:00.000000	BATCH
5	G	TQA201000562	N		<NA>	<NA>	00:00.0	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	1	32:10.4	4792	32:10.4	4792
6	G	TQA201200218			<NA>	<NA>	00:00.0	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	11	42:36.9	4792	0001-01-01 00:00:00.000000	BATCH
7	G	IIA200800626	Y	1	2011	2012	0001-01-01 00:00:00.000000	240000000	80000000	1600000	00:00.0	Y	0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	5	16:09.2	4084	0001-01-01 00:00:00.000000	BATCH
8	G	TQD201100691	N		2014	2015	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	6	20:41.5	3514	0001-01-01 00:00:00.000000	BATCH
9	G	THW201200215	N		2015	2016	00:00.0	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	6	57:45.1	4670	0001-01-01 00:00:00.000000	BATCH

	업무구분코드	원장번호	성과공유금액약정체결여부	성과공유금액약정체결사유코드	4기평가년도	5기평가년도	중단일자	한도설정금액	건별발급금액	성과공유금액납부예정금액	성과공유금액최초납부기한	성과공유금액분납신청여부	성과공유금액분납예정일자	성과공유금액유예기한	삭제여부	최종수정수	처리시각	처리직원번호	최초처리시각	최초처리직원번호
490	G	ICA200800567	Y	1	2011	2012	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	1	18:36.1	4255	18:36.1	4255
491	G	IPA200800377	Y	1	2011	2012	0001-01-01 00:00:00.000000	150000000	50000000	1000000	00:00.0	N	0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	4	55:33.4	3650	0001-01-01 00:00:00.000000	BATCH
492	G	TAP200701024	Y	1	2010	2011	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	2	59:04.9	3767	0001-01-01 00:00:00.000000	BATCH
493	G	THJ200800775	N		2011	2012	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	3	32:03.2	4147	0001-01-01 00:00:00.000000	BATCH
494	G	IIA200800846	Y	1	2011	2012	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	2	06:41.0	2564	0001-01-01 00:00:00.000000	BATCH
495	G	IIA200800027	Y	1	2011	2012	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	4	51:01.3	2564	0001-01-01 00:00:00.000000	BATCH
496	G	TNA200701089	Y	1	2010	2011	0001-01-01 00:00:00.000000	500000000	370000000	7400000	00:00.0	N	0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	4	11:30.5	3973	0001-01-01 00:00:00.000000	BATCH
497	G	IIA200801264	Y	1	2011	2012	0001-01-01 00:00:00.000000	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	3	51:11.5	2564	0001-01-01 00:00:00.000000	BATCH
498	G	THU200800192	Y		2011	2012	0001-01-01 00:00:00.000000	300000000	128000000	2560000	00:00.0	N	0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	2	45:17.9	3082	0001-01-01 00:00:00.000000	BATCH
499	G	TAZ200700725	N	1	2010	2011	00:00.0	0	0	0	0001-01-01 00:00:00.000000		0001-01-01 00:00:00.000000	0001-01-01 00:00:00.000000	N	2	58:42.3	3863	0001-01-01 00:00:00.000000	BATCH

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values

Length

Interactions

Correlations

Missing values

Sample