Overview

Dataset statistics

Number of variables7
Number of observations33
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory62.0 B

Variable types

Numeric2
Text3
Categorical1
DateTime1

Dataset

Description안전진단전문기관등록현황20153
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202463

Alerts

등록번호 is highly overall correlated with 등록분야High correlation
등록분야 is highly overall correlated with 등록번호High correlation
No has unique valuesUnique
등록번호 has unique valuesUnique
업체명(등록번호) has unique valuesUnique
대표자 has unique valuesUnique

Reproduction

Analysis started2024-03-14 01:23:05.672589
Analysis finished2024-03-14 01:23:06.459587
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

No
Real number (ℝ)

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17
Minimum1
Maximum33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2024-03-14T10:23:06.518027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.6
Q19
median17
Q325
95-th percentile31.4
Maximum33
Range32
Interquartile range (IQR)16

Descriptive statistics

Standard deviation9.6695398
Coefficient of variation (CV)0.56879646
Kurtosis-1.2
Mean17
Median Absolute Deviation (MAD)8
Skewness0
Sum561
Variance93.5
MonotonicityStrictly increasing
2024-03-14T10:23:06.619779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 1
 
3.0%
26 1
 
3.0%
20 1
 
3.0%
21 1
 
3.0%
22 1
 
3.0%
23 1
 
3.0%
24 1
 
3.0%
25 1
 
3.0%
27 1
 
3.0%
2 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
1 1
3.0%
2 1
3.0%
3 1
3.0%
4 1
3.0%
5 1
3.0%
6 1
3.0%
7 1
3.0%
8 1
3.0%
9 1
3.0%
10 1
3.0%
ValueCountFrequency (%)
33 1
3.0%
32 1
3.0%
31 1
3.0%
30 1
3.0%
29 1
3.0%
28 1
3.0%
27 1
3.0%
26 1
3.0%
25 1
3.0%
24 1
3.0%

등록번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.666667
Minimum1
Maximum242
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2024-03-14T10:23:06.721724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.2
Q113
median25
Q335
95-th percentile101
Maximum242
Range241
Interquartile range (IQR)22

Descriptive statistics

Standard deviation48.782468
Coefficient of variation (CV)1.4071866
Kurtosis13.013815
Mean34.666667
Median Absolute Deviation (MAD)11
Skewness3.5871681
Sum1144
Variance2379.7292
MonotonicityNot monotonic
2024-03-14T10:23:06.821145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
39 1
 
3.0%
29 1
 
3.0%
31 1
 
3.0%
24 1
 
3.0%
36 1
 
3.0%
8 1
 
3.0%
25 1
 
3.0%
242 1
 
3.0%
15 1
 
3.0%
21 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
1 1
3.0%
4 1
3.0%
6 1
3.0%
7 1
3.0%
8 1
3.0%
9 1
3.0%
11 1
3.0%
12 1
3.0%
13 1
3.0%
14 1
3.0%
ValueCountFrequency (%)
242 1
3.0%
191 1
3.0%
41 1
3.0%
40 1
3.0%
39 1
3.0%
38 1
3.0%
37 1
3.0%
36 1
3.0%
35 1
3.0%
34 1
3.0%

업체명(등록번호)
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2024-03-14T10:23:07.010522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length13
Mean length10.272727
Min length5

Characters and Unicode

Total characters339
Distinct characters92
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

Unique33 ?
Unique (%)100.0%

Sample

1st row(유)가온이앤씨
2nd row(유)대승엔지니어링
3rd row(유)세종건설기술
4th row(유)센이엔지건축사사무소
5th row(유)승명종합건설
ValueCountFrequency (%)
유)가온이앤씨 1
 
2.8%
유)대승엔지니어링 1
 
2.8%
주)우향이앤씨 1
 
2.8%
주)조화엔지니어링 1
 
2.8%
주)한국건설기술공사 1
 
2.8%
건축법인 1
 
2.8%
녹엔지니어링 1
 
2.8%
건축사사무소(주 1
 
2.8%
기술사건축사사무소 1
 
2.8%
미문건설기술연구원(주 1
 
2.8%
Other values (26) 26
72.2%
2024-03-14T10:23:07.304643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 34
 
10.0%
) 34
 
10.0%
주 21
 
6.2%
건 15
 
4.4%
엔 13
 
3.8%
사 10
 
2.9%
유 10
 
2.9%
설 10
 
2.9%
지 10
 
2.9%
술 9
 
2.7%
Other values (82) 173
51.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 260
76.7%
Open Punctuation 34
 
10.0%
Close Punctuation 34
 
10.0%
Decimal Number 6
 
1.8%
Space Separator 3
 
0.9%
Other Symbol 2
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 21
 
8.1%
건 15
 
5.8%
엔 13
 
5.0%
사 10
 
3.8%
유 10
 
3.8%
설 10
 
3.8%
지 10
 
3.8%
술 9
 
3.5%
기 9
 
3.5%
링 8
 
3.1%
Other values (73) 145
55.8%
Decimal Number
ValueCountFrequency (%)
4 2
33.3%
3 1
16.7%
8 1
16.7%
0 1
16.7%
1 1
16.7%
Open Punctuation
ValueCountFrequency (%)
( 34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 34
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 262
77.3%
Common 77
 
22.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 21
 
8.0%
건 15
 
5.7%
엔 13
 
5.0%
사 10
 
3.8%
유 10
 
3.8%
설 10
 
3.8%
지 10
 
3.8%
술 9
 
3.4%
기 9
 
3.4%
링 8
 
3.1%
Other values (74) 147
56.1%
Common
ValueCountFrequency (%)
( 34
44.2%
) 34
44.2%
3
 
3.9%
4 2
 
2.6%
3 1
 
1.3%
8 1
 
1.3%
0 1
 
1.3%
1 1
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 260
76.7%
ASCII 77
 
22.7%
None 2
 
0.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 34
44.2%
) 34
44.2%
3
 
3.9%
4 2
 
2.6%
3 1
 
1.3%
8 1
 
1.3%
0 1
 
1.3%
1 1
 
1.3%
Hangul
ValueCountFrequency (%)
주 21
 
8.1%
건 15
 
5.8%
엔 13
 
5.0%
사 10
 
3.8%
유 10
 
3.8%
설 10
 
3.8%
지 10
 
3.8%
술 9
 
3.5%
기 9
 
3.5%
링 8
 
3.1%
Other values (73) 145
55.8%
None
ValueCountFrequency (%)
㈜ 2
100.0%

등록분야
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)21.2%
Missing0
Missing (%)0.0%
Memory size396.0 B
교량/터널
14 
교량/터널,수리
9 
건축
4 
교량/터널,건축
3 
교량/터널,건축,수리
 
1
Other values (2)
2 

Length

Max length11
Median length8
Mean length5.969697
Min length2

Unique

Unique3 ?
Unique (%)9.1%

Sample

1st row교량/터널
2nd row교량/터널,건축
3rd row교량/터널
4th row건축
5th row교량/터널

Common Values

ValueCountFrequency (%)
교량/터널 14
42.4%
교량/터널,수리 9
27.3%
건축 4
 
12.1%
교량/터널,건축 3
 
9.1%
교량/터널,건축,수리 1
 
3.0%
수리시설 1
 
3.0%
교량/너널,항만 1
 
3.0%

Length

2024-03-14T10:23:07.408968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T10:23:07.498331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교량/터널 14
42.4%
교량/터널,수리 9
27.3%
건축 4
 
12.1%
교량/터널,건축 3
 
9.1%
교량/터널,건축,수리 1
 
3.0%
수리시설 1
 
3.0%
교량/너널,항만 1
 
3.0%

대표자
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2024-03-14T10:23:07.655665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length3
Mean length3.1212121
Min length2

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st row백영희
2nd row채윤석
3rd row조천목
4th row김광서, 유영일
5th row김승수
ValueCountFrequency (%)
유영일 2
 
5.9%
백영희 1
 
2.9%
김보현 1
 
2.9%
박석순 1
 
2.9%
김효녀 1
 
2.9%
채희정 1
 
2.9%
장승환 1
 
2.9%
빙인섭 1
 
2.9%
전옥영 1
 
2.9%
온형수 1
 
2.9%
Other values (23) 23
67.6%
2024-03-14T10:23:08.019019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 8
 
7.8%
영 5
 
4.9%
박 3
 
2.9%
형 3
 
2.9%
이 3
 
2.9%
수 3
 
2.9%
승 3
 
2.9%
백 2
 
1.9%
일 2
 
1.9%
옥 2
 
1.9%
Other values (59) 69
67.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 101
98.1%
Other Punctuation 1
 
1.0%
Space Separator 1
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 8
 
7.9%
영 5
 
5.0%
박 3
 
3.0%
형 3
 
3.0%
이 3
 
3.0%
수 3
 
3.0%
승 3
 
3.0%
백 2
 
2.0%
일 2
 
2.0%
옥 2
 
2.0%
Other values (57) 67
66.3%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 101
98.1%
Common 2
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 8
 
7.9%
영 5
 
5.0%
박 3
 
3.0%
형 3
 
3.0%
이 3
 
3.0%
수 3
 
3.0%
승 3
 
3.0%
백 2
 
2.0%
일 2
 
2.0%
옥 2
 
2.0%
Other values (57) 67
66.3%
Common
ValueCountFrequency (%)
, 1
50.0%
1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 101
98.1%
ASCII 2
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 8
 
7.9%
영 5
 
5.0%
박 3
 
3.0%
형 3
 
3.0%
이 3
 
3.0%
수 3
 
3.0%
승 3
 
3.0%
백 2
 
2.0%
일 2
 
2.0%
옥 2
 
2.0%
Other values (57) 67
66.3%
ASCII
ValueCountFrequency (%)
, 1
50.0%
1
50.0%

소재지
Text

Distinct32
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2024-03-14T10:23:08.268116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length24
Mean length19.393939
Min length12

Characters and Unicode

Total characters640
Distinct characters106
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

Unique31 ?
Unique (%)93.9%

Sample

1st row완주군 용진면 상운길 88
2nd row전주시 완산구 평화로 69
3rd row군산시 번영로 121(경장동)
4th row전주시 완산구 화산천변3길 12 (중화산동2가)
5th row군산시 번영로 121(경장동)
ValueCountFrequency (%)
전주시 14
 
10.1%
완산구 9
 
6.5%
덕진구 5
 
3.6%
익산시 4
 
2.9%
김제시 3
 
2.2%
2층 3
 
2.2%
중화산동2가 3
 
2.2%
군산시 3
 
2.2%
봉황로 2
 
1.4%
완주군 2
 
1.4%
Other values (86) 90
65.2%
2024-03-14T10:23:08.636690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
105
 
16.4%
1 28
 
4.4%
2 28
 
4.4%
시 27
 
4.2%
동 24
 
3.8%
산 22
 
3.4%
주 18
 
2.8%
로 16
 
2.5%
구 15
 
2.3%
3 15
 
2.3%
Other values (96) 342
53.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 349
54.5%
Decimal Number 138
 
21.6%
Space Separator 105
 
16.4%
Open Punctuation 14
 
2.2%
Close Punctuation 14
 
2.2%
Dash Punctuation 12
 
1.9%
Other Punctuation 8
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 27
 
7.7%
동 24
 
6.9%
산 22
 
6.3%
주 18
 
5.2%
로 16
 
4.6%
구 15
 
4.3%
전 14
 
4.0%
진 11
 
3.2%
완 11
 
3.2%
군 10
 
2.9%
Other values (81) 181
51.9%
Decimal Number
ValueCountFrequency (%)
1 28
20.3%
2 28
20.3%
3 15
10.9%
5 11
 
8.0%
6 11
 
8.0%
0 11
 
8.0%
4 10
 
7.2%
9 9
 
6.5%
7 8
 
5.8%
8 7
 
5.1%
Space Separator
ValueCountFrequency (%)
105
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Other Punctuation
ValueCountFrequency (%)
, 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 349
54.5%
Common 291
45.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 27
 
7.7%
동 24
 
6.9%
산 22
 
6.3%
주 18
 
5.2%
로 16
 
4.6%
구 15
 
4.3%
전 14
 
4.0%
진 11
 
3.2%
완 11
 
3.2%
군 10
 
2.9%
Other values (81) 181
51.9%
Common
ValueCountFrequency (%)
105
36.1%
1 28
 
9.6%
2 28
 
9.6%
3 15
 
5.2%
( 14
 
4.8%
) 14
 
4.8%
- 12
 
4.1%
5 11
 
3.8%
6 11
 
3.8%
0 11
 
3.8%
Other values (5) 42
 
14.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 349
54.5%
ASCII 291
45.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
105
36.1%
1 28
 
9.6%
2 28
 
9.6%
3 15
 
5.2%
( 14
 
4.8%
) 14
 
4.8%
- 12
 
4.1%
5 11
 
3.8%
6 11
 
3.8%
0 11
 
3.8%
Other values (5) 42
 
14.4%
Hangul
ValueCountFrequency (%)
시 27
 
7.7%
동 24
 
6.9%
산 22
 
6.3%
주 18
 
5.2%
로 16
 
4.6%
구 15
 
4.3%
전 14
 
4.0%
진 11
 
3.2%
완 11
 
3.2%
군 10
 
2.9%
Other values (81) 181
51.9%

등록일자
Date

Distinct32
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
Minimum1998-11-19 00:00:00
Maximum2015-03-23 00:00:00
2024-03-14T10:23:08.762073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T10:23:08.871070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)

Interactions

2024-03-14T10:23:06.131743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T10:23:05.992829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T10:23:06.198221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T10:23:06.065578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T10:23:08.939346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
No등록번호업체명(등록번호)등록분야대표자소재지등록일자
No1.0000.4151.0000.2221.0000.9320.949
등록번호0.4151.0001.0000.7301.0000.9681.000
업체명(등록번호)1.0001.0001.0001.0001.0001.0001.000
등록분야0.2220.7301.0001.0001.0001.0001.000
대표자1.0001.0001.0001.0001.0001.0001.000
소재지0.9320.9681.0001.0001.0001.0000.992
등록일자0.9491.0001.0001.0001.0000.9921.000
2024-03-14T10:23:09.036831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
No등록번호등록분야
No1.0000.3240.082
등록번호0.3241.0000.568
등록분야0.0820.5681.000

Missing values

2024-03-14T10:23:06.324256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T10:23:06.421575image/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

No등록번호업체명(등록번호)등록분야대표자소재지등록일자
0139(유)가온이앤씨교량/터널백영희완주군 용진면 상운길 882014-12-29
1221(유)대승엔지니어링교량/터널,건축채윤석전주시 완산구 평화로 692012-10-30
2332(유)세종건설기술교량/터널조천목군산시 번영로 121(경장동)2014-05-09
344(유)센이엔지건축사사무소건축김광서, 유영일전주시 완산구 화산천변3길 12 (중화산동2가)2005-02-23
459(유)승명종합건설교량/터널김승수군산시 번영로 121(경장동)2009-02-20
5612(유)쎈구조엔지니어링건축김용진전주시 완산구 용머리로 127, 2층 (효자동1가)2009-05-28
6713(유)용성엔지니어링교량/터널원복주정읍시 시기동 165-4 2층2010-04-12
7816(유)케이티엔지니어링교량/터널이철상부안군 부안읍 학동길 152011-10-26
8923(유)한강건설교량/터널이제형임실군 임실읍 이도리 2722013-02-05
910191(주)건설방재기술연구원교량/터널,건축,수리백승복전주시 완산구 중산중앙로 32 (중화산동2가)1998-11-19
No등록번호업체명(등록번호)등록분야대표자소재지등록일자
232425건축법인 녹엔지니어링 건축사사무소(주)건축빙인섭익산시 남중동 1-150 60-702013-07-22
2425242기술사건축사사무소 미문건설기술연구원(주)건축전옥영전주시 덕진구 진북동 294-102000-04-08
252629미래건설산업(주)교량/터널,수리김보현전주시 완산구 서곡5길 13-5(효자동3가,2층)2000-12-06
262715성원기술개발㈜교량/터널온형수김제시 중앙로 26,3층(서암동)2011-08-10
272814제이씨엔(주)교량/터널강종찬전주시 덕진구 호성동2가 468-20번지2010-11-11
282935(주)고산교량/터널,수리박성수김제시 봉황로 11482014-07-14
293027(주)동서기술교량/터널,수리전벼리전주시 완산구 중화산동2가 18-9,3012014-03-10
303134(주)한가람수리시설류양규진안군 진안읍 진무로 11442014-07-04
313238(유)대성이엔씨(38)교량/터널강대후무주군 무주읍 단천로 99(읍내리 299)2014-12-29
323341㈜항도엔지니어링(41)교량/너널,항만안익성군산시 대학로 10, 3층(영화동)2015-02-16