Overview

Dataset statistics

Number of variables4
Number of observations69
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.4 KiB
Average record size in memory34.9 B

Variable types

Numeric1
Text3

Dataset

Description경기도 수원시의 자동차 관리사업(정비업, 매매업) 현황에 대한 데이터로 업체명, 소재지주소, 업체 전화번호를 포함합니다.
Author경기도 수원시
URLhttps://www.data.go.kr/data/15051551/fileData.do

Alerts

No has unique valuesUnique
업 체 명 has unique valuesUnique
소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:40:36.438718
Analysis finished2023-12-12 11:40:37.244614
Duration0.81 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

No
Real number (ℝ)

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35
Minimum1
Maximum69
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2023-12-12T20:40:37.383652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.4
Q118
median35
Q352
95-th percentile65.6
Maximum69
Range68
Interquartile range (IQR)34

Descriptive statistics

Standard deviation20.062403
Coefficient of variation (CV)0.5732115
Kurtosis-1.2
Mean35
Median Absolute Deviation (MAD)17
Skewness0
Sum2415
Variance402.5
MonotonicityStrictly increasing
2023-12-12T20:40:37.729253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.4%
45 1
 
1.4%
51 1
 
1.4%
50 1
 
1.4%
49 1
 
1.4%
48 1
 
1.4%
47 1
 
1.4%
46 1
 
1.4%
44 1
 
1.4%
53 1
 
1.4%
Other values (59) 59
85.5%
ValueCountFrequency (%)
1 1
1.4%
2 1
1.4%
3 1
1.4%
4 1
1.4%
5 1
1.4%
6 1
1.4%
7 1
1.4%
8 1
1.4%
9 1
1.4%
10 1
1.4%
ValueCountFrequency (%)
69 1
1.4%
68 1
1.4%
67 1
1.4%
66 1
1.4%
65 1
1.4%
64 1
1.4%
63 1
1.4%
62 1
1.4%
61 1
1.4%
60 1
1.4%

업 체 명
Text

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size684.0 B
2023-12-12T20:40:38.122746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length14
Mean length9.3478261
Min length3

Characters and Unicode

Total characters645
Distinct characters119
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

Unique69 ?
Unique (%)100.0%

Sample

1st row(주)우성자동차정비공업사
2nd row경수모터스
3rd row(주)탑모터스
4th row대원자동차정비공장
5th row현대자동차정비공업사
ValueCountFrequency (%)
주식회사 4
 
5.1%
주)우성자동차정비공업사 1
 
1.3%
주)신대영자동차1급정비업체 1
 
1.3%
주)현대북수원서비스 1
 
1.3%
조원자동차공업사 1
 
1.3%
북수원정비사업소 1
 
1.3%
주)르노삼성자동차서비스센터 1
 
1.3%
주)오토25시종합자동차서비스 1
 
1.3%
㈜홍보(장안자동차공업사 1
 
1.3%
㈜영통현대모터스 1
 
1.3%
Other values (66) 66
83.5%
2023-12-12T20:40:38.782260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 35
 
5.4%
자 33
 
5.1%
차 33
 
5.1%
사 31
 
4.8%
스 28
 
4.3%
㈜ 26
 
4.0%
업 26
 
4.0%
비 25
 
3.9%
공 23
 
3.6%
주 21
 
3.3%
Other values (109) 364
56.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 564
87.4%
Other Symbol 26
 
4.0%
Open Punctuation 15
 
2.3%
Close Punctuation 15
 
2.3%
Decimal Number 12
 
1.9%
Space Separator 10
 
1.6%
Uppercase Letter 2
 
0.3%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 35
 
6.2%
자 33
 
5.9%
차 33
 
5.9%
사 31
 
5.5%
스 28
 
5.0%
업 26
 
4.6%
비 25
 
4.4%
공 23
 
4.1%
주 21
 
3.7%
터 19
 
3.4%
Other values (100) 290
51.4%
Decimal Number
ValueCountFrequency (%)
1 8
66.7%
2 3
 
25.0%
5 1
 
8.3%
Other Symbol
ValueCountFrequency (%)
㈜ 26
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Space Separator
ValueCountFrequency (%)
10
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 2
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 590
91.5%
Common 53
 
8.2%
Latin 2
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 35
 
5.9%
자 33
 
5.6%
차 33
 
5.6%
사 31
 
5.3%
스 28
 
4.7%
㈜ 26
 
4.4%
업 26
 
4.4%
비 25
 
4.2%
공 23
 
3.9%
주 21
 
3.6%
Other values (101) 309
52.4%
Common
ValueCountFrequency (%)
( 15
28.3%
) 15
28.3%
10
18.9%
1 8
15.1%
2 3
 
5.7%
5 1
 
1.9%
& 1
 
1.9%
Latin
ValueCountFrequency (%)
B 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 564
87.4%
ASCII 55
 
8.5%
None 26
 
4.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 35
 
6.2%
자 33
 
5.9%
차 33
 
5.9%
사 31
 
5.5%
스 28
 
5.0%
업 26
 
4.6%
비 25
 
4.4%
공 23
 
4.1%
주 21
 
3.7%
터 19
 
3.4%
Other values (100) 290
51.4%
None
ValueCountFrequency (%)
㈜ 26
100.0%
ASCII
ValueCountFrequency (%)
( 15
27.3%
) 15
27.3%
10
18.2%
1 8
14.5%
2 3
 
5.5%
B 2
 
3.6%
5 1
 
1.8%
& 1
 
1.8%

소재지
Text

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size684.0 B
2023-12-12T20:40:39.322916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length33
Mean length26.811594
Min length7

Characters and Unicode

Total characters1850
Distinct characters77
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique69 ?
Unique (%)100.0%

Sample

1st row경기도 수원시 권선구 매송고색로 779 (고색동, 163-7)
2nd row경기도 수원시 권선구 평동로 46 (고색동)
3rd row경기도 수원시 권선구 매송고색로 808-1 (고색동, 186-26)
4th row경기도 수원시 권선구 평동로 14 (고색동)
5th row경기도 수원시 권선구 평동로 10 (고색동)
ValueCountFrequency (%)
수원시 58
 
15.2%
경기도 57
 
15.0%
권선구 32
 
8.4%
영통구 29
 
7.6%
원천동 13
 
3.4%
매송고색로 10
 
2.6%
오목천동 8
 
2.1%
평동 7
 
1.8%
매영로 7
 
1.8%
장안구 7
 
1.8%
Other values (109) 153
40.2%
2023-12-12T20:40:40.087297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
424
22.9%
원 84
 
4.5%
동 69
 
3.7%
로 69
 
3.7%
구 68
 
3.7%
수 63
 
3.4%
경 59
 
3.2%
( 59
 
3.2%
) 59
 
3.2%
시 58
 
3.1%
Other values (67) 838
45.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 996
53.8%
Space Separator 424
22.9%
Decimal Number 275
 
14.9%
Open Punctuation 59
 
3.2%
Close Punctuation 59
 
3.2%
Other Punctuation 18
 
1.0%
Dash Punctuation 18
 
1.0%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 84
 
8.4%
동 69
 
6.9%
로 69
 
6.9%
구 68
 
6.8%
수 63
 
6.3%
경 59
 
5.9%
시 58
 
5.8%
도 57
 
5.7%
기 57
 
5.7%
영 43
 
4.3%
Other values (51) 369
37.0%
Decimal Number
ValueCountFrequency (%)
1 46
16.7%
2 42
15.3%
0 28
10.2%
4 27
9.8%
6 26
9.5%
7 23
8.4%
8 23
8.4%
5 22
8.0%
3 21
7.6%
9 17
 
6.2%
Space Separator
ValueCountFrequency (%)
424
100.0%
Open Punctuation
ValueCountFrequency (%)
( 59
100.0%
Close Punctuation
ValueCountFrequency (%)
) 59
100.0%
Other Punctuation
ValueCountFrequency (%)
, 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 996
53.8%
Common 854
46.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 84
 
8.4%
동 69
 
6.9%
로 69
 
6.9%
구 68
 
6.8%
수 63
 
6.3%
경 59
 
5.9%
시 58
 
5.8%
도 57
 
5.7%
기 57
 
5.7%
영 43
 
4.3%
Other values (51) 369
37.0%
Common
ValueCountFrequency (%)
424
49.6%
( 59
 
6.9%
) 59
 
6.9%
1 46
 
5.4%
2 42
 
4.9%
0 28
 
3.3%
4 27
 
3.2%
6 26
 
3.0%
7 23
 
2.7%
8 23
 
2.7%
Other values (6) 97
 
11.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 996
53.8%
ASCII 854
46.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
424
49.6%
( 59
 
6.9%
) 59
 
6.9%
1 46
 
5.4%
2 42
 
4.9%
0 28
 
3.3%
4 27
 
3.2%
6 26
 
3.0%
7 23
 
2.7%
8 23
 
2.7%
Other values (6) 97
 
11.4%
Hangul
ValueCountFrequency (%)
원 84
 
8.4%
동 69
 
6.9%
로 69
 
6.9%
구 68
 
6.8%
수 63
 
6.3%
경 59
 
5.9%
시 58
 
5.8%
도 57
 
5.7%
기 57
 
5.7%
영 43
 
4.3%
Other values (51) 369
37.0%

전화번호
Text

Distinct68
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size684.0 B
2023-12-12T20:40:40.544208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length8
Mean length8.3043478
Min length8

Characters and Unicode

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

Unique

Unique67 ?
Unique (%)97.1%

Sample

1st row296-7100
2nd row298-2261
3rd row227-1223
4th row291-2294
5th row292-6741
ValueCountFrequency (%)
204-0123 2
 
2.9%
216-2612 1
 
1.4%
211-5582 1
 
1.4%
214-4000 1
 
1.4%
213-9797 1
 
1.4%
294-8844 1
 
1.4%
216-8633 1
 
1.4%
212-4244 1
 
1.4%
251-8331 1
 
1.4%
216-8610 1
 
1.4%
Other values (59) 59
84.3%
2023-12-12T20:40:41.218611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 115
20.1%
- 71
12.4%
1 60
10.5%
0 52
9.1%
9 48
8.4%
4 42
 
7.3%
7 42
 
7.3%
6 39
 
6.8%
3 33
 
5.8%
8 33
 
5.8%
Other values (3) 38
 
6.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 494
86.2%
Dash Punctuation 71
 
12.4%
Space Separator 7
 
1.2%
Control 1
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 115
23.3%
1 60
12.1%
0 52
10.5%
9 48
9.7%
4 42
 
8.5%
7 42
 
8.5%
6 39
 
7.9%
3 33
 
6.7%
8 33
 
6.7%
5 30
 
6.1%
Dash Punctuation
ValueCountFrequency (%)
- 71
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 573
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 115
20.1%
- 71
12.4%
1 60
10.5%
0 52
9.1%
9 48
8.4%
4 42
 
7.3%
7 42
 
7.3%
6 39
 
6.8%
3 33
 
5.8%
8 33
 
5.8%
Other values (3) 38
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 573
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 115
20.1%
- 71
12.4%
1 60
10.5%
0 52
9.1%
9 48
8.4%
4 42
 
7.3%
7 42
 
7.3%
6 39
 
6.8%
3 33
 
5.8%
8 33
 
5.8%
Other values (3) 38
 
6.6%

Interactions

2023-12-12T20:40:36.786753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:40:41.416704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
No업 체 명소재지전화번호
No1.0001.0001.0001.000
업 체 명1.0001.0001.0001.000
소재지1.0001.0001.0001.000
전화번호1.0001.0001.0001.000

Missing values

2023-12-12T20:40:37.016007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:40:37.178223image/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

No업 체 명소재지전화번호
01(주)우성자동차정비공업사경기도 수원시 권선구 매송고색로 779 (고색동, 163-7)296-7100
12경수모터스경기도 수원시 권선구 평동로 46 (고색동)298-2261
23(주)탑모터스경기도 수원시 권선구 매송고색로 808-1 (고색동, 186-26)227-1223
34대원자동차정비공장경기도 수원시 권선구 평동로 14 (고색동)291-2294
45현대자동차정비공업사경기도 수원시 권선구 평동로 10 (고색동)292-6741
56㈜1급가족자동차정비공업사경기도 수원시 권선구 새터로47번길 74 (세류동)239-4972
67서수원자동차공업사㈜경기도 수원시 권선구 매송고색로503번길 2 (오목천동)295-6622 295-6694
78㈜신안전자동차공업사경기도 수원시 권선구 효행로 40 (오목천동)293-6036
89쌍용자동차서수원사업소㈜경기도 수원시 권선구 서수원로 135 (오목천동)292-4360
910㈜이즈모터스경기도 수원시 권선구 오목천로 56 (오목천동)292-8787
No업 체 명소재지전화번호
5960오일타운수원시 권선구 정조로 221,223(대황교동)232-0061
6061대성자동차공업사신원로 196205-1865
6162프렌치오토모빌영통구 영통로 297,1~3층224-6655
6263에코모터스정비㈜권선구 서호동로 33297-2627
6364퍼스트 오토권선구 평동로52-30278-6567
6465비엠모터스정비㈜권선구 평동로 47227-0768
65661급 다온모터스권선구 평동로25-66296-8272
6667소명모터스권선구 세화로26296-9477
6768가온모터스권선구 서수원로75번길70-11278-7942
6869우리자동차공업사(1급)권선구 세화로50(평동)295-5872