Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 2015 |
| Missing cells (%) | 14.5% |
| Duplicate rows | 454 |
| Duplicate rows (%) | 3.3% |
| 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 454 (3.3%) duplicate rows | Duplicates |
Flow has 2015 (14.5%) missing values | Missing |
Flow has 182 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-12 19:36:22.461819 |
|---|---|
| Analysis finished | 2024-05-12 19:36:23.945221 |
| Duration | 1.48 second |
| Missing | Q_Station_NA_25027930_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING ZEROS
| Distinct | 1397 |
|---|---|
| Distinct (%) | 11.8% |
| Missing | 2015 |
| Missing (%) | 14.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.015979772 |
|---|---|
| Minimum | -2994 |
| Maximum | 2958 |
| Zeros | 182 |
| Zeros (%) | 1.3% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -2994 |
|---|---|
| 5-th percentile | -114 |
| Q1 | -30.3 |
| median | 1 |
| Q3 | 33 |
| 95-th percentile | 110 |
| Maximum | 2958 |
| Range | 5952 |
| Interquartile range (IQR) | 63.3 |
Descriptive statistics
| Standard deviation | 101.33172 |
|---|---|
| Coefficient of variation (CV) | 6341.2491 |
| Kurtosis | 222.69094 |
| Mean | 0.015979772 |
| Median Absolute Deviation (MAD) | 32 |
| Skewness | -0.11325632 |
| Sum | 189.6 |
| Variance | 10268.117 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 29 |
|---|---|
| min | 5 days |
| max | 2 years, 36 weeks and 1 day |
| mean | 10 weeks, 9 hours and 6 minutes |
| std | 25 weeks, 3 days and 11 hours |
| Value | Count | Frequency (%) |
| 0 | 182 | 1.3% |
| -4 | 144 | 1.0% |
| 8 | 125 | 0.9% |
| 5 | 121 | 0.9% |
| -8 | 120 | 0.9% |
| 1 | 119 | 0.9% |
| -9 | 115 | 0.8% |
| 9 | 113 | 0.8% |
| 4 | 112 | 0.8% |
| 13 | 105 | 0.8% |
| Other values (1387) | 10609 | |
| (Missing) | 2015 | 14.5% |
| Value | Count | Frequency (%) |
| -2994 | 1 | |
| -2473 | 1 | |
| -1697 | 1 | |
| -1284 | 1 | |
| -1251 | 1 | |
| -1049 | 1 | |
| -1035 | 1 | |
| -1031 | 1 | |
| -953 | 1 | |
| -887 | 1 |
| Value | Count | Frequency (%) |
| 2958 | 1 | |
| 2505 | 1 | |
| 2087 | 1 | |
| 1086 | 1 | |
| 963 | 1 | |
| 849 | 1 | |
| 845 | 1 | |
| 822 | 1 | |
| 757 | 1 | |
| 734 | 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 | NaN |
| 1983-01-02 | NaN |
| 1983-01-03 | NaN |
| 1983-01-04 | -50.0 |
| 1983-01-05 | 96.0 |
| 1983-01-06 | -33.0 |
| 1983-01-07 | -32.0 |
| 1983-01-08 | 60.0 |
| 1983-01-09 | -46.0 |
| 1983-01-10 | 41.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 63.0 |
| 2020-12-23 | -83.8 |
| 2020-12-24 | 19.1 |
| 2020-12-25 | -84.4 |
| 2020-12-26 | 168.3 |
| 2020-12-27 | -79.6 |
| 2020-12-28 | 30.7 |
| 2020-12-29 | -37.5 |
| 2020-12-30 | 33.4 |
| 2020-12-31 | -40.4 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 453 | NaN | 2015 |
| 231 | 0.0 | 182 |
| 224 | -4.0 | 144 |
| 242 | 8.0 | 125 |
| 237 | 5.0 | 121 |
| 219 | -8.0 | 120 |
| 232 | 1.0 | 119 |
| 217 | -9.0 | 115 |
| 243 | 9.0 | 113 |
| 235 | 4.0 | 112 |