I have a table like this INPUT I want to be able to pivot this table in the following manner OUTPUT All the articles that I can find online pivot tables based on a second column. My ultimate goal is to get one records per ID. FINAL OUTPUT Here the values of the size, python, cpp, non-code columns are aggregated.
Tag: aggregate-filter
Aggregate columns with additional (distinct) filters
This code works as expected, but I it’s long and creepy. As you can see, it consists of 3 repetitive parts for retrieving: player name and the amount of games they played player name and the amount of games they won player name and the amount of games they lost And each of those also consists of 2 parts: player