[R] removing non-table lines

Nick Wray n|ckmwr@y @end|ng |rom gm@||@com
Sun Sep 18 21:39:50 CEST 2022


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]]



More information about the R-help mailing list