背景:
原df
df1 = df.pivot_table(index=["user_id"], columns=["question_id"], values=["score","duration"]).fillna(0)
print(df1)
透视之后
目标透视图:
solution:
c1=df['question_id'].drop_duplicates()
c2=['score','duration']
index=pd.MultiIndex.from_product([c1,c2])
df1.columns=index
print(df1)
知识点:
创建多重索引的方法
pd.MultiIndex.from_product() pd.MultiIndex.from_arrays() pd.MultiIndex.from_tuples() pd.MultiIndex.from_frame()