Overview

Dataset statistics

Number of variables18
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.7 KiB
Average record size in memory160.4 B

Variable types

DateTime2
Categorical15
Text1

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/cae63362-1ec7-4fec-b402-c97c637dcbf1

Alerts

시험_유형 has constant value ""Constant
기준_년월 has constant value ""Constant
공급_전류 has constant value ""Constant
SOC has constant value ""Constant
감축_기준값(CBL) has constant value ""Constant
전력_사용량 has constant value ""Constant
전력_감축_량 has constant value ""Constant
기여도 has constant value ""Constant
정산금_전력량 has constant value ""Constant
총_수익금 has constant value ""Constant
기본_수익금 has constant value ""Constant
실적_수익금 has constant value ""Constant
위약금 has constant value ""Constant
비고 has constant value ""Constant
생산_일시 has constant value ""Constant

Reproduction

Analysis started2023-12-10 13:53:21.487607
Analysis finished2023-12-10 13:53:22.797105
Duration1.31 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

실행_일자
Date

Distinct11
Distinct (%)36.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-07-02 12:50:00
Maximum2023-07-02 12:50:11
2023-12-10T22:53:22.877690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:53:23.188837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)

시험_유형
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
등록시험
30 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row등록시험
2nd row등록시험
3rd row등록시험
4th row등록시험
5th row등록시험

Common Values

ValueCountFrequency (%)
등록시험 30
100.0%

Length

2023-12-10T22:53:23.572163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:23.757026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
등록시험 30
100.0%

충전_사업자
Categorical

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
가산차고지
13 
한남여객 본사차고지
11 
한남여객 서림차고지
6 

Length

Max length10
Median length10
Mean length7.8333333
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가산차고지
2nd row한남여객 본사차고지
3rd row한남여객 서림차고지
4th row한남여객 본사차고지
5th row한남여객 본사차고지

Common Values

ValueCountFrequency (%)
가산차고지 13
43.3%
한남여객 본사차고지 11
36.7%
한남여객 서림차고지 6
20.0%

Length

2023-12-10T22:53:23.972288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:24.188551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한남여객 17
36.2%
가산차고지 13
27.7%
본사차고지 11
23.4%
서림차고지 6
 
12.8%

충전기명
Text

Distinct22
Distinct (%)73.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T22:53:24.474687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

Total characters330
Distinct characters14
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16 ?
Unique (%)53.3%

Sample

1st rowKRPPKCP0132
2nd rowKRPPKCP0598
3rd rowKRPPKCP0591
4th rowKRPPKCP0594
5th rowKRPPKCP0594
ValueCountFrequency (%)
krppkcp0594 4
 
13.3%
krppkcp0131 2
 
6.7%
krppkcp0598 2
 
6.7%
krppkcp0138 2
 
6.7%
krppkcp0132 2
 
6.7%
krppkcp0597 2
 
6.7%
krppkcp0128 1
 
3.3%
krppkcp0136 1
 
3.3%
krppkcp0126 1
 
3.3%
krppkcp0134 1
 
3.3%
Other values (12) 12
40.0%
2023-12-10T22:53:25.230273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
P 90
27.3%
K 60
18.2%
0 31
 
9.4%
R 30
 
9.1%
C 30
 
9.1%
5 19
 
5.8%
9 16
 
4.8%
1 16
 
4.8%
3 11
 
3.3%
8 9
 
2.7%
Other values (4) 18
 
5.5%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 210
63.6%
Decimal Number 120
36.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 31
25.8%
5 19
15.8%
9 16
13.3%
1 16
13.3%
3 11
 
9.2%
8 9
 
7.5%
2 6
 
5.0%
4 5
 
4.2%
7 4
 
3.3%
6 3
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
P 90
42.9%
K 60
28.6%
R 30
 
14.3%
C 30
 
14.3%

Most occurring scripts

ValueCountFrequency (%)
Latin 210
63.6%
Common 120
36.4%

Most frequent character per script

Common
ValueCountFrequency (%)
0 31
25.8%
5 19
15.8%
9 16
13.3%
1 16
13.3%
3 11
 
9.2%
8 9
 
7.5%
2 6
 
5.0%
4 5
 
4.2%
7 4
 
3.3%
6 3
 
2.5%
Latin
ValueCountFrequency (%)
P 90
42.9%
K 60
28.6%
R 30
 
14.3%
C 30
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 330
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
P 90
27.3%
K 60
18.2%
0 31
 
9.4%
R 30
 
9.1%
C 30
 
9.1%
5 19
 
5.8%
9 16
 
4.8%
1 16
 
4.8%
3 11
 
3.3%
8 9
 
2.7%
Other values (4) 18
 
5.5%

기준_년월
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
202307 30
100.0%

Length

2023-12-10T22:53:25.507311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:25.719082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
202307 30
100.0%

공급_전류
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
50 30
100.0%

Length

2023-12-10T22:53:25.899158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:26.097712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
50 30
100.0%

SOC
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
80 30
100.0%

Length

2023-12-10T22:53:26.257554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:26.414372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
80 30
100.0%

감축_기준값(CBL)
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
676 30
100.0%

Length

2023-12-10T22:53:26.602216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:26.774832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
676 30
100.0%

전력_사용량
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
13 30
100.0%

Length

2023-12-10T22:53:26.930980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:27.114257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
13 30
100.0%

전력_감축_량
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
663 30
100.0%

Length

2023-12-10T22:53:27.301623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:27.441374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
663 30
100.0%

기여도
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
24 30
100.0%

Length

2023-12-10T22:53:27.608838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:27.772553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
24 30
100.0%

정산금_전력량
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
449 30
100.0%

Length

2023-12-10T22:53:27.922323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:28.076849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
449 30
100.0%

총_수익금
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
953157 30
100.0%

Length

2023-12-10T22:53:28.225924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:28.449478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
953157 30
100.0%

기본_수익금
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
227313 30
100.0%

Length

2023-12-10T22:53:28.637418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:28.804740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
227313 30
100.0%

실적_수익금
Categorical

CONSTANT 

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

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 30
100.0%

Length

2023-12-10T22:53:28.955852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:29.098233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

위약금
Categorical

CONSTANT 

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

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 30
100.0%

Length

2023-12-10T22:53:29.242520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:29.399942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-10-16 전기차 충전기 DR 운영 이력
30 

Length

Max length27
Median length27
Mean length27
Min length27

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-16 전기차 충전기 DR 운영 이력
2nd row2023-10-16 전기차 충전기 DR 운영 이력
3rd row2023-10-16 전기차 충전기 DR 운영 이력
4th row2023-10-16 전기차 충전기 DR 운영 이력
5th row2023-10-16 전기차 충전기 DR 운영 이력

Common Values

ValueCountFrequency (%)
2023-10-16 전기차 충전기 DR 운영 이력 30
100.0%

Length

2023-12-10T22:53:29.541614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:53:29.702550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-16 30
16.7%
전기차 30
16.7%
충전기 30
16.7%
dr 30
16.7%
운영 30
16.7%
이력 30
16.7%

생산_일시
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-10-16 16:51:00
Maximum2023-10-16 16:51:00
2023-12-10T22:53:29.845154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:53:29.997890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-10T22:53:30.126820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
실행_일자충전_사업자충전기명
실행_일자1.0000.0000.000
충전_사업자0.0001.0001.000
충전기명0.0001.0001.000

Missing values

2023-12-10T22:53:22.114915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:53:22.663146image/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

실행_일자시험_유형충전_사업자충전기명기준_년월공급_전류SOC감축_기준값(CBL)전력_사용량전력_감축_량기여도정산금_전력량총_수익금기본_수익금실적_수익금위약금비고생산_일시
02023-07-02 12:50:00등록시험가산차고지KRPPKCP013220230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
12023-07-02 12:50:00등록시험한남여객 본사차고지KRPPKCP059820230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
22023-07-02 12:50:00등록시험한남여객 서림차고지KRPPKCP059120230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
32023-07-02 12:50:00등록시험한남여객 본사차고지KRPPKCP059420230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
42023-07-02 12:50:01등록시험한남여객 본사차고지KRPPKCP059420230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
52023-07-02 12:50:02등록시험한남여객 서림차고지KRPPKCP059020230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
62023-07-02 12:50:02등록시험가산차고지KRPPKCP012520230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
72023-07-02 12:50:02등록시험가산차고지KRPPKCP013620230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
82023-07-02 12:50:02등록시험가산차고지KRPPKCP012620230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
92023-07-02 12:50:02등록시험가산차고지KRPPKCP013220230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
실행_일자시험_유형충전_사업자충전기명기준_년월공급_전류SOC감축_기준값(CBL)전력_사용량전력_감축_량기여도정산금_전력량총_수익금기본_수익금실적_수익금위약금비고생산_일시
202023-07-02 12:50:08등록시험한남여객 서림차고지KRPPKCP058820230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
212023-07-02 12:50:08등록시험한남여객 본사차고지KRPPKCP059620230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
222023-07-02 12:50:08등록시험한남여객 서림차고지KRPPKCP058920230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
232023-07-02 12:50:08등록시험한남여객 본사차고지KRPPKCP059420230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
242023-07-02 12:50:09등록시험가산차고지KRPPKCP013920230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
252023-07-02 12:50:09등록시험가산차고지KRPPKCP013120230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
262023-07-02 12:50:09등록시험한남여객 서림차고지KRPPKCP058720230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
272023-07-02 12:50:10등록시험한남여객 본사차고지KRPPKCP059320230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
282023-07-02 12:50:11등록시험가산차고지KRPPKCP013120230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00
292023-07-02 12:50:11등록시험한남여객 본사차고지KRPPKCP059720230750806761366324449953157227313002023-10-16 전기차 충전기 DR 운영 이력2023-10-16 16:51:00