Skip to content

Tag: python

VSCode not using test database for Django tests

I’ve got an issue where VSCode’s test feature uses the production database instead of creating a test database. tests.py I have previously created 1 instance of SomeModel, so if you do SomeModel.objects.all() in the shell, it returns a queryset with that one instance. If I run this test from vscod…

Excel VBA to Python code (Filter function)

I’m new to python. Some help would be great, thanks in advance too. I am trying to get the various average salary based on Units. In Excel, I would do =AVERAGE(FILTER(B:B,A:A=D3)). Where Column B is all the individual salaries and Column A is the various Unit. I have managed to do an array of the differ…

Emoji converter

How can I convert this string in python3 ‘👀🥶’ into this ‘%F0%9F%91%80%F0%9F%A5%B6’ ? Would like to do this with any emojis Answer If percentage encoding is what you are after, urllib module in Python could help. Ref: https://docs.python.org/3/library/urllib.parse.html#urllib.parse.quot…

int unexpectedly turning into string

With the following snippet from a script: I expected the outcome to be: but instead I get: Does anyone know why this is happening and how I can fix it? In case you need it here is SelectTile: Answer You are not assigning the new int value to the original variable. Here’s a fix:

Python making scoreboard based on list input

I am trying to make a scoreboard based on an input which has a list of all rounds played and their result. I have already split this input so that each round of games is one list; in it, one item is one game played. Each game is noted as ‘White Black ResultWhite ResultBlack’. For example, with thr…

get intersection in single column of pandas dataframe

I have a dataframe like this: I want to add a new column ‘intersec’ and get the intersection of the Price column and its shift value. But when I use It doesn’t work, I get the following error: what should I do? My expected result is: Answer shift the price find intersect sample output