Using MAX function to determine which year had the highest value
2 views (last 30 days)
Show older comments
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
0 Comments
Answers (2)
Andrei Bobrov
on 27 Nov 2020
T = readtable('2020-11-28.txt');
out = T(max(T.tropical_storms) == T.tropical_storms,:)
0 Comments
Sulaymon Eshkabilov
on 27 Nov 2020
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
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!