Message Boards Message Boards

GROUPS:
Mathematica Wolfram Language
Samuel Chen

question regarding totals

Samuel Chen
Posted 11 years ago
2849 Views
|
4 Replies
|
8 Total Likes
|
Hi there,
I'd like to find out the total amount when the dates are the same. What is the best method when the data set has 3000 - 4000 rows?
{{{1, 1, 2000}, 2}, {{1, 2, 2000}, 1}, {{1, 2, 2000}, .2}}
Please help. Thanks.
Sam 
POSTED BY: Samuel Chen
4 Replies
Sort By:
Nick Gaskill
Nick Gaskill
Posted 11 years ago
There's also a useful how-to in Documentation that talks about this...

How to Perform Operations on Subgroups of Data
POSTED BY: Nick Gaskill
You can also use GatherBy[...]:
{#[[1, 1]], Total[#[[All, 2]]]} & /@ GatherBy[data, #[[1]] &]
Apply Sort[...] to the final result if your dates will come out unsorted.
POSTED BY: Vitaliy Kaurov
That's better, yes.

Or even:
GatherBy[ data, First ]
POSTED BY: Arnoud Buzing
Does this work for you?


Map[
{#[[1, 1]], Total[#[[All, 2]]]} &,
Gather[list, SameQ[First[#], First[#2]] &]
]
POSTED BY: Arnoud Buzing
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract