-
Python recipe Excel packages
Hello everyone, I have an issue while constructing excel with python recipe. I need to use precise packages (xlsxwriter, xlwings, openpyxl and so on) that work very well in Anaconda.But in Dataiku python recipe it's not the case. In my mind with python recipe I could do whatever python usually does. Ex below of a line that…
-
folder.get_download_stream I/O operation on closed file
Hi experts, Dataiku prompts this error ValueError: I/O operation on closed file. when I tried to execute the script below: with folder.get_download_stream(path_csv) as f: data = pd.read_csv(f, encoding='latin-1') The reason I put that encoding is due to the utf-8 error if encoding is not specified ( 'utf-8' codec can't…
-
linear programming for schedule optimization
Is there anyone out there who is using a linear programming approach for scheduling; who would be willing to share some knowledge. I have about 1500 people to schedule into 8-10 events (shifts), with participant availability constraints, event capacity constraints, and possibly some other constraints I’m not yet aware of.…
-
Way to include current user ID in SQL table names?
Hello all, Does anyone know of a way to automatically include the current user ID in SQL table name. I've seen references in the documentation to the variable dssUserLogin so I thought the following might work: ${projectKey}_${dssUserLogin}_TABLENAME However this variable is not recognized in SQL recipes. I also tried…
-
Dataiku MLFlow integration
Hi Dataiku Team, I am trying to integrate the MLFLOW models into DSS, which I have successfully done as per the DSS 10 documentation. I am interested in knowing if we would be able to connect with the ground truth data (lets say from (snowflake DB) for the models that we have imported from mlflow into DSS, so that we would…
-
Extracting filename from imported data files
I am trying to extract the file name of multiple csv files from: 1. Folder (with uploaded csv data files) --> 2. Created dataset from these files --> 3. Prepare recipe, using [Misc] --> Enrich records with context information --> 4. Key in a field header name under "output filename column" However, all the records are…
-
Retrieve feature importance from partioned model
Hello, Is there a way to automatically retrieve (via a recipe) features importances of a partitioned model, by partition, in DSS please ? I tried to do it through a python recipe with the following code: import dataikuimport pandas as pdclient = dataiku.api_client()project =…
-
Creating an excel output with multiple sheet
I am trying to create and excel output with multiple sheet. This is what i've come up with so far. with output.get_writer("Summary_File"+current_day+".xlsx") as writer: report_df.to_excel(writer, sheet_name='summary') cleaned_inbound_prepared_distinct_prepared_joined_df.to_excel(writer, sheet_name='Duplicates')…
-
Embed Web APP Internally
TLDR: How can I embed a web application into an internal website with authentication or remove dataiku headers? I have a scenario where our users use various platforms to consume their data. Mainly some other very large BI tools. We provide all the reports / dashboards / and web applications embedded within one…
-
Unable to join 2 datasets
Hi, I am going through Business Analyst quick start tutorial and I am unable to join 2 datasets. I have attached the screenshot.
