Handling Missing Values ​

Function Description ​

TIP

Fill missing values (NaN) in the data table with a fixed value, fill with the previous value, fill with the next value, or delete missing values.

Configuration Item Description ​

General ​

Command Input

  • Data Table ObjectTDataTable: The variable returned by the 'Create Data Table' component can be used.

  • Missing Value TypeInteger: Process specified missing value types, including NaN, None, and empty strings.

  • Processing AreaInteger: Processing Area

  • Row/Column Name/NumberInteger: Row/Column Name/Number

  • Row Namestring: Supports single or multiple rows, an empty value indicates the entire table. Example: [1], [1,2,3]. The default row name is the first element of each row in the data table.

  • Column Namestring: Supports single or multiple columns, an empty value indicates the entire table. Example: ['A'], ['A','B','C']

  • Row Numberstring: Supports single or multiple rows, an empty value indicates the entire table. Example: [1], [1,2,3]

  • Column Numberstring: Supports single or multiple columns, an empty value indicates the entire table. Example: [1], [1,2,3]

  • Method of HandlingInteger: Supports filling missing values with a specified value, filling with the previous value (previous row/column), filling with the next value (next row/column), or deleting the row/column where the missing value exists.

  • Fill Valuestring: Fill all missing values with the specified value.

  • Deletion ConditionInteger: Supports deleting the row/column if there is a missing value in the specified row/column, or only deleting the row/column if all values in the specified row/column are missing values.

  • Preview in Data TableBoolean: Preview in Data Table

  • Print Component's Output Variable ValueBoolean: After checking, the component will output the generated variable data or variable value and print it to the console output log.

Command Output

  • Result After HandlingTDataTable: The data table after handling the missing values.

Error Handling ​

  • Print Error LogsBoolean: Whether to print error logs to the "Logs" panel when the command fails. Default is checked.

  • Handling MethodInteger:

    • Terminate Process: If the command fails, terminate the process.

    • Ignore Exception and Continue Execution: If the command fails, ignore the exception and continue the process.

    • Retry This Command: If the command fails, retry the command a specified number of times with a specified interval between retries.

Usage Example ​

Process logic description:

Common Errors and Handling ​

None

Frequently Asked Questions ​

None