Overview

Dataset statistics

Number of variables1
Number of observations13880
Missing cells141
Missing cells (%)1.0%
Duplicate rows615
Duplicate rows (%)4.4%
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:16:04.298046image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
2024-05-12T14:16:04.659574image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Alerts

Dataset has 615 (4.4%) duplicate rowsDuplicates
Flow has 141 (1.0%) missing valuesMissing
Flow is non stationaryNon stationary
Flow is seasonalSeasonal

Reproduction

Analysis started2024-05-12 18:16:01.837370
Analysis finished2024-05-12 18:16:04.226394
Duration2.39 seconds
MissingQ_Station_NA_22057010_ok_Missing.csv
Download configurationconfig.json

Variables

Flow
Numeric time series

MISSING  NON STATIONARY  SEASONAL 

Distinct1779
Distinct (%)12.9%
Missing141
Missing (%)1.0%
Infinite0
Infinite (%)0.0%
Mean204.78996
Minimum0
Maximum541.83
Zeros9
Zeros (%)0.1%
Memory size216.9 KiB
2024-05-12T14:16:05.151881image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile90
Q1143
median210
Q3257
95-th percentile325
Maximum541.83
Range541.83
Interquartile range (IQR)114

Descriptive statistics

Standard deviation75.487234
Coefficient of variation (CV)0.36860807
Kurtosis-0.28786938
Mean204.78996
Median Absolute Deviation (MAD)56
Skewness0.14505419
Sum2813609.3
Variance5698.3225
MonotonicityNot monotonic
Augmented Dickey-Fuller test p-value2.386949493 × 10-7
2024-05-12T14:16:05.522642image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
2024-05-12T14:16:06.777765image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/

Gap statistics

number of gaps11
min3 days
max2 weeks and 1 day
mean5 days, 8 hours and 43 minutes
std4 days, 4 hours and 16 minutes
2024-05-12T14:16:07.256074image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ValueCountFrequency (%)
224 82
 
0.6%
250 76
 
0.5%
245 75
 
0.5%
260 73
 
0.5%
236 73
 
0.5%
237 71
 
0.5%
248 70
 
0.5%
225 70
 
0.5%
252 69
 
0.5%
267 69
 
0.5%
Other values (1769) 13011
93.7%
(Missing) 141
 
1.0%
ValueCountFrequency (%)
0 9
0.1%
12 1
 
< 0.1%
14 3
 
< 0.1%
15 1
 
< 0.1%
17 1
 
< 0.1%
18 1
 
< 0.1%
19 2
 
< 0.1%
20 7
0.1%
22 6
< 0.1%
25 4
< 0.1%
ValueCountFrequency (%)
541.83 1
< 0.1%
532 1
< 0.1%
510 1
< 0.1%
498 1
< 0.1%
496.04 1
< 0.1%
490 1
< 0.1%
480.23 1
< 0.1%
470 1
< 0.1%
467.96 1
< 0.1%
467 1
< 0.1%
2024-05-12T14:16:05.965554image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
ACF and PACF

Interactions

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

Missing values

2024-05-12T14:16:04.041824image/svg+xmlMatplotlib v3.8.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T14:16:04.160738image/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-01111.0
1983-01-02121.0
1983-01-03124.0
1983-01-04131.0
1983-01-05154.0
1983-01-06139.0
1983-01-07118.0
1983-01-08115.0
1983-01-09106.0
1983-01-10100.0
Flow
Date
2020-12-22NaN
2020-12-23NaN
2020-12-24NaN
2020-12-25NaN
2020-12-26NaN
2020-12-27NaN
2020-12-28NaN
2020-12-29NaN
2020-12-30NaN
2020-12-31NaN

Duplicate rows

Most frequently occurring

Flow# duplicates
614NaN141
312224.082
402250.076
386245.075
356236.073
428260.073
359237.071
319225.070
397248.070
406252.069