Re: [R] Merging rows in dataframes

2009-03-29 Thread Umesh Srinivasan
ou very much! > > Schragi > > > > -Original Message- > > From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] > > Sent: Wednesday, March 25, 2009 3:44 PM > > To: Schragi Schwartz > > Cc: r-help@r-project.org > > Subject: Re: [R] Merging rows

Re: [R] Merging rows in dataframes

2009-03-29 Thread Gabor Grothendieck
way to do this? > > Thank you very much! > Schragi > > -Original Message- > From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] > Sent: Wednesday, March 25, 2009 3:44 PM > To: Schragi Schwartz > Cc: r-help@r-project.org > Subject: Re: [R] Merging rows in d

Re: [R] Merging rows in dataframes

2009-03-29 Thread Schragi Schwartz
tz Cc: r-help@r-project.org Subject: Re: [R] Merging rows in dataframes I've added an example to FAQ 3 on the home page that illustrates group_concat. http://sqldf.googlecode.com On Wed, Mar 25, 2009 at 9:06 AM, Gabor Grothendieck wrote: > In the Links box to the right on the sqldf home

Re: [R] Merging rows in dataframes

2009-03-25 Thread Gabor Grothendieck
e output in the form >> "apple|banana|orange". Is there any way to do this? >> >> Thanks again, >> Schragi >> >> -Original Message- >> From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] >> Sent: Tuesday, March 24, 2009 12:50 AM >> To:

Re: [R] Merging rows in dataframes

2009-03-25 Thread Gabor Grothendieck
: Tuesday, March 24, 2009 12:50 AM > To: Schraga Schwartz > Cc: r-help@r-project.org > Subject: Re: [R] Merging rows in dataframes > > Using sqldf you only need two statements, infile <- file(...) and > DF <- sqldf("select min(a), max(b), mean(c), ... from infile group by

Re: [R] Merging rows in dataframes

2009-03-25 Thread Schragi Schwartz
rothendieck [mailto:ggrothendi...@gmail.com] Sent: Tuesday, March 24, 2009 12:50 AM To: Schraga Schwartz Cc: r-help@r-project.org Subject: Re: [R] Merging rows in dataframes Using sqldf you only need two statements, infile <- file(...) and DF <- sqldf("select min(a), max(b), mean(c), ...

Re: [R] Merging rows in dataframes

2009-03-23 Thread Gabor Grothendieck
Using sqldf you only need two statements, infile <- file(...) and DF <- sqldf("select min(a), max(b), mean(c), ... from infile group by id"). The file statement identifies the filename and the second reads it into sqlite (without going through R), summarizes it and then reads the summarized version

[R] Merging rows in dataframes

2009-03-23 Thread Schraga Schwartz
Hello, I have a dataframe with 40 columns and around 450,000 rows. The first column in each row is a factor id and the remaining are numeric. Some rows have the same ids. What I want to do is to merge each set of rows sharing the same ids (id set) into one single row (summarizing row) wit