Re: [R] question about read.columns

2011-06-22 Thread Gabor Grothendieck
On Wed, Jun 22, 2011 at 7:07 PM, Changbin Du wrote: > INstalling of "RSQLite" was successful. > > in R: >> packageVersion("RSQLite") > [1] '0.9.4' > > > > When I try to install "sqldf", I found the following errors: > >> install.packages("sqldf") > Installing package(s) into '/house/homedirs/c/cdu

Re: [R] question about read.columns

2011-06-22 Thread Changbin Du
INstalling of "RSQLite" was successful. in R: > packageVersion("RSQLite") [1] '0.9.4' When I try to install "sqldf", I found the following errors: > install.packages("sqldf") Installing package(s) into '/house/homedirs/c/cdu/library/' (as 'lib' is unspecified) trying URL 'http://cran.cnr.Berke

Re: [R] question about read.columns

2011-06-22 Thread Changbin Du
I will try this first. Thanks, Gabor! On Wed, Jun 22, 2011 at 3:15 PM, Gabor Grothendieck wrote: > On Wed, Jun 22, 2011 at 6:10 PM, Changbin Du wrote: > > My R is 2.12.0. > > > >> R.version.string > > [1] "R version 2.12.0 (2010-10-15)" > >> packageVersion("RSQLite") > > [1] '0.8.0' > >> pac

Re: [R] question about read.columns

2011-06-22 Thread Gabor Grothendieck
On Wed, Jun 22, 2011 at 6:10 PM, Changbin Du wrote: > My R is 2.12.0. > >> R.version.string > [1] "R version 2.12.0 (2010-10-15)" >> packageVersion("RSQLite") > [1] '0.8.0' >> packageVersion("sqldf") > [1] '0.3.5' > > So it seems I have to update or install the 2.13.0 version in my linux > machine

Re: [R] question about read.columns

2011-06-22 Thread Changbin Du
My R is 2.12.0. > R.version.string [1] "R version 2.12.0 (2010-10-15)" > packageVersion("RSQLite") [1] '0.8.0' > packageVersion("sqldf") [1] '0.3.5' So it seems I have to update or install the 2.13.0 version in my linux machine. On Wed, Jun 22, 2011 at 3:04 PM, Gabor Grothendieck wrote: >

Re: [R] question about read.columns

2011-06-22 Thread Gabor Grothendieck
On Wed, Jun 22, 2011 at 6:01 PM, Changbin Du wrote: > I found the following errors: > > >> library(sqldf) > Loading required package: DBI > Loading required package: RSQLite > Loading required package: RSQLite.extfuns > Error: package 'RSQLite' 0.8-0 is loaded, but >= 0.9.1 is required by > 'RSQLi

Re: [R] question about read.columns

2011-06-22 Thread Changbin Du
I found the following errors: > library(sqldf) Loading required package: DBI Loading required package: RSQLite Loading required package: RSQLite.extfuns *Error: package 'RSQLite' 0.8-0 is loaded, but >= 0.9.1 is required by 'RSQLite.extfuns'* > hh<-read.csv.sql("/house/homedirs/c/cdu/operon/gh5/

Re: [R] question about read.columns

2011-06-22 Thread Changbin Du
Hi, Gabor, Thanks so much, I will try it and let you know the results. Appreciated! On Wed, Jun 22, 2011 at 2:54 PM, Gabor Grothendieck wrote: > On Wed, Jun 22, 2011 at 5:45 PM, Changbin Du wrote: > > HI, Dear R community, > > > > I have a large data set names dd.txt, the columns are: there

Re: [R] question about read.columns

2011-06-22 Thread Gabor Grothendieck
On Wed, Jun 22, 2011 at 5:45 PM, Changbin Du wrote: > HI, Dear R community, > > I have a large data set names dd.txt, the columns are: there are 2402 > variables. > > a1, b1, ..z1, a11, b11, ...z11, a111, b111, ..z111.. > > IF I dont know the relative position of the columns, but I know I need the

[R] question about read.columns

2011-06-22 Thread Changbin Du
HI, Dear R community, I have a large data set names dd.txt, the columns are: there are 2402 variables. a1, b1, ..z1, a11, b11, ...z11, a111, b111, ..z111.. IF I dont know the relative position of the columns, but I know I need the following variables: var<-c(a1, c1,a11,b11,f111) Can I use read.