How do we do operations directly on table elements in matlab?
显示 更早的评论
I am thinking of doing min max normalization of my data where if x is vector the procedure is as follows x = (x- min(x))/(max(x)-min(x)). However I want to do this operation directly on the table elements which have 150 rows and 42 features and I want to normalize each of these columns. Is there any one line procedure to do it without using for loop or something like that ? I know we could use curly and dot bracket indexing but the result is not gonna be a table though.
采纳的回答
Walter Roberson
2020-7-2
normalized_data = normalize(data, 'range'); %works on a table, normalizes to [0 1]
更多回答（1 个）
bharath pro
2020-7-2
If you can use z-score instead of min max, then you can directly do
data=normalize(data);
If you cant do that, then this works in one line.
data = (data - min(data, [], 1)) ./ max(data - min(data, [], 1), [], 1)
4 个评论
bharath pro
2020-7-2
I missed the table part. If your table is homogenous you can convert to array do the computation and convert it back.
data = array2table((table2array(data) - min(table2array(data), [], 1)) ./ max(table2array(data) - min(table2array(data), [], 1), [], 1))
This is a workaround and not a direct answer of normalizing table entries.
D_coder
2020-7-2
Walter Roberson
2020-7-2
data = array2table((table2array(data) - min(table2array(data), [], 1)) ./ max(table2array(data) - min(table2array(data), [], 1), [], 1), 'VariableNames', data.Properties.VariableNames);
However, the solution I posted using normalize() works directly on tables without that bother.
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
