Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 5436 |
| Missing cells (%) | 39.2% |
| Duplicate rows | 1117 |
| Duplicate rows (%) | 8.0% |
| 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 1117 (8.0%) duplicate rows | Duplicates |
Flow has 5436 (39.2%) missing values | Missing |
Reproduction
| Analysis started | 2024-05-12 19:33:53.492024 |
|---|---|
| Analysis finished | 2024-05-12 19:33:54.842524 |
| Duration | 1.35 second |
| Missing | Q_Station_NA_23167010_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING 
| Distinct | 2987 |
|---|---|
| Distinct (%) | 35.4% |
| Missing | 5436 |
| Missing (%) | 39.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8675959 |
|---|---|
| Minimum | -2634 |
| Maximum | 2652 |
| Zeros | 100 |
| Zeros (%) | 0.7% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -2634 |
|---|---|
| 5-th percentile | -465 |
| Q1 | -172 |
| median | -13 |
| Q3 | 160.475 |
| 95-th percentile | 516 |
| Maximum | 2652 |
| Range | 5286 |
| Interquartile range (IQR) | 332.475 |
Descriptive statistics
| Standard deviation | 305.58573 |
|---|---|
| Coefficient of variation (CV) | 163.62519 |
| Kurtosis | 4.0397427 |
| Mean | 1.8675959 |
| Median Absolute Deviation (MAD) | 166 |
| Skewness | 0.39097977 |
| Sum | 15769.98 |
| Variance | 93382.64 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 102 |
|---|---|
| min | 4 days |
| max | 5 years, 9 weeks and 6 days |
| mean | 7 weeks, 3 days and 15 hours |
| std | 29 weeks, 3 days and 17 hours |
| Value | Count | Frequency (%) |
| 0 | 100 | 0.7% |
| -75 | 21 | 0.2% |
| -18 | 20 | 0.1% |
| -90 | 19 | 0.1% |
| 115 | 19 | 0.1% |
| 18 | 19 | 0.1% |
| -5 | 19 | 0.1% |
| -49 | 18 | 0.1% |
| -20 | 18 | 0.1% |
| -103 | 18 | 0.1% |
| Other values (2977) | 8173 | |
| (Missing) | 5436 |
| Value | Count | Frequency (%) |
| -2634 | 1 | |
| -1674 | 1 | |
| -1615 | 1 | |
| -1584 | 1 | |
| -1551 | 1 | |
| -1524 | 1 | |
| -1435 | 1 | |
| -1358 | 1 | |
| -1328 | 1 | |
| -1293 | 1 |
| Value | Count | Frequency (%) |
| 2652 | 1 | |
| 2511 | 1 | |
| 1795 | 1 | |
| 1783 | 1 | |
| 1536 | 1 | |
| 1534 | 1 | |
| 1533 | 1 | |
| 1484 | 1 | |
| 1467 | 1 | |
| 1427 | 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 | 201.0 |
| 2020-12-23 | -235.7 |
| 2020-12-24 | -355.7 |
| 2020-12-25 | 149.6 |
| 2020-12-26 | 289.8 |
| 2020-12-27 | -187.4 |
| 2020-12-28 | 195.4 |
| 2020-12-29 | -97.9 |
| 2020-12-30 | -361.9 |
| 2020-12-31 | 133.5 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 1116 | NaN | 5436 |
| 554 | 0.0 | 100 |
| 464 | -75.0 | 21 |
| 532 | -18.0 | 20 |
| 440 | -90.0 | 19 |
| 548 | -5.0 | 19 |
| 576 | 18.0 | 19 |
| 684 | 115.0 | 19 |
| 427 | -103.0 | 18 |
| 492 | -49.0 | 18 |