Assignments

Here are the assignment instructions (in Word format).

For this assignment, you’ll use the ARulesAssignmentOutput.csv which is generated based on the Python code as in ICA14. 

In addition, no late submission will be accepted for this assignment (I will post the solution right after the deadline so you can prepare for the exam.)

Here are the assignment instructions and an answer sheet to submit (in Word format).

Here is the data file you’ll need Restaurant.csv. 

For this assignment, you’ll need to modify the python script you used in ICA #12 (ICA12_Clustering.ipynb). 

Due date: Tuesday, 4/16/2024, 11:59 pm.

Here are the assignment instructions(in Word format).

For this assignment, you’ll need to modify the python script you used in ICA #11 (ICA11_Decision_tree.ipynb).

Due date: Tuesday, 4/30/2024, 11:59 pm.

Here are the assignment instructions and an answer sheet to submit (in Word format).

Here is the data file you’ll need BankLoan.csv. (Make sure that the name doesn’t change.)

For this assignment, you’ll need to modify the python script you used in ICA #11 (ICA11_Decision_tree.ipynb).

Due date: Tuesday, 4/9/2024, 11:59 pm.

Here are the instructions and csv file: Assignment #6 – Python Pandas and Sales.csv.

Submit your answer sheet as a PDF document through Canvas>Assignment>To-Do.

Due date: Thursday, 3/21/2024, 11:59 pm.

Here are the instructions and JSON file: Assignment #5 – Python and JSON and restaurant.json.

Submit your answer sheet as a PDF document through Canvas>Assignment>To-Do.

Due date: Thursday, 3/14/2024, 11:59 pm.

Here are the instructions: Assignment #4 – Python Basics.

Submit your answer sheet as a PDF document through Canvas>Assignment>To-Do.

Due date: Thursday, 2/29/2024, 11:59 pm.

Here are the instruction: Assignment #3 – SQL Advanced Queries.

Submit your answer sheet as a word or PDF document through Canvas>Assignment>To-Do.

Due date: Tuesday, 2/13/2024, 11:59 pm.

No late assignment will be accepted after 9 am on 2/14/2024.

Here are the instructions: Assignment #2 – SQL Basic Queries and an answer sheet to submit (in Word format).

Submit the answer sheet as a word or PDF document through Canvas>Assignment>To-Do.

Due date: Tuesday, 2/6/2024, 11:59 pm.

Here is the assignment instruction based on MySQL Workbench (instruction based on Vertabelo): Use MySQL Workbench or Vertabelo and the provided Schema template to complete the assignment.

Remember, you must submit all the required files mentioned in the instructions. Points will be deducted for submissions in the wrong format.