MATLAB Answers

Create a uniform empty cells between 2 data in excel file?

조회 수: 3(최근 30일)
MUKESH KUMAR
MUKESH KUMAR 12 Mar 2019
댓글: Raghunandan V 12 Mar 2019
I had a excel file having data at 30min interval for a day , size (48*1). Now I want to create it at 1min time interval with same data and keeping at same postion and between 2 data , create 30 empty cells.
for example see the excel file.......In desired output I only filled upto 6 data, simillary how can we fill it by matlab?
thanks

  댓글 수: 1

Alex Mcaulley
Alex Mcaulley 12 Mar 2019
what have you tried so far?

댓글을 달려면 로그인하십시오.

답변(1개)

Raghunandan V
Raghunandan V 12 Mar 2019
Please check this out:
[num, as,ads] = xlsread('m.xlsx');
%take the required data
A = num(1:48, 1:2);
%initialize B
B = zeros(30*48,2);
%initialize time stamp of B
B(:,1) = [1:30*48]';
for k=1:48
B(((k-1)*30 +1):k*30,2) = A(k,2);
end
you can write the result B into the excel

  댓글 수: 2

MUKESH KUMAR
MUKESH KUMAR 12 Mar 2019
If i had 30min interval data for full year then how to d this for 1 min time interval ?
Raghunandan V
Raghunandan V 12 Mar 2019
replace 48 by length(data)

댓글을 달려면 로그인하십시오.

Community Treasure Hunt

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

Start Hunting!

Translated by