Dataset statistics
| Number of variables | 1 |
|---|---|
| Number of observations | 13880 |
| Missing cells | 166 |
| Missing cells (%) | 1.2% |
| Duplicate rows | 441 |
| Duplicate rows (%) | 3.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 441 (3.2%) duplicate rows | Duplicates |
Flow has 166 (1.2%) missing values | Missing |
Flow has 299 (2.2%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-12 19:32:32.943360 |
|---|---|
| Analysis finished | 2024-05-12 19:32:35.553846 |
| Duration | 2.61 seconds |
| Missing | Q_Station_NA_22057010_ok_Missing.csv |
| Download configuration | config.json |
Flow
Numeric time series
MISSING ZEROS
| Distinct | 1898 |
|---|---|
| Distinct (%) | 13.8% |
| Missing | 166 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0073209859 |
|---|---|
| Minimum | -313 |
| Maximum | 218 |
| Zeros | 299 |
| Zeros (%) | 2.2% |
| Memory size | 216.9 KiB |
Quantile statistics
| Minimum | -313 |
|---|---|
| 5-th percentile | -84.2835 |
| Q1 | -16 |
| median | 3 |
| Q3 | 22 |
| 95-th percentile | 68 |
| Maximum | 218 |
| Range | 531 |
| Interquartile range (IQR) | 38 |
Descriptive statistics
| Standard deviation | 47.041837 |
|---|---|
| Coefficient of variation (CV) | 6425.6151 |
| Kurtosis | 4.2218199 |
| Mean | 0.0073209859 |
| Median Absolute Deviation (MAD) | 19 |
| Skewness | -0.86999602 |
| Sum | 100.4 |
| Variance | 2212.9344 |
| Monotonicity | Not monotonic |
| Augmented Dickey-Fuller test p-value | 0 |
Histogram with fixed size bins (bins=50)
Gap statistics
| number of gaps | 9 |
|---|---|
| min | 4 days |
| max | 4 weeks and 5 days |
| mean | 1 week and 2 days |
| std | 1 week, 2 days and 4 hours |
| Value | Count | Frequency (%) |
| 0 | 299 | 2.2% |
| 4 | 261 | 1.9% |
| 3 | 257 | 1.9% |
| -1 | 256 | 1.8% |
| 1 | 251 | 1.8% |
| 2 | 248 | 1.8% |
| 6 | 225 | 1.6% |
| 5 | 216 | 1.6% |
| 8 | 197 | 1.4% |
| 7 | 196 | 1.4% |
| Other values (1888) | 11308 |
| Value | Count | Frequency (%) |
| -313 | 1 | |
| -301 | 1 | |
| -300 | 1 | |
| -291.43 | 1 | |
| -278.06 | 1 | |
| -273 | 2 | |
| -268 | 1 | |
| -263 | 1 | |
| -258 | 1 | |
| -255 | 1 |
| Value | Count | Frequency (%) |
| 218 | 1 | |
| 214 | 1 | |
| 211 | 1 | |
| 199 | 1 | |
| 197 | 1 | |
| 192 | 1 | |
| 190.12 | 1 | |
| 190 | 1 | |
| 189 | 1 | |
| 187 | 2 |
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 | -7.0 |
| 1983-01-04 | 4.0 |
| 1983-01-05 | 16.0 |
| 1983-01-06 | -38.0 |
| 1983-01-07 | -6.0 |
| 1983-01-08 | 18.0 |
| 1983-01-09 | -6.0 |
| 1983-01-10 | 3.0 |
| Flow | |
|---|---|
| Date | |
| 2020-12-22 | NaN |
| 2020-12-23 | NaN |
| 2020-12-24 | NaN |
| 2020-12-25 | NaN |
| 2020-12-26 | NaN |
| 2020-12-27 | NaN |
| 2020-12-28 | NaN |
| 2020-12-29 | NaN |
| 2020-12-30 | NaN |
| 2020-12-31 | NaN |
Most frequently occurring
| Flow | # duplicates | |
|---|---|---|
| 224 | 0.0 | 299 |
| 252 | 4.0 | 261 |
| 245 | 3.0 | 257 |
| 219 | -1.0 | 256 |
| 234 | 1.0 | 251 |
| 241 | 2.0 | 248 |
| 265 | 6.0 | 225 |
| 258 | 5.0 | 216 |
| 276 | 8.0 | 197 |
| 272 | 7.0 | 196 |