Overview

Dataset statistics

Number of variables13
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.4 KiB
Average record size in memory114.4 B

Variable types

Categorical7
DateTime3
Numeric3

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/3b04296f-b07b-4f92-a639-f733e64ec7d8

Alerts

충전소ID has constant value ""Constant
전력량요금명 has constant value ""Constant
기본요금 has constant value ""Constant
비고 has constant value ""Constant
생산일시 has constant value ""Constant
전력사용요금 is highly overall correlated with 전력사용요금경부하High correlation
전력사용요금경부하 is highly overall correlated with 전력사용요금 and 1 other fieldsHigh correlation
전력사용요금중부하 is highly overall correlated with 전력사용요금경부하High correlation
전력사용요금최대부하 is highly imbalanced (73.5%)Imbalance
시작일시 has unique valuesUnique
종료일시 has unique valuesUnique
전력사용요금 has unique valuesUnique
전력사용요금경부하 has 13 (43.3%) zerosZeros
전력사용요금중부하 has 19 (63.3%) zerosZeros

Reproduction

Analysis started2024-03-13 11:56:26.654824
Analysis finished2024-03-13 11:56:28.482776
Duration1.83 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

충전소ID
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
KRPPKCS0001
30 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KRPPKCS0001 30
100.0%

Length

2024-03-13T20:56:28.575091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:56:28.709866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
krppkcs0001 30
100.0%

충전기ID
Categorical

Distinct8
Distinct (%)26.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
KRPPKCP0004
7 
KRPPKCP0005
6 
KRPPKCP0007
5 
KRPPKCP0003
4 
KRPPKCP0002
4 
Other values (3)
4 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique2 ?
Unique (%)6.7%

Sample

1st rowKRPPKCP0008
2nd rowKRPPKCP0007
3rd rowKRPPKCP0001
4th rowKRPPKCP0003
5th rowKRPPKCP0007

Common Values

ValueCountFrequency (%)
KRPPKCP0004 7
23.3%
KRPPKCP0005 6
20.0%
KRPPKCP0007 5
16.7%
KRPPKCP0003 4
13.3%
KRPPKCP0002 4
13.3%
KRPPKCP0008 2
 
6.7%
KRPPKCP0001 1
 
3.3%
KRPPKCP0006 1
 
3.3%

Length

2024-03-13T20:56:28.824632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:56:28.937488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
krppkcp0004 7
23.3%
krppkcp0005 6
20.0%
krppkcp0007 5
16.7%
krppkcp0003 4
13.3%
krppkcp0002 4
13.3%
krppkcp0008 2
 
6.7%
krppkcp0001 1
 
3.3%
krppkcp0006 1
 
3.3%

충전건
Categorical

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
1
15 
2
15 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row2
3rd row2
4th row1
5th row2

Common Values

ValueCountFrequency (%)
1 15
50.0%
2 15
50.0%

Length

2024-03-13T20:56:29.112173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:56:29.231299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 15
50.0%
2 15
50.0%

시작일시
Date

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-10-03 02:13:37
Maximum2023-10-31 16:47:57
2024-03-13T20:56:29.339820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:29.453723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)

종료일시
Date

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-10-03 02:39:24
Maximum2023-10-31 17:02:18
2024-03-13T20:56:29.588297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:29.731234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)

전력량요금명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
선택2고압
30 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row선택2고압
2nd row선택2고압
3rd row선택2고압
4th row선택2고압
5th row선택2고압

Common Values

ValueCountFrequency (%)
선택2고압 30
100.0%

Length

2024-03-13T20:56:29.870769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:56:29.964196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
선택2고압 30
100.0%

기본요금
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2580
30 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2580 30
100.0%

Length

2024-03-13T20:56:30.080060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:56:30.181176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2580 30
100.0%

전력사용요금
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3591.7667
Minimum273
Maximum13815
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:56:30.270302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum273
5-th percentile443.3
Q11151.25
median2048
Q35420.75
95-th percentile11792.4
Maximum13815
Range13542
Interquartile range (IQR)4269.5

Descriptive statistics

Standard deviation3721.6144
Coefficient of variation (CV)1.0361515
Kurtosis1.4406801
Mean3591.7667
Median Absolute Deviation (MAD)1062.5
Skewness1.5423466
Sum107753
Variance13850413
MonotonicityNot monotonic
2024-03-13T20:56:30.417157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
2854 1
 
3.3%
3038 1
 
3.3%
273 1
 
3.3%
2127 1
 
3.3%
2008 1
 
3.3%
2520 1
 
3.3%
329 1
 
3.3%
1757 1
 
3.3%
7041 1
 
3.3%
6447 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
273 1
3.3%
329 1
3.3%
583 1
3.3%
779 1
3.3%
824 1
3.3%
873 1
3.3%
913 1
3.3%
1060 1
3.3%
1425 1
3.3%
1565 1
3.3%
ValueCountFrequency (%)
13815 1
3.3%
11895 1
3.3%
11667 1
3.3%
8606 1
3.3%
7041 1
3.3%
6760 1
3.3%
6447 1
3.3%
6215 1
3.3%
3038 1
3.3%
2854 1
3.3%

전력사용요금경부하
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct18
Distinct (%)60.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2782.8
Minimum0
Maximum13815
Zeros13
Zeros (%)43.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:56:30.531045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1004
Q32770.5
95-th percentile11792.4
Maximum13815
Range13815
Interquartile range (IQR)2770.5

Descriptive statistics

Standard deviation4070.98
Coefficient of variation (CV)1.4629079
Kurtosis1.3970498
Mean2782.8
Median Absolute Deviation (MAD)1004
Skewness1.569482
Sum83484
Variance16572878
MonotonicityNot monotonic
2024-03-13T20:56:30.633151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
0 13
43.3%
2854 1
 
3.3%
1565 1
 
3.3%
273 1
 
3.3%
2127 1
 
3.3%
2520 1
 
3.3%
7041 1
 
3.3%
11895 1
 
3.3%
13815 1
 
3.3%
1425 1
 
3.3%
Other values (8) 8
26.7%
ValueCountFrequency (%)
0 13
43.3%
273 1
 
3.3%
583 1
 
3.3%
1425 1
 
3.3%
1565 1
 
3.3%
1901 1
 
3.3%
2088 1
 
3.3%
2127 1
 
3.3%
2149 1
 
3.3%
2520 1
 
3.3%
ValueCountFrequency (%)
13815 1
3.3%
11895 1
3.3%
11667 1
3.3%
8606 1
3.3%
7041 1
3.3%
6760 1
3.3%
6215 1
3.3%
2854 1
3.3%
2520 1
3.3%
2149 1
3.3%

전력사용요금중부하
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct12
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean535.5
Minimum0
Maximum3038
Zeros19
Zeros (%)63.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:56:30.735181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q3860.75
95-th percentile2421.6
Maximum3038
Range3038
Interquartile range (IQR)860.75

Descriptive statistics

Standard deviation880.81501
Coefficient of variation (CV)1.644846
Kurtosis1.9307103
Mean535.5
Median Absolute Deviation (MAD)0
Skewness1.6708181
Sum16065
Variance775835.09
MonotonicityNot monotonic
2024-03-13T20:56:30.888998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
0 19
63.3%
873 1
 
3.3%
824 1
 
3.3%
1060 1
 
3.3%
913 1
 
3.3%
2760 1
 
3.3%
779 1
 
3.3%
3038 1
 
3.3%
1581 1
 
3.3%
1900 1
 
3.3%
Other values (2) 2
 
6.7%
ValueCountFrequency (%)
0 19
63.3%
329 1
 
3.3%
779 1
 
3.3%
824 1
 
3.3%
873 1
 
3.3%
913 1
 
3.3%
1060 1
 
3.3%
1581 1
 
3.3%
1900 1
 
3.3%
2008 1
 
3.3%
ValueCountFrequency (%)
3038 1
3.3%
2760 1
3.3%
2008 1
3.3%
1900 1
3.3%
1581 1
3.3%
1060 1
3.3%
913 1
3.3%
873 1
3.3%
824 1
3.3%
779 1
3.3%

전력사용요금최대부하
Categorical

IMBALANCE 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
28 
6447
 
1
1757
 
1

Length

Max length4
Median length1
Mean length1.2
Min length1

Unique

Unique2 ?
Unique (%)6.7%

Sample

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

Common Values

ValueCountFrequency (%)
0 28
93.3%
6447 1
 
3.3%
1757 1
 
3.3%

Length

2024-03-13T20:56:31.041005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:56:31.138422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 28
93.3%
6447 1
 
3.3%
1757 1
 
3.3%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-01-10 한전요금제별 충전요금 분석
30 

Length

Max length25
Median length25
Mean length25
Min length25

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-01-10 한전요금제별 충전요금 분석
2nd row2024-01-10 한전요금제별 충전요금 분석
3rd row2024-01-10 한전요금제별 충전요금 분석
4th row2024-01-10 한전요금제별 충전요금 분석
5th row2024-01-10 한전요금제별 충전요금 분석

Common Values

ValueCountFrequency (%)
2024-01-10 한전요금제별 충전요금 분석 30
100.0%

Length

2024-03-13T20:56:31.279302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:56:31.382674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-10 30
25.0%
한전요금제별 30
25.0%
충전요금 30
25.0%
분석 30
25.0%

생산일시
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2024-01-10 14:45:47
Maximum2024-01-10 14:45:47
2024-03-13T20:56:31.468329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:31.557048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-13T20:56:27.662132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.010547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.298116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.752903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.115571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.436635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.839939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.209285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:56:27.550605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T20:56:31.635208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전기ID충전건시작일시종료일시전력사용요금전력사용요금경부하전력사용요금중부하전력사용요금최대부하
충전기ID1.0000.4921.0001.0000.3720.5010.0980.000
충전건0.4921.0001.0001.0000.0000.0000.3960.000
시작일시1.0001.0001.0001.0001.0001.0001.0001.000
종료일시1.0001.0001.0001.0001.0001.0001.0001.000
전력사용요금0.3720.0001.0001.0001.0000.8890.0000.000
전력사용요금경부하0.5010.0001.0001.0000.8891.0000.0000.000
전력사용요금중부하0.0980.3961.0001.0000.0000.0001.0000.000
전력사용요금최대부하0.0000.0001.0001.0000.0000.0000.0001.000
2024-03-13T20:56:31.758115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전력사용요금최대부하충전기ID충전건
전력사용요금최대부하1.0000.0000.000
충전기ID0.0001.0000.317
충전건0.0000.3171.000
2024-03-13T20:56:31.860591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전력사용요금전력사용요금경부하전력사용요금중부하충전기ID충전건전력사용요금최대부하
전력사용요금1.0000.692-0.3350.1750.0000.000
전력사용요금경부하0.6921.000-0.7530.1580.0000.000
전력사용요금중부하-0.335-0.7531.0000.0000.3770.000
충전기ID0.1750.1580.0001.0000.3170.000
충전건0.0000.0000.3770.3171.0000.000
전력사용요금최대부하0.0000.0000.0000.0000.0001.000

Missing values

2024-03-13T20:56:28.248406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T20:56:28.415697image/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

충전소ID충전기ID충전건시작일시종료일시전력량요금명기본요금전력사용요금전력사용요금경부하전력사용요금중부하전력사용요금최대부하비고생산일시
0KRPPKCS0001KRPPKCP000812023-10-03 02:13:372023-10-03 02:39:24선택2고압258028542854002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
1KRPPKCS0001KRPPKCP000722023-10-19 00:00:002023-10-19 01:47:58선택2고압25801166711667002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
2KRPPKCS0001KRPPKCP000122023-10-11 18:45:172023-10-11 18:52:45선택2고압2580873087302024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
3KRPPKCS0001KRPPKCP000312023-10-28 06:37:222023-10-28 06:42:46선택2고압2580583583002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
4KRPPKCS0001KRPPKCP000722023-10-21 21:36:292023-10-21 21:43:47선택2고압2580824082402024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
5KRPPKCS0001KRPPKCP000522023-10-15 00:00:002023-10-15 01:19:26선택2고압258086068606002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
6KRPPKCS0001KRPPKCP000712023-10-16 08:34:372023-10-16 08:44:08선택2고압258010600106002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
7KRPPKCS0001KRPPKCP000422023-10-09 22:54:052023-10-10 00:00:00선택2고압258067606760002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
8KRPPKCS0001KRPPKCP000322023-10-24 09:28:262023-10-24 09:36:26선택2고압2580913091302024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
9KRPPKCS0001KRPPKCP000812023-10-12 09:16:102023-10-12 09:38:14선택2고압258027600276002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
충전소ID충전기ID충전건시작일시종료일시전력량요금명기본요금전력사용요금전력사용요금경부하전력사용요금중부하전력사용요금최대부하비고생산일시
20KRPPKCS0001KRPPKCP000612023-10-30 00:00:002023-10-30 01:50:55선택2고압25801189511895002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
21KRPPKCS0001KRPPKCP000422023-10-14 17:44:032023-10-14 18:00:10선택2고압258019000190002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
22KRPPKCS0001KRPPKCP000412023-10-24 15:24:352023-10-24 16:08:14선택2고압258064470064472024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
23KRPPKCS0001KRPPKCP000412023-10-15 22:51:462023-10-16 00:00:00선택2고압258070417041002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
24KRPPKCS0001KRPPKCP000222023-10-31 16:47:572023-10-31 17:02:18선택2고압258017570017572024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
25KRPPKCS0001KRPPKCP000222023-10-17 19:12:392023-10-17 19:15:36선택2고압2580329032902024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
26KRPPKCS0001KRPPKCP000322023-10-25 07:24:302023-10-25 07:47:36선택2고압258025202520002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
27KRPPKCS0001KRPPKCP000522023-10-21 11:11:322023-10-21 11:27:39선택2고압258020080200802024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
28KRPPKCS0001KRPPKCP000522023-10-07 07:17:522023-10-07 07:37:10선택2고압258021272127002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47
29KRPPKCS0001KRPPKCP000712023-10-28 23:57:012023-10-29 00:00:00선택2고압2580273273002024-01-10 한전요금제별 충전요금 분석2024-01-10 14:45:47