Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2004
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2004

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

Search the Archive

Re: Selecting by first element of each list

  • To: mathgroup at smc.vnet.net
  • Subject: [mg48163] Re: Selecting by first element of each list
  • From: "Borut Levart" <bole79 at email.si>
  • Date: Fri, 14 May 2004 20:59:34 -0400 (EDT)
  • References: <c81i3m$509$1@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

Hello,


I would do it like this:

1. extract the unique id's
2. select the lists with particular id, one group at a time


In[1]:=
data={{3,5,6,7,8,0},{2,3,4,5,77},{2,4,5,66,77},{3,4,7,8,90,6},{3,45,67,77,
        12}};

In[2]:=
ids=Union[First/@data]

Out[2]=
{2,3}

In[3]:=
Map[Function[id,Select[data,#[[1]]==id&]],ids]

Out[3]=
{{{2,3,4,5,77},{2,4,5,66,77}},{{3,5,6,7,8,0},{3,4,7,8,90,6},{3,45,67,77,12}}
}



Is that it?

Borut > Europe > Slovenia > Ljubljana


<camartin at snet.net> wrote in message news:c81i3m$509$1 at smc.vnet.net...
> Hi,
>
> I'm trying to learn to handle a flat file kind of database using
> Mathematica. An example is the list of lists below:
>
> {{2,3,4,5,77},{2,4,5,66,77},{3,4,7,8,90,6},{3,5,6,7,8,0},{3,45,67,77,12}}
>
> It's actually more complicated than this but good enough for
> illustrative purposes. The first element in each list is actually an
> identifier, like an account number. I want to create a list of lists
> with each account, that is,
>
> {{{2,3,4,5,77},{2,4,5,66,77}},
> {{3,4,7,8,90,6},{3,5,6,7,8,0},{3,45,67,77,12}}}.
>
> When I use Select with an anonymous function such as
>
> Select[list1,#1[[1]] = = #2[[1]]&]
>
> I get an error because it stops (of course) after the first two lists. I
> get the right grouping for the first list but it doesn't finish. I don't
> understand how to use the anonymous function to go through my list (it's
> got several thousand entries) and select and group by the first element
> in each group. I've been through the archive but nothing there quite
helps.
>
> I would appreciate some direction.
>
> Thanks
>
> Cliff
>
>


  • Prev by Date: Re: Selecting by first element of each list
  • Next by Date: RE: Selecting by first element of each list
  • Previous by thread: Re: Selecting by first element of each list
  • Next by thread: RE: Selecting by first element of each list