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

To resolve issues starting MATLAB on Mac OS X 10.10 (Yosemite) visit: http://www.mathworks.com/matlabcentral/answers/159016

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

bym on 15 Dec 2012

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

accumarray()
Gokturk

Products

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

Gokturk on 23 Jan 2013

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.

Mark Whirdy

Contact us