Data Preparation

AnoFox Forecast provides 14 data preparation functions across 4 categories: gap filling (2 functions for missing timestamps), series filtering (4 functions to remove constant, short, gappy, or all-zero series), edge cleaning (3 functions for leading/trailing zero removal), and imputation (5 functions including forward fill, backward fill, mean fill, constant fill, and differencing). These functions operate on grouped time series data, processing all series in a single SQL call. Clean data is a prerequisite for reliable forecasts -- gaps and structural artifacts in the input directly degrade model accuracy.

Clean, transform, and prepare your time series data for forecasting.

Categories

Gap Filling

Fill missing timestamps in time series

fill_gapsfill_forward

Series Filtering

Remove constant, short, gappy, or zero series

drop_constantdrop_shortdrop_gappy+1 more

Edge Cleaning

Remove leading/trailing zeros

drop_leading_zerosdrop_trailing_zeros+1 more

Imputation

Fill missing values and transform data

fill_nulls_*diff

All Functions

All CategoryEdge CleaningFilteringGap FillingImputation

Function	Category	Description
anofox_fcst_ts_fill_gaps_by	Gap Filling	Fill missing timestamps with NULL values
anofox_fcst_ts_fill_forward_by	Gap Filling	Extend series to target date
anofox_fcst_ts_drop_constant	Filtering	Remove series with no variation
anofox_fcst_ts_drop_short	Filtering	Remove series below minimum length
anofox_fcst_ts_drop_gappy	Filtering	Remove series exceeding max gap ratio
anofox_fcst_ts_drop_zeros	Filtering	Remove all-zero series
anofox_fcst_ts_drop_leading_zeros	Edge Cleaning	Remove initial zero values
anofox_fcst_ts_drop_trailing_zeros	Edge Cleaning	Remove trailing zero values
anofox_fcst_ts_drop_edge_zeros	Edge Cleaning	Remove both leading and trailing zeros
anofox_fcst_ts_fill_nulls_const	Imputation	Replace NULLs with constant value
anofox_fcst_ts_fill_nulls_forward	Imputation	Forward fill (LOCF)
anofox_fcst_ts_fill_nulls_backward	Imputation	Backward fill (NOCB)
anofox_fcst_ts_fill_nulls_mean	Imputation	Fill with series mean
anofox_fcst_ts_diff	Imputation	Differencing transformation

Showing 14 of 14