Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells13
Missing cells (%)0.1%
Duplicate rows2933
Duplicate rows (%)21.1%
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:18:28.701020image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:18:29.076246image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 2933 (21.1%) duplicate rowsDuplicates
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:18:26.402553
Analysis finished2024-05-12 18:18:28.508787
Duration2.11 seconds
MissingQ_Station_NA_25027020_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

NON STATIONARY  SEASONAL 

Distinct6034
Distinct (%)43.5%
Missing13
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean4043.0019
Minimum911.9
Maximum9681
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:18:29.771751image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum911.9
5-th percentile1912
Q13010.65
median3912
Q34957.4
95-th percentile6496.7
Maximum9681
Range8769.1
Interquartile range (IQR)1946.75

Descriptive statistics

Standard deviation1408.3869
Coefficient of variation (CV)0.34835179
Kurtosis0.11403357
Mean4043.0019
Median Absolute Deviation (MAD)972.7
Skewness0.45914854
Sum56064307
Variance1983553.8
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value6.866990579 × 10-23
2024-05-12T14:18:30.476500image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:18:34.438477image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps2
min3 days
max5 days
mean4 days
std1 day, 9 hours and 56 minutes
2024-05-12T14:18:34.689421image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
4061 15
 
0.1%
3790 15
 
0.1%
3002 15
 
0.1%
5284 14
 
0.1%
4877 14
 
0.1%
3242 14
 
0.1%
3153 14
 
0.1%
4225 13
 
0.1%
3091 12
 
0.1%
2481 12
 
0.1%
Other values (6024) 13729
98.9%
(Missing) 13
 
0.1%
ValueCountFrequency (%)
911.9 1
< 0.1%
945.7 1
< 0.1%
1005 1
< 0.1%
1035 2
< 0.1%
1045.5 1
< 0.1%
1048 1
< 0.1%
1056 1
< 0.1%
1072.4 1
< 0.1%
1073 1
< 0.1%
1079.5 1
< 0.1%
ValueCountFrequency (%)
9681 1
< 0.1%
9662 1
< 0.1%
9643 1
< 0.1%
9605 2
< 0.1%
9586 1
< 0.1%
9567 2
< 0.1%
9491 1
< 0.1%
9464 1
< 0.1%
9431 2
< 0.1%
9426 1
< 0.1%
2024-05-12T14:18:33.830937image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:18:28.236950image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:18:28.426992image/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-013431.0
1983-01-023307.0
1983-01-033168.0
1983-01-043078.0
1983-01-053009.0
1983-01-062950.0
1983-01-072903.0
1983-01-082898.0
1983-01-093018.0
1983-01-103087.0
Flow
Date
2020-12-225091.9
2020-12-234960.1
2020-12-244890.4
2020-12-254796.2
2020-12-264615.2
2020-12-274573.1
2020-12-284612.6
2020-12-294581.0
2020-12-304533.0
2020-12-314515.2

Duplicate rows

Most frequently occurring

Flow# duplicates
7283002.015
13433790.015
15404061.015
8523153.014
9193242.014
21214877.014
23505284.014
16604225.013
2932NaN13
3952481.012