Prev: Cases vs. StringCases vs. Select and StringMatchQ vs. StringFreeQ
Next: surprising comparison of Mathematica 5.2 and 7.0
From: Garapata on 22 Jul 2010 05:42
Hi everyone,

A simple example of my problem follows.

I have a nested list, myList, with the following dimensions:

Dimensions[#] & /@ myList

{{93, 2}, {93, 2}, {93, 2}, {88, 2}, {92, 2}, {93, 2}, {93, 2}}

The columns of each sublist contain values and SQLDateTime(s)
respectively, i.e:

myList[[1,1]
=E2=80=A8 {1.01055, SQLDateTime[{2010, 7, 9, 10, 30, 0.}]

I've sorted each sublist by SQLDateTime.

The Union of the date columns across all sub lists give me 120
distinct dates.

myUnion = Union @@ (myList[[All, All, 2]]);
Length[myUnion]

120

That's what I have so far.

Now I need to do 2 things:

First, create a 2 dimensional list with dimensions {120, 7} that would
have myUnion as the first column and the seven columns of values from
the sublists in myList aligned with their respective dates in
myUnion. This will leave me with some blanks throughout the matrix
which I need to fill in with the value 1.

Just not sure how to do it.

Please advise.

Many thanks

 | 
Pages: 1
Prev: Cases vs. StringCases vs. Select and StringMatchQ vs. StringFreeQ
Next: surprising comparison of Mathematica 5.2 and 7.0