[Coding Exercise 4] Billboard Top 100 Songs Charts

16/10/2023, 13:49 [Coding Exercise 4] Billboard Top 100 Songs Charts https://canvas.sfu.ca/courses/79847/assignments/904834?module_item_id=3035539 1/9 [Coding Exercise 4] Billboard Top 100 Songs Charts Due Nov 3 by 11:59pm Points 22 Submitting a file upload File Types py Start Assignment Concerts are coming back to town! Inspired by the CMPT 120 course, you and your friends want to get ideas of possible concerts to go to by exploring data, and here is an opportunity: You will be able to analyze a data file containing Billboard weekly ranked top 100 songs. The file c ontains data from years 1958 till 2020 and is available in Kaggle (https://www.kaggle.com/datasets/victorsoeiro/netflix-tv- shows-and-movies) (we are providing the link to Kaggle for your interest, but you do NOT need to access there and you do NOT need to become a member there!). For this assignment you are provided a partial data file to make it easier for you to work with, including only the rankings corresponding to the weeks in October 2021. Data File Start by downloading the CSV data file charts.csv from HERE (https://canvas.sfu.ca/courses/79847/files/22121807?wrap=1) (https://canvas.sfu.ca/courses/79847/files/22121807/download?download_frd=1) containing the song charts information for Oct 2021. For clarity, this document will refer to the data file's column names in orange italics . The first row has the title for each column, most of which are self explanatory. peak_rank indicates the highest rank the song reached in the whole file, and weeks_on_board , analogously, indicates the number of weeks that the song has been rated in the top 100, considering the whole file. Rank is the current week ranking, last_week is the previous week ranking. Each line in the file after the first line (i.e. after the titles line) contains data about a particular song/artist. For example, the song "Easy on Me", by Adele, in the first data line, shows how such a song advanced incredibly in the charts! It was in position 68 during the week 2021-10-23 and in the week 2021-10-30 it is in position 1! Many songs appear several times in the file (even in the partial file provided here), as there are rankings for each week and many songs appear in many weeks. Further, the same artist may appear multiple times, even during the same week, since the same or different songs by the same artist may be in these top charts. For example, Ed Sheeran and Drake have a couple songs in the board for week 2021-10-30. Have a careful look through the data file and make sure you understand how it is structured before starting the exercise. Also carefully check the sample outputs which complement the exercise

16/10/2023, 13:49 [Coding Exercise 4] Billboard Top 100 Songs Charts https://canvas.sfu.ca/courses/79847/assignments/904834?module_item_id=3035539 2/9 description. This exercise is broken down into two parts, and part 2 has two queries, all of which should be included, in order, in a single Python file named analyzingCharts.py . Part 1: Overall Data Your program should output the following information (in this order): 1. A greeting messag e to the user. 2. Aggregate information over all the songs in the provided file (i.e. with the October 2021 information): the number of songs including the word "love" in the title (upper or lower case) the songs names which were in rank 1 or 2 the artist 's names whose names start in 'A' the number of songs which advanced in the ranks with respect to the previous week (their current rank number is greater smaller than their last-week rank number ). Rank number #1 is the highest possible rank, indeed. the average of weeks-on-board (of all songs in the provided file) You should NOT check if the songs nor the artists are repeated. That is, if a song or artist is repeated in the file, consider these as separate entries. Hints for Part 1 You should be able to solve this part with one single loop ( considering the loop over the file) . Plan ahead which variables and lists you may need. You may have other loops after you visited all lines of the file to for example print a short list with names. Sample Output Welcome to the Billboard top 100 app! PART 1 ====== Number songs containing the word 'love': 28 Songs names in rank positions 1 or 2: 10 Easy On Me Stay Industry Baby Stay Stay Industry Baby My Universe Stay Stay Industry Baby Artists names starting with 'A': Adele Aventura x Bad Bunny Aventura x Bad Bunny Adele

16/10/2023, 13:49 [Coding Exercise 4] Billboard Top 100 Songs Charts https://canvas.sfu.ca/courses/79847/assignments/904834?module_item_id=3035539 4/9 print("{:<10}".format("fortune")) prints the string " fortune " so that it is left-aligned in a 10 character- wide column print("{:>6.1f}".format(42.367)) prints the number 42.367 to one decimal place, right-aligned in a 6 character-wide column More details about the format method are available in the Runestone textbook. You may also explore https://www.w3schools.com/python/ref_string_format.asp (https://www.w3schools.com/python/ref_string_format.asp) You may use a width of 25 for song titles and for artists names. This will cause a non-aligned look when the names or titles are wider, but that is accepted as ok. Your program must accept any case from the user input. For example, ' Shivers', and 'ShIvErS' would be recognized as the same song. Leading and trailing spaces and punctuation marks including the characters .,?! in the input should also be ignored. Hint for the first query in Part 2 : To determine if an artist is not in the file, notice that you need to visit the whole file. One possibility is to count the number of times the artist name is found as the file is read, and if at the end of visiting the whole file the count is still 0, that indicates that the artist was not found. Hints and simplifying assumptions for the second query in Part 2 : To print only the first occurrence of the requested song, you may use the break statement inside the for loop as soon as you printed such information. There are other ways to obtain this effect to be seen later in the course. Assume that the user types an existing song (or part of song). Assume that there exists at least one song with more weeks on board than the requested song. Sample Output Here is the output for two sample runs: (What the user types is highlighted to aid this description) Sample Run 1 PART 2 ====== First query: Individual artist songs Artist name (may be part of the name) --> sheera Artist Song Date Rank Previous rank Ed Sheeran Bad Habits 2021-10-30 5 4 Ed Sheeran Shivers 2021-10-30 9 10 Ed Sheeran Bad Habits 2021-10-23 4 5 Ed Sheeran Shivers 2021-10-23 10 11 Ed Sheeran Bad Habits 2021-10-16 5 6 Ed Sheeran Shivers 2021-10-16 11 14 Ed Sheeran Bad Habits 2021-10-09 6 4 Ed Sheeran Shivers 2021-10-09 14 17 Ed Sheeran Bad Habits 2021-10-02 4 3 Ed Sheeran Shivers 2021-10-02 17 16

16/10/2023, 13:49 [Coding Exercise 4] Billboard Top 100 Songs Charts https://canvas.sfu.ca/courses/79847/assignments/904834?module_item_id=3035539 5/9 Second query: Songs and weeks on board Song title (may be part of the title) --> wave Requested Song Date Weeks on board Heat Waves 2021-10-30 40 Songs with more weeks on board than the requested song Song Date Extra weeks on board Levitating 2021-10-30 15 Save Your Tears 2021-10-30 5 Levitating 2021-10-23 14 Save Your Tears 2021-10-23 4 Levitating 2021-10-16 13 Save Your Tears 2021-10-16 3 Levitating 2021-10-09 12 Save Your Tears 2021-10-09 2 Levitating 2021-10-02 11 Save Your Tears 2021-10-02 1 Bye! End of app! Sample Run 2 PART 2 ====== First query: Individual artist songs Artist name (may be part of the name) --> xxxxxxxx Artist Song Date Rank Previous rank There is no such artist in the file Second query: Songs and weeks on board Song title (may be part of the title) --> tears Requested Song Date Weeks on board Save Your Tears 2021-10-30 45 Songs with more weeks on board than the requested song Song Date Extra weeks on board Levitating 2021-10-30 10 Levitating 2021-10-23 9 Levitating 2021-10-16 8 Levitating 2021-10-09 7 Levitating 2021-10-02 6 Bye! End of app! General Notes, Requirements

16/10/2023, 13:49 [Coding Exercise 4] Billboard Top 100 Songs Charts https://canvas.sfu.ca/courses/79847/assignments/904834?module_item_id=3035539 7/9 Criteria Ratings Pts 2 pts 2 pts 2 pts 2 pts PART 1 number songs w/word 'love' checked that 'love' is *in* the song name, calculated with accumulation pattern 2 pts Full Marks 1 pts partially correct 0 pts not done or incorrect (hardcoded answer is 0 also for all queries) PART 1 song names in rank positions 1 or 2 maybe printed directly as file is read (requiring starting reading the file form start again) or from a list. Number of songs not required. Maybe using Boolean expression with 'or' or comparing int(rank) <=2 2 pts Full Marks 1 pts partially correct 0 pts No Marks PART 1 artists names starting with 'A' (or "a") (analogous comments to counting song names). Only required that the first name starts with 'A', if multiple artists and 'A' appears after this is NOT required to be counted as first letter having an "A" 2 pts Full Marks 1 pts partially correct 0 pts No Marks PART 1 songs advancing rank wrt. prev week rank number < prev week rank number. (Clarified that *peak number* should not be used, but no penalty if it was used instead of rank number) (Clarified that a previous rank 0 means that such song just entered the charts, so it is not considered to advance. If a special treatment 2 pts Full Marks 1 pts partially correct (comparison made without converting to int: -0.5) 0 pts No Marks

16/10/2023, 13:49 [Coding Exercise 4] Billboard Top 100 Songs Charts https://canvas.sfu.ca/courses/79847/assignments/904834?module_item_id=3035539 8/9 Criteria Ratings Pts 2 pts 1 pts 1 pts 2 pts 1 pts 1 pts 2 pts is done with 0 and reasonable, no penalty) PART 1 avg weeks on board 2 pts Full Marks 1 pts partially correct 0 pts No Marks PART 1 and PART 2 - titles clearly welcome user, identify the two parts 1 pts Full Marks 0 pts No Marks PART 2 First query - ask user part of artist name. consider same case to compare (.lower() or .upper()) 1 pts Full Marks 0 pts No Marks PART 2 first query - all associated info shown may be constructing a list or directly printing. 2 pts Full Marks 1 pts partially correct 0 pts No Marks PART 2 First query correctly aligned (maybe aligned fine for songs that are up to 25 characters. if wider songs are misaligned, no penalty 1 pts Full Marks 0 pts No Marks PART 2 first query correctly (only once) inform when artist name does not contain the part 1 pts Full Marks 0 pts No Marks PART 2 Second query. show requested song information 2 pts Full Marks 1 pts partially correct 0 pts No Marks