computation for each date

1 次查看（过去 30 天）
Gokturk
Gokturk 2012-12-15
Sorry for this presumably simple question, but i am new in coding. I want matlab to make a computation for specific dates but it does not read dates from the excel file. To give a simple example, lets say we have different observations for each date (number of observations is changing date to date) and on excel: first column for dates and second is for observations. I want matlab to read first column, and get the observations for each date separately and lets say take average of the observations, that is showing daily average, sum all observations for each date and divide number of obs (length of obs vector) Thanks a lot for your help
[EDITED, Jan, copied from Answer section, but this is an important part of the question]
Hi, thanks for the replies, but I gave taking averages as an example, my problem in here is, how to get data from xls depending on specific dates I do have a sheet like;
date1 12314 03123
date1 11321 84646
date2 46469 4580
.. 46461 4667
daten 78974 8795
(first column is for date second and third..for data)
and I want to get data assigned to each date (colums right next to dates) separately so that I can make some computations on them. I searched and found that I can get data by datenum, and transfer it to matlab date, thats fine. But I could not figure out how I can split data according to the dates :(

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

回答（1 个）

Mark Whirdy
Mark Whirdy 2012-12-16
doc xlsread
doc movavg
doc accumarray
  1 个评论
Gokturk
Gokturk 2013-1-23
the main question was how to deal with importing such a data on dates and make some computations on the data assigned to specific dates. lets say for some certain dates take the vector corresponding to that date and do whatever..i managed to handle the problem by getting the data as excel date numbers transferred into matlab date numbers, did the rest according to the number array rather than string cells.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by