Overview

Dataset statistics

Number of variables7
Number of observations35
Missing cells6
Missing cells (%)2.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory59.8 B

Variable types

Unsupported3
Text3
Categorical1

Dataset

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

Alerts

안전진단전문기관 현황 has 1 (2.9%) missing valuesMissing
Unnamed: 1 has 1 (2.9%) missing valuesMissing
Unnamed: 2 has 1 (2.9%) missing valuesMissing
Unnamed: 4 has 1 (2.9%) missing valuesMissing
Unnamed: 5 has 1 (2.9%) missing valuesMissing
Unnamed: 6 has 1 (2.9%) missing valuesMissing
안전진단전문기관 현황 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 01:23:09.716454
Analysis finished2024-03-14 01:23:10.481387
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

안전진단전문기관 현황
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Unnamed: 2
Text

MISSING 

Distinct34
Distinct (%)100.0%
Missing1
Missing (%)2.9%
Memory size412.0 B
2024-03-14T10:23:10.626151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length13
Mean length10.235294
Min length5

Characters and Unicode

Total characters348
Distinct characters97
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

Unique34 ?
Unique (%)100.0%

Sample

1st row업체명(등록번호)
2nd row(유)가온이앤씨
3rd row(유)대승엔지니어링
4th row(유)세종건설기술
5th row(유)센이엔지건축사사무소
ValueCountFrequency (%)
유)케이티엔지니어링 1
 
2.7%
미래건설산업(주 1
 
2.7%
주)세화엔지니어링 1
 
2.7%
주)우향이앤씨 1
 
2.7%
주)조화엔지니어링 1
 
2.7%
주)한국건설기술공사 1
 
2.7%
건축법인 1
 
2.7%
녹엔지니어링 1
 
2.7%
건축사사무소(주 1
 
2.7%
주)새롬이엔지 1
 
2.7%
Other values (27) 27
73.0%
2024-03-14T10:23:10.966817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 35
 
10.1%
) 35
 
10.1%
주 21
 
6.0%
건 15
 
4.3%
엔 13
 
3.7%
유 10
 
2.9%
사 10
 
2.9%
설 10
 
2.9%
지 10
 
2.9%
기 9
 
2.6%
Other values (87) 180
51.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 267
76.7%
Open Punctuation 35
 
10.1%
Close Punctuation 35
 
10.1%
Decimal Number 6
 
1.7%
Space Separator 3
 
0.9%
Other Symbol 2
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 21
 
7.9%
건 15
 
5.6%
엔 13
 
4.9%
유 10
 
3.7%
사 10
 
3.7%
설 10
 
3.7%
지 10
 
3.7%
기 9
 
3.4%
술 9
 
3.4%
니 8
 
3.0%
Other values (78) 152
56.9%
Decimal Number
ValueCountFrequency (%)
4 2
33.3%
8 1
16.7%
3 1
16.7%
0 1
16.7%
1 1
16.7%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 269
77.3%
Common 79
 
22.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 21
 
7.8%
건 15
 
5.6%
엔 13
 
4.8%
유 10
 
3.7%
사 10
 
3.7%
설 10
 
3.7%
지 10
 
3.7%
기 9
 
3.3%
술 9
 
3.3%
니 8
 
3.0%
Other values (79) 154
57.2%
Common
ValueCountFrequency (%)
( 35
44.3%
) 35
44.3%
3
 
3.8%
4 2
 
2.5%
8 1
 
1.3%
3 1
 
1.3%
0 1
 
1.3%
1 1
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 267
76.7%
ASCII 79
 
22.7%
None 2
 
0.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 35
44.3%
) 35
44.3%
3
 
3.8%
4 2
 
2.5%
8 1
 
1.3%
3 1
 
1.3%
0 1
 
1.3%
1 1
 
1.3%
Hangul
ValueCountFrequency (%)
주 21
 
7.9%
건 15
 
5.6%
엔 13
 
4.9%
유 10
 
3.7%
사 10
 
3.7%
설 10
 
3.7%
지 10
 
3.7%
기 9
 
3.4%
술 9
 
3.4%
니 8
 
3.0%
Other values (78) 152
56.9%
None
ValueCountFrequency (%)
㈜ 2
100.0%

Unnamed: 3
Categorical

Distinct9
Distinct (%)25.7%
Missing0
Missing (%)0.0%
Memory size412.0 B
교량/터널
14 
교량/터널,수리
9 
건축
4 
교량/터널,건축
3 
<NA>
 
1
Other values (4)
4 

Length

Max length11
Median length8
Mean length5.8571429
Min length2

Unique

Unique5 ?
Unique (%)14.3%

Sample

1st row<NA>
2nd row등록분야
3rd row교량/터널
4th row교량/터널,건축
5th row교량/터널

Common Values

ValueCountFrequency (%)
교량/터널 14
40.0%
교량/터널,수리 9
25.7%
건축 4
 
11.4%
교량/터널,건축 3
 
8.6%
<NA> 1
 
2.9%
등록분야 1
 
2.9%
교량/터널,건축,수리 1
 
2.9%
수리시설 1
 
2.9%
교량/너널,항만 1
 
2.9%

Length

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

Common Values (Plot)

2024-03-14T10:23:11.169128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교량/터널 14
40.0%
교량/터널,수리 9
25.7%
건축 4
 
11.4%
교량/터널,건축 3
 
8.6%
na 1
 
2.9%
등록분야 1
 
2.9%
교량/터널,건축,수리 1
 
2.9%
수리시설 1
 
2.9%
교량/너널,항만 1
 
2.9%

Unnamed: 4
Text

MISSING 

Distinct34
Distinct (%)100.0%
Missing1
Missing (%)2.9%
Memory size412.0 B
2024-03-14T10:23:11.335024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length3
Mean length3.1176471
Min length2

Characters and Unicode

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

Unique34 ?
Unique (%)100.0%

Sample

1st row대표자
2nd row백영희
3rd row채윤석
4th row조천목
5th row김광서, 유영일
ValueCountFrequency (%)
유영일 2
 
5.7%
이철상 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 (24) 24
68.6%
2024-03-14T10:23:11.597659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 8
 
7.5%
영 5
 
4.7%
이 3
 
2.8%
형 3
 
2.8%
수 3
 
2.8%
승 3
 
2.8%
박 3
 
2.8%
강 2
 
1.9%
유 2
 
1.9%
환 2
 
1.9%
Other values (61) 72
67.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 104
98.1%
Other Punctuation 1
 
0.9%
Space Separator 1
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 8
 
7.7%
영 5
 
4.8%
이 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) 70
67.3%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

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

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 8
 
7.7%
영 5
 
4.8%
이 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) 70
67.3%
Common
ValueCountFrequency (%)
, 1
50.0%
1
50.0%

Most occurring blocks

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

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 8
 
7.7%
영 5
 
4.8%
이 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) 70
67.3%
ASCII
ValueCountFrequency (%)
, 1
50.0%
1
50.0%

Unnamed: 5
Text

MISSING 

Distinct33
Distinct (%)97.1%
Missing1
Missing (%)2.9%
Memory size412.0 B
2024-03-14T10:23:11.819408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length24
Mean length18.911765
Min length3

Characters and Unicode

Total characters643
Distinct characters108
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

Unique32 ?
Unique (%)94.1%

Sample

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

Most occurring characters

ValueCountFrequency (%)
105
 
16.3%
1 28
 
4.4%
2 28
 
4.4%
시 27
 
4.2%
동 24
 
3.7%
산 22
 
3.4%
주 18
 
2.8%
로 16
 
2.5%
구 15
 
2.3%
3 15
 
2.3%
Other values (98) 345
53.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 352
54.7%
Decimal Number 138
 
21.5%
Space Separator 105
 
16.3%
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.8%
산 22
 
6.2%
주 18
 
5.1%
로 16
 
4.5%
구 15
 
4.3%
전 14
 
4.0%
진 11
 
3.1%
완 11
 
3.1%
군 10
 
2.8%
Other values (83) 184
52.3%
Decimal Number
ValueCountFrequency (%)
1 28
20.3%
2 28
20.3%
3 15
10.9%
0 11
 
8.0%
6 11
 
8.0%
5 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 352
54.7%
Common 291
45.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 27
 
7.7%
동 24
 
6.8%
산 22
 
6.2%
주 18
 
5.1%
로 16
 
4.5%
구 15
 
4.3%
전 14
 
4.0%
진 11
 
3.1%
완 11
 
3.1%
군 10
 
2.8%
Other values (83) 184
52.3%
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%
0 11
 
3.8%
6 11
 
3.8%
5 11
 
3.8%
Other values (5) 42
 
14.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 352
54.7%
ASCII 291
45.3%

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%
0 11
 
3.8%
6 11
 
3.8%
5 11
 
3.8%
Other values (5) 42
 
14.4%
Hangul
ValueCountFrequency (%)
시 27
 
7.7%
동 24
 
6.8%
산 22
 
6.2%
주 18
 
5.1%
로 16
 
4.5%
구 15
 
4.3%
전 14
 
4.0%
진 11
 
3.1%
완 11
 
3.1%
군 10
 
2.8%
Other values (83) 184
52.3%

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Correlations

2024-03-14T10:23:12.339766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5
Unnamed: 21.0001.0001.0001.000
Unnamed: 31.0001.0001.0001.000
Unnamed: 41.0001.0001.0001.000
Unnamed: 51.0001.0001.0001.000

Missing values

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

안전진단전문기관 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
0NaNNaN<NA><NA><NA><NA>NaN
1No등록번호업체명(등록번호)등록분야대표자소재지등록일자
2139(유)가온이앤씨교량/터널백영희완주군 용진면 상운길 882014-12-29 00:00:00
3221(유)대승엔지니어링교량/터널,건축채윤석전주시 완산구 평화로 692012-10-30 00:00:00
4332(유)세종건설기술교량/터널조천목군산시 번영로 121(경장동)2014-05-09 00:00:00
544(유)센이엔지건축사사무소건축김광서, 유영일전주시 완산구 화산천변3길 12 (중화산동2가)2005-02-23 00:00:00
659(유)승명종합건설교량/터널김승수군산시 번영로 121(경장동)2009-02-20 00:00:00
7612(유)쎈구조엔지니어링건축김용진전주시 완산구 용머리로 127, 2층 (효자동1가)2009-05-28 00:00:00
8713(유)용성엔지니어링교량/터널원복주정읍시 시기동 165-4 2층2010-04-12 00:00:00
9816(유)케이티엔지니어링교량/터널이철상부안군 부안읍 학동길 152011-10-26 00:00:00
안전진단전문기관 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
252425건축법인 녹엔지니어링 건축사사무소(주)건축빙인섭익산시 남중동 1-150 60-702013-07-22 00:00:00
2625242기술사건축사사무소 미문건설기술연구원(주)건축전옥영전주시 덕진구 진북동 294-102000-04-08 00:00:00
272629미래건설산업(주)교량/터널,수리김보현전주시 완산구 서곡5길 13-5(효자동3가,2층)2000-12-06 00:00:00
282715성원기술개발㈜교량/터널온형수김제시 중앙로 26,3층(서암동)2011-08-10 00:00:00
292814제이씨엔(주)교량/터널강종찬전주시 덕진구 호성동2가 468-20번지2010-11-11 00:00:00
302935(주)고산교량/터널,수리박성수김제시 봉황로 11482014-07-14 00:00:00
313027(주)동서기술교량/터널,수리전벼리전주시 완산구 중화산동2가 18-9,3012014-03-10 00:00:00
323134(주)한가람수리시설류양규진안군 진안읍 진무로 11442014-07-04 00:00:00
333238(유)대성이엔씨(38)교량/터널강대후무주군 무주읍 단천로 99(읍내리 299)2014-12-29 00:00:00
343341㈜항도엔지니어링(41)교량/너널,항만안익성군산시 대학로 10, 3층(영화동)2015-02-16 00:00:00