Overview

Dataset statistics

Number of variables5
Number of observations184
Missing cells52
Missing cells (%)5.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.7 KiB
Average record size in memory42.7 B

Variable types

Text2
Numeric2
Categorical1

Dataset

Description충청남도 청양군 소재 마을회관에 대한 운영현황 데이터로 마을회관명, 소재지주소, 건축연도, 면적을 나타내고 있습니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=429&beforeMenuCd=DOM_000000201001001000&publicdatapk=15029932

Alerts

데이터기준일자 has constant value ""Constant
건축년도 has 26 (14.1%) missing valuesMissing
면적(제곱미터) has 26 (14.1%) missing valuesMissing
마을회관명 has unique valuesUnique

Reproduction

Analysis started2024-01-09 19:59:06.405482
Analysis finished2024-01-09 19:59:07.624404
Duration1.22 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

마을회관명
Text

UNIQUE 

Distinct184
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-01-10T04:59:07.943567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length8.701087
Min length8

Characters and Unicode

Total characters1601
Distinct characters115
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

Unique184 ?
Unique (%)100.0%

Sample

1st row읍내1리 마을회관
2nd row읍내2리 마을회관
3rd row읍내3리 마을회관
4th row읍내4리 마을회관
5th row읍내5리 마을회관
ValueCountFrequency (%)
마을회관 184
49.7%
아산리 2
 
0.5%
미당2리 1
 
0.3%
용마1리 1
 
0.3%
적곡리 1
 
0.3%
도림리 1
 
0.3%
락지리 1
 
0.3%
지천리 1
 
0.3%
죽림리 1
 
0.3%
화산1리 1
 
0.3%
Other values (176) 176
47.6%
2024-01-10T04:59:08.521812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
188
11.7%
186
11.6%
186
11.6%
184
11.5%
184
11.5%
184
11.5%
1 57
 
3.6%
2 57
 
3.6%
15
 
0.9%
14
 
0.9%
Other values (105) 346
21.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1293
80.8%
Space Separator 186
 
11.6%
Decimal Number 122
 
7.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
188
14.5%
186
14.4%
184
14.2%
184
14.2%
184
14.2%
15
 
1.2%
14
 
1.1%
12
 
0.9%
12
 
0.9%
11
 
0.9%
Other values (99) 303
23.4%
Decimal Number
ValueCountFrequency (%)
1 57
46.7%
2 57
46.7%
3 6
 
4.9%
4 1
 
0.8%
5 1
 
0.8%
Space Separator
ValueCountFrequency (%)
186
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1293
80.8%
Common 308
 
19.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
188
14.5%
186
14.4%
184
14.2%
184
14.2%
184
14.2%
15
 
1.2%
14
 
1.1%
12
 
0.9%
12
 
0.9%
11
 
0.9%
Other values (99) 303
23.4%
Common
ValueCountFrequency (%)
186
60.4%
1 57
 
18.5%
2 57
 
18.5%
3 6
 
1.9%
4 1
 
0.3%
5 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1293
80.8%
ASCII 308
 
19.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
188
14.5%
186
14.4%
184
14.2%
184
14.2%
184
14.2%
15
 
1.2%
14
 
1.1%
12
 
0.9%
12
 
0.9%
11
 
0.9%
Other values (99) 303
23.4%
ASCII
ValueCountFrequency (%)
186
60.4%
1 57
 
18.5%
2 57
 
18.5%
3 6
 
1.9%
4 1
 
0.3%
5 1
 
0.3%
Distinct183
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-01-10T04:59:09.014583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length18
Mean length12.570652
Min length9

Characters and Unicode

Total characters2313
Distinct characters193
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

Unique182 ?
Unique (%)98.9%

Sample

1st row청양군 청양읍 칠갑산로 11길 9
2nd row청양군 청양읍 칠갑산로 7길 16-10
3rd row청양군 청양읍 중앙로4길 21
4th row청양군 청양읍 중앙로3길 23
5th row청양군 청양읍 중앙로 155-4
ValueCountFrequency (%)
남양면 27
 
4.7%
청양군 26
 
4.5%
청양읍 26
 
4.5%
정산면 21
 
3.6%
청남면 18
 
3.1%
장평면 17
 
2.9%
대치면 16
 
2.8%
화성면 15
 
2.6%
운곡면 15
 
2.6%
목면 14
 
2.4%
Other values (307) 385
66.4%
2024-01-10T04:59:09.730441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
396
 
17.1%
159
 
6.9%
133
 
5.8%
1 121
 
5.2%
2 85
 
3.7%
82
 
3.5%
81
 
3.5%
- 79
 
3.4%
3 60
 
2.6%
5 57
 
2.5%
Other values (183) 1060
45.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1264
54.6%
Decimal Number 572
24.7%
Space Separator 396
 
17.1%
Dash Punctuation 79
 
3.4%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
159
 
12.6%
133
 
10.5%
82
 
6.5%
81
 
6.4%
54
 
4.3%
45
 
3.6%
42
 
3.3%
26
 
2.1%
26
 
2.1%
24
 
1.9%
Other values (169) 592
46.8%
Decimal Number
ValueCountFrequency (%)
1 121
21.2%
2 85
14.9%
3 60
10.5%
5 57
10.0%
4 55
9.6%
7 48
 
8.4%
8 45
 
7.9%
9 35
 
6.1%
0 33
 
5.8%
6 33
 
5.8%
Space Separator
ValueCountFrequency (%)
396
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 79
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1264
54.6%
Common 1049
45.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
159
 
12.6%
133
 
10.5%
82
 
6.5%
81
 
6.4%
54
 
4.3%
45
 
3.6%
42
 
3.3%
26
 
2.1%
26
 
2.1%
24
 
1.9%
Other values (169) 592
46.8%
Common
ValueCountFrequency (%)
396
37.8%
1 121
 
11.5%
2 85
 
8.1%
- 79
 
7.5%
3 60
 
5.7%
5 57
 
5.4%
4 55
 
5.2%
7 48
 
4.6%
8 45
 
4.3%
9 35
 
3.3%
Other values (4) 68
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1264
54.6%
ASCII 1049
45.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
396
37.8%
1 121
 
11.5%
2 85
 
8.1%
- 79
 
7.5%
3 60
 
5.7%
5 57
 
5.4%
4 55
 
5.2%
7 48
 
4.6%
8 45
 
4.3%
9 35
 
3.3%
Other values (4) 68
 
6.5%
Hangul
ValueCountFrequency (%)
159
 
12.6%
133
 
10.5%
82
 
6.5%
81
 
6.4%
54
 
4.3%
45
 
3.6%
42
 
3.3%
26
 
2.1%
26
 
2.1%
24
 
1.9%
Other values (169) 592
46.8%

건축년도
Real number (ℝ)

MISSING 

Distinct28
Distinct (%)17.7%
Missing26
Missing (%)14.1%
Infinite0
Infinite (%)0.0%
Mean1998.3418
Minimum1966
Maximum2018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2024-01-10T04:59:09.963696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1966
5-th percentile1991.4
Q11995
median1999
Q32001
95-th percentile2007.15
Maximum2018
Range52
Interquartile range (IQR)6

Descriptive statistics

Standard deviation6.9710705
Coefficient of variation (CV)0.0034884275
Kurtosis6.0152808
Mean1998.3418
Median Absolute Deviation (MAD)3
Skewness-1.4566531
Sum315738
Variance48.595824
MonotonicityNot monotonic
2024-01-10T04:59:10.184837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
1995 21
11.4%
2001 20
10.9%
1999 16
8.7%
1996 14
7.6%
1998 13
 
7.1%
2002 12
 
6.5%
2000 10
 
5.4%
2004 7
 
3.8%
1994 6
 
3.3%
1997 5
 
2.7%
Other values (18) 34
18.5%
(Missing) 26
14.1%
ValueCountFrequency (%)
1966 1
 
0.5%
1973 1
 
0.5%
1974 2
 
1.1%
1976 1
 
0.5%
1978 1
 
0.5%
1980 1
 
0.5%
1988 1
 
0.5%
1992 4
2.2%
1993 2
 
1.1%
1994 6
3.3%
ValueCountFrequency (%)
2018 1
 
0.5%
2017 1
 
0.5%
2014 2
 
1.1%
2009 1
 
0.5%
2008 3
1.6%
2007 2
 
1.1%
2006 3
1.6%
2005 4
2.2%
2004 7
3.8%
2003 3
1.6%

면적(제곱미터)
Real number (ℝ)

MISSING 

Distinct150
Distinct (%)94.9%
Missing26
Missing (%)14.1%
Infinite0
Infinite (%)0.0%
Mean122.54785
Minimum60.48
Maximum261.64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2024-01-10T04:59:10.357920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum60.48
5-th percentile76.869
Q198.615
median107.82
Q3145.5175
95-th percentile192.577
Maximum261.64
Range201.16
Interquartile range (IQR)46.9025

Descriptive statistics

Standard deviation37.106457
Coefficient of variation (CV)0.30279158
Kurtosis0.55674627
Mean122.54785
Median Absolute Deviation (MAD)16.335
Skewness0.9969547
Sum19362.56
Variance1376.8891
MonotonicityNot monotonic
2024-01-10T04:59:10.553581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.63 3
 
1.6%
98.52 3
 
1.6%
86.64 2
 
1.1%
102.64 2
 
1.1%
99.54 2
 
1.1%
107.82 2
 
1.1%
105.78 1
 
0.5%
163.3 1
 
0.5%
91.85 1
 
0.5%
192.37 1
 
0.5%
Other values (140) 140
76.1%
(Missing) 26
 
14.1%
ValueCountFrequency (%)
60.48 1
0.5%
65.98 1
0.5%
68.25 1
0.5%
69.21 1
0.5%
69.36 1
0.5%
72.73 1
0.5%
74.14 1
0.5%
75.9 1
0.5%
77.04 1
0.5%
77.25 1
0.5%
ValueCountFrequency (%)
261.64 1
0.5%
221.12 1
0.5%
208.84 1
0.5%
204.66 1
0.5%
199.85 1
0.5%
197.35 1
0.5%
196.92 1
0.5%
193.75 1
0.5%
192.37 1
0.5%
191.7 1
0.5%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-07-21
184 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-21
2nd row2023-07-21
3rd row2023-07-21
4th row2023-07-21
5th row2023-07-21

Common Values

ValueCountFrequency (%)
2023-07-21 184
100.0%

Length

2024-01-10T04:59:11.290988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:59:11.455606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-21 184
100.0%

Interactions

2024-01-10T04:59:06.962342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:59:06.689264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:59:07.098683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:59:06.817623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T04:59:11.551635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건축년도면적(제곱미터)
건축년도1.0000.261
면적(제곱미터)0.2611.000
2024-01-10T04:59:11.717494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건축년도면적(제곱미터)
건축년도1.0000.037
면적(제곱미터)0.0371.000

Missing values

2024-01-10T04:59:07.276052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T04:59:07.426191image/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.
2024-01-10T04:59:07.558753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

마을회관명소재지 주소건축년도면적(제곱미터)데이터기준일자
0읍내1리 마을회관청양군 청양읍 칠갑산로 11길 92004177.462023-07-21
1읍내2리 마을회관청양군 청양읍 칠갑산로 7길 16-102006164.182023-07-21
2읍내3리 마을회관청양군 청양읍 중앙로4길 212003161.182023-07-21
3읍내4리 마을회관청양군 청양읍 중앙로3길 232005199.852023-07-21
4읍내5리 마을회관청양군 청양읍 중앙로 155-42018131.352023-07-21
5백천리 마을회관청양군 청양읍 청산로 3172000145.062023-07-21
6교월1리 마을회관청양군 청양읍 칠갑산로 318-131992113.72023-07-21
7교월2리 마을회관청양군 청양읍 평촌1길 40200499.272023-07-21
8교월3리 마을회관청양군 청양읍 향교길 15199792.292023-07-21
9벽천1리 마을회관청양군 청양읍 학사길 5-331980193.752023-07-21
마을회관명소재지 주소건축년도면적(제곱미터)데이터기준일자
174관산리 마을회관비봉면 은골길 1242000191.42023-07-21
175록평1리 마을회관비봉면 상록길 14-62002185.752023-07-21
176록평2리 마을회관비봉면 무한천길 108-83200195.782023-07-21
177장재리 마을회관비봉면 충절로 2094-17200199.152023-07-21
178강정리 마을회관비봉면 록평용당로 680-11999172.892023-07-21
179양사1리 마을회관비봉면 느랭이길 6-21995104.082023-07-21
180양사2리 마을회관비봉면 양사길 1441998108.482023-07-21
181용천리 마을회관비봉면 마리골길 441995186.282023-07-21
182방한1리 마을회관비봉면 큰한술길 55-52<NA><NA>2023-07-21
183방한2리 마을회관비봉면 신기길 171996156.272023-07-21