how to create legend from neighboring column in 3d plot

3 vues (au cours des 30 derniers jours)
Andrew le 28 Avr 2023
Modifié(e) : dpb le 29 Avr 2023
Hi, I have a question, I'm wondering how I'd be able to create a legend based on a neighboring column
right now I have this code
And the pulled table doesn't necessarily extract the element names (i assume because it's not integer?)
but I'm wondering how I can make my scatter legend based on my column 1 in the excel sheet?
  7 commentaires
dpb le 28 Avr 2023
"...but his code does not determine how many cells you selected..."
Au contraire, good buddy! <VBG> I did get that far before the phone's in
although not at that point a separate variable...not sure if going to need that or not, yet, but is good possibility.
Will return to the field of battle; may need to look more at the structure of the spreadsheet; I didn't look at it specifically, to know what details may look like...

Connectez-vous pour commenter.

Réponse acceptée

dpb le 28 Avr 2023
Modifié(e) : dpb le 29 Avr 2023
Why folks continue to beat head against wall with deprecated xlsread is beyond ken...
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
Element AtomicNumber E0 R CED Pvap Tm a b c _______ ____________ ______ ___ __________ __________ ____ ______ ______ ______ {'Al'} 13 -1.66 125 0.00045848 2.1021e-07 660 8.2407 14525 192.25 {'Si'} 14 -1.37 110 0.1877 0.035232 1410 8.7131 20614 267.17 {'Sc'} 21 -2.08 160 318.31 1.0132e+05 2836 7.7265 13961 45.18 {'Ti'} 22 -0.163 140 317.48 1.0079e+05 3287 8.9022 20949 190.76 {'V' } 23 -1.18 135 47.626 2268.2 2672 9.18 22303 133.69 {'Cr'} 24 -0.74 140 8.2415 67.923 1684 8.4871 15308 59.51 {'Mn'} 25 -1.185 140 11.645 135.6 1246 7.5051 9853.7 68.23 {'Fe'} 26 -0.04 140 1.8146 3.2928 1535 8.3793 16214 88.52
There's something really funky about the content of this spreadsheet that dreadfully screws up the MATLAB detection process in trying to find out where the data are and creating an appropriate internal import object.
Without all the help given above, it can't figure out the first row are variable names and that the real data begins in the second row -- it skips down to row 7 -- I've noticed in the past that having some odds 'n ends over to the side out of the way of the main data can confuse things; it seems to have done so royally here.
I'd be tempted to suggest this one be sent to TMW as a sample that their 'bot ought to do a much better job on and as a template to figure out what caused it to lose its way so badly....that's a sidelight; it should NOT be that much grief to read the table -- generally detectimportOptions does do a pretty good job; but "not so much!" on this one. That's frustrating to the newcomer who doesn't yet know about all the innards that one can play with...
Anyways, now on to the problem at hand...
OK, now we're back to where was before got so rudely interrupted before, but with the actual full table and names...
scatter3 handle hSc3 is still just one object; so now we'll fix things up to be able to make a legend object to match. This again is a pretty common "hack" one has to do with handle graphics when the base objects don't match what one really wants to do...
hold on % don't let added stuff wipe out what we've already got drawn
hL=plot(nan(2,NNZ),'o'); % create an array of NNZ columns to force NNZ line handles
set(hL,{'MarkerFaceColor'},num2cell(C,2),{'MarkerEdgeColor'},num2cell(C,2)) % force the same color map
hLg=legend(hL,tT.Element(ix)); % and add the legend on those
  8 commentaires
dpb le 29 Avr 2023
Modifié(e) : dpb le 29 Avr 2023
"...what do I need to do If I want to select at# 21-23,49-52 and 82-83 at the same time?"
The higher level comes in very handy there to reduce clutter...
Nota Bene the "or" operator, not "and". And, of course, you shouldn't write such code burying "magic numbers" inside the code itself, but use a set of low/high range arrays and set those instead. Then you can prompt the user for values desired and not change the code at all. Separate the logic from the data.
The problem with the above solution, however, is that it requires explicit code for the number of disparate selections. That's awfully inconvenient to code around; that solution works well only if the number of groups to be selected from is known a priori and doesn't change.
Alternatively, for disparate sets such as this, you can use some of the other MATLAB set operation functions or ismember
R=[21,30; 49,52; 82,83]; % set ranges desired in array by row, start-stop
rnge=cell2mat(arrayfun(@(i1,i2)i1:i2,R(:,1),R(:,2),'uni',0).'); % convert to a list of wanted values
ix=ismember(tT.AtomicNumber,rnge); % look 'em up in your table.
is one way. See intersect and friends as well...

Connectez-vous pour commenter.

Plus de réponses (0)


En savoir plus sur Data Distribution Plots dans Help Center et File Exchange




Community Treasure Hunt

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

Start Hunting!

Translated by