Reshape panel data to wide using text scan

8 次查看（过去 30 天）
Kwasi Boateng
Kwasi Boateng 2020-9-26
评论： Rik 2020-9-26
I have a panel data and want to group each the last five columns according to the dates and ID names in the first column
  2 个评论
Rik
Rik 2020-9-26
How did you try loading this to a Matlab variable?
Kwasi Boateng
Kwasi Boateng 2020-9-26
编辑：Rik 2020-9-26
i used textscan, but is not working for me
Want to bring the #RIC as columns and group the rest of the data according to date under these columns

请先登录，再进行评论。

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

回答（1 个）

Rik
Rik 2020-9-26
If you want to read an Excel file you can use the aptly named xlsread function. The second or third output is probably what you are looking for.
  2 个评论
Kwasi Boateng
Kwasi Boateng 2020-9-26
编辑：Rik 2020-9-26
The second attachement is the format of the data, and I want it in a wider form where I can group all the various RIC according to the date
I want the data in this form
Rik
Rik 2020-9-26
Do you want to process your data inside Excel? Because then you are on the wrong website.
Do you want the result to be written back to Excel? Because you can do that: xlswrite.
What kind of processing do you want? Do you want to sort your data, or do you mean something else by grouping?
(Also, you don't need to post multiple comments, you can simply edit your last comment. As long as there is no newer comment that will not cause any confusion.)

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by