Overview

Dataset statistics

Number of variables7
Number of observations73
Missing cells78
Missing cells (%)15.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory58.8 B

Variable types

Unsupported4
Text2
Categorical1

Dataset

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

Alerts

Unnamed: 0 has 73 (100.0%) missing valuesMissing
안전진단 전문기관 등록현황 has 1 (1.4%) missing valuesMissing
Unnamed: 2 has 1 (1.4%) missing valuesMissing
Unnamed: 3 has 1 (1.4%) missing valuesMissing
Unnamed: 5 has 1 (1.4%) missing valuesMissing
Unnamed: 6 has 1 (1.4%) missing valuesMissing
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
안전진단 전문기관 등록현황 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 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 00:22:05.793074
Analysis finished2024-03-14 00:22:06.255064
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing73
Missing (%)100.0%
Memory size789.0 B

안전진단 전문기관 등록현황
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)1.4%
Memory size716.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)1.4%
Memory size716.0 B

Unnamed: 3
Text

MISSING 

Distinct72
Distinct (%)100.0%
Missing1
Missing (%)1.4%
Memory size716.0 B
2024-03-14T09:22:06.350736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length21
Mean length10.027778
Min length3

Characters and Unicode

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

Unique

Unique72 ?
Unique (%)100.0%

Sample

1st row업 체 명
2nd row㈜건설방재기술연구원
3rd row기술사건축사사무소 미문건설기술연구원㈜
4th row㈜건설품질시험원
5th row(유)센이엔지건축안전진단[구: (유)센이엔지건축사사무소]
ValueCountFrequency (%)
주식회사 13
 
13.4%
유한회사 3
 
3.1%
㈜한아 2
 
2.1%
누리종합건축사사무소 1
 
1.0%
서현이앤씨 1
 
1.0%
㈜영광이엔씨 1
 
1.0%
㈜에스이 1
 
1.0%
㈜혜원이엔지 1
 
1.0%
㈜대승엔지니어링(구:(유)대승엔지니어링 1
 
1.0%
창운 1
 
1.0%
Other values (72) 72
74.2%
2024-03-14T09:22:06.656441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 39
 
5.4%
㈜ 39
 
5.4%
건 32
 
4.4%
25
 
3.5%
유 24
 
3.3%
) 23
 
3.2%
( 23
 
3.2%
기 22
 
3.0%
술 22
 
3.0%
이 22
 
3.0%
Other values (112) 451
62.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 588
81.4%
Other Symbol 39
 
5.4%
Close Punctuation 29
 
4.0%
Open Punctuation 29
 
4.0%
Space Separator 25
 
3.5%
Other Punctuation 8
 
1.1%
Decimal Number 4
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 39
 
6.6%
건 32
 
5.4%
유 24
 
4.1%
기 22
 
3.7%
술 22
 
3.7%
이 22
 
3.7%
설 22
 
3.7%
엔 21
 
3.6%
구 18
 
3.1%
지 18
 
3.1%
Other values (103) 348
59.2%
Close Punctuation
ValueCountFrequency (%)
) 23
79.3%
] 6
 
20.7%
Open Punctuation
ValueCountFrequency (%)
( 23
79.3%
[ 6
 
20.7%
Decimal Number
ValueCountFrequency (%)
1 2
50.0%
0 2
50.0%
Other Symbol
ValueCountFrequency (%)
㈜ 39
100.0%
Space Separator
ValueCountFrequency (%)
25
100.0%
Other Punctuation
ValueCountFrequency (%)
: 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 627
86.8%
Common 95
 
13.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 39
 
6.2%
㈜ 39
 
6.2%
건 32
 
5.1%
유 24
 
3.8%
기 22
 
3.5%
술 22
 
3.5%
이 22
 
3.5%
설 22
 
3.5%
엔 21
 
3.3%
구 18
 
2.9%
Other values (104) 366
58.4%
Common
ValueCountFrequency (%)
25
26.3%
) 23
24.2%
( 23
24.2%
: 8
 
8.4%
] 6
 
6.3%
[ 6
 
6.3%
1 2
 
2.1%
0 2
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 588
81.4%
ASCII 95
 
13.2%
None 39
 
5.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 39
 
6.6%
건 32
 
5.4%
유 24
 
4.1%
기 22
 
3.7%
술 22
 
3.7%
이 22
 
3.7%
설 22
 
3.7%
엔 21
 
3.6%
구 18
 
3.1%
지 18
 
3.1%
Other values (103) 348
59.2%
None
ValueCountFrequency (%)
㈜ 39
100.0%
ASCII
ValueCountFrequency (%)
25
26.3%
) 23
24.2%
( 23
24.2%
: 8
 
8.4%
] 6
 
6.3%
[ 6
 
6.3%
1 2
 
2.1%
0 2
 
2.1%

Unnamed: 4
Categorical

Distinct11
Distinct (%)15.1%
Missing0
Missing (%)0.0%
Memory size716.0 B
교량/터널,수리
21 
교량/터널
20 
건축
17 
교량/터널,수리,건축
4 
교량/터널,건축
4 
Other values (6)
7 

Length

Max length12
Median length11
Mean length5.9589041
Min length2

Unique

Unique5 ?
Unique (%)6.8%

Sample

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

Common Values

ValueCountFrequency (%)
교량/터널,수리 21
28.8%
교량/터널 20
27.4%
건축 17
23.3%
교량/터널,수리,건축 4
 
5.5%
교량/터널,건축 4
 
5.5%
교량/터널, 수리 2
 
2.7%
<NA> 1
 
1.4%
등록분야 1
 
1.4%
교량/터널,항만 1
 
1.4%
교량/터널,수리,항만 1
 
1.4%

Length

2024-03-14T09:22:06.779171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
교량/터널 22
29.3%
교량/터널,수리 21
28.0%
건축 17
22.7%
교량/터널,수리,건축 5
 
6.7%
교량/터널,건축 4
 
5.3%
수리 2
 
2.7%
na 1
 
1.3%
등록분야 1
 
1.3%
교량/터널,항만 1
 
1.3%
교량/터널,수리,항만 1
 
1.3%

Unnamed: 5
Text

MISSING 

Distinct72
Distinct (%)100.0%
Missing1
Missing (%)1.4%
Memory size716.0 B
2024-03-14T09:22:06.983473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length3
Mean length3.1388889
Min length2

Characters and Unicode

Total characters226
Distinct characters98
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

Unique72 ?
Unique (%)100.0%

Sample

1st row대표자
2nd row백승복
3rd row전옥영
4th row이재열
5th row박은심
ValueCountFrequency (%)
대표자 1
 
1.3%
장병길 1
 
1.3%
최도성 1
 
1.3%
김성모 1
 
1.3%
진 1
 
1.3%
허 1
 
1.3%
김성귀 1
 
1.3%
박흥재 1
 
1.3%
이혜림 1
 
1.3%
채윤석 1
 
1.3%
Other values (65) 65
86.7%
2024-03-14T09:22:07.327099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 18
 
8.0%
김 15
 
6.6%
영 9
 
4.0%
박 7
 
3.1%
진 6
 
2.7%
성 6
 
2.7%
정 6
 
2.7%
형 5
 
2.2%
최 5
 
2.2%
호 5
 
2.2%
Other values (88) 144
63.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 220
97.3%
Space Separator 4
 
1.8%
Other Punctuation 2
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 18
 
8.2%
김 15
 
6.8%
영 9
 
4.1%
박 7
 
3.2%
진 6
 
2.7%
성 6
 
2.7%
정 6
 
2.7%
형 5
 
2.3%
최 5
 
2.3%
호 5
 
2.3%
Other values (86) 138
62.7%
Space Separator
ValueCountFrequency (%)
4
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 220
97.3%
Common 6
 
2.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 18
 
8.2%
김 15
 
6.8%
영 9
 
4.1%
박 7
 
3.2%
진 6
 
2.7%
성 6
 
2.7%
정 6
 
2.7%
형 5
 
2.3%
최 5
 
2.3%
호 5
 
2.3%
Other values (86) 138
62.7%
Common
ValueCountFrequency (%)
4
66.7%
, 2
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 220
97.3%
ASCII 6
 
2.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 18
 
8.2%
김 15
 
6.8%
영 9
 
4.1%
박 7
 
3.2%
진 6
 
2.7%
성 6
 
2.7%
정 6
 
2.7%
형 5
 
2.3%
최 5
 
2.3%
호 5
 
2.3%
Other values (86) 138
62.7%
ASCII
ValueCountFrequency (%)
4
66.7%
, 2
33.3%

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)1.4%
Memory size716.0 B

Correlations

2024-03-14T09:22:07.429001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 3Unnamed: 4Unnamed: 5
Unnamed: 31.0001.0001.000
Unnamed: 41.0001.0001.000
Unnamed: 51.0001.0001.000

Missing values

2024-03-14T09:22:06.012953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:22:06.096365image/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-14T09:22:06.183076image/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: 0안전진단 전문기관 등록현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
0<NA>NaNNaN<NA><NA><NA>NaN
1<NA>연번등록번호업 체 명등록분야대표자등록일자
2<NA>1191㈜건설방재기술연구원교량/터널,수리,건축백승복1998-11-09 00:00:00
3<NA>2242기술사건축사사무소 미문건설기술연구원㈜건축전옥영2000-04-08 00:00:00
4<NA>31, 2㈜건설품질시험원교량/터널,수리이재열2003-04-03 00:00:00
5<NA>44(유)센이엔지건축안전진단[구: (유)센이엔지건축사사무소]건축박은심2005-02-23 00:00:00
6<NA>56㈜대한건설연구원교량/터널,수리조은아2005-06-22 00:00:00
7<NA>67㈜대들보구조안전기술단교량/터널,건축박형권2006-08-09 00:00:00
8<NA>78㈜한국건설기술공사교량/터널,수리장승환2007-03-09 00:00:00
9<NA>811㈜세종건설기술교량/터널,수리이제형2009-05-11 00:00:00
Unnamed: 0안전진단 전문기관 등록현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
63<NA>62851010건축사사무소건축최형규2019-03-11 00:00:00
64<NA>6386(유)영화이엔지교량/터널윤인영2019-05-07 00:00:00
65<NA>6487주식회사 신화기술건축김정수2019-06-10 00:00:00
66<NA>6588유한회사 금강기술건축김영득2019-06-17 00:00:00
67<NA>6689유한회사 라온건설기술사사무소건축이한진2019-07-18 00:00:00
68<NA>6790주식회사 온길교량/터널이현정2019-07-29 00:00:00
69<NA>6891선인건축사사무소건축서남근2019-08-26 00:00:00
70<NA>6992태안특수건설㈜교량/터널이호준2019-11-28 00:00:00
71<NA>7093(유)장원종합건축사사무소건축박진만2019-12-03 00:00:00
72<NA>7194(유)큰길이엔지교량/터널송장기2020-01-23 00:00:00