MATLAB Answers

from cell array to numeric vector

546 views (last 30 days)
I have a 1x52 length cell array of years stored in MWDIData_years, i need to get these to be a nummeric vector. I am trying something like
x = cell2mat(MWDIData_years(:));
But it gives me a 52x4 matrix of chars where each adress in the matrix is a single number, ie 1994 becomes 1 9 9 4.
How can i get around this problem ?
Thank you


Sign in to comment.

Accepted Answer

Mark Whirdy
Mark Whirdy on 16 Dec 2012
Edited: Mark Whirdy on 16 Dec 2012
MWDIData_pop(1,1:5) = {[3752373],[3876616],[4006236],[4140773],[4279524]}; % square brackets in a cellarray indicates that the elements are numeric so if this is your starting point then no need to convert to a numeric, just convert cell to mat
cell2mat(MWDIData_pop(i,:)); % just a cell2mat
If I'm misunderstanding what you're doing here, then please paste in more of your code which GENERATES these cellarrays as the extra bit of clarity there will help in giving you a better response in how to manipulate/convert them to other datatypes.

  1 Comment

DoVile Last Name:
DoVile Last Name: on 17 Dec 2012
Cell2mat was all that i needed, works now.
Thanks for the help Mark

Sign in to comment.

More Answers (1)

Mark Whirdy
Mark Whirdy on 16 Dec 2012
yearCellArray = {'2008';'2009';'2010'};
yearVector = cellfun(@str2double,yearCellArray);


DoVile Last Name:
DoVile Last Name: on 16 Dec 2012
Thanks Mark works great,
however i have run into a strange problem, while it works for the years i have another cell array it does not seem to work for.
MWDIData_pop(i,1:5) = [3752373] [3876616] [4006236] [4140773] [4279524]
It must be something to do with the brackets, the previous vector was using ' symbols. But when i ask for class on any of the above numbers it still says it is a cell. I feel like i am probably missing something fundamental to Matlab here :)
Also Thanks
Andrei Bobrov
Andrei Bobrov on 16 Dec 2012
y = {'2008';'2009';'2010'};
DoVile Last Name:
DoVile Last Name: on 16 Dec 2012
It doesnt work, it just returns NA values when i do it like that..

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!