Data Wrangling
Importing Data Select, Drop & Rename Filter, Sort & Sample Add Columns Cleaning Data Dates & Time Join Data Aggregate & Transform
Data Analysis
Exploring Data Plotting Continuous Variables Plotting Discrete Variables
Machine Learning
Data Preparation Linear Models
Other Tutorials & Content
Learn Python for Data Science Learn Alteryx Blog



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')