MATLAB: Readtable, how to convert the colume into a numeric array

readtable

In readtable, how to convert the colume into a numeric array?

thx

Best Answer

If I understand correctly what you want, the table2array function may work for you.

Related Solutions

MATLAB: How to perform a mathematical operations on all elements of a column of numerical data imported from Excel in Matlab

Try this:

D = xlsread('YourFile.xlsx');
D1new = D(:,1)/sqrt(3);

MATLAB: Readtable, problems reading identically structured data files

If you are not specific on to use only table try this

f1 = fopen('File1.txt', 'r');
f2 = fopen('File2.txt', 'r');
% read files according to your text file format
data_1 = textscan(f1, '%d%d%d%f%f%f%f%f%f', 'CollectOutput', 1);
data_file1 = [double(data_1{1}),data_1{2}];
data_2 = textscan(f2, '%d%d%d%f%f%f%f%f%f', 'CollectOutput', 1);
data_file2 =[double(data_2{1}),data_2{2}];
% close identifiers
fclose(f1);
fclose(f2);
% concatanate two files data
data_final = [data_file1;data_file2];
% convert to table
T = array2table(data_final);

Best Answer

Related Solutions

MATLAB: How to perform a mathematical operations on all elements of a column of numerical data imported from Excel in Matlab

MATLAB: Readtable, problems reading identically structured data files

Related Question