Write a Python code to read JSON data from a file and convert it to dataframe, CSV files

Assume you have the following sample json data stored in a file as pandas_sample.json

{
   "employee": {
      "name": "emp1",
      "salary": 50000,
      "age": 31
   }
}

The result for after converting to csv as,

,employee
age,31
name,emp1
salary,50000

Solution

To solve this, we will follow the steps given below −

data = pd.read_json('pandas_sample.json')

df = pd.DataFrame(data)

df.to_csv('pandas_json.csv')

Let’s see the below implementation to get a better understanding −

import pandas as pd
data = pd.read_json('pandas_sample.json')
df = pd.DataFrame(data)
df.to_csv('pandas_json.csv')

employee
age 31
name emp1
salary 50000

Published on 11-Feb-2021 10:59:53