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, <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. > [[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.
