gimi9 Pandas Profiling

Dataset statistics

Number of variables	14
Number of observations	10000
Missing cells	776
Missing cells (%)	0.6%
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 131 (1.3%) missing values	Missing
`2월사용량` has 121 (1.2%) missing values	Missing
`3월사용량` has 111 (1.1%) missing values	Missing
`4월사용량` has 104 (1.0%) missing values	Missing
`1월사용량` is highly skewed (γ1 = 30.67947536)	Skewed
`2월사용량` is highly skewed (γ1 = 31.35234603)	Skewed
`3월사용량` is highly skewed (γ1 = 31.5039583)	Skewed
`4월사용량` is highly skewed (γ1 = 30.78119042)	Skewed
`5월사용량` is highly skewed (γ1 = 31.46372161)	Skewed
`6월사용량` is highly skewed (γ1 = 30.4267333)	Skewed
`7월사용량` is highly skewed (γ1 = 30.69818109)	Skewed
`8월사용량` is highly skewed (γ1 = 29.88342719)	Skewed
`9월사용량` is highly skewed (γ1 = 31.75921132)	Skewed
`10월사용량` is highly skewed (γ1 = 31.72874098)	Skewed
`11월사용량` is highly skewed (γ1 = 31.03399109)	Skewed
`12월사용량` is highly skewed (γ1 = 30.50071944)	Skewed
`사용량합계` is highly skewed (γ1 = 31.23421377)	Skewed
`1월사용량` has 560 (5.6%) zeros	Zeros
`2월사용량` has 642 (6.4%) zeros	Zeros
`3월사용량` has 672 (6.7%) zeros	Zeros
`4월사용량` has 662 (6.6%) zeros	Zeros
`5월사용량` has 619 (6.2%) zeros	Zeros
`6월사용량` has 572 (5.7%) zeros	Zeros
`7월사용량` has 539 (5.4%) zeros	Zeros
`8월사용량` has 533 (5.3%) zeros	Zeros
`9월사용량` has 494 (4.9%) zeros	Zeros
`10월사용량` has 539 (5.4%) zeros	Zeros
`11월사용량` has 515 (5.1%) zeros	Zeros
`12월사용량` has 554 (5.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:17:44.328522
Analysis finished	2023-12-11 00:18:02.872501
Duration	18.54 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

주소
Text

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

Length

Max length	50
Median length	43
Mean length	25.1958
Min length	14

Characters and Unicode

Total characters	251958
Distinct characters	533
Distinct categories	9 ?
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	9898 ?
Unique (%)	99.0%

Sample

1st row	경상남도 진주시 진성면 동부로1345번길 28-3
2nd row	경상남도 진주시 지수면 방어산로 56-10
3rd row	경상남도 진주시 금산면 갈전길63번길 6
4th row	경상남도 진주시 진양호로239번길 6-7
5th row	경상남도 진주시 일반성면 수목원로277번길 44-3

Value	Count	Frequency (%)
경상남도	10000	20.1%
진주시	10000	20.1%
상대동	548	1.1%
문산읍	401	0.8%
금산면	373	0.7%
상봉동	334	0.7%
대곡면	332	0.7%
신안동	317	0.6%
명석면	272	0.5%
집현면	267	0.5%
Other values (5667)	27026	54.2%

Most occurring characters

Value	Count	Frequency (%)
	41765	16.6%
진	11859	4.7%
1	11847	4.7%
상	11256	4.5%
주	10801	4.3%
남	10747	4.3%
경	10454	4.1%
도	10283	4.1%
시	10051	4.0%
길	8449	3.4%
Other values (523)	114446	45.4%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	141770	56.3%
Decimal Number	48591	19.3%
Space Separator	41765	16.6%
Open Punctuation	5577	2.2%
Close Punctuation	5414	2.1%
Dash Punctuation	5109	2.0%
Other Punctuation	3683	1.5%
Uppercase Letter	42	< 0.1%
Lowercase Letter	7	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
진	11859	8.4%
상	11256	7.9%
주	10801	7.6%
남	10747	7.6%
경	10454	7.4%
도	10283	7.3%
시	10051	7.1%
길	8449	6.0%
로	7708	5.4%
번	6452	4.6%
Other values (479)	43710	30.8%

Uppercase Letter

Value	Count	Frequency (%)
B	7	16.7%
A	5	11.9%
L	5	11.9%
P	3	7.1%
M	3	7.1%
S	3	7.1%
F	2	4.8%
G	2	4.8%
T	2	4.8%
H	2	4.8%
Other values (8)	8	19.0%

Decimal Number

Value	Count	Frequency (%)
1	11847	24.4%
2	6637	13.7%
3	5094	10.5%
4	4436	9.1%
5	4268	8.8%
6	3627	7.5%
7	3365	6.9%
9	3255	6.7%
0	3056	6.3%
8	3006	6.2%

Lowercase Letter

Value	Count	Frequency (%)
s	2	28.6%
x	1	14.3%
k	1	14.3%
i	1	14.3%
o	1	14.3%
n	1	14.3%

Other Punctuation

Value	Count	Frequency (%)
/	1840	50.0%
,	1793	48.7%
.	45	1.2%
:	5	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	5531	99.2%
[	46	0.8%

Close Punctuation

Value	Count	Frequency (%)
)	5368	99.2%
]	46	0.8%

Space Separator

Value	Count	Frequency (%)
	41765	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5109	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	141770	56.3%
Common	110139	43.7%
Latin	49	< 0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
진	11859	8.4%
상	11256	7.9%
주	10801	7.6%
남	10747	7.6%
경	10454	7.4%
도	10283	7.3%
시	10051	7.1%
길	8449	6.0%
로	7708	5.4%
번	6452	4.6%
Other values (479)	43710	30.8%

Latin

Value	Count	Frequency (%)
B	7	14.3%
A	5	10.2%
L	5	10.2%
P	3	6.1%
M	3	6.1%
S	3	6.1%
F	2	4.1%
s	2	4.1%
G	2	4.1%
T	2	4.1%
Other values (14)	15	30.6%

Common

Value	Count	Frequency (%)
	41765	37.9%
1	11847	10.8%
2	6637	6.0%
(	5531	5.0%
)	5368	4.9%
-	5109	4.6%
3	5094	4.6%
4	4436	4.0%
5	4268	3.9%
6	3627	3.3%
Other values (10)	16457	14.9%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	141770	56.3%
ASCII	110188	43.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	41765	37.9%
1	11847	10.8%
2	6637	6.0%
(	5531	5.0%
)	5368	4.9%
-	5109	4.6%
3	5094	4.6%
4	4436	4.0%
5	4268	3.9%
6	3627	3.3%
Other values (34)	16506	15.0%

Hangul

Value	Count	Frequency (%)
진	11859	8.4%
상	11256	7.9%
주	10801	7.6%
남	10747	7.6%
경	10454	7.4%
도	10283	7.3%
시	10051	7.1%
길	8449	6.0%
로	7708	5.4%
번	6452	4.6%
Other values (479)	43710	30.8%

1월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	365
Distinct (%)	3.7%
Missing	131
Missing (%)	1.3%
Infinite	0
Infinite (%)	0.0%
Mean	59.085318

Minimum	0
Maximum	24875
Zeros	560
Zeros (%)	5.6%
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	116
Maximum	24875
Range	24875
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	535.58637
Coefficient of variation (CV)	9.0646271
Kurtosis	1126.1235
Mean	59.085318
Median Absolute Deviation (MAD)	12
Skewness	30.679475
Sum	583113
Variance	286852.76
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	560	5.6%
5	318	3.2%
1	315	3.1%
2	313	3.1%
4	297	3.0%
10	294	2.9%
3	290	2.9%
6	277	2.8%
8	270	2.7%
9	245	2.5%
Other values (355)	6690	66.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	560	5.6%
1	315	3.1%
2	313	3.1%
3	290	2.9%
4	297	3.0%
5	318	3.2%
6	277	2.8%
7	243	2.4%
8	270	2.7%
9	245	2.5%

Value	Count	Frequency (%)
24875	1	< 0.1%
21329	1	< 0.1%
19704	1	< 0.1%
16441	1	< 0.1%
16389	1	< 0.1%
10780	1	< 0.1%
8720	1	< 0.1%
8289	1	< 0.1%
7852	1	< 0.1%
7686	1	< 0.1%

2월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	372
Distinct (%)	3.8%
Missing	121
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%
Mean	58.739549

Minimum	0
Maximum	26144
Zeros	642
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	17
Q3	36
95-th percentile	115.1
Maximum	26144
Range	26144
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	539.65104
Coefficient of variation (CV)	9.187184
Kurtosis	1179.3171
Mean	58.739549
Median Absolute Deviation (MAD)	13
Skewness	31.352346
Sum	580288
Variance	291223.25
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	642	6.4%
1	344	3.4%
4	327	3.3%
2	315	3.1%
5	298	3.0%
3	290	2.9%
10	286	2.9%
8	274	2.7%
7	259	2.6%
11	253	2.5%
Other values (362)	6591	65.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	642	6.4%
1	344	3.4%
2	315	3.1%
3	290	2.9%
4	327	3.3%
5	298	3.0%
6	252	2.5%
7	259	2.6%
8	274	2.7%
9	234	2.3%

Value	Count	Frequency (%)
26144	1	< 0.1%
20883	1	< 0.1%
19141	1	< 0.1%
17454	1	< 0.1%
16489	1	< 0.1%
11839	1	< 0.1%
7907	1	< 0.1%
7732	1	< 0.1%
7508	1	< 0.1%
7210	1	< 0.1%

3월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	357
Distinct (%)	3.6%
Missing	111
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	56.059864

Minimum	0
Maximum	25047
Zeros	672
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	16
Q3	34
95-th percentile	110
Maximum	25047
Range	25047
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	522.40074
Coefficient of variation (CV)	9.318623
Kurtosis	1185.1693
Mean	56.059864
Median Absolute Deviation (MAD)	12
Skewness	31.503958
Sum	554376
Variance	272902.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	672	6.7%
2	367	3.7%
1	350	3.5%
3	333	3.3%
4	330	3.3%
10	309	3.1%
7	297	3.0%
5	293	2.9%
6	276	2.8%
8	272	2.7%
Other values (347)	6390	63.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	672	6.7%
1	350	3.5%
2	367	3.7%
3	333	3.3%
4	330	3.3%
5	293	2.9%
6	276	2.8%
7	297	3.0%
8	272	2.7%
9	215	2.1%

Value	Count	Frequency (%)
25047	1	< 0.1%
19933	1	< 0.1%
19160	1	< 0.1%
18317	1	< 0.1%
15086	1	< 0.1%
10660	1	< 0.1%
7851	1	< 0.1%
7512	1	< 0.1%
7280	1	< 0.1%
7187	1	< 0.1%

4월사용량
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	341
Distinct (%)	3.4%
Missing	104
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.966148

Minimum	0
Maximum	22481
Zeros	662
Zeros (%)	6.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7
median	16
Q3	33
95-th percentile	101
Maximum	22481
Range	22481
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	485.29794
Coefficient of variation (CV)	9.1624171
Kurtosis	1127.0229
Mean	52.966148
Median Absolute Deviation (MAD)	11
Skewness	30.78119
Sum	524153
Variance	235514.09
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	662	6.6%
10	344	3.4%
1	319	3.2%
2	311	3.1%
4	308	3.1%
5	302	3.0%
8	281	2.8%
7	273	2.7%
6	273	2.7%
12	271	2.7%
Other values (331)	6552	65.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	662	6.6%
1	319	3.2%
2	311	3.1%
3	260	2.6%
4	308	3.1%
5	302	3.0%
6	273	2.7%
7	273	2.7%
8	281	2.8%
9	259	2.6%

Value	Count	Frequency (%)
22481	1	< 0.1%
19043	1	< 0.1%
17001	1	< 0.1%
16018	1	< 0.1%
15919	1	< 0.1%
10248	1	< 0.1%
7362	1	< 0.1%
6788	1	< 0.1%
6706	1	< 0.1%
6636	1	< 0.1%

5월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	365
Distinct (%)	3.7%
Missing	92
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	58.643117

Minimum	0
Maximum	26066
Zeros	619
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	16
Q3	36
95-th percentile	116
Maximum	26066
Range	26066
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	546.49348
Coefficient of variation (CV)	9.3189707
Kurtosis	1200.9885
Mean	58.643117
Median Absolute Deviation (MAD)	12
Skewness	31.463722
Sum	581036
Variance	298655.13
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	619	6.2%
1	354	3.5%
2	347	3.5%
7	327	3.3%
10	318	3.2%
5	314	3.1%
3	313	3.1%
4	290	2.9%
12	267	2.7%
6	249	2.5%
Other values (355)	6510	65.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	619	6.2%
1	354	3.5%
2	347	3.5%
3	313	3.1%
4	290	2.9%
5	314	3.1%
6	249	2.5%
7	327	3.3%
8	248	2.5%
9	246	2.5%

Value	Count	Frequency (%)
26066	1	< 0.1%
24020	1	< 0.1%
17345	1	< 0.1%
17265	1	< 0.1%
15245	1	< 0.1%
11451	1	< 0.1%
9214	1	< 0.1%
8220	1	< 0.1%
8067	1	< 0.1%
7506	1	< 0.1%

6월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	365
Distinct (%)	3.7%
Missing	76
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	59.185611

Minimum	0
Maximum	25306
Zeros	572
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	117
Maximum	25306
Range	25306
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	532.78229
Coefficient of variation (CV)	9.0018889
Kurtosis	1116.2473
Mean	59.185611
Median Absolute Deviation (MAD)	12
Skewness	30.426733
Sum	587358
Variance	283856.97
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	572	5.7%
4	310	3.1%
1	301	3.0%
10	301	3.0%
2	298	3.0%
5	296	3.0%
3	292	2.9%
7	283	2.8%
6	276	2.8%
15	248	2.5%
Other values (355)	6747	67.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	572	5.7%
1	301	3.0%
2	298	3.0%
3	292	2.9%
4	310	3.1%
5	296	3.0%
6	276	2.8%
7	283	2.8%
8	244	2.4%
9	236	2.4%

Value	Count	Frequency (%)
25306	1	< 0.1%
20255	1	< 0.1%
18867	1	< 0.1%
17667	1	< 0.1%
15472	1	< 0.1%
11757	1	< 0.1%
8080	1	< 0.1%
8065	1	< 0.1%
7836	1	< 0.1%
7182	1	< 0.1%

7월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	371
Distinct (%)	3.7%
Missing	51
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	64.181827

Minimum	0
Maximum	27909
Zeros	539
Zeros (%)	5.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	574.40596
Coefficient of variation (CV)	8.9496667
Kurtosis	1153.77
Mean	64.181827
Median Absolute Deviation (MAD)	14
Skewness	30.698181
Sum	638545
Variance	329942.21
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	539	5.4%
5	287	2.9%
10	286	2.9%
1	264	2.6%
6	262	2.6%
2	262	2.6%
7	256	2.6%
8	255	2.5%
4	251	2.5%
3	250	2.5%
Other values (361)	7037	70.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	539	5.4%
1	264	2.6%
2	262	2.6%
3	250	2.5%
4	251	2.5%
5	287	2.9%
6	262	2.6%
7	256	2.6%
8	255	2.5%
9	221	2.2%

Value	Count	Frequency (%)
27909	1	< 0.1%
23504	1	< 0.1%
18826	1	< 0.1%
17186	1	< 0.1%
17018	1	< 0.1%
11775	1	< 0.1%
9951	1	< 0.1%
8907	1	< 0.1%
8198	1	< 0.1%
7471	1	< 0.1%

8월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	379
Distinct (%)	3.8%
Missing	39
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	65.048389

Minimum	0
Maximum	28367
Zeros	533
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	584.49271
Coefficient of variation (CV)	8.9855064
Kurtosis	1098.8286
Mean	65.048389
Median Absolute Deviation (MAD)	14
Skewness	29.883427
Sum	647947
Variance	341631.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	533	5.3%
5	300	3.0%
10	289	2.9%
2	282	2.8%
1	279	2.8%
6	267	2.7%
4	261	2.6%
11	247	2.5%
8	246	2.5%
7	243	2.4%
Other values (369)	7014	70.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	533	5.3%
1	279	2.8%
2	282	2.8%
3	239	2.4%
4	261	2.6%
5	300	3.0%
6	267	2.7%
7	243	2.4%
8	246	2.5%
9	233	2.3%

Value	Count	Frequency (%)
28367	1	< 0.1%
21973	1	< 0.1%
19481	1	< 0.1%
18589	1	< 0.1%
17277	1	< 0.1%
12099	1	< 0.1%
9242	1	< 0.1%
8190	1	< 0.1%
8106	1	< 0.1%
7592	1	< 0.1%

9월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	385
Distinct (%)	3.9%
Missing	27
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	67.962298

Minimum	0
Maximum	30708
Zeros	494
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	43
95-th percentile	131
Maximum	30708
Range	30708
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	628.2329
Coefficient of variation (CV)	9.2438443
Kurtosis	1222.6209
Mean	67.962298
Median Absolute Deviation (MAD)	15
Skewness	31.759211
Sum	677788
Variance	394676.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	494	4.9%
10	265	2.6%
5	252	2.5%
8	244	2.4%
3	243	2.4%
6	242	2.4%
4	238	2.4%
2	237	2.4%
1	231	2.3%
9	230	2.3%
Other values (375)	7297	73.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	494	4.9%
1	231	2.3%
2	237	2.4%
3	243	2.4%
4	238	2.4%
5	252	2.5%
6	242	2.4%
7	220	2.2%
8	244	2.4%
9	230	2.3%

Value	Count	Frequency (%)
30708	1	< 0.1%
26644	1	< 0.1%
20935	1	< 0.1%
20026	1	< 0.1%
17911	1	< 0.1%
13001	1	< 0.1%
9924	1	< 0.1%
8831	1	< 0.1%
8764	1	< 0.1%
7854	1	< 0.1%

10월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	382
Distinct (%)	3.8%
Missing	14
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	66.673843

Minimum	0
Maximum	29563
Zeros	539
Zeros (%)	5.4%
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	131
Maximum	29563
Range	29563
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	609.5759
Coefficient of variation (CV)	9.1426543
Kurtosis	1231.0569
Mean	66.673843
Median Absolute Deviation (MAD)	14
Skewness	31.728741
Sum	665805
Variance	371582.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	539	5.4%
10	293	2.9%
2	277	2.8%
1	277	2.8%
7	262	2.6%
5	257	2.6%
6	247	2.5%
4	246	2.5%
8	239	2.4%
3	227	2.3%
Other values (372)	7122	71.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	539	5.4%
1	277	2.8%
2	277	2.8%
3	227	2.3%
4	246	2.5%
5	257	2.6%
6	247	2.5%
7	262	2.6%
8	239	2.4%
9	219	2.2%

Value	Count	Frequency (%)
29563	1	< 0.1%
27033	1	< 0.1%
18901	1	< 0.1%
18740	1	< 0.1%
18090	1	< 0.1%
12254	1	< 0.1%
9072	1	< 0.1%
8893	1	< 0.1%
8399	1	< 0.1%
8256	1	< 0.1%

11월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	364
Distinct (%)	3.6%
Missing	10
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	62.488388

Minimum	0
Maximum	27911
Zeros	515
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	40
95-th percentile	122
Maximum	27911
Range	27911
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	541.93662
Coefficient of variation (CV)	8.6725972
Kurtosis	1200.6637
Mean	62.488388
Median Absolute Deviation (MAD)	14
Skewness	31.033991
Sum	624259
Variance	293695.31
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	515	5.1%
10	277	2.8%
1	270	2.7%
5	267	2.7%
3	256	2.6%
6	249	2.5%
12	248	2.5%
7	247	2.5%
2	243	2.4%
15	242	2.4%
Other values (354)	7176	71.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	515	5.1%
1	270	2.7%
2	243	2.4%
3	256	2.6%
4	236	2.4%
5	267	2.7%
6	249	2.5%
7	247	2.5%
8	242	2.4%
9	223	2.2%

Value	Count	Frequency (%)
27911	1	< 0.1%
18865	1	< 0.1%
18188	1	< 0.1%
17355	1	< 0.1%
16234	1	< 0.1%
11661	1	< 0.1%
8425	1	< 0.1%
7868	1	< 0.1%
7563	1	< 0.1%
7139	1	< 0.1%

12월사용량
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	377
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.0282

Minimum	0
Maximum	26794
Zeros	554
Zeros (%)	5.5%
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	123
Maximum	26794
Range	26794
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	563.07314
Coefficient of variation (CV)	9.0776959
Kurtosis	1127.3261
Mean	62.0282
Median Absolute Deviation (MAD)	13
Skewness	30.500719
Sum	620282
Variance	317051.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	554	5.5%
1	318	3.2%
2	310	3.1%
8	284	2.8%
4	284	2.8%
3	282	2.8%
6	275	2.8%
10	274	2.7%
5	271	2.7%
7	262	2.6%
Other values (367)	6886	68.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	554	5.5%
1	318	3.2%
2	310	3.1%
3	282	2.8%
4	284	2.8%
5	271	2.7%
6	275	2.8%
7	262	2.6%
8	284	2.8%
9	256	2.6%

Value	Count	Frequency (%)
26794	1	< 0.1%
22523	1	< 0.1%
19197	1	< 0.1%
18329	1	< 0.1%
16573	1	< 0.1%
11604	1	< 0.1%
8646	1	< 0.1%
8219	1	< 0.1%
7816	1	< 0.1%
7631	1	< 0.1%

사용량합계
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1632
Distinct (%)	16.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	728.495

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

Quantile statistics

Minimum	1
5-th percentile	15
Q1	99
median	224
Q3	457
95-th percentile	1381.15
Maximum	321171
Range	321170
Interquartile range (IQR)	358

Descriptive statistics

Standard deviation	6606.9424
Coefficient of variation (CV)	9.0693037
Kurtosis	1180.4981
Mean	728.495
Median Absolute Deviation (MAD)	150
Skewness	31.234214
Sum	7284950
Variance	43651688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	81	0.8%
2	53	0.5%
3	37	0.4%
50	37	0.4%
113	35	0.4%
4	35	0.4%
76	35	0.4%
5	33	0.3%
190	33	0.3%
78	33	0.3%
Other values (1622)	9588	95.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	81	0.8%
2	53	0.5%
3	37	0.4%
4	35	0.4%
5	33	0.3%
6	26	0.3%
7	30	0.3%
8	29	0.3%
9	24	0.2%
10	29	0.3%

Value	Count	Frequency (%)
321171	1	< 0.1%
266005	1	< 0.1%
219866	1	< 0.1%
219185	1	< 0.1%
198785	1	< 0.1%
139129	1	< 0.1%
102039	1	< 0.1%
95689	1	< 0.1%
94619	1	< 0.1%
89087	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
1월사용량	1.000	0.950	0.959	0.969	0.947	0.995	0.966	0.964	0.990	0.946	0.943	0.993	0.972
2월사용량	0.950	1.000	0.988	0.990	0.983	0.962	0.987	0.985	0.937	0.922	0.986	0.959	0.988
3월사용량	0.959	0.988	1.000	0.992	0.990	0.952	0.986	0.986	0.955	0.936	0.994	0.946	0.990
4월사용량	0.969	0.990	0.992	1.000	0.988	0.971	0.994	0.995	0.963	0.968	0.989	0.965	0.998
5월사용량	0.947	0.983	0.990	0.988	1.000	0.966	0.990	0.985	0.962	0.960	0.990	0.942	0.987
6월사용량	0.995	0.962	0.952	0.971	0.966	1.000	0.984	0.970	0.993	0.973	0.959	0.999	0.974
7월사용량	0.966	0.987	0.986	0.994	0.990	0.984	1.000	0.999	0.972	0.969	0.995	0.974	0.998
8월사용량	0.964	0.985	0.986	0.995	0.985	0.970	0.999	1.000	0.986	0.969	0.997	0.975	0.999
9월사용량	0.990	0.937	0.955	0.963	0.962	0.993	0.972	0.986	1.000	0.955	0.983	0.995	0.981
10월사용량	0.946	0.922	0.936	0.968	0.960	0.973	0.969	0.969	0.955	1.000	0.958	0.959	0.962
11월사용량	0.943	0.986	0.994	0.989	0.990	0.959	0.995	0.997	0.983	0.958	1.000	0.964	0.996
12월사용량	0.993	0.959	0.946	0.965	0.942	0.999	0.974	0.975	0.995	0.959	0.964	1.000	0.981
사용량합계	0.972	0.988	0.990	0.998	0.987	0.974	0.998	0.999	0.981	0.962	0.996	0.981	1.000

Heatmap
Table

	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
1월사용량	1.000	0.907	0.894	0.888	0.883	0.875	0.864	0.852	0.841	0.836	0.830	0.830	0.915
2월사용량	0.907	1.000	0.921	0.897	0.884	0.869	0.856	0.842	0.829	0.822	0.817	0.819	0.917
3월사용량	0.894	0.921	1.000	0.921	0.904	0.886	0.870	0.853	0.842	0.834	0.827	0.828	0.925
4월사용량	0.888	0.897	0.921	1.000	0.936	0.913	0.890	0.874	0.860	0.851	0.848	0.843	0.933
5월사용량	0.883	0.884	0.904	0.936	1.000	0.943	0.919	0.898	0.881	0.872	0.864	0.866	0.944
6월사용량	0.875	0.869	0.886	0.913	0.943	1.000	0.939	0.913	0.897	0.884	0.875	0.875	0.948
7월사용량	0.864	0.856	0.870	0.890	0.919	0.939	1.000	0.938	0.917	0.901	0.886	0.883	0.949
8월사용량	0.852	0.842	0.853	0.874	0.898	0.913	0.938	1.000	0.937	0.916	0.900	0.893	0.945
9월사용량	0.841	0.829	0.842	0.860	0.881	0.897	0.917	0.937	1.000	0.940	0.916	0.906	0.940
10월사용량	0.836	0.822	0.834	0.851	0.872	0.884	0.901	0.916	0.940	1.000	0.938	0.923	0.937
11월사용량	0.830	0.817	0.827	0.848	0.864	0.875	0.886	0.900	0.916	0.938	1.000	0.940	0.930
12월사용량	0.830	0.819	0.828	0.843	0.866	0.875	0.883	0.893	0.906	0.923	0.940	1.000	0.924
사용량합계	0.915	0.917	0.925	0.933	0.944	0.948	0.949	0.945	0.940	0.937	0.930	0.924	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월사용량	사용량합계
33107	경상남도 진주시 진성면 동부로1345번길 28-3	16	21	21	19	20	25	22	20	25	22	32	92	335
14988	경상남도 진주시 지수면 방어산로 56-10	10	9	10	10	6	9	14	6	14	12	9	10	119
15662	경상남도 진주시 금산면 갈전길63번길 6	15	7	7	7	9	8	16	14	12	9	12	9	125
25722	경상남도 진주시 진양호로239번길 6-7	15	14	13	29	9	23	23	24	21	18	18	18	225
14302	경상남도 진주시 일반성면 수목원로277번길 44-3	8	8	7	8	8	8	10	11	15	11	10	9	113
1294	경상남도 진주시 진양호로555번길 10-1, 진주땅콩 (장대동)	0	1	1	0	1	0	1	0	1	0	1	0	6
44757	경상남도 진주시 대신로231번길 19-1 (상대동)	40	35	61	52	57	78	89	94	84	75	78	61	804
34344	경상남도 진주시 진주대로931번길 14-1	40	23	23	24	28	27	35	32	38	33	31	26	360
41328	경상남도 진주시 평거로 154, (20/3) 두피클리닉 (신안동)	46	45	31	32	46	48	51	62	56	55	60	47	579
9970	경상남도 진주시 봉래길27번길 6-7	7	6	8	6	7	8	9	8	10	1	2	3	75

	주소	1월사용량	2월사용량	3월사용량	4월사용량	5월사용량	6월사용량	7월사용량	8월사용량	9월사용량	10월사용량	11월사용량	12월사용량	사용량합계
3632	경상남도 진주시 이반성면 길성길 139-4	2	1	1	1	2	2	3	2	3	3	3	2	25
41457	경상남도 진주시 모덕로 53, (2/1)거성스포츠 (상대동)	63	63	61	61	65	73	33	36	35	35	40	21	586
14380	경상남도 진주시 향교로131번길 10-4	6	9	4	20	6	7	8	10	14	10	12	7	113
16867	경상남도 진주시 명석면 남성리 584	8	4	6	5	5	5	10	12	8	17	40	16	136
41655	경상남도 진주시 봉수대길5번길 7	45	41	40	37	42	49	76	56	59	53	51	47	596
57	경상남도 진주시 진성면 일사로499번길 22-4	1	0	0	0	0	0	0	0	0	0	0	0	1
10331	경상남도 진주시 진주대로1164번길 20 (상봉동) 102호	5	4	5	3	5	5	5	5	15	14	6	6	78
15749	경상남도 진주시 사봉면 지사로 144-17	16	5	6	11	10	10	11	8	9	10	18	12	126
44419	경상남도 진주시 강남로177번길 23 (칠암동)	10	8	5	47	68	114	91	100	58	72	86	112	771
48140	경상남도 진주시 동진로107번길 3, (13/1) (상대동)	107	120	84	116	120	108	150	104	97	102	106	105	1319

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Lowercase Letter

Other Punctuation

Open Punctuation

Close Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Interactions

Correlations

Missing values

Sample