CS-UY 1113 Problem Solving and Programming I — Spring 2024 Homework #7

Submission instructions

1.  You should submit your  homework on Gradescope. To do so, turn in separate .py files for each question or question part, named according to the following pattern: hw7_q1.py,  hw7_q2.py, etc.

2.  Each Python file you submit MUST contain a header comment block as follows: # Author: INSERT YOUR NAME HERE

# Assignment / Part: HW7 - Q1 (etc.)

# Date due: 2023-04-29

# I pledge that I have completed this assignment without

# collaborating with anyone else (including using someone

# else's solution/partial solution, or sharing my

# solution/partial solution) in conformance with the

# NYU School of Engineering Policies and Procedures on

# Academic Misconduct.

Homework Rules

1.  All work should be your own. You should not use any other person's solutions or partial solutions  in your submission. This  includes, but is not limited to current and former students of this class, other Python-related classes, or other students at other institutions. The sharing of your solution or partial solution or work-in-progress is also a violation of the Code of Conduct. The use of generative AI systems (such as ChatGPT) is  forbidden. These rules have been  previously discussed in class. If you do not understand the limitations, please ask a professor. Violating these rules will be treated as a violation of the Tandon Student Code of Conduct.

2.   Do not use any Python language statements or features that have not been lectured on in class by a professor. You may encounter such statements / features / functions in your readings, prior experience, or self-learning. If we didn't cover it in lecture, it's not permitted. If you are unsure if we did or did not cover a topic, please post a question to the EdStem Discussion board .

Code to read the data file

Once the file is successfully read, the superbowl_data variable in the main function will contain a 2D list of the data which will look something like this:

We strongly suggest that you consider writing the initial solution so that it can successfully open and read from the file, and  print the resulting data list. Visually verify that the data is "loaded" into your program by doing so. Once it is printed, examine the first few lines of data. Note that each sublist of the main list contains information about an advertisement during a SuperBowl game.  Details of the advertisement are provided in each sublist, in the following sequence.

Details of each column are found  in the  README file on the  Git Hub  page for the dataset (https://github.com/fivethirtyeight/superbowl-ads?tab=readme-ov-file#super-bowl-ads).

For the remainder of  the homework, implement the functions required and produce any appropriate output as described. Unless otherwise stated, do not produce any output in any function, but return the desired result of the analysis.

Note that in all cases, the data read by the read_data function will need to be passed to each function you author so that the functions can operate and analyze the data. Additional function parameters may need to be sent as well, depending on the function's goal. Also note the data and return type that the function should return. Generally speaking you should be invoking the function in your main function one at a time, (after the else clause) and then print the result of the function.

Question 1 (10 points):

Write a function named get_num_pepsi_or_coke which calculates and returns the number of ads in the dataset that either Pepsi or Coca-Cola ran. That is, what is the number of ads in which the brand is either 'Pepsi' or 'Coca-Cola'. Return an integer value that is 0 or greater. The function should print nothing. Do not use a list comprehension to compute the answer. You will be re-implementing this function below with a list comprehension.

Once the function is invoked and returns, the program should print the result as follows. Include the Q-number and the text exactly as:

Question 2 (15 points):

Write a function named get_num_doritos_listcomp that does the exact same thing as Question 1, however, rather than Pepsi and/or Coca-Cola, search for Doritos. Your implementation must use a list comprehension to compute the result.

Once the function is invoked and returns, the program should print the result as follows. Include the Q-number and the text exactly as:

Question 3 (25 points):

Write a function named get_advertisers_for_year that returns an ascending sorted list of advertisers for a given year. The function should accept an integer year (e.g. 2010). The function will return a list of the brand (advertisers) that ran SuperBowl ads during the specified year. Each brand should be listed only once and the list should be in ascending alphabetical order.

Once the function is invoked and returns, the program should print the result as follows. Include the Q-number, the year, and the text exactly as shown. For example, if we invoke the function and pass it the year 2010, the result should be as follows.

Question 4 (25 points):

Write a function named get_advertiser_count_by_year which calculates and returns a list of sorted tuples.   Each tuple is a pair of an integer year, and the integer number of advertisers that ran an advertisement during the game that year.  (E.g. there were 8 ads run in 2008 according to our data source.) There should be only one tuple for each year in the data set and the tuples should be sorted (ascending) by the year value.

Once the function is invoked and returns, the program should print the result as follows. Include the Q-number, the year, and the text exactly as shown.

Question 5 (25 points):

Write a function named get_years_links_and_animals_by_advertiser_when_patriotic which returns a list of tuples of selected data for brands that have run patriotic advertisements (in any year). The each tuple in the list must contain the following information:

● the year as an integer,

● the YouTube link to the video as a string, and

●    if the advertisement used animals (True or False) as a boolean

This solution must  use a list comprehension to do all of the work (iteration, filtering, sublist construction, data conversion). The function literally can be written in one line (two at the most) using a robust list comprehension to build the results and then return the results.

The function should be used 2x once for the advertiser E-Trade and once for Busweiser. Each time the function is invoked and returns, the program should print the result as follows. Include the Q-number, the year, and the text exactly as shown.