How can I convert this table to a cell array as shown in the screenshot?

2 次查看（过去 30 天）

zhongjie 2019-9-2

评论： zhongjie 2019-9-6

I have a CSV file that looks like this

and I would like to convert it to two cell arrays by id.

One array contains all "t" of the same id (shown above), and the other array contains all "measure" of the same id as shown below

Andrei Bobrov 2019-9-5

编辑：Andrei Bobrov 2019-9-6

tout = varfun(@(x){x(:)'},T,'GroupingVariables','id');
C = tout{:,3:end};
measure = C(:,1);
t = C(:,2);

Andrei Bobrov 2019-9-6

编辑：Andrei Bobrov 2019-9-6

I'm fix (about transpose).

Maybe accept it answer? Or ...

zhongjie 2019-9-6

Sorry I'm new to this community, didn't really notice that "Accept this answer" button. My bad!

Anmol Dhiman 2019-9-5

Use the following commands

T = readtable('filename.csv')
c{1} = T{T.id==1,'measure'}
c{2} = T{T.id==2,'measure'}

zhongjie 2019-9-5

编辑：zhongjie 2019-9-5

Thank you very much for the answer!

MATLAB Language Fundamentals Data Types Numeric Types Logical

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

R2019a

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

Translated by