Why does pandas.read_json() returns an empty dataframe

Question

My problem is quite straightforward.

I have the following json string:
myjson = '{"resolves_to": "16534af166355cda", "aliases": []}'
that I want to convert to a DataFrame using pd.read_json(myjson), but instead of returning a DataFrame with one row and two columns (resolves_to and aliases), with an empty entry in the column aliases (which is what I need), it returns an empty DataFrame.

I would like to understand why, and how to get the DataFrame I need.

Thank you in advance for your answers.

Peter Mølgaard Pallesen · Accepted Answer · 2021-02-09 15:49:20Z

1

You need to make it a list:

myjson = '[{"resolves_to": "16534af166355cda", "aliases": []}]'
import pandas as pd
pd.read_json(myjson)

answered Feb 9, 2021 at 15:49

Peter Mølgaard Pallesen

1,9892 gold badges22 silver badges37 bronze badges

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

1 Comment

pegot Over a year ago

Thank you very much! I also saw that there is an argument 'lines' to the function, that if set to True seems to perform the same thing.

Collectives™ on Stack Overflow

Why does pandas.read_json() returns an empty dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related