Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells2927
Missing cells (%)21.1%
Duplicate rows1645
Duplicate rows (%)11.9%
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:16:38.797959image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:16:39.193964image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1645 (11.9%) duplicate rowsDuplicates
Flow has 2927 (21.1%) missing valuesMissing
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:16:36.723106
Analysis finished2024-05-12 18:16:38.695446
Duration1.97 second
MissingQ_Station_NA_24037360_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING  NON STATIONARY  SEASONAL 

Distinct4509
Distinct (%)41.2%
Missing2927
Missing (%)21.1%
Infinite0
Infinite (%)0.0%
Mean123.89839
Minimum10
Maximum1099
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:16:40.016514image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile23
Q163.6
median104
Q3160.1
95-th percentile288.38
Maximum1099
Range1089
Interquartile range (IQR)96.5

Descriptive statistics

Standard deviation91.552196
Coefficient of variation (CV)0.73892966
Kurtosis8.8627273
Mean123.89839
Median Absolute Deviation (MAD)46.95
Skewness2.1991805
Sum1357059.1
Variance8381.8046
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value3.151945966 × 10-18
2024-05-12T14:16:40.666229image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:16:42.630462image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps42
min3 days
max1 year and 3 days
mean9 weeks, 3 days and 10 hours
std15 weeks, 3 days and 3 hours
2024-05-12T14:16:42.940715image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
36.5 97
 
0.7%
53 45
 
0.3%
82.6 33
 
0.2%
118.5 31
 
0.2%
23 30
 
0.2%
80.5 27
 
0.2%
125.5 27
 
0.2%
121 27
 
0.2%
140.3 26
 
0.2%
179 24
 
0.2%
Other values (4499) 10586
76.3%
(Missing) 2927
 
21.1%
ValueCountFrequency (%)
10 1
 
< 0.1%
10.6 1
 
< 0.1%
10.9 1
 
< 0.1%
11 1
 
< 0.1%
11.1 3
< 0.1%
11.2 3
< 0.1%
11.4 3
< 0.1%
11.6 2
< 0.1%
11.7 3
< 0.1%
11.8 3
< 0.1%
ValueCountFrequency (%)
1099 1
< 0.1%
946.7 1
< 0.1%
939 1
< 0.1%
905.2 1
< 0.1%
830 1
< 0.1%
771.2 1
< 0.1%
757.9 1
< 0.1%
755.3 1
< 0.1%
731.3 1
< 0.1%
729 1
< 0.1%
2024-05-12T14:16:42.052539image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:16:38.376221image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:16:38.603451image/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-2264.564
2020-12-2362.913
2020-12-2460.122
2020-12-2562.410
2020-12-2666.464
2020-12-2762.341
2020-12-2864.379
2020-12-2961.160
2020-12-3071.746
2020-12-3186.033

Duplicate rows

Most frequently occurring

Flow# duplicates
1644NaN2927
19136.597
33653.045
58282.633
904118.531
8523.030
56380.527
919121.027
953125.527
1049140.326