-
String dates to datetime format
Hello, is there a way to convert string dates to datetime format? For example Jan-18 to '01-2018'? I know sql has TO_DATE( '10 Aug 2018', 'DD MON YYYY' ) But is there something similar available for dataiku?
-
How to add feature selection into custom prediction algorithm plugin
Hi, I have built a simple XGBoost classifier algorithm by following closely: https://doc.dataiku.com/dss/7.0/plugins/reference/prediction-algorithms.html However, I would like to add UI feature that allows to choose which columns to be included as Xs (features) when applying algorithm. I have a feeling that following part…
-
How to initialize empty dataset?
Hello, In a simplified example I have a flow with two pipelines. On the first pipeline, the final output is a DatasetA. On the second pipeline, the first input is DatasetA. They both link to the same path on the filesystem. The flow is more complicated than this hence why I cannot simply link the two pipelines linearlly.…
-
How to check if column value is in between of two other column values
Hi Team, I am having a use case where I have to create a new column based on 3 columns X, Y and Z. If a value of X is in between the range of columns Y and Z then the new column has the value X else the complete row is deleted. I am using a postgre in - database sql engine for computation. Can you please help me in writing…
-
Can we detach the downstream from the dataset and attach to another dataset ?
Hi Team, Hope you are all doing well during this Pandemic ! I have a question in my use case which is, my dataset has more than 70 million rows and as it is taking more run time for a simple prep recipe. We thought of fastening the development time by taking the sample of it and then running it for now. I have to create a…
-
dataset content in plugin UI
Hey, I have built a dataset that I would like to be displayed near parameters in plugin's UI. Do I have to use method of custom UI shown in documentation or is there a simple way to achieve that? Also can custom UI only be done with python or is it efficient with R too? P.S. would like to take a look into custom UI examples
-
Export DataIku dataset to Excel
Dear experts, I have been trying to understand how I could export an existing DataIku dataset to Excel. By studying the documentation, I suppose there might be an API functionality allowing me to achieve it, but unfortunately I could not find it. More in details: * I have created a dataset in my DataIku project using a…
-
Count occurences of sells per customer
Hi there, I think it must be a very simple task, but I can't find any recipe or formula in order to count the number of sells per customer (I have a colum "orderTransaction" and a column "IDbuyer"). Thank you for your help !
-
Getting local variable in python
Hi, I am trying to create a python script which will bring local variable defined in the project. Then I want to update that local variable in runtime automatically. So for that i tried to use get_variable() function but facing the below error.Is it due to permission problem or anything else? Would like answer on the below…
-
Import rds file and processing it in DSS
Hi I want to import RDS file into Dataiku. I have used Managed Folder with S3 as storage and upload the RDS file into the Managed folder(i.e in S3) I have created an R recipie where i am able to retrieve the data from the Managed folder using dkuManagedFolderDownloadPath R API. I want to convert the RDS format file into…