Append columns from a known variable into cell

Question

Andrea Moro 2019-11-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/493452-append-columns-from-a-known-variable-into-cell

编辑： Simon Silge 2019-11-27

采纳的回答： Simon Silge

在 MATLAB Online 中打开

Hi!

I can't seem to find the solution to this problem.

In my program I'm extracting data from multiple e.g. 6 excel files (through readcell), all with the same structure: column 1 with the quantity, column 2 with the value and column 3 with the unit of measurement, obtaining a {28,3} cell.

I then extract in a for loop the second column, and create a matrix of all the numeric values adding column after column for the different examines files.

What i'd like to do now is to create a cell with:

column 1 from the first cell with the quantity names;
column 2:(6+1) with the different values of the quantity across the 6 files
column 8 with the units of measurement;

Here is the script that I tried:

clear all
dataset=uigetfile('*.xlsx','Multiselect','on');
for i=1:length(dataset)
    tri=readcell((dataset{1,i}));
    estrai(:,i)=cell2mat(tri(:,2));
end
output=[tri(:,1),estrai];
xlswrite('Analysis',output)

If I run the script i get the following error:

Dimensions of arrays being concatenated are not consistent. Consider converting input arrays to the same type before concatenating.

I also tried writing output as output={tri(:,1),estrai} but instead of a 28x7 cell it returns a 1x2 cell, in which element {1,1} is a 28x1 cell and {1,2} is a 28x6 double. xlswrite('Analysis',output) in this case returns an empty excel file.

Any help?

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

请先登录，再进行评论。

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

Answer 1

Simon Silge 2019-11-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/493452-append-columns-from-a-known-variable-into-cell#answer_403588

在 MATLAB Online 中打开

Have you tested this? You are trying to join a cell array and a numerical matrix from what it seems.

output = [cell2mat(tri(:,1)),estrai]

4 个评论
显示 2更早的评论隐藏 2更早的评论

Andrea Moro 2019-11-27

Solution verified!

Yes. tri(:,1) contained text.

My script didn't work because I was trying to append a double array to a cell array, executed by Matlab creating a new cell with the two individual elements instead of appending the content of the two elements. Your script instead executes the operation between two cell arrays.

Did I understand correctly?

Simon Silge 2019-11-27

编辑：Simon Silge 2019-11-27

在 MATLAB Online 中打开

Thanks for marking the answer as correct.

Correct, In the code you posted you tried to concatenate/ join a cell array and a numerical matrix, which does not work by using [ ] . Instead you should first make sure both variables have the same format and then use [ ]

When you use { } what you do is create a cell array that incorporates the variables (you pass) into new cells. So creating two cells (one for each of your variables) and putting your variables inside, which is not what you want here.

If you have to work with data that contains both text and numbers you have to stay with an cell array (or a table could also work maybe). Just keep in mind that if you want to do calculations you have to extract the numerical values with cell2mat. And you can put them back in:

E.g.

A = {1, 'A'; 2,'B'}
% extract numerical matrix
col1 = cell2mat(A(:,1))
% do calculation
col1 = col1 * 2 
% put back into cell if needed
A(:,1) = num2cell(col1)