Absolutely – you basically want: Or as a non-query expression: Basically the contents of the group (when viewed as an IEnumerable<T>) is a sequence of whatever values were in the projection (p.car in this case) present for the given key. For more on how GroupBy works, see my Edulinq post on the topic. (I’ve renamed … Read more
A similar question might have been asked before, but I couldn’t find the exact one fitting to my problem. I want to group by a dataframe based on two columns. For exmaple to make this Into this: Meaning that summation on “quantity” column for same “id” and same “product”.
On groupby object, the agg function can take a list to apply several aggregation methods at once. This should give you the result you need: