Reading JSON with read_json in Pandas - Mini Project: Build & Apply

Reading JSON with read_json

📖 Scenario: You work in a small bookstore. You receive book data from your supplier in JSON format. You want to load this data into Python to analyze it easily.

🎯 Goal: Load the JSON data into a pandas DataFrame using read_json and display it.

📋 What You'll Learn

Use pandas library

Create a JSON string variable with book data

Use pandas read_json to load the JSON string

Print the resulting DataFrame

💡 Why This Matters

🌍 Real World

Many data sources provide data in JSON format. Loading JSON into pandas helps analyze and visualize data easily.

💼 Career

Data scientists and analysts often need to read JSON data from APIs or files to prepare data for analysis.

1

Create JSON string with book data

Create a variable called json_data and assign it this exact JSON string: '[{"title": "Python Basics", "author": "John Doe", "price": 29.99}, {"title": "Data Science 101", "author": "Jane Smith", "price": 39.99}, {"title": "Machine Learning", "author": "Tom Brown", "price": 49.99}]'

Pandas

# Create the JSON string variable json_data
# Your code here

Need a hint?

Use single quotes outside and double quotes inside for the JSON string.

2

Import pandas library

Import the pandas library with the alias pd by writing import pandas as pd

Pandas

json_data = '[{"title": "Python Basics", "author": "John Doe", "price": 29.99}, {"title": "Data Science 101", "author": "Jane Smith", "price": 39.99}, {"title": "Machine Learning", "author": "Tom Brown", "price": 49.99}]'
# Import pandas as pd
# Your code here

Need a hint?

Use the standard import statement for pandas.

3

Load JSON string into DataFrame

Use pd.read_json with the variable json_data to create a DataFrame called df

Pandas

import pandas as pd
json_data = '[{"title": "Python Basics", "author": "John Doe", "price": 29.99}, {"title": "Data Science 101", "author": "Jane Smith", "price": 39.99}, {"title": "Machine Learning", "author": "Tom Brown", "price": 49.99}]'
# Load json_data into a DataFrame called df
# Your code here

Need a hint?

Use pd.read_json(json_data) to read the JSON string.

4

Print the DataFrame

Print the DataFrame df to see the loaded book data

Pandas

import pandas as pd
json_data = '[{"title": "Python Basics", "author": "John Doe", "price": 29.99}, {"title": "Data Science 101", "author": "Jane Smith", "price": 39.99}, {"title": "Machine Learning", "author": "Tom Brown", "price": 49.99}]'
df = pd.read_json(json_data)
# Print the DataFrame df
# Your code here

Need a hint?

Use print(df) to display the DataFrame.