Overview

Dataset statistics

Number of variables6
Number of observations303
Missing cells5
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.6 KiB
Average record size in memory49.4 B

Variable types

Numeric1
Text4
DateTime1

Dataset

Description충청북도 음성군에 등록된 전문건설업체 현황(회사명, 업종, 소재지, 전화번호) 정보를 제공하는 데이터입니다.
Author충청북도 음성군
URLhttps://www.data.go.kr/data/15023987/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 14:50:09.292409
Analysis finished2023-12-12 14:50:10.162964
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct303
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean152
Minimum1
Maximum303
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.8 KiB
2023-12-12T23:50:10.259292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile16.1
Q176.5
median152
Q3227.5
95-th percentile287.9
Maximum303
Range302
Interquartile range (IQR)151

Descriptive statistics

Standard deviation87.612784
Coefficient of variation (CV)0.5763999
Kurtosis-1.2
Mean152
Median Absolute Deviation (MAD)76
Skewness0
Sum46056
Variance7676
MonotonicityStrictly increasing
2023-12-12T23:50:10.479381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
201 1
 
0.3%
208 1
 
0.3%
207 1
 
0.3%
206 1
 
0.3%
205 1
 
0.3%
204 1
 
0.3%
203 1
 
0.3%
202 1
 
0.3%
200 1
 
0.3%
Other values (293) 293
96.7%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
303 1
0.3%
302 1
0.3%
301 1
0.3%
300 1
0.3%
299 1
0.3%
298 1
0.3%
297 1
0.3%
296 1
0.3%
295 1
0.3%
294 1
0.3%

상호
Text

UNIQUE 

Distinct303
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.5 KiB
2023-12-12T23:50:10.785892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length7.3960396
Min length3

Characters and Unicode

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

Unique

Unique303 ?
Unique (%)100.0%

Sample

1st row(유)삼건토건
2nd row(유)태림건설
3rd row(유)태평건설
4th row(유)해광기업
5th row(주)가교기업
ValueCountFrequency (%)
유)삼건토건 1
 
0.3%
삼원설비공사 1
 
0.3%
소이가스 1
 
0.3%
세진에스앤티(주 1
 
0.3%
세움모빌(주 1
 
0.3%
성현건설(주 1
 
0.3%
성원테크 1
 
0.3%
성림산업(주 1
 
0.3%
설성종합가스 1
 
0.3%
설성설비공사 1
 
0.3%
Other values (293) 293
96.7%
2023-12-12T23:50:11.258649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 242
 
10.8%
( 215
 
9.6%
) 215
 
9.6%
설 106
 
4.7%
건 104
 
4.6%
스 49
 
2.2%
이 45
 
2.0%
사 43
 
1.9%
회 38
 
1.7%
식 38
 
1.7%
Other values (224) 1146
51.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1798
80.2%
Open Punctuation 215
 
9.6%
Close Punctuation 215
 
9.6%
Uppercase Letter 10
 
0.4%
Other Punctuation 2
 
0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 242
 
13.5%
설 106
 
5.9%
건 104
 
5.8%
스 49
 
2.7%
이 45
 
2.5%
사 43
 
2.4%
회 38
 
2.1%
식 38
 
2.1%
성 34
 
1.9%
에 34
 
1.9%
Other values (217) 1065
59.2%
Uppercase Letter
ValueCountFrequency (%)
N 4
40.0%
G 3
30.0%
E 3
30.0%
Open Punctuation
ValueCountFrequency (%)
( 215
100.0%
Close Punctuation
ValueCountFrequency (%)
) 215
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1799
80.3%
Common 432
 
19.3%
Latin 10
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 242
 
13.5%
설 106
 
5.9%
건 104
 
5.8%
스 49
 
2.7%
이 45
 
2.5%
사 43
 
2.4%
회 38
 
2.1%
식 38
 
2.1%
성 34
 
1.9%
에 34
 
1.9%
Other values (218) 1066
59.3%
Common
ValueCountFrequency (%)
( 215
49.8%
) 215
49.8%
. 2
 
0.5%
Latin
ValueCountFrequency (%)
N 4
40.0%
G 3
30.0%
E 3
30.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1798
80.2%
ASCII 442
 
19.7%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 242
 
13.5%
설 106
 
5.9%
건 104
 
5.8%
스 49
 
2.7%
이 45
 
2.5%
사 43
 
2.4%
회 38
 
2.1%
식 38
 
2.1%
성 34
 
1.9%
에 34
 
1.9%
Other values (217) 1065
59.2%
ASCII
ValueCountFrequency (%)
( 215
48.6%
) 215
48.6%
N 4
 
0.9%
G 3
 
0.7%
E 3
 
0.7%
. 2
 
0.5%
None
ValueCountFrequency (%)
㈜ 1
100.0%

업종
Text

Distinct84
Distinct (%)27.7%
Missing0
Missing (%)0.0%
Memory size2.5 KiB
2023-12-12T23:50:11.503033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length62
Median length57
Mean length17.455446
Min length7

Characters and Unicode

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

Unique

Unique47 ?
Unique (%)15.5%

Sample

1st row철근ㆍ콘크리트공사업+지반조성ㆍ포장공사업
2nd row철근ㆍ콘크리트공사업+상ㆍ하수도설비공사업+지반조성ㆍ포장공사업
3rd row상ㆍ하수도설비공사업
4th row지반조성ㆍ포장공사업+상ㆍ하수도설비공사업
5th row승강기ㆍ삭도공사업
ValueCountFrequency (%)
가스ㆍ난방공사업 52
17.2%
금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업 33
 
10.9%
지반조성ㆍ포장공사업 21
 
6.9%
도장ㆍ습식ㆍ방수ㆍ석공사업 19
 
6.3%
기계설비ㆍ가스공사업 16
 
5.3%
지반조성ㆍ포장공사업+철근ㆍ콘크리트공사업 14
 
4.6%
조경식재ㆍ시설물공사업 12
 
4.0%
철근ㆍ콘크리트공사업+지반조성ㆍ포장공사업 9
 
3.0%
철근ㆍ콘크리트공사업 8
 
2.6%
철강구조물공사업 8
 
2.6%
Other values (58) 111
36.6%
2023-12-12T23:50:11.971151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
ㆍ 620
 
11.7%
업 463
 
8.8%
공 447
 
8.5%
사 447
 
8.5%
조 189
 
3.6%
178
 
3.4%
지 161
 
3.0%
+ 160
 
3.0%
장 142
 
2.7%
물 111
 
2.1%
Other values (45) 2371
44.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4951
93.6%
Space Separator 178
 
3.4%
Math Symbol 160
 
3.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
ㆍ 620
 
12.5%
업 463
 
9.4%
공 447
 
9.0%
사 447
 
9.0%
조 189
 
3.8%
지 161
 
3.3%
장 142
 
2.9%
물 111
 
2.2%
방 103
 
2.1%
설 102
 
2.1%
Other values (43) 2166
43.7%
Space Separator
ValueCountFrequency (%)
178
100.0%
Math Symbol
ValueCountFrequency (%)
+ 160
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4951
93.6%
Common 338
 
6.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
ㆍ 620
 
12.5%
업 463
 
9.4%
공 447
 
9.0%
사 447
 
9.0%
조 189
 
3.8%
지 161
 
3.3%
장 142
 
2.9%
물 111
 
2.2%
방 103
 
2.1%
설 102
 
2.1%
Other values (43) 2166
43.7%
Common
ValueCountFrequency (%)
178
52.7%
+ 160
47.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4331
81.9%
Compat Jamo 620
 
11.7%
ASCII 338
 
6.4%

Most frequent character per block

Compat Jamo
ValueCountFrequency (%)
ㆍ 620
100.0%
Hangul
ValueCountFrequency (%)
업 463
 
10.7%
공 447
 
10.3%
사 447
 
10.3%
조 189
 
4.4%
지 161
 
3.7%
장 142
 
3.3%
물 111
 
2.6%
방 103
 
2.4%
설 102
 
2.4%
도 96
 
2.2%
Other values (42) 2070
47.8%
ASCII
ValueCountFrequency (%)
178
52.7%
+ 160
47.3%

영업소재지(도로명주소)
Text

Distinct284
Distinct (%)94.0%
Missing1
Missing (%)0.3%
Memory size2.5 KiB
2023-12-12T23:50:12.343609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length33
Mean length22.86755
Min length18

Characters and Unicode

Total characters6906
Distinct characters132
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

Unique267 ?
Unique (%)88.4%

Sample

1st row충청북도 음성군 감곡면 음성로 2193
2nd row충청북도 음성군 음성읍 중앙로 15
3rd row충청북도 음성군 음성읍 용광로230번길 49
4th row충청북도 음성군 대소면 소석로 137
5th row충청북도 음성군 삼성면 덕호로 475-18
ValueCountFrequency (%)
음성군 302
19.0%
충청북도 299
18.8%
음성읍 78
 
4.9%
금왕읍 60
 
3.8%
대소면 42
 
2.6%
삼성면 37
 
2.3%
생극면 29
 
1.8%
대금로 28
 
1.8%
음성로 21
 
1.3%
감곡면 20
 
1.3%
Other values (409) 673
42.4%
2023-12-12T23:50:12.937860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1287
18.6%
성 460
 
6.7%
음 410
 
5.9%
청 314
 
4.5%
충 308
 
4.5%
북 302
 
4.4%
군 302
 
4.4%
도 301
 
4.4%
1 283
 
4.1%
로 261
 
3.8%
Other values (122) 2678
38.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4259
61.7%
Space Separator 1287
 
18.6%
Decimal Number 1234
 
17.9%
Dash Punctuation 102
 
1.5%
Other Punctuation 14
 
0.2%
Close Punctuation 4
 
0.1%
Open Punctuation 4
 
0.1%
Uppercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
성 460
 
10.8%
음 410
 
9.6%
청 314
 
7.4%
충 308
 
7.2%
북 302
 
7.1%
군 302
 
7.1%
도 301
 
7.1%
로 261
 
6.1%
면 164
 
3.9%
읍 138
 
3.2%
Other values (105) 1299
30.5%
Decimal Number
ValueCountFrequency (%)
1 283
22.9%
2 185
15.0%
3 121
9.8%
4 105
 
8.5%
0 97
 
7.9%
5 95
 
7.7%
6 93
 
7.5%
9 89
 
7.2%
8 85
 
6.9%
7 81
 
6.6%
Other Punctuation
ValueCountFrequency (%)
, 13
92.9%
， 1
 
7.1%
Space Separator
ValueCountFrequency (%)
1287
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 102
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4259
61.7%
Common 2645
38.3%
Latin 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
성 460
 
10.8%
음 410
 
9.6%
청 314
 
7.4%
충 308
 
7.2%
북 302
 
7.1%
군 302
 
7.1%
도 301
 
7.1%
로 261
 
6.1%
면 164
 
3.9%
읍 138
 
3.2%
Other values (105) 1299
30.5%
Common
ValueCountFrequency (%)
1287
48.7%
1 283
 
10.7%
2 185
 
7.0%
3 121
 
4.6%
4 105
 
4.0%
- 102
 
3.9%
0 97
 
3.7%
5 95
 
3.6%
6 93
 
3.5%
9 89
 
3.4%
Other values (6) 188
 
7.1%
Latin
ValueCountFrequency (%)
A 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4259
61.7%
ASCII 2646
38.3%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1287
48.6%
1 283
 
10.7%
2 185
 
7.0%
3 121
 
4.6%
4 105
 
4.0%
- 102
 
3.9%
0 97
 
3.7%
5 95
 
3.6%
6 93
 
3.5%
9 89
 
3.4%
Other values (6) 189
 
7.1%
Hangul
ValueCountFrequency (%)
성 460
 
10.8%
음 410
 
9.6%
청 314
 
7.4%
충 308
 
7.2%
북 302
 
7.1%
군 302
 
7.1%
도 301
 
7.1%
로 261
 
6.1%
면 164
 
3.9%
읍 138
 
3.2%
Other values (105) 1299
30.5%
None
ValueCountFrequency (%)
， 1
100.0%

전화번호
Text

MISSING 

Distinct291
Distinct (%)97.3%
Missing4
Missing (%)1.3%
Memory size2.5 KiB
2023-12-12T23:50:13.308590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.003344
Min length11

Characters and Unicode

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

Unique283 ?
Unique (%)94.6%

Sample

1st row043-878-8711
2nd row043-873-4377
3rd row043-872-1394
4th row051-622-7789
5th row043-887-6037
ValueCountFrequency (%)
043-873-4377 2
 
0.7%
043-877-8258 2
 
0.7%
043-873-4662 2
 
0.7%
043-878-9450 2
 
0.7%
043-535-0714 2
 
0.7%
043-872-3719 2
 
0.7%
043-872-3835 2
 
0.7%
043-872-1389 2
 
0.7%
043-873-6101 1
 
0.3%
043-882-4944 1
 
0.3%
Other values (281) 281
94.0%
2023-12-12T23:50:13.795073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 598
16.7%
3 505
14.1%
0 488
13.6%
8 469
13.1%
4 410
11.4%
7 350
9.8%
2 224
 
6.2%
1 174
 
4.8%
5 141
 
3.9%
9 118
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2991
83.3%
Dash Punctuation 598
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 505
16.9%
0 488
16.3%
8 469
15.7%
4 410
13.7%
7 350
11.7%
2 224
7.5%
1 174
 
5.8%
5 141
 
4.7%
9 118
 
3.9%
6 112
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 598
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3589
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 598
16.7%
3 505
14.1%
0 488
13.6%
8 469
13.1%
4 410
11.4%
7 350
9.8%
2 224
 
6.2%
1 174
 
4.8%
5 141
 
3.9%
9 118
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3589
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 598
16.7%
3 505
14.1%
0 488
13.6%
8 469
13.1%
4 410
11.4%
7 350
9.8%
2 224
 
6.2%
1 174
 
4.8%
5 141
 
3.9%
9 118
 
3.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.5 KiB
Minimum2023-11-30 00:00:00
Maximum2023-11-30 00:00:00
2023-12-12T23:50:13.925001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:50:14.009324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T23:50:09.699090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:50:14.080882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.326
업종0.3261.000

Missing values

2023-12-12T23:50:09.847355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:50:09.974715image/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-12T23:50:10.099290image/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(유)삼건토건철근ㆍ콘크리트공사업+지반조성ㆍ포장공사업충청북도 음성군 감곡면 음성로 2193043-878-87112023-11-30
12(유)태림건설철근ㆍ콘크리트공사업+상ㆍ하수도설비공사업+지반조성ㆍ포장공사업충청북도 음성군 음성읍 중앙로 15043-873-43772023-11-30
23(유)태평건설상ㆍ하수도설비공사업충청북도 음성군 음성읍 용광로230번길 49043-872-13942023-11-30
34(유)해광기업지반조성ㆍ포장공사업+상ㆍ하수도설비공사업충청북도 음성군 대소면 소석로 137051-622-77892023-11-30
45(주)가교기업승강기ㆍ삭도공사업충청북도 음성군 삼성면 덕호로 475-18043-887-60372023-11-30
56(주)가스뱅크가스ㆍ난방공사업충청북도 음성군 대소면 대동로 655043-881-35002023-11-30
67(주)개풍토건지반조성ㆍ포장공사업+상ㆍ하수도설비공사업+철근ㆍ콘크리트공사업충청북도 음성군 맹동면 덕금로168번길 5-2043-877-12892023-11-30
78(주)경동개발기계설비ㆍ가스공사업충청북도 음성군 음성읍 한불로127번길 11043-873-27702023-11-30
89(주)그린도장도장ㆍ습식ㆍ방수ㆍ석공사업충청북도 음성군 금왕읍 금일로284번길 65-20043-881-18952023-11-30
910(주)글라스원금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업충청북도 음성군 대소면 소석로 169043-883-21372023-11-30
연번상호업종영업소재지(도로명주소)전화번호데이터기준일자
293294한내건설(주)철근ㆍ콘크리트공사업+지반조성ㆍ포장공사업+상ㆍ하수도설비공사업충청북도 음성군 음성읍 시장로 53 103호043-873-22682023-11-30
294295한양설비가스ㆍ난방공사업충청북도 음성군 대소면 오산로 73-2043-881-20032023-11-30
295296한주건설(주)상ㆍ하수도설비공사업+지반조성ㆍ포장공사업+철근ㆍ콘크리트공사업충청북도 음성군 음성읍 음성로 426043-873-18872023-11-30
296297햇사레건설(주)지반조성ㆍ포장공사업충청북도 음성군 음성읍 시장로 75-1043-873-88542023-11-30
297298현대E.N.G실내건축공사업충청북도 음성군 음성읍 신용로 56043-873-54872023-11-30
298299현대설비가스ㆍ난방공사업충청북도 음성군 금왕읍 음성로1230번길 15043-883-68062023-11-30
299300현도건설(주)지반조성ㆍ포장공사업+금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업충청북도 음성군 음성읍 시장로 29, 현도건설(주)043-872-02022023-11-30
300301현부건설(주)상ㆍ하수도설비공사업+지반조성ㆍ포장공사업충청북도 음성군 생극면 이진말길 9-8043-873-36042023-11-30
301302현우건설(주)지반조성ㆍ포장공사업+철근ㆍ콘크리트공사업+도장ㆍ습식ㆍ방수ㆍ석공사업+상ㆍ하수도설비공사업충북 음성군 소이면 소이로 279-10043-873-51872023-11-30
302303형제보일러가스ㆍ난방공사업충청북도 음성군 감곡면 장감로126번길 13-7043-882-41302023-11-30