> And I've read them with the 2-calls-to-read.table trick you mentioned
> > hd <- read.csv(..., nrows=2)
> > df <- read.csv(..., skip=2, header=FALSE)
> > names(df) <- ... some operation on hd ...
> (or 3 calls, when I wanted to paste the units onto the variable name.)
Or with read.table(text=readLines("http://...";)[-2]):
> u <- "http://www.ndbc.noaa.gov/data/5day2/SISW1_5day.cwind";
> d <- read.table(text=readLines(u)[-2], header=TRUE, comment.char="",
check.names=FALSE)
> d[1:4,]
#YY MM DD hh mm WDIR WSPD GDR GST GTIME
1 2013 4 27 14 0 190 4.1 200 5.7 1337
2 2013 4 27 13 50 198 4.1 999 99.0 9999
3 2013 4 27 13 40 196 4.1 999 99.0 9999
4 2013 4 27 13 30 202 4.1 999 99.0 9999
> with(d, plot(complex(mod=WSPD, arg=(90-WDIR)/180*pi), asp=1))
Bill Dunlap
Spotfire, TIBCO Software
wdunlap tibco.com
> -----Original Message-----
> From: William Dunlap
> Sent: Saturday, April 27, 2013 7:36 AM
> To: 'peter dalgaard'; John Kane
> Cc: r-help@r-project.org; analys...@hotmail.com
> Subject: RE: [R] csv file with two header rows
>
> > 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.
>
> I've seen double headers in which the first line gives the names of the
> variables
> and the second their units. E.g.,
> http://www.ndbc.noaa.gov/data/5day2/SISW1_5day.cwind
> contains wind data (from Smith Island, Washington) and it currently starts
> with
> #YY MM DD hh mm WDIR WSPD GDR GST GTIME
> #yr mo dy hr mn degT m/s degT m/s hhmm
> 2013 04 27 14 00 190 4.1 200 5.7 1337
> 2013 04 27 13 50 198 4.1 999 99.0 9999
> 2013 04 27 13 40 196 4.1 999 99.0 9999
> 2013 04 27 13 30 202 4.1 999 99.0 9999
> 2013 04 27 13 20 199 3.6 999 99.0 9999
> 2013 04 27 13 10 188 3.1 999 99.0 9999
> 2013 04 27 13 00 182 3.1 210 4.1 1218
> 2013 04 27 12 50 198 3.1 999 99.0 9999
> And I've read them with the 2-calls-to-read.table trick you mentioned
> > hd <- read.csv(..., nrows=2)
> > df <- read.csv(..., skip=2, header=FALSE)
> > names(df) <- ... some operation on hd ...
> (or 3 calls, when I wanted to paste the units onto the variable name.)
>
> Bill Dunlap
> Spotfire, TIBCO Software
> wdunlap tibco.com
>
>
> > -----Original Message-----
> > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On
> > Behalf
> > Of peter dalgaard
> > Sent: Saturday, April 27, 2013 12:48 AM
> > To: John Kane
> > Cc: r-help@r-project.org; analys...@hotmail.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: analys...@hotmail.com
> > >> Sent: Thu, 25 Apr 2013 18:35:42 -0700 (PDT)
> > >> To: r-help@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@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(r), MSN(r) Messenger, Yahoo!(r) Messenger, ICQ(r), Google
> > > Talk(tm) and
> > most webmails
> > >
> > > ______________________________________________
> > > 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.
> >
> > --
> > Peter Dalgaard, Professor,
> > Center for Statistics, Copenhagen Business School
> > Solbjerg Plads 3, 2000 Frederiksberg, Denmark
> > Phone: (+45)38153501
> > Email: pd....@cbs.dk Priv: pda...@gmail.com
> >
> > ______________________________________________
> > 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.
______________________________________________
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.
