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/e7e9163c-5434-4a7d-90fc-fcfbd27bd7d8

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
충전_일시 has unique valuesUnique
공급_전압 has 2 (6.7%) zerosZeros
공급_전류 has 4 (13.3%) zerosZeros

Reproduction

Analysis started2023-12-10 14:03:14.068945
Analysis finished2023-12-10 14:03:16.444197
Duration2.38 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:03:16.565873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:03:16.765307image/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-07-01 09:00:24
Maximum2023-07-09 16:17:19
2023-12-10T23:03:16.944711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:17.150982image/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:03:17.341410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

SOC
Real number (ℝ)

Distinct14
Distinct (%)46.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean91.2
Minimum58
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:03:19.265935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum58
5-th percentile74
Q189.25
median92
Q397
95-th percentile98.55
Maximum100
Range42
Interquartile range (IQR)7.75

Descriptive statistics

Standard deviation9.075925
Coefficient of variation (CV)0.099516721
Kurtosis7.3648857
Mean91.2
Median Absolute Deviation (MAD)3.5
Skewness-2.5493953
Sum2736
Variance82.372414
MonotonicityNot monotonic
2023-12-10T23:03:19.443743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
95 5
16.7%
98 5
16.7%
91 3
10.0%
92 3
10.0%
97 2
 
6.7%
88 2
 
6.7%
90 2
 
6.7%
89 2
 
6.7%
99 1
 
3.3%
87 1
 
3.3%
Other values (4) 4
13.3%
ValueCountFrequency (%)
58 1
 
3.3%
65 1
 
3.3%
85 1
 
3.3%
87 1
 
3.3%
88 2
 
6.7%
89 2
 
6.7%
90 2
 
6.7%
91 3
10.0%
92 3
10.0%
95 5
16.7%
ValueCountFrequency (%)
100 1
 
3.3%
99 1
 
3.3%
98 5
16.7%
97 2
 
6.7%
95 5
16.7%
92 3
10.0%
91 3
10.0%
90 2
 
6.7%
89 2
 
6.7%
88 2
 
6.7%

공급_전압
Real number (ℝ)

ZEROS 

Distinct21
Distinct (%)70.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean653.76667
Minimum0
Maximum812
Zeros2
Zeros (%)6.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:03:19.610614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.45
Q1769.5
median793
Q3797
95-th percentile804.1
Maximum812
Range812
Interquartile range (IQR)27.5

Descriptive statistics

Standard deviation291.33245
Coefficient of variation (CV)0.44562146
Kurtosis1.4016829
Mean653.76667
Median Absolute Deviation (MAD)6
Skewness-1.7838339
Sum19613
Variance84874.599
MonotonicityNot monotonic
2023-12-10T23:03:19.791543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
793 4
 
13.3%
798 3
 
10.0%
0 2
 
6.7%
796 2
 
6.7%
794 2
 
6.7%
797 2
 
6.7%
803 1
 
3.3%
771 1
 
3.3%
800 1
 
3.3%
769 1
 
3.3%
Other values (11) 11
36.7%
ValueCountFrequency (%)
0 2
6.7%
1 1
3.3%
38 1
3.3%
85 1
3.3%
507 1
3.3%
743 1
3.3%
769 1
3.3%
771 1
3.3%
776 1
3.3%
777 1
3.3%
ValueCountFrequency (%)
812 1
 
3.3%
805 1
 
3.3%
803 1
 
3.3%
800 1
 
3.3%
798 3
10.0%
797 2
6.7%
796 2
6.7%
795 1
 
3.3%
794 2
6.7%
793 4
13.3%

공급_전류
Real number (ℝ)

ZEROS 

Distinct20
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean48.466667
Minimum0
Maximum149
Zeros4
Zeros (%)13.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:03:19.998685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q14
median49
Q368
95-th percentile122.55
Maximum149
Range149
Interquartile range (IQR)64

Descriptive statistics

Standard deviation47.393244
Coefficient of variation (CV)0.97785234
Kurtosis-0.8672905
Mean48.466667
Median Absolute Deviation (MAD)44.5
Skewness0.61311922
Sum1454
Variance2246.1195
MonotonicityNot monotonic
2023-12-10T23:03:20.173814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
0 4
 
13.3%
4 4
 
13.3%
68 2
 
6.7%
50 2
 
6.7%
120 2
 
6.7%
5 2
 
6.7%
118 1
 
3.3%
61 1
 
3.3%
48 1
 
3.3%
149 1
 
3.3%
Other values (10) 10
33.3%
ValueCountFrequency (%)
0 4
13.3%
2 1
 
3.3%
4 4
13.3%
5 2
6.7%
8 1
 
3.3%
11 1
 
3.3%
40 1
 
3.3%
48 1
 
3.3%
50 2
6.7%
60 1
 
3.3%
ValueCountFrequency (%)
149 1
3.3%
123 1
3.3%
122 1
3.3%
120 2
6.7%
118 1
3.3%
81 1
3.3%
68 2
6.7%
67 1
3.3%
62 1
3.3%
61 1
3.3%

비고
Categorical

CONSTANT 

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

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

2023-12-10T23:03:20.589047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-12 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-10-12 14:59:45
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-12 14:59:45
2nd row2023-10-12 14:59:45
3rd row2023-10-12 14:59:45
4th row2023-10-12 14:59:45
5th row2023-10-12 14:59:45

Common Values

ValueCountFrequency (%)
2023-10-12 14:59:45 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:03:20.974837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-12 30
50.0%
14:59:45 30
50.0%

Interactions

2023-12-10T23:03:15.556633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:14.691081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:15.095229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:15.678338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:14.809476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:15.241513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:15.822692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:14.950199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:15.397488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:03:21.061160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전_일시SOC공급_전압공급_전류
충전_일시1.0001.0001.0001.000
SOC1.0001.0000.0000.692
공급_전압1.0000.0001.0000.823
공급_전류1.0000.6920.8231.000
2023-12-10T23:03:21.211992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SOC공급_전압공급_전류
SOC1.0000.152-0.426
공급_전압0.1521.0000.465
공급_전류-0.4260.4651.000

Missing values

2023-12-10T23:03:16.016843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:03:16.330610image/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-07-01 11:57:39HYDELEC-CITY-3262019-10-2825601958031182023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
1009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-01 11:42:39HYDELEC-CITY-3262019-10-282560199507402023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
2009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 08:31:13HYDELEC-CITY-3262019-10-282560195002023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
3009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 10:56:10HYDELEC-CITY-3262019-10-282560191793682023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
4009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-06 10:09:59HYDELEC-CITY-3262019-10-2825601988542023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
5009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 11:08:03HYDELEC-CITY-3262019-10-28256019779682023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
6009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-05 07:19:17HYDELEC-CITY-3262019-10-28256018777742023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
7009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-04 07:46:50HYDELEC-CITY-3262019-10-2825601587431232023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
8009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-05 07:20:12HYDELEC-CITY-3262019-10-282560188794812023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
9009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-01 11:52:19HYDELEC-CITY-3262019-10-282560192798602023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
차량_번호충전_일시차량_제조사차량_모델출고_일자배터리_용량배터리_전압배터리_팩_수SOC공급_전압공급_전류비고생산_일시
20009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-06 10:08:24HYDELEC-CITY-3262019-10-28256019879752023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
21009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 10:54:37HYDELEC-CITY-3262019-10-282560190791672023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
22009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 10:56:41HYDELEC-CITY-3262019-10-282560191794682023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
23009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 10:57:24HYDELEC-CITY-3262019-10-282560192793502023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
24009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 10:57:55HYDELEC-CITY-3262019-10-282560192793502023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
25009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-02 16:13:32HYDELEC-CITY-3262019-10-2825601657691492023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
26009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-09 16:16:17HYDELEC-CITY-3262019-10-28256019880052023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
27009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-09 16:17:19HYDELEC-CITY-3262019-10-28256019879742023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
28009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-07 23:45:15HYDELEC-CITY-3262019-10-2825601897981202023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45
29009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2023-07-08 19:31:50HYDELEC-CITY-3262019-10-282560191793482023-10-12 전기차 배터리 상태 이력2023-10-12 14:59:45