Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 3021 |
| Missing cells (%) | 21.8% |
| Duplicate rows | 885 |
| Duplicate rows (%) | 6.4% |
| 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 885 (6.4%) duplicate rows | Duplicates |
Flow has 3021 (21.8%) missing values | Missing |
Reproduction
| Analysis started | 2024-05-12 19:34:14.685849 |
|---|---|
| Analysis finished | 2024-05-12 19:34:16.238484 |
| Duration | 1.55 second |
| Missing | Q_Station_NA_25027410_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING
| Distinct | 2478 |
|---|---|
| Distinct (%) | 22.8% |
| Missing | 3021 |
| Missing (%) | 21.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.29206188 |
|---|---|
| Minimum | -3231 |
| Maximum | 2600 |
| Zeros | 67 |
| Zeros (%) | 0.5% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -3231 |
|---|---|
| 5-th percentile | -322 |
| Q1 | -92 |
| median | 2 |
| Q3 | 99 |
| 95-th percentile | 313 |
| Maximum | 2600 |
| Range | 5831 |
| Interquartile range (IQR) | 191 |
Descriptive statistics
| Standard deviation | 223.50477 |
|---|---|
| Coefficient of variation (CV) | 765.26512 |
| Kurtosis | 22.749703 |
| Mean | 0.29206188 |
| Median Absolute Deviation (MAD) | 96 |
| Skewness | -0.57326012 |
| Sum | 3171.5 |
| Variance | 49954.383 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 77 |
|---|---|
| min | 5 days |
| max | 1 year, 5 weeks and 1 day |
| mean | 5 weeks, 4 days and 19 hours |
| std | 8 weeks, 2 days and 8 minutes |
| Value | Count | Frequency (%) |
| 0 | 67 | 0.5% |
| -6 | 42 | 0.3% |
| -1 | 40 | 0.3% |
| 22 | 40 | 0.3% |
| 7 | 38 | 0.3% |
| -8 | 36 | 0.3% |
| -33 | 35 | 0.3% |
| -36 | 35 | 0.3% |
| 31 | 35 | 0.3% |
| -20 | 35 | 0.3% |
| Other values (2468) | 10456 | |
| (Missing) | 3021 | 21.8% |
| Value | Count | Frequency (%) |
| -3231 | 1 | |
| -2806 | 1 | |
| -2669 | 1 | |
| -2468 | 1 | |
| -2437 | 1 | |
| -2311 | 1 | |
| -2014 | 1 | |
| -1796 | 1 | |
| -1648 | 1 | |
| -1583 | 1 |
| Value | Count | Frequency (%) |
| 2600 | 1 | |
| 2519 | 1 | |
| 2331 | 1 | |
| 2182 | 1 | |
| 1790 | 1 | |
| 1586 | 1 | |
| 1501 | 1 | |
| 1498 | 1 | |
| 1426 | 1 | |
| 1418 | 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 | 36.0 |
| 1983-01-05 | 100.0 |
| 1983-01-06 | -456.0 |
| 1983-01-07 | 36.0 |
| 1983-01-08 | 601.0 |
| 1983-01-09 | -68.0 |
| 1983-01-10 | -686.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | NaN |
| 2020-12-23 | NaN |
| 2020-12-24 | NaN |
| 2020-12-25 | NaN |
| 2020-12-26 | NaN |
| 2020-12-27 | NaN |
| 2020-12-28 | NaN |
| 2020-12-29 | NaN |
| 2020-12-30 | NaN |
| 2020-12-31 | NaN |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 884 | NaN | 3021 |
| 445 | 0.0 | 67 |
| 437 | -6.0 | 42 |
| 444 | -1.0 | 40 |
| 471 | 22.0 | 40 |
| 454 | 7.0 | 38 |
| 435 | -8.0 | 36 |
| 404 | -36.0 | 35 |
| 407 | -33.0 | 35 |
| 421 | -20.0 | 35 |