stack and unstack pandas code example
Example 1: dataframe join in python stack overflow
df1.join(df2)
Example 2: pandas loc for list
df.loc[df['channel'].isin(['sale','fullprice'])]
df1.join(df2)
df.loc[df['channel'].isin(['sale','fullprice'])]