SHAZAM Community
Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Reorganizing data-matrix

Hi all,

Background: I’m planning to analyze daily data covering all months of the year. The total time horizon is six years. The data-matrix has the following structure (please, see attached pdf-file observation for 1980): 12 columns – one for each month and 31 rows for daily observations – but note that February has 29 observations and April, June, Sept and November, respectively have 30). Problems: (1) Is it possible to reorganize the data in Shazam so the daily data/observations for each of the months are linked together in a single column, i.e. month by month etc.? (2) I’m also interesting in generating monthly average data by using this matrix (monthly scale over six years) and the first best is to store the data in one column.

testdata.csv