change output from row to column and display one cell value instead of multiple

Question

Emu 2022-9-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1796425-change-output-from-row-to-column-and-display-one-cell-value-instead-of-multiple

评论： Emu 2022-9-8

采纳的回答： dpb

在 MATLAB Online 中打开

Hi I have this code:

[locAll,typeAll]=find(mVocs==1)

which is getting index from 1-30 from a matrix (mVocs size x*32) of mostly NaNs and outputting into a 1170*1 matrix x*32 in ascending order. So 1 (for column 1) appears 200 times and then 2, 3, 4 and so on, e.g.

1

The cell values are either 1,2 or 3. What I want is an output x*33 matrix with the cell value displayed under each column. How do I do this?

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

请先登录，再进行评论。

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

Answer 1

dpb 2022-9-6

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1796425-change-output-from-row-to-column-and-display-one-cell-value-instead-of-multiple#answer_1044165

编辑：dpb 2022-9-6

在 MATLAB Online 中打开

[locAll,typeAll]=find(mVocs==1)

will return two vectors of the row,column indices (that you've inexplicably called loc/typeAll, respectively, for some unknownst reason).

Oh! Now it dawns on me what it is you want...

RC=accumarray(locAll,typeAll,[],@(v){v.'});

RC will be a cell array of numel(unique(locAll)) x 1 where each cell will have the numel() column indices satisfying the condition for the given row. That could be from empty to size(mVocs,2)

To put into a regular array you would have to allocate the array and augment each cell array to the full length with NaN or other missing indicator. This is fairly straightforward w/ a looping construct or might even be done in a cellfun call.

ADDENDUM/ERRATUM:

I realized I had forgotten to transpose the column vector from column to row to accumulate cell array content being row vectors instead of column vectors. Fixed up above (the ".'" inside the "{}" is the array transpose operator in MATLAB)

8 个评论
显示 6更早的评论隐藏 6更早的评论

dpb 2022-9-6

编辑：dpb 2022-9-7

Doesn't matter what you call them; find has defined outputs when called with two output arguments, the row and column locations that satisfy the given logical condition in the argument expression.

There is no such thing in MATLAB as an array as the above -- arrays are and must be rectangular; no empty "holes" in them. MATLAB is NOT a spreadsheet.

The only way to have something approximating the above is as shown above, a cell array, or alternatively, a square array where the "don't care" elements are some missing value indicator like NaN -- but they can't be "not there"

Whatever you think locAll is giving you, what it is is the list of rows that contain a 1 in them, regardless of which column -- the corresponding column is the other variable and is the column, nothing more, nothing less. If the values range only between 1 and 3 and the size of the array is large, then it's highly probable all rows will contain at least one "1" and so, indeed, the returned vector will be all rows -- but just because it happens to be all rows doesn't imply that it always will be. Needs must be careful in drawing improper conclusions based on what numeric results may be or you would like them to be -- they are what is defined by the function outputs and only that.

If you want, instead, the value at those locations, then it would be mVocs(locAll,typeAll), but we already know what those values are; they're all identically == 1 because that's the condition you placed on them in calling find. From the data available to us, it's certainly not clear where any 2's or 3's would be coming from -- not from any of this code for certain.

I think you need to go back to the beginning and explain just what it is you're actually trying to do...

Attach a (smallish) sample dataset that's easy enough to look at on the screen without panning (5x7 or somesuch would be plenty big enough to illustrate with) and then show us what you would have the result be (although recognize the limitations of arrays being rectangular)

dpb 2022-9-6

在 MATLAB Online 中打开

Here's an illustration of what you've coded -- it may not be what you're looking for, but it's what you've done so far --

>> M=randi(3,5,7)           % best can tell an array that matches what you described
M =
   2     3     1     2     1     2
   2     1     3     2     2     1
   1     1     1     1     3     1
   3     2     1     3     1     1
   3     3     2     1     1     1
>> [r,c]=find(M==1);        % what you computed whatever you used for variable names
>> [r c]
ans =
   1
   2
   3
   3
   4
   4
   4
   5
   5
   6
   6
   6
   7
   7
   7
   7
>> 

You can see how each "1" in M is at the location specified by the r,c pair; "r" is row, "c" is column. Remember MATLAB stores arrays in column-major order.

Now, to consolidate row positions by column (as near as I could tell as to what were asking for),

>> C=accumarray(r,c,[],@(v){v.'});  % accumulate for each row a cell array of columns
>> C{:}                             % see what each cell contains
ans =
     1     4     6
ans =
     3     7
ans =
     2     3     4     5     7
ans =
     4     6     7
ans =
     5     6     7
>> 

The other non-1-valued array locations are those not in the list above; there's no way directly to use what has been calculated so far to get those so we're still stuck with the Q? of what it is that you're expecting to see here.

dpb 2022-9-8

OK, if you have some other indexing operation needed, come back when can identify just what it is you're trying to accomplish.

Oftentimes we can help more if we are told the final/overall problem trying to be solved instead of just being given a particular stumbling block; the tack being taken may be going down the wrong road and approaching the end result from another direction can be all the difference. The easiest problem to solve is the one avoided in the first place! :)

Emu 2022-9-8

Ok yes I am slowiy learning this :)

请先登录，再进行评论。

change output from row to column and display one cell value instead of multiple

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

采纳的回答

8 个评论
显示 6更早的评论隐藏 6更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

change output from row to column and display one cell value instead of multiple

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

采纳的回答

8 个评论 显示 6更早的评论隐藏 6更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

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

8 个评论
显示 6更早的评论隐藏 6更早的评论