Here's some faux stock market data for July 1-11, 2011: a=. 77247;1;2;3;4;5;6 a=. a,.(77251;1;2;3;4;5;6) a=. a,.(77252;1;2;3;4;5;6) a=. a,.(77253;1;2;3;4;5;6) a=. a,.(77254;1;2;3;4;5;6) a=. a,.(77257;1;2;3;4;5;6) a=. |: a a +-----+-+-+-+-+-+-+ |77247|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77251|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77252|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77253|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77254|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77257|1|2|3|4|5|6| +-----+-+-+-+-+-+-+
The above is how the data appears after reading it in from a CSV file. As you may note, there are missing dates due to market closures for weekends and holidays. I'd like to insert zeroed data so that every daynum is accounted for. Here's what I'd like the result to look like: +-----+-+-+-+-+-+-+ |77247|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77248|0|0|0|0|0|0| +-----+-+-+-+-+-+-+ |77249|0|0|0|0|0|0| +-----+-+-+-+-+-+-+ |77250|0|0|0|0|0|0| +-----+-+-+-+-+-+-+ |77251|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77252|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77253|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77254|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ |77255|0|0|0|0|0|0| +-----+-+-+-+-+-+-+ |77256|0|0|0|0|0|0| +-----+-+-+-+-+-+-+ |77257|1|2|3|4|5|6| +-----+-+-+-+-+-+-+ I'm stumped as to how to fill in the missing values. Any assistance would be greatly appreciated! Harvey ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
