NFL Data Project

Project Description

This is an NFL Play Visualizer is a full-stack web application that transforms Next Gen Stats tracking data into interactive play-by-play visualizations of the 2023 NFL season. The application features a dual-panel interface displaying pre-snap formations alongside animated route development, combining frame-by-frame tracking data with comprehensive play analytics including formations, coverage schemes, and Expected Points Added (EPA). Built with a React frontend and Python Flask API, the system manages a PostgreSQL database containing over 5 million player tracking records across 14,000+ plays, implementing intelligent frame sequencing to merge pre-throw input data with post-throw prediction data for complete play visualization. The project demonstrates advanced database optimization through custom SQL views and compound indexing, RESTful API design with multiple endpoints, SVG-based coordinate transformations for field rendering, and complex ETL pipeline development processing 36 CSV files while handling data type standardization and non-unique identifier resolution across multi-million row datasets