Overview

Dataset statistics

Number of variables8
Number of observations10000
Missing cells195
Missing cells (%)0.2%
Duplicate rows22
Duplicate rows (%)0.2%
Total size in memory742.2 KiB
Average record size in memory76.0 B

Variable types

Categorical3
DateTime1
Numeric4

Dataset

Description일산 호수공원 수상 드론 정보
Author고양시
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=ZN4OREO1LMAHIDRY0I6U26412848&infSeq=1

Alerts

설치장소명 has constant value ""Constant
디바이스명 has constant value ""Constant
보고형태 has constant value ""Constant
Dataset has 22 (0.2%) duplicate rowsDuplicates
탁도측정값(NTU) is highly overall correlated with 배터리전압측정값(V)High correlation
배터리전압측정값(V) is highly overall correlated with 탁도측정값(NTU)High correlation
수온측정값(℃) has 195 (1.9%) missing valuesMissing
탁도측정값(NTU) is highly skewed (γ1 = 61.63826204)Skewed
배터리전압측정값(V) is highly skewed (γ1 = 61.63826204)Skewed
수온측정값(℃) has 195 (1.9%) zerosZeros
전기전도도측정값(m/S) has 2345 (23.4%) zerosZeros
탁도측정값(NTU) has 358 (3.6%) zerosZeros
배터리전압측정값(V) has 358 (3.6%) zerosZeros

Reproduction

Analysis started2023-12-10 21:38:01.993244
Analysis finished2023-12-10 21:38:04.970481
Duration2.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치장소명
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-11T06:38:05.042725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:38:05.210958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
호수공원 10000
33.3%
내 10000
33.3%
인공호수 10000
33.3%

디바이스명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
waterdrone
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
waterdrone 10000
100.0%

Length

2023-12-11T06:38:05.324605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:38:05.441057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
waterdrone 10000
100.0%

수집시간
Date

Distinct9940
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-09-13 06:15:00
Maximum2019-10-31 13:33:22
2023-12-11T06:38:05.571185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:05.742159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

보고형태
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
report
10000 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
report 10000
100.0%

Length

2023-12-11T06:38:05.899796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:38:06.011363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
report 10000
100.0%

수온측정값(℃)
Real number (ℝ)

MISSING  ZEROS 

Distinct2776
Distinct (%)28.3%
Missing195
Missing (%)1.9%
Infinite0
Infinite (%)0.0%
Mean14.822
Minimum-1.05
Maximum33.3
Zeros195
Zeros (%)1.9%
Negative52
Negative (%)0.5%
Memory size166.0 KiB
2023-12-11T06:38:06.157426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-1.05
5-th percentile1.842
Q14.69
median15.56
Q322.26
95-th percentile28.068
Maximum33.3
Range34.35
Interquartile range (IQR)17.57

Descriptive statistics

Standard deviation9.1848911
Coefficient of variation (CV)0.61967961
Kurtosis-1.2870933
Mean14.822
Median Absolute Deviation (MAD)8.65
Skewness-0.0030431475
Sum145329.71
Variance84.362225
MonotonicityNot monotonic
2023-12-11T06:38:06.323936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 195
 
1.9%
3.97 24
 
0.2%
4.04 23
 
0.2%
3.95 22
 
0.2%
3.93 22
 
0.2%
4.12 22
 
0.2%
4.03 21
 
0.2%
4.05 20
 
0.2%
4.11 19
 
0.2%
3.94 18
 
0.2%
Other values (2766) 9419
94.2%
(Missing) 195
 
1.9%
ValueCountFrequency (%)
-1.05 1
< 0.1%
-1.01 1
< 0.1%
-0.81 1
< 0.1%
-0.71 1
< 0.1%
-0.63 2
< 0.1%
-0.58 1
< 0.1%
-0.57 1
< 0.1%
-0.55 1
< 0.1%
-0.53 2
< 0.1%
-0.52 1
< 0.1%
ValueCountFrequency (%)
33.3 1
< 0.1%
33.25 1
< 0.1%
33.24 1
< 0.1%
33.21 1
< 0.1%
33.18 1
< 0.1%
33.17 1
< 0.1%
33.16 1
< 0.1%
33.15 2
< 0.1%
33.14 1
< 0.1%
33.13 1
< 0.1%

전기전도도측정값(m/S)
Real number (ℝ)

ZEROS 

Distinct564
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.1741253
Minimum0
Maximum0.891
Zeros2345
Zeros (%)23.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T06:38:06.467868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.025
median0.177
Q30.263
95-th percentile0.411
Maximum0.891
Range0.891
Interquartile range (IQR)0.238

Descriptive statistics

Standard deviation0.13598154
Coefficient of variation (CV)0.78094071
Kurtosis-0.34599073
Mean0.1741253
Median Absolute Deviation (MAD)0.105
Skewness0.36951402
Sum1741.253
Variance0.018490978
MonotonicityNot monotonic
2023-12-11T06:38:06.652538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 2345
 
23.4%
0.14 103
 
1.0%
0.06 62
 
0.6%
0.186 56
 
0.6%
0.187 49
 
0.5%
0.18 48
 
0.5%
0.175 45
 
0.4%
0.181 44
 
0.4%
0.179 43
 
0.4%
0.184 42
 
0.4%
Other values (554) 7163
71.6%
ValueCountFrequency (%)
0.0 2345
23.4%
0.001 14
 
0.1%
0.002 10
 
0.1%
0.003 4
 
< 0.1%
0.004 8
 
0.1%
0.005 4
 
< 0.1%
0.006 6
 
0.1%
0.007 8
 
0.1%
0.008 9
 
0.1%
0.009 5
 
0.1%
ValueCountFrequency (%)
0.891 1
< 0.1%
0.885 1
< 0.1%
0.805 1
< 0.1%
0.784 1
< 0.1%
0.692 1
< 0.1%
0.671 1
< 0.1%
0.661 1
< 0.1%
0.657 1
< 0.1%
0.652 1
< 0.1%
0.65 1
< 0.1%

탁도측정값(NTU)
Real number (ℝ)

HIGH CORRELATION  SKEWED  ZEROS 

Distinct642
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.1507394
Minimum0
Maximum780.038
Zeros358
Zeros (%)3.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T06:38:06.804832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.5
Q10.793
median1.156
Q32.523
95-th percentile4.895
Maximum780.038
Range780.038
Interquartile range (IQR)1.73

Descriptive statistics

Standard deviation10.079154
Coefficient of variation (CV)4.686367
Kurtosis4359.9063
Mean2.1507394
Median Absolute Deviation (MAD)0.516
Skewness61.638262
Sum21507.394
Variance101.58935
MonotonicityNot monotonic
2023-12-11T06:38:06.960334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 358
 
3.6%
0.779 144
 
1.4%
0.849 133
 
1.3%
0.807 132
 
1.3%
0.542 131
 
1.3%
0.765 125
 
1.2%
0.821 124
 
1.2%
0.528 122
 
1.2%
0.57 119
 
1.2%
0.514 117
 
1.2%
Other values (632) 8495
85.0%
ValueCountFrequency (%)
0.0 358
3.6%
0.02 5
 
0.1%
0.04 9
 
0.1%
0.07 4
 
< 0.1%
0.09 4
 
< 0.1%
0.14 4
 
< 0.1%
0.16 1
 
< 0.1%
0.19 1
 
< 0.1%
0.444 1
 
< 0.1%
0.458 7
 
0.1%
ValueCountFrequency (%)
780.038 1
< 0.1%
539.63 1
< 0.1%
107.324 1
< 0.1%
103.725 1
< 0.1%
64.257 1
< 0.1%
59.165 1
< 0.1%
57.798 1
< 0.1%
57.714 1
< 0.1%
54.854 1
< 0.1%
52.092 1
< 0.1%

배터리전압측정값(V)
Real number (ℝ)

HIGH CORRELATION  SKEWED  ZEROS 

Distinct642
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.1507394
Minimum0
Maximum780.038
Zeros358
Zeros (%)3.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T06:38:07.119492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.5
Q10.793
median1.156
Q32.523
95-th percentile4.895
Maximum780.038
Range780.038
Interquartile range (IQR)1.73

Descriptive statistics

Standard deviation10.079154
Coefficient of variation (CV)4.686367
Kurtosis4359.9063
Mean2.1507394
Median Absolute Deviation (MAD)0.516
Skewness61.638262
Sum21507.394
Variance101.58935
MonotonicityNot monotonic
2023-12-11T06:38:07.278880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 358
 
3.6%
0.779 144
 
1.4%
0.849 133
 
1.3%
0.807 132
 
1.3%
0.542 131
 
1.3%
0.765 125
 
1.2%
0.821 124
 
1.2%
0.528 122
 
1.2%
0.57 119
 
1.2%
0.514 117
 
1.2%
Other values (632) 8495
85.0%
ValueCountFrequency (%)
0.0 358
3.6%
0.02 5
 
0.1%
0.04 9
 
0.1%
0.07 4
 
< 0.1%
0.09 4
 
< 0.1%
0.14 4
 
< 0.1%
0.16 1
 
< 0.1%
0.19 1
 
< 0.1%
0.444 1
 
< 0.1%
0.458 7
 
0.1%
ValueCountFrequency (%)
780.038 1
< 0.1%
539.63 1
< 0.1%
107.324 1
< 0.1%
103.725 1
< 0.1%
64.257 1
< 0.1%
59.165 1
< 0.1%
57.798 1
< 0.1%
57.714 1
< 0.1%
54.854 1
< 0.1%
52.092 1
< 0.1%

Interactions

2023-12-11T06:38:04.287731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:02.789593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.354609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.841698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:04.387632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:02.953038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.507879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.975052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:04.480338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.091996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.617627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:04.069664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:04.592127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.219253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:03.741336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:38:04.171948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:38:07.389485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수온측정값(℃)전기전도도측정값(m/S)탁도측정값(NTU)배터리전압측정값(V)
수온측정값(℃)1.0000.7030.0000.000
전기전도도측정값(m/S)0.7031.0000.0000.000
탁도측정값(NTU)0.0000.0001.0001.000
배터리전압측정값(V)0.0000.0001.0001.000
2023-12-11T06:38:07.485281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수온측정값(℃)전기전도도측정값(m/S)탁도측정값(NTU)배터리전압측정값(V)
수온측정값(℃)1.000-0.100-0.349-0.349
전기전도도측정값(m/S)-0.1001.0000.0720.072
탁도측정값(NTU)-0.3490.0721.0001.000
배터리전압측정값(V)-0.3490.0721.0001.000

Missing values

2023-12-11T06:38:04.730999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T06:38:04.892621image/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

설치장소명디바이스명수집시간보고형태수온측정값(℃)전기전도도측정값(m/S)탁도측정값(NTU)배터리전압측정값(V)
56460호수공원 내 인공호수waterdrone2017-11-13 14:35:00report11.150.1930.5140.514
11139호수공원 내 인공호수waterdrone2018-06-24 13:50:00report28.290.00.8630.863
21366호수공원 내 인공호수waterdrone2018-04-26 13:25:00report17.280.3650.9740.974
8817호수공원 내 인공호수waterdrone2018-07-02 11:25:00report25.310.0910.960.96
59965호수공원 내 인공호수waterdrone2017-10-11 06:30:00report21.840.00.6950.695
50778호수공원 내 인공호수waterdrone2018-01-07 16:05:00report2.230.0161.4071.407
50782호수공원 내 인공호수waterdrone2018-01-07 15:40:00report1.890.041.3371.337
60200호수공원 내 인공호수waterdrone2017-10-10 11:10:00report22.030.00.6260.626
10681호수공원 내 인공호수waterdrone2018-06-26 04:10:00report28.280.00.7230.723
67796호수공원 내 인공호수waterdrone2017-09-13 08:40:00report24.530.3493.6673.667
설치장소명디바이스명수집시간보고형태수온측정값(℃)전기전도도측정값(m/S)탁도측정값(NTU)배터리전압측정값(V)
9112호수공원 내 인공호수waterdrone2018-07-01 10:50:00report26.690.00.7650.765
8128호수공원 내 인공호수waterdrone2018-07-04 18:10:00report28.890.03.6393.639
11892호수공원 내 인공호수waterdrone2018-06-22 00:05:00report27.380.1030.7650.765
22624호수공원 내 인공호수waterdrone2018-04-22 09:05:00report18.310.4540.7790.779
65705호수공원 내 인공호수waterdrone2017-09-20 14:05:00report24.10.2760.7790.779
11956호수공원 내 인공호수waterdrone2018-06-21 18:55:00report27.70.1223.6533.653
47373호수공원 내 인공호수waterdrone2018-01-25 01:30:00report2.480.02.4672.467
53411호수공원 내 인공호수waterdrone2017-12-02 16:15:00report4.010.3190.5980.598
8662호수공원 내 인공호수waterdrone2018-07-02 23:45:00report25.580.0871.0161.016
48887호수공원 내 인공호수waterdrone2018-01-17 23:50:00report3.950.01.7561.756

Duplicate rows

Most frequently occurring

설치장소명디바이스명수집시간보고형태수온측정값(℃)전기전도도측정값(m/S)탁도측정값(NTU)배터리전압측정값(V)# duplicates
0호수공원 내 인공호수waterdrone2017-09-30 11:35:00report22.110.0750.8210.8212
1호수공원 내 인공호수waterdrone2018-04-03 10:55:00report16.410.2181.4351.4352
2호수공원 내 인공호수waterdrone2018-07-07 00:55:00report27.30.0920.8490.8492
3호수공원 내 인공호수waterdrone2018-07-07 01:25:00report27.370.10.8910.8912
4호수공원 내 인공호수waterdrone2018-07-07 02:10:00report27.290.0990.8490.8492
5호수공원 내 인공호수waterdrone2018-07-07 03:50:00report27.120.1770.8490.8492
6호수공원 내 인공호수waterdrone2018-07-07 07:15:00report26.70.1510.8210.8212
7호수공원 내 인공호수waterdrone2018-07-07 08:00:00report26.670.150.8630.8632
8호수공원 내 인공호수waterdrone2018-07-07 13:40:00report27.440.0680.8350.8352
9호수공원 내 인공호수waterdrone2018-07-07 16:05:00report27.810.0080.8910.8912