How to create a double array from a cell array

I want to convert this data into the image shown after
paths = ["path1";"path2";"path3"];
cellData = {1,2,3,4;5,6,7,8;9,10,11,12};
How do I do this?

4 comentarios

Using randi() perhaps?
None of the values you list in the first row of that 8144x5 cell appear anywhere in the output of the table at the top, so we have no idea where you are getting the data from.
Asim Shahzad
Asim Shahzad el 7 de Feb. de 2021
@Walter Roberson the first image is just to describe what format I want my data in. I want 'n' rows of [39, 375, 530, 259] type of data.
Do all rows have the same number of columns in your cell array data ?
Asim Shahzad
Asim Shahzad el 8 de Feb. de 2021
@Siddharth Bhutiya yes they do.

Iniciar sesión para comentar.

 Respuesta aceptada

paths = ["path1";"path2";"path3"];
cellData = {1,2,3,4;5,6,7,8;9,10,11,12};
imageFilename = paths;
vehicle = cell2mat(cellData);
table(paths, vehicle)
ans = 3x2 table
paths vehicle _______ ___________________ "path1" 1 2 3 4 "path2" 5 6 7 8 "path3" 9 10 11 12
If you are going to put more than one group into the vehicle area, then instead
paths = ["path1";"path2";"path3"];
cellData = {1,2,3,4;5,6,7,8;9,10,11,12};
imageFilename = paths;
vehicle = num2cell(cell2mat(cellData),2);
table(paths, vehicle)
ans = 3x2 table
paths vehicle _______ ____________ "path1" {1×4 double} "path2" {1×4 double} "path3" {1×4 double}
you will not be able to get the actual numbers to display in that situation

Más respuestas (1)

David Hill
David Hill el 8 de Feb. de 2021
Why not just:
cell2mat(yourCellarray);

8 comentarios

As David mentioned you can use cell2mat to convert your cell array to a double matrix and then use that multi-column double matrix as your table variable, something like this
paths = ["path1";"path2";"path3"];
cellData = {1,2,3;4,5,6;7,8,9};
dblData = cell2mat(cellData);
t = table(paths,dblData)
t =
3×2 table
paths dblData
_______ ___________
"path1" 1 2 3
"path2" 4 5 6
"path3" 7 8 9
Asim Shahzad
Asim Shahzad el 11 de Feb. de 2021
@David Hill @Siddharth Bhutiya this does not show up in the format that I have shown in my question. The first image. Your answer gives me this:
What I want is this (visual representation, not the actual data - the second column):
Walter Roberson
Walter Roberson el 11 de Feb. de 2021
Editada: Walter Roberson el 13 de Feb. de 2021
Your input is an 8144 x 5 cell, with 5th column not shown.
Your required output is a table with file names in the first column. The second column has a mix of 2 x 4 and 1 x 4 numeric arrays.
You have not given us any indication of where the file names are coming from for the first column, and there is nothing in the first four columns of the cells in your input that would give us any grouping information to put multiple entries together for the second column of the table.
Furthermore, not even one of the values in the 8144 x 5 cells that you show, appears in the second column of the table, so we are not able to deduce any pattern.
There is only one possible conclusion:
You. Should. Just. Create. Random. Output.
@Walter Roberson Ok let me simplify it further.
My input data is
paths = ["path1";"path2";"path3"];
cellData = {1,2,3,4;5,6,7,8;9,10,11,12};
My output should look like this
How do I achieve this?
paths = ["path1";"path2";"path3"];
cellData = {1,2,3,4;5,6,7,8;9,10,11,12};
imageFilename = paths;
vehicle = cell2mat(cellData);
table(paths, vehicle)
ans = 3x2 table
paths vehicle _______ ___________________ "path1" 1 2 3 4 "path2" 5 6 7 8 "path3" 9 10 11 12
If you are going to put more than one group into the vehicle area, then instead
paths = ["path1";"path2";"path3"];
cellData = {1,2,3,4;5,6,7,8;9,10,11,12};
imageFilename = paths;
vehicle = num2cell(cell2mat(cellData),2);
table(paths, vehicle)
ans = 3x2 table
paths vehicle _______ ____________ "path1" {1×4 double} "path2" {1×4 double} "path3" {1×4 double}
you will not be able to get the actual numbers to display in that situation
Asim Shahzad
Asim Shahzad el 13 de Feb. de 2021
@Walter Roberson thanks for the help.
'you will not be able to get the actual numbers to display in that situation'
How is it being done in the image I shared then? Just curious.
Walter Roberson
Walter Roberson el 13 de Feb. de 2021
Perhaps Variable Browser shows them. The command window will not.
Asim Shahzad
Asim Shahzad el 13 de Feb. de 2021
Editada: Asim Shahzad el 13 de Feb. de 2021
@Walter Roberson just checked. It does. Could you please post your comment as an answer so I can accept it? I'll edit my question with the updated images.

Iniciar sesión para comentar.

Categorías

Productos

Versión

R2020b

Preguntada:

el 7 de Feb. de 2021

Respondida:

el 13 de Feb. de 2021

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by