Top "Aggregate" questions

How to sum a variable by group

I have a data frame with two columns. First column contains categories such as "First", "Second", "Third", and the second …

r dataframe aggregate r-faq

Group By Multiple Columns

How can I do GroupBy Multiple Columns in LINQ Something similar to this in SQL: SELECT * FROM <TableName> …

c# .net linq group-by aggregate

C# Linq Group By on multiple columns

public class ConsolidatedChild { public string School { get; set; } public string Friend { get; set; } public string FavoriteColor { get; set; } public List&…

c# linq group-by aggregate

Mean per group in a data.frame

I have a data.frame and I need to calculate the mean per group (i.e. per Month, below). Name …

r aggregate

Pandas group-by and sum

I am using this data frame: Fruit Date Name Number Apples 10/6/2016 Bob 7 Apples 10/6/2016 Bob 8 Apples 10/6/2016 Mike 9 Apples 10/7/2016 Steve 10 Apples 10/7/2016 Bob 1 …

python pandas dataframe group-by aggregate

Count number of rows within each group

I have a dataframe and I would like to count the number of rows within each group. I reguarly use …

r dataframe aggregate r-faq

LINQ Aggregate algorithm explained

This might sound lame, but I have not been able to find a really good explanation of Aggregate. Good means …

c# .net linq aggregate

How to use GROUP BY to concatenate strings in MySQL?

Basically the question is how to get from this: foo_id foo_name 1 A 1 B 2 C to this: foo_id …

sql mysql string aggregate concatenation

How to group dataframe rows into list in pandas groupby

I have a pandas data frame df like: a b A 1 A 2 B 5 B 5 B 4 C 6 I want to group …

python pandas list aggregate pandas-groupby

SQL Server : SUM() of multiple rows including where clauses

I have a table that looks something like the following : PropertyID Amount Type EndDate -------------------------------------------- 1 100 RENT null 1 50 WATER null 1 60 ELEC …

sql sql-server tsql aggregate