How to replace table cell values with cell value multiplied by 0.0254?

2 次查看（过去 30 天）

Hao Tang 2018-2-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/384012-how-to-replace-table-cell-values-with-cell-value-multiplied-by-0-0254

评论： Peter Perkins 2018-2-21

I want to look through the rows, find a specific text. If that text exists, then go to column 4 to 6 and replace those values by multiplying that value by 0.0254. How can I do that? I have this code but it doesn't work

num_rows = size(HabEx3P,1);
num_cols = size(HabEx3P,2);
for i = 1:1:num_rows
    if ~exist('GRID','var')
        for j = 4:1:6
            HabEx3P(:,j) = HabEx3P(:,j).*0.0254;
        end
    end
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Hao Tang 2018-2-21

HabEx3P.mat

I also meant to use exist and not ~exist.

I've attached the HabEx3P matlab table

So to clarify, look in first column for the word GRID, then go to the 4th to 6th column and replace that Value with Value*0.0254

For some reason, I always get an error 'Undefined operator '*' for input arguments of type 'table'

Eventually, the table will have lots of unique words like GRID, but if I can get just replacing values with GRID values working then the rest should be straightforward