sports | Abandoned sports arbitrage project | Scraper library

I'm trying to scrape some data off ESPN and run some calculations off the scraped data. Ideally, I will like to iterate through a dataframe, grab the players name with Selenium, send the player's name into the search box and tell Selenium to click the player's name. I was able to do this successfully with one player. I'm not quite sure how to iterate through all the players in my data frame.

The second part of the code is where I'm struggling. For some reason I am not able to get the data. Selenium isn't able to find any of the elements. I don't think I'm doing it properly. If I am able to scrape the required data, I will like to plug them into a calculation and append the calculated projected points into my dataframe, dfNBA.

Can someone please help me with my code? and point me in the right direction. I'm trying to be more efficient writing python codes but right now I'm stuck

Thanks

I'm trying to scrape lines for a typical baseball game from fanduel using BeautifulSoup but I found (as this person did) that much of the data doesn't show up when I try something standard like

I'm new to HTML and JS and I'm trying to make an alert when a button is pressed on the webpage that says "Good day" or "Good evening" The problem is that I need to do it on an external JS and I'm having trouble doing it. Here is the code I have so far:

I'm trying to get some insight in this room for optimization for a SQL query (BigQuery). I have this segment of a WHERE clause that needs to include all instances where h.isEntrance is TRUE or where h.hitNumber = 1. I've tested it back and forth with CASE statements, and with OR statements for them, and the results aren't wholly conclusive.

It seems like the CASE is faster for shorter data pulls, and the OR is faster for longer data pulls, but that doesn't make sense to me. Is there a difference between these or is it likely something else driving this difference? Is one faster/is there another better option for incorporating this logical requirement into my query? Below the statement is my full query for context in case that's helpful.

Also open to any other optimizations I may have overlooked within this query as lowering the runtime for this query is paramount to its usefulness.

Thanks!

Need to split the 3rd row and have it in the below xml format.

My Excel data:

My XML data:

I am re-doing the Tesla website just to get a bit of practice, I am aiming for the Cybertruck page. The page consists of one section that I gave a min-height of 100vh. The section contains two elements (text and a button that are inside a span) and I want to position them to the bottom-center of the section by using Flexbox.

Core of the problem

The text and button align perfectly to the center, but not to the bottom. I gave the span element a flex-direction: column and align-items: center which works fine, however, the elements don't align themselves to the bottom of the section when I use justify-content: flex-end and height: 90%.

Do you have any suggestions on how to deal with this problem?

So I have three tables,

news :

I've been struggling to figure out how to describe what I want to do (maybe that's why I can't find anything telling me how...). I'm also aware that my methods of doing things are kinda messy and aren't always most efficient, but I take the macgyver approach and it usually works out.

Basically, I have a table that I've been echoing as a list, with auto_incremented ids in the order the rows were inserted, and ordering alphabetically. The list is getting long and I want to split it into two columns while keeping it in alphabetical order

Relevant code:

i am trying my hand at front end development for the first time and am having a little glitch which is not behaving as i thought it would.

The website is calculating ratings for sports teams using ELO derived algos.

Problem 1 : On the EPL Game Results tab it should only have 'ternary algorithm' active on page load, and the tab should have a green underline. Currently nothing is underlined on initial load, and both tabs (ternary and MOV) appear to be active.

Problem 2 : when you click MOV algorithm, and then refresh the page, I need it to just be the MOV algorithm active and underlined. Currently, MOV stays underlined but both MOV and Ternary become active.

Here is the jsfiddle: https://jsfiddle.net/wa7gb43j/