Convert cell char array With Column in Table form MATLAB

Question

Hammad Younas 2023-2-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1905386-convert-cell-char-array-with-column-in-table-form-matlab

评论： Hammad Younas 2023-2-6

Datasetwebsite.mat

Hello. I have import Data from website. I need to convert the Char array in Table with Values in Each Column

For Example In the following data I have 2x8 cell. The first Cell Predicted Class is the Column name and Cat is the Value.

The second Cell in first will be Column name Maximum, Minimum and Mean Value corresponding to there Values.

The Third Cell in first Row Predicted Class is the Column name and Fighter is the Value. The fourth Cell Fighter Levels, Fighter Values, Maximum, Minimum and Mean Value

The first row is C1 is the first Class and the 2nd row is C2 is the Second Class so it should be in loop to save the data for multiple classes.

Can anybody help me with that.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2023-2-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1905386-convert-cell-char-array-with-column-in-table-form-matlab#answer_1162501

编辑：dpb 2023-2-2

在 MATLAB Online 中打开

This is pretty simple with the newer string facilities -- as an example, for the first variable, use something like

animal=extractAfter(DatasetWebsite(:,1),'Animal: ');

It should be obvious how to proceed with the remainder; the one with the multiple values will need only slightly more complicated logic although here's a place to illustrate another new(ish) feature so...

>> extract(DatasetWebsite(:,2),digitsPattern)
ans =
  2×3 cell array
    {'1000'}    {'1000'}    {'1000'}
    {'1000'}    {'1000'}    {'1000'}
>> 

and then just wrap the latter inside

>> str2double(ans)
ans =
       1000.00       1000.00       1000.00
       1000.00       1000.00       1000.00
>> 

and you've got the numeric array. This could be one line of code, of course...

statistics=str2double(extract(DatasetWebsite(:,2),digitsPattern));

7 个评论
显示 5更早的评论隐藏 5更早的评论

dpb 2023-2-3

Well, show us what you tried...

Hammad Younas 2023-2-6

在 MATLAB Online 中打开

@dpb Here is the following code i have tried

% Split the data by the delimiter ','
splittedData = split(data,',');
% Get the number of rows and columns from the splitted data
[rows,cols] = size(splittedData);
% Initialize a cell array to store the table data
tableData = cell(rows/2, cols/2);
% Loop through the splitted data and store the values in the tableData cell array
for i = 1:2:rows    
    for j = 1:2:cols
        tableData{(i+1)/2, (j+1)/2} = splittedData{i,j};    
    end
end
% Convert the values in the tableData cell array to a table
table = cell2table(tableData);
% Convert the values in the table to numeric if possible
table.Variables = str2double(table{:,:});