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/15ff4c22-5c51-48b0-b051-069f2533cfe6

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 공급_전압High correlation
공급_전압 is highly overall correlated with SOCHigh correlation
충전_일시 has unique valuesUnique
공급_전류 has 2 (6.7%) zerosZeros

Reproduction

Analysis started2023-12-10 13:45:54.045925
Analysis finished2023-12-10 13:45:56.562273
Duration2.52 seconds
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-10T22:45:56.659049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:45:56.814595image/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
Minimum2023-01-02 00:15:38
Maximum2023-01-31 10:41:55
2023-12-10T22:45:56.969909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:57.160532image/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-10T22:45:57.364119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:45:57.538827image/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-10T22:45:57.793439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:45:57.943947image/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-10T22:45:58.099682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:45:58.235664image/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-10T22:45:58.381178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:45:58.522024image/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-10T22:45:58.718952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:45:58.881638image/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-10T22:45:59.060184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

SOC
Real number (ℝ)

HIGH CORRELATION 

Distinct23
Distinct (%)76.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean78.933333
Minimum38
Maximum96
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:45:59.419093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum38
5-th percentile59.25
Q174.75
median82.5
Q386.5
95-th percentile94.55
Maximum96
Range58
Interquartile range (IQR)11.75

Descriptive statistics

Standard deviation12.808761
Coefficient of variation (CV)0.16227316
Kurtosis2.2495076
Mean78.933333
Median Absolute Deviation (MAD)5.5
Skewness-1.3334215
Sum2368
Variance164.06437
MonotonicityNot monotonic
2023-12-10T22:45:59.688705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
84 3
 
10.0%
82 2
 
6.7%
83 2
 
6.7%
65 2
 
6.7%
88 2
 
6.7%
85 2
 
6.7%
38 1
 
3.3%
94 1
 
3.3%
64 1
 
3.3%
66 1
 
3.3%
Other values (13) 13
43.3%
ValueCountFrequency (%)
38 1
3.3%
57 1
3.3%
62 1
3.3%
64 1
3.3%
65 2
6.7%
66 1
3.3%
74 1
3.3%
77 1
3.3%
78 1
3.3%
79 1
3.3%
ValueCountFrequency (%)
96 1
 
3.3%
95 1
 
3.3%
94 1
 
3.3%
92 1
 
3.3%
90 1
 
3.3%
88 2
6.7%
87 1
 
3.3%
85 2
6.7%
84 3
10.0%
83 2
6.7%

공급_전압
Real number (ℝ)

HIGH CORRELATION 

Distinct26
Distinct (%)86.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean754.63333
Minimum2
Maximum817
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:45:59.895341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile719.45
Q1771.25
median785.5
Q3793
95-th percentile807.2
Maximum817
Range815
Interquartile range (IQR)21.75

Descriptive statistics

Standard deviation143.92083
Coefficient of variation (CV)0.19071624
Kurtosis28.393967
Mean754.63333
Median Absolute Deviation (MAD)10.5
Skewness-5.2684719
Sum22639
Variance20713.206
MonotonicityNot monotonic
2023-12-10T22:46:00.131895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
793 2
 
6.7%
780 2
 
6.7%
792 2
 
6.7%
796 2
 
6.7%
777 1
 
3.3%
801 1
 
3.3%
809 1
 
3.3%
764 1
 
3.3%
771 1
 
3.3%
789 1
 
3.3%
Other values (16) 16
53.3%
ValueCountFrequency (%)
2 1
3.3%
719 1
3.3%
720 1
3.3%
742 1
3.3%
761 1
3.3%
764 1
3.3%
768 1
3.3%
771 1
3.3%
772 1
3.3%
773 1
3.3%
ValueCountFrequency (%)
817 1
3.3%
809 1
3.3%
805 1
3.3%
801 1
3.3%
796 2
6.7%
794 1
3.3%
793 2
6.7%
792 2
6.7%
791 1
3.3%
790 1
3.3%

공급_전류
Real number (ℝ)

ZEROS 

Distinct19
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean92.666667
Minimum0
Maximum149
Zeros2
Zeros (%)6.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:46:00.444733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile26.1
Q161
median109
Q3116.75
95-th percentile133.1
Maximum149
Range149
Interquartile range (IQR)55.75

Descriptive statistics

Standard deviation36.730457
Coefficient of variation (CV)0.39637183
Kurtosis0.77854324
Mean92.666667
Median Absolute Deviation (MAD)20.5
Skewness-1.0059271
Sum2780
Variance1349.1264
MonotonicityNot monotonic
2023-12-10T22:46:00.645198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
113 5
16.7%
59 3
 
10.0%
124 3
 
10.0%
0 2
 
6.7%
58 2
 
6.7%
116 2
 
6.7%
77 1
 
3.3%
87 1
 
3.3%
118 1
 
3.3%
105 1
 
3.3%
Other values (9) 9
30.0%
ValueCountFrequency (%)
0 2
6.7%
58 2
6.7%
59 3
10.0%
60 1
 
3.3%
64 1
 
3.3%
77 1
 
3.3%
87 1
 
3.3%
88 1
 
3.3%
89 1
 
3.3%
98 1
 
3.3%
ValueCountFrequency (%)
149 1
 
3.3%
134 1
 
3.3%
132 1
 
3.3%
124 3
10.0%
118 1
 
3.3%
117 1
 
3.3%
116 2
 
6.7%
113 5
16.7%
105 1
 
3.3%
98 1
 
3.3%

비고
Categorical

CONSTANT 

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

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

2023-12-10T22:46:01.024470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-04-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
2023-04-04 17:43:51
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-04-04 17:43:51
2nd row2023-04-04 17:43:51
3rd row2023-04-04 17:43:51
4th row2023-04-04 17:43:51
5th row2023-04-04 17:43:51

Common Values

ValueCountFrequency (%)
2023-04-04 17:43:51 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:46:01.463290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-04-04 30
50.0%
17:43:51 30
50.0%

Interactions

2023-12-10T22:45:55.630640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:54.417574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:54.977501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:55.775450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:54.586663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:55.228122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:55.920639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:54.767865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:45:55.456947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:46:01.581481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전_일시SOC공급_전압공급_전류
충전_일시1.0001.0001.0001.000
SOC1.0001.0000.7760.748
공급_전압1.0000.7761.0000.793
공급_전류1.0000.7480.7931.000
2023-12-10T22:46:01.751719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SOC공급_전압공급_전류
SOC1.0000.683-0.197
공급_전압0.6831.0000.003
공급_전류-0.1970.0031.000

Missing values

2023-12-10T22:45:56.124238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:45:56.443490image/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공급_전압공급_전류비고생산_일시
0009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-05 08:35:21HYDELEC-CITY-3262019-10-2825601827771132023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
1009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-16 15:11:20HYDELEC-CITY-3262019-10-2825601857851162023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
2009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-05 22:34:02HYDELEC-CITY-3262019-10-282560185793602023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
3009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-05 08:36:54HYDELEC-CITY-3262019-10-2825601837801132023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
4009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-24 19:06:40HYDELEC-CITY-3262019-10-282560190805592023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
5009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-02 17:59:01HYDELEC-CITY-3262019-10-28256015771902023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
6009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-05 16:52:50HYDELEC-CITY-3262019-10-2825601747861242023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
7009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-02 10:19:07HYDELEC-CITY-3262019-10-282560195202023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
8009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-05 02:00:19HYDELEC-CITY-3262019-10-2825601968171162023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
9009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-02 00:15:38HYDELEC-CITY-3262019-10-2825601657721242023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
차량_번호충전_일시차량_제조사차량_모델출고_일자배터리_용량배터리_전압배터리_팩_수SOC공급_전압공급_전류비고생산_일시
20009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-04 08:48:39HYDELEC-CITY-3262019-10-282560178768772023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
21009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-31 10:41:55HYDELEC-CITY-3262019-10-282560180796882023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
22009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-05 08:37:25HYDELEC-CITY-3262019-10-2825601847801132023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
23009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-05 08:45:41HYDELEC-CITY-3262019-10-2825601887901132023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
24009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-29 08:55:57HYDELEC-CITY-3262019-10-282560184789582023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
25009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-23 19:35:15HYDELEC-CITY-3262019-10-282560181792892023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
26009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-21 00:18:42HYDELEC-CITY-3262019-10-2825601667711242023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
27009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-25 10:18:51HYDELEC-CITY-3262019-10-2825601647641052023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
28009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-21 00:38:01HYDELEC-CITY-3262019-10-2825601847931182023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51
29009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-01-02 00:49:40HYDELEC-CITY-3262019-10-282560194809872023-04-04 전기차 배터리 상태 이력2023-04-04 17:43:51