Loading Data
The analysis uses the teams and games
datasets, dynamically loaded based on the provided file paths.
Data Cleaning
I drop unnecessary columns, filter out tied games, and ensure columns
are compatible for joining.
Combining Data
The datasets are merged for analysis, linking winners and losers to
their respective teams.
Calculating Wins and Rankings
Wins are calculated, and teams are ranked.
## Analyzing the 1976 NFL season.| Team | Total Wins | Rank |
|---|---|---|
| Denver Broncos | 14 | 1 |
| Los Angeles Rams | 13 | 2 |
| New York Giants | 11 | 3 |
| St. Louis Cardinals | 11 | 4 |
| Cleveland Browns | 10 | 5 |
| Green Bay Packers | 10 | 6 |
| Kansas City Chiefs | 10 | 7 |
| Oakland Raiders | 10 | 8 |
| Atlanta Falcons | 9 | 9 |
| Chicago Bears | 9 | 10 |
| Houston Oilers | 7 | 11 |
| Minnesota Vikings | 7 | 12 |
| Baltimore Colts | 6 | 13 |
| Buffalo Bills | 6 | 14 |
| Dallas Cowboys | 6 | 15 |
| New York Jets | 6 | 16 |
| Philadelphia Eagles | 6 | 17 |
| Pittsburgh Steelers | 6 | 18 |
| San Diego Chargers | 6 | 19 |
| Cincinnati Bengals | 5 | 20 |
| Detroit Lions | 4 | 21 |
| New England Patriots | 4 | 22 |
| New Orleans Saints | 4 | 23 |
| San Francisco 49ers | 4 | 24 |
| Washington Redskins | 4 | 25 |
| Miami Dolphins | 1 | 26 |
This report dynamically evaluates and ranks NFL teams, enabling the analysis to update seamlessly with new data inputs.