How to reorder monthly row data into one column?

4 visualizzazioni (ultimi 30 giorni)
Elizabeth Lees
Elizabeth Lees il 17 Nov 2020
Commentato: Ameer Hamza il 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.

Accedi per rispondere a questa domanda.

Risposta accettata

Ameer Hamza
Ameer Hamza il 17 Nov 2020
Modificato: Ameer Hamza il 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)

Più risposte (0)

Categorie

Scopri di più su Loops and Conditional Statements in Help Center e File Exchange

Tag

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by