Overview

Dataset statistics

Number of variables24
Number of observations39
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.1 KiB
Average record size in memory212.4 B

Variable types

Categorical8
Numeric13
Text3

Dataset

Description이 데이터는 용연정수사업소의 전력 사용량 에 대한 정보를 포함하고 있습니다. 용연정수사업소에서 사용하는 총괄적인 전력 사용량 관련 데이터입니다.
Author광주광역시 상수도사업본부
URLhttps://www.data.go.kr/data/15098484/fileData.do

Alerts

11월 has constant value ""Constant
12월 has constant value ""Constant
활동자료 is highly imbalanced (57.8%)Imbalance
단위 is highly imbalanced (54.6%)Imbalance
시설일련번호 has unique valuesUnique
세부장치(내부 관리명) has unique valuesUnique
시설용량 has 2 (5.1%) zerosZeros
1월 has 9 (23.1%) zerosZeros
2월 has 6 (15.4%) zerosZeros
3월 has 5 (12.8%) zerosZeros
4월 has 5 (12.8%) zerosZeros
5월 has 7 (17.9%) zerosZeros
6월 has 4 (10.3%) zerosZeros
7월 has 6 (15.4%) zerosZeros
8월 has 5 (12.8%) zerosZeros
9월 has 4 (10.3%) zerosZeros
10월 has 8 (20.5%) zerosZeros
사용량합계 has 3 (7.7%) zerosZeros

Reproduction

Analysis started2023-12-12 23:19:55.362987
Analysis finished2023-12-12 23:19:55.661020
Duration0.3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

신규 폐쇄여부
Categorical

Distinct7
Distinct (%)17.9%
Missing0
Missing (%)0.0%
Memory size444.0 B
2
21 
0.3
5 
신설(19)
5 
신설(21)
4 
0.5
 
2
Other values (2)
 
2

Length

Max length6
Median length1
Mean length2.6410256
Min length1

Unique

Unique2 ?
Unique (%)5.1%

Sample

1st row0.5
2nd row0.3
3rd row0.3
4th row0.5
5th row0

Common Values

ValueCountFrequency (%)
2 21
53.8%
0.3 5
 
12.8%
신설(19) 5
 
12.8%
신설(21) 4
 
10.3%
0.5 2
 
5.1%
0 1
 
2.6%
신설(20) 1
 
2.6%

Length

2023-12-13T08:19:55.737933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:55.845290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 21
53.8%
0.3 5
 
12.8%
신설(19 5
 
12.8%
신설(21 4
 
10.3%
0.5 2
 
5.1%
0 1
 
2.6%
신설(20 1
 
2.6%

시설일련번호
Real number (ℝ)

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean44.205128
Minimum1
Maximum92
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:55.961204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.8
Q117.5
median38
Q381.5
95-th percentile90.1
Maximum92
Range91
Interquartile range (IQR)64

Descriptive statistics

Standard deviation30.801725
Coefficient of variation (CV)0.69679077
Kurtosis-1.3188392
Mean44.205128
Median Absolute Deviation (MAD)25
Skewness0.35515316
Sum1724
Variance948.74629
MonotonicityStrictly increasing
2023-12-13T08:19:56.088119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
1 1
 
2.6%
2 1
 
2.6%
42 1
 
2.6%
43 1
 
2.6%
44 1
 
2.6%
45 1
 
2.6%
46 1
 
2.6%
80 1
 
2.6%
81 1
 
2.6%
82 1
 
2.6%
Other values (29) 29
74.4%
ValueCountFrequency (%)
1 1
2.6%
2 1
2.6%
4 1
2.6%
7 1
2.6%
8 1
2.6%
9 1
2.6%
12 1
2.6%
13 1
2.6%
16 1
2.6%
17 1
2.6%
ValueCountFrequency (%)
92 1
2.6%
91 1
2.6%
90 1
2.6%
89 1
2.6%
87 1
2.6%
86 1
2.6%
85 1
2.6%
84 1
2.6%
83 1
2.6%
82 1
2.6%

세부장치(내부 관리명)
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-13T08:19:56.309578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length7.3846154
Min length3

Characters and Unicode

Total characters288
Distinct characters86
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique39 ?
Unique (%)100.0%

Sample

1st row용연정수장(용연사무실)
2nd row관용차량
3rd row관용선박
4th row동복 수중폭기기(구)
5th row이륜자동차
ValueCountFrequency (%)
동복 3
 
7.0%
용연정수장(용연사무실 1
 
2.3%
오치동(전기방식 1
 
2.3%
물염로 1
 
2.3%
동명동(전기방식 1
 
2.3%
우산동(전기방식 1
 
2.3%
각화동(전기방식 1
 
2.3%
학동(전기방식 1
 
2.3%
계림동(전기방식 1
 
2.3%
동복수원지(취수탑 1
 
2.3%
Other values (31) 31
72.1%
2023-12-13T08:19:56.650200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 24
 
8.3%
) 21
 
7.3%
( 21
 
7.3%
수 20
 
6.9%
기 17
 
5.9%
전 11
 
3.8%
식 9
 
3.1%
지 9
 
3.1%
방 8
 
2.8%
용 7
 
2.4%
Other values (76) 141
49.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 235
81.6%
Close Punctuation 21
 
7.3%
Open Punctuation 21
 
7.3%
Space Separator 4
 
1.4%
Lowercase Letter 4
 
1.4%
Decimal Number 3
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 24
 
10.2%
수 20
 
8.5%
기 17
 
7.2%
전 11
 
4.7%
식 9
 
3.8%
지 9
 
3.8%
방 8
 
3.4%
용 7
 
3.0%
연 5
 
2.1%
계 5
 
2.1%
Other values (68) 120
51.1%
Lowercase Letter
ValueCountFrequency (%)
c 2
50.0%
v 1
25.0%
t 1
25.0%
Decimal Number
ValueCountFrequency (%)
4 2
66.7%
2 1
33.3%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 235
81.6%
Common 49
 
17.0%
Latin 4
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 24
 
10.2%
수 20
 
8.5%
기 17
 
7.2%
전 11
 
4.7%
식 9
 
3.8%
지 9
 
3.8%
방 8
 
3.4%
용 7
 
3.0%
연 5
 
2.1%
계 5
 
2.1%
Other values (68) 120
51.1%
Common
ValueCountFrequency (%)
) 21
42.9%
( 21
42.9%
4
 
8.2%
4 2
 
4.1%
2 1
 
2.0%
Latin
ValueCountFrequency (%)
c 2
50.0%
v 1
25.0%
t 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 235
81.6%
ASCII 53
 
18.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 24
 
10.2%
수 20
 
8.5%
기 17
 
7.2%
전 11
 
4.7%
식 9
 
3.8%
지 9
 
3.8%
방 8
 
3.4%
용 7
 
3.0%
연 5
 
2.1%
계 5
 
2.1%
Other values (68) 120
51.1%
ASCII
ValueCountFrequency (%)
) 21
39.6%
( 21
39.6%
4
 
7.5%
c 2
 
3.8%
4 2
 
3.8%
v 1
 
1.9%
t 1
 
1.9%
2 1
 
1.9%

시설용량
Real number (ℝ)

ZEROS 

Distinct18
Distinct (%)46.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55.102564
Minimum0
Maximum1038
Zeros2
Zeros (%)5.1%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:56.783132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.9
Q14
median5
Q38.5
95-th percentile265
Maximum1038
Range1038
Interquartile range (IQR)4.5

Descriptive statistics

Standard deviation178.63574
Coefficient of variation (CV)3.241877
Kurtosis25.476852
Mean55.102564
Median Absolute Deviation (MAD)2
Skewness4.8407879
Sum2149
Variance31910.726
MonotonicityNot monotonic
2023-12-13T08:19:56.903485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
4 10
25.6%
5 6
15.4%
3 3
 
7.7%
8 3
 
7.7%
7 3
 
7.7%
0 2
 
5.1%
1038 1
 
2.6%
10 1
 
2.6%
150 1
 
2.6%
60 1
 
2.6%
Other values (8) 8
20.5%
ValueCountFrequency (%)
0 2
 
5.1%
1 1
 
2.6%
3 3
 
7.7%
4 10
25.6%
5 6
15.4%
6 1
 
2.6%
7 3
 
7.7%
8 3
 
7.7%
9 1
 
2.6%
10 1
 
2.6%
ValueCountFrequency (%)
1038 1
2.6%
400 1
2.6%
250 1
2.6%
150 1
2.6%
60 1
2.6%
52 1
2.6%
34 1
2.6%
15 1
2.6%
10 1
2.6%
9 1
2.6%

시설용량단위
Categorical

Distinct5
Distinct (%)12.8%
Missing0
Missing (%)0.0%
Memory size444.0 B
kW
22 
KW
10 
대
4 
kw
 
2
0
 
1

Length

Max length2
Median length2
Mean length1.8717949
Min length1

Unique

Unique1 ?
Unique (%)2.6%

Sample

1st rowkW
2nd row대
3rd row대
4th rowkw
5th row대

Common Values

ValueCountFrequency (%)
kW 22
56.4%
KW 10
25.6%
대 4
 
10.3%
kw 2
 
5.1%
0 1
 
2.6%

Length

2023-12-13T08:19:57.049922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:57.156019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kw 34
87.2%
대 4
 
10.3%
0 1
 
2.6%

일일평균가동시간(시간)
Categorical

Distinct2
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size444.0 B
24
33 
0
6 

Length

Max length2
Median length2
Mean length1.8461538
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row24
2nd row0
3rd row0
4th row24
5th row0

Common Values

ValueCountFrequency (%)
24 33
84.6%
0 6
 
15.4%

Length

2023-12-13T08:19:57.263734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:57.375821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
24 33
84.6%
0 6
 
15.4%

연간가동일수(일)
Categorical

Distinct2
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size444.0 B
365
33 
0
6 

Length

Max length3
Median length3
Mean length2.6923077
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row365
2nd row0
3rd row0
4th row365
5th row0

Common Values

ValueCountFrequency (%)
365 33
84.6%
0 6
 
15.4%

Length

2023-12-13T08:19:57.504790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:57.628469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
365 33
84.6%
0 6
 
15.4%

활동자료
Categorical

IMBALANCE 

Distinct4
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Memory size444.0 B
전기
33 
경유
 
3
휘발유
 
2
프로판(LPG)
 
1

Length

Max length8
Median length2
Mean length2.2051282
Min length2

Unique

Unique1 ?
Unique (%)2.6%

Sample

1st row전기
2nd row경유
3rd row경유
4th row전기
5th row휘발유

Common Values

ValueCountFrequency (%)
전기 33
84.6%
경유 3
 
7.7%
휘발유 2
 
5.1%
프로판(LPG) 1
 
2.6%

Length

2023-12-13T08:19:57.730117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:57.825850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전기 33
84.6%
경유 3
 
7.7%
휘발유 2
 
5.1%
프로판(lpg 1
 
2.6%

단위
Categorical

IMBALANCE 

Distinct3
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size444.0 B
kWh
33 
리터
5 
kg
 
1

Length

Max length3
Median length3
Mean length2.8461538
Min length2

Unique

Unique1 ?
Unique (%)2.6%

Sample

1st rowkWh
2nd row리터
3rd row리터
4th rowkWh
5th row리터

Common Values

ValueCountFrequency (%)
kWh 33
84.6%
리터 5
 
12.8%
kg 1
 
2.6%

Length

2023-12-13T08:19:57.920994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:19:58.014306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kwh 33
84.6%
리터 5
 
12.8%
kg 1
 
2.6%

1월
Real number (ℝ)

ZEROS 

Distinct31
Distinct (%)79.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14052.513
Minimum0
Maximum358660
Zeros9
Zeros (%)23.1%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:58.102840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q117.5
median177
Q3790
95-th percentile67830.4
Maximum358660
Range358660
Interquartile range (IQR)772.5

Descriptive statistics

Standard deviation59998.466
Coefficient of variation (CV)4.2695899
Kurtosis30.496838
Mean14052.513
Median Absolute Deviation (MAD)177
Skewness5.3684631
Sum548048
Variance3.599816 × 109
MonotonicityNot monotonic
2023-12-13T08:19:58.232924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
0 9
23.1%
358660 1
 
2.6%
40 1
 
2.6%
57 1
 
2.6%
10 1
 
2.6%
1489 1
 
2.6%
530 1
 
2.6%
177 1
 
2.6%
63284 1
 
2.6%
471 1
 
2.6%
Other values (21) 21
53.8%
ValueCountFrequency (%)
0 9
23.1%
10 1
 
2.6%
25 1
 
2.6%
31 1
 
2.6%
40 1
 
2.6%
53 1
 
2.6%
57 1
 
2.6%
70 1
 
2.6%
82 1
 
2.6%
119 1
 
2.6%
ValueCountFrequency (%)
358660 1
2.6%
108748 1
2.6%
63284 1
2.6%
2858 1
2.6%
2364 1
2.6%
2031 1
2.6%
1489 1
2.6%
1373 1
2.6%
1125 1
2.6%
857 1
2.6%

2월
Real number (ℝ)

ZEROS 

Distinct34
Distinct (%)87.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11623.564
Minimum0
Maximum279897
Zeros6
Zeros (%)15.4%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:58.339701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q142.5
median298
Q3779.5
95-th percentile55434.7
Maximum279897
Range279897
Interquartile range (IQR)737

Descriptive statistics

Standard deviation47949.697
Coefficient of variation (CV)4.1252146
Kurtosis27.481719
Mean11623.564
Median Absolute Deviation (MAD)267
Skewness5.089343
Sum453319
Variance2.2991734 × 109
MonotonicityNot monotonic
2023-12-13T08:19:58.432537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
0 6
 
15.4%
279897 1
 
2.6%
49511 1
 
2.6%
441 1
 
2.6%
22 1
 
2.6%
4 1
 
2.6%
2379 1
 
2.6%
479 1
 
2.6%
440 1
 
2.6%
158 1
 
2.6%
Other values (24) 24
61.5%
ValueCountFrequency (%)
0 6
15.4%
4 1
 
2.6%
22 1
 
2.6%
31 1
 
2.6%
37 1
 
2.6%
48 1
 
2.6%
57 1
 
2.6%
60 1
 
2.6%
64 1
 
2.6%
99 1
 
2.6%
ValueCountFrequency (%)
279897 1
2.6%
108748 1
2.6%
49511 1
2.6%
2379 1
2.6%
1837 1
2.6%
1489 1
2.6%
1364 1
2.6%
1142 1
2.6%
880 1
2.6%
835 1
2.6%

3월
Real number (ℝ)

ZEROS 

Distinct35
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10203.205
Minimum0
Maximum231088
Zeros5
Zeros (%)12.8%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:58.529995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q174
median180
Q3833.5
95-th percentile49423.6
Maximum231088
Range231088
Interquartile range (IQR)759.5

Descriptive statistics

Standard deviation40723.596
Coefficient of variation (CV)3.9912553
Kurtosis24.496675
Mean10203.205
Median Absolute Deviation (MAD)180
Skewness4.8196313
Sum397925
Variance1.6584113 × 109
MonotonicityNot monotonic
2023-12-13T08:19:58.624278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
0 5
 
12.8%
231088 1
 
2.6%
42832 1
 
2.6%
69 1
 
2.6%
369 1
 
2.6%
24 1
 
2.6%
2368 1
 
2.6%
559 1
 
2.6%
346 1
 
2.6%
180 1
 
2.6%
Other values (25) 25
64.1%
ValueCountFrequency (%)
0 5
12.8%
24 1
 
2.6%
34 1
 
2.6%
39 1
 
2.6%
53 1
 
2.6%
69 1
 
2.6%
79 1
 
2.6%
81 1
 
2.6%
83 1
 
2.6%
84 1
 
2.6%
ValueCountFrequency (%)
231088 1
2.6%
108748 1
2.6%
42832 1
2.6%
2368 1
2.6%
1678 1
2.6%
1489 1
2.6%
1137 1
2.6%
1123 1
2.6%
1015 1
2.6%
898 1
2.6%

4월
Real number (ℝ)

ZEROS 

Distinct35
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15044.308
Minimum0
Maximum422414
Zeros5
Zeros (%)12.8%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:58.722201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q160.5
median200
Q3706
95-th percentile48231.1
Maximum422414
Range422414
Interquartile range (IQR)645.5

Descriptive statistics

Standard deviation69427.978
Coefficient of variation (CV)4.6149002
Kurtosis33.383206
Mean15044.308
Median Absolute Deviation (MAD)194
Skewness5.6635857
Sum586728
Variance4.8202441 × 109
MonotonicityNot monotonic
2023-12-13T08:19:58.818931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
0 5
 
12.8%
422414 1
 
2.6%
41507 1
 
2.6%
394 1
 
2.6%
24 1
 
2.6%
75 1
 
2.6%
1730 1
 
2.6%
617 1
 
2.6%
375 1
 
2.6%
187 1
 
2.6%
Other values (25) 25
64.1%
ValueCountFrequency (%)
0 5
12.8%
24 1
 
2.6%
33 1
 
2.6%
39 1
 
2.6%
52 1
 
2.6%
58 1
 
2.6%
63 1
 
2.6%
66 1
 
2.6%
75 1
 
2.6%
88 1
 
2.6%
ValueCountFrequency (%)
422414 1
2.6%
108748 1
2.6%
41507 1
2.6%
1730 1
2.6%
1489 1
2.6%
1457 1
2.6%
1279 1
2.6%
1093 1
2.6%
898 1
2.6%
765 1
2.6%

5월
Real number (ℝ)

ZEROS 

Distinct31
Distinct (%)79.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16369.513
Minimum0
Maximum473217
Zeros7
Zeros (%)17.9%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:58.907826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q145
median125
Q3751.5
95-th percentile49519
Maximum473217
Range473217
Interquartile range (IQR)706.5

Descriptive statistics

Standard deviation77318.186
Coefficient of variation (CV)4.7233041
Kurtosis34.379039
Mean16369.513
Median Absolute Deviation (MAD)125
Skewness5.7615717
Sum638411
Variance5.9781019 × 109
MonotonicityNot monotonic
2023-12-13T08:19:58.998577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
0 7
 
17.9%
48 2
 
5.1%
375 2
 
5.1%
473217 1
 
2.6%
42938 1
 
2.6%
416 1
 
2.6%
25 1
 
2.6%
1790 1
 
2.6%
526 1
 
2.6%
492 1
 
2.6%
Other values (21) 21
53.8%
ValueCountFrequency (%)
0 7
17.9%
25 1
 
2.6%
40 1
 
2.6%
42 1
 
2.6%
48 2
 
5.1%
51 1
 
2.6%
69 1
 
2.6%
70 1
 
2.6%
77 1
 
2.6%
80 1
 
2.6%
ValueCountFrequency (%)
473217 1
2.6%
108748 1
2.6%
42938 1
2.6%
1837 1
2.6%
1790 1
2.6%
1489 1
2.6%
1067 1
2.6%
1017 1
2.6%
898 1
2.6%
818 1
2.6%

6월
Real number (ℝ)

ZEROS 

Distinct35
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17119.487
Minimum0
Maximum503265
Zeros4
Zeros (%)10.3%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:59.086889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q161.5
median264
Q3691
95-th percentile47426.5
Maximum503265
Range503265
Interquartile range (IQR)629.5

Descriptive statistics

Standard deviation81972.242
Coefficient of variation (CV)4.7882417
Kurtosis34.925173
Mean17119.487
Median Absolute Deviation (MAD)219
Skewness5.8169091
Sum667660
Variance6.7194485 × 109
MonotonicityNot monotonic
2023-12-13T08:19:59.183501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
0 4
 
10.3%
140 2
 
5.1%
503265 1
 
2.6%
40613 1
 
2.6%
404 1
 
2.6%
24 1
 
2.6%
40 1
 
2.6%
2400 1
 
2.6%
516 1
 
2.6%
403 1
 
2.6%
Other values (25) 25
64.1%
ValueCountFrequency (%)
0 4
10.3%
24 1
 
2.6%
38 1
 
2.6%
40 1
 
2.6%
45 1
 
2.6%
52 1
 
2.6%
60 1
 
2.6%
63 1
 
2.6%
66 1
 
2.6%
67 1
 
2.6%
ValueCountFrequency (%)
503265 1
2.6%
108748 1
2.6%
40613 1
2.6%
2400 1
2.6%
2127 1
2.6%
1489 1
2.6%
1109 1
2.6%
976 1
2.6%
763 1
2.6%
738 1
2.6%

7월
Real number (ℝ)

ZEROS 

Distinct32
Distinct (%)82.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17529.179
Minimum0
Maximum527309
Zeros6
Zeros (%)15.4%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:59.279509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q143
median214
Q3780.5
95-th percentile49660.1
Maximum527309
Range527309
Interquartile range (IQR)737.5

Descriptive statistics

Standard deviation85455.436
Coefficient of variation (CV)4.8750392
Kurtosis35.803996
Mean17529.179
Median Absolute Deviation (MAD)214
Skewness5.9038101
Sum683638
Variance7.3026316 × 109
MonotonicityNot monotonic
2023-12-13T08:19:59.378296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
0 6
 
15.4%
39 3
 
7.7%
527309 1
 
2.6%
214 1
 
2.6%
24 1
 
2.6%
1779 1
 
2.6%
522 1
 
2.6%
320 1
 
2.6%
44381 1
 
2.6%
497 1
 
2.6%
Other values (22) 22
56.4%
ValueCountFrequency (%)
0 6
15.4%
24 1
 
2.6%
39 3
7.7%
47 1
 
2.6%
52 1
 
2.6%
63 1
 
2.6%
65 1
 
2.6%
66 1
 
2.6%
74 1
 
2.6%
88 1
 
2.6%
ValueCountFrequency (%)
527309 1
2.6%
97172 1
2.6%
44381 1
2.6%
2276 1
2.6%
1779 1
2.6%
1489 1
2.6%
1160 1
2.6%
1029 1
2.6%
877 1
2.6%
787 1
2.6%

8월
Real number (ℝ)

ZEROS 

Distinct34
Distinct (%)87.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17614.897
Minimum0
Maximum541120
Zeros5
Zeros (%)12.8%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:59.474818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q149.5
median196
Q3700.5
95-th percentile47125.5
Maximum541120
Range541120
Interquartile range (IQR)651

Descriptive statistics

Standard deviation87438.143
Coefficient of variation (CV)4.9638747
Kurtosis36.365639
Mean17614.897
Median Absolute Deviation (MAD)196
Skewness5.9614104
Sum686981
Variance7.6454289 × 109
MonotonicityNot monotonic
2023-12-13T08:19:59.577460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
0 5
 
12.8%
64 2
 
5.1%
541120 1
 
2.6%
42422 1
 
2.6%
25 1
 
2.6%
41 1
 
2.6%
1666 1
 
2.6%
518 1
 
2.6%
326 1
 
2.6%
196 1
 
2.6%
Other values (24) 24
61.5%
ValueCountFrequency (%)
0 5
12.8%
25 1
 
2.6%
34 1
 
2.6%
40 1
 
2.6%
41 1
 
2.6%
47 1
 
2.6%
52 1
 
2.6%
64 2
 
5.1%
65 1
 
2.6%
75 1
 
2.6%
ValueCountFrequency (%)
541120 1
2.6%
89457 1
2.6%
42422 1
2.6%
1919 1
2.6%
1666 1
2.6%
1489 1
2.6%
1272 1
2.6%
882 1
2.6%
881 1
2.6%
767 1
2.6%

9월
Real number (ℝ)

ZEROS 

Distinct36
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16916.641
Minimum0
Maximum515914
Zeros4
Zeros (%)10.3%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:19:59.681248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q155.5
median200
Q3712
95-th percentile49710.1
Maximum515914
Range515914
Interquartile range (IQR)656.5

Descriptive statistics

Standard deviation83351.108
Coefficient of variation (CV)4.9271666
Kurtosis36.351854
Mean16916.641
Median Absolute Deviation (MAD)200
Skewness5.9588075
Sum659749
Variance6.9474072 × 109
MonotonicityNot monotonic
2023-12-13T08:20:00.050144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
0 4
 
10.3%
515914 1
 
2.6%
46031 1
 
2.6%
54 1
 
2.6%
416 1
 
2.6%
24 1
 
2.6%
40 1
 
2.6%
1990 1
 
2.6%
560 1
 
2.6%
297 1
 
2.6%
Other values (26) 26
66.7%
ValueCountFrequency (%)
0 4
10.3%
24 1
 
2.6%
33 1
 
2.6%
38 1
 
2.6%
40 1
 
2.6%
45 1
 
2.6%
54 1
 
2.6%
57 1
 
2.6%
63 1
 
2.6%
67 1
 
2.6%
ValueCountFrequency (%)
515914 1
2.6%
82822 1
2.6%
46031 1
2.6%
1990 1
2.6%
1885 1
2.6%
1510 1
2.6%
1489 1
2.6%
1058 1
2.6%
772 1
2.6%
766 1
2.6%

10월
Real number (ℝ)

ZEROS 

Distinct32
Distinct (%)82.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17084.897
Minimum0
Maximum521247
Zeros8
Zeros (%)20.5%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:20:00.174741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q136
median183
Q3769
95-th percentile46169.3
Maximum521247
Range521247
Interquartile range (IQR)733

Descriptive statistics

Standard deviation84251.247
Coefficient of variation (CV)4.9313288
Kurtosis36.284363
Mean17084.897
Median Absolute Deviation (MAD)183
Skewness5.9529734
Sum666311
Variance7.0982725 × 109
MonotonicityNot monotonic
2023-12-13T08:20:00.355577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
0 8
 
20.5%
521247 1
 
2.6%
41566 1
 
2.6%
54 1
 
2.6%
435 1
 
2.6%
25 1
 
2.6%
55 1
 
2.6%
2119 1
 
2.6%
570 1
 
2.6%
183 1
 
2.6%
Other values (22) 22
56.4%
ValueCountFrequency (%)
0 8
20.5%
25 1
 
2.6%
32 1
 
2.6%
40 1
 
2.6%
45 1
 
2.6%
54 1
 
2.6%
55 1
 
2.6%
59 1
 
2.6%
78 1
 
2.6%
88 1
 
2.6%
ValueCountFrequency (%)
521247 1
2.6%
87599 1
2.6%
41566 1
2.6%
2119 1
2.6%
1612 1
2.6%
1603 1
2.6%
1489 1
2.6%
1354 1
2.6%
1057 1
2.6%
772 1
2.6%

11월
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
0
39 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 39
100.0%

Length

2023-12-13T08:20:00.457620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:20:00.543283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 39
100.0%

12월
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
0
39 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 39
100.0%

Length

2023-12-13T08:20:00.634275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:20:00.736878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 39
100.0%

사용량합계
Real number (ℝ)

ZEROS 

Distinct37
Distinct (%)94.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean153558.21
Minimum0
Maximum4374131
Zeros3
Zeros (%)7.7%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-13T08:20:00.834525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1522
median2880
Q37400
95-th percentile510530.3
Maximum4374131
Range4374131
Interquartile range (IQR)6878

Descriptive statistics

Standard deviation715270.65
Coefficient of variation (CV)4.6579774
Kurtosis34.176974
Mean153558.21
Median Absolute Deviation (MAD)2504
Skewness5.7392724
Sum5988770
Variance5.1161211 × 1011
MonotonicityNot monotonic
2023-12-13T08:20:00.985281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
0 3
 
7.7%
4374131 1
 
2.6%
455085 1
 
2.6%
640 1
 
2.6%
4162 1
 
2.6%
242 1
 
2.6%
342 1
 
2.6%
21079 1
 
2.6%
5396 1
 
2.6%
3353 1
 
2.6%
Other values (27) 27
69.2%
ValueCountFrequency (%)
0 3
7.7%
242 1
 
2.6%
307 1
 
2.6%
342 1
 
2.6%
376 1
 
2.6%
390 1
 
2.6%
420 1
 
2.6%
503 1
 
2.6%
541 1
 
2.6%
640 1
 
2.6%
ValueCountFrequency (%)
4374131 1
2.6%
1009538 1
2.6%
455085 1
2.6%
21079 1
2.6%
16507 1
2.6%
14890 1
2.6%
13075 1
2.6%
10272 1
2.6%
8323 1
2.6%
7648 1
2.6%

측정기기고유번호
Text

Distinct34
Distinct (%)87.2%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-13T08:20:01.272219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length12
Mean length10.948718
Min length1

Characters and Unicode

Total characters427
Distinct characters15
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)84.6%

Sample

1st row03-2213-5765
2nd row0
3rd row0
4th row03-2212-9424
5th row0
ValueCountFrequency (%)
0 6
 
14.6%
03-1873-8416 1
 
2.4%
03-4394-2728 1
 
2.4%
03-4394-2737 1
 
2.4%
03-4059-7857 1
 
2.4%
외 1
 
2.4%
12개소 1
 
2.4%
03-4103-3447 1
 
2.4%
03-4215-7123 1
 
2.4%
03-4134-0301 1
 
2.4%
Other values (26) 26
63.4%
2023-12-13T08:20:01.646263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 68
15.9%
- 66
15.5%
0 62
14.5%
1 39
9.1%
2 31
7.3%
8 29
6.8%
4 29
6.8%
5 23
 
5.4%
9 21
 
4.9%
20
 
4.7%
Other values (5) 39
9.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 338
79.2%
Dash Punctuation 66
 
15.5%
Space Separator 20
 
4.7%
Other Letter 3
 
0.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 68
20.1%
0 62
18.3%
1 39
11.5%
2 31
9.2%
8 29
8.6%
4 29
8.6%
5 23
 
6.8%
9 21
 
6.2%
7 18
 
5.3%
6 18
 
5.3%
Other Letter
ValueCountFrequency (%)
외 1
33.3%
개 1
33.3%
소 1
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 66
100.0%
Space Separator
ValueCountFrequency (%)
20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 424
99.3%
Hangul 3
 
0.7%

Most frequent character per script

Common
ValueCountFrequency (%)
3 68
16.0%
- 66
15.6%
0 62
14.6%
1 39
9.2%
2 31
7.3%
8 29
6.8%
4 29
6.8%
5 23
 
5.4%
9 21
 
5.0%
20
 
4.7%
Other values (2) 36
8.5%
Hangul
ValueCountFrequency (%)
외 1
33.3%
개 1
33.3%
소 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 424
99.3%
Hangul 3
 
0.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 68
16.0%
- 66
15.6%
0 62
14.6%
1 39
9.2%
2 31
7.3%
8 29
6.8%
4 29
6.8%
5 23
 
5.4%
9 21
 
5.0%
20
 
4.7%
Other values (2) 36
8.5%
Hangul
ValueCountFrequency (%)
외 1
33.3%
개 1
33.3%
소 1
33.3%

비고(한전 고객번호)
Text

Distinct34
Distinct (%)87.2%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-13T08:20:01.882709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length9.2307692
Min length1

Characters and Unicode

Total characters360
Distinct characters29
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)84.6%

Sample

1st row5142021626
2nd row0
3rd row0
4th row98202003277
5th row0
ValueCountFrequency (%)
0 6
 
15.0%
5460064809 1
 
2.5%
56190086487 1
 
2.5%
56190093831 1
 
2.5%
계기번호 1
 
2.5%
없음(비주거용 1
 
2.5%
6450113221 1
 
2.5%
2450355823 1
 
2.5%
29250141004 1
 
2.5%
ls141852146 1
 
2.5%
Other values (25) 25
62.5%
2023-12-13T08:20:02.276135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 62
17.2%
1 52
14.4%
5 36
10.0%
2 35
9.7%
4 32
8.9%
3 26
7.2%
6 23
 
6.4%
9 22
 
6.1%
8 22
 
6.1%
7 19
 
5.3%
Other values (19) 31
8.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 329
91.4%
Uppercase Letter 18
 
5.0%
Other Letter 10
 
2.8%
Open Punctuation 1
 
0.3%
Space Separator 1
 
0.3%
Close Punctuation 1
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 62
18.8%
1 52
15.8%
5 36
10.9%
2 35
10.6%
4 32
9.7%
3 26
7.9%
6 23
 
7.0%
9 22
 
6.7%
8 22
 
6.7%
7 19
 
5.8%
Other Letter
ValueCountFrequency (%)
없 1
10.0%
용 1
10.0%
거 1
10.0%
주 1
10.0%
비 1
10.0%
음 1
10.0%
호 1
10.0%
번 1
10.0%
기 1
10.0%
계 1
10.0%
Uppercase Letter
ValueCountFrequency (%)
S 6
33.3%
L 5
27.8%
H 3
16.7%
K 2
 
11.1%
T 1
 
5.6%
C 1
 
5.6%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 332
92.2%
Latin 18
 
5.0%
Hangul 10
 
2.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 62
18.7%
1 52
15.7%
5 36
10.8%
2 35
10.5%
4 32
9.6%
3 26
7.8%
6 23
 
6.9%
9 22
 
6.6%
8 22
 
6.6%
7 19
 
5.7%
Other values (3) 3
 
0.9%
Hangul
ValueCountFrequency (%)
없 1
10.0%
용 1
10.0%
거 1
10.0%
주 1
10.0%
비 1
10.0%
음 1
10.0%
호 1
10.0%
번 1
10.0%
기 1
10.0%
계 1
10.0%
Latin
ValueCountFrequency (%)
S 6
33.3%
L 5
27.8%
H 3
16.7%
K 2
 
11.1%
T 1
 
5.6%
C 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 350
97.2%
Hangul 10
 
2.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 62
17.7%
1 52
14.9%
5 36
10.3%
2 35
10.0%
4 32
9.1%
3 26
7.4%
6 23
 
6.6%
9 22
 
6.3%
8 22
 
6.3%
7 19
 
5.4%
Other values (9) 21
 
6.0%
Hangul
ValueCountFrequency (%)
없 1
10.0%
용 1
10.0%
거 1
10.0%
주 1
10.0%
비 1
10.0%
음 1
10.0%
호 1
10.0%
번 1
10.0%
기 1
10.0%
계 1
10.0%

Sample

신규 폐쇄여부시설일련번호세부장치(내부 관리명)시설용량시설용량단위일일평균가동시간(시간)연간가동일수(일)활동자료단위1월2월3월4월5월6월7월8월9월10월11월12월사용량합계측정기기고유번호비고(한전 고객번호)
00.51용연정수장(용연사무실)1038kW24365전기kWh35866027989723108842241447321750326552730954112051591452124700437413103-2213-57655142021626
10.32관용차량7대00경유리터6438801015109310171109102912726021612001027200
20.34관용선박1대00경유리터20002002000400116012020040000288000
30.57동복 수중폭기기(구)250kw24365전기kWh1087481087481087481087481087481087489717289457828228759900100953803-2212-942498202003277
408이륜자동차5대00휘발유리터000000000000000
50.39용연 비상발전기400kW00경유리터0003070000000030700
60.312용연식당0000프로판(LPG)kg00140001400014000042000
70.313예초기0대00휘발유리터000000000000000
82162수원지5kW24365전기kWh38534037734333631532833233336300345203-0092-8263KH171026232
92174수원지(취수탑)7kW24365전기kWh11912612611411114011812812511900122603-1920-382036450004753
신규 폐쇄여부시설일련번호세부장치(내부 관리명)시설용량시설용량단위일일평균가동시간(시간)연간가동일수(일)활동자료단위1월2월3월4월5월6월7월8월9월10월11월12월사용량합계측정기기고유번호비고(한전 고객번호)
29신설(19)82용연동(전기차충전)8KW24365전기kWh471440346375375403320326297000335303-3811-164329250141004
30신설(19)83물염로7KW24365전기kWh000000000000003-4201-967526190287418
31신설(19)84동복 수중폭기기(신)150kw24365전기kWh632844951142832415074293840613443814242246031415660045508503-4134-03015460064809
32신설(19)85소태동10KW24365전기kWh17715818018715717121419617918300180203-4215-71232450355823
33신설(19)86월남배수지8KW24365전기kWh53045451055349247049751049649900501103-4103-34476450113221
34신설(20)87동복 cctv3KW24365전기kWh1489148914891489148914891489148914891489001489003-4059-7857 외 12개소계기번호 없음(비주거용)
35신설(21)89일곡동(수질계측제어)4KW24365전기kWh106081908485888885880075903-4394-273756190093831
36신설(21)90동명동(수질계측제어)4KW24365전기kWh57998358484547475700054103-4394-272856190086487
37신설(21)91두암동(수질계측제어)4KW24365전기kWh0298125101807374757310100100003-4394-275567190078013
38신설(21)92소태동(수질계측제어)4KW24365전기kWh0113109886963656563780071303-4394-271956190093661