Overview

Dataset statistics

Number of variables6
Number of observations120
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.9 KiB
Average record size in memory50.1 B

Variable types

Categorical5
Numeric1

Dataset

Description한국전력공사에서 2020년도에 인천광역시 동구에 공급한 전력 사용량이며, 용도별(가정용, 국군용, 기타 공공용, 수도 등)로 분류 하였습니다.
Author한국전력공사
URLhttps://www.data.go.kr/data/15102033/fileData.do

Alerts

시도 has constant value ""Constant
시군구 has constant value ""Constant
부문 is highly overall correlated with 용도업종(대)High correlation
용도업종(대) is highly overall correlated with 판매량(kw) and 1 other fieldsHigh correlation
판매량(kw) is highly overall correlated with 용도업종(대)High correlation
판매량(kw) has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:36:35.988649
Analysis finished2023-12-12 20:36:36.577096
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

조회기간
Categorical

Distinct11
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2020-01-01
20 
2020-02-01
10 
2020-03-01
10 
2020-04-01
10 
2020-05-01
10 
Other values (6)
60 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-01-01
2nd row2020-01-01
3rd row2020-01-01
4th row2020-01-01
5th row2020-01-01

Common Values

ValueCountFrequency (%)
2020-01-01 20
16.7%
2020-02-01 10
8.3%
2020-03-01 10
8.3%
2020-04-01 10
8.3%
2020-05-01 10
8.3%
2020-06-01 10
8.3%
2020-07-01 10
8.3%
2020-08-01 10
8.3%
2020-09-01 10
8.3%
2020-11-01 10
8.3%

Length

2023-12-13T05:36:36.672165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2020-01-01 20
16.7%
2020-02-01 10
8.3%
2020-03-01 10
8.3%
2020-04-01 10
8.3%
2020-05-01 10
8.3%
2020-06-01 10
8.3%
2020-07-01 10
8.3%
2020-08-01 10
8.3%
2020-09-01 10
8.3%
2020-11-01 10
8.3%

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
인천광역시
120 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천광역시
2nd row인천광역시
3rd row인천광역시
4th row인천광역시
5th row인천광역시

Common Values

ValueCountFrequency (%)
인천광역시 120
100.0%

Length

2023-12-13T05:36:36.847774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:36:36.951963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천광역시 120
100.0%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
동구
120 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동구
2nd row동구
3rd row동구
4th row동구
5th row동구

Common Values

ValueCountFrequency (%)
동구 120
100.0%

Length

2023-12-13T05:36:37.054821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:36:37.169205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동구 120
100.0%

부문
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
공공용
36 
서비스
36 
생산
36 
가정용
12 

Length

Max length3
Median length3
Mean length2.7
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가정용
2nd row공공용
3rd row공공용
4th row공공용
5th row서비스

Common Values

ValueCountFrequency (%)
공공용 36
30.0%
서비스 36
30.0%
생산 36
30.0%
가정용 12
 
10.0%

Length

2023-12-13T05:36:37.311954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:36:37.440044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공공용 36
30.0%
서비스 36
30.0%
생산 36
30.0%
가정용 12
 
10.0%

용도업종(대)
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
가정용
12 
국군용
12 
기타공공용
12 
관공용
12 
수도
12 
Other values (5)
60 

Length

Max length5
Median length4
Mean length3.4
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가정용
2nd row국군용
3rd row기타공공용
4th row관공용
5th row수도

Common Values

ValueCountFrequency (%)
가정용 12
10.0%
국군용 12
10.0%
기타공공용 12
10.0%
관공용 12
10.0%
수도 12
10.0%
사업자용 12
10.0%
순수써비스 12
10.0%
농수산업 12
10.0%
광업 12
10.0%
제조업 12
10.0%

Length

2023-12-13T05:36:37.593579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:36:37.752128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가정용 12
10.0%
국군용 12
10.0%
기타공공용 12
10.0%
관공용 12
10.0%
수도 12
10.0%
사업자용 12
10.0%
순수써비스 12
10.0%
농수산업 12
10.0%
광업 12
10.0%
제조업 12
10.0%

판매량(kw)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct120
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29443624
Minimum811
Maximum3.0512129 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-13T05:36:37.947371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum811
5-th percentile1397.55
Q123324.25
median306079
Q36928207.2
95-th percentile2.6556746 × 108
Maximum3.0512129 × 108
Range3.0512048 × 108
Interquartile range (IQR)6904883

Descriptive statistics

Standard deviation81555641
Coefficient of variation (CV)2.7698915
Kurtosis5.5731452
Mean29443624
Median Absolute Deviation (MAD)299066
Skewness2.7170865
Sum3.5332348 × 109
Variance6.6513226 × 1015
MonotonicityNot monotonic
2023-12-13T05:36:38.117603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
7501281 1
 
0.8%
1138 1
 
0.8%
298139643 1
 
0.8%
72900 1
 
0.8%
11126 1
 
0.8%
13818097 1
 
0.8%
28047 1
 
0.8%
121505 1
 
0.8%
417972 1
 
0.8%
497502 1
 
0.8%
Other values (110) 110
91.7%
ValueCountFrequency (%)
811 1
0.8%
1010 1
0.8%
1070 1
0.8%
1135 1
0.8%
1138 1
0.8%
1370 1
0.8%
1399 1
0.8%
1415 1
0.8%
1609 1
0.8%
2089 1
0.8%
ValueCountFrequency (%)
305121292 1
0.8%
298139643 1
0.8%
288578113 1
0.8%
287465250 1
0.8%
287432503 1
0.8%
269675263 1
0.8%
265351255 1
0.8%
259854677 1
0.8%
256726331 1
0.8%
256622576 1
0.8%

Interactions

2023-12-13T05:36:36.204863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:36:38.581182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조회기간부문용도업종(대)판매량(kw)
조회기간1.0000.0000.0000.000
부문0.0001.0001.0000.566
용도업종(대)0.0001.0001.0000.723
판매량(kw)0.0000.5660.7231.000
2023-12-13T05:36:38.691764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부문용도업종(대)조회기간
부문1.0000.9740.000
용도업종(대)0.9741.0000.000
조회기간0.0000.0001.000
2023-12-13T05:36:38.791485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
판매량(kw)조회기간부문용도업종(대)
판매량(kw)1.0000.0000.2510.514
조회기간0.0001.0000.0000.000
부문0.2510.0001.0000.974
용도업종(대)0.5140.0000.9741.000

Missing values

2023-12-13T05:36:36.356580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:36:36.522440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

조회기간시도시군구부문용도업종(대)판매량(kw)
02020-01-01인천광역시동구가정용가정용7501281
12020-01-01인천광역시동구공공용국군용2089
22020-01-01인천광역시동구공공용기타공공용975291
32020-01-01인천광역시동구공공용관공용687461
42020-01-01인천광역시동구서비스수도115229
52020-01-01인천광역시동구서비스사업자용23417
62020-01-01인천광역시동구서비스순수써비스14813762
72020-01-01인천광역시동구생산농수산업7799
82020-01-01인천광역시동구생산광업65751
92020-01-01인천광역시동구생산제조업241117658
조회기간시도시군구부문용도업종(대)판매량(kw)
1102020-12-01인천광역시동구가정용가정용7395486
1112020-12-01인천광역시동구공공용국군용2259
1122020-12-01인천광역시동구공공용기타공공용1085087
1132020-12-01인천광역시동구공공용관공용596002
1142020-12-01인천광역시동구서비스수도117185
1152020-12-01인천광역시동구서비스사업자용23046
1162020-12-01인천광역시동구서비스순수써비스15243008
1172020-12-01인천광역시동구생산농수산업10035
1182020-12-01인천광역시동구생산광업2204317
1192020-12-01인천광역시동구생산제조업256726331