Overview

Dataset statistics

Number of variables9
Number of observations361
Missing cells40
Missing cells (%)1.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory26.2 KiB
Average record size in memory74.4 B

Variable types

Categorical4
Text2
DateTime1
Numeric2

Dataset

Description충청북도 충주시 관내 마을회관 현황에 관한 데이터(시도, 시군구, 읍면동, 시설명, 위치, 건축년월일, 구조, 건축연면적, 부지면적) 제공
URLhttps://www.data.go.kr/data/15007423/fileData.do

Alerts

시도 has constant value ""Constant
시군구 has constant value ""Constant
부지면적 has 39 (10.8%) missing valuesMissing

Reproduction

Analysis started2023-12-12 09:08:22.957530
Analysis finished2023-12-12 09:08:24.299097
Duration1.34 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
충청북도
361 

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 (%)
충청북도 361
100.0%

Length

2023-12-12T18:08:24.367989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:08:24.483218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청북도 361
100.0%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
충주시
361 

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 (%)
충주시 361
100.0%

Length

2023-12-12T18:08:24.625327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:08:24.757093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충주시 361
100.0%

읍면동
Categorical

Distinct22
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
주덕읍
35 
앙성면
35 
대소원면
30 
엄정면
26 
신니면
25 
Other values (17)
210 

Length

Max length5
Median length3
Mean length3.2714681
Min length3

Unique

Unique2 ?
Unique (%)0.6%

Sample

1st row주덕읍
2nd row주덕읍
3rd row주덕읍
4th row주덕읍
5th row주덕읍

Common Values

ValueCountFrequency (%)
주덕읍 35
 
9.7%
앙성면 35
 
9.7%
대소원면 30
 
8.3%
엄정면 26
 
7.2%
신니면 25
 
6.9%
산척면 25
 
6.9%
중앙탑면 24
 
6.6%
동량면 23
 
6.4%
소태면 21
 
5.8%
노은면 19
 
5.3%
Other values (12) 98
27.1%

Length

2023-12-12T18:08:24.908901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
주덕읍 35
 
9.7%
앙성면 35
 
9.7%
대소원면 30
 
8.3%
엄정면 26
 
7.2%
신니면 25
 
6.9%
산척면 25
 
6.9%
중앙탑면 24
 
6.6%
동량면 23
 
6.4%
소태면 21
 
5.8%
노은면 19
 
5.3%
Other values (12) 98
27.1%

시설명
Text

Distinct348
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2023-12-12T18:08:25.356419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length8
Mean length8.5955679
Min length7

Characters and Unicode

Total characters3103
Distinct characters186
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

Unique337 ?
Unique (%)93.4%

Sample

1st row창전5리 다기능회관
2nd row창전4리 다기능회관
3rd row창전1리 다기능회관
4th row동산미 다기능회관
5th row맹동 다기능회관
ValueCountFrequency (%)
다기능회관 356
49.4%
신대 4
 
0.6%
내동 3
 
0.4%
행정 3
 
0.4%
신촌 3
 
0.4%
탑평 2
 
0.3%
갈마 2
 
0.3%
능암 2
 
0.3%
하남 2
 
0.3%
미륵 2
 
0.3%
Other values (335) 342
47.4%
2023-12-12T18:08:26.056700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
403
13.0%
능 365
11.8%
회 363
11.7%
관 363
11.7%
기 362
11.7%
다 360
11.6%
리 61
 
2.0%
동 44
 
1.4%
1 27
 
0.9%
2 27
 
0.9%
Other values (176) 728
23.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2634
84.9%
Space Separator 403
 
13.0%
Decimal Number 66
 
2.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
능 365
13.9%
회 363
13.8%
관 363
13.8%
기 362
13.7%
다 360
13.7%
리 61
 
2.3%
동 44
 
1.7%
신 24
 
0.9%
대 23
 
0.9%
곡 20
 
0.8%
Other values (170) 649
24.6%
Decimal Number
ValueCountFrequency (%)
1 27
40.9%
2 27
40.9%
3 8
 
12.1%
5 2
 
3.0%
4 2
 
3.0%
Space Separator
ValueCountFrequency (%)
403
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2634
84.9%
Common 469
 
15.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
능 365
13.9%
회 363
13.8%
관 363
13.8%
기 362
13.7%
다 360
13.7%
리 61
 
2.3%
동 44
 
1.7%
신 24
 
0.9%
대 23
 
0.9%
곡 20
 
0.8%
Other values (170) 649
24.6%
Common
ValueCountFrequency (%)
403
85.9%
1 27
 
5.8%
2 27
 
5.8%
3 8
 
1.7%
5 2
 
0.4%
4 2
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2634
84.9%
ASCII 469
 
15.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
403
85.9%
1 27
 
5.8%
2 27
 
5.8%
3 8
 
1.7%
5 2
 
0.4%
4 2
 
0.4%
Hangul
ValueCountFrequency (%)
능 365
13.9%
회 363
13.8%
관 363
13.8%
기 362
13.7%
다 360
13.7%
리 61
 
2.3%
동 44
 
1.7%
신 24
 
0.9%
대 23
 
0.9%
곡 20
 
0.8%
Other values (170) 649
24.6%

위치
Text

Distinct360
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2023-12-12T18:08:26.484774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length24
Mean length16.736842
Min length10

Characters and Unicode

Total characters6042
Distinct characters156
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

Unique359 ?
Unique (%)99.4%

Sample

1st row충주시 주덕읍 창전리 66-3
2nd row충주시 주덕읍 창전리 290-5
3rd row충주시 주덕읍 창전리 491-4
4th row충주시 주덕읍 대곡리 230-1
5th row충주시 주덕읍 대곡리 323-5
ValueCountFrequency (%)
충주시 361
25.3%
주덕읍 35
 
2.5%
앙성면 35
 
2.5%
대소원면 30
 
2.1%
엄정면 26
 
1.8%
산척면 25
 
1.8%
신니면 25
 
1.8%
중앙탑면 24
 
1.7%
동량면 23
 
1.6%
소태면 21
 
1.5%
Other values (516) 823
57.6%
2023-12-12T18:08:27.446594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1067
17.7%
주 405
 
6.7%
충 362
 
6.0%
시 361
 
6.0%
리 313
 
5.2%
1 289
 
4.8%
- 286
 
4.7%
면 279
 
4.6%
2 208
 
3.4%
3 160
 
2.6%
Other values (146) 2312
38.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3236
53.6%
Decimal Number 1440
23.8%
Space Separator 1067
 
17.7%
Dash Punctuation 286
 
4.7%
Other Punctuation 13
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 405
 
12.5%
충 362
 
11.2%
시 361
 
11.2%
리 313
 
9.7%
면 279
 
8.6%
동 91
 
2.8%
앙 59
 
1.8%
소 53
 
1.6%
덕 51
 
1.6%
대 49
 
1.5%
Other values (133) 1213
37.5%
Decimal Number
ValueCountFrequency (%)
1 289
20.1%
2 208
14.4%
3 160
11.1%
4 151
10.5%
5 135
9.4%
7 127
8.8%
6 114
 
7.9%
8 98
 
6.8%
9 82
 
5.7%
0 76
 
5.3%
Space Separator
ValueCountFrequency (%)
1067
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 286
100.0%
Other Punctuation
ValueCountFrequency (%)
, 13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3236
53.6%
Common 2806
46.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 405
 
12.5%
충 362
 
11.2%
시 361
 
11.2%
리 313
 
9.7%
면 279
 
8.6%
동 91
 
2.8%
앙 59
 
1.8%
소 53
 
1.6%
덕 51
 
1.6%
대 49
 
1.5%
Other values (133) 1213
37.5%
Common
ValueCountFrequency (%)
1067
38.0%
1 289
 
10.3%
- 286
 
10.2%
2 208
 
7.4%
3 160
 
5.7%
4 151
 
5.4%
5 135
 
4.8%
7 127
 
4.5%
6 114
 
4.1%
8 98
 
3.5%
Other values (3) 171
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3236
53.6%
ASCII 2806
46.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1067
38.0%
1 289
 
10.3%
- 286
 
10.2%
2 208
 
7.4%
3 160
 
5.7%
4 151
 
5.4%
5 135
 
4.8%
7 127
 
4.5%
6 114
 
4.1%
8 98
 
3.5%
Other values (3) 171
 
6.1%
Hangul
ValueCountFrequency (%)
주 405
 
12.5%
충 362
 
11.2%
시 361
 
11.2%
리 313
 
9.7%
면 279
 
8.6%
동 91
 
2.8%
앙 59
 
1.8%
소 53
 
1.6%
덕 51
 
1.6%
대 49
 
1.5%
Other values (133) 1213
37.5%

건축년월일
Date

Distinct314
Distinct (%)87.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
Minimum1963-01-01 00:00:00
Maximum2021-12-30 00:00:00
2023-12-12T18:08:27.618172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:08:27.785369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

구조
Categorical

Distinct44
Distinct (%)12.2%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
철근콘크리트 스라브
83 
시멘벽돌 스라브
51 
조적조 스라브
38 
철근콘크리트
36 
시멘블럭 스라브
30 
Other values (39)
123 

Length

Max length11
Median length10
Mean length7.9833795
Min length3

Unique

Unique24 ?
Unique (%)6.6%

Sample

1st row철근콘크리트 스라브
2nd row시멘블럭 스라브
3rd row시멘블럭 스라브
4th row철근콘크리트구조
5th row철근콘크리트 스라브

Common Values

ValueCountFrequency (%)
철근콘크리트 스라브 83
23.0%
시멘벽돌 스라브 51
14.1%
조적조 스라브 38
10.5%
철근콘크리트 36
10.0%
시멘블럭 스라브 30
 
8.3%
치장벽돌 스라브 26
 
7.2%
철근콘크리트조 14
 
3.9%
시멘블럭 스레트 13
 
3.6%
적벽돌 스라브 9
 
2.5%
시멘벽돌 스레트 6
 
1.7%
Other values (34) 55
15.2%

Length

2023-12-12T18:08:27.943848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
스라브 249
38.3%
철근콘크리트 126
19.4%
시멘벽돌 60
 
9.2%
시멘블럭 44
 
6.8%
조적조 39
 
6.0%
치장벽돌 29
 
4.5%
철근콘크리트조 19
 
2.9%
스레트 19
 
2.9%
적벽돌 11
 
1.7%
벽돌구조 6
 
0.9%
Other values (26) 48
 
7.4%

건축연면적
Real number (ℝ)

Distinct341
Distinct (%)94.7%
Missing1
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean216.67056
Minimum36
Maximum17815
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T18:08:28.073448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36
5-th percentile64.347
Q192.55
median112.945
Q3153.365
95-th percentile252.591
Maximum17815
Range17779
Interquartile range (IQR)60.815

Descriptive statistics

Standard deviation1137.6834
Coefficient of variation (CV)5.2507523
Kurtosis197.30775
Mean216.67056
Median Absolute Deviation (MAD)28.945
Skewness13.870695
Sum78001.4
Variance1294323.6
MonotonicityNot monotonic
2023-12-12T18:08:28.213796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
84.0 4
 
1.1%
99.6 3
 
0.8%
132.0 2
 
0.6%
99.0 2
 
0.6%
96.0 2
 
0.6%
105.02 2
 
0.6%
90.0 2
 
0.6%
82.64 2
 
0.6%
116.0 2
 
0.6%
66.0 2
 
0.6%
Other values (331) 337
93.4%
ValueCountFrequency (%)
36.0 1
0.3%
37.8 1
0.3%
42.0 1
0.3%
43.0 1
0.3%
44.18 1
0.3%
45.0 1
0.3%
48.51 1
0.3%
49.4 1
0.3%
49.47 1
0.3%
51.36 1
0.3%
ValueCountFrequency (%)
17815.0 1
0.3%
12474.0 1
0.3%
975.32 1
0.3%
563.76 1
0.3%
493.9 1
0.3%
387.34 1
0.3%
384.61 1
0.3%
373.51 1
0.3%
372.87 1
0.3%
349.8 1
0.3%

부지면적
Real number (ℝ)

MISSING 

Distinct268
Distinct (%)83.2%
Missing39
Missing (%)10.8%
Infinite0
Infinite (%)0.0%
Mean878.84
Minimum74
Maximum60367
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T18:08:28.355482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum74
5-th percentile166.3
Q1300.265
median430
Q3675
95-th percentile1667.05
Maximum60367
Range60293
Interquartile range (IQR)374.735

Descriptive statistics

Standard deviation3846.0733
Coefficient of variation (CV)4.3763066
Kurtosis195.88551
Mean878.84
Median Absolute Deviation (MAD)170.75
Skewness13.587652
Sum282986.48
Variance14792279
MonotonicityNot monotonic
2023-12-12T18:08:28.479546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
330.0 6
 
1.7%
660.0 5
 
1.4%
324.0 4
 
1.1%
397.0 3
 
0.8%
181.0 3
 
0.8%
495.0 3
 
0.8%
327.0 3
 
0.8%
496.0 3
 
0.8%
255.0 2
 
0.6%
417.0 2
 
0.6%
Other values (258) 288
79.8%
(Missing) 39
 
10.8%
ValueCountFrequency (%)
74.0 1
0.3%
96.0 1
0.3%
97.0 1
0.3%
98.0 1
0.3%
100.0 1
0.3%
100.75 1
0.3%
104.0 1
0.3%
107.0 1
0.3%
120.0 1
0.3%
127.0 1
0.3%
ValueCountFrequency (%)
60367.0 1
0.3%
33900.0 1
0.3%
3967.0 1
0.3%
3960.0 1
0.3%
3577.0 1
0.3%
2895.0 1
0.3%
2840.0 1
0.3%
2631.0 1
0.3%
2324.0 1
0.3%
2278.0 1
0.3%

Interactions

2023-12-12T18:08:23.663425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:08:23.403340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:08:23.786192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:08:23.537079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:08:28.561715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동구조건축연면적부지면적
읍면동1.0000.2210.0000.000
구조0.2211.0000.0000.000
건축연면적0.0000.0001.0000.000
부지면적0.0000.0000.0001.000
2023-12-12T18:08:28.646530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구조읍면동
구조1.0000.043
읍면동0.0431.000
2023-12-12T18:08:28.741303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건축연면적부지면적읍면동구조
건축연면적1.0000.2590.0000.000
부지면적0.2591.0000.0000.000
읍면동0.0000.0001.0000.043
구조0.0000.0000.0431.000

Missing values

2023-12-12T18:08:23.929039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:08:24.082258image/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.
2023-12-12T18:08:24.221265image/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충청북도충주시주덕읍창전5리 다기능회관충주시 주덕읍 창전리 66-32007-06-11철근콘크리트 스라브120.34496.0
1충청북도충주시주덕읍창전4리 다기능회관충주시 주덕읍 창전리 290-51972-01-01시멘블럭 스라브149.48420.0
2충청북도충주시주덕읍창전1리 다기능회관충주시 주덕읍 창전리 491-41984-01-01시멘블럭 스라브86.21857.0
3충청북도충주시주덕읍동산미 다기능회관충주시 주덕읍 대곡리 230-12011-10-16철근콘크리트구조133.11398.0
4충청북도충주시주덕읍맹동 다기능회관충주시 주덕읍 대곡리 323-52003-12-15철근콘크리트 스라브117.21399.0
5충청북도충주시주덕읍원대곡 다기능회관충주시 주덕읍 대곡리 616-32006-12-14철근콘크리트 스라브121.24321.0
6충청북도충주시주덕읍청양 다기능회관충주시 주덕읍 삼청리 99-42004-10-08철근콘크리트 스라브92.81364.0
7충청북도충주시주덕읍능촌 다기능회관충주시 주덕읍 삼청리 4201992-01-01시멘벽돌 스라브136.11521.0
8충청북도충주시주덕읍묵동 다기능회관충주시 주덕읍 삼청리 570-21995-01-01적벽돌 스라브84.0400.0
9충청북도충주시주덕읍삼방 다기능회관충주시 주덕읍 삼청리 977-32010-12-10철근콘크리트조152.3813.0
시도시군구읍면동시설명위치건축년월일구조건축연면적부지면적
351충청북도충주시연수동동편 다기능회관 가동충주시 연수동 658-51986-12-30철근콘크리트 스라브66.54605.0
352충청북도충주시연수동서편 다기능회관충주시 연수동 679-12002-11-27철근콘크리트 스라브117.2327.0
353충청북도충주시목행동미륵 다기능회관충주시 목행동 403-5외 1필지2004-02-03조적조 스라브94.61495.0
354충청북도충주시목행동목행 다기능회관충주시 목행동 600-151994-01-01철근콘크리트 스라브147.96277.1
355충청북도충주시목행동행정 경로당으로변경충주시 목행동 663-191996-01-01철근콘크리트 스라브156.29148.9
356충청북도충주시목행동서흥 다기능회관충주시 목행동 150-21983-01-01시멘블럭 스레트63.0<NA>
357충청북도충주시용탄동용곡 다기능회관충주시 용탄동 6451999-01-07시멘벽돌 스라브97.02585.0
358충청북도충주시용탄동용곡2 다기능회관충주시 용탄동 3522011-12-13철근콘크리트 스라브96.66350.0
359충청북도충주시용탄동구동 다기능회관충주시 용탄동 8472007-08-16철근콘크리트 스라브105.95930.0
360충청북도충주시용탄동용탄2통 다기능회관충주시 용탄동 266-42007-08-29철근콘크리트 슬라브126.84635.0