cola | Security library

I'd like to have a 2 column reveal.js slide where I can page through the slides in the left-hand column (ColA) while a video plays in the right-hand column (ColB). The slides accompany the video.

I have it laid out on this page but the contents in the iframe/ColA are not large enough to read. I've tried scaling it but it scales the entire containing div, making the two columns overlap, and does not just scale the contents of the iframe.

Another option is to do the slides like normal, where each slide contains a link to the embedded video. My worry there is that every one of the embedded videos will play at once once the page loads because it's a live stream - it seems like that might eat a lot of processing power as my computer tries to play the same embedded live stream in 30 different slides. When moving from Slide1 to Slide2, are embedded videos stopped?

The full git repo for this is here.

I have a test sheet where I am using an onEdit script to copy a row of data to a different tab, and delete the row from the source. It works fine, but I would like a way for the target sheet to be a variable based on a cell value in the row.

I have 2 large dataframes, df1 and df2. I am missing a column (colB) in df2 and I would like to add that column based of the values in the shared column (colA). If I was using Excel I would do this via a standard vlookup formula but I’m struggling to get the desired results using the pandas merge function.

colA and colB both contain multiple entries of the same value so I’m using this line of code to create a new dataframe with only the unique pairings.

I have some DataFrames:

I'm very rusty on the little SQL I once learned, and while I totally get SELECT column1 FROM table WHERE column2 LIKE pattern, what I need is:

I am trying to convert a tibble with a single row to turn it into a table with 2 columns.
Here's my example :
Many thanks in advance !

I have a dataset in wide format where the x and y ordinates for a line are in separate columns. The example below has only 4 ordinate pairs, but the actual dataset has a few dozen. There is a column with the number of ordinates (n in the example below).

How can I melt this dataframe with so many xn, yn columns? Can I do this without explicitly calling ('x1', 'y1', 'x2', 'y2', 'x3', 'y3', 'x4', 'y4' ... 'xn', 'yn')? I need to track the order, such that the (x1,y1) pair is counter 1; (x2,y2) is counter 2; etc.

I have a Spreadsheet (see link at the bottom of the page) that has 1 row and 3 columns. I want to take the data contained and split it out, resulting in a row by row breakdown.

Is anyone aware of how this could be done using a formula? It would save me a bunch of time doing it manually!

DemoSheet - This shows what the input and the desired outputs are

EDIT:

• The Input sheet shows the data as I have it, using metasyntactic variables as examples (real data will vary, but will always follow the same formatting).

For every email address in the email column, I need to do the following

• Get the list of managers and members and have it output as per the Desired Output 1 sheet. So for each entry in ColA, a row entry for each of the data in B and C, as if they were concatenated, split by " | " and transposed vertically.
• Repeat the above process but only for managers (as per the the Desired Output 2 sheet).

I have an array containing attributes of each store (this is just the first few kv pairs, there're 100 in total)