given this dataframe how can I find where if rows are grouped by first name and last name, the row with type as 'CA' get its Value column set to the r...

I have a pandas dataframe: d = {'col1': ['Date1', 'Date1', 'Date1', 'Date2', 'Date2', 'Date2', 'Date3', 'Date3', 'Date3', 'Date4', 'Date4', 'Date4'], ...

I have scoured this forum, and have yet to find a solution to my problem. I am using pandas dataframes, and I need to order this column, which of type...

I want to reshape my dataset from this: Date Item A B 1 1 a1 b1 1 2 a2 b2 1 3 a3 b3 to this Date Letter Item 1 Item 2 Item 3 1...

I would like to convert my dataframe, df1, to the format shown in df2. How can I do this in an efficient manner without hard-coding & while using R li...

I am trying to apply case_when to selected columns in dataframe_1 based on a list of case_when functions in another dataframe. For example, using the ...

Lets say I have this df: import pandas as pd import numpy as np # Sample MultiIndex DataFrame index = pd.date_range('2023-01-01', '2023-01-05', freq=...

I have two dataframes that look like the following library(dplyr) State = c('AK','AL','AR','AZ') Perc = c(0.0023, 0.0034, 0.0043, 0.065) df1 .frame(...

I have a dataframe as follow: Index Value Condition1 Condition2 1 1 True False 2 5 False False 3 3 False True 4 3 False False 5 3 True...

I would like to compute a distance distance between all elements of two series: import pandas as pd a = pd.Series([1,2,3], ['a', 'b', 'c'] ) b = pd.Se...

I made this code that allows me to create a table in an excel file. Only I wanted to add at the beginning of the column a string and then afterwards a...

I created a document-term matrix from multiple txt files. The result is a dataframe with each column being a word, and each row being a file (my final...

Certainly! Here is a draft of your Stack Overflow question with proper code formatting: Title: How to calculate time between sessions for each ID in a...

Difficult to explain but hope this code will help df "table_mtcars" = df ) If you run the two lines above it gets to the result I want, a list that co...

This is the dataset im using and some code. I have been working on an ML project and while I was trying to train using random forest classification, i...

I have two Data Frames df and df1, based on the date range from df i want to sum the Distance column in df1 from io import StringIO data = """IGN,Ex...

I have dataframe with column that contains lists with id of objects and objects alias in other dataframe. I want to replace id in column with lists in...

I have tried the following script to call jira api to get the jira issues. JQL = 'project = DEMO AND status IN ("To Do", "In Progress") ORDER BY issue...

I have the following sample python dataframe below: Type Value A sesame B A C tea A bun The code to create the table is below: i...

I am trying to add a row to the bottom of a grouped by data frame in Pandas, using following code import pandas as pd import matplotlib.pyplot as plt ...

I have a dataframe with rows like this, I want to go through the rows and see if there is " ; " in any of the column values if there is I want to spli...

For instance, I create a pandas dataframe: data = [['nick', 3, '2023/11/22 10:05:00', 'A'], ['tom', 3, '2023/11/22 9:25:00','A'], ['juli', 2, '2023/11...

Given a numpy array such as the one below, is it possible to use vectorization to return the associated value in column HHt without using a for loop? ...

I have the following polars DF in Python df = pl.DataFrame({ "user_movies": [[7064, 7153, 78009], [6, 7, 1042], [99, 110, 3927], [2, 11, 152081], ...

I see that in dplyr the function cur_data() has been deprecated in favor of pick(). However, I'm confused about how to use pick() when trying to add r...