cancel
Showing results for 
Search instead for 
Did you mean: 

You can shape your data with Data Prep - try it!

akshay
DataRobot Employee
DataRobot Employee

You can shape your data with Data Prep - try it!

Analysts get a lot of use of group by when aggregating data to derive deeper insights from data. With Data Prep, shaping your data using a group by is very simple.

Consider a dataset, like the one shown below:

akshay_0-1630541863283.png

The goal is to compute the Sum, Minimum, Maximum, and Average Annual Tax revenue per state, per year. 

Use the following steps to compute these four aggregations:

Step 1: Use the Shape tool to invoke the Shaping editor.

akshay_1-1630541863284.png

Step 2: At the top of the Shaping editor, choose Group By.

akshay_2-1630541863257.png

Step 3: 

  1. Add the desired columns you want to group by in the top area (State and year, in this case).
  2. Choose the aggregation(s).
  3. Choose the column.
  4. Name the result column.
  5. Optionally, click + to add another aggregation.

akshay_3-1630541863303.png

Step 4: Save the Data Prep Project

Now that you know how powerful a group by can be, happy data prepping!

- Akshay

Labels (3)
0 Kudos
0 Replies