Overview

Dataset statistics

Number of variables7
Number of observations720
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory43.7 KiB
Average record size in memory62.2 B

Variable types

DateTime1
Categorical5
Numeric1

Dataset

Description제주특별자치도개발공사가 운영하는 제주삼다수 제1,2취수원의 감시정 6개를 통해 관리 및 수집하는 제주지역 지하수 수온 정보 입니다.
Author제주특별자치도개발공사
URLhttps://www.data.go.kr/data/15103551/fileData.do

Alerts

1수원 감시정1 has constant value ""Constant
1수원 감시정2 has constant value ""Constant
1수원 감시정3 is highly imbalanced (71.3%)Imbalance
2수원 감시정1 is highly imbalanced (64.1%)Imbalance
2수원 감시정3 is highly imbalanced (98.5%)Imbalance
관측소명 has unique valuesUnique

Reproduction

Analysis started2024-05-11 07:49:26.764171
Analysis finished2024-05-11 07:49:27.950258
Duration1.19 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관측소명
Date

UNIQUE 

Distinct720
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
Minimum2024-04-01 00:00:00
Maximum2024-04-30 23:00:00
2024-05-11T16:49:28.113136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:49:28.419691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

1수원 감시정1
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
13.81
720 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row13.81
2nd row13.81
3rd row13.81
4th row13.81
5th row13.81

Common Values

ValueCountFrequency (%)
13.81 720
100.0%

Length

2024-05-11T16:49:28.684949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T16:49:29.033417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
13.81 720
100.0%

1수원 감시정2
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
13.63
720 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row13.63
2nd row13.63
3rd row13.63
4th row13.63
5th row13.63

Common Values

ValueCountFrequency (%)
13.63 720
100.0%

Length

2024-05-11T16:49:29.310874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T16:49:29.517688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
13.63 720
100.0%

1수원 감시정3
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
14.01
666 
14.02
 
34
14.0
 
20

Length

Max length5
Median length5
Mean length4.9722222
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row14.01
2nd row14.01
3rd row14.01
4th row14.01
5th row14.01

Common Values

ValueCountFrequency (%)
14.01 666
92.5%
14.02 34
 
4.7%
14.0 20
 
2.8%

Length

2024-05-11T16:49:29.788343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T16:49:30.024416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
14.01 666
92.5%
14.02 34
 
4.7%
14.0 20
 
2.8%

2수원 감시정1
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
13.53
671 
13.54
 
49

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row13.54
2nd row13.53
3rd row13.53
4th row13.53
5th row13.54

Common Values

ValueCountFrequency (%)
13.53 671
93.2%
13.54 49
 
6.8%

Length

2024-05-11T16:49:30.221551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T16:49:30.427314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
13.53 671
93.2%
13.54 49
 
6.8%

2수원 감시정2
Real number (ℝ)

Distinct23
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.657792
Minimum13.64
Maximum13.86
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.5 KiB
2024-05-11T16:49:30.625858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum13.64
5-th percentile13.64
Q113.64
median13.64
Q313.65
95-th percentile13.7705
Maximum13.86
Range0.22
Interquartile range (IQR)0.01

Descriptive statistics

Standard deviation0.042811304
Coefficient of variation (CV)0.00313457
Kurtosis9.7365676
Mean13.657792
Median Absolute Deviation (MAD)0
Skewness3.2339955
Sum9833.61
Variance0.0018328077
MonotonicityNot monotonic
2024-05-11T16:49:30.868024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
13.64 366
50.8%
13.65 268
37.2%
13.66 5
 
0.7%
13.67 5
 
0.7%
13.78 4
 
0.6%
13.86 4
 
0.6%
13.85 4
 
0.6%
13.84 4
 
0.6%
13.83 4
 
0.6%
13.82 4
 
0.6%
Other values (13) 52
 
7.2%
ValueCountFrequency (%)
13.64 366
50.8%
13.65 268
37.2%
13.66 5
 
0.7%
13.67 5
 
0.7%
13.68 4
 
0.6%
13.69 4
 
0.6%
13.7 4
 
0.6%
13.71 4
 
0.6%
13.72 4
 
0.6%
13.73 4
 
0.6%
ValueCountFrequency (%)
13.86 4
0.6%
13.85 4
0.6%
13.84 4
0.6%
13.83 4
0.6%
13.82 4
0.6%
13.81 4
0.6%
13.8 4
0.6%
13.79 4
0.6%
13.78 4
0.6%
13.77 4
0.6%

2수원 감시정3
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.8 KiB
13.62
719 
13.65
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row13.62
2nd row13.62
3rd row13.62
4th row13.62
5th row13.62

Common Values

ValueCountFrequency (%)
13.62 719
99.9%
13.65 1
 
0.1%

Length

2024-05-11T16:49:31.134766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T16:49:31.342092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
13.62 719
99.9%
13.65 1
 
0.1%

Interactions

2024-05-11T16:49:27.193397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T16:49:31.466848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
1수원 감시정32수원 감시정12수원 감시정22수원 감시정3
1수원 감시정31.0000.1320.6510.000
2수원 감시정10.1321.0000.5230.000
2수원 감시정20.6510.5231.0000.000
2수원 감시정30.0000.0000.0001.000
2024-05-11T16:49:31.675984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2수원 감시정12수원 감시정31수원 감시정3
2수원 감시정11.0000.0000.218
2수원 감시정30.0001.0000.000
1수원 감시정30.2180.0001.000
2024-05-11T16:49:31.944808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2수원 감시정21수원 감시정32수원 감시정12수원 감시정3
2수원 감시정21.0000.4970.4110.000
1수원 감시정30.4971.0000.2180.000
2수원 감시정10.4110.2181.0000.000
2수원 감시정30.0000.0000.0001.000

Missing values

2024-05-11T16:49:27.440060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T16:49:27.749454image/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

관측소명1수원 감시정11수원 감시정21수원 감시정32수원 감시정12수원 감시정22수원 감시정3
02024-04-01 00:0013.8113.6314.0113.5413.6513.62
12024-04-01 01:0013.8113.6314.0113.5313.6513.62
22024-04-01 02:0013.8113.6314.0113.5313.6513.62
32024-04-01 03:0013.8113.6314.0113.5313.6513.62
42024-04-01 04:0013.8113.6314.0113.5413.6513.62
52024-04-01 05:0013.8113.6314.0113.5313.6513.62
62024-04-01 06:0013.8113.6314.0113.5313.6513.62
72024-04-01 07:0013.8113.6314.0113.5313.6513.62
82024-04-01 08:0013.8113.6314.0113.5413.6513.62
92024-04-01 09:0013.8113.6314.0113.5313.6513.62
관측소명1수원 감시정11수원 감시정21수원 감시정32수원 감시정12수원 감시정22수원 감시정3
7102024-04-30 14:0013.8113.6314.013.5313.8413.62
7112024-04-30 15:0013.8113.6314.013.5413.8413.62
7122024-04-30 16:0013.8113.6314.013.5313.8513.62
7132024-04-30 17:0013.8113.6314.013.5413.8513.62
7142024-04-30 18:0013.8113.6314.013.5413.8513.62
7152024-04-30 19:0013.8113.6314.0113.5313.8513.62
7162024-04-30 20:0013.8113.6314.013.5313.8613.62
7172024-04-30 21:0013.8113.6314.013.5413.8613.62
7182024-04-30 22:0013.8113.6314.0113.5413.8613.62
7192024-04-30 23:0013.8113.6314.013.5313.8613.62