Overview

Dataset statistics

Number of variables5
Number of observations109
Missing cells24
Missing cells (%)4.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory42.2 B

Variable types

Numeric1
Text3
Categorical1

Dataset

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

Alerts

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

Reproduction

Analysis started2024-01-28 14:00:06.591138
Analysis finished2024-01-28 14:00:07.012013
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct109
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55
Minimum1
Maximum109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2024-01-28T23:00:07.095792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.4
Q128
median55
Q382
95-th percentile103.6
Maximum109
Range108
Interquartile range (IQR)54

Descriptive statistics

Standard deviation31.609598
Coefficient of variation (CV)0.57471996
Kurtosis-1.2
Mean55
Median Absolute Deviation (MAD)27
Skewness0
Sum5995
Variance999.16667
MonotonicityStrictly increasing
2024-01-28T23:00:07.228325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.9%
70 1
 
0.9%
81 1
 
0.9%
80 1
 
0.9%
79 1
 
0.9%
78 1
 
0.9%
77 1
 
0.9%
76 1
 
0.9%
75 1
 
0.9%
74 1
 
0.9%
Other values (99) 99
90.8%
ValueCountFrequency (%)
1 1
0.9%
2 1
0.9%
3 1
0.9%
4 1
0.9%
5 1
0.9%
6 1
0.9%
7 1
0.9%
8 1
0.9%
9 1
0.9%
10 1
0.9%
ValueCountFrequency (%)
109 1
0.9%
108 1
0.9%
107 1
0.9%
106 1
0.9%
105 1
0.9%
104 1
0.9%
103 1
0.9%
102 1
0.9%
101 1
0.9%
100 1
0.9%

상호명
Text

UNIQUE 

Distinct109
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2024-01-28T23:00:07.428305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length12
Mean length8.1100917
Min length2

Characters and Unicode

Total characters884
Distinct characters179
Distinct categories8 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique109 ?
Unique (%)100.0%

Sample

1st row(주)시우자동차
2nd rowS&K모터스자동차매매상사
3rd row씨에스모터스
4th row엠파크(주)
5th row유성모터스
ValueCountFrequency (%)
주식회사 16
 
11.9%
오토허브 2
 
1.5%
엠파크(주 2
 
1.5%
주)유카 2
 
1.5%
오토플러스(주 2
 
1.5%
케이카(주 2
 
1.5%
웰컴카 1
 
0.7%
굿카대표 1
 
0.7%
지후모터스 1
 
0.7%
스마트상사 1
 
0.7%
Other values (104) 104
77.6%
2024-01-28T23:00:07.753173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 65
 
7.4%
모 49
 
5.5%
터 47
 
5.3%
사 46
 
5.2%
주 43
 
4.9%
매 42
 
4.8%
차 35
 
4.0%
( 26
 
2.9%
) 26
 
2.9%
자 26
 
2.9%
Other values (169) 479
54.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 788
89.1%
Open Punctuation 26
 
2.9%
Close Punctuation 26
 
2.9%
Space Separator 25
 
2.8%
Uppercase Letter 15
 
1.7%
Other Symbol 2
 
0.2%
Other Punctuation 1
 
0.1%
Decimal Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 65
 
8.2%
모 49
 
6.2%
터 47
 
6.0%
사 46
 
5.8%
주 43
 
5.5%
매 42
 
5.3%
차 35
 
4.4%
자 26
 
3.3%
상 26
 
3.3%
동 25
 
3.2%
Other values (152) 384
48.7%
Uppercase Letter
ValueCountFrequency (%)
G 2
13.3%
J 2
13.3%
A 2
13.3%
K 2
13.3%
T 1
6.7%
B 1
6.7%
S 1
6.7%
P 1
6.7%
M 1
6.7%
N 1
6.7%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Space Separator
ValueCountFrequency (%)
25
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%
Decimal Number
ValueCountFrequency (%)
1 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 786
88.9%
Common 79
 
8.9%
Latin 15
 
1.7%
Han 4
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 65
 
8.3%
모 49
 
6.2%
터 47
 
6.0%
사 46
 
5.9%
주 43
 
5.5%
매 42
 
5.3%
차 35
 
4.5%
자 26
 
3.3%
상 26
 
3.3%
동 25
 
3.2%
Other values (149) 382
48.6%
Latin
ValueCountFrequency (%)
G 2
13.3%
J 2
13.3%
A 2
13.3%
K 2
13.3%
T 1
6.7%
B 1
6.7%
S 1
6.7%
P 1
6.7%
M 1
6.7%
N 1
6.7%
Common
ValueCountFrequency (%)
( 26
32.9%
) 26
32.9%
25
31.6%
& 1
 
1.3%
1 1
 
1.3%
Han
ValueCountFrequency (%)
安 1
25.0%
巨 1
25.0%
社 1
25.0%
商 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 784
88.7%
ASCII 94
 
10.6%
CJK 4
 
0.5%
None 2
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 65
 
8.3%
모 49
 
6.2%
터 47
 
6.0%
사 46
 
5.9%
주 43
 
5.5%
매 42
 
5.4%
차 35
 
4.5%
자 26
 
3.3%
상 26
 
3.3%
동 25
 
3.2%
Other values (148) 380
48.5%
ASCII
ValueCountFrequency (%)
( 26
27.7%
) 26
27.7%
25
26.6%
G 2
 
2.1%
J 2
 
2.1%
A 2
 
2.1%
K 2
 
2.1%
T 1
 
1.1%
B 1
 
1.1%
& 1
 
1.1%
Other values (6) 6
 
6.4%
None
ValueCountFrequency (%)
㈜ 2
100.0%
CJK
ValueCountFrequency (%)
安 1
25.0%
巨 1
25.0%
社 1
25.0%
商 1
25.0%

소재지
Text

Distinct107
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2024-01-28T23:00:08.039705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length47
Mean length35.458716
Min length22

Characters and Unicode

Total characters3865
Distinct characters57
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

Unique105 ?
Unique (%)96.3%

Sample

1st row인천광역시 서구 염곡로 52, 324호 (가좌동, 엠파크허브)
2nd row인천광역시 서구 봉수대로 158, S113호 (가좌동, 엠파크타워)
3rd row인천광역시 서구 봉수대로 158, S060호 (가좌동, 엠파크타워)
4th row인천광역시 서구 염곡로 149, A209호 (가좌동, 엠파크랜드)
5th row인천광역시 서구 봉수대로 158, S003호 (가좌동, 엠파크타워)
ValueCountFrequency (%)
인천광역시 109
14.7%
서구 109
14.7%
가좌동 82
11.1%
엠파크타워 54
7.3%
봉수대로 54
7.3%
158 54
7.3%
염곡로 50
 
6.8%
엠파크허브 48
 
6.5%
52 46
 
6.2%
149 3
 
0.4%
Other values (125) 130
17.6%
2024-01-28T23:00:08.436727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
631
 
16.3%
, 217
 
5.6%
5 116
 
3.0%
1 114
 
2.9%
서 110
 
2.8%
) 109
 
2.8%
( 109
 
2.8%
호 109
 
2.8%
로 109
 
2.8%
인 109
 
2.8%
Other values (47) 2132
55.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2108
54.5%
Space Separator 631
 
16.3%
Decimal Number 624
 
16.1%
Other Punctuation 217
 
5.6%
Close Punctuation 109
 
2.8%
Open Punctuation 109
 
2.8%
Uppercase Letter 66
 
1.7%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 110
 
5.2%
호 109
 
5.2%
로 109
 
5.2%
인 109
 
5.2%
천 109
 
5.2%
구 109
 
5.2%
시 109
 
5.2%
역 109
 
5.2%
광 109
 
5.2%
동 108
 
5.1%
Other values (27) 1018
48.3%
Decimal Number
ValueCountFrequency (%)
5 116
18.6%
1 114
18.3%
2 98
15.7%
0 88
14.1%
8 75
12.0%
3 62
9.9%
4 20
 
3.2%
7 19
 
3.0%
6 17
 
2.7%
9 15
 
2.4%
Uppercase Letter
ValueCountFrequency (%)
S 59
89.4%
D 2
 
3.0%
A 2
 
3.0%
C 2
 
3.0%
F 1
 
1.5%
Space Separator
ValueCountFrequency (%)
631
100.0%
Other Punctuation
ValueCountFrequency (%)
, 217
100.0%
Close Punctuation
ValueCountFrequency (%)
) 109
100.0%
Open Punctuation
ValueCountFrequency (%)
( 109
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2108
54.5%
Common 1691
43.8%
Latin 66
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 110
 
5.2%
호 109
 
5.2%
로 109
 
5.2%
인 109
 
5.2%
천 109
 
5.2%
구 109
 
5.2%
시 109
 
5.2%
역 109
 
5.2%
광 109
 
5.2%
동 108
 
5.1%
Other values (27) 1018
48.3%
Common
ValueCountFrequency (%)
631
37.3%
, 217
 
12.8%
5 116
 
6.9%
1 114
 
6.7%
) 109
 
6.4%
( 109
 
6.4%
2 98
 
5.8%
0 88
 
5.2%
8 75
 
4.4%
3 62
 
3.7%
Other values (5) 72
 
4.3%
Latin
ValueCountFrequency (%)
S 59
89.4%
D 2
 
3.0%
A 2
 
3.0%
C 2
 
3.0%
F 1
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2108
54.5%
ASCII 1757
45.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
631
35.9%
, 217
 
12.4%
5 116
 
6.6%
1 114
 
6.5%
) 109
 
6.2%
( 109
 
6.2%
2 98
 
5.6%
0 88
 
5.0%
8 75
 
4.3%
3 62
 
3.5%
Other values (10) 138
 
7.9%
Hangul
ValueCountFrequency (%)
서 110
 
5.2%
호 109
 
5.2%
로 109
 
5.2%
인 109
 
5.2%
천 109
 
5.2%
구 109
 
5.2%
시 109
 
5.2%
역 109
 
5.2%
광 109
 
5.2%
동 108
 
5.1%
Other values (27) 1018
48.3%

전화번호
Text

MISSING 

Distinct83
Distinct (%)97.6%
Missing24
Missing (%)22.0%
Memory size1004.0 B
2024-01-28T23:00:08.651738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique81 ?
Unique (%)95.3%

Sample

1st row032-715-4084
2nd row032-715-7177
3rd row032-715-7707
4th row032-585-0640
5th row032-262-3500
ValueCountFrequency (%)
032-262-1122 2
 
2.4%
032-581-0341 2
 
2.4%
032-266-7900 1
 
1.2%
032-671-2345 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%
032-271-2100 1
 
1.2%
032-266-8949 1
 
1.2%
Other values (73) 73
85.9%
2024-01-28T23:00:08.975823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 182
17.8%
2 171
16.8%
- 170
16.7%
3 117
11.5%
5 99
9.7%
7 78
7.6%
1 54
 
5.3%
6 53
 
5.2%
8 43
 
4.2%
4 28
 
2.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 850
83.3%
Dash Punctuation 170
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 182
21.4%
2 171
20.1%
3 117
13.8%
5 99
11.6%
7 78
9.2%
1 54
 
6.4%
6 53
 
6.2%
8 43
 
5.1%
4 28
 
3.3%
9 25
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 170
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1020
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 182
17.8%
2 171
16.8%
- 170
16.7%
3 117
11.5%
5 99
9.7%
7 78
7.6%
1 54
 
5.3%
6 53
 
5.2%
8 43
 
4.2%
4 28
 
2.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1020
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 182
17.8%
2 171
16.8%
- 170
16.7%
3 117
11.5%
5 99
9.7%
7 78
7.6%
1 54
 
5.3%
6 53
 
5.2%
8 43
 
4.2%
4 28
 
2.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2022-08-30
109 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-30
2nd row2022-08-30
3rd row2022-08-30
4th row2022-08-30
5th row2022-08-30

Common Values

ValueCountFrequency (%)
2022-08-30 109
100.0%

Length

2024-01-28T23:00:09.091992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T23:00:09.168809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-30 109
100.0%

Interactions

2024-01-28T23:00:06.807003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T23:00:09.221431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번전화번호
연번1.0000.874
전화번호0.8741.000

Missing values

2024-01-28T23:00:06.893810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T23:00:06.979330image/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-40842022-08-30
12S&K모터스자동차매매상사인천광역시 서구 봉수대로 158, S113호 (가좌동, 엠파크타워)032-715-71772022-08-30
23씨에스모터스인천광역시 서구 봉수대로 158, S060호 (가좌동, 엠파크타워)032-715-77072022-08-30
34엠파크(주)인천광역시 서구 염곡로 149, A209호 (가좌동, 엠파크랜드)032-585-06402022-08-30
45유성모터스인천광역시 서구 봉수대로 158, S003호 (가좌동, 엠파크타워)032-262-35002022-08-30
56조이카모터스자동차매매상사인천광역시 서구 봉수대로 158, S074호 (가좌동, 엠파크타워)032-715-77002022-08-30
67(주)유카인천광역시 서구 봉수대로 158, S120호 (가좌동, 엠파크타워)032-262-11222022-08-30
78카프라자자동차매매상사인천광역시 서구 염곡로 52, 214호 (가좌동, 엠파크허브)032-715-83332022-08-30
89한솔모터스인천광역시 서구 봉수대로 158, S001호 (가좌동, 엠파크타워)032-715-76762022-08-30
910(주)탁월한선택인천광역시 서구 염곡로 52, 213호 (가좌동, 엠파크허브)032-715-62622022-08-30
연번상호명소재지전화번호데이터기준일자
99100대연상사인천광역시 서구 봉수대로 158, S022호(가좌동, 엠파크타워)<NA>2022-08-30
100101미래모터스인천광역시 서구 봉수대로 158, S017호(가좌동, 엠파크타워)<NA>2022-08-30
101102뉴AK모터스자동차매매상사인천광역시 서구 봉수대로 158, S080호(가좌동, 엠파크타워)<NA>2022-08-30
102103해든모터스인천광역시 서구 봉수대로 158, S076호(가좌동, 엠파크타워)<NA>2022-08-30
103104조은자동차매매상사인천광역시 서구 봉수대로 158, S012호(가좌동, 엠파크타워)<NA>2022-08-30
104105카놀자인천광역시 서구 봉수대로 158, S110호(가좌동, 엠파크타워)<NA>2022-08-30
105106주식회사 케이비인증중고차인천광역시 서구 봉수대로 158, S082호(가좌동, 엠파크타워)<NA>2022-08-30
106107민모터스인천광역시 서구 봉수대로 158, S073호(가좌동, 엠파크타워)<NA>2022-08-30
107108킹덤모터스인천광역시 서구 봉수대로 158, S020호(가좌동, 엠파크타워)<NA>2022-08-30
108109카빌리지인천광역시 서구 염곡로 52, 325호 (가좌동, 엠파크허브)<NA>2022-08-30