Overview

Dataset statistics

Number of variables21
Number of observations99
Missing cells456
Missing cells (%)21.9%
Duplicate rows1
Duplicate rows (%)1.0%
Total size in memory17.6 KiB
Average record size in memory182.3 B

Variable types

Categorical6
Text3
Numeric8
Unsupported4

Dataset

Description전력기술감리업체 현황_인허가
Author행정안전부
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=VJ00ZDXJIX7GPMRVV5QW14478627&infSeq=1

Alerts

업종구분명 has constant value ""Constant
Dataset has 1 (1.0%) duplicate rowsDuplicates
영업상태구분코드 is highly imbalanced (51.9%)Imbalance
영업상태명 is highly imbalanced (51.9%)Imbalance
인허가취소일자 has 99 (100.0%) missing valuesMissing
소재지시설전화번호 has 1 (1.0%) missing valuesMissing
소재지면적정보 has 99 (100.0%) missing valuesMissing
도로명우편번호 has 99 (100.0%) missing valuesMissing
소재지도로명주소 has 7 (7.1%) missing valuesMissing
업태구분명정보 has 99 (100.0%) missing valuesMissing
X좌표값 has 26 (26.3%) missing valuesMissing
Y좌표값 has 26 (26.3%) missing valuesMissing
인허가취소일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
소재지면적정보 is an unsupported type, check if it needs cleaning or further analysisUnsupported
도로명우편번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported
업태구분명정보 is an unsupported type, check if it needs cleaning or further analysisUnsupported
실질자본금 has 74 (74.7%) zerosZeros

Reproduction

Analysis started2023-12-10 21:13:48.361941
Analysis finished2023-12-10 21:13:48.791091
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

Distinct21
Distinct (%)21.2%
Missing0
Missing (%)0.0%
Memory size924.0 B
안양시
18 
성남시
17 
수원시
의정부시
고양시
Other values (16)
41 

Length

Max length4
Median length3
Mean length3.1010101
Min length3

Unique

Unique7 ?
Unique (%)7.1%

Sample

1st row고양시
2nd row고양시
3rd row고양시
4th row고양시
5th row고양시

Common Values

ValueCountFrequency (%)
안양시 18
18.2%
성남시 17
17.2%
수원시 9
9.1%
의정부시 7
 
7.1%
고양시 7
 
7.1%
안산시 6
 
6.1%
용인시 6
 
6.1%
양주시 5
 
5.1%
김포시 4
 
4.0%
평택시 4
 
4.0%
Other values (11) 16
16.2%

Length

2023-12-11T06:13:48.866562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
안양시 18
18.2%
성남시 17
17.2%
수원시 9
9.1%
의정부시 7
 
7.1%
고양시 7
 
7.1%
안산시 6
 
6.1%
용인시 6
 
6.1%
양주시 5
 
5.1%
김포시 4
 
4.0%
평택시 4
 
4.0%
Other values (11) 16
16.2%
Distinct88
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-11T06:13:49.091536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length17
Mean length9.8080808
Min length4

Characters and Unicode

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

Unique

Unique77 ?
Unique (%)77.8%

Sample

1st row(주)연합기술단
2nd row(주)뉴스타
3rd row(주)선진기술단
4th row(주)서광안전컨설팅
5th row(주)휴먼아키피아건축사사무소
ValueCountFrequency (%)
p&s엔지니어링 2
 
1.9%
오엑스엔지니어링(주 2
 
1.9%
주)동림컨설턴트 2
 
1.9%
대아기술단 2
 
1.9%
그린이엔지 2
 
1.9%
기술사사무소 2
 
1.9%
주)에이텍엔지니어링건축사사무소 2
 
1.9%
진성전기공사 2
 
1.9%
주)화인이엔씨 2
 
1.9%
주)백향엔지니어링 2
 
1.9%
Other values (81) 83
80.6%
2023-12-11T06:13:49.489721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
84
 
8.7%
( 83
 
8.5%
) 83
 
8.5%
45
 
4.6%
41
 
4.2%
39
 
4.0%
35
 
3.6%
32
 
3.3%
32
 
3.3%
32
 
3.3%
Other values (124) 465
47.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 795
81.9%
Open Punctuation 83
 
8.5%
Close Punctuation 83
 
8.5%
Space Separator 4
 
0.4%
Uppercase Letter 4
 
0.4%
Other Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
84
 
10.6%
45
 
5.7%
41
 
5.2%
39
 
4.9%
35
 
4.4%
32
 
4.0%
32
 
4.0%
32
 
4.0%
31
 
3.9%
22
 
2.8%
Other values (118) 402
50.6%
Uppercase Letter
ValueCountFrequency (%)
P 2
50.0%
S 2
50.0%
Open Punctuation
ValueCountFrequency (%)
( 83
100.0%
Close Punctuation
ValueCountFrequency (%)
) 83
100.0%
Space Separator
ValueCountFrequency (%)
4
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 795
81.9%
Common 172
 
17.7%
Latin 4
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
84
 
10.6%
45
 
5.7%
41
 
5.2%
39
 
4.9%
35
 
4.4%
32
 
4.0%
32
 
4.0%
32
 
4.0%
31
 
3.9%
22
 
2.8%
Other values (118) 402
50.6%
Common
ValueCountFrequency (%)
( 83
48.3%
) 83
48.3%
4
 
2.3%
& 2
 
1.2%
Latin
ValueCountFrequency (%)
P 2
50.0%
S 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 795
81.9%
ASCII 176
 
18.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
84
 
10.6%
45
 
5.7%
41
 
5.2%
39
 
4.9%
35
 
4.4%
32
 
4.0%
32
 
4.0%
32
 
4.0%
31
 
3.9%
22
 
2.8%
Other values (118) 402
50.6%
ASCII
ValueCountFrequency (%)
( 83
47.2%
) 83
47.2%
4
 
2.3%
& 2
 
1.1%
P 2
 
1.1%
S 2
 
1.1%

인허가일자
Real number (ℝ)

Distinct80
Distinct (%)80.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20062142
Minimum19970407
Maximum20071031
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:49.664772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19970407
5-th percentile20029407
Q120061228
median20070328
Q320070620
95-th percentile20071012
Maximum20071031
Range100624
Interquartile range (IQR)9392.5

Descriptive statistics

Standard deviation20876.482
Coefficient of variation (CV)0.0010405909
Kurtosis10.948748
Mean20062142
Median Absolute Deviation (MAD)300
Skewness-3.2834523
Sum1.9861521 × 109
Variance4.3582751 × 108
MonotonicityNot monotonic
2023-12-11T06:13:49.875572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20070416 3
 
3.0%
20070330 3
 
3.0%
20070226 2
 
2.0%
20070628 2
 
2.0%
20061215 2
 
2.0%
20070118 2
 
2.0%
20070509 2
 
2.0%
20070221 2
 
2.0%
20070215 2
 
2.0%
20070207 2
 
2.0%
Other values (70) 77
77.8%
ValueCountFrequency (%)
19970407 1
1.0%
19970526 1
1.0%
19970729 1
1.0%
19990414 1
1.0%
20021221 1
1.0%
20030317 1
1.0%
20030611 1
1.0%
20030731 1
1.0%
20030807 1
1.0%
20030819 1
1.0%
ValueCountFrequency (%)
20071031 1
1.0%
20071024 1
1.0%
20071023 1
1.0%
20071022 1
1.0%
20071016 1
1.0%
20071011 1
1.0%
20071010 1
1.0%
20071005 1
1.0%
20070910 1
1.0%
20070905 1
1.0%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing99
Missing (%)100.0%
Memory size1023.0 B

영업상태구분코드
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
1
80 
3
18 
6
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 80
80.8%
3 18
 
18.2%
6 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-11T06:13:50.141013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 80
80.8%
3 18
 
18.2%
6 1
 
1.0%

영업상태명
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
인허가
80 
폐업
18 
합병말소
 
1

Length

Max length4
Median length3
Mean length2.8282828
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row인허가
2nd row인허가
3rd row인허가
4th row인허가
5th row인허가

Common Values

ValueCountFrequency (%)
인허가 80
80.8%
폐업 18
 
18.2%
합병말소 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-11T06:13:50.360442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인허가 80
80.8%
폐업 18
 
18.2%
합병말소 1
 
1.0%

소재지시설전화번호
Real number (ℝ)

MISSING 

Distinct84
Distinct (%)85.7%
Missing1
Missing (%)1.0%
Infinite0
Infinite (%)0.0%
Mean2.974353 × 108
Minimum24612628
Maximum4.2552801 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:50.709976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum24612628
5-th percentile1.9169806 × 108
Q13.1336786 × 108
median3.1484504 × 108
Q33.1777876 × 108
95-th percentile3.1991141 × 108
Maximum4.2552801 × 108
Range4.0091538 × 108
Interquartile range (IQR)4410901

Descriptive statistics

Standard deviation67600607
Coefficient of variation (CV)0.22727836
Kurtosis11.496901
Mean2.974353 × 108
Median Absolute Deviation (MAD)2517756.5
Skewness-3.3976092
Sum2.9148659 × 1010
Variance4.5698421 × 1015
MonotonicityNot monotonic
2023-12-11T06:13:50.881406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
317762233 2
 
2.0%
323241538 2
 
2.0%
319696114 2
 
2.0%
313849600 2
 
2.0%
25158965 2
 
2.0%
317587697 2
 
2.0%
317778765 2
 
2.0%
314220872 2
 
2.0%
313368050 2
 
2.0%
317562742 2
 
2.0%
Other values (74) 78
78.8%
ValueCountFrequency (%)
24612628 1
1.0%
24612630 1
1.0%
25158965 2
2.0%
27583884 1
1.0%
220659384 1
1.0%
221226906 1
1.0%
222036323 1
1.0%
236604263 1
1.0%
236646791 1
1.0%
264054931 1
1.0%
ValueCountFrequency (%)
425528010 1
1.0%
326632881 1
1.0%
323241538 2
2.0%
319986807 1
1.0%
319898099 1
1.0%
319700038 1
1.0%
319696114 2
2.0%
319494220 1
1.0%
319250445 1
1.0%
319241252 1
1.0%

소재지면적정보
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing99
Missing (%)100.0%
Memory size1023.0 B

도로명우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing99
Missing (%)100.0%
Memory size1023.0 B
Distinct83
Distinct (%)90.2%
Missing7
Missing (%)7.1%
Memory size924.0 B
2023-12-11T06:13:51.129569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length36
Mean length29.456522
Min length19

Characters and Unicode

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

Unique

Unique75 ?
Unique (%)81.5%

Sample

1st row경기도 고양시 덕양구 용현로35번길 8-16 (행신동,301호)
2nd row경기도 고양시 덕양구 화정로 53-1 704호 (화정동,글로리아빌딩)
3rd row경기도 고양시 일산서구 중앙로 1568 (대화동,하성상가 705호)
4th row경기도 고양시 덕양구 화정로 53-1 706호 (화정동,글로리아빌딩)
5th row경기도 고양시 일산서구 중앙로 1576 (대화동,태진빌딩 605)
ValueCountFrequency (%)
경기도 90
 
16.5%
안양시 18
 
3.3%
성남시 15
 
2.8%
동안구 15
 
2.8%
수원시 8
 
1.5%
의정부시 7
 
1.3%
관양동 7
 
1.3%
고양시 7
 
1.3%
분당구 6
 
1.1%
중원구 6
 
1.1%
Other values (261) 365
67.1%
2023-12-11T06:13:51.543392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
452
 
16.7%
107
 
3.9%
96
 
3.5%
94
 
3.5%
93
 
3.4%
92
 
3.4%
91
 
3.4%
( 88
 
3.2%
) 88
 
3.2%
1 75
 
2.8%
Other values (178) 1434
52.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1613
59.5%
Space Separator 452
 
16.7%
Decimal Number 421
 
15.5%
Open Punctuation 88
 
3.2%
Close Punctuation 88
 
3.2%
Other Punctuation 35
 
1.3%
Dash Punctuation 11
 
0.4%
Lowercase Letter 1
 
< 0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
107
 
6.6%
96
 
6.0%
94
 
5.8%
93
 
5.8%
92
 
5.7%
91
 
5.6%
66
 
4.1%
56
 
3.5%
49
 
3.0%
40
 
2.5%
Other values (161) 829
51.4%
Decimal Number
ValueCountFrequency (%)
1 75
17.8%
3 56
13.3%
2 55
13.1%
5 45
10.7%
0 42
10.0%
4 38
9.0%
6 35
8.3%
7 30
 
7.1%
9 23
 
5.5%
8 22
 
5.2%
Space Separator
ValueCountFrequency (%)
452
100.0%
Open Punctuation
ValueCountFrequency (%)
( 88
100.0%
Close Punctuation
ValueCountFrequency (%)
) 88
100.0%
Other Punctuation
ValueCountFrequency (%)
, 35
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1613
59.5%
Common 1095
40.4%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
107
 
6.6%
96
 
6.0%
94
 
5.8%
93
 
5.8%
92
 
5.7%
91
 
5.6%
66
 
4.1%
56
 
3.5%
49
 
3.0%
40
 
2.5%
Other values (161) 829
51.4%
Common
ValueCountFrequency (%)
452
41.3%
( 88
 
8.0%
) 88
 
8.0%
1 75
 
6.8%
3 56
 
5.1%
2 55
 
5.0%
5 45
 
4.1%
0 42
 
3.8%
4 38
 
3.5%
6 35
 
3.2%
Other values (5) 121
 
11.1%
Latin
ValueCountFrequency (%)
c 1
50.0%
B 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1613
59.5%
ASCII 1097
40.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
452
41.2%
( 88
 
8.0%
) 88
 
8.0%
1 75
 
6.8%
3 56
 
5.1%
2 55
 
5.0%
5 45
 
4.1%
0 42
 
3.8%
4 38
 
3.5%
6 35
 
3.2%
Other values (7) 123
 
11.2%
Hangul
ValueCountFrequency (%)
107
 
6.6%
96
 
6.0%
94
 
5.8%
93
 
5.8%
92
 
5.7%
91
 
5.6%
66
 
4.1%
56
 
3.5%
49
 
3.0%
40
 
2.5%
Other values (161) 829
51.4%
Distinct91
Distinct (%)91.9%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-11T06:13:51.779817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length38
Mean length28.383838
Min length19

Characters and Unicode

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

Unique

Unique84 ?
Unique (%)84.8%

Sample

1st row경기도 고양시덕양구 행신동 754번지 301호
2nd row경기도 고양시덕양구 화정동 967-3번지 글로리아프라자 704호
3rd row경기도 고양시일산서구 대화동 2203번지 하성상가 705호
4th row경기도 고양시덕양구 화정동 967-3번지 글로리아프라자 706호
5th row경기도 고양시일산서구 대화동 2205번지 태진빌딩 605
ValueCountFrequency (%)
경기도 97
 
18.5%
안양시동안구 15
 
2.9%
1호 11
 
2.1%
4호 10
 
1.9%
성남시중원구 7
 
1.3%
의정부시 7
 
1.3%
9호 6
 
1.1%
성남시분당구 6
 
1.1%
관양1동 5
 
1.0%
양주시 5
 
1.0%
Other values (253) 355
67.7%
2023-12-11T06:13:52.137745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
610
21.7%
114
 
4.1%
101
 
3.6%
101
 
3.6%
100
 
3.6%
99
 
3.5%
1 98
 
3.5%
98
 
3.5%
97
 
3.5%
92
 
3.3%
Other values (172) 1300
46.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1623
57.8%
Space Separator 610
 
21.7%
Decimal Number 550
 
19.6%
Dash Punctuation 19
 
0.7%
Uppercase Letter 3
 
0.1%
Lowercase Letter 2
 
0.1%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
114
 
7.0%
101
 
6.2%
101
 
6.2%
100
 
6.2%
99
 
6.1%
98
 
6.0%
97
 
6.0%
92
 
5.7%
69
 
4.3%
51
 
3.1%
Other values (152) 701
43.2%
Decimal Number
ValueCountFrequency (%)
1 98
17.8%
2 77
14.0%
3 64
11.6%
4 58
10.5%
0 57
10.4%
7 49
8.9%
5 47
8.5%
9 41
7.5%
6 30
 
5.5%
8 29
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
B 1
33.3%
S 1
33.3%
K 1
33.3%
Lowercase Letter
ValueCountFrequency (%)
c 1
50.0%
n 1
50.0%
Space Separator
ValueCountFrequency (%)
610
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1623
57.8%
Common 1182
42.1%
Latin 5
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
114
 
7.0%
101
 
6.2%
101
 
6.2%
100
 
6.2%
99
 
6.1%
98
 
6.0%
97
 
6.0%
92
 
5.7%
69
 
4.3%
51
 
3.1%
Other values (152) 701
43.2%
Common
ValueCountFrequency (%)
610
51.6%
1 98
 
8.3%
2 77
 
6.5%
3 64
 
5.4%
4 58
 
4.9%
0 57
 
4.8%
7 49
 
4.1%
5 47
 
4.0%
9 41
 
3.5%
6 30
 
2.5%
Other values (5) 51
 
4.3%
Latin
ValueCountFrequency (%)
c 1
20.0%
B 1
20.0%
S 1
20.0%
K 1
20.0%
n 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1623
57.8%
ASCII 1187
42.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
610
51.4%
1 98
 
8.3%
2 77
 
6.5%
3 64
 
5.4%
4 58
 
4.9%
0 57
 
4.8%
7 49
 
4.1%
5 47
 
4.0%
9 41
 
3.5%
6 30
 
2.5%
Other values (10) 56
 
4.7%
Hangul
ValueCountFrequency (%)
114
 
7.0%
101
 
6.2%
101
 
6.2%
100
 
6.2%
99
 
6.1%
98
 
6.0%
97
 
6.0%
92
 
5.7%
69
 
4.3%
51
 
3.1%
Other values (152) 701
43.2%

소재지우편번호
Real number (ℝ)

Distinct79
Distinct (%)79.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean440900.25
Minimum138837
Maximum482871
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:52.269981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum138837
5-th percentile411805
Q1430324
median441878
Q3462817
95-th percentile480983.5
Maximum482871
Range344034
Interquartile range (IQR)32493

Descriptive statistics

Standard deviation39178.055
Coefficient of variation (CV)0.088859225
Kurtosis36.157231
Mean440900.25
Median Absolute Deviation (MAD)19928
Skewness-4.8790475
Sum43649125
Variance1.53492 × 109
MonotonicityNot monotonic
2023-12-11T06:13:52.418558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
431807 4
 
4.0%
480010 3
 
3.0%
480865 2
 
2.0%
431841 2
 
2.0%
412270 2
 
2.0%
425906 2
 
2.0%
431050 2
 
2.0%
442843 2
 
2.0%
482050 2
 
2.0%
449815 2
 
2.0%
Other values (69) 76
76.8%
ValueCountFrequency (%)
138837 1
1.0%
330020 1
1.0%
410360 1
1.0%
410380 1
1.0%
411805 2
2.0%
412220 1
1.0%
412270 2
2.0%
413010 1
1.0%
413821 1
1.0%
415050 1
1.0%
ValueCountFrequency (%)
482871 1
 
1.0%
482140 1
 
1.0%
482130 1
 
1.0%
482050 2
2.0%
480865 2
2.0%
480849 1
 
1.0%
480072 1
 
1.0%
480010 3
3.0%
472933 1
 
1.0%
471020 2
2.0%

WGS84위도
Real number (ℝ)

Distinct85
Distinct (%)85.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.442619
Minimum36.807241
Maximum37.864662
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:52.557069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.807241
5-th percentile37.1225
Q137.314636
median37.405111
Q337.612749
95-th percentile37.765949
Maximum37.864662
Range1.0574215
Interquartile range (IQR)0.2981133

Descriptive statistics

Standard deviation0.20413525
Coefficient of variation (CV)0.005451949
Kurtosis0.38873353
Mean37.442619
Median Absolute Deviation (MAD)0.1019844
Skewness-0.13027326
Sum3706.8193
Variance0.041671201
MonotonicityNot monotonic
2023-12-11T06:13:52.703624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.4051109 3
 
3.0%
37.2846825 2
 
2.0%
37.6627891 2
 
2.0%
37.8190353 2
 
2.0%
37.4325577 2
 
2.0%
37.4388024 2
 
2.0%
37.7525708 2
 
2.0%
37.7459855 2
 
2.0%
37.3916901 2
 
2.0%
37.4898967 2
 
2.0%
Other values (75) 78
78.8%
ValueCountFrequency (%)
36.8072407 1
1.0%
36.9887765 1
1.0%
36.9937971 2
2.0%
37.0014348 1
1.0%
37.135952 1
1.0%
37.2141297 1
1.0%
37.2345504 1
1.0%
37.2361353 1
1.0%
37.2540152 1
1.0%
37.2611239 1
1.0%
ValueCountFrequency (%)
37.8646622 1
1.0%
37.8190353 2
2.0%
37.8105889 1
1.0%
37.7844504 1
1.0%
37.7638935 1
1.0%
37.7590065 1
1.0%
37.7525708 2
2.0%
37.7494262 1
1.0%
37.7459855 2
2.0%
37.7343767 1
1.0%

WGS84경도
Real number (ℝ)

Distinct85
Distinct (%)85.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.99644
Minimum126.56265
Maximum127.31919
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:52.837598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.56265
5-th percentile126.7478
Q1126.93499
median127.01856
Q3127.11263
95-th percentile127.18479
Maximum127.31919
Range0.7565481
Interquartile range (IQR)0.1776444

Descriptive statistics

Standard deviation0.15117737
Coefficient of variation (CV)0.0011904064
Kurtosis0.10342324
Mean126.99644
Median Absolute Deviation (MAD)0.091352
Skewness-0.67636311
Sum12572.647
Variance0.022854598
MonotonicityNot monotonic
2023-12-11T06:13:52.967736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.9643337 3
 
3.0%
127.217203 2
 
2.0%
126.5626465 2
 
2.0%
127.0470163 2
 
2.0%
127.1590969 2
 
2.0%
127.1282395 2
 
2.0%
127.069376 2
 
2.0%
127.0490379 2
 
2.0%
126.9516478 2
 
2.0%
126.7564626 2
 
2.0%
Other values (75) 78
78.8%
ValueCountFrequency (%)
126.5626465 2
2.0%
126.6727447 1
1.0%
126.7193599 1
1.0%
126.7471294 1
1.0%
126.7478786 1
1.0%
126.7555255 1
1.0%
126.7564626 2
2.0%
126.7650995 1
1.0%
126.7782575 1
1.0%
126.7867655 1
1.0%
ValueCountFrequency (%)
127.3191946 1
1.0%
127.217203 2
2.0%
127.214731 1
1.0%
127.1905152 1
1.0%
127.1841555 1
1.0%
127.170841 1
1.0%
127.1687321 1
1.0%
127.1685172 1
1.0%
127.1640631 1
1.0%
127.1614011 1
1.0%

업태구분명정보
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing99
Missing (%)100.0%
Memory size1023.0 B

X좌표값
Real number (ℝ)

MISSING 

Distinct64
Distinct (%)87.7%
Missing26
Missing (%)26.3%
Infinite0
Infinite (%)0.0%
Mean200160.74
Minimum161346.99
Maximum228242.64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:53.116714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum161346.99
5-th percentile177667.73
Q1195651.67
median201200.42
Q3209682.01
95-th percentile217669.91
Maximum228242.64
Range66895.651
Interquartile range (IQR)14030.339

Descriptive statistics

Standard deviation13084.781
Coefficient of variation (CV)0.065371365
Kurtosis0.79769798
Mean200160.74
Median Absolute Deviation (MAD)7760.7727
Skewness-0.77279601
Sum14611734
Variance1.7121149 × 108
MonotonicityNot monotonic
2023-12-11T06:13:53.269241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
196777.850321928 3
 
3.0%
195651.673909625 2
 
2.0%
214017.029812623 2
 
2.0%
211283.670320813 2
 
2.0%
219196.35268678 2
 
2.0%
204139.131902 2
 
2.0%
208937.580791137 2
 
2.0%
196526.008225935 2
 
2.0%
197069.82356942 1
 
1.0%
195926.56393091 1
 
1.0%
Other values (54) 54
54.5%
(Missing) 26
26.3%
ValueCountFrequency (%)
161346.986707785 1
1.0%
161386.832823747 1
1.0%
175157.898424558 1
1.0%
177628.867467241 1
1.0%
177693.645 1
1.0%
180395.056070328 1
1.0%
181108.608529259 1
1.0%
181115.903503155 1
1.0%
181299.885530928 1
1.0%
185075.778286666 1
1.0%
ValueCountFrequency (%)
228242.637493685 1
1.0%
219196.35268678 2
2.0%
218913.619993448 1
1.0%
216840.765290407 1
1.0%
214422.24763 1
1.0%
214216.296234676 1
1.0%
214017.029812623 2
2.0%
211914.015716421 1
1.0%
211847.959607528 1
1.0%
211392.208839515 1
1.0%

Y좌표값
Real number (ℝ)

MISSING 

Distinct64
Distinct (%)87.7%
Missing26
Missing (%)26.3%
Infinite0
Infinite (%)0.0%
Mean432641.31
Minimum387475.67
Maximum479939.71
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:53.404438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum387475.67
5-th percentile397836.94
Q1422474.97
median432053.09
Q3437204.28
95-th percentile467495.81
Maximum479939.71
Range92464.036
Interquartile range (IQR)14729.319

Descriptive statistics

Standard deviation19430.134
Coefficient of variation (CV)0.044910491
Kurtosis1.0475097
Mean432641.31
Median Absolute Deviation (MAD)8412.6455
Skewness0.26236998
Sum31582816
Variance3.7753009 × 108
MonotonicityNot monotonic
2023-12-11T06:13:53.531170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
433677.726933482 3
 
3.0%
432187.915104016 2
 
2.0%
436734.115630983 2
 
2.0%
437423.509342085 2
 
2.0%
420331.566143047 2
 
2.0%
479939.705757 2
 
2.0%
388032.212559048 2
 
2.0%
429965.166931186 2
 
2.0%
433267.205928793 1
 
1.0%
432053.085008877 1
 
1.0%
Other values (54) 54
54.5%
(Missing) 26
26.3%
ValueCountFrequency (%)
387475.669486268 1
1.0%
388032.212559048 2
2.0%
388880.42007542 1
1.0%
403807.960210456 1
1.0%
412480.974351001 1
1.0%
414937.689010039 1
1.0%
416906.569138055 1
1.0%
417697.607580629 1
1.0%
418015.126882687 1
1.0%
418533.459417408 1
1.0%
ValueCountFrequency (%)
479939.705757 2
2.0%
478683.79753029 1
1.0%
472978.932283259 1
1.0%
463840.388783964 1
1.0%
463804.75 1
1.0%
462366.002384067 1
1.0%
462303.535851555 1
1.0%
460088.169930198 1
1.0%
457486.173634048 1
1.0%
457156.752015931 1
1.0%

업종구분명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
감리업
99 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row감리업
2nd row감리업
3rd row감리업
4th row감리업
5th row감리업

Common Values

ValueCountFrequency (%)
감리업 99
100.0%

Length

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

Common Values (Plot)

2023-12-11T06:13:53.758710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
감리업 99
100.0%
Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
종합감리업
52 
전문감리업
47 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row종합감리업
2nd row종합감리업
3rd row종합감리업
4th row전문감리업
5th row종합감리업

Common Values

ValueCountFrequency (%)
종합감리업 52
52.5%
전문감리업 47
47.5%

Length

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

Common Values (Plot)

2023-12-11T06:13:53.943237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종합감리업 52
52.5%
전문감리업 47
47.5%

소속국가명
Categorical

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
<NA>
87 
대한민국
12 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대한민국
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row대한민국

Common Values

ValueCountFrequency (%)
<NA> 87
87.9%
대한민국 12
 
12.1%

Length

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

Common Values (Plot)

2023-12-11T06:13:54.115747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 87
87.9%
대한민국 12
 
12.1%

실질자본금
Real number (ℝ)

ZEROS 

Distinct12
Distinct (%)12.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean58209403
Minimum0
Maximum1.22 × 109
Zeros74
Zeros (%)74.7%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-11T06:13:54.192501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q325000000
95-th percentile2.735 × 108
Maximum1.22 × 109
Range1.22 × 109
Interquartile range (IQR)25000000

Descriptive statistics

Standard deviation1.8462527 × 108
Coefficient of variation (CV)3.171743
Kurtosis24.313528
Mean58209403
Median Absolute Deviation (MAD)0
Skewness4.7409552
Sum5.7627309 × 109
Variance3.408649 × 1016
MonotonicityNot monotonic
2023-12-11T06:13:54.316759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
0 74
74.7%
100000000 8
 
8.1%
50000000 7
 
7.1%
440000000 2
 
2.0%
1220000000 1
 
1.0%
700000000 1
 
1.0%
210000000 1
 
1.0%
1031779200 1
 
1.0%
161097000 1
 
1.0%
53080000 1
 
1.0%
Other values (2) 2
 
2.0%
ValueCountFrequency (%)
0 74
74.7%
50000000 7
 
7.1%
53080000 1
 
1.0%
100000000 8
 
8.1%
101774734 1
 
1.0%
161097000 1
 
1.0%
210000000 1
 
1.0%
255000000 1
 
1.0%
440000000 2
 
2.0%
700000000 1
 
1.0%
ValueCountFrequency (%)
1220000000 1
 
1.0%
1031779200 1
 
1.0%
700000000 1
 
1.0%
440000000 2
 
2.0%
255000000 1
 
1.0%
210000000 1
 
1.0%
161097000 1
 
1.0%
101774734 1
 
1.0%
100000000 8
8.1%
53080000 1
 
1.0%

Sample

시군명사업장명인허가일자인허가취소일자영업상태구분코드영업상태명소재지시설전화번호소재지면적정보도로명우편번호소재지도로명주소소재지지번주소소재지우편번호WGS84위도WGS84경도업태구분명정보X좌표값Y좌표값업종구분명설계감리업종류명소속국가명실질자본금
0고양시(주)연합기술단20030819<NA>1인허가319700038<NA><NA>경기도 고양시 덕양구 용현로35번길 8-16 (행신동,301호)경기도 고양시덕양구 행신동 754번지 301호41222037.616551126.835511<NA>185411.958411457156.752016감리업종합감리업대한민국100000000
1고양시(주)뉴스타20070730<NA>1인허가319696114<NA><NA>경기도 고양시 덕양구 화정로 53-1 704호 (화정동,글로리아빌딩)경기도 고양시덕양구 화정동 967-3번지 글로리아프라자 704호41227037.635386126.832342<NA><NA><NA>감리업종합감리업<NA>0
2고양시(주)선진기술단20070515<NA>1인허가319250445<NA><NA>경기도 고양시 일산서구 중앙로 1568 (대화동,하성상가 705호)경기도 고양시일산서구 대화동 2203번지 하성상가 705호41180537.676291126.747879<NA>177693.645463804.75감리업종합감리업<NA>100000000
3고양시(주)서광안전컨설팅20070503<NA>1인허가319696114<NA><NA>경기도 고양시 덕양구 화정로 53-1 706호 (화정동,글로리아빌딩)경기도 고양시덕양구 화정동 967-3번지 글로리아프라자 706호41227037.635386126.832342<NA><NA><NA>감리업전문감리업<NA>50000000
4고양시(주)휴먼아키피아건축사사무소19990414<NA>1인허가319223500<NA><NA>경기도 고양시 일산서구 중앙로 1576 (대화동,태진빌딩 605)경기도 고양시일산서구 대화동 2205번지 태진빌딩 60541180537.676596126.747129<NA>177628.867467463840.388784감리업종합감리업대한민국1220000000
5고양시(주)세종전력기술단20061129<NA>1인허가319241252<NA><NA>경기도 고양시 일산동구 호수로 672 315호 (장항동,대우메종오피스텔)경기도 고양시일산구 장항동 750-1번지 대우메종리브로 315호41038037.66138126.7651<NA><NA><NA>감리업종합감리업대한민국0
6고양시(주)무림이엔씨20060921<NA>3폐업319057255<NA><NA>경기도 고양시 일산동구 장백로 56 (백석동,크리스탈빌딩 502호)경기도 고양시일산구 백석동 1331번지 1호 크리스탈빌딩 502호41036037.64288126.786766<NA>181115.903503460088.16993감리업종합감리업<NA>100000000
7광주시대한라이팅(주)20070615<NA>1인허가317635276<NA><NA>경기도 광주시 초월읍 산수로226번길 32경기도 광주시 초월읍 선동리 338번지46486437.383286127.319195<NA>228242.637494431303.988272감리업종합감리업<NA>0
8구리시(주)삼우공간건축사사무소19970526<NA>1인허가315556080<NA><NA>경기도 구리시 안골로 1 (교문동)경기도 구리시 교문동 730-7번지47102037.597256127.131177<NA><NA><NA>감리업종합감리업<NA>700000000
9구리시(주)고려이엔씨20050826<NA>1인허가315624215<NA><NA>경기도 구리시 장자대로 7 2층 (교문동,매산빌딩)경기도 구리시 교문동 807-9번지 매산빌딩 2층47102037.587787127.131127<NA><NA><NA>감리업전문감리업대한민국50000000
시군명사업장명인허가일자인허가취소일자영업상태구분코드영업상태명소재지시설전화번호소재지면적정보도로명우편번호소재지도로명주소소재지지번주소소재지우편번호WGS84위도WGS84경도업태구분명정보X좌표값Y좌표값업종구분명설계감리업종류명소속국가명실질자본금
89파주시(주)한국이에프티엔지니어링20021221<NA>1인허가220659384<NA><NA>경기도 파주시 중앙로 256 (금촌동,용수빌딩 301호)경기도 파주시 금촌동 769번지 14호 용수빌딩 301호41301037.759006126.778257<NA>180395.05607472978.932283감리업종합감리업<NA>100000000
90파주시대영일렉테크(주)19970729<NA>1인허가319494220<NA><NA>경기도 파주시 조리읍 등원로129번길 28 (뇌조리)경기도 파주시 조리읍 뇌조리 413-2번지41382137.763894126.811041<NA><NA><NA>감리업전문감리업대한민국255000000
91평택시(주)기남전기엔지니어링20061212<NA>1인허가316588600<NA><NA>경기도 평택시 비전1로 19 (비전동)경기도 평택시 비전1동 787번지 8호45080837.001435127.094118<NA>208310.223308388880.420075감리업전문감리업<NA>50000000
92평택시(주)백향엔지니어링20070328<NA>1인허가316588082<NA><NA>경기도 평택시 평택4로 67 (비전동)경기도 평택시 비전2동 751번지 9호45080636.993797127.101141<NA>208937.580791388032.212559감리업종합감리업<NA>0
93평택시(주)성우엔지니어링수건축사무소20070412<NA>1인허가316577184<NA><NA>경기도 평택시 중앙2로 149 (합정동)경기도 평택시 합정동 913번지 12호45002036.988777127.103111<NA>209114.252967387475.669486감리업종합감리업<NA>0
94평택시(주)백향엔지니어링20070330<NA>3폐업316588082<NA><NA>경기도 평택시 평택4로 67 (비전동)경기도 평택시 비전2동 751번지 9호45080636.993797127.101141<NA>208937.580791388032.212559감리업전문감리업<NA>0
95하남시(주)다우기술단20070416<NA>1인허가24612630<NA><NA>경기도 하남시 천현로39번길 53 (신장동)경기도 하남시 신장2동 532번지 4호46581237.536545127.214731<NA>218913.619993448285.378821감리업전문감리업<NA>0
96화성시지추이엔씨(주)20070716<NA>1인허가312326828<NA><NA>경기도 화성시 효행로 1056 (병점동,탑프라자606호)경기도 화성시 병점동 844번지 2호 탑프라자606호44536037.21413127.042809<NA>203734.759394412480.974351감리업전문감리업<NA>0
97<NA>(주)한국조형종합건축사사무소20070418<NA>1인허가222036323<NA><NA>서울특별시 송파구 석촌호수로 130 (삼전동)서울특별시 송파구 삼전동 1번지 1호13883737.507095127.091348<NA>208011.395671444998.464309감리업종합감리업<NA>0
98<NA>보람엔지니어링(주)20030731<NA>6합병말소425528010<NA><NA>충청남도 천안시 동남구 영성로 101 (문화동)충청남도 천안시 문화동 160-1번지33002036.807241127.149648<NA><NA><NA>감리업전문감리업대한민국50000000

Duplicate rows

Most frequently occurring

시군명사업장명인허가일자영업상태구분코드영업상태명소재지시설전화번호소재지도로명주소소재지지번주소소재지우편번호WGS84위도WGS84경도X좌표값Y좌표값업종구분명설계감리업종류명소속국가명실질자본금# duplicates
0안양시(주)동림컨설턴트200702011인허가313849600경기도 안양시 동안구 시민대로 187 (비산동)경기도 안양시동안구 비산동 1112번지 1호43105037.39169126.951648195651.67391432187.915104감리업전문감리업<NA>02