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
Answers
-
JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 296 Dataiker
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 Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 5 ✭
How to delete a file in a managed folder like in onedrive folder ?
-
JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 296 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.managedfolder.DSSManagedFolder.delete_file
Thanks!
Jordan