Overview

Dataset statistics

Number of variables19
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.8 KiB
Average record size in memory164.4 B

Variable types

Categorical16
Text2
Numeric1

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/5899b82e-a012-4dc9-9f4a-a3380bd8eaa1

Alerts

운행일자 has constant value ""Constant
전비 has constant value ""Constant
메모내용 has constant value ""Constant
등록일시 has constant value ""Constant
수정일시 has constant value ""Constant
시군구코드 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
전력사용량 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
출차시간 is highly overall correlated with 충전소ID and 9 other fieldsHigh correlation
노선유형 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
노선번호 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
차량번호 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
소요시간 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
충전지역명 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
시도코드 is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
충전소ID is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
사용SOC is highly overall correlated with 출차시간 and 9 other fieldsHigh correlation
정류장ID has unique valuesUnique

Reproduction

Analysis started2023-12-10 14:10:51.716620
Analysis finished2023-12-10 14:10:54.423867
Duration2.71 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
2021-09-01
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-09-01
2nd row2021-09-01
3rd row2021-09-01
4th row2021-09-01
5th row2021-09-01

Common Values

ValueCountFrequency (%)
2021-09-01 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:10:54.697939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-09-01 30
100.0%

출차시간
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
14:24:01
10 
13:45:00
7 
13:41:18
5 
14:27:27
3 
13:45:47
 
1
Other values (4)
4 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique5 ?
Unique (%)16.7%

Sample

1st row13:45:47
2nd row14:23:02
3rd row13:45:00
4th row14:23:39
5th row13:45:00

Common Values

ValueCountFrequency (%)
14:24:01 10
33.3%
13:45:00 7
23.3%
13:41:18 5
16.7%
14:27:27 3
 
10.0%
13:45:47 1
 
3.3%
14:23:02 1
 
3.3%
14:23:39 1
 
3.3%
13:43:04 1
 
3.3%
13:38:38 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T23:10:55.112711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
14:24:01 10
33.3%
13:45:00 7
23.3%
13:41:18 5
16.7%
14:27:27 3
 
10.0%
13:45:47 1
 
3.3%
14:23:02 1
 
3.3%
14:23:39 1
 
3.3%
13:43:04 1
 
3.3%
13:38:38 1
 
3.3%

충전소ID
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
KRPPKCS0044
12 
KRPPKCS0006
11 
KRPPKCS0045
7 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKRPPKCS0044
2nd rowKRPPKCS0044
3rd rowKRPPKCS0045
4th rowKRPPKCS0044
5th rowKRPPKCS0045

Common Values

ValueCountFrequency (%)
KRPPKCS0044 12
40.0%
KRPPKCS0006 11
36.7%
KRPPKCS0045 7
23.3%

Length

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

Common Values (Plot)

2023-12-10T23:10:55.510628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
krppkcs0044 12
40.0%
krppkcs0006 11
36.7%
krppkcs0045 7
23.3%

노선번호
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
162
11 
41
8 
107
7 
83
4 

Length

Max length3
Median length3
Mean length2.6
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row41
2nd row83
3rd row107
4th row41
5th row107

Common Values

ValueCountFrequency (%)
162 11
36.7%
41 8
26.7%
107 7
23.3%
83 4
 
13.3%

Length

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

Common Values (Plot)

2023-12-10T23:10:55.891933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
162 11
36.7%
41 8
26.7%
107 7
23.3%
83 4
 
13.3%

정류장ID
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T23:10:56.202252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters360
Distinct characters13
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st rowBSB199250301
2nd rowBSB505430000
3rd rowBSB500950000
4th rowBSB199370301
5th rowBSB217900201
ValueCountFrequency (%)
bsb199250301 1
 
3.3%
bsb505430000 1
 
3.3%
bsb211840303 1
 
3.3%
bsb199420102 1
 
3.3%
bsb167860102 1
 
3.3%
bsb199270101 1
 
3.3%
bsb168010301 1
 
3.3%
sob118000070 1
 
3.3%
bsb169150203 1
 
3.3%
sob118000065 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T23:10:56.810693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 108
30.0%
1 54
15.0%
B 49
13.6%
S 30
 
8.3%
2 29
 
8.1%
9 16
 
4.4%
8 13
 
3.6%
3 12
 
3.3%
7 12
 
3.3%
O 11
 
3.1%
Other values (3) 26
 
7.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 270
75.0%
Uppercase Letter 90
 
25.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 108
40.0%
1 54
20.0%
2 29
 
10.7%
9 16
 
5.9%
8 13
 
4.8%
3 12
 
4.4%
7 12
 
4.4%
5 10
 
3.7%
4 10
 
3.7%
6 6
 
2.2%
Uppercase Letter
ValueCountFrequency (%)
B 49
54.4%
S 30
33.3%
O 11
 
12.2%

Most occurring scripts

ValueCountFrequency (%)
Common 270
75.0%
Latin 90
 
25.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 108
40.0%
1 54
20.0%
2 29
 
10.7%
9 16
 
5.9%
8 13
 
4.8%
3 12
 
4.4%
7 12
 
4.4%
5 10
 
3.7%
4 10
 
3.7%
6 6
 
2.2%
Latin
ValueCountFrequency (%)
B 49
54.4%
S 30
33.3%
O 11
 
12.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 360
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 108
30.0%
1 54
15.0%
B 49
13.6%
S 30
 
8.3%
2 29
 
8.1%
9 16
 
4.4%
8 13
 
3.6%
3 12
 
3.3%
7 12
 
3.3%
O 11
 
3.1%
Other values (3) 26
 
7.2%

차량번호
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d359
10 
7416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd
7 
d27722e74c518073f77e33ffc8b4ea4dc6c12c04689a12413a9fd8788e57f1ab
5 
9869402e2b5ea13e5a13fcb8eec789dc6db4bada6cd462bd612937b57f19839e
3 
2903cebea4e25ade66ca7dd54f555a574bd3213ae832b8d0ffa4c70d187b7f26
 
1
Other values (4)
4 

Length

Max length64
Median length64
Mean length64
Min length64

Unique

Unique5 ?
Unique (%)16.7%

Sample

1st row2903cebea4e25ade66ca7dd54f555a574bd3213ae832b8d0ffa4c70d187b7f26
2nd row2e56888891d0286c7a820a390f776ac1d61002fa28c5c2084c43b27882e6be90
3rd row7416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd
4th rowe1becacc1de352b0fa3f5ad54a7f66c5485bc6c0293afa98dee421c6ead12cc9
5th row7416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd

Common Values

ValueCountFrequency (%)
975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d359 10
33.3%
7416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd 7
23.3%
d27722e74c518073f77e33ffc8b4ea4dc6c12c04689a12413a9fd8788e57f1ab 5
16.7%
9869402e2b5ea13e5a13fcb8eec789dc6db4bada6cd462bd612937b57f19839e 3
 
10.0%
2903cebea4e25ade66ca7dd54f555a574bd3213ae832b8d0ffa4c70d187b7f26 1
 
3.3%
2e56888891d0286c7a820a390f776ac1d61002fa28c5c2084c43b27882e6be90 1
 
3.3%
e1becacc1de352b0fa3f5ad54a7f66c5485bc6c0293afa98dee421c6ead12cc9 1
 
3.3%
92894256aa2443b0d6669f935b3e0210ee72cff48158ea5cde40bac7e1ba1bf5 1
 
3.3%
1806224e952e60e87a18706608841554aace4594585f07fc5946c07eccf3554b 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T23:10:57.298535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d359 10
33.3%
7416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd 7
23.3%
d27722e74c518073f77e33ffc8b4ea4dc6c12c04689a12413a9fd8788e57f1ab 5
16.7%
9869402e2b5ea13e5a13fcb8eec789dc6db4bada6cd462bd612937b57f19839e 3
 
10.0%
2903cebea4e25ade66ca7dd54f555a574bd3213ae832b8d0ffa4c70d187b7f26 1
 
3.3%
2e56888891d0286c7a820a390f776ac1d61002fa28c5c2084c43b27882e6be90 1
 
3.3%
e1becacc1de352b0fa3f5ad54a7f66c5485bc6c0293afa98dee421c6ead12cc9 1
 
3.3%
92894256aa2443b0d6669f935b3e0210ee72cff48158ea5cde40bac7e1ba1bf5 1
 
3.3%
1806224e952e60e87a18706608841554aace4594585f07fc5946c07eccf3554b 1
 
3.3%

시도코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
26
19 
11
11 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
26 19
63.3%
11 11
36.7%

Length

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

Common Values (Plot)

2023-12-10T23:10:57.758348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
26 19
63.3%
11 11
36.7%

시군구코드
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
500
12 
290
11 
710
7 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row500
2nd row500
3rd row710
4th row500
5th row710

Common Values

ValueCountFrequency (%)
500 12
40.0%
290 11
36.7%
710 7
23.3%

Length

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

Common Values (Plot)

2023-12-10T23:10:58.378070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
500 12
40.0%
290 11
36.7%
710 7
23.3%

충전지역명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
부산광역시 수영구 민락동
12 
서울특별시 성북구 정릉동
11 
부산광역시 기장군 정관읍 용수리
7 

Length

Max length17
Median length13
Mean length13.933333
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산광역시 수영구 민락동
2nd row부산광역시 수영구 민락동
3rd row부산광역시 기장군 정관읍 용수리
4th row부산광역시 수영구 민락동
5th row부산광역시 기장군 정관읍 용수리

Common Values

ValueCountFrequency (%)
부산광역시 수영구 민락동 12
40.0%
서울특별시 성북구 정릉동 11
36.7%
부산광역시 기장군 정관읍 용수리 7
23.3%

Length

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

Common Values (Plot)

2023-12-10T23:10:58.962621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부산광역시 19
19.6%
수영구 12
12.4%
민락동 12
12.4%
서울특별시 11
11.3%
성북구 11
11.3%
정릉동 11
11.3%
기장군 7
 
7.2%
정관읍 7
 
7.2%
용수리 7
 
7.2%

노선유형
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
일반버스
19 
간선
11 

Length

Max length4
Median length4
Mean length3.2666667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반버스
2nd row일반버스
3rd row일반버스
4th row일반버스
5th row일반버스

Common Values

ValueCountFrequency (%)
일반버스 19
63.3%
간선 11
36.7%

Length

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

Common Values (Plot)

2023-12-10T23:10:59.927268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반버스 19
63.3%
간선 11
36.7%

정류장명
Text

Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T23:11:00.212911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length6.8666667
Min length3

Characters and Unicode

Total characters206
Distinct characters116
Distinct categories5 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)93.3%

Sample

1st row롯데캐슬아파트
2nd row대연고개
3rd row철마교
4th row서호병원
5th row달산마을
ValueCountFrequency (%)
갈월동 2
 
6.7%
롯데캐슬아파트 1
 
3.3%
삼선교.한성대학교 1
 
3.3%
중앙역2번출구 1
 
3.3%
광안2동우편취급국 1
 
3.3%
영주동 1
 
3.3%
금련산청소년수련원 1
 
3.3%
중앙동.중앙역 1
 
3.3%
여의도역 1
 
3.3%
부산진역 1
 
3.3%
Other values (19) 19
63.3%
2023-12-10T23:11:00.817683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 10
 
4.9%
동 9
 
4.4%
대 6
 
2.9%
산 6
 
2.9%
역 6
 
2.9%
교 5
 
2.4%
원 5
 
2.4%
한 4
 
1.9%
마 4
 
1.9%
앙 4
 
1.9%
Other values (106) 147
71.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 189
91.7%
Other Punctuation 10
 
4.9%
Decimal Number 3
 
1.5%
Uppercase Letter 3
 
1.5%
Lowercase Letter 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 9
 
4.8%
대 6
 
3.2%
산 6
 
3.2%
역 6
 
3.2%
교 5
 
2.6%
원 5
 
2.6%
한 4
 
2.1%
마 4
 
2.1%
앙 4
 
2.1%
구 3
 
1.6%
Other values (100) 137
72.5%
Uppercase Letter
ValueCountFrequency (%)
S 1
33.3%
B 1
33.3%
K 1
33.3%
Other Punctuation
ValueCountFrequency (%)
. 10
100.0%
Decimal Number
ValueCountFrequency (%)
2 3
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 189
91.7%
Common 13
 
6.3%
Latin 4
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 9
 
4.8%
대 6
 
3.2%
산 6
 
3.2%
역 6
 
3.2%
교 5
 
2.6%
원 5
 
2.6%
한 4
 
2.1%
마 4
 
2.1%
앙 4
 
2.1%
구 3
 
1.6%
Other values (100) 137
72.5%
Latin
ValueCountFrequency (%)
S 1
25.0%
B 1
25.0%
K 1
25.0%
e 1
25.0%
Common
ValueCountFrequency (%)
. 10
76.9%
2 3
 
23.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 189
91.7%
ASCII 17
 
8.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 10
58.8%
2 3
 
17.6%
S 1
 
5.9%
B 1
 
5.9%
K 1
 
5.9%
e 1
 
5.9%
Hangul
ValueCountFrequency (%)
동 9
 
4.8%
대 6
 
3.2%
산 6
 
3.2%
역 6
 
3.2%
교 5
 
2.6%
원 5
 
2.6%
한 4
 
2.1%
마 4
 
2.1%
앙 4
 
2.1%
구 3
 
1.6%
Other values (100) 137
72.5%

구간거리
Real number (ℝ)

Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean360.03333
Minimum124
Maximum1065
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:11:01.059196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum124
5-th percentile143.4
Q1239.75
median349.5
Q3432.25
95-th percentile610.25
Maximum1065
Range941
Interquartile range (IQR)192.5

Descriptive statistics

Standard deviation185.71325
Coefficient of variation (CV)0.51582239
Kurtosis6.2027708
Mean360.03333
Median Absolute Deviation (MAD)91.5
Skewness1.8935715
Sum10801
Variance34489.413
MonotonicityNot monotonic
2023-12-10T23:11:01.297192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
238 2
 
6.7%
124 1
 
3.3%
360 1
 
3.3%
466 1
 
3.3%
569 1
 
3.3%
276 1
 
3.3%
245 1
 
3.3%
470 1
 
3.3%
339 1
 
3.3%
129 1
 
3.3%
Other values (19) 19
63.3%
ValueCountFrequency (%)
124 1
3.3%
129 1
3.3%
161 1
3.3%
171 1
3.3%
172 1
3.3%
191 1
3.3%
238 2
6.7%
245 1
3.3%
270 1
3.3%
272 1
3.3%
ValueCountFrequency (%)
1065 1
3.3%
644 1
3.3%
569 1
3.3%
470 1
3.3%
466 1
3.3%
446 1
3.3%
436 1
3.3%
433 1
3.3%
430 1
3.3%
420 1
3.3%

소요시간
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
12 
11679
10 
<NA>
7 
12030
 
1

Length

Max length5
Median length4
Mean length3.1666667
Min length1

Unique

Unique1 ?
Unique (%)3.3%

Sample

1st row0
2nd row<NA>
3rd row0
4th row<NA>
5th row0

Common Values

ValueCountFrequency (%)
0 12
40.0%
11679 10
33.3%
<NA> 7
23.3%
12030 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T23:11:02.023155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 12
40.0%
11679 10
33.3%
na 7
23.3%
12030 1
 
3.3%

사용SOC
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
19 
13
10 
12
 
1

Length

Max length2
Median length1
Mean length1.3666667
Min length1

Unique

Unique1 ?
Unique (%)3.3%

Sample

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

Common Values

ValueCountFrequency (%)
0 19
63.3%
13 10
33.3%
12 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T23:11:02.520693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 19
63.3%
13 10
33.3%
12 1
 
3.3%

전력사용량
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
0.0
19 
36.36
10 
35.98
 
1

Length

Max length5
Median length3
Mean length3.7333333
Min length3

Unique

Unique1 ?
Unique (%)3.3%

Sample

1st row0.0
2nd row0.0
3rd row0.0
4th row0.0
5th row0.0

Common Values

ValueCountFrequency (%)
0.0 19
63.3%
36.36 10
33.3%
35.98 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T23:11:02.978959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0.0 19
63.3%
36.36 10
33.3%
35.98 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:11:03.240331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:11:03.387368image/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
2021년 09월 01일 정류장별 에너지 소비 분석
30 

Length

Max length28
Median length28
Mean length28
Min length28

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021년 09월 01일 정류장별 에너지 소비 분석
2nd row2021년 09월 01일 정류장별 에너지 소비 분석
3rd row2021년 09월 01일 정류장별 에너지 소비 분석
4th row2021년 09월 01일 정류장별 에너지 소비 분석
5th row2021년 09월 01일 정류장별 에너지 소비 분석

Common Values

ValueCountFrequency (%)
2021년 09월 01일 정류장별 에너지 소비 분석 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:11:03.723708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021년 30
14.3%
09월 30
14.3%
01일 30
14.3%
정류장별 30
14.3%
에너지 30
14.3%
소비 30
14.3%
분석 30
14.3%

등록일시
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2021-12-23 01:14:18
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-12-23 01:14:18
2nd row2021-12-23 01:14:18
3rd row2021-12-23 01:14:18
4th row2021-12-23 01:14:18
5th row2021-12-23 01:14:18

Common Values

ValueCountFrequency (%)
2021-12-23 01:14:18 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:11:04.062469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-12-23 30
50.0%
01:14:18 30
50.0%

수정일시
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2021-12-23 01:14:18
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-12-23 01:14:18
2nd row2021-12-23 01:14:18
3rd row2021-12-23 01:14:18
4th row2021-12-23 01:14:18
5th row2021-12-23 01:14:18

Common Values

ValueCountFrequency (%)
2021-12-23 01:14:18 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:11:04.369543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-12-23 30
50.0%
01:14:18 30
50.0%

Interactions

2023-12-10T23:10:53.627200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:11:04.501895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
출차시간충전소ID노선번호정류장ID차량번호시도코드시군구코드충전지역명노선유형정류장명구간거리소요시간사용SOC전력사용량
출차시간1.0001.0001.0001.0001.0001.0001.0001.0001.0000.0000.6431.0001.0001.000
충전소ID1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0000.5570.9280.9320.932
노선번호1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0000.5550.6310.6430.643
정류장ID1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
차량번호1.0001.0001.0001.0001.0001.0001.0001.0001.0000.0000.6431.0001.0001.000
시도코드1.0001.0001.0001.0001.0001.0001.0001.0000.9931.0000.4901.0001.0001.000
시군구코드1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0000.5570.9280.9320.932
충전지역명1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0000.5570.9280.9320.932
노선유형1.0001.0001.0001.0001.0000.9931.0001.0001.0001.0000.4901.0001.0001.000
정류장명0.0001.0001.0001.0000.0001.0001.0001.0001.0001.0000.0000.0000.0000.000
구간거리0.6430.5570.5551.0000.6430.4900.5570.5570.4900.0001.0000.4130.3030.303
소요시간1.0000.9280.6311.0001.0001.0000.9280.9281.0000.0000.4131.0001.0001.000
사용SOC1.0000.9320.6431.0001.0001.0000.9320.9321.0000.0000.3031.0001.0001.000
전력사용량1.0000.9320.6431.0001.0001.0000.9320.9321.0000.0000.3031.0001.0001.000
2023-12-10T23:11:04.768773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구코드전력사용량출차시간노선유형노선번호차량번호소요시간충전지역명시도코드충전소ID사용SOC
시군구코드1.0000.6800.8820.9820.9810.8820.6711.0000.9821.0000.680
전력사용량0.6801.0000.8820.9820.6530.8821.0000.6800.9820.6801.000
출차시간0.8820.8821.0000.8660.8991.0000.9220.8820.8660.8820.882
노선유형0.9820.9820.8661.0000.9640.8660.9760.9820.9260.9820.982
노선번호0.9810.6530.8990.9641.0000.8990.6320.9810.9640.9810.653
차량번호0.8820.8821.0000.8660.8991.0000.9220.8820.8660.8820.882
소요시간0.6711.0000.9220.9760.6320.9221.0000.6710.9760.6711.000
충전지역명1.0000.6800.8820.9820.9810.8820.6711.0000.9821.0000.680
시도코드0.9820.9820.8660.9260.9640.8660.9760.9821.0000.9820.982
충전소ID1.0000.6800.8820.9820.9810.8820.6711.0000.9821.0000.680
사용SOC0.6801.0000.8820.9820.6530.8821.0000.6800.9820.6801.000
2023-12-10T23:11:05.005559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구간거리출차시간충전소ID노선번호차량번호시도코드시군구코드충전지역명노선유형소요시간사용SOC전력사용량
구간거리1.0000.3800.4050.3830.3800.4710.4050.4050.4710.2510.1790.179
출차시간0.3801.0000.8820.8991.0000.8660.8820.8820.8660.9220.8820.882
충전소ID0.4050.8821.0000.9810.8820.9821.0001.0000.9820.6710.6800.680
노선번호0.3830.8990.9811.0000.8990.9640.9810.9810.9640.6320.6530.653
차량번호0.3801.0000.8820.8991.0000.8660.8820.8820.8660.9220.8820.882
시도코드0.4710.8660.9820.9640.8661.0000.9820.9820.9260.9760.9820.982
시군구코드0.4050.8821.0000.9810.8820.9821.0001.0000.9820.6710.6800.680
충전지역명0.4050.8821.0000.9810.8820.9821.0001.0000.9820.6710.6800.680
노선유형0.4710.8660.9820.9640.8660.9260.9820.9821.0000.9760.9820.982
소요시간0.2510.9220.6710.6320.9220.9760.6710.6710.9761.0001.0001.000
사용SOC0.1790.8820.6800.6530.8820.9820.6800.6800.9821.0001.0001.000
전력사용량0.1790.8820.6800.6530.8820.9820.6800.6800.9821.0001.0001.000

Missing values

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

운행일자출차시간충전소ID노선번호정류장ID차량번호시도코드시군구코드충전지역명노선유형정류장명구간거리소요시간사용SOC전력사용량전비메모내용등록일시수정일시
02021-09-0113:45:47KRPPKCS004441BSB1992503012903cebea4e25ade66ca7dd54f555a574bd3213ae832b8d0ffa4c70d187b7f2626500부산광역시 수영구 민락동일반버스롯데캐슬아파트124000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
12021-09-0114:23:02KRPPKCS004483BSB5054300002e56888891d0286c7a820a390f776ac1d61002fa28c5c2084c43b27882e6be9026500부산광역시 수영구 민락동일반버스대연고개436<NA>00.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
22021-09-0113:45:00KRPPKCS0045107BSB5009500007416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd26710부산광역시 기장군 정관읍 용수리일반버스철마교270000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
32021-09-0114:23:39KRPPKCS004441BSB199370301e1becacc1de352b0fa3f5ad54a7f66c5485bc6c0293afa98dee421c6ead12cc926500부산광역시 수영구 민락동일반버스서호병원238<NA>00.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
42021-09-0113:45:00KRPPKCS0045107BSB2179002017416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd26710부산광역시 기장군 정관읍 용수리일반버스달산마을172000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
52021-09-0114:24:01KRPPKCS0006162SOB100000104975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d35911290서울특별시 성북구 정릉동간선안국역.종로경찰서.인사동1065116791336.3602021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
62021-09-0113:45:00KRPPKCS0045107BSB2128401017416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd26710부산광역시 기장군 정관읍 용수리일반버스구연마을191000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
72021-09-0114:24:01KRPPKCS0006162SOB100000123975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d35911290서울특별시 성북구 정릉동간선방송통신대.이화장446116791336.3602021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
82021-09-0113:45:00KRPPKCS0045107BSB2128302017416fbe0ea46ce01b6412bddb68c195f8cc1c687a442c72436c4bcbb31d2bcfd26710부산광역시 기장군 정관읍 용수리일반버스솔마루공원238000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
92021-09-0114:24:01KRPPKCS0006162SOB102000011975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d35911290서울특별시 성북구 정릉동간선갈월동644116791336.3602021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
운행일자출차시간충전소ID노선번호정류장ID차량번호시도코드시군구코드충전지역명노선유형정류장명구간거리소요시간사용SOC전력사용량전비메모내용등록일시수정일시
202021-09-0113:41:18KRPPKCS004441BSB180220101d27722e74c518073f77e33ffc8b4ea4dc6c12c04689a12413a9fd8788e57f1ab26500부산광역시 수영구 민락동일반버스못골시장406<NA>00.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
212021-09-0114:24:01KRPPKCS0006162SOB118000065975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d35911290서울특별시 성북구 정릉동간선KBS별관419116791336.3602021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
222021-09-0113:41:18KRPPKCS004441BSB169150203d27722e74c518073f77e33ffc8b4ea4dc6c12c04689a12413a9fd8788e57f1ab26500부산광역시 수영구 민락동일반버스부산진역323<NA>00.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
232021-09-0114:24:01KRPPKCS0006162SOB118000070975aea48beae53c0731a1c0b29da152f912a4fdc26cfab24c3bbe73800b6d35911290서울특별시 성북구 정릉동간선여의도역129116791336.3602021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
242021-09-0113:41:18KRPPKCS004441BSB168010301d27722e74c518073f77e33ffc8b4ea4dc6c12c04689a12413a9fd8788e57f1ab26500부산광역시 수영구 민락동일반버스중앙동.중앙역339<NA>00.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
252021-09-0114:27:27KRPPKCS004483BSB1992701019869402e2b5ea13e5a13fcb8eec789dc6db4bada6cd462bd612937b57f19839e26500부산광역시 수영구 민락동일반버스금련산청소년수련원470000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
262021-09-0113:41:18KRPPKCS004441BSB167860102d27722e74c518073f77e33ffc8b4ea4dc6c12c04689a12413a9fd8788e57f1ab26500부산광역시 수영구 민락동일반버스영주동245<NA>00.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
272021-09-0114:27:27KRPPKCS004483BSB1994201029869402e2b5ea13e5a13fcb8eec789dc6db4bada6cd462bd612937b57f19839e26500부산광역시 수영구 민락동일반버스광안2동우편취급국276000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
282021-09-0113:38:38KRPPKCS004441BSB2118403031806224e952e60e87a18706608841554aace4594585f07fc5946c07eccf3554b26500부산광역시 수영구 민락동일반버스중앙역2번출구569000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18
292021-09-0114:27:27KRPPKCS004483BSB1994803019869402e2b5ea13e5a13fcb8eec789dc6db4bada6cd462bd612937b57f19839e26500부산광역시 수영구 민락동일반버스경성대.부경대역466000.002021년 09월 01일 정류장별 에너지 소비 분석2021-12-23 01:14:182021-12-23 01:14:18