Choosing data based on names

Question

0 个投票

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2019-6-16

You might find this useful to read:

Answer 1

Guillaume 2019-6-16

编辑：Guillaume 2019-6-16

1 个投票

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'})