Overview

Dataset statistics

Number of variables6
Number of observations103
Missing cells5
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.1 KiB
Average record size in memory50.3 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description부산광역시연제구_자동차관리업체현황_20230215
Author부산광역시 연제구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15025098

Alerts

상태정보 has constant value ""Constant
관리사업유형 has constant value ""Constant
전화번호 has 5 (4.9%) missing valuesMissing
순번 has unique valuesUnique
사업자 상호(명칭) has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:26:42.459623
Analysis finished2023-12-10 16:26:43.062452
Duration0.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct103
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean52
Minimum1
Maximum103
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-11T01:26:43.160573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.1
Q126.5
median52
Q377.5
95-th percentile97.9
Maximum103
Range102
Interquartile range (IQR)51

Descriptive statistics

Standard deviation29.877528
Coefficient of variation (CV)0.57456784
Kurtosis-1.2
Mean52
Median Absolute Deviation (MAD)26
Skewness0
Sum5356
Variance892.66667
MonotonicityStrictly increasing
2023-12-11T01:26:43.348106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
2 1
 
1.0%
77 1
 
1.0%
76 1
 
1.0%
75 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
Other values (93) 93
90.3%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
103 1
1.0%
102 1
1.0%
101 1
1.0%
100 1
1.0%
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%

상태정보
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size956.0 B
영업
103 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업
2nd row영업
3rd row영업
4th row영업
5th row영업

Common Values

ValueCountFrequency (%)
영업 103
100.0%

Length

2023-12-11T01:26:43.529285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:26:43.662685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업 103
100.0%

관리사업유형
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size956.0 B
자동차매매업
103 

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 (%)
자동차매매업 103
100.0%

Length

2023-12-11T01:26:43.792430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:26:43.918075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동차매매업 103
100.0%

전화번호
Text

MISSING 

Distinct87
Distinct (%)88.8%
Missing5
Missing (%)4.9%
Memory size956.0 B
2023-12-11T01:26:44.229723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length12
Mean length12.112245
Min length9

Characters and Unicode

Total characters1187
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

Unique77 ?
Unique (%)78.6%

Sample

1st row051-863-0880
2nd row051-523-7333
3rd row051-862-2828
4th row051-315-3000(051-866-6161)
5th row051-864-9615
ValueCountFrequency (%)
051-862-8949 3
 
3.1%
051-809-8989 2
 
2.0%
051-715-7151 2
 
2.0%
051-711-8589 2
 
2.0%
051-636-8192 2
 
2.0%
051-501-0013 2
 
2.0%
051-714-1300 2
 
2.0%
051-710-1770 2
 
2.0%
051-714-0824 2
 
2.0%
051-711-8595 2
 
2.0%
Other values (77) 77
78.6%
2023-12-11T01:26:44.770285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 197
16.6%
1 189
15.9%
5 175
14.7%
0 173
14.6%
8 101
8.5%
9 70
 
5.9%
6 64
 
5.4%
7 64
 
5.4%
3 61
 
5.1%
2 46
 
3.9%
Other values (3) 47
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 988
83.2%
Dash Punctuation 197
 
16.6%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 189
19.1%
5 175
17.7%
0 173
17.5%
8 101
10.2%
9 70
 
7.1%
6 64
 
6.5%
7 64
 
6.5%
3 61
 
6.2%
2 46
 
4.7%
4 45
 
4.6%
Dash Punctuation
ValueCountFrequency (%)
- 197
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1187
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 197
16.6%
1 189
15.9%
5 175
14.7%
0 173
14.6%
8 101
8.5%
9 70
 
5.9%
6 64
 
5.4%
7 64
 
5.4%
3 61
 
5.1%
2 46
 
3.9%
Other values (3) 47
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1187
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 197
16.6%
1 189
15.9%
5 175
14.7%
0 173
14.6%
8 101
8.5%
9 70
 
5.9%
6 64
 
5.4%
7 64
 
5.4%
3 61
 
5.1%
2 46
 
3.9%
Other values (3) 47
 
4.0%

사업자 상호(명칭)
Text

UNIQUE 

Distinct103
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size956.0 B
2023-12-11T01:26:45.106459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length9
Mean length6.5825243
Min length3

Characters and Unicode

Total characters678
Distinct characters138
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

Unique103 ?
Unique (%)100.0%

Sample

1st row진성모터스
2nd rowSH모터스
3rd row(주)월드모터
4th row유승모터스
5th row대진모터스
ValueCountFrequency (%)
주식회사 3
 
2.7%
모터스 2
 
1.8%
진성모터스 1
 
0.9%
마이카2 1
 
0.9%
주)카엔카 1
 
0.9%
주)카톡모터스 1
 
0.9%
주)더굿카모터스 1
 
0.9%
주)아이언모터스 1
 
0.9%
픽카 1
 
0.9%
정상모터스 1
 
0.9%
Other values (97) 97
88.2%
2023-12-11T01:26:45.603357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 64
 
9.4%
모 56
 
8.3%
터 55
 
8.1%
주 48
 
7.1%
( 45
 
6.6%
) 45
 
6.6%
카 22
 
3.2%
차 17
 
2.5%
동 16
 
2.4%
자 14
 
2.1%
Other values (128) 296
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 551
81.3%
Open Punctuation 45
 
6.6%
Close Punctuation 45
 
6.6%
Uppercase Letter 17
 
2.5%
Space Separator 8
 
1.2%
Other Symbol 8
 
1.2%
Decimal Number 2
 
0.3%
Lowercase Letter 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 64
 
11.6%
모 56
 
10.2%
터 55
 
10.0%
주 48
 
8.7%
카 22
 
4.0%
차 17
 
3.1%
동 16
 
2.9%
자 14
 
2.5%
사 12
 
2.2%
오 9
 
1.6%
Other values (110) 238
43.2%
Uppercase Letter
ValueCountFrequency (%)
K 4
23.5%
B 3
17.6%
S 2
11.8%
J 1
 
5.9%
H 1
 
5.9%
Y 1
 
5.9%
G 1
 
5.9%
M 1
 
5.9%
P 1
 
5.9%
W 1
 
5.9%
Lowercase Letter
ValueCountFrequency (%)
k 1
50.0%
b 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 45
100.0%
Close Punctuation
ValueCountFrequency (%)
) 45
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 8
100.0%
Decimal Number
ValueCountFrequency (%)
2 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 559
82.4%
Common 100
 
14.7%
Latin 19
 
2.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 64
 
11.4%
모 56
 
10.0%
터 55
 
9.8%
주 48
 
8.6%
카 22
 
3.9%
차 17
 
3.0%
동 16
 
2.9%
자 14
 
2.5%
사 12
 
2.1%
오 9
 
1.6%
Other values (111) 246
44.0%
Latin
ValueCountFrequency (%)
K 4
21.1%
B 3
15.8%
S 2
10.5%
J 1
 
5.3%
H 1
 
5.3%
Y 1
 
5.3%
G 1
 
5.3%
k 1
 
5.3%
b 1
 
5.3%
M 1
 
5.3%
Other values (3) 3
15.8%
Common
ValueCountFrequency (%)
( 45
45.0%
) 45
45.0%
8
 
8.0%
2 2
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 551
81.3%
ASCII 119
 
17.6%
None 8
 
1.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 64
 
11.6%
모 56
 
10.2%
터 55
 
10.0%
주 48
 
8.7%
카 22
 
4.0%
차 17
 
3.1%
동 16
 
2.9%
자 14
 
2.5%
사 12
 
2.2%
오 9
 
1.6%
Other values (110) 238
43.2%
ASCII
ValueCountFrequency (%)
( 45
37.8%
) 45
37.8%
8
 
6.7%
K 4
 
3.4%
B 3
 
2.5%
S 2
 
1.7%
2 2
 
1.7%
J 1
 
0.8%
H 1
 
0.8%
Y 1
 
0.8%
Other values (7) 7
 
5.9%
None
ValueCountFrequency (%)
㈜ 8
100.0%

사업장주소
Text

Distinct62
Distinct (%)60.2%
Missing0
Missing (%)0.0%
Memory size956.0 B
2023-12-11T01:26:45.894763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length23
Mean length21.582524
Min length18

Characters and Unicode

Total characters2223
Distinct characters37
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

Unique53 ?
Unique (%)51.5%

Sample

1st row부산광역시 연제구 중앙대로 1154, 203호
2nd row부산광역시 연제구 중앙대로 1154, 303호
3rd row부산광역시 연제구 중앙대로 1154
4th row부산광역시 연제구 중앙대로 1154
5th row부산광역시 연제구 중앙대로 1154
ValueCountFrequency (%)
부산광역시 103
21.5%
연제구 103
21.5%
경기장로 62
12.9%
15 32
 
6.7%
21 30
 
6.3%
거제천로 20
 
4.2%
174 20
 
4.2%
중앙대로 13
 
2.7%
1154 13
 
2.7%
거제천로182번길 8
 
1.7%
Other values (43) 75
15.7%
2023-12-11T01:26:46.504862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
376
16.9%
1 150
 
6.7%
제 131
 
5.9%
부 103
 
4.6%
로 103
 
4.6%
광 103
 
4.6%
역 103
 
4.6%
시 103
 
4.6%
연 103
 
4.6%
구 103
 
4.6%
Other values (27) 845
38.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1320
59.4%
Decimal Number 461
 
20.7%
Space Separator 376
 
16.9%
Other Punctuation 65
 
2.9%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 131
9.9%
부 103
 
7.8%
로 103
 
7.8%
광 103
 
7.8%
역 103
 
7.8%
시 103
 
7.8%
연 103
 
7.8%
구 103
 
7.8%
산 103
 
7.8%
호 64
 
4.8%
Other values (14) 301
22.8%
Decimal Number
ValueCountFrequency (%)
1 150
32.5%
2 79
17.1%
3 53
 
11.5%
5 50
 
10.8%
0 41
 
8.9%
4 38
 
8.2%
7 24
 
5.2%
8 12
 
2.6%
9 8
 
1.7%
6 6
 
1.3%
Space Separator
ValueCountFrequency (%)
376
100.0%
Other Punctuation
ValueCountFrequency (%)
, 65
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1320
59.4%
Common 902
40.6%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 131
9.9%
부 103
 
7.8%
로 103
 
7.8%
광 103
 
7.8%
역 103
 
7.8%
시 103
 
7.8%
연 103
 
7.8%
구 103
 
7.8%
산 103
 
7.8%
호 64
 
4.8%
Other values (14) 301
22.8%
Common
ValueCountFrequency (%)
376
41.7%
1 150
 
16.6%
2 79
 
8.8%
, 65
 
7.2%
3 53
 
5.9%
5 50
 
5.5%
0 41
 
4.5%
4 38
 
4.2%
7 24
 
2.7%
8 12
 
1.3%
Other values (2) 14
 
1.6%
Latin
ValueCountFrequency (%)
c 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1320
59.4%
ASCII 903
40.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
376
41.6%
1 150
 
16.6%
2 79
 
8.7%
, 65
 
7.2%
3 53
 
5.9%
5 50
 
5.5%
0 41
 
4.5%
4 38
 
4.2%
7 24
 
2.7%
8 12
 
1.3%
Other values (3) 15
 
1.7%
Hangul
ValueCountFrequency (%)
제 131
9.9%
부 103
 
7.8%
로 103
 
7.8%
광 103
 
7.8%
역 103
 
7.8%
시 103
 
7.8%
연 103
 
7.8%
구 103
 
7.8%
산 103
 
7.8%
호 64
 
4.8%
Other values (14) 301
22.8%

Interactions

2023-12-11T01:26:42.702608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:26:46.661411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번전화번호사업장주소
순번1.0000.5930.953
전화번호0.5931.0000.000
사업장주소0.9530.0001.000

Missing values

2023-12-11T01:26:42.825098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:26:43.006763image/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영업자동차매매업051-863-0880진성모터스부산광역시 연제구 중앙대로 1154, 203호
12영업자동차매매업051-523-7333SH모터스부산광역시 연제구 중앙대로 1154, 303호
23영업자동차매매업051-862-2828(주)월드모터부산광역시 연제구 중앙대로 1154
34영업자동차매매업051-315-3000(051-866-6161)유승모터스부산광역시 연제구 중앙대로 1154
45영업자동차매매업051-864-9615대진모터스부산광역시 연제구 중앙대로 1154
56영업자동차매매업051-866-0080우리자동차부산광역시 연제구 중앙대로 1154
67영업자동차매매업051-863-5577스타모터스부산광역시 연제구 중앙대로 1154
78영업자동차매매업051-864-9009진모터스부산광역시 연제구 중앙대로 1154
89영업자동차매매업051-862-5533YG모터스부산광역시 연제구 중앙대로 1154
910영업자동차매매업051-866-0555JK모터스부산광역시 연제구 중앙대로 1154
순번상태정보관리사업유형전화번호사업자 상호(명칭)사업장주소
9394영업자동차매매업051-989-3989(주)오토라인모터스부산광역시 연제구 경기장로 21, 311호
9495영업자동차매매업051-529-4982판다모터스부산광역시 연제구 경기장로 21, 210호
9596영업자동차매매업051-913-6636부경모터스부산광역시 연제구 경기장로 21, 310호
9697영업자동차매매업051-939-5511신박한모터스부산광역시 연제구 경기장로 21, 316호
9798영업자동차매매업<NA>(주)에이스타모터스부산광역시 연제구 경기장로 21, 208호
9899영업자동차매매업051-709-6312스타자동차(주)부산광역시 연제구 경기장로 21, 206호
99100영업자동차매매업<NA>㈜카카오모터스부산광역시 연제구 경기장로 21, 211호
100101영업자동차매매업051-714-1300카 빌리지부산광역시 연제구 경기장로 21, 204호
101102영업자동차매매업051-714-3673에이스타모터스부산광역시 연제구 경기장로 21, 209호
102103영업자동차매매업051-915-7070순수자동차부산광역시 연제구 경기장로 21, 301호