Unstack table and NaN values
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Jose Rubio
el 29 de Sept. de 2020
Comentada: Star Strider
el 1 de Oct. de 2020
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,
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/368662/image.png)
1 comentario
Cris LaPierre
el 30 de Sept. de 2020
I think we need more more information about your table to help. Any chance you can attach a mat file containing T or MyArray?
Respuesta aceptada
Mohammad Sami
el 30 de Sept. de 2020
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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Matrices and Arrays en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!