Using MAX function to determine which year had the highest value
조회 수: 8 (최근 30일)
이전 댓글 표시
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
답변 (2개)
Andrei Bobrov
2020년 11월 27일
T = readtable('2020-11-28.txt');
out = T(max(T.tropical_storms) == T.tropical_storms,:)
댓글 수: 0
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Logical에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!