Homework 4: due by beginning of class as noted in Canvas as a Jupyter notebook.
Try to obey the rules for clean, concise code and comment your assignments where you think
appropriate.
“Some assembly required:” any sources used should be cited, and feel free to ask lots of
questions.
Total: 50 points, 25 for each section you choose. You may choose to write code for any two
of the following three prompts!
Coding 1: Concepts of Computer Programming and the Fantastic Beasts (12.5 points
each for parent and child implementation)
You are a mad computer scientist and have made an entirely new Python animal! Write one
new Python class for a new fantastical or mythical creature that has two methods and three
attributes. These methods and attributes may be of any kind and say or do whatever you want.
At least one method should change an attribute of the animal when invoked. At least one
method should take user-submitted input! Radical or obscure mythical animals will
eceive shout-outs.
Make a child beast that inherits from the parent beast. The child must ove
ide at least one
method from the parent. It must also inherit at least one of the parent’s attributes.
Coding 2: Python Pandas: Thankfully Not Endangered (5 points for part 1, 10 for parts 2
and 3)
Using Pandas and tabular data of your choice (it can be junk data or real data in a CSV, Excel,
or whatever):
1. Import the data into a dataframe, ensuring the dataframe has good column names and a
descriptive, useful index (not just auto-numbered rows!).
2. Show that the data imported is clean - each row has valid values in the context of each
column, by writing some Python code that analyzes it. For example, your code might
show you have no blank cells and no cells with data that does not fit the desired format
of the data. If the data isn’t clean, fix any problems you discover via Python code.
3. Perform one operation on the dataframe to query the data, showing some minor but
meaningful conclusion like the minimum or maximum of a specific column. Perform a
second operation that involves an insight across two columns.
Coding 3: SQLite, SQL, and You (5 points for parts 1, 2, 4, 10 points for part 3)
1. Create a SQLite database named “hw4.db” from your Jupyter notebook. Include a
schema with at least six unique columns.
2. Load the database with at least five rows of data using the appropriate SQL commands.
3. Run two SQL statements such that each statement returns a single row of the data from
the database. The two statements must use different syntax or operational choices.
4. Return a count of the rows in the database, and then delete a row of the data. Return a
count of the remaining rows in the database.