Prev: Constrain imdistline endpoints to two lines
Next: re-arranging data into a matrix
From: Tiina on 19 Feb 2010 19:42

I need to organise a large file of data that appears like
Date obs
20090102 900
20090102 600
20090102 800
20090102 800
20090102 700

20090103 650
20090103 900
20090103 840

20090104 100
20090104 1000
20090104 600
20090104 450

How can I transform the data to look like the following matrix: ( I got 1000s of dates like that and there are different observations for each day with a max of 100 per day but can be less at times so i got to fill the empty observations with zeros)

2009-01-02 900 600 800 800 700
2009-01-03 650 900 840 0 0
2009-01-04 100 1000 600 450 0
I appreciate any help 

tiina
 | 
Pages: 1
Prev: Constrain imdistline endpoints to two lines
Next: re-arranging data into a matrix