Create a new table with filtered rows

I have a table called january_2022. One of the columns, called sports, is categorical. I want to create a new table called sports_basketball which only shows the rows from january_2022 where the value of the sports column is basketball. Any suggestions, please?

Thanks!

Answer 1

[the cyclist]

Here is one way.

% Pretend data
sports = categorical({'basketball';'volleyball';'basketball'});
num = [2;3;5];

% Put in a table
january_2022 = table(num,sports);

% Pull out the rows you want
sports_basketball = january_2022(ismember(january_2022.sports,'basketball'),:)

sports_basketball = 2×2 table
    num      sports  
    ___    __________

     2     basketball
     5     basketball