Fill

Fill lets you automatically populate missing values in a given column using a variety of methods.

Format

Fill uses a single utterance: Fill missing values in the column <column> using the <method> method

Parameters

Fill uses the following parameters:

• column (required). The column in which to fill in any missing values.
• method (required). The method to use to fill in the missing values. The options include:
  • Mean. Fill in the missing values with the average of the other values.
  • Most Frequent. Fill in the missing values with the most frequent of the other values.

Output

If the missing values are filled successfully, a histogram of the value distribution in the column is shown and a success message appears in the chat history. Otherwise, an error message is shown in the chat history.

Examples

To fill in any missing values in a column called "Age" with the most frequent age, enter Fill missing values in the column Age using the most frequent method.

To fill in any missing values in a column called "Revenue" with the average revenue, enter Fill missing values in the column Revenue using the mean method.