steam | Installer for the Steam software distribution service | Video Game library

original data frame:

Date Detail 31/03/22 I watch Netflix at home with my family 4 hours 01/04/22 I walk to the market for 3km and I spent 11.54 dollar 02/04/22 my dog bite me, I go to hospital, spend 29.99 dollar 03/04/22 I bought a game on steam 7 games spen 19.23 dollar

result data frame:

Date Detail Cost 31/03/22 I watch Netflix at home with my family 4 hours 0 01/04/22 I walk to the market for 3km and I spent 11.54 dollar 11.54 02/04/22 my dog bite me, I go to hospital, spend 29.99 dollar 29.99 03/04/22 I bought a game on steam 7 games spen 19.23 dollar 19.23

Describe my question:

• If Detail Column does not contain specific string which is begin with sp.. and end with dollar then value in Cost col equal zero.

• If Detail Column does contain specific string which is begin with sp.. and end with dollar, then value in Cost col equal value in the middle of specific string which is begin with sp.. and end with dollar.

I try to use regex but it's got first int that contain in the col like

| 01/04/22 | I walk to the market for 3km and I spent 11.54 dollar| 3 |

...

This is a reporting presentation exercise...

I am looking for the magic to change the colour of the cell without changing the contents of the cell.

I have a type of crosstab table, which has the ROWS individual CustomerIDs, and the COLs as months.

PRESENTATION TABLE

CustomerID Jan 22 Feb 22 Mar 22 0001 $100 $50 $10000 0002 $1000 $1000 $200 .... .... ...

And in a separate table, I have some data which I want to use in a conditional formatting type of way.

LOOKUP TABLE

CustomerID Period Label 0001 Feb 22 Applied 0001 Mar 22 Pending 0006 Mar 22 Approved 0009 Dec 23 Pending

Let's say that if the CustomerID and Period in the data table has the label "Applied" then I want that cell in the top table, where CustomerID and Period intersect, to be coloured RED. If it's "Passed", I want it to be coloured green, and so on.

The periods are dates data types. The tables are excel tables.

The dollar value in the cell has nothing to do with it.

I've seen some techniques where a combination of Named ranges and confditional formatting are used, but I'm stumped.

I can put the dollar values in the correct cell by putting a helper column into my source data (the second table) and then doing an xlookup on the combination of the row and col headers, against that helper column.

But then I run out of steam.

END RESULT

CustomerID Jan 22 Feb 22 Mar 22 0001 RED BLUE 0002 .... .... ... ...

I'm trying to get the game list from the Steam API. I know that in this link there is a page with all the games/apps in a JSON format: https://api.steampowered.com/ISteamApps/GetAppList/v2/ The thing is that I don't know how to get that JSON inside the app. What I tried is downloading the whole website (html) and looking in the correct html tag for the string content that is the JSON, but I guess that there is a better way to get the content. Also, doing that way I can only make it work in web, when I also want it to work in app version.

Any idea on how to get the content of the page?

...

I have a page where circles randomly appear in a certain place. When you click on the circle, it disappears.

So, I have another circle-smoke, and I want that when the clicked circle disappears, this circle with the circle-smoke class appears in its place, and also dissolves in just a second.

I tried to add new element creation to my click function, but it didn't work

...

I would like to count the files in folder with Excel VBA.

The speed very important for me now, so first I list all files (from folders and subfolders) to "A" column, and I would like to go thru on all lines and count how many files in the folder.

My list from "A" column:

...

I'm trying to download an mp3 file on the click of a button, it downloads, but the file it downloads is not correct, it's a WAY smaller file than the original one (25 bytes), while the original one is 10MB.

It's my first time working with downloading stuff so I'm pretty clueless.

Here's some code:

JS function:

...

Good evening,

I have a dataframe like this:

Corp TDS VVT SOAR Steam 3429.0 450 Steam 1365 Bliz 3425.1 11 Bliz 353.3 34 Tesla 18 Tesla 2243.3 32 OYV 15 OYV 16

What is the best way to replace emptiness in the columns with the same value from another row if the Corp value is equal? The result should be like this:

Corp TDS VVT SOAR Steam 3429.0 450 Steam 3429.0 1365 Bliz 3425.1 34 11 Bliz 353.3 34 11 Tesla 2243.3 18 Tesla 2243.3 32 OYV 15 16 OYV 15 16

Thanks for all help!

...

I have a dataframe with 11 000k rows. There are multiple columns but I am interested only in 2 of them: TagName and Samples_Value. One tag can repeat itself multiple times among rows. I want to calculate the average value for each tag and create a new dataframe with the average value for each tag. I don't really know how to walk through rows and how to calculate the average. Any help will be highly appreciated. Thank you!

...

I have a JSON data saved in the database. I want to put this data in a while loop and get everything in the line, but I can't. How can I do it?

...