import pandas as pd
def rearrange_products_table(products: pd. DataFrame ) -> pd. DataFrame :
df = products.melt(id_vars='product_id', var_name='store', value_name='price')
df = df.dropna(axis=0)
return df
import pandas as pd
def rearrange_products_table(products: pd.DataFrame) -> pd.DataFrame:
# set_index 会按照[product_id]进行分行(大行包小行)
df = products.set_index(['product_id']).stack()
# 与 set_index 对照看
df = df.reset_index()
# 重新命名
df.columns = ['product_id','store','price']
return df