Replacing values in a table

9 次查看（过去 30 天）
Rylan Thronburg
Rylan Thronburg 2019-4-7
编辑： per isakson 2019-4-8
Hi, I need to replace all numerical values in this table with a ranking of 5 through 1, but I can't use the city names associated with the numbers because my code has to be able to work for different data sets.
Location EndAvg
___________________ _________
'Oklahoma City, OK' [ 7.5000]
'Buffalo, NY' [ 7.8000]
'Wichita, KS' [ 8.6000]
'Rochester, MN' [ 8.8000]
'Abilene, TX' [10.9000]
This is my table, and I need to replace 7.5 with 1, 7.8 with 2, 8.6 with 3, and so on. But say there were 7 cities, I would need it to be ranked from 1-7. How do I get this done?

请先登录，再回答此问题。

回答（1 个）

Walter Roberson
Walter Roberson 2019-4-7
[sorted_vals, sortidx] = sort(YourTable.EndAvg);
YourTable.Rank = sortidx;
  2 个评论
Rylan Thronburg
Rylan Thronburg 2019-4-8
This doesn’t seem to work, unless I’m just using it wrong.
Walter Roberson
Walter Roberson 2019-4-8
The above would create a new variable named Rank in the table. You could replace EndAvg by assigning to YourTable.EndAvg instead of to YourTable.Rank

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

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

Start Hunting!

Translated by