Question 4: Download the following file to your local machin…
Question 4: Download the following file to your local machine: NHL_data.csv The data set contains statistics for some of the National Hockey League teams across the years. Question: Perform the tasks listed below using the Pandas Library. Notice that these tasks are divided into 3 cells. Please only use the designated cell area in the Jupyter file to write down your corresponding code. After importing the file at the beginning, you can continue working on the same data (i.e., you don’t need to re-import the data for each individual cell). Cell #1: Import the downloaded data into the Python environment as a Pandas DataFrame. Drop the column titled “GamesPlayed” from the DataFrame. Select the first 10 observations and the first 5 columns from the data and display the values. Do NOT assign the selection to anything — simply display the values on the screen. Cell #2: Display all observations that had more than 40 “Shots”. Show all the columns for these observations. Select and display all observations in Year 2011 that had more “Wins” than the average number of “Wins” for that particular year (2011). Cell #3: Notice that the “SeasonWinner” column indicates the season winner for a given year (The value of that column is “Y” if winner of the “Year”). Find out which team won the season the most across the years. Do the necessary operation in Pandas and print out a single output (can be a table or a string) that states the team’s name and the number of season wins.