collapsing redundant entries in MATLAB table

2 views (last 30 days)
I have the following MATLAB table
item_a item_b score
a b 1
a b 1
b c 3
d e 2
d e 1
d e 0
I want average the redundant rows. The result should be as follows:
item_a item_b score
a b (1+1)/2
b c 3
d e (2+1+0)/3
I could not find a way to do it. Could you please help?

Accepted Answer

Daniel M
Daniel M on 2 Nov 2019

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!