Overview

Dataset statistics

Number of variables7
Number of observations209
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.0 KiB
Average record size in memory58.6 B

Variable types

Numeric2
Categorical2
Text3

Dataset

Description충청남도 시군 읍면동사무소 정보를 시도, 시군구, 우편번호, 주소, 전화번호로 표현하여 데이터로 개방하고자 합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=405&beforeMenuCd=DOM_000000201001001000&publicdatapk=15032211

Alerts

시도 has constant value ""Constant
연번 is highly overall correlated with 시군구High correlation
우편번호 is highly overall correlated with 시군구High correlation
시군구 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
연번 has unique valuesUnique
읍면동 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:17:10.071089
Analysis finished2024-01-09 22:17:10.964742
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct209
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean105
Minimum1
Maximum209
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2024-01-10T07:17:11.024669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.4
Q153
median105
Q3157
95-th percentile198.6
Maximum209
Range208
Interquartile range (IQR)104

Descriptive statistics

Standard deviation60.477268
Coefficient of variation (CV)0.57597399
Kurtosis-1.2
Mean105
Median Absolute Deviation (MAD)52
Skewness0
Sum21945
Variance3657.5
MonotonicityStrictly increasing
2024-01-10T07:17:11.129403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
158 1
 
0.5%
134 1
 
0.5%
135 1
 
0.5%
136 1
 
0.5%
137 1
 
0.5%
138 1
 
0.5%
139 1
 
0.5%
140 1
 
0.5%
141 1
 
0.5%
Other values (199) 199
95.2%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
209 1
0.5%
208 1
0.5%
207 1
0.5%
206 1
0.5%
205 1
0.5%
204 1
0.5%
203 1
0.5%
202 1
0.5%
201 1
0.5%
200 1
0.5%

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
충청남도
209 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
충청남도 209
100.0%

Length

2024-01-10T07:17:11.221066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:17:11.292399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청남도 209
100.0%

시군구
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
천안시
31 
공주시
17 
아산시
17 
보령시
16 
부여군
16 
Other values (10)
112 

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 (%)
천안시 31
14.8%
공주시 17
 
8.1%
아산시 17
 
8.1%
보령시 16
 
7.7%
부여군 16
 
7.7%
서산시 15
 
7.2%
논산시 15
 
7.2%
당진시 14
 
6.7%
서천군 13
 
6.2%
예산군 12
 
5.7%
Other values (5) 43
20.6%

Length

2024-01-10T07:17:11.378152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
천안시 31
14.8%
공주시 17
 
8.1%
아산시 17
 
8.1%
보령시 16
 
7.7%
부여군 16
 
7.7%
서산시 15
 
7.2%
논산시 15
 
7.2%
당진시 14
 
6.7%
서천군 13
 
6.2%
예산군 12
 
5.7%
Other values (5) 43
20.6%

읍면동
Text

UNIQUE 

Distinct209
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-01-10T07:17:11.577399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length7.7129187
Min length4

Characters and Unicode

Total characters1612
Distinct characters152
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

Unique209 ?
Unique (%)100.0%

Sample

1st row천안시청
2nd row목천읍행정복지센터
3rd row풍세면행정복지센터
4th row광덕면행정복지센터
5th row북면행정복지센터
ValueCountFrequency (%)
행정복지센터 6
 
2.7%
행정복지센터주민센터 2
 
0.9%
행정복지센터사무소 2
 
0.9%
천안시청 1
 
0.5%
군북면사무소 1
 
0.5%
남일면사무소 1
 
0.5%
남이면사무소 1
 
0.5%
진산면사무소 1
 
0.5%
복수면사무소 1
 
0.5%
추부면사무소 1
 
0.5%
Other values (202) 202
92.2%
2024-01-10T07:17:11.866316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
면 138
 
8.6%
센 116
 
7.2%
터 116
 
7.2%
정 107
 
6.6%
지 104
 
6.5%
복 102
 
6.3%
행 101
 
6.3%
소 97
 
6.0%
사 97
 
6.0%
무 96
 
6.0%
Other values (142) 538
33.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1577
97.8%
Decimal Number 25
 
1.6%
Space Separator 10
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
면 138
 
8.8%
센 116
 
7.4%
터 116
 
7.4%
정 107
 
6.8%
지 104
 
6.6%
복 102
 
6.5%
행 101
 
6.4%
소 97
 
6.2%
사 97
 
6.2%
무 96
 
6.1%
Other values (135) 503
31.9%
Decimal Number
ValueCountFrequency (%)
1 8
32.0%
2 8
32.0%
3 4
16.0%
5 2
 
8.0%
4 2
 
8.0%
6 1
 
4.0%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1577
97.8%
Common 35
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
면 138
 
8.8%
센 116
 
7.4%
터 116
 
7.4%
정 107
 
6.8%
지 104
 
6.6%
복 102
 
6.5%
행 101
 
6.4%
소 97
 
6.2%
사 97
 
6.2%
무 96
 
6.1%
Other values (135) 503
31.9%
Common
ValueCountFrequency (%)
10
28.6%
1 8
22.9%
2 8
22.9%
3 4
 
11.4%
5 2
 
5.7%
4 2
 
5.7%
6 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1577
97.8%
ASCII 35
 
2.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
면 138
 
8.8%
센 116
 
7.4%
터 116
 
7.4%
정 107
 
6.8%
지 104
 
6.6%
복 102
 
6.5%
행 101
 
6.4%
소 97
 
6.2%
사 97
 
6.2%
무 96
 
6.1%
Other values (135) 503
31.9%
ASCII
ValueCountFrequency (%)
10
28.6%
1 8
22.9%
2 8
22.9%
3 4
 
11.4%
5 2
 
5.7%
4 2
 
5.7%
6 1
 
2.9%

우편번호
Real number (ℝ)

HIGH CORRELATION 

Distinct207
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32407.488
Minimum31015
Maximum35718
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2024-01-10T07:17:11.979555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum31015
5-th percentile31137.2
Q131754
median32446
Q333167
95-th percentile33613.8
Maximum35718
Range4703
Interquartile range (IQR)1413

Descriptive statistics

Standard deviation832.68146
Coefficient of variation (CV)0.025694107
Kurtosis-0.22944476
Mean32407.488
Median Absolute Deviation (MAD)705
Skewness0.1628659
Sum6773165
Variance693358.41
MonotonicityNot monotonic
2024-01-10T07:17:12.094635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
32954 2
 
1.0%
31125 2
 
1.0%
31514 1
 
0.5%
33200 1
 
0.5%
32751 1
 
0.5%
32704 1
 
0.5%
32703 1
 
0.5%
32712 1
 
0.5%
33167 1
 
0.5%
33123 1
 
0.5%
Other values (197) 197
94.3%
ValueCountFrequency (%)
31015 1
0.5%
31037 1
0.5%
31045 1
0.5%
31055 1
0.5%
31080 1
0.5%
31100 1
0.5%
31125 2
1.0%
31128 1
0.5%
31131 1
0.5%
31134 1
0.5%
ValueCountFrequency (%)
35718 1
0.5%
33673 1
0.5%
33654 1
0.5%
33643 1
0.5%
33630 1
0.5%
33628 1
0.5%
33624 1
0.5%
33622 1
0.5%
33620 1
0.5%
33617 1
0.5%

주소
Text

Distinct208
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-01-10T07:17:12.356942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length25
Mean length20.401914
Min length14

Characters and Unicode

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

Unique

Unique207 ?
Unique (%)99.0%

Sample

1st row충청남도 천안시 서북구 번영로 156
2nd row충청남도 천안시 동남구 목천읍 서리1길 41-7
3rd row충청남도 천안시 동남구 풍세면 상정1길 3
4th row충청남도 천안시 동남구 광덕면 신흥리3길 33
5th row충청남도 천안시 동남구 북면 위례성로 724
ValueCountFrequency (%)
충청남도 209
 
20.2%
천안시 31
 
3.0%
공주시 17
 
1.6%
아산시 17
 
1.6%
동남구 17
 
1.6%
보령시 16
 
1.5%
부여군 16
 
1.5%
서산시 15
 
1.4%
서북구 15
 
1.4%
논산시 15
 
1.4%
Other values (523) 669
64.5%
2024-01-10T07:17:12.739122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
833
19.5%
남 242
 
5.7%
청 229
 
5.4%
충 217
 
5.1%
도 215
 
5.0%
로 153
 
3.6%
면 144
 
3.4%
시 136
 
3.2%
1 122
 
2.9%
산 109
 
2.6%
Other values (199) 1864
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2792
65.5%
Space Separator 833
 
19.5%
Decimal Number 611
 
14.3%
Dash Punctuation 27
 
0.6%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 242
 
8.7%
청 229
 
8.2%
충 217
 
7.8%
도 215
 
7.7%
로 153
 
5.5%
면 144
 
5.2%
시 136
 
4.9%
산 109
 
3.9%
군 81
 
2.9%
길 72
 
2.6%
Other values (186) 1194
42.8%
Decimal Number
ValueCountFrequency (%)
1 122
20.0%
3 73
11.9%
2 71
11.6%
4 63
10.3%
7 56
9.2%
5 56
9.2%
9 51
8.3%
6 49
8.0%
8 40
 
6.5%
0 30
 
4.9%
Space Separator
ValueCountFrequency (%)
833
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 27
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2792
65.5%
Common 1472
34.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 242
 
8.7%
청 229
 
8.2%
충 217
 
7.8%
도 215
 
7.7%
로 153
 
5.5%
면 144
 
5.2%
시 136
 
4.9%
산 109
 
3.9%
군 81
 
2.9%
길 72
 
2.6%
Other values (186) 1194
42.8%
Common
ValueCountFrequency (%)
833
56.6%
1 122
 
8.3%
3 73
 
5.0%
2 71
 
4.8%
4 63
 
4.3%
7 56
 
3.8%
5 56
 
3.8%
9 51
 
3.5%
6 49
 
3.3%
8 40
 
2.7%
Other values (3) 58
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2792
65.5%
ASCII 1472
34.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
833
56.6%
1 122
 
8.3%
3 73
 
5.0%
2 71
 
4.8%
4 63
 
4.3%
7 56
 
3.8%
5 56
 
3.8%
9 51
 
3.5%
6 49
 
3.3%
8 40
 
2.7%
Other values (3) 58
 
3.9%
Hangul
ValueCountFrequency (%)
남 242
 
8.7%
청 229
 
8.2%
충 217
 
7.8%
도 215
 
7.7%
로 153
 
5.5%
면 144
 
5.2%
시 136
 
4.9%
산 109
 
3.9%
군 81
 
2.9%
길 72
 
2.6%
Other values (186) 1194
42.8%

전화번호
Text

UNIQUE 

Distinct209
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-01-10T07:17:12.949311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.961722
Min length7

Characters and Unicode

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

Unique209 ?
Unique (%)100.0%

Sample

1st row1422-36
2nd row041-521-4651
3rd row041-521-4681
4th row041-521-4701
5th row041-521-4729
ValueCountFrequency (%)
1422-36 1
 
0.5%
041-746-8797 1
 
0.5%
041-830-6453 1
 
0.5%
041-750-8453 1
 
0.5%
041-750-8506 1
 
0.5%
041-750-8553 1
 
0.5%
041-750-8605 1
 
0.5%
041-750-8653 1
 
0.5%
041-750-3107 1
 
0.5%
041-830-6302 1
 
0.5%
Other values (199) 199
95.2%
2024-01-10T07:17:13.252722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 416
16.6%
0 398
15.9%
4 365
14.6%
1 305
12.2%
3 214
8.6%
6 192
7.7%
5 151
 
6.0%
8 140
 
5.6%
2 117
 
4.7%
7 103
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2084
83.4%
Dash Punctuation 416
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 398
19.1%
4 365
17.5%
1 305
14.6%
3 214
10.3%
6 192
9.2%
5 151
 
7.2%
8 140
 
6.7%
2 117
 
5.6%
7 103
 
4.9%
9 99
 
4.8%
Dash Punctuation
ValueCountFrequency (%)
- 416
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2500
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 416
16.6%
0 398
15.9%
4 365
14.6%
1 305
12.2%
3 214
8.6%
6 192
7.7%
5 151
 
6.0%
8 140
 
5.6%
2 117
 
4.7%
7 103
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2500
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 416
16.6%
0 398
15.9%
4 365
14.6%
1 305
12.2%
3 214
8.6%
6 192
7.7%
5 151
 
6.0%
8 140
 
5.6%
2 117
 
4.7%
7 103
 
4.1%

Interactions

2024-01-10T07:17:10.703240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:17:10.584835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:17:10.759972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:17:10.642759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:17:13.333042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시군구우편번호
연번1.0000.9760.789
시군구0.9761.0000.955
우편번호0.7890.9551.000
2024-01-10T07:17:13.403890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번우편번호시군구
연번1.0000.4370.826
우편번호0.4371.0000.821
시군구0.8260.8211.000

Missing values

2024-01-10T07:17:10.839623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:17:10.929655image/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

연번시도시군구읍면동우편번호주소전화번호
01충청남도천안시천안시청31514충청남도 천안시 서북구 번영로 1561422-36
12충청남도천안시목천읍행정복지센터31231충청남도 천안시 동남구 목천읍 서리1길 41-7041-521-4651
23충청남도천안시풍세면행정복지센터31217충청남도 천안시 동남구 풍세면 상정1길 3041-521-4681
34충청남도천안시광덕면행정복지센터31221충청남도 천안시 동남구 광덕면 신흥리3길 33041-521-4701
45충청남도천안시북면행정복지센터31238충청남도 천안시 동남구 북면 위례성로 724041-521-4729
56충청남도천안시성남면행정복지센터31245충청남도 천안시 동남구 성남면 신사대화로 149041-521-4749
67충청남도천안시수신면행정복지센터31251충청남도 천안시 동남구 수신면 수신로 431041-521-4766
78충청남도천안시병천면행정복지센터31254충청남도 천안시 동남구 병천면 병천2로 57041-521-4781
89충청남도천안시동면행정복지센터31258충청남도 천안시 동남구 동면 동산1길 15041-521-4809
910충청남도천안시중앙동행정복지센터31131충청남도 천안시 동남구 원성천1길 17041-521-4821
연번시도시군구읍면동우편번호주소전화번호
199200충청남도예산군신암면행정복지센터32418충청남도 예산군 신암면 종경길 70041-339-8844
200201충청남도예산군오가면행정복지센터32425충청남도 예산군 오가면 오가중앙로 86-12041-339-8882
201202충청남도태안군태안읍행정복지센터32141충청남도 태안군 태안읍 백화로 54041-670-5502
202203충청남도태안군안면읍행정복지센터32164충청남도 태안군 안면읍 장터로 149041-670-5560
203204충청남도태안군고남면사무소32172충청남도 태안군 고남면 안면대로 4254-12041-670-5593
204205충청남도태안군남면사무소32154충청남도 태안군 남면 달산포로 311041-670-5135
205206충청남도태안군근흥면사무소32129충청남도 태안군 근흥면 근흥로 724041-670-5656
206207충청남도태안군소원면사무소32120충청남도 태안군 소원면 소근로 26-12041-670-5685
207208충청남도태안군원북면사무소32109충청남도 태안군 원북면 상리길 11041-670-5713
208209충청남도태안군이원면사무소32103충청남도 태안군 이원면 분지길 14041-670-5745