Displaying 6 results from an estimated 6 matches for "groupby".
Did you mean:
group_by
2010 Jul 30
1
Unique rows in data frame (with condition)
...3 z
4 5 b
5 8 c
However, I want only the first occurance of timestamp and then
selected over the first label resulting in an output like this:
timestamp mylabel
1 3 a
4 5 b
5 8 c
Is there something like groupBy (like in SQL) ?
Best,
Ralf
2008 Sep 03
4
delta index in Sphinx
...0.9.8-release (r1371)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file ''/usr/local/etc/sphinx.conf''...
-------------------------------------------------------------------
>> @sphinx = Sphinx.new
=> #<Sphinx:0xb6f7fe20 @mode=0, @host="localhost", @groupby="",
@port=3312, @min_id=0, @warning="", @error="", @max={}, @weights=[],
@sortby="", @maxmatches=1000, @min={}, @filter={}, @sort=0, @limit=20,
@offset=0, @groupfunc=0, @max_id=4294967295>
>> @sphinx.set_match_mode(Sphinx::SPH_MATCH_ANY)
=> 1
&g...
2007 Jul 30
4
indexing only the changed values
Hi all,
i have model A which has a field indexed from model B. model A belongs
to model B.
So whenever i insert a row in model ''A'', a query is fired to the field from
model ''B'' even though the data was not changed for the field in model B.
Can i somehow avoid these extra queries,or rather query the data and index
it,only if the data has been changed>?
e.g
2009 Mar 01
1
SPSS repeated interaction contrast in R
...CongruenceNow F1.0 CongruenceBefore
F1.0 Subjects F1.0.
# CACHE.
# EXECUTE.
# DATASET NAME DataSet1 WINDOW=FRONT.
#
# SORT CASES BY Subjects TaskSwitch CongruenceNow CongruenceBefore .
# CASESTOVARS
# /ID= Subjects
# /INDEX=TaskSwitch CongruenceNow CongruenceBefore
# /GROUPBY=VARIABLE.
#
# GLM RT.1.1.1 RT.1.1.2 RT.1.1.3 RT.1.2.1 RT.1.2.2 RT.1.2.3
RT.1.3.1 RT.1.3.2 RT.1.3.3 RT.2.1.1
# RT.2.1.2 RT.2.1.3 RT.2.2.1 RT.2.2.2 RT.2.2.3 RT.2.3.1 RT.2.3.2 RT.2.3.3
# /WSFACTOR=TaskSwitch 2 Repeated CongruenceNow 3 Repeated
CongruenceBefore 3 Repeated
# /METHOD...
2009 Jan 02
7
the first and last observation for each subject
I have the following data
ID x y time
1 10 20 0
1 10 30 1
1 10 40 2
2 12 23 0
2 12 25 1
2 12 28 2
2 12 38 3
3 5 10 0
3 5 15 2
.....
x is time invariant, ID is the subject id number, y is changing over time.
I want to find out the difference between the first and last observed y
value for each subject and get a table like
ID x y
1 10 20
2 12 15
3 5 5
......
Is there any easy way to generate
2005 Mar 29
6
Aggregating data (with more than one function)
I have the data similar to the following in a data frame:
LastName Department Salary
1 Johnson IT 56000
2 James HR 54223
3 Howe Finance 80000
4 Jones Finance 82000
5 Norwood IT 67000
6 Benson Sales 76000
7 Smith Sales 65778
8 Baker HR 56778
9 Dempsey HR 78999
10 Nolan