[R] removing non-table lines

Jeff Newmiller jdnewm|| @end|ng |rom dcn@d@v|@@c@@u@
Sun Sep 18 23:31:56 CEST 2022


Use the skip parameter if the number of header lines is always the same.

On September 18, 2022 12:39:50 PM PDT, Nick Wray <nickmwray using gmail.com> wrote:
>Hello - I am having to download lots of rainfall and temperature data in
>csv form from the UK Met Office.  The data isn't a problem - it's in nice
>columns and can be read into R easily - the problem is that in each csv
>there are 60 or so lines of information first which are not part of the
>columnar data.  If I read the whole csv into R the column data is now
>longer in columns but in some disorganised form - if I manually delete all
>the text lines above and download I get a nice neat data table.  As the
>text lines can't be identified in R by line numbers etc I can't find a way
>of deleting them in R and atm have to do it by hand which is slow.  It
>might be possible to write a complicated and dirty algorithm to rearrange
>the meteorological data back into columns but I suspect that it might be
>hard to get right and consistent across every csv sheet and any errors
>might be hard to spot.   I can't find anything on the net about this - has
>anyone else had to deal with this problem and if so do they have any
>solutions using R?
>Thanks Nick Wray
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.

-- 
Sent from my phone. Please excuse my brevity.



More information about the R-help mailing list