Missing Time Imputation

Missing Time Imputation

Missing Time Imputation is located under
Forecasting > Data Preparation > Missing Time Imputation
Use the drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis.

Imputing missing values is an important step when dealing with data. It is also one of the steps involved in Data Analysis. In time-series analysis, missing dates play a significant role in the overall analysis. If the missing dates are untouched, the performance of many time-series machine-learning models will be affected.

Properties of Missing Time Imputation


The available properties of Missing Time Imputation are shown in the figure given below.




The table given below describes different fields present on the properties of missing time imputation.

Field

Description

Remark


It helps to execute the node.

–


It helps to explore the successful node.

–


It displays the following options in the list view.

  • Run from node,
  • Run till node,
  • Explore,
  • Delete

–

Task Name

It is the name of the task selected on the workbook canvas.

You can click the text field to edit or modify the task name as required.

Time Variables

It allows you to select time variables to perform missing time imputation.

  • Multiple data fields can be selected.
  • Only the interval data fields for the selected reader are visible.

Frequency

Frequency options define the frequency at which time series data is measured.
Choosing the appropriate frequency option depends on the nature of the data and the analysis requirements.

Here are some commonly used frequency options:

  • Business Days (B)
  • Business Month End (BM)
  • Business Month Start (BMS)
  • Business Quarter End (BQ)
  • Business Quarter Start (BQS)
  • Business Year End (BA)
  • Business Year Start (BAS)
  • Custom Business Month End (CBM)
  • Custom Business Month Start (CBMS)
  • Day (D)
  • Month (M)
  • Month Start (MS)
  • Quarter (Q)
  • Quarter Start (QS)
  • Semi-Month End (SM)
  • Semi-Month Start (SMS)
  • Week (W)
  • Year (Y)
  • Year Start (YS)

Select Imputation Method

It allows you to select the imputation method from the drop-list to apply for the selected data fields.

The available imputation methods are,

  • Forwardfill
  • Backwardfill
  • Remove
  • Constant

Exclude Public Holiday

It excludes the public holidays while imputing the missing values.



    • Related Articles

    • Missing Value Imputation

      Missing Value Imputation is located under Model Studio ( ) in Data Preparation, in the task pane on the left. Use the drag-and-drop method to use algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Refer ...

    • Missing Value Imputation

      Missing Value Imputation is located under Model Studio ( ) in Data Preparation, in the task pane on the left. Use the drag-and-drop method to use algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Refer ...

    • Date and Time Formatting on Chart

      In RubiSight, when you plot a chart using the Date and Time formatting feature, the coordinates of the plot appear in the standard ISO format, by default, as given below. Format: YYYY-MM-DD HH:MM:SS Where, YYYY-MM-DD is the date components of the ...

    • Classification

      Notes: The Reader (Dataset) should be connected to the algorithm. Missing values should not be present in any rows or columns of the reader. To find out missing values in a data, use Descriptive Statistics. Refer to Descriptive Statistics. If missing ...

    • Components in Forecasting

      Forecasting deals with the analysis and detection of trends in the time-series data. The components of forecasting are, Data Exploration: Data Exploration is used to explore the time-series data. It helps in identifying the underlying parameters ...