pandas json object read error when using flask request get_json

Question

I am passing a JSON object through a POST API into a flask app. The goal is to convert it to a single row pandas DF and pass it on for further processing.

the JSON payload is as follows:

{
  "ABC": "123",
  "DATE": "2020-01-01",
  "AMOUNT": "100",
  "IDENTIFIER": "12345"
}

The output of data=flask.request.get_json() and print(data) is

{'ABC': '123', 'DATE': '2020-01-01', 'AMOUNT': '100','IDENTIFIER': '12345'}

But when I do a pd.read_json(data) on it I get an error ValueError: Invalid file path or buffer object type: <class 'dict'> Any ideas on how to handle this? I need the output to be

ABC    DATE        AMOUNT    IDENTIFIER
123   2020-01-01   100        12345

Thanks!

Lorenzo Bonetti · Accepted Answer · 2022-07-20 08:03:10Z

1

Try this:

import pandas as pd

df = pd.DataFrame([data.values()], columns=data.keys())
print(df)

Output:

     ABC       DATE          AMOUNT   IDENTIFIER
 0   123       2020-01-01    100      12345

edited Jul 20, 2022 at 8:03

answered Jul 20, 2022 at 7:53

Lorenzo Bonetti

6406 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

pandas json object read error when using flask request get_json

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