gimi9 Pandas Profiling

Dataset statistics

Number of variables	20
Number of observations	728
Missing cells	550
Missing cells (%)	3.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	125.2 KiB
Average record size in memory	176.2 B

Variable types

Numeric	14
Categorical	4
DateTime	2

Dataset

Description	부산광역시 상수도사업본부에서 상하수도 요금 계산 및 징수를 위해 운영하는 수용가정보시스템에 사용되는 복지사각지대 자료 제공 통계자료입니다.(자료제공년월, 자료회차, 전월 사용량 등)사용량의 단위는 톤입니다.
Author	부산광역시 상수도사업본부
URL	https://www.data.go.kr/data/15100343/fileData.do

Alerts

`자료회차` has constant value ""	Constant
`자료접수기관코드` has constant value ""	Constant
`자료처리일자` is highly overall correlated with `연번` and 1 other fields	High correlation
`자료제공년월` is highly overall correlated with `연번` and 1 other fields	High correlation
`연번` is highly overall correlated with `자료제공년월` and 1 other fields	High correlation
`전월사용량` is highly overall correlated with `3개월전사용량` and 4 other fields	High correlation
`2개월전사용량` is highly overall correlated with `4개월전사용량` and 4 other fields	High correlation
`3개월전사용량` is highly overall correlated with `전월사용량` and 4 other fields	High correlation
`4개월전사용량` is highly overall correlated with `2개월전사용량` and 4 other fields	High correlation
`5개월전사용량` is highly overall correlated with `전월사용량` and 4 other fields	High correlation
`6개월전사용량` is highly overall correlated with `2개월전사용량` and 4 other fields	High correlation
`7개월전사용량` is highly overall correlated with `전월사용량` and 4 other fields	High correlation
`8개월전사용량` is highly overall correlated with `2개월전사용량` and 4 other fields	High correlation
`9개월전사용량` is highly overall correlated with `전월사용량` and 4 other fields	High correlation
`10개월전사용량` is highly overall correlated with `2개월전사용량` and 4 other fields	High correlation
`11개월전사용량` is highly overall correlated with `전월사용량` and 4 other fields	High correlation
`12개월전사용량` is highly overall correlated with `2개월전사용량` and 4 other fields	High correlation
`정수종료일` has 550 (75.5%) missing values	Missing
`4개월전사용량` is highly skewed (γ1 = 25.14977004)	Skewed
`연번` has unique values	Unique
`전월사용량` has 620 (85.2%) zeros	Zeros
`2개월전사용량` has 594 (81.6%) zeros	Zeros
`3개월전사용량` has 587 (80.6%) zeros	Zeros
`4개월전사용량` has 574 (78.8%) zeros	Zeros
`5개월전사용량` has 572 (78.6%) zeros	Zeros
`6개월전사용량` has 560 (76.9%) zeros	Zeros
`7개월전사용량` has 546 (75.0%) zeros	Zeros
`8개월전사용량` has 527 (72.4%) zeros	Zeros
`9개월전사용량` has 524 (72.0%) zeros	Zeros
`10개월전사용량` has 514 (70.6%) zeros	Zeros
`11개월전사용량` has 515 (70.7%) zeros	Zeros
`12개월전사용량` has 498 (68.4%) zeros	Zeros

Reproduction

Analysis started	2024-03-14 11:33:56.443231
Analysis finished	2024-03-14 11:34:48.252276
Duration	51.81 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	728
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	364.5

Minimum	1
Maximum	728
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	1
5-th percentile	37.35
Q1	182.75
median	364.5
Q3	546.25
95-th percentile	691.65
Maximum	728
Range	727
Interquartile range (IQR)	363.5

Descriptive statistics

Standard deviation	210.29979
Coefficient of variation (CV)	0.57695415
Kurtosis	-1.2
Mean	364.5
Median Absolute Deviation (MAD)	182
Skewness	0
Sum	265356
Variance	44226
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.1%
480	1	0.1%
482	1	0.1%
483	1	0.1%
484	1	0.1%
485	1	0.1%
486	1	0.1%
487	1	0.1%
488	1	0.1%
489	1	0.1%
Other values (718)	718	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%
10	1	0.1%

Value	Count	Frequency (%)
728	1	0.1%
727	1	0.1%
726	1	0.1%
725	1	0.1%
724	1	0.1%
723	1	0.1%
722	1	0.1%
721	1	0.1%
720	1	0.1%
719	1	0.1%

자료제공년월
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

2023-11	147
2023-03	142
2023-09	133
2023-07	126
2023-05	126

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-09
2nd row	2023-09
3rd row	2023-09
4th row	2023-09
5th row	2023-09

Common Values

Value	Count	Frequency (%)
2023-11	147	20.2%
2023-03	142	19.5%
2023-09	133	18.3%
2023-07	126	17.3%
2023-05	126	17.3%
2023-01	54	7.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-11	147	20.2%
2023-03	142	19.5%
2023-09	133	18.3%
2023-07	126	17.3%
2023-05	126	17.3%
2023-01	54	7.4%

자료회차
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

1	728

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	1

Common Values

Value	Count	Frequency (%)
1	728	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	728	100.0%

자료순번
Real number (ℝ)

Distinct	147
Distinct (%)	20.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	65.149725

Minimum	1
Maximum	147
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	31
median	62.5
Q3	99
95-th percentile	129
Maximum	147
Range	146
Interquartile range (IQR)	68

Descriptive statistics

Standard deviation	39.612196
Coefficient of variation (CV)	0.60801786
Kurtosis	-1.1468636
Mean	65.149725
Median Absolute Deviation (MAD)	33.5
Skewness	0.15058963
Sum	47429
Variance	1569.1261
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
54	6	0.8%
20	6	0.8%
18	6	0.8%
17	6	0.8%
16	6	0.8%
15	6	0.8%
14	6	0.8%
13	6	0.8%
12	6	0.8%
11	6	0.8%
Other values (137)	668	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	0.8%
2	6	0.8%
3	6	0.8%
4	6	0.8%
5	6	0.8%
6	6	0.8%
7	6	0.8%
8	6	0.8%
9	6	0.8%
10	6	0.8%

Value	Count	Frequency (%)
147	1	0.1%
146	1	0.1%
145	1	0.1%
144	1	0.1%
143	1	0.1%
142	2	0.3%
141	2	0.3%
140	2	0.3%
139	2	0.3%
138	2	0.3%

자료접수기관코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

6260095	728

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
6260095	728	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6260095	728	100.0%

정수시작일
Date

Distinct	197
Distinct (%)	27.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

Minimum	2022-12-01 00:00:00
Maximum	2023-11-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

정수종료일
Date

MISSING

Distinct	120
Distinct (%)	67.4%
Missing	550
Missing (%)	75.5%
Memory size	5.8 KiB

Minimum	2022-12-05 00:00:00
Maximum	2023-12-08 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

전월사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	66
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.197802

Minimum	0
Maximum	1838
Zeros	620
Zeros (%)	85.2%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	42.65
Maximum	1838
Range	1838
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	99.330977
Coefficient of variation (CV)	6.5358778
Kurtosis	178.92929
Mean	15.197802
Median Absolute Deviation (MAD)	0
Skewness	11.849391
Sum	11064
Variance	9866.6431
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	620	85.2%
1	11	1.5%
4	6	0.8%
3	4	0.5%
6	4	0.5%
12	3	0.4%
5	3	0.4%
2	3	0.4%
48	2	0.3%
30	2	0.3%
Other values (56)	70	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	620	85.2%
1	11	1.5%
2	3	0.4%
3	4	0.5%
4	6	0.8%
5	3	0.4%
6	4	0.5%
7	2	0.3%
8	2	0.3%
9	2	0.3%

Value	Count	Frequency (%)
1838	1	0.1%
990	1	0.1%
731	1	0.1%
637	1	0.1%
618	1	0.1%
550	2	0.3%
509	1	0.1%
451	1	0.1%
324	1	0.1%
278	1	0.1%

2개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	60
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.502747

Minimum	0
Maximum	984
Zeros	594
Zeros (%)	81.6%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	28.3
Maximum	984
Range	984
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	65.687518
Coefficient of variation (CV)	6.2543177
Kurtosis	113.98375
Mean	10.502747
Median Absolute Deviation (MAD)	0
Skewness	9.9725782
Sum	7646
Variance	4314.8501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	594	81.6%
1	20	2.7%
3	12	1.6%
2	8	1.1%
10	5	0.7%
8	5	0.7%
9	4	0.5%
14	4	0.5%
7	4	0.5%
5	3	0.4%
Other values (50)	69	9.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	594	81.6%
1	20	2.7%
2	8	1.1%
3	12	1.6%
4	1	0.1%
5	3	0.4%
6	3	0.4%
7	4	0.5%
8	5	0.7%
9	4	0.5%

Value	Count	Frequency (%)
984	1	0.1%
725	1	0.1%
659	1	0.1%
632	1	0.1%
418	1	0.1%
387	1	0.1%
380	1	0.1%
290	1	0.1%
283	1	0.1%
262	1	0.1%

3개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	74
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.196429

Minimum	0
Maximum	1234
Zeros	587
Zeros (%)	80.6%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	63
Maximum	1234
Range	1234
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	87.611379
Coefficient of variation (CV)	5.0947427
Kurtosis	96.404736
Mean	17.196429
Median Absolute Deviation (MAD)	0
Skewness	8.8722115
Sum	12519
Variance	7675.7537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	587	80.6%
1	14	1.9%
2	8	1.1%
3	6	0.8%
5	5	0.7%
17	5	0.7%
6	3	0.4%
10	3	0.4%
4	3	0.4%
36	3	0.4%
Other values (64)	91	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	587	80.6%
1	14	1.9%
2	8	1.1%
3	6	0.8%
4	3	0.4%
5	5	0.7%
6	3	0.4%
8	2	0.3%
9	2	0.3%
10	3	0.4%

Value	Count	Frequency (%)
1234	1	0.1%
1095	1	0.1%
703	1	0.1%
654	1	0.1%
587	1	0.1%
505	1	0.1%
459	1	0.1%
429	1	0.1%
383	1	0.1%
366	1	0.1%

4개월전사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	66
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.684066

Minimum	0
Maximum	10764
Zeros	574
Zeros (%)	78.8%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	40
Maximum	10764
Range	10764
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	408.55259
Coefficient of variation (CV)	14.243189
Kurtosis	658.58226
Mean	28.684066
Median Absolute Deviation (MAD)	0
Skewness	25.14977
Sum	20882
Variance	166915.22
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	574	78.8%
1	27	3.7%
3	9	1.2%
12	7	1.0%
4	6	0.8%
9	6	0.8%
10	6	0.8%
15	5	0.7%
2	4	0.5%
11	4	0.5%
Other values (56)	80	11.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	574	78.8%
1	27	3.7%
2	4	0.5%
3	9	1.2%
4	6	0.8%
5	1	0.1%
6	1	0.1%
7	3	0.4%
8	3	0.4%
9	6	0.8%

Value	Count	Frequency (%)
10764	1	0.1%
1655	1	0.1%
890	1	0.1%
849	1	0.1%
674	1	0.1%
668	1	0.1%
447	1	0.1%
349	1	0.1%
281	1	0.1%
277	1	0.1%

5개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	86
Distinct (%)	11.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.924451

Minimum	0
Maximum	863
Zeros	572
Zeros (%)	78.6%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	72.6
Maximum	863
Range	863
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	81.406082
Coefficient of variation (CV)	4.5416222
Kurtosis	58.559967
Mean	17.924451
Median Absolute Deviation (MAD)	0
Skewness	7.1601098
Sum	13049
Variance	6626.9503
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	572	78.6%
1	18	2.5%
5	8	1.1%
2	6	0.8%
3	6	0.8%
20	4	0.5%
10	4	0.5%
14	4	0.5%
6	4	0.5%
12	3	0.4%
Other values (76)	99	13.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	572	78.6%
1	18	2.5%
2	6	0.8%
3	6	0.8%
4	2	0.3%
5	8	1.1%
6	4	0.5%
7	2	0.3%
8	2	0.3%
9	2	0.3%

Value	Count	Frequency (%)
863	1	0.1%
809	1	0.1%
755	1	0.1%
745	2	0.3%
493	1	0.1%
475	1	0.1%
419	1	0.1%
356	1	0.1%
338	1	0.1%
325	1	0.1%

6개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	76
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.913462

Minimum	0
Maximum	929
Zeros	560
Zeros (%)	76.9%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	55.65
Maximum	929
Range	929
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	66.319612
Coefficient of variation (CV)	5.135696
Kurtosis	101.11251
Mean	12.913462
Median Absolute Deviation (MAD)	0
Skewness	9.3230275
Sum	9401
Variance	4398.291
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	560	76.9%
1	15	2.1%
2	14	1.9%
11	10	1.4%
10	8	1.1%
4	5	0.7%
9	5	0.7%
5	5	0.7%
6	5	0.7%
16	4	0.5%
Other values (66)	97	13.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	560	76.9%
1	15	2.1%
2	14	1.9%
3	3	0.4%
4	5	0.7%
5	5	0.7%
6	5	0.7%
7	1	0.1%
8	3	0.4%
9	5	0.7%

Value	Count	Frequency (%)
929	1	0.1%
775	1	0.1%
711	1	0.1%
520	1	0.1%
458	1	0.1%
433	1	0.1%
380	1	0.1%
325	1	0.1%
270	1	0.1%
223	1	0.1%

7개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	90
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.072802

Minimum	0
Maximum	859
Zeros	546
Zeros (%)	75.0%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.25
95-th percentile	76.65
Maximum	859
Range	859
Interquartile range (IQR)	0.25

Descriptive statistics

Standard deviation	79.270844
Coefficient of variation (CV)	4.1562243
Kurtosis	47.297792
Mean	19.072802
Median Absolute Deviation (MAD)	0
Skewness	6.4481451
Sum	13885
Variance	6283.8668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	546	75.0%
1	15	2.1%
2	8	1.1%
6	7	1.0%
14	6	0.8%
17	6	0.8%
10	6	0.8%
16	6	0.8%
5	5	0.7%
3	5	0.7%
Other values (80)	118	16.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	546	75.0%
1	15	2.1%
2	8	1.1%
3	5	0.7%
4	3	0.4%
5	5	0.7%
6	7	1.0%
7	4	0.5%
8	4	0.5%
9	5	0.7%

Value	Count	Frequency (%)
859	1	0.1%
719	1	0.1%
643	1	0.1%
618	1	0.1%
614	1	0.1%
499	1	0.1%
497	1	0.1%
460	1	0.1%
458	1	0.1%
450	1	0.1%

8개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	76
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.315934

Minimum	0
Maximum	731
Zeros	527
Zeros (%)	72.4%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	56
Maximum	731
Range	731
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	65.327314
Coefficient of variation (CV)	4.9059505
Kurtosis	78.718167
Mean	13.315934
Median Absolute Deviation (MAD)	0
Skewness	8.4426621
Sum	9694
Variance	4267.658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	527	72.4%
1	27	3.7%
3	16	2.2%
8	11	1.5%
5	9	1.2%
4	8	1.1%
7	7	1.0%
2	7	1.0%
10	6	0.8%
12	4	0.5%
Other values (66)	106	14.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	527	72.4%
1	27	3.7%
2	7	1.0%
3	16	2.2%
4	8	1.1%
5	9	1.2%
6	4	0.5%
7	7	1.0%
8	11	1.5%
9	4	0.5%

Value	Count	Frequency (%)
731	1	0.1%
728	1	0.1%
708	1	0.1%
612	1	0.1%
531	1	0.1%
523	1	0.1%
389	1	0.1%
347	1	0.1%
299	1	0.1%
274	1	0.1%

9개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	88
Distinct (%)	12.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.67033

Minimum	0
Maximum	750
Zeros	524
Zeros (%)	72.0%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	84.6
Maximum	750
Range	750
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	66.220931
Coefficient of variation (CV)	3.7475775
Kurtosis	51.174265
Mean	17.67033
Median Absolute Deviation (MAD)	0
Skewness	6.4716366
Sum	12864
Variance	4385.2117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	524	72.0%
1	16	2.2%
10	9	1.2%
6	9	1.2%
5	8	1.1%
13	7	1.0%
4	6	0.8%
3	6	0.8%
7	6	0.8%
28	5	0.7%
Other values (78)	132	18.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	524	72.0%
1	16	2.2%
2	2	0.3%
3	6	0.8%
4	6	0.8%
5	8	1.1%
6	9	1.2%
7	6	0.8%
8	4	0.5%
9	3	0.4%

Value	Count	Frequency (%)
750	1	0.1%
639	1	0.1%
629	1	0.1%
516	1	0.1%
437	1	0.1%
372	1	0.1%
366	1	0.1%
329	1	0.1%
311	1	0.1%
283	1	0.1%

10개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	86
Distinct (%)	11.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.06456

Minimum	0
Maximum	750
Zeros	514
Zeros (%)	70.6%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	60
Maximum	750
Range	750
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	72.074392
Coefficient of variation (CV)	4.4865462
Kurtosis	59.412528
Mean	16.06456
Median Absolute Deviation (MAD)	0
Skewness	7.3241263
Sum	11695
Variance	5194.718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	514	70.6%
1	23	3.2%
2	16	2.2%
6	12	1.6%
5	12	1.6%
3	7	1.0%
12	7	1.0%
4	7	1.0%
10	6	0.8%
16	5	0.7%
Other values (76)	119	16.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	514	70.6%
1	23	3.2%
2	16	2.2%
3	7	1.0%
4	7	1.0%
5	12	1.6%
6	12	1.6%
7	4	0.5%
8	5	0.7%
9	2	0.3%

Value	Count	Frequency (%)
750	1	0.1%
728	1	0.1%
705	1	0.1%
624	1	0.1%
601	1	0.1%
483	1	0.1%
477	1	0.1%
459	1	0.1%
392	1	0.1%
342	1	0.1%

11개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	89
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.729396

Minimum	0
Maximum	850
Zeros	515
Zeros (%)	70.7%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	93
Maximum	850
Range	850
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	72.559852
Coefficient of variation (CV)	3.8741161
Kurtosis	51.366627
Mean	18.729396
Median Absolute Deviation (MAD)	0
Skewness	6.4945853
Sum	13635
Variance	5264.9322
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	515	70.7%
1	16	2.2%
5	9	1.2%
12	9	1.2%
3	8	1.1%
11	8	1.1%
7	7	1.0%
13	7	1.0%
2	6	0.8%
17	6	0.8%
Other values (79)	137	18.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	515	70.7%
1	16	2.2%
2	6	0.8%
3	8	1.1%
4	5	0.7%
5	9	1.2%
6	5	0.7%
7	7	1.0%
8	4	0.5%
9	6	0.8%

Value	Count	Frequency (%)
850	1	0.1%
726	1	0.1%
608	1	0.1%
460	1	0.1%
451	1	0.1%
419	1	0.1%
412	1	0.1%
402	1	0.1%
395	1	0.1%
366	1	0.1%

12개월전사용량
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	82
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.910714

Minimum	0
Maximum	1032
Zeros	498
Zeros (%)	68.4%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5
95-th percentile	62.95
Maximum	1032
Range	1032
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	71.928296
Coefficient of variation (CV)	4.8239336
Kurtosis	103.16322
Mean	14.910714
Median Absolute Deviation (MAD)	0
Skewness	9.4376837
Sum	10855
Variance	5173.6798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	498	68.4%
1	15	2.1%
8	14	1.9%
3	13	1.8%
5	12	1.6%
6	10	1.4%
4	9	1.2%
9	8	1.1%
2	8	1.1%
12	7	1.0%
Other values (72)	134	18.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	498	68.4%
1	15	2.1%
2	8	1.1%
3	13	1.8%
4	9	1.2%
5	12	1.6%
6	10	1.4%
7	7	1.0%
8	14	1.9%
9	8	1.1%

Value	Count	Frequency (%)
1032	1	0.1%
778	1	0.1%
729	1	0.1%
700	1	0.1%
584	1	0.1%
388	1	0.1%
366	1	0.1%
297	1	0.1%
291	1	0.1%
271	1	0.1%

자료처리일자
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

2023-12-13	147
2023-04-13	142
2023-10-13	133
2023-08-13	126
2023-06-13	126

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-10-13
2nd row	2023-10-13
3rd row	2023-10-13
4th row	2023-10-13
5th row	2023-10-13

Common Values

Value	Count	Frequency (%)
2023-12-13	147	20.2%
2023-04-13	142	19.5%
2023-10-13	133	18.3%
2023-08-13	126	17.3%
2023-06-13	126	17.3%
2023-02-13	54	7.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-12-13	147	20.2%
2023-04-13	142	19.5%
2023-10-13	133	18.3%
2023-08-13	126	17.3%
2023-06-13	126	17.3%
2023-02-13	54	7.4%

Heatmap
Table

	연번	자료제공년월	자료순번	전월사용량	2개월전사용량	3개월전사용량	4개월전사용량	5개월전사용량	6개월전사용량	7개월전사용량	8개월전사용량	9개월전사용량	10개월전사용량	11개월전사용량	12개월전사용량	자료처리일자
연번	1.000	0.896	0.781	0.073	0.000	0.111	0.015	0.000	0.000	0.110	0.000	0.000	0.000	0.031	0.000	0.896
자료제공년월	0.896	1.000	0.241	0.142	0.096	0.130	0.160	0.053	0.048	0.103	0.087	0.095	0.000	0.098	0.085	1.000
자료순번	0.781	0.241	1.000	0.193	0.122	0.177	0.000	0.119	0.105	0.000	0.078	0.000	0.080	0.000	0.039	0.241
전월사용량	0.073	0.142	0.193	1.000	0.734	0.907	0.000	0.776	0.806	0.781	0.778	0.721	0.586	0.727	0.672	0.142
2개월전사용량	0.000	0.096	0.122	0.734	1.000	0.866	0.000	0.777	0.868	0.645	0.794	0.651	0.640	0.696	0.870	0.096
3개월전사용량	0.111	0.130	0.177	0.907	0.866	1.000	0.000	0.934	0.798	0.764	0.770	0.774	0.662	0.764	0.850	0.130
4개월전사용량	0.015	0.160	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.160
5개월전사용량	0.000	0.053	0.119	0.776	0.777	0.934	0.000	1.000	0.762	0.791	0.720	0.766	0.650	0.724	0.845	0.053
6개월전사용량	0.000	0.048	0.105	0.806	0.868	0.798	0.000	0.762	1.000	0.893	0.968	0.912	0.921	0.918	0.912	0.048
7개월전사용량	0.110	0.103	0.000	0.781	0.645	0.764	0.000	0.791	0.893	1.000	0.814	0.934	0.743	0.915	0.765	0.103
8개월전사용량	0.000	0.087	0.078	0.778	0.794	0.770	0.000	0.720	0.968	0.814	1.000	0.813	0.943	0.827	0.884	0.087
9개월전사용량	0.000	0.095	0.000	0.721	0.651	0.774	0.000	0.766	0.912	0.934	0.813	1.000	0.827	0.966	0.796	0.095
10개월전사용량	0.000	0.000	0.080	0.586	0.640	0.662	0.000	0.650	0.921	0.743	0.943	0.827	1.000	0.841	0.866	0.000
11개월전사용량	0.031	0.098	0.000	0.727	0.696	0.764	0.000	0.724	0.918	0.915	0.827	0.966	0.841	1.000	0.825	0.098
12개월전사용량	0.000	0.085	0.039	0.672	0.870	0.850	0.000	0.845	0.912	0.765	0.884	0.796	0.866	0.825	1.000	0.085
자료처리일자	0.896	1.000	0.241	0.142	0.096	0.130	0.160	0.053	0.048	0.103	0.087	0.095	0.000	0.098	0.085	1.000

Heatmap
Table

	자료처리일자	자료제공년월
자료처리일자	1.000	1.000
자료제공년월	1.000	1.000

Heatmap
Table

	연번	자료순번	전월사용량	2개월전사용량	3개월전사용량	4개월전사용량	5개월전사용량	6개월전사용량	7개월전사용량	8개월전사용량	9개월전사용량	10개월전사용량	11개월전사용량	12개월전사용량	자료제공년월	자료처리일자
연번	1.000	-0.073	0.036	0.020	0.008	0.045	0.071	0.031	0.013	-0.008	0.021	0.014	0.059	0.014	0.748	0.748
자료순번	-0.073	1.000	0.091	-0.039	0.038	-0.042	0.011	-0.010	0.065	-0.043	0.050	-0.069	0.047	-0.043	0.129	0.129
전월사용량	0.036	0.091	1.000	-0.037	0.745	-0.051	0.668	-0.063	0.642	-0.100	0.609	-0.099	0.594	-0.126	0.052	0.052
2개월전사용량	0.020	-0.039	-0.037	1.000	-0.082	0.814	-0.106	0.751	-0.120	0.696	-0.134	0.666	-0.132	0.599	0.053	0.053
3개월전사용량	0.008	0.038	0.745	-0.082	1.000	-0.105	0.807	-0.113	0.751	-0.150	0.700	-0.146	0.694	-0.157	0.072	0.072
4개월전사용량	0.045	-0.042	-0.051	0.814	-0.105	1.000	-0.123	0.815	-0.139	0.750	-0.157	0.716	-0.143	0.669	0.067	0.067
5개월전사용량	0.071	0.011	0.668	-0.106	0.807	-0.123	1.000	-0.123	0.817	-0.163	0.747	-0.172	0.729	-0.184	0.029	0.029
6개월전사용량	0.031	-0.010	-0.063	0.751	-0.113	0.815	-0.123	1.000	-0.119	0.791	-0.145	0.735	-0.117	0.703	0.024	0.024
7개월전사용량	0.013	0.065	0.642	-0.120	0.751	-0.139	0.817	-0.119	1.000	-0.169	0.838	-0.176	0.798	-0.187	0.051	0.051
8개월전사용량	-0.008	-0.043	-0.100	0.696	-0.150	0.750	-0.163	0.791	-0.169	1.000	-0.156	0.821	-0.166	0.728	0.043	0.043
9개월전사용량	0.021	0.050	0.609	-0.134	0.700	-0.157	0.747	-0.145	0.838	-0.156	1.000	-0.171	0.860	-0.201	0.047	0.047
10개월전사용량	0.014	-0.069	-0.099	0.666	-0.146	0.716	-0.172	0.735	-0.176	0.821	-0.171	1.000	-0.188	0.848	0.000	0.000
11개월전사용량	0.059	0.047	0.594	-0.132	0.694	-0.143	0.729	-0.117	0.798	-0.166	0.860	-0.188	1.000	-0.184	0.048	0.048
12개월전사용량	0.014	-0.043	-0.126	0.599	-0.157	0.669	-0.184	0.703	-0.187	0.728	-0.201	0.848	-0.184	1.000	0.047	0.047
자료제공년월	0.748	0.129	0.052	0.053	0.072	0.067	0.029	0.024	0.051	0.043	0.047	0.000	0.048	0.047	1.000	1.000
자료처리일자	0.748	0.129	0.052	0.053	0.072	0.067	0.029	0.024	0.051	0.043	0.047	0.000	0.048	0.047	1.000	1.000

Count
Matrix

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.

First rows
Last rows

	연번	자료제공년월	자료회차	자료순번	자료접수기관코드	정수시작일	정수종료일	2개월전사용량	4개월전사용량	6개월전사용량	7개월전사용량	8개월전사용량	9개월전사용량	10개월전사용량	11개월전사용량	12개월전사용량	자료처리일자
0	1	2023-09	1	54	6260095	2023-08-25	<NA>	7	4	13	0	45	0	6	0	9	2023-10-13
1	2	2023-09	1	55	6260095	2023-08-25	<NA>	0	0	0	0	0	0	0	0	0	2023-10-13
2	3	2023-09	1	56	6260095	2023-08-25	<NA>	0	0	0	0	0	0	0	0	3	2023-10-13
3	4	2023-09	1	57	6260095	2023-08-25	2023-09-14	0	0	0	0	0	0	0	0	0	2023-10-13
4	5	2023-09	1	58	6260095	2023-08-25	<NA>	0	0	0	0	0	0	0	0	0	2023-10-13
5	6	2023-09	1	59	6260095	2023-08-25	<NA>	0	0	0	1	0	0	0	0	0	2023-10-13
6	7	2023-09	1	60	6260095	2023-08-25	<NA>	0	0	0	0	0	1	0	5	0	2023-10-13
7	8	2023-09	1	61	6260095	2023-08-25	<NA>	0	0	0	499	0	30	0	26	0	2023-10-13
8	9	2023-09	1	62	6260095	2023-08-28	<NA>	0	0	0	58	0	0	0	0	0	2023-10-13
9	10	2023-09	1	63	6260095	2023-08-28	<NA>	0	0	0	0	0	0	0	0	3	2023-10-13

	연번	자료제공년월	자료회차	자료순번	자료접수기관코드	정수시작일	정수종료일	전월사용량	2개월전사용량	3개월전사용량	4개월전사용량	5개월전사용량	6개월전사용량	7개월전사용량	8개월전사용량	9개월전사용량	10개월전사용량	11개월전사용량	12개월전사용량	자료처리일자
718	719	2023-07	1	102	6260095	2023-07-13	<NA>	4	0	17	0	21	0	27	0	23	0	28	0	2023-08-13
719	720	2023-07	1	103	6260095	2023-07-17	<NA>	0	0	0	0	0	0	0	0	0	0	0	0	2023-08-13
720	721	2023-07	1	104	6260095	2023-07-17	<NA>	10	0	61	0	70	0	75	0	33	0	34	0	2023-08-13
721	722	2023-07	1	105	6260095	2023-07-17	2023-07-17	34	0	39	0	35	0	38	0	44	0	43	0	2023-08-13
722	723	2023-07	1	106	6260095	2023-07-18	<NA>	0	2	0	0	0	0	0	0	0	1	0	68	2023-08-13
723	724	2023-07	1	107	6260095	2023-07-18	2023-07-21	0	10	0	7	0	6	0	8	0	7	0	8	2023-08-13
724	725	2023-07	1	108	6260095	2023-07-19	<NA>	0	0	0	0	0	0	0	0	1	0	1	0	2023-08-13
725	726	2023-07	1	109	6260095	2023-07-19	2023-07-20	86	0	79	0	64	0	58	0	57	0	46	0	2023-08-13
726	727	2023-07	1	110	6260095	2023-07-19	<NA>	0	0	2	0	1	0	12	0	13	0	17	0	2023-08-13
727	728	2023-07	1	111	6260095	2023-07-19	<NA>	0	0	0	0	0	0	0	0	0	0	0	0	2023-08-13

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample