jeroen/jsonlite

How to generate a complex json from R dataframe

Opened this issue · 0 comments

Now:

[
  {
    "full": "NATURE REVIEWS DRUG DISCOVERY",
    "ab": "NAT REV DRUG DISCOV",
    "ifc": "84.694",
    "if5": "80.543"
  },
  {
    "full": "LANCET",
    "ab": "LANCET",
    "ifc": "79.321",
    "if5": "77.237"
  }
] 

Expect:

{ 
  "NATURE REVIEWS DRUG DISCOVERY" : ["NAT REV DRUG DISCOV", "84.694", "80.543"],
  "LANCET" : ["LANCET", "79.321", "77.237"]
}

MWE:

ifsxls <- structure(list(full = c("NATURE REVIEWS DRUG DISCOVERY", "LANCET"
), ab = c("NAT REV DRUG DISCOV", "LANCET"), ifc = c("84.694", 
                                                    "79.321"), if5 = c("80.543", "77.237")), row.names = c(NA, -2L
                                                    ), class = c("tbl_df", "tbl", "data.frame"))
toJSON(ifsxls, pretty=TRUE)