How to edit a dataset ?
Hello everyone,
I exported an excel file and I would like to be able to add columns and rowsand calculations from Dataiku DSS as if I was in Excel !
Thanks !
Hugo
Best Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,226 Dataiker
Hi Hugo,
In DSS you can edit datasets by using a "Push to editable" recipe. You can read more about here .
You can find it under Other Recipes, once the new dataset is created you can click on Edit and it will bring up page shows below.
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
Hi @Hugo_Wsld
besides Alex's great solution (thanks for accepting it btw!) I just wanted to provide you with this resource. Just incase you haven't accessed it yet, here is the Excel to Dataiku DSS Quick Start on the Dataiku Academy.This short hands-on tutorial is geared towards business analysts and other Excel users entirely new to Dataiku. It focuses on using the point-and-click interface and performing some of the most common Excel data processing and analysis tasks in a more efficient and scalable way with Dataiku.
The tutorial introduces many of the essential capabilities of Dataiku by walking through a simple use case: connecting to, preparing, and analyzing CRM and web sales data.
I hope this helps!
Answers
-
Thanks for your very quick responses!
I'll see the tutorials and try it all right away
Is it possible to do calculations directly on the data table?
Have a nice day!
Hugo
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,226 Dataiker
Hi, Not currently possible directly in the editable data table, where you can add rows, columns, and edit values there. Calculations needed can be done Prepare recipe.