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.
