Seperate the data of a table

1 vue (au cours des 30 derniers jours)
lakehead
lakehead le 23 Oct 2018
Modifié(e) : jonas le 23 Oct 2018
Hello,
I have a table and would like to get out the specific lines based on chosen strings of the first and second column. Means when you look at the attached picture, I would like to have e.g. all the lines with 'Fossil Gas' and 'NO_1' and maybe build them up in a new table or better just take out the values of the last column.
Thank you for the answer! :)

Réponse acceptée

jonas
jonas le 23 Oct 2018
Modifié(e) : jonas le 23 Oct 2018
Just use logical indexing
T{strcmp(T{:,1},'Fossil Gas'),end}
The line
strcmp(T{:,1},'Fossil Gas')
returns a logical vector where rows matching the target string are true. This vector is then used to extract values from the last (end) column.
Depending on what you are trying to do, it may be wise to use the first column as a grouping variable, and evaluate the other columns group-wise.
  4 commentaires
lakehead
lakehead le 23 Oct 2018
Thank you perfect and for the tip with the grouping, too!!! I think it might be better.
jonas
jonas le 23 Oct 2018
Modifié(e) : jonas le 23 Oct 2018
My pleasure! Your data set indeed seems ideal for grouping. To get you started, you can look into the following functions
  • findgroups & splitapply
  • varfun
  • grpstats
They are three different functions for evaluating grouped data. If I had to pick one... I would probably go for varfun.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Workspace Variables and MAT-Files dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by