cafe | A replica of Transformice 's Cafe | Database library

I have a image in 16:9 (1920 x 1080) of a draw with some led light strips on it.

My objective is to implement a div of a gradient color to simulate a light effect, but I can only make this when the image is static on the background. When I implement a object-fit: cover; property, the light div doesn't keep his position on the right area.

I have already tried to use background-image instead of tag and tried to create a wrapper with position relative and absolute. Also, I'm using only responsive values into the css (percentages and viewport).

I think that the problem is in the fact that the object-fit: cover adjusts the image with zooms, and the div image doesn't follow that.

That's the image I'am using on this project. There's already a pink light coming out the LED strips on the draw, and I'm trying to make a new light above the pink one with a div.

This green light is the div that I'm trying to put above the pink light:

...

I want to filter anything between 2 tags but It skipped the first tag, I don't know what to do.

this is my raw string :

...

I have a large list of tuples where each tuple contains 9 string elements:

...

I have list items in SwiftUI, and I want to move item on top when I set the favorite item with star icon, and I want to repeat it for second item again, is it possible? I know there is example for moving the row, but I do not understand how I will do like that.

Model:

...

There is a similar thread and I like one of the answers there, the one using shell. But it seems to connect to a running instance of mongo.

In my case, there's no running instance, the Mongo db is somewhere else and I can't figure out how to connect to it using this script. I guess i would need a way to add a connection string to an outside MongoDB using an approach similar to the one below.

How to connect Mongodb from Excel

This is the answer

The Shell Approach Pretty much anything that interfaces with the Command Line can be accessed with Shell.

Here's a bare-bones example that connects to a running MongoDB instance and prints a query to the Immediate Window. You'll need to add a reference to the Windows Script Host Object Model.

...

I have a dataset df_1 that looks like this:

date stock A stock B stock C stock D 2020-11-01 4 8 14 30 2020-11-10 0.4 0.6 0.8 0.2 2020-11-30 6 10 20 35 2020-12-01 6 10 20 35 2020-11-31 8 12 25 0.1

And a second dataset, df_2:

date output1 output2 11/2020 stock A,stock B stock C, stock D 12/2020 stock B,stock D stock A,stock C

I want to, for every output in df_2, compute the return for each month. An expected result for this example is df_3:

date output1 output2 11/2020 stock A: 50%, stock B: 25% stock C:42.8% , stock D: 16.6% 12/2020 stock B: 20% ,stock D: 14.3% stock A: 33.3% , stock C: 25%

In the df_3, I do not need the result to be displayed with a comma separator, however, I need later to be able to plot everything in a graph with time on the X axis and stock values (from df_3) on the Y axis.

Update 1: As requested, here is the constructor of my sample dataframes: df1:

...

I've got a class containing a Dictionary like this:

...

This is my current SQL Database.

...

I have a dataframe that contains a string column with text of varied lengths, then I have an array column where each element is a struct with specified word, index, start position and end position in the text column. I want to replace words in the text column, that is in the array.

It looks like this:

...