📊 Excel to Pandas Cheatsheet

Excel Function Pandas Equivalent
VLOOKUP() merge()
Pivot Table pivot_table()
Filter df[df["col"] == "value"]
SUMIFS groupby() + sum()
Remove Duplicates drop_duplicates()
Sort sort_values(by="col")
IF Formula np.where() or df.apply()