Please can you help me download all this F1 data and get it into a .CSV file for analysis: http://ergast.com/mrd/db/
I have tried a scraping code in R but just cannot seem to get any worthwhile information (its just all jumbled etc.).
raw.data <- readLines(url, warn=”F”)
rd <- fromJSON(raw.data)
But I get the error “unexpected character <” in the last line.
I would love to have the whole dataset but I have no experience with SQL. I have tried downloading SQL and using an online conversion tool but it says I am missing a SELECT statement.
Thank you for any help!