Re: [R] how to read in only some columns of a data file

2009-06-17 Thread Mark Na
Use the colClasses argument in combination with "NULL" for the columns you don't want to read. For example, this code reads the first column as character data and does not import the remaining 10 columns: yourdata<-read.csv("yourdata.csv",colClasses=c(rep("character",3),rep("NULL",10))) HTH, Mark

Re: [R] how to read in only some columns of a data file

2009-06-17 Thread Gabor Grothendieck
read.csv.sql in sqldf will create an sqlite database on the fly, read the file in (without going through R) and then extract into R only that portion specified by an SQL statement. Alternately use read.csv with appropraite colClasses argument. On Wed, Jun 17, 2009 at 4:59 PM, liujb wrote: > > Hel

Re: [R] how to read in only some columns of a data file

2009-06-17 Thread David Winsemius
Read the help page and the Import/Export Manual on the facilities offered by the colClasses parameter of the read.table function. On Jun 17, 2009, at 4:59 PM, liujb wrote: Hello, I have a data file (.csv) that has a size of about 2.6 GB. I am not able to read in the whole data set becaus

[R] how to read in only some columns of a data file

2009-06-17 Thread liujb
Hello, I have a data file (.csv) that has a size of about 2.6 GB. I am not able to read in the whole data set because of the memory limit. I actually only need some columns (3 columns) of the data set, is there a way to read in specified columns? I am using windows. Thanks, Julia -- View this