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

Categorical7
DateTime3
Numeric3

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/6dcdae18-294d-4740-b3b4-97d50fe7e1ca

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 9 (30.0%) zerosZeros

Reproduction

Analysis started2024-03-13 11:49:56.674370
Analysis finished2024-03-13 11:49:58.557965
Duration1.88 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
001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee875
30 

Length

Max length64
Median length64
Mean length64
Min length64

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee875 30
100.0%

Length

2024-03-13T20:49:58.629550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:58.722918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee875 30
100.0%

충전_일시
Date

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-10-01 14:32:21
Maximum2023-10-04 09:13:48
2024-03-13T20:49:58.856455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:59.012602image/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

2024-03-13T20:49:59.154320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:59.258157image/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

2024-03-13T20:49:59.360573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:59.454067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
elec-city-326 30
100.0%

출고_일자
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2021-09-28 00:00:00
Maximum2021-09-28 00:00:00
2024-03-13T20:49:59.536423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:59.653403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

배터리_용량
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

2024-03-13T20:49:59.776156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:59.895643image/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

2024-03-13T20:50:00.016800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:50:00.122301image/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

2024-03-13T20:50:00.248771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:50:00.414992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 30
100.0%

SOC
Real number (ℝ)

Distinct15
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean91.066667
Minimum69
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:50:00.533507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum69
5-th percentile77.25
Q185.25
median95.5
Q397
95-th percentile100
Maximum100
Range31
Interquartile range (IQR)11.75

Descriptive statistics

Standard deviation8.4971936
Coefficient of variation (CV)0.093307397
Kurtosis-0.078108071
Mean91.066667
Median Absolute Deviation (MAD)4.5
Skewness-0.85829847
Sum2732
Variance72.202299
MonotonicityNot monotonic
2024-03-13T20:50:00.673032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
97 7
23.3%
100 4
13.3%
80 3
10.0%
87 2
 
6.7%
85 2
 
6.7%
99 2
 
6.7%
88 2
 
6.7%
75 1
 
3.3%
96 1
 
3.3%
86 1
 
3.3%
Other values (5) 5
16.7%
ValueCountFrequency (%)
69 1
 
3.3%
75 1
 
3.3%
80 3
10.0%
84 1
 
3.3%
85 2
6.7%
86 1
 
3.3%
87 2
6.7%
88 2
6.7%
92 1
 
3.3%
95 1
 
3.3%
ValueCountFrequency (%)
100 4
13.3%
99 2
 
6.7%
98 1
 
3.3%
97 7
23.3%
96 1
 
3.3%
95 1
 
3.3%
92 1
 
3.3%
88 2
 
6.7%
87 2
 
6.7%
86 1
 
3.3%

공급_전압
Real number (ℝ)

ZEROS 

Distinct24
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean611.33333
Minimum0
Maximum774
Zeros2
Zeros (%)6.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:50:00.840413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.45
Q1712.25
median731.5
Q3744
95-th percentile749.1
Maximum774
Range774
Interquartile range (IQR)31.75

Descriptive statistics

Standard deviation278.1962
Coefficient of variation (CV)0.45506467
Kurtosis1.6327236
Mean611.33333
Median Absolute Deviation (MAD)15
Skewness-1.8722723
Sum18340
Variance77393.126
MonotonicityNot monotonic
2024-03-13T20:50:01.007412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
1 3
 
10.0%
744 3
 
10.0%
729 2
 
6.7%
0 2
 
6.7%
713 1
 
3.3%
731 1
 
3.3%
704 1
 
3.3%
716 1
 
3.3%
717 1
 
3.3%
737 1
 
3.3%
Other values (14) 14
46.7%
ValueCountFrequency (%)
0 2
6.7%
1 3
10.0%
704 1
 
3.3%
708 1
 
3.3%
712 1
 
3.3%
713 1
 
3.3%
715 1
 
3.3%
716 1
 
3.3%
717 1
 
3.3%
729 2
6.7%
ValueCountFrequency (%)
774 1
 
3.3%
750 1
 
3.3%
748 1
 
3.3%
747 1
 
3.3%
746 1
 
3.3%
745 1
 
3.3%
744 3
10.0%
743 1
 
3.3%
738 1
 
3.3%
737 1
 
3.3%

공급_전류
Real number (ℝ)

ZEROS 

Distinct11
Distinct (%)36.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean81.866667
Minimum0
Maximum149
Zeros9
Zeros (%)30.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:50:01.221024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median81.5
Q3149
95-th percentile149
Maximum149
Range149
Interquartile range (IQR)149

Descriptive statistics

Standard deviation66.751073
Coefficient of variation (CV)0.81536327
Kurtosis-1.8293969
Mean81.866667
Median Absolute Deviation (MAD)67.5
Skewness-0.22470396
Sum2456
Variance4455.7057
MonotonicityNot monotonic
2024-03-13T20:50:01.374695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
0 9
30.0%
149 9
30.0%
74 3
 
10.0%
148 2
 
6.7%
134 1
 
3.3%
146 1
 
3.3%
8 1
 
3.3%
15 1
 
3.3%
89 1
 
3.3%
73 1
 
3.3%
ValueCountFrequency (%)
0 9
30.0%
8 1
 
3.3%
15 1
 
3.3%
73 1
 
3.3%
74 3
 
10.0%
89 1
 
3.3%
132 1
 
3.3%
134 1
 
3.3%
146 1
 
3.3%
148 2
 
6.7%
ValueCountFrequency (%)
149 9
30.0%
148 2
 
6.7%
146 1
 
3.3%
134 1
 
3.3%
132 1
 
3.3%
89 1
 
3.3%
74 3
 
10.0%
73 1
 
3.3%
15 1
 
3.3%
8 1
 
3.3%

비고
Categorical

CONSTANT 

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

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2024-01-09 전기차 배터리 상태 이력 30
100.0%

Length

2024-03-13T20:50:01.542061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:50:01.664052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-09 30
20.0%
전기차 30
20.0%
배터리 30
20.0%
상태 30
20.0%
이력 30
20.0%

생산_일시
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2024-01-09 09:45:56
Maximum2024-01-09 09:45:56
2024-03-13T20:50:01.787198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:50:01.909582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-13T20:49:57.893610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:56.911110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:57.256701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:57.994370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:57.031480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:57.366523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:58.124302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:57.147201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:57.798815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T20:50:02.005241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
충전_일시SOC공급_전압공급_전류
충전_일시1.0001.0001.0001.000
SOC1.0001.0000.0000.344
공급_전압1.0000.0001.0000.717
공급_전류1.0000.3440.7171.000
2024-03-13T20:50:02.114274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SOC공급_전압공급_전류
SOC1.0000.248-0.458
공급_전압0.2481.0000.331
공급_전류-0.4580.3311.000

Missing values

2024-03-13T20:49:58.309952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T20:49:58.477612image/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공급_전압공급_전류비고생산_일시
0001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-01 23:51:39HYDELEC-CITY-3262021-09-282560197102024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
1001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 14:28:41HYDELEC-CITY-3262021-09-28256018070802024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
2001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-01 14:52:21HYDELEC-CITY-3262021-09-2825601757121492024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
3001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-03 10:18:34HYDELEC-CITY-3262021-09-282560196747742024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
4001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 19:26:39HYDELEC-CITY-3262021-09-2825601877291492024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
5001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-03 00:05:11HYDELEC-CITY-3262021-09-2825601977441342024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
6001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 14:28:37HYDELEC-CITY-3262021-09-282560110071502024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
7001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-03 10:06:34HYDELEC-CITY-3262021-09-2825601867351492024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
8001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-04 00:02:17HYDELEC-CITY-3262021-09-2825601927431462024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
9001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-01 15:29:23HYDELEC-CITY-3262021-09-28256019773882024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
차량_번호충전_일시차량_제조사차량_모델출고_일자배터리_용량배터리_전압배터리_팩_수SOC공급_전압공급_전류비고생산_일시
20001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-03 00:08:11HYDELEC-CITY-3262021-09-2825601997461322024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
21001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 19:28:40HYDELEC-CITY-3262021-09-2825601887321492024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
22001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 19:43:40HYDELEC-CITY-3262021-09-2825601977441492024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
23001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 14:53:29HYDELEC-CITY-3262021-09-2825601100002024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
24001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 00:00:13HYDELEC-CITY-3262021-09-2825601887371492024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
25001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-01 23:51:41HYDELEC-CITY-3262021-09-28256018471702024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
26001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-02 14:29:36HYDELEC-CITY-3262021-09-2825601807161492024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
27001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-01 14:32:21HYDELEC-CITY-3262021-09-282560197102024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
28001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-01 14:42:21HYDELEC-CITY-3262021-09-2825601697041482024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56
29001be427693b5fce8fe1d358fae5ae849b9ecd26a377666185791fc0fc3ee8752023-10-01 15:11:22HYDELEC-CITY-3262021-09-2825601877311482024-01-09 전기차 배터리 상태 이력2024-01-09 09:45:56