dpb
Posts:
9,824
Registered:
6/7/07
|
|
Re: how to find unique rows and calculate the average.
Posted:
Apr 10, 2013 10:50 PM
|
|
On 4/10/2013 4:10 PM, Alan Hitch wrote:
...
> Thanks for responding. I neglected to tell you that the data is a cell
> array with different data types and textscan only works with double or
> string. I read the data in using xlsread and was using the raw data. I
> am relatively new to MatLab. How do I convert the cell array into a
> double or string? I tried using cell2mat but the contents of my
> cellarray are different data types.
OK, it just dawned on me--your problem is trying to use RAW; use TEXT as
the C{1} cell in my example and NUM as the C{2}. Since XLSREAD returns
the numeric fields as a double array instead of cell, just dispense w/
the curly brackets to dereference the cell contents and just use the
subscripting expressions directly into NUM. (Of course, use whatever
variable names you wish instead of the ML placeholders...)
--
|
|
