Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells32
Missing cells (%)0.2%
Duplicate rows1943
Duplicate rows (%)14.0%
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:18.197201image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:16:18.616855image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1943 (14.0%) duplicate rowsDuplicates
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:16:15.302990
Analysis finished2024-05-12 18:16:18.079975
Duration2.78 seconds
MissingQ_Station_NA_21237010_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

NON STATIONARY  SEASONAL 

Distinct5066
Distinct (%)36.6%
Missing32
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean1133.2592
Minimum92.689
Maximum5286
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:16:19.303619image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum92.689
5-th percentile483
Q1756.075
median1044
Q31386
95-th percentile2156.3
Maximum5286
Range5193.311
Interquartile range (IQR)629.925

Descriptive statistics

Standard deviation533.30666
Coefficient of variation (CV)0.47059547
Kurtosis3.3023431
Mean1133.2592
Median Absolute Deviation (MAD)309
Skewness1.4005897
Sum15693374
Variance284415.99
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value3.226973266 × 10-25
2024-05-12T14:16:19.912062image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:16:21.343116image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps9
min3 days
max1 week
mean3 days, 21 hours and 20 minutes
std1 day, 10 hours and 52 minutes
2024-05-12T14:16:21.800237image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
1115 24
 
0.2%
1175 19
 
0.1%
1145 18
 
0.1%
1059 18
 
0.1%
1126 17
 
0.1%
1308 17
 
0.1%
817 17
 
0.1%
880 17
 
0.1%
1083 17
 
0.1%
1128 17
 
0.1%
Other values (5056) 13667
98.5%
(Missing) 32
 
0.2%
ValueCountFrequency (%)
92.689 1
< 0.1%
94.863 1
< 0.1%
98.261 1
< 0.1%
99.398 1
< 0.1%
117.27 1
< 0.1%
117.71 1
< 0.1%
118.83 1
< 0.1%
122.2 1
< 0.1%
123.99 1
< 0.1%
127.13 1
< 0.1%
ValueCountFrequency (%)
5286 1
< 0.1%
4701 1
< 0.1%
4403 1
< 0.1%
4351 1
< 0.1%
4276 1
< 0.1%
4140 1
< 0.1%
4121 1
< 0.1%
4073 1
< 0.1%
4071 1
< 0.1%
4054 1
< 0.1%
2024-05-12T14:16:20.476384image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:16:17.783737image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:16:17.977188image/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-011198.0
1983-01-02948.0
1983-01-03864.0
1983-01-041360.0
1983-01-051654.0
1983-01-061599.0
1983-01-071361.0
1983-01-081414.0
1983-01-091115.0
1983-01-10941.0
Flow
Date
2020-12-221166.6
2020-12-231127.6
2020-12-241037.2
2020-12-251136.0
2020-12-261115.3
2020-12-27932.8
2020-12-281061.3
2020-12-291225.7
2020-12-301164.6
2020-12-311039.3

Duplicate rows

Most frequently occurring

Flow# duplicates
1942NaN32
9641115.024
10351175.019
9021059.018
10001145.018
570817.017
659880.017
681898.017
8361002.017
9261083.017