Overview

Dataset statistics

Number of variables5
Number of observations40
Missing cells40
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory44.3 B

Variable types

Text3
Categorical1
Unsupported1

Dataset

Description충청북도 내의 소방시설 관리업체에 대한 데이터로 업체명, 주소, 업종 ,전화번호 ,비고 등과 같은 정보를 제공합니다.
Author충청북도
URLhttps://www.data.go.kr/data/3083589/fileData.do

Alerts

업종 has constant value ""Constant
비고 has 40 (100.0%) missing valuesMissing
업체명 has unique valuesUnique
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 02:30:09.145968
Analysis finished2023-12-12 02:30:09.909012
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct40
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-12T11:30:10.092928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length11
Mean length7.2
Min length4

Characters and Unicode

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

Unique

Unique40 ?
Unique (%)100.0%

Sample

1st row대성방재㈜
2nd row대원소방
3rd row명일방재 주식회사
4th row세이프방재 주식회사
5th row일진소방주식회사
ValueCountFrequency (%)
주식회사 10
 
20.0%
대성방재㈜ 1
 
2.0%
㈜제종소방 1
 
2.0%
㈜원방재엔지니어링 1
 
2.0%
케이소방 1
 
2.0%
주식회사공신 1
 
2.0%
주식회사중앙방재 1
 
2.0%
㈜신영방재 1
 
2.0%
㈜에이스방재 1
 
2.0%
㈜엠솔루션 1
 
2.0%
Other values (31) 31
62.0%
2023-12-12T11:30:10.543912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
방 36
 
12.5%
㈜ 23
 
8.0%
재 20
 
6.9%
소 17
 
5.9%
사 14
 
4.9%
주 14
 
4.9%
회 14
 
4.9%
식 13
 
4.5%
10
 
3.5%
원 6
 
2.1%
Other values (73) 121
42.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 251
87.2%
Other Symbol 23
 
8.0%
Space Separator 10
 
3.5%
Decimal Number 2
 
0.7%
Uppercase Letter 2
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
방 36
 
14.3%
재 20
 
8.0%
소 17
 
6.8%
사 14
 
5.6%
주 14
 
5.6%
회 14
 
5.6%
식 13
 
5.2%
원 6
 
2.4%
안 5
 
2.0%
성 5
 
2.0%
Other values (67) 107
42.6%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
1 1
50.0%
Uppercase Letter
ValueCountFrequency (%)
E 1
50.0%
S 1
50.0%
Other Symbol
ValueCountFrequency (%)
㈜ 23
100.0%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 274
95.1%
Common 12
 
4.2%
Latin 2
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
방 36
 
13.1%
㈜ 23
 
8.4%
재 20
 
7.3%
소 17
 
6.2%
사 14
 
5.1%
주 14
 
5.1%
회 14
 
5.1%
식 13
 
4.7%
원 6
 
2.2%
안 5
 
1.8%
Other values (68) 112
40.9%
Common
ValueCountFrequency (%)
10
83.3%
2 1
 
8.3%
1 1
 
8.3%
Latin
ValueCountFrequency (%)
E 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 251
87.2%
None 23
 
8.0%
ASCII 14
 
4.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
방 36
 
14.3%
재 20
 
8.0%
소 17
 
6.8%
사 14
 
5.6%
주 14
 
5.6%
회 14
 
5.6%
식 13
 
5.2%
원 6
 
2.4%
안 5
 
2.0%
성 5
 
2.0%
Other values (67) 107
42.6%
None
ValueCountFrequency (%)
㈜ 23
100.0%
ASCII
ValueCountFrequency (%)
10
71.4%
2 1
 
7.1%
1 1
 
7.1%
E 1
 
7.1%
S 1
 
7.1%

주소
Text

Distinct39
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-12T11:30:10.872075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length31
Mean length24.55
Min length18

Characters and Unicode

Total characters982
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

Unique38 ?
Unique (%)95.0%

Sample

1st row충청북도 옥천군 옥천읍 가화길 21
2nd row충청북도 충주시 탄금대로 93 2층
3rd row충청북도 영동군 영동읍 부용1길 18
4th row충청북도 청주시 청원구 충청대로 151
5th row충청북도 진천군 진천읍 원덕로 243
ValueCountFrequency (%)
충청북도 40
 
18.3%
청주시 27
 
12.4%
청원구 11
 
5.0%
서원구 7
 
3.2%
흥덕구 7
 
3.2%
진천군 3
 
1.4%
충주시 3
 
1.4%
2층 3
 
1.4%
음성군 3
 
1.4%
진천읍 2
 
0.9%
Other values (104) 112
51.4%
2023-12-12T11:30:11.341105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
183
18.6%
청 81
 
8.2%
충 46
 
4.7%
1 44
 
4.5%
북 41
 
4.2%
도 40
 
4.1%
2 35
 
3.6%
로 34
 
3.5%
주 32
 
3.3%
시 31
 
3.2%
Other values (96) 415
42.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 595
60.6%
Decimal Number 186
 
18.9%
Space Separator 183
 
18.6%
Dash Punctuation 14
 
1.4%
Other Punctuation 2
 
0.2%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 81
 
13.6%
충 46
 
7.7%
북 41
 
6.9%
도 40
 
6.7%
로 34
 
5.7%
주 32
 
5.4%
시 31
 
5.2%
구 29
 
4.9%
길 20
 
3.4%
원 19
 
3.2%
Other values (81) 222
37.3%
Decimal Number
ValueCountFrequency (%)
1 44
23.7%
2 35
18.8%
3 26
14.0%
0 23
12.4%
4 16
 
8.6%
7 11
 
5.9%
6 11
 
5.9%
8 10
 
5.4%
5 5
 
2.7%
9 5
 
2.7%
Space Separator
ValueCountFrequency (%)
183
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 595
60.6%
Common 387
39.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 81
 
13.6%
충 46
 
7.7%
북 41
 
6.9%
도 40
 
6.7%
로 34
 
5.7%
주 32
 
5.4%
시 31
 
5.2%
구 29
 
4.9%
길 20
 
3.4%
원 19
 
3.2%
Other values (81) 222
37.3%
Common
ValueCountFrequency (%)
183
47.3%
1 44
 
11.4%
2 35
 
9.0%
3 26
 
6.7%
0 23
 
5.9%
4 16
 
4.1%
- 14
 
3.6%
7 11
 
2.8%
6 11
 
2.8%
8 10
 
2.6%
Other values (5) 14
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 595
60.6%
ASCII 387
39.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
183
47.3%
1 44
 
11.4%
2 35
 
9.0%
3 26
 
6.7%
0 23
 
5.9%
4 16
 
4.1%
- 14
 
3.6%
7 11
 
2.8%
6 11
 
2.8%
8 10
 
2.6%
Other values (5) 14
 
3.6%
Hangul
ValueCountFrequency (%)
청 81
 
13.6%
충 46
 
7.7%
북 41
 
6.9%
도 40
 
6.7%
로 34
 
5.7%
주 32
 
5.4%
시 31
 
5.2%
구 29
 
4.9%
길 20
 
3.4%
원 19
 
3.2%
Other values (81) 222
37.3%

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
소방시설관리업
40 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row소방시설관리업
2nd row소방시설관리업
3rd row소방시설관리업
4th row소방시설관리업
5th row소방시설관리업

Common Values

ValueCountFrequency (%)
소방시설관리업 40
100.0%

Length

2023-12-12T11:30:11.465345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:30:11.559490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소방시설관리업 40
100.0%

전화번호
Text

Distinct39
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-12T11:30:11.761438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.025
Min length12

Characters and Unicode

Total characters481
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique38 ?
Unique (%)95.0%

Sample

1st row043-732-7119
2nd row043-853-1190
3rd row043-743-7968
4th row043-218-8540
5th row043-533-1104
ValueCountFrequency (%)
043-232-1190 2
 
5.0%
043-236-1119 1
 
2.5%
043-716-0119 1
 
2.5%
043-272-0016 1
 
2.5%
043-847-2119 1
 
2.5%
043-225-7770 1
 
2.5%
043-853-3119 1
 
2.5%
043-215-3340 1
 
2.5%
043-214-4119 1
 
2.5%
043-294-4244 1
 
2.5%
Other values (29) 29
72.5%
2023-12-12T11:30:12.167345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 80
16.6%
1 71
14.8%
3 66
13.7%
0 60
12.5%
4 56
11.6%
2 44
9.1%
9 35
7.3%
7 23
 
4.8%
8 20
 
4.2%
6 15
 
3.1%
Other values (2) 11
 
2.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 400
83.2%
Dash Punctuation 80
 
16.6%
Space Separator 1
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 71
17.8%
3 66
16.5%
0 60
15.0%
4 56
14.0%
2 44
11.0%
9 35
8.8%
7 23
 
5.8%
8 20
 
5.0%
6 15
 
3.8%
5 10
 
2.5%
Dash Punctuation
ValueCountFrequency (%)
- 80
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 481
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 80
16.6%
1 71
14.8%
3 66
13.7%
0 60
12.5%
4 56
11.6%
2 44
9.1%
9 35
7.3%
7 23
 
4.8%
8 20
 
4.2%
6 15
 
3.1%
Other values (2) 11
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 481
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 80
16.6%
1 71
14.8%
3 66
13.7%
0 60
12.5%
4 56
11.6%
2 44
9.1%
9 35
7.3%
7 23
 
4.8%
8 20
 
4.2%
6 15
 
3.1%
Other values (2) 11
 
2.3%

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing40
Missing (%)100.0%
Memory size492.0 B

Correlations

2023-12-12T11:30:12.324020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명주소전화번호
업체명1.0001.0001.000
주소1.0001.0001.000
전화번호1.0001.0001.000

Missing values

2023-12-12T11:30:09.407783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:30:09.848385image/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대성방재㈜충청북도 옥천군 옥천읍 가화길 21소방시설관리업043-732-7119<NA>
1대원소방충청북도 충주시 탄금대로 93 2층소방시설관리업043-853-1190<NA>
2명일방재 주식회사충청북도 영동군 영동읍 부용1길 18소방시설관리업043-743-7968<NA>
3세이프방재 주식회사충청북도 청주시 청원구 충청대로 151소방시설관리업043-218-8540<NA>
4일진소방주식회사충청북도 진천군 진천읍 원덕로 243소방시설관리업043-533-1104<NA>
5재원소방충청북도 청주시 흥덕구 풍산로 172소방시설관리업043-268-1190<NA>
6조은소방㈜충청북도 진천군 문백면 문진로 468-21 평안빌리지 2동 103호소방시설관리업043-533-4233<NA>
7㈜21세기소방충청북도 음성군 대소면 대금로 272소방시설관리업043-877-2119<NA>
8㈜ES방재충청북도 청주시 흥덕구 경산로 14소방시설관리업043-233-1197<NA>
9㈜가람방재충청북도 진천군 진천읍 장관1길 16-1소방시설관리업043-232-9119<NA>
업체명주소업종전화번호비고
30㈜제종소방충청북도 청주시 서원구 성화로 26소방시설관리업043-236-1119<NA>
31㈜청주소방안전관리충청북도 청주시 청원구 율봉로152번길 45-3소방시설관리업043-218-1119<NA>
32㈜청풍소방안전공사충청북도 제천시 내토로38길 10소방시설관리업043-643-2119<NA>
33㈜태일방재충청북도 청주시 청원구 토성로120번길 84-1소방시설관리업043-272-9713<NA>
34㈜하나방재충청북도 음성군 금왕읍 무극로244번길 40소방시설관리업043-877-1996<NA>
35중원방재 주식회사충청북도 증평군 증평읍 송산로 130 두타타워 301호소방시설관리업043-836-9119<NA>
36충북학교안전공제회충청북도 청주시 상당구 교서로 17소방시설관리업043-252-7109<NA>
37충청방재㈜충청북도 청주시 서원구 구룡산로 402-1소방시설관리업043-288-0119<NA>
38토광방재안전관리㈜충청북도 청주시 청원구 충청대로 320번길 33소방시설관리업043-294-4244<NA>
39호암방재충청북도 청주시 흥덕구 장구봉로137번길 7-8소방시설관리업043-264-8896<NA>