Choosing data based on names

Asked by Ammar Jakrin on 15 Jun 2019

Latest activity Edited by Guillaume on 16 Jun 2019

2 views (last 30 days)

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 Comment

Stephen Cobeldick on 16 Jun 2019

You might find this useful to read:

https://www.mathworks.com/help/matlab/matlab_prog/split-table-data-variables-and-apply-functions.html

1 Answer

Link

Answer by Guillaume on 16 Jun 2019

Edited by Guillaume on 16 Jun 2019

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

You are now following this question

Ammar Jakrin (view profile)