Overview

Dataset statistics

Number of variables8
Number of observations48
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory66.8 B

Variable types

Categorical6
Text2

Dataset

Description충청남도 화학사고 발생 시 신속한 대응체계 구축을 위한 15개시군 비상연락망 - 부서, 내선번호(사무실, 당직실), 팩스번호(사무실, 당직실)
Author충청남도
URLhttps://www.data.go.kr/data/15047587/fileData.do

Alerts

팩스번호(당직실_야간) is highly overall correlated with 기관명 and 3 other fieldsHigh correlation
기관명 is highly overall correlated with 부서명 and 3 other fieldsHigh correlation
부서명 is highly overall correlated with 기관명 and 3 other fieldsHigh correlation
내선번호(당직실_야간) is highly overall correlated with 기관명 and 3 other fieldsHigh correlation
팩스번호(사무실_주간) is highly overall correlated with 기관명 and 3 other fieldsHigh correlation
내선번호(사무실_주간) has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:49:08.925078
Analysis finished2023-12-12 08:49:09.658122
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관명
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
충청남도
 
3
천안시
 
3
공주시
 
3
보령시
 
3
아산시
 
3
Other values (11)
33 

Length

Max length4
Median length3
Mean length3.0625
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충청남도
2nd row충청남도
3rd row충청남도
4th row천안시
5th row천안시

Common Values

ValueCountFrequency (%)
충청남도 3
 
6.2%
천안시 3
 
6.2%
공주시 3
 
6.2%
보령시 3
 
6.2%
아산시 3
 
6.2%
서산시 3
 
6.2%
논산시 3
 
6.2%
계룡시 3
 
6.2%
당진시 3
 
6.2%
금산군 3
 
6.2%
Other values (6) 18
37.5%

Length

2023-12-12T17:49:09.726701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
충청남도 3
 
6.2%
천안시 3
 
6.2%
공주시 3
 
6.2%
보령시 3
 
6.2%
아산시 3
 
6.2%
서산시 3
 
6.2%
논산시 3
 
6.2%
계룡시 3
 
6.2%
당진시 3
 
6.2%
금산군 3
 
6.2%
Other values (6) 18
37.5%

부서명
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size516.0 B
환경보호과
12 
환경과
12 
환경안전관리과
3 
환경정책과
3 
환경보전과
3 
Other values (5)
15 

Length

Max length7
Median length5
Mean length4.75
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row환경안전관리과
2nd row환경안전관리과
3rd row환경안전관리과
4th row환경정책과
5th row환경정책과

Common Values

ValueCountFrequency (%)
환경보호과 12
25.0%
환경과 12
25.0%
환경안전관리과 3
 
6.2%
환경정책과 3
 
6.2%
환경보전과 3
 
6.2%
환경생태과 3
 
6.2%
환경위생과 3
 
6.2%
환경관리사업소 3
 
6.2%
환경자원과 3
 
6.2%
환경산림과 3
 
6.2%

Length

2023-12-12T17:49:09.872228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:49:10.049301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
환경보호과 12
25.0%
환경과 12
25.0%
환경안전관리과 3
 
6.2%
환경정책과 3
 
6.2%
환경보전과 3
 
6.2%
환경생태과 3
 
6.2%
환경위생과 3
 
6.2%
환경관리사업소 3
 
6.2%
환경자원과 3
 
6.2%
환경산림과 3
 
6.2%

직위(직급)
Categorical

Distinct4
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
팀장
16 
주무관
16 
과장
15 
소장
 
1

Length

Max length3
Median length2
Mean length2.3333333
Min length2

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row과장
2nd row팀장
3rd row주무관
4th row과장
5th row팀장

Common Values

ValueCountFrequency (%)
팀장 16
33.3%
주무관 16
33.3%
과장 15
31.2%
소장 1
 
2.1%

Length

2023-12-12T17:49:10.243588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:49:10.356730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
팀장 16
33.3%
주무관 16
33.3%
과장 15
31.2%
소장 1
 
2.1%

성 명
Text

Distinct47
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-12T17:49:10.556283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9791667
Min length2

Characters and Unicode

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

Unique

Unique46 ?
Unique (%)95.8%

Sample

1st row김윤섭
2nd row류광하
3rd row천혜연
4th row윤상원
5th row김수진
ValueCountFrequency (%)
강미영 2
 
4.2%
박재근 1
 
2.1%
박시온 1
 
2.1%
김현성 1
 
2.1%
신갑동 1
 
2.1%
조기환 1
 
2.1%
차재승 1
 
2.1%
유정현 1
 
2.1%
장기수 1
 
2.1%
한흥현 1
 
2.1%
Other values (37) 37
77.1%
2023-12-12T17:49:10.905135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 8
 
5.6%
이 8
 
5.6%
박 7
 
4.9%
진 6
 
4.2%
현 5
 
3.5%
영 5
 
3.5%
성 4
 
2.8%
연 4
 
2.8%
미 4
 
2.8%
장 4
 
2.8%
Other values (57) 88
61.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 143
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 8
 
5.6%
이 8
 
5.6%
박 7
 
4.9%
진 6
 
4.2%
현 5
 
3.5%
영 5
 
3.5%
성 4
 
2.8%
연 4
 
2.8%
미 4
 
2.8%
장 4
 
2.8%
Other values (57) 88
61.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 143
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 8
 
5.6%
이 8
 
5.6%
박 7
 
4.9%
진 6
 
4.2%
현 5
 
3.5%
영 5
 
3.5%
성 4
 
2.8%
연 4
 
2.8%
미 4
 
2.8%
장 4
 
2.8%
Other values (57) 88
61.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 143
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 8
 
5.6%
이 8
 
5.6%
박 7
 
4.9%
진 6
 
4.2%
현 5
 
3.5%
영 5
 
3.5%
성 4
 
2.8%
연 4
 
2.8%
미 4
 
2.8%
장 4
 
2.8%
Other values (57) 88
61.5%

내선번호(사무실_주간)
Text

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-12T17:49:11.196879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique48 ?
Unique (%)100.0%

Sample

1st row041-635-2720
2nd row041-635-4431
3rd row041-635-4442
4th row041-521-2330
5th row041-521-2332
ValueCountFrequency (%)
041-635-2720 1
 
2.1%
041-635-4431 1
 
2.1%
041-950-4332 1
 
2.1%
041-360-6761 1
 
2.1%
041-750-2510 1
 
2.1%
041-750-2521 1
 
2.1%
041-750-2523 1
 
2.1%
041-830-2290 1
 
2.1%
041-830-2296 1
 
2.1%
041-830-2299 1
 
2.1%
Other values (38) 38
79.2%
2023-12-12T17:49:11.598649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 101
17.5%
- 96
16.7%
4 83
14.4%
1 72
12.5%
2 50
8.7%
3 45
7.8%
5 38
 
6.6%
6 32
 
5.6%
7 22
 
3.8%
9 20
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 480
83.3%
Dash Punctuation 96
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 101
21.0%
4 83
17.3%
1 72
15.0%
2 50
10.4%
3 45
9.4%
5 38
 
7.9%
6 32
 
6.7%
7 22
 
4.6%
9 20
 
4.2%
8 17
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 96
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 576
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 101
17.5%
- 96
16.7%
4 83
14.4%
1 72
12.5%
2 50
8.7%
3 45
7.8%
5 38
 
6.6%
6 32
 
5.6%
7 22
 
3.8%
9 20
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 576
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 101
17.5%
- 96
16.7%
4 83
14.4%
1 72
12.5%
2 50
8.7%
3 45
7.8%
5 38
 
6.6%
6 32
 
5.6%
7 22
 
3.8%
9 20
 
3.5%

팩스번호(사무실_주간)
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
041-635-3065
 
3
041-521-2339
 
3
041-840-3736
 
3
041-930-3659
 
3
041-540-2328
 
3
Other values (11)
33 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row041-635-3065
2nd row041-635-3065
3rd row041-635-3065
4th row041-521-2339
5th row041-521-2339

Common Values

ValueCountFrequency (%)
041-635-3065 3
 
6.2%
041-521-2339 3
 
6.2%
041-840-3736 3
 
6.2%
041-930-3659 3
 
6.2%
041-540-2328 3
 
6.2%
041-660-2748 3
 
6.2%
041-746-5519 3
 
6.2%
042-840-2459 3
 
6.2%
041-360-6769 3
 
6.2%
041-751-6291 3
 
6.2%
Other values (6) 18
37.5%

Length

2023-12-12T17:49:11.770679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
041-635-3065 3
 
6.2%
041-521-2339 3
 
6.2%
041-840-3736 3
 
6.2%
041-930-3659 3
 
6.2%
041-540-2328 3
 
6.2%
041-660-2748 3
 
6.2%
041-746-5519 3
 
6.2%
042-840-2459 3
 
6.2%
041-360-6769 3
 
6.2%
041-751-6291 3
 
6.2%
Other values (6) 18
37.5%

내선번호(당직실_야간)
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)35.4%
Missing0
Missing (%)0.0%
Memory size516.0 B
041-635-2222
 
3
041-521-2222
 
3
041-840-2222
 
3
041-930-3114
 
3
041-540-2222
 
3
Other values (12)
33 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row041-635-2222
2nd row041-635-2222
3rd row041-635-2222
4th row041-521-2222
5th row041-521-2222

Common Values

ValueCountFrequency (%)
041-635-2222 3
 
6.2%
041-521-2222 3
 
6.2%
041-840-2222 3
 
6.2%
041-930-3114 3
 
6.2%
041-540-2222 3
 
6.2%
041-660-2222 3
 
6.2%
041-746-5700 3
 
6.2%
042-840-2222 3
 
6.2%
041-670-2114 3
 
6.2%
041-750-2222 3
 
6.2%
Other values (7) 18
37.5%

Length

2023-12-12T17:49:11.882231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
041-635-2222 3
 
6.2%
041-521-2222 3
 
6.2%
041-339-7222 3
 
6.2%
041-630-1114 3
 
6.2%
041-940-2222 3
 
6.2%
041-950-4444 3
 
6.2%
041-830-2840 3
 
6.2%
041-750-2222 3
 
6.2%
041-670-2114 3
 
6.2%
042-840-2222 3
 
6.2%
Other values (7) 18
37.5%

팩스번호(당직실_야간)
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)35.4%
Missing0
Missing (%)0.0%
Memory size516.0 B
041-635-3000
 
3
041-350-3699
 
3
041-670-1569
 
3
041-840-2362
 
3
041-930-3116
 
3
Other values (12)
33 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row041-635-3000
2nd row041-635-3000
3rd row041-635-3000
4th row041-521-2339
5th row041-521-2339

Common Values

ValueCountFrequency (%)
041-635-3000 3
 
6.2%
041-350-3699 3
 
6.2%
041-670-1569 3
 
6.2%
041-840-2362 3
 
6.2%
041-930-3116 3
 
6.2%
041-660-2229 3
 
6.2%
041-746-5519 3
 
6.2%
041-521-2339 3
 
6.2%
042-840-2229 3
 
6.2%
041-751-6291 3
 
6.2%
Other values (7) 18
37.5%

Length

2023-12-12T17:49:12.012429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
041-635-3000 3
 
6.2%
041-350-3699 3
 
6.2%
041-339-7509 3
 
6.2%
041-630-1421 3
 
6.2%
041-940-2420 3
 
6.2%
041-950-4695 3
 
6.2%
041-830-2319 3
 
6.2%
041-751-6291 3
 
6.2%
042-840-2229 3
 
6.2%
041-521-2339 3
 
6.2%
Other values (7) 18
37.5%

Correlations

2023-12-12T17:49:12.097217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기관명부서명직위(직급)성 명내선번호(사무실_주간)팩스번호(사무실_주간)내선번호(당직실_야간)팩스번호(당직실_야간)
기관명1.0001.0000.0000.9611.0001.0001.0001.000
부서명1.0001.0000.0000.7131.0001.0001.0001.000
직위(직급)0.0000.0001.0000.9071.0000.0000.0000.000
성 명0.9610.7130.9071.0001.0000.9610.9680.968
내선번호(사무실_주간)1.0001.0001.0001.0001.0001.0001.0001.000
팩스번호(사무실_주간)1.0001.0000.0000.9611.0001.0001.0001.000
내선번호(당직실_야간)1.0001.0000.0000.9681.0001.0001.0001.000
팩스번호(당직실_야간)1.0001.0000.0000.9681.0001.0001.0001.000
2023-12-12T17:49:12.239754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
팩스번호(당직실_야간)기관명부서명내선번호(당직실_야간)팩스번호(사무실_주간)직위(직급)
팩스번호(당직실_야간)1.0000.9840.9030.9510.9840.000
기관명0.9841.0000.9180.9841.0000.000
부서명0.9030.9181.0000.9030.9180.000
내선번호(당직실_야간)0.9510.9840.9031.0000.9840.000
팩스번호(사무실_주간)0.9841.0000.9180.9841.0000.000
직위(직급)0.0000.0000.0000.0000.0001.000
2023-12-12T17:49:12.350582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기관명부서명직위(직급)팩스번호(사무실_주간)내선번호(당직실_야간)팩스번호(당직실_야간)
기관명1.0000.9180.0001.0000.9840.984
부서명0.9181.0000.0000.9180.9030.903
직위(직급)0.0000.0001.0000.0000.0000.000
팩스번호(사무실_주간)1.0000.9180.0001.0000.9840.984
내선번호(당직실_야간)0.9840.9030.0000.9841.0000.951
팩스번호(당직실_야간)0.9840.9030.0000.9840.9511.000

Missing values

2023-12-12T17:49:09.462887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:49:09.598813image/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충청남도환경안전관리과과장김윤섭041-635-2720041-635-3065041-635-2222041-635-3000
1충청남도환경안전관리과팀장류광하041-635-4431041-635-3065041-635-2222041-635-3000
2충청남도환경안전관리과주무관천혜연041-635-4442041-635-3065041-635-2222041-635-3000
3천안시환경정책과과장윤상원041-521-2330041-521-2339041-521-2222041-521-2339
4천안시환경정책과팀장김수진041-521-2332041-521-2339041-521-2222041-521-2339
5천안시환경정책과주무관신정현041-521-5437041-521-2339041-521-2222041-521-2339
6공주시환경보호과과장홍석종041-840-8521041-840-3736041-840-2222041-840-2362
7공주시환경보호과팀장이진석041-840-8531041-840-3736041-840-2222041-840-2362
8공주시환경보호과주무관장동희041-840-8514041-840-3736041-840-2222041-840-2362
9보령시환경보호과과장이연헌041-930-3650041-930-3659041-930-3114041-930-3116
기관명부서명직위(직급)성 명내선번호(사무실_주간)팩스번호(사무실_주간)내선번호(당직실_야간)팩스번호(당직실_야간)
38청양군환경보호과주무관김하일041-940-2243041-940-2239041-940-2222041-940-2420
39홍성군환경과과장유철식041-630-1220041-630-1421041-630-1114041-630-1421
40홍성군환경과팀장김성현041-630-1831041-630-1421041-630-1114041-630-1421
41홍성군환경과주무관이대영041-630-1456041-630-1421041-630-1114041-630-1421
42예산군환경과과장이장연041-339-7500041-339-7509041-339-7222041-339-7509
43예산군환경과팀장이범진041-339-7511041-339-7509041-339-7222041-339-7509
44예산군환경과주무관박형배041-339-7512041-339-7509041-339-7222041-339-7509
45태안군환경산림과과장이종진041-670-2340041-670-1522041-670-2114041-670-1569
46태안군환경산림과팀장박태순041-670-2153041-670-1522041-670-2114041-670-1569
47태안군환경산림과주무관문영수041-670-2792041-670-1522041-670-2114041-670-1569