Overview

Dataset statistics

Number of variables5
Number of observations120
Missing cells38
Missing cells (%)6.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.9 KiB
Average record size in memory42.1 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description인천광역시 서구에 위치한 중고자동차매매업등록현황에 관한 데이터셋입니다. 인천광역시 서구에 위치한 중고자동차매매업등록현황의 상호명, 소재지, 전화번호에 관한 정보를 포함하고 있습니다.
Author인천광역시 서구
URLhttps://www.data.go.kr/data/15090870/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 38 (31.7%) missing valuesMissing
연번 has unique valuesUnique
상호명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:34:09.471913
Analysis finished2023-12-12 19:34:10.265470
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct120
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean61.575
Minimum1
Maximum122
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-13T04:34:10.336343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.95
Q131.75
median61.5
Q391.25
95-th percentile116.05
Maximum122
Range121
Interquartile range (IQR)59.5

Descriptive statistics

Standard deviation35.194218
Coefficient of variation (CV)0.57156668
Kurtosis-1.1773883
Mean61.575
Median Absolute Deviation (MAD)30
Skewness0.0037815171
Sum7389
Variance1238.633
MonotonicityStrictly increasing
2023-12-13T04:34:10.468425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
63 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
87 1
 
0.8%
86 1
 
0.8%
85 1
 
0.8%
84 1
 
0.8%
Other values (110) 110
91.7%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
122 1
0.8%
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%
117 1
0.8%
116 1
0.8%
115 1
0.8%
114 1
0.8%
113 1
0.8%

상호명
Text

UNIQUE 

Distinct120
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-13T04:34:10.688672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length13
Mean length8.2333333
Min length2

Characters and Unicode

Total characters988
Distinct characters182
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

Unique120 ?
Unique (%)100.0%

Sample

1st row(주)시우자동차
2nd rowS&K모터스자동차매매상사
3rd row엠파크㈜
4th row유성모터스
5th row조이카모터스자동차매매상사
ValueCountFrequency (%)
주식회사 25
 
15.6%
모터스 3
 
1.9%
엠파크㈜ 2
 
1.2%
오토허브 2
 
1.2%
모터바겐 1
 
0.6%
오토팰리스 1
 
0.6%
올바른자동차 1
 
0.6%
bt모터스 1
 
0.6%
착한중고차 1
 
0.6%
와이에스모터스 1
 
0.6%
Other values (122) 122
76.2%
2023-12-13T04:34:11.058962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 71
 
7.2%
터 56
 
5.7%
모 55
 
5.6%
사 53
 
5.4%
매 42
 
4.3%
주 41
 
4.1%
40
 
4.0%
차 36
 
3.6%
식 27
 
2.7%
회 27
 
2.7%
Other values (172) 540
54.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 889
90.0%
Space Separator 40
 
4.0%
Open Punctuation 15
 
1.5%
Close Punctuation 15
 
1.5%
Uppercase Letter 14
 
1.4%
Other Symbol 11
 
1.1%
Decimal Number 3
 
0.3%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 71
 
8.0%
터 56
 
6.3%
모 55
 
6.2%
사 53
 
6.0%
매 42
 
4.7%
주 41
 
4.6%
차 36
 
4.0%
식 27
 
3.0%
회 27
 
3.0%
동 26
 
2.9%
Other values (153) 455
51.2%
Uppercase Letter
ValueCountFrequency (%)
A 2
14.3%
G 2
14.3%
K 2
14.3%
T 1
7.1%
B 1
7.1%
S 1
7.1%
N 1
7.1%
I 1
7.1%
M 1
7.1%
J 1
7.1%
Decimal Number
ValueCountFrequency (%)
3 1
33.3%
2 1
33.3%
1 1
33.3%
Space Separator
ValueCountFrequency (%)
40
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 11
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 900
91.1%
Common 74
 
7.5%
Latin 14
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 71
 
7.9%
터 56
 
6.2%
모 55
 
6.1%
사 53
 
5.9%
매 42
 
4.7%
주 41
 
4.6%
차 36
 
4.0%
식 27
 
3.0%
회 27
 
3.0%
동 26
 
2.9%
Other values (154) 466
51.8%
Latin
ValueCountFrequency (%)
A 2
14.3%
G 2
14.3%
K 2
14.3%
T 1
7.1%
B 1
7.1%
S 1
7.1%
N 1
7.1%
I 1
7.1%
M 1
7.1%
J 1
7.1%
Common
ValueCountFrequency (%)
40
54.1%
( 15
 
20.3%
) 15
 
20.3%
& 1
 
1.4%
3 1
 
1.4%
2 1
 
1.4%
1 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 889
90.0%
ASCII 88
 
8.9%
None 11
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 71
 
8.0%
터 56
 
6.3%
모 55
 
6.2%
사 53
 
6.0%
매 42
 
4.7%
주 41
 
4.6%
차 36
 
4.0%
식 27
 
3.0%
회 27
 
3.0%
동 26
 
2.9%
Other values (153) 455
51.2%
ASCII
ValueCountFrequency (%)
40
45.5%
( 15
 
17.0%
) 15
 
17.0%
A 2
 
2.3%
G 2
 
2.3%
K 2
 
2.3%
T 1
 
1.1%
B 1
 
1.1%
S 1
 
1.1%
& 1
 
1.1%
Other values (8) 8
 
9.1%
None
ValueCountFrequency (%)
㈜ 11
100.0%

소재지
Text

Distinct117
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-13T04:34:11.380649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length47
Mean length35.25
Min length22

Characters and Unicode

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

Unique

Unique114 ?
Unique (%)95.0%

Sample

1st row인천광역시 서구 염곡로 52, 324호 (가좌동, 엠파크허브)
2nd row인천광역시 서구 봉수대로 158, S113호 (가좌동, 엠파크타워)
3rd row인천광역시 서구 염곡로 52, 300호 (가좌동, 엠파크허브)
4th row인천광역시 서구 봉수대로 158, S120호 (가좌동, 엠파크타워)
5th row인천광역시 서구 봉수대로 158, S074호 (가좌동, 엠파크타워)
ValueCountFrequency (%)
인천광역시 120
15.0%
서구 120
15.0%
가좌동 76
9.5%
봉수대로 59
7.4%
엠파크타워 59
7.4%
158 59
7.4%
염곡로 55
 
6.9%
엠파크허브 53
 
6.6%
52 51
 
6.4%
엠파크랜드 3
 
0.4%
Other values (138) 144
18.0%
2023-12-13T04:34:11.893911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
679
 
16.1%
, 238
 
5.6%
5 128
 
3.0%
1 124
 
2.9%
서 121
 
2.9%
로 120
 
2.8%
천 120
 
2.8%
인 120
 
2.8%
구 120
 
2.8%
시 120
 
2.8%
Other values (50) 2340
55.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2316
54.8%
Decimal Number 687
 
16.2%
Space Separator 679
 
16.1%
Other Punctuation 238
 
5.6%
Open Punctuation 119
 
2.8%
Close Punctuation 119
 
2.8%
Uppercase Letter 71
 
1.7%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 121
 
5.2%
로 120
 
5.2%
천 120
 
5.2%
인 120
 
5.2%
구 120
 
5.2%
시 120
 
5.2%
광 120
 
5.2%
역 120
 
5.2%
호 119
 
5.1%
동 119
 
5.1%
Other values (29) 1117
48.2%
Decimal Number
ValueCountFrequency (%)
5 128
18.6%
1 124
18.0%
2 108
15.7%
0 99
14.4%
8 84
12.2%
3 67
9.8%
4 23
 
3.3%
7 22
 
3.2%
6 17
 
2.5%
9 15
 
2.2%
Uppercase Letter
ValueCountFrequency (%)
S 62
87.3%
C 2
 
2.8%
A 2
 
2.8%
F 2
 
2.8%
D 2
 
2.8%
B 1
 
1.4%
Space Separator
ValueCountFrequency (%)
679
100.0%
Other Punctuation
ValueCountFrequency (%)
, 238
100.0%
Open Punctuation
ValueCountFrequency (%)
( 119
100.0%
Close Punctuation
ValueCountFrequency (%)
) 119
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2316
54.8%
Common 1843
43.6%
Latin 71
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 121
 
5.2%
로 120
 
5.2%
천 120
 
5.2%
인 120
 
5.2%
구 120
 
5.2%
시 120
 
5.2%
광 120
 
5.2%
역 120
 
5.2%
호 119
 
5.1%
동 119
 
5.1%
Other values (29) 1117
48.2%
Common
ValueCountFrequency (%)
679
36.8%
, 238
 
12.9%
5 128
 
6.9%
1 124
 
6.7%
( 119
 
6.5%
) 119
 
6.5%
2 108
 
5.9%
0 99
 
5.4%
8 84
 
4.6%
3 67
 
3.6%
Other values (5) 78
 
4.2%
Latin
ValueCountFrequency (%)
S 62
87.3%
C 2
 
2.8%
A 2
 
2.8%
F 2
 
2.8%
D 2
 
2.8%
B 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2316
54.8%
ASCII 1914
45.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
679
35.5%
, 238
 
12.4%
5 128
 
6.7%
1 124
 
6.5%
( 119
 
6.2%
) 119
 
6.2%
2 108
 
5.6%
0 99
 
5.2%
8 84
 
4.4%
3 67
 
3.5%
Other values (11) 149
 
7.8%
Hangul
ValueCountFrequency (%)
서 121
 
5.2%
로 120
 
5.2%
천 120
 
5.2%
인 120
 
5.2%
구 120
 
5.2%
시 120
 
5.2%
광 120
 
5.2%
역 120
 
5.2%
호 119
 
5.1%
동 119
 
5.1%
Other values (29) 1117
48.2%

전화번호
Text

MISSING 

Distinct81
Distinct (%)98.8%
Missing38
Missing (%)31.7%
Memory size1.1 KiB
2023-12-13T04:34:12.190789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.02439
Min length11

Characters and Unicode

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

Unique80 ?
Unique (%)97.6%

Sample

1st row032-715-4084
2nd row032-715-7177
3rd row032-585-0640
4th row032-262-3500
5th row032-715-7700
ValueCountFrequency (%)
032-581-0341 2
 
2.4%
032-265-3700 1
 
1.2%
032-715-4084 1
 
1.2%
032-288-2800 1
 
1.2%
032-888-0542 1
 
1.2%
032-577-0339 1
 
1.2%
032-264-2700 1
 
1.2%
032-218-6300 1
 
1.2%
032-285-1900 1
 
1.2%
032-574-0574 1
 
1.2%
Other values (72) 72
86.7%
2023-12-13T04:34:12.584815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 172
17.4%
- 164
16.6%
2 156
15.8%
3 116
11.8%
5 101
10.2%
7 76
7.7%
6 51
 
5.2%
1 45
 
4.6%
8 43
 
4.4%
4 32
 
3.2%
Other values (3) 30
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 820
83.2%
Dash Punctuation 164
 
16.6%
Math Symbol 1
 
0.1%
Space Separator 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 172
21.0%
2 156
19.0%
3 116
14.1%
5 101
12.3%
7 76
9.3%
6 51
 
6.2%
1 45
 
5.5%
8 43
 
5.2%
4 32
 
3.9%
9 28
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 164
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 986
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 172
17.4%
- 164
16.6%
2 156
15.8%
3 116
11.8%
5 101
10.2%
7 76
7.7%
6 51
 
5.2%
1 45
 
4.6%
8 43
 
4.4%
4 32
 
3.2%
Other values (3) 30
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 986
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 172
17.4%
- 164
16.6%
2 156
15.8%
3 116
11.8%
5 101
10.2%
7 76
7.7%
6 51
 
5.2%
1 45
 
4.6%
8 43
 
4.4%
4 32
 
3.2%
Other values (3) 30
 
3.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2023-09-30 00:00:00
Maximum2023-09-30 00:00:00
2023-12-13T04:34:12.699133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:34:12.823137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T04:34:09.717797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:34:12.893714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번전화번호
연번1.0000.961
전화번호0.9611.000

Missing values

2023-12-13T04:34:09.827013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:34:10.224019image/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(주)시우자동차인천광역시 서구 염곡로 52, 324호 (가좌동, 엠파크허브)032-715-40842023-09-30
12S&K모터스자동차매매상사인천광역시 서구 봉수대로 158, S113호 (가좌동, 엠파크타워)032-715-71772023-09-30
23엠파크㈜인천광역시 서구 염곡로 52, 300호 (가좌동, 엠파크허브)032-585-06402023-09-30
34유성모터스인천광역시 서구 봉수대로 158, S120호 (가좌동, 엠파크타워)032-262-35002023-09-30
45조이카모터스자동차매매상사인천광역시 서구 봉수대로 158, S074호 (가좌동, 엠파크타워)032-715-77002023-09-30
56카프라자자동차매매상사인천광역시 서구 염곡로 52, 214호 (가좌동, 엠파크허브)032-715-83332023-09-30
67한솔모터스인천광역시 서구 봉수대로 158, S001호 (가좌동, 엠파크타워)032-715-76762023-09-30
78(주)탁월한선택인천광역시 서구 염곡로 52, 213호 (가좌동, 엠파크허브)032-715-62622023-09-30
89원스탑모터스주식회사인천광역시 서구 봉수대로 158, S057호 (가좌동, 엠파크타워)032-572-00662023-09-30
910주식회사 트루카인천광역시 서구 봉수대로 158, S104호 (가좌동, 엠파크타워)032-715-55252023-09-30
연번상호명소재지전화번호데이터기준일자
110113주식회사 애니카모터스인천광역시 서구 염곡로 52, 332호(가좌동, 엠파크허브)<NA>2023-09-30
111114바른모터스인천광역시 서구 봉수대로 158, S108호(가좌동, 엠파크타워)<NA>2023-09-30
112115지티 오토인천광역시 서구 봉수대로 158, S013호(가좌동, 엠파크타워)<NA>2023-09-30
113116다올 모터스인천광역시 서구 봉수대로 158, S010호(가좌동, 엠파크타워)<NA>2023-09-30
114117신신상사 주식회사인천광역시 서구 봉수대로 158, S076호(가좌동, 엠파크타워)<NA>2023-09-30
115118우정 모터스인천광역시 서구 봉수대로 158, S011호(가좌동, 엠파크타워)<NA>2023-09-30
116119케이엔씨인천광역시 서구 봉수대로 158, S009호(가좌동, 엠파크타워)<NA>2023-09-30
117120㈜엠카코퍼레이션인천광역시 서구 봉수대로 158, S100호(가좌동, 엠파크타워)<NA>2023-09-30
118121주식회사 에스와이오토인천광역시 서구 봉수대로 158, S007호(가좌동, 엠파크타워)<NA>2023-09-30
119122주식회사 제이제이오토컴퍼니인천광역시 서구 봉수대로 158, S077호(가좌동, 엠파크타워)<NA>2023-09-30