Python Playground

I want to calculate an expanding z-score for some time series data that I have in a DataFrame, but … Read more Pandas - Expanding Z-score Across Multiple Columns

I am importing below df3 dataframe in my excel file and want to grouby only Name and rest dublicate… Read more How To Crate The Group By In Pandas Only In One Level

I've the following column: column 0 10 1 10 2 8 3 8 4 6 5 … Read more Pandas Enumerate Groups In Descending Order

time A1 A1 A2 A2 A2 A3 A3 2017-01 a1 a2 b1 b2 c ..... … Read more Grouping On Identical Column Names In Pandas

I have a pandas dataframe in the following format: id,criteria_1,criteria_2,criteria_3,criteria_4,c… Read more Python Pandas: Groupby First Transform Create Indicator

So I have a pandas dataframe called 'df' and I want to remove the seconds and just have the… Read more Group Index By Minute And Compute Average

I am new to python and i want to understand how the execution takes place in a DataFrame. let's… Read more Understanding The Execution Of Dataframe In Python

I'm attempting to group by two factors in a long (>2M) rows. Background to the data The seco… Read more Groupby To Return Nth Group - Not Row

I have a dataframe like this: col1 col2 0 a 100 1 a 200 2 a 150 3 b 1000 4 … Read more Pandas Groupby Count And Then Conditional Mean

I'm having a hard time trying to do this efficiently. I have some stocks and daily P&L info… Read more Pandas P&l Rollup To The Next Business Day

Continuing from my previous question. This produces a dafatrame with 81 columns and filled with ran… Read more Groupby On Columns With Overlapping Groups

I have a dataframe: Time T201FN1ST2010 T201FN1VT2010 1791 2017-12-26 00:00:00… Read more Groupby Every 2 Hours Data Of A Dataframe

i tried df.groupby('item')['variable'].nunique() and it returns a unique count of e… Read more Filter Dataframe After Groupby And Nunique In Pandas

I am trying to capture the date of the “visit_num==2” of “users” in a new column ('2nd_visit_da… Read more Groupby + Conditional From Another Column To Create New One

I have a dataframe with a Week , Campaign , Placement and Count column. In order to compare counts … Read more Take Difference Between Pivot Table Columns In Python

I know how to compute the groupby mean or std. But now I want to compute both at a time. My code: d… Read more Python Dataframe Groupby Mean And Std

In Python Pandas, I have a DataFrame. I group this DataFrame by a column and want to assign the las… Read more Python Pandas: Assign Last Value Of Dataframe Group To All Entries Of That Group

I've got a datframe that looks like that df1 v w x y 4… Read more Groupby Of Multiple Columns And Assigning Values To Each By Considering Start And End Of Each (pandas)

I'm missing something in the syntax of merging in pandas. I have the following 2 data frames: &… Read more Left Join In Pandas Without The Creation Of Left And Right Variables

I want to apply some custom logic to each individual group obtained by groupby. It is easy to do so… Read more Apply Custom Function To Groupby In Vaex