[R] removing non-table lines

CALUM POLWART po|c1410 @end|ng |rom gm@||@com
Sun Sep 18 21:45:05 CEST 2022

Can you provide a sample of say the first 3 rows then the last 2 rows
before the CSV starts.

Are there always the same number of lines at the top? Or can it vary
depending what non-sense the Met Office decided to contaminate it with?

This should be solvable with some sample data.

Base R or Tidyverse? Any limitations on packages (e.g. stringr?)

On Sun, 18 Sep 2022, 20:40 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.

	[[alternative HTML version deleted]]

More information about the R-help mailing list