Using MAX function to determine which year had the highest value

8 次查看（过去 30 天）
CassieK
CassieK 2020-11-27
回答： Andrei Bobrov 2020-11-27
I have this data here that I have put into a table:
INPUT
years ace tropical_storms hurricanes major_hurricanes
_____ ___ _______________ __________ ________________
1950 243 13 11 8
1951 137 10 8 5
1952 87 7 6 3
1953 104 14 6 4
1954 113 11 8 2
1955 199 12 9 6
1956 54 8 4 2
1957 84 8 3 2
1958 121 10 7 5
1959 77 11 7 2
1960 88 7 4 2
I need to use tha max function to determine which year has the highest number of tropical storms.
DESIRED OUTPUT
Max =
1953 14
I have tried to use the table2timetable function to no avail... Please help :(
MATLAB Version: 9.8.0.1417392 (R2020a) Update 4

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

回答（2 个）

Andrei Bobrov
Andrei Bobrov 2020-11-27
T = readtable('2020-11-28.txt');
out = T(max(T.tropical_storms) == T.tropical_storms,:)
Sulaymon Eshkabilov
Sulaymon Eshkabilov 2020-11-27
Create just a matrix array of your data, e.g. A = [...; ....];
Atab = array2table(A, 'VariableNames', {'Years', 'Ace', 'Tropical_st', 'Hurricanes', 'Major_Hurricanes'});
[Values, Rows]=max(Atab.Tropical_st);
ANS = Atab(Rows,:) % Get the complete answer
Year_ans = Atab(Rows,1) % Get the YEAR answer
  1 个评论
CassieK
CassieK 2020-11-27
Imported the data file and created a matrix(acedata). Is there something else I'm missing that I'm getting this error?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by