how to skip and split specific range of rows in to multiple columns ?

1 次查看(过去 30 天)
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 ?

采纳的回答

Walter Roberson
Walter Roberson 2020-5-17
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,:) = [];

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by