Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory644.5 KiB
Average record size in memory66.0 B

Variable types

DateTime1
Numeric2
Categorical4

Dataset

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

Alerts

하수처리장구분명 has constant value ""Constant
계측구분명 is highly overall correlated with 계측값 and 2 other fieldsHigh correlation
계측태그명 is highly overall correlated with 계측값 and 2 other fieldsHigh correlation
계측단위 is highly overall correlated with 계측값 and 2 other fieldsHigh correlation
계측값 is highly overall correlated with 계측구분명 and 2 other fieldsHigh correlation
기준시간 has 416 (4.2%) zerosZeros
계측값 has 1175 (11.8%) zerosZeros

Reproduction

Analysis started2023-12-12 13:42:00.244859
Analysis finished2023-12-12 13:42:01.643403
Duration1.4 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준연월일
Date

Distinct1332
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2018-01-01 00:00:00
Maximum2021-08-25 00:00:00
2023-12-12T22:42:01.708446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:42:01.856116image/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.417
Minimum0
Maximum23
Zeros416
Zeros (%)4.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T22:42:01.969388image/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.8898373
Coefficient of variation (CV)0.60347178
Kurtosis-1.2047209
Mean11.417
Median Absolute Deviation (MAD)6
Skewness0.020628835
Sum114170
Variance47.469858
MonotonicityNot monotonic
2023-12-12T22:42:02.081530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
19 448
 
4.5%
5 447
 
4.5%
8 442
 
4.4%
4 441
 
4.4%
6 435
 
4.3%
13 431
 
4.3%
7 425
 
4.2%
10 424
 
4.2%
9 422
 
4.2%
17 421
 
4.2%
Other values (14) 5664
56.6%
ValueCountFrequency (%)
0 416
4.2%
1 399
4.0%
2 408
4.1%
3 415
4.2%
4 441
4.4%
5 447
4.5%
6 435
4.3%
7 425
4.2%
8 442
4.4%
9 422
4.2%
ValueCountFrequency (%)
23 392
3.9%
22 399
4.0%
21 418
4.2%
20 400
4.0%
19 448
4.5%
18 414
4.1%
17 421
4.2%
16 385
3.9%
15 408
4.1%
14 416
4.2%

하수처리장구분명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
진례 하수처리장
10000 

Length

Max length8
Median length8
Mean length8
Min length8

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-12T22:42:02.203011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:42:02.289446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
진례 10000
50.0%
하수처리장 10000
50.0%

계측구분명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
유입수 pH
3410 
유입수 온도
3367 
유량조정조 수위
3223 

Length

Max length8
Median length6
Mean length6.6446
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유입수 온도
2nd row유입수 pH
3rd row유입수 온도
4th row유량조정조 수위
5th row유량조정조 수위

Common Values

ValueCountFrequency (%)
유입수 pH 3410
34.1%
유입수 온도 3367
33.7%
유량조정조 수위 3223
32.2%

Length

2023-12-12T22:42:02.420082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:42:02.530490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유입수 6777
33.9%
ph 3410
17.1%
온도 3367
16.8%
유량조정조 3223
16.1%
수위 3223
16.1%

계측태그명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
PHT-101
3410 
TT-102
3367 
LT-103
3223 

Length

Max length7
Median length6
Mean length6.341
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowTT-102
2nd rowPHT-101
3rd rowTT-102
4th rowLT-103
5th rowLT-103

Common Values

ValueCountFrequency (%)
PHT-101 3410
34.1%
TT-102 3367
33.7%
LT-103 3223
32.2%

Length

2023-12-12T22:42:02.645430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:42:02.745486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
pht-101 3410
34.1%
tt-102 3367
33.7%
lt-103 3223
32.2%

계측단위
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
pH
3410 
℃
3367 
m
3223 

Length

Max length2
Median length1
Mean length1.341
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row℃
2nd rowpH
3rd row℃
4th rowm
5th rowm

Common Values

ValueCountFrequency (%)
pH 3410
34.1%
℃ 3367
33.7%
m 3223
32.2%

Length

2023-12-12T22:42:02.876853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:42:02.973613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
ph 3410
34.1%
℃ 3367
33.7%
m 3223
32.2%

계측값
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct2109
Distinct (%)21.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.590425
Minimum-6.64
Maximum26.65
Zeros1175
Zeros (%)11.8%
Negative827
Negative (%)8.3%
Memory size166.0 KiB
2023-12-12T22:42:03.084919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-6.64
5-th percentile-2.5305
Q11.21
median2.48
Q37.18
95-th percentile22.9105
Maximum26.65
Range33.29
Interquartile range (IQR)5.97

Descriptive statistics

Standard deviation7.0315779
Coefficient of variation (CV)1.2577895
Kurtosis1.0124356
Mean5.590425
Median Absolute Deviation (MAD)3.04
Skewness1.2593866
Sum55904.25
Variance49.443088
MonotonicityNot monotonic
2023-12-12T22:42:03.234393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 1175
 
11.8%
14.0 416
 
4.2%
7.1 258
 
2.6%
7.09 53
 
0.5%
7.08 36
 
0.4%
2.55 36
 
0.4%
6.98 36
 
0.4%
2.39 35
 
0.4%
6.93 33
 
0.3%
3.28 32
 
0.3%
Other values (2099) 7890
78.9%
ValueCountFrequency (%)
-6.64 2
< 0.1%
-6.61 2
< 0.1%
-6.58 3
< 0.1%
-6.57 1
 
< 0.1%
-6.55 1
 
< 0.1%
-6.53 1
 
< 0.1%
-6.52 1
 
< 0.1%
-6.51 2
< 0.1%
-6.47 1
 
< 0.1%
-6.39 2
< 0.1%
ValueCountFrequency (%)
26.65 1
 
< 0.1%
26.62 2
< 0.1%
26.6 1
 
< 0.1%
26.56 3
< 0.1%
26.55 1
 
< 0.1%
26.54 2
< 0.1%
26.52 1
 
< 0.1%
26.51 2
< 0.1%
26.49 2
< 0.1%
26.46 3
< 0.1%

Interactions

2023-12-12T22:42:00.908674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:42:00.728058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:42:00.993736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:42:00.812451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:42:03.348078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준시간계측구분명계측태그명계측단위계측값
기준시간1.0000.0240.0240.0240.074
계측구분명0.0241.0001.0001.0000.860
계측태그명0.0241.0001.0001.0000.860
계측단위0.0241.0001.0001.0000.860
계측값0.0740.8600.8600.8601.000
2023-12-12T22:42:03.463450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계측구분명계측태그명계측단위
계측구분명1.0001.0001.000
계측태그명1.0001.0001.000
계측단위1.0001.0001.000
2023-12-12T22:42:03.555762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준시간계측값계측구분명계측태그명계측단위
기준시간1.0000.0140.0140.0140.014
계측값0.0141.0000.7840.7840.784
계측구분명0.0140.7841.0001.0001.000
계측태그명0.0140.7841.0001.0001.000
계측단위0.0140.7841.0001.0001.000

Missing values

2023-12-12T22:42:01.422258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:42:01.581980image/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

기준연월일기준시간하수처리장구분명계측구분명계측태그명계측단위계측값
637532021-08-169진례 하수처리장유입수 온도TT-102℃26.11
300262021-06-052진례 하수처리장유입수 pHPHT-101pH0.0
496442020-01-0612진례 하수처리장유입수 온도TT-102℃-2.93
709602018-10-1816진례 하수처리장유량조정조 수위LT-103m1.86
748212019-03-2813진례 하수처리장유량조정조 수위LT-103m1.76
696252018-08-241진례 하수처리장유량조정조 수위LT-103m2.39
386392018-10-0423진례 하수처리장유입수 온도TT-102℃8.15
920262021-03-1410진례 하수처리장유량조정조 수위LT-103m2.48
67732018-10-105진례 하수처리장유입수 pHPHT-101pH3.28
641512018-01-0723진례 하수처리장유량조정조 수위LT-103m1.41
기준연월일기준시간하수처리장구분명계측구분명계측태그명계측단위계측값
631252021-07-215진례 하수처리장유입수 온도TT-102℃24.89
691152018-08-0219진례 하수처리장유량조정조 수위LT-103m2.19
358792018-06-1123진례 하수처리장유입수 온도TT-102℃6.53
262932020-12-3113진례 하수처리장유입수 pHPHT-101pH0.0
117842019-05-070진례 하수처리장유입수 pHPHT-101pH6.17
797522019-10-200진례 하수처리장유량조정조 수위LT-103m2.66
76512018-11-1519진례 하수처리장유입수 pHPHT-101pH7.16
94272019-01-2819진례 하수처리장유입수 pHPHT-101pH6.85
405412018-12-235진례 하수처리장유입수 온도TT-102℃-2.08
919352021-03-1015진례 하수처리장유량조정조 수위LT-103m2.01