Overview

Dataset statistics

Number of variables7
Number of observations343
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.6 KiB
Average record size in memory58.4 B

Variable types

Numeric2
Categorical3
DateTime2

Dataset

Description전북특별자치도 김제시 1톤트럭 폐차정보입니다. 차명, 최초등록일, 주행거리, 폐차일, 폐차 사유를 제공하고 있습니다.
Author전북특별자치도 김제시
URLhttps://www.data.go.kr/data/15124377/fileData.do

Alerts

폐차 사유(노후_사고) has constant value ""Constant
폐차시 차량 상태 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2024-03-23 04:28:21.695124
Analysis finished2024-03-23 04:28:23.793028
Duration2.1 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct343
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean172
Minimum1
Maximum343
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.1 KiB
2024-03-23T04:28:24.288515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile18.1
Q186.5
median172
Q3257.5
95-th percentile325.9
Maximum343
Range342
Interquartile range (IQR)171

Descriptive statistics

Standard deviation99.159804
Coefficient of variation (CV)0.57651049
Kurtosis-1.2
Mean172
Median Absolute Deviation (MAD)86
Skewness0
Sum58996
Variance9832.6667
MonotonicityStrictly increasing
2024-03-23T04:28:25.290605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
227 1
 
0.3%
235 1
 
0.3%
234 1
 
0.3%
233 1
 
0.3%
232 1
 
0.3%
231 1
 
0.3%
230 1
 
0.3%
229 1
 
0.3%
228 1
 
0.3%
Other values (333) 333
97.1%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
343 1
0.3%
342 1
0.3%
341 1
0.3%
340 1
0.3%
339 1
0.3%
338 1
0.3%
337 1
0.3%
336 1
0.3%
335 1
0.3%
334 1
0.3%

차명
Categorical

Distinct50
Distinct (%)14.6%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
포터Ⅱ(PORTERⅡ)
126 
봉고Ⅲ 1톤
66 
봉고프런티어
28 
포터초장축슈퍼캡
24 
포터Ⅱ (PORTERⅡ)
19 
Other values (45)
80 

Length

Max length27
Median length19
Mean length9.845481
Min length2

Unique

Unique27 ?
Unique (%)7.9%

Sample

1st row봉고프런티어
2nd row포터Ⅱ(PORTERⅡ)
3rd row봉고Ⅲ 1톤
4th row포터Ⅱ (PORTERⅡ)
5th row포터Ⅱ(PORTERⅡ)

Common Values

ValueCountFrequency (%)
포터Ⅱ(PORTERⅡ) 126
36.7%
봉고Ⅲ 1톤 66
19.2%
봉고프런티어 28
 
8.2%
포터초장축슈퍼캡 24
 
7.0%
포터Ⅱ (PORTERⅡ) 19
 
5.5%
포터초장축슈퍼캡(PORTER) 9
 
2.6%
포터초장축더블캡 6
 
1.7%
포터Ⅱ냉동탑차 (PORTERⅡ) 4
 
1.2%
봉고Ⅲ 4륜구동 3
 
0.9%
리베로슈퍼캡초장축 3
 
0.9%
Other values (40) 55
16.0%

Length

2024-03-23T04:28:26.524898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
포터ⅱ(porterⅱ 126
26.9%
봉고ⅲ 77
16.4%
1톤 67
14.3%
봉고프런티어 30
 
6.4%
porterⅱ 26
 
5.5%
포터초장축슈퍼캡 24
 
5.1%
포터ⅱ 23
 
4.9%
봉고 9
 
1.9%
포터초장축슈퍼캡(porter 9
 
1.9%
포터ⅱ냉동탑차 8
 
1.7%
Other values (40) 70
14.9%

최초등록일
Date

Distinct322
Distinct (%)93.9%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
Minimum1993-07-08 00:00:00
Maximum2021-08-31 00:00:00
2024-03-23T04:28:27.215589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T04:28:27.952780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

주행거리
Real number (ℝ)

Distinct339
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean237480.53
Minimum11901
Maximum863841
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.1 KiB
2024-03-23T04:28:28.417595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11901
5-th percentile92205.9
Q1171688
median230000
Q3292873
95-th percentile408270.9
Maximum863841
Range851940
Interquartile range (IQR)121185

Descriptive statistics

Standard deviation99332.415
Coefficient of variation (CV)0.41827604
Kurtosis4.0550128
Mean237480.53
Median Absolute Deviation (MAD)60469
Skewness0.86645309
Sum81455821
Variance9.8669287 × 109
MonotonicityNot monotonic
2024-03-23T04:28:29.385836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
290124 2
 
0.6%
230000 2
 
0.6%
260000 2
 
0.6%
135000 2
 
0.6%
110466 1
 
0.3%
174855 1
 
0.3%
210270 1
 
0.3%
320142 1
 
0.3%
110049 1
 
0.3%
91938 1
 
0.3%
Other values (329) 329
95.9%
ValueCountFrequency (%)
11901 1
0.3%
17740 1
0.3%
20000 1
0.3%
32023 1
0.3%
34042 1
0.3%
35718 1
0.3%
41573 1
0.3%
42115 1
0.3%
45753 1
0.3%
52036 1
0.3%
ValueCountFrequency (%)
863841 1
0.3%
516653 1
0.3%
503599 1
0.3%
473335 1
0.3%
463161 1
0.3%
450693 1
0.3%
442579 1
0.3%
440283 1
0.3%
433654 1
0.3%
430609 1
0.3%

폐차일(말소일자)
Date

Distinct143
Distinct (%)41.7%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
Minimum2023-01-02 00:00:00
Maximum2023-09-25 00:00:00
2024-03-23T04:28:30.151332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T04:28:30.765096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

폐차 사유(노후_사고)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
자진말소(폐차)
343 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자진말소(폐차)
2nd row자진말소(폐차)
3rd row자진말소(폐차)
4th row자진말소(폐차)
5th row자진말소(폐차)

Common Values

ValueCountFrequency (%)
자진말소(폐차) 343
100.0%

Length

2024-03-23T04:28:31.779941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T04:28:32.102928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자진말소(폐차 343
100.0%

폐차시 차량 상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
알 수 없음
343 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row알 수 없음
2nd row알 수 없음
3rd row알 수 없음
4th row알 수 없음
5th row알 수 없음

Common Values

ValueCountFrequency (%)
알 수 없음 343
100.0%

Length

2024-03-23T04:28:32.602178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T04:28:32.968537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
알 343
33.3%
수 343
33.3%
없음 343
33.3%

Interactions

2024-03-23T04:28:22.499382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T04:28:21.983060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T04:28:22.800277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T04:28:22.247878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T04:28:33.152209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번차명주행거리
순번1.0000.1540.000
차명0.1541.0000.361
주행거리0.0000.3611.000
2024-03-23T04:28:33.477656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번주행거리차명
순번1.0000.0770.042
주행거리0.0771.0000.160
차명0.0420.1601.000

Missing values

2024-03-23T04:28:23.118467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T04:28:23.586808image/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

순번차명최초등록일주행거리폐차일(말소일자)폐차 사유(노후_사고)폐차시 차량 상태
01봉고프런티어1998-10-141104662023-01-02자진말소(폐차)알 수 없음
12포터Ⅱ(PORTERⅡ)2006-08-221679062023-01-03자진말소(폐차)알 수 없음
23봉고Ⅲ 1톤2014-03-031699652023-01-03자진말소(폐차)알 수 없음
34포터Ⅱ (PORTERⅡ)2016-11-03717902023-01-03자진말소(폐차)알 수 없음
45포터Ⅱ(PORTERⅡ)2006-05-121482232023-01-04자진말소(폐차)알 수 없음
56포터초장축더블캡2002-07-022996772023-01-05자진말소(폐차)알 수 없음
67봉고Ⅲ 1톤2011-12-292841282023-01-05자진말소(폐차)알 수 없음
78포터초장축슈퍼캡1999-09-173024042023-01-06자진말소(폐차)알 수 없음
89포터엘피지초장축더블캡1999-08-251552362023-01-11자진말소(폐차)알 수 없음
910포터초장축슈퍼캡(PORTER)2003-11-282156542023-01-20자진말소(폐차)알 수 없음
순번차명최초등록일주행거리폐차일(말소일자)폐차 사유(노후_사고)폐차시 차량 상태
333334포터Ⅱ(PORTERⅡ)2010-03-152355122023-09-18자진말소(폐차)알 수 없음
334335포터Ⅱ (PORTERⅡ)2017-06-09357182023-09-18자진말소(폐차)알 수 없음
335336포터Ⅱ(PORTERⅡ)2004-03-272557202023-09-19자진말소(폐차)알 수 없음
336337포터Ⅱ(PORTERⅡ)2010-02-244291402023-09-19자진말소(폐차)알 수 없음
337338포터Ⅱ (PORTERⅡ)2011-11-222213572023-09-19자진말소(폐차)알 수 없음
338339봉고프런티어2002-06-272116912023-09-20자진말소(폐차)알 수 없음
339340봉고Ⅲ 1톤2006-10-231494672023-09-20자진말소(폐차)알 수 없음
340341포터Ⅱ(PORTERⅡ)2009-04-212695842023-09-20자진말소(폐차)알 수 없음
341342포터Ⅱ(PORTERⅡ)2007-02-152929892023-09-22자진말소(폐차)알 수 없음
342343포터Ⅱ(PORTERⅡ)2009-07-243276882023-09-25자진말소(폐차)알 수 없음