Overview

Dataset statistics

Number of variables6
Number of observations429
Missing cells56
Missing cells (%)2.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.7 KiB
Average record size in memory49.3 B

Variable types

Numeric1
Text4
Categorical1

Dataset

Description세종특별자치시의 건설업체 등록현황(상호,대표자,업종,영업소재지,전화번호)건설업체 상호 예시로는 (주)가온산업개발, (주)금성백조건설, (주)금송건설 등이 있습니다.
Author세종특별자치시
URLhttps://www.data.go.kr/data/15037736/fileData.do

Alerts

전화번호 has 54 (12.6%) missing valuesMissing
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:36:25.034446
Analysis finished2023-12-12 12:36:25.868290
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct429
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean215
Minimum1
Maximum429
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.9 KiB
2023-12-12T21:36:25.968234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile22.4
Q1108
median215
Q3322
95-th percentile407.6
Maximum429
Range428
Interquartile range (IQR)214

Descriptive statistics

Standard deviation123.98589
Coefficient of variation (CV)0.57667854
Kurtosis-1.2
Mean215
Median Absolute Deviation (MAD)107
Skewness0
Sum92235
Variance15372.5
MonotonicityStrictly increasing
2023-12-12T21:36:26.469068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
296 1
 
0.2%
294 1
 
0.2%
293 1
 
0.2%
292 1
 
0.2%
291 1
 
0.2%
290 1
 
0.2%
289 1
 
0.2%
288 1
 
0.2%
287 1
 
0.2%
Other values (419) 419
97.7%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
429 1
0.2%
428 1
0.2%
427 1
0.2%
426 1
0.2%
425 1
0.2%
424 1
0.2%
423 1
0.2%
422 1
0.2%
421 1
0.2%
420 1
0.2%

상호
Text

Distinct426
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
2023-12-12T21:36:26.752439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length7.5944056
Min length2

Characters and Unicode

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

Unique

Unique423 ?
Unique (%)98.6%

Sample

1st row(유)다함
2nd row(유)안전세종
3rd row(유)이음유앤아이
4th row(주)가온건설산업
5th row(주)건솔
ValueCountFrequency (%)
주)윤성토건 2
 
0.5%
주식회사더양지 2
 
0.5%
주)미성아이디 2
 
0.5%
크로스산업개발(주 1
 
0.2%
인성건설(주 1
 
0.2%
아뜰리에지음주식회사 1
 
0.2%
쎈종합건설(주 1
 
0.2%
신흥설비 1
 
0.2%
신화종합건설(주 1
 
0.2%
신화건설산업(주 1
 
0.2%
Other values (416) 416
97.0%
2023-12-12T21:36:27.263067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
363
 
11.1%
( 287
 
8.8%
) 287
 
8.8%
172
 
5.3%
159
 
4.9%
93
 
2.9%
87
 
2.7%
87
 
2.7%
76
 
2.3%
57
 
1.7%
Other values (261) 1590
48.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2674
82.1%
Open Punctuation 287
 
8.8%
Close Punctuation 287
 
8.8%
Uppercase Letter 9
 
0.3%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
363
 
13.6%
172
 
6.4%
159
 
5.9%
93
 
3.5%
87
 
3.3%
87
 
3.3%
76
 
2.8%
57
 
2.1%
55
 
2.1%
52
 
1.9%
Other values (251) 1473
55.1%
Uppercase Letter
ValueCountFrequency (%)
E 2
22.2%
M 2
22.2%
T 1
11.1%
H 1
11.1%
G 1
11.1%
N 1
11.1%
C 1
11.1%
Open Punctuation
ValueCountFrequency (%)
( 287
100.0%
Close Punctuation
ValueCountFrequency (%)
) 287
100.0%
Other Symbol
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2675
82.1%
Common 574
 
17.6%
Latin 9
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
363
 
13.6%
172
 
6.4%
159
 
5.9%
93
 
3.5%
87
 
3.3%
87
 
3.3%
76
 
2.8%
57
 
2.1%
55
 
2.1%
52
 
1.9%
Other values (252) 1474
55.1%
Latin
ValueCountFrequency (%)
E 2
22.2%
M 2
22.2%
T 1
11.1%
H 1
11.1%
G 1
11.1%
N 1
11.1%
C 1
11.1%
Common
ValueCountFrequency (%)
( 287
50.0%
) 287
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2674
82.1%
ASCII 583
 
17.9%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
363
 
13.6%
172
 
6.4%
159
 
5.9%
93
 
3.5%
87
 
3.3%
87
 
3.3%
76
 
2.8%
57
 
2.1%
55
 
2.1%
52
 
1.9%
Other values (251) 1473
55.1%
ASCII
ValueCountFrequency (%)
( 287
49.2%
) 287
49.2%
E 2
 
0.3%
M 2
 
0.3%
T 1
 
0.2%
H 1
 
0.2%
G 1
 
0.2%
N 1
 
0.2%
C 1
 
0.2%
None
ValueCountFrequency (%)
1
100.0%

업종
Categorical

Distinct16
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
조경식재ㆍ시설물공사업
79 
가스난방공사업
47 
실내건축공사업
44 
건축공사업
39 
기계가스설비공사업
38 
Other values (11)
182 

Length

Max length17
Median length11
Mean length9.025641
Min length5

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row토목공사업
2nd row도장ㆍ습식ㆍ방수ㆍ석공사업
3rd row조경식재ㆍ시설물공사업
4th row지반조성ㆍ포장공사업
5th row도장ㆍ습식ㆍ방수ㆍ석공사업

Common Values

ValueCountFrequency (%)
조경식재ㆍ시설물공사업 79
18.4%
가스난방공사업 47
11.0%
실내건축공사업 44
10.3%
건축공사업 39
9.1%
기계가스설비공사업 38
8.9%
철근ㆍ콘크리트공사업 36
8.4%
지반조성ㆍ포장공사업 31
 
7.2%
토목건축공사업 26
 
6.1%
도장ㆍ습식ㆍ방수ㆍ석공사업 19
 
4.4%
금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업 19
 
4.4%
Other values (6) 51
11.9%

Length

2023-12-12T21:36:27.449573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
조경식재ㆍ시설물공사업 79
18.4%
가스난방공사업 47
11.0%
실내건축공사업 44
10.3%
건축공사업 39
9.1%
기계가스설비공사업 38
8.9%
철근ㆍ콘크리트공사업 36
8.4%
지반조성ㆍ포장공사업 31
 
7.2%
토목건축공사업 26
 
6.1%
도장ㆍ습식ㆍ방수ㆍ석공사업 19
 
4.4%
금속ㆍ창호ㆍ지붕ㆍ건축물조립공사업 19
 
4.4%
Other values (6) 51
11.9%
Distinct325
Distinct (%)75.9%
Missing1
Missing (%)0.2%
Memory size3.5 KiB
2023-12-12T21:36:27.732527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length19.233645
Min length14

Characters and Unicode

Total characters8232
Distinct characters178
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

Unique257 ?
Unique (%)60.0%

Sample

1st row세종특별자치시 금남면 용포로 58
2nd row세종특별자치시 금남면 안금로 251
3rd row세종특별자치시 소정면 작은황골길 78
4th row세종특별자치시 고운서길 20 501호
5th row세종특별자치시 부강면 시장길 38
ValueCountFrequency (%)
세종특별자치시 426
27.0%
조치원읍 98
 
6.2%
한누리대로 59
 
3.7%
연서면 37
 
2.3%
금남면 35
 
2.2%
부강면 26
 
1.6%
장군면 24
 
1.5%
충현로 20
 
1.3%
전의면 20
 
1.3%
갈매로 19
 
1.2%
Other values (402) 814
51.6%
2023-12-12T21:36:28.164142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1277
 
15.5%
534
 
6.5%
452
 
5.5%
448
 
5.4%
438
 
5.3%
426
 
5.2%
426
 
5.2%
426
 
5.2%
274
 
3.3%
1 268
 
3.3%
Other values (168) 3263
39.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5529
67.2%
Decimal Number 1331
 
16.2%
Space Separator 1277
 
15.5%
Dash Punctuation 95
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
534
 
9.7%
452
 
8.2%
448
 
8.1%
438
 
7.9%
426
 
7.7%
426
 
7.7%
426
 
7.7%
274
 
5.0%
181
 
3.3%
153
 
2.8%
Other values (156) 1771
32.0%
Decimal Number
ValueCountFrequency (%)
1 268
20.1%
2 217
16.3%
3 200
15.0%
0 114
8.6%
4 113
8.5%
5 107
 
8.0%
9 93
 
7.0%
6 91
 
6.8%
7 75
 
5.6%
8 53
 
4.0%
Space Separator
ValueCountFrequency (%)
1277
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 95
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5529
67.2%
Common 2703
32.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
534
 
9.7%
452
 
8.2%
448
 
8.1%
438
 
7.9%
426
 
7.7%
426
 
7.7%
426
 
7.7%
274
 
5.0%
181
 
3.3%
153
 
2.8%
Other values (156) 1771
32.0%
Common
ValueCountFrequency (%)
1277
47.2%
1 268
 
9.9%
2 217
 
8.0%
3 200
 
7.4%
0 114
 
4.2%
4 113
 
4.2%
5 107
 
4.0%
- 95
 
3.5%
9 93
 
3.4%
6 91
 
3.4%
Other values (2) 128
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5529
67.2%
ASCII 2703
32.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1277
47.2%
1 268
 
9.9%
2 217
 
8.0%
3 200
 
7.4%
0 114
 
4.2%
4 113
 
4.2%
5 107
 
4.0%
- 95
 
3.5%
9 93
 
3.4%
6 91
 
3.4%
Other values (2) 128
 
4.7%
Hangul
ValueCountFrequency (%)
534
 
9.7%
452
 
8.2%
448
 
8.1%
438
 
7.9%
426
 
7.7%
426
 
7.7%
426
 
7.7%
274
 
5.0%
181
 
3.3%
153
 
2.8%
Other values (156) 1771
32.0%
Distinct336
Distinct (%)78.5%
Missing1
Missing (%)0.2%
Memory size3.5 KiB
2023-12-12T21:36:28.437549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length19.380841
Min length15

Characters and Unicode

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

Unique

Unique274 ?
Unique (%)64.0%

Sample

1st row세종특별자치시 금남면 용포리 92-4
2nd row세종특별자치시 금남면 용담리 263-3
3rd row세종특별자치시 소정면 대곡리 31-4
4th row세종특별자치시 고운동 1716
5th row세종특별자치시 부강면 부강리 458-1
ValueCountFrequency (%)
세종특별자치시 424
26.9%
조치원읍 98
 
6.2%
나성동 45
 
2.9%
연서면 36
 
2.3%
금남면 35
 
2.2%
어진동 33
 
2.1%
부강면 25
 
1.6%
장군면 24
 
1.5%
전의면 20
 
1.3%
침산리 18
 
1.1%
Other values (391) 818
51.9%
2023-12-12T21:36:28.853537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1342
16.2%
522
 
6.3%
424
 
5.1%
424
 
5.1%
424
 
5.1%
424
 
5.1%
424
 
5.1%
424
 
5.1%
278
 
3.4%
1 263
 
3.2%
Other values (114) 3346
40.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5191
62.6%
Decimal Number 1526
 
18.4%
Space Separator 1342
 
16.2%
Dash Punctuation 235
 
2.8%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
522
 
10.1%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
278
 
5.4%
180
 
3.5%
175
 
3.4%
Other values (101) 1492
28.7%
Decimal Number
ValueCountFrequency (%)
1 263
17.2%
7 202
13.2%
2 184
12.1%
6 184
12.1%
4 151
9.9%
5 139
9.1%
8 131
8.6%
3 108
7.1%
0 91
 
6.0%
9 73
 
4.8%
Space Separator
ValueCountFrequency (%)
1342
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 235
100.0%
Uppercase Letter
ValueCountFrequency (%)
E 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5191
62.6%
Common 3103
37.4%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
522
 
10.1%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
278
 
5.4%
180
 
3.5%
175
 
3.4%
Other values (101) 1492
28.7%
Common
ValueCountFrequency (%)
1342
43.2%
1 263
 
8.5%
- 235
 
7.6%
7 202
 
6.5%
2 184
 
5.9%
6 184
 
5.9%
4 151
 
4.9%
5 139
 
4.5%
8 131
 
4.2%
3 108
 
3.5%
Other values (2) 164
 
5.3%
Latin
ValueCountFrequency (%)
E 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5191
62.6%
ASCII 3104
37.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1342
43.2%
1 263
 
8.5%
- 235
 
7.6%
7 202
 
6.5%
2 184
 
5.9%
6 184
 
5.9%
4 151
 
4.9%
5 139
 
4.5%
8 131
 
4.2%
3 108
 
3.5%
Other values (3) 165
 
5.3%
Hangul
ValueCountFrequency (%)
522
 
10.1%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
424
 
8.2%
278
 
5.4%
180
 
3.5%
175
 
3.4%
Other values (101) 1492
28.7%

전화번호
Text

MISSING 

Distinct365
Distinct (%)97.3%
Missing54
Missing (%)12.6%
Memory size3.5 KiB
2023-12-12T21:36:29.141386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.053333
Min length12

Characters and Unicode

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

Unique356 ?
Unique (%)94.9%

Sample

1st row044-868-9092
2nd row044-867-0407
3rd row044-867-2226
4th row044-868-1621
5th row070-4383-1614
ValueCountFrequency (%)
044-863-2016 3
 
0.8%
044-865-0221 2
 
0.5%
044-866-6753 2
 
0.5%
044-866-1732 2
 
0.5%
044-864-0411 2
 
0.5%
044-903-3943 2
 
0.5%
044-867-0407 2
 
0.5%
044-862-8080 2
 
0.5%
044-868-0680 2
 
0.5%
044-557-0900 1
 
0.3%
Other values (355) 355
94.7%
2023-12-12T21:36:29.632383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 895
19.8%
- 750
16.6%
0 622
13.8%
8 537
11.9%
6 505
11.2%
5 247
 
5.5%
3 224
 
5.0%
1 199
 
4.4%
7 197
 
4.4%
2 194
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3770
83.4%
Dash Punctuation 750
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 895
23.7%
0 622
16.5%
8 537
14.2%
6 505
13.4%
5 247
 
6.6%
3 224
 
5.9%
1 199
 
5.3%
7 197
 
5.2%
2 194
 
5.1%
9 150
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 750
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4520
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 895
19.8%
- 750
16.6%
0 622
13.8%
8 537
11.9%
6 505
11.2%
5 247
 
5.5%
3 224
 
5.0%
1 199
 
4.4%
7 197
 
4.4%
2 194
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4520
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 895
19.8%
- 750
16.6%
0 622
13.8%
8 537
11.9%
6 505
11.2%
5 247
 
5.5%
3 224
 
5.0%
1 199
 
4.4%
7 197
 
4.4%
2 194
 
4.3%

Interactions

2023-12-12T21:36:25.430159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:36:29.749243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호업종
번호1.0000.342
업종0.3421.000
2023-12-12T21:36:29.842478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호업종
번호1.0000.140
업종0.1401.000

Missing values

2023-12-12T21:36:25.573410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:36:25.701025image/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-12T21:36:25.803046image/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(유)다함토목공사업세종특별자치시 금남면 용포로 58세종특별자치시 금남면 용포리 92-4044-868-9092
12(유)안전세종도장ㆍ습식ㆍ방수ㆍ석공사업세종특별자치시 금남면 안금로 251세종특별자치시 금남면 용담리 263-3044-867-0407
23(유)이음유앤아이조경식재ㆍ시설물공사업세종특별자치시 소정면 작은황골길 78세종특별자치시 소정면 대곡리 31-4044-867-2226
34(주)가온건설산업지반조성ㆍ포장공사업세종특별자치시 고운서길 20 501호세종특별자치시 고운동 1716044-868-1621
45(주)건솔도장ㆍ습식ㆍ방수ㆍ석공사업세종특별자치시 부강면 시장길 38세종특별자치시 부강면 부강리 458-1070-4383-1614
56(주)건일철근ㆍ콘크리트공사업세종특별자치시 소정면 아야목길 45세종특별자치시 소정면 고등리 217-7044-868-0757
67(주)경관조경식재ㆍ시설물공사업세종특별자치시 한누리대로 2143세종특별자치시 보람동 742<NA>
78(주)구봉조경식재ㆍ시설물공사업세종특별자치시 조치원읍 충현로 114세종특별자치시 조치원읍 침산리 167-31044-865-0695
89(주)그린랜드도장ㆍ습식ㆍ방수ㆍ석공사업세종특별자치시 조치원읍 신흥샛터길 46세종특별자치시 조치원읍 신흥리 45-2044-866-1503
910(주)금강피스코상ㆍ하수도설비공사업세종특별자치시 소정면 학수소사길 63세종특별자치시 소정면 대곡리 368-8044-868-7048
번호상호업종도로명주소지번주소전화번호
419420헤브론건설(주)상ㆍ하수도설비공사업세종특별자치시 전의면 세종로 3890세종특별자치시 전의면 유천리 545-6044-866-0532
420421현대가스가스난방공사업세종특별자치시 소정면 소정샘골길 42-6세종특별자치시 소정면 소정리 170044-566-5900
421422형제가스가스난방공사업세종특별자치시 부강면 부강금호로 111세종특별자치시 부강면 부강리 767-1044-275-5271
422423형창토건(주)상ㆍ하수도설비공사업세종특별자치시 조치원읍 문화로 27세종특별자치시 조치원읍 교리 18-9044-868-3302
423424호등종합건설(주)토목건축공사업세종특별자치시 연서면 아홉거리길 100세종특별자치시 연서면 월하리 948-8044-862-6272
424425화이젠조경식재ㆍ시설물공사업세종특별자치시 나성북1로 22세종특별자치시 나성동 790070-4142-3500
425426효림종합건설(주)조경공사업세종특별자치시 금남면 초정길 17세종특별자치시 금남면 대박리 313-14044-867-4710
426427효성TMC기계가스설비공사업세종특별자치시 금남면 성덕영곡길 253세종특별자치시 금남면 영곡리 236-1044-864-3189
427428효성종합건설토목건축공사업세종특별자치시 국세청로 32세종특별자치시 나성동 815044-864-2056
428429희진조경주식회사조경식재ㆍ시설물공사업세종특별자치시 한누리대로 1948세종특별자치시 반곡동 771-68044-903-3868