how to skip and split specific range of rows in to multiple columns ?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Jeevan Kumar Bodaballa
le 17 Mai 2020
Commenté : Jeevan Kumar Bodaballa
le 17 Mai 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 commentaire
Stijn Haenen
le 17 Mai 2020
somthing like this:
new_list=[];
for i=1:9:numel(data)
new_list(1:5,end+1)=data(i:i+4);
end
Réponse acceptée
Walter Roberson
le 17 Mai 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,:) = [];
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!