Verifying Column Details

Objectives

After completing this lesson, you will be able to:

  • Verify data and correct column details

Check and Correct Column Details

Edit Column Details

When building your model, it is important to ensure that the variable metadata is correct and that you update the column details where required.

The key things to check and update, where required, are:

  1. Edit the data Description, if necessary.
  2. Ensure that the Data Type and Statistical Type are correct.
    • Smart Predict provides an initial guess of the data type and statistical type, but the guess can be incorrect. To optimize the automated data encoding, the correct data and statistical types are essential.
    • If the guessed data or statistical type is incorrect, you must update it before training your model.
  3. In the Interpret As Missing Value column, if there are missing values, enter a missing value description.
    • Enter the string that is used to represent the missing values, for example, 999, #NA or #Empty. This value is now assigned as missing in the data encoding process and is not considered to be an actual data value.
    • For example, if a value of 999 is entered into the Interpret As Missing description for a continuous type variable, the data encoding assigns any 999 values as missing.
  4. Indicate which variables are Keys.
Edit column details dialog.

Log in to track your progress & complete quizzes