Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory478.5 KiB
Average record size in memory49.0 B

Variable types

Categorical3
DateTime1
Numeric1

Dataset

Description광주광역시 북구 지하수보조관측망시간별수위측정정보로 관측소이름, 관측일자, 관측시간, 수위 항목을 반기단위로 정기 제공하고 있습니다.
Author광주광역시 북구
URLhttps://www.data.go.kr/data/15066535/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
수위(미터) is highly overall correlated with 관측소이름High correlation
관측소이름 is highly overall correlated with 수위(미터)High correlation

Reproduction

Analysis started2024-04-06 08:31:06.373000
Analysis finished2024-04-06 08:31:09.478891
Duration3.11 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관측소이름
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
양산초교
3556 
(B)대촌
1953 
용주어린이공원
1875 
(B)두암
1323 
동운초등학교
1293 

Length

Max length7
Median length6
Mean length5.1487
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동운초등학교
2nd row(B)두암
3rd row(B)두암
4th row양산초교
5th row용주어린이공원

Common Values

ValueCountFrequency (%)
양산초교 3556
35.6%
(B)대촌 1953
19.5%
용주어린이공원 1875
18.8%
(B)두암 1323
 
13.2%
동운초등학교 1293
 
12.9%

Length

2024-04-06T17:31:09.612160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:31:09.830515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양산초교 3556
35.6%
b)대촌 1953
19.5%
용주어린이공원 1875
18.8%
b)두암 1323
 
13.2%
동운초등학교 1293
 
12.9%

관측일자
Date

Distinct2334
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-11-24 00:00:00
Maximum2024-03-20 00:00:00
2024-04-06T17:31:10.095393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:31:10.336100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

관측시간
Categorical

Distinct24
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
15:00
 
452
23:00
 
449
11:00
 
443
14:00
 
439
09:00
 
433
Other values (19)
7784 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row04:00
2nd row03:00
3rd row17:00
4th row16:00
5th row15:00

Common Values

ValueCountFrequency (%)
15:00 452
 
4.5%
23:00 449
 
4.5%
11:00 443
 
4.4%
14:00 439
 
4.4%
09:00 433
 
4.3%
01:00 429
 
4.3%
07:00 426
 
4.3%
21:00 426
 
4.3%
12:00 425
 
4.2%
04:00 425
 
4.2%
Other values (14) 5653
56.5%

Length

2024-04-06T17:31:10.558373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
15:00 452
 
4.5%
23:00 449
 
4.5%
11:00 443
 
4.4%
14:00 439
 
4.4%
09:00 433
 
4.3%
01:00 429
 
4.3%
07:00 426
 
4.3%
21:00 426
 
4.3%
12:00 425
 
4.2%
04:00 425
 
4.2%
Other values (14) 5653
56.5%

수위(미터)
Real number (ℝ)

HIGH CORRELATION 

Distinct2483
Distinct (%)24.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.5741431
Minimum0.92
Maximum39.9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:31:10.828162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.92
5-th percentile2.58
Q13.61
median4.78
Q311.14325
95-th percentile12.77
Maximum39.9
Range38.98
Interquartile range (IQR)7.5332498

Descriptive statistics

Standard deviation3.8632542
Coefficient of variation (CV)0.58764376
Kurtosis-0.54917446
Mean6.5741431
Median Absolute Deviation (MAD)1.55
Skewness0.78525891
Sum65741.431
Variance14.924733
MonotonicityNot monotonic
2024-04-06T17:31:11.154281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.76 70
 
0.7%
3.75 59
 
0.6%
3.77 55
 
0.5%
3.72 50
 
0.5%
5.2 49
 
0.5%
3.73 47
 
0.5%
5.41 47
 
0.5%
5.27 46
 
0.5%
3.78 44
 
0.4%
3.35 43
 
0.4%
Other values (2473) 9490
94.9%
ValueCountFrequency (%)
0.92 1
 
< 0.1%
1.54 1
 
< 0.1%
1.55 1
 
< 0.1%
1.58 1
 
< 0.1%
1.6 1
 
< 0.1%
1.68 1
 
< 0.1%
1.71 2
< 0.1%
1.72 1
 
< 0.1%
1.73 3
< 0.1%
1.74 4
< 0.1%
ValueCountFrequency (%)
39.9 1
< 0.1%
19.84 1
< 0.1%
17.967 1
< 0.1%
17.807 1
< 0.1%
17.621 1
< 0.1%
17.4 1
< 0.1%
17.2 1
< 0.1%
17.19 1
< 0.1%
16.903 1
< 0.1%
16.72 1
< 0.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-22
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-22
2nd row2024-03-22
3rd row2024-03-22
4th row2024-03-22
5th row2024-03-22

Common Values

ValueCountFrequency (%)
2024-03-22 10000
100.0%

Length

2024-04-06T17:31:11.440196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:31:11.629476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-22 10000
100.0%

Interactions

2024-04-06T17:31:08.614957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:31:11.750200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관측소이름관측시간수위(미터)
관측소이름1.0000.0000.716
관측시간0.0001.0000.095
수위(미터)0.7160.0951.000
2024-04-06T17:31:11.933314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관측소이름관측시간
관측소이름1.0000.000
관측시간0.0001.000
2024-04-06T17:31:12.109173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수위(미터)관측소이름관측시간
수위(미터)1.0000.5830.038
관측소이름0.5831.0000.000
관측시간0.0380.0001.000

Missing values

2024-04-06T17:31:09.222780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:31:09.387695image/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

관측소이름관측일자관측시간수위(미터)데이터기준일자
87250동운초등학교2020-06-2504:003.292024-03-22
32192(B)두암2024-02-2603:003.132024-03-22
30841(B)두암2023-12-3117:003.222024-03-22
60623양산초교2023-04-2616:0012.9152024-03-22
76852용주어린이공원2020-11-1115:005.192024-03-22
43800양산초교2019-04-0713:0012.362024-03-22
88929동운초등학교2020-09-0306:001.942024-03-22
32089(B)두암2024-02-2120:003.242024-03-22
82884용주어린이공원2021-07-2023:004.952024-03-22
37335양산초교2018-06-1820:0012.832024-03-22
관측소이름관측일자관측시간수위(미터)데이터기준일자
91623동운초등학교2020-12-2502:003.432024-03-22
35323양산초교2018-03-2700:0013.232024-03-22
80484용주어린이공원2021-04-1123:005.212024-03-22
15788(B)대촌2022-11-2000:003.762024-03-22
42668양산초교2019-02-1909:0011.572024-03-22
39299양산초교2018-09-0816:0011.082024-03-22
51951양산초교2022-04-2821:0012.382024-03-22
80286용주어린이공원2021-04-0317:005.112024-03-22
42515양산초교2019-02-1300:0011.582024-03-22
48982양산초교2021-12-2601:0011.212024-03-22