Imagine a nested array like this:
ID IND1 V1 IND2 V2 IND3 V3 DATE
1 A 100 - - - - 2001-12-01
2 A 80 - - C 20 2001-12-01
3 B 70 C 5 D 10 2001-12-01
where - indicates a missing or unassigned value.
1. Quickest APL way to reformat it as follows?
(replacing missing values by zero)
ID IND V DATE
1 A 100 2001-12-01
1 B 0 2001-12-01
1 C 0 2001-12-01
1 D 0 2001-12-01
2 A 80 2001-12-01
2 B 0 2001-12-01
2 C 20 2001-12-01
2 D 0 2001-12-01
3 A 0 2001-12-01
3 B 70 2001-12-01
3 C 5 2001-12-01
3 D 10 2001-12-01
2. Quickest APL way to reformat it as follows?
(lose rows with missing values)
ID IND V DATE
1 A 100 2001-12-01
2 A 80 2001-12-01
2 C 20 2001-12-01
3 B 70 2001-12-01
3 C 5 2001-12-01
3 D 10 2001-12-01
