[R] csv file with two header rows

[John Kane]

Thanks Peter, I must have misread the read.csv help. I thought skip had been dropped with a couple of other options.

John Kane
Kingston ON Canada


> -----Original Message-----
> From: pdalgd at gmail.com
> Sent: Sat, 27 Apr 2013 09:48:22 +0200
> To: jrkrideau at inbox.com
> Subject: Re: [R] csv file with two header rows
> 
> 
> On Apr 26, 2013, at 14:48 , John Kane wrote:
> 
>> I don't think so. read.csv is a striped down version of read.table.  You
>> should be able to do this with the skip option there.
> 
> You can also pass skip= to read.csv, it just passes it on to read.table.
> But it is not clear to me what is supposed to happen with the the double
> header, or what the file format in question is exactly.
> 
> It is, e.g., quite possible to do something like
> 
> hd <- read.csv(..., nrows=2)
> df <- read.csv(..., skip=2, header=FALSE)
> names(df) <- ... some operation on hd ...
> 
>> 
>> John Kane
>> Kingston ON Canada
>> 
>> 
>>> -----Original Message-----
>>> From: analyst41 at hotmail.com
>>> Sent: Thu, 25 Apr 2013 18:35:42 -0700 (PDT)
>>> To: r-help at r-project.org
>>> Subject: [R] csv file with two header rows
>>> 
>>> Is there a way to use read.csv() on such a file without deleting one
>>> of the header rows?
>>> 
>>> Thanks.
>>> 
>>> ______________________________________________
>>> R-help at 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.
>> 
>> ____________________________________________________________
>> GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at
>> http://www.inbox.com/smileys
>> Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™
>> and most webmails
>> 
>> ______________________________________________
>> R-help at 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.
> 
> --
> Peter Dalgaard, Professor,
> Center for Statistics, Copenhagen Business School
> Solbjerg Plads 3, 2000 Frederiksberg, Denmark
> Phone: (+45)38153501
> Email: pd.mes at cbs.dk  Priv: PDalgd at gmail.com

____________________________________________________________
GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at http://www.inbox.com/smileys
Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails