How to find aximum value in a particular day
2 views (last 30 days)
Show older comments
LISSA DUVVU
on 16 Jun 2023
Answered: Image Analyst
on 16 Jun 2023
Want to find a maximum value for a particular day and if that value is more than 0.1 then i have take that value with corresponding other values in the same line
This is how my data looks like
1. time
2. prn
3. day
4. tec
5. rot
now
17.8152780000000 1 1 0.0299329491029012 0.0238570000000000
17.8819440000000 1 1 0.0361110886425115 0.0165560000000000
17.9486110000000 1 1 0.0609912912295436 0.0143080000000000
18.0152780000000 1 1 0.0525351996648996 0.00938500000000000
18.0819440000000 1 1 0.0458706181346478 0.00502800000000000
18.1486110000000 1 1 0.0458695507597667 0.00665000000000000
18.2152780000000 1 1 0.0516134215864671 0.0116360000000000
18.2819440000000 1 1 0.0316242692661046 0.00635400000000000
18.3486110000000 1 1 0.0361103841317258 0.0158660000000000
18.4152780000000 1 1 0.0453422293504342 0.0145850000000000
18.4819440000000 1 1 0.0596673580349598 0.0237340000000000
18.5486110000000 1 1 0.0475831349854618 0.0122550000000000
18.6486110000000 1 1 5.99231716569814 0.482069000000000
18.7486110000000 1 1 15.2063246834517 0.473571000000000
18.8386110000000 1 1 22.1305951631731 0.716901000000000
i want like ths, maximum value of rot in a particular day that is greater than 0.1
18.8386110000000 1 1 22.1305951631731 0.716901000000000
0 Comments
Accepted Answer
Image Analyst
on 16 Jun 2023
dayNumber = data(:, 3);
rot = data(:, 5);
dailyMaxima = groupsummary(rot, dayNumber, 'max');
If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:
0 Comments
More Answers (0)
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!