MATLAB Answers

0

Choosing data based on names

Asked by Ammar Jakrin on 15 Jun 2019
Latest activity Edited by Guillaume
on 16 Jun 2019
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)

Tags

1 Answer

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

  0 Comments

Sign in to comment.