Question: B . 5 - Franchises with Best Win / Loss Ratios In this subsection, we will identify the 1 0 franchises who have the best
B Franchises with Best WinLoss Ratios
In this subsection, we will identify the franchises who have the best winloss ratios.
Sort the franchisesummary DataFrame in decreasing order by WLratio. Show that first rows of the
following columns in this order: franchID, franchName, seasons, firstyear, lastyear,
WLratio.
BWinLoss Ratios in Recent Years
In this subsection, we will calculate the winloss ratio for each of the current franchises during the period since
which was when the newest franchises were added
Apply a filter to the teams DataFrame keeping only records from or later. Then apply transformations to
calculate the WinLoss Ratio for each team currently active. You will repeat many but not all of the steps
from Subsection B Sort the resulting DataFrame in increasing order by winloss ratio and convert it to a
Pandas DataFrame.
Display the result as a horizontal bar chart. Use the same specifications stated in Subsection B except that
the horizontal axis should represent WinLoss Ratio.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
