Effacer les filtres
Effacer les filtres

How to bring Quartly format time excel data to matlab

4 vues (au cours des 30 derniers jours)
Joon Jeon
Joon Jeon le 24 Mar 2011
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 commentaire
Walter Roberson
Walter Roberson le 13 Mai 2011
duplicates http://www.mathworks.com/matlabcentral/answers/3646-converting-to-quarterly-time-from-xls

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponse acceptée

the cyclist
the cyclist le 24 Mar 2011
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).

Plus de réponses (1)

Oleg Komarov
Oleg Komarov le 24 Mar 2011
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

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by