How can I return cell array values using an index matrix.

2 次查看（过去 30 天）
Aaron Jean-Baptiste
评论： Walter Roberson 2017-10-2
Hi there,
I have the following variables:
variableNames = {'Aaron', 'Brett', 'Charlie', 'Katie', 'Jess'}
index_matrix = [1,3,4,5,2; 2,1,4,5,3; 3,2,1,5,4]
and I want to return the variableName corresponding to that index in a new cell array or timetable:
index_name = {'Aaron','Charlie','Katie','Jess','Brett';
'Brett','Aaron','Katie','Jess','Charlie';
'Charlie','Brett','Aaron','Jess','Katie'}
My index_matrix is actually in a timetable, but I suppose once I have a solution for this I can adjust it.
Many thanks,
Aaron

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

采纳的回答

Walter Roberson
Walter Roberson 2017-10-1
index_name = variableNames(index_matrix);
  3 个评论
显示 1更早的评论
Aaron Jean-Baptiste
Aaron Jean-Baptiste 2017-10-2
That was embarrassingly easy. I suppose a follow-up is that I want to store this cell array as a time-series. I.e. I want to see on what date did 'Aaron' come first. How can I store the data in this ordered format?
Walter Roberson
Walter Roberson 2017-10-2
timeseries() does not appear to be usable for cell array of strings.
You could convert to categorical... which would effectively look like your index matrix internally.
You could create a timetable() if you have a sufficiently new MATLAB.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by