Displaying 20 results from an estimated 951 matches for "aggregating".

2006 Mar 04

6

validation of aggregates

This may not be possible...
I have an aggregation of clwholename defined in my model.
the aggregation builds clwholename from :first_name, middle_initial,
last_name
and it generally works fine.
I am trying to add a validation so while there may be many ''John''
first_names, and ''Doe'' last_names, I only want one ''John Doe''
so I tried...

2011 Feb 22

6

"aggregate" in R

Hi, R users,
I''m wondering how I can aggregate data in R with different functions for
different columns. For example:
x<-rep(1:5,3)
y<-cbind(x,a=1:15,b=21:35)
y<-data.frame(y)
I want to aggregate "a" and "b" in y by "x". With "a", I want to use
function "mean"; with "b", I want to use function "sum". I

2016 Apr 17

1

Trying to understand cut

I am trying to understand cut so I can divide a list of numbers into 10 group:
0-9.0
10-10.9
20-20.9
30-30.9,
40-40.9,
50-50.9
60-60.9
70-70.9
80-80.9
90-90.9
As I try to do this, I have been playing with the cut function. Surprising the following for applications of cut give me the exact same groups. This surprises me given that I have varied parameters include.lowest and right. Can someone

2007 Oct 24

4

Partial aggregate on sorted data

Hi All,
I''m looking for ways to compute aggregate statistics (with the aggregate
function) but with an option for sorting and selecting a subset of the data
frame. For example, I have would like to turn this :
aggregate(myDataframe$TargetValue,list(SomeFactor =
myDataframe$SomeFactor),mean)
into something like
aggregate(myDataframe$TargetValue,list(SomeFactor =

2016 Apr 17

3

Trying to understand cut

Jeff,
Perhaps I was sloppy with my notation:
I want groups
>=0 <10
>=10 <20
>=20<30
......
>=90 <100
In any event, my question remains, why did the four different versions of cut give me the same results? I hope someone can explain to me the function of
include.lowest and right in the call to cut. As demonstrated in my example below, the parameters do not seem to alter

2018 Feb 06

2

Aggregate behaviour inconsistent (?) when FUN=table

Dear R users,
When I use aggregate with table as FUN, I get what I would call a
strange behaviour if it involves numerical vectors and one "level" of it
is not present for every "levels" of the "by" variable:
---------------------------
> df <-
data.frame(A=c(1,1,1,1,0,0,0,0),B=c(1,0,1,0,0,0,1,0),C=c(1,0,1,0,0,1,1,1))
>

2016 Apr 17

1

Trying to understand cut

Have you read FAQ 7.31 recently, John? Your whole premise is flawed. You should be thinking of ranges [0,10), [10,20), and so on because numbers ending in 0.9 are never going to be exact.
--
Sent from my phone. Please excuse my brevity.
On April 16, 2016 7:38:50 PM PDT, John Sorkin <jsorkin at grecc.umaryland.edu> wrote:
>I am trying to understand cut so I can divide a list of numbers

2011 Sep 15

1

Problems with aggregate() function in stats package

Hi,
I''m having some problems with the aggregate() function in the {stats}
package, and the documentation doesn''t address them.
1) Why would the first line work, but the second not? According to the
help file, it accepts a "data=" argument.
> with(tsrc, aggregate(x=DistRatio, by=list(Condition), FUN=mean))
Group.1 x
1 Congruent 1.741789
2 Mismatch

2008 Jan 06

2

aggregate.ts help

Hi,
I have a ts object with a frequency of 4, i.e., quarterly data, and I would
like to calculate the mean for each quarter. So for example:
> ts.data=ts(1:20,start=c(1984,2),frequency=4)
> ts.data
Qtr1 Qtr2 Qtr3 Qtr4
1984 1 2 3
1985 4 5 6 7
1986 8 9 10 11
1987 12 13 14 15
1988 16 17 18 19
1989 20
If I do this manually, the mean

2003 Jan 02

2

aggregate: "sum" not meaningful for factors

Dear all,
I try to summarise my data per category using aggregate, but for some
reason I get the error message "sum" not meaningful for factors even though
my vector is numeric. The data set is shown below.
Could someone please give a hint.
Thanks in advance!
Sincerely,
Tord
> names(test)
[1] "ObjektID" "tallstubbyta"
> is.factor(test$ObjektID);

2011 Aug 05

5

Aggregating data

I aggregated my data: aggresults <-aggregate(results, by=list(results$a, results$b, results$c), FUN=mean, na.rm=TRUE)
results has about 8000 lines of data, and aggresults has about 80 lines. I would like to create a separate variable for each of the 80 aggregates, each containing the 100 lines that were aggregated. I would also like to create plots for each of those 80 datasets.
Is

2005 May 10

1

Aggregate lag

hello,
Does anybody know how to aggregate a lag series ?
when I try to use aggregate I get the following message
> try<-ts(1:100,start=c(1985,1),freq=12)
> aggregate(try,4,mean,na.rm=T)
Qtr1 Qtr2 Qtr3 Qtr4
1985 2 5 8 11
1986 14 17 20 23
1987 26 29 32 35
1988 38 41 44 47
1989 50 53 56 59
1990 62 65 68 71
1991 74 77 80 83
1992

2008 Oct 02

5

aggregate empty row for pretty appearance also subtotal if possible

Hi,
To pretty print aggregates by various dimensions I needed to add a
empty row in output of aggregate.
For example.
d<-(aggregate(data[,cbind("x")], by=list(data$group1,data$group2),
sum))
Group.1 Group.2 x
1 A N 3
2 A Y 2
3 B N 420164905
Is there a way to add an empty

2017 Nov 02

2

RFC: Generate plain !tbaa tags in place of !tbaa.struct ones

On 02/11/17 05:54, Hal Finkel wrote:
>
> On 10/31/2017 05:02 AM, Ivan Kosarev wrote:
>> To clarify further, what this paper proposes is to use !tbaa for all
>> kinds of accesses, including aggregate ones, so we don't need to
>> bother trying to convert them when an aggregate access becomes a
>> series of scalar accesses or vice versa. As I said,

2005 Oct 31

11

Aggregation elements

Howdy,
Is there a method to get the number of elements in an aggregation? Are the
results stored in an aggregation guaranteed to be in any type of order?
Thanks for any insight,
- Ryan
--
UNIX Administrator
http://daemons.net/~matty

2006 Apr 23

2

models and views

Greetings.
I have an application which is used to track jobs and payments.
The billables table contains columns "job_date", "amount" and "receipt"
which indicate the date of the job, the amount due and whether or not
payment has been received, respectively. In addition to tracking and
manipulating individual jobs, the application is also used to generate
aggregate

2010 Jan 25

4

question on sqldf syntax

trying to structure sql to merge two datasets. structure follows:
dbs.possible.combos (all possible combinations of dates and places)
Date Place
1/1/10 N-01
1/1/10 S-02
1/2/10 N-01
1/2/10 S-02
etc...
dbs.aggregate (the raw data aggregated by date and location)
Date Place Days
1/1/10 N-01 6
1/1/10 S-02 10
1/2/10 S-02 5
Trying to merge so I

2008 Jan 26

7

Comparison of aggregate in R and group by in mysql

Hi, netters,
First of all, thanks a lot for all the prompt replies to my earlier question about "merging" data frames in R.
Actually that''s an equivalence to the "join" clause in mysql.
Now I have another question. Suppose I have a data frame X with lots of columns/variables:
Name, Age,Group, Type, Salary.
I wanna do a subtotal of salaries:
aggregate(X$Salary,

2007 Sep 06

3

Warning message with aggregate function

Dear all,
When I use aggregate function as:
attach(warpbreaks)
aggregate(warpbreaks[, 1], list(wool = wool, tension = tension), sum)
The results are right but I get a warning message:
"number of items to replace is not a multiple of replacement length."
BTW: I use R version 2.4.1 in Ubuntu 7.04.
Your kind solutions will be great appreciated.
Best wishes
Yours, sincerely,
Xingwang

2018 Feb 06

1

Aggregate behaviour inconsistent (?) when FUN=table

Don't use aggregate's simplify=TRUE when FUN() produces return
values of various dimensions. In your case, the shape of table(subset)'s
return value depends on the number of levels in the factor 'subset'.
If you make B a factor before splitting it by C, each split will have the
same number of levels (2). If you split it and then let table convert
each split to a factor, one