Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells32
Missing cells (%)0.2%
Duplicate rows592
Duplicate rows (%)4.3%
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:35:53.837417image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T15:35:54.255411image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 592 (4.3%) duplicate rowsDuplicates
Flow has 236 (1.7%) zerosZeros

Reproduction

Analysis started2024-05-12 19:35:51.255870
Analysis finished2024-05-12 19:35:53.729126
Duration2.47 seconds
MissingQ_Station_NA_25027020_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

ZEROS 

Distinct2118
Distinct (%)15.3%
Missing32
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean-0.012420566
Minimum-524
Maximum758
Zeros236
Zeros (%)1.7%
Memory size216.9 KiB
2024-05-12T15:35:54.997161image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum-524
5-th percentile-117
Q1-36
median0
Q336
95-th percentile120.065
Maximum758
Range1282
Interquartile range (IQR)72

Descriptive statistics

Standard deviation74.795295
Coefficient of variation (CV)-6021.891
Kurtosis4.7472385
Mean-0.012420566
Median Absolute Deviation (MAD)36
Skewness0.030305093
Sum-172
Variance5594.3362
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value0
2024-05-12T15:35:55.776352image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T15:35:57.860430image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps7
min4 days
max1 week and 4 days
mean5 days, 6 hours and 51 minutes
std2 days, 15 hours and 3 minutes
2024-05-12T15:35:58.290418image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
0 236
 
1.7%
-5 140
 
1.0%
-9 137
 
1.0%
5 136
 
1.0%
9 128
 
0.9%
10 124
 
0.9%
-18 117
 
0.8%
-4 116
 
0.8%
-10 114
 
0.8%
13 111
 
0.8%
Other values (2108) 12489
90.0%
ValueCountFrequency (%)
-524 1
< 0.1%
-484 1
< 0.1%
-444 1
< 0.1%
-438 1
< 0.1%
-430 1
< 0.1%
-426 1
< 0.1%
-425 1
< 0.1%
-409 1
< 0.1%
-408 1
< 0.1%
-400 1
< 0.1%
ValueCountFrequency (%)
758 1
< 0.1%
561 1
< 0.1%
513 1
< 0.1%
485 1
< 0.1%
467 1
< 0.1%
463 1
< 0.1%
419 1
< 0.1%
402 1
< 0.1%
394 1
< 0.1%
383 1
< 0.1%
2024-05-12T15:35:57.113809image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T15:35:53.430103image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T15:35:53.638938image/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-03-15.0
1983-01-0449.0
1983-01-0521.0
1983-01-0610.0
1983-01-0712.0
1983-01-0842.0
1983-01-09125.0
1983-01-10-51.0
Flow
Date
2020-12-2268.6
2020-12-23-53.2
2020-12-2462.1
2020-12-25-24.5
2020-12-26-86.8
2020-12-27138.9
2020-12-2881.6
2020-12-29-71.1
2020-12-30-16.4
2020-12-3130.2

Duplicate rows

Most frequently occurring

Flow# duplicates
3040.0236
289-5.0140
276-9.0137
3125.0136
3209.0128
32310.0124
247-18.0117
291-4.0116
273-10.0114
3071.0111