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

3 views (last 30 days)
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

Accepted Answer

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

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!