Overview

Dataset statistics

Number of variables12
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory107.4 B

Variable types

Categorical8
DateTime1
Numeric3

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/519c2ef2-5c0f-4540-8f8e-ca6647270c36

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
SOH has constant value ""Constant
평균공급전압 is highly overall correlated with 평균공급전류High correlation
평균공급전류 is highly overall correlated with 평균공급전압High correlation
조회일시 has unique valuesUnique

Reproduction

Analysis started2023-12-10 14:00:49.277840
Analysis finished2023-12-10 14:00:51.621754
Duration2.34 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:00:51.736482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:00:51.891265image/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
Minimum2021-08-02 15:36:14
Maximum2021-08-31 18:47:42
2023-12-10T23:00:52.044222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:52.290630image/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:00:52.626970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:00:52.884311image/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-240
30 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

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

출고일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
9999-12-31
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row9999-12-31
2nd row9999-12-31
3rd row9999-12-31
4th row9999-12-31
5th row9999-12-31

Common Values

ValueCountFrequency (%)
9999-12-31 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:00:53.882163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
9999-12-31 30
100.0%

배터리용량
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
128 30
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

평균공급전압
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean733.186
Minimum728.55
Maximum755.78
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:00:54.979239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum728.55
5-th percentile728.55
Q1728.55
median731.25
Q3735
95-th percentile744.0975
Maximum755.78
Range27.23
Interquartile range (IQR)6.45

Descriptive statistics

Standard deviation6.1781275
Coefficient of variation (CV)0.0084264123
Kurtosis7.5906978
Mean733.186
Median Absolute Deviation (MAD)2.7
Skewness2.6141693
Sum21995.58
Variance38.169259
MonotonicityNot monotonic
2023-12-10T23:00:55.193258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
728.55 9
30.0%
731.25 6
20.0%
735.0 6
20.0%
735.16 4
13.3%
731.1 3
 
10.0%
755.78 1
 
3.3%
751.41 1
 
3.3%
ValueCountFrequency (%)
728.55 9
30.0%
731.1 3
 
10.0%
731.25 6
20.0%
735.0 6
20.0%
735.16 4
13.3%
751.41 1
 
3.3%
755.78 1
 
3.3%
ValueCountFrequency (%)
755.78 1
 
3.3%
751.41 1
 
3.3%
735.16 4
13.3%
735.0 6
20.0%
731.25 6
20.0%
731.1 3
 
10.0%
728.55 9
30.0%

평균공급전류
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean78.936333
Minimum76.76
Maximum100.8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:00:55.378580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum76.76
5-th percentile76.76
Q176.76
median77.845
Q379.18
95-th percentile83.8785
Maximum100.8
Range24.04
Interquartile range (IQR)2.42

Descriptive statistics

Standard deviation4.6106986
Coefficient of variation (CV)0.058410346
Kurtosis18.664291
Mean78.936333
Median Absolute Deviation (MAD)1.085
Skewness4.1366404
Sum2368.09
Variance21.258541
MonotonicityNot monotonic
2023-12-10T23:00:55.567744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
76.76 9
30.0%
78.54 6
20.0%
77.15 6
20.0%
79.18 4
13.3%
79.33 3
 
10.0%
100.8 1
 
3.3%
87.6 1
 
3.3%
ValueCountFrequency (%)
76.76 9
30.0%
77.15 6
20.0%
78.54 6
20.0%
79.18 4
13.3%
79.33 3
 
10.0%
87.6 1
 
3.3%
100.8 1
 
3.3%
ValueCountFrequency (%)
100.8 1
 
3.3%
87.6 1
 
3.3%
79.33 3
 
10.0%
79.18 4
13.3%
78.54 6
20.0%
77.15 6
20.0%
76.76 9
30.0%

총충전횟수
Real number (ℝ)

Distinct8
Distinct (%)26.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.233333
Minimum2
Maximum16
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:00:55.768788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile9.45
Q110.25
median11.5
Q312
95-th percentile13.55
Maximum16
Range14
Interquartile range (IQR)1.75

Descriptive statistics

Standard deviation2.2388934
Coefficient of variation (CV)0.19930802
Kurtosis10.024332
Mean11.233333
Median Absolute Deviation (MAD)0.5
Skewness-2.1699073
Sum337
Variance5.0126437
MonotonicityNot monotonic
2023-12-10T23:00:56.113898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
12 10
33.3%
11 7
23.3%
10 6
20.0%
13 3
 
10.0%
16 1
 
3.3%
2 1
 
3.3%
9 1
 
3.3%
14 1
 
3.3%
ValueCountFrequency (%)
2 1
 
3.3%
9 1
 
3.3%
10 6
20.0%
11 7
23.3%
12 10
33.3%
13 3
 
10.0%
14 1
 
3.3%
16 1
 
3.3%
ValueCountFrequency (%)
16 1
 
3.3%
14 1
 
3.3%
13 3
 
10.0%
12 10
33.3%
11 7
23.3%
10 6
20.0%
9 1
 
3.3%
2 1
 
3.3%

총주행거리
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:00:56.333443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

SOH
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:00:56.643177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Interactions

2023-12-10T23:00:50.611838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:49.670651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:50.184306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:50.759251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:49.809506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:50.320604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:50.899147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:49.933450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:00:50.447079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:00:56.915605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조회일시평균공급전압평균공급전류총충전횟수
조회일시1.0001.0001.0001.000
평균공급전압1.0001.0000.9740.570
평균공급전류1.0000.9741.0000.701
총충전횟수1.0000.5700.7011.000
2023-12-10T23:00:57.096159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
평균공급전압평균공급전류총충전횟수
평균공급전압1.0000.6870.165
평균공급전류0.6871.0000.070
총충전횟수0.1650.0701.000

Missing values

2023-12-10T23:00:51.157719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:00:51.477954image/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

차량번호조회일시제조사모델명출고일자배터리용량배터리전압값평균공급전압평균공급전류총충전횟수총주행거리SOH
0009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-21 06:56:11HYDELEC-CITY-2409999-12-311280731.2578.541200
1009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-25 21:34:33HYDELEC-CITY-2409999-12-311280731.2578.541300
2009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-12 19:06:15HYDELEC-CITY-2409999-12-311280728.5576.761000
3009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-19 18:41:51HYDELEC-CITY-2409999-12-311280735.1679.181200
4009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-27 12:27:43HYDELEC-CITY-2409999-12-311280735.077.151000
5009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-08 17:36:37HYDELEC-CITY-2409999-12-311280735.1679.181200
6009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-18 11:00:21HYDELEC-CITY-2409999-12-311280728.5576.761100
7009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-02 15:36:14HYDELEC-CITY-2409999-12-311280728.5576.761600
8009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-24 21:49:22HYDELEC-CITY-2409999-12-311280728.5576.761200
9009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-10 14:33:56HYDELEC-CITY-2409999-12-311280731.179.331000
차량번호조회일시제조사모델명출고일자배터리용량배터리전압값평균공급전압평균공급전류총충전횟수총주행거리SOH
20009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-20 18:21:43HYDELEC-CITY-2409999-12-311280728.5576.761200
21009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-11 14:17:29HYDELEC-CITY-2409999-12-311280731.179.331100
22009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-19 21:24:18HYDELEC-CITY-2409999-12-311280731.2578.541200
23009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-14 00:05:19HYDELEC-CITY-2409999-12-311280751.4187.61300
24009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-15 17:11:54HYDELEC-CITY-2409999-12-311280731.2578.54900
25009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-26 12:51:23HYDELEC-CITY-2409999-12-311280735.1679.181400
26009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-21 17:25:02HYDELEC-CITY-2409999-12-311280735.077.151200
27009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-25 07:51:47HYDELEC-CITY-2409999-12-311280735.077.151300
28009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-30 16:12:29HYDELEC-CITY-2409999-12-311280728.5576.761000
29009d5ab8beac1990d82081ca2f661f0a85ddb5def46e094bc1d89e786d3bad0f2021-08-03 23:04:18HYDELEC-CITY-2409999-12-311280735.077.151100