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.).

url=paste(“http://ergast.com/api/f1/2008“,sep=””)

url

browseURL(url)
install.packages(“rjson”)
require(rjson)
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!

Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> 

required