Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells98
Missing cells (%)0.7%
Duplicate rows1710
Duplicate rows (%)12.3%
Total size in memory216.9 KiB
Average record size in memory16.0 B

Variable types

TimeSeries1

Timeseries statistics

Number of series1
Time series length13880
Starting point1983-01-01 00:00:00
Ending point2020-12-31 00:00:00
Period1 day
2024-05-12T14:16:11.153847image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:16:11.434943image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1710 (12.3%) duplicate rowsDuplicates
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:16:08.605738
Analysis finished2024-05-12 18:16:11.083720
Duration2.48 seconds
MissingQ_Station_NA_21137010_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

NON STATIONARY  SEASONAL 

Distinct5335
Distinct (%)38.7%
Missing98
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean776.19456
Minimum148
Maximum4247
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:16:11.988736image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum148
5-th percentile302
Q1484
median701.2
Q3974
95-th percentile1485.355
Maximum4247
Range4099
Interquartile range (IQR)490

Descriptive statistics

Standard deviation401.53669
Coefficient of variation (CV)0.51731449
Kurtosis6.1447639
Mean776.19456
Median Absolute Deviation (MAD)237.57
Skewness1.7111346
Sum10697513
Variance161231.71
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value7.614086678 × 10-25
2024-05-12T14:16:12.441039image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:16:13.696351image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps8
min3 days
max8 weeks and 6 days
mean1 week, 5 days and 15 hours
std2 weeks, 6 days and 1 hour
2024-05-12T14:16:14.162686image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
346 23
 
0.2%
405 23
 
0.2%
390 22
 
0.2%
410 21
 
0.2%
516 21
 
0.2%
476 20
 
0.1%
416 19
 
0.1%
487 19
 
0.1%
485 19
 
0.1%
568 19
 
0.1%
Other values (5325) 13576
97.8%
(Missing) 98
 
0.7%
ValueCountFrequency (%)
148 1
< 0.1%
150 1
< 0.1%
152 1
< 0.1%
153 2
< 0.1%
155 1
< 0.1%
157 1
< 0.1%
158 1
< 0.1%
159 2
< 0.1%
160 1
< 0.1%
161 1
< 0.1%
ValueCountFrequency (%)
4247 1
< 0.1%
4135 1
< 0.1%
4104 1
< 0.1%
3906 1
< 0.1%
3905.9 1
< 0.1%
3791 1
< 0.1%
3765 1
< 0.1%
3701 1
< 0.1%
3642 1
< 0.1%
3617 1
< 0.1%
2024-05-12T14:16:12.905786image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

2024-05-12T14:16:10.550333image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Missing values

2024-05-12T14:16:10.857511image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:16:11.033242image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

Flow
Date
1983-01-01642.0
1983-01-02535.0
1983-01-03586.0
1983-01-04842.0
1983-01-051111.0
1983-01-06921.0
1983-01-07895.0
1983-01-08934.0
1983-01-09655.0
1983-01-10551.0
Flow
Date
2020-12-22784.87
2020-12-231008.50
2020-12-24457.19
2020-12-25548.71
2020-12-261067.40
2020-12-27744.43
2020-12-28857.33
2020-12-291110.50
2020-12-30956.61
2020-12-31522.41

Duplicate rows

Most frequently occurring

Flow# duplicates
1709NaN98
159346.023
254405.023
231390.022
263410.021
430516.021
370476.020
274416.019
369475.019
386485.019