Cell to double for table2array operation, then compile two matice into a .mat file.

I need to change a datatype from cell to double (or vice-versa) in order to get my bagged tree function to work. This is needed to create/sparse a table2array from the original .csv file.

Answer 1

[Deepak]

Hi @Jered Willoughby,

I understand that you are trying to use a bagged tree function in MATLAB, but facing issues due to mismatched data types—specifically, needing to convert between cell and double to successfully use table2array on your CSV data.

To resolve this issue and ensure compatibility, we can convert the relevant cell columns to double before applying table2array.

Below is a sample MATLAB code to achieve the same:

% Read the CSV file into a table
T = readtable('yourfile.csv');

% Convert specific cell columns to double
if iscell(T.YourColumn)
    T.YourColumn = cellfun(@str2double, T.YourColumn);
end

% Convert table to array
A = table2array(T);

Also, we can convert numeric double data to a cell format using the below code:

T.YourColumn = num2cell(T.YourColumn);

Please find attached the documentation of functions used for reference:

cellfun: www.mathworks.com/help/matlab/ref/cellfun.html

num2cell: www.mathworks.com/help/matlab/ref/num2cell.html

I hope this assists in resolving the issue.