Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 1351 |
| Missing cells (%) | 9.7% |
| Duplicate rows | 508 |
| Duplicate rows (%) | 3.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 508 (3.7%) duplicate rows | Duplicates |
Flow has 1351 (9.7%) missing values | Missing |
Flow has 938 (6.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-12 19:36:10.911973 |
|---|---|
| Analysis finished | 2024-05-12 19:36:13.481553 |
| Duration | 2.57 seconds |
| Missing | Q_Station_NA_25027680_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING ZEROS
| Distinct | 1544 |
|---|---|
| Distinct (%) | 12.3% |
| Missing | 1351 |
| Missing (%) | 9.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.085762631 |
|---|---|
| Minimum | -3215 |
| Maximum | 3047 |
| Zeros | 938 |
| Zeros (%) | 6.8% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -3215 |
|---|---|
| 5-th percentile | -48 |
| Q1 | -15 |
| median | 0 |
| Q3 | 14 |
| 95-th percentile | 51 |
| Maximum | 3047 |
| Range | 6262 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 68.417127 |
|---|---|
| Coefficient of variation (CV) | -797.74986 |
| Kurtosis | 929.35582 |
| Mean | -0.085762631 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 1.8824171 |
| Sum | -1074.52 |
| Variance | 4680.9032 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 33 |
|---|---|
| min | 4 days |
| max | 32 weeks and 5 days |
| mean | 5 weeks, 5 days and 2 hours |
| std | 6 weeks, 1 day and 9 hours |
| Value | Count | Frequency (%) |
| 0 | 938 | 6.8% |
| 1 | 340 | 2.4% |
| -1 | 320 | 2.3% |
| -5 | 277 | 2.0% |
| 5 | 261 | 1.9% |
| -9 | 222 | 1.6% |
| -6 | 222 | 1.6% |
| -10 | 220 | 1.6% |
| 10 | 210 | 1.5% |
| 9 | 209 | 1.5% |
| Other values (1534) | 9310 | |
| (Missing) | 1351 | 9.7% |
| Value | Count | Frequency (%) |
| -3215 | 1 | |
| -1545 | 1 | |
| -1534 | 1 | |
| -1151 | 1 | |
| -1143 | 1 | |
| -642 | 1 | |
| -613 | 1 | |
| -551 | 1 | |
| -536 | 1 | |
| -465 | 1 |
| Value | Count | Frequency (%) |
| 3047 | 1 | |
| 2349 | 1 | |
| 1705 | 1 | |
| 1638 | 1 | |
| 689 | 1 | |
| 620 | 1 | |
| 610 | 1 | |
| 549 | 1 | |
| 546 | 1 | |
| 502 | 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 | NaN |
| 1983-01-05 | NaN |
| 1983-01-06 | NaN |
| 1983-01-07 | NaN |
| 1983-01-08 | NaN |
| 1983-01-09 | NaN |
| 1983-01-10 | NaN |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | -6.3 |
| 2020-12-23 | 14.7 |
| 2020-12-24 | -1.0 |
| 2020-12-25 | -18.1 |
| 2020-12-26 | 16.3 |
| 2020-12-27 | -9.9 |
| 2020-12-28 | 18.1 |
| 2020-12-29 | -20.0 |
| 2020-12-30 | -12.5 |
| 2020-12-31 | 21.8 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 507 | NaN | 1351 |
| 255 | 0.0 | 938 |
| 264 | 1.0 | 340 |
| 246 | -1.0 | 320 |
| 224 | -5.0 | 277 |
| 286 | 5.0 | 261 |
| 198 | -9.0 | 222 |
| 221 | -6.0 | 222 |
| 191 | -10.0 | 220 |
| 320 | 10.0 | 210 |