How to sort a table based off of values in one row in MATLAB

57 visualizaciones (últimos 30 días)
Allie Geiger
Allie Geiger el 8 de Mzo. de 2021
Comentada: Jan el 9 de Mzo. de 2021
I am working on analyzing a data set for a 2AFC task. I have a table called 'SmallerTable,' that has multiple columns. One of my columns titled 'GroupB', I have various numbers ranging from 1:28 in this column. I would like to put these in order so that row one has the number 1, row two has the number 2 and so on. I would like every respective colum to sort their rows according to how this GroupB column is sorted.
Would anyone be able to help me with this?

Respuestas (2)

the cyclist
the cyclist el 8 de Mzo. de 2021
Editada: the cyclist el 8 de Mzo. de 2021
Take a look at the documentation for the sortrows function, in particular the example on sorting rows of tables by variables. The syntax is basically
tblB = sortrows(tblA,vars)
where vars is a cell array with the variable name(s).
  2 comentarios
Allie Geiger
Allie Geiger el 8 de Mzo. de 2021
Thank you for your feedback I am getting the following error now:
Error using tabular/sortrows (line 88)
An error occurred when sorting the variable 'GroupB', whose type is 'table'.
Thank you for any and all help!
the cyclist
the cyclist el 8 de Mzo. de 2021
Can you upload your data in a MAT file, using the paperclip icon in the toolbar?
If you cannot for some reason, could you upload a sample (perhaps just a few rows and columns) of the data that gives the same error?

Iniciar sesión para comentar.


Jan
Jan el 8 de Mzo. de 2021
Editada: Jan el 8 de Mzo. de 2021
sortedTable = sortrows(SmallerTable, {'GroupB'})
  2 comentarios
Allie Geiger
Allie Geiger el 8 de Mzo. de 2021
Thank you for your feedback I am getting the following error now:
Error using tabular/sortrows (line 88)
An error occurred when sorting the variable 'GroupB', whose type is 'table'.
Thank you for any and all help!
Jan
Jan el 9 de Mzo. de 2021
Then SmallerTable is not a table, because a column of a table cannot be a table also. Please post an example of your data.

Iniciar sesión para comentar.

Categorías

Más información sobre Shifting and Sorting Matrices 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!

Translated by