MATLAB: Pulling columns from a table to create new table

tabletable2array

Hello. I have a data table with 8 columns. I am trying to create a new table, with four of these columns, with one being time. I have

tbl=table2array(NumericValueTable(:,[1 2 4 7]))

and generate a date/time error because column 7 is a date and time. I tried to put

tbl=table2array(NumericValueTable(:,[1 2 4 datetime(7)]))

but this did not work, nor did 'datevec'. Is this possible to do?

Best Answer

If you want to make a new table, just use subscripting, no reason to use table2array.

NumericValueTable(:,[1 2 4 7])

will return a table with only those four variables.

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: Minus table with another table

You have to specify the columns of each table.

% Create two tables, each with 1 column and 5 rows
T1 = table(randi(10,5,1),'VariableName',{'RandData'});
T2 = table(randi(10,5,1),'VariableName',{'RandData'});
% Subtract the two table-columns
y = T1.RandData - T2.RandData

Best Answer

Related Solutions

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

MATLAB: Minus table with another table

Related Question