Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 1538 |
| Missing cells (%) | 11.1% |
| Duplicate rows | 1411 |
| Duplicate rows (%) | 10.2% |
| 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 1411 (10.2%) duplicate rows | Duplicates |
Flow has 1538 (11.1%) missing values | Missing |
Flow is non stationary | Non stationary |
Flow is seasonal | Seasonal |
Reproduction
| Analysis started | 2024-05-12 18:18:04.090302 |
|---|---|
| Analysis finished | 2024-05-12 18:18:05.948218 |
| Duration | 1.86 second |
| Missing | Q_Station_NA_28037030_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING NON STATIONARY SEASONAL
| Distinct | 3972 |
|---|---|
| Distinct (%) | 32.2% |
| Missing | 1538 |
| Missing (%) | 11.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.272723 |
|---|---|
| Minimum | 0.3 |
| Maximum | 435.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | 0.3 |
|---|---|
| 5-th percentile | 2.304 |
| Q1 | 5.7 |
| median | 15.1295 |
| Q3 | 37.5 |
| 95-th percentile | 127.3985 |
| Maximum | 435.6 |
| Range | 435.3 |
| Interquartile range (IQR) | 31.8 |
Descriptive statistics
| Standard deviation | 46.054609 |
|---|---|
| Coefficient of variation (CV) | 1.4270444 |
| Kurtosis | 11.77997 |
| Mean | 32.272723 |
| Median Absolute Deviation (MAD) | 11.2075 |
| Skewness | 3.034682 |
| Sum | 398309.95 |
| Variance | 2121.027 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 1.638485994 × 10-20 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 27 |
|---|---|
| min | 3 days |
| max | 2 years and 4 days |
| mean | 8 weeks, 1 day and 8 hours |
| std | 20 weeks, 1 day and 22 hours |
| Value | Count | Frequency (%) |
| 2.444 | 86 | 0.6% |
| 2.867 | 76 | 0.5% |
| 3.148 | 64 | 0.5% |
| 2.726 | 61 | 0.4% |
| 2.585 | 52 | 0.4% |
| 2 | 49 | 0.4% |
| 2.304 | 49 | 0.4% |
| 1.5 | 48 | 0.3% |
| 4 | 48 | 0.3% |
| 4.6 | 47 | 0.3% |
| Other values (3962) | 11762 | |
| (Missing) | 1538 | 11.1% |
| Value | Count | Frequency (%) |
| 0.3 | 10 | |
| 0.4 | 1 | < 0.1% |
| 0.5 | 2 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 0.8 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 1.0167 | 1 | < 0.1% |
| 1.0333 | 2 | < 0.1% |
| 1.0556 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 435.6 | 1 | |
| 434.1 | 1 | |
| 423.7 | 1 | |
| 394.7 | 1 | |
| 379.5 | 1 | |
| 373.5 | 1 | |
| 369.9 | 1 | |
| 368.8 | 1 | |
| 365.2 | 1 | |
| 360.8 | 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 | 6.6 |
| 1983-01-02 | 6.6 |
| 1983-01-03 | 6.6 |
| 1983-01-04 | 6.3 |
| 1983-01-05 | 6.4 |
| 1983-01-06 | 6.5 |
| 1983-01-07 | 6.5 |
| 1983-01-08 | 6.8 |
| 1983-01-09 | 6.7 |
| 1983-01-10 | 5.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 25.9540 |
| 2020-12-23 | 26.2340 |
| 2020-12-24 | 24.2070 |
| 2020-12-25 | 22.6220 |
| 2020-12-26 | 18.9260 |
| 2020-12-27 | 16.6780 |
| 2020-12-28 | 12.9970 |
| 2020-12-29 | 10.5280 |
| 2020-12-30 | 9.6073 |
| 2020-12-31 | 7.8895 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 1410 | NaN | 1538 |
| 49 | 2.444 | 86 |
| 63 | 2.867 | 76 |
| 77 | 3.148 | 64 |
| 58 | 2.726 | 61 |
| 53 | 2.585 | 52 |
| 33 | 2.000 | 49 |
| 44 | 2.304 | 49 |
| 19 | 1.500 | 48 |
| 111 | 4.000 | 48 |