Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory566.4 KiB
Average record size in memory58.0 B

Variable types

DateTime1
Numeric2
Categorical3

Dataset

Description김해도시개발공사 대동 하수처리시설별에 대한 시간대별 가동시간 현황을 조회하는 서비스로 기준연월일, 기준시간, 하수처리장구분명, 가동시간 등의 정보를 제공
Author김해시도시개발공사
URLhttps://www.data.go.kr/data/15096547/fileData.do

Alerts

하수처리장구분명 has constant value ""Constant
태그설명 is highly overall correlated with 태그High correlation
태그 is highly overall correlated with 태그설명High correlation
기준시간 has 425 (4.2%) zerosZeros
가동시간 has 5710 (57.1%) zerosZeros

Reproduction

Analysis started2023-12-12 05:37:41.797845
Analysis finished2023-12-12 05:37:42.909852
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준연월일
Date

Distinct621
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2019-04-23 00:00:00
Maximum2021-01-27 00:00:00
2023-12-12T14:37:43.008846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:37:43.189546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준시간
Real number (ℝ)

ZEROS 

Distinct24
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.4666
Minimum0
Maximum23
Zeros425
Zeros (%)4.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T14:37:43.354540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q15
median11
Q317
95-th percentile22
Maximum23
Range23
Interquartile range (IQR)12

Descriptive statistics

Standard deviation6.9029885
Coefficient of variation (CV)0.60200831
Kurtosis-1.1942622
Mean11.4666
Median Absolute Deviation (MAD)6
Skewness0.0045179326
Sum114666
Variance47.65125
MonotonicityNot monotonic
2023-12-12T14:37:43.525116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
7 455
 
4.5%
19 449
 
4.5%
10 438
 
4.4%
17 434
 
4.3%
23 433
 
4.3%
5 431
 
4.3%
1 429
 
4.3%
13 427
 
4.3%
0 425
 
4.2%
11 425
 
4.2%
Other values (14) 5654
56.5%
ValueCountFrequency (%)
0 425
4.2%
1 429
4.3%
2 394
3.9%
3 398
4.0%
4 424
4.2%
5 431
4.3%
6 397
4.0%
7 455
4.5%
8 410
4.1%
9 411
4.1%
ValueCountFrequency (%)
23 433
4.3%
22 377
3.8%
21 401
4.0%
20 406
4.1%
19 449
4.5%
18 396
4.0%
17 434
4.3%
16 424
4.2%
15 413
4.1%
14 403
4.0%

하수처리장구분명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
대동 공공하수처리시설
10000 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대동 공공하수처리시설
2nd row대동 공공하수처리시설
3rd row대동 공공하수처리시설
4th row대동 공공하수처리시설
5th row대동 공공하수처리시설

Common Values

ValueCountFrequency (%)
대동 공공하수처리시설 10000
100.0%

Length

2023-12-12T14:37:43.698758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:37:43.824267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대동 10000
50.0%
공공하수처리시설 10000
50.0%

태그설명
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
협잡물이송콘베어
2166 
침사수평스크류
1622 
스텝스크린
1572 
침사경사스크류
1569 
세목스크린
1550 

Length

Max length10
Median length8
Mean length7.0485
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세목스크린
2nd row협잡물이송콘베어
3rd row미세목(스텝)스크린
4th row침사경사스크류
5th row세목스크린

Common Values

ValueCountFrequency (%)
협잡물이송콘베어 2166
21.7%
침사수평스크류 1622
16.2%
스텝스크린 1572
15.7%
침사경사스크류 1569
15.7%
세목스크린 1550
15.5%
미세목(스텝)스크린 1521
15.2%

Length

2023-12-12T14:37:43.949529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:37:44.102914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
협잡물이송콘베어 2166
21.7%
침사수평스크류 1622
16.2%
스텝스크린 1572
15.7%
침사경사스크류 1569
15.7%
세목스크린 1550
15.5%
미세목(스텝)스크린 1521
15.2%

태그
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
MD-102A
6323 
MD-102B
2127 
MD-103
1550 

Length

Max length7
Median length7
Mean length6.845
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMD-103
2nd rowMD-102B
3rd rowMD-102B
4th rowMD-102A
5th rowMD-103

Common Values

ValueCountFrequency (%)
MD-102A 6323
63.2%
MD-102B 2127
 
21.3%
MD-103 1550
 
15.5%

Length

2023-12-12T14:37:44.252021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:37:44.381988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
md-102a 6323
63.2%
md-102b 2127
 
21.3%
md-103 1550
 
15.5%

가동시간
Real number (ℝ)

ZEROS 

Distinct26
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3248
Minimum0
Maximum60
Zeros5710
Zeros (%)57.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T14:37:44.543678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q35
95-th percentile6
Maximum60
Range60
Interquartile range (IQR)5

Descriptive statistics

Standard deviation5.1666018
Coefficient of variation (CV)2.2223855
Kurtosis87.134868
Mean2.3248
Median Absolute Deviation (MAD)0
Skewness8.1949471
Sum23248
Variance26.693774
MonotonicityNot monotonic
2023-12-12T14:37:44.698842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
0 5710
57.1%
5 1406
 
14.1%
6 1199
 
12.0%
2 450
 
4.5%
3 416
 
4.2%
1 349
 
3.5%
7 162
 
1.6%
4 120
 
1.2%
60 57
 
0.6%
8 43
 
0.4%
Other values (16) 88
 
0.9%
ValueCountFrequency (%)
0 5710
57.1%
1 349
 
3.5%
2 450
 
4.5%
3 416
 
4.2%
4 120
 
1.2%
5 1406
 
14.1%
6 1199
 
12.0%
7 162
 
1.6%
8 43
 
0.4%
9 23
 
0.2%
ValueCountFrequency (%)
60 57
0.6%
47 2
 
< 0.1%
29 2
 
< 0.1%
25 1
 
< 0.1%
23 1
 
< 0.1%
20 3
 
< 0.1%
19 2
 
< 0.1%
18 1
 
< 0.1%
17 1
 
< 0.1%
16 3
 
< 0.1%

Interactions

2023-12-12T14:37:42.379584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:37:42.183706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:37:42.480466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:37:42.279150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:37:44.801465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준시간태그설명태그가동시간
기준시간1.0000.0000.0120.025
태그설명0.0001.0000.9970.341
태그0.0120.9971.0000.323
가동시간0.0250.3410.3231.000
2023-12-12T14:37:44.905354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
태그설명태그
태그설명1.0000.929
태그0.9291.000
2023-12-12T14:37:45.020246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준시간가동시간태그설명태그
기준시간1.0000.0110.0000.007
가동시간0.0111.0000.0990.099
태그설명0.0000.0991.0000.929
태그0.0070.0990.9291.000

Missing values

2023-12-12T14:37:42.699661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:37:42.847608image/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

기준연월일기준시간하수처리장구분명태그설명태그가동시간
104052020-07-1914대동 공공하수처리시설세목스크린MD-1033
934522019-10-0511대동 공공하수처리시설협잡물이송콘베어MD-102B0
749642019-05-043대동 공공하수처리시설미세목(스텝)스크린MD-102B0
624142019-08-150대동 공공하수처리시설침사경사스크류MD-102A0
15412019-06-2813대동 공공하수처리시설세목스크린MD-1033
35812019-09-2313대동 공공하수처리시설세목스크린MD-1033
405192020-07-2910대동 공공하수처리시설협잡물이송콘베어MD-102A5
927772019-09-078대동 공공하수처리시설협잡물이송콘베어MD-102B0
297072021-01-2111대동 공공하수처리시설스텝스크린MD-102A0
372232020-03-032대동 공공하수처리시설협잡물이송콘베어MD-102A5
기준연월일기준시간하수처리장구분명태그설명태그가동시간
756012019-05-3116대동 공공하수처리시설미세목(스텝)스크린MD-102B0
562192020-08-2921대동 공공하수처리시설침사수평스크류MD-102A6
196232019-11-0821대동 공공하수처리시설스텝스크린MD-102A0
392592020-06-0422대동 공공하수처리시설협잡물이송콘베어MD-102A3
369642020-02-207대동 공공하수처리시설협잡물이송콘베어MD-102A0
923292019-08-1816대동 공공하수처리시설협잡물이송콘베어MD-102B0
68812020-02-1118대동 공공하수처리시설세목스크린MD-1030
666022020-02-0917대동 공공하수처리시설침사경사스크류MD-102A7
751012019-05-0920대동 공공하수처리시설미세목(스텝)스크린MD-102B0
764042019-07-073대동 공공하수처리시설미세목(스텝)스크린MD-102B0