Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells71
Missing cells (%)0.5%
Duplicate rows2832
Duplicate rows (%)20.4%
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:19:01.797402image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:19:02.204249image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 2832 (20.4%) duplicate rowsDuplicates
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:18:59.459070
Analysis finished2024-05-12 18:19:01.585716
Duration2.13 seconds
MissingQ_Station_NA_29037020_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

NON STATIONARY  SEASONAL 

Distinct5918
Distinct (%)42.9%
Missing71
Missing (%)0.5%
Infinite0
Infinite (%)0.0%
Mean7211.3961
Minimum2092
Maximum14909
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:19:02.922378image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum2092
5-th percentile3047.8
Q15185
median6980
Q39096
95-th percentile12070.6
Maximum14909
Range12817
Interquartile range (IQR)3911

Descriptive statistics

Standard deviation2697.2498
Coefficient of variation (CV)0.37402602
Kurtosis-0.47659774
Mean7211.3961
Median Absolute Deviation (MAD)1953
Skewness0.3421782
Sum99582169
Variance7275156.3
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value5.113459717 × 10-20
2024-05-12T14:19:03.540654image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:19:06.356719image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps8
min3 days
max3 weeks and 5 days
mean1 week, 2 days and 9 hours
std1 week, 1 day and 15 hours
2024-05-12T14:19:06.714370image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
6810 22
 
0.2%
9431 18
 
0.1%
8552 18
 
0.1%
6244 17
 
0.1%
8536 16
 
0.1%
7956 16
 
0.1%
8028 15
 
0.1%
8325 15
 
0.1%
8451 14
 
0.1%
13577 14
 
0.1%
Other values (5908) 13644
98.3%
(Missing) 71
 
0.5%
ValueCountFrequency (%)
2092 1
< 0.1%
2096 1
< 0.1%
2100 1
< 0.1%
2128 1
< 0.1%
2156 1
< 0.1%
2161 1
< 0.1%
2187 1
< 0.1%
2205 1
< 0.1%
2219 1
< 0.1%
2232 1
< 0.1%
ValueCountFrequency (%)
14909 1
 
< 0.1%
14894 1
 
< 0.1%
14879 1
 
< 0.1%
14864 2
< 0.1%
14835 1
 
< 0.1%
14820 4
< 0.1%
14761 1
 
< 0.1%
14746 1
 
< 0.1%
14687 1
 
< 0.1%
14642 1
 
< 0.1%
2024-05-12T14:19:05.774557image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:19:01.304866image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:19:01.499506image/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-016268.0
1983-01-026193.0
1983-01-036035.0
1983-01-045878.0
1983-01-055720.0
1983-01-065585.0
1983-01-075435.0
1983-01-085330.0
1983-01-095195.0
1983-01-105027.0
Flow
Date
2020-12-2210371.0
2020-12-2310342.0
2020-12-2410281.0
2020-12-2510209.0
2020-12-2610137.0
2020-12-2710060.0
2020-12-2810020.0
2020-12-299951.3
2020-12-309871.2
2020-12-319802.2

Duplicate rows

Most frequently occurring

Flow# duplicates
2831NaN71
13776810.022
19628552.018
22279431.018
11766244.017
17957956.016
19598536.016
18158028.015
19028325.015
8815540.014