Data Analysis and Visualization

Perform the following data analysis on NFL dataset (NFL.xlsx).

  1. Load the data from excel file into a pandas DataFrame named ‘data’.
  2. 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]
  3. Add month number and week number columns to the dataFrame.
    [Bonus: Also add month name]
  4. Display month-wise Visitor v/s home win split for all teams combined using stacked bar
    graph.
    [Bonus: display week-wise stacked bar graph]
  5. 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.
  6. Display the names of Top 5 and bottom 5 teams based on number of wins.
  7. Display a ‘boxplot’ of scores for games won and lost by top 5 teams.

find the cost of your paper

This question has been answered.

Get Answer