How do I convert a column to numeric?
58 views (last 30 days)
Show older comments
See the image
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/191048/image.png)
I want to count with the 1st column, but I always get the message "Undefined operator" - "for input arguments or type 'cell'." What can I do about it? I think the column is not numeric, but I am not sure. Who can help me?
Accepted Answer
Stephen23
on 6 Jun 2018
Edited: Stephen23
on 6 Jun 2018
Where C is your cell array:
V = str2double(C(:,1))
This assumes that there is no header, and that each cell of the first column contains one number stored as a char (using a dot, not comma).
9 Comments
Stephen23
on 6 Jun 2018
Edited: Stephen23
on 6 Jun 2018
- {} curly braces access the data inside the cells.
- () parentheses access the cells themselves.
Just think of cell arrays like boxes: do you want to pick up the box (the cell, ()), or whatever that is inside the box (the data, {}). Sometimes you want to pick up the box, and sometimes you want to get out whatever is inside... each of these can be useful.
Therefore to access the contents of one cell you just need to use curly braces:
alldata{1,1} - 10
More Answers (0)
See Also
Categories
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!