Choosing data based on names

1 次查看（过去 30 天）
Ammar Jakrin
Ammar Jakrin 2019-6-15
编辑： Guillaume 2019-6-16
Example if I have a table called data
Type Test 1
A 23
A 12
A 97
A 72
B 12
B 55
C 22
C 98
C 76
and I want to find the max and min of Type A only. Is there anyway to call Type A without hardcoding data(1,:4)

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

回答（1 个）

Guillaume
Guillaume 2019-6-16
编辑：Guillaume 2019-6-16
Of course, you don't need to hardcode anything.
If you really just want A:
[minval, maxval] = bounds(data.Test1(data.Type == 'A')) %The exact type and name of your table variables is unclear. Adapt as needed
However, you could obtain the max and min of all types at once. This may be more useful:
groupsummary(data, 'Type', {'max', 'min'})

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by