i have data in a dataframe such as the following columns: week, SITE, LAL, SITE, LAL. I need to assign a suffix to the col name == ‘SITE’ such that the final df will look like: week, SITE_1, LAL, SITE_2, LAL. Thank you, dataframe example: week SITE LAL SITE LAL 0 1 BARTON CHAPEL 1.1… Read More Add Suffix to Dataframe with Specific Repeating Column Name
i have a simple ui created with pyqt5 it loads a file, let you choose a outputfolder and creats a new txt file with additonals information. the string of the loaded file is written to self.inputs.filename.text() it looks like "C:/User/Folder/File.txt" later in the application i write into a new file in a specific location. new_txt… Read More Cutting Strings Pyhton
I am running into a problem and no clue what to do, as I am new to programming. The situation is as follows, we extracted data from a .txt file with names, children etc. and extracted it into a dictionary. The dictionary is accessed with the name as the key, e.g: # access a single… Read More Occurence of name in dictionary
My question is somewhat similar to subtracting-two-columns-named-in-certain-pattern I’m having trouble performing operations on columns that share the same root substring, without a loop. Basically I want to calculate a percentage change using columns that end with ‘_PY’ with another column that shares the same name except for the suffix. What’s a possible one line solution,… Read More Find percent difference between two columns, that share same root name, but differ in suffix
I have following error while i try to reach PizzaDetailView on template: AttributeError at /pizza/6/ type object ‘PizzaMenu’ has no attribute ‘_default_manager’. Where is the problem? models.py class PizzaMenu(models.Model): name = models.CharField(max_length=30) description = models.TextField() ingredients = models.CharField(max_length=100) price = models.DecimalField(max_digits=4, decimal_places=2) def __str__(self): return self.name class Meta: ordering = ["price"] views.py from django.views.generic import… Read More type object 'PizzaMenu' has no attribute '_default_manager'
My dataframe is this : position labels [58.0, 71.0] ind [137.0, 147.0] pro [170.0, 191.0] pro [nan, nan] NaN [nan, nan] NaN [36.0, 57.0] pro [67.0, 73.0] ind [86.0, 93.0] tar [0.0, 8.0] ind The wanted output is this: ind.position pro.position tar.position [58.0, 71.0] [137.0, 147.0] [170.0, 191.0] [36.0, 57.0] [67.0, 73.0] [86.0, 93.0] [0.0,… Read More Pandas : Create columns based on values of another column if string value from 3rd column
I’m trying to build and tag a container image based on the git branch I’m building. ADO has two options for the branch name: Build.SourceBranch eg. refs/heads/rc/1.0.0 or Build.SourceBranchName eg. 1.0.0 However I want to tag my image using rc1.0.0, and I figured that should be possible by initially in my yml defining a variable… Read More Using 'replace' expression in Azure Devops pipeline
This might be very simple question, but here’s my dataframe: id text position labels 0 39088 skin melanoma [58.0, 71.0] indication 1 39088 proteinase [137.0, 147.0] protein 2 39088 plasminogen activator [170.0, 191.0] protein 3 39088 NaN [nan, nan] NaN 4 39088 NaN [nan, nan] NaN 5 39088 proteinase substrates [36.0, 57.0] protein 6 39088… Read More Pandas : Create new column based on text value of another column
I want to have my x-axis show the scale with an added "m2" at the end of each axis text using the scales::label_number() function. Reproducible code: tibble(x = 1:10, y = 1:10) |> ggplot(aes(x, y)) + scale_x_continuous(label = scales::label_number(suffix = "m^2")) which gives me "5m^2" (for example) on the x-axis, whereas I want it to… Read More Adding a suffix that includes superscript text to axis text in ggplot
I have a pandas dataframe with the following structure: Frame P_1_x P_1_y P_2_x P_2_y … P_N_x P_N_y 0 1 9 6 2 4 3 And I would like to transform it to: x y P_1 1 9 P_2 6 2 . . . P_N 4 3 Is there any efficient way to do it with… Read More How to pivot a data frame with suffixed columns?