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 中查找有关 Data Import and Analysis 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by