Or more simply: $,/"3 dates ,"1/ hours 3 16 5
On Tue, Dec 28, 2010 at 11:56 AM, Tikkanz <tikk...@gmail.com> wrote: > Is this what you want? > > dates > 2010 1 1 > 2010 1 2 > 2010 1 3 > 2010 1 4 > > 2009 1 1 > 2009 1 2 > 2009 1 3 > 2009 1 4 > > 2010 1 1 > 2010 1 2 > 2010 1 3 > 2010 1 4 > hours > 0 15 > 0 30 > 0 45 > 0 60 > $,/"3 dates ,"1"1 2 hours > 3 16 5 > > On Tue, Dec 28, 2010 at 11:06 AM, Bill Harris > <bill_har...@facilitatedsystems.com> wrote: >> I've been working in R too long, and my J is rusty. >> >> I'm trying to take what seems like the Cartesian product of two >> arrays. In particular, I've got a list of lists of dates, and I want >> to turn them into ISO timestamps with a consistent HMS appended to them. >> >> The dates list might look like >> >> dates =: 1 4 3 $ 2010 01 01 2010 01 02 2010 01 03 2010 01 04 >> dates =: dates, 4 3 $ 2009 01 01 2009 01 02 2009 01 03 2009 01 04 >> dates =: dates, 4 3 $ 2010 01 01 2010 01 02 2010 01 03 2010 01 04 >> >> That's 3 sets of data, each with 4 dates, and each date with 3 >> components. (In general, each set of data could have a different >> number of dates.) >> >> The complete hours list looks like >> >> hoursmins=: 24 (<95 0) } 24 60 #: 15 * >: i. 96 >> >> but a simple version for this example might only have 4 times: >> >> hours =: 4 2 $ 0 15 0 30 0 45 0 60 >> >> What I want looks roughly like >> >> 2010 01 01 00:15:00.00 >> 2010 01 01 00:30:00.00 >> 2010 01 01 00:45:00.00 >> 2010 01 01 00:60:00.00 >> 2010 01 02 00:00:00.00 >> . >> . >> . >> 2010 01 04 00:60:00.00 >> >> 2009 01 01 00:15:00.00 >> . >> . >> . >> >> The last step needs the isotimestamp verb from dates, so I need to get >> to lines of the form >> >> 2010 01 01 0 15 >> 2010 01 01 0 30 >> >> and so forth. The rank of that result should be 3 16 5: 3 sets of 16 >> date-time stamps, each with 5 components. >> >> I've tried lots of alternatives, including variants on catalog and on >> Henry's JfC ,"_1 _ "_ _1, all to no avail. I suspect it's trivial; can >> someone help? >> >> Thanks, >> >> Bill >> >> PS: I apologize if this comes through twice. I originally sent it from >> the wrong email address, which I suspect will get it blocked. >> >> >> >> ---------------------------------------------------------------------- >> For information about J forums see http://www.jsoftware.com/forums.htm >> > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
