Overview

Dataset statistics

Number of variables18
Number of observations91
Missing cells547
Missing cells (%)33.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.8 KiB
Average record size in memory155.5 B

Variable types

Text4
Categorical5
Numeric3
DateTime1
Unsupported5

Dataset

Description대구광역시_남구_자동차정비업체
Author대구광역시 남구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15028204&dataSetDetailId=150282041f2adb87eeac9&provdMethod=FILE

Alerts

소재지지번주소 has constant value ""Constant
영업상태 has constant value ""Constant
관리기관명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
면적 is highly overall correlated with 자동차정비업체종류High correlation
자동차정비업체종류 is highly overall correlated with 면적High correlation
자동차정비업체종류 is highly imbalanced (89.0%)Imbalance
소재지지번주소 has 90 (98.9%) missing valuesMissing
폐업일자 has 91 (100.0%) missing valuesMissing
휴업시작일자 has 91 (100.0%) missing valuesMissing
휴업종료일자 has 91 (100.0%) missing valuesMissing
운영시작시각 has 91 (100.0%) missing valuesMissing
운영종료시각 has 91 (100.0%) missing valuesMissing
전화번호 has 2 (2.2%) missing valuesMissing
자동차정비업체명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique
폐업일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업시작일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업종료일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
운영시작시각 is an unsupported type, check if it needs cleaning or further analysisUnsupported
운영종료시각 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-02 04:29:12.201841
Analysis finished2023-12-02 04:29:17.163697
Duration4.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자동차정비업체명
Text

UNIQUE 

Distinct91
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size860.0 B
2023-12-02T13:29:17.405596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length11
Mean length7.6483516
Min length4

Characters and Unicode

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

Unique

Unique91 ?
Unique (%)100.0%

Sample

1st row중대구현대서비스
2nd row산호자동차정비공장
3rd row삼양카써비스센타
4th row대명점기아오토큐
5th row현대자동차대명점
ValueCountFrequency (%)
중대구현대서비스 1
 
1.0%
경상자동차모터샵부분정비 1
 
1.0%
자동차11번가 1
 
1.0%
대명카부분정비 1
 
1.0%
블루핸즈 1
 
1.0%
대명중부점 1
 
1.0%
우리카부분정비 1
 
1.0%
현대부분정비 1
 
1.0%
캠프자동차부분정비 1
 
1.0%
몽키개러지 1
 
1.0%
Other values (91) 91
90.1%
2023-12-02T13:29:18.380858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
비 55
 
7.9%
카 41
 
5.9%
정 40
 
5.7%
부 35
 
5.0%
분 33
 
4.7%
스 33
 
4.7%
대 22
 
3.2%
동 19
 
2.7%
터 18
 
2.6%
차 17
 
2.4%
Other values (158) 383
55.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 658
94.5%
Uppercase Letter 15
 
2.2%
Space Separator 10
 
1.4%
Lowercase Letter 8
 
1.1%
Decimal Number 4
 
0.6%
Other Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
비 55
 
8.4%
카 41
 
6.2%
정 40
 
6.1%
부 35
 
5.3%
분 33
 
5.0%
스 33
 
5.0%
대 22
 
3.3%
동 19
 
2.9%
터 18
 
2.7%
차 17
 
2.6%
Other values (137) 345
52.4%
Uppercase Letter
ValueCountFrequency (%)
O 2
13.3%
M 2
13.3%
G 2
13.3%
Y 1
6.7%
H 1
6.7%
J 1
6.7%
N 1
6.7%
I 1
6.7%
K 1
6.7%
R 1
6.7%
Other values (2) 2
13.3%
Lowercase Letter
ValueCountFrequency (%)
a 2
25.0%
r 2
25.0%
e 2
25.0%
d 1
12.5%
l 1
12.5%
Decimal Number
ValueCountFrequency (%)
1 3
75.0%
2 1
 
25.0%
Space Separator
ValueCountFrequency (%)
10
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 659
94.7%
Latin 23
 
3.3%
Common 14
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
비 55
 
8.3%
카 41
 
6.2%
정 40
 
6.1%
부 35
 
5.3%
분 33
 
5.0%
스 33
 
5.0%
대 22
 
3.3%
동 19
 
2.9%
터 18
 
2.7%
차 17
 
2.6%
Other values (138) 346
52.5%
Latin
ValueCountFrequency (%)
O 2
 
8.7%
M 2
 
8.7%
G 2
 
8.7%
a 2
 
8.7%
r 2
 
8.7%
e 2
 
8.7%
Y 1
 
4.3%
H 1
 
4.3%
J 1
 
4.3%
N 1
 
4.3%
Other values (7) 7
30.4%
Common
ValueCountFrequency (%)
10
71.4%
1 3
 
21.4%
2 1
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 658
94.5%
ASCII 37
 
5.3%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
비 55
 
8.4%
카 41
 
6.2%
정 40
 
6.1%
부 35
 
5.3%
분 33
 
5.0%
스 33
 
5.0%
대 22
 
3.3%
동 19
 
2.9%
터 18
 
2.7%
차 17
 
2.6%
Other values (137) 345
52.4%
ASCII
ValueCountFrequency (%)
10
27.0%
1 3
 
8.1%
O 2
 
5.4%
M 2
 
5.4%
G 2
 
5.4%
a 2
 
5.4%
r 2
 
5.4%
e 2
 
5.4%
Y 1
 
2.7%
H 1
 
2.7%
Other values (10) 10
27.0%
None
ValueCountFrequency (%)
㈜ 1
100.0%

자동차정비업체종류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size860.0 B
3
89 
1
 
1
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)2.2%

Sample

1st row1
2nd row2
3rd row3
4th row3
5th row3

Common Values

ValueCountFrequency (%)
3 89
97.8%
1 1
 
1.1%
2 1
 
1.1%

Length

2023-12-02T13:29:19.014086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-02T13:29:19.268215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 89
97.8%
1 1
 
1.1%
2 1
 
1.1%

소재지도로명주소
Text

UNIQUE 

Distinct91
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size860.0 B
2023-12-02T13:29:19.566794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length25
Mean length21.692308
Min length19

Characters and Unicode

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

Unique

Unique91 ?
Unique (%)100.0%

Sample

1st row대구광역시 남구 봉덕로 32(봉덕동)
2nd row대구광역시 남구 봉덕남로 142(봉덕동)
3rd row대구광역시 남구 성당로 158(대명동)
4th row대구광역시 남구 대명로 85(대명동)
5th row대구광역시 남구 대명로 28(대명동)
ValueCountFrequency (%)
대구광역시 91
24.9%
남구 91
24.9%
대명복개로 12
 
3.3%
현충로 9
 
2.5%
대명로 9
 
2.5%
이천로 5
 
1.4%
두류공원로 5
 
1.4%
성당로 5
 
1.4%
대명남로 4
 
1.1%
대경길 4
 
1.1%
Other values (108) 130
35.6%
2023-12-02T13:29:20.140109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
274
13.9%
대 191
 
9.7%
구 182
 
9.2%
남 97
 
4.9%
역 91
 
4.6%
시 91
 
4.6%
광 91
 
4.6%
( 91
 
4.6%
동 91
 
4.6%
) 91
 
4.6%
Other values (52) 684
34.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1245
63.1%
Space Separator 274
 
13.9%
Decimal Number 258
 
13.1%
Open Punctuation 91
 
4.6%
Close Punctuation 91
 
4.6%
Dash Punctuation 14
 
0.7%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 191
15.3%
구 182
14.6%
남 97
7.8%
역 91
7.3%
시 91
7.3%
광 91
7.3%
동 91
7.3%
명 87
7.0%
로 81
 
6.5%
봉 33
 
2.7%
Other values (37) 210
16.9%
Decimal Number
ValueCountFrequency (%)
1 69
26.7%
2 45
17.4%
6 24
 
9.3%
7 22
 
8.5%
8 21
 
8.1%
3 19
 
7.4%
4 18
 
7.0%
5 16
 
6.2%
0 13
 
5.0%
9 11
 
4.3%
Space Separator
ValueCountFrequency (%)
274
100.0%
Open Punctuation
ValueCountFrequency (%)
( 91
100.0%
Close Punctuation
ValueCountFrequency (%)
) 91
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1245
63.1%
Common 729
36.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 191
15.3%
구 182
14.6%
남 97
7.8%
역 91
7.3%
시 91
7.3%
광 91
7.3%
동 91
7.3%
명 87
7.0%
로 81
 
6.5%
봉 33
 
2.7%
Other values (37) 210
16.9%
Common
ValueCountFrequency (%)
274
37.6%
( 91
 
12.5%
) 91
 
12.5%
1 69
 
9.5%
2 45
 
6.2%
6 24
 
3.3%
7 22
 
3.0%
8 21
 
2.9%
3 19
 
2.6%
4 18
 
2.5%
Other values (5) 55
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1245
63.1%
ASCII 729
36.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
274
37.6%
( 91
 
12.5%
) 91
 
12.5%
1 69
 
9.5%
2 45
 
6.2%
6 24
 
3.3%
7 22
 
3.0%
8 21
 
2.9%
3 19
 
2.6%
4 18
 
2.5%
Other values (5) 55
 
7.5%
Hangul
ValueCountFrequency (%)
대 191
15.3%
구 182
14.6%
남 97
7.8%
역 91
7.3%
시 91
7.3%
광 91
7.3%
동 91
7.3%
명 87
7.0%
로 81
 
6.5%
봉 33
 
2.7%
Other values (37) 210
16.9%

소재지지번주소
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing90
Missing (%)98.9%
Memory size860.0 B
2023-12-02T13:29:20.328951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

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

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row대구광역시 남구 이천동 453-18
ValueCountFrequency (%)
대구광역시 1
25.0%
남구 1
25.0%
이천동 1
25.0%
453-18 1
25.0%
2023-12-02T13:29:20.658215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3
15.8%
구 2
 
10.5%
대 1
 
5.3%
광 1
 
5.3%
역 1
 
5.3%
시 1
 
5.3%
남 1
 
5.3%
이 1
 
5.3%
천 1
 
5.3%
동 1
 
5.3%
Other values (6) 6
31.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10
52.6%
Decimal Number 5
26.3%
Space Separator 3
 
15.8%
Dash Punctuation 1
 
5.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 2
20.0%
대 1
10.0%
광 1
10.0%
역 1
10.0%
시 1
10.0%
남 1
10.0%
이 1
10.0%
천 1
10.0%
동 1
10.0%
Decimal Number
ValueCountFrequency (%)
4 1
20.0%
5 1
20.0%
3 1
20.0%
1 1
20.0%
8 1
20.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10
52.6%
Common 9
47.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 2
20.0%
대 1
10.0%
광 1
10.0%
역 1
10.0%
시 1
10.0%
남 1
10.0%
이 1
10.0%
천 1
10.0%
동 1
10.0%
Common
ValueCountFrequency (%)
3
33.3%
4 1
 
11.1%
5 1
 
11.1%
3 1
 
11.1%
- 1
 
11.1%
1 1
 
11.1%
8 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10
52.6%
ASCII 9
47.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3
33.3%
4 1
 
11.1%
5 1
 
11.1%
3 1
 
11.1%
- 1
 
11.1%
1 1
 
11.1%
8 1
 
11.1%
Hangul
ValueCountFrequency (%)
구 2
20.0%
대 1
10.0%
광 1
10.0%
역 1
10.0%
시 1
10.0%
남 1
10.0%
이 1
10.0%
천 1
10.0%
동 1
10.0%

위도
Real number (ℝ)

Distinct90
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.843712
Minimum35.831554
Maximum35.858365
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size951.0 B
2023-12-02T13:29:20.872419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.831554
5-th percentile35.83418
Q135.840567
median35.84242
Q335.847677
95-th percentile35.85324
Maximum35.858365
Range0.02681094
Interquartile range (IQR)0.00710993

Descriptive statistics

Standard deviation0.0056773816
Coefficient of variation (CV)0.00015839268
Kurtosis-0.023198043
Mean35.843712
Median Absolute Deviation (MAD)0.00375765
Skewness0.19383922
Sum3261.7778
Variance3.2232661 × 10-5
MonotonicityNot monotonic
2023-12-02T13:29:21.077358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.84767574 2
 
2.2%
35.84477872 1
 
1.1%
35.83772108 1
 
1.1%
35.84718204 1
 
1.1%
35.84093751 1
 
1.1%
35.84242043 1
 
1.1%
35.84065271 1
 
1.1%
35.85110421 1
 
1.1%
35.84498811 1
 
1.1%
35.85446818 1
 
1.1%
Other values (80) 80
87.9%
ValueCountFrequency (%)
35.83155409 1
1.1%
35.83210169 1
1.1%
35.8321415 1
1.1%
35.83253172 1
1.1%
35.83369353 1
1.1%
35.83466549 1
1.1%
35.83541427 1
1.1%
35.83582445 1
1.1%
35.83663277 1
1.1%
35.83702672 1
1.1%
ValueCountFrequency (%)
35.85836503 1
1.1%
35.85780612 1
1.1%
35.85479743 1
1.1%
35.85446818 1
1.1%
35.85344867 1
1.1%
35.85303155 1
1.1%
35.85194856 1
1.1%
35.85190516 1
1.1%
35.85116809 1
1.1%
35.85110421 1
1.1%

경도
Real number (ℝ)

Distinct90
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.58171
Minimum128.55838
Maximum128.60499
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size951.0 B
2023-12-02T13:29:21.254238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.55838
5-th percentile128.56072
Q1128.56961
median128.58022
Q3128.596
95-th percentile128.60298
Maximum128.60499
Range0.046614
Interquartile range (IQR)0.02638385

Descriptive statistics

Standard deviation0.013688788
Coefficient of variation (CV)0.00010645984
Kurtosis-1.2368401
Mean128.58171
Median Absolute Deviation (MAD)0.0120507
Skewness0.12905504
Sum11700.935
Variance0.00018738291
MonotonicityNot monotonic
2023-12-02T13:29:21.477984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.5841726 2
 
2.2%
128.5938929 1
 
1.1%
128.577336 1
 
1.1%
128.5963574 1
 
1.1%
128.5831931 1
 
1.1%
128.580359 1
 
1.1%
128.6042952 1
 
1.1%
128.5860797 1
 
1.1%
128.5749755 1
 
1.1%
128.6028778 1
 
1.1%
Other values (80) 80
87.9%
ValueCountFrequency (%)
128.5583796 1
1.1%
128.5591873 1
1.1%
128.5599401 1
1.1%
128.5604236 1
1.1%
128.560579 1
1.1%
128.5608679 1
1.1%
128.5618262 1
1.1%
128.5634405 1
1.1%
128.5638176 1
1.1%
128.5644852 1
1.1%
ValueCountFrequency (%)
128.6049936 1
1.1%
128.6042952 1
1.1%
128.6042541 1
1.1%
128.6033056 1
1.1%
128.6030804 1
1.1%
128.6028778 1
1.1%
128.6019282 1
1.1%
128.6007109 1
1.1%
128.6005079 1
1.1%
128.6003601 1
1.1%

사업등록일자
Date

Distinct87
Distinct (%)95.6%
Missing0
Missing (%)0.0%
Memory size860.0 B
Minimum1975-05-15 00:00:00
Maximum2023-02-13 00:00:00
2023-12-02T13:29:21.676518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:21.871053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

면적
Real number (ℝ)

HIGH CORRELATION 

Distinct72
Distinct (%)79.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean216.2967
Minimum71
Maximum1926
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size951.0 B
2023-12-02T13:29:22.099050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum71
5-th percentile78
Q198.5
median140
Q3221.5
95-th percentile523
Maximum1926
Range1855
Interquartile range (IQR)123

Descriptive statistics

Standard deviation263.51839
Coefficient of variation (CV)1.2183191
Kurtosis26.762234
Mean216.2967
Median Absolute Deviation (MAD)50
Skewness4.7960669
Sum19683
Variance69441.944
MonotonicityNot monotonic
2023-12-02T13:29:22.987460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99 3
 
3.3%
189 3
 
3.3%
110 3
 
3.3%
108 2
 
2.2%
548 2
 
2.2%
89 2
 
2.2%
173 2
 
2.2%
91 2
 
2.2%
160 2
 
2.2%
98 2
 
2.2%
Other values (62) 68
74.7%
ValueCountFrequency (%)
71 1
1.1%
73 1
1.1%
76 2
2.2%
78 2
2.2%
80 2
2.2%
81 1
1.1%
82 1
1.1%
86 1
1.1%
88 2
2.2%
89 2
2.2%
ValueCountFrequency (%)
1926 1
1.1%
1582 1
1.1%
683 1
1.1%
548 2
2.2%
498 1
1.1%
481 1
1.1%
474 1
1.1%
462 1
1.1%
398 1
1.1%
357 1
1.1%

영업상태
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size860.0 B
1
91 

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

Length

2023-12-02T13:29:23.194585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-02T13:29:23.369709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 91
100.0%

폐업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing91
Missing (%)100.0%
Memory size951.0 B

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing91
Missing (%)100.0%
Memory size951.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing91
Missing (%)100.0%
Memory size951.0 B

운영시작시각
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing91
Missing (%)100.0%
Memory size951.0 B

운영종료시각
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing91
Missing (%)100.0%
Memory size951.0 B

전화번호
Text

MISSING 

Distinct89
Distinct (%)100.0%
Missing2
Missing (%)2.2%
Memory size860.0 B
2023-12-02T13:29:23.713358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique89 ?
Unique (%)100.0%

Sample

1st row053-471-6611
2nd row053-471-5303
3rd row053-624-1735
4th row053-653-8285
5th row053-624-8204
ValueCountFrequency (%)
053-476-7779 1
 
1.1%
053-623-8204 1
 
1.1%
053-565-7976 1
 
1.1%
053-621-1571 1
 
1.1%
053-475-3084 1
 
1.1%
053-746-3444 1
 
1.1%
053-266-7006 1
 
1.1%
053-473-6665 1
 
1.1%
053-475-0982 1
 
1.1%
053-471-4108 1
 
1.1%
Other values (79) 79
88.8%
2023-12-02T13:29:24.324142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 178
16.7%
5 156
14.6%
3 136
12.7%
0 135
12.6%
6 106
9.9%
7 78
7.3%
2 78
7.3%
4 70
 
6.6%
1 55
 
5.1%
8 41
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 890
83.3%
Dash Punctuation 178
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 156
17.5%
3 136
15.3%
0 135
15.2%
6 106
11.9%
7 78
8.8%
2 78
8.8%
4 70
7.9%
1 55
 
6.2%
8 41
 
4.6%
9 35
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 178
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1068
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 178
16.7%
5 156
14.6%
3 136
12.7%
0 135
12.6%
6 106
9.9%
7 78
7.3%
2 78
7.3%
4 70
 
6.6%
1 55
 
5.1%
8 41
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1068
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 178
16.7%
5 156
14.6%
3 136
12.7%
0 135
12.6%
6 106
9.9%
7 78
7.3%
2 78
7.3%
4 70
 
6.6%
1 55
 
5.1%
8 41
 
3.8%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size860.0 B
대구광역시 남구청
91 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대구광역시 남구청
2nd row대구광역시 남구청
3rd row대구광역시 남구청
4th row대구광역시 남구청
5th row대구광역시 남구청

Common Values

ValueCountFrequency (%)
대구광역시 남구청 91
100.0%

Length

2023-12-02T13:29:24.513927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-02T13:29:24.631228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대구광역시 91
50.0%
남구청 91
50.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size860.0 B
053-664-3046
91 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row053-664-3046
2nd row053-664-3046
3rd row053-664-3046
4th row053-664-3046
5th row053-664-3046

Common Values

ValueCountFrequency (%)
053-664-3046 91
100.0%

Length

2023-12-02T13:29:24.750772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-02T13:29:24.861125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
053-664-3046 91
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size860.0 B
2023-11-08
91 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-08
2nd row2023-11-08
3rd row2023-11-08
4th row2023-11-08
5th row2023-11-08

Common Values

ValueCountFrequency (%)
2023-11-08 91
100.0%

Length

2023-12-02T13:29:24.968095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-02T13:29:25.064446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-08 91
100.0%

Interactions

2023-12-02T13:29:16.024235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:15.255336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:15.633677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:16.150811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:15.388216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:15.815198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:16.277993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:15.506793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-02T13:29:15.913727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-02T13:29:25.264357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
자동차정비업체명자동차정비업체종류소재지도로명주소위도경도사업등록일자면적전화번호
자동차정비업체명1.0001.0001.0001.0001.0001.0001.0001.000
자동차정비업체종류1.0001.0001.0000.0000.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.0001.0001.0001.0001.000
위도1.0000.0001.0001.0000.6810.9610.0001.000
경도1.0000.0001.0000.6811.0000.8520.1271.000
사업등록일자1.0001.0001.0000.9610.8521.0001.0001.000
면적1.0001.0001.0000.0000.1271.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.0001.0001.000
2023-12-02T13:29:25.769543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도면적자동차정비업체종류
위도1.0000.463-0.0760.000
경도0.4631.0000.0090.000
면적-0.0760.0091.0000.983
자동차정비업체종류0.0000.0000.9831.000

Missing values

2023-12-02T13:29:16.508922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-02T13:29:16.836614image/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.
2023-12-02T13:29:17.084385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

자동차정비업체명자동차정비업체종류소재지도로명주소소재지지번주소위도경도사업등록일자면적영업상태폐업일자휴업시작일자휴업종료일자운영시작시각운영종료시각전화번호관리기관명관리기관전화번호데이터기준일자
0중대구현대서비스1대구광역시 남구 봉덕로 32(봉덕동)<NA>35.844779128.5938931975-05-1519261<NA><NA><NA><NA><NA>053-471-6611대구광역시 남구청053-664-30462023-11-08
1산호자동차정비공장2대구광역시 남구 봉덕남로 142(봉덕동)<NA>35.841279128.5963391991-12-2715821<NA><NA><NA><NA><NA>053-471-5303대구광역시 남구청053-664-30462023-11-08
2삼양카써비스센타3대구광역시 남구 성당로 158(대명동)<NA>35.848447128.569721997-07-311701<NA><NA><NA><NA><NA>053-624-1735대구광역시 남구청053-664-30462023-11-08
3대명점기아오토큐3대구광역시 남구 대명로 85(대명동)<NA>35.839851128.5672341999-07-231931<NA><NA><NA><NA><NA>053-653-8285대구광역시 남구청053-664-30462023-11-08
4현대자동차대명점3대구광역시 남구 대명로 28(대명동)<NA>35.837963128.5605791999-09-036831<NA><NA><NA><NA><NA>053-624-8204대구광역시 남구청053-664-30462023-11-08
5영광카센타3대구광역시 남구 신촌길 21(봉덕동)<NA>35.8385128.6000561998-10-24801<NA><NA><NA><NA><NA>053-475-3167대구광역시 남구청053-664-30462023-11-08
6안전카써비스3대구광역시 남구 안지랑로 13(대명동)<NA>35.832532128.5712111998-10-301191<NA><NA><NA><NA><NA>053-652-2324대구광역시 남구청053-664-30462023-11-08
7스피드메이트대구제일점3대구광역시 남구 대명로 226(대명동)<NA>35.840539128.5817841998-11-161541<NA><NA><NA><NA><NA>053-626-0079대구광역시 남구청053-664-30462023-11-08
8아세아카센타3대구광역시 남구 현충로 134(대명동)<NA>35.844683128.5803311998-11-18881<NA><NA><NA><NA><NA>053-652-6493대구광역시 남구청053-664-30462023-11-08
9보성카센타3대구광역시 남구 대경길 253(대명동)<NA>35.847928128.5766241998-11-18761<NA><NA><NA><NA><NA>053-654-0733대구광역시 남구청053-664-30462023-11-08
자동차정비업체명자동차정비업체종류소재지도로명주소소재지지번주소위도경도사업등록일자면적영업상태폐업일자휴업시작일자휴업종료일자운영시작시각운영종료시각전화번호관리기관명관리기관전화번호데이터기준일자
81복과장카정비3대구광역시 남구 희망로 60(이천동)<NA>35.847346128.6049942015-03-131601<NA><NA><NA><NA><NA>053-768-4422대구광역시 남구청053-664-30462023-11-08
82명전카 자동차정비3대구광역시 남구 대명복개로 31(대명동)<NA>35.839692128.5608682015-11-181081<NA><NA><NA><NA><NA>053-656-9703대구광역시 남구청053-664-30462023-11-08
83그린모터스3대구광역시 남구 대봉로 84(이천동)<NA>35.846178128.6042542017-01-131721<NA><NA><NA><NA><NA>053-311-5760대구광역시 남구청053-664-30462023-11-08
84신동아카써비스3대구광역시 남구 이천로 61(봉덕동)<NA>35.846777128.5980812017-03-312551<NA><NA><NA><NA><NA>053-473-1336대구광역시 남구청053-664-30462023-11-08
85루미노스3대구광역시 남구 봉덕로9길 96(봉덕동)<NA>35.848833128.5975442019-07-254811<NA><NA><NA><NA><NA>053-474-0129대구광역시 남구청053-664-30462023-11-08
86대성오토3대구광역시 남구 대명복개로 51(대명동)<NA>35.840172128.5618262020-01-031731<NA><NA><NA><NA><NA><NA>대구광역시 남구청053-664-30462023-11-08
87아너스오토3대구광역시 남구 이천로19길 62-6(이천동)대구광역시 남구 이천동 453-1835.849985128.5956562021-06-232001<NA><NA><NA><NA><NA>053-761-0202대구광역시 남구청053-664-30462023-11-08
88중앙모터스㈜ 대구남구점3대구광역시 남구 현충로 170, 1층(대명동)<NA>35.847676128.5841732021-08-273981<NA><NA><NA><NA><NA>053-553-4400대구광역시 남구청053-664-30462023-11-08
89레드라인3대구광역시 남구 두류공원로 32-1(대명동)<NA>35.841216128.5740072022-07-291401<NA><NA><NA><NA><NA>053-655-0470대구광역시 남구청053-664-30462023-11-08
90예인오토 리페어샵3대구광역시 남구 대덕로 143(봉덕동)<NA>35.841178128.5985042023-02-13891<NA><NA><NA><NA><NA>053-201-1777대구광역시 남구청053-664-30462023-11-08