Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 2227 |
| Missing cells (%) | 16.0% |
| Duplicate rows | 1052 |
| Duplicate rows (%) | 7.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 1052 (7.6%) duplicate rows | Duplicates |
Flow has 2227 (16.0%) missing values | Missing |
Reproduction
| Analysis started | 2024-05-12 19:34:58.502278 |
|---|---|
| Analysis finished | 2024-05-12 19:35:00.659258 |
| Duration | 2.16 seconds |
| Missing | Q_Station_NA_25027270_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING
| Distinct | 3403 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 2227 |
| Missing (%) | 16.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.010677937 |
|---|---|
| Minimum | -2448 |
| Maximum | 2664 |
| Zeros | 74 |
| Zeros (%) | 0.5% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -2448 |
|---|---|
| 5-th percentile | -410.46 |
| Q1 | -110 |
| median | 4 |
| Q3 | 122 |
| 95-th percentile | 371 |
| Maximum | 2664 |
| Range | 5112 |
| Interquartile range (IQR) | 232 |
Descriptive statistics
| Standard deviation | 254.04775 |
|---|---|
| Coefficient of variation (CV) | 23791.838 |
| Kurtosis | 9.7569031 |
| Mean | 0.010677937 |
| Median Absolute Deviation (MAD) | 116 |
| Skewness | -0.20924161 |
| Sum | 124.43 |
| Variance | 64540.258 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 23 |
|---|---|
| min | 5 days |
| max | 2 years and 6 days |
| mean | 13 weeks, 6 days and 16 hours |
| std | 22 weeks, 5 days and 19 hours |
| Value | Count | Frequency (%) |
| 0 | 74 | 0.5% |
| 8 | 42 | 0.3% |
| 6 | 40 | 0.3% |
| -8 | 39 | 0.3% |
| -6 | 38 | 0.3% |
| 25 | 37 | 0.3% |
| 24 | 36 | 0.3% |
| -4 | 36 | 0.3% |
| 3 | 35 | 0.3% |
| 2 | 34 | 0.2% |
| Other values (3393) | 11242 | |
| (Missing) | 2227 | 16.0% |
| Value | Count | Frequency (%) |
| -2448 | 1 | |
| -2411 | 1 | |
| -2224 | 1 | |
| -2158 | 1 | |
| -2105 | 1 | |
| -1976 | 1 | |
| -1891 | 1 | |
| -1770 | 1 | |
| -1760 | 1 | |
| -1576 | 1 |
| Value | Count | Frequency (%) |
| 2664 | 1 | |
| 2583 | 1 | |
| 2242 | 1 | |
| 2034 | 1 | |
| 1947 | 1 | |
| 1700 | 1 | |
| 1600 | 1 | |
| 1571 | 1 | |
| 1502 | 1 | |
| 1459 | 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 | -60.0 |
| 1983-01-05 | 50.0 |
| 1983-01-06 | -3.0 |
| 1983-01-07 | 5.0 |
| 1983-01-08 | -5.0 |
| 1983-01-09 | 140.0 |
| 1983-01-10 | -387.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 110.3 |
| 2020-12-23 | -23.3 |
| 2020-12-24 | 131.0 |
| 2020-12-25 | 183.8 |
| 2020-12-26 | -365.4 |
| 2020-12-27 | 373.1 |
| 2020-12-28 | -563.7 |
| 2020-12-29 | 295.6 |
| 2020-12-30 | -66.0 |
| 2020-12-31 | -96.4 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 1051 | NaN | 2227 |
| 537 | 0.0 | 74 |
| 547 | 8.0 | 42 |
| 545 | 6.0 | 40 |
| 529 | -8.0 | 39 |
| 531 | -6.0 | 38 |
| 568 | 25.0 | 37 |
| 533 | -4.0 | 36 |
| 566 | 24.0 | 36 |
| 541 | 3.0 | 35 |