here the attchment.............forget to attch
I want to retrieve every data from my table (as atachment) in column red and green
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Mimie Basha
il 12 Feb 2015
Commentato: Geoff Hayes
il 15 Feb 2015
I want to retrieve every data from my table (as atachment) in column red and green....and compare to one value (as condition) and counter if value correct for the condition.....do you have any suggesstion code?...tq
Risposta accettata
Geoff Hayes
il 12 Feb 2015
Mimie - see xlsread for how you can read in the data from the spreadsheet, and in particular, the red and green columns. For your case, you may want to do something like
filename = 'microarrayMimie.xls';
firstPair = xlsread(filename,'E:F');
secondPair = xlsread(filename,'H:I')
where you read in two columns at a time, those in E and F, and those in H and I.
Your next step is that you want to compare to one value. Please elaborate - which elements of the columns are you comparing, and to what?
3 Commenti
Geoff Hayes
il 15 Feb 2015
Mimie - see the find for how you can determine which elements of your vector exceed some threshold. For example, if hData is your column H and you wish to know how many elements exceed 100 then
find(hData>100)
will return all row indices of hData whose element is greater than 100. Now use length to determine how many rows of hData exceed this threshold
length(find(hData>100))
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Structures in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!