Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
ALY6140: Analytics Systems Technology Assignment
The assignment section for Week 2 contains:
and find the number of paragraphs
contains the string "gravitational wave" omitting the cases.
• For json file → find the number of records in the json file, show last 3 records, and find
out the number of null values in column ‘mass’.
• For SQLite database file → find out which customer has the 2nd most accumulated
spending and show CustomerId, the name of the customer, BillingCountry, and total
spending (Hint: One customer might have multiple transactions. Using table customers &
invoices )
ALY6140: Analytics Systems Technology Assignment 2 Winter B 2022
2
Please define above functions in a script file(.py), then import this utility file in a Jupyter
Notebook file(.ipynb) and verify/demonstrate the results.
Please make sure to:
• Properly document the functions
• Properly assign arguments to the functions
• Properly return a data structure from each function
• Avoid excessive printing
• Submit a proper Python script file (A2_utility_firstname_lastname.py) and a Jupyter
Notebook file (A2_test_firstname_lastname.ipynb) as your answer to the assignment