Sort and match data in a table

2 次查看（过去 30 天）
Julian
Julian 2019-9-10
评论： Julian 2019-9-10
Hi,
i basically have a table with two collumns.
Col1 Col 2
Label1 9
Label2 8
Label3 6
Label1 5
Label2 5
To analyze this I want to have a table which is basically something like this.
Label 1 9 5
Label 2 8 5
Label 3 6
Then i want to export this to Excel. This is why i thought it would be best to work with tables. Also because in the code before I used a lot of findgroups and splitapply, thats why the format was pretty nice. But right now i'm really stuck. I think there should exist a fairly easy solution, but i don't really see it.

请先登录，再回答此问题。

采纳的回答

Julian
Julian 2019-9-10
You might consider
groupsummary(D, 'Col1', @(x){x})
where D is table containing your data. This does leave a "ragged right" cell array containing differing lengths and you will need to pad it if you want a uniform tabular representation.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by