Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 2274 |
| Missing cells (%) | 16.4% |
| Duplicate rows | 1748 |
| Duplicate rows (%) | 12.6% |
| 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 1748 (12.6%) duplicate rows | Duplicates |
Flow has 2274 (16.4%) missing values | Missing |
Reproduction
| Analysis started | 2024-05-12 19:33:08.883371 |
|---|---|
| Analysis finished | 2024-05-12 19:33:11.043469 |
| Duration | 2.16 seconds |
| Missing | Q_Station_NA_21237020_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING
| Distinct | 4398 |
|---|---|
| Distinct (%) | 37.9% |
| Missing | 2274 |
| Missing (%) | 16.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.17894193 |
|---|---|
| Minimum | -4816 |
| Maximum | 4085 |
| Zeros | 16 |
| Zeros (%) | 0.1% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -4816 |
|---|---|
| 5-th percentile | -1027.75 |
| Q1 | -268 |
| median | 7 |
| Q3 | 279.375 |
| 95-th percentile | 1000.225 |
| Maximum | 4085 |
| Range | 8901 |
| Interquartile range (IQR) | 547.375 |
Descriptive statistics
| Standard deviation | 626.99874 |
|---|---|
| Coefficient of variation (CV) | -3503.923 |
| Kurtosis | 4.0329942 |
| Mean | -0.17894193 |
| Median Absolute Deviation (MAD) | 274 |
| Skewness | -0.097738824 |
| Sum | -2076.8 |
| Variance | 393127.42 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 7 |
|---|---|
| min | 5 days |
| max | 4 weeks and 5 days |
| mean | 1 week, 5 days and 6 hours |
| std | 1 week, 2 days and 17 hours |
| Value | Count | Frequency (%) |
| -47 | 21 | 0.2% |
| 93 | 20 | 0.1% |
| 22 | 20 | 0.1% |
| -14 | 19 | 0.1% |
| 62 | 19 | 0.1% |
| 5 | 18 | 0.1% |
| 8 | 18 | 0.1% |
| -77 | 18 | 0.1% |
| 19 | 18 | 0.1% |
| 30 | 17 | 0.1% |
| Other values (4388) | 11418 | |
| (Missing) | 2274 | 16.4% |
| Value | Count | Frequency (%) |
| -4816 | 1 | |
| -3837 | 1 | |
| -3508 | 1 | |
| -3400 | 1 | |
| -3385 | 1 | |
| -3326 | 1 | |
| -3298 | 1 | |
| -3278 | 1 | |
| -3187 | 1 | |
| -3137 | 1 |
| Value | Count | Frequency (%) |
| 4085 | 1 | |
| 3978 | 1 | |
| 3578 | 1 | |
| 3552 | 1 | |
| 3540 | 1 | |
| 3348 | 1 | |
| 3247 | 1 | |
| 3199 | 1 | |
| 3170 | 1 | |
| 3168 | 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 | 0.0 |
| 1983-01-05 | 278.0 |
| 1983-01-06 | -954.0 |
| 1983-01-07 | -13.0 |
| 1983-01-08 | 620.0 |
| 1983-01-09 | -46.0 |
| 1983-01-10 | -390.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 | |
|---|---|---|
| 1747 | NaN | 2274 |
| 812 | -47.0 | 21 |
| 885 | 22.0 | 20 |
| 959 | 93.0 | 20 |
| 847 | -14.0 | 19 |
| 927 | 62.0 | 19 |
| 779 | -77.0 | 18 |
| 867 | 5.0 | 18 |
| 870 | 8.0 | 18 |
| 882 | 19.0 | 18 |