Python - JSON array to DataFrame

Question

I have this following JSON array.

[
    {
        "foo"=1
    },
    {
        "foo"=2
    },
    ...
]

I would like to convert it to DataFrame object using pd.read_json() command like below.

df = pd.read_json(my_json) #my_json is JSON array above

However, I got the error, since my_json is a list/array of json. The error is ValueError: Invalid file path or buffer object type: <class 'list'>.

Besides iterating through the list, is there any efficient way to extract/convert the JSON to DataFrame object?

@AmiTavory @thebjorn typo guys. Edited to the correct one, i.e. read_json() — Darren Christopher
– Darren Christopher, Commented May 6, 2018 at 12:58

Rakesh · Accepted Answer · 2018-05-06 12:57:54Z

24

Use df = pd.DataFrame(YourList)

Ex:

import pandas as pd

d = [
    {
        "foo":1
    },
    {
        "foo":2
    }
]

df = pd.DataFrame(d)
print(df)

Output:

   foo
0    1
1    2

answered May 6, 2018 at 12:57

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

Comments

Ami Tavory · Accepted Answer · 2018-05-06 12:59:31Z

5

There are two problems in your question:

It called to_csv on a list.
The JSON was illegal, as it contained = signs instead of :

This works by me:

import json
import pandas as pd

>>> pd.DataFrame(json.loads("""[
    {
        "foo": 1
    },
    {
        "foo": 2
    }
]"""))

   foo
0    1
1    2

You can also call read_json directly.

answered May 6, 2018 at 12:59

Ami Tavory

76.7k13 gold badges152 silver badges196 bronze badges

Collectives™ on Stack Overflow

Python - JSON array to DataFrame

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related