how to combine contents from multiple cells into one cell or datevector?

2 次查看（过去 30 天）
Ryan Dillingham
Ryan Dillingham 2013-6-7
I have just downloaded some data as a .csv and the date came in format: 12,10,1,12,30 (yy,mm,dd,hh,mn) for each column in the row and the data followed in the subsequent columns of each row. I am trying to combine the contents of the five columns into one column or add the columns using datevec so that I can get a datenumber. Anyone know how I would approach this?

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-6-7
x={12,10,1,12,30;13,5,24,13,30}
x=cell2mat(x)
x=[x zeros(size(x,1),1)]
y=datenum(x)
  1 个评论
Ryan Dillingham
Ryan Dillingham 2013-6-7
perfect! Thanks Azzi, that worked very well. I was then able to turn the datenumber into a datevec which was nice too.
date={[Column1],[Column2],[Column3],[Column4],[Column5]};
date = cell2mat(date);
date = [date zeros(size(date,1),1)];
y = datenum(x);
y = datevec(y);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Downloads 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by