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

2 次查看(过去 30 天)
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 CenterFile Exchange 中查找有关 Dates and Time 的更多信息

产品

Community Treasure Hunt

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

Start Hunting!

Translated by