finding the value in a table
20 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Lorraine Williams
le 16 Oct 2015
Commenté : Lorraine Williams
le 16 Oct 2015
I have a table and I wish to store the value of the 'rating pts' column in a variable when the column 'yds per att'= 7.21 (there are two values in the table (see example).
What command do I use to get the value in the last column when another column is a value??
Thanks
0 commentaires
Réponse acceptée
Peter Perkins
le 16 Oct 2015
You said "table". Your screenshot looks a whole lot like a spreadsheet. It would help to be more clear.
Assuming you mean that you used readtable to read that spreadsheet into a table, then you probably ended up with variables in the table named YrdsPerAtt and RatingPts, so do this:
T.RatingPts(T.YrdsPerAtt == 7.21)
Plus de réponses (2)
Naga A
le 16 Oct 2015
Suppose if you store that table in the matrix named " table" then you can use this one:
table(find(table(:,column number of "yds per att")=="your required 'yds per att"),column_number of "Rating Pts")
0 commentaires
Walter Roberson
le 16 Oct 2015
There are no entries which will have value exactly 7.21 . Finite binary floating point is not able to represent 0.21 exactly, because 1/10 = 0.1 (and so 0.01 and so 0.21) requires an infinite binary expansion, the same way that in decimal, 1/7 requires an infinite decimal expansion.
You need to test for values that are "close enough" to 7.21 for your purpose. abs(x-7.21) < tolerance for some positive tolerance such as 1E-10
0 commentaires
Voir également
Catégories
En savoir plus sur Tables 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!