General Discussion
- I have a currency code column in a dataset with a currency code of VND. It is a valid currency code however Dataiku is flagging this in red and as invalid. How can I add this currency to the Dataiku d…
Last answer by importthepandas@David_Mellamphy
we can add these currencies to our own UDF internally so this is fixed up.Last answer by importthepandas@David_Mellamphy
we can add these currencies to our own UDF internally so this is fixed up. - I am trying to write a pdf filer to dataiku folder. usually I can write pdf file in my device with: with open(outputFile, "wb") as outputStream: output.write(outputStream) but it doesnt work withing D…
Last answer by TurribeachFirst issue, Dataiku's dirty little secret: it doesn't actually create the folder in the file system until you put a file in it. Go to your flow and add a dummy file to the folder manually.
Second issue you can't write directly to a Dataiku folder, use either upload_steam or upload_file:
Last answer by TurribeachFirst issue, Dataiku's dirty little secret: it doesn't actually create the folder in the file system until you put a file in it. Go to your flow and add a dummy file to the folder manually.
Second issue you can't write directly to a Dataiku folder, use either upload_steam or upload_file:
- In the sample project of time-series forecasting of links, I have no expertise in machine learning, but how do you generally do the following two points? ・Regarding the criteria for deciding on a mode…Last answer by
Last answer by jun-suzuki - This question pertains to the functionality of the Speakatoo API and whether it allows text-to-speech conversion without requiring an API key. To clarify, it is essential to understand the API's speci…Last answer by
Last answer by Khushi100Hey,
This focuses on Speakatoo API's capability for text-to-speech conversion without necessitating an API key. Understanding the API's authentication prerequisites and access limitations is crucial to determine its functionality within AI Text to Speech.
- Hi, I am developing a visual application in which the users will upload one excel with multiple sheets (each sheet contains different column headers). One solution is to let users upload it multiple t…Last answer byLast answer by Shashank
You can use the "Excel Sheet Importer" Dataiku Plugin for your use case.
https://www.dataiku.com/product/plugins/excel-sheet-importer/ - How to find Max date from previous month from a dataset using sql for scenario variable. required max date of previous month not last date of previous month. Operating system used: windows Operating s…Last answer byLast answer by Turribeach
Come up with the SQL that gives the date you want. Then follow the steps in the "Using the results of a previous SQL step":
https://doc.dataiku.com/dss/latest/scenarios/variables.html#using-the-results-of-a-previous-sql-step
The SQL step name must not have spaces.
- Greetings! I have a data set consisting of various columns, one being 'US State' - All states are represented multiple times. I would like to compile a random sample consisting of 2 samples for each s…Solution by
Solution by AlexandruHi,
The sampling method in the Sample
-> Class rebalance (approx. nb. records)
Should somewhat achieve this but there is not guarantee it will select exactly 2 samples from each item but instead ensure you have sample from all states.
If you need this specific type of sampling you could use Python recipe. Using Pandas group by / sample on the "state" column.
https://pandas.pydata.org/docs/reference/api/pandas.core.groupby.DataFrameGroupBy.sample.html - Hi - I have a very simple request but I am unable to work it out. I have 2 columns on a dataset which I need to multiply one by the other? Example one column is in USD and then I have a rates column a…Last answer byLast answer by me2
You can do it several ways including using SQL, Python, R, Visual Recipe, etc.
Using a Prepare Visual Recipe:
- Add new step, "Formula" from the Processor Library
- Set the formula to numval("dollars")*numval("rate"). Numval() tells dataiku to use the number value of that row from column "x".
You might have to do some pre-processing if some rows have null values or storage type is not an integer/double .
Have fun!
- i want to create column in pivot recipe with specific sorting ,any idea how to do it example: col1 col2national failinternationalsuccessnationalsuccessinternationalfail pivot national_success,national…Last answer by
Last answer by debanasser1i want to create column in pivot recipe with specific sorting ,any idea how to do it
example:
a b col1 col2 1
23
national
fail 1 34 international success 2 44 national success 2 44 international fail pivot
national_success,national_fail,international_success,international_fail
so pivot table column col1 ,(col2 sorted desc )
row identifier : a
values: sum of b