Reading and writing data from JSON

JSON (JavaScript Object Notation) files are a widely used format for interchanging data among web applications and servers. It acts as a data interchanger and is more readable compared to XML. pandas offers the read_json function for reading JSON data and to_json() for writing JSON data:

# Reading JSON file
df=pd.read_json('employee.json')

# display initial 5 records
df.head()

This results in the following output:

In the preceding code example, we have read the JSON file using the read_json() method. Let's see how to write a JSON file:

# Writing DataFrame to JSON file
df.to_json('employee_demo.json',orient="columns")

In the preceding code example, we have written the JSON file using the to_json() method. In the to_json() method, the orient parameter is used to handle the output string format. orient offers record, column, index, and value kind of formats. You can explore...