Overview

Dataset statistics

Number of variables1
Number of observations10380
Missing cells354
Missing cells (%)3.4%
Duplicate rows1745
Duplicate rows (%)16.8%
Total size in memory162.2 KiB
Average record size in memory16.0 B

Variable types

TimeSeries1

Timeseries statistics

Number of series1
Time series length10380
Starting point1992-08-01 00:00:00
Ending point2020-12-31 00:00:00
Period1 day
2024-05-12T14:16:45.324973image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:16:45.719687image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1745 (16.8%) duplicate rowsDuplicates
Flow has 354 (3.4%) missing valuesMissing
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:16:43.818571
Analysis finished2024-05-12 18:16:45.225502
Duration1.41 second
MissingQ_Station_NA_24067020_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING  NON STATIONARY  SEASONAL 

Distinct5409
Distinct (%)53.9%
Missing354
Missing (%)3.4%
Infinite0
Infinite (%)0.0%
Mean434.35907
Minimum26
Maximum2625
Zeros0
Zeros (%)0.0%
Memory size162.2 KiB
2024-05-12T14:16:46.457036image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum26
5-th percentile120
Q1239
median364.355
Q3550
95-th percentile985.95
Maximum2625
Range2599
Interquartile range (IQR)311

Descriptive statistics

Standard deviation286.69872
Coefficient of variation (CV)0.66005003
Kurtosis5.7442832
Mean434.35907
Median Absolute Deviation (MAD)147.645
Skewness1.8536768
Sum4354884.1
Variance82196.155
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value1.8285414 × 10-17
2024-05-12T14:16:47.091181image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:16:50.198749image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps36
min3 days
max5 weeks and 1 day
mean1 week, 3 days and 6 hours
std1 week, 3 days and 17 hours
2024-05-12T14:16:50.593938image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
382 28
 
0.3%
410 24
 
0.2%
363 24
 
0.2%
369 23
 
0.2%
321 22
 
0.2%
371 22
 
0.2%
299 20
 
0.2%
385 20
 
0.2%
391 20
 
0.2%
308 17
 
0.2%
Other values (5399) 9806
94.5%
(Missing) 354
 
3.4%
ValueCountFrequency (%)
26 1
 
< 0.1%
33 1
 
< 0.1%
34 1
 
< 0.1%
37 1
 
< 0.1%
38 1
 
< 0.1%
40 1
 
< 0.1%
40.8 2
< 0.1%
42.4 1
 
< 0.1%
44.8 4
< 0.1%
45 1
 
< 0.1%
ValueCountFrequency (%)
2625 1
< 0.1%
2555 2
< 0.1%
2536 1
< 0.1%
2523 1
< 0.1%
2491 1
< 0.1%
2485 1
< 0.1%
2412 1
< 0.1%
2343 1
< 0.1%
2302 1
< 0.1%
2277 1
< 0.1%
2024-05-12T14:16:49.624335image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:16:45.025443image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:16:45.141856image/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
1992-08-01300.8
1992-08-02450.1
1992-08-03553.1
1992-08-04373.7
1992-08-05327.0
1992-08-06290.5
1992-08-07281.3
1992-08-08265.1
1992-08-09299.7
1992-08-10320.9
Flow
Date
2020-12-22231.03
2020-12-23239.47
2020-12-24221.50
2020-12-25359.13
2020-12-26353.43
2020-12-27224.69
2020-12-28249.88
2020-12-29357.90
2020-12-30288.21
2020-12-31329.20

Duplicate rows

Most frequently occurring

Flow# duplicates
1744NaN354
941382.028
891363.024
1009410.024
908369.023
755321.022
913371.022
679299.020
950385.020
964391.020