How can I convert this table to a cell array as shown in the screenshot?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Andrei Bobrov
le 5 Sep 2019
Modifié(e) : Andrei Bobrov
le 6 Sep 2019
tout = varfun(@(x){x(:)'},T,'GroupingVariables','id');
C = tout{:,3:end};
measure = C(:,1);
t = C(:,2);
4 commentaires
Andrei Bobrov
le 6 Sep 2019
Modifié(e) : Andrei Bobrov
le 6 Sep 2019
I'm fix (about transpose).
Maybe accept it answer? Or ...
Plus de réponses (1)
Anmol Dhiman
le 5 Sep 2019
Use the following commands
T = readtable('filename.csv')
c{1} = T{T.id==1,'measure'}
c{2} = T{T.id==2,'measure'}
1 commentaire
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!