นับสินค้าที่มีคำอธิบายสี "สีขาว" หรือมีลักษณะชื่อ "ร้อน"
Count the products that have the color description "white" or have the characteristic name "hot".
df_characteristics = pd.DataFrame(columns=['characteristic_id', 'characteristic_name'])
df_ref_colors = pd.DataFrame(columns=['color_code', 'color_description'])
df_products = pd.DataFrame(columns=['product_id', 'color_code'])
df_product_characteristics = pd.DataFrame(columns=['product_id', 'characteristic_id'])
df_products[(df_products['color_code'].isin(df_ref_colors[df_ref_colors['color_description'] == 'white']['color_code'])) | (df_products['product_id'].isin(df_product_characteristics[df_product_characteristics['characteristic_id'].isin(df_characteristics[df_characteristics['characteristic_name'] == 'hot']['characteristic_id'])]['product_id']))].shape[0]