Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells1179
Missing cells (%)8.5%
Duplicate rows1927
Duplicate rows (%)13.9%
Total size in memory216.9 KiB
Average record size in memory16.0 B

Variable types

TimeSeries1

Timeseries statistics

Number of series1
Time series length13880
Starting point1983-01-01 00:00:00
Ending point2020-12-31 00:00:00
Period1 day
2024-05-12T14:17:42.646818image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:17:43.042412image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1927 (13.9%) duplicate rowsDuplicates
Flow has 1179 (8.5%) missing valuesMissing
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:17:40.269649
Analysis finished2024-05-12 18:17:42.430978
Duration2.16 seconds
MissingQ_Station_NA_25027050_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING  NON STATIONARY  SEASONAL 

Distinct4366
Distinct (%)34.4%
Missing1179
Missing (%)8.5%
Infinite0
Infinite (%)0.0%
Mean1378.076
Minimum121.6
Maximum4539
Zeros0
Zeros (%)0.0%
Memory size216.9 KiB
2024-05-12T14:17:43.773135image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum121.6
5-th percentile616
Q1962.1
median1294.4
Q31692.8
95-th percentile2433.7
Maximum4539
Range4417.4
Interquartile range (IQR)730.7

Descriptive statistics

Standard deviation578.98225
Coefficient of variation (CV)0.4201381
Kurtosis1.9688883
Mean1378.076
Median Absolute Deviation (MAD)363.6
Skewness1.0077564
Sum17502944
Variance335220.44
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value1.325980977 × 10-18
2024-05-12T14:17:44.349627image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:17:46.649912image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps19
min4 days
max1 year and 4 days
mean8 weeks, 6 days and 8 hours
std15 weeks, 4 days and 11 hours
2024-05-12T14:17:47.076295image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
1343 21
 
0.2%
1074 21
 
0.2%
1110 20
 
0.1%
1178 19
 
0.1%
1181 19
 
0.1%
1173 19
 
0.1%
1220 19
 
0.1%
1093 18
 
0.1%
1150 18
 
0.1%
1292 17
 
0.1%
Other values (4356) 12510
90.1%
(Missing) 1179
 
8.5%
ValueCountFrequency (%)
121.6 2
< 0.1%
129.4 1
< 0.1%
138 1
< 0.1%
140 1
< 0.1%
147.1 1
< 0.1%
147.4 1
< 0.1%
154.1 1
< 0.1%
156.7 1
< 0.1%
157.4 1
< 0.1%
158.4 1
< 0.1%
ValueCountFrequency (%)
4539 1
< 0.1%
4531 2
< 0.1%
4522 2
< 0.1%
4514 1
< 0.1%
4497 1
< 0.1%
4472 1
< 0.1%
4463 1
< 0.1%
4446 1
< 0.1%
4438 1
< 0.1%
4421 1
< 0.1%
2024-05-12T14:17:45.900956image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

2024-05-12T14:17:41.804121image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Missing values

2024-05-12T14:17:42.134677image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:17:42.331323image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

Flow
Date
1983-01-01746.0
1983-01-02812.0
1983-01-03834.0
1983-01-04903.0
1983-01-05844.0
1983-01-06816.0
1983-01-07792.0
1983-01-08792.0
1983-01-09842.0
1983-01-10855.0
Flow
Date
2020-12-22962.38
2020-12-23953.02
2020-12-24989.34
2020-12-251058.50
2020-12-261063.90
2020-12-271419.40
2020-12-28NaN
2020-12-29NaN
2020-12-30NaN
2020-12-31NaN

Duplicate rows

Most frequently occurring

Flow# duplicates
1926NaN1179
6401074.021
9191343.021
6771110.020
7431173.019
7481178.019
7511181.019
7951220.019
6601093.018
7181150.018