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

采纳的回答

Sam Cook
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
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.
ariane
ariane 2018-6-26
Thank you very much for responding to my question. This works perfectly.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by