How to fill null or missing values in your data?

AMuresan
AMuresan
in Data preparation

When data is imperfect or has missing values how do i automatically fill it in?

Comments

  • Ali
    Ali

    Hi,

    You need to add Fill tool and connect it to your datasource (or previous node)

    After that you can configure the tool from the left side menue.

    image.png

    Each fill tool works on one type of data (e.g. string, or number) Once you select your column(s) you can input the text.

    Here's how fill works one each column type:

    • Numeric. You can choose to fill empty values with a constant number, an average, a medium, or a mode.
    • Text. Fill empty values with text you specify.
    • Boolean. Fill empty values with TRUE.
    • Date. Fill empty values with the current date or a date you specify.


Categories