gimi9 Pandas Profiling

Dataset statistics

Number of variables	14
Number of observations	10000
Missing cells	1786
Missing cells (%)	1.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.3 MiB
Average record size in memory	133.0 B

Variable types

Text	1
Numeric	13

Dataset

Description	진주시 지번별 2012년 1월~12월 상수도 사용량 에너지 관련 정보 제공(주소, 1월사용량, 2월사용량, 3월사용량, 4월사용량, 5월사용량, 6월사용량, 7월사용량, 8월사용량, 9월사용량, 10월사용량, 11월사용량, 12월사용량, 사용량합계)
Author	경상남도 진주시
URL	https://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15025330

Alerts

`1월사용량` is highly overall correlated with `2월사용량` and 11 other fields	High correlation
`2월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`3월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`4월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`5월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`6월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`7월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`8월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`9월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`10월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`11월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`12월사용량` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`사용량합계` is highly overall correlated with `1월사용량` and 11 other fields	High correlation
`1월사용량` has 259 (2.6%) missing values	Missing
`2월사용량` has 232 (2.3%) missing values	Missing
`3월사용량` has 226 (2.3%) missing values	Missing
`4월사용량` has 222 (2.2%) missing values	Missing
`5월사용량` has 198 (2.0%) missing values	Missing
`6월사용량` has 179 (1.8%) missing values	Missing
`7월사용량` has 156 (1.6%) missing values	Missing
`8월사용량` has 132 (1.3%) missing values	Missing
`1월사용량` is highly skewed (γ1 = 84.19008056)	Skewed
`2월사용량` is highly skewed (γ1 = 85.78432985)	Skewed
`3월사용량` is highly skewed (γ1 = 86.0413703)	Skewed
`4월사용량` is highly skewed (γ1 = 83.22831311)	Skewed
`5월사용량` is highly skewed (γ1 = 86.31187833)	Skewed
`6월사용량` is highly skewed (γ1 = 85.78871132)	Skewed
`7월사용량` is highly skewed (γ1 = 86.16489133)	Skewed
`8월사용량` is highly skewed (γ1 = 83.58781165)	Skewed
`9월사용량` is highly skewed (γ1 = 83.19106697)	Skewed
`10월사용량` is highly skewed (γ1 = 80.35529444)	Skewed
`11월사용량` is highly skewed (γ1 = 80.81720373)	Skewed
`12월사용량` is highly skewed (γ1 = 84.98271446)	Skewed
`사용량합계` is highly skewed (γ1 = 85.23933094)	Skewed
`1월사용량` has 387 (3.9%) zeros	Zeros
`2월사용량` has 494 (4.9%) zeros	Zeros
`3월사용량` has 555 (5.5%) zeros	Zeros
`4월사용량` has 561 (5.6%) zeros	Zeros
`5월사용량` has 594 (5.9%) zeros	Zeros
`6월사용량` has 525 (5.2%) zeros	Zeros
`7월사용량` has 486 (4.9%) zeros	Zeros
`8월사용량` has 460 (4.6%) zeros	Zeros
`9월사용량` has 476 (4.8%) zeros	Zeros
`10월사용량` has 434 (4.3%) zeros	Zeros
`11월사용량` has 446 (4.5%) zeros	Zeros
`12월사용량` has 452 (4.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:15:09.014088
Analysis finished	2023-12-11 00:15:32.718145
Duration	23.7 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

주소
Text

Distinct	9945
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	51
Median length	44
Mean length	25.3862
Min length	14

Characters and Unicode

Total characters	253862
Distinct characters	491
Distinct categories	9 ?
Distinct scripts	4 ?
Distinct blocks	3 ?

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

Unique

Unique	9892 ?
Unique (%)	98.9%

Sample

1st row	경상남동 진주시 강남로247번길 3
2nd row	경상남동 진주시 향교로131번길 9-6
3rd row	경상남동 진주시 진양호로625번길 3
4th row	경상남동 진주시 진산로10번길 37-15
5th row	경상남동 진주시 상봉대룡길 27-1, (22/4) (상봉동)

Value	Count	Frequency (%)
경상남동	10000	20.0%
진주시	10000	20.0%
상대동	593	1.2%
문산읍	421	0.8%
신안동	380	0.8%
금산면	354	0.7%
상봉동	351	0.7%
대곡면	307	0.6%
집현면	271	0.5%
명석면	263	0.5%
Other values (5352)	27045	54.1%

Most occurring characters

Value	Count	Frequency (%)
	42065	16.6%
동	14654	5.8%
1	12198	4.8%
진	11997	4.7%
상	11334	4.5%
주	10885	4.3%
남	10709	4.2%
경	10437	4.1%
시	10049	4.0%
길	8576	3.4%
Other values (481)	110958	43.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	141818	55.9%
Decimal Number	49023	19.3%
Space Separator	42065	16.6%
Open Punctuation	5958	2.3%
Close Punctuation	5804	2.3%
Dash Punctuation	5065	2.0%
Other Punctuation	4111	1.6%
Uppercase Letter	16	< 0.1%
Math Symbol	2	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	14654	10.3%
진	11997	8.5%
상	11334	8.0%
주	10885	7.7%
남	10709	7.6%
경	10437	7.4%
시	10049	7.1%
길	8576	6.0%
로	7772	5.5%
번	6545	4.6%
Other values (447)	38860	27.4%

Uppercase Letter

Value	Count	Frequency (%)
B	3	18.8%
K	2	12.5%
G	2	12.5%
L	2	12.5%
A	1	6.2%
Q	1	6.2%
O	1	6.2%
S	1	6.2%
P	1	6.2%
C	1	6.2%

Decimal Number

Value	Count	Frequency (%)
1	12198	24.9%
2	6629	13.5%
3	5151	10.5%
4	4451	9.1%
5	4416	9.0%
6	3652	7.4%
7	3347	6.8%
9	3191	6.5%
8	3008	6.1%
0	2980	6.1%

Other Punctuation

Value	Count	Frequency (%)
/	2040	49.6%
,	2007	48.8%
.	57	1.4%
:	4	0.1%
?	3	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	5924	99.4%
[	34	0.6%

Close Punctuation

Value	Count	Frequency (%)
)	5770	99.4%
]	34	0.6%

Math Symbol

Value	Count	Frequency (%)
>	1	50.0%
<	1	50.0%

Space Separator

Value	Count	Frequency (%)
	42065	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5065	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	141817	55.9%
Common	112028	44.1%
Latin	16	< 0.1%
Han	1	< 0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	14654	10.3%
진	11997	8.5%
상	11334	8.0%
주	10885	7.7%
남	10709	7.6%
경	10437	7.4%
시	10049	7.1%
길	8576	6.0%
로	7772	5.5%
번	6545	4.6%
Other values (446)	38859	27.4%

Common

Value	Count	Frequency (%)
	42065	37.5%
1	12198	10.9%
2	6629	5.9%
(	5924	5.3%
)	5770	5.2%
3	5151	4.6%
-	5065	4.5%
4	4451	4.0%
5	4416	3.9%
6	3652	3.3%
Other values (13)	16707	14.9%

Latin

Value	Count	Frequency (%)
B	3	18.8%
K	2	12.5%
G	2	12.5%
L	2	12.5%
A	1	6.2%
Q	1	6.2%
O	1	6.2%
S	1	6.2%
P	1	6.2%
C	1	6.2%

Han

Value	Count	Frequency (%)
新	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	141817	55.9%
ASCII	112044	44.1%
CJK	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	42065	37.5%
1	12198	10.9%
2	6629	5.9%
(	5924	5.3%
)	5770	5.1%
3	5151	4.6%
-	5065	4.5%
4	4451	4.0%
5	4416	3.9%
6	3652	3.3%
Other values (24)	16723	14.9%

Hangul

Value	Count	Frequency (%)
동	14654	10.3%
진	11997	8.5%
상	11334	8.0%
주	10885	7.7%
남	10709	7.6%
경	10437	7.4%
시	10049	7.1%
길	8576	6.0%
로	7772	5.5%
번	6545	4.6%
Other values (446)	38859	27.4%

CJK

Value	Count	Frequency (%)
新	1	100.0%

1월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	385
Distinct (%)	4.0%
Missing	259
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	69.197824

Minimum	0
Maximum	125820
Zeros	387
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	20
Q3	41
95-th percentile	120
Maximum	125820
Range	125820
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	1351.8788
Coefficient of variation (CV)	19.536435
Kurtosis	7715.9222
Mean	69.197824
Median Absolute Deviation (MAD)	14
Skewness	84.190081
Sum	674056
Variance	1827576.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	387	3.9%
10	339	3.4%
3	265	2.6%
6	259	2.6%
5	258	2.6%
4	257	2.6%
1	247	2.5%
15	245	2.5%
2	244	2.4%
7	233	2.3%
Other values (375)	7007	70.1%
(Missing)	259	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	387	3.9%
1	247	2.5%
2	244	2.4%
3	265	2.6%
4	257	2.6%
5	258	2.6%
6	259	2.6%
7	233	2.3%
8	225	2.2%
9	179	1.8%

Value	Count	Frequency (%)
125820	1	< 0.1%
29140	1	< 0.1%
18960	1	< 0.1%
13371	1	< 0.1%
10096	1	< 0.1%
9001	1	< 0.1%
7263	1	< 0.1%
6126	1	< 0.1%
5595	1	< 0.1%
5539	1	< 0.1%

2월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	396
Distinct (%)	4.1%
Missing	232
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	71.31767

Minimum	0
Maximum	137480
Zeros	494
Zeros (%)	4.9%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8
median	20
Q3	42
95-th percentile	123
Maximum	137480
Range	137480
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	1465.1373
Coefficient of variation (CV)	20.543819
Kurtosis	7945.5822
Mean	71.31767
Median Absolute Deviation (MAD)	14
Skewness	85.78433
Sum	696631
Variance	2146627.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	494	4.9%
10	287	2.9%
1	271	2.7%
2	265	2.6%
4	254	2.5%
3	253	2.5%
12	246	2.5%
15	240	2.4%
7	240	2.4%
6	234	2.3%
Other values (386)	6984	69.8%
(Missing)	232	2.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	494	4.9%
1	271	2.7%
2	265	2.6%
3	253	2.5%
4	254	2.5%
5	230	2.3%
6	234	2.3%
7	240	2.4%
8	223	2.2%
9	219	2.2%

Value	Count	Frequency (%)
137480	1	< 0.1%
30320	1	< 0.1%
19000	1	< 0.1%
13169	1	< 0.1%
10096	1	< 0.1%
9015	1	< 0.1%
7027	1	< 0.1%
5595	1	< 0.1%
5463	1	< 0.1%
5419	1	< 0.1%

3월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	395
Distinct (%)	4.0%
Missing	226
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	72.827502

Minimum	0
Maximum	139540
Zeros	555
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	21
Q3	44
95-th percentile	126
Maximum	139540
Range	139540
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	1484.8854
Coefficient of variation (CV)	20.389076
Kurtosis	7985.8878
Mean	72.827502
Median Absolute Deviation (MAD)	14
Skewness	86.04137
Sum	711816
Variance	2204884.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	555	5.5%
10	284	2.8%
7	227	2.3%
12	227	2.3%
11	226	2.3%
8	223	2.2%
6	222	2.2%
15	220	2.2%
13	219	2.2%
5	218	2.2%
Other values (385)	7153	71.5%
(Missing)	226	2.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	555	5.5%
1	187	1.9%
2	203	2.0%
3	209	2.1%
4	197	2.0%
5	218	2.2%
6	222	2.2%
7	227	2.3%
8	223	2.2%
9	194	1.9%

Value	Count	Frequency (%)
139540	1	< 0.1%
29940	1	< 0.1%
19150	1	< 0.1%
13452	1	< 0.1%
9845	1	< 0.1%
8943	1	< 0.1%
7180	1	< 0.1%
6765	1	< 0.1%
6616	1	< 0.1%
6277	1	< 0.1%

4월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	370
Distinct (%)	3.8%
Missing	222
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	64.642463

Minimum	0
Maximum	123010
Zeros	561
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	18
Q3	38
95-th percentile	113
Maximum	123010
Range	123010
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	1327.3241
Coefficient of variation (CV)	20.533316
Kurtosis	7567.6216
Mean	64.642463
Median Absolute Deviation (MAD)	13
Skewness	83.228313
Sum	632074
Variance	1761789.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	561	5.6%
1	322	3.2%
3	311	3.1%
2	301	3.0%
10	296	3.0%
7	264	2.6%
4	261	2.6%
5	258	2.6%
8	253	2.5%
12	247	2.5%
Other values (360)	6704	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	561	5.6%
1	322	3.2%
2	301	3.0%
3	311	3.1%
4	261	2.6%
5	258	2.6%
6	243	2.4%
7	264	2.6%
8	253	2.5%
9	225	2.2%

Value	Count	Frequency (%)
123010	1	< 0.1%
28170	1	< 0.1%
26170	1	< 0.1%
11814	1	< 0.1%
8413	1	< 0.1%
8303	1	< 0.1%
6774	1	< 0.1%
6118	1	< 0.1%
5575	1	< 0.1%
4786	1	< 0.1%

5월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	374
Distinct (%)	3.8%
Missing	198
Missing (%)	2.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.19292

Minimum	0
Maximum	138030
Zeros	594
Zeros (%)	5.9%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	19
Q3	39
95-th percentile	119
Maximum	138030
Range	138030
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	1466.1905
Coefficient of variation (CV)	21.500627
Kurtosis	8022.3845
Mean	68.19292
Median Absolute Deviation (MAD)	14
Skewness	86.311878
Sum	668427
Variance	2149714.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	594	5.9%
2	302	3.0%
10	302	3.0%
5	277	2.8%
3	274	2.7%
1	271	2.7%
4	262	2.6%
11	247	2.5%
7	243	2.4%
6	241	2.4%
Other values (364)	6789	67.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	594	5.9%
1	271	2.7%
2	302	3.0%
3	274	2.7%
4	262	2.6%
5	277	2.8%
6	241	2.4%
7	243	2.4%
8	234	2.3%
9	225	2.2%

Value	Count	Frequency (%)
138030	1	< 0.1%
29730	1	< 0.1%
20560	1	< 0.1%
12976	1	< 0.1%
9287	1	< 0.1%
8936	1	< 0.1%
7290	1	< 0.1%
5993	1	< 0.1%
5803	1	< 0.1%
5234	1	< 0.1%

6월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	391
Distinct (%)	4.0%
Missing	179
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	69.797882

Minimum	0
Maximum	134110
Zeros	525
Zeros (%)	5.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8
median	20
Q3	41
95-th percentile	120
Maximum	134110
Range	134110
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	1426.6675
Coefficient of variation (CV)	20.439982
Kurtosis	7959.0608
Mean	69.797882
Median Absolute Deviation (MAD)	14
Skewness	85.788711
Sum	685485
Variance	2035380.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	525	5.2%
10	266	2.7%
2	265	2.6%
5	264	2.6%
7	260	2.6%
3	256	2.6%
6	244	2.4%
1	238	2.4%
12	232	2.3%
4	231	2.3%
Other values (381)	7040	70.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	525	5.2%
1	238	2.4%
2	265	2.6%
3	256	2.6%
4	231	2.3%
5	264	2.6%
6	244	2.4%
7	260	2.6%
8	228	2.3%
9	217	2.2%

Value	Count	Frequency (%)
134110	1	< 0.1%
29200	1	< 0.1%
19293	1	< 0.1%
13023	1	< 0.1%
9295	1	< 0.1%
8949	1	< 0.1%
7850	1	< 0.1%
6983	1	< 0.1%
5845	1	< 0.1%
5715	1	< 0.1%

7월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	381
Distinct (%)	3.9%
Missing	156
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	72.49807

Minimum	0
Maximum	138900
Zeros	486
Zeros (%)	4.9%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	21
Q3	44
95-th percentile	124
Maximum	138900
Range	138900
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	1474.0211
Coefficient of variation (CV)	20.331867
Kurtosis	8017.1876
Mean	72.49807
Median Absolute Deviation (MAD)	15
Skewness	86.164891
Sum	713671
Variance	2172738.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	486	4.9%
20	257	2.6%
10	255	2.5%
5	247	2.5%
3	247	2.5%
6	238	2.4%
4	233	2.3%
7	230	2.3%
15	228	2.3%
13	228	2.3%
Other values (371)	7195	72.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	486	4.9%
1	226	2.3%
2	202	2.0%
3	247	2.5%
4	233	2.3%
5	247	2.5%
6	238	2.4%
7	230	2.3%
8	210	2.1%
9	208	2.1%

Value	Count	Frequency (%)
138900	1	< 0.1%
30020	1	< 0.1%
18486	1	< 0.1%
14545	1	< 0.1%
10414	1	< 0.1%
9274	1	< 0.1%
8463	1	< 0.1%
6274	1	< 0.1%
5941	1	< 0.1%
5772	1	< 0.1%

8월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	393
Distinct (%)	4.0%
Missing	132
Missing (%)	1.3%
Infinite	0
Infinite (%)	0.0%
Mean	72.750203

Minimum	0
Maximum	128300
Zeros	460
Zeros (%)	4.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	23
Q3	46
95-th percentile	126
Maximum	128300
Range	128300
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	1377.9929
Coefficient of variation (CV)	18.941431
Kurtosis	7639.4494
Mean	72.750203
Median Absolute Deviation (MAD)	16
Skewness	83.587812
Sum	717899
Variance	1898864.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	460	4.6%
10	270	2.7%
2	242	2.4%
5	240	2.4%
8	233	2.3%
1	230	2.3%
20	225	2.2%
4	223	2.2%
12	221	2.2%
3	220	2.2%
Other values (383)	7304	73.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	460	4.6%
1	230	2.3%
2	242	2.4%
3	220	2.2%
4	223	2.2%
5	240	2.4%
6	186	1.9%
7	216	2.2%
8	233	2.3%
9	192	1.9%

Value	Count	Frequency (%)
128300	1	< 0.1%
33140	1	< 0.1%
18622	1	< 0.1%
14348	1	< 0.1%
10271	1	< 0.1%
9247	1	< 0.1%
8880	1	< 0.1%
6482	1	< 0.1%
5862	1	< 0.1%
5588	1	< 0.1%

9월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	396
Distinct (%)	4.0%
Missing	87
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	75.055483

Minimum	0
Maximum	129670
Zeros	476
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	24
Q3	49
95-th percentile	129.4
Maximum	129670
Range	129670
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	1392.5848
Coefficient of variation (CV)	18.554071
Kurtosis	7603.8916
Mean	75.055483
Median Absolute Deviation (MAD)	17
Skewness	83.191067
Sum	744025
Variance	1939292.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	476	4.8%
4	230	2.3%
10	228	2.3%
15	216	2.2%
7	214	2.1%
1	213	2.1%
5	213	2.1%
20	212	2.1%
2	211	2.1%
8	211	2.1%
Other values (386)	7489	74.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	476	4.8%
1	213	2.1%
2	211	2.1%
3	195	1.9%
4	230	2.3%
5	213	2.1%
6	202	2.0%
7	214	2.1%
8	211	2.1%
9	187	1.9%

Value	Count	Frequency (%)
129670	1	< 0.1%
32230	1	< 0.1%
19922	1	< 0.1%
15896	1	< 0.1%
10834	1	< 0.1%
10155	1	< 0.1%
9262	1	< 0.1%
7389	1	< 0.1%
6930	1	< 0.1%
6553	1	< 0.1%

10월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	401
Distinct (%)	4.0%
Missing	49
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	75.700533

Minimum	0
Maximum	121430
Zeros	434
Zeros (%)	4.3%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	11
median	25
Q3	49
95-th percentile	130
Maximum	121430
Range	121430
Interquartile range (IQR)	38

Descriptive statistics

Standard deviation	1322.3287
Coefficient of variation (CV)	17.467891
Kurtosis	7191.0858
Mean	75.700533
Median Absolute Deviation (MAD)	16
Skewness	80.355294
Sum	753296
Variance	1748553.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	434	4.3%
10	241	2.4%
15	226	2.3%
12	221	2.2%
3	220	2.2%
20	216	2.2%
6	215	2.1%
5	205	2.1%
8	202	2.0%
13	196	2.0%
Other values (391)	7575	75.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	434	4.3%
1	177	1.8%
2	171	1.7%
3	220	2.2%
4	171	1.7%
5	205	2.1%
6	215	2.1%
7	182	1.8%
8	202	2.0%
9	167	1.7%

Value	Count	Frequency (%)
121430	1	< 0.1%
35610	1	< 0.1%
19829	1	< 0.1%
15627	1	< 0.1%
10563	1	< 0.1%
9260	1	< 0.1%
9130	1	< 0.1%
7415	1	< 0.1%
6453	1	< 0.1%
6239	1	< 0.1%

11월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	392
Distinct (%)	3.9%
Missing	45
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	69.878252

Minimum	0
Maximum	105280
Zeros	446
Zeros (%)	4.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	23
Q3	46
95-th percentile	127
Maximum	105280
Range	105280
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	1141.5502
Coefficient of variation (CV)	16.336273
Kurtosis	7291.755
Mean	69.878252
Median Absolute Deviation (MAD)	16
Skewness	80.817204
Sum	695638
Variance	1303136.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	446	4.5%
10	310	3.1%
20	241	2.4%
2	236	2.4%
15	230	2.3%
3	228	2.3%
5	225	2.2%
1	218	2.2%
7	217	2.2%
13	214	2.1%
Other values (382)	7390	73.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	446	4.5%
1	218	2.2%
2	236	2.4%
3	228	2.3%
4	205	2.1%
5	225	2.2%
6	203	2.0%
7	217	2.2%
8	203	2.0%
9	165	1.7%

Value	Count	Frequency (%)
105280	1	< 0.1%
27340	1	< 0.1%
17115	1	< 0.1%
14522	1	< 0.1%
9347	1	< 0.1%
8449	1	< 0.1%
8302	1	< 0.1%
6636	1	< 0.1%
6189	1	< 0.1%
5911	1	< 0.1%

12월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	395
Distinct (%)	4.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	67.493649

Minimum	0
Maximum	109780
Zeros	452
Zeros (%)	4.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	8
median	20
Q3	43
95-th percentile	122
Maximum	109780
Range	109780
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	1163.467
Coefficient of variation (CV)	17.23817
Kurtosis	7924.1138
Mean	67.493649
Median Absolute Deviation (MAD)	14
Skewness	84.982714
Sum	674869
Variance	1353655.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	452	4.5%
2	314	3.1%
10	298	3.0%
5	274	2.7%
4	263	2.6%
3	261	2.6%
1	256	2.6%
6	243	2.4%
7	241	2.4%
15	227	2.3%
Other values (385)	7170	71.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	452	4.5%
1	256	2.6%
2	314	3.1%
3	261	2.6%
4	263	2.6%
5	274	2.7%
6	243	2.4%
7	241	2.4%
8	205	2.1%
9	219	2.2%

Value	Count	Frequency (%)
109780	1	< 0.1%
17880	1	< 0.1%
17308	1	< 0.1%
13903	1	< 0.1%
9671	1	< 0.1%
9088	1	< 0.1%
8445	1	< 0.1%
6353	1	< 0.1%
6020	1	< 0.1%
5641	1	< 0.1%

사용량합계
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1681
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	836.7887

Minimum	1
Maximum	1531350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	22
Q1	120
median	258
Q3	514
95-th percentile	1398.1
Maximum	1531350
Range	1531349
Interquartile range (IQR)	394

Descriptive statistics

Standard deviation	16242.863
Coefficient of variation (CV)	19.41095
Kurtosis	7913.4661
Mean	836.7887
Median Absolute Deviation (MAD)	169
Skewness	85.239331
Sum	8367887
Variance	2.6383061 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	53	0.5%
2	38	0.4%
73	34	0.3%
4	34	0.3%
151	31	0.3%
36	31	0.3%
78	29	0.3%
49	28	0.3%
84	28	0.3%
127	28	0.3%
Other values (1671)	9666	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	53	0.5%
2	38	0.4%
3	28	0.3%
4	34	0.3%
5	19	0.2%
6	20	0.2%
7	17	0.2%
8	22	0.2%
9	15	0.1%
10	24	0.2%

Value	Count	Frequency (%)
1531350	1	< 0.1%
350720	1	< 0.1%
236415	1	< 0.1%
166646	1	< 0.1%
117230	1	< 0.1%
109522	1	< 0.1%
95866	1	< 0.1%
73761	1	< 0.1%
72165	1	< 0.1%
69231	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
1월사용량	1.000	0.996	0.996	0.863	0.996	0.996	1.000	1.000	1.000	1.000	1.000	1.000	1.000
2월사용량	0.996	1.000	1.000	1.000	1.000	1.000	0.996	0.996	0.996	0.996	0.996	0.842	0.996
3월사용량	0.996	1.000	1.000	1.000	1.000	1.000	0.996	0.996	0.996	0.996	0.996	0.842	0.996
4월사용량	0.863	1.000	1.000	1.000	1.000	1.000	0.863	0.863	0.863	0.863	0.863	0.995	0.863
5월사용량	0.996	1.000	1.000	1.000	1.000	1.000	0.996	0.996	0.996	0.996	0.996	0.842	0.996
6월사용량	0.996	1.000	1.000	1.000	1.000	1.000	0.996	0.996	0.996	0.996	0.996	0.842	0.996
7월사용량	1.000	0.996	0.996	0.863	0.996	0.996	1.000	1.000	1.000	1.000	1.000	1.000	1.000
8월사용량	1.000	0.996	0.996	0.863	0.996	0.996	1.000	1.000	1.000	1.000	1.000	1.000	1.000
9월사용량	1.000	0.996	0.996	0.863	0.996	0.996	1.000	1.000	1.000	1.000	1.000	1.000	1.000
10월사용량	1.000	0.996	0.996	0.863	0.996	0.996	1.000	1.000	1.000	1.000	1.000	1.000	1.000
11월사용량	1.000	0.996	0.996	0.863	0.996	0.996	1.000	1.000	1.000	1.000	1.000	1.000	1.000
12월사용량	1.000	0.842	0.842	0.995	0.842	0.842	1.000	1.000	1.000	1.000	1.000	1.000	1.000
사용량합계	1.000	0.996	0.996	0.863	0.996	0.996	1.000	1.000	1.000	1.000	1.000	1.000	1.000

Heatmap
Table

	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
1월사용량	1.000	0.915	0.846	0.840	0.856	0.859	0.853	0.849	0.833	0.834	0.830	0.831	0.914
2월사용량	0.915	1.000	0.872	0.841	0.845	0.845	0.838	0.832	0.814	0.813	0.811	0.813	0.907
3월사용량	0.846	0.872	1.000	0.836	0.824	0.818	0.811	0.801	0.786	0.787	0.781	0.780	0.886
4월사용량	0.840	0.841	0.836	1.000	0.903	0.873	0.852	0.836	0.820	0.816	0.813	0.811	0.907
5월사용량	0.856	0.845	0.824	0.903	1.000	0.926	0.898	0.875	0.856	0.848	0.842	0.842	0.928
6월사용량	0.859	0.845	0.818	0.873	0.926	1.000	0.936	0.905	0.882	0.874	0.863	0.861	0.938
7월사용량	0.853	0.838	0.811	0.852	0.898	0.936	1.000	0.933	0.903	0.894	0.883	0.879	0.939
8월사용량	0.849	0.832	0.801	0.836	0.875	0.905	0.933	1.000	0.934	0.916	0.900	0.891	0.941
9월사용량	0.833	0.814	0.786	0.820	0.856	0.882	0.903	0.934	1.000	0.939	0.912	0.895	0.933
10월사용량	0.834	0.813	0.787	0.816	0.848	0.874	0.894	0.916	0.939	1.000	0.935	0.912	0.933
11월사용량	0.830	0.811	0.781	0.813	0.842	0.863	0.883	0.900	0.912	0.935	1.000	0.935	0.927
12월사용량	0.831	0.813	0.780	0.811	0.842	0.861	0.879	0.891	0.895	0.912	0.935	1.000	0.916
사용량합계	0.914	0.907	0.886	0.907	0.928	0.938	0.939	0.941	0.933	0.933	0.927	0.916	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

	주소	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
15752	경상남동 진주시 강남로247번길 3	10	10	8	17	15	10	11	16	20	15	16	15	163
39405	경상남동 진주시 향교로131번길 9-6	36	32	49	44	60	56	73	74	77	64	72	61	698
36975	경상남동 진주시 진양호로625번길 3	32	44	48	34	43	46	53	51	56	66	56	48	577
11799	경상남동 진주시 진산로10번길 37-15	6	12	14	10	8	8	20	7	8	13	7	7	120
29267	경상남동 진주시 상봉대룡길 27-1, (22/4) (상봉동)	27	27	29	22	41	30	28	32	39	28	26	27	356
38751	경상남동 진주시 창렬로43번길 8, (13/1 (인사동)	54	45	52	42	51	53	57	62	72	59	53	59	659
25658	경상남동 진주시 돗골로117번길 18 (상대동)	19	22	37	24	20	23	21	22	25	24	21	33	291
29269	경상남동 진주시 의곡길 36-1	19	28	35	19	25	23	26	43	36	39	29	34	356
46949	경상남동 진주시 가호로 13 (가좌동)	2198	3013	3288	2479	1862	1992	2323	2811	3554	3008	2526	1843	30897
10768	경상남동 진주시 망경남길24번길 7-15	11	5	11	8	7	6	7	9	8	8	17	12	109

	주소	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
2940	경상남동 진주시 내동면 산유로456번길 54-17	0	0	2	1	1	1	5	4	5	3	5	2	29
12824	경상남동 진주시 진양호로 409-5 (신안동)	10	5	8	5	5	5	8	28	17	13	13	14	131
25961	경상남동 진주시 북장대로69번길 6-3, (7/2) (상봉동)	20	17	18	16	28	23	30	12	24	39	35	34	296
20886	경상남동 진주시 일반성면 수목원로277번길 12-6	10	13	25	17	19	21	20	23	23	20	18	14	223
28327	경상남동 진주시 비봉로97번길 15-8	28	24	32	27	25	21	27	32	36	39	25	21	337
5740	경상남동 진주시 월아산로 2083, 동명모터펌프 (초전동)	2	3	0	2	9	5	3	4	6	5	16	2	57
44180	경상남동 진주시 도동로223번길 19 (하대동)	91	91	132	106	111	103	95	114	159	106	90	94	1292
41267	경상남동 진주시 도동로263번길 10-5 (하대동)	53	55	94	77	95	63	61	71	75	67	69	63	843
32283	경상남동 진주시 창렬로 199	26	32	26	34	30	37	27	36	53	50	45	29	425
32850	경상남동 진주시 모덕로197번길 4-2	42	86	37	31	11	13	15	38	40	45	53	29	440

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Other Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Han

Most occurring blocks

Most frequent character per block

ASCII

Hangul

CJK

Interactions

Correlations

Missing values

Sample