MATLAB Answers


computation for each date

Asked by Gokturk
on 15 Dec 2012

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 Comment

on 15 Dec 2012

what have you done so far? I suggest you look into



No products are associated with this question.

1 Answer

Answer by Mark Whirdy
on 16 Dec 2012

doc xlsread
doc movavg
doc accumarray

  1 Comment

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.

Join the 15-year community celebration.

Play games and win prizes!

Learn more
Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

MATLAB Academy

New to MATLAB?

Learn MATLAB today!