Given a data frame structured as follows: df = pd.DataFrame({ ‘DATE’ : [1,2,3,4,5], ‘Q24’ : [23.28, 28.81, 29.32, 29.8, 30.25], ‘J24’ : [24.22, 24.89, 25.54, 26.15, 26.73], ‘F24’ : [22.34, 32.73, 33.1, 33.45, 33.77] }) I would like to create a dictionary in which all keys are tuples containing the products of values in df[‘DATES’]… Read More Dictionary from data frame. Values assigned to tuple keys derived from column, row products

I’m working up some data where I’ve looked at data and created a flag column because I want to provide a column (I’ve called it result although this is my aim) where it is empty top_tier is empty or returns the parent region. I’ve tried ffill and apply but I can’t get the result. Update:… Read More An apply function in pandas to create a column based on conditions in a column

Let say I have below dataframe import pandas as pd Dat = pd.DataFrame({‘a’ : [1,2], ‘b’ : [3,4]}) def MyFunc(x, y) : return x + y ** (.5) Now I want to apply above custom function to elements of each of the columns of Dat. Is there any function/method to achieve this? I have gone… Read More Apply a custom function to each column of a pandas dataframe

I’m trying to find the sum of the variable "candle" in the code below, but not sure how to write the code. I know someone is going to suggest using NumPy, but I don’t even know where to begin with that. for index, row in df.iterrows(): openPrice = row[‘open’] closePrice = row[‘close’] if closePrice -… Read More Iterating Pandas DF, Finding Sum After Loop

I have below data frame import pandas as pd dat1 = pd.DataFrame({‘x’ : [1,2,4], ‘y’ : [3,4,10]}).set_axis([‘a’, ‘b’, ‘c’], axis = 0) Now I want chance values of certain cells by calling those cells by name. I tried below dat1.iloc[‘b’][‘y’] = 999 However this generates error as below, >>> dat1.iloc[‘b’][‘y’] = 999 Traceback (most recent… Read More Changing cell values of a pandas dataframe

I have a data frame like this print(df) Hostname Slot Port Reserved Server1 1 1 0 Server1 1 2 0 Server1 2 3 1 Server2 2 1 1 Server2 2 2 0 Server2 2 3 1 Server3 1 1 0 Server3 2 2 0 Server3 3 3 1 I need to sum Reserved column by… Read More how do you add values in pandas dataframe column based on group values

I have a list of strings that I’d like to concatenate to every value in a column. Basically if there are 20 values in the column and 5 in the list it would now have 100 rows. The list of tenant IDs comes a thousand lines up in the code, but it’s basically every unique… Read More Concatenate every value in list to every value in column

My team uses a Ç (ALT 0199) as a separator in their CSV files. I’m trying to replicate using this in Pandas, but not having any luck. Any guidance is appreciated as I’m new to Pandas results.to_csv(‘filename.csv’, encoding=’latin1′, sep=’Ç’) SyntaxError: (unicode error) ‘utf-8’ can’t decode byte 0xc7 >Solution : The fact that you get a… Read More pandas to_csv using latin script Ç as separator?

There is a dataset in this form: company_url Name Revenue mackter.com Mack Sander NaN nientact.com Neient Dan 321 ventienty.com Richard NaN So, my task here is to remove all the rows where string ‘tac’, ‘bux’ or ‘mvy’ is coming in either ‘company_url’ or ‘Name’ column…. As you can see, ‘tac’ is present in nientact.com ,… Read More Unable to Filter based on Substring in Pandas

I am working in Python 3.11.1. I have data like these stored in a Pandas Dataframe: ID Position Select 1 A 0 2 B 1 2 C 0 3 B 0 3 C 0 4 A 1 5 A 0 Where some ID’s are recorded in multiple rows, but others only appear in a single… Read More Python Pandas – How to Keep All Observations By Selector Variable When Data are in Long Form