Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells10000
Missing cells (%)14.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory654.3 KiB
Average record size in memory67.0 B

Variable types

Categorical4
DateTime1
Numeric1
Unsupported1

Dataset

Description국가해양관측망 실측파고(대천해수욕장)
Author충청남도
URLhttps://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=2682

Alerts

관측소 명 has constant value ""Constant
관측소 위도 is highly overall correlated with 관측소 ID and 1 other fieldsHigh correlation
관측소 ID is highly overall correlated with 관측소 위도 and 1 other fieldsHigh correlation
관측소 경도 is highly overall correlated with 관측소 ID and 1 other fieldsHigh correlation
관측소 ID is highly imbalanced (55.0%)Imbalance
관측소 위도 is highly imbalanced (95.3%)Imbalance
금일요청가능횟수 has 10000 (100.0%) missing valuesMissing
관측시간 has unique valuesUnique
금일요청가능횟수 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-09 23:16:42.668205
Analysis finished2024-01-09 23:16:43.212431
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관측소 ID
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
126.457805
7777 
126.4578
1961 
126.45781
 
210
TW_0069
 
52

Length

Max length10
Median length10
Mean length9.5712
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row126.45781
2nd row126.457805
3rd row126.4578
4th row126.457805
5th row126.4578

Common Values

ValueCountFrequency (%)
126.457805 7777
77.8%
126.4578 1961
 
19.6%
126.45781 210
 
2.1%
TW_0069 52
 
0.5%

Length

2024-01-10T08:16:43.269217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:16:43.358297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
126.457805 7777
77.8%
126.4578 1961
 
19.6%
126.45781 210
 
2.1%
tw_0069 52
 
0.5%

관측소 명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
대천해수욕장
10000 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대천해수욕장
2nd row대천해수욕장
3rd row대천해수욕장
4th row대천해수욕장
5th row대천해수욕장

Common Values

ValueCountFrequency (%)
대천해수욕장 10000
100.0%

Length

2024-01-10T08:16:43.447522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:16:43.524991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대천해수욕장 10000
100.0%

관측소 위도
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
TW_0069
9948 
36.274111
 
52

Length

Max length9
Median length7
Mean length7.0104
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
TW_0069 9948
99.5%
36.274111 52
 
0.5%

Length

2024-01-10T08:16:43.614059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:16:43.705467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
tw_0069 9948
99.5%
36.274111 52
 
0.5%

관측소 경도
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
36.274111
7777 
36.27411
2171 
126.457805
 
52

Length

Max length10
Median length9
Mean length8.7881
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row36.27411
2nd row36.274111
3rd row36.27411
4th row36.274111
5th row36.27411

Common Values

ValueCountFrequency (%)
36.274111 7777
77.8%
36.27411 2171
 
21.7%
126.457805 52
 
0.5%

Length

2024-01-10T08:16:43.814566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:16:43.927409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
36.274111 7777
77.8%
36.27411 2171
 
21.7%
126.457805 52
 
0.5%

관측시간
Date

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-11-01 00:25:00
Maximum2023-10-25 23:55:00
2024-01-10T08:16:44.049757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T08:16:44.190371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

파고
Real number (ℝ)

Distinct160
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.345487
Minimum0
Maximum2.08
Zeros27
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T08:16:44.308054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.1
Q10.19
median0.28
Q30.45
95-th percentile0.82
Maximum2.08
Range2.08
Interquartile range (IQR)0.26

Descriptive statistics

Standard deviation0.23920983
Coefficient of variation (CV)0.69238447
Kurtosis4.420508
Mean0.345487
Median Absolute Deviation (MAD)0.12
Skewness1.772336
Sum3454.87
Variance0.057221345
MonotonicityNot monotonic
2024-01-10T08:16:44.432172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.2 1001
 
10.0%
0.3 626
 
6.3%
0.1 491
 
4.9%
0.4 296
 
3.0%
0.21 253
 
2.5%
0.19 245
 
2.5%
0.5 237
 
2.4%
0.17 234
 
2.3%
0.16 233
 
2.3%
0.23 222
 
2.2%
Other values (150) 6162
61.6%
ValueCountFrequency (%)
0.0 27
 
0.3%
0.05 11
 
0.1%
0.06 22
 
0.2%
0.07 42
 
0.4%
0.08 89
 
0.9%
0.09 121
 
1.2%
0.1 491
4.9%
0.11 130
 
1.3%
0.12 151
 
1.5%
0.13 159
 
1.6%
ValueCountFrequency (%)
2.08 1
< 0.1%
1.87 2
< 0.1%
1.85 2
< 0.1%
1.84 1
< 0.1%
1.77 1
< 0.1%
1.75 2
< 0.1%
1.72 1
< 0.1%
1.66 2
< 0.1%
1.64 1
< 0.1%
1.61 2
< 0.1%

금일요청가능횟수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

Interactions

2024-01-10T08:16:42.960192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T08:16:44.520362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관측소 ID관측소 위도관측소 경도파고
관측소 ID1.0001.0001.0000.190
관측소 위도1.0001.0001.0000.016
관측소 경도1.0001.0001.0000.220
파고0.1900.0160.2201.000
2024-01-10T08:16:44.618098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관측소 위도관측소 ID관측소 경도
관측소 위도1.0001.0001.000
관측소 ID1.0001.0001.000
관측소 경도1.0001.0001.000
2024-01-10T08:16:44.716547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
파고관측소 ID관측소 위도관측소 경도
파고1.0000.1150.0130.134
관측소 ID0.1151.0001.0001.000
관측소 위도0.0131.0001.0001.000
관측소 경도0.1341.0001.0001.000

Missing values

2024-01-10T08:16:43.053555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T08:16:43.165695image/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

관측소 ID관측소 명관측소 위도관측소 경도관측시간파고금일요청가능횟수
46264126.45781대천해수욕장TW_006936.274112023-08-30 21:550.2<NA>
344126.457805대천해수욕장TW_006936.2741112023-01-18 05:200.27<NA>
47290126.4578대천해수욕장TW_006936.274112023-09-08 12:250.2<NA>
31856126.457805대천해수욕장TW_006936.2741112023-06-13 04:200.17<NA>
50003126.4578대천해수욕장TW_006936.274112023-09-20 00:150.1<NA>
195TW_0069대천해수욕장36.274111126.4578052022-11-01 16:350.3<NA>
21098126.457805대천해수욕장TW_006936.2741112023-04-25 01:100.18<NA>
9669126.457805대천해수욕장TW_006936.2741112023-03-02 07:200.68<NA>
53404126.4578대천해수욕장TW_006936.274112023-10-10 23:300.2<NA>
16069126.457805대천해수욕장TW_006936.2741112023-03-25 06:300.41<NA>
관측소 ID관측소 명관측소 위도관측소 경도관측시간파고금일요청가능횟수
41440126.457805대천해수욕장TW_006936.2741112023-07-24 20:550.22<NA>
38849126.457805대천해수욕장TW_006936.2741112023-07-15 18:401.09<NA>
32401126.457805대천해수욕장TW_006936.2741112023-06-17 02:200.12<NA>
43066126.457805대천해수욕장TW_006936.2741112023-08-10 14:000.45<NA>
26792126.457805대천해수욕장TW_006936.2741112023-05-26 07:000.18<NA>
46234126.45781대천해수욕장TW_006936.274112023-08-30 19:250.2<NA>
34457126.457805대천해수욕장TW_006936.2741112023-06-24 07:250.17<NA>
13491126.457805대천해수욕장TW_006936.2741112023-03-16 01:550.5<NA>
38449126.457805대천해수욕장TW_006936.2741112023-07-14 08:451.59<NA>
42058126.457805대천해수욕장TW_006936.2741112023-08-03 01:150.21<NA>