How to transform a nested json into a data frame in r?

Question

I am using a third party response in json and I want to analyse it using r. To do so I need to transform the json into an r data frame. For instance my json might look like this:

{
    "useless_info1": "trash1",
    "useless_info2": "trash2",
    "useless_info3": "trash3",
    "usefull_info": [
        {
            "color": "red",
            "sizes": [
                "height": 128,
                "width": 40
            ],
            "flavour": "bitter"
        },
        {
            "color": "blue",
            "sizes": [
                "height": 30,
                "width": 10
            ],
            "flavour": "sweet"
        },
    ]
}

I am looking for something like this:

color     sizes_height     sizes_width    flavor
--------  ---------------  -------------  ---------
red       128              40             bitter
blue      30               10             sweet

Your JSON is invalid. Is that intentional, or a mistake?

Michael Griffiths
– Michael Griffiths

2016-11-28 14:52:08 +00:00
Commented Nov 28, 2016 at 14:52 — Michael Griffiths
– Michael Griffiths, Commented Nov 28, 2016 at 14:52

Michael Griffiths · Accepted Answer · 2016-11-28 14:53:49Z

3

Consider this:

library(jsonlite)

json = '{
    "useless_info1": "trash1",
    "useless_info2": "trash2",
    "useless_info3": "trash3",
    "usefull_info": [
        {
            "color": "red",
            "sizes": {
                "height": 128,
                "width": 40
            },
            "flavour": "bitter"
        },
        {
            "color": "blue",
            "sizes": {
                "height": 30,
                "width": 10
            },
            "flavour": "sweet"
        }
    ]
}'

fromJSON(json)$usefull_info
#>   color sizes.height sizes.width flavour
#> 1   red          128          40  bitter
#> 2  blue           30          10   sweet

answered Nov 28, 2016 at 14:53

Michael Griffiths

1,4278 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to transform a nested json into a data frame in r?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related