On Tue, Jun 21, 2011 at 11:39 AM, Raul Miller <[email protected]> wrote: > For starters, I would parse your data like this: > > 'area source year qtr hpi'=:|:}.<;._2@,&',';._2 htData > 'year qtr hpi'=:".L:0 year;qtr;hpi
P.S. some calculations: ~.year 2009 2010 year (+/ %#)/. hpi 148.175 150.566 That was hpi averaged by year CA NY US area (+/ %#)/. hpi 136.783 177.301 134.028 That was hpi averaged by area ~.area,.":,.year CA2009 CA2010 NY2009 NY2010 US2009 US2010 (area,.":,.year) (+/ %#)/. hpi 132.848 140.718 177.71 176.892 133.968 134.087 That was hpi averaged by area and year. -- Raul ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
