Data Analysis and Visualization
Perform the following data analysis on NFL dataset (NFL.xlsx).
- Load the data from excel file into a pandas DataFrame named ‘data’.
- Calculate the total number of wins for home teams and visitor teams and display it using a
pie-chart.
[Bonus: Also show the OT and non-OT split along with Home-Visitor split on pie-chart] - Add month number and week number columns to the dataFrame.
[Bonus: Also add month name] - Display month-wise Visitor v/s home win split for all teams combined using stacked bar
graph.
[Bonus: display week-wise stacked bar graph] - For each team calculate the following and save in a new dataFrame named ‘results’:
a. Number of home and away (Visitor) games.
b. Number of games won and lost.
c. Average winning and losing score.
d. Maximum and minimum score for season. - Display the names of Top 5 and bottom 5 teams based on number of wins.
- Display a ‘boxplot’ of scores for games won and lost by top 5 teams.