Overview

Dataset statistics

Number of variables5
Number of observations243
Missing cells243
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.1 KiB
Average record size in memory42.5 B

Variable types

Numeric1
Text2
Categorical1
Unsupported1

Dataset

Description충청남도 보령시 마을회관의 시설명, 도로명 주소, 지번 주소, 위도, 경도, 동수/층수, 건축면적, 연면적, 사용승인일, 소유자, 경로다겸용여부, 건축년도에 대한 데이터를 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=425&beforeMenuCd=DOM_000000201001001000&publicdatapk=15037749

Alerts

종류 has constant value ""Constant
전화번호 has 243 (100.0%) missing valuesMissing
연번 has unique valuesUnique
시설소재지 주소 has unique valuesUnique
전화번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-09 21:35:13.445733
Analysis finished2024-01-09 21:35:13.806624
Duration0.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct243
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean122
Minimum1
Maximum243
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2024-01-10T06:35:13.862269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile13.1
Q161.5
median122
Q3182.5
95-th percentile230.9
Maximum243
Range242
Interquartile range (IQR)121

Descriptive statistics

Standard deviation70.292247
Coefficient of variation (CV)0.57616596
Kurtosis-1.2
Mean122
Median Absolute Deviation (MAD)61
Skewness0
Sum29646
Variance4941
MonotonicityStrictly increasing
2024-01-10T06:35:13.969592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
154 1
 
0.4%
156 1
 
0.4%
157 1
 
0.4%
158 1
 
0.4%
159 1
 
0.4%
160 1
 
0.4%
161 1
 
0.4%
162 1
 
0.4%
163 1
 
0.4%
Other values (233) 233
95.9%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
243 1
0.4%
242 1
0.4%
241 1
0.4%
240 1
0.4%
239 1
0.4%
238 1
0.4%
237 1
0.4%
236 1
0.4%
235 1
0.4%
234 1
0.4%

시설명
Text

Distinct240
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-01-10T06:35:14.151294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length9.7201646
Min length5

Characters and Unicode

Total characters2362
Distinct characters177
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

Unique237 ?
Unique (%)97.5%

Sample

1st row수부1리 마을회관
2nd row수부2리 마을회관
3rd row수부3리 마을회관
4th row성동1리 마을회관
5th row성동2,3리 노인회관
ValueCountFrequency (%)
마을회관 146
37.0%
노인회관 4
 
1.0%
도흥리마을회관 2
 
0.5%
관산리 2
 
0.5%
성주5리마을회관 2
 
0.5%
원산1리(선촌 2
 
0.5%
금암4리마을회관 1
 
0.3%
신구2리마을회관 1
 
0.3%
주야2리(장자동)마을회관 1
 
0.3%
주야1리마을회관 1
 
0.3%
Other values (233) 233
59.0%
2024-01-10T06:35:14.426391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
관 246
 
10.4%
회 239
 
10.1%
마 233
 
9.9%
을 230
 
9.7%
리 188
 
8.0%
153
 
6.5%
2 80
 
3.4%
1 75
 
3.2%
) 71
 
3.0%
( 71
 
3.0%
Other values (167) 776
32.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1856
78.6%
Decimal Number 210
 
8.9%
Space Separator 153
 
6.5%
Close Punctuation 71
 
3.0%
Open Punctuation 71
 
3.0%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
관 246
13.3%
회 239
12.9%
마 233
12.6%
을 230
 
12.4%
리 188
 
10.1%
대 33
 
1.8%
통 33
 
1.8%
성 25
 
1.3%
동 24
 
1.3%
신 23
 
1.2%
Other values (154) 582
31.4%
Decimal Number
ValueCountFrequency (%)
2 80
38.1%
1 75
35.7%
3 27
 
12.9%
4 11
 
5.2%
5 6
 
2.9%
8 3
 
1.4%
7 3
 
1.4%
6 3
 
1.4%
9 2
 
1.0%
Space Separator
ValueCountFrequency (%)
153
100.0%
Close Punctuation
ValueCountFrequency (%)
) 71
100.0%
Open Punctuation
ValueCountFrequency (%)
( 71
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1856
78.6%
Common 506
 
21.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
관 246
13.3%
회 239
12.9%
마 233
12.6%
을 230
 
12.4%
리 188
 
10.1%
대 33
 
1.8%
통 33
 
1.8%
성 25
 
1.3%
동 24
 
1.3%
신 23
 
1.2%
Other values (154) 582
31.4%
Common
ValueCountFrequency (%)
153
30.2%
2 80
15.8%
1 75
14.8%
) 71
14.0%
( 71
14.0%
3 27
 
5.3%
4 11
 
2.2%
5 6
 
1.2%
8 3
 
0.6%
7 3
 
0.6%
Other values (3) 6
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1856
78.6%
ASCII 506
 
21.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
관 246
13.3%
회 239
12.9%
마 233
12.6%
을 230
 
12.4%
리 188
 
10.1%
대 33
 
1.8%
통 33
 
1.8%
성 25
 
1.3%
동 24
 
1.3%
신 23
 
1.2%
Other values (154) 582
31.4%
ASCII
ValueCountFrequency (%)
153
30.2%
2 80
15.8%
1 75
14.8%
) 71
14.0%
( 71
14.0%
3 27
 
5.3%
4 11
 
2.2%
5 6
 
1.2%
8 3
 
0.6%
7 3
 
0.6%
Other values (3) 6
 
1.2%

종류
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
마을회관
243 

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 (%)
마을회관 243
100.0%

Length

2024-01-10T06:35:14.532555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:35:14.597927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마을회관 243
100.0%

전화번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing243
Missing (%)100.0%
Memory size2.3 KiB

시설소재지 주소
Text

UNIQUE 

Distinct243
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-01-10T06:35:14.866826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length58
Mean length19.485597
Min length15

Characters and Unicode

Total characters4735
Distinct characters112
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

Unique243 ?
Unique (%)100.0%

Sample

1st row충청남도 보령시 수부리 297-3
2nd row충청남도 보령시 수부리 805-2
3rd row충청남도 보령시 수부리 586
4th row충청남도 보령시 성동리 199-1
5th row충청남도 보령시 성동리 781-3
ValueCountFrequency (%)
충청남도 243
22.8%
보령시 243
22.8%
외 46
 
4.3%
1필지 37
 
3.5%
대천동 15
 
1.4%
성주리 9
 
0.8%
2필지 7
 
0.7%
신흑동 5
 
0.5%
나원리 5
 
0.5%
주교리 5
 
0.5%
Other values (335) 450
42.3%
2024-01-10T06:35:15.260485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
955
20.2%
도 258
 
5.4%
남 246
 
5.2%
보 246
 
5.2%
시 246
 
5.2%
령 244
 
5.2%
청 244
 
5.2%
충 243
 
5.1%
리 209
 
4.4%
1 201
 
4.2%
Other values (102) 1643
34.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2583
54.6%
Decimal Number 997
 
21.1%
Space Separator 955
 
20.2%
Dash Punctuation 200
 
4.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 258
10.0%
남 246
9.5%
보 246
9.5%
시 246
9.5%
령 244
9.4%
청 244
9.4%
충 243
9.4%
리 209
 
8.1%
외 48
 
1.9%
지 48
 
1.9%
Other values (90) 551
21.3%
Decimal Number
ValueCountFrequency (%)
1 201
20.2%
2 141
14.1%
3 124
12.4%
5 108
10.8%
4 100
10.0%
6 79
 
7.9%
7 72
 
7.2%
0 62
 
6.2%
8 57
 
5.7%
9 53
 
5.3%
Space Separator
ValueCountFrequency (%)
955
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 200
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2583
54.6%
Common 2152
45.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 258
10.0%
남 246
9.5%
보 246
9.5%
시 246
9.5%
령 244
9.4%
청 244
9.4%
충 243
9.4%
리 209
 
8.1%
외 48
 
1.9%
지 48
 
1.9%
Other values (90) 551
21.3%
Common
ValueCountFrequency (%)
955
44.4%
1 201
 
9.3%
- 200
 
9.3%
2 141
 
6.6%
3 124
 
5.8%
5 108
 
5.0%
4 100
 
4.6%
6 79
 
3.7%
7 72
 
3.3%
0 62
 
2.9%
Other values (2) 110
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2583
54.6%
ASCII 2152
45.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
955
44.4%
1 201
 
9.3%
- 200
 
9.3%
2 141
 
6.6%
3 124
 
5.8%
5 108
 
5.0%
4 100
 
4.6%
6 79
 
3.7%
7 72
 
3.3%
0 62
 
2.9%
Other values (2) 110
 
5.1%
Hangul
ValueCountFrequency (%)
도 258
10.0%
남 246
9.5%
보 246
9.5%
시 246
9.5%
령 244
9.4%
청 244
9.4%
충 243
9.4%
리 209
 
8.1%
외 48
 
1.9%
지 48
 
1.9%
Other values (90) 551
21.3%

Interactions

2024-01-10T06:35:13.615826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-01-10T06:35:13.701185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:35:13.777670image/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수부1리 마을회관마을회관<NA>충청남도 보령시 수부리 297-3
12수부2리 마을회관마을회관<NA>충청남도 보령시 수부리 805-2
23수부3리 마을회관마을회관<NA>충청남도 보령시 수부리 586
34성동1리 마을회관마을회관<NA>충청남도 보령시 성동리 199-1
45성동2,3리 노인회관마을회관<NA>충청남도 보령시 성동리 781-3
56대창4리 마을회관마을회관<NA>충청남도 보령시 대창리 240-1 외 3필지
67대창5리 마을회관마을회관<NA>충청남도 보령시 대창리 483
78대창6리 마을회관마을회관<NA>충청남도 보령시 대창리 453-1
89대창9리 노인회관마을회관<NA>충청남도 보령시 대창리 685-1 외 2필지
910대천1리 마을회관마을회관<NA>충청남도 보령시 대천리 138-14
연번시설명종류전화번호시설소재지 주소
233234남곡1통탑골마을(노인)회관마을회관<NA>충청남도 보령시 남곡동 251-1 외 1필지
234235남곡3통마을(노인)회관마을회관<NA>충청남도 보령시 남곡동 1030-2
235236요암1통1반마을(노인)회관마을회관<NA>충청남도 보령시 요암동 141-3
236237요암2통마을(노인)회관마을회관<NA>충청남도 보령시 요암동 868-3 외 1필지
237238요암3통마을(노인)회관마을회관<NA>충청남도 보령시 요암동 504-2
238239신흑1통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 126-7
239240신흑2통마을회관마을회관<NA>충청남도 보령시 신흑동 245-1
240241신흑3통1반마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 900-31
241242신흑4통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 775-13
242243신흑7통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 2240-7