Say I have a dataframe that records temperature measurements for various sensors: import pandas as pd df = pd.DataFrame({‘sensor’: [‘A’, ‘C’, ‘A’, ‘C’, ‘B’, ‘B’, ‘C’, ‘A’, ‘A’, ‘A’], ‘temperature’: [4.8, 12.5, 25.1, 16.9, 20.4, 15.7, 7.7, 5.5, 27.4, 17.7]}) I would like to add a column max_prev_temp that will show the previous maximum temperature… Read More Get max value in previous rows for matching rows
I would like to perform a rolling mean while the mean excludes duplicates found in another column. Let me provide an example dataframe: Date Warehose Value 10-01-1998 London 10 13-01-1998 London 13 15-01-1998 New York 37 12-02-1998 London 21 20-02-1998 New York 39 21-02-1998 New York 17 In this example, let’s say I like to… Read More Pandas: Rolling mean using only the last update based on another column
Here is my dataset Date,p1Close,p2Close, spread, movingAverage 2022-02-28,5,10,2,NaN 2022-03-01,2,6,3,2.5 2022-03-02,4,8,2,2,5 2022-03-03,2,8,4,3 I am trying to create a new column in pandas data frame that is equal to the standard deviation between ‘spread’ from previous row and current row. df[‘standardDeviation’] = statistics.stdev(df[‘spread’], df[‘spread’].shift(1)) I keep getting this error: File "/usr/lib/python3.9/statistics.py", line 797, in stdev var =… Read More Calculate stdev for a row and previous row in pandas without series error
I have a table like this import pandas as pd import numpy as np df = pd.DataFrame.from_dict({‘date’:[1,2,3,4,5,6,7,8,9,10] ,’high’:[10,9,8,8,7,6,7,8,9,10],’low’:[9,7,6,5,2,1,2,1,8,9],’stock’:[‘A’]*5 + [‘B’]*5}) date high low stock 1 10 9 A 2 9 7 A 3 8 6 A 4 8 5 A 5 7 2 A 6 6 1 B 7 7 2 B 8 8 1… Read More How to effectively loop within groups in pandas?
I have the following DataFrame: match_date player_id player__match_count__won 1 2012-09-25 10:00:00 23640 1 18 2012-09-25 10:00:00 17969 0 2 2012-09-26 16:00:00 17268 1 19 2012-09-26 16:00:00 11247 0 0 2012-09-25 00:00:00 23640 1 17 2012-09-25 00:00:00 17268 0 3 2012-09-29 00:00:00 12202 1 20 2012-09-29 00:00:00 23640 0 5 2012-10-02 14:20:00 9241 1 22 2012-10-02… Read More Sum of rolling groupby based on date not returning expected results