Overview

Dataset statistics

Number of variables6
Number of observations1443
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory69.2 KiB
Average record size in memory49.1 B

Variable types

DateTime1
Categorical2
Numeric1
Text2

Dataset

Description한국전력공사에서 시도 및 계약종별로 관리된 영업통계에 관한 정보입니다. (광역시도별 판매량, 판매수입, 고객호수 )
URLhttps://www.data.go.kr/data/15053175/fileData.do

Reproduction

Analysis started2023-12-12 10:25:23.901477
Analysis finished2023-12-12 10:25:24.465053
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

조회기간
Date

Distinct12
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size11.4 KiB
Minimum2022-01-01 00:00:00
Maximum2022-12-01 00:00:00
2023-12-12T19:25:24.507323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:25:24.617103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

시도
Categorical

Distinct19
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size11.4 KiB
서울특별시
 
84
부산광역시
 
84
대구광역시
 
84
인천광역시
 
84
광주광역시
 
84
Other values (14)
1023 

Length

Max length8
Median length7
Mean length4.6541927
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시
2nd row서울특별시
3rd row서울특별시
4th row서울특별시
5th row서울특별시

Common Values

ValueCountFrequency (%)
서울특별시 84
 
5.8%
부산광역시 84
 
5.8%
대구광역시 84
 
5.8%
인천광역시 84
 
5.8%
광주광역시 84
 
5.8%
대전광역시 84
 
5.8%
울산광역시 84
 
5.8%
경기도 84
 
5.8%
강원도 84
 
5.8%
충청북도 84
 
5.8%
Other values (9) 603
41.8%

Length

2023-12-12T19:25:24.737084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울특별시 84
 
5.8%
부산광역시 84
 
5.8%
세종특별자치시 84
 
5.8%
제주특별자치도 84
 
5.8%
경상남도 84
 
5.8%
경상북도 84
 
5.8%
전라남도 84
 
5.8%
전라북도 84
 
5.8%
충청남도 84
 
5.8%
충청북도 84
 
5.8%
Other values (9) 603
41.8%

계약종별
Categorical

Distinct7
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size11.4 KiB
일반용
212 
주택용
208 
산업용
207 
교육용
204 
농사용
204 
Other values (2)
408 

Length

Max length4
Median length3
Mean length3.1413721
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주택용
2nd row일반용
3rd row교육용
4th row산업용
5th row농사용

Common Values

ValueCountFrequency (%)
일반용 212
14.7%
주택용 208
14.4%
산업용 207
14.3%
교육용 204
14.1%
농사용 204
14.1%
가로등 204
14.1%
심 야 204
14.1%

Length

2023-12-12T19:25:24.850858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:25:24.969288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반용 212
12.9%
주택용 208
12.6%
산업용 207
12.6%
교육용 204
12.4%
농사용 204
12.4%
가로등 204
12.4%
심 204
12.4%
야 204
12.4%

고객호수
Real number (ℝ)

Distinct1338
Distinct (%)92.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean205714.55
Minimum1
Maximum3075675
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size12.8 KiB
2023-12-12T19:25:25.115333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile630
Q111159
median55440
Q3197430.5
95-th percentile782625
Maximum3075675
Range3075674
Interquartile range (IQR)186271.5

Descriptive statistics

Standard deviation435498.2
Coefficient of variation (CV)2.1170024
Kurtosis25.245455
Mean205714.55
Median Absolute Deviation (MAD)54213
Skewness4.6160253
Sum2.9684609 × 108
Variance1.8965868 × 1011
MonotonicityNot monotonic
2023-12-12T19:25:25.291550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 9
 
0.6%
629 7
 
0.5%
422 6
 
0.4%
614 5
 
0.3%
1227 5
 
0.3%
156 5
 
0.3%
630 5
 
0.3%
1326 4
 
0.3%
157 3
 
0.2%
1327 3
 
0.2%
Other values (1328) 1391
96.4%
ValueCountFrequency (%)
1 9
0.6%
4 3
 
0.2%
9 3
 
0.2%
152 2
 
0.1%
153 1
 
0.1%
155 1
 
0.1%
156 5
0.3%
157 3
 
0.2%
344 1
 
0.1%
345 2
 
0.1%
ValueCountFrequency (%)
3075675 1
0.1%
3074778 1
0.1%
3072588 1
0.1%
3070767 1
0.1%
3068273 1
0.1%
3066707 1
0.1%
3064756 1
0.1%
3062101 1
0.1%
3059716 1
0.1%
3057823 1
0.1%

판매량
Text

Distinct1434
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size11.4 KiB
2023-12-12T19:25:25.603987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length9.3804574
Min length2

Characters and Unicode

Total characters13536
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1433 ?
Unique (%)99.3%

Sample

1st row1303987955
2nd row2500834252
3rd row206767204
4th row454360497
5th row2385867
ValueCountFrequency (%)
0 10
 
0.7%
193077877 1
 
0.1%
145727963 1
 
0.1%
2294058224 1
 
0.1%
1352108397 1
 
0.1%
1372990 1
 
0.1%
2702302 1
 
0.1%
9726814 1
 
0.1%
173407283 1
 
0.1%
6330472 1
 
0.1%
Other values (1424) 1424
98.7%
2023-12-12T19:25:26.112133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1474
10.9%
1442
10.7%
2 1414
10.4%
3 1280
9.5%
6 1173
8.7%
5 1153
8.5%
7 1142
8.4%
9 1123
8.3%
4 1114
8.2%
0 1112
8.2%
Other values (3) 1109
8.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 12092
89.3%
Space Separator 1442
 
10.7%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1474
12.2%
2 1414
11.7%
3 1280
10.6%
6 1173
9.7%
5 1153
9.5%
7 1142
9.4%
9 1123
9.3%
4 1114
9.2%
0 1112
9.2%
8 1107
9.2%
Space Separator
ValueCountFrequency (%)
1442
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 13536
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1474
10.9%
1442
10.7%
2 1414
10.4%
3 1280
9.5%
6 1173
8.7%
5 1153
8.5%
7 1142
8.4%
9 1123
8.3%
4 1114
8.2%
0 1112
8.2%
Other values (3) 1109
8.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 13536
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1474
10.9%
1442
10.7%
2 1414
10.4%
3 1280
9.5%
6 1173
8.7%
5 1153
8.5%
7 1142
8.4%
9 1123
8.3%
4 1114
8.2%
0 1112
8.2%
Other values (3) 1109
8.2%

판매수입
Text

Distinct1434
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size11.4 KiB
2023-12-12T19:25:26.457037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.334026
Min length2

Characters and Unicode

Total characters16355
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1433 ?
Unique (%)99.3%

Sample

1st row156687439742
2nd row328390432066
3rd row19441307587
4th row55040047084
5th row114458313
ValueCountFrequency (%)
0 10
 
0.7%
11876514269 1
 
0.1%
16318099761 1
 
0.1%
309889836224 1
 
0.1%
168630558610 1
 
0.1%
100992994 1
 
0.1%
354648984 1
 
0.1%
582962148 1
 
0.1%
22729026200 1
 
0.1%
838897755 1
 
0.1%
Other values (1424) 1424
98.7%
2023-12-12T19:25:26.932508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1733
10.6%
2 1675
10.2%
4 1543
9.4%
3 1526
9.3%
5 1450
8.9%
1442
8.8%
9 1423
8.7%
7 1414
8.6%
6 1397
8.5%
8 1379
8.4%
Other values (3) 1373
8.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 14911
91.2%
Space Separator 1442
 
8.8%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1733
11.6%
2 1675
11.2%
4 1543
10.3%
3 1526
10.2%
5 1450
9.7%
9 1423
9.5%
7 1414
9.5%
6 1397
9.4%
8 1379
9.2%
0 1371
9.2%
Space Separator
ValueCountFrequency (%)
1442
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 16355
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1733
10.6%
2 1675
10.2%
4 1543
9.4%
3 1526
9.3%
5 1450
8.9%
1442
8.8%
9 1423
8.7%
7 1414
8.6%
6 1397
8.5%
8 1379
8.4%
Other values (3) 1373
8.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 16355
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1733
10.6%
2 1675
10.2%
4 1543
9.4%
3 1526
9.3%
5 1450
8.9%
1442
8.8%
9 1423
8.7%
7 1414
8.6%
6 1397
8.5%
8 1379
8.4%
Other values (3) 1373
8.4%

Interactions

2023-12-12T19:25:24.178145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:25:27.059746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조회기간시도계약종별고객호수
조회기간1.0000.0000.0000.000
시도0.0001.0000.0000.535
계약종별0.0000.0001.0000.587
고객호수0.0000.5350.5871.000
2023-12-12T19:25:27.166161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시도계약종별
시도1.0000.000
계약종별0.0001.000
2023-12-12T19:25:27.274432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고객호수시도계약종별
고객호수1.0000.2990.428
시도0.2991.0000.000
계약종별0.4280.0001.000

Missing values

2023-12-12T19:25:24.322493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:25:24.423753image/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

조회기간시도계약종별고객호수판매량판매수입
02022-01서울특별시주택용28847081303987955156687439742
12022-01서울특별시일반용5534912500834252328390432066
22022-01서울특별시교육용260220676720419441307587
32022-01서울특별시산업용4306545436049755040047084
42022-01서울특별시농사용19522385867114458313
52022-01서울특별시가로등218527268454082850643445
62022-01서울특별시심 야12260228362841929658531
72022-01부산광역시주택용95241045066009152059024370
82022-01부산광역시일반용19361762440711184004785020
92022-01부산광역시교육용1147449993974882512581
조회기간시도계약종별고객호수판매량판매수입
14332022-12제주특별자치도농사용506121227530658284994375
14342022-12제주특별자치도가로등567554568138541479337
14352022-12제주특별자치도심 야62179368247893439669
14362022-12세종특별자치시주택용55519507036656535017272
14372022-12세종특별자치시일반용161967564763412181580583
14382022-12세종특별자치시교육용15791155951081253177
14392022-12세종특별자치시산업용173117601702625067227514
14402022-12세종특별자치시농사용106036996828487571459
14412022-12세종특별자치시가로등147053764228457902405
14422022-12세종특별자치시심 야66969199808868871969