How can I convert this table to a cell array as shown in the screenshot?
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
.
0 Commenti
Risposta accettata
Andrei Bobrov
il 5 Set 2019
Modificato: Andrei Bobrov
il 6 Set 2019
tout = varfun(@(x){x(:)'},T,'GroupingVariables','id');
C = tout{:,3:end};
measure = C(:,1);
t = C(:,2);
4 Commenti
Andrei Bobrov
il 6 Set 2019
Modificato: Andrei Bobrov
il 6 Set 2019
I'm fix (about transpose).
Maybe accept it answer? Or ...
Più risposte (1)
Anmol Dhiman
il 5 Set 2019
Use the following commands
T = readtable('filename.csv')
c{1} = T{T.id==1,'measure'}
c{2} = T{T.id==2,'measure'}
Vedere anche
Categorie
Scopri di più su Logical in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!