Overview

Dataset statistics

Number of variables8
Number of observations60
Missing cells8
Missing cells (%)1.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.9 KiB
Average record size in memory66.2 B

Variable types

Categorical4
Text3
DateTime1

Dataset

Description전라남도 소방시설 감리업체 현황 (상호명, 주소, 소방시설업 등록번호, 등록일자, 폐업여부)에 관한 데이터를 조회하실 수 있게 제공하고 있습니다.
Author전라남도
URLhttps://www.data.go.kr/data/15122357/fileData.do

Alerts

업종 has constant value ""Constant
폐업여부 is highly overall correlated with 세부지역 and 1 other fieldsHigh correlation
세부지역 is highly overall correlated with 폐업여부High correlation
분야 is highly overall correlated with 폐업여부High correlation
등록일자 has 8 (13.3%) missing valuesMissing

Reproduction

Analysis started2023-12-12 03:40:12.378543
Analysis finished2023-12-12 03:40:13.101541
Duration0.72 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

세부지역
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)15.0%
Missing0
Missing (%)0.0%
Memory size612.0 B
여수시
13 
목포시
13 
순천시
11 
나주시
8 
광양시
7 
Other values (4)
8 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique2 ?
Unique (%)3.3%

Sample

1st row여수시
2nd row광양시
3rd row광양시
4th row목포시
5th row목포시

Common Values

ValueCountFrequency (%)
여수시 13
21.7%
목포시 13
21.7%
순천시 11
18.3%
나주시 8
13.3%
광양시 7
11.7%
화순군 3
 
5.0%
해남군 3
 
5.0%
장성군 1
 
1.7%
고흥군 1
 
1.7%

Length

2023-12-12T12:40:13.196512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:40:13.417968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
여수시 13
21.7%
목포시 13
21.7%
순천시 11
18.3%
나주시 8
13.3%
광양시 7
11.7%
화순군 3
 
5.0%
해남군 3
 
5.0%
장성군 1
 
1.7%
고흥군 1
 
1.7%

상호
Text

Distinct38
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Memory size612.0 B
2023-12-12T12:40:13.720198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length14
Mean length8.5
Min length4

Characters and Unicode

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

Unique

Unique16 ?
Unique (%)26.7%

Sample

1st row(주)제일소방환경
2nd row(주)거산소방공사
3rd row(주)거산소방공사
4th row(주)백두기연
5th row(주)백두기연
ValueCountFrequency (%)
주식회사 15
 
17.6%
유한회사 6
 
7.1%
kst 2
 
2.4%
유)전남이엔지 2
 
2.4%
정원이엔지 2
 
2.4%
정도eng 2
 
2.4%
믿음이엔지 2
 
2.4%
거성이앤지 2
 
2.4%
한국안전기술 2
 
2.4%
가나이엔지 2
 
2.4%
Other values (32) 48
56.5%
2023-12-12T12:40:14.204643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 31
 
6.1%
사 27
 
5.3%
25
 
4.9%
지 25
 
4.9%
) 24
 
4.7%
( 24
 
4.7%
엔 23
 
4.5%
회 21
 
4.1%
이 20
 
3.9%
유 15
 
2.9%
Other values (84) 275
53.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 409
80.2%
Uppercase Letter 28
 
5.5%
Space Separator 25
 
4.9%
Close Punctuation 24
 
4.7%
Open Punctuation 24
 
4.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 31
 
7.6%
사 27
 
6.6%
지 25
 
6.1%
엔 23
 
5.6%
회 21
 
5.1%
이 20
 
4.9%
유 15
 
3.7%
식 15
 
3.7%
한 15
 
3.7%
방 14
 
3.4%
Other values (73) 203
49.6%
Uppercase Letter
ValueCountFrequency (%)
N 6
21.4%
E 6
21.4%
G 4
14.3%
S 4
14.3%
K 2
 
7.1%
T 2
 
7.1%
F 2
 
7.1%
C 2
 
7.1%
Space Separator
ValueCountFrequency (%)
25
100.0%
Close Punctuation
ValueCountFrequency (%)
) 24
100.0%
Open Punctuation
ValueCountFrequency (%)
( 24
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 409
80.2%
Common 73
 
14.3%
Latin 28
 
5.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 31
 
7.6%
사 27
 
6.6%
지 25
 
6.1%
엔 23
 
5.6%
회 21
 
5.1%
이 20
 
4.9%
유 15
 
3.7%
식 15
 
3.7%
한 15
 
3.7%
방 14
 
3.4%
Other values (73) 203
49.6%
Latin
ValueCountFrequency (%)
N 6
21.4%
E 6
21.4%
G 4
14.3%
S 4
14.3%
K 2
 
7.1%
T 2
 
7.1%
F 2
 
7.1%
C 2
 
7.1%
Common
ValueCountFrequency (%)
25
34.2%
) 24
32.9%
( 24
32.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 409
80.2%
ASCII 101
 
19.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 31
 
7.6%
사 27
 
6.6%
지 25
 
6.1%
엔 23
 
5.6%
회 21
 
5.1%
이 20
 
4.9%
유 15
 
3.7%
식 15
 
3.7%
한 15
 
3.7%
방 14
 
3.4%
Other values (73) 203
49.6%
ASCII
ValueCountFrequency (%)
25
24.8%
) 24
23.8%
( 24
23.8%
N 6
 
5.9%
E 6
 
5.9%
G 4
 
4.0%
S 4
 
4.0%
K 2
 
2.0%
T 2
 
2.0%
F 2
 
2.0%

주소
Text

Distinct38
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Memory size612.0 B
2023-12-12T12:40:14.593570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length44
Mean length34.85
Min length29

Characters and Unicode

Total characters2091
Distinct characters129
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

Unique16 ?
Unique (%)26.7%

Sample

1st row(59687) 전라남도 여수시 신기남1길 30-7 (신기동)
2nd row(57740) 전라남도 광양시 광양읍 칠성로 16 ()
3rd row(57740) 전라남도 광양시 광양읍 칠성로 16 ()
4th row(58600) 전라남도 목포시 대양산단로97번길 33 (대양동)
5th row(58600) 전라남도 목포시 대양산단로97번길 33 (대양동)
ValueCountFrequency (%)
전라남도 60
 
15.0%
13
 
3.3%
여수시 13
 
3.3%
목포시 13
 
3.3%
순천시 11
 
2.8%
나주시 8
 
2.0%
광양시 7
 
1.8%
광양읍 6
 
1.5%
화장동 6
 
1.5%
조례동 5
 
1.3%
Other values (145) 257
64.4%
2023-12-12T12:40:15.202302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
340
 
16.3%
( 113
 
5.4%
) 113
 
5.4%
5 90
 
4.3%
남 79
 
3.8%
도 61
 
2.9%
7 60
 
2.9%
전 60
 
2.9%
라 60
 
2.9%
2 58
 
2.8%
Other values (119) 1057
50.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 945
45.2%
Decimal Number 534
25.5%
Space Separator 340
 
16.3%
Open Punctuation 113
 
5.4%
Close Punctuation 113
 
5.4%
Other Punctuation 32
 
1.5%
Dash Punctuation 14
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 79
 
8.4%
도 61
 
6.5%
전 60
 
6.3%
라 60
 
6.3%
동 55
 
5.8%
시 54
 
5.7%
길 34
 
3.6%
로 34
 
3.6%
양 25
 
2.6%
층 19
 
2.0%
Other values (104) 464
49.1%
Decimal Number
ValueCountFrequency (%)
5 90
16.9%
7 60
11.2%
2 58
10.9%
1 54
10.1%
3 54
10.1%
6 54
10.1%
8 50
9.4%
9 45
8.4%
0 44
8.2%
4 25
 
4.7%
Space Separator
ValueCountFrequency (%)
340
100.0%
Open Punctuation
ValueCountFrequency (%)
( 113
100.0%
Close Punctuation
ValueCountFrequency (%)
) 113
100.0%
Other Punctuation
ValueCountFrequency (%)
, 32
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1146
54.8%
Hangul 945
45.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 79
 
8.4%
도 61
 
6.5%
전 60
 
6.3%
라 60
 
6.3%
동 55
 
5.8%
시 54
 
5.7%
길 34
 
3.6%
로 34
 
3.6%
양 25
 
2.6%
층 19
 
2.0%
Other values (104) 464
49.1%
Common
ValueCountFrequency (%)
340
29.7%
( 113
 
9.9%
) 113
 
9.9%
5 90
 
7.9%
7 60
 
5.2%
2 58
 
5.1%
1 54
 
4.7%
3 54
 
4.7%
6 54
 
4.7%
8 50
 
4.4%
Other values (5) 160
14.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1146
54.8%
Hangul 945
45.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
340
29.7%
( 113
 
9.9%
) 113
 
9.9%
5 90
 
7.9%
7 60
 
5.2%
2 58
 
5.1%
1 54
 
4.7%
3 54
 
4.7%
6 54
 
4.7%
8 50
 
4.4%
Other values (5) 160
14.0%
Hangul
ValueCountFrequency (%)
남 79
 
8.4%
도 61
 
6.5%
전 60
 
6.3%
라 60
 
6.3%
동 55
 
5.8%
시 54
 
5.7%
길 34
 
3.6%
로 34
 
3.6%
양 25
 
2.6%
층 19
 
2.0%
Other values (104) 464
49.1%

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size612.0 B
감리업
60 

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 (%)
감리업 60
100.0%

Length

2023-12-12T12:40:15.395009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:40:15.551625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
감리업 60
100.0%

분야
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size612.0 B
일반(기계)
21 
일반(전기)
21 
전문
10 
일반(전기),일반(기계)
4 
전문,일반(전기),일반(기계)
3 

Length

Max length34
Median length6
Mean length6.7666667
Min length2

Unique

Unique1 ?
Unique (%)1.7%

Sample

1st row일반(전기),일반(기계)
2nd row전문,일반(전기),일반(기계)
3rd row전문,일반(전기),일반(기계)
4th row일반(기계)
5th row일반(전기)

Common Values

ValueCountFrequency (%)
일반(기계) 21
35.0%
일반(전기) 21
35.0%
전문 10
16.7%
일반(전기),일반(기계) 4
 
6.7%
전문,일반(전기),일반(기계) 3
 
5.0%
일반(전기),일반(전기),일반(기계),일반(기계),일반(기계) 1
 
1.7%

Length

2023-12-12T12:40:15.713978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:40:15.872929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반(기계 21
35.0%
일반(전기 21
35.0%
전문 10
16.7%
일반(전기),일반(기계 4
 
6.7%
전문,일반(전기),일반(기계 3
 
5.0%
일반(전기),일반(전기),일반(기계),일반(기계),일반(기계 1
 
1.7%

소방시설업 등록번호
Text

Distinct39
Distinct (%)65.0%
Missing0
Missing (%)0.0%
Memory size612.0 B
2023-12-12T12:40:16.122270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length11.116667
Min length8

Characters and Unicode

Total characters667
Distinct characters23
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

Unique18 ?
Unique (%)30.0%

Sample

1st row제2013-나-1호
2nd row2016-03-00081
3rd row제2010-마-1호
4th row제2006-가-2호
5th row제2006-가-2호
ValueCountFrequency (%)
2020-03-00059 2
 
3.3%
제2011-다-6호 2
 
3.3%
제2014-다-7호 2
 
3.3%
2019-03-00078 2
 
3.3%
2016-03-00101 2
 
3.3%
2023-03-00010 2
 
3.3%
2020-03-00065 2
 
3.3%
2022-03-00005 2
 
3.3%
제2011-다-8호 2
 
3.3%
2019-03-00059 2
 
3.3%
Other values (29) 40
66.7%
2023-12-12T12:40:16.592198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 187
28.0%
- 114
17.1%
2 83
12.4%
1 57
 
8.5%
3 50
 
7.5%
호 35
 
5.2%
제 34
 
5.1%
6 20
 
3.0%
5 14
 
2.1%
4 13
 
1.9%
Other values (13) 60
 
9.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 451
67.6%
Dash Punctuation 114
 
17.1%
Other Letter 102
 
15.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
호 35
34.3%
제 34
33.3%
가 9
 
8.8%
다 7
 
6.9%
마 4
 
3.9%
나 3
 
2.9%
라 3
 
2.9%
순 2
 
2.0%
천 2
 
2.0%
바 1
 
1.0%
Other values (2) 2
 
2.0%
Decimal Number
ValueCountFrequency (%)
0 187
41.5%
2 83
18.4%
1 57
 
12.6%
3 50
 
11.1%
6 20
 
4.4%
5 14
 
3.1%
4 13
 
2.9%
8 10
 
2.2%
7 9
 
2.0%
9 8
 
1.8%
Dash Punctuation
ValueCountFrequency (%)
- 114
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 565
84.7%
Hangul 102
 
15.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
호 35
34.3%
제 34
33.3%
가 9
 
8.8%
다 7
 
6.9%
마 4
 
3.9%
나 3
 
2.9%
라 3
 
2.9%
순 2
 
2.0%
천 2
 
2.0%
바 1
 
1.0%
Other values (2) 2
 
2.0%
Common
ValueCountFrequency (%)
0 187
33.1%
- 114
20.2%
2 83
14.7%
1 57
 
10.1%
3 50
 
8.8%
6 20
 
3.5%
5 14
 
2.5%
4 13
 
2.3%
8 10
 
1.8%
7 9
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 565
84.7%
Hangul 102
 
15.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 187
33.1%
- 114
20.2%
2 83
14.7%
1 57
 
10.1%
3 50
 
8.8%
6 20
 
3.5%
5 14
 
2.5%
4 13
 
2.3%
8 10
 
1.8%
7 9
 
1.6%
Hangul
ValueCountFrequency (%)
호 35
34.3%
제 34
33.3%
가 9
 
8.8%
다 7
 
6.9%
마 4
 
3.9%
나 3
 
2.9%
라 3
 
2.9%
순 2
 
2.0%
천 2
 
2.0%
바 1
 
1.0%
Other values (2) 2
 
2.0%

등록일자
Date

MISSING 

Distinct31
Distinct (%)59.6%
Missing8
Missing (%)13.3%
Memory size612.0 B
Minimum1995-01-06 00:00:00
Maximum2023-07-17 00:00:00
2023-12-12T12:40:16.805177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:40:16.972250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)

폐업여부
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size612.0 B
<NA>
52 
폐업
8 

Length

Max length4
Median length4
Mean length3.7333333
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐업
2nd row폐업
3rd row폐업
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 52
86.7%
폐업 8
 
13.3%

Length

2023-12-12T12:40:17.114692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:40:17.236656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 52
86.7%
폐업 8
 
13.3%

Correlations

2023-12-12T12:40:17.302507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세부지역상호주소분야소방시설업 등록번호등록일자
세부지역1.0001.0001.0000.5291.0001.000
상호1.0001.0001.0000.9130.9991.000
주소1.0001.0001.0000.9130.9991.000
분야0.5290.9130.9131.0000.8720.000
소방시설업 등록번호1.0000.9990.9990.8721.0001.000
등록일자1.0001.0001.0000.0001.0001.000
2023-12-12T12:40:17.404918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
폐업여부세부지역분야
폐업여부1.0001.0001.000
세부지역1.0001.0000.283
분야1.0000.2831.000
2023-12-12T12:40:17.502384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세부지역분야폐업여부
세부지역1.0000.2831.000
분야0.2831.0001.000
폐업여부1.0001.0001.000

Missing values

2023-12-12T12:40:12.833684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:40:13.046457image/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

세부지역상호주소업종분야소방시설업 등록번호등록일자폐업여부
0여수시(주)제일소방환경(59687) 전라남도 여수시 신기남1길 30-7 (신기동)감리업일반(전기),일반(기계)제2013-나-1호<NA>폐업
1광양시(주)거산소방공사(57740) 전라남도 광양시 광양읍 칠성로 16 ()감리업전문,일반(전기),일반(기계)2016-03-00081<NA>폐업
2광양시(주)거산소방공사(57740) 전라남도 광양시 광양읍 칠성로 16 ()감리업전문,일반(전기),일반(기계)제2010-마-1호<NA>폐업
3목포시(주)백두기연(58600) 전라남도 목포시 대양산단로97번길 33 (대양동)감리업일반(기계)제2006-가-2호2006-04-05<NA>
4목포시(주)백두기연(58600) 전라남도 목포시 대양산단로97번길 33 (대양동)감리업일반(전기)제2006-가-2호2006-04-05<NA>
5화순군주식회사 유탑엔지니어링(58118) 전라남도 화순군 화순읍 자치샘로 48 ,310호(미래타워)감리업전문제2012-카-25호2012-06-18<NA>
6해남군(주)성동전기소방(59043) 전라남도 해남군 홍교로 78 (해남읍)감리업일반(전기),일반(기계)제2012-아-4호<NA>폐업
7목포시주식회사 하나엔지니어링(58697) 전라남도 목포시 입암로 7-1 301호(상동,동광오피스텔)감리업일반(전기),일반(전기),일반(기계),일반(기계),일반(기계)제2008-가-2호<NA>폐업
8순천시(주)한울이엔지(57970) 전라남도 순천시 연동남1길 37 (조례동)감리업일반(기계)순천제2003-1호2003-04-14<NA>
9순천시(주)한울이엔지(57970) 전라남도 순천시 연동남1길 37 (조례동)감리업일반(전기)순천제2003-1호2003-04-14<NA>
세부지역상호주소업종분야소방시설업 등록번호등록일자폐업여부
50순천시팔마기술단 주식회사(57924) 전라남도 순천시 중앙로 513-1 (가곡동)감리업전문제2011-다-6호2011-06-16<NA>
51화순군유한회사 에프씨(58148) 전라남도 화순군 도곡면 천암3길 9-21 , 1층감리업전문2021-03-000142021-03-02<NA>
52나주시주식회사 피치이앤씨(58327) 전라남도 나주시 황동1길 52-8 ,102호(빛가람동)감리업일반(전기),일반(기계)2021-03-00046<NA>폐업
53해남군유한회사 진용(59038) 전라남도 해남군 해남읍 교육청길 60 ,701호(해남오피스텔)감리업일반(기계)2022-03-000052022-01-12<NA>
54해남군유한회사 진용(59038) 전라남도 해남군 해남읍 교육청길 60 ,701호(해남오피스텔)감리업일반(전기)2022-03-000052022-01-12<NA>
55여수시주식회사 대신소방기술(59678) 전라남도 여수시 쌍봉로 135 , 2층(학동)감리업일반(기계)2023-03-000102023-02-07<NA>
56여수시주식회사 대신소방기술(59678) 전라남도 여수시 쌍봉로 135 , 2층(학동)감리업일반(전기)2023-03-000102023-02-07<NA>
57고흥군유한회사 장강(59540) 전라남도 고흥군 고흥읍 여산당촌길 23 ,301호(고흥군산림조합청사)감리업전문2023-03-000532023-07-17<NA>
58광양시주식회사 케이앤에스엔지니어링(57754) 전라남도 광양시 광양읍 인덕로 967-1 , 3층감리업일반(기계)2023-03-000372023-05-03<NA>
59광양시주식회사 케이앤에스엔지니어링(57754) 전라남도 광양시 광양읍 인덕로 967-1 , 3층감리업일반(전기)2023-03-000372023-05-03<NA>