Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells110
Missing cells (%)0.8%
Duplicate rows531
Duplicate rows (%)3.8%
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:36:38.869737image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T15:36:39.259976image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 531 (3.8%) duplicate rowsDuplicates
Flow has 434 (3.1%) zerosZeros

Reproduction

Analysis started2024-05-12 19:36:35.997078
Analysis finished2024-05-12 19:36:38.769716
Duration2.77 seconds
MissingQ_Station_NA_29037020_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

ZEROS 

Distinct1790
Distinct (%)13.0%
Missing110
Missing (%)0.8%
Infinite0
Infinite (%)0.0%
Mean0.011953522
Minimum-2283
Maximum1914
Zeros434
Zeros (%)3.1%
Memory size216.9 KiB
2024-05-12T15:36:39.928712image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum-2283
5-th percentile-94
Q1-30
median0
Q330.45
95-th percentile92.55
Maximum1914
Range4197
Interquartile range (IQR)60.45

Descriptive statistics

Standard deviation80.942105
Coefficient of variation (CV)6771.4021
Kurtosis135.1398
Mean0.011953522
Median Absolute Deviation (MAD)30
Skewness-1.0590288
Sum164.6
Variance6551.6243
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value0
2024-05-12T15:36:40.508932image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T15:36:41.806259image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps11
min5 days
max4 weeks and 1 day
mean1 week, 3 days and 17 hours
std1 week, 21 hours and 14.05 seconds
2024-05-12T15:36:42.365672image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
0 434
 
3.1%
-1 174
 
1.3%
8 165
 
1.2%
-8 156
 
1.1%
24 152
 
1.1%
1 148
 
1.1%
10 147
 
1.1%
9 138
 
1.0%
-9 135
 
1.0%
-2 131
 
0.9%
Other values (1780) 11990
86.4%
ValueCountFrequency (%)
-2283 1
< 0.1%
-1592 1
< 0.1%
-1482 1
< 0.1%
-1209 1
< 0.1%
-1075 1
< 0.1%
-1034 1
< 0.1%
-975 1
< 0.1%
-931 1
< 0.1%
-873 1
< 0.1%
-849 1
< 0.1%
ValueCountFrequency (%)
1914 1
< 0.1%
1639 1
< 0.1%
1549 1
< 0.1%
1164 1
< 0.1%
1081 1
< 0.1%
806 1
< 0.1%
778 1
< 0.1%
768 1
< 0.1%
719 1
< 0.1%
670 1
< 0.1%
2024-05-12T15:36:41.065568image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T15:36:38.486524image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T15:36:38.686919image/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-0484.0
1983-01-05-2.0
1983-01-0624.0
1983-01-07-38.0
1983-01-0860.0
1983-01-09-75.0
1983-01-10-3.0
Flow
Date
2020-12-22-31.0
2020-12-2316.0
2020-12-24-45.0
2020-12-2521.0
2020-12-2611.0
2020-12-27-5.0
2020-12-2842.0
2020-12-29-65.7
2020-12-3017.3
2020-12-3122.5

Duplicate rows

Most frequently occurring

Flow# duplicates
2580.0434
255-1.0174
2848.0165
236-8.0156
32524.0152
2611.0148
29010.0147
2869.0138
234-9.0135
251-2.0131