How to reorganize the data in table?

3 次查看（过去 30 天）
Zeynab Mousavikhamene
编辑： madhan ravi 2020-8-10
I have a large table like this: (the first row is column name "E" and "M")
I want to know how many "blc" has "m" and how many "blc" has "f" and the same thin for "whi". Any idea how?

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

采纳的回答

Cris LaPierre
Cris LaPierre 2020-8-9
Use groupsummary. Group the data first by E then by M. Groupsummary will tell you the count of each group. Here's an example using the name data for the table.
E=["blc";"whi";"blc";"blc";"whi";"blc";"blc";"blc";"whi";"whi";"whi";"whi"];
M=["m";"f";"f";"f";"f";"m";"f";"f";"m";"m";"m";"f"];
data=table(E,M);
summaryTbl = groupsummary(data,["E","M"])
summaryTbl =
4×3 table
E M GroupCount
_____ ___ __________
"blc" "f" 4
"blc" "m" 2
"whi" "f" 3
"whi" "m" 3
  4 个评论
显示 2更早的评论
Cris LaPierre
Cris LaPierre 2020-8-10
Cell vs string. Might have an older version of MATLAB.
madhan ravi
madhan ravi 2020-8-10
编辑：madhan ravi 2020-8-10
Ah true, but groupsummary() was introduced in 2018a hence the OP has access to string classes which was there even before 2018 (2016b I believe).

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by