How to reorder monthly row data into one column?
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Ameer Hamza
2020-11-17
编辑:Ameer Hamza
2020-11-17
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)
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Other Formats 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!