擅长:python、mysql、java
<p>可能有一种更简洁的方法来实现您的结果,但这里有一种非常明确的多步骤方法</p>
<pre><code>#get each column
post_op=df[df['prom_completed_date']>0].groupby('uuid').mean()['prom_score']
pre_op=df[df['prom_completed_date']<0].groupby('uuid').mean()['prom_score']
difference=post_op-pre_op
#concat them together
df1=pd.concat([post_op,pre_op,difference], axis=1)
#rename the columns
df1.columns=['postop_avgPROM','preop_avgPROM','difference']
df1
postop_avgPROM preop_avgPROM difference
uuid
0068edf090ceaf1356 48.3 22.5 25.8
009eft67eaa133cea4 67.9 18.4 49.5
</code></pre>