Overview

Dataset statistics

Number of variables7
Number of observations24
Missing cells5
Missing cells (%)3.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory63.5 B

Variable types

Text3
Categorical1
Numeric2
DateTime1

Dataset

Description서산시에 소재한 자동차 매매업체 등록현황으로 업체명, 대표자, 소재지, 전화번호, 위치에 대한 정보를 제공합니다.
Author충청남도 서산시
URLhttps://www.data.go.kr/data/15000681/fileData.do

Alerts

데이터기준일 has constant value ""Constant
위도 is highly overall correlated with 경도 and 1 other fieldsHigh correlation
경도 is highly overall correlated with 위도 and 1 other fieldsHigh correlation
소재지 is highly overall correlated with 위도 and 1 other fieldsHigh correlation
전화번호 has 1 (4.2%) missing valuesMissing
위도 has 2 (8.3%) missing valuesMissing
경도 has 2 (8.3%) missing valuesMissing
업체명 has unique valuesUnique
대표자 has unique valuesUnique

Reproduction

Analysis started2023-12-12 03:23:52.517845
Analysis finished2023-12-12 03:23:53.593182
Duration1.08 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-12T12:23:53.769160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length8.125
Min length4

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)100.0%

Sample

1st row123모터스매매상사
2nd row감자매매상사
3rd row국제자동차매매상사
4th row남부자동차매매상사
5th row대명자동차매매상사
ValueCountFrequency (%)
123모터스매매상사 1
 
4.2%
감자매매상사 1
 
4.2%
한성자동차매매상사 1
 
4.2%
태양자동차매매상사 1
 
4.2%
진성자동차매매상사 1
 
4.2%
종현상사 1
 
4.2%
전국자동차매매상사 1
 
4.2%
일등자동차매매상사 1
 
4.2%
유일자동차매매상사 1
 
4.2%
우리자동차매매상사 1
 
4.2%
Other values (14) 14
58.3%
2023-12-12T12:23:54.234582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
매 38
19.5%
사 22
11.3%
상 21
10.8%
자 18
9.2%
동 18
9.2%
차 17
 
8.7%
스 5
 
2.6%
서 5
 
2.6%
대 4
 
2.1%
터 3
 
1.5%
Other values (35) 44
22.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 192
98.5%
Decimal Number 3
 
1.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
매 38
19.8%
사 22
11.5%
상 21
10.9%
자 18
9.4%
동 18
9.4%
차 17
8.9%
스 5
 
2.6%
서 5
 
2.6%
대 4
 
2.1%
터 3
 
1.6%
Other values (32) 41
21.4%
Decimal Number
ValueCountFrequency (%)
1 1
33.3%
2 1
33.3%
3 1
33.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 192
98.5%
Common 3
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
매 38
19.8%
사 22
11.5%
상 21
10.9%
자 18
9.4%
동 18
9.4%
차 17
8.9%
스 5
 
2.6%
서 5
 
2.6%
대 4
 
2.1%
터 3
 
1.6%
Other values (32) 41
21.4%
Common
ValueCountFrequency (%)
1 1
33.3%
2 1
33.3%
3 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 192
98.5%
ASCII 3
 
1.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
매 38
19.8%
사 22
11.5%
상 21
10.9%
자 18
9.4%
동 18
9.4%
차 17
8.9%
스 5
 
2.6%
서 5
 
2.6%
대 4
 
2.1%
터 3
 
1.6%
Other values (32) 41
21.4%
ASCII
ValueCountFrequency (%)
1 1
33.3%
2 1
33.3%
3 1
33.3%

대표자
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-12T12:23:54.459521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)100.0%

Sample

1st row오병진
2nd row김민권
3rd row김시용
4th row이창한
5th row송태자
ValueCountFrequency (%)
오병진 1
 
4.2%
김민권 1
 
4.2%
이세림 1
 
4.2%
김달형 1
 
4.2%
정창대 1
 
4.2%
김종현 1
 
4.2%
이기양 1
 
4.2%
문성환 1
 
4.2%
조한승 1
 
4.2%
최웅엽 1
 
4.2%
Other values (14) 14
58.3%
2023-12-12T12:23:54.850086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 7
 
9.7%
이 6
 
8.3%
종 3
 
4.2%
한 3
 
4.2%
성 2
 
2.8%
태 2
 
2.8%
정 2
 
2.8%
승 2
 
2.8%
환 2
 
2.8%
신 2
 
2.8%
Other values (37) 41
56.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 72
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 7
 
9.7%
이 6
 
8.3%
종 3
 
4.2%
한 3
 
4.2%
성 2
 
2.8%
태 2
 
2.8%
정 2
 
2.8%
승 2
 
2.8%
환 2
 
2.8%
신 2
 
2.8%
Other values (37) 41
56.9%

Most occurring scripts

ValueCountFrequency (%)
Hangul 72
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 7
 
9.7%
이 6
 
8.3%
종 3
 
4.2%
한 3
 
4.2%
성 2
 
2.8%
태 2
 
2.8%
정 2
 
2.8%
승 2
 
2.8%
환 2
 
2.8%
신 2
 
2.8%
Other values (37) 41
56.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 72
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 7
 
9.7%
이 6
 
8.3%
종 3
 
4.2%
한 3
 
4.2%
성 2
 
2.8%
태 2
 
2.8%
정 2
 
2.8%
승 2
 
2.8%
환 2
 
2.8%
신 2
 
2.8%
Other values (37) 41
56.9%

소재지
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)45.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
충청남도 서산시 중앙로 532(수석동)
8 
충청남도 서산시 한성지2길 6(수석동)
6 
충청남도 서산시 팔봉면 팔봉2로 194-12
2 
충청남도 서산시 안견로 585, 2동 128호
1 
충청남도 서산시 문화로 64(읍내동)
1 
Other values (6)
6 

Length

Max length25
Median length21
Mean length21.541667
Min length20

Unique

Unique8 ?
Unique (%)33.3%

Sample

1st row충청남도 서산시 안견로 585, 2동 128호
2nd row충청남도 서산시 중앙로 532(수석동)
3rd row충청남도 서산시 한성지2길 6(수석동)
4th row충청남도 서산시 한성지2길 6(수석동)
5th row충청남도 서산시 한성지2길 6(수석동)

Common Values

ValueCountFrequency (%)
충청남도 서산시 중앙로 532(수석동) 8
33.3%
충청남도 서산시 한성지2길 6(수석동) 6
25.0%
충청남도 서산시 팔봉면 팔봉2로 194-12 2
 
8.3%
충청남도 서산시 안견로 585, 2동 128호 1
 
4.2%
충청남도 서산시 문화로 64(읍내동) 1
 
4.2%
충청남도 서산시 지곡면 충의로 1585 1
 
4.2%
충청남도 서산시 소탐6길 57(수석동) 1
 
4.2%
충청남도 서산시 한성지2길 42(수석동) 1
 
4.2%
충청남도 서산시 지곡면 충의로 1309-3 1
 
4.2%
충청남도 서산시 지곡면 충의로 1309 1
 
4.2%

Length

2023-12-12T12:23:55.008136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
충청남도 24
23.3%
서산시 24
23.3%
중앙로 8
 
7.8%
532(수석동 8
 
7.8%
한성지2길 7
 
6.8%
6(수석동 6
 
5.8%
지곡면 3
 
2.9%
충의로 3
 
2.9%
팔봉2로 2
 
1.9%
팔봉면 2
 
1.9%
Other values (15) 16
15.5%

전화번호
Text

MISSING 

Distinct23
Distinct (%)100.0%
Missing1
Missing (%)4.2%
Memory size324.0 B
2023-12-12T12:23:55.236511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique23 ?
Unique (%)100.0%

Sample

1st row041-667-5514
2nd row041-662-1212
3rd row041-667-2233
4th row041-667-8949
5th row041-667-4800
ValueCountFrequency (%)
041-667-5514 1
 
4.3%
041-681-7678 1
 
4.3%
041-666-5533 1
 
4.3%
041-662-8956 1
 
4.3%
041-667-0055 1
 
4.3%
041-668-8813 1
 
4.3%
041-662-8872 1
 
4.3%
041-669-4985 1
 
4.3%
041-681-8080 1
 
4.3%
041-681-5599 1
 
4.3%
Other values (13) 13
56.5%
2023-12-12T12:23:55.628142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 50
18.1%
- 46
16.7%
0 37
13.4%
1 33
12.0%
4 30
10.9%
8 21
7.6%
7 14
 
5.1%
5 13
 
4.7%
2 12
 
4.3%
9 11
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 230
83.3%
Dash Punctuation 46
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 50
21.7%
0 37
16.1%
1 33
14.3%
4 30
13.0%
8 21
9.1%
7 14
 
6.1%
5 13
 
5.7%
2 12
 
5.2%
9 11
 
4.8%
3 9
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 276
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 50
18.1%
- 46
16.7%
0 37
13.4%
1 33
12.0%
4 30
10.9%
8 21
7.6%
7 14
 
5.1%
5 13
 
4.7%
2 12
 
4.3%
9 11
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 276
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 50
18.1%
- 46
16.7%
0 37
13.4%
1 33
12.0%
4 30
10.9%
8 21
7.6%
7 14
 
5.1%
5 13
 
4.7%
2 12
 
4.3%
9 11
 
4.0%

위도
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct11
Distinct (%)50.0%
Missing2
Missing (%)8.3%
Infinite0
Infinite (%)0.0%
Mean36.775971
Minimum36.752897
Maximum36.907887
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T12:23:55.781687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.752897
5-th percentile36.752897
Q136.752897
median36.76439
Q336.779305
95-th percentile36.878297
Maximum36.907887
Range0.15499
Interquartile range (IQR)0.02640775

Descriptive statistics

Standard deviation0.040742371
Coefficient of variation (CV)0.001107853
Kurtosis6.5418818
Mean36.775971
Median Absolute Deviation (MAD)0.0114925
Skewness2.6392066
Sum809.07135
Variance0.0016599408
MonotonicityNot monotonic
2023-12-12T12:23:55.920732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
36.752897 8
33.3%
36.764508 5
20.8%
36.79309 1
 
4.2%
36.786825 1
 
4.2%
36.907887 1
 
4.2%
36.784375 1
 
4.2%
36.764271 1
 
4.2%
36.760033 1
 
4.2%
36.784237 1
 
4.2%
36.762139 1
 
4.2%
(Missing) 2
 
8.3%
ValueCountFrequency (%)
36.752897 8
33.3%
36.760033 1
 
4.2%
36.762139 1
 
4.2%
36.764271 1
 
4.2%
36.764508 5
20.8%
36.784237 1
 
4.2%
36.784375 1
 
4.2%
36.786825 1
 
4.2%
36.79309 1
 
4.2%
36.882782 1
 
4.2%
ValueCountFrequency (%)
36.907887 1
 
4.2%
36.882782 1
 
4.2%
36.79309 1
 
4.2%
36.786825 1
 
4.2%
36.784375 1
 
4.2%
36.784237 1
 
4.2%
36.764508 5
20.8%
36.764271 1
 
4.2%
36.762139 1
 
4.2%
36.760033 1
 
4.2%

경도
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct11
Distinct (%)50.0%
Missing2
Missing (%)8.3%
Infinite0
Infinite (%)0.0%
Mean126.46954
Minimum126.36771
Maximum126.4979
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T12:23:56.075125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.36771
5-th percentile126.37124
Q1126.45584
median126.47976
Q3126.4979
95-th percentile126.4979
Maximum126.4979
Range0.130198
Interquartile range (IQR)0.04206775

Descriptive statistics

Standard deviation0.038812583
Coefficient of variation (CV)0.00030689274
Kurtosis2.7413046
Mean126.46954
Median Absolute Deviation (MAD)0.018142
Skewness-1.8027316
Sum2782.3298
Variance0.0015064166
MonotonicityNot monotonic
2023-12-12T12:23:56.200162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
126.497904 8
33.3%
126.479762 5
20.8%
126.434393 1
 
4.2%
126.447863 1
 
4.2%
126.440288 1
 
4.2%
126.367921 1
 
4.2%
126.479756 1
 
4.2%
126.486446 1
 
4.2%
126.367706 1
 
4.2%
126.482979 1
 
4.2%
(Missing) 2
 
8.3%
ValueCountFrequency (%)
126.367706 1
 
4.2%
126.367921 1
 
4.2%
126.434393 1
 
4.2%
126.440288 1
 
4.2%
126.440421 1
 
4.2%
126.447863 1
 
4.2%
126.479756 1
 
4.2%
126.479762 5
20.8%
126.482979 1
 
4.2%
126.486446 1
 
4.2%
ValueCountFrequency (%)
126.497904 8
33.3%
126.486446 1
 
4.2%
126.482979 1
 
4.2%
126.479762 5
20.8%
126.479756 1
 
4.2%
126.447863 1
 
4.2%
126.440421 1
 
4.2%
126.440288 1
 
4.2%
126.434393 1
 
4.2%
126.367921 1
 
4.2%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
Minimum2021-09-29 00:00:00
Maximum2021-09-29 00:00:00
2023-12-12T12:23:56.305286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:23:56.409452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T12:23:53.030368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:23:52.815655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:23:53.136753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:23:52.931814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:23:56.518239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명대표자소재지전화번호위도경도
업체명1.0001.0001.0001.0001.0001.000
대표자1.0001.0001.0001.0001.0001.000
소재지1.0001.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
위도1.0001.0001.0001.0001.0000.689
경도1.0001.0001.0001.0000.6891.000
2023-12-12T12:23:56.657664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도소재지
위도1.000-0.9480.850
경도-0.9481.0000.874
소재지0.8500.8741.000

Missing values

2023-12-12T12:23:53.285331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:23:53.424139image/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-12T12:23:53.528632image/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

업체명대표자소재지전화번호위도경도데이터기준일
0123모터스매매상사오병진충청남도 서산시 안견로 585, 2동 128호041-667-551436.79309126.4343932021-09-29
1감자매매상사김민권충청남도 서산시 중앙로 532(수석동)041-662-121236.752897126.4979042021-09-29
2국제자동차매매상사김시용충청남도 서산시 한성지2길 6(수석동)041-667-223336.764508126.4797622021-09-29
3남부자동차매매상사이창한충청남도 서산시 한성지2길 6(수석동)041-667-894936.764508126.4797622021-09-29
4대명자동차매매상사송태자충청남도 서산시 한성지2길 6(수석동)041-667-480036.764508126.4797622021-09-29
5대성자동차매매상사한상영충청남도 서산시 문화로 64(읍내동)041-665-794136.786825126.4478632021-09-29
6대원자동차매매상사신백희충청남도 서산시 중앙로 532(수석동)041-665-600136.752897126.4979042021-09-29
7백마공업사이광신충청남도 서산시 지곡면 충의로 1585041-663-377736.907887126.4402882021-09-29
8서동자동차매매상사김재환충청남도 서산시 팔봉면 팔봉2로 194-12041-668-030836.784375126.3679212021-09-29
9서령자동차매매상사반용인충청남도 서산시 한성지2길 6(수석동)041-667-600036.764271126.4797562021-09-29
업체명대표자소재지전화번호위도경도데이터기준일
14에스에스모터스강영숙충청남도 서산시 지곡면 충의로 1309-3<NA><NA><NA>2021-09-29
15우리자동차매매상사최웅엽충청남도 서산시 중앙로 532(수석동)041-681-559936.752897126.4979042021-09-29
16유일자동차매매상사조한승충청남도 서산시 지곡면 충의로 1309041-681-808036.882782126.4404212021-09-29
17일등자동차매매상사문성환충청남도 서산시 중앙로 532(수석동)041-669-498536.752897126.4979042021-09-29
18전국자동차매매상사이기양충청남도 서산시 중앙로 532(수석동)041-662-887236.752897126.4979042021-09-29
19종현상사김종현충청남도 서산시 중앙로 532(수석동)041-668-881336.752897126.4979042021-09-29
20진성자동차매매상사정창대충청남도 서산시 한성지2길 6(수석동)041-667-005536.764508126.4797622021-09-29
21태양자동차매매상사김달형충청남도 서산시 한성지2길 6(수석동)041-662-895636.764508126.4797622021-09-29
22한성자동차매매상사이세림충청남도 서산시 덕치천로 254(오남동)041-666-5533<NA><NA>2021-09-29
23현대자동차매매상사김성태충청남도 서산시 중앙로 532(수석동)041-666-031536.752897126.4979042021-09-29