[Num,Txt,R​aw]=xlsrea​d......

9 次查看（过去 30 天）
Cristina
Cristina 2012-6-15
编辑： Image Analyst 2022-3-20
I used [Num,Txt,Raw]=xlsread to import a matrix containing both numerical and text data and Raw is a 2000*8 cell. When I try to compute eg mean(Raw(.,7)) the following message appears:
??? Undefined function or method 'sum' for input arguments of type 'cell'.
Error in ==> mean at 29 y = sum(x)/size(x,dim);
How can I convert cel into num values?
Thanks
  2 个评论
C.J. Harris
C.J. Harris 2012-6-15
Why don't you use the numeric data to compute the mean etc?
Cristina
Cristina 2012-6-15
Because I have to make computations conditional to a list of variables.... e.g. Raw contains a colums country, rating... and I have to compute let's say the mean only if country=IT and rating=BBB. So I need both numerical and text data...

请先登录，再进行评论。

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

回答（4 个）

Kye Taylor
Kye Taylor 2012-6-15
To convert cell to matrix use the cell2mat functions. For example,
mean(cell2mat(Raw(:,7)))
Andrei Bobrov
Andrei Bobrov 2012-6-15
sum for arguments of type double
eg
mean(Num(:,7));
  1 个评论
Cristina
Cristina 2012-6-15
ok but this is not a conditional mean...I need to compute the mean if eg country='IT'

请先登录，再进行评论。

Peter Perkins
Peter Perkins 2012-6-15
Cristina, if you have access to the Statistics Toolbox, you might find that using a dataset array is helpful the kind of thing you seem to be describing. You can read a spreadsheet into a dataset array, and then, for example, compute the mean of one variable conditional on values of other numeric or non-numeric variables.
This example on the File Exchange
http://www.mathworks.com/matlabcentral/fileexchange/24267-an-introduction-to-dataset-arrays
seems more or less the kind of thing you are describing.
Syed Zubair shah
Syed Zubair shah 2022-3-20
what does it means of Num , txt , Raw ... can we just assign it by T =xlsread(filename) ... if yes then how we call specific column then like F is a column of 1600 rows ?
[Num,Txt,R​aw] = xlsread(filename)
  1 个评论
Image Analyst
Image Analyst 2022-3-20
编辑：Image Analyst 2022-3-20
[Num,Txt,Raw] = xlsread(filename, sheetName, 'F1:F1600');

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by