Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 1365 |
| Missing cells (%) | 9.8% |
| Duplicate rows | 795 |
| Duplicate rows (%) | 5.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 795 (5.7%) duplicate rows | Duplicates |
Flow has 1365 (9.8%) missing values | Missing |
Reproduction
| Analysis started | 2024-05-12 19:35:09.650889 |
|---|---|
| Analysis finished | 2024-05-12 19:35:11.427583 |
| Duration | 1.78 second |
| Missing | Q_Station_NA_25027640_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING 
| Distinct | 2982 |
|---|---|
| Distinct (%) | 23.8% |
| Missing | 1365 |
| Missing (%) | 9.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.024003196 |
|---|---|
| Minimum | -4646 |
| Maximum | 4308 |
| Zeros | 117 |
| Zeros (%) | 0.8% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -4646 |
|---|---|
| 5-th percentile | -237 |
| Q1 | -53 |
| median | 1 |
| Q3 | 54 |
| 95-th percentile | 230.3 |
| Maximum | 4308 |
| Range | 8954 |
| Interquartile range (IQR) | 107 |
Descriptive statistics
| Standard deviation | 224.48974 |
|---|---|
| Coefficient of variation (CV) | 9352.4936 |
| Kurtosis | 67.491502 |
| Mean | 0.024003196 |
| Median Absolute Deviation (MAD) | 53 |
| Skewness | -0.29156623 |
| Sum | 300.4 |
| Variance | 50395.642 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 19 |
|---|---|
| min | 5 days |
| max | 1 year and 6 days |
| mean | 10 weeks, 2 days and 16 hours |
| std | 16 weeks, 2 days and 23 hours |
| Value | Count | Frequency (%) |
| 0 | 117 | 0.8% |
| -2 | 86 | 0.6% |
| 14 | 81 | 0.6% |
| 3 | 81 | 0.6% |
| 4 | 78 | 0.6% |
| -11 | 76 | 0.5% |
| -3 | 76 | 0.5% |
| -6 | 73 | 0.5% |
| 16 | 72 | 0.5% |
| 8 | 72 | 0.5% |
| Other values (2972) | 11703 | |
| (Missing) | 1365 | 9.8% |
| Value | Count | Frequency (%) |
| -4646 | 1 | |
| -4030 | 1 | |
| -2805 | 1 | |
| -2613 | 1 | |
| -2467 | 1 | |
| -2459 | 1 | |
| -2303 | 1 | |
| -2178 | 1 | |
| -2173 | 1 | |
| -2121 | 1 |
| Value | Count | Frequency (%) |
| 4308 | 1 | |
| 2947 | 1 | |
| 2833 | 1 | |
| 2787 | 1 | |
| 2600 | 1 | |
| 2460 | 1 | |
| 2450 | 1 | |
| 2391.9 | 1 | |
| 2301 | 1 | |
| 2276 | 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 | 205.0 |
| 1983-01-05 | -227.0 |
| 1983-01-06 | 110.0 |
| 1983-01-07 | 77.0 |
| 1983-01-08 | -120.0 |
| 1983-01-09 | 174.0 |
| 1983-01-10 | -264.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 110.4 |
| 2020-12-23 | -72.4 |
| 2020-12-24 | 85.3 |
| 2020-12-25 | -101.2 |
| 2020-12-26 | 93.0 |
| 2020-12-27 | -67.3 |
| 2020-12-28 | -7.2 |
| 2020-12-29 | -87.4 |
| 2020-12-30 | 192.0 |
| 2020-12-31 | -91.2 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 794 | NaN | 1365 |
| 404 | 0.0 | 117 |
| 399 | -2.0 | 86 |
| 412 | 3.0 | 81 |
| 433 | 14.0 | 81 |
| 414 | 4.0 | 78 |
| 378 | -11.0 | 76 |
| 397 | -3.0 | 76 |
| 390 | -6.0 | 73 |
| 408 | 1.0 | 72 |