Overview

Dataset statistics

Number of variables4
Number of observations6515
Missing cells0
Missing cells (%)0.0%
Duplicate rows498
Duplicate rows (%)7.6%
Total size in memory210.1 KiB
Average record size in memory33.0 B

Variable types

DateTime3
Numeric1

Dataset

Description한국상하수도협회 급속충전시설 이용내역 : 해당 데이터는 한국상하수도협회 충전시설의 충전시작일시, 충전종료일시, 충전시간, 충전량 데이터 입니다.
URLhttps://www.data.go.kr/data/15120301/fileData.do

Alerts

Dataset has 498 (7.6%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 10:28:33.119087
Analysis finished2023-12-12 10:28:33.646534
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

충전시작일시
Date

Distinct6017
Distinct (%)92.4%
Missing0
Missing (%)0.0%
Memory size51.0 KiB
Minimum2021-04-30 12:21:00
Maximum2022-11-30 23:07:00
2023-12-12T19:28:33.732534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:28:33.893183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

충전종료일시
Date

Distinct6017
Distinct (%)92.4%
Missing0
Missing (%)0.0%
Memory size51.0 KiB
Minimum2021-04-30 12:22:00
Maximum2022-11-30 23:47:00
2023-12-12T19:28:34.025479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:28:34.182531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

충전시간
Date

Distinct1549
Distinct (%)23.8%
Missing0
Missing (%)0.0%
Memory size51.0 KiB
Minimum2023-12-12 00:00:16
Maximum2023-12-12 00:40:00
2023-12-12T19:28:34.375379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:28:34.541334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

충전량(kWh)
Real number (ℝ)

Distinct3068
Distinct (%)47.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.64198
Minimum0.11
Maximum54.19
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size57.4 KiB
2023-12-12T19:28:35.008874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.11
5-th percentile2.96
Q19.12
median17.2
Q327.28
95-th percentile38.586
Maximum54.19
Range54.08
Interquartile range (IQR)18.16

Descriptive statistics

Standard deviation11.25371
Coefficient of variation (CV)0.60367566
Kurtosis-0.70093037
Mean18.64198
Median Absolute Deviation (MAD)8.8
Skewness0.42208699
Sum121452.5
Variance126.64598
MonotonicityNot monotonic
2023-12-12T19:28:35.170346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
12.94 19
 
0.3%
17.28 17
 
0.3%
19.41 17
 
0.3%
14.4 16
 
0.2%
5.76 14
 
0.2%
19.42 13
 
0.2%
8.64 12
 
0.2%
11.52 11
 
0.2%
9.7 10
 
0.2%
9.71 10
 
0.2%
Other values (3058) 6376
97.9%
ValueCountFrequency (%)
0.11 2
< 0.1%
0.13 1
< 0.1%
0.15 2
< 0.1%
0.16 1
< 0.1%
0.17 1
< 0.1%
0.2 1
< 0.1%
0.25 2
< 0.1%
0.27 1
< 0.1%
0.28 1
< 0.1%
0.32 1
< 0.1%
ValueCountFrequency (%)
54.19 1
< 0.1%
54.16 1
< 0.1%
54.08 1
< 0.1%
53.33 1
< 0.1%
50.82 1
< 0.1%
50.79 1
< 0.1%
50.77 1
< 0.1%
50.73 1
< 0.1%
50.71 1
< 0.1%
50.7 1
< 0.1%

Interactions

2023-12-12T19:28:33.374587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T19:28:33.502683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:28:33.602738image/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

충전시작일시충전종료일시충전시간충전량(kWh)
02021-04-30 12:212021-04-30 12:2200:01:040.39
12021-04-30 12:242021-04-30 12:2900:05:352.0
22021-05-05 10:142021-05-05 10:3100:16:567.19
32021-05-06 9:592021-05-06 10:3500:35:3810.78
42021-05-05 23:132021-05-05 23:2300:09:547.14
52021-05-26 18:092021-05-26 18:4900:40:0048.44
62021-05-25 10:092021-05-25 10:4900:40:005.5
72021-05-26 16:322021-05-26 17:0400:32:339.31
82021-05-26 18:542021-05-26 19:1800:23:3420.03
92021-05-26 14:422021-05-26 15:0700:25:2524.99
충전시작일시충전종료일시충전시간충전량(kWh)
65052022-11-29 13:272022-11-29 13:5600:28:514.14
65062022-11-29 20:322022-11-29 20:5800:25:5812.19
65072022-11-29 21:002022-11-29 21:4000:40:0011.72
65082022-11-29 16:082022-11-29 16:4800:40:0030.07
65092022-11-29 19:522022-11-29 20:2900:36:5730.35
65102022-11-29 17:412022-11-29 18:2100:39:306.56
65112022-11-29 9:542022-11-29 10:3400:40:0021.02
65122022-11-29 22:222022-11-29 23:0200:39:5526.1
65132022-11-29 12:562022-11-29 13:2500:29:1510.46
65142022-11-29 17:002022-11-29 17:4000:40:0022.91

Duplicate rows

Most frequently occurring

충전시작일시충전종료일시충전시간충전량(kWh)# duplicates
02022-11-01 11:142022-11-01 11:5400:40:0028.532
12022-11-01 12:142022-11-01 12:5400:40:0030.152
22022-11-01 13:152022-11-01 13:5500:40:0018.332
32022-11-01 13:582022-11-01 14:0600:07:561.432
42022-11-01 14:082022-11-01 14:3800:30:286.412
52022-11-01 16:152022-11-01 16:5500:40:0021.612
62022-11-01 16:582022-11-01 17:3800:40:0015.922
72022-11-01 17:452022-11-01 18:1100:25:5623.342
82022-11-01 18:342022-11-01 19:1400:40:0017.852
92022-11-01 19:422022-11-01 20:1800:35:2231.682