清空筛选条件
清空筛选条件

Shift n rows in column to next column by a grouping variable

3 次查看（过去 30 天）
NS
NS 2021-6-1
评论： NS 2021-6-2
I wish to shift every 5 rows to the next column as shown below. I have two columns C1 and C2. I want to shift every 5 rows representing a group variable A2 to third columns and 5 rows of group variable A3 to fourth column. Please suggest how to shift n rows in one columns to next column by a increasing number.
My data looks like this-
C1 C2
A1 23
A1 55
A1 45
A1 55
A1 77
A2 56
A2 43
A2 12
A2 33
A2 55
A3 11
A3 22
A3 33
A3 44
A3 55
My desired output is -
C1 C2 C3 C4
A1 23 NA NA
A1 55 NA NA
A1 45 NA NA
A1 55 NA NA
A1 77 NA NA
A2 NA 56 NA
A2 NA 43 NA
A2 NA 12 NA
A2 NA 33 NA
A2 NA 55 NA
A3 NA NA 11
A3 NA NA 22
A3 NA NA 33
A3 NA NA 44
A3 NA NA 55

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

采纳的回答

Jonas
Jonas 2021-6-1
编辑：Jonas 2021-6-1
quick and dirty example:
a=(1:24)';
grpSize=4;
mat=nan(numel(a),numel(a)/grpSize);
mat(:,1)=a;
for grpNr=1:numel(a)/grpSize
mat((1:grpSize)+grpSize*(grpNr-1),:)=circshift(mat((1:grpSize)+grpSize*(grpNr-1),:),grpNr-1,2);
end

更多回答（0 个）

类别

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

标签

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by