MLB | Limnoria plugin for displaying some MLB baseball things

I'm creating a small program to return the name of all the link titles when you search for something on google using selenium

here's the code:

I am trying to get MLB game odds and total runs from rotowire. I have tried two approaches and while I can get close, can't quite figure out what I need to do next. The first approach looks like I need to scrape the child class "composite hide." The other approach I have taken returns a bunch of new line and other extra characters despite my attempt to just get the text and strip those out.

I've been using ImportHTML to draw MLB stats from this link without issue: "https://widgets.sports-reference.com/wg.fcgi?css=1&site=br&url=%2Fleagues%2FMLB%2F2021-standard-batting.shtml&div=div_players_standard_batting". I was simply reproducing the table on a Google Sheet.

However, the source table has now grown so large that I'm getting this error in my Sheet: "Resource at url contents exceeded maximum size."

I know I need to pivot to a Google Apps Script and URLFetchApp, but my amateur approach produces nothing but empty cells. Is it possible for me to reproduce the table in my link using this approach?

Thanks for any guidance and your time.

I have this terraform module route_table.tf I need to use. It looks like below:

Im trying to scrape daily fantasy baseball projections from here: https://www.numberfire.com/mlb/daily-fantasy/daily-baseball-projections/batters

I want to navigate through the 'Platform' table dropdown option to get projections for DraftKings (FanDuel is set as the table default) using selenium. Following this answer Selenium (Python): How to insert value on a hidden input? I'm attempting to change the hidden value for class 'dfs-option-drop-value'.

Using the dataset hosted on Google (MBL Data) as an example, here is what I am accomplishing to do - obtain last 3 weeks score run for a given Venue.

My aggregated dataset looks like this without the strikes_3wk column -

Logic for strikes_3wk column is to partition the aggregated dataset by venueName, order by YearWeek column and then obtain the last 3 weeks aggregated strikes data.

Here is the query I have written so far. I see that the windowing function is where I need to modify the logic. So, is there a way to add grouping within the windowing function? Is there any alternative way of doing this?

In the image I added a new column 'expected', showing values for two weeks.

I'm following an online tutorial, but as usual I've gone off-piste and I'm trying to apply the lessons learned to my own project. All is going surprisingly well, however I've hit a problem and I haven't yet been able to find a solution.

https://pastebin.com/x4NjjTij

There are two problems with this (I mean, I'm sure you can find many more than two...):

In any cells that have a hyperlink in them, the data is replaced with "None". Example, this:

I am trying to pull down ticket prices/information for a few baseball games but I am getting errors everytime I try and grab the data... Any idea what would be causing these for price, loc, and detail? I've also tried by XPATH with no success

So I was given some example code of how to essentially control multiple Listboxes within one function, it seems to work during the example code but after implementing i am struggling to see what I've missed out.

Example code: