Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells249
Missing cells (%)1.8%
Duplicate rows1837
Duplicate rows (%)13.2%
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:17:26.291421image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:17:26.800337image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1837 (13.2%) duplicate rowsDuplicates
Flow has 249 (1.8%) missing valuesMissing
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:17:23.947941
Analysis finished2024-05-12 18:17:26.174035
Duration2.23 seconds
MissingQ_Station_NA_27037010_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING  NON STATIONARY  SEASONAL 

Distinct4933
Distinct (%)36.2%
Missing249
Missing (%)1.8%
Infinite0
Infinite (%)0.0%
Mean823.03006
Minimum103.45
Maximum2430
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:17:27.527082image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum103.45
5-th percentile294.965
Q1507.95
median806.1
Q31082
95-th percentile1478
Maximum2430
Range2326.55
Interquartile range (IQR)574.05

Descriptive statistics

Standard deviation373.52249
Coefficient of variation (CV)0.45383821
Kurtosis-0.35279162
Mean823.03006
Median Absolute Deviation (MAD)288.8
Skewness0.43740401
Sum11218723
Variance139519.05
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value1.163756679 × 10-18
2024-05-12T14:17:28.159577image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:17:30.641869image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps25
min3 days
max6 weeks and 6 days
mean1 week, 3 days and 57 minutes
std1 week, 4 days and 2 hours
2024-05-12T14:17:31.143509image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
526 20
 
0.1%
1010 19
 
0.1%
716 19
 
0.1%
1101 18
 
0.1%
320 18
 
0.1%
440 17
 
0.1%
794 17
 
0.1%
442 17
 
0.1%
985 17
 
0.1%
1011 17
 
0.1%
Other values (4923) 13452
96.9%
(Missing) 249
 
1.8%
ValueCountFrequency (%)
103.45 1
 
< 0.1%
110.63 1
 
< 0.1%
114.33 1
 
< 0.1%
118.88 1
 
< 0.1%
120.19 1
 
< 0.1%
121.3 1
 
< 0.1%
122.11 1
 
< 0.1%
127.78 1
 
< 0.1%
132 3
< 0.1%
134 1
 
< 0.1%
ValueCountFrequency (%)
2430 1
< 0.1%
2230 1
< 0.1%
2226 1
< 0.1%
2222 1
< 0.1%
2220 1
< 0.1%
2197 1
< 0.1%
2184 1
< 0.1%
2173 1
< 0.1%
2164 1
< 0.1%
2154 1
< 0.1%
2024-05-12T14:17:29.805212image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:17:25.932046image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:17:26.098125image/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-01467.0
1983-01-02440.0
1983-01-03460.0
1983-01-04445.0
1983-01-05424.0
1983-01-06415.0
1983-01-07440.0
1983-01-08430.0
1983-01-09513.0
1983-01-10445.0
Flow
Date
2020-12-22974.51
2020-12-23848.62
2020-12-24791.16
2020-12-25784.83
2020-12-26814.74
2020-12-27834.01
2020-12-28861.40
2020-12-29882.36
2020-12-30892.57
2020-12-31815.97

Duplicate rows

Most frequently occurring

Flow# duplicates
1836NaN249
459526.020
733716.019
12101010.019
142320.018
13221101.018
180350.017
315440.017
317442.017
418501.017