Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 2312 |
| Missing cells (%) | 16.7% |
| Duplicate rows | 1096 |
| Duplicate rows (%) | 7.9% |
| 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 1096 (7.9%) duplicate rows | Duplicates |
Flow has 2312 (16.7%) missing values | Missing |
Flow has 637 (4.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-12 19:36:45.601679 |
|---|---|
| Analysis finished | 2024-05-12 19:36:47.514333 |
| Duration | 1.91 second |
| Missing | Q_Station_NA_25027370_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING ZEROS
| Distinct | 2657 |
|---|---|
| Distinct (%) | 23.0% |
| Missing | 2312 |
| Missing (%) | 16.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.015109786 |
|---|---|
| Minimum | -243 |
| Maximum | 144 |
| Zeros | 637 |
| Zeros (%) | 4.6% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -243 |
|---|---|
| 5-th percentile | -12.579 |
| Q1 | -3 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 12.8 |
| Maximum | 144 |
| Range | 387 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 9.4414159 |
|---|---|
| Coefficient of variation (CV) | -624.85439 |
| Kurtosis | 70.398624 |
| Mean | -0.015109786 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -1.6902988 |
| Sum | -174.79 |
| Variance | 89.140334 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 36 |
|---|---|
| min | 4 days |
| max | 2 years and 6 days |
| mean | 9 weeks, 2 days and 4 hours |
| std | 17 weeks, 4 days and 3 hours |
| Value | Count | Frequency (%) |
| 0 | 637 | 4.6% |
| -1 | 236 | 1.7% |
| -2 | 235 | 1.7% |
| 1 | 222 | 1.6% |
| 2 | 189 | 1.4% |
| -3 | 181 | 1.3% |
| 3 | 177 | 1.3% |
| 4 | 138 | 1.0% |
| -5 | 127 | 0.9% |
| -4 | 124 | 0.9% |
| Other values (2647) | 9302 | |
| (Missing) | 2312 | 16.7% |
| Value | Count | Frequency (%) |
| -243 | 1 | |
| -184.8 | 1 | |
| -120 | 1 | |
| -107.5 | 1 | |
| -85.7 | 1 | |
| -73.4 | 1 | |
| -64.3 | 1 | |
| -62.6 | 1 | |
| -62 | 1 | |
| -58.4 | 1 |
| Value | Count | Frequency (%) |
| 144 | 1 | |
| 116.9 | 1 | |
| 112 | 1 | |
| 92.9 | 1 | |
| 83.7 | 1 | |
| 82.4 | 1 | |
| 71.7 | 1 | |
| 69.6 | 1 | |
| 69 | 1 | |
| 65.1 | 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 | 2.5 |
| 1983-01-04 | -1.3 |
| 1983-01-05 | 1.5 |
| 1983-01-06 | -2.4 |
| 1983-01-07 | 6.0 |
| 1983-01-08 | 7.2 |
| 1983-01-09 | -13.2 |
| 1983-01-10 | 2.4 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | -4.21 |
| 2020-12-23 | 7.90 |
| 2020-12-24 | 5.46 |
| 2020-12-25 | 1.35 |
| 2020-12-26 | 0.60 |
| 2020-12-27 | -6.76 |
| 2020-12-28 | -7.53 |
| 2020-12-29 | 8.89 |
| 2020-12-30 | 1.83 |
| 2020-12-31 | 5.04 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 1095 | NaN | 2312 |
| 542 | 0.0 | 637 |
| 477 | -1.0 | 236 |
| 417 | -2.0 | 235 |
| 606 | 1.0 | 222 |
| 666 | 2.0 | 189 |
| 360 | -3.0 | 181 |
| 719 | 3.0 | 177 |
| 761 | 4.0 | 138 |
| 275 | -5.0 | 127 |