Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells3058
Missing cells (%)22.0%
Duplicate rows1482
Duplicate rows (%)10.7%
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-12T15:33:27.838618image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T15:33:28.219396image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1482 (10.7%) duplicate rowsDuplicates
Flow has 3058 (22.0%) missing valuesMissing
Flow has 156 (1.1%) zerosZeros

Reproduction

Analysis started2024-05-12 19:33:26.183579
Analysis finished2024-05-12 19:33:27.746056
Duration1.56 second
MissingQ_Station_NA_24037360_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING  ZEROS 

Distinct7338
Distinct (%)67.8%
Missing3058
Missing (%)22.0%
Infinite0
Infinite (%)0.0%
Mean0.0023034559
Minimum-1001.4
Maximum665.5
Zeros156
Zeros (%)1.1%
Memory size216.9 KiB
2024-05-12T15:33:28.901037image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum-1001.4
5-th percentile-96.0971
Q1-10.27675
median1
Q317.1
95-th percentile87.599
Maximum665.5
Range1666.9
Interquartile range (IQR)27.37675

Descriptive statistics

Standard deviation67.614911
Coefficient of variation (CV)29353.681
Kurtosis25.974247
Mean0.0023034559
Median Absolute Deviation (MAD)13.8
Skewness-1.6519482
Sum24.928
Variance4571.7763
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value2.325220812 × 10-27
2024-05-12T15:33:29.519008image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T15:33:34.706699image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps56
min4 days
max1 year and 5 days
mean7 weeks, 3 days and 21 hours
std14 weeks, 3 hours and 57 minutes
2024-05-12T15:33:35.186011image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
0 156
 
1.1%
2.5 21
 
0.2%
3 20
 
0.1%
-1 20
 
0.1%
-2 19
 
0.1%
1.5 19
 
0.1%
0.5 18
 
0.1%
-1.5 18
 
0.1%
1 15
 
0.1%
0.9 15
 
0.1%
Other values (7328) 10501
75.7%
(Missing) 3058
 
22.0%
ValueCountFrequency (%)
-1001.4 1
< 0.1%
-916.2 1
< 0.1%
-791.9 1
< 0.1%
-775.2 1
< 0.1%
-703.2 1
< 0.1%
-681.3 1
< 0.1%
-677.6 1
< 0.1%
-626.9 1
< 0.1%
-604.5 1
< 0.1%
-492.3 1
< 0.1%
ValueCountFrequency (%)
665.5 1
< 0.1%
658.5 1
< 0.1%
600.6 1
< 0.1%
548.1 1
< 0.1%
544.9 1
< 0.1%
519.5 1
< 0.1%
457.5 1
< 0.1%
409.2 1
< 0.1%
393 1
< 0.1%
385.9 1
< 0.1%
2024-05-12T15:33:33.821222image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

2024-05-12T15:33:27.105806image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Missing values

2024-05-12T15:33:27.451803image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T15:33:27.664742image/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-01NaN
1983-01-02NaN
1983-01-03NaN
1983-01-04NaN
1983-01-05NaN
1983-01-06NaN
1983-01-07NaN
1983-01-08NaN
1983-01-09NaN
1983-01-10NaN
Flow
Date
2020-12-22-3.290
2020-12-230.338
2020-12-24-1.140
2020-12-255.079
2020-12-261.766
2020-12-27-8.177
2020-12-286.161
2020-12-29-5.257
2020-12-3013.805
2020-12-313.701

Duplicate rows

Most frequently occurring

Flow# duplicates
1481NaN3058
6290.0156
7782.521
560-1.020
8063.020
515-2.019
7321.519
536-1.518
6690.518
564-0.915