Top "Aggregate" questions

Why is there no PRODUCT aggregate function in SQL?

Im looking for something like SELECT PRODUCT(table.price) FROM table GROUP BY table.sale similar to how SUM works. …

sql aggregate

Aggregating by unique identifier and concatenating related values into a string

I have a need that I imagine could be satisfied by aggregate or reshape, but I can't quite figure out. …

r concatenation aggregate

'Could not interpret input' error with Seaborn when plotting groupbys

Say I have this dataframe d = { 'Path' : ['abc', 'abc', 'ghi','ghi', 'jkl','jkl'], 'Detail' : ['foo', 'bar', 'bar','foo','foo','foo'], …

python pandas grouping aggregate seaborn

Entity Framework with LINQ aggregate to concatenate string?

This is easy for me to perform in TSQL, but I'm just sitting here banging my head against the desk …

c# linq entity-framework-4 aggregate

Select the first and last row by group in a data frame

How can I select the first and last row for each unique id in the following dataframe? tmp <- …

r dataframe aggregate

django aggregate or annotate

This is a very stupid thing, I know, but I just don't seem to get the handle on Django aggregate …

django aggregate annotate

Summarizing by subgroup percentage in R

I have a dataset like this: df = data.frame(group = c(rep('A',4), rep('B',3)), subgroup = c('a', 'b', 'c', …

r aggregate percentage

Use data.table to count and aggregate / summarize a column

I want to count and aggregate(sum) a column in a data.table, and couldn't find the most efficient way …

r dataframe data.table aggregate

Explain the aggregate functionality in Spark

I am looking for some better explanation of the aggregate functionality that is available via spark in python. The example …

python apache-spark lambda aggregate rdd

How to include BIT type column in SELECT part with out including it on the GROUP BY in T-SQL?

Here is my T-SQL query SELECT ProductID, VendorID, ProductName= MAX(ProductName), VendorName = MAX(VendorName), IsActive = MAX(IsActive) # This brings error …

sql tsql group-by aggregate