MathGroup Archive 2005

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

Search the Archive

Re: CategoryCounts

  • To: mathgroup at smc.vnet.net
  • Subject: [mg61442] Re: [mg61403] CategoryCounts
  • From: "Carl K. Woll" <carl at woll2woll.com>
  • Date: Wed, 19 Oct 2005 02:16:35 -0400 (EDT)
  • References: <200510180644.CAA11223@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

Gregory Lypny wrote:
> Hello Everyone,
>
>     I'm having trouble with the bivariate form of CategoryCounts.
>
> I have an 1000 x 11 array named h1 whose 9th and 11th columns contain
> the month and year, such as
>
> h1[[All, {9,11}]={{October, 1999}, {October, 1999}, {October, 1999},
> {August, 1999}, {August, 1999},...}
>
> Picking off months is no problem because
> CategoryCounts[h1[[All, 9]], {"October", "July", "August"}]
> correctly gives me {38, 752, 210}.
>
> And picking off years is also no problem because
> CategoryCounts[h1[[All, 11]], {1999, 2000, 2001, 2002, 2003}]
> correctly gives me {1000, 0, 0, 0, 0} (the first 1,000 observations
> all occurred in 1999).
>
> But picking off months and years does not give me the 3 x 5 array
> that I expect:
> CategoryCounts[h1[[All, {9,11}]], {{"October", "July", "August"},
> {1999, 2000, 2001, 2002, 2003}}]
> yields {0, 0}.
>
>     What am I doing wrong?  Any advice would be most appreciated.
>
>         Greg
>

Your syntax is a bit off. In your example you should use:

CategoryCounts[
   h1[[All, {9,11}]],
   {{"October"},{"July"},{"August"}},
   {{1999},{2000},{2001},{2002},{2003}}
]

Specifically, you should have 3 arguments to CategoryCounts, not 2 as in 
your example.

Carl Woll
Wolfram Research 




  • References:
  • Prev by Date: Exporting XML as DocBook, etc
  • Next by Date: Memory use by NMaximize (and NMinimize)
  • Previous by thread: CategoryCounts
  • Next by thread: NestList