Find the maximum value of a column in a table

134 visualizaciones (últimos 30 días)
Robert Demyanovich
Robert Demyanovich el 29 de Oct. de 2021
Editada: Dave B el 29 de Oct. de 2021
I have a spreadsheet that is read into a Matlab table. I need to get the maximum value in column 1. I thought the following would work, but it keeps throwing up an error.
MaxExpTime = max(A(:1));

Respuestas (1)

Dave B
Dave B el 29 de Oct. de 2021
Editada: Dave B el 29 de Oct. de 2021
The problem here is that A(:,1) returns a table not the values in the table. You can retrieve the values with A.(1) or A{:,1} but better practice is to use variable names (e.g. A.Var1) with a table:
A=table(rand(10,1))
A = 10×1 table
Var1 _______ 0.92076 0.69648 0.27894 0.40647 0.90258 0.21383 0.17593 0.8362 0.23215 0.95136
max(A.(1))
ans = 0.9514
max(A{:,1})
ans = 0.9514
max(A.Var1)
ans = 0.9514

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by