Overview

Dataset statistics

Number of variables4
Number of observations596
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.3 KiB
Average record size in memory33.2 B

Variable types

Numeric1
Text3

Dataset

Description전라남도 여수시 전문건설업 현황(상호, 업종, 소재지)이며, 자료추출은 건설업관리시스템에서 추출하였음자료추출 기준일 2024. 2. 13.제공부서 여수시 도시게획과
Author전라남도 여수시
URLhttps://www.data.go.kr/data/15126663/fileData.do

Alerts

연번 has unique valuesUnique
상호 has unique valuesUnique

Reproduction

Analysis started2024-04-17 16:32:50.270952
Analysis finished2024-04-17 16:32:50.685907
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct596
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean298.5
Minimum1
Maximum596
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.4 KiB
2024-04-18T01:32:50.746789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile30.75
Q1149.75
median298.5
Q3447.25
95-th percentile566.25
Maximum596
Range595
Interquartile range (IQR)297.5

Descriptive statistics

Standard deviation172.19466
Coefficient of variation (CV)0.57686652
Kurtosis-1.2
Mean298.5
Median Absolute Deviation (MAD)149
Skewness0
Sum177906
Variance29651
MonotonicityStrictly increasing
2024-04-18T01:32:50.862604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
394 1
 
0.2%
396 1
 
0.2%
397 1
 
0.2%
398 1
 
0.2%
399 1
 
0.2%
400 1
 
0.2%
401 1
 
0.2%
402 1
 
0.2%
403 1
 
0.2%
Other values (586) 586
98.3%
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 (%)
596 1
0.2%
595 1
0.2%
594 1
0.2%
593 1
0.2%
592 1
0.2%
591 1
0.2%
590 1
0.2%
589 1
0.2%
588 1
0.2%
587 1
0.2%

상호
Text

UNIQUE 

Distinct596
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2024-04-18T01:32:51.033958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length13
Mean length7.6560403
Min length3

Characters and Unicode

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

Unique

Unique596 ?
Unique (%)100.0%

Sample

1st row(유)건영
2nd row(유)건일건설
3rd row(유)금강하이테크
4th row(유)다온산업
5th row(유)대도진흥
ValueCountFrequency (%)
유)건영 1
 
0.2%
이온텍주식회사 1
 
0.2%
재영냉난방시스템 1
 
0.2%
일광건설주식회사 1
 
0.2%
일신기술(주 1
 
0.2%
일영산업주식회사 1
 
0.2%
일일구가스 1
 
0.2%
장한건설(주 1
 
0.2%
재성건설주식회사 1
 
0.2%
재원건설(주 1
 
0.2%
Other values (586) 586
98.3%
2024-04-18T01:32:51.330122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
483
 
10.6%
( 305
 
6.7%
) 305
 
6.7%
210
 
4.6%
206
 
4.5%
191
 
4.2%
167
 
3.7%
159
 
3.5%
124
 
2.7%
90
 
2.0%
Other values (287) 2323
50.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3900
85.5%
Open Punctuation 305
 
6.7%
Close Punctuation 305
 
6.7%
Uppercase Letter 41
 
0.9%
Decimal Number 5
 
0.1%
Other Punctuation 4
 
0.1%
Lowercase Letter 1
 
< 0.1%
Other Symbol 1
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
483
 
12.4%
210
 
5.4%
206
 
5.3%
191
 
4.9%
167
 
4.3%
159
 
4.1%
124
 
3.2%
90
 
2.3%
85
 
2.2%
66
 
1.7%
Other values (268) 2119
54.3%
Uppercase Letter
ValueCountFrequency (%)
N 11
26.8%
E 11
26.8%
G 9
22.0%
A 3
 
7.3%
S 2
 
4.9%
C 2
 
4.9%
Y 1
 
2.4%
J 1
 
2.4%
W 1
 
2.4%
Decimal Number
ValueCountFrequency (%)
1 3
60.0%
4 1
 
20.0%
2 1
 
20.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
50.0%
. 2
50.0%
Open Punctuation
ValueCountFrequency (%)
( 305
100.0%
Close Punctuation
ValueCountFrequency (%)
) 305
100.0%
Lowercase Letter
ValueCountFrequency (%)
u 1
100.0%
Other Symbol
ValueCountFrequency (%)
1
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3901
85.5%
Common 620
 
13.6%
Latin 42
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
483
 
12.4%
210
 
5.4%
206
 
5.3%
191
 
4.9%
167
 
4.3%
159
 
4.1%
124
 
3.2%
90
 
2.3%
85
 
2.2%
66
 
1.7%
Other values (269) 2120
54.3%
Latin
ValueCountFrequency (%)
N 11
26.2%
E 11
26.2%
G 9
21.4%
A 3
 
7.1%
S 2
 
4.8%
C 2
 
4.8%
Y 1
 
2.4%
J 1
 
2.4%
W 1
 
2.4%
u 1
 
2.4%
Common
ValueCountFrequency (%)
( 305
49.2%
) 305
49.2%
1 3
 
0.5%
/ 2
 
0.3%
. 2
 
0.3%
4 1
 
0.2%
2 1
 
0.2%
+ 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3900
85.5%
ASCII 662
 
14.5%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
483
 
12.4%
210
 
5.4%
206
 
5.3%
191
 
4.9%
167
 
4.3%
159
 
4.1%
124
 
3.2%
90
 
2.3%
85
 
2.2%
66
 
1.7%
Other values (268) 2119
54.3%
ASCII
ValueCountFrequency (%)
( 305
46.1%
) 305
46.1%
N 11
 
1.7%
E 11
 
1.7%
G 9
 
1.4%
1 3
 
0.5%
A 3
 
0.5%
/ 2
 
0.3%
S 2
 
0.3%
. 2
 
0.3%
Other values (8) 9
 
1.4%
None
ValueCountFrequency (%)
1
100.0%
Distinct214
Distinct (%)35.9%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2024-04-18T01:32:51.497036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length115
Median length72
Mean length16.236577
Min length3

Characters and Unicode

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

Unique

Unique169 ?
Unique (%)28.4%

Sample

1st row상ㆍ하수도설비공사, 철근ㆍ콘크리트공사
2nd row도장공사,석공사, 철근ㆍ콘크리트공사,상ㆍ하수도설비공사
3rd row도장공사
4th row기계설비공사
5th row습식ㆍ방수공사
ValueCountFrequency (%)
기계설비공사 115
 
17.5%
철근ㆍ콘크리트공사 37
 
5.6%
가스시설공사(제2종 32
 
4.9%
난방공사(제2종 26
 
3.9%
조경식재공사,조경시설물설치공사 25
 
3.8%
금속구조물ㆍ창호ㆍ온실공사 24
 
3.6%
구조물해체ㆍ비계공사 24
 
3.6%
도장공사 21
 
3.2%
가스시설공사(제3종),난방공사(제2종 14
 
2.1%
실내건축공사 13
 
2.0%
Other values (185) 328
49.8%
2024-04-18T01:32:52.047891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1234
 
12.8%
1227
 
12.7%
, 638
 
6.6%
431
 
4.5%
421
 
4.4%
341
 
3.5%
301
 
3.1%
278
 
2.9%
245
 
2.5%
194
 
2.0%
Other values (60) 4367
45.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8533
88.2%
Other Punctuation 638
 
6.6%
Open Punctuation 148
 
1.5%
Decimal Number 148
 
1.5%
Close Punctuation 147
 
1.5%
Space Separator 63
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1234
 
14.5%
1227
 
14.4%
431
 
5.1%
421
 
4.9%
341
 
4.0%
301
 
3.5%
278
 
3.3%
245
 
2.9%
194
 
2.3%
194
 
2.3%
Other values (53) 3667
43.0%
Decimal Number
ValueCountFrequency (%)
2 85
57.4%
1 45
30.4%
3 18
 
12.2%
Other Punctuation
ValueCountFrequency (%)
, 638
100.0%
Open Punctuation
ValueCountFrequency (%)
( 148
100.0%
Close Punctuation
ValueCountFrequency (%)
) 147
100.0%
Space Separator
ValueCountFrequency (%)
63
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8533
88.2%
Common 1144
 
11.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1234
 
14.5%
1227
 
14.4%
431
 
5.1%
421
 
4.9%
341
 
4.0%
301
 
3.5%
278
 
3.3%
245
 
2.9%
194
 
2.3%
194
 
2.3%
Other values (53) 3667
43.0%
Common
ValueCountFrequency (%)
, 638
55.8%
( 148
 
12.9%
) 147
 
12.8%
2 85
 
7.4%
63
 
5.5%
1 45
 
3.9%
3 18
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8112
83.8%
ASCII 1144
 
11.8%
Compat Jamo 421
 
4.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
1234
 
15.2%
1227
 
15.1%
431
 
5.3%
341
 
4.2%
301
 
3.7%
278
 
3.4%
245
 
3.0%
194
 
2.4%
194
 
2.4%
151
 
1.9%
Other values (52) 3516
43.3%
ASCII
ValueCountFrequency (%)
, 638
55.8%
( 148
 
12.9%
) 147
 
12.8%
2 85
 
7.4%
63
 
5.5%
1 45
 
3.9%
3 18
 
1.6%
Compat Jamo
ValueCountFrequency (%)
421
100.0%
Distinct561
Distinct (%)94.1%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2024-04-18T01:32:52.297959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length36
Mean length23.65604
Min length15

Characters and Unicode

Total characters14099
Distinct characters158
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

Unique533 ?
Unique (%)89.4%

Sample

1st row전라남도 여수시 학동5길 1 (학동)
2nd row전라남도 여수시 하멜로 30 (고소동)
3rd row전라남도 여수시 좌수영로 311 2층 (오림동)
4th row전라남도 여수시 여수산단로 562 (중흥동)
5th row전라남도 여수시 삼동2길 18 (주삼동)
ValueCountFrequency (%)
여수시 594
 
19.1%
전라남도 587
 
18.8%
소라면 63
 
2.0%
2층 62
 
2.0%
화장동 48
 
1.5%
좌수영로 43
 
1.4%
신기동 42
 
1.3%
주삼동 34
 
1.1%
학동 33
 
1.1%
여수산단로 29
 
0.9%
Other values (715) 1580
50.7%
2024-04-18T01:32:52.655033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2519
17.9%
708
 
5.0%
689
 
4.9%
652
 
4.6%
628
 
4.5%
622
 
4.4%
600
 
4.3%
599
 
4.2%
517
 
3.7%
1 497
 
3.5%
Other values (148) 6068
43.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8169
57.9%
Space Separator 2519
 
17.9%
Decimal Number 2217
 
15.7%
Open Punctuation 469
 
3.3%
Close Punctuation 469
 
3.3%
Dash Punctuation 221
 
1.6%
Other Punctuation 31
 
0.2%
Uppercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
708
 
8.7%
689
 
8.4%
652
 
8.0%
628
 
7.7%
622
 
7.6%
600
 
7.3%
599
 
7.3%
517
 
6.3%
344
 
4.2%
252
 
3.1%
Other values (128) 2558
31.3%
Decimal Number
ValueCountFrequency (%)
1 497
22.4%
2 368
16.6%
3 266
12.0%
5 204
9.2%
4 186
 
8.4%
7 166
 
7.5%
6 163
 
7.4%
0 133
 
6.0%
8 128
 
5.8%
9 106
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
A 1
25.0%
P 1
25.0%
T 1
25.0%
F 1
25.0%
Other Punctuation
ValueCountFrequency (%)
, 17
54.8%
14
45.2%
Space Separator
ValueCountFrequency (%)
2519
100.0%
Open Punctuation
ValueCountFrequency (%)
( 469
100.0%
Close Punctuation
ValueCountFrequency (%)
) 469
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 221
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8169
57.9%
Common 5926
42.0%
Latin 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
708
 
8.7%
689
 
8.4%
652
 
8.0%
628
 
7.7%
622
 
7.6%
600
 
7.3%
599
 
7.3%
517
 
6.3%
344
 
4.2%
252
 
3.1%
Other values (128) 2558
31.3%
Common
ValueCountFrequency (%)
2519
42.5%
1 497
 
8.4%
( 469
 
7.9%
) 469
 
7.9%
2 368
 
6.2%
3 266
 
4.5%
- 221
 
3.7%
5 204
 
3.4%
4 186
 
3.1%
7 166
 
2.8%
Other values (6) 561
 
9.5%
Latin
ValueCountFrequency (%)
A 1
25.0%
P 1
25.0%
T 1
25.0%
F 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8169
57.9%
ASCII 5916
42.0%
None 14
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2519
42.6%
1 497
 
8.4%
( 469
 
7.9%
) 469
 
7.9%
2 368
 
6.2%
3 266
 
4.5%
- 221
 
3.7%
5 204
 
3.4%
4 186
 
3.1%
7 166
 
2.8%
Other values (9) 551
 
9.3%
Hangul
ValueCountFrequency (%)
708
 
8.7%
689
 
8.4%
652
 
8.0%
628
 
7.7%
622
 
7.6%
600
 
7.3%
599
 
7.3%
517
 
6.3%
344
 
4.2%
252
 
3.1%
Other values (128) 2558
31.3%
None
ValueCountFrequency (%)
14
100.0%

Interactions

2024-04-18T01:32:50.505599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-04-18T01:32:50.595768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-18T01:32:50.659154image/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(유)건영상ㆍ하수도설비공사, 철근ㆍ콘크리트공사전라남도 여수시 학동5길 1 (학동)
12(유)건일건설도장공사,석공사, 철근ㆍ콘크리트공사,상ㆍ하수도설비공사전라남도 여수시 하멜로 30 (고소동)
23(유)금강하이테크도장공사전라남도 여수시 좌수영로 311 2층 (오림동)
34(유)다온산업기계설비공사전라남도 여수시 여수산단로 562 (중흥동)
45(유)대도진흥습식ㆍ방수공사전라남도 여수시 삼동2길 18 (주삼동)
56(유)대동이엔지기계설비공사전라남도 여수시 좌수영로 812-13 (봉계동)
67(유)대현기업상ㆍ하수도설비공사,포장공사,기계설비공사전라남도 여수시 화양면 영터길 11
78(유)서울토건철근ㆍ콘크리트공사전라남도 여수시 신기남1길 16-12 (신기동)
89(유)성전이엔씨기계설비공사전라남도 여수시 좌수영로 889 2층 (여천동)
910(유)성찬건업금속구조물ㆍ창호ㆍ온실공사전라남도 여수시 좌수영로 445 (둔덕동)
연번상호업종(주력분야)영업소재지(도로명주소)
586587해수건설(주)철근ㆍ콘크리트공사전라남도 여수시 중흥3로 25-5 (중흥동)
587588현대가스설비가스시설공사(제2종)전라남도 여수시 신기북2길 13-1 (신기동)
588589현우플랜트(주)구조물해체ㆍ비계공사, 기계설비공사전라남도 여수시 소라면 봉두로 318
589590현주건설주식회사도장공사,석공사전라남도 여수시 율촌면 종개길 6
590591호일프랜트(주)토공사,금속구조물ㆍ창호ㆍ온실공사,철강구조물공사,기계설비공사,가스시설공사(제1종)전라남도 여수시 여수산단로 585 (중흥동)
591592홍보건축설비가스시설공사(제3종),난방공사(제2종)전라남도 여수시 신기남1길 10-1 (신기동)
592593화동설비난방공사(제2종)전라남도 여수시 화양면 화동로 160
593594화양가스가스시설공사(제2종)전라남도 여수시 화양면 옥천로 58
594595화양설비난방공사(제2종)전라남도 여수시 화양면 창무1길 49
595596흰돌건설(주)토공사,습식ㆍ방수공사,철근ㆍ콘크리트공사,구조물해체ㆍ비계공사전라남도 여수시 여수산단로 285-7 (월하동)