Overview

Dataset statistics

Number of variables5
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory46.3 B

Variable types

Numeric4
Categorical1

Alerts

일자() has constant value ""Constant
호수위() is highly overall correlated with 해수위()High correlation
해수위() is highly overall correlated with 호수위() and 1 other fieldsHigh correlation
수위차이() is highly overall correlated with 해수위()High correlation
순번() has unique valuesUnique

Reproduction

Analysis started2023-12-10 12:33:13.260220
Analysis finished2023-12-10 12:33:16.978440
Duration3.72 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번()
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4510.5
Minimum4461
Maximum4560
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:33:17.102027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4461
5-th percentile4465.95
Q14485.75
median4510.5
Q34535.25
95-th percentile4555.05
Maximum4560
Range99
Interquartile range (IQR)49.5

Descriptive statistics

Standard deviation29.011492
Coefficient of variation (CV)0.0064319902
Kurtosis-1.2
Mean4510.5
Median Absolute Deviation (MAD)25
Skewness0
Sum451050
Variance841.66667
MonotonicityStrictly decreasing
2023-12-10T21:33:17.323305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4560 1
 
1.0%
4496 1
 
1.0%
4486 1
 
1.0%
4487 1
 
1.0%
4488 1
 
1.0%
4489 1
 
1.0%
4490 1
 
1.0%
4491 1
 
1.0%
4492 1
 
1.0%
4493 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
4461 1
1.0%
4462 1
1.0%
4463 1
1.0%
4464 1
1.0%
4465 1
1.0%
4466 1
1.0%
4467 1
1.0%
4468 1
1.0%
4469 1
1.0%
4470 1
1.0%
ValueCountFrequency (%)
4560 1
1.0%
4559 1
1.0%
4558 1
1.0%
4557 1
1.0%
4556 1
1.0%
4555 1
1.0%
4554 1
1.0%
4553 1
1.0%
4552 1
1.0%
4551 1
1.0%

일자()
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20211111
100 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20211111 100
100.0%

Length

2023-12-10T21:33:17.597937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:33:17.848410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20211111 100
100.0%

호수위()
Real number (ℝ)

HIGH CORRELATION 

Distinct66
Distinct (%)66.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1.7215
Minimum-2.48
Maximum-0.99
Zeros0
Zeros (%)0.0%
Negative100
Negative (%)100.0%
Memory size1.0 KiB
2023-12-10T21:33:18.055681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-2.48
5-th percentile-2.45
Q1-2.1
median-1.845
Q3-1.21
95-th percentile-1.01
Maximum-0.99
Range1.49
Interquartile range (IQR)0.89

Descriptive statistics

Standard deviation0.49842454
Coefficient of variation (CV)-0.28952921
Kurtosis-1.4122404
Mean-1.7215
Median Absolute Deviation (MAD)0.39
Skewness0.15985
Sum-172.15
Variance0.24842702
MonotonicityNot monotonic
2023-12-10T21:33:18.377526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-2.1 11
 
11.0%
-2.11 5
 
5.0%
-1.01 4
 
4.0%
-2.45 3
 
3.0%
-1.05 3
 
3.0%
-1.0 3
 
3.0%
-1.02 3
 
3.0%
-2.12 3
 
3.0%
-2.44 2
 
2.0%
-2.06 2
 
2.0%
Other values (56) 61
61.0%
ValueCountFrequency (%)
-2.48 1
 
1.0%
-2.47 1
 
1.0%
-2.46 1
 
1.0%
-2.45 3
3.0%
-2.44 2
2.0%
-2.43 1
 
1.0%
-2.42 1
 
1.0%
-2.41 1
 
1.0%
-2.39 1
 
1.0%
-2.37 1
 
1.0%
ValueCountFrequency (%)
-0.99 1
 
1.0%
-1.0 3
3.0%
-1.01 4
4.0%
-1.02 3
3.0%
-1.03 2
2.0%
-1.04 1
 
1.0%
-1.05 3
3.0%
-1.06 1
 
1.0%
-1.07 1
 
1.0%
-1.1 1
 
1.0%

해수위()
Real number (ℝ)

HIGH CORRELATION 

Distinct95
Distinct (%)95.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.6907
Minimum-2.67
Maximum1.72
Zeros0
Zeros (%)0.0%
Negative66
Negative (%)66.0%
Memory size1.0 KiB
2023-12-10T21:33:18.659773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-2.67
5-th percentile-2.551
Q1-2.0325
median-0.995
Q30.685
95-th percentile1.651
Maximum1.72
Range4.39
Interquartile range (IQR)2.7175

Descriptive statistics

Standard deviation1.4601524
Coefficient of variation (CV)-2.1140182
Kurtosis-1.3372391
Mean-0.6907
Median Absolute Deviation (MAD)1.2
Skewness0.32903977
Sum-69.07
Variance2.132045
MonotonicityNot monotonic
2023-12-10T21:33:18.871413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-2.03 2
 
2.0%
-2.19 2
 
2.0%
1.72 2
 
2.0%
-1.37 2
 
2.0%
-2.63 2
 
2.0%
-0.01 1
 
1.0%
-1.42 1
 
1.0%
-1.24 1
 
1.0%
-1.07 1
 
1.0%
-0.9 1
 
1.0%
Other values (85) 85
85.0%
ValueCountFrequency (%)
-2.67 1
1.0%
-2.65 1
1.0%
-2.63 2
2.0%
-2.57 1
1.0%
-2.55 1
1.0%
-2.52 1
1.0%
-2.48 1
1.0%
-2.45 1
1.0%
-2.39 1
1.0%
-2.34 1
1.0%
ValueCountFrequency (%)
1.72 2
2.0%
1.71 1
1.0%
1.69 1
1.0%
1.67 1
1.0%
1.65 1
1.0%
1.63 1
1.0%
1.61 1
1.0%
1.57 1
1.0%
1.56 1
1.0%
1.52 1
1.0%

수위차이()
Real number (ℝ)

HIGH CORRELATION 

Distinct83
Distinct (%)83.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1.0308
Minimum-3.34
Maximum0.35
Zeros0
Zeros (%)0.0%
Negative63
Negative (%)63.0%
Memory size1.0 KiB
2023-12-10T21:33:19.082173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-3.34
5-th percentile-3.3005
Q1-2.2225
median-0.565
Q30.1425
95-th percentile0.29
Maximum0.35
Range3.69
Interquartile range (IQR)2.365

Descriptive statistics

Standard deviation1.3044792
Coefficient of variation (CV)-1.2655018
Kurtosis-1.2205958
Mean-1.0308
Median Absolute Deviation (MAD)0.815
Skewness-0.58817722
Sum-103.08
Variance1.701666
MonotonicityNot monotonic
2023-12-10T21:33:19.310047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.28 4
 
4.0%
0.25 4
 
4.0%
0.09 3
 
3.0%
0.15 2
 
2.0%
0.03 2
 
2.0%
0.32 2
 
2.0%
0.29 2
 
2.0%
0.26 2
 
2.0%
0.24 2
 
2.0%
-3.23 2
 
2.0%
Other values (73) 75
75.0%
ValueCountFrequency (%)
-3.34 1
1.0%
-3.33 1
1.0%
-3.32 1
1.0%
-3.31 2
2.0%
-3.3 1
1.0%
-3.28 1
1.0%
-3.23 2
2.0%
-3.17 1
1.0%
-3.1 1
1.0%
-3.08 1
1.0%
ValueCountFrequency (%)
0.35 1
 
1.0%
0.32 2
2.0%
0.31 1
 
1.0%
0.29 2
2.0%
0.28 4
4.0%
0.26 2
2.0%
0.25 4
4.0%
0.24 2
2.0%
0.22 1
 
1.0%
0.21 1
 
1.0%

Interactions

2023-12-10T21:33:15.992818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:13.464874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:14.368649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:15.044200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:16.216626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:13.602504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:14.512538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:15.370750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:16.413929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:13.741219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:14.659175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:15.542166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:16.550151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:14.210009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:14.877715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:33:15.738423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T21:33:19.455641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번()호수위()해수위()수위차이()
순번()1.0000.9100.8770.849
호수위()0.9101.0000.7230.463
해수위()0.8770.7231.0000.863
수위차이()0.8490.4630.8631.000
2023-12-10T21:33:19.602741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번()호수위()해수위()수위차이()
순번()1.000-0.235-0.1670.073
호수위()-0.2351.0000.527-0.178
해수위()-0.1670.5271.000-0.902
수위차이()0.073-0.178-0.9021.000

Missing values

2023-12-10T21:33:16.765370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T21:33:16.920894image/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

순번()일자()호수위()해수위()수위차이()
0456020211111-2.44-1.55-0.89
1455920211111-2.45-1.72-0.73
2455820211111-2.45-1.87-0.58
3455720211111-2.45-2.04-0.41
4455620211111-2.43-2.19-0.24
5455520211111-2.42-2.34-0.08
6455420211111-2.39-2.450.06
7455320211111-2.44-2.520.08
8455220211111-2.46-2.550.09
9455120211111-2.48-2.630.15
순번()일자()호수위()해수위()수위차이()
90447020211111-1.34-1.470.13
91446920211111-1.23-1.370.14
92446820211111-1.13-1.220.09
93446720211111-1.05-1.080.03
94446620211111-1.01-0.94-0.07
95446520211111-1.0-0.75-0.25
96446420211111-1.01-0.57-0.44
97446320211111-1.03-0.39-0.64
98446220211111-1.02-0.2-0.82
99446120211111-1.060.01-1.07