Overview

Dataset statistics

Number of variables6
Number of observations166
Missing cells0
Missing cells (%)0.0%
Duplicate rows5
Duplicate rows (%)3.0%
Total size in memory8.1 KiB
Average record size in memory49.8 B

Variable types

Categorical3
Text1
DateTime2

Dataset

Description전기전자제품및자동차의재활용시스템 내 폐자동차 협력업체 정보를 제공(업업체명, 협력 업체, 계약 순번, 계약 시작 일자, 계약 종료 일자, 등록 일시)
Author환경부
URLhttps://www.data.go.kr/data/15092392/fileData.do

Alerts

업체명 has constant value ""Constant
계약 순번 has constant value ""Constant
Dataset has 5 (3.0%) duplicate rowsDuplicates
계약 종료 일자 is highly imbalanced (76.5%)Imbalance

Reproduction

Analysis started2024-04-06 08:54:57.305976
Analysis finished2024-04-06 08:54:58.289553
Duration0.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
현대자동차
166 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row현대자동차
2nd row현대자동차
3rd row현대자동차
4th row현대자동차
5th row현대자동차

Common Values

ValueCountFrequency (%)
현대자동차 166
100.0%

Length

2024-04-06T17:54:58.849791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:54:59.093171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
현대자동차 166
100.0%

협력 업체
Text

Distinct161
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-06T17:54:59.607021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length8.8674699
Min length2

Characters and Unicode

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

Unique

Unique156 ?
Unique (%)94.0%

Sample

1st row광역자동차해체재활용산업
2nd row고흥자동차해체재활용산업
3rd row(주)삼성자동차해체재활용산업
4th row삼양자동차해체재활용산업
5th row경인폐차산업(주)
ValueCountFrequency (%)
주식회사 8
 
4.4%
주)에스피네이처 2
 
1.1%
주)카옥스 2
 
1.1%
중부종합폐차산업 2
 
1.1%
강원산업(주 2
 
1.1%
굿바이카주식회사 2
 
1.1%
슈레더사업소 2
 
1.1%
주)글로벌종합폐차산업 1
 
0.5%
주)모터스랜드 1
 
0.5%
동아자동차기업(주)폐차사업소 1
 
0.5%
Other values (160) 160
87.4%
2024-04-06T17:55:00.615154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
차 117
 
7.9%
주 101
 
6.9%
) 88
 
6.0%
( 87
 
5.9%
폐 85
 
5.8%
업 74
 
5.0%
산 73
 
5.0%
장 52
 
3.5%
동 40
 
2.7%
자 36
 
2.4%
Other values (173) 719
48.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1260
85.6%
Close Punctuation 88
 
6.0%
Open Punctuation 87
 
5.9%
Space Separator 18
 
1.2%
Lowercase Letter 10
 
0.7%
Uppercase Letter 8
 
0.5%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
차 117
 
9.3%
주 101
 
8.0%
폐 85
 
6.7%
업 74
 
5.9%
산 73
 
5.8%
장 52
 
4.1%
동 40
 
3.2%
자 36
 
2.9%
해 31
 
2.5%
체 30
 
2.4%
Other values (158) 621
49.3%
Lowercase Letter
ValueCountFrequency (%)
c 2
20.0%
o 2
20.0%
x 1
10.0%
s 1
10.0%
r 1
10.0%
a 1
10.0%
u 1
10.0%
t 1
10.0%
Uppercase Letter
ValueCountFrequency (%)
R 3
37.5%
A 3
37.5%
C 2
25.0%
Close Punctuation
ValueCountFrequency (%)
) 88
100.0%
Open Punctuation
ValueCountFrequency (%)
( 87
100.0%
Space Separator
ValueCountFrequency (%)
18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1260
85.6%
Common 194
 
13.2%
Latin 18
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
차 117
 
9.3%
주 101
 
8.0%
폐 85
 
6.7%
업 74
 
5.9%
산 73
 
5.8%
장 52
 
4.1%
동 40
 
3.2%
자 36
 
2.9%
해 31
 
2.5%
체 30
 
2.4%
Other values (158) 621
49.3%
Latin
ValueCountFrequency (%)
R 3
16.7%
A 3
16.7%
C 2
11.1%
c 2
11.1%
o 2
11.1%
x 1
 
5.6%
s 1
 
5.6%
r 1
 
5.6%
a 1
 
5.6%
u 1
 
5.6%
Common
ValueCountFrequency (%)
) 88
45.4%
( 87
44.8%
18
 
9.3%
- 1
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1260
85.6%
ASCII 212
 
14.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
차 117
 
9.3%
주 101
 
8.0%
폐 85
 
6.7%
업 74
 
5.9%
산 73
 
5.8%
장 52
 
4.1%
동 40
 
3.2%
자 36
 
2.9%
해 31
 
2.5%
체 30
 
2.4%
Other values (158) 621
49.3%
ASCII
ValueCountFrequency (%)
) 88
41.5%
( 87
41.0%
18
 
8.5%
R 3
 
1.4%
A 3
 
1.4%
C 2
 
0.9%
c 2
 
0.9%
o 2
 
0.9%
x 1
 
0.5%
s 1
 
0.5%
Other values (5) 5
 
2.4%

계약 순번
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
1
166 

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 166
100.0%

Length

2024-04-06T17:55:01.015866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:55:01.276595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 166
100.0%

계약 시작 일자
Date

Distinct38
Distinct (%)22.9%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2015-05-14 00:00:00
Maximum2022-04-01 00:00:00
2024-04-06T17:55:01.644109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:55:02.053915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)

계약 종료 일자
Categorical

IMBALANCE 

Distinct3
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2999-01-01
156 
2021-12-31
 
8
2022-12-31
 
2

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row 2999-01-01
2nd row 2999-01-01
3rd row 2999-01-01
4th row 2999-01-01
5th row 2999-01-01

Common Values

ValueCountFrequency (%)
2999-01-01 156
94.0%
2021-12-31 8
 
4.8%
2022-12-31 2
 
1.2%

Length

2024-04-06T17:55:02.366103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:55:02.670002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2999-01-01 156
94.0%
2021-12-31 8
 
4.8%
2022-12-31 2
 
1.2%

등록 일시
Date

Distinct41
Distinct (%)24.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2016-12-08 00:00:00
Maximum2022-10-20 00:00:00
2024-04-06T17:55:03.014220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:55:03.426597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)

Correlations

2024-04-06T17:55:03.744456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약 시작 일자계약 종료 일자등록 일시
계약 시작 일자1.0000.0000.986
계약 종료 일자0.0001.0000.806
등록 일시0.9860.8061.000

Missing values

2024-04-06T17:54:57.920953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:54:58.188609image/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

업체명협력 업체계약 순번계약 시작 일자계약 종료 일자등록 일시
0현대자동차광역자동차해체재활용산업12018-01-012999-01-012018-02-13
1현대자동차고흥자동차해체재활용산업12022-04-012999-01-012022-04-13
2현대자동차(주)삼성자동차해체재활용산업12018-01-012999-01-012018-02-13
3현대자동차삼양자동차해체재활용산업12018-01-012999-01-012018-02-13
4현대자동차경인폐차산업(주)12015-09-012999-01-012016-12-08
5현대자동차서천폐차장12019-05-012999-01-012019-06-11
6현대자동차(주)대불자동차해체재활용산업12021-04-012999-01-012021-04-29
7현대자동차(주)영남폐차산업12022-03-012999-01-012022-03-14
8현대자동차(주)카랜드12015-05-142999-01-012016-12-08
9현대자동차(유)중앙폐차장(x)12015-05-142999-01-012016-12-08
업체명협력 업체계약 순번계약 시작 일자계약 종료 일자등록 일시
156현대자동차(주)티더블유에프12021-03-022999-01-012021-03-19
157현대자동차현대폐차장12020-01-012999-01-012020-01-13
158현대자동차주식회사 이화산업12020-09-012999-01-012020-09-15
159현대자동차(주)가람이엔알12021-03-012999-01-012021-03-27
160현대자동차인호폐차산업12021-03-022999-01-012021-03-19
161현대자동차재성오토파츠주식회사12021-02-012999-01-012021-02-05
162현대자동차(주)지엔종합폐차산업12022-02-012999-01-012022-03-02
163현대자동차대경폐차장12021-08-012999-01-012021-09-02
164현대자동차(주)어스앤배터리12022-01-012999-01-012022-01-26
165현대자동차카이로폐차장주식회사12022-01-012999-01-012022-01-12

Duplicate rows

Most frequently occurring

업체명협력 업체계약 순번계약 시작 일자계약 종료 일자등록 일시# duplicates
0현대자동차(주)에스피네이처 슈레더사업소12015-08-032999-01-012016-12-082
1현대자동차(주)카옥스12016-04-012999-01-012016-12-082
2현대자동차강원산업(주)12016-08-012999-01-012017-06-072
3현대자동차굿바이카주식회사12018-01-012999-01-012018-02-132
4현대자동차중부종합폐차산업12016-04-182999-01-012017-06-072