manipulate structure field data to create a table

1 次查看（过去 30 天）
ppp
ppp 2019-4-18
评论： ppp 2019-5-7
Hello All,
I am trying to restructure the data from the structure fields to get the desired table. For better understanding i illustrate with a simple example below:
1x4 struct with 3 fields
type list no
type1 a 1
type1 p 0
type2 a 7
type2 c 6
what i need is a sorted summary table like this: (alphabetically sorted & unique of 'list' with unique of 'type' associated with their respective 'no' values.)
a c p
type1 1 - 0
type2 7 6 -
Thank you all in advance.

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

采纳的回答

Peter Perkins
Peter Perkins 2019-5-3
Tailor-made for the too-often-overlooked unstack:
>> type = categorical(["type1";"type1";"type2";"type2"]);
>> list = ["a";"p";"a";"c"];
>> no = [1;0;7;6];
>> t = table(type,list,no)
t =
4×3 table
type list no
_____ ____ __
type1 "a" 1
type1 "p" 0
type2 "a" 7
type2 "c" 6
>> t2 = unstack(t,"no","list")
t2 =
2×4 table
type a c p
_____ _ ___ ___
type1 1 NaN 0
type2 7 6 NaN

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by