Converting first column unique values to number
显示 更早的评论
I have a table that I need to use for another function.
Currently the table is setup as
Base1,x,y,z
Base1,x,y,z
Building2,x,y,z
Building2,x,y,z
Complex3,x,y,z
Complex3,x,y,z
Complex3,x,y,z
What I would like to do is rename the first column if they have unique names so Base1 would switch to 1, Building2 switches to 2 ect...
Is there an easy way to rename all of the first column based on if the values are unique or not?
采纳的回答
[~,~,u]=unique(yourTable{:,1},'stable');
yourTable{:,1}=num2cell(u)
4 个评论
Bewler
2019-6-28
Stephen23
2019-6-29
Rather than converting the double array to a cell array of scalar numerics and then converting that back to a duoble array, just don't use num2cell in the first place.
@Bewler,
To replace the column with variables of a different type, you need to use dot-indexing,
[~,~,u]=unique(yourTable{:,1},'stable');
yourTable.Var1=u;
where 'Var1' is the variable name for the column in the table.
Bewler
2019-7-1
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Other Formats 的更多信息
产品
Translated by 
