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/d0754d65-fc4d-4165-b6d5-9906f9665e4a

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 14:08:14.528138
Analysis finished2023-12-10 14:08:16.774281
Duration2.25 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-10T23:08:17.193518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:08:17.400072image/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-04-03 11:01:40
Maximum2023-04-09 10:39:18
2023-12-10T23:08:17.694880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:17.954408image/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:08:18.270622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:08:18.581772image/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:08:18.833429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:08:19.041923image/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:08:19.301796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:08:19.454503image/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:08:19.722836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:08:19.868645image/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:08:20.019434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:08:20.182140image/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:08:20.343712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:08:20.512522image/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%
Mean84.533333
Minimum54
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:08:20.742147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum54
5-th percentile74
Q175
median86.5
Q392.75
95-th percentile97
Maximum100
Range46
Interquartile range (IQR)17.75

Descriptive statistics

Standard deviation10.28133
Coefficient of variation (CV)0.12162457
Kurtosis0.91938064
Mean84.533333
Median Absolute Deviation (MAD)8.5
Skewness-0.79723105
Sum2536
Variance105.70575
MonotonicityNot monotonic
2023-12-10T23:08:20.948853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
74 4
13.3%
75 4
13.3%
90 2
 
6.7%
88 2
 
6.7%
95 2
 
6.7%
86 2
 
6.7%
97 2
 
6.7%
94 1
 
3.3%
92 1
 
3.3%
79 1
 
3.3%
Other values (9) 9
30.0%
ValueCountFrequency (%)
54 1
 
3.3%
74 4
13.3%
75 4
13.3%
77 1
 
3.3%
79 1
 
3.3%
82 1
 
3.3%
85 1
 
3.3%
86 2
6.7%
87 1
 
3.3%
88 2
6.7%
ValueCountFrequency (%)
100 1
3.3%
97 2
6.7%
96 1
3.3%
95 2
6.7%
94 1
3.3%
93 1
3.3%
92 1
3.3%
90 2
6.7%
89 1
3.3%
88 2
6.7%

공급_전압
Real number (ℝ)

HIGH CORRELATION 

Distinct24
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean732.73333
Minimum1
Maximum809
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:08:21.130733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile348.45
Q1769.25
median790
Q3799
95-th percentile806.55
Maximum809
Range808
Interquartile range (IQR)29.75

Descriptive statistics

Standard deviation196.79605
Coefficient of variation (CV)0.26857799
Kurtosis11.91606
Mean732.73333
Median Absolute Deviation (MAD)14.5
Skewness-3.5988693
Sum21982
Variance38728.685
MonotonicityNot monotonic
2023-12-10T23:08:21.321736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
790 3
 
10.0%
805 2
 
6.7%
792 2
 
6.7%
745 2
 
6.7%
794 2
 
6.7%
809 1
 
3.3%
778 1
 
3.3%
1 1
 
3.3%
804 1
 
3.3%
24 1
 
3.3%
Other values (14) 14
46.7%
ValueCountFrequency (%)
1 1
3.3%
24 1
3.3%
745 2
6.7%
746 1
3.3%
750 1
3.3%
751 1
3.3%
768 1
3.3%
773 1
3.3%
775 1
3.3%
778 1
3.3%
ValueCountFrequency (%)
809 1
3.3%
807 1
3.3%
806 1
3.3%
805 2
6.7%
804 1
3.3%
801 1
3.3%
800 1
3.3%
796 1
3.3%
794 2
6.7%
792 2
6.7%

공급_전류
Real number (ℝ)

ZEROS 

Distinct17
Distinct (%)56.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean70.333333
Minimum0
Maximum127
Zeros2
Zeros (%)6.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:08:21.538673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.9
Q151
median65.5
Q3117
95-th percentile124
Maximum127
Range127
Interquartile range (IQR)66

Descriptive statistics

Standard deviation45.967255
Coefficient of variation (CV)0.65356286
Kurtosis-1.2806753
Mean70.333333
Median Absolute Deviation (MAD)51.5
Skewness-0.3256994
Sum2110
Variance2112.9885
MonotonicityNot monotonic
2023-12-10T23:08:21.759788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
58 4
13.3%
57 3
10.0%
124 3
10.0%
4 2
 
6.7%
119 2
 
6.7%
0 2
 
6.7%
105 2
 
6.7%
117 2
 
6.7%
73 2
 
6.7%
3 1
 
3.3%
Other values (7) 7
23.3%
ValueCountFrequency (%)
0 2
6.7%
2 1
 
3.3%
3 1
 
3.3%
4 2
6.7%
5 1
 
3.3%
49 1
 
3.3%
57 3
10.0%
58 4
13.3%
73 2
6.7%
86 1
 
3.3%
ValueCountFrequency (%)
127 1
 
3.3%
124 3
10.0%
123 1
 
3.3%
119 2
6.7%
117 2
6.7%
105 2
6.7%
104 1
 
3.3%
86 1
 
3.3%
73 2
6.7%
58 4
13.3%

비고
Categorical

CONSTANT 

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

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

2023-12-10T23:08:22.128720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-05 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-07-05 12:11:37
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-05 12:11:37
2nd row2023-07-05 12:11:37
3rd row2023-07-05 12:11:37
4th row2023-07-05 12:11:37
5th row2023-07-05 12:11:37

Common Values

ValueCountFrequency (%)
2023-07-05 12:11:37 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:08:22.437825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-05 30
50.0%
12:11:37 30
50.0%

Interactions

2023-12-10T23:08:15.706655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:14.819551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:15.227594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:15.825822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:14.956889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:15.369530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:16.087218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:15.101915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:08:15.547489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:08:22.536662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전_일시SOC공급_전압공급_전류
충전_일시1.0001.0001.0001.000
SOC1.0001.0000.0000.715
공급_전압1.0000.0001.0000.195
공급_전류1.0000.7150.1951.000
2023-12-10T23:08:22.695012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SOC공급_전압공급_전류
SOC1.0000.615-0.149
공급_전압0.6151.0000.324
공급_전류-0.1490.3241.000

Missing values

2023-12-10T23:08:16.339143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:08:16.671544image/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-04-04 10:31:26HYDELEC-CITY-3262019-10-28256017474642023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
1009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 11:04:39HYDELEC-CITY-3262019-10-2825601857941052023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
2009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 16:26:21HYDELEC-CITY-3262019-10-28256017475142023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
3009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 19:54:12HYDELEC-CITY-3262019-10-282560197805732023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
4009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 11:16:20HYDELEC-CITY-3262019-10-282560192801572023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
5009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-04 10:32:05HYDELEC-CITY-3262019-10-2825601757681242023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
6009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-04 10:50:23HYDELEC-CITY-3262019-10-282560190792582023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
7009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-09 10:39:18HYDELEC-CITY-3262019-10-282560194806582023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
8009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 16:26:20HYDELEC-CITY-3262019-10-28256017475022023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
9009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 16:26:18HYDELEC-CITY-3262019-10-2825601958071192023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
차량_번호충전_일시차량_제조사차량_모델출고_일자배터리_용량배터리_전압배터리_팩_수SOC공급_전압공급_전류비고생산_일시
20009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 19:36:07HYDELEC-CITY-3262019-10-282560188792492023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
21009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 22:10:30HYDELEC-CITY-3262019-10-28256018677352023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
22009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 19:54:20HYDELEC-CITY-3262019-10-282560197805732023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
23009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-06 17:59:49HYDELEC-CITY-3262019-10-2825601547451232023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
24009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 22:10:08HYDELEC-CITY-3262019-10-28256011002402023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
25009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-05 07:42:46HYDELEC-CITY-3262019-10-282560189790572023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
26009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 11:17:20HYDELEC-CITY-3262019-10-282560193804582023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
27009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-03 19:26:07HYDELEC-CITY-3262019-10-282560195102023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
28009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-04 10:48:21HYDELEC-CITY-3262019-10-282560188790572023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37
29009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-04-06 09:56:25HYDELEC-CITY-3262019-10-2825601757781042023-07-05 전기차 배터리 상태 이력2023-07-05 12:11:37