Readtable function reads the return of CRSP data as cell array
1 回表示 (過去 30 日間)
古いコメントを表示
David Schaefer
2019 年 10 月 11 日
コメント済み: David Schaefer
2019 年 10 月 15 日
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 件のコメント
採用された回答
Joe Vinciguerra
2019 年 10 月 11 日
編集済み: Joe Vinciguerra
2019 年 10 月 11 日
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(:));
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Matrices and Arrays についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!