Overview

Dataset statistics

Number of variables9
Number of observations355
Missing cells1775
Missing cells (%)55.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory27.2 KiB
Average record size in memory78.4 B

Variable types

Numeric1
Text2
Categorical1
Unsupported5

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 355 (100.0%) missing valuesMissing
Unnamed: 5 has 355 (100.0%) missing valuesMissing
Unnamed: 6 has 355 (100.0%) missing valuesMissing
Unnamed: 7 has 355 (100.0%) missing valuesMissing
Unnamed: 8 has 355 (100.0%) missing valuesMissing
연번 has unique valuesUnique
전화번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-09 21:35:15.748890
Analysis finished2024-01-09 21:35:16.203210
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct355
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean178
Minimum1
Maximum355
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.2 KiB
2024-01-10T06:35:16.261300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile18.7
Q189.5
median178
Q3266.5
95-th percentile337.3
Maximum355
Range354
Interquartile range (IQR)177

Descriptive statistics

Standard deviation102.62391
Coefficient of variation (CV)0.57653881
Kurtosis-1.2
Mean178
Median Absolute Deviation (MAD)89
Skewness0
Sum63190
Variance10531.667
MonotonicityStrictly increasing
2024-01-10T06:35:16.400637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
224 1
 
0.3%
244 1
 
0.3%
243 1
 
0.3%
242 1
 
0.3%
241 1
 
0.3%
240 1
 
0.3%
239 1
 
0.3%
238 1
 
0.3%
237 1
 
0.3%
Other values (345) 345
97.2%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
355 1
0.3%
354 1
0.3%
353 1
0.3%
352 1
0.3%
351 1
0.3%
350 1
0.3%
349 1
0.3%
348 1
0.3%
347 1
0.3%
346 1
0.3%

시설명
Text

Distinct348
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2024-01-10T06:35:16.592102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length9.8422535
Min length6

Characters and Unicode

Total characters3494
Distinct characters187
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

Unique342 ?
Unique (%)96.3%

Sample

1st row수부1리 마을회관
2nd row수부2리 마을회관
3rd row수부3리 마을회관
4th row성동1리 마을회관
5th row성동2,3리 노인회관
ValueCountFrequency (%)
마을회관 191
33.8%
노인회관 11
 
1.9%
창동1리 3
 
0.5%
녹문마을(노인)회관 3
 
0.5%
도흥리마을회관 2
 
0.4%
성주5리마을회관 2
 
0.4%
노천1리 2
 
0.4%
마을(노인)회관 2
 
0.4%
복지회관 2
 
0.4%
원산1리(선촌 2
 
0.4%
Other values (338) 345
61.1%
2024-01-10T06:35:16.874193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
관 364
 
10.4%
회 356
 
10.2%
마 342
 
9.8%
을 339
 
9.7%
리 244
 
7.0%
211
 
6.0%
1 126
 
3.6%
2 112
 
3.2%
) 101
 
2.9%
( 101
 
2.9%
Other values (177) 1198
34.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2728
78.1%
Decimal Number 345
 
9.9%
Space Separator 211
 
6.0%
Close Punctuation 101
 
2.9%
Open Punctuation 101
 
2.9%
Other Punctuation 8
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
관 364
13.3%
회 356
13.0%
마 342
12.5%
을 339
12.4%
리 244
 
8.9%
통 82
 
3.0%
대 58
 
2.1%
천 52
 
1.9%
신 34
 
1.2%
노 34
 
1.2%
Other values (163) 823
30.2%
Decimal Number
ValueCountFrequency (%)
1 126
36.5%
2 112
32.5%
3 42
 
12.2%
4 16
 
4.6%
5 10
 
2.9%
6 9
 
2.6%
8 8
 
2.3%
9 8
 
2.3%
7 8
 
2.3%
0 6
 
1.7%
Space Separator
ValueCountFrequency (%)
211
100.0%
Close Punctuation
ValueCountFrequency (%)
) 101
100.0%
Open Punctuation
ValueCountFrequency (%)
( 101
100.0%
Other Punctuation
ValueCountFrequency (%)
, 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2728
78.1%
Common 766
 
21.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
관 364
13.3%
회 356
13.0%
마 342
12.5%
을 339
12.4%
리 244
 
8.9%
통 82
 
3.0%
대 58
 
2.1%
천 52
 
1.9%
신 34
 
1.2%
노 34
 
1.2%
Other values (163) 823
30.2%
Common
ValueCountFrequency (%)
211
27.5%
1 126
16.4%
2 112
14.6%
) 101
13.2%
( 101
13.2%
3 42
 
5.5%
4 16
 
2.1%
5 10
 
1.3%
6 9
 
1.2%
, 8
 
1.0%
Other values (4) 30
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2728
78.1%
ASCII 766
 
21.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
관 364
13.3%
회 356
13.0%
마 342
12.5%
을 339
12.4%
리 244
 
8.9%
통 82
 
3.0%
대 58
 
2.1%
천 52
 
1.9%
신 34
 
1.2%
노 34
 
1.2%
Other values (163) 823
30.2%
ASCII
ValueCountFrequency (%)
211
27.5%
1 126
16.4%
2 112
14.6%
) 101
13.2%
( 101
13.2%
3 42
 
5.5%
4 16
 
2.1%
5 10
 
1.3%
6 9
 
1.2%
, 8
 
1.0%
Other values (4) 30
 
3.9%

종류
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
마을회관
355 

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

Length

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

Common Values (Plot)

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

전화번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing355
Missing (%)100.0%
Memory size3.2 KiB

시설소재지 주소
Text

Distinct352
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2024-01-10T06:35:17.327945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length58
Mean length19.211268
Min length15

Characters and Unicode

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

Unique

Unique350 ?
Unique (%)98.6%

Sample

1st row충청남도 보령시 수부리 297-3
2nd row충청남도 보령시 수부리 805-2
3rd row충청남도 보령시 수부리 586
4th row충청남도 보령시 성동리 199-1
5th row충청남도 보령시 성동리 781-3
ValueCountFrequency (%)
보령시 355
23.1%
충청남도 353
23.0%
외 54
 
3.5%
1필지 42
 
2.7%
대천동 30
 
2.0%
명천동 15
 
1.0%
죽정동 11
 
0.7%
신흑동 10
 
0.7%
2필지 9
 
0.6%
성주리 9
 
0.6%
Other values (463) 650
42.3%
2024-01-10T06:35:17.755321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1316
19.3%
도 375
 
5.5%
남 360
 
5.3%
시 360
 
5.3%
보 359
 
5.3%
령 357
 
5.2%
청 356
 
5.2%
충 355
 
5.2%
1 296
 
4.3%
- 280
 
4.1%
Other values (116) 2406
35.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3764
55.2%
Decimal Number 1459
 
21.4%
Space Separator 1316
 
19.3%
Dash Punctuation 280
 
4.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 375
10.0%
남 360
9.6%
시 360
9.6%
보 359
9.5%
령 357
9.5%
청 356
9.5%
충 355
9.4%
리 265
 
7.0%
동 115
 
3.1%
외 56
 
1.5%
Other values (103) 806
21.4%
Decimal Number
ValueCountFrequency (%)
1 296
20.3%
2 201
13.8%
3 180
12.3%
5 148
10.1%
4 146
10.0%
6 113
 
7.7%
7 109
 
7.5%
0 96
 
6.6%
8 90
 
6.2%
9 80
 
5.5%
Space Separator
ValueCountFrequency (%)
1316
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 280
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3764
55.2%
Common 3055
44.8%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 375
10.0%
남 360
9.6%
시 360
9.6%
보 359
9.5%
령 357
9.5%
청 356
9.5%
충 355
9.4%
리 265
 
7.0%
동 115
 
3.1%
외 56
 
1.5%
Other values (103) 806
21.4%
Common
ValueCountFrequency (%)
1316
43.1%
1 296
 
9.7%
- 280
 
9.2%
2 201
 
6.6%
3 180
 
5.9%
5 148
 
4.8%
4 146
 
4.8%
6 113
 
3.7%
7 109
 
3.6%
0 96
 
3.1%
Other values (2) 170
 
5.6%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3764
55.2%
ASCII 3056
44.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1316
43.1%
1 296
 
9.7%
- 280
 
9.2%
2 201
 
6.6%
3 180
 
5.9%
5 148
 
4.8%
4 146
 
4.8%
6 113
 
3.7%
7 109
 
3.6%
0 96
 
3.1%
Other values (3) 171
 
5.6%
Hangul
ValueCountFrequency (%)
도 375
10.0%
남 360
9.6%
시 360
9.6%
보 359
9.5%
령 357
9.5%
청 356
9.5%
충 355
9.4%
리 265
 
7.0%
동 115
 
3.1%
외 56
 
1.5%
Other values (103) 806
21.4%

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing355
Missing (%)100.0%
Memory size3.2 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing355
Missing (%)100.0%
Memory size3.2 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing355
Missing (%)100.0%
Memory size3.2 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing355
Missing (%)100.0%
Memory size3.2 KiB

Interactions

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

Missing values

2024-01-10T06:35:16.064820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:35:16.163707image/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

연번시설명종류전화번호시설소재지 주소Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8
01수부1리 마을회관마을회관<NA>충청남도 보령시 수부리 297-3<NA><NA><NA><NA>
12수부2리 마을회관마을회관<NA>충청남도 보령시 수부리 805-2<NA><NA><NA><NA>
23수부3리 마을회관마을회관<NA>충청남도 보령시 수부리 586<NA><NA><NA><NA>
34성동1리 마을회관마을회관<NA>충청남도 보령시 성동리 199-1<NA><NA><NA><NA>
45성동2,3리 노인회관마을회관<NA>충청남도 보령시 성동리 781-3<NA><NA><NA><NA>
56대창4리 마을회관마을회관<NA>충청남도 보령시 대창리 240-1 외 3필지<NA><NA><NA><NA>
67대창5리 마을회관마을회관<NA>충청남도 보령시 대창리 483<NA><NA><NA><NA>
78대창6리 마을회관마을회관<NA>충청남도 보령시 대창리 453-1<NA><NA><NA><NA>
89대창6리 노인회관마을회관<NA>충청남도 보령시 대창리 169-3<NA><NA><NA><NA>
910대창9리 노인회관마을회관<NA>충청남도 보령시 대창리 685-1 외 2필지<NA><NA><NA><NA>
연번시설명종류전화번호시설소재지 주소Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8
345346신흑1통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 126-7<NA><NA><NA><NA>
346347신흑2통마을회관마을회관<NA>충청남도 보령시 신흑동 245-1<NA><NA><NA><NA>
347348신흑3통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 2230-1<NA><NA><NA><NA>
348349신흑3통1반마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 900-31<NA><NA><NA><NA>
349350신흑4통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 775-13<NA><NA><NA><NA>
350351신흑6통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 1440-48<NA><NA><NA><NA>
351352신흑7통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 2240-7<NA><NA><NA><NA>
352353신흑8통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 911-107<NA><NA><NA><NA>
353354신흑9통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 1634-6<NA><NA><NA><NA>
354355신흑10통마을(노인)회관마을회관<NA>충청남도 보령시 신흑동 1457-4<NA><NA><NA><NA>