Transforming JSON string to Pandas DataFrame in Flask

Question

I'm parsing JSON data in Flask from POST request. Everything seems to be fine and works ok:

from flask import Flask
from flask import request
import io
import json
import pandas as pd

app = Flask(__name__)

@app.route('/postjson', methods = ['POST'])

def postJsonHandler():

    print (request.is_json)
    content = request.get_json()
    df = pd.io.json.json_normalize(content)
    print (df)
    return 'JSON posted'

app.run(host='0.0.0.0', port= 8090)

The output looks like this:

True 

          columns                                               data
0  [Days, Orders]  [[10/1/16, 284], [10/2/16, 633], [10/3/16, 532...

Then I try to transform json to pandas dataframe using json_normalize() function. So I receiving the result close to pandas dataframe but it is not yet it. What changes in the code should I do to receive classical Pandas Dataframe format with columns and data inside.

Thanks in advance.

Keithx · Accepted Answer · 2017-10-26 13:24:38Z

1

Solved the problem. The idea was to use parameters of the json_normalize() function something like that:

df = pd.io.json.json_normalize(content, 'data')

answered Oct 26, 2017 at 13:24

Keithx

3,15816 gold badges45 silver badges81 bronze badges

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

Collectives™ on Stack Overflow

Transforming JSON string to Pandas DataFrame in Flask

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