How to reorder monthly row data into one column?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Elizabeth Lees
el 17 de Nov. de 2020
Comentada: Ameer Hamza
el 17 de Nov. de 2020
I have a dataset in csv format which is formatted in yearly rows containing a value for each month (13 values total per row, first one being the year then followed by each month). I'd like to transpose this data into one long column of only the monthly values. I believe a loop might work but unsure how to apply it. Any help would be greatly apprciated.
0 comentarios
Respuesta aceptada
Ameer Hamza
el 17 de Nov. de 2020
Editada: Ameer Hamza
el 17 de Nov. de 2020
Following assume variable M is n*13 matrix from csv file
M = readmatrix('filename.csv');
M_data = M(:,2:end); % exclude the years column
M_linear = reshape(M_data.', [], 1)
2 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Loops and Conditional Statements en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!