Question

How to convert pandas DataFrame to JSON formating by columns, index and data 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 ='split') 
json_object = json.loads(js) 
print(json.dumps(json_object, indent = 2)) 
 
 
'''
run:
     
  col1 col2
0    1    2
1    3    4
2    5    6 
 
 
{
  "columns": [
    "col1",
    "col2"
  ],
  "index": [
    0,
    1,
    2
  ],
  "data": [
    [
      "1",
      "2"
    ],
    [
      "3",
      "4"
    ],
    [
      "5",
      "6"
    ]
  ]
}
               
'''

 

70+ SQL courses for beginners and professionals