Re: [R] how to delete columns with NA values?

Thank you all! It works well now -- View this message in context: http://n4.nabble.com/how-to-delete-columns-with-NA-values-tp1839902p1839953.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://st

[R] how to delete columns with NA values?

[4,]1 [5,]2 [6,]1 what should I do? I search a lot, all I found is how to delete column with all NA values.. Thanks a lot muting -- View this message in context: http://n4.nabble.com/how-to-delete-columns-with-NA-values-tp1839902p1839902.html Sent from the R help

[R] dataframe in loop

nnel,"select caldt, mret from Monthly_returns where crsp_fundno = 2899 and caldt > 19900630 order by caldt") gmret.2899 It will give me what I want: sample2899<-head(gmret.2899) sample2899 caldt mret 1 19900731 0.014204546 2 19900831 -0.050420168 3 19900928 -0.0398

Re: [R] string problems in R

Thank you I am waiting for the R to finish running the loop..I hope it will work.. muting Quoting "jholtman [via R]" : > > > > try this: > > x <- lapply(v.fundno, function(.fund){ >sqlQuery(channel, paste("select mret from monthly_return where >

Re: [R] string problems in R

Hi Charlie: I tried gmret<-sqlQuery(channel, paste( "select mret from Monthly_returns where crsp_fundno =", v.fundno[1] ) ) It works well.. I think you got my problem solved,R just need time to run the loop, not dead.. Thank you very much Muting -- View this message in c

Re: [R] string problems in R

.06285714 0.045774648 but there's 310 data set I need, I cant do them by hand like this, I need the loop. could u please help me out? Thank you very much Muting -- View this message in context: http://n4.nabble.com/string-problems-in-R-tp1685419p1692612.html Sent from the R help mailing lis

[R] string problems in R

ne an object or how to convert number to string.. I would be appreciated if anyone gives me any clue about it. Muting __ 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-contained, reproducible code.