Task 1: Write a function fetch_and_update_user_info() to:
Fetch additional user details (e.g., Username, PictureURL, Timezone) from the
Random User API (
https://randomuser.me/api/).
Update the database schema to include new fields:
Username, PictureURL, Timezone.
Match and update users in the database with these new details based on their ID
Task 2: Discuss the challenges of working with live APIs and JSON data (as comments in the code).
Question 5: Main Function and Demo (2 marks)
Task 1: Write a main function that:
Calls load_user_data(filename) to load data from the CSV file into a list.
Calls visualize_user_data(data) to generate visualizations.
Calls store_user_data_in_database(data) to store the data in the SQLite database.
Calls fetch_and_update_user_info() to fetch live API data and update the database.
Demonstrates the system's functionality by:
Calculate and display the percentage of users by gender who registered in
the last 5 years.
Note: Submit 1 Python file only with no name of the student in the filename, e.g.,PracticalExamFA24.py.
Zoom FUO
+ 110%
Close
