Overview

Dataset statistics

Number of variables4
Number of observations44
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory36.9 B

Variable types

Categorical3
Numeric1

Dataset

Description경기도 양주시 수도원격계량기(스마트워터그리드 미터기) 현황으로 설치연도, 시군명, 지역, 설치대수의 항목으로 구성되어 있습니다.
Author경기도 양주시
URLhttps://www.data.go.kr/data/15102844/fileData.do

Alerts

시군명 has constant value ""Constant
설치대수 has 9 (20.5%) zerosZeros

Reproduction

Analysis started2024-03-14 09:24:04.425512
Analysis finished2024-03-14 09:24:05.297769
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치연도
Categorical

Distinct4
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size480.0 B
2019
11 
2020
11 
2021
11 
2022
11 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019
2nd row2019
3rd row2019
4th row2019
5th row2019

Common Values

ValueCountFrequency (%)
2019 11
25.0%
2020 11
25.0%
2021 11
25.0%
2022 11
25.0%

Length

2024-03-14T18:24:05.501626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:24:05.826571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019 11
25.0%
2020 11
25.0%
2021 11
25.0%
2022 11
25.0%

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size480.0 B
양주시
44 

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 (%)
양주시 44
100.0%

Length

2024-03-14T18:24:06.189264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:24:06.689369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양주시 44
100.0%

지역
Categorical

Distinct11
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size480.0 B
광적면
4 
백석읍
4 
남면
4 
은현면
4 
양주1동
4 
Other values (6)
24 

Length

Max length4
Median length4
Mean length3.4545455
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광적면
2nd row백석읍
3rd row남면
4th row은현면
5th row양주1동

Common Values

ValueCountFrequency (%)
광적면 4
9.1%
백석읍 4
9.1%
남면 4
9.1%
은현면 4
9.1%
양주1동 4
9.1%
양주2동 4
9.1%
장흥면 4
9.1%
회천1동 4
9.1%
회천2동 4
9.1%
회천3동 4
9.1%

Length

2024-03-14T18:24:07.055761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
광적면 4
9.1%
백석읍 4
9.1%
남면 4
9.1%
은현면 4
9.1%
양주1동 4
9.1%
양주2동 4
9.1%
장흥면 4
9.1%
회천1동 4
9.1%
회천2동 4
9.1%
회천3동 4
9.1%

설치대수
Real number (ℝ)

ZEROS 

Distinct21
Distinct (%)47.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.204545
Minimum0
Maximum135
Zeros9
Zeros (%)20.5%
Negative0
Negative (%)0.0%
Memory size524.0 B
2024-03-14T18:24:07.430741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median6
Q310.25
95-th percentile36.55
Maximum135
Range135
Interquartile range (IQR)9.25

Descriptive statistics

Standard deviation22.723392
Coefficient of variation (CV)1.8618794
Kurtosis20.272355
Mean12.204545
Median Absolute Deviation (MAD)5
Skewness4.1082325
Sum537
Variance516.35254
MonotonicityNot monotonic
2024-03-14T18:24:07.830393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
0 9
20.5%
2 4
 
9.1%
7 4
 
9.1%
1 4
 
9.1%
6 3
 
6.8%
10 3
 
6.8%
3 2
 
4.5%
9 2
 
4.5%
33 1
 
2.3%
61 1
 
2.3%
Other values (11) 11
25.0%
ValueCountFrequency (%)
0 9
20.5%
1 4
9.1%
2 4
9.1%
3 2
 
4.5%
4 1
 
2.3%
6 3
 
6.8%
7 4
9.1%
8 1
 
2.3%
9 2
 
4.5%
10 3
 
6.8%
ValueCountFrequency (%)
135 1
2.3%
61 1
2.3%
37 1
2.3%
34 1
2.3%
33 1
2.3%
29 1
2.3%
21 1
2.3%
19 1
2.3%
18 1
2.3%
15 1
2.3%

Interactions

2024-03-14T18:24:04.571781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T18:24:08.082233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치연도지역설치대수
설치연도1.0000.0000.430
지역0.0001.0000.000
설치대수0.4300.0001.000
2024-03-14T18:24:08.322426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치연도지역
설치연도1.0000.000
지역0.0001.000
2024-03-14T18:24:08.552566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치대수설치연도지역
설치대수1.0000.3560.000
설치연도0.3561.0000.000
지역0.0000.0001.000

Missing values

2024-03-14T18:24:04.912752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T18:24:05.188615image/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

설치연도시군명지역설치대수
02019양주시광적면6
12019양주시백석읍1
22019양주시남면10
32019양주시은현면6
42019양주시양주1동0
52019양주시양주2동1
62019양주시장흥면2
72019양주시회천1동4
82019양주시회천2동3
92019양주시회천3동2
설치연도시군명지역설치대수
342022양주시백석읍1
352022양주시남면0
362022양주시은현면0
372022양주시양주1동0
382022양주시양주2동2
392022양주시장흥면0
402022양주시회천1동0
412022양주시회천2동2
422022양주시회천3동0
432022양주시회천4동3