Overview

Dataset statistics

Number of variables7
Number of observations217
Missing cells8
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.2 KiB
Average record size in memory57.6 B

Variable types

Numeric1
Text4
Categorical1
DateTime1

Dataset

Description경상북도 영양군 전문건설업 현황에 대한 데이터로 번호, 업체명, 대표자, 업종, 도로명주소, 전화번호, 데이터기준일자로 구성되어 있습니다.
Author경상북도 영양군
URLhttps://www.data.go.kr/data/15084403/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 8 (3.7%) missing valuesMissing
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:12:06.269309
Analysis finished2023-12-12 22:12:06.856714
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct217
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean109
Minimum1
Maximum217
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-13T07:12:06.946332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.8
Q155
median109
Q3163
95-th percentile206.2
Maximum217
Range216
Interquartile range (IQR)108

Descriptive statistics

Standard deviation62.786676
Coefficient of variation (CV)0.57602455
Kurtosis-1.2
Mean109
Median Absolute Deviation (MAD)54
Skewness0
Sum23653
Variance3942.1667
MonotonicityStrictly increasing
2023-12-13T07:12:07.084829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
150 1
 
0.5%
139 1
 
0.5%
140 1
 
0.5%
141 1
 
0.5%
142 1
 
0.5%
143 1
 
0.5%
144 1
 
0.5%
145 1
 
0.5%
146 1
 
0.5%
Other values (207) 207
95.4%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
217 1
0.5%
216 1
0.5%
215 1
0.5%
214 1
0.5%
213 1
0.5%
212 1
0.5%
211 1
0.5%
210 1
0.5%
209 1
0.5%
208 1
0.5%

업체명
Text

Distinct129
Distinct (%)59.4%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T07:12:07.384557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length7
Mean length6.9769585
Min length4

Characters and Unicode

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

Unique

Unique69 ?
Unique (%)31.8%

Sample

1st row(주)거성건설
2nd row(주)거성건설
3rd row(주)거성건설
4th row(주)거성건설
5th row(주)경림건설
ValueCountFrequency (%)
케이건설(주 5
 
2.3%
세윤건설(주 4
 
1.8%
동아종합건설(주 4
 
1.8%
금라건설(주 4
 
1.8%
이제이건설주식회사 4
 
1.8%
주)거성건설 4
 
1.8%
주)대성건설 4
 
1.8%
정환건설(주 4
 
1.8%
주)대광건설 3
 
1.4%
주식회사대지원 3
 
1.4%
Other values (119) 178
82.0%
2023-12-13T07:12:07.851066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 201
13.3%
설 168
 
11.1%
( 161
 
10.6%
) 161
 
10.6%
건 158
 
10.4%
사 40
 
2.6%
대 38
 
2.5%
회 37
 
2.4%
식 37
 
2.4%
성 25
 
1.7%
Other values (105) 488
32.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1191
78.7%
Open Punctuation 161
 
10.6%
Close Punctuation 161
 
10.6%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 201
16.9%
설 168
 
14.1%
건 158
 
13.3%
사 40
 
3.4%
대 38
 
3.2%
회 37
 
3.1%
식 37
 
3.1%
성 25
 
2.1%
원 22
 
1.8%
이 22
 
1.8%
Other values (102) 443
37.2%
Open Punctuation
ValueCountFrequency (%)
( 161
100.0%
Close Punctuation
ValueCountFrequency (%)
) 161
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1191
78.7%
Common 323
 
21.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 201
16.9%
설 168
 
14.1%
건 158
 
13.3%
사 40
 
3.4%
대 38
 
3.2%
회 37
 
3.1%
식 37
 
3.1%
성 25
 
2.1%
원 22
 
1.8%
이 22
 
1.8%
Other values (102) 443
37.2%
Common
ValueCountFrequency (%)
( 161
49.8%
) 161
49.8%
. 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1191
78.7%
ASCII 323
 
21.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 201
16.9%
설 168
 
14.1%
건 158
 
13.3%
사 40
 
3.4%
대 38
 
3.2%
회 37
 
3.1%
식 37
 
3.1%
성 25
 
2.1%
원 22
 
1.8%
이 22
 
1.8%
Other values (102) 443
37.2%
ASCII
ValueCountFrequency (%)
( 161
49.8%
) 161
49.8%
. 1
 
0.3%

대표자
Text

Distinct123
Distinct (%)56.7%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T07:12:08.233973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length3
Mean length3.0184332
Min length3

Characters and Unicode

Total characters655
Distinct characters108
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

Unique63 ?
Unique (%)29.0%

Sample

1st row김경희
2nd row김경희
3rd row김경희
4th row김경희
5th row임장희
ValueCountFrequency (%)
고종환 5
 
2.3%
최순자 5
 
2.3%
김경희 4
 
1.8%
강진영 4
 
1.8%
류금지 4
 
1.8%
김윤종 4
 
1.8%
김경민 4
 
1.8%
황인숙 4
 
1.8%
임석규 4
 
1.8%
최희정 4
 
1.8%
Other values (113) 175
80.6%
2023-12-13T07:12:08.862990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 62
 
9.5%
정 31
 
4.7%
이 24
 
3.7%
희 21
 
3.2%
임 19
 
2.9%
진 19
 
2.9%
최 16
 
2.4%
종 15
 
2.3%
권 14
 
2.1%
수 14
 
2.1%
Other values (98) 420
64.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 654
99.8%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 62
 
9.5%
정 31
 
4.7%
이 24
 
3.7%
희 21
 
3.2%
임 19
 
2.9%
진 19
 
2.9%
최 16
 
2.4%
종 15
 
2.3%
권 14
 
2.1%
수 14
 
2.1%
Other values (97) 419
64.1%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 654
99.8%
Common 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 62
 
9.5%
정 31
 
4.7%
이 24
 
3.7%
희 21
 
3.2%
임 19
 
2.9%
진 19
 
2.9%
최 16
 
2.4%
종 15
 
2.3%
권 14
 
2.1%
수 14
 
2.1%
Other values (97) 419
64.1%
Common
ValueCountFrequency (%)
, 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 654
99.8%
ASCII 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 62
 
9.5%
정 31
 
4.7%
이 24
 
3.7%
희 21
 
3.2%
임 19
 
2.9%
진 19
 
2.9%
최 16
 
2.4%
종 15
 
2.3%
권 14
 
2.1%
수 14
 
2.1%
Other values (97) 419
64.1%
ASCII
ValueCountFrequency (%)
, 1
100.0%

업종
Categorical

Distinct10
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
지반조성ㆍ포장공사업
71 
철근ㆍ콘크리트공사업
46 
상ㆍ하수도설비공사업
23 
도장ㆍ습식ㆍ방수ㆍ석공사업
23 
가스난방공사업
18 
Other values (5)
36 

Length

Max length17
Median length10
Mean length10.35023
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상ㆍ하수도설비공사업
2nd row철근ㆍ콘크리트공사업
3rd row도장ㆍ습식ㆍ방수ㆍ석공사업
4th row지반조성ㆍ포장공사업
5th row상ㆍ하수도설비공사업

Common Values

ValueCountFrequency (%)
지반조성ㆍ포장공사업 71
32.7%
철근ㆍ콘크리트공사업 46
21.2%
상ㆍ하수도설비공사업 23
 
10.6%
도장ㆍ습식ㆍ방수ㆍ석공사업 23
 
10.6%
가스난방공사업 18
 
8.3%
금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업 10
 
4.6%
구조물해체ㆍ비계공사업 9
 
4.1%
조경식재ㆍ시설물공사업 7
 
3.2%
시설물유지관리업 5
 
2.3%
실내건축공사업 5
 
2.3%

Length

2023-12-13T07:12:09.044571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:12:09.185764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
지반조성ㆍ포장공사업 71
32.7%
철근ㆍ콘크리트공사업 46
21.2%
상ㆍ하수도설비공사업 23
 
10.6%
도장ㆍ습식ㆍ방수ㆍ석공사업 23
 
10.6%
가스난방공사업 18
 
8.3%
금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업 10
 
4.6%
구조물해체ㆍ비계공사업 9
 
4.1%
조경식재ㆍ시설물공사업 7
 
3.2%
시설물유지관리업 5
 
2.3%
실내건축공사업 5
 
2.3%

도로명주소
Text

Distinct112
Distinct (%)51.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T07:12:09.513911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length27
Mean length21.543779
Min length18

Characters and Unicode

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

Unique

Unique58 ?
Unique (%)26.7%

Sample

1st row경상북도 영양군 영양읍 동서대로 5
2nd row경상북도 영양군 영양읍 동서대로 5
3rd row경상북도 영양군 영양읍 동서대로 5
4th row경상북도 영양군 영양읍 동서대로 5
5th row경상북도 영양군 영양읍 동서대로 1
ValueCountFrequency (%)
경상북도 217
19.1%
영양군 217
19.1%
영양읍 167
14.7%
동서대로 47
 
4.1%
입암면 31
 
2.7%
중앙로 22
 
1.9%
2층 18
 
1.6%
입암로 17
 
1.5%
군민회관길 15
 
1.3%
17 14
 
1.2%
Other values (140) 369
32.5%
2023-12-13T07:12:10.237166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
917
19.6%
영 404
 
8.6%
양 399
 
8.5%
군 239
 
5.1%
북 220
 
4.7%
도 220
 
4.7%
상 220
 
4.7%
경 217
 
4.6%
읍 167
 
3.6%
1 163
 
3.5%
Other values (81) 1509
32.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3000
64.2%
Space Separator 917
 
19.6%
Decimal Number 643
 
13.8%
Dash Punctuation 85
 
1.8%
Other Punctuation 22
 
0.5%
Close Punctuation 4
 
0.1%
Open Punctuation 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 404
13.5%
양 399
13.3%
군 239
 
8.0%
북 220
 
7.3%
도 220
 
7.3%
상 220
 
7.3%
경 217
 
7.2%
읍 167
 
5.6%
로 127
 
4.2%
길 90
 
3.0%
Other values (66) 697
23.2%
Decimal Number
ValueCountFrequency (%)
1 163
25.3%
6 79
12.3%
3 74
11.5%
4 65
 
10.1%
2 62
 
9.6%
7 57
 
8.9%
5 53
 
8.2%
9 33
 
5.1%
0 29
 
4.5%
8 28
 
4.4%
Space Separator
ValueCountFrequency (%)
917
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 85
100.0%
Other Punctuation
ValueCountFrequency (%)
, 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3000
64.2%
Common 1675
35.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 404
13.5%
양 399
13.3%
군 239
 
8.0%
북 220
 
7.3%
도 220
 
7.3%
상 220
 
7.3%
경 217
 
7.2%
읍 167
 
5.6%
로 127
 
4.2%
길 90
 
3.0%
Other values (66) 697
23.2%
Common
ValueCountFrequency (%)
917
54.7%
1 163
 
9.7%
- 85
 
5.1%
6 79
 
4.7%
3 74
 
4.4%
4 65
 
3.9%
2 62
 
3.7%
7 57
 
3.4%
5 53
 
3.2%
9 33
 
2.0%
Other values (5) 87
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3000
64.2%
ASCII 1675
35.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
917
54.7%
1 163
 
9.7%
- 85
 
5.1%
6 79
 
4.7%
3 74
 
4.4%
4 65
 
3.9%
2 62
 
3.7%
7 57
 
3.4%
5 53
 
3.2%
9 33
 
2.0%
Other values (5) 87
 
5.2%
Hangul
ValueCountFrequency (%)
영 404
13.5%
양 399
13.3%
군 239
 
8.0%
북 220
 
7.3%
도 220
 
7.3%
상 220
 
7.3%
경 217
 
7.2%
읍 167
 
5.6%
로 127
 
4.2%
길 90
 
3.0%
Other values (66) 697
23.2%

전화번호
Text

MISSING 

Distinct114
Distinct (%)54.5%
Missing8
Missing (%)3.7%
Memory size1.8 KiB
2023-12-13T07:12:10.504915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique58 ?
Unique (%)27.8%

Sample

1st row054-683-1188
2nd row054-683-1188
3rd row054-683-1188
4th row054-683-1188
5th row054-682-5088
ValueCountFrequency (%)
054-682-0505 6
 
2.9%
054-683-3767 6
 
2.9%
054-682-6432 5
 
2.4%
054-683-3665 5
 
2.4%
054-682-0091 5
 
2.4%
054-683-8476 4
 
1.9%
054-683-6337 4
 
1.9%
054-683-1188 4
 
1.9%
054-682-0273 4
 
1.9%
054-682-1900 4
 
1.9%
Other values (104) 162
77.5%
2023-12-13T07:12:10.835162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 418
16.7%
0 377
15.0%
5 281
11.2%
6 279
11.1%
8 276
11.0%
4 265
10.6%
3 224
8.9%
2 148
 
5.9%
1 93
 
3.7%
7 91
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2090
83.3%
Dash Punctuation 418
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 377
18.0%
5 281
13.4%
6 279
13.3%
8 276
13.2%
4 265
12.7%
3 224
10.7%
2 148
 
7.1%
1 93
 
4.4%
7 91
 
4.4%
9 56
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 418
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2508
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 418
16.7%
0 377
15.0%
5 281
11.2%
6 279
11.1%
8 276
11.0%
4 265
10.6%
3 224
8.9%
2 148
 
5.9%
1 93
 
3.7%
7 91
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2508
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 418
16.7%
0 377
15.0%
5 281
11.2%
6 279
11.1%
8 276
11.0%
4 265
10.6%
3 224
8.9%
2 148
 
5.9%
1 93
 
3.7%
7 91
 
3.6%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2023-10-23 00:00:00
Maximum2023-10-23 00:00:00
2023-12-13T07:12:10.945328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:12:11.030108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T07:12:06.555316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:12:11.095583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호업종
번호1.0000.000
업종0.0001.000
2023-12-13T07:12:11.164756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호업종
번호1.0000.000
업종0.0001.000

Missing values

2023-12-13T07:12:06.663780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:12:06.805065image/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(주)거성건설김경희상ㆍ하수도설비공사업경상북도 영양군 영양읍 동서대로 5054-683-11882023-10-23
12(주)거성건설김경희철근ㆍ콘크리트공사업경상북도 영양군 영양읍 동서대로 5054-683-11882023-10-23
23(주)거성건설김경희도장ㆍ습식ㆍ방수ㆍ석공사업경상북도 영양군 영양읍 동서대로 5054-683-11882023-10-23
34(주)거성건설김경희지반조성ㆍ포장공사업경상북도 영양군 영양읍 동서대로 5054-683-11882023-10-23
45(주)경림건설임장희상ㆍ하수도설비공사업경상북도 영양군 영양읍 동서대로 1054-682-50882023-10-23
56(주)경민조성현지반조성ㆍ포장공사업경상북도 영양군 영양읍 서북새길 7-4054-683-63002023-10-23
67(주)경민조성현상ㆍ하수도설비공사업경상북도 영양군 영양읍 서북새길 7-4054-683-63002023-10-23
78(주)경북건설김경호철근ㆍ콘크리트공사업경상북도 영양군 영양읍 동서대로 103054-682-39842023-10-23
89(주)경북건설김경호지반조성ㆍ포장공사업경상북도 영양군 영양읍 동서대로 103054-682-39842023-10-23
910(주)경북건업우재윤금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업경상북도 영양군 영양읍 중앙로 159054-682-26842023-10-23
번호업체명대표자업종도로명주소전화번호데이터기준일자
207208케이지건설(주)지연화도장ㆍ습식ㆍ방수ㆍ석공사업경상북도 영양군 일월면 당진길 36054-682-85412023-10-23
208209태경건설(주)송진태지반조성ㆍ포장공사업경상북도 영양군 영양읍 낙원로 63054-683-55332023-10-23
209210태경건설(주)송진태철근ㆍ콘크리트공사업경상북도 영양군 영양읍 낙원로 63054-683-55332023-10-23
210211태승건설주식회사김범진지반조성ㆍ포장공사업경상북도 영양군 영양읍 석영로 1119054-683-13772023-10-23
211212태양에너지.설비이창식가스난방공사업경상북도 영양군 영양읍 시장길 13, 1호054-683-82132023-10-23
212213태영건설(주)박효정상ㆍ하수도설비공사업경상북도 영양군 입암면 조기리길 28-1054-683-17832023-10-23
213214태영건설(주)박효정지반조성ㆍ포장공사업경상북도 영양군 입암면 조기리길 28-1054-683-17832023-10-23
214215하남건설(주)이기식지반조성ㆍ포장공사업경상북도 영양군 청기면 청기1길 8054-683-67652023-10-23
215216한주건설(주)김규태철근ㆍ콘크리트공사업경상북도 영양군 영양읍 도뭇골길 99-4054-683-68002023-10-23
216217한주건설(주)김규태지반조성ㆍ포장공사업경상북도 영양군 영양읍 도뭇골길 99-4054-683-68002023-10-23