Repeating array row n times with change of indexes

3 次查看（过去 30 天）
Joanna Widzinska
Joanna Widzinska 2019-9-12
回答： Joanna Widzinska 2019-9-24
Hello everyone,
I have matrix of 1 minute data of the household load (5760x2, where 1st column reflects minutes and second the load). I need to transform data into seconds, where every row will be repeated 60 times with the change of indexes.
Ex.
1min x1 1 x1
2min x2 -----------------> 2 x1
... .....
5760min x5760 60 x1
61 x2
...
120 x2 etc.
I tried many different options and now I think it's involved in multiplying the matrices, but I can't solve this properly.
Can somebody help me? Thanks!

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

采纳的回答

Shubh Sahu
Shubh Sahu 2019-9-18
Hello Jonna,
Let us suppose, the household data is in ‘a’, to repeat the number of rows repelem function is used:
u(:,2) = repelem(a(:,2),[60]);
u(:,1)=1:(5760*60);
for more information regarding repelem refer the following link:
https://www.mathworks.com/help/matlab/ref/repelem.html?searchHighlight=repeat&s_tid=doc_srchtitle
  3 个评论
显示 1更早的评论
Shubh Sahu
Shubh Sahu 2019-9-19
Have a look on this, may it explains
clc;
clear all;
close all;
a=[1,5;2,7;3,8];% take a 3*2 matrix
u(:,2) = repelem(a(:,2),[60]);
u(:,1)=1:(size(a,1)*60);

请先登录，再进行评论。

更多回答（1 个）

Joanna Widzinska
Joanna Widzinska 2019-9-24
It worked! Thank you very much :)

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by