Exporting to JSON in Data Analysis Python - Mini Project: Build & Apply

Exporting to JSON

📖 Scenario: You work in a small store that keeps track of product sales. You want to save the sales data in a file so it can be shared with your team easily.

🎯 Goal: Create a Python program that stores sales data in a dictionary, then exports this data to a JSON file.

📋 What You'll Learn

Create a dictionary with product names and their sales numbers

Create a filename variable for the JSON file

Use the json module to export the dictionary to a JSON file

Print a confirmation message after exporting

💡 Why This Matters

🌍 Real World

Exporting data to JSON is common when sharing data between programs or saving data for later use.

💼 Career

Data analysts and scientists often export processed data to JSON files to share with teams or use in web applications.

1

Create the sales data dictionary

Create a dictionary called sales_data with these exact entries: 'Apples': 30, 'Bananas': 45, 'Cherries': 25.

Data Analysis Python

# Create the sales_data dictionary with the exact entries
# Your code here

Hint

Use curly braces {} to create a dictionary with keys and values separated by colons.

2

Create the JSON filename variable

Create a variable called filename and set it to the string 'sales.json'.

Data Analysis Python

sales_data = {'Apples': 30, 'Bananas': 45, 'Cherries': 25}
# Create the filename variable with the value 'sales.json'
# Your code here

Hint

Use a simple assignment to create the filename variable as a string.

3

Export the dictionary to a JSON file

Import the json module. Then open the file named filename in write mode as file. Use json.dump() to write sales_data to file.

Data Analysis Python

sales_data = {'Apples': 30, 'Bananas': 45, 'Cherries': 25}
filename = 'sales.json'
# Import json and export sales_data to the file
# Your code here

Hint

Use with open(filename, 'w') as file: to open the file and json.dump() to write the dictionary.

4

Print confirmation message

Write a print statement that outputs exactly: "Data exported to sales.json".

Data Analysis Python

import json

sales_data = {'Apples': 30, 'Bananas': 45, 'Cherries': 25}
filename = 'sales.json'

with open(filename, 'w') as file:
    json.dump(sales_data, file)
# Print confirmation message
# Your code here

Hint

Use print() with the exact message inside quotes.

Practice

1. What is the main purpose of exporting data to JSON format in data analysis?

easy

A. To save data in a format that is easy to share and widely used

B. To make data unreadable for security

C. To convert data into an Excel spreadsheet

D. To compress data to reduce file size

Solution

1. Step 1: Understand JSON format use

   JSON is a text format that is easy to share and read by many programs.

2. Step 2: Identify the purpose of exporting

   Exporting to JSON helps save data in this easy-to-share format.

3. Final Answer:

   To save data in a format that is easy to share and widely used -> Option A

4. Quick Check:

   Exporting to JSON = Easy sharing [OK]

Hint: JSON is for sharing data simply and widely [OK]

Common Mistakes:

• Thinking JSON is for data compression
• Confusing JSON with Excel format
• Believing JSON makes data unreadable

2. Which of the following is the correct way to export a pandas DataFrame df to a JSON file named data.json?

easy

A. df.write_json('data.json')

B. df.export_json('data.json')

C. df.to_json('data.json')

D. df.save_json('data.json')

Solution

1. Step 1: Recall pandas export method

   The correct pandas method to export JSON is to_json.

2. Step 2: Match method with filename

   Using df.to_json('data.json') saves the DataFrame to the file.

3. Final Answer:

   df.to_json('data.json') -> Option C

4. Quick Check:

   pandas export JSON = to_json() [OK]

Hint: Use df.to_json(filename) to save DataFrame as JSON [OK]

Common Mistakes:

• Using non-existent methods like export_json
• Confusing save_json or write_json with to_json
• Forgetting to provide the filename as a string

3. Given the DataFrame df = pd.DataFrame({'A':[1,2], 'B':[3,4]}), what is the output of df.to_json(orient='records')?

medium

A. '{"A":{"0":1,"1":2},"B":{"0":3,"1":4}}'

B. '[{"A":1,"B":3},{"A":2,"B":4}]'

C. '{"0":{"A":1,"B":3},"1":{"A":2,"B":4}}'

D. '[1,2,3,4]'

Solution

1. Step 1: Understand orient='records'

   This option converts each row to a JSON object in a list.

2. Step 2: Convert DataFrame rows to JSON objects

   Rows become [{"A":1,"B":3}, {"A":2,"B":4}].

3. Final Answer:

   '[{"A":1,"B":3},{"A":2,"B":4}]' -> Option B

4. Quick Check:

   orient='records' = list of row dicts [OK]

Hint: orient='records' makes list of row dictionaries [OK]

Common Mistakes:

• Confusing 'records' with default 'columns' orient
• Expecting a nested dictionary instead of list
• Misreading JSON string format

4. What is wrong with this code snippet for exporting a DataFrame df to JSON?

df.to_json('output.json', orient='wrong')

medium

A. It raises a ValueError because 'wrong' is not a valid orient

B. It will save the file but with empty content

C. It ignores the orient and uses default silently

D. It saves the file but with incorrect JSON format

Solution

1. Step 1: Check valid orient options

   Valid options include 'records', 'columns', 'index', etc., but not 'wrong'.

2. Step 2: Understand error behavior

   Using an invalid orient raises a ValueError immediately.

3. Final Answer:

   It raises a ValueError because 'wrong' is not a valid orient -> Option A

4. Quick Check:

   Invalid orient = ValueError [OK]

Hint: Invalid orient causes ValueError, check spelling [OK]

Common Mistakes:

• Assuming invalid orient defaults silently
• Expecting empty file instead of error
• Thinking JSON format is saved anyway

5. You want to export a DataFrame df with nested dictionaries in a column to JSON, preserving the nested structure. Which orient option should you use to keep the nested data intact?

hard

A. 'records'

B. 'split'

C. 'index'

D. 'table'

Solution

1. Step 1: Understand nested data export needs

   Nested dictionaries require a format that preserves complex structure.

2. Step 2: Identify orient='table' features

   Orient='table' exports data with schema and supports nested structures well.

3. Step 3: Compare other options

   'records' flattens rows, 'split' and 'index' do not preserve nested well.

4. Final Answer:

   'table' -> Option D

5. Quick Check:

   Nested data export = orient='table' [OK]

Hint: Use orient='table' to keep nested JSON structure [OK]

Common Mistakes:

• Using 'records' which flattens nested data
• Choosing 'split' or 'index' which lose nested info
• Not specifying orient and losing structure