How to make a P color plot with two variables
2 次查看(过去 30 天)
显示 更早的评论
Hi I wish to make a P colour plot with the following data (see attached csv). However, I only have 2 variables (Elv and KE) and I want to add a 3rd variable (Count rate) as from the data we notice various instances of the same values occurring more than once. Any help would be much appreciated. The sample data looks like this:
Elv KE
88 8600
88 8600
88 8600
88 8600
88 8600
88 8600
88 8600
88 8600
88 8600
88 8600
0 个评论
采纳的回答
Sam Cook
2018-6-13
You could use unique to get each unique combination of your row data, and then iteratively count the number of occurrences.
data = [[88; 88; 88; 23; 23], [8600; 8600; 9000; 9000; 9000]];
opts = unique(data, 'rows'); % Unique combinations of columns
nopts = size(opts, 1);
counts = zeros(nopts, 1);
for i=1:nopts % Counts the number of exact matches
counts(i) = nnz(all(data == opts(i,:), 2));
end
dataout = [opts counts];
This takes the example data...
88 8600
88 8600
88 9000
23 9000
23 9000
...and produces this:
23 9000 2
88 8600 2
88 9000 1
which I believe is the information that you're looking for.
3 个评论
Sam Cook
2018-6-25
Apologies for the late response. First you need to get the subset of data (EG the 'Elv' and 'KE' columns), and then perform the same algorithm as above.
dataSubset = data{:, {'Elv','KE'}};
opts = unique(dataSubset, 'rows');
nopts = size(opts, 1);
counts = zeros(nopts, 1);
for i = 1:nopts
counts(i) = nnz(all(subsetData == opts(i,:), 2));
end
dataout = [opts counts];
Hope this helps.
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!