MATLAB: Working with Excel Tables and Importing them.

dataexceltable

After I import the table from Excel, how can I make a new table with only the names of the columns that you input somewhere?

Best Answer

mask = ismember(YourTable.Properties.VariableNames, ListOfColumnsYouWant);
NewTable = YourTable(:,mask);

Related Solutions

MATLAB: Remove rows of a table based on values in an array

disp('Original table');
var1=[1;1;1;1;4;1];
var2=[2;2;2;2;5;2];
var3=[0;3;3;8;8;9];
table_data=table(var1,var2,var3)
n=histc(var3(:),var3);
disp('Updated table');
table_data(find(n==1),:)=[]

Result Window:

Original table
table_data =
  6×3 table
    var1    var2    var3
    __    ____    ____
    1       2       0   
    1       2       3   
    1       2       3   
    1       2       8   
    4       5       8   
    1       2       9   
    
Updated table
table_data =
  4×3 table
    var1    var2    var3
    ____    ____    ____
    1       2       3   
    1       2       3   
    1       2       8   
    4       5       8

MATLAB: How to vertically concatenate two tables with different sizes

outerjoin(A,B,'MergeKeys', true)

It took me a few minutes to find the right command.

Best Answer

Related Solutions

MATLAB: Remove rows of a table based on values in an array

MATLAB: How to vertically concatenate two tables with different sizes

Related Question