Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 3435 |
| Missing cells (%) | 24.7% |
| Duplicate rows | 2040 |
| Duplicate rows (%) | 14.7% |
| Total size in memory | 216.9 KiB |
| Average record size in memory | 16.0 B |
Variable types
| TimeSeries | 1 |
|---|
Timeseries statistics
| Number of series | 1 |
|---|---|
| Time series length | 13880 |
| Starting point | 1983-01-01 00:00:00 |
| Ending point | 2020-12-31 00:00:00 |
| Period | 1 day |
| Dataset has 2040 (14.7%) duplicate rows | Duplicates |
Flow has 3435 (24.7%) missing values | Missing |
Flow is non stationary | Non stationary |
Flow is seasonal | Seasonal |
Reproduction
| Analysis started | 2024-05-12 18:18:11.985445 |
|---|---|
| Analysis finished | 2024-05-12 18:18:13.552609 |
| Duration | 1.57 second |
| Missing | Q_Station_NA_28037090_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING NON STATIONARY SEASONAL
| Distinct | 3532 |
|---|---|
| Distinct (%) | 33.8% |
| Missing | 3435 |
| Missing (%) | 24.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.669406 |
|---|---|
| Minimum | 0.1 |
| Maximum | 299 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 2.2 |
| Q1 | 10.4 |
| median | 39.578 |
| Q3 | 97.3 |
| 95-th percentile | 178.4 |
| Maximum | 299 |
| Range | 298.9 |
| Interquartile range (IQR) | 86.9 |
Descriptive statistics
| Standard deviation | 59.580421 |
|---|---|
| Coefficient of variation (CV) | 0.9820505 |
| Kurtosis | 0.29555196 |
| Mean | 60.669406 |
| Median Absolute Deviation (MAD) | 33.978 |
| Skewness | 1.0588233 |
| Sum | 633691.94 |
| Variance | 3549.8265 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 1.947472341 × 10-18 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 31 |
|---|---|
| min | 3 days |
| max | 4 years and 6 days |
| mean | 15 weeks, 6 days and 14 hours |
| std | 41 weeks, 2 days and 9 hours |
| Value | Count | Frequency (%) |
| 3.2 | 36 | 0.3% |
| 3.7 | 35 | 0.3% |
| 2 | 32 | 0.2% |
| 2.3 | 31 | 0.2% |
| 2.1 | 31 | 0.2% |
| 4.7 | 27 | 0.2% |
| 3.5 | 27 | 0.2% |
| 2.2 | 27 | 0.2% |
| 4.6 | 26 | 0.2% |
| 3.4 | 26 | 0.2% |
| Other values (3522) | 10147 | |
| (Missing) | 3435 | 24.7% |
| Value | Count | Frequency (%) |
| 0.1 | 2 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.175 | 2 | < 0.1% |
| 0.192 | 1 | < 0.1% |
| 0.21 | 2 | < 0.1% |
| 0.227 | 1 | < 0.1% |
| 0.245 | 4 | |
| 0.262 | 2 | < 0.1% |
| 0.28 | 7 | |
| 0.298 | 5 |
| Value | Count | Frequency (%) |
| 299 | 1 | |
| 288.5 | 2 | |
| 283.2 | 1 | |
| 278.6 | 1 | |
| 278 | 1 | |
| 277.1 | 1 | |
| 269.8 | 1 | |
| 268.6 | 1 | |
| 267.5 | 2 | |
| 266.9 | 1 |
ACF and PACF
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Flow | |
|---|---|
| Date | |
| 1983-01-01 | 3.2 |
| 1983-01-02 | 3.1 |
| 1983-01-03 | 3.0 |
| 1983-01-04 | 2.9 |
| 1983-01-05 | 2.9 |
| 1983-01-06 | 2.9 |
| 1983-01-07 | 2.7 |
| 1983-01-08 | 2.7 |
| 1983-01-09 | 2.6 |
| 1983-01-10 | 2.5 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 23.047 |
| 2020-12-23 | 21.002 |
| 2020-12-24 | 19.275 |
| 2020-12-25 | 17.389 |
| 2020-12-26 | 16.135 |
| 2020-12-27 | 15.620 |
| 2020-12-28 | 15.131 |
| 2020-12-29 | 14.940 |
| 2020-12-30 | NaN |
| 2020-12-31 | NaN |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 2039 | NaN | 3435 |
| 148 | 3.2 | 36 |
| 167 | 3.7 | 35 |
| 66 | 2.0 | 32 |
| 72 | 2.1 | 31 |
| 91 | 2.3 | 31 |
| 82 | 2.2 | 27 |
| 157 | 3.5 | 27 |
| 199 | 4.7 | 27 |
| 154 | 3.4 | 26 |