MATLAB: Delete specific rows in table

table

I want a table that has all values that their cell_type is 4 and get rid of those row that their cell_type is not 4.

Any suggestion?

Best Answer

    T(T.cell_type~=4,:) = [];
    % where T is the name of your table

Related Solutions

MATLAB: Pad a table without variable names

Create a table with just 0s and with VariableNames that match your original table. The number or rows in your zeros-table should be determined by the first value in your Frame column. Then vertically concatenate the tables.

% Create demo table
T = table((7:10)',rand(4,1), rand(4,1),'VariableNames',{'Frame','Value_X','Value_Y'}); 
% Create pad table
Tpad = array2table(zeros(T.Frame(1)-1,size(T,2)),'VariableNames',T.Properties.VariableNames); 
% Concatenate tables
T = [Tpad;T];

MATLAB: Deleting several specific columns from a table

Do you know all the column indices you want to delete? It's as simple as

columnIndicesToDelete = [4 5 6 7 9 12 14 15 17]; % and so on
QuestionnairesData(:,columnIndicesToDelete) = [];

And if there is some pattern to the indices, you won't necessarily have to specify every single value.

Or am I missing something? In your example, the columns deleted in the command

QuestionnairesData(:,5:6) = [];

after having done

QuestionnairesData(:,4:5) = [];

will not be the 5th and 6th column of the original array. So maybe there is some complication there?

Best Answer

Related Solutions

MATLAB: Pad a table without variable names

MATLAB: Deleting several specific columns from a table

Related Question