How can I remove or regroup entities of my dataset?
The Entity columns are those necessary to uniquely identify a row of the dataset and, to that extent, the combinations of Entities cannot be repeated. This implies that trying to remove or change entities are delicate task as they can corrupt the data
Let's say, for example, that you have a Dataset with Date and Country as entities (the most common combo in Alphacast). This means that you will have many rows for the same date for different countries. In this example, you can not drop the country column/entity because dates will then be repeated and entities have to be unique
The way to deal with this is by regrouping entities using pipelines.
Step 1. Create a Pipeline and select the Dataset source.
Step 2. add the step "Regroup Entities"
Step 3. Decide which entities will be dropped by deselecting them.
Step 4. Decide what formula you will use to group the rows with repeated values in the Entity (the Date In the previous example)
For example, you can sum all the values of every country for a given date, calculate the mean or the min or max value. The optimal formula depends on the content and context of the data.
The new dataset will have every entity except those you have just excluded. Also, it will have fewer rows than the original because rows with repeated entities will be grouped together