Overview

Dataset statistics

Number of variables5
Number of observations35
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory46.8 B

Variable types

DateTime1
Categorical1
Numeric3

Dataset

Description영업통계 정보(계약종별 판매량, 판매수입, 고객호수 (16.11~17.3))
Author한국전력공사
URLhttps://www.data.go.kr/data/15069184/fileData.do

Alerts

고객호수 is highly overall correlated with 계약종별(대)High correlation
판매량 is highly overall correlated with 판매수입 and 1 other fieldsHigh correlation
판매수입 is highly overall correlated with 판매량 and 1 other fieldsHigh correlation
계약종별(대) is highly overall correlated with 고객호수 and 2 other fieldsHigh correlation
고객호수 has unique valuesUnique
판매량 has unique valuesUnique
판매수입 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:54:59.345143
Analysis finished2023-12-12 15:55:00.790632
Duration1.45 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

조회기간
Date

Distinct5
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size412.0 B
Minimum2016-11-01 00:00:00
Maximum2017-03-01 00:00:00
2023-12-13T00:55:00.855253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:00.990027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

계약종별(대)
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
주택용
5 
일반용
5 
교육용
5 
산업용
5 
농사용
5 
Other values (2)
10 

Length

Max length4
Median length3
Mean length3.1428571
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
주택용 5
14.3%
일반용 5
14.3%
교육용 5
14.3%
산업용 5
14.3%
농사용 5
14.3%
가로등 5
14.3%
심 야 5
14.3%

Length

2023-12-13T00:55:01.121866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:55:01.259922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주택용 5
12.5%
일반용 5
12.5%
교육용 5
12.5%
산업용 5
12.5%
농사용 5
12.5%
가로등 5
12.5%
심 5
12.5%
야 5
12.5%

고객호수
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3248015.9
Minimum20649
Maximum14828872
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-13T00:55:01.406948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20649
5-th percentile20714.8
Q1407470
median1710781
Q33078056
95-th percentile14780550
Maximum14828872
Range14808223
Interquartile range (IQR)2670586

Descriptive statistics

Standard deviation4868493.5
Coefficient of variation (CV)1.4989131
Kurtosis2.2813757
Mean3248015.9
Median Absolute Deviation (MAD)1304321
Skewness1.9619013
Sum1.1368056 × 108
Variance2.3702229 × 1013
MonotonicityNot monotonic
2023-12-13T00:55:01.557545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
14701858 1
 
2.9%
3076978 1
 
2.9%
845391 1
 
2.9%
14799363 1
 
2.9%
3081614 1
 
2.9%
20900 1
 
2.9%
407186 1
 
2.9%
1629555 1
 
2.9%
1771479 1
 
2.9%
843719 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
20649 1
2.9%
20663 1
2.9%
20737 1
2.9%
20900 1
2.9%
20958 1
2.9%
405060 1
2.9%
405771 1
2.9%
406460 1
2.9%
407186 1
2.9%
407754 1
2.9%
ValueCountFrequency (%)
14828872 1
2.9%
14799363 1
2.9%
14772488 1
2.9%
14728391 1
2.9%
14701858 1
2.9%
3088632 1
2.9%
3083090 1
2.9%
3081614 1
2.9%
3079134 1
2.9%
3076978 1
2.9%

판매량
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.1705174 × 109
Minimum2.9687931 × 108
Maximum2.4321168 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-13T00:55:01.690558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.9687931 × 108
5-th percentile3.191962 × 108
Q18.2427028 × 108
median1.7570783 × 109
Q38.543488 × 109
95-th percentile2.4100797 × 1010
Maximum2.4321168 × 1010
Range2.4024289 × 1010
Interquartile range (IQR)7.7192177 × 109

Descriptive statistics

Standard deviation7.8934322 × 109
Coefficient of variation (CV)1.2792172
Kurtosis1.1535402
Mean6.1705174 × 109
Median Absolute Deviation (MAD)1.4371707 × 109
Skewness1.5556757
Sum2.1596811 × 1011
Variance6.2306272 × 1019
MonotonicityNot monotonic
2023-12-13T00:55:01.820946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
5397987241 1
 
2.9%
8129763677 1
 
2.9%
1992653350 1
 
2.9%
6082350042 1
 
2.9%
10432553231 1
 
2.9%
806754891 1
 
2.9%
22832169433 1
 
2.9%
1757078282 1
 
2.9%
319907547 1
 
2.9%
2191586707 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
296879313 1
2.9%
317536375 1
2.9%
319907547 1
2.9%
332846043 1
2.9%
338587206 1
2.9%
647745378 1
2.9%
764921520 1
2.9%
806754891 1
2.9%
811030684 1
2.9%
837509886 1
2.9%
ValueCountFrequency (%)
24321168113 1
2.9%
24140679400 1
2.9%
24083703944 1
2.9%
23138590546 1
2.9%
22832169433 1
2.9%
10432553231 1
2.9%
10273698170 1
2.9%
9294444754 1
2.9%
8957212264 1
2.9%
8129763677 1
2.9%

판매수입
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.9324907 × 1011
Minimum3.3274145 × 1010
Maximum2.8488475 × 1012
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-13T00:55:01.976001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.3274145 × 1010
5-th percentile3.4706003 × 1010
Q17.3278843 × 1010
median1.2483022 × 1011
Q31.0898216 × 1012
95-th percentile2.7131987 × 1012
Maximum2.8488475 × 1012
Range2.8155734 × 1012
Interquartile range (IQR)1.0165427 × 1012

Descriptive statistics

Standard deviation9.1827641 × 1011
Coefficient of variation (CV)1.3245981
Kurtosis0.74693233
Mean6.9324907 × 1011
Median Absolute Deviation (MAD)8.9894885 × 1010
Skewness1.4150654
Sum2.4263718 × 1013
Variance8.4323157 × 1023
MonotonicityNot monotonic
2023-12-13T00:55:02.120421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
643641367340 1
 
2.9%
1075633040527 1
 
2.9%
149796886561 1
 
2.9%
691457232719 1
 
2.9%
1385662433142 1
 
2.9%
80580964872 1
 
2.9%
2690726807137 1
 
2.9%
83388142810 1
 
2.9%
35508364765 1
 
2.9%
164877087173 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
33274145263 1
2.9%
34170887941 1
2.9%
34935338093 1
2.9%
35508364765 1
2.9%
35808755435 1
2.9%
66183159591 1
2.9%
69632299619 1
2.9%
71370972802 1
2.9%
72432699841 1
2.9%
74124986470 1
2.9%
ValueCountFrequency (%)
2848847541840 1
2.9%
2765633206413 1
2.9%
2690726807137 1
2.9%
2678498274373 1
2.9%
2299640462439 1
2.9%
1385662433142 1
2.9%
1369130566395 1
2.9%
1282644690026 1
2.9%
1104010061239 1
2.9%
1075633040527 1
2.9%

Interactions

2023-12-13T00:55:00.210867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:59.528714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:59.828327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:00.348847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:59.638163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:59.928134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:00.456312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:59.735611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:00.080064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:55:02.242994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조회기간계약종별(대)고객호수판매량판매수입
조회기간1.0000.0000.0000.0000.000
계약종별(대)0.0001.0001.0000.8940.939
고객호수0.0001.0001.0000.8510.875
판매량0.0000.8940.8511.0000.936
판매수입0.0000.9390.8750.9361.000
2023-12-13T00:55:02.379338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고객호수판매량판매수입계약종별(대)
고객호수1.0000.1730.0560.950
판매량0.1731.0000.9640.806
판매수입0.0560.9641.0000.627
계약종별(대)0.9500.8060.6271.000

Missing values

2023-12-13T00:55:00.596709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:55:00.740324image/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

조회기간계약종별(대)고객호수판매량판매수입
02016-11주택용147018585397987241643641367340
12016-11일반용307697881297636771075633040527
22016-11교육용2064964774537874517144964
32016-11산업용405060231385905462678498274373
42016-11농사용2155274159753080769632299619
52016-11가로등173580631753637534170887941
62016-11심 야848014102731238966183159591
72016-12주택용147283915602358968655574755605
82016-12일반용308863292944447541282644690026
92016-12교육용2066383750988690417447898
조회기간계약종별(대)고객호수판매량판매수입
252017-02농사용1629555175707828283388142810
262017-02가로등177147931990754735508364765
272017-02심 야8437192191586707164877087173
282017-03주택용148288725269452345531282677124
292017-03일반용307913489572122641104010061239
302017-03교육용2095876492152074124986470
312017-03산업용407754240837039442299640462439
322017-03농사용2155756150668856572432699841
332017-03가로등177492329687931333274145263
342017-03심 야8422171679676906111599735342