Overview

Dataset statistics

Number of variables5
Number of observations97
Missing cells2
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.9 KiB
Average record size in memory41.4 B

Variable types

Text3
Categorical1
DateTime1

Dataset

Description제주특별자치도 서귀포시 내 종합건설업 현황에 관한 데이터로 업체명, 업종(조경, 토목 등), 연락처, 주소 등 정보를 제공합니다.
Author제주특별자치도 서귀포시
URLhttps://www.data.go.kr/data/15018022/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 2 (2.1%) missing valuesMissing

Reproduction

Analysis started2023-12-12 12:10:18.543917
Analysis finished2023-12-12 12:10:19.110331
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

Distinct86
Distinct (%)88.7%
Missing0
Missing (%)0.0%
Memory size908.0 B
2023-12-12T21:10:19.292703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length10
Mean length8.9896907
Min length4

Characters and Unicode

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

Unique

Unique76 ?
Unique (%)78.4%

Sample

1st row가나종합건설주식회사
2nd row가인종합건설주식회사
3rd row강진종합건설주식회사
4th row경현건설(주)
5th row경현건설(주)
ValueCountFrequency (%)
경현건설(주 3
 
3.1%
현담종합건설주식회사 2
 
2.1%
대아토건주식회사 2
 
2.1%
주식회사안성종합건설 2
 
2.1%
주식회사대건 2
 
2.1%
고운종합건설주식회사 2
 
2.1%
주식회사선우 2
 
2.1%
오경종합건설유한회사 2
 
2.1%
성운건설주식회사 2
 
2.1%
주식회사서하건설 2
 
2.1%
Other values (76) 76
78.4%
2023-12-12T21:10:19.720337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 96
11.0%
사 90
 
10.3%
회 89
 
10.2%
식 86
 
9.9%
건 82
 
9.4%
설 76
 
8.7%
종 51
 
5.8%
합 51
 
5.8%
성 12
 
1.4%
대 10
 
1.1%
Other values (106) 229
26.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 858
98.4%
Open Punctuation 7
 
0.8%
Close Punctuation 7
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 96
11.2%
사 90
10.5%
회 89
10.4%
식 86
 
10.0%
건 82
 
9.6%
설 76
 
8.9%
종 51
 
5.9%
합 51
 
5.9%
성 12
 
1.4%
대 10
 
1.2%
Other values (104) 215
25.1%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 858
98.4%
Common 14
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 96
11.2%
사 90
10.5%
회 89
10.4%
식 86
 
10.0%
건 82
 
9.6%
설 76
 
8.9%
종 51
 
5.9%
합 51
 
5.9%
성 12
 
1.4%
대 10
 
1.2%
Other values (104) 215
25.1%
Common
ValueCountFrequency (%)
( 7
50.0%
) 7
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 858
98.4%
ASCII 14
 
1.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 96
11.2%
사 90
10.5%
회 89
10.4%
식 86
 
10.0%
건 82
 
9.6%
설 76
 
8.9%
종 51
 
5.9%
합 51
 
5.9%
성 12
 
1.4%
대 10
 
1.2%
Other values (104) 215
25.1%
ASCII
ValueCountFrequency (%)
( 7
50.0%
) 7
50.0%

업종
Categorical

Distinct4
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size908.0 B
건축공사업
50 
토목공사업
30 
토목건축공사업
9 
조경공사업
8 

Length

Max length7
Median length5
Mean length5.185567
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row토목건축공사업
2nd row건축공사업
3rd row건축공사업
4th row토목공사업
5th row건축공사업

Common Values

ValueCountFrequency (%)
건축공사업 50
51.5%
토목공사업 30
30.9%
토목건축공사업 9
 
9.3%
조경공사업 8
 
8.2%

Length

2023-12-12T21:10:19.867546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:10:19.983573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건축공사업 50
51.5%
토목공사업 30
30.9%
토목건축공사업 9
 
9.3%
조경공사업 8
 
8.2%

도로명주소
Text

Distinct85
Distinct (%)87.6%
Missing0
Missing (%)0.0%
Memory size908.0 B
2023-12-12T21:10:20.346313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length44
Mean length30.804124
Min length19

Characters and Unicode

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

Unique

Unique74 ?
Unique (%)76.3%

Sample

1st row제주특별자치도 서귀포시 태평로 569 (동홍동)
2nd row제주특별자치도 서귀포시 동홍로 102 903호 (동홍동)
3rd row제주특별자치도 서귀포시 대정읍 중산간서로 2380 2층
4th row제주특별자치도 서귀포시 성산읍 일주동로 5069 1층
5th row제주특별자치도 서귀포시 성산읍 일주동로 5069 1층
ValueCountFrequency (%)
제주특별자치도 97
 
17.6%
서귀포시 97
 
17.6%
동홍동 21
 
3.8%
2층 16
 
2.9%
일주동로 13
 
2.4%
1층 11
 
2.0%
중산간동로 9
 
1.6%
서귀동 9
 
1.6%
강정동 8
 
1.5%
서홍동 8
 
1.5%
Other values (174) 262
47.5%
2023-12-12T21:10:20.943597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
463
 
15.5%
동 148
 
5.0%
서 138
 
4.6%
주 110
 
3.7%
귀 107
 
3.6%
제 104
 
3.5%
도 100
 
3.3%
시 99
 
3.3%
포 98
 
3.3%
치 97
 
3.2%
Other values (116) 1524
51.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1928
64.5%
Space Separator 463
 
15.5%
Decimal Number 437
 
14.6%
Close Punctuation 72
 
2.4%
Open Punctuation 72
 
2.4%
Dash Punctuation 16
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 148
 
7.7%
서 138
 
7.2%
주 110
 
5.7%
귀 107
 
5.5%
제 104
 
5.4%
도 100
 
5.2%
시 99
 
5.1%
포 98
 
5.1%
치 97
 
5.0%
자 97
 
5.0%
Other values (102) 830
43.0%
Decimal Number
ValueCountFrequency (%)
1 76
17.4%
2 68
15.6%
0 48
11.0%
8 40
9.2%
3 39
8.9%
4 37
8.5%
5 37
8.5%
7 32
7.3%
6 30
 
6.9%
9 30
 
6.9%
Space Separator
ValueCountFrequency (%)
463
100.0%
Close Punctuation
ValueCountFrequency (%)
) 72
100.0%
Open Punctuation
ValueCountFrequency (%)
( 72
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1928
64.5%
Common 1060
35.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 148
 
7.7%
서 138
 
7.2%
주 110
 
5.7%
귀 107
 
5.5%
제 104
 
5.4%
도 100
 
5.2%
시 99
 
5.1%
포 98
 
5.1%
치 97
 
5.0%
자 97
 
5.0%
Other values (102) 830
43.0%
Common
ValueCountFrequency (%)
463
43.7%
1 76
 
7.2%
) 72
 
6.8%
( 72
 
6.8%
2 68
 
6.4%
0 48
 
4.5%
8 40
 
3.8%
3 39
 
3.7%
4 37
 
3.5%
5 37
 
3.5%
Other values (4) 108
 
10.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1928
64.5%
ASCII 1060
35.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
463
43.7%
1 76
 
7.2%
) 72
 
6.8%
( 72
 
6.8%
2 68
 
6.4%
0 48
 
4.5%
8 40
 
3.8%
3 39
 
3.7%
4 37
 
3.5%
5 37
 
3.5%
Other values (4) 108
 
10.2%
Hangul
ValueCountFrequency (%)
동 148
 
7.7%
서 138
 
7.2%
주 110
 
5.7%
귀 107
 
5.5%
제 104
 
5.4%
도 100
 
5.2%
시 99
 
5.1%
포 98
 
5.1%
치 97
 
5.0%
자 97
 
5.0%
Other values (102) 830
43.0%

전화번호
Text

MISSING 

Distinct84
Distinct (%)88.4%
Missing2
Missing (%)2.1%
Memory size908.0 B
2023-12-12T21:10:21.237694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12
Min length11

Characters and Unicode

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

Unique74 ?
Unique (%)77.9%

Sample

1st row064-739-3225
2nd row064-762-9696
3rd row064-792-1143
4th row064-782-5557
5th row064-782-5557
ValueCountFrequency (%)
064-782-5557 3
 
3.2%
064-739-3770 2
 
2.1%
064-702-5050 2
 
2.1%
064-733-0331 2
 
2.1%
064-767-2003 2
 
2.1%
064-733-4664 2
 
2.1%
064-792-0569 2
 
2.1%
064-733-9500 2
 
2.1%
064-763-0800 2
 
2.1%
064-746-2320 2
 
2.1%
Other values (74) 74
77.9%
2023-12-12T21:10:21.761629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 190
16.7%
0 166
14.6%
6 157
13.8%
4 144
12.6%
7 131
11.5%
3 110
9.6%
2 64
 
5.6%
5 46
 
4.0%
1 46
 
4.0%
8 43
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 950
83.3%
Dash Punctuation 190
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 166
17.5%
6 157
16.5%
4 144
15.2%
7 131
13.8%
3 110
11.6%
2 64
 
6.7%
5 46
 
4.8%
1 46
 
4.8%
8 43
 
4.5%
9 43
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 190
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1140
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 190
16.7%
0 166
14.6%
6 157
13.8%
4 144
12.6%
7 131
11.5%
3 110
9.6%
2 64
 
5.6%
5 46
 
4.0%
1 46
 
4.0%
8 43
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1140
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 190
16.7%
0 166
14.6%
6 157
13.8%
4 144
12.6%
7 131
11.5%
3 110
9.6%
2 64
 
5.6%
5 46
 
4.0%
1 46
 
4.0%
8 43
 
3.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size908.0 B
Minimum2023-10-31 00:00:00
Maximum2023-10-31 00:00:00
2023-12-12T21:10:21.926816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:10:22.052598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T21:10:22.163071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명업종도로명주소전화번호
업체명1.0000.0001.0001.000
업종0.0001.0000.0000.000
도로명주소1.0000.0001.0001.000
전화번호1.0000.0001.0001.000

Missing values

2023-12-12T21:10:18.936874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:10:19.066769image/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

업체명업종도로명주소전화번호데이터기준일자
0가나종합건설주식회사토목건축공사업제주특별자치도 서귀포시 태평로 569 (동홍동)064-739-32252023-10-31
1가인종합건설주식회사건축공사업제주특별자치도 서귀포시 동홍로 102 903호 (동홍동)064-762-96962023-10-31
2강진종합건설주식회사건축공사업제주특별자치도 서귀포시 대정읍 중산간서로 2380 2층064-792-11432023-10-31
3경현건설(주)토목공사업제주특별자치도 서귀포시 성산읍 일주동로 5069 1층064-782-55572023-10-31
4경현건설(주)건축공사업제주특별자치도 서귀포시 성산읍 일주동로 5069 1층064-782-55572023-10-31
5경현건설(주)조경공사업제주특별자치도 서귀포시 성산읍 일주동로 5069 1층064-782-55572023-10-31
6고운종합건설주식회사조경공사업제주특별자치도 서귀포시 중정로 123 505호 (서귀동 선경오피스텔)064-733-03312023-10-31
7고운종합건설주식회사토목공사업제주특별자치도 서귀포시 중정로 123 505호 (서귀동 선경오피스텔)064-733-03312023-10-31
8금나종합건설주식회사토목건축공사업제주특별자치도 서귀포시 동홍남로 79 (동홍동)064-763-88042023-10-31
9금성종합건설주식회사토목건축공사업제주특별자치도 서귀포시 동문로 15 (서귀동)064-762-81182023-10-31
업체명업종도로명주소전화번호데이터기준일자
87탐나라건설주식회사건축공사업제주특별자치도 서귀포시 일주동로 8643 5층 (서귀동)064-762-04272023-10-31
88탐나종합건설주식회사토목공사업제주특별자치도 서귀포시 동홍북로 66 102동 (동홍동)064-763-04222023-10-31
89토안건설주식회사토목공사업제주특별자치도 서귀포시 동홍서로96번길 15(동홍동)064-732-04032023-10-31
90파라다이스건설(주)건축공사업제주특별자치도 서귀포시 장수로 87 2층 (서홍동)064-733-34562023-10-31
91현담종합건설주식회사건축공사업제주특별자치도 서귀포시 중문로 48 101호 (중문동 이도빌리지)064-767-20032023-10-31
92현담종합건설주식회사토목공사업제주특별자치도 서귀포시 중문로 48 101호 (중문동 이도빌리지)064-767-20032023-10-31
93형남종합건설주식회사토목건축공사업제주특별자치도 서귀포시 동홍동로 39 2층 (동홍동 만영빌딩)064-732-73382023-10-31
94혜광건설주식회사건축공사업제주특별자치도 서귀포시 동홍중앙로 58-1 2층 (동홍동)064-738-09452023-10-31
95혜승건설(주)건축공사업제주특별자치도 서귀포시 일주동로 8810 (서홍동)064-763-57582023-10-31
96황금건설주식회사토목공사업제주특별자치도 서귀포시 토평공단로 38(토평동)064-759-88042023-10-31