Creating a pandas DataFrame from a JSON String

Overview:

JSON is the abbreviation of JavaScript Object Notation. A JSON string consists of a collection of name value pairs. The value for a name can be a collection.
The function read_json() of pandas library constructs and returns a DataFrame object, while to_json() creates a JSON string from a DataFrame object.

Example:

# Example Python program that creates
# a DataFrame instance from a JSON string
import pandas as pds

# Animal data as JSON string
animalData = """[{"Animal":"Asian Elephant", "Height": 110, "Weight":8818},
{"Animal":"Lion", "Height": 47, "Weight":418},
{"Animal":"Giraffe", "Height": 232, "Weight":2627},
{"Animal":"Brush Rabbit", "Height": 12, "Weight":1.54}]"""

# Create a DataFrame from JSON
animalDataFrame = pds.read_json(animalData)

# Print the DataFrame
print(animalDataFrame)

Output:

Animal Height Weight

0 Asian Elephant 110 8818.00

1 Lion 47 418.00

2 Giraffe 232 2627.00

3 Brush Rabbit 12 1.54

Creating A Pandas DataFrame From A JSON String

Overview:

Example:

Output: