MATLAB: How to change value in a table

changematrixtablevalue

I have this code

d={'first';'second';'third';'forth'};
L=[2;35;4;65];
T=table(d,L)

after the result came,I would like to change the 35 to zero. How can I change the table value?

Best Answer

Adding to Star's way, here are some other ways:

T{2, 2} = 0  % Set row 2, column 2 to 0.
T.L(2)  = 0  % Set row 2 of column "L" to 0 (L not required to be column #2 in this case)

It depends on what you know about the 35. Star's way will set all values of 35 in column "L" to zero. The ways I gave are if you know that it's row 2 in column 2 (the "L" column), and it's row 2 you want to set, instead of all the rows with a value of 35.

It can be tricky figuring out when to use braces, parentheses, or brackets in MATLAB. Tables are sort of like cell arrays in a way, it's just that every item in a column must be of the same type. So the FAQ http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F may help you to figure out when to use braces, parentheses, or brackets.

Related Solutions

MATLAB: How to get one table instead of multiple tables.

you have two methods, to either add to the table instead of creating a new table or create the table at the end and build a matrix storing all the data.

for i=1:5
  num = randi([1 75], 1, 5);
  ex_num = randi([1 15], 1 , 1);
  x=sort(num);
  iteration(i,1)=i;
  s = horzcat(x, ex_num);
  S(i,:) = horzcat(x, ex_num);
  T(i,:)=table(i,s(1),s(2),s(3),s(4),s(5),s(6),'VariableNames', {'iter' 'first' 'second' 'third' 'fourth' 'fifth' 'extra'}, 'RowNames' ,{'iteration'});
end
table(iteration,S(:,1),S(:,2),S(:,3),S(:,4),S(:,5),S(:,6),'VariableNames', {'iteration' 'first' 'second' 'third' 'fourth' 'fifth' 'extra'})

so in the sample code i added two methods. 1 is to create the table variable T which appends to the existing table instead of generating a new table.

The other is the last line and the S(i,:) which generates the table at the end. you cannot have duplicate row names so i removed your iteration label for each row. additionally you've already labeled it in column 1.

MATLAB: Selecting particular data range from table/ columns

Try this:

T1 = table(rand(100,1), randi(75,100,1));                       % Original Table
L = table2array(varfun(@(x)((x>=15) & (x<=50)), T1(:,2)));      % Logical Vector
T2 = T1(L,:);                                                   % Edited Table

Best Answer

Related Solutions

MATLAB: How to get one table instead of multiple tables.

MATLAB: Selecting particular data range from table/ columns

Related Question