Readtable function reads the return of CRSP data as cell array
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
David Schaefer
le 11 Oct 2019
Commenté : David Schaefer
le 15 Oct 2019
I want to work with CRSP stock data in matlab but when I use the funtion readtable to import the data, which I have as a CSV file, I have some issues.
If you look at the picture you see that the function reads the returns of the file as a cell array but I want it as a numeric number just as the price or the shares outstanding.
Is there an easy way to convert it?
Thanks!
0 commentaires
Réponse acceptée
Joe Vinciguerra
le 11 Oct 2019
Modifié(e) : Joe Vinciguerra
le 11 Oct 2019
This will convert that column to numbers (assuming all elements in that column can be converted to numbers)
(EDIT: sorry I haven't had my coffee yet. This is correct now...)
variableName.RET = str2double(variableName.RET(:));
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Matrices and Arrays dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!