擅长:python、mysql、java
<p>假设您的数据帧为<code>df</code></p>
<pre><code>data = df.iloc[:,2:]
predf = df.iloc[:,:2]
colnums = [i for i in range(0,len(data.columns),3)]
newdf = pd.DataFrame()
for idx,val in enumerate(colnums):
name = data.columns[idx].split("-")[0]
colname = f"{name}-q{idx+1}"
newdf[colname] = data.iloc[:,val:(val+2)].mean(axis=1)
output = pd.concat([predf,newdf],axis=1)
</code></pre>