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
If you trusted your data and wanted self naming columns, you could instead use:
data=: <;._2@,&',';._2 htData
({.data)=: |:}.data
But I would not side-track too much into general utility until I had a
need for it.
That said, I think tables in J are best represented as columns -- each
column has a name (it's a variable) and columns from the same table
are the same length (indices on one column work on the other columns
from that table).
Does this get you started?
Or did I overlook an important question?
Thanks,
--
Raul
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
