Question: B . 5 - Franchises with Best Win / Loss Ratios In this subsection, we will identify the 1 0 franchises who have the best

B.5- Franchises with Best Win/Loss Ratios
In this subsection, we will identify the 10 franchises who have the best win/loss ratios.
Sort the franchise_summary DataFrame in decreasing order by WL_ratio. Show that first 10 rows of the
following columns (in this order): franchID, franchName, seasons, first_year, last_year,
WL_ratio.
B.6-Win/Loss Ratios in Recent Years
In this subsection, we will calculate the win/loss ratio for each of the current franchises during the period since
1998(which was when the newest franchises were added).
Apply a filter to the teams DataFrame keeping only records from 1998 or later. Then apply transformations to
calculate the Win/Loss Ratio for each team currently active. You will repeat many (but not all) of the steps
from Subsection B.2. Sort the resulting DataFrame in increasing order by win/loss ratio and convert it to a
Pandas DataFrame.
Display the result as a horizontal bar chart. Use the same specifications stated in Subsection B.4, except that
the horizontal axis should represent Win/Loss Ratio.
 B.5- Franchises with Best Win/Loss Ratios In this subsection, we will

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!