Sort table by two columns using column name

27 次查看（过去 30 天）
Shana Hartel
Shana Hartel 2018-12-20
评论： Peter Perkins 2018-12-21
Hello!
I can sort a table with: sortrows(tableName, 'columnName1').
I can also sort the same table by 2 columns using: sortrows(tableName,[columnNumber1 columnNumber2])
How can I sort the table by 2 columns using column name?
The following does not work: sortrows(tableName, ['columnName1' 'columnName2']). I get an error saying "unrecognized variable name 'columnName1ColumnName2'.
Thanks in advance!
  2 个评论
Peter Perkins
Peter Perkins 2018-12-21
The issue here is that ['columnName1' 'columnName2'] concatenates those two char row vectors to make one long one. As Chris says, you need either a cell array of char row vectors
>> {'columnName1' 'columnName2'}
ans =
1×2 cell array
{'columnName1'} {'columnName2'}
or in recent versions of MATLAB, a string array
>> ["columnName1" "columnName2"]
ans =
1×2 string array
"columnName1" "columnName2"

请先登录，再进行评论。

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

采纳的回答

Cris LaPierre
Cris LaPierre 2018-12-20
Use curly braces. From the doc page for sortrows
sortrows(tblA,{'Height','Weight'})
Use square brackets if you want to use indexing to specify the columns
sortrows(tblA,[1 4])

更多回答（1 个）

madhan ravi
madhan ravi 2018-12-20
Another possible solution:
sortrows(yourtable,[yourtable{:,1} yourtable{:,2}])

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by