how to select the best 15 scores
2 views (last 30 days)
Show older comments
Hi,
How can I select the * best* 15 scores of a 70 element vector with some NaN values in it (which should not be selected)?
0 Comments
Accepted Answer
Kirby Fears
on 6 Nov 2015
Edited: Kirby Fears
on 6 Nov 2015
When you sort descending, the NaN values are actually sorted on top. You can use indexing to ignore NaN's before sorting. I'm adding a bit of extra code to keep track of the original position of these best 15 scores (you might want it later).
myData = rand(70,1); % pretend data
myData([1,2,4,6]) = NaN; % adding NaNs for testing
idxKeepers = find(~isnan(myData)); % index for non-NaN data
[~,idxSort] = sort(myData(idxKeepers),'descend');
idxBestScores = idxKeepers(idxSort(1:15));
bestScores = myData(idxBestScores);
idxBestScores contains the location of the best 15 scores in your original data. bestScores contains the 15 best scores (sorted descending).
2 Comments
Kirby Fears
on 9 Nov 2015
Edited: Kirby Fears
on 9 Nov 2015
Sam,
The idxSort array contains the ordered positions for scores from best to worst. Instead of taking the first 15 elements of idxSort, you can take the last 15 elements to get the worst 15 scores.
idxWorstScores = idxKeepers(idxSort(end-14:end));
You can loop across similar arrays such as TRIG, PAL, etc, by storing their data into one structure that you can index across. For example, you can store the initial scores into a struct like this:
MyData.TRIG.scores = num(:,strcmp('TRIG',txt(1,:)));
Repeat for PAL and others. Then you can store field names of MyData and loop over them.
fn = fieldnames(MyData);
for iter = 1:numel(fn),
disp(MyData.(fn{iter}).scores);
...
...
data.(fn{iter}).bestScores = ... ;
end
Please give this a try.
More Answers (1)
Walter Roberson
on 6 Nov 2015
Sort descending and take the first 15 entries of the result.
0 Comments
See Also
Categories
Find more on Scatter Plots 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!