filter based on column values

[degananda264]

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

[JordanB]

Hi @degananda264,

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

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

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

Thanks!

Jordan

 

[degananda264]

How to delete a file in a managed folder like in onedrive folder ?

[JordanB]

Hi @degananda264,

You will need to have the necessary Microsoft API permissions to delete: https://www.dataiku.com/product/plugins/onedrive/

You can delete a file on a managed folder from the DSS user interface or using DSS Python APIs: https://developer.dataiku.com/latest/api-reference/python/managed-folders.html#dataikuapi.dss.manage...

Thanks!

Jordan