Manipulating data extracted from WRDS

1 次查看（过去 30 天）
Omar Abdel Hamid
Omar Abdel Hamid 2019-8-6
编辑： Dinesh Yadav 2019-8-9
Hello,
I am trying to manipulate data i extracted from WRDS! I have the monthly stock returns for 80 stocks and they are sorted by stock rather than date (the monthly returns for stock 1 for all the dates then the monthly stock returns for stock 2 etc.). how can i manipulate the csv file so that i have the returns for every month together?
thanks

请先登录，再回答此问题。

回答（1 个）

Dinesh Yadav
Dinesh Yadav 2019-8-9
编辑：Dinesh Yadav 2019-8-9
I am providing link to the documentation of sort function in MATLAB below in which steps are shown how you can sort data by a specific rows, columns and date-time also. You can use the combination of sorting by date-time and sorting by columns to get your solution.
https://www.mathworks.com/help/matlab/ref/sort.html
https://www.mathworks.com/help/stats/sort-dataset-rows.html

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by