# Calculating a discounted price row by row discounted_prices = [] for index, row in df.iterrows(): discounted_prices.append(row['sales'] * (1 - row['discount'])) df['discounted_price'] = discounted_prices