Questions tagged [group-summaries]
69 questions
0
votes
4 answers
Aggregation and filtering in Django
I have this table:
**ID val1 val2**
1 5 6
2 6 4
3 3 1
4 8 4
5 2 6
6 8 2
Using filter query in Django, I want to summarize these data so that I get the mean values…
mrbf
- 512
- 1
- 7
- 23
0
votes
3 answers
Oracle - Group-level summaries
I am trying to create a report that has a summary for each group. For example:
ID NAME COUNT TOTAL TYPE
-------------------------------------------------------------
1 Test 1 10 …
FrustratedWithFormsDesigner
- 26,726
- 31
- 139
- 202
0
votes
1 answer
labelling two summary data in one boxplot
I am a new user of R.
• I would like to combine the results of these two groups and still maintain their labels as two groups. When I combine, they yield a figure, which has lost the labels.
• I would also like to label number 1 and 2 (for both…
user3437736
- 3
- 2
0
votes
2 answers
How to summarize date data by groups in R
I would like to summarize the following sample data into a new dataframe as follows:
Population, Sample Size (N), Percent Completed (%)
Sample Size is a count of all records for each population. I can do this using the table command or tapply.…
Keith W. Larson
- 1,543
- 2
- 19
- 34
0
votes
2 answers
jqgrid summary tpl with group name
Is it possible to display row group summary text with group Value..
As shown in above, I want to set text "total" As "Gwadar-Total" and so on.
How can I achieve this at run time, which get Text from row group and display with summary Text?
I am…
Ahmad
- 13
- 1
- 5
0
votes
1 answer
Oracle SQL: retrieve sum and value from row in group based on value of another column
I am trying to create a summary query that returns the sum of the quantity for each group along with the description from from the row with the largest quantity in that group.
For example, if the table looks like this:
GROUP QTY DESC
----- --- …
user2360190
- 1
- 1
-2
votes
1 answer
How i can summarize totals based on a scalar value in R?
I have a data frame with a column "discount" with values from 0 to 1. I want to count the rows based on grouped values for discount e.g discount 0-0.09 xxx books, 0.1 - 0.19 xxx books, etc
title…
John Kamaras
- 9
- 2
-2
votes
1 answer
calculate and plot time interval means
I would like to calculate and plot changing numbers of differently colored animals over time using dplyr and ggplot2.
I have observations of different animals on random dates and so I would first like to group those observations into 4-day brackets…
Kestrel1
- 163
- 1
- 2
- 8
-2
votes
2 answers
R rbind rows to df with results calculated by group for multiple columns by name
How can I group by "id", apply some arithmetic functions to the last four columns (by group), and add new rows to the df containing the results. Here is an illustrative example with 5 samples (id) and 8 columns:
d1 d2 id type …
Dave Stumped
- 319
- 1
- 3
- 12