How to bring Quartly format time excel data to matlab
4 ビュー (過去 30 日間)
古いコメントを表示
Hi.
I'm about to bring time data from matlab. But the problem is that this data is 'quarterly' form such as
time
1981q1
1981q2
...
2011q1
whenever I bring this data using xlsread(), matlab doesn't recognize these data. How can I bring to matlab?
1 件のコメント
Walter Roberson
2011 年 5 月 13 日
duplicates http://www.mathworks.com/matlabcentral/answers/3646-converting-to-quarterly-time-from-xls
採用された回答
the cyclist
2011 年 3 月 24 日
When you say that MATLAB doesn't recognize these data, what do you mean? Just that it does not recognize them as dates?
You might need to read them in as strings (which I am guessing is what xlsread does), then manually extract the first four characters as the year, and the last one as the quarter. Then you could convert those strings to numeric (using str2num).
0 件のコメント
その他の回答 (1 件)
Oleg Komarov
2011 年 3 月 24 日
This is a duplicate post.
Please refer to the answer I've given you here: http://www.mathworks.com/matlabcentral/answers/3646-converting-to-quarterly-time-from-xls
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!