from 8760 x 1 to 1 x 8760 ??

2 views (last 30 days)
federico
federico on 22 Oct 2013
Edited: Image Analyst on 22 Oct 2013
I have wind speed data over the year in an excel's coloumn (8760 X 1) and i need to import it in matlab. The problem is that MATLAB Simulink reads the data across the matrix so i need to transpose the matrix, go from 8760 x 1 to 1 x 8760 and also MATLAB reads the first row of the matrix as the time step so i need to convert the 1 x 8760 to a 2 x 8760 where the first row is the time step eg: 1 2 3 4 5 6 7 8 9 10 …………. I need a help, please, Thank you very much

Answers (2)

sixwwwwww
sixwwwwww on 22 Oct 2013
Edited: sixwwwwww on 22 Oct 2013
Dear you can do like this(if i understood correctly):
num = xlsread('filename.xls', 'A:A');
ind = 1:length(num);
matrix = [ind; num'];
I hope it helps. Good luck!

Image Analyst
Image Analyst on 22 Oct 2013
Edited: Image Analyst on 22 Oct 2013
To transpose use the apostrophe operator.
m = m';
To get the numbers sequentially use the colon operator
m2 = startingValue : stepValue : endingValue;
The step value is 1 if it's not explicitly given. So you want
out = [1:length(m); m'];

Categories

Find more on Get Started with MATLAB 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!