How to generate a complex json from R dataframe
Opened this issue · 0 comments
redleafnew commented
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)