Question

How to convert pandas DataFrame to JSON formating by table in Python

Answer 1

import numpy as np 
import pandas as pd 
import json
   
array = np.array([['1', '2'], ['3', '4'], ['5', '6']]) 
   
dataFrame = pd.DataFrame(array, columns = ['col1', 'col2']) 
print(dataFrame, '\n\n') 
 
js = dataFrame.to_json(orient ='table') 
json_object = json.loads(js) 
print(json.dumps(json_object, indent = 2)) 


'''
run:
    
  col1 col2
0    1    2
1    3    4
2    5    6 


{
  "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"
    },
    {
      "index": 2,
      "col1": "5",
      "col2": "6"
    }
  ]
}
              
'''

 

70+ SQL courses for beginners and professionals