The objective of the project is to interact with various file types (CSV, HTML, APIs, etc.), perform cleaning techniques, and then bring the data together and store it in a database. The project is broken down into five project milestones.
Professional Football Hall of Fame- The primary data set used for this analysis is the "HeismanHOF.csv" file containing information about Hall of Famers. Fantasy Football Data Pros NFL Combined Results- The data set describes scouting statistics for players from 1987-2023
-Jupyter Notebook -Data Cleaning with Python
-SQL Server Management Studio - Table creation and simple queries
In the initial data preparation phase, the following tasks were performed:
- Data loading and inspection
- Handling missing values
- Data cleaning and formatting
The analysis findings are summarized as follows:
Based on the analysis, it is recommended that the following: