合并以下两段代码df_skinhair = filtered_dffiltered_df1 == 护肤&头发reset_indexdrop=True #筛选护肤&头发类df_skinhair = df_skinhairdropnaaxis=1 how=alldf_skinhaircolumns = df_skinhairiloc0df_skinhair = df_skinhairdrop0 1re

df_skinhair = filtered_df[filtered_df[1] == "护肤&头发"].reset_index(drop=True) #筛选护肤&头发类 df_skinhair = df_skinhair.dropna(axis=1, how='all') df_skinhair.columns = df_skinhair.iloc[0] df_skinhair = df_skinhair.drop([0, 1]).reset_index(drop=True) df_skinhair = df_skinhair.drop(df_skinhair.columns[[0]], axis = 1)

df_makeupfrag = filtered_df[filtered_df[1] == "彩妆&香水"].reset_index(drop=True) df_makeupfrag = df_makeupfrag.dropna(axis=1, how='all') df_makeupfrag.columns = df_makeupfrag.iloc[0] df_makeupfrag = df_makeupfrag.drop([0, 1]).reset_index(drop=True) df_makeupfrag = df_makeupfrag.drop(df_makeupfrag.columns[[0]], axis = 1)

combined_df = pd.concat([df_skinhair, df_makeupfrag], axis=0).reset_index(drop=True