How to add names to table variables from a large cell with names?

Question

Robert 2017-9-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/357827-how-to-add-names-to-table-variables-from-a-large-cell-with-names

评论： Robert 2017-9-22

采纳的回答： dpb

在 MATLAB Online 中打开

Hello,

I have a 600x1000 array (double), where Columns have data like this...

65  18.81 29.06 28.48 ...
66  18.73 29.10 28.52 ...
64  18.77 29.02 28.49 ...
 ...
82  17.59 29.27 28.94 ...

And have a 600 x 1 cell with Names like...

 AAA_010
 AAA_002
 AAA_143
 ...
 AAA 123

And I would like to end with a TABLE that has variable names based on the above cell with Names, like this...

 AAA_010 AAA_002 AAA_143 ... AA123
 145.65  145.66  145.64  ... 145.82
 18.81   18.73   18.77   ... 17.59
 29.06   29.10   29.02   ... 29.27
 28.48   28.52   28.49   ... 28.94
 ...     ...     ...     ... ...

Thanks for your suggestions!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2017-9-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/357827-how-to-add-names-to-table-variables-from-a-large-cell-with-names#answer_282631

编辑：dpb 2017-9-22

在 MATLAB Online 中打开

Looks peculiar orientation as doesn't keep the similarly-valued variables together, but per your request--

>> t=array2table(d.','variablenames',n)
t = 
  AAA_010    AAA_002    AAA_143    AAA_123
  _______    _______    _______    _______
  145.65     145.66     145.64     145.82 
   18.81      18.73      18.77      17.59 
   29.06       29.1      29.02      29.27 
   28.48      28.52      28.49      28.94 
>>

Also, those names are going to be very difficult to use in being only distinguished by the trailing digits unless it is intended that names be automatically generated and/or the column positions are known. Of course, with 600 variables, having individual names/variables is going to be an issue in and of itself.

I'd suggest probably keeping the array structure and using the vector operations possible in Matlab will be more fruitful way to process your data but we're not given any indications of what intend to do next.