Overview

Dataset statistics

Number of variables6
Number of observations85
Missing cells21
Missing cells (%)4.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.1 KiB
Average record size in memory49.6 B

Variable types

Categorical1
Text3
DateTime2

Dataset

Description제주특별자치도에 소재하고 있는 자동차 매매업체와 관련한 데이터로 행정시, 업체명, 등록일, 소재지, 연락처 등의 정보를 제공합니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15056313/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연락처 has 21 (24.7%) missing valuesMissing
업체명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:44:03.006136
Analysis finished2023-12-12 08:44:03.581689
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정시
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size812.0 B
제주시
74 
서귀포시
11 

Length

Max length4
Median length3
Mean length3.1294118
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주시
2nd row제주시
3rd row제주시
4th row제주시
5th row제주시

Common Values

ValueCountFrequency (%)
제주시 74
87.1%
서귀포시 11
 
12.9%

Length

2023-12-12T17:44:03.652771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:44:03.763015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주시 74
87.1%
서귀포시 11
 
12.9%

업체명
Text

UNIQUE 

Distinct85
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size812.0 B
2023-12-12T17:44:04.024878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length15
Mean length7.8941176
Min length3

Characters and Unicode

Total characters671
Distinct characters124
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique85 ?
Unique (%)100.0%

Sample

1st row제니스오토
2nd row베스트자동차매매상사
3rd row한라자동차매매상사
4th row경기자동차매매상사
5th row세기자동차매매상사
ValueCountFrequency (%)
주식회사 2
 
2.2%
제주중고차 2
 
2.2%
제니스오토 1
 
1.1%
오토파크 1
 
1.1%
라온자동차 1
 
1.1%
디에이치모터스 1
 
1.1%
케이씨씨오토 1
 
1.1%
정원자동차 1
 
1.1%
주식회사김서방제주지점 1
 
1.1%
영진모터스매매상사 1
 
1.1%
Other values (78) 78
86.7%
2023-12-12T17:44:04.838004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
매 88
 
13.1%
차 54
 
8.0%
사 48
 
7.2%
동 46
 
6.9%
자 45
 
6.7%
상 42
 
6.3%
스 26
 
3.9%
모 22
 
3.3%
주 22
 
3.3%
제 20
 
3.0%
Other values (114) 258
38.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 638
95.1%
Lowercase Letter 9
 
1.3%
Uppercase Letter 9
 
1.3%
Space Separator 5
 
0.7%
Other Symbol 4
 
0.6%
Dash Punctuation 2
 
0.3%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
매 88
 
13.8%
차 54
 
8.5%
사 48
 
7.5%
동 46
 
7.2%
자 45
 
7.1%
상 42
 
6.6%
스 26
 
4.1%
모 22
 
3.4%
주 22
 
3.4%
제 20
 
3.1%
Other values (96) 225
35.3%
Uppercase Letter
ValueCountFrequency (%)
K 2
22.2%
C 2
22.2%
A 1
11.1%
R 1
11.1%
J 1
11.1%
F 1
11.1%
M 1
11.1%
Lowercase Letter
ValueCountFrequency (%)
s 2
22.2%
o 2
22.2%
r 2
22.2%
t 1
11.1%
m 1
11.1%
a 1
11.1%
Space Separator
ValueCountFrequency (%)
5
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 642
95.7%
Latin 18
 
2.7%
Common 11
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
매 88
 
13.7%
차 54
 
8.4%
사 48
 
7.5%
동 46
 
7.2%
자 45
 
7.0%
상 42
 
6.5%
스 26
 
4.0%
모 22
 
3.4%
주 22
 
3.4%
제 20
 
3.1%
Other values (97) 229
35.7%
Latin
ValueCountFrequency (%)
s 2
11.1%
K 2
11.1%
C 2
11.1%
o 2
11.1%
r 2
11.1%
A 1
 
5.6%
R 1
 
5.6%
J 1
 
5.6%
t 1
 
5.6%
m 1
 
5.6%
Other values (3) 3
16.7%
Common
ValueCountFrequency (%)
5
45.5%
- 2
 
18.2%
) 2
 
18.2%
( 2
 
18.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 638
95.1%
ASCII 29
 
4.3%
None 4
 
0.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
매 88
 
13.8%
차 54
 
8.5%
사 48
 
7.5%
동 46
 
7.2%
자 45
 
7.1%
상 42
 
6.6%
스 26
 
4.1%
모 22
 
3.4%
주 22
 
3.4%
제 20
 
3.1%
Other values (96) 225
35.3%
ASCII
ValueCountFrequency (%)
5
17.2%
s 2
 
6.9%
K 2
 
6.9%
- 2
 
6.9%
C 2
 
6.9%
o 2
 
6.9%
) 2
 
6.9%
( 2
 
6.9%
r 2
 
6.9%
A 1
 
3.4%
Other values (7) 7
24.1%
None
ValueCountFrequency (%)
㈜ 4
100.0%

등록일
Date

Distinct77
Distinct (%)90.6%
Missing0
Missing (%)0.0%
Memory size812.0 B
Minimum1972-01-25 00:00:00
Maximum2023-06-13 00:00:00
2023-12-12T17:44:05.042651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:44:05.245585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

소재지
Text

Distinct49
Distinct (%)57.6%
Missing0
Missing (%)0.0%
Memory size812.0 B
2023-12-12T17:44:05.521931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length32
Mean length27.705882
Min length23

Characters and Unicode

Total characters2355
Distinct characters61
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

Unique33 ?
Unique (%)38.8%

Sample

1st row제주특별자치도 제주시 번영로 390 14호 (봉개동)
2nd row제주특별자치도 제주시 화남로 6 (화북일동)
3rd row제주특별자치도 제주시 화남로 8 110호 (화북일동)
4th row제주특별자치도 제주시 번영로 390 10호 (봉개동)
5th row제주특별자치도 제주시 화남로 8 108호 (화북일동)
ValueCountFrequency (%)
제주특별자치도 85
18.4%
제주시 72
15.6%
화북일동 36
 
7.8%
봉개동 27
 
5.8%
일주동로 27
 
5.8%
번영로 27
 
5.8%
390 22
 
4.8%
일주서로 15
 
3.2%
서귀포시 11
 
2.4%
화남로 9
 
1.9%
Other values (61) 131
28.4%
2023-12-12T17:44:05.908690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
377
 
16.0%
주 201
 
8.5%
제 159
 
6.8%
동 116
 
4.9%
도 92
 
3.9%
특 85
 
3.6%
별 85
 
3.6%
자 85
 
3.6%
치 85
 
3.6%
시 85
 
3.6%
Other values (51) 985
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1496
63.5%
Space Separator 377
 
16.0%
Decimal Number 305
 
13.0%
Close Punctuation 83
 
3.5%
Open Punctuation 83
 
3.5%
Uppercase Letter 6
 
0.3%
Dash Punctuation 5
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 201
13.4%
제 159
 
10.6%
동 116
 
7.8%
도 92
 
6.1%
특 85
 
5.7%
별 85
 
5.7%
자 85
 
5.7%
치 85
 
5.7%
시 85
 
5.7%
일 85
 
5.7%
Other values (36) 418
27.9%
Decimal Number
ValueCountFrequency (%)
1 69
22.6%
0 49
16.1%
3 43
14.1%
9 36
11.8%
4 24
 
7.9%
7 21
 
6.9%
2 21
 
6.9%
6 21
 
6.9%
8 11
 
3.6%
5 10
 
3.3%
Space Separator
ValueCountFrequency (%)
377
100.0%
Close Punctuation
ValueCountFrequency (%)
) 83
100.0%
Open Punctuation
ValueCountFrequency (%)
( 83
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 6
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1496
63.5%
Common 853
36.2%
Latin 6
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 201
13.4%
제 159
 
10.6%
동 116
 
7.8%
도 92
 
6.1%
특 85
 
5.7%
별 85
 
5.7%
자 85
 
5.7%
치 85
 
5.7%
시 85
 
5.7%
일 85
 
5.7%
Other values (36) 418
27.9%
Common
ValueCountFrequency (%)
377
44.2%
) 83
 
9.7%
( 83
 
9.7%
1 69
 
8.1%
0 49
 
5.7%
3 43
 
5.0%
9 36
 
4.2%
4 24
 
2.8%
7 21
 
2.5%
2 21
 
2.5%
Other values (4) 47
 
5.5%
Latin
ValueCountFrequency (%)
B 6
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1496
63.5%
ASCII 859
36.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
377
43.9%
) 83
 
9.7%
( 83
 
9.7%
1 69
 
8.0%
0 49
 
5.7%
3 43
 
5.0%
9 36
 
4.2%
4 24
 
2.8%
7 21
 
2.4%
2 21
 
2.4%
Other values (5) 53
 
6.2%
Hangul
ValueCountFrequency (%)
주 201
13.4%
제 159
 
10.6%
동 116
 
7.8%
도 92
 
6.1%
특 85
 
5.7%
별 85
 
5.7%
자 85
 
5.7%
치 85
 
5.7%
시 85
 
5.7%
일 85
 
5.7%
Other values (36) 418
27.9%

연락처
Text

MISSING 

Distinct59
Distinct (%)92.2%
Missing21
Missing (%)24.7%
Memory size812.0 B
2023-12-12T17:44:06.221119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.015625
Min length12

Characters and Unicode

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

Unique

Unique54 ?
Unique (%)84.4%

Sample

1st row064-755-8711
2nd row064-755-2191
3rd row064-758-8820
4th row064-743-9112
5th row064-755-1811
ValueCountFrequency (%)
064-756-0001 2
 
3.1%
064-725-7755 2
 
3.1%
064-743-3343 2
 
3.1%
064-724-2111 2
 
3.1%
064-712-3838 2
 
3.1%
064-748-7782 1
 
1.6%
064-759-9303 1
 
1.6%
064-756-7733 1
 
1.6%
064-723-5556 1
 
1.6%
064-746-0330 1
 
1.6%
Other values (49) 49
76.6%
2023-12-12T17:44:06.640205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 128
16.6%
0 111
14.4%
4 101
13.1%
6 90
11.7%
7 85
11.1%
3 48
 
6.2%
5 47
 
6.1%
1 43
 
5.6%
9 41
 
5.3%
2 40
 
5.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 641
83.4%
Dash Punctuation 128
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 111
17.3%
4 101
15.8%
6 90
14.0%
7 85
13.3%
3 48
7.5%
5 47
7.3%
1 43
 
6.7%
9 41
 
6.4%
2 40
 
6.2%
8 35
 
5.5%
Dash Punctuation
ValueCountFrequency (%)
- 128
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 769
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 128
16.6%
0 111
14.4%
4 101
13.1%
6 90
11.7%
7 85
11.1%
3 48
 
6.2%
5 47
 
6.1%
1 43
 
5.6%
9 41
 
5.3%
2 40
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 769
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 128
16.6%
0 111
14.4%
4 101
13.1%
6 90
11.7%
7 85
11.1%
3 48
 
6.2%
5 47
 
6.1%
1 43
 
5.6%
9 41
 
5.3%
2 40
 
5.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size812.0 B
Minimum2023-06-30 00:00:00
Maximum2023-06-30 00:00:00
2023-12-12T17:44:06.779449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:44:06.872716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T17:44:06.948704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정시업체명등록일소재지연락처
행정시1.0001.0001.0001.0001.000
업체명1.0001.0001.0001.0001.000
등록일1.0001.0001.0000.9520.954
소재지1.0001.0000.9521.0000.584
연락처1.0001.0000.9540.5841.000

Missing values

2023-12-12T17:44:03.433738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:44:03.541993image/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제주시제니스오토1972-01-25제주특별자치도 제주시 번영로 390 14호 (봉개동)<NA>2023-06-30
1제주시베스트자동차매매상사1976-08-31제주특별자치도 제주시 화남로 6 (화북일동)064-755-87112023-06-30
2제주시한라자동차매매상사1989-11-17제주특별자치도 제주시 화남로 8 110호 (화북일동)064-755-21912023-06-30
3제주시경기자동차매매상사1996-12-16제주특별자치도 제주시 번영로 390 10호 (봉개동)064-758-88202023-06-30
4제주시세기자동차매매상사1996-12-24제주특별자치도 제주시 화남로 8 108호 (화북일동)064-743-91122023-06-30
5제주시현대자동차매매상사1996-12-24제주특별자치도 제주시 일주동로 135 (화북일동)064-755-18112023-06-30
6제주시화북자동차매매상사2003-05-01제주특별자치도 제주시 일주동로 130 (화북일동)064-758-05002023-06-30
7제주시대성자동차매매상사1997-06-17제주특별자치도 제주시 일주동로 136 (화북일동)064-723-14142023-06-30
8제주시제이자동차매매1997-07-28제주특별자치도 제주시 일주동로 126 (화북일동)<NA>2023-06-30
9제주시그린자동차매매상사1997-07-28제주특별자치도 제주시 일주동로 126 (화북일동)064-756-16612023-06-30
행정시업체명등록일소재지연락처데이터기준일자
75서귀포시주영중고차매매상사1999-03-27제주특별자치도 서귀포시 검은여로 190 (토평동)064-732-99902023-06-30
76서귀포시신용자동차매매상사2000-12-30제주특별자치도 서귀포시 일주서로 106 (강정동)064-739-33992023-06-30
77서귀포시혁신자동차매매상사2001-12-15제주특별자치도 서귀포시 일주서로 102 (강정동)064-739-55682023-06-30
78서귀포시굿모닝자동차매매상사2002-07-22제주특별자치도 서귀포시 일주서로 106 (강정동)064-739-10042023-06-30
79서귀포시제주모터스2006-04-18제주특별자치도 서귀포시 일주서로 102 (강정동)064-739-89452023-06-30
80서귀포시삼일자동차매매상사2006-05-18제주특별자치도 서귀포시 일주서로 106 (강정동)064-738-71312023-06-30
81서귀포시우성자동차매매상사2006-06-09제주특별자치도 서귀포시 일주서로 102 (강정동)064-739-16002023-06-30
82서귀포시제주자동차매매상사2004-08-10제주특별자치도 서귀포시 남원읍 일주동로 7150064-764-82892023-06-30
83서귀포시효돈자동차매매상사2001-05-12제주특별자치도 서귀포시 효돈로 57 (신효동)070-4230-19042023-06-30
84서귀포시신동아자동차매매상사2015-02-27제주특별자치도 서귀포시 일주서로 106 (강정동)064-739-99832023-06-30