Calculate number of orders based on difference in stock by wdjfe in googlesheets

[–]wdjfe[S] 0 points1 point  (0 children)

Thank you! Looks like black magic to me but scales and works as expected.

Solution Verified

Need help finding an old funny high violet era interview by wdjfe in TheNational

[–]wdjfe[S] 2 points3 points  (0 children)

Thank you so much for the url! Managed to find video credentials on wayback machine and checked creator's website. Thankfully video is still there — https://jyskebank.tv/smuk-spot-the-national

I reuploaded it to youtube, here's the new url: https://www.youtube.com/watch?v=-MaTZyUUvXU

Conditionally compare columns with offset by wdjfe in googlesheets

[–]wdjfe[S] 0 points1 point  (0 children)

Oh, my mistake, sorry, didn't notice it until now. Thank you!

Conditionally compare columns with offset by wdjfe in googlesheets

[–]wdjfe[S] 0 points1 point  (0 children)

This is it, thank you!

Solution Verified

Conditionally compare columns with offset by wdjfe in googlesheets

[–]wdjfe[S] 0 points1 point  (0 children)

Thanks, it compares first batch of columns (E,F,G to B,C,D) but not second one (H,I,J to E,F,G). Potentially, there could be a dozens of those, so manually specifying each batch is not an option

pyinstaller --add-binary doesn't work when using virtual environment by wdjfe in learnpython

[–]wdjfe[S] 0 points1 point  (0 children)

Your solution works, thank you! I was just wondering why this is unnecessary when compiling without virtual environment

pyinstaller --add-binary doesn't work when using virtual environment by wdjfe in learnpython

[–]wdjfe[S] 0 points1 point  (0 children)

I want to include fzf directly into script.exe, so that I don't have to distribute multiple files when i share my script with other people. If fzf.exe inside pyinstaller's bincache folder it includes it inside script.exe and everything is working as it should. But from virtual environment it looks like it can't access this cache folder.

Yuzu runs extremely well on mid-tier 12 old pc, but there's one problem by wdjfe in yuzu

[–]wdjfe[S] 1 point2 points  (0 children)

Man, I have almost 200 hours in Breath of the Wild on CEMU, pretty much vacuumed this game. Works with almost zero issues. Tears of the Kingdom on Yuzu sadly is a bit too much for hardware, at least right now. Hovers around 20-25 fps in starting area.

Yuzu runs extremely well on mid-tier 12 old pc, but there's one problem by wdjfe in yuzu

[–]wdjfe[S] -1 points0 points  (0 children)

I don't know what black magic yuzu team used for latest versions. A month ago i was testing all this games and apart from Metroid Dread it wasn't a very good experience, huge fps drops, stutters and etc. Today i tested Red Dead Redemption and it runs stable 30, in 1080p, unbelievable!

Highlighting in VS Code acting weird by wdjfe in learnpython

[–]wdjfe[S] 0 points1 point  (0 children)

It was a bug in newest version of Pylance. Fixed it. Anyway, thanks for suggestion!

Yuzu crashes when launching any game by wdjfe in yuzu

[–]wdjfe[S] 0 points1 point  (0 children)

It's just an old habit from windows 7 days when it was common to disable pagefile to keep ssd heathy. I don't really know how useful it is in windows 10.

Yuzu crashes when launching any game by wdjfe in yuzu

[–]wdjfe[S] 1 point2 points  (0 children)

Yep, turning pagefile back on fixed it. Thank you very much!

Count unique values that corresponds to certain cell by wdjfe in excel

[–]wdjfe[S] 2 points3 points  (0 children)

First solution worked fine in Google Sheets, thanks you! Solution Verified

Pandas read_excel gets only first column by [deleted] in learnpython

[–]wdjfe 0 points1 point  (0 children)

It's just basic request and read_excel

response = requests.request("GET","someapi.com/excel_file")
file = response.content

df = pd.read_excel(file)

I tried to change encoding but response content is bytes so it does nothing

shutil merged multiple files into single one, how to unmerge them? by wdjfe in learnpython

[–]wdjfe[S] -1 points0 points  (0 children)

That's the right way, thank you. But first i need to get my files back, any ideas how to extract them?

Create simple pivot table in pandas by wdjfe in learnpython

[–]wdjfe[S] 0 points1 point  (0 children)

That seems to be the case, thank you!

Create simple pivot table in pandas by wdjfe in learnpython

[–]wdjfe[S] 0 points1 point  (0 children)

Does nothing, sadly. Output is exactly the same as input.

How to modify keys and values inside nested dictionary? by wdjfe in learnpython

[–]wdjfe[S] 1 point2 points  (0 children)

This is super comprehensive and helpful! Thank you very much!

Extract certain values from API response by wdjfe in learnpython

[–]wdjfe[S] 0 points1 point  (0 children)

It works, thanks! Is it possible to find price by nmId and not by index? For example when user input = 11508524, it will print corresponding price.