shark | Development in Shark

Say I have a dataframe:

I'm trying to merge together two Pandas data frames but not able to get the desired result. One data frame has been transposed, and I think for this reason has a header row containing the column indexes. The other has a header row with column names, however each have the same number of columns.

Data Frame 1 (DF1):

i'm confused with the following condition, simply i want to have arrayformula or maybe a custom-formula to increment number in a way bound by specific condition based on value in other column, put it simply :

if the group doesn't change and sub-group is different increment number by 1
else if the group doesn't change and sub-group is doesn't change (same) hold value by previous
else if the group change regardless sub-group value reset number back to 1

for ilustration

** notes Number is the result that i want, in example i fill it manually

UPDATE (dummy file link) :
https://docs.google.com/spreadsheets/d/1DAPf-DvWz50_DJ0IqAoSHbfEnfg_mN1lNXHcCjkj27M/edit#gid=0

Using bootstrap's navbar, I'm only using the dropdown toggler icon on the right. I want a background with a width that covers only the right portion and not the entire width. Any insight would be appreciated.

Attempts 1 and 2:

Trying to get:

when I select a rating, it will stay "lit up" but when i duplicate it and give it a different class, when I select a rating on the second copy, it changes the first copy and the second copy doesn't get updated. its hard to explain what happens in text and its better to run it and see it for yourself

I'm trying to change collision for my game and I saw pygame has mask collision so I tried to use it, but collision is registered all the time and I dont know how to fix it

Here's my code

Class Enemy for fishes spawning in from both sides of the screen and Respawning after hit

I know there is a few questions on SO regarding the conversion of JSON file to a pandas df but nothing is working. Specifically, the JSON requests the current days information. I'm trying to return the tabular structure that corresponds with Data but I'm only getting the first dict object.

I'll list the current attempts and the resulting outputs below.

I have a script that reads the links that are in excel file, it opens each link fine, but when it encounters an error in automatic it marks error and closes the script. How can I make the script continue to open the links without stopping on the page that has an error?

I accept any suggestion or improvement for script in general. It's just a part of my code.

i'm trying to get names of products but when it gets to the sponsored products it returns None. Here's my code;