Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 3542 |
| Missing cells (%) | 25.5% |
| Duplicate rows | 1370 |
| Duplicate rows (%) | 9.9% |
| 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 1370 (9.9%) duplicate rows | Duplicates |
Flow has 3542 (25.5%) missing values | Missing |
Flow has 228 (1.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-12 19:35:31.079475 |
|---|---|
| Analysis finished | 2024-05-12 19:35:33.100998 |
| Duration | 2.02 seconds |
| Missing | Q_Station_NA_28037090_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING ZEROS
| Distinct | 5565 |
|---|---|
| Distinct (%) | 53.8% |
| Missing | 3542 |
| Missing (%) | 25.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0057741826 |
|---|---|
| Minimum | -190.9 |
| Maximum | 196.8 |
| Zeros | 228 |
| Zeros (%) | 1.6% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -190.9 |
|---|---|
| 5-th percentile | -7.349 |
| Q1 | -1.24475 |
| median | 0 |
| Q3 | 1.3 |
| 95-th percentile | 7.2 |
| Maximum | 196.8 |
| Range | 387.7 |
| Interquartile range (IQR) | 2.54475 |
Descriptive statistics
| Standard deviation | 7.3116554 |
|---|---|
| Coefficient of variation (CV) | 1266.2667 |
| Kurtosis | 130.95208 |
| Mean | 0.0057741826 |
| Median Absolute Deviation (MAD) | 1.3 |
| Skewness | -0.21414691 |
| Sum | 59.6935 |
| Variance | 53.460304 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 34 |
|---|---|
| min | 5 days |
| max | 4 years, 1 week and 2 days |
| mean | 15 weeks, 42 minutes and 21.35 seconds |
| std | 39 weeks, 4 days and 17 hours |
| Value | Count | Frequency (%) |
| 0 | 228 | 1.6% |
| 0.5 | 53 | 0.4% |
| -0.5 | 42 | 0.3% |
| -0.1 | 37 | 0.3% |
| -0.1 | 36 | 0.3% |
| -1 | 33 | 0.2% |
| 0.2 | 31 | 0.2% |
| 0.1 | 29 | 0.2% |
| 0.2 | 27 | 0.2% |
| 0.1 | 25 | 0.2% |
| Other values (5555) | 9797 | |
| (Missing) | 3542 | 25.5% |
| Value | Count | Frequency (%) |
| -190.9 | 1 | |
| -86.4 | 1 | |
| -85.6 | 1 | |
| -85.1 | 1 | |
| -84.1 | 1 | |
| -74.1 | 1 | |
| -73.9 | 1 | |
| -73.4 | 1 | |
| -73 | 1 | |
| -67.4 | 1 |
| Value | Count | Frequency (%) |
| 196.8 | 1 | |
| 93.9 | 1 | |
| 90.6 | 1 | |
| 85.5 | 1 | |
| 83.6 | 1 | |
| 79.7 | 1 | |
| 76 | 1 | |
| 70.2 | 1 | |
| 63.4 | 1 | |
| 58.9 | 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 | 0.1 |
| 1983-01-06 | -0.1 |
| 1983-01-07 | -0.2 |
| 1983-01-08 | 0.4 |
| 1983-01-09 | -0.3 |
| 1983-01-10 | 0.1 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 0.620 |
| 2020-12-23 | -1.437 |
| 2020-12-24 | 0.701 |
| 2020-12-25 | -0.477 |
| 2020-12-26 | 0.791 |
| 2020-12-27 | 0.107 |
| 2020-12-28 | -0.713 |
| 2020-12-29 | 0.272 |
| 2020-12-30 | NaN |
| 2020-12-31 | NaN |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 1369 | NaN | 3542 |
| 689 | 0.0 | 228 |
| 847 | 0.5 | 53 |
| 516 | -0.5 | 42 |
| 642 | -0.1 | 37 |
| 640 | -0.1 | 36 |
| 413 | -1.0 | 33 |
| 772 | 0.2 | 31 |
| 743 | 0.1 | 29 |
| 769 | 0.2 | 27 |