☑Kizspy.me
visualize gold price data effectively. In this exam, you will read gold
price data from a
JSON file, process the information to extract key insights, and perform analytical tasks
such as identifying peak value days, calculating price changes, and exporting structured
reports. You will also visualize trends using charts to interpret fluctuations in gold prices
over time.
points)
Question 1: Load and Display Gold Price Table
(2
Write a function to display gold price data (Date | Buy | Sell) in tabular format
from a list of dictionaries.
Task 1: Create a class GoldPrice representing: Date, Buy, and Sell.
Task 2: Create a function display_gold_table to read the JSON file and display
the data in the correct order.
Date
Buy
Sell
2025-06-15
2025-06-16
73,900,000 73,920,000
73,800,000 73,950,000
2025-06-17
73,750,000
73,850,000
Figure 1. Illustration of the result for question 1
points)
Question 2: Query the Lowest Sell Price and Save to SQLite
(2
Query the record(s) with the highest buy price and store the data in a SQLite
table named gold_price(date, buy, sell).
Task 1: Create a function save_lowest_buy_to_sqlite to create gold.db and save
the lowest buy price entry to it.
Zoom
+ 100%
Close
