Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells3966
Missing cells (%)28.6%
Duplicate rows1076
Duplicate rows (%)7.8%
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-12T15:33:39.747367image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T15:33:40.158763image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 1076 (7.8%) duplicate rowsDuplicates
Flow has 3966 (28.6%) missing valuesMissing

Reproduction

Analysis started2024-05-12 19:33:37.663328
Analysis finished2024-05-12 19:33:39.645805
Duration1.98 second
MissingQ_Station_NA_24067020_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING 

Distinct6336
Distinct (%)63.9%
Missing3966
Missing (%)28.6%
Infinite0
Infinite (%)0.0%
Mean0.6560692
Minimum-1784.2
Maximum2084
Zeros29
Zeros (%)0.2%
Memory size216.9 KiB
2024-05-12T15:33:40.981121image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum-1784.2
5-th percentile-276.935
Q1-51
median4.8
Q365
95-th percentile254.9545
Maximum2084
Range3868.2
Interquartile range (IQR)116

Descriptive statistics

Standard deviation183.13594
Coefficient of variation (CV)279.14119
Kurtosis11.207918
Mean0.6560692
Median Absolute Deviation (MAD)58
Skewness-0.77167211
Sum6504.27
Variance33538.772
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value0
2024-05-12T15:33:41.635820image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T15:33:43.013057image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps48
min4 days
max7 weeks and 2 days
mean1 week, 3 days and 16 hours
std1 week, 4 days and 8 hours
2024-05-12T15:33:43.524434image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
-2 40
 
0.3%
3 30
 
0.2%
0 29
 
0.2%
9 29
 
0.2%
4 29
 
0.2%
-3 27
 
0.2%
-1 26
 
0.2%
-6 26
 
0.2%
28 26
 
0.2%
17 25
 
0.2%
Other values (6326) 9627
69.4%
(Missing) 3966
28.6%
ValueCountFrequency (%)
-1784.2 1
< 0.1%
-1572.1 1
< 0.1%
-1447.9 1
< 0.1%
-1364.8 1
< 0.1%
-1364 1
< 0.1%
-1342 1
< 0.1%
-1265 1
< 0.1%
-1248 1
< 0.1%
-1247.1 1
< 0.1%
-1224 1
< 0.1%
ValueCountFrequency (%)
2084 1
< 0.1%
1412.8 1
< 0.1%
1137 1
< 0.1%
1111 1
< 0.1%
1010 1
< 0.1%
968.6 1
< 0.1%
967.5 1
< 0.1%
966 1
< 0.1%
932.5 1
< 0.1%
909.2 1
< 0.1%
2024-05-12T15:33:42.267987image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

2024-05-12T15:33:38.978704image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Missing values

2024-05-12T15:33:39.354518image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T15:33:39.558631image/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-01NaN
1983-01-02NaN
1983-01-03NaN
1983-01-04NaN
1983-01-05NaN
1983-01-06NaN
1983-01-07NaN
1983-01-08NaN
1983-01-09NaN
1983-01-10NaN
Flow
Date
2020-12-22195.77
2020-12-23-33.99
2020-12-24-26.41
2020-12-25155.60
2020-12-26-143.33
2020-12-27-123.04
2020-12-28153.93
2020-12-2982.83
2020-12-30-177.71
2020-12-31110.68

Duplicate rows

Most frequently occurring

Flow# duplicates
1075NaN3966
450-2.040
5093.030
4700.029
5224.029
5769.029
441-3.027
415-6.026
460-1.026
69728.026