Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 2155 |
| Missing cells (%) | 15.5% |
| Duplicate rows | 2408 |
| Duplicate rows (%) | 17.3% |
| 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 2408 (17.3%) duplicate rows | Duplicates |
Flow has 2155 (15.5%) missing values | Missing |
Flow is non stationary | Non stationary |
Flow is seasonal | Seasonal |
Reproduction
| Analysis started | 2024-05-12 18:17:48.099248 |
|---|---|
| Analysis finished | 2024-05-12 18:17:49.881772 |
| Duration | 1.78 second |
| Missing | Q_Station_NA_25027270_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING NON STATIONARY SEASONAL
| Distinct | 4884 |
|---|---|
| Distinct (%) | 41.7% |
| Missing | 2155 |
| Missing (%) | 15.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2283.652 |
|---|---|
| Minimum | 228.3 |
| Maximum | 6694 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | 228.3 |
|---|---|
| 5-th percentile | 921.2 |
| Q1 | 1655.1 |
| median | 2245 |
| Q3 | 2841.4 |
| 95-th percentile | 3785 |
| Maximum | 6694 |
| Range | 6465.7 |
| Interquartile range (IQR) | 1186.3 |
Descriptive statistics
| Standard deviation | 879.8907 |
|---|---|
| Coefficient of variation (CV) | 0.38529981 |
| Kurtosis | 0.24309059 |
| Mean | 2283.652 |
| Median Absolute Deviation (MAD) | 593 |
| Skewness | 0.40495827 |
| Sum | 26775820 |
| Variance | 774207.65 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 9.008908054 × 10-18 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 18 |
|---|---|
| min | 3 days |
| max | 2 years and 3 days |
| mean | 17 weeks, 1 day and 10 hours |
| std | 24 weeks, 4 days and 16 hours |
| Value | Count | Frequency (%) |
| 2462 | 18 | 0.1% |
| 2062 | 18 | 0.1% |
| 1284 | 15 | 0.1% |
| 1724 | 14 | 0.1% |
| 1888 | 13 | 0.1% |
| 2366 | 13 | 0.1% |
| 1442 | 13 | 0.1% |
| 2454 | 13 | 0.1% |
| 2282 | 12 | 0.1% |
| 2577 | 12 | 0.1% |
| Other values (4874) | 11584 | |
| (Missing) | 2155 | 15.5% |
| Value | Count | Frequency (%) |
| 228.3 | 1 | |
| 232.4 | 1 | |
| 238.1 | 1 | |
| 239.2 | 1 | |
| 240.8 | 1 | |
| 246.6 | 2 | |
| 246.7 | 1 | |
| 252.5 | 1 | |
| 256.9 | 1 | |
| 258.4 | 1 |
| Value | Count | Frequency (%) |
| 6694 | 1 | |
| 6535 | 2 | |
| 6486 | 1 | |
| 6378 | 1 | |
| 6368 | 1 | |
| 6241 | 1 | |
| 6125 | 1 | |
| 5837 | 1 | |
| 5809 | 1 | |
| 5800 | 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 | 1359.0 |
| 1983-01-02 | 1324.0 |
| 1983-01-03 | 1309.0 |
| 1983-01-04 | 1254.0 |
| 1983-01-05 | 1209.0 |
| 1983-01-06 | 1171.0 |
| 1983-01-07 | 1145.0 |
| 1983-01-08 | 1126.0 |
| 1983-01-09 | 1254.0 |
| 1983-01-10 | 1142.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | 1860.9 |
| 2020-12-23 | 1698.7 |
| 2020-12-24 | 1613.6 |
| 2020-12-25 | 1789.4 |
| 2020-12-26 | 1860.7 |
| 2020-12-27 | 2200.6 |
| 2020-12-28 | 2245.4 |
| 2020-12-29 | 2290.7 |
| 2020-12-30 | 2270.5 |
| 2020-12-31 | 2088.4 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 2407 | NaN | 2155 |
| 979 | 2062.0 | 18 |
| 1366 | 2462.0 | 18 |
| 292 | 1284.0 | 15 |
| 657 | 1724.0 | 14 |
| 412 | 1442.0 | 13 |
| 812 | 1888.0 | 13 |
| 1275 | 2366.0 | 13 |
| 1358 | 2454.0 | 13 |
| 673 | 1741.0 | 12 |