Add Columns to Pandas Dataframes
Basic Formulas
products['gross_margin'] = products['Retail_Price'] - products['Cost']
products['gross_margin_rate'] = products['gross_margin'] / products['Retail_Price']
If Else Statement Using Lambda
orders['in_promo'] = orders['PromoID'].apply(lambda x: 'N' if x == 'None' else 'Y')