Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 1267 |
| Missing cells (%) | 9.1% |
| Duplicate rows | 1196 |
| Duplicate rows (%) | 8.6% |
| 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 1196 (8.6%) duplicate rows | Duplicates |
Flow has 1267 (9.1%) missing values | Missing |
Reproduction
| Analysis started | 2024-05-12 19:34:02.924919 |
|---|---|
| Analysis finished | 2024-05-12 19:34:05.457855 |
| Duration | 2.53 seconds |
| Missing | Q_Station_NA_23187280_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING
| Distinct | 3156 |
|---|---|
| Distinct (%) | 25.0% |
| Missing | 1267 |
| Missing (%) | 9.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.072504559 |
|---|---|
| Minimum | -2207 |
| Maximum | 2712 |
| Zeros | 65 |
| Zeros (%) | 0.5% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -2207 |
|---|---|
| 5-th percentile | -428.4 |
| Q1 | -130 |
| median | 1 |
| Q3 | 140.7 |
| 95-th percentile | 414 |
| Maximum | 2712 |
| Range | 4919 |
| Interquartile range (IQR) | 270.7 |
Descriptive statistics
| Standard deviation | 261.2597 |
|---|---|
| Coefficient of variation (CV) | -3603.3555 |
| Kurtosis | 4.0382475 |
| Mean | -0.072504559 |
| Median Absolute Deviation (MAD) | 135 |
| Skewness | -0.16846052 |
| Sum | -914.5 |
| Variance | 68256.632 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 41 |
|---|---|
| min | 4 days |
| max | 22 weeks |
| mean | 4 weeks, 3 days and 20 hours |
| std | 5 weeks, 4 days and 2 hours |
| Value | Count | Frequency (%) |
| 0 | 65 | 0.5% |
| -8 | 36 | 0.3% |
| -36 | 36 | 0.3% |
| 9 | 36 | 0.3% |
| -22 | 33 | 0.2% |
| -32 | 33 | 0.2% |
| 20 | 33 | 0.2% |
| 1 | 32 | 0.2% |
| -109 | 32 | 0.2% |
| -72 | 32 | 0.2% |
| Other values (3146) | 12245 | |
| (Missing) | 1267 | 9.1% |
| Value | Count | Frequency (%) |
| -2207 | 1 | |
| -2068 | 1 | |
| -1747 | 1 | |
| -1603 | 1 | |
| -1578 | 1 | |
| -1541 | 1 | |
| -1414 | 1 | |
| -1335 | 1 | |
| -1302 | 1 | |
| -1291 | 1 |
| Value | Count | Frequency (%) |
| 2712 | 1 | |
| 1574 | 1 | |
| 1516 | 1 | |
| 1354 | 1 | |
| 1261 | 1 | |
| 1235 | 1 | |
| 1234 | 1 | |
| 1204 | 1 | |
| 1144 | 1 | |
| 1138 | 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 | 45.0 |
| 1983-01-04 | 184.0 |
| 1983-01-05 | -154.0 |
| 1983-01-06 | -347.0 |
| 1983-01-07 | 450.0 |
| 1983-01-08 | 455.0 |
| 1983-01-09 | -617.0 |
| 1983-01-10 | -237.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | -6.0 |
| 2020-12-23 | 144.8 |
| 2020-12-24 | -272.1 |
| 2020-12-25 | 70.0 |
| 2020-12-26 | 191.3 |
| 2020-12-27 | 26.5 |
| 2020-12-28 | -233.1 |
| 2020-12-29 | 339.5 |
| 2020-12-30 | -294.7 |
| 2020-12-31 | -108.4 |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 1195 | NaN | 1267 |
| 603 | 0.0 | 65 |
| 562 | -36.0 | 36 |
| 593 | -8.0 | 36 |
| 614 | 9.0 | 36 |
| 566 | -32.0 | 33 |
| 576 | -22.0 | 33 |
| 626 | 20.0 | 33 |
| 474 | -109.0 | 32 |
| 514 | -72.0 | 32 |