MATLAB: Percentage increase for table variables

rowfuntable

I have a 6×18 table. All with numeric values. How can I compute the percentage increase for all variables ? I tried using rowfun with diff(x) ./x(1:end-1)*100 but I am getting too many input variables error

Best Answer

If I'm understanding the problem correctly, the result would be an 6x17 matrix "M" where

% P is the 6x18 input table converted to a matrix
M(i,j) = (P(i,j+1)-P(i,j)) / P(i,j) * 100

If the table contains only numeric values which is how it's described in the question, it would be easier to convert it to a matrix.

T = array2table(randi(10,6,18)); % 6x18 numeric table
P = T{:,:};  % Convert to matrix
% Compute percent increase across rows (6x17 result)
M = diff(P,1,2)./P(:,1:end-1)*100

Related Solutions

MATLAB: Problem in reading data from Excel sheet and copying it in 2d array

reverse i & j ?

%copying data from the Numeric array to P     
      for i = 1: 1:1110
              for j = 1: 1 : 61
                  P(i,j) = NUMERIC1 (j,i); % reversed i & j
              end
      end

MATLAB: Please help me implement the equations: Pij = (f(i,j))/(∑_(i=1)^M∑_(j=1)^N〖f(i,j)〗) and H = ─∑_(i=1)^M∑_(j=1)^NPijlog2Pij

It would be something like (provide your own functions for f, and set up the values of M and N),

clc;clear;close; % set up, clean up.. 
% start of Pij part: Pij = (f(i,j))/(∑_(i=1)^M∑_(j=1)^N〖f(i,j)〗) 
M=...; N=...; % give values
function f=functionF(x,y)
% ... how to find f for x (x is imported i) and y (it is j ) 
end % function 
Pij_single=zeros(M,N); P_of_J=zeros(1,M); % initialize P's  
for i=1:M 
     for j=1:N
         Pij_single(i,j)=functionF(i,j);
     end 
   P_of_J(i)=sum(Pij_single(i,:));
end  
Pij_sumOnly=sum(P_of_J); % it must be a single value
for i=1:M
   for j=1:M
     P(i,j)=functionF(i,j)./Pij_sumOnly;
   end 
end
% End of Pij part
% Start of H part: H = ─∑_(i=1)^M∑_(j=1)^NPijlog2Pij 
clear P_single, P_of_J; % in case you need to save memory
H_of_J=zeros(1,M);Hij=zeros(N,M);
% Mark 1   
% Note: if you need  H = ─∑_(i=1)^M∑_(j=1)^NPijlog2Pij  use the code in mark2.
% If you mean H = ─∑_(i=1)^(M-1)∑_(j=1)^(N-1)Pij*log2(Pij) use below: 
H=entropy(Pij);
disp('H is:  '); H
% Mark 2. Delete the lines below if not needed
for i=1:M;
    for j=1:N
      Hij(i,j)=P(i,j).*log2(P(i,j));
    end 
    H_of_J(i)=sum(Hij(:,1));
  end 
  H=-sum(H_of_J);
  disp('H is:  '); H
  % End of the code. Double check initial indices of M, N please.

Best Answer

Related Solutions

MATLAB: Problem in reading data from Excel sheet and copying it in 2d array

MATLAB: Please help me implement the equations: Pij = (f(i,j))/(​∑_(i=1)^M∑​_(j=1)^N〖f​(i,j)〗) and H = ─∑_(i=1)^M​∑_(j=1)^NP​ijlog2Pij

Related Question

MATLAB: Please help me implement the equations: Pij = (f(i,j))/(∑_(i=1)^M∑_(j=1)^N〖f(i,j)〗) and H = ─∑_(i=1)^M∑_(j=1)^NPijlog2Pij