Automating Rocket League data collection

I have returned with MORE data to improve my Rocket League (RL) gameplay. I took a new data collection and analysis approach, utilizing Python and Power BI, automating most of the manual collection. I will give a general overview of my data wrangling and my thoughts along the way. If you haven’t already read my previous RL article, I suggest you click<a href="https://medium.com/@joncollins2592/optimizing-rocket-league-gameplay-7d3d9407eb81" rel="noopener"> HERE</a>. In my last project, I focused mostly on optimizing win rates and implementing gameplay changes based on the collected data. The goal of this project will be to automate the data collection process and create a relevant dashboard. So, data collection. Previously, I was manually recording data in Google Sheets after EVERY game played. This time around, I downloaded a RL plugin, BakkasMod, to export recordings of games played. This app sends game replays immediately after a match to<a href="https://ballchasing.com/?uploader=76561199247852261" rel="noopener ugc nofollow" target="_blank"> Ballchasing.com</a> (BC.com), which creates useable CSV files. After I navigate to BC.com and download a game, Python cleans, concatenates, and adds additional fields to the data. Not only does this process eliminate the time it takes to record data after a game, but BC.com has more game analysis fields. I would like to personally thank the creators and operators of BC.com for keeping it free, saving me loads of time, and making this project possible. Is this a truly automated process? No. The one hiccup is each game file needs to be manually downloaded from BC.com. This is done between games while waiting in the queue. Perhaps an API call or the Python library selenium will be utilized in the future should there ever be another RL article. Regardless, once files are downloaded to my computer the data cleanse can begin. <a href="https://medium.com/@joncollins2592/automating-rocket-league-data-collection-7bb20c26ae18">Click Here</a>