gimi9 Pandas Profiling

Dataset statistics

Number of variables	14
Number of observations	10000
Missing cells	1737
Missing cells (%)	1.2%
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 274 (2.7%) missing values	Missing
`2월사용량` has 228 (2.3%) missing values	Missing
`3월사용량` has 225 (2.2%) missing values	Missing
`4월사용량` has 221 (2.2%) missing values	Missing
`5월사용량` has 213 (2.1%) missing values	Missing
`6월사용량` has 185 (1.8%) missing values	Missing
`7월사용량` has 171 (1.7%) missing values	Missing
`8월사용량` has 130 (1.3%) missing values	Missing
`1월사용량` is highly skewed (γ1 = 27.87073262)	Skewed
`2월사용량` is highly skewed (γ1 = 27.28948596)	Skewed
`3월사용량` is highly skewed (γ1 = 27.62684971)	Skewed
`4월사용량` is highly skewed (γ1 = 27.349113)	Skewed
`5월사용량` is highly skewed (γ1 = 27.19611081)	Skewed
`6월사용량` is highly skewed (γ1 = 27.56651397)	Skewed
`7월사용량` is highly skewed (γ1 = 27.06089951)	Skewed
`8월사용량` is highly skewed (γ1 = 28.40125515)	Skewed
`9월사용량` is highly skewed (γ1 = 27.59854901)	Skewed
`10월사용량` is highly skewed (γ1 = 27.74573206)	Skewed
`11월사용량` is highly skewed (γ1 = 26.65837963)	Skewed
`12월사용량` is highly skewed (γ1 = 27.21544309)	Skewed
`사용량합계` is highly skewed (γ1 = 27.68291541)	Skewed
`1월사용량` has 471 (4.7%) zeros	Zeros
`2월사용량` has 578 (5.8%) zeros	Zeros
`3월사용량` has 553 (5.5%) zeros	Zeros
`4월사용량` has 570 (5.7%) zeros	Zeros
`5월사용량` has 513 (5.1%) zeros	Zeros
`6월사용량` has 483 (4.8%) zeros	Zeros
`7월사용량` has 461 (4.6%) zeros	Zeros
`8월사용량` has 442 (4.4%) zeros	Zeros
`9월사용량` has 426 (4.3%) zeros	Zeros
`10월사용량` has 440 (4.4%) zeros	Zeros
`11월사용량` has 468 (4.7%) zeros	Zeros
`12월사용량` has 511 (5.1%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:18:23.453681
Analysis finished	2023-12-11 00:18:46.662058
Duration	23.21 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

주소
Text

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

Length

Max length	51
Median length	42
Mean length	25.3792
Min length	14

Characters and Unicode

Total characters	253792
Distinct characters	495
Distinct categories	10 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

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

Unique

Unique	9899 ?
Unique (%)	99.0%

Sample

1st row	경상남도 진주시 사봉면 동부로1769번길 9 (중촌마을)
2nd row	경상남도 진주시 미천면 상미로 55-3
3rd row	경상남도 진주시 촉석로 145, (9/5) (봉곡동) (옥외원격검침 2012)
4th row	경상남도 진주시 동진로 169 (상대동) 도동치과
5th row	경상남도 진주시 대곡면 오방로 108

Value	Count	Frequency (%)
경상남도	10000	20.0%
진주시	10000	20.0%
상대동	590	1.2%
문산읍	438	0.9%
금산면	375	0.7%
상봉동	344	0.7%
신안동	339	0.7%
대곡면	320	0.6%
집현면	254	0.5%
명석면	233	0.5%
Other values (5523)	27160	54.3%

Most occurring characters

Value	Count	Frequency (%)
	42098	16.6%
1	12170	4.8%
진	11919	4.7%
상	11328	4.5%
주	10833	4.3%
남	10791	4.3%
경	10490	4.1%
도	10308	4.1%
시	10038	4.0%
길	8550	3.4%
Other values (485)	115267	45.4%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	141969	55.9%
Decimal Number	48945	19.3%
Space Separator	42098	16.6%
Open Punctuation	5904	2.3%
Close Punctuation	5731	2.3%
Dash Punctuation	5094	2.0%
Other Punctuation	4001	1.6%
Uppercase Letter	43	< 0.1%
Math Symbol	6	< 0.1%
Lowercase Letter	1	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
진	11919	8.4%
상	11328	8.0%
주	10833	7.6%
남	10791	7.6%
경	10490	7.4%
도	10308	7.3%
시	10038	7.1%
길	8550	6.0%
로	7819	5.5%
번	6560	4.6%
Other values (442)	43333	30.5%

Uppercase Letter

Value	Count	Frequency (%)
S	7	16.3%
G	5	11.6%
L	4	9.3%
K	4	9.3%
A	3	7.0%
B	3	7.0%
T	3	7.0%
P	2	4.7%
O	2	4.7%
N	2	4.7%
Other values (7)	8	18.6%

Decimal Number

Value	Count	Frequency (%)
1	12170	24.9%
2	6672	13.6%
3	5185	10.6%
4	4479	9.2%
5	4296	8.8%
6	3606	7.4%
7	3306	6.8%
9	3223	6.6%
0	3050	6.2%
8	2958	6.0%

Other Punctuation

Value	Count	Frequency (%)
/	2002	50.0%
,	1958	48.9%
.	36	0.9%
:	4	0.1%
&	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
<	2	33.3%
>	2	33.3%
+	1	16.7%
~	1	16.7%

Open Punctuation

Value	Count	Frequency (%)
(	5871	99.4%
[	33	0.6%

Close Punctuation

Value	Count	Frequency (%)
)	5698	99.4%
]	33	0.6%

Space Separator

Value	Count	Frequency (%)
	42098	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5094	100.0%

Lowercase Letter

Value	Count	Frequency (%)
x	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	141969	55.9%
Common	111779	44.0%
Latin	44	< 0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
진	11919	8.4%
상	11328	8.0%
주	10833	7.6%
남	10791	7.6%
경	10490	7.4%
도	10308	7.3%
시	10038	7.1%
길	8550	6.0%
로	7819	5.5%
번	6560	4.6%
Other values (442)	43333	30.5%

Common

Value	Count	Frequency (%)
	42098	37.7%
1	12170	10.9%
2	6672	6.0%
(	5871	5.3%
)	5698	5.1%
3	5185	4.6%
-	5094	4.6%
4	4479	4.0%
5	4296	3.8%
6	3606	3.2%
Other values (15)	16610	14.9%

Latin

Value	Count	Frequency (%)
S	7	15.9%
G	5	11.4%
L	4	9.1%
K	4	9.1%
A	3	6.8%
B	3	6.8%
T	3	6.8%
P	2	4.5%
O	2	4.5%
N	2	4.5%
Other values (8)	9	20.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	141969	55.9%
ASCII	111823	44.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	42098	37.6%
1	12170	10.9%
2	6672	6.0%
(	5871	5.3%
)	5698	5.1%
3	5185	4.6%
-	5094	4.6%
4	4479	4.0%
5	4296	3.8%
6	3606	3.2%
Other values (33)	16654	14.9%

Hangul

Value	Count	Frequency (%)
진	11919	8.4%
상	11328	8.0%
주	10833	7.6%
남	10791	7.6%
경	10490	7.4%
도	10308	7.3%
시	10038	7.1%
길	8550	6.0%
로	7819	5.5%
번	6560	4.6%
Other values (442)	43333	30.5%

1월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	384
Distinct (%)	3.9%
Missing	274
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	58.468024

Minimum	0
Maximum	21016
Zeros	471
Zeros (%)	4.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	8
median	19
Q3	39
95-th percentile	120
Maximum	21016
Range	21016
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	466.82278
Coefficient of variation (CV)	7.9842407
Kurtosis	941.09844
Mean	58.468024
Median Absolute Deviation (MAD)	13
Skewness	27.870733
Sum	568660
Variance	217923.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	471	4.7%
1	293	2.9%
10	293	2.9%
2	286	2.9%
5	273	2.7%
4	269	2.7%
8	265	2.6%
3	265	2.6%
12	253	2.5%
7	244	2.4%
Other values (374)	6814	68.1%
(Missing)	274	2.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	471	4.7%
1	293	2.9%
2	286	2.9%
3	265	2.6%
4	269	2.7%
5	273	2.7%
6	230	2.3%
7	244	2.4%
8	265	2.6%
9	217	2.2%

Value	Count	Frequency (%)
21016	1	< 0.1%
17868	1	< 0.1%
15440	1	< 0.1%
12122	1	< 0.1%
10911	1	< 0.1%
10560	1	< 0.1%
10160	1	< 0.1%
10105	1	< 0.1%
8872	1	< 0.1%
8027	1	< 0.1%

2월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	390
Distinct (%)	4.0%
Missing	228
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	58.76054

Minimum	0
Maximum	21804
Zeros	578
Zeros (%)	5.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	19
Q3	40
95-th percentile	121
Maximum	21804
Range	21804
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	466.18513
Coefficient of variation (CV)	7.9336427
Kurtosis	917.63961
Mean	58.76054
Median Absolute Deviation (MAD)	14
Skewness	27.289486
Sum	574208
Variance	217328.57
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	578	5.8%
10	315	3.1%
5	296	3.0%
2	280	2.8%
1	278	2.8%
3	277	2.8%
4	257	2.6%
7	247	2.5%
20	247	2.5%
15	244	2.4%
Other values (380)	6753	67.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	578	5.8%
1	278	2.8%
2	280	2.8%
3	277	2.8%
4	257	2.6%
5	296	3.0%
6	242	2.4%
7	247	2.5%
8	227	2.3%
9	208	2.1%

Value	Count	Frequency (%)
21804	1	< 0.1%
16529	1	< 0.1%
13834	1	< 0.1%
12598	1	< 0.1%
10829	1	< 0.1%
10683	1	< 0.1%
9951	1	< 0.1%
9449	1	< 0.1%
8942	1	< 0.1%
8322	1	< 0.1%

3월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	393
Distinct (%)	4.0%
Missing	225
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	59.368389

Minimum	0
Maximum	21850
Zeros	553
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	9
median	19
Q3	40.5
95-th percentile	122
Maximum	21850
Range	21850
Interquartile range (IQR)	31.5

Descriptive statistics

Standard deviation	465.69222
Coefficient of variation (CV)	7.8441107
Kurtosis	938.92451
Mean	59.368389
Median Absolute Deviation (MAD)	13
Skewness	27.62685
Sum	580326
Variance	216869.24
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	553	5.5%
10	276	2.8%
13	258	2.6%
5	257	2.6%
7	256	2.6%
3	246	2.5%
11	244	2.4%
2	236	2.4%
12	234	2.3%
20	234	2.3%
Other values (383)	6981	69.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	553	5.5%
1	214	2.1%
2	236	2.4%
3	246	2.5%
4	234	2.3%
5	257	2.6%
6	226	2.3%
7	256	2.6%
8	218	2.2%
9	204	2.0%

Value	Count	Frequency (%)
21850	1	< 0.1%
16766	1	< 0.1%
14300	1	< 0.1%
12664	1	< 0.1%
11023	1	< 0.1%
10064	1	< 0.1%
9355	1	< 0.1%
9191	1	< 0.1%
8957	1	< 0.1%
8444	1	< 0.1%

4월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	366
Distinct (%)	3.7%
Missing	221
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	54.452807

Minimum	0
Maximum	19594
Zeros	570
Zeros (%)	5.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	17
Q3	37
95-th percentile	112
Maximum	19594
Range	19594
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	437.1302
Coefficient of variation (CV)	8.0276889
Kurtosis	910.24658
Mean	54.452807
Median Absolute Deviation (MAD)	12
Skewness	27.349113
Sum	532494
Variance	191082.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	570	5.7%
1	317	3.2%
10	317	3.2%
2	311	3.1%
5	300	3.0%
4	284	2.8%
3	275	2.8%
6	260	2.6%
8	259	2.6%
12	244	2.4%
Other values (356)	6642	66.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	570	5.7%
1	317	3.2%
2	311	3.1%
3	275	2.8%
4	284	2.8%
5	300	3.0%
6	260	2.6%
7	242	2.4%
8	259	2.6%
9	228	2.3%

Value	Count	Frequency (%)
19594	1	< 0.1%
16872	1	< 0.1%
13236	1	< 0.1%
11995	1	< 0.1%
10129	1	< 0.1%
9722	1	< 0.1%
9668	1	< 0.1%
8884	1	< 0.1%
8175	1	< 0.1%
6814	1	< 0.1%

5월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	392
Distinct (%)	4.0%
Missing	213
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	58.898028

Minimum	0
Maximum	22298
Zeros	513
Zeros (%)	5.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	18
Q3	39
95-th percentile	123
Maximum	22298
Range	22298
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	470.94533
Coefficient of variation (CV)	7.9959439
Kurtosis	918.34141
Mean	58.898028
Median Absolute Deviation (MAD)	13
Skewness	27.196111
Sum	576435
Variance	221789.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	513	5.1%
2	307	3.1%
3	306	3.1%
10	296	3.0%
5	294	2.9%
4	285	2.9%
1	280	2.8%
7	268	2.7%
13	262	2.6%
6	256	2.6%
Other values (382)	6720	67.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	513	5.1%
1	280	2.8%
2	307	3.1%
3	306	3.1%
4	285	2.9%
5	294	2.9%
6	256	2.6%
7	268	2.7%
8	237	2.4%
9	214	2.1%

Value	Count	Frequency (%)
22298	1	< 0.1%
15259	1	< 0.1%
14966	1	< 0.1%
13341	1	< 0.1%
10388	1	< 0.1%
10128	1	< 0.1%
9807	1	< 0.1%
9350	1	< 0.1%
9264	1	< 0.1%
8920	1	< 0.1%

6월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	387
Distinct (%)	3.9%
Missing	185
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	59.347427

Minimum	0
Maximum	21969
Zeros	483
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	8
median	19
Q3	40
95-th percentile	123
Maximum	21969
Range	21969
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	478.5569
Coefficient of variation (CV)	8.0636504
Kurtosis	927.02909
Mean	59.347427
Median Absolute Deviation (MAD)	13
Skewness	27.566514
Sum	582495
Variance	229016.71
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	483	4.8%
5	319	3.2%
10	294	2.9%
2	283	2.8%
3	266	2.7%
6	261	2.6%
8	258	2.6%
4	254	2.5%
1	251	2.5%
15	250	2.5%
Other values (377)	6896	69.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	483	4.8%
1	251	2.5%
2	283	2.8%
3	266	2.7%
4	254	2.5%
5	319	3.2%
6	261	2.6%
7	235	2.4%
8	258	2.6%
9	233	2.3%

Value	Count	Frequency (%)
21969	1	< 0.1%
17555	1	< 0.1%
14709	1	< 0.1%
14371	1	< 0.1%
10786	1	< 0.1%
10107	1	< 0.1%
10006	1	< 0.1%
9820	1	< 0.1%
8904	1	< 0.1%
8310	1	< 0.1%

7월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	403
Distinct (%)	4.1%
Missing	171
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	64.178553

Minimum	0
Maximum	22525
Zeros	461
Zeros (%)	4.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	21
Q3	43
95-th percentile	131.6
Maximum	22525
Range	22525
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	504.71526
Coefficient of variation (CV)	7.8642355
Kurtosis	890.73359
Mean	64.178553
Median Absolute Deviation (MAD)	15
Skewness	27.0609
Sum	630811
Variance	254737.49
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	461	4.6%
10	296	3.0%
4	251	2.5%
5	244	2.4%
3	238	2.4%
7	238	2.4%
2	236	2.4%
20	231	2.3%
6	231	2.3%
14	223	2.2%
Other values (393)	7180	71.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	461	4.6%
1	216	2.2%
2	236	2.4%
3	238	2.4%
4	251	2.5%
5	244	2.4%
6	231	2.3%
7	238	2.4%
8	212	2.1%
9	213	2.1%

Value	Count	Frequency (%)
22525	1	< 0.1%
19204	1	< 0.1%
15617	1	< 0.1%
13467	1	< 0.1%
11553	1	< 0.1%
11105	1	< 0.1%
10603	1	< 0.1%
9848	1	< 0.1%
9834	1	< 0.1%
9833	1	< 0.1%

8월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	397
Distinct (%)	4.0%
Missing	130
Missing (%)	1.3%
Infinite	0
Infinite (%)	0.0%
Mean	64.229483

Minimum	0
Maximum	25113
Zeros	442
Zeros (%)	4.4%
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	134
Maximum	25113
Range	25113
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	516.60105
Coefficient of variation (CV)	8.0430516
Kurtosis	996.65769
Mean	64.229483
Median Absolute Deviation (MAD)	15
Skewness	28.401255
Sum	633945
Variance	266876.64
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	442	4.4%
10	278	2.8%
5	252	2.5%
1	249	2.5%
2	246	2.5%
4	244	2.4%
7	239	2.4%
3	239	2.4%
8	234	2.3%
6	232	2.3%
Other values (387)	7215	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	442	4.4%
1	249	2.5%
2	246	2.5%
3	239	2.4%
4	244	2.4%
5	252	2.5%
6	232	2.3%
7	239	2.4%
8	234	2.3%
9	202	2.0%

Value	Count	Frequency (%)
25113	1	< 0.1%
17276	1	< 0.1%
17036	1	< 0.1%
14201	1	< 0.1%
12161	1	< 0.1%
11612	1	< 0.1%
10657	1	< 0.1%
10111	1	< 0.1%
10030	1	< 0.1%
9932	1	< 0.1%

9월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	413
Distinct (%)	4.2%
Missing	59
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	68.810482

Minimum	0
Maximum	23999
Zeros	426
Zeros (%)	4.3%
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	142
Maximum	23999
Range	23999
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	546.73752
Coefficient of variation (CV)	7.9455557
Kurtosis	904.55193
Mean	68.810482
Median Absolute Deviation (MAD)	16
Skewness	27.598549
Sum	684045
Variance	298921.91
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	426	4.3%
10	242	2.4%
5	236	2.4%
20	221	2.2%
4	215	2.1%
12	211	2.1%
18	206	2.1%
6	205	2.1%
8	203	2.0%
2	202	2.0%
Other values (403)	7574	75.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	426	4.3%
1	196	2.0%
2	202	2.0%
3	185	1.8%
4	215	2.1%
5	236	2.4%
6	205	2.1%
7	194	1.9%
8	203	2.0%
9	196	2.0%

Value	Count	Frequency (%)
23999	1	< 0.1%
20600	1	< 0.1%
18088	1	< 0.1%
15507	1	< 0.1%
12960	1	< 0.1%
12530	1	< 0.1%
12261	1	< 0.1%
11694	1	< 0.1%
10593	1	< 0.1%
10447	1	< 0.1%

10월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	412
Distinct (%)	4.1%
Missing	25
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	68.19609

Minimum	0
Maximum	23034
Zeros	440
Zeros (%)	4.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	24
Q3	48
95-th percentile	143.3
Maximum	23034
Range	23034
Interquartile range (IQR)	38

Descriptive statistics

Standard deviation	536.06042
Coefficient of variation (CV)	7.8605741
Kurtosis	916.8518
Mean	68.19609
Median Absolute Deviation (MAD)	16
Skewness	27.745732
Sum	680256
Variance	287360.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	440	4.4%
20	251	2.5%
10	246	2.5%
2	229	2.3%
7	224	2.2%
4	219	2.2%
15	218	2.2%
5	217	2.2%
1	215	2.1%
11	215	2.1%
Other values (402)	7501	75.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	440	4.4%
1	215	2.1%
2	229	2.3%
3	195	1.9%
4	219	2.2%
5	217	2.2%
6	202	2.0%
7	224	2.2%
8	180	1.8%
9	191	1.9%

Value	Count	Frequency (%)
23034	1	< 0.1%
21345	1	< 0.1%
17587	1	< 0.1%
15539	1	< 0.1%
12993	1	< 0.1%
12260	1	< 0.1%
12087	1	< 0.1%
11213	1	< 0.1%
10327	1	< 0.1%
8849	1	< 0.1%

11월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	407
Distinct (%)	4.1%
Missing	6
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	63.231539

Minimum	0
Maximum	20299
Zeros	468
Zeros (%)	4.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	22
Q3	44
95-th percentile	131.35
Maximum	20299
Range	20299
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	481.7037
Coefficient of variation (CV)	7.6180923
Kurtosis	841.67083
Mean	63.231539
Median Absolute Deviation (MAD)	15
Skewness	26.65838
Sum	631936
Variance	232038.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	468	4.7%
10	274	2.7%
1	246	2.5%
2	244	2.4%
4	234	2.3%
20	232	2.3%
5	228	2.3%
12	219	2.2%
6	212	2.1%
16	211	2.1%
Other values (397)	7426	74.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	468	4.7%
1	246	2.5%
2	244	2.4%
3	209	2.1%
4	234	2.3%
5	228	2.3%
6	212	2.1%
7	202	2.0%
8	208	2.1%
9	209	2.1%

Value	Count	Frequency (%)
20299	1	< 0.1%
17930	1	< 0.1%
14623	1	< 0.1%
14580	1	< 0.1%
13541	1	< 0.1%
11067	1	< 0.1%
10251	1	< 0.1%
9852	1	< 0.1%
9593	1	< 0.1%
8373	1	< 0.1%

12월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	399
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.2098

Minimum	0
Maximum	21130
Zeros	511
Zeros (%)	5.1%
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	130
Maximum	21130
Range	21130
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	497.48314
Coefficient of variation (CV)	7.9968612
Kurtosis	880.22419
Mean	62.2098
Median Absolute Deviation (MAD)	14
Skewness	27.215443
Sum	622098
Variance	247489.47
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	511	5.1%
3	302	3.0%
1	283	2.8%
10	280	2.8%
4	273	2.7%
2	268	2.7%
5	260	2.6%
15	257	2.6%
6	249	2.5%
7	237	2.4%
Other values (389)	7080	70.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	511	5.1%
1	283	2.8%
2	268	2.7%
3	302	3.0%
4	273	2.7%
5	260	2.6%
6	249	2.5%
7	237	2.4%
8	236	2.4%
9	223	2.2%

Value	Count	Frequency (%)
21130	1	< 0.1%
19141	1	< 0.1%
16584	1	< 0.1%
13355	1	< 0.1%
13077	1	< 0.1%
12247	1	< 0.1%
11261	1	< 0.1%
10425	1	< 0.1%
9822	1	< 0.1%
8285	1	< 0.1%

사용량합계
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1684
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	729.7709

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

Quantile statistics

Minimum	1
5-th percentile	21
Q1	114
median	247
Q3	500
95-th percentile	1490
Maximum	264631
Range	264630
Interquartile range (IQR)	386

Descriptive statistics

Standard deviation	5799.97
Coefficient of variation (CV)	7.9476587
Kurtosis	927.15281
Mean	729.7709
Median Absolute Deviation (MAD)	161.5
Skewness	27.682915
Sum	7297709
Variance	33639652
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	52	0.5%
128	37	0.4%
92	37	0.4%
2	33	0.3%
5	33	0.3%
181	32	0.3%
19	31	0.3%
136	31	0.3%
129	30	0.3%
69	30	0.3%
Other values (1674)	9654	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	52	0.5%
2	33	0.3%
3	28	0.3%
4	26	0.3%
5	33	0.3%
6	19	0.2%
7	22	0.2%
8	25	0.2%
9	22	0.2%
10	14	0.1%

Value	Count	Frequency (%)
264631	1	< 0.1%
216345	1	< 0.1%
185682	1	< 0.1%
160493	1	< 0.1%
139097	1	< 0.1%
134286	1	< 0.1%
124774	1	< 0.1%
123443	1	< 0.1%
113215	1	< 0.1%
96999	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
1월사용량	1.000	0.993	0.992	0.988	0.945	0.959	0.996	0.922	0.968	0.991	0.935	0.982	0.963
2월사용량	0.993	1.000	0.993	0.994	0.958	0.973	0.991	0.951	0.970	0.981	0.952	0.985	0.980
3월사용량	0.992	0.993	1.000	0.989	0.930	0.962	0.996	0.935	0.962	0.986	0.942	0.985	0.975
4월사용량	0.988	0.994	0.989	1.000	0.939	0.976	0.983	0.929	0.948	0.984	0.942	0.981	0.966
5월사용량	0.945	0.958	0.930	0.939	1.000	0.987	0.937	0.995	0.969	0.903	0.943	0.900	0.956
6월사용량	0.959	0.973	0.962	0.976	0.987	1.000	0.964	0.988	0.973	0.931	0.951	0.945	0.990
7월사용량	0.996	0.991	0.996	0.983	0.937	0.964	1.000	0.928	0.972	0.982	0.945	0.985	0.973
8월사용량	0.922	0.951	0.935	0.929	0.995	0.988	0.928	1.000	0.976	0.922	0.960	0.924	0.969
9월사용량	0.968	0.970	0.962	0.948	0.969	0.973	0.972	0.976	1.000	0.965	0.994	0.948	0.998
10월사용량	0.991	0.981	0.986	0.984	0.903	0.931	0.982	0.922	0.965	1.000	0.943	0.992	0.963
11월사용량	0.935	0.952	0.942	0.942	0.943	0.951	0.945	0.960	0.994	0.943	1.000	0.956	0.993
12월사용량	0.982	0.985	0.985	0.981	0.900	0.945	0.985	0.924	0.948	0.992	0.956	1.000	0.967
사용량합계	0.963	0.980	0.975	0.966	0.956	0.990	0.973	0.969	0.998	0.963	0.993	0.967	1.000

Heatmap
Table

	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
1월사용량	1.000	0.894	0.844	0.857	0.864	0.862	0.855	0.849	0.841	0.829	0.828	0.831	0.912
2월사용량	0.894	1.000	0.861	0.853	0.847	0.838	0.828	0.820	0.807	0.795	0.792	0.800	0.899
3월사용량	0.844	0.861	1.000	0.874	0.847	0.831	0.817	0.806	0.795	0.783	0.781	0.784	0.894
4월사용량	0.857	0.853	0.874	1.000	0.913	0.886	0.865	0.852	0.837	0.823	0.822	0.825	0.921
5월사용량	0.864	0.847	0.847	0.913	1.000	0.934	0.909	0.890	0.871	0.853	0.851	0.852	0.937
6월사용량	0.862	0.838	0.831	0.886	0.934	1.000	0.934	0.910	0.890	0.871	0.865	0.865	0.940
7월사용량	0.855	0.828	0.817	0.865	0.909	0.934	1.000	0.940	0.916	0.892	0.882	0.877	0.942
8월사용량	0.849	0.820	0.806	0.852	0.890	0.910	0.940	1.000	0.939	0.910	0.895	0.886	0.941
9월사용량	0.841	0.807	0.795	0.837	0.871	0.890	0.916	0.939	1.000	0.939	0.907	0.892	0.934
10월사용량	0.829	0.795	0.783	0.823	0.853	0.871	0.892	0.910	0.939	1.000	0.926	0.902	0.925
11월사용량	0.828	0.792	0.781	0.822	0.851	0.865	0.882	0.895	0.907	0.926	1.000	0.932	0.921
12월사용량	0.831	0.800	0.784	0.825	0.852	0.865	0.877	0.886	0.892	0.902	0.932	1.000	0.916
사용량합계	0.912	0.899	0.894	0.921	0.937	0.940	0.942	0.941	0.934	0.925	0.921	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월사용량	사용량합계
18210	경상남도 진주시 사봉면 동부로1769번길 9 (중촌마을)	15	10	12	9	15	14	17	15	17	21	19	9	173
16758	경상남도 진주시 미천면 상미로 55-3	11	11	11	9	8	11	14	17	21	18	15	12	158
38079	경상남도 진주시 촉석로 145, (9/5) (봉곡동) (옥외원격검침 2012)	40	38	39	33	44	43	43	47	48	66	40	59	540
31123	경상남도 진주시 동진로 169 (상대동) 도동치과	28	28	27	27	18	38	28	30	28	36	28	32	348
6560	경상남도 진주시 대곡면 오방로 108	1	3	5	1	1	11	5	6	8	8	6	5	60
26815	경상남도 진주시 선학산길 45-2, (4/3) (상대동)	27	22	23	18	24	23	30	23	22	25	20	18	275
22783	경상남도 진주시 명석면 나불로289번길 6-4	20	13	25	10	15	18	21	20	24	23	22	12	223
11048	경상남도 진주시 집현면 덕오리 471-10	0	0	18	6	10	11	5	8	6	7	17	14	102
7728	경상남도 진주시 금곡면 월아산로480번길 41-4	2	2	2	2	3	7	15	6	9	8	7	8	71
3907	경상남도 진주시 진주대로1134번길 15-5	2	4	2	2	1	3	8	0	2	5	3	3	35

	주소	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
45125	경상남도 진주시 촉석로 217-1	140	133	95	54	69	65	80	77	95	101	104	95	1108
8483	경상남도 진주시 진성면 동부로 1602번길 107	11	2	7	3	4	5	6	6	9	10	9	6	78
45865	경상남도 진주시 논개길 57, (7/3) 고천장여관 (장대동)	105	102	102	72	93	90	120	86	108	122	114	139	1253
43285	경상남도 진주시 돗골로 73, 김홍규 (상평동)	78	77	71	74	83	84	98	96	92	47	46	13	859
48879	경상남도 진주시 돗골로117번길 15 (상평동) (옥외원격검침 2014)	1481	1284	1507	1231	1368	1324	1617	1604	1649	1686	1683	1552	17986
16772	경상남도 진주시 천수로138번길 9-7	2	40	38	37	7	4	7	4	5	7	3	4	158
17917	경상남도 진주시 미천면 오방로409번길 39-3 (정성마을)	12	13	16	16	12	13	14	10	14	25	13	12	170
31603	경상남도 진주시 문산읍 월아산로1094번길 14-10	21	22	15	41	19	21	40	34	48	24	30	43	358
1283	경상남도 진주시 미천면 오방로711	1	2	2	0	1	0	0	0	1	0	0	2	9
8313	경상남도 진주시 의병로58번길 3-1, (18/3) (상봉동)	11	11	6	10	2	8	13	1	2	10	1	1	76

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Space Separator

Dash Punctuation

Lowercase Letter

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Interactions

Correlations

Missing values

Sample