How to find a corresponds value?

1 view (last 30 days)
Wiktoria Schabek
Wiktoria Schabek on 18 Nov 2021
Answered: dpb on 18 Nov 2021
I have a big .csv file (like 30 000 data) which one I import to matlab (to import i used "readtable"). In one colum are current, in second voltage and in third radiation value. In matlab script im making a power value, then im looking for the max Power value, after that i need to find a radiation value which corresponds in the file to the value of the maximum power and thats where the problem begin. I am making m= max(power_value) and i dont know how to find value of radiation which corresponds to that m. How can i find it?

Accepted Answer

David Hill
David Hill on 18 Nov 2021
[maxPower,idx]=max(yourMatrix(:,1).*yourMatrix(:,2));
radAtMaxPower=yourMatrix(idx,3);

More Answers (1)

dpb
dpb on 18 Nov 2021
Use the optional second return value of max
[mx,imx]=max(t.Power);
rmx=t.Radiation(imx);
NB: the use of the table, t variable and dot reference directly instead of making duplicate copies of the data in the table as standalone arrays.
See the doc for max for all the details.
MORAL: Always read the documentation FIRST!; MATLAB may already have the solution at hand.

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!