>>> df.to_json(orient=”records”)<br /> ‘[{“col 1″:”a”,”col 2″:”b”},{“col 1″:”c”,”col 2″:”d”}]’<br />

import numpy as np<br /> import pandas as pd<br />   <br />   <br /> data = np.array([[‘1’, ‘2’], [‘3’, ‘4’]])<br />    <br /> dataFrame = pd.DataFrame(data, columns = [‘col1’, ‘col2’])<br /> json = dataFrame.to_json()<br /> print(json)<br />   <br /> json_split = dataFrame.to_json(orient=”split”)<br /> print(“json_split = “, json_split, “\n”)<br />    <br /> json_records = dataFrame.to_json(orient=”records”)<br /> print(“json_records = “, json_records, “\n”)<br />    <br /> json_index = dataFrame.to_json(orient=”index”)<br /> print(“json_index = “, json_index, “\n”)<br />    <br /> json_columns = dataFrame.to_json(orient=”columns”)<br /> print(“json_columns = “, json_columns, “\n”)<br />    <br /> json_values = dataFrame.to_json(orient=”values”)<br /> print(“json_values = “, json_values, “\n”)<br />    <br /> json_table = dataFrame.to_json(orient=”table”)<br /> print(“json_table = “, json_table, “\n”)</p> <p>## output<br /> json_split = {“columns”:[“col1”, “col2”], “index”:[0, 1], “data”:[[“1”, “2”], [“3”, “4”]]}</p> <p>json_records = [{“col1″:”1”, “col2″:”2”}, {“col1″:”3”, “col2″:”4”}]</p> <p>json_index = {“0”:{“col1″:”1”, “col2″:”2”}, “1”:{“col1″:”3”, “col2″:”4”}}</p> <p>json_columns = {“col1”:{“0″:”1”, “1”:”3″}, “col2”:{“0″:”2”, “1”:”4″}}</p> <p>json_values = [[“1”, “2”], [“3”, “4”]]</p> <p>json_table = {“schema”:{“fields”:[{“name”:”index”, “type”:”integer”}, {“name”:”col1″, “type”:”string”}, {“name”:”col2″, “type”:”string”}], “primaryKey”:[“index”], “pandas_version”:”0.20.0″}, “data”:[{“index”:0, “col1″:”1”, “col2″:”2”}, {“index”:1, “col1″:”3”, “col2″:”4”}]}<br />

df = pd.json_normalize(json data)

dataframe = pd.DataFrame.from_dict(a_json, orient=”index”)