Transform json into table where attributes come columns and objects come rows

Asked Sep 27 '17 at 17:37

Active Sep 27 '17 at 17:49

Viewed 84 times

I'm running some scripts in version 3.4.1 using Rstudio.

What I need ? Transform json into table where attributes come columns and objects come rows

That's the script:

library(data.table)
library(jsonlite)

url <- 'http://ergast.com/api/f1/2004/1/results.json'
res <- fromJSON(file=url)
drivers <- res$MRData$RaceTable$Races$Results[[1]]$Driver
colnames(drivers)

The result that I hope is something like

   givenName    familyName code nationality
1    Michael    Schumacher  MSC      German
2     Rubens   Barrichello  BAR   Brazilian
3   Fernando        Alonso  ALO     Spanish
4       Ralf    Schumacher  SCH      German
5       Juan Pablo Montoya  MON   Colombian
6     Jenson        Button  BUT     British
7      Jarno        Trulli  TRU     Italian
8      David     Coulthard  COU     British
9     Takuma          Sato  SAT    Japanese
10 Giancarlo    Fisichella  FIS     Italian

edited Sep 27 '17 at 17:49

asked Sep 27 '17 at 17:37

Fabio de Paula

`drivers = drivers[,c(4,5,2,7)]` – Alexey Ferapontov Sep 27 '17 at 17:42
but the var "drivers" return NULL ever ... – Fabio de Paula Sep 27 '17 at 17:54
Try `res <- fromJSON(txt=url)` – Alexey Ferapontov Sep 27 '17 at 17:59
209/5000 There is no problem with "res". The problem is when I start the "drivers". The "drivers" variable will return "NULL" Apparently the problem in the line `drivers<- res$MRData$RaceTable$Races$Results[[1]]$Driver` – Fabio de Paula Sep 27 '17 at 18:26
Worked for me. R 3.1.2 – Alexey Ferapontov Sep 27 '17 at 21:54
I think you may have your libraries confused: `jsonlite::fromJSON()` doesn't have a `file` argument. You may be using `library(rjson)` in stead. (Both libraries have a `fromJSON` function.) – SymbolixAU Sep 27 '17 at 22:16
so replace `fromJSON(file=url)` with `jsonlite::fromJSON(url)` and it will work – SymbolixAU Sep 27 '17 at 22:19

Transform json into table where attributes come columns and objects come rows

0 Answers0