Question

How to convert pandas DataFrame to JSON 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(data=array, index=["row1", "row2", "row3"], columns=["col1", "col2"])
print(dataFrame, '\n\n') 

js = dataFrame.to_json() 
json_object = json.loads(js) 
print(json.dumps(json_object, indent = 2)) 


    
            
       
'''
run:
   
     col1 col2
row1    1    2
row2    3    4
row3    5    6 


{
  "col1": {
    "row1": "1",
    "row2": "3",
    "row3": "5"
  },
  "col2": {
    "row1": "2",
    "row2": "4",
    "row3": "6"
  }
}
             
'''

 

70+ SQL courses for beginners and professionals

Answer 2

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() 
json_object = json.loads(js) 
print(json.dumps(json_object, indent = 2)) 


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


{
  "col1": {
    "0": "1",
    "1": "3",
    "2": "5"
  },
  "col2": {
    "0": "2",
    "1": "4",
    "2": "6"
  }
}
             
'''

 

70+ SQL courses for beginners and professionals

Answer 3

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

Answer 4

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 ='index') 
json_object = json.loads(js) 
print(json.dumps(json_object, indent = 2)) 


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


{
  "0": {
    "col1": "1",
    "col2": "2"
  },
  "1": {
    "col1": "3",
    "col2": "4"
  },
  "2": {
    "col1": "5",
    "col2": "6"
  }
}
              
'''

 

70+ SQL courses for beginners and professionals