Vertical to horizontal data
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Ana
am 26 Apr. 2014
Kommentiert: Ana
am 26 Apr. 2014
Hello,
I have a column of data with several rows (about 125000).
I want to copy that data, every 62 rows, to separate columns. So I would have from row 1 to 62 in column A, from row 63 to 125 in column B, from row 126 to 188 in column C and so on until there is no more data.
Is there an easy way to do this? Thank you so much in advance! (I'm new in matlab)
0 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 26 Apr. 2014
a=rand(12500,1); % Example
n=numel(a);
ii=mod(-n,62),
a(end+1:end+ii)=nan
out=reshape(a,62,[])
Weitere Antworten (2)
the cyclist
am 26 Apr. 2014
You probably want the reshape() function.
doc reshape
for syntax details.
0 Kommentare
Salaheddin Hosseinzadeh
am 26 Apr. 2014
As mentioned, you need to reshape the matrix, but for your data size, which is 125000, since it's not a multiply of 62 you need to pad it with (54) zeros and then reshape it
roughly it's gonna be like
data(1,end:end+54) = 0; % adds 54 zeros to the end of data to be multiply of 62
reshape(data,[],62);
I didn't check the code, might have minor problems ;)
0 Kommentare
Siehe auch
Kategorien
Mehr zu Matrices and Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!