How to extract data from a table based on a specific variable

3 visualizzazioni (ultimi 30 giorni)
I have a huge csv file with 7 columns that I import into matlab as a table (see picture below).
Is there a way to split this table into smaller tables that contain all the rows with the same Asset Description? For example, I would like to create a table with all the rows where my Asset is 'Glendevon'. The different variables in the Asset Description Row are 210, which means that "manual" extract is not an option.
Thanks

Risposta accettata

dpb
dpb il 12 Ott 2018
Modificato: dpb il 12 Ott 2018
  1. Convert the categorical variables from character representation to categorical
  2. Use findgroups and splitapply, grpstats, etc., to group by variable(s) value

Più risposte (0)

Categorie

Scopri di più su Tables 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!

Translated by