Overview

Dataset statistics

Number of variables9
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory820.3 KiB
Average record size in memory84.0 B

Variable types

Categorical2
Text2
Numeric3
DateTime2

Dataset

Description2021.1.1-2022.3.31 기간의 서울시에 위치하고 있는 한국전력공사의 전기차 충전소의 충전량을 제공합니다.
Author한국전력공사
URLhttps://www.data.go.kr/data/15100212/fileData.do

Alerts

충전기용량 is highly overall correlated with 충전구분High correlation
충전구분 is highly overall correlated with 충전기용량High correlation
충전시간 has 3383 (33.8%) zerosZeros
충전분 has 223 (2.2%) zerosZeros

Reproduction

Analysis started2023-12-12 09:29:26.641033
Analysis finished2023-12-12 09:29:29.244574
Duration2.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

충전구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
완속
5456 
급속
4544 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row완속
2nd row완속
3rd row급속
4th row완속
5th row완속

Common Values

ValueCountFrequency (%)
완속 5456
54.6%
급속 4544
45.4%

Length

2023-12-12T18:29:29.317291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:29:29.425607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완속 5456
54.6%
급속 4544
45.4%
Distinct74
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T18:29:29.639827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length14
Mean length8.4962
Min length4

Characters and Unicode

Total characters84962
Distinct characters155
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row레이크팰리스
2nd row레이크팰리스
3rd row현대백화점 천호점
4th row갤러리아팰리스
5th row송파파크데일2단지
ValueCountFrequency (%)
아파트 2579
 
17.1%
공영주차장 886
 
5.9%
리센츠 669
 
4.4%
주민센터 643
 
4.3%
레이크팰리스 523
 
3.5%
가락시장 477
 
3.2%
송파꿈에그린(위례24단지 397
 
2.6%
천호1동 383
 
2.5%
송파구청 329
 
2.2%
가락2동 328
 
2.2%
Other values (77) 7847
52.1%
2023-12-12T18:29:30.137796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7370
 
8.7%
5061
 
6.0%
3613
 
4.3%
3527
 
4.2%
3086
 
3.6%
2484
 
2.9%
2458
 
2.9%
2424
 
2.9%
2308
 
2.7%
1611
 
1.9%
Other values (145) 51020
60.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 74488
87.7%
Space Separator 5061
 
6.0%
Decimal Number 4411
 
5.2%
Close Punctuation 397
 
0.5%
Open Punctuation 397
 
0.5%
Uppercase Letter 208
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
7370
 
9.9%
3613
 
4.9%
3527
 
4.7%
3086
 
4.1%
2484
 
3.3%
2458
 
3.3%
2424
 
3.3%
2308
 
3.1%
1611
 
2.2%
1592
 
2.1%
Other values (131) 44015
59.1%
Decimal Number
ValueCountFrequency (%)
2 1343
30.4%
1 1082
24.5%
3 627
14.2%
4 557
12.6%
5 303
 
6.9%
9 189
 
4.3%
6 152
 
3.4%
7 122
 
2.8%
0 36
 
0.8%
Uppercase Letter
ValueCountFrequency (%)
S 104
50.0%
G 104
50.0%
Space Separator
ValueCountFrequency (%)
5061
100.0%
Close Punctuation
ValueCountFrequency (%)
) 397
100.0%
Open Punctuation
ValueCountFrequency (%)
( 397
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 74488
87.7%
Common 10266
 
12.1%
Latin 208
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
7370
 
9.9%
3613
 
4.9%
3527
 
4.7%
3086
 
4.1%
2484
 
3.3%
2458
 
3.3%
2424
 
3.3%
2308
 
3.1%
1611
 
2.2%
1592
 
2.1%
Other values (131) 44015
59.1%
Common
ValueCountFrequency (%)
5061
49.3%
2 1343
 
13.1%
1 1082
 
10.5%
3 627
 
6.1%
4 557
 
5.4%
) 397
 
3.9%
( 397
 
3.9%
5 303
 
3.0%
9 189
 
1.8%
6 152
 
1.5%
Other values (2) 158
 
1.5%
Latin
ValueCountFrequency (%)
S 104
50.0%
G 104
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 74488
87.7%
ASCII 10474
 
12.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
7370
 
9.9%
3613
 
4.9%
3527
 
4.7%
3086
 
4.1%
2484
 
3.3%
2458
 
3.3%
2424
 
3.3%
2308
 
3.1%
1611
 
2.2%
1592
 
2.1%
Other values (131) 44015
59.1%
ASCII
ValueCountFrequency (%)
5061
48.3%
2 1343
 
12.8%
1 1082
 
10.3%
3 627
 
6.0%
4 557
 
5.3%
) 397
 
3.8%
( 397
 
3.8%
5 303
 
2.9%
9 189
 
1.8%
6 152
 
1.5%
Other values (4) 366
 
3.5%

주소
Text

Distinct74
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T18:29:30.481593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length26
Mean length20.605
Min length14

Characters and Unicode

Total characters206050
Distinct characters103
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시 송파구 잠실동 잠실로 88
2nd row서울특별시 송파구 잠실동 잠실로 88
3rd row서울특별시 강동구 천호대로 1005
4th row서울특별시 송파구 잠실동 40
5th row서울특별시 송파구 마천동 성내천로47길 38
ValueCountFrequency (%)
서울특별시 9980
21.8%
송파구 6757
 
14.8%
강동구 3038
 
6.6%
장지동 1256
 
2.7%
올림픽로 914
 
2.0%
잠실동 768
 
1.7%
135 669
 
1.5%
양재대로 637
 
1.4%
거여동 636
 
1.4%
가락동 634
 
1.4%
Other values (134) 20422
44.7%
2023-12-12T18:29:31.015310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
35711
17.3%
10905
 
5.3%
10710
 
5.2%
10000
 
4.9%
9980
 
4.8%
9980
 
4.8%
9980
 
4.8%
9980
 
4.8%
7648
 
3.7%
7628
 
3.7%
Other values (93) 83528
40.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 134460
65.3%
Space Separator 35711
 
17.3%
Decimal Number 32001
 
15.5%
Dash Punctuation 1656
 
0.8%
Close Punctuation 974
 
0.5%
Open Punctuation 974
 
0.5%
Other Punctuation 274
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
10905
 
8.1%
10710
 
8.0%
10000
 
7.4%
9980
 
7.4%
9980
 
7.4%
9980
 
7.4%
9980
 
7.4%
7648
 
5.7%
7628
 
5.7%
7392
 
5.5%
Other values (78) 40257
29.9%
Decimal Number
ValueCountFrequency (%)
1 5639
17.6%
2 4209
13.2%
3 3668
11.5%
5 3576
11.2%
8 3446
10.8%
9 2992
9.3%
4 2438
7.6%
7 2071
 
6.5%
0 2029
 
6.3%
6 1933
 
6.0%
Space Separator
ValueCountFrequency (%)
35711
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1656
100.0%
Close Punctuation
ValueCountFrequency (%)
) 974
100.0%
Open Punctuation
ValueCountFrequency (%)
( 974
100.0%
Other Punctuation
ValueCountFrequency (%)
, 274
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 134460
65.3%
Common 71590
34.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
10905
 
8.1%
10710
 
8.0%
10000
 
7.4%
9980
 
7.4%
9980
 
7.4%
9980
 
7.4%
9980
 
7.4%
7648
 
5.7%
7628
 
5.7%
7392
 
5.5%
Other values (78) 40257
29.9%
Common
ValueCountFrequency (%)
35711
49.9%
1 5639
 
7.9%
2 4209
 
5.9%
3 3668
 
5.1%
5 3576
 
5.0%
8 3446
 
4.8%
9 2992
 
4.2%
4 2438
 
3.4%
7 2071
 
2.9%
0 2029
 
2.8%
Other values (5) 5811
 
8.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 134460
65.3%
ASCII 71590
34.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
35711
49.9%
1 5639
 
7.9%
2 4209
 
5.9%
3 3668
 
5.1%
5 3576
 
5.0%
8 3446
 
4.8%
9 2992
 
4.2%
4 2438
 
3.4%
7 2071
 
2.9%
0 2029
 
2.8%
Other values (5) 5811
 
8.1%
Hangul
ValueCountFrequency (%)
10905
 
8.1%
10710
 
8.0%
10000
 
7.4%
9980
 
7.4%
9980
 
7.4%
9980
 
7.4%
9980
 
7.4%
7648
 
5.7%
7628
 
5.7%
7392
 
5.5%
Other values (78) 40257
29.9%

충전기용량
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
7
5456 
50
4544 

Length

Max length2
Median length1
Mean length1.4544
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
7 5456
54.6%
50 4544
45.4%

Length

2023-12-12T18:29:31.200105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:29:31.295719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
7 5456
54.6%
50 4544
45.4%

충전량
Real number (ℝ)

Distinct3933
Distinct (%)39.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.652853
Minimum0.01
Maximum90.64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T18:29:31.427636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.01
5-th percentile2.1
Q19.215
median17.045
Q332.1
95-th percentile53.4
Maximum90.64
Range90.63
Interquartile range (IQR)22.885

Descriptive statistics

Standard deviation16.263723
Coefficient of variation (CV)0.75111224
Kurtosis0.15411375
Mean21.652853
Median Absolute Deviation (MAD)10.055
Skewness0.90326653
Sum216528.53
Variance264.50868
MonotonicityNot monotonic
2023-12-12T18:29:31.622062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.1 102
 
1.0%
11.4 58
 
0.6%
11.3 55
 
0.5%
11.6 45
 
0.4%
11.2 41
 
0.4%
11.5 40
 
0.4%
6.9 38
 
0.4%
7.0 37
 
0.4%
7.1 36
 
0.4%
6.8 34
 
0.3%
Other values (3923) 9514
95.1%
ValueCountFrequency (%)
0.01 15
 
0.1%
0.02 6
 
0.1%
0.03 7
 
0.1%
0.04 9
 
0.1%
0.05 3
 
< 0.1%
0.06 5
 
0.1%
0.07 3
 
< 0.1%
0.08 2
 
< 0.1%
0.09 3
 
< 0.1%
0.1 102
1.0%
ValueCountFrequency (%)
90.64 1
< 0.1%
89.28 1
< 0.1%
87.07 1
< 0.1%
86.1 1
< 0.1%
85.23 1
< 0.1%
84.37 1
< 0.1%
83.0 1
< 0.1%
81.96 1
< 0.1%
80.14 1
< 0.1%
79.95 1
< 0.1%

충전시간
Real number (ℝ)

ZEROS 

Distinct35
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.1508
Minimum0
Maximum77
Zeros3383
Zeros (%)33.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T18:29:31.774511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile8
Maximum77
Range77
Interquartile range (IQR)3

Descriptive statistics

Standard deviation3.1917829
Coefficient of variation (CV)1.483998
Kurtosis50.790257
Mean2.1508
Median Absolute Deviation (MAD)1
Skewness4.4062072
Sum21508
Variance10.187478
MonotonicityNot monotonic
2023-12-12T18:29:31.974048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
0 3383
33.8%
1 2682
26.8%
2 1087
 
10.9%
3 887
 
8.9%
4 423
 
4.2%
5 357
 
3.6%
6 308
 
3.1%
7 258
 
2.6%
8 179
 
1.8%
9 125
 
1.2%
Other values (25) 311
 
3.1%
ValueCountFrequency (%)
0 3383
33.8%
1 2682
26.8%
2 1087
 
10.9%
3 887
 
8.9%
4 423
 
4.2%
5 357
 
3.6%
6 308
 
3.1%
7 258
 
2.6%
8 179
 
1.8%
9 125
 
1.2%
ValueCountFrequency (%)
77 1
< 0.1%
49 1
< 0.1%
48 1
< 0.1%
41 1
< 0.1%
40 1
< 0.1%
34 1
< 0.1%
29 1
< 0.1%
27 1
< 0.1%
26 2
< 0.1%
25 2
< 0.1%

충전분
Real number (ℝ)

ZEROS 

Distinct60
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.7401
Minimum0
Maximum59
Zeros223
Zeros (%)2.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T18:29:32.178700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q113
median29
Q344
95-th percentile56
Maximum59
Range59
Interquartile range (IQR)31

Descriptive statistics

Standard deviation17.617769
Coefficient of variation (CV)0.61300306
Kurtosis-1.2086581
Mean28.7401
Median Absolute Deviation (MAD)15
Skewness-0.0099815419
Sum287401
Variance310.38579
MonotonicityNot monotonic
2023-12-12T18:29:32.383902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 373
 
3.7%
0 223
 
2.2%
2 208
 
2.1%
41 198
 
2.0%
15 197
 
2.0%
43 190
 
1.9%
34 186
 
1.9%
42 180
 
1.8%
39 179
 
1.8%
35 178
 
1.8%
Other values (50) 7888
78.9%
ValueCountFrequency (%)
0 223
2.2%
1 373
3.7%
2 208
2.1%
3 160
1.6%
4 177
1.8%
5 144
 
1.4%
6 139
 
1.4%
7 150
1.5%
8 160
1.6%
9 144
 
1.4%
ValueCountFrequency (%)
59 145
1.5%
58 170
1.7%
57 154
1.5%
56 130
1.3%
55 145
1.5%
54 172
1.7%
53 174
1.7%
52 148
1.5%
51 149
1.5%
50 175
1.8%
Distinct9997
Distinct (%)> 99.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2020-12-31 17:32:36
Maximum2022-03-31 14:28:06
2023-12-12T18:29:32.574775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:32.764250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct9997
Distinct (%)> 99.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 00:22:44
Maximum2022-03-31 15:10:28
2023-12-12T18:29:32.926434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:33.068524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T18:29:28.270413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:27.491532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:27.872927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:28.386723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:27.605797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:27.978689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:28.521368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:27.742474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:29:28.130335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:29:33.168768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전구분충전소명주소충전기용량충전량충전시간충전분
충전구분1.0000.9320.9321.0000.3180.2940.082
충전소명0.9321.0001.0000.9320.3990.3530.230
주소0.9321.0001.0000.9320.3990.3530.230
충전기용량1.0000.9320.9321.0000.3180.2940.082
충전량0.3180.3990.3990.3181.0000.3150.323
충전시간0.2940.3530.3530.2940.3151.0000.044
충전분0.0820.2300.2300.0820.3230.0441.000
2023-12-12T18:29:33.262273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전기용량충전구분
충전기용량1.0001.000
충전구분1.0001.000
2023-12-12T18:29:33.349916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전량충전시간충전분충전구분충전기용량
충전량1.0000.3520.1600.2430.243
충전시간0.3521.000-0.0800.2210.221
충전분0.160-0.0801.0000.0630.063
충전구분0.2430.2210.0631.0001.000
충전기용량0.2430.2210.0631.0001.000

Missing values

2023-12-12T18:29:28.685186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:29:29.168465image/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

충전구분충전소명주소충전기용량충전량충전시간충전분충전시작시각충전종료시각
33314완속레이크팰리스서울특별시 송파구 잠실동 잠실로 8876.010532021-06-19 13:26:212021-06-19 14:20:07
16820완속레이크팰리스서울특별시 송파구 잠실동 잠실로 88714.922102021-03-25 19:14:232021-03-25 21:25:09
43660급속현대백화점 천호점서울특별시 강동구 천호대로 10055016.50252021-08-05 18:57:302021-08-05 19:22:42
74260완속갤러리아팰리스서울특별시 송파구 잠실동 4079.27882021-12-08 23:40:512021-12-09 07:49:22
14409완속송파파크데일2단지서울특별시 송파구 마천동 성내천로47길 38712.63502021-03-12 16:09:162021-03-12 19:59:16
38083급속홈플러스 강동점서울특별시 강동구 양재대로 15715020.250472021-07-10 21:16:072021-07-10 22:03:14
47861급속명일동 공영주차장서울특별시 강동구 구천면로 395(명일동)5013.440172021-08-23 10:01:372021-08-23 10:19:18
13999완속강일리버파크3단지서울특별시 강동구 강일동 아리수로93길 40747.07562021-03-09 23:25:332021-03-10 07:22:06
36170급속홈플러스 강동점서울특별시 강동구 양재대로 15715013.60202021-07-02 13:05:502021-07-02 13:26:07
72993완속송파꿈에그린(위례24단지)서울특별시 송파구 장지동 516712.01542021-12-04 17:07:542021-12-04 19:01:59
충전구분충전소명주소충전기용량충전량충전시간충전분충전시작시각충전종료시각
64442완속성내삼성 아파트서울특별시 강동구 성내동 풍성로 128726.7492021-11-02 19:05:392021-11-02 23:15:37
1334완속동서울 전력지사경기도 하남시 감북로 80738.236292021-01-07 17:25:022021-01-07 23:54:19
9254완속갤러리아팰리스서울특별시 송파구 잠실동 4070.11012021-02-10 09:47:122021-02-10 09:48:19
69086완속거여5단지 아파트서울특별시 송파구 거여동 양산로4길 16713.5282021-11-20 09:57:162021-11-20 12:06:00
37769완속문정래미안아파트서울특별시 송파구 문정동 문정로 8377.8110422021-07-08 20:25:502021-07-09 07:08:48
40046완속송파파크데일1단지 아파트서울특별시 송파구 마천동 성내천로37길 37717.872432021-07-19 23:11:562021-07-20 01:55:03
62496급속더샵스타리버 아파트서울특별시 송파구 올림픽로35길 935053.61392021-10-25 21:42:432021-10-25 23:21:55
12139급속강동송파지사서울특별시 강동구 둔촌동 522-95017.540402021-02-27 13:47:112021-02-27 14:28:08
40534급속강동송파지사서울특별시 강동구 둔촌동 522-95012.80422021-07-22 20:57:422021-07-22 21:39:53
50596완속문정래미안아파트서울특별시 송파구 문정동 문정로 8374.080352021-09-04 14:00:172021-09-04 14:35:28