Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

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
3 Replies
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
degananda264
Level 1
Author

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

0 Kudos
JordanB
Dataiker

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

0 Kudos