how to skip and split specific range of rows in to multiple columns ?
1 view (last 30 days)
Show older comments
Jeevan Kumar Bodaballa
on 17 May 2020
Commented: Jeevan Kumar Bodaballa
on 17 May 2020
I have long data like thais in one colmun
0.00248
0.00310
0.00377
0.00459
0.00558
120
0
0
NaN
0.002480
0.003100
0.003770
0.004590
0.005580
I want to read first 5 rows in first colmun and skip the next 4 rows and read next five rows as second colmun.
like that I want to do for entire my long colmun data.
How can I do that ?
1 Comment
Stijn Haenen
on 17 May 2020
somthing like this:
new_list=[];
for i=1:9:numel(data)
new_list(1:5,end+1)=data(i:i+4);
end
Accepted Answer
Walter Roberson
on 17 May 2020
D = load('YourFile.txt');
N = length(D);
R = mod(N,9);
if R ~= 0
D(end+1:end+9-R) = nan;
end
Dcols = reshape(D, 9, []);
Dcols(6:end,:) = [];
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!