Create a new table with filtered rows

2022 10 16
1 个回答
更新时间：2022 10 16
3 次查看（30 天）

0 个投票

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!

请先登录，再回答此问题。

回答（1 个）

the cyclist
the cyclist 2022-10-16
Ran in:

0 个投票

Ran in:
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

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

标签

提问:

Kayleigh
Kayleigh
2022-10-16

回答：

the cyclist
the cyclist
2022-10-16

Community Treasure Hunt

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

Start Hunting!

Translated by