Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells124
Missing cells (%)0.9%
Duplicate rows2562
Duplicate rows (%)18.5%
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:53.552021image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:16:53.999496image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 2562 (18.5%) duplicate rowsDuplicates
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:16:51.472042
Analysis finished2024-05-12 18:16:53.450341
Duration1.98 second
MissingQ_Station_NA_23097030_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

NON STATIONARY  SEASONAL 

Distinct4940
Distinct (%)35.9%
Missing124
Missing (%)0.9%
Infinite0
Infinite (%)0.0%
Mean2289.2534
Minimum531.5
Maximum8317
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:16:54.839192image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum531.5
5-th percentile1101
Q11548
median2074
Q32814
95-th percentile4167.25
Maximum8317
Range7785.5
Interquartile range (IQR)1266

Descriptive statistics

Standard deviation1002.6836
Coefficient of variation (CV)0.43799589
Kurtosis2.5205007
Mean2289.2534
Median Absolute Deviation (MAD)597
Skewness1.3037539
Sum31490970
Variance1005374.4
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value1.917652532 × 10-24
2024-05-12T14:16:55.515162image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:16:58.366552image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps9
min3 days
max10 weeks and 6 days
mean1 week, 6 days and 21 hours
std3 weeks, 2 days and 15 hours
2024-05-12T14:16:58.787631image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
1348 16
 
0.1%
2708 15
 
0.1%
1564 14
 
0.1%
1623 14
 
0.1%
1670 14
 
0.1%
1542 14
 
0.1%
1963 14
 
0.1%
1668 13
 
0.1%
1559 13
 
0.1%
1578 13
 
0.1%
Other values (4930) 13616
98.1%
(Missing) 124
 
0.9%
ValueCountFrequency (%)
531.5 1
< 0.1%
544.5 1
< 0.1%
570.6 1
< 0.1%
576.9 1
< 0.1%
588.5 1
< 0.1%
595.3 1
< 0.1%
608.7 1
< 0.1%
611.1 1
< 0.1%
625.7 1
< 0.1%
628.7 1
< 0.1%
ValueCountFrequency (%)
8317 1
< 0.1%
8287 1
< 0.1%
8139 1
< 0.1%
8080 2
< 0.1%
7855 1
< 0.1%
7759 1
< 0.1%
7598 1
< 0.1%
7589 1
< 0.1%
7474 1
< 0.1%
7419 1
< 0.1%
2024-05-12T14:16:57.610520image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:16:53.217077image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:16:53.379879image/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-011894.0
1983-01-022216.0
1983-01-032352.0
1983-01-041768.0
1983-01-051753.0
1983-01-062610.0
1983-01-072713.0
1983-01-082275.0
1983-01-092032.0
1983-01-102053.0
Flow
Date
2020-12-222410.4
2020-12-232237.9
2020-12-242173.7
2020-12-252480.7
2020-12-262232.7
2020-12-272304.7
2020-12-282468.8
2020-12-292260.8
2020-12-302242.2
2020-12-312336.6

Duplicate rows

Most frequently occurring

Flow# duplicates
2561NaN124
3631348.016
16812708.015
5541542.014
5771564.014
6361623.014
6841670.014
9791963.014
1971180.013
2941280.013