Fill lets you automatically populate missing values in a given column using a variety of methods.
Fill uses a single utterance:
Fill missing values in the column <column> using the <method> method
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.
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.
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.