How to reorder monthly row data into one column?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Elizabeth Lees
le 17 Nov 2020
Commenté : Ameer Hamza
le 17 Nov 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 commentaires
Réponse acceptée
Ameer Hamza
le 17 Nov 2020
Modifié(e) : Ameer Hamza
le 17 Nov 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Other Formats 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!