Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells76
Missing cells (%)0.5%
Duplicate rows1895
Duplicate rows (%)13.7%
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:17:34.982614image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:17:35.386854image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1895 (13.7%) duplicate rowsDuplicates
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:17:32.289640
Analysis finished2024-05-12 18:17:34.876678
Duration2.59 seconds
MissingQ_Station_NA_26207080_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

NON STATIONARY  SEASONAL 

Distinct5567
Distinct (%)40.3%
Missing76
Missing (%)0.5%
Infinite0
Infinite (%)0.0%
Mean842.96732
Minimum135.23
Maximum3183.2
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:17:36.129583image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum135.23
5-th percentile323
Q1491
median724.135
Q31092
95-th percentile1729.85
Maximum3183.2
Range3047.97
Interquartile range (IQR)601

Descriptive statistics

Standard deviation460.17439
Coefficient of variation (CV)0.54589825
Kurtosis1.8190493
Mean842.96732
Median Absolute Deviation (MAD)273.69
Skewness1.2572127
Sum11636321
Variance211760.46
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value3.693264709 × 10-16
2024-05-12T14:17:36.769435image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:17:38.894499image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps10
min3 days
max3 weeks and 6 days
mean1 week, 4 hours and 48 minutes
std1 week, 13 hours and 39 minutes
2024-05-12T14:17:39.321326image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
648 23
 
0.2%
442 22
 
0.2%
436 21
 
0.2%
472 21
 
0.2%
540 21
 
0.2%
560 20
 
0.1%
450 20
 
0.1%
657 19
 
0.1%
619 18
 
0.1%
910 18
 
0.1%
Other values (5557) 13601
98.0%
(Missing) 76
 
0.5%
ValueCountFrequency (%)
135.23 1
< 0.1%
139.27 1
< 0.1%
139.35 1
< 0.1%
139.5 1
< 0.1%
140.89 1
< 0.1%
144.51 1
< 0.1%
145.06 1
< 0.1%
145.45 1
< 0.1%
146.17 1
< 0.1%
147.14 1
< 0.1%
ValueCountFrequency (%)
3183.2 1
 
< 0.1%
3035 1
 
< 0.1%
3029 1
 
< 0.1%
3012 1
 
< 0.1%
2998.1 1
 
< 0.1%
2946 1
 
< 0.1%
2931 5
< 0.1%
2916 1
 
< 0.1%
2904 1
 
< 0.1%
2901 5
< 0.1%
2024-05-12T14:17:38.136585image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:17:34.572667image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:17:34.784380image/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-01910.0
1983-01-02842.0
1983-01-03829.0
1983-01-04787.0
1983-01-05730.0
1983-01-06695.0
1983-01-07723.0
1983-01-08706.0
1983-01-09679.0
1983-01-10653.0
Flow
Date
2020-12-22572.51
2020-12-23548.03
2020-12-24579.82
2020-12-25738.92
2020-12-261019.60
2020-12-271025.10
2020-12-281209.30
2020-12-291250.00
2020-12-301211.10
2020-12-31NaN

Duplicate rows

Most frequently occurring

Flow# duplicates
1894NaN76
676648.023
300442.022
293436.021
359472.021
492540.021
313450.020
523560.020
688657.019
279428.018