Overview

Dataset statistics

Number of variables5
Number of observations99
Missing cells57
Missing cells (%)11.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.1 KiB
Average record size in memory42.3 B

Variable types

Numeric1
Text4

Dataset

Description인천광역시 미추홀구의 중장비 업체에 대한 데이터로 업체명, 도로명주소, 전화번호, 위도, 경도 등의 항목을 제공하고 있습니다.
URLhttps://www.data.go.kr/data/15087070/fileData.do

Alerts

도로명주소 has 23 (23.2%) missing valuesMissing
전화번호 has 34 (34.3%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:41:55.224013
Analysis finished2023-12-12 11:41:56.732122
Duration1.51 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct99
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50
Minimum1
Maximum99
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-12T20:41:56.866866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.9
Q125.5
median50
Q374.5
95-th percentile94.1
Maximum99
Range98
Interquartile range (IQR)49

Descriptive statistics

Standard deviation28.722813
Coefficient of variation (CV)0.57445626
Kurtosis-1.2
Mean50
Median Absolute Deviation (MAD)25
Skewness0
Sum4950
Variance825
MonotonicityStrictly increasing
2023-12-12T20:41:57.101346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
64 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
67 1
 
1.0%
Other values (89) 89
89.9%
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 (%)
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%
90 1
1.0%

상호명
Text

Distinct89
Distinct (%)89.9%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-12T20:41:57.549309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length20
Mean length7.3030303
Min length4

Characters and Unicode

Total characters723
Distinct characters152
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

Unique83 ?
Unique (%)83.8%

Sample

1st row사다리차
2nd row미니포크레인
3rd row사다리차
4th row학익동지게차
5th row인천미니포크레인
ValueCountFrequency (%)
천지굴삭기미니포크레인 4
 
3.9%
사다리차 3
 
2.9%
채영사다리차,스카이차 3
 
2.9%
장비박사포크레인굴삭기덤프크레인스카이펌프카바브켓토목포장 2
 
2.0%
월드스카이 2
 
2.0%
인천사다리차 2
 
2.0%
88스카이차 1
 
1.0%
중앙스카이차 1
 
1.0%
태영미니포크레인 1
 
1.0%
민스카이 1
 
1.0%
Other values (82) 82
80.4%
2023-12-12T20:41:58.257379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
인 44
 
6.1%
카 40
 
5.5%
차 36
 
5.0%
이 36
 
5.0%
스 35
 
4.8%
기 32
 
4.4%
레 30
 
4.1%
크 30
 
4.1%
사 24
 
3.3%
중 22
 
3.0%
Other values (142) 394
54.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 702
97.1%
Other Punctuation 9
 
1.2%
Decimal Number 5
 
0.7%
Space Separator 3
 
0.4%
Lowercase Letter 1
 
0.1%
Uppercase Letter 1
 
0.1%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 44
 
6.3%
카 40
 
5.7%
차 36
 
5.1%
이 36
 
5.1%
스 35
 
5.0%
기 32
 
4.6%
레 30
 
4.3%
크 30
 
4.3%
사 24
 
3.4%
중 22
 
3.1%
Other values (131) 373
53.1%
Decimal Number
ValueCountFrequency (%)
8 2
40.0%
1 1
20.0%
3 1
20.0%
5 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 6
66.7%
. 3
33.3%
Space Separator
ValueCountFrequency (%)
3
100.0%
Lowercase Letter
ValueCountFrequency (%)
o 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
K 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 702
97.1%
Common 19
 
2.6%
Latin 2
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 44
 
6.3%
카 40
 
5.7%
차 36
 
5.1%
이 36
 
5.1%
스 35
 
5.0%
기 32
 
4.6%
레 30
 
4.3%
크 30
 
4.3%
사 24
 
3.4%
중 22
 
3.1%
Other values (131) 373
53.1%
Common
ValueCountFrequency (%)
, 6
31.6%
3
15.8%
. 3
15.8%
8 2
 
10.5%
1 1
 
5.3%
3 1
 
5.3%
5 1
 
5.3%
) 1
 
5.3%
( 1
 
5.3%
Latin
ValueCountFrequency (%)
o 1
50.0%
K 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 702
97.1%
ASCII 21
 
2.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
인 44
 
6.3%
카 40
 
5.7%
차 36
 
5.1%
이 36
 
5.1%
스 35
 
5.0%
기 32
 
4.6%
레 30
 
4.3%
크 30
 
4.3%
사 24
 
3.4%
중 22
 
3.1%
Other values (131) 373
53.1%
ASCII
ValueCountFrequency (%)
, 6
28.6%
3
14.3%
. 3
14.3%
8 2
 
9.5%
1 1
 
4.8%
3 1
 
4.8%
5 1
 
4.8%
o 1
 
4.8%
K 1
 
4.8%
) 1
 
4.8%

지번주소
Text

Distinct74
Distinct (%)74.7%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-12T20:41:58.729506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length35
Mean length20.222222
Min length14

Characters and Unicode

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

Unique

Unique57 ?
Unique (%)57.6%

Sample

1st row인천광역시 미추홀구 도화동 1008
2nd row인천광역시 미추홀구 숭의동 129-9
3rd row인천광역시 미추홀구 주안동 56-10
4th row인천광역시 미추홀구 학익동 125-1
5th row인천광역시 미추홀구 숭의동 406-9
ValueCountFrequency (%)
인천광역시 99
24.8%
미추홀구 99
24.8%
숭의동 27
 
6.8%
주안동 19
 
4.8%
용현동 17
 
4.2%
학익동 9
 
2.2%
도화동 8
 
2.0%
문학동 7
 
1.8%
129-9 7
 
1.8%
204호 4
 
1.0%
Other values (87) 104
26.0%
2023-12-12T20:41:59.442015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
307
 
15.3%
동 106
 
5.3%
인 101
 
5.0%
미 100
 
5.0%
천 100
 
5.0%
광 99
 
4.9%
역 99
 
4.9%
시 99
 
4.9%
추 99
 
4.9%
홀 99
 
4.9%
Other values (48) 793
39.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1236
61.7%
Decimal Number 392
 
19.6%
Space Separator 307
 
15.3%
Dash Punctuation 64
 
3.2%
Other Punctuation 2
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 106
8.6%
인 101
8.2%
미 100
8.1%
천 100
8.1%
광 99
8.0%
역 99
8.0%
시 99
8.0%
추 99
8.0%
홀 99
8.0%
구 99
8.0%
Other values (34) 235
19.0%
Decimal Number
ValueCountFrequency (%)
1 74
18.9%
2 47
12.0%
4 46
11.7%
6 42
10.7%
3 39
9.9%
0 37
9.4%
9 36
9.2%
5 30
7.7%
7 23
 
5.9%
8 18
 
4.6%
Space Separator
ValueCountFrequency (%)
307
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1236
61.7%
Common 765
38.2%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 106
8.6%
인 101
8.2%
미 100
8.1%
천 100
8.1%
광 99
8.0%
역 99
8.0%
시 99
8.0%
추 99
8.0%
홀 99
8.0%
구 99
8.0%
Other values (34) 235
19.0%
Common
ValueCountFrequency (%)
307
40.1%
1 74
 
9.7%
- 64
 
8.4%
2 47
 
6.1%
4 46
 
6.0%
6 42
 
5.5%
3 39
 
5.1%
0 37
 
4.8%
9 36
 
4.7%
5 30
 
3.9%
Other values (3) 43
 
5.6%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1236
61.7%
ASCII 766
38.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
307
40.1%
1 74
 
9.7%
- 64
 
8.4%
2 47
 
6.1%
4 46
 
6.0%
6 42
 
5.5%
3 39
 
5.1%
0 37
 
4.8%
9 36
 
4.7%
5 30
 
3.9%
Other values (4) 44
 
5.7%
Hangul
ValueCountFrequency (%)
동 106
8.6%
인 101
8.2%
미 100
8.1%
천 100
8.1%
광 99
8.0%
역 99
8.0%
시 99
8.0%
추 99
8.0%
홀 99
8.0%
구 99
8.0%
Other values (34) 235
19.0%

도로명주소
Text

MISSING 

Distinct66
Distinct (%)86.8%
Missing23
Missing (%)23.2%
Memory size924.0 B
2023-12-12T20:41:59.953349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length32
Mean length22.184211
Min length16

Characters and Unicode

Total characters1686
Distinct characters109
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

Unique59 ?
Unique (%)77.6%

Sample

1st row인천광역시 미추홀구 숙골로88번길 56
2nd row인천광역시 미추홀구 참외전로 302
3rd row인천광역시 미추홀구 주안동로 40
4th row인천광역시 미추홀구 소성로 211
5th row인천광역시 미추홀구 인중로 22
ValueCountFrequency (%)
인천광역시 76
22.4%
미추홀구 76
22.4%
참외전로 8
 
2.4%
302 7
 
2.1%
인중로 7
 
2.1%
9 5
 
1.5%
22 4
 
1.2%
204호 4
 
1.2%
미추로 3
 
0.9%
74 3
 
0.9%
Other values (127) 147
43.2%
2023-12-12T20:42:00.678519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
264
 
15.7%
인 93
 
5.5%
미 82
 
4.9%
추 81
 
4.8%
홀 81
 
4.8%
천 78
 
4.6%
시 76
 
4.5%
역 76
 
4.5%
광 76
 
4.5%
구 76
 
4.5%
Other values (99) 703
41.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1089
64.6%
Decimal Number 314
 
18.6%
Space Separator 264
 
15.7%
Dash Punctuation 14
 
0.8%
Lowercase Letter 2
 
0.1%
Uppercase Letter 1
 
0.1%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 93
 
8.5%
미 82
 
7.5%
추 81
 
7.4%
홀 81
 
7.4%
천 78
 
7.2%
시 76
 
7.0%
역 76
 
7.0%
광 76
 
7.0%
구 76
 
7.0%
로 67
 
6.2%
Other values (82) 303
27.8%
Decimal Number
ValueCountFrequency (%)
1 59
18.8%
2 48
15.3%
0 45
14.3%
3 30
9.6%
4 27
8.6%
5 25
8.0%
6 22
 
7.0%
9 22
 
7.0%
8 19
 
6.1%
7 17
 
5.4%
Lowercase Letter
ValueCountFrequency (%)
k 1
50.0%
s 1
50.0%
Space Separator
ValueCountFrequency (%)
264
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1089
64.6%
Common 594
35.2%
Latin 3
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 93
 
8.5%
미 82
 
7.5%
추 81
 
7.4%
홀 81
 
7.4%
천 78
 
7.2%
시 76
 
7.0%
역 76
 
7.0%
광 76
 
7.0%
구 76
 
7.0%
로 67
 
6.2%
Other values (82) 303
27.8%
Common
ValueCountFrequency (%)
264
44.4%
1 59
 
9.9%
2 48
 
8.1%
0 45
 
7.6%
3 30
 
5.1%
4 27
 
4.5%
5 25
 
4.2%
6 22
 
3.7%
9 22
 
3.7%
8 19
 
3.2%
Other values (4) 33
 
5.6%
Latin
ValueCountFrequency (%)
B 1
33.3%
k 1
33.3%
s 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1089
64.6%
ASCII 597
35.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
264
44.2%
1 59
 
9.9%
2 48
 
8.0%
0 45
 
7.5%
3 30
 
5.0%
4 27
 
4.5%
5 25
 
4.2%
6 22
 
3.7%
9 22
 
3.7%
8 19
 
3.2%
Other values (7) 36
 
6.0%
Hangul
ValueCountFrequency (%)
인 93
 
8.5%
미 82
 
7.5%
추 81
 
7.4%
홀 81
 
7.4%
천 78
 
7.2%
시 76
 
7.0%
역 76
 
7.0%
광 76
 
7.0%
구 76
 
7.0%
로 67
 
6.2%
Other values (82) 303
27.8%

전화번호
Text

MISSING 

Distinct65
Distinct (%)100.0%
Missing34
Missing (%)34.3%
Memory size924.0 B
2023-12-12T20:42:01.063291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length12.692308
Min length12

Characters and Unicode

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

Unique65 ?
Unique (%)100.0%

Sample

1st row032-710-8404
2nd row032-205-1644
3rd row0507-1311-1284
4th row070-8904-8759
5th row032-887-2838
ValueCountFrequency (%)
032-752-0304 1
 
1.5%
032-216-0424 1
 
1.5%
070-4587-9813 1
 
1.5%
070-4983-5238 1
 
1.5%
032-887-2701 1
 
1.5%
032-467-1990 1
 
1.5%
032-259-0511 1
 
1.5%
070-4529-5106 1
 
1.5%
070-4574-1265 1
 
1.5%
070-8089-0764 1
 
1.5%
Other values (55) 55
84.6%
2023-12-12T20:42:01.695328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 147
17.8%
- 130
15.8%
2 83
10.1%
3 82
9.9%
7 77
9.3%
4 65
7.9%
5 62
7.5%
8 60
7.3%
1 46
 
5.6%
6 38
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 695
84.2%
Dash Punctuation 130
 
15.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 147
21.2%
2 83
11.9%
3 82
11.8%
7 77
11.1%
4 65
9.4%
5 62
8.9%
8 60
8.6%
1 46
 
6.6%
6 38
 
5.5%
9 35
 
5.0%
Dash Punctuation
ValueCountFrequency (%)
- 130
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 825
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 147
17.8%
- 130
15.8%
2 83
10.1%
3 82
9.9%
7 77
9.3%
4 65
7.9%
5 62
7.5%
8 60
7.3%
1 46
 
5.6%
6 38
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 825
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 147
17.8%
- 130
15.8%
2 83
10.1%
3 82
9.9%
7 77
9.3%
4 65
7.9%
5 62
7.5%
8 60
7.3%
1 46
 
5.6%
6 38
 
4.6%

Interactions

2023-12-12T20:41:56.155990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:42:01.852940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호명지번주소도로명주소전화번호
연번1.0000.7220.5840.8171.000
상호명0.7221.0000.9630.9391.000
지번주소0.5840.9631.0000.9991.000
도로명주소0.8170.9390.9991.0001.000
전화번호1.0001.0001.0001.0001.000

Missing values

2023-12-12T20:41:56.351829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:41:56.510803image/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-12T20:41:56.650118image/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

연번상호명지번주소도로명주소전화번호
01사다리차인천광역시 미추홀구 도화동 1008인천광역시 미추홀구 숙골로88번길 56<NA>
12미니포크레인인천광역시 미추홀구 숭의동 129-9인천광역시 미추홀구 참외전로 302<NA>
23사다리차인천광역시 미추홀구 주안동 56-10인천광역시 미추홀구 주안동로 40032-710-8404
34학익동지게차인천광역시 미추홀구 학익동 125-1인천광역시 미추홀구 소성로 211<NA>
45인천미니포크레인인천광역시 미추홀구 숭의동 406-9인천광역시 미추홀구 인중로 22032-205-1644
56인천사다리차인천광역시 미추홀구 학익동 703-2인천광역시 미추홀구 한나루로357번길 63-190507-1311-1284
67가가렌탈리프트고소작업대인천광역시 미추홀구 문학동<NA>070-8904-8759
78삼성 볼보 중장비부품인천광역시 미추홀구 숭의동 435-46인천광역시 미추홀구 인중로16번길 5-16032-887-2838
89용현동지게차인천광역시 미추홀구 용현동 664인천광역시 미추홀구 용정공원로 33032-873-8255
910인천포크레인인천광역시 미추홀구 숭의동 129-9인천광역시 미추홀구 참외전로 302032-205-1744
연번상호명지번주소도로명주소전화번호
8990영일사다리차인천광역시 미추홀구 학익1동 225-32 22-5인천광역시 미추홀구 매소홀로401번길 9-18<NA>
9091경인공사인천광역시 미추홀구 주안동 410-51인천광역시 미추홀구 동주길119번길 8-1<NA>
9192길상크레인인천광역시 미추홀구 숭의동 129-9 2층 204호인천광역시 미추홀구 참외전로 302 2층 204호<NA>
9293천지굴삭기미니포크레인인천광역시 미추홀구 숭의4동<NA>070-4534-5625
9394스카이스카이차스카이장비.삼양인천광역시 미추홀구 문학동<NA>070-4537-3429
9495천지굴삭기미니포크레인인천광역시 미추홀구 주안동<NA>070-4563-8024
9596월드스카이인천광역시 미추홀구 학익동 125-1인천광역시 미추홀구 소성로 211<NA>
969788스카이차인천광역시 미추홀구 용현동<NA>070-4565-3842
9798신진스카이차인천광역시 미추홀구 학익동 689-19인천광역시 미추홀구 한나루로358번길 21032-223-3370
9899경기스카이인천광역시 미추홀구 문학동 335-4인천광역시 미추홀구 승학길 20<NA>