-
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…
-
Convert scientific numbers
Hello, I would like to convert numbers in scientific fromat (1,5E7 for example) in a number format (1 500 000,00). Does someone know how to do that ? Thank you !
-
Dataset overwritten instead of error
When building datasets I have seen that, on changes to the schema given by the recipe, the dataset is fully overwritten, data and all. This means that, when a recipe suddenly does not return the correct schema, all previous data is lost… Previously we did get an error message if this was the case and we would not lose any…
-
Sorting dates in Pivot Tables
Hey everyone! I created one Pivot Table as an Insight to include it in my Dashboard. The Dataset has a date column. It is parsed correctly and the Insight has recognised the field as date. In the dataset, the table is ordered by the date field Descending. However, when I create the Insight with the Pivot Table, the only…
-
Possible to set importLibrariesFromProjects using Python
Hi, I need to be able to set importLibrariesFromProjects using Python, is this possible? thx Operating system used: Windows10
-
How to shift data in a column
I have a main question and as part of my solution to it I have a follow up question: Main question: I have a column in my time series data (let's call it status) that is populated with on/ off binary data. I need to find a way to create a column to count the days since last time status was on. so basically when the status…
-
Password of connection visible via Python API
When I look at a connection in the settings password, this one is hide. But when I use the python API with: conn = dataiku.get_connection('my_con_name') conn.conn_details['params']['password'] It looks like a security issue, no?
-
Append data from a non-SQL step to a SQL table without dropping the SQL table
Hello, I'm trying to append data to my SQL table, but using the DSS recipe (Sync, Prepare), the SQL table is dropped and overwritten. Is there a way to only append? Thanks
-
Encountering a problem, trying to create a new branch
In Version Control, I tried to create a branch while duplicating the project. However i encounter the following problem: There seems to be a reference to an old code env, that doesn't exist anymore. However, I cannot find where the reference is. I already tried to manually set all notebook envs, as well as python-recipe…
-
Missing columns in Schema when using API Connect
Hi all, I'm using the API connect plugin to connect to an external dataset. The plugin works like a charm, but some columns do not end up in the schema for some reason. Exploring the dataset gives me 109 columns, while the schema shows me 101 columns. The columns are also missing a format (like "string") and are…
