How to reorganize the data in table?

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?

Answer 1

[Cris LaPierre]

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    

[Zeynab Mousavikhamene]

worked with slightly modification:

groupsummary(data,{'E','M'})

Thanks!

[madhan ravi]

? Isn’t that what Cris gave y0u.

[Cris LaPierre]

Cell vs string. Might have an older version of MATLAB.

[madhan ravi]

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).