Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analysis
Course Intro
1.1 - Intro (1:19)
1.2 - If you need a refresher on Python basics, take my 1 hour intro course! (0:35)
1.3 - ...why aren't we just learning Excel or SQL? (3:18)
Introduction to Pandas
2.1 - Installing and importing Pandas (5:38)
2.2 - Creating a dataframe from 'Player Game Data.csv' (4:55)
2.3 - Understanding dataframe contents (8:43)
2.4 - Understanding dataframe contents continued (2:55)
2.5 - Copying dataframes (2:32)
2.6 - Adding columns to dataframes (6:01)
2.7 - Saving dataframes to CSV's (3:41)
Finding the top scorer on each team by average points per game
3.1 - Finding the top scorer on each team by average points per game (2:09)
3.2 - Using 'groupby' to calculate the avg_ppg for each player (4:30)
3.3 - Using 'transform' to save the avg_ppg to the dataframe (2:41)
3.4 - Ranking players by avg_ppg on each team (7:07)
3.5 - Deduplicating the dataframe to only include 1 row per player and running our ranking again (5:20)
3.6 - Filter the dataframe to only include the top players on each team (5:47)
3.7 - Sorting the dataframe by avg_ppg (2:39)
3.8 - Specifying columns we want to keep in the dataframe (6:58)
Finding the top scorer on each team that played half their team's games
4.1 - Finding the top scorer on each team that played half their team's games (2:02)
4.2 - Merging team_games_played_df with player_game_data_df (10:14)
4.3 - Calculating the number of games each player played (2:31)
4.4 - Determine if the player played half of the team's games (5:14)
Creating an algorithm to find the 2019 MVP
5.1 - Creating an algorithm to find the 2019 MVP (5:11)
5.2 - Calculate each player's share of points, assists, and rebounds for the season (11:42)
5.3 - Update the code by implementing a list + for loop (13:05)
5.4 - Lambda Functions (8:46)
5.5 - Calculate the win bonus for each player using a lambda function (8:50)
5.6 - Calculate the win bonus for each player using NumPy (5:28)
5.7 - Calculate the mvp_scores for each player for each game and the whole regular season (4:11)
5.8 - Format and save the dataframe (9:04)
Visualizing our data
6.1 - Visualizing our data (1:45)
6.2 - Install and import Matplot (2:14)
6.3 - Create a bar chart showing the season_mvp_score for the top 10 mvp candidates (6:46)
6.4 - Scatter plot of season_avg_PTS and season_mvp_score (5:37)
6.5 - Histogram of the game_mvp_score for the MVP (7:22)
6.6 - Get the PLAYER_ID for the MVP dynamically so we don't have to hard-code it in (7:25)
Course Wrap
7.1 - That's a wrap! (1:57)
Teach online with
3.2 - Using 'groupby' to calculate the avg_ppg for each player
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock