Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells2238
Missing cells (%)16.1%
Duplicate rows2240
Duplicate rows (%)16.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:19:09.527981image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:19:09.925540image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 2240 (16.1%) duplicate rowsDuplicates
Flow has 2238 (16.1%) missing valuesMissing
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:19:07.639042
Analysis finished2024-05-12 18:19:09.428568
Duration1.79 second
MissingQ_Station_NA_25027370_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING  NON STATIONARY  SEASONAL 

Distinct4637
Distinct (%)39.8%
Missing2238
Missing (%)16.1%
Infinite0
Infinite (%)0.0%
Mean567.0587
Minimum50.2
Maximum1527
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:19:10.754797image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum50.2
5-th percentile189.6
Q1357
median526.4
Q3746
95-th percentile1095
Maximum1527
Range1476.8
Interquartile range (IQR)389

Descriptive statistics

Standard deviation273.28538
Coefficient of variation (CV)0.48193491
Kurtosis-0.23045229
Mean567.0587
Median Absolute Deviation (MAD)189.2
Skewness0.60213027
Sum6601697.4
Variance74684.901
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value3.461765687 × 10-16
2024-05-12T14:19:11.422858image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:19:14.343874image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps32
min3 days
max2 years and 4 days
mean10 weeks, 19 hours and 30 minutes
std18 weeks, 2 days and 18 hours
2024-05-12T14:19:14.640602image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
928.8 26
 
0.2%
553.6 23
 
0.2%
450 23
 
0.2%
448 22
 
0.2%
546 19
 
0.1%
363.6 19
 
0.1%
734 18
 
0.1%
390 18
 
0.1%
562.3 17
 
0.1%
547.4 17
 
0.1%
Other values (4627) 11440
82.4%
(Missing) 2238
 
16.1%
ValueCountFrequency (%)
50.2 2
< 0.1%
54.2 1
< 0.1%
54.8 2
< 0.1%
64.4 1
< 0.1%
65.7 1
< 0.1%
65.8 1
< 0.1%
68.2 1
< 0.1%
70.4 1
< 0.1%
71.4 1
< 0.1%
73.4 1
< 0.1%
ValueCountFrequency (%)
1527 2
< 0.1%
1525 2
< 0.1%
1519 1
< 0.1%
1517 2
< 0.1%
1511 1
< 0.1%
1509 2
< 0.1%
1505 1
< 0.1%
1501 1
< 0.1%
1499 1
< 0.1%
1495 2
< 0.1%
2024-05-12T14:19:13.704149image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:19:09.133944image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:19:09.338840image/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-01395.0
1983-01-02387.5
1983-01-03382.5
1983-01-04376.2
1983-01-05371.4
1983-01-06364.2
1983-01-07363.0
1983-01-08369.0
1983-01-09361.8
1983-01-10357.0
Flow
Date
2020-12-22741.22
2020-12-23730.95
2020-12-24726.14
2020-12-25722.68
2020-12-26719.82
2020-12-27710.20
2020-12-28693.05
2020-12-29684.79
2020-12-30678.36
2020-12-31676.97

Duplicate rows

Most frequently occurring

Flow# duplicates
2239NaN2238
1957928.826
891450.023
1187553.623
888448.022
615363.619
1163546.019
706390.018
1648734.018
1059510.017