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

Categorical9
DateTime1
Numeric3

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/de4944e8-dc08-497b-8e95-26ccd81d2c71

Alerts

차량_번호 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
SOC is highly overall correlated with 공급_전압 and 1 other fieldsHigh correlation
공급_전압 is highly overall correlated with SOCHigh correlation
공급_전류 is highly overall correlated with SOCHigh correlation
충전_일시 has unique valuesUnique

Reproduction

Analysis started2023-12-10 14:01:22.250276
Analysis finished2023-12-10 14:01:24.093401
Duration1.84 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

차량_번호
Categorical

CONSTANT 

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

Length

Max length64
Median length64
Mean length64
Min length64

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f 30
100.0%

Length

2023-12-10T23:01:24.190027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:24.317820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f 30
100.0%

충전_일시
Date

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2022-01-01 00:00:45
Maximum2022-01-27 14:25:00
2023-12-10T23:01:24.475274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:24.638990image/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
HYD
30 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
HYD 30
100.0%

Length

2023-12-10T23:01:24.805531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:24.910143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
hyd 30
100.0%

차량_모델
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
ELEC-CITY-326
30 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowELEC-CITY-326
2nd rowELEC-CITY-326
3rd rowELEC-CITY-326
4th rowELEC-CITY-326
5th rowELEC-CITY-326

Common Values

ValueCountFrequency (%)
ELEC-CITY-326 30
100.0%

Length

2023-12-10T23:01:25.031817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:25.156303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
elec-city-326 30
100.0%

출고_일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2019-10-28
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019-10-28
2nd row2019-10-28
3rd row2019-10-28
4th row2019-10-28
5th row2019-10-28

Common Values

ValueCountFrequency (%)
2019-10-28 30
100.0%

Length

2023-12-10T23:01:25.302118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:25.447006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-10-28 30
100.0%

배터리_용량
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
256 30
100.0%

Length

2023-12-10T23:01:25.998080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:26.161259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
256 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-10T23:01:26.356989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:26.522954image/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
1
30 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 30
100.0%

Length

2023-12-10T23:01:26.668220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:26.909248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 30
100.0%

SOC
Real number (ℝ)

HIGH CORRELATION 

Distinct19
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean79.366667
Minimum38
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:01:27.092955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum38
5-th percentile57
Q165.75
median83
Q390
95-th percentile99.55
Maximum100
Range62
Interquartile range (IQR)24.25

Descriptive statistics

Standard deviation15.475193
Coefficient of variation (CV)0.19498354
Kurtosis0.094388955
Mean79.366667
Median Absolute Deviation (MAD)8
Skewness-0.77446075
Sum2381
Variance239.48161
MonotonicityNot monotonic
2023-12-10T23:01:27.306909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
91 3
 
10.0%
90 3
 
10.0%
57 2
 
6.7%
87 2
 
6.7%
63 2
 
6.7%
100 2
 
6.7%
88 2
 
6.7%
83 2
 
6.7%
75 2
 
6.7%
68 1
 
3.3%
Other values (9) 9
30.0%
ValueCountFrequency (%)
38 1
3.3%
57 2
6.7%
58 1
3.3%
63 2
6.7%
64 1
3.3%
65 1
3.3%
68 1
3.3%
75 2
6.7%
79 1
3.3%
81 1
3.3%
ValueCountFrequency (%)
100 2
6.7%
99 1
 
3.3%
98 1
 
3.3%
91 3
10.0%
90 3
10.0%
88 2
6.7%
87 2
6.7%
83 2
6.7%
82 1
 
3.3%
81 1
 
3.3%

공급_전압
Real number (ℝ)

HIGH CORRELATION 

Distinct27
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean736.73333
Minimum97
Maximum816
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:01:27.499598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum97
5-th percentile392.3
Q1762
median781.5
Q3794.75
95-th percentile810.05
Maximum816
Range719
Interquartile range (IQR)32.75

Descriptive statistics

Standard deviation173.58093
Coefficient of variation (CV)0.2356089
Kurtosis11.848687
Mean736.73333
Median Absolute Deviation (MAD)15.5
Skewness-3.5855064
Sum22102
Variance30130.34
MonotonicityNot monotonic
2023-12-10T23:01:27.729703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
759 2
 
6.7%
802 2
 
6.7%
804 2
 
6.7%
816 1
 
3.3%
741 1
 
3.3%
799 1
 
3.3%
783 1
 
3.3%
786 1
 
3.3%
770 1
 
3.3%
777 1
 
3.3%
Other values (17) 17
56.7%
ValueCountFrequency (%)
97 1
3.3%
107 1
3.3%
741 1
3.3%
748 1
3.3%
758 1
3.3%
759 2
6.7%
760 1
3.3%
768 1
3.3%
769 1
3.3%
770 1
3.3%
ValueCountFrequency (%)
816 1
3.3%
815 1
3.3%
804 2
6.7%
802 2
6.7%
799 1
3.3%
795 1
3.3%
794 1
3.3%
793 1
3.3%
791 1
3.3%
787 1
3.3%

공급_전류
Real number (ℝ)

HIGH CORRELATION 

Distinct13
Distinct (%)43.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean95.866667
Minimum8
Maximum149
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:01:27.904088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8
5-th percentile30.6
Q158.25
median113
Q3145.25
95-th percentile149
Maximum149
Range141
Interquartile range (IQR)87

Descriptive statistics

Standard deviation44.888931
Coefficient of variation (CV)0.46824337
Kurtosis-1.1862136
Mean95.866667
Median Absolute Deviation (MAD)36
Skewness-0.24261172
Sum2876
Variance2015.0161
MonotonicityNot monotonic
2023-12-10T23:01:28.072162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
149 8
26.7%
59 4
13.3%
58 3
 
10.0%
57 3
 
10.0%
114 2
 
6.7%
118 2
 
6.7%
67 2
 
6.7%
9 1
 
3.3%
117 1
 
3.3%
134 1
 
3.3%
Other values (3) 3
 
10.0%
ValueCountFrequency (%)
8 1
 
3.3%
9 1
 
3.3%
57 3
10.0%
58 3
10.0%
59 4
13.3%
67 2
6.7%
112 1
 
3.3%
114 2
6.7%
117 1
 
3.3%
118 2
6.7%
ValueCountFrequency (%)
149 8
26.7%
134 1
 
3.3%
125 1
 
3.3%
118 2
 
6.7%
117 1
 
3.3%
114 2
 
6.7%
112 1
 
3.3%
67 2
 
6.7%
59 4
13.3%
58 3
 
10.0%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2022-10-04 전기차 배터리 상태 이력
30 

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-10-04 전기차 배터리 상태 이력
2nd row2022-10-04 전기차 배터리 상태 이력
3rd row2022-10-04 전기차 배터리 상태 이력
4th row2022-10-04 전기차 배터리 상태 이력
5th row2022-10-04 전기차 배터리 상태 이력

Common Values

ValueCountFrequency (%)
2022-10-04 전기차 배터리 상태 이력 30
100.0%

Length

2023-12-10T23:01:28.285405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:28.433896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-10-04 30
20.0%
전기차 30
20.0%
배터리 30
20.0%
상태 30
20.0%
이력 30
20.0%

생산_일시
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2022-10-04 11:29:17
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-10-04 11:29:17
2nd row2022-10-04 11:29:17
3rd row2022-10-04 11:29:17
4th row2022-10-04 11:29:17
5th row2022-10-04 11:29:17

Common Values

ValueCountFrequency (%)
2022-10-04 11:29:17 30
100.0%

Length

2023-12-10T23:01:28.579834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:01:28.730133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-10-04 30
50.0%
11:29:17 30
50.0%

Interactions

2023-12-10T23:01:23.329870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:22.512555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:22.945137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:23.458585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:22.652061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:23.080324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:23.592348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:22.802162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:01:23.199567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:01:28.828621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전_일시SOC공급_전압공급_전류
충전_일시1.0001.0001.0001.000
SOC1.0001.0000.4600.775
공급_전압1.0000.4601.0000.936
공급_전류1.0000.7750.9361.000
2023-12-10T23:01:28.969582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SOC공급_전압공급_전류
SOC1.0000.587-0.704
공급_전압0.5871.000-0.216
공급_전류-0.704-0.2161.000

Missing values

2023-12-10T23:01:23.774866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:01:23.998204image/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공급_전압공급_전류비고생산_일시
0009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-04 19:49:23HYDELEC-CITY-3262019-10-2825601998161142022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
1009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 09:52:45HYDELEC-CITY-3262019-10-282560181780582022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
2009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 00:00:45HYDELEC-CITY-3262019-10-2825601577591492022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
3009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-26 00:10:59HYDELEC-CITY-3262019-10-2825601877931182022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
4009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 00:07:39HYDELEC-CITY-3262019-10-2825601637681492022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
5009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-04 19:48:23HYDELEC-CITY-3262019-10-2825601988151142022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
6009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 09:53:45HYDELEC-CITY-3262019-10-282560182781572022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
7009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-04 19:50:03HYDELEC-CITY-3262019-10-28256011009792022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
8009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 00:00:46HYDELEC-CITY-3262019-10-2825601577581492022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
9009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-27 14:23:57HYDELEC-CITY-3262019-10-282560190802592022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
차량_번호충전_일시차량_제조사차량_모델출고_일자배터리_용량배터리_전압배터리_팩_수SOC공급_전압공급_전류비고생산_일시
20009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-20 00:42:00HYDELEC-CITY-3262019-10-282560110010782022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
21009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 00:01:39HYDELEC-CITY-3262019-10-2825601587601492022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
22009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-27 14:22:57HYDELEC-CITY-3262019-10-282560190802592022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
23009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-26 00:13:02HYDELEC-CITY-3262019-10-2825601887951182022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
24009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-27 14:25:00HYDELEC-CITY-3262019-10-282560191804592022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
25009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 09:48:44HYDELEC-CITY-3262019-10-282560179777672022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
26009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 00:09:39HYDELEC-CITY-3262019-10-2825601657701492022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
27009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 00:20:40HYDELEC-CITY-3262019-10-2825601757861492022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
28009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 09:55:45HYDELEC-CITY-3262019-10-282560183783572022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17
29009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2022-01-01 12:36:50HYDELEC-CITY-3262019-10-282560190799582022-10-04 전기차 배터리 상태 이력2022-10-04 11:29:17