I have data of that look as that looks like this:
Year Month Day1 Day2 Day3 ...
1999 01 VAL VAL VAL VAL
1999 02 VAL VAL VAL VAL
It's a csv file and VAL is a real number. I'm using a mix of textread and csvread to open them (depending, some of the files have headers that need to be included) and it seems like a lot of matrix rearranging. I think I have an idea of how to use MATLAB to organize them into cell arrays, but actually cell arrays won't help me in the end. What is needed is just a x-by-2 matrix that basically is like
I'm mainly not sure if the first column is possible like that or if it needs to be either a string or a x-by-4 matrix like this
Thanks for any suggestions.