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 <nickmw...@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@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. ______________________________________________ R-help@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.
