Overview

Dataset statistics

Number of variables9
Number of observations101
Missing cells15
Missing cells (%)1.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.6 KiB
Average record size in memory77.3 B

Variable types

Categorical6
DateTime1
Numeric2

Dataset

Description경기도 성남시의 제설제 사용량 현황에 대한 데이터로 관리부서명, 사용연월, 염화칼슘/모래/친환경/소금 사용량 등 항목을 제공하고 있습니다.
Author경기도 성남시
URLhttps://www.data.go.kr/data/15037038/fileData.do

Alerts

시군명 has constant value ""Constant
비고 has constant value ""Constant
데이터기준일자 has constant value ""Constant
소금 사용량(톤) is highly overall correlated with 염화칼슘 사용량(톤) and 3 other fieldsHigh correlation
모래 사용량(M3) is highly overall correlated with 소금 사용량(톤)High correlation
관리부서명 is highly overall correlated with 소금 사용량(톤)High correlation
염화칼슘 사용량(톤) is highly overall correlated with 소금 사용량(톤)High correlation
친환경 제설제 사용량(톤) is highly overall correlated with 소금 사용량(톤)High correlation
염화칼슘 사용량(톤) has 4 (4.0%) missing valuesMissing
친환경 제설제 사용량(톤) has 11 (10.9%) missing valuesMissing
염화칼슘 사용량(톤) has 4 (4.0%) zerosZeros
친환경 제설제 사용량(톤) has 15 (14.9%) zerosZeros

Reproduction

Analysis started2023-12-12 17:39:18.757652
Analysis finished2023-12-12 17:39:19.759465
Duration1 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
성남시
101 

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 (%)
성남시 101
100.0%

Length

2023-12-13T02:39:19.829466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:19.923030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성남시 101
100.0%

관리부서명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
수정구 건설과
37 
중원구 건설과
35 
분당구 건설과
29 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수정구 건설과
2nd row수정구 건설과
3rd row수정구 건설과
4th row수정구 건설과
5th row수정구 건설과

Common Values

ValueCountFrequency (%)
수정구 건설과 37
36.6%
중원구 건설과 35
34.7%
분당구 건설과 29
28.7%

Length

2023-12-13T02:39:20.021660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:20.133075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건설과 101
50.0%
수정구 37
 
18.3%
중원구 35
 
17.3%
분당구 29
 
14.4%

사용연월
Date

Distinct54
Distinct (%)53.5%
Missing0
Missing (%)0.0%
Memory size940.0 B
Minimum2020-01-01 00:00:00
Maximum2023-01-26 00:00:00
2023-12-13T02:39:20.270990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:20.433427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

염화칼슘 사용량(톤)
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct77
Distinct (%)79.4%
Missing4
Missing (%)4.0%
Infinite0
Infinite (%)0.0%
Mean181.54227
Minimum0
Maximum2816
Zeros4
Zeros (%)4.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T02:39:20.922519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.48
Q127
median110
Q3243
95-th percentile391.4
Maximum2816
Range2816
Interquartile range (IQR)216

Descriptive statistics

Standard deviation322.12339
Coefficient of variation (CV)1.7743713
Kurtosis47.420577
Mean181.54227
Median Absolute Deviation (MAD)96
Skewness6.1317807
Sum17609.6
Variance103763.48
MonotonicityNot monotonic
2023-12-13T02:39:21.100826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5.0 4
 
4.0%
0.0 4
 
4.0%
112.0 3
 
3.0%
15.0 3
 
3.0%
352.0 2
 
2.0%
95.0 2
 
2.0%
151.0 2
 
2.0%
301.0 2
 
2.0%
8.0 2
 
2.0%
2.0 2
 
2.0%
Other values (67) 71
70.3%
(Missing) 4
 
4.0%
ValueCountFrequency (%)
0.0 4
4.0%
1.0 1
 
1.0%
1.6 1
 
1.0%
2.0 2
2.0%
5.0 4
4.0%
7.0 1
 
1.0%
8.0 2
2.0%
10.0 1
 
1.0%
12.0 1
 
1.0%
14.0 1
 
1.0%
ValueCountFrequency (%)
2816.0 1
1.0%
990.0 1
1.0%
974.0 1
1.0%
544.0 1
1.0%
437.0 1
1.0%
380.0 1
1.0%
377.0 2
2.0%
372.0 1
1.0%
369.0 1
1.0%
352.0 2
2.0%

모래 사용량(M3)
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
0
62 
<NA>
38 
5
 
1

Length

Max length4
Median length1
Mean length2.1287129
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 62
61.4%
<NA> 38
37.6%
5 1
 
1.0%

Length

2023-12-13T02:39:21.304346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:21.487977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 62
61.4%
na 38
37.6%
5 1
 
1.0%

친환경 제설제 사용량(톤)
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct50
Distinct (%)55.6%
Missing11
Missing (%)10.9%
Infinite0
Infinite (%)0.0%
Mean52.755556
Minimum0
Maximum659
Zeros15
Zeros (%)14.9%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T02:39:21.627128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q15
median17.5
Q349
95-th percentile235.05
Maximum659
Range659
Interquartile range (IQR)44

Descriptive statistics

Standard deviation109.0375
Coefficient of variation (CV)2.0668439
Kurtosis20.217761
Mean52.755556
Median Absolute Deviation (MAD)17.5
Skewness4.2253274
Sum4748
Variance11889.176
MonotonicityNot monotonic
2023-12-13T02:39:21.783559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 15
 
14.9%
10 5
 
5.0%
13 4
 
4.0%
5 4
 
4.0%
2 3
 
3.0%
30 3
 
3.0%
50 3
 
3.0%
3 3
 
3.0%
17 3
 
3.0%
6 2
 
2.0%
Other values (40) 45
44.6%
(Missing) 11
 
10.9%
ValueCountFrequency (%)
0 15
14.9%
1 1
 
1.0%
2 3
 
3.0%
3 3
 
3.0%
5 4
 
4.0%
6 2
 
2.0%
10 5
 
5.0%
11 1
 
1.0%
12 2
 
2.0%
13 4
 
4.0%
ValueCountFrequency (%)
659 1
1.0%
653 1
1.0%
304 1
1.0%
279 1
1.0%
249 1
1.0%
218 1
1.0%
164 1
1.0%
136 1
1.0%
134 1
1.0%
133 1
1.0%

소금 사용량(톤)
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
0
76 
<NA>
25 

Length

Max length4
Median length1
Mean length1.7425743
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 76
75.2%
<NA> 25
 
24.8%

Length

2023-12-13T02:39:21.965552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:22.109437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 76
75.2%
na 25
 
24.8%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
사용시점 기준
101 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사용시점 기준
2nd row사용시점 기준
3rd row사용시점 기준
4th row사용시점 기준
5th row사용시점 기준

Common Values

ValueCountFrequency (%)
사용시점 기준 101
100.0%

Length

2023-12-13T02:39:22.230997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:22.329040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사용시점 101
50.0%
기준 101
50.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-11-28
101 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-28
2nd row2023-11-28
3rd row2023-11-28
4th row2023-11-28
5th row2023-11-28

Common Values

ValueCountFrequency (%)
2023-11-28 101
100.0%

Length

2023-12-13T02:39:22.439757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:22.552741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-28 101
100.0%

Interactions

2023-12-13T02:39:19.209544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:19.002811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:19.298630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:19.101763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:39:22.659515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리부서명사용연월염화칼슘 사용량(톤)모래 사용량(M3)친환경 제설제 사용량(톤)
관리부서명1.0000.0000.1460.1300.320
사용연월0.0001.0000.5961.0000.000
염화칼슘 사용량(톤)0.1460.5961.0000.0000.635
모래 사용량(M3)0.1301.0000.0001.0000.000
친환경 제설제 사용량(톤)0.3200.0000.6350.0001.000
2023-12-13T02:39:22.788088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소금 사용량(톤)모래 사용량(M3)관리부서명
소금 사용량(톤)1.0001.0001.000
모래 사용량(M3)1.0001.0000.211
관리부서명1.0000.2111.000
2023-12-13T02:39:22.885355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
염화칼슘 사용량(톤)친환경 제설제 사용량(톤)관리부서명모래 사용량(M3)소금 사용량(톤)
염화칼슘 사용량(톤)1.0000.4530.1360.0001.000
친환경 제설제 사용량(톤)0.4531.0000.1350.0001.000
관리부서명0.1360.1351.0000.2111.000
모래 사용량(M3)0.0000.0000.2111.0001.000
소금 사용량(톤)1.0001.0001.0001.0001.000

Missing values

2023-12-13T02:39:19.426640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:39:19.567230image/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-13T02:39:19.682784image/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

시군명관리부서명사용연월염화칼슘 사용량(톤)모래 사용량(M3)친환경 제설제 사용량(톤)소금 사용량(톤)비고데이터기준일자
0성남시수정구 건설과2020-01-011.6000사용시점 기준2023-11-28
1성남시수정구 건설과2020-02-045.0000사용시점 기준2023-11-28
2성남시수정구 건설과2020-02-16130.001330사용시점 기준2023-11-28
3성남시수정구 건설과2020-12-130.00520사용시점 기준2023-11-28
4성남시수정구 건설과2020-12-180.00780사용시점 기준2023-11-28
5성남시수정구 건설과2021-01-08544.002790사용시점 기준2023-11-28
6성남시수정구 건설과2021-01-13116.00580사용시점 기준2023-11-28
7성남시수정구 건설과2021-01-1766.00330사용시점 기준2023-11-28
8성남시수정구 건설과2021-01-28112.0000사용시점 기준2023-11-28
9성남시수정구 건설과2021-01-3018.0000사용시점 기준2023-11-28
시군명관리부서명사용연월염화칼슘 사용량(톤)모래 사용량(M3)친환경 제설제 사용량(톤)소금 사용량(톤)비고데이터기준일자
91성남시분당구 건설과2022-12-15306.00460사용시점 기준2023-11-28
92성남시분당구 건설과2022-12-17352.00390사용시점 기준2023-11-28
93성남시분당구 건설과2022-12-21437.00670사용시점 기준2023-11-28
94성남시분당구 건설과2022-12-22124.00160사용시점 기준2023-11-28
95성남시분당구 건설과2022-12-2837.0060사용시점 기준2023-11-28
96성남시분당구 건설과2022-12-30114.00170사용시점 기준2023-11-28
97성남시분당구 건설과2023-01-07208.00310사용시점 기준2023-11-28
98성남시분당구 건설과2023-01-1741.0050사용시점 기준2023-11-28
99성남시분당구 건설과2023-01-20369.00500사용시점 기준2023-11-28
100성남시분당구 건설과2023-01-26372.00990사용시점 기준2023-11-28