How to convert JSON into CSV in R programming

Question

This is my JSON format:

{"abc":
  {
    "123":[45600],
    "378":[78689],
    "343":[23456]
  }
}

I want to convert this JSON format to CSV file in R.

CSV format :

 ds      y
123  45600
378  78689
343  23456

I'm using R library rjson to do this.. 

I tried this:

jsonFile <- fromJSON(file=fileName)
json_data_frame <- as.data.frame(jsonFile)

but it's not working out.

Answer 1

Use the jsonlite::fromJSON to read the data into a list, but you'll have to pull it apart to assemble it into a data.frame:

abc <- jsonlite::fromJSON('{"abc":
{
    "123":[45600],
    "378":[78689],
    "343":[23456]
    }
}')


abc <- data.frame(ds = names(abc[[1]]), 
                  y = unlist(abc[[1]]), stringsAsFactors = FALSE)

abc
#>      ds     y
#> 123 123 45600
#> 378 378 78689
#> 343 343 23456