Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 2824 |
| Missing cells (%) | 20.3% |
| Duplicate rows | 2196 |
| Duplicate rows (%) | 15.8% |
| 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 2196 (15.8%) duplicate rows | Duplicates |
Flow has 2824 (20.3%) missing values | Missing |
Flow is non stationary | Non stationary |
Flow is seasonal | Seasonal |
Reproduction
| Analysis started | 2024-05-12 18:16:29.929748 |
|---|---|
| Analysis finished | 2024-05-12 18:16:32.223339 |
| Duration | 2.29 seconds |
| Missing | Q_Station_NA_24017640_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING NON STATIONARY SEASONAL
| Distinct | 5302 |
|---|---|
| Distinct (%) | 48.0% |
| Missing | 2824 |
| Missing (%) | 20.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 220.17517 |
|---|---|
| Minimum | 8.7 |
| Maximum | 1649 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | 8.7 |
|---|---|
| 5-th percentile | 39.18075 |
| Q1 | 93.1875 |
| median | 172.95 |
| Q3 | 292.6 |
| 95-th percentile | 556.275 |
| Maximum | 1649 |
| Range | 1640.3 |
| Interquartile range (IQR) | 199.4125 |
Descriptive statistics
| Standard deviation | 178.34402 |
|---|---|
| Coefficient of variation (CV) | 0.8100097 |
| Kurtosis | 6.4347659 |
| Mean | 220.17517 |
| Median Absolute Deviation (MAD) | 91.35 |
| Skewness | 2.002024 |
| Sum | 2434256.7 |
| Variance | 31806.59 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 2.111722393 × 10-23 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 88 |
|---|---|
| min | 3 days |
| max | 2 years and 5 days |
| mean | 4 weeks, 3 days and 13 hours |
| std | 14 weeks, 5 days and 3 hours |
| Value | Count | Frequency (%) |
| 136 | 34 | 0.2% |
| 122.5 | 22 | 0.2% |
| 120 | 21 | 0.2% |
| 114.1 | 19 | 0.1% |
| 103.6 | 19 | 0.1% |
| 201.3 | 17 | 0.1% |
| 128 | 16 | 0.1% |
| 70.3 | 16 | 0.1% |
| 47.08 | 15 | 0.1% |
| 105.8 | 15 | 0.1% |
| Other values (5292) | 10862 | |
| (Missing) | 2824 | 20.3% |
| Value | Count | Frequency (%) |
| 8.7 | 1 | < 0.1% |
| 9.6 | 1 | < 0.1% |
| 9.8 | 1 | < 0.1% |
| 10 | 2 | |
| 10.3 | 1 | < 0.1% |
| 10.4 | 3 | |
| 10.7 | 1 | < 0.1% |
| 11.2 | 1 | < 0.1% |
| 11.8 | 1 | < 0.1% |
| 12.1 | 2 |
| Value | Count | Frequency (%) |
| 1649 | 2 | |
| 1546 | 1 | |
| 1483 | 1 | |
| 1461 | 1 | |
| 1440 | 1 | |
| 1420 | 1 | |
| 1400.9 | 1 | |
| 1389 | 1 | |
| 1387 | 1 | |
| 1370 | 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 | 87.8 |
| 1983-01-02 | 89.1 |
| 1983-01-03 | 91.2 |
| 1983-01-04 | 88.6 |
| 1983-01-05 | 86.0 |
| 1983-01-06 | 98.0 |
| 1983-01-07 | 93.5 |
| 1983-01-08 | 88.6 |
| 1983-01-09 | 88.5 |
| 1983-01-10 | 87.2 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 112.910 |
| 2020-12-23 | 162.010 |
| 2020-12-24 | 115.470 |
| 2020-12-25 | 255.950 |
| 2020-12-26 | 162.400 |
| 2020-12-27 | 102.690 |
| 2020-12-28 | 81.423 |
| 2020-12-29 | 63.997 |
| 2020-12-30 | 75.866 |
| 2020-12-31 | 160.550 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 2195 | NaN | 2824 |
| 831 | 136.00 | 34 |
| 743 | 122.50 | 22 |
| 727 | 120.00 | 21 |
| 615 | 103.60 | 19 |
| 688 | 114.10 | 19 |
| 1240 | 201.30 | 17 |
| 335 | 70.30 | 16 |
| 780 | 128.00 | 16 |
| 171 | 47.08 | 15 |