Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

filter based on column values

degananda264
Level 1
filter based on column values

plese refer python code here 

lsa=["esis","dega"] #sometimes lsa will be "NaN", "","NA"

if lsa not in ["NaN","NA",""]:

       df=df[df['column_name'].isin([lsa])

else:

      do nothing

 

could you please convert the same using dataiku formulas

 

0 Kudos
1 Reply
JordanB
Dataiker

Hi @degananda264,

You can do a filter rows with a simple formula such as the one shown below.

Screen Shot 2023-04-14 at 10.34.12 AM.png

Your formula would look something like Isa == "Nan" || Isa == "Na" || Isa == ""

Please let me know if this does not work for you.

Thanks!

Jordan

0 Kudos