Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Intersection of sublists on date and making a 2D list from a 3D

  • To: mathgroup at smc.vnet.net
  • Subject: [mg109928] Re: Intersection of sublists on date and making a 2D list from a 3D
  • From: Garapata <warsaw95826 at mypacks.net>
  • Date: Sun, 23 May 2010 03:17:31 -0400 (EDT)
  • References: <ht7nbh$psj$1@smc.vnet.net>

A friend working serendipitously on a very similar problem got a step
of the solution from Wolfram Support (credit where credit's due, they
seem to have made some real improvements over there).

Anyway, since I have unique dates within each of the groups described
in my original post I can use Part to pull out all of the dates,
something like this:

groupDates = list[[All,All, 3]]

Then I can use this elegant solution via Wolfram support:

datesIntersection = Apply[Intersection, groupDates]

Doesn't get me all the way to what I need, but looks like a good
start.

Remember I still need to get to this (from my original post):
...

I'd like to find all the rows that intersect on the same dates and put
the whole thing into a 2 dimensional structure that
would have the following columns:

commonDates, group1Data1, group1Data2, group2Data1, group2Data2,
group3Data1, group3Data2
...

So any help still very much appreciated.

Thx



  • Prev by Date: Re: combining ArrayPlot with ListLinePlot
  • Next by Date: Re: SQLExecute with an argument
  • Previous by thread: Re: Intersection of sublists on date and making a 2D list from a 3D
  • Next by thread: Re: Intersection of sublists on date and making a 2D list from a 3D