Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 1298 |
| Missing cells (%) | 9.4% |
| Duplicate rows | 2386 |
| Duplicate rows (%) | 17.2% |
| 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 2386 (17.2%) duplicate rows | Duplicates |
Flow has 1298 (9.4%) missing values | Missing |
Flow is non stationary | Non stationary |
Flow is seasonal | Seasonal |
Reproduction
| Analysis started | 2024-05-12 18:17:55.882090 |
|---|---|
| Analysis finished | 2024-05-12 18:17:57.818864 |
| Duration | 1.94 second |
| Missing | Q_Station_NA_25027640_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING NON STATIONARY SEASONAL
| Distinct | 4443 |
|---|---|
| Distinct (%) | 35.3% |
| Missing | 1298 |
| Missing (%) | 9.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2433.9115 |
|---|---|
| Minimum | 14.22 |
| Maximum | 5244 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | 14.22 |
|---|---|
| 5-th percentile | 898.2 |
| Q1 | 1685 |
| median | 2402 |
| Q3 | 3159 |
| 95-th percentile | 4086.9 |
| Maximum | 5244 |
| Range | 5229.78 |
| Interquartile range (IQR) | 1474 |
Descriptive statistics
| Standard deviation | 990.02944 |
|---|---|
| Coefficient of variation (CV) | 0.40676476 |
| Kurtosis | -0.44620424 |
| Mean | 2433.9115 |
| Median Absolute Deviation (MAD) | 738 |
| Skewness | 0.1906057 |
| Sum | 30623474 |
| Variance | 980158.28 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 9.916193239 × 10-14 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 19 |
|---|---|
| min | 3 days |
| max | 1 year and 3 days |
| mean | 9 weeks, 6 days and 2 hours |
| std | 16 weeks, 3 days and 6 hours |
| Value | Count | Frequency (%) |
| 3495 | 23 | 0.2% |
| 2638 | 19 | 0.1% |
| 1258 | 16 | 0.1% |
| 1824 | 16 | 0.1% |
| 1602 | 16 | 0.1% |
| 3474 | 16 | 0.1% |
| 3381 | 16 | 0.1% |
| 3375 | 15 | 0.1% |
| 2761 | 15 | 0.1% |
| 3398 | 15 | 0.1% |
| Other values (4433) | 12415 | |
| (Missing) | 1298 | 9.4% |
| Value | Count | Frequency (%) |
| 14.22 | 1 | |
| 17.53 | 1 | |
| 25.25 | 1 | |
| 32.97 | 1 | |
| 34.08 | 1 | |
| 35.18 | 1 | |
| 58.56 | 1 | |
| 63.4 | 1 | |
| 69.45 | 2 | |
| 76.71 | 1 |
| Value | Count | Frequency (%) |
| 5244 | 1 | < 0.1% |
| 5236 | 1 | < 0.1% |
| 5227 | 1 | < 0.1% |
| 5202 | 2 | < 0.1% |
| 5177 | 1 | < 0.1% |
| 5168 | 2 | < 0.1% |
| 5160 | 2 | < 0.1% |
| 5151 | 4 | |
| 5143 | 5 | |
| 5135 | 7 |
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 | 1543.0 |
| 1983-01-02 | 1542.0 |
| 1983-01-03 | 1454.0 |
| 1983-01-04 | 1484.0 |
| 1983-01-05 | 1405.0 |
| 1983-01-06 | 1327.0 |
| 1983-01-07 | 1327.0 |
| 1983-01-08 | 1285.0 |
| 1983-01-09 | 1375.0 |
| 1983-01-10 | 1333.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 2547.2 |
| 2020-12-23 | 2514.7 |
| 2020-12-24 | 2548.6 |
| 2020-12-25 | 2547.7 |
| 2020-12-26 | 2605.0 |
| 2020-12-27 | 2653.2 |
| 2020-12-28 | 2685.1 |
| 2020-12-29 | 2613.3 |
| 2020-12-30 | 2629.8 |
| 2020-12-31 | 2643.4 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 2385 | NaN | 1298 |
| 2012 | 3495.0 | 23 |
| 1388 | 2638.0 | 19 |
| 314 | 1258.0 | 16 |
| 561 | 1602.0 | 16 |
| 727 | 1824.0 | 16 |
| 1937 | 3381.0 | 16 |
| 1996 | 3474.0 | 16 |
| 1478 | 2761.0 | 15 |
| 1933 | 3375.0 | 15 |