trine | A utility library for modern JavaScript | Functional Programming library

I have a dataset with the name of Danish ministers and their position from 1990 to 2020 (data comes from dataset called WhoGovern; https://politicscentre.nuffield.ox.ac.uk/whogov-dataset/). The dataset consists of the ministers name, the ministers position, the prestige of that position, and the year in which the minister had that given position.

My problem is that some ministers are counted twice in the same year (i.e., the rows aren't unique in terms of name and year). See the example in the picture below, where "Bertel Haarder" was both Minister of Health and Minister of Interior Affairs in 2010 and 2021.

I want to create a dataset, where all the rows are unique combinations of name and year. However, I do not want to remove any information from the dataset. Instead, I want to use the information in the prestige column to combine the duplicated rows into one. The observations with the highest prestige should be the main observations, where the other information should be added in a new column, e.g., position2 and prestige2. In the example with Bertel Haarder the data should look like this:

(PS: Sorry for bad presenting of the tables, but didn't know how to create a nice looking table...)

Here's the dataset for creating a reproducible example with observations from 2010-2020: