Top "Aggregate" questions

How to add count of unique values by group to R data.frame

I wish to count the number of unique values by grouping of a second variable, and then add the count …

r count unique aggregate

How does a site like kayak.com aggregate content?

Greetings, I've been toying with an idea for a new project and was wondering if anyone has any idea on …

api architecture screen-scraping aggregate

Extract row corresponding to minimum value of a variable by group

I wish to (1) group data by one variable (State), (2) within each group find the row of minimum value of another …

r dplyr data.table aggregate

Group by multiple columns and sum other multiple columns

I have a data frame with about 200 columns, out of them I want to group the table by first 10 or …

r grouping aggregate plyr data.table

AggregateException C# example

I have seen an example of AggregateException on the web and I'm trying to figure out how it works. I …

c# exception aggregate

SQL group by day, with count

I've got a log table in SQL Server that looks like this: CREATE TABLE [dbo].[RefundProcessLog]( [LogId] [bigint] IDENTITY(1,1) NOT …

sql sql-server group-by aggregate

Keep other columns when doing groupby

I'm using groupby on a pandas dataframe to drop all rows that don't have the minimum of a specific column. …

python pandas aggregate pandas-groupby

Name columns within aggregate in R

I know I can *re*name columns after I aggregate the data: blubb <- aggregate(dat$two ~ dat$one, ...) …

r rename aggregate

SSRS Expression: The value expression for textbox has scope parameter that is invalid for aggregate

i'm recieving the following error: Error 1 [rsInvalidAggregateScope] The Value expression for the text box ‘Textbox2’ has a scope parameter that …

reporting-services ssrs-2008 concatenation aggregate ssrs-expression

SQL distinct and count

I have a query where I want to get distinct dates, the phone numbers associated with those dates, and a …

sql count aggregate distinct