Building a Perfect Team Model EP 2 - Data Cleaning
4Watch me live at twitch.tv/irockths
Data used in this series: https://github.com/IRockThs/OOTPResources/blob/main/Iron%20December%20Export.xlsx
In this episode, I go through the basics of cleaning and preparing data using Power Query for use in OOTP modeling. I also go over tools you can use for data cleaning, such as Power Query, R and Python.
Please let me know in the comments section whether you want that discussion of statistics after episode 3 or toward/at the end of the series.
Out of the Park Baseball is baseball gaming at its finest. Make your move to guide your favorite team to glory. Build a dynasty, win the World Series and achieve immortality.
0:00 Finn-terruption 1
0:52 Introduction
1:33 Finn-terruption 2
2:33: Data Cleaning Discussion
7:16 Cleaning up Innings Pitched (Dollarde Formula)
9:05 Creating Queries in Power Query
10:06 Correcting Innings and Null Values in Power Query
16:56 Group By
26:01 Calculating Modeling Statistics
36:24 Outro
Other Videos By IRockThs
| 2024-04-11 | Perfect Team 25 - Meta and Iron Tournament Model Discussion (04/07/2024) |
| 2024-02-24 | Building a Perfect Team Model EP 5 - Modeling Pitching |
| 2024-01-23 | Building a Perfect Team Model EP 4 - Regression Analysis |
| 2024-01-02 | Building a Perfect Team Model EP 3 - League Totals and Weights |
| 2023-12-30 | Finn-Lights: He's so sneaky! |
| 2023-12-24 | Building a Perfect Team Model EP 2 - Data Cleaning |
| 2023-12-18 | Building a Perfect Team Model Episode 1: Gathering Data |
| 2023-11-25 | Kaizo Ironmon Stream Highlights Ep 1 - "Muk spelled backwards is..." |
| 2023-11-09 | Collete Takes Over the Stream pt 1 |
| 2023-11-09 | Fire moves don't exist! |
| 2023-11-02 | Collete loves belly rubs |
| 2023-09-29 | Tortie pets and purrs |
| 2023-09-24 | Tortie headbutts the camera |
| 2023-09-23 | Collete purrs, Finn grooming |
| 2023-09-21 | Tortie purrs and cuddles |
| 2023-09-20 | Stray Cat Cuddles |
| 2023-09-19 | Cats are the best |
| 2023-09-17 | Tortie scritches and purrs |
| 2023-09-16 | Tortie snuggles with purrs |
| 2023-09-15 | First person tortie cuddles |
| 2023-09-14 | First person tortie cuddles #adoptdontshop |
Other Statistics
Out of the Park Baseball Statistics For IRockThs
At present, IRockThs has 1,374 views spread across 9 videos for Out of the Park Baseball, with his channel uploading 6 hours worth of Out of the Park Baseball videos. This is 11.37% of the total watchable video on IRockThs's YouTube channel.