Converting to quarterly time from xls

2 ビュー (過去 30 日間)
Joon Jeon
Joon Jeon 2011 年 3 月 21 日
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!)

サインインしてこの質問に回答する。

採用された回答

Oleg Komarov
Oleg Komarov 2011 年 3 月 23 日
You can import xls data with xlsread:
[data, text] = xlsread(filename,...);
EDIT
To convert cellstrings dates of the format yyyyq# into numeric representation, use:
datenum(text(:,1),'yyyyQQ')

その他の回答 (0 件)

カテゴリ

Help Center および File Exchange で MATLAB についてさらに検索

タグ

製品

Community Treasure Hunt

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

Start Hunting!

Translated by