Search All of the Math Forum:
Views expressed in these public forums are not endorsed by
NCTM or The Math Forum.


Math Forum
»
Discussions
»
Software
»
comp.softsys.matlab
Notice: We are no longer accepting new posts, but the forums will continue to be readable.
Topic:
how to find unique rows and calculate the average.
Replies:
9
Last Post:
Apr 12, 2013 6:31 PM



dpb
Posts:
9,850
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 meyour 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...)




