Overview

Dataset statistics

Number of variables4
Number of observations169
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.4 KiB
Average record size in memory32.8 B

Variable types

Categorical1
Text3

Dataset

Description충청북도 내 시 군 구 및 읍 면 동 사무소 연락처 및 개소수 등에 대한 정보 현황 정리 데이터(지역 기관명 전화번호 주소) (지역 기관명 전화번호 주소)
Author충청북도
URLhttps://www.data.go.kr/data/15033291/fileData.do

Alerts

기관명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 01:15:08.442907
Analysis finished2023-12-12 01:15:08.977877
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지역
Categorical

Distinct11
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
청주시
74 
제천시
18 
보은군
12 
영동군
12 
괴산군
12 
Other values (6)
41 

Length

Max length4
Median length3
Mean length3.0059172
Min length3

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st row충청북도
2nd row청주시
3rd row청주시
4th row청주시
5th row청주시

Common Values

ValueCountFrequency (%)
청주시 74
43.8%
제천시 18
 
10.7%
보은군 12
 
7.1%
영동군 12
 
7.1%
괴산군 12
 
7.1%
옥천군 10
 
5.9%
음성군 10
 
5.9%
단양군 9
 
5.3%
진천군 8
 
4.7%
증평군 3
 
1.8%

Length

2023-12-12T10:15:09.092287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
청주시 74
43.8%
제천시 18
 
10.7%
보은군 12
 
7.1%
영동군 12
 
7.1%
괴산군 12
 
7.1%
옥천군 10
 
5.9%
음성군 10
 
5.9%
단양군 9
 
5.3%
진천군 8
 
4.7%
증평군 3
 
1.8%

기관명
Text

UNIQUE 

Distinct169
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T10:15:09.561992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length4
Mean length4.3550296
Min length3

Characters and Unicode

Total characters736
Distinct characters136
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

Unique169 ?
Unique (%)100.0%

Sample

1st row충북도청
2nd row청주시청
3rd row상당구청
4th row낭성면
5th row미원면
ValueCountFrequency (%)
충북도청 1
 
0.6%
영동군청 1
 
0.6%
양산면 1
 
0.6%
군서면 1
 
0.6%
동이면 1
 
0.6%
안남면 1
 
0.6%
안내면 1
 
0.6%
이원면 1
 
0.6%
청산면 1
 
0.6%
군북면 1
 
0.6%
Other values (159) 159
94.1%
2023-12-12T10:15:10.188988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
167
22.7%
면 86
 
11.7%
동 56
 
7.6%
청 24
 
3.3%
산 17
 
2.3%
성 16
 
2.2%
읍 16
 
2.2%
천 12
 
1.6%
군 10
 
1.4%
수 9
 
1.2%
Other values (126) 323
43.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 554
75.3%
Space Separator 167
 
22.7%
Decimal Number 15
 
2.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
면 86
 
15.5%
동 56
 
10.1%
청 24
 
4.3%
산 17
 
3.1%
성 16
 
2.9%
읍 16
 
2.9%
천 12
 
2.2%
군 10
 
1.8%
수 9
 
1.6%
안 8
 
1.4%
Other values (123) 300
54.2%
Decimal Number
ValueCountFrequency (%)
2 8
53.3%
1 7
46.7%
Space Separator
ValueCountFrequency (%)
167
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 554
75.3%
Common 182
 
24.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
면 86
 
15.5%
동 56
 
10.1%
청 24
 
4.3%
산 17
 
3.1%
성 16
 
2.9%
읍 16
 
2.9%
천 12
 
2.2%
군 10
 
1.8%
수 9
 
1.6%
안 8
 
1.4%
Other values (123) 300
54.2%
Common
ValueCountFrequency (%)
167
91.8%
2 8
 
4.4%
1 7
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 554
75.3%
ASCII 182
 
24.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
167
91.8%
2 8
 
4.4%
1 7
 
3.8%
Hangul
ValueCountFrequency (%)
면 86
 
15.5%
동 56
 
10.1%
청 24
 
4.3%
산 17
 
3.1%
성 16
 
2.9%
읍 16
 
2.9%
천 12
 
2.2%
군 10
 
1.8%
수 9
 
1.6%
안 8
 
1.4%
Other values (123) 300
54.2%

전화번호
Text

UNIQUE 

Distinct169
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T10:15:10.508065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.994083
Min length11

Characters and Unicode

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

Unique169 ?
Unique (%)100.0%

Sample

1st row043-220-2114
2nd row043-201-2114
3rd row043-201-5114
4th row043-201-5502
5th row043-201-5552
ValueCountFrequency (%)
043-220-2114 1
 
0.6%
043-740-3114 1
 
0.6%
043-740-5883 1
 
0.6%
043-730-4742 1
 
0.6%
043-730-4502 1
 
0.6%
043-730-4544 1
 
0.6%
043-730-4582 1
 
0.6%
043-730-4702 1
 
0.6%
043-730-4662 1
 
0.6%
043-730-4782 1
 
0.6%
Other values (159) 159
94.1%
2023-12-12T10:15:10.988518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 371
18.3%
- 338
16.7%
3 291
14.4%
4 279
13.8%
2 175
8.6%
1 174
8.6%
5 108
 
5.3%
8 106
 
5.2%
7 92
 
4.5%
6 67
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1689
83.3%
Dash Punctuation 338
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 371
22.0%
3 291
17.2%
4 279
16.5%
2 175
10.4%
1 174
10.3%
5 108
 
6.4%
8 106
 
6.3%
7 92
 
5.4%
6 67
 
4.0%
9 26
 
1.5%
Dash Punctuation
ValueCountFrequency (%)
- 338
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2027
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 371
18.3%
- 338
16.7%
3 291
14.4%
4 279
13.8%
2 175
8.6%
1 174
8.6%
5 108
 
5.3%
8 106
 
5.2%
7 92
 
4.5%
6 67
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2027
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 371
18.3%
- 338
16.7%
3 291
14.4%
4 279
13.8%
2 175
8.6%
1 174
8.6%
5 108
 
5.3%
8 106
 
5.2%
7 92
 
4.5%
6 67
 
3.3%

주소
Text

Distinct168
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T10:15:11.420022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length27
Mean length20.420118
Min length15

Characters and Unicode

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

Unique

Unique167 ?
Unique (%)98.8%

Sample

1st row충청북도 충청북도 청주시 상당구 상당로 82
2nd row충청북도 청주시 상당구 상당로 155
3rd row충청북도 청주시 상당구 상당로 69번길 38
4th row충청북도 청주시 상당구 낭성면 낭성시내길 21
5th row충청북도 청주시 상당구 미원면 단재로 2472
ValueCountFrequency (%)
충청북도 170
 
20.3%
청주시 49
 
5.8%
충주시 26
 
3.1%
제천시 18
 
2.1%
상당구 16
 
1.9%
서원구 12
 
1.4%
영동군 12
 
1.4%
괴산군 12
 
1.4%
흥덕구 12
 
1.4%
보은군 12
 
1.4%
Other values (382) 500
59.6%
2023-12-12T10:15:11.979905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
670
19.4%
청 240
 
7.0%
충 204
 
5.9%
도 174
 
5.0%
북 173
 
5.0%
로 134
 
3.9%
1 112
 
3.2%
시 97
 
2.8%
면 87
 
2.5%
주 83
 
2.4%
Other values (181) 1477
42.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2299
66.6%
Space Separator 670
 
19.4%
Decimal Number 473
 
13.7%
Dash Punctuation 9
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 240
 
10.4%
충 204
 
8.9%
도 174
 
7.6%
북 173
 
7.5%
로 134
 
5.8%
시 97
 
4.2%
면 87
 
3.8%
주 83
 
3.6%
군 80
 
3.5%
길 61
 
2.7%
Other values (169) 966
42.0%
Decimal Number
ValueCountFrequency (%)
1 112
23.7%
2 63
13.3%
3 49
10.4%
4 46
9.7%
5 43
 
9.1%
6 36
 
7.6%
7 35
 
7.4%
8 33
 
7.0%
0 28
 
5.9%
9 28
 
5.9%
Space Separator
ValueCountFrequency (%)
670
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2299
66.6%
Common 1152
33.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 240
 
10.4%
충 204
 
8.9%
도 174
 
7.6%
북 173
 
7.5%
로 134
 
5.8%
시 97
 
4.2%
면 87
 
3.8%
주 83
 
3.6%
군 80
 
3.5%
길 61
 
2.7%
Other values (169) 966
42.0%
Common
ValueCountFrequency (%)
670
58.2%
1 112
 
9.7%
2 63
 
5.5%
3 49
 
4.3%
4 46
 
4.0%
5 43
 
3.7%
6 36
 
3.1%
7 35
 
3.0%
8 33
 
2.9%
0 28
 
2.4%
Other values (2) 37
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2299
66.6%
ASCII 1152
33.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
670
58.2%
1 112
 
9.7%
2 63
 
5.5%
3 49
 
4.3%
4 46
 
4.0%
5 43
 
3.7%
6 36
 
3.1%
7 35
 
3.0%
8 33
 
2.9%
0 28
 
2.4%
Other values (2) 37
 
3.2%
Hangul
ValueCountFrequency (%)
청 240
 
10.4%
충 204
 
8.9%
도 174
 
7.6%
북 173
 
7.5%
로 134
 
5.8%
시 97
 
4.2%
면 87
 
3.8%
주 83
 
3.6%
군 80
 
3.5%
길 61
 
2.7%
Other values (169) 966
42.0%

Missing values

2023-12-12T10:15:08.718136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:15:08.851887image/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충청북도충북도청043-220-2114충청북도 충청북도 청주시 상당구 상당로 82
1청주시청주시청043-201-2114충청북도 청주시 상당구 상당로 155
2청주시상당구청043-201-5114충청북도 청주시 상당구 상당로 69번길 38
3청주시낭성면043-201-5502충청북도 청주시 상당구 낭성면 낭성시내길 21
4청주시미원면043-201-5552충청북도 청주시 상당구 미원면 단재로 2472
5청주시가덕면043-201-5602충청북도 청주시 상당구 가덕면 보청대로 4646
6청주시남일면043-201-5652충청북도 청주시 상당구 남일면 단재로 501
7청주시문의면043-201-5702충청북도 청주시 상당구 문의면 문의시내1길 8-15
8청주시중앙동043-201-5752충청북도 청주시 상당구 교서로32번길 31
9청주시성안동043-201-5782충청북도 청주시 상당구 대성로 72
지역기관명전화번호주소
159음성군감곡면043-881-3000충청북도 음성군 감곡면 음성로 2652
160단양군단양군청043-420-3114충청북도 단양군 단양읍 중앙1로 10
161단양군단양읍043-420-3501충청북도 단양군 단양읍 중앙1로 35
162단양군적성면043-423-7730충청북도 단양군 적성면 금수산로 957
163단양군매포읍043-420-3602충청북도 단양군 매포읍 평동14길 12
164단양군가곡면043-420-3801충청북도 단양군 가곡면 남한강로 550
165단양군단성면043-420-3701충청북도 단양군 단성면 충혼로 16
166단양군대강면043-420-3751충청북도 단양군 대강면 대강로 74
167단양군어상천면043-420-3901충청북도 단양군 어상천면 어상천로 928
168단양군영춘면043-420-3851충청북도 단양군 영춘면 영춘면 온달평강3로 9