Converting to quarterly time from xls
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a excel(xls) data in which the first column is time variable (quarterly from 1978q1 to 2011q1).
How can I bring this into matlab and use the same format. (I will plot against other merged data.)
Help me! (I searched 'toquarterly' but its explaination is too short to fully understand. Any good explaination might be helpful!)
0 Kommentare
Akzeptierte Antwort
Oleg Komarov
am 23 Mär. 2011
[data, text] = xlsread(filename,...);
EDIT
To convert cellstrings dates of the format yyyyq# into numeric representation, use:
datenum(text(:,1),'yyyyQQ')
0 Kommentare
Weitere Antworten (0)
Siehe auch
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!