Read json from BI Query

Asked Oct 09 '19 at 13:10

Active Oct 09 '19 at 13:10

Viewed 18 times

I have BI Query service which returns something like this:

{"count":78,
"next":"...",
"previous":null,
"results":[
    {"name":"John"surname":"Smith"},
    {"name":"Bob"surname":"Black"},
]}

Is there any easy method to read this data to Pandas DataFrame? read_json(url) can not deal with this. Of course, I can write my code for this, but I believe that it is a common task and someone has written code for this.

asked Oct 09 '19 at 13:10

Bartłomiej Bartnicki

do you want to create a dataframe from the results? – IWHKYB Oct 09 '19 at 13:12
Yes, I want to create DF for all results (iterate until next!=null) – Bartłomiej Bartnicki Oct 09 '19 at 14:17
I think this guy had a similar problem: https://stackoverflow.com/questions/21104592/json-to-pandas-dataframe and found a nice solution for it – IWHKYB Oct 09 '19 at 15:08
I have created a task for it on Pandas: https://github.com/pandas-dev/pandas/issues/28877 – Bartłomiej Bartnicki Oct 09 '19 at 19:44

Read json from BI Query

0 Answers0