Overview

Dataset statistics

Number of variables16
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 MiB
Average record size in memory141.0 B

Variable types

Categorical3
Text5
Numeric5
DateTime3

Dataset

Description제주특별자치도와 환경부(한국환경공단)에서 운영하는 전기차 충전기의 충전 이력 데이터를 월별, 요일별, 일별로 취합한 데이터 입니다. 전기차가 얼마나 충전 했는지, 충전 시간은 얼마나 되는지, 충전량은 얼마나 되는지 확인할 수 있습니다. 충전 횟수는 합계, 충전 시간, 충전량, 충전 금액은 평균으로 계산 되었습니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15109706/fileData.do

Alerts

운영기관 has constant value ""Constant
충전 시작 시 is highly overall correlated with 충전 종료 시High correlation
충전 종료 시 is highly overall correlated with 충전 시작 시High correlation
충전량 is highly overall correlated with 충전 금액High correlation
충전 금액 is highly overall correlated with 충전량High correlation
충전 종료 시 has 147 (1.5%) zerosZeros
충전량 has 325 (3.2%) zerosZeros
충전 금액 has 346 (3.5%) zerosZeros

Reproduction

Analysis started2023-12-12 04:54:39.878513
Analysis finished2023-12-12 04:54:47.212919
Duration7.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

운영기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
제주특별자치도
10000 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주특별자치도
2nd row제주특별자치도
3rd row제주특별자치도
4th row제주특별자치도
5th row제주특별자치도

Common Values

ValueCountFrequency (%)
제주특별자치도 10000
100.0%

Length

2023-12-12T13:54:47.306647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:54:47.434952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주특별자치도 10000
100.0%

충전소 아이디
Text

Distinct269
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T13:54:47.759397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length8
Mean length8
Min length8

Characters and Unicode

Total characters80000
Distinct characters12
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

Unique7 ?
Unique (%)0.1%

Sample

1st rowJD110058
2nd rowJD110046
3rd rowJD100026
4th rowJD210001
5th rowJD100047
ValueCountFrequency (%)
jd210001 424
 
4.2%
jd000003 408
 
4.1%
jd000001 374
 
3.7%
jd210004 269
 
2.7%
jd000004 244
 
2.4%
jd210002 232
 
2.3%
jd100021 219
 
2.2%
jd210005 217
 
2.2%
jd110041 197
 
2.0%
jd100010 191
 
1.9%
Other values (259) 7225
72.2%
2023-12-12T13:54:48.334703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 34143
42.7%
1 12027
 
15.0%
J 10000
 
12.5%
D 10000
 
12.5%
2 3390
 
4.2%
3 2152
 
2.7%
4 2065
 
2.6%
6 1902
 
2.4%
5 1379
 
1.7%
7 1118
 
1.4%
Other values (2) 1824
 
2.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 60000
75.0%
Uppercase Letter 20000
 
25.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 34143
56.9%
1 12027
 
20.0%
2 3390
 
5.7%
3 2152
 
3.6%
4 2065
 
3.4%
6 1902
 
3.2%
5 1379
 
2.3%
7 1118
 
1.9%
9 994
 
1.7%
8 830
 
1.4%
Uppercase Letter
ValueCountFrequency (%)
J 10000
50.0%
D 10000
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 60000
75.0%
Latin 20000
 
25.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 34143
56.9%
1 12027
 
20.0%
2 3390
 
5.7%
3 2152
 
3.6%
4 2065
 
3.4%
6 1902
 
3.2%
5 1379
 
2.3%
7 1118
 
1.9%
9 994
 
1.7%
8 830
 
1.4%
Latin
ValueCountFrequency (%)
J 10000
50.0%
D 10000
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 80000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 34143
42.7%
1 12027
 
15.0%
J 10000
 
12.5%
D 10000
 
12.5%
2 3390
 
4.2%
3 2152
 
2.7%
4 2065
 
2.6%
6 1902
 
2.4%
5 1379
 
1.7%
7 1118
 
1.4%
Other values (2) 1824
 
2.3%

충전소 이름
Text

Distinct268
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T13:54:48.706194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length14
Mean length7.6103
Min length3

Characters and Unicode

Total characters76103
Distinct characters272
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique7 ?
Unique (%)0.1%

Sample

1st row우당도서관
2nd row한화꿈에그린아파트
3rd row대륜동 문화복지센터
4th row함덕회차지
5th row중앙공영주차장
ValueCountFrequency (%)
제주시청 465
 
3.8%
함덕회차지 424
 
3.4%
공영주차장 382
 
3.1%
제주특별자치도청 374
 
3.0%
제2청사 307
 
2.5%
국제부두회차지 269
 
2.2%
서귀포시청 244
 
2.0%
제주시공영버스차고지 232
 
1.9%
탐라도서관 219
 
1.8%
서귀포 218
 
1.8%
Other values (291) 9160
74.5%
2023-12-12T13:54:49.205153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 4872
 
6.4%
제 3463
 
4.6%
차 2889
 
3.8%
2294
 
3.0%
지 2228
 
2.9%
장 2176
 
2.9%
공 1823
 
2.4%
청 1755
 
2.3%
영 1714
 
2.3%
서 1708
 
2.2%
Other values (262) 51181
67.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 71995
94.6%
Space Separator 2294
 
3.0%
Decimal Number 1485
 
2.0%
Close Punctuation 132
 
0.2%
Open Punctuation 132
 
0.2%
Uppercase Letter 36
 
< 0.1%
Other Punctuation 29
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 4872
 
6.8%
제 3463
 
4.8%
차 2889
 
4.0%
지 2228
 
3.1%
장 2176
 
3.0%
공 1823
 
2.5%
청 1755
 
2.4%
영 1714
 
2.4%
서 1708
 
2.4%
도 1659
 
2.3%
Other values (249) 47708
66.3%
Decimal Number
ValueCountFrequency (%)
2 693
46.7%
1 599
40.3%
9 61
 
4.1%
3 53
 
3.6%
5 41
 
2.8%
4 38
 
2.6%
Uppercase Letter
ValueCountFrequency (%)
H 12
33.3%
S 12
33.3%
E 12
33.3%
Space Separator
ValueCountFrequency (%)
2294
100.0%
Close Punctuation
ValueCountFrequency (%)
) 132
100.0%
Open Punctuation
ValueCountFrequency (%)
( 132
100.0%
Other Punctuation
ValueCountFrequency (%)
· 29
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 71995
94.6%
Common 4072
 
5.4%
Latin 36
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 4872
 
6.8%
제 3463
 
4.8%
차 2889
 
4.0%
지 2228
 
3.1%
장 2176
 
3.0%
공 1823
 
2.5%
청 1755
 
2.4%
영 1714
 
2.4%
서 1708
 
2.4%
도 1659
 
2.3%
Other values (249) 47708
66.3%
Common
ValueCountFrequency (%)
2294
56.3%
2 693
 
17.0%
1 599
 
14.7%
) 132
 
3.2%
( 132
 
3.2%
9 61
 
1.5%
3 53
 
1.3%
5 41
 
1.0%
4 38
 
0.9%
· 29
 
0.7%
Latin
ValueCountFrequency (%)
H 12
33.3%
S 12
33.3%
E 12
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 71995
94.6%
ASCII 4079
 
5.4%
None 29
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 4872
 
6.8%
제 3463
 
4.8%
차 2889
 
4.0%
지 2228
 
3.1%
장 2176
 
3.0%
공 1823
 
2.5%
청 1755
 
2.4%
영 1714
 
2.4%
서 1708
 
2.4%
도 1659
 
2.3%
Other values (249) 47708
66.3%
ASCII
ValueCountFrequency (%)
2294
56.2%
2 693
 
17.0%
1 599
 
14.7%
) 132
 
3.2%
( 132
 
3.2%
9 61
 
1.5%
3 53
 
1.3%
5 41
 
1.0%
4 38
 
0.9%
H 12
 
0.3%
Other values (2) 24
 
0.6%
None
ValueCountFrequency (%)
· 29
100.0%

충전기 아이디
Real number (ℝ)

Distinct15
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0625
Minimum1
Maximum16
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:54:49.361232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q32
95-th percentile6
Maximum16
Range15
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.9018295
Coefficient of variation (CV)0.92209915
Kurtosis15.014894
Mean2.0625
Median Absolute Deviation (MAD)0
Skewness3.365904
Sum20625
Variance3.6169554
MonotonicityNot monotonic
2023-12-12T13:54:49.540234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
1 5326
53.3%
2 2583
25.8%
3 810
 
8.1%
4 505
 
5.1%
5 254
 
2.5%
6 169
 
1.7%
7 95
 
0.9%
8 66
 
0.7%
10 52
 
0.5%
9 40
 
0.4%
Other values (5) 100
 
1.0%
ValueCountFrequency (%)
1 5326
53.3%
2 2583
25.8%
3 810
 
8.1%
4 505
 
5.1%
5 254
 
2.5%
6 169
 
1.7%
7 95
 
0.9%
8 66
 
0.7%
9 40
 
0.4%
10 52
 
0.5%
ValueCountFrequency (%)
16 26
 
0.3%
14 15
 
0.1%
13 8
 
0.1%
12 35
 
0.4%
11 16
 
0.2%
10 52
 
0.5%
9 40
 
0.4%
8 66
 
0.7%
7 95
0.9%
6 169
1.7%

충전기 이름
Text

Distinct490
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T13:54:49.811998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length10.5896
Min length6

Characters and Unicode

Total characters105896
Distinct characters277
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique17 ?
Unique (%)0.2%

Sample

1st row우당도서관_01
2nd row한화꿈에그린아파트_01
3rd row대륜동 문화복지센터_01
4th row함덕회차지_03
5th row중앙공영주차장_02
ValueCountFrequency (%)
공영주차장_01 247
 
2.0%
서귀포 218
 
1.8%
도청 191
 
1.6%
제2청사 191
 
1.6%
함덕회차지_02 152
 
1.2%
함덕회차지_03 136
 
1.1%
함덕회차지_01 136
 
1.1%
공영주차장_02 135
 
1.1%
국제부두회차지_01 135
 
1.1%
국제부두회차지_02 134
 
1.1%
Other values (511) 10619
86.4%
2023-12-12T13:54:50.269690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
_ 9985
 
9.4%
0 9885
 
9.3%
1 6078
 
5.7%
주 4872
 
4.6%
제 3463
 
3.3%
2 3311
 
3.1%
차 2889
 
2.7%
2294
 
2.2%
지 2228
 
2.1%
장 2176
 
2.1%
Other values (267) 58715
55.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 71869
67.9%
Decimal Number 21455
 
20.3%
Connector Punctuation 9985
 
9.4%
Space Separator 2294
 
2.2%
Open Punctuation 114
 
0.1%
Close Punctuation 114
 
0.1%
Uppercase Letter 36
 
< 0.1%
Other Punctuation 29
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 4872
 
6.8%
제 3463
 
4.8%
차 2889
 
4.0%
지 2228
 
3.1%
장 2176
 
3.0%
공 1823
 
2.5%
청 1755
 
2.4%
영 1714
 
2.4%
서 1708
 
2.4%
도 1659
 
2.3%
Other values (249) 47582
66.2%
Decimal Number
ValueCountFrequency (%)
0 9885
46.1%
1 6078
28.3%
2 3311
 
15.4%
3 871
 
4.1%
4 558
 
2.6%
5 295
 
1.4%
6 195
 
0.9%
9 101
 
0.5%
7 95
 
0.4%
8 66
 
0.3%
Uppercase Letter
ValueCountFrequency (%)
E 12
33.3%
S 12
33.3%
H 12
33.3%
Connector Punctuation
ValueCountFrequency (%)
_ 9985
100.0%
Space Separator
ValueCountFrequency (%)
2294
100.0%
Open Punctuation
ValueCountFrequency (%)
( 114
100.0%
Close Punctuation
ValueCountFrequency (%)
) 114
100.0%
Other Punctuation
ValueCountFrequency (%)
· 29
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 71869
67.9%
Common 33991
32.1%
Latin 36
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 4872
 
6.8%
제 3463
 
4.8%
차 2889
 
4.0%
지 2228
 
3.1%
장 2176
 
3.0%
공 1823
 
2.5%
청 1755
 
2.4%
영 1714
 
2.4%
서 1708
 
2.4%
도 1659
 
2.3%
Other values (249) 47582
66.2%
Common
ValueCountFrequency (%)
_ 9985
29.4%
0 9885
29.1%
1 6078
17.9%
2 3311
 
9.7%
2294
 
6.7%
3 871
 
2.6%
4 558
 
1.6%
5 295
 
0.9%
6 195
 
0.6%
( 114
 
0.3%
Other values (5) 405
 
1.2%
Latin
ValueCountFrequency (%)
E 12
33.3%
S 12
33.3%
H 12
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 71869
67.9%
ASCII 33998
32.1%
None 29
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_ 9985
29.4%
0 9885
29.1%
1 6078
17.9%
2 3311
 
9.7%
2294
 
6.7%
3 871
 
2.6%
4 558
 
1.6%
5 295
 
0.9%
6 195
 
0.6%
( 114
 
0.3%
Other values (7) 412
 
1.2%
Hangul
ValueCountFrequency (%)
주 4872
 
6.8%
제 3463
 
4.8%
차 2889
 
4.0%
지 2228
 
3.1%
장 2176
 
3.0%
공 1823
 
2.5%
청 1755
 
2.4%
영 1714
 
2.4%
서 1708
 
2.4%
도 1659
 
2.3%
Other values (249) 47582
66.2%
None
ValueCountFrequency (%)
· 29
100.0%

충전기 타입
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
DC콤보
4045 
완속
1885 
AC급속3상
1405 
DC차데모
1400 
DC콤보2(버스충전기용)
1263 

Length

Max length13
Median length6
Mean length5.1807
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDC차데모
2nd rowDC차데모
3rd rowAC급속3상
4th rowDC콤보2(버스충전기용)
5th rowDC콤보

Common Values

ValueCountFrequency (%)
DC콤보 4045
40.5%
완속 1885
18.9%
AC급속3상 1405
 
14.1%
DC차데모 1400
 
14.0%
DC콤보2(버스충전기용) 1263
 
12.6%
<NA> 2
 
< 0.1%

Length

2023-12-12T13:54:50.455882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:54:50.584778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
dc콤보 4045
40.5%
완속 1885
18.9%
ac급속3상 1405
 
14.1%
dc차데모 1400
 
14.0%
dc콤보2(버스충전기용 1263
 
12.6%
na 2
 
< 0.1%

충전 시작 일자
Date

Distinct45
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-05-17 00:00:00
Maximum2021-06-30 00:00:00
2023-12-12T13:54:50.728621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:50.890320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)

충전 시작 시
Real number (ℝ)

HIGH CORRELATION 

Distinct24
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.6626
Minimum0
Maximum23
Zeros86
Zeros (%)0.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:54:51.021374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile6
Q110
median14
Q317
95-th percentile21
Maximum23
Range23
Interquartile range (IQR)7

Descriptive statistics

Standard deviation4.7050159
Coefficient of variation (CV)0.34437193
Kurtosis-0.31656187
Mean13.6626
Median Absolute Deviation (MAD)4
Skewness-0.27917712
Sum136626
Variance22.137175
MonotonicityNot monotonic
2023-12-12T13:54:51.196761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
17 768
 
7.7%
16 748
 
7.5%
14 722
 
7.2%
15 715
 
7.1%
13 709
 
7.1%
18 689
 
6.9%
11 655
 
6.6%
12 651
 
6.5%
10 621
 
6.2%
8 602
 
6.0%
Other values (14) 3120
31.2%
ValueCountFrequency (%)
0 86
 
0.9%
1 50
 
0.5%
2 40
 
0.4%
3 29
 
0.3%
4 38
 
0.4%
5 100
 
1.0%
6 217
 
2.2%
7 334
3.3%
8 602
6.0%
9 590
5.9%
ValueCountFrequency (%)
23 121
 
1.2%
22 219
 
2.2%
21 320
3.2%
20 423
4.2%
19 553
5.5%
18 689
6.9%
17 768
7.7%
16 748
7.5%
15 715
7.1%
14 722
7.2%

충전 시작 분초
Text

Distinct3346
Distinct (%)33.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T13:54:51.681035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length5
Min length5

Characters and Unicode

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

Unique

Unique611 ?
Unique (%)6.1%

Sample

1st row33:26
2nd row16:03
3rd row46:57
4th row09:43
5th row18:43
ValueCountFrequency (%)
22:22 9
 
0.1%
50:31 9
 
0.1%
31:30 9
 
0.1%
32:28 9
 
0.1%
24:10 9
 
0.1%
42:35 9
 
0.1%
51:23 9
 
0.1%
13:03 9
 
0.1%
18:45 8
 
0.1%
46:08 8
 
0.1%
Other values (3336) 9912
99.1%
2023-12-12T13:54:52.302406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
: 10000
20.0%
1 5392
10.8%
2 5359
10.7%
3 5356
10.7%
4 5309
10.6%
5 5288
10.6%
0 5258
10.5%
6 2103
 
4.2%
9 2009
 
4.0%
8 1972
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 40000
80.0%
Other Punctuation 10000
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 5392
13.5%
2 5359
13.4%
3 5356
13.4%
4 5309
13.3%
5 5288
13.2%
0 5258
13.1%
6 2103
 
5.3%
9 2009
 
5.0%
8 1972
 
4.9%
7 1954
 
4.9%
Other Punctuation
ValueCountFrequency (%)
: 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 50000
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
: 10000
20.0%
1 5392
10.8%
2 5359
10.7%
3 5356
10.7%
4 5309
10.6%
5 5288
10.6%
0 5258
10.5%
6 2103
 
4.2%
9 2009
 
4.0%
8 1972
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 50000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
: 10000
20.0%
1 5392
10.8%
2 5359
10.7%
3 5356
10.7%
4 5309
10.6%
5 5288
10.6%
0 5258
10.5%
6 2103
 
4.2%
9 2009
 
4.0%
8 1972
 
3.9%

충전 종료 일자
Date

Distinct46
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-05-17 00:00:00
Maximum2021-07-01 00:00:00
2023-12-12T13:54:52.481032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:52.926464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)

충전 종료 시
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct24
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.9473
Minimum0
Maximum23
Zeros147
Zeros (%)1.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:54:53.060269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile6
Q111
median14
Q318
95-th percentile21
Maximum23
Range23
Interquartile range (IQR)7

Descriptive statistics

Standard deviation4.9252359
Coefficient of variation (CV)0.35313185
Kurtosis-0.014471827
Mean13.9473
Median Absolute Deviation (MAD)4
Skewness-0.45583748
Sum139473
Variance24.257949
MonotonicityNot monotonic
2023-12-12T13:54:53.198872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
17 754
 
7.5%
16 750
 
7.5%
14 726
 
7.3%
15 705
 
7.0%
18 693
 
6.9%
11 690
 
6.9%
13 676
 
6.8%
10 653
 
6.5%
12 638
 
6.4%
19 591
 
5.9%
Other values (14) 3124
31.2%
ValueCountFrequency (%)
0 147
 
1.5%
1 75
 
0.8%
2 67
 
0.7%
3 48
 
0.5%
4 53
 
0.5%
5 66
 
0.7%
6 182
 
1.8%
7 229
2.3%
8 379
3.8%
9 545
5.5%
ValueCountFrequency (%)
23 181
 
1.8%
22 268
 
2.7%
21 383
3.8%
20 501
5.0%
19 591
5.9%
18 693
6.9%
17 754
7.5%
16 750
7.5%
15 705
7.0%
14 726
7.3%

충전 종료 분초
Text

Distinct3385
Distinct (%)33.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T13:54:53.621564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length5
Min length5

Characters and Unicode

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

Unique

Unique622 ?
Unique (%)6.2%

Sample

1st row51:09
2nd row56:08
3rd row53:24
4th row35:03
5th row55:05
ValueCountFrequency (%)
20:51 11
 
0.1%
40:09 11
 
0.1%
51:21 10
 
0.1%
27:10 10
 
0.1%
15:59 10
 
0.1%
56:27 9
 
0.1%
07:30 9
 
0.1%
16:10 9
 
0.1%
03:56 8
 
0.1%
45:03 8
 
0.1%
Other values (3375) 9905
99.1%
2023-12-12T13:54:54.144660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
: 10000
20.0%
0 5384
10.8%
4 5381
10.8%
2 5354
10.7%
5 5342
10.7%
1 5272
10.5%
3 5264
10.5%
9 2053
 
4.1%
8 2003
 
4.0%
7 1980
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 40000
80.0%
Other Punctuation 10000
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 5384
13.5%
4 5381
13.5%
2 5354
13.4%
5 5342
13.4%
1 5272
13.2%
3 5264
13.2%
9 2053
 
5.1%
8 2003
 
5.0%
7 1980
 
5.0%
6 1967
 
4.9%
Other Punctuation
ValueCountFrequency (%)
: 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 50000
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
: 10000
20.0%
0 5384
10.8%
4 5381
10.8%
2 5354
10.7%
5 5342
10.7%
1 5272
10.5%
3 5264
10.5%
9 2053
 
4.1%
8 2003
 
4.0%
7 1980
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 50000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
: 10000
20.0%
0 5384
10.8%
4 5381
10.8%
2 5354
10.7%
5 5342
10.7%
1 5272
10.5%
3 5264
10.5%
9 2053
 
4.1%
8 2003
 
4.0%
7 1980
 
4.0%

충전 시간
Date

Distinct3687
Distinct (%)36.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-12 00:00:00
Maximum2023-12-12 20:41:55
2023-12-12T13:54:54.299051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:54.464766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

충전량
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct3089
Distinct (%)30.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.457823
Minimum0
Maximum156.5
Zeros325
Zeros (%)3.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:54:54.643825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.36
Q17.56
median13.84
Q321.55
95-th percentile52.5
Maximum156.5
Range156.5
Interquartile range (IQR)13.99

Descriptive statistics

Standard deviation15.71701
Coefficient of variation (CV)0.90028467
Kurtosis6.3092002
Mean17.457823
Median Absolute Deviation (MAD)6.81
Skewness2.1150185
Sum174578.23
Variance247.02442
MonotonicityNot monotonic
2023-12-12T13:54:54.791750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 325
 
3.2%
12.0 195
 
1.9%
20.0 167
 
1.7%
5.0 142
 
1.4%
8.0 130
 
1.3%
4.0 97
 
1.0%
0.1 43
 
0.4%
20.01 42
 
0.4%
16.0 40
 
0.4%
8.01 37
 
0.4%
Other values (3079) 8782
87.8%
ValueCountFrequency (%)
0.0 325
3.2%
0.01 14
 
0.1%
0.02 9
 
0.1%
0.03 5
 
0.1%
0.04 5
 
0.1%
0.05 2
 
< 0.1%
0.06 3
 
< 0.1%
0.07 1
 
< 0.1%
0.08 4
 
< 0.1%
0.09 1
 
< 0.1%
ValueCountFrequency (%)
156.5 1
< 0.1%
134.5 1
< 0.1%
121.5 1
< 0.1%
121.44 1
< 0.1%
120.08 1
< 0.1%
119.5 1
< 0.1%
117.82 1
< 0.1%
117.0 1
< 0.1%
114.5 1
< 0.1%
111.0 1
< 0.1%

충전 금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct3083
Distinct (%)30.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4363.6338
Minimum0
Maximum39125
Zeros346
Zeros (%)3.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:54:54.959965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile75
Q11890
median3460
Q35387.75
95-th percentile13125
Maximum39125
Range39125
Interquartile range (IQR)3497.75

Descriptive statistics

Standard deviation3931.9216
Coefficient of variation (CV)0.90106589
Kurtosis6.2884153
Mean4363.6338
Median Absolute Deviation (MAD)1702
Skewness2.1104947
Sum43636338
Variance15460007
MonotonicityNot monotonic
2023-12-12T13:54:55.163213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 346
 
3.5%
3000 228
 
2.3%
5000 227
 
2.3%
2000 169
 
1.7%
1250 137
 
1.4%
1000 111
 
1.1%
4000 50
 
0.5%
25 43
 
0.4%
2500 41
 
0.4%
7000 30
 
0.3%
Other values (3073) 8618
86.2%
ValueCountFrequency (%)
0 346
3.5%
2 14
 
0.1%
5 9
 
0.1%
7 5
 
0.1%
10 5
 
0.1%
12 2
 
< 0.1%
15 3
 
< 0.1%
17 1
 
< 0.1%
20 4
 
< 0.1%
22 1
 
< 0.1%
ValueCountFrequency (%)
39125 1
< 0.1%
33625 1
< 0.1%
30375 1
< 0.1%
30360 1
< 0.1%
30020 1
< 0.1%
29875 1
< 0.1%
29455 1
< 0.1%
29250 1
< 0.1%
28625 1
< 0.1%
27750 1
< 0.1%

충전 완료 상태
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
정상적으로 충전이 완료된 경우
4894 
고객이 Stop Button 누른 경우
2854 
차량에서 충전 종료를 요구한 경우(급속)
1769 
충전기 Error로 충전이 종료된 경우
 
302
통신오류에 의한 무과금 충전 완료한 경우
 
149

Length

Max length23
Median length22
Mean length18.7512
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row차량에서 충전 종료를 요구한 경우(급속)
2nd row차량에서 충전 종료를 요구한 경우(급속)
3rd row정상적으로 충전이 완료된 경우
4th row정상적으로 충전이 완료된 경우
5th row고객이 Stop Button 누른 경우

Common Values

ValueCountFrequency (%)
정상적으로 충전이 완료된 경우 4894
48.9%
고객이 Stop Button 누른 경우 2854
28.5%
차량에서 충전 종료를 요구한 경우(급속) 1769
 
17.7%
충전기 Error로 충전이 종료된 경우 302
 
3.0%
통신오류에 의한 무과금 충전 완료한 경우 149
 
1.5%
고객이 Emergency Button 경우 32
 
0.3%

Length

2023-12-12T13:54:55.317317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:54:55.464574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경우 8231
18.2%
충전이 5196
11.5%
정상적으로 4894
10.8%
완료된 4894
10.8%
고객이 2886
 
6.4%
button 2886
 
6.4%
stop 2854
 
6.3%
누른 2854
 
6.3%
충전 1918
 
4.2%
요구한 1769
 
3.9%
Other values (11) 6841
15.1%

Interactions

2023-12-12T13:54:45.814077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:43.175289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:43.798672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:44.520381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:45.164848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:45.963025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:43.299027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:43.959178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:44.638518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:45.311379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:46.089895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:43.419109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:44.091248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:44.765586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:45.429363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:46.254092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:43.529429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:44.209038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:44.875247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:45.543251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:46.455506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:43.663574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:44.358917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:45.034939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:54:45.663537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:54:55.577880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전기 아이디충전기 타입충전 시작 일자충전 시작 시충전 종료 일자충전 종료 시충전량충전 금액충전 완료 상태
충전기 아이디1.0000.3820.0230.0810.0400.0590.0900.0890.111
충전기 타입0.3821.0000.0950.1930.0850.2060.7280.7290.395
충전 시작 일자0.0230.0951.0000.1361.0000.1270.0500.0490.101
충전 시작 시0.0810.1930.1361.0000.1560.9700.1250.1260.076
충전 종료 일자0.0400.0851.0000.1561.0000.1680.0530.0530.091
충전 종료 시0.0590.2060.1270.9700.1681.0000.1700.1690.057
충전량0.0900.7280.0500.1250.0530.1701.0001.0000.332
충전 금액0.0890.7290.0490.1260.0530.1691.0001.0000.332
충전 완료 상태0.1110.3950.1010.0760.0910.0570.3320.3321.000
2023-12-12T13:54:55.726529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전기 타입충전 완료 상태
충전기 타입1.0000.281
충전 완료 상태0.2811.000
2023-12-12T13:54:55.813998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전기 아이디충전 시작 시충전 종료 시충전량충전 금액충전기 타입충전 완료 상태
충전기 아이디1.000-0.002-0.0050.0590.0570.1740.056
충전 시작 시-0.0021.0000.8710.0350.0350.0810.040
충전 종료 시-0.0050.8711.0000.0280.0280.0870.030
충전량0.0590.0350.0281.0001.0000.3880.182
충전 금액0.0570.0350.0281.0001.0000.3880.182
충전기 타입0.1740.0810.0870.3880.3881.0000.281
충전 완료 상태0.0560.0400.0300.1820.1820.2811.000

Missing values

2023-12-12T13:54:46.692266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:54:47.038530image/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

운영기관충전소 아이디충전소 이름충전기 아이디충전기 이름충전기 타입충전 시작 일자충전 시작 시충전 시작 분초충전 종료 일자충전 종료 시충전 종료 분초충전 시간충전량충전 금액충전 완료 상태
21336제주특별자치도JD110058우당도서관1우당도서관_01DC차데모2021-06-161633:262021-06-161651:0900:17:434.571142차량에서 충전 종료를 요구한 경우(급속)
19501제주특별자치도JD110046한화꿈에그린아파트1한화꿈에그린아파트_01DC차데모2021-06-172016:032021-06-172056:0800:40:0520.465115차량에서 충전 종료를 요구한 경우(급속)
44924제주특별자치도JD100026대륜동 문화복지센터1대륜동 문화복지센터_01AC급속3상2021-05-30746:572021-05-30753:2400:06:274.011000정상적으로 충전이 완료된 경우
16676제주특별자치도JD210001함덕회차지3함덕회차지_03DC콤보2(버스충전기용)2021-06-192009:432021-06-192035:0300:25:2048.512125정상적으로 충전이 완료된 경우
35272제주특별자치도JD100047중앙공영주차장2중앙공영주차장_02DC콤보2021-06-061318:432021-06-061355:0500:36:2222.05500고객이 Stop Button 누른 경우
44892제주특별자치도JD000101동부소방서1동부소방서_01완속2021-05-30825:042021-05-301319:2904:54:2534.18525정상적으로 충전이 완료된 경우
43330제주특별자치도JD000003제주시청12제주시청_12DC차데모2021-05-311228:592021-05-311307:2200:38:2318.84700차량에서 충전 종료를 요구한 경우(급속)
34662제주특별자치도JD110013한림금능농공단지(제주맥주)1한림금능농공단지(제주맥주)_01DC콤보2021-06-062143:562021-06-062223:5600:40:0010.812702정상적으로 충전이 완료된 경우
8853제주특별자치도JD000123서귀포소방서1서귀포소방서_01완속2021-06-25505:102021-06-25505:1700:00:070.00고객이 Stop Button 누른 경우
41192제주특별자치도JD110072한경면종합복지회관1한경면종합복지회관_01DC콤보2021-06-011958:112021-06-012014:5100:16:4012.03000정상적으로 충전이 완료된 경우
운영기관충전소 아이디충전소 이름충전기 아이디충전기 이름충전기 타입충전 시작 일자충전 시작 시충전 시작 분초충전 종료 일자충전 종료 시충전 종료 분초충전 시간충전량충전 금액충전 완료 상태
29477제주특별자치도JD000002제주특별자치도의회2제주특별자치도의회_02DC콤보2021-06-101330:342021-06-101404:4700:34:1321.025255차량에서 충전 종료를 요구한 경우(급속)
22915제주특별자치도JD210004국제부두회차지1국제부두회차지_01DC콤보2(버스충전기용)2021-06-151414:492021-06-151456:5400:42:0582.520625정상적으로 충전이 완료된 경우
33993제주특별자치도JD000011용담2동 주민센터1용담2동 주민센터_01DC콤보2021-06-071305:092021-06-071332:3600:27:279.62400고객이 Stop Button 누른 경우
54328제주특별자치도JD100026대륜동 문화복지센터1대륜동 문화복지센터_01DC콤보2021-05-221832:452021-05-221913:0000:40:1513.523380정상적으로 충전이 완료된 경우
55558제주특별자치도JD210006별빛누리공원4별빛누리공원_04DC콤보2(버스충전기용)2021-05-211837:242021-05-211907:1500:29:5148.7412185고객이 Stop Button 누른 경우
31329제주특별자치도JD000003제주시청2제주시청_02DC차데모2021-06-091011:082021-06-091022:2000:11:124.731182고객이 Stop Button 누른 경우
40383제주특별자치도JD210002제주시공영버스차고지2제주시공영버스차고지_02DC콤보2(버스충전기용)2021-06-021401:212021-06-021437:0100:35:4075.018750정상적으로 충전이 완료된 경우
13818제주특별자치도JD000003제주시청1제주시청_01DC콤보2021-06-211903:122021-06-211933:1600:30:046.41600고객이 Stop Button 누른 경우
53573제주특별자치도JD160002서부소방서 안덕 119센터1서부소방서 안덕 119센터_01DC차데모2021-05-231427:572021-05-231446:5500:18:586.991747고객이 Stop Button 누른 경우
37765제주특별자치도JD210001함덕회차지2함덕회차지_02DC콤보2(버스충전기용)2021-06-041315:172021-06-041324:5300:09:3615.53875정상적으로 충전이 완료된 경우