[R] Sum of column from another df based of row values of df1

information from my side would help or if I need to explain the issue more clearly. Any minor improvement will be great help. Thanks in advance. -Shivam -- *Victoria Concordia Crescit* __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman

Re: [R] Sum of column from another df based of row values of df1

Thanks a lot Jim, it works a treat. Just had to change the date format in the mCALL as well. But you saved me 80 hours of fretting and frustration. Really thankful for it. Regards, Shivam On Mon, Sep 10, 2012 at 1:33 AM, jim holtman jholt...@gmail.com wrote: How about an improvement to 16

Re: [R] Sum of column from another df based of row values of df1

Just to add, I did not know that the speed of data access is so much different in matrix and dataframes. This is one for the future. Thanks again Jim :) -Shivam On Mon, Sep 10, 2012 at 3:29 AM, Shivam shivamsi...@gmail.com wrote: Thanks a lot Jim, it works a treat. Just had to change the date

[R] Query about TSRV

? Can anyone point out please. Thanks and regards, Shivam __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self

Re: [R] Query about creating time sequences

:03 2011-01-04 09:15:04 2011-01-04 09:15:05 ... tseq = merge.xts(seqtimes[[1]],seqtimes[[2]], all = TRUE) tseq Data: numeric(0) Index: integer(0) Any help would be greatly appreciated. Thanks in advance, Regards, Shivam P.S. - The dput of the fdates file: dput(fdates) structure(c(2011-01-03

Re: [R] Query about creating time sequences

) hend - new_period( hour=15, minute=30,second=0 ) mperiod - new_period( second=1 ) numperday - (hend-hstart)/mperiod dtms - expand.grid( dt=pdates, tm=hstart + mperiod * seq( from=0, to=numperday ) ) dtms$dtm - with( dtms, dt + tm ) dtms - dtms[ order( dtms$dtm ), ] Regards, Shivam On Mon, May 28

Re: [R] Query about creating time sequences

sequence. This was the part which I deemed as difficult to achieve. I had mentioned this issue in my previous mails but you might have missed it. Thanks again for your time :) Regards, Shivam On Mon, May 28, 2012 at 5:06 AM, Gabor Grothendieck ggrothendi...@gmail.com wrote: On Sun, May 27

[R] Query about creating time sequences

and regards, Shivam structure(list(20110103, 20110104, 20110105, 20110106, 20110107, 20110110, 20110111, 20110112, 20110113, 20110114, 20110117, 20110118, 20110119, 20110120, 20110121, 20110124, 20110125, 20110127, 20110128, 20110131, 20110201, 20110202, 20110203, 20110204, 20110207

[R] Query regarding date as argument in functions - and about sqldf

no idea. Can anyone help please? Thanks a lot for reading though this long email. Kindly reply if you have an idea about either issue. Regards, Shivam [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch

Re: [R] Problem with SQLDF - Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: no such table:

Thanks Gabor, Jim, POSIXct is working fine :) Regards, Shivam On Thu, May 10, 2012 at 5:22 AM, Gabor Grothendieck ggrothendi...@gmail.com wrote: On Wed, May 9, 2012 at 7:24 PM, Shivam shivamsi...@gmail.com wrote: Ohh ... Thanks Gabor. I have a few related queries then, kindly have a look

[R] Problem with SQLDF - Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: no such table:

', not a 'double' Can anyone guide me if there is any difference in the structure of the two dataframes or what else can be the issue? Thanks in advance, Regards, Shivam Singh [[alternative HTML version deleted]] __ R-help@r-project.org mailing list

Re: [R] Problem with SQLDF - Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: no such table:

+timestamp', something like '2011-01-03 09:07:07' which are of class POSIXlt. I need to perform some arithmetic operations on these columns. Which class would be most appropriate for such kind of data? Thanks and Regards, Shivam On Thu, May 10, 2012 at 4:45 AM, Gabor Grothendieck ggrothendi...@gmail.com

[R] Query about memory used in list and dataframe

. This was in contradiction to the earlier result. What am I missing? Why a 75% reduction in size in one case and double size in other? Anyone with any explanation? Sorry for the verbose email, just wanted to make my case clear. Thanks in advance, Regards Shivam [[alternative HTML version

Re: [R] How to insert filename as column in a file

O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --- Sent from my phone. Please excuse my brevity. Shivam shivamsi...@gmail.com wrote: Reposting in hope

Re: [R] How to insert filename as column in a file

Reposting in hope of a reply. On Tue, Apr 24, 2012 at 1:12 AM, Shivam shivamsi...@gmail.com wrote: Thanks for the quick response. It works for an individual dataframe, but I have many dataframes. This is the code so far fnames = list.files(path = getwd()) for (i in 1:length(fnames

[R] How to insert filename as column in a file

be greatly appreciated. Thanks in advance, Shivam [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html

Re: [R] How to insert filename as column in a file

a date column as in the example. You'll have to extract the date from the filename, of course. -Don -- Don MacQueen Lawrence Livermore National Laboratory 7000 East Ave., L-627 Livermore, CA 94550 925-423-1062 On 4/23/12 9:29 AM, Shivam shivamsi...@gmail.com wrote: Hi, I am