Max/Min Values in a table

2018 2 18
2 个回答
更新时间：2025 4 15
27 次查看（30 天）

0 个投票

I'm trying to find the max and min values of a table, and the times that each max and min occurred, what function/syntax would I use to find these values? table =
24×4 table
t wsp1 wsp2 wsp3
__ ____ ____ ____
1 7.8 6.9 6.7
2 7.5 6.8 6.4
3 8.5 8.1 8
4 8.4 6.8 6.5
5 11.1 7.2 6.9
6 14.5 11.7 11.5
7 22.6 16 15.6
8 34.9 22.6 20
9 30 20.5 18.5
10 29.5 18.1 18
11 21.3 15.6 14.5
12 20.5 13.9 13.4
13 18.4 13.8 13
14 15.6 9.3 8.9
15 14 9.2 8.5
16 13.9 9.1 8.8
17 13 8 7.4
18 11.8 7 6.3
19 12.4 7.1 6.8
20 13.4 5.8 5.4
21 5.6 5.7 4.7
22 6.7 4.2 3.6
23 6.4 4.5 3.2
24 5.9 4.4 3.8

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

回答（2 个）

Walter Roberson
Walter Roberson 2018-2-18

0 个投票

[min_vals, min_idx] = min(YourTable{:,2:4});
min_times = YourTable.t(min_idx);
Now min_vals(1) is the minimum wsp1 and that occurred at time min_times(1)
Steven Lord
Steven Lord 2025-4-15
Ran in:

0 个投票

Ran in:
As of release R2023a, you can directly call min on a table or timetable array as long as all the variables are of a data type that supports the calculation.
T = array2table(magic(5))
T = 5x5 table
Var1 Var2 Var3 Var4 Var5 ____ ____ ____ ____ ____ 17 24 1 8 15 23 5 7 14 16 4 6 13 20 22 10 12 19 21 3 11 18 25 2 9
[minValues, minLocations] = min(T)
minValues = 1x5 table
Var1 Var2 Var3 Var4 Var5 ____ ____ ____ ____ ____ 4 5 1 2 3
minLocations = 1x5 table
Var1 Var2 Var3 Var4 Var5 ____ ____ ____ ____ ____ 3 2 1 5 4
resultInVariableVar2 = T{minLocations.Var2, "Var2"}
resultInVariableVar2 = 5
See this documentation page for more information.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by