Unstack table and NaN values

3 次查看（过去 30 天）
Jose Rubio
Jose Rubio 2020-9-29
评论： Star Strider 2020-10-1
I have a table with 5 columns which represent different variables
T = cell2table(MyArray,'VariableNames',{'ID' 'Region' 'Int_Den' 'Area' 'Group'});
Then, I used unstack to kind of reorganize it
S = unstack(T,'Int_Den','ID');
However, this is not exactly what I need. You can see from the screenshot below that I have a 294x52 table, where the majority of values are NaN. Instead of this, I would like to have a table where the first column is the "Region", and then the IDs will be distributed from columns 2 to 50. At the end the table should be 6 rows x 50 columns.
Thanks,
  1 个评论
Cris LaPierre
Cris LaPierre 2020-9-30
I think we need more more information about your table to help. Any chance you can attach a mat file containing T or MyArray?

请先登录，再进行评论。

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

采纳的回答

Mohammad Sami
Mohammad Sami 2020-9-30
The remaining variables are used by unstack as grouping variables. You should exclude them when calling unstack.
T = cell2table(MyArray,'VariableNames',{'ID' 'Region' 'Int_Den' 'Area' 'Group'});
S = unstack(T(:,{'ID' 'Region' 'Int_Den'}),'Int_Den','ID');
  3 个评论
显示 1更早的评论
Star Strider
Star Strider 2020-10-1
Apparently, that got fixed!

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by