«

How can I group the following array data
1 9 101 I 1
1 9 101 I 2

1 9 101 I 3

1 9 101 I 3.5

1 9 101 II 41

1 9 101 II 42

1 9 101 II 43

1 9 102 I 1

1 9 102 I 2

Thanks

Why don't you treat each array as a vector and
insert its elements in to a tree? So at the end you get:
1(9)
|
9(9)
--------------
| |
101(7) 102(2)
----------- |
| | |
I(3) II(4) I(2)
and so on. You can also have each node in the tree
have a count associated with it, if that is needed later on.
With one pass over the data, you have everything grouped.

does this help?


"Brad Foster" <> wrote in message
news:bnbmsr$a9v$...
> How can I group the following array data
> 1 9 101 I 1
> 1 9 101 I 2
>
> 1 9 101 I 3
>
> 1 9 101 I 3.5
>
> 1 9 101 II 41
>
> 1 9 101 II 42
>
> 1 9 101 II 43
>
> 1 9 102 I 1
>
> 1 9 102 I 2
>
> Thanks
>
>
>

actually these values are what I got from a tree!

any other way?


"bm" <> wrote in message
news:9odmb.12797$EO3.1824@clgrps13...
> Why don't you treat each array as a vector and
> insert its elements in to a tree? So at the end you get:
> 1(9)
> |
> 9(9)
> --------------
> | |
> 101(7) 102(2)
> ----------- |
> | | |
> I(3) II(4) I(2)
> and so on. You can also have each node in the tree
> have a count associated with it, if that is needed later on.
> With one pass over the data, you have everything grouped.
>
> does this help?
>
>
> "Brad Foster" <> wrote in message
> news:bnbmsr$a9v$...
> > How can I group the following array data
> > 1 9 101 I 1
> > 1 9 101 I 2
> >
> > 1 9 101 I 3
> >
> > 1 9 101 I 3.5
> >
> > 1 9 101 II 41
> >
> > 1 9 101 II 42
> >
> > 1 9 101 II 43
> >
> > 1 9 102 I 1
> >
> > 1 9 102 I 2
> >
> > Thanks
> >
> >
> >
>
>

Then they are already sorted in a tree. What do you mean by sorting then?


"Brad Foster" <> wrote in message
news:bnbo58$1l6$...
> actually these values are what I got from a tree!
>
> any other way?
>
>
> "bm" <> wrote in message
> news:9odmb.12797$EO3.1824@clgrps13...
> > Why don't you treat each array as a vector and
> > insert its elements in to a tree? So at the end you get:
> > 1(9)
> > |
> > 9(9)
> > --------------
> > | |
> > 101(7) 102(2)
> > ----------- |
> > | | |
> > I(3) II(4) I(2)
> > and so on. You can also have each node in the tree
> > have a count associated with it, if that is needed later on.
> > With one pass over the data, you have everything grouped.
> >
> > does this help?
> >
> >
> > "Brad Foster" <> wrote in message
> > news:bnbmsr$a9v$...
> > > How can I group the following array data
> > > 1 9 101 I 1
> > > 1 9 101 I 2
> > >
> > > 1 9 101 I 3
> > >
> > > 1 9 101 I 3.5
> > >
> > > 1 9 101 II 41
> > >
> > > 1 9 101 II 42
> > >
> > > 1 9 101 II 43
> > >
> > > 1 9 102 I 1
> > >
> > > 1 9 102 I 2
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
>
>

On Fri, 24 Oct 2003 13:18:13 -0400, "Brad Foster"
<> wrote or quoted :

>How can I group the following array data

You can use RPG-like control break logic. where you sort the data by
fields, and write little routines to use at the start and end of each
group. I have a skeleton class for managing such code if you are
interested. The key is writing a differAt method that returns an int
that says which field the two records differ at.


--
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.

actually i dont need to sort at all..all I need is a grouping


"Roedy Green" <> wrote in message
news:...
> On Fri, 24 Oct 2003 13:18:13 -0400, "Brad Foster"
> <> wrote or quoted :
>
> >How can I group the following array data
>
> You can use RPG-like control break logic. where you sort the data by
> fields, and write little routines to use at the start and end of each
> group. I have a skeleton class for managing such code if you are
> interested. The key is writing a differAt method that returns an int
> that says which field the two records differ at.
>
>
> --
> Canadian Mind Products, Roedy Green.
> Coaching, problem solving, economical contract programming.
> See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.

What exactly do you mean by grouping them? What kind of data structure
do you need/want as a result?

Brad Foster wrote:

>How can I group the following array data
>1 9 101 I 1
>1 9 101 I 2
>
>1 9 101 I 3
>
>1 9 101 I 3.5
>
>1 9 101 II 41
>
>1 9 101 II 42
>
>1 9 101 II 43
>
>1 9 102 I 1
>
>1 9 102 I 2
>
>Thanks
>
>
>
>
>

--
..tom
remove email address' dashes for replies
opensource middleware at <http://isectd.sourceforge.net>
http://gagne.homedns.org

The result i want is this

Get first column [1]
Process this--

Get second column [101 102]
Process this--

On third column [I,II], [I]
Process this--

ON fourth col [1,2,3,3.4], [41,42,43] [1,2]
Process this--


Arrays are ok to use for each of these steps


"Thomas Gagné" <> wrote in message
news:...
> What exactly do you mean by grouping them? What kind of data structure
> do you need/want as a result?
>
> Brad Foster wrote:
>
> >How can I group the following array data
> >1 9 101 I 1
> >1 9 101 I 2
> >
> >1 9 101 I 3
> >
> >1 9 101 I 3.5
> >
> >1 9 101 II 41
> >
> >1 9 101 II 42
> >
> >1 9 101 II 43
> >
> >1 9 102 I 1
> >
> >1 9 102 I 2
> >
> >Thanks
> >
> >
> >
> >
> >
>
> --
> .tom
> remove email address' dashes for replies
> opensource middleware at <http://isectd.sourceforge.net>
> http://gagne.homedns.org
>
>

seems that you need Set.
add all data from first column to Set and you get just one value - 1 and so
on with second, third column....


"Brad Foster" <> schrieb im Newsbeitrag
news:bnbtat$s6d$...
> The result i want is this
>
> Get first column [1]
> Process this--
>
> Get second column [101 102]
> Process this--
>
> On third column [I,II], [I]
> Process this--
>
> ON fourth col [1,2,3,3.4], [41,42,43] [1,2]
> Process this--
>
>
> Arrays are ok to use for each of these steps
>
>
> "Thomas Gagné" <> wrote in message
> news:...
> > What exactly do you mean by grouping them? What kind of data structure
> > do you need/want as a result?
> >
> > Brad Foster wrote:
> >
> > >How can I group the following array data
> > >1 9 101 I 1
> > >1 9 101 I 2
> > >
> > >1 9 101 I 3
> > >
> > >1 9 101 I 3.5
> > >
> > >1 9 101 II 41
> > >
> > >1 9 101 II 42
> > >
> > >1 9 101 II 43
> > >
> > >1 9 102 I 1
> > >
> > >1 9 102 I 2
> > >
> > >Thanks
> > >
> > >
> > >
> > >
> > >
> >
> > --
> > .tom
> > remove email address' dashes for replies
> > opensource middleware at <http://isectd.sourceforge.net>
> > http://gagne.homedns.org
> >
> >
>
>

You already have the data grouped in your tree.
Simply traverse the tree at different depths and
group the nodes that have the same parents.
For example:

getNodesAtDepth(1) gives the set {1}
getNodesAtDepth(2) gives the set { (101, 102) }
getNodesAtDepth(3) gives the set { (I, II), (I) }
getNodesAtDepth(4) gives the set { (1, 2, 3, 3.5), (41, 42, 43), (1, 2) }

does this help?


"Brad Foster" <> wrote in message
news:bnbtat$s6d$...
> The result i want is this
>
> Get first column [1]
> Process this--
>
> Get second column [101 102]
> Process this--
>
> On third column [I,II], [I]
> Process this--
>
> ON fourth col [1,2,3,3.4], [41,42,43] [1,2]
> Process this--
>
>
> Arrays are ok to use for each of these steps
>
>
> "Thomas Gagné" <> wrote in message
> news:...
> > What exactly do you mean by grouping them? What kind of data structure
> > do you need/want as a result?
> >
> > Brad Foster wrote:
> >
> > >How can I group the following array data
> > >1 9 101 I 1
> > >1 9 101 I 2
> > >
> > >1 9 101 I 3
> > >
> > >1 9 101 I 3.5
> > >
> > >1 9 101 II 41
> > >
> > >1 9 101 II 42
> > >
> > >1 9 101 II 43
> > >
> > >1 9 102 I 1
> > >
> > >1 9 102 I 2
> > >
> > >Thanks
> > >
> > >
> > >
> > >
> > >
> >
> > --
> > .tom
> > remove email address' dashes for replies
> > opensource middleware at <http://isectd.sourceforge.net>
> > http://gagne.homedns.org
> >
> >
>
>