Overview

Dataset statistics

Number of variables5
Number of observations35
Missing cells35
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory44.8 B

Variable types

Text3
Categorical1
Unsupported1

Dataset

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

Alerts

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

Reproduction

Analysis started2023-12-12 02:30:05.529935
Analysis finished2023-12-12 02:30:05.963186
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

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

Length

Max length11
Median length9
Mean length7.1142857
Min length4

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)100.0%

Sample

1st row(주)21세기소방
2nd row(주)ES방재
3rd row(주)가람방재
4th row(주)미래이앤지
5th row(주)세종소방
ValueCountFrequency (%)
주식회사 5
 
12.5%
주)21세기소방 1
 
2.5%
㈜에이스방재 1
 
2.5%
동성소방 1
 
2.5%
에이탑소방 1
 
2.5%
충북소방 1
 
2.5%
주식회사공신 1
 
2.5%
주식회사중앙방재 1
 
2.5%
㈜신영방재 1
 
2.5%
㈜대진소방 1
 
2.5%
Other values (26) 26
65.0%
2023-12-12T11:30:06.574016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
방 30
 
12.0%
재 18
 
7.2%
주 18
 
7.2%
소 13
 
5.2%
㈜ 12
 
4.8%
( 9
 
3.6%
) 9
 
3.6%
회 9
 
3.6%
사 9
 
3.6%
식 8
 
3.2%
Other values (67) 114
45.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 210
84.3%
Other Symbol 12
 
4.8%
Open Punctuation 9
 
3.6%
Close Punctuation 9
 
3.6%
Space Separator 5
 
2.0%
Uppercase Letter 2
 
0.8%
Decimal Number 2
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
방 30
 
14.3%
재 18
 
8.6%
주 18
 
8.6%
소 13
 
6.2%
회 9
 
4.3%
사 9
 
4.3%
식 8
 
3.8%
원 5
 
2.4%
이 4
 
1.9%
전 4
 
1.9%
Other values (59) 92
43.8%
Uppercase Letter
ValueCountFrequency (%)
E 1
50.0%
S 1
50.0%
Decimal Number
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%
Other Symbol
ValueCountFrequency (%)
㈜ 12
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 222
89.2%
Common 25
 
10.0%
Latin 2
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
방 30
 
13.5%
재 18
 
8.1%
주 18
 
8.1%
소 13
 
5.9%
㈜ 12
 
5.4%
회 9
 
4.1%
사 9
 
4.1%
식 8
 
3.6%
원 5
 
2.3%
이 4
 
1.8%
Other values (60) 96
43.2%
Common
ValueCountFrequency (%)
( 9
36.0%
) 9
36.0%
5
20.0%
1 1
 
4.0%
2 1
 
4.0%
Latin
ValueCountFrequency (%)
E 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 210
84.3%
ASCII 27
 
10.8%
None 12
 
4.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
방 30
 
14.3%
재 18
 
8.6%
주 18
 
8.6%
소 13
 
6.2%
회 9
 
4.3%
사 9
 
4.3%
식 8
 
3.8%
원 5
 
2.4%
이 4
 
1.9%
전 4
 
1.9%
Other values (59) 92
43.8%
None
ValueCountFrequency (%)
㈜ 12
100.0%
ASCII
ValueCountFrequency (%)
( 9
33.3%
) 9
33.3%
5
18.5%
E 1
 
3.7%
S 1
 
3.7%
1 1
 
3.7%
2 1
 
3.7%

주소
Text

UNIQUE 

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

Length

Max length37
Median length28
Mean length23.142857
Min length16

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)100.0%

Sample

1st row충청북도 음성군 대소면 대금로 272
2nd row충청북도 청주시 흥덕구 경산로 14
3rd row충청북도 진천군 진천읍 장관1길 16-1
4th row충청북도 청주시 흥덕구 공단로 134
5th row충청북도 청주시 서원구 성화로 26
ValueCountFrequency (%)
충청북도 35
 
19.3%
청주시 23
 
12.7%
청원구 9
 
5.0%
흥덕구 7
 
3.9%
서원구 5
 
2.8%
충주시 4
 
2.2%
진천군 3
 
1.7%
102 2
 
1.1%
상당구 2
 
1.1%
1층 2
 
1.1%
Other values (84) 89
49.2%
2023-12-12T11:30:07.368246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
150
18.5%
청 69
 
8.5%
충 41
 
5.1%
1 38
 
4.7%
북 35
 
4.3%
도 35
 
4.3%
로 31
 
3.8%
2 30
 
3.7%
주 28
 
3.5%
시 28
 
3.5%
Other values (86) 325
40.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 497
61.4%
Space Separator 150
 
18.5%
Decimal Number 150
 
18.5%
Dash Punctuation 11
 
1.4%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 69
 
13.9%
충 41
 
8.2%
북 35
 
7.0%
도 35
 
7.0%
로 31
 
6.2%
주 28
 
5.6%
시 28
 
5.6%
구 25
 
5.0%
길 17
 
3.4%
원 15
 
3.0%
Other values (72) 173
34.8%
Decimal Number
ValueCountFrequency (%)
1 38
25.3%
2 30
20.0%
3 21
14.0%
0 17
11.3%
4 15
 
10.0%
7 9
 
6.0%
6 6
 
4.0%
8 6
 
4.0%
9 4
 
2.7%
5 4
 
2.7%
Space Separator
ValueCountFrequency (%)
150
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 497
61.4%
Common 313
38.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 69
 
13.9%
충 41
 
8.2%
북 35
 
7.0%
도 35
 
7.0%
로 31
 
6.2%
주 28
 
5.6%
시 28
 
5.6%
구 25
 
5.0%
길 17
 
3.4%
원 15
 
3.0%
Other values (72) 173
34.8%
Common
ValueCountFrequency (%)
150
47.9%
1 38
 
12.1%
2 30
 
9.6%
3 21
 
6.7%
0 17
 
5.4%
4 15
 
4.8%
- 11
 
3.5%
7 9
 
2.9%
6 6
 
1.9%
8 6
 
1.9%
Other values (4) 10
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 497
61.4%
ASCII 313
38.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
150
47.9%
1 38
 
12.1%
2 30
 
9.6%
3 21
 
6.7%
0 17
 
5.4%
4 15
 
4.8%
- 11
 
3.5%
7 9
 
2.9%
6 6
 
1.9%
8 6
 
1.9%
Other values (4) 10
 
3.2%
Hangul
ValueCountFrequency (%)
청 69
 
13.9%
충 41
 
8.2%
북 35
 
7.0%
도 35
 
7.0%
로 31
 
6.2%
주 28
 
5.6%
시 28
 
5.6%
구 25
 
5.0%
길 17
 
3.4%
원 15
 
3.0%
Other values (72) 173
34.8%

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
소방시설관리업
35 

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 (%)
소방시설관리업 35
100.0%

Length

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

Common Values (Plot)

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

전화번호
Text

UNIQUE 

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

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)100.0%

Sample

1st row043-877-2119
2nd row043-233-1197
3rd row043-232-9119
4th row043-212-5460
5th row043-236-1119
ValueCountFrequency (%)
043-877-2119 1
 
2.9%
043-212-1190 1
 
2.9%
043-232-1190 1
 
2.9%
043-217-5119 1
 
2.9%
043-716-0119 1
 
2.9%
043-272-0016 1
 
2.9%
043-847-2119 1
 
2.9%
043-225-7770 1
 
2.9%
043-234-7119 1
 
2.9%
043-853-3119 1
 
2.9%
Other values (25) 25
71.4%
2023-12-12T11:30:08.339968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 70
16.7%
1 61
14.5%
3 58
13.8%
0 52
12.4%
4 52
12.4%
2 37
8.8%
9 29
6.9%
7 19
 
4.5%
8 18
 
4.3%
6 13
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 350
83.3%
Dash Punctuation 70
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 61
17.4%
3 58
16.6%
0 52
14.9%
4 52
14.9%
2 37
10.6%
9 29
8.3%
7 19
 
5.4%
8 18
 
5.1%
6 13
 
3.7%
5 11
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 70
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 420
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 70
16.7%
1 61
14.5%
3 58
13.8%
0 52
12.4%
4 52
12.4%
2 37
8.8%
9 29
6.9%
7 19
 
4.5%
8 18
 
4.3%
6 13
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 420
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 70
16.7%
1 61
14.5%
3 58
13.8%
0 52
12.4%
4 52
12.4%
2 37
8.8%
9 29
6.9%
7 19
 
4.5%
8 18
 
4.3%
6 13
 
3.1%

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing35
Missing (%)100.0%
Memory size447.0 B

Correlations

2023-12-12T11:30:08.452503image/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:05.783904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:30:05.922437image/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세기소방충청북도 음성군 대소면 대금로 272소방시설관리업043-877-2119<NA>
1(주)ES방재충청북도 청주시 흥덕구 경산로 14소방시설관리업043-233-1197<NA>
2(주)가람방재충청북도 진천군 진천읍 장관1길 16-1소방시설관리업043-232-9119<NA>
3(주)미래이앤지충청북도 청주시 흥덕구 공단로 134소방시설관리업043-212-5460<NA>
4(주)세종소방충청북도 청주시 서원구 성화로 26소방시설관리업043-236-1119<NA>
5(주)청주소방안전관리충청북도 청주시 청원구 율봉로152번길 45-3소방시설관리업043-218-1119<NA>
6(주)청풍소방안전공사충청북도 제천시 내토로38길 10소방시설관리업043-643-2119<NA>
7(주)하나방재충청북도 음성군 금왕읍 무극로244번길 40소방시설관리업043-877-1996<NA>
8대성방재㈜충청북도 옥천군 옥천읍 가화길 21소방시설관리업043-732-7119<NA>
9대원소방충청북도 충주시 탄금대로 93 2층소방시설관리업043-853-1190<NA>
업체명주소업종전화번호비고
25㈜신영방재충청북도 청주시 청원구 내수로 23소방시설관리업043-225-7770<NA>
26㈜에이스방재충청북도 충주시 연수양지말길 33-1 1층소방시설관리업043-853-3119<NA>
27㈜원방재엔지니어링충청북도 청주시 청원구 1순환로 102소방시설관리업043-216-6119<NA>
28㈜태일방재충청북도 청주시 청원구 토성로120번길 84-1소방시설관리업043-272-9713<NA>
29중원방재 주식회사충청북도 증평군 증평읍 송산로 130 두타타워 301호소방시설관리업043-836-9119<NA>
30충북학교안전공제회충청북도 청주시 상당구 교서로 17소방시설관리업043-252-7109<NA>
31충청방재㈜충청북도 청주시 서원구 구룡산로 402-1소방시설관리업043-288-0119<NA>
32토광방재안전관리㈜충청북도 청주시 청원구 충청대로 320번길 33소방시설관리업043-294-4244<NA>
33호암방재충청북도 청주시 흥덕구 장구봉로137번길 7-8소방시설관리업043-264-8896<NA>
34㈜엠솔루션충청북도 청주시 청원구 외남로 70-37(외남동)소방시설관리업043-215-3340<NA>